DBA Data[Home] [Help]

PACKAGE: APPS.CN_GET_TX_DATA_PUB_W

Source


1 package cn_get_tx_data_pub_w as
2   /* $Header: cnwxadjs.pls 120.4.12000000.2 2007/08/08 05:57:56 apink ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_400
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_100
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_VARCHAR2_TABLE_1800
25     , a22 JTF_NUMBER_TABLE
26     , a23 JTF_NUMBER_TABLE
27     , a24 JTF_DATE_TABLE
28     , a25 JTF_NUMBER_TABLE
29     , a26 JTF_NUMBER_TABLE
30     , a27 JTF_DATE_TABLE
31     , a28 JTF_VARCHAR2_TABLE_100
32     , a29 JTF_VARCHAR2_TABLE_300
33     , a30 JTF_VARCHAR2_TABLE_300
34     , a31 JTF_VARCHAR2_TABLE_300
35     , a32 JTF_VARCHAR2_TABLE_300
36     , a33 JTF_VARCHAR2_TABLE_300
37     , a34 JTF_VARCHAR2_TABLE_300
38     , a35 JTF_VARCHAR2_TABLE_300
39     , a36 JTF_VARCHAR2_TABLE_300
40     , a37 JTF_VARCHAR2_TABLE_300
41     , a38 JTF_VARCHAR2_TABLE_300
42     , a39 JTF_VARCHAR2_TABLE_300
43     , a40 JTF_VARCHAR2_TABLE_300
44     , a41 JTF_VARCHAR2_TABLE_300
45     , a42 JTF_VARCHAR2_TABLE_300
46     , a43 JTF_VARCHAR2_TABLE_300
47     , a44 JTF_VARCHAR2_TABLE_300
48     , a45 JTF_VARCHAR2_TABLE_300
49     , a46 JTF_VARCHAR2_TABLE_300
50     , a47 JTF_VARCHAR2_TABLE_300
51     , a48 JTF_VARCHAR2_TABLE_300
52     , a49 JTF_VARCHAR2_TABLE_300
53     , a50 JTF_VARCHAR2_TABLE_300
54     , a51 JTF_VARCHAR2_TABLE_300
55     , a52 JTF_VARCHAR2_TABLE_300
56     , a53 JTF_VARCHAR2_TABLE_300
57     , a54 JTF_VARCHAR2_TABLE_300
58     , a55 JTF_VARCHAR2_TABLE_300
59     , a56 JTF_VARCHAR2_TABLE_300
60     , a57 JTF_VARCHAR2_TABLE_300
61     , a58 JTF_VARCHAR2_TABLE_300
62     , a59 JTF_VARCHAR2_TABLE_300
63     , a60 JTF_VARCHAR2_TABLE_300
64     , a61 JTF_VARCHAR2_TABLE_300
65     , a62 JTF_VARCHAR2_TABLE_300
66     , a63 JTF_VARCHAR2_TABLE_300
67     , a64 JTF_VARCHAR2_TABLE_300
68     , a65 JTF_VARCHAR2_TABLE_300
69     , a66 JTF_VARCHAR2_TABLE_300
70     , a67 JTF_VARCHAR2_TABLE_300
71     , a68 JTF_VARCHAR2_TABLE_300
72     , a69 JTF_VARCHAR2_TABLE_300
73     , a70 JTF_VARCHAR2_TABLE_300
74     , a71 JTF_VARCHAR2_TABLE_300
75     , a72 JTF_VARCHAR2_TABLE_300
76     , a73 JTF_VARCHAR2_TABLE_300
77     , a74 JTF_VARCHAR2_TABLE_300
78     , a75 JTF_VARCHAR2_TABLE_300
79     , a76 JTF_VARCHAR2_TABLE_300
80     , a77 JTF_VARCHAR2_TABLE_300
81     , a78 JTF_VARCHAR2_TABLE_300
82     , a79 JTF_VARCHAR2_TABLE_300
83     , a80 JTF_VARCHAR2_TABLE_300
84     , a81 JTF_VARCHAR2_TABLE_300
85     , a82 JTF_VARCHAR2_TABLE_300
86     , a83 JTF_VARCHAR2_TABLE_300
87     , a84 JTF_VARCHAR2_TABLE_300
88     , a85 JTF_VARCHAR2_TABLE_300
89     , a86 JTF_VARCHAR2_TABLE_300
90     , a87 JTF_VARCHAR2_TABLE_300
91     , a88 JTF_VARCHAR2_TABLE_300
92     , a89 JTF_VARCHAR2_TABLE_300
93     , a90 JTF_VARCHAR2_TABLE_300
94     , a91 JTF_VARCHAR2_TABLE_300
95     , a92 JTF_VARCHAR2_TABLE_300
96     , a93 JTF_VARCHAR2_TABLE_300
97     , a94 JTF_VARCHAR2_TABLE_300
98     , a95 JTF_VARCHAR2_TABLE_300
99     , a96 JTF_VARCHAR2_TABLE_300
100     , a97 JTF_VARCHAR2_TABLE_300
101     , a98 JTF_VARCHAR2_TABLE_300
102     , a99 JTF_VARCHAR2_TABLE_300
103     , a100 JTF_VARCHAR2_TABLE_300
104     , a101 JTF_VARCHAR2_TABLE_300
105     , a102 JTF_VARCHAR2_TABLE_300
106     , a103 JTF_VARCHAR2_TABLE_300
107     , a104 JTF_VARCHAR2_TABLE_300
108     , a105 JTF_VARCHAR2_TABLE_300
109     , a106 JTF_VARCHAR2_TABLE_300
110     , a107 JTF_VARCHAR2_TABLE_300
111     , a108 JTF_VARCHAR2_TABLE_300
112     , a109 JTF_VARCHAR2_TABLE_300
113     , a110 JTF_VARCHAR2_TABLE_300
114     , a111 JTF_VARCHAR2_TABLE_300
115     , a112 JTF_VARCHAR2_TABLE_300
116     , a113 JTF_VARCHAR2_TABLE_300
117     , a114 JTF_VARCHAR2_TABLE_300
118     , a115 JTF_VARCHAR2_TABLE_300
119     , a116 JTF_VARCHAR2_TABLE_300
120     , a117 JTF_VARCHAR2_TABLE_300
121     , a118 JTF_VARCHAR2_TABLE_300
122     , a119 JTF_VARCHAR2_TABLE_300
123     , a120 JTF_VARCHAR2_TABLE_300
124     , a121 JTF_VARCHAR2_TABLE_300
125     , a122 JTF_VARCHAR2_TABLE_300
126     , a123 JTF_VARCHAR2_TABLE_300
127     , a124 JTF_VARCHAR2_TABLE_300
128     , a125 JTF_VARCHAR2_TABLE_300
129     , a126 JTF_VARCHAR2_TABLE_300
130     , a127 JTF_VARCHAR2_TABLE_300
131     , a128 JTF_VARCHAR2_TABLE_300
132     , a129 JTF_NUMBER_TABLE
133     , a130 JTF_VARCHAR2_TABLE_100
134     , a131 JTF_NUMBER_TABLE
135     , a132 JTF_VARCHAR2_TABLE_100
136     , a133 JTF_VARCHAR2_TABLE_100
137     , a134 JTF_VARCHAR2_TABLE_100
138     , a135 JTF_NUMBER_TABLE
139     , a136 JTF_NUMBER_TABLE
140     , a137 JTF_NUMBER_TABLE
141     , a138 JTF_NUMBER_TABLE
142     , a139 JTF_VARCHAR2_TABLE_100
143     , a140 JTF_NUMBER_TABLE
144     , a141 JTF_NUMBER_TABLE
145     , a142 JTF_VARCHAR2_TABLE_100
146     , a143 JTF_NUMBER_TABLE
147     , a144 JTF_NUMBER_TABLE
148     , a145 JTF_NUMBER_TABLE
149     , a146 JTF_NUMBER_TABLE
150     , a147 JTF_DATE_TABLE
151     , a148 JTF_NUMBER_TABLE
152     , a149 JTF_VARCHAR2_TABLE_100
153     , a150 JTF_DATE_TABLE
154     , a151 JTF_NUMBER_TABLE
155     , a152 JTF_DATE_TABLE
156     , a153 JTF_NUMBER_TABLE
157     , a154 JTF_NUMBER_TABLE
158     , a155 JTF_NUMBER_TABLE
159     , a156 JTF_NUMBER_TABLE
160     , a157 JTF_NUMBER_TABLE
161     , a158 JTF_NUMBER_TABLE
162     , a159 JTF_VARCHAR2_TABLE_100
163     , a160 JTF_VARCHAR2_TABLE_100
164     , a161 JTF_VARCHAR2_TABLE_100
165     , a162 JTF_VARCHAR2_TABLE_100
166     , a163 JTF_DATE_TABLE
167     , a164 JTF_VARCHAR2_TABLE_100
168     , a165 JTF_VARCHAR2_TABLE_100
169     , a166 JTF_VARCHAR2_TABLE_100
170     , a167 JTF_VARCHAR2_TABLE_2000
171     , a168 JTF_VARCHAR2_TABLE_100
172     , a169 JTF_VARCHAR2_TABLE_100
173     , a170 JTF_NUMBER_TABLE
174     , a171 JTF_NUMBER_TABLE
175     , a172 JTF_NUMBER_TABLE
176     , a173 JTF_VARCHAR2_TABLE_100
177     , a174 JTF_NUMBER_TABLE
178     , a175 JTF_NUMBER_TABLE
179     , a176 JTF_VARCHAR2_TABLE_100
180     , a177 JTF_NUMBER_TABLE
181     , a178 JTF_VARCHAR2_TABLE_100
182     , a179 JTF_VARCHAR2_TABLE_100
183     , a180 JTF_VARCHAR2_TABLE_100
184     , a181 JTF_VARCHAR2_TABLE_100
185     , a182 JTF_VARCHAR2_TABLE_100
186     , a183 JTF_NUMBER_TABLE
187     , a184 JTF_NUMBER_TABLE
188     , a185 JTF_NUMBER_TABLE
189     , a186 JTF_NUMBER_TABLE
190     , a187 JTF_NUMBER_TABLE
191     , a188 JTF_NUMBER_TABLE
192     , a189 JTF_VARCHAR2_TABLE_100
193     , a190 JTF_VARCHAR2_TABLE_2000
194     );
195   procedure rosetta_table_copy_out_p1(t cn_get_tx_data_pub.adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
196     , a1 out nocopy JTF_VARCHAR2_TABLE_100
197     , a2 out nocopy JTF_VARCHAR2_TABLE_400
198     , a3 out nocopy JTF_NUMBER_TABLE
199     , a4 out nocopy JTF_NUMBER_TABLE
200     , a5 out nocopy JTF_VARCHAR2_TABLE_100
201     , a6 out nocopy JTF_DATE_TABLE
202     , a7 out nocopy JTF_DATE_TABLE
203     , a8 out nocopy JTF_NUMBER_TABLE
204     , a9 out nocopy JTF_NUMBER_TABLE
205     , a10 out nocopy JTF_NUMBER_TABLE
206     , a11 out nocopy JTF_NUMBER_TABLE
207     , a12 out nocopy JTF_NUMBER_TABLE
208     , a13 out nocopy JTF_VARCHAR2_TABLE_100
209     , a14 out nocopy JTF_NUMBER_TABLE
210     , a15 out nocopy JTF_VARCHAR2_TABLE_100
211     , a16 out nocopy JTF_VARCHAR2_TABLE_100
212     , a17 out nocopy JTF_VARCHAR2_TABLE_100
213     , a18 out nocopy JTF_VARCHAR2_TABLE_100
214     , a19 out nocopy JTF_VARCHAR2_TABLE_100
215     , a20 out nocopy JTF_VARCHAR2_TABLE_100
216     , a21 out nocopy JTF_VARCHAR2_TABLE_1800
217     , a22 out nocopy JTF_NUMBER_TABLE
218     , a23 out nocopy JTF_NUMBER_TABLE
219     , a24 out nocopy JTF_DATE_TABLE
220     , a25 out nocopy JTF_NUMBER_TABLE
221     , a26 out nocopy JTF_NUMBER_TABLE
222     , a27 out nocopy JTF_DATE_TABLE
223     , a28 out nocopy JTF_VARCHAR2_TABLE_100
224     , a29 out nocopy JTF_VARCHAR2_TABLE_300
225     , a30 out nocopy JTF_VARCHAR2_TABLE_300
226     , a31 out nocopy JTF_VARCHAR2_TABLE_300
227     , a32 out nocopy JTF_VARCHAR2_TABLE_300
228     , a33 out nocopy JTF_VARCHAR2_TABLE_300
229     , a34 out nocopy JTF_VARCHAR2_TABLE_300
230     , a35 out nocopy JTF_VARCHAR2_TABLE_300
231     , a36 out nocopy JTF_VARCHAR2_TABLE_300
232     , a37 out nocopy JTF_VARCHAR2_TABLE_300
233     , a38 out nocopy JTF_VARCHAR2_TABLE_300
234     , a39 out nocopy JTF_VARCHAR2_TABLE_300
235     , a40 out nocopy JTF_VARCHAR2_TABLE_300
236     , a41 out nocopy JTF_VARCHAR2_TABLE_300
237     , a42 out nocopy JTF_VARCHAR2_TABLE_300
238     , a43 out nocopy JTF_VARCHAR2_TABLE_300
239     , a44 out nocopy JTF_VARCHAR2_TABLE_300
240     , a45 out nocopy JTF_VARCHAR2_TABLE_300
241     , a46 out nocopy JTF_VARCHAR2_TABLE_300
242     , a47 out nocopy JTF_VARCHAR2_TABLE_300
243     , a48 out nocopy JTF_VARCHAR2_TABLE_300
244     , a49 out nocopy JTF_VARCHAR2_TABLE_300
245     , a50 out nocopy JTF_VARCHAR2_TABLE_300
246     , a51 out nocopy JTF_VARCHAR2_TABLE_300
247     , a52 out nocopy JTF_VARCHAR2_TABLE_300
248     , a53 out nocopy JTF_VARCHAR2_TABLE_300
249     , a54 out nocopy JTF_VARCHAR2_TABLE_300
250     , a55 out nocopy JTF_VARCHAR2_TABLE_300
251     , a56 out nocopy JTF_VARCHAR2_TABLE_300
252     , a57 out nocopy JTF_VARCHAR2_TABLE_300
253     , a58 out nocopy JTF_VARCHAR2_TABLE_300
254     , a59 out nocopy JTF_VARCHAR2_TABLE_300
255     , a60 out nocopy JTF_VARCHAR2_TABLE_300
256     , a61 out nocopy JTF_VARCHAR2_TABLE_300
257     , a62 out nocopy JTF_VARCHAR2_TABLE_300
258     , a63 out nocopy JTF_VARCHAR2_TABLE_300
259     , a64 out nocopy JTF_VARCHAR2_TABLE_300
260     , a65 out nocopy JTF_VARCHAR2_TABLE_300
261     , a66 out nocopy JTF_VARCHAR2_TABLE_300
262     , a67 out nocopy JTF_VARCHAR2_TABLE_300
263     , a68 out nocopy JTF_VARCHAR2_TABLE_300
264     , a69 out nocopy JTF_VARCHAR2_TABLE_300
265     , a70 out nocopy JTF_VARCHAR2_TABLE_300
266     , a71 out nocopy JTF_VARCHAR2_TABLE_300
267     , a72 out nocopy JTF_VARCHAR2_TABLE_300
268     , a73 out nocopy JTF_VARCHAR2_TABLE_300
269     , a74 out nocopy JTF_VARCHAR2_TABLE_300
270     , a75 out nocopy JTF_VARCHAR2_TABLE_300
271     , a76 out nocopy JTF_VARCHAR2_TABLE_300
272     , a77 out nocopy JTF_VARCHAR2_TABLE_300
273     , a78 out nocopy JTF_VARCHAR2_TABLE_300
274     , a79 out nocopy JTF_VARCHAR2_TABLE_300
275     , a80 out nocopy JTF_VARCHAR2_TABLE_300
276     , a81 out nocopy JTF_VARCHAR2_TABLE_300
277     , a82 out nocopy JTF_VARCHAR2_TABLE_300
278     , a83 out nocopy JTF_VARCHAR2_TABLE_300
279     , a84 out nocopy JTF_VARCHAR2_TABLE_300
280     , a85 out nocopy JTF_VARCHAR2_TABLE_300
281     , a86 out nocopy JTF_VARCHAR2_TABLE_300
282     , a87 out nocopy JTF_VARCHAR2_TABLE_300
283     , a88 out nocopy JTF_VARCHAR2_TABLE_300
284     , a89 out nocopy JTF_VARCHAR2_TABLE_300
285     , a90 out nocopy JTF_VARCHAR2_TABLE_300
286     , a91 out nocopy JTF_VARCHAR2_TABLE_300
287     , a92 out nocopy JTF_VARCHAR2_TABLE_300
288     , a93 out nocopy JTF_VARCHAR2_TABLE_300
289     , a94 out nocopy JTF_VARCHAR2_TABLE_300
290     , a95 out nocopy JTF_VARCHAR2_TABLE_300
291     , a96 out nocopy JTF_VARCHAR2_TABLE_300
292     , a97 out nocopy JTF_VARCHAR2_TABLE_300
293     , a98 out nocopy JTF_VARCHAR2_TABLE_300
294     , a99 out nocopy JTF_VARCHAR2_TABLE_300
295     , a100 out nocopy JTF_VARCHAR2_TABLE_300
296     , a101 out nocopy JTF_VARCHAR2_TABLE_300
297     , a102 out nocopy JTF_VARCHAR2_TABLE_300
298     , a103 out nocopy JTF_VARCHAR2_TABLE_300
299     , a104 out nocopy JTF_VARCHAR2_TABLE_300
300     , a105 out nocopy JTF_VARCHAR2_TABLE_300
301     , a106 out nocopy JTF_VARCHAR2_TABLE_300
302     , a107 out nocopy JTF_VARCHAR2_TABLE_300
303     , a108 out nocopy JTF_VARCHAR2_TABLE_300
304     , a109 out nocopy JTF_VARCHAR2_TABLE_300
305     , a110 out nocopy JTF_VARCHAR2_TABLE_300
306     , a111 out nocopy JTF_VARCHAR2_TABLE_300
307     , a112 out nocopy JTF_VARCHAR2_TABLE_300
308     , a113 out nocopy JTF_VARCHAR2_TABLE_300
309     , a114 out nocopy JTF_VARCHAR2_TABLE_300
310     , a115 out nocopy JTF_VARCHAR2_TABLE_300
311     , a116 out nocopy JTF_VARCHAR2_TABLE_300
312     , a117 out nocopy JTF_VARCHAR2_TABLE_300
313     , a118 out nocopy JTF_VARCHAR2_TABLE_300
314     , a119 out nocopy JTF_VARCHAR2_TABLE_300
315     , a120 out nocopy JTF_VARCHAR2_TABLE_300
316     , a121 out nocopy JTF_VARCHAR2_TABLE_300
317     , a122 out nocopy JTF_VARCHAR2_TABLE_300
318     , a123 out nocopy JTF_VARCHAR2_TABLE_300
319     , a124 out nocopy JTF_VARCHAR2_TABLE_300
320     , a125 out nocopy JTF_VARCHAR2_TABLE_300
321     , a126 out nocopy JTF_VARCHAR2_TABLE_300
322     , a127 out nocopy JTF_VARCHAR2_TABLE_300
323     , a128 out nocopy JTF_VARCHAR2_TABLE_300
324     , a129 out nocopy JTF_NUMBER_TABLE
325     , a130 out nocopy JTF_VARCHAR2_TABLE_100
326     , a131 out nocopy JTF_NUMBER_TABLE
327     , a132 out nocopy JTF_VARCHAR2_TABLE_100
328     , a133 out nocopy JTF_VARCHAR2_TABLE_100
329     , a134 out nocopy JTF_VARCHAR2_TABLE_100
330     , a135 out nocopy JTF_NUMBER_TABLE
331     , a136 out nocopy JTF_NUMBER_TABLE
332     , a137 out nocopy JTF_NUMBER_TABLE
333     , a138 out nocopy JTF_NUMBER_TABLE
334     , a139 out nocopy JTF_VARCHAR2_TABLE_100
335     , a140 out nocopy JTF_NUMBER_TABLE
336     , a141 out nocopy JTF_NUMBER_TABLE
337     , a142 out nocopy JTF_VARCHAR2_TABLE_100
338     , a143 out nocopy JTF_NUMBER_TABLE
339     , a144 out nocopy JTF_NUMBER_TABLE
340     , a145 out nocopy JTF_NUMBER_TABLE
341     , a146 out nocopy JTF_NUMBER_TABLE
342     , a147 out nocopy JTF_DATE_TABLE
343     , a148 out nocopy JTF_NUMBER_TABLE
344     , a149 out nocopy JTF_VARCHAR2_TABLE_100
345     , a150 out nocopy JTF_DATE_TABLE
346     , a151 out nocopy JTF_NUMBER_TABLE
347     , a152 out nocopy JTF_DATE_TABLE
348     , a153 out nocopy JTF_NUMBER_TABLE
349     , a154 out nocopy JTF_NUMBER_TABLE
350     , a155 out nocopy JTF_NUMBER_TABLE
351     , a156 out nocopy JTF_NUMBER_TABLE
352     , a157 out nocopy JTF_NUMBER_TABLE
353     , a158 out nocopy JTF_NUMBER_TABLE
354     , a159 out nocopy JTF_VARCHAR2_TABLE_100
355     , a160 out nocopy JTF_VARCHAR2_TABLE_100
356     , a161 out nocopy JTF_VARCHAR2_TABLE_100
357     , a162 out nocopy JTF_VARCHAR2_TABLE_100
358     , a163 out nocopy JTF_DATE_TABLE
359     , a164 out nocopy JTF_VARCHAR2_TABLE_100
360     , a165 out nocopy JTF_VARCHAR2_TABLE_100
361     , a166 out nocopy JTF_VARCHAR2_TABLE_100
362     , a167 out nocopy JTF_VARCHAR2_TABLE_2000
363     , a168 out nocopy JTF_VARCHAR2_TABLE_100
364     , a169 out nocopy JTF_VARCHAR2_TABLE_100
365     , a170 out nocopy JTF_NUMBER_TABLE
366     , a171 out nocopy JTF_NUMBER_TABLE
367     , a172 out nocopy JTF_NUMBER_TABLE
368     , a173 out nocopy JTF_VARCHAR2_TABLE_100
369     , a174 out nocopy JTF_NUMBER_TABLE
370     , a175 out nocopy JTF_NUMBER_TABLE
371     , a176 out nocopy JTF_VARCHAR2_TABLE_100
372     , a177 out nocopy JTF_NUMBER_TABLE
373     , a178 out nocopy JTF_VARCHAR2_TABLE_100
374     , a179 out nocopy JTF_VARCHAR2_TABLE_100
375     , a180 out nocopy JTF_VARCHAR2_TABLE_100
376     , a181 out nocopy JTF_VARCHAR2_TABLE_100
377     , a182 out nocopy JTF_VARCHAR2_TABLE_100
378     , a183 out nocopy JTF_NUMBER_TABLE
379     , a184 out nocopy JTF_NUMBER_TABLE
380     , a185 out nocopy JTF_NUMBER_TABLE
381     , a186 out nocopy JTF_NUMBER_TABLE
382     , a187 out nocopy JTF_NUMBER_TABLE
383     , a188 out nocopy JTF_NUMBER_TABLE
384     , a189 out nocopy JTF_VARCHAR2_TABLE_100
385     , a190 out nocopy JTF_VARCHAR2_TABLE_2000
386     );
387 
388   procedure rosetta_table_copy_in_p3(t out nocopy cn_get_tx_data_pub.tx_adj_data_tbl, a0 JTF_NUMBER_TABLE
389     , a1 JTF_VARCHAR2_TABLE_100
390     , a2 JTF_VARCHAR2_TABLE_400
391     , a3 JTF_DATE_TABLE
392     , a4 JTF_NUMBER_TABLE
393     , a5 JTF_NUMBER_TABLE
394     , a6 JTF_NUMBER_TABLE
395     , a7 JTF_VARCHAR2_TABLE_100
396     , a8 JTF_VARCHAR2_TABLE_100
397     , a9 JTF_VARCHAR2_TABLE_100
398     , a10 JTF_NUMBER_TABLE
399     , a11 JTF_DATE_TABLE
400     , a12 JTF_VARCHAR2_TABLE_100
401     , a13 JTF_DATE_TABLE
402     , a14 JTF_NUMBER_TABLE
403     );
404   procedure rosetta_table_copy_out_p3(t cn_get_tx_data_pub.tx_adj_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
405     , a1 out nocopy JTF_VARCHAR2_TABLE_100
406     , a2 out nocopy JTF_VARCHAR2_TABLE_400
407     , a3 out nocopy JTF_DATE_TABLE
408     , a4 out nocopy JTF_NUMBER_TABLE
409     , a5 out nocopy JTF_NUMBER_TABLE
410     , a6 out nocopy JTF_NUMBER_TABLE
411     , a7 out nocopy JTF_VARCHAR2_TABLE_100
412     , a8 out nocopy JTF_VARCHAR2_TABLE_100
413     , a9 out nocopy JTF_VARCHAR2_TABLE_100
414     , a10 out nocopy JTF_NUMBER_TABLE
415     , a11 out nocopy JTF_DATE_TABLE
416     , a12 out nocopy JTF_VARCHAR2_TABLE_100
417     , a13 out nocopy JTF_DATE_TABLE
418     , a14 out nocopy JTF_NUMBER_TABLE
419     );
420 
421   procedure rosetta_table_copy_in_p5(t out nocopy cn_get_tx_data_pub.split_data_tbl, a0 JTF_NUMBER_TABLE
422     , a1 JTF_VARCHAR2_TABLE_100
423     , a2 JTF_VARCHAR2_TABLE_100
424     , a3 JTF_NUMBER_TABLE
425     , a4 JTF_NUMBER_TABLE
426     );
427   procedure rosetta_table_copy_out_p5(t cn_get_tx_data_pub.split_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
428     , a1 out nocopy JTF_VARCHAR2_TABLE_100
429     , a2 out nocopy JTF_VARCHAR2_TABLE_100
430     , a3 out nocopy JTF_NUMBER_TABLE
431     , a4 out nocopy JTF_NUMBER_TABLE
432     );
433 
434   procedure rosetta_table_copy_in_p7(t out nocopy cn_get_tx_data_pub.trx_line_tbl, a0 JTF_NUMBER_TABLE
435     , a1 JTF_NUMBER_TABLE
436     , a2 JTF_NUMBER_TABLE
437     , a3 JTF_VARCHAR2_TABLE_400
438     , a4 JTF_VARCHAR2_TABLE_100
439     , a5 JTF_NUMBER_TABLE
440     , a6 JTF_DATE_TABLE
441     , a7 JTF_VARCHAR2_TABLE_100
442     , a8 JTF_NUMBER_TABLE
443     , a9 JTF_NUMBER_TABLE
444     , a10 JTF_NUMBER_TABLE
445     , a11 JTF_NUMBER_TABLE
446     , a12 JTF_VARCHAR2_TABLE_100
447     , a13 JTF_VARCHAR2_TABLE_100
448     , a14 JTF_VARCHAR2_TABLE_100
449     , a15 JTF_NUMBER_TABLE
450     , a16 JTF_VARCHAR2_TABLE_100
451     , a17 JTF_VARCHAR2_TABLE_100
452     , a18 JTF_VARCHAR2_TABLE_100
453     , a19 JTF_VARCHAR2_TABLE_400
454     );
455   procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
456     , a1 out nocopy JTF_NUMBER_TABLE
457     , a2 out nocopy JTF_NUMBER_TABLE
458     , a3 out nocopy JTF_VARCHAR2_TABLE_400
459     , a4 out nocopy JTF_VARCHAR2_TABLE_100
460     , a5 out nocopy JTF_NUMBER_TABLE
461     , a6 out nocopy JTF_DATE_TABLE
462     , a7 out nocopy JTF_VARCHAR2_TABLE_100
463     , a8 out nocopy JTF_NUMBER_TABLE
464     , a9 out nocopy JTF_NUMBER_TABLE
465     , a10 out nocopy JTF_NUMBER_TABLE
466     , a11 out nocopy JTF_NUMBER_TABLE
467     , a12 out nocopy JTF_VARCHAR2_TABLE_100
468     , a13 out nocopy JTF_VARCHAR2_TABLE_100
469     , a14 out nocopy JTF_VARCHAR2_TABLE_100
470     , a15 out nocopy JTF_NUMBER_TABLE
471     , a16 out nocopy JTF_VARCHAR2_TABLE_100
472     , a17 out nocopy JTF_VARCHAR2_TABLE_100
473     , a18 out nocopy JTF_VARCHAR2_TABLE_100
474     , a19 out nocopy JTF_VARCHAR2_TABLE_400
475     );
476 
477   procedure rosetta_table_copy_in_p9(t out nocopy cn_get_tx_data_pub.cust_info_tbl, a0 JTF_NUMBER_TABLE
478     , a1 JTF_VARCHAR2_TABLE_100
479     , a2 JTF_VARCHAR2_TABLE_300
480     , a3 JTF_NUMBER_TABLE
481     , a4 JTF_VARCHAR2_TABLE_300
482     , a5 JTF_VARCHAR2_TABLE_300
483     , a6 JTF_VARCHAR2_TABLE_300
484     , a7 JTF_VARCHAR2_TABLE_300
485     , a8 JTF_VARCHAR2_TABLE_100
486     , a9 JTF_VARCHAR2_TABLE_100
487     , a10 JTF_VARCHAR2_TABLE_100
488     , a11 JTF_NUMBER_TABLE
489     , a12 JTF_VARCHAR2_TABLE_300
490     , a13 JTF_VARCHAR2_TABLE_300
491     , a14 JTF_VARCHAR2_TABLE_300
492     , a15 JTF_VARCHAR2_TABLE_300
493     , a16 JTF_VARCHAR2_TABLE_100
494     , a17 JTF_VARCHAR2_TABLE_100
495     , a18 JTF_VARCHAR2_TABLE_100
496     , a19 JTF_NUMBER_TABLE
497     , a20 JTF_VARCHAR2_TABLE_400
498     , a21 JTF_NUMBER_TABLE
499     , a22 JTF_VARCHAR2_TABLE_400
500     );
501   procedure rosetta_table_copy_out_p9(t cn_get_tx_data_pub.cust_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
502     , a1 out nocopy JTF_VARCHAR2_TABLE_100
503     , a2 out nocopy JTF_VARCHAR2_TABLE_300
504     , a3 out nocopy JTF_NUMBER_TABLE
505     , a4 out nocopy JTF_VARCHAR2_TABLE_300
506     , a5 out nocopy JTF_VARCHAR2_TABLE_300
507     , a6 out nocopy JTF_VARCHAR2_TABLE_300
508     , a7 out nocopy JTF_VARCHAR2_TABLE_300
509     , a8 out nocopy JTF_VARCHAR2_TABLE_100
510     , a9 out nocopy JTF_VARCHAR2_TABLE_100
511     , a10 out nocopy JTF_VARCHAR2_TABLE_100
512     , a11 out nocopy JTF_NUMBER_TABLE
513     , a12 out nocopy JTF_VARCHAR2_TABLE_300
514     , a13 out nocopy JTF_VARCHAR2_TABLE_300
515     , a14 out nocopy JTF_VARCHAR2_TABLE_300
516     , a15 out nocopy JTF_VARCHAR2_TABLE_300
517     , a16 out nocopy JTF_VARCHAR2_TABLE_100
518     , a17 out nocopy JTF_VARCHAR2_TABLE_100
519     , a18 out nocopy JTF_VARCHAR2_TABLE_100
520     , a19 out nocopy JTF_NUMBER_TABLE
521     , a20 out nocopy JTF_VARCHAR2_TABLE_400
522     , a21 out nocopy JTF_NUMBER_TABLE
523     , a22 out nocopy JTF_VARCHAR2_TABLE_400
524     );
525 
526   procedure rosetta_table_copy_in_p11(t out nocopy cn_get_tx_data_pub.attribute_tbl, a0 JTF_VARCHAR2_TABLE_100
527     , a1 JTF_VARCHAR2_TABLE_100
528     );
529   procedure rosetta_table_copy_out_p11(t cn_get_tx_data_pub.attribute_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
530     , a1 out nocopy JTF_VARCHAR2_TABLE_100
531     );
532 
533   procedure get_api_data(p_comm_lines_api_id  NUMBER
534     , p1_a0 out nocopy JTF_NUMBER_TABLE
535     , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
536     , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
537     , p1_a3 out nocopy JTF_NUMBER_TABLE
538     , p1_a4 out nocopy JTF_NUMBER_TABLE
539     , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
540     , p1_a6 out nocopy JTF_DATE_TABLE
541     , p1_a7 out nocopy JTF_DATE_TABLE
542     , p1_a8 out nocopy JTF_NUMBER_TABLE
543     , p1_a9 out nocopy JTF_NUMBER_TABLE
544     , p1_a10 out nocopy JTF_NUMBER_TABLE
545     , p1_a11 out nocopy JTF_NUMBER_TABLE
546     , p1_a12 out nocopy JTF_NUMBER_TABLE
547     , p1_a13 out nocopy JTF_VARCHAR2_TABLE_100
548     , p1_a14 out nocopy JTF_NUMBER_TABLE
549     , p1_a15 out nocopy JTF_VARCHAR2_TABLE_100
550     , p1_a16 out nocopy JTF_VARCHAR2_TABLE_100
551     , p1_a17 out nocopy JTF_VARCHAR2_TABLE_100
552     , p1_a18 out nocopy JTF_VARCHAR2_TABLE_100
553     , p1_a19 out nocopy JTF_VARCHAR2_TABLE_100
554     , p1_a20 out nocopy JTF_VARCHAR2_TABLE_100
555     , p1_a21 out nocopy JTF_VARCHAR2_TABLE_1800
556     , p1_a22 out nocopy JTF_NUMBER_TABLE
557     , p1_a23 out nocopy JTF_NUMBER_TABLE
558     , p1_a24 out nocopy JTF_DATE_TABLE
559     , p1_a25 out nocopy JTF_NUMBER_TABLE
560     , p1_a26 out nocopy JTF_NUMBER_TABLE
561     , p1_a27 out nocopy JTF_DATE_TABLE
562     , p1_a28 out nocopy JTF_VARCHAR2_TABLE_100
563     , p1_a29 out nocopy JTF_VARCHAR2_TABLE_300
564     , p1_a30 out nocopy JTF_VARCHAR2_TABLE_300
565     , p1_a31 out nocopy JTF_VARCHAR2_TABLE_300
566     , p1_a32 out nocopy JTF_VARCHAR2_TABLE_300
567     , p1_a33 out nocopy JTF_VARCHAR2_TABLE_300
568     , p1_a34 out nocopy JTF_VARCHAR2_TABLE_300
569     , p1_a35 out nocopy JTF_VARCHAR2_TABLE_300
570     , p1_a36 out nocopy JTF_VARCHAR2_TABLE_300
571     , p1_a37 out nocopy JTF_VARCHAR2_TABLE_300
572     , p1_a38 out nocopy JTF_VARCHAR2_TABLE_300
573     , p1_a39 out nocopy JTF_VARCHAR2_TABLE_300
574     , p1_a40 out nocopy JTF_VARCHAR2_TABLE_300
575     , p1_a41 out nocopy JTF_VARCHAR2_TABLE_300
576     , p1_a42 out nocopy JTF_VARCHAR2_TABLE_300
577     , p1_a43 out nocopy JTF_VARCHAR2_TABLE_300
578     , p1_a44 out nocopy JTF_VARCHAR2_TABLE_300
579     , p1_a45 out nocopy JTF_VARCHAR2_TABLE_300
580     , p1_a46 out nocopy JTF_VARCHAR2_TABLE_300
581     , p1_a47 out nocopy JTF_VARCHAR2_TABLE_300
582     , p1_a48 out nocopy JTF_VARCHAR2_TABLE_300
583     , p1_a49 out nocopy JTF_VARCHAR2_TABLE_300
584     , p1_a50 out nocopy JTF_VARCHAR2_TABLE_300
585     , p1_a51 out nocopy JTF_VARCHAR2_TABLE_300
586     , p1_a52 out nocopy JTF_VARCHAR2_TABLE_300
587     , p1_a53 out nocopy JTF_VARCHAR2_TABLE_300
588     , p1_a54 out nocopy JTF_VARCHAR2_TABLE_300
589     , p1_a55 out nocopy JTF_VARCHAR2_TABLE_300
590     , p1_a56 out nocopy JTF_VARCHAR2_TABLE_300
591     , p1_a57 out nocopy JTF_VARCHAR2_TABLE_300
592     , p1_a58 out nocopy JTF_VARCHAR2_TABLE_300
593     , p1_a59 out nocopy JTF_VARCHAR2_TABLE_300
594     , p1_a60 out nocopy JTF_VARCHAR2_TABLE_300
595     , p1_a61 out nocopy JTF_VARCHAR2_TABLE_300
596     , p1_a62 out nocopy JTF_VARCHAR2_TABLE_300
597     , p1_a63 out nocopy JTF_VARCHAR2_TABLE_300
598     , p1_a64 out nocopy JTF_VARCHAR2_TABLE_300
599     , p1_a65 out nocopy JTF_VARCHAR2_TABLE_300
600     , p1_a66 out nocopy JTF_VARCHAR2_TABLE_300
601     , p1_a67 out nocopy JTF_VARCHAR2_TABLE_300
602     , p1_a68 out nocopy JTF_VARCHAR2_TABLE_300
603     , p1_a69 out nocopy JTF_VARCHAR2_TABLE_300
604     , p1_a70 out nocopy JTF_VARCHAR2_TABLE_300
605     , p1_a71 out nocopy JTF_VARCHAR2_TABLE_300
606     , p1_a72 out nocopy JTF_VARCHAR2_TABLE_300
607     , p1_a73 out nocopy JTF_VARCHAR2_TABLE_300
608     , p1_a74 out nocopy JTF_VARCHAR2_TABLE_300
609     , p1_a75 out nocopy JTF_VARCHAR2_TABLE_300
610     , p1_a76 out nocopy JTF_VARCHAR2_TABLE_300
611     , p1_a77 out nocopy JTF_VARCHAR2_TABLE_300
612     , p1_a78 out nocopy JTF_VARCHAR2_TABLE_300
613     , p1_a79 out nocopy JTF_VARCHAR2_TABLE_300
614     , p1_a80 out nocopy JTF_VARCHAR2_TABLE_300
615     , p1_a81 out nocopy JTF_VARCHAR2_TABLE_300
616     , p1_a82 out nocopy JTF_VARCHAR2_TABLE_300
617     , p1_a83 out nocopy JTF_VARCHAR2_TABLE_300
618     , p1_a84 out nocopy JTF_VARCHAR2_TABLE_300
619     , p1_a85 out nocopy JTF_VARCHAR2_TABLE_300
620     , p1_a86 out nocopy JTF_VARCHAR2_TABLE_300
621     , p1_a87 out nocopy JTF_VARCHAR2_TABLE_300
622     , p1_a88 out nocopy JTF_VARCHAR2_TABLE_300
623     , p1_a89 out nocopy JTF_VARCHAR2_TABLE_300
624     , p1_a90 out nocopy JTF_VARCHAR2_TABLE_300
625     , p1_a91 out nocopy JTF_VARCHAR2_TABLE_300
626     , p1_a92 out nocopy JTF_VARCHAR2_TABLE_300
627     , p1_a93 out nocopy JTF_VARCHAR2_TABLE_300
628     , p1_a94 out nocopy JTF_VARCHAR2_TABLE_300
629     , p1_a95 out nocopy JTF_VARCHAR2_TABLE_300
630     , p1_a96 out nocopy JTF_VARCHAR2_TABLE_300
631     , p1_a97 out nocopy JTF_VARCHAR2_TABLE_300
632     , p1_a98 out nocopy JTF_VARCHAR2_TABLE_300
633     , p1_a99 out nocopy JTF_VARCHAR2_TABLE_300
634     , p1_a100 out nocopy JTF_VARCHAR2_TABLE_300
635     , p1_a101 out nocopy JTF_VARCHAR2_TABLE_300
636     , p1_a102 out nocopy JTF_VARCHAR2_TABLE_300
637     , p1_a103 out nocopy JTF_VARCHAR2_TABLE_300
638     , p1_a104 out nocopy JTF_VARCHAR2_TABLE_300
639     , p1_a105 out nocopy JTF_VARCHAR2_TABLE_300
640     , p1_a106 out nocopy JTF_VARCHAR2_TABLE_300
641     , p1_a107 out nocopy JTF_VARCHAR2_TABLE_300
642     , p1_a108 out nocopy JTF_VARCHAR2_TABLE_300
643     , p1_a109 out nocopy JTF_VARCHAR2_TABLE_300
644     , p1_a110 out nocopy JTF_VARCHAR2_TABLE_300
645     , p1_a111 out nocopy JTF_VARCHAR2_TABLE_300
646     , p1_a112 out nocopy JTF_VARCHAR2_TABLE_300
647     , p1_a113 out nocopy JTF_VARCHAR2_TABLE_300
648     , p1_a114 out nocopy JTF_VARCHAR2_TABLE_300
649     , p1_a115 out nocopy JTF_VARCHAR2_TABLE_300
650     , p1_a116 out nocopy JTF_VARCHAR2_TABLE_300
651     , p1_a117 out nocopy JTF_VARCHAR2_TABLE_300
652     , p1_a118 out nocopy JTF_VARCHAR2_TABLE_300
653     , p1_a119 out nocopy JTF_VARCHAR2_TABLE_300
654     , p1_a120 out nocopy JTF_VARCHAR2_TABLE_300
655     , p1_a121 out nocopy JTF_VARCHAR2_TABLE_300
656     , p1_a122 out nocopy JTF_VARCHAR2_TABLE_300
657     , p1_a123 out nocopy JTF_VARCHAR2_TABLE_300
658     , p1_a124 out nocopy JTF_VARCHAR2_TABLE_300
659     , p1_a125 out nocopy JTF_VARCHAR2_TABLE_300
660     , p1_a126 out nocopy JTF_VARCHAR2_TABLE_300
661     , p1_a127 out nocopy JTF_VARCHAR2_TABLE_300
662     , p1_a128 out nocopy JTF_VARCHAR2_TABLE_300
663     , p1_a129 out nocopy JTF_NUMBER_TABLE
664     , p1_a130 out nocopy JTF_VARCHAR2_TABLE_100
665     , p1_a131 out nocopy JTF_NUMBER_TABLE
666     , p1_a132 out nocopy JTF_VARCHAR2_TABLE_100
667     , p1_a133 out nocopy JTF_VARCHAR2_TABLE_100
668     , p1_a134 out nocopy JTF_VARCHAR2_TABLE_100
669     , p1_a135 out nocopy JTF_NUMBER_TABLE
670     , p1_a136 out nocopy JTF_NUMBER_TABLE
671     , p1_a137 out nocopy JTF_NUMBER_TABLE
672     , p1_a138 out nocopy JTF_NUMBER_TABLE
673     , p1_a139 out nocopy JTF_VARCHAR2_TABLE_100
674     , p1_a140 out nocopy JTF_NUMBER_TABLE
675     , p1_a141 out nocopy JTF_NUMBER_TABLE
676     , p1_a142 out nocopy JTF_VARCHAR2_TABLE_100
677     , p1_a143 out nocopy JTF_NUMBER_TABLE
678     , p1_a144 out nocopy JTF_NUMBER_TABLE
679     , p1_a145 out nocopy JTF_NUMBER_TABLE
680     , p1_a146 out nocopy JTF_NUMBER_TABLE
681     , p1_a147 out nocopy JTF_DATE_TABLE
682     , p1_a148 out nocopy JTF_NUMBER_TABLE
683     , p1_a149 out nocopy JTF_VARCHAR2_TABLE_100
684     , p1_a150 out nocopy JTF_DATE_TABLE
685     , p1_a151 out nocopy JTF_NUMBER_TABLE
686     , p1_a152 out nocopy JTF_DATE_TABLE
687     , p1_a153 out nocopy JTF_NUMBER_TABLE
688     , p1_a154 out nocopy JTF_NUMBER_TABLE
689     , p1_a155 out nocopy JTF_NUMBER_TABLE
690     , p1_a156 out nocopy JTF_NUMBER_TABLE
691     , p1_a157 out nocopy JTF_NUMBER_TABLE
692     , p1_a158 out nocopy JTF_NUMBER_TABLE
693     , p1_a159 out nocopy JTF_VARCHAR2_TABLE_100
694     , p1_a160 out nocopy JTF_VARCHAR2_TABLE_100
695     , p1_a161 out nocopy JTF_VARCHAR2_TABLE_100
696     , p1_a162 out nocopy JTF_VARCHAR2_TABLE_100
697     , p1_a163 out nocopy JTF_DATE_TABLE
698     , p1_a164 out nocopy JTF_VARCHAR2_TABLE_100
699     , p1_a165 out nocopy JTF_VARCHAR2_TABLE_100
700     , p1_a166 out nocopy JTF_VARCHAR2_TABLE_100
701     , p1_a167 out nocopy JTF_VARCHAR2_TABLE_2000
702     , p1_a168 out nocopy JTF_VARCHAR2_TABLE_100
703     , p1_a169 out nocopy JTF_VARCHAR2_TABLE_100
704     , p1_a170 out nocopy JTF_NUMBER_TABLE
705     , p1_a171 out nocopy JTF_NUMBER_TABLE
706     , p1_a172 out nocopy JTF_NUMBER_TABLE
707     , p1_a173 out nocopy JTF_VARCHAR2_TABLE_100
708     , p1_a174 out nocopy JTF_NUMBER_TABLE
709     , p1_a175 out nocopy JTF_NUMBER_TABLE
710     , p1_a176 out nocopy JTF_VARCHAR2_TABLE_100
711     , p1_a177 out nocopy JTF_NUMBER_TABLE
712     , p1_a178 out nocopy JTF_VARCHAR2_TABLE_100
713     , p1_a179 out nocopy JTF_VARCHAR2_TABLE_100
714     , p1_a180 out nocopy JTF_VARCHAR2_TABLE_100
715     , p1_a181 out nocopy JTF_VARCHAR2_TABLE_100
716     , p1_a182 out nocopy JTF_VARCHAR2_TABLE_100
717     , p1_a183 out nocopy JTF_NUMBER_TABLE
718     , p1_a184 out nocopy JTF_NUMBER_TABLE
719     , p1_a185 out nocopy JTF_NUMBER_TABLE
720     , p1_a186 out nocopy JTF_NUMBER_TABLE
721     , p1_a187 out nocopy JTF_NUMBER_TABLE
722     , p1_a188 out nocopy JTF_NUMBER_TABLE
723     , p1_a189 out nocopy JTF_VARCHAR2_TABLE_100
724     , p1_a190 out nocopy JTF_VARCHAR2_TABLE_2000
725   );
726   procedure get_adj(p_api_version  NUMBER
727     , p_init_msg_list  VARCHAR2
728     , p_validation_level  VARCHAR2
729     , p_org_id  NUMBER
730     , p_salesrep_id  NUMBER
731     , p_pr_date_to  DATE
732     , p_pr_date_from  DATE
733     , p_calc_status  VARCHAR2
734     , p_adj_status  VARCHAR2
735     , p_load_status  VARCHAR2
736     , p_invoice_num  VARCHAR2
737     , p_order_num  NUMBER
738     , p12_a0  NUMBER
739     , p12_a1  VARCHAR2
740     , p12_a2  VARCHAR2
741     , p12_a3  NUMBER
742     , p12_a4  NUMBER
743     , p12_a5  VARCHAR2
744     , p12_a6  DATE
745     , p12_a7  DATE
746     , p12_a8  NUMBER
747     , p12_a9  NUMBER
748     , p12_a10  NUMBER
749     , p12_a11  NUMBER
750     , p12_a12  NUMBER
751     , p12_a13  VARCHAR2
752     , p12_a14  NUMBER
753     , p12_a15  VARCHAR2
754     , p12_a16  VARCHAR2
755     , p12_a17  VARCHAR2
756     , p12_a18  VARCHAR2
757     , p12_a19  VARCHAR2
758     , p12_a20  VARCHAR2
759     , p12_a21  VARCHAR2
760     , p12_a22  NUMBER
761     , p12_a23  NUMBER
762     , p12_a24  DATE
763     , p12_a25  NUMBER
764     , p12_a26  NUMBER
765     , p12_a27  DATE
766     , p12_a28  VARCHAR2
767     , p12_a29  VARCHAR2
768     , p12_a30  VARCHAR2
769     , p12_a31  VARCHAR2
770     , p12_a32  VARCHAR2
771     , p12_a33  VARCHAR2
772     , p12_a34  VARCHAR2
773     , p12_a35  VARCHAR2
774     , p12_a36  VARCHAR2
775     , p12_a37  VARCHAR2
776     , p12_a38  VARCHAR2
777     , p12_a39  VARCHAR2
778     , p12_a40  VARCHAR2
779     , p12_a41  VARCHAR2
780     , p12_a42  VARCHAR2
781     , p12_a43  VARCHAR2
782     , p12_a44  VARCHAR2
783     , p12_a45  VARCHAR2
784     , p12_a46  VARCHAR2
785     , p12_a47  VARCHAR2
786     , p12_a48  VARCHAR2
787     , p12_a49  VARCHAR2
788     , p12_a50  VARCHAR2
789     , p12_a51  VARCHAR2
790     , p12_a52  VARCHAR2
791     , p12_a53  VARCHAR2
792     , p12_a54  VARCHAR2
793     , p12_a55  VARCHAR2
794     , p12_a56  VARCHAR2
795     , p12_a57  VARCHAR2
796     , p12_a58  VARCHAR2
797     , p12_a59  VARCHAR2
798     , p12_a60  VARCHAR2
799     , p12_a61  VARCHAR2
800     , p12_a62  VARCHAR2
801     , p12_a63  VARCHAR2
802     , p12_a64  VARCHAR2
803     , p12_a65  VARCHAR2
804     , p12_a66  VARCHAR2
805     , p12_a67  VARCHAR2
806     , p12_a68  VARCHAR2
807     , p12_a69  VARCHAR2
808     , p12_a70  VARCHAR2
809     , p12_a71  VARCHAR2
810     , p12_a72  VARCHAR2
811     , p12_a73  VARCHAR2
812     , p12_a74  VARCHAR2
813     , p12_a75  VARCHAR2
814     , p12_a76  VARCHAR2
815     , p12_a77  VARCHAR2
816     , p12_a78  VARCHAR2
817     , p12_a79  VARCHAR2
818     , p12_a80  VARCHAR2
819     , p12_a81  VARCHAR2
820     , p12_a82  VARCHAR2
821     , p12_a83  VARCHAR2
822     , p12_a84  VARCHAR2
823     , p12_a85  VARCHAR2
824     , p12_a86  VARCHAR2
825     , p12_a87  VARCHAR2
826     , p12_a88  VARCHAR2
827     , p12_a89  VARCHAR2
828     , p12_a90  VARCHAR2
829     , p12_a91  VARCHAR2
830     , p12_a92  VARCHAR2
831     , p12_a93  VARCHAR2
832     , p12_a94  VARCHAR2
833     , p12_a95  VARCHAR2
834     , p12_a96  VARCHAR2
835     , p12_a97  VARCHAR2
836     , p12_a98  VARCHAR2
837     , p12_a99  VARCHAR2
838     , p12_a100  VARCHAR2
839     , p12_a101  VARCHAR2
840     , p12_a102  VARCHAR2
841     , p12_a103  VARCHAR2
842     , p12_a104  VARCHAR2
843     , p12_a105  VARCHAR2
844     , p12_a106  VARCHAR2
845     , p12_a107  VARCHAR2
846     , p12_a108  VARCHAR2
847     , p12_a109  VARCHAR2
848     , p12_a110  VARCHAR2
849     , p12_a111  VARCHAR2
850     , p12_a112  VARCHAR2
851     , p12_a113  VARCHAR2
852     , p12_a114  VARCHAR2
853     , p12_a115  VARCHAR2
854     , p12_a116  VARCHAR2
855     , p12_a117  VARCHAR2
856     , p12_a118  VARCHAR2
857     , p12_a119  VARCHAR2
858     , p12_a120  VARCHAR2
859     , p12_a121  VARCHAR2
860     , p12_a122  VARCHAR2
861     , p12_a123  VARCHAR2
862     , p12_a124  VARCHAR2
863     , p12_a125  VARCHAR2
864     , p12_a126  VARCHAR2
865     , p12_a127  VARCHAR2
866     , p12_a128  VARCHAR2
867     , p12_a129  NUMBER
868     , p12_a130  VARCHAR2
869     , p12_a131  NUMBER
870     , p12_a132  VARCHAR2
871     , p12_a133  VARCHAR2
872     , p12_a134  VARCHAR2
873     , p12_a135  NUMBER
874     , p12_a136  NUMBER
875     , p12_a137  NUMBER
876     , p12_a138  NUMBER
877     , p12_a139  VARCHAR2
878     , p12_a140  NUMBER
879     , p12_a141  NUMBER
880     , p12_a142  VARCHAR2
881     , p12_a143  NUMBER
882     , p12_a144  NUMBER
883     , p12_a145  NUMBER
884     , p12_a146  NUMBER
885     , p12_a147  DATE
886     , p12_a148  NUMBER
887     , p12_a149  VARCHAR2
888     , p12_a150  DATE
889     , p12_a151  NUMBER
890     , p12_a152  DATE
891     , p12_a153  NUMBER
892     , p12_a154  NUMBER
893     , p12_a155  NUMBER
894     , p12_a156  NUMBER
895     , p12_a157  NUMBER
896     , p12_a158  NUMBER
897     , p12_a159  VARCHAR2
898     , p12_a160  VARCHAR2
899     , p12_a161  VARCHAR2
900     , p12_a162  VARCHAR2
901     , p12_a163  DATE
902     , p12_a164  VARCHAR2
903     , p12_a165  VARCHAR2
904     , p12_a166  VARCHAR2
905     , p12_a167  VARCHAR2
906     , p12_a168  VARCHAR2
907     , p12_a169  VARCHAR2
908     , p12_a170  NUMBER
909     , p12_a171  NUMBER
910     , p12_a172  NUMBER
911     , p12_a173  VARCHAR2
912     , p12_a174  NUMBER
913     , p12_a175  NUMBER
914     , p12_a176  VARCHAR2
915     , p12_a177  NUMBER
916     , p12_a178  VARCHAR2
917     , p12_a179  VARCHAR2
918     , p12_a180  VARCHAR2
919     , p12_a181  VARCHAR2
920     , p12_a182  VARCHAR2
921     , p12_a183  NUMBER
922     , p12_a184  NUMBER
923     , p12_a185  NUMBER
924     , p12_a186  NUMBER
925     , p12_a187  NUMBER
926     , p12_a188  NUMBER
927     , p12_a189  VARCHAR2
928     , p12_a190  VARCHAR2
929     , p_first  NUMBER
930     , p_last  NUMBER
931     , x_return_status out nocopy  VARCHAR2
932     , x_msg_count out nocopy  NUMBER
933     , x_msg_data out nocopy  VARCHAR2
934     , x_loading_status out nocopy  VARCHAR2
935     , p19_a0 out nocopy JTF_NUMBER_TABLE
936     , p19_a1 out nocopy JTF_VARCHAR2_TABLE_100
937     , p19_a2 out nocopy JTF_VARCHAR2_TABLE_400
938     , p19_a3 out nocopy JTF_NUMBER_TABLE
939     , p19_a4 out nocopy JTF_NUMBER_TABLE
940     , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
941     , p19_a6 out nocopy JTF_DATE_TABLE
942     , p19_a7 out nocopy JTF_DATE_TABLE
943     , p19_a8 out nocopy JTF_NUMBER_TABLE
944     , p19_a9 out nocopy JTF_NUMBER_TABLE
945     , p19_a10 out nocopy JTF_NUMBER_TABLE
946     , p19_a11 out nocopy JTF_NUMBER_TABLE
947     , p19_a12 out nocopy JTF_NUMBER_TABLE
948     , p19_a13 out nocopy JTF_VARCHAR2_TABLE_100
949     , p19_a14 out nocopy JTF_NUMBER_TABLE
950     , p19_a15 out nocopy JTF_VARCHAR2_TABLE_100
951     , p19_a16 out nocopy JTF_VARCHAR2_TABLE_100
952     , p19_a17 out nocopy JTF_VARCHAR2_TABLE_100
953     , p19_a18 out nocopy JTF_VARCHAR2_TABLE_100
954     , p19_a19 out nocopy JTF_VARCHAR2_TABLE_100
955     , p19_a20 out nocopy JTF_VARCHAR2_TABLE_100
956     , p19_a21 out nocopy JTF_VARCHAR2_TABLE_1800
957     , p19_a22 out nocopy JTF_NUMBER_TABLE
958     , p19_a23 out nocopy JTF_NUMBER_TABLE
959     , p19_a24 out nocopy JTF_DATE_TABLE
960     , p19_a25 out nocopy JTF_NUMBER_TABLE
961     , p19_a26 out nocopy JTF_NUMBER_TABLE
962     , p19_a27 out nocopy JTF_DATE_TABLE
963     , p19_a28 out nocopy JTF_VARCHAR2_TABLE_100
964     , p19_a29 out nocopy JTF_VARCHAR2_TABLE_300
965     , p19_a30 out nocopy JTF_VARCHAR2_TABLE_300
966     , p19_a31 out nocopy JTF_VARCHAR2_TABLE_300
967     , p19_a32 out nocopy JTF_VARCHAR2_TABLE_300
968     , p19_a33 out nocopy JTF_VARCHAR2_TABLE_300
969     , p19_a34 out nocopy JTF_VARCHAR2_TABLE_300
970     , p19_a35 out nocopy JTF_VARCHAR2_TABLE_300
971     , p19_a36 out nocopy JTF_VARCHAR2_TABLE_300
972     , p19_a37 out nocopy JTF_VARCHAR2_TABLE_300
973     , p19_a38 out nocopy JTF_VARCHAR2_TABLE_300
974     , p19_a39 out nocopy JTF_VARCHAR2_TABLE_300
975     , p19_a40 out nocopy JTF_VARCHAR2_TABLE_300
976     , p19_a41 out nocopy JTF_VARCHAR2_TABLE_300
977     , p19_a42 out nocopy JTF_VARCHAR2_TABLE_300
978     , p19_a43 out nocopy JTF_VARCHAR2_TABLE_300
979     , p19_a44 out nocopy JTF_VARCHAR2_TABLE_300
980     , p19_a45 out nocopy JTF_VARCHAR2_TABLE_300
981     , p19_a46 out nocopy JTF_VARCHAR2_TABLE_300
982     , p19_a47 out nocopy JTF_VARCHAR2_TABLE_300
983     , p19_a48 out nocopy JTF_VARCHAR2_TABLE_300
984     , p19_a49 out nocopy JTF_VARCHAR2_TABLE_300
985     , p19_a50 out nocopy JTF_VARCHAR2_TABLE_300
986     , p19_a51 out nocopy JTF_VARCHAR2_TABLE_300
987     , p19_a52 out nocopy JTF_VARCHAR2_TABLE_300
988     , p19_a53 out nocopy JTF_VARCHAR2_TABLE_300
989     , p19_a54 out nocopy JTF_VARCHAR2_TABLE_300
990     , p19_a55 out nocopy JTF_VARCHAR2_TABLE_300
991     , p19_a56 out nocopy JTF_VARCHAR2_TABLE_300
992     , p19_a57 out nocopy JTF_VARCHAR2_TABLE_300
993     , p19_a58 out nocopy JTF_VARCHAR2_TABLE_300
994     , p19_a59 out nocopy JTF_VARCHAR2_TABLE_300
995     , p19_a60 out nocopy JTF_VARCHAR2_TABLE_300
996     , p19_a61 out nocopy JTF_VARCHAR2_TABLE_300
997     , p19_a62 out nocopy JTF_VARCHAR2_TABLE_300
998     , p19_a63 out nocopy JTF_VARCHAR2_TABLE_300
999     , p19_a64 out nocopy JTF_VARCHAR2_TABLE_300
1000     , p19_a65 out nocopy JTF_VARCHAR2_TABLE_300
1001     , p19_a66 out nocopy JTF_VARCHAR2_TABLE_300
1002     , p19_a67 out nocopy JTF_VARCHAR2_TABLE_300
1003     , p19_a68 out nocopy JTF_VARCHAR2_TABLE_300
1004     , p19_a69 out nocopy JTF_VARCHAR2_TABLE_300
1005     , p19_a70 out nocopy JTF_VARCHAR2_TABLE_300
1006     , p19_a71 out nocopy JTF_VARCHAR2_TABLE_300
1007     , p19_a72 out nocopy JTF_VARCHAR2_TABLE_300
1008     , p19_a73 out nocopy JTF_VARCHAR2_TABLE_300
1009     , p19_a74 out nocopy JTF_VARCHAR2_TABLE_300
1010     , p19_a75 out nocopy JTF_VARCHAR2_TABLE_300
1011     , p19_a76 out nocopy JTF_VARCHAR2_TABLE_300
1012     , p19_a77 out nocopy JTF_VARCHAR2_TABLE_300
1013     , p19_a78 out nocopy JTF_VARCHAR2_TABLE_300
1014     , p19_a79 out nocopy JTF_VARCHAR2_TABLE_300
1015     , p19_a80 out nocopy JTF_VARCHAR2_TABLE_300
1016     , p19_a81 out nocopy JTF_VARCHAR2_TABLE_300
1017     , p19_a82 out nocopy JTF_VARCHAR2_TABLE_300
1018     , p19_a83 out nocopy JTF_VARCHAR2_TABLE_300
1019     , p19_a84 out nocopy JTF_VARCHAR2_TABLE_300
1020     , p19_a85 out nocopy JTF_VARCHAR2_TABLE_300
1021     , p19_a86 out nocopy JTF_VARCHAR2_TABLE_300
1022     , p19_a87 out nocopy JTF_VARCHAR2_TABLE_300
1023     , p19_a88 out nocopy JTF_VARCHAR2_TABLE_300
1024     , p19_a89 out nocopy JTF_VARCHAR2_TABLE_300
1025     , p19_a90 out nocopy JTF_VARCHAR2_TABLE_300
1026     , p19_a91 out nocopy JTF_VARCHAR2_TABLE_300
1027     , p19_a92 out nocopy JTF_VARCHAR2_TABLE_300
1028     , p19_a93 out nocopy JTF_VARCHAR2_TABLE_300
1029     , p19_a94 out nocopy JTF_VARCHAR2_TABLE_300
1030     , p19_a95 out nocopy JTF_VARCHAR2_TABLE_300
1031     , p19_a96 out nocopy JTF_VARCHAR2_TABLE_300
1032     , p19_a97 out nocopy JTF_VARCHAR2_TABLE_300
1033     , p19_a98 out nocopy JTF_VARCHAR2_TABLE_300
1034     , p19_a99 out nocopy JTF_VARCHAR2_TABLE_300
1035     , p19_a100 out nocopy JTF_VARCHAR2_TABLE_300
1036     , p19_a101 out nocopy JTF_VARCHAR2_TABLE_300
1037     , p19_a102 out nocopy JTF_VARCHAR2_TABLE_300
1038     , p19_a103 out nocopy JTF_VARCHAR2_TABLE_300
1039     , p19_a104 out nocopy JTF_VARCHAR2_TABLE_300
1040     , p19_a105 out nocopy JTF_VARCHAR2_TABLE_300
1041     , p19_a106 out nocopy JTF_VARCHAR2_TABLE_300
1042     , p19_a107 out nocopy JTF_VARCHAR2_TABLE_300
1043     , p19_a108 out nocopy JTF_VARCHAR2_TABLE_300
1044     , p19_a109 out nocopy JTF_VARCHAR2_TABLE_300
1045     , p19_a110 out nocopy JTF_VARCHAR2_TABLE_300
1046     , p19_a111 out nocopy JTF_VARCHAR2_TABLE_300
1047     , p19_a112 out nocopy JTF_VARCHAR2_TABLE_300
1048     , p19_a113 out nocopy JTF_VARCHAR2_TABLE_300
1049     , p19_a114 out nocopy JTF_VARCHAR2_TABLE_300
1050     , p19_a115 out nocopy JTF_VARCHAR2_TABLE_300
1051     , p19_a116 out nocopy JTF_VARCHAR2_TABLE_300
1052     , p19_a117 out nocopy JTF_VARCHAR2_TABLE_300
1053     , p19_a118 out nocopy JTF_VARCHAR2_TABLE_300
1054     , p19_a119 out nocopy JTF_VARCHAR2_TABLE_300
1055     , p19_a120 out nocopy JTF_VARCHAR2_TABLE_300
1056     , p19_a121 out nocopy JTF_VARCHAR2_TABLE_300
1057     , p19_a122 out nocopy JTF_VARCHAR2_TABLE_300
1058     , p19_a123 out nocopy JTF_VARCHAR2_TABLE_300
1059     , p19_a124 out nocopy JTF_VARCHAR2_TABLE_300
1060     , p19_a125 out nocopy JTF_VARCHAR2_TABLE_300
1061     , p19_a126 out nocopy JTF_VARCHAR2_TABLE_300
1062     , p19_a127 out nocopy JTF_VARCHAR2_TABLE_300
1063     , p19_a128 out nocopy JTF_VARCHAR2_TABLE_300
1064     , p19_a129 out nocopy JTF_NUMBER_TABLE
1065     , p19_a130 out nocopy JTF_VARCHAR2_TABLE_100
1066     , p19_a131 out nocopy JTF_NUMBER_TABLE
1067     , p19_a132 out nocopy JTF_VARCHAR2_TABLE_100
1068     , p19_a133 out nocopy JTF_VARCHAR2_TABLE_100
1069     , p19_a134 out nocopy JTF_VARCHAR2_TABLE_100
1070     , p19_a135 out nocopy JTF_NUMBER_TABLE
1071     , p19_a136 out nocopy JTF_NUMBER_TABLE
1072     , p19_a137 out nocopy JTF_NUMBER_TABLE
1073     , p19_a138 out nocopy JTF_NUMBER_TABLE
1074     , p19_a139 out nocopy JTF_VARCHAR2_TABLE_100
1075     , p19_a140 out nocopy JTF_NUMBER_TABLE
1076     , p19_a141 out nocopy JTF_NUMBER_TABLE
1077     , p19_a142 out nocopy JTF_VARCHAR2_TABLE_100
1078     , p19_a143 out nocopy JTF_NUMBER_TABLE
1079     , p19_a144 out nocopy JTF_NUMBER_TABLE
1080     , p19_a145 out nocopy JTF_NUMBER_TABLE
1081     , p19_a146 out nocopy JTF_NUMBER_TABLE
1082     , p19_a147 out nocopy JTF_DATE_TABLE
1083     , p19_a148 out nocopy JTF_NUMBER_TABLE
1084     , p19_a149 out nocopy JTF_VARCHAR2_TABLE_100
1085     , p19_a150 out nocopy JTF_DATE_TABLE
1086     , p19_a151 out nocopy JTF_NUMBER_TABLE
1087     , p19_a152 out nocopy JTF_DATE_TABLE
1088     , p19_a153 out nocopy JTF_NUMBER_TABLE
1089     , p19_a154 out nocopy JTF_NUMBER_TABLE
1090     , p19_a155 out nocopy JTF_NUMBER_TABLE
1091     , p19_a156 out nocopy JTF_NUMBER_TABLE
1092     , p19_a157 out nocopy JTF_NUMBER_TABLE
1093     , p19_a158 out nocopy JTF_NUMBER_TABLE
1094     , p19_a159 out nocopy JTF_VARCHAR2_TABLE_100
1095     , p19_a160 out nocopy JTF_VARCHAR2_TABLE_100
1096     , p19_a161 out nocopy JTF_VARCHAR2_TABLE_100
1097     , p19_a162 out nocopy JTF_VARCHAR2_TABLE_100
1098     , p19_a163 out nocopy JTF_DATE_TABLE
1099     , p19_a164 out nocopy JTF_VARCHAR2_TABLE_100
1100     , p19_a165 out nocopy JTF_VARCHAR2_TABLE_100
1101     , p19_a166 out nocopy JTF_VARCHAR2_TABLE_100
1102     , p19_a167 out nocopy JTF_VARCHAR2_TABLE_2000
1103     , p19_a168 out nocopy JTF_VARCHAR2_TABLE_100
1104     , p19_a169 out nocopy JTF_VARCHAR2_TABLE_100
1105     , p19_a170 out nocopy JTF_NUMBER_TABLE
1106     , p19_a171 out nocopy JTF_NUMBER_TABLE
1107     , p19_a172 out nocopy JTF_NUMBER_TABLE
1108     , p19_a173 out nocopy JTF_VARCHAR2_TABLE_100
1109     , p19_a174 out nocopy JTF_NUMBER_TABLE
1110     , p19_a175 out nocopy JTF_NUMBER_TABLE
1111     , p19_a176 out nocopy JTF_VARCHAR2_TABLE_100
1112     , p19_a177 out nocopy JTF_NUMBER_TABLE
1113     , p19_a178 out nocopy JTF_VARCHAR2_TABLE_100
1114     , p19_a179 out nocopy JTF_VARCHAR2_TABLE_100
1115     , p19_a180 out nocopy JTF_VARCHAR2_TABLE_100
1116     , p19_a181 out nocopy JTF_VARCHAR2_TABLE_100
1117     , p19_a182 out nocopy JTF_VARCHAR2_TABLE_100
1118     , p19_a183 out nocopy JTF_NUMBER_TABLE
1119     , p19_a184 out nocopy JTF_NUMBER_TABLE
1120     , p19_a185 out nocopy JTF_NUMBER_TABLE
1121     , p19_a186 out nocopy JTF_NUMBER_TABLE
1122     , p19_a187 out nocopy JTF_NUMBER_TABLE
1123     , p19_a188 out nocopy JTF_NUMBER_TABLE
1124     , p19_a189 out nocopy JTF_VARCHAR2_TABLE_100
1125     , p19_a190 out nocopy JTF_VARCHAR2_TABLE_2000
1126     , x_adj_count out nocopy  NUMBER
1127     , x_valid_trx_count out nocopy  NUMBER
1128   );
1129   procedure get_split_data(p_api_version  NUMBER
1130     , p_init_msg_list  VARCHAR2
1131     , p_validation_level  VARCHAR2
1132     , p_comm_lines_api_id  NUMBER
1133     , p_load_status  VARCHAR2
1134     , x_return_status out nocopy  VARCHAR2
1135     , x_msg_count out nocopy  NUMBER
1136     , x_msg_data out nocopy  VARCHAR2
1137     , x_loading_status out nocopy  VARCHAR2
1138     , p9_a0 out nocopy JTF_NUMBER_TABLE
1139     , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1140     , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
1141     , p9_a3 out nocopy JTF_NUMBER_TABLE
1142     , p9_a4 out nocopy JTF_NUMBER_TABLE
1143     , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
1144     , p9_a6 out nocopy JTF_DATE_TABLE
1145     , p9_a7 out nocopy JTF_DATE_TABLE
1146     , p9_a8 out nocopy JTF_NUMBER_TABLE
1147     , p9_a9 out nocopy JTF_NUMBER_TABLE
1148     , p9_a10 out nocopy JTF_NUMBER_TABLE
1149     , p9_a11 out nocopy JTF_NUMBER_TABLE
1150     , p9_a12 out nocopy JTF_NUMBER_TABLE
1151     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
1152     , p9_a14 out nocopy JTF_NUMBER_TABLE
1153     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
1154     , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
1155     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
1156     , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
1157     , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
1158     , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
1159     , p9_a21 out nocopy JTF_VARCHAR2_TABLE_1800
1160     , p9_a22 out nocopy JTF_NUMBER_TABLE
1161     , p9_a23 out nocopy JTF_NUMBER_TABLE
1162     , p9_a24 out nocopy JTF_DATE_TABLE
1163     , p9_a25 out nocopy JTF_NUMBER_TABLE
1164     , p9_a26 out nocopy JTF_NUMBER_TABLE
1165     , p9_a27 out nocopy JTF_DATE_TABLE
1166     , p9_a28 out nocopy JTF_VARCHAR2_TABLE_100
1167     , p9_a29 out nocopy JTF_VARCHAR2_TABLE_300
1168     , p9_a30 out nocopy JTF_VARCHAR2_TABLE_300
1169     , p9_a31 out nocopy JTF_VARCHAR2_TABLE_300
1170     , p9_a32 out nocopy JTF_VARCHAR2_TABLE_300
1171     , p9_a33 out nocopy JTF_VARCHAR2_TABLE_300
1172     , p9_a34 out nocopy JTF_VARCHAR2_TABLE_300
1173     , p9_a35 out nocopy JTF_VARCHAR2_TABLE_300
1174     , p9_a36 out nocopy JTF_VARCHAR2_TABLE_300
1175     , p9_a37 out nocopy JTF_VARCHAR2_TABLE_300
1176     , p9_a38 out nocopy JTF_VARCHAR2_TABLE_300
1177     , p9_a39 out nocopy JTF_VARCHAR2_TABLE_300
1178     , p9_a40 out nocopy JTF_VARCHAR2_TABLE_300
1179     , p9_a41 out nocopy JTF_VARCHAR2_TABLE_300
1180     , p9_a42 out nocopy JTF_VARCHAR2_TABLE_300
1181     , p9_a43 out nocopy JTF_VARCHAR2_TABLE_300
1182     , p9_a44 out nocopy JTF_VARCHAR2_TABLE_300
1183     , p9_a45 out nocopy JTF_VARCHAR2_TABLE_300
1184     , p9_a46 out nocopy JTF_VARCHAR2_TABLE_300
1185     , p9_a47 out nocopy JTF_VARCHAR2_TABLE_300
1186     , p9_a48 out nocopy JTF_VARCHAR2_TABLE_300
1187     , p9_a49 out nocopy JTF_VARCHAR2_TABLE_300
1188     , p9_a50 out nocopy JTF_VARCHAR2_TABLE_300
1189     , p9_a51 out nocopy JTF_VARCHAR2_TABLE_300
1190     , p9_a52 out nocopy JTF_VARCHAR2_TABLE_300
1191     , p9_a53 out nocopy JTF_VARCHAR2_TABLE_300
1192     , p9_a54 out nocopy JTF_VARCHAR2_TABLE_300
1193     , p9_a55 out nocopy JTF_VARCHAR2_TABLE_300
1194     , p9_a56 out nocopy JTF_VARCHAR2_TABLE_300
1195     , p9_a57 out nocopy JTF_VARCHAR2_TABLE_300
1196     , p9_a58 out nocopy JTF_VARCHAR2_TABLE_300
1197     , p9_a59 out nocopy JTF_VARCHAR2_TABLE_300
1198     , p9_a60 out nocopy JTF_VARCHAR2_TABLE_300
1199     , p9_a61 out nocopy JTF_VARCHAR2_TABLE_300
1200     , p9_a62 out nocopy JTF_VARCHAR2_TABLE_300
1201     , p9_a63 out nocopy JTF_VARCHAR2_TABLE_300
1202     , p9_a64 out nocopy JTF_VARCHAR2_TABLE_300
1203     , p9_a65 out nocopy JTF_VARCHAR2_TABLE_300
1204     , p9_a66 out nocopy JTF_VARCHAR2_TABLE_300
1205     , p9_a67 out nocopy JTF_VARCHAR2_TABLE_300
1206     , p9_a68 out nocopy JTF_VARCHAR2_TABLE_300
1207     , p9_a69 out nocopy JTF_VARCHAR2_TABLE_300
1208     , p9_a70 out nocopy JTF_VARCHAR2_TABLE_300
1209     , p9_a71 out nocopy JTF_VARCHAR2_TABLE_300
1210     , p9_a72 out nocopy JTF_VARCHAR2_TABLE_300
1211     , p9_a73 out nocopy JTF_VARCHAR2_TABLE_300
1212     , p9_a74 out nocopy JTF_VARCHAR2_TABLE_300
1213     , p9_a75 out nocopy JTF_VARCHAR2_TABLE_300
1214     , p9_a76 out nocopy JTF_VARCHAR2_TABLE_300
1215     , p9_a77 out nocopy JTF_VARCHAR2_TABLE_300
1216     , p9_a78 out nocopy JTF_VARCHAR2_TABLE_300
1217     , p9_a79 out nocopy JTF_VARCHAR2_TABLE_300
1218     , p9_a80 out nocopy JTF_VARCHAR2_TABLE_300
1219     , p9_a81 out nocopy JTF_VARCHAR2_TABLE_300
1220     , p9_a82 out nocopy JTF_VARCHAR2_TABLE_300
1221     , p9_a83 out nocopy JTF_VARCHAR2_TABLE_300
1222     , p9_a84 out nocopy JTF_VARCHAR2_TABLE_300
1223     , p9_a85 out nocopy JTF_VARCHAR2_TABLE_300
1224     , p9_a86 out nocopy JTF_VARCHAR2_TABLE_300
1225     , p9_a87 out nocopy JTF_VARCHAR2_TABLE_300
1226     , p9_a88 out nocopy JTF_VARCHAR2_TABLE_300
1227     , p9_a89 out nocopy JTF_VARCHAR2_TABLE_300
1228     , p9_a90 out nocopy JTF_VARCHAR2_TABLE_300
1229     , p9_a91 out nocopy JTF_VARCHAR2_TABLE_300
1230     , p9_a92 out nocopy JTF_VARCHAR2_TABLE_300
1231     , p9_a93 out nocopy JTF_VARCHAR2_TABLE_300
1232     , p9_a94 out nocopy JTF_VARCHAR2_TABLE_300
1233     , p9_a95 out nocopy JTF_VARCHAR2_TABLE_300
1234     , p9_a96 out nocopy JTF_VARCHAR2_TABLE_300
1235     , p9_a97 out nocopy JTF_VARCHAR2_TABLE_300
1236     , p9_a98 out nocopy JTF_VARCHAR2_TABLE_300
1237     , p9_a99 out nocopy JTF_VARCHAR2_TABLE_300
1238     , p9_a100 out nocopy JTF_VARCHAR2_TABLE_300
1239     , p9_a101 out nocopy JTF_VARCHAR2_TABLE_300
1240     , p9_a102 out nocopy JTF_VARCHAR2_TABLE_300
1241     , p9_a103 out nocopy JTF_VARCHAR2_TABLE_300
1242     , p9_a104 out nocopy JTF_VARCHAR2_TABLE_300
1243     , p9_a105 out nocopy JTF_VARCHAR2_TABLE_300
1244     , p9_a106 out nocopy JTF_VARCHAR2_TABLE_300
1245     , p9_a107 out nocopy JTF_VARCHAR2_TABLE_300
1246     , p9_a108 out nocopy JTF_VARCHAR2_TABLE_300
1247     , p9_a109 out nocopy JTF_VARCHAR2_TABLE_300
1248     , p9_a110 out nocopy JTF_VARCHAR2_TABLE_300
1249     , p9_a111 out nocopy JTF_VARCHAR2_TABLE_300
1250     , p9_a112 out nocopy JTF_VARCHAR2_TABLE_300
1251     , p9_a113 out nocopy JTF_VARCHAR2_TABLE_300
1252     , p9_a114 out nocopy JTF_VARCHAR2_TABLE_300
1253     , p9_a115 out nocopy JTF_VARCHAR2_TABLE_300
1254     , p9_a116 out nocopy JTF_VARCHAR2_TABLE_300
1255     , p9_a117 out nocopy JTF_VARCHAR2_TABLE_300
1256     , p9_a118 out nocopy JTF_VARCHAR2_TABLE_300
1257     , p9_a119 out nocopy JTF_VARCHAR2_TABLE_300
1258     , p9_a120 out nocopy JTF_VARCHAR2_TABLE_300
1259     , p9_a121 out nocopy JTF_VARCHAR2_TABLE_300
1260     , p9_a122 out nocopy JTF_VARCHAR2_TABLE_300
1261     , p9_a123 out nocopy JTF_VARCHAR2_TABLE_300
1262     , p9_a124 out nocopy JTF_VARCHAR2_TABLE_300
1263     , p9_a125 out nocopy JTF_VARCHAR2_TABLE_300
1264     , p9_a126 out nocopy JTF_VARCHAR2_TABLE_300
1265     , p9_a127 out nocopy JTF_VARCHAR2_TABLE_300
1266     , p9_a128 out nocopy JTF_VARCHAR2_TABLE_300
1267     , p9_a129 out nocopy JTF_NUMBER_TABLE
1268     , p9_a130 out nocopy JTF_VARCHAR2_TABLE_100
1269     , p9_a131 out nocopy JTF_NUMBER_TABLE
1270     , p9_a132 out nocopy JTF_VARCHAR2_TABLE_100
1271     , p9_a133 out nocopy JTF_VARCHAR2_TABLE_100
1272     , p9_a134 out nocopy JTF_VARCHAR2_TABLE_100
1273     , p9_a135 out nocopy JTF_NUMBER_TABLE
1274     , p9_a136 out nocopy JTF_NUMBER_TABLE
1275     , p9_a137 out nocopy JTF_NUMBER_TABLE
1276     , p9_a138 out nocopy JTF_NUMBER_TABLE
1277     , p9_a139 out nocopy JTF_VARCHAR2_TABLE_100
1278     , p9_a140 out nocopy JTF_NUMBER_TABLE
1279     , p9_a141 out nocopy JTF_NUMBER_TABLE
1280     , p9_a142 out nocopy JTF_VARCHAR2_TABLE_100
1281     , p9_a143 out nocopy JTF_NUMBER_TABLE
1282     , p9_a144 out nocopy JTF_NUMBER_TABLE
1283     , p9_a145 out nocopy JTF_NUMBER_TABLE
1284     , p9_a146 out nocopy JTF_NUMBER_TABLE
1285     , p9_a147 out nocopy JTF_DATE_TABLE
1286     , p9_a148 out nocopy JTF_NUMBER_TABLE
1287     , p9_a149 out nocopy JTF_VARCHAR2_TABLE_100
1288     , p9_a150 out nocopy JTF_DATE_TABLE
1289     , p9_a151 out nocopy JTF_NUMBER_TABLE
1290     , p9_a152 out nocopy JTF_DATE_TABLE
1291     , p9_a153 out nocopy JTF_NUMBER_TABLE
1292     , p9_a154 out nocopy JTF_NUMBER_TABLE
1293     , p9_a155 out nocopy JTF_NUMBER_TABLE
1294     , p9_a156 out nocopy JTF_NUMBER_TABLE
1295     , p9_a157 out nocopy JTF_NUMBER_TABLE
1296     , p9_a158 out nocopy JTF_NUMBER_TABLE
1297     , p9_a159 out nocopy JTF_VARCHAR2_TABLE_100
1298     , p9_a160 out nocopy JTF_VARCHAR2_TABLE_100
1299     , p9_a161 out nocopy JTF_VARCHAR2_TABLE_100
1300     , p9_a162 out nocopy JTF_VARCHAR2_TABLE_100
1301     , p9_a163 out nocopy JTF_DATE_TABLE
1302     , p9_a164 out nocopy JTF_VARCHAR2_TABLE_100
1303     , p9_a165 out nocopy JTF_VARCHAR2_TABLE_100
1304     , p9_a166 out nocopy JTF_VARCHAR2_TABLE_100
1305     , p9_a167 out nocopy JTF_VARCHAR2_TABLE_2000
1306     , p9_a168 out nocopy JTF_VARCHAR2_TABLE_100
1307     , p9_a169 out nocopy JTF_VARCHAR2_TABLE_100
1308     , p9_a170 out nocopy JTF_NUMBER_TABLE
1309     , p9_a171 out nocopy JTF_NUMBER_TABLE
1310     , p9_a172 out nocopy JTF_NUMBER_TABLE
1311     , p9_a173 out nocopy JTF_VARCHAR2_TABLE_100
1312     , p9_a174 out nocopy JTF_NUMBER_TABLE
1313     , p9_a175 out nocopy JTF_NUMBER_TABLE
1314     , p9_a176 out nocopy JTF_VARCHAR2_TABLE_100
1315     , p9_a177 out nocopy JTF_NUMBER_TABLE
1316     , p9_a178 out nocopy JTF_VARCHAR2_TABLE_100
1317     , p9_a179 out nocopy JTF_VARCHAR2_TABLE_100
1318     , p9_a180 out nocopy JTF_VARCHAR2_TABLE_100
1319     , p9_a181 out nocopy JTF_VARCHAR2_TABLE_100
1320     , p9_a182 out nocopy JTF_VARCHAR2_TABLE_100
1321     , p9_a183 out nocopy JTF_NUMBER_TABLE
1322     , p9_a184 out nocopy JTF_NUMBER_TABLE
1323     , p9_a185 out nocopy JTF_NUMBER_TABLE
1324     , p9_a186 out nocopy JTF_NUMBER_TABLE
1325     , p9_a187 out nocopy JTF_NUMBER_TABLE
1326     , p9_a188 out nocopy JTF_NUMBER_TABLE
1327     , p9_a189 out nocopy JTF_VARCHAR2_TABLE_100
1328     , p9_a190 out nocopy JTF_VARCHAR2_TABLE_2000
1329     , x_adj_count out nocopy  NUMBER
1330   );
1331   procedure insert_api_record(p_api_version  NUMBER
1332     , p_init_msg_list  VARCHAR2
1333     , p_validation_level  VARCHAR2
1334     , p_action  VARCHAR2
1335     , p4_a0  NUMBER
1336     , p4_a1  VARCHAR2
1337     , p4_a2  VARCHAR2
1338     , p4_a3  NUMBER
1339     , p4_a4  NUMBER
1340     , p4_a5  VARCHAR2
1341     , p4_a6  DATE
1342     , p4_a7  DATE
1343     , p4_a8  NUMBER
1344     , p4_a9  NUMBER
1345     , p4_a10  NUMBER
1346     , p4_a11  NUMBER
1347     , p4_a12  NUMBER
1348     , p4_a13  VARCHAR2
1349     , p4_a14  NUMBER
1350     , p4_a15  VARCHAR2
1351     , p4_a16  VARCHAR2
1352     , p4_a17  VARCHAR2
1353     , p4_a18  VARCHAR2
1354     , p4_a19  VARCHAR2
1355     , p4_a20  VARCHAR2
1356     , p4_a21  VARCHAR2
1357     , p4_a22  NUMBER
1358     , p4_a23  NUMBER
1359     , p4_a24  DATE
1360     , p4_a25  NUMBER
1361     , p4_a26  NUMBER
1362     , p4_a27  DATE
1363     , p4_a28  VARCHAR2
1364     , p4_a29  VARCHAR2
1365     , p4_a30  VARCHAR2
1366     , p4_a31  VARCHAR2
1367     , p4_a32  VARCHAR2
1368     , p4_a33  VARCHAR2
1369     , p4_a34  VARCHAR2
1370     , p4_a35  VARCHAR2
1371     , p4_a36  VARCHAR2
1372     , p4_a37  VARCHAR2
1373     , p4_a38  VARCHAR2
1374     , p4_a39  VARCHAR2
1375     , p4_a40  VARCHAR2
1376     , p4_a41  VARCHAR2
1377     , p4_a42  VARCHAR2
1378     , p4_a43  VARCHAR2
1379     , p4_a44  VARCHAR2
1380     , p4_a45  VARCHAR2
1381     , p4_a46  VARCHAR2
1382     , p4_a47  VARCHAR2
1383     , p4_a48  VARCHAR2
1384     , p4_a49  VARCHAR2
1385     , p4_a50  VARCHAR2
1386     , p4_a51  VARCHAR2
1387     , p4_a52  VARCHAR2
1388     , p4_a53  VARCHAR2
1389     , p4_a54  VARCHAR2
1390     , p4_a55  VARCHAR2
1391     , p4_a56  VARCHAR2
1392     , p4_a57  VARCHAR2
1393     , p4_a58  VARCHAR2
1394     , p4_a59  VARCHAR2
1395     , p4_a60  VARCHAR2
1396     , p4_a61  VARCHAR2
1397     , p4_a62  VARCHAR2
1398     , p4_a63  VARCHAR2
1399     , p4_a64  VARCHAR2
1400     , p4_a65  VARCHAR2
1401     , p4_a66  VARCHAR2
1402     , p4_a67  VARCHAR2
1403     , p4_a68  VARCHAR2
1404     , p4_a69  VARCHAR2
1405     , p4_a70  VARCHAR2
1406     , p4_a71  VARCHAR2
1407     , p4_a72  VARCHAR2
1408     , p4_a73  VARCHAR2
1409     , p4_a74  VARCHAR2
1410     , p4_a75  VARCHAR2
1411     , p4_a76  VARCHAR2
1412     , p4_a77  VARCHAR2
1413     , p4_a78  VARCHAR2
1414     , p4_a79  VARCHAR2
1415     , p4_a80  VARCHAR2
1416     , p4_a81  VARCHAR2
1417     , p4_a82  VARCHAR2
1418     , p4_a83  VARCHAR2
1419     , p4_a84  VARCHAR2
1420     , p4_a85  VARCHAR2
1421     , p4_a86  VARCHAR2
1422     , p4_a87  VARCHAR2
1423     , p4_a88  VARCHAR2
1424     , p4_a89  VARCHAR2
1425     , p4_a90  VARCHAR2
1426     , p4_a91  VARCHAR2
1427     , p4_a92  VARCHAR2
1428     , p4_a93  VARCHAR2
1429     , p4_a94  VARCHAR2
1430     , p4_a95  VARCHAR2
1431     , p4_a96  VARCHAR2
1432     , p4_a97  VARCHAR2
1433     , p4_a98  VARCHAR2
1434     , p4_a99  VARCHAR2
1435     , p4_a100  VARCHAR2
1436     , p4_a101  VARCHAR2
1437     , p4_a102  VARCHAR2
1438     , p4_a103  VARCHAR2
1439     , p4_a104  VARCHAR2
1440     , p4_a105  VARCHAR2
1441     , p4_a106  VARCHAR2
1442     , p4_a107  VARCHAR2
1443     , p4_a108  VARCHAR2
1444     , p4_a109  VARCHAR2
1445     , p4_a110  VARCHAR2
1446     , p4_a111  VARCHAR2
1447     , p4_a112  VARCHAR2
1448     , p4_a113  VARCHAR2
1449     , p4_a114  VARCHAR2
1450     , p4_a115  VARCHAR2
1451     , p4_a116  VARCHAR2
1452     , p4_a117  VARCHAR2
1453     , p4_a118  VARCHAR2
1454     , p4_a119  VARCHAR2
1455     , p4_a120  VARCHAR2
1456     , p4_a121  VARCHAR2
1457     , p4_a122  VARCHAR2
1458     , p4_a123  VARCHAR2
1459     , p4_a124  VARCHAR2
1460     , p4_a125  VARCHAR2
1461     , p4_a126  VARCHAR2
1462     , p4_a127  VARCHAR2
1463     , p4_a128  VARCHAR2
1464     , p4_a129  NUMBER
1465     , p4_a130  VARCHAR2
1466     , p4_a131  NUMBER
1467     , p4_a132  VARCHAR2
1468     , p4_a133  VARCHAR2
1469     , p4_a134  VARCHAR2
1470     , p4_a135  NUMBER
1471     , p4_a136  NUMBER
1472     , p4_a137  NUMBER
1473     , p4_a138  NUMBER
1474     , p4_a139  VARCHAR2
1475     , p4_a140  NUMBER
1476     , p4_a141  NUMBER
1477     , p4_a142  VARCHAR2
1478     , p4_a143  NUMBER
1479     , p4_a144  NUMBER
1480     , p4_a145  NUMBER
1481     , p4_a146  NUMBER
1482     , p4_a147  DATE
1483     , p4_a148  NUMBER
1484     , p4_a149  VARCHAR2
1485     , p4_a150  DATE
1486     , p4_a151  NUMBER
1487     , p4_a152  DATE
1488     , p4_a153  NUMBER
1489     , p4_a154  NUMBER
1490     , p4_a155  NUMBER
1491     , p4_a156  NUMBER
1492     , p4_a157  NUMBER
1493     , p4_a158  NUMBER
1494     , p4_a159  VARCHAR2
1495     , p4_a160  VARCHAR2
1496     , p4_a161  VARCHAR2
1497     , p4_a162  VARCHAR2
1498     , p4_a163  DATE
1499     , p4_a164  VARCHAR2
1500     , p4_a165  VARCHAR2
1501     , p4_a166  VARCHAR2
1502     , p4_a167  VARCHAR2
1503     , p4_a168  VARCHAR2
1504     , p4_a169  VARCHAR2
1505     , p4_a170  NUMBER
1506     , p4_a171  NUMBER
1507     , p4_a172  NUMBER
1508     , p4_a173  VARCHAR2
1509     , p4_a174  NUMBER
1510     , p4_a175  NUMBER
1511     , p4_a176  VARCHAR2
1512     , p4_a177  NUMBER
1513     , p4_a178  VARCHAR2
1514     , p4_a179  VARCHAR2
1515     , p4_a180  VARCHAR2
1516     , p4_a181  VARCHAR2
1517     , p4_a182  VARCHAR2
1518     , p4_a183  NUMBER
1519     , p4_a184  NUMBER
1520     , p4_a185  NUMBER
1521     , p4_a186  NUMBER
1522     , p4_a187  NUMBER
1523     , p4_a188  NUMBER
1524     , p4_a189  VARCHAR2
1525     , p4_a190  VARCHAR2
1526     , x_api_id out nocopy  NUMBER
1527     , x_return_status out nocopy  VARCHAR2
1528     , x_msg_count out nocopy  NUMBER
1529     , x_msg_data out nocopy  VARCHAR2
1530     , x_loading_status out nocopy  VARCHAR2
1531   );
1532   procedure call_mass_update(p_api_version  NUMBER
1533     , p_init_msg_list  VARCHAR2
1534     , p_validation_level  VARCHAR2
1535     , p_org_id  NUMBER
1536     , p_salesrep_id  NUMBER
1537     , p_pr_date_to  DATE
1538     , p_pr_date_from  DATE
1539     , p_calc_status  VARCHAR2
1540     , p_adj_status  VARCHAR2
1541     , p_load_status  VARCHAR2
1542     , p_invoice_num  VARCHAR2
1543     , p_order_num  NUMBER
1544     , p12_a0  NUMBER
1545     , p12_a1  VARCHAR2
1546     , p12_a2  VARCHAR2
1547     , p12_a3  NUMBER
1548     , p12_a4  NUMBER
1549     , p12_a5  VARCHAR2
1550     , p12_a6  DATE
1551     , p12_a7  DATE
1552     , p12_a8  NUMBER
1553     , p12_a9  NUMBER
1554     , p12_a10  NUMBER
1555     , p12_a11  NUMBER
1556     , p12_a12  NUMBER
1557     , p12_a13  VARCHAR2
1558     , p12_a14  NUMBER
1559     , p12_a15  VARCHAR2
1560     , p12_a16  VARCHAR2
1561     , p12_a17  VARCHAR2
1562     , p12_a18  VARCHAR2
1563     , p12_a19  VARCHAR2
1564     , p12_a20  VARCHAR2
1565     , p12_a21  VARCHAR2
1566     , p12_a22  NUMBER
1567     , p12_a23  NUMBER
1568     , p12_a24  DATE
1569     , p12_a25  NUMBER
1570     , p12_a26  NUMBER
1571     , p12_a27  DATE
1572     , p12_a28  VARCHAR2
1573     , p12_a29  VARCHAR2
1574     , p12_a30  VARCHAR2
1575     , p12_a31  VARCHAR2
1576     , p12_a32  VARCHAR2
1577     , p12_a33  VARCHAR2
1578     , p12_a34  VARCHAR2
1579     , p12_a35  VARCHAR2
1580     , p12_a36  VARCHAR2
1581     , p12_a37  VARCHAR2
1582     , p12_a38  VARCHAR2
1583     , p12_a39  VARCHAR2
1584     , p12_a40  VARCHAR2
1585     , p12_a41  VARCHAR2
1586     , p12_a42  VARCHAR2
1587     , p12_a43  VARCHAR2
1588     , p12_a44  VARCHAR2
1589     , p12_a45  VARCHAR2
1590     , p12_a46  VARCHAR2
1591     , p12_a47  VARCHAR2
1592     , p12_a48  VARCHAR2
1593     , p12_a49  VARCHAR2
1594     , p12_a50  VARCHAR2
1595     , p12_a51  VARCHAR2
1596     , p12_a52  VARCHAR2
1597     , p12_a53  VARCHAR2
1598     , p12_a54  VARCHAR2
1599     , p12_a55  VARCHAR2
1600     , p12_a56  VARCHAR2
1601     , p12_a57  VARCHAR2
1602     , p12_a58  VARCHAR2
1603     , p12_a59  VARCHAR2
1604     , p12_a60  VARCHAR2
1605     , p12_a61  VARCHAR2
1606     , p12_a62  VARCHAR2
1607     , p12_a63  VARCHAR2
1608     , p12_a64  VARCHAR2
1609     , p12_a65  VARCHAR2
1610     , p12_a66  VARCHAR2
1611     , p12_a67  VARCHAR2
1612     , p12_a68  VARCHAR2
1613     , p12_a69  VARCHAR2
1614     , p12_a70  VARCHAR2
1615     , p12_a71  VARCHAR2
1616     , p12_a72  VARCHAR2
1617     , p12_a73  VARCHAR2
1618     , p12_a74  VARCHAR2
1619     , p12_a75  VARCHAR2
1620     , p12_a76  VARCHAR2
1621     , p12_a77  VARCHAR2
1622     , p12_a78  VARCHAR2
1623     , p12_a79  VARCHAR2
1624     , p12_a80  VARCHAR2
1625     , p12_a81  VARCHAR2
1626     , p12_a82  VARCHAR2
1627     , p12_a83  VARCHAR2
1628     , p12_a84  VARCHAR2
1629     , p12_a85  VARCHAR2
1630     , p12_a86  VARCHAR2
1631     , p12_a87  VARCHAR2
1632     , p12_a88  VARCHAR2
1633     , p12_a89  VARCHAR2
1634     , p12_a90  VARCHAR2
1635     , p12_a91  VARCHAR2
1636     , p12_a92  VARCHAR2
1637     , p12_a93  VARCHAR2
1638     , p12_a94  VARCHAR2
1639     , p12_a95  VARCHAR2
1640     , p12_a96  VARCHAR2
1641     , p12_a97  VARCHAR2
1642     , p12_a98  VARCHAR2
1643     , p12_a99  VARCHAR2
1644     , p12_a100  VARCHAR2
1645     , p12_a101  VARCHAR2
1646     , p12_a102  VARCHAR2
1647     , p12_a103  VARCHAR2
1648     , p12_a104  VARCHAR2
1649     , p12_a105  VARCHAR2
1650     , p12_a106  VARCHAR2
1651     , p12_a107  VARCHAR2
1652     , p12_a108  VARCHAR2
1653     , p12_a109  VARCHAR2
1654     , p12_a110  VARCHAR2
1655     , p12_a111  VARCHAR2
1656     , p12_a112  VARCHAR2
1657     , p12_a113  VARCHAR2
1658     , p12_a114  VARCHAR2
1659     , p12_a115  VARCHAR2
1660     , p12_a116  VARCHAR2
1661     , p12_a117  VARCHAR2
1662     , p12_a118  VARCHAR2
1663     , p12_a119  VARCHAR2
1664     , p12_a120  VARCHAR2
1665     , p12_a121  VARCHAR2
1666     , p12_a122  VARCHAR2
1667     , p12_a123  VARCHAR2
1668     , p12_a124  VARCHAR2
1669     , p12_a125  VARCHAR2
1670     , p12_a126  VARCHAR2
1671     , p12_a127  VARCHAR2
1672     , p12_a128  VARCHAR2
1673     , p12_a129  NUMBER
1674     , p12_a130  VARCHAR2
1675     , p12_a131  NUMBER
1676     , p12_a132  VARCHAR2
1677     , p12_a133  VARCHAR2
1678     , p12_a134  VARCHAR2
1679     , p12_a135  NUMBER
1680     , p12_a136  NUMBER
1681     , p12_a137  NUMBER
1682     , p12_a138  NUMBER
1683     , p12_a139  VARCHAR2
1684     , p12_a140  NUMBER
1685     , p12_a141  NUMBER
1686     , p12_a142  VARCHAR2
1687     , p12_a143  NUMBER
1688     , p12_a144  NUMBER
1689     , p12_a145  NUMBER
1690     , p12_a146  NUMBER
1691     , p12_a147  DATE
1692     , p12_a148  NUMBER
1693     , p12_a149  VARCHAR2
1694     , p12_a150  DATE
1695     , p12_a151  NUMBER
1696     , p12_a152  DATE
1697     , p12_a153  NUMBER
1698     , p12_a154  NUMBER
1699     , p12_a155  NUMBER
1700     , p12_a156  NUMBER
1701     , p12_a157  NUMBER
1702     , p12_a158  NUMBER
1703     , p12_a159  VARCHAR2
1704     , p12_a160  VARCHAR2
1705     , p12_a161  VARCHAR2
1706     , p12_a162  VARCHAR2
1707     , p12_a163  DATE
1708     , p12_a164  VARCHAR2
1709     , p12_a165  VARCHAR2
1710     , p12_a166  VARCHAR2
1711     , p12_a167  VARCHAR2
1712     , p12_a168  VARCHAR2
1713     , p12_a169  VARCHAR2
1714     , p12_a170  NUMBER
1715     , p12_a171  NUMBER
1716     , p12_a172  NUMBER
1717     , p12_a173  VARCHAR2
1718     , p12_a174  NUMBER
1719     , p12_a175  NUMBER
1720     , p12_a176  VARCHAR2
1721     , p12_a177  NUMBER
1722     , p12_a178  VARCHAR2
1723     , p12_a179  VARCHAR2
1724     , p12_a180  VARCHAR2
1725     , p12_a181  VARCHAR2
1726     , p12_a182  VARCHAR2
1727     , p12_a183  NUMBER
1728     , p12_a184  NUMBER
1729     , p12_a185  NUMBER
1730     , p12_a186  NUMBER
1731     , p12_a187  NUMBER
1732     , p12_a188  NUMBER
1733     , p12_a189  VARCHAR2
1734     , p12_a190  VARCHAR2
1735     , p_mass_adj_type  VARCHAR2
1736     , p14_a0  NUMBER
1737     , p14_a1  VARCHAR2
1738     , p14_a2  VARCHAR2
1739     , p14_a3  NUMBER
1740     , p14_a4  NUMBER
1741     , p14_a5  VARCHAR2
1742     , p14_a6  DATE
1743     , p14_a7  DATE
1744     , p14_a8  NUMBER
1745     , p14_a9  NUMBER
1746     , p14_a10  NUMBER
1747     , p14_a11  NUMBER
1748     , p14_a12  NUMBER
1749     , p14_a13  VARCHAR2
1750     , p14_a14  NUMBER
1751     , p14_a15  VARCHAR2
1752     , p14_a16  VARCHAR2
1753     , p14_a17  VARCHAR2
1754     , p14_a18  VARCHAR2
1755     , p14_a19  VARCHAR2
1756     , p14_a20  VARCHAR2
1757     , p14_a21  VARCHAR2
1758     , p14_a22  NUMBER
1759     , p14_a23  NUMBER
1760     , p14_a24  DATE
1761     , p14_a25  NUMBER
1762     , p14_a26  NUMBER
1763     , p14_a27  DATE
1764     , p14_a28  VARCHAR2
1765     , p14_a29  VARCHAR2
1766     , p14_a30  VARCHAR2
1767     , p14_a31  VARCHAR2
1768     , p14_a32  VARCHAR2
1769     , p14_a33  VARCHAR2
1770     , p14_a34  VARCHAR2
1771     , p14_a35  VARCHAR2
1772     , p14_a36  VARCHAR2
1773     , p14_a37  VARCHAR2
1774     , p14_a38  VARCHAR2
1775     , p14_a39  VARCHAR2
1776     , p14_a40  VARCHAR2
1777     , p14_a41  VARCHAR2
1778     , p14_a42  VARCHAR2
1779     , p14_a43  VARCHAR2
1780     , p14_a44  VARCHAR2
1781     , p14_a45  VARCHAR2
1782     , p14_a46  VARCHAR2
1783     , p14_a47  VARCHAR2
1784     , p14_a48  VARCHAR2
1785     , p14_a49  VARCHAR2
1786     , p14_a50  VARCHAR2
1787     , p14_a51  VARCHAR2
1788     , p14_a52  VARCHAR2
1789     , p14_a53  VARCHAR2
1790     , p14_a54  VARCHAR2
1791     , p14_a55  VARCHAR2
1792     , p14_a56  VARCHAR2
1793     , p14_a57  VARCHAR2
1794     , p14_a58  VARCHAR2
1795     , p14_a59  VARCHAR2
1796     , p14_a60  VARCHAR2
1797     , p14_a61  VARCHAR2
1798     , p14_a62  VARCHAR2
1799     , p14_a63  VARCHAR2
1800     , p14_a64  VARCHAR2
1801     , p14_a65  VARCHAR2
1802     , p14_a66  VARCHAR2
1803     , p14_a67  VARCHAR2
1804     , p14_a68  VARCHAR2
1805     , p14_a69  VARCHAR2
1806     , p14_a70  VARCHAR2
1807     , p14_a71  VARCHAR2
1808     , p14_a72  VARCHAR2
1809     , p14_a73  VARCHAR2
1810     , p14_a74  VARCHAR2
1811     , p14_a75  VARCHAR2
1812     , p14_a76  VARCHAR2
1813     , p14_a77  VARCHAR2
1814     , p14_a78  VARCHAR2
1815     , p14_a79  VARCHAR2
1816     , p14_a80  VARCHAR2
1817     , p14_a81  VARCHAR2
1818     , p14_a82  VARCHAR2
1819     , p14_a83  VARCHAR2
1820     , p14_a84  VARCHAR2
1821     , p14_a85  VARCHAR2
1822     , p14_a86  VARCHAR2
1823     , p14_a87  VARCHAR2
1824     , p14_a88  VARCHAR2
1825     , p14_a89  VARCHAR2
1826     , p14_a90  VARCHAR2
1827     , p14_a91  VARCHAR2
1828     , p14_a92  VARCHAR2
1829     , p14_a93  VARCHAR2
1830     , p14_a94  VARCHAR2
1831     , p14_a95  VARCHAR2
1832     , p14_a96  VARCHAR2
1833     , p14_a97  VARCHAR2
1834     , p14_a98  VARCHAR2
1835     , p14_a99  VARCHAR2
1836     , p14_a100  VARCHAR2
1837     , p14_a101  VARCHAR2
1838     , p14_a102  VARCHAR2
1839     , p14_a103  VARCHAR2
1840     , p14_a104  VARCHAR2
1841     , p14_a105  VARCHAR2
1842     , p14_a106  VARCHAR2
1843     , p14_a107  VARCHAR2
1844     , p14_a108  VARCHAR2
1845     , p14_a109  VARCHAR2
1846     , p14_a110  VARCHAR2
1847     , p14_a111  VARCHAR2
1848     , p14_a112  VARCHAR2
1849     , p14_a113  VARCHAR2
1850     , p14_a114  VARCHAR2
1851     , p14_a115  VARCHAR2
1852     , p14_a116  VARCHAR2
1853     , p14_a117  VARCHAR2
1854     , p14_a118  VARCHAR2
1855     , p14_a119  VARCHAR2
1856     , p14_a120  VARCHAR2
1857     , p14_a121  VARCHAR2
1858     , p14_a122  VARCHAR2
1859     , p14_a123  VARCHAR2
1860     , p14_a124  VARCHAR2
1861     , p14_a125  VARCHAR2
1862     , p14_a126  VARCHAR2
1863     , p14_a127  VARCHAR2
1864     , p14_a128  VARCHAR2
1865     , p14_a129  NUMBER
1866     , p14_a130  VARCHAR2
1867     , p14_a131  NUMBER
1868     , p14_a132  VARCHAR2
1869     , p14_a133  VARCHAR2
1870     , p14_a134  VARCHAR2
1871     , p14_a135  NUMBER
1872     , p14_a136  NUMBER
1873     , p14_a137  NUMBER
1874     , p14_a138  NUMBER
1875     , p14_a139  VARCHAR2
1876     , p14_a140  NUMBER
1877     , p14_a141  NUMBER
1878     , p14_a142  VARCHAR2
1879     , p14_a143  NUMBER
1880     , p14_a144  NUMBER
1881     , p14_a145  NUMBER
1882     , p14_a146  NUMBER
1883     , p14_a147  DATE
1884     , p14_a148  NUMBER
1885     , p14_a149  VARCHAR2
1886     , p14_a150  DATE
1887     , p14_a151  NUMBER
1888     , p14_a152  DATE
1889     , p14_a153  NUMBER
1890     , p14_a154  NUMBER
1891     , p14_a155  NUMBER
1892     , p14_a156  NUMBER
1893     , p14_a157  NUMBER
1894     , p14_a158  NUMBER
1895     , p14_a159  VARCHAR2
1896     , p14_a160  VARCHAR2
1897     , p14_a161  VARCHAR2
1898     , p14_a162  VARCHAR2
1899     , p14_a163  DATE
1900     , p14_a164  VARCHAR2
1901     , p14_a165  VARCHAR2
1902     , p14_a166  VARCHAR2
1903     , p14_a167  VARCHAR2
1904     , p14_a168  VARCHAR2
1905     , p14_a169  VARCHAR2
1906     , p14_a170  NUMBER
1907     , p14_a171  NUMBER
1908     , p14_a172  NUMBER
1909     , p14_a173  VARCHAR2
1910     , p14_a174  NUMBER
1911     , p14_a175  NUMBER
1912     , p14_a176  VARCHAR2
1913     , p14_a177  NUMBER
1914     , p14_a178  VARCHAR2
1915     , p14_a179  VARCHAR2
1916     , p14_a180  VARCHAR2
1917     , p14_a181  VARCHAR2
1918     , p14_a182  VARCHAR2
1919     , p14_a183  NUMBER
1920     , p14_a184  NUMBER
1921     , p14_a185  NUMBER
1922     , p14_a186  NUMBER
1923     , p14_a187  NUMBER
1924     , p14_a188  NUMBER
1925     , p14_a189  VARCHAR2
1926     , p14_a190  VARCHAR2
1927     , x_return_status out nocopy  VARCHAR2
1928     , x_msg_count out nocopy  NUMBER
1929     , x_msg_data out nocopy  VARCHAR2
1930     , x_loading_status out nocopy  VARCHAR2
1931   );
1932   procedure call_split(p_api_version  NUMBER
1933     , p_init_msg_list  VARCHAR2
1934     , p_validation_level  VARCHAR2
1935     , p_split_type  VARCHAR2
1936     , p_from_salesrep_id  NUMBER
1937     , p5_a0 JTF_NUMBER_TABLE
1938     , p5_a1 JTF_VARCHAR2_TABLE_100
1939     , p5_a2 JTF_VARCHAR2_TABLE_100
1940     , p5_a3 JTF_NUMBER_TABLE
1941     , p5_a4 JTF_NUMBER_TABLE
1942     , p_comm_lines_api_id  NUMBER
1943     , p_invoice_number  VARCHAR2
1944     , p_order_number  NUMBER
1945     , p_transaction_amount  NUMBER
1946     , p_adjusted_by  VARCHAR2
1947     , p_adjust_comments  VARCHAR2
1948     , p_org_id  NUMBER
1949     , x_return_status out nocopy  VARCHAR2
1950     , x_msg_count out nocopy  NUMBER
1951     , x_msg_data out nocopy  VARCHAR2
1952     , x_loading_status out nocopy  VARCHAR2
1953   );
1954   procedure get_trx_lines(p_api_version  NUMBER
1955     , p_init_msg_list  VARCHAR2
1956     , p_validation_level  VARCHAR2
1957     , p_header_id  NUMBER
1958     , x_return_status out nocopy  VARCHAR2
1959     , x_msg_count out nocopy  NUMBER
1960     , x_msg_data out nocopy  VARCHAR2
1961     , x_loading_status out nocopy  VARCHAR2
1962     , p8_a0 out nocopy JTF_NUMBER_TABLE
1963     , p8_a1 out nocopy JTF_NUMBER_TABLE
1964     , p8_a2 out nocopy JTF_NUMBER_TABLE
1965     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_400
1966     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1967     , p8_a5 out nocopy JTF_NUMBER_TABLE
1968     , p8_a6 out nocopy JTF_DATE_TABLE
1969     , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
1970     , p8_a8 out nocopy JTF_NUMBER_TABLE
1971     , p8_a9 out nocopy JTF_NUMBER_TABLE
1972     , p8_a10 out nocopy JTF_NUMBER_TABLE
1973     , p8_a11 out nocopy JTF_NUMBER_TABLE
1974     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1975     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1976     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1977     , p8_a15 out nocopy JTF_NUMBER_TABLE
1978     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1979     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1980     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
1981     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_400
1982     , x_tbl_count out nocopy  NUMBER
1983   );
1984   procedure get_trx_history(p_api_version  NUMBER
1985     , p_init_msg_list  VARCHAR2
1986     , p_validation_level  VARCHAR2
1987     , p_adj_comm_lines_api_id  NUMBER
1988     , x_return_status out nocopy  VARCHAR2
1989     , x_msg_count out nocopy  NUMBER
1990     , x_msg_data out nocopy  VARCHAR2
1991     , x_loading_status out nocopy  VARCHAR2
1992     , p8_a0 out nocopy JTF_NUMBER_TABLE
1993     , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
1994     , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
1995     , p8_a3 out nocopy JTF_NUMBER_TABLE
1996     , p8_a4 out nocopy JTF_NUMBER_TABLE
1997     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1998     , p8_a6 out nocopy JTF_DATE_TABLE
1999     , p8_a7 out nocopy JTF_DATE_TABLE
2000     , p8_a8 out nocopy JTF_NUMBER_TABLE
2001     , p8_a9 out nocopy JTF_NUMBER_TABLE
2002     , p8_a10 out nocopy JTF_NUMBER_TABLE
2003     , p8_a11 out nocopy JTF_NUMBER_TABLE
2004     , p8_a12 out nocopy JTF_NUMBER_TABLE
2005     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
2006     , p8_a14 out nocopy JTF_NUMBER_TABLE
2007     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
2008     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
2009     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
2010     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
2011     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
2012     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
2013     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_1800
2014     , p8_a22 out nocopy JTF_NUMBER_TABLE
2015     , p8_a23 out nocopy JTF_NUMBER_TABLE
2016     , p8_a24 out nocopy JTF_DATE_TABLE
2017     , p8_a25 out nocopy JTF_NUMBER_TABLE
2018     , p8_a26 out nocopy JTF_NUMBER_TABLE
2019     , p8_a27 out nocopy JTF_DATE_TABLE
2020     , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
2021     , p8_a29 out nocopy JTF_VARCHAR2_TABLE_300
2022     , p8_a30 out nocopy JTF_VARCHAR2_TABLE_300
2023     , p8_a31 out nocopy JTF_VARCHAR2_TABLE_300
2024     , p8_a32 out nocopy JTF_VARCHAR2_TABLE_300
2025     , p8_a33 out nocopy JTF_VARCHAR2_TABLE_300
2026     , p8_a34 out nocopy JTF_VARCHAR2_TABLE_300
2027     , p8_a35 out nocopy JTF_VARCHAR2_TABLE_300
2028     , p8_a36 out nocopy JTF_VARCHAR2_TABLE_300
2029     , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
2030     , p8_a38 out nocopy JTF_VARCHAR2_TABLE_300
2031     , p8_a39 out nocopy JTF_VARCHAR2_TABLE_300
2032     , p8_a40 out nocopy JTF_VARCHAR2_TABLE_300
2033     , p8_a41 out nocopy JTF_VARCHAR2_TABLE_300
2034     , p8_a42 out nocopy JTF_VARCHAR2_TABLE_300
2035     , p8_a43 out nocopy JTF_VARCHAR2_TABLE_300
2036     , p8_a44 out nocopy JTF_VARCHAR2_TABLE_300
2037     , p8_a45 out nocopy JTF_VARCHAR2_TABLE_300
2038     , p8_a46 out nocopy JTF_VARCHAR2_TABLE_300
2039     , p8_a47 out nocopy JTF_VARCHAR2_TABLE_300
2040     , p8_a48 out nocopy JTF_VARCHAR2_TABLE_300
2041     , p8_a49 out nocopy JTF_VARCHAR2_TABLE_300
2042     , p8_a50 out nocopy JTF_VARCHAR2_TABLE_300
2043     , p8_a51 out nocopy JTF_VARCHAR2_TABLE_300
2044     , p8_a52 out nocopy JTF_VARCHAR2_TABLE_300
2045     , p8_a53 out nocopy JTF_VARCHAR2_TABLE_300
2046     , p8_a54 out nocopy JTF_VARCHAR2_TABLE_300
2047     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_300
2048     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_300
2049     , p8_a57 out nocopy JTF_VARCHAR2_TABLE_300
2050     , p8_a58 out nocopy JTF_VARCHAR2_TABLE_300
2051     , p8_a59 out nocopy JTF_VARCHAR2_TABLE_300
2052     , p8_a60 out nocopy JTF_VARCHAR2_TABLE_300
2053     , p8_a61 out nocopy JTF_VARCHAR2_TABLE_300
2054     , p8_a62 out nocopy JTF_VARCHAR2_TABLE_300
2055     , p8_a63 out nocopy JTF_VARCHAR2_TABLE_300
2056     , p8_a64 out nocopy JTF_VARCHAR2_TABLE_300
2057     , p8_a65 out nocopy JTF_VARCHAR2_TABLE_300
2058     , p8_a66 out nocopy JTF_VARCHAR2_TABLE_300
2059     , p8_a67 out nocopy JTF_VARCHAR2_TABLE_300
2060     , p8_a68 out nocopy JTF_VARCHAR2_TABLE_300
2061     , p8_a69 out nocopy JTF_VARCHAR2_TABLE_300
2062     , p8_a70 out nocopy JTF_VARCHAR2_TABLE_300
2063     , p8_a71 out nocopy JTF_VARCHAR2_TABLE_300
2064     , p8_a72 out nocopy JTF_VARCHAR2_TABLE_300
2065     , p8_a73 out nocopy JTF_VARCHAR2_TABLE_300
2066     , p8_a74 out nocopy JTF_VARCHAR2_TABLE_300
2067     , p8_a75 out nocopy JTF_VARCHAR2_TABLE_300
2068     , p8_a76 out nocopy JTF_VARCHAR2_TABLE_300
2069     , p8_a77 out nocopy JTF_VARCHAR2_TABLE_300
2070     , p8_a78 out nocopy JTF_VARCHAR2_TABLE_300
2071     , p8_a79 out nocopy JTF_VARCHAR2_TABLE_300
2072     , p8_a80 out nocopy JTF_VARCHAR2_TABLE_300
2073     , p8_a81 out nocopy JTF_VARCHAR2_TABLE_300
2074     , p8_a82 out nocopy JTF_VARCHAR2_TABLE_300
2075     , p8_a83 out nocopy JTF_VARCHAR2_TABLE_300
2076     , p8_a84 out nocopy JTF_VARCHAR2_TABLE_300
2077     , p8_a85 out nocopy JTF_VARCHAR2_TABLE_300
2078     , p8_a86 out nocopy JTF_VARCHAR2_TABLE_300
2079     , p8_a87 out nocopy JTF_VARCHAR2_TABLE_300
2080     , p8_a88 out nocopy JTF_VARCHAR2_TABLE_300
2081     , p8_a89 out nocopy JTF_VARCHAR2_TABLE_300
2082     , p8_a90 out nocopy JTF_VARCHAR2_TABLE_300
2083     , p8_a91 out nocopy JTF_VARCHAR2_TABLE_300
2084     , p8_a92 out nocopy JTF_VARCHAR2_TABLE_300
2085     , p8_a93 out nocopy JTF_VARCHAR2_TABLE_300
2086     , p8_a94 out nocopy JTF_VARCHAR2_TABLE_300
2087     , p8_a95 out nocopy JTF_VARCHAR2_TABLE_300
2088     , p8_a96 out nocopy JTF_VARCHAR2_TABLE_300
2089     , p8_a97 out nocopy JTF_VARCHAR2_TABLE_300
2090     , p8_a98 out nocopy JTF_VARCHAR2_TABLE_300
2091     , p8_a99 out nocopy JTF_VARCHAR2_TABLE_300
2092     , p8_a100 out nocopy JTF_VARCHAR2_TABLE_300
2093     , p8_a101 out nocopy JTF_VARCHAR2_TABLE_300
2094     , p8_a102 out nocopy JTF_VARCHAR2_TABLE_300
2095     , p8_a103 out nocopy JTF_VARCHAR2_TABLE_300
2096     , p8_a104 out nocopy JTF_VARCHAR2_TABLE_300
2097     , p8_a105 out nocopy JTF_VARCHAR2_TABLE_300
2098     , p8_a106 out nocopy JTF_VARCHAR2_TABLE_300
2099     , p8_a107 out nocopy JTF_VARCHAR2_TABLE_300
2100     , p8_a108 out nocopy JTF_VARCHAR2_TABLE_300
2101     , p8_a109 out nocopy JTF_VARCHAR2_TABLE_300
2102     , p8_a110 out nocopy JTF_VARCHAR2_TABLE_300
2103     , p8_a111 out nocopy JTF_VARCHAR2_TABLE_300
2104     , p8_a112 out nocopy JTF_VARCHAR2_TABLE_300
2105     , p8_a113 out nocopy JTF_VARCHAR2_TABLE_300
2106     , p8_a114 out nocopy JTF_VARCHAR2_TABLE_300
2107     , p8_a115 out nocopy JTF_VARCHAR2_TABLE_300
2108     , p8_a116 out nocopy JTF_VARCHAR2_TABLE_300
2109     , p8_a117 out nocopy JTF_VARCHAR2_TABLE_300
2110     , p8_a118 out nocopy JTF_VARCHAR2_TABLE_300
2111     , p8_a119 out nocopy JTF_VARCHAR2_TABLE_300
2112     , p8_a120 out nocopy JTF_VARCHAR2_TABLE_300
2113     , p8_a121 out nocopy JTF_VARCHAR2_TABLE_300
2114     , p8_a122 out nocopy JTF_VARCHAR2_TABLE_300
2115     , p8_a123 out nocopy JTF_VARCHAR2_TABLE_300
2116     , p8_a124 out nocopy JTF_VARCHAR2_TABLE_300
2117     , p8_a125 out nocopy JTF_VARCHAR2_TABLE_300
2118     , p8_a126 out nocopy JTF_VARCHAR2_TABLE_300
2119     , p8_a127 out nocopy JTF_VARCHAR2_TABLE_300
2120     , p8_a128 out nocopy JTF_VARCHAR2_TABLE_300
2121     , p8_a129 out nocopy JTF_NUMBER_TABLE
2122     , p8_a130 out nocopy JTF_VARCHAR2_TABLE_100
2123     , p8_a131 out nocopy JTF_NUMBER_TABLE
2124     , p8_a132 out nocopy JTF_VARCHAR2_TABLE_100
2125     , p8_a133 out nocopy JTF_VARCHAR2_TABLE_100
2126     , p8_a134 out nocopy JTF_VARCHAR2_TABLE_100
2127     , p8_a135 out nocopy JTF_NUMBER_TABLE
2128     , p8_a136 out nocopy JTF_NUMBER_TABLE
2129     , p8_a137 out nocopy JTF_NUMBER_TABLE
2130     , p8_a138 out nocopy JTF_NUMBER_TABLE
2131     , p8_a139 out nocopy JTF_VARCHAR2_TABLE_100
2132     , p8_a140 out nocopy JTF_NUMBER_TABLE
2133     , p8_a141 out nocopy JTF_NUMBER_TABLE
2134     , p8_a142 out nocopy JTF_VARCHAR2_TABLE_100
2135     , p8_a143 out nocopy JTF_NUMBER_TABLE
2136     , p8_a144 out nocopy JTF_NUMBER_TABLE
2137     , p8_a145 out nocopy JTF_NUMBER_TABLE
2138     , p8_a146 out nocopy JTF_NUMBER_TABLE
2139     , p8_a147 out nocopy JTF_DATE_TABLE
2140     , p8_a148 out nocopy JTF_NUMBER_TABLE
2141     , p8_a149 out nocopy JTF_VARCHAR2_TABLE_100
2142     , p8_a150 out nocopy JTF_DATE_TABLE
2143     , p8_a151 out nocopy JTF_NUMBER_TABLE
2144     , p8_a152 out nocopy JTF_DATE_TABLE
2145     , p8_a153 out nocopy JTF_NUMBER_TABLE
2146     , p8_a154 out nocopy JTF_NUMBER_TABLE
2147     , p8_a155 out nocopy JTF_NUMBER_TABLE
2148     , p8_a156 out nocopy JTF_NUMBER_TABLE
2149     , p8_a157 out nocopy JTF_NUMBER_TABLE
2150     , p8_a158 out nocopy JTF_NUMBER_TABLE
2151     , p8_a159 out nocopy JTF_VARCHAR2_TABLE_100
2152     , p8_a160 out nocopy JTF_VARCHAR2_TABLE_100
2153     , p8_a161 out nocopy JTF_VARCHAR2_TABLE_100
2154     , p8_a162 out nocopy JTF_VARCHAR2_TABLE_100
2155     , p8_a163 out nocopy JTF_DATE_TABLE
2156     , p8_a164 out nocopy JTF_VARCHAR2_TABLE_100
2157     , p8_a165 out nocopy JTF_VARCHAR2_TABLE_100
2158     , p8_a166 out nocopy JTF_VARCHAR2_TABLE_100
2159     , p8_a167 out nocopy JTF_VARCHAR2_TABLE_2000
2160     , p8_a168 out nocopy JTF_VARCHAR2_TABLE_100
2161     , p8_a169 out nocopy JTF_VARCHAR2_TABLE_100
2162     , p8_a170 out nocopy JTF_NUMBER_TABLE
2163     , p8_a171 out nocopy JTF_NUMBER_TABLE
2164     , p8_a172 out nocopy JTF_NUMBER_TABLE
2165     , p8_a173 out nocopy JTF_VARCHAR2_TABLE_100
2166     , p8_a174 out nocopy JTF_NUMBER_TABLE
2167     , p8_a175 out nocopy JTF_NUMBER_TABLE
2168     , p8_a176 out nocopy JTF_VARCHAR2_TABLE_100
2169     , p8_a177 out nocopy JTF_NUMBER_TABLE
2170     , p8_a178 out nocopy JTF_VARCHAR2_TABLE_100
2171     , p8_a179 out nocopy JTF_VARCHAR2_TABLE_100
2172     , p8_a180 out nocopy JTF_VARCHAR2_TABLE_100
2173     , p8_a181 out nocopy JTF_VARCHAR2_TABLE_100
2174     , p8_a182 out nocopy JTF_VARCHAR2_TABLE_100
2175     , p8_a183 out nocopy JTF_NUMBER_TABLE
2176     , p8_a184 out nocopy JTF_NUMBER_TABLE
2177     , p8_a185 out nocopy JTF_NUMBER_TABLE
2178     , p8_a186 out nocopy JTF_NUMBER_TABLE
2179     , p8_a187 out nocopy JTF_NUMBER_TABLE
2180     , p8_a188 out nocopy JTF_NUMBER_TABLE
2181     , p8_a189 out nocopy JTF_VARCHAR2_TABLE_100
2182     , p8_a190 out nocopy JTF_VARCHAR2_TABLE_2000
2183     , x_adj_count out nocopy  NUMBER
2184   );
2185   procedure get_cust_info(p_api_version  NUMBER
2186     , p_init_msg_list  VARCHAR2
2187     , p_validation_level  VARCHAR2
2188     , p_comm_lines_api_id  NUMBER
2189     , p_load_status  VARCHAR2
2190     , x_return_status out nocopy  VARCHAR2
2191     , x_msg_count out nocopy  NUMBER
2192     , x_msg_data out nocopy  VARCHAR2
2193     , x_loading_status out nocopy  VARCHAR2
2194     , p9_a0 out nocopy  NUMBER
2195     , p9_a1 out nocopy  VARCHAR2
2196     , p9_a2 out nocopy  VARCHAR2
2197     , p9_a3 out nocopy  NUMBER
2198     , p9_a4 out nocopy  VARCHAR2
2199     , p9_a5 out nocopy  VARCHAR2
2200     , p9_a6 out nocopy  VARCHAR2
2201     , p9_a7 out nocopy  VARCHAR2
2202     , p9_a8 out nocopy  VARCHAR2
2203     , p9_a9 out nocopy  VARCHAR2
2204     , p9_a10 out nocopy  VARCHAR2
2205     , p9_a11 out nocopy  NUMBER
2206     , p9_a12 out nocopy  VARCHAR2
2207     , p9_a13 out nocopy  VARCHAR2
2208     , p9_a14 out nocopy  VARCHAR2
2209     , p9_a15 out nocopy  VARCHAR2
2210     , p9_a16 out nocopy  VARCHAR2
2211     , p9_a17 out nocopy  VARCHAR2
2212     , p9_a18 out nocopy  VARCHAR2
2213     , p9_a19 out nocopy  NUMBER
2214     , p9_a20 out nocopy  VARCHAR2
2215     , p9_a21 out nocopy  NUMBER
2216     , p9_a22 out nocopy  VARCHAR2
2217   );
2218   procedure update_api_record(p_api_version  NUMBER
2219     , p_init_msg_list  VARCHAR2
2220     , p_validation_level  VARCHAR2
2221     , p3_a0  NUMBER
2222     , p3_a1  VARCHAR2
2223     , p3_a2  VARCHAR2
2224     , p3_a3  NUMBER
2225     , p3_a4  NUMBER
2226     , p3_a5  VARCHAR2
2227     , p3_a6  DATE
2228     , p3_a7  DATE
2229     , p3_a8  NUMBER
2230     , p3_a9  NUMBER
2231     , p3_a10  NUMBER
2232     , p3_a11  NUMBER
2233     , p3_a12  NUMBER
2234     , p3_a13  VARCHAR2
2235     , p3_a14  NUMBER
2236     , p3_a15  VARCHAR2
2237     , p3_a16  VARCHAR2
2238     , p3_a17  VARCHAR2
2239     , p3_a18  VARCHAR2
2240     , p3_a19  VARCHAR2
2241     , p3_a20  VARCHAR2
2242     , p3_a21  VARCHAR2
2243     , p3_a22  NUMBER
2244     , p3_a23  NUMBER
2245     , p3_a24  DATE
2246     , p3_a25  NUMBER
2247     , p3_a26  NUMBER
2248     , p3_a27  DATE
2249     , p3_a28  VARCHAR2
2250     , p3_a29  VARCHAR2
2251     , p3_a30  VARCHAR2
2252     , p3_a31  VARCHAR2
2253     , p3_a32  VARCHAR2
2254     , p3_a33  VARCHAR2
2255     , p3_a34  VARCHAR2
2256     , p3_a35  VARCHAR2
2257     , p3_a36  VARCHAR2
2258     , p3_a37  VARCHAR2
2259     , p3_a38  VARCHAR2
2260     , p3_a39  VARCHAR2
2261     , p3_a40  VARCHAR2
2262     , p3_a41  VARCHAR2
2263     , p3_a42  VARCHAR2
2264     , p3_a43  VARCHAR2
2265     , p3_a44  VARCHAR2
2266     , p3_a45  VARCHAR2
2267     , p3_a46  VARCHAR2
2268     , p3_a47  VARCHAR2
2269     , p3_a48  VARCHAR2
2270     , p3_a49  VARCHAR2
2271     , p3_a50  VARCHAR2
2272     , p3_a51  VARCHAR2
2273     , p3_a52  VARCHAR2
2274     , p3_a53  VARCHAR2
2275     , p3_a54  VARCHAR2
2276     , p3_a55  VARCHAR2
2277     , p3_a56  VARCHAR2
2278     , p3_a57  VARCHAR2
2279     , p3_a58  VARCHAR2
2280     , p3_a59  VARCHAR2
2281     , p3_a60  VARCHAR2
2282     , p3_a61  VARCHAR2
2283     , p3_a62  VARCHAR2
2284     , p3_a63  VARCHAR2
2285     , p3_a64  VARCHAR2
2286     , p3_a65  VARCHAR2
2287     , p3_a66  VARCHAR2
2288     , p3_a67  VARCHAR2
2289     , p3_a68  VARCHAR2
2290     , p3_a69  VARCHAR2
2291     , p3_a70  VARCHAR2
2292     , p3_a71  VARCHAR2
2293     , p3_a72  VARCHAR2
2294     , p3_a73  VARCHAR2
2295     , p3_a74  VARCHAR2
2296     , p3_a75  VARCHAR2
2297     , p3_a76  VARCHAR2
2298     , p3_a77  VARCHAR2
2299     , p3_a78  VARCHAR2
2300     , p3_a79  VARCHAR2
2301     , p3_a80  VARCHAR2
2302     , p3_a81  VARCHAR2
2303     , p3_a82  VARCHAR2
2304     , p3_a83  VARCHAR2
2305     , p3_a84  VARCHAR2
2306     , p3_a85  VARCHAR2
2307     , p3_a86  VARCHAR2
2308     , p3_a87  VARCHAR2
2309     , p3_a88  VARCHAR2
2310     , p3_a89  VARCHAR2
2311     , p3_a90  VARCHAR2
2312     , p3_a91  VARCHAR2
2313     , p3_a92  VARCHAR2
2314     , p3_a93  VARCHAR2
2315     , p3_a94  VARCHAR2
2316     , p3_a95  VARCHAR2
2317     , p3_a96  VARCHAR2
2318     , p3_a97  VARCHAR2
2319     , p3_a98  VARCHAR2
2320     , p3_a99  VARCHAR2
2321     , p3_a100  VARCHAR2
2322     , p3_a101  VARCHAR2
2323     , p3_a102  VARCHAR2
2324     , p3_a103  VARCHAR2
2325     , p3_a104  VARCHAR2
2326     , p3_a105  VARCHAR2
2327     , p3_a106  VARCHAR2
2328     , p3_a107  VARCHAR2
2329     , p3_a108  VARCHAR2
2330     , p3_a109  VARCHAR2
2331     , p3_a110  VARCHAR2
2332     , p3_a111  VARCHAR2
2333     , p3_a112  VARCHAR2
2334     , p3_a113  VARCHAR2
2335     , p3_a114  VARCHAR2
2336     , p3_a115  VARCHAR2
2337     , p3_a116  VARCHAR2
2338     , p3_a117  VARCHAR2
2339     , p3_a118  VARCHAR2
2340     , p3_a119  VARCHAR2
2341     , p3_a120  VARCHAR2
2342     , p3_a121  VARCHAR2
2343     , p3_a122  VARCHAR2
2344     , p3_a123  VARCHAR2
2345     , p3_a124  VARCHAR2
2346     , p3_a125  VARCHAR2
2347     , p3_a126  VARCHAR2
2348     , p3_a127  VARCHAR2
2349     , p3_a128  VARCHAR2
2350     , p3_a129  NUMBER
2351     , p3_a130  VARCHAR2
2352     , p3_a131  NUMBER
2353     , p3_a132  VARCHAR2
2354     , p3_a133  VARCHAR2
2355     , p3_a134  VARCHAR2
2356     , p3_a135  NUMBER
2357     , p3_a136  NUMBER
2358     , p3_a137  NUMBER
2359     , p3_a138  NUMBER
2360     , p3_a139  VARCHAR2
2361     , p3_a140  NUMBER
2362     , p3_a141  NUMBER
2363     , p3_a142  VARCHAR2
2364     , p3_a143  NUMBER
2365     , p3_a144  NUMBER
2366     , p3_a145  NUMBER
2367     , p3_a146  NUMBER
2368     , p3_a147  DATE
2369     , p3_a148  NUMBER
2370     , p3_a149  VARCHAR2
2371     , p3_a150  DATE
2372     , p3_a151  NUMBER
2373     , p3_a152  DATE
2374     , p3_a153  NUMBER
2375     , p3_a154  NUMBER
2376     , p3_a155  NUMBER
2377     , p3_a156  NUMBER
2378     , p3_a157  NUMBER
2379     , p3_a158  NUMBER
2380     , p3_a159  VARCHAR2
2381     , p3_a160  VARCHAR2
2382     , p3_a161  VARCHAR2
2383     , p3_a162  VARCHAR2
2384     , p3_a163  DATE
2385     , p3_a164  VARCHAR2
2386     , p3_a165  VARCHAR2
2387     , p3_a166  VARCHAR2
2388     , p3_a167  VARCHAR2
2389     , p3_a168  VARCHAR2
2390     , p3_a169  VARCHAR2
2391     , p3_a170  NUMBER
2392     , p3_a171  NUMBER
2393     , p3_a172  NUMBER
2394     , p3_a173  VARCHAR2
2395     , p3_a174  NUMBER
2396     , p3_a175  NUMBER
2397     , p3_a176  VARCHAR2
2398     , p3_a177  NUMBER
2399     , p3_a178  VARCHAR2
2400     , p3_a179  VARCHAR2
2401     , p3_a180  VARCHAR2
2402     , p3_a181  VARCHAR2
2403     , p3_a182  VARCHAR2
2404     , p3_a183  NUMBER
2405     , p3_a184  NUMBER
2406     , p3_a185  NUMBER
2407     , p3_a186  NUMBER
2408     , p3_a187  NUMBER
2409     , p3_a188  NUMBER
2410     , p3_a189  VARCHAR2
2411     , p3_a190  VARCHAR2
2412     , x_api_id out nocopy  NUMBER
2413     , x_return_status out nocopy  VARCHAR2
2414     , x_msg_count out nocopy  NUMBER
2415     , x_msg_data out nocopy  VARCHAR2
2416     , x_loading_status out nocopy  VARCHAR2
2417   );
2418 end cn_get_tx_data_pub_w;