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 645: insert into pqh_transaction_categories_tl

641:
642: --
643: -- Insert row into the tl table
644: --
645: insert into pqh_transaction_categories_tl
646: ( transaction_category_id,
647: name,
648: language,
649: source_lang,

Line 669: from pqh_transaction_categories_tl ctl

665: l_last_update_login
666: from fnd_languages l
667: where l.installed_flag in ('I','B')
668: and not exists (select null
669: from pqh_transaction_categories_tl ctl
670: where ctl.transaction_category_id = l_transaction_category_id
671: and ctl.language = l.language_code );
672: --
673: --

Line 689: delete from PQH_TRANSACTION_CATEGORIES_TL T

685: --
686: Procedure ADD_LANGUAGE
687: is
688: begin
689: delete from PQH_TRANSACTION_CATEGORIES_TL T
690: where not exists
691: (select NULL
692: from PQH_TRANSACTION_CATEGORIES B
693: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID

Line 696: update PQH_TRANSACTION_CATEGORIES_TL T set (

692: from PQH_TRANSACTION_CATEGORIES B
693: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
694: );
695:
696: update PQH_TRANSACTION_CATEGORIES_TL T set (
697: NAME
698: ) = (select
699: B.NAME
700: from PQH_TRANSACTION_CATEGORIES_TL B

Line 700: from PQH_TRANSACTION_CATEGORIES_TL B

696: update PQH_TRANSACTION_CATEGORIES_TL T set (
697: NAME
698: ) = (select
699: B.NAME
700: from PQH_TRANSACTION_CATEGORIES_TL B
701: where B.TRANSACTION_CATEGORY_ID = T.TRANSACTION_CATEGORY_ID
702: and B.LANGUAGE = T.SOURCE_LANG)
703: where (
704: T.TRANSACTION_CATEGORY_ID,

Line 709: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT

705: T.LANGUAGE
706: ) in (select
707: SUBT.TRANSACTION_CATEGORY_ID,
708: SUBT.LANGUAGE
709: from PQH_TRANSACTION_CATEGORIES_TL SUBB, PQH_TRANSACTION_CATEGORIES_TL SUBT
710: where SUBB.TRANSACTION_CATEGORY_ID = SUBT.TRANSACTION_CATEGORY_ID
711: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
712: and (SUBB.NAME <> SUBT.NAME
713: ));

Line 715: insert into PQH_TRANSACTION_CATEGORIES_TL (

711: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
712: and (SUBB.NAME <> SUBT.NAME
713: ));
714:
715: insert into PQH_TRANSACTION_CATEGORIES_TL (
716: TRANSACTION_CATEGORY_ID,
717: NAME,
718: LAST_UPDATE_DATE,
719: CREATION_DATE,

Line 735: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L

731: B.LAST_UPDATE_LOGIN,
732: B.LAST_UPDATED_BY,
733: L.LANGUAGE_CODE,
734: B.SOURCE_LANG
735: from PQH_TRANSACTION_CATEGORIES_TL B, FND_LANGUAGES L
736: where L.INSTALLED_FLAG in ('I', 'B')
737: and B.LANGUAGE = userenv('LANG')
738: and not exists
739: (select NULL

Line 740: from PQH_TRANSACTION_CATEGORIES_TL T

736: where L.INSTALLED_FLAG in ('I', 'B')
737: and B.LANGUAGE = userenv('LANG')
738: and not exists
739: (select NULL
740: from PQH_TRANSACTION_CATEGORIES_TL T
741: where T.TRANSACTION_CATEGORY_ID = B.TRANSACTION_CATEGORY_ID
742: and T.LANGUAGE = L.LANGUAGE_CODE);
743: end ADD_LANGUAGE;
744: -- --