DBA Data[Home] [Help]

PACKAGE: APPS.OKL_LPO_PVT_W

Source


1 package okl_lpo_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLILPOS.pls 115.4 2003/11/06 01:30:27 pjgomes noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy okl_lpo_pvt.lpov_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_2000
6     , a3 JTF_VARCHAR2_TABLE_2000
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     , a10 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_NUMBER_TABLE
24     , a21 JTF_NUMBER_TABLE
25     , a22 JTF_NUMBER_TABLE
26     , a23 JTF_NUMBER_TABLE
27     , a24 JTF_NUMBER_TABLE
28     , a25 JTF_VARCHAR2_TABLE_100
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     , a36 JTF_VARCHAR2_TABLE_500
40     , a37 JTF_VARCHAR2_TABLE_500
41     , a38 JTF_VARCHAR2_TABLE_500
42     , a39 JTF_VARCHAR2_TABLE_500
43     , a40 JTF_VARCHAR2_TABLE_500
44     , a41 JTF_NUMBER_TABLE
45     , a42 JTF_DATE_TABLE
46     , a43 JTF_NUMBER_TABLE
47     , a44 JTF_DATE_TABLE
48     , a45 JTF_NUMBER_TABLE
49     , a46 JTF_VARCHAR2_TABLE_100
50     );
51   procedure rosetta_table_copy_out_p2(t okl_lpo_pvt.lpov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52     , a1 out nocopy JTF_NUMBER_TABLE
53     , a2 out nocopy JTF_VARCHAR2_TABLE_2000
54     , a3 out nocopy JTF_VARCHAR2_TABLE_2000
55     , a4 out nocopy JTF_NUMBER_TABLE
56     , a5 out nocopy JTF_NUMBER_TABLE
57     , a6 out nocopy JTF_NUMBER_TABLE
58     , a7 out nocopy JTF_VARCHAR2_TABLE_100
59     , a8 out nocopy JTF_NUMBER_TABLE
60     , a9 out nocopy JTF_VARCHAR2_TABLE_100
61     , a10 out nocopy JTF_VARCHAR2_TABLE_100
62     , a11 out nocopy JTF_NUMBER_TABLE
63     , a12 out nocopy JTF_NUMBER_TABLE
64     , a13 out nocopy JTF_NUMBER_TABLE
65     , a14 out nocopy JTF_NUMBER_TABLE
66     , a15 out nocopy JTF_NUMBER_TABLE
67     , a16 out nocopy JTF_NUMBER_TABLE
68     , a17 out nocopy JTF_VARCHAR2_TABLE_100
69     , a18 out nocopy JTF_VARCHAR2_TABLE_100
70     , a19 out nocopy JTF_NUMBER_TABLE
71     , a20 out nocopy JTF_NUMBER_TABLE
72     , a21 out nocopy JTF_NUMBER_TABLE
73     , a22 out nocopy JTF_NUMBER_TABLE
74     , a23 out nocopy JTF_NUMBER_TABLE
75     , a24 out nocopy JTF_NUMBER_TABLE
76     , a25 out nocopy JTF_VARCHAR2_TABLE_100
77     , a26 out nocopy JTF_VARCHAR2_TABLE_500
78     , a27 out nocopy JTF_VARCHAR2_TABLE_500
79     , a28 out nocopy JTF_VARCHAR2_TABLE_500
80     , a29 out nocopy JTF_VARCHAR2_TABLE_500
81     , a30 out nocopy JTF_VARCHAR2_TABLE_500
82     , a31 out nocopy JTF_VARCHAR2_TABLE_500
83     , a32 out nocopy JTF_VARCHAR2_TABLE_500
84     , a33 out nocopy JTF_VARCHAR2_TABLE_500
85     , a34 out nocopy JTF_VARCHAR2_TABLE_500
86     , a35 out nocopy JTF_VARCHAR2_TABLE_500
87     , a36 out nocopy JTF_VARCHAR2_TABLE_500
88     , a37 out nocopy JTF_VARCHAR2_TABLE_500
89     , a38 out nocopy JTF_VARCHAR2_TABLE_500
90     , a39 out nocopy JTF_VARCHAR2_TABLE_500
91     , a40 out nocopy JTF_VARCHAR2_TABLE_500
92     , a41 out nocopy JTF_NUMBER_TABLE
93     , a42 out nocopy JTF_DATE_TABLE
94     , a43 out nocopy JTF_NUMBER_TABLE
95     , a44 out nocopy JTF_DATE_TABLE
96     , a45 out nocopy JTF_NUMBER_TABLE
97     , a46 out nocopy JTF_VARCHAR2_TABLE_100
98     );
99 
100   procedure rosetta_table_copy_in_p5(t out nocopy okl_lpo_pvt.lpo_tbl_type, a0 JTF_NUMBER_TABLE
101     , a1 JTF_NUMBER_TABLE
102     , a2 JTF_NUMBER_TABLE
103     , a3 JTF_NUMBER_TABLE
104     , a4 JTF_NUMBER_TABLE
105     , a5 JTF_VARCHAR2_TABLE_100
106     , a6 JTF_NUMBER_TABLE
107     , a7 JTF_VARCHAR2_TABLE_100
108     , a8 JTF_VARCHAR2_TABLE_100
109     , a9 JTF_NUMBER_TABLE
110     , a10 JTF_NUMBER_TABLE
111     , a11 JTF_NUMBER_TABLE
112     , a12 JTF_NUMBER_TABLE
113     , a13 JTF_NUMBER_TABLE
114     , a14 JTF_NUMBER_TABLE
115     , a15 JTF_VARCHAR2_TABLE_100
116     , a16 JTF_VARCHAR2_TABLE_100
117     , a17 JTF_NUMBER_TABLE
118     , a18 JTF_NUMBER_TABLE
119     , a19 JTF_NUMBER_TABLE
120     , a20 JTF_NUMBER_TABLE
121     , a21 JTF_NUMBER_TABLE
122     , a22 JTF_NUMBER_TABLE
123     , a23 JTF_VARCHAR2_TABLE_100
124     , a24 JTF_VARCHAR2_TABLE_500
125     , a25 JTF_VARCHAR2_TABLE_500
126     , a26 JTF_VARCHAR2_TABLE_500
127     , a27 JTF_VARCHAR2_TABLE_500
128     , a28 JTF_VARCHAR2_TABLE_500
129     , a29 JTF_VARCHAR2_TABLE_500
130     , a30 JTF_VARCHAR2_TABLE_500
131     , a31 JTF_VARCHAR2_TABLE_500
132     , a32 JTF_VARCHAR2_TABLE_500
133     , a33 JTF_VARCHAR2_TABLE_500
134     , a34 JTF_VARCHAR2_TABLE_500
135     , a35 JTF_VARCHAR2_TABLE_500
136     , a36 JTF_VARCHAR2_TABLE_500
137     , a37 JTF_VARCHAR2_TABLE_500
138     , a38 JTF_VARCHAR2_TABLE_500
139     , a39 JTF_NUMBER_TABLE
140     , a40 JTF_DATE_TABLE
141     , a41 JTF_NUMBER_TABLE
142     , a42 JTF_DATE_TABLE
143     , a43 JTF_NUMBER_TABLE
144     , a44 JTF_VARCHAR2_TABLE_100
145     );
146   procedure rosetta_table_copy_out_p5(t okl_lpo_pvt.lpo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147     , a1 out nocopy JTF_NUMBER_TABLE
148     , a2 out nocopy JTF_NUMBER_TABLE
149     , a3 out nocopy JTF_NUMBER_TABLE
150     , a4 out nocopy JTF_NUMBER_TABLE
151     , a5 out nocopy JTF_VARCHAR2_TABLE_100
152     , a6 out nocopy JTF_NUMBER_TABLE
153     , a7 out nocopy JTF_VARCHAR2_TABLE_100
154     , a8 out nocopy JTF_VARCHAR2_TABLE_100
155     , a9 out nocopy JTF_NUMBER_TABLE
156     , a10 out nocopy JTF_NUMBER_TABLE
157     , a11 out nocopy JTF_NUMBER_TABLE
158     , a12 out nocopy JTF_NUMBER_TABLE
159     , a13 out nocopy JTF_NUMBER_TABLE
160     , a14 out nocopy JTF_NUMBER_TABLE
161     , a15 out nocopy JTF_VARCHAR2_TABLE_100
162     , a16 out nocopy JTF_VARCHAR2_TABLE_100
163     , a17 out nocopy JTF_NUMBER_TABLE
164     , a18 out nocopy JTF_NUMBER_TABLE
165     , a19 out nocopy JTF_NUMBER_TABLE
166     , a20 out nocopy JTF_NUMBER_TABLE
167     , a21 out nocopy JTF_NUMBER_TABLE
168     , a22 out nocopy JTF_NUMBER_TABLE
169     , a23 out nocopy JTF_VARCHAR2_TABLE_100
170     , a24 out nocopy JTF_VARCHAR2_TABLE_500
171     , a25 out nocopy JTF_VARCHAR2_TABLE_500
172     , a26 out nocopy JTF_VARCHAR2_TABLE_500
173     , a27 out nocopy JTF_VARCHAR2_TABLE_500
174     , a28 out nocopy JTF_VARCHAR2_TABLE_500
175     , a29 out nocopy JTF_VARCHAR2_TABLE_500
176     , a30 out nocopy JTF_VARCHAR2_TABLE_500
177     , a31 out nocopy JTF_VARCHAR2_TABLE_500
178     , a32 out nocopy JTF_VARCHAR2_TABLE_500
179     , a33 out nocopy JTF_VARCHAR2_TABLE_500
180     , a34 out nocopy JTF_VARCHAR2_TABLE_500
181     , a35 out nocopy JTF_VARCHAR2_TABLE_500
182     , a36 out nocopy JTF_VARCHAR2_TABLE_500
183     , a37 out nocopy JTF_VARCHAR2_TABLE_500
184     , a38 out nocopy JTF_VARCHAR2_TABLE_500
185     , a39 out nocopy JTF_NUMBER_TABLE
186     , a40 out nocopy JTF_DATE_TABLE
187     , a41 out nocopy JTF_NUMBER_TABLE
188     , a42 out nocopy JTF_DATE_TABLE
189     , a43 out nocopy JTF_NUMBER_TABLE
190     , a44 out nocopy JTF_VARCHAR2_TABLE_100
191     );
192 
193   procedure rosetta_table_copy_in_p8(t out nocopy okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 JTF_NUMBER_TABLE
194     , a1 JTF_VARCHAR2_TABLE_100
195     , a2 JTF_VARCHAR2_TABLE_100
196     , a3 JTF_VARCHAR2_TABLE_2000
197     , a4 JTF_VARCHAR2_TABLE_2000
198     , a5 JTF_NUMBER_TABLE
199     , a6 JTF_DATE_TABLE
200     , a7 JTF_NUMBER_TABLE
201     , a8 JTF_DATE_TABLE
202     , a9 JTF_NUMBER_TABLE
203     );
204   procedure rosetta_table_copy_out_p8(t okl_lpo_pvt.okl_late_policies_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
205     , a1 out nocopy JTF_VARCHAR2_TABLE_100
206     , a2 out nocopy JTF_VARCHAR2_TABLE_100
207     , a3 out nocopy JTF_VARCHAR2_TABLE_2000
208     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
209     , a5 out nocopy JTF_NUMBER_TABLE
210     , a6 out nocopy JTF_DATE_TABLE
211     , a7 out nocopy JTF_NUMBER_TABLE
212     , a8 out nocopy JTF_DATE_TABLE
213     , a9 out nocopy JTF_NUMBER_TABLE
214     );
215 
216   procedure insert_row(p_api_version  NUMBER
217     , p_init_msg_list  VARCHAR2
218     , x_return_status out nocopy  VARCHAR2
219     , x_msg_count out nocopy  NUMBER
220     , x_msg_data out nocopy  VARCHAR2
221     , p6_a0 out nocopy  NUMBER
222     , p6_a1 out nocopy  NUMBER
223     , p6_a2 out nocopy  VARCHAR2
224     , p6_a3 out nocopy  VARCHAR2
225     , p6_a4 out nocopy  NUMBER
226     , p6_a5 out nocopy  NUMBER
227     , p6_a6 out nocopy  NUMBER
228     , p6_a7 out nocopy  VARCHAR2
229     , p6_a8 out nocopy  NUMBER
230     , p6_a9 out nocopy  VARCHAR2
231     , p6_a10 out nocopy  VARCHAR2
232     , p6_a11 out nocopy  NUMBER
233     , p6_a12 out nocopy  NUMBER
234     , p6_a13 out nocopy  NUMBER
235     , p6_a14 out nocopy  NUMBER
236     , p6_a15 out nocopy  NUMBER
237     , p6_a16 out nocopy  NUMBER
238     , p6_a17 out nocopy  VARCHAR2
239     , p6_a18 out nocopy  VARCHAR2
240     , p6_a19 out nocopy  NUMBER
241     , p6_a20 out nocopy  NUMBER
242     , p6_a21 out nocopy  NUMBER
243     , p6_a22 out nocopy  NUMBER
244     , p6_a23 out nocopy  NUMBER
245     , p6_a24 out nocopy  NUMBER
246     , p6_a25 out nocopy  VARCHAR2
247     , p6_a26 out nocopy  VARCHAR2
248     , p6_a27 out nocopy  VARCHAR2
249     , p6_a28 out nocopy  VARCHAR2
250     , p6_a29 out nocopy  VARCHAR2
251     , p6_a30 out nocopy  VARCHAR2
252     , p6_a31 out nocopy  VARCHAR2
253     , p6_a32 out nocopy  VARCHAR2
254     , p6_a33 out nocopy  VARCHAR2
255     , p6_a34 out nocopy  VARCHAR2
256     , p6_a35 out nocopy  VARCHAR2
257     , p6_a36 out nocopy  VARCHAR2
258     , p6_a37 out nocopy  VARCHAR2
259     , p6_a38 out nocopy  VARCHAR2
260     , p6_a39 out nocopy  VARCHAR2
261     , p6_a40 out nocopy  VARCHAR2
262     , p6_a41 out nocopy  NUMBER
263     , p6_a42 out nocopy  DATE
264     , p6_a43 out nocopy  NUMBER
265     , p6_a44 out nocopy  DATE
266     , p6_a45 out nocopy  NUMBER
267     , p6_a46 out nocopy  VARCHAR2
268     , p5_a0  NUMBER := 0-1962.0724
269     , p5_a1  NUMBER := 0-1962.0724
270     , p5_a2  VARCHAR2 := okl_api.g_miss_char
271     , p5_a3  VARCHAR2 := okl_api.g_miss_char
272     , p5_a4  NUMBER := 0-1962.0724
273     , p5_a5  NUMBER := 0-1962.0724
274     , p5_a6  NUMBER := 0-1962.0724
275     , p5_a7  VARCHAR2 := okl_api.g_miss_char
276     , p5_a8  NUMBER := 0-1962.0724
277     , p5_a9  VARCHAR2 := okl_api.g_miss_char
278     , p5_a10  VARCHAR2 := okl_api.g_miss_char
279     , p5_a11  NUMBER := 0-1962.0724
280     , p5_a12  NUMBER := 0-1962.0724
281     , p5_a13  NUMBER := 0-1962.0724
282     , p5_a14  NUMBER := 0-1962.0724
283     , p5_a15  NUMBER := 0-1962.0724
284     , p5_a16  NUMBER := 0-1962.0724
285     , p5_a17  VARCHAR2 := okl_api.g_miss_char
286     , p5_a18  VARCHAR2 := okl_api.g_miss_char
287     , p5_a19  NUMBER := 0-1962.0724
288     , p5_a20  NUMBER := 0-1962.0724
289     , p5_a21  NUMBER := 0-1962.0724
290     , p5_a22  NUMBER := 0-1962.0724
291     , p5_a23  NUMBER := 0-1962.0724
292     , p5_a24  NUMBER := 0-1962.0724
293     , p5_a25  VARCHAR2 := okl_api.g_miss_char
294     , p5_a26  VARCHAR2 := okl_api.g_miss_char
295     , p5_a27  VARCHAR2 := okl_api.g_miss_char
296     , p5_a28  VARCHAR2 := okl_api.g_miss_char
297     , p5_a29  VARCHAR2 := okl_api.g_miss_char
298     , p5_a30  VARCHAR2 := okl_api.g_miss_char
299     , p5_a31  VARCHAR2 := okl_api.g_miss_char
300     , p5_a32  VARCHAR2 := okl_api.g_miss_char
301     , p5_a33  VARCHAR2 := okl_api.g_miss_char
302     , p5_a34  VARCHAR2 := okl_api.g_miss_char
303     , p5_a35  VARCHAR2 := okl_api.g_miss_char
304     , p5_a36  VARCHAR2 := okl_api.g_miss_char
305     , p5_a37  VARCHAR2 := okl_api.g_miss_char
306     , p5_a38  VARCHAR2 := okl_api.g_miss_char
307     , p5_a39  VARCHAR2 := okl_api.g_miss_char
308     , p5_a40  VARCHAR2 := okl_api.g_miss_char
309     , p5_a41  NUMBER := 0-1962.0724
310     , p5_a42  DATE := okl_api.g_miss_date
311     , p5_a43  NUMBER := 0-1962.0724
312     , p5_a44  DATE := okl_api.g_miss_date
313     , p5_a45  NUMBER := 0-1962.0724
314     , p5_a46  VARCHAR2 := okl_api.g_miss_char
315   );
316   procedure insert_row(p_api_version  NUMBER
317     , p_init_msg_list  VARCHAR2
318     , x_return_status out nocopy  VARCHAR2
319     , x_msg_count out nocopy  NUMBER
320     , x_msg_data out nocopy  VARCHAR2
321     , p5_a0 JTF_NUMBER_TABLE
322     , p5_a1 JTF_NUMBER_TABLE
323     , p5_a2 JTF_VARCHAR2_TABLE_2000
324     , p5_a3 JTF_VARCHAR2_TABLE_2000
325     , p5_a4 JTF_NUMBER_TABLE
326     , p5_a5 JTF_NUMBER_TABLE
327     , p5_a6 JTF_NUMBER_TABLE
328     , p5_a7 JTF_VARCHAR2_TABLE_100
329     , p5_a8 JTF_NUMBER_TABLE
330     , p5_a9 JTF_VARCHAR2_TABLE_100
331     , p5_a10 JTF_VARCHAR2_TABLE_100
332     , p5_a11 JTF_NUMBER_TABLE
333     , p5_a12 JTF_NUMBER_TABLE
334     , p5_a13 JTF_NUMBER_TABLE
335     , p5_a14 JTF_NUMBER_TABLE
336     , p5_a15 JTF_NUMBER_TABLE
337     , p5_a16 JTF_NUMBER_TABLE
338     , p5_a17 JTF_VARCHAR2_TABLE_100
339     , p5_a18 JTF_VARCHAR2_TABLE_100
340     , p5_a19 JTF_NUMBER_TABLE
341     , p5_a20 JTF_NUMBER_TABLE
342     , p5_a21 JTF_NUMBER_TABLE
343     , p5_a22 JTF_NUMBER_TABLE
344     , p5_a23 JTF_NUMBER_TABLE
345     , p5_a24 JTF_NUMBER_TABLE
346     , p5_a25 JTF_VARCHAR2_TABLE_100
347     , p5_a26 JTF_VARCHAR2_TABLE_500
348     , p5_a27 JTF_VARCHAR2_TABLE_500
349     , p5_a28 JTF_VARCHAR2_TABLE_500
350     , p5_a29 JTF_VARCHAR2_TABLE_500
351     , p5_a30 JTF_VARCHAR2_TABLE_500
352     , p5_a31 JTF_VARCHAR2_TABLE_500
353     , p5_a32 JTF_VARCHAR2_TABLE_500
354     , p5_a33 JTF_VARCHAR2_TABLE_500
355     , p5_a34 JTF_VARCHAR2_TABLE_500
356     , p5_a35 JTF_VARCHAR2_TABLE_500
357     , p5_a36 JTF_VARCHAR2_TABLE_500
358     , p5_a37 JTF_VARCHAR2_TABLE_500
359     , p5_a38 JTF_VARCHAR2_TABLE_500
360     , p5_a39 JTF_VARCHAR2_TABLE_500
361     , p5_a40 JTF_VARCHAR2_TABLE_500
362     , p5_a41 JTF_NUMBER_TABLE
363     , p5_a42 JTF_DATE_TABLE
364     , p5_a43 JTF_NUMBER_TABLE
365     , p5_a44 JTF_DATE_TABLE
366     , p5_a45 JTF_NUMBER_TABLE
367     , p5_a46 JTF_VARCHAR2_TABLE_100
368     , p6_a0 out nocopy JTF_NUMBER_TABLE
369     , p6_a1 out nocopy JTF_NUMBER_TABLE
370     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
371     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
372     , p6_a4 out nocopy JTF_NUMBER_TABLE
373     , p6_a5 out nocopy JTF_NUMBER_TABLE
374     , p6_a6 out nocopy JTF_NUMBER_TABLE
375     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
376     , p6_a8 out nocopy JTF_NUMBER_TABLE
377     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
378     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
379     , p6_a11 out nocopy JTF_NUMBER_TABLE
380     , p6_a12 out nocopy JTF_NUMBER_TABLE
381     , p6_a13 out nocopy JTF_NUMBER_TABLE
382     , p6_a14 out nocopy JTF_NUMBER_TABLE
383     , p6_a15 out nocopy JTF_NUMBER_TABLE
384     , p6_a16 out nocopy JTF_NUMBER_TABLE
385     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
386     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
387     , p6_a19 out nocopy JTF_NUMBER_TABLE
388     , p6_a20 out nocopy JTF_NUMBER_TABLE
389     , p6_a21 out nocopy JTF_NUMBER_TABLE
390     , p6_a22 out nocopy JTF_NUMBER_TABLE
391     , p6_a23 out nocopy JTF_NUMBER_TABLE
392     , p6_a24 out nocopy JTF_NUMBER_TABLE
393     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
394     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
395     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
396     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
397     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
398     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
399     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
400     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
401     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
402     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
403     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
404     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
405     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
406     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
407     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
408     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
409     , p6_a41 out nocopy JTF_NUMBER_TABLE
410     , p6_a42 out nocopy JTF_DATE_TABLE
411     , p6_a43 out nocopy JTF_NUMBER_TABLE
412     , p6_a44 out nocopy JTF_DATE_TABLE
413     , p6_a45 out nocopy JTF_NUMBER_TABLE
414     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
415   );
416   procedure lock_row(p_api_version  NUMBER
417     , p_init_msg_list  VARCHAR2
418     , x_return_status out nocopy  VARCHAR2
419     , x_msg_count out nocopy  NUMBER
420     , x_msg_data out nocopy  VARCHAR2
421     , p5_a0  NUMBER := 0-1962.0724
422     , p5_a1  NUMBER := 0-1962.0724
423     , p5_a2  VARCHAR2 := okl_api.g_miss_char
424     , p5_a3  VARCHAR2 := okl_api.g_miss_char
425     , p5_a4  NUMBER := 0-1962.0724
426     , p5_a5  NUMBER := 0-1962.0724
427     , p5_a6  NUMBER := 0-1962.0724
428     , p5_a7  VARCHAR2 := okl_api.g_miss_char
429     , p5_a8  NUMBER := 0-1962.0724
430     , p5_a9  VARCHAR2 := okl_api.g_miss_char
431     , p5_a10  VARCHAR2 := okl_api.g_miss_char
432     , p5_a11  NUMBER := 0-1962.0724
433     , p5_a12  NUMBER := 0-1962.0724
434     , p5_a13  NUMBER := 0-1962.0724
435     , p5_a14  NUMBER := 0-1962.0724
436     , p5_a15  NUMBER := 0-1962.0724
437     , p5_a16  NUMBER := 0-1962.0724
438     , p5_a17  VARCHAR2 := okl_api.g_miss_char
439     , p5_a18  VARCHAR2 := okl_api.g_miss_char
440     , p5_a19  NUMBER := 0-1962.0724
441     , p5_a20  NUMBER := 0-1962.0724
442     , p5_a21  NUMBER := 0-1962.0724
443     , p5_a22  NUMBER := 0-1962.0724
444     , p5_a23  NUMBER := 0-1962.0724
445     , p5_a24  NUMBER := 0-1962.0724
446     , p5_a25  VARCHAR2 := okl_api.g_miss_char
447     , p5_a26  VARCHAR2 := okl_api.g_miss_char
448     , p5_a27  VARCHAR2 := okl_api.g_miss_char
449     , p5_a28  VARCHAR2 := okl_api.g_miss_char
450     , p5_a29  VARCHAR2 := okl_api.g_miss_char
451     , p5_a30  VARCHAR2 := okl_api.g_miss_char
452     , p5_a31  VARCHAR2 := okl_api.g_miss_char
453     , p5_a32  VARCHAR2 := okl_api.g_miss_char
454     , p5_a33  VARCHAR2 := okl_api.g_miss_char
455     , p5_a34  VARCHAR2 := okl_api.g_miss_char
456     , p5_a35  VARCHAR2 := okl_api.g_miss_char
457     , p5_a36  VARCHAR2 := okl_api.g_miss_char
458     , p5_a37  VARCHAR2 := okl_api.g_miss_char
459     , p5_a38  VARCHAR2 := okl_api.g_miss_char
460     , p5_a39  VARCHAR2 := okl_api.g_miss_char
461     , p5_a40  VARCHAR2 := okl_api.g_miss_char
462     , p5_a41  NUMBER := 0-1962.0724
463     , p5_a42  DATE := okl_api.g_miss_date
464     , p5_a43  NUMBER := 0-1962.0724
465     , p5_a44  DATE := okl_api.g_miss_date
466     , p5_a45  NUMBER := 0-1962.0724
467     , p5_a46  VARCHAR2 := okl_api.g_miss_char
468   );
469   procedure lock_row(p_api_version  NUMBER
470     , p_init_msg_list  VARCHAR2
471     , x_return_status out nocopy  VARCHAR2
472     , x_msg_count out nocopy  NUMBER
473     , x_msg_data out nocopy  VARCHAR2
474     , p5_a0 JTF_NUMBER_TABLE
475     , p5_a1 JTF_NUMBER_TABLE
476     , p5_a2 JTF_VARCHAR2_TABLE_2000
477     , p5_a3 JTF_VARCHAR2_TABLE_2000
478     , p5_a4 JTF_NUMBER_TABLE
479     , p5_a5 JTF_NUMBER_TABLE
480     , p5_a6 JTF_NUMBER_TABLE
481     , p5_a7 JTF_VARCHAR2_TABLE_100
482     , p5_a8 JTF_NUMBER_TABLE
483     , p5_a9 JTF_VARCHAR2_TABLE_100
484     , p5_a10 JTF_VARCHAR2_TABLE_100
485     , p5_a11 JTF_NUMBER_TABLE
486     , p5_a12 JTF_NUMBER_TABLE
487     , p5_a13 JTF_NUMBER_TABLE
488     , p5_a14 JTF_NUMBER_TABLE
489     , p5_a15 JTF_NUMBER_TABLE
490     , p5_a16 JTF_NUMBER_TABLE
491     , p5_a17 JTF_VARCHAR2_TABLE_100
492     , p5_a18 JTF_VARCHAR2_TABLE_100
493     , p5_a19 JTF_NUMBER_TABLE
494     , p5_a20 JTF_NUMBER_TABLE
495     , p5_a21 JTF_NUMBER_TABLE
496     , p5_a22 JTF_NUMBER_TABLE
497     , p5_a23 JTF_NUMBER_TABLE
498     , p5_a24 JTF_NUMBER_TABLE
499     , p5_a25 JTF_VARCHAR2_TABLE_100
500     , p5_a26 JTF_VARCHAR2_TABLE_500
501     , p5_a27 JTF_VARCHAR2_TABLE_500
502     , p5_a28 JTF_VARCHAR2_TABLE_500
503     , p5_a29 JTF_VARCHAR2_TABLE_500
504     , p5_a30 JTF_VARCHAR2_TABLE_500
505     , p5_a31 JTF_VARCHAR2_TABLE_500
506     , p5_a32 JTF_VARCHAR2_TABLE_500
507     , p5_a33 JTF_VARCHAR2_TABLE_500
508     , p5_a34 JTF_VARCHAR2_TABLE_500
509     , p5_a35 JTF_VARCHAR2_TABLE_500
510     , p5_a36 JTF_VARCHAR2_TABLE_500
511     , p5_a37 JTF_VARCHAR2_TABLE_500
512     , p5_a38 JTF_VARCHAR2_TABLE_500
513     , p5_a39 JTF_VARCHAR2_TABLE_500
514     , p5_a40 JTF_VARCHAR2_TABLE_500
515     , p5_a41 JTF_NUMBER_TABLE
516     , p5_a42 JTF_DATE_TABLE
517     , p5_a43 JTF_NUMBER_TABLE
518     , p5_a44 JTF_DATE_TABLE
519     , p5_a45 JTF_NUMBER_TABLE
520     , p5_a46 JTF_VARCHAR2_TABLE_100
521   );
522   procedure update_row(p_api_version  NUMBER
523     , p_init_msg_list  VARCHAR2
524     , x_return_status out nocopy  VARCHAR2
525     , x_msg_count out nocopy  NUMBER
526     , x_msg_data out nocopy  VARCHAR2
527     , p6_a0 out nocopy  NUMBER
528     , p6_a1 out nocopy  NUMBER
529     , p6_a2 out nocopy  VARCHAR2
530     , p6_a3 out nocopy  VARCHAR2
531     , p6_a4 out nocopy  NUMBER
532     , p6_a5 out nocopy  NUMBER
533     , p6_a6 out nocopy  NUMBER
534     , p6_a7 out nocopy  VARCHAR2
535     , p6_a8 out nocopy  NUMBER
536     , p6_a9 out nocopy  VARCHAR2
537     , p6_a10 out nocopy  VARCHAR2
538     , p6_a11 out nocopy  NUMBER
539     , p6_a12 out nocopy  NUMBER
540     , p6_a13 out nocopy  NUMBER
541     , p6_a14 out nocopy  NUMBER
542     , p6_a15 out nocopy  NUMBER
543     , p6_a16 out nocopy  NUMBER
544     , p6_a17 out nocopy  VARCHAR2
545     , p6_a18 out nocopy  VARCHAR2
546     , p6_a19 out nocopy  NUMBER
547     , p6_a20 out nocopy  NUMBER
548     , p6_a21 out nocopy  NUMBER
549     , p6_a22 out nocopy  NUMBER
550     , p6_a23 out nocopy  NUMBER
551     , p6_a24 out nocopy  NUMBER
552     , p6_a25 out nocopy  VARCHAR2
553     , p6_a26 out nocopy  VARCHAR2
554     , p6_a27 out nocopy  VARCHAR2
555     , p6_a28 out nocopy  VARCHAR2
556     , p6_a29 out nocopy  VARCHAR2
557     , p6_a30 out nocopy  VARCHAR2
558     , p6_a31 out nocopy  VARCHAR2
559     , p6_a32 out nocopy  VARCHAR2
560     , p6_a33 out nocopy  VARCHAR2
561     , p6_a34 out nocopy  VARCHAR2
562     , p6_a35 out nocopy  VARCHAR2
563     , p6_a36 out nocopy  VARCHAR2
564     , p6_a37 out nocopy  VARCHAR2
565     , p6_a38 out nocopy  VARCHAR2
566     , p6_a39 out nocopy  VARCHAR2
567     , p6_a40 out nocopy  VARCHAR2
568     , p6_a41 out nocopy  NUMBER
569     , p6_a42 out nocopy  DATE
570     , p6_a43 out nocopy  NUMBER
571     , p6_a44 out nocopy  DATE
572     , p6_a45 out nocopy  NUMBER
573     , p6_a46 out nocopy  VARCHAR2
574     , p5_a0  NUMBER := 0-1962.0724
575     , p5_a1  NUMBER := 0-1962.0724
576     , p5_a2  VARCHAR2 := okl_api.g_miss_char
577     , p5_a3  VARCHAR2 := okl_api.g_miss_char
578     , p5_a4  NUMBER := 0-1962.0724
579     , p5_a5  NUMBER := 0-1962.0724
580     , p5_a6  NUMBER := 0-1962.0724
581     , p5_a7  VARCHAR2 := okl_api.g_miss_char
582     , p5_a8  NUMBER := 0-1962.0724
583     , p5_a9  VARCHAR2 := okl_api.g_miss_char
584     , p5_a10  VARCHAR2 := okl_api.g_miss_char
585     , p5_a11  NUMBER := 0-1962.0724
586     , p5_a12  NUMBER := 0-1962.0724
587     , p5_a13  NUMBER := 0-1962.0724
588     , p5_a14  NUMBER := 0-1962.0724
589     , p5_a15  NUMBER := 0-1962.0724
590     , p5_a16  NUMBER := 0-1962.0724
591     , p5_a17  VARCHAR2 := okl_api.g_miss_char
592     , p5_a18  VARCHAR2 := okl_api.g_miss_char
593     , p5_a19  NUMBER := 0-1962.0724
594     , p5_a20  NUMBER := 0-1962.0724
595     , p5_a21  NUMBER := 0-1962.0724
596     , p5_a22  NUMBER := 0-1962.0724
597     , p5_a23  NUMBER := 0-1962.0724
598     , p5_a24  NUMBER := 0-1962.0724
599     , p5_a25  VARCHAR2 := okl_api.g_miss_char
600     , p5_a26  VARCHAR2 := okl_api.g_miss_char
601     , p5_a27  VARCHAR2 := okl_api.g_miss_char
602     , p5_a28  VARCHAR2 := okl_api.g_miss_char
603     , p5_a29  VARCHAR2 := okl_api.g_miss_char
604     , p5_a30  VARCHAR2 := okl_api.g_miss_char
605     , p5_a31  VARCHAR2 := okl_api.g_miss_char
606     , p5_a32  VARCHAR2 := okl_api.g_miss_char
607     , p5_a33  VARCHAR2 := okl_api.g_miss_char
608     , p5_a34  VARCHAR2 := okl_api.g_miss_char
609     , p5_a35  VARCHAR2 := okl_api.g_miss_char
610     , p5_a36  VARCHAR2 := okl_api.g_miss_char
611     , p5_a37  VARCHAR2 := okl_api.g_miss_char
612     , p5_a38  VARCHAR2 := okl_api.g_miss_char
613     , p5_a39  VARCHAR2 := okl_api.g_miss_char
614     , p5_a40  VARCHAR2 := okl_api.g_miss_char
615     , p5_a41  NUMBER := 0-1962.0724
616     , p5_a42  DATE := okl_api.g_miss_date
617     , p5_a43  NUMBER := 0-1962.0724
618     , p5_a44  DATE := okl_api.g_miss_date
619     , p5_a45  NUMBER := 0-1962.0724
620     , p5_a46  VARCHAR2 := okl_api.g_miss_char
621   );
622   procedure update_row(p_api_version  NUMBER
623     , p_init_msg_list  VARCHAR2
624     , x_return_status out nocopy  VARCHAR2
625     , x_msg_count out nocopy  NUMBER
626     , x_msg_data out nocopy  VARCHAR2
627     , p5_a0 JTF_NUMBER_TABLE
628     , p5_a1 JTF_NUMBER_TABLE
629     , p5_a2 JTF_VARCHAR2_TABLE_2000
630     , p5_a3 JTF_VARCHAR2_TABLE_2000
631     , p5_a4 JTF_NUMBER_TABLE
632     , p5_a5 JTF_NUMBER_TABLE
633     , p5_a6 JTF_NUMBER_TABLE
634     , p5_a7 JTF_VARCHAR2_TABLE_100
635     , p5_a8 JTF_NUMBER_TABLE
636     , p5_a9 JTF_VARCHAR2_TABLE_100
637     , p5_a10 JTF_VARCHAR2_TABLE_100
638     , p5_a11 JTF_NUMBER_TABLE
639     , p5_a12 JTF_NUMBER_TABLE
640     , p5_a13 JTF_NUMBER_TABLE
641     , p5_a14 JTF_NUMBER_TABLE
642     , p5_a15 JTF_NUMBER_TABLE
643     , p5_a16 JTF_NUMBER_TABLE
644     , p5_a17 JTF_VARCHAR2_TABLE_100
645     , p5_a18 JTF_VARCHAR2_TABLE_100
646     , p5_a19 JTF_NUMBER_TABLE
647     , p5_a20 JTF_NUMBER_TABLE
648     , p5_a21 JTF_NUMBER_TABLE
649     , p5_a22 JTF_NUMBER_TABLE
650     , p5_a23 JTF_NUMBER_TABLE
651     , p5_a24 JTF_NUMBER_TABLE
652     , p5_a25 JTF_VARCHAR2_TABLE_100
653     , p5_a26 JTF_VARCHAR2_TABLE_500
654     , p5_a27 JTF_VARCHAR2_TABLE_500
655     , p5_a28 JTF_VARCHAR2_TABLE_500
656     , p5_a29 JTF_VARCHAR2_TABLE_500
657     , p5_a30 JTF_VARCHAR2_TABLE_500
658     , p5_a31 JTF_VARCHAR2_TABLE_500
659     , p5_a32 JTF_VARCHAR2_TABLE_500
660     , p5_a33 JTF_VARCHAR2_TABLE_500
661     , p5_a34 JTF_VARCHAR2_TABLE_500
662     , p5_a35 JTF_VARCHAR2_TABLE_500
663     , p5_a36 JTF_VARCHAR2_TABLE_500
664     , p5_a37 JTF_VARCHAR2_TABLE_500
665     , p5_a38 JTF_VARCHAR2_TABLE_500
666     , p5_a39 JTF_VARCHAR2_TABLE_500
667     , p5_a40 JTF_VARCHAR2_TABLE_500
668     , p5_a41 JTF_NUMBER_TABLE
669     , p5_a42 JTF_DATE_TABLE
670     , p5_a43 JTF_NUMBER_TABLE
671     , p5_a44 JTF_DATE_TABLE
672     , p5_a45 JTF_NUMBER_TABLE
673     , p5_a46 JTF_VARCHAR2_TABLE_100
674     , p6_a0 out nocopy JTF_NUMBER_TABLE
675     , p6_a1 out nocopy JTF_NUMBER_TABLE
676     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
677     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
678     , p6_a4 out nocopy JTF_NUMBER_TABLE
679     , p6_a5 out nocopy JTF_NUMBER_TABLE
680     , p6_a6 out nocopy JTF_NUMBER_TABLE
681     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
682     , p6_a8 out nocopy JTF_NUMBER_TABLE
683     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
684     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
685     , p6_a11 out nocopy JTF_NUMBER_TABLE
686     , p6_a12 out nocopy JTF_NUMBER_TABLE
687     , p6_a13 out nocopy JTF_NUMBER_TABLE
688     , p6_a14 out nocopy JTF_NUMBER_TABLE
689     , p6_a15 out nocopy JTF_NUMBER_TABLE
690     , p6_a16 out nocopy JTF_NUMBER_TABLE
691     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
692     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
693     , p6_a19 out nocopy JTF_NUMBER_TABLE
694     , p6_a20 out nocopy JTF_NUMBER_TABLE
695     , p6_a21 out nocopy JTF_NUMBER_TABLE
696     , p6_a22 out nocopy JTF_NUMBER_TABLE
697     , p6_a23 out nocopy JTF_NUMBER_TABLE
698     , p6_a24 out nocopy JTF_NUMBER_TABLE
699     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
700     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
701     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
702     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
703     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
704     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
705     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
706     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
707     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
708     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
709     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
710     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
711     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
712     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
713     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
714     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
715     , p6_a41 out nocopy JTF_NUMBER_TABLE
716     , p6_a42 out nocopy JTF_DATE_TABLE
717     , p6_a43 out nocopy JTF_NUMBER_TABLE
718     , p6_a44 out nocopy JTF_DATE_TABLE
719     , p6_a45 out nocopy JTF_NUMBER_TABLE
720     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
721   );
722   procedure delete_row(p_api_version  NUMBER
723     , p_init_msg_list  VARCHAR2
724     , x_return_status out nocopy  VARCHAR2
725     , x_msg_count out nocopy  NUMBER
726     , x_msg_data out nocopy  VARCHAR2
727     , p5_a0  NUMBER := 0-1962.0724
728     , p5_a1  NUMBER := 0-1962.0724
729     , p5_a2  VARCHAR2 := okl_api.g_miss_char
730     , p5_a3  VARCHAR2 := okl_api.g_miss_char
731     , p5_a4  NUMBER := 0-1962.0724
732     , p5_a5  NUMBER := 0-1962.0724
733     , p5_a6  NUMBER := 0-1962.0724
734     , p5_a7  VARCHAR2 := okl_api.g_miss_char
735     , p5_a8  NUMBER := 0-1962.0724
736     , p5_a9  VARCHAR2 := okl_api.g_miss_char
737     , p5_a10  VARCHAR2 := okl_api.g_miss_char
738     , p5_a11  NUMBER := 0-1962.0724
739     , p5_a12  NUMBER := 0-1962.0724
740     , p5_a13  NUMBER := 0-1962.0724
741     , p5_a14  NUMBER := 0-1962.0724
742     , p5_a15  NUMBER := 0-1962.0724
743     , p5_a16  NUMBER := 0-1962.0724
744     , p5_a17  VARCHAR2 := okl_api.g_miss_char
745     , p5_a18  VARCHAR2 := okl_api.g_miss_char
746     , p5_a19  NUMBER := 0-1962.0724
747     , p5_a20  NUMBER := 0-1962.0724
748     , p5_a21  NUMBER := 0-1962.0724
749     , p5_a22  NUMBER := 0-1962.0724
750     , p5_a23  NUMBER := 0-1962.0724
751     , p5_a24  NUMBER := 0-1962.0724
752     , p5_a25  VARCHAR2 := okl_api.g_miss_char
753     , p5_a26  VARCHAR2 := okl_api.g_miss_char
754     , p5_a27  VARCHAR2 := okl_api.g_miss_char
755     , p5_a28  VARCHAR2 := okl_api.g_miss_char
756     , p5_a29  VARCHAR2 := okl_api.g_miss_char
757     , p5_a30  VARCHAR2 := okl_api.g_miss_char
758     , p5_a31  VARCHAR2 := okl_api.g_miss_char
759     , p5_a32  VARCHAR2 := okl_api.g_miss_char
760     , p5_a33  VARCHAR2 := okl_api.g_miss_char
761     , p5_a34  VARCHAR2 := okl_api.g_miss_char
762     , p5_a35  VARCHAR2 := okl_api.g_miss_char
763     , p5_a36  VARCHAR2 := okl_api.g_miss_char
764     , p5_a37  VARCHAR2 := okl_api.g_miss_char
765     , p5_a38  VARCHAR2 := okl_api.g_miss_char
766     , p5_a39  VARCHAR2 := okl_api.g_miss_char
767     , p5_a40  VARCHAR2 := okl_api.g_miss_char
768     , p5_a41  NUMBER := 0-1962.0724
769     , p5_a42  DATE := okl_api.g_miss_date
770     , p5_a43  NUMBER := 0-1962.0724
771     , p5_a44  DATE := okl_api.g_miss_date
772     , p5_a45  NUMBER := 0-1962.0724
773     , p5_a46  VARCHAR2 := okl_api.g_miss_char
774   );
775   procedure delete_row(p_api_version  NUMBER
776     , p_init_msg_list  VARCHAR2
777     , x_return_status out nocopy  VARCHAR2
778     , x_msg_count out nocopy  NUMBER
779     , x_msg_data out nocopy  VARCHAR2
780     , p5_a0 JTF_NUMBER_TABLE
781     , p5_a1 JTF_NUMBER_TABLE
782     , p5_a2 JTF_VARCHAR2_TABLE_2000
783     , p5_a3 JTF_VARCHAR2_TABLE_2000
784     , p5_a4 JTF_NUMBER_TABLE
785     , p5_a5 JTF_NUMBER_TABLE
786     , p5_a6 JTF_NUMBER_TABLE
787     , p5_a7 JTF_VARCHAR2_TABLE_100
788     , p5_a8 JTF_NUMBER_TABLE
789     , p5_a9 JTF_VARCHAR2_TABLE_100
790     , p5_a10 JTF_VARCHAR2_TABLE_100
791     , p5_a11 JTF_NUMBER_TABLE
792     , p5_a12 JTF_NUMBER_TABLE
793     , p5_a13 JTF_NUMBER_TABLE
794     , p5_a14 JTF_NUMBER_TABLE
795     , p5_a15 JTF_NUMBER_TABLE
796     , p5_a16 JTF_NUMBER_TABLE
797     , p5_a17 JTF_VARCHAR2_TABLE_100
798     , p5_a18 JTF_VARCHAR2_TABLE_100
799     , p5_a19 JTF_NUMBER_TABLE
800     , p5_a20 JTF_NUMBER_TABLE
801     , p5_a21 JTF_NUMBER_TABLE
802     , p5_a22 JTF_NUMBER_TABLE
803     , p5_a23 JTF_NUMBER_TABLE
804     , p5_a24 JTF_NUMBER_TABLE
805     , p5_a25 JTF_VARCHAR2_TABLE_100
806     , p5_a26 JTF_VARCHAR2_TABLE_500
807     , p5_a27 JTF_VARCHAR2_TABLE_500
808     , p5_a28 JTF_VARCHAR2_TABLE_500
809     , p5_a29 JTF_VARCHAR2_TABLE_500
810     , p5_a30 JTF_VARCHAR2_TABLE_500
811     , p5_a31 JTF_VARCHAR2_TABLE_500
812     , p5_a32 JTF_VARCHAR2_TABLE_500
813     , p5_a33 JTF_VARCHAR2_TABLE_500
814     , p5_a34 JTF_VARCHAR2_TABLE_500
815     , p5_a35 JTF_VARCHAR2_TABLE_500
816     , p5_a36 JTF_VARCHAR2_TABLE_500
817     , p5_a37 JTF_VARCHAR2_TABLE_500
818     , p5_a38 JTF_VARCHAR2_TABLE_500
819     , p5_a39 JTF_VARCHAR2_TABLE_500
820     , p5_a40 JTF_VARCHAR2_TABLE_500
821     , p5_a41 JTF_NUMBER_TABLE
822     , p5_a42 JTF_DATE_TABLE
823     , p5_a43 JTF_NUMBER_TABLE
824     , p5_a44 JTF_DATE_TABLE
825     , p5_a45 JTF_NUMBER_TABLE
826     , p5_a46 JTF_VARCHAR2_TABLE_100
827   );
828   procedure validate_row(p_api_version  NUMBER
829     , p_init_msg_list  VARCHAR2
830     , x_return_status out nocopy  VARCHAR2
831     , x_msg_count out nocopy  NUMBER
832     , x_msg_data out nocopy  VARCHAR2
833     , p5_a0  NUMBER := 0-1962.0724
834     , p5_a1  NUMBER := 0-1962.0724
835     , p5_a2  VARCHAR2 := okl_api.g_miss_char
836     , p5_a3  VARCHAR2 := okl_api.g_miss_char
837     , p5_a4  NUMBER := 0-1962.0724
838     , p5_a5  NUMBER := 0-1962.0724
839     , p5_a6  NUMBER := 0-1962.0724
840     , p5_a7  VARCHAR2 := okl_api.g_miss_char
841     , p5_a8  NUMBER := 0-1962.0724
842     , p5_a9  VARCHAR2 := okl_api.g_miss_char
843     , p5_a10  VARCHAR2 := okl_api.g_miss_char
844     , p5_a11  NUMBER := 0-1962.0724
845     , p5_a12  NUMBER := 0-1962.0724
846     , p5_a13  NUMBER := 0-1962.0724
847     , p5_a14  NUMBER := 0-1962.0724
848     , p5_a15  NUMBER := 0-1962.0724
849     , p5_a16  NUMBER := 0-1962.0724
850     , p5_a17  VARCHAR2 := okl_api.g_miss_char
851     , p5_a18  VARCHAR2 := okl_api.g_miss_char
852     , p5_a19  NUMBER := 0-1962.0724
853     , p5_a20  NUMBER := 0-1962.0724
854     , p5_a21  NUMBER := 0-1962.0724
855     , p5_a22  NUMBER := 0-1962.0724
856     , p5_a23  NUMBER := 0-1962.0724
857     , p5_a24  NUMBER := 0-1962.0724
858     , p5_a25  VARCHAR2 := okl_api.g_miss_char
859     , p5_a26  VARCHAR2 := okl_api.g_miss_char
860     , p5_a27  VARCHAR2 := okl_api.g_miss_char
861     , p5_a28  VARCHAR2 := okl_api.g_miss_char
862     , p5_a29  VARCHAR2 := okl_api.g_miss_char
863     , p5_a30  VARCHAR2 := okl_api.g_miss_char
864     , p5_a31  VARCHAR2 := okl_api.g_miss_char
865     , p5_a32  VARCHAR2 := okl_api.g_miss_char
866     , p5_a33  VARCHAR2 := okl_api.g_miss_char
867     , p5_a34  VARCHAR2 := okl_api.g_miss_char
868     , p5_a35  VARCHAR2 := okl_api.g_miss_char
869     , p5_a36  VARCHAR2 := okl_api.g_miss_char
870     , p5_a37  VARCHAR2 := okl_api.g_miss_char
871     , p5_a38  VARCHAR2 := okl_api.g_miss_char
872     , p5_a39  VARCHAR2 := okl_api.g_miss_char
873     , p5_a40  VARCHAR2 := okl_api.g_miss_char
874     , p5_a41  NUMBER := 0-1962.0724
875     , p5_a42  DATE := okl_api.g_miss_date
876     , p5_a43  NUMBER := 0-1962.0724
877     , p5_a44  DATE := okl_api.g_miss_date
878     , p5_a45  NUMBER := 0-1962.0724
879     , p5_a46  VARCHAR2 := okl_api.g_miss_char
880   );
881   procedure validate_row(p_api_version  NUMBER
882     , p_init_msg_list  VARCHAR2
883     , x_return_status out nocopy  VARCHAR2
884     , x_msg_count out nocopy  NUMBER
885     , x_msg_data out nocopy  VARCHAR2
886     , p5_a0 JTF_NUMBER_TABLE
887     , p5_a1 JTF_NUMBER_TABLE
888     , p5_a2 JTF_VARCHAR2_TABLE_2000
889     , p5_a3 JTF_VARCHAR2_TABLE_2000
890     , p5_a4 JTF_NUMBER_TABLE
891     , p5_a5 JTF_NUMBER_TABLE
892     , p5_a6 JTF_NUMBER_TABLE
893     , p5_a7 JTF_VARCHAR2_TABLE_100
894     , p5_a8 JTF_NUMBER_TABLE
895     , p5_a9 JTF_VARCHAR2_TABLE_100
896     , p5_a10 JTF_VARCHAR2_TABLE_100
897     , p5_a11 JTF_NUMBER_TABLE
898     , p5_a12 JTF_NUMBER_TABLE
899     , p5_a13 JTF_NUMBER_TABLE
900     , p5_a14 JTF_NUMBER_TABLE
901     , p5_a15 JTF_NUMBER_TABLE
902     , p5_a16 JTF_NUMBER_TABLE
903     , p5_a17 JTF_VARCHAR2_TABLE_100
904     , p5_a18 JTF_VARCHAR2_TABLE_100
905     , p5_a19 JTF_NUMBER_TABLE
906     , p5_a20 JTF_NUMBER_TABLE
907     , p5_a21 JTF_NUMBER_TABLE
908     , p5_a22 JTF_NUMBER_TABLE
909     , p5_a23 JTF_NUMBER_TABLE
910     , p5_a24 JTF_NUMBER_TABLE
911     , p5_a25 JTF_VARCHAR2_TABLE_100
912     , p5_a26 JTF_VARCHAR2_TABLE_500
913     , p5_a27 JTF_VARCHAR2_TABLE_500
914     , p5_a28 JTF_VARCHAR2_TABLE_500
915     , p5_a29 JTF_VARCHAR2_TABLE_500
916     , p5_a30 JTF_VARCHAR2_TABLE_500
917     , p5_a31 JTF_VARCHAR2_TABLE_500
918     , p5_a32 JTF_VARCHAR2_TABLE_500
919     , p5_a33 JTF_VARCHAR2_TABLE_500
920     , p5_a34 JTF_VARCHAR2_TABLE_500
921     , p5_a35 JTF_VARCHAR2_TABLE_500
922     , p5_a36 JTF_VARCHAR2_TABLE_500
923     , p5_a37 JTF_VARCHAR2_TABLE_500
924     , p5_a38 JTF_VARCHAR2_TABLE_500
925     , p5_a39 JTF_VARCHAR2_TABLE_500
926     , p5_a40 JTF_VARCHAR2_TABLE_500
927     , p5_a41 JTF_NUMBER_TABLE
928     , p5_a42 JTF_DATE_TABLE
929     , p5_a43 JTF_NUMBER_TABLE
930     , p5_a44 JTF_DATE_TABLE
931     , p5_a45 JTF_NUMBER_TABLE
932     , p5_a46 JTF_VARCHAR2_TABLE_100
933   );
934 end okl_lpo_pvt_w;