1 PACKAGE GHR_SF52_PRE_UPDATE AS
2 /* $Header: gh52prup.pkh 120.3.12010000.1 2008/07/28 10:21:14 appldev ship $ */
3 --
4
5 Procedure populate_record_groups
6 (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
7 p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
8 p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
9 p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
10 p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
11 p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
12 p_imm_per_group1 out nocopy ghr_api.per_group1_type,
13 p_imm_per_group2 out nocopy ghr_api.per_group2_type,
14 p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
15 p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
16 p_imm_per_probations out nocopy ghr_api.per_probations_type,
17 p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
18 p_imm_per_security out nocopy ghr_api.per_security_type,
19 --Bug#4486823 RRR Changes
20 p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
21 p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
22 -- BEN_EIT Changes
23 p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
24 p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
25 p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
26 p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
27 p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
28 p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
29 p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
30 p_imm_loc_info out nocopy ghr_api.loc_info_type,
31 p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
32 p_imm_gov_awards out nocopy ghr_api.government_awards_type,
33 p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
34 p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
35 p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
36 --Pradeep
37 p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
38 p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
39 p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
40
41 p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
42 p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
43 p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
44 p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
45 p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
46 p_imm_personal_info out nocopy ghr_api.personal_info_type,
47 p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
48 p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
49 p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
50 p_imm_entitlement out nocopy ghr_api.entitlement_type,
51 --Bug#2759379 Added fegli record
52 p_imm_fegli out nocopy ghr_api.fegli_type,
53 p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
54 -- Bug#3385386 Added FTA record
55 p_imm_fta out nocopy ghr_api.fta_type,
56 p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
57 p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
58 p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
59 p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
60 p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
61 p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
62 p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
63 p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
64 p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
65 p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
66 p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
67 p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
68 p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
69 p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
70 p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
71 p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
72 p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
73 p_agency_code out nocopy varchar2,
74 --Bug #6312144 RPA EIT Benefits
75 p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
76 p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
77 );
78
79 procedure retrieve_all_extra_info
80 (p_pa_request_rec in ghr_pa_requests%rowtype,
81 p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
82 p_per_sf52 in out nocopy ghr_api.per_sf52_type,
83 p_per_group1 in out nocopy ghr_api.per_group1_type,
84 p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
85 p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
86 p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
87 p_loc_info in out nocopy ghr_api.loc_info_type,
88 p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
89 p_per_conversions in out nocopy ghr_api.per_conversions_type,
90 -- BEN_EIT Changes
91 p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
92 p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
93 p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
94 p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
95 p_per_probations in out nocopy ghr_api.per_probations_type,
96 p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
97 --Bug#4486823 RRR Changes
98 p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
99 p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
100 p_valid_grade in out nocopy ghr_api.pos_valid_grade_type,
101 p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
102 p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
103 --Bug #6312144 RPA EIT Benefits
104 p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
105 p_retirement_info in out nocopy ghr_api.per_retirement_info_type
106 );
107
108 procedure SF52_br_extra_info
109 (
110 P_PA_REQUEST_REC IN GHR_PA_REQUESTS%ROWTYPE
111 ,p_agency_code out nocopy varchar2
112 );
113
114 procedure Process_Sf52_Extra_Info
115 (p_pa_request_rec in ghr_pa_requests%rowtype,
116 p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
117 p_per_sf52 in out nocopy ghr_api.per_sf52_type,
118 p_per_group1 in out nocopy ghr_api.per_group1_type,
119 p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
120 p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
121 p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
122 p_loc_info in out nocopy ghr_api.loc_info_type,
123 p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
124 p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
125 p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
126 p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
127 p_valid_grade in out nocopy ghr_api.pos_valid_grade_type);
128
129 PROCEDURE Process_Non_Sf52_Extra_Info
130 (p_pa_request_rec IN OUT nocopy ghr_pa_requests%rowtype,
131 p_generic_ei_rec IN ghr_pa_request_extra_info%rowtype,
132 p_per_group1 IN OUT nocopy ghr_api.per_group1_type,
133 p_per_scd_info IN OUT nocopy ghr_api.per_scd_info_type,
134 p_pos_grp2 IN OUT nocopy ghr_api.pos_grp2_type,
135 p_pos_grp1 IN OUT nocopy ghr_api.pos_grp1_type,
136 p_per_uniformed_services IN OUT nocopy ghr_api.per_uniformed_services_type,
137 p_per_conversions IN OUT nocopy ghr_api.per_conversions_type,
138 -- BEN_EIT Changes
139 p_per_benefit_info IN OUT nocopy ghr_api.per_benefit_info_type,
140 p_asg_non_sf52 IN OUT nocopy ghr_api.asg_non_sf52_type,
141 p_per_separate_Retire IN OUT nocopy ghr_api.per_sep_retire_type,
142 p_asg_nte_dates IN OUT nocopy ghr_api.asg_nte_dates_type,
143 p_per_probations IN OUT nocopy ghr_api.per_probations_type,
144 p_per_retained_grade IN OUT nocopy ghr_api.per_retained_grade_type,
145 --Bug#4486823 RRR Changes
146 p_per_service_oblig IN OUT nocopy ghr_api.per_service_oblig_type,
147 p_within_grade_increase IN OUT nocopy ghr_api.within_grade_increase_type,
148 p_gov_awards IN OUT nocopy ghr_api.government_awards_type,
149 p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
150 p_agency_sf52 IN OUT nocopy ghr_api.agency_sf52_type,
151 p_recruitment_bonus IN OUT nocopy ghr_apI.recruitment_bonus_type,
152 p_relocation_bonus IN OUT nocopy ghr_apI.relocation_bonus_type,
153 p_student_loan_repay IN OUT nocopy ghr_api.student_loan_repay_type,
154 --Pradeep
155 p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
156 p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
157
158 p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
159 p_entitlement in out nocopy ghr_api.entitlement_type,
160 --Bug#2759379 Added fegli record
161 p_fegli in out nocopy ghr_api.fegli_type,
162 p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
163 -- Bug#3385386 Added FTA record
164 p_imm_fta in out nocopy ghr_api.fta_type,
165 p_edp_pay in out nocopy ghr_api.edp_pay_type,
166 p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
167 p_health_benefits in out nocopy ghr_api.health_benefits_type,
168 p_danger_pay in out nocopy ghr_api.danger_pay_type,
169 p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
170 p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
171 p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
172 p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
173 p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
174 p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
175 p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
176 p_premium_pay in out nocopy ghr_api.premium_pay_type,
177 p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
178 p_severance_pay in out nocopy ghr_api.severance_pay_type,
179 p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
180 p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
181 p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
182 p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, --Bug 4724337 Race or National Origin changes
183 --Bug #6312144 RPA EIT Benefits
184 p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
185 p_retirement_info in out nocopy ghr_api.per_retirement_info_type
186 );
187
188 PROCEDURE get_auth_codes
189 (p_pa_req_rec IN ghr_pa_requests%rowtype,
190 p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
191 p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
192 p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
193 p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type);
194
195
196
197 end GHR_SF52_PRE_UPDATE;