APPS.PQH_TEM_SHD dependencies on PQH_TEMPLATES_TL

Line 422: UPDATE pqh_templates_tl

418: --
419: -- update the tl table
420: if (sql%found) then
421: --
422: UPDATE pqh_templates_tl
423: SET template_name = p_template_name,
424: last_updated_by = l_last_updated_by,
425: last_update_date = l_last_update_date,
426: last_update_login = l_last_update_login,

Line 435: insert into pqh_templates_tl(

431: If (sql%notfound) then
432: -- no row in TL table so insert row
433:
434: --
435: insert into pqh_templates_tl(
436: template_id,
437: template_name,
438: language,
439: source_lang,

Line 459: from pqh_templates_tl ttl

455: l_last_update_login
456: from fnd_languages l
457: where l.installed_flag in ('I','B')
458: and not exists (select null
459: from pqh_templates_tl ttl
460: where ttl.template_id = l_template_id
461: and ttl.language = l.language_code );
462: --
463: --

Line 536: insert into pqh_templates_tl(

532: p_short_name
533: );
534: --
535:
536: insert into pqh_templates_tl(
537: template_id,
538: template_name,
539: language,
540: source_lang,

Line 560: from pqh_templates_tl ttl

556: l_last_update_login
557: from fnd_languages l
558: where l.installed_flag in ('I','B')
559: and not exists (select null
560: from pqh_templates_tl ttl
561: where ttl.template_id = l_template_id
562: and ttl.language = l.language_code );
563: --
564: --

Line 579: delete from PQH_TEMPLATES_TL T

575: --
576: Procedure ADD_LANGUAGE
577: is
578: begin
579: delete from PQH_TEMPLATES_TL T
580: where not exists
581: (select NULL
582: from PQH_TEMPLATES B
583: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 586: update PQH_TEMPLATES_TL T set (

582: from PQH_TEMPLATES B
583: where B.TEMPLATE_ID = T.TEMPLATE_ID
584: );
585:
586: update PQH_TEMPLATES_TL T set (
587: TEMPLATE_NAME
588: ) = (select
589: B.TEMPLATE_NAME
590: from PQH_TEMPLATES_TL B

Line 590: from PQH_TEMPLATES_TL B

586: update PQH_TEMPLATES_TL T set (
587: TEMPLATE_NAME
588: ) = (select
589: B.TEMPLATE_NAME
590: from PQH_TEMPLATES_TL B
591: where B.TEMPLATE_ID = T.TEMPLATE_ID
592: and B.LANGUAGE = T.SOURCE_LANG)
593: where (
594: T.TEMPLATE_ID,

Line 599: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT

595: T.LANGUAGE
596: ) in (select
597: SUBT.TEMPLATE_ID,
598: SUBT.LANGUAGE
599: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT
600: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
603: ));

Line 605: insert into PQH_TEMPLATES_TL (

601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
603: ));
604:
605: insert into PQH_TEMPLATES_TL (
606: TEMPLATE_ID,
607: TEMPLATE_NAME,
608: LAST_UPDATE_DATE,
609: CREATION_DATE,

Line 625: from PQH_TEMPLATES_TL B, FND_LANGUAGES L

621: B.LAST_UPDATE_LOGIN,
622: B.LAST_UPDATED_BY,
623: L.LANGUAGE_CODE,
624: B.SOURCE_LANG
625: from PQH_TEMPLATES_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL

Line 630: from PQH_TEMPLATES_TL T

626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL
630: from PQH_TEMPLATES_TL T
631: where T.TEMPLATE_ID = B.TEMPLATE_ID
632: and T.LANGUAGE = L.LANGUAGE_CODE);
633: end ADD_LANGUAGE;
634: -- --