DBA Data[Home] [Help]

PACKAGE: APPS.CSI_JAVA_INTERFACE_PKG_W

Source


1 package csi_java_interface_pkg_w as
2   /* $Header: csivjiws.pls 120.19 2008/01/15 03:32:34 devijay ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy csi_java_interface_pkg.csi_output_tbl_ib, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_200
5     , a2 JTF_VARCHAR2_TABLE_200
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_300
9     , a6 JTF_VARCHAR2_TABLE_300
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_200
12     , a9 JTF_VARCHAR2_TABLE_2000
13     , a10 JTF_DATE_TABLE
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_DATE_TABLE
18     , a15 JTF_DATE_TABLE
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_2000
21     , a18 JTF_DATE_TABLE
22     );
23   procedure rosetta_table_copy_out_p1(t csi_java_interface_pkg.csi_output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
24     , a1 out nocopy JTF_VARCHAR2_TABLE_200
25     , a2 out nocopy JTF_VARCHAR2_TABLE_200
26     , a3 out nocopy JTF_VARCHAR2_TABLE_100
27     , a4 out nocopy JTF_NUMBER_TABLE
28     , a5 out nocopy JTF_VARCHAR2_TABLE_300
29     , a6 out nocopy JTF_VARCHAR2_TABLE_300
30     , a7 out nocopy JTF_NUMBER_TABLE
31     , a8 out nocopy JTF_VARCHAR2_TABLE_200
32     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
33     , a10 out nocopy JTF_DATE_TABLE
34     , a11 out nocopy JTF_DATE_TABLE
35     , a12 out nocopy JTF_VARCHAR2_TABLE_100
36     , a13 out nocopy JTF_VARCHAR2_TABLE_100
37     , a14 out nocopy JTF_DATE_TABLE
38     , a15 out nocopy JTF_DATE_TABLE
39     , a16 out nocopy JTF_VARCHAR2_TABLE_100
40     , a17 out nocopy JTF_VARCHAR2_TABLE_2000
41     , a18 out nocopy JTF_DATE_TABLE
42     );
43 
44   procedure rosetta_table_copy_in_p3(t out nocopy csi_java_interface_pkg.csi_coverage_tbl_ib, a0 JTF_VARCHAR2_TABLE_100
45     , a1 JTF_NUMBER_TABLE
46     );
47   procedure rosetta_table_copy_out_p3(t csi_java_interface_pkg.csi_coverage_tbl_ib, a0 out nocopy JTF_VARCHAR2_TABLE_100
48     , a1 out nocopy JTF_NUMBER_TABLE
49     );
50 
51   procedure rosetta_table_copy_in_p5(t out nocopy csi_java_interface_pkg.dpl_instance_tbl, a0 JTF_NUMBER_TABLE
52     );
53   procedure rosetta_table_copy_out_p5(t csi_java_interface_pkg.dpl_instance_tbl, a0 out nocopy JTF_NUMBER_TABLE
54     );
55 
56   procedure create_item_instance(p_api_version  NUMBER
57     , p_commit  VARCHAR2
58     , p_init_msg_list  VARCHAR2
59     , p_validation_level  NUMBER
60     , p4_a0 in out nocopy  NUMBER
61     , p4_a1 in out nocopy  VARCHAR2
62     , p4_a2 in out nocopy  VARCHAR2
63     , p4_a3 in out nocopy  NUMBER
64     , p4_a4 in out nocopy  NUMBER
65     , p4_a5 in out nocopy  VARCHAR2
66     , p4_a6 in out nocopy  NUMBER
67     , p4_a7 in out nocopy  VARCHAR2
68     , p4_a8 in out nocopy  VARCHAR2
69     , p4_a9 in out nocopy  VARCHAR2
70     , p4_a10 in out nocopy  NUMBER
71     , p4_a11 in out nocopy  VARCHAR2
72     , p4_a12 in out nocopy  VARCHAR2
73     , p4_a13 in out nocopy  NUMBER
74     , p4_a14 in out nocopy  NUMBER
75     , p4_a15 in out nocopy  VARCHAR2
76     , p4_a16 in out nocopy  VARCHAR2
77     , p4_a17 in out nocopy  VARCHAR2
78     , p4_a18 in out nocopy  NUMBER
79     , p4_a19 in out nocopy  VARCHAR2
80     , p4_a20 in out nocopy  DATE
81     , p4_a21 in out nocopy  DATE
82     , p4_a22 in out nocopy  VARCHAR2
83     , p4_a23 in out nocopy  NUMBER
84     , p4_a24 in out nocopy  NUMBER
85     , p4_a25 in out nocopy  VARCHAR2
86     , p4_a26 in out nocopy  NUMBER
87     , p4_a27 in out nocopy  NUMBER
88     , p4_a28 in out nocopy  NUMBER
89     , p4_a29 in out nocopy  NUMBER
90     , p4_a30 in out nocopy  NUMBER
91     , p4_a31 in out nocopy  NUMBER
92     , p4_a32 in out nocopy  NUMBER
93     , p4_a33 in out nocopy  NUMBER
94     , p4_a34 in out nocopy  NUMBER
95     , p4_a35 in out nocopy  VARCHAR2
96     , p4_a36 in out nocopy  NUMBER
97     , p4_a37 in out nocopy  NUMBER
98     , p4_a38 in out nocopy  NUMBER
99     , p4_a39 in out nocopy  NUMBER
100     , p4_a40 in out nocopy  DATE
101     , p4_a41 in out nocopy  VARCHAR2
102     , p4_a42 in out nocopy  DATE
103     , p4_a43 in out nocopy  DATE
104     , p4_a44 in out nocopy  VARCHAR2
105     , p4_a45 in out nocopy  VARCHAR2
106     , p4_a46 in out nocopy  VARCHAR2
107     , p4_a47 in out nocopy  VARCHAR2
108     , p4_a48 in out nocopy  VARCHAR2
109     , p4_a49 in out nocopy  VARCHAR2
110     , p4_a50 in out nocopy  VARCHAR2
111     , p4_a51 in out nocopy  VARCHAR2
112     , p4_a52 in out nocopy  VARCHAR2
113     , p4_a53 in out nocopy  VARCHAR2
114     , p4_a54 in out nocopy  VARCHAR2
115     , p4_a55 in out nocopy  VARCHAR2
116     , p4_a56 in out nocopy  VARCHAR2
117     , p4_a57 in out nocopy  VARCHAR2
118     , p4_a58 in out nocopy  VARCHAR2
119     , p4_a59 in out nocopy  VARCHAR2
120     , p4_a60 in out nocopy  VARCHAR2
121     , p4_a61 in out nocopy  VARCHAR2
122     , p4_a62 in out nocopy  VARCHAR2
123     , p4_a63 in out nocopy  VARCHAR2
124     , p4_a64 in out nocopy  NUMBER
125     , p4_a65 in out nocopy  NUMBER
126     , p4_a66 in out nocopy  VARCHAR2
127     , p4_a67 in out nocopy  NUMBER
128     , p4_a68 in out nocopy  VARCHAR2
129     , p4_a69 in out nocopy  VARCHAR2
130     , p4_a70 in out nocopy  VARCHAR2
131     , p4_a71 in out nocopy  VARCHAR2
132     , p4_a72 in out nocopy  NUMBER
133     , p4_a73 in out nocopy  VARCHAR2
134     , p4_a74 in out nocopy  NUMBER
135     , p4_a75 in out nocopy  NUMBER
136     , p4_a76 in out nocopy  NUMBER
137     , p4_a77 in out nocopy  VARCHAR2
138     , p4_a78 in out nocopy  VARCHAR2
139     , p4_a79 in out nocopy  VARCHAR2
140     , p4_a80 in out nocopy  NUMBER
141     , p4_a81 in out nocopy  NUMBER
142     , p4_a82 in out nocopy  NUMBER
143     , p4_a83 in out nocopy  DATE
144     , p4_a84 in out nocopy  VARCHAR2
145     , p4_a85 in out nocopy  VARCHAR2
146     , p4_a86 in out nocopy  VARCHAR2
147     , p4_a87 in out nocopy  NUMBER
148     , p4_a88 in out nocopy  VARCHAR2
149     , p4_a89 in out nocopy  NUMBER
150     , p4_a90 in out nocopy  NUMBER
151     , p4_a91 in out nocopy  VARCHAR2
152     , p4_a92 in out nocopy  NUMBER
153     , p4_a93 in out nocopy  VARCHAR2
154     , p4_a94 in out nocopy  NUMBER
155     , p4_a95 in out nocopy  DATE
156     , p4_a96 in out nocopy  VARCHAR2
157     , p4_a97 in out nocopy  VARCHAR2
158     , p4_a98 in out nocopy  VARCHAR2
159     , p4_a99 in out nocopy  VARCHAR2
160     , p4_a100 in out nocopy  VARCHAR2
161     , p4_a101 in out nocopy  VARCHAR2
162     , p4_a102 in out nocopy  VARCHAR2
163     , p4_a103 in out nocopy  VARCHAR2
164     , p4_a104 in out nocopy  VARCHAR2
165     , p4_a105 in out nocopy  VARCHAR2
166     , p4_a106 in out nocopy  VARCHAR2
167     , p4_a107 in out nocopy  VARCHAR2
168     , p4_a108 in out nocopy  VARCHAR2
169     , p4_a109 in out nocopy  VARCHAR2
170     , p4_a110 in out nocopy  VARCHAR2
171     , p4_a111 in out nocopy  NUMBER
172     , p4_a112 in out nocopy  VARCHAR2
173     , p4_a113 in out nocopy  NUMBER
174     , p4_a114 in out nocopy  VARCHAR2
175     , p4_a115 in out nocopy  NUMBER
176     , p4_a116 in out nocopy  VARCHAR2
177     , p4_a117 in out nocopy  VARCHAR2
178     , p4_a118 in out nocopy  NUMBER
179     , p4_a119 in out nocopy  VARCHAR2
180     , p4_a120 in out nocopy  NUMBER
181     , p4_a121 in out nocopy  NUMBER
182     , p4_a122 in out nocopy  VARCHAR2
183     , p5_a0 in out nocopy JTF_NUMBER_TABLE
184     , p5_a1 in out nocopy JTF_NUMBER_TABLE
185     , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_100
186     , p5_a3 in out nocopy JTF_NUMBER_TABLE
187     , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
188     , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
189     , p5_a6 in out nocopy JTF_NUMBER_TABLE
190     , p5_a7 in out nocopy JTF_DATE_TABLE
191     , p5_a8 in out nocopy JTF_DATE_TABLE
192     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
194     , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
195     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
196     , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
197     , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
198     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
199     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
200     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
201     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
202     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
203     , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
204     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
205     , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
206     , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
207     , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
208     , p5_a25 in out nocopy JTF_NUMBER_TABLE
209     , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
210     , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
211     , p5_a28 in out nocopy JTF_NUMBER_TABLE
212     , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
213     , p5_a30 in out nocopy JTF_NUMBER_TABLE
214     , p5_a31 in out nocopy JTF_NUMBER_TABLE
215     , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
216     , p6_a0 in out nocopy JTF_NUMBER_TABLE
217     , p6_a1 in out nocopy JTF_NUMBER_TABLE
218     , p6_a2 in out nocopy JTF_NUMBER_TABLE
219     , p6_a3 in out nocopy JTF_NUMBER_TABLE
220     , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
221     , p6_a5 in out nocopy JTF_NUMBER_TABLE
222     , p6_a6 in out nocopy JTF_NUMBER_TABLE
223     , p6_a7 in out nocopy JTF_DATE_TABLE
224     , p6_a8 in out nocopy JTF_DATE_TABLE
225     , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
226     , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
227     , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
228     , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
229     , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
230     , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
231     , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
232     , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
233     , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
234     , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
235     , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
236     , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
237     , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
238     , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
239     , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
240     , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
241     , p6_a25 in out nocopy JTF_NUMBER_TABLE
242     , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
243     , p6_a27 in out nocopy JTF_NUMBER_TABLE
244     , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_100
245     , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
246     , p6_a30 in out nocopy JTF_NUMBER_TABLE
247     , p6_a31 in out nocopy JTF_NUMBER_TABLE
248     , p6_a32 in out nocopy JTF_NUMBER_TABLE
249     , p6_a33 in out nocopy JTF_DATE_TABLE
250     , p6_a34 in out nocopy JTF_NUMBER_TABLE
251     , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
252     , p7_a0 in out nocopy  NUMBER
253     , p7_a1 in out nocopy  DATE
254     , p7_a2 in out nocopy  DATE
255     , p7_a3 in out nocopy  NUMBER
256     , p7_a4 in out nocopy  NUMBER
257     , p7_a5 in out nocopy  NUMBER
258     , p7_a6 in out nocopy  VARCHAR2
259     , p7_a7 in out nocopy  NUMBER
260     , p7_a8 in out nocopy  VARCHAR2
261     , p7_a9 in out nocopy  NUMBER
262     , p7_a10 in out nocopy  VARCHAR2
263     , p7_a11 in out nocopy  NUMBER
264     , p7_a12 in out nocopy  NUMBER
265     , p7_a13 in out nocopy  NUMBER
266     , p7_a14 in out nocopy  NUMBER
267     , p7_a15 in out nocopy  VARCHAR2
268     , p7_a16 in out nocopy  NUMBER
269     , p7_a17 in out nocopy  VARCHAR2
270     , p7_a18 in out nocopy  VARCHAR2
271     , p7_a19 in out nocopy  NUMBER
272     , p7_a20 in out nocopy  VARCHAR2
273     , p7_a21 in out nocopy  VARCHAR2
274     , p7_a22 in out nocopy  VARCHAR2
275     , p7_a23 in out nocopy  VARCHAR2
276     , p7_a24 in out nocopy  VARCHAR2
277     , p7_a25 in out nocopy  VARCHAR2
278     , p7_a26 in out nocopy  VARCHAR2
279     , p7_a27 in out nocopy  VARCHAR2
280     , p7_a28 in out nocopy  VARCHAR2
281     , p7_a29 in out nocopy  VARCHAR2
282     , p7_a30 in out nocopy  VARCHAR2
283     , p7_a31 in out nocopy  VARCHAR2
284     , p7_a32 in out nocopy  VARCHAR2
285     , p7_a33 in out nocopy  VARCHAR2
286     , p7_a34 in out nocopy  VARCHAR2
287     , p7_a35 in out nocopy  VARCHAR2
288     , p7_a36 in out nocopy  NUMBER
289     , p7_a37 in out nocopy  VARCHAR2
290     , p7_a38 in out nocopy  DATE
291     , p7_a39 in out nocopy  NUMBER
292     , x_return_status out nocopy  VARCHAR2
293     , x_msg_count out nocopy  NUMBER
294     , x_msg_data out nocopy  VARCHAR2
295   );
296   procedure split_item_instance(p_api_version  NUMBER
297     , p_commit  VARCHAR2
298     , p_init_msg_list  VARCHAR2
299     , p_validation_level  NUMBER
300     , p4_a0 in out nocopy  NUMBER
301     , p4_a1 in out nocopy  VARCHAR2
302     , p4_a2 in out nocopy  VARCHAR2
303     , p4_a3 in out nocopy  NUMBER
304     , p4_a4 in out nocopy  NUMBER
305     , p4_a5 in out nocopy  VARCHAR2
306     , p4_a6 in out nocopy  NUMBER
307     , p4_a7 in out nocopy  VARCHAR2
308     , p4_a8 in out nocopy  VARCHAR2
309     , p4_a9 in out nocopy  VARCHAR2
310     , p4_a10 in out nocopy  NUMBER
311     , p4_a11 in out nocopy  VARCHAR2
312     , p4_a12 in out nocopy  VARCHAR2
313     , p4_a13 in out nocopy  NUMBER
314     , p4_a14 in out nocopy  NUMBER
315     , p4_a15 in out nocopy  VARCHAR2
316     , p4_a16 in out nocopy  VARCHAR2
317     , p4_a17 in out nocopy  VARCHAR2
318     , p4_a18 in out nocopy  NUMBER
319     , p4_a19 in out nocopy  VARCHAR2
320     , p4_a20 in out nocopy  DATE
321     , p4_a21 in out nocopy  DATE
322     , p4_a22 in out nocopy  VARCHAR2
323     , p4_a23 in out nocopy  NUMBER
324     , p4_a24 in out nocopy  NUMBER
325     , p4_a25 in out nocopy  VARCHAR2
326     , p4_a26 in out nocopy  NUMBER
327     , p4_a27 in out nocopy  NUMBER
328     , p4_a28 in out nocopy  NUMBER
329     , p4_a29 in out nocopy  NUMBER
330     , p4_a30 in out nocopy  NUMBER
331     , p4_a31 in out nocopy  NUMBER
332     , p4_a32 in out nocopy  NUMBER
333     , p4_a33 in out nocopy  NUMBER
334     , p4_a34 in out nocopy  NUMBER
335     , p4_a35 in out nocopy  VARCHAR2
336     , p4_a36 in out nocopy  NUMBER
337     , p4_a37 in out nocopy  NUMBER
338     , p4_a38 in out nocopy  NUMBER
339     , p4_a39 in out nocopy  NUMBER
340     , p4_a40 in out nocopy  DATE
341     , p4_a41 in out nocopy  VARCHAR2
342     , p4_a42 in out nocopy  DATE
343     , p4_a43 in out nocopy  DATE
344     , p4_a44 in out nocopy  VARCHAR2
345     , p4_a45 in out nocopy  VARCHAR2
346     , p4_a46 in out nocopy  VARCHAR2
347     , p4_a47 in out nocopy  VARCHAR2
348     , p4_a48 in out nocopy  VARCHAR2
349     , p4_a49 in out nocopy  VARCHAR2
350     , p4_a50 in out nocopy  VARCHAR2
351     , p4_a51 in out nocopy  VARCHAR2
352     , p4_a52 in out nocopy  VARCHAR2
353     , p4_a53 in out nocopy  VARCHAR2
354     , p4_a54 in out nocopy  VARCHAR2
355     , p4_a55 in out nocopy  VARCHAR2
356     , p4_a56 in out nocopy  VARCHAR2
357     , p4_a57 in out nocopy  VARCHAR2
361     , p4_a61 in out nocopy  VARCHAR2
358     , p4_a58 in out nocopy  VARCHAR2
359     , p4_a59 in out nocopy  VARCHAR2
360     , p4_a60 in out nocopy  VARCHAR2
362     , p4_a62 in out nocopy  VARCHAR2
363     , p4_a63 in out nocopy  VARCHAR2
364     , p4_a64 in out nocopy  NUMBER
365     , p4_a65 in out nocopy  NUMBER
366     , p4_a66 in out nocopy  VARCHAR2
367     , p4_a67 in out nocopy  NUMBER
368     , p4_a68 in out nocopy  VARCHAR2
369     , p4_a69 in out nocopy  VARCHAR2
370     , p4_a70 in out nocopy  VARCHAR2
371     , p4_a71 in out nocopy  VARCHAR2
372     , p4_a72 in out nocopy  NUMBER
373     , p4_a73 in out nocopy  VARCHAR2
374     , p4_a74 in out nocopy  NUMBER
375     , p4_a75 in out nocopy  NUMBER
376     , p4_a76 in out nocopy  NUMBER
377     , p4_a77 in out nocopy  VARCHAR2
378     , p4_a78 in out nocopy  VARCHAR2
379     , p4_a79 in out nocopy  VARCHAR2
380     , p4_a80 in out nocopy  NUMBER
381     , p4_a81 in out nocopy  NUMBER
382     , p4_a82 in out nocopy  NUMBER
383     , p4_a83 in out nocopy  DATE
384     , p4_a84 in out nocopy  VARCHAR2
385     , p4_a85 in out nocopy  VARCHAR2
386     , p4_a86 in out nocopy  VARCHAR2
387     , p4_a87 in out nocopy  NUMBER
388     , p4_a88 in out nocopy  VARCHAR2
389     , p4_a89 in out nocopy  NUMBER
390     , p4_a90 in out nocopy  NUMBER
391     , p4_a91 in out nocopy  VARCHAR2
392     , p4_a92 in out nocopy  NUMBER
393     , p4_a93 in out nocopy  VARCHAR2
394     , p4_a94 in out nocopy  NUMBER
395     , p4_a95 in out nocopy  DATE
396     , p4_a96 in out nocopy  VARCHAR2
397     , p4_a97 in out nocopy  VARCHAR2
398     , p4_a98 in out nocopy  VARCHAR2
399     , p4_a99 in out nocopy  VARCHAR2
400     , p4_a100 in out nocopy  VARCHAR2
401     , p4_a101 in out nocopy  VARCHAR2
402     , p4_a102 in out nocopy  VARCHAR2
403     , p4_a103 in out nocopy  VARCHAR2
404     , p4_a104 in out nocopy  VARCHAR2
405     , p4_a105 in out nocopy  VARCHAR2
406     , p4_a106 in out nocopy  VARCHAR2
407     , p4_a107 in out nocopy  VARCHAR2
408     , p4_a108 in out nocopy  VARCHAR2
409     , p4_a109 in out nocopy  VARCHAR2
410     , p4_a110 in out nocopy  VARCHAR2
411     , p4_a111 in out nocopy  NUMBER
412     , p4_a112 in out nocopy  VARCHAR2
413     , p4_a113 in out nocopy  NUMBER
414     , p4_a114 in out nocopy  VARCHAR2
415     , p4_a115 in out nocopy  NUMBER
416     , p4_a116 in out nocopy  VARCHAR2
417     , p4_a117 in out nocopy  VARCHAR2
418     , p4_a118 in out nocopy  NUMBER
419     , p4_a119 in out nocopy  VARCHAR2
420     , p4_a120 in out nocopy  NUMBER
421     , p4_a121 in out nocopy  NUMBER
422     , p4_a122 in out nocopy  VARCHAR2
423     , p_quantity1  NUMBER
424     , p_quantity2  NUMBER
425     , p_copy_ext_attribs  VARCHAR2
426     , p_copy_org_assignments  VARCHAR2
427     , p_copy_parties  VARCHAR2
428     , p_copy_accounts  VARCHAR2
429     , p_copy_asset_assignments  VARCHAR2
430     , p_copy_pricing_attribs  VARCHAR2
431     , p13_a0 in out nocopy  NUMBER
432     , p13_a1 in out nocopy  DATE
433     , p13_a2 in out nocopy  DATE
434     , p13_a3 in out nocopy  NUMBER
435     , p13_a4 in out nocopy  NUMBER
436     , p13_a5 in out nocopy  NUMBER
437     , p13_a6 in out nocopy  VARCHAR2
438     , p13_a7 in out nocopy  NUMBER
439     , p13_a8 in out nocopy  VARCHAR2
440     , p13_a9 in out nocopy  NUMBER
441     , p13_a10 in out nocopy  VARCHAR2
442     , p13_a11 in out nocopy  NUMBER
443     , p13_a12 in out nocopy  NUMBER
444     , p13_a13 in out nocopy  NUMBER
445     , p13_a14 in out nocopy  NUMBER
446     , p13_a15 in out nocopy  VARCHAR2
447     , p13_a16 in out nocopy  NUMBER
448     , p13_a17 in out nocopy  VARCHAR2
449     , p13_a18 in out nocopy  VARCHAR2
450     , p13_a19 in out nocopy  NUMBER
451     , p13_a20 in out nocopy  VARCHAR2
455     , p13_a24 in out nocopy  VARCHAR2
452     , p13_a21 in out nocopy  VARCHAR2
453     , p13_a22 in out nocopy  VARCHAR2
454     , p13_a23 in out nocopy  VARCHAR2
456     , p13_a25 in out nocopy  VARCHAR2
457     , p13_a26 in out nocopy  VARCHAR2
458     , p13_a27 in out nocopy  VARCHAR2
459     , p13_a28 in out nocopy  VARCHAR2
460     , p13_a29 in out nocopy  VARCHAR2
461     , p13_a30 in out nocopy  VARCHAR2
462     , p13_a31 in out nocopy  VARCHAR2
463     , p13_a32 in out nocopy  VARCHAR2
464     , p13_a33 in out nocopy  VARCHAR2
465     , p13_a34 in out nocopy  VARCHAR2
466     , p13_a35 in out nocopy  VARCHAR2
467     , p13_a36 in out nocopy  NUMBER
468     , p13_a37 in out nocopy  VARCHAR2
469     , p13_a38 in out nocopy  DATE
470     , p13_a39 in out nocopy  NUMBER
471     , p14_a0 out nocopy  NUMBER
472     , p14_a1 out nocopy  VARCHAR2
473     , p14_a2 out nocopy  VARCHAR2
474     , p14_a3 out nocopy  NUMBER
475     , p14_a4 out nocopy  NUMBER
476     , p14_a5 out nocopy  VARCHAR2
477     , p14_a6 out nocopy  NUMBER
478     , p14_a7 out nocopy  VARCHAR2
479     , p14_a8 out nocopy  VARCHAR2
480     , p14_a9 out nocopy  VARCHAR2
481     , p14_a10 out nocopy  NUMBER
482     , p14_a11 out nocopy  VARCHAR2
483     , p14_a12 out nocopy  VARCHAR2
484     , p14_a13 out nocopy  NUMBER
485     , p14_a14 out nocopy  NUMBER
486     , p14_a15 out nocopy  VARCHAR2
487     , p14_a16 out nocopy  VARCHAR2
488     , p14_a17 out nocopy  VARCHAR2
489     , p14_a18 out nocopy  NUMBER
490     , p14_a19 out nocopy  VARCHAR2
491     , p14_a20 out nocopy  DATE
492     , p14_a21 out nocopy  DATE
493     , p14_a22 out nocopy  VARCHAR2
494     , p14_a23 out nocopy  NUMBER
495     , p14_a24 out nocopy  NUMBER
496     , p14_a25 out nocopy  VARCHAR2
497     , p14_a26 out nocopy  NUMBER
498     , p14_a27 out nocopy  NUMBER
499     , p14_a28 out nocopy  NUMBER
500     , p14_a29 out nocopy  NUMBER
501     , p14_a30 out nocopy  NUMBER
502     , p14_a31 out nocopy  NUMBER
503     , p14_a32 out nocopy  NUMBER
504     , p14_a33 out nocopy  NUMBER
505     , p14_a34 out nocopy  NUMBER
506     , p14_a35 out nocopy  VARCHAR2
507     , p14_a36 out nocopy  NUMBER
508     , p14_a37 out nocopy  NUMBER
509     , p14_a38 out nocopy  NUMBER
510     , p14_a39 out nocopy  NUMBER
511     , p14_a40 out nocopy  DATE
512     , p14_a41 out nocopy  VARCHAR2
513     , p14_a42 out nocopy  DATE
514     , p14_a43 out nocopy  DATE
515     , p14_a44 out nocopy  VARCHAR2
516     , p14_a45 out nocopy  VARCHAR2
517     , p14_a46 out nocopy  VARCHAR2
518     , p14_a47 out nocopy  VARCHAR2
519     , p14_a48 out nocopy  VARCHAR2
520     , p14_a49 out nocopy  VARCHAR2
521     , p14_a50 out nocopy  VARCHAR2
522     , p14_a51 out nocopy  VARCHAR2
523     , p14_a52 out nocopy  VARCHAR2
524     , p14_a53 out nocopy  VARCHAR2
525     , p14_a54 out nocopy  VARCHAR2
526     , p14_a55 out nocopy  VARCHAR2
527     , p14_a56 out nocopy  VARCHAR2
528     , p14_a57 out nocopy  VARCHAR2
529     , p14_a58 out nocopy  VARCHAR2
530     , p14_a59 out nocopy  VARCHAR2
531     , p14_a60 out nocopy  VARCHAR2
532     , p14_a61 out nocopy  VARCHAR2
533     , p14_a62 out nocopy  VARCHAR2
534     , p14_a63 out nocopy  VARCHAR2
535     , p14_a64 out nocopy  NUMBER
536     , p14_a65 out nocopy  NUMBER
537     , p14_a66 out nocopy  VARCHAR2
538     , p14_a67 out nocopy  NUMBER
539     , p14_a68 out nocopy  VARCHAR2
540     , p14_a69 out nocopy  VARCHAR2
541     , p14_a70 out nocopy  VARCHAR2
542     , p14_a71 out nocopy  VARCHAR2
543     , p14_a72 out nocopy  NUMBER
544     , p14_a73 out nocopy  VARCHAR2
545     , p14_a74 out nocopy  NUMBER
546     , p14_a75 out nocopy  NUMBER
547     , p14_a76 out nocopy  NUMBER
548     , p14_a77 out nocopy  VARCHAR2
549     , p14_a78 out nocopy  VARCHAR2
550     , p14_a79 out nocopy  VARCHAR2
551     , p14_a80 out nocopy  NUMBER
552     , p14_a81 out nocopy  NUMBER
553     , p14_a82 out nocopy  NUMBER
554     , p14_a83 out nocopy  DATE
555     , p14_a84 out nocopy  VARCHAR2
556     , p14_a85 out nocopy  VARCHAR2
557     , p14_a86 out nocopy  VARCHAR2
558     , p14_a87 out nocopy  NUMBER
559     , p14_a88 out nocopy  VARCHAR2
560     , p14_a89 out nocopy  NUMBER
561     , p14_a90 out nocopy  NUMBER
562     , p14_a91 out nocopy  VARCHAR2
563     , p14_a92 out nocopy  NUMBER
564     , p14_a93 out nocopy  VARCHAR2
568     , p14_a97 out nocopy  VARCHAR2
565     , p14_a94 out nocopy  NUMBER
566     , p14_a95 out nocopy  DATE
567     , p14_a96 out nocopy  VARCHAR2
569     , p14_a98 out nocopy  VARCHAR2
570     , p14_a99 out nocopy  VARCHAR2
571     , p14_a100 out nocopy  VARCHAR2
572     , p14_a101 out nocopy  VARCHAR2
573     , p14_a102 out nocopy  VARCHAR2
574     , p14_a103 out nocopy  VARCHAR2
575     , p14_a104 out nocopy  VARCHAR2
576     , p14_a105 out nocopy  VARCHAR2
577     , p14_a106 out nocopy  VARCHAR2
578     , p14_a107 out nocopy  VARCHAR2
579     , p14_a108 out nocopy  VARCHAR2
580     , p14_a109 out nocopy  VARCHAR2
581     , p14_a110 out nocopy  VARCHAR2
582     , p14_a111 out nocopy  NUMBER
583     , p14_a112 out nocopy  VARCHAR2
584     , p14_a113 out nocopy  NUMBER
585     , p14_a114 out nocopy  VARCHAR2
586     , p14_a115 out nocopy  NUMBER
587     , p14_a116 out nocopy  VARCHAR2
588     , p14_a117 out nocopy  VARCHAR2
589     , p14_a118 out nocopy  NUMBER
590     , p14_a119 out nocopy  VARCHAR2
591     , p14_a120 out nocopy  NUMBER
592     , p14_a121 out nocopy  NUMBER
593     , p14_a122 out nocopy  VARCHAR2
594     , x_return_status out nocopy  VARCHAR2
595     , x_msg_count out nocopy  NUMBER
596     , x_msg_data out nocopy  VARCHAR2
597   );
598   procedure split_item_instance_lines(p_api_version  NUMBER
599     , p_commit  VARCHAR2
600     , p_init_msg_list  VARCHAR2
601     , p_validation_level  NUMBER
602     , p4_a0 in out nocopy  NUMBER
603     , p4_a1 in out nocopy  VARCHAR2
604     , p4_a2 in out nocopy  VARCHAR2
605     , p4_a3 in out nocopy  NUMBER
606     , p4_a4 in out nocopy  NUMBER
607     , p4_a5 in out nocopy  VARCHAR2
608     , p4_a6 in out nocopy  NUMBER
609     , p4_a7 in out nocopy  VARCHAR2
610     , p4_a8 in out nocopy  VARCHAR2
611     , p4_a9 in out nocopy  VARCHAR2
612     , p4_a10 in out nocopy  NUMBER
613     , p4_a11 in out nocopy  VARCHAR2
614     , p4_a12 in out nocopy  VARCHAR2
615     , p4_a13 in out nocopy  NUMBER
616     , p4_a14 in out nocopy  NUMBER
617     , p4_a15 in out nocopy  VARCHAR2
618     , p4_a16 in out nocopy  VARCHAR2
619     , p4_a17 in out nocopy  VARCHAR2
620     , p4_a18 in out nocopy  NUMBER
621     , p4_a19 in out nocopy  VARCHAR2
622     , p4_a20 in out nocopy  DATE
623     , p4_a21 in out nocopy  DATE
624     , p4_a22 in out nocopy  VARCHAR2
625     , p4_a23 in out nocopy  NUMBER
626     , p4_a24 in out nocopy  NUMBER
627     , p4_a25 in out nocopy  VARCHAR2
628     , p4_a26 in out nocopy  NUMBER
629     , p4_a27 in out nocopy  NUMBER
630     , p4_a28 in out nocopy  NUMBER
631     , p4_a29 in out nocopy  NUMBER
632     , p4_a30 in out nocopy  NUMBER
633     , p4_a31 in out nocopy  NUMBER
634     , p4_a32 in out nocopy  NUMBER
635     , p4_a33 in out nocopy  NUMBER
636     , p4_a34 in out nocopy  NUMBER
637     , p4_a35 in out nocopy  VARCHAR2
638     , p4_a36 in out nocopy  NUMBER
639     , p4_a37 in out nocopy  NUMBER
640     , p4_a38 in out nocopy  NUMBER
641     , p4_a39 in out nocopy  NUMBER
642     , p4_a40 in out nocopy  DATE
643     , p4_a41 in out nocopy  VARCHAR2
644     , p4_a42 in out nocopy  DATE
645     , p4_a43 in out nocopy  DATE
646     , p4_a44 in out nocopy  VARCHAR2
647     , p4_a45 in out nocopy  VARCHAR2
648     , p4_a46 in out nocopy  VARCHAR2
649     , p4_a47 in out nocopy  VARCHAR2
650     , p4_a48 in out nocopy  VARCHAR2
651     , p4_a49 in out nocopy  VARCHAR2
652     , p4_a50 in out nocopy  VARCHAR2
653     , p4_a51 in out nocopy  VARCHAR2
654     , p4_a52 in out nocopy  VARCHAR2
655     , p4_a53 in out nocopy  VARCHAR2
656     , p4_a54 in out nocopy  VARCHAR2
657     , p4_a55 in out nocopy  VARCHAR2
658     , p4_a56 in out nocopy  VARCHAR2
659     , p4_a57 in out nocopy  VARCHAR2
660     , p4_a58 in out nocopy  VARCHAR2
661     , p4_a59 in out nocopy  VARCHAR2
662     , p4_a60 in out nocopy  VARCHAR2
663     , p4_a61 in out nocopy  VARCHAR2
664     , p4_a62 in out nocopy  VARCHAR2
665     , p4_a63 in out nocopy  VARCHAR2
666     , p4_a64 in out nocopy  NUMBER
667     , p4_a65 in out nocopy  NUMBER
668     , p4_a66 in out nocopy  VARCHAR2
669     , p4_a67 in out nocopy  NUMBER
670     , p4_a68 in out nocopy  VARCHAR2
671     , p4_a69 in out nocopy  VARCHAR2
672     , p4_a70 in out nocopy  VARCHAR2
673     , p4_a71 in out nocopy  VARCHAR2
674     , p4_a72 in out nocopy  NUMBER
675     , p4_a73 in out nocopy  VARCHAR2
676     , p4_a74 in out nocopy  NUMBER
677     , p4_a75 in out nocopy  NUMBER
678     , p4_a76 in out nocopy  NUMBER
679     , p4_a77 in out nocopy  VARCHAR2
680     , p4_a78 in out nocopy  VARCHAR2
681     , p4_a79 in out nocopy  VARCHAR2
682     , p4_a80 in out nocopy  NUMBER
683     , p4_a81 in out nocopy  NUMBER
684     , p4_a82 in out nocopy  NUMBER
685     , p4_a83 in out nocopy  DATE
686     , p4_a84 in out nocopy  VARCHAR2
687     , p4_a85 in out nocopy  VARCHAR2
688     , p4_a86 in out nocopy  VARCHAR2
689     , p4_a87 in out nocopy  NUMBER
690     , p4_a88 in out nocopy  VARCHAR2
691     , p4_a89 in out nocopy  NUMBER
692     , p4_a90 in out nocopy  NUMBER
693     , p4_a91 in out nocopy  VARCHAR2
694     , p4_a92 in out nocopy  NUMBER
695     , p4_a93 in out nocopy  VARCHAR2
696     , p4_a94 in out nocopy  NUMBER
697     , p4_a95 in out nocopy  DATE
698     , p4_a96 in out nocopy  VARCHAR2
699     , p4_a97 in out nocopy  VARCHAR2
703     , p4_a101 in out nocopy  VARCHAR2
700     , p4_a98 in out nocopy  VARCHAR2
701     , p4_a99 in out nocopy  VARCHAR2
702     , p4_a100 in out nocopy  VARCHAR2
704     , p4_a102 in out nocopy  VARCHAR2
705     , p4_a103 in out nocopy  VARCHAR2
706     , p4_a104 in out nocopy  VARCHAR2
707     , p4_a105 in out nocopy  VARCHAR2
708     , p4_a106 in out nocopy  VARCHAR2
709     , p4_a107 in out nocopy  VARCHAR2
710     , p4_a108 in out nocopy  VARCHAR2
711     , p4_a109 in out nocopy  VARCHAR2
712     , p4_a110 in out nocopy  VARCHAR2
713     , p4_a111 in out nocopy  NUMBER
714     , p4_a112 in out nocopy  VARCHAR2
715     , p4_a113 in out nocopy  NUMBER
716     , p4_a114 in out nocopy  VARCHAR2
717     , p4_a115 in out nocopy  NUMBER
718     , p4_a116 in out nocopy  VARCHAR2
719     , p4_a117 in out nocopy  VARCHAR2
720     , p4_a118 in out nocopy  NUMBER
721     , p4_a119 in out nocopy  VARCHAR2
722     , p4_a120 in out nocopy  NUMBER
723     , p4_a121 in out nocopy  NUMBER
724     , p4_a122 in out nocopy  VARCHAR2
725     , p_copy_ext_attribs  VARCHAR2
726     , p_copy_org_assignments  VARCHAR2
727     , p_copy_parties  VARCHAR2
728     , p_copy_accounts  VARCHAR2
729     , p_copy_asset_assignments  VARCHAR2
730     , p_copy_pricing_attribs  VARCHAR2
731     , p11_a0 in out nocopy  NUMBER
732     , p11_a1 in out nocopy  DATE
733     , p11_a2 in out nocopy  DATE
734     , p11_a3 in out nocopy  NUMBER
735     , p11_a4 in out nocopy  NUMBER
736     , p11_a5 in out nocopy  NUMBER
737     , p11_a6 in out nocopy  VARCHAR2
738     , p11_a7 in out nocopy  NUMBER
739     , p11_a8 in out nocopy  VARCHAR2
740     , p11_a9 in out nocopy  NUMBER
741     , p11_a10 in out nocopy  VARCHAR2
742     , p11_a11 in out nocopy  NUMBER
743     , p11_a12 in out nocopy  NUMBER
744     , p11_a13 in out nocopy  NUMBER
745     , p11_a14 in out nocopy  NUMBER
746     , p11_a15 in out nocopy  VARCHAR2
747     , p11_a16 in out nocopy  NUMBER
748     , p11_a17 in out nocopy  VARCHAR2
749     , p11_a18 in out nocopy  VARCHAR2
750     , p11_a19 in out nocopy  NUMBER
751     , p11_a20 in out nocopy  VARCHAR2
752     , p11_a21 in out nocopy  VARCHAR2
753     , p11_a22 in out nocopy  VARCHAR2
754     , p11_a23 in out nocopy  VARCHAR2
755     , p11_a24 in out nocopy  VARCHAR2
756     , p11_a25 in out nocopy  VARCHAR2
757     , p11_a26 in out nocopy  VARCHAR2
758     , p11_a27 in out nocopy  VARCHAR2
759     , p11_a28 in out nocopy  VARCHAR2
760     , p11_a29 in out nocopy  VARCHAR2
761     , p11_a30 in out nocopy  VARCHAR2
762     , p11_a31 in out nocopy  VARCHAR2
763     , p11_a32 in out nocopy  VARCHAR2
764     , p11_a33 in out nocopy  VARCHAR2
765     , p11_a34 in out nocopy  VARCHAR2
766     , p11_a35 in out nocopy  VARCHAR2
767     , p11_a36 in out nocopy  NUMBER
768     , p11_a37 in out nocopy  VARCHAR2
769     , p11_a38 in out nocopy  DATE
770     , p11_a39 in out nocopy  NUMBER
771     , p12_a0 out nocopy JTF_NUMBER_TABLE
772     , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
773     , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
774     , p12_a3 out nocopy JTF_NUMBER_TABLE
775     , p12_a4 out nocopy JTF_NUMBER_TABLE
776     , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
777     , p12_a6 out nocopy JTF_NUMBER_TABLE
778     , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
779     , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
780     , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
781     , p12_a10 out nocopy JTF_NUMBER_TABLE
782     , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
783     , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
784     , p12_a13 out nocopy JTF_NUMBER_TABLE
785     , p12_a14 out nocopy JTF_NUMBER_TABLE
786     , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
787     , p12_a16 out nocopy JTF_VARCHAR2_TABLE_100
788     , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
789     , p12_a18 out nocopy JTF_NUMBER_TABLE
790     , p12_a19 out nocopy JTF_VARCHAR2_TABLE_100
791     , p12_a20 out nocopy JTF_DATE_TABLE
792     , p12_a21 out nocopy JTF_DATE_TABLE
793     , p12_a22 out nocopy JTF_VARCHAR2_TABLE_100
794     , p12_a23 out nocopy JTF_NUMBER_TABLE
795     , p12_a24 out nocopy JTF_NUMBER_TABLE
796     , p12_a25 out nocopy JTF_VARCHAR2_TABLE_100
797     , p12_a26 out nocopy JTF_NUMBER_TABLE
798     , p12_a27 out nocopy JTF_NUMBER_TABLE
799     , p12_a28 out nocopy JTF_NUMBER_TABLE
800     , p12_a29 out nocopy JTF_NUMBER_TABLE
801     , p12_a30 out nocopy JTF_NUMBER_TABLE
802     , p12_a31 out nocopy JTF_NUMBER_TABLE
803     , p12_a32 out nocopy JTF_NUMBER_TABLE
804     , p12_a33 out nocopy JTF_NUMBER_TABLE
805     , p12_a34 out nocopy JTF_NUMBER_TABLE
806     , p12_a35 out nocopy JTF_VARCHAR2_TABLE_100
807     , p12_a36 out nocopy JTF_NUMBER_TABLE
808     , p12_a37 out nocopy JTF_NUMBER_TABLE
809     , p12_a38 out nocopy JTF_NUMBER_TABLE
810     , p12_a39 out nocopy JTF_NUMBER_TABLE
811     , p12_a40 out nocopy JTF_DATE_TABLE
812     , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
813     , p12_a42 out nocopy JTF_DATE_TABLE
814     , p12_a43 out nocopy JTF_DATE_TABLE
815     , p12_a44 out nocopy JTF_VARCHAR2_TABLE_100
816     , p12_a45 out nocopy JTF_VARCHAR2_TABLE_100
817     , p12_a46 out nocopy JTF_VARCHAR2_TABLE_300
818     , p12_a47 out nocopy JTF_VARCHAR2_TABLE_300
819     , p12_a48 out nocopy JTF_VARCHAR2_TABLE_100
820     , p12_a49 out nocopy JTF_VARCHAR2_TABLE_300
821     , p12_a50 out nocopy JTF_VARCHAR2_TABLE_300
822     , p12_a51 out nocopy JTF_VARCHAR2_TABLE_300
826     , p12_a55 out nocopy JTF_VARCHAR2_TABLE_300
823     , p12_a52 out nocopy JTF_VARCHAR2_TABLE_300
824     , p12_a53 out nocopy JTF_VARCHAR2_TABLE_300
825     , p12_a54 out nocopy JTF_VARCHAR2_TABLE_300
827     , p12_a56 out nocopy JTF_VARCHAR2_TABLE_300
828     , p12_a57 out nocopy JTF_VARCHAR2_TABLE_300
829     , p12_a58 out nocopy JTF_VARCHAR2_TABLE_300
830     , p12_a59 out nocopy JTF_VARCHAR2_TABLE_300
831     , p12_a60 out nocopy JTF_VARCHAR2_TABLE_300
832     , p12_a61 out nocopy JTF_VARCHAR2_TABLE_300
833     , p12_a62 out nocopy JTF_VARCHAR2_TABLE_300
834     , p12_a63 out nocopy JTF_VARCHAR2_TABLE_300
835     , p12_a64 out nocopy JTF_NUMBER_TABLE
836     , p12_a65 out nocopy JTF_NUMBER_TABLE
837     , p12_a66 out nocopy JTF_VARCHAR2_TABLE_100
838     , p12_a67 out nocopy JTF_NUMBER_TABLE
839     , p12_a68 out nocopy JTF_VARCHAR2_TABLE_100
840     , p12_a69 out nocopy JTF_VARCHAR2_TABLE_100
841     , p12_a70 out nocopy JTF_VARCHAR2_TABLE_100
842     , p12_a71 out nocopy JTF_VARCHAR2_TABLE_100
843     , p12_a72 out nocopy JTF_NUMBER_TABLE
844     , p12_a73 out nocopy JTF_VARCHAR2_TABLE_100
845     , p12_a74 out nocopy JTF_NUMBER_TABLE
846     , p12_a75 out nocopy JTF_NUMBER_TABLE
847     , p12_a76 out nocopy JTF_NUMBER_TABLE
848     , p12_a77 out nocopy JTF_VARCHAR2_TABLE_100
849     , p12_a78 out nocopy JTF_VARCHAR2_TABLE_300
850     , p12_a79 out nocopy JTF_VARCHAR2_TABLE_100
851     , p12_a80 out nocopy JTF_NUMBER_TABLE
852     , p12_a81 out nocopy JTF_NUMBER_TABLE
853     , p12_a82 out nocopy JTF_NUMBER_TABLE
854     , p12_a83 out nocopy JTF_DATE_TABLE
855     , p12_a84 out nocopy JTF_VARCHAR2_TABLE_100
856     , p12_a85 out nocopy JTF_VARCHAR2_TABLE_100
857     , p12_a86 out nocopy JTF_VARCHAR2_TABLE_100
858     , p12_a87 out nocopy JTF_NUMBER_TABLE
859     , p12_a88 out nocopy JTF_VARCHAR2_TABLE_100
860     , p12_a89 out nocopy JTF_NUMBER_TABLE
861     , p12_a90 out nocopy JTF_NUMBER_TABLE
862     , p12_a91 out nocopy JTF_VARCHAR2_TABLE_100
863     , p12_a92 out nocopy JTF_NUMBER_TABLE
864     , p12_a93 out nocopy JTF_VARCHAR2_TABLE_100
865     , p12_a94 out nocopy JTF_NUMBER_TABLE
866     , p12_a95 out nocopy JTF_DATE_TABLE
867     , p12_a96 out nocopy JTF_VARCHAR2_TABLE_300
868     , p12_a97 out nocopy JTF_VARCHAR2_TABLE_300
869     , p12_a98 out nocopy JTF_VARCHAR2_TABLE_300
870     , p12_a99 out nocopy JTF_VARCHAR2_TABLE_300
871     , p12_a100 out nocopy JTF_VARCHAR2_TABLE_300
872     , p12_a101 out nocopy JTF_VARCHAR2_TABLE_300
873     , p12_a102 out nocopy JTF_VARCHAR2_TABLE_300
874     , p12_a103 out nocopy JTF_VARCHAR2_TABLE_300
875     , p12_a104 out nocopy JTF_VARCHAR2_TABLE_300
876     , p12_a105 out nocopy JTF_VARCHAR2_TABLE_300
877     , p12_a106 out nocopy JTF_VARCHAR2_TABLE_300
878     , p12_a107 out nocopy JTF_VARCHAR2_TABLE_300
879     , p12_a108 out nocopy JTF_VARCHAR2_TABLE_300
880     , p12_a109 out nocopy JTF_VARCHAR2_TABLE_300
881     , p12_a110 out nocopy JTF_VARCHAR2_TABLE_300
882     , p12_a111 out nocopy JTF_NUMBER_TABLE
883     , p12_a112 out nocopy JTF_VARCHAR2_TABLE_100
884     , p12_a113 out nocopy JTF_NUMBER_TABLE
885     , p12_a114 out nocopy JTF_VARCHAR2_TABLE_100
886     , p12_a115 out nocopy JTF_NUMBER_TABLE
887     , p12_a116 out nocopy JTF_VARCHAR2_TABLE_100
888     , p12_a117 out nocopy JTF_VARCHAR2_TABLE_100
889     , p12_a118 out nocopy JTF_NUMBER_TABLE
890     , p12_a119 out nocopy JTF_VARCHAR2_TABLE_100
891     , p12_a120 out nocopy JTF_NUMBER_TABLE
892     , p12_a121 out nocopy JTF_NUMBER_TABLE
893     , p12_a122 out nocopy JTF_VARCHAR2_TABLE_100
894     , x_return_status out nocopy  VARCHAR2
895     , x_msg_count out nocopy  NUMBER
896     , x_msg_data out nocopy  VARCHAR2
897   );
898   procedure copy_item_instance(p_api_version  NUMBER
899     , p_commit  VARCHAR2
900     , p_init_msg_list  VARCHAR2
901     , p_validation_level  NUMBER
902     , p_copy_ext_attribs  VARCHAR2
903     , p_copy_org_assignments  VARCHAR2
904     , p_copy_parties  VARCHAR2
905     , p_copy_contacts  VARCHAR2
906     , p_copy_accounts  VARCHAR2
907     , p_copy_asset_assignments  VARCHAR2
908     , p_copy_pricing_attribs  VARCHAR2
909     , p_copy_inst_children  VARCHAR2
910     , p13_a0 in out nocopy  NUMBER
911     , p13_a1 in out nocopy  DATE
912     , p13_a2 in out nocopy  DATE
913     , p13_a3 in out nocopy  NUMBER
914     , p13_a4 in out nocopy  NUMBER
915     , p13_a5 in out nocopy  NUMBER
916     , p13_a6 in out nocopy  VARCHAR2
917     , p13_a7 in out nocopy  NUMBER
918     , p13_a8 in out nocopy  VARCHAR2
919     , p13_a9 in out nocopy  NUMBER
920     , p13_a10 in out nocopy  VARCHAR2
921     , p13_a11 in out nocopy  NUMBER
922     , p13_a12 in out nocopy  NUMBER
923     , p13_a13 in out nocopy  NUMBER
924     , p13_a14 in out nocopy  NUMBER
925     , p13_a15 in out nocopy  VARCHAR2
926     , p13_a16 in out nocopy  NUMBER
927     , p13_a17 in out nocopy  VARCHAR2
928     , p13_a18 in out nocopy  VARCHAR2
929     , p13_a19 in out nocopy  NUMBER
930     , p13_a20 in out nocopy  VARCHAR2
931     , p13_a21 in out nocopy  VARCHAR2
932     , p13_a22 in out nocopy  VARCHAR2
933     , p13_a23 in out nocopy  VARCHAR2
934     , p13_a24 in out nocopy  VARCHAR2
935     , p13_a25 in out nocopy  VARCHAR2
936     , p13_a26 in out nocopy  VARCHAR2
937     , p13_a27 in out nocopy  VARCHAR2
938     , p13_a28 in out nocopy  VARCHAR2
939     , p13_a29 in out nocopy  VARCHAR2
940     , p13_a30 in out nocopy  VARCHAR2
944     , p13_a34 in out nocopy  VARCHAR2
941     , p13_a31 in out nocopy  VARCHAR2
942     , p13_a32 in out nocopy  VARCHAR2
943     , p13_a33 in out nocopy  VARCHAR2
945     , p13_a35 in out nocopy  VARCHAR2
946     , p13_a36 in out nocopy  NUMBER
947     , p13_a37 in out nocopy  VARCHAR2
948     , p13_a38 in out nocopy  DATE
949     , p13_a39 in out nocopy  NUMBER
950     , p14_a0 out nocopy JTF_NUMBER_TABLE
951     , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
952     , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
953     , p14_a3 out nocopy JTF_NUMBER_TABLE
954     , p14_a4 out nocopy JTF_NUMBER_TABLE
955     , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
956     , p14_a6 out nocopy JTF_NUMBER_TABLE
957     , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
958     , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
959     , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
960     , p14_a10 out nocopy JTF_NUMBER_TABLE
961     , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
962     , p14_a12 out nocopy JTF_VARCHAR2_TABLE_100
963     , p14_a13 out nocopy JTF_NUMBER_TABLE
964     , p14_a14 out nocopy JTF_NUMBER_TABLE
965     , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
966     , p14_a16 out nocopy JTF_VARCHAR2_TABLE_100
967     , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
968     , p14_a18 out nocopy JTF_NUMBER_TABLE
969     , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
970     , p14_a20 out nocopy JTF_DATE_TABLE
971     , p14_a21 out nocopy JTF_DATE_TABLE
972     , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
973     , p14_a23 out nocopy JTF_NUMBER_TABLE
974     , p14_a24 out nocopy JTF_NUMBER_TABLE
975     , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
976     , p14_a26 out nocopy JTF_NUMBER_TABLE
977     , p14_a27 out nocopy JTF_NUMBER_TABLE
978     , p14_a28 out nocopy JTF_NUMBER_TABLE
979     , p14_a29 out nocopy JTF_NUMBER_TABLE
980     , p14_a30 out nocopy JTF_NUMBER_TABLE
981     , p14_a31 out nocopy JTF_NUMBER_TABLE
982     , p14_a32 out nocopy JTF_NUMBER_TABLE
983     , p14_a33 out nocopy JTF_NUMBER_TABLE
984     , p14_a34 out nocopy JTF_NUMBER_TABLE
985     , p14_a35 out nocopy JTF_VARCHAR2_TABLE_100
986     , p14_a36 out nocopy JTF_NUMBER_TABLE
987     , p14_a37 out nocopy JTF_NUMBER_TABLE
988     , p14_a38 out nocopy JTF_NUMBER_TABLE
989     , p14_a39 out nocopy JTF_NUMBER_TABLE
990     , p14_a40 out nocopy JTF_DATE_TABLE
991     , p14_a41 out nocopy JTF_VARCHAR2_TABLE_100
992     , p14_a42 out nocopy JTF_DATE_TABLE
993     , p14_a43 out nocopy JTF_DATE_TABLE
994     , p14_a44 out nocopy JTF_VARCHAR2_TABLE_100
995     , p14_a45 out nocopy JTF_VARCHAR2_TABLE_100
996     , p14_a46 out nocopy JTF_VARCHAR2_TABLE_300
997     , p14_a47 out nocopy JTF_VARCHAR2_TABLE_300
998     , p14_a48 out nocopy JTF_VARCHAR2_TABLE_100
999     , p14_a49 out nocopy JTF_VARCHAR2_TABLE_300
1000     , p14_a50 out nocopy JTF_VARCHAR2_TABLE_300
1001     , p14_a51 out nocopy JTF_VARCHAR2_TABLE_300
1002     , p14_a52 out nocopy JTF_VARCHAR2_TABLE_300
1003     , p14_a53 out nocopy JTF_VARCHAR2_TABLE_300
1004     , p14_a54 out nocopy JTF_VARCHAR2_TABLE_300
1005     , p14_a55 out nocopy JTF_VARCHAR2_TABLE_300
1006     , p14_a56 out nocopy JTF_VARCHAR2_TABLE_300
1007     , p14_a57 out nocopy JTF_VARCHAR2_TABLE_300
1008     , p14_a58 out nocopy JTF_VARCHAR2_TABLE_300
1009     , p14_a59 out nocopy JTF_VARCHAR2_TABLE_300
1010     , p14_a60 out nocopy JTF_VARCHAR2_TABLE_300
1011     , p14_a61 out nocopy JTF_VARCHAR2_TABLE_300
1012     , p14_a62 out nocopy JTF_VARCHAR2_TABLE_300
1013     , p14_a63 out nocopy JTF_VARCHAR2_TABLE_300
1014     , p14_a64 out nocopy JTF_NUMBER_TABLE
1015     , p14_a65 out nocopy JTF_NUMBER_TABLE
1016     , p14_a66 out nocopy JTF_VARCHAR2_TABLE_100
1017     , p14_a67 out nocopy JTF_NUMBER_TABLE
1018     , p14_a68 out nocopy JTF_VARCHAR2_TABLE_100
1019     , p14_a69 out nocopy JTF_VARCHAR2_TABLE_100
1020     , p14_a70 out nocopy JTF_VARCHAR2_TABLE_100
1021     , p14_a71 out nocopy JTF_VARCHAR2_TABLE_100
1022     , p14_a72 out nocopy JTF_NUMBER_TABLE
1023     , p14_a73 out nocopy JTF_VARCHAR2_TABLE_100
1024     , p14_a74 out nocopy JTF_NUMBER_TABLE
1025     , p14_a75 out nocopy JTF_NUMBER_TABLE
1026     , p14_a76 out nocopy JTF_NUMBER_TABLE
1027     , p14_a77 out nocopy JTF_VARCHAR2_TABLE_100
1028     , p14_a78 out nocopy JTF_VARCHAR2_TABLE_300
1029     , p14_a79 out nocopy JTF_VARCHAR2_TABLE_100
1030     , p14_a80 out nocopy JTF_NUMBER_TABLE
1031     , p14_a81 out nocopy JTF_NUMBER_TABLE
1032     , p14_a82 out nocopy JTF_NUMBER_TABLE
1033     , p14_a83 out nocopy JTF_DATE_TABLE
1034     , p14_a84 out nocopy JTF_VARCHAR2_TABLE_100
1035     , p14_a85 out nocopy JTF_VARCHAR2_TABLE_100
1036     , p14_a86 out nocopy JTF_VARCHAR2_TABLE_100
1037     , p14_a87 out nocopy JTF_NUMBER_TABLE
1038     , p14_a88 out nocopy JTF_VARCHAR2_TABLE_100
1039     , p14_a89 out nocopy JTF_NUMBER_TABLE
1040     , p14_a90 out nocopy JTF_NUMBER_TABLE
1041     , p14_a91 out nocopy JTF_VARCHAR2_TABLE_100
1042     , p14_a92 out nocopy JTF_NUMBER_TABLE
1043     , p14_a93 out nocopy JTF_VARCHAR2_TABLE_100
1044     , p14_a94 out nocopy JTF_NUMBER_TABLE
1045     , p14_a95 out nocopy JTF_DATE_TABLE
1046     , p14_a96 out nocopy JTF_VARCHAR2_TABLE_300
1047     , p14_a97 out nocopy JTF_VARCHAR2_TABLE_300
1048     , p14_a98 out nocopy JTF_VARCHAR2_TABLE_300
1049     , p14_a99 out nocopy JTF_VARCHAR2_TABLE_300
1050     , p14_a100 out nocopy JTF_VARCHAR2_TABLE_300
1051     , p14_a101 out nocopy JTF_VARCHAR2_TABLE_300
1052     , p14_a102 out nocopy JTF_VARCHAR2_TABLE_300
1053     , p14_a103 out nocopy JTF_VARCHAR2_TABLE_300
1057     , p14_a107 out nocopy JTF_VARCHAR2_TABLE_300
1054     , p14_a104 out nocopy JTF_VARCHAR2_TABLE_300
1055     , p14_a105 out nocopy JTF_VARCHAR2_TABLE_300
1056     , p14_a106 out nocopy JTF_VARCHAR2_TABLE_300
1058     , p14_a108 out nocopy JTF_VARCHAR2_TABLE_300
1059     , p14_a109 out nocopy JTF_VARCHAR2_TABLE_300
1060     , p14_a110 out nocopy JTF_VARCHAR2_TABLE_300
1061     , p14_a111 out nocopy JTF_NUMBER_TABLE
1062     , p14_a112 out nocopy JTF_VARCHAR2_TABLE_100
1063     , p14_a113 out nocopy JTF_NUMBER_TABLE
1064     , p14_a114 out nocopy JTF_VARCHAR2_TABLE_100
1065     , p14_a115 out nocopy JTF_NUMBER_TABLE
1066     , p14_a116 out nocopy JTF_VARCHAR2_TABLE_100
1067     , p14_a117 out nocopy JTF_VARCHAR2_TABLE_100
1068     , p14_a118 out nocopy JTF_NUMBER_TABLE
1069     , p14_a119 out nocopy JTF_VARCHAR2_TABLE_100
1070     , p14_a120 out nocopy JTF_NUMBER_TABLE
1071     , p14_a121 out nocopy JTF_NUMBER_TABLE
1072     , p14_a122 out nocopy JTF_VARCHAR2_TABLE_100
1073     , x_return_status out nocopy  VARCHAR2
1074     , x_msg_count out nocopy  NUMBER
1075     , x_msg_data out nocopy  VARCHAR2
1076     , p4_a0  NUMBER := 0-1962.0724
1077     , p4_a1  VARCHAR2 := fnd_api.g_miss_char
1078     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
1079     , p4_a3  NUMBER := 0-1962.0724
1080     , p4_a4  NUMBER := 0-1962.0724
1081     , p4_a5  VARCHAR2 := fnd_api.g_miss_char
1082     , p4_a6  NUMBER := 0-1962.0724
1083     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
1084     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
1085     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
1086     , p4_a10  NUMBER := 0-1962.0724
1087     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
1088     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
1089     , p4_a13  NUMBER := 0-1962.0724
1090     , p4_a14  NUMBER := 0-1962.0724
1091     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
1092     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
1093     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
1094     , p4_a18  NUMBER := 0-1962.0724
1095     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
1096     , p4_a20  DATE := fnd_api.g_miss_date
1097     , p4_a21  DATE := fnd_api.g_miss_date
1098     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
1099     , p4_a23  NUMBER := 0-1962.0724
1100     , p4_a24  NUMBER := 0-1962.0724
1101     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
1102     , p4_a26  NUMBER := 0-1962.0724
1103     , p4_a27  NUMBER := 0-1962.0724
1104     , p4_a28  NUMBER := 0-1962.0724
1105     , p4_a29  NUMBER := 0-1962.0724
1106     , p4_a30  NUMBER := 0-1962.0724
1107     , p4_a31  NUMBER := 0-1962.0724
1108     , p4_a32  NUMBER := 0-1962.0724
1109     , p4_a33  NUMBER := 0-1962.0724
1110     , p4_a34  NUMBER := 0-1962.0724
1111     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
1112     , p4_a36  NUMBER := 0-1962.0724
1113     , p4_a37  NUMBER := 0-1962.0724
1114     , p4_a38  NUMBER := 0-1962.0724
1115     , p4_a39  NUMBER := 0-1962.0724
1116     , p4_a40  DATE := fnd_api.g_miss_date
1117     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
1118     , p4_a42  DATE := fnd_api.g_miss_date
1119     , p4_a43  DATE := fnd_api.g_miss_date
1120     , p4_a44  VARCHAR2 := fnd_api.g_miss_char
1121     , p4_a45  VARCHAR2 := fnd_api.g_miss_char
1122     , p4_a46  VARCHAR2 := fnd_api.g_miss_char
1123     , p4_a47  VARCHAR2 := fnd_api.g_miss_char
1124     , p4_a48  VARCHAR2 := fnd_api.g_miss_char
1125     , p4_a49  VARCHAR2 := fnd_api.g_miss_char
1126     , p4_a50  VARCHAR2 := fnd_api.g_miss_char
1127     , p4_a51  VARCHAR2 := fnd_api.g_miss_char
1128     , p4_a52  VARCHAR2 := fnd_api.g_miss_char
1129     , p4_a53  VARCHAR2 := fnd_api.g_miss_char
1130     , p4_a54  VARCHAR2 := fnd_api.g_miss_char
1131     , p4_a55  VARCHAR2 := fnd_api.g_miss_char
1132     , p4_a56  VARCHAR2 := fnd_api.g_miss_char
1133     , p4_a57  VARCHAR2 := fnd_api.g_miss_char
1134     , p4_a58  VARCHAR2 := fnd_api.g_miss_char
1135     , p4_a59  VARCHAR2 := fnd_api.g_miss_char
1136     , p4_a60  VARCHAR2 := fnd_api.g_miss_char
1137     , p4_a61  VARCHAR2 := fnd_api.g_miss_char
1138     , p4_a62  VARCHAR2 := fnd_api.g_miss_char
1139     , p4_a63  VARCHAR2 := fnd_api.g_miss_char
1140     , p4_a64  NUMBER := 0-1962.0724
1141     , p4_a65  NUMBER := 0-1962.0724
1142     , p4_a66  VARCHAR2 := fnd_api.g_miss_char
1143     , p4_a67  NUMBER := 0-1962.0724
1144     , p4_a68  VARCHAR2 := fnd_api.g_miss_char
1145     , p4_a69  VARCHAR2 := fnd_api.g_miss_char
1146     , p4_a70  VARCHAR2 := fnd_api.g_miss_char
1147     , p4_a71  VARCHAR2 := fnd_api.g_miss_char
1148     , p4_a72  NUMBER := 0-1962.0724
1149     , p4_a73  VARCHAR2 := fnd_api.g_miss_char
1150     , p4_a74  NUMBER := 0-1962.0724
1151     , p4_a75  NUMBER := 0-1962.0724
1152     , p4_a76  NUMBER := 0-1962.0724
1153     , p4_a77  VARCHAR2 := fnd_api.g_miss_char
1154     , p4_a78  VARCHAR2 := fnd_api.g_miss_char
1155     , p4_a79  VARCHAR2 := fnd_api.g_miss_char
1156     , p4_a80  NUMBER := 0-1962.0724
1157     , p4_a81  NUMBER := 0-1962.0724
1158     , p4_a82  NUMBER := 0-1962.0724
1159     , p4_a83  DATE := fnd_api.g_miss_date
1160     , p4_a84  VARCHAR2 := fnd_api.g_miss_char
1161     , p4_a85  VARCHAR2 := fnd_api.g_miss_char
1162     , p4_a86  VARCHAR2 := fnd_api.g_miss_char
1163     , p4_a87  NUMBER := 0-1962.0724
1164     , p4_a88  VARCHAR2 := fnd_api.g_miss_char
1165     , p4_a89  NUMBER := 0-1962.0724
1166     , p4_a90  NUMBER := 0-1962.0724
1167     , p4_a91  VARCHAR2 := fnd_api.g_miss_char
1168     , p4_a92  NUMBER := 0-1962.0724
1169     , p4_a93  VARCHAR2 := fnd_api.g_miss_char
1170     , p4_a94  NUMBER := 0-1962.0724
1171     , p4_a95  DATE := fnd_api.g_miss_date
1175     , p4_a99  VARCHAR2 := fnd_api.g_miss_char
1172     , p4_a96  VARCHAR2 := fnd_api.g_miss_char
1173     , p4_a97  VARCHAR2 := fnd_api.g_miss_char
1174     , p4_a98  VARCHAR2 := fnd_api.g_miss_char
1176     , p4_a100  VARCHAR2 := fnd_api.g_miss_char
1177     , p4_a101  VARCHAR2 := fnd_api.g_miss_char
1178     , p4_a102  VARCHAR2 := fnd_api.g_miss_char
1179     , p4_a103  VARCHAR2 := fnd_api.g_miss_char
1180     , p4_a104  VARCHAR2 := fnd_api.g_miss_char
1181     , p4_a105  VARCHAR2 := fnd_api.g_miss_char
1182     , p4_a106  VARCHAR2 := fnd_api.g_miss_char
1183     , p4_a107  VARCHAR2 := fnd_api.g_miss_char
1184     , p4_a108  VARCHAR2 := fnd_api.g_miss_char
1185     , p4_a109  VARCHAR2 := fnd_api.g_miss_char
1186     , p4_a110  VARCHAR2 := fnd_api.g_miss_char
1187     , p4_a111  NUMBER := 0-1962.0724
1188     , p4_a112  VARCHAR2 := fnd_api.g_miss_char
1189     , p4_a113  NUMBER := 0-1962.0724
1190     , p4_a114  VARCHAR2 := fnd_api.g_miss_char
1191     , p4_a115  NUMBER := 0-1962.0724
1192     , p4_a116  VARCHAR2 := fnd_api.g_miss_char
1193     , p4_a117  VARCHAR2 := fnd_api.g_miss_char
1194     , p4_a118  NUMBER := 0-1962.0724
1195     , p4_a119  VARCHAR2 := fnd_api.g_miss_char
1196     , p4_a120  NUMBER := 0-1962.0724
1197     , p4_a121  NUMBER := 0-1962.0724
1198     , p4_a122  VARCHAR2 := fnd_api.g_miss_char
1199   );
1200   procedure getcontracts(product_id  NUMBER
1201     , x_return_status out nocopy  VARCHAR2
1202     , x_msg_count out nocopy  NUMBER
1203     , x_msg_data out nocopy  VARCHAR2
1204     , p4_a0 out nocopy JTF_NUMBER_TABLE
1205     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
1206     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
1207     , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1208     , p4_a4 out nocopy JTF_NUMBER_TABLE
1209     , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
1210     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
1211     , p4_a7 out nocopy JTF_NUMBER_TABLE
1212     , p4_a8 out nocopy JTF_VARCHAR2_TABLE_200
1213     , p4_a9 out nocopy JTF_VARCHAR2_TABLE_2000
1214     , p4_a10 out nocopy JTF_DATE_TABLE
1215     , p4_a11 out nocopy JTF_DATE_TABLE
1216     , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
1217     , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
1218     , p4_a14 out nocopy JTF_DATE_TABLE
1219     , p4_a15 out nocopy JTF_DATE_TABLE
1220     , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
1221     , p4_a17 out nocopy JTF_VARCHAR2_TABLE_2000
1222     , p4_a18 out nocopy JTF_DATE_TABLE
1223   );
1224   procedure get_coverage_for_prod_sch(contract_number  VARCHAR2
1225     , p1_a0 out nocopy JTF_VARCHAR2_TABLE_100
1226     , p1_a1 out nocopy JTF_NUMBER_TABLE
1227     , x_sequence_id out nocopy  NUMBER
1228     , x_return_status out nocopy  VARCHAR2
1229     , x_msg_count out nocopy  NUMBER
1230     , x_msg_data out nocopy  VARCHAR2
1231   );
1232   procedure get_history_transactions(p_api_version  NUMBER
1233     , p_commit  VARCHAR2
1234     , p_init_msg_list  VARCHAR2
1235     , p_validation_level  NUMBER
1236     , p_transaction_id  NUMBER
1237     , p_instance_id  NUMBER
1238     , p6_a0 out nocopy JTF_NUMBER_TABLE
1239     , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1240     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1241     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1242     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1243     , p6_a5 out nocopy JTF_NUMBER_TABLE
1244     , p6_a6 out nocopy JTF_NUMBER_TABLE
1245     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1246     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1247     , p6_a9 out nocopy JTF_NUMBER_TABLE
1248     , p6_a10 out nocopy JTF_NUMBER_TABLE
1249     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1250     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1251     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1252     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1253     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1254     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1255     , p6_a17 out nocopy JTF_NUMBER_TABLE
1256     , p6_a18 out nocopy JTF_NUMBER_TABLE
1257     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1258     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1259     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1260     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1261     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1262     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1263     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1264     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
1265     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
1266     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
1267     , p6_a29 out nocopy JTF_NUMBER_TABLE
1268     , p6_a30 out nocopy JTF_NUMBER_TABLE
1269     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1270     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
1271     , p6_a33 out nocopy JTF_NUMBER_TABLE
1272     , p6_a34 out nocopy JTF_NUMBER_TABLE
1273     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1274     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1275     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1276     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1277     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1278     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1279     , p6_a41 out nocopy JTF_NUMBER_TABLE
1280     , p6_a42 out nocopy JTF_NUMBER_TABLE
1281     , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
1282     , p6_a44 out nocopy JTF_VARCHAR2_TABLE_100
1283     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
1284     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_100
1285     , p6_a47 out nocopy JTF_VARCHAR2_TABLE_300
1286     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_300
1287     , p6_a49 out nocopy JTF_DATE_TABLE
1288     , p6_a50 out nocopy JTF_DATE_TABLE
1292     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1289     , p6_a51 out nocopy JTF_DATE_TABLE
1290     , p6_a52 out nocopy JTF_DATE_TABLE
1291     , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1293     , p6_a55 out nocopy JTF_NUMBER_TABLE
1294     , p6_a56 out nocopy JTF_NUMBER_TABLE
1295     , p6_a57 out nocopy JTF_NUMBER_TABLE
1296     , p6_a58 out nocopy JTF_NUMBER_TABLE
1297     , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
1298     , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
1299     , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1300     , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1301     , p6_a63 out nocopy JTF_NUMBER_TABLE
1302     , p6_a64 out nocopy JTF_NUMBER_TABLE
1303     , p6_a65 out nocopy JTF_NUMBER_TABLE
1304     , p6_a66 out nocopy JTF_NUMBER_TABLE
1305     , p6_a67 out nocopy JTF_NUMBER_TABLE
1306     , p6_a68 out nocopy JTF_NUMBER_TABLE
1307     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
1308     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
1309     , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
1310     , p6_a72 out nocopy JTF_VARCHAR2_TABLE_100
1311     , p6_a73 out nocopy JTF_VARCHAR2_TABLE_100
1312     , p6_a74 out nocopy JTF_VARCHAR2_TABLE_100
1313     , p6_a75 out nocopy JTF_VARCHAR2_TABLE_100
1314     , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
1315     , p6_a77 out nocopy JTF_NUMBER_TABLE
1316     , p6_a78 out nocopy JTF_NUMBER_TABLE
1317     , p6_a79 out nocopy JTF_NUMBER_TABLE
1318     , p6_a80 out nocopy JTF_NUMBER_TABLE
1319     , p6_a81 out nocopy JTF_NUMBER_TABLE
1320     , p6_a82 out nocopy JTF_NUMBER_TABLE
1321     , p6_a83 out nocopy JTF_NUMBER_TABLE
1322     , p6_a84 out nocopy JTF_NUMBER_TABLE
1323     , p6_a85 out nocopy JTF_VARCHAR2_TABLE_300
1324     , p6_a86 out nocopy JTF_VARCHAR2_TABLE_300
1325     , p6_a87 out nocopy JTF_NUMBER_TABLE
1326     , p6_a88 out nocopy JTF_NUMBER_TABLE
1327     , p6_a89 out nocopy JTF_NUMBER_TABLE
1328     , p6_a90 out nocopy JTF_NUMBER_TABLE
1329     , p6_a91 out nocopy JTF_NUMBER_TABLE
1330     , p6_a92 out nocopy JTF_NUMBER_TABLE
1331     , p6_a93 out nocopy JTF_NUMBER_TABLE
1332     , p6_a94 out nocopy JTF_NUMBER_TABLE
1333     , p6_a95 out nocopy JTF_VARCHAR2_TABLE_100
1334     , p6_a96 out nocopy JTF_VARCHAR2_TABLE_100
1335     , p6_a97 out nocopy JTF_NUMBER_TABLE
1336     , p6_a98 out nocopy JTF_NUMBER_TABLE
1337     , p6_a99 out nocopy JTF_NUMBER_TABLE
1338     , p6_a100 out nocopy JTF_NUMBER_TABLE
1339     , p6_a101 out nocopy JTF_NUMBER_TABLE
1340     , p6_a102 out nocopy JTF_NUMBER_TABLE
1341     , p6_a103 out nocopy JTF_NUMBER_TABLE
1342     , p6_a104 out nocopy JTF_NUMBER_TABLE
1343     , p6_a105 out nocopy JTF_DATE_TABLE
1344     , p6_a106 out nocopy JTF_DATE_TABLE
1345     , p6_a107 out nocopy JTF_VARCHAR2_TABLE_100
1346     , p6_a108 out nocopy JTF_VARCHAR2_TABLE_100
1347     , p6_a109 out nocopy JTF_DATE_TABLE
1348     , p6_a110 out nocopy JTF_DATE_TABLE
1349     , p6_a111 out nocopy JTF_DATE_TABLE
1350     , p6_a112 out nocopy JTF_DATE_TABLE
1351     , p6_a113 out nocopy JTF_VARCHAR2_TABLE_100
1352     , p6_a114 out nocopy JTF_VARCHAR2_TABLE_100
1353     , p6_a115 out nocopy JTF_VARCHAR2_TABLE_100
1354     , p6_a116 out nocopy JTF_VARCHAR2_TABLE_100
1355     , p6_a117 out nocopy JTF_VARCHAR2_TABLE_100
1356     , p6_a118 out nocopy JTF_VARCHAR2_TABLE_100
1357     , p6_a119 out nocopy JTF_VARCHAR2_TABLE_300
1358     , p6_a120 out nocopy JTF_VARCHAR2_TABLE_300
1359     , p6_a121 out nocopy JTF_VARCHAR2_TABLE_300
1360     , p6_a122 out nocopy JTF_VARCHAR2_TABLE_300
1361     , p6_a123 out nocopy JTF_VARCHAR2_TABLE_300
1362     , p6_a124 out nocopy JTF_VARCHAR2_TABLE_300
1363     , p6_a125 out nocopy JTF_VARCHAR2_TABLE_300
1364     , p6_a126 out nocopy JTF_VARCHAR2_TABLE_300
1365     , p6_a127 out nocopy JTF_VARCHAR2_TABLE_300
1366     , p6_a128 out nocopy JTF_VARCHAR2_TABLE_300
1367     , p6_a129 out nocopy JTF_VARCHAR2_TABLE_300
1368     , p6_a130 out nocopy JTF_VARCHAR2_TABLE_300
1369     , p6_a131 out nocopy JTF_VARCHAR2_TABLE_300
1370     , p6_a132 out nocopy JTF_VARCHAR2_TABLE_300
1371     , p6_a133 out nocopy JTF_VARCHAR2_TABLE_300
1372     , p6_a134 out nocopy JTF_VARCHAR2_TABLE_300
1373     , p6_a135 out nocopy JTF_VARCHAR2_TABLE_300
1374     , p6_a136 out nocopy JTF_VARCHAR2_TABLE_300
1375     , p6_a137 out nocopy JTF_VARCHAR2_TABLE_300
1376     , p6_a138 out nocopy JTF_VARCHAR2_TABLE_300
1377     , p6_a139 out nocopy JTF_VARCHAR2_TABLE_300
1378     , p6_a140 out nocopy JTF_VARCHAR2_TABLE_300
1379     , p6_a141 out nocopy JTF_VARCHAR2_TABLE_300
1380     , p6_a142 out nocopy JTF_VARCHAR2_TABLE_300
1381     , p6_a143 out nocopy JTF_VARCHAR2_TABLE_300
1382     , p6_a144 out nocopy JTF_VARCHAR2_TABLE_300
1383     , p6_a145 out nocopy JTF_VARCHAR2_TABLE_300
1384     , p6_a146 out nocopy JTF_VARCHAR2_TABLE_300
1385     , p6_a147 out nocopy JTF_VARCHAR2_TABLE_300
1386     , p6_a148 out nocopy JTF_VARCHAR2_TABLE_300
1387     , p6_a149 out nocopy JTF_NUMBER_TABLE
1388     , p6_a150 out nocopy JTF_NUMBER_TABLE
1389     , p6_a151 out nocopy JTF_VARCHAR2_TABLE_100
1390     , p6_a152 out nocopy JTF_VARCHAR2_TABLE_100
1391     , p6_a153 out nocopy JTF_NUMBER_TABLE
1392     , p6_a154 out nocopy JTF_NUMBER_TABLE
1393     , p6_a155 out nocopy JTF_VARCHAR2_TABLE_100
1394     , p6_a156 out nocopy JTF_VARCHAR2_TABLE_100
1395     , p6_a157 out nocopy JTF_VARCHAR2_TABLE_300
1396     , p6_a158 out nocopy JTF_VARCHAR2_TABLE_300
1397     , p6_a159 out nocopy JTF_VARCHAR2_TABLE_300
1398     , p6_a160 out nocopy JTF_VARCHAR2_TABLE_300
1399     , p6_a161 out nocopy JTF_VARCHAR2_TABLE_300
1400     , p6_a162 out nocopy JTF_VARCHAR2_TABLE_300
1401     , p6_a163 out nocopy JTF_VARCHAR2_TABLE_300
1405     , p6_a167 out nocopy JTF_VARCHAR2_TABLE_100
1402     , p6_a164 out nocopy JTF_VARCHAR2_TABLE_300
1403     , p6_a165 out nocopy JTF_VARCHAR2_TABLE_100
1404     , p6_a166 out nocopy JTF_VARCHAR2_TABLE_100
1406     , p6_a168 out nocopy JTF_VARCHAR2_TABLE_100
1407     , p6_a169 out nocopy JTF_VARCHAR2_TABLE_100
1408     , p6_a170 out nocopy JTF_VARCHAR2_TABLE_100
1409     , p6_a171 out nocopy JTF_NUMBER_TABLE
1410     , p6_a172 out nocopy JTF_NUMBER_TABLE
1411     , p6_a173 out nocopy JTF_NUMBER_TABLE
1412     , p6_a174 out nocopy JTF_NUMBER_TABLE
1413     , p6_a175 out nocopy JTF_DATE_TABLE
1414     , p6_a176 out nocopy JTF_DATE_TABLE
1415     , p6_a177 out nocopy JTF_VARCHAR2_TABLE_100
1416     , p6_a178 out nocopy JTF_VARCHAR2_TABLE_100
1417     , p6_a179 out nocopy JTF_VARCHAR2_TABLE_100
1418     , p6_a180 out nocopy JTF_VARCHAR2_TABLE_100
1419     , p6_a181 out nocopy JTF_VARCHAR2_TABLE_100
1420     , p6_a182 out nocopy JTF_VARCHAR2_TABLE_100
1421     , p6_a183 out nocopy JTF_VARCHAR2_TABLE_300
1422     , p6_a184 out nocopy JTF_VARCHAR2_TABLE_300
1423     , p6_a185 out nocopy JTF_VARCHAR2_TABLE_300
1424     , p6_a186 out nocopy JTF_VARCHAR2_TABLE_300
1425     , p6_a187 out nocopy JTF_VARCHAR2_TABLE_300
1426     , p6_a188 out nocopy JTF_VARCHAR2_TABLE_300
1427     , p6_a189 out nocopy JTF_VARCHAR2_TABLE_300
1428     , p6_a190 out nocopy JTF_VARCHAR2_TABLE_300
1429     , p6_a191 out nocopy JTF_VARCHAR2_TABLE_100
1430     , p6_a192 out nocopy JTF_VARCHAR2_TABLE_100
1431     , p6_a193 out nocopy JTF_VARCHAR2_TABLE_100
1432     , p6_a194 out nocopy JTF_VARCHAR2_TABLE_100
1433     , p6_a195 out nocopy JTF_VARCHAR2_TABLE_100
1434     , p6_a196 out nocopy JTF_VARCHAR2_TABLE_100
1435     , p6_a197 out nocopy JTF_VARCHAR2_TABLE_100
1436     , p6_a198 out nocopy JTF_VARCHAR2_TABLE_100
1437     , p6_a199 out nocopy JTF_NUMBER_TABLE
1438     , p6_a200 out nocopy JTF_NUMBER_TABLE
1439     , p6_a201 out nocopy JTF_VARCHAR2_TABLE_100
1440     , p6_a202 out nocopy JTF_VARCHAR2_TABLE_100
1441     , p6_a203 out nocopy JTF_VARCHAR2_TABLE_300
1442     , p6_a204 out nocopy JTF_VARCHAR2_TABLE_300
1443     , p6_a205 out nocopy JTF_NUMBER_TABLE
1444     , p6_a206 out nocopy JTF_NUMBER_TABLE
1445     , p6_a207 out nocopy JTF_NUMBER_TABLE
1446     , p6_a208 out nocopy JTF_NUMBER_TABLE
1447     , p6_a209 out nocopy JTF_VARCHAR2_TABLE_300
1448     , p6_a210 out nocopy JTF_VARCHAR2_TABLE_300
1449     , p6_a211 out nocopy JTF_VARCHAR2_TABLE_300
1450     , p6_a212 out nocopy JTF_VARCHAR2_TABLE_300
1451     , p6_a213 out nocopy JTF_VARCHAR2_TABLE_100
1452     , p6_a214 out nocopy JTF_VARCHAR2_TABLE_100
1453     , p6_a215 out nocopy JTF_VARCHAR2_TABLE_100
1454     , p6_a216 out nocopy JTF_VARCHAR2_TABLE_100
1455     , p6_a217 out nocopy JTF_VARCHAR2_TABLE_100
1456     , p6_a218 out nocopy JTF_VARCHAR2_TABLE_100
1457     , p6_a219 out nocopy JTF_VARCHAR2_TABLE_100
1458     , p6_a220 out nocopy JTF_VARCHAR2_TABLE_100
1459     , p6_a221 out nocopy JTF_NUMBER_TABLE
1460     , p6_a222 out nocopy JTF_NUMBER_TABLE
1461     , p6_a223 out nocopy JTF_VARCHAR2_TABLE_100
1462     , p6_a224 out nocopy JTF_VARCHAR2_TABLE_100
1463     , p6_a225 out nocopy JTF_VARCHAR2_TABLE_100
1464     , p6_a226 out nocopy JTF_VARCHAR2_TABLE_100
1465     , p6_a227 out nocopy JTF_NUMBER_TABLE
1466     , p6_a228 out nocopy JTF_NUMBER_TABLE
1467     , p6_a229 out nocopy JTF_VARCHAR2_TABLE_200
1468     , p6_a230 out nocopy JTF_VARCHAR2_TABLE_200
1469     , p6_a231 out nocopy JTF_VARCHAR2_TABLE_100
1470     , p6_a232 out nocopy JTF_VARCHAR2_TABLE_100
1471     , p6_a233 out nocopy JTF_NUMBER_TABLE
1472     , p6_a234 out nocopy JTF_NUMBER_TABLE
1473     , p6_a235 out nocopy JTF_VARCHAR2_TABLE_100
1474     , p6_a236 out nocopy JTF_VARCHAR2_TABLE_100
1475     , p6_a237 out nocopy JTF_NUMBER_TABLE
1476     , p6_a238 out nocopy JTF_NUMBER_TABLE
1477     , p6_a239 out nocopy JTF_VARCHAR2_TABLE_100
1478     , p6_a240 out nocopy JTF_VARCHAR2_TABLE_100
1479     , p6_a241 out nocopy JTF_NUMBER_TABLE
1480     , p6_a242 out nocopy JTF_NUMBER_TABLE
1481     , p6_a243 out nocopy JTF_DATE_TABLE
1482     , p6_a244 out nocopy JTF_DATE_TABLE
1483     , p6_a245 out nocopy JTF_VARCHAR2_TABLE_300
1484     , p6_a246 out nocopy JTF_VARCHAR2_TABLE_300
1485     , p6_a247 out nocopy JTF_VARCHAR2_TABLE_300
1486     , p6_a248 out nocopy JTF_VARCHAR2_TABLE_300
1487     , p6_a249 out nocopy JTF_VARCHAR2_TABLE_300
1488     , p6_a250 out nocopy JTF_VARCHAR2_TABLE_300
1489     , p6_a251 out nocopy JTF_VARCHAR2_TABLE_300
1490     , p6_a252 out nocopy JTF_VARCHAR2_TABLE_300
1491     , p6_a253 out nocopy JTF_VARCHAR2_TABLE_300
1492     , p6_a254 out nocopy JTF_VARCHAR2_TABLE_300
1493     , p6_a255 out nocopy JTF_VARCHAR2_TABLE_300
1494     , p6_a256 out nocopy JTF_VARCHAR2_TABLE_300
1495     , p6_a257 out nocopy JTF_VARCHAR2_TABLE_300
1496     , p6_a258 out nocopy JTF_VARCHAR2_TABLE_300
1497     , p6_a259 out nocopy JTF_VARCHAR2_TABLE_300
1498     , p6_a260 out nocopy JTF_VARCHAR2_TABLE_300
1499     , p6_a261 out nocopy JTF_VARCHAR2_TABLE_300
1500     , p6_a262 out nocopy JTF_VARCHAR2_TABLE_300
1501     , p6_a263 out nocopy JTF_VARCHAR2_TABLE_300
1502     , p6_a264 out nocopy JTF_VARCHAR2_TABLE_300
1503     , p6_a265 out nocopy JTF_VARCHAR2_TABLE_300
1504     , p6_a266 out nocopy JTF_VARCHAR2_TABLE_300
1505     , p6_a267 out nocopy JTF_VARCHAR2_TABLE_300
1506     , p6_a268 out nocopy JTF_VARCHAR2_TABLE_300
1507     , p6_a269 out nocopy JTF_VARCHAR2_TABLE_300
1508     , p6_a270 out nocopy JTF_VARCHAR2_TABLE_300
1509     , p6_a271 out nocopy JTF_VARCHAR2_TABLE_300
1510     , p6_a272 out nocopy JTF_VARCHAR2_TABLE_300
1514     , p6_a276 out nocopy JTF_VARCHAR2_TABLE_100
1511     , p6_a273 out nocopy JTF_VARCHAR2_TABLE_300
1512     , p6_a274 out nocopy JTF_VARCHAR2_TABLE_300
1513     , p6_a275 out nocopy JTF_VARCHAR2_TABLE_100
1515     , p6_a277 out nocopy JTF_NUMBER_TABLE
1516     , p6_a278 out nocopy JTF_NUMBER_TABLE
1517     , p6_a279 out nocopy JTF_VARCHAR2_TABLE_100
1518     , p6_a280 out nocopy JTF_VARCHAR2_TABLE_100
1519     , p6_a281 out nocopy JTF_NUMBER_TABLE
1520     , p6_a282 out nocopy JTF_NUMBER_TABLE
1521     , p6_a283 out nocopy JTF_NUMBER_TABLE
1522     , p6_a284 out nocopy JTF_NUMBER_TABLE
1523     , p6_a285 out nocopy JTF_VARCHAR2_TABLE_100
1524     , p6_a286 out nocopy JTF_VARCHAR2_TABLE_100
1525     , p6_a287 out nocopy JTF_VARCHAR2_TABLE_100
1526     , p6_a288 out nocopy JTF_VARCHAR2_TABLE_100
1527     , p6_a289 out nocopy JTF_VARCHAR2_TABLE_100
1528     , p6_a290 out nocopy JTF_VARCHAR2_TABLE_100
1529     , p6_a291 out nocopy JTF_VARCHAR2_TABLE_100
1530     , p7_a0 out nocopy JTF_NUMBER_TABLE
1531     , p7_a1 out nocopy JTF_NUMBER_TABLE
1532     , p7_a2 out nocopy JTF_NUMBER_TABLE
1533     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1534     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1535     , p7_a5 out nocopy JTF_NUMBER_TABLE
1536     , p7_a6 out nocopy JTF_NUMBER_TABLE
1537     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
1538     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1539     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1540     , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
1541     , p7_a11 out nocopy JTF_NUMBER_TABLE
1542     , p7_a12 out nocopy JTF_NUMBER_TABLE
1543     , p7_a13 out nocopy JTF_DATE_TABLE
1544     , p7_a14 out nocopy JTF_DATE_TABLE
1545     , p7_a15 out nocopy JTF_DATE_TABLE
1546     , p7_a16 out nocopy JTF_DATE_TABLE
1547     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1548     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
1549     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
1550     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
1551     , p7_a21 out nocopy JTF_VARCHAR2_TABLE_200
1552     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
1553     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_200
1554     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
1555     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
1556     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_200
1557     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
1558     , p7_a28 out nocopy JTF_VARCHAR2_TABLE_200
1559     , p7_a29 out nocopy JTF_VARCHAR2_TABLE_200
1560     , p7_a30 out nocopy JTF_VARCHAR2_TABLE_200
1561     , p7_a31 out nocopy JTF_VARCHAR2_TABLE_200
1562     , p7_a32 out nocopy JTF_VARCHAR2_TABLE_200
1563     , p7_a33 out nocopy JTF_VARCHAR2_TABLE_200
1564     , p7_a34 out nocopy JTF_VARCHAR2_TABLE_200
1565     , p7_a35 out nocopy JTF_VARCHAR2_TABLE_200
1566     , p7_a36 out nocopy JTF_VARCHAR2_TABLE_200
1567     , p7_a37 out nocopy JTF_VARCHAR2_TABLE_200
1568     , p7_a38 out nocopy JTF_VARCHAR2_TABLE_200
1569     , p7_a39 out nocopy JTF_VARCHAR2_TABLE_200
1570     , p7_a40 out nocopy JTF_VARCHAR2_TABLE_200
1571     , p7_a41 out nocopy JTF_VARCHAR2_TABLE_200
1572     , p7_a42 out nocopy JTF_VARCHAR2_TABLE_200
1573     , p7_a43 out nocopy JTF_VARCHAR2_TABLE_200
1574     , p7_a44 out nocopy JTF_VARCHAR2_TABLE_200
1575     , p7_a45 out nocopy JTF_VARCHAR2_TABLE_200
1576     , p7_a46 out nocopy JTF_VARCHAR2_TABLE_200
1577     , p7_a47 out nocopy JTF_VARCHAR2_TABLE_200
1578     , p7_a48 out nocopy JTF_VARCHAR2_TABLE_200
1579     , p7_a49 out nocopy JTF_VARCHAR2_TABLE_100
1580     , p7_a50 out nocopy JTF_NUMBER_TABLE
1581     , p7_a51 out nocopy JTF_VARCHAR2_TABLE_100
1582     , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
1583     , p7_a53 out nocopy JTF_VARCHAR2_TABLE_100
1584     , p7_a54 out nocopy JTF_VARCHAR2_TABLE_100
1585     , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
1586     , p7_a56 out nocopy JTF_VARCHAR2_TABLE_400
1587     , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
1588     , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
1589     , p7_a59 out nocopy JTF_VARCHAR2_TABLE_400
1590     , p7_a60 out nocopy JTF_VARCHAR2_TABLE_100
1591     , p7_a61 out nocopy JTF_VARCHAR2_TABLE_300
1592     , p7_a62 out nocopy JTF_VARCHAR2_TABLE_300
1593     , p7_a63 out nocopy JTF_VARCHAR2_TABLE_300
1594     , p7_a64 out nocopy JTF_VARCHAR2_TABLE_300
1595     , p7_a65 out nocopy JTF_VARCHAR2_TABLE_100
1596     , p7_a66 out nocopy JTF_VARCHAR2_TABLE_100
1597     , p7_a67 out nocopy JTF_VARCHAR2_TABLE_100
1598     , p7_a68 out nocopy JTF_VARCHAR2_TABLE_100
1599     , p7_a69 out nocopy JTF_VARCHAR2_TABLE_100
1600     , p7_a70 out nocopy JTF_VARCHAR2_TABLE_2000
1601     , p7_a71 out nocopy JTF_VARCHAR2_TABLE_100
1602     , p7_a72 out nocopy JTF_VARCHAR2_TABLE_400
1603     , p7_a73 out nocopy JTF_VARCHAR2_TABLE_100
1604     , p7_a74 out nocopy JTF_VARCHAR2_TABLE_100
1605     , p7_a75 out nocopy JTF_VARCHAR2_TABLE_400
1606     , p7_a76 out nocopy JTF_VARCHAR2_TABLE_100
1607     , p7_a77 out nocopy JTF_VARCHAR2_TABLE_300
1608     , p7_a78 out nocopy JTF_VARCHAR2_TABLE_300
1609     , p7_a79 out nocopy JTF_VARCHAR2_TABLE_300
1610     , p7_a80 out nocopy JTF_VARCHAR2_TABLE_300
1611     , p7_a81 out nocopy JTF_VARCHAR2_TABLE_100
1612     , p7_a82 out nocopy JTF_VARCHAR2_TABLE_100
1613     , p7_a83 out nocopy JTF_VARCHAR2_TABLE_100
1614     , p7_a84 out nocopy JTF_VARCHAR2_TABLE_100
1615     , p7_a85 out nocopy JTF_VARCHAR2_TABLE_100
1616     , p7_a86 out nocopy JTF_VARCHAR2_TABLE_2000
1617     , p7_a87 out nocopy JTF_NUMBER_TABLE
1618     , p8_a0 out nocopy JTF_NUMBER_TABLE
1619     , p8_a1 out nocopy JTF_NUMBER_TABLE
1620     , p8_a2 out nocopy JTF_NUMBER_TABLE
1624     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
1621     , p8_a3 out nocopy JTF_NUMBER_TABLE
1622     , p8_a4 out nocopy JTF_NUMBER_TABLE
1623     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1625     , p8_a7 out nocopy JTF_DATE_TABLE
1626     , p8_a8 out nocopy JTF_DATE_TABLE
1627     , p8_a9 out nocopy JTF_DATE_TABLE
1628     , p8_a10 out nocopy JTF_DATE_TABLE
1629     , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1630     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1631     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
1632     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
1633     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_200
1634     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
1635     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
1636     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
1637     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200
1638     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_200
1639     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
1640     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
1641     , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
1642     , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
1643     , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
1644     , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
1645     , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
1646     , p8_a28 out nocopy JTF_VARCHAR2_TABLE_200
1647     , p8_a29 out nocopy JTF_VARCHAR2_TABLE_200
1648     , p8_a30 out nocopy JTF_VARCHAR2_TABLE_200
1649     , p8_a31 out nocopy JTF_VARCHAR2_TABLE_200
1650     , p8_a32 out nocopy JTF_VARCHAR2_TABLE_200
1651     , p8_a33 out nocopy JTF_VARCHAR2_TABLE_200
1652     , p8_a34 out nocopy JTF_VARCHAR2_TABLE_200
1653     , p8_a35 out nocopy JTF_VARCHAR2_TABLE_200
1654     , p8_a36 out nocopy JTF_VARCHAR2_TABLE_200
1655     , p8_a37 out nocopy JTF_VARCHAR2_TABLE_200
1656     , p8_a38 out nocopy JTF_VARCHAR2_TABLE_200
1657     , p8_a39 out nocopy JTF_VARCHAR2_TABLE_200
1658     , p8_a40 out nocopy JTF_VARCHAR2_TABLE_200
1659     , p8_a41 out nocopy JTF_VARCHAR2_TABLE_200
1660     , p8_a42 out nocopy JTF_VARCHAR2_TABLE_200
1661     , p8_a43 out nocopy JTF_VARCHAR2_TABLE_100
1662     , p8_a44 out nocopy JTF_NUMBER_TABLE
1663     , p8_a45 out nocopy JTF_NUMBER_TABLE
1664     , p8_a46 out nocopy JTF_NUMBER_TABLE
1665     , p8_a47 out nocopy JTF_NUMBER_TABLE
1666     , p8_a48 out nocopy JTF_NUMBER_TABLE
1667     , p8_a49 out nocopy JTF_VARCHAR2_TABLE_100
1668     , p8_a50 out nocopy JTF_VARCHAR2_TABLE_300
1669     , p8_a51 out nocopy JTF_VARCHAR2_TABLE_100
1670     , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
1671     , p8_a53 out nocopy JTF_VARCHAR2_TABLE_100
1672     , p8_a54 out nocopy JTF_VARCHAR2_TABLE_300
1673     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_100
1674     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
1675     , p8_a57 out nocopy JTF_NUMBER_TABLE
1676     , p8_a58 out nocopy JTF_VARCHAR2_TABLE_300
1677     , p8_a59 out nocopy JTF_VARCHAR2_TABLE_300
1678     , p8_a60 out nocopy JTF_VARCHAR2_TABLE_300
1679     , p8_a61 out nocopy JTF_VARCHAR2_TABLE_300
1680     , p8_a62 out nocopy JTF_VARCHAR2_TABLE_300
1681     , p8_a63 out nocopy JTF_VARCHAR2_TABLE_300
1682     , p8_a64 out nocopy JTF_VARCHAR2_TABLE_300
1683     , p8_a65 out nocopy JTF_VARCHAR2_TABLE_300
1684     , p8_a66 out nocopy JTF_VARCHAR2_TABLE_100
1685     , p8_a67 out nocopy JTF_VARCHAR2_TABLE_100
1686     , p8_a68 out nocopy JTF_VARCHAR2_TABLE_100
1687     , p8_a69 out nocopy JTF_VARCHAR2_TABLE_100
1688     , p8_a70 out nocopy JTF_VARCHAR2_TABLE_100
1689     , p8_a71 out nocopy JTF_VARCHAR2_TABLE_100
1690     , p8_a72 out nocopy JTF_VARCHAR2_TABLE_100
1691     , p8_a73 out nocopy JTF_VARCHAR2_TABLE_100
1692     , p8_a74 out nocopy JTF_VARCHAR2_TABLE_300
1693     , p8_a75 out nocopy JTF_VARCHAR2_TABLE_300
1694     , p8_a76 out nocopy JTF_VARCHAR2_TABLE_300
1695     , p8_a77 out nocopy JTF_VARCHAR2_TABLE_300
1696     , p8_a78 out nocopy JTF_VARCHAR2_TABLE_300
1697     , p8_a79 out nocopy JTF_VARCHAR2_TABLE_300
1698     , p8_a80 out nocopy JTF_VARCHAR2_TABLE_300
1699     , p8_a81 out nocopy JTF_VARCHAR2_TABLE_300
1700     , p8_a82 out nocopy JTF_VARCHAR2_TABLE_100
1701     , p8_a83 out nocopy JTF_VARCHAR2_TABLE_100
1702     , p8_a84 out nocopy JTF_VARCHAR2_TABLE_100
1703     , p8_a85 out nocopy JTF_VARCHAR2_TABLE_100
1704     , p8_a86 out nocopy JTF_VARCHAR2_TABLE_100
1705     , p8_a87 out nocopy JTF_VARCHAR2_TABLE_100
1706     , p8_a88 out nocopy JTF_VARCHAR2_TABLE_100
1707     , p8_a89 out nocopy JTF_VARCHAR2_TABLE_100
1708     , p8_a90 out nocopy JTF_NUMBER_TABLE
1709     , p8_a91 out nocopy JTF_NUMBER_TABLE
1710     , p9_a0 out nocopy JTF_NUMBER_TABLE
1711     , p9_a1 out nocopy JTF_NUMBER_TABLE
1712     , p9_a2 out nocopy JTF_NUMBER_TABLE
1713     , p9_a3 out nocopy JTF_NUMBER_TABLE
1714     , p9_a4 out nocopy JTF_NUMBER_TABLE
1715     , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
1716     , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
1717     , p9_a7 out nocopy JTF_DATE_TABLE
1718     , p9_a8 out nocopy JTF_DATE_TABLE
1719     , p9_a9 out nocopy JTF_DATE_TABLE
1720     , p9_a10 out nocopy JTF_DATE_TABLE
1721     , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
1722     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1723     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
1724     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200
1725     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_200
1726     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_200
1727     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_200
1728     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_200
1729     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_200
1730     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_200
1731     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_200
1735     , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
1732     , p9_a22 out nocopy JTF_VARCHAR2_TABLE_200
1733     , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
1734     , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
1736     , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
1737     , p9_a27 out nocopy JTF_VARCHAR2_TABLE_200
1738     , p9_a28 out nocopy JTF_VARCHAR2_TABLE_200
1739     , p9_a29 out nocopy JTF_VARCHAR2_TABLE_200
1740     , p9_a30 out nocopy JTF_VARCHAR2_TABLE_200
1741     , p9_a31 out nocopy JTF_VARCHAR2_TABLE_200
1742     , p9_a32 out nocopy JTF_VARCHAR2_TABLE_200
1743     , p9_a33 out nocopy JTF_VARCHAR2_TABLE_200
1744     , p9_a34 out nocopy JTF_VARCHAR2_TABLE_200
1745     , p9_a35 out nocopy JTF_VARCHAR2_TABLE_200
1746     , p9_a36 out nocopy JTF_VARCHAR2_TABLE_200
1747     , p9_a37 out nocopy JTF_VARCHAR2_TABLE_200
1748     , p9_a38 out nocopy JTF_VARCHAR2_TABLE_200
1749     , p9_a39 out nocopy JTF_VARCHAR2_TABLE_200
1750     , p9_a40 out nocopy JTF_VARCHAR2_TABLE_200
1751     , p9_a41 out nocopy JTF_VARCHAR2_TABLE_200
1752     , p9_a42 out nocopy JTF_VARCHAR2_TABLE_200
1753     , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
1754     , p9_a44 out nocopy JTF_NUMBER_TABLE
1755     , p9_a45 out nocopy JTF_VARCHAR2_TABLE_100
1756     , p9_a46 out nocopy JTF_VARCHAR2_TABLE_100
1757     , p9_a47 out nocopy JTF_NUMBER_TABLE
1758     , p10_a0 out nocopy JTF_NUMBER_TABLE
1759     , p10_a1 out nocopy JTF_NUMBER_TABLE
1760     , p10_a2 out nocopy JTF_NUMBER_TABLE
1761     , p10_a3 out nocopy JTF_NUMBER_TABLE
1762     , p10_a4 out nocopy JTF_NUMBER_TABLE
1763     , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
1764     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1765     , p10_a7 out nocopy JTF_NUMBER_TABLE
1766     , p10_a8 out nocopy JTF_NUMBER_TABLE
1767     , p10_a9 out nocopy JTF_NUMBER_TABLE
1768     , p10_a10 out nocopy JTF_NUMBER_TABLE
1769     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1770     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1771     , p10_a13 out nocopy JTF_DATE_TABLE
1772     , p10_a14 out nocopy JTF_DATE_TABLE
1773     , p10_a15 out nocopy JTF_DATE_TABLE
1774     , p10_a16 out nocopy JTF_DATE_TABLE
1775     , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
1776     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
1777     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
1778     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
1779     , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
1780     , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
1781     , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
1782     , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
1783     , p10_a25 out nocopy JTF_VARCHAR2_TABLE_100
1784     , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
1785     , p10_a27 out nocopy JTF_VARCHAR2_TABLE_100
1786     , p10_a28 out nocopy JTF_VARCHAR2_TABLE_100
1787     , p10_a29 out nocopy JTF_VARCHAR2_TABLE_100
1788     , p10_a30 out nocopy JTF_VARCHAR2_TABLE_100
1789     , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
1790     , p10_a32 out nocopy JTF_VARCHAR2_TABLE_100
1791     , p10_a33 out nocopy JTF_VARCHAR2_TABLE_100
1792     , p10_a34 out nocopy JTF_VARCHAR2_TABLE_100
1793     , p10_a35 out nocopy JTF_VARCHAR2_TABLE_100
1794     , p10_a36 out nocopy JTF_VARCHAR2_TABLE_100
1795     , p10_a37 out nocopy JTF_VARCHAR2_TABLE_100
1796     , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
1797     , p10_a39 out nocopy JTF_DATE_TABLE
1798     , p10_a40 out nocopy JTF_DATE_TABLE
1799     , p10_a41 out nocopy JTF_VARCHAR2_TABLE_100
1800     , p10_a42 out nocopy JTF_VARCHAR2_TABLE_100
1801     , p10_a43 out nocopy JTF_VARCHAR2_TABLE_300
1802     , p10_a44 out nocopy JTF_VARCHAR2_TABLE_300
1803     , p10_a45 out nocopy JTF_VARCHAR2_TABLE_100
1804     , p10_a46 out nocopy JTF_VARCHAR2_TABLE_100
1805     , p10_a47 out nocopy JTF_NUMBER_TABLE
1806     , p10_a48 out nocopy JTF_NUMBER_TABLE
1807     , p10_a49 out nocopy JTF_NUMBER_TABLE
1808     , p10_a50 out nocopy JTF_VARCHAR2_TABLE_100
1809     , p10_a51 out nocopy JTF_VARCHAR2_TABLE_100
1810     , p10_a52 out nocopy JTF_NUMBER_TABLE
1811     , p10_a53 out nocopy JTF_NUMBER_TABLE
1812     , p10_a54 out nocopy JTF_VARCHAR2_TABLE_100
1813     , p10_a55 out nocopy JTF_VARCHAR2_TABLE_100
1814     , p11_a0 out nocopy JTF_NUMBER_TABLE
1815     , p11_a1 out nocopy JTF_NUMBER_TABLE
1816     , p11_a2 out nocopy JTF_VARCHAR2_TABLE_300
1817     , p11_a3 out nocopy JTF_VARCHAR2_TABLE_300
1818     , p11_a4 out nocopy JTF_DATE_TABLE
1819     , p11_a5 out nocopy JTF_DATE_TABLE
1820     , p11_a6 out nocopy JTF_DATE_TABLE
1821     , p11_a7 out nocopy JTF_DATE_TABLE
1822     , p11_a8 out nocopy JTF_VARCHAR2_TABLE_100
1823     , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
1824     , p11_a10 out nocopy JTF_VARCHAR2_TABLE_200
1825     , p11_a11 out nocopy JTF_VARCHAR2_TABLE_200
1826     , p11_a12 out nocopy JTF_VARCHAR2_TABLE_200
1827     , p11_a13 out nocopy JTF_VARCHAR2_TABLE_200
1828     , p11_a14 out nocopy JTF_VARCHAR2_TABLE_200
1829     , p11_a15 out nocopy JTF_VARCHAR2_TABLE_200
1830     , p11_a16 out nocopy JTF_VARCHAR2_TABLE_200
1831     , p11_a17 out nocopy JTF_VARCHAR2_TABLE_200
1832     , p11_a18 out nocopy JTF_VARCHAR2_TABLE_200
1833     , p11_a19 out nocopy JTF_VARCHAR2_TABLE_200
1834     , p11_a20 out nocopy JTF_VARCHAR2_TABLE_200
1835     , p11_a21 out nocopy JTF_VARCHAR2_TABLE_200
1836     , p11_a22 out nocopy JTF_VARCHAR2_TABLE_200
1837     , p11_a23 out nocopy JTF_VARCHAR2_TABLE_200
1838     , p11_a24 out nocopy JTF_VARCHAR2_TABLE_200
1839     , p11_a25 out nocopy JTF_VARCHAR2_TABLE_200
1840     , p11_a26 out nocopy JTF_VARCHAR2_TABLE_200
1841     , p11_a27 out nocopy JTF_VARCHAR2_TABLE_200
1842     , p11_a28 out nocopy JTF_VARCHAR2_TABLE_200
1846     , p11_a32 out nocopy JTF_VARCHAR2_TABLE_200
1843     , p11_a29 out nocopy JTF_VARCHAR2_TABLE_200
1844     , p11_a30 out nocopy JTF_VARCHAR2_TABLE_200
1845     , p11_a31 out nocopy JTF_VARCHAR2_TABLE_200
1847     , p11_a33 out nocopy JTF_VARCHAR2_TABLE_200
1848     , p11_a34 out nocopy JTF_VARCHAR2_TABLE_200
1849     , p11_a35 out nocopy JTF_VARCHAR2_TABLE_200
1850     , p11_a36 out nocopy JTF_VARCHAR2_TABLE_200
1851     , p11_a37 out nocopy JTF_VARCHAR2_TABLE_200
1852     , p11_a38 out nocopy JTF_VARCHAR2_TABLE_200
1853     , p11_a39 out nocopy JTF_VARCHAR2_TABLE_200
1854     , p11_a40 out nocopy JTF_NUMBER_TABLE
1855     , p11_a41 out nocopy JTF_VARCHAR2_TABLE_100
1856     , p11_a42 out nocopy JTF_NUMBER_TABLE
1857     , p12_a0 out nocopy JTF_NUMBER_TABLE
1858     , p12_a1 out nocopy JTF_NUMBER_TABLE
1859     , p12_a2 out nocopy JTF_NUMBER_TABLE
1860     , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
1861     , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
1862     , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
1863     , p12_a6 out nocopy JTF_VARCHAR2_TABLE_300
1864     , p12_a7 out nocopy JTF_DATE_TABLE
1865     , p12_a8 out nocopy JTF_DATE_TABLE
1866     , p12_a9 out nocopy JTF_DATE_TABLE
1867     , p12_a10 out nocopy JTF_DATE_TABLE
1868     , p12_a11 out nocopy JTF_DATE_TABLE
1869     , p12_a12 out nocopy JTF_DATE_TABLE
1870     , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
1871     , p12_a14 out nocopy JTF_VARCHAR2_TABLE_100
1872     , p12_a15 out nocopy JTF_VARCHAR2_TABLE_200
1873     , p12_a16 out nocopy JTF_VARCHAR2_TABLE_200
1874     , p12_a17 out nocopy JTF_VARCHAR2_TABLE_200
1875     , p12_a18 out nocopy JTF_VARCHAR2_TABLE_200
1876     , p12_a19 out nocopy JTF_VARCHAR2_TABLE_200
1877     , p12_a20 out nocopy JTF_VARCHAR2_TABLE_200
1878     , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
1879     , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
1880     , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
1881     , p12_a24 out nocopy JTF_VARCHAR2_TABLE_200
1882     , p12_a25 out nocopy JTF_VARCHAR2_TABLE_200
1883     , p12_a26 out nocopy JTF_VARCHAR2_TABLE_200
1884     , p12_a27 out nocopy JTF_VARCHAR2_TABLE_200
1885     , p12_a28 out nocopy JTF_VARCHAR2_TABLE_200
1886     , p12_a29 out nocopy JTF_VARCHAR2_TABLE_200
1887     , p12_a30 out nocopy JTF_VARCHAR2_TABLE_200
1888     , p12_a31 out nocopy JTF_VARCHAR2_TABLE_200
1889     , p12_a32 out nocopy JTF_VARCHAR2_TABLE_200
1890     , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
1891     , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
1892     , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
1893     , p12_a36 out nocopy JTF_VARCHAR2_TABLE_200
1894     , p12_a37 out nocopy JTF_VARCHAR2_TABLE_200
1895     , p12_a38 out nocopy JTF_VARCHAR2_TABLE_200
1896     , p12_a39 out nocopy JTF_VARCHAR2_TABLE_200
1897     , p12_a40 out nocopy JTF_VARCHAR2_TABLE_200
1898     , p12_a41 out nocopy JTF_VARCHAR2_TABLE_200
1899     , p12_a42 out nocopy JTF_VARCHAR2_TABLE_200
1900     , p12_a43 out nocopy JTF_VARCHAR2_TABLE_200
1901     , p12_a44 out nocopy JTF_VARCHAR2_TABLE_200
1902     , p12_a45 out nocopy JTF_VARCHAR2_TABLE_100
1903     , p12_a46 out nocopy JTF_NUMBER_TABLE
1904     , p12_a47 out nocopy JTF_NUMBER_TABLE
1905     , p13_a0 out nocopy JTF_NUMBER_TABLE
1906     , p13_a1 out nocopy JTF_NUMBER_TABLE
1907     , p13_a2 out nocopy JTF_NUMBER_TABLE
1908     , p13_a3 out nocopy JTF_NUMBER_TABLE
1909     , p13_a4 out nocopy JTF_NUMBER_TABLE
1910     , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
1911     , p13_a6 out nocopy JTF_VARCHAR2_TABLE_100
1912     , p13_a7 out nocopy JTF_DATE_TABLE
1913     , p13_a8 out nocopy JTF_DATE_TABLE
1914     , p13_a9 out nocopy JTF_DATE_TABLE
1915     , p13_a10 out nocopy JTF_DATE_TABLE
1916     , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
1917     , p13_a12 out nocopy JTF_VARCHAR2_TABLE_100
1918     , p13_a13 out nocopy JTF_VARCHAR2_TABLE_100
1919     , p13_a14 out nocopy JTF_VARCHAR2_TABLE_100
1920     , p13_a15 out nocopy JTF_VARCHAR2_TABLE_200
1921     , p13_a16 out nocopy JTF_VARCHAR2_TABLE_200
1922     , p13_a17 out nocopy JTF_VARCHAR2_TABLE_200
1923     , p13_a18 out nocopy JTF_VARCHAR2_TABLE_200
1924     , p13_a19 out nocopy JTF_VARCHAR2_TABLE_200
1925     , p13_a20 out nocopy JTF_VARCHAR2_TABLE_200
1926     , p13_a21 out nocopy JTF_VARCHAR2_TABLE_200
1927     , p13_a22 out nocopy JTF_VARCHAR2_TABLE_200
1928     , p13_a23 out nocopy JTF_VARCHAR2_TABLE_200
1929     , p13_a24 out nocopy JTF_VARCHAR2_TABLE_200
1930     , p13_a25 out nocopy JTF_VARCHAR2_TABLE_200
1931     , p13_a26 out nocopy JTF_VARCHAR2_TABLE_200
1932     , p13_a27 out nocopy JTF_VARCHAR2_TABLE_200
1933     , p13_a28 out nocopy JTF_VARCHAR2_TABLE_200
1934     , p13_a29 out nocopy JTF_VARCHAR2_TABLE_200
1935     , p13_a30 out nocopy JTF_VARCHAR2_TABLE_200
1936     , p13_a31 out nocopy JTF_VARCHAR2_TABLE_200
1937     , p13_a32 out nocopy JTF_VARCHAR2_TABLE_200
1938     , p13_a33 out nocopy JTF_VARCHAR2_TABLE_200
1939     , p13_a34 out nocopy JTF_VARCHAR2_TABLE_200
1940     , p13_a35 out nocopy JTF_VARCHAR2_TABLE_200
1941     , p13_a36 out nocopy JTF_VARCHAR2_TABLE_200
1942     , p13_a37 out nocopy JTF_VARCHAR2_TABLE_200
1943     , p13_a38 out nocopy JTF_VARCHAR2_TABLE_200
1944     , p13_a39 out nocopy JTF_VARCHAR2_TABLE_200
1945     , p13_a40 out nocopy JTF_VARCHAR2_TABLE_200
1946     , p13_a41 out nocopy JTF_VARCHAR2_TABLE_200
1947     , p13_a42 out nocopy JTF_VARCHAR2_TABLE_200
1948     , p13_a43 out nocopy JTF_VARCHAR2_TABLE_200
1949     , p13_a44 out nocopy JTF_VARCHAR2_TABLE_200
1950     , p13_a45 out nocopy JTF_VARCHAR2_TABLE_100
1951     , p13_a46 out nocopy JTF_NUMBER_TABLE
1952     , p13_a47 out nocopy JTF_DATE_TABLE
1956     , p13_a51 out nocopy JTF_VARCHAR2_TABLE_100
1953     , p13_a48 out nocopy JTF_NUMBER_TABLE
1954     , p13_a49 out nocopy JTF_NUMBER_TABLE
1955     , p13_a50 out nocopy JTF_VARCHAR2_TABLE_100
1957     , p13_a52 out nocopy JTF_VARCHAR2_TABLE_100
1958     , p13_a53 out nocopy JTF_VARCHAR2_TABLE_100
1959     , x_return_status out nocopy  VARCHAR2
1960     , x_msg_count out nocopy  NUMBER
1961     , x_msg_data out nocopy  VARCHAR2
1962   );
1963   procedure get_instance_link_locations(p_api_version  NUMBER
1964     , p_commit  VARCHAR2
1965     , p_init_msg_list  VARCHAR2
1966     , p_validation_level  NUMBER
1967     , p_instance_id  NUMBER
1968     , p5_a0 out nocopy  NUMBER
1969     , p5_a1 out nocopy  VARCHAR2
1970     , p5_a2 out nocopy  VARCHAR2
1971     , p5_a3 out nocopy  VARCHAR2
1972     , p5_a4 out nocopy  VARCHAR2
1973     , p5_a5 out nocopy  VARCHAR2
1974     , p5_a6 out nocopy  VARCHAR2
1975     , p5_a7 out nocopy  VARCHAR2
1976     , p5_a8 out nocopy  VARCHAR2
1977     , p5_a9 out nocopy  VARCHAR2
1978     , p5_a10 out nocopy  VARCHAR2
1979     , p5_a11 out nocopy  VARCHAR2
1980     , p5_a12 out nocopy  VARCHAR2
1981     , p5_a13 out nocopy  VARCHAR2
1982     , p5_a14 out nocopy  VARCHAR2
1983     , p5_a15 out nocopy  VARCHAR2
1984     , p5_a16 out nocopy  VARCHAR2
1985     , x_return_status out nocopy  VARCHAR2
1986     , x_msg_count out nocopy  NUMBER
1987     , x_msg_data out nocopy  VARCHAR2
1988   );
1989   procedure get_contact_details(p_api_version  NUMBER
1990     , p_commit  VARCHAR2
1991     , p_init_msg_list  VARCHAR2
1992     , p_validation_level  NUMBER
1993     , p_contact_party_id  NUMBER
1994     , p_contact_flag  VARCHAR2
1995     , p_party_tbl  VARCHAR2
1996     , p7_a0 out nocopy  NUMBER
1997     , p7_a1 out nocopy  VARCHAR2
1998     , p7_a2 out nocopy  VARCHAR2
1999     , p7_a3 out nocopy  VARCHAR2
2000     , p7_a4 out nocopy  VARCHAR2
2001     , p7_a5 out nocopy  VARCHAR2
2002     , p7_a6 out nocopy  VARCHAR2
2003     , p7_a7 out nocopy  VARCHAR2
2004     , p7_a8 out nocopy  VARCHAR2
2005     , p7_a9 out nocopy  VARCHAR2
2006     , p7_a10 out nocopy  VARCHAR2
2007     , p7_a11 out nocopy  VARCHAR2
2008     , p7_a12 out nocopy  VARCHAR2
2009     , p7_a13 out nocopy  VARCHAR2
2010     , p7_a14 out nocopy  VARCHAR2
2011     , p7_a15 out nocopy  VARCHAR2
2012     , x_return_status out nocopy  VARCHAR2
2013     , x_msg_count out nocopy  NUMBER
2014     , x_msg_data out nocopy  VARCHAR2
2015   );
2016   procedure bld_instance_all_parents_tbl(p_subject_id  NUMBER
2017     , p_relationship_type_code  VARCHAR2
2018     , p_time_stamp  date
2019   );
2020   function get_instance_all_parents(p_subject_id  NUMBER
2021     , p_time_stamp  date
2022   ) return varchar2;
2023   procedure expire_relationship(p_api_version  NUMBER
2024     , p_commit  VARCHAR2
2025     , p_init_msg_list  VARCHAR2
2026     , p_validation_level  NUMBER
2027     , p_subject_id  NUMBER
2028     , p5_a0 in out nocopy  NUMBER
2029     , p5_a1 in out nocopy  DATE
2030     , p5_a2 in out nocopy  DATE
2031     , p5_a3 in out nocopy  NUMBER
2032     , p5_a4 in out nocopy  NUMBER
2033     , p5_a5 in out nocopy  NUMBER
2034     , p5_a6 in out nocopy  VARCHAR2
2035     , p5_a7 in out nocopy  NUMBER
2036     , p5_a8 in out nocopy  VARCHAR2
2037     , p5_a9 in out nocopy  NUMBER
2038     , p5_a10 in out nocopy  VARCHAR2
2039     , p5_a11 in out nocopy  NUMBER
2040     , p5_a12 in out nocopy  NUMBER
2041     , p5_a13 in out nocopy  NUMBER
2042     , p5_a14 in out nocopy  NUMBER
2043     , p5_a15 in out nocopy  VARCHAR2
2044     , p5_a16 in out nocopy  NUMBER
2045     , p5_a17 in out nocopy  VARCHAR2
2046     , p5_a18 in out nocopy  VARCHAR2
2047     , p5_a19 in out nocopy  NUMBER
2048     , p5_a20 in out nocopy  VARCHAR2
2049     , p5_a21 in out nocopy  VARCHAR2
2050     , p5_a22 in out nocopy  VARCHAR2
2051     , p5_a23 in out nocopy  VARCHAR2
2052     , p5_a24 in out nocopy  VARCHAR2
2053     , p5_a25 in out nocopy  VARCHAR2
2054     , p5_a26 in out nocopy  VARCHAR2
2055     , p5_a27 in out nocopy  VARCHAR2
2056     , p5_a28 in out nocopy  VARCHAR2
2057     , p5_a29 in out nocopy  VARCHAR2
2058     , p5_a30 in out nocopy  VARCHAR2
2059     , p5_a31 in out nocopy  VARCHAR2
2060     , p5_a32 in out nocopy  VARCHAR2
2061     , p5_a33 in out nocopy  VARCHAR2
2062     , p5_a34 in out nocopy  VARCHAR2
2063     , p5_a35 in out nocopy  VARCHAR2
2064     , p5_a36 in out nocopy  NUMBER
2065     , p5_a37 in out nocopy  VARCHAR2
2066     , p5_a38 in out nocopy  DATE
2067     , p5_a39 in out nocopy  NUMBER
2068     , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
2069     , x_return_status out nocopy  VARCHAR2
2070     , x_msg_count out nocopy  NUMBER
2071     , x_msg_data out nocopy  VARCHAR2
2072   );
2073   function get_instance_ids(p0_a0 in out nocopy JTF_NUMBER_TABLE
2074   ) return varchar2;
2075 end csi_java_interface_pkg_w;