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