[Home] [Help]
908: hr_utility.set_location('From_clause not there '||l_proc,30);
909: else
910: l_setup := tran_setup(p_transaction_category_id);
911: hr_utility.set_location('tran_cat setup is '||l_setup||l_proc,66);
912: if nvl(l_setup,'XYZ') = 'STANDARD' then
913: list_range_check(p_tran_cat_id => p_transaction_category_id,
914: p_member_cd => l_member_cd,
915: p_used_for => 'O',
916: p_routing_list_id => l_routing_list_id,
1638: if p_status_flag = 0 then
1639: hr_utility.set_location('no error in routing history'||l_proc,65);
1640: l_setup := tran_setup(p_tran_cat_id);
1641: hr_utility.set_location('tran_cat setup is '||l_setup||l_proc,66);
1642: if nvl(l_setup,'XYZ') = 'STANDARD' then
1643: list_range_check(p_tran_cat_id => p_tran_cat_id,
1644: p_member_cd => p_member_cd,
1645: p_used_for => 'L',
1646: p_routing_list_id => p_routing_list_id,
2464: and position_structure_id is null;
2465:
2466: l_proc varchar2(256) := g_package||'list_range_check_std';
2467: begin
2468: -- this procedure will be getting called if only standard setup is complete.
2469: /*
2470: The change in logic , to pick up the routing category was changed with discussion with stella
2471: as per the change in wizard functionality.
2472: earlier we were assuming that only one default routing category will be there, but there can be
2593: l_error_flag boolean := FALSE;
2594: l_range_found_flag boolean;
2595: l_approver_flag boolean;
2596: l_rout_cat number;
2597: l_standard_setup number;
2598: l_proc varchar2(256) := g_package||'list_range_check_adv';
2599: begin
2600: /* called when advanced setup is complete */
2601: hr_utility.set_location('Entering '||l_proc,10);
2808: hr_utility.set_location('more than one range applicable'||l_proc,190);
2809: else
2810: list_rout_crit;
2811: hr_utility.set_location('no range applicable'||p_status_flag||l_proc,192);
2812: -- check standard setup can be taken or not if yes then call it.
2813: select count(*) into l_standard_setup
2814: from pqh_routing_categories
2815: where transaction_category_id = p_tran_cat_id
2816: and nvl(default_flag,'X') ='Y'
2809: else
2810: list_rout_crit;
2811: hr_utility.set_location('no range applicable'||p_status_flag||l_proc,192);
2812: -- check standard setup can be taken or not if yes then call it.
2813: select count(*) into l_standard_setup
2814: from pqh_routing_categories
2815: where transaction_category_id = p_tran_cat_id
2816: and nvl(default_flag,'X') ='Y'
2817: and nvl(delete_flag,'N') = 'N'
2815: where transaction_category_id = p_tran_cat_id
2816: and nvl(default_flag,'X') ='Y'
2817: and nvl(delete_flag,'N') = 'N'
2818: and nvl(enable_flag,'X') = 'Y';
2819: if nvl(l_standard_setup,0) > 0 then
2820: hr_utility.set_location('calling standard setup'||l_proc,200);
2821: list_range_check(p_tran_cat_id => p_tran_cat_id,
2822: p_member_cd => p_member_cd,
2823: p_used_for => 'L',
2816: and nvl(default_flag,'X') ='Y'
2817: and nvl(delete_flag,'N') = 'N'
2818: and nvl(enable_flag,'X') = 'Y';
2819: if nvl(l_standard_setup,0) > 0 then
2820: hr_utility.set_location('calling standard setup'||l_proc,200);
2821: list_range_check(p_tran_cat_id => p_tran_cat_id,
2822: p_member_cd => p_member_cd,
2823: p_used_for => 'L',
2824: p_routing_list_id => p_routing_list_id,
2824: p_routing_list_id => p_routing_list_id,
2825: p_pos_str_id => p_pos_str_id,
2826: p_routing_category_id => p_routing_category_id,
2827: p_status_flag => p_status_flag);
2828: hr_utility.set_location('out of standard setup'||l_proc,200);
2829: else
2830: -- hard coding the value of routing catg to 0
2831: p_routing_category_id := 0;
2832: p_status_flag := 11;