[Home] [Help]
PACKAGE BODY: APPS.BEN_XRD_SHD
Source
4 -- ----------------------------------------------------------------------------
1 Package Body ben_xrd_shd as
2 /* $Header: bexrdrhi.pkb 120.1 2006/02/06 11:28:36 tjesumic noship $ */
3 --
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_xrd_shd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< return_api_dml_status >-------------------------|
12 -- ----------------------------------------------------------------------------
13 Function return_api_dml_status Return Boolean Is
14 --
15 l_proc varchar2(72) := g_package||'return_api_dml_status';
16 --
17 Begin
18 hr_utility.set_location('Entering:'||l_proc, 5);
19 --
20 Return (nvl(g_api_dml, false));
21 --
22 hr_utility.set_location(' Leaving:'||l_proc, 10);
23 End return_api_dml_status;
24 --
25 -- ----------------------------------------------------------------------------
26 -- |---------------------------< constraint_error >---------------------------|
27 -- ----------------------------------------------------------------------------
28 Procedure constraint_error
29 (p_constraint_name in all_constraints.constraint_name%TYPE) Is
30 --
31 l_proc varchar2(72) := g_package||'constraint_error';
32 --
33 Begin
34 hr_utility.set_location('Entering:'||l_proc, 5);
35 --
36 If (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK1') Then
37 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38 hr_utility.set_message_token('PROCEDURE', l_proc);
39 hr_utility.set_message_token('STEP','5');
40 hr_utility.raise_error;
41 ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK2') Then
42 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43 hr_utility.set_message_token('PROCEDURE', l_proc);
44 hr_utility.set_message_token('STEP','10');
45 hr_utility.raise_error;
46 ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
47 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48 hr_utility.set_message_token('PROCEDURE', l_proc);
49 hr_utility.set_message_token('STEP','15');
50 hr_utility.raise_error;
51 ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_PK') Then
52 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53 hr_utility.set_message_token('PROCEDURE', l_proc);
54 hr_utility.set_message_token('STEP','20');
55 hr_utility.raise_error;
56 Else
57 hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58 hr_utility.set_message_token('PROCEDURE', l_proc);
59 hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60 hr_utility.raise_error;
61 End If;
62 --
63 hr_utility.set_location(' Leaving:'||l_proc, 10);
64 End constraint_error;
65 --
66 -- ----------------------------------------------------------------------------
67 -- |-----------------------------< api_updating >-----------------------------|
68 -- ----------------------------------------------------------------------------
69 Function api_updating
70 (
71 p_ext_rslt_dtl_id in number,
72 p_object_version_number in number
73 ) Return Boolean Is
74 --
75 --
76 -- Cursor selects the 'current' row from the HR Schema
77 --
78 Cursor C_Sel1 is
79 select
80 ext_rslt_dtl_id,
81 prmy_sort_val,
82 scnd_sort_val,
83 thrd_sort_val,
84 trans_seq_num,
85 rcrd_seq_num,
86 ext_rslt_id,
87 ext_rcd_id,
88 person_id,
89 business_group_id,
90 ext_per_bg_id,
91 val_01,
92 val_02,
93 val_03,
94 val_04,
95 val_05,
96 val_06,
97 val_07,
98 val_08,
99 val_09,
100 val_10,
101 val_11,
102 val_12,
103 val_13,
104 val_14,
105 val_15,
106 val_16,
107 val_17,
108 val_19,
109 val_18,
110 val_20,
111 val_21,
112 val_22,
113 val_23,
114 val_24,
115 val_25,
116 val_26,
117 val_27,
118 val_28,
119 val_29,
120 val_30,
121 val_31,
122 val_32,
123 val_33,
124 val_34,
125 val_35,
126 val_36,
127 val_37,
128 val_38,
129 val_39,
130 val_40,
131 val_41,
132 val_42,
133 val_43,
134 val_44,
135 val_45,
136 val_46,
137 val_47,
138 val_48,
139 val_49,
140 val_50,
141 val_51,
142 val_52,
143 val_53,
144 val_54,
145 val_55,
146 val_56,
147 val_57,
148 val_58,
149 val_59,
150 val_60,
151 val_61,
152 val_62,
153 val_63,
154 val_64,
155 val_65,
156 val_66,
157 val_67,
158 val_68,
159 val_69,
160 val_70,
161 val_71,
162 val_72,
163 val_73,
164 val_74,
165 val_75,
166 val_76,
167 val_77,
168 val_78,
169 val_79,
170 val_80,
171 val_81,
172 val_82,
173 val_83,
174 val_84,
175 val_85,
176 val_86,
177 val_87,
178 val_88,
179 val_89,
180 val_90,
181 val_91,
182 val_92,
183 val_93,
184 val_94,
185 val_95,
186 val_96,
187 val_97,
188 val_98,
189 val_99,
190 val_100,
191 val_101,
192 val_102,
193 val_103,
194 val_104,
195 val_105,
196 val_106,
197 val_107,
198 val_108,
199 val_109,
200 val_110,
201 val_111,
202 val_112,
203 val_113,
204 val_114,
205 val_115,
206 val_116,
207 val_117,
208 val_119,
209 val_118,
210 val_120,
211 val_121,
212 val_122,
213 val_123,
214 val_124,
215 val_125,
216 val_126,
217 val_127,
218 val_128,
219 val_129,
220 val_130,
221 val_131,
222 val_132,
223 val_133,
224 val_134,
225 val_135,
226 val_136,
227 val_137,
228 val_138,
229 val_139,
230 val_140,
231 val_141,
232 val_142,
233 val_143,
234 val_144,
235 val_145,
236 val_146,
237 val_147,
238 val_148,
239 val_149,
240 val_150,
241 val_151,
242 val_152,
243 val_153,
244 val_154,
245 val_155,
246 val_156,
247 val_157,
248 val_158,
249 val_159,
250 val_160,
251 val_161,
252 val_162,
253 val_163,
254 val_164,
255 val_165,
256 val_166,
257 val_167,
258 val_168,
259 val_169,
260 val_170,
261 val_171,
262 val_172,
263 val_173,
264 val_174,
265 val_175,
266 val_176,
267 val_177,
268 val_178,
269 val_179,
270 val_180,
271 val_181,
272 val_182,
273 val_183,
274 val_184,
275 val_185,
276 val_186,
277 val_187,
278 val_188,
279 val_189,
280 val_190,
281 val_191,
282 val_192,
283 val_193,
284 val_194,
285 val_195,
286 val_196,
287 val_197,
288 val_198,
289 val_199,
290 val_200,
291 val_201,
292 val_202,
293 val_203,
294 val_204,
295 val_205,
296 val_206,
297 val_207,
298 val_208,
299 val_209,
300 val_210,
301 val_211,
302 val_212,
303 val_213,
304 val_214,
305 val_215,
306 val_216,
307 val_217,
308 val_219,
309 val_218,
310 val_220,
311 val_221,
312 val_222,
313 val_223,
314 val_224,
315 val_225,
316 val_226,
317 val_227,
318 val_228,
319 val_229,
320 val_230,
321 val_231,
322 val_232,
323 val_233,
324 val_234,
325 val_235,
326 val_236,
327 val_237,
328 val_238,
329 val_239,
330 val_240,
331 val_241,
332 val_242,
333 val_243,
334 val_244,
335 val_245,
336 val_246,
337 val_247,
338 val_248,
339 val_249,
340 val_250,
341 val_251,
342 val_252,
343 val_253,
344 val_254,
345 val_255,
346 val_256,
347 val_257,
348 val_258,
349 val_259,
350 val_260,
351 val_261,
352 val_262,
353 val_263,
354 val_264,
355 val_265,
356 val_266,
357 val_267,
358 val_268,
359 val_269,
360 val_270,
361 val_271,
362 val_272,
363 val_273,
364 val_274,
365 val_275,
366 val_276,
367 val_277,
368 val_278,
369 val_279,
370 val_280,
371 val_281,
372 val_282,
373 val_283,
374 val_284,
375 val_285,
376 val_286,
377 val_287,
378 val_288,
379 val_289,
380 val_290,
381 val_291,
382 val_292,
383 val_293,
384 val_294,
385 val_295,
386 val_296,
387 val_297,
388 val_298,
389 val_299,
390 val_300,
391 group_val_01 ,
392 group_val_02 ,
393 program_application_id,
394 program_id,
395 program_update_date,
399 from ben_ext_rslt_dtl
396 request_id,
397 object_version_number,
398 ext_rcd_in_file_id
400 where ext_rslt_dtl_id = p_ext_rslt_dtl_id;
401 --
402 l_proc varchar2(72) := g_package||'api_updating';
403 l_fct_ret boolean;
404 --
405 Begin
406 hr_utility.set_location('Entering:'||l_proc, 5);
407 --
408 If (
409 p_ext_rslt_dtl_id is null and
410 p_object_version_number is null
411 ) Then
412 --
413 -- One of the primary key arguments is null therefore we must
414 -- set the returning function value to false
415 --
416 l_fct_ret := false;
417 Else
418 If (
419 p_ext_rslt_dtl_id = g_old_rec.ext_rslt_dtl_id and
420 p_object_version_number = g_old_rec.object_version_number
421 ) Then
422 hr_utility.set_location(l_proc, 10);
423 --
424 -- The g_old_rec is current therefore we must
425 -- set the returning function to true
426 --
427 l_fct_ret := true;
428 Else
429 --
430 -- Select the current row into g_old_rec
431 --
432 Open C_Sel1;
433 Fetch C_Sel1 Into g_old_rec;
434 If C_Sel1%notfound Then
435 Close C_Sel1;
436 --
437 -- The primary key is invalid therefore we must error
438 --
439 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
440 hr_utility.raise_error;
441 End If;
442 Close C_Sel1;
443 If (p_object_version_number <> g_old_rec.object_version_number) Then
444 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
445 hr_utility.raise_error;
446 End If;
447 hr_utility.set_location(l_proc, 15);
448 l_fct_ret := true;
449 End If;
450 End If;
451 hr_utility.set_location(' Leaving:'||l_proc, 20);
452 Return (l_fct_ret);
453 --
454 End api_updating;
455 --
456 -- ----------------------------------------------------------------------------
457 -- |---------------------------------< lck >----------------------------------|
458 -- ----------------------------------------------------------------------------
459 Procedure lck
460 (
461 p_ext_rslt_dtl_id in number,
462 p_object_version_number in number
463 ) is
464 --
465 -- Cursor selects the 'current' row from the HR Schema
466 --
467 Cursor C_Sel1 is
468 select ext_rslt_dtl_id,
469 prmy_sort_val,
470 scnd_sort_val,
471 thrd_sort_val,
472 trans_seq_num,
473 rcrd_seq_num,
474 ext_rslt_id,
475 ext_rcd_id,
476 person_id,
477 business_group_id,
478 ext_per_bg_id,
479 val_01,
480 val_02,
481 val_03,
482 val_04,
483 val_05,
484 val_06,
485 val_07,
486 val_08,
487 val_09,
488 val_10,
489 val_11,
490 val_12,
491 val_13,
492 val_14,
493 val_15,
494 val_16,
495 val_17,
496 val_19,
497 val_18,
498 val_20,
499 val_21,
500 val_22,
501 val_23,
502 val_24,
503 val_25,
504 val_26,
505 val_27,
506 val_28,
507 val_29,
508 val_30,
509 val_31,
510 val_32,
511 val_33,
512 val_34,
513 val_35,
514 val_36,
515 val_37,
516 val_38,
517 val_39,
518 val_40,
519 val_41,
520 val_42,
521 val_43,
522 val_44,
523 val_45,
524 val_46,
525 val_47,
526 val_48,
527 val_49,
528 val_50,
529 val_51,
530 val_52,
531 val_53,
532 val_54,
533 val_55,
534 val_56,
535 val_57,
536 val_58,
537 val_59,
538 val_60,
539 val_61,
540 val_62,
541 val_63,
542 val_64,
543 val_65,
544 val_66,
545 val_67,
546 val_68,
547 val_69,
548 val_70,
549 val_71,
550 val_72,
551 val_73,
552 val_74,
553 val_75,
554 val_76,
555 val_77,
556 val_78,
557 val_79,
558 val_80,
559 val_81,
560 val_82,
561 val_83,
562 val_84,
563 val_85,
564 val_86,
565 val_87,
566 val_88,
567 val_89,
568 val_90,
569 val_91,
570 val_92,
571 val_93,
572 val_94,
573 val_95,
574 val_96,
575 val_97,
576 val_98,
577 val_99,
578 val_100,
579 val_101,
580 val_102,
581 val_103,
582 val_104,
583 val_105,
584 val_106,
585 val_107,
586 val_108,
587 val_109,
588 val_110,
589 val_111,
590 val_112,
591 val_113,
592 val_114,
593 val_115,
594 val_116,
595 val_117,
596 val_119,
597 val_118,
598 val_120,
599 val_121,
600 val_122,
601 val_123,
602 val_124,
603 val_125,
604 val_126,
605 val_127,
606 val_128,
607 val_129,
608 val_130,
609 val_131,
610 val_132,
611 val_133,
612 val_134,
613 val_135,
614 val_136,
615 val_137,
616 val_138,
617 val_139,
618 val_140,
619 val_141,
620 val_142,
621 val_143,
622 val_144,
623 val_145,
624 val_146,
625 val_147,
626 val_148,
627 val_149,
628 val_150,
629 val_151,
630 val_152,
631 val_153,
632 val_154,
633 val_155,
634 val_156,
635 val_157,
636 val_158,
637 val_159,
638 val_160,
639 val_161,
640 val_162,
641 val_163,
642 val_164,
643 val_165,
644 val_166,
645 val_167,
646 val_168,
647 val_169,
648 val_170,
649 val_171,
650 val_172,
651 val_173,
652 val_174,
653 val_175,
654 val_176,
655 val_177,
656 val_178,
657 val_179,
658 val_180,
659 val_181,
660 val_182,
661 val_183,
662 val_184,
663 val_185,
664 val_186,
665 val_187,
666 val_188,
667 val_189,
668 val_190,
669 val_191,
670 val_192,
671 val_193,
672 val_194,
673 val_195,
674 val_196,
675 val_197,
676 val_198,
677 val_199,
678 val_200,
679 val_201,
680 val_202,
681 val_203,
682 val_204,
683 val_205,
684 val_206,
685 val_207,
686 val_208,
687 val_209,
688 val_210,
689 val_211,
690 val_212,
691 val_213,
692 val_214,
693 val_215,
694 val_216,
695 val_217,
696 val_219,
697 val_218,
698 val_220,
699 val_221,
700 val_222,
701 val_223,
702 val_224,
703 val_225,
704 val_226,
705 val_227,
706 val_228,
707 val_229,
708 val_230,
709 val_231,
710 val_232,
711 val_233,
712 val_234,
713 val_235,
714 val_236,
715 val_237,
716 val_238,
717 val_239,
718 val_240,
719 val_241,
720 val_242,
721 val_243,
722 val_244,
723 val_245,
724 val_246,
725 val_247,
726 val_248,
727 val_249,
728 val_250,
729 val_251,
730 val_252,
731 val_253,
732 val_254,
733 val_255,
734 val_256,
735 val_257,
736 val_258,
737 val_259,
738 val_260,
739 val_261,
740 val_262,
741 val_263,
742 val_264,
743 val_265,
744 val_266,
745 val_267,
746 val_268,
747 val_269,
748 val_270,
749 val_271,
750 val_272,
751 val_273,
752 val_274,
753 val_275,
754 val_276,
755 val_277,
756 val_278,
757 val_279,
758 val_280,
759 val_281,
760 val_282,
761 val_283,
762 val_284,
763 val_285,
764 val_286,
765 val_287,
766 val_288,
767 val_289,
768 val_290,
769 val_291,
770 val_292,
771 val_293,
772 val_294,
773 val_295,
774 val_296,
775 val_297,
776 val_298,
777 val_299,
778 val_300,
779 group_val_01 ,
780 group_val_02 ,
781 program_application_id,
782 program_id,
783 program_update_date,
784 request_id,
785 object_version_number,
786 ext_rcd_in_file_id
787 from ben_ext_rslt_dtl
788 where ext_rslt_dtl_id = p_ext_rslt_dtl_id
789 for update nowait;
790 --
791 l_proc varchar2(72) := g_package||'lck';
792 --
793 Begin
794 hr_utility.set_location('Entering:'||l_proc, 5);
795 --
796 -- Add any mandatory argument checking here:
797 -- Example:
798 -- hr_api.mandatory_arg_error
799 -- (p_api_name => l_proc,
800 -- p_argument => 'object_version_number',
801 -- p_argument_value => p_object_version_number);
802 --
803 Open C_Sel1;
804 Fetch C_Sel1 Into g_old_rec;
805 If C_Sel1%notfound then
806 Close C_Sel1;
807 --
808 -- The primary key is invalid therefore we must error
809 --
810 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
811 hr_utility.raise_error;
812 End If;
813 Close C_Sel1;
814 If (p_object_version_number <> g_old_rec.object_version_number) Then
815 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
816 hr_utility.raise_error;
817 End If;
818 --
819 hr_utility.set_location(' Leaving:'||l_proc, 10);
820 --
821 -- We need to trap the ORA LOCK exception
822 --
823 Exception
824 When HR_Api.Object_Locked then
825 --
826 -- The object is locked therefore we need to supply a meaningful
827 -- error message.
828 --
829 hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
830 hr_utility.set_message_token('TABLE_NAME', 'ben_ext_rslt_dtl');
831 hr_utility.raise_error;
832 End lck;
833 --
834 -- ----------------------------------------------------------------------------
835 -- |-----------------------------< convert_args >-----------------------------|
836 -- ----------------------------------------------------------------------------
837 Function convert_args
838 (
839 p_ext_rslt_dtl_id in number,
840 p_prmy_sort_val in varchar2,
841 p_scnd_sort_val in varchar2,
842 p_thrd_sort_val in varchar2,
843 p_trans_seq_num in number,
844 p_rcrd_seq_num in number,
845 p_ext_rslt_id in number,
846 p_ext_rcd_id in number,
847 p_person_id in number,
848 p_business_group_id in number,
849 p_ext_per_bg_id in number,
850 p_val_01 in varchar2,
851 p_val_02 in varchar2,
852 p_val_03 in varchar2,
853 p_val_04 in varchar2,
854 p_val_05 in varchar2,
855 p_val_06 in varchar2,
856 p_val_07 in varchar2,
857 p_val_08 in varchar2,
858 p_val_09 in varchar2,
859 p_val_10 in varchar2,
860 p_val_11 in varchar2,
861 p_val_12 in varchar2,
862 p_val_13 in varchar2,
863 p_val_14 in varchar2,
864 p_val_15 in varchar2,
865 p_val_16 in varchar2,
866 p_val_17 in varchar2,
867 p_val_19 in varchar2,
868 p_val_18 in varchar2,
869 p_val_20 in varchar2,
870 p_val_21 in varchar2,
871 p_val_22 in varchar2,
872 p_val_23 in varchar2,
873 p_val_24 in varchar2,
874 p_val_25 in varchar2,
875 p_val_26 in varchar2,
876 p_val_27 in varchar2,
877 p_val_28 in varchar2,
878 p_val_29 in varchar2,
879 p_val_30 in varchar2,
880 p_val_31 in varchar2,
881 p_val_32 in varchar2,
882 p_val_33 in varchar2,
883 p_val_34 in varchar2,
884 p_val_35 in varchar2,
885 p_val_36 in varchar2,
886 p_val_37 in varchar2,
887 p_val_38 in varchar2,
888 p_val_39 in varchar2,
889 p_val_40 in varchar2,
890 p_val_41 in varchar2,
891 p_val_42 in varchar2,
892 p_val_43 in varchar2,
893 p_val_44 in varchar2,
894 p_val_45 in varchar2,
895 p_val_46 in varchar2,
896 p_val_47 in varchar2,
897 p_val_48 in varchar2,
898 p_val_49 in varchar2,
899 p_val_50 in varchar2,
900 p_val_51 in varchar2,
901 p_val_52 in varchar2,
902 p_val_53 in varchar2,
903 p_val_54 in varchar2,
904 p_val_55 in varchar2,
905 p_val_56 in varchar2,
906 p_val_57 in varchar2,
907 p_val_58 in varchar2,
908 p_val_59 in varchar2,
909 p_val_60 in varchar2,
910 p_val_61 in varchar2,
911 p_val_62 in varchar2,
912 p_val_63 in varchar2,
913 p_val_64 in varchar2,
914 p_val_65 in varchar2,
915 p_val_66 in varchar2,
916 p_val_67 in varchar2,
917 p_val_68 in varchar2,
918 p_val_69 in varchar2,
919 p_val_70 in varchar2,
920 p_val_71 in varchar2,
921 p_val_72 in varchar2,
922 p_val_73 in varchar2,
923 p_val_74 in varchar2,
924 p_val_75 in varchar2,
925 p_val_76 in varchar2,
926 p_val_77 in varchar2,
927 p_val_78 in varchar2,
928 p_val_79 in varchar2,
929 p_val_80 in varchar2,
930 p_val_81 in varchar2,
931 p_val_82 in varchar2,
932 p_val_83 in varchar2,
933 p_val_84 in varchar2,
934 p_val_85 in varchar2,
935 p_val_86 in varchar2,
936 p_val_87 in varchar2,
937 p_val_88 in varchar2,
938 p_val_89 in varchar2,
939 p_val_90 in varchar2,
940 p_val_91 in varchar2,
941 p_val_92 in varchar2,
942 p_val_93 in varchar2,
943 p_val_94 in varchar2,
944 p_val_95 in varchar2,
945 p_val_96 in varchar2,
946 p_val_97 in varchar2,
947 p_val_98 in varchar2,
948 p_val_99 in varchar2,
949 p_val_100 in varchar2,
950 p_val_101 in varchar2,
951 p_val_102 in varchar2,
952 p_val_103 in varchar2,
953 p_val_104 in varchar2,
954 p_val_105 in varchar2,
955 p_val_106 in varchar2,
956 p_val_107 in varchar2,
957 p_val_108 in varchar2,
958 p_val_109 in varchar2,
959 p_val_110 in varchar2,
960 p_val_111 in varchar2,
961 p_val_112 in varchar2,
962 p_val_113 in varchar2,
963 p_val_114 in varchar2,
964 p_val_115 in varchar2,
965 p_val_116 in varchar2,
966 p_val_117 in varchar2,
967 p_val_119 in varchar2,
968 p_val_118 in varchar2,
969 p_val_120 in varchar2,
970 p_val_121 in varchar2,
971 p_val_122 in varchar2,
972 p_val_123 in varchar2,
973 p_val_124 in varchar2,
974 p_val_125 in varchar2,
975 p_val_126 in varchar2,
976 p_val_127 in varchar2,
977 p_val_128 in varchar2,
978 p_val_129 in varchar2,
979 p_val_130 in varchar2,
980 p_val_131 in varchar2,
981 p_val_132 in varchar2,
982 p_val_133 in varchar2,
983 p_val_134 in varchar2,
984 p_val_135 in varchar2,
985 p_val_136 in varchar2,
986 p_val_137 in varchar2,
987 p_val_138 in varchar2,
988 p_val_139 in varchar2,
989 p_val_140 in varchar2,
990 p_val_141 in varchar2,
991 p_val_142 in varchar2,
992 p_val_143 in varchar2,
993 p_val_144 in varchar2,
994 p_val_145 in varchar2,
995 p_val_146 in varchar2,
996 p_val_147 in varchar2,
997 p_val_148 in varchar2,
998 p_val_149 in varchar2,
999 p_val_150 in varchar2,
1000 p_val_151 in varchar2,
1001 p_val_152 in varchar2,
1002 p_val_153 in varchar2,
1003 p_val_154 in varchar2,
1004 p_val_155 in varchar2,
1005 p_val_156 in varchar2,
1006 p_val_157 in varchar2,
1007 p_val_158 in varchar2,
1008 p_val_159 in varchar2,
1009 p_val_160 in varchar2,
1010 p_val_161 in varchar2,
1011 p_val_162 in varchar2,
1012 p_val_163 in varchar2,
1013 p_val_164 in varchar2,
1014 p_val_165 in varchar2,
1015 p_val_166 in varchar2,
1016 p_val_167 in varchar2,
1017 p_val_168 in varchar2,
1018 p_val_169 in varchar2,
1019 p_val_170 in varchar2,
1020 p_val_171 in varchar2,
1021 p_val_172 in varchar2,
1022 p_val_173 in varchar2,
1023 p_val_174 in varchar2,
1024 p_val_175 in varchar2,
1025 p_val_176 in varchar2,
1026 p_val_177 in varchar2,
1027 p_val_178 in varchar2,
1028 p_val_179 in varchar2,
1029 p_val_180 in varchar2,
1030 p_val_181 in varchar2,
1031 p_val_182 in varchar2,
1032 p_val_183 in varchar2,
1033 p_val_184 in varchar2,
1034 p_val_185 in varchar2,
1035 p_val_186 in varchar2,
1036 p_val_187 in varchar2,
1037 p_val_188 in varchar2,
1038 p_val_189 in varchar2,
1039 p_val_190 in varchar2,
1040 p_val_191 in varchar2,
1041 p_val_192 in varchar2,
1042 p_val_193 in varchar2,
1043 p_val_194 in varchar2,
1044 p_val_195 in varchar2,
1045 p_val_196 in varchar2,
1046 p_val_197 in varchar2,
1047 p_val_198 in varchar2,
1048 p_val_199 in varchar2,
1049 p_val_200 in varchar2,
1050 p_val_201 in varchar2,
1051 p_val_202 in varchar2,
1052 p_val_203 in varchar2,
1053 p_val_204 in varchar2,
1054 p_val_205 in varchar2,
1055 p_val_206 in varchar2,
1056 p_val_207 in varchar2,
1057 p_val_208 in varchar2,
1058 p_val_209 in varchar2,
1059 p_val_210 in varchar2,
1060 p_val_211 in varchar2,
1061 p_val_212 in varchar2,
1062 p_val_213 in varchar2,
1063 p_val_214 in varchar2,
1064 p_val_215 in varchar2,
1065 p_val_216 in varchar2,
1066 p_val_217 in varchar2,
1067 p_val_219 in varchar2,
1068 p_val_218 in varchar2,
1069 p_val_220 in varchar2,
1070 p_val_221 in varchar2,
1071 p_val_222 in varchar2,
1072 p_val_223 in varchar2,
1073 p_val_224 in varchar2,
1074 p_val_225 in varchar2,
1075 p_val_226 in varchar2,
1076 p_val_227 in varchar2,
1077 p_val_228 in varchar2,
1078 p_val_229 in varchar2,
1079 p_val_230 in varchar2,
1080 p_val_231 in varchar2,
1081 p_val_232 in varchar2,
1082 p_val_233 in varchar2,
1083 p_val_234 in varchar2,
1084 p_val_235 in varchar2,
1085 p_val_236 in varchar2,
1086 p_val_237 in varchar2,
1087 p_val_238 in varchar2,
1088 p_val_239 in varchar2,
1089 p_val_240 in varchar2,
1090 p_val_241 in varchar2,
1091 p_val_242 in varchar2,
1092 p_val_243 in varchar2,
1093 p_val_244 in varchar2,
1094 p_val_245 in varchar2,
1095 p_val_246 in varchar2,
1096 p_val_247 in varchar2,
1097 p_val_248 in varchar2,
1098 p_val_249 in varchar2,
1099 p_val_250 in varchar2,
1100 p_val_251 in varchar2,
1101 p_val_252 in varchar2,
1102 p_val_253 in varchar2,
1103 p_val_254 in varchar2,
1104 p_val_255 in varchar2,
1105 p_val_256 in varchar2,
1106 p_val_257 in varchar2,
1107 p_val_258 in varchar2,
1108 p_val_259 in varchar2,
1109 p_val_260 in varchar2,
1110 p_val_261 in varchar2,
1111 p_val_262 in varchar2,
1112 p_val_263 in varchar2,
1113 p_val_264 in varchar2,
1114 p_val_265 in varchar2,
1115 p_val_266 in varchar2,
1116 p_val_267 in varchar2,
1117 p_val_268 in varchar2,
1118 p_val_269 in varchar2,
1119 p_val_270 in varchar2,
1120 p_val_271 in varchar2,
1121 p_val_272 in varchar2,
1122 p_val_273 in varchar2,
1123 p_val_274 in varchar2,
1124 p_val_275 in varchar2,
1125 p_val_276 in varchar2,
1126 p_val_277 in varchar2,
1127 p_val_278 in varchar2,
1128 p_val_279 in varchar2,
1129 p_val_280 in varchar2,
1130 p_val_281 in varchar2,
1131 p_val_282 in varchar2,
1132 p_val_283 in varchar2,
1133 p_val_284 in varchar2,
1134 p_val_285 in varchar2,
1135 p_val_286 in varchar2,
1136 p_val_287 in varchar2,
1137 p_val_288 in varchar2,
1138 p_val_289 in varchar2,
1139 p_val_290 in varchar2,
1140 p_val_291 in varchar2,
1141 p_val_292 in varchar2,
1142 p_val_293 in varchar2,
1143 p_val_294 in varchar2,
1144 p_val_295 in varchar2,
1145 p_val_296 in varchar2,
1146 p_val_297 in varchar2,
1147 p_val_298 in varchar2,
1148 p_val_299 in varchar2,
1149 p_val_300 in varchar2,
1150 p_group_val_01 in varchar2,
1151 p_group_val_02 in varchar2 ,
1152 p_program_application_id in number,
1153 p_program_id in number,
1154 p_program_update_date in date,
1155 p_request_id in number,
1156 p_object_version_number in number,
1157 p_ext_rcd_in_file_id in number
1158 )
1159 Return g_rec_type is
1160 --
1161 l_rec g_rec_type;
1162 l_proc varchar2(72) := g_package||'convert_args';
1163 --
1164 Begin
1165 --
1166 hr_utility.set_location('Entering:'||l_proc, 5);
1167 --
1168 -- Convert arguments into local l_rec structure.
1169 --
1170 l_rec.ext_rslt_dtl_id := p_ext_rslt_dtl_id;
1171 l_rec.prmy_sort_val := p_prmy_sort_val;
1172 l_rec.scnd_sort_val := p_scnd_sort_val;
1173 l_rec.thrd_sort_val := p_thrd_sort_val;
1177 l_rec.ext_rcd_id := p_ext_rcd_id;
1174 l_rec.trans_seq_num := p_trans_seq_num;
1175 l_rec.rcrd_seq_num := p_rcrd_seq_num;
1176 l_rec.ext_rslt_id := p_ext_rslt_id;
1178 l_rec.person_id := p_person_id;
1179 l_rec.business_group_id := p_business_group_id;
1180 l_rec.ext_per_bg_id := p_ext_per_bg_id ;
1181 l_rec.val_01 := p_val_01;
1182 l_rec.val_02 := p_val_02;
1183 l_rec.val_03 := p_val_03;
1184 l_rec.val_04 := p_val_04;
1185 l_rec.val_05 := p_val_05;
1186 l_rec.val_06 := p_val_06;
1187 l_rec.val_07 := p_val_07;
1188 l_rec.val_08 := p_val_08;
1189 l_rec.val_09 := p_val_09;
1190 l_rec.val_10 := p_val_10;
1191 l_rec.val_11 := p_val_11;
1192 l_rec.val_12 := p_val_12;
1193 l_rec.val_13 := p_val_13;
1194 l_rec.val_14 := p_val_14;
1195 l_rec.val_15 := p_val_15;
1196 l_rec.val_16 := p_val_16;
1197 l_rec.val_17 := p_val_17;
1198 l_rec.val_19 := p_val_19;
1199 l_rec.val_18 := p_val_18;
1200 l_rec.val_20 := p_val_20;
1201 l_rec.val_21 := p_val_21;
1202 l_rec.val_22 := p_val_22;
1203 l_rec.val_23 := p_val_23;
1204 l_rec.val_24 := p_val_24;
1205 l_rec.val_25 := p_val_25;
1206 l_rec.val_26 := p_val_26;
1207 l_rec.val_27 := p_val_27;
1208 l_rec.val_28 := p_val_28;
1209 l_rec.val_29 := p_val_29;
1210 l_rec.val_30 := p_val_30;
1211 l_rec.val_31 := p_val_31;
1212 l_rec.val_32 := p_val_32;
1213 l_rec.val_33 := p_val_33;
1214 l_rec.val_34 := p_val_34;
1215 l_rec.val_35 := p_val_35;
1216 l_rec.val_36 := p_val_36;
1217 l_rec.val_37 := p_val_37;
1218 l_rec.val_38 := p_val_38;
1219 l_rec.val_39 := p_val_39;
1220 l_rec.val_40 := p_val_40;
1221 l_rec.val_41 := p_val_41;
1222 l_rec.val_42 := p_val_42;
1223 l_rec.val_43 := p_val_43;
1224 l_rec.val_44 := p_val_44;
1225 l_rec.val_45 := p_val_45;
1226 l_rec.val_46 := p_val_46;
1227 l_rec.val_47 := p_val_47;
1228 l_rec.val_48 := p_val_48;
1229 l_rec.val_49 := p_val_49;
1230 l_rec.val_50 := p_val_50;
1231 l_rec.val_51 := p_val_51;
1232 l_rec.val_52 := p_val_52;
1233 l_rec.val_53 := p_val_53;
1234 l_rec.val_54 := p_val_54;
1235 l_rec.val_55 := p_val_55;
1236 l_rec.val_56 := p_val_56;
1237 l_rec.val_57 := p_val_57;
1238 l_rec.val_58 := p_val_58;
1239 l_rec.val_59 := p_val_59;
1240 l_rec.val_60 := p_val_60;
1241 l_rec.val_61 := p_val_61;
1242 l_rec.val_62 := p_val_62;
1243 l_rec.val_63 := p_val_63;
1244 l_rec.val_64 := p_val_64;
1245 l_rec.val_65 := p_val_65;
1246 l_rec.val_66 := p_val_66;
1247 l_rec.val_67 := p_val_67;
1248 l_rec.val_68 := p_val_68;
1249 l_rec.val_69 := p_val_69;
1250 l_rec.val_70 := p_val_70;
1251 l_rec.val_71 := p_val_71;
1252 l_rec.val_72 := p_val_72;
1253 l_rec.val_73 := p_val_73;
1254 l_rec.val_74 := p_val_74;
1255 l_rec.val_75 := p_val_75;
1256 l_rec.val_76 := p_val_76;
1257 l_rec.val_77 := p_val_77;
1258 l_rec.val_78 := p_val_78;
1259 l_rec.val_79 := p_val_79;
1260 l_rec.val_80 := p_val_80;
1261 l_rec.val_81 := p_val_81;
1262 l_rec.val_82 := p_val_82;
1263 l_rec.val_83 := p_val_83;
1264 l_rec.val_84 := p_val_84;
1265 l_rec.val_85 := p_val_85;
1266 l_rec.val_86 := p_val_86;
1267 l_rec.val_87 := p_val_87;
1268 l_rec.val_88 := p_val_88;
1269 l_rec.val_89 := p_val_89;
1270 l_rec.val_90 := p_val_90;
1271 l_rec.val_91 := p_val_91;
1272 l_rec.val_92 := p_val_92;
1273 l_rec.val_93 := p_val_93;
1274 l_rec.val_94 := p_val_94;
1275 l_rec.val_95 := p_val_95;
1276 l_rec.val_96 := p_val_96;
1277 l_rec.val_97 := p_val_97;
1278 l_rec.val_98 := p_val_98;
1279 l_rec.val_99 := p_val_99;
1280 l_rec.val_100 := p_val_100;
1281 l_rec.val_101 := p_val_101;
1282 l_rec.val_102 := p_val_102;
1283 l_rec.val_103 := p_val_103;
1284 l_rec.val_104 := p_val_104;
1285 l_rec.val_105 := p_val_105;
1286 l_rec.val_106 := p_val_106;
1287 l_rec.val_107 := p_val_107;
1288 l_rec.val_108 := p_val_108;
1289 l_rec.val_109 := p_val_109;
1290 l_rec.val_110 := p_val_110;
1291 l_rec.val_111 := p_val_111;
1292 l_rec.val_112 := p_val_112;
1293 l_rec.val_113 := p_val_113;
1294 l_rec.val_114 := p_val_114;
1295 l_rec.val_115 := p_val_115;
1296 l_rec.val_116 := p_val_116;
1297 l_rec.val_117 := p_val_117;
1298 l_rec.val_119 := p_val_119;
1299 l_rec.val_118 := p_val_118;
1300 l_rec.val_120 := p_val_120;
1301 l_rec.val_121 := p_val_121;
1302 l_rec.val_122 := p_val_122;
1303 l_rec.val_123 := p_val_123;
1304 l_rec.val_124 := p_val_124;
1305 l_rec.val_125 := p_val_125;
1306 l_rec.val_126 := p_val_126;
1307 l_rec.val_127 := p_val_127;
1308 l_rec.val_128 := p_val_128;
1309 l_rec.val_129 := p_val_129;
1310 l_rec.val_130 := p_val_130;
1311 l_rec.val_131 := p_val_131;
1312 l_rec.val_132 := p_val_132;
1313 l_rec.val_133 := p_val_133;
1314 l_rec.val_134 := p_val_134;
1315 l_rec.val_135 := p_val_135;
1316 l_rec.val_136 := p_val_136;
1317 l_rec.val_137 := p_val_137;
1318 l_rec.val_138 := p_val_138;
1319 l_rec.val_139 := p_val_139;
1320 l_rec.val_140 := p_val_140;
1321 l_rec.val_141 := p_val_141;
1322 l_rec.val_142 := p_val_142;
1323 l_rec.val_143 := p_val_143;
1324 l_rec.val_144 := p_val_144;
1325 l_rec.val_145 := p_val_145;
1326 l_rec.val_146 := p_val_146;
1327 l_rec.val_147 := p_val_147;
1328 l_rec.val_148 := p_val_148;
1329 l_rec.val_149 := p_val_149;
1330 l_rec.val_150 := p_val_150;
1331 l_rec.val_151 := p_val_151;
1332 l_rec.val_152 := p_val_152;
1333 l_rec.val_153 := p_val_153;
1334 l_rec.val_154 := p_val_154;
1335 l_rec.val_155 := p_val_155;
1336 l_rec.val_156 := p_val_156;
1337 l_rec.val_157 := p_val_157;
1338 l_rec.val_158 := p_val_158;
1339 l_rec.val_159 := p_val_159;
1340 l_rec.val_160 := p_val_160;
1341 l_rec.val_161 := p_val_161;
1342 l_rec.val_162 := p_val_162;
1343 l_rec.val_163 := p_val_163;
1344 l_rec.val_164 := p_val_164;
1345 l_rec.val_165 := p_val_165;
1346 l_rec.val_166 := p_val_166;
1347 l_rec.val_167 := p_val_167;
1348 l_rec.val_168 := p_val_168;
1349 l_rec.val_169 := p_val_169;
1350 l_rec.val_170 := p_val_170;
1351 l_rec.val_171 := p_val_171;
1352 l_rec.val_172 := p_val_172;
1353 l_rec.val_173 := p_val_173;
1354 l_rec.val_174 := p_val_174;
1355 l_rec.val_175 := p_val_175;
1356 l_rec.val_176 := p_val_176;
1357 l_rec.val_177 := p_val_177;
1358 l_rec.val_178 := p_val_178;
1359 l_rec.val_179 := p_val_179;
1360 l_rec.val_180 := p_val_180;
1361 l_rec.val_181 := p_val_181;
1362 l_rec.val_182 := p_val_182;
1363 l_rec.val_183 := p_val_183;
1364 l_rec.val_184 := p_val_184;
1365 l_rec.val_185 := p_val_185;
1366 l_rec.val_186 := p_val_186;
1367 l_rec.val_187 := p_val_187;
1368 l_rec.val_188 := p_val_188;
1369 l_rec.val_189 := p_val_189;
1370 l_rec.val_190 := p_val_190;
1371 l_rec.val_191 := p_val_191;
1372 l_rec.val_192 := p_val_192;
1373 l_rec.val_193 := p_val_193;
1374 l_rec.val_194 := p_val_194;
1375 l_rec.val_195 := p_val_195;
1376 l_rec.val_196 := p_val_196;
1377 l_rec.val_197 := p_val_197;
1378 l_rec.val_198 := p_val_198;
1379 l_rec.val_199 := p_val_199;
1380 l_rec.val_200 := p_val_200;
1381 l_rec.val_201 := p_val_201 ;
1382 l_rec.val_202 := p_val_202 ;
1383 l_rec.val_203 := p_val_203 ;
1384 l_rec.val_204 := p_val_204 ;
1385 l_rec.val_205 := p_val_205 ;
1386 l_rec.val_206 := p_val_206 ;
1387 l_rec.val_207 := p_val_207 ;
1388 l_rec.val_208 := p_val_208 ;
1389 l_rec.val_209 := p_val_209 ;
1390 l_rec.val_210 := p_val_210 ;
1391 l_rec.val_211 := p_val_211 ;
1392 l_rec.val_212 := p_val_212 ;
1393 l_rec.val_213 := p_val_213 ;
1394 l_rec.val_214 := p_val_214 ;
1395 l_rec.val_215 := p_val_215 ;
1396 l_rec.val_216 := p_val_216 ;
1397 l_rec.val_217 := p_val_217 ;
1398 l_rec.val_219 := p_val_219 ;
1399 l_rec.val_218 := p_val_218 ;
1400 l_rec.val_220 := p_val_220 ;
1401 l_rec.val_221 := p_val_221 ;
1402 l_rec.val_222 := p_val_222 ;
1403 l_rec.val_223 := p_val_223 ;
1404 l_rec.val_224 := p_val_224 ;
1405 l_rec.val_225 := p_val_225 ;
1406 l_rec.val_226 := p_val_226 ;
1407 l_rec.val_227 := p_val_227 ;
1408 l_rec.val_228 := p_val_228 ;
1409 l_rec.val_229 := p_val_229 ;
1410 l_rec.val_230 := p_val_230 ;
1411 l_rec.val_231 := p_val_231 ;
1412 l_rec.val_232 := p_val_232 ;
1413 l_rec.val_233 := p_val_233 ;
1414 l_rec.val_234 := p_val_234 ;
1415 l_rec.val_235 := p_val_235 ;
1416 l_rec.val_236 := p_val_236 ;
1417 l_rec.val_237 := p_val_237 ;
1418 l_rec.val_238 := p_val_238 ;
1419 l_rec.val_239 := p_val_239 ;
1420 l_rec.val_240 := p_val_240 ;
1421 l_rec.val_241 := p_val_241 ;
1422 l_rec.val_242 := p_val_242 ;
1423 l_rec.val_243 := p_val_243 ;
1424 l_rec.val_244 := p_val_244 ;
1425 l_rec.val_245 := p_val_245 ;
1426 l_rec.val_246 := p_val_246 ;
1427 l_rec.val_247 := p_val_247 ;
1428 l_rec.val_248 := p_val_248 ;
1429 l_rec.val_249 := p_val_249 ;
1430 l_rec.val_250 := p_val_250 ;
1431 l_rec.val_251 := p_val_251 ;
1432 l_rec.val_252 := p_val_252 ;
1433 l_rec.val_253 := p_val_253 ;
1434 l_rec.val_254 := p_val_254 ;
1435 l_rec.val_255 := p_val_255 ;
1436 l_rec.val_256 := p_val_256 ;
1437 l_rec.val_257 := p_val_257 ;
1438 l_rec.val_258 := p_val_258 ;
1439 l_rec.val_259 := p_val_259 ;
1440 l_rec.val_260 := p_val_260 ;
1441 l_rec.val_261 := p_val_261 ;
1442 l_rec.val_262 := p_val_262 ;
1443 l_rec.val_263 := p_val_263 ;
1444 l_rec.val_264 := p_val_264 ;
1445 l_rec.val_265 := p_val_265 ;
1446 l_rec.val_266 := p_val_266 ;
1447 l_rec.val_267 := p_val_267 ;
1448 l_rec.val_268 := p_val_268 ;
1449 l_rec.val_269 := p_val_269 ;
1450 l_rec.val_270 := p_val_270 ;
1451 l_rec.val_271 := p_val_271 ;
1452 l_rec.val_272 := p_val_272 ;
1453 l_rec.val_273 := p_val_273 ;
1454 l_rec.val_274 := p_val_274 ;
1455 l_rec.val_275 := p_val_275 ;
1456 l_rec.val_276 := p_val_276 ;
1457 l_rec.val_277 := p_val_277 ;
1458 l_rec.val_278 := p_val_278 ;
1459 l_rec.val_279 := p_val_279 ;
1460 l_rec.val_280 := p_val_280 ;
1461 l_rec.val_281 := p_val_281 ;
1462 l_rec.val_282 := p_val_282 ;
1463 l_rec.val_283 := p_val_283 ;
1464 l_rec.val_284 := p_val_284 ;
1465 l_rec.val_285 := p_val_285 ;
1466 l_rec.val_286 := p_val_286 ;
1467 l_rec.val_287 := p_val_287 ;
1468 l_rec.val_288 := p_val_288 ;
1469 l_rec.val_289 := p_val_289 ;
1470 l_rec.val_290 := p_val_290 ;
1471 l_rec.val_291 := p_val_291 ;
1472 l_rec.val_292 := p_val_292 ;
1473 l_rec.val_293 := p_val_293 ;
1474 l_rec.val_294 := p_val_294 ;
1475 l_rec.val_295 := p_val_295 ;
1476 l_rec.val_296 := p_val_296 ;
1477 l_rec.val_297 := p_val_297 ;
1478 l_rec.val_298 := p_val_298 ;
1479 l_rec.val_299 := p_val_299 ;
1480 l_rec.val_300 := p_val_300;
1481 l_rec.group_val_01 := p_group_val_01;
1482 l_rec.group_val_02 := p_group_val_02;
1483 l_rec.program_application_id := p_program_application_id;
1484 l_rec.program_id := p_program_id;
1485 l_rec.program_update_date := p_program_update_date;
1486 l_rec.request_id := p_request_id;
1487 l_rec.object_version_number := p_object_version_number;
1488 l_rec.ext_rcd_in_file_id := p_ext_rcd_in_file_id;
1489 --
1490 -- Return the plsql record structure.
1491 --
1492 hr_utility.set_location(' Leaving:'||l_proc, 10);
1493 Return(l_rec);
1494 --
1495 End convert_args;
1496 --
1497 end ben_xrd_shd;