DBA Data[Home] [Help]

PACKAGE: APPS.OKL_TQL_PVT_W

Source


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