[Home] [Help]
PACKAGE BODY: APPS.GHR_PAH_INS
Source
1 Package Body ghr_pah_ins 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_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic. The processing of
17 -- this procedure are as follows:
18 -- 1) Initialise the object_version_number to 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 insert the row into the schema.
23 -- 4) To trap any constraint violations that may have occurred.
24 -- 5) To raise any other errors.
25 --
26 -- Prerequisites:
27 -- This is an internal private procedure which must be called from the ins
28 -- procedure and must have all mandatory attributes set (except the
29 -- object_version_number which is initialised within this procedure).
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be inserted into the schema.
36 --
37 -- Post Failure:
38 -- On the insert 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 -- None.
47 --
48 -- Access Status:
49 -- Internal Row Handler Use Only.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 Procedure insert_dml(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
54 --
55 l_proc varchar2(72) := g_package||'insert_dml';
56 --
57 Begin
58 hr_utility.set_location('Entering:'||l_proc, 5);
59 --
60 --
61 ghr_pah_shd.g_api_dml := true; -- Set the api dml status
62 --
63 -- Insert the row into: ghr_pa_history
64 --
65 insert into ghr_pa_history
66 ( pa_history_id,
67 pa_request_id,
68 process_date,
69 nature_of_action_id,
70 effective_date,
71 altered_pa_request_id,
72 person_id,
73 assignment_id,
74 dml_operation,
75 table_name,
76 pre_values_flag,
77 information1,
78 information2,
79 information3,
80 information4,
81 information5,
82 information6,
83 information7,
84 information8,
85 information9,
86 information10,
87 information11,
88 information12,
89 information13,
90 information14,
91 information15,
92 information16,
93 information17,
94 information18,
95 information19,
96 information20,
97 information21,
98 information22,
99 information23,
100 information24,
101 information25,
102 information26,
103 information27,
104 information28,
105 information29,
106 information30,
107 information31,
108 information32,
109 information33,
110 information34,
111 information35,
112 information36,
113 information37,
114 information38,
115 information39,
116 information47,
117 information48,
118 information49,
119 information40,
120 information41,
121 information42,
122 information43,
123 information44,
124 information45,
125 information46,
126 information50,
127 information51,
128 information52,
129 information53,
130 information54,
131 information55,
132 information56,
133 information57,
134 information58,
135 information59,
136 information60,
137 information61,
138 information62,
139 information63,
140 information64,
141 information65,
142 information66,
143 information67,
144 information68,
145 information69,
146 information70,
147 information71,
148 information72,
149 information73,
150 information74,
151 information75,
152 information76,
153 information77,
154 information78,
155 information79,
156 information80,
157 information81,
158 information82,
159 information83,
160 information84,
161 information85,
162 information86,
163 information87,
164 information88,
165 information89,
166 information90,
167 information91,
168 information92,
169 information93,
170 information94,
171 information95,
172 information96,
173 information97,
174 information98,
175 information99,
176 information100,
177 information101,
178 information102,
179 information103,
180 information104,
181 information105,
182 information106,
183 information107,
184 information108,
185 information109,
186 information110,
187 information111,
188 information112,
189 information113,
190 information114,
191 information115,
192 information116,
193 information117,
194 information118,
195 information119,
196 information120,
197 information121,
198 information122,
199 information123,
200 information124,
201 information125,
202 information126,
203 information127,
204 information128,
205 information129,
206 information130,
207 information131,
208 information132,
209 information133,
210 information134,
211 information135,
212 information136,
213 information137,
214 information138,
215 information139,
216 information140,
217 information141,
218 information142,
219 information143,
220 information144,
221 information145,
222 information146,
223 information147,
224 information148,
225 information149,
226 information150,
227 information151,
228 information152,
229 information153,
230 information154,
231 information155,
232 information156,
233 information157,
234 information158,
235 information159,
236 information160,
237 information161,
238 information162,
239 information163,
240 information164,
241 information165,
242 information166,
243 information167,
244 information168,
245 information169,
246 information170,
247 information171,
248 information172,
249 information173,
250 information174,
251 information175,
252 information176,
253 information177,
254 information178,
255 information179,
256 information180,
257 information181,
258 information182,
259 information183,
260 information184,
261 information185,
262 information186,
263 information187,
264 information188,
265 information189,
266 information190,
267 information191,
268 information192,
269 information193,
270 information194,
271 information195,
272 information196,
273 information197,
274 information198,
275 information199,
276 information200
277 )
278 Values
279 ( p_rec.pa_history_id,
280 p_rec.pa_request_id,
281 p_rec.process_date,
282 p_rec.nature_of_action_id,
283 p_rec.effective_date,
284 p_rec.altered_pa_request_id,
285 p_rec.person_id,
286 p_rec.assignment_id,
287 p_rec.dml_operation,
288 p_rec.table_name,
289 p_rec.pre_values_flag,
290 p_rec.information1,
291 p_rec.information2,
292 p_rec.information3,
293 p_rec.information4,
294 p_rec.information5,
295 p_rec.information6,
296 p_rec.information7,
297 p_rec.information8,
298 p_rec.information9,
299 p_rec.information10,
300 p_rec.information11,
301 p_rec.information12,
302 p_rec.information13,
303 p_rec.information14,
304 p_rec.information15,
305 p_rec.information16,
306 p_rec.information17,
307 p_rec.information18,
308 p_rec.information19,
309 p_rec.information20,
310 p_rec.information21,
311 p_rec.information22,
312 p_rec.information23,
313 p_rec.information24,
314 p_rec.information25,
315 p_rec.information26,
316 p_rec.information27,
317 p_rec.information28,
318 p_rec.information29,
319 p_rec.information30,
320 p_rec.information31,
321 p_rec.information32,
322 p_rec.information33,
323 p_rec.information34,
324 p_rec.information35,
325 p_rec.information36,
326 p_rec.information37,
327 p_rec.information38,
328 p_rec.information39,
329 p_rec.information47,
330 p_rec.information48,
331 p_rec.information49,
332 p_rec.information40,
333 p_rec.information41,
334 p_rec.information42,
335 p_rec.information43,
336 p_rec.information44,
337 p_rec.information45,
338 p_rec.information46,
339 p_rec.information50,
340 p_rec.information51,
341 p_rec.information52,
342 p_rec.information53,
343 p_rec.information54,
344 p_rec.information55,
345 p_rec.information56,
346 p_rec.information57,
347 p_rec.information58,
348 p_rec.information59,
349 p_rec.information60,
350 p_rec.information61,
351 p_rec.information62,
352 p_rec.information63,
353 p_rec.information64,
354 p_rec.information65,
355 p_rec.information66,
356 p_rec.information67,
357 p_rec.information68,
358 p_rec.information69,
359 p_rec.information70,
360 p_rec.information71,
361 p_rec.information72,
362 p_rec.information73,
363 p_rec.information74,
364 p_rec.information75,
365 p_rec.information76,
366 p_rec.information77,
367 p_rec.information78,
368 p_rec.information79,
369 p_rec.information80,
370 p_rec.information81,
371 p_rec.information82,
372 p_rec.information83,
373 p_rec.information84,
374 p_rec.information85,
375 p_rec.information86,
376 p_rec.information87,
377 p_rec.information88,
378 p_rec.information89,
379 p_rec.information90,
380 p_rec.information91,
381 p_rec.information92,
382 p_rec.information93,
383 p_rec.information94,
384 p_rec.information95,
385 p_rec.information96,
386 p_rec.information97,
387 p_rec.information98,
388 p_rec.information99,
389 p_rec.information100,
390 p_rec.information101,
391 p_rec.information102,
392 p_rec.information103,
393 p_rec.information104,
394 p_rec.information105,
395 p_rec.information106,
396 p_rec.information107,
397 p_rec.information108,
398 p_rec.information109,
399 p_rec.information110,
400 p_rec.information111,
401 p_rec.information112,
402 p_rec.information113,
403 p_rec.information114,
404 p_rec.information115,
405 p_rec.information116,
406 p_rec.information117,
407 p_rec.information118,
408 p_rec.information119,
409 p_rec.information120,
410 p_rec.information121,
411 p_rec.information122,
412 p_rec.information123,
413 p_rec.information124,
414 p_rec.information125,
415 p_rec.information126,
416 p_rec.information127,
417 p_rec.information128,
418 p_rec.information129,
419 p_rec.information130,
420 p_rec.information131,
421 p_rec.information132,
422 p_rec.information133,
423 p_rec.information134,
424 p_rec.information135,
425 p_rec.information136,
426 p_rec.information137,
427 p_rec.information138,
428 p_rec.information139,
429 p_rec.information140,
430 p_rec.information141,
431 p_rec.information142,
432 p_rec.information143,
433 p_rec.information144,
434 p_rec.information145,
435 p_rec.information146,
436 p_rec.information147,
437 p_rec.information148,
438 p_rec.information149,
439 p_rec.information150,
440 p_rec.information151,
441 p_rec.information152,
442 p_rec.information153,
443 p_rec.information154,
444 p_rec.information155,
445 p_rec.information156,
446 p_rec.information157,
447 p_rec.information158,
448 p_rec.information159,
449 p_rec.information160,
450 p_rec.information161,
451 p_rec.information162,
452 p_rec.information163,
453 p_rec.information164,
454 p_rec.information165,
455 p_rec.information166,
456 p_rec.information167,
457 p_rec.information168,
458 p_rec.information169,
459 p_rec.information170,
460 p_rec.information171,
461 p_rec.information172,
462 p_rec.information173,
463 p_rec.information174,
464 p_rec.information175,
465 p_rec.information176,
466 p_rec.information177,
467 p_rec.information178,
468 p_rec.information179,
469 p_rec.information180,
470 p_rec.information181,
471 p_rec.information182,
472 p_rec.information183,
473 p_rec.information184,
474 p_rec.information185,
475 p_rec.information186,
476 p_rec.information187,
477 p_rec.information188,
478 p_rec.information189,
479 p_rec.information190,
480 p_rec.information191,
481 p_rec.information192,
482 p_rec.information193,
483 p_rec.information194,
484 p_rec.information195,
485 p_rec.information196,
486 p_rec.information197,
487 p_rec.information198,
488 p_rec.information199,
489 p_rec.information200
490 );
491 --
492 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
493 --
494 hr_utility.set_location(' Leaving:'||l_proc, 10);
495 Exception
496 When hr_api.check_integrity_violated Then
497 -- A check constraint has been violated
498 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499 ghr_pah_shd.constraint_error
500 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501 When hr_api.parent_integrity_violated Then
502 -- Parent integrity has been violated
503 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504 ghr_pah_shd.constraint_error
505 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506 When hr_api.unique_integrity_violated Then
507 -- Unique integrity has been violated
508 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509 ghr_pah_shd.constraint_error
510 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
511 When Others Then
512 ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
513 Raise;
514 End insert_dml;
515 --
516 -- ----------------------------------------------------------------------------
517 -- |------------------------------< pre_insert >------------------------------|
518 -- ----------------------------------------------------------------------------
519 -- {Start Of Comments}
520 --
521 -- Description:
522 -- This private procedure contains any processing which is required before
523 -- the insert dml. Presently, if the entity has a corresponding primary
524 -- key which is maintained by an associating sequence, the primary key for
525 -- the entity will be populated with the next sequence value in
526 -- preparation for the insert dml.
527 --
528 -- Prerequisites:
529 -- This is an internal procedure which is called from the ins procedure.
530 --
531 -- In Parameters:
532 -- A Pl/Sql record structre.
533 --
534 -- Post Success:
535 -- Processing continues.
536 --
537 -- Post Failure:
538 -- If an error has occurred, an error message and exception will be raised
539 -- but not handled.
540 --
541 -- Developer Implementation Notes:
542 -- Any pre-processing required before the insert dml is issued should be
543 -- coded within this procedure. As stated above, a good example is the
544 -- generation of a primary key number via a corresponding sequence.
545 -- It is important to note that any 3rd party maintenance should be reviewed
546 -- before placing in this procedure.
547 --
548 -- Access Status:
549 -- Internal Row Handler Use Only.
550 --
551 -- {End Of Comments}
552 -- ----------------------------------------------------------------------------
553 Procedure pre_insert(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
554 --
555 l_proc varchar2(72) := g_package||'pre_insert';
556 --
557 Cursor C_Sel1 is select ghr_pa_history_s.nextval from sys.dual;
558 --
559 Begin
560 hr_utility.set_location('Entering:'||l_proc, 5);
561 --
562 --
563 -- Select the next sequence number
564 --
565 Open C_Sel1;
566 Fetch C_Sel1 Into p_rec.pa_history_id;
567 Close C_Sel1;
568 --
569 hr_utility.set_location(' Leaving:'||l_proc, 10);
570 End pre_insert;
571 --
572 -- ----------------------------------------------------------------------------
573 -- |-----------------------------< post_insert >------------------------------|
574 -- ----------------------------------------------------------------------------
575 -- {Start Of Comments}
576 --
577 -- Description:
578 -- This private procedure contains any processing which is required after the
579 -- insert dml.
580 --
581 -- Prerequisites:
582 -- This is an internal procedure which is called from the ins procedure.
583 --
584 -- In Parameters:
585 -- A Pl/Sql record structre.
586 --
587 -- Post Success:
588 -- Processing continues.
589 --
590 -- Post Failure:
591 -- If an error has occurred, an error message and exception will be raised
592 -- but not handled.
593 --
594 -- Developer Implementation Notes:
595 -- Any post-processing required after the insert dml is issued should be
596 -- coded within this procedure. It is important to note that any 3rd party
597 -- maintenance should be reviewed before placing in this procedure.
598 --
599 -- Access Status:
600 -- Internal Row Handler Use Only.
601 --
602 -- {End Of Comments}
603 -- ----------------------------------------------------------------------------
604 Procedure post_insert(p_rec in ghr_pah_shd.g_rec_type) is
605 --
606 l_proc varchar2(72) := g_package||'post_insert';
607 --
608 Begin
609 hr_utility.set_location('Entering:'||l_proc, 5);
610 --
611 -- This is a hook point and the user hook for post_insert is called here.
612 --
613 begin
614 ghr_pah_rki.after_insert (
615 p_PA_HISTORY_ID => p_rec.PA_HISTORY_ID ,
616 p_PA_REQUEST_ID => p_rec.PA_REQUEST_ID ,
617 p_PROCESS_DATE => p_rec.PROCESS_DATE ,
618 p_NATURE_OF_ACTION_ID => p_rec.NATURE_OF_ACTION_ID ,
619 p_EFFECTIVE_DATE => p_rec.EFFECTIVE_DATE ,
620 p_ALTERED_PA_REQUEST_ID => p_rec.ALTERED_PA_REQUEST_ID ,
621 p_PERSON_ID => p_rec.PERSON_ID ,
622 p_ASSIGNMENT_ID => p_rec.ASSIGNMENT_ID ,
623 p_DML_OPERATION => p_rec.DML_OPERATION ,
624 p_TABLE_NAME => p_rec.TABLE_NAME ,
625 p_PRE_VALUES_FLAG => p_rec.PRE_VALUES_FLAG ,
626 p_INFORMATION1 => p_rec.INFORMATION1 ,
627 p_INFORMATION2 => p_rec.INFORMATION2 ,
628 p_INFORMATION3 => p_rec.INFORMATION3 ,
629 p_INFORMATION4 => p_rec.INFORMATION4 ,
630 p_INFORMATION5 => p_rec.INFORMATION5 ,
631 p_INFORMATION6 => p_rec.INFORMATION6 ,
632 p_INFORMATION7 => p_rec.INFORMATION7 ,
633 p_INFORMATION8 => p_rec.INFORMATION8 ,
634 p_INFORMATION9 => p_rec.INFORMATION9 ,
635 p_INFORMATION10 => p_rec.INFORMATION10 ,
636 p_INFORMATION11 => p_rec.INFORMATION11 ,
637 p_INFORMATION12 => p_rec.INFORMATION12 ,
638 p_INFORMATION13 => p_rec.INFORMATION13 ,
639 p_INFORMATION14 => p_rec.INFORMATION14 ,
640 p_INFORMATION15 => p_rec.INFORMATION15 ,
641 p_INFORMATION16 => p_rec.INFORMATION16 ,
642 p_INFORMATION17 => p_rec.INFORMATION17 ,
643 p_INFORMATION18 => p_rec.INFORMATION18 ,
644 p_INFORMATION19 => p_rec.INFORMATION19 ,
645 p_INFORMATION20 => p_rec.INFORMATION20 ,
646 p_INFORMATION21 => p_rec.INFORMATION21 ,
647 p_INFORMATION22 => p_rec.INFORMATION22 ,
648 p_INFORMATION23 => p_rec.INFORMATION23 ,
649 p_INFORMATION24 => p_rec.INFORMATION24 ,
650 p_INFORMATION25 => p_rec.INFORMATION25 ,
651 p_INFORMATION26 => p_rec.INFORMATION26 ,
652 p_INFORMATION27 => p_rec.INFORMATION27 ,
653 p_INFORMATION28 => p_rec.INFORMATION28 ,
654 p_INFORMATION29 => p_rec.INFORMATION29 ,
655 p_INFORMATION30 => p_rec.INFORMATION30 ,
656 p_INFORMATION31 => p_rec.INFORMATION31 ,
657 p_INFORMATION32 => p_rec.INFORMATION32 ,
658 p_INFORMATION33 => p_rec.INFORMATION33 ,
659 p_INFORMATION34 => p_rec.INFORMATION34 ,
660 p_INFORMATION35 => p_rec.INFORMATION35 ,
661 p_INFORMATION36 => p_rec.INFORMATION36 ,
662 p_INFORMATION37 => p_rec.INFORMATION37 ,
663 p_INFORMATION38 => p_rec.INFORMATION38 ,
664 p_INFORMATION39 => p_rec.INFORMATION39 ,
665 p_INFORMATION47 => p_rec.INFORMATION47 ,
666 p_INFORMATION48 => p_rec.INFORMATION48 ,
667 p_INFORMATION49 => p_rec.INFORMATION49 ,
668 p_INFORMATION40 => p_rec.INFORMATION40 ,
669 p_INFORMATION41 => p_rec.INFORMATION41 ,
670 p_INFORMATION42 => p_rec.INFORMATION42 ,
671 p_INFORMATION43 => p_rec.INFORMATION43 ,
672 p_INFORMATION44 => p_rec.INFORMATION44 ,
673 p_INFORMATION45 => p_rec.INFORMATION45 ,
674 p_INFORMATION46 => p_rec.INFORMATION46 ,
675 p_INFORMATION50 => p_rec.INFORMATION50 ,
676 p_INFORMATION51 => p_rec.INFORMATION51 ,
677 p_INFORMATION52 => p_rec.INFORMATION52 ,
678 p_INFORMATION53 => p_rec.INFORMATION53 ,
679 p_INFORMATION54 => p_rec.INFORMATION54 ,
680 p_INFORMATION55 => p_rec.INFORMATION55 ,
681 p_INFORMATION56 => p_rec.INFORMATION56 ,
682 p_INFORMATION57 => p_rec.INFORMATION57 ,
683 p_INFORMATION58 => p_rec.INFORMATION58 ,
684 p_INFORMATION59 => p_rec.INFORMATION59 ,
685 p_INFORMATION60 => p_rec.INFORMATION60 ,
686 p_INFORMATION61 => p_rec.INFORMATION61 ,
687 p_INFORMATION62 => p_rec.INFORMATION62 ,
688 p_INFORMATION63 => p_rec.INFORMATION63 ,
689 p_INFORMATION64 => p_rec.INFORMATION64 ,
690 p_INFORMATION65 => p_rec.INFORMATION65 ,
691 p_INFORMATION66 => p_rec.INFORMATION66 ,
692 p_INFORMATION67 => p_rec.INFORMATION67 ,
693 p_INFORMATION68 => p_rec.INFORMATION68 ,
694 p_INFORMATION69 => p_rec.INFORMATION69 ,
695 p_INFORMATION70 => p_rec.INFORMATION70 ,
696 p_INFORMATION71 => p_rec.INFORMATION71 ,
697 p_INFORMATION72 => p_rec.INFORMATION72 ,
698 p_INFORMATION73 => p_rec.INFORMATION73 ,
699 p_INFORMATION74 => p_rec.INFORMATION74 ,
700 p_INFORMATION75 => p_rec.INFORMATION75 ,
701 p_INFORMATION76 => p_rec.INFORMATION76 ,
702 p_INFORMATION77 => p_rec.INFORMATION77 ,
703 p_INFORMATION78 => p_rec.INFORMATION78 ,
704 p_INFORMATION79 => p_rec.INFORMATION79 ,
705 p_INFORMATION80 => p_rec.INFORMATION80 ,
706 p_INFORMATION81 => p_rec.INFORMATION81 ,
707 p_INFORMATION82 => p_rec.INFORMATION82 ,
708 p_INFORMATION83 => p_rec.INFORMATION83 ,
709 p_INFORMATION84 => p_rec.INFORMATION84 ,
710 p_INFORMATION85 => p_rec.INFORMATION85 ,
711 p_INFORMATION86 => p_rec.INFORMATION86 ,
712 p_INFORMATION87 => p_rec.INFORMATION87 ,
713 p_INFORMATION88 => p_rec.INFORMATION88 ,
714 p_INFORMATION89 => p_rec.INFORMATION89 ,
715 p_INFORMATION90 => p_rec.INFORMATION90 ,
716 p_INFORMATION91 => p_rec.INFORMATION91 ,
717 p_INFORMATION92 => p_rec.INFORMATION92 ,
718 p_INFORMATION93 => p_rec.INFORMATION93 ,
719 p_INFORMATION94 => p_rec.INFORMATION94 ,
720 p_INFORMATION95 => p_rec.INFORMATION95 ,
721 p_INFORMATION96 => p_rec.INFORMATION96 ,
722 p_INFORMATION97 => p_rec.INFORMATION97 ,
723 p_INFORMATION98 => p_rec.INFORMATION98 ,
724 p_INFORMATION99 => p_rec.INFORMATION99 ,
725 p_INFORMATION100 => p_rec.INFORMATION100 ,
726 p_INFORMATION101 => p_rec.INFORMATION101 ,
727 p_INFORMATION102 => p_rec.INFORMATION102 ,
728 p_INFORMATION103 => p_rec.INFORMATION103 ,
729 p_INFORMATION104 => p_rec.INFORMATION104 ,
730 p_INFORMATION105 => p_rec.INFORMATION105 ,
731 p_INFORMATION106 => p_rec.INFORMATION106 ,
732 p_INFORMATION107 => p_rec.INFORMATION107 ,
733 p_INFORMATION108 => p_rec.INFORMATION108 ,
734 p_INFORMATION109 => p_rec.INFORMATION109 ,
735 p_INFORMATION110 => p_rec.INFORMATION110 ,
736 p_INFORMATION111 => p_rec.INFORMATION111 ,
737 p_INFORMATION112 => p_rec.INFORMATION112 ,
738 p_INFORMATION113 => p_rec.INFORMATION113 ,
739 p_INFORMATION114 => p_rec.INFORMATION114 ,
740 p_INFORMATION115 => p_rec.INFORMATION115 ,
741 p_INFORMATION116 => p_rec.INFORMATION116 ,
742 p_INFORMATION117 => p_rec.INFORMATION117 ,
743 p_INFORMATION118 => p_rec.INFORMATION118 ,
744 p_INFORMATION119 => p_rec.INFORMATION119 ,
745 p_INFORMATION120 => p_rec.INFORMATION120 ,
746 p_INFORMATION121 => p_rec.INFORMATION121 ,
747 p_INFORMATION122 => p_rec.INFORMATION122 ,
748 p_INFORMATION123 => p_rec.INFORMATION123 ,
749 p_INFORMATION124 => p_rec.INFORMATION124 ,
750 p_INFORMATION125 => p_rec.INFORMATION125 ,
751 p_INFORMATION126 => p_rec.INFORMATION126 ,
752 p_INFORMATION127 => p_rec.INFORMATION127 ,
753 p_INFORMATION128 => p_rec.INFORMATION128 ,
754 p_INFORMATION129 => p_rec.INFORMATION129 ,
755 p_INFORMATION130 => p_rec.INFORMATION130 ,
756 p_INFORMATION131 => p_rec.INFORMATION131 ,
757 p_INFORMATION132 => p_rec.INFORMATION132 ,
758 p_INFORMATION133 => p_rec.INFORMATION133 ,
759 p_INFORMATION134 => p_rec.INFORMATION134 ,
760 p_INFORMATION135 => p_rec.INFORMATION135 ,
761 p_INFORMATION136 => p_rec.INFORMATION136 ,
762 p_INFORMATION137 => p_rec.INFORMATION137 ,
763 p_INFORMATION138 => p_rec.INFORMATION138 ,
764 p_INFORMATION139 => p_rec.INFORMATION139 ,
765 p_INFORMATION140 => p_rec.INFORMATION140 ,
766 p_INFORMATION141 => p_rec.INFORMATION141 ,
767 p_INFORMATION142 => p_rec.INFORMATION142 ,
768 p_INFORMATION143 => p_rec.INFORMATION143 ,
769 p_INFORMATION144 => p_rec.INFORMATION144 ,
770 p_INFORMATION145 => p_rec.INFORMATION145 ,
771 p_INFORMATION146 => p_rec.INFORMATION146 ,
772 p_INFORMATION147 => p_rec.INFORMATION147 ,
773 p_INFORMATION148 => p_rec.INFORMATION148 ,
774 p_INFORMATION149 => p_rec.INFORMATION149 ,
775 p_INFORMATION150 => p_rec.INFORMATION150 ,
776 p_INFORMATION151 => p_rec.INFORMATION151 ,
777 p_INFORMATION152 => p_rec.INFORMATION152 ,
778 p_INFORMATION153 => p_rec.INFORMATION153 ,
779 p_INFORMATION154 => p_rec.INFORMATION154 ,
780 p_INFORMATION155 => p_rec.INFORMATION155 ,
781 p_INFORMATION156 => p_rec.INFORMATION156 ,
782 p_INFORMATION157 => p_rec.INFORMATION157 ,
783 p_INFORMATION158 => p_rec.INFORMATION158 ,
784 p_INFORMATION159 => p_rec.INFORMATION159 ,
785 p_INFORMATION160 => p_rec.INFORMATION160 ,
786 p_INFORMATION161 => p_rec.INFORMATION161 ,
787 p_INFORMATION162 => p_rec.INFORMATION162 ,
788 p_INFORMATION163 => p_rec.INFORMATION163 ,
789 p_INFORMATION164 => p_rec.INFORMATION164 ,
790 p_INFORMATION165 => p_rec.INFORMATION165 ,
791 p_INFORMATION166 => p_rec.INFORMATION166 ,
792 p_INFORMATION167 => p_rec.INFORMATION167 ,
793 p_INFORMATION168 => p_rec.INFORMATION168 ,
794 p_INFORMATION169 => p_rec.INFORMATION169 ,
795 p_INFORMATION170 => p_rec.INFORMATION170 ,
796 p_INFORMATION171 => p_rec.INFORMATION171 ,
797 p_INFORMATION172 => p_rec.INFORMATION172 ,
798 p_INFORMATION173 => p_rec.INFORMATION173 ,
799 p_INFORMATION174 => p_rec.INFORMATION174 ,
800 p_INFORMATION175 => p_rec.INFORMATION175 ,
801 p_INFORMATION176 => p_rec.INFORMATION176 ,
802 p_INFORMATION177 => p_rec.INFORMATION177 ,
803 p_INFORMATION178 => p_rec.INFORMATION178 ,
804 p_INFORMATION179 => p_rec.INFORMATION179 ,
805 p_INFORMATION180 => p_rec.INFORMATION180 ,
806 p_INFORMATION181 => p_rec.INFORMATION181 ,
807 p_INFORMATION182 => p_rec.INFORMATION182 ,
808 p_INFORMATION183 => p_rec.INFORMATION183 ,
809 p_INFORMATION184 => p_rec.INFORMATION184 ,
810 p_INFORMATION185 => p_rec.INFORMATION185 ,
811 p_INFORMATION186 => p_rec.INFORMATION186 ,
812 p_INFORMATION187 => p_rec.INFORMATION187 ,
813 p_INFORMATION188 => p_rec.INFORMATION188 ,
814 p_INFORMATION189 => p_rec.INFORMATION189 ,
815 p_INFORMATION190 => p_rec.INFORMATION190 ,
816 p_INFORMATION191 => p_rec.INFORMATION191 ,
817 p_INFORMATION192 => p_rec.INFORMATION192 ,
818 p_INFORMATION193 => p_rec.INFORMATION193 ,
819 p_INFORMATION194 => p_rec.INFORMATION194 ,
820 p_INFORMATION195 => p_rec.INFORMATION195 ,
821 p_INFORMATION196 => p_rec.INFORMATION196 ,
822 p_INFORMATION197 => p_rec.INFORMATION197 ,
823 p_INFORMATION198 => p_rec.INFORMATION198 ,
824 p_INFORMATION199 => p_rec.INFORMATION199 ,
825 p_INFORMATION200 => p_rec.INFORMATION200
826 );
827 exception
828 when hr_api.cannot_find_prog_unit then
829 hr_api.cannot_find_prog_unit_error
830 ( p_module_name => 'GHR_PA_HISTORY'
831 ,p_hook_type => 'AI'
832 );
833 end;
834 -- End of API User Hook for post_insert.
835
836 hr_utility.set_location(' Leaving:'||l_proc, 10);
837 End post_insert;
838 --
839 -- ----------------------------------------------------------------------------
840 -- |---------------------------------< ins >----------------------------------|
841 -- ----------------------------------------------------------------------------
842 Procedure ins
843 (
844 p_rec in out nocopy ghr_pah_shd.g_rec_type
845 ) is
846 --
847 l_proc varchar2(72) := g_package||'ins';
848 --
849 Begin
850 hr_utility.set_location('Entering:'||l_proc, 5);
851 --
852 -- Call the supporting insert validate operations
853 --
854 ghr_pah_bus.insert_validate(p_rec);
855 --
856 -- Call the supporting pre-insert operation
857 --
858 pre_insert(p_rec);
859 --
860 -- Insert the row
861 --
862 insert_dml(p_rec);
863 --
864 -- Call the supporting post-insert operation
865 --
866 post_insert(p_rec);
867 end ins;
868 --
869 -- ----------------------------------------------------------------------------
870 -- |---------------------------------< ins >----------------------------------|
871 -- ----------------------------------------------------------------------------
872 Procedure ins
873 (
874 p_pa_history_id out nocopy number,
875 p_pa_request_id in number default null,
876 p_process_date in date,
877 p_nature_of_action_id in number default null,
878 p_effective_date in date,
879 p_altered_pa_request_id in number default null,
880 p_person_id in number default null,
881 p_assignment_id in number default null,
882 p_dml_operation in varchar2 default null,
883 p_table_name in varchar2,
884 p_pre_values_flag in varchar2 default null,
885 p_information1 in varchar2 default null,
886 p_information2 in varchar2 default null,
887 p_information3 in varchar2 default null,
888 p_information4 in varchar2 default null,
889 p_information5 in varchar2 default null,
890 p_information6 in varchar2 default null,
891 p_information7 in varchar2 default null,
892 p_information8 in varchar2 default null,
893 p_information9 in varchar2 default null,
894 p_information10 in varchar2 default null,
895 p_information11 in varchar2 default null,
896 p_information12 in varchar2 default null,
897 p_information13 in varchar2 default null,
898 p_information14 in varchar2 default null,
899 p_information15 in varchar2 default null,
900 p_information16 in varchar2 default null,
901 p_information17 in varchar2 default null,
902 p_information18 in varchar2 default null,
903 p_information19 in varchar2 default null,
904 p_information20 in varchar2 default null,
905 p_information21 in varchar2 default null,
906 p_information22 in varchar2 default null,
907 p_information23 in varchar2 default null,
908 p_information24 in varchar2 default null,
909 p_information25 in varchar2 default null,
910 p_information26 in varchar2 default null,
911 p_information27 in varchar2 default null,
912 p_information28 in varchar2 default null,
913 p_information29 in varchar2 default null,
914 p_information30 in varchar2 default null,
915 p_information31 in varchar2 default null,
916 p_information32 in varchar2 default null,
917 p_information33 in varchar2 default null,
918 p_information34 in varchar2 default null,
919 p_information35 in varchar2 default null,
920 p_information36 in varchar2 default null,
921 p_information37 in varchar2 default null,
922 p_information38 in varchar2 default null,
923 p_information39 in varchar2 default null,
924 p_information47 in varchar2 default null,
925 p_information48 in varchar2 default null,
926 p_information49 in varchar2 default null,
927 p_information40 in varchar2 default null,
928 p_information41 in varchar2 default null,
929 p_information42 in varchar2 default null,
930 p_information43 in varchar2 default null,
931 p_information44 in varchar2 default null,
932 p_information45 in varchar2 default null,
933 p_information46 in varchar2 default null,
934 p_information50 in varchar2 default null,
935 p_information51 in varchar2 default null,
936 p_information52 in varchar2 default null,
937 p_information53 in varchar2 default null,
938 p_information54 in varchar2 default null,
939 p_information55 in varchar2 default null,
940 p_information56 in varchar2 default null,
941 p_information57 in varchar2 default null,
942 p_information58 in varchar2 default null,
943 p_information59 in varchar2 default null,
944 p_information60 in varchar2 default null,
945 p_information61 in varchar2 default null,
946 p_information62 in varchar2 default null,
947 p_information63 in varchar2 default null,
948 p_information64 in varchar2 default null,
949 p_information65 in varchar2 default null,
950 p_information66 in varchar2 default null,
951 p_information67 in varchar2 default null,
952 p_information68 in varchar2 default null,
953 p_information69 in varchar2 default null,
954 p_information70 in varchar2 default null,
955 p_information71 in varchar2 default null,
956 p_information72 in varchar2 default null,
957 p_information73 in varchar2 default null,
958 p_information74 in varchar2 default null,
959 p_information75 in varchar2 default null,
960 p_information76 in varchar2 default null,
961 p_information77 in varchar2 default null,
962 p_information78 in varchar2 default null,
963 p_information79 in varchar2 default null,
964 p_information80 in varchar2 default null,
965 p_information81 in varchar2 default null,
966 p_information82 in varchar2 default null,
967 p_information83 in varchar2 default null,
968 p_information84 in varchar2 default null,
969 p_information85 in varchar2 default null,
970 p_information86 in varchar2 default null,
971 p_information87 in varchar2 default null,
972 p_information88 in varchar2 default null,
973 p_information89 in varchar2 default null,
974 p_information90 in varchar2 default null,
975 p_information91 in varchar2 default null,
976 p_information92 in varchar2 default null,
977 p_information93 in varchar2 default null,
978 p_information94 in varchar2 default null,
979 p_information95 in varchar2 default null,
980 p_information96 in varchar2 default null,
981 p_information97 in varchar2 default null,
982 p_information98 in varchar2 default null,
983 p_information99 in varchar2 default null,
984 p_information100 in varchar2 default null,
985 p_information101 in varchar2 default null,
986 p_information102 in varchar2 default null,
987 p_information103 in varchar2 default null,
988 p_information104 in varchar2 default null,
989 p_information105 in varchar2 default null,
990 p_information106 in varchar2 default null,
991 p_information107 in varchar2 default null,
992 p_information108 in varchar2 default null,
993 p_information109 in varchar2 default null,
994 p_information110 in varchar2 default null,
995 p_information111 in varchar2 default null,
996 p_information112 in varchar2 default null,
997 p_information113 in varchar2 default null,
998 p_information114 in varchar2 default null,
999 p_information115 in varchar2 default null,
1000 p_information116 in varchar2 default null,
1001 p_information117 in varchar2 default null,
1005 p_information121 in varchar2 default null,
1002 p_information118 in varchar2 default null,
1003 p_information119 in varchar2 default null,
1004 p_information120 in varchar2 default null,
1006 p_information122 in varchar2 default null,
1007 p_information123 in varchar2 default null,
1008 p_information124 in varchar2 default null,
1009 p_information125 in varchar2 default null,
1010 p_information126 in varchar2 default null,
1011 p_information127 in varchar2 default null,
1012 p_information128 in varchar2 default null,
1013 p_information129 in varchar2 default null,
1014 p_information130 in varchar2 default null,
1015 p_information131 in varchar2 default null,
1016 p_information132 in varchar2 default null,
1017 p_information133 in varchar2 default null,
1018 p_information134 in varchar2 default null,
1019 p_information135 in varchar2 default null,
1020 p_information136 in varchar2 default null,
1021 p_information137 in varchar2 default null,
1022 p_information138 in varchar2 default null,
1023 p_information139 in varchar2 default null,
1024 p_information140 in varchar2 default null,
1025 p_information141 in varchar2 default null,
1026 p_information142 in varchar2 default null,
1027 p_information143 in varchar2 default null,
1028 p_information144 in varchar2 default null,
1029 p_information145 in varchar2 default null,
1030 p_information146 in varchar2 default null,
1031 p_information147 in varchar2 default null,
1032 p_information148 in varchar2 default null,
1033 p_information149 in varchar2 default null,
1034 p_information150 in varchar2 default null,
1035 p_information151 in varchar2 default null,
1036 p_information152 in varchar2 default null,
1037 p_information153 in varchar2 default null,
1038 p_information154 in varchar2 default null,
1039 p_information155 in varchar2 default null,
1040 p_information156 in varchar2 default null,
1041 p_information157 in varchar2 default null,
1042 p_information158 in varchar2 default null,
1043 p_information159 in varchar2 default null,
1044 p_information160 in varchar2 default null,
1045 p_information161 in varchar2 default null,
1046 p_information162 in varchar2 default null,
1047 p_information163 in varchar2 default null,
1048 p_information164 in varchar2 default null,
1049 p_information165 in varchar2 default null,
1050 p_information166 in varchar2 default null,
1051 p_information167 in varchar2 default null,
1052 p_information168 in varchar2 default null,
1053 p_information169 in varchar2 default null,
1054 p_information170 in varchar2 default null,
1055 p_information171 in varchar2 default null,
1056 p_information172 in varchar2 default null,
1057 p_information173 in varchar2 default null,
1058 p_information174 in varchar2 default null,
1059 p_information175 in varchar2 default null,
1060 p_information176 in varchar2 default null,
1061 p_information177 in varchar2 default null,
1062 p_information178 in varchar2 default null,
1063 p_information179 in varchar2 default null,
1064 p_information180 in varchar2 default null,
1065 p_information181 in varchar2 default null,
1066 p_information182 in varchar2 default null,
1067 p_information183 in varchar2 default null,
1068 p_information184 in varchar2 default null,
1069 p_information185 in varchar2 default null,
1070 p_information186 in varchar2 default null,
1071 p_information187 in varchar2 default null,
1072 p_information188 in varchar2 default null,
1073 p_information189 in varchar2 default null,
1074 p_information190 in varchar2 default null,
1075 p_information191 in varchar2 default null,
1076 p_information192 in varchar2 default null,
1077 p_information193 in varchar2 default null,
1078 p_information194 in varchar2 default null,
1079 p_information195 in varchar2 default null,
1080 p_information196 in varchar2 default null,
1081 p_information197 in varchar2 default null,
1082 p_information198 in varchar2 default null,
1083 p_information199 in varchar2 default null,
1084 p_information200 in varchar2 default null
1085 ) is
1086 --
1087 l_rec ghr_pah_shd.g_rec_type;
1088 l_proc varchar2(72) := g_package||'ins';
1089 --
1090 Begin
1091 hr_utility.set_location('Entering:'||l_proc, 5);
1092 --
1093 -- Call conversion function to turn arguments into the
1094 -- p_rec structure.
1095 --
1096 l_rec :=
1097 ghr_pah_shd.convert_args
1101 p_process_date,
1098 (
1099 null,
1100 p_pa_request_id,
1102 p_nature_of_action_id,
1103 p_effective_date,
1104 p_altered_pa_request_id,
1105 p_person_id,
1106 p_assignment_id,
1107 p_dml_operation,
1108 p_table_name,
1109 p_pre_values_flag,
1110 p_information1,
1111 p_information2,
1112 p_information3,
1113 p_information4,
1114 p_information5,
1115 p_information6,
1116 p_information7,
1117 p_information8,
1118 p_information9,
1119 p_information10,
1120 p_information11,
1121 p_information12,
1122 p_information13,
1123 p_information14,
1124 p_information15,
1125 p_information16,
1126 p_information17,
1127 p_information18,
1128 p_information19,
1129 p_information20,
1130 p_information21,
1131 p_information22,
1132 p_information23,
1133 p_information24,
1134 p_information25,
1135 p_information26,
1136 p_information27,
1137 p_information28,
1138 p_information29,
1139 p_information30,
1140 p_information31,
1141 p_information32,
1142 p_information33,
1143 p_information34,
1144 p_information35,
1145 p_information36,
1146 p_information37,
1147 p_information38,
1148 p_information39,
1149 p_information47,
1150 p_information48,
1151 p_information49,
1152 p_information40,
1153 p_information41,
1154 p_information42,
1155 p_information43,
1156 p_information44,
1157 p_information45,
1158 p_information46,
1159 p_information50,
1160 p_information51,
1161 p_information52,
1162 p_information53,
1163 p_information54,
1164 p_information55,
1165 p_information56,
1166 p_information57,
1167 p_information58,
1168 p_information59,
1169 p_information60,
1170 p_information61,
1171 p_information62,
1172 p_information63,
1173 p_information64,
1174 p_information65,
1175 p_information66,
1176 p_information67,
1177 p_information68,
1178 p_information69,
1179 p_information70,
1180 p_information71,
1181 p_information72,
1182 p_information73,
1183 p_information74,
1184 p_information75,
1185 p_information76,
1186 p_information77,
1187 p_information78,
1188 p_information79,
1189 p_information80,
1190 p_information81,
1191 p_information82,
1192 p_information83,
1193 p_information84,
1194 p_information85,
1195 p_information86,
1196 p_information87,
1197 p_information88,
1198 p_information89,
1199 p_information90,
1200 p_information91,
1201 p_information92,
1202 p_information93,
1203 p_information94,
1204 p_information95,
1205 p_information96,
1206 p_information97,
1207 p_information98,
1208 p_information99,
1209 p_information100,
1210 p_information101,
1211 p_information102,
1212 p_information103,
1213 p_information104,
1214 p_information105,
1215 p_information106,
1216 p_information107,
1217 p_information108,
1218 p_information109,
1219 p_information110,
1220 p_information111,
1221 p_information112,
1222 p_information113,
1223 p_information114,
1224 p_information115,
1225 p_information116,
1226 p_information117,
1227 p_information118,
1228 p_information119,
1229 p_information120,
1230 p_information121,
1231 p_information122,
1232 p_information123,
1233 p_information124,
1234 p_information125,
1235 p_information126,
1236 p_information127,
1237 p_information128,
1238 p_information129,
1239 p_information130,
1240 p_information131,
1241 p_information132,
1242 p_information133,
1243 p_information134,
1244 p_information135,
1245 p_information136,
1246 p_information137,
1247 p_information138,
1248 p_information139,
1249 p_information140,
1250 p_information141,
1251 p_information142,
1252 p_information143,
1253 p_information144,
1254 p_information145,
1255 p_information146,
1256 p_information147,
1257 p_information148,
1258 p_information149,
1259 p_information150,
1260 p_information151,
1261 p_information152,
1262 p_information153,
1263 p_information154,
1264 p_information155,
1265 p_information156,
1266 p_information157,
1267 p_information158,
1268 p_information159,
1269 p_information160,
1270 p_information161,
1271 p_information162,
1272 p_information163,
1273 p_information164,
1274 p_information165,
1275 p_information166,
1276 p_information167,
1277 p_information168,
1278 p_information169,
1279 p_information170,
1280 p_information171,
1281 p_information172,
1282 p_information173,
1283 p_information174,
1284 p_information175,
1285 p_information176,
1286 p_information177,
1287 p_information178,
1288 p_information179,
1289 p_information180,
1290 p_information181,
1291 p_information182,
1292 p_information183,
1293 p_information184,
1294 p_information185,
1295 p_information186,
1296 p_information187,
1297 p_information188,
1298 p_information189,
1299 p_information190,
1300 p_information191,
1301 p_information192,
1302 p_information193,
1303 p_information194,
1304 p_information195,
1305 p_information196,
1306 p_information197,
1307 p_information198,
1311 --
1308 p_information199,
1309 p_information200
1310 );
1312 -- Having converted the arguments into the ghr_pah_rec
1313 -- plsql record structure we call the corresponding record business process.
1314 --
1315 ins(l_rec);
1316 --
1317 -- As the primary key argument(s)
1318 -- are specified as an OUT's we must set these values.
1319 --
1320 p_pa_history_id := l_rec.pa_history_id;
1321 --
1322 --
1323 hr_utility.set_location(' Leaving:'||l_proc, 10);
1324 End ins;
1325 --
1326 end ghr_pah_ins;