APPS.PQH_RST_SHD dependencies on PQH_RULE_SETS_TL

Line 372: UPDATE pqh_rule_sets_tl

368: --
369: -- update the tl table
370: --
371: if sql%found then
372: UPDATE pqh_rule_sets_tl
373: SET rule_set_name = p_rule_set_name,
374: description = p_description,
375: last_updated_by = l_last_updated_by,
376: last_update_date = l_last_update_date,

Line 386: insert into pqh_rule_sets_tl(

382: If (sql%notfound) then
383: -- no row in TL table so insert row
384:
385: --
386: insert into pqh_rule_sets_tl(
387: rule_set_id,
388: rule_set_name,
389: description,
390: language,

Line 412: from pqh_rule_sets_tl rtl

408: l_last_update_login
409: from fnd_languages l
410: where l.installed_flag in ('I','B')
411: and not exists (select null
412: from pqh_rule_sets_tl rtl
413: where rtl.rule_set_id = l_rule_set_id
414: and rtl.language = l.language_code );
415: --
416: --

Line 465: insert into pqh_rule_sets_tl(

461: l_last_update_login,
462: 'Y'
463: );
464:
465: insert into pqh_rule_sets_tl(
466: rule_set_id,
467: rule_set_name,
468: description,
469: language,

Line 491: from pqh_rule_sets_tl rtl

487: l_last_update_login
488: from fnd_languages l
489: where l.installed_flag in ('I','B')
490: and not exists (select null
491: from pqh_rule_sets_tl rtl
492: where rtl.rule_set_id = l_rule_set_id
493: and rtl.language = l.language_code );
494: --
495: --

Line 552: delete from PQH_RULE_SETS_TL T

548:
549: Procedure ADD_LANGUAGE
550: is
551: begin
552: delete from PQH_RULE_SETS_TL T
553: where not exists
554: (select NULL
555: from PQH_RULE_SETS B
556: where B.RULE_SET_ID = T.RULE_SET_ID

Line 559: update PQH_RULE_SETS_TL T set (

555: from PQH_RULE_SETS B
556: where B.RULE_SET_ID = T.RULE_SET_ID
557: );
558:
559: update PQH_RULE_SETS_TL T set (
560: RULE_SET_NAME
561: ) = (select
562: B.RULE_SET_NAME
563: from PQH_RULE_SETS_TL B

Line 563: from PQH_RULE_SETS_TL B

559: update PQH_RULE_SETS_TL T set (
560: RULE_SET_NAME
561: ) = (select
562: B.RULE_SET_NAME
563: from PQH_RULE_SETS_TL B
564: where B.RULE_SET_ID = T.RULE_SET_ID
565: and B.LANGUAGE = T.SOURCE_LANG)
566: where (
567: T.RULE_SET_ID,

Line 572: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT

568: T.LANGUAGE
569: ) in (select
570: SUBT.RULE_SET_ID,
571: SUBT.LANGUAGE
572: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT
573: where SUBB.RULE_SET_ID = SUBT.RULE_SET_ID
574: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
575: and (SUBB.RULE_SET_NAME <> SUBT.RULE_SET_NAME
576: ));

Line 578: insert into PQH_RULE_SETS_TL (

574: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
575: and (SUBB.RULE_SET_NAME <> SUBT.RULE_SET_NAME
576: ));
577:
578: insert into PQH_RULE_SETS_TL (
579: RULE_SET_ID,
580: RULE_SET_NAME,
581: LAST_UPDATE_DATE,
582: CREATION_DATE,

Line 598: from PQH_RULE_SETS_TL B, FND_LANGUAGES L

594: B.LAST_UPDATE_LOGIN,
595: B.LAST_UPDATED_BY,
596: L.LANGUAGE_CODE,
597: B.SOURCE_LANG
598: from PQH_RULE_SETS_TL B, FND_LANGUAGES L
599: where L.INSTALLED_FLAG in ('I', 'B')
600: and B.LANGUAGE = userenv('LANG')
601: and not exists
602: (select NULL

Line 603: from PQH_RULE_SETS_TL T

599: where L.INSTALLED_FLAG in ('I', 'B')
600: and B.LANGUAGE = userenv('LANG')
601: and not exists
602: (select NULL
603: from PQH_RULE_SETS_TL T
604: where T.RULE_SET_ID = B.RULE_SET_ID
605: and T.LANGUAGE = L.LANGUAGE_CODE);
606: end ADD_LANGUAGE;
607: -- --