[Home] [Help]
PACKAGE BODY: APPS.GHR_PAR_UPD
Source
1 Package Body ghr_par_upd as
2 /* $Header: ghparrhi.pkb 120.5.12010000.3 2008/10/22 07:10:55 utokachi ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ghr_par_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< update_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml update logic. The processing of
17 -- this procedure is:
18 -- 1) Increment the object_version_number by 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To update the specified row in the schema using the primary key in
21 -- the predicates.
22 -- 3) To trap any constraint violations that may have occurred.
23 -- 4) To raise any other errors.
24 --
25 -- Prerequisites:
26 -- This is an internal private procedure which must be called from the upd
27 -- procedure.
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- The specified row will be updated in the schema.
34 --
35 -- Post Failure:
36 -- If a check, unique or parent integrity constraint violation is raised the
37 -- constraint_error procedure will be called.
38
39 --
40 -- Developer Implementation Notes:
41 -- The update 'set' attribute list should be modified if any of your
42 -- attributes are not updateable.
43 --
44 -- Access Status:
45 -- Internal Row Handler Use Only.
46 --
47 -- {End Of Comments}
48 -- ----------------------------------------------------------------------------
49 Procedure update_dml(p_rec in out nocopy ghr_par_shd.g_rec_type) is
50 --
51 l_proc varchar2(72) := g_package||'update_dml';
52 --
53 Begin
54 hr_utility.set_location('Entering:'||l_proc, 5);
55 --
56 -- Increment the object version
57 --
58 p_rec.object_version_number := p_rec.object_version_number + 1;
59 --
60 --
61 -- Update the ghr_pa_requests Row
62 --
63 update ghr_pa_requests
64 set
65 pa_request_id = p_rec.pa_request_id,
66 pa_notification_id = p_rec.pa_notification_id,
67 noa_family_code = p_rec.noa_family_code,
68 routing_group_id = p_rec.routing_group_id,
69 proposed_effective_asap_flag = p_rec.proposed_effective_asap_flag,
70 academic_discipline = p_rec.academic_discipline,
71 additional_info_person_id = p_rec.additional_info_person_id,
72 additional_info_tel_number = p_rec.additional_info_tel_number,
73 agency_code = p_rec.agency_code,
74 altered_pa_request_id = p_rec.altered_pa_request_id,
75 annuitant_indicator = p_rec.annuitant_indicator,
76 annuitant_indicator_desc = p_rec.annuitant_indicator_desc,
77 appropriation_code1 = p_rec.appropriation_code1,
78 appropriation_code2 = p_rec.appropriation_code2,
79 approval_date = p_rec.approval_date,
80 approving_official_full_name = p_rec.approving_official_full_name,
81 approving_official_work_title = p_rec.approving_official_work_title,
82 sf50_approval_date = p_rec.sf50_approval_date,
83 sf50_approving_ofcl_full_name = p_rec.sf50_approving_ofcl_full_name,
84 sf50_approving_ofcl_work_title = p_rec.sf50_approving_ofcl_work_title,
85 authorized_by_person_id = p_rec.authorized_by_person_id,
86 authorized_by_title = p_rec.authorized_by_title,
87 award_amount = p_rec.award_amount,
88 award_uom = p_rec.award_uom,
89 bargaining_unit_status = p_rec.bargaining_unit_status,
90 citizenship = p_rec.citizenship,
91 concurrence_date = p_rec.concurrence_date,
92 custom_pay_calc_flag = p_rec.custom_pay_calc_flag,
93 duty_station_code = p_rec.duty_station_code,
94 duty_station_desc = p_rec.duty_station_desc,
95 duty_station_id = p_rec.duty_station_id,
96 duty_station_location_id = p_rec.duty_station_location_id,
97 education_level = p_rec.education_level,
98 effective_date = p_rec.effective_date,
99 employee_assignment_id = p_rec.employee_assignment_id,
100 employee_date_of_birth = p_rec.employee_date_of_birth,
101 employee_dept_or_agency = p_rec.employee_dept_or_agency,
102 employee_first_name = p_rec.employee_first_name,
103 employee_last_name = p_rec.employee_last_name,
104 employee_middle_names = p_rec.employee_middle_names,
105 employee_national_identifier = p_rec.employee_national_identifier,
106 fegli = p_rec.fegli,
107 fegli_desc = p_rec.fegli_desc,
108 first_action_la_code1 = p_rec.first_action_la_code1,
109 first_action_la_code2 = p_rec.first_action_la_code2,
110 first_action_la_desc1 = p_rec.first_action_la_desc1,
111 first_action_la_desc2 = p_rec.first_action_la_desc2,
112 first_noa_cancel_or_correct = p_rec.first_noa_cancel_or_correct,
113 first_noa_code = p_rec.first_noa_code,
114 first_noa_desc = p_rec.first_noa_desc,
115 first_noa_id = p_rec.first_noa_id,
116 first_noa_pa_request_id = p_rec.first_noa_pa_request_id,
117 flsa_category = p_rec.flsa_category,
118 forwarding_address_line1 = p_rec.forwarding_address_line1,
119 forwarding_address_line2 = p_rec.forwarding_address_line2,
120 forwarding_address_line3 = p_rec.forwarding_address_line3,
121 forwarding_country = p_rec.forwarding_country,
122 forwarding_country_short_name = p_rec.forwarding_country_short_name,
123 forwarding_postal_code = p_rec.forwarding_postal_code,
124 forwarding_region_2 = p_rec.forwarding_region_2,
125 forwarding_town_or_city = p_rec.forwarding_town_or_city,
126 from_adj_basic_pay = p_rec.from_adj_basic_pay,
127 from_agency_code = p_rec.from_agency_code,
128 from_agency_desc = p_rec.from_agency_desc,
129 from_basic_pay = p_rec.from_basic_pay,
130 from_grade_or_level = p_rec.from_grade_or_level,
131 from_locality_adj = p_rec.from_locality_adj,
132 from_occ_code = p_rec.from_occ_code,
133 from_office_symbol = p_rec.from_office_symbol,
134 from_other_pay_amount = p_rec.from_other_pay_amount,
135 from_pay_basis = p_rec.from_pay_basis,
136 from_pay_plan = p_rec.from_pay_plan,
137 -- FWFA Changes Bug#4444609
138 input_pay_rate_determinant = p_rec.input_pay_rate_determinant,
139 from_pay_table_identifier = p_rec.from_pay_table_identifier,
140 -- FWFA Changes
141 from_position_id = p_rec.from_position_id,
142 from_position_org_line1 = p_rec.from_position_org_line1,
143 from_position_org_line2 = p_rec.from_position_org_line2,
144 from_position_org_line3 = p_rec.from_position_org_line3,
145 from_position_org_line4 = p_rec.from_position_org_line4,
146 from_position_org_line5 = p_rec.from_position_org_line5,
147 from_position_org_line6 = p_rec.from_position_org_line6,
148 from_position_number = p_rec.from_position_number,
149 from_position_seq_no = p_rec.from_position_seq_no,
150 from_position_title = p_rec.from_position_title,
151 from_step_or_rate = p_rec.from_step_or_rate,
152 from_total_salary = p_rec.from_total_salary,
153 functional_class = p_rec.functional_class,
154 notepad = p_rec.notepad,
155 part_time_hours = p_rec.part_time_hours,
156 pay_rate_determinant = p_rec.pay_rate_determinant,
157 personnel_office_id = p_rec.personnel_office_id,
158 person_id = p_rec.person_id,
159 position_occupied = p_rec.position_occupied,
160 proposed_effective_date = p_rec.proposed_effective_date,
161 requested_by_person_id = p_rec.requested_by_person_id,
162 requested_by_title = p_rec.requested_by_title,
163 requested_date = p_rec.requested_date,
164 requesting_office_remarks_desc = p_rec.requesting_office_remarks_desc,
165 requesting_office_remarks_flag = p_rec.requesting_office_remarks_flag,
166 request_number = p_rec.request_number,
167 resign_and_retire_reason_desc = p_rec.resign_and_retire_reason_desc,
168 retirement_plan = p_rec.retirement_plan,
169 retirement_plan_desc = p_rec.retirement_plan_desc,
170 second_action_la_code1 = p_rec.second_action_la_code1,
171 second_action_la_code2 = p_rec.second_action_la_code2,
172 second_action_la_desc1 = p_rec.second_action_la_desc1,
173 second_action_la_desc2 = p_rec.second_action_la_desc2,
174 second_noa_cancel_or_correct = p_rec.second_noa_cancel_or_correct,
175 second_noa_code = p_rec.second_noa_code,
176 second_noa_desc = p_rec.second_noa_desc,
177 second_noa_id = p_rec.second_noa_id,
178 second_noa_pa_request_id = p_rec.second_noa_pa_request_id,
179 service_comp_date = p_rec.service_comp_date,
180 status = p_rec.status,
181 supervisory_status = p_rec.supervisory_status,
182 tenure = p_rec.tenure,
183 to_adj_basic_pay = p_rec.to_adj_basic_pay,
184 to_basic_pay = p_rec.to_basic_pay,
185 to_grade_id = p_rec.to_grade_id,
186 to_grade_or_level = p_rec.to_grade_or_level,
187 to_job_id = p_rec.to_job_id,
188 to_locality_adj = p_rec.to_locality_adj,
189 to_occ_code = p_rec.to_occ_code,
190 to_office_symbol = p_rec.to_office_symbol,
191 to_organization_id = p_rec.to_organization_id,
192 to_other_pay_amount = p_rec.to_other_pay_amount,
193 to_au_overtime = p_rec.to_au_overtime,
194 to_auo_premium_pay_indicator = p_rec.to_auo_premium_pay_indicator,
195 to_availability_pay = p_rec.to_availability_pay,
196 to_ap_premium_pay_indicator = p_rec.to_ap_premium_pay_indicator,
197 to_retention_allowance = p_rec.to_retention_allowance,
198 to_supervisory_differential = p_rec.to_supervisory_differential,
199 to_staffing_differential = p_rec.to_staffing_differential,
200 to_pay_basis = p_rec.to_pay_basis,
201 to_pay_plan = p_rec.to_pay_plan,
202 -- FWFA Changes Bug#4444609
203 to_pay_table_identifier = p_rec.to_pay_table_identifier,
204 -- FWFA Changes
205 to_position_id = p_rec.to_position_id,
206 to_position_org_line1 = p_rec.to_position_org_line1,
207 to_position_org_line2 = p_rec.to_position_org_line2,
208 to_position_org_line3 = p_rec.to_position_org_line3,
209 to_position_org_line4 = p_rec.to_position_org_line4,
210 to_position_org_line5 = p_rec.to_position_org_line5,
211 to_position_org_line6 = p_rec.to_position_org_line6,
212 to_position_number = p_rec.to_position_number,
213 to_position_seq_no = p_rec.to_position_seq_no,
214 to_position_title = p_rec.to_position_title,
215 to_step_or_rate = p_rec.to_step_or_rate,
216 to_total_salary = p_rec.to_total_salary,
217 veterans_preference = p_rec.veterans_preference,
218 veterans_pref_for_rif = p_rec.veterans_pref_for_rif,
219 veterans_status = p_rec.veterans_status,
220 work_schedule = p_rec.work_schedule,
221 work_schedule_desc = p_rec.work_schedule_desc,
222 year_degree_attained = p_rec.year_degree_attained,
223 first_noa_information1 = p_rec.first_noa_information1,
224 first_noa_information2 = p_rec.first_noa_information2,
225 first_noa_information3 = p_rec.first_noa_information3,
226 first_noa_information4 = p_rec.first_noa_information4,
227 first_noa_information5 = p_rec.first_noa_information5,
228 second_lac1_information1 = p_rec.second_lac1_information1,
229 second_lac1_information2 = p_rec.second_lac1_information2,
230 second_lac1_information3 = p_rec.second_lac1_information3,
231 second_lac1_information4 = p_rec.second_lac1_information4,
232 second_lac1_information5 = p_rec.second_lac1_information5,
233 second_lac2_information1 = p_rec.second_lac2_information1,
234 second_lac2_information2 = p_rec.second_lac2_information2,
235 second_lac2_information3 = p_rec.second_lac2_information3,
236 second_lac2_information4 = p_rec.second_lac2_information4,
237 second_lac2_information5 = p_rec.second_lac2_information5,
238 second_noa_information1 = p_rec.second_noa_information1,
239 second_noa_information2 = p_rec.second_noa_information2,
240 second_noa_information3 = p_rec.second_noa_information3,
241 second_noa_information4 = p_rec.second_noa_information4,
242 second_noa_information5 = p_rec.second_noa_information5,
243 first_lac1_information1 = p_rec.first_lac1_information1,
244 first_lac1_information2 = p_rec.first_lac1_information2,
245 first_lac1_information3 = p_rec.first_lac1_information3,
246 first_lac1_information4 = p_rec.first_lac1_information4,
247 first_lac1_information5 = p_rec.first_lac1_information5,
248 first_lac2_information1 = p_rec.first_lac2_information1,
249 first_lac2_information2 = p_rec.first_lac2_information2,
250 first_lac2_information3 = p_rec.first_lac2_information3,
251 first_lac2_information4 = p_rec.first_lac2_information4,
252 first_lac2_information5 = p_rec.first_lac2_information5,
253 attribute_category = p_rec.attribute_category,
254 attribute1 = p_rec.attribute1,
255 attribute2 = p_rec.attribute2,
256 attribute3 = p_rec.attribute3,
257 attribute4 = p_rec.attribute4,
258 attribute5 = p_rec.attribute5,
259 attribute6 = p_rec.attribute6,
260 attribute7 = p_rec.attribute7,
261 attribute8 = p_rec.attribute8,
262 attribute9 = p_rec.attribute9,
263 attribute10 = p_rec.attribute10,
264 attribute11 = p_rec.attribute11,
265 attribute12 = p_rec.attribute12,
266 attribute13 = p_rec.attribute13,
267 attribute14 = p_rec.attribute14,
268 attribute15 = p_rec.attribute15,
269 attribute16 = p_rec.attribute16,
270 attribute17 = p_rec.attribute17,
271 attribute18 = p_rec.attribute18,
272 attribute19 = p_rec.attribute19,
273 attribute20 = p_rec.attribute20,
274 object_version_number = p_rec.object_version_number ,
275 first_noa_canc_pa_request_id = p_rec.first_noa_canc_pa_request_id ,
276 second_noa_canc_pa_request_id = p_rec.second_noa_canc_pa_request_id ,
277 to_retention_allow_percentage = p_rec.to_retention_allow_percentage ,
278 to_supervisory_diff_percentage = p_rec.to_supervisory_diff_percentage ,
279 to_staffing_diff_percentage = p_rec.to_staffing_diff_percentage ,
280 award_percentage = p_rec.award_percentage ,
281 rpa_type = p_rec.rpa_type,
282 mass_action_id = p_rec.mass_action_id,
283 mass_action_eligible_flag = p_rec.mass_action_eligible_flag,
284 mass_action_select_flag = p_rec.mass_action_select_flag,
285 mass_action_comments = p_rec.mass_action_comments,
286 -- Bug# RRR Changes
287 pa_incentive_payment_option = p_rec.payment_option,
288 award_salary = p_rec.award_salary
289 -- Bug# RRR Changes
290 where pa_request_id = p_rec.pa_request_id;
291 --
292 --
293 hr_utility.set_location(' Leaving:'||l_proc, 10);
294 --
295 Exception
296 When hr_api.check_integrity_violated Then
297 -- A check constraint has been violated
298 ghr_par_shd.constraint_error
299 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
300 When hr_api.parent_integrity_violated Then
301 -- Parent integrity has been violated
302 ghr_par_shd.constraint_error
303 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304 When hr_api.unique_integrity_violated Then
305 -- Unique integrity has been violated
306 ghr_par_shd.constraint_error
307 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308 When Others Then
309 Raise;
310 End update_dml;
311 --
312 -- ----------------------------------------------------------------------------
313 -- |------------------------------< pre_update >------------------------------|
314 -- ----------------------------------------------------------------------------
315 -- {Start Of Comments}
316 --
317 -- Description:
318 -- This private procedure contains any processing which is required before
319 -- the update dml.
320 --
321 -- Prerequisites:
322 -- This is an internal procedure which is called from the upd procedure.
323 --
324 -- In Parameters:
325 -- A Pl/Sql record structre.
326 --
327 -- Post Success:
328 -- Processing continues.
329 --
330 -- Post Failure:
331 -- If an error has occurred, an error message and exception will be raised
332 -- but not handled.
333 --
334 -- Developer Implementation Notes:
335 -- Any pre-processing required before the update dml is issued should be
336 -- coded within this procedure. It is important to note that any 3rd party
337 -- maintenance should be reviewed before placing in this procedure.
338 --
339 -- Access Status:
340 -- Internal Row Handler Use Only.
341 --
342 -- {End Of Comments}
343 -- ----------------------------------------------------------------------------
344 Procedure pre_update(p_rec in ghr_par_shd.g_rec_type) is
345 --
346 l_proc varchar2(72) := g_package||'pre_update';
347 --
348 Begin
349 hr_utility.set_location('Entering:'||l_proc, 5);
350 --
351 hr_utility.set_location(' Leaving:'||l_proc, 10);
352 End pre_update;
353 --
354 -- ----------------------------------------------------------------------------
355 -- |-----------------------------< post_update >------------------------------|
356 -- ----------------------------------------------------------------------------
357 -- {Start Of Comments}
358 --
359 -- Description:
360 -- This private procedure contains any processing which is required after the
361 -- update dml.
362 --
363 -- Prerequisites:
364 -- This is an internal procedure which is called from the upd procedure.
365 --
366 -- In Parameters:
367 -- A Pl/Sql record structre.
368 --
369 -- Post Success:
370 -- Processing continues.
371 --
372 -- Post Failure:
373 -- If an error has occurred, an error message and exception will be raised
374 -- but not handled.
375 --
376 -- Developer Implementation Notes:
377 -- Any post-processing required after the update dml is issued should be
378 -- coded within this procedure. It is important to note that any 3rd party
379 -- maintenance should be reviewed before placing in this procedure.
380 --
381 -- Access Status:
382 -- Internal Row Handler Use Only.
383 --
384 -- {End Of Comments}
385 -- ----------------------------------------------------------------------------
386 Procedure post_update(p_rec in ghr_par_shd.g_rec_type) is
387 --
388 l_proc varchar2(72) := g_package||'post_update';
389 --
390 Begin
391 hr_utility.set_location('Entering:'||l_proc, 5);
392 --
393 -- This is a hook point and the user hook for post_update is called here.
394 --
395 begin
396 ghr_par_rku.after_update (
397 p_pa_request_id => p_rec.pa_request_id ,
398 p_pa_notification_id => p_rec.pa_notification_id ,
399 p_noa_family_code => p_rec.noa_family_code ,
400 p_routing_group_id => p_rec.routing_group_id ,
401 p_proposed_effective_asap_flag => p_rec.proposed_effective_asap_flag ,
402 p_academic_discipline => p_rec.academic_discipline ,
403 p_additional_info_person_id => p_rec.additional_info_person_id ,
404 p_additional_info_tel_number => p_rec.additional_info_tel_number ,
405 p_agency_code => p_rec.agency_code ,
406 p_altered_pa_request_id => p_rec.altered_pa_request_id ,
407 p_annuitant_indicator => p_rec.annuitant_indicator ,
408 p_annuitant_indicator_desc => p_rec.annuitant_indicator_desc ,
409 p_appropriation_code1 => p_rec.appropriation_code1 ,
410 p_appropriation_code2 => p_rec.appropriation_code2 ,
411 p_approval_date => p_rec.approval_date ,
412 p_approving_official_full_name => p_rec.approving_official_full_name ,
413 p_approving_official_work_titl => p_rec.approving_official_work_title ,
414 p_sf50_approval_date => p_rec.sf50_approval_date ,
415 p_sf50_approving_ofcl_full_nam => p_rec.sf50_approving_ofcl_full_name ,
416 p_sf50_approving_ofcl_work_tit => p_rec.sf50_approving_ofcl_work_title ,
417 p_authorized_by_person_id => p_rec.authorized_by_person_id ,
418 p_authorized_by_title => p_rec.authorized_by_title ,
419 p_award_amount => p_rec.award_amount ,
420 p_award_uom => p_rec.award_uom ,
421 p_bargaining_unit_status => p_rec.bargaining_unit_status ,
422 p_citizenship => p_rec.citizenship ,
423 p_concurrence_date => p_rec.concurrence_date ,
424 p_custom_pay_calc_flag => p_rec.custom_pay_calc_flag ,
425 p_duty_station_code => p_rec.duty_station_code ,
426 p_duty_station_desc => p_rec.duty_station_desc ,
427 p_duty_station_id => p_rec.duty_station_id ,
428 p_duty_station_location_id => p_rec.duty_station_location_id ,
429 p_education_level => p_rec.education_level ,
430 p_effective_date => p_rec.effective_date ,
431 p_employee_assignment_id => p_rec.employee_assignment_id ,
432 p_employee_date_of_birth => p_rec.employee_date_of_birth ,
433 p_employee_dept_or_agency => p_rec.employee_dept_or_agency ,
434 p_employee_first_name => p_rec.employee_first_name ,
435 p_employee_last_name => p_rec.employee_last_name ,
436 p_employee_middle_names => p_rec.employee_middle_names ,
437 p_employee_national_identifier => p_rec.employee_national_identifier ,
438 p_fegli => p_rec.fegli ,
439 p_fegli_desc => p_rec.fegli_desc ,
440 p_first_action_la_code1 => p_rec.first_action_la_code1 ,
441 p_first_action_la_code2 => p_rec.first_action_la_code2 ,
442 p_first_action_la_desc1 => p_rec.first_action_la_desc1 ,
443 p_first_action_la_desc2 => p_rec.first_action_la_desc2 ,
444 p_first_noa_cancel_or_correct => p_rec.first_noa_cancel_or_correct ,
445 p_first_noa_code => p_rec.first_noa_code ,
446 p_first_noa_desc => p_rec.first_noa_desc ,
447 p_first_noa_id => p_rec.first_noa_id ,
448 p_first_noa_pa_request_id => p_rec.first_noa_pa_request_id ,
449 p_flsa_category => p_rec.flsa_category ,
450 p_forwarding_address_line1 => p_rec.forwarding_address_line1 ,
451 p_forwarding_address_line2 => p_rec.forwarding_address_line2 ,
452 p_forwarding_address_line3 => p_rec.forwarding_address_line3 ,
453 p_forwarding_country => p_rec.forwarding_country ,
454 p_forwarding_country_short_nam => p_rec.forwarding_country_short_name ,
455 p_forwarding_postal_code => p_rec.forwarding_postal_code ,
456 p_forwarding_region_2 => p_rec.forwarding_region_2 ,
457 p_forwarding_town_or_city => p_rec.forwarding_town_or_city ,
458 p_from_adj_basic_pay => p_rec.from_adj_basic_pay ,
459 p_from_agency_code => p_rec.from_agency_code ,
460 p_from_agency_desc => p_rec.from_agency_desc ,
461 p_from_basic_pay => p_rec.from_basic_pay ,
462 p_from_grade_or_level => p_rec.from_grade_or_level ,
463 p_from_locality_adj => p_rec.from_locality_adj ,
464 p_from_occ_code => p_rec.from_occ_code ,
465 p_from_office_symbol => p_rec.from_office_symbol ,
466 p_from_other_pay_amount => p_rec.from_other_pay_amount ,
467 p_from_pay_basis => p_rec.from_pay_basis ,
468 p_from_pay_plan => p_rec.from_pay_plan ,
469 -- FWFA Changes Bug#4444609
470 -- p_input_pay_rate_determinant => p_rec.input_pay_rate_determinant ,
471 -- p_from_pay_table_identifier => p_rec.from_pay_table_identifier ,
472 -- FWFA Changes
473 p_from_position_id => p_rec.from_position_id ,
474 p_from_position_org_line1 => p_rec.from_position_org_line1 ,
475 p_from_position_org_line2 => p_rec.from_position_org_line2 ,
476 p_from_position_org_line3 => p_rec.from_position_org_line3 ,
477 p_from_position_org_line4 => p_rec.from_position_org_line4 ,
478 p_from_position_org_line5 => p_rec.from_position_org_line5 ,
479 p_from_position_org_line6 => p_rec.from_position_org_line6 ,
480 p_from_position_number => p_rec.from_position_number ,
481 p_from_position_seq_no => p_rec.from_position_seq_no ,
482 p_from_position_title => p_rec.from_position_title ,
483 p_from_step_or_rate => p_rec.from_step_or_rate ,
484 p_from_total_salary => p_rec.from_total_salary ,
485 p_functional_class => p_rec.functional_class ,
486 p_notepad => p_rec.notepad ,
487 p_part_time_hours => p_rec.part_time_hours ,
488 p_pay_rate_determinant => p_rec.pay_rate_determinant ,
489 p_personnel_office_id => p_rec.personnel_office_id ,
490 p_person_id => p_rec.person_id ,
491 p_position_occupied => p_rec.position_occupied ,
492 p_proposed_effective_date => p_rec.proposed_effective_date ,
493 p_requested_by_person_id => p_rec.requested_by_person_id ,
494 p_requested_by_title => p_rec.requested_by_title ,
495 p_requested_date => p_rec.requested_date ,
496 p_requesting_office_remarks_de => p_rec.requesting_office_remarks_desc ,
497 p_requesting_office_remarks_fl => p_rec.requesting_office_remarks_flag ,
498 p_request_number => p_rec.request_number ,
499 p_resign_and_retire_reason_des => p_rec.resign_and_retire_reason_desc ,
500 p_retirement_plan => p_rec.retirement_plan ,
501 p_retirement_plan_desc => p_rec.retirement_plan_desc ,
502 p_second_action_la_code1 => p_rec.second_action_la_code1 ,
503 p_second_action_la_code2 => p_rec.second_action_la_code2 ,
504 p_second_action_la_desc1 => p_rec.second_action_la_desc1 ,
505 p_second_action_la_desc2 => p_rec.second_action_la_desc2 ,
506 p_second_noa_cancel_or_correct => p_rec.second_noa_cancel_or_correct ,
507 p_second_noa_code => p_rec.second_noa_code ,
508 p_second_noa_desc => p_rec.second_noa_desc ,
509 p_second_noa_id => p_rec.second_noa_id ,
510 p_second_noa_pa_request_id => p_rec.second_noa_pa_request_id ,
511 p_service_comp_date => p_rec.service_comp_date ,
512 p_status => p_rec.status,
513 p_supervisory_status => p_rec.supervisory_status ,
514 p_tenure => p_rec.tenure ,
515 p_to_adj_basic_pay => p_rec.to_adj_basic_pay ,
516 p_to_basic_pay => p_rec.to_basic_pay ,
517 p_to_grade_id => p_rec.to_grade_id ,
518 p_to_grade_or_level => p_rec.to_grade_or_level ,
519 p_to_job_id => p_rec.to_job_id ,
520 p_to_locality_adj => p_rec.to_locality_adj ,
521 p_to_occ_code => p_rec.to_occ_code ,
522 p_to_office_symbol => p_rec.to_office_symbol ,
523 p_to_organization_id => p_rec.to_organization_id ,
524 p_to_other_pay_amount => p_rec.to_other_pay_amount ,
525 p_to_au_overtime => p_rec.to_au_overtime ,
526 p_to_auo_premium_pay_indicator => p_rec.to_auo_premium_pay_indicator ,
527 p_to_availability_pay => p_rec.to_availability_pay ,
528 p_to_ap_premium_pay_indicator => p_rec.to_ap_premium_pay_indicator ,
529 p_to_retention_allowance => p_rec.to_retention_allowance ,
530 p_to_supervisory_differential => p_rec.to_supervisory_differential ,
531 p_to_staffing_differential => p_rec.to_staffing_differential ,
532 p_to_pay_basis => p_rec.to_pay_basis ,
533 p_to_pay_plan => p_rec.to_pay_plan ,
534 -- FWFA Changes Bug#4444609
535 -- p_to_pay_table_identifier => p_rec.to_pay_table_identifier ,
536 -- FWFA Changes
537 p_to_position_id => p_rec.to_position_id ,
538 p_to_position_org_line1 => p_rec.to_position_org_line1 ,
539 p_to_position_org_line2 => p_rec.to_position_org_line2 ,
540 p_to_position_org_line3 => p_rec.to_position_org_line3 ,
541 p_to_position_org_line4 => p_rec.to_position_org_line4 ,
542 p_to_position_org_line5 => p_rec.to_position_org_line5 ,
543 p_to_position_org_line6 => p_rec.to_position_org_line6 ,
544 p_to_position_number => p_rec.to_position_number ,
545 p_to_position_seq_no => p_rec.to_position_seq_no ,
546 p_to_position_title => p_rec.to_position_title ,
547 p_to_step_or_rate => p_rec.to_step_or_rate ,
548 p_to_total_salary => p_rec.to_total_salary ,
549 p_veterans_preference => p_rec.veterans_preference ,
550 p_veterans_pref_for_rif => p_rec.veterans_pref_for_rif ,
551 p_veterans_status => p_rec.veterans_status ,
552 p_work_schedule => p_rec.work_schedule ,
553 p_work_schedule_desc => p_rec.work_schedule_desc ,
554 p_year_degree_attained => p_rec.year_degree_attained ,
555 p_first_noa_information1 => p_rec.first_noa_information1 ,
556 p_first_noa_information2 => p_rec.first_noa_information2 ,
557 p_first_noa_information3 => p_rec.first_noa_information3 ,
558 p_first_noa_information4 => p_rec.first_noa_information4 ,
559 p_first_noa_information5 => p_rec.first_noa_information5 ,
560 p_second_lac1_information1 => p_rec.second_lac1_information1 ,
561 p_second_lac1_information2 => p_rec.second_lac1_information2 ,
562 p_second_lac1_information3 => p_rec.second_lac1_information3 ,
563 p_second_lac1_information4 => p_rec.second_lac1_information4 ,
564 p_second_lac1_information5 => p_rec.second_lac1_information5 ,
565 p_second_lac2_information1 => p_rec.second_lac2_information1 ,
566 p_second_lac2_information2 => p_rec.second_lac2_information2 ,
567 p_second_lac2_information3 => p_rec.second_lac2_information3 ,
568 p_second_lac2_information4 => p_rec.second_lac2_information4 ,
569 p_second_lac2_information5 => p_rec.second_lac2_information5 ,
570 p_second_noa_information1 => p_rec.second_noa_information1 ,
571 p_second_noa_information2 => p_rec.second_noa_information2 ,
572 p_second_noa_information3 => p_rec.second_noa_information3 ,
573 p_second_noa_information4 => p_rec.second_noa_information4 ,
574 p_second_noa_information5 => p_rec.second_noa_information5 ,
575 p_first_lac1_information1 => p_rec.first_lac1_information1 ,
576 p_first_lac1_information2 => p_rec.first_lac1_information2 ,
577 p_first_lac1_information3 => p_rec.first_lac1_information3 ,
578 p_first_lac1_information4 => p_rec.first_lac1_information4 ,
579 p_first_lac1_information5 => p_rec.first_lac1_information5 ,
580 p_first_lac2_information1 => p_rec.first_lac2_information1 ,
581 p_first_lac2_information2 => p_rec.first_lac2_information2 ,
582 p_first_lac2_information3 => p_rec.first_lac2_information3 ,
583 p_first_lac2_information4 => p_rec.first_lac2_information4 ,
584 p_first_lac2_information5 => p_rec.first_lac2_information5 ,
585 p_attribute_category => p_rec.attribute_category ,
586 p_attribute1 => p_rec.attribute1 ,
587 p_attribute2 => p_rec.attribute2 ,
588 p_attribute3 => p_rec.attribute3 ,
589 p_attribute4 => p_rec.attribute4 ,
590 p_attribute5 => p_rec.attribute5 ,
591 p_attribute6 => p_rec.attribute6 ,
592 p_attribute7 => p_rec.attribute7 ,
593 p_attribute8 => p_rec.attribute8 ,
594 p_attribute9 => p_rec.attribute9 ,
595 p_attribute10 => p_rec.attribute10 ,
596 p_attribute11 => p_rec.attribute11 ,
597 p_attribute12 => p_rec.attribute12 ,
598 p_attribute13 => p_rec.attribute13 ,
599 p_attribute14 => p_rec.attribute14 ,
600 p_attribute15 => p_rec.attribute15 ,
601 p_attribute16 => p_rec.attribute16 ,
602 p_attribute17 => p_rec.attribute17 ,
603 p_attribute18 => p_rec.attribute18 ,
604 p_attribute19 => p_rec.attribute19 ,
605 p_attribute20 => p_rec.attribute20 ,
606 p_first_noa_canc_pa_request_id => p_rec.first_noa_canc_pa_request_id ,
607 p_second_noa_canc_pa_request_i => p_rec.second_noa_canc_pa_request_id ,
608 p_to_retention_allow_percentag => p_rec.to_retention_allow_percentage ,
609 p_to_supervisory_diff_percenta => p_rec.to_supervisory_diff_percentage ,
610 p_to_staffing_diff_percentage => p_rec.to_staffing_diff_percentage ,
611 p_award_percentage => p_rec.award_percentage ,
612 p_rpa_type => p_rec.rpa_type,
613 p_mass_action_id => p_rec.mass_action_id,
614 p_mass_action_eligible_flag => p_rec.mass_action_eligible_flag,
615 p_mass_action_select_flag => p_rec.mass_action_select_flag,
616 p_mass_action_comments => p_rec.mass_action_comments,
617 p_pa_notification_id_o => ghr_par_shd.g_old_rec.pa_notification_id ,
618 p_noa_family_code_o => ghr_par_shd.g_old_rec.noa_family_code ,
619 p_routing_group_id_o => ghr_par_shd.g_old_rec.routing_group_id ,
620 p_proposed_effective_asap_fl_o => ghr_par_shd.g_old_rec.proposed_effective_asap_flag ,
621 p_academic_discipline_o => ghr_par_shd.g_old_rec.academic_discipline ,
622 p_additional_info_person_id_o => ghr_par_shd.g_old_rec.additional_info_person_id ,
623 p_additional_info_tel_number_o => ghr_par_shd.g_old_rec.additional_info_tel_number ,
624 p_agency_code_o => ghr_par_shd.g_old_rec.agency_code ,
625 p_altered_pa_request_id_o => ghr_par_shd.g_old_rec.altered_pa_request_id ,
626 p_annuitant_indicator_o => ghr_par_shd.g_old_rec.annuitant_indicator ,
627 p_annuitant_indicator_desc_o => ghr_par_shd.g_old_rec.annuitant_indicator_desc ,
628 p_appropriation_code1_o => ghr_par_shd.g_old_rec.appropriation_code1 ,
629 p_appropriation_code2_o => ghr_par_shd.g_old_rec.appropriation_code2 ,
630 p_approval_date_o => ghr_par_shd.g_old_rec.approval_date ,
631 p_approving_official_full_na_o => ghr_par_shd.g_old_rec.approving_official_full_name ,
632 p_approving_official_work_ti_o => ghr_par_shd.g_old_rec.approving_official_work_title ,
633 p_sf50_approval_date_o => ghr_par_shd.g_old_rec.sf50_approval_date ,
634 p_sf50_approving_ofcl_full_n_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ,
635 p_sf50_approving_ofcl_work_t_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title ,
636 p_authorized_by_person_id_o => ghr_par_shd.g_old_rec.authorized_by_person_id ,
637 p_authorized_by_title_o => ghr_par_shd.g_old_rec.authorized_by_title ,
638 p_award_amount_o => ghr_par_shd.g_old_rec.award_amount ,
639 p_award_uom_o => ghr_par_shd.g_old_rec.award_uom ,
640 p_bargaining_unit_status_o => ghr_par_shd.g_old_rec.bargaining_unit_status ,
641 p_citizenship_o => ghr_par_shd.g_old_rec.citizenship ,
642 p_concurrence_date_o => ghr_par_shd.g_old_rec.concurrence_date ,
643 p_custom_pay_calc_flag_o => ghr_par_shd.g_old_rec.custom_pay_calc_flag ,
644 p_duty_station_code_o => ghr_par_shd.g_old_rec.duty_station_code ,
645 p_duty_station_desc_o => ghr_par_shd.g_old_rec.duty_station_desc ,
646 p_duty_station_id_o => ghr_par_shd.g_old_rec.duty_station_id ,
647 p_duty_station_location_id_o => ghr_par_shd.g_old_rec.duty_station_location_id ,
648 p_education_level_o => ghr_par_shd.g_old_rec.education_level ,
649 p_effective_date_o => ghr_par_shd.g_old_rec.effective_date ,
650 p_employee_assignment_id_o => ghr_par_shd.g_old_rec.employee_assignment_id ,
651 p_employee_date_of_birth_o => ghr_par_shd.g_old_rec.employee_date_of_birth ,
652 p_employee_dept_or_agency_o => ghr_par_shd.g_old_rec.employee_dept_or_agency ,
653 p_employee_first_name_o => ghr_par_shd.g_old_rec.employee_first_name ,
654 p_employee_last_name_o => ghr_par_shd.g_old_rec.employee_last_name ,
655 p_employee_middle_names_o => ghr_par_shd.g_old_rec.employee_middle_names ,
656 p_employee_national_identifi_o => ghr_par_shd.g_old_rec.employee_national_identifier ,
657 p_fegli_o => ghr_par_shd.g_old_rec.fegli ,
658 p_fegli_desc_o => ghr_par_shd.g_old_rec.fegli_desc ,
659 p_first_action_la_code1_o => ghr_par_shd.g_old_rec.first_action_la_code1 ,
660 p_first_action_la_code2_o => ghr_par_shd.g_old_rec.first_action_la_code2 ,
661 p_first_action_la_desc1_o => ghr_par_shd.g_old_rec.first_action_la_desc1 ,
662 p_first_action_la_desc2_o => ghr_par_shd.g_old_rec.first_action_la_desc2 ,
663 p_first_noa_cancel_or_correc_o => ghr_par_shd.g_old_rec.first_noa_cancel_or_correct ,
664 p_first_noa_code_o => ghr_par_shd.g_old_rec.first_noa_code ,
665 p_first_noa_desc_o => ghr_par_shd.g_old_rec.first_noa_desc ,
666 p_first_noa_id_o => ghr_par_shd.g_old_rec.first_noa_id ,
667 p_first_noa_pa_request_id_o => ghr_par_shd.g_old_rec.first_noa_pa_request_id ,
668 p_flsa_category_o => ghr_par_shd.g_old_rec.flsa_category ,
669 p_forwarding_address_line1_o => ghr_par_shd.g_old_rec.forwarding_address_line1 ,
670 p_forwarding_address_line2_o => ghr_par_shd.g_old_rec.forwarding_address_line2 ,
671 p_forwarding_address_line3_o => ghr_par_shd.g_old_rec.forwarding_address_line3 ,
672 p_forwarding_country_o => ghr_par_shd.g_old_rec.forwarding_country ,
673 p_forwarding_country_short_n_o => ghr_par_shd.g_old_rec.forwarding_country_short_name ,
674 p_forwarding_postal_code_o => ghr_par_shd.g_old_rec.forwarding_postal_code ,
675 p_forwarding_region_2_o => ghr_par_shd.g_old_rec.forwarding_region_2 ,
676 p_forwarding_town_or_city_o => ghr_par_shd.g_old_rec.forwarding_town_or_city ,
677 p_from_adj_basic_pay_o => ghr_par_shd.g_old_rec.from_adj_basic_pay ,
678 p_from_agency_code_o => ghr_par_shd.g_old_rec.from_agency_code ,
679 p_from_agency_desc_o => ghr_par_shd.g_old_rec.from_agency_desc ,
680 p_from_basic_pay_o => ghr_par_shd.g_old_rec.from_basic_pay ,
681 p_from_grade_or_level_o => ghr_par_shd.g_old_rec.from_grade_or_level ,
682 p_from_locality_adj_o => ghr_par_shd.g_old_rec.from_locality_adj ,
683 p_from_occ_code_o => ghr_par_shd.g_old_rec.from_occ_code ,
684 p_from_office_symbol_o => ghr_par_shd.g_old_rec.from_office_symbol ,
685 p_from_other_pay_amount_o => ghr_par_shd.g_old_rec.from_other_pay_amount ,
686 p_from_pay_basis_o => ghr_par_shd.g_old_rec.from_pay_basis ,
687 p_from_pay_plan_o => ghr_par_shd.g_old_rec.from_pay_plan ,
688 -- FWFA Changes Bug#4444609
689 -- p_input_pay_rate_determinant_o => ghr_par_shd.g_old_rec.input_pay_rate_determinant ,
690 -- p_from_pay_table_identifier_o => ghr_par_shd.g_old_rec.from_pay_table_identifier ,
691 -- FWFA Changes
692 p_from_position_id_o => ghr_par_shd.g_old_rec.from_position_id ,
693 p_from_position_org_line1_o => ghr_par_shd.g_old_rec.from_position_org_line1 ,
694 p_from_position_org_line2_o => ghr_par_shd.g_old_rec.from_position_org_line2 ,
695 p_from_position_org_line3_o => ghr_par_shd.g_old_rec.from_position_org_line3 ,
696 p_from_position_org_line4_o => ghr_par_shd.g_old_rec.from_position_org_line4 ,
697 p_from_position_org_line5_o => ghr_par_shd.g_old_rec.from_position_org_line5 ,
698 p_from_position_org_line6_o => ghr_par_shd.g_old_rec.from_position_org_line6 ,
699 p_from_position_number_o => ghr_par_shd.g_old_rec.from_position_number ,
700 p_from_position_seq_no_o => ghr_par_shd.g_old_rec.from_position_seq_no ,
701 p_from_position_title_o => ghr_par_shd.g_old_rec.from_position_title ,
702 p_from_step_or_rate_o => ghr_par_shd.g_old_rec.from_step_or_rate ,
703 p_from_total_salary_o => ghr_par_shd.g_old_rec.from_total_salary ,
704 p_functional_class_o => ghr_par_shd.g_old_rec.functional_class ,
705 p_notepad_o => ghr_par_shd.g_old_rec.notepad ,
706 p_part_time_hours_o => ghr_par_shd.g_old_rec.part_time_hours ,
707 p_pay_rate_determinant_o => ghr_par_shd.g_old_rec.pay_rate_determinant ,
708 p_personnel_office_id_o => ghr_par_shd.g_old_rec.personnel_office_id ,
709 p_person_id_o => ghr_par_shd.g_old_rec.person_id ,
710 p_position_occupied_o => ghr_par_shd.g_old_rec.position_occupied ,
711 p_proposed_effective_date_o => ghr_par_shd.g_old_rec.proposed_effective_date ,
712 p_requested_by_person_id_o => ghr_par_shd.g_old_rec.requested_by_person_id ,
713 p_requested_by_title_o => ghr_par_shd.g_old_rec.requested_by_title ,
714 p_requested_date_o => ghr_par_shd.g_old_rec.requested_date ,
715 p_requesting_office_remark_d_o => ghr_par_shd.g_old_rec.requesting_office_remarks_desc ,
716 p_requesting_office_remark_f_o => ghr_par_shd.g_old_rec.requesting_office_remarks_flag ,
717 p_request_number_o => ghr_par_shd.g_old_rec.request_number ,
718 p_resign_and_retire_reason_d_o => ghr_par_shd.g_old_rec.resign_and_retire_reason_desc ,
719 p_retirement_plan_o => ghr_par_shd.g_old_rec.retirement_plan ,
720 p_retirement_plan_desc_o => ghr_par_shd.g_old_rec.retirement_plan_desc ,
721 p_second_action_la_code1_o => ghr_par_shd.g_old_rec.second_action_la_code1 ,
722 p_second_action_la_code2_o => ghr_par_shd.g_old_rec.second_action_la_code2 ,
723 p_second_action_la_desc1_o => ghr_par_shd.g_old_rec.second_action_la_desc1 ,
724 p_second_action_la_desc2_o => ghr_par_shd.g_old_rec.second_action_la_desc2 ,
725 p_second_noa_cancel_or_corre_o => ghr_par_shd.g_old_rec.second_noa_cancel_or_correct ,
726 p_second_noa_code_o => ghr_par_shd.g_old_rec.second_noa_code ,
727 p_second_noa_desc_o => ghr_par_shd.g_old_rec.second_noa_desc ,
728 p_second_noa_id_o => ghr_par_shd.g_old_rec.second_noa_id ,
729 p_second_noa_pa_request_id_o => ghr_par_shd.g_old_rec.second_noa_pa_request_id ,
730 p_service_comp_date_o => ghr_par_shd.g_old_rec.service_comp_date ,
731 p_status_o => ghr_par_shd.g_old_rec.status ,
732 p_supervisory_status_o => ghr_par_shd.g_old_rec.supervisory_status ,
733 p_tenure_o => ghr_par_shd.g_old_rec.tenure ,
734 p_to_adj_basic_pay_o => ghr_par_shd.g_old_rec.to_adj_basic_pay ,
735 p_to_basic_pay_o => ghr_par_shd.g_old_rec.to_basic_pay ,
736 p_to_grade_id_o => ghr_par_shd.g_old_rec.to_grade_id ,
737 p_to_grade_or_level_o => ghr_par_shd.g_old_rec.to_grade_or_level ,
738 p_to_job_id_o => ghr_par_shd.g_old_rec.to_job_id ,
739 p_to_locality_adj_o => ghr_par_shd.g_old_rec.to_locality_adj ,
740 p_to_occ_code_o => ghr_par_shd.g_old_rec.to_occ_code ,
741 p_to_office_symbol_o => ghr_par_shd.g_old_rec.to_office_symbol ,
742 p_to_organization_id_o => ghr_par_shd.g_old_rec.to_organization_id ,
743 p_to_other_pay_amount_o => ghr_par_shd.g_old_rec.to_other_pay_amount ,
744 p_to_au_overtime_o => ghr_par_shd.g_old_rec.to_au_overtime ,
745 p_to_auo_premium_pay_indicat_o => ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator ,
746 p_to_availability_pay_o => ghr_par_shd.g_old_rec.to_availability_pay ,
747 p_to_ap_premium_pay_indicato_o => ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator ,
748 p_to_retention_allowance_o => ghr_par_shd.g_old_rec.to_retention_allowance ,
749 p_to_supervisory_differentia_o => ghr_par_shd.g_old_rec.to_supervisory_differential ,
750 p_to_staffing_differential_o => ghr_par_shd.g_old_rec.to_staffing_differential ,
751 p_to_pay_basis_o => ghr_par_shd.g_old_rec.to_pay_basis ,
752 p_to_pay_plan_o => ghr_par_shd.g_old_rec.to_pay_plan ,
753 -- FWFA Changes Bug#4444609
754 -- p_to_pay_table_identifier_o => ghr_par_shd.g_old_rec.to_pay_table_identifier ,
755 -- FWFA Changes
756 p_to_position_id_o => ghr_par_shd.g_old_rec.to_position_id ,
757 p_to_position_org_line1_o => ghr_par_shd.g_old_rec.to_position_org_line1 ,
758 p_to_position_org_line2_o => ghr_par_shd.g_old_rec.to_position_org_line2 ,
759 p_to_position_org_line3_o => ghr_par_shd.g_old_rec.to_position_org_line3 ,
760 p_to_position_org_line4_o => ghr_par_shd.g_old_rec.to_position_org_line4 ,
761 p_to_position_org_line5_o => ghr_par_shd.g_old_rec.to_position_org_line5 ,
762 p_to_position_org_line6_o => ghr_par_shd.g_old_rec.to_position_org_line6 ,
763 p_to_position_number_o => ghr_par_shd.g_old_rec.to_position_number ,
764 p_to_position_seq_no_o => ghr_par_shd.g_old_rec.to_position_seq_no ,
765 p_to_position_title_o => ghr_par_shd.g_old_rec.to_position_title ,
766 p_to_step_or_rate_o => ghr_par_shd.g_old_rec.to_step_or_rate ,
767 p_to_total_salary_o => ghr_par_shd.g_old_rec.to_total_salary ,
768 p_veterans_preference_o => ghr_par_shd.g_old_rec.veterans_preference ,
769 p_veterans_pref_for_rif_o => ghr_par_shd.g_old_rec.veterans_pref_for_rif ,
770 p_veterans_status_o => ghr_par_shd.g_old_rec.veterans_status ,
771 p_work_schedule_o => ghr_par_shd.g_old_rec.work_schedule ,
772 p_work_schedule_desc_o => ghr_par_shd.g_old_rec.work_schedule_desc ,
773 p_year_degree_attained_o => ghr_par_shd.g_old_rec.year_degree_attained ,
774 p_first_noa_information1_o => ghr_par_shd.g_old_rec.first_noa_information1 ,
775 p_first_noa_information2_o => ghr_par_shd.g_old_rec.first_noa_information2 ,
776 p_first_noa_information3_o => ghr_par_shd.g_old_rec.first_noa_information3 ,
777 p_first_noa_information4_o => ghr_par_shd.g_old_rec.first_noa_information4 ,
778 p_first_noa_information5_o => ghr_par_shd.g_old_rec.first_noa_information5 ,
779 p_second_lac1_information1_o => ghr_par_shd.g_old_rec.second_lac1_information1 ,
780 p_second_lac1_information2_o => ghr_par_shd.g_old_rec.second_lac1_information2 ,
781 p_second_lac1_information3_o => ghr_par_shd.g_old_rec.second_lac1_information3 ,
782 p_second_lac1_information4_o => ghr_par_shd.g_old_rec.second_lac1_information4 ,
783 p_second_lac1_information5_o => ghr_par_shd.g_old_rec.second_lac1_information5 ,
784 p_second_lac2_information1_o => ghr_par_shd.g_old_rec.second_lac2_information1 ,
785 p_second_lac2_information2_o => ghr_par_shd.g_old_rec.second_lac2_information2 ,
786 p_second_lac2_information3_o => ghr_par_shd.g_old_rec.second_lac2_information3 ,
787 p_second_lac2_information4_o => ghr_par_shd.g_old_rec.second_lac2_information4 ,
788 p_second_lac2_information5_o => ghr_par_shd.g_old_rec.second_lac2_information5 ,
789 p_second_noa_information1_o => ghr_par_shd.g_old_rec.second_noa_information1 ,
790 p_second_noa_information2_o => ghr_par_shd.g_old_rec.second_noa_information2 ,
791 p_second_noa_information3_o => ghr_par_shd.g_old_rec.second_noa_information3 ,
792 p_second_noa_information4_o => ghr_par_shd.g_old_rec.second_noa_information4 ,
793 p_second_noa_information5_o => ghr_par_shd.g_old_rec.second_noa_information5 ,
794 p_first_lac1_information1_o => ghr_par_shd.g_old_rec.first_lac1_information1 ,
795 p_first_lac1_information2_o => ghr_par_shd.g_old_rec.first_lac1_information2 ,
796 p_first_lac1_information3_o => ghr_par_shd.g_old_rec.first_lac1_information3 ,
797 p_first_lac1_information4_o => ghr_par_shd.g_old_rec.first_lac1_information4 ,
798 p_first_lac1_information5_o => ghr_par_shd.g_old_rec.first_lac1_information5 ,
799 p_first_lac2_information1_o => ghr_par_shd.g_old_rec.first_lac2_information1 ,
800 p_first_lac2_information2_o => ghr_par_shd.g_old_rec.first_lac2_information2 ,
801 p_first_lac2_information3_o => ghr_par_shd.g_old_rec.first_lac2_information3 ,
802 p_first_lac2_information4_o => ghr_par_shd.g_old_rec.first_lac2_information4 ,
803 p_first_lac2_information5_o => ghr_par_shd.g_old_rec.first_lac2_information5 ,
804 p_attribute_category_o => ghr_par_shd.g_old_rec.attribute_category ,
805 p_attribute1_o => ghr_par_shd.g_old_rec.attribute1 ,
806 p_attribute2_o => ghr_par_shd.g_old_rec.attribute2 ,
807 p_attribute3_o => ghr_par_shd.g_old_rec.attribute3 ,
808 p_attribute4_o => ghr_par_shd.g_old_rec.attribute4 ,
809 p_attribute5_o => ghr_par_shd.g_old_rec.attribute5 ,
810 p_attribute6_o => ghr_par_shd.g_old_rec.attribute6 ,
811 p_attribute7_o => ghr_par_shd.g_old_rec.attribute7 ,
812 p_attribute8_o => ghr_par_shd.g_old_rec.attribute8 ,
813 p_attribute9_o => ghr_par_shd.g_old_rec.attribute9 ,
814 p_attribute10_o => ghr_par_shd.g_old_rec.attribute10 ,
815 p_attribute11_o => ghr_par_shd.g_old_rec.attribute11 ,
816 p_attribute12_o => ghr_par_shd.g_old_rec.attribute12 ,
817 p_attribute13_o => ghr_par_shd.g_old_rec.attribute13 ,
818 p_attribute14_o => ghr_par_shd.g_old_rec.attribute14 ,
819 p_attribute15_o => ghr_par_shd.g_old_rec.attribute15 ,
820 p_attribute16_o => ghr_par_shd.g_old_rec.attribute16 ,
821 p_attribute17_o => ghr_par_shd.g_old_rec.attribute17 ,
822 p_attribute18_o => ghr_par_shd.g_old_rec.attribute18 ,
823 p_attribute19_o => ghr_par_shd.g_old_rec.attribute19 ,
824 p_attribute20_o => ghr_par_shd.g_old_rec.attribute20 ,
825 p_first_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id ,
826 p_second_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id ,
827 p_to_retention_allow_percent_o => ghr_par_shd.g_old_rec.to_retention_allow_percentage ,
828 p_to_supervisory_diff_percen_o => ghr_par_shd.g_old_rec.to_supervisory_diff_percentage,
829 p_to_staffing_diff_percentag_o => ghr_par_shd.g_old_rec.to_staffing_diff_percentage ,
830 p_award_percentage_o => ghr_par_shd.g_old_rec.award_percentage ,
831 p_rpa_type_o => ghr_par_shd.g_old_rec.rpa_type,
832 p_mass_action_id_o => ghr_par_shd.g_old_rec.mass_action_id,
833 p_mass_action_eligible_flag_o => ghr_par_shd.g_old_rec.mass_action_eligible_flag,
834 p_mass_action_select_flag_o => ghr_par_shd.g_old_rec.mass_action_select_flag,
835 p_mass_action_comments_o => ghr_par_shd.g_old_rec.mass_action_comments
836 );
837 exception
838 when hr_api.cannot_find_prog_unit then
839 hr_api.cannot_find_prog_unit_error
840 ( p_module_name => 'GHR_PA_REQUESTS'
841 ,p_hook_type => 'AU'
842 );
843 end;
844 -- End of API User Hook for post_insert.
845
846 hr_utility.set_location(' Leaving:'||l_proc, 10);
847 End post_update;
848 --
849 -- ----------------------------------------------------------------------------
850 -- |-----------------------------< convert_defs >-----------------------------|
851 -- ----------------------------------------------------------------------------
852 -- {Start Of Comments}
853 --
854 -- Description:
855 -- The Convert_Defs procedure has one very important function:
856
857 -- It must return the record structure for the row with all system defaulted
858 -- values converted into its corresponding parameter value for update. When
859 -- we attempt to update a row through the Upd process , certain
860 -- parameters can be defaulted which enables flexibility in the calling of
861 -- the upd process (e.g. only attributes which need to be updated need to be
862 -- specified). For the upd process to determine which attributes
863 -- have NOT been specified we need to check if the parameter has a reserved
864 -- system default value. Therefore, for all parameters which have a
865 -- corresponding reserved system default mechanism specified we need to
866 -- check if a system default is being used. If a system default is being
867 -- used then we convert the defaulted value into its corresponding attribute
868 -- value held in the g_old_rec data structure.
869 --
870 -- Prerequisites:
871 -- This private function can only be called from the upd process.
872 --
873 -- In Parameters:
874 -- A Pl/Sql record structre.
875 --
876 -- Post Success:
877 -- The record structure will be returned with all system defaulted parameter
878 -- values converted into its current row attribute value.
879 --
880 -- Post Failure:
881 -- No direct error handling is required within this function. Any possible
882 -- errors within this procedure will be a PL/SQL value error due to conversion
883
884 -- of datatypes or data lengths.
885 --
886 -- Developer Implementation Notes:
887 -- None.
888 --
889 -- Access Status:
890 -- Internal Row Handler Use Only.
891 --
892 -- {End Of Comments}
893 -- ----------------------------------------------------------------------------
894 Procedure convert_defs(p_rec in out nocopy ghr_par_shd.g_rec_type) is
895 --
896 l_proc varchar2(72) := g_package||'convert_defs';
897 --
898 Begin
899 --
900 hr_utility.set_location('Entering:'||l_proc, 5);
901 --
902 -- We must now examine each argument value in the
903 -- p_rec plsql record structure
904 -- to see if a system default is being used. If a system default
905 -- is being used then we must set to the 'current' argument value.
906 --
907 If (p_rec.pa_notification_id = hr_api.g_number) then
908 p_rec.pa_notification_id :=
909 ghr_par_shd.g_old_rec.pa_notification_id;
910 End If;
911 If (p_rec.noa_family_code = hr_api.g_varchar2) then
912 p_rec.noa_family_code :=
913 ghr_par_shd.g_old_rec.noa_family_code;
914 End If;
915 If (p_rec.routing_group_id = hr_api.g_number) then
916 p_rec.routing_group_id :=
917 ghr_par_shd.g_old_rec.routing_group_id;
918 End If;
919 If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
920 p_rec.proposed_effective_asap_flag :=
921 ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
922 End If;
923 If (p_rec.academic_discipline = hr_api.g_varchar2) then
924 p_rec.academic_discipline :=
925 ghr_par_shd.g_old_rec.academic_discipline;
926 End If;
927 If (p_rec.additional_info_person_id = hr_api.g_number) then
928 p_rec.additional_info_person_id :=
929 ghr_par_shd.g_old_rec.additional_info_person_id;
930 End If;
931 If (p_rec.additional_info_tel_number = hr_api.g_varchar2) then
932 p_rec.additional_info_tel_number :=
933 ghr_par_shd.g_old_rec.additional_info_tel_number;
934 End If;
935 If (p_rec.agency_code = hr_api.g_varchar2) then
936 p_rec.agency_code :=
937 ghr_par_shd.g_old_rec.agency_code;
938 End If;
939 If (p_rec.altered_pa_request_id = hr_api.g_number) then
940 p_rec.altered_pa_request_id :=
941 ghr_par_shd.g_old_rec.altered_pa_request_id;
942 End If;
943 If (p_rec.annuitant_indicator = hr_api.g_varchar2) then
944 p_rec.annuitant_indicator :=
945 ghr_par_shd.g_old_rec.annuitant_indicator;
946 End If;
947 If (p_rec.annuitant_indicator_desc = hr_api.g_varchar2) then
948 p_rec.annuitant_indicator_desc :=
949 ghr_par_shd.g_old_rec.annuitant_indicator_desc;
950 End If;
951 If (p_rec.appropriation_code1 = hr_api.g_varchar2) then
952 p_rec.appropriation_code1 :=
953 ghr_par_shd.g_old_rec.appropriation_code1;
954 End If;
955 If (p_rec.appropriation_code2 = hr_api.g_varchar2) then
956 p_rec.appropriation_code2 :=
957 ghr_par_shd.g_old_rec.appropriation_code2;
958 End If;
959 If (p_rec.approval_date = hr_api.g_date) then
960 p_rec.approval_date :=
961 ghr_par_shd.g_old_rec.approval_date;
962 End If;
963 If (p_rec.approving_official_full_name = hr_api.g_varchar2) then
964 p_rec.approving_official_full_name :=
965 ghr_par_shd.g_old_rec.approving_official_full_name;
966 End If;
967 If (p_rec.approving_official_work_title = hr_api.g_varchar2) then
968 p_rec.approving_official_work_title :=
969 ghr_par_shd.g_old_rec.approving_official_work_title;
970 End If;
971 If (p_rec.sf50_approval_date = hr_api.g_date) then
972 p_rec.sf50_approval_date :=
973 ghr_par_shd.g_old_rec.sf50_approval_date;
974 End If;
975 If (p_rec.sf50_approving_ofcl_full_name = hr_api.g_varchar2) then
976 p_rec.sf50_approving_ofcl_full_name :=
977 ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ;
978 End If;
979 If (p_rec.sf50_approving_ofcl_work_title = hr_api.g_varchar2) then
980 p_rec.sf50_approving_ofcl_work_title :=
981 ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title;
982 End If;
983 If (p_rec.authorized_by_person_id = hr_api.g_number) then
984 p_rec.authorized_by_person_id :=
985 ghr_par_shd.g_old_rec.authorized_by_person_id;
986 End If;
987 If (p_rec.authorized_by_title = hr_api.g_varchar2) then
988 p_rec.authorized_by_title :=
989 ghr_par_shd.g_old_rec.authorized_by_title;
990 End If;
991 If (p_rec.award_amount = hr_api.g_number) then
992 p_rec.award_amount :=
993 ghr_par_shd.g_old_rec.award_amount;
994 End If;
995 If (p_rec.award_uom = hr_api.g_varchar2) then
996 p_rec.award_uom :=
997 ghr_par_shd.g_old_rec.award_uom;
998 End If;
999 If (p_rec.bargaining_unit_status = hr_api.g_varchar2) then
1000 p_rec.bargaining_unit_status :=
1001 ghr_par_shd.g_old_rec.bargaining_unit_status;
1002 End If;
1003 If (p_rec.citizenship = hr_api.g_varchar2) then
1004 p_rec.citizenship :=
1005 ghr_par_shd.g_old_rec.citizenship;
1006 End If;
1007 If (p_rec.concurrence_date = hr_api.g_date) then
1008 p_rec.concurrence_date :=
1009 ghr_par_shd.g_old_rec.concurrence_date;
1010 End If;
1011 If (p_rec.custom_pay_calc_flag = hr_api.g_varchar2) then
1012 p_rec.custom_pay_calc_flag :=
1013 ghr_par_shd.g_old_rec.custom_pay_calc_flag;
1014 End If;
1015 If (p_rec.duty_station_code = hr_api.g_varchar2) then
1016 p_rec.duty_station_code :=
1017 ghr_par_shd.g_old_rec.duty_station_code;
1018 End If;
1019 If (p_rec.duty_station_desc = hr_api.g_varchar2) then
1020 p_rec.duty_station_desc :=
1021 ghr_par_shd.g_old_rec.duty_station_desc;
1022 End If;
1023 If (p_rec.duty_station_id = hr_api.g_number) then
1024 p_rec.duty_station_id :=
1025 ghr_par_shd.g_old_rec.duty_station_id;
1026 End If;
1027 If (p_rec.duty_station_location_id = hr_api.g_number) then
1028 p_rec.duty_station_location_id :=
1029 ghr_par_shd.g_old_rec.duty_station_location_id;
1030 End If;
1031 If (p_rec.education_level = hr_api.g_varchar2) then
1032 p_rec.education_level :=
1033 ghr_par_shd.g_old_rec.education_level;
1034 End If;
1035 If (p_rec.effective_date = hr_api.g_date) then
1036 p_rec.effective_date :=
1037 ghr_par_shd.g_old_rec.effective_date;
1038 End If;
1039 If (p_rec.employee_assignment_id = hr_api.g_number) then
1040 p_rec.employee_assignment_id :=
1041 ghr_par_shd.g_old_rec.employee_assignment_id;
1042 End If;
1043 If (p_rec.employee_date_of_birth = hr_api.g_date) then
1044 p_rec.employee_date_of_birth :=
1045 ghr_par_shd.g_old_rec.employee_date_of_birth;
1046 End If;
1047 If (p_rec.employee_dept_or_agency = hr_api.g_varchar2) then
1048 p_rec.employee_dept_or_agency :=
1049 ghr_par_shd.g_old_rec.employee_dept_or_agency;
1050 End If;
1051 If (p_rec.employee_first_name = hr_api.g_varchar2) then
1052 p_rec.employee_first_name :=
1053 ghr_par_shd.g_old_rec.employee_first_name;
1054 End If;
1055 If (p_rec.employee_last_name = hr_api.g_varchar2) then
1056 p_rec.employee_last_name :=
1057 ghr_par_shd.g_old_rec.employee_last_name;
1058 End If;
1059 If (p_rec.employee_middle_names = hr_api.g_varchar2) then
1060 p_rec.employee_middle_names :=
1061 ghr_par_shd.g_old_rec.employee_middle_names;
1062 End If;
1063 If (p_rec.employee_national_identifier = hr_api.g_varchar2) then
1064 p_rec.employee_national_identifier :=
1065 ghr_par_shd.g_old_rec.employee_national_identifier;
1066 End If;
1067 If (p_rec.fegli = hr_api.g_varchar2) then
1068 p_rec.fegli :=
1069 ghr_par_shd.g_old_rec.fegli;
1070 End If;
1071 If (p_rec.fegli_desc = hr_api.g_varchar2) then
1072 p_rec.fegli_desc :=
1073 ghr_par_shd.g_old_rec.fegli_desc;
1074 End If;
1075 If (p_rec.first_action_la_code1 = hr_api.g_varchar2) then
1076 p_rec.first_action_la_code1 :=
1077 ghr_par_shd.g_old_rec.first_action_la_code1;
1078 End If;
1079 If (p_rec.first_action_la_code2 = hr_api.g_varchar2) then
1080 p_rec.first_action_la_code2 :=
1081 ghr_par_shd.g_old_rec.first_action_la_code2;
1082 End If;
1083 If (p_rec.first_action_la_desc1 = hr_api.g_varchar2) then
1084 p_rec.first_action_la_desc1 :=
1085 ghr_par_shd.g_old_rec.first_action_la_desc1;
1086 End If;
1087 If (p_rec.first_action_la_desc2 = hr_api.g_varchar2) then
1088 p_rec.first_action_la_desc2 :=
1089 ghr_par_shd.g_old_rec.first_action_la_desc2;
1090 End If;
1091 If (p_rec.first_noa_cancel_or_correct = hr_api.g_varchar2) then
1092 p_rec.first_noa_cancel_or_correct :=
1093 ghr_par_shd.g_old_rec.first_noa_cancel_or_correct;
1094 End If;
1095 If (p_rec.first_noa_code = hr_api.g_varchar2) then
1096 p_rec.first_noa_code :=
1097 ghr_par_shd.g_old_rec.first_noa_code;
1098 End If;
1099 If (p_rec.first_noa_desc = hr_api.g_varchar2) then
1100 p_rec.first_noa_desc :=
1101 ghr_par_shd.g_old_rec.first_noa_desc;
1102 End If;
1103 If (p_rec.first_noa_id = hr_api.g_number) then
1104 p_rec.first_noa_id :=
1105 ghr_par_shd.g_old_rec.first_noa_id;
1106 End If;
1107 If (p_rec.first_noa_pa_request_id = hr_api.g_number) then
1108 p_rec.first_noa_pa_request_id :=
1109 ghr_par_shd.g_old_rec.first_noa_pa_request_id;
1110 End If;
1111 If (p_rec.flsa_category = hr_api.g_varchar2) then
1112 p_rec.flsa_category :=
1113 ghr_par_shd.g_old_rec.flsa_category;
1114 End If;
1115 If (p_rec.forwarding_address_line1 = hr_api.g_varchar2) then
1116 p_rec.forwarding_address_line1 :=
1117 ghr_par_shd.g_old_rec.forwarding_address_line1;
1118 End If;
1119 If (p_rec.forwarding_address_line2 = hr_api.g_varchar2) then
1120 p_rec.forwarding_address_line2 :=
1121 ghr_par_shd.g_old_rec.forwarding_address_line2;
1122 End If;
1123 If (p_rec.forwarding_address_line3 = hr_api.g_varchar2) then
1124 p_rec.forwarding_address_line3 :=
1125 ghr_par_shd.g_old_rec.forwarding_address_line3;
1126 End If;
1127 If (p_rec.forwarding_country_short_name = hr_api.g_varchar2) then
1128 p_rec.forwarding_country_short_name :=
1129 ghr_par_shd.g_old_rec.forwarding_country_short_name;
1130 End If;
1131 If (p_rec.forwarding_country = hr_api.g_varchar2) then
1132 p_rec.forwarding_country :=
1133 ghr_par_shd.g_old_rec.forwarding_country;
1134 End If;
1135 If (p_rec.forwarding_postal_code = hr_api.g_varchar2) then
1136 p_rec.forwarding_postal_code :=
1137 ghr_par_shd.g_old_rec.forwarding_postal_code;
1138 End If;
1139 If (p_rec.forwarding_region_2 = hr_api.g_varchar2) then
1140 p_rec.forwarding_region_2 :=
1141 ghr_par_shd.g_old_rec.forwarding_region_2;
1142 End If;
1143 If (p_rec.forwarding_town_or_city = hr_api.g_varchar2) then
1144 p_rec.forwarding_town_or_city :=
1145 ghr_par_shd.g_old_rec.forwarding_town_or_city;
1146 End If;
1147 If (p_rec.from_adj_basic_pay = hr_api.g_number) then
1148 p_rec.from_adj_basic_pay :=
1149 ghr_par_shd.g_old_rec.from_adj_basic_pay;
1150 End If;
1151 If (p_rec.from_agency_code = hr_api.g_varchar2) then
1152 p_rec.from_agency_code :=
1153 ghr_par_shd.g_old_rec.from_agency_code;
1154 End If;
1155 If (p_rec.from_agency_desc = hr_api.g_varchar2) then
1156 p_rec.from_agency_desc :=
1157 ghr_par_shd.g_old_rec.from_agency_desc;
1158 End If;
1159 If (p_rec.from_basic_pay = hr_api.g_number) then
1160 p_rec.from_basic_pay :=
1161 ghr_par_shd.g_old_rec.from_basic_pay;
1162 End If;
1163 If (p_rec.from_grade_or_level = hr_api.g_varchar2) then
1164 p_rec.from_grade_or_level :=
1165 ghr_par_shd.g_old_rec.from_grade_or_level;
1166 End If;
1167 If (p_rec.from_locality_adj = hr_api.g_number) then
1168 p_rec.from_locality_adj :=
1169 ghr_par_shd.g_old_rec.from_locality_adj;
1170 End If;
1171 If (p_rec.from_occ_code = hr_api.g_varchar2) then
1172 p_rec.from_occ_code :=
1173 ghr_par_shd.g_old_rec.from_occ_code;
1174 End If;
1175 If (p_rec.from_office_symbol = hr_api.g_varchar2) then
1176 p_rec.from_office_symbol :=
1177 ghr_par_shd.g_old_rec.from_office_symbol;
1178 End If;
1179 If (p_rec.from_other_pay_amount = hr_api.g_number) then
1180 p_rec.from_other_pay_amount :=
1181 ghr_par_shd.g_old_rec.from_other_pay_amount;
1182 End If;
1183 If (p_rec.from_pay_basis = hr_api.g_varchar2) then
1184 p_rec.from_pay_basis :=
1185 ghr_par_shd.g_old_rec.from_pay_basis;
1186 End If;
1187 If (p_rec.from_pay_plan = hr_api.g_varchar2) then
1188 p_rec.from_pay_plan :=
1189 ghr_par_shd.g_old_rec.from_pay_plan;
1190 End If;
1191 -- FWFA Changes Bug#4444609
1192 If (p_rec.input_pay_rate_determinant = hr_api.g_varchar2) then
1193 p_rec.input_pay_rate_determinant :=
1194 ghr_par_shd.g_old_rec.input_pay_rate_determinant;
1195 End If;
1196 If (p_rec.from_pay_table_identifier = hr_api.g_number) then
1197 p_rec.from_pay_table_identifier :=
1198 ghr_par_shd.g_old_rec.from_pay_table_identifier;
1199 End If;
1200 -- FWFA Changes
1201 If (p_rec.from_position_org_line1 = hr_api.g_varchar2) then
1202 p_rec.from_position_org_line1 :=
1203 ghr_par_shd.g_old_rec.from_position_org_line1;
1204 End If;
1205 If (p_rec.from_position_org_line2 = hr_api.g_varchar2) then
1206 p_rec.from_position_org_line2 :=
1207 ghr_par_shd.g_old_rec.from_position_org_line2;
1208 End If;
1209 If (p_rec.from_position_org_line3 = hr_api.g_varchar2) then
1210 p_rec.from_position_org_line3 :=
1211 ghr_par_shd.g_old_rec.from_position_org_line3;
1212 End If;
1213 If (p_rec.from_position_org_line4 = hr_api.g_varchar2) then
1214 p_rec.from_position_org_line4 :=
1215 ghr_par_shd.g_old_rec.from_position_org_line4;
1216 End If;
1217 If (p_rec.from_position_org_line5 = hr_api.g_varchar2) then
1218 p_rec.from_position_org_line5 :=
1219 ghr_par_shd.g_old_rec.from_position_org_line5;
1220 End If;
1221 If (p_rec.from_position_org_line6 = hr_api.g_varchar2) then
1222 p_rec.from_position_org_line6 :=
1223 ghr_par_shd.g_old_rec.from_position_org_line6;
1224 End If;
1225 If (p_rec.from_position_id = hr_api.g_number) then
1226 p_rec.from_position_id :=
1227 ghr_par_shd.g_old_rec.from_position_id;
1228 End If;
1229 If (p_rec.from_position_number = hr_api.g_varchar2) then
1230 p_rec.from_position_number :=
1231 ghr_par_shd.g_old_rec.from_position_number;
1232 End If;
1233 If (p_rec.from_position_seq_no = hr_api.g_number) then
1234 p_rec.from_position_seq_no :=
1235 ghr_par_shd.g_old_rec.from_position_seq_no;
1236 End If;
1237 If (p_rec.from_position_title = hr_api.g_varchar2) then
1238 p_rec.from_position_title :=
1239 ghr_par_shd.g_old_rec.from_position_title;
1240 End If;
1241 If (p_rec.from_step_or_rate = hr_api.g_varchar2) then
1242 p_rec.from_step_or_rate :=
1243 ghr_par_shd.g_old_rec.from_step_or_rate;
1244 End If;
1245 If (p_rec.from_total_salary = hr_api.g_number) then
1246 p_rec.from_total_salary :=
1247 ghr_par_shd.g_old_rec.from_total_salary;
1248 End If;
1249 If (p_rec.functional_class = hr_api.g_varchar2) then
1250 p_rec.functional_class :=
1251 ghr_par_shd.g_old_rec.functional_class;
1252 End If;
1253 If (p_rec.notepad = hr_api.g_varchar2) then
1254 p_rec.notepad :=
1255 ghr_par_shd.g_old_rec.notepad;
1256 End If;
1257 If (p_rec.part_time_hours = hr_api.g_number) then
1258 p_rec.part_time_hours :=
1259 ghr_par_shd.g_old_rec.part_time_hours;
1260 End If;
1261 If (p_rec.pay_rate_determinant = hr_api.g_varchar2) then
1262 p_rec.pay_rate_determinant :=
1263 ghr_par_shd.g_old_rec.pay_rate_determinant;
1264 End If;
1265 If (p_rec.personnel_office_id = hr_api.g_varchar2) then
1266 p_rec.personnel_office_id :=
1267 ghr_par_shd.g_old_rec.personnel_office_id;
1268 End If;
1269 If (p_rec.person_id = hr_api.g_number) then
1270 p_rec.person_id :=
1271 ghr_par_shd.g_old_rec.person_id;
1272 End If;
1273 If (p_rec.position_occupied = hr_api.g_varchar2) then
1274 p_rec.position_occupied :=
1275 ghr_par_shd.g_old_rec.position_occupied;
1276 End If;
1277 If (p_rec.proposed_effective_date = hr_api.g_date) then
1278 p_rec.proposed_effective_date :=
1279 ghr_par_shd.g_old_rec.proposed_effective_date;
1280 End If;
1281 If (p_rec.proposed_effective_asap_flag = hr_api.g_varchar2) then
1282 p_rec.proposed_effective_asap_flag :=
1283 ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
1284 End If;
1285
1286 If (p_rec.requested_by_person_id = hr_api.g_number) then
1287 p_rec.requested_by_person_id :=
1288 ghr_par_shd.g_old_rec.requested_by_person_id;
1289 End If;
1290 If (p_rec.requested_by_title = hr_api.g_varchar2) then
1291 p_rec.requested_by_title :=
1292 ghr_par_shd.g_old_rec.requested_by_title;
1293 End If;
1294 If (p_rec.requested_date = hr_api.g_date) then
1295 p_rec.requested_date :=
1296 ghr_par_shd.g_old_rec.requested_date;
1297 End If;
1298 If (p_rec.requesting_office_remarks_desc = hr_api.g_varchar2) then
1299 p_rec.requesting_office_remarks_desc :=
1300 ghr_par_shd.g_old_rec.requesting_office_remarks_desc;
1301 End If;
1302 If (p_rec.requesting_office_remarks_flag = hr_api.g_varchar2) then
1303 p_rec.requesting_office_remarks_flag :=
1304 ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
1305 End If;
1306 If (p_rec.request_number = hr_api.g_varchar2) then
1307 p_rec.request_number :=
1308 ghr_par_shd.g_old_rec.request_number;
1309 End If;
1310 If (p_rec.resign_and_retire_reason_desc = hr_api.g_varchar2) then
1311 p_rec.resign_and_retire_reason_desc :=
1312 ghr_par_shd.g_old_rec.resign_and_retire_reason_desc;
1313 End If;
1314 If (p_rec.retirement_plan = hr_api.g_varchar2) then
1315 p_rec.retirement_plan :=
1316 ghr_par_shd.g_old_rec.retirement_plan;
1317 End If;
1318 If (p_rec.retirement_plan_desc = hr_api.g_varchar2) then
1319 p_rec.retirement_plan_desc :=
1320 ghr_par_shd.g_old_rec.retirement_plan_desc;
1321 End If;
1322 If (p_rec.second_action_la_code1 = hr_api.g_varchar2) then
1323 p_rec.second_action_la_code1 :=
1324 ghr_par_shd.g_old_rec.second_action_la_code1;
1325 End If;
1326 If (p_rec.second_action_la_code2 = hr_api.g_varchar2) then
1327 p_rec.second_action_la_code2 :=
1328 ghr_par_shd.g_old_rec.second_action_la_code2;
1329 End If;
1330 If (p_rec.second_action_la_desc1 = hr_api.g_varchar2) then
1331 p_rec.second_action_la_desc1 :=
1332 ghr_par_shd.g_old_rec.second_action_la_desc1;
1333 End If;
1334 If (p_rec.second_action_la_desc2 = hr_api.g_varchar2) then
1335 p_rec.second_action_la_desc2 :=
1336 ghr_par_shd.g_old_rec.second_action_la_desc2;
1337 End If;
1338 If (p_rec.second_noa_cancel_or_correct = hr_api.g_varchar2) then
1339 p_rec.second_noa_cancel_or_correct :=
1340 ghr_par_shd.g_old_rec.second_noa_cancel_or_correct;
1341 End If;
1342 If (p_rec.second_noa_code = hr_api.g_varchar2) then
1343 p_rec.second_noa_code :=
1344 ghr_par_shd.g_old_rec.second_noa_code;
1345 End If;
1346 If (p_rec.second_noa_desc = hr_api.g_varchar2) then
1347 p_rec.second_noa_desc :=
1348 ghr_par_shd.g_old_rec.second_noa_desc;
1349 End If;
1350 If (p_rec.second_noa_id = hr_api.g_number) then
1351 p_rec.second_noa_id :=
1352 ghr_par_shd.g_old_rec.second_noa_id;
1353 End If;
1354 If (p_rec.second_noa_pa_request_id = hr_api.g_number) then
1355 p_rec.second_noa_pa_request_id :=
1356 ghr_par_shd.g_old_rec.second_noa_pa_request_id;
1357 End If;
1358 If (p_rec.service_comp_date = hr_api.g_date) then
1359 p_rec.service_comp_date :=
1360 ghr_par_shd.g_old_rec.service_comp_date;
1361 End If;
1362 If (p_rec.status = hr_api.g_varchar2) then
1363 p_rec.status :=
1364 ghr_par_shd.g_old_rec.status;
1365 End If;
1366 If (p_rec.supervisory_status = hr_api.g_varchar2) then
1367 p_rec.supervisory_status :=
1368 ghr_par_shd.g_old_rec.supervisory_status;
1369 End If;
1370 If (p_rec.tenure = hr_api.g_varchar2) then
1371 p_rec.tenure :=
1372 ghr_par_shd.g_old_rec.tenure;
1373 End If;
1374 If (p_rec.to_adj_basic_pay = hr_api.g_number) then
1375 p_rec.to_adj_basic_pay :=
1376 ghr_par_shd.g_old_rec.to_adj_basic_pay;
1377 End If;
1378 If (p_rec.to_basic_pay = hr_api.g_number) then
1379 p_rec.to_basic_pay :=
1380 ghr_par_shd.g_old_rec.to_basic_pay;
1381 End If;
1382 If (p_rec.to_grade_id = hr_api.g_number) then
1383 p_rec.to_grade_id :=
1384 ghr_par_shd.g_old_rec.to_grade_id;
1385 End If;
1386 If (p_rec.to_grade_or_level = hr_api.g_varchar2) then
1387 p_rec.to_grade_or_level :=
1388 ghr_par_shd.g_old_rec.to_grade_or_level;
1389 End If;
1390 If (p_rec.to_job_id = hr_api.g_number) then
1391 p_rec.to_job_id :=
1392 ghr_par_shd.g_old_rec.to_job_id;
1393 End If;
1394 If (p_rec.to_locality_adj = hr_api.g_number) then
1395 p_rec.to_locality_adj :=
1396 ghr_par_shd.g_old_rec.to_locality_adj;
1397 End If;
1398 If (p_rec.to_occ_code = hr_api.g_varchar2) then
1399 p_rec.to_occ_code :=
1400 ghr_par_shd.g_old_rec.to_occ_code;
1401 End If;
1402 If (p_rec.to_office_symbol = hr_api.g_varchar2) then
1403 p_rec.to_office_symbol :=
1404 ghr_par_shd.g_old_rec.to_office_symbol;
1405 End If;
1406 If (p_rec.to_organization_id = hr_api.g_number) then
1407 p_rec.to_organization_id :=
1408 ghr_par_shd.g_old_rec.to_organization_id;
1409 End If;
1410 If (p_rec.to_other_pay_amount = hr_api.g_number) then
1411 p_rec.to_other_pay_amount :=
1412 ghr_par_shd.g_old_rec.to_other_pay_amount;
1413 End If;
1414 If (p_rec.to_pay_basis = hr_api.g_varchar2) then
1415 p_rec.to_pay_basis :=
1416 ghr_par_shd.g_old_rec.to_pay_basis;
1417 End If;
1418 If (p_rec.to_pay_plan = hr_api.g_varchar2) then
1419 p_rec.to_pay_plan :=
1420 ghr_par_shd.g_old_rec.to_pay_plan;
1421 End If;
1422 -- FWFA Changes Bug#4444609
1423 If (p_rec.to_pay_table_identifier = hr_api.g_number) then
1424 p_rec.to_pay_table_identifier :=
1425 ghr_par_shd.g_old_rec.to_pay_table_identifier;
1426 End If;
1427 -- FWFA Changes
1428 If (p_rec.to_position_id = hr_api.g_number) then
1429 p_rec.to_position_id :=
1430 ghr_par_shd.g_old_rec.to_position_id;
1431 End If;
1432 If (p_rec.to_position_org_line1 = hr_api.g_varchar2) then
1433 p_rec.to_position_org_line1 :=
1434 ghr_par_shd.g_old_rec.to_position_org_line1;
1435 End If;
1436 If (p_rec.to_position_org_line2 = hr_api.g_varchar2) then
1437 p_rec.to_position_org_line2 :=
1438 ghr_par_shd.g_old_rec.to_position_org_line2;
1439 End If;
1440 If (p_rec.to_position_org_line3 = hr_api.g_varchar2) then
1441 p_rec.to_position_org_line3 :=
1442 ghr_par_shd.g_old_rec.to_position_org_line3;
1443 End If;
1444 If (p_rec.to_position_org_line4 = hr_api.g_varchar2) then
1445 p_rec.to_position_org_line4 :=
1446 ghr_par_shd.g_old_rec.to_position_org_line4;
1447 End If;
1448 If (p_rec.to_position_org_line5 = hr_api.g_varchar2) then
1449 p_rec.to_position_org_line5 :=
1450 ghr_par_shd.g_old_rec.to_position_org_line5;
1451 End If;
1452 If (p_rec.to_position_org_line6 = hr_api.g_varchar2) then
1453 p_rec.to_position_org_line6 :=
1454 ghr_par_shd.g_old_rec.to_position_org_line6;
1455 End If;
1456
1457 If (p_rec.to_position_number = hr_api.g_varchar2) then
1458 p_rec.to_position_number :=
1459 ghr_par_shd.g_old_rec.to_position_number;
1460 End If;
1461 If (p_rec.to_position_seq_no = hr_api.g_number) then
1462 p_rec.to_position_seq_no :=
1463 ghr_par_shd.g_old_rec.to_position_seq_no;
1464 End If;
1465 If (p_rec.to_position_title = hr_api.g_varchar2) then
1466 p_rec.to_position_title :=
1467 ghr_par_shd.g_old_rec.to_position_title;
1468 End If;
1469 If (p_rec.to_step_or_rate = hr_api.g_varchar2) then
1470 p_rec.to_step_or_rate :=
1471 ghr_par_shd.g_old_rec.to_step_or_rate;
1472 End If;
1473
1474 If (p_rec.to_ap_premium_pay_indicator = hr_api.g_varchar2) then
1475 p_rec.to_ap_premium_pay_indicator :=
1476 ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator;
1477 End If;
1478
1479 If (p_rec.to_auo_premium_pay_indicator = hr_api.g_varchar2) then
1480 p_rec.to_auo_premium_pay_indicator :=
1481 ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator;
1482 End If;
1483
1484 If (p_rec.to_au_overtime = hr_api.g_number) then
1485 p_rec.to_au_overtime :=
1486 ghr_par_shd.g_old_rec.to_au_overtime ;
1487 End If;
1488
1489 If (p_rec.to_availability_pay = hr_api.g_number) then
1490 p_rec.to_availability_pay :=
1491 ghr_par_shd.g_old_rec.to_availability_pay ;
1492 End If;
1493
1494 If (p_rec.to_retention_allowance = hr_api.g_number) then
1495 p_rec.to_retention_allowance :=
1496 ghr_par_shd.g_old_rec.to_retention_allowance;
1497 End If;
1498
1499 If (p_rec.to_staffing_differential = hr_api.g_number) then
1500 p_rec.to_staffing_differential :=
1501 ghr_par_shd.g_old_rec.to_staffing_differential ;
1502 End If;
1503
1504 If (p_rec.to_supervisory_differential = hr_api.g_number) then
1505 p_rec.to_supervisory_differential :=
1506 ghr_par_shd.g_old_rec.to_supervisory_differential ;
1507 End If;
1508
1509 If (p_rec.to_total_salary = hr_api.g_number) then
1510 p_rec.to_total_salary :=
1511 ghr_par_shd.g_old_rec.to_total_salary;
1512 End If;
1513 If (p_rec.veterans_preference = hr_api.g_varchar2) then
1514 p_rec.veterans_preference :=
1515 ghr_par_shd.g_old_rec.veterans_preference;
1516 End If;
1517 If (p_rec.veterans_pref_for_rif = hr_api.g_varchar2) then
1518 p_rec.veterans_pref_for_rif :=
1519 ghr_par_shd.g_old_rec.veterans_pref_for_rif;
1520 End If;
1521 If (p_rec.veterans_status = hr_api.g_varchar2) then
1522 p_rec.veterans_status :=
1523 ghr_par_shd.g_old_rec.veterans_status;
1524 End If;
1525 If (p_rec.work_schedule = hr_api.g_varchar2) then
1526 p_rec.work_schedule :=
1527 ghr_par_shd.g_old_rec.work_schedule;
1528 End If;
1529 If (p_rec.work_schedule_desc = hr_api.g_varchar2) then
1530 p_rec.work_schedule_desc :=
1531 ghr_par_shd.g_old_rec.work_schedule_desc;
1532 End If;
1533 If (p_rec.year_degree_attained = hr_api.g_number) then
1534 p_rec.year_degree_attained :=
1535 ghr_par_shd.g_old_rec.year_degree_attained;
1536 End If;
1537 If (p_rec.first_noa_information1 = hr_api.g_varchar2) then
1538 p_rec.first_noa_information1 :=
1539 ghr_par_shd.g_old_rec.first_noa_information1;
1540 End If;
1541 If (p_rec.first_noa_information2 = hr_api.g_varchar2) then
1542 p_rec.first_noa_information2 :=
1543 ghr_par_shd.g_old_rec.first_noa_information2;
1544 End If;
1545 If (p_rec.first_noa_information3 = hr_api.g_varchar2) then
1546 p_rec.first_noa_information3 :=
1547 ghr_par_shd.g_old_rec.first_noa_information3;
1548 End If;
1549 If (p_rec.first_noa_information4 = hr_api.g_varchar2) then
1550 p_rec.first_noa_information4 :=
1551 ghr_par_shd.g_old_rec.first_noa_information4;
1552 End If;
1553 If (p_rec.first_noa_information5 = hr_api.g_varchar2) then
1554 p_rec.first_noa_information5 :=
1555 ghr_par_shd.g_old_rec.first_noa_information5;
1556 End If;
1557 If (p_rec.second_lac1_information1 = hr_api.g_varchar2) then
1558 p_rec.second_lac1_information1 :=
1559 ghr_par_shd.g_old_rec.second_lac1_information1;
1560 End If;
1561 If (p_rec.second_lac1_information2 = hr_api.g_varchar2) then
1562 p_rec.second_lac1_information2 :=
1563 ghr_par_shd.g_old_rec.second_lac1_information2;
1564 End If;
1565 If (p_rec.second_lac1_information3 = hr_api.g_varchar2) then
1566 p_rec.second_lac1_information3 :=
1567 ghr_par_shd.g_old_rec.second_lac1_information3;
1568 End If;
1569 If (p_rec.second_lac1_information4 = hr_api.g_varchar2) then
1570 p_rec.second_lac1_information4 :=
1571 ghr_par_shd.g_old_rec.second_lac1_information4;
1572 End If;
1573 If (p_rec.second_lac1_information5 = hr_api.g_varchar2) then
1574 p_rec.second_lac1_information5 :=
1575 ghr_par_shd.g_old_rec.second_lac1_information5;
1576 End If;
1577 If (p_rec.second_lac2_information1 = hr_api.g_varchar2) then
1578 p_rec.second_lac2_information1 :=
1579 ghr_par_shd.g_old_rec.second_lac2_information1;
1580 End If;
1581 If (p_rec.second_lac2_information2 = hr_api.g_varchar2) then
1582 p_rec.second_lac2_information2 :=
1583 ghr_par_shd.g_old_rec.second_lac2_information2;
1584 End If;
1585 If (p_rec.second_lac2_information3 = hr_api.g_varchar2) then
1586 p_rec.second_lac2_information3 :=
1587 ghr_par_shd.g_old_rec.second_lac2_information3;
1588 End If;
1589 If (p_rec.second_lac2_information4 = hr_api.g_varchar2) then
1590 p_rec.second_lac2_information4 :=
1591 ghr_par_shd.g_old_rec.second_lac2_information4;
1592 End If;
1593 If (p_rec.second_lac2_information5 = hr_api.g_varchar2) then
1594 p_rec.second_lac2_information5 :=
1595 ghr_par_shd.g_old_rec.second_lac2_information5;
1596 End If;
1597 If (p_rec.second_noa_information1 = hr_api.g_varchar2) then
1598 p_rec.second_noa_information1 :=
1599 ghr_par_shd.g_old_rec.second_noa_information1;
1600 End If;
1601 If (p_rec.second_noa_information2 = hr_api.g_varchar2) then
1602 p_rec.second_noa_information2 :=
1603 ghr_par_shd.g_old_rec.second_noa_information2;
1604 End If;
1605 If (p_rec.second_noa_information3 = hr_api.g_varchar2) then
1606 p_rec.second_noa_information3 :=
1607 ghr_par_shd.g_old_rec.second_noa_information3;
1608 End If;
1609 If (p_rec.second_noa_information4 = hr_api.g_varchar2) then
1610 p_rec.second_noa_information4 :=
1611 ghr_par_shd.g_old_rec.second_noa_information4;
1612 End If;
1613 If (p_rec.second_noa_information5 = hr_api.g_varchar2) then
1614 p_rec.second_noa_information5 :=
1615 ghr_par_shd.g_old_rec.second_noa_information5;
1616 End If;
1617 If (p_rec.first_lac1_information1 = hr_api.g_varchar2) then
1618 p_rec.first_lac1_information1 :=
1619 ghr_par_shd.g_old_rec.first_lac1_information1;
1620 End If;
1621 If (p_rec.first_lac1_information2 = hr_api.g_varchar2) then
1622 p_rec.first_lac1_information2 :=
1623 ghr_par_shd.g_old_rec.first_lac1_information2;
1624 End If;
1625 If (p_rec.first_lac1_information3 = hr_api.g_varchar2) then
1626 p_rec.first_lac1_information3 :=
1627 ghr_par_shd.g_old_rec.first_lac1_information3;
1628 End If;
1629 If (p_rec.first_lac1_information4 = hr_api.g_varchar2) then
1630 p_rec.first_lac1_information4 :=
1631 ghr_par_shd.g_old_rec.first_lac1_information4;
1632 End If;
1633 If (p_rec.first_lac1_information5 = hr_api.g_varchar2) then
1634 p_rec.first_lac1_information5 :=
1635 ghr_par_shd.g_old_rec.first_lac1_information5;
1636 End If;
1637 If (p_rec.first_lac2_information1 = hr_api.g_varchar2) then
1638 p_rec.first_lac2_information1 :=
1639 ghr_par_shd.g_old_rec.first_lac2_information1;
1640 End If;
1641 If (p_rec.first_lac2_information2 = hr_api.g_varchar2) then
1642 p_rec.first_lac2_information2 :=
1643 ghr_par_shd.g_old_rec.first_lac2_information2;
1644 End If;
1645 If (p_rec.first_lac2_information3 = hr_api.g_varchar2) then
1646 p_rec.first_lac2_information3 :=
1647 ghr_par_shd.g_old_rec.first_lac2_information3;
1648 End If;
1649 If (p_rec.first_lac2_information4 = hr_api.g_varchar2) then
1650 p_rec.first_lac2_information4 :=
1651 ghr_par_shd.g_old_rec.first_lac2_information4;
1652 End If;
1653 If (p_rec.first_lac2_information5 = hr_api.g_varchar2) then
1654 p_rec.first_lac2_information5 :=
1655 ghr_par_shd.g_old_rec.first_lac2_information5;
1656 End If;
1657 If (p_rec.attribute_category = hr_api.g_varchar2) then
1658 p_rec.attribute_category :=
1659 ghr_par_shd.g_old_rec.attribute_category;
1660 End If;
1661 If (p_rec.attribute1 = hr_api.g_varchar2) then
1662 p_rec.attribute1 :=
1663 ghr_par_shd.g_old_rec.attribute1;
1664 End If;
1665 If (p_rec.attribute2 = hr_api.g_varchar2) then
1666 p_rec.attribute2 :=
1667 ghr_par_shd.g_old_rec.attribute2;
1668 End If;
1669 If (p_rec.attribute3 = hr_api.g_varchar2) then
1670 p_rec.attribute3 :=
1671 ghr_par_shd.g_old_rec.attribute3;
1672 End If;
1673 If (p_rec.attribute4 = hr_api.g_varchar2) then
1674 p_rec.attribute4 :=
1675 ghr_par_shd.g_old_rec.attribute4;
1676 End If;
1677 If (p_rec.attribute5 = hr_api.g_varchar2) then
1678 p_rec.attribute5 :=
1679 ghr_par_shd.g_old_rec.attribute5;
1680 End If;
1681 If (p_rec.attribute6 = hr_api.g_varchar2) then
1682 p_rec.attribute6 :=
1683 ghr_par_shd.g_old_rec.attribute6;
1684 End If;
1685 If (p_rec.attribute7 = hr_api.g_varchar2) then
1686 p_rec.attribute7 :=
1687 ghr_par_shd.g_old_rec.attribute7;
1688 End If;
1689 If (p_rec.attribute8 = hr_api.g_varchar2) then
1690 p_rec.attribute8 :=
1691 ghr_par_shd.g_old_rec.attribute8;
1692 End If;
1693 If (p_rec.attribute9 = hr_api.g_varchar2) then
1694 p_rec.attribute9 :=
1695 ghr_par_shd.g_old_rec.attribute9;
1696 End If;
1697 If (p_rec.attribute10 = hr_api.g_varchar2) then
1698 p_rec.attribute10 :=
1699 ghr_par_shd.g_old_rec.attribute10;
1700 End If;
1701 If (p_rec.attribute11 = hr_api.g_varchar2) then
1702 p_rec.attribute11 :=
1703 ghr_par_shd.g_old_rec.attribute11;
1704 End If;
1705 If (p_rec.attribute12 = hr_api.g_varchar2) then
1706 p_rec.attribute12 :=
1707 ghr_par_shd.g_old_rec.attribute12;
1708 End If;
1709 If (p_rec.attribute13 = hr_api.g_varchar2) then
1710 p_rec.attribute13 :=
1711 ghr_par_shd.g_old_rec.attribute13;
1712 End If;
1713 If (p_rec.attribute14 = hr_api.g_varchar2) then
1714 p_rec.attribute14 :=
1715 ghr_par_shd.g_old_rec.attribute14;
1716 End If;
1717 If (p_rec.attribute15 = hr_api.g_varchar2) then
1718 p_rec.attribute15 :=
1719 ghr_par_shd.g_old_rec.attribute15;
1720 End If;
1721 If (p_rec.attribute16 = hr_api.g_varchar2) then
1722 p_rec.attribute16 :=
1723 ghr_par_shd.g_old_rec.attribute16;
1724 End If;
1725 If (p_rec.attribute17 = hr_api.g_varchar2) then
1726 p_rec.attribute17 :=
1727 ghr_par_shd.g_old_rec.attribute17;
1728 End If;
1729 If (p_rec.attribute18 = hr_api.g_varchar2) then
1730 p_rec.attribute18 :=
1731 ghr_par_shd.g_old_rec.attribute18;
1732 End If;
1733 If (p_rec.attribute19 = hr_api.g_varchar2) then
1734 p_rec.attribute19 :=
1735 ghr_par_shd.g_old_rec.attribute19;
1736 End If;
1737 If (p_rec.attribute20 = hr_api.g_varchar2) then
1738 p_rec.attribute20 :=
1739 ghr_par_shd.g_old_rec.attribute20;
1740 End If;
1741
1742 If (p_rec.first_noa_canc_pa_request_id = hr_api.g_number) then
1743 p_rec.first_noa_canc_pa_request_id :=
1744 ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id;
1745 End If;
1746 If (p_rec.second_noa_canc_pa_request_id = hr_api.g_number) then
1747 p_rec.second_noa_canc_pa_request_id :=
1748 ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id;
1749 End If;
1750 If (p_rec.to_retention_allow_percentage = hr_api.g_number) then
1751 p_rec.to_retention_allow_percentage :=
1752 ghr_par_shd.g_old_rec.to_retention_allow_percentage;
1753 End If;
1754 If (p_rec.to_supervisory_diff_percentage = hr_api.g_number) then
1755 p_rec.to_supervisory_diff_percentage :=
1756 ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
1757 End If;
1758 If (p_rec.to_staffing_diff_percentage = hr_api.g_number) then
1759 p_rec.to_staffing_diff_percentage :=
1760 ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
1761 End If;
1762 If (p_rec.award_percentage = hr_api.g_number) then
1763 p_rec.award_percentage :=
1764 ghr_par_shd.g_old_rec.award_percentage;
1765 End If;
1766 If (p_rec.rpa_type = hr_api.g_varchar2) then
1767 p_rec.rpa_type :=
1768 ghr_par_shd.g_old_rec.rpa_type;
1769 End If;
1770 If (p_rec.mass_action_id = hr_api.g_number) then
1771 p_rec.mass_action_id :=
1772 ghr_par_shd.g_old_rec.mass_action_id;
1773 End If;
1774 If (p_rec.mass_action_eligible_flag = hr_api.g_varchar2) then
1775 p_rec.mass_action_eligible_flag :=
1776 ghr_par_shd.g_old_rec.mass_action_eligible_flag;
1777 End If;
1778 If (p_rec.mass_action_select_flag = hr_api.g_varchar2) then
1779 p_rec.mass_action_select_flag :=
1780 ghr_par_shd.g_old_rec.mass_action_select_flag;
1781 End If;
1782 If (p_rec.mass_action_comments = hr_api.g_varchar2) then
1783 p_rec.mass_action_comments :=
1784 ghr_par_shd.g_old_rec.mass_action_comments;
1785 End If;
1786 -- Bug# RRR Changes
1787 If (p_rec.payment_option = hr_api.g_varchar2) then
1788 p_rec.payment_option :=
1789 ghr_par_shd.g_old_rec.payment_option;
1790 End If;
1791 If (p_rec.award_salary = hr_api.g_number) then
1792 p_rec.award_salary :=
1793 ghr_par_shd.g_old_rec.award_salary;
1794 End If;
1795 -- Bug# RRR Changes
1796 --
1797 hr_utility.set_location(' Leaving:'||l_proc, 10);
1798 --
1799 End convert_defs;
1800 --
1801 -- ----------------------------------------------------------------------------
1802 -- |---------------------------------< upd >----------------------------------|
1803 -- ----------------------------------------------------------------------------
1804 Procedure upd
1805 (
1806 p_rec in out nocopy ghr_par_shd.g_rec_type
1807 ) is
1808 --
1809 l_proc varchar2(72) := g_package||'upd';
1810 --
1811 Begin
1812 hr_utility.set_location('Entering:'||l_proc, 5);
1813 --
1814 -- We must lock the row which we need to update.
1815 --
1816 ghr_par_shd.lck
1817 (
1818 p_rec.pa_request_id,
1819 p_rec.routing_group_id,
1820 p_rec.object_version_number
1821 );
1822 --
1823 -- 1. During an update system defaults are used to determine if
1824 -- arguments have been defaulted or not. We must therefore
1825 -- derive the full record structure values to be updated.
1826 --
1827 -- 2. Call the supporting update validate operations.
1828 --
1829 convert_defs(p_rec);
1830 ghr_par_bus.update_validate(p_rec);
1831 --
1832 -- Call the supporting pre-update operation
1833 --
1834 pre_update(p_rec);
1835 --
1836 -- Update the row.
1837 --
1838 update_dml(p_rec);
1839 --
1840 -- Call the supporting post-update operation
1841 --
1842 post_update(p_rec);
1843 End upd;
1844 --
1845 -- ----------------------------------------------------------------------------
1846 -- |---------------------------------< upd >----------------------------------|
1847 -- ----------------------------------------------------------------------------
1848 Procedure upd
1849 (
1850 p_pa_request_id in number,
1851 p_pa_notification_id in number default hr_api.g_number,
1852 p_noa_family_code in varchar2 default hr_api.g_varchar2,
1853 p_routing_group_id in number default hr_api.g_number,
1854 p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1855 p_academic_discipline in varchar2 default hr_api.g_varchar2,
1856 p_additional_info_person_id in number default hr_api.g_number,
1857 p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1858 p_agency_code in varchar2 default hr_api.g_varchar2,
1859 p_altered_pa_request_id in number default hr_api.g_number,
1860 p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1861 p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1862 p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1863 p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1864 p_approval_date in date default hr_api.g_date,
1865 p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1866 p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1867 p_sf50_approval_date in date default hr_api.g_date,
1868 p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1869 p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1870 p_authorized_by_person_id in number default hr_api.g_number,
1871 p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1872 p_award_amount in number default hr_api.g_number,
1873 p_award_uom in varchar2 default hr_api.g_varchar2,
1874 p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1875 p_citizenship in varchar2 default hr_api.g_varchar2,
1876 p_concurrence_date in date default hr_api.g_date,
1877 p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1878 p_duty_station_code in varchar2 default hr_api.g_varchar2,
1879 p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1880 p_duty_station_id in number default hr_api.g_number,
1881 p_duty_station_location_id in number default hr_api.g_number,
1882 p_education_level in varchar2 default hr_api.g_varchar2,
1883 p_effective_date in date default hr_api.g_date,
1884 p_employee_assignment_id in number default hr_api.g_number,
1885 p_employee_date_of_birth in date default hr_api.g_date,
1886 p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1887 p_employee_first_name in varchar2 default hr_api.g_varchar2,
1888 p_employee_last_name in varchar2 default hr_api.g_varchar2,
1889 p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1890 p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1891 p_fegli in varchar2 default hr_api.g_varchar2,
1892 p_fegli_desc in varchar2 default hr_api.g_varchar2,
1893 p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1894 p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1895 p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1896 p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1897 p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1898 p_first_noa_code in varchar2 default hr_api.g_varchar2,
1899 p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1900 p_first_noa_id in number default hr_api.g_number,
1901 p_first_noa_pa_request_id in number default hr_api.g_number,
1902 p_flsa_category in varchar2 default hr_api.g_varchar2,
1903 p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1904 p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1905 p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1906 p_forwarding_country in varchar2 default hr_api.g_varchar2,
1907 p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1908 p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1909 p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1910 p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1911 p_from_adj_basic_pay in number default hr_api.g_number,
1912 p_from_agency_code in varchar2 default hr_api.g_varchar2,
1913 p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1914 p_from_basic_pay in number default hr_api.g_number,
1915 p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1916 p_from_locality_adj in number default hr_api.g_number,
1917 p_from_occ_code in varchar2 default hr_api.g_varchar2,
1918 p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1919 p_from_other_pay_amount in number default hr_api.g_number,
1920 p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1921 p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1922 -- FWFA Changes Bug#4444609
1923 p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1924 p_from_pay_table_identifier in number default hr_api.g_number,
1925 -- FWFA Changes
1926 p_from_position_id in number default hr_api.g_number,
1927 p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1928 p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1929 p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1930 p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1931 p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1932 p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1933 p_from_position_number in varchar2 default hr_api.g_varchar2,
1934 p_from_position_seq_no in number default hr_api.g_number,
1935 p_from_position_title in varchar2 default hr_api.g_varchar2,
1936 p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1937 p_from_total_salary in number default hr_api.g_number,
1938 p_functional_class in varchar2 default hr_api.g_varchar2,
1939 p_notepad in varchar2 default hr_api.g_varchar2,
1940 p_part_time_hours in number default hr_api.g_number,
1941 p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1942 p_personnel_office_id in varchar2 default hr_api.g_varchar2,
1943 p_person_id in number default hr_api.g_number,
1944 p_position_occupied in varchar2 default hr_api.g_varchar2,
1945 p_proposed_effective_date in date default hr_api.g_date,
1946 p_requested_by_person_id in number default hr_api.g_number,
1947 p_requested_by_title in varchar2 default hr_api.g_varchar2,
1948 p_requested_date in date default hr_api.g_date,
1949 p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1950 p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1951 p_request_number in varchar2 default hr_api.g_varchar2,
1952 p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1953 p_retirement_plan in varchar2 default hr_api.g_varchar2,
1954 p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1955 p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1956 p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1957 p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1958 p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1959 p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1960 p_second_noa_code in varchar2 default hr_api.g_varchar2,
1961 p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1962 p_second_noa_id in number default hr_api.g_number,
1963 p_second_noa_pa_request_id in number default hr_api.g_number,
1964 p_service_comp_date in date default hr_api.g_date,
1965 p_status in varchar2 default hr_api.g_varchar2,
1966 p_supervisory_status in varchar2 default hr_api.g_varchar2,
1967 p_tenure in varchar2 default hr_api.g_varchar2,
1968 p_to_adj_basic_pay in number default hr_api.g_number,
1969 p_to_basic_pay in number default hr_api.g_number,
1970 p_to_grade_id in number default hr_api.g_number,
1971 p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1972 p_to_job_id in number default hr_api.g_number,
1973 p_to_locality_adj in number default hr_api.g_number,
1974 p_to_occ_code in varchar2 default hr_api.g_varchar2,
1975 p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1976 p_to_organization_id in number default hr_api.g_number,
1977 p_to_other_pay_amount in number default hr_api.g_number,
1978 p_to_au_overtime in number default hr_api.g_number,
1979 p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1980 p_to_availability_pay in number default hr_api.g_number,
1981 p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1982 p_to_retention_allowance in number default hr_api.g_number,
1983 p_to_supervisory_differential in number default hr_api.g_number,
1984 p_to_staffing_differential in number default hr_api.g_number,
1985 p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1986 p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1987 -- FWFA Changes Bug#4444609
1988 p_to_pay_table_identifier in number default hr_api.g_number,
1989 -- FWFA Changes
1990 p_to_position_id in number default hr_api.g_number,
1991 p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1992 p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1993 p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1994 p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1995 p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1996 p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1997 p_to_position_number in varchar2 default hr_api.g_varchar2,
1998 p_to_position_seq_no in number default hr_api.g_number,
1999 p_to_position_title in varchar2 default hr_api.g_varchar2,
2000 p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
2001 p_to_total_salary in number default hr_api.g_number,
2002 p_veterans_preference in varchar2 default hr_api.g_varchar2,
2003 p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
2004 p_veterans_status in varchar2 default hr_api.g_varchar2,
2005 p_work_schedule in varchar2 default hr_api.g_varchar2,
2006 p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
2007 p_year_degree_attained in number default hr_api.g_number,
2008 p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
2009 p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
2010 p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
2011 p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
2012 p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
2013 p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
2014 p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
2015 p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
2016 p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
2017 p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
2018 p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
2019 p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
2020 p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
2021 p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
2022 p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
2023 p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
2024 p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
2025 p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
2026 p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
2027 p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
2028 p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
2029 p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
2030 p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
2031 p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
2032 p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
2033 p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
2034 p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
2035 p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
2036 p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
2037 p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
2038 p_attribute_category in varchar2 default hr_api.g_varchar2,
2039 p_attribute1 in varchar2 default hr_api.g_varchar2,
2040 p_attribute2 in varchar2 default hr_api.g_varchar2,
2041 p_attribute3 in varchar2 default hr_api.g_varchar2,
2042 p_attribute4 in varchar2 default hr_api.g_varchar2,
2043 p_attribute5 in varchar2 default hr_api.g_varchar2,
2044 p_attribute6 in varchar2 default hr_api.g_varchar2,
2045 p_attribute7 in varchar2 default hr_api.g_varchar2,
2046 p_attribute8 in varchar2 default hr_api.g_varchar2,
2047 p_attribute9 in varchar2 default hr_api.g_varchar2,
2048 p_attribute10 in varchar2 default hr_api.g_varchar2,
2049 p_attribute11 in varchar2 default hr_api.g_varchar2,
2050 p_attribute12 in varchar2 default hr_api.g_varchar2,
2051 p_attribute13 in varchar2 default hr_api.g_varchar2,
2052 p_attribute14 in varchar2 default hr_api.g_varchar2,
2053 p_attribute15 in varchar2 default hr_api.g_varchar2,
2054 p_attribute16 in varchar2 default hr_api.g_varchar2,
2055 p_attribute17 in varchar2 default hr_api.g_varchar2,
2056 p_attribute18 in varchar2 default hr_api.g_varchar2,
2057 p_attribute19 in varchar2 default hr_api.g_varchar2,
2058 p_attribute20 in varchar2 default hr_api.g_varchar2,
2059 p_first_noa_canc_pa_request_id in number default hr_api.g_number,
2060 p_second_noa_canc_pa_request_i in number default hr_api.g_number,
2061 p_to_retention_allow_percentag in number default hr_api.g_number,
2062 p_to_supervisory_diff_percenta in number default hr_api.g_number,
2063 p_to_staffing_diff_percentage in number default hr_api.g_number,
2064 p_award_percentage in number default hr_api.g_number,
2065 p_rpa_type in varchar2 default hr_api.g_varchar2,
2066 p_mass_action_id in number default hr_api.g_number,
2067 p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
2068 p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
2069 p_mass_action_comments in varchar2 default hr_api.g_varchar2,
2070 -- Bug# RRR Changes
2071 p_payment_option in varchar2 default hr_api.g_varchar2,
2072 p_award_salary in number default hr_api.g_number,
2073 -- Bug# RRR Changes
2074 p_object_version_number in out nocopy number
2075 )
2076 is
2077 --
2078 l_rec ghr_par_shd.g_rec_type;
2079 l_proc varchar2(72) := g_package||'upd';
2080 --
2081 Begin
2082 hr_utility.set_location('Entering:'||l_proc, 5);
2083 --
2084 -- Call conversion function to turn arguments into the
2085 -- l_rec structure.
2086 --
2087 l_rec :=
2088 ghr_par_shd.convert_args
2089 (
2090 p_pa_request_id,
2091 p_pa_notification_id,
2092 p_noa_family_code,
2093 p_routing_group_id,
2094 p_proposed_effective_asap_flag,
2095 p_academic_discipline,
2096 p_additional_info_person_id,
2097 p_additional_info_tel_number,
2098 p_agency_code,
2099 p_altered_pa_request_id,
2100 p_annuitant_indicator,
2101 p_annuitant_indicator_desc,
2102 p_appropriation_code1,
2103 p_appropriation_code2,
2104 p_approval_date,
2105 p_approving_official_full_name,
2106 p_approving_official_work_titl,
2107 p_sf50_approval_date,
2108 p_sf50_approving_ofcl_full_nam,
2109 p_sf50_approving_ofcl_work_tit,
2110 p_authorized_by_person_id,
2111 p_authorized_by_title,
2112 p_award_amount,
2113 p_award_uom,
2114 p_bargaining_unit_status,
2115 p_citizenship,
2116 p_concurrence_date,
2117 p_custom_pay_calc_flag,
2118 p_duty_station_code,
2119 p_duty_station_desc,
2120 p_duty_station_id,
2121 p_duty_station_location_id,
2122 p_education_level,
2123 p_effective_date,
2124 p_employee_assignment_id,
2125 p_employee_date_of_birth,
2126 p_employee_dept_or_agency,
2127 p_employee_first_name,
2128 p_employee_last_name,
2129 p_employee_middle_names,
2130 p_employee_national_identifier,
2131 p_fegli,
2132 p_fegli_desc,
2133 p_first_action_la_code1,
2134 p_first_action_la_code2,
2135 p_first_action_la_desc1,
2136 p_first_action_la_desc2,
2137 p_first_noa_cancel_or_correct,
2138 p_first_noa_code,
2139 p_first_noa_desc,
2140 p_first_noa_id,
2141 p_first_noa_pa_request_id,
2142 p_flsa_category,
2143 p_forwarding_address_line1,
2144 p_forwarding_address_line2,
2145 p_forwarding_address_line3,
2146 p_forwarding_country,
2147 p_forwarding_country_short_nam,
2148 p_forwarding_postal_code,
2149 p_forwarding_region_2,
2150 p_forwarding_town_or_city,
2151 p_from_adj_basic_pay,
2152 p_from_agency_code,
2153 p_from_agency_desc,
2154 p_from_basic_pay,
2155 p_from_grade_or_level,
2156 p_from_locality_adj,
2157 p_from_occ_code,
2158 p_from_office_symbol,
2159 p_from_other_pay_amount,
2160 p_from_pay_basis,
2161 p_from_pay_plan,
2162 -- FWFA Chagnes Bug#4444609
2163 p_input_pay_rate_determinant,
2164 p_from_pay_table_identifier,
2165 -- FWFA Changes
2166 p_from_position_id,
2167 p_from_position_org_line1,
2168 p_from_position_org_line2,
2169 p_from_position_org_line3,
2170 p_from_position_org_line4,
2171 p_from_position_org_line5,
2172 p_from_position_org_line6,
2173 p_from_position_number,
2174 p_from_position_seq_no,
2175 p_from_position_title,
2176 p_from_step_or_rate,
2177 p_from_total_salary,
2178 p_functional_class,
2179 p_notepad,
2180 p_part_time_hours,
2181 p_pay_rate_determinant,
2182 p_personnel_office_id,
2183 p_person_id,
2184 p_position_occupied,
2185 p_proposed_effective_date,
2186 p_requested_by_person_id,
2187 p_requested_by_title,
2188 p_requested_date,
2189 p_requesting_office_remarks_de,
2190 p_requesting_office_remarks_fl,
2191 p_request_number,
2192 p_resign_and_retire_reason_des,
2193 p_retirement_plan,
2194 p_retirement_plan_desc,
2195 p_second_action_la_code1,
2196 p_second_action_la_code2,
2197 p_second_action_la_desc1,
2198 p_second_action_la_desc2,
2199 p_second_noa_cancel_or_correct,
2200 p_second_noa_code,
2201 p_second_noa_desc,
2202 p_second_noa_id,
2203 p_second_noa_pa_request_id,
2204 p_service_comp_date,
2205 p_status,
2206 p_supervisory_status,
2207 p_tenure,
2208 p_to_adj_basic_pay,
2209 p_to_basic_pay,
2210 p_to_grade_id,
2211 p_to_grade_or_level,
2212 p_to_job_id,
2213 p_to_locality_adj,
2214 p_to_occ_code,
2215 p_to_office_symbol,
2216 p_to_organization_id,
2217 p_to_other_pay_amount,
2218 p_to_au_overtime,
2219 p_to_auo_premium_pay_indicator,
2220 p_to_availability_pay,
2221 p_to_ap_premium_pay_indicator,
2222 p_to_retention_allowance,
2223 p_to_supervisory_differential,
2224 p_to_staffing_differential,
2225 p_to_pay_basis,
2226 p_to_pay_plan,
2227 -- FWFA Chagnes Bug#4444609
2228 p_to_pay_table_identifier,
2229 -- FWFA Changes
2230 p_to_position_id,
2231 p_to_position_org_line1,
2232 p_to_position_org_line2,
2233 p_to_position_org_line3,
2234 p_to_position_org_line4,
2235 p_to_position_org_line5,
2236 p_to_position_org_line6,
2237 p_to_position_number,
2238 p_to_position_seq_no,
2239 p_to_position_title,
2240 p_to_step_or_rate,
2241 p_to_total_salary,
2242 p_veterans_preference,
2243 p_veterans_pref_for_rif,
2244 p_veterans_status,
2245 p_work_schedule,
2246 p_work_schedule_desc,
2247 p_year_degree_attained,
2248 p_first_noa_information1,
2249 p_first_noa_information2,
2250 p_first_noa_information3,
2251 p_first_noa_information4,
2252 p_first_noa_information5,
2253 p_second_lac1_information1,
2254 p_second_lac1_information2,
2255 p_second_lac1_information3,
2256 p_second_lac1_information4,
2257 p_second_lac1_information5,
2258 p_second_lac2_information1,
2259 p_second_lac2_information2,
2260 p_second_lac2_information3,
2261 p_second_lac2_information4,
2262 p_second_lac2_information5,
2263 p_second_noa_information1,
2264 p_second_noa_information2,
2265 p_second_noa_information3,
2266 p_second_noa_information4,
2267 p_second_noa_information5,
2268 p_first_lac1_information1,
2269 p_first_lac1_information2,
2270 p_first_lac1_information3,
2271 p_first_lac1_information4,
2272 p_first_lac1_information5,
2273 p_first_lac2_information1,
2274 p_first_lac2_information2,
2275 p_first_lac2_information3,
2276 p_first_lac2_information4,
2277 p_first_lac2_information5,
2278 p_attribute_category,
2279 p_attribute1,
2280 p_attribute2,
2281 p_attribute3,
2282 p_attribute4,
2283 p_attribute5,
2284 p_attribute6,
2285 p_attribute7,
2286 p_attribute8,
2287 p_attribute9,
2288 p_attribute10,
2289 p_attribute11,
2290 p_attribute12,
2291 p_attribute13,
2292 p_attribute14,
2293 p_attribute15,
2294 p_attribute16,
2295 p_attribute17,
2296 p_attribute18,
2297 p_attribute19,
2298 p_attribute20,
2299 p_first_noa_canc_pa_request_id,
2300 p_second_noa_canc_pa_request_i,
2301 p_to_retention_allow_percentag,
2302 p_to_supervisory_diff_percenta,
2303 p_to_staffing_diff_percentage ,
2304 p_award_percentage ,
2305 p_rpa_type ,
2306 p_mass_action_id ,
2307 p_mass_action_eligible_flag ,
2308 p_mass_action_select_flag ,
2309 p_mass_action_comments ,
2310 -- Bug# RRR Changes
2311 p_payment_option ,
2312 p_award_salary ,
2313 -- Bug# RRR Changes
2314 p_object_version_number
2315 );
2316 --
2317 -- Having converted the arguments into the
2318 -- plsql record structure we call the corresponding record
2319 -- business process.
2320 --
2321 upd(l_rec);
2322 p_object_version_number := l_rec.object_version_number;
2323 --
2324 hr_utility.set_location(' Leaving:'||l_proc, 10);
2325 End upd;
2326 --
2327 end ghr_par_upd;