DBA Data[Home] [Help]

PACKAGE: APPS.OKL_ASS_PVT_W

Source


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