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 2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(

2507: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
2508: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID', NULL,rng_rec.attribute_id, NULL))),
2509: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_LIST_MEMBERS', PER_RIC_PKG.column_info_tbl(
2510: PER_RIC_PKG.col_info_rec('ROUTING_LIST_MEMBER_ID',NULL,rng_rec.routing_list_member_id,NULL))),
2511: PER_RIC_PKG.ref_info_rec('PQH_ROUTING_CATEGORIES',PER_RIC_PKG.column_info_tbl(
2512: PER_RIC_PKG.col_info_rec('ROUTING_CATEGORY_ID',NULL,rct_id, NULL)))),
2513: p_ref_type=>'INS');
2514:
2515: --

Line 2803: from pqh_routing_categories_v

2799: --
2800: Cursor csr_def_hier (p_transaction_category_id in number,
2801: p_member_cd in varchar2) is
2802: Select routing_category_id
2803: from pqh_routing_categories_v
2804: where member_cd = p_member_cd
2805: and transaction_category_id = p_transaction_category_id
2806: and nvl(enable_flag,'Y') = 'Y'
2807: and nvl(default_flag,'N') = 'Y';

Line 2816: l_routing_category_id pqh_routing_categories.routing_category_id%type;

2812: Where routing_category_id = p_routing_category_id
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;

Line 2892: l_routing_category_id pqh_routing_categories.routing_category_id%type;

2888: l_rec_count number(10) := 0;
2889: l_no_of_rules number(10) := 0;
2890: l_no_of_errors number(10) := 0;
2891: --
2892: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2893: l_list_name varchar2(200);
2894: --
2895: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2896: default_flag pqh_routing_categories.default_flag%type,

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

2891: --
2892: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2893: l_list_name varchar2(200);
2894: --
2895: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2896: default_flag pqh_routing_categories.default_flag%type,
2897: delete_flag pqh_routing_categories.delete_flag%type);
2898: type rct_tab is table of rct_rec index by binary_integer;
2899: --

Line 2896: default_flag pqh_routing_categories.default_flag%type,

2892: l_routing_category_id pqh_routing_categories.routing_category_id%type;
2893: l_list_name varchar2(200);
2894: --
2895: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2896: default_flag pqh_routing_categories.default_flag%type,
2897: delete_flag pqh_routing_categories.delete_flag%type);
2898: type rct_tab is table of rct_rec index by binary_integer;
2899: --
2900: l_rct_tab rct_tab;

Line 2897: delete_flag pqh_routing_categories.delete_flag%type);

2893: l_list_name varchar2(200);
2894: --
2895: type rct_rec is record(routing_category_id pqh_routing_categories.routing_category_id%type,
2896: default_flag pqh_routing_categories.default_flag%type,
2897: delete_flag pqh_routing_categories.delete_flag%type);
2898: type rct_tab is table of rct_rec index by binary_integer;
2899: --
2900: l_rct_tab rct_tab;
2901: l_cnt number(15) := 0;

Line 2911: from pqh_routing_categories rct

2907:
2908: --Perf changes
2909: Cursor csr_ph is
2910: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2911: from pqh_routing_categories rct
2912: Where rct.transaction_category_id = p_transaction_category_id
2913: and rct.enable_flag = 'Y'
2914: and rct.position_structure_id IS NOT NULL;
2915: --

Line 2918: from pqh_routing_categories rct

2914: and rct.position_structure_id IS NOT NULL;
2915: --
2916: Cursor csr_sh is
2917: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2918: from pqh_routing_categories rct
2919: Where rct.transaction_category_id = p_transaction_category_id
2920: and rct.enable_flag = 'Y'
2921: and rct.routing_list_id IS NULL and rct.position_structure_id IS NULL;
2922: --

Line 2925: from pqh_routing_categories rct

2921: and rct.routing_list_id IS NULL and rct.position_structure_id IS NULL;
2922: --
2923: Cursor csr_rl is
2924: Select rct.routing_category_id,rct.default_flag, rct.delete_flag
2925: from pqh_routing_categories rct
2926: Where rct.transaction_category_id = p_transaction_category_id
2927: and rct.enable_flag = 'Y'
2928: and rct.routing_list_id IS NOT NULL;
2929: --

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

