[Home] [Help]
PACKAGE BODY: APPS.BEN_CPE_INS
Source
1 Package Body ben_cpe_ins as
2 /* $Header: becperhi.pkb 120.0 2005/05/28 01:12:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_cpe_ins.'; -- Global package name
9 --
10 -- The following global variables are only to be used by
11 -- the set_base_key_value and pre_insert procedures.
12 --
13 g_copy_entity_result_id_i number default null;
14 --
15 -- ----------------------------------------------------------------------------
16 -- |------------------------< set_base_key_value >----------------------------|
17 -- ----------------------------------------------------------------------------
18 procedure set_base_key_value
19 (p_copy_entity_result_id in number) is
20 --
21 l_proc varchar2(72) := g_package||'set_base_key_value';
22 --
23 Begin
24 hr_utility.set_location('Entering:'||l_proc, 10);
25 --
26 ben_cpe_ins.g_copy_entity_result_id_i := p_copy_entity_result_id;
27 --
28 hr_utility.set_location(' Leaving:'||l_proc, 20);
29 End set_base_key_value;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |------------------------------< insert_dml >------------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the actual dml insert logic. The processing of
39 -- this procedure are as follows:
40 -- 1) Initialise the object_version_number to 1 if the object_version_number
41 -- is defined as an attribute for this entity.
42 -- 2) To set and unset the g_api_dml status as required (as we are about to
43 -- perform dml).
44 -- 3) To insert the row into the schema.
45 -- 4) To trap any constraint violations that may have occurred.
46 -- 5) To raise any other errors.
47 --
48 -- Prerequisites:
49 -- This is an internal private procedure which must be called from the ins
50 -- procedure and must have all mandatory attributes set (except the
51 -- object_version_number which is initialised within this procedure).
52 --
53 -- In Parameters:
54 -- A Pl/Sql record structre.
55 --
56 -- Post Success:
57 -- The specified row will be inserted into the schema.
58 --
59 -- Post Failure:
60 -- On the insert dml failure it is important to note that we always reset the
61 -- g_api_dml status to false.
62 -- If a check, unique or parent integrity constraint violation is raised the
63 -- constraint_error procedure will be called.
64 -- If any other error is reported, the error will be raised after the
65 -- g_api_dml status is reset.
66 --
67 -- Developer Implementation Notes:
68 -- None.
69 --
70 -- Access Status:
71 -- Internal Row Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 Procedure insert_dml
76 (p_rec in out nocopy ben_cpe_shd.g_rec_type
77 ) is
78 --
79 l_proc varchar2(72) := g_package||'insert_dml';
80 --
81 Begin
82 hr_utility.set_location('Entering:'||l_proc, 5);
83 p_rec.object_version_number := 1; -- Initialise the object version
84 --
85 ben_cpe_shd.g_api_dml := true; -- Set the api dml status
86 --
87 -- Insert the row into: ben_copy_entity_results
88 --
89 insert into ben_copy_entity_results
90 (copy_entity_result_id
91 ,copy_entity_txn_id
92 ,src_copy_entity_result_id
93 ,result_type_cd
94 ,number_of_copies
95 ,mirror_entity_result_id
96 ,mirror_src_entity_result_id
97 ,parent_entity_result_id
98 ,pd_mirror_src_entity_result_id
99 ,pd_parent_entity_result_id
100 ,gs_mirror_src_entity_result_id
101 ,gs_parent_entity_result_id
102 ,table_name
103 ,table_alias
104 ,table_route_id
105 ,status
106 ,dml_operation
107 ,information_category
108 ,information1
109 ,information2
110 ,information3
111 ,information4
112 ,information5
113 ,information6
114 ,information7
115 ,information8
116 ,information9
117 ,information10
118 ,information11
119 ,information12
120 ,information13
121 ,information14
122 ,information15
123 ,information16
124 ,information17
125 ,information18
126 ,information19
127 ,information20
128 ,information21
129 ,information22
130 ,information23
131 ,information24
132 ,information25
133 ,information26
134 ,information27
135 ,information28
136 ,information29
137 ,information30
138 ,information31
139 ,information32
140 ,information33
141 ,information34
142 ,information35
143 ,information36
144 ,information37
145 ,information38
146 ,information39
147 ,information40
148 ,information41
149 ,information42
150 ,information43
151 ,information44
152 ,information45
153 ,information46
154 ,information47
155 ,information48
156 ,information49
157 ,information50
158 ,information51
159 ,information52
160 ,information53
161 ,information54
162 ,information55
163 ,information56
164 ,information57
165 ,information58
166 ,information59
167 ,information60
168 ,information61
169 ,information62
170 ,information63
171 ,information64
172 ,information65
173 ,information66
174 ,information67
175 ,information68
176 ,information69
177 ,information70
178 ,information71
179 ,information72
180 ,information73
181 ,information74
182 ,information75
183 ,information76
184 ,information77
185 ,information78
186 ,information79
187 ,information80
188 ,information81
189 ,information82
190 ,information83
191 ,information84
192 ,information85
193 ,information86
194 ,information87
195 ,information88
196 ,information89
197 ,information90
198 ,information91
199 ,information92
200 ,information93
201 ,information94
202 ,information95
203 ,information96
204 ,information97
205 ,information98
206 ,information99
207 ,information100
208 ,information101
209 ,information102
210 ,information103
211 ,information104
212 ,information105
213 ,information106
214 ,information107
215 ,information108
216 ,information109
217 ,information110
218 ,information111
219 ,information112
220 ,information113
221 ,information114
222 ,information115
223 ,information116
224 ,information117
225 ,information118
226 ,information119
227 ,information120
228 ,information121
229 ,information122
230 ,information123
231 ,information124
232 ,information125
233 ,information126
234 ,information127
235 ,information128
236 ,information129
237 ,information130
238 ,information131
239 ,information132
240 ,information133
241 ,information134
242 ,information135
243 ,information136
244 ,information137
245 ,information138
246 ,information139
247 ,information140
248 ,information141
249 ,information142
250
251 /* Extra Reserved Columns
252 ,information143
253 ,information144
254 ,information145
255 ,information146
256 ,information147
257 ,information148
258 ,information149
259 ,information150
260 */
261 ,information151
262 ,information152
263 ,information153
264
265 /* Extra Reserved Columns
266 ,information154
267 ,information155
268 ,information156
269 ,information157
270 ,information158
271 ,information159
272 */
273 ,information160
274 ,information161
275 ,information162
276
277 /* Extra Reserved Columns
278 ,information163
279 ,information164
280 ,information165
281 */
282 ,information166
283 ,information167
284 ,information168
285 ,information169
286 ,information170
287
288 /* Extra Reserved Columns
289 ,information171
290 ,information172
291 */
292 ,information173
293 ,information174
294 ,information175
295 ,information176
296 ,information177
297 ,information178
298 ,information179
299 ,information180
300 ,information181
301 ,information182
302
303 /* Extra Reserved Columns
304 ,information183
305 ,information184
306 */
307 ,information185
308 ,information186
309 ,information187
310 ,information188
311
312 /* Extra Reserved Columns
313 ,information189
314 */
315 ,information190
316 ,information191
317 ,information192
318 ,information193
319 ,information194
320 ,information195
321 ,information196
322 ,information197
323 ,information198
324 ,information199
325
326 /* Extra Reserved Columns
327 ,information200
328 ,information201
329 ,information202
330 ,information203
331 ,information204
332 ,information205
333 ,information206
334 ,information207
335 ,information208
336 ,information209
337 ,information210
338 ,information211
339 ,information212
340 ,information213
341 ,information214
342 ,information215
343 */
344 ,information216
345 ,information217
346 ,information218
347 ,information219
348 ,information220
349 ,information221
350 ,information222
351 ,information223
352 ,information224
353 ,information225
354 ,information226
355 ,information227
356 ,information228
357 ,information229
358 ,information230
359 ,information231
360 ,information232
361 ,information233
362 ,information234
363 ,information235
364 ,information236
365 ,information237
366 ,information238
367 ,information239
368 ,information240
369 ,information241
370 ,information242
371 ,information243
372 ,information244
373 ,information245
374 ,information246
375 ,information247
376 ,information248
377 ,information249
378 ,information250
379 ,information251
380 ,information252
381 ,information253
382 ,information254
383 ,information255
384 ,information256
385 ,information257
386 ,information258
387 ,information259
388 ,information260
389 ,information261
390 ,information262
391 ,information263
392 ,information264
393 ,information265
394 ,information266
395 ,information267
396 ,information268
397 ,information269
398 ,information270
399 ,information271
400 ,information272
401 ,information273
402 ,information274
403 ,information275
404 ,information276
405 ,information277
406 ,information278
407 ,information279
408 ,information280
409 ,information281
410 ,information282
411 ,information283
412 ,information284
413 ,information285
414 ,information286
415 ,information287
416 ,information288
417 ,information289
418 ,information290
419 ,information291
420 ,information292
421 ,information293
422 ,information294
423 ,information295
424 ,information296
425 ,information297
426 ,information298
427 ,information299
428 ,information300
429 ,information301
430 ,information302
431 ,information303
432 ,information304
433
434 /* Extra Reserved Columns
435 ,information305
436 */
437 ,information306
438 ,information307
439 ,information308
440 ,information309
441 ,information310
442 ,information311
443 ,information312
444 ,information313
445 ,information314
446 ,information315
447 ,information316
448 ,information317
449 ,information318
450 ,information319
451 ,information320
452
453 /* Extra Reserved Columns
454 ,information321
455 ,information322
456 */
457 ,information323
458 ,datetrack_mode
459 ,object_version_number
460 )
461 Values
462 (p_rec.copy_entity_result_id
463 ,p_rec.copy_entity_txn_id
464 ,p_rec.src_copy_entity_result_id
465 ,p_rec.result_type_cd
466 ,p_rec.number_of_copies
467 ,nvl(p_rec.mirror_entity_result_id,p_rec.copy_entity_result_id)
468 ,p_rec.mirror_src_entity_result_id
469 ,p_rec.parent_entity_result_id
470 ,p_rec.pd_mirror_src_entity_result_id
471 ,p_rec.pd_parent_entity_result_id
472 ,p_rec.gs_mirror_src_entity_result_id
473 ,p_rec.gs_parent_entity_result_id
474 ,p_rec.table_name
475 ,p_rec.table_alias
476 ,p_rec.table_route_id
477 ,p_rec.status
478 ,p_rec.dml_operation
479 ,p_rec.information_category
480 ,p_rec.information1
481 ,p_rec.information2
482 ,p_rec.information3
483 ,p_rec.information4
484 ,p_rec.information5
485 ,p_rec.information6
486 ,p_rec.information7
487 ,p_rec.information8
488 ,p_rec.information9
489 ,p_rec.information10
490 ,p_rec.information11
491 ,p_rec.information12
492 ,p_rec.information13
493 ,p_rec.information14
494 ,p_rec.information15
495 ,p_rec.information16
496 ,p_rec.information17
497 ,p_rec.information18
498 ,p_rec.information19
499 ,p_rec.information20
500 ,p_rec.information21
501 ,p_rec.information22
502 ,p_rec.information23
503 ,p_rec.information24
504 ,p_rec.information25
508 ,p_rec.information29
505 ,p_rec.information26
506 ,p_rec.information27
507 ,p_rec.information28
509 ,p_rec.information30
510 ,p_rec.information31
511 ,p_rec.information32
512 ,p_rec.information33
513 ,p_rec.information34
514 ,p_rec.information35
515 ,p_rec.information36
516 ,p_rec.information37
517 ,p_rec.information38
518 ,p_rec.information39
519 ,p_rec.information40
520 ,p_rec.information41
521 ,p_rec.information42
522 ,p_rec.information43
523 ,p_rec.information44
524 ,p_rec.information45
525 ,p_rec.information46
526 ,p_rec.information47
527 ,p_rec.information48
528 ,p_rec.information49
529 ,p_rec.information50
530 ,p_rec.information51
531 ,p_rec.information52
532 ,p_rec.information53
533 ,p_rec.information54
534 ,p_rec.information55
535 ,p_rec.information56
536 ,p_rec.information57
537 ,p_rec.information58
538 ,p_rec.information59
539 ,p_rec.information60
540 ,p_rec.information61
541 ,p_rec.information62
542 ,p_rec.information63
543 ,p_rec.information64
544 ,p_rec.information65
545 ,p_rec.information66
546 ,p_rec.information67
547 ,p_rec.information68
548 ,p_rec.information69
549 ,p_rec.information70
550 ,p_rec.information71
551 ,p_rec.information72
552 ,p_rec.information73
553 ,p_rec.information74
554 ,p_rec.information75
555 ,p_rec.information76
556 ,p_rec.information77
557 ,p_rec.information78
558 ,p_rec.information79
559 ,p_rec.information80
560 ,p_rec.information81
561 ,p_rec.information82
562 ,p_rec.information83
563 ,p_rec.information84
564 ,p_rec.information85
565 ,p_rec.information86
566 ,p_rec.information87
567 ,p_rec.information88
568 ,p_rec.information89
569 ,p_rec.information90
570 ,p_rec.information91
571 ,p_rec.information92
572 ,p_rec.information93
573 ,p_rec.information94
574 ,p_rec.information95
575 ,p_rec.information96
576 ,p_rec.information97
577 ,p_rec.information98
578 ,p_rec.information99
579 ,p_rec.information100
580 ,p_rec.information101
581 ,p_rec.information102
582 ,p_rec.information103
583 ,p_rec.information104
584 ,p_rec.information105
585 ,p_rec.information106
586 ,p_rec.information107
587 ,p_rec.information108
588 ,p_rec.information109
589 ,p_rec.information110
590 ,p_rec.information111
591 ,p_rec.information112
592 ,p_rec.information113
593 ,p_rec.information114
594 ,p_rec.information115
595 ,p_rec.information116
596 ,p_rec.information117
597 ,p_rec.information118
598 ,p_rec.information119
599 ,p_rec.information120
600 ,p_rec.information121
601 ,p_rec.information122
602 ,p_rec.information123
603 ,p_rec.information124
604 ,p_rec.information125
605 ,p_rec.information126
606 ,p_rec.information127
607 ,p_rec.information128
608 ,p_rec.information129
609 ,p_rec.information130
610 ,p_rec.information131
611 ,p_rec.information132
612 ,p_rec.information133
613 ,p_rec.information134
614 ,p_rec.information135
615 ,p_rec.information136
616 ,p_rec.information137
617 ,p_rec.information138
618 ,p_rec.information139
619 ,p_rec.information140
620 ,p_rec.information141
621 ,p_rec.information142
622
623 /* Extra Reserved Columns
624 ,p_rec.information143
625 ,p_rec.information144
626 ,p_rec.information145
627 ,p_rec.information146
628 ,p_rec.information147
629 ,p_rec.information148
630 ,p_rec.information149
631 ,p_rec.information150
632 */
633 ,p_rec.information151
634 ,p_rec.information152
635 ,p_rec.information153
636
637 /* Extra Reserved Columns
638 ,p_rec.information154
639 ,p_rec.information155
640 ,p_rec.information156
641 ,p_rec.information157
642 ,p_rec.information158
643 ,p_rec.information159
644 */
645 ,p_rec.information160
646 ,p_rec.information161
647 ,p_rec.information162
648
649 /* Extra Reserved Columns
650 ,p_rec.information163
651 ,p_rec.information164
652 ,p_rec.information165
653 */
654 ,p_rec.information166
655 ,p_rec.information167
656 ,p_rec.information168
657 ,p_rec.information169
658 ,p_rec.information170
659
660 /* Extra Reserved Columns
661 ,p_rec.information171
662 ,p_rec.information172
663 */
664 ,p_rec.information173
665 ,p_rec.information174
666 ,p_rec.information175
667 ,p_rec.information176
668 ,p_rec.information177
669 ,p_rec.information178
670 ,p_rec.information179
671 ,p_rec.information180
672 ,p_rec.information181
673 ,p_rec.information182
674
675 /* Extra Reserved Columns
676 ,p_rec.information183
677 ,p_rec.information184
678 */
682 ,p_rec.information188
679 ,p_rec.information185
680 ,p_rec.information186
681 ,p_rec.information187
683
684 /* Extra Reserved Columns
685 ,p_rec.information189
686 */
687 ,p_rec.information190
688 ,p_rec.information191
689 ,p_rec.information192
690 ,p_rec.information193
691 ,p_rec.information194
692 ,p_rec.information195
693 ,p_rec.information196
694 ,p_rec.information197
695 ,p_rec.information198
696 ,p_rec.information199
697
698 /* Extra Reserved Columns
699 ,p_rec.information200
700 ,p_rec.information201
701 ,p_rec.information202
702 ,p_rec.information203
703 ,p_rec.information204
704 ,p_rec.information205
705 ,p_rec.information206
706 ,p_rec.information207
707 ,p_rec.information208
708 ,p_rec.information209
709 ,p_rec.information210
710 ,p_rec.information211
711 ,p_rec.information212
712 ,p_rec.information213
713 ,p_rec.information214
714 ,p_rec.information215
715 */
716 ,p_rec.information216
717 ,p_rec.information217
718 ,p_rec.information218
719 ,p_rec.information219
720 ,p_rec.information220
721 ,p_rec.information221
722 ,p_rec.information222
723 ,p_rec.information223
724 ,p_rec.information224
725 ,p_rec.information225
726 ,p_rec.information226
727 ,p_rec.information227
728 ,p_rec.information228
729 ,p_rec.information229
730 ,p_rec.information230
731 ,p_rec.information231
732 ,p_rec.information232
733 ,p_rec.information233
734 ,p_rec.information234
735 ,p_rec.information235
736 ,p_rec.information236
737 ,p_rec.information237
738 ,p_rec.information238
739 ,p_rec.information239
740 ,p_rec.information240
741 ,p_rec.information241
742 ,p_rec.information242
743 ,p_rec.information243
744 ,p_rec.information244
745 ,p_rec.information245
746 ,p_rec.information246
747 ,p_rec.information247
748 ,p_rec.information248
749 ,p_rec.information249
750 ,p_rec.information250
751 ,p_rec.information251
752 ,p_rec.information252
753 ,p_rec.information253
754 ,p_rec.information254
755 ,p_rec.information255
756 ,p_rec.information256
757 ,p_rec.information257
758 ,p_rec.information258
759 ,p_rec.information259
760 ,p_rec.information260
761 ,p_rec.information261
762 ,p_rec.information262
763 ,p_rec.information263
764 ,p_rec.information264
765 ,p_rec.information265
766 ,p_rec.information266
767 ,p_rec.information267
768 ,p_rec.information268
769 ,p_rec.information269
770 ,p_rec.information270
771 ,p_rec.information271
772 ,p_rec.information272
773 ,p_rec.information273
774 ,p_rec.information274
775 ,p_rec.information275
776 ,p_rec.information276
777 ,p_rec.information277
778 ,p_rec.information278
779 ,p_rec.information279
780 ,p_rec.information280
781 ,p_rec.information281
782 ,p_rec.information282
783 ,p_rec.information283
784 ,p_rec.information284
785 ,p_rec.information285
786 ,p_rec.information286
787 ,p_rec.information287
788 ,p_rec.information288
789 ,p_rec.information289
790 ,p_rec.information290
791 ,p_rec.information291
792 ,p_rec.information292
793 ,p_rec.information293
794 ,p_rec.information294
795 ,p_rec.information295
796 ,p_rec.information296
797 ,p_rec.information297
798 ,p_rec.information298
799 ,p_rec.information299
800 ,p_rec.information300
801 ,p_rec.information301
802 ,p_rec.information302
803 ,p_rec.information303
804 ,p_rec.information304
805
806 /* Extra Reserved Columns
807 ,p_rec.information305
808 */
809 ,p_rec.information306
810 ,p_rec.information307
811 ,p_rec.information308
812 ,p_rec.information309
813 ,p_rec.information310
814 ,p_rec.information311
815 ,p_rec.information312
816 ,p_rec.information313
817 ,p_rec.information314
818 ,p_rec.information315
819 ,p_rec.information316
820 ,p_rec.information317
821 ,p_rec.information318
822 ,p_rec.information319
823 ,p_rec.information320
824
825 /* Extra Reserved Columns
826 ,p_rec.information321
827 ,p_rec.information322
828 */
829 ,p_rec.information323
830 ,p_rec.datetrack_mode
831 ,p_rec.object_version_number
832 );
833 --
834 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
835 --
836 hr_utility.set_location(' Leaving:'||l_proc, 10);
837 Exception
838 When hr_api.check_integrity_violated Then
839 -- A check constraint has been violated
840 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
841 ben_cpe_shd.constraint_error
842 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
843 When hr_api.parent_integrity_violated Then
844 -- Parent integrity has been violated
848 When hr_api.unique_integrity_violated Then
845 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
846 ben_cpe_shd.constraint_error
847 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
849 -- Unique integrity has been violated
850 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
851 ben_cpe_shd.constraint_error
852 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
853 When Others Then
854 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
855 Raise;
856 End insert_dml;
857 --
858 -- ----------------------------------------------------------------------------
859 -- |------------------------------< pre_insert >------------------------------|
860 -- ----------------------------------------------------------------------------
861 -- {Start Of Comments}
862 --
863 -- Description:
864 -- This private procedure contains any processing which is required before
865 -- the insert dml. Presently, if the entity has a corresponding primary
866 -- key which is maintained by an associating sequence, the primary key for
867 -- the entity will be populated with the next sequence value in
868 -- preparation for the insert dml.
869 --
870 -- Prerequisites:
871 -- This is an internal procedure which is called from the ins procedure.
872 --
873 -- In Parameters:
874 -- A Pl/Sql record structure.
875 --
876 -- Post Success:
877 -- Processing continues.
878 --
879 -- Post Failure:
880 -- If an error has occurred, an error message and exception will be raised
881 -- but not handled.
882 --
883 -- Developer Implementation Notes:
884 -- Any pre-processing required before the insert dml is issued should be
885 -- coded within this procedure. As stated above, a good example is the
886 -- generation of a primary key number via a corresponding sequence.
887 -- It is important to note that any 3rd party maintenance should be reviewed
888 -- before placing in this procedure.
889 --
890 -- Access Status:
891 -- Internal Row Handler Use Only.
892 --
893 -- {End Of Comments}
894 -- ----------------------------------------------------------------------------
895 Procedure pre_insert
896 (p_rec in out nocopy ben_cpe_shd.g_rec_type
897 ) is
898 --
899 Cursor C_Sel1 is select ben_copy_entity_results_s.nextval from sys.dual;
900 --
901 Cursor C_Sel2 is
902 Select null
903 from ben_copy_entity_results
904 where copy_entity_result_id =
905 ben_cpe_ins.g_copy_entity_result_id_i;
906 --
907 l_proc varchar2(72) := g_package||'pre_insert';
908 l_exists varchar2(1);
909 --
910 Begin
911 hr_utility.set_location('Entering:'||l_proc, 5);
912 --
913 If (ben_cpe_ins.g_copy_entity_result_id_i is not null) Then
914 --
915 -- Verify registered primary key values not already in use
916 --
917 Open C_Sel2;
918 Fetch C_Sel2 into l_exists;
919 If C_Sel2%found Then
920 Close C_Sel2;
921 --
922 -- The primary key values are already in use.
923 --
924 fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
925 fnd_message.set_token('TABLE_NAME','ben_copy_entity_results');
926 fnd_message.raise_error;
927 End If;
928 Close C_Sel2;
929 --
930 -- Use registered key values and clear globals
931 --
932 p_rec.copy_entity_result_id :=
933 ben_cpe_ins.g_copy_entity_result_id_i;
934 ben_cpe_ins.g_copy_entity_result_id_i := null;
935 Else
936 --
937 -- No registerd key values, so select the next sequence number
938 --
939 --
940 -- Select the next sequence number
941 --
942 Open C_Sel1;
943 Fetch C_Sel1 Into p_rec.copy_entity_result_id;
944 Close C_Sel1;
945 End If;
946 --
947 hr_utility.set_location(' Leaving:'||l_proc, 10);
948 End pre_insert;
949 --
950 -- ----------------------------------------------------------------------------
951 -- |-----------------------------< post_insert >------------------------------|
952 -- ----------------------------------------------------------------------------
953 -- {Start Of Comments}
954 --
955 -- Description:
956 -- This private procedure contains any processing which is required after
957 -- the insert dml.
958 --
959 -- Prerequisites:
960 -- This is an internal procedure which is called from the ins procedure.
961 --
962 -- In Parameters:
963 -- A Pl/Sql record structre.
964 --
965 -- Post Success:
966 -- Processing continues.
967 --
968 -- Post Failure:
969 -- If an error has occurred, an error message and exception will be raised
970 -- but not handled.
971 --
972 -- Developer Implementation Notes:
973 -- Any post-processing required after the insert dml is issued should be
974 -- coded within this procedure. It is important to note that any 3rd party
975 -- maintenance should be reviewed before placing in this procedure.
976 --
977 -- Access Status:
978 -- Internal Row Handler Use Only.
979 --
980 -- {End Of Comments}
981 -- ----------------------------------------------------------------------------
982 Procedure post_insert
983 (p_effective_date in date
984 ,p_rec in ben_cpe_shd.g_rec_type
985 ) is
986 --
990 hr_utility.set_location('Entering:'||l_proc, 5);
987 l_proc varchar2(72) := g_package||'post_insert';
988 --
989 Begin
991 begin
992 --
993 ben_cpe_rki.after_insert
994 (p_effective_date => p_effective_date
995 ,p_copy_entity_result_id
996 => p_rec.copy_entity_result_id
997 ,p_copy_entity_txn_id
998 => p_rec.copy_entity_txn_id
999 ,p_src_copy_entity_result_id
1000 => p_rec.src_copy_entity_result_id
1001 ,p_result_type_cd
1002 => p_rec.result_type_cd
1003 ,p_number_of_copies
1004 => p_rec.number_of_copies
1005 ,p_mirror_entity_result_id
1006 => p_rec.mirror_entity_result_id
1007 ,p_mirror_src_entity_result_id
1008 => p_rec.mirror_src_entity_result_id
1009 ,p_parent_entity_result_id
1010 => p_rec.parent_entity_result_id
1011 ,p_pd_mr_src_entity_result_id
1012 => p_rec.pd_mirror_src_entity_result_id
1013 ,p_pd_parent_entity_result_id
1014 => p_rec.pd_parent_entity_result_id
1015 ,p_gs_mr_src_entity_result_id
1016 => p_rec.gs_mirror_src_entity_result_id
1017 ,p_gs_parent_entity_result_id
1018 => p_rec.gs_parent_entity_result_id
1019 ,p_table_name
1020 => p_rec.table_name
1021 ,p_table_alias
1022 => p_rec.table_alias
1023 ,p_table_route_id
1024 => p_rec.table_route_id
1025 ,p_status
1026 => p_rec.status
1027 ,p_dml_operation
1028 => p_rec.dml_operation
1029 ,p_information_category
1030 => p_rec.information_category
1031 ,p_information1
1032 => p_rec.information1
1033 ,p_information2
1034 => p_rec.information2
1035 ,p_information3
1036 => p_rec.information3
1037 ,p_information4
1038 => p_rec.information4
1039 ,p_information5
1040 => p_rec.information5
1041 ,p_information6
1042 => p_rec.information6
1043 ,p_information7
1044 => p_rec.information7
1045 ,p_information8
1046 => p_rec.information8
1047 ,p_information9
1048 => p_rec.information9
1049 ,p_information10
1050 => p_rec.information10
1051 ,p_information11
1052 => p_rec.information11
1053 ,p_information12
1054 => p_rec.information12
1055 ,p_information13
1056 => p_rec.information13
1057 ,p_information14
1058 => p_rec.information14
1059 ,p_information15
1060 => p_rec.information15
1061 ,p_information16
1062 => p_rec.information16
1063 ,p_information17
1064 => p_rec.information17
1065 ,p_information18
1066 => p_rec.information18
1067 ,p_information19
1068 => p_rec.information19
1069 ,p_information20
1070 => p_rec.information20
1071 ,p_information21
1072 => p_rec.information21
1073 ,p_information22
1074 => p_rec.information22
1075 ,p_information23
1076 => p_rec.information23
1077 ,p_information24
1078 => p_rec.information24
1079 ,p_information25
1080 => p_rec.information25
1081 ,p_information26
1082 => p_rec.information26
1083 ,p_information27
1084 => p_rec.information27
1085 ,p_information28
1086 => p_rec.information28
1087 ,p_information29
1088 => p_rec.information29
1089 ,p_information30
1090 => p_rec.information30
1091 ,p_information31
1092 => p_rec.information31
1093 ,p_information32
1094 => p_rec.information32
1095 ,p_information33
1096 => p_rec.information33
1097 ,p_information34
1098 => p_rec.information34
1099 ,p_information35
1100 => p_rec.information35
1101 ,p_information36
1102 => p_rec.information36
1103 ,p_information37
1104 => p_rec.information37
1105 ,p_information38
1106 => p_rec.information38
1107 ,p_information39
1108 => p_rec.information39
1109 ,p_information40
1110 => p_rec.information40
1111 ,p_information41
1112 => p_rec.information41
1113 ,p_information42
1114 => p_rec.information42
1115 ,p_information43
1116 => p_rec.information43
1117 ,p_information44
1118 => p_rec.information44
1119 ,p_information45
1120 => p_rec.information45
1121 ,p_information46
1122 => p_rec.information46
1123 ,p_information47
1124 => p_rec.information47
1125 ,p_information48
1126 => p_rec.information48
1127 ,p_information49
1128 => p_rec.information49
1129 ,p_information50
1130 => p_rec.information50
1131 ,p_information51
1132 => p_rec.information51
1133 ,p_information52
1134 => p_rec.information52
1135 ,p_information53
1136 => p_rec.information53
1137 ,p_information54
1138 => p_rec.information54
1139 ,p_information55
1140 => p_rec.information55
1141 ,p_information56
1142 => p_rec.information56
1143 ,p_information57
1144 => p_rec.information57
1145 ,p_information58
1146 => p_rec.information58
1147 ,p_information59
1148 => p_rec.information59
1149 ,p_information60
1150 => p_rec.information60
1151 ,p_information61
1152 => p_rec.information61
1153 ,p_information62
1154 => p_rec.information62
1155 ,p_information63
1156 => p_rec.information63
1157 ,p_information64
1158 => p_rec.information64
1159 ,p_information65
1160 => p_rec.information65
1161 ,p_information66
1162 => p_rec.information66
1163 ,p_information67
1164 => p_rec.information67
1165 ,p_information68
1166 => p_rec.information68
1167 ,p_information69
1168 => p_rec.information69
1169 ,p_information70
1170 => p_rec.information70
1171 ,p_information71
1172 => p_rec.information71
1173 ,p_information72
1174 => p_rec.information72
1175 ,p_information73
1176 => p_rec.information73
1177 ,p_information74
1178 => p_rec.information74
1179 ,p_information75
1180 => p_rec.information75
1181 ,p_information76
1182 => p_rec.information76
1183 ,p_information77
1184 => p_rec.information77
1185 ,p_information78
1186 => p_rec.information78
1187 ,p_information79
1188 => p_rec.information79
1189 ,p_information80
1190 => p_rec.information80
1191 ,p_information81
1192 => p_rec.information81
1193 ,p_information82
1194 => p_rec.information82
1195 ,p_information83
1196 => p_rec.information83
1197 ,p_information84
1198 => p_rec.information84
1199 ,p_information85
1200 => p_rec.information85
1201 ,p_information86
1202 => p_rec.information86
1203 ,p_information87
1204 => p_rec.information87
1205 ,p_information88
1206 => p_rec.information88
1207 ,p_information89
1208 => p_rec.information89
1209 ,p_information90
1210 => p_rec.information90
1211 ,p_information91
1212 => p_rec.information91
1213 ,p_information92
1214 => p_rec.information92
1215 ,p_information93
1216 => p_rec.information93
1217 ,p_information94
1218 => p_rec.information94
1219 ,p_information95
1220 => p_rec.information95
1221 ,p_information96
1222 => p_rec.information96
1223 ,p_information97
1224 => p_rec.information97
1225 ,p_information98
1226 => p_rec.information98
1227 ,p_information99
1228 => p_rec.information99
1229 ,p_information100
1230 => p_rec.information100
1231 ,p_information101
1232 => p_rec.information101
1233 ,p_information102
1234 => p_rec.information102
1235 ,p_information103
1236 => p_rec.information103
1237 ,p_information104
1238 => p_rec.information104
1239 ,p_information105
1240 => p_rec.information105
1241 ,p_information106
1242 => p_rec.information106
1243 ,p_information107
1244 => p_rec.information107
1245 ,p_information108
1246 => p_rec.information108
1247 ,p_information109
1248 => p_rec.information109
1249 ,p_information110
1250 => p_rec.information110
1251 ,p_information111
1252 => p_rec.information111
1253 ,p_information112
1254 => p_rec.information112
1255 ,p_information113
1256 => p_rec.information113
1257 ,p_information114
1258 => p_rec.information114
1259 ,p_information115
1260 => p_rec.information115
1261 ,p_information116
1262 => p_rec.information116
1263 ,p_information117
1264 => p_rec.information117
1265 ,p_information118
1266 => p_rec.information118
1267 ,p_information119
1268 => p_rec.information119
1269 ,p_information120
1270 => p_rec.information120
1271 ,p_information121
1272 => p_rec.information121
1273 ,p_information122
1274 => p_rec.information122
1275 ,p_information123
1276 => p_rec.information123
1277 ,p_information124
1278 => p_rec.information124
1279 ,p_information125
1280 => p_rec.information125
1281 ,p_information126
1282 => p_rec.information126
1283 ,p_information127
1284 => p_rec.information127
1285 ,p_information128
1286 => p_rec.information128
1287 ,p_information129
1288 => p_rec.information129
1289 ,p_information130
1290 => p_rec.information130
1291 ,p_information131
1292 => p_rec.information131
1293 ,p_information132
1294 => p_rec.information132
1295 ,p_information133
1296 => p_rec.information133
1300 => p_rec.information135
1297 ,p_information134
1298 => p_rec.information134
1299 ,p_information135
1301 ,p_information136
1302 => p_rec.information136
1303 ,p_information137
1304 => p_rec.information137
1305 ,p_information138
1306 => p_rec.information138
1307 ,p_information139
1308 => p_rec.information139
1309 ,p_information140
1310 => p_rec.information140
1311 ,p_information141
1312 => p_rec.information141
1313 ,p_information142
1314 => p_rec.information142
1315
1316 /* Extra Reserved Columns
1317 ,p_information143
1318 => p_rec.information143
1319 ,p_information144
1320 => p_rec.information144
1321 ,p_information145
1322 => p_rec.information145
1323 ,p_information146
1324 => p_rec.information146
1325 ,p_information147
1326 => p_rec.information147
1327 ,p_information148
1328 => p_rec.information148
1329 ,p_information149
1330 => p_rec.information149
1331 ,p_information150
1332 => p_rec.information150
1333 */
1334
1335 ,p_information151
1336 => p_rec.information151
1337 ,p_information152
1338 => p_rec.information152
1339 ,p_information153
1340 => p_rec.information153
1341
1342 /* Extra Reserved Columns
1343 ,p_information154
1344 => p_rec.information154
1345 ,p_information155
1346 => p_rec.information155
1347 ,p_information156
1348 => p_rec.information156
1349 ,p_information157
1350 => p_rec.information157
1351 ,p_information158
1352 => p_rec.information158
1353 ,p_information159
1354 => p_rec.information159
1355 */
1356
1357 ,p_information160
1358 => p_rec.information160
1359 ,p_information161
1360 => p_rec.information161
1361 ,p_information162
1362 => p_rec.information162
1363
1364 /* Extra Reserved Columns
1365 ,p_information163
1366 => p_rec.information163
1367 ,p_information164
1368 => p_rec.information164
1369 ,p_information165
1370 => p_rec.information165
1371 */
1372
1373 ,p_information166
1374 => p_rec.information166
1375 ,p_information167
1376 => p_rec.information167
1377 ,p_information168
1378 => p_rec.information168
1379 ,p_information169
1380 => p_rec.information169
1381 ,p_information170
1382 => p_rec.information170
1383
1384 /* Extra Reserved Columns
1385 ,p_information171
1386 => p_rec.information171
1387 ,p_information172
1388 => p_rec.information172
1389 */
1390
1391 ,p_information173
1392 => p_rec.information173
1393 ,p_information174
1394 => p_rec.information174
1395 ,p_information175
1396 => p_rec.information175
1397 ,p_information176
1398 => p_rec.information176
1399 ,p_information177
1400 => p_rec.information177
1401 ,p_information178
1402 => p_rec.information178
1403 ,p_information179
1404 => p_rec.information179
1405 ,p_information180
1406 => p_rec.information180
1407 ,p_information181
1408 => p_rec.information181
1409 ,p_information182
1410 => p_rec.information182
1411
1412 /* Extra Reserved Columns
1413 ,p_information183
1414 => p_rec.information183
1415 ,p_information184
1416 => p_rec.information184
1417 */
1418
1419 ,p_information185
1420 => p_rec.information185
1421 ,p_information186
1422 => p_rec.information186
1423 ,p_information187
1424 => p_rec.information187
1425 ,p_information188
1426 => p_rec.information188
1427
1428 /* Extra Reserved Columns
1429 ,p_information189
1430 => p_rec.information189
1431 */
1432 ,p_information190
1433 => p_rec.information190
1434 ,p_information191
1435 => p_rec.information191
1436 ,p_information192
1437 => p_rec.information192
1438 ,p_information193
1439 => p_rec.information193
1440 ,p_information194
1441 => p_rec.information194
1442 ,p_information195
1443 => p_rec.information195
1444 ,p_information196
1445 => p_rec.information196
1446 ,p_information197
1447 => p_rec.information197
1448 ,p_information198
1449 => p_rec.information198
1450 ,p_information199
1451 => p_rec.information199
1452
1453 /* Extra Reserved Columns
1454 ,p_information200
1455 => p_rec.information200
1456 ,p_information201
1457 => p_rec.information201
1458 ,p_information202
1459 => p_rec.information202
1460 ,p_information203
1461 => p_rec.information203
1465 => p_rec.information205
1462 ,p_information204
1463 => p_rec.information204
1464 ,p_information205
1466 ,p_information206
1467 => p_rec.information206
1468 ,p_information207
1469 => p_rec.information207
1470 ,p_information208
1471 => p_rec.information208
1472 ,p_information209
1473 => p_rec.information209
1474 ,p_information210
1475 => p_rec.information210
1476 ,p_information211
1477 => p_rec.information211
1478 ,p_information212
1479 => p_rec.information212
1480 ,p_information213
1481 => p_rec.information213
1482 ,p_information214
1483 => p_rec.information214
1484 ,p_information215
1485 => p_rec.information215
1486 */
1487
1488 ,p_information216
1489 => p_rec.information216
1490 ,p_information217
1491 => p_rec.information217
1492 ,p_information218
1493 => p_rec.information218
1494 ,p_information219
1495 => p_rec.information219
1496 ,p_information220
1497 => p_rec.information220
1498
1499 ,p_information221
1500 => p_rec.information221
1501 ,p_information222
1502 => p_rec.information222
1503 ,p_information223
1504 => p_rec.information223
1505 ,p_information224
1506 => p_rec.information224
1507 ,p_information225
1508 => p_rec.information225
1509 ,p_information226
1510 => p_rec.information226
1511 ,p_information227
1512 => p_rec.information227
1513 ,p_information228
1514 => p_rec.information228
1515 ,p_information229
1516 => p_rec.information229
1517 ,p_information230
1518 => p_rec.information230
1519 ,p_information231
1520 => p_rec.information231
1521 ,p_information232
1522 => p_rec.information232
1523 ,p_information233
1524 => p_rec.information233
1525 ,p_information234
1526 => p_rec.information234
1527 ,p_information235
1528 => p_rec.information235
1529 ,p_information236
1530 => p_rec.information236
1531 ,p_information237
1532 => p_rec.information237
1533 ,p_information238
1534 => p_rec.information238
1535 ,p_information239
1536 => p_rec.information239
1537 ,p_information240
1538 => p_rec.information240
1539 ,p_information241
1540 => p_rec.information241
1541 ,p_information242
1542 => p_rec.information242
1543 ,p_information243
1544 => p_rec.information243
1545 ,p_information244
1546 => p_rec.information244
1547 ,p_information245
1548 => p_rec.information245
1549 ,p_information246
1550 => p_rec.information246
1551 ,p_information247
1552 => p_rec.information247
1553 ,p_information248
1554 => p_rec.information248
1555 ,p_information249
1556 => p_rec.information249
1557 ,p_information250
1558 => p_rec.information250
1559 ,p_information251
1560 => p_rec.information251
1561 ,p_information252
1562 => p_rec.information252
1563 ,p_information253
1564 => p_rec.information253
1565 ,p_information254
1566 => p_rec.information254
1567 ,p_information255
1568 => p_rec.information255
1569 ,p_information256
1570 => p_rec.information256
1571 ,p_information257
1572 => p_rec.information257
1573 ,p_information258
1574 => p_rec.information258
1575 ,p_information259
1576 => p_rec.information259
1577 ,p_information260
1578 => p_rec.information260
1579 ,p_information261
1580 => p_rec.information261
1581 ,p_information262
1582 => p_rec.information262
1583 ,p_information263
1584 => p_rec.information263
1585 ,p_information264
1586 => p_rec.information264
1587 ,p_information265
1588 => p_rec.information265
1589 ,p_information266
1590 => p_rec.information266
1591 ,p_information267
1592 => p_rec.information267
1593 ,p_information268
1594 => p_rec.information268
1595 ,p_information269
1596 => p_rec.information269
1597 ,p_information270
1598 => p_rec.information270
1599 ,p_information271
1600 => p_rec.information271
1601 ,p_information272
1602 => p_rec.information272
1603 ,p_information273
1604 => p_rec.information273
1605 ,p_information274
1606 => p_rec.information274
1607 ,p_information275
1608 => p_rec.information275
1609 ,p_information276
1610 => p_rec.information276
1611 ,p_information277
1612 => p_rec.information277
1613 ,p_information278
1614 => p_rec.information278
1615 ,p_information279
1616 => p_rec.information279
1617 ,p_information280
1618 => p_rec.information280
1622 => p_rec.information282
1619 ,p_information281
1620 => p_rec.information281
1621 ,p_information282
1623 ,p_information283
1624 => p_rec.information283
1625 ,p_information284
1626 => p_rec.information284
1627 ,p_information285
1628 => p_rec.information285
1629 ,p_information286
1630 => p_rec.information286
1631 ,p_information287
1632 => p_rec.information287
1633 ,p_information288
1634 => p_rec.information288
1635 ,p_information289
1636 => p_rec.information289
1637 ,p_information290
1638 => p_rec.information290
1639 ,p_information291
1640 => p_rec.information291
1641 ,p_information292
1642 => p_rec.information292
1643 ,p_information293
1644 => p_rec.information293
1645 ,p_information294
1646 => p_rec.information294
1647 ,p_information295
1648 => p_rec.information295
1649 ,p_information296
1650 => p_rec.information296
1651 ,p_information297
1652 => p_rec.information297
1653 ,p_information298
1654 => p_rec.information298
1655 ,p_information299
1656 => p_rec.information299
1657 ,p_information300
1658 => p_rec.information300
1659 ,p_information301
1660 => p_rec.information301
1661 ,p_information302
1662 => p_rec.information302
1663 ,p_information303
1664 => p_rec.information303
1665 ,p_information304
1666 => p_rec.information304
1667
1668 /* Extra Reserved Columns
1669 ,p_information305
1670 => p_rec.information305
1671 */
1672 ,p_information306
1673 => p_rec.information306
1674 ,p_information307
1675 => p_rec.information307
1676 ,p_information308
1677 => p_rec.information308
1678 ,p_information309
1679 => p_rec.information309
1680 ,p_information310
1681 => p_rec.information310
1682 ,p_information311
1683 => p_rec.information311
1684 ,p_information312
1685 => p_rec.information312
1686 ,p_information313
1687 => p_rec.information313
1688 ,p_information314
1689 => p_rec.information314
1690 ,p_information315
1691 => p_rec.information315
1692 ,p_information316
1693 => p_rec.information316
1694 ,p_information317
1695 => p_rec.information317
1696 ,p_information318
1697 => p_rec.information318
1698 ,p_information319
1699 => p_rec.information319
1700 ,p_information320
1701 => p_rec.information320
1702
1703 /* Extra Reserved Columns
1704 ,p_information321
1705 => p_rec.information321
1706 ,p_information322
1707 => p_rec.information322
1708 */
1709 ,p_information323
1710 => p_rec.information323
1711
1712 ,p_datetrack_mode
1713 => p_rec.datetrack_mode
1714 ,p_object_version_number
1715 => p_rec.object_version_number
1716 );
1717 --
1718 exception
1719 --
1720 when hr_api.cannot_find_prog_unit then
1721 --
1722 hr_api.cannot_find_prog_unit_error
1723 (p_module_name => 'BEN_COPY_ENTITY_RESULTS'
1724 ,p_hook_type => 'AI');
1725 --
1726 end;
1727 --
1728 hr_utility.set_location(' Leaving:'||l_proc, 10);
1729 End post_insert;
1730 --
1731 -- ----------------------------------------------------------------------------
1732 -- |---------------------------------< ins >----------------------------------|
1733 -- ----------------------------------------------------------------------------
1734 Procedure ins
1735 (p_effective_date in date
1736 ,p_rec in out nocopy ben_cpe_shd.g_rec_type
1737 ) is
1738 --
1739 l_proc varchar2(72) := g_package||'ins';
1740 --
1741 Begin
1742 hr_utility.set_location('Entering:'||l_proc, 5);
1743 --
1744 -- Call the supporting insert validate operations
1745 --
1746 ben_cpe_bus.insert_validate
1747 (p_effective_date
1748 ,p_rec
1749 );
1750 --
1751 -- Call to raise any errors on multi-message list
1752 hr_multi_message.end_validation_set;
1753 --
1754 -- Call the supporting pre-insert operation
1755 --
1756 ben_cpe_ins.pre_insert(p_rec);
1757 --
1758 -- Insert the row
1759 --
1760 ben_cpe_ins.insert_dml(p_rec);
1761 --
1762 -- Call the supporting post-insert operation
1763 --
1764 ben_cpe_ins.post_insert
1765 (p_effective_date
1766 ,p_rec
1767 );
1768 --
1769 -- Call to raise any errors on multi-message list
1770 hr_multi_message.end_validation_set;
1771 --
1772 hr_utility.set_location('Leaving:'||l_proc, 20);
1773 end ins;
1774 --
1775 -- ----------------------------------------------------------------------------
1776 -- |---------------------------------< ins >----------------------------------|
1777 -- ----------------------------------------------------------------------------
1781 ,p_result_type_cd in varchar2
1778 Procedure ins
1779 (p_effective_date in date
1780 ,p_copy_entity_txn_id in number
1782 ,p_src_copy_entity_result_id in number default null
1783 ,p_number_of_copies in number default null
1784 ,p_mirror_entity_result_id in number default null
1785 ,p_mirror_src_entity_result_id in number default null
1786 ,p_parent_entity_result_id in number default null
1787 ,p_pd_mr_src_entity_result_id in number default null
1788 ,p_pd_parent_entity_result_id in number default null
1789 ,p_gs_mr_src_entity_result_id in number default null
1790 ,p_gs_parent_entity_result_id in number default null
1791 ,p_table_name in varchar2 default null
1792 ,p_table_alias in varchar2 default null
1793 ,p_table_route_id in number default null
1794 ,p_status in varchar2 default null
1795 ,p_dml_operation in varchar2 default null
1796 ,p_information_category in varchar2 default null
1797 ,p_information1 in number default null
1798 ,p_information2 in date default null
1799 ,p_information3 in date default null
1800 ,p_information4 in number default null
1801 ,p_information5 in varchar2 default null
1802 ,p_information6 in varchar2 default null
1803 ,p_information7 in varchar2 default null
1804 ,p_information8 in varchar2 default null
1805 ,p_information9 in varchar2 default null
1806 ,p_information10 in date default null
1807 ,p_information11 in varchar2 default null
1808 ,p_information12 in varchar2 default null
1809 ,p_information13 in varchar2 default null
1810 ,p_information14 in varchar2 default null
1811 ,p_information15 in varchar2 default null
1812 ,p_information16 in varchar2 default null
1813 ,p_information17 in varchar2 default null
1814 ,p_information18 in varchar2 default null
1815 ,p_information19 in varchar2 default null
1816 ,p_information20 in varchar2 default null
1817 ,p_information21 in varchar2 default null
1818 ,p_information22 in varchar2 default null
1819 ,p_information23 in varchar2 default null
1820 ,p_information24 in varchar2 default null
1821 ,p_information25 in varchar2 default null
1822 ,p_information26 in varchar2 default null
1823 ,p_information27 in varchar2 default null
1824 ,p_information28 in varchar2 default null
1825 ,p_information29 in varchar2 default null
1826 ,p_information30 in varchar2 default null
1827 ,p_information31 in varchar2 default null
1828 ,p_information32 in varchar2 default null
1829 ,p_information33 in varchar2 default null
1830 ,p_information34 in varchar2 default null
1831 ,p_information35 in varchar2 default null
1832 ,p_information36 in varchar2 default null
1833 ,p_information37 in varchar2 default null
1834 ,p_information38 in varchar2 default null
1835 ,p_information39 in varchar2 default null
1836 ,p_information40 in varchar2 default null
1837 ,p_information41 in varchar2 default null
1838 ,p_information42 in varchar2 default null
1839 ,p_information43 in varchar2 default null
1840 ,p_information44 in varchar2 default null
1841 ,p_information45 in varchar2 default null
1842 ,p_information46 in varchar2 default null
1843 ,p_information47 in varchar2 default null
1844 ,p_information48 in varchar2 default null
1845 ,p_information49 in varchar2 default null
1846 ,p_information50 in varchar2 default null
1847 ,p_information51 in varchar2 default null
1848 ,p_information52 in varchar2 default null
1849 ,p_information53 in varchar2 default null
1850 ,p_information54 in varchar2 default null
1851 ,p_information55 in varchar2 default null
1852 ,p_information56 in varchar2 default null
1853 ,p_information57 in varchar2 default null
1854 ,p_information58 in varchar2 default null
1855 ,p_information59 in varchar2 default null
1856 ,p_information60 in varchar2 default null
1857 ,p_information61 in varchar2 default null
1858 ,p_information62 in varchar2 default null
1859 ,p_information63 in varchar2 default null
1860 ,p_information64 in varchar2 default null
1861 ,p_information65 in varchar2 default null
1865 ,p_information69 in varchar2 default null
1862 ,p_information66 in varchar2 default null
1863 ,p_information67 in varchar2 default null
1864 ,p_information68 in varchar2 default null
1866 ,p_information70 in varchar2 default null
1867 ,p_information71 in varchar2 default null
1868 ,p_information72 in varchar2 default null
1869 ,p_information73 in varchar2 default null
1870 ,p_information74 in varchar2 default null
1871 ,p_information75 in varchar2 default null
1872 ,p_information76 in varchar2 default null
1873 ,p_information77 in varchar2 default null
1874 ,p_information78 in varchar2 default null
1875 ,p_information79 in varchar2 default null
1876 ,p_information80 in varchar2 default null
1877 ,p_information81 in varchar2 default null
1878 ,p_information82 in varchar2 default null
1879 ,p_information83 in varchar2 default null
1880 ,p_information84 in varchar2 default null
1881 ,p_information85 in varchar2 default null
1882 ,p_information86 in varchar2 default null
1883 ,p_information87 in varchar2 default null
1884 ,p_information88 in varchar2 default null
1885 ,p_information89 in varchar2 default null
1886 ,p_information90 in varchar2 default null
1887 ,p_information91 in varchar2 default null
1888 ,p_information92 in varchar2 default null
1889 ,p_information93 in varchar2 default null
1890 ,p_information94 in varchar2 default null
1891 ,p_information95 in varchar2 default null
1892 ,p_information96 in varchar2 default null
1893 ,p_information97 in varchar2 default null
1894 ,p_information98 in varchar2 default null
1895 ,p_information99 in varchar2 default null
1896 ,p_information100 in varchar2 default null
1897 ,p_information101 in varchar2 default null
1898 ,p_information102 in varchar2 default null
1899 ,p_information103 in varchar2 default null
1900 ,p_information104 in varchar2 default null
1901 ,p_information105 in varchar2 default null
1902 ,p_information106 in varchar2 default null
1903 ,p_information107 in varchar2 default null
1904 ,p_information108 in varchar2 default null
1905 ,p_information109 in varchar2 default null
1906 ,p_information110 in varchar2 default null
1907 ,p_information111 in varchar2 default null
1908 ,p_information112 in varchar2 default null
1909 ,p_information113 in varchar2 default null
1910 ,p_information114 in varchar2 default null
1911 ,p_information115 in varchar2 default null
1912 ,p_information116 in varchar2 default null
1913 ,p_information117 in varchar2 default null
1914 ,p_information118 in varchar2 default null
1915 ,p_information119 in varchar2 default null
1916 ,p_information120 in varchar2 default null
1917 ,p_information121 in varchar2 default null
1918 ,p_information122 in varchar2 default null
1919 ,p_information123 in varchar2 default null
1920 ,p_information124 in varchar2 default null
1921 ,p_information125 in varchar2 default null
1922 ,p_information126 in varchar2 default null
1923 ,p_information127 in varchar2 default null
1924 ,p_information128 in varchar2 default null
1925 ,p_information129 in varchar2 default null
1926 ,p_information130 in varchar2 default null
1927 ,p_information131 in varchar2 default null
1928 ,p_information132 in varchar2 default null
1929 ,p_information133 in varchar2 default null
1930 ,p_information134 in varchar2 default null
1931 ,p_information135 in varchar2 default null
1932 ,p_information136 in varchar2 default null
1933 ,p_information137 in varchar2 default null
1934 ,p_information138 in varchar2 default null
1935 ,p_information139 in varchar2 default null
1936 ,p_information140 in varchar2 default null
1937 ,p_information141 in varchar2 default null
1938 ,p_information142 in varchar2 default null
1939
1940 /* Extra Reserved Columns
1941 ,p_information143 in varchar2 default null
1942 ,p_information144 in varchar2 default null
1943 ,p_information145 in varchar2 default null
1947 ,p_information149 in varchar2 default null
1944 ,p_information146 in varchar2 default null
1945 ,p_information147 in varchar2 default null
1946 ,p_information148 in varchar2 default null
1948 ,p_information150 in varchar2 default null
1949 */
1950 ,p_information151 in varchar2 default null
1951 ,p_information152 in varchar2 default null
1952 ,p_information153 in varchar2 default null
1953
1954 /* Extra Reserved Columns
1955 ,p_information154 in varchar2 default null
1956 ,p_information155 in varchar2 default null
1957 ,p_information156 in varchar2 default null
1958 ,p_information157 in varchar2 default null
1959 ,p_information158 in varchar2 default null
1960 ,p_information159 in varchar2 default null
1961 */
1962 ,p_information160 in number default null
1963 ,p_information161 in number default null
1964 ,p_information162 in number default null
1965
1966 /* Extra Reserved Columns
1967 ,p_information163 in number default null
1968 ,p_information164 in number default null
1969 ,p_information165 in number default null
1970 */
1971 ,p_information166 in date default null
1972 ,p_information167 in date default null
1973 ,p_information168 in date default null
1974 ,p_information169 in number default null
1975 ,p_information170 in varchar2 default null
1976
1977 /* Extra Reserved Columns
1978 ,p_information171 in varchar2 default null
1979 ,p_information172 in varchar2 default null
1980 */
1981 ,p_information173 in varchar2 default null
1982 ,p_information174 in number default null
1983 ,p_information175 in varchar2 default null
1984 ,p_information176 in number default null
1985 ,p_information177 in varchar2 default null
1986 ,p_information178 in number default null
1987 ,p_information179 in varchar2 default null
1988 ,p_information180 in number default null
1989 ,p_information181 in varchar2 default null
1990 ,p_information182 in varchar2 default null
1991
1992 /* Extra Reserved Columns
1993 ,p_information183 in varchar2 default null
1994 ,p_information184 in varchar2 default null
1995 */
1996 ,p_information185 in varchar2 default null
1997 ,p_information186 in varchar2 default null
1998 ,p_information187 in varchar2 default null
1999 ,p_information188 in varchar2 default null
2000
2001 /* Extra Reserved Columns
2002 ,p_information189 in varchar2 default null
2003 */
2004 ,p_information190 in varchar2 default null
2005 ,p_information191 in varchar2 default null
2006 ,p_information192 in varchar2 default null
2007 ,p_information193 in varchar2 default null
2008 ,p_information194 in varchar2 default null
2009 ,p_information195 in varchar2 default null
2010 ,p_information196 in varchar2 default null
2011 ,p_information197 in varchar2 default null
2012 ,p_information198 in varchar2 default null
2013 ,p_information199 in varchar2 default null
2014
2015 /* Extra Reserved Columns
2016 ,p_information200 in varchar2 default null
2017 ,p_information201 in varchar2 default null
2018 ,p_information202 in varchar2 default null
2019 ,p_information203 in varchar2 default null
2020 ,p_information204 in varchar2 default null
2021 ,p_information205 in varchar2 default null
2022 ,p_information206 in varchar2 default null
2023 ,p_information207 in varchar2 default null
2024 ,p_information208 in varchar2 default null
2025 ,p_information209 in varchar2 default null
2026 ,p_information210 in varchar2 default null
2027 ,p_information211 in varchar2 default null
2028 ,p_information212 in varchar2 default null
2029 ,p_information213 in varchar2 default null
2030 ,p_information214 in varchar2 default null
2031 ,p_information215 in varchar2 default null
2032 */
2033 ,p_information216 in varchar2 default null
2034 ,p_information217 in varchar2 default null
2035 ,p_information218 in varchar2 default null
2036 ,p_information219 in varchar2 default null
2037 ,p_information220 in varchar2 default null
2041 ,p_information224 in number default null
2038 ,p_information221 in number default null
2039 ,p_information222 in number default null
2040 ,p_information223 in number default null
2042 ,p_information225 in number default null
2043 ,p_information226 in number default null
2044 ,p_information227 in number default null
2045 ,p_information228 in number default null
2046 ,p_information229 in number default null
2047 ,p_information230 in number default null
2048 ,p_information231 in number default null
2049 ,p_information232 in number default null
2050 ,p_information233 in number default null
2051 ,p_information234 in number default null
2052 ,p_information235 in number default null
2053 ,p_information236 in number default null
2054 ,p_information237 in number default null
2055 ,p_information238 in number default null
2056 ,p_information239 in number default null
2057 ,p_information240 in number default null
2058 ,p_information241 in number default null
2059 ,p_information242 in number default null
2060 ,p_information243 in number default null
2061 ,p_information244 in number default null
2062 ,p_information245 in number default null
2063 ,p_information246 in number default null
2064 ,p_information247 in number default null
2065 ,p_information248 in number default null
2066 ,p_information249 in number default null
2067 ,p_information250 in number default null
2068 ,p_information251 in number default null
2069 ,p_information252 in number default null
2070 ,p_information253 in number default null
2071 ,p_information254 in number default null
2072 ,p_information255 in number default null
2073 ,p_information256 in number default null
2074 ,p_information257 in number default null
2075 ,p_information258 in number default null
2076 ,p_information259 in number default null
2077 ,p_information260 in number default null
2078 ,p_information261 in number default null
2079 ,p_information262 in number default null
2080 ,p_information263 in number default null
2081 ,p_information264 in number default null
2082 ,p_information265 in number default null
2083 ,p_information266 in number default null
2084 ,p_information267 in number default null
2085 ,p_information268 in number default null
2086 ,p_information269 in number default null
2087 ,p_information270 in number default null
2088 ,p_information271 in number default null
2089 ,p_information272 in number default null
2090 ,p_information273 in number default null
2091 ,p_information274 in number default null
2092 ,p_information275 in number default null
2093 ,p_information276 in number default null
2094 ,p_information277 in number default null
2095 ,p_information278 in number default null
2096 ,p_information279 in number default null
2097 ,p_information280 in number default null
2098 ,p_information281 in number default null
2099 ,p_information282 in number default null
2100 ,p_information283 in number default null
2101 ,p_information284 in number default null
2102 ,p_information285 in number default null
2103 ,p_information286 in number default null
2104 ,p_information287 in number default null
2105 ,p_information288 in number default null
2106 ,p_information289 in number default null
2107 ,p_information290 in number default null
2108 ,p_information291 in number default null
2109 ,p_information292 in number default null
2110 ,p_information293 in number default null
2111 ,p_information294 in number default null
2112 ,p_information295 in number default null
2113 ,p_information296 in number default null
2114 ,p_information297 in number default null
2115 ,p_information298 in number default null
2116 ,p_information299 in number default null
2117 ,p_information300 in number default null
2121 ,p_information304 in number default null
2118 ,p_information301 in number default null
2119 ,p_information302 in number default null
2120 ,p_information303 in number default null
2122
2123 /* Extra Reserved Columns
2124 ,p_information305 in number default null
2125 */
2126 ,p_information306 in date default null
2127 ,p_information307 in date default null
2128 ,p_information308 in date default null
2129 ,p_information309 in date default null
2130 ,p_information310 in date default null
2131 ,p_information311 in date default null
2132 ,p_information312 in date default null
2133 ,p_information313 in date default null
2134 ,p_information314 in date default null
2135 ,p_information315 in date default null
2136 ,p_information316 in date default null
2137 ,p_information317 in date default null
2138 ,p_information318 in date default null
2139 ,p_information319 in date default null
2140 ,p_information320 in date default null
2141
2142 /* Extra Reserved Columns
2143 ,p_information321 in date default null
2144 ,p_information322 in date default null
2145 */
2146 ,p_information323 in long default null
2147 ,p_datetrack_mode in varchar2 default null
2148 ,p_copy_entity_result_id out nocopy number
2149 ,p_object_version_number out nocopy number
2150 ) is
2151 --
2152 l_rec ben_cpe_shd.g_rec_type;
2153 l_proc varchar2(72) := g_package||'ins';
2154 --
2155 Begin
2156 hr_utility.set_location('Entering:'||l_proc, 5);
2157 --
2158 -- Call conversion function to turn arguments into the
2159 -- p_rec structure.
2160 --
2161 l_rec :=
2162 ben_cpe_shd.convert_args
2163 (null
2164 ,p_copy_entity_txn_id
2165 ,p_src_copy_entity_result_id
2166 ,p_result_type_cd
2167 ,p_number_of_copies
2168 ,p_mirror_entity_result_id
2169 ,p_mirror_src_entity_result_id
2170 ,p_parent_entity_result_id
2171 ,p_pd_mr_src_entity_result_id
2172 ,p_pd_parent_entity_result_id
2173 ,p_gs_mr_src_entity_result_id
2174 ,p_gs_parent_entity_result_id
2175 ,p_table_name
2176 ,p_table_alias
2177 ,p_table_route_id
2178 ,p_status
2179 ,p_dml_operation
2180 ,p_information_category
2181 ,p_information1
2182 ,p_information2
2183 ,p_information3
2184 ,p_information4
2185 ,p_information5
2186 ,p_information6
2187 ,p_information7
2188 ,p_information8
2189 ,p_information9
2190 ,p_information10
2191 ,p_information11
2192 ,p_information12
2193 ,p_information13
2194 ,p_information14
2195 ,p_information15
2196 ,p_information16
2197 ,p_information17
2198 ,p_information18
2199 ,p_information19
2200 ,p_information20
2201 ,p_information21
2202 ,p_information22
2203 ,p_information23
2204 ,p_information24
2205 ,p_information25
2206 ,p_information26
2207 ,p_information27
2208 ,p_information28
2209 ,p_information29
2210 ,p_information30
2211 ,p_information31
2212 ,p_information32
2213 ,p_information33
2214 ,p_information34
2215 ,p_information35
2216 ,p_information36
2217 ,p_information37
2218 ,p_information38
2219 ,p_information39
2220 ,p_information40
2221 ,p_information41
2222 ,p_information42
2223 ,p_information43
2224 ,p_information44
2225 ,p_information45
2226 ,p_information46
2227 ,p_information47
2228 ,p_information48
2229 ,p_information49
2230 ,p_information50
2231 ,p_information51
2232 ,p_information52
2233 ,p_information53
2234 ,p_information54
2235 ,p_information55
2236 ,p_information56
2237 ,p_information57
2238 ,p_information58
2239 ,p_information59
2240 ,p_information60
2241 ,p_information61
2242 ,p_information62
2243 ,p_information63
2244 ,p_information64
2245 ,p_information65
2246 ,p_information66
2247 ,p_information67
2248 ,p_information68
2249 ,p_information69
2250 ,p_information70
2251 ,p_information71
2252 ,p_information72
2253 ,p_information73
2254 ,p_information74
2255 ,p_information75
2256 ,p_information76
2257 ,p_information77
2258 ,p_information78
2259 ,p_information79
2260 ,p_information80
2261 ,p_information81
2262 ,p_information82
2263 ,p_information83
2264 ,p_information84
2265 ,p_information85
2266 ,p_information86
2267 ,p_information87
2268 ,p_information88
2272 ,p_information92
2269 ,p_information89
2270 ,p_information90
2271 ,p_information91
2273 ,p_information93
2274 ,p_information94
2275 ,p_information95
2276 ,p_information96
2277 ,p_information97
2278 ,p_information98
2279 ,p_information99
2280 ,p_information100
2281 ,p_information101
2282 ,p_information102
2283 ,p_information103
2284 ,p_information104
2285 ,p_information105
2286 ,p_information106
2287 ,p_information107
2288 ,p_information108
2289 ,p_information109
2290 ,p_information110
2291 ,p_information111
2292 ,p_information112
2293 ,p_information113
2294 ,p_information114
2295 ,p_information115
2296 ,p_information116
2297 ,p_information117
2298 ,p_information118
2299 ,p_information119
2300 ,p_information120
2301 ,p_information121
2302 ,p_information122
2303 ,p_information123
2304 ,p_information124
2305 ,p_information125
2306 ,p_information126
2307 ,p_information127
2308 ,p_information128
2309 ,p_information129
2310 ,p_information130
2311 ,p_information131
2312 ,p_information132
2313 ,p_information133
2314 ,p_information134
2315 ,p_information135
2316 ,p_information136
2317 ,p_information137
2318 ,p_information138
2319 ,p_information139
2320 ,p_information140
2321 ,p_information141
2322 ,p_information142
2323
2324 /* Extra Reserved Columns
2325 ,p_information143
2326 ,p_information144
2327 ,p_information145
2328 ,p_information146
2329 ,p_information147
2330 ,p_information148
2331 ,p_information149
2332 ,p_information150
2333 */
2334 ,p_information151
2335 ,p_information152
2336 ,p_information153
2337
2338 /* Extra Reserved Columns
2339 ,p_information154
2340 ,p_information155
2341 ,p_information156
2342 ,p_information157
2343 ,p_information158
2344 ,p_information159
2345 */
2346 ,p_information160
2347 ,p_information161
2348 ,p_information162
2349
2350 /* Extra Reserved Columns
2351 ,p_information163
2352 ,p_information164
2353 ,p_information165
2354 */
2355 ,p_information166
2356 ,p_information167
2357 ,p_information168
2358 ,p_information169
2359 ,p_information170
2360
2361 /* Extra Reserved Columns
2362 ,p_information171
2363 ,p_information172
2364 */
2365 ,p_information173
2366 ,p_information174
2367 ,p_information175
2368 ,p_information176
2369 ,p_information177
2370 ,p_information178
2371 ,p_information179
2372 ,p_information180
2373 ,p_information181
2374 ,p_information182
2375
2376 /* Extra Reserved Columns
2377 ,p_information183
2378 ,p_information184
2379 */
2380 ,p_information185
2381 ,p_information186
2382 ,p_information187
2383 ,p_information188
2384
2385 /* Extra Reserved Columns
2386 ,p_information189
2387 */
2388 ,p_information190
2389 ,p_information191
2390 ,p_information192
2391 ,p_information193
2392 ,p_information194
2393 ,p_information195
2394 ,p_information196
2395 ,p_information197
2396 ,p_information198
2397 ,p_information199
2398
2399 /* Extra Reserved Columns
2400 ,p_information200
2401 ,p_information201
2402 ,p_information202
2403 ,p_information203
2404 ,p_information204
2405 ,p_information205
2406 ,p_information206
2407 ,p_information207
2408 ,p_information208
2409 ,p_information209
2410 ,p_information210
2411 ,p_information211
2412 ,p_information212
2413 ,p_information213
2414 ,p_information214
2415 ,p_information215
2416 */
2417 ,p_information216
2418 ,p_information217
2419 ,p_information218
2420 ,p_information219
2421 ,p_information220
2422 ,p_information221
2423 ,p_information222
2424 ,p_information223
2425 ,p_information224
2426 ,p_information225
2427 ,p_information226
2428 ,p_information227
2429 ,p_information228
2430 ,p_information229
2431 ,p_information230
2432 ,p_information231
2433 ,p_information232
2434 ,p_information233
2435 ,p_information234
2436 ,p_information235
2437 ,p_information236
2438 ,p_information237
2439 ,p_information238
2440 ,p_information239
2441 ,p_information240
2442 ,p_information241
2443 ,p_information242
2444 ,p_information243
2445 ,p_information244
2446 ,p_information245
2447 ,p_information246
2448 ,p_information247
2449 ,p_information248
2450 ,p_information249
2451 ,p_information250
2452 ,p_information251
2453 ,p_information252
2454 ,p_information253
2455 ,p_information254
2456 ,p_information255
2457 ,p_information256
2458 ,p_information257
2459 ,p_information258
2460 ,p_information259
2461 ,p_information260
2462 ,p_information261
2463 ,p_information262
2464 ,p_information263
2465 ,p_information264
2466 ,p_information265
2467 ,p_information266
2468 ,p_information267
2469 ,p_information268
2470 ,p_information269
2471 ,p_information270
2472 ,p_information271
2473 ,p_information272
2474 ,p_information273
2475 ,p_information274
2476 ,p_information275
2477 ,p_information276
2478 ,p_information277
2479 ,p_information278
2480 ,p_information279
2481 ,p_information280
2482 ,p_information281
2483 ,p_information282
2484 ,p_information283
2485 ,p_information284
2486 ,p_information285
2487 ,p_information286
2488 ,p_information287
2489 ,p_information288
2490 ,p_information289
2491 ,p_information290
2492 ,p_information291
2493 ,p_information292
2494 ,p_information293
2495 ,p_information294
2496 ,p_information295
2497 ,p_information296
2498 ,p_information297
2499 ,p_information298
2500 ,p_information299
2501 ,p_information300
2502 ,p_information301
2503 ,p_information302
2504 ,p_information303
2505 ,p_information304
2506
2507 /* Extra Reserved Columns
2508 ,p_information305
2509 */
2510 ,p_information306
2511 ,p_information307
2512 ,p_information308
2513 ,p_information309
2514 ,p_information310
2515 ,p_information311
2516 ,p_information312
2517 ,p_information313
2518 ,p_information314
2519 ,p_information315
2520 ,p_information316
2521 ,p_information317
2522 ,p_information318
2523 ,p_information319
2524 ,p_information320
2525
2526 /* Extra Reserved Columns
2527 ,p_information321
2528 ,p_information322
2529 */
2530 ,p_information323
2531 ,p_datetrack_mode
2532 ,null
2533 );
2534 --
2535 -- Having converted the arguments into the ben_cpe_rec
2536 -- plsql record structure we call the corresponding record business process.
2537 --
2538 ben_cpe_ins.ins
2539 (p_effective_date
2540 ,l_rec
2541 );
2542 --
2543 -- As the primary key argument(s)
2544 -- are specified as an OUT's we must set these values.
2545 --
2546 p_copy_entity_result_id := l_rec.copy_entity_result_id;
2547 p_object_version_number := l_rec.object_version_number;
2548 --
2549 hr_utility.set_location(' Leaving:'||l_proc, 10);
2550 End ins;
2551 --
2552 end ben_cpe_ins;