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_REQUESTS

Line 249: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

245: --
246:
247: l_proc varchar2(72) := g_package||'create_sf52';
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;

Line 251: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;

247: l_proc varchar2(72) := g_package||'create_sf52';
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;

Line 271: l_rec ghr_pa_requests%rowtype;

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
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;

Line 273: l_par_object_version_number ghr_pa_requests.object_version_number%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
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;

Line 280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;

276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;
279: l_approval_date date;
280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;
283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;

Line 281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;

277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;
279: l_approval_date date;
280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;
283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;

Line 283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;

279: l_approval_date date;
280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;
283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;

Line 284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;

280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;
283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

Line 285: l_status ghr_pa_requests.status%type;

281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
282: l_sf50_approval_date date;
283: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
284: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
285: l_status ghr_pa_requests.status%type;
286: l_message boolean := FALSE;
287: l_asg_sf52 ghr_api.asg_sf52_type;
288: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
289: l_asg_nte_dates ghr_api.asg_nte_dates_type;

Line 396: FROM ghr_pa_requests par

392: WHERE gbx.groupbox_id = l_2_groupbox_id;
393:
394: CURSOR c_ovn IS
395: SELECT par.object_version_number
396: FROM ghr_pa_requests par
397: WHERE par.pa_request_id = l_pa_request_id;
398: --Begin Bug# 7174094
399: l_separation_flag BOOLEAN;
400:

Line 415: l_assignment_id ghr_pa_requests.employee_assignment_id%type;

411: and nvl(noafam.end_date_active,to_date('4712/12/31','RRRR/MM/DD'));
412: --End Bug# 7174094
413:
414: l_capped_other_pay number;
415: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
416:
417: --Bug# 6127620
418: -- l_curr_sess_date fnd_sessions.effective_date%type;
419:

Line 699: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title

695: l_employee_id := user_emp_name.employee_id;
696: end loop;
697: if l_employee_id is not null then
698: -- get the working title of the approver -- would be as of today
699: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
700: (p_person_id => l_employee_id
701: );
702: End if;
703: Else

Line 732: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title

728: l_employee_id := user_emp_name.employee_id;
729: end loop;
730: if l_employee_id is not null then
731: -- get the working title of the approver -- would be as of today
732: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
733: (p_person_id => l_employee_id
734: --p_effective_date => l_effective_date
735: );
736: End if;

Line 816: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop

812: p_from_grade_or_level => p_from_grade_or_level,
813: p_from_locality_adj => p_from_locality_adj,
814: p_from_occ_code => p_from_occ_code,
815: -- Bug 2353506
816: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop
817: (p_employee_assignment_id, p_effective_date),
818: p_from_other_pay_amount),
819: -- End Bug 2353506
820: p_from_pay_basis => p_from_pay_basis,

Line 1122: ghr_pa_requests_pkg.get_roles

