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 466: insert into pqh_rule_sets_tl(

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

Line 492: from pqh_rule_sets_tl rtl

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

Line 553: delete from PQH_RULE_SETS_TL T

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

Line 560: update PQH_RULE_SETS_TL T set (

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

Line 564: from PQH_RULE_SETS_TL B

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

Line 573: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT

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

Line 579: insert into PQH_RULE_SETS_TL (

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

Line 599: from PQH_RULE_SETS_TL B, FND_LANGUAGES L

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

Line 604: from PQH_RULE_SETS_TL T

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