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_ROUTING_CATEGORIES

Line 123: pqh_routing_categories_api.create_routing_category

119: --
120: -- Create a routing category and with default_flag 'Y'
121: -- File : pqrctapi.pkh/pkb
122: --
123: pqh_routing_categories_api.create_routing_category
124: (
125: p_validate => p_validate
126: ,p_routing_category_id => p_routing_category_id
127: ,p_transaction_category_id => p_transaction_category_id

Line 209: Select * from pqh_routing_categories

205: --
206: l_rng_record pqh_attribute_ranges%ROWTYPE;
207: --
208: Cursor csr_old_def_hierarchy is
209: Select * from pqh_routing_categories
210: Where routing_category_id = p_old_routing_category_id;
211: --
212: l_rct_record pqh_routing_categories%ROWTYPE;
213: --

Line 212: l_rct_record pqh_routing_categories%ROWTYPE;

208: Cursor csr_old_def_hierarchy is
209: Select * from pqh_routing_categories
210: Where routing_category_id = p_old_routing_category_id;
211: --
212: l_rct_record pqh_routing_categories%ROWTYPE;
213: --
214: l_proc varchar2(72) := 'update_default_hierarchy';
215: l_routing_category_id number := p_routing_category_id;
216: l_object_version_number number := p_object_version_number;

Line 269: pqh_routing_categories_api.update_routing_category

265: Close csr_old_def_hierarchy;
266: --
267: -- Disable previously selected default hierarcy
268: --
269: pqh_routing_categories_api.update_routing_category
270: (
271: p_validate => p_validate
272: ,p_routing_category_id => p_old_routing_category_id
273: ,p_transaction_category_id => l_rct_record.transaction_category_id

Line 328: pqh_routing_categories_api.update_routing_category

324: --
325: --
326: -- Enable previously selected default hierarcy
327: --
328: pqh_routing_categories_api.update_routing_category
329: (
330: p_validate => p_validate
331: ,p_routing_category_id => p_routing_category_id
332: ,p_transaction_category_id => p_transaction_category_id

Line 353: pqh_routing_categories_api.create_routing_category

349:
350: --
351: -- Create a routing category and with default_flag 'Y'
352: --
353: pqh_routing_categories_api.create_routing_category
354: (
355: p_validate => p_validate
356: ,p_routing_category_id => p_routing_category_id
357: ,p_transaction_category_id => p_transaction_category_id

Line 931: From pqh_routing_categories rct

927: p_identifier_type in varchar2) is
928: --
929: Cursor csr_adv_rct is
930: Select rct.routing_category_id
931: From pqh_routing_categories rct
932: Where rct.transaction_category_id = p_transaction_category_id
933: and nvl(rct.default_flag,'N') <> 'Y' ;
934: --
935: -- Cursor to return newly selected routing attributes

Line 944: From pqh_attribute_ranges rng,pqh_routing_categories rct

940: Where transaction_category_id = p_transaction_category_id
941: and list_identifying_flag = 'Y'
942: and not exists
943: (Select null
944: From pqh_attribute_ranges rng,pqh_routing_categories rct
945: Where rct.transaction_category_id = p_transaction_category_id
946: and nvl(rct.default_flag,'N') <> 'Y'
947: and rct.routing_category_id = rng.routing_category_id
948: and routing_list_member_id IS NULL

Line 973: From pqh_attribute_ranges rng,pqh_routing_categories rct

969: Where transaction_category_id = p_transaction_category_id
970: and member_identifying_flag = 'Y'
971: and not exists
972: (Select null
973: From pqh_attribute_ranges rng,pqh_routing_categories rct
974: Where rct.transaction_category_id = p_transaction_category_id
975: and nvl(rct.default_flag,'N') <> 'Y'
976: and rct.routing_category_id = rng.routing_category_id
977: and (routing_list_member_id IS NOT NULL or

Line 1116: From pqh_routing_categories rct

1112: -- routing attributes which were de-selected.
1113: --
1114: Cursor csr_rct is
1115: Select rct.routing_category_id
1116: From pqh_routing_categories rct
1117: Where rct.transaction_category_id = p_transaction_category_id;
1118: --
1119: /**
1120: Cursor csr_old (p_routing_category_id in number) is

Line 1234: From pqh_routing_categories rct

1230: -- authorization attributes which were de-selected.
1231: --
1232: Cursor csr_rct is
1233: Select rct.routing_category_id
1234: From pqh_routing_categories rct
1235: Where rct.transaction_category_id = p_transaction_category_id;
1236: --
1237: /**
1238: Cursor csr_old (p_routing_category_id in number) is

Line 1337: from pqh_routing_categories

1333: -- transaction category.
1334: --
1335: Cursor csr_rout_hier is
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)

Line 1358: pqh_ROUTING_CATEGORIES_api.update_ROUTING_CATEGORY

1354: If csr_attr%notfound then
1355: --
1356: For old_rec in csr_rout_hier loop
1357: --
1358: pqh_ROUTING_CATEGORIES_api.update_ROUTING_CATEGORY
1359: (
1360: p_validate => false
1361: ,p_routing_category_id => old_rec.routing_category_id
1362: ,p_enable_flag => 'N'

Line 2353: FROM PQH_ROUTING_CATEGORIES

2349:
2350: --- Cursor to copy default hierarchy detail
2351: CURSOR csr_routing_category IS
2352: SELECT *
2353: FROM PQH_ROUTING_CATEGORIES
2354: WHERE TRANSACTION_CATEGORY_ID = p_transaction_category_id
2355: AND NVL(ENABLE_FLAG, 'N') = 'Y'
2356: AND NVL(DEFAULT_FLAG,'N') = 'Y';
2357:

Line 2379: rct_rec pqh_routing_categories%ROWTYPE;

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;
2382: --
2383: rng_id pqh_attribute_ranges.attribute_range_id%type;

Line 2380: rct_id pqh_routing_categories.transaction_category_id%type;

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;
2382: --
2383: rng_id pqh_attribute_ranges.attribute_range_id%type;
2384: rng_ovn pqh_attribute_ranges.object_version_number%type;

Line 2381: rct_ovn pqh_routing_categories.object_version_number%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;
2382: --
2383: rng_id pqh_attribute_ranges.attribute_range_id%type;
2384: rng_ovn pqh_attribute_ranges.object_version_number%type;
2385: --

Line 2465: Select pqh_routing_categories_s.nextval into rct_id from dual;

2461: fetch csr_routing_category into rct_rec;
2462:
2463: exit when csr_routing_category%notfound;
2464:
2465: Select pqh_routing_categories_s.nextval into rct_id from dual;
2466:
2467: insert into pqh_routing_categories (
2468: routing_category_id,
2469: transaction_category_id,

Line 2467: insert into pqh_routing_categories (

2463: exit when csr_routing_category%notfound;
2464:
2465: Select pqh_routing_categories_s.nextval into rct_id from dual;
2466:
2467: insert into pqh_routing_categories (
2468: routing_category_id,
2469: transaction_category_id,
2470: enable_flag,
2471: default_flag,

Line 2782: from pqh_routing_categories_v

2778: --
2779: Cursor csr_def_hier (p_transaction_category_id in number,
2780: p_member_cd in varchar2) is
2781: Select routing_category_id
2782: from pqh_routing_categories_v
2783: where member_cd = p_member_cd
2784: and transaction_category_id = p_transaction_category_id
2785: and nvl(enable_flag,'Y') = 'Y'
2786: and nvl(default_flag,'N') = 'Y';

Line 2795: l_routing_category_id pqh_routing_categories.routing_category_id%type;

2791: Where routing_category_id = p_routing_category_id
2792: and nvl(approver_flag,'N') = 'Y'
2793: and nvl(enable_flag,'Y') = 'Y';
2794: --
2795: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2796: l_member_cd pqh_transaction_categories.member_cd%type;
2797: --
2798: l_dummy varchar2(1);
2799: l_error_status boolean := TRUE;

Line 2871: l_routing_category_id pqh_routing_categories.routing_category_id%type;

2867: l_rec_count number(10) := 0;
2868: l_no_of_rules number(10) := 0;
2869: l_no_of_errors number(10) := 0;
2870: --
2871: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2872: l_list_name varchar2(200);
2873: --
2874: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2875: default_flag pqh_routing_categories.default_flag%type,

Line 2874: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,

2870: --
2871: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2872: l_list_name varchar2(200);
2873: --
2874: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2875: default_flag pqh_routing_categories.default_flag%type,
2876: delete_flag pqh_routing_categories.delete_flag%type);
2877: type rct_tab is table of rct_rec index by binary_integer;
2878: --

Line 2875: default_flag pqh_routing_categories.default_flag%type,

2871: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2872: l_list_name varchar2(200);
2873: --
2874: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2875: default_flag pqh_routing_categories.default_flag%type,
2876: delete_flag pqh_routing_categories.delete_flag%type);
2877: type rct_tab is table of rct_rec index by binary_integer;
2878: --
2879: l_rct_tab rct_tab;

Line 2876: delete_flag pqh_routing_categories.delete_flag%type);

2872: l_list_name varchar2(200);
2873: --
2874: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2875: default_flag pqh_routing_categories.default_flag%type,
2876: delete_flag pqh_routing_categories.delete_flag%type);
2877: type rct_tab is table of rct_rec index by binary_integer;
2878: --
2879: l_rct_tab rct_tab;
2880: l_cnt number(15) := 0;

Line 2890: from pqh_routing_categories rct

2886:
2887: --Perf changes
2888: Cursor csr_ph is
2889: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2890: from pqh_routing_categories rct
2891: Where rct.transaction_category_id = p_transaction_category_id
2892: and rct.enable_flag = 'Y'
2893: and rct.position_structure_id IS NOT NULL;
2894: --

Line 2897: from pqh_routing_categories rct

2893: and rct.position_structure_id IS NOT NULL;
2894: --
2895: Cursor csr_sh is
2896: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2897: from pqh_routing_categories rct
2898: Where rct.transaction_category_id = p_transaction_category_id
2899: and rct.enable_flag = 'Y'
2900: and rct.routing_list_id IS NULL and rct.position_structure_id IS NULL;
2901: --

Line 2904: from pqh_routing_categories rct

2900: and rct.routing_list_id IS NULL and rct.position_structure_id IS NULL;
2901: --
2902: Cursor csr_rl is
2903: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2904: from pqh_routing_categories rct
2905: Where rct.transaction_category_id = p_transaction_category_id
2906: and rct.enable_flag = 'Y'
2907: and rct.routing_list_id IS NOT NULL;
2908: --

Line 3013: || ' from pqh_routing_categories rct,pqh_attribute_ranges rng'

3009: RETURN TRUE;
3010: --
3011: /**
3012: sql_stmt := 'Select rct.routing_category_id, count(rng.range_name)'
3013: || ' from pqh_routing_categories rct,pqh_attribute_ranges rng'
3014: || ' Where rct.transaction_category_id = :p_transaction_category_id'
3015: || ' and rct.enable_flag = :p_enable_flag'
3016: || ' and nvl(rct.default_flag,:null1) <> :p_default_flag'
3017: || ' and nvl(rct.delete_flag,:null2) <> :p_delete_flag';

Line 3105: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3101: Function chk_rout_overlap_on_freeze(p_transaction_category_id in number,
3102: p_routing_type in varchar2)
3103: RETURN BOOLEAN is
3104: --
3105: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3106: --
3107: type cur_type IS REF CURSOR;
3108: csr_chk_rule_overlap cur_type;
3109: sql_stmt varchar2(2000);

Line 3121: From pqh_routing_categories rct

3117: l_proc varchar2(72) := 'chk_overlap_on_freeze_cat';
3118: --
3119: /** Perf changes
3120: Select rct.routing_category_id,default_flag,delete_flag
3121: From pqh_routing_categories rct
3122: Where rct.transaction_category_id = :p_transaction_category_id
3123: and rct.enable_flag = 'Y'
3124: and rct.routing_list_id is not null
3125: **/

Line 3134: sql_stmt := 'Select rct.routing_category_id From pqh_routing_categories rct ';

3130: --
3131: -- Select all routing categories under the transaction category that
3132: -- belong to the current routing type
3133: --
3134: sql_stmt := 'Select rct.routing_category_id From pqh_routing_categories rct ';
3135: --
3136: sql_stmt := sql_stmt ||' Where rct.transaction_category_id = :p_transaction_category_id and rct.enable_flag = :p_enable_flag and nvl(rct.default_flag,:null_value) <> :default_flag and nvl(rct.delete_flag,:null2) <> :delete_flag ';
3137: --
3138: If p_routing_type = 'R' then

Line 3211: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;

3207: l_overlap_range_name pqh_attribute_ranges.range_name%type;
3208: l_error_range_name pqh_attribute_ranges.range_name%type;
3209: --
3210: l_prev_range_name pqh_attribute_ranges.range_name%type;
3211: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;
3212: l_prev_member_id number(30);
3213: --
3214: cnt number(10);
3215: l_attribute_range_id_list varchar2(2000);

Line 3218: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3214: cnt number(10);
3215: l_attribute_range_id_list varchar2(2000);
3216: l_no_mem_identifiers number(10);
3217: --
3218: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3219: l_range_name pqh_attribute_ranges.range_name%type;
3220: l_member_id number(30);
3221: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;
3222: l_attribute_id pqh_attribute_ranges.attribute_id%type;

Line 3274: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';

3270: End if;
3271: --
3272: sql_stmt := sql_stmt ||' rng.attribute_range_id, rng.attribute_id, att.column_type, rng.from_char, rng.to_char, rng.from_number, rng.to_number, rng.from_date, rng.to_date ';
3273: --
3274: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';
3275: --
3276: sql_stmt := sql_stmt ||' Where rct.transaction_category_id = :p_transaction_category_id and rct.enable_flag = :enable_flag and nvl(rct.default_flag,:null_value) <> :default_flag and nvl(rct.delete_flag,:null2) <> :delete_flag ';
3277: --
3278: -- If a routing category is passed, process only this routing category.

Line 3597: from pqh_routing_categories_v a

3593: --
3594: Cursor csr_hier (p_transaction_category_id in number,
3595: p_member_cd in varchar2) is
3596: Select routing_category_id
3597: from pqh_routing_categories_v a
3598: where a.transaction_category_id = p_transaction_category_id
3599: and a.member_cd = p_member_cd
3600: and nvl(a.enable_flag,'Y') = 'Y'
3601: and nvl(a.delete_flag,'N') <> 'Y'

Line 3604: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3600: and nvl(a.enable_flag,'Y') = 'Y'
3601: and nvl(a.delete_flag,'N') <> 'Y'
3602: and nvl(a.default_flag,'N') <> 'Y';
3603: --
3604: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3605: l_member_cd pqh_transaction_categories.member_cd%type;
3606: --
3607: l_error_status boolean := TRUE;
3608: l_proc varchar2(72) := 'check_if_adv_setup_started';

Line 3669: || ' from pqh_routing_categories rct '

3665: sql_stmt1 := 'Delete From pqh_attribute_ranges rng Where';
3666: --
3667: sql_stmt1 := sql_stmt1 || ' rng.routing_category_id in ('
3668: || ' Select routing_category_id '
3669: || ' from pqh_routing_categories rct '
3670: ||' Where rct.transaction_category_id = :p_transaction_category_id and nvl(rct.default_flag,:null_value) <> :default_flag and nvl(rct.delete_flag,:null2) = :delete_flag ';
3671: --
3672: If p_routing_style = 'R' then
3673: --

Line 3691: sql_stmt1 := 'Delete From pqh_routing_categories rct';

3687: --
3688: -- The following cursor selects all routing hierarchies that were selected for
3689: -- deletion for the passed transaction category and its current routing style.
3690: --
3691: sql_stmt1 := 'Delete From pqh_routing_categories rct';
3692: --
3693: sql_stmt1 := sql_stmt1 ||' Where rct.transaction_category_id = :p_transaction_category_id and nvl(rct.default_flag,:null_value) <> :default_flag and nvl(rct.delete_flag,:null2) = :delete_flag ';
3694: --
3695: If p_routing_style = 'R' then

Line 3719: ||' from pqh_routing_categories rct '

3715: ||' Where nvl(rng.delete_flag,:null1) = :delete_flag ';
3716: --
3717: sql_stmt1 := sql_stmt1 ||' and rng.routing_category_id in ('
3718: ||' Select routing_category_id '
3719: ||' from pqh_routing_categories rct '
3720: ||' Where rct.transaction_category_id = :p_transaction_category_id ';
3721: --
3722: If p_routing_style = 'R' then
3723: --