3030: RETURN TRUE;
3031: --
3032: /**
3033: sql_stmt := 'Select rct.routing_category_id, count(rng.range_name)'
3034: || ' from pqh_routing_categories rct,pqh_attribute_ranges rng'
3035: || ' Where rct.transaction_category_id = :p_transaction_category_id'
3036: || ' and rct.enable_flag = :p_enable_flag'
3037: || ' and nvl(rct.default_flag,:null1) <> :p_default_flag'
3038: || ' and nvl(rct.delete_flag,:null2) <> :p_delete_flag';

Line 3126: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3122: Function chk_rout_overlap_on_freeze(p_transaction_category_id in number,
3123: p_routing_type in varchar2)
3124: RETURN BOOLEAN is
3125: --
3126: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3127: --
3128: type cur_type IS REF CURSOR;
3129: csr_chk_rule_overlap cur_type;
3130: sql_stmt varchar2(2000);

Line 3142: From pqh_routing_categories rct

3138: l_proc varchar2(72) := 'chk_overlap_on_freeze_cat';
3139: --
3140: /** Perf changes
3141: Select rct.routing_category_id,default_flag,delete_flag
3142: From pqh_routing_categories rct
3143: Where rct.transaction_category_id = :p_transaction_category_id
3144: and rct.enable_flag = 'Y'
3145: and rct.routing_list_id is not null
3146: **/

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

3151: --
3152: -- Select all routing categories under the transaction category that
3153: -- belong to the current routing type
3154: --
3155: sql_stmt := 'Select rct.routing_category_id From pqh_routing_categories rct ';
3156: --
3157: 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 ';
3158: --
3159: If p_routing_type = 'R' then

Line 3232: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;

3228: l_overlap_range_name pqh_attribute_ranges.range_name%type;
3229: l_error_range_name pqh_attribute_ranges.range_name%type;
3230: --
3231: l_prev_range_name pqh_attribute_ranges.range_name%type;
3232: l_prev_routing_category_id pqh_routing_categories.routing_category_id%type;
3233: l_prev_member_id number(30);
3234: --
3235: cnt number(10);
3236: l_attribute_range_id_list varchar2(2000);

Line 3239: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3235: cnt number(10);
3236: l_attribute_range_id_list varchar2(2000);
3237: l_no_mem_identifiers number(10);
3238: --
3239: l_routing_category_id pqh_routing_categories.routing_category_id%type;
3240: l_range_name pqh_attribute_ranges.range_name%type;
3241: l_member_id number(30);
3242: l_attribute_range_id pqh_attribute_ranges.attribute_range_id %type;
3243: l_attribute_id pqh_attribute_ranges.attribute_id%type;

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

3291: End if;
3292: --
3293: 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 ';
3294: --
3295: sql_stmt := sql_stmt ||' From pqh_routing_categories rct,pqh_attribute_ranges rng,pqh_attributes att ';
3296: --
3297: 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 ';
3298: --
3299: -- If a routing category is passed, process only this routing category.

Line 3618: from pqh_routing_categories_v a

3614: --
3615: Cursor csr_hier (p_transaction_category_id in number,
3616: p_member_cd in varchar2) is
3617: Select routing_category_id
3618: from pqh_routing_categories_v a
3619: where a.transaction_category_id = p_transaction_category_id
3620: and a.member_cd = p_member_cd
3621: and nvl(a.enable_flag,'Y') = 'Y'
3622: and nvl(a.delete_flag,'N') <> 'Y'

Line 3625: l_routing_category_id pqh_routing_categories.routing_category_id%type;

3621: and nvl(a.enable_flag,'Y') = 'Y'
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';

Line 3690: || ' from pqh_routing_categories rct '

3686: sql_stmt1 := 'Delete From pqh_attribute_ranges rng Where';
3687: --
3688: sql_stmt1 := sql_stmt1 || ' rng.routing_category_id in ('
3689: || ' Select routing_category_id '
3690: || ' from pqh_routing_categories rct '
3691: ||' 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 ';
3692: --
3693: If p_routing_style = 'R' then
3694: --

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

3708: --
3709: -- The following cursor selects all routing hierarchies that were selected for
3710: -- deletion for the passed transaction category and its current routing style.
3711: --
3712: sql_stmt1 := 'Delete From pqh_routing_categories rct';
3713: --
3714: 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 ';
3715: --
3716: If p_routing_style = 'R' then

Line 3740: ||' from pqh_routing_categories rct '

3736: ||' Where nvl(rng.delete_flag,:null1) = :delete_flag ';
3737: --
3738: sql_stmt1 := sql_stmt1 ||' and rng.routing_category_id in ('
3739: ||' Select routing_category_id '
3740: ||' from pqh_routing_categories rct '
3741: ||' Where rct.transaction_category_id = :p_transaction_category_id ';
3742: --
3743: If p_routing_style = 'R' then
3744: --