DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CLM_PVT_W

Source


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