[Home] [Help]
PACKAGE BODY: APPS.BEN_CPE_SHD
Source
1 Package Body ben_cpe_shd 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_shd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< return_api_dml_status >-------------------------|
12 -- ----------------------------------------------------------------------------
13 Function return_api_dml_status Return Boolean Is
14 --
15 Begin
16 --
17 Return (nvl(g_api_dml, false));
18 --
19 End return_api_dml_status;
20 --
21 -- ----------------------------------------------------------------------------
22 -- |---------------------------< constraint_error >---------------------------|
23 -- ----------------------------------------------------------------------------
24 Procedure constraint_error
25 (p_constraint_name in all_constraints.constraint_name%TYPE
26 ) Is
27 --
28 l_proc varchar2(72) := g_package||'constraint_error';
29 --
30 Begin
31 --
32 If (p_constraint_name = 'BEN_COPY_ENTITY_RESULTS_PK') Then
33 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34 fnd_message.set_token('PROCEDURE', l_proc);
35 fnd_message.set_token('STEP','5');
36 fnd_message.raise_error;
37 Else
38 fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39 fnd_message.set_token('PROCEDURE', l_proc);
40 fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41 fnd_message.raise_error;
42 End If;
43 --
44 End constraint_error;
45 --
46 -- ----------------------------------------------------------------------------
47 -- |-----------------------------< api_updating >-----------------------------|
48 -- ----------------------------------------------------------------------------
49 Function api_updating
50 (p_copy_entity_result_id in number
51 ,p_object_version_number in number
52 )
53 Return Boolean Is
54 --
55 --
56 -- Cursor selects the 'current' row from the HR Schema
57 --
58 Cursor C_Sel1 is
59 select
60 copy_entity_result_id
61 ,copy_entity_txn_id
62 ,src_copy_entity_result_id
63 ,result_type_cd
64 ,number_of_copies
65 ,mirror_entity_result_id
66 ,mirror_src_entity_result_id
67 ,parent_entity_result_id
68 ,pd_mirror_src_entity_result_id
69 ,pd_parent_entity_result_id
70 ,gs_mirror_src_entity_result_id
71 ,gs_parent_entity_result_id
72 ,table_name
73 ,table_alias
74 ,table_route_id
75 ,status
76 ,dml_operation
77 ,information_category
78 ,information1
79 ,information2
80 ,information3
81 ,information4
82 ,information5
83 ,information6
84 ,information7
85 ,information8
86 ,information9
87 ,information10
88 ,information11
89 ,information12
90 ,information13
91 ,information14
92 ,information15
93 ,information16
94 ,information17
95 ,information18
96 ,information19
97 ,information20
98 ,information21
99 ,information22
100 ,information23
101 ,information24
102 ,information25
103 ,information26
104 ,information27
105 ,information28
106 ,information29
107 ,information30
108 ,information31
109 ,information32
110 ,information33
111 ,information34
112 ,information35
113 ,information36
114 ,information37
115 ,information38
116 ,information39
117 ,information40
118 ,information41
119 ,information42
120 ,information43
121 ,information44
122 ,information45
123 ,information46
124 ,information47
125 ,information48
126 ,information49
127 ,information50
128 ,information51
129 ,information52
130 ,information53
131 ,information54
132 ,information55
133 ,information56
134 ,information57
135 ,information58
136 ,information59
137 ,information60
138 ,information61
139 ,information62
140 ,information63
141 ,information64
142 ,information65
143 ,information66
144 ,information67
145 ,information68
146 ,information69
147 ,information70
148 ,information71
149 ,information72
150 ,information73
151 ,information74
152 ,information75
153 ,information76
154 ,information77
155 ,information78
156 ,information79
157 ,information80
158 ,information81
159 ,information82
160 ,information83
161 ,information84
162 ,information85
163 ,information86
164 ,information87
165 ,information88
166 ,information89
167 ,information90
168 ,information91
169 ,information92
170 ,information93
171 ,information94
172 ,information95
173 ,information96
174 ,information97
175 ,information98
176 ,information99
177 ,information100
178 ,information101
179 ,information102
180 ,information103
181 ,information104
182 ,information105
183 ,information106
184 ,information107
185 ,information108
186 ,information109
187 ,information110
188 ,information111
189 ,information112
190 ,information113
191 ,information114
192 ,information115
193 ,information116
194 ,information117
195 ,information118
196 ,information119
197 ,information120
198 ,information121
199 ,information122
200 ,information123
201 ,information124
202 ,information125
203 ,information126
204 ,information127
205 ,information128
206 ,information129
207 ,information130
208 ,information131
209 ,information132
210 ,information133
211 ,information134
212 ,information135
213 ,information136
214 ,information137
215 ,information138
216 ,information139
217 ,information140
218 ,information141
219 ,information142
220
221 /* Extra Reserved Columns
222 ,information143
223 ,information144
224 ,information145
225 ,information146
226 ,information147
227 ,information148
228 ,information149
229 ,information150
230 */
231 ,information151
232 ,information152
233 ,information153
234
235 /* Extra Reserved Columns
236 ,information154
237 ,information155
238 ,information156
239 ,information157
240 ,information158
241 ,information159
242 */
243 ,information160
244 ,information161
245 ,information162
246
247 /* Extra Reserved Columns
248 ,information163
249 ,information164
250 ,information165
251 */
252 ,information166
253 ,information167
254 ,information168
255 ,information169
256 ,information170
257
258 /* Extra Reserved Columns
259 ,information171
260 ,information172
261 */
262 ,information173
263 ,information174
264 ,information175
265 ,information176
266 ,information177
267 ,information178
268 ,information179
269 ,information180
270 ,information181
271 ,information182
272
273 /* Extra Reserved Columns
274 ,information183
275 ,information184
276 */
277 ,information185
278 ,information186
279 ,information187
280 ,information188
281
282 /* Extra Reserved Columns
283 ,information189
284 */
285 ,information190
286 ,information191
287 ,information192
288 ,information193
289 ,information194
290 ,information195
291 ,information196
292 ,information197
293 ,information198
294 ,information199
295
296 /* Extra Reserved Columns
297 ,information200
298 ,information201
299 ,information202
300 ,information203
301 ,information204
302 ,information205
303 ,information206
304 ,information207
305 ,information208
306 ,information209
307 ,information210
308 ,information211
309 ,information212
310 ,information213
311 ,information214
312 ,information215
313 */
314 ,information216
315 ,information217
316 ,information218
317 ,information219
318 ,information220
319 ,information221
320 ,information222
321 ,information223
322 ,information224
323 ,information225
324 ,information226
325 ,information227
326 ,information228
327 ,information229
328 ,information230
329 ,information231
330 ,information232
331 ,information233
332 ,information234
333 ,information235
334 ,information236
335 ,information237
336 ,information238
337 ,information239
338 ,information240
339 ,information241
340 ,information242
341 ,information243
342 ,information244
343 ,information245
344 ,information246
345 ,information247
346 ,information248
347 ,information249
348 ,information250
349 ,information251
350 ,information252
351 ,information253
352 ,information254
353 ,information255
354 ,information256
355 ,information257
356 ,information258
357 ,information259
358 ,information260
359 ,information261
360 ,information262
361 ,information263
362 ,information264
363 ,information265
364 ,information266
365 ,information267
366 ,information268
367 ,information269
368 ,information270
369 ,information271
370 ,information272
371 ,information273
372 ,information274
373 ,information275
374 ,information276
375 ,information277
376 ,information278
377 ,information279
378 ,information280
379 ,information281
380 ,information282
381 ,information283
382 ,information284
383 ,information285
384 ,information286
385 ,information287
386 ,information288
387 ,information289
388 ,information290
389 ,information291
390 ,information292
391 ,information293
392 ,information294
393 ,information295
394 ,information296
395 ,information297
396 ,information298
397 ,information299
398 ,information300
399 ,information301
400 ,information302
401 ,information303
402 ,information304
403
404 /* Extra Reserved Columns
405 ,information305
406 */
407 ,information306
408 ,information307
409 ,information308
410 ,information309
411 ,information310
412 ,information311
413 ,information312
414 ,information313
415 ,information314
416 ,information315
417 ,information316
418 ,information317
419 ,information318
420 ,information319
421 ,information320
422
423 /* Extra Reserved Columns
424 ,information321
425 ,information322
426 */
427 ,information323
428 ,datetrack_mode
429 ,object_version_number
430 from ben_copy_entity_results
431 where copy_entity_result_id = p_copy_entity_result_id;
432 --
433 l_fct_ret boolean;
434 --
435 Begin
436 --
437 If (p_copy_entity_result_id is null and
438 p_object_version_number is null
439 ) Then
440 --
441 -- One of the primary key arguments is null therefore we must
442 -- set the returning function value to false
443 --
444 l_fct_ret := false;
445 Else
446 If (p_copy_entity_result_id
447 = ben_cpe_shd.g_old_rec.copy_entity_result_id and
448 p_object_version_number
449 = ben_cpe_shd.g_old_rec.object_version_number
450 ) Then
451 --
452 -- The g_old_rec is current therefore we must
453 -- set the returning function to true
454 --
455 l_fct_ret := true;
456 Else
457 --
458 -- Select the current row into g_old_rec
459 --
460 Open C_Sel1;
461 Fetch C_Sel1 Into ben_cpe_shd.g_old_rec;
462 If C_Sel1%notfound Then
463 Close C_Sel1;
464 --
465 -- The primary key is invalid therefore we must error
466 --
467 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
468 fnd_message.raise_error;
469 End If;
470 Close C_Sel1;
471 If (p_object_version_number
472 <> ben_cpe_shd.g_old_rec.object_version_number) Then
473 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
474 fnd_message.raise_error;
475 End If;
476 l_fct_ret := true;
477 End If;
478 End If;
479 Return (l_fct_ret);
480 --
481 End api_updating;
482 --
483 -- ----------------------------------------------------------------------------
484 -- |---------------------------------< lck >----------------------------------|
485 -- ----------------------------------------------------------------------------
486 Procedure lck
487 (p_copy_entity_result_id in number
488 ,p_object_version_number in number
489 ) is
490 --
491 -- Cursor selects the 'current' row from the HR Schema
492 --
493 Cursor C_Sel1 is
494 select
495 copy_entity_result_id
496 ,copy_entity_txn_id
497 ,src_copy_entity_result_id
498 ,result_type_cd
499 ,number_of_copies
500 ,mirror_entity_result_id
501 ,mirror_src_entity_result_id
502 ,parent_entity_result_id
503 ,pd_mirror_src_entity_result_id
504 ,pd_parent_entity_result_id
505 ,gs_mirror_src_entity_result_id
506 ,gs_parent_entity_result_id
507 ,table_name
508 ,table_alias
509 ,table_route_id
510 ,status
511 ,dml_operation
512 ,information_category
513 ,information1
514 ,information2
515 ,information3
516 ,information4
517 ,information5
518 ,information6
519 ,information7
520 ,information8
521 ,information9
522 ,information10
523 ,information11
524 ,information12
525 ,information13
526 ,information14
527 ,information15
528 ,information16
529 ,information17
530 ,information18
531 ,information19
532 ,information20
533 ,information21
534 ,information22
535 ,information23
536 ,information24
537 ,information25
538 ,information26
539 ,information27
540 ,information28
541 ,information29
542 ,information30
543 ,information31
544 ,information32
545 ,information33
546 ,information34
547 ,information35
548 ,information36
549 ,information37
550 ,information38
551 ,information39
552 ,information40
553 ,information41
554 ,information42
555 ,information43
556 ,information44
557 ,information45
558 ,information46
559 ,information47
560 ,information48
561 ,information49
562 ,information50
563 ,information51
564 ,information52
565 ,information53
566 ,information54
567 ,information55
568 ,information56
569 ,information57
570 ,information58
571 ,information59
572 ,information60
573 ,information61
574 ,information62
575 ,information63
576 ,information64
577 ,information65
578 ,information66
579 ,information67
580 ,information68
581 ,information69
582 ,information70
583 ,information71
584 ,information72
585 ,information73
586 ,information74
587 ,information75
588 ,information76
589 ,information77
590 ,information78
591 ,information79
592 ,information80
593 ,information81
594 ,information82
595 ,information83
596 ,information84
597 ,information85
598 ,information86
599 ,information87
600 ,information88
601 ,information89
602 ,information90
603 ,information91
604 ,information92
605 ,information93
606 ,information94
607 ,information95
608 ,information96
609 ,information97
610 ,information98
611 ,information99
612 ,information100
613 ,information101
614 ,information102
615 ,information103
616 ,information104
617 ,information105
618 ,information106
619 ,information107
620 ,information108
621 ,information109
622 ,information110
623 ,information111
624 ,information112
625 ,information113
626 ,information114
627 ,information115
628 ,information116
629 ,information117
630 ,information118
631 ,information119
632 ,information120
633 ,information121
634 ,information122
635 ,information123
636 ,information124
637 ,information125
638 ,information126
639 ,information127
640 ,information128
641 ,information129
642 ,information130
643 ,information131
644 ,information132
645 ,information133
646 ,information134
647 ,information135
648 ,information136
649 ,information137
650 ,information138
651 ,information139
652 ,information140
653 ,information141
654 ,information142
655
656 /* Extra Reserved Columns
657 ,information143
658 ,information144
659 ,information145
660 ,information146
661 ,information147
662 ,information148
663 ,information149
664 ,information150
665 */
666 ,information151
667 ,information152
668 ,information153
669
670 /* Extra Reserved Columns
671 ,information154
672 ,information155
673 ,information156
674 ,information157
675 ,information158
676 ,information159
677 */
678 ,information160
679 ,information161
680 ,information162
681
682 /* Extra Reserved Columns
683 ,information163
684 ,information164
685 ,information165
686 */
687 ,information166
688 ,information167
689 ,information168
690 ,information169
691 ,information170
692
693 /* Extra Reserved Columns
694 ,information171
695 ,information172
699 ,information175
696 */
697 ,information173
698 ,information174
700 ,information176
701 ,information177
702 ,information178
703 ,information179
704 ,information180
705 ,information181
706 ,information182
707
708 /* Extra Reserved Columns
709 ,information183
710 ,information184
711 */
712 ,information185
713 ,information186
714 ,information187
715 ,information188
716
717 /* Extra Reserved Columns
718 ,information189
719 */
720 ,information190
721 ,information191
722 ,information192
723 ,information193
724 ,information194
725 ,information195
726 ,information196
727 ,information197
728 ,information198
729 ,information199
730
731 /* Extra Reserved Columns
732 ,information200
733 ,information201
734 ,information202
735 ,information203
736 ,information204
737 ,information205
738 ,information206
739 ,information207
740 ,information208
741 ,information209
742 ,information210
743 ,information211
744 ,information212
745 ,information213
746 ,information214
747 ,information215
748 */
749 ,information216
750 ,information217
751 ,information218
752 ,information219
753 ,information220
754 ,information221
755 ,information222
756 ,information223
757 ,information224
758 ,information225
759 ,information226
760 ,information227
761 ,information228
762 ,information229
763 ,information230
764 ,information231
765 ,information232
766 ,information233
767 ,information234
768 ,information235
769 ,information236
770 ,information237
771 ,information238
772 ,information239
773 ,information240
774 ,information241
775 ,information242
776 ,information243
777 ,information244
778 ,information245
779 ,information246
780 ,information247
781 ,information248
782 ,information249
783 ,information250
784 ,information251
785 ,information252
786 ,information253
787 ,information254
788 ,information255
789 ,information256
790 ,information257
791 ,information258
792 ,information259
793 ,information260
794 ,information261
795 ,information262
796 ,information263
797 ,information264
798 ,information265
799 ,information266
800 ,information267
801 ,information268
802 ,information269
803 ,information270
804 ,information271
805 ,information272
806 ,information273
807 ,information274
808 ,information275
809 ,information276
810 ,information277
811 ,information278
812 ,information279
813 ,information280
814 ,information281
815 ,information282
816 ,information283
817 ,information284
818 ,information285
819 ,information286
820 ,information287
821 ,information288
822 ,information289
823 ,information290
824 ,information291
825 ,information292
826 ,information293
827 ,information294
828 ,information295
829 ,information296
830 ,information297
831 ,information298
832 ,information299
833 ,information300
834 ,information301
835 ,information302
836 ,information303
837 ,information304
838
839 /* Extra Reserved Columns
840 ,information305
841 */
842 ,information306
843 ,information307
844 ,information308
845 ,information309
846 ,information310
847 ,information311
848 ,information312
849 ,information313
850 ,information314
851 ,information315
852 ,information316
853 ,information317
854 ,information318
855 ,information319
856 ,information320
857
858 /* Extra Reserved Columns
859 ,information321
860 ,information322
861 */
862 ,information323
863 ,datetrack_mode
864 ,object_version_number
865 from ben_copy_entity_results
866 where copy_entity_result_id = p_copy_entity_result_id
867 for update nowait;
868 --
869 l_proc varchar2(72) := g_package||'lck';
870 --
871 Begin
872 hr_utility.set_location('Entering:'||l_proc, 5);
873 --
874 hr_api.mandatory_arg_error
875 (p_api_name => l_proc
876 ,p_argument => 'COPY_ENTITY_RESULT_ID'
877 ,p_argument_value => p_copy_entity_result_id
878 );
879 hr_utility.set_location(l_proc,6);
883 ,p_argument_value => p_object_version_number
880 hr_api.mandatory_arg_error
881 (p_api_name => l_proc
882 ,p_argument => 'OBJECT_VERSION_NUMBER'
884 );
885 --
886 Open C_Sel1;
887 Fetch C_Sel1 Into ben_cpe_shd.g_old_rec;
888 If C_Sel1%notfound then
889 Close C_Sel1;
890 --
891 -- The primary key is invalid therefore we must error
892 --
893 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
894 fnd_message.raise_error;
895 End If;
896 Close C_Sel1;
897 If (p_object_version_number
898 <> ben_cpe_shd.g_old_rec.object_version_number) Then
899 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
900 fnd_message.raise_error;
901 End If;
902 --
903 hr_utility.set_location(' Leaving:'||l_proc, 10);
904 --
905 -- We need to trap the ORA LOCK exception
906 --
907 Exception
908 When HR_Api.Object_Locked then
909 --
910 -- The object is locked therefore we need to supply a meaningful
911 -- error message.
912 --
913 fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
914 fnd_message.set_token('TABLE_NAME', 'ben_copy_entity_results');
915 fnd_message.raise_error;
916 End lck;
917 --
918 -- ----------------------------------------------------------------------------
919 -- |-----------------------------< convert_args >-----------------------------|
920 -- ----------------------------------------------------------------------------
921 Function convert_args
922 (p_copy_entity_result_id in number
923 ,p_copy_entity_txn_id in number
924 ,p_src_copy_entity_result_id in number
925 ,p_result_type_cd in varchar2
926 ,p_number_of_copies in number
927 ,p_mirror_entity_result_id in number
928 ,p_mirror_src_entity_result_id in number
929 ,p_parent_entity_result_id in number
930 ,p_pd_mr_src_entity_result_id in number
931 ,p_pd_parent_entity_result_id in number
932 ,p_gs_mr_src_entity_result_id in number
933 ,p_gs_parent_entity_result_id in number
934 ,p_table_name in varchar2
935 ,p_table_alias in varchar2
936 ,p_table_route_id in number
937 ,p_status in varchar2
938 ,p_dml_operation in varchar2
939 ,p_information_category in varchar2
940 ,p_information1 in number
941 ,p_information2 in date
942 ,p_information3 in date
943 ,p_information4 in number
944 ,p_information5 in varchar2
945 ,p_information6 in varchar2
946 ,p_information7 in varchar2
947 ,p_information8 in varchar2
948 ,p_information9 in varchar2
949 ,p_information10 in date
950 ,p_information11 in varchar2
951 ,p_information12 in varchar2
952 ,p_information13 in varchar2
953 ,p_information14 in varchar2
954 ,p_information15 in varchar2
955 ,p_information16 in varchar2
956 ,p_information17 in varchar2
957 ,p_information18 in varchar2
958 ,p_information19 in varchar2
959 ,p_information20 in varchar2
960 ,p_information21 in varchar2
961 ,p_information22 in varchar2
962 ,p_information23 in varchar2
963 ,p_information24 in varchar2
964 ,p_information25 in varchar2
965 ,p_information26 in varchar2
966 ,p_information27 in varchar2
967 ,p_information28 in varchar2
968 ,p_information29 in varchar2
969 ,p_information30 in varchar2
970 ,p_information31 in varchar2
971 ,p_information32 in varchar2
972 ,p_information33 in varchar2
973 ,p_information34 in varchar2
974 ,p_information35 in varchar2
975 ,p_information36 in varchar2
976 ,p_information37 in varchar2
977 ,p_information38 in varchar2
978 ,p_information39 in varchar2
979 ,p_information40 in varchar2
980 ,p_information41 in varchar2
981 ,p_information42 in varchar2
982 ,p_information43 in varchar2
983 ,p_information44 in varchar2
984 ,p_information45 in varchar2
985 ,p_information46 in varchar2
986 ,p_information47 in varchar2
987 ,p_information48 in varchar2
988 ,p_information49 in varchar2
989 ,p_information50 in varchar2
990 ,p_information51 in varchar2
991 ,p_information52 in varchar2
992 ,p_information53 in varchar2
993 ,p_information54 in varchar2
994 ,p_information55 in varchar2
995 ,p_information56 in varchar2
996 ,p_information57 in varchar2
997 ,p_information58 in varchar2
1001 ,p_information62 in varchar2
998 ,p_information59 in varchar2
999 ,p_information60 in varchar2
1000 ,p_information61 in varchar2
1002 ,p_information63 in varchar2
1003 ,p_information64 in varchar2
1004 ,p_information65 in varchar2
1005 ,p_information66 in varchar2
1006 ,p_information67 in varchar2
1007 ,p_information68 in varchar2
1008 ,p_information69 in varchar2
1009 ,p_information70 in varchar2
1010 ,p_information71 in varchar2
1011 ,p_information72 in varchar2
1012 ,p_information73 in varchar2
1013 ,p_information74 in varchar2
1014 ,p_information75 in varchar2
1015 ,p_information76 in varchar2
1016 ,p_information77 in varchar2
1017 ,p_information78 in varchar2
1018 ,p_information79 in varchar2
1019 ,p_information80 in varchar2
1020 ,p_information81 in varchar2
1021 ,p_information82 in varchar2
1022 ,p_information83 in varchar2
1023 ,p_information84 in varchar2
1024 ,p_information85 in varchar2
1025 ,p_information86 in varchar2
1026 ,p_information87 in varchar2
1027 ,p_information88 in varchar2
1028 ,p_information89 in varchar2
1029 ,p_information90 in varchar2
1030 ,p_information91 in varchar2
1031 ,p_information92 in varchar2
1032 ,p_information93 in varchar2
1033 ,p_information94 in varchar2
1034 ,p_information95 in varchar2
1035 ,p_information96 in varchar2
1036 ,p_information97 in varchar2
1037 ,p_information98 in varchar2
1038 ,p_information99 in varchar2
1039 ,p_information100 in varchar2
1040 ,p_information101 in varchar2
1041 ,p_information102 in varchar2
1042 ,p_information103 in varchar2
1043 ,p_information104 in varchar2
1044 ,p_information105 in varchar2
1045 ,p_information106 in varchar2
1046 ,p_information107 in varchar2
1047 ,p_information108 in varchar2
1048 ,p_information109 in varchar2
1049 ,p_information110 in varchar2
1050 ,p_information111 in varchar2
1051 ,p_information112 in varchar2
1052 ,p_information113 in varchar2
1053 ,p_information114 in varchar2
1054 ,p_information115 in varchar2
1055 ,p_information116 in varchar2
1056 ,p_information117 in varchar2
1057 ,p_information118 in varchar2
1058 ,p_information119 in varchar2
1059 ,p_information120 in varchar2
1060 ,p_information121 in varchar2
1061 ,p_information122 in varchar2
1062 ,p_information123 in varchar2
1063 ,p_information124 in varchar2
1064 ,p_information125 in varchar2
1065 ,p_information126 in varchar2
1066 ,p_information127 in varchar2
1067 ,p_information128 in varchar2
1068 ,p_information129 in varchar2
1069 ,p_information130 in varchar2
1070 ,p_information131 in varchar2
1071 ,p_information132 in varchar2
1072 ,p_information133 in varchar2
1073 ,p_information134 in varchar2
1074 ,p_information135 in varchar2
1075 ,p_information136 in varchar2
1076 ,p_information137 in varchar2
1077 ,p_information138 in varchar2
1078 ,p_information139 in varchar2
1079 ,p_information140 in varchar2
1080 ,p_information141 in varchar2
1081 ,p_information142 in varchar2
1082
1083 /* Extra Reserved Columns
1084 ,p_information143 in varchar2
1085 ,p_information144 in varchar2
1086 ,p_information145 in varchar2
1087 ,p_information146 in varchar2
1088 ,p_information147 in varchar2
1089 ,p_information148 in varchar2
1090 ,p_information149 in varchar2
1091 ,p_information150 in varchar2
1092 */
1093 ,p_information151 in varchar2
1094 ,p_information152 in varchar2
1095 ,p_information153 in varchar2
1096
1097 /* Extra Reserved Columns
1098 ,p_information154 in varchar2
1099 ,p_information155 in varchar2
1100 ,p_information156 in varchar2
1101 ,p_information157 in varchar2
1102 ,p_information158 in varchar2
1103 ,p_information159 in varchar2
1104 */
1105 ,p_information160 in number
1106 ,p_information161 in number
1107 ,p_information162 in number
1108
1109 /* Extra Reserved Columns
1110 ,p_information163 in number
1114 ,p_information166 in date
1111 ,p_information164 in number
1112 ,p_information165 in number
1113 */
1115 ,p_information167 in date
1116 ,p_information168 in date
1117 ,p_information169 in number
1118 ,p_information170 in varchar2
1119
1120 /* Extra Reserved Columns
1121 ,p_information171 in varchar2
1122 ,p_information172 in varchar2
1123 */
1124 ,p_information173 in varchar2
1125 ,p_information174 in number
1126 ,p_information175 in varchar2
1127 ,p_information176 in number
1128 ,p_information177 in varchar2
1129 ,p_information178 in number
1130 ,p_information179 in varchar2
1131 ,p_information180 in number
1132 ,p_information181 in varchar2
1133 ,p_information182 in varchar2
1134
1135 /* Extra Reserved Columns
1136 ,p_information183 in varchar2
1137 ,p_information184 in varchar2
1138 */
1139 ,p_information185 in varchar2
1140 ,p_information186 in varchar2
1141 ,p_information187 in varchar2
1142 ,p_information188 in varchar2
1143
1144 /* Extra Reserved Columns
1145 ,p_information189 in varchar2
1146 */
1147 ,p_information190 in varchar2
1148 ,p_information191 in varchar2
1149 ,p_information192 in varchar2
1150 ,p_information193 in varchar2
1151 ,p_information194 in varchar2
1152 ,p_information195 in varchar2
1153 ,p_information196 in varchar2
1154 ,p_information197 in varchar2
1155 ,p_information198 in varchar2
1156 ,p_information199 in varchar2
1157
1158 /* Extra Reserved Columns
1159 ,p_information200 in varchar2
1160 ,p_information201 in varchar2
1161 ,p_information202 in varchar2
1162 ,p_information203 in varchar2
1163 ,p_information204 in varchar2
1164 ,p_information205 in varchar2
1165 ,p_information206 in varchar2
1166 ,p_information207 in varchar2
1167 ,p_information208 in varchar2
1168 ,p_information209 in varchar2
1169 ,p_information210 in varchar2
1170 ,p_information211 in varchar2
1171 ,p_information212 in varchar2
1172 ,p_information213 in varchar2
1173 ,p_information214 in varchar2
1174 ,p_information215 in varchar2
1175 */
1176 ,p_information216 in varchar2
1177 ,p_information217 in varchar2
1178 ,p_information218 in varchar2
1179 ,p_information219 in varchar2
1180 ,p_information220 in varchar2
1181 ,p_information221 in number
1182 ,p_information222 in number
1183 ,p_information223 in number
1184 ,p_information224 in number
1185 ,p_information225 in number
1186 ,p_information226 in number
1187 ,p_information227 in number
1188 ,p_information228 in number
1189 ,p_information229 in number
1190 ,p_information230 in number
1191 ,p_information231 in number
1192 ,p_information232 in number
1193 ,p_information233 in number
1194 ,p_information234 in number
1195 ,p_information235 in number
1196 ,p_information236 in number
1197 ,p_information237 in number
1198 ,p_information238 in number
1199 ,p_information239 in number
1200 ,p_information240 in number
1201 ,p_information241 in number
1202 ,p_information242 in number
1203 ,p_information243 in number
1204 ,p_information244 in number
1205 ,p_information245 in number
1206 ,p_information246 in number
1207 ,p_information247 in number
1208 ,p_information248 in number
1209 ,p_information249 in number
1210 ,p_information250 in number
1211 ,p_information251 in number
1212 ,p_information252 in number
1213 ,p_information253 in number
1214 ,p_information254 in number
1215 ,p_information255 in number
1216 ,p_information256 in number
1217 ,p_information257 in number
1218 ,p_information258 in number
1219 ,p_information259 in number
1220 ,p_information260 in number
1221 ,p_information261 in number
1222 ,p_information262 in number
1223 ,p_information263 in number
1224 ,p_information264 in number
1225 ,p_information265 in number
1229 ,p_information269 in number
1226 ,p_information266 in number
1227 ,p_information267 in number
1228 ,p_information268 in number
1230 ,p_information270 in number
1231 ,p_information271 in number
1232 ,p_information272 in number
1233 ,p_information273 in number
1234 ,p_information274 in number
1235 ,p_information275 in number
1236 ,p_information276 in number
1237 ,p_information277 in number
1238 ,p_information278 in number
1239 ,p_information279 in number
1240 ,p_information280 in number
1241 ,p_information281 in number
1242 ,p_information282 in number
1243 ,p_information283 in number
1244 ,p_information284 in number
1245 ,p_information285 in number
1246 ,p_information286 in number
1247 ,p_information287 in number
1248 ,p_information288 in number
1249 ,p_information289 in number
1250 ,p_information290 in number
1251 ,p_information291 in number
1252 ,p_information292 in number
1253 ,p_information293 in number
1254 ,p_information294 in number
1255 ,p_information295 in number
1256 ,p_information296 in number
1257 ,p_information297 in number
1258 ,p_information298 in number
1259 ,p_information299 in number
1260 ,p_information300 in number
1261 ,p_information301 in number
1262 ,p_information302 in number
1263 ,p_information303 in number
1264 ,p_information304 in number
1265
1266 /* Extra Reserved Columns
1267 ,p_information305 in number
1268 */
1269 ,p_information306 in date
1270 ,p_information307 in date
1271 ,p_information308 in date
1272 ,p_information309 in date
1273 ,p_information310 in date
1274 ,p_information311 in date
1275 ,p_information312 in date
1276 ,p_information313 in date
1277 ,p_information314 in date
1278 ,p_information315 in date
1279 ,p_information316 in date
1280 ,p_information317 in date
1281 ,p_information318 in date
1282 ,p_information319 in date
1283 ,p_information320 in date
1284
1285 /* Extra Reserved Columns
1286 ,p_information321 in date
1287 ,p_information322 in date
1288 */
1289 ,p_information323 in long
1290 ,p_datetrack_mode in varchar2
1291 ,p_object_version_number in number
1292 )
1293 Return g_rec_type is
1294 --
1295 l_rec g_rec_type;
1296 --
1297 Begin
1298 --
1299 -- Convert arguments into local l_rec structure.
1300 --
1301 l_rec.copy_entity_result_id := p_copy_entity_result_id;
1302 l_rec.copy_entity_txn_id := p_copy_entity_txn_id;
1303 l_rec.src_copy_entity_result_id := p_src_copy_entity_result_id;
1304 l_rec.result_type_cd := p_result_type_cd;
1305 l_rec.number_of_copies := p_number_of_copies;
1306 l_rec.mirror_entity_result_id := p_mirror_entity_result_id;
1307 l_rec.mirror_src_entity_result_id := p_mirror_src_entity_result_id;
1308 l_rec.parent_entity_result_id := p_parent_entity_result_id;
1309 l_rec.pd_mirror_src_entity_result_id := p_pd_mr_src_entity_result_id;
1310 l_rec.pd_parent_entity_result_id := p_pd_parent_entity_result_id;
1311 l_rec.gs_mirror_src_entity_result_id := p_gs_mr_src_entity_result_id;
1312 l_rec.gs_parent_entity_result_id := p_gs_parent_entity_result_id;
1313 l_rec.table_name := p_table_name;
1314 l_rec.table_alias := p_table_alias;
1315 l_rec.table_route_id := p_table_route_id;
1316 l_rec.status := p_status;
1317 l_rec.dml_operation := p_dml_operation;
1318 l_rec.information_category := p_information_category;
1319 l_rec.information1 := p_information1;
1320 l_rec.information2 := p_information2;
1321 l_rec.information3 := p_information3;
1322 l_rec.information4 := p_information4;
1323 l_rec.information5 := p_information5;
1324 l_rec.information6 := p_information6;
1325 l_rec.information7 := p_information7;
1326 l_rec.information8 := p_information8;
1327 l_rec.information9 := p_information9;
1328 l_rec.information10 := p_information10;
1329 l_rec.information11 := p_information11;
1330 l_rec.information12 := p_information12;
1334 l_rec.information16 := p_information16;
1331 l_rec.information13 := p_information13;
1332 l_rec.information14 := p_information14;
1333 l_rec.information15 := p_information15;
1335 l_rec.information17 := p_information17;
1336 l_rec.information18 := p_information18;
1337 l_rec.information19 := p_information19;
1338 l_rec.information20 := p_information20;
1339 l_rec.information21 := p_information21;
1340 l_rec.information22 := p_information22;
1341 l_rec.information23 := p_information23;
1342 l_rec.information24 := p_information24;
1343 l_rec.information25 := p_information25;
1344 l_rec.information26 := p_information26;
1345 l_rec.information27 := p_information27;
1346 l_rec.information28 := p_information28;
1347 l_rec.information29 := p_information29;
1348 l_rec.information30 := p_information30;
1349 l_rec.information31 := p_information31;
1350 l_rec.information32 := p_information32;
1351 l_rec.information33 := p_information33;
1352 l_rec.information34 := p_information34;
1353 l_rec.information35 := p_information35;
1354 l_rec.information36 := p_information36;
1355 l_rec.information37 := p_information37;
1356 l_rec.information38 := p_information38;
1357 l_rec.information39 := p_information39;
1358 l_rec.information40 := p_information40;
1359 l_rec.information41 := p_information41;
1360 l_rec.information42 := p_information42;
1361 l_rec.information43 := p_information43;
1362 l_rec.information44 := p_information44;
1363 l_rec.information45 := p_information45;
1364 l_rec.information46 := p_information46;
1365 l_rec.information47 := p_information47;
1366 l_rec.information48 := p_information48;
1367 l_rec.information49 := p_information49;
1368 l_rec.information50 := p_information50;
1369 l_rec.information51 := p_information51;
1370 l_rec.information52 := p_information52;
1371 l_rec.information53 := p_information53;
1372 l_rec.information54 := p_information54;
1373 l_rec.information55 := p_information55;
1374 l_rec.information56 := p_information56;
1375 l_rec.information57 := p_information57;
1376 l_rec.information58 := p_information58;
1377 l_rec.information59 := p_information59;
1378 l_rec.information60 := p_information60;
1379 l_rec.information61 := p_information61;
1380 l_rec.information62 := p_information62;
1381 l_rec.information63 := p_information63;
1382 l_rec.information64 := p_information64;
1383 l_rec.information65 := p_information65;
1384 l_rec.information66 := p_information66;
1385 l_rec.information67 := p_information67;
1386 l_rec.information68 := p_information68;
1387 l_rec.information69 := p_information69;
1388 l_rec.information70 := p_information70;
1389 l_rec.information71 := p_information71;
1390 l_rec.information72 := p_information72;
1391 l_rec.information73 := p_information73;
1392 l_rec.information74 := p_information74;
1393 l_rec.information75 := p_information75;
1394 l_rec.information76 := p_information76;
1395 l_rec.information77 := p_information77;
1396 l_rec.information78 := p_information78;
1397 l_rec.information79 := p_information79;
1398 l_rec.information80 := p_information80;
1399 l_rec.information81 := p_information81;
1400 l_rec.information82 := p_information82;
1401 l_rec.information83 := p_information83;
1402 l_rec.information84 := p_information84;
1403 l_rec.information85 := p_information85;
1404 l_rec.information86 := p_information86;
1405 l_rec.information87 := p_information87;
1406 l_rec.information88 := p_information88;
1407 l_rec.information89 := p_information89;
1408 l_rec.information90 := p_information90;
1409 l_rec.information91 := p_information91;
1410 l_rec.information92 := p_information92;
1411 l_rec.information93 := p_information93;
1412 l_rec.information94 := p_information94;
1413 l_rec.information95 := p_information95;
1414 l_rec.information96 := p_information96;
1415 l_rec.information97 := p_information97;
1416 l_rec.information98 := p_information98;
1420 l_rec.information102 := p_information102;
1417 l_rec.information99 := p_information99;
1418 l_rec.information100 := p_information100;
1419 l_rec.information101 := p_information101;
1421 l_rec.information103 := p_information103;
1422 l_rec.information104 := p_information104;
1423 l_rec.information105 := p_information105;
1424 l_rec.information106 := p_information106;
1425 l_rec.information107 := p_information107;
1426 l_rec.information108 := p_information108;
1427 l_rec.information109 := p_information109;
1428 l_rec.information110 := p_information110;
1429 l_rec.information111 := p_information111;
1430 l_rec.information112 := p_information112;
1431 l_rec.information113 := p_information113;
1432 l_rec.information114 := p_information114;
1433 l_rec.information115 := p_information115;
1434 l_rec.information116 := p_information116;
1435 l_rec.information117 := p_information117;
1436 l_rec.information118 := p_information118;
1437 l_rec.information119 := p_information119;
1438 l_rec.information120 := p_information120;
1439 l_rec.information121 := p_information121;
1440 l_rec.information122 := p_information122;
1441 l_rec.information123 := p_information123;
1442 l_rec.information124 := p_information124;
1443 l_rec.information125 := p_information125;
1444 l_rec.information126 := p_information126;
1445 l_rec.information127 := p_information127;
1446 l_rec.information128 := p_information128;
1447 l_rec.information129 := p_information129;
1448 l_rec.information130 := p_information130;
1449 l_rec.information131 := p_information131;
1450 l_rec.information132 := p_information132;
1451 l_rec.information133 := p_information133;
1452 l_rec.information134 := p_information134;
1453 l_rec.information135 := p_information135;
1454 l_rec.information136 := p_information136;
1455 l_rec.information137 := p_information137;
1456 l_rec.information138 := p_information138;
1457 l_rec.information139 := p_information139;
1458 l_rec.information140 := p_information140;
1459 l_rec.information141 := p_information141;
1460 l_rec.information142 := p_information142;
1461
1462 /* Extra Reserved Columns
1463 l_rec.information143 := p_information143;
1464 l_rec.information144 := p_information144;
1465 l_rec.information145 := p_information145;
1466 l_rec.information146 := p_information146;
1467 l_rec.information147 := p_information147;
1468 l_rec.information148 := p_information148;
1469 l_rec.information149 := p_information149;
1470 l_rec.information150 := p_information150;
1471 */
1472 l_rec.information151 := p_information151;
1473 l_rec.information152 := p_information152;
1474 l_rec.information153 := p_information153;
1475
1476 /* Extra Reserved Columns
1477 l_rec.information154 := p_information154;
1478 l_rec.information155 := p_information155;
1479 l_rec.information156 := p_information156;
1480 l_rec.information157 := p_information157;
1481 l_rec.information158 := p_information158;
1482 l_rec.information159 := p_information159;
1483 */
1484 l_rec.information160 := p_information160;
1485 l_rec.information161 := p_information161;
1486 l_rec.information162 := p_information162;
1487
1488 /* Extra Reserved Columns
1489 l_rec.information163 := p_information163;
1490 l_rec.information164 := p_information164;
1491 l_rec.information165 := p_information165;
1492 */
1493 l_rec.information166 := p_information166;
1494 l_rec.information167 := p_information167;
1495 l_rec.information168 := p_information168;
1496 l_rec.information169 := p_information169;
1497 l_rec.information170 := p_information170;
1498
1499 /* Extra Reserved Columns
1500 l_rec.information171 := p_information171;
1501 l_rec.information172 := p_information172;
1502 */
1503 l_rec.information173 := p_information173;
1504 l_rec.information174 := p_information174;
1505 l_rec.information175 := p_information175;
1506 l_rec.information176 := p_information176;
1507 l_rec.information177 := p_information177;
1508 l_rec.information178 := p_information178;
1512 l_rec.information182 := p_information182;
1509 l_rec.information179 := p_information179;
1510 l_rec.information180 := p_information180;
1511 l_rec.information181 := p_information181;
1513
1514 /* Extra Reserved Columns
1515 l_rec.information183 := p_information183;
1516 l_rec.information184 := p_information184;
1517 */
1518 l_rec.information185 := p_information185;
1519 l_rec.information186 := p_information186;
1520 l_rec.information187 := p_information187;
1521 l_rec.information188 := p_information188;
1522
1523 /* Extra Reserved Columns
1524 l_rec.information189 := p_information189;
1525 */
1526 l_rec.information190 := p_information190;
1527 l_rec.information191 := p_information191;
1528 l_rec.information192 := p_information192;
1529 l_rec.information193 := p_information193;
1530 l_rec.information194 := p_information194;
1531 l_rec.information195 := p_information195;
1532 l_rec.information196 := p_information196;
1533 l_rec.information197 := p_information197;
1534 l_rec.information198 := p_information198;
1535 l_rec.information199 := p_information199;
1536
1537 /* Extra Reserved Columns
1538 l_rec.information200 := p_information200;
1539 l_rec.information201 := p_information201;
1540 l_rec.information202 := p_information202;
1541 l_rec.information203 := p_information203;
1542 l_rec.information204 := p_information204;
1543 l_rec.information205 := p_information205;
1544 l_rec.information206 := p_information206;
1545 l_rec.information207 := p_information207;
1546 l_rec.information208 := p_information208;
1547 l_rec.information209 := p_information209;
1548 l_rec.information210 := p_information210;
1549 l_rec.information211 := p_information211;
1550 l_rec.information212 := p_information212;
1551 l_rec.information213 := p_information213;
1552 l_rec.information214 := p_information214;
1553 l_rec.information215 := p_information215;
1554 */
1555 l_rec.information216 := p_information216;
1556 l_rec.information217 := p_information217;
1557 l_rec.information218 := p_information218;
1558 l_rec.information219 := p_information219;
1559 l_rec.information220 := p_information220;
1560 l_rec.information221 := p_information221;
1561 l_rec.information222 := p_information222;
1562 l_rec.information223 := p_information223;
1563 l_rec.information224 := p_information224;
1564 l_rec.information225 := p_information225;
1565 l_rec.information226 := p_information226;
1566 l_rec.information227 := p_information227;
1567 l_rec.information228 := p_information228;
1568 l_rec.information229 := p_information229;
1569 l_rec.information230 := p_information230;
1570 l_rec.information231 := p_information231;
1571 l_rec.information232 := p_information232;
1572 l_rec.information233 := p_information233;
1573 l_rec.information234 := p_information234;
1574 l_rec.information235 := p_information235;
1575 l_rec.information236 := p_information236;
1576 l_rec.information237 := p_information237;
1577 l_rec.information238 := p_information238;
1578 l_rec.information239 := p_information239;
1579 l_rec.information240 := p_information240;
1580 l_rec.information241 := p_information241;
1581 l_rec.information242 := p_information242;
1582 l_rec.information243 := p_information243;
1583 l_rec.information244 := p_information244;
1584 l_rec.information245 := p_information245;
1585 l_rec.information246 := p_information246;
1586 l_rec.information247 := p_information247;
1587 l_rec.information248 := p_information248;
1588 l_rec.information249 := p_information249;
1589 l_rec.information250 := p_information250;
1590 l_rec.information251 := p_information251;
1591 l_rec.information252 := p_information252;
1592 l_rec.information253 := p_information253;
1593 l_rec.information254 := p_information254;
1594 l_rec.information255 := p_information255;
1595 l_rec.information256 := p_information256;
1596 l_rec.information257 := p_information257;
1597 l_rec.information258 := p_information258;
1598 l_rec.information259 := p_information259;
1602 l_rec.information263 := p_information263;
1599 l_rec.information260 := p_information260;
1600 l_rec.information261 := p_information261;
1601 l_rec.information262 := p_information262;
1603 l_rec.information264 := p_information264;
1604 l_rec.information265 := p_information265;
1605 l_rec.information266 := p_information266;
1606 l_rec.information267 := p_information267;
1607 l_rec.information268 := p_information268;
1608 l_rec.information269 := p_information269;
1609 l_rec.information270 := p_information270;
1613 l_rec.information274 := p_information274;
1610 l_rec.information271 := p_information271;
1611 l_rec.information272 := p_information272;
1612 l_rec.information273 := p_information273;
1614 l_rec.information275 := p_information275;
1615 l_rec.information276 := p_information276;
1616 l_rec.information277 := p_information277;
1617 l_rec.information278 := p_information278;
1618 l_rec.information279 := p_information279;
1619 l_rec.information280 := p_information280;
1620 l_rec.information281 := p_information281;
1621 l_rec.information282 := p_information282;
1622 l_rec.information283 := p_information283;
1623 l_rec.information284 := p_information284;
1624 l_rec.information285 := p_information285;
1625 l_rec.information286 := p_information286;
1626 l_rec.information287 := p_information287;
1627 l_rec.information288 := p_information288;
1628 l_rec.information289 := p_information289;
1629 l_rec.information290 := p_information290;
1630 l_rec.information291 := p_information291;
1631 l_rec.information292 := p_information292;
1632 l_rec.information293 := p_information293;
1633 l_rec.information294 := p_information294;
1634 l_rec.information295 := p_information295;
1635 l_rec.information296 := p_information296;
1636 l_rec.information297 := p_information297;
1637 l_rec.information298 := p_information298;
1638 l_rec.information299 := p_information299;
1639 l_rec.information300 := p_information300;
1640 l_rec.information301 := p_information301;
1641 l_rec.information302 := p_information302;
1642 l_rec.information303 := p_information303;
1643 l_rec.information304 := p_information304;
1644
1645 /* Extra Reserved Columns
1646 l_rec.information305 := p_information305;
1647 */
1648 l_rec.information306 := p_information306;
1649 l_rec.information307 := p_information307;
1650 l_rec.information308 := p_information308;
1651 l_rec.information309 := p_information309;
1652 l_rec.information310 := p_information310;
1653 l_rec.information311 := p_information311;
1654 l_rec.information312 := p_information312;
1655 l_rec.information313 := p_information313;
1656 l_rec.information314 := p_information314;
1657 l_rec.information315 := p_information315;
1658 l_rec.information316 := p_information316;
1659 l_rec.information317 := p_information317;
1660 l_rec.information318 := p_information318;
1661 l_rec.information319 := p_information319;
1662 l_rec.information320 := p_information320;
1663
1664 /* Extra Reserved Columns
1665 l_rec.information321 := p_information321;
1666 l_rec.information322 := p_information322;
1667 */
1668 l_rec.information323 := p_information323;
1669 l_rec.datetrack_mode := p_datetrack_mode;
1670 l_rec.object_version_number := p_object_version_number;
1671 --
1672 -- Return the plsql record structure.
1673 --
1674 Return(l_rec);
1675 --
1676 End convert_args;
1677 --
1678 end ben_cpe_shd;