1118: -- 3)Derive all parmeters required to insert routing_history records.
1119: -- Roles , Action_taken (and sequence Number if necessary)
1120:
1121: if p_1_user_name_acted_on is not null then
1122: ghr_pa_requests_pkg.get_roles
1123: (l_pa_request_id,
1124: p_routing_group_id,
1125: p_1_user_name_acted_on,
1126: l_initiator_flag,

Line 2237: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

2233:
2234: l_proc varchar2(72) := g_package||'update_sf52';
2235: l_exists boolean := false;
2236: l_cnt_history number;
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;

Line 2238: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;

2234: l_proc varchar2(72) := g_package||'update_sf52';
2235: l_exists boolean := false;
2236: l_cnt_history number;
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;

Line 2239: l_from_cop ghr_pa_requests.from_other_pay_amount%TYPE;

2235: l_exists boolean := false;
2236: l_cnt_history number;
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;

Line 2240: l_object_version_number ghr_pa_requests.object_version_number%TYPE;

2236: l_cnt_history number;
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;

Line 2265: l_rec ghr_pa_requests%rowtype;

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;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;

Line 2268: l_part_time_hours ghr_pa_requests.part_time_hours%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;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

Line 2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%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;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;

Line 2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;

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;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;

Line 2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;

2267: l_rei_rec ghr_pa_request_extra_info%rowtype;
2268: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;

Line 2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

2268: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;

Line 2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;

2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;

Line 2274: l_last_update_date ghr_pa_requests.last_update_date%type;

2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;
2278: l_creation_date ghr_pa_requests.creation_date%type;

Line 2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;

2271: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;
2278: l_creation_date ghr_pa_requests.creation_date%type;
2279: l_flag varchar2(1);

Line 2276: l_last_update_login ghr_pa_requests.last_update_login%type;

2272: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;
2278: l_creation_date ghr_pa_requests.creation_date%type;
2279: l_flag varchar2(1);
2280: l_information_type ghr_pa_request_info_types.information_type%type;

Line 2277: l_created_by ghr_pa_requests.created_by%type;

2273: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;
2278: l_creation_date ghr_pa_requests.creation_date%type;
2279: l_flag varchar2(1);
2280: l_information_type ghr_pa_request_info_types.information_type%type;
2281: l_set_print_options_status boolean;

Line 2278: l_creation_date ghr_pa_requests.creation_date%type;

2274: l_last_update_date ghr_pa_requests.last_update_date%type;
2275: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2276: l_last_update_login ghr_pa_requests.last_update_login%type;
2277: l_created_by ghr_pa_requests.created_by%type;
2278: l_creation_date ghr_pa_requests.creation_date%type;
2279: l_flag varchar2(1);
2280: l_information_type ghr_pa_request_info_types.information_type%type;
2281: l_set_print_options_status boolean;
2282: l_request_status number(15);

Line 2284: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;

2280: l_information_type ghr_pa_request_info_types.information_type%type;
2281: l_set_print_options_status boolean;
2282: l_request_status number(15);
2283: l_employee_id per_people_f.person_id%type;
2284: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2286: l_approval_date date;
2287: l_sf50_approval_date date;
2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;

Line 2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;

2281: l_set_print_options_status boolean;
2282: l_request_status number(15);
2283: l_employee_id per_people_f.person_id%type;
2284: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2286: l_approval_date date;
2287: l_sf50_approval_date date;
2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;

Line 2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;

2284: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2286: l_approval_date date;
2287: l_sf50_approval_date date;
2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;

Line 2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;

2285: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2286: l_approval_date date;
2287: l_sf50_approval_date date;
2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;

Line 2290: l_status ghr_pa_requests.status%type;

2286: l_approval_date date;
2287: l_sf50_approval_date date;
2288: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2289: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2290: l_status ghr_pa_requests.status%type;
2291: l_message boolean := FALSE;
2292: l_asg_sf52 ghr_api.asg_sf52_type;
2293: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2294: l_asg_nte_dates ghr_api.asg_nte_dates_type;

Line 2344: l_rpa_type ghr_pa_requests.rpa_type%type;

2340: l_imm_severance_pay ghr_api.severance_pay_type;
2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661

Line 2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;

2341: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2342: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2343: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2344: l_rpa_type ghr_pa_requests.rpa_type%type;
2345: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2346: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2347: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2348: --Begin Bug# 10181661
2349: l_imm_asg_detail_info ghr_api.asg_detail_info_type;

Line 2368: FROM ghr_pa_requests par

2364: ORDER by prh.pa_routing_history_id desc;
2365:
2366: CURSOR c_routing_group_id IS
2367: SELECT par.routing_group_id
2368: FROM ghr_pa_requests par
2369: WHERE par.pa_request_id = p_pa_request_id;
2370:
2371: /* cursor c_names is
2372: select usr.employee_id,

Line 2432: FROM ghr_pa_requests par

2428: par.last_updated_by,
2429: par.last_update_login,
2430: par.created_by,
2431: par.creation_date
2432: FROM ghr_pa_requests par
2433: WHERE pa_request_id = p_pa_request_id;
2434:
2435: CURSOR c_rei_rec IS
2436: SELECT pa_request_extra_info_id,

Line 2444: FROM ghr_pa_requests par

2440: AND rei.information_type = l_information_type;
2441:
2442: CURSOR c_ovn IS
2443: SELECT par.object_version_number
2444: FROM ghr_pa_requests par
2445: WHERE par.pa_request_id = p_pa_request_id;
2446:
2447: CURSOR c_get_det_for_cop IS
2448: SELECT par.employee_assignment_id,par.effective_date

Line 2449: FROM ghr_pa_requests par

2445: WHERE par.pa_request_id = p_pa_request_id;
2446:
2447: CURSOR c_get_det_for_cop IS
2448: SELECT par.employee_assignment_id,par.effective_date
2449: FROM ghr_pa_requests par
2450: WHERE par.pa_request_id = p_pa_request_id;
2451:
2452: --6976674
2453: CURSOR c_dual_cancel

Line 2456: from ghr_pa_requests

2452: --6976674
2453: CURSOR c_dual_cancel
2454: is
2455: select pa_request_id
2456: from ghr_pa_requests
2457: where pa_request_id in (select mass_action_id
2458: from ghr_pa_requests
2459: where pa_request_id = p_pa_request_id
2460: and first_noa_code = '001'

Line 2458: from ghr_pa_requests

2454: is
2455: select pa_request_id
2456: from ghr_pa_requests
2457: where pa_request_id in (select mass_action_id
2458: from ghr_pa_requests
2459: where pa_request_id = p_pa_request_id
2460: and first_noa_code = '001'
2461: and mass_action_id is not null
2462: and rpa_type = 'DUAL')

Line 2471: from ghr_pa_requests

2467: --8286910
2468: cursor c_dual_sec_corr
2469: is
2470: select 1
2471: from ghr_pa_requests
2472: where pa_request_id = p_pa_request_id
2473: and mass_action_id < pa_request_id
2474: and rpa_type = 'DUAL'
2475: and second_noa_code = (select second_noa_code

Line 2476: from ghr_pa_requests

2472: where pa_request_id = p_pa_request_id
2473: and mass_action_id < pa_request_id
2474: and rpa_type = 'DUAL'
2475: and second_noa_code = (select second_noa_code
2476: from ghr_pa_requests
2477: where pa_request_id = (select min(pa_request_id)
2478: from ghr_pa_requests
2479: where pa_notification_id is not null
2480: connect by pa_request_id = prior altered_pa_request_id

Line 2478: from ghr_pa_requests

2474: and rpa_type = 'DUAL'
2475: and second_noa_code = (select second_noa_code
2476: from ghr_pa_requests
2477: where pa_request_id = (select min(pa_request_id)
2478: from ghr_pa_requests
2479: where pa_notification_id is not null
2480: connect by pa_request_id = prior altered_pa_request_id
2481: start with pa_request_id = p_pa_request_id));
2482:

Line 2486: from ghr_pa_requests

2482:
2483: cursor c_first_corr_npa(p_first_pa_req_id in number)
2484: is
2485: select 1
2486: from ghr_pa_requests
2487: where pa_request_id = p_first_pa_req_id
2488: and pa_notification_id is not null;
2489: --8286910
2490: --Begin Bug# 8510411

Line 2492: l_to_position_id ghr_pa_requests.to_position_id%type;

2488: and pa_notification_id is not null;
2489: --8286910
2490: --Begin Bug# 8510411
2491:
2492: l_to_position_id ghr_pa_requests.to_position_id%type;
2493:
2494: CURSOR c_to_pos_id IS
2495: SELECT to_position_id FROM ghr_pa_requests
2496: WHERE pa_request_id = p_pa_request_id;

Line 2495: SELECT to_position_id FROM ghr_pa_requests

2491:
2492: l_to_position_id ghr_pa_requests.to_position_id%type;
2493:
2494: CURSOR c_to_pos_id IS
2495: SELECT to_position_id FROM ghr_pa_requests
2496: WHERE pa_request_id = p_pa_request_id;
2497: --End Bug# 8510411
2498:
2499: --Bug# 6127620

Line 2819: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title

2815: l_employee_id := user_emp_name.employee_id;
2816: end loop;
2817: if l_employee_id is not null then
2818: -- get the working title of the approver -- would it be as of today
2819: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
2820: (p_person_id => l_employee_id,
2821: p_effective_date => l_effective_date
2822: );
2823: End if;

Line 2861: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title

2857: l_employee_id := user_emp_name.employee_id;
2858: end loop;
2859: if l_employee_id is not null then
2860: -- get the working title of the approver -- would be as of today
2861: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
2862: (p_person_id => l_employee_id
2863: );
2864: End if;
2865: End if;

Line 2886: -- ghr_pa_requests_pkg2.get_cop function

2882: -- Bug 2542417
2883: -- In some cases like Mass actions/Cancellation actions the assignment id and
2884: -- and effective_date are not available to fetch the capped other pay
2885: -- Below code fetches the effective_date and assignment id to be passed to
2886: -- ghr_pa_requests_pkg2.get_cop function
2887:
2888: for c_par in c_get_det_for_cop loop
2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);

Line 2893: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop

2889: hr_utility.set_location('c_par.employee_assignment_id : '
2890: ||c_par.employee_assignment_id, 8);
2891: hr_utility.set_location('c_par.effective_date : '
2892: ||c_par.effective_date, 8);
2893: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2894: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2895: ,c_par.effective_date)
2896: ,p_from_other_pay_amount);
2897: end loop;

Line 3445: ghr_pa_requests_pkg.get_roles

3441: -- RP
3442: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3443: hr_utility.set_location(l_proc, 12);
3444:
3445: ghr_pa_requests_pkg.get_roles
3446: (p_pa_request_id,
3447: p_routing_group_id,
3448: p_u_user_name_acted_on,
3449: l_initiator_flag,

Line 4402: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

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;
4405: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4406: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;

Line 4469: from ghr_pa_requests par

4465:
4466: cursor c_request_details is
4467: select par.effective_date,
4468: par.routing_group_id
4469: from ghr_pa_requests par
4470: where par.pa_request_id = p_pa_request_id;
4471:
4472:
4473: /* cursor c_names is

Line 4647: ghr_pa_requests_pkg.get_roles

4643: */
4644:
4645:
4646: If l_user_name is not null then
4647: ghr_pa_requests_pkg.get_roles
4648: (p_pa_request_id,
4649: l_routing_group_id,
4650: l_user_name,
4651: l_initiator_flag,

Line 4778: from ghr_pa_requests

4774: select rowid row_id,
4775: first_noa_code,
4776: second_noa_code,
4777: object_version_number
4778: from ghr_pa_requests
4779: where pa_request_id = cp_pa_request_id
4780: for update;
4781:
4782: l_req c_get_req%rowtype;

Line 4831: p_pa_request_id in ghr_pa_requests.pa_request_id%type,

4827:
4828: --Bug#3757201 Added p_back_page parameter
4829: Procedure submit_request_to_print_50
4830: (p_printer_name in varchar2,
4831: p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4832: p_effective_date in date,
4833: p_user_name in varchar2,
4834: p_back_page in varchar2
4835: )

Line 4936: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

4932: End get_par_status;
4933:
4934:
4935: Procedure check_for_open_events
4936: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4937: p_action_taken in varchar2,
4938: p_user_name_acted_on in varchar2,
4939: p_user_name_routed_to in varchar2,
4940: p_groupbox_routed_to in number,

Line 4951: where table_name = 'GHR_PA_REQUESTS'

4947:
4948: cursor c_open_events is
4949: select 1
4950: from ghr_event_history
4951: where table_name = 'GHR_PA_REQUESTS'
4952: and record_id = p_pa_request_id
4953: and start_date is not null
4954: and end_date is null;
4955:

Line 5059: l_detail_pay_plan ghr_pa_requests.from_pay_plan%type;

5055:
5056: l_detail_position_name hr_all_positions_f.name%type;
5057: l_detail_grade PER_GRADES.name%type;
5058: l_detail_job HR_LOOKUPS.MEANING%type;
5059: l_detail_pay_plan ghr_pa_requests.from_pay_plan%type;
5060: l_detail_location varchar2(200);
5061: l_record_found BOOLEAN default FALSE;
5062:
5063: BEGIN

Line 5253: l_detail_job := SUBSTR(ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_OCC_SERIES',l_detail_job_id),1,80);

5249: BEGIN
5250: l_remk_desc:= NULL;
5251: l_pa_remark_id := NULL;
5252: l_rem_ovn := NULL;
5253: l_detail_job := SUBSTR(ghr_pa_requests_pkg.get_lookup_meaning(800,'GHR_US_OCC_SERIES',l_detail_job_id),1,80);
5254: ghr_mass_actions_pkg.get_remark_id_desc
5255: (p_remark_code => 'ZK8',--Bug# 9928813
5256: p_effective_date => p_effective_date,
5257: p_remark_id => l_remark_id,