[Home] [Help]
42: --
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
117: )
118: is
119:
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
117: )
118: is
119:
120: -- Cursor to select the person's sex which is required for CPDF Edits
178: from per_all_assignments_f asg
179: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
179: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
250: l_result_code varchar2(50);
252: l_effective_date date;
253: -- Bug#4054110
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
253: -- Bug#4054110
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
263:
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
263:
264: Begin
507:
508: If l_session.noa_id_correct is null then
509: hr_utility.set_location('populate_record_groups ', 30);
510:
511: ghr_api.return_special_information
512: (p_person_id => p_pa_request_rec.person_id,
513: p_structure_name => 'US Fed Perf Appraisal',
514: p_effective_date => p_pa_request_rec.effective_date,
515: p_special_info => l_special_info_type
757: --
758:
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
758:
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1614: p_pa_request_rec.noa_family_code = 'REALIGNMENT' and
1615: l_agency_code is not null then
1616: p_agency_code := l_agency_code;
1617: else
1618: p_agency_code := ghr_api.get_position_agency_code_pos
1619: (p_position_id => l_position_id
1620: ,p_business_group_id => l_bus_gp
1621: ,p_effective_date => p_pa_request_rec.effective_date
1622: );
1633: -- This procedure Updates the various Record Groups with Data from the SF52 Form.
1634:
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1634:
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1651: l_noa_code ghr_nature_of_actions.code%type;
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1651: l_noa_code ghr_nature_of_actions.code%type;
1652: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1672: and information_type = l_information_type; */
1673: --
1674: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1675: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1676: l_student_loan_repay ghr_api.student_loan_repay_type;
1677:
1678: --Bug 6881863
1679: l_calc_table_id pay_user_tables.user_table_id%type;
1680: --
2087: PROCEDURE Process_Non_Sf52_Extra_Info
2088: --
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2088: --
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2146: IS
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2146: IS
2147: --
2151: l_noa_code ghr_nature_of_actions.code%type;
2152: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2153: l_information_type ghr_pa_request_info_types.information_type%type;
2154: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2155: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2156: l_session ghr_history_api.g_session_var_type;
2157: l_multiple_error_flag boolean;
2158: -- Bug#5668878
2159: l_psi VARCHAR2(10);
3133: -- -- Bug#4486823 RRR Changes
3134: --
3135: Procedure non_pay_duty_status is
3136: l_proc varchar2(72) := 'non_pay_duty_status';
3137: l_special_info_type ghr_api.special_information_type;
3138:
3139: Begin
3140: set_extra_info(p_per_group1.type_of_employment,
3141: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag, 'Y');
4372: Begin
4373: --
4374: hr_utility.set_location('Entering ' ||l_proc,5);
4375: If p_pa_request_rec.employee_assignment_id is not null then
4376: ghr_api.retrieve_element_entry_value
4377: (p_element_name => 'Retention Allowance',
4378: p_input_value_name => 'Date',
4379: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4380: p_effective_date => nvl(p_pa_request_rec.effective_date,trunc(sysdate)) ,