APPS.PQH_TCT_SHD dependencies on PQH_TRANSACTION_CATEGORIES_TL

Line 528: UPDATE pqh_transaction_categories_tl

524: -- update the tl table
525: --
526: if (sql%found) then
527:
528: UPDATE pqh_transaction_categories_tl
529: SET name = p_name,
530: last_updated_by = l_last_updated_by,
531: last_update_date = l_last_update_date,
532: last_update_login = l_last_update_login,

Line 541: insert into pqh_transaction_categories_tl

537: If (sql%notfound) then
538: -- no row in TL table so insert row
539:
540: --
541: insert into pqh_transaction_categories_tl
542: ( transaction_category_id,
543: name,
544: language,
545: source_lang,

Line 565: from pqh_transaction_categories_tl ctl

561: l_last_update_login
562: from fnd_languages l
563: where l.installed_flag in ('I','B')
564: and not exists (select null
565: from pqh_transaction_categories_tl ctl
566: where ctl.transaction_category_id = l_transaction_category_id
567: and ctl.language = l.language_code );
568: --
569: End if;

Line 661: insert into pqh_transaction_categories_tl

657:
658: --
659: -- Insert row into the tl table
660: --
661: insert into pqh_transaction_categories_tl
662: ( transaction_category_id,
663: name,
664: language,
665: source_lang,

Line 685: from pqh_transaction_categories_tl ctl

681: l_last_update_login
682: from fnd_languages l
683: where l.installed_flag in ('I','B')
684: and not exists (select null
685: from pqh_transaction_categories_tl ctl
686: where ctl.transaction_category_id = l_transaction_category_id
687: and ctl.language = l.language_code );
688: --
689: --

Line 705: delete from PQH_TRANSACTION_CATEGORIES_TL T

701: --
702: Procedure ADD_LANGUAGE
703: is
704: begin
705: delete from PQH_TRANSACTION_CATEGORIES_TL T
706: where not exists
707: (select NULL
708: from PQH_TRANSACTION_CATEGORIES B
709: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID

Line 712: update PQH_TRANSACTION_CATEGORIES_TL T set (

708: from PQH_TRANSACTION_CATEGORIES B
709: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
710: );
711:
712: update PQH_TRANSACTION_CATEGORIES_TL T set (
713: NAME
714: ) = (select
715: B.NAME
716: from PQH_TRANSACTION_CATEGORIES_TL B

Line 716: from PQH_TRANSACTION_CATEGORIES_TL B

712: update PQH_TRANSACTION_CATEGORIES_TL T set (
713: NAME
714: ) = (select
715: B.NAME
716: from PQH_TRANSACTION_CATEGORIES_TL B
717: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
718: and B.LANGUAGE = T.SOURCE_LANG)
719: where (
720: T.TRANSACTION_CATEGORY_ID,

Line 725: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT

721: T.LANGUAGE
722: ) in (select
723: SUBT.TRANSACTION_CATEGORY_ID,
724: SUBT.LANGUAGE
725: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT
726: where SUBB.TRANSACTION_CATEGORY_ID = SUBT.TRANSACTION_CATEGORY_ID
727: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
728: and (SUBB.NAME <> SUBT.NAME
729: ));

Line 731: insert into PQH_TRANSACTION_CATEGORIES_TL (

727: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
728: and (SUBB.NAME <> SUBT.NAME
729: ));
730:
731: insert into PQH_TRANSACTION_CATEGORIES_TL (
732: TRANSACTION_CATEGORY_ID,
733: NAME,
734: LAST_UPDATE_DATE,
735: CREATION_DATE,

Line 751: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L

747: B.LAST_UPDATE_LOGIN,
748: B.LAST_UPDATED_BY,
749: L.LANGUAGE_CODE,
750: B.SOURCE_LANG
751: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L
752: where L.INSTALLED_FLAG in ('I', 'B')
753: and B.LANGUAGE = userenv('LANG')
754: and not exists
755: (select NULL

Line 756: from PQH_TRANSACTION_CATEGORIES_TL T

752: where L.INSTALLED_FLAG in ('I', 'B')
753: and B.LANGUAGE = userenv('LANG')
754: and not exists
755: (select NULL
756: from PQH_TRANSACTION_CATEGORIES_TL T
757: where T.TRANSACTION_CATEGORY_ID = B.TRANSACTION_CATEGORY_ID
758: and T.LANGUAGE = L.LANGUAGE_CODE);
759: end ADD_LANGUAGE;
760: -- --