186: l_interv_on_eff_date boolean;
187: l_hist_data_as_of_date ghr_pa_history%rowtype;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
187: l_hist_data_as_of_date ghr_pa_history%rowtype;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
193: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
194: l_imm_per_sf52 ghr_api.per_sf52_type;
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
195: l_imm_per_group1 ghr_api.per_group1_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
196: l_imm_per_group2 ghr_api.per_group2_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
197: l_imm_per_scd_info ghr_api.per_scd_info_type;
198: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
199: l_imm_per_probations ghr_api.per_probations_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
200: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
201: l_imm_per_security ghr_api.per_security_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
202: -- Bug#4486823 RRR changes
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
203: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
204: l_imm_per_conversions ghr_api.per_conversions_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
205: -- 4352589 BEN_EIT Changes
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
206: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
207: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
208: l_imm_pos_oblig ghr_api.pos_oblig_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
209: l_imm_pos_grp2 ghr_api.pos_grp2_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
210: l_imm_pos_grp1 ghr_api.pos_grp1_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
211: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
212: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
213: l_imm_loc_info ghr_api.loc_info_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
214: l_imm_wgi ghr_api.within_grade_increase_type;
215: l_imm_gov_awards ghr_api.government_awards_type;
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
216: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
217: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
218: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
219: --Pradeep
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
220: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
221: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
222:
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
223: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
224: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
225: l_imm_personal_info ghr_api.personal_info_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
226: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
227: l_imm_agency_sf52 ghr_api.agency_sf52_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
228: l_agency_code varchar2(50);
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
230: l_imm_conduct_performance ghr_api.conduct_performance_type;
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
231: l_imm_payroll_type ghr_api.government_payroll_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
233: l_imm_entitlement ghr_api.entitlement_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
234: -- Bug#2759379 Added FEGLI Record
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_fegli ghr_api.fegli_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: -- Bug#3385386 Added FTA Record
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_fta ghr_api.fta_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_edp_pay ghr_api.edp_pay_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_hazard_pay ghr_api.hazard_pay_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_health_benefits ghr_api.health_benefits_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_danger_pay ghr_api.danger_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
249: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
250: l_imm_premium_pay ghr_api.premium_pay_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
251: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
252: l_imm_severance_pay ghr_api.severance_pay_type;
253: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
254: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
255: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
256: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
263: l_sf52_data ghr_pa_requests%rowtype;
257: --Bug# 6312144
258: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
259: l_imm_retirement_info ghr_api.per_retirement_info_type;
260: --BUG # 13571004
261: l_imm_roth_tsp ghr_api.tsp_roth_type;
262:
263: l_sf52_data ghr_pa_requests%rowtype;
264: l_sf52_data_rec ghr_pa_requests%rowtype;
265: l_health_plan varchar2(30);
389: --BUG # 13571004 added TSP Roth
390: p_imm_tsp_roth => l_imm_roth_tsp
391: );
392: --
393: ghr_api.retrieve_element_entry_value
394: ( p_element_name => 'Health Benefits'
395: ,p_input_value_name => 'Health Plan'
396: ,p_assignment_id => l_sf52_data.employee_assignment_id
397: ,p_effective_date => trunc(l_sf52_data.effective_date)
812: l_u_prh_object_version_number number;
813: l_i_pa_routing_history_id number;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
813: l_i_pa_routing_history_id number;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
814: l_i_prh_object_version_number number;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
815: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
816: l_imm_asg_sf52 ghr_api.asg_sf52_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
817: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
818: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
819: l_imm_per_sf52 ghr_api.per_sf52_type;
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
820: l_imm_per_group1 ghr_api.per_group1_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
821: l_imm_per_group2 ghr_api.per_group2_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
822: l_imm_per_scd_info ghr_api.per_scd_info_type;
823: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
824: l_imm_per_probations ghr_api.per_probations_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
825: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
826: l_imm_per_security ghr_api.per_security_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
827: -- Bug#4486823 RRR changes
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
828: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
829: l_imm_per_conversions ghr_api.per_conversions_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
830: -- 4352589 BEN_EIT Changes
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
831: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
832: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
833: l_imm_pos_oblig ghr_api.pos_oblig_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
834: l_imm_pos_grp2 ghr_api.pos_grp2_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
835: l_imm_pos_grp1 ghr_api.pos_grp1_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
836: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
837: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
838: l_imm_loc_info ghr_api.loc_info_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
839: l_imm_wgi ghr_api.within_grade_increase_type;
840: l_imm_gov_awards ghr_api.government_awards_type;
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
841: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
842: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
843: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
844: --Pradeep
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
845: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
846: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
847:
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
848: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
849: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
850: l_imm_personal_info ghr_api.personal_info_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
851: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
852: l_imm_agency_sf52 ghr_api.agency_sf52_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
853: l_agency_code varchar2(50);
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
854: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
855: l_imm_conduct_performance ghr_api.conduct_performance_type;
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
856: l_imm_payroll_type ghr_api.government_payroll_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
857: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
858: l_imm_entitlement ghr_api.entitlement_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
859: -- Bug#2759379 Added FEGLI Record
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
860: l_imm_fegli ghr_api.fegli_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
861: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
862: -- Bug#3385386 Added FTA Record
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
863: l_imm_fta ghr_api.fta_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
864: l_imm_edp_pay ghr_api.edp_pay_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
865: l_imm_hazard_pay ghr_api.hazard_pay_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
866: l_imm_health_benefits ghr_api.health_benefits_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
867: l_imm_danger_pay ghr_api.danger_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
868: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
869: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
870: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
871: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
872: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
873: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
874: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
875: l_imm_premium_pay ghr_api.premium_pay_type;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
876: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
884: l_health_plan varchar2(30);
877: l_imm_severance_pay ghr_api.severance_pay_type;
878: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
879: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
880: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
881: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
882: l_sf52_data ghr_pa_requests%rowtype;
883: l_sf52_data_rec ghr_pa_requests%rowtype;
884: l_health_plan varchar2(30);
885: l_error_flag boolean;
889: l_cao_effective_date date;
890: l_cancel_effective_date date;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
890: l_cancel_effective_date date;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
891:
892: --Bug# 6312144
893: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
899:
894: l_imm_retirement_info ghr_api.per_retirement_info_type;
895: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
896:
897: --BUG # 13571004
898: l_imm_roth_tsp ghr_api.tsp_roth_type;
899:
900:
901: -- this cursor gets the business_group_id for the person_id/effective_date passed.
902: cursor c_bg ( c_person_id number,
1102: --BUG # 13571004 added TSP Roth
1103: p_imm_tsp_roth => l_imm_roth_tsp
1104: );
1105:
1106: ghr_api.retrieve_element_entry_value
1107: ( p_element_name => 'Health Benefits'
1108: ,p_input_value_name => 'Health Plan'
1109: ,p_assignment_id => l_sf52_data.employee_assignment_id
1110: ,p_effective_date => trunc(l_sf52_data.effective_date)
1641: l_result_code varchar2(30);
1642: l_rec_created_flag boolean;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1642: l_rec_created_flag boolean;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1645: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1646: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1647: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1648: l_imm_per_sf52 ghr_api.per_sf52_type;
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1649: l_imm_per_group1 ghr_api.per_group1_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1650: l_imm_per_group2 ghr_api.per_group2_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1651: l_imm_per_scd_info ghr_api.per_scd_info_type;
1652: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1653: l_imm_per_probations ghr_api.per_probations_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1654: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
1655: l_imm_per_security ghr_api.per_security_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1656: -- Bug#4486823 RRR changes
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1657: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1658: l_imm_per_conversions ghr_api.per_conversions_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1659: -- 4352589 BEN_EIT Changes
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1660: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1661: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1662: l_imm_pos_oblig ghr_api.pos_oblig_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1663: l_imm_pos_grp2 ghr_api.pos_grp2_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1664: l_imm_pos_grp1 ghr_api.pos_grp1_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1665: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1666: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1667: l_imm_loc_info ghr_api.loc_info_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1668: l_imm_wgi ghr_api.within_grade_increase_type;
1669: l_imm_gov_awards ghr_api.government_awards_type;
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1670: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1671: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
1672: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1673: --Pradeep
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1674: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1675: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1676:
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1677: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
1678: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1679: l_imm_personal_info ghr_api.personal_info_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1680: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1681: l_imm_agency_sf52 ghr_api.agency_sf52_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1682: l_agency_code varchar2(50);
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1683: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
1684: l_imm_conduct_performance ghr_api.conduct_performance_type;
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1685: l_imm_payroll_type ghr_api.government_payroll_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1686: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
1687: l_imm_entitlement ghr_api.entitlement_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1688: -- Bug#2759379 Added FEGLI Record
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1689: l_imm_fegli ghr_api.fegli_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1690: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1691: -- Bug#3385386 Added FTA Record
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1692: l_imm_fta ghr_api.fta_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1693: l_imm_edp_pay ghr_api.edp_pay_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1694: l_imm_hazard_pay ghr_api.hazard_pay_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1695: l_imm_health_benefits ghr_api.health_benefits_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1696: l_imm_danger_pay ghr_api.danger_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1697: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1698: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1699: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1700: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1701: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1702: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1703: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1704: l_imm_premium_pay ghr_api.premium_pay_type;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1705: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1713: l_health_plan varchar2(30);
1706: l_imm_severance_pay ghr_api.severance_pay_type;
1707: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
1708: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
1709: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
1710: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
1711: l_sf52_data ghr_pa_requests%rowtype;
1712: l_sf52_data_rec ghr_pa_requests%rowtype;
1713: l_health_plan varchar2(30);
1714: l_error_flag boolean;
1720: l_noa_family_code ghr_families.noa_family_code%type;
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1730:
1725: l_imm_retirement_info ghr_api.per_retirement_info_type;
1726: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
1727:
1728: --BUG # 13571004
1729: l_imm_roth_tsp ghr_api.tsp_roth_type;
1730:
1731:
1732: -- this cursor retrieves the ghr_pa_history row for the pa_request_id and noa_id given.
1733: -- note that this cursor orders by table name, this is due to the fact that we need to
2010: p_imm_tsp_roth => l_imm_roth_tsp
2011: );
2012:
2013: --
2014: ghr_api.retrieve_element_entry_value
2015: ( p_element_name => 'Health Benefits'
2016: ,p_input_value_name => 'Health Plan'
2017: ,p_assignment_id => l_sf52_data.employee_assignment_id
2018: ,p_effective_date => trunc(l_sf52_data.effective_date)
6166:
6167: Cancel_subs_correction (
6168: p_corr_sf52_detail => l_subsequent_pa_req(l_rev_count),
6169: p_which_noa => l_which_noa);
6170: ghr_api.g_api_dml := TRUE; --bug# 5389132
6171: end if;
6172: l_rev_count := l_rev_count - 1;
6173: end loop;
6174:
6358: -- original SF52 not found
6359: hr_utility.set_location(' Parent of pa_request_id : ' ||
6360: p_sf52_data.pa_request_id || ' Not Found. !! ERROR !! ' || l_proc , 20);
6361: hr_utility.set_message(8301 , 'GHR_38221_CORR_SF50_NOT_FOUND');
6362: ghr_api.g_api_dml := FALSE;
6363: hr_utility.raise_error;
6364: -- raise error
6365: else
6366: hr_utility.set_location( l_proc, 30);