DBA Data[Home] [Help]

PACKAGE: APPS.CSI_ITEM_INSTANCE_PUB_W

Source


1 package csi_item_instance_pub_w as
2   /* $Header: csipiiws.pls 120.18 2008/01/15 03:32:15 devijay ship $ */
3   procedure rosetta_table_copy_in_p14(t out nocopy csi_item_instance_pub.txn_oks_type_tbl, a0 JTF_VARCHAR2_TABLE_100);
4   procedure rosetta_table_copy_out_p14(t csi_item_instance_pub.txn_oks_type_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
5 
6   procedure create_item_instance(p_api_version  NUMBER
7     , p_commit  VARCHAR2
8     , p_init_msg_list  VARCHAR2
9     , p_validation_level  NUMBER
10     , p4_a0 in out nocopy  NUMBER
11     , p4_a1 in out nocopy  VARCHAR2
12     , p4_a2 in out nocopy  VARCHAR2
13     , p4_a3 in out nocopy  NUMBER
14     , p4_a4 in out nocopy  NUMBER
15     , p4_a5 in out nocopy  VARCHAR2
16     , p4_a6 in out nocopy  NUMBER
17     , p4_a7 in out nocopy  VARCHAR2
18     , p4_a8 in out nocopy  VARCHAR2
19     , p4_a9 in out nocopy  VARCHAR2
20     , p4_a10 in out nocopy  NUMBER
21     , p4_a11 in out nocopy  VARCHAR2
22     , p4_a12 in out nocopy  VARCHAR2
23     , p4_a13 in out nocopy  NUMBER
24     , p4_a14 in out nocopy  NUMBER
25     , p4_a15 in out nocopy  VARCHAR2
26     , p4_a16 in out nocopy  VARCHAR2
27     , p4_a17 in out nocopy  VARCHAR2
28     , p4_a18 in out nocopy  NUMBER
29     , p4_a19 in out nocopy  VARCHAR2
30     , p4_a20 in out nocopy  DATE
31     , p4_a21 in out nocopy  DATE
32     , p4_a22 in out nocopy  VARCHAR2
33     , p4_a23 in out nocopy  NUMBER
34     , p4_a24 in out nocopy  NUMBER
35     , p4_a25 in out nocopy  VARCHAR2
36     , p4_a26 in out nocopy  NUMBER
37     , p4_a27 in out nocopy  NUMBER
38     , p4_a28 in out nocopy  NUMBER
39     , p4_a29 in out nocopy  NUMBER
40     , p4_a30 in out nocopy  NUMBER
41     , p4_a31 in out nocopy  NUMBER
42     , p4_a32 in out nocopy  NUMBER
43     , p4_a33 in out nocopy  NUMBER
44     , p4_a34 in out nocopy  NUMBER
45     , p4_a35 in out nocopy  VARCHAR2
46     , p4_a36 in out nocopy  NUMBER
47     , p4_a37 in out nocopy  NUMBER
48     , p4_a38 in out nocopy  NUMBER
49     , p4_a39 in out nocopy  NUMBER
50     , p4_a40 in out nocopy  DATE
51     , p4_a41 in out nocopy  VARCHAR2
52     , p4_a42 in out nocopy  DATE
53     , p4_a43 in out nocopy  DATE
54     , p4_a44 in out nocopy  VARCHAR2
55     , p4_a45 in out nocopy  VARCHAR2
56     , p4_a46 in out nocopy  VARCHAR2
57     , p4_a47 in out nocopy  VARCHAR2
58     , p4_a48 in out nocopy  VARCHAR2
59     , p4_a49 in out nocopy  VARCHAR2
60     , p4_a50 in out nocopy  VARCHAR2
61     , p4_a51 in out nocopy  VARCHAR2
62     , p4_a52 in out nocopy  VARCHAR2
63     , p4_a53 in out nocopy  VARCHAR2
64     , p4_a54 in out nocopy  VARCHAR2
65     , p4_a55 in out nocopy  VARCHAR2
66     , p4_a56 in out nocopy  VARCHAR2
67     , p4_a57 in out nocopy  VARCHAR2
68     , p4_a58 in out nocopy  VARCHAR2
69     , p4_a59 in out nocopy  VARCHAR2
70     , p4_a60 in out nocopy  VARCHAR2
71     , p4_a61 in out nocopy  VARCHAR2
72     , p4_a62 in out nocopy  VARCHAR2
73     , p4_a63 in out nocopy  VARCHAR2
74     , p4_a64 in out nocopy  NUMBER
75     , p4_a65 in out nocopy  NUMBER
76     , p4_a66 in out nocopy  VARCHAR2
77     , p4_a67 in out nocopy  NUMBER
78     , p4_a68 in out nocopy  VARCHAR2
79     , p4_a69 in out nocopy  VARCHAR2
80     , p4_a70 in out nocopy  VARCHAR2
81     , p4_a71 in out nocopy  VARCHAR2
82     , p4_a72 in out nocopy  NUMBER
83     , p4_a73 in out nocopy  VARCHAR2
84     , p4_a74 in out nocopy  NUMBER
85     , p4_a75 in out nocopy  NUMBER
86     , p4_a76 in out nocopy  NUMBER
87     , p4_a77 in out nocopy  VARCHAR2
88     , p4_a78 in out nocopy  VARCHAR2
89     , p4_a79 in out nocopy  VARCHAR2
90     , p4_a80 in out nocopy  NUMBER
91     , p4_a81 in out nocopy  NUMBER
92     , p4_a82 in out nocopy  NUMBER
93     , p4_a83 in out nocopy  DATE
94     , p4_a84 in out nocopy  VARCHAR2
95     , p4_a85 in out nocopy  VARCHAR2
96     , p4_a86 in out nocopy  VARCHAR2
97     , p4_a87 in out nocopy  NUMBER
98     , p4_a88 in out nocopy  VARCHAR2
99     , p4_a89 in out nocopy  NUMBER
100     , p4_a90 in out nocopy  NUMBER
101     , p4_a91 in out nocopy  VARCHAR2
102     , p4_a92 in out nocopy  NUMBER
103     , p4_a93 in out nocopy  VARCHAR2
104     , p4_a94 in out nocopy  NUMBER
105     , p4_a95 in out nocopy  DATE
106     , p4_a96 in out nocopy  VARCHAR2
107     , p4_a97 in out nocopy  VARCHAR2
108     , p4_a98 in out nocopy  VARCHAR2
109     , p4_a99 in out nocopy  VARCHAR2
110     , p4_a100 in out nocopy  VARCHAR2
111     , p4_a101 in out nocopy  VARCHAR2
112     , p4_a102 in out nocopy  VARCHAR2
113     , p4_a103 in out nocopy  VARCHAR2
114     , p4_a104 in out nocopy  VARCHAR2
115     , p4_a105 in out nocopy  VARCHAR2
116     , p4_a106 in out nocopy  VARCHAR2
117     , p4_a107 in out nocopy  VARCHAR2
118     , p4_a108 in out nocopy  VARCHAR2
119     , p4_a109 in out nocopy  VARCHAR2
120     , p4_a110 in out nocopy  VARCHAR2
121     , p4_a111 in out nocopy  NUMBER
122     , p4_a112 in out nocopy  VARCHAR2
123     , p4_a113 in out nocopy  NUMBER
124     , p4_a114 in out nocopy  VARCHAR2
125     , p4_a115 in out nocopy  NUMBER
126     , p4_a116 in out nocopy  VARCHAR2
127     , p4_a117 in out nocopy  VARCHAR2
128     , p4_a118 in out nocopy  NUMBER
129     , p4_a119 in out nocopy  VARCHAR2
130     , p4_a120 in out nocopy  NUMBER
131     , p4_a121 in out nocopy  NUMBER
132     , p4_a122 in out nocopy  VARCHAR2
133     , p5_a0 in out nocopy JTF_NUMBER_TABLE
134     , p5_a1 in out nocopy JTF_NUMBER_TABLE
135     , p5_a2 in out nocopy JTF_NUMBER_TABLE
136     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
137     , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
138     , p5_a5 in out nocopy JTF_DATE_TABLE
139     , p5_a6 in out nocopy JTF_DATE_TABLE
140     , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
141     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_200
142     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
143     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
144     , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
145     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
146     , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
147     , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
148     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
149     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
150     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
151     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
152     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
153     , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
154     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
155     , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
156     , p5_a23 in out nocopy JTF_NUMBER_TABLE
157     , p5_a24 in out nocopy JTF_NUMBER_TABLE
158     , p6_a0 in out nocopy JTF_NUMBER_TABLE
159     , p6_a1 in out nocopy JTF_NUMBER_TABLE
160     , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
161     , p6_a3 in out nocopy JTF_NUMBER_TABLE
162     , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
163     , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
164     , p6_a6 in out nocopy JTF_NUMBER_TABLE
165     , p6_a7 in out nocopy JTF_DATE_TABLE
166     , p6_a8 in out nocopy JTF_DATE_TABLE
167     , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
168     , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
169     , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
170     , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
171     , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
172     , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
173     , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
174     , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
175     , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
176     , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
177     , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
178     , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
179     , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
180     , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
181     , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
182     , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
183     , p6_a25 in out nocopy JTF_NUMBER_TABLE
184     , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
185     , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_100
186     , p6_a28 in out nocopy JTF_NUMBER_TABLE
187     , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
188     , p6_a30 in out nocopy JTF_NUMBER_TABLE
189     , p6_a31 in out nocopy JTF_NUMBER_TABLE
190     , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_100
191     , p7_a0 in out nocopy JTF_NUMBER_TABLE
192     , p7_a1 in out nocopy JTF_NUMBER_TABLE
193     , p7_a2 in out nocopy JTF_NUMBER_TABLE
194     , p7_a3 in out nocopy JTF_NUMBER_TABLE
195     , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
196     , p7_a5 in out nocopy JTF_NUMBER_TABLE
197     , p7_a6 in out nocopy JTF_NUMBER_TABLE
198     , p7_a7 in out nocopy JTF_DATE_TABLE
199     , p7_a8 in out nocopy JTF_DATE_TABLE
200     , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
201     , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_200
202     , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_200
203     , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_200
204     , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_200
205     , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_200
206     , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_200
207     , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_200
208     , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
209     , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
210     , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
211     , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
212     , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
213     , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
214     , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200
215     , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_200
216     , p7_a25 in out nocopy JTF_NUMBER_TABLE
217     , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_100
218     , p7_a27 in out nocopy JTF_NUMBER_TABLE
219     , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100
220     , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
221     , p7_a30 in out nocopy JTF_NUMBER_TABLE
222     , p7_a31 in out nocopy JTF_NUMBER_TABLE
223     , p7_a32 in out nocopy JTF_NUMBER_TABLE
224     , p7_a33 in out nocopy JTF_DATE_TABLE
225     , p7_a34 in out nocopy JTF_NUMBER_TABLE
226     , p7_a35 in out nocopy JTF_VARCHAR2_TABLE_100
227     , p8_a0 in out nocopy JTF_NUMBER_TABLE
228     , p8_a1 in out nocopy JTF_NUMBER_TABLE
229     , p8_a2 in out nocopy JTF_DATE_TABLE
230     , p8_a3 in out nocopy JTF_DATE_TABLE
231     , p8_a4 in out nocopy JTF_VARCHAR2_TABLE_100
232     , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_200
233     , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_200
234     , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_200
235     , p8_a8 in out nocopy JTF_VARCHAR2_TABLE_200
236     , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_200
237     , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_200
238     , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_200
239     , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
240     , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
241     , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
242     , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
243     , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
244     , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
245     , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
246     , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
247     , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
248     , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
249     , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
250     , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
251     , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_300
252     , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
253     , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
254     , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
255     , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
256     , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
257     , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
258     , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
259     , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_200
260     , p8_a33 in out nocopy JTF_VARCHAR2_TABLE_200
261     , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_200
262     , p8_a35 in out nocopy JTF_VARCHAR2_TABLE_200
263     , p8_a36 in out nocopy JTF_VARCHAR2_TABLE_200
264     , p8_a37 in out nocopy JTF_VARCHAR2_TABLE_200
265     , p8_a38 in out nocopy JTF_VARCHAR2_TABLE_200
266     , p8_a39 in out nocopy JTF_VARCHAR2_TABLE_200
267     , p8_a40 in out nocopy JTF_VARCHAR2_TABLE_200
268     , p8_a41 in out nocopy JTF_VARCHAR2_TABLE_200
269     , p8_a42 in out nocopy JTF_VARCHAR2_TABLE_200
270     , p8_a43 in out nocopy JTF_VARCHAR2_TABLE_200
271     , p8_a44 in out nocopy JTF_VARCHAR2_TABLE_200
272     , p8_a45 in out nocopy JTF_VARCHAR2_TABLE_200
273     , p8_a46 in out nocopy JTF_VARCHAR2_TABLE_200
274     , p8_a47 in out nocopy JTF_VARCHAR2_TABLE_200
275     , p8_a48 in out nocopy JTF_VARCHAR2_TABLE_200
276     , p8_a49 in out nocopy JTF_VARCHAR2_TABLE_200
277     , p8_a50 in out nocopy JTF_VARCHAR2_TABLE_200
278     , p8_a51 in out nocopy JTF_VARCHAR2_TABLE_200
279     , p8_a52 in out nocopy JTF_VARCHAR2_TABLE_200
280     , p8_a53 in out nocopy JTF_VARCHAR2_TABLE_200
281     , p8_a54 in out nocopy JTF_VARCHAR2_TABLE_200
282     , p8_a55 in out nocopy JTF_VARCHAR2_TABLE_200
283     , p8_a56 in out nocopy JTF_VARCHAR2_TABLE_200
284     , p8_a57 in out nocopy JTF_VARCHAR2_TABLE_200
285     , p8_a58 in out nocopy JTF_VARCHAR2_TABLE_200
286     , p8_a59 in out nocopy JTF_VARCHAR2_TABLE_200
287     , p8_a60 in out nocopy JTF_VARCHAR2_TABLE_200
288     , p8_a61 in out nocopy JTF_VARCHAR2_TABLE_200
289     , p8_a62 in out nocopy JTF_VARCHAR2_TABLE_200
290     , p8_a63 in out nocopy JTF_VARCHAR2_TABLE_200
291     , p8_a64 in out nocopy JTF_VARCHAR2_TABLE_200
292     , p8_a65 in out nocopy JTF_VARCHAR2_TABLE_200
293     , p8_a66 in out nocopy JTF_VARCHAR2_TABLE_200
294     , p8_a67 in out nocopy JTF_VARCHAR2_TABLE_200
295     , p8_a68 in out nocopy JTF_VARCHAR2_TABLE_200
296     , p8_a69 in out nocopy JTF_VARCHAR2_TABLE_200
297     , p8_a70 in out nocopy JTF_VARCHAR2_TABLE_200
298     , p8_a71 in out nocopy JTF_VARCHAR2_TABLE_200
299     , p8_a72 in out nocopy JTF_VARCHAR2_TABLE_200
300     , p8_a73 in out nocopy JTF_VARCHAR2_TABLE_200
301     , p8_a74 in out nocopy JTF_VARCHAR2_TABLE_200
302     , p8_a75 in out nocopy JTF_VARCHAR2_TABLE_200
303     , p8_a76 in out nocopy JTF_VARCHAR2_TABLE_200
304     , p8_a77 in out nocopy JTF_VARCHAR2_TABLE_200
305     , p8_a78 in out nocopy JTF_VARCHAR2_TABLE_200
306     , p8_a79 in out nocopy JTF_VARCHAR2_TABLE_200
307     , p8_a80 in out nocopy JTF_VARCHAR2_TABLE_200
308     , p8_a81 in out nocopy JTF_VARCHAR2_TABLE_200
309     , p8_a82 in out nocopy JTF_VARCHAR2_TABLE_200
310     , p8_a83 in out nocopy JTF_VARCHAR2_TABLE_200
311     , p8_a84 in out nocopy JTF_VARCHAR2_TABLE_200
312     , p8_a85 in out nocopy JTF_VARCHAR2_TABLE_200
313     , p8_a86 in out nocopy JTF_VARCHAR2_TABLE_200
314     , p8_a87 in out nocopy JTF_VARCHAR2_TABLE_200
315     , p8_a88 in out nocopy JTF_VARCHAR2_TABLE_200
316     , p8_a89 in out nocopy JTF_VARCHAR2_TABLE_200
317     , p8_a90 in out nocopy JTF_VARCHAR2_TABLE_200
318     , p8_a91 in out nocopy JTF_VARCHAR2_TABLE_200
319     , p8_a92 in out nocopy JTF_VARCHAR2_TABLE_200
320     , p8_a93 in out nocopy JTF_VARCHAR2_TABLE_200
321     , p8_a94 in out nocopy JTF_VARCHAR2_TABLE_200
322     , p8_a95 in out nocopy JTF_VARCHAR2_TABLE_200
323     , p8_a96 in out nocopy JTF_VARCHAR2_TABLE_200
324     , p8_a97 in out nocopy JTF_VARCHAR2_TABLE_200
325     , p8_a98 in out nocopy JTF_VARCHAR2_TABLE_200
326     , p8_a99 in out nocopy JTF_VARCHAR2_TABLE_200
327     , p8_a100 in out nocopy JTF_VARCHAR2_TABLE_200
328     , p8_a101 in out nocopy JTF_VARCHAR2_TABLE_200
329     , p8_a102 in out nocopy JTF_VARCHAR2_TABLE_200
330     , p8_a103 in out nocopy JTF_VARCHAR2_TABLE_200
331     , p8_a104 in out nocopy JTF_VARCHAR2_TABLE_200
332     , p8_a105 in out nocopy JTF_VARCHAR2_TABLE_100
333     , p8_a106 in out nocopy JTF_VARCHAR2_TABLE_200
334     , p8_a107 in out nocopy JTF_VARCHAR2_TABLE_200
335     , p8_a108 in out nocopy JTF_VARCHAR2_TABLE_200
336     , p8_a109 in out nocopy JTF_VARCHAR2_TABLE_200
337     , p8_a110 in out nocopy JTF_VARCHAR2_TABLE_200
338     , p8_a111 in out nocopy JTF_VARCHAR2_TABLE_200
339     , p8_a112 in out nocopy JTF_VARCHAR2_TABLE_200
340     , p8_a113 in out nocopy JTF_VARCHAR2_TABLE_200
341     , p8_a114 in out nocopy JTF_VARCHAR2_TABLE_200
342     , p8_a115 in out nocopy JTF_VARCHAR2_TABLE_200
343     , p8_a116 in out nocopy JTF_VARCHAR2_TABLE_200
344     , p8_a117 in out nocopy JTF_VARCHAR2_TABLE_200
345     , p8_a118 in out nocopy JTF_VARCHAR2_TABLE_200
346     , p8_a119 in out nocopy JTF_VARCHAR2_TABLE_200
347     , p8_a120 in out nocopy JTF_VARCHAR2_TABLE_200
348     , p8_a121 in out nocopy JTF_NUMBER_TABLE
349     , p8_a122 in out nocopy JTF_NUMBER_TABLE
350     , p9_a0 in out nocopy JTF_NUMBER_TABLE
351     , p9_a1 in out nocopy JTF_NUMBER_TABLE
352     , p9_a2 in out nocopy JTF_NUMBER_TABLE
353     , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
354     , p9_a4 in out nocopy JTF_DATE_TABLE
355     , p9_a5 in out nocopy JTF_DATE_TABLE
356     , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
357     , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
358     , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200
359     , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
360     , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200
361     , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
362     , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
363     , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
364     , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
365     , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
366     , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
367     , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
368     , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
369     , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
370     , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
371     , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
372     , p9_a22 in out nocopy JTF_NUMBER_TABLE
373     , p9_a23 in out nocopy JTF_NUMBER_TABLE
374     , p10_a0 in out nocopy JTF_NUMBER_TABLE
375     , p10_a1 in out nocopy JTF_NUMBER_TABLE
376     , p10_a2 in out nocopy JTF_NUMBER_TABLE
377     , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
378     , p10_a4 in out nocopy JTF_NUMBER_TABLE
379     , p10_a5 in out nocopy JTF_NUMBER_TABLE
380     , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
381     , p10_a7 in out nocopy JTF_DATE_TABLE
382     , p10_a8 in out nocopy JTF_DATE_TABLE
383     , p10_a9 in out nocopy JTF_NUMBER_TABLE
384     , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
385     , p10_a11 in out nocopy JTF_NUMBER_TABLE
386     , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
387     , p10_a13 in out nocopy JTF_NUMBER_TABLE
388     , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_100
389     , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_100
390     , p11_a0 in out nocopy  NUMBER
391     , p11_a1 in out nocopy  DATE
392     , p11_a2 in out nocopy  DATE
393     , p11_a3 in out nocopy  NUMBER
394     , p11_a4 in out nocopy  NUMBER
395     , p11_a5 in out nocopy  NUMBER
396     , p11_a6 in out nocopy  VARCHAR2
397     , p11_a7 in out nocopy  NUMBER
398     , p11_a8 in out nocopy  VARCHAR2
399     , p11_a9 in out nocopy  NUMBER
400     , p11_a10 in out nocopy  VARCHAR2
401     , p11_a11 in out nocopy  NUMBER
402     , p11_a12 in out nocopy  NUMBER
403     , p11_a13 in out nocopy  NUMBER
404     , p11_a14 in out nocopy  NUMBER
405     , p11_a15 in out nocopy  VARCHAR2
406     , p11_a16 in out nocopy  NUMBER
407     , p11_a17 in out nocopy  VARCHAR2
408     , p11_a18 in out nocopy  VARCHAR2
409     , p11_a19 in out nocopy  NUMBER
410     , p11_a20 in out nocopy  VARCHAR2
411     , p11_a21 in out nocopy  VARCHAR2
412     , p11_a22 in out nocopy  VARCHAR2
413     , p11_a23 in out nocopy  VARCHAR2
414     , p11_a24 in out nocopy  VARCHAR2
415     , p11_a25 in out nocopy  VARCHAR2
416     , p11_a26 in out nocopy  VARCHAR2
417     , p11_a27 in out nocopy  VARCHAR2
418     , p11_a28 in out nocopy  VARCHAR2
419     , p11_a29 in out nocopy  VARCHAR2
420     , p11_a30 in out nocopy  VARCHAR2
421     , p11_a31 in out nocopy  VARCHAR2
422     , p11_a32 in out nocopy  VARCHAR2
423     , p11_a33 in out nocopy  VARCHAR2
424     , p11_a34 in out nocopy  VARCHAR2
425     , p11_a35 in out nocopy  VARCHAR2
426     , p11_a36 in out nocopy  NUMBER
427     , p11_a37 in out nocopy  VARCHAR2
428     , p11_a38 in out nocopy  DATE
429     , p11_a39 in out nocopy  NUMBER
430     , x_return_status out nocopy  VARCHAR2
431     , x_msg_count out nocopy  NUMBER
432     , x_msg_data out nocopy  VARCHAR2
433   );
434   procedure update_item_instance(p_api_version  NUMBER
435     , p_commit  VARCHAR2
436     , p_init_msg_list  VARCHAR2
437     , p_validation_level  NUMBER
438     , p5_a0 in out nocopy JTF_NUMBER_TABLE
439     , p5_a1 in out nocopy JTF_NUMBER_TABLE
440     , p5_a2 in out nocopy JTF_NUMBER_TABLE
441     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
442     , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_300
443     , p5_a5 in out nocopy JTF_DATE_TABLE
444     , p5_a6 in out nocopy JTF_DATE_TABLE
445     , p5_a7 in out nocopy JTF_VARCHAR2_TABLE_100
446     , p5_a8 in out nocopy JTF_VARCHAR2_TABLE_200
447     , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
448     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
449     , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
450     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
451     , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
452     , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
453     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
454     , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
455     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
456     , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
457     , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
458     , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
459     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
460     , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
461     , p5_a23 in out nocopy JTF_NUMBER_TABLE
462     , p5_a24 in out nocopy JTF_NUMBER_TABLE
463     , p6_a0 in out nocopy JTF_NUMBER_TABLE
464     , p6_a1 in out nocopy JTF_NUMBER_TABLE
465     , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
466     , p6_a3 in out nocopy JTF_NUMBER_TABLE
467     , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
468     , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
469     , p6_a6 in out nocopy JTF_NUMBER_TABLE
470     , p6_a7 in out nocopy JTF_DATE_TABLE
471     , p6_a8 in out nocopy JTF_DATE_TABLE
472     , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
473     , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_200
474     , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_200
475     , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_200
476     , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_200
477     , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_200
478     , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_200
479     , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
480     , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
481     , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
482     , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
483     , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
484     , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
485     , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
486     , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
487     , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
488     , p6_a25 in out nocopy JTF_NUMBER_TABLE
489     , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_100
490     , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_100
491     , p6_a28 in out nocopy JTF_NUMBER_TABLE
492     , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
493     , p6_a30 in out nocopy JTF_NUMBER_TABLE
494     , p6_a31 in out nocopy JTF_NUMBER_TABLE
495     , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_100
496     , p7_a0 in out nocopy JTF_NUMBER_TABLE
497     , p7_a1 in out nocopy JTF_NUMBER_TABLE
498     , p7_a2 in out nocopy JTF_NUMBER_TABLE
499     , p7_a3 in out nocopy JTF_NUMBER_TABLE
500     , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
501     , p7_a5 in out nocopy JTF_NUMBER_TABLE
502     , p7_a6 in out nocopy JTF_NUMBER_TABLE
503     , p7_a7 in out nocopy JTF_DATE_TABLE
504     , p7_a8 in out nocopy JTF_DATE_TABLE
505     , p7_a9 in out nocopy JTF_VARCHAR2_TABLE_100
506     , p7_a10 in out nocopy JTF_VARCHAR2_TABLE_200
507     , p7_a11 in out nocopy JTF_VARCHAR2_TABLE_200
508     , p7_a12 in out nocopy JTF_VARCHAR2_TABLE_200
509     , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_200
510     , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_200
511     , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_200
512     , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_200
513     , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
514     , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
515     , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
516     , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
517     , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
518     , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
519     , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200
520     , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_200
521     , p7_a25 in out nocopy JTF_NUMBER_TABLE
522     , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_100
523     , p7_a27 in out nocopy JTF_NUMBER_TABLE
524     , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_100
525     , p7_a29 in out nocopy JTF_VARCHAR2_TABLE_100
526     , p7_a30 in out nocopy JTF_NUMBER_TABLE
527     , p7_a31 in out nocopy JTF_NUMBER_TABLE
528     , p7_a32 in out nocopy JTF_NUMBER_TABLE
529     , p7_a33 in out nocopy JTF_DATE_TABLE
530     , p7_a34 in out nocopy JTF_NUMBER_TABLE
531     , p7_a35 in out nocopy JTF_VARCHAR2_TABLE_100
532     , p8_a0 in out nocopy JTF_NUMBER_TABLE
533     , p8_a1 in out nocopy JTF_NUMBER_TABLE
534     , p8_a2 in out nocopy JTF_DATE_TABLE
535     , p8_a3 in out nocopy JTF_DATE_TABLE
536     , p8_a4 in out nocopy JTF_VARCHAR2_TABLE_100
537     , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_200
538     , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_200
539     , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_200
540     , p8_a8 in out nocopy JTF_VARCHAR2_TABLE_200
541     , p8_a9 in out nocopy JTF_VARCHAR2_TABLE_200
542     , p8_a10 in out nocopy JTF_VARCHAR2_TABLE_200
543     , p8_a11 in out nocopy JTF_VARCHAR2_TABLE_200
544     , p8_a12 in out nocopy JTF_VARCHAR2_TABLE_200
545     , p8_a13 in out nocopy JTF_VARCHAR2_TABLE_200
546     , p8_a14 in out nocopy JTF_VARCHAR2_TABLE_200
547     , p8_a15 in out nocopy JTF_VARCHAR2_TABLE_200
548     , p8_a16 in out nocopy JTF_VARCHAR2_TABLE_200
549     , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
550     , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
551     , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
552     , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
553     , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
554     , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
555     , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
556     , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_300
557     , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
558     , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
559     , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
560     , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
561     , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
562     , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
563     , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
564     , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_200
565     , p8_a33 in out nocopy JTF_VARCHAR2_TABLE_200
566     , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_200
567     , p8_a35 in out nocopy JTF_VARCHAR2_TABLE_200
568     , p8_a36 in out nocopy JTF_VARCHAR2_TABLE_200
569     , p8_a37 in out nocopy JTF_VARCHAR2_TABLE_200
570     , p8_a38 in out nocopy JTF_VARCHAR2_TABLE_200
571     , p8_a39 in out nocopy JTF_VARCHAR2_TABLE_200
572     , p8_a40 in out nocopy JTF_VARCHAR2_TABLE_200
573     , p8_a41 in out nocopy JTF_VARCHAR2_TABLE_200
574     , p8_a42 in out nocopy JTF_VARCHAR2_TABLE_200
575     , p8_a43 in out nocopy JTF_VARCHAR2_TABLE_200
576     , p8_a44 in out nocopy JTF_VARCHAR2_TABLE_200
577     , p8_a45 in out nocopy JTF_VARCHAR2_TABLE_200
578     , p8_a46 in out nocopy JTF_VARCHAR2_TABLE_200
579     , p8_a47 in out nocopy JTF_VARCHAR2_TABLE_200
580     , p8_a48 in out nocopy JTF_VARCHAR2_TABLE_200
581     , p8_a49 in out nocopy JTF_VARCHAR2_TABLE_200
582     , p8_a50 in out nocopy JTF_VARCHAR2_TABLE_200
583     , p8_a51 in out nocopy JTF_VARCHAR2_TABLE_200
584     , p8_a52 in out nocopy JTF_VARCHAR2_TABLE_200
585     , p8_a53 in out nocopy JTF_VARCHAR2_TABLE_200
586     , p8_a54 in out nocopy JTF_VARCHAR2_TABLE_200
587     , p8_a55 in out nocopy JTF_VARCHAR2_TABLE_200
588     , p8_a56 in out nocopy JTF_VARCHAR2_TABLE_200
589     , p8_a57 in out nocopy JTF_VARCHAR2_TABLE_200
590     , p8_a58 in out nocopy JTF_VARCHAR2_TABLE_200
591     , p8_a59 in out nocopy JTF_VARCHAR2_TABLE_200
592     , p8_a60 in out nocopy JTF_VARCHAR2_TABLE_200
593     , p8_a61 in out nocopy JTF_VARCHAR2_TABLE_200
594     , p8_a62 in out nocopy JTF_VARCHAR2_TABLE_200
595     , p8_a63 in out nocopy JTF_VARCHAR2_TABLE_200
596     , p8_a64 in out nocopy JTF_VARCHAR2_TABLE_200
597     , p8_a65 in out nocopy JTF_VARCHAR2_TABLE_200
598     , p8_a66 in out nocopy JTF_VARCHAR2_TABLE_200
599     , p8_a67 in out nocopy JTF_VARCHAR2_TABLE_200
600     , p8_a68 in out nocopy JTF_VARCHAR2_TABLE_200
601     , p8_a69 in out nocopy JTF_VARCHAR2_TABLE_200
602     , p8_a70 in out nocopy JTF_VARCHAR2_TABLE_200
603     , p8_a71 in out nocopy JTF_VARCHAR2_TABLE_200
604     , p8_a72 in out nocopy JTF_VARCHAR2_TABLE_200
605     , p8_a73 in out nocopy JTF_VARCHAR2_TABLE_200
606     , p8_a74 in out nocopy JTF_VARCHAR2_TABLE_200
607     , p8_a75 in out nocopy JTF_VARCHAR2_TABLE_200
608     , p8_a76 in out nocopy JTF_VARCHAR2_TABLE_200
609     , p8_a77 in out nocopy JTF_VARCHAR2_TABLE_200
610     , p8_a78 in out nocopy JTF_VARCHAR2_TABLE_200
611     , p8_a79 in out nocopy JTF_VARCHAR2_TABLE_200
612     , p8_a80 in out nocopy JTF_VARCHAR2_TABLE_200
613     , p8_a81 in out nocopy JTF_VARCHAR2_TABLE_200
614     , p8_a82 in out nocopy JTF_VARCHAR2_TABLE_200
615     , p8_a83 in out nocopy JTF_VARCHAR2_TABLE_200
616     , p8_a84 in out nocopy JTF_VARCHAR2_TABLE_200
617     , p8_a85 in out nocopy JTF_VARCHAR2_TABLE_200
618     , p8_a86 in out nocopy JTF_VARCHAR2_TABLE_200
619     , p8_a87 in out nocopy JTF_VARCHAR2_TABLE_200
620     , p8_a88 in out nocopy JTF_VARCHAR2_TABLE_200
621     , p8_a89 in out nocopy JTF_VARCHAR2_TABLE_200
622     , p8_a90 in out nocopy JTF_VARCHAR2_TABLE_200
623     , p8_a91 in out nocopy JTF_VARCHAR2_TABLE_200
624     , p8_a92 in out nocopy JTF_VARCHAR2_TABLE_200
625     , p8_a93 in out nocopy JTF_VARCHAR2_TABLE_200
626     , p8_a94 in out nocopy JTF_VARCHAR2_TABLE_200
627     , p8_a95 in out nocopy JTF_VARCHAR2_TABLE_200
628     , p8_a96 in out nocopy JTF_VARCHAR2_TABLE_200
629     , p8_a97 in out nocopy JTF_VARCHAR2_TABLE_200
630     , p8_a98 in out nocopy JTF_VARCHAR2_TABLE_200
631     , p8_a99 in out nocopy JTF_VARCHAR2_TABLE_200
632     , p8_a100 in out nocopy JTF_VARCHAR2_TABLE_200
633     , p8_a101 in out nocopy JTF_VARCHAR2_TABLE_200
634     , p8_a102 in out nocopy JTF_VARCHAR2_TABLE_200
635     , p8_a103 in out nocopy JTF_VARCHAR2_TABLE_200
636     , p8_a104 in out nocopy JTF_VARCHAR2_TABLE_200
637     , p8_a105 in out nocopy JTF_VARCHAR2_TABLE_100
638     , p8_a106 in out nocopy JTF_VARCHAR2_TABLE_200
639     , p8_a107 in out nocopy JTF_VARCHAR2_TABLE_200
640     , p8_a108 in out nocopy JTF_VARCHAR2_TABLE_200
641     , p8_a109 in out nocopy JTF_VARCHAR2_TABLE_200
642     , p8_a110 in out nocopy JTF_VARCHAR2_TABLE_200
643     , p8_a111 in out nocopy JTF_VARCHAR2_TABLE_200
644     , p8_a112 in out nocopy JTF_VARCHAR2_TABLE_200
645     , p8_a113 in out nocopy JTF_VARCHAR2_TABLE_200
646     , p8_a114 in out nocopy JTF_VARCHAR2_TABLE_200
647     , p8_a115 in out nocopy JTF_VARCHAR2_TABLE_200
648     , p8_a116 in out nocopy JTF_VARCHAR2_TABLE_200
649     , p8_a117 in out nocopy JTF_VARCHAR2_TABLE_200
650     , p8_a118 in out nocopy JTF_VARCHAR2_TABLE_200
651     , p8_a119 in out nocopy JTF_VARCHAR2_TABLE_200
652     , p8_a120 in out nocopy JTF_VARCHAR2_TABLE_200
653     , p8_a121 in out nocopy JTF_NUMBER_TABLE
654     , p8_a122 in out nocopy JTF_NUMBER_TABLE
655     , p9_a0 in out nocopy JTF_NUMBER_TABLE
656     , p9_a1 in out nocopy JTF_NUMBER_TABLE
657     , p9_a2 in out nocopy JTF_NUMBER_TABLE
658     , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
659     , p9_a4 in out nocopy JTF_DATE_TABLE
660     , p9_a5 in out nocopy JTF_DATE_TABLE
661     , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
662     , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
663     , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200
664     , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
665     , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200
666     , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
667     , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
668     , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
669     , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
670     , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
671     , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
672     , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
673     , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
674     , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
675     , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
676     , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
677     , p9_a22 in out nocopy JTF_NUMBER_TABLE
678     , p9_a23 in out nocopy JTF_NUMBER_TABLE
679     , p10_a0 in out nocopy JTF_NUMBER_TABLE
680     , p10_a1 in out nocopy JTF_NUMBER_TABLE
681     , p10_a2 in out nocopy JTF_NUMBER_TABLE
682     , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
683     , p10_a4 in out nocopy JTF_NUMBER_TABLE
684     , p10_a5 in out nocopy JTF_NUMBER_TABLE
685     , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
686     , p10_a7 in out nocopy JTF_DATE_TABLE
687     , p10_a8 in out nocopy JTF_DATE_TABLE
688     , p10_a9 in out nocopy JTF_NUMBER_TABLE
689     , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
690     , p10_a11 in out nocopy JTF_NUMBER_TABLE
691     , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
692     , p10_a13 in out nocopy JTF_NUMBER_TABLE
693     , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_100
694     , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_100
695     , p11_a0 in out nocopy  NUMBER
696     , p11_a1 in out nocopy  DATE
697     , p11_a2 in out nocopy  DATE
698     , p11_a3 in out nocopy  NUMBER
699     , p11_a4 in out nocopy  NUMBER
700     , p11_a5 in out nocopy  NUMBER
701     , p11_a6 in out nocopy  VARCHAR2
702     , p11_a7 in out nocopy  NUMBER
703     , p11_a8 in out nocopy  VARCHAR2
704     , p11_a9 in out nocopy  NUMBER
705     , p11_a10 in out nocopy  VARCHAR2
706     , p11_a11 in out nocopy  NUMBER
707     , p11_a12 in out nocopy  NUMBER
708     , p11_a13 in out nocopy  NUMBER
709     , p11_a14 in out nocopy  NUMBER
710     , p11_a15 in out nocopy  VARCHAR2
711     , p11_a16 in out nocopy  NUMBER
712     , p11_a17 in out nocopy  VARCHAR2
713     , p11_a18 in out nocopy  VARCHAR2
714     , p11_a19 in out nocopy  NUMBER
715     , p11_a20 in out nocopy  VARCHAR2
716     , p11_a21 in out nocopy  VARCHAR2
717     , p11_a22 in out nocopy  VARCHAR2
718     , p11_a23 in out nocopy  VARCHAR2
719     , p11_a24 in out nocopy  VARCHAR2
720     , p11_a25 in out nocopy  VARCHAR2
721     , p11_a26 in out nocopy  VARCHAR2
722     , p11_a27 in out nocopy  VARCHAR2
723     , p11_a28 in out nocopy  VARCHAR2
724     , p11_a29 in out nocopy  VARCHAR2
725     , p11_a30 in out nocopy  VARCHAR2
726     , p11_a31 in out nocopy  VARCHAR2
727     , p11_a32 in out nocopy  VARCHAR2
728     , p11_a33 in out nocopy  VARCHAR2
729     , p11_a34 in out nocopy  VARCHAR2
730     , p11_a35 in out nocopy  VARCHAR2
731     , p11_a36 in out nocopy  NUMBER
732     , p11_a37 in out nocopy  VARCHAR2
733     , p11_a38 in out nocopy  DATE
734     , p11_a39 in out nocopy  NUMBER
735     , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
736     , x_return_status out nocopy  VARCHAR2
737     , x_msg_count out nocopy  NUMBER
738     , x_msg_data out nocopy  VARCHAR2
739     , p4_a0  NUMBER := 0-1962.0724
740     , p4_a1  VARCHAR2 := fnd_api.g_miss_char
741     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
742     , p4_a3  NUMBER := 0-1962.0724
743     , p4_a4  NUMBER := 0-1962.0724
744     , p4_a5  VARCHAR2 := fnd_api.g_miss_char
745     , p4_a6  NUMBER := 0-1962.0724
746     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
747     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
748     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
749     , p4_a10  NUMBER := 0-1962.0724
750     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
751     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
752     , p4_a13  NUMBER := 0-1962.0724
753     , p4_a14  NUMBER := 0-1962.0724
754     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
755     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
756     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
757     , p4_a18  NUMBER := 0-1962.0724
758     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
759     , p4_a20  DATE := fnd_api.g_miss_date
760     , p4_a21  DATE := fnd_api.g_miss_date
761     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
762     , p4_a23  NUMBER := 0-1962.0724
763     , p4_a24  NUMBER := 0-1962.0724
764     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
765     , p4_a26  NUMBER := 0-1962.0724
766     , p4_a27  NUMBER := 0-1962.0724
767     , p4_a28  NUMBER := 0-1962.0724
768     , p4_a29  NUMBER := 0-1962.0724
769     , p4_a30  NUMBER := 0-1962.0724
770     , p4_a31  NUMBER := 0-1962.0724
771     , p4_a32  NUMBER := 0-1962.0724
772     , p4_a33  NUMBER := 0-1962.0724
773     , p4_a34  NUMBER := 0-1962.0724
774     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
775     , p4_a36  NUMBER := 0-1962.0724
776     , p4_a37  NUMBER := 0-1962.0724
777     , p4_a38  NUMBER := 0-1962.0724
778     , p4_a39  NUMBER := 0-1962.0724
779     , p4_a40  DATE := fnd_api.g_miss_date
780     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
781     , p4_a42  DATE := fnd_api.g_miss_date
782     , p4_a43  DATE := fnd_api.g_miss_date
783     , p4_a44  VARCHAR2 := fnd_api.g_miss_char
784     , p4_a45  VARCHAR2 := fnd_api.g_miss_char
785     , p4_a46  VARCHAR2 := fnd_api.g_miss_char
786     , p4_a47  VARCHAR2 := fnd_api.g_miss_char
787     , p4_a48  VARCHAR2 := fnd_api.g_miss_char
788     , p4_a49  VARCHAR2 := fnd_api.g_miss_char
789     , p4_a50  VARCHAR2 := fnd_api.g_miss_char
790     , p4_a51  VARCHAR2 := fnd_api.g_miss_char
791     , p4_a52  VARCHAR2 := fnd_api.g_miss_char
792     , p4_a53  VARCHAR2 := fnd_api.g_miss_char
793     , p4_a54  VARCHAR2 := fnd_api.g_miss_char
794     , p4_a55  VARCHAR2 := fnd_api.g_miss_char
795     , p4_a56  VARCHAR2 := fnd_api.g_miss_char
796     , p4_a57  VARCHAR2 := fnd_api.g_miss_char
797     , p4_a58  VARCHAR2 := fnd_api.g_miss_char
798     , p4_a59  VARCHAR2 := fnd_api.g_miss_char
799     , p4_a60  VARCHAR2 := fnd_api.g_miss_char
800     , p4_a61  VARCHAR2 := fnd_api.g_miss_char
801     , p4_a62  VARCHAR2 := fnd_api.g_miss_char
802     , p4_a63  VARCHAR2 := fnd_api.g_miss_char
803     , p4_a64  NUMBER := 0-1962.0724
804     , p4_a65  NUMBER := 0-1962.0724
805     , p4_a66  VARCHAR2 := fnd_api.g_miss_char
806     , p4_a67  NUMBER := 0-1962.0724
807     , p4_a68  VARCHAR2 := fnd_api.g_miss_char
808     , p4_a69  VARCHAR2 := fnd_api.g_miss_char
809     , p4_a70  VARCHAR2 := fnd_api.g_miss_char
810     , p4_a71  VARCHAR2 := fnd_api.g_miss_char
811     , p4_a72  NUMBER := 0-1962.0724
812     , p4_a73  VARCHAR2 := fnd_api.g_miss_char
813     , p4_a74  NUMBER := 0-1962.0724
814     , p4_a75  NUMBER := 0-1962.0724
815     , p4_a76  NUMBER := 0-1962.0724
816     , p4_a77  VARCHAR2 := fnd_api.g_miss_char
817     , p4_a78  VARCHAR2 := fnd_api.g_miss_char
818     , p4_a79  VARCHAR2 := fnd_api.g_miss_char
819     , p4_a80  NUMBER := 0-1962.0724
820     , p4_a81  NUMBER := 0-1962.0724
821     , p4_a82  NUMBER := 0-1962.0724
822     , p4_a83  DATE := fnd_api.g_miss_date
823     , p4_a84  VARCHAR2 := fnd_api.g_miss_char
824     , p4_a85  VARCHAR2 := fnd_api.g_miss_char
825     , p4_a86  VARCHAR2 := fnd_api.g_miss_char
826     , p4_a87  NUMBER := 0-1962.0724
827     , p4_a88  VARCHAR2 := fnd_api.g_miss_char
828     , p4_a89  NUMBER := 0-1962.0724
829     , p4_a90  NUMBER := 0-1962.0724
830     , p4_a91  VARCHAR2 := fnd_api.g_miss_char
831     , p4_a92  NUMBER := 0-1962.0724
832     , p4_a93  VARCHAR2 := fnd_api.g_miss_char
833     , p4_a94  NUMBER := 0-1962.0724
834     , p4_a95  DATE := fnd_api.g_miss_date
835     , p4_a96  VARCHAR2 := fnd_api.g_miss_char
836     , p4_a97  VARCHAR2 := fnd_api.g_miss_char
837     , p4_a98  VARCHAR2 := fnd_api.g_miss_char
838     , p4_a99  VARCHAR2 := fnd_api.g_miss_char
839     , p4_a100  VARCHAR2 := fnd_api.g_miss_char
840     , p4_a101  VARCHAR2 := fnd_api.g_miss_char
841     , p4_a102  VARCHAR2 := fnd_api.g_miss_char
842     , p4_a103  VARCHAR2 := fnd_api.g_miss_char
843     , p4_a104  VARCHAR2 := fnd_api.g_miss_char
844     , p4_a105  VARCHAR2 := fnd_api.g_miss_char
845     , p4_a106  VARCHAR2 := fnd_api.g_miss_char
846     , p4_a107  VARCHAR2 := fnd_api.g_miss_char
847     , p4_a108  VARCHAR2 := fnd_api.g_miss_char
848     , p4_a109  VARCHAR2 := fnd_api.g_miss_char
849     , p4_a110  VARCHAR2 := fnd_api.g_miss_char
850     , p4_a111  NUMBER := 0-1962.0724
851     , p4_a112  VARCHAR2 := fnd_api.g_miss_char
852     , p4_a113  NUMBER := 0-1962.0724
853     , p4_a114  VARCHAR2 := fnd_api.g_miss_char
854     , p4_a115  NUMBER := 0-1962.0724
855     , p4_a116  VARCHAR2 := fnd_api.g_miss_char
856     , p4_a117  VARCHAR2 := fnd_api.g_miss_char
857     , p4_a118  NUMBER := 0-1962.0724
858     , p4_a119  VARCHAR2 := fnd_api.g_miss_char
859     , p4_a120  NUMBER := 0-1962.0724
860     , p4_a121  NUMBER := 0-1962.0724
861     , p4_a122  VARCHAR2 := fnd_api.g_miss_char
862   );
863   procedure expire_item_instance(p_api_version  NUMBER
864     , p_commit  VARCHAR2
865     , p_init_msg_list  VARCHAR2
866     , p_validation_level  NUMBER
867     , p_expire_children  VARCHAR2
868     , p6_a0 in out nocopy  NUMBER
869     , p6_a1 in out nocopy  DATE
870     , p6_a2 in out nocopy  DATE
871     , p6_a3 in out nocopy  NUMBER
872     , p6_a4 in out nocopy  NUMBER
873     , p6_a5 in out nocopy  NUMBER
874     , p6_a6 in out nocopy  VARCHAR2
875     , p6_a7 in out nocopy  NUMBER
876     , p6_a8 in out nocopy  VARCHAR2
877     , p6_a9 in out nocopy  NUMBER
878     , p6_a10 in out nocopy  VARCHAR2
879     , p6_a11 in out nocopy  NUMBER
880     , p6_a12 in out nocopy  NUMBER
881     , p6_a13 in out nocopy  NUMBER
882     , p6_a14 in out nocopy  NUMBER
883     , p6_a15 in out nocopy  VARCHAR2
884     , p6_a16 in out nocopy  NUMBER
885     , p6_a17 in out nocopy  VARCHAR2
886     , p6_a18 in out nocopy  VARCHAR2
887     , p6_a19 in out nocopy  NUMBER
888     , p6_a20 in out nocopy  VARCHAR2
889     , p6_a21 in out nocopy  VARCHAR2
890     , p6_a22 in out nocopy  VARCHAR2
891     , p6_a23 in out nocopy  VARCHAR2
892     , p6_a24 in out nocopy  VARCHAR2
893     , p6_a25 in out nocopy  VARCHAR2
894     , p6_a26 in out nocopy  VARCHAR2
895     , p6_a27 in out nocopy  VARCHAR2
896     , p6_a28 in out nocopy  VARCHAR2
897     , p6_a29 in out nocopy  VARCHAR2
898     , p6_a30 in out nocopy  VARCHAR2
899     , p6_a31 in out nocopy  VARCHAR2
900     , p6_a32 in out nocopy  VARCHAR2
901     , p6_a33 in out nocopy  VARCHAR2
902     , p6_a34 in out nocopy  VARCHAR2
903     , p6_a35 in out nocopy  VARCHAR2
904     , p6_a36 in out nocopy  NUMBER
905     , p6_a37 in out nocopy  VARCHAR2
906     , p6_a38 in out nocopy  DATE
907     , p6_a39 in out nocopy  NUMBER
908     , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
909     , x_return_status out nocopy  VARCHAR2
910     , x_msg_count out nocopy  NUMBER
911     , x_msg_data out nocopy  VARCHAR2
912     , p4_a0  NUMBER := 0-1962.0724
913     , p4_a1  VARCHAR2 := fnd_api.g_miss_char
914     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
915     , p4_a3  NUMBER := 0-1962.0724
916     , p4_a4  NUMBER := 0-1962.0724
917     , p4_a5  VARCHAR2 := fnd_api.g_miss_char
918     , p4_a6  NUMBER := 0-1962.0724
919     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
920     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
921     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
922     , p4_a10  NUMBER := 0-1962.0724
923     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
924     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
925     , p4_a13  NUMBER := 0-1962.0724
926     , p4_a14  NUMBER := 0-1962.0724
927     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
928     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
929     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
930     , p4_a18  NUMBER := 0-1962.0724
931     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
932     , p4_a20  DATE := fnd_api.g_miss_date
933     , p4_a21  DATE := fnd_api.g_miss_date
934     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
935     , p4_a23  NUMBER := 0-1962.0724
936     , p4_a24  NUMBER := 0-1962.0724
937     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
938     , p4_a26  NUMBER := 0-1962.0724
939     , p4_a27  NUMBER := 0-1962.0724
940     , p4_a28  NUMBER := 0-1962.0724
941     , p4_a29  NUMBER := 0-1962.0724
942     , p4_a30  NUMBER := 0-1962.0724
943     , p4_a31  NUMBER := 0-1962.0724
944     , p4_a32  NUMBER := 0-1962.0724
945     , p4_a33  NUMBER := 0-1962.0724
946     , p4_a34  NUMBER := 0-1962.0724
947     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
948     , p4_a36  NUMBER := 0-1962.0724
949     , p4_a37  NUMBER := 0-1962.0724
950     , p4_a38  NUMBER := 0-1962.0724
951     , p4_a39  NUMBER := 0-1962.0724
952     , p4_a40  DATE := fnd_api.g_miss_date
953     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
954     , p4_a42  DATE := fnd_api.g_miss_date
955     , p4_a43  DATE := fnd_api.g_miss_date
956     , p4_a44  VARCHAR2 := fnd_api.g_miss_char
957     , p4_a45  VARCHAR2 := fnd_api.g_miss_char
958     , p4_a46  VARCHAR2 := fnd_api.g_miss_char
959     , p4_a47  VARCHAR2 := fnd_api.g_miss_char
960     , p4_a48  VARCHAR2 := fnd_api.g_miss_char
961     , p4_a49  VARCHAR2 := fnd_api.g_miss_char
962     , p4_a50  VARCHAR2 := fnd_api.g_miss_char
963     , p4_a51  VARCHAR2 := fnd_api.g_miss_char
964     , p4_a52  VARCHAR2 := fnd_api.g_miss_char
965     , p4_a53  VARCHAR2 := fnd_api.g_miss_char
966     , p4_a54  VARCHAR2 := fnd_api.g_miss_char
967     , p4_a55  VARCHAR2 := fnd_api.g_miss_char
968     , p4_a56  VARCHAR2 := fnd_api.g_miss_char
969     , p4_a57  VARCHAR2 := fnd_api.g_miss_char
970     , p4_a58  VARCHAR2 := fnd_api.g_miss_char
971     , p4_a59  VARCHAR2 := fnd_api.g_miss_char
972     , p4_a60  VARCHAR2 := fnd_api.g_miss_char
973     , p4_a61  VARCHAR2 := fnd_api.g_miss_char
974     , p4_a62  VARCHAR2 := fnd_api.g_miss_char
975     , p4_a63  VARCHAR2 := fnd_api.g_miss_char
976     , p4_a64  NUMBER := 0-1962.0724
977     , p4_a65  NUMBER := 0-1962.0724
978     , p4_a66  VARCHAR2 := fnd_api.g_miss_char
979     , p4_a67  NUMBER := 0-1962.0724
980     , p4_a68  VARCHAR2 := fnd_api.g_miss_char
981     , p4_a69  VARCHAR2 := fnd_api.g_miss_char
982     , p4_a70  VARCHAR2 := fnd_api.g_miss_char
983     , p4_a71  VARCHAR2 := fnd_api.g_miss_char
984     , p4_a72  NUMBER := 0-1962.0724
985     , p4_a73  VARCHAR2 := fnd_api.g_miss_char
986     , p4_a74  NUMBER := 0-1962.0724
987     , p4_a75  NUMBER := 0-1962.0724
988     , p4_a76  NUMBER := 0-1962.0724
989     , p4_a77  VARCHAR2 := fnd_api.g_miss_char
990     , p4_a78  VARCHAR2 := fnd_api.g_miss_char
991     , p4_a79  VARCHAR2 := fnd_api.g_miss_char
992     , p4_a80  NUMBER := 0-1962.0724
993     , p4_a81  NUMBER := 0-1962.0724
994     , p4_a82  NUMBER := 0-1962.0724
995     , p4_a83  DATE := fnd_api.g_miss_date
996     , p4_a84  VARCHAR2 := fnd_api.g_miss_char
997     , p4_a85  VARCHAR2 := fnd_api.g_miss_char
998     , p4_a86  VARCHAR2 := fnd_api.g_miss_char
999     , p4_a87  NUMBER := 0-1962.0724
1000     , p4_a88  VARCHAR2 := fnd_api.g_miss_char
1001     , p4_a89  NUMBER := 0-1962.0724
1002     , p4_a90  NUMBER := 0-1962.0724
1003     , p4_a91  VARCHAR2 := fnd_api.g_miss_char
1004     , p4_a92  NUMBER := 0-1962.0724
1005     , p4_a93  VARCHAR2 := fnd_api.g_miss_char
1006     , p4_a94  NUMBER := 0-1962.0724
1007     , p4_a95  DATE := fnd_api.g_miss_date
1008     , p4_a96  VARCHAR2 := fnd_api.g_miss_char
1009     , p4_a97  VARCHAR2 := fnd_api.g_miss_char
1010     , p4_a98  VARCHAR2 := fnd_api.g_miss_char
1011     , p4_a99  VARCHAR2 := fnd_api.g_miss_char
1012     , p4_a100  VARCHAR2 := fnd_api.g_miss_char
1013     , p4_a101  VARCHAR2 := fnd_api.g_miss_char
1014     , p4_a102  VARCHAR2 := fnd_api.g_miss_char
1015     , p4_a103  VARCHAR2 := fnd_api.g_miss_char
1016     , p4_a104  VARCHAR2 := fnd_api.g_miss_char
1017     , p4_a105  VARCHAR2 := fnd_api.g_miss_char
1018     , p4_a106  VARCHAR2 := fnd_api.g_miss_char
1019     , p4_a107  VARCHAR2 := fnd_api.g_miss_char
1020     , p4_a108  VARCHAR2 := fnd_api.g_miss_char
1021     , p4_a109  VARCHAR2 := fnd_api.g_miss_char
1022     , p4_a110  VARCHAR2 := fnd_api.g_miss_char
1023     , p4_a111  NUMBER := 0-1962.0724
1024     , p4_a112  VARCHAR2 := fnd_api.g_miss_char
1025     , p4_a113  NUMBER := 0-1962.0724
1026     , p4_a114  VARCHAR2 := fnd_api.g_miss_char
1027     , p4_a115  NUMBER := 0-1962.0724
1028     , p4_a116  VARCHAR2 := fnd_api.g_miss_char
1029     , p4_a117  VARCHAR2 := fnd_api.g_miss_char
1030     , p4_a118  NUMBER := 0-1962.0724
1031     , p4_a119  VARCHAR2 := fnd_api.g_miss_char
1032     , p4_a120  NUMBER := 0-1962.0724
1033     , p4_a121  NUMBER := 0-1962.0724
1034     , p4_a122  VARCHAR2 := fnd_api.g_miss_char
1035   );
1036   procedure get_item_instances(p_api_version  NUMBER
1037     , p_commit  VARCHAR2
1038     , p_init_msg_list  VARCHAR2
1039     , p_validation_level  NUMBER
1040     , p_transaction_id  NUMBER
1041     , p_resolve_id_columns  VARCHAR2
1042     , p_active_instance_only  VARCHAR2
1043     , p10_a0 out nocopy JTF_NUMBER_TABLE
1044     , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
1045     , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
1046     , p10_a3 out nocopy JTF_NUMBER_TABLE
1047     , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
1048     , p10_a5 out nocopy JTF_NUMBER_TABLE
1049     , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
1050     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
1051     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
1052     , p10_a9 out nocopy JTF_NUMBER_TABLE
1053     , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
1054     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
1055     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
1056     , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
1057     , p10_a14 out nocopy JTF_VARCHAR2_TABLE_100
1058     , p10_a15 out nocopy JTF_NUMBER_TABLE
1059     , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
1060     , p10_a17 out nocopy JTF_NUMBER_TABLE
1061     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
1062     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
1063     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
1064     , p10_a21 out nocopy JTF_NUMBER_TABLE
1065     , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
1066     , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
1067     , p10_a24 out nocopy JTF_VARCHAR2_TABLE_300
1068     , p10_a25 out nocopy JTF_DATE_TABLE
1069     , p10_a26 out nocopy JTF_DATE_TABLE
1070     , p10_a27 out nocopy JTF_VARCHAR2_TABLE_100
1071     , p10_a28 out nocopy JTF_NUMBER_TABLE
1072     , p10_a29 out nocopy JTF_NUMBER_TABLE
1073     , p10_a30 out nocopy JTF_VARCHAR2_TABLE_100
1074     , p10_a31 out nocopy JTF_VARCHAR2_TABLE_100
1075     , p10_a32 out nocopy JTF_NUMBER_TABLE
1076     , p10_a33 out nocopy JTF_NUMBER_TABLE
1077     , p10_a34 out nocopy JTF_NUMBER_TABLE
1078     , p10_a35 out nocopy JTF_VARCHAR2_TABLE_100
1079     , p10_a36 out nocopy JTF_VARCHAR2_TABLE_100
1080     , p10_a37 out nocopy JTF_VARCHAR2_TABLE_100
1081     , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
1082     , p10_a39 out nocopy JTF_NUMBER_TABLE
1083     , p10_a40 out nocopy JTF_NUMBER_TABLE
1084     , p10_a41 out nocopy JTF_NUMBER_TABLE
1085     , p10_a42 out nocopy JTF_NUMBER_TABLE
1086     , p10_a43 out nocopy JTF_VARCHAR2_TABLE_300
1087     , p10_a44 out nocopy JTF_NUMBER_TABLE
1088     , p10_a45 out nocopy JTF_NUMBER_TABLE
1089     , p10_a46 out nocopy JTF_NUMBER_TABLE
1090     , p10_a47 out nocopy JTF_NUMBER_TABLE
1091     , p10_a48 out nocopy JTF_VARCHAR2_TABLE_100
1092     , p10_a49 out nocopy JTF_NUMBER_TABLE
1093     , p10_a50 out nocopy JTF_NUMBER_TABLE
1094     , p10_a51 out nocopy JTF_NUMBER_TABLE
1095     , p10_a52 out nocopy JTF_NUMBER_TABLE
1096     , p10_a53 out nocopy JTF_DATE_TABLE
1097     , p10_a54 out nocopy JTF_VARCHAR2_TABLE_100
1098     , p10_a55 out nocopy JTF_DATE_TABLE
1099     , p10_a56 out nocopy JTF_DATE_TABLE
1100     , p10_a57 out nocopy JTF_VARCHAR2_TABLE_100
1101     , p10_a58 out nocopy JTF_VARCHAR2_TABLE_100
1102     , p10_a59 out nocopy JTF_VARCHAR2_TABLE_100
1103     , p10_a60 out nocopy JTF_VARCHAR2_TABLE_300
1104     , p10_a61 out nocopy JTF_VARCHAR2_TABLE_300
1105     , p10_a62 out nocopy JTF_VARCHAR2_TABLE_300
1106     , p10_a63 out nocopy JTF_VARCHAR2_TABLE_300
1107     , p10_a64 out nocopy JTF_VARCHAR2_TABLE_300
1108     , p10_a65 out nocopy JTF_VARCHAR2_TABLE_300
1109     , p10_a66 out nocopy JTF_VARCHAR2_TABLE_300
1110     , p10_a67 out nocopy JTF_VARCHAR2_TABLE_300
1111     , p10_a68 out nocopy JTF_VARCHAR2_TABLE_300
1112     , p10_a69 out nocopy JTF_VARCHAR2_TABLE_300
1113     , p10_a70 out nocopy JTF_VARCHAR2_TABLE_300
1114     , p10_a71 out nocopy JTF_VARCHAR2_TABLE_300
1115     , p10_a72 out nocopy JTF_VARCHAR2_TABLE_300
1116     , p10_a73 out nocopy JTF_VARCHAR2_TABLE_300
1117     , p10_a74 out nocopy JTF_VARCHAR2_TABLE_300
1118     , p10_a75 out nocopy JTF_NUMBER_TABLE
1119     , p10_a76 out nocopy JTF_NUMBER_TABLE
1120     , p10_a77 out nocopy JTF_VARCHAR2_TABLE_100
1121     , p10_a78 out nocopy JTF_NUMBER_TABLE
1122     , p10_a79 out nocopy JTF_VARCHAR2_TABLE_100
1123     , p10_a80 out nocopy JTF_VARCHAR2_TABLE_300
1124     , p10_a81 out nocopy JTF_VARCHAR2_TABLE_300
1125     , p10_a82 out nocopy JTF_VARCHAR2_TABLE_300
1126     , p10_a83 out nocopy JTF_VARCHAR2_TABLE_300
1127     , p10_a84 out nocopy JTF_VARCHAR2_TABLE_100
1128     , p10_a85 out nocopy JTF_VARCHAR2_TABLE_200
1129     , p10_a86 out nocopy JTF_VARCHAR2_TABLE_100
1130     , p10_a87 out nocopy JTF_VARCHAR2_TABLE_100
1131     , p10_a88 out nocopy JTF_NUMBER_TABLE
1132     , p10_a89 out nocopy JTF_NUMBER_TABLE
1133     , p10_a90 out nocopy JTF_DATE_TABLE
1134     , p10_a91 out nocopy JTF_VARCHAR2_TABLE_100
1135     , p10_a92 out nocopy JTF_VARCHAR2_TABLE_100
1136     , p10_a93 out nocopy JTF_VARCHAR2_TABLE_300
1137     , p10_a94 out nocopy JTF_VARCHAR2_TABLE_300
1138     , p10_a95 out nocopy JTF_VARCHAR2_TABLE_300
1139     , p10_a96 out nocopy JTF_VARCHAR2_TABLE_300
1140     , p10_a97 out nocopy JTF_VARCHAR2_TABLE_100
1141     , p10_a98 out nocopy JTF_VARCHAR2_TABLE_200
1142     , p10_a99 out nocopy JTF_VARCHAR2_TABLE_100
1143     , p10_a100 out nocopy JTF_VARCHAR2_TABLE_100
1144     , p10_a101 out nocopy JTF_NUMBER_TABLE
1145     , p10_a102 out nocopy JTF_VARCHAR2_TABLE_100
1146     , p10_a103 out nocopy JTF_VARCHAR2_TABLE_100
1147     , p10_a104 out nocopy JTF_VARCHAR2_TABLE_400
1148     , p10_a105 out nocopy JTF_VARCHAR2_TABLE_100
1149     , p10_a106 out nocopy JTF_VARCHAR2_TABLE_400
1150     , p10_a107 out nocopy JTF_VARCHAR2_TABLE_100
1151     , p10_a108 out nocopy JTF_NUMBER_TABLE
1152     , p10_a109 out nocopy JTF_NUMBER_TABLE
1153     , p10_a110 out nocopy JTF_NUMBER_TABLE
1154     , p10_a111 out nocopy JTF_VARCHAR2_TABLE_100
1155     , p10_a112 out nocopy JTF_VARCHAR2_TABLE_300
1156     , p10_a113 out nocopy JTF_VARCHAR2_TABLE_300
1157     , p10_a114 out nocopy JTF_VARCHAR2_TABLE_300
1158     , p10_a115 out nocopy JTF_VARCHAR2_TABLE_300
1159     , p10_a116 out nocopy JTF_VARCHAR2_TABLE_300
1160     , p10_a117 out nocopy JTF_VARCHAR2_TABLE_100
1161     , p10_a118 out nocopy JTF_VARCHAR2_TABLE_100
1162     , p10_a119 out nocopy JTF_VARCHAR2_TABLE_100
1163     , p10_a120 out nocopy JTF_VARCHAR2_TABLE_100
1164     , p10_a121 out nocopy JTF_VARCHAR2_TABLE_300
1165     , p10_a122 out nocopy JTF_VARCHAR2_TABLE_300
1166     , p10_a123 out nocopy JTF_VARCHAR2_TABLE_300
1167     , p10_a124 out nocopy JTF_VARCHAR2_TABLE_300
1168     , p10_a125 out nocopy JTF_VARCHAR2_TABLE_100
1169     , p10_a126 out nocopy JTF_VARCHAR2_TABLE_100
1170     , p10_a127 out nocopy JTF_VARCHAR2_TABLE_100
1171     , p10_a128 out nocopy JTF_VARCHAR2_TABLE_100
1172     , p10_a129 out nocopy JTF_VARCHAR2_TABLE_100
1173     , p10_a130 out nocopy JTF_VARCHAR2_TABLE_300
1174     , p10_a131 out nocopy JTF_VARCHAR2_TABLE_300
1175     , p10_a132 out nocopy JTF_VARCHAR2_TABLE_100
1176     , p10_a133 out nocopy JTF_VARCHAR2_TABLE_100
1177     , p10_a134 out nocopy JTF_NUMBER_TABLE
1178     , p10_a135 out nocopy JTF_VARCHAR2_TABLE_100
1179     , p10_a136 out nocopy JTF_NUMBER_TABLE
1180     , p10_a137 out nocopy JTF_NUMBER_TABLE
1181     , p10_a138 out nocopy JTF_VARCHAR2_TABLE_100
1182     , p10_a139 out nocopy JTF_NUMBER_TABLE
1183     , p10_a140 out nocopy JTF_VARCHAR2_TABLE_100
1184     , p10_a141 out nocopy JTF_NUMBER_TABLE
1185     , p10_a142 out nocopy JTF_DATE_TABLE
1186     , p10_a143 out nocopy JTF_VARCHAR2_TABLE_300
1187     , p10_a144 out nocopy JTF_VARCHAR2_TABLE_300
1188     , p10_a145 out nocopy JTF_VARCHAR2_TABLE_300
1189     , p10_a146 out nocopy JTF_VARCHAR2_TABLE_300
1190     , p10_a147 out nocopy JTF_VARCHAR2_TABLE_300
1191     , p10_a148 out nocopy JTF_VARCHAR2_TABLE_300
1192     , p10_a149 out nocopy JTF_VARCHAR2_TABLE_300
1193     , p10_a150 out nocopy JTF_VARCHAR2_TABLE_300
1194     , p10_a151 out nocopy JTF_VARCHAR2_TABLE_300
1195     , p10_a152 out nocopy JTF_VARCHAR2_TABLE_300
1196     , p10_a153 out nocopy JTF_VARCHAR2_TABLE_300
1197     , p10_a154 out nocopy JTF_VARCHAR2_TABLE_300
1198     , p10_a155 out nocopy JTF_VARCHAR2_TABLE_300
1199     , p10_a156 out nocopy JTF_VARCHAR2_TABLE_300
1200     , p10_a157 out nocopy JTF_VARCHAR2_TABLE_300
1201     , p10_a158 out nocopy JTF_NUMBER_TABLE
1202     , p10_a159 out nocopy JTF_VARCHAR2_TABLE_100
1203     , p10_a160 out nocopy JTF_NUMBER_TABLE
1204     , p10_a161 out nocopy JTF_VARCHAR2_TABLE_100
1205     , p10_a162 out nocopy JTF_NUMBER_TABLE
1206     , p10_a163 out nocopy JTF_VARCHAR2_TABLE_100
1207     , p10_a164 out nocopy JTF_VARCHAR2_TABLE_100
1208     , p10_a165 out nocopy JTF_VARCHAR2_TABLE_100
1209     , p10_a166 out nocopy JTF_VARCHAR2_TABLE_100
1210     , p10_a167 out nocopy JTF_VARCHAR2_TABLE_100
1211     , p10_a168 out nocopy JTF_VARCHAR2_TABLE_100
1212     , p10_a169 out nocopy JTF_VARCHAR2_TABLE_100
1213     , p10_a170 out nocopy JTF_VARCHAR2_TABLE_100
1214     , p10_a171 out nocopy JTF_VARCHAR2_TABLE_100
1215     , p10_a172 out nocopy JTF_VARCHAR2_TABLE_200
1216     , p10_a173 out nocopy JTF_VARCHAR2_TABLE_100
1217     , p10_a174 out nocopy JTF_VARCHAR2_TABLE_100
1218     , p10_a175 out nocopy JTF_VARCHAR2_TABLE_100
1219     , p10_a176 out nocopy JTF_VARCHAR2_TABLE_100
1220     , x_return_status out nocopy  VARCHAR2
1221     , x_msg_count out nocopy  NUMBER
1222     , x_msg_data out nocopy  VARCHAR2
1223     , p4_a0  NUMBER := 0-1962.0724
1224     , p4_a1  NUMBER := 0-1962.0724
1225     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
1226     , p4_a3  NUMBER := 0-1962.0724
1227     , p4_a4  VARCHAR2 := fnd_api.g_miss_char
1228     , p4_a5  VARCHAR2 := fnd_api.g_miss_char
1229     , p4_a6  VARCHAR2 := fnd_api.g_miss_char
1230     , p4_a7  NUMBER := 0-1962.0724
1231     , p4_a8  NUMBER := 0-1962.0724
1232     , p4_a9  NUMBER := 0-1962.0724
1233     , p4_a10  VARCHAR2 := fnd_api.g_miss_char
1234     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
1235     , p4_a12  NUMBER := 0-1962.0724
1236     , p4_a13  NUMBER := 0-1962.0724
1237     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
1238     , p4_a15  NUMBER := 0-1962.0724
1239     , p4_a16  NUMBER := 0-1962.0724
1240     , p4_a17  NUMBER := 0-1962.0724
1241     , p4_a18  NUMBER := 0-1962.0724
1242     , p4_a19  NUMBER := 0-1962.0724
1243     , p4_a20  NUMBER := 0-1962.0724
1244     , p4_a21  NUMBER := 0-1962.0724
1245     , p4_a22  NUMBER := 0-1962.0724
1246     , p4_a23  NUMBER := 0-1962.0724
1247     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
1248     , p4_a25  NUMBER := 0-1962.0724
1249     , p4_a26  NUMBER := 0-1962.0724
1250     , p4_a27  NUMBER := 0-1962.0724
1251     , p4_a28  NUMBER := 0-1962.0724
1252     , p4_a29  DATE := fnd_api.g_miss_date
1253     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
1254     , p4_a31  DATE := fnd_api.g_miss_date
1255     , p4_a32  DATE := fnd_api.g_miss_date
1256     , p4_a33  VARCHAR2 := fnd_api.g_miss_char
1257     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
1258     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
1259     , p4_a36  NUMBER := 0-1962.0724
1260     , p4_a37  NUMBER := 0-1962.0724
1261     , p4_a38  NUMBER := 0-1962.0724
1262     , p4_a39  VARCHAR2 := fnd_api.g_miss_char
1263     , p4_a40  VARCHAR2 := fnd_api.g_miss_char
1264     , p5_a0  NUMBER := 0-1962.0724
1265     , p5_a1  NUMBER := 0-1962.0724
1266     , p5_a2  NUMBER := 0-1962.0724
1267     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
1268     , p6_a0  NUMBER := 0-1962.0724
1269     , p6_a1  NUMBER := 0-1962.0724
1270     , p6_a2  NUMBER := 0-1962.0724
1271     , p6_a3  VARCHAR2 := fnd_api.g_miss_char
1272   );
1273   procedure get_item_instance_details(p_api_version  NUMBER
1274     , p_commit  VARCHAR2
1275     , p_init_msg_list  VARCHAR2
1276     , p_validation_level  NUMBER
1277     , p4_a0 in out nocopy  NUMBER
1278     , p4_a1 in out nocopy  VARCHAR2
1279     , p4_a2 in out nocopy  VARCHAR2
1280     , p4_a3 in out nocopy  NUMBER
1281     , p4_a4 in out nocopy  VARCHAR2
1282     , p4_a5 in out nocopy  NUMBER
1283     , p4_a6 in out nocopy  VARCHAR2
1284     , p4_a7 in out nocopy  VARCHAR2
1285     , p4_a8 in out nocopy  VARCHAR2
1286     , p4_a9 in out nocopy  NUMBER
1287     , p4_a10 in out nocopy  VARCHAR2
1288     , p4_a11 in out nocopy  VARCHAR2
1289     , p4_a12 in out nocopy  VARCHAR2
1290     , p4_a13 in out nocopy  VARCHAR2
1291     , p4_a14 in out nocopy  VARCHAR2
1292     , p4_a15 in out nocopy  NUMBER
1293     , p4_a16 in out nocopy  VARCHAR2
1294     , p4_a17 in out nocopy  NUMBER
1295     , p4_a18 in out nocopy  VARCHAR2
1296     , p4_a19 in out nocopy  VARCHAR2
1297     , p4_a20 in out nocopy  VARCHAR2
1298     , p4_a21 in out nocopy  NUMBER
1299     , p4_a22 in out nocopy  VARCHAR2
1300     , p4_a23 in out nocopy  VARCHAR2
1301     , p4_a24 in out nocopy  VARCHAR2
1302     , p4_a25 in out nocopy  DATE
1303     , p4_a26 in out nocopy  DATE
1304     , p4_a27 in out nocopy  VARCHAR2
1305     , p4_a28 in out nocopy  NUMBER
1306     , p4_a29 in out nocopy  NUMBER
1307     , p4_a30 in out nocopy  VARCHAR2
1308     , p4_a31 in out nocopy  VARCHAR2
1309     , p4_a32 in out nocopy  NUMBER
1310     , p4_a33 in out nocopy  NUMBER
1311     , p4_a34 in out nocopy  NUMBER
1312     , p4_a35 in out nocopy  VARCHAR2
1313     , p4_a36 in out nocopy  VARCHAR2
1314     , p4_a37 in out nocopy  VARCHAR2
1315     , p4_a38 in out nocopy  VARCHAR2
1316     , p4_a39 in out nocopy  NUMBER
1317     , p4_a40 in out nocopy  NUMBER
1318     , p4_a41 in out nocopy  NUMBER
1319     , p4_a42 in out nocopy  NUMBER
1320     , p4_a43 in out nocopy  VARCHAR2
1321     , p4_a44 in out nocopy  NUMBER
1322     , p4_a45 in out nocopy  NUMBER
1323     , p4_a46 in out nocopy  NUMBER
1324     , p4_a47 in out nocopy  NUMBER
1325     , p4_a48 in out nocopy  VARCHAR2
1326     , p4_a49 in out nocopy  NUMBER
1327     , p4_a50 in out nocopy  NUMBER
1328     , p4_a51 in out nocopy  NUMBER
1329     , p4_a52 in out nocopy  NUMBER
1330     , p4_a53 in out nocopy  DATE
1331     , p4_a54 in out nocopy  VARCHAR2
1332     , p4_a55 in out nocopy  DATE
1333     , p4_a56 in out nocopy  DATE
1334     , p4_a57 in out nocopy  VARCHAR2
1335     , p4_a58 in out nocopy  VARCHAR2
1336     , p4_a59 in out nocopy  VARCHAR2
1337     , p4_a60 in out nocopy  VARCHAR2
1338     , p4_a61 in out nocopy  VARCHAR2
1339     , p4_a62 in out nocopy  VARCHAR2
1340     , p4_a63 in out nocopy  VARCHAR2
1341     , p4_a64 in out nocopy  VARCHAR2
1342     , p4_a65 in out nocopy  VARCHAR2
1343     , p4_a66 in out nocopy  VARCHAR2
1344     , p4_a67 in out nocopy  VARCHAR2
1345     , p4_a68 in out nocopy  VARCHAR2
1346     , p4_a69 in out nocopy  VARCHAR2
1347     , p4_a70 in out nocopy  VARCHAR2
1348     , p4_a71 in out nocopy  VARCHAR2
1349     , p4_a72 in out nocopy  VARCHAR2
1350     , p4_a73 in out nocopy  VARCHAR2
1351     , p4_a74 in out nocopy  VARCHAR2
1352     , p4_a75 in out nocopy  NUMBER
1353     , p4_a76 in out nocopy  NUMBER
1354     , p4_a77 in out nocopy  VARCHAR2
1355     , p4_a78 in out nocopy  NUMBER
1356     , p4_a79 in out nocopy  VARCHAR2
1357     , p4_a80 in out nocopy  VARCHAR2
1358     , p4_a81 in out nocopy  VARCHAR2
1359     , p4_a82 in out nocopy  VARCHAR2
1360     , p4_a83 in out nocopy  VARCHAR2
1361     , p4_a84 in out nocopy  VARCHAR2
1362     , p4_a85 in out nocopy  VARCHAR2
1363     , p4_a86 in out nocopy  VARCHAR2
1364     , p4_a87 in out nocopy  VARCHAR2
1365     , p4_a88 in out nocopy  NUMBER
1366     , p4_a89 in out nocopy  NUMBER
1367     , p4_a90 in out nocopy  DATE
1368     , p4_a91 in out nocopy  VARCHAR2
1369     , p4_a92 in out nocopy  VARCHAR2
1370     , p4_a93 in out nocopy  VARCHAR2
1371     , p4_a94 in out nocopy  VARCHAR2
1372     , p4_a95 in out nocopy  VARCHAR2
1373     , p4_a96 in out nocopy  VARCHAR2
1374     , p4_a97 in out nocopy  VARCHAR2
1375     , p4_a98 in out nocopy  VARCHAR2
1376     , p4_a99 in out nocopy  VARCHAR2
1377     , p4_a100 in out nocopy  VARCHAR2
1378     , p4_a101 in out nocopy  NUMBER
1379     , p4_a102 in out nocopy  VARCHAR2
1380     , p4_a103 in out nocopy  VARCHAR2
1381     , p4_a104 in out nocopy  VARCHAR2
1382     , p4_a105 in out nocopy  VARCHAR2
1383     , p4_a106 in out nocopy  VARCHAR2
1384     , p4_a107 in out nocopy  VARCHAR2
1385     , p4_a108 in out nocopy  NUMBER
1386     , p4_a109 in out nocopy  NUMBER
1387     , p4_a110 in out nocopy  NUMBER
1388     , p4_a111 in out nocopy  VARCHAR2
1389     , p4_a112 in out nocopy  VARCHAR2
1390     , p4_a113 in out nocopy  VARCHAR2
1391     , p4_a114 in out nocopy  VARCHAR2
1392     , p4_a115 in out nocopy  VARCHAR2
1393     , p4_a116 in out nocopy  VARCHAR2
1394     , p4_a117 in out nocopy  VARCHAR2
1395     , p4_a118 in out nocopy  VARCHAR2
1396     , p4_a119 in out nocopy  VARCHAR2
1397     , p4_a120 in out nocopy  VARCHAR2
1398     , p4_a121 in out nocopy  VARCHAR2
1399     , p4_a122 in out nocopy  VARCHAR2
1400     , p4_a123 in out nocopy  VARCHAR2
1401     , p4_a124 in out nocopy  VARCHAR2
1402     , p4_a125 in out nocopy  VARCHAR2
1403     , p4_a126 in out nocopy  VARCHAR2
1404     , p4_a127 in out nocopy  VARCHAR2
1405     , p4_a128 in out nocopy  VARCHAR2
1406     , p4_a129 in out nocopy  VARCHAR2
1407     , p4_a130 in out nocopy  VARCHAR2
1408     , p4_a131 in out nocopy  VARCHAR2
1409     , p4_a132 in out nocopy  VARCHAR2
1410     , p4_a133 in out nocopy  VARCHAR2
1411     , p4_a134 in out nocopy  NUMBER
1412     , p4_a135 in out nocopy  VARCHAR2
1413     , p4_a136 in out nocopy  NUMBER
1414     , p4_a137 in out nocopy  NUMBER
1415     , p4_a138 in out nocopy  VARCHAR2
1416     , p4_a139 in out nocopy  NUMBER
1417     , p4_a140 in out nocopy  VARCHAR2
1418     , p4_a141 in out nocopy  NUMBER
1419     , p4_a142 in out nocopy  DATE
1420     , p4_a143 in out nocopy  VARCHAR2
1421     , p4_a144 in out nocopy  VARCHAR2
1422     , p4_a145 in out nocopy  VARCHAR2
1423     , p4_a146 in out nocopy  VARCHAR2
1424     , p4_a147 in out nocopy  VARCHAR2
1425     , p4_a148 in out nocopy  VARCHAR2
1426     , p4_a149 in out nocopy  VARCHAR2
1427     , p4_a150 in out nocopy  VARCHAR2
1428     , p4_a151 in out nocopy  VARCHAR2
1429     , p4_a152 in out nocopy  VARCHAR2
1430     , p4_a153 in out nocopy  VARCHAR2
1431     , p4_a154 in out nocopy  VARCHAR2
1432     , p4_a155 in out nocopy  VARCHAR2
1433     , p4_a156 in out nocopy  VARCHAR2
1434     , p4_a157 in out nocopy  VARCHAR2
1435     , p4_a158 in out nocopy  NUMBER
1436     , p4_a159 in out nocopy  VARCHAR2
1437     , p4_a160 in out nocopy  NUMBER
1438     , p4_a161 in out nocopy  VARCHAR2
1439     , p4_a162 in out nocopy  NUMBER
1440     , p4_a163 in out nocopy  VARCHAR2
1441     , p4_a164 in out nocopy  VARCHAR2
1442     , p4_a165 in out nocopy  VARCHAR2
1443     , p4_a166 in out nocopy  VARCHAR2
1444     , p4_a167 in out nocopy  VARCHAR2
1445     , p4_a168 in out nocopy  VARCHAR2
1446     , p4_a169 in out nocopy  VARCHAR2
1447     , p4_a170 in out nocopy  VARCHAR2
1448     , p4_a171 in out nocopy  VARCHAR2
1449     , p4_a172 in out nocopy  VARCHAR2
1450     , p4_a173 in out nocopy  VARCHAR2
1451     , p4_a174 in out nocopy  VARCHAR2
1452     , p4_a175 in out nocopy  VARCHAR2
1453     , p4_a176 in out nocopy  VARCHAR2
1454     , p_get_parties  VARCHAR2
1455     , p6_a0 out nocopy JTF_NUMBER_TABLE
1456     , p6_a1 out nocopy JTF_NUMBER_TABLE
1457     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1458     , p6_a3 out nocopy JTF_NUMBER_TABLE
1459     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1460     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1461     , p6_a6 out nocopy JTF_NUMBER_TABLE
1462     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1463     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_400
1464     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1465     , p6_a10 out nocopy JTF_DATE_TABLE
1466     , p6_a11 out nocopy JTF_DATE_TABLE
1467     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1468     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1469     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
1470     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
1471     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
1472     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1473     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
1474     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
1475     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
1476     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1477     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1478     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_200
1479     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
1480     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_200
1481     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_200
1482     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_200
1483     , p6_a28 out nocopy JTF_NUMBER_TABLE
1484     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
1485     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
1486     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
1487     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1488     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
1489     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
1490     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1491     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1492     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1493     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_2000
1494     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1495     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1496     , p_get_accounts  VARCHAR2
1497     , p8_a0 out nocopy JTF_NUMBER_TABLE
1498     , p8_a1 out nocopy JTF_NUMBER_TABLE
1499     , p8_a2 out nocopy JTF_NUMBER_TABLE
1500     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1501     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_300
1502     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1503     , p8_a6 out nocopy JTF_NUMBER_TABLE
1504     , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
1505     , p8_a8 out nocopy JTF_NUMBER_TABLE
1506     , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
1507     , p8_a10 out nocopy JTF_DATE_TABLE
1508     , p8_a11 out nocopy JTF_DATE_TABLE
1509     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1510     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_200
1511     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_200
1512     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_200
1513     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_200
1514     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_200
1515     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_200
1516     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_200
1517     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_200
1518     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
1519     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
1520     , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
1521     , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
1522     , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
1523     , p8_a26 out nocopy JTF_VARCHAR2_TABLE_200
1524     , p8_a27 out nocopy JTF_VARCHAR2_TABLE_200
1525     , p8_a28 out nocopy JTF_NUMBER_TABLE
1526     , p8_a29 out nocopy JTF_VARCHAR2_TABLE_300
1527     , p8_a30 out nocopy JTF_VARCHAR2_TABLE_300
1528     , p8_a31 out nocopy JTF_VARCHAR2_TABLE_300
1529     , p8_a32 out nocopy JTF_VARCHAR2_TABLE_300
1530     , p8_a33 out nocopy JTF_VARCHAR2_TABLE_100
1531     , p8_a34 out nocopy JTF_VARCHAR2_TABLE_100
1532     , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
1533     , p8_a36 out nocopy JTF_VARCHAR2_TABLE_100
1534     , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
1535     , p8_a38 out nocopy JTF_VARCHAR2_TABLE_300
1536     , p8_a39 out nocopy JTF_VARCHAR2_TABLE_300
1537     , p8_a40 out nocopy JTF_VARCHAR2_TABLE_300
1538     , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100
1539     , p8_a42 out nocopy JTF_VARCHAR2_TABLE_100
1540     , p8_a43 out nocopy JTF_VARCHAR2_TABLE_100
1541     , p8_a44 out nocopy JTF_VARCHAR2_TABLE_100
1542     , p_get_org_assignments  VARCHAR2
1543     , p10_a0 out nocopy JTF_NUMBER_TABLE
1544     , p10_a1 out nocopy JTF_NUMBER_TABLE
1545     , p10_a2 out nocopy JTF_NUMBER_TABLE
1546     , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
1547     , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
1548     , p10_a5 out nocopy JTF_DATE_TABLE
1549     , p10_a6 out nocopy JTF_DATE_TABLE
1550     , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
1551     , p10_a8 out nocopy JTF_VARCHAR2_TABLE_200
1552     , p10_a9 out nocopy JTF_VARCHAR2_TABLE_200
1553     , p10_a10 out nocopy JTF_VARCHAR2_TABLE_200
1554     , p10_a11 out nocopy JTF_VARCHAR2_TABLE_200
1555     , p10_a12 out nocopy JTF_VARCHAR2_TABLE_200
1556     , p10_a13 out nocopy JTF_VARCHAR2_TABLE_200
1557     , p10_a14 out nocopy JTF_VARCHAR2_TABLE_200
1558     , p10_a15 out nocopy JTF_VARCHAR2_TABLE_200
1559     , p10_a16 out nocopy JTF_VARCHAR2_TABLE_200
1560     , p10_a17 out nocopy JTF_VARCHAR2_TABLE_200
1561     , p10_a18 out nocopy JTF_VARCHAR2_TABLE_200
1562     , p10_a19 out nocopy JTF_VARCHAR2_TABLE_200
1563     , p10_a20 out nocopy JTF_VARCHAR2_TABLE_200
1564     , p10_a21 out nocopy JTF_VARCHAR2_TABLE_200
1565     , p10_a22 out nocopy JTF_VARCHAR2_TABLE_200
1566     , p10_a23 out nocopy JTF_NUMBER_TABLE
1567     , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100
1568     , p_get_pricing_attribs  VARCHAR2
1569     , p12_a0 out nocopy JTF_NUMBER_TABLE
1570     , p12_a1 out nocopy JTF_NUMBER_TABLE
1571     , p12_a2 out nocopy JTF_DATE_TABLE
1572     , p12_a3 out nocopy JTF_DATE_TABLE
1573     , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
1574     , p12_a5 out nocopy JTF_VARCHAR2_TABLE_200
1575     , p12_a6 out nocopy JTF_VARCHAR2_TABLE_200
1576     , p12_a7 out nocopy JTF_VARCHAR2_TABLE_200
1577     , p12_a8 out nocopy JTF_VARCHAR2_TABLE_200
1578     , p12_a9 out nocopy JTF_VARCHAR2_TABLE_200
1579     , p12_a10 out nocopy JTF_VARCHAR2_TABLE_200
1580     , p12_a11 out nocopy JTF_VARCHAR2_TABLE_200
1581     , p12_a12 out nocopy JTF_VARCHAR2_TABLE_200
1582     , p12_a13 out nocopy JTF_VARCHAR2_TABLE_200
1583     , p12_a14 out nocopy JTF_VARCHAR2_TABLE_200
1584     , p12_a15 out nocopy JTF_VARCHAR2_TABLE_200
1585     , p12_a16 out nocopy JTF_VARCHAR2_TABLE_200
1586     , p12_a17 out nocopy JTF_VARCHAR2_TABLE_200
1587     , p12_a18 out nocopy JTF_VARCHAR2_TABLE_200
1588     , p12_a19 out nocopy JTF_VARCHAR2_TABLE_200
1589     , p12_a20 out nocopy JTF_VARCHAR2_TABLE_200
1590     , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
1591     , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
1592     , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
1593     , p12_a24 out nocopy JTF_VARCHAR2_TABLE_300
1594     , p12_a25 out nocopy JTF_VARCHAR2_TABLE_200
1595     , p12_a26 out nocopy JTF_VARCHAR2_TABLE_200
1596     , p12_a27 out nocopy JTF_VARCHAR2_TABLE_200
1597     , p12_a28 out nocopy JTF_VARCHAR2_TABLE_200
1598     , p12_a29 out nocopy JTF_VARCHAR2_TABLE_200
1599     , p12_a30 out nocopy JTF_VARCHAR2_TABLE_200
1600     , p12_a31 out nocopy JTF_VARCHAR2_TABLE_200
1601     , p12_a32 out nocopy JTF_VARCHAR2_TABLE_200
1602     , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
1603     , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
1604     , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
1605     , p12_a36 out nocopy JTF_VARCHAR2_TABLE_200
1606     , p12_a37 out nocopy JTF_VARCHAR2_TABLE_200
1607     , p12_a38 out nocopy JTF_VARCHAR2_TABLE_200
1608     , p12_a39 out nocopy JTF_VARCHAR2_TABLE_200
1609     , p12_a40 out nocopy JTF_VARCHAR2_TABLE_200
1610     , p12_a41 out nocopy JTF_VARCHAR2_TABLE_200
1611     , p12_a42 out nocopy JTF_VARCHAR2_TABLE_200
1612     , p12_a43 out nocopy JTF_VARCHAR2_TABLE_200
1613     , p12_a44 out nocopy JTF_VARCHAR2_TABLE_200
1614     , p12_a45 out nocopy JTF_VARCHAR2_TABLE_200
1615     , p12_a46 out nocopy JTF_VARCHAR2_TABLE_200
1616     , p12_a47 out nocopy JTF_VARCHAR2_TABLE_200
1617     , p12_a48 out nocopy JTF_VARCHAR2_TABLE_200
1618     , p12_a49 out nocopy JTF_VARCHAR2_TABLE_200
1619     , p12_a50 out nocopy JTF_VARCHAR2_TABLE_200
1620     , p12_a51 out nocopy JTF_VARCHAR2_TABLE_200
1621     , p12_a52 out nocopy JTF_VARCHAR2_TABLE_200
1622     , p12_a53 out nocopy JTF_VARCHAR2_TABLE_200
1623     , p12_a54 out nocopy JTF_VARCHAR2_TABLE_200
1624     , p12_a55 out nocopy JTF_VARCHAR2_TABLE_200
1625     , p12_a56 out nocopy JTF_VARCHAR2_TABLE_200
1626     , p12_a57 out nocopy JTF_VARCHAR2_TABLE_200
1627     , p12_a58 out nocopy JTF_VARCHAR2_TABLE_200
1628     , p12_a59 out nocopy JTF_VARCHAR2_TABLE_200
1629     , p12_a60 out nocopy JTF_VARCHAR2_TABLE_200
1630     , p12_a61 out nocopy JTF_VARCHAR2_TABLE_200
1631     , p12_a62 out nocopy JTF_VARCHAR2_TABLE_200
1632     , p12_a63 out nocopy JTF_VARCHAR2_TABLE_200
1633     , p12_a64 out nocopy JTF_VARCHAR2_TABLE_200
1634     , p12_a65 out nocopy JTF_VARCHAR2_TABLE_200
1635     , p12_a66 out nocopy JTF_VARCHAR2_TABLE_200
1636     , p12_a67 out nocopy JTF_VARCHAR2_TABLE_200
1637     , p12_a68 out nocopy JTF_VARCHAR2_TABLE_200
1638     , p12_a69 out nocopy JTF_VARCHAR2_TABLE_200
1639     , p12_a70 out nocopy JTF_VARCHAR2_TABLE_200
1640     , p12_a71 out nocopy JTF_VARCHAR2_TABLE_200
1641     , p12_a72 out nocopy JTF_VARCHAR2_TABLE_200
1642     , p12_a73 out nocopy JTF_VARCHAR2_TABLE_200
1643     , p12_a74 out nocopy JTF_VARCHAR2_TABLE_200
1644     , p12_a75 out nocopy JTF_VARCHAR2_TABLE_200
1645     , p12_a76 out nocopy JTF_VARCHAR2_TABLE_200
1646     , p12_a77 out nocopy JTF_VARCHAR2_TABLE_200
1647     , p12_a78 out nocopy JTF_VARCHAR2_TABLE_200
1648     , p12_a79 out nocopy JTF_VARCHAR2_TABLE_200
1649     , p12_a80 out nocopy JTF_VARCHAR2_TABLE_200
1650     , p12_a81 out nocopy JTF_VARCHAR2_TABLE_200
1651     , p12_a82 out nocopy JTF_VARCHAR2_TABLE_200
1652     , p12_a83 out nocopy JTF_VARCHAR2_TABLE_200
1653     , p12_a84 out nocopy JTF_VARCHAR2_TABLE_200
1654     , p12_a85 out nocopy JTF_VARCHAR2_TABLE_200
1655     , p12_a86 out nocopy JTF_VARCHAR2_TABLE_200
1656     , p12_a87 out nocopy JTF_VARCHAR2_TABLE_200
1657     , p12_a88 out nocopy JTF_VARCHAR2_TABLE_200
1658     , p12_a89 out nocopy JTF_VARCHAR2_TABLE_200
1659     , p12_a90 out nocopy JTF_VARCHAR2_TABLE_200
1660     , p12_a91 out nocopy JTF_VARCHAR2_TABLE_200
1661     , p12_a92 out nocopy JTF_VARCHAR2_TABLE_200
1662     , p12_a93 out nocopy JTF_VARCHAR2_TABLE_200
1663     , p12_a94 out nocopy JTF_VARCHAR2_TABLE_200
1664     , p12_a95 out nocopy JTF_VARCHAR2_TABLE_200
1665     , p12_a96 out nocopy JTF_VARCHAR2_TABLE_200
1666     , p12_a97 out nocopy JTF_VARCHAR2_TABLE_200
1667     , p12_a98 out nocopy JTF_VARCHAR2_TABLE_200
1668     , p12_a99 out nocopy JTF_VARCHAR2_TABLE_200
1669     , p12_a100 out nocopy JTF_VARCHAR2_TABLE_200
1670     , p12_a101 out nocopy JTF_VARCHAR2_TABLE_200
1671     , p12_a102 out nocopy JTF_VARCHAR2_TABLE_200
1672     , p12_a103 out nocopy JTF_VARCHAR2_TABLE_200
1673     , p12_a104 out nocopy JTF_VARCHAR2_TABLE_200
1674     , p12_a105 out nocopy JTF_VARCHAR2_TABLE_100
1675     , p12_a106 out nocopy JTF_VARCHAR2_TABLE_200
1676     , p12_a107 out nocopy JTF_VARCHAR2_TABLE_200
1677     , p12_a108 out nocopy JTF_VARCHAR2_TABLE_200
1678     , p12_a109 out nocopy JTF_VARCHAR2_TABLE_200
1679     , p12_a110 out nocopy JTF_VARCHAR2_TABLE_200
1680     , p12_a111 out nocopy JTF_VARCHAR2_TABLE_200
1681     , p12_a112 out nocopy JTF_VARCHAR2_TABLE_200
1682     , p12_a113 out nocopy JTF_VARCHAR2_TABLE_200
1683     , p12_a114 out nocopy JTF_VARCHAR2_TABLE_200
1684     , p12_a115 out nocopy JTF_VARCHAR2_TABLE_200
1685     , p12_a116 out nocopy JTF_VARCHAR2_TABLE_200
1686     , p12_a117 out nocopy JTF_VARCHAR2_TABLE_200
1687     , p12_a118 out nocopy JTF_VARCHAR2_TABLE_200
1688     , p12_a119 out nocopy JTF_VARCHAR2_TABLE_200
1689     , p12_a120 out nocopy JTF_VARCHAR2_TABLE_200
1690     , p12_a121 out nocopy JTF_NUMBER_TABLE
1691     , p12_a122 out nocopy JTF_NUMBER_TABLE
1692     , p_get_ext_attribs  VARCHAR2
1693     , p14_a0 out nocopy JTF_NUMBER_TABLE
1694     , p14_a1 out nocopy JTF_NUMBER_TABLE
1695     , p14_a2 out nocopy JTF_NUMBER_TABLE
1696     , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
1697     , p14_a4 out nocopy JTF_VARCHAR2_TABLE_300
1698     , p14_a5 out nocopy JTF_DATE_TABLE
1699     , p14_a6 out nocopy JTF_DATE_TABLE
1700     , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
1701     , p14_a8 out nocopy JTF_VARCHAR2_TABLE_200
1702     , p14_a9 out nocopy JTF_VARCHAR2_TABLE_200
1703     , p14_a10 out nocopy JTF_VARCHAR2_TABLE_200
1704     , p14_a11 out nocopy JTF_VARCHAR2_TABLE_200
1705     , p14_a12 out nocopy JTF_VARCHAR2_TABLE_200
1706     , p14_a13 out nocopy JTF_VARCHAR2_TABLE_200
1707     , p14_a14 out nocopy JTF_VARCHAR2_TABLE_200
1708     , p14_a15 out nocopy JTF_VARCHAR2_TABLE_200
1709     , p14_a16 out nocopy JTF_VARCHAR2_TABLE_200
1710     , p14_a17 out nocopy JTF_VARCHAR2_TABLE_200
1711     , p14_a18 out nocopy JTF_VARCHAR2_TABLE_200
1712     , p14_a19 out nocopy JTF_VARCHAR2_TABLE_200
1713     , p14_a20 out nocopy JTF_VARCHAR2_TABLE_200
1714     , p14_a21 out nocopy JTF_VARCHAR2_TABLE_200
1715     , p14_a22 out nocopy JTF_VARCHAR2_TABLE_200
1716     , p14_a23 out nocopy JTF_NUMBER_TABLE
1717     , p14_a24 out nocopy JTF_NUMBER_TABLE
1718     , p15_a0 out nocopy JTF_NUMBER_TABLE
1719     , p15_a1 out nocopy JTF_VARCHAR2_TABLE_100
1720     , p15_a2 out nocopy JTF_NUMBER_TABLE
1721     , p15_a3 out nocopy JTF_NUMBER_TABLE
1722     , p15_a4 out nocopy JTF_NUMBER_TABLE
1723     , p15_a5 out nocopy JTF_NUMBER_TABLE
1724     , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
1725     , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
1726     , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100
1727     , p15_a9 out nocopy JTF_VARCHAR2_TABLE_300
1728     , p15_a10 out nocopy JTF_DATE_TABLE
1729     , p15_a11 out nocopy JTF_DATE_TABLE
1730     , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1731     , p15_a13 out nocopy JTF_VARCHAR2_TABLE_200
1732     , p15_a14 out nocopy JTF_VARCHAR2_TABLE_200
1733     , p15_a15 out nocopy JTF_VARCHAR2_TABLE_200
1734     , p15_a16 out nocopy JTF_VARCHAR2_TABLE_200
1735     , p15_a17 out nocopy JTF_VARCHAR2_TABLE_200
1736     , p15_a18 out nocopy JTF_VARCHAR2_TABLE_200
1737     , p15_a19 out nocopy JTF_VARCHAR2_TABLE_200
1738     , p15_a20 out nocopy JTF_VARCHAR2_TABLE_200
1739     , p15_a21 out nocopy JTF_VARCHAR2_TABLE_200
1740     , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1741     , p15_a23 out nocopy JTF_VARCHAR2_TABLE_200
1742     , p15_a24 out nocopy JTF_VARCHAR2_TABLE_200
1743     , p15_a25 out nocopy JTF_VARCHAR2_TABLE_200
1744     , p15_a26 out nocopy JTF_VARCHAR2_TABLE_200
1745     , p15_a27 out nocopy JTF_VARCHAR2_TABLE_200
1746     , p15_a28 out nocopy JTF_NUMBER_TABLE
1747     , p_get_asset_assignments  VARCHAR2
1748     , p17_a0 out nocopy JTF_NUMBER_TABLE
1749     , p17_a1 out nocopy JTF_NUMBER_TABLE
1750     , p17_a2 out nocopy JTF_NUMBER_TABLE
1751     , p17_a3 out nocopy JTF_VARCHAR2_TABLE_100
1752     , p17_a4 out nocopy JTF_NUMBER_TABLE
1753     , p17_a5 out nocopy JTF_NUMBER_TABLE
1754     , p17_a6 out nocopy JTF_VARCHAR2_TABLE_100
1755     , p17_a7 out nocopy JTF_DATE_TABLE
1756     , p17_a8 out nocopy JTF_DATE_TABLE
1757     , p17_a9 out nocopy JTF_NUMBER_TABLE
1758     , p17_a10 out nocopy JTF_VARCHAR2_TABLE_100
1759     , p17_a11 out nocopy JTF_VARCHAR2_TABLE_100
1760     , p17_a12 out nocopy JTF_VARCHAR2_TABLE_100
1761     , p17_a13 out nocopy JTF_VARCHAR2_TABLE_100
1762     , p17_a14 out nocopy JTF_VARCHAR2_TABLE_100
1763     , p17_a15 out nocopy JTF_VARCHAR2_TABLE_100
1764     , p17_a16 out nocopy JTF_VARCHAR2_TABLE_100
1765     , p17_a17 out nocopy JTF_VARCHAR2_TABLE_100
1766     , p17_a18 out nocopy JTF_VARCHAR2_TABLE_100
1767     , p17_a19 out nocopy JTF_VARCHAR2_TABLE_100
1768     , p17_a20 out nocopy JTF_VARCHAR2_TABLE_100
1769     , p17_a21 out nocopy JTF_DATE_TABLE
1770     , p17_a22 out nocopy JTF_VARCHAR2_TABLE_100
1771     , p17_a23 out nocopy JTF_VARCHAR2_TABLE_300
1772     , p17_a24 out nocopy JTF_VARCHAR2_TABLE_100
1773     , p17_a25 out nocopy JTF_NUMBER_TABLE
1774     , p17_a26 out nocopy JTF_VARCHAR2_TABLE_100
1775     , p_resolve_id_columns  VARCHAR2
1776     , p_time_stamp  date
1777     , x_return_status out nocopy  VARCHAR2
1778     , x_msg_count out nocopy  NUMBER
1779     , x_msg_data out nocopy  VARCHAR2
1780   );
1781   procedure get_version_labels(p_api_version  NUMBER
1782     , p_commit  VARCHAR2
1783     , p_init_msg_list  VARCHAR2
1784     , p_validation_level  NUMBER
1785     , p_time_stamp  date
1786     , p6_a0 out nocopy JTF_NUMBER_TABLE
1787     , p6_a1 out nocopy JTF_NUMBER_TABLE
1788     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
1789     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
1790     , p6_a4 out nocopy JTF_DATE_TABLE
1791     , p6_a5 out nocopy JTF_DATE_TABLE
1792     , p6_a6 out nocopy JTF_DATE_TABLE
1793     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1794     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
1795     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
1796     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
1797     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
1798     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
1799     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1800     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
1801     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
1802     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
1803     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
1804     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
1805     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
1806     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
1807     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
1808     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
1809     , p6_a23 out nocopy JTF_NUMBER_TABLE
1810     , x_return_status out nocopy  VARCHAR2
1811     , x_msg_count out nocopy  NUMBER
1812     , x_msg_data out nocopy  VARCHAR2
1813     , p4_a0  NUMBER := 0-1962.0724
1814     , p4_a1  NUMBER := 0-1962.0724
1815     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
1816     , p4_a3  DATE := fnd_api.g_miss_date
1817   );
1818   procedure create_version_label(p_api_version  NUMBER
1819     , p_commit  VARCHAR2
1820     , p_init_msg_list  VARCHAR2
1821     , p_validation_level  NUMBER
1822     , p4_a0 in out nocopy JTF_NUMBER_TABLE
1823     , p4_a1 in out nocopy JTF_NUMBER_TABLE
1824     , p4_a2 in out nocopy JTF_VARCHAR2_TABLE_300
1825     , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_300
1826     , p4_a4 in out nocopy JTF_DATE_TABLE
1827     , p4_a5 in out nocopy JTF_DATE_TABLE
1828     , p4_a6 in out nocopy JTF_DATE_TABLE
1829     , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1830     , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_200
1831     , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_200
1832     , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_200
1833     , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
1834     , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
1835     , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_200
1836     , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1837     , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
1838     , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
1839     , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1840     , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1841     , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1842     , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1843     , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1844     , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1845     , p4_a23 in out nocopy JTF_NUMBER_TABLE
1846     , p5_a0 in out nocopy  NUMBER
1847     , p5_a1 in out nocopy  DATE
1848     , p5_a2 in out nocopy  DATE
1849     , p5_a3 in out nocopy  NUMBER
1850     , p5_a4 in out nocopy  NUMBER
1851     , p5_a5 in out nocopy  NUMBER
1852     , p5_a6 in out nocopy  VARCHAR2
1853     , p5_a7 in out nocopy  NUMBER
1854     , p5_a8 in out nocopy  VARCHAR2
1855     , p5_a9 in out nocopy  NUMBER
1856     , p5_a10 in out nocopy  VARCHAR2
1857     , p5_a11 in out nocopy  NUMBER
1858     , p5_a12 in out nocopy  NUMBER
1859     , p5_a13 in out nocopy  NUMBER
1860     , p5_a14 in out nocopy  NUMBER
1861     , p5_a15 in out nocopy  VARCHAR2
1862     , p5_a16 in out nocopy  NUMBER
1863     , p5_a17 in out nocopy  VARCHAR2
1864     , p5_a18 in out nocopy  VARCHAR2
1865     , p5_a19 in out nocopy  NUMBER
1866     , p5_a20 in out nocopy  VARCHAR2
1867     , p5_a21 in out nocopy  VARCHAR2
1868     , p5_a22 in out nocopy  VARCHAR2
1869     , p5_a23 in out nocopy  VARCHAR2
1870     , p5_a24 in out nocopy  VARCHAR2
1871     , p5_a25 in out nocopy  VARCHAR2
1872     , p5_a26 in out nocopy  VARCHAR2
1873     , p5_a27 in out nocopy  VARCHAR2
1874     , p5_a28 in out nocopy  VARCHAR2
1875     , p5_a29 in out nocopy  VARCHAR2
1876     , p5_a30 in out nocopy  VARCHAR2
1877     , p5_a31 in out nocopy  VARCHAR2
1878     , p5_a32 in out nocopy  VARCHAR2
1879     , p5_a33 in out nocopy  VARCHAR2
1880     , p5_a34 in out nocopy  VARCHAR2
1881     , p5_a35 in out nocopy  VARCHAR2
1882     , p5_a36 in out nocopy  NUMBER
1883     , p5_a37 in out nocopy  VARCHAR2
1884     , p5_a38 in out nocopy  DATE
1885     , p5_a39 in out nocopy  NUMBER
1886     , x_return_status out nocopy  VARCHAR2
1887     , x_msg_count out nocopy  NUMBER
1888     , x_msg_data out nocopy  VARCHAR2
1889   );
1890   procedure update_version_label(p_api_version  NUMBER
1891     , p_commit  VARCHAR2
1892     , p_init_msg_list  VARCHAR2
1893     , p_validation_level  NUMBER
1894     , p4_a0 JTF_NUMBER_TABLE
1895     , p4_a1 JTF_NUMBER_TABLE
1896     , p4_a2 JTF_VARCHAR2_TABLE_300
1897     , p4_a3 JTF_VARCHAR2_TABLE_300
1898     , p4_a4 JTF_DATE_TABLE
1899     , p4_a5 JTF_DATE_TABLE
1900     , p4_a6 JTF_DATE_TABLE
1901     , p4_a7 JTF_VARCHAR2_TABLE_100
1902     , p4_a8 JTF_VARCHAR2_TABLE_200
1903     , p4_a9 JTF_VARCHAR2_TABLE_200
1904     , p4_a10 JTF_VARCHAR2_TABLE_200
1905     , p4_a11 JTF_VARCHAR2_TABLE_200
1906     , p4_a12 JTF_VARCHAR2_TABLE_200
1907     , p4_a13 JTF_VARCHAR2_TABLE_200
1908     , p4_a14 JTF_VARCHAR2_TABLE_200
1909     , p4_a15 JTF_VARCHAR2_TABLE_200
1910     , p4_a16 JTF_VARCHAR2_TABLE_200
1911     , p4_a17 JTF_VARCHAR2_TABLE_200
1912     , p4_a18 JTF_VARCHAR2_TABLE_200
1913     , p4_a19 JTF_VARCHAR2_TABLE_200
1914     , p4_a20 JTF_VARCHAR2_TABLE_200
1915     , p4_a21 JTF_VARCHAR2_TABLE_200
1916     , p4_a22 JTF_VARCHAR2_TABLE_200
1917     , p4_a23 JTF_NUMBER_TABLE
1918     , p5_a0 in out nocopy  NUMBER
1919     , p5_a1 in out nocopy  DATE
1920     , p5_a2 in out nocopy  DATE
1921     , p5_a3 in out nocopy  NUMBER
1922     , p5_a4 in out nocopy  NUMBER
1923     , p5_a5 in out nocopy  NUMBER
1924     , p5_a6 in out nocopy  VARCHAR2
1925     , p5_a7 in out nocopy  NUMBER
1926     , p5_a8 in out nocopy  VARCHAR2
1927     , p5_a9 in out nocopy  NUMBER
1928     , p5_a10 in out nocopy  VARCHAR2
1929     , p5_a11 in out nocopy  NUMBER
1930     , p5_a12 in out nocopy  NUMBER
1931     , p5_a13 in out nocopy  NUMBER
1932     , p5_a14 in out nocopy  NUMBER
1933     , p5_a15 in out nocopy  VARCHAR2
1934     , p5_a16 in out nocopy  NUMBER
1935     , p5_a17 in out nocopy  VARCHAR2
1936     , p5_a18 in out nocopy  VARCHAR2
1937     , p5_a19 in out nocopy  NUMBER
1938     , p5_a20 in out nocopy  VARCHAR2
1939     , p5_a21 in out nocopy  VARCHAR2
1940     , p5_a22 in out nocopy  VARCHAR2
1941     , p5_a23 in out nocopy  VARCHAR2
1942     , p5_a24 in out nocopy  VARCHAR2
1943     , p5_a25 in out nocopy  VARCHAR2
1944     , p5_a26 in out nocopy  VARCHAR2
1945     , p5_a27 in out nocopy  VARCHAR2
1946     , p5_a28 in out nocopy  VARCHAR2
1947     , p5_a29 in out nocopy  VARCHAR2
1948     , p5_a30 in out nocopy  VARCHAR2
1949     , p5_a31 in out nocopy  VARCHAR2
1950     , p5_a32 in out nocopy  VARCHAR2
1951     , p5_a33 in out nocopy  VARCHAR2
1952     , p5_a34 in out nocopy  VARCHAR2
1953     , p5_a35 in out nocopy  VARCHAR2
1954     , p5_a36 in out nocopy  NUMBER
1955     , p5_a37 in out nocopy  VARCHAR2
1956     , p5_a38 in out nocopy  DATE
1957     , p5_a39 in out nocopy  NUMBER
1958     , x_return_status out nocopy  VARCHAR2
1959     , x_msg_count out nocopy  NUMBER
1960     , x_msg_data out nocopy  VARCHAR2
1961   );
1962   procedure expire_version_label(p_api_version  NUMBER
1963     , p_commit  VARCHAR2
1964     , p_init_msg_list  VARCHAR2
1965     , p_validation_level  NUMBER
1966     , p4_a0 JTF_NUMBER_TABLE
1967     , p4_a1 JTF_NUMBER_TABLE
1968     , p4_a2 JTF_VARCHAR2_TABLE_300
1969     , p4_a3 JTF_VARCHAR2_TABLE_300
1970     , p4_a4 JTF_DATE_TABLE
1971     , p4_a5 JTF_DATE_TABLE
1972     , p4_a6 JTF_DATE_TABLE
1973     , p4_a7 JTF_VARCHAR2_TABLE_100
1974     , p4_a8 JTF_VARCHAR2_TABLE_200
1975     , p4_a9 JTF_VARCHAR2_TABLE_200
1976     , p4_a10 JTF_VARCHAR2_TABLE_200
1977     , p4_a11 JTF_VARCHAR2_TABLE_200
1978     , p4_a12 JTF_VARCHAR2_TABLE_200
1979     , p4_a13 JTF_VARCHAR2_TABLE_200
1980     , p4_a14 JTF_VARCHAR2_TABLE_200
1981     , p4_a15 JTF_VARCHAR2_TABLE_200
1982     , p4_a16 JTF_VARCHAR2_TABLE_200
1983     , p4_a17 JTF_VARCHAR2_TABLE_200
1984     , p4_a18 JTF_VARCHAR2_TABLE_200
1985     , p4_a19 JTF_VARCHAR2_TABLE_200
1986     , p4_a20 JTF_VARCHAR2_TABLE_200
1987     , p4_a21 JTF_VARCHAR2_TABLE_200
1988     , p4_a22 JTF_VARCHAR2_TABLE_200
1989     , p4_a23 JTF_NUMBER_TABLE
1990     , p5_a0 in out nocopy  NUMBER
1991     , p5_a1 in out nocopy  DATE
1992     , p5_a2 in out nocopy  DATE
1993     , p5_a3 in out nocopy  NUMBER
1994     , p5_a4 in out nocopy  NUMBER
1995     , p5_a5 in out nocopy  NUMBER
1996     , p5_a6 in out nocopy  VARCHAR2
1997     , p5_a7 in out nocopy  NUMBER
1998     , p5_a8 in out nocopy  VARCHAR2
1999     , p5_a9 in out nocopy  NUMBER
2000     , p5_a10 in out nocopy  VARCHAR2
2001     , p5_a11 in out nocopy  NUMBER
2002     , p5_a12 in out nocopy  NUMBER
2003     , p5_a13 in out nocopy  NUMBER
2004     , p5_a14 in out nocopy  NUMBER
2005     , p5_a15 in out nocopy  VARCHAR2
2006     , p5_a16 in out nocopy  NUMBER
2007     , p5_a17 in out nocopy  VARCHAR2
2008     , p5_a18 in out nocopy  VARCHAR2
2009     , p5_a19 in out nocopy  NUMBER
2010     , p5_a20 in out nocopy  VARCHAR2
2011     , p5_a21 in out nocopy  VARCHAR2
2012     , p5_a22 in out nocopy  VARCHAR2
2013     , p5_a23 in out nocopy  VARCHAR2
2014     , p5_a24 in out nocopy  VARCHAR2
2015     , p5_a25 in out nocopy  VARCHAR2
2016     , p5_a26 in out nocopy  VARCHAR2
2017     , p5_a27 in out nocopy  VARCHAR2
2018     , p5_a28 in out nocopy  VARCHAR2
2019     , p5_a29 in out nocopy  VARCHAR2
2020     , p5_a30 in out nocopy  VARCHAR2
2021     , p5_a31 in out nocopy  VARCHAR2
2022     , p5_a32 in out nocopy  VARCHAR2
2023     , p5_a33 in out nocopy  VARCHAR2
2024     , p5_a34 in out nocopy  VARCHAR2
2025     , p5_a35 in out nocopy  VARCHAR2
2026     , p5_a36 in out nocopy  NUMBER
2027     , p5_a37 in out nocopy  VARCHAR2
2028     , p5_a38 in out nocopy  DATE
2029     , p5_a39 in out nocopy  NUMBER
2030     , x_return_status out nocopy  VARCHAR2
2031     , x_msg_count out nocopy  NUMBER
2032     , x_msg_data out nocopy  VARCHAR2
2033   );
2034   procedure get_extended_attrib_values(p_api_version  NUMBER
2035     , p_commit  VARCHAR2
2036     , p_init_msg_list  VARCHAR2
2037     , p_validation_level  NUMBER
2038     , p_time_stamp  date
2039     , p6_a0 out nocopy JTF_NUMBER_TABLE
2040     , p6_a1 out nocopy JTF_NUMBER_TABLE
2041     , p6_a2 out nocopy JTF_NUMBER_TABLE
2042     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2043     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
2044     , p6_a5 out nocopy JTF_DATE_TABLE
2045     , p6_a6 out nocopy JTF_DATE_TABLE
2046     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2047     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
2048     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
2049     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
2050     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
2051     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
2052     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
2053     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
2054     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2055     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
2056     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
2057     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
2058     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
2059     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
2060     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
2061     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
2062     , p6_a23 out nocopy JTF_NUMBER_TABLE
2063     , p6_a24 out nocopy JTF_NUMBER_TABLE
2064     , p7_a0 out nocopy JTF_NUMBER_TABLE
2065     , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
2066     , p7_a2 out nocopy JTF_NUMBER_TABLE
2067     , p7_a3 out nocopy JTF_NUMBER_TABLE
2068     , p7_a4 out nocopy JTF_NUMBER_TABLE
2069     , p7_a5 out nocopy JTF_NUMBER_TABLE
2070     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
2071     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
2072     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
2073     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_300
2074     , p7_a10 out nocopy JTF_DATE_TABLE
2075     , p7_a11 out nocopy JTF_DATE_TABLE
2076     , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
2077     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_200
2078     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_200
2079     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_200
2080     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_200
2081     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
2082     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_200
2083     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_200
2084     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_200
2085     , p7_a21 out nocopy JTF_VARCHAR2_TABLE_200
2086     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
2087     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_200
2088     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
2089     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
2090     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_200
2091     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
2092     , p7_a28 out nocopy JTF_NUMBER_TABLE
2093     , x_return_status out nocopy  VARCHAR2
2094     , x_msg_count out nocopy  NUMBER
2095     , x_msg_data out nocopy  VARCHAR2
2096     , p4_a0  NUMBER := 0-1962.0724
2097     , p4_a1  NUMBER := 0-1962.0724
2098     , p4_a2  NUMBER := 0-1962.0724
2099   );
2100   procedure create_extended_attrib_values(p_api_version  NUMBER
2101     , p_commit  VARCHAR2
2102     , p_init_msg_list  VARCHAR2
2103     , p_validation_level  NUMBER
2104     , p4_a0 in out nocopy JTF_NUMBER_TABLE
2105     , p4_a1 in out nocopy JTF_NUMBER_TABLE
2106     , p4_a2 in out nocopy JTF_NUMBER_TABLE
2107     , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2108     , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_300
2109     , p4_a5 in out nocopy JTF_DATE_TABLE
2110     , p4_a6 in out nocopy JTF_DATE_TABLE
2111     , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
2112     , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_200
2113     , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_200
2114     , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_200
2115     , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
2116     , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
2117     , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_200
2118     , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2119     , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2120     , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2121     , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2122     , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2123     , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2124     , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2125     , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2126     , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2127     , p4_a23 in out nocopy JTF_NUMBER_TABLE
2128     , p4_a24 in out nocopy JTF_NUMBER_TABLE
2129     , p5_a0 in out nocopy  NUMBER
2130     , p5_a1 in out nocopy  DATE
2131     , p5_a2 in out nocopy  DATE
2132     , p5_a3 in out nocopy  NUMBER
2133     , p5_a4 in out nocopy  NUMBER
2134     , p5_a5 in out nocopy  NUMBER
2135     , p5_a6 in out nocopy  VARCHAR2
2136     , p5_a7 in out nocopy  NUMBER
2137     , p5_a8 in out nocopy  VARCHAR2
2138     , p5_a9 in out nocopy  NUMBER
2139     , p5_a10 in out nocopy  VARCHAR2
2140     , p5_a11 in out nocopy  NUMBER
2141     , p5_a12 in out nocopy  NUMBER
2142     , p5_a13 in out nocopy  NUMBER
2143     , p5_a14 in out nocopy  NUMBER
2144     , p5_a15 in out nocopy  VARCHAR2
2145     , p5_a16 in out nocopy  NUMBER
2146     , p5_a17 in out nocopy  VARCHAR2
2147     , p5_a18 in out nocopy  VARCHAR2
2148     , p5_a19 in out nocopy  NUMBER
2149     , p5_a20 in out nocopy  VARCHAR2
2150     , p5_a21 in out nocopy  VARCHAR2
2151     , p5_a22 in out nocopy  VARCHAR2
2152     , p5_a23 in out nocopy  VARCHAR2
2153     , p5_a24 in out nocopy  VARCHAR2
2154     , p5_a25 in out nocopy  VARCHAR2
2155     , p5_a26 in out nocopy  VARCHAR2
2156     , p5_a27 in out nocopy  VARCHAR2
2157     , p5_a28 in out nocopy  VARCHAR2
2158     , p5_a29 in out nocopy  VARCHAR2
2159     , p5_a30 in out nocopy  VARCHAR2
2160     , p5_a31 in out nocopy  VARCHAR2
2161     , p5_a32 in out nocopy  VARCHAR2
2162     , p5_a33 in out nocopy  VARCHAR2
2163     , p5_a34 in out nocopy  VARCHAR2
2164     , p5_a35 in out nocopy  VARCHAR2
2165     , p5_a36 in out nocopy  NUMBER
2166     , p5_a37 in out nocopy  VARCHAR2
2167     , p5_a38 in out nocopy  DATE
2168     , p5_a39 in out nocopy  NUMBER
2169     , x_return_status out nocopy  VARCHAR2
2170     , x_msg_count out nocopy  NUMBER
2171     , x_msg_data out nocopy  VARCHAR2
2172   );
2173   procedure update_extended_attrib_values(p_api_version  NUMBER
2174     , p_commit  VARCHAR2
2175     , p_init_msg_list  VARCHAR2
2176     , p_validation_level  NUMBER
2177     , p4_a0 JTF_NUMBER_TABLE
2178     , p4_a1 JTF_NUMBER_TABLE
2179     , p4_a2 JTF_NUMBER_TABLE
2180     , p4_a3 JTF_VARCHAR2_TABLE_100
2181     , p4_a4 JTF_VARCHAR2_TABLE_300
2182     , p4_a5 JTF_DATE_TABLE
2183     , p4_a6 JTF_DATE_TABLE
2184     , p4_a7 JTF_VARCHAR2_TABLE_100
2185     , p4_a8 JTF_VARCHAR2_TABLE_200
2186     , p4_a9 JTF_VARCHAR2_TABLE_200
2187     , p4_a10 JTF_VARCHAR2_TABLE_200
2188     , p4_a11 JTF_VARCHAR2_TABLE_200
2189     , p4_a12 JTF_VARCHAR2_TABLE_200
2190     , p4_a13 JTF_VARCHAR2_TABLE_200
2191     , p4_a14 JTF_VARCHAR2_TABLE_200
2192     , p4_a15 JTF_VARCHAR2_TABLE_200
2193     , p4_a16 JTF_VARCHAR2_TABLE_200
2194     , p4_a17 JTF_VARCHAR2_TABLE_200
2195     , p4_a18 JTF_VARCHAR2_TABLE_200
2196     , p4_a19 JTF_VARCHAR2_TABLE_200
2197     , p4_a20 JTF_VARCHAR2_TABLE_200
2198     , p4_a21 JTF_VARCHAR2_TABLE_200
2199     , p4_a22 JTF_VARCHAR2_TABLE_200
2200     , p4_a23 JTF_NUMBER_TABLE
2201     , p4_a24 JTF_NUMBER_TABLE
2202     , p5_a0 in out nocopy  NUMBER
2203     , p5_a1 in out nocopy  DATE
2204     , p5_a2 in out nocopy  DATE
2205     , p5_a3 in out nocopy  NUMBER
2206     , p5_a4 in out nocopy  NUMBER
2207     , p5_a5 in out nocopy  NUMBER
2208     , p5_a6 in out nocopy  VARCHAR2
2209     , p5_a7 in out nocopy  NUMBER
2210     , p5_a8 in out nocopy  VARCHAR2
2211     , p5_a9 in out nocopy  NUMBER
2212     , p5_a10 in out nocopy  VARCHAR2
2213     , p5_a11 in out nocopy  NUMBER
2214     , p5_a12 in out nocopy  NUMBER
2215     , p5_a13 in out nocopy  NUMBER
2216     , p5_a14 in out nocopy  NUMBER
2217     , p5_a15 in out nocopy  VARCHAR2
2218     , p5_a16 in out nocopy  NUMBER
2219     , p5_a17 in out nocopy  VARCHAR2
2220     , p5_a18 in out nocopy  VARCHAR2
2221     , p5_a19 in out nocopy  NUMBER
2222     , p5_a20 in out nocopy  VARCHAR2
2223     , p5_a21 in out nocopy  VARCHAR2
2224     , p5_a22 in out nocopy  VARCHAR2
2225     , p5_a23 in out nocopy  VARCHAR2
2226     , p5_a24 in out nocopy  VARCHAR2
2227     , p5_a25 in out nocopy  VARCHAR2
2228     , p5_a26 in out nocopy  VARCHAR2
2229     , p5_a27 in out nocopy  VARCHAR2
2230     , p5_a28 in out nocopy  VARCHAR2
2231     , p5_a29 in out nocopy  VARCHAR2
2232     , p5_a30 in out nocopy  VARCHAR2
2233     , p5_a31 in out nocopy  VARCHAR2
2234     , p5_a32 in out nocopy  VARCHAR2
2235     , p5_a33 in out nocopy  VARCHAR2
2236     , p5_a34 in out nocopy  VARCHAR2
2237     , p5_a35 in out nocopy  VARCHAR2
2238     , p5_a36 in out nocopy  NUMBER
2239     , p5_a37 in out nocopy  VARCHAR2
2240     , p5_a38 in out nocopy  DATE
2241     , p5_a39 in out nocopy  NUMBER
2242     , x_return_status out nocopy  VARCHAR2
2243     , x_msg_count out nocopy  NUMBER
2244     , x_msg_data out nocopy  VARCHAR2
2245   );
2246   procedure expire_extended_attrib_values(p_api_version  NUMBER
2247     , p_commit  VARCHAR2
2248     , p_init_msg_list  VARCHAR2
2249     , p_validation_level  NUMBER
2250     , p4_a0 JTF_NUMBER_TABLE
2251     , p4_a1 JTF_NUMBER_TABLE
2252     , p4_a2 JTF_NUMBER_TABLE
2253     , p4_a3 JTF_VARCHAR2_TABLE_100
2254     , p4_a4 JTF_VARCHAR2_TABLE_300
2255     , p4_a5 JTF_DATE_TABLE
2256     , p4_a6 JTF_DATE_TABLE
2257     , p4_a7 JTF_VARCHAR2_TABLE_100
2258     , p4_a8 JTF_VARCHAR2_TABLE_200
2259     , p4_a9 JTF_VARCHAR2_TABLE_200
2260     , p4_a10 JTF_VARCHAR2_TABLE_200
2261     , p4_a11 JTF_VARCHAR2_TABLE_200
2262     , p4_a12 JTF_VARCHAR2_TABLE_200
2263     , p4_a13 JTF_VARCHAR2_TABLE_200
2264     , p4_a14 JTF_VARCHAR2_TABLE_200
2265     , p4_a15 JTF_VARCHAR2_TABLE_200
2266     , p4_a16 JTF_VARCHAR2_TABLE_200
2267     , p4_a17 JTF_VARCHAR2_TABLE_200
2268     , p4_a18 JTF_VARCHAR2_TABLE_200
2269     , p4_a19 JTF_VARCHAR2_TABLE_200
2270     , p4_a20 JTF_VARCHAR2_TABLE_200
2271     , p4_a21 JTF_VARCHAR2_TABLE_200
2272     , p4_a22 JTF_VARCHAR2_TABLE_200
2273     , p4_a23 JTF_NUMBER_TABLE
2274     , p4_a24 JTF_NUMBER_TABLE
2275     , p5_a0 in out nocopy  NUMBER
2276     , p5_a1 in out nocopy  DATE
2277     , p5_a2 in out nocopy  DATE
2278     , p5_a3 in out nocopy  NUMBER
2279     , p5_a4 in out nocopy  NUMBER
2280     , p5_a5 in out nocopy  NUMBER
2281     , p5_a6 in out nocopy  VARCHAR2
2282     , p5_a7 in out nocopy  NUMBER
2283     , p5_a8 in out nocopy  VARCHAR2
2284     , p5_a9 in out nocopy  NUMBER
2285     , p5_a10 in out nocopy  VARCHAR2
2286     , p5_a11 in out nocopy  NUMBER
2287     , p5_a12 in out nocopy  NUMBER
2288     , p5_a13 in out nocopy  NUMBER
2289     , p5_a14 in out nocopy  NUMBER
2290     , p5_a15 in out nocopy  VARCHAR2
2291     , p5_a16 in out nocopy  NUMBER
2292     , p5_a17 in out nocopy  VARCHAR2
2293     , p5_a18 in out nocopy  VARCHAR2
2294     , p5_a19 in out nocopy  NUMBER
2295     , p5_a20 in out nocopy  VARCHAR2
2296     , p5_a21 in out nocopy  VARCHAR2
2297     , p5_a22 in out nocopy  VARCHAR2
2298     , p5_a23 in out nocopy  VARCHAR2
2299     , p5_a24 in out nocopy  VARCHAR2
2300     , p5_a25 in out nocopy  VARCHAR2
2301     , p5_a26 in out nocopy  VARCHAR2
2302     , p5_a27 in out nocopy  VARCHAR2
2303     , p5_a28 in out nocopy  VARCHAR2
2304     , p5_a29 in out nocopy  VARCHAR2
2305     , p5_a30 in out nocopy  VARCHAR2
2306     , p5_a31 in out nocopy  VARCHAR2
2307     , p5_a32 in out nocopy  VARCHAR2
2308     , p5_a33 in out nocopy  VARCHAR2
2309     , p5_a34 in out nocopy  VARCHAR2
2310     , p5_a35 in out nocopy  VARCHAR2
2311     , p5_a36 in out nocopy  NUMBER
2312     , p5_a37 in out nocopy  VARCHAR2
2313     , p5_a38 in out nocopy  DATE
2314     , p5_a39 in out nocopy  NUMBER
2315     , x_return_status out nocopy  VARCHAR2
2316     , x_msg_count out nocopy  NUMBER
2317     , x_msg_data out nocopy  VARCHAR2
2318   );
2319   procedure copy_item_instance(p_api_version  NUMBER
2320     , p_commit  VARCHAR2
2321     , p_init_msg_list  VARCHAR2
2322     , p_validation_level  NUMBER
2323     , p_copy_ext_attribs  VARCHAR2
2324     , p_copy_org_assignments  VARCHAR2
2325     , p_copy_parties  VARCHAR2
2326     , p_copy_party_contacts  VARCHAR2
2327     , p_copy_accounts  VARCHAR2
2328     , p_copy_asset_assignments  VARCHAR2
2329     , p_copy_pricing_attribs  VARCHAR2
2330     , p_copy_inst_children  VARCHAR2
2331     , p13_a0 in out nocopy  NUMBER
2332     , p13_a1 in out nocopy  DATE
2333     , p13_a2 in out nocopy  DATE
2334     , p13_a3 in out nocopy  NUMBER
2335     , p13_a4 in out nocopy  NUMBER
2336     , p13_a5 in out nocopy  NUMBER
2337     , p13_a6 in out nocopy  VARCHAR2
2338     , p13_a7 in out nocopy  NUMBER
2339     , p13_a8 in out nocopy  VARCHAR2
2340     , p13_a9 in out nocopy  NUMBER
2341     , p13_a10 in out nocopy  VARCHAR2
2342     , p13_a11 in out nocopy  NUMBER
2343     , p13_a12 in out nocopy  NUMBER
2344     , p13_a13 in out nocopy  NUMBER
2345     , p13_a14 in out nocopy  NUMBER
2346     , p13_a15 in out nocopy  VARCHAR2
2347     , p13_a16 in out nocopy  NUMBER
2348     , p13_a17 in out nocopy  VARCHAR2
2349     , p13_a18 in out nocopy  VARCHAR2
2350     , p13_a19 in out nocopy  NUMBER
2351     , p13_a20 in out nocopy  VARCHAR2
2352     , p13_a21 in out nocopy  VARCHAR2
2353     , p13_a22 in out nocopy  VARCHAR2
2354     , p13_a23 in out nocopy  VARCHAR2
2355     , p13_a24 in out nocopy  VARCHAR2
2356     , p13_a25 in out nocopy  VARCHAR2
2357     , p13_a26 in out nocopy  VARCHAR2
2358     , p13_a27 in out nocopy  VARCHAR2
2359     , p13_a28 in out nocopy  VARCHAR2
2360     , p13_a29 in out nocopy  VARCHAR2
2361     , p13_a30 in out nocopy  VARCHAR2
2362     , p13_a31 in out nocopy  VARCHAR2
2363     , p13_a32 in out nocopy  VARCHAR2
2364     , p13_a33 in out nocopy  VARCHAR2
2365     , p13_a34 in out nocopy  VARCHAR2
2366     , p13_a35 in out nocopy  VARCHAR2
2367     , p13_a36 in out nocopy  NUMBER
2368     , p13_a37 in out nocopy  VARCHAR2
2369     , p13_a38 in out nocopy  DATE
2370     , p13_a39 in out nocopy  NUMBER
2371     , p14_a0 out nocopy JTF_NUMBER_TABLE
2372     , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
2373     , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
2374     , p14_a3 out nocopy JTF_NUMBER_TABLE
2375     , p14_a4 out nocopy JTF_NUMBER_TABLE
2376     , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
2377     , p14_a6 out nocopy JTF_NUMBER_TABLE
2378     , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
2379     , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
2380     , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
2381     , p14_a10 out nocopy JTF_NUMBER_TABLE
2382     , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
2383     , p14_a12 out nocopy JTF_VARCHAR2_TABLE_100
2384     , p14_a13 out nocopy JTF_NUMBER_TABLE
2385     , p14_a14 out nocopy JTF_NUMBER_TABLE
2386     , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
2387     , p14_a16 out nocopy JTF_VARCHAR2_TABLE_100
2388     , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
2389     , p14_a18 out nocopy JTF_NUMBER_TABLE
2390     , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
2391     , p14_a20 out nocopy JTF_DATE_TABLE
2392     , p14_a21 out nocopy JTF_DATE_TABLE
2393     , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
2394     , p14_a23 out nocopy JTF_NUMBER_TABLE
2395     , p14_a24 out nocopy JTF_NUMBER_TABLE
2396     , p14_a25 out nocopy JTF_VARCHAR2_TABLE_100
2397     , p14_a26 out nocopy JTF_NUMBER_TABLE
2398     , p14_a27 out nocopy JTF_NUMBER_TABLE
2399     , p14_a28 out nocopy JTF_NUMBER_TABLE
2400     , p14_a29 out nocopy JTF_NUMBER_TABLE
2401     , p14_a30 out nocopy JTF_NUMBER_TABLE
2402     , p14_a31 out nocopy JTF_NUMBER_TABLE
2403     , p14_a32 out nocopy JTF_NUMBER_TABLE
2404     , p14_a33 out nocopy JTF_NUMBER_TABLE
2405     , p14_a34 out nocopy JTF_NUMBER_TABLE
2406     , p14_a35 out nocopy JTF_VARCHAR2_TABLE_100
2407     , p14_a36 out nocopy JTF_NUMBER_TABLE
2408     , p14_a37 out nocopy JTF_NUMBER_TABLE
2409     , p14_a38 out nocopy JTF_NUMBER_TABLE
2410     , p14_a39 out nocopy JTF_NUMBER_TABLE
2411     , p14_a40 out nocopy JTF_DATE_TABLE
2412     , p14_a41 out nocopy JTF_VARCHAR2_TABLE_100
2413     , p14_a42 out nocopy JTF_DATE_TABLE
2414     , p14_a43 out nocopy JTF_DATE_TABLE
2415     , p14_a44 out nocopy JTF_VARCHAR2_TABLE_100
2416     , p14_a45 out nocopy JTF_VARCHAR2_TABLE_100
2417     , p14_a46 out nocopy JTF_VARCHAR2_TABLE_300
2418     , p14_a47 out nocopy JTF_VARCHAR2_TABLE_300
2419     , p14_a48 out nocopy JTF_VARCHAR2_TABLE_100
2420     , p14_a49 out nocopy JTF_VARCHAR2_TABLE_300
2421     , p14_a50 out nocopy JTF_VARCHAR2_TABLE_300
2422     , p14_a51 out nocopy JTF_VARCHAR2_TABLE_300
2423     , p14_a52 out nocopy JTF_VARCHAR2_TABLE_300
2424     , p14_a53 out nocopy JTF_VARCHAR2_TABLE_300
2425     , p14_a54 out nocopy JTF_VARCHAR2_TABLE_300
2426     , p14_a55 out nocopy JTF_VARCHAR2_TABLE_300
2427     , p14_a56 out nocopy JTF_VARCHAR2_TABLE_300
2428     , p14_a57 out nocopy JTF_VARCHAR2_TABLE_300
2429     , p14_a58 out nocopy JTF_VARCHAR2_TABLE_300
2430     , p14_a59 out nocopy JTF_VARCHAR2_TABLE_300
2431     , p14_a60 out nocopy JTF_VARCHAR2_TABLE_300
2432     , p14_a61 out nocopy JTF_VARCHAR2_TABLE_300
2433     , p14_a62 out nocopy JTF_VARCHAR2_TABLE_300
2434     , p14_a63 out nocopy JTF_VARCHAR2_TABLE_300
2435     , p14_a64 out nocopy JTF_NUMBER_TABLE
2436     , p14_a65 out nocopy JTF_NUMBER_TABLE
2437     , p14_a66 out nocopy JTF_VARCHAR2_TABLE_100
2438     , p14_a67 out nocopy JTF_NUMBER_TABLE
2439     , p14_a68 out nocopy JTF_VARCHAR2_TABLE_100
2440     , p14_a69 out nocopy JTF_VARCHAR2_TABLE_100
2441     , p14_a70 out nocopy JTF_VARCHAR2_TABLE_100
2442     , p14_a71 out nocopy JTF_VARCHAR2_TABLE_100
2443     , p14_a72 out nocopy JTF_NUMBER_TABLE
2444     , p14_a73 out nocopy JTF_VARCHAR2_TABLE_100
2445     , p14_a74 out nocopy JTF_NUMBER_TABLE
2446     , p14_a75 out nocopy JTF_NUMBER_TABLE
2447     , p14_a76 out nocopy JTF_NUMBER_TABLE
2448     , p14_a77 out nocopy JTF_VARCHAR2_TABLE_100
2449     , p14_a78 out nocopy JTF_VARCHAR2_TABLE_300
2450     , p14_a79 out nocopy JTF_VARCHAR2_TABLE_100
2451     , p14_a80 out nocopy JTF_NUMBER_TABLE
2452     , p14_a81 out nocopy JTF_NUMBER_TABLE
2453     , p14_a82 out nocopy JTF_NUMBER_TABLE
2454     , p14_a83 out nocopy JTF_DATE_TABLE
2455     , p14_a84 out nocopy JTF_VARCHAR2_TABLE_100
2456     , p14_a85 out nocopy JTF_VARCHAR2_TABLE_100
2457     , p14_a86 out nocopy JTF_VARCHAR2_TABLE_100
2458     , p14_a87 out nocopy JTF_NUMBER_TABLE
2459     , p14_a88 out nocopy JTF_VARCHAR2_TABLE_100
2460     , p14_a89 out nocopy JTF_NUMBER_TABLE
2461     , p14_a90 out nocopy JTF_NUMBER_TABLE
2462     , p14_a91 out nocopy JTF_VARCHAR2_TABLE_100
2463     , p14_a92 out nocopy JTF_NUMBER_TABLE
2464     , p14_a93 out nocopy JTF_VARCHAR2_TABLE_100
2465     , p14_a94 out nocopy JTF_NUMBER_TABLE
2466     , p14_a95 out nocopy JTF_DATE_TABLE
2467     , p14_a96 out nocopy JTF_VARCHAR2_TABLE_300
2468     , p14_a97 out nocopy JTF_VARCHAR2_TABLE_300
2469     , p14_a98 out nocopy JTF_VARCHAR2_TABLE_300
2470     , p14_a99 out nocopy JTF_VARCHAR2_TABLE_300
2471     , p14_a100 out nocopy JTF_VARCHAR2_TABLE_300
2472     , p14_a101 out nocopy JTF_VARCHAR2_TABLE_300
2473     , p14_a102 out nocopy JTF_VARCHAR2_TABLE_300
2474     , p14_a103 out nocopy JTF_VARCHAR2_TABLE_300
2475     , p14_a104 out nocopy JTF_VARCHAR2_TABLE_300
2476     , p14_a105 out nocopy JTF_VARCHAR2_TABLE_300
2477     , p14_a106 out nocopy JTF_VARCHAR2_TABLE_300
2478     , p14_a107 out nocopy JTF_VARCHAR2_TABLE_300
2479     , p14_a108 out nocopy JTF_VARCHAR2_TABLE_300
2480     , p14_a109 out nocopy JTF_VARCHAR2_TABLE_300
2481     , p14_a110 out nocopy JTF_VARCHAR2_TABLE_300
2482     , p14_a111 out nocopy JTF_NUMBER_TABLE
2483     , p14_a112 out nocopy JTF_VARCHAR2_TABLE_100
2484     , p14_a113 out nocopy JTF_NUMBER_TABLE
2485     , p14_a114 out nocopy JTF_VARCHAR2_TABLE_100
2486     , p14_a115 out nocopy JTF_NUMBER_TABLE
2487     , p14_a116 out nocopy JTF_VARCHAR2_TABLE_100
2488     , p14_a117 out nocopy JTF_VARCHAR2_TABLE_100
2489     , p14_a118 out nocopy JTF_NUMBER_TABLE
2490     , p14_a119 out nocopy JTF_VARCHAR2_TABLE_100
2491     , p14_a120 out nocopy JTF_NUMBER_TABLE
2492     , p14_a121 out nocopy JTF_NUMBER_TABLE
2493     , p14_a122 out nocopy JTF_VARCHAR2_TABLE_100
2494     , x_return_status out nocopy  VARCHAR2
2495     , x_msg_count out nocopy  NUMBER
2496     , x_msg_data out nocopy  VARCHAR2
2497     , p4_a0  NUMBER := 0-1962.0724
2498     , p4_a1  VARCHAR2 := fnd_api.g_miss_char
2499     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
2500     , p4_a3  NUMBER := 0-1962.0724
2501     , p4_a4  NUMBER := 0-1962.0724
2502     , p4_a5  VARCHAR2 := fnd_api.g_miss_char
2503     , p4_a6  NUMBER := 0-1962.0724
2504     , p4_a7  VARCHAR2 := fnd_api.g_miss_char
2505     , p4_a8  VARCHAR2 := fnd_api.g_miss_char
2506     , p4_a9  VARCHAR2 := fnd_api.g_miss_char
2507     , p4_a10  NUMBER := 0-1962.0724
2508     , p4_a11  VARCHAR2 := fnd_api.g_miss_char
2509     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
2510     , p4_a13  NUMBER := 0-1962.0724
2511     , p4_a14  NUMBER := 0-1962.0724
2512     , p4_a15  VARCHAR2 := fnd_api.g_miss_char
2513     , p4_a16  VARCHAR2 := fnd_api.g_miss_char
2514     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
2515     , p4_a18  NUMBER := 0-1962.0724
2516     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
2517     , p4_a20  DATE := fnd_api.g_miss_date
2518     , p4_a21  DATE := fnd_api.g_miss_date
2519     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
2520     , p4_a23  NUMBER := 0-1962.0724
2521     , p4_a24  NUMBER := 0-1962.0724
2522     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
2523     , p4_a26  NUMBER := 0-1962.0724
2524     , p4_a27  NUMBER := 0-1962.0724
2525     , p4_a28  NUMBER := 0-1962.0724
2526     , p4_a29  NUMBER := 0-1962.0724
2527     , p4_a30  NUMBER := 0-1962.0724
2528     , p4_a31  NUMBER := 0-1962.0724
2529     , p4_a32  NUMBER := 0-1962.0724
2530     , p4_a33  NUMBER := 0-1962.0724
2531     , p4_a34  NUMBER := 0-1962.0724
2532     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
2533     , p4_a36  NUMBER := 0-1962.0724
2534     , p4_a37  NUMBER := 0-1962.0724
2535     , p4_a38  NUMBER := 0-1962.0724
2536     , p4_a39  NUMBER := 0-1962.0724
2537     , p4_a40  DATE := fnd_api.g_miss_date
2538     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
2539     , p4_a42  DATE := fnd_api.g_miss_date
2540     , p4_a43  DATE := fnd_api.g_miss_date
2541     , p4_a44  VARCHAR2 := fnd_api.g_miss_char
2542     , p4_a45  VARCHAR2 := fnd_api.g_miss_char
2543     , p4_a46  VARCHAR2 := fnd_api.g_miss_char
2544     , p4_a47  VARCHAR2 := fnd_api.g_miss_char
2545     , p4_a48  VARCHAR2 := fnd_api.g_miss_char
2546     , p4_a49  VARCHAR2 := fnd_api.g_miss_char
2547     , p4_a50  VARCHAR2 := fnd_api.g_miss_char
2548     , p4_a51  VARCHAR2 := fnd_api.g_miss_char
2549     , p4_a52  VARCHAR2 := fnd_api.g_miss_char
2550     , p4_a53  VARCHAR2 := fnd_api.g_miss_char
2551     , p4_a54  VARCHAR2 := fnd_api.g_miss_char
2552     , p4_a55  VARCHAR2 := fnd_api.g_miss_char
2553     , p4_a56  VARCHAR2 := fnd_api.g_miss_char
2554     , p4_a57  VARCHAR2 := fnd_api.g_miss_char
2555     , p4_a58  VARCHAR2 := fnd_api.g_miss_char
2556     , p4_a59  VARCHAR2 := fnd_api.g_miss_char
2557     , p4_a60  VARCHAR2 := fnd_api.g_miss_char
2558     , p4_a61  VARCHAR2 := fnd_api.g_miss_char
2559     , p4_a62  VARCHAR2 := fnd_api.g_miss_char
2560     , p4_a63  VARCHAR2 := fnd_api.g_miss_char
2561     , p4_a64  NUMBER := 0-1962.0724
2562     , p4_a65  NUMBER := 0-1962.0724
2563     , p4_a66  VARCHAR2 := fnd_api.g_miss_char
2564     , p4_a67  NUMBER := 0-1962.0724
2565     , p4_a68  VARCHAR2 := fnd_api.g_miss_char
2566     , p4_a69  VARCHAR2 := fnd_api.g_miss_char
2567     , p4_a70  VARCHAR2 := fnd_api.g_miss_char
2568     , p4_a71  VARCHAR2 := fnd_api.g_miss_char
2569     , p4_a72  NUMBER := 0-1962.0724
2570     , p4_a73  VARCHAR2 := fnd_api.g_miss_char
2571     , p4_a74  NUMBER := 0-1962.0724
2572     , p4_a75  NUMBER := 0-1962.0724
2573     , p4_a76  NUMBER := 0-1962.0724
2574     , p4_a77  VARCHAR2 := fnd_api.g_miss_char
2575     , p4_a78  VARCHAR2 := fnd_api.g_miss_char
2576     , p4_a79  VARCHAR2 := fnd_api.g_miss_char
2577     , p4_a80  NUMBER := 0-1962.0724
2578     , p4_a81  NUMBER := 0-1962.0724
2579     , p4_a82  NUMBER := 0-1962.0724
2580     , p4_a83  DATE := fnd_api.g_miss_date
2581     , p4_a84  VARCHAR2 := fnd_api.g_miss_char
2582     , p4_a85  VARCHAR2 := fnd_api.g_miss_char
2583     , p4_a86  VARCHAR2 := fnd_api.g_miss_char
2584     , p4_a87  NUMBER := 0-1962.0724
2585     , p4_a88  VARCHAR2 := fnd_api.g_miss_char
2586     , p4_a89  NUMBER := 0-1962.0724
2587     , p4_a90  NUMBER := 0-1962.0724
2588     , p4_a91  VARCHAR2 := fnd_api.g_miss_char
2589     , p4_a92  NUMBER := 0-1962.0724
2590     , p4_a93  VARCHAR2 := fnd_api.g_miss_char
2591     , p4_a94  NUMBER := 0-1962.0724
2592     , p4_a95  DATE := fnd_api.g_miss_date
2593     , p4_a96  VARCHAR2 := fnd_api.g_miss_char
2594     , p4_a97  VARCHAR2 := fnd_api.g_miss_char
2595     , p4_a98  VARCHAR2 := fnd_api.g_miss_char
2596     , p4_a99  VARCHAR2 := fnd_api.g_miss_char
2597     , p4_a100  VARCHAR2 := fnd_api.g_miss_char
2598     , p4_a101  VARCHAR2 := fnd_api.g_miss_char
2599     , p4_a102  VARCHAR2 := fnd_api.g_miss_char
2600     , p4_a103  VARCHAR2 := fnd_api.g_miss_char
2601     , p4_a104  VARCHAR2 := fnd_api.g_miss_char
2602     , p4_a105  VARCHAR2 := fnd_api.g_miss_char
2603     , p4_a106  VARCHAR2 := fnd_api.g_miss_char
2604     , p4_a107  VARCHAR2 := fnd_api.g_miss_char
2605     , p4_a108  VARCHAR2 := fnd_api.g_miss_char
2606     , p4_a109  VARCHAR2 := fnd_api.g_miss_char
2607     , p4_a110  VARCHAR2 := fnd_api.g_miss_char
2608     , p4_a111  NUMBER := 0-1962.0724
2609     , p4_a112  VARCHAR2 := fnd_api.g_miss_char
2610     , p4_a113  NUMBER := 0-1962.0724
2611     , p4_a114  VARCHAR2 := fnd_api.g_miss_char
2612     , p4_a115  NUMBER := 0-1962.0724
2613     , p4_a116  VARCHAR2 := fnd_api.g_miss_char
2614     , p4_a117  VARCHAR2 := fnd_api.g_miss_char
2615     , p4_a118  NUMBER := 0-1962.0724
2616     , p4_a119  VARCHAR2 := fnd_api.g_miss_char
2617     , p4_a120  NUMBER := 0-1962.0724
2618     , p4_a121  NUMBER := 0-1962.0724
2619     , p4_a122  VARCHAR2 := fnd_api.g_miss_char
2620   );
2621   procedure get_oks_txn_types(p_api_version  NUMBER
2622     , p_commit  VARCHAR2
2623     , p_init_msg_list  VARCHAR2
2624     , p_check_contracts_yn  VARCHAR2
2625     , p_txn_type  VARCHAR2
2626     , x_txn_type_tbl out nocopy JTF_VARCHAR2_TABLE_100
2627     , x_configflag out nocopy  VARCHAR2
2628     , px_txn_date in out nocopy  date
2629     , x_imp_contracts_flag out nocopy  VARCHAR2
2630     , x_return_status out nocopy  VARCHAR2
2631     , x_msg_count out nocopy  NUMBER
2632     , x_msg_data out nocopy  VARCHAR2
2633     , p3_a0  NUMBER := 0-1962.0724
2634     , p3_a1  VARCHAR2 := fnd_api.g_miss_char
2635     , p3_a2  VARCHAR2 := fnd_api.g_miss_char
2636     , p3_a3  NUMBER := 0-1962.0724
2637     , p3_a4  NUMBER := 0-1962.0724
2638     , p3_a5  VARCHAR2 := fnd_api.g_miss_char
2639     , p3_a6  NUMBER := 0-1962.0724
2640     , p3_a7  VARCHAR2 := fnd_api.g_miss_char
2641     , p3_a8  VARCHAR2 := fnd_api.g_miss_char
2642     , p3_a9  VARCHAR2 := fnd_api.g_miss_char
2643     , p3_a10  NUMBER := 0-1962.0724
2644     , p3_a11  VARCHAR2 := fnd_api.g_miss_char
2645     , p3_a12  VARCHAR2 := fnd_api.g_miss_char
2646     , p3_a13  NUMBER := 0-1962.0724
2647     , p3_a14  NUMBER := 0-1962.0724
2648     , p3_a15  VARCHAR2 := fnd_api.g_miss_char
2649     , p3_a16  VARCHAR2 := fnd_api.g_miss_char
2650     , p3_a17  VARCHAR2 := fnd_api.g_miss_char
2651     , p3_a18  NUMBER := 0-1962.0724
2652     , p3_a19  VARCHAR2 := fnd_api.g_miss_char
2653     , p3_a20  DATE := fnd_api.g_miss_date
2654     , p3_a21  DATE := fnd_api.g_miss_date
2655     , p3_a22  VARCHAR2 := fnd_api.g_miss_char
2656     , p3_a23  NUMBER := 0-1962.0724
2657     , p3_a24  NUMBER := 0-1962.0724
2658     , p3_a25  VARCHAR2 := fnd_api.g_miss_char
2659     , p3_a26  NUMBER := 0-1962.0724
2660     , p3_a27  NUMBER := 0-1962.0724
2661     , p3_a28  NUMBER := 0-1962.0724
2662     , p3_a29  NUMBER := 0-1962.0724
2663     , p3_a30  NUMBER := 0-1962.0724
2664     , p3_a31  NUMBER := 0-1962.0724
2665     , p3_a32  NUMBER := 0-1962.0724
2666     , p3_a33  NUMBER := 0-1962.0724
2667     , p3_a34  NUMBER := 0-1962.0724
2668     , p3_a35  VARCHAR2 := fnd_api.g_miss_char
2669     , p3_a36  NUMBER := 0-1962.0724
2670     , p3_a37  NUMBER := 0-1962.0724
2671     , p3_a38  NUMBER := 0-1962.0724
2672     , p3_a39  NUMBER := 0-1962.0724
2673     , p3_a40  DATE := fnd_api.g_miss_date
2674     , p3_a41  VARCHAR2 := fnd_api.g_miss_char
2675     , p3_a42  DATE := fnd_api.g_miss_date
2676     , p3_a43  DATE := fnd_api.g_miss_date
2677     , p3_a44  VARCHAR2 := fnd_api.g_miss_char
2678     , p3_a45  VARCHAR2 := fnd_api.g_miss_char
2679     , p3_a46  VARCHAR2 := fnd_api.g_miss_char
2680     , p3_a47  VARCHAR2 := fnd_api.g_miss_char
2681     , p3_a48  VARCHAR2 := fnd_api.g_miss_char
2682     , p3_a49  VARCHAR2 := fnd_api.g_miss_char
2683     , p3_a50  VARCHAR2 := fnd_api.g_miss_char
2684     , p3_a51  VARCHAR2 := fnd_api.g_miss_char
2685     , p3_a52  VARCHAR2 := fnd_api.g_miss_char
2686     , p3_a53  VARCHAR2 := fnd_api.g_miss_char
2687     , p3_a54  VARCHAR2 := fnd_api.g_miss_char
2688     , p3_a55  VARCHAR2 := fnd_api.g_miss_char
2689     , p3_a56  VARCHAR2 := fnd_api.g_miss_char
2690     , p3_a57  VARCHAR2 := fnd_api.g_miss_char
2691     , p3_a58  VARCHAR2 := fnd_api.g_miss_char
2692     , p3_a59  VARCHAR2 := fnd_api.g_miss_char
2693     , p3_a60  VARCHAR2 := fnd_api.g_miss_char
2694     , p3_a61  VARCHAR2 := fnd_api.g_miss_char
2695     , p3_a62  VARCHAR2 := fnd_api.g_miss_char
2696     , p3_a63  VARCHAR2 := fnd_api.g_miss_char
2697     , p3_a64  NUMBER := 0-1962.0724
2698     , p3_a65  NUMBER := 0-1962.0724
2699     , p3_a66  VARCHAR2 := fnd_api.g_miss_char
2700     , p3_a67  NUMBER := 0-1962.0724
2701     , p3_a68  VARCHAR2 := fnd_api.g_miss_char
2702     , p3_a69  VARCHAR2 := fnd_api.g_miss_char
2703     , p3_a70  VARCHAR2 := fnd_api.g_miss_char
2704     , p3_a71  VARCHAR2 := fnd_api.g_miss_char
2705     , p3_a72  NUMBER := 0-1962.0724
2706     , p3_a73  VARCHAR2 := fnd_api.g_miss_char
2707     , p3_a74  NUMBER := 0-1962.0724
2708     , p3_a75  NUMBER := 0-1962.0724
2709     , p3_a76  NUMBER := 0-1962.0724
2710     , p3_a77  VARCHAR2 := fnd_api.g_miss_char
2711     , p3_a78  VARCHAR2 := fnd_api.g_miss_char
2712     , p3_a79  VARCHAR2 := fnd_api.g_miss_char
2713     , p3_a80  NUMBER := 0-1962.0724
2714     , p3_a81  NUMBER := 0-1962.0724
2715     , p3_a82  NUMBER := 0-1962.0724
2716     , p3_a83  DATE := fnd_api.g_miss_date
2717     , p3_a84  VARCHAR2 := fnd_api.g_miss_char
2718     , p3_a85  VARCHAR2 := fnd_api.g_miss_char
2719     , p3_a86  VARCHAR2 := fnd_api.g_miss_char
2720     , p3_a87  NUMBER := 0-1962.0724
2721     , p3_a88  VARCHAR2 := fnd_api.g_miss_char
2722     , p3_a89  NUMBER := 0-1962.0724
2723     , p3_a90  NUMBER := 0-1962.0724
2724     , p3_a91  VARCHAR2 := fnd_api.g_miss_char
2725     , p3_a92  NUMBER := 0-1962.0724
2726     , p3_a93  VARCHAR2 := fnd_api.g_miss_char
2727     , p3_a94  NUMBER := 0-1962.0724
2728     , p3_a95  DATE := fnd_api.g_miss_date
2729     , p3_a96  VARCHAR2 := fnd_api.g_miss_char
2730     , p3_a97  VARCHAR2 := fnd_api.g_miss_char
2731     , p3_a98  VARCHAR2 := fnd_api.g_miss_char
2732     , p3_a99  VARCHAR2 := fnd_api.g_miss_char
2733     , p3_a100  VARCHAR2 := fnd_api.g_miss_char
2734     , p3_a101  VARCHAR2 := fnd_api.g_miss_char
2735     , p3_a102  VARCHAR2 := fnd_api.g_miss_char
2736     , p3_a103  VARCHAR2 := fnd_api.g_miss_char
2737     , p3_a104  VARCHAR2 := fnd_api.g_miss_char
2738     , p3_a105  VARCHAR2 := fnd_api.g_miss_char
2739     , p3_a106  VARCHAR2 := fnd_api.g_miss_char
2740     , p3_a107  VARCHAR2 := fnd_api.g_miss_char
2741     , p3_a108  VARCHAR2 := fnd_api.g_miss_char
2742     , p3_a109  VARCHAR2 := fnd_api.g_miss_char
2743     , p3_a110  VARCHAR2 := fnd_api.g_miss_char
2744     , p3_a111  NUMBER := 0-1962.0724
2745     , p3_a112  VARCHAR2 := fnd_api.g_miss_char
2746     , p3_a113  NUMBER := 0-1962.0724
2747     , p3_a114  VARCHAR2 := fnd_api.g_miss_char
2748     , p3_a115  NUMBER := 0-1962.0724
2749     , p3_a116  VARCHAR2 := fnd_api.g_miss_char
2750     , p3_a117  VARCHAR2 := fnd_api.g_miss_char
2751     , p3_a118  NUMBER := 0-1962.0724
2752     , p3_a119  VARCHAR2 := fnd_api.g_miss_char
2753     , p3_a120  NUMBER := 0-1962.0724
2754     , p3_a121  NUMBER := 0-1962.0724
2755     , p3_a122  VARCHAR2 := fnd_api.g_miss_char
2756   );
2757 end csi_item_instance_pub_w;