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_WIZARD_PKG dependencies on PQH_TRANSACTION_CATEGORIES

Line 16: -- Set_up flag is a new field in pqh_transaction_categories which tells us what

12: p_setup_type out nocopy varchar2)
13: Return Boolean
14: IS
15: --
16: -- Set_up flag is a new field in pqh_transaction_categories which tells us what
17: -- part of the setup is complete. Can have values of STANDARD/ADVANCED/NULL
18: --
19: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
20: l_set_up_flag pqh_transaction_categories.setup_type_cd%type;

Line 19: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;

15: --
16: -- Set_up flag is a new field in pqh_transaction_categories which tells us what
17: -- part of the setup is complete. Can have values of STANDARD/ADVANCED/NULL
18: --
19: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
20: l_set_up_flag pqh_transaction_categories.setup_type_cd%type;
21: --
22: l_proc varchar2(72) := 'chk_if_setup_finish';
23: --

Line 20: l_set_up_flag pqh_transaction_categories.setup_type_cd%type;

16: -- Set_up flag is a new field in pqh_transaction_categories which tells us what
17: -- part of the setup is complete. Can have values of STANDARD/ADVANCED/NULL
18: --
19: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
20: l_set_up_flag pqh_transaction_categories.setup_type_cd%type;
21: --
22: l_proc varchar2(72) := 'chk_if_setup_finish';
23: --
24: Cursor csr_setup is

Line 27: from pqh_transaction_categories_vl

23: --
24: Cursor csr_setup is
25: --
26: Select nvl(setup_type_cd,'INCOMPLETE') , nvl(freeze_status_cd,'X')
27: from pqh_transaction_categories_vl
28: where transaction_category_id = p_transaction_category_id;
29: --
30: Begin
31: --

Line 1340: from pqh_transaction_categories

1336: Select routing_category_id,object_version_number
1337: from pqh_routing_categories
1338: Where transaction_category_id = p_transaction_category_id
1339: and decode(routing_list_id,NULL,decode( Position_structure_id,NULL,'S','P'),'R') = (Select member_cd
1340: from pqh_transaction_categories
1341: Where transaction_category_id = p_transaction_category_id)
1342: and nvl(default_flag,'N') <> 'Y'
1343: and nvl(enable_flag,'Y') = 'Y';
1344: --

Line 2346: FROM PQH_TRANSACTION_CATEGORIES

2342:
2343: --- Cursor to copy transaction category detail
2344: CURSOR csr_transaction_category IS
2345: SELECT *
2346: FROM PQH_TRANSACTION_CATEGORIES
2347: WHERE TRANSACTION_CATEGORY_ID = p_transaction_category_id
2348: AND BUSINESS_GROUP_ID IS NULL;
2349:
2350: --- Cursor to copy default hierarchy detail

Line 2375: tct_rec pqh_transaction_categories%ROWTYPE;

2371: attr_rec pqh_txn_category_Attributes%ROWTYPE;
2372: l_id pqh_txn_category_Attributes.txn_category_attribute_id%type;
2373: l_ovn pqh_txn_category_Attributes.object_version_number%type;
2374: --
2375: tct_rec pqh_transaction_categories%ROWTYPE;
2376: tct_id pqh_transaction_categories.transaction_category_id%type;
2377: tct_ovn pqh_transaction_categories.object_version_number%type;
2378: --
2379: rct_rec pqh_routing_categories%ROWTYPE;

Line 2376: tct_id pqh_transaction_categories.transaction_category_id%type;

2372: l_id pqh_txn_category_Attributes.txn_category_attribute_id%type;
2373: l_ovn pqh_txn_category_Attributes.object_version_number%type;
2374: --
2375: tct_rec pqh_transaction_categories%ROWTYPE;
2376: tct_id pqh_transaction_categories.transaction_category_id%type;
2377: tct_ovn pqh_transaction_categories.object_version_number%type;
2378: --
2379: rct_rec pqh_routing_categories%ROWTYPE;
2380: rct_id pqh_routing_categories.transaction_category_id%type;

Line 2377: tct_ovn pqh_transaction_categories.object_version_number%type;

2373: l_ovn pqh_txn_category_Attributes.object_version_number%type;
2374: --
2375: tct_rec pqh_transaction_categories%ROWTYPE;
2376: tct_id pqh_transaction_categories.transaction_category_id%type;
2377: tct_ovn pqh_transaction_categories.object_version_number%type;
2378: --
2379: rct_rec pqh_routing_categories%ROWTYPE;
2380: rct_id pqh_routing_categories.transaction_category_id%type;
2381: rct_ovn pqh_routing_categories.object_version_number%type;

Line 2580: Update pqh_transaction_categories

2576: --
2577: hr_utility.set_location('Entering:'||l_proc, 5);
2578: --
2579: --
2580: Update pqh_transaction_categories
2581: set freeze_status_cd = p_freeze_status_cd
2582: ,setup_type_cd = p_setup_type_cd
2583: where transaction_category_id = p_transaction_category_id;
2584: --

Line 2797: from pqh_transaction_categories

2793: RETURN boolean IS
2794: --
2795: Cursor csr_member_cd(p_transaction_category_id in number) is
2796: Select member_cd
2797: from pqh_transaction_categories
2798: Where transaction_category_id = p_transaction_category_id;
2799: --
2800: Cursor csr_def_hier (p_transaction_category_id in number,
2801: p_member_cd in varchar2) is

Line 2817: l_member_cd pqh_transaction_categories.member_cd%type;

2813: and nvl(approver_flag,'N') = 'Y'
2814: and nvl(enable_flag,'Y') = 'Y';
2815: --
2816: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2817: l_member_cd pqh_transaction_categories.member_cd%type;
2818: --
2819: l_dummy varchar2(1);
2820: l_error_status boolean := TRUE;
2821: --

Line 3525: l_routing_type pqh_transaction_categories.member_cd%type;

3521: --
3522: l_error_index number(10) := 0;
3523: l_error_messages warnings_tab;
3524: --
3525: l_routing_type pqh_transaction_categories.member_cd%type;
3526: --
3527: l_error_routing_category varchar2(200);
3528: l_member_name varchar2(300);
3529: l_overlap_range_name pqh_attribute_ranges.range_name%type;

Line 3535: From pqh_transaction_categories

3531: --
3532: --
3533: Cursor csr_routing_type is
3534: Select member_Cd
3535: From pqh_transaction_categories
3536: Where transaction_category_id = p_transaction_category_id;
3537: --
3538: Begin
3539: --

Line 3612: from pqh_transaction_categories

3608: RETURN BOOLEAN is
3609: --
3610: Cursor csr_member_cd(p_transaction_category_id in number) is
3611: Select member_cd
3612: from pqh_transaction_categories
3613: Where transaction_category_id = p_transaction_category_id;
3614: --
3615: Cursor csr_hier (p_transaction_category_id in number,
3616: p_member_cd in varchar2) is

Line 3626: l_member_cd pqh_transaction_categories.member_cd%type;

3622: and nvl(a.delete_flag,'N') <> 'Y'
3623: and nvl(a.default_flag,'N') <> 'Y';
3624: --
3625: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3626: l_member_cd pqh_transaction_categories.member_cd%type;
3627: --
3628: l_error_status boolean := TRUE;
3629: l_proc varchar2(72) := 'check_if_adv_setup_started';
3630: --