DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CREDIT_PUB_W

Source


1 package okl_credit_pub_w AUTHID CURRENT_USER as
2   /* $Header: OKLUCRDS.pls 115.7 2003/08/29 22:45:55 cklee noship $ */
3   procedure rosetta_table_copy_in_p5(t out nocopy okl_credit_pub.clev_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_200
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_2000
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_DATE_TABLE
13     );
14   procedure rosetta_table_copy_out_p5(t okl_credit_pub.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15     , a1 out nocopy JTF_NUMBER_TABLE
16     , a2 out nocopy JTF_NUMBER_TABLE
17     , a3 out nocopy JTF_VARCHAR2_TABLE_200
18     , a4 out nocopy JTF_VARCHAR2_TABLE_100
19     , a5 out nocopy JTF_NUMBER_TABLE
20     , a6 out nocopy JTF_NUMBER_TABLE
21     , a7 out nocopy JTF_VARCHAR2_TABLE_2000
22     , a8 out nocopy JTF_VARCHAR2_TABLE_100
23     , a9 out nocopy JTF_DATE_TABLE
24     );
25 
26   procedure create_credit(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , x_return_status out nocopy  VARCHAR2
29     , x_msg_count out nocopy  NUMBER
30     , x_msg_data out nocopy  VARCHAR2
31     , p_contract_number  VARCHAR2
32     , p_description  VARCHAR2
33     , p_customer_id1  VARCHAR2
34     , p_customer_id2  VARCHAR2
35     , p_customer_code  VARCHAR2
36     , p_customer_name  VARCHAR2
37     , p_effective_from  date
38     , p_effective_to  date
39     , p_currency_code  VARCHAR2
40     , p_currency_conv_type  VARCHAR2
41     , p_currency_conv_rate  NUMBER
42     , p_currency_conv_date  date
43     , p_revolving_credit_yn  VARCHAR2
44     , p_sts_code  VARCHAR2
45     , p_credit_ckl_id  NUMBER
46     , p_funding_ckl_id  NUMBER
47     , p_cust_acct_id  NUMBER
48     , p_cust_acct_number  VARCHAR2
49     , p_org_id  NUMBER
50     , p_organization_id  NUMBER
51     , p_source_chr_id  NUMBER
52     , x_chr_id out nocopy  NUMBER
53   );
54   procedure create_credit_header(p_api_version  NUMBER
55     , p_init_msg_list  VARCHAR2
56     , x_return_status out nocopy  VARCHAR2
57     , x_msg_count out nocopy  NUMBER
58     , x_msg_data out nocopy  VARCHAR2
59     , p_credit_ckl_id  NUMBER
60     , p_funding_ckl_id  NUMBER
61     , p9_a0 out nocopy  NUMBER
62     , p9_a1 out nocopy  NUMBER
63     , p9_a2 out nocopy  VARCHAR2
64     , p9_a3 out nocopy  NUMBER
65     , p9_a4 out nocopy  NUMBER
66     , p9_a5 out nocopy  NUMBER
67     , p9_a6 out nocopy  NUMBER
68     , p9_a7 out nocopy  VARCHAR2
69     , p9_a8 out nocopy  NUMBER
70     , p9_a9 out nocopy  VARCHAR2
71     , p9_a10 out nocopy  VARCHAR2
72     , p9_a11 out nocopy  VARCHAR2
73     , p9_a12 out nocopy  VARCHAR2
74     , p9_a13 out nocopy  VARCHAR2
75     , p9_a14 out nocopy  VARCHAR2
76     , p9_a15 out nocopy  VARCHAR2
77     , p9_a16 out nocopy  VARCHAR2
78     , p9_a17 out nocopy  VARCHAR2
79     , p9_a18 out nocopy  VARCHAR2
80     , p9_a19 out nocopy  VARCHAR2
81     , p9_a20 out nocopy  VARCHAR2
82     , p9_a21 out nocopy  VARCHAR2
83     , p9_a22 out nocopy  VARCHAR2
84     , p9_a23 out nocopy  VARCHAR2
85     , p9_a24 out nocopy  VARCHAR2
86     , p9_a25 out nocopy  DATE
87     , p9_a26 out nocopy  DATE
88     , p9_a27 out nocopy  NUMBER
89     , p9_a28 out nocopy  DATE
90     , p9_a29 out nocopy  DATE
91     , p9_a30 out nocopy  VARCHAR2
92     , p9_a31 out nocopy  VARCHAR2
93     , p9_a32 out nocopy  VARCHAR2
94     , p9_a33 out nocopy  VARCHAR2
95     , p9_a34 out nocopy  VARCHAR2
96     , p9_a35 out nocopy  VARCHAR2
97     , p9_a36 out nocopy  NUMBER
98     , p9_a37 out nocopy  NUMBER
99     , p9_a38 out nocopy  DATE
100     , p9_a39 out nocopy  DATE
101     , p9_a40 out nocopy  DATE
102     , p9_a41 out nocopy  DATE
103     , p9_a42 out nocopy  DATE
104     , p9_a43 out nocopy  VARCHAR2
105     , p9_a44 out nocopy  DATE
106     , p9_a45 out nocopy  DATE
107     , p9_a46 out nocopy  NUMBER
108     , p9_a47 out nocopy  VARCHAR2
109     , p9_a48 out nocopy  VARCHAR2
110     , p9_a49 out nocopy  NUMBER
111     , p9_a50 out nocopy  NUMBER
112     , p9_a51 out nocopy  NUMBER
113     , p9_a52 out nocopy  VARCHAR2
114     , p9_a53 out nocopy  VARCHAR2
115     , p9_a54 out nocopy  NUMBER
116     , p9_a55 out nocopy  NUMBER
117     , p9_a56 out nocopy  VARCHAR2
118     , p9_a57 out nocopy  NUMBER
119     , p9_a58 out nocopy  VARCHAR2
120     , p9_a59 out nocopy  NUMBER
121     , p9_a60 out nocopy  NUMBER
122     , p9_a61 out nocopy  NUMBER
123     , p9_a62 out nocopy  DATE
124     , p9_a63 out nocopy  DATE
125     , p9_a64 out nocopy  DATE
126     , p9_a65 out nocopy  NUMBER
127     , p9_a66 out nocopy  NUMBER
128     , p9_a67 out nocopy  NUMBER
129     , p9_a68 out nocopy  VARCHAR2
130     , p9_a69 out nocopy  VARCHAR2
131     , p9_a70 out nocopy  VARCHAR2
132     , p9_a71 out nocopy  VARCHAR2
133     , p9_a72 out nocopy  VARCHAR2
134     , p9_a73 out nocopy  VARCHAR2
135     , p9_a74 out nocopy  VARCHAR2
136     , p9_a75 out nocopy  VARCHAR2
137     , p9_a76 out nocopy  VARCHAR2
138     , p9_a77 out nocopy  VARCHAR2
139     , p9_a78 out nocopy  VARCHAR2
140     , p9_a79 out nocopy  VARCHAR2
141     , p9_a80 out nocopy  VARCHAR2
142     , p9_a81 out nocopy  VARCHAR2
143     , p9_a82 out nocopy  VARCHAR2
144     , p9_a83 out nocopy  VARCHAR2
145     , p9_a84 out nocopy  NUMBER
146     , p9_a85 out nocopy  DATE
147     , p9_a86 out nocopy  NUMBER
148     , p9_a87 out nocopy  DATE
149     , p9_a88 out nocopy  NUMBER
150     , p9_a89 out nocopy  VARCHAR2
151     , p9_a90 out nocopy  VARCHAR2
152     , p9_a91 out nocopy  VARCHAR2
153     , p9_a92 out nocopy  VARCHAR2
154     , p9_a93 out nocopy  VARCHAR2
155     , p9_a94 out nocopy  NUMBER
156     , p9_a95 out nocopy  DATE
157     , p9_a96 out nocopy  NUMBER
158     , p9_a97 out nocopy  NUMBER
159     , p9_a98 out nocopy  NUMBER
160     , p9_a99 out nocopy  NUMBER
161     , p9_a100 out nocopy  VARCHAR2
162     , p9_a101 out nocopy  NUMBER
163     , p9_a102 out nocopy  DATE
164     , p9_a103 out nocopy  NUMBER
165     , p9_a104 out nocopy  NUMBER
166     , p10_a0 out nocopy  NUMBER
167     , p10_a1 out nocopy  NUMBER
168     , p10_a2 out nocopy  NUMBER
169     , p10_a3 out nocopy  NUMBER
170     , p10_a4 out nocopy  NUMBER
171     , p10_a5 out nocopy  VARCHAR2
172     , p10_a6 out nocopy  DATE
173     , p10_a7 out nocopy  VARCHAR2
174     , p10_a8 out nocopy  VARCHAR2
175     , p10_a9 out nocopy  DATE
176     , p10_a10 out nocopy  VARCHAR2
177     , p10_a11 out nocopy  NUMBER
178     , p10_a12 out nocopy  VARCHAR2
179     , p10_a13 out nocopy  DATE
180     , p10_a14 out nocopy  VARCHAR2
181     , p10_a15 out nocopy  VARCHAR2
182     , p10_a16 out nocopy  DATE
183     , p10_a17 out nocopy  DATE
184     , p10_a18 out nocopy  DATE
185     , p10_a19 out nocopy  DATE
186     , p10_a20 out nocopy  VARCHAR2
187     , p10_a21 out nocopy  VARCHAR2
188     , p10_a22 out nocopy  VARCHAR2
189     , p10_a23 out nocopy  VARCHAR2
190     , p10_a24 out nocopy  VARCHAR2
191     , p10_a25 out nocopy  VARCHAR2
192     , p10_a26 out nocopy  VARCHAR2
193     , p10_a27 out nocopy  VARCHAR2
194     , p10_a28 out nocopy  VARCHAR2
195     , p10_a29 out nocopy  VARCHAR2
196     , p10_a30 out nocopy  VARCHAR2
197     , p10_a31 out nocopy  VARCHAR2
198     , p10_a32 out nocopy  VARCHAR2
199     , p10_a33 out nocopy  VARCHAR2
200     , p10_a34 out nocopy  VARCHAR2
201     , p10_a35 out nocopy  VARCHAR2
202     , p10_a36 out nocopy  NUMBER
203     , p10_a37 out nocopy  DATE
204     , p10_a38 out nocopy  NUMBER
205     , p10_a39 out nocopy  DATE
206     , p10_a40 out nocopy  NUMBER
207     , p10_a41 out nocopy  NUMBER
208     , p10_a42 out nocopy  NUMBER
209     , p10_a43 out nocopy  NUMBER
210     , p10_a44 out nocopy  NUMBER
211     , p10_a45 out nocopy  NUMBER
212     , p10_a46 out nocopy  NUMBER
213     , p10_a47 out nocopy  NUMBER
214     , p10_a48 out nocopy  NUMBER
215     , p10_a49 out nocopy  DATE
216     , p10_a50 out nocopy  VARCHAR2
217     , p10_a51 out nocopy  NUMBER
218     , p10_a52 out nocopy  NUMBER
219     , p10_a53 out nocopy  DATE
220     , p10_a54 out nocopy  DATE
221     , p10_a55 out nocopy  VARCHAR2
222     , p10_a56 out nocopy  VARCHAR2
223     , p10_a57 out nocopy  VARCHAR2
224     , p10_a58 out nocopy  NUMBER
225     , p10_a59 out nocopy  DATE
226     , p10_a60 out nocopy  VARCHAR2
227     , p10_a61 out nocopy  VARCHAR2
228     , p10_a62 out nocopy  VARCHAR2
229     , p10_a63 out nocopy  VARCHAR2
230     , p10_a64 out nocopy  VARCHAR2
231     , p10_a65 out nocopy  VARCHAR2
232     , p7_a0  NUMBER := 0-1962.0724
233     , p7_a1  NUMBER := 0-1962.0724
234     , p7_a2  VARCHAR2 := fnd_api.g_miss_char
235     , p7_a3  NUMBER := 0-1962.0724
236     , p7_a4  NUMBER := 0-1962.0724
237     , p7_a5  NUMBER := 0-1962.0724
238     , p7_a6  NUMBER := 0-1962.0724
239     , p7_a7  VARCHAR2 := fnd_api.g_miss_char
240     , p7_a8  NUMBER := 0-1962.0724
241     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
242     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
243     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
244     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
245     , p7_a13  VARCHAR2 := fnd_api.g_miss_char
246     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
247     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
248     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
249     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
250     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
251     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
252     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
253     , p7_a21  VARCHAR2 := fnd_api.g_miss_char
254     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
255     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
256     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
257     , p7_a25  DATE := fnd_api.g_miss_date
258     , p7_a26  DATE := fnd_api.g_miss_date
259     , p7_a27  NUMBER := 0-1962.0724
260     , p7_a28  DATE := fnd_api.g_miss_date
261     , p7_a29  DATE := fnd_api.g_miss_date
262     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
263     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
264     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
265     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
266     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
267     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
268     , p7_a36  NUMBER := 0-1962.0724
269     , p7_a37  NUMBER := 0-1962.0724
270     , p7_a38  DATE := fnd_api.g_miss_date
271     , p7_a39  DATE := fnd_api.g_miss_date
272     , p7_a40  DATE := fnd_api.g_miss_date
273     , p7_a41  DATE := fnd_api.g_miss_date
274     , p7_a42  DATE := fnd_api.g_miss_date
275     , p7_a43  VARCHAR2 := fnd_api.g_miss_char
276     , p7_a44  DATE := fnd_api.g_miss_date
277     , p7_a45  DATE := fnd_api.g_miss_date
278     , p7_a46  NUMBER := 0-1962.0724
279     , p7_a47  VARCHAR2 := fnd_api.g_miss_char
280     , p7_a48  VARCHAR2 := fnd_api.g_miss_char
281     , p7_a49  NUMBER := 0-1962.0724
282     , p7_a50  NUMBER := 0-1962.0724
283     , p7_a51  NUMBER := 0-1962.0724
284     , p7_a52  VARCHAR2 := fnd_api.g_miss_char
285     , p7_a53  VARCHAR2 := fnd_api.g_miss_char
286     , p7_a54  NUMBER := 0-1962.0724
287     , p7_a55  NUMBER := 0-1962.0724
288     , p7_a56  VARCHAR2 := fnd_api.g_miss_char
289     , p7_a57  NUMBER := 0-1962.0724
290     , p7_a58  VARCHAR2 := fnd_api.g_miss_char
291     , p7_a59  NUMBER := 0-1962.0724
292     , p7_a60  NUMBER := 0-1962.0724
293     , p7_a61  NUMBER := 0-1962.0724
294     , p7_a62  DATE := fnd_api.g_miss_date
295     , p7_a63  DATE := fnd_api.g_miss_date
296     , p7_a64  DATE := fnd_api.g_miss_date
297     , p7_a65  NUMBER := 0-1962.0724
298     , p7_a66  NUMBER := 0-1962.0724
299     , p7_a67  NUMBER := 0-1962.0724
300     , p7_a68  VARCHAR2 := fnd_api.g_miss_char
301     , p7_a69  VARCHAR2 := fnd_api.g_miss_char
302     , p7_a70  VARCHAR2 := fnd_api.g_miss_char
303     , p7_a71  VARCHAR2 := fnd_api.g_miss_char
304     , p7_a72  VARCHAR2 := fnd_api.g_miss_char
305     , p7_a73  VARCHAR2 := fnd_api.g_miss_char
306     , p7_a74  VARCHAR2 := fnd_api.g_miss_char
307     , p7_a75  VARCHAR2 := fnd_api.g_miss_char
308     , p7_a76  VARCHAR2 := fnd_api.g_miss_char
309     , p7_a77  VARCHAR2 := fnd_api.g_miss_char
310     , p7_a78  VARCHAR2 := fnd_api.g_miss_char
311     , p7_a79  VARCHAR2 := fnd_api.g_miss_char
312     , p7_a80  VARCHAR2 := fnd_api.g_miss_char
313     , p7_a81  VARCHAR2 := fnd_api.g_miss_char
314     , p7_a82  VARCHAR2 := fnd_api.g_miss_char
315     , p7_a83  VARCHAR2 := fnd_api.g_miss_char
316     , p7_a84  NUMBER := 0-1962.0724
317     , p7_a85  DATE := fnd_api.g_miss_date
318     , p7_a86  NUMBER := 0-1962.0724
319     , p7_a87  DATE := fnd_api.g_miss_date
320     , p7_a88  NUMBER := 0-1962.0724
321     , p7_a89  VARCHAR2 := fnd_api.g_miss_char
322     , p7_a90  VARCHAR2 := fnd_api.g_miss_char
323     , p7_a91  VARCHAR2 := fnd_api.g_miss_char
324     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
325     , p7_a93  VARCHAR2 := fnd_api.g_miss_char
326     , p7_a94  NUMBER := 0-1962.0724
327     , p7_a95  DATE := fnd_api.g_miss_date
328     , p7_a96  NUMBER := 0-1962.0724
329     , p7_a97  NUMBER := 0-1962.0724
330     , p7_a98  NUMBER := 0-1962.0724
331     , p7_a99  NUMBER := 0-1962.0724
332     , p7_a100  VARCHAR2 := fnd_api.g_miss_char
333     , p7_a101  NUMBER := 0-1962.0724
334     , p7_a102  DATE := fnd_api.g_miss_date
335     , p7_a103  NUMBER := 0-1962.0724
336     , p7_a104  NUMBER := 0-1962.0724
337     , p8_a0  NUMBER := 0-1962.0724
338     , p8_a1  NUMBER := 0-1962.0724
339     , p8_a2  NUMBER := 0-1962.0724
340     , p8_a3  NUMBER := 0-1962.0724
341     , p8_a4  NUMBER := 0-1962.0724
342     , p8_a5  VARCHAR2 := fnd_api.g_miss_char
343     , p8_a6  DATE := fnd_api.g_miss_date
344     , p8_a7  VARCHAR2 := fnd_api.g_miss_char
345     , p8_a8  VARCHAR2 := fnd_api.g_miss_char
346     , p8_a9  DATE := fnd_api.g_miss_date
347     , p8_a10  VARCHAR2 := fnd_api.g_miss_char
348     , p8_a11  NUMBER := 0-1962.0724
349     , p8_a12  VARCHAR2 := fnd_api.g_miss_char
350     , p8_a13  DATE := fnd_api.g_miss_date
351     , p8_a14  VARCHAR2 := fnd_api.g_miss_char
352     , p8_a15  VARCHAR2 := fnd_api.g_miss_char
353     , p8_a16  DATE := fnd_api.g_miss_date
354     , p8_a17  DATE := fnd_api.g_miss_date
355     , p8_a18  DATE := fnd_api.g_miss_date
356     , p8_a19  DATE := fnd_api.g_miss_date
357     , p8_a20  VARCHAR2 := fnd_api.g_miss_char
358     , p8_a21  VARCHAR2 := fnd_api.g_miss_char
359     , p8_a22  VARCHAR2 := fnd_api.g_miss_char
360     , p8_a23  VARCHAR2 := fnd_api.g_miss_char
361     , p8_a24  VARCHAR2 := fnd_api.g_miss_char
362     , p8_a25  VARCHAR2 := fnd_api.g_miss_char
363     , p8_a26  VARCHAR2 := fnd_api.g_miss_char
364     , p8_a27  VARCHAR2 := fnd_api.g_miss_char
365     , p8_a28  VARCHAR2 := fnd_api.g_miss_char
366     , p8_a29  VARCHAR2 := fnd_api.g_miss_char
367     , p8_a30  VARCHAR2 := fnd_api.g_miss_char
368     , p8_a31  VARCHAR2 := fnd_api.g_miss_char
369     , p8_a32  VARCHAR2 := fnd_api.g_miss_char
370     , p8_a33  VARCHAR2 := fnd_api.g_miss_char
371     , p8_a34  VARCHAR2 := fnd_api.g_miss_char
372     , p8_a35  VARCHAR2 := fnd_api.g_miss_char
373     , p8_a36  NUMBER := 0-1962.0724
374     , p8_a37  DATE := fnd_api.g_miss_date
375     , p8_a38  NUMBER := 0-1962.0724
376     , p8_a39  DATE := fnd_api.g_miss_date
377     , p8_a40  NUMBER := 0-1962.0724
378     , p8_a41  NUMBER := 0-1962.0724
379     , p8_a42  NUMBER := 0-1962.0724
380     , p8_a43  NUMBER := 0-1962.0724
381     , p8_a44  NUMBER := 0-1962.0724
382     , p8_a45  NUMBER := 0-1962.0724
383     , p8_a46  NUMBER := 0-1962.0724
384     , p8_a47  NUMBER := 0-1962.0724
385     , p8_a48  NUMBER := 0-1962.0724
386     , p8_a49  DATE := fnd_api.g_miss_date
387     , p8_a50  VARCHAR2 := fnd_api.g_miss_char
388     , p8_a51  NUMBER := 0-1962.0724
389     , p8_a52  NUMBER := 0-1962.0724
390     , p8_a53  DATE := fnd_api.g_miss_date
391     , p8_a54  DATE := fnd_api.g_miss_date
392     , p8_a55  VARCHAR2 := fnd_api.g_miss_char
393     , p8_a56  VARCHAR2 := fnd_api.g_miss_char
394     , p8_a57  VARCHAR2 := fnd_api.g_miss_char
395     , p8_a58  NUMBER := 0-1962.0724
396     , p8_a59  DATE := fnd_api.g_miss_date
397     , p8_a60  VARCHAR2 := fnd_api.g_miss_char
398     , p8_a61  VARCHAR2 := fnd_api.g_miss_char
399     , p8_a62  VARCHAR2 := fnd_api.g_miss_char
400     , p8_a63  VARCHAR2 := fnd_api.g_miss_char
401     , p8_a64  VARCHAR2 := fnd_api.g_miss_char
402     , p8_a65  VARCHAR2 := fnd_api.g_miss_char
403   );
404   procedure update_credit_header(p_api_version  NUMBER
405     , p_init_msg_list  VARCHAR2
406     , x_return_status out nocopy  VARCHAR2
407     , x_msg_count out nocopy  NUMBER
408     , x_msg_data out nocopy  VARCHAR2
409     , p_restricted_update  VARCHAR2
410     , p_chklst_tpl_rgp_id  NUMBER
411     , p_chklst_tpl_rule_id  NUMBER
412     , p_credit_ckl_id  NUMBER
413     , p_funding_ckl_id  NUMBER
414     , p12_a0 out nocopy  NUMBER
415     , p12_a1 out nocopy  NUMBER
416     , p12_a2 out nocopy  VARCHAR2
417     , p12_a3 out nocopy  NUMBER
418     , p12_a4 out nocopy  NUMBER
419     , p12_a5 out nocopy  NUMBER
420     , p12_a6 out nocopy  NUMBER
421     , p12_a7 out nocopy  VARCHAR2
422     , p12_a8 out nocopy  NUMBER
423     , p12_a9 out nocopy  VARCHAR2
424     , p12_a10 out nocopy  VARCHAR2
425     , p12_a11 out nocopy  VARCHAR2
426     , p12_a12 out nocopy  VARCHAR2
427     , p12_a13 out nocopy  VARCHAR2
428     , p12_a14 out nocopy  VARCHAR2
429     , p12_a15 out nocopy  VARCHAR2
430     , p12_a16 out nocopy  VARCHAR2
431     , p12_a17 out nocopy  VARCHAR2
432     , p12_a18 out nocopy  VARCHAR2
433     , p12_a19 out nocopy  VARCHAR2
434     , p12_a20 out nocopy  VARCHAR2
435     , p12_a21 out nocopy  VARCHAR2
436     , p12_a22 out nocopy  VARCHAR2
437     , p12_a23 out nocopy  VARCHAR2
438     , p12_a24 out nocopy  VARCHAR2
439     , p12_a25 out nocopy  DATE
440     , p12_a26 out nocopy  DATE
441     , p12_a27 out nocopy  NUMBER
442     , p12_a28 out nocopy  DATE
443     , p12_a29 out nocopy  DATE
444     , p12_a30 out nocopy  VARCHAR2
445     , p12_a31 out nocopy  VARCHAR2
446     , p12_a32 out nocopy  VARCHAR2
447     , p12_a33 out nocopy  VARCHAR2
448     , p12_a34 out nocopy  VARCHAR2
449     , p12_a35 out nocopy  VARCHAR2
450     , p12_a36 out nocopy  NUMBER
451     , p12_a37 out nocopy  NUMBER
452     , p12_a38 out nocopy  DATE
453     , p12_a39 out nocopy  DATE
454     , p12_a40 out nocopy  DATE
455     , p12_a41 out nocopy  DATE
456     , p12_a42 out nocopy  DATE
457     , p12_a43 out nocopy  VARCHAR2
458     , p12_a44 out nocopy  DATE
459     , p12_a45 out nocopy  DATE
460     , p12_a46 out nocopy  NUMBER
461     , p12_a47 out nocopy  VARCHAR2
462     , p12_a48 out nocopy  VARCHAR2
463     , p12_a49 out nocopy  NUMBER
464     , p12_a50 out nocopy  NUMBER
465     , p12_a51 out nocopy  NUMBER
466     , p12_a52 out nocopy  VARCHAR2
467     , p12_a53 out nocopy  VARCHAR2
468     , p12_a54 out nocopy  NUMBER
469     , p12_a55 out nocopy  NUMBER
470     , p12_a56 out nocopy  VARCHAR2
471     , p12_a57 out nocopy  NUMBER
472     , p12_a58 out nocopy  VARCHAR2
473     , p12_a59 out nocopy  NUMBER
474     , p12_a60 out nocopy  NUMBER
475     , p12_a61 out nocopy  NUMBER
476     , p12_a62 out nocopy  DATE
477     , p12_a63 out nocopy  DATE
478     , p12_a64 out nocopy  DATE
479     , p12_a65 out nocopy  NUMBER
480     , p12_a66 out nocopy  NUMBER
481     , p12_a67 out nocopy  NUMBER
482     , p12_a68 out nocopy  VARCHAR2
483     , p12_a69 out nocopy  VARCHAR2
484     , p12_a70 out nocopy  VARCHAR2
485     , p12_a71 out nocopy  VARCHAR2
486     , p12_a72 out nocopy  VARCHAR2
487     , p12_a73 out nocopy  VARCHAR2
488     , p12_a74 out nocopy  VARCHAR2
489     , p12_a75 out nocopy  VARCHAR2
490     , p12_a76 out nocopy  VARCHAR2
491     , p12_a77 out nocopy  VARCHAR2
492     , p12_a78 out nocopy  VARCHAR2
493     , p12_a79 out nocopy  VARCHAR2
494     , p12_a80 out nocopy  VARCHAR2
495     , p12_a81 out nocopy  VARCHAR2
496     , p12_a82 out nocopy  VARCHAR2
497     , p12_a83 out nocopy  VARCHAR2
498     , p12_a84 out nocopy  NUMBER
499     , p12_a85 out nocopy  DATE
500     , p12_a86 out nocopy  NUMBER
501     , p12_a87 out nocopy  DATE
502     , p12_a88 out nocopy  NUMBER
503     , p12_a89 out nocopy  VARCHAR2
504     , p12_a90 out nocopy  VARCHAR2
505     , p12_a91 out nocopy  VARCHAR2
506     , p12_a92 out nocopy  VARCHAR2
507     , p12_a93 out nocopy  VARCHAR2
508     , p12_a94 out nocopy  NUMBER
509     , p12_a95 out nocopy  DATE
510     , p12_a96 out nocopy  NUMBER
511     , p12_a97 out nocopy  NUMBER
512     , p12_a98 out nocopy  NUMBER
513     , p12_a99 out nocopy  NUMBER
514     , p12_a100 out nocopy  VARCHAR2
515     , p12_a101 out nocopy  NUMBER
516     , p12_a102 out nocopy  DATE
517     , p12_a103 out nocopy  NUMBER
518     , p12_a104 out nocopy  NUMBER
519     , p13_a0 out nocopy  NUMBER
520     , p13_a1 out nocopy  NUMBER
521     , p13_a2 out nocopy  NUMBER
522     , p13_a3 out nocopy  NUMBER
523     , p13_a4 out nocopy  NUMBER
524     , p13_a5 out nocopy  VARCHAR2
525     , p13_a6 out nocopy  DATE
526     , p13_a7 out nocopy  VARCHAR2
527     , p13_a8 out nocopy  VARCHAR2
528     , p13_a9 out nocopy  DATE
529     , p13_a10 out nocopy  VARCHAR2
530     , p13_a11 out nocopy  NUMBER
531     , p13_a12 out nocopy  VARCHAR2
532     , p13_a13 out nocopy  DATE
533     , p13_a14 out nocopy  VARCHAR2
534     , p13_a15 out nocopy  VARCHAR2
535     , p13_a16 out nocopy  DATE
536     , p13_a17 out nocopy  DATE
537     , p13_a18 out nocopy  DATE
538     , p13_a19 out nocopy  DATE
539     , p13_a20 out nocopy  VARCHAR2
540     , p13_a21 out nocopy  VARCHAR2
541     , p13_a22 out nocopy  VARCHAR2
542     , p13_a23 out nocopy  VARCHAR2
543     , p13_a24 out nocopy  VARCHAR2
544     , p13_a25 out nocopy  VARCHAR2
545     , p13_a26 out nocopy  VARCHAR2
546     , p13_a27 out nocopy  VARCHAR2
547     , p13_a28 out nocopy  VARCHAR2
548     , p13_a29 out nocopy  VARCHAR2
549     , p13_a30 out nocopy  VARCHAR2
550     , p13_a31 out nocopy  VARCHAR2
551     , p13_a32 out nocopy  VARCHAR2
552     , p13_a33 out nocopy  VARCHAR2
553     , p13_a34 out nocopy  VARCHAR2
554     , p13_a35 out nocopy  VARCHAR2
555     , p13_a36 out nocopy  NUMBER
556     , p13_a37 out nocopy  DATE
557     , p13_a38 out nocopy  NUMBER
558     , p13_a39 out nocopy  DATE
559     , p13_a40 out nocopy  NUMBER
560     , p13_a41 out nocopy  NUMBER
561     , p13_a42 out nocopy  NUMBER
562     , p13_a43 out nocopy  NUMBER
563     , p13_a44 out nocopy  NUMBER
564     , p13_a45 out nocopy  NUMBER
565     , p13_a46 out nocopy  NUMBER
566     , p13_a47 out nocopy  NUMBER
567     , p13_a48 out nocopy  NUMBER
568     , p13_a49 out nocopy  DATE
569     , p13_a50 out nocopy  VARCHAR2
570     , p13_a51 out nocopy  NUMBER
571     , p13_a52 out nocopy  NUMBER
572     , p13_a53 out nocopy  DATE
573     , p13_a54 out nocopy  DATE
574     , p13_a55 out nocopy  VARCHAR2
575     , p13_a56 out nocopy  VARCHAR2
576     , p13_a57 out nocopy  VARCHAR2
577     , p13_a58 out nocopy  NUMBER
578     , p13_a59 out nocopy  DATE
579     , p13_a60 out nocopy  VARCHAR2
580     , p13_a61 out nocopy  VARCHAR2
581     , p13_a62 out nocopy  VARCHAR2
582     , p13_a63 out nocopy  VARCHAR2
583     , p13_a64 out nocopy  VARCHAR2
584     , p13_a65 out nocopy  VARCHAR2
585     , p10_a0  NUMBER := 0-1962.0724
586     , p10_a1  NUMBER := 0-1962.0724
587     , p10_a2  VARCHAR2 := fnd_api.g_miss_char
588     , p10_a3  NUMBER := 0-1962.0724
589     , p10_a4  NUMBER := 0-1962.0724
590     , p10_a5  NUMBER := 0-1962.0724
591     , p10_a6  NUMBER := 0-1962.0724
592     , p10_a7  VARCHAR2 := fnd_api.g_miss_char
593     , p10_a8  NUMBER := 0-1962.0724
594     , p10_a9  VARCHAR2 := fnd_api.g_miss_char
595     , p10_a10  VARCHAR2 := fnd_api.g_miss_char
596     , p10_a11  VARCHAR2 := fnd_api.g_miss_char
597     , p10_a12  VARCHAR2 := fnd_api.g_miss_char
598     , p10_a13  VARCHAR2 := fnd_api.g_miss_char
599     , p10_a14  VARCHAR2 := fnd_api.g_miss_char
600     , p10_a15  VARCHAR2 := fnd_api.g_miss_char
601     , p10_a16  VARCHAR2 := fnd_api.g_miss_char
602     , p10_a17  VARCHAR2 := fnd_api.g_miss_char
603     , p10_a18  VARCHAR2 := fnd_api.g_miss_char
604     , p10_a19  VARCHAR2 := fnd_api.g_miss_char
605     , p10_a20  VARCHAR2 := fnd_api.g_miss_char
606     , p10_a21  VARCHAR2 := fnd_api.g_miss_char
607     , p10_a22  VARCHAR2 := fnd_api.g_miss_char
608     , p10_a23  VARCHAR2 := fnd_api.g_miss_char
609     , p10_a24  VARCHAR2 := fnd_api.g_miss_char
610     , p10_a25  DATE := fnd_api.g_miss_date
611     , p10_a26  DATE := fnd_api.g_miss_date
612     , p10_a27  NUMBER := 0-1962.0724
613     , p10_a28  DATE := fnd_api.g_miss_date
614     , p10_a29  DATE := fnd_api.g_miss_date
615     , p10_a30  VARCHAR2 := fnd_api.g_miss_char
616     , p10_a31  VARCHAR2 := fnd_api.g_miss_char
617     , p10_a32  VARCHAR2 := fnd_api.g_miss_char
618     , p10_a33  VARCHAR2 := fnd_api.g_miss_char
619     , p10_a34  VARCHAR2 := fnd_api.g_miss_char
620     , p10_a35  VARCHAR2 := fnd_api.g_miss_char
621     , p10_a36  NUMBER := 0-1962.0724
622     , p10_a37  NUMBER := 0-1962.0724
623     , p10_a38  DATE := fnd_api.g_miss_date
624     , p10_a39  DATE := fnd_api.g_miss_date
625     , p10_a40  DATE := fnd_api.g_miss_date
626     , p10_a41  DATE := fnd_api.g_miss_date
627     , p10_a42  DATE := fnd_api.g_miss_date
628     , p10_a43  VARCHAR2 := fnd_api.g_miss_char
629     , p10_a44  DATE := fnd_api.g_miss_date
630     , p10_a45  DATE := fnd_api.g_miss_date
631     , p10_a46  NUMBER := 0-1962.0724
632     , p10_a47  VARCHAR2 := fnd_api.g_miss_char
633     , p10_a48  VARCHAR2 := fnd_api.g_miss_char
634     , p10_a49  NUMBER := 0-1962.0724
635     , p10_a50  NUMBER := 0-1962.0724
636     , p10_a51  NUMBER := 0-1962.0724
637     , p10_a52  VARCHAR2 := fnd_api.g_miss_char
638     , p10_a53  VARCHAR2 := fnd_api.g_miss_char
639     , p10_a54  NUMBER := 0-1962.0724
640     , p10_a55  NUMBER := 0-1962.0724
641     , p10_a56  VARCHAR2 := fnd_api.g_miss_char
642     , p10_a57  NUMBER := 0-1962.0724
643     , p10_a58  VARCHAR2 := fnd_api.g_miss_char
644     , p10_a59  NUMBER := 0-1962.0724
645     , p10_a60  NUMBER := 0-1962.0724
646     , p10_a61  NUMBER := 0-1962.0724
647     , p10_a62  DATE := fnd_api.g_miss_date
648     , p10_a63  DATE := fnd_api.g_miss_date
649     , p10_a64  DATE := fnd_api.g_miss_date
650     , p10_a65  NUMBER := 0-1962.0724
651     , p10_a66  NUMBER := 0-1962.0724
652     , p10_a67  NUMBER := 0-1962.0724
653     , p10_a68  VARCHAR2 := fnd_api.g_miss_char
654     , p10_a69  VARCHAR2 := fnd_api.g_miss_char
655     , p10_a70  VARCHAR2 := fnd_api.g_miss_char
656     , p10_a71  VARCHAR2 := fnd_api.g_miss_char
657     , p10_a72  VARCHAR2 := fnd_api.g_miss_char
658     , p10_a73  VARCHAR2 := fnd_api.g_miss_char
659     , p10_a74  VARCHAR2 := fnd_api.g_miss_char
660     , p10_a75  VARCHAR2 := fnd_api.g_miss_char
661     , p10_a76  VARCHAR2 := fnd_api.g_miss_char
662     , p10_a77  VARCHAR2 := fnd_api.g_miss_char
663     , p10_a78  VARCHAR2 := fnd_api.g_miss_char
664     , p10_a79  VARCHAR2 := fnd_api.g_miss_char
665     , p10_a80  VARCHAR2 := fnd_api.g_miss_char
666     , p10_a81  VARCHAR2 := fnd_api.g_miss_char
667     , p10_a82  VARCHAR2 := fnd_api.g_miss_char
668     , p10_a83  VARCHAR2 := fnd_api.g_miss_char
669     , p10_a84  NUMBER := 0-1962.0724
670     , p10_a85  DATE := fnd_api.g_miss_date
671     , p10_a86  NUMBER := 0-1962.0724
672     , p10_a87  DATE := fnd_api.g_miss_date
673     , p10_a88  NUMBER := 0-1962.0724
674     , p10_a89  VARCHAR2 := fnd_api.g_miss_char
675     , p10_a90  VARCHAR2 := fnd_api.g_miss_char
676     , p10_a91  VARCHAR2 := fnd_api.g_miss_char
677     , p10_a92  VARCHAR2 := fnd_api.g_miss_char
678     , p10_a93  VARCHAR2 := fnd_api.g_miss_char
679     , p10_a94  NUMBER := 0-1962.0724
680     , p10_a95  DATE := fnd_api.g_miss_date
681     , p10_a96  NUMBER := 0-1962.0724
682     , p10_a97  NUMBER := 0-1962.0724
683     , p10_a98  NUMBER := 0-1962.0724
684     , p10_a99  NUMBER := 0-1962.0724
685     , p10_a100  VARCHAR2 := fnd_api.g_miss_char
686     , p10_a101  NUMBER := 0-1962.0724
687     , p10_a102  DATE := fnd_api.g_miss_date
688     , p10_a103  NUMBER := 0-1962.0724
689     , p10_a104  NUMBER := 0-1962.0724
690     , p11_a0  NUMBER := 0-1962.0724
691     , p11_a1  NUMBER := 0-1962.0724
692     , p11_a2  NUMBER := 0-1962.0724
693     , p11_a3  NUMBER := 0-1962.0724
694     , p11_a4  NUMBER := 0-1962.0724
695     , p11_a5  VARCHAR2 := fnd_api.g_miss_char
696     , p11_a6  DATE := fnd_api.g_miss_date
697     , p11_a7  VARCHAR2 := fnd_api.g_miss_char
698     , p11_a8  VARCHAR2 := fnd_api.g_miss_char
699     , p11_a9  DATE := fnd_api.g_miss_date
700     , p11_a10  VARCHAR2 := fnd_api.g_miss_char
701     , p11_a11  NUMBER := 0-1962.0724
702     , p11_a12  VARCHAR2 := fnd_api.g_miss_char
703     , p11_a13  DATE := fnd_api.g_miss_date
704     , p11_a14  VARCHAR2 := fnd_api.g_miss_char
705     , p11_a15  VARCHAR2 := fnd_api.g_miss_char
706     , p11_a16  DATE := fnd_api.g_miss_date
707     , p11_a17  DATE := fnd_api.g_miss_date
708     , p11_a18  DATE := fnd_api.g_miss_date
709     , p11_a19  DATE := fnd_api.g_miss_date
710     , p11_a20  VARCHAR2 := fnd_api.g_miss_char
711     , p11_a21  VARCHAR2 := fnd_api.g_miss_char
712     , p11_a22  VARCHAR2 := fnd_api.g_miss_char
713     , p11_a23  VARCHAR2 := fnd_api.g_miss_char
714     , p11_a24  VARCHAR2 := fnd_api.g_miss_char
715     , p11_a25  VARCHAR2 := fnd_api.g_miss_char
716     , p11_a26  VARCHAR2 := fnd_api.g_miss_char
717     , p11_a27  VARCHAR2 := fnd_api.g_miss_char
718     , p11_a28  VARCHAR2 := fnd_api.g_miss_char
719     , p11_a29  VARCHAR2 := fnd_api.g_miss_char
720     , p11_a30  VARCHAR2 := fnd_api.g_miss_char
721     , p11_a31  VARCHAR2 := fnd_api.g_miss_char
722     , p11_a32  VARCHAR2 := fnd_api.g_miss_char
723     , p11_a33  VARCHAR2 := fnd_api.g_miss_char
724     , p11_a34  VARCHAR2 := fnd_api.g_miss_char
725     , p11_a35  VARCHAR2 := fnd_api.g_miss_char
726     , p11_a36  NUMBER := 0-1962.0724
727     , p11_a37  DATE := fnd_api.g_miss_date
728     , p11_a38  NUMBER := 0-1962.0724
729     , p11_a39  DATE := fnd_api.g_miss_date
730     , p11_a40  NUMBER := 0-1962.0724
731     , p11_a41  NUMBER := 0-1962.0724
732     , p11_a42  NUMBER := 0-1962.0724
733     , p11_a43  NUMBER := 0-1962.0724
734     , p11_a44  NUMBER := 0-1962.0724
735     , p11_a45  NUMBER := 0-1962.0724
736     , p11_a46  NUMBER := 0-1962.0724
737     , p11_a47  NUMBER := 0-1962.0724
738     , p11_a48  NUMBER := 0-1962.0724
739     , p11_a49  DATE := fnd_api.g_miss_date
740     , p11_a50  VARCHAR2 := fnd_api.g_miss_char
741     , p11_a51  NUMBER := 0-1962.0724
742     , p11_a52  NUMBER := 0-1962.0724
743     , p11_a53  DATE := fnd_api.g_miss_date
744     , p11_a54  DATE := fnd_api.g_miss_date
745     , p11_a55  VARCHAR2 := fnd_api.g_miss_char
746     , p11_a56  VARCHAR2 := fnd_api.g_miss_char
747     , p11_a57  VARCHAR2 := fnd_api.g_miss_char
748     , p11_a58  NUMBER := 0-1962.0724
749     , p11_a59  DATE := fnd_api.g_miss_date
750     , p11_a60  VARCHAR2 := fnd_api.g_miss_char
751     , p11_a61  VARCHAR2 := fnd_api.g_miss_char
752     , p11_a62  VARCHAR2 := fnd_api.g_miss_char
753     , p11_a63  VARCHAR2 := fnd_api.g_miss_char
754     , p11_a64  VARCHAR2 := fnd_api.g_miss_char
755     , p11_a65  VARCHAR2 := fnd_api.g_miss_char
756   );
757   procedure validate_credit(p_api_version  NUMBER
758     , p_init_msg_list  VARCHAR2
759     , x_return_status out nocopy  VARCHAR2
760     , x_msg_count out nocopy  NUMBER
761     , x_msg_data out nocopy  VARCHAR2
762     , p_chr_id  NUMBER
763     , p_contract_number  VARCHAR2
764     , p_description  VARCHAR2
765     , p_customer_id1  VARCHAR2
766     , p_customer_id2  VARCHAR2
767     , p_customer_code  VARCHAR2
768     , p_customer_name  VARCHAR2
769     , p_effective_from  date
770     , p_effective_to  date
771     , p_currency_code  VARCHAR2
772     , p_currency_conv_type  VARCHAR2
773     , p_currency_conv_rate  NUMBER
774     , p_currency_conv_date  date
775     , p_credit_ckl_id  NUMBER
776     , p_funding_ckl_id  NUMBER
777     , p_cust_acct_id  NUMBER
778     , p_cust_acct_number  VARCHAR2
779     , p_sts_code  VARCHAR2
780   );
781   procedure validate_credit_limit(p_api_version  NUMBER
782     , p_init_msg_list  VARCHAR2
783     , x_return_status out nocopy  VARCHAR2
784     , x_msg_count out nocopy  NUMBER
785     , x_msg_data out nocopy  VARCHAR2
786     , p_mode  VARCHAR2
787     , p_chr_id  NUMBER
788     , p_cle_id  NUMBER
789     , p_cle_start_date  date
790     , p_description  VARCHAR2
791     , p_credit_nature  VARCHAR2
792     , p_amount  NUMBER
793   );
794   procedure validate_credit_limit(p_api_version  NUMBER
795     , p_init_msg_list  VARCHAR2
796     , x_return_status out nocopy  VARCHAR2
797     , x_msg_count out nocopy  NUMBER
798     , x_msg_data out nocopy  VARCHAR2
799     , p_mode  VARCHAR2
800     , p6_a0  NUMBER := 0-1962.0724
801     , p6_a1  NUMBER := 0-1962.0724
802     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
803     , p6_a3  NUMBER := 0-1962.0724
804     , p6_a4  NUMBER := 0-1962.0724
805     , p6_a5  NUMBER := 0-1962.0724
806     , p6_a6  NUMBER := 0-1962.0724
807     , p6_a7  NUMBER := 0-1962.0724
808     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
809     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
810     , p6_a10  NUMBER := 0-1962.0724
811     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
812     , p6_a12  NUMBER := 0-1962.0724
813     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
814     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
815     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
816     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
817     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
818     , p6_a18  NUMBER := 0-1962.0724
819     , p6_a19  NUMBER := 0-1962.0724
820     , p6_a20  NUMBER := 0-1962.0724
821     , p6_a21  NUMBER := 0-1962.0724
822     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
823     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
824     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
825     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
826     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
827     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
828     , p6_a28  DATE := fnd_api.g_miss_date
829     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
830     , p6_a30  DATE := fnd_api.g_miss_date
831     , p6_a31  DATE := fnd_api.g_miss_date
832     , p6_a32  DATE := fnd_api.g_miss_date
833     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
834     , p6_a34  NUMBER := 0-1962.0724
835     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
836     , p6_a36  NUMBER := 0-1962.0724
837     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
838     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
839     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
840     , p6_a40  VARCHAR2 := fnd_api.g_miss_char
841     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
842     , p6_a42  VARCHAR2 := fnd_api.g_miss_char
843     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
844     , p6_a44  VARCHAR2 := fnd_api.g_miss_char
845     , p6_a45  VARCHAR2 := fnd_api.g_miss_char
846     , p6_a46  VARCHAR2 := fnd_api.g_miss_char
847     , p6_a47  VARCHAR2 := fnd_api.g_miss_char
848     , p6_a48  VARCHAR2 := fnd_api.g_miss_char
849     , p6_a49  VARCHAR2 := fnd_api.g_miss_char
850     , p6_a50  VARCHAR2 := fnd_api.g_miss_char
851     , p6_a51  VARCHAR2 := fnd_api.g_miss_char
852     , p6_a52  VARCHAR2 := fnd_api.g_miss_char
853     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
854     , p6_a54  NUMBER := 0-1962.0724
855     , p6_a55  DATE := fnd_api.g_miss_date
856     , p6_a56  NUMBER := 0-1962.0724
857     , p6_a57  DATE := fnd_api.g_miss_date
858     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
859     , p6_a59  VARCHAR2 := fnd_api.g_miss_char
860     , p6_a60  VARCHAR2 := fnd_api.g_miss_char
861     , p6_a61  NUMBER := 0-1962.0724
862     , p6_a62  VARCHAR2 := fnd_api.g_miss_char
863     , p6_a63  VARCHAR2 := fnd_api.g_miss_char
864     , p6_a64  VARCHAR2 := fnd_api.g_miss_char
865     , p6_a65  VARCHAR2 := fnd_api.g_miss_char
866     , p6_a66  VARCHAR2 := fnd_api.g_miss_char
867     , p6_a67  NUMBER := 0-1962.0724
868     , p6_a68  NUMBER := 0-1962.0724
869     , p6_a69  NUMBER := 0-1962.0724
870     , p6_a70  DATE := fnd_api.g_miss_date
871     , p6_a71  NUMBER := 0-1962.0724
872     , p6_a72  DATE := fnd_api.g_miss_date
873     , p6_a73  NUMBER := 0-1962.0724
874     , p6_a74  NUMBER := 0-1962.0724
875     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
876     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
877     , p6_a77  NUMBER := 0-1962.0724
878     , p6_a78  NUMBER := 0-1962.0724
879     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
880     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
881     , p6_a81  NUMBER := 0-1962.0724
882     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
883     , p6_a83  NUMBER := 0-1962.0724
884     , p6_a84  NUMBER := 0-1962.0724
885     , p6_a85  NUMBER := 0-1962.0724
886     , p6_a86  NUMBER := 0-1962.0724
887     , p6_a87  VARCHAR2 := fnd_api.g_miss_char
888     , p6_a88  NUMBER := 0-1962.0724
889     , p6_a89  NUMBER := 0-1962.0724
890     , p7_a0  NUMBER := 0-1962.0724
891     , p7_a1  NUMBER := 0-1962.0724
892     , p7_a2  NUMBER := 0-1962.0724
893     , p7_a3  NUMBER := 0-1962.0724
894     , p7_a4  VARCHAR2 := fnd_api.g_miss_char
895     , p7_a5  VARCHAR2 := fnd_api.g_miss_char
896     , p7_a6  VARCHAR2 := fnd_api.g_miss_char
897     , p7_a7  NUMBER := 0-1962.0724
898     , p7_a8  NUMBER := 0-1962.0724
899     , p7_a9  DATE := fnd_api.g_miss_date
900     , p7_a10  NUMBER := 0-1962.0724
901     , p7_a11  NUMBER := 0-1962.0724
902     , p7_a12  NUMBER := 0-1962.0724
903     , p7_a13  NUMBER := 0-1962.0724
904     , p7_a14  NUMBER := 0-1962.0724
905     , p7_a15  NUMBER := 0-1962.0724
906     , p7_a16  NUMBER := 0-1962.0724
907     , p7_a17  NUMBER := 0-1962.0724
908     , p7_a18  NUMBER := 0-1962.0724
909     , p7_a19  NUMBER := 0-1962.0724
910     , p7_a20  DATE := fnd_api.g_miss_date
911     , p7_a21  DATE := fnd_api.g_miss_date
912     , p7_a22  NUMBER := 0-1962.0724
913     , p7_a23  NUMBER := 0-1962.0724
914     , p7_a24  DATE := fnd_api.g_miss_date
915     , p7_a25  DATE := fnd_api.g_miss_date
916     , p7_a26  DATE := fnd_api.g_miss_date
917     , p7_a27  NUMBER := 0-1962.0724
918     , p7_a28  NUMBER := 0-1962.0724
919     , p7_a29  NUMBER := 0-1962.0724
920     , p7_a30  NUMBER := 0-1962.0724
921     , p7_a31  NUMBER := 0-1962.0724
922     , p7_a32  NUMBER := 0-1962.0724
923     , p7_a33  NUMBER := 0-1962.0724
924     , p7_a34  DATE := fnd_api.g_miss_date
925     , p7_a35  VARCHAR2 := fnd_api.g_miss_char
926     , p7_a36  DATE := fnd_api.g_miss_date
927     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
928     , p7_a38  NUMBER := 0-1962.0724
929     , p7_a39  NUMBER := 0-1962.0724
930     , p7_a40  NUMBER := 0-1962.0724
931     , p7_a41  VARCHAR2 := fnd_api.g_miss_char
932     , p7_a42  DATE := fnd_api.g_miss_date
933     , p7_a43  NUMBER := 0-1962.0724
934     , p7_a44  NUMBER := 0-1962.0724
935     , p7_a45  DATE := fnd_api.g_miss_date
936     , p7_a46  NUMBER := 0-1962.0724
937     , p7_a47  DATE := fnd_api.g_miss_date
938     , p7_a48  DATE := fnd_api.g_miss_date
939     , p7_a49  DATE := fnd_api.g_miss_date
940     , p7_a50  NUMBER := 0-1962.0724
941     , p7_a51  NUMBER := 0-1962.0724
942     , p7_a52  VARCHAR2 := fnd_api.g_miss_char
943     , p7_a53  NUMBER := 0-1962.0724
944     , p7_a54  NUMBER := 0-1962.0724
945     , p7_a55  VARCHAR2 := fnd_api.g_miss_char
946     , p7_a56  VARCHAR2 := fnd_api.g_miss_char
947     , p7_a57  NUMBER := 0-1962.0724
948     , p7_a58  DATE := fnd_api.g_miss_date
949     , p7_a59  NUMBER := 0-1962.0724
950     , p7_a60  VARCHAR2 := fnd_api.g_miss_char
951     , p7_a61  VARCHAR2 := fnd_api.g_miss_char
952     , p7_a62  VARCHAR2 := fnd_api.g_miss_char
953     , p7_a63  VARCHAR2 := fnd_api.g_miss_char
954     , p7_a64  VARCHAR2 := fnd_api.g_miss_char
955     , p7_a65  VARCHAR2 := fnd_api.g_miss_char
956     , p7_a66  VARCHAR2 := fnd_api.g_miss_char
957     , p7_a67  VARCHAR2 := fnd_api.g_miss_char
958     , p7_a68  VARCHAR2 := fnd_api.g_miss_char
959     , p7_a69  VARCHAR2 := fnd_api.g_miss_char
960     , p7_a70  VARCHAR2 := fnd_api.g_miss_char
961     , p7_a71  VARCHAR2 := fnd_api.g_miss_char
962     , p7_a72  VARCHAR2 := fnd_api.g_miss_char
963     , p7_a73  VARCHAR2 := fnd_api.g_miss_char
964     , p7_a74  VARCHAR2 := fnd_api.g_miss_char
965     , p7_a75  VARCHAR2 := fnd_api.g_miss_char
966     , p7_a76  NUMBER := 0-1962.0724
967     , p7_a77  NUMBER := 0-1962.0724
968     , p7_a78  NUMBER := 0-1962.0724
969     , p7_a79  DATE := fnd_api.g_miss_date
970     , p7_a80  NUMBER := 0-1962.0724
971     , p7_a81  DATE := fnd_api.g_miss_date
972     , p7_a82  NUMBER := 0-1962.0724
973     , p7_a83  DATE := fnd_api.g_miss_date
974     , p7_a84  DATE := fnd_api.g_miss_date
975     , p7_a85  DATE := fnd_api.g_miss_date
976     , p7_a86  DATE := fnd_api.g_miss_date
977     , p7_a87  NUMBER := 0-1962.0724
978     , p7_a88  NUMBER := 0-1962.0724
979     , p7_a89  NUMBER := 0-1962.0724
980     , p7_a90  VARCHAR2 := fnd_api.g_miss_char
981     , p7_a91  NUMBER := 0-1962.0724
982     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
983     , p7_a93  NUMBER := 0-1962.0724
984     , p7_a94  NUMBER := 0-1962.0724
985     , p7_a95  DATE := fnd_api.g_miss_date
986     , p7_a96  VARCHAR2 := fnd_api.g_miss_char
987     , p7_a97  VARCHAR2 := fnd_api.g_miss_char
988     , p7_a98  NUMBER := 0-1962.0724
989   );
990   procedure validate_credit_limit(p_api_version  NUMBER
991     , p_init_msg_list  VARCHAR2
992     , x_return_status out nocopy  VARCHAR2
993     , x_msg_count out nocopy  NUMBER
994     , x_msg_data out nocopy  VARCHAR2
995     , p_mode  VARCHAR2
996     , p6_a0 JTF_NUMBER_TABLE
997     , p6_a1 JTF_NUMBER_TABLE
998     , p6_a2 JTF_VARCHAR2_TABLE_100
999     , p6_a3 JTF_NUMBER_TABLE
1000     , p6_a4 JTF_NUMBER_TABLE
1001     , p6_a5 JTF_NUMBER_TABLE
1002     , p6_a6 JTF_NUMBER_TABLE
1003     , p6_a7 JTF_NUMBER_TABLE
1004     , p6_a8 JTF_VARCHAR2_TABLE_200
1005     , p6_a9 JTF_VARCHAR2_TABLE_100
1006     , p6_a10 JTF_NUMBER_TABLE
1007     , p6_a11 JTF_VARCHAR2_TABLE_100
1008     , p6_a12 JTF_NUMBER_TABLE
1009     , p6_a13 JTF_VARCHAR2_TABLE_2000
1010     , p6_a14 JTF_VARCHAR2_TABLE_2000
1011     , p6_a15 JTF_VARCHAR2_TABLE_2000
1012     , p6_a16 JTF_VARCHAR2_TABLE_300
1013     , p6_a17 JTF_VARCHAR2_TABLE_100
1014     , p6_a18 JTF_NUMBER_TABLE
1015     , p6_a19 JTF_NUMBER_TABLE
1016     , p6_a20 JTF_NUMBER_TABLE
1017     , p6_a21 JTF_NUMBER_TABLE
1018     , p6_a22 JTF_VARCHAR2_TABLE_100
1019     , p6_a23 JTF_VARCHAR2_TABLE_100
1020     , p6_a24 JTF_VARCHAR2_TABLE_100
1021     , p6_a25 JTF_VARCHAR2_TABLE_2000
1022     , p6_a26 JTF_VARCHAR2_TABLE_100
1023     , p6_a27 JTF_VARCHAR2_TABLE_200
1024     , p6_a28 JTF_DATE_TABLE
1025     , p6_a29 JTF_VARCHAR2_TABLE_200
1026     , p6_a30 JTF_DATE_TABLE
1027     , p6_a31 JTF_DATE_TABLE
1028     , p6_a32 JTF_DATE_TABLE
1029     , p6_a33 JTF_VARCHAR2_TABLE_100
1030     , p6_a34 JTF_NUMBER_TABLE
1031     , p6_a35 JTF_VARCHAR2_TABLE_100
1032     , p6_a36 JTF_NUMBER_TABLE
1033     , p6_a37 JTF_VARCHAR2_TABLE_100
1034     , p6_a38 JTF_VARCHAR2_TABLE_100
1035     , p6_a39 JTF_VARCHAR2_TABLE_500
1036     , p6_a40 JTF_VARCHAR2_TABLE_500
1037     , p6_a41 JTF_VARCHAR2_TABLE_500
1038     , p6_a42 JTF_VARCHAR2_TABLE_500
1039     , p6_a43 JTF_VARCHAR2_TABLE_500
1040     , p6_a44 JTF_VARCHAR2_TABLE_500
1041     , p6_a45 JTF_VARCHAR2_TABLE_500
1042     , p6_a46 JTF_VARCHAR2_TABLE_500
1043     , p6_a47 JTF_VARCHAR2_TABLE_500
1044     , p6_a48 JTF_VARCHAR2_TABLE_500
1045     , p6_a49 JTF_VARCHAR2_TABLE_500
1046     , p6_a50 JTF_VARCHAR2_TABLE_500
1047     , p6_a51 JTF_VARCHAR2_TABLE_500
1048     , p6_a52 JTF_VARCHAR2_TABLE_500
1049     , p6_a53 JTF_VARCHAR2_TABLE_500
1050     , p6_a54 JTF_NUMBER_TABLE
1051     , p6_a55 JTF_DATE_TABLE
1052     , p6_a56 JTF_NUMBER_TABLE
1053     , p6_a57 JTF_DATE_TABLE
1054     , p6_a58 JTF_VARCHAR2_TABLE_100
1055     , p6_a59 JTF_VARCHAR2_TABLE_100
1056     , p6_a60 JTF_VARCHAR2_TABLE_100
1057     , p6_a61 JTF_NUMBER_TABLE
1058     , p6_a62 JTF_VARCHAR2_TABLE_100
1059     , p6_a63 JTF_VARCHAR2_TABLE_100
1060     , p6_a64 JTF_VARCHAR2_TABLE_100
1061     , p6_a65 JTF_VARCHAR2_TABLE_100
1062     , p6_a66 JTF_VARCHAR2_TABLE_100
1063     , p6_a67 JTF_NUMBER_TABLE
1064     , p6_a68 JTF_NUMBER_TABLE
1065     , p6_a69 JTF_NUMBER_TABLE
1066     , p6_a70 JTF_DATE_TABLE
1067     , p6_a71 JTF_NUMBER_TABLE
1068     , p6_a72 JTF_DATE_TABLE
1069     , p6_a73 JTF_NUMBER_TABLE
1070     , p6_a74 JTF_NUMBER_TABLE
1071     , p6_a75 JTF_VARCHAR2_TABLE_100
1072     , p6_a76 JTF_VARCHAR2_TABLE_100
1073     , p6_a77 JTF_NUMBER_TABLE
1074     , p6_a78 JTF_NUMBER_TABLE
1075     , p6_a79 JTF_VARCHAR2_TABLE_100
1076     , p6_a80 JTF_VARCHAR2_TABLE_100
1077     , p6_a81 JTF_NUMBER_TABLE
1078     , p6_a82 JTF_VARCHAR2_TABLE_100
1079     , p6_a83 JTF_NUMBER_TABLE
1080     , p6_a84 JTF_NUMBER_TABLE
1081     , p6_a85 JTF_NUMBER_TABLE
1082     , p6_a86 JTF_NUMBER_TABLE
1083     , p6_a87 JTF_VARCHAR2_TABLE_100
1084     , p6_a88 JTF_NUMBER_TABLE
1085     , p6_a89 JTF_NUMBER_TABLE
1086     , p7_a0 JTF_NUMBER_TABLE
1087     , p7_a1 JTF_NUMBER_TABLE
1088     , p7_a2 JTF_NUMBER_TABLE
1089     , p7_a3 JTF_NUMBER_TABLE
1090     , p7_a4 JTF_VARCHAR2_TABLE_100
1091     , p7_a5 JTF_VARCHAR2_TABLE_100
1092     , p7_a6 JTF_VARCHAR2_TABLE_100
1093     , p7_a7 JTF_NUMBER_TABLE
1094     , p7_a8 JTF_NUMBER_TABLE
1095     , p7_a9 JTF_DATE_TABLE
1096     , p7_a10 JTF_NUMBER_TABLE
1097     , p7_a11 JTF_NUMBER_TABLE
1098     , p7_a12 JTF_NUMBER_TABLE
1099     , p7_a13 JTF_NUMBER_TABLE
1100     , p7_a14 JTF_NUMBER_TABLE
1101     , p7_a15 JTF_NUMBER_TABLE
1102     , p7_a16 JTF_NUMBER_TABLE
1103     , p7_a17 JTF_NUMBER_TABLE
1104     , p7_a18 JTF_NUMBER_TABLE
1105     , p7_a19 JTF_NUMBER_TABLE
1106     , p7_a20 JTF_DATE_TABLE
1107     , p7_a21 JTF_DATE_TABLE
1108     , p7_a22 JTF_NUMBER_TABLE
1109     , p7_a23 JTF_NUMBER_TABLE
1110     , p7_a24 JTF_DATE_TABLE
1111     , p7_a25 JTF_DATE_TABLE
1112     , p7_a26 JTF_DATE_TABLE
1113     , p7_a27 JTF_NUMBER_TABLE
1114     , p7_a28 JTF_NUMBER_TABLE
1115     , p7_a29 JTF_NUMBER_TABLE
1116     , p7_a30 JTF_NUMBER_TABLE
1117     , p7_a31 JTF_NUMBER_TABLE
1118     , p7_a32 JTF_NUMBER_TABLE
1119     , p7_a33 JTF_NUMBER_TABLE
1120     , p7_a34 JTF_DATE_TABLE
1121     , p7_a35 JTF_VARCHAR2_TABLE_100
1122     , p7_a36 JTF_DATE_TABLE
1123     , p7_a37 JTF_VARCHAR2_TABLE_300
1124     , p7_a38 JTF_NUMBER_TABLE
1125     , p7_a39 JTF_NUMBER_TABLE
1126     , p7_a40 JTF_NUMBER_TABLE
1127     , p7_a41 JTF_VARCHAR2_TABLE_100
1128     , p7_a42 JTF_DATE_TABLE
1129     , p7_a43 JTF_NUMBER_TABLE
1130     , p7_a44 JTF_NUMBER_TABLE
1131     , p7_a45 JTF_DATE_TABLE
1132     , p7_a46 JTF_NUMBER_TABLE
1133     , p7_a47 JTF_DATE_TABLE
1134     , p7_a48 JTF_DATE_TABLE
1135     , p7_a49 JTF_DATE_TABLE
1136     , p7_a50 JTF_NUMBER_TABLE
1137     , p7_a51 JTF_NUMBER_TABLE
1138     , p7_a52 JTF_VARCHAR2_TABLE_100
1139     , p7_a53 JTF_NUMBER_TABLE
1140     , p7_a54 JTF_NUMBER_TABLE
1141     , p7_a55 JTF_VARCHAR2_TABLE_100
1142     , p7_a56 JTF_VARCHAR2_TABLE_100
1143     , p7_a57 JTF_NUMBER_TABLE
1144     , p7_a58 JTF_DATE_TABLE
1145     , p7_a59 JTF_NUMBER_TABLE
1146     , p7_a60 JTF_VARCHAR2_TABLE_100
1147     , p7_a61 JTF_VARCHAR2_TABLE_500
1148     , p7_a62 JTF_VARCHAR2_TABLE_500
1149     , p7_a63 JTF_VARCHAR2_TABLE_500
1150     , p7_a64 JTF_VARCHAR2_TABLE_500
1151     , p7_a65 JTF_VARCHAR2_TABLE_500
1152     , p7_a66 JTF_VARCHAR2_TABLE_500
1153     , p7_a67 JTF_VARCHAR2_TABLE_500
1154     , p7_a68 JTF_VARCHAR2_TABLE_500
1155     , p7_a69 JTF_VARCHAR2_TABLE_500
1156     , p7_a70 JTF_VARCHAR2_TABLE_500
1157     , p7_a71 JTF_VARCHAR2_TABLE_500
1158     , p7_a72 JTF_VARCHAR2_TABLE_500
1159     , p7_a73 JTF_VARCHAR2_TABLE_500
1160     , p7_a74 JTF_VARCHAR2_TABLE_500
1161     , p7_a75 JTF_VARCHAR2_TABLE_500
1162     , p7_a76 JTF_NUMBER_TABLE
1163     , p7_a77 JTF_NUMBER_TABLE
1164     , p7_a78 JTF_NUMBER_TABLE
1165     , p7_a79 JTF_DATE_TABLE
1166     , p7_a80 JTF_NUMBER_TABLE
1167     , p7_a81 JTF_DATE_TABLE
1168     , p7_a82 JTF_NUMBER_TABLE
1169     , p7_a83 JTF_DATE_TABLE
1170     , p7_a84 JTF_DATE_TABLE
1171     , p7_a85 JTF_DATE_TABLE
1172     , p7_a86 JTF_DATE_TABLE
1173     , p7_a87 JTF_NUMBER_TABLE
1174     , p7_a88 JTF_NUMBER_TABLE
1175     , p7_a89 JTF_NUMBER_TABLE
1176     , p7_a90 JTF_VARCHAR2_TABLE_100
1177     , p7_a91 JTF_NUMBER_TABLE
1178     , p7_a92 JTF_VARCHAR2_TABLE_100
1179     , p7_a93 JTF_NUMBER_TABLE
1180     , p7_a94 JTF_NUMBER_TABLE
1181     , p7_a95 JTF_DATE_TABLE
1182     , p7_a96 JTF_VARCHAR2_TABLE_100
1183     , p7_a97 JTF_VARCHAR2_TABLE_100
1184     , p7_a98 JTF_NUMBER_TABLE
1185   );
1186   procedure create_credit_limit(p_api_version  NUMBER
1187     , p_init_msg_list  VARCHAR2
1188     , x_return_status out nocopy  VARCHAR2
1189     , x_msg_count out nocopy  NUMBER
1190     , x_msg_data out nocopy  VARCHAR2
1191     , p5_a0 JTF_NUMBER_TABLE
1192     , p5_a1 JTF_NUMBER_TABLE
1193     , p5_a2 JTF_NUMBER_TABLE
1194     , p5_a3 JTF_VARCHAR2_TABLE_200
1195     , p5_a4 JTF_VARCHAR2_TABLE_100
1196     , p5_a5 JTF_NUMBER_TABLE
1197     , p5_a6 JTF_NUMBER_TABLE
1198     , p5_a7 JTF_VARCHAR2_TABLE_2000
1199     , p5_a8 JTF_VARCHAR2_TABLE_100
1200     , p5_a9 JTF_DATE_TABLE
1201     , p6_a0 JTF_NUMBER_TABLE
1202     , p6_a1 JTF_NUMBER_TABLE
1203     , p6_a2 JTF_NUMBER_TABLE
1204     , p6_a3 JTF_NUMBER_TABLE
1205     , p6_a4 JTF_VARCHAR2_TABLE_100
1206     , p6_a5 JTF_VARCHAR2_TABLE_100
1207     , p6_a6 JTF_VARCHAR2_TABLE_100
1208     , p6_a7 JTF_NUMBER_TABLE
1209     , p6_a8 JTF_NUMBER_TABLE
1210     , p6_a9 JTF_DATE_TABLE
1211     , p6_a10 JTF_NUMBER_TABLE
1212     , p6_a11 JTF_NUMBER_TABLE
1213     , p6_a12 JTF_NUMBER_TABLE
1214     , p6_a13 JTF_NUMBER_TABLE
1215     , p6_a14 JTF_NUMBER_TABLE
1216     , p6_a15 JTF_NUMBER_TABLE
1217     , p6_a16 JTF_NUMBER_TABLE
1218     , p6_a17 JTF_NUMBER_TABLE
1219     , p6_a18 JTF_NUMBER_TABLE
1220     , p6_a19 JTF_NUMBER_TABLE
1221     , p6_a20 JTF_DATE_TABLE
1222     , p6_a21 JTF_DATE_TABLE
1223     , p6_a22 JTF_NUMBER_TABLE
1224     , p6_a23 JTF_NUMBER_TABLE
1225     , p6_a24 JTF_DATE_TABLE
1226     , p6_a25 JTF_DATE_TABLE
1227     , p6_a26 JTF_DATE_TABLE
1228     , p6_a27 JTF_NUMBER_TABLE
1229     , p6_a28 JTF_NUMBER_TABLE
1230     , p6_a29 JTF_NUMBER_TABLE
1231     , p6_a30 JTF_NUMBER_TABLE
1232     , p6_a31 JTF_NUMBER_TABLE
1233     , p6_a32 JTF_NUMBER_TABLE
1234     , p6_a33 JTF_NUMBER_TABLE
1235     , p6_a34 JTF_DATE_TABLE
1236     , p6_a35 JTF_VARCHAR2_TABLE_100
1237     , p6_a36 JTF_DATE_TABLE
1238     , p6_a37 JTF_VARCHAR2_TABLE_300
1239     , p6_a38 JTF_NUMBER_TABLE
1240     , p6_a39 JTF_NUMBER_TABLE
1241     , p6_a40 JTF_NUMBER_TABLE
1242     , p6_a41 JTF_VARCHAR2_TABLE_100
1243     , p6_a42 JTF_DATE_TABLE
1244     , p6_a43 JTF_NUMBER_TABLE
1245     , p6_a44 JTF_NUMBER_TABLE
1246     , p6_a45 JTF_DATE_TABLE
1247     , p6_a46 JTF_NUMBER_TABLE
1248     , p6_a47 JTF_DATE_TABLE
1249     , p6_a48 JTF_DATE_TABLE
1250     , p6_a49 JTF_DATE_TABLE
1251     , p6_a50 JTF_NUMBER_TABLE
1252     , p6_a51 JTF_NUMBER_TABLE
1253     , p6_a52 JTF_VARCHAR2_TABLE_100
1254     , p6_a53 JTF_NUMBER_TABLE
1255     , p6_a54 JTF_NUMBER_TABLE
1256     , p6_a55 JTF_VARCHAR2_TABLE_100
1257     , p6_a56 JTF_VARCHAR2_TABLE_100
1258     , p6_a57 JTF_NUMBER_TABLE
1259     , p6_a58 JTF_DATE_TABLE
1260     , p6_a59 JTF_NUMBER_TABLE
1261     , p6_a60 JTF_VARCHAR2_TABLE_100
1262     , p6_a61 JTF_VARCHAR2_TABLE_500
1263     , p6_a62 JTF_VARCHAR2_TABLE_500
1264     , p6_a63 JTF_VARCHAR2_TABLE_500
1265     , p6_a64 JTF_VARCHAR2_TABLE_500
1266     , p6_a65 JTF_VARCHAR2_TABLE_500
1267     , p6_a66 JTF_VARCHAR2_TABLE_500
1268     , p6_a67 JTF_VARCHAR2_TABLE_500
1269     , p6_a68 JTF_VARCHAR2_TABLE_500
1270     , p6_a69 JTF_VARCHAR2_TABLE_500
1271     , p6_a70 JTF_VARCHAR2_TABLE_500
1272     , p6_a71 JTF_VARCHAR2_TABLE_500
1273     , p6_a72 JTF_VARCHAR2_TABLE_500
1274     , p6_a73 JTF_VARCHAR2_TABLE_500
1275     , p6_a74 JTF_VARCHAR2_TABLE_500
1276     , p6_a75 JTF_VARCHAR2_TABLE_500
1277     , p6_a76 JTF_NUMBER_TABLE
1278     , p6_a77 JTF_NUMBER_TABLE
1279     , p6_a78 JTF_NUMBER_TABLE
1280     , p6_a79 JTF_DATE_TABLE
1281     , p6_a80 JTF_NUMBER_TABLE
1282     , p6_a81 JTF_DATE_TABLE
1283     , p6_a82 JTF_NUMBER_TABLE
1284     , p6_a83 JTF_DATE_TABLE
1285     , p6_a84 JTF_DATE_TABLE
1286     , p6_a85 JTF_DATE_TABLE
1287     , p6_a86 JTF_DATE_TABLE
1288     , p6_a87 JTF_NUMBER_TABLE
1289 
1290 
1291 
1292 
1293 
1294 
1295     , p6_a88 JTF_NUMBER_TABLE
1296     , p6_a89 JTF_NUMBER_TABLE
1297     , p6_a90 JTF_VARCHAR2_TABLE_100
1298     , p6_a91 JTF_NUMBER_TABLE
1299     , p6_a92 JTF_VARCHAR2_TABLE_100
1300     , p6_a93 JTF_NUMBER_TABLE
1301     , p6_a94 JTF_NUMBER_TABLE
1302     , p6_a95 JTF_DATE_TABLE
1303     , p6_a96 JTF_VARCHAR2_TABLE_100
1304     , p6_a97 JTF_VARCHAR2_TABLE_100
1305     , p6_a98 JTF_NUMBER_TABLE
1306     , p7_a0 out nocopy JTF_NUMBER_TABLE
1307     , p7_a1 out nocopy JTF_NUMBER_TABLE
1308     , p7_a2 out nocopy JTF_NUMBER_TABLE
1309     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
1310     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1311     , p7_a5 out nocopy JTF_NUMBER_TABLE
1312     , p7_a6 out nocopy JTF_NUMBER_TABLE
1313     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1314     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1315     , p7_a9 out nocopy JTF_DATE_TABLE
1316     , p8_a0 out nocopy JTF_NUMBER_TABLE
1317     , p8_a1 out nocopy JTF_NUMBER_TABLE
1318     , p8_a2 out nocopy JTF_NUMBER_TABLE
1319     , p8_a3 out nocopy JTF_NUMBER_TABLE
1320     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1322     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
1323     , p8_a7 out nocopy JTF_NUMBER_TABLE
1324     , p8_a8 out nocopy JTF_NUMBER_TABLE
1325     , p8_a9 out nocopy JTF_DATE_TABLE
1326     , p8_a10 out nocopy JTF_NUMBER_TABLE
1327     , p8_a11 out nocopy JTF_NUMBER_TABLE
1328     , p8_a12 out nocopy JTF_NUMBER_TABLE
1329     , p8_a13 out nocopy JTF_NUMBER_TABLE
1330     , p8_a14 out nocopy JTF_NUMBER_TABLE
1331     , p8_a15 out nocopy JTF_NUMBER_TABLE
1332     , p8_a16 out nocopy JTF_NUMBER_TABLE
1333     , p8_a17 out nocopy JTF_NUMBER_TABLE
1334     , p8_a18 out nocopy JTF_NUMBER_TABLE
1335     , p8_a19 out nocopy JTF_NUMBER_TABLE
1336     , p8_a20 out nocopy JTF_DATE_TABLE
1337     , p8_a21 out nocopy JTF_DATE_TABLE
1338     , p8_a22 out nocopy JTF_NUMBER_TABLE
1339     , p8_a23 out nocopy JTF_NUMBER_TABLE
1340     , p8_a24 out nocopy JTF_DATE_TABLE
1341     , p8_a25 out nocopy JTF_DATE_TABLE
1342     , p8_a26 out nocopy JTF_DATE_TABLE
1343     , p8_a27 out nocopy JTF_NUMBER_TABLE
1344     , p8_a28 out nocopy JTF_NUMBER_TABLE
1345     , p8_a29 out nocopy JTF_NUMBER_TABLE
1346     , p8_a30 out nocopy JTF_NUMBER_TABLE
1347     , p8_a31 out nocopy JTF_NUMBER_TABLE
1348     , p8_a32 out nocopy JTF_NUMBER_TABLE
1349     , p8_a33 out nocopy JTF_NUMBER_TABLE
1350     , p8_a34 out nocopy JTF_DATE_TABLE
1351     , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
1352     , p8_a36 out nocopy JTF_DATE_TABLE
1353     , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
1354     , p8_a38 out nocopy JTF_NUMBER_TABLE
1355     , p8_a39 out nocopy JTF_NUMBER_TABLE
1356     , p8_a40 out nocopy JTF_NUMBER_TABLE
1357     , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100
1358     , p8_a42 out nocopy JTF_DATE_TABLE
1359     , p8_a43 out nocopy JTF_NUMBER_TABLE
1360     , p8_a44 out nocopy JTF_NUMBER_TABLE
1361     , p8_a45 out nocopy JTF_DATE_TABLE
1362     , p8_a46 out nocopy JTF_NUMBER_TABLE
1363     , p8_a47 out nocopy JTF_DATE_TABLE
1364     , p8_a48 out nocopy JTF_DATE_TABLE
1365     , p8_a49 out nocopy JTF_DATE_TABLE
1366     , p8_a50 out nocopy JTF_NUMBER_TABLE
1367     , p8_a51 out nocopy JTF_NUMBER_TABLE
1368     , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
1369     , p8_a53 out nocopy JTF_NUMBER_TABLE
1370     , p8_a54 out nocopy JTF_NUMBER_TABLE
1371     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_100
1372     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
1373     , p8_a57 out nocopy JTF_NUMBER_TABLE
1374     , p8_a58 out nocopy JTF_DATE_TABLE
1375     , p8_a59 out nocopy JTF_NUMBER_TABLE
1376     , p8_a60 out nocopy JTF_VARCHAR2_TABLE_100
1377     , p8_a61 out nocopy JTF_VARCHAR2_TABLE_500
1378     , p8_a62 out nocopy JTF_VARCHAR2_TABLE_500
1379     , p8_a63 out nocopy JTF_VARCHAR2_TABLE_500
1380     , p8_a64 out nocopy JTF_VARCHAR2_TABLE_500
1381     , p8_a65 out nocopy JTF_VARCHAR2_TABLE_500
1382     , p8_a66 out nocopy JTF_VARCHAR2_TABLE_500
1383     , p8_a67 out nocopy JTF_VARCHAR2_TABLE_500
1384     , p8_a68 out nocopy JTF_VARCHAR2_TABLE_500
1385     , p8_a69 out nocopy JTF_VARCHAR2_TABLE_500
1386     , p8_a70 out nocopy JTF_VARCHAR2_TABLE_500
1387     , p8_a71 out nocopy JTF_VARCHAR2_TABLE_500
1388     , p8_a72 out nocopy JTF_VARCHAR2_TABLE_500
1389     , p8_a73 out nocopy JTF_VARCHAR2_TABLE_500
1390     , p8_a74 out nocopy JTF_VARCHAR2_TABLE_500
1391     , p8_a75 out nocopy JTF_VARCHAR2_TABLE_500
1392     , p8_a76 out nocopy JTF_NUMBER_TABLE
1393     , p8_a77 out nocopy JTF_NUMBER_TABLE
1394     , p8_a78 out nocopy JTF_NUMBER_TABLE
1395     , p8_a79 out nocopy JTF_DATE_TABLE
1396     , p8_a80 out nocopy JTF_NUMBER_TABLE
1397     , p8_a81 out nocopy JTF_DATE_TABLE
1398     , p8_a82 out nocopy JTF_NUMBER_TABLE
1399     , p8_a83 out nocopy JTF_DATE_TABLE
1400     , p8_a84 out nocopy JTF_DATE_TABLE
1401     , p8_a85 out nocopy JTF_DATE_TABLE
1402     , p8_a86 out nocopy JTF_DATE_TABLE
1403     , p8_a87 out nocopy JTF_NUMBER_TABLE
1404     , p8_a88 out nocopy JTF_NUMBER_TABLE
1405     , p8_a89 out nocopy JTF_NUMBER_TABLE
1406     , p8_a90 out nocopy JTF_VARCHAR2_TABLE_100
1407     , p8_a91 out nocopy JTF_NUMBER_TABLE
1408     , p8_a92 out nocopy JTF_VARCHAR2_TABLE_100
1409     , p8_a93 out nocopy JTF_NUMBER_TABLE
1410     , p8_a94 out nocopy JTF_NUMBER_TABLE
1411     , p8_a95 out nocopy JTF_DATE_TABLE
1412     , p8_a96 out nocopy JTF_VARCHAR2_TABLE_100
1413     , p8_a97 out nocopy JTF_VARCHAR2_TABLE_100
1414     , p8_a98 out nocopy JTF_NUMBER_TABLE
1415   );
1416   procedure update_credit_limit(p_api_version  NUMBER
1417     , p_init_msg_list  VARCHAR2
1418     , x_return_status out nocopy  VARCHAR2
1419     , x_msg_count out nocopy  NUMBER
1420     , x_msg_data out nocopy  VARCHAR2
1421     , p5_a0 JTF_NUMBER_TABLE
1422     , p5_a1 JTF_NUMBER_TABLE
1423     , p5_a2 JTF_NUMBER_TABLE
1424     , p5_a3 JTF_VARCHAR2_TABLE_200
1425     , p5_a4 JTF_VARCHAR2_TABLE_100
1426     , p5_a5 JTF_NUMBER_TABLE
1427     , p5_a6 JTF_NUMBER_TABLE
1428     , p5_a7 JTF_VARCHAR2_TABLE_2000
1429     , p5_a8 JTF_VARCHAR2_TABLE_100
1430     , p5_a9 JTF_DATE_TABLE
1431     , p6_a0 JTF_NUMBER_TABLE
1432     , p6_a1 JTF_NUMBER_TABLE
1433     , p6_a2 JTF_NUMBER_TABLE
1434     , p6_a3 JTF_NUMBER_TABLE
1435     , p6_a4 JTF_VARCHAR2_TABLE_100
1436     , p6_a5 JTF_VARCHAR2_TABLE_100
1437     , p6_a6 JTF_VARCHAR2_TABLE_100
1438     , p6_a7 JTF_NUMBER_TABLE
1439     , p6_a8 JTF_NUMBER_TABLE
1440     , p6_a9 JTF_DATE_TABLE
1441     , p6_a10 JTF_NUMBER_TABLE
1442     , p6_a11 JTF_NUMBER_TABLE
1443     , p6_a12 JTF_NUMBER_TABLE
1444     , p6_a13 JTF_NUMBER_TABLE
1445     , p6_a14 JTF_NUMBER_TABLE
1446     , p6_a15 JTF_NUMBER_TABLE
1447     , p6_a16 JTF_NUMBER_TABLE
1448     , p6_a17 JTF_NUMBER_TABLE
1449     , p6_a18 JTF_NUMBER_TABLE
1450     , p6_a19 JTF_NUMBER_TABLE
1451     , p6_a20 JTF_DATE_TABLE
1452     , p6_a21 JTF_DATE_TABLE
1453     , p6_a22 JTF_NUMBER_TABLE
1454     , p6_a23 JTF_NUMBER_TABLE
1455     , p6_a24 JTF_DATE_TABLE
1456     , p6_a25 JTF_DATE_TABLE
1457     , p6_a26 JTF_DATE_TABLE
1458     , p6_a27 JTF_NUMBER_TABLE
1459     , p6_a28 JTF_NUMBER_TABLE
1460     , p6_a29 JTF_NUMBER_TABLE
1461     , p6_a30 JTF_NUMBER_TABLE
1462     , p6_a31 JTF_NUMBER_TABLE
1463     , p6_a32 JTF_NUMBER_TABLE
1464     , p6_a33 JTF_NUMBER_TABLE
1465     , p6_a34 JTF_DATE_TABLE
1466     , p6_a35 JTF_VARCHAR2_TABLE_100
1467     , p6_a36 JTF_DATE_TABLE
1468     , p6_a37 JTF_VARCHAR2_TABLE_300
1469     , p6_a38 JTF_NUMBER_TABLE
1470     , p6_a39 JTF_NUMBER_TABLE
1471     , p6_a40 JTF_NUMBER_TABLE
1472     , p6_a41 JTF_VARCHAR2_TABLE_100
1473     , p6_a42 JTF_DATE_TABLE
1474     , p6_a43 JTF_NUMBER_TABLE
1475     , p6_a44 JTF_NUMBER_TABLE
1476     , p6_a45 JTF_DATE_TABLE
1477     , p6_a46 JTF_NUMBER_TABLE
1478     , p6_a47 JTF_DATE_TABLE
1479     , p6_a48 JTF_DATE_TABLE
1480     , p6_a49 JTF_DATE_TABLE
1481     , p6_a50 JTF_NUMBER_TABLE
1482     , p6_a51 JTF_NUMBER_TABLE
1483     , p6_a52 JTF_VARCHAR2_TABLE_100
1484     , p6_a53 JTF_NUMBER_TABLE
1485     , p6_a54 JTF_NUMBER_TABLE
1486     , p6_a55 JTF_VARCHAR2_TABLE_100
1487     , p6_a56 JTF_VARCHAR2_TABLE_100
1488     , p6_a57 JTF_NUMBER_TABLE
1489     , p6_a58 JTF_DATE_TABLE
1490     , p6_a59 JTF_NUMBER_TABLE
1491     , p6_a60 JTF_VARCHAR2_TABLE_100
1492     , p6_a61 JTF_VARCHAR2_TABLE_500
1493     , p6_a62 JTF_VARCHAR2_TABLE_500
1494     , p6_a63 JTF_VARCHAR2_TABLE_500
1495     , p6_a64 JTF_VARCHAR2_TABLE_500
1496     , p6_a65 JTF_VARCHAR2_TABLE_500
1497     , p6_a66 JTF_VARCHAR2_TABLE_500
1498     , p6_a67 JTF_VARCHAR2_TABLE_500
1499     , p6_a68 JTF_VARCHAR2_TABLE_500
1500     , p6_a69 JTF_VARCHAR2_TABLE_500
1501     , p6_a70 JTF_VARCHAR2_TABLE_500
1502     , p6_a71 JTF_VARCHAR2_TABLE_500
1503     , p6_a72 JTF_VARCHAR2_TABLE_500
1504     , p6_a73 JTF_VARCHAR2_TABLE_500
1505     , p6_a74 JTF_VARCHAR2_TABLE_500
1506     , p6_a75 JTF_VARCHAR2_TABLE_500
1507     , p6_a76 JTF_NUMBER_TABLE
1508     , p6_a77 JTF_NUMBER_TABLE
1509     , p6_a78 JTF_NUMBER_TABLE
1510     , p6_a79 JTF_DATE_TABLE
1511     , p6_a80 JTF_NUMBER_TABLE
1512     , p6_a81 JTF_DATE_TABLE
1513     , p6_a82 JTF_NUMBER_TABLE
1514     , p6_a83 JTF_DATE_TABLE
1515     , p6_a84 JTF_DATE_TABLE
1516     , p6_a85 JTF_DATE_TABLE
1517     , p6_a86 JTF_DATE_TABLE
1518     , p6_a87 JTF_NUMBER_TABLE
1519     , p6_a88 JTF_NUMBER_TABLE
1520     , p6_a89 JTF_NUMBER_TABLE
1521     , p6_a90 JTF_VARCHAR2_TABLE_100
1522     , p6_a91 JTF_NUMBER_TABLE
1523     , p6_a92 JTF_VARCHAR2_TABLE_100
1524     , p6_a93 JTF_NUMBER_TABLE
1525     , p6_a94 JTF_NUMBER_TABLE
1526     , p6_a95 JTF_DATE_TABLE
1527     , p6_a96 JTF_VARCHAR2_TABLE_100
1528     , p6_a97 JTF_VARCHAR2_TABLE_100
1529     , p6_a98 JTF_NUMBER_TABLE
1530     , p7_a0 out nocopy JTF_NUMBER_TABLE
1531     , p7_a1 out nocopy JTF_NUMBER_TABLE
1532     , p7_a2 out nocopy JTF_NUMBER_TABLE
1533     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
1534     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
1535     , p7_a5 out nocopy JTF_NUMBER_TABLE
1536     , p7_a6 out nocopy JTF_NUMBER_TABLE
1537     , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1538     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
1539     , p7_a9 out nocopy JTF_DATE_TABLE
1540     , p8_a0 out nocopy JTF_NUMBER_TABLE
1541     , p8_a1 out nocopy JTF_NUMBER_TABLE
1542     , p8_a2 out nocopy JTF_NUMBER_TABLE
1543     , p8_a3 out nocopy JTF_NUMBER_TABLE
1544     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1545     , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1546     , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
1547     , p8_a7 out nocopy JTF_NUMBER_TABLE
1548     , p8_a8 out nocopy JTF_NUMBER_TABLE
1549     , p8_a9 out nocopy JTF_DATE_TABLE
1550     , p8_a10 out nocopy JTF_NUMBER_TABLE
1551     , p8_a11 out nocopy JTF_NUMBER_TABLE
1552     , p8_a12 out nocopy JTF_NUMBER_TABLE
1553     , p8_a13 out nocopy JTF_NUMBER_TABLE
1554     , p8_a14 out nocopy JTF_NUMBER_TABLE
1555     , p8_a15 out nocopy JTF_NUMBER_TABLE
1556     , p8_a16 out nocopy JTF_NUMBER_TABLE
1557     , p8_a17 out nocopy JTF_NUMBER_TABLE
1558     , p8_a18 out nocopy JTF_NUMBER_TABLE
1559     , p8_a19 out nocopy JTF_NUMBER_TABLE
1560     , p8_a20 out nocopy JTF_DATE_TABLE
1561     , p8_a21 out nocopy JTF_DATE_TABLE
1562     , p8_a22 out nocopy JTF_NUMBER_TABLE
1563     , p8_a23 out nocopy JTF_NUMBER_TABLE
1564     , p8_a24 out nocopy JTF_DATE_TABLE
1565     , p8_a25 out nocopy JTF_DATE_TABLE
1566     , p8_a26 out nocopy JTF_DATE_TABLE
1567     , p8_a27 out nocopy JTF_NUMBER_TABLE
1568     , p8_a28 out nocopy JTF_NUMBER_TABLE
1569     , p8_a29 out nocopy JTF_NUMBER_TABLE
1570     , p8_a30 out nocopy JTF_NUMBER_TABLE
1571     , p8_a31 out nocopy JTF_NUMBER_TABLE
1572     , p8_a32 out nocopy JTF_NUMBER_TABLE
1573     , p8_a33 out nocopy JTF_NUMBER_TABLE
1574     , p8_a34 out nocopy JTF_DATE_TABLE
1575     , p8_a35 out nocopy JTF_VARCHAR2_TABLE_100
1576     , p8_a36 out nocopy JTF_DATE_TABLE
1577     , p8_a37 out nocopy JTF_VARCHAR2_TABLE_300
1578     , p8_a38 out nocopy JTF_NUMBER_TABLE
1579     , p8_a39 out nocopy JTF_NUMBER_TABLE
1580     , p8_a40 out nocopy JTF_NUMBER_TABLE
1581     , p8_a41 out nocopy JTF_VARCHAR2_TABLE_100
1582     , p8_a42 out nocopy JTF_DATE_TABLE
1583     , p8_a43 out nocopy JTF_NUMBER_TABLE
1584     , p8_a44 out nocopy JTF_NUMBER_TABLE
1585     , p8_a45 out nocopy JTF_DATE_TABLE
1586     , p8_a46 out nocopy JTF_NUMBER_TABLE
1587     , p8_a47 out nocopy JTF_DATE_TABLE
1588     , p8_a48 out nocopy JTF_DATE_TABLE
1589     , p8_a49 out nocopy JTF_DATE_TABLE
1590     , p8_a50 out nocopy JTF_NUMBER_TABLE
1591     , p8_a51 out nocopy JTF_NUMBER_TABLE
1592     , p8_a52 out nocopy JTF_VARCHAR2_TABLE_100
1593     , p8_a53 out nocopy JTF_NUMBER_TABLE
1594     , p8_a54 out nocopy JTF_NUMBER_TABLE
1595     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_100
1596     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
1597     , p8_a57 out nocopy JTF_NUMBER_TABLE
1598     , p8_a58 out nocopy JTF_DATE_TABLE
1599     , p8_a59 out nocopy JTF_NUMBER_TABLE
1600     , p8_a60 out nocopy JTF_VARCHAR2_TABLE_100
1601     , p8_a61 out nocopy JTF_VARCHAR2_TABLE_500
1602     , p8_a62 out nocopy JTF_VARCHAR2_TABLE_500
1603     , p8_a63 out nocopy JTF_VARCHAR2_TABLE_500
1604     , p8_a64 out nocopy JTF_VARCHAR2_TABLE_500
1605     , p8_a65 out nocopy JTF_VARCHAR2_TABLE_500
1606     , p8_a66 out nocopy JTF_VARCHAR2_TABLE_500
1607     , p8_a67 out nocopy JTF_VARCHAR2_TABLE_500
1608     , p8_a68 out nocopy JTF_VARCHAR2_TABLE_500
1609     , p8_a69 out nocopy JTF_VARCHAR2_TABLE_500
1610     , p8_a70 out nocopy JTF_VARCHAR2_TABLE_500
1611     , p8_a71 out nocopy JTF_VARCHAR2_TABLE_500
1612     , p8_a72 out nocopy JTF_VARCHAR2_TABLE_500
1613     , p8_a73 out nocopy JTF_VARCHAR2_TABLE_500
1614     , p8_a74 out nocopy JTF_VARCHAR2_TABLE_500
1615     , p8_a75 out nocopy JTF_VARCHAR2_TABLE_500
1616     , p8_a76 out nocopy JTF_NUMBER_TABLE
1617     , p8_a77 out nocopy JTF_NUMBER_TABLE
1618     , p8_a78 out nocopy JTF_NUMBER_TABLE
1619     , p8_a79 out nocopy JTF_DATE_TABLE
1620     , p8_a80 out nocopy JTF_NUMBER_TABLE
1621     , p8_a81 out nocopy JTF_DATE_TABLE
1622     , p8_a82 out nocopy JTF_NUMBER_TABLE
1623     , p8_a83 out nocopy JTF_DATE_TABLE
1624     , p8_a84 out nocopy JTF_DATE_TABLE
1625     , p8_a85 out nocopy JTF_DATE_TABLE
1626     , p8_a86 out nocopy JTF_DATE_TABLE
1627     , p8_a87 out nocopy JTF_NUMBER_TABLE
1628     , p8_a88 out nocopy JTF_NUMBER_TABLE
1629     , p8_a89 out nocopy JTF_NUMBER_TABLE
1630     , p8_a90 out nocopy JTF_VARCHAR2_TABLE_100
1631     , p8_a91 out nocopy JTF_NUMBER_TABLE
1632     , p8_a92 out nocopy JTF_VARCHAR2_TABLE_100
1633     , p8_a93 out nocopy JTF_NUMBER_TABLE
1634     , p8_a94 out nocopy JTF_NUMBER_TABLE
1635     , p8_a95 out nocopy JTF_DATE_TABLE
1636     , p8_a96 out nocopy JTF_VARCHAR2_TABLE_100
1637     , p8_a97 out nocopy JTF_VARCHAR2_TABLE_100
1638     , p8_a98 out nocopy JTF_NUMBER_TABLE
1639   );
1640   procedure delete_credit_limit(p_api_version  NUMBER
1641     , p_init_msg_list  VARCHAR2
1642     , x_return_status out nocopy  VARCHAR2
1643     , x_msg_count out nocopy  NUMBER
1644     , x_msg_data out nocopy  VARCHAR2
1645     , p5_a0 JTF_NUMBER_TABLE
1646     , p5_a1 JTF_NUMBER_TABLE
1647     , p5_a2 JTF_NUMBER_TABLE
1648     , p5_a3 JTF_VARCHAR2_TABLE_200
1649     , p5_a4 JTF_VARCHAR2_TABLE_100
1650     , p5_a5 JTF_NUMBER_TABLE
1651     , p5_a6 JTF_NUMBER_TABLE
1652     , p5_a7 JTF_VARCHAR2_TABLE_2000
1653     , p5_a8 JTF_VARCHAR2_TABLE_100
1654     , p5_a9 JTF_DATE_TABLE
1655     , p6_a0 JTF_NUMBER_TABLE
1656     , p6_a1 JTF_NUMBER_TABLE
1657     , p6_a2 JTF_NUMBER_TABLE
1658     , p6_a3 JTF_NUMBER_TABLE
1659     , p6_a4 JTF_VARCHAR2_TABLE_100
1660     , p6_a5 JTF_VARCHAR2_TABLE_100
1661     , p6_a6 JTF_VARCHAR2_TABLE_100
1662     , p6_a7 JTF_NUMBER_TABLE
1663     , p6_a8 JTF_NUMBER_TABLE
1664     , p6_a9 JTF_DATE_TABLE
1665     , p6_a10 JTF_NUMBER_TABLE
1666     , p6_a11 JTF_NUMBER_TABLE
1667     , p6_a12 JTF_NUMBER_TABLE
1668     , p6_a13 JTF_NUMBER_TABLE
1669     , p6_a14 JTF_NUMBER_TABLE
1670     , p6_a15 JTF_NUMBER_TABLE
1671     , p6_a16 JTF_NUMBER_TABLE
1672     , p6_a17 JTF_NUMBER_TABLE
1673     , p6_a18 JTF_NUMBER_TABLE
1674     , p6_a19 JTF_NUMBER_TABLE
1675     , p6_a20 JTF_DATE_TABLE
1676     , p6_a21 JTF_DATE_TABLE
1677     , p6_a22 JTF_NUMBER_TABLE
1678     , p6_a23 JTF_NUMBER_TABLE
1679     , p6_a24 JTF_DATE_TABLE
1680     , p6_a25 JTF_DATE_TABLE
1681     , p6_a26 JTF_DATE_TABLE
1682     , p6_a27 JTF_NUMBER_TABLE
1683     , p6_a28 JTF_NUMBER_TABLE
1684     , p6_a29 JTF_NUMBER_TABLE
1685     , p6_a30 JTF_NUMBER_TABLE
1686     , p6_a31 JTF_NUMBER_TABLE
1687     , p6_a32 JTF_NUMBER_TABLE
1688     , p6_a33 JTF_NUMBER_TABLE
1689     , p6_a34 JTF_DATE_TABLE
1690     , p6_a35 JTF_VARCHAR2_TABLE_100
1691     , p6_a36 JTF_DATE_TABLE
1692     , p6_a37 JTF_VARCHAR2_TABLE_300
1693     , p6_a38 JTF_NUMBER_TABLE
1694     , p6_a39 JTF_NUMBER_TABLE
1695     , p6_a40 JTF_NUMBER_TABLE
1696     , p6_a41 JTF_VARCHAR2_TABLE_100
1697     , p6_a42 JTF_DATE_TABLE
1698     , p6_a43 JTF_NUMBER_TABLE
1699     , p6_a44 JTF_NUMBER_TABLE
1700     , p6_a45 JTF_DATE_TABLE
1701     , p6_a46 JTF_NUMBER_TABLE
1702     , p6_a47 JTF_DATE_TABLE
1703     , p6_a48 JTF_DATE_TABLE
1704     , p6_a49 JTF_DATE_TABLE
1705     , p6_a50 JTF_NUMBER_TABLE
1706     , p6_a51 JTF_NUMBER_TABLE
1707     , p6_a52 JTF_VARCHAR2_TABLE_100
1708     , p6_a53 JTF_NUMBER_TABLE
1709     , p6_a54 JTF_NUMBER_TABLE
1710     , p6_a55 JTF_VARCHAR2_TABLE_100
1711     , p6_a56 JTF_VARCHAR2_TABLE_100
1712     , p6_a57 JTF_NUMBER_TABLE
1713     , p6_a58 JTF_DATE_TABLE
1714     , p6_a59 JTF_NUMBER_TABLE
1715     , p6_a60 JTF_VARCHAR2_TABLE_100
1716     , p6_a61 JTF_VARCHAR2_TABLE_500
1717     , p6_a62 JTF_VARCHAR2_TABLE_500
1718     , p6_a63 JTF_VARCHAR2_TABLE_500
1719     , p6_a64 JTF_VARCHAR2_TABLE_500
1720     , p6_a65 JTF_VARCHAR2_TABLE_500
1721     , p6_a66 JTF_VARCHAR2_TABLE_500
1722     , p6_a67 JTF_VARCHAR2_TABLE_500
1723     , p6_a68 JTF_VARCHAR2_TABLE_500
1724     , p6_a69 JTF_VARCHAR2_TABLE_500
1725     , p6_a70 JTF_VARCHAR2_TABLE_500
1726     , p6_a71 JTF_VARCHAR2_TABLE_500
1727     , p6_a72 JTF_VARCHAR2_TABLE_500
1728     , p6_a73 JTF_VARCHAR2_TABLE_500
1729     , p6_a74 JTF_VARCHAR2_TABLE_500
1730     , p6_a75 JTF_VARCHAR2_TABLE_500
1731     , p6_a76 JTF_NUMBER_TABLE
1732     , p6_a77 JTF_NUMBER_TABLE
1733     , p6_a78 JTF_NUMBER_TABLE
1734     , p6_a79 JTF_DATE_TABLE
1735     , p6_a80 JTF_NUMBER_TABLE
1736     , p6_a81 JTF_DATE_TABLE
1737     , p6_a82 JTF_NUMBER_TABLE
1738     , p6_a83 JTF_DATE_TABLE
1739     , p6_a84 JTF_DATE_TABLE
1740     , p6_a85 JTF_DATE_TABLE
1741     , p6_a86 JTF_DATE_TABLE
1742     , p6_a87 JTF_NUMBER_TABLE
1743     , p6_a88 JTF_NUMBER_TABLE
1744     , p6_a89 JTF_NUMBER_TABLE
1745     , p6_a90 JTF_VARCHAR2_TABLE_100
1746     , p6_a91 JTF_NUMBER_TABLE
1747     , p6_a92 JTF_VARCHAR2_TABLE_100
1748     , p6_a93 JTF_NUMBER_TABLE
1749     , p6_a94 JTF_NUMBER_TABLE
1750     , p6_a95 JTF_DATE_TABLE
1751     , p6_a96 JTF_VARCHAR2_TABLE_100
1752     , p6_a97 JTF_VARCHAR2_TABLE_100
1753     , p6_a98 JTF_NUMBER_TABLE
1754   );
1755 end okl_credit_pub_w;