DBA Data[Home] [Help]

PACKAGE: APPS.OKL_ECV_PVT_W

Source


1 package okl_ecv_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLIECVS.pls 120.1 2005/10/30 04:58:46 appldev noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy okl_ecv_pvt.okl_ecv_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_VARCHAR2_TABLE_300
11     , a8 JTF_VARCHAR2_TABLE_300
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_DATE_TABLE
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_DATE_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_DATE_TABLE
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_VARCHAR2_TABLE_500
25     , a22 JTF_VARCHAR2_TABLE_500
26     , a23 JTF_VARCHAR2_TABLE_500
27     , a24 JTF_VARCHAR2_TABLE_500
28     , a25 JTF_VARCHAR2_TABLE_500
29     , a26 JTF_VARCHAR2_TABLE_500
30     , a27 JTF_VARCHAR2_TABLE_500
31     , a28 JTF_VARCHAR2_TABLE_500
32     , a29 JTF_VARCHAR2_TABLE_500
33     , a30 JTF_VARCHAR2_TABLE_500
34     , a31 JTF_VARCHAR2_TABLE_500
35     , a32 JTF_VARCHAR2_TABLE_500
36     , a33 JTF_VARCHAR2_TABLE_500
37     , a34 JTF_VARCHAR2_TABLE_500
38     , a35 JTF_VARCHAR2_TABLE_500
39     );
40   procedure rosetta_table_copy_out_p1(t okl_ecv_pvt.okl_ecv_tbl, a0 out nocopy JTF_NUMBER_TABLE
41     , a1 out nocopy JTF_NUMBER_TABLE
42     , a2 out nocopy JTF_NUMBER_TABLE
43     , a3 out nocopy JTF_VARCHAR2_TABLE_100
44     , a4 out nocopy JTF_VARCHAR2_TABLE_100
45     , a5 out nocopy JTF_VARCHAR2_TABLE_100
46     , a6 out nocopy JTF_VARCHAR2_TABLE_100
47     , a7 out nocopy JTF_VARCHAR2_TABLE_300
48     , a8 out nocopy JTF_VARCHAR2_TABLE_300
49     , a9 out nocopy JTF_NUMBER_TABLE
50     , a10 out nocopy JTF_NUMBER_TABLE
51     , a11 out nocopy JTF_DATE_TABLE
52     , a12 out nocopy JTF_DATE_TABLE
53     , a13 out nocopy JTF_VARCHAR2_TABLE_100
54     , a14 out nocopy JTF_NUMBER_TABLE
55     , a15 out nocopy JTF_NUMBER_TABLE
56     , a16 out nocopy JTF_DATE_TABLE
57     , a17 out nocopy JTF_NUMBER_TABLE
58     , a18 out nocopy JTF_DATE_TABLE
59     , a19 out nocopy JTF_NUMBER_TABLE
60     , a20 out nocopy JTF_VARCHAR2_TABLE_100
61     , a21 out nocopy JTF_VARCHAR2_TABLE_500
62     , a22 out nocopy JTF_VARCHAR2_TABLE_500
63     , a23 out nocopy JTF_VARCHAR2_TABLE_500
64     , a24 out nocopy JTF_VARCHAR2_TABLE_500
65     , a25 out nocopy JTF_VARCHAR2_TABLE_500
66     , a26 out nocopy JTF_VARCHAR2_TABLE_500
67     , a27 out nocopy JTF_VARCHAR2_TABLE_500
68     , a28 out nocopy JTF_VARCHAR2_TABLE_500
69     , a29 out nocopy JTF_VARCHAR2_TABLE_500
70     , a30 out nocopy JTF_VARCHAR2_TABLE_500
71     , a31 out nocopy JTF_VARCHAR2_TABLE_500
72     , a32 out nocopy JTF_VARCHAR2_TABLE_500
73     , a33 out nocopy JTF_VARCHAR2_TABLE_500
74     , a34 out nocopy JTF_VARCHAR2_TABLE_500
75     , a35 out nocopy JTF_VARCHAR2_TABLE_500
76     );
77 
78   procedure insert_row(p_api_version  NUMBER
79     , p_init_msg_list  VARCHAR2
80     , x_return_status out nocopy  VARCHAR2
81     , x_msg_count out nocopy  NUMBER
82     , x_msg_data out nocopy  VARCHAR2
83     , p5_a0  NUMBER
84     , p5_a1  NUMBER
85     , p5_a2  NUMBER
86     , p5_a3  VARCHAR2
87     , p5_a4  VARCHAR2
88     , p5_a5  VARCHAR2
89     , p5_a6  VARCHAR2
90     , p5_a7  VARCHAR2
91     , p5_a8  VARCHAR2
92     , p5_a9  NUMBER
93     , p5_a10  NUMBER
94     , p5_a11  DATE
95     , p5_a12  DATE
96     , p5_a13  VARCHAR2
97     , p5_a14  NUMBER
98     , p5_a15  NUMBER
99     , p5_a16  DATE
100     , p5_a17  NUMBER
101     , p5_a18  DATE
102     , p5_a19  NUMBER
103     , p5_a20  VARCHAR2
104     , p5_a21  VARCHAR2
105     , p5_a22  VARCHAR2
106     , p5_a23  VARCHAR2
107     , p5_a24  VARCHAR2
108     , p5_a25  VARCHAR2
109     , p5_a26  VARCHAR2
110     , p5_a27  VARCHAR2
111     , p5_a28  VARCHAR2
112     , p5_a29  VARCHAR2
113     , p5_a30  VARCHAR2
114     , p5_a31  VARCHAR2
115     , p5_a32  VARCHAR2
116     , p5_a33  VARCHAR2
117     , p5_a34  VARCHAR2
118     , p5_a35  VARCHAR2
119     , p6_a0 out nocopy  NUMBER
120     , p6_a1 out nocopy  NUMBER
121     , p6_a2 out nocopy  NUMBER
122     , p6_a3 out nocopy  VARCHAR2
123     , p6_a4 out nocopy  VARCHAR2
124     , p6_a5 out nocopy  VARCHAR2
125     , p6_a6 out nocopy  VARCHAR2
126     , p6_a7 out nocopy  VARCHAR2
127     , p6_a8 out nocopy  VARCHAR2
128     , p6_a9 out nocopy  NUMBER
129     , p6_a10 out nocopy  NUMBER
130     , p6_a11 out nocopy  DATE
131     , p6_a12 out nocopy  DATE
132     , p6_a13 out nocopy  VARCHAR2
133     , p6_a14 out nocopy  NUMBER
134     , p6_a15 out nocopy  NUMBER
135     , p6_a16 out nocopy  DATE
136     , p6_a17 out nocopy  NUMBER
137     , p6_a18 out nocopy  DATE
138     , p6_a19 out nocopy  NUMBER
139     , p6_a20 out nocopy  VARCHAR2
140     , p6_a21 out nocopy  VARCHAR2
141     , p6_a22 out nocopy  VARCHAR2
142     , p6_a23 out nocopy  VARCHAR2
143     , p6_a24 out nocopy  VARCHAR2
144     , p6_a25 out nocopy  VARCHAR2
145     , p6_a26 out nocopy  VARCHAR2
146     , p6_a27 out nocopy  VARCHAR2
147     , p6_a28 out nocopy  VARCHAR2
148     , p6_a29 out nocopy  VARCHAR2
149     , p6_a30 out nocopy  VARCHAR2
150     , p6_a31 out nocopy  VARCHAR2
151     , p6_a32 out nocopy  VARCHAR2
152     , p6_a33 out nocopy  VARCHAR2
153     , p6_a34 out nocopy  VARCHAR2
154     , p6_a35 out nocopy  VARCHAR2
155   );
156   procedure insert_row(p_api_version  NUMBER
157     , p_init_msg_list  VARCHAR2
158     , x_return_status out nocopy  VARCHAR2
159     , x_msg_count out nocopy  NUMBER
160     , x_msg_data out nocopy  VARCHAR2
161     , p5_a0 JTF_NUMBER_TABLE
162     , p5_a1 JTF_NUMBER_TABLE
163     , p5_a2 JTF_NUMBER_TABLE
164     , p5_a3 JTF_VARCHAR2_TABLE_100
165     , p5_a4 JTF_VARCHAR2_TABLE_100
166     , p5_a5 JTF_VARCHAR2_TABLE_100
167     , p5_a6 JTF_VARCHAR2_TABLE_100
168     , p5_a7 JTF_VARCHAR2_TABLE_300
169     , p5_a8 JTF_VARCHAR2_TABLE_300
170     , p5_a9 JTF_NUMBER_TABLE
171     , p5_a10 JTF_NUMBER_TABLE
172     , p5_a11 JTF_DATE_TABLE
173     , p5_a12 JTF_DATE_TABLE
174     , p5_a13 JTF_VARCHAR2_TABLE_100
175     , p5_a14 JTF_NUMBER_TABLE
176     , p5_a15 JTF_NUMBER_TABLE
177     , p5_a16 JTF_DATE_TABLE
178     , p5_a17 JTF_NUMBER_TABLE
179     , p5_a18 JTF_DATE_TABLE
180     , p5_a19 JTF_NUMBER_TABLE
181     , p5_a20 JTF_VARCHAR2_TABLE_100
182     , p5_a21 JTF_VARCHAR2_TABLE_500
183     , p5_a22 JTF_VARCHAR2_TABLE_500
184     , p5_a23 JTF_VARCHAR2_TABLE_500
185     , p5_a24 JTF_VARCHAR2_TABLE_500
186     , p5_a25 JTF_VARCHAR2_TABLE_500
187     , p5_a26 JTF_VARCHAR2_TABLE_500
188     , p5_a27 JTF_VARCHAR2_TABLE_500
189     , p5_a28 JTF_VARCHAR2_TABLE_500
190     , p5_a29 JTF_VARCHAR2_TABLE_500
191     , p5_a30 JTF_VARCHAR2_TABLE_500
192     , p5_a31 JTF_VARCHAR2_TABLE_500
193     , p5_a32 JTF_VARCHAR2_TABLE_500
194     , p5_a33 JTF_VARCHAR2_TABLE_500
195     , p5_a34 JTF_VARCHAR2_TABLE_500
196     , p5_a35 JTF_VARCHAR2_TABLE_500
197     , p6_a0 out nocopy JTF_NUMBER_TABLE
198     , p6_a1 out nocopy JTF_NUMBER_TABLE
199     , p6_a2 out nocopy JTF_NUMBER_TABLE
200     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
201     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
202     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
203     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
204     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
205     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
206     , p6_a9 out nocopy JTF_NUMBER_TABLE
207     , p6_a10 out nocopy JTF_NUMBER_TABLE
208     , p6_a11 out nocopy JTF_DATE_TABLE
209     , p6_a12 out nocopy JTF_DATE_TABLE
210     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
211     , p6_a14 out nocopy JTF_NUMBER_TABLE
212     , p6_a15 out nocopy JTF_NUMBER_TABLE
213     , p6_a16 out nocopy JTF_DATE_TABLE
214     , p6_a17 out nocopy JTF_NUMBER_TABLE
215     , p6_a18 out nocopy JTF_DATE_TABLE
216     , p6_a19 out nocopy JTF_NUMBER_TABLE
217     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
218     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
219     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
220     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
221     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
222     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
223     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
224     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
225     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
226     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
227     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
228     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
229     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
230     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
231     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
232     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
233   );
234   procedure update_row(p_api_version  NUMBER
235     , p_init_msg_list  VARCHAR2
236     , x_return_status out nocopy  VARCHAR2
237     , x_msg_count out nocopy  NUMBER
238     , x_msg_data out nocopy  VARCHAR2
239     , p5_a0  NUMBER
240     , p5_a1  NUMBER
241     , p5_a2  NUMBER
242     , p5_a3  VARCHAR2
243     , p5_a4  VARCHAR2
244     , p5_a5  VARCHAR2
245     , p5_a6  VARCHAR2
246     , p5_a7  VARCHAR2
247     , p5_a8  VARCHAR2
248     , p5_a9  NUMBER
249     , p5_a10  NUMBER
250     , p5_a11  DATE
251     , p5_a12  DATE
252     , p5_a13  VARCHAR2
253     , p5_a14  NUMBER
254     , p5_a15  NUMBER
255     , p5_a16  DATE
256     , p5_a17  NUMBER
257     , p5_a18  DATE
258     , p5_a19  NUMBER
259     , p5_a20  VARCHAR2
260     , p5_a21  VARCHAR2
261     , p5_a22  VARCHAR2
262     , p5_a23  VARCHAR2
263     , p5_a24  VARCHAR2
264     , p5_a25  VARCHAR2
265     , p5_a26  VARCHAR2
266     , p5_a27  VARCHAR2
267     , p5_a28  VARCHAR2
268     , p5_a29  VARCHAR2
269     , p5_a30  VARCHAR2
270     , p5_a31  VARCHAR2
271     , p5_a32  VARCHAR2
272     , p5_a33  VARCHAR2
273     , p5_a34  VARCHAR2
274     , p5_a35  VARCHAR2
275     , p6_a0 out nocopy  NUMBER
276     , p6_a1 out nocopy  NUMBER
277     , p6_a2 out nocopy  NUMBER
278     , p6_a3 out nocopy  VARCHAR2
279     , p6_a4 out nocopy  VARCHAR2
280     , p6_a5 out nocopy  VARCHAR2
281     , p6_a6 out nocopy  VARCHAR2
282     , p6_a7 out nocopy  VARCHAR2
283     , p6_a8 out nocopy  VARCHAR2
284     , p6_a9 out nocopy  NUMBER
285     , p6_a10 out nocopy  NUMBER
286     , p6_a11 out nocopy  DATE
287     , p6_a12 out nocopy  DATE
288     , p6_a13 out nocopy  VARCHAR2
289     , p6_a14 out nocopy  NUMBER
290     , p6_a15 out nocopy  NUMBER
291     , p6_a16 out nocopy  DATE
292     , p6_a17 out nocopy  NUMBER
293     , p6_a18 out nocopy  DATE
294     , p6_a19 out nocopy  NUMBER
295     , p6_a20 out nocopy  VARCHAR2
296     , p6_a21 out nocopy  VARCHAR2
297     , p6_a22 out nocopy  VARCHAR2
298     , p6_a23 out nocopy  VARCHAR2
299     , p6_a24 out nocopy  VARCHAR2
300     , p6_a25 out nocopy  VARCHAR2
301     , p6_a26 out nocopy  VARCHAR2
302     , p6_a27 out nocopy  VARCHAR2
303     , p6_a28 out nocopy  VARCHAR2
304     , p6_a29 out nocopy  VARCHAR2
305     , p6_a30 out nocopy  VARCHAR2
306     , p6_a31 out nocopy  VARCHAR2
307     , p6_a32 out nocopy  VARCHAR2
308     , p6_a33 out nocopy  VARCHAR2
309     , p6_a34 out nocopy  VARCHAR2
310     , p6_a35 out nocopy  VARCHAR2
311   );
312   procedure update_row(p_api_version  NUMBER
313     , p_init_msg_list  VARCHAR2
314     , x_return_status out nocopy  VARCHAR2
315     , x_msg_count out nocopy  NUMBER
316     , x_msg_data out nocopy  VARCHAR2
317     , p5_a0 JTF_NUMBER_TABLE
318     , p5_a1 JTF_NUMBER_TABLE
319     , p5_a2 JTF_NUMBER_TABLE
320     , p5_a3 JTF_VARCHAR2_TABLE_100
321     , p5_a4 JTF_VARCHAR2_TABLE_100
322     , p5_a5 JTF_VARCHAR2_TABLE_100
323     , p5_a6 JTF_VARCHAR2_TABLE_100
324     , p5_a7 JTF_VARCHAR2_TABLE_300
325     , p5_a8 JTF_VARCHAR2_TABLE_300
326     , p5_a9 JTF_NUMBER_TABLE
327     , p5_a10 JTF_NUMBER_TABLE
328     , p5_a11 JTF_DATE_TABLE
329     , p5_a12 JTF_DATE_TABLE
330     , p5_a13 JTF_VARCHAR2_TABLE_100
331     , p5_a14 JTF_NUMBER_TABLE
332     , p5_a15 JTF_NUMBER_TABLE
333     , p5_a16 JTF_DATE_TABLE
334     , p5_a17 JTF_NUMBER_TABLE
335     , p5_a18 JTF_DATE_TABLE
336     , p5_a19 JTF_NUMBER_TABLE
337     , p5_a20 JTF_VARCHAR2_TABLE_100
338     , p5_a21 JTF_VARCHAR2_TABLE_500
339     , p5_a22 JTF_VARCHAR2_TABLE_500
340     , p5_a23 JTF_VARCHAR2_TABLE_500
341     , p5_a24 JTF_VARCHAR2_TABLE_500
342     , p5_a25 JTF_VARCHAR2_TABLE_500
343     , p5_a26 JTF_VARCHAR2_TABLE_500
344     , p5_a27 JTF_VARCHAR2_TABLE_500
345     , p5_a28 JTF_VARCHAR2_TABLE_500
346     , p5_a29 JTF_VARCHAR2_TABLE_500
347     , p5_a30 JTF_VARCHAR2_TABLE_500
348     , p5_a31 JTF_VARCHAR2_TABLE_500
349     , p5_a32 JTF_VARCHAR2_TABLE_500
350     , p5_a33 JTF_VARCHAR2_TABLE_500
351     , p5_a34 JTF_VARCHAR2_TABLE_500
352     , p5_a35 JTF_VARCHAR2_TABLE_500
353     , p6_a0 out nocopy JTF_NUMBER_TABLE
354     , p6_a1 out nocopy JTF_NUMBER_TABLE
355     , p6_a2 out nocopy JTF_NUMBER_TABLE
356     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
357     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
358     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
359     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
360     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
361     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
362     , p6_a9 out nocopy JTF_NUMBER_TABLE
363     , p6_a10 out nocopy JTF_NUMBER_TABLE
364     , p6_a11 out nocopy JTF_DATE_TABLE
365     , p6_a12 out nocopy JTF_DATE_TABLE
366     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
367     , p6_a14 out nocopy JTF_NUMBER_TABLE
368     , p6_a15 out nocopy JTF_NUMBER_TABLE
369     , p6_a16 out nocopy JTF_DATE_TABLE
370     , p6_a17 out nocopy JTF_NUMBER_TABLE
371     , p6_a18 out nocopy JTF_DATE_TABLE
372     , p6_a19 out nocopy JTF_NUMBER_TABLE
373     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
374     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
375     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
376     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
380     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
381     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
382     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
383     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
384     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
385     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
386     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
387     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
388     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
389   );
390   procedure delete_row(p_api_version  NUMBER
391     , p_init_msg_list  VARCHAR2
392     , x_return_status out nocopy  VARCHAR2
393     , x_msg_count out nocopy  NUMBER
394     , x_msg_data out nocopy  VARCHAR2
395     , p5_a0  NUMBER
396     , p5_a1  NUMBER
397     , p5_a2  NUMBER
398     , p5_a3  VARCHAR2
399     , p5_a4  VARCHAR2
400     , p5_a5  VARCHAR2
401     , p5_a6  VARCHAR2
402     , p5_a7  VARCHAR2
403     , p5_a8  VARCHAR2
404     , p5_a9  NUMBER
405     , p5_a10  NUMBER
406     , p5_a11  DATE
407     , p5_a12  DATE
408     , p5_a13  VARCHAR2
409     , p5_a14  NUMBER
410     , p5_a15  NUMBER
411     , p5_a16  DATE
412     , p5_a17  NUMBER
413     , p5_a18  DATE
414     , p5_a19  NUMBER
415     , p5_a20  VARCHAR2
416     , p5_a21  VARCHAR2
417     , p5_a22  VARCHAR2
418     , p5_a23  VARCHAR2
419     , p5_a24  VARCHAR2
420     , p5_a25  VARCHAR2
421     , p5_a26  VARCHAR2
422     , p5_a27  VARCHAR2
423     , p5_a28  VARCHAR2
424     , p5_a29  VARCHAR2
425     , p5_a30  VARCHAR2
426     , p5_a31  VARCHAR2
427     , p5_a32  VARCHAR2
428     , p5_a33  VARCHAR2
429     , p5_a34  VARCHAR2
430     , p5_a35  VARCHAR2
431   );
432   procedure delete_row(p_api_version  NUMBER
433     , p_init_msg_list  VARCHAR2
434     , x_return_status out nocopy  VARCHAR2
435     , x_msg_count out nocopy  NUMBER
436     , x_msg_data out nocopy  VARCHAR2
437     , p5_a0 JTF_NUMBER_TABLE
438     , p5_a1 JTF_NUMBER_TABLE
439     , p5_a2 JTF_NUMBER_TABLE
440     , p5_a3 JTF_VARCHAR2_TABLE_100
441     , p5_a4 JTF_VARCHAR2_TABLE_100
442     , p5_a5 JTF_VARCHAR2_TABLE_100
443     , p5_a6 JTF_VARCHAR2_TABLE_100
444     , p5_a7 JTF_VARCHAR2_TABLE_300
445     , p5_a8 JTF_VARCHAR2_TABLE_300
446     , p5_a9 JTF_NUMBER_TABLE
447     , p5_a10 JTF_NUMBER_TABLE
448     , p5_a11 JTF_DATE_TABLE
449     , p5_a12 JTF_DATE_TABLE
450     , p5_a13 JTF_VARCHAR2_TABLE_100
451     , p5_a14 JTF_NUMBER_TABLE
452     , p5_a15 JTF_NUMBER_TABLE
453     , p5_a16 JTF_DATE_TABLE
454     , p5_a17 JTF_NUMBER_TABLE
455     , p5_a18 JTF_DATE_TABLE
456     , p5_a19 JTF_NUMBER_TABLE
457     , p5_a20 JTF_VARCHAR2_TABLE_100
458     , p5_a21 JTF_VARCHAR2_TABLE_500
459     , p5_a22 JTF_VARCHAR2_TABLE_500
460     , p5_a23 JTF_VARCHAR2_TABLE_500
461     , p5_a24 JTF_VARCHAR2_TABLE_500
462     , p5_a25 JTF_VARCHAR2_TABLE_500
463     , p5_a26 JTF_VARCHAR2_TABLE_500
464     , p5_a27 JTF_VARCHAR2_TABLE_500
465     , p5_a28 JTF_VARCHAR2_TABLE_500
466     , p5_a29 JTF_VARCHAR2_TABLE_500
467     , p5_a30 JTF_VARCHAR2_TABLE_500
468     , p5_a31 JTF_VARCHAR2_TABLE_500
469     , p5_a32 JTF_VARCHAR2_TABLE_500
470     , p5_a33 JTF_VARCHAR2_TABLE_500
471     , p5_a34 JTF_VARCHAR2_TABLE_500
472     , p5_a35 JTF_VARCHAR2_TABLE_500
473   );
474   function validate_record(p0_a0 in out nocopy  NUMBER
475     , p0_a1 in out nocopy  NUMBER
476     , p0_a2 in out nocopy  NUMBER
477     , p0_a3 in out nocopy  VARCHAR2
478     , p0_a4 in out nocopy  VARCHAR2
479     , p0_a5 in out nocopy  VARCHAR2
480     , p0_a6 in out nocopy  VARCHAR2
481     , p0_a7 in out nocopy  VARCHAR2
482     , p0_a8 in out nocopy  VARCHAR2
483     , p0_a9 in out nocopy  NUMBER
484     , p0_a10 in out nocopy  NUMBER
485     , p0_a11 in out nocopy  DATE
486     , p0_a12 in out nocopy  DATE
487     , p0_a13 in out nocopy  VARCHAR2
488     , p0_a14 in out nocopy  NUMBER
489     , p0_a15 in out nocopy  NUMBER
490     , p0_a16 in out nocopy  DATE
491     , p0_a17 in out nocopy  NUMBER
492     , p0_a18 in out nocopy  DATE
493     , p0_a19 in out nocopy  NUMBER
494     , p0_a20 in out nocopy  VARCHAR2
495     , p0_a21 in out nocopy  VARCHAR2
496     , p0_a22 in out nocopy  VARCHAR2
497     , p0_a23 in out nocopy  VARCHAR2
498     , p0_a24 in out nocopy  VARCHAR2
499     , p0_a25 in out nocopy  VARCHAR2
500     , p0_a26 in out nocopy  VARCHAR2
501     , p0_a27 in out nocopy  VARCHAR2
502     , p0_a28 in out nocopy  VARCHAR2
503     , p0_a29 in out nocopy  VARCHAR2
504     , p0_a30 in out nocopy  VARCHAR2
505     , p0_a31 in out nocopy  VARCHAR2
506     , p0_a32 in out nocopy  VARCHAR2
507     , p0_a33 in out nocopy  VARCHAR2
508     , p0_a34 in out nocopy  VARCHAR2
509     , p0_a35 in out nocopy  VARCHAR2
510   ) return varchar2;
511 end okl_ecv_pvt_w;