DBA Data[Home] [Help]

PACKAGE: APPS.AMS_EVENTOFFER_PVT_W_NEW

Source


1 package ams_eventoffer_pvt_w_new as
2   /* $Header: amsaevos.pls 120.0 2005/08/24 12:05 sikalyan noship $ */
3   procedure create_event_offer(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , p4_a0  NUMBER
8     , p4_a1  DATE
9     , p4_a2  NUMBER
10     , p4_a3  DATE
11     , p4_a4  NUMBER
12     , p4_a5  NUMBER
13     , p4_a6  NUMBER
14     , p4_a7  NUMBER
15     , p4_a8  NUMBER
16     , p4_a9  VARCHAR2
17     , p4_a10  VARCHAR2
18     , p4_a11  VARCHAR2
19     , p4_a12  VARCHAR2
20     , p4_a13  NUMBER
21     , p4_a14  DATE
22     , p4_a15  VARCHAR2
23     , p4_a16  VARCHAR2
24     , p4_a17  NUMBER
25     , p4_a18  VARCHAR2
26     , p4_a19  VARCHAR2
27     , p4_a20  VARCHAR2
28     , p4_a21  NUMBER
29     , p4_a22  VARCHAR2
30     , p4_a23  VARCHAR2
31     , p4_a24  VARCHAR2
32     , p4_a25  VARCHAR2
33     , p4_a26  VARCHAR2
34     , p4_a27  VARCHAR2
35     , p4_a28  VARCHAR2
36     , p4_a29  VARCHAR2
37     , p4_a30  VARCHAR2
38     , p4_a31  VARCHAR2
39     , p4_a32  VARCHAR2
40     , p4_a33  VARCHAR2
41     , p4_a34  VARCHAR2
42     , p4_a35  NUMBER
43     , p4_a36  NUMBER
44     , p4_a37  VARCHAR2
45     , p4_a38  DATE
46     , p4_a39  DATE
47     , p4_a40  DATE
48     , p4_a41  DATE
49     , p4_a42  DATE
50     , p4_a43  DATE
51     , p4_a44  DATE
52     , p4_a45  DATE
53     , p4_a46  NUMBER
54     , p4_a47  NUMBER
55     , p4_a48  NUMBER
56     , p4_a49  NUMBER
57     , p4_a50  NUMBER
58     , p4_a51  DATE
59     , p4_a52  NUMBER
60     , p4_a53  VARCHAR2
61     , p4_a54  NUMBER
62     , p4_a55  NUMBER
63     , p4_a56  NUMBER
64     , p4_a57  NUMBER
65     , p4_a58  VARCHAR2
66     , p4_a59  VARCHAR2
67     , p4_a60  NUMBER
68     , p4_a61  VARCHAR2
69     , p4_a62  NUMBER
70     , p4_a63  NUMBER
71     , p4_a64  NUMBER
72     , p4_a65  NUMBER
73     , p4_a66  VARCHAR2
74     , p4_a67  NUMBER
75     , p4_a68  VARCHAR2
76     , p4_a69  NUMBER
77     , p4_a70  NUMBER
78     , p4_a71  VARCHAR2
79     , p4_a72  VARCHAR2
80     , p4_a73  VARCHAR2
81     , p4_a74  VARCHAR2
82     , p4_a75  VARCHAR2
83     , p4_a76  NUMBER
84     , p4_a77  NUMBER
85     , p4_a78  VARCHAR2
86     , p4_a79  VARCHAR2
87     , p4_a80  VARCHAR2
88     , p4_a81  NUMBER
89     , p4_a82  NUMBER
90     , p4_a83  VARCHAR2
91     , p4_a84  NUMBER
92     , p4_a85  VARCHAR2
93     , p4_a86  VARCHAR2
94     , p4_a87  VARCHAR2
95     , p4_a88  VARCHAR2
96     , p4_a89  VARCHAR2
97     , p4_a90  VARCHAR2
98     , p4_a91  VARCHAR2
99     , p4_a92  VARCHAR2
100     , p4_a93  VARCHAR2
101     , p4_a94  VARCHAR2
102     , p4_a95  VARCHAR2
103     , p4_a96  VARCHAR2
104     , p4_a97  VARCHAR2
105     , p4_a98  VARCHAR2
106     , p4_a99  VARCHAR2
107     , p4_a100  VARCHAR2
108     , p4_a101  VARCHAR2
109     , p4_a102  VARCHAR2
110     , p4_a103  VARCHAR2
111     , p4_a104  VARCHAR2
112     , p4_a105  NUMBER
113     , p4_a106  VARCHAR2
114     , p4_a107  NUMBER
115     , p4_a108  VARCHAR2
116     , p4_a109  VARCHAR2
117     , p4_a110  VARCHAR2
118     , p4_a111  VARCHAR2
119     , p4_a112  NUMBER
120     , p4_a113  VARCHAR2
121     , p4_a114  NUMBER
122     , p4_a115  VARCHAR2
123     , p4_a116  VARCHAR2
124     , p4_a117  VARCHAR2
125     , p4_a118  NUMBER
126     , p4_a119  VARCHAR2
127     , p4_a120  VARCHAR2
128     , p4_a121  VARCHAR2
129     , p4_a122  VARCHAR2
130     , p4_a123  VARCHAR2
131     , p4_a124  VARCHAR2
132     , p4_a125  DATE
133     , p4_a126  DATE
134     , p4_a127  NUMBER
135     , p4_a128  NUMBER
136     , p4_a129  VARCHAR2
137     , p4_a130  VARCHAR2
138     , p4_a131  VARCHAR2
139     , p4_a132  VARCHAR2
140     , p4_a133  VARCHAR2
141     , p4_a134  VARCHAR2
142     , p4_a135  VARCHAR2
143     , p4_a136  NUMBER
144     , p4_a137  VARCHAR2
145     , x_return_status out nocopy  VARCHAR2
146     , x_msg_count out nocopy  NUMBER
147     , x_msg_data out nocopy  VARCHAR2
148     , x_evo_id out nocopy  NUMBER
149   );
150   procedure update_event_offer(p_api_version  NUMBER
151     , p_init_msg_list  VARCHAR2
152     , p_commit  VARCHAR2
153     , p_validation_level  NUMBER
154     , p4_a0  NUMBER
155     , p4_a1  DATE
156     , p4_a2  NUMBER
157     , p4_a3  DATE
158     , p4_a4  NUMBER
159     , p4_a5  NUMBER
160     , p4_a6  NUMBER
161     , p4_a7  NUMBER
162     , p4_a8  NUMBER
163     , p4_a9  VARCHAR2
164     , p4_a10  VARCHAR2
165     , p4_a11  VARCHAR2
166     , p4_a12  VARCHAR2
167     , p4_a13  NUMBER
168     , p4_a14  DATE
169     , p4_a15  VARCHAR2
170     , p4_a16  VARCHAR2
171     , p4_a17  NUMBER
172     , p4_a18  VARCHAR2
173     , p4_a19  VARCHAR2
174     , p4_a20  VARCHAR2
175     , p4_a21  NUMBER
176     , p4_a22  VARCHAR2
177     , p4_a23  VARCHAR2
178     , p4_a24  VARCHAR2
179     , p4_a25  VARCHAR2
180     , p4_a26  VARCHAR2
181     , p4_a27  VARCHAR2
182     , p4_a28  VARCHAR2
183     , p4_a29  VARCHAR2
184     , p4_a30  VARCHAR2
185     , p4_a31  VARCHAR2
186     , p4_a32  VARCHAR2
187     , p4_a33  VARCHAR2
188     , p4_a34  VARCHAR2
189     , p4_a35  NUMBER
190     , p4_a36  NUMBER
191     , p4_a37  VARCHAR2
192     , p4_a38  DATE
193     , p4_a39  DATE
194     , p4_a40  DATE
195     , p4_a41  DATE
196     , p4_a42  DATE
197     , p4_a43  DATE
198     , p4_a44  DATE
199     , p4_a45  DATE
200     , p4_a46  NUMBER
201     , p4_a47  NUMBER
202     , p4_a48  NUMBER
203     , p4_a49  NUMBER
204     , p4_a50  NUMBER
205     , p4_a51  DATE
206     , p4_a52  NUMBER
207     , p4_a53  VARCHAR2
208     , p4_a54  NUMBER
209     , p4_a55  NUMBER
210     , p4_a56  NUMBER
211     , p4_a57  NUMBER
212     , p4_a58  VARCHAR2
213     , p4_a59  VARCHAR2
214     , p4_a60  NUMBER
215     , p4_a61  VARCHAR2
216     , p4_a62  NUMBER
217     , p4_a63  NUMBER
218     , p4_a64  NUMBER
219     , p4_a65  NUMBER
220     , p4_a66  VARCHAR2
221     , p4_a67  NUMBER
222     , p4_a68  VARCHAR2
223     , p4_a69  NUMBER
224     , p4_a70  NUMBER
225     , p4_a71  VARCHAR2
226     , p4_a72  VARCHAR2
227     , p4_a73  VARCHAR2
228     , p4_a74  VARCHAR2
229     , p4_a75  VARCHAR2
230     , p4_a76  NUMBER
231     , p4_a77  NUMBER
232     , p4_a78  VARCHAR2
233     , p4_a79  VARCHAR2
234     , p4_a80  VARCHAR2
235     , p4_a81  NUMBER
236     , p4_a82  NUMBER
237     , p4_a83  VARCHAR2
238     , p4_a84  NUMBER
239     , p4_a85  VARCHAR2
240     , p4_a86  VARCHAR2
241     , p4_a87  VARCHAR2
242     , p4_a88  VARCHAR2
243     , p4_a89  VARCHAR2
244     , p4_a90  VARCHAR2
245     , p4_a91  VARCHAR2
246     , p4_a92  VARCHAR2
247     , p4_a93  VARCHAR2
248     , p4_a94  VARCHAR2
249     , p4_a95  VARCHAR2
250     , p4_a96  VARCHAR2
251     , p4_a97  VARCHAR2
252     , p4_a98  VARCHAR2
253     , p4_a99  VARCHAR2
254     , p4_a100  VARCHAR2
255     , p4_a101  VARCHAR2
256     , p4_a102  VARCHAR2
257     , p4_a103  VARCHAR2
258     , p4_a104  VARCHAR2
259     , p4_a105  NUMBER
260     , p4_a106  VARCHAR2
261     , p4_a107  NUMBER
262     , p4_a108  VARCHAR2
263     , p4_a109  VARCHAR2
264     , p4_a110  VARCHAR2
265     , p4_a111  VARCHAR2
266     , p4_a112  NUMBER
267     , p4_a113  VARCHAR2
268     , p4_a114  NUMBER
269     , p4_a115  VARCHAR2
270     , p4_a116  VARCHAR2
271     , p4_a117  VARCHAR2
272     , p4_a118  NUMBER
273     , p4_a119  VARCHAR2
274     , p4_a120  VARCHAR2
275     , p4_a121  VARCHAR2
276     , p4_a122  VARCHAR2
277     , p4_a123  VARCHAR2
278     , p4_a124  VARCHAR2
279     , p4_a125  DATE
280     , p4_a126  DATE
281     , p4_a127  NUMBER
282     , p4_a128  NUMBER
283     , p4_a129  VARCHAR2
284     , p4_a130  VARCHAR2
285     , p4_a131  VARCHAR2
286     , p4_a132  VARCHAR2
287     , p4_a133  VARCHAR2
288     , p4_a134  VARCHAR2
289     , p4_a135  VARCHAR2
290     , p4_a136  NUMBER
291     , p4_a137  VARCHAR2
292     , x_return_status out nocopy  VARCHAR2
293     , x_msg_count out nocopy  NUMBER
294     , x_msg_data out nocopy  VARCHAR2
295   );
296   procedure validate_event_offer(p_api_version  NUMBER
297     , p_init_msg_list  VARCHAR2
298     , p_validation_level  NUMBER
299     , p3_a0  NUMBER
300     , p3_a1  DATE
301     , p3_a2  NUMBER
302     , p3_a3  DATE
303     , p3_a4  NUMBER
304     , p3_a5  NUMBER
305     , p3_a6  NUMBER
306     , p3_a7  NUMBER
307     , p3_a8  NUMBER
308     , p3_a9  VARCHAR2
309     , p3_a10  VARCHAR2
310     , p3_a11  VARCHAR2
311     , p3_a12  VARCHAR2
312     , p3_a13  NUMBER
313     , p3_a14  DATE
314     , p3_a15  VARCHAR2
315     , p3_a16  VARCHAR2
316     , p3_a17  NUMBER
317     , p3_a18  VARCHAR2
318     , p3_a19  VARCHAR2
319     , p3_a20  VARCHAR2
320     , p3_a21  NUMBER
321     , p3_a22  VARCHAR2
322     , p3_a23  VARCHAR2
323     , p3_a24  VARCHAR2
324     , p3_a25  VARCHAR2
325     , p3_a26  VARCHAR2
326     , p3_a27  VARCHAR2
327     , p3_a28  VARCHAR2
328     , p3_a29  VARCHAR2
329     , p3_a30  VARCHAR2
330     , p3_a31  VARCHAR2
331     , p3_a32  VARCHAR2
332     , p3_a33  VARCHAR2
333     , p3_a34  VARCHAR2
334     , p3_a35  NUMBER
335     , p3_a36  NUMBER
336     , p3_a37  VARCHAR2
337     , p3_a38  DATE
338     , p3_a39  DATE
339     , p3_a40  DATE
340     , p3_a41  DATE
341     , p3_a42  DATE
342     , p3_a43  DATE
343     , p3_a44  DATE
344     , p3_a45  DATE
345     , p3_a46  NUMBER
346     , p3_a47  NUMBER
347     , p3_a48  NUMBER
348     , p3_a49  NUMBER
349     , p3_a50  NUMBER
350     , p3_a51  DATE
351     , p3_a52  NUMBER
352     , p3_a53  VARCHAR2
353     , p3_a54  NUMBER
354     , p3_a55  NUMBER
355     , p3_a56  NUMBER
356     , p3_a57  NUMBER
357     , p3_a58  VARCHAR2
358     , p3_a59  VARCHAR2
359     , p3_a60  NUMBER
360     , p3_a61  VARCHAR2
361     , p3_a62  NUMBER
362     , p3_a63  NUMBER
363     , p3_a64  NUMBER
364     , p3_a65  NUMBER
365     , p3_a66  VARCHAR2
366     , p3_a67  NUMBER
367     , p3_a68  VARCHAR2
368     , p3_a69  NUMBER
369     , p3_a70  NUMBER
370     , p3_a71  VARCHAR2
371     , p3_a72  VARCHAR2
372     , p3_a73  VARCHAR2
373     , p3_a74  VARCHAR2
374     , p3_a75  VARCHAR2
375     , p3_a76  NUMBER
376     , p3_a77  NUMBER
377     , p3_a78  VARCHAR2
378     , p3_a79  VARCHAR2
379     , p3_a80  VARCHAR2
380     , p3_a81  NUMBER
381     , p3_a82  NUMBER
382     , p3_a83  VARCHAR2
383     , p3_a84  NUMBER
384     , p3_a85  VARCHAR2
385     , p3_a86  VARCHAR2
386     , p3_a87  VARCHAR2
387     , p3_a88  VARCHAR2
388     , p3_a89  VARCHAR2
389     , p3_a90  VARCHAR2
390     , p3_a91  VARCHAR2
391     , p3_a92  VARCHAR2
392     , p3_a93  VARCHAR2
393     , p3_a94  VARCHAR2
394     , p3_a95  VARCHAR2
395     , p3_a96  VARCHAR2
396     , p3_a97  VARCHAR2
397     , p3_a98  VARCHAR2
398     , p3_a99  VARCHAR2
399     , p3_a100  VARCHAR2
400     , p3_a101  VARCHAR2
401     , p3_a102  VARCHAR2
402     , p3_a103  VARCHAR2
403     , p3_a104  VARCHAR2
404     , p3_a105  NUMBER
405     , p3_a106  VARCHAR2
406     , p3_a107  NUMBER
407     , p3_a108  VARCHAR2
408     , p3_a109  VARCHAR2
409     , p3_a110  VARCHAR2
410     , p3_a111  VARCHAR2
411     , p3_a112  NUMBER
412     , p3_a113  VARCHAR2
413     , p3_a114  NUMBER
414     , p3_a115  VARCHAR2
415     , p3_a116  VARCHAR2
416     , p3_a117  VARCHAR2
417     , p3_a118  NUMBER
418     , p3_a119  VARCHAR2
419     , p3_a120  VARCHAR2
420     , p3_a121  VARCHAR2
421     , p3_a122  VARCHAR2
422     , p3_a123  VARCHAR2
423     , p3_a124  VARCHAR2
424     , p3_a125  DATE
425     , p3_a126  DATE
426     , p3_a127  NUMBER
427     , p3_a128  NUMBER
428     , p3_a129  VARCHAR2
429     , p3_a130  VARCHAR2
430     , p3_a131  VARCHAR2
431     , p3_a132  VARCHAR2
432     , p3_a133  VARCHAR2
433     , p3_a134  VARCHAR2
434     , p3_a135  VARCHAR2
435     , p3_a136  NUMBER
436     , p3_a137  VARCHAR2
437     , x_return_status out nocopy  VARCHAR2
438     , x_msg_count out nocopy  NUMBER
439     , x_msg_data out nocopy  VARCHAR2
440   );
444     , p0_a3  DATE
441   procedure check_evo_items(p0_a0  NUMBER
442     , p0_a1  DATE
443     , p0_a2  NUMBER
445     , p0_a4  NUMBER
446     , p0_a5  NUMBER
447     , p0_a6  NUMBER
448     , p0_a7  NUMBER
449     , p0_a8  NUMBER
450     , p0_a9  VARCHAR2
451     , p0_a10  VARCHAR2
452     , p0_a11  VARCHAR2
453     , p0_a12  VARCHAR2
454     , p0_a13  NUMBER
455     , p0_a14  DATE
456     , p0_a15  VARCHAR2
457     , p0_a16  VARCHAR2
458     , p0_a17  NUMBER
459     , p0_a18  VARCHAR2
460     , p0_a19  VARCHAR2
461     , p0_a20  VARCHAR2
462     , p0_a21  NUMBER
463     , p0_a22  VARCHAR2
464     , p0_a23  VARCHAR2
465     , p0_a24  VARCHAR2
466     , p0_a25  VARCHAR2
467     , p0_a26  VARCHAR2
468     , p0_a27  VARCHAR2
469     , p0_a28  VARCHAR2
470     , p0_a29  VARCHAR2
471     , p0_a30  VARCHAR2
472     , p0_a31  VARCHAR2
473     , p0_a32  VARCHAR2
474     , p0_a33  VARCHAR2
475     , p0_a34  VARCHAR2
476     , p0_a35  NUMBER
477     , p0_a36  NUMBER
478     , p0_a37  VARCHAR2
479     , p0_a38  DATE
480     , p0_a39  DATE
481     , p0_a40  DATE
482     , p0_a41  DATE
483     , p0_a42  DATE
484     , p0_a43  DATE
485     , p0_a44  DATE
486     , p0_a45  DATE
487     , p0_a46  NUMBER
488     , p0_a47  NUMBER
489     , p0_a48  NUMBER
490     , p0_a49  NUMBER
491     , p0_a50  NUMBER
492     , p0_a51  DATE
493     , p0_a52  NUMBER
494     , p0_a53  VARCHAR2
495     , p0_a54  NUMBER
496     , p0_a55  NUMBER
497     , p0_a56  NUMBER
498     , p0_a57  NUMBER
499     , p0_a58  VARCHAR2
500     , p0_a59  VARCHAR2
501     , p0_a60  NUMBER
502     , p0_a61  VARCHAR2
503     , p0_a62  NUMBER
504     , p0_a63  NUMBER
505     , p0_a64  NUMBER
506     , p0_a65  NUMBER
507     , p0_a66  VARCHAR2
508     , p0_a67  NUMBER
509     , p0_a68  VARCHAR2
510     , p0_a69  NUMBER
511     , p0_a70  NUMBER
512     , p0_a71  VARCHAR2
513     , p0_a72  VARCHAR2
514     , p0_a73  VARCHAR2
515     , p0_a74  VARCHAR2
516     , p0_a75  VARCHAR2
517     , p0_a76  NUMBER
518     , p0_a77  NUMBER
519     , p0_a78  VARCHAR2
520     , p0_a79  VARCHAR2
521     , p0_a80  VARCHAR2
522     , p0_a81  NUMBER
523     , p0_a82  NUMBER
524     , p0_a83  VARCHAR2
525     , p0_a84  NUMBER
526     , p0_a85  VARCHAR2
527     , p0_a86  VARCHAR2
528     , p0_a87  VARCHAR2
529     , p0_a88  VARCHAR2
530     , p0_a89  VARCHAR2
531     , p0_a90  VARCHAR2
532     , p0_a91  VARCHAR2
533     , p0_a92  VARCHAR2
534     , p0_a93  VARCHAR2
535     , p0_a94  VARCHAR2
536     , p0_a95  VARCHAR2
537     , p0_a96  VARCHAR2
538     , p0_a97  VARCHAR2
539     , p0_a98  VARCHAR2
540     , p0_a99  VARCHAR2
541     , p0_a100  VARCHAR2
542     , p0_a101  VARCHAR2
543     , p0_a102  VARCHAR2
544     , p0_a103  VARCHAR2
545     , p0_a104  VARCHAR2
546     , p0_a105  NUMBER
547     , p0_a106  VARCHAR2
548     , p0_a107  NUMBER
549     , p0_a108  VARCHAR2
550     , p0_a109  VARCHAR2
551     , p0_a110  VARCHAR2
552     , p0_a111  VARCHAR2
553     , p0_a112  NUMBER
554     , p0_a113  VARCHAR2
555     , p0_a114  NUMBER
556     , p0_a115  VARCHAR2
557     , p0_a116  VARCHAR2
558     , p0_a117  VARCHAR2
559     , p0_a118  NUMBER
560     , p0_a119  VARCHAR2
561     , p0_a120  VARCHAR2
562     , p0_a121  VARCHAR2
563     , p0_a122  VARCHAR2
564     , p0_a123  VARCHAR2
565     , p0_a124  VARCHAR2
566     , p0_a125  DATE
567     , p0_a126  DATE
568     , p0_a127  NUMBER
569     , p0_a128  NUMBER
570     , p0_a129  VARCHAR2
571     , p0_a130  VARCHAR2
572     , p0_a131  VARCHAR2
573     , p0_a132  VARCHAR2
574     , p0_a133  VARCHAR2
575     , p0_a134  VARCHAR2
576     , p0_a135  VARCHAR2
577     , p0_a136  NUMBER
578     , p0_a137  VARCHAR2
579     , p_validation_mode  VARCHAR2
580     , x_return_status out nocopy  VARCHAR2
581   );
582   procedure check_evo_record(p0_a0  NUMBER
583     , p0_a1  DATE
584     , p0_a2  NUMBER
585     , p0_a3  DATE
586     , p0_a4  NUMBER
587     , p0_a5  NUMBER
588     , p0_a6  NUMBER
589     , p0_a7  NUMBER
590     , p0_a8  NUMBER
591     , p0_a9  VARCHAR2
592     , p0_a10  VARCHAR2
593     , p0_a11  VARCHAR2
594     , p0_a12  VARCHAR2
595     , p0_a13  NUMBER
596     , p0_a14  DATE
597     , p0_a15  VARCHAR2
598     , p0_a16  VARCHAR2
599     , p0_a17  NUMBER
600     , p0_a18  VARCHAR2
601     , p0_a19  VARCHAR2
602     , p0_a20  VARCHAR2
603     , p0_a21  NUMBER
604     , p0_a22  VARCHAR2
605     , p0_a23  VARCHAR2
606     , p0_a24  VARCHAR2
607     , p0_a25  VARCHAR2
608     , p0_a26  VARCHAR2
609     , p0_a27  VARCHAR2
610     , p0_a28  VARCHAR2
611     , p0_a29  VARCHAR2
612     , p0_a30  VARCHAR2
613     , p0_a31  VARCHAR2
614     , p0_a32  VARCHAR2
615     , p0_a33  VARCHAR2
616     , p0_a34  VARCHAR2
617     , p0_a35  NUMBER
618     , p0_a36  NUMBER
619     , p0_a37  VARCHAR2
620     , p0_a38  DATE
621     , p0_a39  DATE
622     , p0_a40  DATE
623     , p0_a41  DATE
624     , p0_a42  DATE
625     , p0_a43  DATE
626     , p0_a44  DATE
627     , p0_a45  DATE
628     , p0_a46  NUMBER
629     , p0_a47  NUMBER
630     , p0_a48  NUMBER
631     , p0_a49  NUMBER
632     , p0_a50  NUMBER
633     , p0_a51  DATE
634     , p0_a52  NUMBER
635     , p0_a53  VARCHAR2
639     , p0_a57  NUMBER
636     , p0_a54  NUMBER
637     , p0_a55  NUMBER
638     , p0_a56  NUMBER
640     , p0_a58  VARCHAR2
641     , p0_a59  VARCHAR2
642     , p0_a60  NUMBER
643     , p0_a61  VARCHAR2
644     , p0_a62  NUMBER
645     , p0_a63  NUMBER
646     , p0_a64  NUMBER
647     , p0_a65  NUMBER
648     , p0_a66  VARCHAR2
649     , p0_a67  NUMBER
650     , p0_a68  VARCHAR2
651     , p0_a69  NUMBER
652     , p0_a70  NUMBER
653     , p0_a71  VARCHAR2
654     , p0_a72  VARCHAR2
655     , p0_a73  VARCHAR2
656     , p0_a74  VARCHAR2
657     , p0_a75  VARCHAR2
658     , p0_a76  NUMBER
659     , p0_a77  NUMBER
660     , p0_a78  VARCHAR2
661     , p0_a79  VARCHAR2
662     , p0_a80  VARCHAR2
663     , p0_a81  NUMBER
664     , p0_a82  NUMBER
665     , p0_a83  VARCHAR2
666     , p0_a84  NUMBER
667     , p0_a85  VARCHAR2
668     , p0_a86  VARCHAR2
669     , p0_a87  VARCHAR2
670     , p0_a88  VARCHAR2
671     , p0_a89  VARCHAR2
672     , p0_a90  VARCHAR2
673     , p0_a91  VARCHAR2
674     , p0_a92  VARCHAR2
675     , p0_a93  VARCHAR2
676     , p0_a94  VARCHAR2
677     , p0_a95  VARCHAR2
678     , p0_a96  VARCHAR2
679     , p0_a97  VARCHAR2
680     , p0_a98  VARCHAR2
681     , p0_a99  VARCHAR2
682     , p0_a100  VARCHAR2
683     , p0_a101  VARCHAR2
684     , p0_a102  VARCHAR2
685     , p0_a103  VARCHAR2
686     , p0_a104  VARCHAR2
687     , p0_a105  NUMBER
688     , p0_a106  VARCHAR2
689     , p0_a107  NUMBER
690     , p0_a108  VARCHAR2
691     , p0_a109  VARCHAR2
692     , p0_a110  VARCHAR2
693     , p0_a111  VARCHAR2
694     , p0_a112  NUMBER
695     , p0_a113  VARCHAR2
696     , p0_a114  NUMBER
697     , p0_a115  VARCHAR2
698     , p0_a116  VARCHAR2
699     , p0_a117  VARCHAR2
700     , p0_a118  NUMBER
701     , p0_a119  VARCHAR2
702     , p0_a120  VARCHAR2
703     , p0_a121  VARCHAR2
704     , p0_a122  VARCHAR2
705     , p0_a123  VARCHAR2
706     , p0_a124  VARCHAR2
707     , p0_a125  DATE
708     , p0_a126  DATE
709     , p0_a127  NUMBER
710     , p0_a128  NUMBER
711     , p0_a129  VARCHAR2
712     , p0_a130  VARCHAR2
713     , p0_a131  VARCHAR2
714     , p0_a132  VARCHAR2
715     , p0_a133  VARCHAR2
716     , p0_a134  VARCHAR2
717     , p0_a135  VARCHAR2
718     , p0_a136  NUMBER
719     , p0_a137  VARCHAR2
720     , p1_a0  NUMBER
721     , p1_a1  DATE
722     , p1_a2  NUMBER
723     , p1_a3  DATE
724     , p1_a4  NUMBER
725     , p1_a5  NUMBER
726     , p1_a6  NUMBER
727     , p1_a7  NUMBER
728     , p1_a8  NUMBER
729     , p1_a9  VARCHAR2
730     , p1_a10  VARCHAR2
731     , p1_a11  VARCHAR2
732     , p1_a12  VARCHAR2
733     , p1_a13  NUMBER
734     , p1_a14  DATE
735     , p1_a15  VARCHAR2
736     , p1_a16  VARCHAR2
737     , p1_a17  NUMBER
738     , p1_a18  VARCHAR2
739     , p1_a19  VARCHAR2
740     , p1_a20  VARCHAR2
741     , p1_a21  NUMBER
742     , p1_a22  VARCHAR2
743     , p1_a23  VARCHAR2
744     , p1_a24  VARCHAR2
745     , p1_a25  VARCHAR2
746     , p1_a26  VARCHAR2
747     , p1_a27  VARCHAR2
748     , p1_a28  VARCHAR2
749     , p1_a29  VARCHAR2
750     , p1_a30  VARCHAR2
751     , p1_a31  VARCHAR2
752     , p1_a32  VARCHAR2
753     , p1_a33  VARCHAR2
754     , p1_a34  VARCHAR2
755     , p1_a35  NUMBER
756     , p1_a36  NUMBER
757     , p1_a37  VARCHAR2
758     , p1_a38  DATE
759     , p1_a39  DATE
760     , p1_a40  DATE
761     , p1_a41  DATE
762     , p1_a42  DATE
763     , p1_a43  DATE
764     , p1_a44  DATE
765     , p1_a45  DATE
766     , p1_a46  NUMBER
767     , p1_a47  NUMBER
768     , p1_a48  NUMBER
769     , p1_a49  NUMBER
770     , p1_a50  NUMBER
771     , p1_a51  DATE
772     , p1_a52  NUMBER
773     , p1_a53  VARCHAR2
774     , p1_a54  NUMBER
775     , p1_a55  NUMBER
776     , p1_a56  NUMBER
777     , p1_a57  NUMBER
778     , p1_a58  VARCHAR2
779     , p1_a59  VARCHAR2
780     , p1_a60  NUMBER
781     , p1_a61  VARCHAR2
782     , p1_a62  NUMBER
783     , p1_a63  NUMBER
784     , p1_a64  NUMBER
785     , p1_a65  NUMBER
786     , p1_a66  VARCHAR2
787     , p1_a67  NUMBER
788     , p1_a68  VARCHAR2
789     , p1_a69  NUMBER
790     , p1_a70  NUMBER
791     , p1_a71  VARCHAR2
792     , p1_a72  VARCHAR2
793     , p1_a73  VARCHAR2
794     , p1_a74  VARCHAR2
795     , p1_a75  VARCHAR2
796     , p1_a76  NUMBER
797     , p1_a77  NUMBER
798     , p1_a78  VARCHAR2
799     , p1_a79  VARCHAR2
800     , p1_a80  VARCHAR2
801     , p1_a81  NUMBER
802     , p1_a82  NUMBER
803     , p1_a83  VARCHAR2
804     , p1_a84  NUMBER
805     , p1_a85  VARCHAR2
806     , p1_a86  VARCHAR2
807     , p1_a87  VARCHAR2
808     , p1_a88  VARCHAR2
809     , p1_a89  VARCHAR2
810     , p1_a90  VARCHAR2
811     , p1_a91  VARCHAR2
812     , p1_a92  VARCHAR2
813     , p1_a93  VARCHAR2
814     , p1_a94  VARCHAR2
815     , p1_a95  VARCHAR2
816     , p1_a96  VARCHAR2
817     , p1_a97  VARCHAR2
818     , p1_a98  VARCHAR2
819     , p1_a99  VARCHAR2
820     , p1_a100  VARCHAR2
821     , p1_a101  VARCHAR2
822     , p1_a102  VARCHAR2
823     , p1_a103  VARCHAR2
824     , p1_a104  VARCHAR2
825     , p1_a105  NUMBER
826     , p1_a106  VARCHAR2
827     , p1_a107  NUMBER
828     , p1_a108  VARCHAR2
829     , p1_a109  VARCHAR2
830     , p1_a110  VARCHAR2
831     , p1_a111  VARCHAR2
832     , p1_a112  NUMBER
833     , p1_a113  VARCHAR2
834     , p1_a114  NUMBER
835     , p1_a115  VARCHAR2
836     , p1_a116  VARCHAR2
837     , p1_a117  VARCHAR2
838     , p1_a118  NUMBER
839     , p1_a119  VARCHAR2
840     , p1_a120  VARCHAR2
841     , p1_a121  VARCHAR2
842     , p1_a122  VARCHAR2
843     , p1_a123  VARCHAR2
844     , p1_a124  VARCHAR2
845     , p1_a125  DATE
846     , p1_a126  DATE
847     , p1_a127  NUMBER
848     , p1_a128  NUMBER
849     , p1_a129  VARCHAR2
850     , p1_a130  VARCHAR2
851     , p1_a131  VARCHAR2
852     , p1_a132  VARCHAR2
853     , p1_a133  VARCHAR2
854     , p1_a134  VARCHAR2
855     , p1_a135  VARCHAR2
856     , p1_a136  NUMBER
857     , p1_a137  VARCHAR2
858     , x_return_status out nocopy  VARCHAR2
859   );
860   procedure init_evo_rec(p0_a0 out nocopy  NUMBER
861     , p0_a1 out nocopy  DATE
862     , p0_a2 out nocopy  NUMBER
863     , p0_a3 out nocopy  DATE
864     , p0_a4 out nocopy  NUMBER
865     , p0_a5 out nocopy  NUMBER
866     , p0_a6 out nocopy  NUMBER
867     , p0_a7 out nocopy  NUMBER
868     , p0_a8 out nocopy  NUMBER
869     , p0_a9 out nocopy  VARCHAR2
870     , p0_a10 out nocopy  VARCHAR2
871     , p0_a11 out nocopy  VARCHAR2
872     , p0_a12 out nocopy  VARCHAR2
873     , p0_a13 out nocopy  NUMBER
874     , p0_a14 out nocopy  DATE
875     , p0_a15 out nocopy  VARCHAR2
876     , p0_a16 out nocopy  VARCHAR2
877     , p0_a17 out nocopy  NUMBER
878     , p0_a18 out nocopy  VARCHAR2
879     , p0_a19 out nocopy  VARCHAR2
880     , p0_a20 out nocopy  VARCHAR2
881     , p0_a21 out nocopy  NUMBER
882     , p0_a22 out nocopy  VARCHAR2
883     , p0_a23 out nocopy  VARCHAR2
884     , p0_a24 out nocopy  VARCHAR2
885     , p0_a25 out nocopy  VARCHAR2
886     , p0_a26 out nocopy  VARCHAR2
887     , p0_a27 out nocopy  VARCHAR2
888     , p0_a28 out nocopy  VARCHAR2
889     , p0_a29 out nocopy  VARCHAR2
890     , p0_a30 out nocopy  VARCHAR2
891     , p0_a31 out nocopy  VARCHAR2
892     , p0_a32 out nocopy  VARCHAR2
893     , p0_a33 out nocopy  VARCHAR2
894     , p0_a34 out nocopy  VARCHAR2
895     , p0_a35 out nocopy  NUMBER
896     , p0_a36 out nocopy  NUMBER
897     , p0_a37 out nocopy  VARCHAR2
898     , p0_a38 out nocopy  DATE
899     , p0_a39 out nocopy  DATE
900     , p0_a40 out nocopy  DATE
901     , p0_a41 out nocopy  DATE
902     , p0_a42 out nocopy  DATE
903     , p0_a43 out nocopy  DATE
904     , p0_a44 out nocopy  DATE
905     , p0_a45 out nocopy  DATE
906     , p0_a46 out nocopy  NUMBER
907     , p0_a47 out nocopy  NUMBER
908     , p0_a48 out nocopy  NUMBER
909     , p0_a49 out nocopy  NUMBER
910     , p0_a50 out nocopy  NUMBER
911     , p0_a51 out nocopy  DATE
912     , p0_a52 out nocopy  NUMBER
913     , p0_a53 out nocopy  VARCHAR2
914     , p0_a54 out nocopy  NUMBER
915     , p0_a55 out nocopy  NUMBER
916     , p0_a56 out nocopy  NUMBER
917     , p0_a57 out nocopy  NUMBER
918     , p0_a58 out nocopy  VARCHAR2
919     , p0_a59 out nocopy  VARCHAR2
920     , p0_a60 out nocopy  NUMBER
921     , p0_a61 out nocopy  VARCHAR2
922     , p0_a62 out nocopy  NUMBER
923     , p0_a63 out nocopy  NUMBER
924     , p0_a64 out nocopy  NUMBER
925     , p0_a65 out nocopy  NUMBER
926     , p0_a66 out nocopy  VARCHAR2
927     , p0_a67 out nocopy  NUMBER
928     , p0_a68 out nocopy  VARCHAR2
929     , p0_a69 out nocopy  NUMBER
930     , p0_a70 out nocopy  NUMBER
931     , p0_a71 out nocopy  VARCHAR2
932     , p0_a72 out nocopy  VARCHAR2
933     , p0_a73 out nocopy  VARCHAR2
934     , p0_a74 out nocopy  VARCHAR2
935     , p0_a75 out nocopy  VARCHAR2
936     , p0_a76 out nocopy  NUMBER
937     , p0_a77 out nocopy  NUMBER
938     , p0_a78 out nocopy  VARCHAR2
939     , p0_a79 out nocopy  VARCHAR2
940     , p0_a80 out nocopy  VARCHAR2
941     , p0_a81 out nocopy  NUMBER
942     , p0_a82 out nocopy  NUMBER
943     , p0_a83 out nocopy  VARCHAR2
944     , p0_a84 out nocopy  NUMBER
945     , p0_a85 out nocopy  VARCHAR2
946     , p0_a86 out nocopy  VARCHAR2
947     , p0_a87 out nocopy  VARCHAR2
948     , p0_a88 out nocopy  VARCHAR2
949     , p0_a89 out nocopy  VARCHAR2
950     , p0_a90 out nocopy  VARCHAR2
951     , p0_a91 out nocopy  VARCHAR2
952     , p0_a92 out nocopy  VARCHAR2
953     , p0_a93 out nocopy  VARCHAR2
954     , p0_a94 out nocopy  VARCHAR2
955     , p0_a95 out nocopy  VARCHAR2
956     , p0_a96 out nocopy  VARCHAR2
957     , p0_a97 out nocopy  VARCHAR2
958     , p0_a98 out nocopy  VARCHAR2
962     , p0_a102 out nocopy  VARCHAR2
959     , p0_a99 out nocopy  VARCHAR2
960     , p0_a100 out nocopy  VARCHAR2
961     , p0_a101 out nocopy  VARCHAR2
963     , p0_a103 out nocopy  VARCHAR2
964     , p0_a104 out nocopy  VARCHAR2
965     , p0_a105 out nocopy  NUMBER
966     , p0_a106 out nocopy  VARCHAR2
967     , p0_a107 out nocopy  NUMBER
968     , p0_a108 out nocopy  VARCHAR2
969     , p0_a109 out nocopy  VARCHAR2
970     , p0_a110 out nocopy  VARCHAR2
971     , p0_a111 out nocopy  VARCHAR2
972     , p0_a112 out nocopy  NUMBER
973     , p0_a113 out nocopy  VARCHAR2
974     , p0_a114 out nocopy  NUMBER
975     , p0_a115 out nocopy  VARCHAR2
976     , p0_a116 out nocopy  VARCHAR2
977     , p0_a117 out nocopy  VARCHAR2
978     , p0_a118 out nocopy  NUMBER
979     , p0_a119 out nocopy  VARCHAR2
980     , p0_a120 out nocopy  VARCHAR2
981     , p0_a121 out nocopy  VARCHAR2
982     , p0_a122 out nocopy  VARCHAR2
983     , p0_a123 out nocopy  VARCHAR2
984     , p0_a124 out nocopy  VARCHAR2
985     , p0_a125 out nocopy  DATE
986     , p0_a126 out nocopy  DATE
987     , p0_a127 out nocopy  NUMBER
988     , p0_a128 out nocopy  NUMBER
989     , p0_a129 out nocopy  VARCHAR2
990     , p0_a130 out nocopy  VARCHAR2
991     , p0_a131 out nocopy  VARCHAR2
992     , p0_a132 out nocopy  VARCHAR2
993     , p0_a133 out nocopy  VARCHAR2
994     , p0_a134 out nocopy  VARCHAR2
995     , p0_a135 out nocopy  VARCHAR2
996     , p0_a136 out nocopy  NUMBER
997     , p0_a137 out nocopy  VARCHAR2
998   );
999   procedure complete_evo_rec(p0_a0  NUMBER
1000     , p0_a1  DATE
1001     , p0_a2  NUMBER
1002     , p0_a3  DATE
1003     , p0_a4  NUMBER
1004     , p0_a5  NUMBER
1005     , p0_a6  NUMBER
1006     , p0_a7  NUMBER
1007     , p0_a8  NUMBER
1008     , p0_a9  VARCHAR2
1009     , p0_a10  VARCHAR2
1010     , p0_a11  VARCHAR2
1011     , p0_a12  VARCHAR2
1012     , p0_a13  NUMBER
1013     , p0_a14  DATE
1014     , p0_a15  VARCHAR2
1015     , p0_a16  VARCHAR2
1016     , p0_a17  NUMBER
1017     , p0_a18  VARCHAR2
1018     , p0_a19  VARCHAR2
1019     , p0_a20  VARCHAR2
1020     , p0_a21  NUMBER
1021     , p0_a22  VARCHAR2
1022     , p0_a23  VARCHAR2
1023     , p0_a24  VARCHAR2
1024     , p0_a25  VARCHAR2
1025     , p0_a26  VARCHAR2
1026     , p0_a27  VARCHAR2
1027     , p0_a28  VARCHAR2
1028     , p0_a29  VARCHAR2
1029     , p0_a30  VARCHAR2
1030     , p0_a31  VARCHAR2
1031     , p0_a32  VARCHAR2
1032     , p0_a33  VARCHAR2
1033     , p0_a34  VARCHAR2
1034     , p0_a35  NUMBER
1035     , p0_a36  NUMBER
1036     , p0_a37  VARCHAR2
1037     , p0_a38  DATE
1038     , p0_a39  DATE
1039     , p0_a40  DATE
1040     , p0_a41  DATE
1041     , p0_a42  DATE
1042     , p0_a43  DATE
1043     , p0_a44  DATE
1044     , p0_a45  DATE
1045     , p0_a46  NUMBER
1046     , p0_a47  NUMBER
1047     , p0_a48  NUMBER
1048     , p0_a49  NUMBER
1049     , p0_a50  NUMBER
1050     , p0_a51  DATE
1051     , p0_a52  NUMBER
1052     , p0_a53  VARCHAR2
1053     , p0_a54  NUMBER
1054     , p0_a55  NUMBER
1055     , p0_a56  NUMBER
1056     , p0_a57  NUMBER
1057     , p0_a58  VARCHAR2
1058     , p0_a59  VARCHAR2
1059     , p0_a60  NUMBER
1060     , p0_a61  VARCHAR2
1061     , p0_a62  NUMBER
1062     , p0_a63  NUMBER
1063     , p0_a64  NUMBER
1064     , p0_a65  NUMBER
1065     , p0_a66  VARCHAR2
1066     , p0_a67  NUMBER
1067     , p0_a68  VARCHAR2
1068     , p0_a69  NUMBER
1069     , p0_a70  NUMBER
1070     , p0_a71  VARCHAR2
1071     , p0_a72  VARCHAR2
1072     , p0_a73  VARCHAR2
1073     , p0_a74  VARCHAR2
1074     , p0_a75  VARCHAR2
1075     , p0_a76  NUMBER
1076     , p0_a77  NUMBER
1077     , p0_a78  VARCHAR2
1078     , p0_a79  VARCHAR2
1079     , p0_a80  VARCHAR2
1080     , p0_a81  NUMBER
1081     , p0_a82  NUMBER
1082     , p0_a83  VARCHAR2
1083     , p0_a84  NUMBER
1084     , p0_a85  VARCHAR2
1085     , p0_a86  VARCHAR2
1086     , p0_a87  VARCHAR2
1087     , p0_a88  VARCHAR2
1088     , p0_a89  VARCHAR2
1089     , p0_a90  VARCHAR2
1090     , p0_a91  VARCHAR2
1091     , p0_a92  VARCHAR2
1092     , p0_a93  VARCHAR2
1093     , p0_a94  VARCHAR2
1094     , p0_a95  VARCHAR2
1095     , p0_a96  VARCHAR2
1096     , p0_a97  VARCHAR2
1097     , p0_a98  VARCHAR2
1098     , p0_a99  VARCHAR2
1099     , p0_a100  VARCHAR2
1100     , p0_a101  VARCHAR2
1101     , p0_a102  VARCHAR2
1102     , p0_a103  VARCHAR2
1103     , p0_a104  VARCHAR2
1104     , p0_a105  NUMBER
1105     , p0_a106  VARCHAR2
1106     , p0_a107  NUMBER
1107     , p0_a108  VARCHAR2
1108     , p0_a109  VARCHAR2
1109     , p0_a110  VARCHAR2
1110     , p0_a111  VARCHAR2
1111     , p0_a112  NUMBER
1112     , p0_a113  VARCHAR2
1113     , p0_a114  NUMBER
1114     , p0_a115  VARCHAR2
1115     , p0_a116  VARCHAR2
1116     , p0_a117  VARCHAR2
1117     , p0_a118  NUMBER
1118     , p0_a119  VARCHAR2
1119     , p0_a120  VARCHAR2
1120     , p0_a121  VARCHAR2
1121     , p0_a122  VARCHAR2
1122     , p0_a123  VARCHAR2
1123     , p0_a124  VARCHAR2
1124     , p0_a125  DATE
1125     , p0_a126  DATE
1126     , p0_a127  NUMBER
1127     , p0_a128  NUMBER
1128     , p0_a129  VARCHAR2
1129     , p0_a130  VARCHAR2
1130     , p0_a131  VARCHAR2
1131     , p0_a132  VARCHAR2
1132     , p0_a133  VARCHAR2
1133     , p0_a134  VARCHAR2
1134     , p0_a135  VARCHAR2
1135     , p0_a136  NUMBER
1136     , p0_a137  VARCHAR2
1137     , p1_a0 out nocopy  NUMBER
1141     , p1_a4 out nocopy  NUMBER
1138     , p1_a1 out nocopy  DATE
1139     , p1_a2 out nocopy  NUMBER
1140     , p1_a3 out nocopy  DATE
1142     , p1_a5 out nocopy  NUMBER
1143     , p1_a6 out nocopy  NUMBER
1144     , p1_a7 out nocopy  NUMBER
1145     , p1_a8 out nocopy  NUMBER
1146     , p1_a9 out nocopy  VARCHAR2
1147     , p1_a10 out nocopy  VARCHAR2
1148     , p1_a11 out nocopy  VARCHAR2
1149     , p1_a12 out nocopy  VARCHAR2
1150     , p1_a13 out nocopy  NUMBER
1151     , p1_a14 out nocopy  DATE
1152     , p1_a15 out nocopy  VARCHAR2
1153     , p1_a16 out nocopy  VARCHAR2
1154     , p1_a17 out nocopy  NUMBER
1155     , p1_a18 out nocopy  VARCHAR2
1156     , p1_a19 out nocopy  VARCHAR2
1157     , p1_a20 out nocopy  VARCHAR2
1158     , p1_a21 out nocopy  NUMBER
1159     , p1_a22 out nocopy  VARCHAR2
1160     , p1_a23 out nocopy  VARCHAR2
1161     , p1_a24 out nocopy  VARCHAR2
1162     , p1_a25 out nocopy  VARCHAR2
1163     , p1_a26 out nocopy  VARCHAR2
1164     , p1_a27 out nocopy  VARCHAR2
1165     , p1_a28 out nocopy  VARCHAR2
1166     , p1_a29 out nocopy  VARCHAR2
1167     , p1_a30 out nocopy  VARCHAR2
1168     , p1_a31 out nocopy  VARCHAR2
1169     , p1_a32 out nocopy  VARCHAR2
1170     , p1_a33 out nocopy  VARCHAR2
1171     , p1_a34 out nocopy  VARCHAR2
1172     , p1_a35 out nocopy  NUMBER
1173     , p1_a36 out nocopy  NUMBER
1174     , p1_a37 out nocopy  VARCHAR2
1175     , p1_a38 out nocopy  DATE
1176     , p1_a39 out nocopy  DATE
1177     , p1_a40 out nocopy  DATE
1178     , p1_a41 out nocopy  DATE
1179     , p1_a42 out nocopy  DATE
1180     , p1_a43 out nocopy  DATE
1181     , p1_a44 out nocopy  DATE
1182     , p1_a45 out nocopy  DATE
1183     , p1_a46 out nocopy  NUMBER
1184     , p1_a47 out nocopy  NUMBER
1185     , p1_a48 out nocopy  NUMBER
1186     , p1_a49 out nocopy  NUMBER
1187     , p1_a50 out nocopy  NUMBER
1188     , p1_a51 out nocopy  DATE
1189     , p1_a52 out nocopy  NUMBER
1190     , p1_a53 out nocopy  VARCHAR2
1191     , p1_a54 out nocopy  NUMBER
1192     , p1_a55 out nocopy  NUMBER
1193     , p1_a56 out nocopy  NUMBER
1194     , p1_a57 out nocopy  NUMBER
1195     , p1_a58 out nocopy  VARCHAR2
1196     , p1_a59 out nocopy  VARCHAR2
1197     , p1_a60 out nocopy  NUMBER
1198     , p1_a61 out nocopy  VARCHAR2
1199     , p1_a62 out nocopy  NUMBER
1200     , p1_a63 out nocopy  NUMBER
1201     , p1_a64 out nocopy  NUMBER
1202     , p1_a65 out nocopy  NUMBER
1203     , p1_a66 out nocopy  VARCHAR2
1204     , p1_a67 out nocopy  NUMBER
1205     , p1_a68 out nocopy  VARCHAR2
1206     , p1_a69 out nocopy  NUMBER
1207     , p1_a70 out nocopy  NUMBER
1208     , p1_a71 out nocopy  VARCHAR2
1209     , p1_a72 out nocopy  VARCHAR2
1210     , p1_a73 out nocopy  VARCHAR2
1211     , p1_a74 out nocopy  VARCHAR2
1212     , p1_a75 out nocopy  VARCHAR2
1213     , p1_a76 out nocopy  NUMBER
1214     , p1_a77 out nocopy  NUMBER
1215     , p1_a78 out nocopy  VARCHAR2
1216     , p1_a79 out nocopy  VARCHAR2
1217     , p1_a80 out nocopy  VARCHAR2
1218     , p1_a81 out nocopy  NUMBER
1219     , p1_a82 out nocopy  NUMBER
1220     , p1_a83 out nocopy  VARCHAR2
1221     , p1_a84 out nocopy  NUMBER
1222     , p1_a85 out nocopy  VARCHAR2
1223     , p1_a86 out nocopy  VARCHAR2
1224     , p1_a87 out nocopy  VARCHAR2
1225     , p1_a88 out nocopy  VARCHAR2
1226     , p1_a89 out nocopy  VARCHAR2
1227     , p1_a90 out nocopy  VARCHAR2
1228     , p1_a91 out nocopy  VARCHAR2
1229     , p1_a92 out nocopy  VARCHAR2
1230     , p1_a93 out nocopy  VARCHAR2
1231     , p1_a94 out nocopy  VARCHAR2
1232     , p1_a95 out nocopy  VARCHAR2
1233     , p1_a96 out nocopy  VARCHAR2
1234     , p1_a97 out nocopy  VARCHAR2
1235     , p1_a98 out nocopy  VARCHAR2
1236     , p1_a99 out nocopy  VARCHAR2
1237     , p1_a100 out nocopy  VARCHAR2
1238     , p1_a101 out nocopy  VARCHAR2
1239     , p1_a102 out nocopy  VARCHAR2
1240     , p1_a103 out nocopy  VARCHAR2
1241     , p1_a104 out nocopy  VARCHAR2
1242     , p1_a105 out nocopy  NUMBER
1243     , p1_a106 out nocopy  VARCHAR2
1244     , p1_a107 out nocopy  NUMBER
1245     , p1_a108 out nocopy  VARCHAR2
1246     , p1_a109 out nocopy  VARCHAR2
1247     , p1_a110 out nocopy  VARCHAR2
1248     , p1_a111 out nocopy  VARCHAR2
1249     , p1_a112 out nocopy  NUMBER
1250     , p1_a113 out nocopy  VARCHAR2
1251     , p1_a114 out nocopy  NUMBER
1252     , p1_a115 out nocopy  VARCHAR2
1253     , p1_a116 out nocopy  VARCHAR2
1254     , p1_a117 out nocopy  VARCHAR2
1255     , p1_a118 out nocopy  NUMBER
1256     , p1_a119 out nocopy  VARCHAR2
1257     , p1_a120 out nocopy  VARCHAR2
1258     , p1_a121 out nocopy  VARCHAR2
1259     , p1_a122 out nocopy  VARCHAR2
1260     , p1_a123 out nocopy  VARCHAR2
1261     , p1_a124 out nocopy  VARCHAR2
1262     , p1_a125 out nocopy  DATE
1263     , p1_a126 out nocopy  DATE
1264     , p1_a127 out nocopy  NUMBER
1265     , p1_a128 out nocopy  NUMBER
1266     , p1_a129 out nocopy  VARCHAR2
1267     , p1_a130 out nocopy  VARCHAR2
1268     , p1_a131 out nocopy  VARCHAR2
1269     , p1_a132 out nocopy  VARCHAR2
1270     , p1_a133 out nocopy  VARCHAR2
1271     , p1_a134 out nocopy  VARCHAR2
1272     , p1_a135 out nocopy  VARCHAR2
1273     , p1_a136 out nocopy  NUMBER
1274     , p1_a137 out nocopy  VARCHAR2
1275   );
1276 end ams_eventoffer_pvt_w_new;