[Home] [Help]
PACKAGE BODY: APPS.BEN_XRD_INS
Source
1 Package Body ben_xrd_ins as
2 /* $Header: bexrdrhi.pkb 120.1 2006/02/06 11:28:36 tjesumic noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_xrd_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic. The processing of
17 -- this procedure are as follows:
18 -- 1) Initialise the object_version_number to 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To insert the row into the schema.
23 -- 4) To trap any constraint violations that may have occurred.
24 -- 5) To raise any other errors.
25 --
26 -- Prerequisites:
27 -- This is an internal private procedure which must be called from the ins
28 -- procedure and must have all mandatory attributes set (except the
29 -- object_version_number which is initialised within this procedure).
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be inserted into the schema.
36 --
37 -- Post Failure:
38 -- On the insert dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- None.
47 --
48 -- Access Status:
49 -- Internal Row Handler Use Only.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 Procedure insert_dml(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
54 --
55 l_proc varchar2(72) := g_package||'insert_dml';
56 --
57 Begin
58 hr_utility.set_location('Entering:'||l_proc, 5);
59 p_rec.object_version_number := 1; -- Initialise the object version
60 --
61 ben_xrd_shd.g_api_dml := true; -- Set the api dml status
62 --
63 -- Insert the row into: ben_ext_rslt_dtl
64 --
65 insert into ben_ext_rslt_dtl
66 ( ext_rslt_dtl_id,
67 prmy_sort_val,
68 scnd_sort_val,
69 thrd_sort_val,
70 trans_seq_num,
71 rcrd_seq_num,
72 ext_rslt_id,
73 ext_rcd_id,
74 person_id,
75 business_group_id,
76 ext_per_bg_id ,
77 val_01,
78 val_02,
79 val_03,
80 val_04,
81 val_05,
82 val_06,
83 val_07,
84 val_08,
85 val_09,
86 val_10,
87 val_11,
88 val_12,
89 val_13,
90 val_14,
91 val_15,
92 val_16,
93 val_17,
94 val_19,
95 val_18,
96 val_20,
97 val_21,
98 val_22,
99 val_23,
100 val_24,
101 val_25,
102 val_26,
103 val_27,
104 val_28,
105 val_29,
106 val_30,
107 val_31,
108 val_32,
109 val_33,
110 val_34,
111 val_35,
112 val_36,
113 val_37,
114 val_38,
115 val_39,
116 val_40,
117 val_41,
118 val_42,
119 val_43,
120 val_44,
121 val_45,
122 val_46,
123 val_47,
124 val_48,
125 val_49,
126 val_50,
127 val_51,
128 val_52,
129 val_53,
130 val_54,
131 val_55,
132 val_56,
133 val_57,
134 val_58,
135 val_59,
136 val_60,
137 val_61,
138 val_62,
139 val_63,
140 val_64,
141 val_65,
142 val_66,
143 val_67,
144 val_68,
145 val_69,
146 val_70,
147 val_71,
148 val_72,
149 val_73,
150 val_74,
151 val_75,
152 val_76,
153 val_77,
154 val_78,
155 val_79,
156 val_80,
157 val_81,
158 val_82,
159 val_83,
160 val_84,
161 val_85,
162 val_86,
163 val_87,
164 val_88,
165 val_89,
166 val_90,
167 val_91,
168 val_92,
169 val_93,
170 val_94,
171 val_95,
172 val_96,
173 val_97,
174 val_98,
175 val_99,
176 val_100,
177 val_101,
178 val_102,
179 val_103,
180 val_104,
181 val_105,
182 val_106,
183 val_107,
184 val_108,
185 val_109,
186 val_110,
187 val_111,
188 val_112,
189 val_113,
190 val_114,
191 val_115,
192 val_116,
193 val_117,
194 val_119,
195 val_118,
196 val_120,
197 val_121,
198 val_122,
199 val_123,
200 val_124,
201 val_125,
202 val_126,
203 val_127,
204 val_128,
205 val_129,
206 val_130,
207 val_131,
208 val_132,
209 val_133,
210 val_134,
211 val_135,
212 val_136,
213 val_137,
214 val_138,
215 val_139,
216 val_140,
217 val_141,
218 val_142,
219 val_143,
220 val_144,
221 val_145,
222 val_146,
223 val_147,
224 val_148,
225 val_149,
226 val_150,
227 val_151,
228 val_152,
229 val_153,
230 val_154,
231 val_155,
232 val_156,
233 val_157,
234 val_158,
235 val_159,
236 val_160,
237 val_161,
238 val_162,
239 val_163,
240 val_164,
241 val_165,
242 val_166,
243 val_167,
244 val_168,
245 val_169,
246 val_170,
247 val_171,
248 val_172,
249 val_173,
250 val_174,
251 val_175,
252 val_176,
253 val_177,
254 val_178,
255 val_179,
256 val_180,
257 val_181,
258 val_182,
259 val_183,
260 val_184,
261 val_185,
262 val_186,
263 val_187,
264 val_188,
265 val_189,
266 val_190,
267 val_191,
268 val_192,
269 val_193,
270 val_194,
271 val_195,
272 val_196,
273 val_197,
274 val_198,
275 val_199,
276 val_200,
277 val_201,
278 val_202,
279 val_203,
280 val_204,
281 val_205,
282 val_206,
283 val_207,
284 val_208,
285 val_209,
286 val_210,
287 val_211,
288 val_212,
289 val_213,
290 val_214,
291 val_215,
292 val_216,
293 val_217,
294 val_219,
295 val_218,
296 val_220,
297 val_221,
298 val_222,
299 val_223,
300 val_224,
301 val_225,
302 val_226,
303 val_227,
304 val_228,
305 val_229,
306 val_230,
307 val_231,
308 val_232,
309 val_233,
310 val_234,
311 val_235,
312 val_236,
313 val_237,
314 val_238,
315 val_239,
316 val_240,
317 val_241,
318 val_242,
319 val_243,
320 val_244,
321 val_245,
322 val_246,
323 val_247,
324 val_248,
325 val_249,
326 val_250,
327 val_251,
328 val_252,
329 val_253,
330 val_254,
331 val_255,
332 val_256,
333 val_257,
334 val_258,
335 val_259,
336 val_260,
337 val_261,
338 val_262,
339 val_263,
340 val_264,
341 val_265,
342 val_266,
343 val_267,
344 val_268,
345 val_269,
346 val_270,
347 val_271,
348 val_272,
349 val_273,
350 val_274,
351 val_275,
352 val_276,
353 val_277,
354 val_278,
355 val_279,
356 val_280,
357 val_281,
358 val_282,
359 val_283,
360 val_284,
361 val_285,
362 val_286,
363 val_287,
364 val_288,
365 val_289,
366 val_290,
367 val_291,
368 val_292,
369 val_293,
370 val_294,
371 val_295,
372 val_296,
373 val_297,
374 val_298,
375 val_299,
376 val_300,
377 group_val_01 ,
378 group_val_02 ,
379 program_application_id,
380 program_id,
381 program_update_date,
382 request_id,
383 object_version_number,
384 ext_rcd_in_file_id
385 )
386 Values
387 ( p_rec.ext_rslt_dtl_id,
388 p_rec.prmy_sort_val,
389 p_rec.scnd_sort_val,
390 p_rec.thrd_sort_val,
391 p_rec.trans_seq_num,
392 p_rec.rcrd_seq_num,
393 p_rec.ext_rslt_id,
394 p_rec.ext_rcd_id,
395 p_rec.person_id,
396 p_rec.business_group_id,
397 p_rec.ext_per_bg_id,
398 p_rec.val_01,
399 p_rec.val_02,
400 p_rec.val_03,
401 p_rec.val_04,
402 p_rec.val_05,
403 p_rec.val_06,
404 p_rec.val_07,
405 p_rec.val_08,
406 p_rec.val_09,
407 p_rec.val_10,
408 p_rec.val_11,
409 p_rec.val_12,
410 p_rec.val_13,
411 p_rec.val_14,
412 p_rec.val_15,
413 p_rec.val_16,
414 p_rec.val_17,
415 p_rec.val_19,
416 p_rec.val_18,
417 p_rec.val_20,
418 p_rec.val_21,
419 p_rec.val_22,
420 p_rec.val_23,
421 p_rec.val_24,
422 p_rec.val_25,
423 p_rec.val_26,
424 p_rec.val_27,
425 p_rec.val_28,
426 p_rec.val_29,
427 p_rec.val_30,
428 p_rec.val_31,
429 p_rec.val_32,
430 p_rec.val_33,
431 p_rec.val_34,
432 p_rec.val_35,
433 p_rec.val_36,
434 p_rec.val_37,
435 p_rec.val_38,
436 p_rec.val_39,
437 p_rec.val_40,
438 p_rec.val_41,
439 p_rec.val_42,
440 p_rec.val_43,
441 p_rec.val_44,
442 p_rec.val_45,
443 p_rec.val_46,
444 p_rec.val_47,
445 p_rec.val_48,
446 p_rec.val_49,
447 p_rec.val_50,
448 p_rec.val_51,
449 p_rec.val_52,
450 p_rec.val_53,
451 p_rec.val_54,
452 p_rec.val_55,
453 p_rec.val_56,
454 p_rec.val_57,
455 p_rec.val_58,
456 p_rec.val_59,
457 p_rec.val_60,
458 p_rec.val_61,
459 p_rec.val_62,
460 p_rec.val_63,
461 p_rec.val_64,
462 p_rec.val_65,
463 p_rec.val_66,
464 p_rec.val_67,
465 p_rec.val_68,
466 p_rec.val_69,
467 p_rec.val_70,
468 p_rec.val_71,
469 p_rec.val_72,
470 p_rec.val_73,
471 p_rec.val_74,
472 p_rec.val_75,
473 p_rec.val_76,
474 p_rec.val_77,
475 p_rec.val_78,
476 p_rec.val_79,
477 p_rec.val_80,
478 p_rec.val_81,
479 p_rec.val_82,
480 p_rec.val_83,
481 p_rec.val_84,
482 p_rec.val_85,
483 p_rec.val_86,
484 p_rec.val_87,
485 p_rec.val_88,
486 p_rec.val_89,
487 p_rec.val_90,
488 p_rec.val_91,
489 p_rec.val_92,
490 p_rec.val_93,
491 p_rec.val_94,
492 p_rec.val_95,
493 p_rec.val_96,
494 p_rec.val_97,
495 p_rec.val_98,
496 p_rec.val_99,
497 p_rec.val_100,
498 p_rec.val_101,
499 p_rec.val_102,
500 p_rec.val_103,
501 p_rec.val_104,
502 p_rec.val_105,
503 p_rec.val_106,
504 p_rec.val_107,
505 p_rec.val_108,
506 p_rec.val_109,
507 p_rec.val_110,
508 p_rec.val_111,
509 p_rec.val_112,
510 p_rec.val_113,
511 p_rec.val_114,
512 p_rec.val_115,
513 p_rec.val_116,
514 p_rec.val_117,
515 p_rec.val_119,
516 p_rec.val_118,
517 p_rec.val_120,
518 p_rec.val_121,
519 p_rec.val_122,
520 p_rec.val_123,
521 p_rec.val_124,
522 p_rec.val_125,
523 p_rec.val_126,
524 p_rec.val_127,
525 p_rec.val_128,
526 p_rec.val_129,
527 p_rec.val_130,
528 p_rec.val_131,
529 p_rec.val_132,
530 p_rec.val_133,
531 p_rec.val_134,
532 p_rec.val_135,
533 p_rec.val_136,
534 p_rec.val_137,
535 p_rec.val_138,
536 p_rec.val_139,
537 p_rec.val_140,
538 p_rec.val_141,
539 p_rec.val_142,
540 p_rec.val_143,
541 p_rec.val_144,
542 p_rec.val_145,
543 p_rec.val_146,
544 p_rec.val_147,
545 p_rec.val_148,
546 p_rec.val_149,
547 p_rec.val_150,
548 p_rec.val_151,
549 p_rec.val_152,
550 p_rec.val_153,
551 p_rec.val_154,
552 p_rec.val_155,
553 p_rec.val_156,
554 p_rec.val_157,
555 p_rec.val_158,
556 p_rec.val_159,
557 p_rec.val_160,
558 p_rec.val_161,
559 p_rec.val_162,
560 p_rec.val_163,
561 p_rec.val_164,
562 p_rec.val_165,
563 p_rec.val_166,
564 p_rec.val_167,
565 p_rec.val_168,
566 p_rec.val_169,
567 p_rec.val_170,
568 p_rec.val_171,
569 p_rec.val_172,
570 p_rec.val_173,
571 p_rec.val_174,
572 p_rec.val_175,
573 p_rec.val_176,
574 p_rec.val_177,
575 p_rec.val_178,
576 p_rec.val_179,
577 p_rec.val_180,
578 p_rec.val_181,
579 p_rec.val_182,
580 p_rec.val_183,
581 p_rec.val_184,
582 p_rec.val_185,
583 p_rec.val_186,
584 p_rec.val_187,
585 p_rec.val_188,
586 p_rec.val_189,
587 p_rec.val_190,
588 p_rec.val_191,
589 p_rec.val_192,
590 p_rec.val_193,
591 p_rec.val_194,
592 p_rec.val_195,
593 p_rec.val_196,
594 p_rec.val_197,
595 p_rec.val_198,
596 p_rec.val_199,
597 p_rec.val_200,
598 p_rec.val_201,
599 p_rec.val_202,
600 p_rec.val_203,
601 p_rec.val_204,
602 p_rec.val_205,
603 p_rec.val_206,
604 p_rec.val_207,
605 p_rec.val_208,
606 p_rec.val_209,
607 p_rec.val_210,
608 p_rec.val_211,
609 p_rec.val_212,
610 p_rec.val_213,
611 p_rec.val_214,
612 p_rec.val_215,
613 p_rec.val_216,
614 p_rec.val_217,
615 p_rec.val_219,
616 p_rec.val_218,
617 p_rec.val_220,
618 p_rec.val_221,
619 p_rec.val_222,
620 p_rec.val_223,
621 p_rec.val_224,
622 p_rec.val_225,
623 p_rec.val_226,
624 p_rec.val_227,
625 p_rec.val_228,
626 p_rec.val_229,
627 p_rec.val_230,
628 p_rec.val_231,
629 p_rec.val_232,
630 p_rec.val_233,
631 p_rec.val_234,
632 p_rec.val_235,
633 p_rec.val_236,
634 p_rec.val_237,
635 p_rec.val_238,
636 p_rec.val_239,
637 p_rec.val_240,
638 p_rec.val_241,
639 p_rec.val_242,
640 p_rec.val_243,
641 p_rec.val_244,
642 p_rec.val_245,
643 p_rec.val_246,
644 p_rec.val_247,
645 p_rec.val_248,
646 p_rec.val_249,
647 p_rec.val_250,
648 p_rec.val_251,
649 p_rec.val_252,
650 p_rec.val_253,
651 p_rec.val_254,
652 p_rec.val_255,
653 p_rec.val_256,
654 p_rec.val_257,
655 p_rec.val_258,
656 p_rec.val_259,
657 p_rec.val_260,
658 p_rec.val_261,
659 p_rec.val_262,
660 p_rec.val_263,
661 p_rec.val_264,
662 p_rec.val_265,
663 p_rec.val_266,
664 p_rec.val_267,
665 p_rec.val_268,
666 p_rec.val_269,
667 p_rec.val_270,
668 p_rec.val_271,
669 p_rec.val_272,
670 p_rec.val_273,
671 p_rec.val_274,
672 p_rec.val_275,
673 p_rec.val_276,
674 p_rec.val_277,
675 p_rec.val_278,
676 p_rec.val_279,
677 p_rec.val_280,
678 p_rec.val_281,
679 p_rec.val_282,
680 p_rec.val_283,
681 p_rec.val_284,
682 p_rec.val_285,
683 p_rec.val_286,
684 p_rec.val_287,
685 p_rec.val_288,
686 p_rec.val_289,
687 p_rec.val_290,
688 p_rec.val_291,
689 p_rec.val_292,
690 p_rec.val_293,
691 p_rec.val_294,
692 p_rec.val_295,
693 p_rec.val_296,
694 p_rec.val_297,
695 p_rec.val_298,
696 p_rec.val_299,
697 p_rec.val_300,
698 p_rec.group_val_01,
699 p_rec.group_val_02,
700 p_rec.program_application_id,
701 p_rec.program_id,
702 p_rec.program_update_date,
703 p_rec.request_id,
704 p_rec.object_version_number,
705 p_rec.ext_rcd_in_file_id
706 );
707 --
708 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
709 --
710 hr_utility.set_location(' Leaving:'||l_proc, 10);
711 Exception
712 When hr_api.check_integrity_violated Then
713 -- A check constraint has been violated
714 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
715 ben_xrd_shd.constraint_error
716 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
717 When hr_api.parent_integrity_violated Then
718 -- Parent integrity has been violated
719 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
720 ben_xrd_shd.constraint_error
721 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
722 When hr_api.unique_integrity_violated Then
723 -- Unique integrity has been violated
724 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
725 ben_xrd_shd.constraint_error
726 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
727 When Others Then
728 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
729 Raise;
730 End insert_dml;
731 --
732 -- ----------------------------------------------------------------------------
733 -- |------------------------------< pre_insert >------------------------------|
734 -- ----------------------------------------------------------------------------
735 -- {Start Of Comments}
736 --
737 -- Description:
738 -- This private procedure contains any processing which is required before
739 -- the insert dml. Presently, if the entity has a corresponding primary
740 -- key which is maintained by an associating sequence, the primary key for
741 -- the entity will be populated with the next sequence value in
742 -- preparation for the insert dml.
743 --
744 -- Prerequisites:
745 -- This is an internal procedure which is called from the ins procedure.
746 --
747 -- In Parameters:
748 -- A Pl/Sql record structre.
749 --
750 -- Post Success:
751 -- Processing continues.
752 --
753 -- Post Failure:
754 -- If an error has occurred, an error message and exception will be raised
755 -- but not handled.
756 --
757 -- Developer Implementation Notes:
758 -- Any pre-processing required before the insert dml is issued should be
759 -- coded within this procedure. As stated above, a good example is the
760 -- generation of a primary key number via a corresponding sequence.
761 -- It is important to note that any 3rd party maintenance should be reviewed
762 -- before placing in this procedure.
763 --
764 -- Access Status:
765 -- Internal Row Handler Use Only.
766 --
767 -- {End Of Comments}
768 -- ----------------------------------------------------------------------------
769 Procedure pre_insert(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
770 --
771 l_proc varchar2(72) := g_package||'pre_insert';
772 --
773 Cursor C_Sel1 is select ben_ext_rslt_dtl_s.nextval from sys.dual;
774 --
775 Begin
776 hr_utility.set_location('Entering:'||l_proc, 5);
777 --
778 --
779 -- Select the next sequence number
780 --
781 Open C_Sel1;
782 Fetch C_Sel1 Into p_rec.ext_rslt_dtl_id;
783 Close C_Sel1;
784 --
785 hr_utility.set_location(' Leaving:'||l_proc, 10);
786 End pre_insert;
787 --
788 -- ----------------------------------------------------------------------------
789 -- |-----------------------------< post_insert >------------------------------|
790 -- ----------------------------------------------------------------------------
791 -- {Start Of Comments}
792 --
793 -- Description:
794 -- This private procedure contains any processing which is required after the
795 -- insert dml.
796 --
797 -- Prerequisites:
798 -- This is an internal procedure which is called from the ins procedure.
799 --
800 -- In Parameters:
801 -- A Pl/Sql record structre.
802 --
803 -- Post Success:
804 -- Processing continues.
805 --
806 -- Post Failure:
807 -- If an error has occurred, an error message and exception will be raised
808 -- but not handled.
809 --
810 -- Developer Implementation Notes:
811 -- Any post-processing required after the insert dml is issued should be
812 -- coded within this procedure. It is important to note that any 3rd party
813 -- maintenance should be reviewed before placing in this procedure.
814 --
815 -- Access Status:
816 -- Internal Row Handler Use Only.
817 --
818 -- {End Of Comments}
819 -- ----------------------------------------------------------------------------
820 Procedure post_insert(p_rec in ben_xrd_shd.g_rec_type) is
821 --
822 l_proc varchar2(72) := g_package||'post_insert';
823 --
824 Begin
825 hr_utility.set_location('Entering:'||l_proc, 5);
826 --
827 --
828 -- Start of API User Hook for post_insert.
829 --
830 begin
831 --
832 ben_xrd_rki.after_insert
833 (
834 p_ext_rslt_dtl_id =>p_rec.ext_rslt_dtl_id
835 ,p_prmy_sort_val =>p_rec.prmy_sort_val
836 ,p_scnd_sort_val =>p_rec.scnd_sort_val
837 ,p_thrd_sort_val =>p_rec.thrd_sort_val
838 ,p_trans_seq_num =>p_rec.trans_seq_num
839 ,p_rcrd_seq_num =>p_rec.rcrd_seq_num
840 ,p_ext_rslt_id =>p_rec.ext_rslt_id
841 ,p_ext_rcd_id =>p_rec.ext_rcd_id
842 ,p_person_id =>p_rec.person_id
843 ,p_business_group_id =>p_rec.business_group_id
844 ,p_ext_per_bg_id =>p_rec.ext_per_bg_id
845 ,p_val_01 =>p_rec.val_01
846 ,p_val_02 =>p_rec.val_02
847 ,p_val_03 =>p_rec.val_03
848 ,p_val_04 =>p_rec.val_04
849 ,p_val_05 =>p_rec.val_05
850 ,p_val_06 =>p_rec.val_06
851 ,p_val_07 =>p_rec.val_07
852 ,p_val_08 =>p_rec.val_08
853 ,p_val_09 =>p_rec.val_09
854 ,p_val_10 =>p_rec.val_10
855 ,p_val_11 =>p_rec.val_11
856 ,p_val_12 =>p_rec.val_12
857 ,p_val_13 =>p_rec.val_13
858 ,p_val_14 =>p_rec.val_14
859 ,p_val_15 =>p_rec.val_15
860 ,p_val_16 =>p_rec.val_16
861 ,p_val_17 =>p_rec.val_17
862 ,p_val_19 =>p_rec.val_19
863 ,p_val_18 =>p_rec.val_18
864 ,p_val_20 =>p_rec.val_20
865 ,p_val_21 =>p_rec.val_21
866 ,p_val_22 =>p_rec.val_22
867 ,p_val_23 =>p_rec.val_23
868 ,p_val_24 =>p_rec.val_24
869 ,p_val_25 =>p_rec.val_25
870 ,p_val_26 =>p_rec.val_26
871 ,p_val_27 =>p_rec.val_27
872 ,p_val_28 =>p_rec.val_28
873 ,p_val_29 =>p_rec.val_29
874 ,p_val_30 =>p_rec.val_30
875 ,p_val_31 =>p_rec.val_31
876 ,p_val_32 =>p_rec.val_32
877 ,p_val_33 =>p_rec.val_33
878 ,p_val_34 =>p_rec.val_34
879 ,p_val_35 =>p_rec.val_35
880 ,p_val_36 =>p_rec.val_36
881 ,p_val_37 =>p_rec.val_37
882 ,p_val_38 =>p_rec.val_38
883 ,p_val_39 =>p_rec.val_39
884 ,p_val_40 =>p_rec.val_40
885 ,p_val_41 =>p_rec.val_41
886 ,p_val_42 =>p_rec.val_42
887 ,p_val_43 =>p_rec.val_43
888 ,p_val_44 =>p_rec.val_44
889 ,p_val_45 =>p_rec.val_45
890 ,p_val_46 =>p_rec.val_46
891 ,p_val_47 =>p_rec.val_47
892 ,p_val_48 =>p_rec.val_48
893 ,p_val_49 =>p_rec.val_49
894 ,p_val_50 =>p_rec.val_50
895 ,p_val_51 =>p_rec.val_51
896 ,p_val_52 =>p_rec.val_52
897 ,p_val_53 =>p_rec.val_53
898 ,p_val_54 =>p_rec.val_54
899 ,p_val_55 =>p_rec.val_55
900 ,p_val_56 =>p_rec.val_56
901 ,p_val_57 =>p_rec.val_57
902 ,p_val_58 =>p_rec.val_58
903 ,p_val_59 =>p_rec.val_59
904 ,p_val_60 =>p_rec.val_60
905 ,p_val_61 =>p_rec.val_61
906 ,p_val_62 =>p_rec.val_62
907 ,p_val_63 =>p_rec.val_63
908 ,p_val_64 =>p_rec.val_64
909 ,p_val_65 =>p_rec.val_65
910 ,p_val_66 =>p_rec.val_66
911 ,p_val_67 =>p_rec.val_67
912 ,p_val_68 =>p_rec.val_68
913 ,p_val_69 =>p_rec.val_69
914 ,p_val_70 =>p_rec.val_70
915 ,p_val_71 =>p_rec.val_71
916 ,p_val_72 =>p_rec.val_72
917 ,p_val_73 =>p_rec.val_73
918 ,p_val_74 =>p_rec.val_74
919 ,p_val_75 =>p_rec.val_75
920 ,p_val_76 =>p_rec.val_76
921 ,p_val_77 =>p_rec.val_77
922 ,p_val_78 =>p_rec.val_78
923 ,p_val_79 =>p_rec.val_79
924 ,p_val_80 =>p_rec.val_80
925 ,p_val_81 =>p_rec.val_81
926 ,p_val_82 =>p_rec.val_82
927 ,p_val_83 =>p_rec.val_83
928 ,p_val_84 =>p_rec.val_84
929 ,p_val_85 =>p_rec.val_85
930 ,p_val_86 =>p_rec.val_86
931 ,p_val_87 =>p_rec.val_87
932 ,p_val_88 =>p_rec.val_88
933 ,p_val_89 =>p_rec.val_89
934 ,p_val_90 =>p_rec.val_90
935 ,p_val_91 =>p_rec.val_91
936 ,p_val_92 =>p_rec.val_92
937 ,p_val_93 =>p_rec.val_93
938 ,p_val_94 =>p_rec.val_94
939 ,p_val_95 =>p_rec.val_95
940 ,p_val_96 =>p_rec.val_96
941 ,p_val_97 =>p_rec.val_97
942 ,p_val_98 =>p_rec.val_98
943 ,p_val_99 =>p_rec.val_99
944 ,p_val_100 =>p_rec.val_100
945 ,p_val_101 =>p_rec.val_101
946 ,p_val_102 =>p_rec.val_102
947 ,p_val_103 =>p_rec.val_103
948 ,p_val_104 =>p_rec.val_104
949 ,p_val_105 =>p_rec.val_105
950 ,p_val_106 =>p_rec.val_106
951 ,p_val_107 =>p_rec.val_107
952 ,p_val_108 =>p_rec.val_108
953 ,p_val_109 =>p_rec.val_109
954 ,p_val_110 =>p_rec.val_110
955 ,p_val_111 =>p_rec.val_111
956 ,p_val_112 =>p_rec.val_112
957 ,p_val_113 =>p_rec.val_113
958 ,p_val_114 =>p_rec.val_114
959 ,p_val_115 =>p_rec.val_115
960 ,p_val_116 =>p_rec.val_116
961 ,p_val_117 =>p_rec.val_117
962 ,p_val_119 =>p_rec.val_119
963 ,p_val_118 =>p_rec.val_118
964 ,p_val_120 =>p_rec.val_120
965 ,p_val_121 =>p_rec.val_121
966 ,p_val_122 =>p_rec.val_122
967 ,p_val_123 =>p_rec.val_123
968 ,p_val_124 =>p_rec.val_124
969 ,p_val_125 =>p_rec.val_125
970 ,p_val_126 =>p_rec.val_126
971 ,p_val_127 =>p_rec.val_127
972 ,p_val_128 =>p_rec.val_128
973 ,p_val_129 =>p_rec.val_129
974 ,p_val_130 =>p_rec.val_130
975 ,p_val_131 =>p_rec.val_131
976 ,p_val_132 =>p_rec.val_132
977 ,p_val_133 =>p_rec.val_133
978 ,p_val_134 =>p_rec.val_134
979 ,p_val_135 =>p_rec.val_135
980 ,p_val_136 =>p_rec.val_136
981 ,p_val_137 =>p_rec.val_137
982 ,p_val_138 =>p_rec.val_138
983 ,p_val_139 =>p_rec.val_139
984 ,p_val_140 =>p_rec.val_140
985 ,p_val_141 =>p_rec.val_141
986 ,p_val_142 =>p_rec.val_142
987 ,p_val_143 =>p_rec.val_143
988 ,p_val_144 =>p_rec.val_144
989 ,p_val_145 =>p_rec.val_145
990 ,p_val_146 =>p_rec.val_146
991 ,p_val_147 =>p_rec.val_147
992 ,p_val_148 =>p_rec.val_148
993 ,p_val_149 =>p_rec.val_149
994 ,p_val_150 =>p_rec.val_150
995 ,p_val_151 =>p_rec.val_151
996 ,p_val_152 =>p_rec.val_152
997 ,p_val_153 =>p_rec.val_153
998 ,p_val_154 =>p_rec.val_154
999 ,p_val_155 =>p_rec.val_155
1000 ,p_val_156 =>p_rec.val_156
1001 ,p_val_157 =>p_rec.val_157
1002 ,p_val_158 =>p_rec.val_158
1003 ,p_val_159 =>p_rec.val_159
1004 ,p_val_160 =>p_rec.val_160
1005 ,p_val_161 =>p_rec.val_161
1006 ,p_val_162 =>p_rec.val_162
1007 ,p_val_163 =>p_rec.val_163
1008 ,p_val_164 =>p_rec.val_164
1009 ,p_val_165 =>p_rec.val_165
1010 ,p_val_166 =>p_rec.val_166
1011 ,p_val_167 =>p_rec.val_167
1012 ,p_val_168 =>p_rec.val_168
1013 ,p_val_169 =>p_rec.val_169
1014 ,p_val_170 =>p_rec.val_170
1015 ,p_val_171 =>p_rec.val_171
1016 ,p_val_172 =>p_rec.val_172
1017 ,p_val_173 =>p_rec.val_173
1018 ,p_val_174 =>p_rec.val_174
1019 ,p_val_175 =>p_rec.val_175
1020 ,p_val_176 =>p_rec.val_176
1021 ,p_val_177 =>p_rec.val_177
1022 ,p_val_178 =>p_rec.val_178
1023 ,p_val_179 =>p_rec.val_179
1024 ,p_val_180 =>p_rec.val_180
1025 ,p_val_181 =>p_rec.val_181
1026 ,p_val_182 =>p_rec.val_182
1027 ,p_val_183 =>p_rec.val_183
1028 ,p_val_184 =>p_rec.val_184
1029 ,p_val_185 =>p_rec.val_185
1030 ,p_val_186 =>p_rec.val_186
1031 ,p_val_187 =>p_rec.val_187
1032 ,p_val_188 =>p_rec.val_188
1033 ,p_val_189 =>p_rec.val_189
1034 ,p_val_190 =>p_rec.val_190
1035 ,p_val_191 =>p_rec.val_191
1036 ,p_val_192 =>p_rec.val_192
1037 ,p_val_193 =>p_rec.val_193
1038 ,p_val_194 =>p_rec.val_194
1039 ,p_val_195 =>p_rec.val_195
1040 ,p_val_196 =>p_rec.val_196
1041 ,p_val_197 =>p_rec.val_197
1042 ,p_val_198 =>p_rec.val_198
1043 ,p_val_199 =>p_rec.val_199
1044 ,p_val_200 =>p_rec.val_200
1045 ,p_val_201 =>p_rec.val_201
1046 ,p_val_202 =>p_rec.val_202
1047 ,p_val_203 =>p_rec.val_203
1048 ,p_val_204 =>p_rec.val_204
1049 ,p_val_205 =>p_rec.val_205
1050 ,p_val_206 =>p_rec.val_206
1051 ,p_val_207 =>p_rec.val_207
1052 ,p_val_208 =>p_rec.val_208
1053 ,p_val_209 =>p_rec.val_209
1054 ,p_val_210 =>p_rec.val_210
1055 ,p_val_211 =>p_rec.val_211
1056 ,p_val_212 =>p_rec.val_212
1057 ,p_val_213 =>p_rec.val_213
1058 ,p_val_214 =>p_rec.val_214
1059 ,p_val_215 =>p_rec.val_215
1060 ,p_val_216 =>p_rec.val_216
1061 ,p_val_217 =>p_rec.val_217
1062 ,p_val_219 =>p_rec.val_219
1063 ,p_val_218 =>p_rec.val_218
1064 ,p_val_220 =>p_rec.val_220
1065 ,p_val_221 =>p_rec.val_221
1066 ,p_val_222 =>p_rec.val_222
1067 ,p_val_223 =>p_rec.val_223
1068 ,p_val_224 =>p_rec.val_224
1069 ,p_val_225 =>p_rec.val_225
1070 ,p_val_226 =>p_rec.val_226
1071 ,p_val_227 =>p_rec.val_227
1072 ,p_val_228 =>p_rec.val_228
1073 ,p_val_229 =>p_rec.val_229
1074 ,p_val_230 =>p_rec.val_230
1075 ,p_val_231 =>p_rec.val_231
1076 ,p_val_232 =>p_rec.val_232
1077 ,p_val_233 =>p_rec.val_233
1078 ,p_val_234 =>p_rec.val_234
1079 ,p_val_235 =>p_rec.val_235
1080 ,p_val_236 =>p_rec.val_236
1081 ,p_val_237 =>p_rec.val_237
1082 ,p_val_238 =>p_rec.val_238
1083 ,p_val_239 =>p_rec.val_239
1084 ,p_val_240 =>p_rec.val_240
1085 ,p_val_241 =>p_rec.val_241
1086 ,p_val_242 =>p_rec.val_242
1087 ,p_val_243 =>p_rec.val_243
1088 ,p_val_244 =>p_rec.val_244
1089 ,p_val_245 =>p_rec.val_245
1090 ,p_val_246 =>p_rec.val_246
1091 ,p_val_247 =>p_rec.val_247
1092 ,p_val_248 =>p_rec.val_248
1093 ,p_val_249 =>p_rec.val_249
1094 ,p_val_250 =>p_rec.val_250
1095 ,p_val_251 =>p_rec.val_251
1096 ,p_val_252 =>p_rec.val_252
1097 ,p_val_253 =>p_rec.val_253
1098 ,p_val_254 =>p_rec.val_254
1099 ,p_val_255 =>p_rec.val_255
1100 ,p_val_256 =>p_rec.val_256
1101 ,p_val_257 =>p_rec.val_257
1102 ,p_val_258 =>p_rec.val_258
1103 ,p_val_259 =>p_rec.val_259
1104 ,p_val_260 =>p_rec.val_260
1105 ,p_val_261 =>p_rec.val_261
1106 ,p_val_262 =>p_rec.val_262
1107 ,p_val_263 =>p_rec.val_263
1108 ,p_val_264 =>p_rec.val_264
1109 ,p_val_265 =>p_rec.val_265
1110 ,p_val_266 =>p_rec.val_266
1111 ,p_val_267 =>p_rec.val_267
1112 ,p_val_268 =>p_rec.val_268
1113 ,p_val_269 =>p_rec.val_269
1114 ,p_val_270 =>p_rec.val_270
1115 ,p_val_271 =>p_rec.val_271
1116 ,p_val_272 =>p_rec.val_272
1117 ,p_val_273 =>p_rec.val_273
1118 ,p_val_274 =>p_rec.val_274
1119 ,p_val_275 =>p_rec.val_275
1120 ,p_val_276 =>p_rec.val_276
1121 ,p_val_277 =>p_rec.val_277
1122 ,p_val_278 =>p_rec.val_278
1123 ,p_val_279 =>p_rec.val_279
1124 ,p_val_280 =>p_rec.val_280
1125 ,p_val_281 =>p_rec.val_281
1126 ,p_val_282 =>p_rec.val_282
1127 ,p_val_283 =>p_rec.val_283
1128 ,p_val_284 =>p_rec.val_284
1129 ,p_val_285 =>p_rec.val_285
1130 ,p_val_286 =>p_rec.val_286
1131 ,p_val_287 =>p_rec.val_287
1132 ,p_val_288 =>p_rec.val_288
1133 ,p_val_289 =>p_rec.val_289
1134 ,p_val_290 =>p_rec.val_290
1135 ,p_val_291 =>p_rec.val_291
1136 ,p_val_292 =>p_rec.val_292
1137 ,p_val_293 =>p_rec.val_293
1138 ,p_val_294 =>p_rec.val_294
1139 ,p_val_295 =>p_rec.val_295
1140 ,p_val_296 =>p_rec.val_296
1141 ,p_val_297 =>p_rec.val_297
1142 ,p_val_298 =>p_rec.val_298
1143 ,p_val_299 =>p_rec.val_299
1144 ,p_val_300 =>p_rec.val_300
1145 ,p_group_val_01 =>p_rec.group_val_01
1146 ,p_group_val_02 =>p_rec.group_val_02
1147 ,p_program_application_id =>p_rec.program_application_id
1148 ,p_program_id =>p_rec.program_id
1149 ,p_program_update_date =>p_rec.program_update_date
1150 ,p_request_id =>p_rec.request_id
1151 ,p_object_version_number =>p_rec.object_version_number
1152 ,p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
1153 );
1154 --
1155 exception
1156 --
1157 when hr_api.cannot_find_prog_unit then
1158 --
1159 hr_api.cannot_find_prog_unit_error
1160 (p_module_name => 'ben_ext_rslt_dtl'
1161 ,p_hook_type => 'AI');
1162 --
1163 end;
1164 --
1165 -- End of API User Hook for post_insert.
1166 --
1167 --
1168 hr_utility.set_location(' Leaving:'||l_proc, 10);
1169 End post_insert;
1170 --
1171 -- ----------------------------------------------------------------------------
1172 -- |---------------------------------< ins >----------------------------------|
1173 -- ----------------------------------------------------------------------------
1174 Procedure ins
1175 (
1176 p_rec in out nocopy ben_xrd_shd.g_rec_type
1177 ) is
1178 --
1179 l_proc varchar2(72) := g_package||'ins';
1180 --
1181 Begin
1182 hr_utility.set_location('Entering:'||l_proc, 5);
1183 --
1184 -- Call the supporting insert validate operations
1185 --
1186 ben_xrd_bus.insert_validate(p_rec);
1187 --
1188 -- Call the supporting pre-insert operation
1189 --
1190 pre_insert(p_rec);
1191 --
1192 -- Insert the row
1193 --
1194 insert_dml(p_rec);
1195 --
1196 -- Call the supporting post-insert operation
1197 --
1198 post_insert(p_rec);
1199 end ins;
1200 --
1201 -- ----------------------------------------------------------------------------
1202 -- |---------------------------------< ins >----------------------------------|
1203 -- ----------------------------------------------------------------------------
1204 Procedure ins
1205 (
1206 p_ext_rslt_dtl_id out nocopy number,
1207 p_prmy_sort_val in varchar2 default null,
1208 p_scnd_sort_val in varchar2 default null,
1209 p_thrd_sort_val in varchar2 default null,
1210 p_trans_seq_num in number default null,
1211 p_rcrd_seq_num in number default null,
1212 p_ext_rslt_id in number,
1213 p_ext_rcd_id in number,
1214 p_person_id in number,
1215 p_business_group_id in number,
1216 p_ext_per_bg_id in number default null,
1217 p_val_01 in varchar2 default null,
1218 p_val_02 in varchar2 default null,
1219 p_val_03 in varchar2 default null,
1220 p_val_04 in varchar2 default null,
1221 p_val_05 in varchar2 default null,
1222 p_val_06 in varchar2 default null,
1223 p_val_07 in varchar2 default null,
1224 p_val_08 in varchar2 default null,
1225 p_val_09 in varchar2 default null,
1226 p_val_10 in varchar2 default null,
1227 p_val_11 in varchar2 default null,
1228 p_val_12 in varchar2 default null,
1229 p_val_13 in varchar2 default null,
1230 p_val_14 in varchar2 default null,
1231 p_val_15 in varchar2 default null,
1232 p_val_16 in varchar2 default null,
1233 p_val_17 in varchar2 default null,
1234 p_val_19 in varchar2 default null,
1235 p_val_18 in varchar2 default null,
1236 p_val_20 in varchar2 default null,
1237 p_val_21 in varchar2 default null,
1238 p_val_22 in varchar2 default null,
1239 p_val_23 in varchar2 default null,
1240 p_val_24 in varchar2 default null,
1241 p_val_25 in varchar2 default null,
1242 p_val_26 in varchar2 default null,
1243 p_val_27 in varchar2 default null,
1244 p_val_28 in varchar2 default null,
1245 p_val_29 in varchar2 default null,
1246 p_val_30 in varchar2 default null,
1247 p_val_31 in varchar2 default null,
1248 p_val_32 in varchar2 default null,
1249 p_val_33 in varchar2 default null,
1250 p_val_34 in varchar2 default null,
1251 p_val_35 in varchar2 default null,
1252 p_val_36 in varchar2 default null,
1253 p_val_37 in varchar2 default null,
1254 p_val_38 in varchar2 default null,
1255 p_val_39 in varchar2 default null,
1256 p_val_40 in varchar2 default null,
1257 p_val_41 in varchar2 default null,
1258 p_val_42 in varchar2 default null,
1259 p_val_43 in varchar2 default null,
1260 p_val_44 in varchar2 default null,
1261 p_val_45 in varchar2 default null,
1262 p_val_46 in varchar2 default null,
1263 p_val_47 in varchar2 default null,
1264 p_val_48 in varchar2 default null,
1265 p_val_49 in varchar2 default null,
1266 p_val_50 in varchar2 default null,
1267 p_val_51 in varchar2 default null,
1268 p_val_52 in varchar2 default null,
1269 p_val_53 in varchar2 default null,
1270 p_val_54 in varchar2 default null,
1271 p_val_55 in varchar2 default null,
1272 p_val_56 in varchar2 default null,
1273 p_val_57 in varchar2 default null,
1274 p_val_58 in varchar2 default null,
1275 p_val_59 in varchar2 default null,
1276 p_val_60 in varchar2 default null,
1277 p_val_61 in varchar2 default null,
1278 p_val_62 in varchar2 default null,
1279 p_val_63 in varchar2 default null,
1280 p_val_64 in varchar2 default null,
1281 p_val_65 in varchar2 default null,
1282 p_val_66 in varchar2 default null,
1283 p_val_67 in varchar2 default null,
1284 p_val_68 in varchar2 default null,
1285 p_val_69 in varchar2 default null,
1286 p_val_70 in varchar2 default null,
1287 p_val_71 in varchar2 default null,
1288 p_val_72 in varchar2 default null,
1289 p_val_73 in varchar2 default null,
1290 p_val_74 in varchar2 default null,
1291 p_val_75 in varchar2 default null,
1292 p_val_76 in varchar2 default null,
1293 p_val_77 in varchar2 default null,
1294 p_val_78 in varchar2 default null,
1295 p_val_79 in varchar2 default null,
1296 p_val_80 in varchar2 default null,
1297 p_val_81 in varchar2 default null,
1298 p_val_82 in varchar2 default null,
1299 p_val_83 in varchar2 default null,
1300 p_val_84 in varchar2 default null,
1301 p_val_85 in varchar2 default null,
1302 p_val_86 in varchar2 default null,
1303 p_val_87 in varchar2 default null,
1304 p_val_88 in varchar2 default null,
1305 p_val_89 in varchar2 default null,
1306 p_val_90 in varchar2 default null,
1307 p_val_91 in varchar2 default null,
1308 p_val_92 in varchar2 default null,
1309 p_val_93 in varchar2 default null,
1310 p_val_94 in varchar2 default null,
1311 p_val_95 in varchar2 default null,
1312 p_val_96 in varchar2 default null,
1313 p_val_97 in varchar2 default null,
1314 p_val_98 in varchar2 default null,
1315 p_val_99 in varchar2 default null,
1316 p_val_100 in varchar2 default null,
1317 p_val_101 in varchar2 default null,
1318 p_val_102 in varchar2 default null,
1319 p_val_103 in varchar2 default null,
1320 p_val_104 in varchar2 default null,
1321 p_val_105 in varchar2 default null,
1322 p_val_106 in varchar2 default null,
1323 p_val_107 in varchar2 default null,
1324 p_val_108 in varchar2 default null,
1325 p_val_109 in varchar2 default null,
1326 p_val_110 in varchar2 default null,
1327 p_val_111 in varchar2 default null,
1328 p_val_112 in varchar2 default null,
1329 p_val_113 in varchar2 default null,
1330 p_val_114 in varchar2 default null,
1331 p_val_115 in varchar2 default null,
1332 p_val_116 in varchar2 default null,
1333 p_val_117 in varchar2 default null,
1334 p_val_119 in varchar2 default null,
1335 p_val_118 in varchar2 default null,
1336 p_val_120 in varchar2 default null,
1337 p_val_121 in varchar2 default null,
1338 p_val_122 in varchar2 default null,
1339 p_val_123 in varchar2 default null,
1340 p_val_124 in varchar2 default null,
1341 p_val_125 in varchar2 default null,
1342 p_val_126 in varchar2 default null,
1343 p_val_127 in varchar2 default null,
1344 p_val_128 in varchar2 default null,
1345 p_val_129 in varchar2 default null,
1346 p_val_130 in varchar2 default null,
1347 p_val_131 in varchar2 default null,
1348 p_val_132 in varchar2 default null,
1349 p_val_133 in varchar2 default null,
1350 p_val_134 in varchar2 default null,
1351 p_val_135 in varchar2 default null,
1352 p_val_136 in varchar2 default null,
1353 p_val_137 in varchar2 default null,
1354 p_val_138 in varchar2 default null,
1355 p_val_139 in varchar2 default null,
1356 p_val_140 in varchar2 default null,
1357 p_val_141 in varchar2 default null,
1358 p_val_142 in varchar2 default null,
1359 p_val_143 in varchar2 default null,
1360 p_val_144 in varchar2 default null,
1361 p_val_145 in varchar2 default null,
1362 p_val_146 in varchar2 default null,
1363 p_val_147 in varchar2 default null,
1364 p_val_148 in varchar2 default null,
1365 p_val_149 in varchar2 default null,
1366 p_val_150 in varchar2 default null,
1367 p_val_151 in varchar2 default null,
1368 p_val_152 in varchar2 default null,
1369 p_val_153 in varchar2 default null,
1370 p_val_154 in varchar2 default null,
1371 p_val_155 in varchar2 default null,
1372 p_val_156 in varchar2 default null,
1373 p_val_157 in varchar2 default null,
1374 p_val_158 in varchar2 default null,
1375 p_val_159 in varchar2 default null,
1376 p_val_160 in varchar2 default null,
1377 p_val_161 in varchar2 default null,
1378 p_val_162 in varchar2 default null,
1379 p_val_163 in varchar2 default null,
1380 p_val_164 in varchar2 default null,
1381 p_val_165 in varchar2 default null,
1382 p_val_166 in varchar2 default null,
1383 p_val_167 in varchar2 default null,
1384 p_val_168 in varchar2 default null,
1385 p_val_169 in varchar2 default null,
1386 p_val_170 in varchar2 default null,
1387 p_val_171 in varchar2 default null,
1388 p_val_172 in varchar2 default null,
1389 p_val_173 in varchar2 default null,
1390 p_val_174 in varchar2 default null,
1391 p_val_175 in varchar2 default null,
1392 p_val_176 in varchar2 default null,
1393 p_val_177 in varchar2 default null,
1394 p_val_178 in varchar2 default null,
1395 p_val_179 in varchar2 default null,
1396 p_val_180 in varchar2 default null,
1397 p_val_181 in varchar2 default null,
1398 p_val_182 in varchar2 default null,
1399 p_val_183 in varchar2 default null,
1400 p_val_184 in varchar2 default null,
1401 p_val_185 in varchar2 default null,
1402 p_val_186 in varchar2 default null,
1403 p_val_187 in varchar2 default null,
1404 p_val_188 in varchar2 default null,
1405 p_val_189 in varchar2 default null,
1406 p_val_190 in varchar2 default null,
1407 p_val_191 in varchar2 default null,
1408 p_val_192 in varchar2 default null,
1409 p_val_193 in varchar2 default null,
1410 p_val_194 in varchar2 default null,
1411 p_val_195 in varchar2 default null,
1412 p_val_196 in varchar2 default null,
1413 p_val_197 in varchar2 default null,
1414 p_val_198 in varchar2 default null,
1415 p_val_199 in varchar2 default null,
1416 p_val_200 in varchar2 default null,
1417 p_val_201 in varchar2 default null,
1418 p_val_202 in varchar2 default null,
1419 p_val_203 in varchar2 default null,
1420 p_val_204 in varchar2 default null,
1421 p_val_205 in varchar2 default null,
1422 p_val_206 in varchar2 default null,
1423 p_val_207 in varchar2 default null,
1424 p_val_208 in varchar2 default null,
1425 p_val_209 in varchar2 default null,
1426 p_val_210 in varchar2 default null,
1427 p_val_211 in varchar2 default null,
1428 p_val_212 in varchar2 default null,
1429 p_val_213 in varchar2 default null,
1430 p_val_214 in varchar2 default null,
1431 p_val_215 in varchar2 default null,
1432 p_val_216 in varchar2 default null,
1433 p_val_217 in varchar2 default null,
1434 p_val_219 in varchar2 default null,
1435 p_val_218 in varchar2 default null,
1436 p_val_220 in varchar2 default null,
1437 p_val_221 in varchar2 default null,
1438 p_val_222 in varchar2 default null,
1439 p_val_223 in varchar2 default null,
1440 p_val_224 in varchar2 default null,
1441 p_val_225 in varchar2 default null,
1442 p_val_226 in varchar2 default null,
1443 p_val_227 in varchar2 default null,
1444 p_val_228 in varchar2 default null,
1445 p_val_229 in varchar2 default null,
1446 p_val_230 in varchar2 default null,
1447 p_val_231 in varchar2 default null,
1448 p_val_232 in varchar2 default null,
1449 p_val_233 in varchar2 default null,
1450 p_val_234 in varchar2 default null,
1451 p_val_235 in varchar2 default null,
1452 p_val_236 in varchar2 default null,
1453 p_val_237 in varchar2 default null,
1454 p_val_238 in varchar2 default null,
1455 p_val_239 in varchar2 default null,
1456 p_val_240 in varchar2 default null,
1457 p_val_241 in varchar2 default null,
1458 p_val_242 in varchar2 default null,
1459 p_val_243 in varchar2 default null,
1460 p_val_244 in varchar2 default null,
1461 p_val_245 in varchar2 default null,
1462 p_val_246 in varchar2 default null,
1463 p_val_247 in varchar2 default null,
1464 p_val_248 in varchar2 default null,
1465 p_val_249 in varchar2 default null,
1466 p_val_250 in varchar2 default null,
1467 p_val_251 in varchar2 default null,
1468 p_val_252 in varchar2 default null,
1469 p_val_253 in varchar2 default null,
1470 p_val_254 in varchar2 default null,
1471 p_val_255 in varchar2 default null,
1472 p_val_256 in varchar2 default null,
1473 p_val_257 in varchar2 default null,
1474 p_val_258 in varchar2 default null,
1475 p_val_259 in varchar2 default null,
1476 p_val_260 in varchar2 default null,
1477 p_val_261 in varchar2 default null,
1478 p_val_262 in varchar2 default null,
1479 p_val_263 in varchar2 default null,
1480 p_val_264 in varchar2 default null,
1481 p_val_265 in varchar2 default null,
1482 p_val_266 in varchar2 default null,
1483 p_val_267 in varchar2 default null,
1484 p_val_268 in varchar2 default null,
1485 p_val_269 in varchar2 default null,
1486 p_val_270 in varchar2 default null,
1487 p_val_271 in varchar2 default null,
1488 p_val_272 in varchar2 default null,
1489 p_val_273 in varchar2 default null,
1490 p_val_274 in varchar2 default null,
1491 p_val_275 in varchar2 default null,
1492 p_val_276 in varchar2 default null,
1493 p_val_277 in varchar2 default null,
1494 p_val_278 in varchar2 default null,
1495 p_val_279 in varchar2 default null,
1496 p_val_280 in varchar2 default null,
1497 p_val_281 in varchar2 default null,
1498 p_val_282 in varchar2 default null,
1499 p_val_283 in varchar2 default null,
1500 p_val_284 in varchar2 default null,
1501 p_val_285 in varchar2 default null,
1502 p_val_286 in varchar2 default null,
1503 p_val_287 in varchar2 default null,
1504 p_val_288 in varchar2 default null,
1505 p_val_289 in varchar2 default null,
1506 p_val_290 in varchar2 default null,
1507 p_val_291 in varchar2 default null,
1508 p_val_292 in varchar2 default null,
1509 p_val_293 in varchar2 default null,
1510 p_val_294 in varchar2 default null,
1511 p_val_295 in varchar2 default null,
1512 p_val_296 in varchar2 default null,
1513 p_val_297 in varchar2 default null,
1514 p_val_298 in varchar2 default null,
1515 p_val_299 in varchar2 default null,
1516 p_val_300 in varchar2 default null,
1517 p_group_val_01 in varchar2 default null,
1518 p_group_val_02 in varchar2 default null,
1519 p_program_application_id in number default null,
1520 p_program_id in number default null,
1521 p_program_update_date in date default null,
1522 p_request_id in number default null,
1523 p_object_version_number out nocopy number ,
1524 p_ext_rcd_in_file_id in number default null
1525 ) is
1526 --
1527 l_rec ben_xrd_shd.g_rec_type;
1528 l_proc varchar2(72) := g_package||'ins';
1529 --
1530 Begin
1531 hr_utility.set_location('Entering:'||l_proc, 5);
1532 --
1533 -- Call conversion function to turn arguments into the
1534 -- p_rec structure.
1535 --
1536 l_rec :=
1537 ben_xrd_shd.convert_args
1538 (
1539 null,
1540 p_prmy_sort_val,
1541 p_scnd_sort_val,
1542 p_thrd_sort_val,
1543 p_trans_seq_num,
1544 p_rcrd_seq_num,
1545 p_ext_rslt_id,
1546 p_ext_rcd_id,
1547 p_person_id,
1548 p_business_group_id,
1549 p_ext_per_bg_id,
1550 p_val_01,
1551 p_val_02,
1552 p_val_03,
1553 p_val_04,
1554 p_val_05,
1555 p_val_06,
1556 p_val_07,
1557 p_val_08,
1558 p_val_09,
1559 p_val_10,
1560 p_val_11,
1561 p_val_12,
1562 p_val_13,
1563 p_val_14,
1564 p_val_15,
1565 p_val_16,
1566 p_val_17,
1567 p_val_19,
1568 p_val_18,
1569 p_val_20,
1570 p_val_21,
1571 p_val_22,
1572 p_val_23,
1573 p_val_24,
1574 p_val_25,
1575 p_val_26,
1576 p_val_27,
1577 p_val_28,
1578 p_val_29,
1579 p_val_30,
1580 p_val_31,
1581 p_val_32,
1582 p_val_33,
1583 p_val_34,
1584 p_val_35,
1585 p_val_36,
1586 p_val_37,
1587 p_val_38,
1588 p_val_39,
1589 p_val_40,
1590 p_val_41,
1591 p_val_42,
1592 p_val_43,
1593 p_val_44,
1594 p_val_45,
1595 p_val_46,
1596 p_val_47,
1597 p_val_48,
1598 p_val_49,
1599 p_val_50,
1600 p_val_51,
1601 p_val_52,
1602 p_val_53,
1603 p_val_54,
1604 p_val_55,
1605 p_val_56,
1606 p_val_57,
1607 p_val_58,
1608 p_val_59,
1609 p_val_60,
1610 p_val_61,
1611 p_val_62,
1612 p_val_63,
1613 p_val_64,
1614 p_val_65,
1615 p_val_66,
1616 p_val_67,
1617 p_val_68,
1618 p_val_69,
1619 p_val_70,
1620 p_val_71,
1621 p_val_72,
1622 p_val_73,
1623 p_val_74,
1624 p_val_75,
1625 p_val_76,
1626 p_val_77,
1627 p_val_78,
1628 p_val_79,
1629 p_val_80,
1630 p_val_81,
1631 p_val_82,
1632 p_val_83,
1633 p_val_84,
1634 p_val_85,
1635 p_val_86,
1636 p_val_87,
1637 p_val_88,
1638 p_val_89,
1639 p_val_90,
1640 p_val_91,
1641 p_val_92,
1642 p_val_93,
1643 p_val_94,
1644 p_val_95,
1645 p_val_96,
1646 p_val_97,
1647 p_val_98,
1648 p_val_99,
1649 p_val_100,
1650 p_val_101,
1651 p_val_102,
1652 p_val_103,
1653 p_val_104,
1654 p_val_105,
1655 p_val_106,
1656 p_val_107,
1657 p_val_108,
1658 p_val_109,
1659 p_val_110,
1660 p_val_111,
1661 p_val_112,
1662 p_val_113,
1663 p_val_114,
1664 p_val_115,
1665 p_val_116,
1666 p_val_117,
1667 p_val_119,
1668 p_val_118,
1669 p_val_120,
1670 p_val_121,
1671 p_val_122,
1672 p_val_123,
1673 p_val_124,
1674 p_val_125,
1675 p_val_126,
1676 p_val_127,
1677 p_val_128,
1678 p_val_129,
1679 p_val_130,
1680 p_val_131,
1681 p_val_132,
1682 p_val_133,
1683 p_val_134,
1684 p_val_135,
1685 p_val_136,
1686 p_val_137,
1687 p_val_138,
1688 p_val_139,
1689 p_val_140,
1690 p_val_141,
1691 p_val_142,
1692 p_val_143,
1693 p_val_144,
1694 p_val_145,
1695 p_val_146,
1696 p_val_147,
1697 p_val_148,
1698 p_val_149,
1699 p_val_150,
1700 p_val_151,
1701 p_val_152,
1702 p_val_153,
1703 p_val_154,
1704 p_val_155,
1705 p_val_156,
1706 p_val_157,
1707 p_val_158,
1708 p_val_159,
1709 p_val_160,
1710 p_val_161,
1711 p_val_162,
1712 p_val_163,
1713 p_val_164,
1714 p_val_165,
1715 p_val_166,
1716 p_val_167,
1717 p_val_168,
1718 p_val_169,
1719 p_val_170,
1720 p_val_171,
1721 p_val_172,
1722 p_val_173,
1723 p_val_174,
1724 p_val_175,
1725 p_val_176,
1726 p_val_177,
1727 p_val_178,
1728 p_val_179,
1729 p_val_180,
1730 p_val_181,
1731 p_val_182,
1732 p_val_183,
1733 p_val_184,
1734 p_val_185,
1735 p_val_186,
1736 p_val_187,
1737 p_val_188,
1738 p_val_189,
1739 p_val_190,
1740 p_val_191,
1741 p_val_192,
1742 p_val_193,
1743 p_val_194,
1744 p_val_195,
1745 p_val_196,
1746 p_val_197,
1747 p_val_198,
1748 p_val_199,
1749 p_val_200,
1750 p_val_201,
1751 p_val_202,
1752 p_val_203,
1753 p_val_204,
1754 p_val_205,
1755 p_val_206,
1756 p_val_207,
1757 p_val_208,
1758 p_val_209,
1759 p_val_210,
1760 p_val_211,
1761 p_val_212,
1762 p_val_213,
1763 p_val_214,
1764 p_val_215,
1765 p_val_216,
1766 p_val_217,
1767 p_val_219,
1768 p_val_218,
1769 p_val_220,
1770 p_val_221,
1771 p_val_222,
1772 p_val_223,
1773 p_val_224,
1774 p_val_225,
1775 p_val_226,
1776 p_val_227,
1777 p_val_228,
1778 p_val_229,
1779 p_val_230,
1780 p_val_231,
1781 p_val_232,
1782 p_val_233,
1783 p_val_234,
1784 p_val_235,
1785 p_val_236,
1786 p_val_237,
1787 p_val_238,
1788 p_val_239,
1789 p_val_240,
1790 p_val_241,
1791 p_val_242,
1792 p_val_243,
1793 p_val_244,
1794 p_val_245,
1795 p_val_246,
1796 p_val_247,
1797 p_val_248,
1798 p_val_249,
1799 p_val_250,
1800 p_val_251,
1801 p_val_252,
1802 p_val_253,
1803 p_val_254,
1804 p_val_255,
1805 p_val_256,
1806 p_val_257,
1807 p_val_258,
1808 p_val_259,
1809 p_val_260,
1810 p_val_261,
1811 p_val_262,
1812 p_val_263,
1813 p_val_264,
1814 p_val_265,
1815 p_val_266,
1816 p_val_267,
1817 p_val_268,
1818 p_val_269,
1819 p_val_270,
1820 p_val_271,
1821 p_val_272,
1822 p_val_273,
1823 p_val_274,
1824 p_val_275,
1825 p_val_276,
1826 p_val_277,
1827 p_val_278,
1828 p_val_279,
1829 p_val_280,
1830 p_val_281,
1831 p_val_282,
1832 p_val_283,
1833 p_val_284,
1834 p_val_285,
1835 p_val_286,
1836 p_val_287,
1837 p_val_288,
1838 p_val_289,
1839 p_val_290,
1840 p_val_291,
1841 p_val_292,
1842 p_val_293,
1843 p_val_294,
1844 p_val_295,
1845 p_val_296,
1846 p_val_297,
1847 p_val_298,
1848 p_val_299,
1849 p_val_300,
1850 p_group_val_01,
1851 p_group_val_02,
1852 p_program_application_id,
1853 p_program_id,
1854 p_program_update_date,
1855 p_request_id,
1856 null ,
1857 p_ext_rcd_in_file_id
1858 );
1859 --
1860 -- Having converted the arguments into the ben_xrd_rec
1861 -- plsql record structure we call the corresponding record business process.
1862 --
1863 ins(l_rec);
1864 --
1865 -- As the primary key argument(s)
1866 -- are specified as an OUT's we must set these values.
1867 --
1868 p_ext_rslt_dtl_id := l_rec.ext_rslt_dtl_id;
1869 p_object_version_number := l_rec.object_version_number;
1870 --
1871 hr_utility.set_location(' Leaving:'||l_proc, 10);
1872 End ins;
1873 --
1874 end ben_xrd_ins;