[Home] [Help]
PACKAGE BODY: APPS.PQH_CER_INS
Source
1 Package Body pqh_cer_ins as
2 /* $Header: pqcerrhi.pkb 120.1 2011/11/17 12:10:50 sidsaxen ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' pqh_cer_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 insert the row into the schema.
21 -- 3) To trap any constraint violations that may have occurred.
22 -- 4) To raise any other errors.
23 --
24 -- Prerequisites:
25 -- This is an internal private procedure which must be called from the ins
26 -- procedure and must have all mandatory attributes set (except the
27 -- object_version_number which is initialised within this procedure).
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- The specified row will be inserted into the schema.
34 --
35 -- Post Failure:
36 -- If a check, unique or parent integrity constraint violation is raised the
37 -- constraint_error procedure will be called.
38 --
39 -- Developer Implementation Notes:
40 -- None.
41 --
42 -- Access Status:
43 -- Internal Row Handler Use Only.
44 --
45 -- {End Of Comments}
46 -- ----------------------------------------------------------------------------
47 Procedure insert_dml(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
48 --
49 l_proc varchar2(72) := g_package||'insert_dml';
50 --
51 Begin
52 hr_utility.set_location('Entering:'||l_proc, 5);
53 p_rec.object_version_number := 1; -- Initialise the object version
54 --
55 -- Insert the row into: pqh_copy_entity_results
56 --
57 insert into pqh_copy_entity_results
58 ( copy_entity_result_id,
59 copy_entity_txn_id,
60 result_type_cd,
61 number_of_copies,
62 status,
63 src_copy_entity_result_id,
64 information_category,
65 information1,
66 information2,
67 information3,
68 information4,
69 information5,
70 information6,
71 information7,
72 information8,
73 information9,
74 information10,
75 information11,
76 information12,
77 information13,
78 information14,
79 information15,
80 information16,
81 information17,
82 information18,
83 information19,
84 information20,
85 information21,
86 information22,
87 information23,
88 information24,
89 information25,
90 information26,
91 information27,
92 information28,
93 information29,
94 information30,
95 information31,
96 information32,
97 information33,
98 information34,
99 information35,
100 information36,
101 information37,
102 information38,
103 information39,
104 information40,
105 information41,
106 information42,
107 information43,
108 information44,
109 information45,
110 information46,
111 information47,
112 information48,
113 information49,
114 information50,
115 information51,
116 information52,
117 information53,
118 information54,
119 information55,
120 information56,
121 information57,
122 information58,
123 information59,
124 information60,
125 information61,
126 information62,
127 information63,
128 information64,
129 information65,
130 information66,
131 information67,
132 information68,
133 information69,
134 information70,
135 information71,
136 information72,
137 information73,
138 information74,
139 information75,
140 information76,
141 information77,
142 information78,
143 information79,
144 information80,
145 information81,
146 information82,
147 information83,
148 information84,
149 information85,
150 information86,
151 information87,
152 information88,
153 information89,
154 information90,
155 information91,
156 information92,
157 information93,
158 information94,
159 information95,
160 information96,
161 information97,
162 information98,
163 information99,
164 information100,
165 information101,
166 information102,
167 information103,
168 information104,
169 information105,
170 information106,
171 information107,
172 information108,
173 information109,
174 information110,
175 information111,
176 information112,
177 information113,
178 information114,
179 information115,
180 information116,
181 information117,
182 information118,
183 information119,
184 information120,
185 information121,
186 information122,
187 information123,
188 information124,
189 information125,
190 information126,
191 information127,
192 information128,
193 information129,
194 information130,
195 information131,
196 information132,
197 information133,
198 information134,
199 information135,
200 information136,
201 information137,
202 information138,
203 information139,
204 information140,
205 information141,
206 information142,
207 information143,
208 information144,
209 information145,
210 information146,
211 information147,
212 information148,
213 information149,
214 information150,
215 information151,
216 information152,
217 information153,
218 information154,
219 information155,
220 information156,
221 information157,
222 information158,
223 information159,
224 information160,
225 information161,
226 information162,
227 information163,
228 information164,
229 information165,
230 information166,
231 information167,
232 information168,
233 information169,
234 information170,
235 information171,
236 information172,
237 information173,
238 information174,
239 information175,
240 information176,
241 information177,
242 information178,
243 information179,
244 information180,
245 information181,
246 information182,
247 information183,
248 information184,
249 information185,
250 information186,
251 information187,
252 information188,
253 information189,
254 information190,
255 mirror_entity_result_id,
256 mirror_src_entity_result_id,
257 parent_entity_result_id,
258 table_route_id,
259 long_attribute1,
260 object_version_number
261 )
262 Values
263 ( p_rec.copy_entity_result_id,
264 p_rec.copy_entity_txn_id,
265 p_rec.result_type_cd,
266 p_rec.number_of_copies,
267 p_rec.status,
268 p_rec.src_copy_entity_result_id,
269 p_rec.information_category,
270 p_rec.information1,
271 p_rec.information2,
272 p_rec.information3,
273 p_rec.information4,
274 p_rec.information5,
275 p_rec.information6,
276 p_rec.information7,
277 p_rec.information8,
278 p_rec.information9,
279 p_rec.information10,
280 p_rec.information11,
281 p_rec.information12,
282 p_rec.information13,
283 p_rec.information14,
284 p_rec.information15,
285 p_rec.information16,
286 p_rec.information17,
287 p_rec.information18,
288 p_rec.information19,
289 p_rec.information20,
290 p_rec.information21,
291 p_rec.information22,
292 p_rec.information23,
293 p_rec.information24,
294 p_rec.information25,
295 p_rec.information26,
296 p_rec.information27,
297 p_rec.information28,
298 p_rec.information29,
299 p_rec.information30,
300 p_rec.information31,
301 p_rec.information32,
302 p_rec.information33,
303 p_rec.information34,
304 p_rec.information35,
305 p_rec.information36,
306 p_rec.information37,
307 p_rec.information38,
308 p_rec.information39,
309 p_rec.information40,
310 p_rec.information41,
311 p_rec.information42,
312 p_rec.information43,
313 p_rec.information44,
314 p_rec.information45,
315 p_rec.information46,
316 p_rec.information47,
317 p_rec.information48,
318 p_rec.information49,
319 p_rec.information50,
320 p_rec.information51,
321 p_rec.information52,
322 p_rec.information53,
323 p_rec.information54,
324 p_rec.information55,
325 p_rec.information56,
326 p_rec.information57,
327 p_rec.information58,
328 p_rec.information59,
329 p_rec.information60,
330 p_rec.information61,
331 p_rec.information62,
332 p_rec.information63,
333 p_rec.information64,
334 p_rec.information65,
335 p_rec.information66,
336 p_rec.information67,
337 p_rec.information68,
338 p_rec.information69,
339 p_rec.information70,
340 p_rec.information71,
341 p_rec.information72,
342 p_rec.information73,
343 p_rec.information74,
344 p_rec.information75,
345 p_rec.information76,
346 p_rec.information77,
347 p_rec.information78,
348 p_rec.information79,
349 p_rec.information80,
350 p_rec.information81,
351 p_rec.information82,
352 p_rec.information83,
353 p_rec.information84,
354 p_rec.information85,
355 p_rec.information86,
356 p_rec.information87,
357 p_rec.information88,
358 p_rec.information89,
359 p_rec.information90,
360 p_rec.information91,
361 p_rec.information92,
362 p_rec.information93,
363 p_rec.information94,
364 p_rec.information95,
365 p_rec.information96,
366 p_rec.information97,
367 p_rec.information98,
368 p_rec.information99,
369 p_rec.information100,
370 p_rec.information101,
371 p_rec.information102,
372 p_rec.information103,
373 p_rec.information104,
374 p_rec.information105,
375 p_rec.information106,
376 p_rec.information107,
377 p_rec.information108,
378 p_rec.information109,
379 p_rec.information110,
380 p_rec.information111,
381 p_rec.information112,
382 p_rec.information113,
383 p_rec.information114,
384 p_rec.information115,
385 p_rec.information116,
386 p_rec.information117,
387 p_rec.information118,
388 p_rec.information119,
389 p_rec.information120,
390 p_rec.information121,
391 p_rec.information122,
392 p_rec.information123,
393 p_rec.information124,
394 p_rec.information125,
395 p_rec.information126,
396 p_rec.information127,
397 p_rec.information128,
398 p_rec.information129,
399 p_rec.information130,
400 p_rec.information131,
401 p_rec.information132,
402 p_rec.information133,
403 p_rec.information134,
404 p_rec.information135,
405 p_rec.information136,
406 p_rec.information137,
407 p_rec.information138,
408 p_rec.information139,
409 p_rec.information140,
410 p_rec.information141,
411 p_rec.information142,
412 p_rec.information143,
413 p_rec.information144,
414 p_rec.information145,
415 p_rec.information146,
416 p_rec.information147,
417 p_rec.information148,
418 p_rec.information149,
419 p_rec.information150,
420 p_rec.information151,
421 p_rec.information152,
422 p_rec.information153,
423 p_rec.information154,
424 p_rec.information155,
425 p_rec.information156,
426 p_rec.information157,
427 p_rec.information158,
428 p_rec.information159,
429 p_rec.information160,
430 p_rec.information161,
431 p_rec.information162,
432 p_rec.information163,
433 p_rec.information164,
434 p_rec.information165,
435 p_rec.information166,
436 p_rec.information167,
437 p_rec.information168,
438 p_rec.information169,
439 p_rec.information170,
440 p_rec.information171,
441 p_rec.information172,
442 p_rec.information173,
443 p_rec.information174,
444 p_rec.information175,
445 p_rec.information176,
446 p_rec.information177,
447 p_rec.information178,
448 p_rec.information179,
449 p_rec.information180,
450 p_rec.information181,
451 p_rec.information182,
452 p_rec.information183,
453 p_rec.information184,
454 p_rec.information185,
455 p_rec.information186,
456 p_rec.information187,
457 p_rec.information188,
458 p_rec.information189,
459 p_rec.information190,
460 nvl(p_rec.mirror_entity_result_id, p_rec.copy_entity_result_id),
461 p_rec.mirror_src_entity_result_id,
462 p_rec.parent_entity_result_id,
463 p_rec.table_route_id,
464 p_rec.long_attribute1,
465 p_rec.object_version_number
466 );
467 --
468 hr_utility.set_location(' Leaving:'||l_proc, 10);
469 Exception
470 When hr_api.check_integrity_violated Then
471 -- A check constraint has been violated
472 pqh_cer_shd.constraint_error
473 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474 When hr_api.parent_integrity_violated Then
475 -- Parent integrity has been violated
476 pqh_cer_shd.constraint_error
477 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
478 When hr_api.unique_integrity_violated Then
479 -- Unique integrity has been violated
480 pqh_cer_shd.constraint_error
481 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
482 When Others Then
483 Raise;
484 End insert_dml;
485 --
486 -- ----------------------------------------------------------------------------
487 -- |------------------------------< pre_insert >------------------------------|
488 -- ----------------------------------------------------------------------------
489 -- {Start Of Comments}
490 --
491 -- Description:
492 -- This private procedure contains any processing which is required before
493 -- the insert dml. Presently, if the entity has a corresponding primary
494 -- key which is maintained by an associating sequence, the primary key for
495 -- the entity will be populated with the next sequence value in
496 -- preparation for the insert dml.
497 --
498 -- Prerequisites:
499 -- This is an internal procedure which is called from the ins procedure.
500 --
501 -- In Parameters:
502 -- A Pl/Sql record structre.
503 --
504 -- Post Success:
505 -- Processing continues.
506 --
507 -- Post Failure:
508 -- If an error has occurred, an error message and exception will be raised
509 -- but not handled.
510 --
511 -- Developer Implementation Notes:
512 -- Any pre-processing required before the insert dml is issued should be
513 -- coded within this procedure. As stated above, a good example is the
514 -- generation of a primary key number via a corresponding sequence.
515 -- It is important to note that any 3rd party maintenance should be reviewed
516 -- before placing in this procedure.
517 --
518 -- Access Status:
519 -- Internal Row Handler Use Only.
520 --
521 -- {End Of Comments}
522 -- ----------------------------------------------------------------------------
523 Procedure pre_insert(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
524 --
525 l_proc varchar2(72) := g_package||'pre_insert';
526 --
527 Cursor C_Sel1 is select pqh_copy_entity_results_s.nextval from sys.dual;
528 --
529 Begin
530 hr_utility.set_location('Entering:'||l_proc, 5);
531 --
532 --
533 -- Select the next sequence number
534 --
535 Open C_Sel1;
536 Fetch C_Sel1 Into p_rec.copy_entity_result_id;
537 Close C_Sel1;
538 --
539 hr_utility.set_location(' Leaving:'||l_proc, 10);
540 End pre_insert;
541 --
542 -- ----------------------------------------------------------------------------
543 -- |-----------------------------< post_insert >------------------------------|
544 -- ----------------------------------------------------------------------------
545 -- {Start Of Comments}
546 --
547 -- Description:
548 -- This private procedure contains any processing which is required after the
549 -- insert dml.
550 --
551 -- Prerequisites:
552 -- This is an internal procedure which is called from the ins procedure.
553 --
554 -- In Parameters:
555 -- A Pl/Sql record structre.
556 --
557 -- Post Success:
558 -- Processing continues.
559 --
560 -- Post Failure:
561 -- If an error has occurred, an error message and exception will be raised
562 -- but not handled.
563 --
564 -- Developer Implementation Notes:
565 -- Any post-processing required after the insert dml is issued should be
566 -- coded within this procedure. It is important to note that any 3rd party
567 -- maintenance should be reviewed before placing in this procedure.
568 --
569 -- Access Status:
570 -- Internal Row Handler Use Only.
571 --
572 -- {End Of Comments}
573 -- ----------------------------------------------------------------------------
574 Procedure post_insert(
575 p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is
576 --
577 l_proc varchar2(72) := g_package||'post_insert';
578 --
579 Begin
580 hr_utility.set_location('Entering:'||l_proc, 5);
581 --
582 --
583 -- Start of API User Hook for post_insert.
584 --
585 begin
586 --
587 pqh_cer_rki.after_insert
588 (
589 p_copy_entity_result_id =>p_rec.copy_entity_result_id
590 ,p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
591 ,p_result_type_cd =>p_rec.result_type_cd
592 ,p_number_of_copies =>p_rec.number_of_copies
593 ,p_status =>p_rec.status
594 ,p_src_copy_entity_result_id =>p_rec.src_copy_entity_result_id
595 ,p_information_category =>p_rec.information_category
596 ,p_information1 =>p_rec.information1
597 ,p_information2 =>p_rec.information2
598 ,p_information3 =>p_rec.information3
599 ,p_information4 =>p_rec.information4
600 ,p_information5 =>p_rec.information5
601 ,p_information6 =>p_rec.information6
602 ,p_information7 =>p_rec.information7
603 ,p_information8 =>p_rec.information8
604 ,p_information9 =>p_rec.information9
605 ,p_information10 =>p_rec.information10
606 ,p_information11 =>p_rec.information11
607 ,p_information12 =>p_rec.information12
608 ,p_information13 =>p_rec.information13
609 ,p_information14 =>p_rec.information14
610 ,p_information15 =>p_rec.information15
611 ,p_information16 =>p_rec.information16
612 ,p_information17 =>p_rec.information17
613 ,p_information18 =>p_rec.information18
614 ,p_information19 =>p_rec.information19
615 ,p_information20 =>p_rec.information20
616 ,p_information21 =>p_rec.information21
617 ,p_information22 =>p_rec.information22
618 ,p_information23 =>p_rec.information23
619 ,p_information24 =>p_rec.information24
620 ,p_information25 =>p_rec.information25
621 ,p_information26 =>p_rec.information26
622 ,p_information27 =>p_rec.information27
623 ,p_information28 =>p_rec.information28
624 ,p_information29 =>p_rec.information29
625 ,p_information30 =>p_rec.information30
626 ,p_information31 =>p_rec.information31
627 ,p_information32 =>p_rec.information32
628 ,p_information33 =>p_rec.information33
629 ,p_information34 =>p_rec.information34
630 ,p_information35 =>p_rec.information35
631 ,p_information36 =>p_rec.information36
632 ,p_information37 =>p_rec.information37
633 ,p_information38 =>p_rec.information38
634 ,p_information39 =>p_rec.information39
635 ,p_information40 =>p_rec.information40
636 ,p_information41 =>p_rec.information41
637 ,p_information42 =>p_rec.information42
638 ,p_information43 =>p_rec.information43
639 ,p_information44 =>p_rec.information44
640 ,p_information45 =>p_rec.information45
641 ,p_information46 =>p_rec.information46
642 ,p_information47 =>p_rec.information47
643 ,p_information48 =>p_rec.information48
644 ,p_information49 =>p_rec.information49
645 ,p_information50 =>p_rec.information50
646 ,p_information51 =>p_rec.information51
647 ,p_information52 =>p_rec.information52
648 ,p_information53 =>p_rec.information53
649 ,p_information54 =>p_rec.information54
650 ,p_information55 =>p_rec.information55
651 ,p_information56 =>p_rec.information56
652 ,p_information57 =>p_rec.information57
653 ,p_information58 =>p_rec.information58
654 ,p_information59 =>p_rec.information59
655 ,p_information60 =>p_rec.information60
656 ,p_information61 =>p_rec.information61
657 ,p_information62 =>p_rec.information62
658 ,p_information63 =>p_rec.information63
659 ,p_information64 =>p_rec.information64
660 ,p_information65 =>p_rec.information65
661 ,p_information66 =>p_rec.information66
662 ,p_information67 =>p_rec.information67
663 ,p_information68 =>p_rec.information68
664 ,p_information69 =>p_rec.information69
665 ,p_information70 =>p_rec.information70
666 ,p_information71 =>p_rec.information71
667 ,p_information72 =>p_rec.information72
668 ,p_information73 =>p_rec.information73
669 ,p_information74 =>p_rec.information74
670 ,p_information75 =>p_rec.information75
671 ,p_information76 =>p_rec.information76
672 ,p_information77 =>p_rec.information77
673 ,p_information78 =>p_rec.information78
674 ,p_information79 =>p_rec.information79
675 ,p_information80 =>p_rec.information80
676 ,p_information81 =>p_rec.information81
677 ,p_information82 =>p_rec.information82
678 ,p_information83 =>p_rec.information83
679 ,p_information84 =>p_rec.information84
680 ,p_information85 =>p_rec.information85
681 ,p_information86 =>p_rec.information86
682 ,p_information87 =>p_rec.information87
683 ,p_information88 =>p_rec.information88
684 ,p_information89 =>p_rec.information89
685 ,p_information90 =>p_rec.information90
686 ,p_information91 =>p_rec.information91
687 ,p_information92 =>p_rec.information92
688 ,p_information93 =>p_rec.information93
689 ,p_information94 =>p_rec.information94
690 ,p_information95 =>p_rec.information95
691 ,p_information96 =>p_rec.information96
692 ,p_information97 =>p_rec.information97
693 ,p_information98 =>p_rec.information98
694 ,p_information99 =>p_rec.information99
695 ,p_information100 =>p_rec.information100
696 ,p_information101 =>p_rec.information101
697 ,p_information102 =>p_rec.information102
698 ,p_information103 =>p_rec.information103
699 ,p_information104 =>p_rec.information104
700 ,p_information105 =>p_rec.information105
701 ,p_information106 =>p_rec.information106
702 ,p_information107 =>p_rec.information107
703 ,p_information108 =>p_rec.information108
704 ,p_information109 =>p_rec.information109
705 ,p_information110 =>p_rec.information110
706 ,p_information111 =>p_rec.information111
707 ,p_information112 =>p_rec.information112
708 ,p_information113 =>p_rec.information113
709 ,p_information114 =>p_rec.information114
710 ,p_information115 =>p_rec.information115
711 ,p_information116 =>p_rec.information116
712 ,p_information117 =>p_rec.information117
713 ,p_information118 =>p_rec.information118
714 ,p_information119 =>p_rec.information119
715 ,p_information120 =>p_rec.information120
716 ,p_information121 =>p_rec.information121
717 ,p_information122 =>p_rec.information122
718 ,p_information123 =>p_rec.information123
719 ,p_information124 =>p_rec.information124
720 ,p_information125 =>p_rec.information125
721 ,p_information126 =>p_rec.information126
722 ,p_information127 =>p_rec.information127
723 ,p_information128 =>p_rec.information128
724 ,p_information129 =>p_rec.information129
725 ,p_information130 =>p_rec.information130
726 ,p_information131 =>p_rec.information131
727 ,p_information132 =>p_rec.information132
728 ,p_information133 =>p_rec.information133
729 ,p_information134 =>p_rec.information134
730 ,p_information135 =>p_rec.information135
731 ,p_information136 =>p_rec.information136
732 ,p_information137 =>p_rec.information137
733 ,p_information138 =>p_rec.information138
734 ,p_information139 =>p_rec.information139
735 ,p_information140 =>p_rec.information140
736 ,p_information141 =>p_rec.information141
737 ,p_information142 =>p_rec.information142
738 ,p_information143 =>p_rec.information143
739 ,p_information144 =>p_rec.information144
740 ,p_information145 =>p_rec.information145
741 ,p_information146 =>p_rec.information146
742 ,p_information147 =>p_rec.information147
743 ,p_information148 =>p_rec.information148
744 ,p_information149 =>p_rec.information149
745 ,p_information150 =>p_rec.information150
746 ,p_information151 =>p_rec.information151
747 ,p_information152 =>p_rec.information152
748 ,p_information153 =>p_rec.information153
749 ,p_information154 =>p_rec.information154
750 ,p_information155 =>p_rec.information155
751 ,p_information156 =>p_rec.information156
752 ,p_information157 =>p_rec.information157
753 ,p_information158 =>p_rec.information158
754 ,p_information159 =>p_rec.information159
755 ,p_information160 =>p_rec.information160
756 ,p_information161 =>p_rec.information161
757 ,p_information162 =>p_rec.information162
758 ,p_information163 =>p_rec.information163
759 ,p_information164 =>p_rec.information164
760 ,p_information165 =>p_rec.information165
761 ,p_information166 =>p_rec.information166
762 ,p_information167 =>p_rec.information167
763 ,p_information168 =>p_rec.information168
764 ,p_information169 =>p_rec.information169
765 ,p_information170 =>p_rec.information170
766 ,p_information171 =>p_rec.information171
767 ,p_information172 =>p_rec.information172
768 ,p_information173 =>p_rec.information173
769 ,p_information174 =>p_rec.information174
770 ,p_information175 =>p_rec.information175
771 ,p_information176 =>p_rec.information176
772 ,p_information177 =>p_rec.information177
773 ,p_information178 =>p_rec.information178
774 ,p_information179 =>p_rec.information179
775 ,p_information180 =>p_rec.information180
776 ,p_information181 =>p_rec.information181
777 ,p_information182 =>p_rec.information182
778 ,p_information183 =>p_rec.information183
779 ,p_information184 =>p_rec.information184
780 ,p_information185 =>p_rec.information185
781 ,p_information186 =>p_rec.information186
782 ,p_information187 =>p_rec.information187
783 ,p_information188 =>p_rec.information188
784 ,p_information189 =>p_rec.information189
785 ,p_information190 =>p_rec.information190
786 ,p_mirror_entity_result_id =>p_rec.mirror_entity_result_id
787 ,p_mirror_src_entity_result_id =>p_rec.mirror_src_entity_result_id
788 ,p_parent_entity_result_id =>p_rec.parent_entity_result_id
789 ,p_table_route_id =>p_rec.table_route_id
790 ,p_long_attribute1 =>p_rec.long_attribute1
791 ,p_object_version_number =>p_rec.object_version_number
792 ,p_effective_date =>p_effective_date
793 );
794 --
795 exception
796 --
797 when hr_api.cannot_find_prog_unit then
798 --
799 hr_api.cannot_find_prog_unit_error
800 (p_module_name => 'pqh_copy_entity_results'
801 ,p_hook_type => 'AI');
802 --
803 end;
804 --
805 -- End of API User Hook for post_insert.
806 --
807 --
808 hr_utility.set_location(' Leaving:'||l_proc, 10);
809 End post_insert;
810 --
811 -- ----------------------------------------------------------------------------
812 -- |---------------------------------< ins >----------------------------------|
813 -- ----------------------------------------------------------------------------
814 Procedure ins
815 (
816 p_effective_date in date,
817 p_rec in out nocopy pqh_cer_shd.g_rec_type
818 ) is
819 --
820 l_proc varchar2(72) := g_package||'ins';
821 --
822 Begin
823 hr_utility.set_location('Entering:'||l_proc, 5);
824 --
825 -- Call the supporting insert validate operations
826 --
827 pqh_cer_bus.insert_validate(p_rec
828 ,p_effective_date);
829 --
830 -- Call the supporting pre-insert operation
831 --
832 pre_insert(p_rec);
833 --
834 -- Insert the row
835 --
836 insert_dml(p_rec);
837 --
838 -- Call the supporting post-insert operation
839 --
840 post_insert(
841 p_effective_date,p_rec);
842 end ins;
843 --
844 -- ----------------------------------------------------------------------------
845 -- |---------------------------------< ins >----------------------------------|
846 -- ----------------------------------------------------------------------------
847 Procedure ins
848 (
849 p_effective_date in date,
850 p_copy_entity_result_id out nocopy number,
851 p_copy_entity_txn_id in number,
852 p_result_type_cd in varchar2 default null,
853 p_number_of_copies in number default null,
854 p_status in varchar2 default null,
855 p_src_copy_entity_result_id in number default null,
856 p_information_category in varchar2 default null,
857 p_information1 in varchar2 default null,
858 p_information2 in varchar2 default null,
859 p_information3 in varchar2 default null,
860 p_information4 in varchar2 default null,
861 p_information5 in varchar2 default null,
862 p_information6 in varchar2 default null,
863 p_information7 in varchar2 default null,
864 p_information8 in varchar2 default null,
865 p_information9 in varchar2 default null,
866 p_information10 in varchar2 default null,
867 p_information11 in varchar2 default null,
868 p_information12 in varchar2 default null,
869 p_information13 in varchar2 default null,
870 p_information14 in varchar2 default null,
871 p_information15 in varchar2 default null,
872 p_information16 in varchar2 default null,
873 p_information17 in varchar2 default null,
874 p_information18 in varchar2 default null,
875 p_information19 in varchar2 default null,
876 p_information20 in varchar2 default null,
877 p_information21 in varchar2 default null,
878 p_information22 in varchar2 default null,
879 p_information23 in varchar2 default null,
880 p_information24 in varchar2 default null,
881 p_information25 in varchar2 default null,
882 p_information26 in varchar2 default null,
883 p_information27 in varchar2 default null,
884 p_information28 in varchar2 default null,
885 p_information29 in varchar2 default null,
886 p_information30 in varchar2 default null,
887 p_information31 in varchar2 default null,
888 p_information32 in varchar2 default null,
889 p_information33 in varchar2 default null,
890 p_information34 in varchar2 default null,
891 p_information35 in varchar2 default null,
892 p_information36 in varchar2 default null,
893 p_information37 in varchar2 default null,
894 p_information38 in varchar2 default null,
895 p_information39 in varchar2 default null,
896 p_information40 in varchar2 default null,
897 p_information41 in varchar2 default null,
898 p_information42 in varchar2 default null,
899 p_information43 in varchar2 default null,
900 p_information44 in varchar2 default null,
901 p_information45 in varchar2 default null,
902 p_information46 in varchar2 default null,
903 p_information47 in varchar2 default null,
904 p_information48 in varchar2 default null,
905 p_information49 in varchar2 default null,
906 p_information50 in varchar2 default null,
907 p_information51 in varchar2 default null,
908 p_information52 in varchar2 default null,
909 p_information53 in varchar2 default null,
910 p_information54 in varchar2 default null,
911 p_information55 in varchar2 default null,
912 p_information56 in varchar2 default null,
913 p_information57 in varchar2 default null,
914 p_information58 in varchar2 default null,
915 p_information59 in varchar2 default null,
916 p_information60 in varchar2 default null,
917 p_information61 in varchar2 default null,
918 p_information62 in varchar2 default null,
919 p_information63 in varchar2 default null,
920 p_information64 in varchar2 default null,
921 p_information65 in varchar2 default null,
922 p_information66 in varchar2 default null,
923 p_information67 in varchar2 default null,
924 p_information68 in varchar2 default null,
925 p_information69 in varchar2 default null,
926 p_information70 in varchar2 default null,
927 p_information71 in varchar2 default null,
928 p_information72 in varchar2 default null,
929 p_information73 in varchar2 default null,
930 p_information74 in varchar2 default null,
931 p_information75 in varchar2 default null,
932 p_information76 in varchar2 default null,
933 p_information77 in varchar2 default null,
934 p_information78 in varchar2 default null,
935 p_information79 in varchar2 default null,
936 p_information80 in varchar2 default null,
937 p_information81 in varchar2 default null,
938 p_information82 in varchar2 default null,
939 p_information83 in varchar2 default null,
940 p_information84 in varchar2 default null,
941 p_information85 in varchar2 default null,
942 p_information86 in varchar2 default null,
943 p_information87 in varchar2 default null,
944 p_information88 in varchar2 default null,
945 p_information89 in varchar2 default null,
946 p_information90 in varchar2 default null,
947 p_information91 in varchar2 default null,
948 p_information92 in varchar2 default null,
949 p_information93 in varchar2 default null,
950 p_information94 in varchar2 default null,
951 p_information95 in varchar2 default null,
952 p_information96 in varchar2 default null,
953 p_information97 in varchar2 default null,
954 p_information98 in varchar2 default null,
955 p_information99 in varchar2 default null,
956 p_information100 in varchar2 default null,
957 p_information101 in varchar2 default null,
958 p_information102 in varchar2 default null,
959 p_information103 in varchar2 default null,
960 p_information104 in varchar2 default null,
961 p_information105 in varchar2 default null,
962 p_information106 in varchar2 default null,
963 p_information107 in varchar2 default null,
964 p_information108 in varchar2 default null,
965 p_information109 in varchar2 default null,
966 p_information110 in varchar2 default null,
967 p_information111 in varchar2 default null,
968 p_information112 in varchar2 default null,
969 p_information113 in varchar2 default null,
970 p_information114 in varchar2 default null,
971 p_information115 in varchar2 default null,
972 p_information116 in varchar2 default null,
973 p_information117 in varchar2 default null,
974 p_information118 in varchar2 default null,
975 p_information119 in varchar2 default null,
976 p_information120 in varchar2 default null,
977 p_information121 in varchar2 default null,
978 p_information122 in varchar2 default null,
979 p_information123 in varchar2 default null,
980 p_information124 in varchar2 default null,
981 p_information125 in varchar2 default null,
982 p_information126 in varchar2 default null,
983 p_information127 in varchar2 default null,
984 p_information128 in varchar2 default null,
985 p_information129 in varchar2 default null,
986 p_information130 in varchar2 default null,
987 p_information131 in varchar2 default null,
988 p_information132 in varchar2 default null,
989 p_information133 in varchar2 default null,
990 p_information134 in varchar2 default null,
991 p_information135 in varchar2 default null,
992 p_information136 in varchar2 default null,
993 p_information137 in varchar2 default null,
994 p_information138 in varchar2 default null,
995 p_information139 in varchar2 default null,
996 p_information140 in varchar2 default null,
997 p_information141 in varchar2 default null,
998 p_information142 in varchar2 default null,
999 p_information143 in varchar2 default null,
1000 p_information144 in varchar2 default null,
1001 p_information145 in varchar2 default null,
1002 p_information146 in varchar2 default null,
1003 p_information147 in varchar2 default null,
1004 p_information148 in varchar2 default null,
1005 p_information149 in varchar2 default null,
1006 p_information150 in varchar2 default null,
1007 p_information151 in varchar2 default null,
1008 p_information152 in varchar2 default null,
1009 p_information153 in varchar2 default null,
1010 p_information154 in varchar2 default null,
1011 p_information155 in varchar2 default null,
1012 p_information156 in varchar2 default null,
1013 p_information157 in varchar2 default null,
1014 p_information158 in varchar2 default null,
1015 p_information159 in varchar2 default null,
1016 p_information160 in varchar2 default null,
1017 p_information161 in varchar2 default null,
1018 p_information162 in varchar2 default null,
1019 p_information163 in varchar2 default null,
1020 p_information164 in varchar2 default null,
1021 p_information165 in varchar2 default null,
1022 p_information166 in varchar2 default null,
1023 p_information167 in varchar2 default null,
1024 p_information168 in varchar2 default null,
1025 p_information169 in varchar2 default null,
1026 p_information170 in varchar2 default null,
1027 p_information171 in varchar2 default null,
1028 p_information172 in varchar2 default null,
1029 p_information173 in varchar2 default null,
1030 p_information174 in varchar2 default null,
1031 p_information175 in varchar2 default null,
1032 p_information176 in varchar2 default null,
1033 p_information177 in varchar2 default null,
1034 p_information178 in varchar2 default null,
1035 p_information179 in varchar2 default null,
1036 p_information180 in varchar2 default null,
1037 p_information181 in varchar2 default null,
1038 p_information182 in varchar2 default null,
1039 p_information183 in varchar2 default null,
1040 p_information184 in varchar2 default null,
1041 p_information185 in varchar2 default null,
1042 p_information186 in varchar2 default null,
1043 p_information187 in varchar2 default null,
1044 p_information188 in varchar2 default null,
1045 p_information189 in varchar2 default null,
1046 p_information190 in varchar2 default null,
1047 p_mirror_entity_result_id in number default null,
1048 p_mirror_src_entity_result_id in number default null,
1049 p_parent_entity_result_id in number default null,
1050 p_table_route_id in number default null,
1051 p_long_attribute1 in clob default null,
1052 p_object_version_number out nocopy number
1053 ) is
1054 --
1055 l_rec pqh_cer_shd.g_rec_type;
1056 l_proc varchar2(72) := g_package||'ins';
1057 --
1058 Begin
1059 hr_utility.set_location('Entering:'||l_proc, 5);
1060 --
1061 -- Call conversion function to turn arguments into the
1062 -- p_rec structure.
1063 --
1064 l_rec :=
1065 pqh_cer_shd.convert_args
1066 (
1067 null,
1068 p_copy_entity_txn_id,
1069 p_result_type_cd,
1070 p_number_of_copies,
1071 p_status,
1072 p_src_copy_entity_result_id,
1073 p_information_category,
1074 p_information1,
1075 p_information2,
1076 p_information3,
1077 p_information4,
1078 p_information5,
1079 p_information6,
1080 p_information7,
1081 p_information8,
1082 p_information9,
1083 p_information10,
1084 p_information11,
1085 p_information12,
1086 p_information13,
1087 p_information14,
1088 p_information15,
1089 p_information16,
1090 p_information17,
1091 p_information18,
1092 p_information19,
1093 p_information20,
1094 p_information21,
1095 p_information22,
1096 p_information23,
1097 p_information24,
1098 p_information25,
1099 p_information26,
1100 p_information27,
1101 p_information28,
1102 p_information29,
1103 p_information30,
1104 p_information31,
1105 p_information32,
1106 p_information33,
1107 p_information34,
1108 p_information35,
1109 p_information36,
1110 p_information37,
1111 p_information38,
1112 p_information39,
1113 p_information40,
1114 p_information41,
1115 p_information42,
1116 p_information43,
1117 p_information44,
1118 p_information45,
1119 p_information46,
1120 p_information47,
1121 p_information48,
1122 p_information49,
1123 p_information50,
1124 p_information51,
1125 p_information52,
1126 p_information53,
1127 p_information54,
1128 p_information55,
1129 p_information56,
1130 p_information57,
1131 p_information58,
1132 p_information59,
1133 p_information60,
1134 p_information61,
1135 p_information62,
1136 p_information63,
1137 p_information64,
1138 p_information65,
1139 p_information66,
1140 p_information67,
1141 p_information68,
1142 p_information69,
1143 p_information70,
1144 p_information71,
1145 p_information72,
1146 p_information73,
1147 p_information74,
1148 p_information75,
1149 p_information76,
1150 p_information77,
1151 p_information78,
1152 p_information79,
1153 p_information80,
1154 p_information81,
1155 p_information82,
1156 p_information83,
1157 p_information84,
1158 p_information85,
1159 p_information86,
1160 p_information87,
1161 p_information88,
1162 p_information89,
1163 p_information90,
1164 p_information91,
1165 p_information92,
1166 p_information93,
1167 p_information94,
1168 p_information95,
1169 p_information96,
1170 p_information97,
1171 p_information98,
1172 p_information99,
1173 p_information100,
1174 p_information101,
1175 p_information102,
1176 p_information103,
1177 p_information104,
1178 p_information105,
1179 p_information106,
1180 p_information107,
1181 p_information108,
1182 p_information109,
1183 p_information110,
1184 p_information111,
1185 p_information112,
1186 p_information113,
1187 p_information114,
1188 p_information115,
1189 p_information116,
1190 p_information117,
1191 p_information118,
1192 p_information119,
1193 p_information120,
1194 p_information121,
1195 p_information122,
1196 p_information123,
1197 p_information124,
1198 p_information125,
1199 p_information126,
1200 p_information127,
1201 p_information128,
1202 p_information129,
1203 p_information130,
1204 p_information131,
1205 p_information132,
1206 p_information133,
1207 p_information134,
1208 p_information135,
1209 p_information136,
1210 p_information137,
1211 p_information138,
1212 p_information139,
1213 p_information140,
1214 p_information141,
1215 p_information142,
1216 p_information143,
1217 p_information144,
1218 p_information145,
1219 p_information146,
1220 p_information147,
1221 p_information148,
1222 p_information149,
1223 p_information150,
1224 p_information151,
1225 p_information152,
1226 p_information153,
1227 p_information154,
1228 p_information155,
1229 p_information156,
1230 p_information157,
1231 p_information158,
1232 p_information159,
1233 p_information160,
1234 p_information161,
1235 p_information162,
1236 p_information163,
1237 p_information164,
1238 p_information165,
1239 p_information166,
1240 p_information167,
1241 p_information168,
1242 p_information169,
1243 p_information170,
1244 p_information171,
1245 p_information172,
1246 p_information173,
1247 p_information174,
1248 p_information175,
1249 p_information176,
1250 p_information177,
1251 p_information178,
1252 p_information179,
1253 p_information180,
1254 p_information181,
1255 p_information182,
1256 p_information183,
1257 p_information184,
1258 p_information185,
1259 p_information186,
1260 p_information187,
1261 p_information188,
1262 p_information189,
1263 p_information190,
1264 p_mirror_entity_result_id,
1265 p_mirror_src_entity_result_id,
1266 p_parent_entity_result_id,
1267 p_table_route_id,
1268 p_long_attribute1,
1269 null
1270 );
1271 --
1272 -- Having converted the arguments into the pqh_cer_rec
1273 -- plsql record structure we call the corresponding record business process.
1274 --
1275 ins(
1276 p_effective_date,l_rec);
1277 --
1278 -- As the primary key argument(s)
1279 -- are specified as an OUT's we must set these values.
1280 --
1281 p_copy_entity_result_id := l_rec.copy_entity_result_id;
1282 p_object_version_number := l_rec.object_version_number;
1283 --
1284 hr_utility.set_location(' Leaving:'||l_proc, 10);
1285 End ins;
1286 --
1287 end pqh_cer_ins;