[Home] [Help]
26:
27: -- Declaring local procedures and functions
28: Procedure delete_element_entry(
29: p_hist_rec in ghr_pa_history%rowtype,
30: p_del_mode in varchar2 default hr_api.g_delete_next_change,
31: p_cannot_cancel out nocopy Boolean) ;
32:
33: Procedure delete_eleentval( p_hist_rec in ghr_pa_history%rowtype) ;
34: Procedure delete_peop_row(
186: l_interv_on_eff_date boolean;
187: l_hist_data_as_of_date ghr_pa_history%rowtype;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
187: l_hist_data_as_of_date ghr_pa_history%rowtype;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
263: l_sf52_data ghr_pa_requests%rowtype;
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
263: l_sf52_data ghr_pa_requests%rowtype;
264: l_sf52_data_rec ghr_pa_requests%rowtype;
265: l_health_plan varchar2(30);
389: --BUG # 13571004 added TSP Roth
390: p_imm_tsp_roth => l_imm_roth_tsp
391: );
392: --
393: ghr_api.retrieve_element_entry_value
394: ( p_element_name => 'Health Benefits'
395: ,p_input_value_name => 'Health Plan'
396: ,p_assignment_id => l_sf52_data.employee_assignment_id
397: ,p_effective_date => trunc(l_sf52_data.effective_date)
572: close c_hist_sevpay;
573: else
574:
575: delete_element_entry( p_hist_rec => l_hist_sevpay,
576: p_del_mode => hr_api.g_zap,
577: p_cannot_cancel => l_cannot_cancel_sevpay);
578:
579: if l_cannot_cancel_sevpay then
580: -- raise error
681: delete_hist_row( l_hist.row_id);
682: end loop;
683:
684: -- Moved after history handling due to bug# 1316321
685: -- call core HR api to cancel the termination.
686: hrempter.cancel_termination(
687: p_person_id => p_sf52_data.person_id,
688: p_Actual_termination_date => p_sf52_data.effective_date
689: );
812: l_u_prh_object_version_number number;
813: l_i_pa_routing_history_id number;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
813: l_i_pa_routing_history_id number;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
884: l_health_plan varchar2(30);
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
884: l_health_plan varchar2(30);
885: l_error_flag boolean;
889: l_cao_effective_date date;
890: l_cancel_effective_date date;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
890: l_cancel_effective_date date;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
899:
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
899:
900:
901: -- this cursor gets the business_group_id for the person_id/effective_date passed.
902: cursor c_bg ( c_person_id number,
1102: --BUG # 13571004 added TSP Roth
1103: p_imm_tsp_roth => l_imm_roth_tsp
1104: );
1105:
1106: ghr_api.retrieve_element_entry_value
1107: ( p_element_name => 'Health Benefits'
1108: ,p_input_value_name => 'Health Plan'
1109: ,p_assignment_id => l_sf52_data.employee_assignment_id
1110: ,p_effective_date => trunc(l_sf52_data.effective_date)
1296: --raise error
1297: end if;
1298: hr_utility.set_location( l_proc, 30);
1299: -- Check if need to call cancel_hire_or_apl.lock_per_row ???
1300: -- call core HR api to cancel the hire.
1301: --*****************************************************************************
1302: -- Added as per Rohini's suggestion to fix bug#3106101
1303: pay_us_tax_internal.maintain_us_employee_taxes (
1304: p_effective_date => p_sf52_data.effective_date
1374:
1375: per_cancel_hire_or_apl_pkg.do_cancel_hire(
1376: p_person_id => p_sf52_data.person_id,
1377: p_date_start => l_cancel_effective_date,
1378: p_end_of_time => hr_api.g_eot,
1379: p_business_group_id => l_business_group_id,
1380: p_period_of_service_id => null
1381: );
1382: -- End segment for bug# 1295751
1641: l_result_code varchar2(30);
1642: l_rec_created_flag boolean;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1642: l_rec_created_flag boolean;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1713: l_health_plan varchar2(30);
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1713: l_health_plan varchar2(30);
1714: l_error_flag boolean;
1720: l_noa_family_code ghr_families.noa_family_code%type;
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1730:
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1730:
1731:
1732: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1733: -- note that this cursor orders by table name, this is due to the fact that we need to
1778: from ghr_noa_families nof,
1779: ghr_families fam
1780: where nof.nature_of_action_id = p_noa_id
1781: and fam.noa_family_code = nof.noa_family_code
1782: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
1783: and p_sf52_data.effective_date
1784: between nvl(fam.start_date_active,p_sf52_data.effective_date)
1785: and nvl(fam.end_date_active,p_sf52_data.effective_date);
1786:
1880:
1881: for noa_family_rec in c_noa_family(p_sf52_data.second_noa_id) loop
1882: l_noa_family_code := noa_family_rec.noa_family_code;
1883: end loop;
1884: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' then
1885: hr_utility.set_location('CAncel of conversion',1);
1886: -- check to see if the person was an EX_EMP prior to the effective
1887: -- date of this action.
1888: for prior_person_type in c_prior_person_type loop
1896: hr_utility.set_location('Family Code' || l_noa_family_code,1000);
1897: hr_utility.set_location('Second NOA Code' || p_sf52_data.second_noa_code,1000);
1898: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1899: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1900: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1901: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1902: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1903:
1904: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1897: hr_utility.set_location('Second NOA Code' || p_sf52_data.second_noa_code,1000);
1898: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1899: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1900: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1901: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1902: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1903:
1904: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1905: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1898: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1899: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1900: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1901: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1902: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1903:
1904: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1905: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1906: Else
2010: p_imm_tsp_roth => l_imm_roth_tsp
2011: );
2012:
2013: --
2014: ghr_api.retrieve_element_entry_value
2015: ( p_element_name => 'Health Benefits'
2016: ,p_input_value_name => 'Health Plan'
2017: ,p_assignment_id => l_sf52_data.employee_assignment_id
2018: ,p_effective_date => trunc(l_sf52_data.effective_date)
2211: -- ask to delete next change.
2212: -- If there is no pre-record then Call IF_ZAP_ELE_ENT to find if we need to zap
2213: -- the entry.
2214: l_result := FALSE;
2215: l_del_mode := hr_api.g_delete_next_change;
2216: if l_return_status is not null then
2217: hr_utility.set_location(' Call IF_ZAP_ELE_ENT' || l_proc, 31);
2218: If l_session_var.noa_id_correct is not null and l_sf52_data.first_noa_code = '866' then
2219: IF_ZAP_ELE_ENT(
2224: if l_result then
2225: -- ie can zap the element;
2226:
2227: hr_utility.set_location(' ZAP Mode set ' || l_proc, 32);
2228: l_del_mode := hr_api.g_zap;
2229: -- As there is no pre record. copy current row in pre record
2230: l_hist_pre := l_hist_rec;
2231: end if;
2232: Else
2238: if l_result then
2239: -- ie can zap the element;
2240:
2241: hr_utility.set_location(' ZAP Mode set ' || l_proc, 32);
2242: l_del_mode := hr_api.g_zap;
2243: -- As there is no pre record. copy current row in pre record
2244: l_hist_pre := l_hist_rec;
2245: end if;
2246: End if;
2418: if (l_datetrack_table = TRUE) then
2419: hr_utility.set_location('Datetrack table'|| l_proc,65);
2420: if (l_pre_record = FALSE and l_last_row = TRUE) then
2421: hr_utility.set_location('Only Row'|| l_proc,70);
2422: l_datetrack_mode := hr_api.g_zap;
2423: else
2424: hr_utility.set_location('Not Only Row'|| l_proc,75);
2425: l_datetrack_mode := hr_api.g_delete_next_change;
2426:
2421: hr_utility.set_location('Only Row'|| l_proc,70);
2422: l_datetrack_mode := hr_api.g_zap;
2423: else
2424: hr_utility.set_location('Not Only Row'|| l_proc,75);
2425: l_datetrack_mode := hr_api.g_delete_next_change;
2426:
2427: end if;
2428: end if;
2429: hr_utility.set_location('after what to do Del Mode ' || l_datetrack_mode,1);
2444: -- Delete history record
2445: delete_hist_row ( l_hist_rec.pa_history_id);
2446: -- cascade changes thru application table, if the application table record was not already deleted above.
2447: if (l_deleted = FALSE)
2448: or (l_datetrack_mode = hr_api.g_delete_next_change) then
2449: if (l_deleted = FALSE) then
2450: hr_utility.set_location('deleted is false : Bef cascade appl_table',1);
2451: else
2452:
2453: hr_utility.set_location('delete next change : Bef cascade appl_table',1);
2454: end if;
2455: -- Sundar Bug#2872298 Cascade should not occur if records are already deleted and
2456: -- delete mode in DELETE_NEXT_CHANGE
2457: IF (l_deleted = TRUE) AND (l_datetrack_mode = hr_api.g_delete_next_change) --AND (p_sf52_data.second_noa_code = '790')
2458: THEN
2459: NULL;
2460: ELSE
2461: --5900178
2710: l_result_code varchar2(30);
2711: l_people_data per_all_people_f%rowtype;
2712: l_hist_id number;
2713: l_proc varchar2(40):='Refresh_Cascade_Name';
2714: l_capped_other_pay number := hr_api.g_number;
2715:
2716: cursor get_hist is
2717: select pa_history_id
2718: from ghr_pa_history
2744:
2745: if l_result_code is NULL then
2746: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2747:
2748: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2749: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2750: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2751:
2752: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2745: if l_result_code is NULL then
2746: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2747:
2748: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2749: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2750: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2751:
2752: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2753: p_sf52_rec.employee_first_name := l_people_data.first_name;
2746: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2747:
2748: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2749: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2750: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2751:
2752: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2753: p_sf52_rec.employee_first_name := l_people_data.first_name;
2754: p_sf52_rec.employee_last_name := l_people_data.last_name;
2759: p_shadow_rec.employee_middle_names := l_people_data.middle_names;
2760: end if;
2761:
2762: hr_utility.set_location( 'Check SSN ' || l_proc, 35);
2763: if nvl(p_sf52_rec.employee_national_identifier, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_national_identifier, hr_api.g_varchar2) then
2764: hr_utility.set_location( 'Refresh SSN ' || l_proc, 40);
2765: p_sf52_rec.employee_national_identifier := l_people_data.national_identifier;
2766: hr_utility.set_location( 'Refresh SSN ' || l_proc, 41);
2767: p_shadow_rec.employee_national_identifier := l_people_data.national_identifier;
2767: p_shadow_rec.employee_national_identifier := l_people_data.national_identifier;
2768: end if;
2769:
2770: hr_utility.set_location( 'check DOB ' || l_proc, 45);
2771: if nvl(p_sf52_rec.employee_date_of_birth, hr_api.g_date) = nvl(p_shadow_rec.employee_date_of_birth, hr_api.g_date) then
2772: hr_utility.set_location( 'Refresh DOB ' || l_proc, 50);
2773: p_sf52_rec.employee_date_of_birth := l_people_data.date_of_birth;
2774: hr_utility.set_location( 'Refresh DOB ' || l_proc, 51);
2775: p_shadow_rec.employee_date_of_birth := l_people_data.date_of_birth;
3480: l_sf52_cursor_step_indx number;
3481: l_session_var ghr_history_api.g_session_var_type;
3482: -- Bug#5435374 added l_session_var1.
3483: l_session_var1 ghr_history_api.g_session_var_type;
3484: l_capped_other_pay number := hr_api.g_number;
3485: l_retro_eff_date ghr_pa_requests.effective_date%type;
3486: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3487: l_retro_first_noa ghr_nature_of_actions.code%type;
3488: l_retro_second_noa ghr_nature_of_actions.code%type;
3998: -- {End Of Comments}
3999: -- ---------------------------------------------------------------------------
4000:
4001: Procedure delete_element_entry( p_hist_rec in ghr_pa_history%rowtype,
4002: p_del_mode in varchar2 default hr_api.g_delete_next_change,
4003: p_cannot_cancel out nocopy Boolean) is
4004: l_del_warning boolean;
4005: -- this cursor selects the element_entry_id and object_version_number from
4006: -- pay_element_entries_f for the element_entry_id and date_effective passed.
4036: hr_utility.set_location( 'element entry id ' || l_c_elmt.element_entry_id, 32);
4037: hr_utility.set_location( 'ovn ' || l_c_elmt.object_version_number, 33);
4038:
4039: PY_element_entry_api.delete_element_entry(
4040: p_datetrack_delete_mode => nvl(p_del_mode, hr_api.g_delete_next_change),
4041: p_effective_date => to_date(p_hist_rec.information2, ghr_history_conv_rg.g_hist_date_format),
4042: p_element_entry_id => l_c_elmt.element_entry_id,
4043: p_object_version_number => l_c_elmt.object_version_number,
4044: p_effective_start_date => l_eff_start_date,
4400: WHERE person_id = cp_person_id
4401: AND cp_date_effective between effective_start_date and effective_end_date;
4402: BEGIN
4403: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4404: if (p_dt_mode = hr_api.g_delete_next_change) then
4405: open c_get_ovn(p_person_id, p_date_effective -1);
4406: fetch c_get_ovn into l_ovn;
4407: if c_get_ovn%NOTFOUND then
4408: -- can't delete without object_version_number.
4417: p_effective_end_date => l_effective_end_date,
4418: p_object_version_number => l_ovn,
4419: p_effective_date => p_date_effective -1,
4420: p_datetrack_mode => p_dt_mode);
4421: elsif (p_dt_mode = hr_api.g_zap) then
4422: open c_get_ovn(p_person_id, p_date_effective );
4423: fetch c_get_ovn into l_ovn;
4424: if c_get_ovn%NOTFOUND then
4425: -- raise error;
4473: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4474: SELECT psf.position_definition_id
4475: FROM hr_all_positions_f psf
4476: WHERE position_id = c_position_id
4477: AND effective_end_date = hr_api.g_eot
4478: FOR UPDATE;
4479: --
4480: l_position_definition_id number;
4481: BEGIN
4499: END IF;
4500: END ghr_regenerate_position_name;
4501: BEGIN
4502: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4503: if (p_dt_mode = hr_api.g_delete_next_change) then
4504: open c_get_ovn(p_position_id, p_date_effective -1);
4505: fetch c_get_ovn into l_ovn;
4506: if c_get_ovn%NOTFOUND then
4507: -- can't delete without object_version_number.
4532: ,p_effective_date => p_date_effective
4533: ,p_object_version_number => l_ovn
4534: ,p_refresh_date => trunc(sysdate));
4535:
4536: elsif (p_dt_mode = hr_api.g_zap) then
4537: open c_get_ovn(p_position_id, p_date_effective );
4538: fetch c_get_ovn into l_ovn;
4539: if c_get_ovn%NOTFOUND then
4540: -- raise error;
4650: l_pay_intg BOOLEAN:=FALSE;
4651:
4652: BEGIN
4653: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4654: if (p_dt_mode = hr_api.g_delete_next_change) then
4655: open c_get_ovn(p_assignment_id, p_date_effective -1);
4656: fetch c_get_ovn into l_ovn;
4657: if c_get_ovn%NOTFOUND then
4658: -- can't delete without object_version_number.
4671: p_object_version_number => l_ovn,
4672: p_effective_date => p_date_effective -1,
4673: p_datetrack_mode => p_dt_mode,
4674: p_org_now_no_manager_warning => l_org_now_no_manager_warning );
4675: elsif (p_dt_mode = hr_api.g_zap) then
4676: open c_get_ovn(p_assignment_id, p_date_effective );
4677: fetch c_get_ovn into l_ovn;
4678: if c_get_ovn%NOTFOUND then
4679: -- can't delete without object_version_number.
5346: l_sf52_data_step ghr_pa_requests%rowtype;
5347: l_sf52_data_result_rec ghr_pa_requests%rowtype;
5348: l_sf52_dummy ghr_pa_requests%rowtype;
5349: l_sf52_cursor_step_indx number;
5350: l_capped_other_pay number := hr_api.g_number;
5351:
5352: -- this cursor selects all rows in the correction chain from ghr_pa_requests
5353: cursor l_sf52_cursor is
5354: select *
5435: l_sf52_data_orig := l_sf52_data_step;
5436: p_sf52_data_result := l_sf52_data_step;
5437: -- Bug 3228557 Added the following IF condition. In case of NPA Printing
5438: -- Pass parameter 'NPA' to the procedure call to refresh_req_shadow.
5439: IF NVL(p_called_from,hr_api.g_varchar2) = 'NPA' THEN
5440: hr_utility.set_location('Inside NPA printing',10);
5441: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5442: p_shadow_data=>l_shadow_data,
5443: p_process_type => 'NPA');
5446: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5447: p_shadow_data=>l_shadow_data);
5448: END IF;
5449: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5450: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN
5451: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
5452: p_capped_other_pay => l_capped_other_pay);
5453: END IF;
5454: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
6166:
6167: Cancel_subs_correction (
6168: p_corr_sf52_detail => l_subsequent_pa_req(l_rev_count),
6169: p_which_noa => l_which_noa);
6170: ghr_api.g_api_dml := TRUE; --bug# 5389132
6171: end if;
6172: l_rev_count := l_rev_count - 1;
6173: end loop;
6174:
6358: -- original SF52 not found
6359: hr_utility.set_location(' Parent of pa_request_id : ' ||
6360: p_sf52_data.pa_request_id || ' Not Found. !! ERROR !! ' || l_proc , 20);
6361: hr_utility.set_message(8301 , 'GHR_38221_CORR_SF50_NOT_FOUND');
6362: ghr_api.g_api_dml := FALSE;
6363: hr_utility.raise_error;
6364: -- raise error
6365: else
6366: hr_utility.set_location( l_proc, 30);
6457: l_deenrtsp := TRUE;
6458: end loop;
6459:
6460: IF l_deenrtsp then
6461: l_datetrack_mode := hr_api.g_delete_next_change;
6462: ELSE
6463: l_datetrack_mode := hr_api.g_zap;
6464: END IF; */
6465:
6459:
6460: IF l_deenrtsp then
6461: l_datetrack_mode := hr_api.g_delete_next_change;
6462: ELSE
6463: l_datetrack_mode := hr_api.g_zap;
6464: END IF; */
6465:
6466:
6467: hr_utility.set_location('p_sf52_data.effective_date'||p_sf52_data.effective_date,1000);
6495: ,p_effective_start_date => l_effective_start_date
6496: ,p_effective_end_date => l_effective_end_date
6497: ,p_object_version_number => l_object_version_number
6498: ,p_effective_date => enrt_rec.effective_start_date
6499: ,p_datetrack_mode => hr_api.g_zap
6500: ,p_enrt_cvg_thru_dt => enrt_rec.enrt_cvg_thru_dt
6501: ,p_multi_row_validate => FALSE);
6502: END IF;
6503: end loop;
6945: END IF;
6946: -- End Bug 4086845
6947:
6948: -- Bug 2970608 - Do not copy from side pos org details to side for 790 action
6949: IF nvl(p_sf52_ia_rec.first_noa_code,hr_api.g_varchar2) <> '790' THEN
6950: p_sf52_ia_rec.to_position_org_line1 := c_sf52_data.from_position_org_line1;
6951: p_sf52_ia_rec.to_position_org_line2 := c_sf52_data.from_position_org_line2;
6952: p_sf52_ia_rec.to_position_org_line3 := c_sf52_data.from_position_org_line3;
6953: p_sf52_ia_rec.to_position_org_line4 := c_sf52_data.from_position_org_line4;
7248: l_sf52_cursor_step_indx number;
7249: l_session_var ghr_history_api.g_session_var_type;
7250: -- Bug#5435374 added l_session_var1.
7251: l_session_var1 ghr_history_api.g_session_var_type;
7252: l_capped_other_pay number := hr_api.g_number;
7253: l_retro_eff_date ghr_pa_requests.effective_date%type;
7254: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
7255: l_retro_first_noa ghr_nature_of_actions.code%type;
7256: l_retro_second_noa ghr_nature_of_actions.code%type;
7339: from ghr_noa_families nof,
7340: ghr_families fam
7341: where nof.nature_of_action_id = p_noa_id
7342: and fam.noa_family_code = nof.noa_family_code
7343: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
7344: and p_sf52_data.effective_date
7345: between nvl(fam.start_date_active,p_sf52_data.effective_date)
7346: and nvl(fam.end_date_active,p_sf52_data.effective_date);
7347: -- 8264545