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 585: insert into pqh_transaction_categories

581: --
582: -- Insert row into the base table
583: --
584:
585: insert into pqh_transaction_categories
586: ( transaction_category_id,
587: custom_wf_process_name,
588: custom_workflow_name,
589: form_name,

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

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
694: );
695:
696: update PQH_TRANSACTION_CATEGORIES_TL T set (

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