[Home] [Help]
PACKAGE BODY: APPS.GHR_PAH_UPD
Source
1 Package Body ghr_pah_upd as
2 /* $Header: ghpahrhi.pkb 115.3 2003/01/30 19:25:31 asubrahm ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ghr_pah_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 set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To update the specified row in the schema using the primary key in
23 -- the predicates.
24 -- 4) To trap any constraint violations that may have occurred.
25 -- 5) To raise any other errors.
26 --
27 -- Prerequisites:
28 -- This is an internal private procedure which must be called from the upd
29 -- procedure.
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be updated in the schema.
36 --
37 -- Post Failure:
38 -- On the update dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- The update 'set' attribute list should be modified if any of your
47 -- attributes are not updateable.
48 --
49 -- Access Status:
50 -- Internal Row Handler Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure update_dml(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
55 --
56 l_proc varchar2(72) := g_package||'update_dml';
57 --
58 Begin
59 hr_utility.set_location('Entering:'||l_proc, 5);
60 --
61 --
62 ghr_pah_shd.g_api_dml := true; -- Set the api dml status
63 --
64 -- Update the ghr_pa_history Row
65 --
66 update ghr_pa_history
67 set
68 pa_history_id = p_rec.pa_history_id,
69 pa_request_id = p_rec.pa_request_id,
70 process_date = p_rec.process_date,
71 nature_of_action_id = p_rec.nature_of_action_id,
72 effective_date = p_rec.effective_date,
73 altered_pa_request_id = p_rec.altered_pa_request_id,
74 person_id = p_rec.person_id,
75 assignment_id = p_rec.assignment_id,
76 dml_operation = p_rec.dml_operation,
77 table_name = p_rec.table_name,
78 pre_values_flag = p_rec.pre_values_flag,
79 information1 = p_rec.information1,
80 information2 = p_rec.information2,
81 information3 = p_rec.information3,
82 information4 = p_rec.information4,
83 information5 = p_rec.information5,
84 information6 = p_rec.information6,
85 information7 = p_rec.information7,
86 information8 = p_rec.information8,
87 information9 = p_rec.information9,
88 information10 = p_rec.information10,
89 information11 = p_rec.information11,
90 information12 = p_rec.information12,
91 information13 = p_rec.information13,
92 information14 = p_rec.information14,
93 information15 = p_rec.information15,
94 information16 = p_rec.information16,
95 information17 = p_rec.information17,
96 information18 = p_rec.information18,
97 information19 = p_rec.information19,
98 information20 = p_rec.information20,
99 information21 = p_rec.information21,
100 information22 = p_rec.information22,
101 information23 = p_rec.information23,
102 information24 = p_rec.information24,
103 information25 = p_rec.information25,
104 information26 = p_rec.information26,
105 information27 = p_rec.information27,
106 information28 = p_rec.information28,
107 information29 = p_rec.information29,
108 information30 = p_rec.information30,
109 information31 = p_rec.information31,
110 information32 = p_rec.information32,
111 information33 = p_rec.information33,
112 information34 = p_rec.information34,
113 information35 = p_rec.information35,
114 information36 = p_rec.information36,
115 information37 = p_rec.information37,
116 information38 = p_rec.information38,
117 information39 = p_rec.information39,
118 information47 = p_rec.information47,
119 information48 = p_rec.information48,
120 information49 = p_rec.information49,
121 information40 = p_rec.information40,
122 information41 = p_rec.information41,
123 information42 = p_rec.information42,
124 information43 = p_rec.information43,
125 information44 = p_rec.information44,
126 information45 = p_rec.information45,
127 information46 = p_rec.information46,
128 information50 = p_rec.information50,
129 information51 = p_rec.information51,
130 information52 = p_rec.information52,
131 information53 = p_rec.information53,
132 information54 = p_rec.information54,
133 information55 = p_rec.information55,
134 information56 = p_rec.information56,
135 information57 = p_rec.information57,
136 information58 = p_rec.information58,
137 information59 = p_rec.information59,
138 information60 = p_rec.information60,
139 information61 = p_rec.information61,
140 information62 = p_rec.information62,
141 information63 = p_rec.information63,
142 information64 = p_rec.information64,
143 information65 = p_rec.information65,
144 information66 = p_rec.information66,
145 information67 = p_rec.information67,
146 information68 = p_rec.information68,
147 information69 = p_rec.information69,
148 information70 = p_rec.information70,
149 information71 = p_rec.information71,
150 information72 = p_rec.information72,
151 information73 = p_rec.information73,
152 information74 = p_rec.information74,
153 information75 = p_rec.information75,
154 information76 = p_rec.information76,
155 information77 = p_rec.information77,
156 information78 = p_rec.information78,
157 information79 = p_rec.information79,
158 information80 = p_rec.information80,
159 information81 = p_rec.information81,
160 information82 = p_rec.information82,
161 information83 = p_rec.information83,
162 information84 = p_rec.information84,
163 information85 = p_rec.information85,
164 information86 = p_rec.information86,
165 information87 = p_rec.information87,
166 information88 = p_rec.information88,
167 information89 = p_rec.information89,
168 information90 = p_rec.information90,
169 information91 = p_rec.information91,
170 information92 = p_rec.information92,
171 information93 = p_rec.information93,
172 information94 = p_rec.information94,
173 information95 = p_rec.information95,
174 information96 = p_rec.information96,
175 information97 = p_rec.information97,
176 information98 = p_rec.information98,
177 information99 = p_rec.information99,
178 information100 = p_rec.information100,
179 information101 = p_rec.information101,
180 information102 = p_rec.information102,
181 information103 = p_rec.information103,
182 information104 = p_rec.information104,
183 information105 = p_rec.information105,
184 information106 = p_rec.information106,
185 information107 = p_rec.information107,
186 information108 = p_rec.information108,
187 information109 = p_rec.information109,
188 information110 = p_rec.information110,
189 information111 = p_rec.information111,
190 information112 = p_rec.information112,
191 information113 = p_rec.information113,
192 information114 = p_rec.information114,
193 information115 = p_rec.information115,
194 information116 = p_rec.information116,
195 information117 = p_rec.information117,
196 information118 = p_rec.information118,
197 information119 = p_rec.information119,
198 information120 = p_rec.information120,
199 information121 = p_rec.information121,
200 information122 = p_rec.information122,
201 information123 = p_rec.information123,
202 information124 = p_rec.information124,
203 information125 = p_rec.information125,
204 information126 = p_rec.information126,
205 information127 = p_rec.information127,
206 information128 = p_rec.information128,
207 information129 = p_rec.information129,
208 information130 = p_rec.information130,
209 information131 = p_rec.information131,
210 information132 = p_rec.information132,
211 information133 = p_rec.information133,
212 information134 = p_rec.information134,
213 information135 = p_rec.information135,
214 information136 = p_rec.information136,
215 information137 = p_rec.information137,
216 information138 = p_rec.information138,
217 information139 = p_rec.information139,
218 information140 = p_rec.information140,
219 information141 = p_rec.information141,
220 information142 = p_rec.information142,
221 information143 = p_rec.information143,
222 information144 = p_rec.information144,
223 information145 = p_rec.information145,
224 information146 = p_rec.information146,
225 information147 = p_rec.information147,
226 information148 = p_rec.information148,
227 information149 = p_rec.information149,
228 information150 = p_rec.information150,
229 information151 = p_rec.information151,
230 information152 = p_rec.information152,
231 information153 = p_rec.information153,
232 information154 = p_rec.information154,
233 information155 = p_rec.information155,
234 information156 = p_rec.information156,
235 information157 = p_rec.information157,
236 information158 = p_rec.information158,
237 information159 = p_rec.information159,
238 information160 = p_rec.information160,
239 information161 = p_rec.information161,
240 information162 = p_rec.information162,
241 information163 = p_rec.information163,
242 information164 = p_rec.information164,
243 information165 = p_rec.information165,
244 information166 = p_rec.information166,
245 information167 = p_rec.information167,
246 information168 = p_rec.information168,
247 information169 = p_rec.information169,
248 information170 = p_rec.information170,
249 information171 = p_rec.information171,
250 information172 = p_rec.information172,
251 information173 = p_rec.information173,
252 information174 = p_rec.information174,
253 information175 = p_rec.information175,
254 information176 = p_rec.information176,
255 information177 = p_rec.information177,
256 information178 = p_rec.information178,
257 information179 = p_rec.information179,
258 information180 = p_rec.information180,
259 information181 = p_rec.information181,
260 information182 = p_rec.information182,
261 information183 = p_rec.information183,
262 information184 = p_rec.information184,
263 information185 = p_rec.information185,
264 information186 = p_rec.information186,
265 information187 = p_rec.information187,
266 information188 = p_rec.information188,
267 information189 = p_rec.information189,
268 information190 = p_rec.information190,
269 information191 = p_rec.information191,
270 information192 = p_rec.information192,
271 information193 = p_rec.information193,
272 information194 = p_rec.information194,
273 information195 = p_rec.information195,
274 information196 = p_rec.information196,
275 information197 = p_rec.information197,
276 information198 = p_rec.information198,
277 information199 = p_rec.information199,
278 information200 = p_rec.information200
279 where pa_history_id = p_rec.pa_history_id;
280 --
281 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
282 --
283 hr_utility.set_location(' Leaving:'||l_proc, 10);
284 --
285 Exception
286 When hr_api.check_integrity_violated Then
287 -- A check constraint has been violated
288 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
289 ghr_pah_shd.constraint_error
290 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
291 When hr_api.parent_integrity_violated Then
292 -- Parent integrity has been violated
293 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
294 ghr_pah_shd.constraint_error
295 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
296 When hr_api.unique_integrity_violated Then
297 -- Unique integrity has been violated
298 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
299 ghr_pah_shd.constraint_error
300 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
301 When Others Then
302 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
303 Raise;
304 End update_dml;
305 --
306 -- ----------------------------------------------------------------------------
307 -- |------------------------------< pre_update >------------------------------|
308 -- ----------------------------------------------------------------------------
309 -- {Start Of Comments}
310 --
311 -- Description:
312 -- This private procedure contains any processing which is required before
313 -- the update dml.
314 --
315 -- Prerequisites:
316 -- This is an internal procedure which is called from the upd procedure.
317 --
318 -- In Parameters:
319 -- A Pl/Sql record structre.
320 --
321 -- Post Success:
322 -- Processing continues.
323 --
324 -- Post Failure:
325 -- If an error has occurred, an error message and exception will be raised
326 -- but not handled.
327 --
328 -- Developer Implementation Notes:
329 -- Any pre-processing required before the update dml is issued should be
330 -- coded within this procedure. It is important to note that any 3rd party
331 -- maintenance should be reviewed before placing in this procedure.
332 --
333 -- Access Status:
334 -- Internal Row Handler Use Only.
335 --
336 -- {End Of Comments}
337 -- ----------------------------------------------------------------------------
338 Procedure pre_update(p_rec in ghr_pah_shd.g_rec_type) is
339 --
340 l_proc varchar2(72) := g_package||'pre_update';
341 --
342 Begin
343 hr_utility.set_location('Entering:'||l_proc, 5);
344 --
345 hr_utility.set_location(' Leaving:'||l_proc, 10);
346 End pre_update;
347 --
348 -- ----------------------------------------------------------------------------
349 -- |-----------------------------< post_update >------------------------------|
350 -- ----------------------------------------------------------------------------
351 -- {Start Of Comments}
352 --
353 -- Description:
354 -- This private procedure contains any processing which is required after the
355 -- update dml.
356 --
357 -- Prerequisites:
358 -- This is an internal procedure which is called from the upd procedure.
359 --
360 -- In Parameters:
361 -- A Pl/Sql record structre.
362 --
363 -- Post Success:
364 -- Processing continues.
365 --
366 -- Post Failure:
367 -- If an error has occurred, an error message and exception will be raised
368 -- but not handled.
369 --
370 -- Developer Implementation Notes:
371 -- Any post-processing required after the update dml is issued should be
372 -- coded within this procedure. It is important to note that any 3rd party
373 -- maintenance should be reviewed before placing in this procedure.
374 --
375 -- Access Status:
376 -- Internal Row Handler Use Only.
377 --
378 -- {End Of Comments}
379 -- ----------------------------------------------------------------------------
380 Procedure post_update(p_rec in ghr_pah_shd.g_rec_type) is
381 --
382 l_proc varchar2(72) := g_package||'post_update';
383 --
384 Begin
385 hr_utility.set_location('Entering:'||l_proc, 5);
386 --
387 -- This is a hook point and the user hook for post_update is called here.
388 --
389 begin
390 ghr_pah_rku.after_update (
391 p_PA_HISTORY_ID => p_rec.PA_HISTORY_ID ,
392 p_PA_REQUEST_ID => p_rec.PA_REQUEST_ID ,
393 p_PROCESS_DATE => p_rec.PROCESS_DATE ,
394 p_NATURE_OF_ACTION_ID => p_rec.NATURE_OF_ACTION_ID ,
395 p_EFFECTIVE_DATE => p_rec.EFFECTIVE_DATE ,
396 p_ALTERED_PA_REQUEST_ID => p_rec.ALTERED_PA_REQUEST_ID ,
397 p_PERSON_ID => p_rec.PERSON_ID ,
398 p_ASSIGNMENT_ID => p_rec.ASSIGNMENT_ID ,
399 p_DML_OPERATION => p_rec.DML_OPERATION ,
400 p_TABLE_NAME => p_rec.TABLE_NAME ,
401 p_PRE_VALUES_FLAG => p_rec.PRE_VALUES_FLAG ,
402 p_INFORMATION1 => p_rec.INFORMATION1 ,
403 p_INFORMATION2 => p_rec.INFORMATION2 ,
404 p_INFORMATION3 => p_rec.INFORMATION3 ,
405 p_INFORMATION4 => p_rec.INFORMATION4 ,
406 p_INFORMATION5 => p_rec.INFORMATION5 ,
407 p_INFORMATION6 => p_rec.INFORMATION6 ,
408 p_INFORMATION7 => p_rec.INFORMATION7 ,
409 p_INFORMATION8 => p_rec.INFORMATION8 ,
410 p_INFORMATION9 => p_rec.INFORMATION9 ,
411 p_INFORMATION10 => p_rec.INFORMATION10 ,
412 p_INFORMATION11 => p_rec.INFORMATION11 ,
413 p_INFORMATION12 => p_rec.INFORMATION12 ,
414 p_INFORMATION13 => p_rec.INFORMATION13 ,
415 p_INFORMATION14 => p_rec.INFORMATION14 ,
416 p_INFORMATION15 => p_rec.INFORMATION15 ,
417 p_INFORMATION16 => p_rec.INFORMATION16 ,
418 p_INFORMATION17 => p_rec.INFORMATION17 ,
419 p_INFORMATION18 => p_rec.INFORMATION18 ,
420 p_INFORMATION19 => p_rec.INFORMATION19 ,
421 p_INFORMATION20 => p_rec.INFORMATION20 ,
422 p_INFORMATION21 => p_rec.INFORMATION21 ,
423 p_INFORMATION22 => p_rec.INFORMATION22 ,
424 p_INFORMATION23 => p_rec.INFORMATION23 ,
425 p_INFORMATION24 => p_rec.INFORMATION24 ,
426 p_INFORMATION25 => p_rec.INFORMATION25 ,
427 p_INFORMATION26 => p_rec.INFORMATION26 ,
428 p_INFORMATION27 => p_rec.INFORMATION27 ,
429 p_INFORMATION28 => p_rec.INFORMATION28 ,
430 p_INFORMATION29 => p_rec.INFORMATION29 ,
431 p_INFORMATION30 => p_rec.INFORMATION30 ,
432 p_INFORMATION31 => p_rec.INFORMATION31 ,
433 p_INFORMATION32 => p_rec.INFORMATION32 ,
434 p_INFORMATION33 => p_rec.INFORMATION33 ,
435 p_INFORMATION34 => p_rec.INFORMATION34 ,
436 p_INFORMATION35 => p_rec.INFORMATION35 ,
437 p_INFORMATION36 => p_rec.INFORMATION36 ,
438 p_INFORMATION37 => p_rec.INFORMATION37 ,
439 p_INFORMATION38 => p_rec.INFORMATION38 ,
440 p_INFORMATION39 => p_rec.INFORMATION39 ,
441 p_INFORMATION47 => p_rec.INFORMATION47 ,
442 p_INFORMATION48 => p_rec.INFORMATION48 ,
443 p_INFORMATION49 => p_rec.INFORMATION49 ,
444 p_INFORMATION40 => p_rec.INFORMATION40 ,
445 p_INFORMATION41 => p_rec.INFORMATION41 ,
446 p_INFORMATION42 => p_rec.INFORMATION42 ,
447 p_INFORMATION43 => p_rec.INFORMATION43 ,
448 p_INFORMATION44 => p_rec.INFORMATION44 ,
449 p_INFORMATION45 => p_rec.INFORMATION45 ,
450 p_INFORMATION46 => p_rec.INFORMATION46 ,
451 p_INFORMATION50 => p_rec.INFORMATION50 ,
452 p_INFORMATION51 => p_rec.INFORMATION51 ,
453 p_INFORMATION52 => p_rec.INFORMATION52 ,
454 p_INFORMATION53 => p_rec.INFORMATION53 ,
455 p_INFORMATION54 => p_rec.INFORMATION54 ,
456 p_INFORMATION55 => p_rec.INFORMATION55 ,
457 p_INFORMATION56 => p_rec.INFORMATION56 ,
458 p_INFORMATION57 => p_rec.INFORMATION57 ,
459 p_INFORMATION58 => p_rec.INFORMATION58 ,
460 p_INFORMATION59 => p_rec.INFORMATION59 ,
461 p_INFORMATION60 => p_rec.INFORMATION60 ,
462 p_INFORMATION61 => p_rec.INFORMATION61 ,
463 p_INFORMATION62 => p_rec.INFORMATION62 ,
464 p_INFORMATION63 => p_rec.INFORMATION63 ,
465 p_INFORMATION64 => p_rec.INFORMATION64 ,
466 p_INFORMATION65 => p_rec.INFORMATION65 ,
467 p_INFORMATION66 => p_rec.INFORMATION66 ,
468 p_INFORMATION67 => p_rec.INFORMATION67 ,
469 p_INFORMATION68 => p_rec.INFORMATION68 ,
470 p_INFORMATION69 => p_rec.INFORMATION69 ,
471 p_INFORMATION70 => p_rec.INFORMATION70 ,
472 p_INFORMATION71 => p_rec.INFORMATION71 ,
473 p_INFORMATION72 => p_rec.INFORMATION72 ,
474 p_INFORMATION73 => p_rec.INFORMATION73 ,
475 p_INFORMATION74 => p_rec.INFORMATION74 ,
476 p_INFORMATION75 => p_rec.INFORMATION75 ,
477 p_INFORMATION76 => p_rec.INFORMATION76 ,
478 p_INFORMATION77 => p_rec.INFORMATION77 ,
479 p_INFORMATION78 => p_rec.INFORMATION78 ,
480 p_INFORMATION79 => p_rec.INFORMATION79 ,
481 p_INFORMATION80 => p_rec.INFORMATION80 ,
482 p_INFORMATION81 => p_rec.INFORMATION81 ,
483 p_INFORMATION82 => p_rec.INFORMATION82 ,
484 p_INFORMATION83 => p_rec.INFORMATION83 ,
485 p_INFORMATION84 => p_rec.INFORMATION84 ,
486 p_INFORMATION85 => p_rec.INFORMATION85 ,
487 p_INFORMATION86 => p_rec.INFORMATION86 ,
488 p_INFORMATION87 => p_rec.INFORMATION87 ,
489 p_INFORMATION88 => p_rec.INFORMATION88 ,
490 p_INFORMATION89 => p_rec.INFORMATION89 ,
491 p_INFORMATION90 => p_rec.INFORMATION90 ,
492 p_INFORMATION91 => p_rec.INFORMATION91 ,
493 p_INFORMATION92 => p_rec.INFORMATION92 ,
494 p_INFORMATION93 => p_rec.INFORMATION93 ,
495 p_INFORMATION94 => p_rec.INFORMATION94 ,
496 p_INFORMATION95 => p_rec.INFORMATION95 ,
497 p_INFORMATION96 => p_rec.INFORMATION96 ,
498 p_INFORMATION97 => p_rec.INFORMATION97 ,
499 p_INFORMATION98 => p_rec.INFORMATION98 ,
500 p_INFORMATION99 => p_rec.INFORMATION99 ,
501 p_INFORMATION100 => p_rec.INFORMATION100 ,
502 p_INFORMATION101 => p_rec.INFORMATION101 ,
503 p_INFORMATION102 => p_rec.INFORMATION102 ,
504 p_INFORMATION103 => p_rec.INFORMATION103 ,
505 p_INFORMATION104 => p_rec.INFORMATION104 ,
506 p_INFORMATION105 => p_rec.INFORMATION105 ,
507 p_INFORMATION106 => p_rec.INFORMATION106 ,
508 p_INFORMATION107 => p_rec.INFORMATION107 ,
509 p_INFORMATION108 => p_rec.INFORMATION108 ,
510 p_INFORMATION109 => p_rec.INFORMATION109 ,
511 p_INFORMATION110 => p_rec.INFORMATION110 ,
512 p_INFORMATION111 => p_rec.INFORMATION111 ,
513 p_INFORMATION112 => p_rec.INFORMATION112 ,
514 p_INFORMATION113 => p_rec.INFORMATION113 ,
515 p_INFORMATION114 => p_rec.INFORMATION114 ,
516 p_INFORMATION115 => p_rec.INFORMATION115 ,
517 p_INFORMATION116 => p_rec.INFORMATION116 ,
518 p_INFORMATION117 => p_rec.INFORMATION117 ,
519 p_INFORMATION118 => p_rec.INFORMATION118 ,
520 p_INFORMATION119 => p_rec.INFORMATION119 ,
521 p_INFORMATION120 => p_rec.INFORMATION120 ,
522 p_INFORMATION121 => p_rec.INFORMATION121 ,
523 p_INFORMATION122 => p_rec.INFORMATION122 ,
524 p_INFORMATION123 => p_rec.INFORMATION123 ,
525 p_INFORMATION124 => p_rec.INFORMATION124 ,
526 p_INFORMATION125 => p_rec.INFORMATION125 ,
527 p_INFORMATION126 => p_rec.INFORMATION126 ,
528 p_INFORMATION127 => p_rec.INFORMATION127 ,
529 p_INFORMATION128 => p_rec.INFORMATION128 ,
530 p_INFORMATION129 => p_rec.INFORMATION129 ,
531 p_INFORMATION130 => p_rec.INFORMATION130 ,
532 p_INFORMATION131 => p_rec.INFORMATION131 ,
533 p_INFORMATION132 => p_rec.INFORMATION132 ,
534 p_INFORMATION133 => p_rec.INFORMATION133 ,
535 p_INFORMATION134 => p_rec.INFORMATION134 ,
536 p_INFORMATION135 => p_rec.INFORMATION135 ,
537 p_INFORMATION136 => p_rec.INFORMATION136 ,
538 p_INFORMATION137 => p_rec.INFORMATION137 ,
539 p_INFORMATION138 => p_rec.INFORMATION138 ,
540 p_INFORMATION139 => p_rec.INFORMATION139 ,
541 p_INFORMATION140 => p_rec.INFORMATION140 ,
542 p_INFORMATION141 => p_rec.INFORMATION141 ,
543 p_INFORMATION142 => p_rec.INFORMATION142 ,
544 p_INFORMATION143 => p_rec.INFORMATION143 ,
545 p_INFORMATION144 => p_rec.INFORMATION144 ,
546 p_INFORMATION145 => p_rec.INFORMATION145 ,
547 p_INFORMATION146 => p_rec.INFORMATION146 ,
548 p_INFORMATION147 => p_rec.INFORMATION147 ,
549 p_INFORMATION148 => p_rec.INFORMATION148 ,
550 p_INFORMATION149 => p_rec.INFORMATION149 ,
551 p_INFORMATION150 => p_rec.INFORMATION150 ,
552 p_INFORMATION151 => p_rec.INFORMATION151 ,
553 p_INFORMATION152 => p_rec.INFORMATION152 ,
554 p_INFORMATION153 => p_rec.INFORMATION153 ,
555 p_INFORMATION154 => p_rec.INFORMATION154 ,
556 p_INFORMATION155 => p_rec.INFORMATION155 ,
557 p_INFORMATION156 => p_rec.INFORMATION156 ,
558 p_INFORMATION157 => p_rec.INFORMATION157 ,
559 p_INFORMATION158 => p_rec.INFORMATION158 ,
560 p_INFORMATION159 => p_rec.INFORMATION159 ,
561 p_INFORMATION160 => p_rec.INFORMATION160 ,
562 p_INFORMATION161 => p_rec.INFORMATION161 ,
563 p_INFORMATION162 => p_rec.INFORMATION162 ,
564 p_INFORMATION163 => p_rec.INFORMATION163 ,
565 p_INFORMATION164 => p_rec.INFORMATION164 ,
566 p_INFORMATION165 => p_rec.INFORMATION165 ,
567 p_INFORMATION166 => p_rec.INFORMATION166 ,
568 p_INFORMATION167 => p_rec.INFORMATION167 ,
569 p_INFORMATION168 => p_rec.INFORMATION168 ,
570 p_INFORMATION169 => p_rec.INFORMATION169 ,
571 p_INFORMATION170 => p_rec.INFORMATION170 ,
572 p_INFORMATION171 => p_rec.INFORMATION171 ,
573 p_INFORMATION172 => p_rec.INFORMATION172 ,
574 p_INFORMATION173 => p_rec.INFORMATION173 ,
575 p_INFORMATION174 => p_rec.INFORMATION174 ,
576 p_INFORMATION175 => p_rec.INFORMATION175 ,
577 p_INFORMATION176 => p_rec.INFORMATION176 ,
578 p_INFORMATION177 => p_rec.INFORMATION177 ,
579 p_INFORMATION178 => p_rec.INFORMATION178 ,
580 p_INFORMATION179 => p_rec.INFORMATION179 ,
581 p_INFORMATION180 => p_rec.INFORMATION180 ,
582 p_INFORMATION181 => p_rec.INFORMATION181 ,
583 p_INFORMATION182 => p_rec.INFORMATION182 ,
584 p_INFORMATION183 => p_rec.INFORMATION183 ,
585 p_INFORMATION184 => p_rec.INFORMATION184 ,
586 p_INFORMATION185 => p_rec.INFORMATION185 ,
587 p_INFORMATION186 => p_rec.INFORMATION186 ,
588 p_INFORMATION187 => p_rec.INFORMATION187 ,
589 p_INFORMATION188 => p_rec.INFORMATION188 ,
590 p_INFORMATION189 => p_rec.INFORMATION189 ,
591 p_INFORMATION190 => p_rec.INFORMATION190 ,
592 p_INFORMATION191 => p_rec.INFORMATION191 ,
593 p_INFORMATION192 => p_rec.INFORMATION192 ,
594 p_INFORMATION193 => p_rec.INFORMATION193 ,
595 p_INFORMATION194 => p_rec.INFORMATION194 ,
596 p_INFORMATION195 => p_rec.INFORMATION195 ,
597 p_INFORMATION196 => p_rec.INFORMATION196 ,
598 p_INFORMATION197 => p_rec.INFORMATION197 ,
599 p_INFORMATION198 => p_rec.INFORMATION198 ,
600 p_INFORMATION199 => p_rec.INFORMATION199 ,
601 p_INFORMATION200 => p_rec.INFORMATION200 ,
602 p_PA_REQUEST_ID_o => ghr_pah_shd.g_old_rec.PA_REQUEST_ID ,
603 p_PROCESS_DATE_o => ghr_pah_shd.g_old_rec.PROCESS_DATE ,
604 p_NATURE_OF_ACTION_ID_o => ghr_pah_shd.g_old_rec.NATURE_OF_ACTION_ID ,
605 p_EFFECTIVE_DATE_o => ghr_pah_shd.g_old_rec.EFFECTIVE_DATE ,
606 p_ALTERED_PA_REQUEST_ID_o => ghr_pah_shd.g_old_rec.ALTERED_PA_REQUEST_ID ,
607 p_PERSON_ID_o => ghr_pah_shd.g_old_rec.PERSON_ID ,
608 p_ASSIGNMENT_ID_o => ghr_pah_shd.g_old_rec.ASSIGNMENT_ID ,
609 p_DML_OPERATION_o => ghr_pah_shd.g_old_rec.DML_OPERATION ,
610 p_TABLE_NAME_o => ghr_pah_shd.g_old_rec.TABLE_NAME ,
611 p_PRE_VALUES_FLAG_o => ghr_pah_shd.g_old_rec.PRE_VALUES_FLAG ,
612 p_INFORMATION1_o => ghr_pah_shd.g_old_rec.INFORMATION1 ,
613 p_INFORMATION2_o => ghr_pah_shd.g_old_rec.INFORMATION2 ,
614 p_INFORMATION3_o => ghr_pah_shd.g_old_rec.INFORMATION3 ,
615 p_INFORMATION4_o => ghr_pah_shd.g_old_rec.INFORMATION4 ,
616 p_INFORMATION5_o => ghr_pah_shd.g_old_rec.INFORMATION5 ,
617 p_INFORMATION6_o => ghr_pah_shd.g_old_rec.INFORMATION6 ,
618 p_INFORMATION7_o => ghr_pah_shd.g_old_rec.INFORMATION7 ,
619 p_INFORMATION8_o => ghr_pah_shd.g_old_rec.INFORMATION8 ,
620 p_INFORMATION9_o => ghr_pah_shd.g_old_rec.INFORMATION9 ,
621 p_INFORMATION10_o => ghr_pah_shd.g_old_rec.INFORMATION10 ,
622 p_INFORMATION11_o => ghr_pah_shd.g_old_rec.INFORMATION11 ,
623 p_INFORMATION12_o => ghr_pah_shd.g_old_rec.INFORMATION12 ,
624 p_INFORMATION13_o => ghr_pah_shd.g_old_rec.INFORMATION13 ,
625 p_INFORMATION14_o => ghr_pah_shd.g_old_rec.INFORMATION14 ,
626 p_INFORMATION15_o => ghr_pah_shd.g_old_rec.INFORMATION15 ,
627 p_INFORMATION16_o => ghr_pah_shd.g_old_rec.INFORMATION16 ,
628 p_INFORMATION17_o => ghr_pah_shd.g_old_rec.INFORMATION17 ,
629 p_INFORMATION18_o => ghr_pah_shd.g_old_rec.INFORMATION18 ,
630 p_INFORMATION19_o => ghr_pah_shd.g_old_rec.INFORMATION19 ,
631 p_INFORMATION20_o => ghr_pah_shd.g_old_rec.INFORMATION20 ,
632 p_INFORMATION21_o => ghr_pah_shd.g_old_rec.INFORMATION21 ,
633 p_INFORMATION22_o => ghr_pah_shd.g_old_rec.INFORMATION22 ,
634 p_INFORMATION23_o => ghr_pah_shd.g_old_rec.INFORMATION23 ,
635 p_INFORMATION24_o => ghr_pah_shd.g_old_rec.INFORMATION24 ,
636 p_INFORMATION25_o => ghr_pah_shd.g_old_rec.INFORMATION25 ,
637 p_INFORMATION26_o => ghr_pah_shd.g_old_rec.INFORMATION26 ,
638 p_INFORMATION27_o => ghr_pah_shd.g_old_rec.INFORMATION27 ,
639 p_INFORMATION28_o => ghr_pah_shd.g_old_rec.INFORMATION28 ,
640 p_INFORMATION29_o => ghr_pah_shd.g_old_rec.INFORMATION29 ,
641 p_INFORMATION30_o => ghr_pah_shd.g_old_rec.INFORMATION30 ,
642 p_INFORMATION31_o => ghr_pah_shd.g_old_rec.INFORMATION31 ,
643 p_INFORMATION32_o => ghr_pah_shd.g_old_rec.INFORMATION32 ,
644 p_INFORMATION33_o => ghr_pah_shd.g_old_rec.INFORMATION33 ,
645 p_INFORMATION34_o => ghr_pah_shd.g_old_rec.INFORMATION34 ,
646 p_INFORMATION35_o => ghr_pah_shd.g_old_rec.INFORMATION35 ,
647 p_INFORMATION36_o => ghr_pah_shd.g_old_rec.INFORMATION36 ,
648 p_INFORMATION37_o => ghr_pah_shd.g_old_rec.INFORMATION37 ,
649 p_INFORMATION38_o => ghr_pah_shd.g_old_rec.INFORMATION38 ,
650 p_INFORMATION39_o => ghr_pah_shd.g_old_rec.INFORMATION39 ,
651 p_INFORMATION47_o => ghr_pah_shd.g_old_rec.INFORMATION47 ,
652 p_INFORMATION48_o => ghr_pah_shd.g_old_rec.INFORMATION48 ,
653 p_INFORMATION49_o => ghr_pah_shd.g_old_rec.INFORMATION49 ,
654 p_INFORMATION40_o => ghr_pah_shd.g_old_rec.INFORMATION40 ,
655 p_INFORMATION41_o => ghr_pah_shd.g_old_rec.INFORMATION41 ,
656 p_INFORMATION42_o => ghr_pah_shd.g_old_rec.INFORMATION42 ,
657 p_INFORMATION43_o => ghr_pah_shd.g_old_rec.INFORMATION43 ,
658 p_INFORMATION44_o => ghr_pah_shd.g_old_rec.INFORMATION44 ,
659 p_INFORMATION45_o => ghr_pah_shd.g_old_rec.INFORMATION45 ,
660 p_INFORMATION46_o => ghr_pah_shd.g_old_rec.INFORMATION46 ,
661 p_INFORMATION50_o => ghr_pah_shd.g_old_rec.INFORMATION50 ,
662 p_INFORMATION51_o => ghr_pah_shd.g_old_rec.INFORMATION51 ,
663 p_INFORMATION52_o => ghr_pah_shd.g_old_rec.INFORMATION52 ,
664 p_INFORMATION53_o => ghr_pah_shd.g_old_rec.INFORMATION53 ,
665 p_INFORMATION54_o => ghr_pah_shd.g_old_rec.INFORMATION54 ,
666 p_INFORMATION55_o => ghr_pah_shd.g_old_rec.INFORMATION55 ,
667 p_INFORMATION56_o => ghr_pah_shd.g_old_rec.INFORMATION56 ,
668 p_INFORMATION57_o => ghr_pah_shd.g_old_rec.INFORMATION57 ,
669 p_INFORMATION58_o => ghr_pah_shd.g_old_rec.INFORMATION58 ,
670 p_INFORMATION59_o => ghr_pah_shd.g_old_rec.INFORMATION59 ,
671 p_INFORMATION60_o => ghr_pah_shd.g_old_rec.INFORMATION60 ,
672 p_INFORMATION61_o => ghr_pah_shd.g_old_rec.INFORMATION61 ,
673 p_INFORMATION62_o => ghr_pah_shd.g_old_rec.INFORMATION62 ,
674 p_INFORMATION63_o => ghr_pah_shd.g_old_rec.INFORMATION63 ,
675 p_INFORMATION64_o => ghr_pah_shd.g_old_rec.INFORMATION64 ,
676 p_INFORMATION65_o => ghr_pah_shd.g_old_rec.INFORMATION65 ,
677 p_INFORMATION66_o => ghr_pah_shd.g_old_rec.INFORMATION66 ,
678 p_INFORMATION67_o => ghr_pah_shd.g_old_rec.INFORMATION67 ,
679 p_INFORMATION68_o => ghr_pah_shd.g_old_rec.INFORMATION68 ,
680 p_INFORMATION69_o => ghr_pah_shd.g_old_rec.INFORMATION69 ,
681 p_INFORMATION70_o => ghr_pah_shd.g_old_rec.INFORMATION70 ,
682 p_INFORMATION71_o => ghr_pah_shd.g_old_rec.INFORMATION71 ,
683 p_INFORMATION72_o => ghr_pah_shd.g_old_rec.INFORMATION72 ,
684 p_INFORMATION73_o => ghr_pah_shd.g_old_rec.INFORMATION73 ,
685 p_INFORMATION74_o => ghr_pah_shd.g_old_rec.INFORMATION74 ,
686 p_INFORMATION75_o => ghr_pah_shd.g_old_rec.INFORMATION75 ,
687 p_INFORMATION76_o => ghr_pah_shd.g_old_rec.INFORMATION76 ,
688 p_INFORMATION77_o => ghr_pah_shd.g_old_rec.INFORMATION77 ,
689 p_INFORMATION78_o => ghr_pah_shd.g_old_rec.INFORMATION78 ,
690 p_INFORMATION79_o => ghr_pah_shd.g_old_rec.INFORMATION79 ,
691 p_INFORMATION80_o => ghr_pah_shd.g_old_rec.INFORMATION80 ,
692 p_INFORMATION81_o => ghr_pah_shd.g_old_rec.INFORMATION81 ,
693 p_INFORMATION82_o => ghr_pah_shd.g_old_rec.INFORMATION82 ,
694 p_INFORMATION83_o => ghr_pah_shd.g_old_rec.INFORMATION83 ,
695 p_INFORMATION84_o => ghr_pah_shd.g_old_rec.INFORMATION84 ,
696 p_INFORMATION85_o => ghr_pah_shd.g_old_rec.INFORMATION85 ,
697 p_INFORMATION86_o => ghr_pah_shd.g_old_rec.INFORMATION86 ,
698 p_INFORMATION87_o => ghr_pah_shd.g_old_rec.INFORMATION87 ,
699 p_INFORMATION88_o => ghr_pah_shd.g_old_rec.INFORMATION88 ,
700 p_INFORMATION89_o => ghr_pah_shd.g_old_rec.INFORMATION89 ,
701 p_INFORMATION90_o => ghr_pah_shd.g_old_rec.INFORMATION90 ,
702 p_INFORMATION91_o => ghr_pah_shd.g_old_rec.INFORMATION91 ,
703 p_INFORMATION92_o => ghr_pah_shd.g_old_rec.INFORMATION92 ,
704 p_INFORMATION93_o => ghr_pah_shd.g_old_rec.INFORMATION93 ,
705 p_INFORMATION94_o => ghr_pah_shd.g_old_rec.INFORMATION94 ,
706 p_INFORMATION95_o => ghr_pah_shd.g_old_rec.INFORMATION95 ,
707 p_INFORMATION96_o => ghr_pah_shd.g_old_rec.INFORMATION96 ,
708 p_INFORMATION97_o => ghr_pah_shd.g_old_rec.INFORMATION97 ,
709 p_INFORMATION98_o => ghr_pah_shd.g_old_rec.INFORMATION98 ,
710 p_INFORMATION99_o => ghr_pah_shd.g_old_rec.INFORMATION99 ,
711 p_INFORMATION100_o => ghr_pah_shd.g_old_rec.INFORMATION100 ,
712 p_INFORMATION101_o => ghr_pah_shd.g_old_rec.INFORMATION101 ,
713 p_INFORMATION102_o => ghr_pah_shd.g_old_rec.INFORMATION102 ,
714 p_INFORMATION103_o => ghr_pah_shd.g_old_rec.INFORMATION103 ,
715 p_INFORMATION104_o => ghr_pah_shd.g_old_rec.INFORMATION104 ,
716 p_INFORMATION105_o => ghr_pah_shd.g_old_rec.INFORMATION105 ,
717 p_INFORMATION106_o => ghr_pah_shd.g_old_rec.INFORMATION106 ,
718 p_INFORMATION107_o => ghr_pah_shd.g_old_rec.INFORMATION107 ,
719 p_INFORMATION108_o => ghr_pah_shd.g_old_rec.INFORMATION108 ,
720 p_INFORMATION109_o => ghr_pah_shd.g_old_rec.INFORMATION109 ,
721 p_INFORMATION110_o => ghr_pah_shd.g_old_rec.INFORMATION110 ,
722 p_INFORMATION111_o => ghr_pah_shd.g_old_rec.INFORMATION111 ,
723 p_INFORMATION112_o => ghr_pah_shd.g_old_rec.INFORMATION112 ,
724 p_INFORMATION113_o => ghr_pah_shd.g_old_rec.INFORMATION113 ,
725 p_INFORMATION114_o => ghr_pah_shd.g_old_rec.INFORMATION114 ,
726 p_INFORMATION115_o => ghr_pah_shd.g_old_rec.INFORMATION115 ,
727 p_INFORMATION116_o => ghr_pah_shd.g_old_rec.INFORMATION116 ,
728 p_INFORMATION117_o => ghr_pah_shd.g_old_rec.INFORMATION117 ,
729 p_INFORMATION118_o => ghr_pah_shd.g_old_rec.INFORMATION118 ,
730 p_INFORMATION119_o => ghr_pah_shd.g_old_rec.INFORMATION119 ,
731 p_INFORMATION120_o => ghr_pah_shd.g_old_rec.INFORMATION120 ,
732 p_INFORMATION121_o => ghr_pah_shd.g_old_rec.INFORMATION121 ,
733 p_INFORMATION122_o => ghr_pah_shd.g_old_rec.INFORMATION122 ,
734 p_INFORMATION123_o => ghr_pah_shd.g_old_rec.INFORMATION123 ,
735 p_INFORMATION124_o => ghr_pah_shd.g_old_rec.INFORMATION124 ,
736 p_INFORMATION125_o => ghr_pah_shd.g_old_rec.INFORMATION125 ,
737 p_INFORMATION126_o => ghr_pah_shd.g_old_rec.INFORMATION126 ,
738 p_INFORMATION127_o => ghr_pah_shd.g_old_rec.INFORMATION127 ,
739 p_INFORMATION128_o => ghr_pah_shd.g_old_rec.INFORMATION128 ,
740 p_INFORMATION129_o => ghr_pah_shd.g_old_rec.INFORMATION129 ,
741 p_INFORMATION130_o => ghr_pah_shd.g_old_rec.INFORMATION130 ,
742 p_INFORMATION131_o => ghr_pah_shd.g_old_rec.INFORMATION131 ,
743 p_INFORMATION132_o => ghr_pah_shd.g_old_rec.INFORMATION132 ,
744 p_INFORMATION133_o => ghr_pah_shd.g_old_rec.INFORMATION133 ,
745 p_INFORMATION134_o => ghr_pah_shd.g_old_rec.INFORMATION134 ,
746 p_INFORMATION135_o => ghr_pah_shd.g_old_rec.INFORMATION135 ,
747 p_INFORMATION136_o => ghr_pah_shd.g_old_rec.INFORMATION136 ,
748 p_INFORMATION137_o => ghr_pah_shd.g_old_rec.INFORMATION137 ,
749 p_INFORMATION138_o => ghr_pah_shd.g_old_rec.INFORMATION138 ,
750 p_INFORMATION139_o => ghr_pah_shd.g_old_rec.INFORMATION139 ,
751 p_INFORMATION140_o => ghr_pah_shd.g_old_rec.INFORMATION140 ,
752 p_INFORMATION141_o => ghr_pah_shd.g_old_rec.INFORMATION141 ,
753 p_INFORMATION142_o => ghr_pah_shd.g_old_rec.INFORMATION142 ,
754 p_INFORMATION143_o => ghr_pah_shd.g_old_rec.INFORMATION143 ,
755 p_INFORMATION144_o => ghr_pah_shd.g_old_rec.INFORMATION144 ,
756 p_INFORMATION145_o => ghr_pah_shd.g_old_rec.INFORMATION145 ,
757 p_INFORMATION146_o => ghr_pah_shd.g_old_rec.INFORMATION146 ,
758 p_INFORMATION147_o => ghr_pah_shd.g_old_rec.INFORMATION147 ,
759 p_INFORMATION148_o => ghr_pah_shd.g_old_rec.INFORMATION148 ,
760 p_INFORMATION149_o => ghr_pah_shd.g_old_rec.INFORMATION149 ,
761 p_INFORMATION150_o => ghr_pah_shd.g_old_rec.INFORMATION150 ,
762 p_INFORMATION151_o => ghr_pah_shd.g_old_rec.INFORMATION151 ,
763 p_INFORMATION152_o => ghr_pah_shd.g_old_rec.INFORMATION152 ,
764 p_INFORMATION153_o => ghr_pah_shd.g_old_rec.INFORMATION153 ,
765 p_INFORMATION154_o => ghr_pah_shd.g_old_rec.INFORMATION154 ,
766 p_INFORMATION155_o => ghr_pah_shd.g_old_rec.INFORMATION155 ,
767 p_INFORMATION156_o => ghr_pah_shd.g_old_rec.INFORMATION156 ,
768 p_INFORMATION157_o => ghr_pah_shd.g_old_rec.INFORMATION157 ,
769 p_INFORMATION158_o => ghr_pah_shd.g_old_rec.INFORMATION158 ,
770 p_INFORMATION159_o => ghr_pah_shd.g_old_rec.INFORMATION159 ,
771 p_INFORMATION160_o => ghr_pah_shd.g_old_rec.INFORMATION160 ,
772 p_INFORMATION161_o => ghr_pah_shd.g_old_rec.INFORMATION161 ,
773 p_INFORMATION162_o => ghr_pah_shd.g_old_rec.INFORMATION162 ,
774 p_INFORMATION163_o => ghr_pah_shd.g_old_rec.INFORMATION163 ,
775 p_INFORMATION164_o => ghr_pah_shd.g_old_rec.INFORMATION164 ,
776 p_INFORMATION165_o => ghr_pah_shd.g_old_rec.INFORMATION165 ,
777 p_INFORMATION166_o => ghr_pah_shd.g_old_rec.INFORMATION166 ,
778 p_INFORMATION167_o => ghr_pah_shd.g_old_rec.INFORMATION167 ,
779 p_INFORMATION168_o => ghr_pah_shd.g_old_rec.INFORMATION168 ,
780 p_INFORMATION169_o => ghr_pah_shd.g_old_rec.INFORMATION169 ,
781 p_INFORMATION170_o => ghr_pah_shd.g_old_rec.INFORMATION170 ,
782 p_INFORMATION171_o => ghr_pah_shd.g_old_rec.INFORMATION171 ,
783 p_INFORMATION172_o => ghr_pah_shd.g_old_rec.INFORMATION172 ,
784 p_INFORMATION173_o => ghr_pah_shd.g_old_rec.INFORMATION173 ,
785 p_INFORMATION174_o => ghr_pah_shd.g_old_rec.INFORMATION174 ,
786 p_INFORMATION175_o => ghr_pah_shd.g_old_rec.INFORMATION175 ,
787 p_INFORMATION176_o => ghr_pah_shd.g_old_rec.INFORMATION176 ,
788 p_INFORMATION177_o => ghr_pah_shd.g_old_rec.INFORMATION177 ,
789 p_INFORMATION178_o => ghr_pah_shd.g_old_rec.INFORMATION178 ,
790 p_INFORMATION179_o => ghr_pah_shd.g_old_rec.INFORMATION179 ,
791 p_INFORMATION180_o => ghr_pah_shd.g_old_rec.INFORMATION180 ,
792 p_INFORMATION181_o => ghr_pah_shd.g_old_rec.INFORMATION181 ,
793 p_INFORMATION182_o => ghr_pah_shd.g_old_rec.INFORMATION182 ,
794 p_INFORMATION183_o => ghr_pah_shd.g_old_rec.INFORMATION183 ,
795 p_INFORMATION184_o => ghr_pah_shd.g_old_rec.INFORMATION184 ,
796 p_INFORMATION185_o => ghr_pah_shd.g_old_rec.INFORMATION185 ,
797 p_INFORMATION186_o => ghr_pah_shd.g_old_rec.INFORMATION186 ,
798 p_INFORMATION187_o => ghr_pah_shd.g_old_rec.INFORMATION187 ,
799 p_INFORMATION188_o => ghr_pah_shd.g_old_rec.INFORMATION188 ,
800 p_INFORMATION189_o => ghr_pah_shd.g_old_rec.INFORMATION189 ,
801 p_INFORMATION190_o => ghr_pah_shd.g_old_rec.INFORMATION190 ,
802 p_INFORMATION191_o => ghr_pah_shd.g_old_rec.INFORMATION191 ,
803 p_INFORMATION192_o => ghr_pah_shd.g_old_rec.INFORMATION192 ,
804 p_INFORMATION193_o => ghr_pah_shd.g_old_rec.INFORMATION193 ,
805 p_INFORMATION194_o => ghr_pah_shd.g_old_rec.INFORMATION194 ,
806 p_INFORMATION195_o => ghr_pah_shd.g_old_rec.INFORMATION195 ,
807 p_INFORMATION196_o => ghr_pah_shd.g_old_rec.INFORMATION196 ,
808 p_INFORMATION197_o => ghr_pah_shd.g_old_rec.INFORMATION197 ,
809 p_INFORMATION198_o => ghr_pah_shd.g_old_rec.INFORMATION198 ,
810 p_INFORMATION199_o => ghr_pah_shd.g_old_rec.INFORMATION199 ,
811 p_INFORMATION200_o => ghr_pah_shd.g_old_rec.INFORMATION200
812 );
813 exception
814 when hr_api.cannot_find_prog_unit then
815 hr_api.cannot_find_prog_unit_error
816 ( p_module_name => 'GHR_PA_HISTORY'
817 ,p_hook_type => 'AU'
818 );
819 end;
820 -- End of API User Hook for post_insert.
821 hr_utility.set_location(' Leaving:'||l_proc, 10);
822 End post_update;
823 --
824 -- ----------------------------------------------------------------------------
825 -- |-----------------------------< convert_defs >-----------------------------|
826 -- ----------------------------------------------------------------------------
827 -- {Start Of Comments}
828 --
829 -- Description:
830 -- The Convert_Defs procedure has one very important function:
831 -- It must return the record structure for the row with all system defaulted
832 -- values converted into its corresponding parameter value for update. When
833 -- we attempt to update a row through the Upd process , certain
834 -- parameters can be defaulted which enables flexibility in the calling of
835 -- the upd process (e.g. only attributes which need to be updated need to be
836 -- specified). For the upd process to determine which attributes
837 -- have NOT been specified we need to check if the parameter has a reserved
838 -- system default value. Therefore, for all parameters which have a
839 -- corresponding reserved system default mechanism specified we need to
840 -- check if a system default is being used. If a system default is being
841 -- used then we convert the defaulted value into its corresponding attribute
842 -- value held in the g_old_rec data structure.
843 --
844 -- Prerequisites:
845 -- This private function can only be called from the upd process.
846 --
847 -- In Parameters:
848 -- A Pl/Sql record structre.
849 --
850 -- Post Success:
851 -- The record structure will be returned with all system defaulted parameter
852 -- values converted into its current row attribute value.
853 --
854 -- Post Failure:
855 -- No direct error handling is required within this function. Any possible
856 -- errors within this procedure will be a PL/SQL value error due to conversion
857
858 -- of datatypes or data lengths.
859 --
860 -- Developer Implementation Notes:
861 -- None.
862 --
863 -- Access Status:
864 -- Internal Row Handler Use Only.
865 --
866 -- {End Of Comments}
867 -- ----------------------------------------------------------------------------
868 Procedure convert_defs(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
869 --
870 l_proc varchar2(72) := g_package||'convert_defs';
871 --
872 Begin
873 --
874 hr_utility.set_location('Entering:'||l_proc, 5);
875 --
876 -- We must now examine each argument value in the
877 -- p_rec plsql record structure
878 -- to see if a system default is being used. If a system default
879 -- is being used then we must set to the 'current' argument value.
880 --
881 If (p_rec.pa_request_id = hr_api.g_number) then
882 p_rec.pa_request_id :=
883 ghr_pah_shd.g_old_rec.pa_request_id;
884 End If;
885 If (p_rec.process_date = hr_api.g_date) then
886 p_rec.process_date :=
887 ghr_pah_shd.g_old_rec.process_date;
888 End If;
889 If (p_rec.nature_of_action_id = hr_api.g_number) then
890 p_rec.nature_of_action_id :=
891 ghr_pah_shd.g_old_rec.nature_of_action_id;
892 End If;
893 If (p_rec.effective_date = hr_api.g_date) then
894 p_rec.effective_date :=
895 ghr_pah_shd.g_old_rec.effective_date;
896 End If;
897 If (p_rec.altered_pa_request_id = hr_api.g_number) then
898 p_rec.altered_pa_request_id :=
899 ghr_pah_shd.g_old_rec.altered_pa_request_id;
900 End If;
901 If (p_rec.person_id = hr_api.g_number) then
902 p_rec.person_id :=
903 ghr_pah_shd.g_old_rec.person_id;
904 End If;
905 If (p_rec.assignment_id = hr_api.g_number) then
906 p_rec.assignment_id :=
907 ghr_pah_shd.g_old_rec.assignment_id;
908 End If;
909 If (p_rec.dml_operation = hr_api.g_varchar2) then
910 p_rec.dml_operation :=
911 ghr_pah_shd.g_old_rec.dml_operation;
912 End If;
913 If (p_rec.table_name = hr_api.g_varchar2) then
914 p_rec.table_name :=
915 ghr_pah_shd.g_old_rec.table_name;
916 End If;
917 If (p_rec.pre_values_flag = hr_api.g_varchar2) then
918 p_rec.pre_values_flag :=
919 ghr_pah_shd.g_old_rec.pre_values_flag;
920 End If;
921 If (p_rec.information1 = hr_api.g_varchar2) then
922 p_rec.information1 :=
923 ghr_pah_shd.g_old_rec.information1;
924 End If;
925 If (p_rec.information2 = hr_api.g_varchar2) then
926 p_rec.information2 :=
927 ghr_pah_shd.g_old_rec.information2;
928 End If;
929 If (p_rec.information3 = hr_api.g_varchar2) then
930 p_rec.information3 :=
931 ghr_pah_shd.g_old_rec.information3;
932 End If;
933 If (p_rec.information4 = hr_api.g_varchar2) then
934 p_rec.information4 :=
935 ghr_pah_shd.g_old_rec.information4;
936 End If;
937 If (p_rec.information5 = hr_api.g_varchar2) then
938 p_rec.information5 :=
939 ghr_pah_shd.g_old_rec.information5;
940 End If;
941 If (p_rec.information6 = hr_api.g_varchar2) then
942 p_rec.information6 :=
943 ghr_pah_shd.g_old_rec.information6;
944 End If;
945 If (p_rec.information7 = hr_api.g_varchar2) then
946 p_rec.information7 :=
947 ghr_pah_shd.g_old_rec.information7;
948 End If;
949 If (p_rec.information8 = hr_api.g_varchar2) then
950 p_rec.information8 :=
951 ghr_pah_shd.g_old_rec.information8;
952 End If;
953 If (p_rec.information9 = hr_api.g_varchar2) then
954 p_rec.information9 :=
955 ghr_pah_shd.g_old_rec.information9;
956 End If;
957 If (p_rec.information10 = hr_api.g_varchar2) then
958 p_rec.information10 :=
959 ghr_pah_shd.g_old_rec.information10;
960 End If;
961 If (p_rec.information11 = hr_api.g_varchar2) then
962 p_rec.information11 :=
963 ghr_pah_shd.g_old_rec.information11;
964 End If;
965 If (p_rec.information12 = hr_api.g_varchar2) then
966 p_rec.information12 :=
967 ghr_pah_shd.g_old_rec.information12;
968 End If;
969 If (p_rec.information13 = hr_api.g_varchar2) then
970 p_rec.information13 :=
971 ghr_pah_shd.g_old_rec.information13;
972 End If;
973 If (p_rec.information14 = hr_api.g_varchar2) then
974 p_rec.information14 :=
975 ghr_pah_shd.g_old_rec.information14;
976 End If;
977 If (p_rec.information15 = hr_api.g_varchar2) then
978 p_rec.information15 :=
979 ghr_pah_shd.g_old_rec.information15;
980 End If;
981 If (p_rec.information16 = hr_api.g_varchar2) then
982 p_rec.information16 :=
983 ghr_pah_shd.g_old_rec.information16;
984 End If;
985 If (p_rec.information17 = hr_api.g_varchar2) then
986 p_rec.information17 :=
987 ghr_pah_shd.g_old_rec.information17;
988 End If;
989 If (p_rec.information18 = hr_api.g_varchar2) then
990 p_rec.information18 :=
991 ghr_pah_shd.g_old_rec.information18;
992 End If;
993 If (p_rec.information19 = hr_api.g_varchar2) then
994 p_rec.information19 :=
995 ghr_pah_shd.g_old_rec.information19;
996 End If;
997 If (p_rec.information20 = hr_api.g_varchar2) then
998 p_rec.information20 :=
999 ghr_pah_shd.g_old_rec.information20;
1000 End If;
1001 If (p_rec.information21 = hr_api.g_varchar2) then
1002 p_rec.information21 :=
1003 ghr_pah_shd.g_old_rec.information21;
1004 End If;
1005 If (p_rec.information22 = hr_api.g_varchar2) then
1006 p_rec.information22 :=
1007 ghr_pah_shd.g_old_rec.information22;
1008 End If;
1009 If (p_rec.information23 = hr_api.g_varchar2) then
1010 p_rec.information23 :=
1011 ghr_pah_shd.g_old_rec.information23;
1012 End If;
1013 If (p_rec.information24 = hr_api.g_varchar2) then
1014 p_rec.information24 :=
1015 ghr_pah_shd.g_old_rec.information24;
1016 End If;
1017 If (p_rec.information25 = hr_api.g_varchar2) then
1018 p_rec.information25 :=
1019 ghr_pah_shd.g_old_rec.information25;
1020 End If;
1021 If (p_rec.information26 = hr_api.g_varchar2) then
1022 p_rec.information26 :=
1023 ghr_pah_shd.g_old_rec.information26;
1024 End If;
1025 If (p_rec.information27 = hr_api.g_varchar2) then
1026 p_rec.information27 :=
1027 ghr_pah_shd.g_old_rec.information27;
1028 End If;
1029 If (p_rec.information28 = hr_api.g_varchar2) then
1030 p_rec.information28 :=
1031 ghr_pah_shd.g_old_rec.information28;
1032 End If;
1033 If (p_rec.information29 = hr_api.g_varchar2) then
1034 p_rec.information29 :=
1035 ghr_pah_shd.g_old_rec.information29;
1036 End If;
1037 If (p_rec.information30 = hr_api.g_varchar2) then
1038 p_rec.information30 :=
1039 ghr_pah_shd.g_old_rec.information30;
1040 End If;
1041 If (p_rec.information31 = hr_api.g_varchar2) then
1042 p_rec.information31 :=
1043 ghr_pah_shd.g_old_rec.information31;
1044 End If;
1045 If (p_rec.information32 = hr_api.g_varchar2) then
1046 p_rec.information32 :=
1047 ghr_pah_shd.g_old_rec.information32;
1048 End If;
1049 If (p_rec.information33 = hr_api.g_varchar2) then
1050 p_rec.information33 :=
1051 ghr_pah_shd.g_old_rec.information33;
1052 End If;
1053 If (p_rec.information34 = hr_api.g_varchar2) then
1054 p_rec.information34 :=
1055 ghr_pah_shd.g_old_rec.information34;
1056 End If;
1057 If (p_rec.information35 = hr_api.g_varchar2) then
1058 p_rec.information35 :=
1059 ghr_pah_shd.g_old_rec.information35;
1060 End If;
1061 If (p_rec.information36 = hr_api.g_varchar2) then
1062 p_rec.information36 :=
1063 ghr_pah_shd.g_old_rec.information36;
1064 End If;
1065 If (p_rec.information37 = hr_api.g_varchar2) then
1066 p_rec.information37 :=
1067 ghr_pah_shd.g_old_rec.information37;
1068 End If;
1069 If (p_rec.information38 = hr_api.g_varchar2) then
1070 p_rec.information38 :=
1071 ghr_pah_shd.g_old_rec.information38;
1072 End If;
1073 If (p_rec.information39 = hr_api.g_varchar2) then
1074 p_rec.information39 :=
1075 ghr_pah_shd.g_old_rec.information39;
1076 End If;
1077 If (p_rec.information47 = hr_api.g_varchar2) then
1078 p_rec.information47 :=
1079 ghr_pah_shd.g_old_rec.information47;
1080 End If;
1081 If (p_rec.information48 = hr_api.g_varchar2) then
1082 p_rec.information48 :=
1083 ghr_pah_shd.g_old_rec.information48;
1084 End If;
1085 If (p_rec.information49 = hr_api.g_varchar2) then
1086 p_rec.information49 :=
1087 ghr_pah_shd.g_old_rec.information49;
1088 End If;
1089 If (p_rec.information40 = hr_api.g_varchar2) then
1090 p_rec.information40 :=
1091 ghr_pah_shd.g_old_rec.information40;
1092 End If;
1093 If (p_rec.information41 = hr_api.g_varchar2) then
1094 p_rec.information41 :=
1095 ghr_pah_shd.g_old_rec.information41;
1096 End If;
1097 If (p_rec.information42 = hr_api.g_varchar2) then
1098 p_rec.information42 :=
1099 ghr_pah_shd.g_old_rec.information42;
1100 End If;
1101 If (p_rec.information43 = hr_api.g_varchar2) then
1102 p_rec.information43 :=
1103 ghr_pah_shd.g_old_rec.information43;
1104 End If;
1105 If (p_rec.information44 = hr_api.g_varchar2) then
1106 p_rec.information44 :=
1107 ghr_pah_shd.g_old_rec.information44;
1108 End If;
1109 If (p_rec.information45 = hr_api.g_varchar2) then
1110 p_rec.information45 :=
1111 ghr_pah_shd.g_old_rec.information45;
1112 End If;
1113 If (p_rec.information46 = hr_api.g_varchar2) then
1114 p_rec.information46 :=
1115 ghr_pah_shd.g_old_rec.information46;
1116 End If;
1117 If (p_rec.information50 = hr_api.g_varchar2) then
1118 p_rec.information50 :=
1119 ghr_pah_shd.g_old_rec.information50;
1120 End If;
1121 If (p_rec.information51 = hr_api.g_varchar2) then
1122 p_rec.information51 :=
1123 ghr_pah_shd.g_old_rec.information51;
1124 End If;
1125 If (p_rec.information52 = hr_api.g_varchar2) then
1126 p_rec.information52 :=
1127 ghr_pah_shd.g_old_rec.information52;
1128 End If;
1129 If (p_rec.information53 = hr_api.g_varchar2) then
1130 p_rec.information53 :=
1131 ghr_pah_shd.g_old_rec.information53;
1132 End If;
1133 If (p_rec.information54 = hr_api.g_varchar2) then
1134 p_rec.information54 :=
1135 ghr_pah_shd.g_old_rec.information54;
1136 End If;
1137 If (p_rec.information55 = hr_api.g_varchar2) then
1138 p_rec.information55 :=
1139 ghr_pah_shd.g_old_rec.information55;
1140 End If;
1141 If (p_rec.information56 = hr_api.g_varchar2) then
1142 p_rec.information56 :=
1143 ghr_pah_shd.g_old_rec.information56;
1144 End If;
1145 If (p_rec.information57 = hr_api.g_varchar2) then
1146 p_rec.information57 :=
1147 ghr_pah_shd.g_old_rec.information57;
1148 End If;
1149 If (p_rec.information58 = hr_api.g_varchar2) then
1150 p_rec.information58 :=
1151 ghr_pah_shd.g_old_rec.information58;
1152 End If;
1153 If (p_rec.information59 = hr_api.g_varchar2) then
1154 p_rec.information59 :=
1155 ghr_pah_shd.g_old_rec.information59;
1156 End If;
1157 If (p_rec.information60 = hr_api.g_varchar2) then
1158 p_rec.information60 :=
1159 ghr_pah_shd.g_old_rec.information60;
1160 End If;
1161 If (p_rec.information61 = hr_api.g_varchar2) then
1162 p_rec.information61 :=
1163 ghr_pah_shd.g_old_rec.information61;
1164 End If;
1165 If (p_rec.information62 = hr_api.g_varchar2) then
1166 p_rec.information62 :=
1167 ghr_pah_shd.g_old_rec.information62;
1168 End If;
1169 If (p_rec.information63 = hr_api.g_varchar2) then
1170 p_rec.information63 :=
1171 ghr_pah_shd.g_old_rec.information63;
1172 End If;
1173 If (p_rec.information64 = hr_api.g_varchar2) then
1174 p_rec.information64 :=
1175 ghr_pah_shd.g_old_rec.information64;
1176 End If;
1177 If (p_rec.information65 = hr_api.g_varchar2) then
1178 p_rec.information65 :=
1179 ghr_pah_shd.g_old_rec.information65;
1180 End If;
1181 If (p_rec.information66 = hr_api.g_varchar2) then
1182 p_rec.information66 :=
1183 ghr_pah_shd.g_old_rec.information66;
1184 End If;
1185 If (p_rec.information67 = hr_api.g_varchar2) then
1186 p_rec.information67 :=
1187 ghr_pah_shd.g_old_rec.information67;
1188 End If;
1189 If (p_rec.information68 = hr_api.g_varchar2) then
1190 p_rec.information68 :=
1191 ghr_pah_shd.g_old_rec.information68;
1192 End If;
1193 If (p_rec.information69 = hr_api.g_varchar2) then
1194 p_rec.information69 :=
1195 ghr_pah_shd.g_old_rec.information69;
1196 End If;
1197 If (p_rec.information70 = hr_api.g_varchar2) then
1198 p_rec.information70 :=
1199 ghr_pah_shd.g_old_rec.information70;
1200 End If;
1201 If (p_rec.information71 = hr_api.g_varchar2) then
1202 p_rec.information71 :=
1203 ghr_pah_shd.g_old_rec.information71;
1204 End If;
1205 If (p_rec.information72 = hr_api.g_varchar2) then
1206 p_rec.information72 :=
1207 ghr_pah_shd.g_old_rec.information72;
1208 End If;
1209 If (p_rec.information73 = hr_api.g_varchar2) then
1210 p_rec.information73 :=
1211 ghr_pah_shd.g_old_rec.information73;
1212 End If;
1213 If (p_rec.information74 = hr_api.g_varchar2) then
1214 p_rec.information74 :=
1215 ghr_pah_shd.g_old_rec.information74;
1216 End If;
1217 If (p_rec.information75 = hr_api.g_varchar2) then
1218 p_rec.information75 :=
1219 ghr_pah_shd.g_old_rec.information75;
1220 End If;
1221 If (p_rec.information76 = hr_api.g_varchar2) then
1222 p_rec.information76 :=
1223 ghr_pah_shd.g_old_rec.information76;
1224 End If;
1225 If (p_rec.information77 = hr_api.g_varchar2) then
1226 p_rec.information77 :=
1227 ghr_pah_shd.g_old_rec.information77;
1228 End If;
1229 If (p_rec.information78 = hr_api.g_varchar2) then
1230 p_rec.information78 :=
1231 ghr_pah_shd.g_old_rec.information78;
1232 End If;
1233 If (p_rec.information79 = hr_api.g_varchar2) then
1234 p_rec.information79 :=
1235 ghr_pah_shd.g_old_rec.information79;
1236 End If;
1237 If (p_rec.information80 = hr_api.g_varchar2) then
1238 p_rec.information80 :=
1239 ghr_pah_shd.g_old_rec.information80;
1240 End If;
1241 If (p_rec.information81 = hr_api.g_varchar2) then
1242 p_rec.information81 :=
1243 ghr_pah_shd.g_old_rec.information81;
1244 End If;
1245 If (p_rec.information82 = hr_api.g_varchar2) then
1246 p_rec.information82 :=
1247 ghr_pah_shd.g_old_rec.information82;
1248 End If;
1249 If (p_rec.information83 = hr_api.g_varchar2) then
1250 p_rec.information83 :=
1251 ghr_pah_shd.g_old_rec.information83;
1252 End If;
1253 If (p_rec.information84 = hr_api.g_varchar2) then
1254 p_rec.information84 :=
1255 ghr_pah_shd.g_old_rec.information84;
1256 End If;
1257 If (p_rec.information85 = hr_api.g_varchar2) then
1258 p_rec.information85 :=
1259 ghr_pah_shd.g_old_rec.information85;
1260 End If;
1261 If (p_rec.information86 = hr_api.g_varchar2) then
1262 p_rec.information86 :=
1263 ghr_pah_shd.g_old_rec.information86;
1264 End If;
1265 If (p_rec.information87 = hr_api.g_varchar2) then
1266 p_rec.information87 :=
1267 ghr_pah_shd.g_old_rec.information87;
1268 End If;
1269 If (p_rec.information88 = hr_api.g_varchar2) then
1270 p_rec.information88 :=
1271 ghr_pah_shd.g_old_rec.information88;
1272 End If;
1273 If (p_rec.information89 = hr_api.g_varchar2) then
1274 p_rec.information89 :=
1275 ghr_pah_shd.g_old_rec.information89;
1276 End If;
1277 If (p_rec.information90 = hr_api.g_varchar2) then
1278 p_rec.information90 :=
1279 ghr_pah_shd.g_old_rec.information90;
1280 End If;
1281 If (p_rec.information91 = hr_api.g_varchar2) then
1282 p_rec.information91 :=
1283 ghr_pah_shd.g_old_rec.information91;
1284 End If;
1285 If (p_rec.information92 = hr_api.g_varchar2) then
1286 p_rec.information92 :=
1287 ghr_pah_shd.g_old_rec.information92;
1288 End If;
1289 If (p_rec.information93 = hr_api.g_varchar2) then
1290 p_rec.information93 :=
1291 ghr_pah_shd.g_old_rec.information93;
1292 End If;
1293 If (p_rec.information94 = hr_api.g_varchar2) then
1294 p_rec.information94 :=
1295 ghr_pah_shd.g_old_rec.information94;
1296 End If;
1297 If (p_rec.information95 = hr_api.g_varchar2) then
1298 p_rec.information95 :=
1299 ghr_pah_shd.g_old_rec.information95;
1300 End If;
1301 If (p_rec.information96 = hr_api.g_varchar2) then
1302 p_rec.information96 :=
1303 ghr_pah_shd.g_old_rec.information96;
1304 End If;
1305 If (p_rec.information97 = hr_api.g_varchar2) then
1306 p_rec.information97 :=
1307 ghr_pah_shd.g_old_rec.information97;
1308 End If;
1309 If (p_rec.information98 = hr_api.g_varchar2) then
1310 p_rec.information98 :=
1311 ghr_pah_shd.g_old_rec.information98;
1312 End If;
1313 If (p_rec.information99 = hr_api.g_varchar2) then
1314 p_rec.information99 :=
1315 ghr_pah_shd.g_old_rec.information99;
1316 End If;
1317 If (p_rec.information100 = hr_api.g_varchar2) then
1318 p_rec.information100 :=
1319 ghr_pah_shd.g_old_rec.information100;
1320 End If;
1321 If (p_rec.information101 = hr_api.g_varchar2) then
1322 p_rec.information101 :=
1323 ghr_pah_shd.g_old_rec.information101;
1324 End If;
1325 If (p_rec.information102 = hr_api.g_varchar2) then
1326 p_rec.information102 :=
1327 ghr_pah_shd.g_old_rec.information102;
1328 End If;
1329 If (p_rec.information103 = hr_api.g_varchar2) then
1330 p_rec.information103 :=
1331 ghr_pah_shd.g_old_rec.information103;
1332 End If;
1333 If (p_rec.information104 = hr_api.g_varchar2) then
1334 p_rec.information104 :=
1335 ghr_pah_shd.g_old_rec.information104;
1336 End If;
1337 If (p_rec.information105 = hr_api.g_varchar2) then
1338 p_rec.information105 :=
1339 ghr_pah_shd.g_old_rec.information105;
1340 End If;
1341 If (p_rec.information106 = hr_api.g_varchar2) then
1342 p_rec.information106 :=
1343 ghr_pah_shd.g_old_rec.information106;
1344 End If;
1345 If (p_rec.information107 = hr_api.g_varchar2) then
1346 p_rec.information107 :=
1347 ghr_pah_shd.g_old_rec.information107;
1348 End If;
1349 If (p_rec.information108 = hr_api.g_varchar2) then
1350 p_rec.information108 :=
1351 ghr_pah_shd.g_old_rec.information108;
1352 End If;
1353 If (p_rec.information109 = hr_api.g_varchar2) then
1354 p_rec.information109 :=
1355 ghr_pah_shd.g_old_rec.information109;
1356 End If;
1357 If (p_rec.information110 = hr_api.g_varchar2) then
1358 p_rec.information110 :=
1359 ghr_pah_shd.g_old_rec.information110;
1360 End If;
1361 If (p_rec.information111 = hr_api.g_varchar2) then
1362 p_rec.information111 :=
1363 ghr_pah_shd.g_old_rec.information111;
1364 End If;
1365 If (p_rec.information112 = hr_api.g_varchar2) then
1366 p_rec.information112 :=
1367 ghr_pah_shd.g_old_rec.information112;
1368 End If;
1369 If (p_rec.information113 = hr_api.g_varchar2) then
1370 p_rec.information113 :=
1371 ghr_pah_shd.g_old_rec.information113;
1372 End If;
1373 If (p_rec.information114 = hr_api.g_varchar2) then
1374 p_rec.information114 :=
1375 ghr_pah_shd.g_old_rec.information114;
1376 End If;
1377 If (p_rec.information115 = hr_api.g_varchar2) then
1378 p_rec.information115 :=
1379 ghr_pah_shd.g_old_rec.information115;
1380 End If;
1381 If (p_rec.information116 = hr_api.g_varchar2) then
1382 p_rec.information116 :=
1383 ghr_pah_shd.g_old_rec.information116;
1384 End If;
1385 If (p_rec.information117 = hr_api.g_varchar2) then
1386 p_rec.information117 :=
1387 ghr_pah_shd.g_old_rec.information117;
1388 End If;
1389 If (p_rec.information118 = hr_api.g_varchar2) then
1390 p_rec.information118 :=
1391 ghr_pah_shd.g_old_rec.information118;
1392 End If;
1393 If (p_rec.information119 = hr_api.g_varchar2) then
1394 p_rec.information119 :=
1395 ghr_pah_shd.g_old_rec.information119;
1396 End If;
1397 If (p_rec.information120 = hr_api.g_varchar2) then
1398 p_rec.information120 :=
1399 ghr_pah_shd.g_old_rec.information120;
1400 End If;
1401 If (p_rec.information121 = hr_api.g_varchar2) then
1402 p_rec.information121 :=
1403 ghr_pah_shd.g_old_rec.information121;
1404 End If;
1405 If (p_rec.information122 = hr_api.g_varchar2) then
1406 p_rec.information122 :=
1407 ghr_pah_shd.g_old_rec.information122;
1408 End If;
1409 If (p_rec.information123 = hr_api.g_varchar2) then
1410 p_rec.information123 :=
1411 ghr_pah_shd.g_old_rec.information123;
1412 End If;
1413 If (p_rec.information124 = hr_api.g_varchar2) then
1414 p_rec.information124 :=
1415 ghr_pah_shd.g_old_rec.information124;
1416 End If;
1417 If (p_rec.information125 = hr_api.g_varchar2) then
1418 p_rec.information125 :=
1419 ghr_pah_shd.g_old_rec.information125;
1420 End If;
1421 If (p_rec.information126 = hr_api.g_varchar2) then
1422 p_rec.information126 :=
1423 ghr_pah_shd.g_old_rec.information126;
1424 End If;
1425 If (p_rec.information127 = hr_api.g_varchar2) then
1426 p_rec.information127 :=
1427 ghr_pah_shd.g_old_rec.information127;
1428 End If;
1429 If (p_rec.information128 = hr_api.g_varchar2) then
1430 p_rec.information128 :=
1431 ghr_pah_shd.g_old_rec.information128;
1432 End If;
1433 If (p_rec.information129 = hr_api.g_varchar2) then
1434 p_rec.information129 :=
1435 ghr_pah_shd.g_old_rec.information129;
1436 End If;
1437 If (p_rec.information130 = hr_api.g_varchar2) then
1438 p_rec.information130 :=
1439 ghr_pah_shd.g_old_rec.information130;
1440 End If;
1441 If (p_rec.information131 = hr_api.g_varchar2) then
1442 p_rec.information131 :=
1443 ghr_pah_shd.g_old_rec.information131;
1444 End If;
1445 If (p_rec.information132 = hr_api.g_varchar2) then
1446 p_rec.information132 :=
1447 ghr_pah_shd.g_old_rec.information132;
1448 End If;
1449 If (p_rec.information133 = hr_api.g_varchar2) then
1450 p_rec.information133 :=
1451 ghr_pah_shd.g_old_rec.information133;
1452 End If;
1453 If (p_rec.information134 = hr_api.g_varchar2) then
1454 p_rec.information134 :=
1455 ghr_pah_shd.g_old_rec.information134;
1456 End If;
1457 If (p_rec.information135 = hr_api.g_varchar2) then
1458 p_rec.information135 :=
1459 ghr_pah_shd.g_old_rec.information135;
1460 End If;
1461 If (p_rec.information136 = hr_api.g_varchar2) then
1462 p_rec.information136 :=
1463 ghr_pah_shd.g_old_rec.information136;
1464 End If;
1465 If (p_rec.information137 = hr_api.g_varchar2) then
1466 p_rec.information137 :=
1467 ghr_pah_shd.g_old_rec.information137;
1468 End If;
1469 If (p_rec.information138 = hr_api.g_varchar2) then
1470 p_rec.information138 :=
1471 ghr_pah_shd.g_old_rec.information138;
1472 End If;
1473 If (p_rec.information139 = hr_api.g_varchar2) then
1474 p_rec.information139 :=
1475 ghr_pah_shd.g_old_rec.information139;
1476 End If;
1477 If (p_rec.information140 = hr_api.g_varchar2) then
1478 p_rec.information140 :=
1479 ghr_pah_shd.g_old_rec.information140;
1480 End If;
1481 If (p_rec.information141 = hr_api.g_varchar2) then
1482 p_rec.information141 :=
1483 ghr_pah_shd.g_old_rec.information141;
1484 End If;
1485 If (p_rec.information142 = hr_api.g_varchar2) then
1486 p_rec.information142 :=
1487 ghr_pah_shd.g_old_rec.information142;
1488 End If;
1489 If (p_rec.information143 = hr_api.g_varchar2) then
1490 p_rec.information143 :=
1491 ghr_pah_shd.g_old_rec.information143;
1492 End If;
1493 If (p_rec.information144 = hr_api.g_varchar2) then
1494 p_rec.information144 :=
1495 ghr_pah_shd.g_old_rec.information144;
1496 End If;
1497 If (p_rec.information145 = hr_api.g_varchar2) then
1498 p_rec.information145 :=
1499 ghr_pah_shd.g_old_rec.information145;
1500 End If;
1501 If (p_rec.information146 = hr_api.g_varchar2) then
1502 p_rec.information146 :=
1503 ghr_pah_shd.g_old_rec.information146;
1504 End If;
1505 If (p_rec.information147 = hr_api.g_varchar2) then
1506 p_rec.information147 :=
1507 ghr_pah_shd.g_old_rec.information147;
1508 End If;
1509 If (p_rec.information148 = hr_api.g_varchar2) then
1510 p_rec.information148 :=
1511 ghr_pah_shd.g_old_rec.information148;
1512 End If;
1513 If (p_rec.information149 = hr_api.g_varchar2) then
1514 p_rec.information149 :=
1515 ghr_pah_shd.g_old_rec.information149;
1516 End If;
1517 If (p_rec.information150 = hr_api.g_varchar2) then
1518 p_rec.information150 :=
1519 ghr_pah_shd.g_old_rec.information150;
1520 End If;
1521 If (p_rec.information151 = hr_api.g_varchar2) then
1522 p_rec.information151 :=
1523 ghr_pah_shd.g_old_rec.information151;
1524 End If;
1525 If (p_rec.information152 = hr_api.g_varchar2) then
1526 p_rec.information152 :=
1527 ghr_pah_shd.g_old_rec.information152;
1528 End If;
1529 If (p_rec.information153 = hr_api.g_varchar2) then
1530 p_rec.information153 :=
1531 ghr_pah_shd.g_old_rec.information153;
1532 End If;
1533 If (p_rec.information154 = hr_api.g_varchar2) then
1534 p_rec.information154 :=
1535 ghr_pah_shd.g_old_rec.information154;
1536 End If;
1537 If (p_rec.information155 = hr_api.g_varchar2) then
1538 p_rec.information155 :=
1539 ghr_pah_shd.g_old_rec.information155;
1540 End If;
1541 If (p_rec.information156 = hr_api.g_varchar2) then
1542 p_rec.information156 :=
1543 ghr_pah_shd.g_old_rec.information156;
1544 End If;
1545 If (p_rec.information157 = hr_api.g_varchar2) then
1546 p_rec.information157 :=
1547 ghr_pah_shd.g_old_rec.information157;
1548 End If;
1549 If (p_rec.information158 = hr_api.g_varchar2) then
1550 p_rec.information158 :=
1551 ghr_pah_shd.g_old_rec.information158;
1552 End If;
1553 If (p_rec.information159 = hr_api.g_varchar2) then
1554 p_rec.information159 :=
1555 ghr_pah_shd.g_old_rec.information159;
1556 End If;
1557 If (p_rec.information160 = hr_api.g_varchar2) then
1558 p_rec.information160 :=
1559 ghr_pah_shd.g_old_rec.information160;
1560 End If;
1561 If (p_rec.information161 = hr_api.g_varchar2) then
1562 p_rec.information161 :=
1563 ghr_pah_shd.g_old_rec.information161;
1564 End If;
1565 If (p_rec.information162 = hr_api.g_varchar2) then
1566 p_rec.information162 :=
1567 ghr_pah_shd.g_old_rec.information162;
1568 End If;
1569 If (p_rec.information163 = hr_api.g_varchar2) then
1570 p_rec.information163 :=
1571 ghr_pah_shd.g_old_rec.information163;
1572 End If;
1573 If (p_rec.information164 = hr_api.g_varchar2) then
1574 p_rec.information164 :=
1575 ghr_pah_shd.g_old_rec.information164;
1576 End If;
1577 If (p_rec.information165 = hr_api.g_varchar2) then
1578 p_rec.information165 :=
1579 ghr_pah_shd.g_old_rec.information165;
1580 End If;
1581 If (p_rec.information166 = hr_api.g_varchar2) then
1582 p_rec.information166 :=
1583 ghr_pah_shd.g_old_rec.information166;
1584 End If;
1585 If (p_rec.information167 = hr_api.g_varchar2) then
1586 p_rec.information167 :=
1587 ghr_pah_shd.g_old_rec.information167;
1588 End If;
1589 If (p_rec.information168 = hr_api.g_varchar2) then
1590 p_rec.information168 :=
1591 ghr_pah_shd.g_old_rec.information168;
1592 End If;
1593 If (p_rec.information169 = hr_api.g_varchar2) then
1594 p_rec.information169 :=
1595 ghr_pah_shd.g_old_rec.information169;
1596 End If;
1597 If (p_rec.information170 = hr_api.g_varchar2) then
1598 p_rec.information170 :=
1599 ghr_pah_shd.g_old_rec.information170;
1600 End If;
1601 If (p_rec.information171 = hr_api.g_varchar2) then
1602 p_rec.information171 :=
1603 ghr_pah_shd.g_old_rec.information171;
1604 End If;
1605 If (p_rec.information172 = hr_api.g_varchar2) then
1606 p_rec.information172 :=
1607 ghr_pah_shd.g_old_rec.information172;
1608 End If;
1609 If (p_rec.information173 = hr_api.g_varchar2) then
1610 p_rec.information173 :=
1611 ghr_pah_shd.g_old_rec.information173;
1612 End If;
1613 If (p_rec.information174 = hr_api.g_varchar2) then
1614 p_rec.information174 :=
1615 ghr_pah_shd.g_old_rec.information174;
1616 End If;
1617 If (p_rec.information175 = hr_api.g_varchar2) then
1618 p_rec.information175 :=
1619 ghr_pah_shd.g_old_rec.information175;
1620 End If;
1621 If (p_rec.information176 = hr_api.g_varchar2) then
1622 p_rec.information176 :=
1623 ghr_pah_shd.g_old_rec.information176;
1624 End If;
1625 If (p_rec.information177 = hr_api.g_varchar2) then
1626 p_rec.information177 :=
1627 ghr_pah_shd.g_old_rec.information177;
1628 End If;
1629 If (p_rec.information178 = hr_api.g_varchar2) then
1630 p_rec.information178 :=
1631 ghr_pah_shd.g_old_rec.information178;
1632 End If;
1633 If (p_rec.information179 = hr_api.g_varchar2) then
1634 p_rec.information179 :=
1635 ghr_pah_shd.g_old_rec.information179;
1636 End If;
1637 If (p_rec.information180 = hr_api.g_varchar2) then
1638 p_rec.information180 :=
1639 ghr_pah_shd.g_old_rec.information180;
1640 End If;
1641 If (p_rec.information181 = hr_api.g_varchar2) then
1642 p_rec.information181 :=
1643 ghr_pah_shd.g_old_rec.information181;
1644 End If;
1645 If (p_rec.information182 = hr_api.g_varchar2) then
1646 p_rec.information182 :=
1647 ghr_pah_shd.g_old_rec.information182;
1648 End If;
1649 If (p_rec.information183 = hr_api.g_varchar2) then
1650 p_rec.information183 :=
1651 ghr_pah_shd.g_old_rec.information183;
1652 End If;
1653 If (p_rec.information184 = hr_api.g_varchar2) then
1654 p_rec.information184 :=
1655 ghr_pah_shd.g_old_rec.information184;
1656 End If;
1657 If (p_rec.information185 = hr_api.g_varchar2) then
1658 p_rec.information185 :=
1659 ghr_pah_shd.g_old_rec.information185;
1660 End If;
1661 If (p_rec.information186 = hr_api.g_varchar2) then
1662 p_rec.information186 :=
1663 ghr_pah_shd.g_old_rec.information186;
1664 End If;
1665 If (p_rec.information187 = hr_api.g_varchar2) then
1666 p_rec.information187 :=
1667 ghr_pah_shd.g_old_rec.information187;
1668 End If;
1669 If (p_rec.information188 = hr_api.g_varchar2) then
1670 p_rec.information188 :=
1671 ghr_pah_shd.g_old_rec.information188;
1672 End If;
1673 If (p_rec.information189 = hr_api.g_varchar2) then
1674 p_rec.information189 :=
1675 ghr_pah_shd.g_old_rec.information189;
1676 End If;
1677 If (p_rec.information190 = hr_api.g_varchar2) then
1678 p_rec.information190 :=
1679 ghr_pah_shd.g_old_rec.information190;
1680 End If;
1681 If (p_rec.information191 = hr_api.g_varchar2) then
1682 p_rec.information191 :=
1683 ghr_pah_shd.g_old_rec.information191;
1684 End If;
1685 If (p_rec.information192 = hr_api.g_varchar2) then
1686 p_rec.information192 :=
1687 ghr_pah_shd.g_old_rec.information192;
1688 End If;
1689 If (p_rec.information193 = hr_api.g_varchar2) then
1690 p_rec.information193 :=
1691 ghr_pah_shd.g_old_rec.information193;
1692 End If;
1693 If (p_rec.information194 = hr_api.g_varchar2) then
1694 p_rec.information194 :=
1695 ghr_pah_shd.g_old_rec.information194;
1696 End If;
1697 If (p_rec.information195 = hr_api.g_varchar2) then
1698 p_rec.information195 :=
1699 ghr_pah_shd.g_old_rec.information195;
1700 End If;
1701 If (p_rec.information196 = hr_api.g_varchar2) then
1702 p_rec.information196 :=
1703 ghr_pah_shd.g_old_rec.information196;
1704 End If;
1705 If (p_rec.information197 = hr_api.g_varchar2) then
1706 p_rec.information197 :=
1707 ghr_pah_shd.g_old_rec.information197;
1708 End If;
1709 If (p_rec.information198 = hr_api.g_varchar2) then
1710 p_rec.information198 :=
1711 ghr_pah_shd.g_old_rec.information198;
1712 End If;
1713 If (p_rec.information199 = hr_api.g_varchar2) then
1714 p_rec.information199 :=
1715 ghr_pah_shd.g_old_rec.information199;
1716 End If;
1717 If (p_rec.information200 = hr_api.g_varchar2) then
1718 p_rec.information200 :=
1719 ghr_pah_shd.g_old_rec.information200;
1720 End If;
1721 --
1722 hr_utility.set_location(' Leaving:'||l_proc, 10);
1723 --
1724 End convert_defs;
1725 --
1726 -- ----------------------------------------------------------------------------
1727 -- |---------------------------------< upd >----------------------------------|
1728 -- ----------------------------------------------------------------------------
1729 Procedure upd
1730 (
1731 p_rec in out nocopy ghr_pah_shd.g_rec_type
1732 ) is
1733 --
1734 l_proc varchar2(72) := g_package||'upd';
1735 --
1736 Begin
1737 hr_utility.set_location('Entering:'||l_proc, 5);
1738 --
1739 -- We must lock the row which we need to update.
1740 --
1741 ghr_pah_shd.lck
1742 (
1743 p_rec.pa_history_id
1744 );
1745 --
1746 -- 1. During an update system defaults are used to determine if
1747 -- arguments have been defaulted or not. We must therefore
1748 -- derive the full record structure values to be updated.
1749 --
1750 -- 2. Call the supporting update validate operations.
1751 --
1752 convert_defs(p_rec);
1753 ghr_pah_bus.update_validate(p_rec);
1754 --
1755 -- Call the supporting pre-update operation
1756 --
1757 pre_update(p_rec);
1758 --
1759 -- Update the row.
1760 --
1761 update_dml(p_rec);
1762 --
1763 -- Call the supporting post-update operation
1764 --
1765 post_update(p_rec);
1766 End upd;
1767 --
1768 -- ----------------------------------------------------------------------------
1769 -- |---------------------------------< upd >----------------------------------|
1770 -- ----------------------------------------------------------------------------
1771 Procedure upd
1772 (
1773 p_pa_history_id in number,
1774 p_pa_request_id in number default hr_api.g_number,
1775 p_process_date in date default hr_api.g_date,
1776 p_nature_of_action_id in number default hr_api.g_number,
1777 p_effective_date in date default hr_api.g_date,
1778 p_altered_pa_request_id in number default hr_api.g_number,
1779 p_person_id in number default hr_api.g_number,
1780 p_assignment_id in number default hr_api.g_number,
1781 p_dml_operation in varchar2 default hr_api.g_varchar2,
1782 p_table_name in varchar2 default hr_api.g_varchar2,
1783 p_pre_values_flag in varchar2 default hr_api.g_varchar2,
1784 p_information1 in varchar2 default hr_api.g_varchar2,
1785 p_information2 in varchar2 default hr_api.g_varchar2,
1786 p_information3 in varchar2 default hr_api.g_varchar2,
1787 p_information4 in varchar2 default hr_api.g_varchar2,
1788 p_information5 in varchar2 default hr_api.g_varchar2,
1789 p_information6 in varchar2 default hr_api.g_varchar2,
1790 p_information7 in varchar2 default hr_api.g_varchar2,
1791 p_information8 in varchar2 default hr_api.g_varchar2,
1792 p_information9 in varchar2 default hr_api.g_varchar2,
1793 p_information10 in varchar2 default hr_api.g_varchar2,
1794 p_information11 in varchar2 default hr_api.g_varchar2,
1795 p_information12 in varchar2 default hr_api.g_varchar2,
1796 p_information13 in varchar2 default hr_api.g_varchar2,
1797 p_information14 in varchar2 default hr_api.g_varchar2,
1798 p_information15 in varchar2 default hr_api.g_varchar2,
1799 p_information16 in varchar2 default hr_api.g_varchar2,
1800 p_information17 in varchar2 default hr_api.g_varchar2,
1801 p_information18 in varchar2 default hr_api.g_varchar2,
1802 p_information19 in varchar2 default hr_api.g_varchar2,
1803 p_information20 in varchar2 default hr_api.g_varchar2,
1804 p_information21 in varchar2 default hr_api.g_varchar2,
1805 p_information22 in varchar2 default hr_api.g_varchar2,
1806 p_information23 in varchar2 default hr_api.g_varchar2,
1807 p_information24 in varchar2 default hr_api.g_varchar2,
1808 p_information25 in varchar2 default hr_api.g_varchar2,
1809 p_information26 in varchar2 default hr_api.g_varchar2,
1810 p_information27 in varchar2 default hr_api.g_varchar2,
1811 p_information28 in varchar2 default hr_api.g_varchar2,
1812 p_information29 in varchar2 default hr_api.g_varchar2,
1813 p_information30 in varchar2 default hr_api.g_varchar2,
1814 p_information31 in varchar2 default hr_api.g_varchar2,
1815 p_information32 in varchar2 default hr_api.g_varchar2,
1816 p_information33 in varchar2 default hr_api.g_varchar2,
1817 p_information34 in varchar2 default hr_api.g_varchar2,
1818 p_information35 in varchar2 default hr_api.g_varchar2,
1819 p_information36 in varchar2 default hr_api.g_varchar2,
1820 p_information37 in varchar2 default hr_api.g_varchar2,
1821 p_information38 in varchar2 default hr_api.g_varchar2,
1822 p_information39 in varchar2 default hr_api.g_varchar2,
1823 p_information47 in varchar2 default hr_api.g_varchar2,
1824 p_information48 in varchar2 default hr_api.g_varchar2,
1825 p_information49 in varchar2 default hr_api.g_varchar2,
1826 p_information40 in varchar2 default hr_api.g_varchar2,
1827 p_information41 in varchar2 default hr_api.g_varchar2,
1828 p_information42 in varchar2 default hr_api.g_varchar2,
1829 p_information43 in varchar2 default hr_api.g_varchar2,
1830 p_information44 in varchar2 default hr_api.g_varchar2,
1831 p_information45 in varchar2 default hr_api.g_varchar2,
1832 p_information46 in varchar2 default hr_api.g_varchar2,
1833 p_information50 in varchar2 default hr_api.g_varchar2,
1834 p_information51 in varchar2 default hr_api.g_varchar2,
1835 p_information52 in varchar2 default hr_api.g_varchar2,
1836 p_information53 in varchar2 default hr_api.g_varchar2,
1837 p_information54 in varchar2 default hr_api.g_varchar2,
1838 p_information55 in varchar2 default hr_api.g_varchar2,
1839 p_information56 in varchar2 default hr_api.g_varchar2,
1840 p_information57 in varchar2 default hr_api.g_varchar2,
1841 p_information58 in varchar2 default hr_api.g_varchar2,
1842 p_information59 in varchar2 default hr_api.g_varchar2,
1843 p_information60 in varchar2 default hr_api.g_varchar2,
1844 p_information61 in varchar2 default hr_api.g_varchar2,
1845 p_information62 in varchar2 default hr_api.g_varchar2,
1846 p_information63 in varchar2 default hr_api.g_varchar2,
1847 p_information64 in varchar2 default hr_api.g_varchar2,
1848 p_information65 in varchar2 default hr_api.g_varchar2,
1849 p_information66 in varchar2 default hr_api.g_varchar2,
1850 p_information67 in varchar2 default hr_api.g_varchar2,
1851 p_information68 in varchar2 default hr_api.g_varchar2,
1852 p_information69 in varchar2 default hr_api.g_varchar2,
1853 p_information70 in varchar2 default hr_api.g_varchar2,
1854 p_information71 in varchar2 default hr_api.g_varchar2,
1855 p_information72 in varchar2 default hr_api.g_varchar2,
1856 p_information73 in varchar2 default hr_api.g_varchar2,
1857 p_information74 in varchar2 default hr_api.g_varchar2,
1858 p_information75 in varchar2 default hr_api.g_varchar2,
1859 p_information76 in varchar2 default hr_api.g_varchar2,
1860 p_information77 in varchar2 default hr_api.g_varchar2,
1861 p_information78 in varchar2 default hr_api.g_varchar2,
1862 p_information79 in varchar2 default hr_api.g_varchar2,
1863 p_information80 in varchar2 default hr_api.g_varchar2,
1864 p_information81 in varchar2 default hr_api.g_varchar2,
1865 p_information82 in varchar2 default hr_api.g_varchar2,
1866 p_information83 in varchar2 default hr_api.g_varchar2,
1867 p_information84 in varchar2 default hr_api.g_varchar2,
1868 p_information85 in varchar2 default hr_api.g_varchar2,
1869 p_information86 in varchar2 default hr_api.g_varchar2,
1870 p_information87 in varchar2 default hr_api.g_varchar2,
1871 p_information88 in varchar2 default hr_api.g_varchar2,
1872 p_information89 in varchar2 default hr_api.g_varchar2,
1873 p_information90 in varchar2 default hr_api.g_varchar2,
1874 p_information91 in varchar2 default hr_api.g_varchar2,
1875 p_information92 in varchar2 default hr_api.g_varchar2,
1876 p_information93 in varchar2 default hr_api.g_varchar2,
1877 p_information94 in varchar2 default hr_api.g_varchar2,
1878 p_information95 in varchar2 default hr_api.g_varchar2,
1879 p_information96 in varchar2 default hr_api.g_varchar2,
1880 p_information97 in varchar2 default hr_api.g_varchar2,
1881 p_information98 in varchar2 default hr_api.g_varchar2,
1882 p_information99 in varchar2 default hr_api.g_varchar2,
1883 p_information100 in varchar2 default hr_api.g_varchar2,
1884 p_information101 in varchar2 default hr_api.g_varchar2,
1885 p_information102 in varchar2 default hr_api.g_varchar2,
1886 p_information103 in varchar2 default hr_api.g_varchar2,
1887 p_information104 in varchar2 default hr_api.g_varchar2,
1888 p_information105 in varchar2 default hr_api.g_varchar2,
1889 p_information106 in varchar2 default hr_api.g_varchar2,
1890 p_information107 in varchar2 default hr_api.g_varchar2,
1891 p_information108 in varchar2 default hr_api.g_varchar2,
1892 p_information109 in varchar2 default hr_api.g_varchar2,
1893 p_information110 in varchar2 default hr_api.g_varchar2,
1894 p_information111 in varchar2 default hr_api.g_varchar2,
1895 p_information112 in varchar2 default hr_api.g_varchar2,
1896 p_information113 in varchar2 default hr_api.g_varchar2,
1897 p_information114 in varchar2 default hr_api.g_varchar2,
1898 p_information115 in varchar2 default hr_api.g_varchar2,
1899 p_information116 in varchar2 default hr_api.g_varchar2,
1900 p_information117 in varchar2 default hr_api.g_varchar2,
1901 p_information118 in varchar2 default hr_api.g_varchar2,
1902 p_information119 in varchar2 default hr_api.g_varchar2,
1903 p_information120 in varchar2 default hr_api.g_varchar2,
1904 p_information121 in varchar2 default hr_api.g_varchar2,
1905 p_information122 in varchar2 default hr_api.g_varchar2,
1906 p_information123 in varchar2 default hr_api.g_varchar2,
1907 p_information124 in varchar2 default hr_api.g_varchar2,
1908 p_information125 in varchar2 default hr_api.g_varchar2,
1909 p_information126 in varchar2 default hr_api.g_varchar2,
1910 p_information127 in varchar2 default hr_api.g_varchar2,
1911 p_information128 in varchar2 default hr_api.g_varchar2,
1912 p_information129 in varchar2 default hr_api.g_varchar2,
1913 p_information130 in varchar2 default hr_api.g_varchar2,
1914 p_information131 in varchar2 default hr_api.g_varchar2,
1915 p_information132 in varchar2 default hr_api.g_varchar2,
1916 p_information133 in varchar2 default hr_api.g_varchar2,
1917 p_information134 in varchar2 default hr_api.g_varchar2,
1918 p_information135 in varchar2 default hr_api.g_varchar2,
1919 p_information136 in varchar2 default hr_api.g_varchar2,
1920 p_information137 in varchar2 default hr_api.g_varchar2,
1921 p_information138 in varchar2 default hr_api.g_varchar2,
1922 p_information139 in varchar2 default hr_api.g_varchar2,
1923 p_information140 in varchar2 default hr_api.g_varchar2,
1924 p_information141 in varchar2 default hr_api.g_varchar2,
1925 p_information142 in varchar2 default hr_api.g_varchar2,
1926 p_information143 in varchar2 default hr_api.g_varchar2,
1927 p_information144 in varchar2 default hr_api.g_varchar2,
1928 p_information145 in varchar2 default hr_api.g_varchar2,
1929 p_information146 in varchar2 default hr_api.g_varchar2,
1930 p_information147 in varchar2 default hr_api.g_varchar2,
1931 p_information148 in varchar2 default hr_api.g_varchar2,
1932 p_information149 in varchar2 default hr_api.g_varchar2,
1933 p_information150 in varchar2 default hr_api.g_varchar2,
1934 p_information151 in varchar2 default hr_api.g_varchar2,
1935 p_information152 in varchar2 default hr_api.g_varchar2,
1936 p_information153 in varchar2 default hr_api.g_varchar2,
1937 p_information154 in varchar2 default hr_api.g_varchar2,
1938 p_information155 in varchar2 default hr_api.g_varchar2,
1939 p_information156 in varchar2 default hr_api.g_varchar2,
1940 p_information157 in varchar2 default hr_api.g_varchar2,
1941 p_information158 in varchar2 default hr_api.g_varchar2,
1942 p_information159 in varchar2 default hr_api.g_varchar2,
1943 p_information160 in varchar2 default hr_api.g_varchar2,
1944 p_information161 in varchar2 default hr_api.g_varchar2,
1945 p_information162 in varchar2 default hr_api.g_varchar2,
1946 p_information163 in varchar2 default hr_api.g_varchar2,
1947 p_information164 in varchar2 default hr_api.g_varchar2,
1948 p_information165 in varchar2 default hr_api.g_varchar2,
1949 p_information166 in varchar2 default hr_api.g_varchar2,
1950 p_information167 in varchar2 default hr_api.g_varchar2,
1951 p_information168 in varchar2 default hr_api.g_varchar2,
1952 p_information169 in varchar2 default hr_api.g_varchar2,
1953 p_information170 in varchar2 default hr_api.g_varchar2,
1954 p_information171 in varchar2 default hr_api.g_varchar2,
1955 p_information172 in varchar2 default hr_api.g_varchar2,
1956 p_information173 in varchar2 default hr_api.g_varchar2,
1957 p_information174 in varchar2 default hr_api.g_varchar2,
1958 p_information175 in varchar2 default hr_api.g_varchar2,
1959 p_information176 in varchar2 default hr_api.g_varchar2,
1960 p_information177 in varchar2 default hr_api.g_varchar2,
1961 p_information178 in varchar2 default hr_api.g_varchar2,
1962 p_information179 in varchar2 default hr_api.g_varchar2,
1963 p_information180 in varchar2 default hr_api.g_varchar2,
1964 p_information181 in varchar2 default hr_api.g_varchar2,
1965 p_information182 in varchar2 default hr_api.g_varchar2,
1966 p_information183 in varchar2 default hr_api.g_varchar2,
1967 p_information184 in varchar2 default hr_api.g_varchar2,
1968 p_information185 in varchar2 default hr_api.g_varchar2,
1969 p_information186 in varchar2 default hr_api.g_varchar2,
1970 p_information187 in varchar2 default hr_api.g_varchar2,
1971 p_information188 in varchar2 default hr_api.g_varchar2,
1972 p_information189 in varchar2 default hr_api.g_varchar2,
1973 p_information190 in varchar2 default hr_api.g_varchar2,
1974 p_information191 in varchar2 default hr_api.g_varchar2,
1975 p_information192 in varchar2 default hr_api.g_varchar2,
1976 p_information193 in varchar2 default hr_api.g_varchar2,
1977 p_information194 in varchar2 default hr_api.g_varchar2,
1978 p_information195 in varchar2 default hr_api.g_varchar2,
1979 p_information196 in varchar2 default hr_api.g_varchar2,
1980 p_information197 in varchar2 default hr_api.g_varchar2,
1981 p_information198 in varchar2 default hr_api.g_varchar2,
1982 p_information199 in varchar2 default hr_api.g_varchar2,
1983 p_information200 in varchar2 default hr_api.g_varchar2
1984 ) is
1985 --
1986 l_rec ghr_pah_shd.g_rec_type;
1987 l_proc varchar2(72) := g_package||'upd';
1988 --
1989 Begin
1990 hr_utility.set_location('Entering:'||l_proc, 5);
1991 --
1992 -- Call conversion function to turn arguments into the
1993 -- l_rec structure.
1994 --
1995 l_rec :=
1996 ghr_pah_shd.convert_args
1997 (
1998 p_pa_history_id,
1999 p_pa_request_id,
2000 p_process_date,
2001 p_nature_of_action_id,
2002 p_effective_date,
2003 p_altered_pa_request_id,
2004 p_person_id,
2005 p_assignment_id,
2006 p_dml_operation,
2007 p_table_name,
2008 p_pre_values_flag,
2009 p_information1,
2010 p_information2,
2011 p_information3,
2012 p_information4,
2013 p_information5,
2014 p_information6,
2015 p_information7,
2016 p_information8,
2017 p_information9,
2018 p_information10,
2019 p_information11,
2020 p_information12,
2021 p_information13,
2022 p_information14,
2023 p_information15,
2024 p_information16,
2025 p_information17,
2026 p_information18,
2027 p_information19,
2028 p_information20,
2029 p_information21,
2030 p_information22,
2031 p_information23,
2032 p_information24,
2033 p_information25,
2034 p_information26,
2035 p_information27,
2036 p_information28,
2037 p_information29,
2038 p_information30,
2039 p_information31,
2040 p_information32,
2041 p_information33,
2042 p_information34,
2043 p_information35,
2044 p_information36,
2045 p_information37,
2046 p_information38,
2047 p_information39,
2048 p_information47,
2049 p_information48,
2050 p_information49,
2051 p_information40,
2052 p_information41,
2053 p_information42,
2054 p_information43,
2055 p_information44,
2056 p_information45,
2057 p_information46,
2058 p_information50,
2059 p_information51,
2060 p_information52,
2061 p_information53,
2062 p_information54,
2063 p_information55,
2064 p_information56,
2065 p_information57,
2066 p_information58,
2067 p_information59,
2068 p_information60,
2069 p_information61,
2070 p_information62,
2071 p_information63,
2072 p_information64,
2073 p_information65,
2074 p_information66,
2075 p_information67,
2076 p_information68,
2077 p_information69,
2078 p_information70,
2079 p_information71,
2080 p_information72,
2081 p_information73,
2082 p_information74,
2083 p_information75,
2084 p_information76,
2085 p_information77,
2086 p_information78,
2087 p_information79,
2088 p_information80,
2089 p_information81,
2090 p_information82,
2091 p_information83,
2092 p_information84,
2093 p_information85,
2094 p_information86,
2095 p_information87,
2096 p_information88,
2097 p_information89,
2098 p_information90,
2099 p_information91,
2100 p_information92,
2101 p_information93,
2102 p_information94,
2103 p_information95,
2104 p_information96,
2105 p_information97,
2106 p_information98,
2107 p_information99,
2108 p_information100,
2109 p_information101,
2110 p_information102,
2111 p_information103,
2112 p_information104,
2113 p_information105,
2114 p_information106,
2115 p_information107,
2116 p_information108,
2117 p_information109,
2118 p_information110,
2119 p_information111,
2120 p_information112,
2121 p_information113,
2122 p_information114,
2123 p_information115,
2124 p_information116,
2125 p_information117,
2126 p_information118,
2127 p_information119,
2128 p_information120,
2129 p_information121,
2130 p_information122,
2131 p_information123,
2132 p_information124,
2133 p_information125,
2134 p_information126,
2135 p_information127,
2136 p_information128,
2137 p_information129,
2138 p_information130,
2139 p_information131,
2140 p_information132,
2141 p_information133,
2142 p_information134,
2143 p_information135,
2144 p_information136,
2145 p_information137,
2146 p_information138,
2147 p_information139,
2148 p_information140,
2149 p_information141,
2150 p_information142,
2151 p_information143,
2152 p_information144,
2153 p_information145,
2154 p_information146,
2155 p_information147,
2156 p_information148,
2157 p_information149,
2158 p_information150,
2159 p_information151,
2160 p_information152,
2161 p_information153,
2162 p_information154,
2163 p_information155,
2164 p_information156,
2165 p_information157,
2166 p_information158,
2167 p_information159,
2168 p_information160,
2169 p_information161,
2170 p_information162,
2171 p_information163,
2172 p_information164,
2173 p_information165,
2174 p_information166,
2175 p_information167,
2176 p_information168,
2177 p_information169,
2178 p_information170,
2179 p_information171,
2180 p_information172,
2181 p_information173,
2182 p_information174,
2183 p_information175,
2184 p_information176,
2185 p_information177,
2186 p_information178,
2187 p_information179,
2188 p_information180,
2189 p_information181,
2190 p_information182,
2191 p_information183,
2192 p_information184,
2193 p_information185,
2194 p_information186,
2195 p_information187,
2196 p_information188,
2197 p_information189,
2198 p_information190,
2199 p_information191,
2200 p_information192,
2201 p_information193,
2202 p_information194,
2203 p_information195,
2204 p_information196,
2205 p_information197,
2206 p_information198,
2207 p_information199,
2208 p_information200
2209 );
2210 --
2211 -- Having converted the arguments into the
2212 -- plsql record structure we call the corresponding record
2213 -- business process.
2214 --
2215 upd(l_rec);
2216 --
2217 --
2218 hr_utility.set_location(' Leaving:'||l_proc, 10);
2219 End upd;
2220 --
2221 end ghr_pah_upd;