eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TCT_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 42: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_FK1') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_FK1') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;

Line 47: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_PK') Then

43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_PK') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;

Line 52: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_FK2') Then

48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_FK2') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;

Line 57: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_UK') Then

53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_TRANSACTION_CATEGORIES_UK') Then
58: hr_utility.set_message(8302, 'PQH_SS_DUPLICATE_SHORT_NAME');
59: hr_utility.raise_error;
60: Else
61: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 105: from pqh_transaction_categories

101: consolidated_table_route_id ,
102: business_group_id,
103: setup_type_cd,
104: master_table_route_id
105: from pqh_transaction_categories
106: where transaction_category_id = p_transaction_category_id;
107: --
108: l_proc varchar2(72) := g_package||'api_updating';
109: l_fct_ret boolean;

Line 195: from pqh_transaction_categories

191: consolidated_table_route_id,
192: business_group_id,
193: setup_type_cd,
194: master_table_route_id
195: from pqh_transaction_categories
196: where transaction_category_id = p_transaction_category_id
197: for update nowait;
198: --
199: l_proc varchar2(72) := g_package||'lck';

Line 238: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories');

234: -- The object is locked therefore we need to supply a meaningful
235: -- error message.
236: --
237: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
238: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories');
239: hr_utility.raise_error;
240: End lck;
241: --
242: -- ----------------------------------------------------------------------------

Line 406: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type := 0;

402: l_object_version_number number := 1;
403: l_language varchar2(30) ;
404:
405: --
406: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type := 0;
407: l_consolidated_table_route_id pqh_transaction_categories.consolidated_table_route_id%type;
408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;
409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --

Line 407: l_consolidated_table_route_id pqh_transaction_categories.consolidated_table_route_id%type;

403: l_language varchar2(30) ;
404:
405: --
406: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type := 0;
407: l_consolidated_table_route_id pqh_transaction_categories.consolidated_table_route_id%type;
408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;
409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --
411: --

Line 408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;

404:
405: --
406: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type := 0;
407: l_consolidated_table_route_id pqh_transaction_categories.consolidated_table_route_id%type;
408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;
409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --
411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;

Line 412: l_created_by pqh_transaction_categories.created_by%TYPE;

408: l_master_table_route_id pqh_transaction_categories.master_table_route_id%type;
409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --
411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
414: l_creation_date pqh_transaction_categories.creation_date%TYPE;
415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;

Line 413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;

409: l_business_group_id hr_all_organization_units.business_group_id%type;
410: --
411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
414: l_creation_date pqh_transaction_categories.creation_date%TYPE;
415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
417: --

Line 414: l_creation_date pqh_transaction_categories.creation_date%TYPE;

410: --
411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
414: l_creation_date pqh_transaction_categories.creation_date%TYPE;
415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
417: --
418: --

Line 415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;

411: --
412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
414: l_creation_date pqh_transaction_categories.creation_date%TYPE;
415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
417: --
418: --
419: cursor c1 is select userenv('LANG') from dual ;

Line 416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;

412: l_created_by pqh_transaction_categories.created_by%TYPE;
413: l_last_updated_by pqh_transaction_categories.last_updated_by%TYPE;
414: l_creation_date pqh_transaction_categories.creation_date%TYPE;
415: l_last_update_date pqh_transaction_categories.last_update_date%TYPE;
416: l_last_update_login pqh_transaction_categories.last_update_login%TYPE;
417: --
418: --
419: cursor c1 is select userenv('LANG') from dual ;
420: --

Line 429: From pqh_transaction_categories_vl

425: --
426: --
427: Cursor c3 is
428: Select transaction_category_id
429: From pqh_transaction_categories_vl
430: Where short_name = p_short_name and business_group_id IS NULL;
431: --
432: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;
433: --

Line 432: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;

428: Select transaction_category_id
429: From pqh_transaction_categories_vl
430: Where short_name = p_short_name and business_group_id IS NULL;
431: --
432: Cursor C_Sel1 is select pqh_transaction_categories_s.nextval from sys.dual;
433: --
434: --
435: /**
436: Cursor c4 is select business_group_id

Line 497: update pqh_transaction_categories

493: --
494: -- If there is a row for the transaction category
495: -- update the row in the base table
496: --
497: update pqh_transaction_categories
498: set
499: custom_wf_process_name = p_custom_wf_process_name,
500: custom_workflow_name = p_custom_workflow_name,
501: form_name = p_form_name,

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 587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',

583: -- Added the following code as a part of Zero Downtime Patching Project.
584: -- Code Starts Here.
585: --
586: PER_RIC_PKG.chk_integrity (
587: p_entity_name=>'PQH_TRANSACTION_CATEGORIES',
588: p_ref_entity_info=>
589: PER_RIC_PKG.ref_entity_tbl(
590: PER_RIC_PKG.ref_info_rec('PQH_TABLE_ROUTE',PER_RIC_PKG.column_info_tbl(
591: PER_RIC_PKG.col_info_rec('TABLE_ROUTE_ID',NULL,l_consolidated_table_route_id, NULL))),

Line 601: insert into pqh_transaction_categories

597: --
598: -- Insert row into the base table
599: --
600:
601: insert into pqh_transaction_categories
602: ( transaction_category_id,
603: custom_wf_process_name,
604: custom_workflow_name,
605: form_name,

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 708: from PQH_TRANSACTION_CATEGORIES B

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
710: );
711:
712: update PQH_TRANSACTION_CATEGORIES_TL T set (

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: -- --