[Home] [Help]
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)
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)
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
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)
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);