DBA Data[Home] [Help]

PACKAGE: APPS.OKL_TRX_CONTRACTS_PUB_W

Source


1 package okl_trx_contracts_pub_w as
2   /* $Header: OKLUTCNS.pls 120.8.12010000.6 2008/11/12 23:53:01 apaul ship $ */
3   procedure create_trx_contracts(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 JTF_NUMBER_TABLE
9     , p6_a1 JTF_NUMBER_TABLE
10     , p6_a2 JTF_NUMBER_TABLE
11     , p6_a3 JTF_NUMBER_TABLE
12     , p6_a4 JTF_NUMBER_TABLE
13     , p6_a5 JTF_NUMBER_TABLE
14     , p6_a6 JTF_NUMBER_TABLE
15     , p6_a7 JTF_NUMBER_TABLE
16     , p6_a8 JTF_VARCHAR2_TABLE_100
17     , p6_a9 JTF_NUMBER_TABLE
18     , p6_a10 JTF_VARCHAR2_TABLE_2000
19     , p6_a11 JTF_NUMBER_TABLE
20     , p6_a12 JTF_VARCHAR2_TABLE_200
21     , p6_a13 JTF_VARCHAR2_TABLE_100
22     , p6_a14 JTF_VARCHAR2_TABLE_100
23     , p6_a15 JTF_VARCHAR2_TABLE_500
24     , p6_a16 JTF_VARCHAR2_TABLE_500
25     , p6_a17 JTF_VARCHAR2_TABLE_500
26     , p6_a18 JTF_VARCHAR2_TABLE_500
27     , p6_a19 JTF_VARCHAR2_TABLE_500
28     , p6_a20 JTF_VARCHAR2_TABLE_500
29     , p6_a21 JTF_VARCHAR2_TABLE_500
30     , p6_a22 JTF_VARCHAR2_TABLE_500
31     , p6_a23 JTF_VARCHAR2_TABLE_500
32     , p6_a24 JTF_VARCHAR2_TABLE_500
33     , p6_a25 JTF_VARCHAR2_TABLE_500
34     , p6_a26 JTF_VARCHAR2_TABLE_500
35     , p6_a27 JTF_VARCHAR2_TABLE_500
36     , p6_a28 JTF_VARCHAR2_TABLE_500
37     , p6_a29 JTF_VARCHAR2_TABLE_500
38     , p6_a30 JTF_VARCHAR2_TABLE_100
39     , p6_a31 JTF_NUMBER_TABLE
40     , p6_a32 JTF_DATE_TABLE
41     , p6_a33 JTF_NUMBER_TABLE
42     , p6_a34 JTF_DATE_TABLE
43     , p6_a35 JTF_NUMBER_TABLE
44     , p6_a36 JTF_NUMBER_TABLE
45     , p6_a37 JTF_NUMBER_TABLE
46     , p6_a38 JTF_NUMBER_TABLE
47     , p6_a39 JTF_DATE_TABLE
48     , p6_a40 JTF_NUMBER_TABLE
49     , p6_a41 JTF_NUMBER_TABLE
50     , p6_a42 JTF_NUMBER_TABLE
51     , p6_a43 JTF_NUMBER_TABLE
52     , p6_a44 JTF_NUMBER_TABLE
53     , p6_a45 JTF_VARCHAR2_TABLE_100
54     , p6_a46 JTF_VARCHAR2_TABLE_200
55     , p6_a47 JTF_NUMBER_TABLE
56     , p6_a48 JTF_VARCHAR2_TABLE_200
57     , p6_a49 JTF_NUMBER_TABLE
58     , p6_a50 JTF_VARCHAR2_TABLE_200
59     , p6_a51 JTF_NUMBER_TABLE
60     , p6_a52 JTF_DATE_TABLE
61     , p6_a53 JTF_NUMBER_TABLE
62     , p6_a54 JTF_VARCHAR2_TABLE_200
63     , p6_a55 JTF_VARCHAR2_TABLE_300
64     , p6_a56 JTF_VARCHAR2_TABLE_100
65     , p6_a57 JTF_VARCHAR2_TABLE_100
66     , p7_a0 out nocopy  NUMBER
67     , p7_a1 out nocopy  NUMBER
68     , p7_a2 out nocopy  VARCHAR2
69     , p7_a3 out nocopy  VARCHAR2
70     , p7_a4 out nocopy  VARCHAR2
71     , p7_a5 out nocopy  VARCHAR2
72     , p7_a6 out nocopy  NUMBER
73     , p7_a7 out nocopy  NUMBER
74     , p7_a8 out nocopy  NUMBER
75     , p7_a9 out nocopy  NUMBER
76     , p7_a10 out nocopy  NUMBER
77     , p7_a11 out nocopy  NUMBER
78     , p7_a12 out nocopy  VARCHAR2
79     , p7_a13 out nocopy  VARCHAR2
80     , p7_a14 out nocopy  DATE
81     , p7_a15 out nocopy  VARCHAR2
82     , p7_a16 out nocopy  VARCHAR2
83     , p7_a17 out nocopy  NUMBER
84     , p7_a18 out nocopy  VARCHAR2
85     , p7_a19 out nocopy  VARCHAR2
86     , p7_a20 out nocopy  VARCHAR2
87     , p7_a21 out nocopy  VARCHAR2
88     , p7_a22 out nocopy  VARCHAR2
89     , p7_a23 out nocopy  VARCHAR2
90     , p7_a24 out nocopy  VARCHAR2
91     , p7_a25 out nocopy  VARCHAR2
92     , p7_a26 out nocopy  VARCHAR2
93     , p7_a27 out nocopy  VARCHAR2
94     , p7_a28 out nocopy  VARCHAR2
95     , p7_a29 out nocopy  VARCHAR2
96     , p7_a30 out nocopy  VARCHAR2
97     , p7_a31 out nocopy  VARCHAR2
98     , p7_a32 out nocopy  VARCHAR2
99     , p7_a33 out nocopy  VARCHAR2
100     , p7_a34 out nocopy  VARCHAR2
101     , p7_a35 out nocopy  VARCHAR2
102     , p7_a36 out nocopy  VARCHAR2
103     , p7_a37 out nocopy  NUMBER
104     , p7_a38 out nocopy  VARCHAR2
105     , p7_a39 out nocopy  NUMBER
106     , p7_a40 out nocopy  VARCHAR2
107     , p7_a41 out nocopy  VARCHAR2
108     , p7_a42 out nocopy  NUMBER
109     , p7_a43 out nocopy  NUMBER
110     , p7_a44 out nocopy  NUMBER
111     , p7_a45 out nocopy  NUMBER
112     , p7_a46 out nocopy  NUMBER
113     , p7_a47 out nocopy  NUMBER
114     , p7_a48 out nocopy  DATE
115     , p7_a49 out nocopy  NUMBER
116     , p7_a50 out nocopy  DATE
117     , p7_a51 out nocopy  NUMBER
118     , p7_a52 out nocopy  DATE
119     , p7_a53 out nocopy  NUMBER
120     , p7_a54 out nocopy  NUMBER
121     , p7_a55 out nocopy  VARCHAR2
122     , p7_a56 out nocopy  NUMBER
123     , p7_a57 out nocopy  VARCHAR2
124     , p7_a58 out nocopy  DATE
125     , p7_a59 out nocopy  VARCHAR2
126     , p7_a60 out nocopy  VARCHAR2
127     , p7_a61 out nocopy  VARCHAR2
128     , p7_a62 out nocopy  VARCHAR2
129     , p7_a63 out nocopy  VARCHAR2
130     , p7_a64 out nocopy  VARCHAR2
131     , p7_a65 out nocopy  VARCHAR2
132     , p7_a66 out nocopy  VARCHAR2
133     , p7_a67 out nocopy  VARCHAR2
134     , p7_a68 out nocopy  VARCHAR2
135     , p7_a69 out nocopy  VARCHAR2
136     , p7_a70 out nocopy  VARCHAR2
137     , p7_a71 out nocopy  VARCHAR2
138     , p7_a72 out nocopy  VARCHAR2
139     , p7_a73 out nocopy  VARCHAR2
140     , p7_a74 out nocopy  VARCHAR2
141     , p7_a75 out nocopy  VARCHAR2
142     , p7_a76 out nocopy  VARCHAR2
143     , p7_a77 out nocopy  NUMBER
144     , p7_a78 out nocopy  DATE
145     , p7_a79 out nocopy  NUMBER
146     , p7_a80 out nocopy  NUMBER
147     , p7_a81 out nocopy  VARCHAR2
148     , p7_a82 out nocopy  DATE
149     , p7_a83 out nocopy  NUMBER
150     , p7_a84 out nocopy  DATE
151     , p7_a85 out nocopy  VARCHAR2
152     , p7_a86 out nocopy  VARCHAR2
153     , p7_a87 out nocopy  VARCHAR2
154     , p7_a88 out nocopy  VARCHAR2
155     , p7_a89 out nocopy  VARCHAR2
156     , p7_a90 out nocopy  VARCHAR2
157     , p7_a91 out nocopy  VARCHAR2
158     , p7_a92 out nocopy  VARCHAR2
159     , p7_a93 out nocopy  DATE
160     , p8_a0 out nocopy JTF_NUMBER_TABLE
161     , p8_a1 out nocopy JTF_NUMBER_TABLE
162     , p8_a2 out nocopy JTF_NUMBER_TABLE
163     , p8_a3 out nocopy JTF_NUMBER_TABLE
164     , p8_a4 out nocopy JTF_NUMBER_TABLE
165     , p8_a5 out nocopy JTF_NUMBER_TABLE
166     , p8_a6 out nocopy JTF_NUMBER_TABLE
167     , p8_a7 out nocopy JTF_NUMBER_TABLE
168     , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
169     , p8_a9 out nocopy JTF_NUMBER_TABLE
170     , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
171     , p8_a11 out nocopy JTF_NUMBER_TABLE
172     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
173     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
174     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
175     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
176     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
177     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
178     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
179     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
180     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
181     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
182     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
183     , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
184     , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
185     , p8_a25 out nocopy JTF_VARCHAR2_TABLE_500
186     , p8_a26 out nocopy JTF_VARCHAR2_TABLE_500
187     , p8_a27 out nocopy JTF_VARCHAR2_TABLE_500
188     , p8_a28 out nocopy JTF_VARCHAR2_TABLE_500
189     , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
190     , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
191     , p8_a31 out nocopy JTF_NUMBER_TABLE
192     , p8_a32 out nocopy JTF_DATE_TABLE
193     , p8_a33 out nocopy JTF_NUMBER_TABLE
194     , p8_a34 out nocopy JTF_DATE_TABLE
195     , p8_a35 out nocopy JTF_NUMBER_TABLE
196     , p8_a36 out nocopy JTF_NUMBER_TABLE
197     , p8_a37 out nocopy JTF_NUMBER_TABLE
198     , p8_a38 out nocopy JTF_NUMBER_TABLE
199     , p8_a39 out nocopy JTF_DATE_TABLE
200     , p8_a40 out nocopy JTF_NUMBER_TABLE
201     , p8_a41 out nocopy JTF_NUMBER_TABLE
202     , p8_a42 out nocopy JTF_NUMBER_TABLE
203     , p8_a43 out nocopy JTF_NUMBER_TABLE
204     , p8_a44 out nocopy JTF_NUMBER_TABLE
205     , p8_a45 out nocopy JTF_VARCHAR2_TABLE_100
206     , p8_a46 out nocopy JTF_VARCHAR2_TABLE_200
207     , p8_a47 out nocopy JTF_NUMBER_TABLE
208     , p8_a48 out nocopy JTF_VARCHAR2_TABLE_200
209     , p8_a49 out nocopy JTF_NUMBER_TABLE
210     , p8_a50 out nocopy JTF_VARCHAR2_TABLE_200
211     , p8_a51 out nocopy JTF_NUMBER_TABLE
212     , p8_a52 out nocopy JTF_DATE_TABLE
213     , p8_a53 out nocopy JTF_NUMBER_TABLE
214     , p8_a54 out nocopy JTF_VARCHAR2_TABLE_200
215     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_300
216     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
217     , p8_a57 out nocopy JTF_VARCHAR2_TABLE_100
218     , p5_a0  NUMBER := 0-1962.0724
219     , p5_a1  NUMBER := 0-1962.0724
220     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
222     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
223     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
224     , p5_a6  NUMBER := 0-1962.0724
225     , p5_a7  NUMBER := 0-1962.0724
226     , p5_a8  NUMBER := 0-1962.0724
227     , p5_a9  NUMBER := 0-1962.0724
228     , p5_a10  NUMBER := 0-1962.0724
229     , p5_a11  NUMBER := 0-1962.0724
230     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a14  DATE := fnd_api.g_miss_date
233     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a17  NUMBER := 0-1962.0724
236     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
244     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
245     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
246     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
247     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
248     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
249     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
250     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
251     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
252     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
253     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
254     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
255     , p5_a37  NUMBER := 0-1962.0724
256     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
257     , p5_a39  NUMBER := 0-1962.0724
258     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
259     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
260     , p5_a42  NUMBER := 0-1962.0724
261     , p5_a43  NUMBER := 0-1962.0724
262     , p5_a44  NUMBER := 0-1962.0724
263     , p5_a45  NUMBER := 0-1962.0724
264     , p5_a46  NUMBER := 0-1962.0724
265     , p5_a47  NUMBER := 0-1962.0724
266     , p5_a48  DATE := fnd_api.g_miss_date
267     , p5_a49  NUMBER := 0-1962.0724
268     , p5_a50  DATE := fnd_api.g_miss_date
269     , p5_a51  NUMBER := 0-1962.0724
270     , p5_a52  DATE := fnd_api.g_miss_date
271     , p5_a53  NUMBER := 0-1962.0724
272     , p5_a54  NUMBER := 0-1962.0724
273     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
274     , p5_a56  NUMBER := 0-1962.0724
275     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
276     , p5_a58  DATE := fnd_api.g_miss_date
277     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
278     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
279     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
280     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
281     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
282     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
283     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
284     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
285     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
286     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
287     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
288     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
289     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
290     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
291     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
292     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
293     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
294     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
295     , p5_a77  NUMBER := 0-1962.0724
296     , p5_a78  DATE := fnd_api.g_miss_date
297     , p5_a79  NUMBER := 0-1962.0724
298     , p5_a80  NUMBER := 0-1962.0724
299     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
300     , p5_a82  DATE := fnd_api.g_miss_date
301     , p5_a83  NUMBER := 0-1962.0724
302     , p5_a84  DATE := fnd_api.g_miss_date
303     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
304     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
305     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
306     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
307     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
308     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
309     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
310     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
311     , p5_a93  DATE := fnd_api.g_miss_date
312   );
313   procedure update_trx_contracts(p_api_version  NUMBER
314     , p_init_msg_list  VARCHAR2
315     , x_return_status out nocopy  VARCHAR2
316     , x_msg_count out nocopy  NUMBER
317     , x_msg_data out nocopy  VARCHAR2
318     , p6_a0 JTF_NUMBER_TABLE
319     , p6_a1 JTF_NUMBER_TABLE
320     , p6_a2 JTF_NUMBER_TABLE
321     , p6_a3 JTF_NUMBER_TABLE
322     , p6_a4 JTF_NUMBER_TABLE
323     , p6_a5 JTF_NUMBER_TABLE
324     , p6_a6 JTF_NUMBER_TABLE
325     , p6_a7 JTF_NUMBER_TABLE
326     , p6_a8 JTF_VARCHAR2_TABLE_100
327     , p6_a9 JTF_NUMBER_TABLE
328     , p6_a10 JTF_VARCHAR2_TABLE_2000
329     , p6_a11 JTF_NUMBER_TABLE
330     , p6_a12 JTF_VARCHAR2_TABLE_200
331     , p6_a13 JTF_VARCHAR2_TABLE_100
332     , p6_a14 JTF_VARCHAR2_TABLE_100
333     , p6_a15 JTF_VARCHAR2_TABLE_500
334     , p6_a16 JTF_VARCHAR2_TABLE_500
335     , p6_a17 JTF_VARCHAR2_TABLE_500
336     , p6_a18 JTF_VARCHAR2_TABLE_500
337     , p6_a19 JTF_VARCHAR2_TABLE_500
338     , p6_a20 JTF_VARCHAR2_TABLE_500
339     , p6_a21 JTF_VARCHAR2_TABLE_500
340     , p6_a22 JTF_VARCHAR2_TABLE_500
341     , p6_a23 JTF_VARCHAR2_TABLE_500
342     , p6_a24 JTF_VARCHAR2_TABLE_500
343     , p6_a25 JTF_VARCHAR2_TABLE_500
344     , p6_a26 JTF_VARCHAR2_TABLE_500
345     , p6_a27 JTF_VARCHAR2_TABLE_500
346     , p6_a28 JTF_VARCHAR2_TABLE_500
347     , p6_a29 JTF_VARCHAR2_TABLE_500
348     , p6_a30 JTF_VARCHAR2_TABLE_100
349     , p6_a31 JTF_NUMBER_TABLE
350     , p6_a32 JTF_DATE_TABLE
351     , p6_a33 JTF_NUMBER_TABLE
352     , p6_a34 JTF_DATE_TABLE
353     , p6_a35 JTF_NUMBER_TABLE
354     , p6_a36 JTF_NUMBER_TABLE
355     , p6_a37 JTF_NUMBER_TABLE
356     , p6_a38 JTF_NUMBER_TABLE
357     , p6_a39 JTF_DATE_TABLE
358     , p6_a40 JTF_NUMBER_TABLE
359     , p6_a41 JTF_NUMBER_TABLE
360     , p6_a42 JTF_NUMBER_TABLE
361     , p6_a43 JTF_NUMBER_TABLE
362     , p6_a44 JTF_NUMBER_TABLE
363     , p6_a45 JTF_VARCHAR2_TABLE_100
364     , p6_a46 JTF_VARCHAR2_TABLE_200
365     , p6_a47 JTF_NUMBER_TABLE
366     , p6_a48 JTF_VARCHAR2_TABLE_200
367     , p6_a49 JTF_NUMBER_TABLE
368     , p6_a50 JTF_VARCHAR2_TABLE_200
369     , p6_a51 JTF_NUMBER_TABLE
370     , p6_a52 JTF_DATE_TABLE
371     , p6_a53 JTF_NUMBER_TABLE
372     , p6_a54 JTF_VARCHAR2_TABLE_200
373     , p6_a55 JTF_VARCHAR2_TABLE_300
374     , p6_a56 JTF_VARCHAR2_TABLE_100
375     , p6_a57 JTF_VARCHAR2_TABLE_100
376     , p7_a0 out nocopy  NUMBER
377     , p7_a1 out nocopy  NUMBER
378     , p7_a2 out nocopy  VARCHAR2
379     , p7_a3 out nocopy  VARCHAR2
380     , p7_a4 out nocopy  VARCHAR2
381     , p7_a5 out nocopy  VARCHAR2
382     , p7_a6 out nocopy  NUMBER
383     , p7_a7 out nocopy  NUMBER
384     , p7_a8 out nocopy  NUMBER
385     , p7_a9 out nocopy  NUMBER
386     , p7_a10 out nocopy  NUMBER
387     , p7_a11 out nocopy  NUMBER
388     , p7_a12 out nocopy  VARCHAR2
389     , p7_a13 out nocopy  VARCHAR2
390     , p7_a14 out nocopy  DATE
391     , p7_a15 out nocopy  VARCHAR2
392     , p7_a16 out nocopy  VARCHAR2
393     , p7_a17 out nocopy  NUMBER
394     , p7_a18 out nocopy  VARCHAR2
395     , p7_a19 out nocopy  VARCHAR2
396     , p7_a20 out nocopy  VARCHAR2
397     , p7_a21 out nocopy  VARCHAR2
398     , p7_a22 out nocopy  VARCHAR2
399     , p7_a23 out nocopy  VARCHAR2
400     , p7_a24 out nocopy  VARCHAR2
401     , p7_a25 out nocopy  VARCHAR2
402     , p7_a26 out nocopy  VARCHAR2
403     , p7_a27 out nocopy  VARCHAR2
404     , p7_a28 out nocopy  VARCHAR2
405     , p7_a29 out nocopy  VARCHAR2
406     , p7_a30 out nocopy  VARCHAR2
407     , p7_a31 out nocopy  VARCHAR2
408     , p7_a32 out nocopy  VARCHAR2
409     , p7_a33 out nocopy  VARCHAR2
410     , p7_a34 out nocopy  VARCHAR2
411     , p7_a35 out nocopy  VARCHAR2
412     , p7_a36 out nocopy  VARCHAR2
413     , p7_a37 out nocopy  NUMBER
414     , p7_a38 out nocopy  VARCHAR2
415     , p7_a39 out nocopy  NUMBER
416     , p7_a40 out nocopy  VARCHAR2
417     , p7_a41 out nocopy  VARCHAR2
418     , p7_a42 out nocopy  NUMBER
419     , p7_a43 out nocopy  NUMBER
420     , p7_a44 out nocopy  NUMBER
421     , p7_a45 out nocopy  NUMBER
422     , p7_a46 out nocopy  NUMBER
423     , p7_a47 out nocopy  NUMBER
424     , p7_a48 out nocopy  DATE
425     , p7_a49 out nocopy  NUMBER
426     , p7_a50 out nocopy  DATE
427     , p7_a51 out nocopy  NUMBER
428     , p7_a52 out nocopy  DATE
429     , p7_a53 out nocopy  NUMBER
430     , p7_a54 out nocopy  NUMBER
431     , p7_a55 out nocopy  VARCHAR2
432     , p7_a56 out nocopy  NUMBER
433     , p7_a57 out nocopy  VARCHAR2
434     , p7_a58 out nocopy  DATE
435     , p7_a59 out nocopy  VARCHAR2
436     , p7_a60 out nocopy  VARCHAR2
437     , p7_a61 out nocopy  VARCHAR2
438     , p7_a62 out nocopy  VARCHAR2
439     , p7_a63 out nocopy  VARCHAR2
440     , p7_a64 out nocopy  VARCHAR2
441     , p7_a65 out nocopy  VARCHAR2
442     , p7_a66 out nocopy  VARCHAR2
443     , p7_a67 out nocopy  VARCHAR2
444     , p7_a68 out nocopy  VARCHAR2
445     , p7_a69 out nocopy  VARCHAR2
446     , p7_a70 out nocopy  VARCHAR2
447     , p7_a71 out nocopy  VARCHAR2
448     , p7_a72 out nocopy  VARCHAR2
449     , p7_a73 out nocopy  VARCHAR2
450     , p7_a74 out nocopy  VARCHAR2
451     , p7_a75 out nocopy  VARCHAR2
452     , p7_a76 out nocopy  VARCHAR2
453     , p7_a77 out nocopy  NUMBER
454     , p7_a78 out nocopy  DATE
455     , p7_a79 out nocopy  NUMBER
456     , p7_a80 out nocopy  NUMBER
457     , p7_a81 out nocopy  VARCHAR2
458     , p7_a82 out nocopy  DATE
459     , p7_a83 out nocopy  NUMBER
460     , p7_a84 out nocopy  DATE
461     , p7_a85 out nocopy  VARCHAR2
462     , p7_a86 out nocopy  VARCHAR2
463     , p7_a87 out nocopy  VARCHAR2
464     , p7_a88 out nocopy  VARCHAR2
465     , p7_a89 out nocopy  VARCHAR2
466     , p7_a90 out nocopy  VARCHAR2
467     , p7_a91 out nocopy  VARCHAR2
468     , p7_a92 out nocopy  VARCHAR2
469     , p7_a93 out nocopy  DATE
470     , p8_a0 out nocopy JTF_NUMBER_TABLE
471     , p8_a1 out nocopy JTF_NUMBER_TABLE
472     , p8_a2 out nocopy JTF_NUMBER_TABLE
473     , p8_a3 out nocopy JTF_NUMBER_TABLE
474     , p8_a4 out nocopy JTF_NUMBER_TABLE
475     , p8_a5 out nocopy JTF_NUMBER_TABLE
476     , p8_a6 out nocopy JTF_NUMBER_TABLE
477     , p8_a7 out nocopy JTF_NUMBER_TABLE
478     , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
479     , p8_a9 out nocopy JTF_NUMBER_TABLE
480     , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
481     , p8_a11 out nocopy JTF_NUMBER_TABLE
482     , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
483     , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
484     , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
485     , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
486     , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
487     , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
488     , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
489     , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
490     , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
491     , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
492     , p8_a22 out nocopy JTF_VARCHAR2_TABLE_500
493     , p8_a23 out nocopy JTF_VARCHAR2_TABLE_500
494     , p8_a24 out nocopy JTF_VARCHAR2_TABLE_500
495     , p8_a25 out nocopy JTF_VARCHAR2_TABLE_500
496     , p8_a26 out nocopy JTF_VARCHAR2_TABLE_500
497     , p8_a27 out nocopy JTF_VARCHAR2_TABLE_500
498     , p8_a28 out nocopy JTF_VARCHAR2_TABLE_500
499     , p8_a29 out nocopy JTF_VARCHAR2_TABLE_500
500     , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
501     , p8_a31 out nocopy JTF_NUMBER_TABLE
502     , p8_a32 out nocopy JTF_DATE_TABLE
503     , p8_a33 out nocopy JTF_NUMBER_TABLE
504     , p8_a34 out nocopy JTF_DATE_TABLE
505     , p8_a35 out nocopy JTF_NUMBER_TABLE
506     , p8_a36 out nocopy JTF_NUMBER_TABLE
507     , p8_a37 out nocopy JTF_NUMBER_TABLE
508     , p8_a38 out nocopy JTF_NUMBER_TABLE
509     , p8_a39 out nocopy JTF_DATE_TABLE
510     , p8_a40 out nocopy JTF_NUMBER_TABLE
511     , p8_a41 out nocopy JTF_NUMBER_TABLE
512     , p8_a42 out nocopy JTF_NUMBER_TABLE
513     , p8_a43 out nocopy JTF_NUMBER_TABLE
514     , p8_a44 out nocopy JTF_NUMBER_TABLE
515     , p8_a45 out nocopy JTF_VARCHAR2_TABLE_100
516     , p8_a46 out nocopy JTF_VARCHAR2_TABLE_200
517     , p8_a47 out nocopy JTF_NUMBER_TABLE
518     , p8_a48 out nocopy JTF_VARCHAR2_TABLE_200
519     , p8_a49 out nocopy JTF_NUMBER_TABLE
520     , p8_a50 out nocopy JTF_VARCHAR2_TABLE_200
521     , p8_a51 out nocopy JTF_NUMBER_TABLE
522     , p8_a52 out nocopy JTF_DATE_TABLE
523     , p8_a53 out nocopy JTF_NUMBER_TABLE
524     , p8_a54 out nocopy JTF_VARCHAR2_TABLE_200
525     , p8_a55 out nocopy JTF_VARCHAR2_TABLE_300
526     , p8_a56 out nocopy JTF_VARCHAR2_TABLE_100
527     , p8_a57 out nocopy JTF_VARCHAR2_TABLE_100
528     , p5_a0  NUMBER := 0-1962.0724
529     , p5_a1  NUMBER := 0-1962.0724
530     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
531     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
532     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
533     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
534     , p5_a6  NUMBER := 0-1962.0724
535     , p5_a7  NUMBER := 0-1962.0724
536     , p5_a8  NUMBER := 0-1962.0724
537     , p5_a9  NUMBER := 0-1962.0724
538     , p5_a10  NUMBER := 0-1962.0724
539     , p5_a11  NUMBER := 0-1962.0724
540     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
541     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
542     , p5_a14  DATE := fnd_api.g_miss_date
543     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
544     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
545     , p5_a17  NUMBER := 0-1962.0724
546     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
547     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
548     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
549     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
550     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
551     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
552     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
553     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
554     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
555     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
556     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
557     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
558     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
559     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
560     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
561     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
562     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
563     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
564     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
565     , p5_a37  NUMBER := 0-1962.0724
566     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
567     , p5_a39  NUMBER := 0-1962.0724
568     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
569     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
570     , p5_a42  NUMBER := 0-1962.0724
571     , p5_a43  NUMBER := 0-1962.0724
572     , p5_a44  NUMBER := 0-1962.0724
573     , p5_a45  NUMBER := 0-1962.0724
574     , p5_a46  NUMBER := 0-1962.0724
575     , p5_a47  NUMBER := 0-1962.0724
576     , p5_a48  DATE := fnd_api.g_miss_date
577     , p5_a49  NUMBER := 0-1962.0724
578     , p5_a50  DATE := fnd_api.g_miss_date
579     , p5_a51  NUMBER := 0-1962.0724
580     , p5_a52  DATE := fnd_api.g_miss_date
581     , p5_a53  NUMBER := 0-1962.0724
582     , p5_a54  NUMBER := 0-1962.0724
583     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
584     , p5_a56  NUMBER := 0-1962.0724
585     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
586     , p5_a58  DATE := fnd_api.g_miss_date
587     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
588     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
589     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
590     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
591     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
592     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
593     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
594     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
595     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
596     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
597     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
598     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
599     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
600     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
601     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
602     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
603     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
604     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
605     , p5_a77  NUMBER := 0-1962.0724
606     , p5_a78  DATE := fnd_api.g_miss_date
607     , p5_a79  NUMBER := 0-1962.0724
608     , p5_a80  NUMBER := 0-1962.0724
609     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
610     , p5_a82  DATE := fnd_api.g_miss_date
611     , p5_a83  NUMBER := 0-1962.0724
612     , p5_a84  DATE := fnd_api.g_miss_date
613     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
614     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
615     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
616     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
617     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
618     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
619     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
620     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
621     , p5_a93  DATE := fnd_api.g_miss_date
622   );
623   procedure validate_trx_contracts(p_api_version  NUMBER
624     , p_init_msg_list  VARCHAR2
625     , x_return_status out nocopy  VARCHAR2
626     , x_msg_count out nocopy  NUMBER
627     , x_msg_data out nocopy  VARCHAR2
628     , p6_a0 JTF_NUMBER_TABLE
629     , p6_a1 JTF_NUMBER_TABLE
630     , p6_a2 JTF_NUMBER_TABLE
631     , p6_a3 JTF_NUMBER_TABLE
632     , p6_a4 JTF_NUMBER_TABLE
633     , p6_a5 JTF_NUMBER_TABLE
634     , p6_a6 JTF_NUMBER_TABLE
635     , p6_a7 JTF_NUMBER_TABLE
636     , p6_a8 JTF_VARCHAR2_TABLE_100
637     , p6_a9 JTF_NUMBER_TABLE
638     , p6_a10 JTF_VARCHAR2_TABLE_2000
639     , p6_a11 JTF_NUMBER_TABLE
640     , p6_a12 JTF_VARCHAR2_TABLE_200
641     , p6_a13 JTF_VARCHAR2_TABLE_100
642     , p6_a14 JTF_VARCHAR2_TABLE_100
643     , p6_a15 JTF_VARCHAR2_TABLE_500
644     , p6_a16 JTF_VARCHAR2_TABLE_500
645     , p6_a17 JTF_VARCHAR2_TABLE_500
646     , p6_a18 JTF_VARCHAR2_TABLE_500
647     , p6_a19 JTF_VARCHAR2_TABLE_500
648     , p6_a20 JTF_VARCHAR2_TABLE_500
649     , p6_a21 JTF_VARCHAR2_TABLE_500
650     , p6_a22 JTF_VARCHAR2_TABLE_500
651     , p6_a23 JTF_VARCHAR2_TABLE_500
652     , p6_a24 JTF_VARCHAR2_TABLE_500
653     , p6_a25 JTF_VARCHAR2_TABLE_500
654     , p6_a26 JTF_VARCHAR2_TABLE_500
655     , p6_a27 JTF_VARCHAR2_TABLE_500
656     , p6_a28 JTF_VARCHAR2_TABLE_500
657     , p6_a29 JTF_VARCHAR2_TABLE_500
658     , p6_a30 JTF_VARCHAR2_TABLE_100
659     , p6_a31 JTF_NUMBER_TABLE
660     , p6_a32 JTF_DATE_TABLE
661     , p6_a33 JTF_NUMBER_TABLE
662     , p6_a34 JTF_DATE_TABLE
663     , p6_a35 JTF_NUMBER_TABLE
664     , p6_a36 JTF_NUMBER_TABLE
665     , p6_a37 JTF_NUMBER_TABLE
666     , p6_a38 JTF_NUMBER_TABLE
667     , p6_a39 JTF_DATE_TABLE
668     , p6_a40 JTF_NUMBER_TABLE
669     , p6_a41 JTF_NUMBER_TABLE
670     , p6_a42 JTF_NUMBER_TABLE
671     , p6_a43 JTF_NUMBER_TABLE
672     , p6_a44 JTF_NUMBER_TABLE
673     , p6_a45 JTF_VARCHAR2_TABLE_100
674     , p6_a46 JTF_VARCHAR2_TABLE_200
675     , p6_a47 JTF_NUMBER_TABLE
676     , p6_a48 JTF_VARCHAR2_TABLE_200
677     , p6_a49 JTF_NUMBER_TABLE
678     , p6_a50 JTF_VARCHAR2_TABLE_200
679     , p6_a51 JTF_NUMBER_TABLE
680     , p6_a52 JTF_DATE_TABLE
681     , p6_a53 JTF_NUMBER_TABLE
682     , p6_a54 JTF_VARCHAR2_TABLE_200
683     , p6_a55 JTF_VARCHAR2_TABLE_300
684     , p6_a56 JTF_VARCHAR2_TABLE_100
685     , p6_a57 JTF_VARCHAR2_TABLE_100
686     , p5_a0  NUMBER := 0-1962.0724
687     , p5_a1  NUMBER := 0-1962.0724
688     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
689     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
690     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
691     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
692     , p5_a6  NUMBER := 0-1962.0724
693     , p5_a7  NUMBER := 0-1962.0724
694     , p5_a8  NUMBER := 0-1962.0724
695     , p5_a9  NUMBER := 0-1962.0724
696     , p5_a10  NUMBER := 0-1962.0724
697     , p5_a11  NUMBER := 0-1962.0724
698     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
699     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
700     , p5_a14  DATE := fnd_api.g_miss_date
701     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
702     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
703     , p5_a17  NUMBER := 0-1962.0724
704     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
705     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
706     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
707     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
708     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
709     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
710     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
711     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
712     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
713     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
714     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
715     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
716     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
717     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
718     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
719     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
720     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
721     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
722     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
723     , p5_a37  NUMBER := 0-1962.0724
724     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
725     , p5_a39  NUMBER := 0-1962.0724
726     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
727     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
728     , p5_a42  NUMBER := 0-1962.0724
729     , p5_a43  NUMBER := 0-1962.0724
730     , p5_a44  NUMBER := 0-1962.0724
731     , p5_a45  NUMBER := 0-1962.0724
732     , p5_a46  NUMBER := 0-1962.0724
733     , p5_a47  NUMBER := 0-1962.0724
734     , p5_a48  DATE := fnd_api.g_miss_date
735     , p5_a49  NUMBER := 0-1962.0724
736     , p5_a50  DATE := fnd_api.g_miss_date
737     , p5_a51  NUMBER := 0-1962.0724
738     , p5_a52  DATE := fnd_api.g_miss_date
739     , p5_a53  NUMBER := 0-1962.0724
740     , p5_a54  NUMBER := 0-1962.0724
741     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
742     , p5_a56  NUMBER := 0-1962.0724
743     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
744     , p5_a58  DATE := fnd_api.g_miss_date
745     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
746     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
747     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
748     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
749     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
750     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
751     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
752     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
753     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
754     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
755     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
756     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
757     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
758     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
759     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
760     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
761     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
762     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
763     , p5_a77  NUMBER := 0-1962.0724
764     , p5_a78  DATE := fnd_api.g_miss_date
765     , p5_a79  NUMBER := 0-1962.0724
766     , p5_a80  NUMBER := 0-1962.0724
767     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
768     , p5_a82  DATE := fnd_api.g_miss_date
769     , p5_a83  NUMBER := 0-1962.0724
770     , p5_a84  DATE := fnd_api.g_miss_date
771     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
772     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
773     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
774     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
775     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
776     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
777     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
778     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
779     , p5_a93  DATE := fnd_api.g_miss_date
780   );
781   procedure create_trx_contracts(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     , p5_a0 JTF_NUMBER_TABLE
787     , p5_a1 JTF_NUMBER_TABLE
788     , p5_a2 JTF_VARCHAR2_TABLE_100
789     , p5_a3 JTF_VARCHAR2_TABLE_100
790     , p5_a4 JTF_VARCHAR2_TABLE_100
791     , p5_a5 JTF_VARCHAR2_TABLE_100
792     , p5_a6 JTF_NUMBER_TABLE
793     , p5_a7 JTF_NUMBER_TABLE
794     , p5_a8 JTF_NUMBER_TABLE
795     , p5_a9 JTF_NUMBER_TABLE
796     , p5_a10 JTF_NUMBER_TABLE
797     , p5_a11 JTF_NUMBER_TABLE
798     , p5_a12 JTF_VARCHAR2_TABLE_100
799     , p5_a13 JTF_VARCHAR2_TABLE_100
800     , p5_a14 JTF_DATE_TABLE
801     , p5_a15 JTF_VARCHAR2_TABLE_100
802     , p5_a16 JTF_VARCHAR2_TABLE_100
803     , p5_a17 JTF_NUMBER_TABLE
804     , p5_a18 JTF_VARCHAR2_TABLE_200
805     , p5_a19 JTF_VARCHAR2_TABLE_100
806     , p5_a20 JTF_VARCHAR2_TABLE_500
807     , p5_a21 JTF_VARCHAR2_TABLE_500
808     , p5_a22 JTF_VARCHAR2_TABLE_500
809     , p5_a23 JTF_VARCHAR2_TABLE_500
810     , p5_a24 JTF_VARCHAR2_TABLE_500
811     , p5_a25 JTF_VARCHAR2_TABLE_500
812     , p5_a26 JTF_VARCHAR2_TABLE_500
813     , p5_a27 JTF_VARCHAR2_TABLE_500
814     , p5_a28 JTF_VARCHAR2_TABLE_500
815     , p5_a29 JTF_VARCHAR2_TABLE_500
816     , p5_a30 JTF_VARCHAR2_TABLE_500
817     , p5_a31 JTF_VARCHAR2_TABLE_500
818     , p5_a32 JTF_VARCHAR2_TABLE_500
819     , p5_a33 JTF_VARCHAR2_TABLE_500
820     , p5_a34 JTF_VARCHAR2_TABLE_500
821     , p5_a35 JTF_VARCHAR2_TABLE_100
822     , p5_a36 JTF_VARCHAR2_TABLE_100
823     , p5_a37 JTF_NUMBER_TABLE
824     , p5_a38 JTF_VARCHAR2_TABLE_100
825     , p5_a39 JTF_NUMBER_TABLE
826     , p5_a40 JTF_VARCHAR2_TABLE_100
827     , p5_a41 JTF_VARCHAR2_TABLE_100
828     , p5_a42 JTF_NUMBER_TABLE
829     , p5_a43 JTF_NUMBER_TABLE
830     , p5_a44 JTF_NUMBER_TABLE
831     , p5_a45 JTF_NUMBER_TABLE
832     , p5_a46 JTF_NUMBER_TABLE
833     , p5_a47 JTF_NUMBER_TABLE
834     , p5_a48 JTF_DATE_TABLE
835     , p5_a49 JTF_NUMBER_TABLE
836     , p5_a50 JTF_DATE_TABLE
837     , p5_a51 JTF_NUMBER_TABLE
838     , p5_a52 JTF_DATE_TABLE
839     , p5_a53 JTF_NUMBER_TABLE
840     , p5_a54 JTF_NUMBER_TABLE
841     , p5_a55 JTF_VARCHAR2_TABLE_100
842     , p5_a56 JTF_NUMBER_TABLE
843     , p5_a57 JTF_VARCHAR2_TABLE_2000
844     , p5_a58 JTF_DATE_TABLE
845     , p5_a59 JTF_VARCHAR2_TABLE_100
846     , p5_a60 JTF_VARCHAR2_TABLE_100
847     , p5_a61 JTF_VARCHAR2_TABLE_100
848     , p5_a62 JTF_VARCHAR2_TABLE_100
849     , p5_a63 JTF_VARCHAR2_TABLE_100
850     , p5_a64 JTF_VARCHAR2_TABLE_100
851     , p5_a65 JTF_VARCHAR2_TABLE_100
852     , p5_a66 JTF_VARCHAR2_TABLE_100
853     , p5_a67 JTF_VARCHAR2_TABLE_100
854     , p5_a68 JTF_VARCHAR2_TABLE_100
855     , p5_a69 JTF_VARCHAR2_TABLE_100
856     , p5_a70 JTF_VARCHAR2_TABLE_100
857     , p5_a71 JTF_VARCHAR2_TABLE_100
858     , p5_a72 JTF_VARCHAR2_TABLE_100
859     , p5_a73 JTF_VARCHAR2_TABLE_100
860     , p5_a74 JTF_VARCHAR2_TABLE_100
861     , p5_a75 JTF_VARCHAR2_TABLE_100
862     , p5_a76 JTF_VARCHAR2_TABLE_100
863     , p5_a77 JTF_NUMBER_TABLE
864     , p5_a78 JTF_DATE_TABLE
865     , p5_a79 JTF_NUMBER_TABLE
866     , p5_a80 JTF_NUMBER_TABLE
867     , p5_a81 JTF_VARCHAR2_TABLE_100
868     , p5_a82 JTF_DATE_TABLE
869     , p5_a83 JTF_NUMBER_TABLE
870     , p5_a84 JTF_DATE_TABLE
871     , p5_a85 JTF_VARCHAR2_TABLE_100
872     , p5_a86 JTF_VARCHAR2_TABLE_200
873     , p5_a87 JTF_VARCHAR2_TABLE_100
874     , p5_a88 JTF_VARCHAR2_TABLE_200
875     , p5_a89 JTF_VARCHAR2_TABLE_100
876     , p5_a90 JTF_VARCHAR2_TABLE_100
877     , p5_a91 JTF_VARCHAR2_TABLE_100
878     , p5_a92 JTF_VARCHAR2_TABLE_100
879     , p5_a93 JTF_DATE_TABLE
880     , p6_a0 out nocopy JTF_NUMBER_TABLE
881     , p6_a1 out nocopy JTF_NUMBER_TABLE
882     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
883     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
884     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
885     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
886     , p6_a6 out nocopy JTF_NUMBER_TABLE
887     , p6_a7 out nocopy JTF_NUMBER_TABLE
888     , p6_a8 out nocopy JTF_NUMBER_TABLE
889     , p6_a9 out nocopy JTF_NUMBER_TABLE
890     , p6_a10 out nocopy JTF_NUMBER_TABLE
891     , p6_a11 out nocopy JTF_NUMBER_TABLE
892     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
893     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
894     , p6_a14 out nocopy JTF_DATE_TABLE
895     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
896     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
897     , p6_a17 out nocopy JTF_NUMBER_TABLE
898     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
899     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
900     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
901     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
902     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
903     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
904     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
905     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
906     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
907     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
908     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
909     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
910     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
911     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
912     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
913     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
914     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
915     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
916     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
917     , p6_a37 out nocopy JTF_NUMBER_TABLE
918     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
919     , p6_a39 out nocopy JTF_NUMBER_TABLE
920     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
921     , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
922     , p6_a42 out nocopy JTF_NUMBER_TABLE
923     , p6_a43 out nocopy JTF_NUMBER_TABLE
924     , p6_a44 out nocopy JTF_NUMBER_TABLE
925     , p6_a45 out nocopy JTF_NUMBER_TABLE
926     , p6_a46 out nocopy JTF_NUMBER_TABLE
927     , p6_a47 out nocopy JTF_NUMBER_TABLE
928     , p6_a48 out nocopy JTF_DATE_TABLE
929     , p6_a49 out nocopy JTF_NUMBER_TABLE
930     , p6_a50 out nocopy JTF_DATE_TABLE
931     , p6_a51 out nocopy JTF_NUMBER_TABLE
932     , p6_a52 out nocopy JTF_DATE_TABLE
933     , p6_a53 out nocopy JTF_NUMBER_TABLE
934     , p6_a54 out nocopy JTF_NUMBER_TABLE
935     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
936     , p6_a56 out nocopy JTF_NUMBER_TABLE
937     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_2000
938     , p6_a58 out nocopy JTF_DATE_TABLE
939     , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
940     , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
941     , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
942     , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
943     , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
944     , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
945     , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
946     , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
947     , p6_a67 out nocopy JTF_VARCHAR2_TABLE_100
948     , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
949     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
950     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
951     , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
952     , p6_a72 out nocopy JTF_VARCHAR2_TABLE_100
953     , p6_a73 out nocopy JTF_VARCHAR2_TABLE_100
954     , p6_a74 out nocopy JTF_VARCHAR2_TABLE_100
955     , p6_a75 out nocopy JTF_VARCHAR2_TABLE_100
956     , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
957     , p6_a77 out nocopy JTF_NUMBER_TABLE
958     , p6_a78 out nocopy JTF_DATE_TABLE
959     , p6_a79 out nocopy JTF_NUMBER_TABLE
960     , p6_a80 out nocopy JTF_NUMBER_TABLE
961     , p6_a81 out nocopy JTF_VARCHAR2_TABLE_100
962     , p6_a82 out nocopy JTF_DATE_TABLE
963     , p6_a83 out nocopy JTF_NUMBER_TABLE
964     , p6_a84 out nocopy JTF_DATE_TABLE
965     , p6_a85 out nocopy JTF_VARCHAR2_TABLE_100
966     , p6_a86 out nocopy JTF_VARCHAR2_TABLE_200
967     , p6_a87 out nocopy JTF_VARCHAR2_TABLE_100
968     , p6_a88 out nocopy JTF_VARCHAR2_TABLE_200
969     , p6_a89 out nocopy JTF_VARCHAR2_TABLE_100
970     , p6_a90 out nocopy JTF_VARCHAR2_TABLE_100
971     , p6_a91 out nocopy JTF_VARCHAR2_TABLE_100
972     , p6_a92 out nocopy JTF_VARCHAR2_TABLE_100
973     , p6_a93 out nocopy JTF_DATE_TABLE
974   );
975   procedure create_trx_contracts(p_api_version  NUMBER
976     , p_init_msg_list  VARCHAR2
977     , x_return_status out nocopy  VARCHAR2
978     , x_msg_count out nocopy  NUMBER
979     , x_msg_data out nocopy  VARCHAR2
980     , p6_a0 out nocopy  NUMBER
981     , p6_a1 out nocopy  NUMBER
982     , p6_a2 out nocopy  VARCHAR2
983     , p6_a3 out nocopy  VARCHAR2
984     , p6_a4 out nocopy  VARCHAR2
985     , p6_a5 out nocopy  VARCHAR2
986     , p6_a6 out nocopy  NUMBER
987     , p6_a7 out nocopy  NUMBER
988     , p6_a8 out nocopy  NUMBER
989     , p6_a9 out nocopy  NUMBER
990     , p6_a10 out nocopy  NUMBER
991     , p6_a11 out nocopy  NUMBER
992     , p6_a12 out nocopy  VARCHAR2
993     , p6_a13 out nocopy  VARCHAR2
994     , p6_a14 out nocopy  DATE
995     , p6_a15 out nocopy  VARCHAR2
996     , p6_a16 out nocopy  VARCHAR2
997     , p6_a17 out nocopy  NUMBER
998     , p6_a18 out nocopy  VARCHAR2
999     , p6_a19 out nocopy  VARCHAR2
1000     , p6_a20 out nocopy  VARCHAR2
1001     , p6_a21 out nocopy  VARCHAR2
1002     , p6_a22 out nocopy  VARCHAR2
1003     , p6_a23 out nocopy  VARCHAR2
1004     , p6_a24 out nocopy  VARCHAR2
1005     , p6_a25 out nocopy  VARCHAR2
1006     , p6_a26 out nocopy  VARCHAR2
1007     , p6_a27 out nocopy  VARCHAR2
1008     , p6_a28 out nocopy  VARCHAR2
1009     , p6_a29 out nocopy  VARCHAR2
1010     , p6_a30 out nocopy  VARCHAR2
1011     , p6_a31 out nocopy  VARCHAR2
1012     , p6_a32 out nocopy  VARCHAR2
1013     , p6_a33 out nocopy  VARCHAR2
1014     , p6_a34 out nocopy  VARCHAR2
1015     , p6_a35 out nocopy  VARCHAR2
1016     , p6_a36 out nocopy  VARCHAR2
1017     , p6_a37 out nocopy  NUMBER
1018     , p6_a38 out nocopy  VARCHAR2
1019     , p6_a39 out nocopy  NUMBER
1020     , p6_a40 out nocopy  VARCHAR2
1021     , p6_a41 out nocopy  VARCHAR2
1022     , p6_a42 out nocopy  NUMBER
1023     , p6_a43 out nocopy  NUMBER
1024     , p6_a44 out nocopy  NUMBER
1025     , p6_a45 out nocopy  NUMBER
1026     , p6_a46 out nocopy  NUMBER
1027     , p6_a47 out nocopy  NUMBER
1028     , p6_a48 out nocopy  DATE
1029     , p6_a49 out nocopy  NUMBER
1030     , p6_a50 out nocopy  DATE
1031     , p6_a51 out nocopy  NUMBER
1032     , p6_a52 out nocopy  DATE
1033     , p6_a53 out nocopy  NUMBER
1034     , p6_a54 out nocopy  NUMBER
1035     , p6_a55 out nocopy  VARCHAR2
1036     , p6_a56 out nocopy  NUMBER
1037     , p6_a57 out nocopy  VARCHAR2
1038     , p6_a58 out nocopy  DATE
1039     , p6_a59 out nocopy  VARCHAR2
1040     , p6_a60 out nocopy  VARCHAR2
1041     , p6_a61 out nocopy  VARCHAR2
1042     , p6_a62 out nocopy  VARCHAR2
1043     , p6_a63 out nocopy  VARCHAR2
1044     , p6_a64 out nocopy  VARCHAR2
1045     , p6_a65 out nocopy  VARCHAR2
1046     , p6_a66 out nocopy  VARCHAR2
1047     , p6_a67 out nocopy  VARCHAR2
1048     , p6_a68 out nocopy  VARCHAR2
1049     , p6_a69 out nocopy  VARCHAR2
1050     , p6_a70 out nocopy  VARCHAR2
1051     , p6_a71 out nocopy  VARCHAR2
1052     , p6_a72 out nocopy  VARCHAR2
1053     , p6_a73 out nocopy  VARCHAR2
1054     , p6_a74 out nocopy  VARCHAR2
1055     , p6_a75 out nocopy  VARCHAR2
1056     , p6_a76 out nocopy  VARCHAR2
1057     , p6_a77 out nocopy  NUMBER
1058     , p6_a78 out nocopy  DATE
1059     , p6_a79 out nocopy  NUMBER
1060     , p6_a80 out nocopy  NUMBER
1061     , p6_a81 out nocopy  VARCHAR2
1062     , p6_a82 out nocopy  DATE
1063     , p6_a83 out nocopy  NUMBER
1064     , p6_a84 out nocopy  DATE
1065     , p6_a85 out nocopy  VARCHAR2
1066     , p6_a86 out nocopy  VARCHAR2
1067     , p6_a87 out nocopy  VARCHAR2
1068     , p6_a88 out nocopy  VARCHAR2
1069     , p6_a89 out nocopy  VARCHAR2
1070     , p6_a90 out nocopy  VARCHAR2
1071     , p6_a91 out nocopy  VARCHAR2
1072     , p6_a92 out nocopy  VARCHAR2
1073     , p6_a93 out nocopy  DATE
1074     , p5_a0  NUMBER := 0-1962.0724
1075     , p5_a1  NUMBER := 0-1962.0724
1076     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1077     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
1078     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1079     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
1080     , p5_a6  NUMBER := 0-1962.0724
1081     , p5_a7  NUMBER := 0-1962.0724
1082     , p5_a8  NUMBER := 0-1962.0724
1083     , p5_a9  NUMBER := 0-1962.0724
1084     , p5_a10  NUMBER := 0-1962.0724
1085     , p5_a11  NUMBER := 0-1962.0724
1086     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1087     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1088     , p5_a14  DATE := fnd_api.g_miss_date
1089     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1090     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1091     , p5_a17  NUMBER := 0-1962.0724
1092     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1093     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1094     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1095     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1096     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1097     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1098     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1099     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
1100     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1101     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1102     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1103     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1104     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1105     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1106     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1107     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1108     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1109     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1110     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
1111     , p5_a37  NUMBER := 0-1962.0724
1112     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1113     , p5_a39  NUMBER := 0-1962.0724
1114     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1115     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1116     , p5_a42  NUMBER := 0-1962.0724
1117     , p5_a43  NUMBER := 0-1962.0724
1118     , p5_a44  NUMBER := 0-1962.0724
1119     , p5_a45  NUMBER := 0-1962.0724
1120     , p5_a46  NUMBER := 0-1962.0724
1121     , p5_a47  NUMBER := 0-1962.0724
1122     , p5_a48  DATE := fnd_api.g_miss_date
1123     , p5_a49  NUMBER := 0-1962.0724
1124     , p5_a50  DATE := fnd_api.g_miss_date
1125     , p5_a51  NUMBER := 0-1962.0724
1126     , p5_a52  DATE := fnd_api.g_miss_date
1127     , p5_a53  NUMBER := 0-1962.0724
1128     , p5_a54  NUMBER := 0-1962.0724
1129     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
1130     , p5_a56  NUMBER := 0-1962.0724
1131     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
1132     , p5_a58  DATE := fnd_api.g_miss_date
1133     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
1134     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
1135     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
1136     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
1137     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
1138     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
1139     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
1140     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
1141     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1142     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1143     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1144     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1145     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1146     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1147     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1148     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1149     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1150     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1151     , p5_a77  NUMBER := 0-1962.0724
1152     , p5_a78  DATE := fnd_api.g_miss_date
1153     , p5_a79  NUMBER := 0-1962.0724
1154     , p5_a80  NUMBER := 0-1962.0724
1155     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1156     , p5_a82  DATE := fnd_api.g_miss_date
1157     , p5_a83  NUMBER := 0-1962.0724
1158     , p5_a84  DATE := fnd_api.g_miss_date
1159     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
1160     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
1161     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
1162     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
1163     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1164     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1165     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1166     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1167     , p5_a93  DATE := fnd_api.g_miss_date
1168   );
1169   procedure lock_trx_contracts(p_api_version  NUMBER
1170     , p_init_msg_list  VARCHAR2
1171     , x_return_status out nocopy  VARCHAR2
1172     , x_msg_count out nocopy  NUMBER
1173     , x_msg_data out nocopy  VARCHAR2
1174     , p5_a0 JTF_NUMBER_TABLE
1175     , p5_a1 JTF_NUMBER_TABLE
1176     , p5_a2 JTF_VARCHAR2_TABLE_100
1177     , p5_a3 JTF_VARCHAR2_TABLE_100
1178     , p5_a4 JTF_VARCHAR2_TABLE_100
1179     , p5_a5 JTF_VARCHAR2_TABLE_100
1180     , p5_a6 JTF_NUMBER_TABLE
1181     , p5_a7 JTF_NUMBER_TABLE
1182     , p5_a8 JTF_NUMBER_TABLE
1183     , p5_a9 JTF_NUMBER_TABLE
1184     , p5_a10 JTF_NUMBER_TABLE
1185     , p5_a11 JTF_NUMBER_TABLE
1186     , p5_a12 JTF_VARCHAR2_TABLE_100
1187     , p5_a13 JTF_VARCHAR2_TABLE_100
1188     , p5_a14 JTF_DATE_TABLE
1189     , p5_a15 JTF_VARCHAR2_TABLE_100
1190     , p5_a16 JTF_VARCHAR2_TABLE_100
1191     , p5_a17 JTF_NUMBER_TABLE
1192     , p5_a18 JTF_VARCHAR2_TABLE_200
1193     , p5_a19 JTF_VARCHAR2_TABLE_100
1194     , p5_a20 JTF_VARCHAR2_TABLE_500
1195     , p5_a21 JTF_VARCHAR2_TABLE_500
1196     , p5_a22 JTF_VARCHAR2_TABLE_500
1197     , p5_a23 JTF_VARCHAR2_TABLE_500
1198     , p5_a24 JTF_VARCHAR2_TABLE_500
1199     , p5_a25 JTF_VARCHAR2_TABLE_500
1200     , p5_a26 JTF_VARCHAR2_TABLE_500
1201     , p5_a27 JTF_VARCHAR2_TABLE_500
1202     , p5_a28 JTF_VARCHAR2_TABLE_500
1203     , p5_a29 JTF_VARCHAR2_TABLE_500
1204     , p5_a30 JTF_VARCHAR2_TABLE_500
1205     , p5_a31 JTF_VARCHAR2_TABLE_500
1206     , p5_a32 JTF_VARCHAR2_TABLE_500
1207     , p5_a33 JTF_VARCHAR2_TABLE_500
1208     , p5_a34 JTF_VARCHAR2_TABLE_500
1209     , p5_a35 JTF_VARCHAR2_TABLE_100
1210     , p5_a36 JTF_VARCHAR2_TABLE_100
1211     , p5_a37 JTF_NUMBER_TABLE
1212     , p5_a38 JTF_VARCHAR2_TABLE_100
1213     , p5_a39 JTF_NUMBER_TABLE
1214     , p5_a40 JTF_VARCHAR2_TABLE_100
1215     , p5_a41 JTF_VARCHAR2_TABLE_100
1216     , p5_a42 JTF_NUMBER_TABLE
1217     , p5_a43 JTF_NUMBER_TABLE
1218     , p5_a44 JTF_NUMBER_TABLE
1219     , p5_a45 JTF_NUMBER_TABLE
1220     , p5_a46 JTF_NUMBER_TABLE
1221     , p5_a47 JTF_NUMBER_TABLE
1222     , p5_a48 JTF_DATE_TABLE
1223     , p5_a49 JTF_NUMBER_TABLE
1224     , p5_a50 JTF_DATE_TABLE
1225     , p5_a51 JTF_NUMBER_TABLE
1226     , p5_a52 JTF_DATE_TABLE
1227     , p5_a53 JTF_NUMBER_TABLE
1228     , p5_a54 JTF_NUMBER_TABLE
1229     , p5_a55 JTF_VARCHAR2_TABLE_100
1230     , p5_a56 JTF_NUMBER_TABLE
1231     , p5_a57 JTF_VARCHAR2_TABLE_2000
1232     , p5_a58 JTF_DATE_TABLE
1233     , p5_a59 JTF_VARCHAR2_TABLE_100
1234     , p5_a60 JTF_VARCHAR2_TABLE_100
1235     , p5_a61 JTF_VARCHAR2_TABLE_100
1236     , p5_a62 JTF_VARCHAR2_TABLE_100
1237     , p5_a63 JTF_VARCHAR2_TABLE_100
1238     , p5_a64 JTF_VARCHAR2_TABLE_100
1239     , p5_a65 JTF_VARCHAR2_TABLE_100
1240     , p5_a66 JTF_VARCHAR2_TABLE_100
1241     , p5_a67 JTF_VARCHAR2_TABLE_100
1242     , p5_a68 JTF_VARCHAR2_TABLE_100
1243     , p5_a69 JTF_VARCHAR2_TABLE_100
1244     , p5_a70 JTF_VARCHAR2_TABLE_100
1245     , p5_a71 JTF_VARCHAR2_TABLE_100
1246     , p5_a72 JTF_VARCHAR2_TABLE_100
1247     , p5_a73 JTF_VARCHAR2_TABLE_100
1248     , p5_a74 JTF_VARCHAR2_TABLE_100
1249     , p5_a75 JTF_VARCHAR2_TABLE_100
1250     , p5_a76 JTF_VARCHAR2_TABLE_100
1251     , p5_a77 JTF_NUMBER_TABLE
1252     , p5_a78 JTF_DATE_TABLE
1253     , p5_a79 JTF_NUMBER_TABLE
1254     , p5_a80 JTF_NUMBER_TABLE
1255     , p5_a81 JTF_VARCHAR2_TABLE_100
1256     , p5_a82 JTF_DATE_TABLE
1257     , p5_a83 JTF_NUMBER_TABLE
1258     , p5_a84 JTF_DATE_TABLE
1259     , p5_a85 JTF_VARCHAR2_TABLE_100
1260     , p5_a86 JTF_VARCHAR2_TABLE_200
1261     , p5_a87 JTF_VARCHAR2_TABLE_100
1262     , p5_a88 JTF_VARCHAR2_TABLE_200
1263     , p5_a89 JTF_VARCHAR2_TABLE_100
1264     , p5_a90 JTF_VARCHAR2_TABLE_100
1265     , p5_a91 JTF_VARCHAR2_TABLE_100
1266     , p5_a92 JTF_VARCHAR2_TABLE_100
1267     , p5_a93 JTF_DATE_TABLE
1268   );
1269   procedure lock_trx_contracts(p_api_version  NUMBER
1270     , p_init_msg_list  VARCHAR2
1271     , x_return_status out nocopy  VARCHAR2
1272     , x_msg_count out nocopy  NUMBER
1273     , x_msg_data out nocopy  VARCHAR2
1274     , p5_a0  NUMBER := 0-1962.0724
1275     , p5_a1  NUMBER := 0-1962.0724
1276     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1277     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
1278     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1279     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
1280     , p5_a6  NUMBER := 0-1962.0724
1281     , p5_a7  NUMBER := 0-1962.0724
1282     , p5_a8  NUMBER := 0-1962.0724
1283     , p5_a9  NUMBER := 0-1962.0724
1284     , p5_a10  NUMBER := 0-1962.0724
1285     , p5_a11  NUMBER := 0-1962.0724
1286     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1287     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1288     , p5_a14  DATE := fnd_api.g_miss_date
1289     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1290     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1291     , p5_a17  NUMBER := 0-1962.0724
1292     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1293     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1294     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1295     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1296     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1297     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1298     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1299     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
1300     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1301     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1302     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1303     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1304     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1305     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1306     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1307     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1308     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1309     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1310     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
1311     , p5_a37  NUMBER := 0-1962.0724
1312     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1313     , p5_a39  NUMBER := 0-1962.0724
1314     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1315     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1316     , p5_a42  NUMBER := 0-1962.0724
1317     , p5_a43  NUMBER := 0-1962.0724
1318     , p5_a44  NUMBER := 0-1962.0724
1319     , p5_a45  NUMBER := 0-1962.0724
1320     , p5_a46  NUMBER := 0-1962.0724
1321     , p5_a47  NUMBER := 0-1962.0724
1322     , p5_a48  DATE := fnd_api.g_miss_date
1323     , p5_a49  NUMBER := 0-1962.0724
1324     , p5_a50  DATE := fnd_api.g_miss_date
1325     , p5_a51  NUMBER := 0-1962.0724
1326     , p5_a52  DATE := fnd_api.g_miss_date
1327     , p5_a53  NUMBER := 0-1962.0724
1328     , p5_a54  NUMBER := 0-1962.0724
1329     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
1330     , p5_a56  NUMBER := 0-1962.0724
1331     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
1332     , p5_a58  DATE := fnd_api.g_miss_date
1333     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
1334     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
1335     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
1336     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
1337     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
1338     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
1339     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
1340     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
1341     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1342     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1343     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1344     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1345     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1346     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1347     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1348     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1349     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1350     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1351     , p5_a77  NUMBER := 0-1962.0724
1352     , p5_a78  DATE := fnd_api.g_miss_date
1353     , p5_a79  NUMBER := 0-1962.0724
1354     , p5_a80  NUMBER := 0-1962.0724
1355     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1356     , p5_a82  DATE := fnd_api.g_miss_date
1357     , p5_a83  NUMBER := 0-1962.0724
1358     , p5_a84  DATE := fnd_api.g_miss_date
1359     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
1360     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
1361     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
1362     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
1363     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1364     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1365     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1366     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1367     , p5_a93  DATE := fnd_api.g_miss_date
1368   );
1369   procedure update_trx_contracts(p_api_version  NUMBER
1370     , p_init_msg_list  VARCHAR2
1371     , x_return_status out nocopy  VARCHAR2
1372     , x_msg_count out nocopy  NUMBER
1373     , x_msg_data out nocopy  VARCHAR2
1374     , p5_a0 JTF_NUMBER_TABLE
1375     , p5_a1 JTF_NUMBER_TABLE
1376     , p5_a2 JTF_VARCHAR2_TABLE_100
1377     , p5_a3 JTF_VARCHAR2_TABLE_100
1378     , p5_a4 JTF_VARCHAR2_TABLE_100
1379     , p5_a5 JTF_VARCHAR2_TABLE_100
1380     , p5_a6 JTF_NUMBER_TABLE
1381     , p5_a7 JTF_NUMBER_TABLE
1382     , p5_a8 JTF_NUMBER_TABLE
1383     , p5_a9 JTF_NUMBER_TABLE
1384     , p5_a10 JTF_NUMBER_TABLE
1385     , p5_a11 JTF_NUMBER_TABLE
1386     , p5_a12 JTF_VARCHAR2_TABLE_100
1387     , p5_a13 JTF_VARCHAR2_TABLE_100
1388     , p5_a14 JTF_DATE_TABLE
1389     , p5_a15 JTF_VARCHAR2_TABLE_100
1390     , p5_a16 JTF_VARCHAR2_TABLE_100
1391     , p5_a17 JTF_NUMBER_TABLE
1392     , p5_a18 JTF_VARCHAR2_TABLE_200
1393     , p5_a19 JTF_VARCHAR2_TABLE_100
1394     , p5_a20 JTF_VARCHAR2_TABLE_500
1395     , p5_a21 JTF_VARCHAR2_TABLE_500
1396     , p5_a22 JTF_VARCHAR2_TABLE_500
1397     , p5_a23 JTF_VARCHAR2_TABLE_500
1398     , p5_a24 JTF_VARCHAR2_TABLE_500
1399     , p5_a25 JTF_VARCHAR2_TABLE_500
1400     , p5_a26 JTF_VARCHAR2_TABLE_500
1401     , p5_a27 JTF_VARCHAR2_TABLE_500
1402     , p5_a28 JTF_VARCHAR2_TABLE_500
1403     , p5_a29 JTF_VARCHAR2_TABLE_500
1404     , p5_a30 JTF_VARCHAR2_TABLE_500
1405     , p5_a31 JTF_VARCHAR2_TABLE_500
1406     , p5_a32 JTF_VARCHAR2_TABLE_500
1407     , p5_a33 JTF_VARCHAR2_TABLE_500
1408     , p5_a34 JTF_VARCHAR2_TABLE_500
1409     , p5_a35 JTF_VARCHAR2_TABLE_100
1410     , p5_a36 JTF_VARCHAR2_TABLE_100
1411     , p5_a37 JTF_NUMBER_TABLE
1412     , p5_a38 JTF_VARCHAR2_TABLE_100
1413     , p5_a39 JTF_NUMBER_TABLE
1414     , p5_a40 JTF_VARCHAR2_TABLE_100
1415     , p5_a41 JTF_VARCHAR2_TABLE_100
1416     , p5_a42 JTF_NUMBER_TABLE
1417     , p5_a43 JTF_NUMBER_TABLE
1418     , p5_a44 JTF_NUMBER_TABLE
1419     , p5_a45 JTF_NUMBER_TABLE
1420     , p5_a46 JTF_NUMBER_TABLE
1421     , p5_a47 JTF_NUMBER_TABLE
1422     , p5_a48 JTF_DATE_TABLE
1423     , p5_a49 JTF_NUMBER_TABLE
1424     , p5_a50 JTF_DATE_TABLE
1425     , p5_a51 JTF_NUMBER_TABLE
1426     , p5_a52 JTF_DATE_TABLE
1427     , p5_a53 JTF_NUMBER_TABLE
1428     , p5_a54 JTF_NUMBER_TABLE
1429     , p5_a55 JTF_VARCHAR2_TABLE_100
1430     , p5_a56 JTF_NUMBER_TABLE
1431     , p5_a57 JTF_VARCHAR2_TABLE_2000
1432     , p5_a58 JTF_DATE_TABLE
1433     , p5_a59 JTF_VARCHAR2_TABLE_100
1434     , p5_a60 JTF_VARCHAR2_TABLE_100
1435     , p5_a61 JTF_VARCHAR2_TABLE_100
1436     , p5_a62 JTF_VARCHAR2_TABLE_100
1437     , p5_a63 JTF_VARCHAR2_TABLE_100
1438     , p5_a64 JTF_VARCHAR2_TABLE_100
1439     , p5_a65 JTF_VARCHAR2_TABLE_100
1440     , p5_a66 JTF_VARCHAR2_TABLE_100
1441     , p5_a67 JTF_VARCHAR2_TABLE_100
1442     , p5_a68 JTF_VARCHAR2_TABLE_100
1443     , p5_a69 JTF_VARCHAR2_TABLE_100
1444     , p5_a70 JTF_VARCHAR2_TABLE_100
1445     , p5_a71 JTF_VARCHAR2_TABLE_100
1446     , p5_a72 JTF_VARCHAR2_TABLE_100
1447     , p5_a73 JTF_VARCHAR2_TABLE_100
1448     , p5_a74 JTF_VARCHAR2_TABLE_100
1449     , p5_a75 JTF_VARCHAR2_TABLE_100
1450     , p5_a76 JTF_VARCHAR2_TABLE_100
1451     , p5_a77 JTF_NUMBER_TABLE
1452     , p5_a78 JTF_DATE_TABLE
1453     , p5_a79 JTF_NUMBER_TABLE
1454     , p5_a80 JTF_NUMBER_TABLE
1455     , p5_a81 JTF_VARCHAR2_TABLE_100
1456     , p5_a82 JTF_DATE_TABLE
1457     , p5_a83 JTF_NUMBER_TABLE
1458     , p5_a84 JTF_DATE_TABLE
1459     , p5_a85 JTF_VARCHAR2_TABLE_100
1460     , p5_a86 JTF_VARCHAR2_TABLE_200
1461     , p5_a87 JTF_VARCHAR2_TABLE_100
1462     , p5_a88 JTF_VARCHAR2_TABLE_200
1463     , p5_a89 JTF_VARCHAR2_TABLE_100
1464     , p5_a90 JTF_VARCHAR2_TABLE_100
1465     , p5_a91 JTF_VARCHAR2_TABLE_100
1466     , p5_a92 JTF_VARCHAR2_TABLE_100
1467     , p5_a93 JTF_DATE_TABLE
1468     , p6_a0 out nocopy JTF_NUMBER_TABLE
1469     , p6_a1 out nocopy JTF_NUMBER_TABLE
1470     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1471     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1472     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1473     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1474     , p6_a6 out nocopy JTF_NUMBER_TABLE
1475     , p6_a7 out nocopy JTF_NUMBER_TABLE
1476     , p6_a8 out nocopy JTF_NUMBER_TABLE
1477     , p6_a9 out nocopy JTF_NUMBER_TABLE
1478     , p6_a10 out nocopy JTF_NUMBER_TABLE
1479     , p6_a11 out nocopy JTF_NUMBER_TABLE
1480     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1481     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1482     , p6_a14 out nocopy JTF_DATE_TABLE
1483     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1484     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1485     , p6_a17 out nocopy JTF_NUMBER_TABLE
1486     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
1487     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1488     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1489     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1490     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1491     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1492     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1493     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1494     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1495     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1496     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1497     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1498     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1499     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1500     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1501     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1502     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1503     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
1504     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1505     , p6_a37 out nocopy JTF_NUMBER_TABLE
1506     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1507     , p6_a39 out nocopy JTF_NUMBER_TABLE
1508     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1509     , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1510     , p6_a42 out nocopy JTF_NUMBER_TABLE
1511     , p6_a43 out nocopy JTF_NUMBER_TABLE
1512     , p6_a44 out nocopy JTF_NUMBER_TABLE
1513     , p6_a45 out nocopy JTF_NUMBER_TABLE
1514     , p6_a46 out nocopy JTF_NUMBER_TABLE
1515     , p6_a47 out nocopy JTF_NUMBER_TABLE
1516     , p6_a48 out nocopy JTF_DATE_TABLE
1517     , p6_a49 out nocopy JTF_NUMBER_TABLE
1518     , p6_a50 out nocopy JTF_DATE_TABLE
1519     , p6_a51 out nocopy JTF_NUMBER_TABLE
1520     , p6_a52 out nocopy JTF_DATE_TABLE
1521     , p6_a53 out nocopy JTF_NUMBER_TABLE
1522     , p6_a54 out nocopy JTF_NUMBER_TABLE
1523     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
1524     , p6_a56 out nocopy JTF_NUMBER_TABLE
1525     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_2000
1526     , p6_a58 out nocopy JTF_DATE_TABLE
1527     , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
1528     , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
1529     , p6_a61 out nocopy JTF_VARCHAR2_TABLE_100
1530     , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1531     , p6_a63 out nocopy JTF_VARCHAR2_TABLE_100
1532     , p6_a64 out nocopy JTF_VARCHAR2_TABLE_100
1533     , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
1534     , p6_a66 out nocopy JTF_VARCHAR2_TABLE_100
1535     , p6_a67 out nocopy JTF_VARCHAR2_TABLE_100
1536     , p6_a68 out nocopy JTF_VARCHAR2_TABLE_100
1537     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_100
1538     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_100
1539     , p6_a71 out nocopy JTF_VARCHAR2_TABLE_100
1540     , p6_a72 out nocopy JTF_VARCHAR2_TABLE_100
1541     , p6_a73 out nocopy JTF_VARCHAR2_TABLE_100
1542     , p6_a74 out nocopy JTF_VARCHAR2_TABLE_100
1543     , p6_a75 out nocopy JTF_VARCHAR2_TABLE_100
1544     , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
1545     , p6_a77 out nocopy JTF_NUMBER_TABLE
1546     , p6_a78 out nocopy JTF_DATE_TABLE
1547     , p6_a79 out nocopy JTF_NUMBER_TABLE
1548     , p6_a80 out nocopy JTF_NUMBER_TABLE
1549     , p6_a81 out nocopy JTF_VARCHAR2_TABLE_100
1550     , p6_a82 out nocopy JTF_DATE_TABLE
1551     , p6_a83 out nocopy JTF_NUMBER_TABLE
1552     , p6_a84 out nocopy JTF_DATE_TABLE
1553     , p6_a85 out nocopy JTF_VARCHAR2_TABLE_100
1554     , p6_a86 out nocopy JTF_VARCHAR2_TABLE_200
1555     , p6_a87 out nocopy JTF_VARCHAR2_TABLE_100
1556     , p6_a88 out nocopy JTF_VARCHAR2_TABLE_200
1557     , p6_a89 out nocopy JTF_VARCHAR2_TABLE_100
1558     , p6_a90 out nocopy JTF_VARCHAR2_TABLE_100
1559     , p6_a91 out nocopy JTF_VARCHAR2_TABLE_100
1560     , p6_a92 out nocopy JTF_VARCHAR2_TABLE_100
1561     , p6_a93 out nocopy JTF_DATE_TABLE
1562   );
1563   procedure update_trx_contracts(p_api_version  NUMBER
1564     , p_init_msg_list  VARCHAR2
1565     , x_return_status out nocopy  VARCHAR2
1566     , x_msg_count out nocopy  NUMBER
1567     , x_msg_data out nocopy  VARCHAR2
1568     , p6_a0 out nocopy  NUMBER
1569     , p6_a1 out nocopy  NUMBER
1570     , p6_a2 out nocopy  VARCHAR2
1571     , p6_a3 out nocopy  VARCHAR2
1572     , p6_a4 out nocopy  VARCHAR2
1573     , p6_a5 out nocopy  VARCHAR2
1574     , p6_a6 out nocopy  NUMBER
1575     , p6_a7 out nocopy  NUMBER
1576     , p6_a8 out nocopy  NUMBER
1577     , p6_a9 out nocopy  NUMBER
1578     , p6_a10 out nocopy  NUMBER
1579     , p6_a11 out nocopy  NUMBER
1580     , p6_a12 out nocopy  VARCHAR2
1581     , p6_a13 out nocopy  VARCHAR2
1582     , p6_a14 out nocopy  DATE
1583     , p6_a15 out nocopy  VARCHAR2
1584     , p6_a16 out nocopy  VARCHAR2
1585     , p6_a17 out nocopy  NUMBER
1586     , p6_a18 out nocopy  VARCHAR2
1587     , p6_a19 out nocopy  VARCHAR2
1588     , p6_a20 out nocopy  VARCHAR2
1589     , p6_a21 out nocopy  VARCHAR2
1590     , p6_a22 out nocopy  VARCHAR2
1591     , p6_a23 out nocopy  VARCHAR2
1592     , p6_a24 out nocopy  VARCHAR2
1593     , p6_a25 out nocopy  VARCHAR2
1594     , p6_a26 out nocopy  VARCHAR2
1595     , p6_a27 out nocopy  VARCHAR2
1596     , p6_a28 out nocopy  VARCHAR2
1597     , p6_a29 out nocopy  VARCHAR2
1598     , p6_a30 out nocopy  VARCHAR2
1599     , p6_a31 out nocopy  VARCHAR2
1600     , p6_a32 out nocopy  VARCHAR2
1601     , p6_a33 out nocopy  VARCHAR2
1602     , p6_a34 out nocopy  VARCHAR2
1603     , p6_a35 out nocopy  VARCHAR2
1604     , p6_a36 out nocopy  VARCHAR2
1605     , p6_a37 out nocopy  NUMBER
1606     , p6_a38 out nocopy  VARCHAR2
1607     , p6_a39 out nocopy  NUMBER
1608     , p6_a40 out nocopy  VARCHAR2
1609     , p6_a41 out nocopy  VARCHAR2
1610     , p6_a42 out nocopy  NUMBER
1611     , p6_a43 out nocopy  NUMBER
1612     , p6_a44 out nocopy  NUMBER
1613     , p6_a45 out nocopy  NUMBER
1614     , p6_a46 out nocopy  NUMBER
1615     , p6_a47 out nocopy  NUMBER
1616     , p6_a48 out nocopy  DATE
1617     , p6_a49 out nocopy  NUMBER
1618     , p6_a50 out nocopy  DATE
1619     , p6_a51 out nocopy  NUMBER
1620     , p6_a52 out nocopy  DATE
1621     , p6_a53 out nocopy  NUMBER
1622     , p6_a54 out nocopy  NUMBER
1623     , p6_a55 out nocopy  VARCHAR2
1624     , p6_a56 out nocopy  NUMBER
1625     , p6_a57 out nocopy  VARCHAR2
1626     , p6_a58 out nocopy  DATE
1627     , p6_a59 out nocopy  VARCHAR2
1628     , p6_a60 out nocopy  VARCHAR2
1629     , p6_a61 out nocopy  VARCHAR2
1630     , p6_a62 out nocopy  VARCHAR2
1631     , p6_a63 out nocopy  VARCHAR2
1632     , p6_a64 out nocopy  VARCHAR2
1633     , p6_a65 out nocopy  VARCHAR2
1634     , p6_a66 out nocopy  VARCHAR2
1635     , p6_a67 out nocopy  VARCHAR2
1636     , p6_a68 out nocopy  VARCHAR2
1637     , p6_a69 out nocopy  VARCHAR2
1638     , p6_a70 out nocopy  VARCHAR2
1639     , p6_a71 out nocopy  VARCHAR2
1640     , p6_a72 out nocopy  VARCHAR2
1641     , p6_a73 out nocopy  VARCHAR2
1642     , p6_a74 out nocopy  VARCHAR2
1643     , p6_a75 out nocopy  VARCHAR2
1644     , p6_a76 out nocopy  VARCHAR2
1645     , p6_a77 out nocopy  NUMBER
1646     , p6_a78 out nocopy  DATE
1647     , p6_a79 out nocopy  NUMBER
1648     , p6_a80 out nocopy  NUMBER
1649     , p6_a81 out nocopy  VARCHAR2
1650     , p6_a82 out nocopy  DATE
1651     , p6_a83 out nocopy  NUMBER
1652     , p6_a84 out nocopy  DATE
1653     , p6_a85 out nocopy  VARCHAR2
1654     , p6_a86 out nocopy  VARCHAR2
1655     , p6_a87 out nocopy  VARCHAR2
1656     , p6_a88 out nocopy  VARCHAR2
1657     , p6_a89 out nocopy  VARCHAR2
1658     , p6_a90 out nocopy  VARCHAR2
1659     , p6_a91 out nocopy  VARCHAR2
1660     , p6_a92 out nocopy  VARCHAR2
1661     , p6_a93 out nocopy  DATE
1662     , p5_a0  NUMBER := 0-1962.0724
1663     , p5_a1  NUMBER := 0-1962.0724
1664     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1665     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
1666     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1667     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
1668     , p5_a6  NUMBER := 0-1962.0724
1669     , p5_a7  NUMBER := 0-1962.0724
1670     , p5_a8  NUMBER := 0-1962.0724
1671     , p5_a9  NUMBER := 0-1962.0724
1672     , p5_a10  NUMBER := 0-1962.0724
1673     , p5_a11  NUMBER := 0-1962.0724
1674     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1675     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1676     , p5_a14  DATE := fnd_api.g_miss_date
1677     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1678     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1679     , p5_a17  NUMBER := 0-1962.0724
1680     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1681     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1682     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1683     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1684     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1685     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1686     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1687     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
1688     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1689     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1690     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1691     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1692     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1693     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1694     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1695     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1696     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1697     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1698     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
1699     , p5_a37  NUMBER := 0-1962.0724
1700     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1701     , p5_a39  NUMBER := 0-1962.0724
1702     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1703     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1704     , p5_a42  NUMBER := 0-1962.0724
1705     , p5_a43  NUMBER := 0-1962.0724
1706     , p5_a44  NUMBER := 0-1962.0724
1707     , p5_a45  NUMBER := 0-1962.0724
1708     , p5_a46  NUMBER := 0-1962.0724
1709     , p5_a47  NUMBER := 0-1962.0724
1710     , p5_a48  DATE := fnd_api.g_miss_date
1711     , p5_a49  NUMBER := 0-1962.0724
1712     , p5_a50  DATE := fnd_api.g_miss_date
1713     , p5_a51  NUMBER := 0-1962.0724
1714     , p5_a52  DATE := fnd_api.g_miss_date
1715     , p5_a53  NUMBER := 0-1962.0724
1716     , p5_a54  NUMBER := 0-1962.0724
1717     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
1718     , p5_a56  NUMBER := 0-1962.0724
1719     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
1720     , p5_a58  DATE := fnd_api.g_miss_date
1721     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
1722     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
1723     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
1724     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
1725     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
1726     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
1727     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
1728     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
1729     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1730     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1731     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1732     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1733     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1734     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1735     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1736     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1737     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1738     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1739     , p5_a77  NUMBER := 0-1962.0724
1740     , p5_a78  DATE := fnd_api.g_miss_date
1741     , p5_a79  NUMBER := 0-1962.0724
1742     , p5_a80  NUMBER := 0-1962.0724
1743     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1744     , p5_a82  DATE := fnd_api.g_miss_date
1745     , p5_a83  NUMBER := 0-1962.0724
1746     , p5_a84  DATE := fnd_api.g_miss_date
1747     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
1748     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
1749     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
1750     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
1751     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1752     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1753     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1754     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1755     , p5_a93  DATE := fnd_api.g_miss_date
1756   );
1757   procedure delete_trx_contracts(p_api_version  NUMBER
1758     , p_init_msg_list  VARCHAR2
1759     , x_return_status out nocopy  VARCHAR2
1760     , x_msg_count out nocopy  NUMBER
1761     , x_msg_data out nocopy  VARCHAR2
1762     , p5_a0 JTF_NUMBER_TABLE
1763     , p5_a1 JTF_NUMBER_TABLE
1764     , p5_a2 JTF_VARCHAR2_TABLE_100
1765     , p5_a3 JTF_VARCHAR2_TABLE_100
1766     , p5_a4 JTF_VARCHAR2_TABLE_100
1767     , p5_a5 JTF_VARCHAR2_TABLE_100
1768     , p5_a6 JTF_NUMBER_TABLE
1769     , p5_a7 JTF_NUMBER_TABLE
1770     , p5_a8 JTF_NUMBER_TABLE
1771     , p5_a9 JTF_NUMBER_TABLE
1772     , p5_a10 JTF_NUMBER_TABLE
1773     , p5_a11 JTF_NUMBER_TABLE
1774     , p5_a12 JTF_VARCHAR2_TABLE_100
1775     , p5_a13 JTF_VARCHAR2_TABLE_100
1776     , p5_a14 JTF_DATE_TABLE
1777     , p5_a15 JTF_VARCHAR2_TABLE_100
1778     , p5_a16 JTF_VARCHAR2_TABLE_100
1779     , p5_a17 JTF_NUMBER_TABLE
1780     , p5_a18 JTF_VARCHAR2_TABLE_200
1781     , p5_a19 JTF_VARCHAR2_TABLE_100
1782     , p5_a20 JTF_VARCHAR2_TABLE_500
1783     , p5_a21 JTF_VARCHAR2_TABLE_500
1784     , p5_a22 JTF_VARCHAR2_TABLE_500
1785     , p5_a23 JTF_VARCHAR2_TABLE_500
1786     , p5_a24 JTF_VARCHAR2_TABLE_500
1787     , p5_a25 JTF_VARCHAR2_TABLE_500
1788     , p5_a26 JTF_VARCHAR2_TABLE_500
1789     , p5_a27 JTF_VARCHAR2_TABLE_500
1790     , p5_a28 JTF_VARCHAR2_TABLE_500
1791     , p5_a29 JTF_VARCHAR2_TABLE_500
1792     , p5_a30 JTF_VARCHAR2_TABLE_500
1793     , p5_a31 JTF_VARCHAR2_TABLE_500
1794     , p5_a32 JTF_VARCHAR2_TABLE_500
1795     , p5_a33 JTF_VARCHAR2_TABLE_500
1796     , p5_a34 JTF_VARCHAR2_TABLE_500
1797     , p5_a35 JTF_VARCHAR2_TABLE_100
1798     , p5_a36 JTF_VARCHAR2_TABLE_100
1799     , p5_a37 JTF_NUMBER_TABLE
1800     , p5_a38 JTF_VARCHAR2_TABLE_100
1801     , p5_a39 JTF_NUMBER_TABLE
1802     , p5_a40 JTF_VARCHAR2_TABLE_100
1803     , p5_a41 JTF_VARCHAR2_TABLE_100
1804     , p5_a42 JTF_NUMBER_TABLE
1805     , p5_a43 JTF_NUMBER_TABLE
1806     , p5_a44 JTF_NUMBER_TABLE
1807     , p5_a45 JTF_NUMBER_TABLE
1808     , p5_a46 JTF_NUMBER_TABLE
1809     , p5_a47 JTF_NUMBER_TABLE
1810     , p5_a48 JTF_DATE_TABLE
1811     , p5_a49 JTF_NUMBER_TABLE
1812     , p5_a50 JTF_DATE_TABLE
1813     , p5_a51 JTF_NUMBER_TABLE
1814     , p5_a52 JTF_DATE_TABLE
1815     , p5_a53 JTF_NUMBER_TABLE
1816     , p5_a54 JTF_NUMBER_TABLE
1817     , p5_a55 JTF_VARCHAR2_TABLE_100
1818     , p5_a56 JTF_NUMBER_TABLE
1819     , p5_a57 JTF_VARCHAR2_TABLE_2000
1820     , p5_a58 JTF_DATE_TABLE
1821     , p5_a59 JTF_VARCHAR2_TABLE_100
1822     , p5_a60 JTF_VARCHAR2_TABLE_100
1823     , p5_a61 JTF_VARCHAR2_TABLE_100
1824     , p5_a62 JTF_VARCHAR2_TABLE_100
1825     , p5_a63 JTF_VARCHAR2_TABLE_100
1826     , p5_a64 JTF_VARCHAR2_TABLE_100
1827     , p5_a65 JTF_VARCHAR2_TABLE_100
1828     , p5_a66 JTF_VARCHAR2_TABLE_100
1829     , p5_a67 JTF_VARCHAR2_TABLE_100
1830     , p5_a68 JTF_VARCHAR2_TABLE_100
1831     , p5_a69 JTF_VARCHAR2_TABLE_100
1832     , p5_a70 JTF_VARCHAR2_TABLE_100
1833     , p5_a71 JTF_VARCHAR2_TABLE_100
1834     , p5_a72 JTF_VARCHAR2_TABLE_100
1835     , p5_a73 JTF_VARCHAR2_TABLE_100
1836     , p5_a74 JTF_VARCHAR2_TABLE_100
1837     , p5_a75 JTF_VARCHAR2_TABLE_100
1838     , p5_a76 JTF_VARCHAR2_TABLE_100
1839     , p5_a77 JTF_NUMBER_TABLE
1840     , p5_a78 JTF_DATE_TABLE
1841     , p5_a79 JTF_NUMBER_TABLE
1842     , p5_a80 JTF_NUMBER_TABLE
1843     , p5_a81 JTF_VARCHAR2_TABLE_100
1844     , p5_a82 JTF_DATE_TABLE
1845     , p5_a83 JTF_NUMBER_TABLE
1846     , p5_a84 JTF_DATE_TABLE
1847     , p5_a85 JTF_VARCHAR2_TABLE_100
1848     , p5_a86 JTF_VARCHAR2_TABLE_200
1849     , p5_a87 JTF_VARCHAR2_TABLE_100
1850     , p5_a88 JTF_VARCHAR2_TABLE_200
1851     , p5_a89 JTF_VARCHAR2_TABLE_100
1852     , p5_a90 JTF_VARCHAR2_TABLE_100
1853     , p5_a91 JTF_VARCHAR2_TABLE_100
1854     , p5_a92 JTF_VARCHAR2_TABLE_100
1855     , p5_a93 JTF_DATE_TABLE
1856   );
1857   procedure delete_trx_contracts(p_api_version  NUMBER
1858     , p_init_msg_list  VARCHAR2
1859     , x_return_status out nocopy  VARCHAR2
1860     , x_msg_count out nocopy  NUMBER
1861     , x_msg_data out nocopy  VARCHAR2
1862     , p5_a0  NUMBER := 0-1962.0724
1863     , p5_a1  NUMBER := 0-1962.0724
1864     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1865     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
1866     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
1867     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
1868     , p5_a6  NUMBER := 0-1962.0724
1869     , p5_a7  NUMBER := 0-1962.0724
1870     , p5_a8  NUMBER := 0-1962.0724
1871     , p5_a9  NUMBER := 0-1962.0724
1872     , p5_a10  NUMBER := 0-1962.0724
1873     , p5_a11  NUMBER := 0-1962.0724
1874     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1875     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1876     , p5_a14  DATE := fnd_api.g_miss_date
1877     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1878     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1879     , p5_a17  NUMBER := 0-1962.0724
1880     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1881     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1882     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1883     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1884     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1885     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1886     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1887     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
1888     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
1889     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
1890     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
1891     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
1892     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1893     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1894     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1895     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1896     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1897     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1898     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
1899     , p5_a37  NUMBER := 0-1962.0724
1900     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
1901     , p5_a39  NUMBER := 0-1962.0724
1902     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
1903     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
1904     , p5_a42  NUMBER := 0-1962.0724
1905     , p5_a43  NUMBER := 0-1962.0724
1906     , p5_a44  NUMBER := 0-1962.0724
1907     , p5_a45  NUMBER := 0-1962.0724
1908     , p5_a46  NUMBER := 0-1962.0724
1909     , p5_a47  NUMBER := 0-1962.0724
1910     , p5_a48  DATE := fnd_api.g_miss_date
1911     , p5_a49  NUMBER := 0-1962.0724
1912     , p5_a50  DATE := fnd_api.g_miss_date
1913     , p5_a51  NUMBER := 0-1962.0724
1914     , p5_a52  DATE := fnd_api.g_miss_date
1915     , p5_a53  NUMBER := 0-1962.0724
1916     , p5_a54  NUMBER := 0-1962.0724
1917     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
1918     , p5_a56  NUMBER := 0-1962.0724
1919     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
1920     , p5_a58  DATE := fnd_api.g_miss_date
1921     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
1922     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
1923     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
1924     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
1925     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
1926     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
1927     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
1928     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
1929     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
1930     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1931     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1932     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1933     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1934     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1935     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1936     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1937     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1938     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1939     , p5_a77  NUMBER := 0-1962.0724
1940     , p5_a78  DATE := fnd_api.g_miss_date
1941     , p5_a79  NUMBER := 0-1962.0724
1942     , p5_a80  NUMBER := 0-1962.0724
1943     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1944     , p5_a82  DATE := fnd_api.g_miss_date
1945     , p5_a83  NUMBER := 0-1962.0724
1946     , p5_a84  DATE := fnd_api.g_miss_date
1947     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
1948     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
1949     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
1950     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
1951     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1952     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1953     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1954     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1955     , p5_a93  DATE := fnd_api.g_miss_date
1956   );
1957   procedure validate_trx_contracts(p_api_version  NUMBER
1958     , p_init_msg_list  VARCHAR2
1959     , x_return_status out nocopy  VARCHAR2
1960     , x_msg_count out nocopy  NUMBER
1961     , x_msg_data out nocopy  VARCHAR2
1962     , p5_a0 JTF_NUMBER_TABLE
1963     , p5_a1 JTF_NUMBER_TABLE
1964     , p5_a2 JTF_VARCHAR2_TABLE_100
1965     , p5_a3 JTF_VARCHAR2_TABLE_100
1966     , p5_a4 JTF_VARCHAR2_TABLE_100
1967     , p5_a5 JTF_VARCHAR2_TABLE_100
1968     , p5_a6 JTF_NUMBER_TABLE
1969     , p5_a7 JTF_NUMBER_TABLE
1970     , p5_a8 JTF_NUMBER_TABLE
1971     , p5_a9 JTF_NUMBER_TABLE
1972     , p5_a10 JTF_NUMBER_TABLE
1973     , p5_a11 JTF_NUMBER_TABLE
1974     , p5_a12 JTF_VARCHAR2_TABLE_100
1975     , p5_a13 JTF_VARCHAR2_TABLE_100
1976     , p5_a14 JTF_DATE_TABLE
1977     , p5_a15 JTF_VARCHAR2_TABLE_100
1978     , p5_a16 JTF_VARCHAR2_TABLE_100
1979     , p5_a17 JTF_NUMBER_TABLE
1980     , p5_a18 JTF_VARCHAR2_TABLE_200
1981     , p5_a19 JTF_VARCHAR2_TABLE_100
1982     , p5_a20 JTF_VARCHAR2_TABLE_500
1983     , p5_a21 JTF_VARCHAR2_TABLE_500
1984     , p5_a22 JTF_VARCHAR2_TABLE_500
1985     , p5_a23 JTF_VARCHAR2_TABLE_500
1986     , p5_a24 JTF_VARCHAR2_TABLE_500
1987     , p5_a25 JTF_VARCHAR2_TABLE_500
1988     , p5_a26 JTF_VARCHAR2_TABLE_500
1989     , p5_a27 JTF_VARCHAR2_TABLE_500
1990     , p5_a28 JTF_VARCHAR2_TABLE_500
1991     , p5_a29 JTF_VARCHAR2_TABLE_500
1992     , p5_a30 JTF_VARCHAR2_TABLE_500
1993     , p5_a31 JTF_VARCHAR2_TABLE_500
1994     , p5_a32 JTF_VARCHAR2_TABLE_500
1995     , p5_a33 JTF_VARCHAR2_TABLE_500
1996     , p5_a34 JTF_VARCHAR2_TABLE_500
1997     , p5_a35 JTF_VARCHAR2_TABLE_100
1998     , p5_a36 JTF_VARCHAR2_TABLE_100
1999     , p5_a37 JTF_NUMBER_TABLE
2000     , p5_a38 JTF_VARCHAR2_TABLE_100
2001     , p5_a39 JTF_NUMBER_TABLE
2002     , p5_a40 JTF_VARCHAR2_TABLE_100
2003     , p5_a41 JTF_VARCHAR2_TABLE_100
2004     , p5_a42 JTF_NUMBER_TABLE
2005     , p5_a43 JTF_NUMBER_TABLE
2006     , p5_a44 JTF_NUMBER_TABLE
2007     , p5_a45 JTF_NUMBER_TABLE
2008     , p5_a46 JTF_NUMBER_TABLE
2009     , p5_a47 JTF_NUMBER_TABLE
2010     , p5_a48 JTF_DATE_TABLE
2011     , p5_a49 JTF_NUMBER_TABLE
2012     , p5_a50 JTF_DATE_TABLE
2013     , p5_a51 JTF_NUMBER_TABLE
2014     , p5_a52 JTF_DATE_TABLE
2015     , p5_a53 JTF_NUMBER_TABLE
2016     , p5_a54 JTF_NUMBER_TABLE
2017     , p5_a55 JTF_VARCHAR2_TABLE_100
2018     , p5_a56 JTF_NUMBER_TABLE
2019     , p5_a57 JTF_VARCHAR2_TABLE_2000
2020     , p5_a58 JTF_DATE_TABLE
2021     , p5_a59 JTF_VARCHAR2_TABLE_100
2022     , p5_a60 JTF_VARCHAR2_TABLE_100
2023     , p5_a61 JTF_VARCHAR2_TABLE_100
2024     , p5_a62 JTF_VARCHAR2_TABLE_100
2025     , p5_a63 JTF_VARCHAR2_TABLE_100
2026     , p5_a64 JTF_VARCHAR2_TABLE_100
2027     , p5_a65 JTF_VARCHAR2_TABLE_100
2028     , p5_a66 JTF_VARCHAR2_TABLE_100
2029     , p5_a67 JTF_VARCHAR2_TABLE_100
2030     , p5_a68 JTF_VARCHAR2_TABLE_100
2031     , p5_a69 JTF_VARCHAR2_TABLE_100
2032     , p5_a70 JTF_VARCHAR2_TABLE_100
2033     , p5_a71 JTF_VARCHAR2_TABLE_100
2034     , p5_a72 JTF_VARCHAR2_TABLE_100
2035     , p5_a73 JTF_VARCHAR2_TABLE_100
2036     , p5_a74 JTF_VARCHAR2_TABLE_100
2037     , p5_a75 JTF_VARCHAR2_TABLE_100
2038     , p5_a76 JTF_VARCHAR2_TABLE_100
2039     , p5_a77 JTF_NUMBER_TABLE
2040     , p5_a78 JTF_DATE_TABLE
2041     , p5_a79 JTF_NUMBER_TABLE
2042     , p5_a80 JTF_NUMBER_TABLE
2043     , p5_a81 JTF_VARCHAR2_TABLE_100
2044     , p5_a82 JTF_DATE_TABLE
2045     , p5_a83 JTF_NUMBER_TABLE
2046     , p5_a84 JTF_DATE_TABLE
2047     , p5_a85 JTF_VARCHAR2_TABLE_100
2048     , p5_a86 JTF_VARCHAR2_TABLE_200
2049     , p5_a87 JTF_VARCHAR2_TABLE_100
2050     , p5_a88 JTF_VARCHAR2_TABLE_200
2051     , p5_a89 JTF_VARCHAR2_TABLE_100
2052     , p5_a90 JTF_VARCHAR2_TABLE_100
2053     , p5_a91 JTF_VARCHAR2_TABLE_100
2054     , p5_a92 JTF_VARCHAR2_TABLE_100
2055     , p5_a93 JTF_DATE_TABLE
2056   );
2057   procedure validate_trx_contracts(p_api_version  NUMBER
2058     , p_init_msg_list  VARCHAR2
2059     , x_return_status out nocopy  VARCHAR2
2060     , x_msg_count out nocopy  NUMBER
2061     , x_msg_data out nocopy  VARCHAR2
2062     , p5_a0  NUMBER := 0-1962.0724
2063     , p5_a1  NUMBER := 0-1962.0724
2064     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
2065     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
2066     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
2067     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
2068     , p5_a6  NUMBER := 0-1962.0724
2069     , p5_a7  NUMBER := 0-1962.0724
2070     , p5_a8  NUMBER := 0-1962.0724
2071     , p5_a9  NUMBER := 0-1962.0724
2072     , p5_a10  NUMBER := 0-1962.0724
2073     , p5_a11  NUMBER := 0-1962.0724
2074     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2075     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2076     , p5_a14  DATE := fnd_api.g_miss_date
2077     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2078     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2079     , p5_a17  NUMBER := 0-1962.0724
2080     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2081     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2082     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2083     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2084     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2085     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2086     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2087     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2088     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2089     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2090     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2091     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2092     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
2093     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
2094     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
2095     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
2096     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
2097     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
2098     , p5_a36  VARCHAR2 := fnd_api.g_miss_char
2099     , p5_a37  NUMBER := 0-1962.0724
2100     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
2101     , p5_a39  NUMBER := 0-1962.0724
2102     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
2103     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
2104     , p5_a42  NUMBER := 0-1962.0724
2105     , p5_a43  NUMBER := 0-1962.0724
2106     , p5_a44  NUMBER := 0-1962.0724
2107     , p5_a45  NUMBER := 0-1962.0724
2108     , p5_a46  NUMBER := 0-1962.0724
2109     , p5_a47  NUMBER := 0-1962.0724
2110     , p5_a48  DATE := fnd_api.g_miss_date
2111     , p5_a49  NUMBER := 0-1962.0724
2112     , p5_a50  DATE := fnd_api.g_miss_date
2113     , p5_a51  NUMBER := 0-1962.0724
2114     , p5_a52  DATE := fnd_api.g_miss_date
2115     , p5_a53  NUMBER := 0-1962.0724
2116     , p5_a54  NUMBER := 0-1962.0724
2117     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
2118     , p5_a56  NUMBER := 0-1962.0724
2119     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
2120     , p5_a58  DATE := fnd_api.g_miss_date
2121     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
2122     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
2123     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
2124     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
2125     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
2126     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
2127     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
2128     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
2129     , p5_a67  VARCHAR2 := fnd_api.g_miss_char
2130     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
2131     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
2132     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
2133     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
2134     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
2135     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
2136     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
2137     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
2138     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
2139     , p5_a77  NUMBER := 0-1962.0724
2140     , p5_a78  DATE := fnd_api.g_miss_date
2141     , p5_a79  NUMBER := 0-1962.0724
2142     , p5_a80  NUMBER := 0-1962.0724
2143     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
2144     , p5_a82  DATE := fnd_api.g_miss_date
2145     , p5_a83  NUMBER := 0-1962.0724
2146     , p5_a84  DATE := fnd_api.g_miss_date
2147     , p5_a85  VARCHAR2 := fnd_api.g_miss_char
2148     , p5_a86  VARCHAR2 := fnd_api.g_miss_char
2149     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
2150     , p5_a88  VARCHAR2 := fnd_api.g_miss_char
2151     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
2152     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
2153     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
2154     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
2155     , p5_a93  DATE := fnd_api.g_miss_date
2156   );
2157   procedure create_trx_cntrct_lines(p_api_version  NUMBER
2158     , p_init_msg_list  VARCHAR2
2159     , x_return_status out nocopy  VARCHAR2
2160     , x_msg_count out nocopy  NUMBER
2161     , x_msg_data out nocopy  VARCHAR2
2162     , p5_a0 JTF_NUMBER_TABLE
2163     , p5_a1 JTF_NUMBER_TABLE
2164     , p5_a2 JTF_NUMBER_TABLE
2165     , p5_a3 JTF_NUMBER_TABLE
2166     , p5_a4 JTF_NUMBER_TABLE
2167     , p5_a5 JTF_NUMBER_TABLE
2168     , p5_a6 JTF_NUMBER_TABLE
2169     , p5_a7 JTF_NUMBER_TABLE
2170     , p5_a8 JTF_VARCHAR2_TABLE_100
2171     , p5_a9 JTF_NUMBER_TABLE
2172     , p5_a10 JTF_VARCHAR2_TABLE_2000
2173     , p5_a11 JTF_NUMBER_TABLE
2174     , p5_a12 JTF_VARCHAR2_TABLE_200
2175     , p5_a13 JTF_VARCHAR2_TABLE_100
2176     , p5_a14 JTF_VARCHAR2_TABLE_100
2177     , p5_a15 JTF_VARCHAR2_TABLE_500
2178     , p5_a16 JTF_VARCHAR2_TABLE_500
2179     , p5_a17 JTF_VARCHAR2_TABLE_500
2180     , p5_a18 JTF_VARCHAR2_TABLE_500
2181     , p5_a19 JTF_VARCHAR2_TABLE_500
2182     , p5_a20 JTF_VARCHAR2_TABLE_500
2183     , p5_a21 JTF_VARCHAR2_TABLE_500
2184     , p5_a22 JTF_VARCHAR2_TABLE_500
2185     , p5_a23 JTF_VARCHAR2_TABLE_500
2186     , p5_a24 JTF_VARCHAR2_TABLE_500
2187     , p5_a25 JTF_VARCHAR2_TABLE_500
2188     , p5_a26 JTF_VARCHAR2_TABLE_500
2189     , p5_a27 JTF_VARCHAR2_TABLE_500
2190     , p5_a28 JTF_VARCHAR2_TABLE_500
2191     , p5_a29 JTF_VARCHAR2_TABLE_500
2192     , p5_a30 JTF_VARCHAR2_TABLE_100
2193     , p5_a31 JTF_NUMBER_TABLE
2194     , p5_a32 JTF_DATE_TABLE
2195     , p5_a33 JTF_NUMBER_TABLE
2196     , p5_a34 JTF_DATE_TABLE
2197     , p5_a35 JTF_NUMBER_TABLE
2198     , p5_a36 JTF_NUMBER_TABLE
2199     , p5_a37 JTF_NUMBER_TABLE
2200     , p5_a38 JTF_NUMBER_TABLE
2201     , p5_a39 JTF_DATE_TABLE
2202     , p5_a40 JTF_NUMBER_TABLE
2203     , p5_a41 JTF_NUMBER_TABLE
2204     , p5_a42 JTF_NUMBER_TABLE
2205     , p5_a43 JTF_NUMBER_TABLE
2206     , p5_a44 JTF_NUMBER_TABLE
2207     , p5_a45 JTF_VARCHAR2_TABLE_100
2208     , p5_a46 JTF_VARCHAR2_TABLE_200
2209     , p5_a47 JTF_NUMBER_TABLE
2210     , p5_a48 JTF_VARCHAR2_TABLE_200
2211     , p5_a49 JTF_NUMBER_TABLE
2212     , p5_a50 JTF_VARCHAR2_TABLE_200
2213     , p5_a51 JTF_NUMBER_TABLE
2214     , p5_a52 JTF_DATE_TABLE
2215     , p5_a53 JTF_NUMBER_TABLE
2216     , p5_a54 JTF_VARCHAR2_TABLE_200
2217     , p5_a55 JTF_VARCHAR2_TABLE_300
2218     , p5_a56 JTF_VARCHAR2_TABLE_100
2219     , p5_a57 JTF_VARCHAR2_TABLE_100
2220     , p6_a0 out nocopy JTF_NUMBER_TABLE
2221     , p6_a1 out nocopy JTF_NUMBER_TABLE
2222     , p6_a2 out nocopy JTF_NUMBER_TABLE
2223     , p6_a3 out nocopy JTF_NUMBER_TABLE
2224     , p6_a4 out nocopy JTF_NUMBER_TABLE
2225     , p6_a5 out nocopy JTF_NUMBER_TABLE
2226     , p6_a6 out nocopy JTF_NUMBER_TABLE
2227     , p6_a7 out nocopy JTF_NUMBER_TABLE
2228     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2229     , p6_a9 out nocopy JTF_NUMBER_TABLE
2230     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2231     , p6_a11 out nocopy JTF_NUMBER_TABLE
2232     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
2233     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2234     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2235     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2236     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2237     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2238     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2239     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2240     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2241     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2242     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2243     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2244     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2245     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2246     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2247     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2248     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
2249     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
2250     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2251     , p6_a31 out nocopy JTF_NUMBER_TABLE
2252     , p6_a32 out nocopy JTF_DATE_TABLE
2253     , p6_a33 out nocopy JTF_NUMBER_TABLE
2254     , p6_a34 out nocopy JTF_DATE_TABLE
2255     , p6_a35 out nocopy JTF_NUMBER_TABLE
2256     , p6_a36 out nocopy JTF_NUMBER_TABLE
2257     , p6_a37 out nocopy JTF_NUMBER_TABLE
2258     , p6_a38 out nocopy JTF_NUMBER_TABLE
2259     , p6_a39 out nocopy JTF_DATE_TABLE
2260     , p6_a40 out nocopy JTF_NUMBER_TABLE
2261     , p6_a41 out nocopy JTF_NUMBER_TABLE
2262     , p6_a42 out nocopy JTF_NUMBER_TABLE
2263     , p6_a43 out nocopy JTF_NUMBER_TABLE
2264     , p6_a44 out nocopy JTF_NUMBER_TABLE
2265     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
2266     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_200
2267     , p6_a47 out nocopy JTF_NUMBER_TABLE
2268     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_200
2269     , p6_a49 out nocopy JTF_NUMBER_TABLE
2270     , p6_a50 out nocopy JTF_VARCHAR2_TABLE_200
2271     , p6_a51 out nocopy JTF_NUMBER_TABLE
2272     , p6_a52 out nocopy JTF_DATE_TABLE
2273     , p6_a53 out nocopy JTF_NUMBER_TABLE
2274     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_200
2275     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_300
2276     , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
2277     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
2278   );
2279   procedure create_trx_cntrct_lines(p_api_version  NUMBER
2280     , p_init_msg_list  VARCHAR2
2281     , x_return_status out nocopy  VARCHAR2
2282     , x_msg_count out nocopy  NUMBER
2283     , x_msg_data out nocopy  VARCHAR2
2284     , p6_a0 out nocopy  NUMBER
2285     , p6_a1 out nocopy  NUMBER
2286     , p6_a2 out nocopy  NUMBER
2287     , p6_a3 out nocopy  NUMBER
2288     , p6_a4 out nocopy  NUMBER
2289     , p6_a5 out nocopy  NUMBER
2290     , p6_a6 out nocopy  NUMBER
2291     , p6_a7 out nocopy  NUMBER
2292     , p6_a8 out nocopy  VARCHAR2
2293     , p6_a9 out nocopy  NUMBER
2294     , p6_a10 out nocopy  VARCHAR2
2295     , p6_a11 out nocopy  NUMBER
2296     , p6_a12 out nocopy  VARCHAR2
2297     , p6_a13 out nocopy  VARCHAR2
2298     , p6_a14 out nocopy  VARCHAR2
2299     , p6_a15 out nocopy  VARCHAR2
2300     , p6_a16 out nocopy  VARCHAR2
2301     , p6_a17 out nocopy  VARCHAR2
2302     , p6_a18 out nocopy  VARCHAR2
2303     , p6_a19 out nocopy  VARCHAR2
2304     , p6_a20 out nocopy  VARCHAR2
2305     , p6_a21 out nocopy  VARCHAR2
2306     , p6_a22 out nocopy  VARCHAR2
2307     , p6_a23 out nocopy  VARCHAR2
2308     , p6_a24 out nocopy  VARCHAR2
2309     , p6_a25 out nocopy  VARCHAR2
2310     , p6_a26 out nocopy  VARCHAR2
2311     , p6_a27 out nocopy  VARCHAR2
2312     , p6_a28 out nocopy  VARCHAR2
2313     , p6_a29 out nocopy  VARCHAR2
2314     , p6_a30 out nocopy  VARCHAR2
2315     , p6_a31 out nocopy  NUMBER
2316     , p6_a32 out nocopy  DATE
2317     , p6_a33 out nocopy  NUMBER
2318     , p6_a34 out nocopy  DATE
2319     , p6_a35 out nocopy  NUMBER
2320     , p6_a36 out nocopy  NUMBER
2321     , p6_a37 out nocopy  NUMBER
2322     , p6_a38 out nocopy  NUMBER
2323     , p6_a39 out nocopy  DATE
2324     , p6_a40 out nocopy  NUMBER
2325     , p6_a41 out nocopy  NUMBER
2326     , p6_a42 out nocopy  NUMBER
2327     , p6_a43 out nocopy  NUMBER
2328     , p6_a44 out nocopy  NUMBER
2329     , p6_a45 out nocopy  VARCHAR2
2330     , p6_a46 out nocopy  VARCHAR2
2331     , p6_a47 out nocopy  NUMBER
2332     , p6_a48 out nocopy  VARCHAR2
2333     , p6_a49 out nocopy  NUMBER
2334     , p6_a50 out nocopy  VARCHAR2
2335     , p6_a51 out nocopy  NUMBER
2336     , p6_a52 out nocopy  DATE
2337     , p6_a53 out nocopy  NUMBER
2338     , p6_a54 out nocopy  VARCHAR2
2339     , p6_a55 out nocopy  VARCHAR2
2340     , p6_a56 out nocopy  VARCHAR2
2341     , p6_a57 out nocopy  VARCHAR2
2342     , p5_a0  NUMBER := 0-1962.0724
2343     , p5_a1  NUMBER := 0-1962.0724
2344     , p5_a2  NUMBER := 0-1962.0724
2345     , p5_a3  NUMBER := 0-1962.0724
2346     , p5_a4  NUMBER := 0-1962.0724
2347     , p5_a5  NUMBER := 0-1962.0724
2348     , p5_a6  NUMBER := 0-1962.0724
2349     , p5_a7  NUMBER := 0-1962.0724
2350     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2351     , p5_a9  NUMBER := 0-1962.0724
2352     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2353     , p5_a11  NUMBER := 0-1962.0724
2354     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2355     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2356     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2357     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2358     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2359     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2360     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2361     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2362     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2363     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2364     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2365     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2366     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2367     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2368     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2369     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2370     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2371     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2372     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
2373     , p5_a31  NUMBER := 0-1962.0724
2374     , p5_a32  DATE := fnd_api.g_miss_date
2375     , p5_a33  NUMBER := 0-1962.0724
2376     , p5_a34  DATE := fnd_api.g_miss_date
2377     , p5_a35  NUMBER := 0-1962.0724
2378     , p5_a36  NUMBER := 0-1962.0724
2379     , p5_a37  NUMBER := 0-1962.0724
2380     , p5_a38  NUMBER := 0-1962.0724
2381     , p5_a39  DATE := fnd_api.g_miss_date
2382     , p5_a40  NUMBER := 0-1962.0724
2383     , p5_a41  NUMBER := 0-1962.0724
2384     , p5_a42  NUMBER := 0-1962.0724
2385     , p5_a43  NUMBER := 0-1962.0724
2386     , p5_a44  NUMBER := 0-1962.0724
2387     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2388     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2389     , p5_a47  NUMBER := 0-1962.0724
2390     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2391     , p5_a49  NUMBER := 0-1962.0724
2392     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2393     , p5_a51  NUMBER := 0-1962.0724
2394     , p5_a52  DATE := fnd_api.g_miss_date
2395     , p5_a53  NUMBER := 0-1962.0724
2396     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
2397     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
2398     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
2399     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
2400   );
2401   procedure lock_trx_cntrct_lines(p_api_version  NUMBER
2402     , p_init_msg_list  VARCHAR2
2403     , x_return_status out nocopy  VARCHAR2
2404     , x_msg_count out nocopy  NUMBER
2405     , x_msg_data out nocopy  VARCHAR2
2406     , p5_a0 JTF_NUMBER_TABLE
2407     , p5_a1 JTF_NUMBER_TABLE
2408     , p5_a2 JTF_NUMBER_TABLE
2409     , p5_a3 JTF_NUMBER_TABLE
2410     , p5_a4 JTF_NUMBER_TABLE
2411     , p5_a5 JTF_NUMBER_TABLE
2412     , p5_a6 JTF_NUMBER_TABLE
2413     , p5_a7 JTF_NUMBER_TABLE
2414     , p5_a8 JTF_VARCHAR2_TABLE_100
2415     , p5_a9 JTF_NUMBER_TABLE
2416     , p5_a10 JTF_VARCHAR2_TABLE_2000
2417     , p5_a11 JTF_NUMBER_TABLE
2418     , p5_a12 JTF_VARCHAR2_TABLE_200
2419     , p5_a13 JTF_VARCHAR2_TABLE_100
2420     , p5_a14 JTF_VARCHAR2_TABLE_100
2421     , p5_a15 JTF_VARCHAR2_TABLE_500
2422     , p5_a16 JTF_VARCHAR2_TABLE_500
2423     , p5_a17 JTF_VARCHAR2_TABLE_500
2424     , p5_a18 JTF_VARCHAR2_TABLE_500
2425     , p5_a19 JTF_VARCHAR2_TABLE_500
2426     , p5_a20 JTF_VARCHAR2_TABLE_500
2427     , p5_a21 JTF_VARCHAR2_TABLE_500
2428     , p5_a22 JTF_VARCHAR2_TABLE_500
2429     , p5_a23 JTF_VARCHAR2_TABLE_500
2430     , p5_a24 JTF_VARCHAR2_TABLE_500
2431     , p5_a25 JTF_VARCHAR2_TABLE_500
2432     , p5_a26 JTF_VARCHAR2_TABLE_500
2433     , p5_a27 JTF_VARCHAR2_TABLE_500
2434     , p5_a28 JTF_VARCHAR2_TABLE_500
2435     , p5_a29 JTF_VARCHAR2_TABLE_500
2436     , p5_a30 JTF_VARCHAR2_TABLE_100
2437     , p5_a31 JTF_NUMBER_TABLE
2438     , p5_a32 JTF_DATE_TABLE
2439     , p5_a33 JTF_NUMBER_TABLE
2440     , p5_a34 JTF_DATE_TABLE
2441     , p5_a35 JTF_NUMBER_TABLE
2442     , p5_a36 JTF_NUMBER_TABLE
2443     , p5_a37 JTF_NUMBER_TABLE
2444     , p5_a38 JTF_NUMBER_TABLE
2445     , p5_a39 JTF_DATE_TABLE
2446     , p5_a40 JTF_NUMBER_TABLE
2447     , p5_a41 JTF_NUMBER_TABLE
2448     , p5_a42 JTF_NUMBER_TABLE
2449     , p5_a43 JTF_NUMBER_TABLE
2450     , p5_a44 JTF_NUMBER_TABLE
2451     , p5_a45 JTF_VARCHAR2_TABLE_100
2452     , p5_a46 JTF_VARCHAR2_TABLE_200
2453     , p5_a47 JTF_NUMBER_TABLE
2454     , p5_a48 JTF_VARCHAR2_TABLE_200
2455     , p5_a49 JTF_NUMBER_TABLE
2456     , p5_a50 JTF_VARCHAR2_TABLE_200
2457     , p5_a51 JTF_NUMBER_TABLE
2458     , p5_a52 JTF_DATE_TABLE
2459     , p5_a53 JTF_NUMBER_TABLE
2460     , p5_a54 JTF_VARCHAR2_TABLE_200
2461     , p5_a55 JTF_VARCHAR2_TABLE_300
2462     , p5_a56 JTF_VARCHAR2_TABLE_100
2463     , p5_a57 JTF_VARCHAR2_TABLE_100
2464   );
2465   procedure lock_trx_cntrct_lines(p_api_version  NUMBER
2466     , p_init_msg_list  VARCHAR2
2467     , x_return_status out nocopy  VARCHAR2
2468     , x_msg_count out nocopy  NUMBER
2469     , x_msg_data out nocopy  VARCHAR2
2470     , p5_a0  NUMBER := 0-1962.0724
2471     , p5_a1  NUMBER := 0-1962.0724
2472     , p5_a2  NUMBER := 0-1962.0724
2473     , p5_a3  NUMBER := 0-1962.0724
2474     , p5_a4  NUMBER := 0-1962.0724
2475     , p5_a5  NUMBER := 0-1962.0724
2476     , p5_a6  NUMBER := 0-1962.0724
2477     , p5_a7  NUMBER := 0-1962.0724
2478     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2479     , p5_a9  NUMBER := 0-1962.0724
2480     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2481     , p5_a11  NUMBER := 0-1962.0724
2482     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2483     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2484     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2485     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2486     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2487     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2488     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2489     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2490     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2491     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2492     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2493     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2494     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2495     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2496     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2497     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2498     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2499     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2500     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
2501     , p5_a31  NUMBER := 0-1962.0724
2502     , p5_a32  DATE := fnd_api.g_miss_date
2503     , p5_a33  NUMBER := 0-1962.0724
2504     , p5_a34  DATE := fnd_api.g_miss_date
2505     , p5_a35  NUMBER := 0-1962.0724
2506     , p5_a36  NUMBER := 0-1962.0724
2507     , p5_a37  NUMBER := 0-1962.0724
2508     , p5_a38  NUMBER := 0-1962.0724
2509     , p5_a39  DATE := fnd_api.g_miss_date
2510     , p5_a40  NUMBER := 0-1962.0724
2511     , p5_a41  NUMBER := 0-1962.0724
2512     , p5_a42  NUMBER := 0-1962.0724
2513     , p5_a43  NUMBER := 0-1962.0724
2514     , p5_a44  NUMBER := 0-1962.0724
2515     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2516     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2517     , p5_a47  NUMBER := 0-1962.0724
2518     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2519     , p5_a49  NUMBER := 0-1962.0724
2520     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2521     , p5_a51  NUMBER := 0-1962.0724
2522     , p5_a52  DATE := fnd_api.g_miss_date
2523     , p5_a53  NUMBER := 0-1962.0724
2524     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
2525     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
2526     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
2527     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
2528   );
2529   procedure update_trx_cntrct_lines(p_api_version  NUMBER
2530     , p_init_msg_list  VARCHAR2
2531     , x_return_status out nocopy  VARCHAR2
2532     , x_msg_count out nocopy  NUMBER
2533     , x_msg_data out nocopy  VARCHAR2
2534     , p5_a0 JTF_NUMBER_TABLE
2535     , p5_a1 JTF_NUMBER_TABLE
2536     , p5_a2 JTF_NUMBER_TABLE
2537     , p5_a3 JTF_NUMBER_TABLE
2538     , p5_a4 JTF_NUMBER_TABLE
2539     , p5_a5 JTF_NUMBER_TABLE
2540     , p5_a6 JTF_NUMBER_TABLE
2541     , p5_a7 JTF_NUMBER_TABLE
2542     , p5_a8 JTF_VARCHAR2_TABLE_100
2543     , p5_a9 JTF_NUMBER_TABLE
2544     , p5_a10 JTF_VARCHAR2_TABLE_2000
2545     , p5_a11 JTF_NUMBER_TABLE
2546     , p5_a12 JTF_VARCHAR2_TABLE_200
2547     , p5_a13 JTF_VARCHAR2_TABLE_100
2548     , p5_a14 JTF_VARCHAR2_TABLE_100
2549     , p5_a15 JTF_VARCHAR2_TABLE_500
2550     , p5_a16 JTF_VARCHAR2_TABLE_500
2551     , p5_a17 JTF_VARCHAR2_TABLE_500
2552     , p5_a18 JTF_VARCHAR2_TABLE_500
2553     , p5_a19 JTF_VARCHAR2_TABLE_500
2554     , p5_a20 JTF_VARCHAR2_TABLE_500
2555     , p5_a21 JTF_VARCHAR2_TABLE_500
2556     , p5_a22 JTF_VARCHAR2_TABLE_500
2557     , p5_a23 JTF_VARCHAR2_TABLE_500
2558     , p5_a24 JTF_VARCHAR2_TABLE_500
2559     , p5_a25 JTF_VARCHAR2_TABLE_500
2560     , p5_a26 JTF_VARCHAR2_TABLE_500
2561     , p5_a27 JTF_VARCHAR2_TABLE_500
2562     , p5_a28 JTF_VARCHAR2_TABLE_500
2563     , p5_a29 JTF_VARCHAR2_TABLE_500
2564     , p5_a30 JTF_VARCHAR2_TABLE_100
2565     , p5_a31 JTF_NUMBER_TABLE
2566     , p5_a32 JTF_DATE_TABLE
2567     , p5_a33 JTF_NUMBER_TABLE
2568     , p5_a34 JTF_DATE_TABLE
2569     , p5_a35 JTF_NUMBER_TABLE
2570     , p5_a36 JTF_NUMBER_TABLE
2571     , p5_a37 JTF_NUMBER_TABLE
2572     , p5_a38 JTF_NUMBER_TABLE
2573     , p5_a39 JTF_DATE_TABLE
2574     , p5_a40 JTF_NUMBER_TABLE
2575     , p5_a41 JTF_NUMBER_TABLE
2576     , p5_a42 JTF_NUMBER_TABLE
2577     , p5_a43 JTF_NUMBER_TABLE
2578     , p5_a44 JTF_NUMBER_TABLE
2579     , p5_a45 JTF_VARCHAR2_TABLE_100
2580     , p5_a46 JTF_VARCHAR2_TABLE_200
2581     , p5_a47 JTF_NUMBER_TABLE
2582     , p5_a48 JTF_VARCHAR2_TABLE_200
2583     , p5_a49 JTF_NUMBER_TABLE
2584     , p5_a50 JTF_VARCHAR2_TABLE_200
2585     , p5_a51 JTF_NUMBER_TABLE
2586     , p5_a52 JTF_DATE_TABLE
2587     , p5_a53 JTF_NUMBER_TABLE
2588     , p5_a54 JTF_VARCHAR2_TABLE_200
2589     , p5_a55 JTF_VARCHAR2_TABLE_300
2590     , p5_a56 JTF_VARCHAR2_TABLE_100
2591     , p5_a57 JTF_VARCHAR2_TABLE_100
2592     , p6_a0 out nocopy JTF_NUMBER_TABLE
2593     , p6_a1 out nocopy JTF_NUMBER_TABLE
2594     , p6_a2 out nocopy JTF_NUMBER_TABLE
2595     , p6_a3 out nocopy JTF_NUMBER_TABLE
2596     , p6_a4 out nocopy JTF_NUMBER_TABLE
2597     , p6_a5 out nocopy JTF_NUMBER_TABLE
2598     , p6_a6 out nocopy JTF_NUMBER_TABLE
2599     , p6_a7 out nocopy JTF_NUMBER_TABLE
2600     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2601     , p6_a9 out nocopy JTF_NUMBER_TABLE
2602     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2603     , p6_a11 out nocopy JTF_NUMBER_TABLE
2604     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
2605     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
2606     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2607     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2608     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2609     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2610     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2611     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2612     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2613     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2614     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2615     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2616     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
2617     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
2618     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
2619     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
2620     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
2621     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
2622     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2623     , p6_a31 out nocopy JTF_NUMBER_TABLE
2624     , p6_a32 out nocopy JTF_DATE_TABLE
2625     , p6_a33 out nocopy JTF_NUMBER_TABLE
2626     , p6_a34 out nocopy JTF_DATE_TABLE
2627     , p6_a35 out nocopy JTF_NUMBER_TABLE
2628     , p6_a36 out nocopy JTF_NUMBER_TABLE
2629     , p6_a37 out nocopy JTF_NUMBER_TABLE
2630     , p6_a38 out nocopy JTF_NUMBER_TABLE
2631     , p6_a39 out nocopy JTF_DATE_TABLE
2632     , p6_a40 out nocopy JTF_NUMBER_TABLE
2633     , p6_a41 out nocopy JTF_NUMBER_TABLE
2634     , p6_a42 out nocopy JTF_NUMBER_TABLE
2635     , p6_a43 out nocopy JTF_NUMBER_TABLE
2636     , p6_a44 out nocopy JTF_NUMBER_TABLE
2637     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_100
2638     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_200
2639     , p6_a47 out nocopy JTF_NUMBER_TABLE
2640     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_200
2641     , p6_a49 out nocopy JTF_NUMBER_TABLE
2642     , p6_a50 out nocopy JTF_VARCHAR2_TABLE_200
2643     , p6_a51 out nocopy JTF_NUMBER_TABLE
2644     , p6_a52 out nocopy JTF_DATE_TABLE
2645     , p6_a53 out nocopy JTF_NUMBER_TABLE
2646     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_200
2647     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_300
2648     , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
2649     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
2650   );
2651   procedure update_trx_cntrct_lines(p_api_version  NUMBER
2652     , p_init_msg_list  VARCHAR2
2653     , x_return_status out nocopy  VARCHAR2
2654     , x_msg_count out nocopy  NUMBER
2655     , x_msg_data out nocopy  VARCHAR2
2656     , p6_a0 out nocopy  NUMBER
2657     , p6_a1 out nocopy  NUMBER
2658     , p6_a2 out nocopy  NUMBER
2659     , p6_a3 out nocopy  NUMBER
2660     , p6_a4 out nocopy  NUMBER
2661     , p6_a5 out nocopy  NUMBER
2662     , p6_a6 out nocopy  NUMBER
2663     , p6_a7 out nocopy  NUMBER
2664     , p6_a8 out nocopy  VARCHAR2
2665     , p6_a9 out nocopy  NUMBER
2666     , p6_a10 out nocopy  VARCHAR2
2667     , p6_a11 out nocopy  NUMBER
2668     , p6_a12 out nocopy  VARCHAR2
2669     , p6_a13 out nocopy  VARCHAR2
2670     , p6_a14 out nocopy  VARCHAR2
2671     , p6_a15 out nocopy  VARCHAR2
2672     , p6_a16 out nocopy  VARCHAR2
2673     , p6_a17 out nocopy  VARCHAR2
2674     , p6_a18 out nocopy  VARCHAR2
2675     , p6_a19 out nocopy  VARCHAR2
2676     , p6_a20 out nocopy  VARCHAR2
2677     , p6_a21 out nocopy  VARCHAR2
2678     , p6_a22 out nocopy  VARCHAR2
2679     , p6_a23 out nocopy  VARCHAR2
2680     , p6_a24 out nocopy  VARCHAR2
2681     , p6_a25 out nocopy  VARCHAR2
2682     , p6_a26 out nocopy  VARCHAR2
2683     , p6_a27 out nocopy  VARCHAR2
2684     , p6_a28 out nocopy  VARCHAR2
2685     , p6_a29 out nocopy  VARCHAR2
2686     , p6_a30 out nocopy  VARCHAR2
2687     , p6_a31 out nocopy  NUMBER
2688     , p6_a32 out nocopy  DATE
2689     , p6_a33 out nocopy  NUMBER
2690     , p6_a34 out nocopy  DATE
2691     , p6_a35 out nocopy  NUMBER
2692     , p6_a36 out nocopy  NUMBER
2693     , p6_a37 out nocopy  NUMBER
2694     , p6_a38 out nocopy  NUMBER
2695     , p6_a39 out nocopy  DATE
2696     , p6_a40 out nocopy  NUMBER
2697     , p6_a41 out nocopy  NUMBER
2698     , p6_a42 out nocopy  NUMBER
2699     , p6_a43 out nocopy  NUMBER
2700     , p6_a44 out nocopy  NUMBER
2701     , p6_a45 out nocopy  VARCHAR2
2702     , p6_a46 out nocopy  VARCHAR2
2703     , p6_a47 out nocopy  NUMBER
2704     , p6_a48 out nocopy  VARCHAR2
2705     , p6_a49 out nocopy  NUMBER
2706     , p6_a50 out nocopy  VARCHAR2
2707     , p6_a51 out nocopy  NUMBER
2708     , p6_a52 out nocopy  DATE
2709     , p6_a53 out nocopy  NUMBER
2710     , p6_a54 out nocopy  VARCHAR2
2711     , p6_a55 out nocopy  VARCHAR2
2712     , p6_a56 out nocopy  VARCHAR2
2713     , p6_a57 out nocopy  VARCHAR2
2714     , p5_a0  NUMBER := 0-1962.0724
2715     , p5_a1  NUMBER := 0-1962.0724
2716     , p5_a2  NUMBER := 0-1962.0724
2717     , p5_a3  NUMBER := 0-1962.0724
2718     , p5_a4  NUMBER := 0-1962.0724
2719     , p5_a5  NUMBER := 0-1962.0724
2720     , p5_a6  NUMBER := 0-1962.0724
2721     , p5_a7  NUMBER := 0-1962.0724
2722     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2723     , p5_a9  NUMBER := 0-1962.0724
2724     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2725     , p5_a11  NUMBER := 0-1962.0724
2726     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2727     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2728     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2729     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2730     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2731     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2732     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2733     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2734     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2735     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2736     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2737     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2738     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2739     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2740     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2741     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2742     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2743     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2744     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
2745     , p5_a31  NUMBER := 0-1962.0724
2746     , p5_a32  DATE := fnd_api.g_miss_date
2747     , p5_a33  NUMBER := 0-1962.0724
2748     , p5_a34  DATE := fnd_api.g_miss_date
2749     , p5_a35  NUMBER := 0-1962.0724
2750     , p5_a36  NUMBER := 0-1962.0724
2751     , p5_a37  NUMBER := 0-1962.0724
2752     , p5_a38  NUMBER := 0-1962.0724
2753     , p5_a39  DATE := fnd_api.g_miss_date
2754     , p5_a40  NUMBER := 0-1962.0724
2755     , p5_a41  NUMBER := 0-1962.0724
2756     , p5_a42  NUMBER := 0-1962.0724
2757     , p5_a43  NUMBER := 0-1962.0724
2758     , p5_a44  NUMBER := 0-1962.0724
2759     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2760     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2761     , p5_a47  NUMBER := 0-1962.0724
2762     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2763     , p5_a49  NUMBER := 0-1962.0724
2764     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2765     , p5_a51  NUMBER := 0-1962.0724
2766     , p5_a52  DATE := fnd_api.g_miss_date
2767     , p5_a53  NUMBER := 0-1962.0724
2768     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
2769     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
2770     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
2771     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
2772   );
2773   procedure delete_trx_cntrct_lines(p_api_version  NUMBER
2774     , p_init_msg_list  VARCHAR2
2775     , x_return_status out nocopy  VARCHAR2
2776     , x_msg_count out nocopy  NUMBER
2777     , x_msg_data out nocopy  VARCHAR2
2778     , p5_a0 JTF_NUMBER_TABLE
2779     , p5_a1 JTF_NUMBER_TABLE
2780     , p5_a2 JTF_NUMBER_TABLE
2781     , p5_a3 JTF_NUMBER_TABLE
2782     , p5_a4 JTF_NUMBER_TABLE
2783     , p5_a5 JTF_NUMBER_TABLE
2784     , p5_a6 JTF_NUMBER_TABLE
2785     , p5_a7 JTF_NUMBER_TABLE
2786     , p5_a8 JTF_VARCHAR2_TABLE_100
2787     , p5_a9 JTF_NUMBER_TABLE
2788     , p5_a10 JTF_VARCHAR2_TABLE_2000
2789     , p5_a11 JTF_NUMBER_TABLE
2790     , p5_a12 JTF_VARCHAR2_TABLE_200
2791     , p5_a13 JTF_VARCHAR2_TABLE_100
2792     , p5_a14 JTF_VARCHAR2_TABLE_100
2793     , p5_a15 JTF_VARCHAR2_TABLE_500
2794     , p5_a16 JTF_VARCHAR2_TABLE_500
2795     , p5_a17 JTF_VARCHAR2_TABLE_500
2796     , p5_a18 JTF_VARCHAR2_TABLE_500
2797     , p5_a19 JTF_VARCHAR2_TABLE_500
2798     , p5_a20 JTF_VARCHAR2_TABLE_500
2799     , p5_a21 JTF_VARCHAR2_TABLE_500
2800     , p5_a22 JTF_VARCHAR2_TABLE_500
2801     , p5_a23 JTF_VARCHAR2_TABLE_500
2802     , p5_a24 JTF_VARCHAR2_TABLE_500
2803     , p5_a25 JTF_VARCHAR2_TABLE_500
2804     , p5_a26 JTF_VARCHAR2_TABLE_500
2805     , p5_a27 JTF_VARCHAR2_TABLE_500
2806     , p5_a28 JTF_VARCHAR2_TABLE_500
2807     , p5_a29 JTF_VARCHAR2_TABLE_500
2808     , p5_a30 JTF_VARCHAR2_TABLE_100
2809     , p5_a31 JTF_NUMBER_TABLE
2810     , p5_a32 JTF_DATE_TABLE
2811     , p5_a33 JTF_NUMBER_TABLE
2812     , p5_a34 JTF_DATE_TABLE
2813     , p5_a35 JTF_NUMBER_TABLE
2814     , p5_a36 JTF_NUMBER_TABLE
2815     , p5_a37 JTF_NUMBER_TABLE
2816     , p5_a38 JTF_NUMBER_TABLE
2817     , p5_a39 JTF_DATE_TABLE
2818     , p5_a40 JTF_NUMBER_TABLE
2819     , p5_a41 JTF_NUMBER_TABLE
2820     , p5_a42 JTF_NUMBER_TABLE
2821     , p5_a43 JTF_NUMBER_TABLE
2822     , p5_a44 JTF_NUMBER_TABLE
2823     , p5_a45 JTF_VARCHAR2_TABLE_100
2824     , p5_a46 JTF_VARCHAR2_TABLE_200
2825     , p5_a47 JTF_NUMBER_TABLE
2826     , p5_a48 JTF_VARCHAR2_TABLE_200
2827     , p5_a49 JTF_NUMBER_TABLE
2828     , p5_a50 JTF_VARCHAR2_TABLE_200
2829     , p5_a51 JTF_NUMBER_TABLE
2830     , p5_a52 JTF_DATE_TABLE
2831     , p5_a53 JTF_NUMBER_TABLE
2832     , p5_a54 JTF_VARCHAR2_TABLE_200
2833     , p5_a55 JTF_VARCHAR2_TABLE_300
2834     , p5_a56 JTF_VARCHAR2_TABLE_100
2835     , p5_a57 JTF_VARCHAR2_TABLE_100
2836   );
2837   procedure delete_trx_cntrct_lines(p_api_version  NUMBER
2838     , p_init_msg_list  VARCHAR2
2839     , x_return_status out nocopy  VARCHAR2
2840     , x_msg_count out nocopy  NUMBER
2841     , x_msg_data out nocopy  VARCHAR2
2842     , p5_a0  NUMBER := 0-1962.0724
2843     , p5_a1  NUMBER := 0-1962.0724
2844     , p5_a2  NUMBER := 0-1962.0724
2845     , p5_a3  NUMBER := 0-1962.0724
2846     , p5_a4  NUMBER := 0-1962.0724
2847     , p5_a5  NUMBER := 0-1962.0724
2848     , p5_a6  NUMBER := 0-1962.0724
2849     , p5_a7  NUMBER := 0-1962.0724
2850     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2851     , p5_a9  NUMBER := 0-1962.0724
2852     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2853     , p5_a11  NUMBER := 0-1962.0724
2854     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2855     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2856     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2857     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2858     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2859     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2860     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2861     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2862     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2863     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2864     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2865     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2866     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2867     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2868     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2869     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2870     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2871     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2872     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
2873     , p5_a31  NUMBER := 0-1962.0724
2874     , p5_a32  DATE := fnd_api.g_miss_date
2875     , p5_a33  NUMBER := 0-1962.0724
2876     , p5_a34  DATE := fnd_api.g_miss_date
2877     , p5_a35  NUMBER := 0-1962.0724
2878     , p5_a36  NUMBER := 0-1962.0724
2879     , p5_a37  NUMBER := 0-1962.0724
2880     , p5_a38  NUMBER := 0-1962.0724
2881     , p5_a39  DATE := fnd_api.g_miss_date
2882     , p5_a40  NUMBER := 0-1962.0724
2883     , p5_a41  NUMBER := 0-1962.0724
2884     , p5_a42  NUMBER := 0-1962.0724
2885     , p5_a43  NUMBER := 0-1962.0724
2886     , p5_a44  NUMBER := 0-1962.0724
2887     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2888     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2889     , p5_a47  NUMBER := 0-1962.0724
2890     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2891     , p5_a49  NUMBER := 0-1962.0724
2892     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2893     , p5_a51  NUMBER := 0-1962.0724
2894     , p5_a52  DATE := fnd_api.g_miss_date
2895     , p5_a53  NUMBER := 0-1962.0724
2896     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
2897     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
2898     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
2899     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
2900   );
2901   procedure validate_trx_cntrct_lines(p_api_version  NUMBER
2902     , p_init_msg_list  VARCHAR2
2903     , x_return_status out nocopy  VARCHAR2
2904     , x_msg_count out nocopy  NUMBER
2905     , x_msg_data out nocopy  VARCHAR2
2906     , p5_a0 JTF_NUMBER_TABLE
2907     , p5_a1 JTF_NUMBER_TABLE
2908     , p5_a2 JTF_NUMBER_TABLE
2909     , p5_a3 JTF_NUMBER_TABLE
2910     , p5_a4 JTF_NUMBER_TABLE
2911     , p5_a5 JTF_NUMBER_TABLE
2912     , p5_a6 JTF_NUMBER_TABLE
2913     , p5_a7 JTF_NUMBER_TABLE
2914     , p5_a8 JTF_VARCHAR2_TABLE_100
2915     , p5_a9 JTF_NUMBER_TABLE
2916     , p5_a10 JTF_VARCHAR2_TABLE_2000
2917     , p5_a11 JTF_NUMBER_TABLE
2918     , p5_a12 JTF_VARCHAR2_TABLE_200
2919     , p5_a13 JTF_VARCHAR2_TABLE_100
2920     , p5_a14 JTF_VARCHAR2_TABLE_100
2921     , p5_a15 JTF_VARCHAR2_TABLE_500
2922     , p5_a16 JTF_VARCHAR2_TABLE_500
2923     , p5_a17 JTF_VARCHAR2_TABLE_500
2924     , p5_a18 JTF_VARCHAR2_TABLE_500
2925     , p5_a19 JTF_VARCHAR2_TABLE_500
2926     , p5_a20 JTF_VARCHAR2_TABLE_500
2927     , p5_a21 JTF_VARCHAR2_TABLE_500
2928     , p5_a22 JTF_VARCHAR2_TABLE_500
2929     , p5_a23 JTF_VARCHAR2_TABLE_500
2930     , p5_a24 JTF_VARCHAR2_TABLE_500
2931     , p5_a25 JTF_VARCHAR2_TABLE_500
2932     , p5_a26 JTF_VARCHAR2_TABLE_500
2933     , p5_a27 JTF_VARCHAR2_TABLE_500
2934     , p5_a28 JTF_VARCHAR2_TABLE_500
2935     , p5_a29 JTF_VARCHAR2_TABLE_500
2936     , p5_a30 JTF_VARCHAR2_TABLE_100
2937     , p5_a31 JTF_NUMBER_TABLE
2938     , p5_a32 JTF_DATE_TABLE
2939     , p5_a33 JTF_NUMBER_TABLE
2940     , p5_a34 JTF_DATE_TABLE
2941     , p5_a35 JTF_NUMBER_TABLE
2942     , p5_a36 JTF_NUMBER_TABLE
2943     , p5_a37 JTF_NUMBER_TABLE
2944     , p5_a38 JTF_NUMBER_TABLE
2945     , p5_a39 JTF_DATE_TABLE
2946     , p5_a40 JTF_NUMBER_TABLE
2947     , p5_a41 JTF_NUMBER_TABLE
2948     , p5_a42 JTF_NUMBER_TABLE
2949     , p5_a43 JTF_NUMBER_TABLE
2950     , p5_a44 JTF_NUMBER_TABLE
2951     , p5_a45 JTF_VARCHAR2_TABLE_100
2952     , p5_a46 JTF_VARCHAR2_TABLE_200
2953     , p5_a47 JTF_NUMBER_TABLE
2954     , p5_a48 JTF_VARCHAR2_TABLE_200
2955     , p5_a49 JTF_NUMBER_TABLE
2956     , p5_a50 JTF_VARCHAR2_TABLE_200
2957     , p5_a51 JTF_NUMBER_TABLE
2958     , p5_a52 JTF_DATE_TABLE
2959     , p5_a53 JTF_NUMBER_TABLE
2960     , p5_a54 JTF_VARCHAR2_TABLE_200
2961     , p5_a55 JTF_VARCHAR2_TABLE_300
2962     , p5_a56 JTF_VARCHAR2_TABLE_100
2963     , p5_a57 JTF_VARCHAR2_TABLE_100
2964   );
2965   procedure validate_trx_cntrct_lines(p_api_version  NUMBER
2966     , p_init_msg_list  VARCHAR2
2967     , x_return_status out nocopy  VARCHAR2
2968     , x_msg_count out nocopy  NUMBER
2969     , x_msg_data out nocopy  VARCHAR2
2970     , p5_a0  NUMBER := 0-1962.0724
2971     , p5_a1  NUMBER := 0-1962.0724
2972     , p5_a2  NUMBER := 0-1962.0724
2973     , p5_a3  NUMBER := 0-1962.0724
2974     , p5_a4  NUMBER := 0-1962.0724
2975     , p5_a5  NUMBER := 0-1962.0724
2976     , p5_a6  NUMBER := 0-1962.0724
2977     , p5_a7  NUMBER := 0-1962.0724
2978     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2979     , p5_a9  NUMBER := 0-1962.0724
2980     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2981     , p5_a11  NUMBER := 0-1962.0724
2982     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2983     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2984     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2985     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2986     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2987     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2988     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
2989     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
2990     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
2991     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
2992     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2993     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2994     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2995     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2996     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2997     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2998     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
2999     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
3000     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
3001     , p5_a31  NUMBER := 0-1962.0724
3002     , p5_a32  DATE := fnd_api.g_miss_date
3003     , p5_a33  NUMBER := 0-1962.0724
3004     , p5_a34  DATE := fnd_api.g_miss_date
3005     , p5_a35  NUMBER := 0-1962.0724
3006     , p5_a36  NUMBER := 0-1962.0724
3007     , p5_a37  NUMBER := 0-1962.0724
3008     , p5_a38  NUMBER := 0-1962.0724
3009     , p5_a39  DATE := fnd_api.g_miss_date
3010     , p5_a40  NUMBER := 0-1962.0724
3011     , p5_a41  NUMBER := 0-1962.0724
3012     , p5_a42  NUMBER := 0-1962.0724
3013     , p5_a43  NUMBER := 0-1962.0724
3014     , p5_a44  NUMBER := 0-1962.0724
3015     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
3016     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
3017     , p5_a47  NUMBER := 0-1962.0724
3018     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
3019     , p5_a49  NUMBER := 0-1962.0724
3020     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
3021     , p5_a51  NUMBER := 0-1962.0724
3022     , p5_a52  DATE := fnd_api.g_miss_date
3023     , p5_a53  NUMBER := 0-1962.0724
3024     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
3025     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
3026     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
3027     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
3028   );
3029 end okl_trx_contracts_pub_w;