[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(
182: l_interv_on_eff_date boolean;
183: l_hist_data_as_of_date ghr_pa_history%rowtype;
184: l_session_var ghr_history_api.g_session_var_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
183: l_hist_data_as_of_date ghr_pa_history%rowtype;
184: l_session_var ghr_history_api.g_session_var_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
184: l_session_var ghr_history_api.g_session_var_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
209: l_imm_wgi ghr_api.within_grade_increase_type;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
214: --Pradeep
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
215: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
216: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
217:
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
218: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
219: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
220: l_imm_personal_info ghr_api.personal_info_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
221: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
222: l_imm_agency_sf52 ghr_api.agency_sf52_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
223: l_agency_code varchar2(50);
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
224: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
225: l_imm_conduct_performance ghr_api.conduct_performance_type;
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
226: l_imm_payroll_type ghr_api.government_payroll_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
227: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
228: l_imm_entitlement ghr_api.entitlement_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: -- Bug#2759379 Added FEGLI Record
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
230: l_imm_fegli ghr_api.fegli_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
231: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
232: -- Bug#3385386 Added FTA Record
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
233: l_imm_fta ghr_api.fta_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
234: l_imm_edp_pay ghr_api.edp_pay_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
235: l_imm_hazard_pay ghr_api.hazard_pay_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
236: l_imm_health_benefits ghr_api.health_benefits_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
237: l_imm_danger_pay ghr_api.danger_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
238: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
239: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
240: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
241: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
242: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
243: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
244: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
245: l_imm_premium_pay ghr_api.premium_pay_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
253: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
246: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
253: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
254: l_imm_retirement_info ghr_api.per_retirement_info_type;
247: l_imm_severance_pay ghr_api.severance_pay_type;
248: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
253: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
254: l_imm_retirement_info ghr_api.per_retirement_info_type;
255:
249: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
253: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
254: l_imm_retirement_info ghr_api.per_retirement_info_type;
255:
256: l_sf52_data ghr_pa_requests%rowtype;
257: l_sf52_data_rec ghr_pa_requests%rowtype;
250: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
251: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
252: --Bug# 6312144
253: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
254: l_imm_retirement_info ghr_api.per_retirement_info_type;
255:
256: l_sf52_data ghr_pa_requests%rowtype;
257: l_sf52_data_rec ghr_pa_requests%rowtype;
258: l_health_plan varchar2(30);
379: p_imm_ipa_benefits_cont => l_imm_ipa_benefits_cont,
380: p_imm_retirement_info => l_imm_retirement_info
381: );
382: --
383: ghr_api.retrieve_element_entry_value
384: ( p_element_name => 'Health Benefits'
385: ,p_input_value_name => 'Health Plan'
386: ,p_assignment_id => l_sf52_data.employee_assignment_id
387: ,p_effective_date => trunc(l_sf52_data.effective_date)
547: close c_hist_sevpay;
548: else
549:
550: delete_element_entry( p_hist_rec => l_hist_sevpay,
551: p_del_mode => hr_api.g_zap,
552: p_cannot_cancel => l_cannot_cancel_sevpay);
553:
554: if l_cannot_cancel_sevpay then
555: -- raise error
656: delete_hist_row( l_hist.row_id);
657: end loop;
658:
659: -- Moved after history handling due to bug# 1316321
660: -- call core HR api to cancel the termination.
661: hrempter.cancel_termination(
662: p_person_id => p_sf52_data.person_id,
663: p_Actual_termination_date => p_sf52_data.effective_date
664: );
782: l_u_prh_object_version_number number;
783: l_i_pa_routing_history_id number;
784: l_i_prh_object_version_number number;
785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
783: l_i_pa_routing_history_id number;
784: l_i_prh_object_version_number number;
785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
784: l_i_prh_object_version_number number;
785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
790: l_imm_per_group1 ghr_api.per_group1_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
791: l_imm_per_group2 ghr_api.per_group2_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
792: l_imm_per_scd_info ghr_api.per_scd_info_type;
793: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
794: l_imm_per_probations ghr_api.per_probations_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
795: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
796: l_imm_per_security ghr_api.per_security_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
797: -- Bug#4486823 RRR changes
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
798: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
799: l_imm_per_conversions ghr_api.per_conversions_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
800: -- 4352589 BEN_EIT Changes
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
801: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
802: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
803: l_imm_pos_oblig ghr_api.pos_oblig_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
804: l_imm_pos_grp2 ghr_api.pos_grp2_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
805: l_imm_pos_grp1 ghr_api.pos_grp1_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
806: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
807: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
808: l_imm_loc_info ghr_api.loc_info_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
809: l_imm_wgi ghr_api.within_grade_increase_type;
810: l_imm_gov_awards ghr_api.government_awards_type;
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
811: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
812: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
813: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
814: --Pradeep
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
815: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
816: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
817:
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
818: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
819: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
820: l_imm_personal_info ghr_api.personal_info_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
821: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
822: l_imm_agency_sf52 ghr_api.agency_sf52_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
823: l_agency_code varchar2(50);
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
824: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
825: l_imm_conduct_performance ghr_api.conduct_performance_type;
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
826: l_imm_payroll_type ghr_api.government_payroll_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
827: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
828: l_imm_entitlement ghr_api.entitlement_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
829: -- Bug#2759379 Added FEGLI Record
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
830: l_imm_fegli ghr_api.fegli_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
831: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
832: -- Bug#3385386 Added FTA Record
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
833: l_imm_fta ghr_api.fta_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
834: l_imm_edp_pay ghr_api.edp_pay_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
835: l_imm_hazard_pay ghr_api.hazard_pay_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
836: l_imm_health_benefits ghr_api.health_benefits_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
837: l_imm_danger_pay ghr_api.danger_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
838: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
839: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
840: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
841: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
842: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
843: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
851: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
844: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
851: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
852: l_sf52_data ghr_pa_requests%rowtype;
845: l_imm_premium_pay ghr_api.premium_pay_type;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
851: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
852: l_sf52_data ghr_pa_requests%rowtype;
853: l_sf52_data_rec ghr_pa_requests%rowtype;
846: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
851: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
852: l_sf52_data ghr_pa_requests%rowtype;
853: l_sf52_data_rec ghr_pa_requests%rowtype;
854: l_health_plan varchar2(30);
847: l_imm_severance_pay ghr_api.severance_pay_type;
848: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
849: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
850: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
851: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
852: l_sf52_data ghr_pa_requests%rowtype;
853: l_sf52_data_rec ghr_pa_requests%rowtype;
854: l_health_plan varchar2(30);
855: l_error_flag boolean;
859: l_cao_effective_date date;
860: l_cancel_effective_date date;
861:
862: --Bug# 6312144
863: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
864: l_imm_retirement_info ghr_api.per_retirement_info_type;
865:
866:
867:
860: l_cancel_effective_date date;
861:
862: --Bug# 6312144
863: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
864: l_imm_retirement_info ghr_api.per_retirement_info_type;
865:
866:
867:
868: -- this cursor gets the business_group_id for the person_id/effective_date passed.
1028: --Bug #6312144 RPA EIT Benefits
1029: p_imm_ipa_benefits_cont => l_imm_ipa_benefits_cont,
1030: p_imm_retirement_info => l_imm_retirement_info);
1031:
1032: ghr_api.retrieve_element_entry_value
1033: ( p_element_name => 'Health Benefits'
1034: ,p_input_value_name => 'Health Plan'
1035: ,p_assignment_id => l_sf52_data.employee_assignment_id
1036: ,p_effective_date => trunc(l_sf52_data.effective_date)
1151: --raise error
1152: end if;
1153: hr_utility.set_location( l_proc, 30);
1154: -- Check if need to call cancel_hire_or_apl.lock_per_row ???
1155: -- call core HR api to cancel the hire.
1156: --*****************************************************************************
1157: -- Added as per Rohini's suggestion to fix bug#3106101
1158: pay_us_tax_internal.maintain_us_employee_taxes (
1159: p_effective_date => p_sf52_data.effective_date
1229:
1230: per_cancel_hire_or_apl_pkg.do_cancel_hire(
1231: p_person_id => p_sf52_data.person_id,
1232: p_date_start => l_cancel_effective_date,
1233: p_end_of_time => hr_api.g_eot,
1234: p_business_group_id => l_business_group_id,
1235: p_period_of_service_id => null
1236: );
1237: -- End segment for bug# 1295751
1472: l_result_code varchar2(30);
1473: l_rec_created_flag boolean;
1474: l_del_mode varchar2(30);
1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1473: l_rec_created_flag boolean;
1474: l_del_mode varchar2(30);
1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1474: l_del_mode varchar2(30);
1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1480: l_imm_per_group1 ghr_api.per_group1_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1481: l_imm_per_group2 ghr_api.per_group2_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1482: l_imm_per_scd_info ghr_api.per_scd_info_type;
1483: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1484: l_imm_per_probations ghr_api.per_probations_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1485: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1486: l_imm_per_security ghr_api.per_security_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1487: -- Bug#4486823 RRR changes
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1488: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1489: l_imm_per_conversions ghr_api.per_conversions_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1490: -- 4352589 BEN_EIT Changes
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1491: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1492: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1493: l_imm_pos_oblig ghr_api.pos_oblig_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1494: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1495: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1496: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1497: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1498: l_imm_loc_info ghr_api.loc_info_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1499: l_imm_wgi ghr_api.within_grade_increase_type;
1500: l_imm_gov_awards ghr_api.government_awards_type;
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1501: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1502: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1503: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1504: --Pradeep
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1505: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1506: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1507:
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1508: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1509: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1510: l_imm_personal_info ghr_api.personal_info_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1511: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1512: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1513: l_agency_code varchar2(50);
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1514: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1515: l_imm_conduct_performance ghr_api.conduct_performance_type;
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1516: l_imm_payroll_type ghr_api.government_payroll_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1517: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1518: l_imm_entitlement ghr_api.entitlement_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1519: -- Bug#2759379 Added FEGLI Record
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1520: l_imm_fegli ghr_api.fegli_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1521: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1522: -- Bug#3385386 Added FTA Record
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1523: l_imm_fta ghr_api.fta_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1524: l_imm_edp_pay ghr_api.edp_pay_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1525: l_imm_hazard_pay ghr_api.hazard_pay_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1526: l_imm_health_benefits ghr_api.health_benefits_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1527: l_imm_danger_pay ghr_api.danger_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1528: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1529: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1530: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1531: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1532: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1533: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1541: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1534: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1541: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1542: l_sf52_data ghr_pa_requests%rowtype;
1535: l_imm_premium_pay ghr_api.premium_pay_type;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1541: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1542: l_sf52_data ghr_pa_requests%rowtype;
1543: l_sf52_data_rec ghr_pa_requests%rowtype;
1536: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1541: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1542: l_sf52_data ghr_pa_requests%rowtype;
1543: l_sf52_data_rec ghr_pa_requests%rowtype;
1544: l_health_plan varchar2(30);
1537: l_imm_severance_pay ghr_api.severance_pay_type;
1538: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1539: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1540: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1541: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1542: l_sf52_data ghr_pa_requests%rowtype;
1543: l_sf52_data_rec ghr_pa_requests%rowtype;
1544: l_health_plan varchar2(30);
1545: l_error_flag boolean;
1551: l_noa_family_code ghr_families.noa_family_code%type;
1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1553:
1554: -- bug #6312144
1555: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1556: l_imm_retirement_info ghr_api.per_retirement_info_type;
1557:
1558:
1559: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1553:
1554: -- bug #6312144
1555: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1556: l_imm_retirement_info ghr_api.per_retirement_info_type;
1557:
1558:
1559: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1560: -- note that this cursor orders by table name, this is due to the fact that we need to
1605: from ghr_noa_families nof,
1606: ghr_families fam
1607: where nof.nature_of_action_id = p_noa_id
1608: and fam.noa_family_code = nof.noa_family_code
1609: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
1610: and p_sf52_data.effective_date
1611: between nvl(fam.start_date_active,p_sf52_data.effective_date)
1612: and nvl(fam.end_date_active,p_sf52_data.effective_date);
1613:
1687:
1688: for noa_family_rec in c_noa_family(p_sf52_data.second_noa_id) loop
1689: l_noa_family_code := noa_family_rec.noa_family_code;
1690: end loop;
1691: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' then
1692: hr_utility.set_location('CAncel of conversion',1);
1693: -- check to see if the person was an EX_EMP prior to the effective
1694: -- date of this action.
1695: for prior_person_type in c_prior_person_type loop
1703: hr_utility.set_location('Family Code' || l_noa_family_code,1000);
1704: hr_utility.set_location('Second NOA Code' || p_sf52_data.second_noa_code,1000);
1705: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1706: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1707: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1708: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1709: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1710:
1711: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1704: hr_utility.set_location('Second NOA Code' || p_sf52_data.second_noa_code,1000);
1705: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1706: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1707: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1708: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1709: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1710:
1711: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1712: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1705: hr_utility.set_location('Prior Assignment Id' || l_prior_asg_id,1001);
1706: hr_utility.set_location('Assignment Id' || l_sf52_data_rec.employee_assignment_id,1002);
1707: If nvl(l_noa_family_code,hr_api.g_varchar2) = 'CONV_APP' and
1708: nvl(l_prior_asg_id,hr_api.g_number) <> l_sf52_data_rec.employee_assignment_id and --Bug# 5442674
1709: nvl(l_prior_noa_code,hr_api.g_varchar2) <> '002' then
1710:
1711: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1712: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1713: Else
1813: p_imm_ipa_benefits_cont => l_imm_ipa_benefits_cont,
1814: p_imm_retirement_info => l_imm_retirement_info);
1815:
1816: --
1817: ghr_api.retrieve_element_entry_value
1818: ( p_element_name => 'Health Benefits'
1819: ,p_input_value_name => 'Health Plan'
1820: ,p_assignment_id => l_sf52_data.employee_assignment_id
1821: ,p_effective_date => trunc(l_sf52_data.effective_date)
1990: -- ask to delete next change.
1991: -- If there is no pre-record then Call IF_ZAP_ELE_ENT to find if we need to zap
1992: -- the entry.
1993: l_result := FALSE;
1994: l_del_mode := hr_api.g_delete_next_change;
1995: if l_return_status is not null then
1996: hr_utility.set_location(' Call IF_ZAP_ELE_ENT' || l_proc, 31);
1997: If l_session_var.noa_id_correct is not null and l_sf52_data.first_noa_code = '866' then
1998: IF_ZAP_ELE_ENT(
2003: if l_result then
2004: -- ie can zap the element;
2005:
2006: hr_utility.set_location(' ZAP Mode set ' || l_proc, 32);
2007: l_del_mode := hr_api.g_zap;
2008: -- As there is no pre record. copy current row in pre record
2009: l_hist_pre := l_hist_rec;
2010: end if;
2011: Else
2017: if l_result then
2018: -- ie can zap the element;
2019:
2020: hr_utility.set_location(' ZAP Mode set ' || l_proc, 32);
2021: l_del_mode := hr_api.g_zap;
2022: -- As there is no pre record. copy current row in pre record
2023: l_hist_pre := l_hist_rec;
2024: end if;
2025: End if;
2196: if (l_datetrack_table = TRUE) then
2197: hr_utility.set_location('Datetrack table'|| l_proc,65);
2198: if (l_pre_record = FALSE and l_last_row = TRUE) then
2199: hr_utility.set_location('Only Row'|| l_proc,70);
2200: l_datetrack_mode := hr_api.g_zap;
2201: else
2202: hr_utility.set_location('Not Only Row'|| l_proc,75);
2203: l_datetrack_mode := hr_api.g_delete_next_change;
2204:
2199: hr_utility.set_location('Only Row'|| l_proc,70);
2200: l_datetrack_mode := hr_api.g_zap;
2201: else
2202: hr_utility.set_location('Not Only Row'|| l_proc,75);
2203: l_datetrack_mode := hr_api.g_delete_next_change;
2204:
2205: end if;
2206: end if;
2207: hr_utility.set_location('after what to do Del Mode ' || l_datetrack_mode,1);
2222: -- Delete history record
2223: delete_hist_row ( l_hist_rec.pa_history_id);
2224: -- cascade changes thru application table, if the application table record was not already deleted above.
2225: if (l_deleted = FALSE)
2226: or (l_datetrack_mode = hr_api.g_delete_next_change) then
2227: if (l_deleted = FALSE) then
2228: hr_utility.set_location('deleted is false : Bef cascade appl_table',1);
2229: else
2230:
2231: hr_utility.set_location('delete next change : Bef cascade appl_table',1);
2232: end if;
2233: -- Sundar Bug#2872298 Cascade should not occur if records are already deleted and
2234: -- delete mode in DELETE_NEXT_CHANGE
2235: IF (l_deleted = TRUE) AND (l_datetrack_mode = hr_api.g_delete_next_change) --AND (p_sf52_data.second_noa_code = '790')
2236: THEN
2237: NULL;
2238: ELSE
2239: --5900178
2430: l_result_code varchar2(30);
2431: l_people_data per_all_people_f%rowtype;
2432: l_hist_id number;
2433: l_proc varchar2(40):='Refresh_Cascade_Name';
2434: l_capped_other_pay number := hr_api.g_number;
2435:
2436: cursor get_hist is
2437: select pa_history_id
2438: from ghr_pa_history
2464:
2465: if l_result_code is NULL then
2466: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2467:
2468: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2469: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2470: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2471:
2472: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2465: if l_result_code is NULL then
2466: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2467:
2468: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2469: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2470: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2471:
2472: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2473: p_sf52_rec.employee_first_name := l_people_data.first_name;
2466: hr_utility.set_location( 'People Data Found' || l_proc, 20);
2467:
2468: if nvl(p_sf52_rec.employee_first_name, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_first_name , hr_api.g_varchar2) and
2469: nvl(p_sf52_rec.employee_last_name , hr_api.g_varchar2) = nvl(p_shadow_rec.employee_last_name , hr_api.g_varchar2) and
2470: nvl(p_sf52_rec.employee_middle_names,hr_api.g_varchar2) = nvl(p_shadow_rec.employee_middle_names, hr_api.g_varchar2) then
2471:
2472: hr_utility.set_location( 'Refresh Name ' || l_proc, 30);
2473: p_sf52_rec.employee_first_name := l_people_data.first_name;
2474: p_sf52_rec.employee_last_name := l_people_data.last_name;
2479: p_shadow_rec.employee_middle_names := l_people_data.middle_names;
2480: end if;
2481:
2482: hr_utility.set_location( 'Check SSN ' || l_proc, 35);
2483: if nvl(p_sf52_rec.employee_national_identifier, hr_api.g_varchar2) = nvl(p_shadow_rec.employee_national_identifier, hr_api.g_varchar2) then
2484: hr_utility.set_location( 'Refresh SSN ' || l_proc, 40);
2485: p_sf52_rec.employee_national_identifier := l_people_data.national_identifier;
2486: hr_utility.set_location( 'Refresh SSN ' || l_proc, 41);
2487: p_shadow_rec.employee_national_identifier := l_people_data.national_identifier;
2487: p_shadow_rec.employee_national_identifier := l_people_data.national_identifier;
2488: end if;
2489:
2490: hr_utility.set_location( 'check DOB ' || l_proc, 45);
2491: 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
2492: hr_utility.set_location( 'Refresh DOB ' || l_proc, 50);
2493: p_sf52_rec.employee_date_of_birth := l_people_data.date_of_birth;
2494: hr_utility.set_location( 'Refresh DOB ' || l_proc, 51);
2495: p_shadow_rec.employee_date_of_birth := l_people_data.date_of_birth;
3174: l_sf52_cursor_step_indx number;
3175: l_session_var ghr_history_api.g_session_var_type;
3176: -- Bug#5435374 added l_session_var1.
3177: l_session_var1 ghr_history_api.g_session_var_type;
3178: l_capped_other_pay number := hr_api.g_number;
3179: l_retro_eff_date ghr_pa_requests.effective_date%type;
3180: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3181: l_retro_first_noa ghr_nature_of_actions.code%type;
3182: l_retro_second_noa ghr_nature_of_actions.code%type;
3690: -- {End Of Comments}
3691: -- ---------------------------------------------------------------------------
3692:
3693: Procedure delete_element_entry( p_hist_rec in ghr_pa_history%rowtype,
3694: p_del_mode in varchar2 default hr_api.g_delete_next_change,
3695: p_cannot_cancel out nocopy Boolean) is
3696: l_del_warning boolean;
3697: -- this cursor selects the element_entry_id and object_version_number from
3698: -- pay_element_entries_f for the element_entry_id and date_effective passed.
3728: hr_utility.set_location( 'element entry id ' || l_c_elmt.element_entry_id, 32);
3729: hr_utility.set_location( 'ovn ' || l_c_elmt.object_version_number, 33);
3730:
3731: PY_element_entry_api.delete_element_entry(
3732: p_datetrack_delete_mode => nvl(p_del_mode, hr_api.g_delete_next_change),
3733: p_effective_date => to_date(p_hist_rec.information2, ghr_history_conv_rg.g_hist_date_format),
3734: p_element_entry_id => l_c_elmt.element_entry_id,
3735: p_object_version_number => l_c_elmt.object_version_number,
3736: p_effective_start_date => l_eff_start_date,
4092: WHERE person_id = cp_person_id
4093: AND cp_date_effective between effective_start_date and effective_end_date;
4094: BEGIN
4095: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4096: if (p_dt_mode = hr_api.g_delete_next_change) then
4097: open c_get_ovn(p_person_id, p_date_effective -1);
4098: fetch c_get_ovn into l_ovn;
4099: if c_get_ovn%NOTFOUND then
4100: -- can't delete without object_version_number.
4109: p_effective_end_date => l_effective_end_date,
4110: p_object_version_number => l_ovn,
4111: p_effective_date => p_date_effective -1,
4112: p_datetrack_mode => p_dt_mode);
4113: elsif (p_dt_mode = hr_api.g_zap) then
4114: open c_get_ovn(p_person_id, p_date_effective );
4115: fetch c_get_ovn into l_ovn;
4116: if c_get_ovn%NOTFOUND then
4117: -- raise error;
4157: CURSOR c_position(c_position_id IN hr_all_positions_f.position_id%type) is
4158: SELECT psf.position_definition_id
4159: FROM hr_all_positions_f psf
4160: WHERE position_id = c_position_id
4161: AND effective_end_date = hr_api.g_eot
4162: FOR UPDATE;
4163: --
4164: l_position_definition_id number;
4165: BEGIN
4183: END IF;
4184: END ghr_regenerate_position_name;
4185: BEGIN
4186: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4187: if (p_dt_mode = hr_api.g_delete_next_change) then
4188: open c_get_ovn(p_position_id, p_date_effective -1);
4189: fetch c_get_ovn into l_ovn;
4190: if c_get_ovn%NOTFOUND then
4191: -- can't delete without object_version_number.
4203: p_datetrack_mode => p_dt_mode);
4204: -- Regenerate Position Bug 3786467.
4205: hr_utility.set_location('Entered ghr regenerate position',15);
4206: ghr_regenerate_position_name(p_position_id);
4207: elsif (p_dt_mode = hr_api.g_zap) then
4208: open c_get_ovn(p_position_id, p_date_effective );
4209: fetch c_get_ovn into l_ovn;
4210: if c_get_ovn%NOTFOUND then
4211: -- raise error;
4308: l_pay_intg BOOLEAN:=FALSE;
4309:
4310: BEGIN
4311: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4312: if (p_dt_mode = hr_api.g_delete_next_change) then
4313: open c_get_ovn(p_assignment_id, p_date_effective -1);
4314: fetch c_get_ovn into l_ovn;
4315: if c_get_ovn%NOTFOUND then
4316: -- can't delete without object_version_number.
4329: p_object_version_number => l_ovn,
4330: p_effective_date => p_date_effective -1,
4331: p_datetrack_mode => p_dt_mode,
4332: p_org_now_no_manager_warning => l_org_now_no_manager_warning );
4333: elsif (p_dt_mode = hr_api.g_zap) then
4334: open c_get_ovn(p_assignment_id, p_date_effective );
4335: fetch c_get_ovn into l_ovn;
4336: if c_get_ovn%NOTFOUND then
4337: -- can't delete without object_version_number.
5004: l_sf52_data_step ghr_pa_requests%rowtype;
5005: l_sf52_data_result_rec ghr_pa_requests%rowtype;
5006: l_sf52_dummy ghr_pa_requests%rowtype;
5007: l_sf52_cursor_step_indx number;
5008: l_capped_other_pay number := hr_api.g_number;
5009:
5010: -- this cursor selects all rows in the correction chain from ghr_pa_requests
5011: cursor l_sf52_cursor is
5012: select *
5093: l_sf52_data_orig := l_sf52_data_step;
5094: p_sf52_data_result := l_sf52_data_step;
5095: -- Bug 3228557 Added the following IF condition. In case of NPA Printing
5096: -- Pass parameter 'NPA' to the procedure call to refresh_req_shadow.
5097: IF NVL(p_called_from,hr_api.g_varchar2) = 'NPA' THEN
5098: hr_utility.set_location('Inside NPA printing',10);
5099: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5100: p_shadow_data=>l_shadow_data,
5101: p_process_type => 'NPA');
5104: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5105: p_shadow_data=>l_shadow_data);
5106: END IF;
5107: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5108: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN
5109: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
5110: p_capped_other_pay => l_capped_other_pay);
5111: END IF;
5112: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
6005: -- original SF52 not found
6006: hr_utility.set_location(' Parent of pa_request_id : ' ||
6007: p_sf52_data.pa_request_id || ' Not Found. !! ERROR !! ' || l_proc , 20);
6008: hr_utility.set_message(8301 , 'GHR_38221_CORR_SF50_NOT_FOUND');
6009: ghr_api.g_api_dml := FALSE;
6010: hr_utility.raise_error;
6011: -- raise error
6012: else
6013: hr_utility.set_location( l_proc, 30);
6103: l_deenrtsp := TRUE;
6104: end loop;
6105:
6106: IF l_deenrtsp then
6107: l_datetrack_mode := hr_api.g_delete_next_change;
6108: ELSE
6109: l_datetrack_mode := hr_api.g_zap;
6110: END IF; */
6111:
6105:
6106: IF l_deenrtsp then
6107: l_datetrack_mode := hr_api.g_delete_next_change;
6108: ELSE
6109: l_datetrack_mode := hr_api.g_zap;
6110: END IF; */
6111:
6112:
6113: hr_utility.set_location('p_sf52_data.effective_date'||p_sf52_data.effective_date,1000);
6141: ,p_effective_start_date => l_effective_start_date
6142: ,p_effective_end_date => l_effective_end_date
6143: ,p_object_version_number => l_object_version_number
6144: ,p_effective_date => enrt_rec.effective_start_date
6145: ,p_datetrack_mode => hr_api.g_zap
6146: ,p_enrt_cvg_thru_dt => enrt_rec.enrt_cvg_thru_dt
6147: ,p_multi_row_validate => FALSE);
6148: END IF;
6149: end loop;
6590: END IF;
6591: -- End Bug 4086845
6592:
6593: -- Bug 2970608 - Do not copy from side pos org details to side for 790 action
6594: IF nvl(p_sf52_ia_rec.first_noa_code,hr_api.g_varchar2) <> '790' THEN
6595: p_sf52_ia_rec.to_position_org_line1 := c_sf52_data.from_position_org_line1;
6596: p_sf52_ia_rec.to_position_org_line2 := c_sf52_data.from_position_org_line2;
6597: p_sf52_ia_rec.to_position_org_line3 := c_sf52_data.from_position_org_line3;
6598: p_sf52_ia_rec.to_position_org_line4 := c_sf52_data.from_position_org_line4;