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 520: insert into pqh_templates_tl(

516: p_short_name
517: );
518: --
519:
520: insert into pqh_templates_tl(
521: template_id,
522: template_name,
523: language,
524: source_lang,

Line 544: from pqh_templates_tl ttl

540: l_last_update_login
541: from fnd_languages l
542: where l.installed_flag in ('I','B')
543: and not exists (select null
544: from pqh_templates_tl ttl
545: where ttl.template_id = l_template_id
546: and ttl.language = l.language_code );
547: --
548: --

Line 563: delete from PQH_TEMPLATES_TL T

559: --
560: Procedure ADD_LANGUAGE
561: is
562: begin
563: delete from PQH_TEMPLATES_TL T
564: where not exists
565: (select NULL
566: from PQH_TEMPLATES B
567: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 570: update PQH_TEMPLATES_TL T set (

566: from PQH_TEMPLATES B
567: where B.TEMPLATE_ID = T.TEMPLATE_ID
568: );
569:
570: update PQH_TEMPLATES_TL T set (
571: TEMPLATE_NAME
572: ) = (select
573: B.TEMPLATE_NAME
574: from PQH_TEMPLATES_TL B

Line 574: from PQH_TEMPLATES_TL B

570: update PQH_TEMPLATES_TL T set (
571: TEMPLATE_NAME
572: ) = (select
573: B.TEMPLATE_NAME
574: from PQH_TEMPLATES_TL B
575: where B.TEMPLATE_ID = T.TEMPLATE_ID
576: and B.LANGUAGE = T.SOURCE_LANG)
577: where (
578: T.TEMPLATE_ID,

Line 583: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT

579: T.LANGUAGE
580: ) in (select
581: SUBT.TEMPLATE_ID,
582: SUBT.LANGUAGE
583: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT
584: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
585: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
586: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
587: ));

Line 589: insert into PQH_TEMPLATES_TL (

585: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
586: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
587: ));
588:
589: insert into PQH_TEMPLATES_TL (
590: TEMPLATE_ID,
591: TEMPLATE_NAME,
592: LAST_UPDATE_DATE,
593: CREATION_DATE,

Line 609: from PQH_TEMPLATES_TL B, FND_LANGUAGES L

605: B.LAST_UPDATE_LOGIN,
606: B.LAST_UPDATED_BY,
607: L.LANGUAGE_CODE,
608: B.SOURCE_LANG
609: from PQH_TEMPLATES_TL B, FND_LANGUAGES L
610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL

Line 614: from PQH_TEMPLATES_TL T

610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL
614: from PQH_TEMPLATES_TL T
615: where T.TEMPLATE_ID = B.TEMPLATE_ID
616: and T.LANGUAGE = L.LANGUAGE_CODE);
617: end ADD_LANGUAGE;
618: -- --