[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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_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_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
121: is
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
121: is
122:
123: -- Cursor to select the person's sex which is required for CPDF Edits
181: from per_all_assignments_f asg
182: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
182: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
252: l_asg_ei_data per_assignment_extra_info%rowtype;
253: l_assignment_data per_all_assignments_f%rowtype;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
252: l_asg_ei_data per_assignment_extra_info%rowtype;
253: l_assignment_data per_all_assignments_f%rowtype;
254: l_result_code varchar2(50);
256: l_effective_date date;
257: -- Bug#4054110
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
257: -- Bug#4054110
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
268:
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
268:
269:
270: Begin
518:
519: If l_session.noa_id_correct is null then
520: hr_utility.set_location('populate_record_groups ', 30);
521:
522: ghr_api.return_special_information
523: (p_person_id => p_pa_request_rec.person_id,
524: p_structure_name => 'US Fed Perf Appraisal',
525: p_effective_date => p_pa_request_rec.effective_date,
526: p_special_info => l_special_info_type
774: --
775:
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
775:
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
1713: p_pa_request_rec.noa_family_code = 'REALIGNMENT' and
1714: l_agency_code is not null then
1715: p_agency_code := l_agency_code;
1716: else
1717: p_agency_code := ghr_api.get_position_agency_code_pos
1718: (p_position_id => l_position_id
1719: ,p_business_group_id => l_bus_gp
1720: ,p_effective_date => p_pa_request_rec.effective_date
1721: );
1732: -- This procedure Updates the various Record Groups with Data from the SF52 Form.
1733:
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1733:
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1750: l_noa_code ghr_nature_of_actions.code%type;
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1750: l_noa_code ghr_nature_of_actions.code%type;
1751: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1771: and information_type = l_information_type; */
1772: --
1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1774: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1775: l_student_loan_repay ghr_api.student_loan_repay_type;
1776:
1777: --Bug 6881863
1778: l_calc_table_id pay_user_tables.user_table_id%type;
1779: --
2190: PROCEDURE Process_Non_Sf52_Extra_Info
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2252: )
2253: --
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2252: )
2253: --
2254: IS
2255: --
2259: l_noa_code ghr_nature_of_actions.code%type;
2260: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2261: l_information_type ghr_pa_request_info_types.information_type%type;
2262: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2263: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2264: l_session ghr_history_api.g_session_var_type;
2265: l_multiple_error_flag boolean;
2266: -- Bug#5668878
2267: l_psi VARCHAR2(10);
3547: -- -- Bug#4486823 RRR Changes
3548: --
3549: Procedure non_pay_duty_status is
3550: l_proc varchar2(72) := 'non_pay_duty_status';
3551: l_special_info_type ghr_api.special_information_type;
3552:
3553: Begin
3554: set_extra_info(p_per_group1.type_of_employment,
3555: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag, 'Y');
4802: Begin
4803: --
4804: hr_utility.set_location('Entering ' ||l_proc,5);
4805: If p_pa_request_rec.employee_assignment_id is not null then
4806: ghr_api.retrieve_element_entry_value
4807: (p_element_name => 'Retention Allowance',
4808: p_input_value_name => 'Date',
4809: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4810: p_effective_date => nvl(p_pa_request_rec.effective_date,trunc(sysdate)) ,