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.GHR_SF52_API dependencies on GHR_PA_ROUTING_HISTORY

Line 252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

248: l_exists boolean := false;
249: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
250: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
251: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

249: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
250: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
251: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

Line 254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

250: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
251: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

Line 255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

251: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

252: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;

253: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

254: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
255: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
256: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
257: l_approved_flag ghr_pa_routing_history.approved_flag%TYPE;
258: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;

259: l_user_name_employee_id per_people_f.person_id%TYPE;
260: l_user_name_emp_first_name per_people_f.first_name%TYPE;
261: l_user_name_emp_last_name per_people_f.last_name%TYPE;
262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);
266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;

Line 266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

262: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);
266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
269: l_temp number(15);
270: --l_rec ghr_par_shd.g_old_rec%type;

Line 267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;

263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);
266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
269: l_temp number(15);
270: --l_rec ghr_par_shd.g_old_rec%type;
271: l_rec ghr_pa_requests%rowtype;

Line 268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

264: -- Modified to consider 100 characters as user name
265: l_forward_to_name varchar2(100);
266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
269: l_temp number(15);
270: --l_rec ghr_par_shd.g_old_rec%type;
271: l_rec ghr_pa_requests%rowtype;
272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available

Line 386: FROM ghr_pa_routing_history prh

382:
383:
384: CURSOR c_history_exists IS
385: SELECT 1
386: FROM ghr_pa_routing_history prh
387: WHERE prh.pa_request_id = l_pa_request_id;
388:
389: CURSOR c_groupbox_name IS
390: SELECT gbx.name

Line 2241: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

2237: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
2238: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2239: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2240: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2241: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));

Line 2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

2238: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2239: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2240: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2241: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

Line 2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

2239: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2240: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2241: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

Line 2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

2240: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2241: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

Line 2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

2242: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

Line 2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

2243: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

2244: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

2245: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

2246: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

2247: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2248: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2249: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2250: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2251: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2252: l_user_name_employee_id per_people_f.person_id%TYPE;
2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

Line 2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2253: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;

Line 2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2254: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2255: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

Line 2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

2256: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;

Line 2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;

2257: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;

Line 2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2258: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;
2266: -- l_rec ghr_par_shd.g_old_rec%type;

Line 2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;

2259: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;
2266: -- l_rec ghr_par_shd.g_old_rec%type;
2267: l_rei_rec ghr_pa_request_extra_info%rowtype;

Line 2264: l_forward_to_name ghr_pa_routing_history.user_name%type;

2260: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2261: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;
2266: -- l_rec ghr_par_shd.g_old_rec%type;
2267: l_rei_rec ghr_pa_request_extra_info%rowtype;
2268: l_part_time_hours ghr_pa_requests.part_time_hours%type;

Line 2356: FROM ghr_pa_routing_history prh

2352:
2353:
2354: CURSOR c_cnt_history IS
2355: SELECT count(*) cnt
2356: FROM ghr_pa_routing_history prh
2357: WHERE prh.pa_request_id = p_pa_request_id;
2358:
2359: CURSOR C_routing_history_id IS
2360: SELECT prh.pa_routing_history_id,

Line 2362: FROM ghr_pa_routing_history prh

2358:
2359: CURSOR C_routing_history_id IS
2360: SELECT prh.pa_routing_history_id,
2361: prh.object_version_number
2362: FROM ghr_pa_routing_history prh
2363: WHERE prh.pa_request_id = p_pa_request_id
2364: ORDER by prh.pa_routing_history_id desc;
2365:
2366: CURSOR c_routing_group_id IS

Line 2400: FROM ghr_pa_routing_history prh

2396: AND effective_end_date;
2397:
2398: CURSOR cur_rout_list_used IS
2399: SELECT prh.routing_seq_number
2400: FROM ghr_pa_routing_history prh
2401: WHERE prh.pa_request_id = p_pa_request_id
2402: AND prh.routing_list_id = p_i_routing_list_id
2403: ORDER BY prh.pa_routing_history_id desc;
2404:

Line 2417: FROM ghr_pa_routing_history prh

2413:
2414:
2415: CURSOR c_history_exists IS
2416: SELECT action_taken
2417: FROM ghr_pa_routing_history prh
2418: WHERE prh.pa_request_id = p_pa_request_id;
2419:
2420: CURSOR c_groupbox_name IS
2421: SELECT gbx.name

Line 4399: l_prh_rec ghr_pa_routing_history%rowtype;

4395: )is
4396:
4397: l_proc varchar2(72) := g_package||'end_sf52';
4398: l_effective_date date;
4399: l_prh_rec ghr_pa_routing_history%rowtype;
4400: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4401: l_count number;
4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;

Line 4400: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

4396:
4397: l_proc varchar2(72) := g_package||'end_sf52';
4398: l_effective_date date;
4399: l_prh_rec ghr_pa_routing_history%rowtype;
4400: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4401: l_count number;
4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;

Line 4403: l_user_name ghr_pa_routing_history.user_name%type;

4399: l_prh_rec ghr_pa_routing_history%rowtype;
4400: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4401: l_count number;
4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

Line 4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;

4400: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4401: l_count number;
4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

4401: l_count number;
4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

Line 4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

Line 4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

4403: l_user_name ghr_pa_routing_history.user_name%type;
4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;

Line 4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

4404: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;

Line 4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;

Line 4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;

Line 4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;

4407: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;

4408: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;

4409: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;

Line 4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;

4410: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;

Line 4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

4411: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;

Line 4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

4412: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4413: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;

Line 4418: l_notepad ghr_pa_routing_history.notepad%type;

4414: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;

Line 4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;

4415: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;

Line 4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;

4416: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;

Line 4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;

4417: l_result boolean;
4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4425:

Line 4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;

4418: l_notepad ghr_pa_routing_history.notepad%type;
4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4425:
4426:

Line 4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;

4419: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4425:
4426:
4427:

Line 4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;

4420: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4421: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4422: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4423: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4424: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4425:
4426:
4427:
4428: cursor c_count_history is

Line 4430: from ghr_pa_routing_history prh

4426:
4427:
4428: cursor c_count_history is
4429: select count(*) cnt
4430: from ghr_pa_routing_history prh
4431: where prh.pa_request_id = p_pa_request_id;
4432:
4433:
4434: cursor C_routing_history_id is

Line 4460: from ghr_pa_routing_history prh

4456: prh.noa_family_code,
4457: prh.second_nature_of_action_id,
4458: prh.object_version_number
4459: -- prh.approval_status
4460: from ghr_pa_routing_history prh
4461: where prh.pa_request_id = p_pa_request_id
4462: Order by prh.pa_routing_history_id desc;
4463:
4464: