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.

[Home] [Help]

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: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

Line 265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%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: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
268: l_temp number(15);
269: --l_rec ghr_par_shd.g_old_rec%type;

Line 266: l_2_user_name ghr_pa_routing_history.user_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: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
268: l_temp number(15);
269: --l_rec ghr_par_shd.g_old_rec%type;
270: l_rec ghr_pa_requests%rowtype;

Line 267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

263: l_2_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
264: l_forward_to_name ghr_groupboxes.name%TYPE;
265: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
266: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
267: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
268: l_temp number(15);
269: --l_rec ghr_par_shd.g_old_rec%type;
270: l_rec ghr_pa_requests%rowtype;
271: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available

Line 380: FROM ghr_pa_routing_history prh

376:
377:
378: CURSOR c_history_exists IS
379: SELECT 1
380: FROM ghr_pa_routing_history prh
381: WHERE prh.pa_request_id = l_pa_request_id;
382:
383: CURSOR c_groupbox_name IS
384: SELECT gbx.name

Line 2167: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

2163: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
2164: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2165: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2166: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2167: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));

Line 2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

2164: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
2165: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2166: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2167: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

Line 2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

2165: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;
2166: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2167: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

Line 2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

2166: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
2167: l_u_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

Line 2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

2168: l_i_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

Line 2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

2169: l_u_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

2170: l_i_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;

Line 2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

2171: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;

Line 2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

2172: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;

Line 2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

2173: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
2174: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
2175: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
2176: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
2177: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;

Line 2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2178: l_user_name_employee_id per_people_f.person_id%TYPE;
2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

Line 2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2179: l_user_name_emp_first_name per_people_f.first_name%TYPE;
2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;

Line 2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;

2180: l_user_name_emp_last_name per_people_f.last_name%TYPE;
2181: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

Line 2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

2182: l_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;

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

2183: l_cur_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;
2191: l_rec ghr_pa_requests%rowtype;

Line 2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

2184: l_next_seq_numb ghr_pa_routing_history.routing_seq_number%TYPE;
2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;
2191: l_rec ghr_pa_requests%rowtype;
2192: -- l_rec ghr_par_shd.g_old_rec%type;

Line 2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;

2185: l_next_groupbox_name ghr_groupboxes.name%TYPE;
2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;
2191: l_rec ghr_pa_requests%rowtype;
2192: -- l_rec ghr_par_shd.g_old_rec%type;
2193: l_rei_rec ghr_pa_request_extra_info%rowtype;

Line 2190: l_forward_to_name ghr_pa_routing_history.user_name%type;

2186: l_next_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
2187: l_next_user_name ghr_pa_routing_history.user_name%TYPE := p_i_user_name_routed_to;
2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;
2191: l_rec ghr_pa_requests%rowtype;
2192: -- l_rec ghr_par_shd.g_old_rec%type;
2193: l_rei_rec ghr_pa_request_extra_info%rowtype;
2194: l_part_time_hours ghr_pa_requests.part_time_hours%type;

Line 2278: FROM ghr_pa_routing_history prh

2274:
2275:
2276: CURSOR c_cnt_history IS
2277: SELECT count(*) cnt
2278: FROM ghr_pa_routing_history prh
2279: WHERE prh.pa_request_id = p_pa_request_id;
2280:
2281: CURSOR C_routing_history_id IS
2282: SELECT prh.pa_routing_history_id,

Line 2284: FROM ghr_pa_routing_history prh

2280:
2281: CURSOR C_routing_history_id IS
2282: SELECT prh.pa_routing_history_id,
2283: prh.object_version_number
2284: FROM ghr_pa_routing_history prh
2285: WHERE prh.pa_request_id = p_pa_request_id
2286: ORDER by prh.pa_routing_history_id desc;
2287:
2288: CURSOR c_routing_group_id IS

Line 2321: FROM ghr_pa_routing_history prh

2317: AND effective_end_date;
2318:
2319: CURSOR cur_rout_list_used IS
2320: SELECT prh.routing_seq_number
2321: FROM ghr_pa_routing_history prh
2322: WHERE prh.pa_request_id = p_pa_request_id
2323: AND prh.routing_list_id = p_i_routing_list_id
2324: ORDER BY prh.pa_routing_history_id desc;
2325:

