358: l_session ghr_history_api.g_session_var_type;
359: l_imm_pa_request_rec ghr_pa_requests%rowtype;
360: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
361: l_capped_other_pay_in number; /* Added for NOCOPY changes */
362: l_imm_asg_sf52 ghr_api.asg_sf52_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
359: l_imm_pa_request_rec ghr_pa_requests%rowtype;
360: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
361: l_capped_other_pay_in number; /* Added for NOCOPY changes */
362: l_imm_asg_sf52 ghr_api.asg_sf52_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
360: l_imm_pa_request_rec_in ghr_pa_requests%rowtype; /* Added for NOCOPY changes */
361: l_capped_other_pay_in number; /* Added for NOCOPY changes */
362: l_imm_asg_sf52 ghr_api.asg_sf52_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
361: l_capped_other_pay_in number; /* Added for NOCOPY changes */
362: l_imm_asg_sf52 ghr_api.asg_sf52_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
362: l_imm_asg_sf52 ghr_api.asg_sf52_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
363: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
364: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
365: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
366: l_imm_per_sf52 ghr_api.per_sf52_type;
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
367: l_imm_per_group1 ghr_api.per_group1_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
368: l_imm_per_group2 ghr_api.per_group2_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
369: l_imm_per_scd_info ghr_api.per_scd_info_type;
370: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
371: l_imm_per_probations ghr_api.per_probations_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
372: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
373: l_imm_per_security ghr_api.per_security_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
374: -- Bug#4486823 RRR changes
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
375: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
376: l_imm_per_conversions ghr_api.per_conversions_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
377: -- 4352589 BEN_EIT Changes
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
378: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
379: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
380: l_imm_pos_oblig ghr_api.pos_oblig_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
381: l_imm_pos_grp2 ghr_api.pos_grp2_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
382: l_imm_pos_grp1 ghr_api.pos_grp1_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
383: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
384: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
385: l_imm_loc_info ghr_api.loc_info_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
386: l_imm_wgi ghr_api.within_grade_increase_type;
387: l_imm_gov_awards ghr_api.government_awards_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
388: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
389: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
390: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
391:
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
392: l_imm_extra_info_rec ghr_api.extra_info_rec_type ;
393: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
394: l_imm_personal_info ghr_api.personal_info_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
395: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type ;
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
396: l_imm_agency_sf52 ghr_api.agency_sf52_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
397: l_agency_code varchar2(50);
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
398: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
399: l_imm_conduct_performance ghr_api.conduct_performance_type;
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
400: l_imm_payroll_type ghr_api.government_payroll_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
401: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
402: l_imm_entitlement ghr_api.entitlement_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
403: -- Bug#2759379 Added FEGLI Record
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
404: l_imm_fegli ghr_api.fegli_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
405: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
406: -- Bug#3385386
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
407: l_imm_fta ghr_api.fta_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
408: l_imm_edp_pay ghr_api.edp_pay_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
409: l_imm_hazard_pay ghr_api.hazard_pay_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
410: l_imm_health_benefits ghr_api.health_benefits_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
411: l_imm_danger_pay ghr_api.danger_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
412: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
413: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
414: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
415: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
416: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
417: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
418: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
419: l_imm_premium_pay ghr_api.premium_pay_type;
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
420: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
421: l_imm_severance_pay ghr_api.severance_pay_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
422: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
430: l_imm_retirement_info ghr_api.per_retirement_info_type;
423: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
424: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
430: l_imm_retirement_info ghr_api.per_retirement_info_type;
431: --BUG # 13571004
425: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
430: l_imm_retirement_info ghr_api.per_retirement_info_type;
431: --BUG # 13571004
432: l_imm_roth_tsp ghr_api.tsp_roth_type;
433:
426: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
427: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Race or National Origin changes
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
430: l_imm_retirement_info ghr_api.per_retirement_info_type;
431: --BUG # 13571004
432: l_imm_roth_tsp ghr_api.tsp_roth_type;
433:
434:
428: -- bug # 6312144 RPA EIT Benefits
429: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
430: l_imm_retirement_info ghr_api.per_retirement_info_type;
431: --BUG # 13571004
432: l_imm_roth_tsp ghr_api.tsp_roth_type;
433:
434:
435: --
436: l_proc varchar2(70) := 'Process_Immediate_Update';
598: from ghr_noa_families nof,
599: ghr_families fam
600: where nof.nature_of_action_id = p_second_noa_id
601: and fam.noa_family_code = nof.noa_family_code
602: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
603: and p_imm_pa_request_rec.effective_date
604: between nvl(fam.start_date_active,p_imm_pa_request_rec.effective_date)
605: and nvl(fam.end_date_active,p_imm_pa_request_rec.effective_date);
606:
973: --Fetch Health Plan
974:
975: hr_utility.set_location('Health Plan ' ,20);
976:
977: ghr_api.retrieve_element_entry_value
978: ( p_element_name => 'Health Benefits'
979: ,p_input_value_name => 'Health Plan'
980: ,p_assignment_id => p_imm_pa_request_rec.employee_assignment_id
981: ,p_effective_date => trunc(p_imm_pa_request_rec.effective_date)