DBA Data[Home] [Help]

PACKAGE: APPS.OKL_TAP_PVT_W

Source


1 package okl_tap_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLITAPS.pls 120.2 2007/11/06 07:35:35 veramach ship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy okl_tap_pvt.tap_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_NUMBER_TABLE
22     , a19 JTF_DATE_TABLE
23     , a20 JTF_DATE_TABLE
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_DATE_TABLE
30     , a27 JTF_DATE_TABLE
31     , a28 JTF_VARCHAR2_TABLE_100
32     , a29 JTF_DATE_TABLE
33     , a30 JTF_VARCHAR2_TABLE_100
34     , a31 JTF_VARCHAR2_TABLE_100
35     , a32 JTF_VARCHAR2_TABLE_100
36     , a33 JTF_VARCHAR2_TABLE_100
37     , a34 JTF_VARCHAR2_TABLE_100
38     , a35 JTF_NUMBER_TABLE
39     , a36 JTF_NUMBER_TABLE
40     , a37 JTF_NUMBER_TABLE
41     , a38 JTF_DATE_TABLE
42     , a39 JTF_NUMBER_TABLE
43     , a40 JTF_VARCHAR2_TABLE_100
44     , a41 JTF_NUMBER_TABLE
45     , a42 JTF_DATE_TABLE
46     , a43 JTF_NUMBER_TABLE
47     , a44 JTF_VARCHAR2_TABLE_100
48     , a45 JTF_VARCHAR2_TABLE_500
49     , a46 JTF_VARCHAR2_TABLE_500
50     , a47 JTF_VARCHAR2_TABLE_500
51     , a48 JTF_VARCHAR2_TABLE_500
52     , a49 JTF_VARCHAR2_TABLE_500
53     , a50 JTF_VARCHAR2_TABLE_500
54     , a51 JTF_VARCHAR2_TABLE_500
55     , a52 JTF_VARCHAR2_TABLE_500
56     , a53 JTF_VARCHAR2_TABLE_500
57     , a54 JTF_VARCHAR2_TABLE_500
58     , a55 JTF_VARCHAR2_TABLE_500
59     , a56 JTF_VARCHAR2_TABLE_500
60     , a57 JTF_VARCHAR2_TABLE_500
61     , a58 JTF_VARCHAR2_TABLE_500
62     , a59 JTF_VARCHAR2_TABLE_500
63     , a60 JTF_NUMBER_TABLE
64     , a61 JTF_DATE_TABLE
65     , a62 JTF_NUMBER_TABLE
66     , a63 JTF_DATE_TABLE
67     , a64 JTF_NUMBER_TABLE
68     , a65 JTF_VARCHAR2_TABLE_300
69     , a66 JTF_VARCHAR2_TABLE_100
70     , a67 JTF_VARCHAR2_TABLE_300
71     , a68 JTF_VARCHAR2_TABLE_100
72     , a69 JTF_NUMBER_TABLE
73     , a70 JTF_NUMBER_TABLE
74     , a71 JTF_DATE_TABLE
75     );
76   procedure rosetta_table_copy_out_p2(t okl_tap_pvt.tap_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77     , a1 out nocopy JTF_VARCHAR2_TABLE_100
78     , a2 out nocopy JTF_VARCHAR2_TABLE_100
79     , a3 out nocopy JTF_VARCHAR2_TABLE_100
80     , a4 out nocopy JTF_VARCHAR2_TABLE_100
81     , a5 out nocopy JTF_NUMBER_TABLE
82     , a6 out nocopy JTF_NUMBER_TABLE
83     , a7 out nocopy JTF_NUMBER_TABLE
84     , a8 out nocopy JTF_NUMBER_TABLE
85     , a9 out nocopy JTF_NUMBER_TABLE
86     , a10 out nocopy JTF_NUMBER_TABLE
87     , a11 out nocopy JTF_NUMBER_TABLE
88     , a12 out nocopy JTF_NUMBER_TABLE
89     , a13 out nocopy JTF_NUMBER_TABLE
90     , a14 out nocopy JTF_NUMBER_TABLE
91     , a15 out nocopy JTF_NUMBER_TABLE
92     , a16 out nocopy JTF_NUMBER_TABLE
93     , a17 out nocopy JTF_NUMBER_TABLE
94     , a18 out nocopy JTF_NUMBER_TABLE
95     , a19 out nocopy JTF_DATE_TABLE
96     , a20 out nocopy JTF_DATE_TABLE
97     , a21 out nocopy JTF_NUMBER_TABLE
98     , a22 out nocopy JTF_VARCHAR2_TABLE_100
99     , a23 out nocopy JTF_NUMBER_TABLE
100     , a24 out nocopy JTF_NUMBER_TABLE
101     , a25 out nocopy JTF_NUMBER_TABLE
102     , a26 out nocopy JTF_DATE_TABLE
103     , a27 out nocopy JTF_DATE_TABLE
104     , a28 out nocopy JTF_VARCHAR2_TABLE_100
105     , a29 out nocopy JTF_DATE_TABLE
106     , a30 out nocopy JTF_VARCHAR2_TABLE_100
107     , a31 out nocopy JTF_VARCHAR2_TABLE_100
108     , a32 out nocopy JTF_VARCHAR2_TABLE_100
109     , a33 out nocopy JTF_VARCHAR2_TABLE_100
110     , a34 out nocopy JTF_VARCHAR2_TABLE_100
111     , a35 out nocopy JTF_NUMBER_TABLE
112     , a36 out nocopy JTF_NUMBER_TABLE
113     , a37 out nocopy JTF_NUMBER_TABLE
114     , a38 out nocopy JTF_DATE_TABLE
115     , a39 out nocopy JTF_NUMBER_TABLE
116     , a40 out nocopy JTF_VARCHAR2_TABLE_100
117     , a41 out nocopy JTF_NUMBER_TABLE
118     , a42 out nocopy JTF_DATE_TABLE
119     , a43 out nocopy JTF_NUMBER_TABLE
120     , a44 out nocopy JTF_VARCHAR2_TABLE_100
121     , a45 out nocopy JTF_VARCHAR2_TABLE_500
122     , a46 out nocopy JTF_VARCHAR2_TABLE_500
123     , a47 out nocopy JTF_VARCHAR2_TABLE_500
124     , a48 out nocopy JTF_VARCHAR2_TABLE_500
125     , a49 out nocopy JTF_VARCHAR2_TABLE_500
126     , a50 out nocopy JTF_VARCHAR2_TABLE_500
127     , a51 out nocopy JTF_VARCHAR2_TABLE_500
128     , a52 out nocopy JTF_VARCHAR2_TABLE_500
129     , a53 out nocopy JTF_VARCHAR2_TABLE_500
130     , a54 out nocopy JTF_VARCHAR2_TABLE_500
131     , a55 out nocopy JTF_VARCHAR2_TABLE_500
132     , a56 out nocopy JTF_VARCHAR2_TABLE_500
133     , a57 out nocopy JTF_VARCHAR2_TABLE_500
134     , a58 out nocopy JTF_VARCHAR2_TABLE_500
135     , a59 out nocopy JTF_VARCHAR2_TABLE_500
136     , a60 out nocopy JTF_NUMBER_TABLE
137     , a61 out nocopy JTF_DATE_TABLE
138     , a62 out nocopy JTF_NUMBER_TABLE
139     , a63 out nocopy JTF_DATE_TABLE
140     , a64 out nocopy JTF_NUMBER_TABLE
141     , a65 out nocopy JTF_VARCHAR2_TABLE_300
142     , a66 out nocopy JTF_VARCHAR2_TABLE_100
143     , a67 out nocopy JTF_VARCHAR2_TABLE_300
144     , a68 out nocopy JTF_VARCHAR2_TABLE_100
145     , a69 out nocopy JTF_NUMBER_TABLE
146     , a70 out nocopy JTF_NUMBER_TABLE
147     , a71 out nocopy JTF_DATE_TABLE
148     );
149 
150   procedure rosetta_table_copy_in_p5(t out nocopy okl_tap_pvt.okltrxapinvoicestltbltype, a0 JTF_NUMBER_TABLE
151     , a1 JTF_VARCHAR2_TABLE_100
152     , a2 JTF_VARCHAR2_TABLE_100
153     , a3 JTF_VARCHAR2_TABLE_100
154     , a4 JTF_VARCHAR2_TABLE_2000
155     , a5 JTF_NUMBER_TABLE
156     , a6 JTF_DATE_TABLE
157     , a7 JTF_NUMBER_TABLE
158     , a8 JTF_DATE_TABLE
159     , a9 JTF_NUMBER_TABLE
160     );
161   procedure rosetta_table_copy_out_p5(t okl_tap_pvt.okltrxapinvoicestltbltype, a0 out nocopy JTF_NUMBER_TABLE
162     , a1 out nocopy JTF_VARCHAR2_TABLE_100
163     , a2 out nocopy JTF_VARCHAR2_TABLE_100
164     , a3 out nocopy JTF_VARCHAR2_TABLE_100
165     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
166     , a5 out nocopy JTF_NUMBER_TABLE
167     , a6 out nocopy JTF_DATE_TABLE
168     , a7 out nocopy JTF_NUMBER_TABLE
169     , a8 out nocopy JTF_DATE_TABLE
170     , a9 out nocopy JTF_NUMBER_TABLE
171     );
172 
173   procedure rosetta_table_copy_in_p8(t out nocopy okl_tap_pvt.tapv_tbl_type, a0 JTF_NUMBER_TABLE
174     , a1 JTF_NUMBER_TABLE
175     , a2 JTF_VARCHAR2_TABLE_100
176     , a3 JTF_NUMBER_TABLE
177     , a4 JTF_VARCHAR2_TABLE_100
178     , a5 JTF_NUMBER_TABLE
179     , a6 JTF_VARCHAR2_TABLE_100
180     , a7 JTF_NUMBER_TABLE
181     , a8 JTF_NUMBER_TABLE
182     , a9 JTF_NUMBER_TABLE
183     , a10 JTF_NUMBER_TABLE
184     , a11 JTF_NUMBER_TABLE
185     , a12 JTF_NUMBER_TABLE
186     , a13 JTF_NUMBER_TABLE
187     , a14 JTF_NUMBER_TABLE
188     , a15 JTF_NUMBER_TABLE
189     , a16 JTF_NUMBER_TABLE
190     , a17 JTF_VARCHAR2_TABLE_100
191     , a18 JTF_VARCHAR2_TABLE_100
192     , a19 JTF_NUMBER_TABLE
193     , a20 JTF_NUMBER_TABLE
194     , a21 JTF_NUMBER_TABLE
195     , a22 JTF_DATE_TABLE
196     , a23 JTF_VARCHAR2_TABLE_100
197     , a24 JTF_DATE_TABLE
198     , a25 JTF_DATE_TABLE
199     , a26 JTF_VARCHAR2_TABLE_100
200     , a27 JTF_VARCHAR2_TABLE_100
201     , a28 JTF_VARCHAR2_TABLE_100
202     , a29 JTF_VARCHAR2_TABLE_100
203     , a30 JTF_VARCHAR2_TABLE_100
204     , a31 JTF_DATE_TABLE
205     , a32 JTF_VARCHAR2_TABLE_2000
206     , a33 JTF_VARCHAR2_TABLE_100
207     , a34 JTF_NUMBER_TABLE
208     , a35 JTF_DATE_TABLE
209     , a36 JTF_NUMBER_TABLE
210     , a37 JTF_VARCHAR2_TABLE_100
211     , a38 JTF_VARCHAR2_TABLE_500
212     , a39 JTF_VARCHAR2_TABLE_500
213     , a40 JTF_VARCHAR2_TABLE_500
214     , a41 JTF_VARCHAR2_TABLE_500
215     , a42 JTF_VARCHAR2_TABLE_500
216     , a43 JTF_VARCHAR2_TABLE_500
217     , a44 JTF_VARCHAR2_TABLE_500
218     , a45 JTF_VARCHAR2_TABLE_500
219     , a46 JTF_VARCHAR2_TABLE_500
220     , a47 JTF_VARCHAR2_TABLE_500
221     , a48 JTF_VARCHAR2_TABLE_500
222     , a49 JTF_VARCHAR2_TABLE_500
223     , a50 JTF_VARCHAR2_TABLE_500
224     , a51 JTF_VARCHAR2_TABLE_500
225     , a52 JTF_VARCHAR2_TABLE_500
226     , a53 JTF_DATE_TABLE
227     , a54 JTF_VARCHAR2_TABLE_100
228     , a55 JTF_NUMBER_TABLE
229     , a56 JTF_NUMBER_TABLE
230     , a57 JTF_NUMBER_TABLE
231     , a58 JTF_NUMBER_TABLE
232     , a59 JTF_NUMBER_TABLE
233     , a60 JTF_DATE_TABLE
234     , a61 JTF_NUMBER_TABLE
235     , a62 JTF_NUMBER_TABLE
236     , a63 JTF_DATE_TABLE
237     , a64 JTF_NUMBER_TABLE
238     , a65 JTF_DATE_TABLE
239     , a66 JTF_NUMBER_TABLE
240     , a67 JTF_VARCHAR2_TABLE_300
241     , a68 JTF_VARCHAR2_TABLE_100
242     , a69 JTF_VARCHAR2_TABLE_300
243     , a70 JTF_VARCHAR2_TABLE_100
244     , a71 JTF_NUMBER_TABLE
245     , a72 JTF_NUMBER_TABLE
246     , a73 JTF_DATE_TABLE
247     );
248   procedure rosetta_table_copy_out_p8(t okl_tap_pvt.tapv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
249     , a1 out nocopy JTF_NUMBER_TABLE
250     , a2 out nocopy JTF_VARCHAR2_TABLE_100
251     , a3 out nocopy JTF_NUMBER_TABLE
252     , a4 out nocopy JTF_VARCHAR2_TABLE_100
253     , a5 out nocopy JTF_NUMBER_TABLE
254     , a6 out nocopy JTF_VARCHAR2_TABLE_100
255     , a7 out nocopy JTF_NUMBER_TABLE
256     , a8 out nocopy JTF_NUMBER_TABLE
257     , a9 out nocopy JTF_NUMBER_TABLE
258     , a10 out nocopy JTF_NUMBER_TABLE
259     , a11 out nocopy JTF_NUMBER_TABLE
260     , a12 out nocopy JTF_NUMBER_TABLE
261     , a13 out nocopy JTF_NUMBER_TABLE
262     , a14 out nocopy JTF_NUMBER_TABLE
263     , a15 out nocopy JTF_NUMBER_TABLE
264     , a16 out nocopy JTF_NUMBER_TABLE
265     , a17 out nocopy JTF_VARCHAR2_TABLE_100
266     , a18 out nocopy JTF_VARCHAR2_TABLE_100
267     , a19 out nocopy JTF_NUMBER_TABLE
268     , a20 out nocopy JTF_NUMBER_TABLE
269     , a21 out nocopy JTF_NUMBER_TABLE
270     , a22 out nocopy JTF_DATE_TABLE
271     , a23 out nocopy JTF_VARCHAR2_TABLE_100
272     , a24 out nocopy JTF_DATE_TABLE
273     , a25 out nocopy JTF_DATE_TABLE
274     , a26 out nocopy JTF_VARCHAR2_TABLE_100
275     , a27 out nocopy JTF_VARCHAR2_TABLE_100
276     , a28 out nocopy JTF_VARCHAR2_TABLE_100
277     , a29 out nocopy JTF_VARCHAR2_TABLE_100
278     , a30 out nocopy JTF_VARCHAR2_TABLE_100
279     , a31 out nocopy JTF_DATE_TABLE
280     , a32 out nocopy JTF_VARCHAR2_TABLE_2000
281     , a33 out nocopy JTF_VARCHAR2_TABLE_100
282     , a34 out nocopy JTF_NUMBER_TABLE
283     , a35 out nocopy JTF_DATE_TABLE
284     , a36 out nocopy JTF_NUMBER_TABLE
285     , a37 out nocopy JTF_VARCHAR2_TABLE_100
286     , a38 out nocopy JTF_VARCHAR2_TABLE_500
287     , a39 out nocopy JTF_VARCHAR2_TABLE_500
288     , a40 out nocopy JTF_VARCHAR2_TABLE_500
289     , a41 out nocopy JTF_VARCHAR2_TABLE_500
290     , a42 out nocopy JTF_VARCHAR2_TABLE_500
291     , a43 out nocopy JTF_VARCHAR2_TABLE_500
292     , a44 out nocopy JTF_VARCHAR2_TABLE_500
293     , a45 out nocopy JTF_VARCHAR2_TABLE_500
294     , a46 out nocopy JTF_VARCHAR2_TABLE_500
295     , a47 out nocopy JTF_VARCHAR2_TABLE_500
296     , a48 out nocopy JTF_VARCHAR2_TABLE_500
297     , a49 out nocopy JTF_VARCHAR2_TABLE_500
298     , a50 out nocopy JTF_VARCHAR2_TABLE_500
299     , a51 out nocopy JTF_VARCHAR2_TABLE_500
300     , a52 out nocopy JTF_VARCHAR2_TABLE_500
301     , a53 out nocopy JTF_DATE_TABLE
302     , a54 out nocopy JTF_VARCHAR2_TABLE_100
303     , a55 out nocopy JTF_NUMBER_TABLE
304     , a56 out nocopy JTF_NUMBER_TABLE
305     , a57 out nocopy JTF_NUMBER_TABLE
306     , a58 out nocopy JTF_NUMBER_TABLE
307     , a59 out nocopy JTF_NUMBER_TABLE
308     , a60 out nocopy JTF_DATE_TABLE
309     , a61 out nocopy JTF_NUMBER_TABLE
310     , a62 out nocopy JTF_NUMBER_TABLE
311     , a63 out nocopy JTF_DATE_TABLE
312     , a64 out nocopy JTF_NUMBER_TABLE
313     , a65 out nocopy JTF_DATE_TABLE
314     , a66 out nocopy JTF_NUMBER_TABLE
315     , a67 out nocopy JTF_VARCHAR2_TABLE_300
316     , a68 out nocopy JTF_VARCHAR2_TABLE_100
317     , a69 out nocopy JTF_VARCHAR2_TABLE_300
318     , a70 out nocopy JTF_VARCHAR2_TABLE_100
319     , a71 out nocopy JTF_NUMBER_TABLE
320     , a72 out nocopy JTF_NUMBER_TABLE
321     , a73 out nocopy JTF_DATE_TABLE
322     );
323 
324   procedure insert_row(p_api_version  NUMBER
325     , p_init_msg_list  VARCHAR2
326     , x_return_status out nocopy  VARCHAR2
327     , x_msg_count out nocopy  NUMBER
328     , x_msg_data out nocopy  VARCHAR2
329     , p6_a0 out nocopy  NUMBER
330     , p6_a1 out nocopy  NUMBER
331     , p6_a2 out nocopy  VARCHAR2
332     , p6_a3 out nocopy  NUMBER
333     , p6_a4 out nocopy  VARCHAR2
334     , p6_a5 out nocopy  NUMBER
335     , p6_a6 out nocopy  VARCHAR2
336     , p6_a7 out nocopy  NUMBER
337     , p6_a8 out nocopy  NUMBER
338     , p6_a9 out nocopy  NUMBER
339     , p6_a10 out nocopy  NUMBER
340     , p6_a11 out nocopy  NUMBER
341     , p6_a12 out nocopy  NUMBER
342     , p6_a13 out nocopy  NUMBER
343     , p6_a14 out nocopy  NUMBER
344     , p6_a15 out nocopy  NUMBER
345     , p6_a16 out nocopy  NUMBER
346     , p6_a17 out nocopy  VARCHAR2
347     , p6_a18 out nocopy  VARCHAR2
348     , p6_a19 out nocopy  NUMBER
349     , p6_a20 out nocopy  NUMBER
350     , p6_a21 out nocopy  NUMBER
351     , p6_a22 out nocopy  DATE
352     , p6_a23 out nocopy  VARCHAR2
353     , p6_a24 out nocopy  DATE
354     , p6_a25 out nocopy  DATE
355     , p6_a26 out nocopy  VARCHAR2
356     , p6_a27 out nocopy  VARCHAR2
357     , p6_a28 out nocopy  VARCHAR2
358     , p6_a29 out nocopy  VARCHAR2
359     , p6_a30 out nocopy  VARCHAR2
360     , p6_a31 out nocopy  DATE
361     , p6_a32 out nocopy  VARCHAR2
362     , p6_a33 out nocopy  VARCHAR2
363     , p6_a34 out nocopy  NUMBER
364     , p6_a35 out nocopy  DATE
365     , p6_a36 out nocopy  NUMBER
366     , p6_a37 out nocopy  VARCHAR2
367     , p6_a38 out nocopy  VARCHAR2
368     , p6_a39 out nocopy  VARCHAR2
369     , p6_a40 out nocopy  VARCHAR2
370     , p6_a41 out nocopy  VARCHAR2
371     , p6_a42 out nocopy  VARCHAR2
372     , p6_a43 out nocopy  VARCHAR2
373     , p6_a44 out nocopy  VARCHAR2
374     , p6_a45 out nocopy  VARCHAR2
375     , p6_a46 out nocopy  VARCHAR2
376     , p6_a47 out nocopy  VARCHAR2
377     , p6_a48 out nocopy  VARCHAR2
378     , p6_a49 out nocopy  VARCHAR2
379     , p6_a50 out nocopy  VARCHAR2
380     , p6_a51 out nocopy  VARCHAR2
381     , p6_a52 out nocopy  VARCHAR2
382     , p6_a53 out nocopy  DATE
383     , p6_a54 out nocopy  VARCHAR2
384     , p6_a55 out nocopy  NUMBER
385     , p6_a56 out nocopy  NUMBER
386     , p6_a57 out nocopy  NUMBER
387     , p6_a58 out nocopy  NUMBER
388     , p6_a59 out nocopy  NUMBER
389     , p6_a60 out nocopy  DATE
390     , p6_a61 out nocopy  NUMBER
391     , p6_a62 out nocopy  NUMBER
392     , p6_a63 out nocopy  DATE
393     , p6_a64 out nocopy  NUMBER
394     , p6_a65 out nocopy  DATE
395     , p6_a66 out nocopy  NUMBER
396     , p6_a67 out nocopy  VARCHAR2
397     , p6_a68 out nocopy  VARCHAR2
398     , p6_a69 out nocopy  VARCHAR2
399     , p6_a70 out nocopy  VARCHAR2
400     , p6_a71 out nocopy  NUMBER
401     , p6_a72 out nocopy  NUMBER
402     , p6_a73 out nocopy  DATE
403     , p5_a0  NUMBER := 0-1962.0724
404     , p5_a1  NUMBER := 0-1962.0724
405     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
406     , p5_a3  NUMBER := 0-1962.0724
407     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
408     , p5_a5  NUMBER := 0-1962.0724
409     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
410     , p5_a7  NUMBER := 0-1962.0724
411     , p5_a8  NUMBER := 0-1962.0724
412     , p5_a9  NUMBER := 0-1962.0724
413     , p5_a10  NUMBER := 0-1962.0724
414     , p5_a11  NUMBER := 0-1962.0724
415     , p5_a12  NUMBER := 0-1962.0724
416     , p5_a13  NUMBER := 0-1962.0724
417     , p5_a14  NUMBER := 0-1962.0724
418     , p5_a15  NUMBER := 0-1962.0724
419     , p5_a16  NUMBER := 0-1962.0724
420     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
421     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
422     , p5_a19  NUMBER := 0-1962.0724
423     , p5_a20  NUMBER := 0-1962.0724
424     , p5_a21  NUMBER := 0-1962.0724
425     , p5_a22  DATE := fnd_api.g_miss_date
426     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
427     , p5_a24  DATE := fnd_api.g_miss_date
428     , p5_a25  DATE := fnd_api.g_miss_date
429     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
430     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
431     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
432     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
433     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
434     , p5_a31  DATE := fnd_api.g_miss_date
435     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
436     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
437     , p5_a34  NUMBER := 0-1962.0724
438     , p5_a35  DATE := fnd_api.g_miss_date
439     , p5_a36  NUMBER := 0-1962.0724
440     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
441     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
442     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
443     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
444     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
445     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
446     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
447     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
448     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
449     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
450     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
451     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
452     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
453     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
454     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
455     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
456     , p5_a53  DATE := fnd_api.g_miss_date
457     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
458     , p5_a55  NUMBER := 0-1962.0724
459     , p5_a56  NUMBER := 0-1962.0724
460     , p5_a57  NUMBER := 0-1962.0724
461     , p5_a58  NUMBER := 0-1962.0724
462     , p5_a59  NUMBER := 0-1962.0724
463     , p5_a60  DATE := fnd_api.g_miss_date
464     , p5_a61  NUMBER := 0-1962.0724
465     , p5_a62  NUMBER := 0-1962.0724
466     , p5_a63  DATE := fnd_api.g_miss_date
467     , p5_a64  NUMBER := 0-1962.0724
468     , p5_a65  DATE := fnd_api.g_miss_date
469     , p5_a66  NUMBER := 0-1962.0724
470     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
471     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
472     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
473     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
474     , p5_a71  NUMBER := 0-1962.0724
475     , p5_a72  NUMBER := 0-1962.0724
476     , p5_a73  DATE := fnd_api.g_miss_date
477   );
478   procedure insert_row(p_api_version  NUMBER
479     , p_init_msg_list  VARCHAR2
480     , x_return_status out nocopy  VARCHAR2
481     , x_msg_count out nocopy  NUMBER
482     , x_msg_data out nocopy  VARCHAR2
483     , p5_a0 JTF_NUMBER_TABLE
484     , p5_a1 JTF_NUMBER_TABLE
485     , p5_a2 JTF_VARCHAR2_TABLE_100
486     , p5_a3 JTF_NUMBER_TABLE
487     , p5_a4 JTF_VARCHAR2_TABLE_100
488     , p5_a5 JTF_NUMBER_TABLE
489     , p5_a6 JTF_VARCHAR2_TABLE_100
490     , p5_a7 JTF_NUMBER_TABLE
491     , p5_a8 JTF_NUMBER_TABLE
492     , p5_a9 JTF_NUMBER_TABLE
493     , p5_a10 JTF_NUMBER_TABLE
494     , p5_a11 JTF_NUMBER_TABLE
495     , p5_a12 JTF_NUMBER_TABLE
496     , p5_a13 JTF_NUMBER_TABLE
497     , p5_a14 JTF_NUMBER_TABLE
498     , p5_a15 JTF_NUMBER_TABLE
499     , p5_a16 JTF_NUMBER_TABLE
500     , p5_a17 JTF_VARCHAR2_TABLE_100
501     , p5_a18 JTF_VARCHAR2_TABLE_100
502     , p5_a19 JTF_NUMBER_TABLE
503     , p5_a20 JTF_NUMBER_TABLE
504     , p5_a21 JTF_NUMBER_TABLE
505     , p5_a22 JTF_DATE_TABLE
506     , p5_a23 JTF_VARCHAR2_TABLE_100
507     , p5_a24 JTF_DATE_TABLE
508     , p5_a25 JTF_DATE_TABLE
509     , p5_a26 JTF_VARCHAR2_TABLE_100
510     , p5_a27 JTF_VARCHAR2_TABLE_100
511     , p5_a28 JTF_VARCHAR2_TABLE_100
512     , p5_a29 JTF_VARCHAR2_TABLE_100
513     , p5_a30 JTF_VARCHAR2_TABLE_100
514     , p5_a31 JTF_DATE_TABLE
515     , p5_a32 JTF_VARCHAR2_TABLE_2000
516     , p5_a33 JTF_VARCHAR2_TABLE_100
517     , p5_a34 JTF_NUMBER_TABLE
518     , p5_a35 JTF_DATE_TABLE
519     , p5_a36 JTF_NUMBER_TABLE
520     , p5_a37 JTF_VARCHAR2_TABLE_100
521     , p5_a38 JTF_VARCHAR2_TABLE_500
522     , p5_a39 JTF_VARCHAR2_TABLE_500
523     , p5_a40 JTF_VARCHAR2_TABLE_500
524     , p5_a41 JTF_VARCHAR2_TABLE_500
525     , p5_a42 JTF_VARCHAR2_TABLE_500
526     , p5_a43 JTF_VARCHAR2_TABLE_500
527     , p5_a44 JTF_VARCHAR2_TABLE_500
528     , p5_a45 JTF_VARCHAR2_TABLE_500
529     , p5_a46 JTF_VARCHAR2_TABLE_500
530     , p5_a47 JTF_VARCHAR2_TABLE_500
531     , p5_a48 JTF_VARCHAR2_TABLE_500
532     , p5_a49 JTF_VARCHAR2_TABLE_500
533     , p5_a50 JTF_VARCHAR2_TABLE_500
534     , p5_a51 JTF_VARCHAR2_TABLE_500
535     , p5_a52 JTF_VARCHAR2_TABLE_500
536     , p5_a53 JTF_DATE_TABLE
537     , p5_a54 JTF_VARCHAR2_TABLE_100
538     , p5_a55 JTF_NUMBER_TABLE
539     , p5_a56 JTF_NUMBER_TABLE
540     , p5_a57 JTF_NUMBER_TABLE
541     , p5_a58 JTF_NUMBER_TABLE
542     , p5_a59 JTF_NUMBER_TABLE
543     , p5_a60 JTF_DATE_TABLE
544     , p5_a61 JTF_NUMBER_TABLE
545     , p5_a62 JTF_NUMBER_TABLE
546     , p5_a63 JTF_DATE_TABLE
547     , p5_a64 JTF_NUMBER_TABLE
548     , p5_a65 JTF_DATE_TABLE
549     , p5_a66 JTF_NUMBER_TABLE
550     , p5_a67 JTF_VARCHAR2_TABLE_300
551     , p5_a68 JTF_VARCHAR2_TABLE_100
552     , p5_a69 JTF_VARCHAR2_TABLE_300
553     , p5_a70 JTF_VARCHAR2_TABLE_100
554     , p5_a71 JTF_NUMBER_TABLE
555     , p5_a72 JTF_NUMBER_TABLE
556     , p5_a73 JTF_DATE_TABLE
557     , p6_a0 out nocopy JTF_NUMBER_TABLE
558     , p6_a1 out nocopy JTF_NUMBER_TABLE
559     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560     , p6_a3 out nocopy JTF_NUMBER_TABLE
561     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562     , p6_a5 out nocopy JTF_NUMBER_TABLE
563     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
564     , p6_a7 out nocopy JTF_NUMBER_TABLE
565     , p6_a8 out nocopy JTF_NUMBER_TABLE
566     , p6_a9 out nocopy JTF_NUMBER_TABLE
567     , p6_a10 out nocopy JTF_NUMBER_TABLE
568     , p6_a11 out nocopy JTF_NUMBER_TABLE
569     , p6_a12 out nocopy JTF_NUMBER_TABLE
570     , p6_a13 out nocopy JTF_NUMBER_TABLE
571     , p6_a14 out nocopy JTF_NUMBER_TABLE
572     , p6_a15 out nocopy JTF_NUMBER_TABLE
573     , p6_a16 out nocopy JTF_NUMBER_TABLE
574     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
575     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
576     , p6_a19 out nocopy JTF_NUMBER_TABLE
577     , p6_a20 out nocopy JTF_NUMBER_TABLE
578     , p6_a21 out nocopy JTF_NUMBER_TABLE
579     , p6_a22 out nocopy JTF_DATE_TABLE
580     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
581     , p6_a24 out nocopy JTF_DATE_TABLE
582     , p6_a25 out nocopy JTF_DATE_TABLE
583     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
584     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
585     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
586     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
587     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
588     , p6_a31 out nocopy JTF_DATE_TABLE
589     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
590     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
591     , p6_a34 out nocopy JTF_NUMBER_TABLE
592     , p6_a35 out nocopy JTF_DATE_TABLE
593     , p6_a36 out nocopy JTF_NUMBER_TABLE
594     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
595     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
596     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
597     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
598     , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
599     , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
600     , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
601     , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
602     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
603     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
604     , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
605     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
606     , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
607     , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
608     , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
609     , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
610     , p6_a53 out nocopy JTF_DATE_TABLE
611     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
612     , p6_a55 out nocopy JTF_NUMBER_TABLE
613     , p6_a56 out nocopy JTF_NUMBER_TABLE
614     , p6_a57 out nocopy JTF_NUMBER_TABLE
615     , p6_a58 out nocopy JTF_NUMBER_TABLE
616     , p6_a59 out nocopy JTF_NUMBER_TABLE
617     , p6_a60 out nocopy JTF_DATE_TABLE
618     , p6_a61 out nocopy JTF_NUMBER_TABLE
619     , p6_a62 out nocopy JTF_NUMBER_TABLE
620     , p6_a63 out nocopy JTF_DATE_TABLE
621     , p6_a64 out nocopy JTF_NUMBER_TABLE
622     , p6_a65 out nocopy JTF_DATE_TABLE
623     , p6_a66 out nocopy JTF_NUMBER_TABLE
624     , p6_a67 out nocopy JTF_VARCHAR2_TABLE_300
625     , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
626     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
627     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
628     , p6_a71 out nocopy JTF_NUMBER_TABLE
629     , p6_a72 out nocopy JTF_NUMBER_TABLE
630     , p6_a73 out nocopy JTF_DATE_TABLE
631   );
632   procedure lock_row(p_api_version  NUMBER
633     , p_init_msg_list  VARCHAR2
634     , x_return_status out nocopy  VARCHAR2
635     , x_msg_count out nocopy  NUMBER
636     , x_msg_data out nocopy  VARCHAR2
637     , p5_a0  NUMBER := 0-1962.0724
638     , p5_a1  NUMBER := 0-1962.0724
639     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
640     , p5_a3  NUMBER := 0-1962.0724
641     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
642     , p5_a5  NUMBER := 0-1962.0724
643     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
644     , p5_a7  NUMBER := 0-1962.0724
645     , p5_a8  NUMBER := 0-1962.0724
646     , p5_a9  NUMBER := 0-1962.0724
647     , p5_a10  NUMBER := 0-1962.0724
648     , p5_a11  NUMBER := 0-1962.0724
649     , p5_a12  NUMBER := 0-1962.0724
650     , p5_a13  NUMBER := 0-1962.0724
651     , p5_a14  NUMBER := 0-1962.0724
652     , p5_a15  NUMBER := 0-1962.0724
653     , p5_a16  NUMBER := 0-1962.0724
654     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
655     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
656     , p5_a19  NUMBER := 0-1962.0724
657     , p5_a20  NUMBER := 0-1962.0724
658     , p5_a21  NUMBER := 0-1962.0724
659     , p5_a22  DATE := fnd_api.g_miss_date
660     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
661     , p5_a24  DATE := fnd_api.g_miss_date
662     , p5_a25  DATE := fnd_api.g_miss_date
663     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
664     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
665     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
666     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
667     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
668     , p5_a31  DATE := fnd_api.g_miss_date
669     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
670     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
671     , p5_a34  NUMBER := 0-1962.0724
672     , p5_a35  DATE := fnd_api.g_miss_date
673     , p5_a36  NUMBER := 0-1962.0724
674     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
675     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
676     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
677     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
678     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
679     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
680     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
681     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
682     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
683     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
684     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
685     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
686     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
687     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
688     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
689     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
690     , p5_a53  DATE := fnd_api.g_miss_date
691     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
692     , p5_a55  NUMBER := 0-1962.0724
693     , p5_a56  NUMBER := 0-1962.0724
694     , p5_a57  NUMBER := 0-1962.0724
695     , p5_a58  NUMBER := 0-1962.0724
696     , p5_a59  NUMBER := 0-1962.0724
697     , p5_a60  DATE := fnd_api.g_miss_date
698     , p5_a61  NUMBER := 0-1962.0724
699     , p5_a62  NUMBER := 0-1962.0724
700     , p5_a63  DATE := fnd_api.g_miss_date
701     , p5_a64  NUMBER := 0-1962.0724
702     , p5_a65  DATE := fnd_api.g_miss_date
703     , p5_a66  NUMBER := 0-1962.0724
704     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
705     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
706     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
707     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
708     , p5_a71  NUMBER := 0-1962.0724
709     , p5_a72  NUMBER := 0-1962.0724
710     , p5_a73  DATE := fnd_api.g_miss_date
711   );
712   procedure lock_row(p_api_version  NUMBER
713     , p_init_msg_list  VARCHAR2
714     , x_return_status out nocopy  VARCHAR2
715     , x_msg_count out nocopy  NUMBER
716     , x_msg_data out nocopy  VARCHAR2
717     , p5_a0 JTF_NUMBER_TABLE
718     , p5_a1 JTF_NUMBER_TABLE
719     , p5_a2 JTF_VARCHAR2_TABLE_100
720     , p5_a3 JTF_NUMBER_TABLE
721     , p5_a4 JTF_VARCHAR2_TABLE_100
722     , p5_a5 JTF_NUMBER_TABLE
723     , p5_a6 JTF_VARCHAR2_TABLE_100
724     , p5_a7 JTF_NUMBER_TABLE
725     , p5_a8 JTF_NUMBER_TABLE
726     , p5_a9 JTF_NUMBER_TABLE
727     , p5_a10 JTF_NUMBER_TABLE
728     , p5_a11 JTF_NUMBER_TABLE
729     , p5_a12 JTF_NUMBER_TABLE
730     , p5_a13 JTF_NUMBER_TABLE
731     , p5_a14 JTF_NUMBER_TABLE
732     , p5_a15 JTF_NUMBER_TABLE
733     , p5_a16 JTF_NUMBER_TABLE
734     , p5_a17 JTF_VARCHAR2_TABLE_100
735     , p5_a18 JTF_VARCHAR2_TABLE_100
736     , p5_a19 JTF_NUMBER_TABLE
737     , p5_a20 JTF_NUMBER_TABLE
738     , p5_a21 JTF_NUMBER_TABLE
739     , p5_a22 JTF_DATE_TABLE
740     , p5_a23 JTF_VARCHAR2_TABLE_100
741     , p5_a24 JTF_DATE_TABLE
742     , p5_a25 JTF_DATE_TABLE
743     , p5_a26 JTF_VARCHAR2_TABLE_100
744     , p5_a27 JTF_VARCHAR2_TABLE_100
745     , p5_a28 JTF_VARCHAR2_TABLE_100
746     , p5_a29 JTF_VARCHAR2_TABLE_100
747     , p5_a30 JTF_VARCHAR2_TABLE_100
748     , p5_a31 JTF_DATE_TABLE
749     , p5_a32 JTF_VARCHAR2_TABLE_2000
750     , p5_a33 JTF_VARCHAR2_TABLE_100
751     , p5_a34 JTF_NUMBER_TABLE
752     , p5_a35 JTF_DATE_TABLE
753     , p5_a36 JTF_NUMBER_TABLE
754     , p5_a37 JTF_VARCHAR2_TABLE_100
755     , p5_a38 JTF_VARCHAR2_TABLE_500
756     , p5_a39 JTF_VARCHAR2_TABLE_500
757     , p5_a40 JTF_VARCHAR2_TABLE_500
758     , p5_a41 JTF_VARCHAR2_TABLE_500
759     , p5_a42 JTF_VARCHAR2_TABLE_500
760     , p5_a43 JTF_VARCHAR2_TABLE_500
761     , p5_a44 JTF_VARCHAR2_TABLE_500
762     , p5_a45 JTF_VARCHAR2_TABLE_500
763     , p5_a46 JTF_VARCHAR2_TABLE_500
764     , p5_a47 JTF_VARCHAR2_TABLE_500
765     , p5_a48 JTF_VARCHAR2_TABLE_500
766     , p5_a49 JTF_VARCHAR2_TABLE_500
767     , p5_a50 JTF_VARCHAR2_TABLE_500
768     , p5_a51 JTF_VARCHAR2_TABLE_500
769     , p5_a52 JTF_VARCHAR2_TABLE_500
770     , p5_a53 JTF_DATE_TABLE
771     , p5_a54 JTF_VARCHAR2_TABLE_100
772     , p5_a55 JTF_NUMBER_TABLE
773     , p5_a56 JTF_NUMBER_TABLE
774     , p5_a57 JTF_NUMBER_TABLE
775     , p5_a58 JTF_NUMBER_TABLE
776     , p5_a59 JTF_NUMBER_TABLE
777     , p5_a60 JTF_DATE_TABLE
778     , p5_a61 JTF_NUMBER_TABLE
779     , p5_a62 JTF_NUMBER_TABLE
780     , p5_a63 JTF_DATE_TABLE
781     , p5_a64 JTF_NUMBER_TABLE
782     , p5_a65 JTF_DATE_TABLE
783     , p5_a66 JTF_NUMBER_TABLE
784     , p5_a67 JTF_VARCHAR2_TABLE_300
785     , p5_a68 JTF_VARCHAR2_TABLE_100
786     , p5_a69 JTF_VARCHAR2_TABLE_300
787     , p5_a70 JTF_VARCHAR2_TABLE_100
788     , p5_a71 JTF_NUMBER_TABLE
789     , p5_a72 JTF_NUMBER_TABLE
790     , p5_a73 JTF_DATE_TABLE
791   );
792   procedure update_row(p_api_version  NUMBER
793     , p_init_msg_list  VARCHAR2
794     , x_return_status out nocopy  VARCHAR2
795     , x_msg_count out nocopy  NUMBER
796     , x_msg_data out nocopy  VARCHAR2
797     , p6_a0 out nocopy  NUMBER
798     , p6_a1 out nocopy  NUMBER
799     , p6_a2 out nocopy  VARCHAR2
800     , p6_a3 out nocopy  NUMBER
801     , p6_a4 out nocopy  VARCHAR2
802     , p6_a5 out nocopy  NUMBER
803     , p6_a6 out nocopy  VARCHAR2
804     , p6_a7 out nocopy  NUMBER
805     , p6_a8 out nocopy  NUMBER
806     , p6_a9 out nocopy  NUMBER
807     , p6_a10 out nocopy  NUMBER
808     , p6_a11 out nocopy  NUMBER
809     , p6_a12 out nocopy  NUMBER
810     , p6_a13 out nocopy  NUMBER
811     , p6_a14 out nocopy  NUMBER
812     , p6_a15 out nocopy  NUMBER
813     , p6_a16 out nocopy  NUMBER
814     , p6_a17 out nocopy  VARCHAR2
815     , p6_a18 out nocopy  VARCHAR2
816     , p6_a19 out nocopy  NUMBER
817     , p6_a20 out nocopy  NUMBER
818     , p6_a21 out nocopy  NUMBER
819     , p6_a22 out nocopy  DATE
820     , p6_a23 out nocopy  VARCHAR2
821     , p6_a24 out nocopy  DATE
822     , p6_a25 out nocopy  DATE
823     , p6_a26 out nocopy  VARCHAR2
824     , p6_a27 out nocopy  VARCHAR2
825     , p6_a28 out nocopy  VARCHAR2
826     , p6_a29 out nocopy  VARCHAR2
827     , p6_a30 out nocopy  VARCHAR2
828     , p6_a31 out nocopy  DATE
829     , p6_a32 out nocopy  VARCHAR2
830     , p6_a33 out nocopy  VARCHAR2
831     , p6_a34 out nocopy  NUMBER
832     , p6_a35 out nocopy  DATE
833     , p6_a36 out nocopy  NUMBER
834     , p6_a37 out nocopy  VARCHAR2
835     , p6_a38 out nocopy  VARCHAR2
836     , p6_a39 out nocopy  VARCHAR2
837     , p6_a40 out nocopy  VARCHAR2
838     , p6_a41 out nocopy  VARCHAR2
839     , p6_a42 out nocopy  VARCHAR2
840     , p6_a43 out nocopy  VARCHAR2
841     , p6_a44 out nocopy  VARCHAR2
842     , p6_a45 out nocopy  VARCHAR2
843     , p6_a46 out nocopy  VARCHAR2
844     , p6_a47 out nocopy  VARCHAR2
845     , p6_a48 out nocopy  VARCHAR2
846     , p6_a49 out nocopy  VARCHAR2
847     , p6_a50 out nocopy  VARCHAR2
848     , p6_a51 out nocopy  VARCHAR2
849     , p6_a52 out nocopy  VARCHAR2
850     , p6_a53 out nocopy  DATE
851     , p6_a54 out nocopy  VARCHAR2
852     , p6_a55 out nocopy  NUMBER
853     , p6_a56 out nocopy  NUMBER
854     , p6_a57 out nocopy  NUMBER
855     , p6_a58 out nocopy  NUMBER
856     , p6_a59 out nocopy  NUMBER
857     , p6_a60 out nocopy  DATE
858     , p6_a61 out nocopy  NUMBER
859     , p6_a62 out nocopy  NUMBER
860     , p6_a63 out nocopy  DATE
861     , p6_a64 out nocopy  NUMBER
862     , p6_a65 out nocopy  DATE
863     , p6_a66 out nocopy  NUMBER
864     , p6_a67 out nocopy  VARCHAR2
865     , p6_a68 out nocopy  VARCHAR2
866     , p6_a69 out nocopy  VARCHAR2
867     , p6_a70 out nocopy  VARCHAR2
868     , p6_a71 out nocopy  NUMBER
869     , p6_a72 out nocopy  NUMBER
870     , p6_a73 out nocopy  DATE
871     , p5_a0  NUMBER := 0-1962.0724
872     , p5_a1  NUMBER := 0-1962.0724
873     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
874     , p5_a3  NUMBER := 0-1962.0724
875     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
876     , p5_a5  NUMBER := 0-1962.0724
877     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
878     , p5_a7  NUMBER := 0-1962.0724
879     , p5_a8  NUMBER := 0-1962.0724
880     , p5_a9  NUMBER := 0-1962.0724
881     , p5_a10  NUMBER := 0-1962.0724
882     , p5_a11  NUMBER := 0-1962.0724
883     , p5_a12  NUMBER := 0-1962.0724
884     , p5_a13  NUMBER := 0-1962.0724
885     , p5_a14  NUMBER := 0-1962.0724
886     , p5_a15  NUMBER := 0-1962.0724
887     , p5_a16  NUMBER := 0-1962.0724
888     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
889     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
890     , p5_a19  NUMBER := 0-1962.0724
891     , p5_a20  NUMBER := 0-1962.0724
892     , p5_a21  NUMBER := 0-1962.0724
893     , p5_a22  DATE := fnd_api.g_miss_date
894     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
895     , p5_a24  DATE := fnd_api.g_miss_date
896     , p5_a25  DATE := fnd_api.g_miss_date
897     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
898     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
899     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
900     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
901     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
902     , p5_a31  DATE := fnd_api.g_miss_date
903     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
904     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
905     , p5_a34  NUMBER := 0-1962.0724
906     , p5_a35  DATE := fnd_api.g_miss_date
907     , p5_a36  NUMBER := 0-1962.0724
908     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
909     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
910     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
911     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
912     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
913     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
914     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
915     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
916     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
917     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
918     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
919     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
920     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
921     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
922     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
923     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
924     , p5_a53  DATE := fnd_api.g_miss_date
925     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
926     , p5_a55  NUMBER := 0-1962.0724
927     , p5_a56  NUMBER := 0-1962.0724
928     , p5_a57  NUMBER := 0-1962.0724
929     , p5_a58  NUMBER := 0-1962.0724
930     , p5_a59  NUMBER := 0-1962.0724
931     , p5_a60  DATE := fnd_api.g_miss_date
932     , p5_a61  NUMBER := 0-1962.0724
933     , p5_a62  NUMBER := 0-1962.0724
934     , p5_a63  DATE := fnd_api.g_miss_date
935     , p5_a64  NUMBER := 0-1962.0724
936     , p5_a65  DATE := fnd_api.g_miss_date
937     , p5_a66  NUMBER := 0-1962.0724
938     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
939     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
940     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
941     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
942     , p5_a71  NUMBER := 0-1962.0724
943     , p5_a72  NUMBER := 0-1962.0724
944     , p5_a73  DATE := fnd_api.g_miss_date
945   );
946   procedure update_row(p_api_version  NUMBER
947     , p_init_msg_list  VARCHAR2
948     , x_return_status out nocopy  VARCHAR2
949     , x_msg_count out nocopy  NUMBER
950     , x_msg_data out nocopy  VARCHAR2
951     , p5_a0 JTF_NUMBER_TABLE
952     , p5_a1 JTF_NUMBER_TABLE
953     , p5_a2 JTF_VARCHAR2_TABLE_100
954     , p5_a3 JTF_NUMBER_TABLE
955     , p5_a4 JTF_VARCHAR2_TABLE_100
956     , p5_a5 JTF_NUMBER_TABLE
957     , p5_a6 JTF_VARCHAR2_TABLE_100
958     , p5_a7 JTF_NUMBER_TABLE
959     , p5_a8 JTF_NUMBER_TABLE
960     , p5_a9 JTF_NUMBER_TABLE
961     , p5_a10 JTF_NUMBER_TABLE
962     , p5_a11 JTF_NUMBER_TABLE
963     , p5_a12 JTF_NUMBER_TABLE
964     , p5_a13 JTF_NUMBER_TABLE
965     , p5_a14 JTF_NUMBER_TABLE
966     , p5_a15 JTF_NUMBER_TABLE
967     , p5_a16 JTF_NUMBER_TABLE
968     , p5_a17 JTF_VARCHAR2_TABLE_100
969     , p5_a18 JTF_VARCHAR2_TABLE_100
970     , p5_a19 JTF_NUMBER_TABLE
971     , p5_a20 JTF_NUMBER_TABLE
972     , p5_a21 JTF_NUMBER_TABLE
973     , p5_a22 JTF_DATE_TABLE
974     , p5_a23 JTF_VARCHAR2_TABLE_100
975     , p5_a24 JTF_DATE_TABLE
976     , p5_a25 JTF_DATE_TABLE
977     , p5_a26 JTF_VARCHAR2_TABLE_100
978     , p5_a27 JTF_VARCHAR2_TABLE_100
979     , p5_a28 JTF_VARCHAR2_TABLE_100
980     , p5_a29 JTF_VARCHAR2_TABLE_100
981     , p5_a30 JTF_VARCHAR2_TABLE_100
982     , p5_a31 JTF_DATE_TABLE
983     , p5_a32 JTF_VARCHAR2_TABLE_2000
984     , p5_a33 JTF_VARCHAR2_TABLE_100
985     , p5_a34 JTF_NUMBER_TABLE
986     , p5_a35 JTF_DATE_TABLE
987     , p5_a36 JTF_NUMBER_TABLE
988     , p5_a37 JTF_VARCHAR2_TABLE_100
989     , p5_a38 JTF_VARCHAR2_TABLE_500
990     , p5_a39 JTF_VARCHAR2_TABLE_500
991     , p5_a40 JTF_VARCHAR2_TABLE_500
992     , p5_a41 JTF_VARCHAR2_TABLE_500
993     , p5_a42 JTF_VARCHAR2_TABLE_500
994     , p5_a43 JTF_VARCHAR2_TABLE_500
995     , p5_a44 JTF_VARCHAR2_TABLE_500
996     , p5_a45 JTF_VARCHAR2_TABLE_500
997     , p5_a46 JTF_VARCHAR2_TABLE_500
998     , p5_a47 JTF_VARCHAR2_TABLE_500
999     , p5_a48 JTF_VARCHAR2_TABLE_500
1000     , p5_a49 JTF_VARCHAR2_TABLE_500
1001     , p5_a50 JTF_VARCHAR2_TABLE_500
1002     , p5_a51 JTF_VARCHAR2_TABLE_500
1003     , p5_a52 JTF_VARCHAR2_TABLE_500
1004     , p5_a53 JTF_DATE_TABLE
1005     , p5_a54 JTF_VARCHAR2_TABLE_100
1006     , p5_a55 JTF_NUMBER_TABLE
1007     , p5_a56 JTF_NUMBER_TABLE
1008     , p5_a57 JTF_NUMBER_TABLE
1009     , p5_a58 JTF_NUMBER_TABLE
1010     , p5_a59 JTF_NUMBER_TABLE
1011     , p5_a60 JTF_DATE_TABLE
1012     , p5_a61 JTF_NUMBER_TABLE
1013     , p5_a62 JTF_NUMBER_TABLE
1014     , p5_a63 JTF_DATE_TABLE
1015     , p5_a64 JTF_NUMBER_TABLE
1016     , p5_a65 JTF_DATE_TABLE
1017     , p5_a66 JTF_NUMBER_TABLE
1018     , p5_a67 JTF_VARCHAR2_TABLE_300
1019     , p5_a68 JTF_VARCHAR2_TABLE_100
1020     , p5_a69 JTF_VARCHAR2_TABLE_300
1021     , p5_a70 JTF_VARCHAR2_TABLE_100
1022     , p5_a71 JTF_NUMBER_TABLE
1023     , p5_a72 JTF_NUMBER_TABLE
1024     , p5_a73 JTF_DATE_TABLE
1025     , p6_a0 out nocopy JTF_NUMBER_TABLE
1026     , p6_a1 out nocopy JTF_NUMBER_TABLE
1027     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1028     , p6_a3 out nocopy JTF_NUMBER_TABLE
1029     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1030     , p6_a5 out nocopy JTF_NUMBER_TABLE
1031     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1032     , p6_a7 out nocopy JTF_NUMBER_TABLE
1033     , p6_a8 out nocopy JTF_NUMBER_TABLE
1034     , p6_a9 out nocopy JTF_NUMBER_TABLE
1035     , p6_a10 out nocopy JTF_NUMBER_TABLE
1036     , p6_a11 out nocopy JTF_NUMBER_TABLE
1037     , p6_a12 out nocopy JTF_NUMBER_TABLE
1038     , p6_a13 out nocopy JTF_NUMBER_TABLE
1039     , p6_a14 out nocopy JTF_NUMBER_TABLE
1040     , p6_a15 out nocopy JTF_NUMBER_TABLE
1041     , p6_a16 out nocopy JTF_NUMBER_TABLE
1042     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
1043     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
1044     , p6_a19 out nocopy JTF_NUMBER_TABLE
1045     , p6_a20 out nocopy JTF_NUMBER_TABLE
1046     , p6_a21 out nocopy JTF_NUMBER_TABLE
1047     , p6_a22 out nocopy JTF_DATE_TABLE
1048     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1049     , p6_a24 out nocopy JTF_DATE_TABLE
1050     , p6_a25 out nocopy JTF_DATE_TABLE
1051     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1052     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
1053     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1054     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
1055     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1056     , p6_a31 out nocopy JTF_DATE_TABLE
1057     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
1058     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
1059     , p6_a34 out nocopy JTF_NUMBER_TABLE
1060     , p6_a35 out nocopy JTF_DATE_TABLE
1061     , p6_a36 out nocopy JTF_NUMBER_TABLE
1062     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1063     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1064     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1065     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1066     , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1067     , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1068     , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1069     , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1070     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1071     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1072     , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1073     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1074     , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
1075     , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
1076     , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
1077     , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
1078     , p6_a53 out nocopy JTF_DATE_TABLE
1079     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1080     , p6_a55 out nocopy JTF_NUMBER_TABLE
1081     , p6_a56 out nocopy JTF_NUMBER_TABLE
1082     , p6_a57 out nocopy JTF_NUMBER_TABLE
1083     , p6_a58 out nocopy JTF_NUMBER_TABLE
1084     , p6_a59 out nocopy JTF_NUMBER_TABLE
1085     , p6_a60 out nocopy JTF_DATE_TABLE
1086     , p6_a61 out nocopy JTF_NUMBER_TABLE
1087     , p6_a62 out nocopy JTF_NUMBER_TABLE
1088     , p6_a63 out nocopy JTF_DATE_TABLE
1089     , p6_a64 out nocopy JTF_NUMBER_TABLE
1090     , p6_a65 out nocopy JTF_DATE_TABLE
1091     , p6_a66 out nocopy JTF_NUMBER_TABLE
1092     , p6_a67 out nocopy JTF_VARCHAR2_TABLE_300
1093     , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
1094     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_300
1095     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
1096     , p6_a71 out nocopy JTF_NUMBER_TABLE
1097     , p6_a72 out nocopy JTF_NUMBER_TABLE
1098     , p6_a73 out nocopy JTF_DATE_TABLE
1099   );
1100   procedure delete_row(p_api_version  NUMBER
1101     , p_init_msg_list  VARCHAR2
1102     , x_return_status out nocopy  VARCHAR2
1103     , x_msg_count out nocopy  NUMBER
1104     , x_msg_data out nocopy  VARCHAR2
1105     , p5_a0  NUMBER := 0-1962.0724
1106     , p5_a1  NUMBER := 0-1962.0724
1107     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1108     , p5_a3  NUMBER := 0-1962.0724
1109     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1110     , p5_a5  NUMBER := 0-1962.0724
1111     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
1112     , p5_a7  NUMBER := 0-1962.0724
1113     , p5_a8  NUMBER := 0-1962.0724
1114     , p5_a9  NUMBER := 0-1962.0724
1115     , p5_a10  NUMBER := 0-1962.0724
1116     , p5_a11  NUMBER := 0-1962.0724
1117     , p5_a12  NUMBER := 0-1962.0724
1118     , p5_a13  NUMBER := 0-1962.0724
1119     , p5_a14  NUMBER := 0-1962.0724
1120     , p5_a15  NUMBER := 0-1962.0724
1121     , p5_a16  NUMBER := 0-1962.0724
1122     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
1123     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1124     , p5_a19  NUMBER := 0-1962.0724
1125     , p5_a20  NUMBER := 0-1962.0724
1126     , p5_a21  NUMBER := 0-1962.0724
1127     , p5_a22  DATE := fnd_api.g_miss_date
1128     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1129     , p5_a24  DATE := fnd_api.g_miss_date
1130     , p5_a25  DATE := fnd_api.g_miss_date
1131     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1132     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1133     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1134     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1135     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1136     , p5_a31  DATE := fnd_api.g_miss_date
1137     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1138     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1139     , p5_a34  NUMBER := 0-1962.0724
1140     , p5_a35  DATE := fnd_api.g_miss_date
1141     , p5_a36  NUMBER := 0-1962.0724
1142     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
1143     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1144     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
1145     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1146     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1147     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
1148     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
1149     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
1150     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
1151     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
1152     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
1153     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
1154     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
1155     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
1156     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
1157     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
1158     , p5_a53  DATE := fnd_api.g_miss_date
1159     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
1160     , p5_a55  NUMBER := 0-1962.0724
1161     , p5_a56  NUMBER := 0-1962.0724
1162     , p5_a57  NUMBER := 0-1962.0724
1163     , p5_a58  NUMBER := 0-1962.0724
1164     , p5_a59  NUMBER := 0-1962.0724
1165     , p5_a60  DATE := fnd_api.g_miss_date
1166     , p5_a61  NUMBER := 0-1962.0724
1167     , p5_a62  NUMBER := 0-1962.0724
1168     , p5_a63  DATE := fnd_api.g_miss_date
1169     , p5_a64  NUMBER := 0-1962.0724
1170     , p5_a65  DATE := fnd_api.g_miss_date
1171     , p5_a66  NUMBER := 0-1962.0724
1172     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1173     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1174     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1175     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1176     , p5_a71  NUMBER := 0-1962.0724
1177     , p5_a72  NUMBER := 0-1962.0724
1178     , p5_a73  DATE := fnd_api.g_miss_date
1179   );
1180   procedure delete_row(p_api_version  NUMBER
1181     , p_init_msg_list  VARCHAR2
1182     , x_return_status out nocopy  VARCHAR2
1183     , x_msg_count out nocopy  NUMBER
1184     , x_msg_data out nocopy  VARCHAR2
1185     , p5_a0 JTF_NUMBER_TABLE
1186     , p5_a1 JTF_NUMBER_TABLE
1187     , p5_a2 JTF_VARCHAR2_TABLE_100
1188     , p5_a3 JTF_NUMBER_TABLE
1189     , p5_a4 JTF_VARCHAR2_TABLE_100
1190     , p5_a5 JTF_NUMBER_TABLE
1191     , p5_a6 JTF_VARCHAR2_TABLE_100
1192     , p5_a7 JTF_NUMBER_TABLE
1193     , p5_a8 JTF_NUMBER_TABLE
1194     , p5_a9 JTF_NUMBER_TABLE
1195     , p5_a10 JTF_NUMBER_TABLE
1196     , p5_a11 JTF_NUMBER_TABLE
1197     , p5_a12 JTF_NUMBER_TABLE
1198     , p5_a13 JTF_NUMBER_TABLE
1199     , p5_a14 JTF_NUMBER_TABLE
1200     , p5_a15 JTF_NUMBER_TABLE
1201     , p5_a16 JTF_NUMBER_TABLE
1202     , p5_a17 JTF_VARCHAR2_TABLE_100
1203     , p5_a18 JTF_VARCHAR2_TABLE_100
1204     , p5_a19 JTF_NUMBER_TABLE
1205     , p5_a20 JTF_NUMBER_TABLE
1206     , p5_a21 JTF_NUMBER_TABLE
1207     , p5_a22 JTF_DATE_TABLE
1208     , p5_a23 JTF_VARCHAR2_TABLE_100
1209     , p5_a24 JTF_DATE_TABLE
1210     , p5_a25 JTF_DATE_TABLE
1211     , p5_a26 JTF_VARCHAR2_TABLE_100
1212     , p5_a27 JTF_VARCHAR2_TABLE_100
1213     , p5_a28 JTF_VARCHAR2_TABLE_100
1214     , p5_a29 JTF_VARCHAR2_TABLE_100
1215     , p5_a30 JTF_VARCHAR2_TABLE_100
1216     , p5_a31 JTF_DATE_TABLE
1217     , p5_a32 JTF_VARCHAR2_TABLE_2000
1218     , p5_a33 JTF_VARCHAR2_TABLE_100
1219     , p5_a34 JTF_NUMBER_TABLE
1220     , p5_a35 JTF_DATE_TABLE
1221     , p5_a36 JTF_NUMBER_TABLE
1222     , p5_a37 JTF_VARCHAR2_TABLE_100
1223     , p5_a38 JTF_VARCHAR2_TABLE_500
1224     , p5_a39 JTF_VARCHAR2_TABLE_500
1225     , p5_a40 JTF_VARCHAR2_TABLE_500
1226     , p5_a41 JTF_VARCHAR2_TABLE_500
1227     , p5_a42 JTF_VARCHAR2_TABLE_500
1228     , p5_a43 JTF_VARCHAR2_TABLE_500
1229     , p5_a44 JTF_VARCHAR2_TABLE_500
1230     , p5_a45 JTF_VARCHAR2_TABLE_500
1231     , p5_a46 JTF_VARCHAR2_TABLE_500
1232     , p5_a47 JTF_VARCHAR2_TABLE_500
1233     , p5_a48 JTF_VARCHAR2_TABLE_500
1234     , p5_a49 JTF_VARCHAR2_TABLE_500
1235     , p5_a50 JTF_VARCHAR2_TABLE_500
1236     , p5_a51 JTF_VARCHAR2_TABLE_500
1237     , p5_a52 JTF_VARCHAR2_TABLE_500
1238     , p5_a53 JTF_DATE_TABLE
1239     , p5_a54 JTF_VARCHAR2_TABLE_100
1240     , p5_a55 JTF_NUMBER_TABLE
1241     , p5_a56 JTF_NUMBER_TABLE
1242     , p5_a57 JTF_NUMBER_TABLE
1243     , p5_a58 JTF_NUMBER_TABLE
1244     , p5_a59 JTF_NUMBER_TABLE
1245     , p5_a60 JTF_DATE_TABLE
1246     , p5_a61 JTF_NUMBER_TABLE
1247     , p5_a62 JTF_NUMBER_TABLE
1248     , p5_a63 JTF_DATE_TABLE
1249     , p5_a64 JTF_NUMBER_TABLE
1250     , p5_a65 JTF_DATE_TABLE
1251     , p5_a66 JTF_NUMBER_TABLE
1252     , p5_a67 JTF_VARCHAR2_TABLE_300
1253     , p5_a68 JTF_VARCHAR2_TABLE_100
1254     , p5_a69 JTF_VARCHAR2_TABLE_300
1255     , p5_a70 JTF_VARCHAR2_TABLE_100
1256     , p5_a71 JTF_NUMBER_TABLE
1257     , p5_a72 JTF_NUMBER_TABLE
1258     , p5_a73 JTF_DATE_TABLE
1259   );
1260   procedure validate_row(p_api_version  NUMBER
1261     , p_init_msg_list  VARCHAR2
1262     , x_return_status out nocopy  VARCHAR2
1263     , x_msg_count out nocopy  NUMBER
1264     , x_msg_data out nocopy  VARCHAR2
1265     , p5_a0  NUMBER := 0-1962.0724
1266     , p5_a1  NUMBER := 0-1962.0724
1267     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1268     , p5_a3  NUMBER := 0-1962.0724
1269     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1270     , p5_a5  NUMBER := 0-1962.0724
1271     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
1272     , p5_a7  NUMBER := 0-1962.0724
1273     , p5_a8  NUMBER := 0-1962.0724
1274     , p5_a9  NUMBER := 0-1962.0724
1275     , p5_a10  NUMBER := 0-1962.0724
1276     , p5_a11  NUMBER := 0-1962.0724
1277     , p5_a12  NUMBER := 0-1962.0724
1278     , p5_a13  NUMBER := 0-1962.0724
1279     , p5_a14  NUMBER := 0-1962.0724
1280     , p5_a15  NUMBER := 0-1962.0724
1281     , p5_a16  NUMBER := 0-1962.0724
1282     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
1283     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1284     , p5_a19  NUMBER := 0-1962.0724
1285     , p5_a20  NUMBER := 0-1962.0724
1286     , p5_a21  NUMBER := 0-1962.0724
1287     , p5_a22  DATE := fnd_api.g_miss_date
1288     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1289     , p5_a24  DATE := fnd_api.g_miss_date
1290     , p5_a25  DATE := fnd_api.g_miss_date
1291     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1292     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1293     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1294     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1295     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1296     , p5_a31  DATE := fnd_api.g_miss_date
1297     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1298     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1299     , p5_a34  NUMBER := 0-1962.0724
1300     , p5_a35  DATE := fnd_api.g_miss_date
1301     , p5_a36  NUMBER := 0-1962.0724
1302     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
1303     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1304     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
1305     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1306     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1307     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
1308     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
1309     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
1310     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
1311     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
1312     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
1313     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
1314     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
1315     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
1316     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
1317     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
1318     , p5_a53  DATE := fnd_api.g_miss_date
1319     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
1320     , p5_a55  NUMBER := 0-1962.0724
1321     , p5_a56  NUMBER := 0-1962.0724
1322     , p5_a57  NUMBER := 0-1962.0724
1323     , p5_a58  NUMBER := 0-1962.0724
1324     , p5_a59  NUMBER := 0-1962.0724
1325     , p5_a60  DATE := fnd_api.g_miss_date
1326     , p5_a61  NUMBER := 0-1962.0724
1327     , p5_a62  NUMBER := 0-1962.0724
1328     , p5_a63  DATE := fnd_api.g_miss_date
1329     , p5_a64  NUMBER := 0-1962.0724
1330     , p5_a65  DATE := fnd_api.g_miss_date
1331     , p5_a66  NUMBER := 0-1962.0724
1332     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1333     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1334     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1335     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1336     , p5_a71  NUMBER := 0-1962.0724
1337     , p5_a72  NUMBER := 0-1962.0724
1338     , p5_a73  DATE := fnd_api.g_miss_date
1339   );
1340   procedure validate_row(p_api_version  NUMBER
1341     , p_init_msg_list  VARCHAR2
1342     , x_return_status out nocopy  VARCHAR2
1343     , x_msg_count out nocopy  NUMBER
1344     , x_msg_data out nocopy  VARCHAR2
1345     , p5_a0 JTF_NUMBER_TABLE
1346     , p5_a1 JTF_NUMBER_TABLE
1347     , p5_a2 JTF_VARCHAR2_TABLE_100
1348     , p5_a3 JTF_NUMBER_TABLE
1349     , p5_a4 JTF_VARCHAR2_TABLE_100
1350     , p5_a5 JTF_NUMBER_TABLE
1351     , p5_a6 JTF_VARCHAR2_TABLE_100
1352     , p5_a7 JTF_NUMBER_TABLE
1353     , p5_a8 JTF_NUMBER_TABLE
1354     , p5_a9 JTF_NUMBER_TABLE
1355     , p5_a10 JTF_NUMBER_TABLE
1356     , p5_a11 JTF_NUMBER_TABLE
1357     , p5_a12 JTF_NUMBER_TABLE
1358     , p5_a13 JTF_NUMBER_TABLE
1359     , p5_a14 JTF_NUMBER_TABLE
1360     , p5_a15 JTF_NUMBER_TABLE
1361     , p5_a16 JTF_NUMBER_TABLE
1362     , p5_a17 JTF_VARCHAR2_TABLE_100
1363     , p5_a18 JTF_VARCHAR2_TABLE_100
1364     , p5_a19 JTF_NUMBER_TABLE
1365     , p5_a20 JTF_NUMBER_TABLE
1366     , p5_a21 JTF_NUMBER_TABLE
1367     , p5_a22 JTF_DATE_TABLE
1368     , p5_a23 JTF_VARCHAR2_TABLE_100
1369     , p5_a24 JTF_DATE_TABLE
1370     , p5_a25 JTF_DATE_TABLE
1371     , p5_a26 JTF_VARCHAR2_TABLE_100
1372     , p5_a27 JTF_VARCHAR2_TABLE_100
1373     , p5_a28 JTF_VARCHAR2_TABLE_100
1374     , p5_a29 JTF_VARCHAR2_TABLE_100
1375     , p5_a30 JTF_VARCHAR2_TABLE_100
1376     , p5_a31 JTF_DATE_TABLE
1377     , p5_a32 JTF_VARCHAR2_TABLE_2000
1378     , p5_a33 JTF_VARCHAR2_TABLE_100
1379     , p5_a34 JTF_NUMBER_TABLE
1380     , p5_a35 JTF_DATE_TABLE
1381     , p5_a36 JTF_NUMBER_TABLE
1382     , p5_a37 JTF_VARCHAR2_TABLE_100
1383     , p5_a38 JTF_VARCHAR2_TABLE_500
1384     , p5_a39 JTF_VARCHAR2_TABLE_500
1385     , p5_a40 JTF_VARCHAR2_TABLE_500
1386     , p5_a41 JTF_VARCHAR2_TABLE_500
1387     , p5_a42 JTF_VARCHAR2_TABLE_500
1388     , p5_a43 JTF_VARCHAR2_TABLE_500
1389     , p5_a44 JTF_VARCHAR2_TABLE_500
1390     , p5_a45 JTF_VARCHAR2_TABLE_500
1391     , p5_a46 JTF_VARCHAR2_TABLE_500
1392     , p5_a47 JTF_VARCHAR2_TABLE_500
1393     , p5_a48 JTF_VARCHAR2_TABLE_500
1394     , p5_a49 JTF_VARCHAR2_TABLE_500
1395     , p5_a50 JTF_VARCHAR2_TABLE_500
1396     , p5_a51 JTF_VARCHAR2_TABLE_500
1397     , p5_a52 JTF_VARCHAR2_TABLE_500
1398     , p5_a53 JTF_DATE_TABLE
1399     , p5_a54 JTF_VARCHAR2_TABLE_100
1400     , p5_a55 JTF_NUMBER_TABLE
1401     , p5_a56 JTF_NUMBER_TABLE
1402     , p5_a57 JTF_NUMBER_TABLE
1403     , p5_a58 JTF_NUMBER_TABLE
1404     , p5_a59 JTF_NUMBER_TABLE
1405     , p5_a60 JTF_DATE_TABLE
1406     , p5_a61 JTF_NUMBER_TABLE
1407     , p5_a62 JTF_NUMBER_TABLE
1408     , p5_a63 JTF_DATE_TABLE
1409     , p5_a64 JTF_NUMBER_TABLE
1410     , p5_a65 JTF_DATE_TABLE
1411     , p5_a66 JTF_NUMBER_TABLE
1412     , p5_a67 JTF_VARCHAR2_TABLE_300
1413     , p5_a68 JTF_VARCHAR2_TABLE_100
1414     , p5_a69 JTF_VARCHAR2_TABLE_300
1415     , p5_a70 JTF_VARCHAR2_TABLE_100
1416     , p5_a71 JTF_NUMBER_TABLE
1417     , p5_a72 JTF_NUMBER_TABLE
1418     , p5_a73 JTF_DATE_TABLE
1419   );
1420 end okl_tap_pvt_w;