Line 2338: FROM ghr_pa_routing_history prh

2334:
2335:
2336: CURSOR c_history_exists IS
2337: SELECT action_taken
2338: FROM ghr_pa_routing_history prh
2339: WHERE prh.pa_request_id = p_pa_request_id;
2340:
2341: CURSOR c_groupbox_name IS
2342: SELECT gbx.name

Line 4156: l_prh_rec ghr_pa_routing_history%rowtype;

4152: )is
4153:
4154: l_proc varchar2(72) := g_package||'end_sf52';
4155: l_effective_date date;
4156: l_prh_rec ghr_pa_routing_history%rowtype;
4157: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4158: l_count number;
4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;

Line 4157: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

4153:
4154: l_proc varchar2(72) := g_package||'end_sf52';
4155: l_effective_date date;
4156: l_prh_rec ghr_pa_routing_history%rowtype;
4157: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4158: l_count number;
4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;

Line 4160: l_user_name ghr_pa_routing_history.user_name%type;

4156: l_prh_rec ghr_pa_routing_history%rowtype;
4157: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4158: l_count number;
4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

Line 4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;

4157: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4158: l_count number;
4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

Line 4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;

4158: l_count number;
4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

Line 4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

4159: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

Line 4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;

4160: l_user_name ghr_pa_routing_history.user_name%type;
4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;

Line 4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;

4161: l_old_action_taken ghr_pa_routing_history.action_taken%type;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;

Line 4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;

4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;

Line 4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;

4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;

Line 4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;

4164: l_authorizer_flag ghr_pa_routing_history.authorizer_flag%TYPE;
4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;

4165: l_approver_flag ghr_pa_routing_history.approver_flag%TYPE;
4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;

4166: l_reviewer_flag ghr_pa_routing_history.reviewer_flag%TYPE;
4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;

Line 4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;

4167: l_personnelist_flag ghr_pa_routing_history.personnelist_flag%TYPE;
4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;

Line 4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

4168: l_user_name_employee_id ghr_pa_routing_history.user_name_employee_id%TYPE;
4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;

Line 4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

4169: l_user_name_emp_first_name ghr_pa_routing_history.user_name_emp_first_name%TYPE;
4170: l_user_name_emp_last_name ghr_pa_routing_history.user_name_emp_last_name%TYPE;
4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;

Line 4175: l_notepad ghr_pa_routing_history.notepad%type;

4171: l_user_name_emp_middle_names ghr_pa_routing_history.user_name_emp_middle_names%TYPE;
4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;

Line 4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;

4172: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;

Line 4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;

4173: l_par_object_version_number ghr_pa_routing_history.object_version_number%TYPE;
4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;

Line 4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;

4174: l_result boolean;
4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4182:

Line 4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;

4175: l_notepad ghr_pa_routing_history.notepad%type;
4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4182:
4183:

Line 4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;

4176: l_noa_family_code ghr_pa_routing_history.noa_family_code%type;
4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4182:
4183:
4184:

Line 4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;

4177: l_first_noa_id ghr_pa_routing_history.nature_of_action_id%type;
4178: l_Second_noa_id ghr_pa_routing_history.second_nature_of_action_id%type;
4179: l_groupbox_id ghr_pa_routing_history.groupbox_id%type;
4180: l_routing_list_id ghr_pa_routing_history.routing_list_id%type;
4181: l_routing_seq_number ghr_pa_routing_history.routing_seq_number%type;
4182:
4183:
4184:
4185: cursor c_count_history is

Line 4187: from ghr_pa_routing_history prh

4183:
4184:
4185: cursor c_count_history is
4186: select count(*) cnt
4187: from ghr_pa_routing_history prh
4188: where prh.pa_request_id = p_pa_request_id;
4189:
4190:
4191: cursor C_routing_history_id is

Line 4217: from ghr_pa_routing_history prh

4213: prh.noa_family_code,
4214: prh.second_nature_of_action_id,
4215: prh.object_version_number
4216: -- prh.approval_status
4217: from ghr_pa_routing_history prh
4218: where prh.pa_request_id = p_pa_request_id
4219: Order by prh.pa_routing_history_id desc;
4220:
4221: