[Home] [Help]
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;
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;
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
272: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
273: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
274: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%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
272: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
273: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
274: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
275: l_flag varchar2(1);
276: l_position_id hr_all_positions_f.position_id%type;
275: l_flag varchar2(1);
276: l_position_id hr_all_positions_f.position_id%type;
277: l_employee_id per_people_f.person_id%type;
278: l_approval_date date;
279: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
280: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
281: l_sf50_approval_date date;
282: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
283: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
276: l_position_id hr_all_positions_f.position_id%type;
277: l_employee_id per_people_f.person_id%type;
278: l_approval_date date;
279: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
280: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
281: l_sf50_approval_date date;
282: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
283: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
284: l_status ghr_pa_requests.status%type;
278: l_approval_date date;
279: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
280: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
281: l_sf50_approval_date date;
282: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
283: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
284: l_status ghr_pa_requests.status%type;
285: l_message boolean := FALSE;
286: l_asg_sf52 ghr_api.asg_sf52_type;
279: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
280: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
281: l_sf50_approval_date date;
282: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
283: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
284: l_status ghr_pa_requests.status%type;
285: l_message boolean := FALSE;
286: l_asg_sf52 ghr_api.asg_sf52_type;
287: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
280: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
281: l_sf50_approval_date date;
282: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
283: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
284: l_status ghr_pa_requests.status%type;
285: l_message boolean := FALSE;
286: l_asg_sf52 ghr_api.asg_sf52_type;
287: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
288: l_asg_nte_dates ghr_api.asg_nte_dates_type;
386: WHERE gbx.groupbox_id = l_2_groupbox_id;
387:
388: CURSOR c_ovn IS
389: SELECT par.object_version_number
390: FROM ghr_pa_requests par
391: WHERE par.pa_request_id = l_pa_request_id;
392:
393:
394: l_capped_other_pay number;
391: WHERE par.pa_request_id = l_pa_request_id;
392:
393:
394: l_capped_other_pay number;
395: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
396: begin
397: hr_utility.set_location('Entering:'|| l_proc, 5);
398:
399: -- Issue a savepoint if operating in validation only mode.
671: l_employee_id := user_emp_name.employee_id;
672: end loop;
673: if l_employee_id is not null then
674: -- get the working title of the approver -- would be as of today
675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
676: (p_person_id => l_employee_id
677: );
678: End if;
679: Else
704: l_employee_id := user_emp_name.employee_id;
705: end loop;
706: if l_employee_id is not null then
707: -- get the working title of the approver -- would be as of today
708: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
709: (p_person_id => l_employee_id
710: --p_effective_date => l_effective_date
711: );
712: End if;
788: p_from_grade_or_level => p_from_grade_or_level,
789: p_from_locality_adj => p_from_locality_adj,
790: p_from_occ_code => p_from_occ_code,
791: -- Bug 2353506
792: p_from_other_pay_amount => nvl(ghr_pa_requests_pkg2.get_cop
793: (p_employee_assignment_id, p_effective_date),
794: p_from_other_pay_amount),
795: -- End Bug 2353506
796: p_from_pay_basis => p_from_pay_basis,
1058: -- 3)Derive all parmeters required to insert routing_history records.
1059: -- Roles , Action_taken (and sequence Number if necessary)
1060:
1061: if p_1_user_name_acted_on is not null then
1062: ghr_pa_requests_pkg.get_roles
1063: (l_pa_request_id,
1064: p_routing_group_id,
1065: p_1_user_name_acted_on,
1066: l_initiator_flag,
2159:
2160: l_proc varchar2(72) := g_package||'update_sf52';
2161: l_exists boolean := false;
2162: l_cnt_history number;
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;
2160: l_proc varchar2(72) := g_package||'update_sf52';
2161: l_exists boolean := false;
2162: l_cnt_history number;
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;
2161: l_exists boolean := false;
2162: l_cnt_history number;
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;
2162: l_cnt_history number;
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;
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;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%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;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%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;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
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;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2193: l_rei_rec ghr_pa_request_extra_info%rowtype;
2194: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2194: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2204: l_creation_date ghr_pa_requests.creation_date%type;
2197: l_veterans_pref_for_rif ghr_pa_requests.veterans_pref_for_rif%type;
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2204: l_creation_date ghr_pa_requests.creation_date%type;
2205: l_flag varchar2(1);
2198: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2204: l_creation_date ghr_pa_requests.creation_date%type;
2205: l_flag varchar2(1);
2206: l_information_type ghr_pa_request_info_types.information_type%type;
2199: l_noa_family_code ghr_pa_requests.noa_family_code%type;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2204: l_creation_date ghr_pa_requests.creation_date%type;
2205: l_flag varchar2(1);
2206: l_information_type ghr_pa_request_info_types.information_type%type;
2207: l_set_print_options_status boolean;
2200: l_last_update_date ghr_pa_requests.last_update_date%type;
2201: l_last_updated_by ghr_pa_requests.last_updated_by%type;
2202: l_last_update_login ghr_pa_requests.last_update_login%type;
2203: l_created_by ghr_pa_requests.created_by%type;
2204: l_creation_date ghr_pa_requests.creation_date%type;
2205: l_flag varchar2(1);
2206: l_information_type ghr_pa_request_info_types.information_type%type;
2207: l_set_print_options_status boolean;
2208: l_request_status number(15);
2206: l_information_type ghr_pa_request_info_types.information_type%type;
2207: l_set_print_options_status boolean;
2208: l_request_status number(15);
2209: l_employee_id per_people_f.person_id%type;
2210: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2211: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;
2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2207: l_set_print_options_status boolean;
2208: l_request_status number(15);
2209: l_employee_id per_people_f.person_id%type;
2210: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2211: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;
2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2210: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
2211: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;
2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2211: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;
2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2212: l_approval_date date;
2213: l_sf50_approval_date date;
2214: l_sf50_approving_ofcl_work_tit ghr_pa_requests.sf50_approving_ofcl_work_title%type;
2215: l_sf50_approving_ofcl_full_nam ghr_pa_requests.sf50_approving_ofcl_full_name%type;
2216: l_status ghr_pa_requests.status%type;
2217: l_message boolean := FALSE;
2218: l_asg_sf52 ghr_api.asg_sf52_type;
2219: l_asg_non_sf52 ghr_api.asg_non_sf52_type;
2220: l_asg_nte_dates ghr_api.asg_nte_dates_type;
2266: l_imm_severance_pay ghr_api.severance_pay_type;
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2273: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2274:
2267: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
2268: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
2269: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
2270: l_rpa_type ghr_pa_requests.rpa_type%type;
2271: l_mass_action_id ghr_pa_requests.mass_action_id%type;
2272: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
2273: l_imm_retirement_info ghr_api.per_retirement_info_type; --Bug# 7131104
2274:
2275:
2286: ORDER by prh.pa_routing_history_id desc;
2287:
2288: CURSOR c_routing_group_id IS
2289: SELECT par.routing_group_id
2290: FROM ghr_pa_requests par
2291: WHERE par.pa_request_id = p_pa_request_id;
2292:
2293: /* cursor c_names is
2294: select usr.employee_id,
2349: par.last_updated_by,
2350: par.last_update_login,
2351: par.created_by,
2352: par.creation_date
2353: FROM ghr_pa_requests par
2354: WHERE pa_request_id = p_pa_request_id;
2355:
2356: CURSOR c_rei_rec IS
2357: SELECT pa_request_extra_info_id,
2361: AND rei.information_type = l_information_type;
2362:
2363: CURSOR c_ovn IS
2364: SELECT par.object_version_number
2365: FROM ghr_pa_requests par
2366: WHERE par.pa_request_id = p_pa_request_id;
2367:
2368: CURSOR c_get_det_for_cop IS
2369: SELECT par.employee_assignment_id,par.effective_date
2366: WHERE par.pa_request_id = p_pa_request_id;
2367:
2368: CURSOR c_get_det_for_cop IS
2369: SELECT par.employee_assignment_id,par.effective_date
2370: FROM ghr_pa_requests par
2371: WHERE par.pa_request_id = p_pa_request_id;
2372:
2373: begin
2374: hr_utility.set_location('Entering:'|| l_proc, 5);
2671: l_employee_id := user_emp_name.employee_id;
2672: end loop;
2673: if l_employee_id is not null then
2674: -- get the working title of the approver -- would it be as of today
2675: l_approving_official_work_titl := ghr_pa_requests_pkg.get_position_work_title
2676: (p_person_id => l_employee_id,
2677: p_effective_date => l_effective_date
2678: );
2679: End if;
2713: l_employee_id := user_emp_name.employee_id;
2714: end loop;
2715: if l_employee_id is not null then
2716: -- get the working title of the approver -- would be as of today
2717: l_sf50_approving_ofcl_work_tit := ghr_pa_requests_pkg.get_position_work_title
2718: (p_person_id => l_employee_id
2719: );
2720: End if;
2721: End if;
2738: -- Bug 2542417
2739: -- In some cases like Mass actions/Cancellation actions the assignment id and
2740: -- and effective_date are not available to fetch the capped other pay
2741: -- Below code fetches the effective_date and assignment id to be passed to
2742: -- ghr_pa_requests_pkg2.get_cop function
2743:
2744: for c_par in c_get_det_for_cop loop
2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);
2745: hr_utility.set_location('c_par.employee_assignment_id : '
2746: ||c_par.employee_assignment_id, 8);
2747: hr_utility.set_location('c_par.effective_date : '
2748: ||c_par.effective_date, 8);
2749: l_from_cop := nvl(ghr_pa_requests_pkg2.get_cop
2750: (nvl(p_employee_assignment_id,c_par.employee_assignment_id)
2751: ,c_par.effective_date)
2752: ,p_from_other_pay_amount);
2753: end loop;
3262: -- RP
3263: and p_u_user_name_acted_on <> hr_api.g_varchar2 then
3264: hr_utility.set_location(l_proc, 12);
3265:
3266: ghr_pa_requests_pkg.get_roles
3267: (p_pa_request_id,
3268: p_routing_group_id,
3269: p_u_user_name_acted_on,
3270: l_initiator_flag,
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;
4162: l_initiator_flag ghr_pa_routing_history.initiator_flag%TYPE;
4163: l_requester_flag ghr_pa_routing_history.requester_flag%TYPE;
4222:
4223: cursor c_request_details is
4224: select par.effective_date,
4225: par.routing_group_id
4226: from ghr_pa_requests par
4227: where par.pa_request_id = p_pa_request_id;
4228:
4229:
4230: /* cursor c_names is
4400: */
4401:
4402:
4403: If l_user_name is not null then
4404: ghr_pa_requests_pkg.get_roles
4405: (p_pa_request_id,
4406: l_routing_group_id,
4407: l_user_name,
4408: l_initiator_flag,
4531: select rowid row_id,
4532: first_noa_code,
4533: second_noa_code,
4534: object_version_number
4535: from ghr_pa_requests
4536: where pa_request_id = cp_pa_request_id
4537: for update;
4538:
4539: l_req c_get_req%rowtype;
4584:
4585: --Bug#3757201 Added p_back_page parameter
4586: Procedure submit_request_to_print_50
4587: (p_printer_name in varchar2,
4588: p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4589: p_effective_date in date,
4590: p_user_name in varchar2,
4591: p_back_page in varchar2
4592: )
4685: End get_par_status;
4686:
4687:
4688: Procedure check_for_open_events
4689: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4690: p_action_taken in varchar2,
4691: p_user_name_acted_on in varchar2,
4692: p_user_name_routed_to in varchar2,
4693: p_groupbox_routed_to in number,
4700:
4701: cursor c_open_events is
4702: select 1
4703: from ghr_event_history
4704: where table_name = 'GHR_PA_REQUESTS'
4705: and record_id = p_pa_request_id
4706: and start_date is not null
4707: and end_date is null;
4708: