DBA Data[Home] [Help]

PACKAGE: APPS.OKL_OKC_MIGRATION_PVT_W

Source


1 package okl_okc_migration_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLEOKCS.pls 115.5 2003/10/16 09:59:10 avsingh noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy okl_okc_migration_pvt.cvmv_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_DATE_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_NUMBER_TABLE
12     );
13   procedure rosetta_table_copy_out_p1(t okl_okc_migration_pvt.cvmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14     , a1 out nocopy JTF_NUMBER_TABLE
15     , a2 out nocopy JTF_NUMBER_TABLE
16     , a3 out nocopy JTF_NUMBER_TABLE
17     , a4 out nocopy JTF_NUMBER_TABLE
18     , a5 out nocopy JTF_DATE_TABLE
19     , a6 out nocopy JTF_NUMBER_TABLE
20     , a7 out nocopy JTF_DATE_TABLE
21     , a8 out nocopy JTF_NUMBER_TABLE
22     );
23 
24   procedure rosetta_table_copy_in_p3(t out nocopy okl_okc_migration_pvt.chrv_tbl_type, a0 JTF_NUMBER_TABLE
25     , a1 JTF_NUMBER_TABLE
26     , a2 JTF_VARCHAR2_TABLE_100
27     , a3 JTF_NUMBER_TABLE
28     , a4 JTF_NUMBER_TABLE
29     , a5 JTF_NUMBER_TABLE
30     , a6 JTF_NUMBER_TABLE
31     , a7 JTF_VARCHAR2_TABLE_100
32     , a8 JTF_NUMBER_TABLE
33     , a9 JTF_VARCHAR2_TABLE_100
34     , a10 JTF_VARCHAR2_TABLE_200
35     , a11 JTF_VARCHAR2_TABLE_100
36     , a12 JTF_VARCHAR2_TABLE_200
37     , a13 JTF_VARCHAR2_TABLE_100
38     , a14 JTF_VARCHAR2_TABLE_100
39     , a15 JTF_VARCHAR2_TABLE_100
40     , a16 JTF_VARCHAR2_TABLE_100
41     , a17 JTF_VARCHAR2_TABLE_200
42     , a18 JTF_VARCHAR2_TABLE_600
43     , a19 JTF_VARCHAR2_TABLE_2000
44     , a20 JTF_VARCHAR2_TABLE_2000
45     , a21 JTF_VARCHAR2_TABLE_100
46     , a22 JTF_VARCHAR2_TABLE_300
47     , a23 JTF_VARCHAR2_TABLE_100
48     , a24 JTF_VARCHAR2_TABLE_200
49     , a25 JTF_DATE_TABLE
50     , a26 JTF_DATE_TABLE
51     , a27 JTF_NUMBER_TABLE
52     , a28 JTF_DATE_TABLE
53     , a29 JTF_DATE_TABLE
54     , a30 JTF_VARCHAR2_TABLE_100
55     , a31 JTF_VARCHAR2_TABLE_2000
56     , a32 JTF_VARCHAR2_TABLE_100
57     , a33 JTF_VARCHAR2_TABLE_100
58     , a34 JTF_VARCHAR2_TABLE_100
59     , a35 JTF_VARCHAR2_TABLE_100
60     , a36 JTF_NUMBER_TABLE
61     , a37 JTF_NUMBER_TABLE
62     , a38 JTF_DATE_TABLE
63     , a39 JTF_DATE_TABLE
64     , a40 JTF_DATE_TABLE
65     , a41 JTF_DATE_TABLE
66     , a42 JTF_DATE_TABLE
67     , a43 JTF_VARCHAR2_TABLE_100
68     , a44 JTF_DATE_TABLE
69     , a45 JTF_DATE_TABLE
70     , a46 JTF_NUMBER_TABLE
71     , a47 JTF_VARCHAR2_TABLE_100
72     , a48 JTF_VARCHAR2_TABLE_100
73     , a49 JTF_NUMBER_TABLE
74     , a50 JTF_NUMBER_TABLE
75     , a51 JTF_NUMBER_TABLE
76     , a52 JTF_VARCHAR2_TABLE_100
77     , a53 JTF_VARCHAR2_TABLE_100
78     , a54 JTF_NUMBER_TABLE
79     , a55 JTF_NUMBER_TABLE
80     , a56 JTF_VARCHAR2_TABLE_100
81     , a57 JTF_NUMBER_TABLE
82     , a58 JTF_VARCHAR2_TABLE_100
83     , a59 JTF_NUMBER_TABLE
84     , a60 JTF_NUMBER_TABLE
85     , a61 JTF_NUMBER_TABLE
86     , a62 JTF_DATE_TABLE
87     , a63 JTF_DATE_TABLE
88     , a64 JTF_DATE_TABLE
89     , a65 JTF_NUMBER_TABLE
90     , a66 JTF_NUMBER_TABLE
91     , a67 JTF_NUMBER_TABLE
92     , a68 JTF_VARCHAR2_TABLE_100
93     , a69 JTF_VARCHAR2_TABLE_500
94     , a70 JTF_VARCHAR2_TABLE_500
95     , a71 JTF_VARCHAR2_TABLE_500
96     , a72 JTF_VARCHAR2_TABLE_500
97     , a73 JTF_VARCHAR2_TABLE_500
98     , a74 JTF_VARCHAR2_TABLE_500
99     , a75 JTF_VARCHAR2_TABLE_500
100     , a76 JTF_VARCHAR2_TABLE_500
101     , a77 JTF_VARCHAR2_TABLE_500
102     , a78 JTF_VARCHAR2_TABLE_500
103     , a79 JTF_VARCHAR2_TABLE_500
104     , a80 JTF_VARCHAR2_TABLE_500
105     , a81 JTF_VARCHAR2_TABLE_500
106     , a82 JTF_VARCHAR2_TABLE_500
107     , a83 JTF_VARCHAR2_TABLE_500
108     , a84 JTF_NUMBER_TABLE
109     , a85 JTF_DATE_TABLE
110     , a86 JTF_NUMBER_TABLE
111     , a87 JTF_DATE_TABLE
112     , a88 JTF_NUMBER_TABLE
113     , a89 JTF_VARCHAR2_TABLE_100
114     , a90 JTF_VARCHAR2_TABLE_100
115     , a91 JTF_VARCHAR2_TABLE_100
116     , a92 JTF_VARCHAR2_TABLE_100
117     , a93 JTF_VARCHAR2_TABLE_100
118     , a94 JTF_NUMBER_TABLE
119     , a95 JTF_DATE_TABLE
120     , a96 JTF_NUMBER_TABLE
121     , a97 JTF_NUMBER_TABLE
122     , a98 JTF_NUMBER_TABLE
123     , a99 JTF_NUMBER_TABLE
124     , a100 JTF_VARCHAR2_TABLE_100
125     , a101 JTF_NUMBER_TABLE
126     , a102 JTF_DATE_TABLE
127     , a103 JTF_NUMBER_TABLE
128     , a104 JTF_NUMBER_TABLE
129     );
130   procedure rosetta_table_copy_out_p3(t okl_okc_migration_pvt.chrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131     , a1 out nocopy JTF_NUMBER_TABLE
132     , a2 out nocopy JTF_VARCHAR2_TABLE_100
133     , a3 out nocopy JTF_NUMBER_TABLE
134     , a4 out nocopy JTF_NUMBER_TABLE
135     , a5 out nocopy JTF_NUMBER_TABLE
136     , a6 out nocopy JTF_NUMBER_TABLE
137     , a7 out nocopy JTF_VARCHAR2_TABLE_100
138     , a8 out nocopy JTF_NUMBER_TABLE
139     , a9 out nocopy JTF_VARCHAR2_TABLE_100
140     , a10 out nocopy JTF_VARCHAR2_TABLE_200
141     , a11 out nocopy JTF_VARCHAR2_TABLE_100
142     , a12 out nocopy JTF_VARCHAR2_TABLE_200
143     , a13 out nocopy JTF_VARCHAR2_TABLE_100
144     , a14 out nocopy JTF_VARCHAR2_TABLE_100
145     , a15 out nocopy JTF_VARCHAR2_TABLE_100
146     , a16 out nocopy JTF_VARCHAR2_TABLE_100
147     , a17 out nocopy JTF_VARCHAR2_TABLE_200
148     , a18 out nocopy JTF_VARCHAR2_TABLE_600
149     , a19 out nocopy JTF_VARCHAR2_TABLE_2000
150     , a20 out nocopy JTF_VARCHAR2_TABLE_2000
151     , a21 out nocopy JTF_VARCHAR2_TABLE_100
152     , a22 out nocopy JTF_VARCHAR2_TABLE_300
153     , a23 out nocopy JTF_VARCHAR2_TABLE_100
154     , a24 out nocopy JTF_VARCHAR2_TABLE_200
155     , a25 out nocopy JTF_DATE_TABLE
156     , a26 out nocopy JTF_DATE_TABLE
157     , a27 out nocopy JTF_NUMBER_TABLE
158     , a28 out nocopy JTF_DATE_TABLE
159     , a29 out nocopy JTF_DATE_TABLE
160     , a30 out nocopy JTF_VARCHAR2_TABLE_100
161     , a31 out nocopy JTF_VARCHAR2_TABLE_2000
162     , a32 out nocopy JTF_VARCHAR2_TABLE_100
163     , a33 out nocopy JTF_VARCHAR2_TABLE_100
164     , a34 out nocopy JTF_VARCHAR2_TABLE_100
165     , a35 out nocopy JTF_VARCHAR2_TABLE_100
166     , a36 out nocopy JTF_NUMBER_TABLE
167     , a37 out nocopy JTF_NUMBER_TABLE
168     , a38 out nocopy JTF_DATE_TABLE
169     , a39 out nocopy JTF_DATE_TABLE
170     , a40 out nocopy JTF_DATE_TABLE
171     , a41 out nocopy JTF_DATE_TABLE
172     , a42 out nocopy JTF_DATE_TABLE
173     , a43 out nocopy JTF_VARCHAR2_TABLE_100
174     , a44 out nocopy JTF_DATE_TABLE
175     , a45 out nocopy JTF_DATE_TABLE
176     , a46 out nocopy JTF_NUMBER_TABLE
177     , a47 out nocopy JTF_VARCHAR2_TABLE_100
178     , a48 out nocopy JTF_VARCHAR2_TABLE_100
179     , a49 out nocopy JTF_NUMBER_TABLE
180     , a50 out nocopy JTF_NUMBER_TABLE
181     , a51 out nocopy JTF_NUMBER_TABLE
182     , a52 out nocopy JTF_VARCHAR2_TABLE_100
183     , a53 out nocopy JTF_VARCHAR2_TABLE_100
184     , a54 out nocopy JTF_NUMBER_TABLE
185     , a55 out nocopy JTF_NUMBER_TABLE
186     , a56 out nocopy JTF_VARCHAR2_TABLE_100
187     , a57 out nocopy JTF_NUMBER_TABLE
188     , a58 out nocopy JTF_VARCHAR2_TABLE_100
189     , a59 out nocopy JTF_NUMBER_TABLE
190     , a60 out nocopy JTF_NUMBER_TABLE
191     , a61 out nocopy JTF_NUMBER_TABLE
192     , a62 out nocopy JTF_DATE_TABLE
193     , a63 out nocopy JTF_DATE_TABLE
194     , a64 out nocopy JTF_DATE_TABLE
195     , a65 out nocopy JTF_NUMBER_TABLE
196     , a66 out nocopy JTF_NUMBER_TABLE
197     , a67 out nocopy JTF_NUMBER_TABLE
198     , a68 out nocopy JTF_VARCHAR2_TABLE_100
199     , a69 out nocopy JTF_VARCHAR2_TABLE_500
200     , a70 out nocopy JTF_VARCHAR2_TABLE_500
201     , a71 out nocopy JTF_VARCHAR2_TABLE_500
202     , a72 out nocopy JTF_VARCHAR2_TABLE_500
203     , a73 out nocopy JTF_VARCHAR2_TABLE_500
204     , a74 out nocopy JTF_VARCHAR2_TABLE_500
205     , a75 out nocopy JTF_VARCHAR2_TABLE_500
206     , a76 out nocopy JTF_VARCHAR2_TABLE_500
207     , a77 out nocopy JTF_VARCHAR2_TABLE_500
208     , a78 out nocopy JTF_VARCHAR2_TABLE_500
209     , a79 out nocopy JTF_VARCHAR2_TABLE_500
210     , a80 out nocopy JTF_VARCHAR2_TABLE_500
211     , a81 out nocopy JTF_VARCHAR2_TABLE_500
212     , a82 out nocopy JTF_VARCHAR2_TABLE_500
213     , a83 out nocopy JTF_VARCHAR2_TABLE_500
214     , a84 out nocopy JTF_NUMBER_TABLE
215     , a85 out nocopy JTF_DATE_TABLE
216     , a86 out nocopy JTF_NUMBER_TABLE
217     , a87 out nocopy JTF_DATE_TABLE
218     , a88 out nocopy JTF_NUMBER_TABLE
219     , a89 out nocopy JTF_VARCHAR2_TABLE_100
220     , a90 out nocopy JTF_VARCHAR2_TABLE_100
221     , a91 out nocopy JTF_VARCHAR2_TABLE_100
222     , a92 out nocopy JTF_VARCHAR2_TABLE_100
223     , a93 out nocopy JTF_VARCHAR2_TABLE_100
224     , a94 out nocopy JTF_NUMBER_TABLE
225     , a95 out nocopy JTF_DATE_TABLE
226     , a96 out nocopy JTF_NUMBER_TABLE
227     , a97 out nocopy JTF_NUMBER_TABLE
228     , a98 out nocopy JTF_NUMBER_TABLE
229     , a99 out nocopy JTF_NUMBER_TABLE
230     , a100 out nocopy JTF_VARCHAR2_TABLE_100
231     , a101 out nocopy JTF_NUMBER_TABLE
232     , a102 out nocopy JTF_DATE_TABLE
233     , a103 out nocopy JTF_NUMBER_TABLE
234     , a104 out nocopy JTF_NUMBER_TABLE
235     );
236 
237   procedure rosetta_table_copy_in_p5(t out nocopy okl_okc_migration_pvt.clev_tbl_type, a0 JTF_NUMBER_TABLE
238     , a1 JTF_NUMBER_TABLE
239     , a2 JTF_VARCHAR2_TABLE_100
240     , a3 JTF_NUMBER_TABLE
241     , a4 JTF_NUMBER_TABLE
242     , a5 JTF_NUMBER_TABLE
243     , a6 JTF_NUMBER_TABLE
244     , a7 JTF_NUMBER_TABLE
245     , a8 JTF_VARCHAR2_TABLE_200
246     , a9 JTF_VARCHAR2_TABLE_100
247     , a10 JTF_NUMBER_TABLE
248     , a11 JTF_VARCHAR2_TABLE_100
249     , a12 JTF_NUMBER_TABLE
250     , a13 JTF_VARCHAR2_TABLE_2000
251     , a14 JTF_VARCHAR2_TABLE_2000
252     , a15 JTF_VARCHAR2_TABLE_2000
253     , a16 JTF_VARCHAR2_TABLE_300
254     , a17 JTF_VARCHAR2_TABLE_100
255     , a18 JTF_NUMBER_TABLE
256     , a19 JTF_NUMBER_TABLE
257     , a20 JTF_NUMBER_TABLE
258     , a21 JTF_NUMBER_TABLE
259     , a22 JTF_VARCHAR2_TABLE_100
260     , a23 JTF_VARCHAR2_TABLE_100
261     , a24 JTF_VARCHAR2_TABLE_100
262     , a25 JTF_VARCHAR2_TABLE_2000
263     , a26 JTF_VARCHAR2_TABLE_100
264     , a27 JTF_VARCHAR2_TABLE_200
265     , a28 JTF_DATE_TABLE
266     , a29 JTF_VARCHAR2_TABLE_200
267     , a30 JTF_DATE_TABLE
268     , a31 JTF_DATE_TABLE
269     , a32 JTF_DATE_TABLE
270     , a33 JTF_VARCHAR2_TABLE_100
271     , a34 JTF_NUMBER_TABLE
272     , a35 JTF_VARCHAR2_TABLE_100
273     , a36 JTF_NUMBER_TABLE
274     , a37 JTF_VARCHAR2_TABLE_100
275     , a38 JTF_VARCHAR2_TABLE_100
276     , a39 JTF_VARCHAR2_TABLE_500
277     , a40 JTF_VARCHAR2_TABLE_500
278     , a41 JTF_VARCHAR2_TABLE_500
279     , a42 JTF_VARCHAR2_TABLE_500
280     , a43 JTF_VARCHAR2_TABLE_500
281     , a44 JTF_VARCHAR2_TABLE_500
282     , a45 JTF_VARCHAR2_TABLE_500
283     , a46 JTF_VARCHAR2_TABLE_500
284     , a47 JTF_VARCHAR2_TABLE_500
285     , a48 JTF_VARCHAR2_TABLE_500
286     , a49 JTF_VARCHAR2_TABLE_500
287     , a50 JTF_VARCHAR2_TABLE_500
288     , a51 JTF_VARCHAR2_TABLE_500
289     , a52 JTF_VARCHAR2_TABLE_500
290     , a53 JTF_VARCHAR2_TABLE_500
291     , a54 JTF_NUMBER_TABLE
292     , a55 JTF_DATE_TABLE
293     , a56 JTF_NUMBER_TABLE
294     , a57 JTF_DATE_TABLE
295     , a58 JTF_VARCHAR2_TABLE_100
296     , a59 JTF_VARCHAR2_TABLE_100
297     , a60 JTF_VARCHAR2_TABLE_100
298     , a61 JTF_NUMBER_TABLE
299     , a62 JTF_VARCHAR2_TABLE_100
300     , a63 JTF_VARCHAR2_TABLE_100
301     , a64 JTF_VARCHAR2_TABLE_100
302     , a65 JTF_VARCHAR2_TABLE_100
303     , a66 JTF_VARCHAR2_TABLE_100
304     , a67 JTF_NUMBER_TABLE
305     , a68 JTF_NUMBER_TABLE
306     , a69 JTF_NUMBER_TABLE
307     , a70 JTF_DATE_TABLE
308     , a71 JTF_NUMBER_TABLE
309     , a72 JTF_DATE_TABLE
310     , a73 JTF_NUMBER_TABLE
311     , a74 JTF_NUMBER_TABLE
312     , a75 JTF_VARCHAR2_TABLE_100
313     , a76 JTF_VARCHAR2_TABLE_100
314     , a77 JTF_NUMBER_TABLE
315     , a78 JTF_NUMBER_TABLE
316     , a79 JTF_VARCHAR2_TABLE_100
317     , a80 JTF_VARCHAR2_TABLE_100
318     , a81 JTF_NUMBER_TABLE
319     , a82 JTF_VARCHAR2_TABLE_100
320     , a83 JTF_NUMBER_TABLE
321     , a84 JTF_NUMBER_TABLE
322     , a85 JTF_NUMBER_TABLE
323     , a86 JTF_NUMBER_TABLE
324     , a87 JTF_VARCHAR2_TABLE_100
325     , a88 JTF_NUMBER_TABLE
326     , a89 JTF_NUMBER_TABLE
327     );
328   procedure rosetta_table_copy_out_p5(t okl_okc_migration_pvt.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
329     , a1 out nocopy JTF_NUMBER_TABLE
330     , a2 out nocopy JTF_VARCHAR2_TABLE_100
331     , a3 out nocopy JTF_NUMBER_TABLE
332     , a4 out nocopy JTF_NUMBER_TABLE
333     , a5 out nocopy JTF_NUMBER_TABLE
334     , a6 out nocopy JTF_NUMBER_TABLE
335     , a7 out nocopy JTF_NUMBER_TABLE
336     , a8 out nocopy JTF_VARCHAR2_TABLE_200
337     , a9 out nocopy JTF_VARCHAR2_TABLE_100
338     , a10 out nocopy JTF_NUMBER_TABLE
339     , a11 out nocopy JTF_VARCHAR2_TABLE_100
340     , a12 out nocopy JTF_NUMBER_TABLE
341     , a13 out nocopy JTF_VARCHAR2_TABLE_2000
342     , a14 out nocopy JTF_VARCHAR2_TABLE_2000
343     , a15 out nocopy JTF_VARCHAR2_TABLE_2000
344     , a16 out nocopy JTF_VARCHAR2_TABLE_300
345     , a17 out nocopy JTF_VARCHAR2_TABLE_100
346     , a18 out nocopy JTF_NUMBER_TABLE
347     , a19 out nocopy JTF_NUMBER_TABLE
348     , a20 out nocopy JTF_NUMBER_TABLE
349     , a21 out nocopy JTF_NUMBER_TABLE
350     , a22 out nocopy JTF_VARCHAR2_TABLE_100
351     , a23 out nocopy JTF_VARCHAR2_TABLE_100
352     , a24 out nocopy JTF_VARCHAR2_TABLE_100
353     , a25 out nocopy JTF_VARCHAR2_TABLE_2000
354     , a26 out nocopy JTF_VARCHAR2_TABLE_100
355     , a27 out nocopy JTF_VARCHAR2_TABLE_200
356     , a28 out nocopy JTF_DATE_TABLE
357     , a29 out nocopy JTF_VARCHAR2_TABLE_200
358     , a30 out nocopy JTF_DATE_TABLE
359     , a31 out nocopy JTF_DATE_TABLE
360     , a32 out nocopy JTF_DATE_TABLE
361     , a33 out nocopy JTF_VARCHAR2_TABLE_100
362     , a34 out nocopy JTF_NUMBER_TABLE
363     , a35 out nocopy JTF_VARCHAR2_TABLE_100
364     , a36 out nocopy JTF_NUMBER_TABLE
365     , a37 out nocopy JTF_VARCHAR2_TABLE_100
366     , a38 out nocopy JTF_VARCHAR2_TABLE_100
367     , a39 out nocopy JTF_VARCHAR2_TABLE_500
368     , a40 out nocopy JTF_VARCHAR2_TABLE_500
369     , a41 out nocopy JTF_VARCHAR2_TABLE_500
370     , a42 out nocopy JTF_VARCHAR2_TABLE_500
371     , a43 out nocopy JTF_VARCHAR2_TABLE_500
372     , a44 out nocopy JTF_VARCHAR2_TABLE_500
373     , a45 out nocopy JTF_VARCHAR2_TABLE_500
374     , a46 out nocopy JTF_VARCHAR2_TABLE_500
375     , a47 out nocopy JTF_VARCHAR2_TABLE_500
376     , a48 out nocopy JTF_VARCHAR2_TABLE_500
377     , a49 out nocopy JTF_VARCHAR2_TABLE_500
378     , a50 out nocopy JTF_VARCHAR2_TABLE_500
379     , a51 out nocopy JTF_VARCHAR2_TABLE_500
380     , a52 out nocopy JTF_VARCHAR2_TABLE_500
381     , a53 out nocopy JTF_VARCHAR2_TABLE_500
382     , a54 out nocopy JTF_NUMBER_TABLE
383     , a55 out nocopy JTF_DATE_TABLE
384     , a56 out nocopy JTF_NUMBER_TABLE
385     , a57 out nocopy JTF_DATE_TABLE
386     , a58 out nocopy JTF_VARCHAR2_TABLE_100
387     , a59 out nocopy JTF_VARCHAR2_TABLE_100
388     , a60 out nocopy JTF_VARCHAR2_TABLE_100
389     , a61 out nocopy JTF_NUMBER_TABLE
390     , a62 out nocopy JTF_VARCHAR2_TABLE_100
391     , a63 out nocopy JTF_VARCHAR2_TABLE_100
392     , a64 out nocopy JTF_VARCHAR2_TABLE_100
393     , a65 out nocopy JTF_VARCHAR2_TABLE_100
394     , a66 out nocopy JTF_VARCHAR2_TABLE_100
395     , a67 out nocopy JTF_NUMBER_TABLE
396     , a68 out nocopy JTF_NUMBER_TABLE
397     , a69 out nocopy JTF_NUMBER_TABLE
398     , a70 out nocopy JTF_DATE_TABLE
399     , a71 out nocopy JTF_NUMBER_TABLE
400     , a72 out nocopy JTF_DATE_TABLE
401     , a73 out nocopy JTF_NUMBER_TABLE
402     , a74 out nocopy JTF_NUMBER_TABLE
403     , a75 out nocopy JTF_VARCHAR2_TABLE_100
404     , a76 out nocopy JTF_VARCHAR2_TABLE_100
405     , a77 out nocopy JTF_NUMBER_TABLE
406     , a78 out nocopy JTF_NUMBER_TABLE
407     , a79 out nocopy JTF_VARCHAR2_TABLE_100
408     , a80 out nocopy JTF_VARCHAR2_TABLE_100
409     , a81 out nocopy JTF_NUMBER_TABLE
410     , a82 out nocopy JTF_VARCHAR2_TABLE_100
411     , a83 out nocopy JTF_NUMBER_TABLE
412     , a84 out nocopy JTF_NUMBER_TABLE
413     , a85 out nocopy JTF_NUMBER_TABLE
414     , a86 out nocopy JTF_NUMBER_TABLE
415     , a87 out nocopy JTF_VARCHAR2_TABLE_100
416     , a88 out nocopy JTF_NUMBER_TABLE
417     , a89 out nocopy JTF_NUMBER_TABLE
418     );
419 
420   procedure rosetta_table_copy_in_p7(t out nocopy okl_okc_migration_pvt.cimv_tbl_type, a0 JTF_NUMBER_TABLE
421     , a1 JTF_NUMBER_TABLE
422     , a2 JTF_NUMBER_TABLE
423     , a3 JTF_NUMBER_TABLE
424     , a4 JTF_NUMBER_TABLE
425     , a5 JTF_NUMBER_TABLE
426     , a6 JTF_VARCHAR2_TABLE_100
427     , a7 JTF_VARCHAR2_TABLE_200
428     , a8 JTF_VARCHAR2_TABLE_100
429     , a9 JTF_VARCHAR2_TABLE_100
430     , a10 JTF_VARCHAR2_TABLE_100
431     , a11 JTF_NUMBER_TABLE
432     , a12 JTF_VARCHAR2_TABLE_100
433     , a13 JTF_NUMBER_TABLE
434     , a14 JTF_VARCHAR2_TABLE_100
435     , a15 JTF_NUMBER_TABLE
436     , a16 JTF_DATE_TABLE
437     , a17 JTF_NUMBER_TABLE
438     , a18 JTF_DATE_TABLE
439     , a19 JTF_NUMBER_TABLE
440     );
441   procedure rosetta_table_copy_out_p7(t okl_okc_migration_pvt.cimv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
442     , a1 out nocopy JTF_NUMBER_TABLE
443     , a2 out nocopy JTF_NUMBER_TABLE
444     , a3 out nocopy JTF_NUMBER_TABLE
445     , a4 out nocopy JTF_NUMBER_TABLE
446     , a5 out nocopy JTF_NUMBER_TABLE
447     , a6 out nocopy JTF_VARCHAR2_TABLE_100
448     , a7 out nocopy JTF_VARCHAR2_TABLE_200
449     , a8 out nocopy JTF_VARCHAR2_TABLE_100
450     , a9 out nocopy JTF_VARCHAR2_TABLE_100
451     , a10 out nocopy JTF_VARCHAR2_TABLE_100
452     , a11 out nocopy JTF_NUMBER_TABLE
453     , a12 out nocopy JTF_VARCHAR2_TABLE_100
454     , a13 out nocopy JTF_NUMBER_TABLE
455     , a14 out nocopy JTF_VARCHAR2_TABLE_100
456     , a15 out nocopy JTF_NUMBER_TABLE
457     , a16 out nocopy JTF_DATE_TABLE
458     , a17 out nocopy JTF_NUMBER_TABLE
459     , a18 out nocopy JTF_DATE_TABLE
460     , a19 out nocopy JTF_NUMBER_TABLE
461     );
462 
463   procedure rosetta_table_copy_in_p9(t out nocopy okl_okc_migration_pvt.cplv_tbl_type, a0 JTF_NUMBER_TABLE
464     , a1 JTF_NUMBER_TABLE
465     , a2 JTF_VARCHAR2_TABLE_100
466     , a3 JTF_NUMBER_TABLE
467     , a4 JTF_NUMBER_TABLE
468     , a5 JTF_NUMBER_TABLE
469     , a6 JTF_VARCHAR2_TABLE_100
470     , a7 JTF_NUMBER_TABLE
471     , a8 JTF_VARCHAR2_TABLE_100
472     , a9 JTF_VARCHAR2_TABLE_200
473     , a10 JTF_VARCHAR2_TABLE_100
474     , a11 JTF_VARCHAR2_TABLE_300
475     , a12 JTF_VARCHAR2_TABLE_100
476     , a13 JTF_VARCHAR2_TABLE_100
477     , a14 JTF_VARCHAR2_TABLE_100
478     , a15 JTF_VARCHAR2_TABLE_100
479     , a16 JTF_VARCHAR2_TABLE_100
480     , a17 JTF_VARCHAR2_TABLE_200
481     , a18 JTF_VARCHAR2_TABLE_100
482     , a19 JTF_VARCHAR2_TABLE_500
483     , a20 JTF_VARCHAR2_TABLE_500
484     , a21 JTF_VARCHAR2_TABLE_500
485     , a22 JTF_VARCHAR2_TABLE_500
486     , a23 JTF_VARCHAR2_TABLE_500
487     , a24 JTF_VARCHAR2_TABLE_500
488     , a25 JTF_VARCHAR2_TABLE_500
489     , a26 JTF_VARCHAR2_TABLE_500
490     , a27 JTF_VARCHAR2_TABLE_500
491     , a28 JTF_VARCHAR2_TABLE_500
492     , a29 JTF_VARCHAR2_TABLE_500
493     , a30 JTF_VARCHAR2_TABLE_500
494     , a31 JTF_VARCHAR2_TABLE_500
495     , a32 JTF_VARCHAR2_TABLE_500
496     , a33 JTF_VARCHAR2_TABLE_500
497     , a34 JTF_NUMBER_TABLE
498     , a35 JTF_DATE_TABLE
499     , a36 JTF_NUMBER_TABLE
500     , a37 JTF_DATE_TABLE
501     , a38 JTF_NUMBER_TABLE
502     , a39 JTF_NUMBER_TABLE
503     , a40 JTF_NUMBER_TABLE
504     );
505   procedure rosetta_table_copy_out_p9(t okl_okc_migration_pvt.cplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
506     , a1 out nocopy JTF_NUMBER_TABLE
507     , a2 out nocopy JTF_VARCHAR2_TABLE_100
508     , a3 out nocopy JTF_NUMBER_TABLE
509     , a4 out nocopy JTF_NUMBER_TABLE
510     , a5 out nocopy JTF_NUMBER_TABLE
511     , a6 out nocopy JTF_VARCHAR2_TABLE_100
512     , a7 out nocopy JTF_NUMBER_TABLE
513     , a8 out nocopy JTF_VARCHAR2_TABLE_100
514     , a9 out nocopy JTF_VARCHAR2_TABLE_200
515     , a10 out nocopy JTF_VARCHAR2_TABLE_100
516     , a11 out nocopy JTF_VARCHAR2_TABLE_300
517     , a12 out nocopy JTF_VARCHAR2_TABLE_100
518     , a13 out nocopy JTF_VARCHAR2_TABLE_100
519     , a14 out nocopy JTF_VARCHAR2_TABLE_100
520     , a15 out nocopy JTF_VARCHAR2_TABLE_100
521     , a16 out nocopy JTF_VARCHAR2_TABLE_100
522     , a17 out nocopy JTF_VARCHAR2_TABLE_200
523     , a18 out nocopy JTF_VARCHAR2_TABLE_100
524     , a19 out nocopy JTF_VARCHAR2_TABLE_500
525     , a20 out nocopy JTF_VARCHAR2_TABLE_500
526     , a21 out nocopy JTF_VARCHAR2_TABLE_500
527     , a22 out nocopy JTF_VARCHAR2_TABLE_500
528     , a23 out nocopy JTF_VARCHAR2_TABLE_500
529     , a24 out nocopy JTF_VARCHAR2_TABLE_500
530     , a25 out nocopy JTF_VARCHAR2_TABLE_500
531     , a26 out nocopy JTF_VARCHAR2_TABLE_500
532     , a27 out nocopy JTF_VARCHAR2_TABLE_500
533     , a28 out nocopy JTF_VARCHAR2_TABLE_500
534     , a29 out nocopy JTF_VARCHAR2_TABLE_500
535     , a30 out nocopy JTF_VARCHAR2_TABLE_500
536     , a31 out nocopy JTF_VARCHAR2_TABLE_500
537     , a32 out nocopy JTF_VARCHAR2_TABLE_500
538     , a33 out nocopy JTF_VARCHAR2_TABLE_500
539     , a34 out nocopy JTF_NUMBER_TABLE
540     , a35 out nocopy JTF_DATE_TABLE
541     , a36 out nocopy JTF_NUMBER_TABLE
542     , a37 out nocopy JTF_DATE_TABLE
543     , a38 out nocopy JTF_NUMBER_TABLE
544     , a39 out nocopy JTF_NUMBER_TABLE
545     , a40 out nocopy JTF_NUMBER_TABLE
546     );
547 
548   procedure rosetta_table_copy_in_p11(t out nocopy okl_okc_migration_pvt.gvev_tbl_type, a0 JTF_NUMBER_TABLE
549     , a1 JTF_NUMBER_TABLE
550     , a2 JTF_NUMBER_TABLE
551     , a3 JTF_NUMBER_TABLE
552     , a4 JTF_NUMBER_TABLE
553     , a5 JTF_NUMBER_TABLE
554     , a6 JTF_NUMBER_TABLE
555     , a7 JTF_NUMBER_TABLE
556     , a8 JTF_VARCHAR2_TABLE_100
557     , a9 JTF_NUMBER_TABLE
558     , a10 JTF_DATE_TABLE
559     , a11 JTF_NUMBER_TABLE
560     , a12 JTF_DATE_TABLE
561     , a13 JTF_NUMBER_TABLE
562     );
563   procedure rosetta_table_copy_out_p11(t okl_okc_migration_pvt.gvev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
564     , a1 out nocopy JTF_NUMBER_TABLE
565     , a2 out nocopy JTF_NUMBER_TABLE
566     , a3 out nocopy JTF_NUMBER_TABLE
567     , a4 out nocopy JTF_NUMBER_TABLE
568     , a5 out nocopy JTF_NUMBER_TABLE
569     , a6 out nocopy JTF_NUMBER_TABLE
570     , a7 out nocopy JTF_NUMBER_TABLE
571     , a8 out nocopy JTF_VARCHAR2_TABLE_100
572     , a9 out nocopy JTF_NUMBER_TABLE
573     , a10 out nocopy JTF_DATE_TABLE
574     , a11 out nocopy JTF_NUMBER_TABLE
575     , a12 out nocopy JTF_DATE_TABLE
576     , a13 out nocopy JTF_NUMBER_TABLE
577     );
578 
579   procedure rosetta_table_copy_in_p13(t out nocopy okl_okc_migration_pvt.rgpv_tbl_type, a0 JTF_NUMBER_TABLE
580     , a1 JTF_NUMBER_TABLE
581     , a2 JTF_VARCHAR2_TABLE_100
582     , a3 JTF_VARCHAR2_TABLE_100
583     , a4 JTF_VARCHAR2_TABLE_100
584     , a5 JTF_VARCHAR2_TABLE_100
585     , a6 JTF_NUMBER_TABLE
586     , a7 JTF_NUMBER_TABLE
587     , a8 JTF_NUMBER_TABLE
588     , a9 JTF_NUMBER_TABLE
589     , a10 JTF_VARCHAR2_TABLE_2000
590     , a11 JTF_VARCHAR2_TABLE_100
591     , a12 JTF_VARCHAR2_TABLE_500
592     , a13 JTF_VARCHAR2_TABLE_500
593     , a14 JTF_VARCHAR2_TABLE_500
594     , a15 JTF_VARCHAR2_TABLE_500
595     , a16 JTF_VARCHAR2_TABLE_500
596     , a17 JTF_VARCHAR2_TABLE_500
597     , a18 JTF_VARCHAR2_TABLE_500
598     , a19 JTF_VARCHAR2_TABLE_500
599     , a20 JTF_VARCHAR2_TABLE_500
600     , a21 JTF_VARCHAR2_TABLE_500
601     , a22 JTF_VARCHAR2_TABLE_500
602     , a23 JTF_VARCHAR2_TABLE_500
603     , a24 JTF_VARCHAR2_TABLE_500
604     , a25 JTF_VARCHAR2_TABLE_500
605     , a26 JTF_VARCHAR2_TABLE_500
606     , a27 JTF_NUMBER_TABLE
607     , a28 JTF_DATE_TABLE
608     , a29 JTF_NUMBER_TABLE
609     , a30 JTF_DATE_TABLE
610     , a31 JTF_NUMBER_TABLE
611     );
612   procedure rosetta_table_copy_out_p13(t okl_okc_migration_pvt.rgpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
613     , a1 out nocopy JTF_NUMBER_TABLE
614     , a2 out nocopy JTF_VARCHAR2_TABLE_100
615     , a3 out nocopy JTF_VARCHAR2_TABLE_100
616     , a4 out nocopy JTF_VARCHAR2_TABLE_100
617     , a5 out nocopy JTF_VARCHAR2_TABLE_100
618     , a6 out nocopy JTF_NUMBER_TABLE
619     , a7 out nocopy JTF_NUMBER_TABLE
620     , a8 out nocopy JTF_NUMBER_TABLE
621     , a9 out nocopy JTF_NUMBER_TABLE
622     , a10 out nocopy JTF_VARCHAR2_TABLE_2000
623     , a11 out nocopy JTF_VARCHAR2_TABLE_100
624     , a12 out nocopy JTF_VARCHAR2_TABLE_500
625     , a13 out nocopy JTF_VARCHAR2_TABLE_500
626     , a14 out nocopy JTF_VARCHAR2_TABLE_500
627     , a15 out nocopy JTF_VARCHAR2_TABLE_500
628     , a16 out nocopy JTF_VARCHAR2_TABLE_500
629     , a17 out nocopy JTF_VARCHAR2_TABLE_500
630     , a18 out nocopy JTF_VARCHAR2_TABLE_500
631     , a19 out nocopy JTF_VARCHAR2_TABLE_500
632     , a20 out nocopy JTF_VARCHAR2_TABLE_500
633     , a21 out nocopy JTF_VARCHAR2_TABLE_500
634     , a22 out nocopy JTF_VARCHAR2_TABLE_500
635     , a23 out nocopy JTF_VARCHAR2_TABLE_500
636     , a24 out nocopy JTF_VARCHAR2_TABLE_500
637     , a25 out nocopy JTF_VARCHAR2_TABLE_500
638     , a26 out nocopy JTF_VARCHAR2_TABLE_500
639     , a27 out nocopy JTF_NUMBER_TABLE
640     , a28 out nocopy JTF_DATE_TABLE
641     , a29 out nocopy JTF_NUMBER_TABLE
642     , a30 out nocopy JTF_DATE_TABLE
643     , a31 out nocopy JTF_NUMBER_TABLE
644     );
645 
646   procedure rosetta_table_copy_in_p15(t out nocopy okl_okc_migration_pvt.rmpv_tbl_type, a0 JTF_NUMBER_TABLE
647     , a1 JTF_NUMBER_TABLE
648     , a2 JTF_NUMBER_TABLE
649     , a3 JTF_NUMBER_TABLE
650     , a4 JTF_NUMBER_TABLE
651     , a5 JTF_NUMBER_TABLE
652     , a6 JTF_NUMBER_TABLE
653     , a7 JTF_DATE_TABLE
654     , a8 JTF_NUMBER_TABLE
655     , a9 JTF_DATE_TABLE
656     , a10 JTF_NUMBER_TABLE
657     );
658   procedure rosetta_table_copy_out_p15(t okl_okc_migration_pvt.rmpv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
659     , a1 out nocopy JTF_NUMBER_TABLE
660     , a2 out nocopy JTF_NUMBER_TABLE
661     , a3 out nocopy JTF_NUMBER_TABLE
662     , a4 out nocopy JTF_NUMBER_TABLE
663     , a5 out nocopy JTF_NUMBER_TABLE
664     , a6 out nocopy JTF_NUMBER_TABLE
665     , a7 out nocopy JTF_DATE_TABLE
666     , a8 out nocopy JTF_NUMBER_TABLE
667     , a9 out nocopy JTF_DATE_TABLE
668     , a10 out nocopy JTF_NUMBER_TABLE
669     );
670 
671   procedure rosetta_table_copy_in_p17(t out nocopy okl_okc_migration_pvt.ctcv_tbl_type, a0 JTF_NUMBER_TABLE
672     , a1 JTF_NUMBER_TABLE
673     , a2 JTF_NUMBER_TABLE
674     , a3 JTF_VARCHAR2_TABLE_100
675     , a4 JTF_NUMBER_TABLE
676     , a5 JTF_NUMBER_TABLE
677     , a6 JTF_VARCHAR2_TABLE_100
678     , a7 JTF_VARCHAR2_TABLE_200
679     , a8 JTF_VARCHAR2_TABLE_100
680     , a9 JTF_VARCHAR2_TABLE_100
681     , a10 JTF_VARCHAR2_TABLE_500
682     , a11 JTF_VARCHAR2_TABLE_500
683     , a12 JTF_VARCHAR2_TABLE_500
684     , a13 JTF_VARCHAR2_TABLE_500
685     , a14 JTF_VARCHAR2_TABLE_500
686     , a15 JTF_VARCHAR2_TABLE_500
687     , a16 JTF_VARCHAR2_TABLE_500
688     , a17 JTF_VARCHAR2_TABLE_500
689     , a18 JTF_VARCHAR2_TABLE_500
690     , a19 JTF_VARCHAR2_TABLE_500
691     , a20 JTF_VARCHAR2_TABLE_500
692     , a21 JTF_VARCHAR2_TABLE_500
693     , a22 JTF_VARCHAR2_TABLE_500
694     , a23 JTF_VARCHAR2_TABLE_500
695     , a24 JTF_VARCHAR2_TABLE_500
696     , a25 JTF_NUMBER_TABLE
697     , a26 JTF_DATE_TABLE
698     , a27 JTF_NUMBER_TABLE
699     , a28 JTF_DATE_TABLE
700     , a29 JTF_NUMBER_TABLE
701     , a30 JTF_DATE_TABLE
702     , a31 JTF_DATE_TABLE
703     );
704   procedure rosetta_table_copy_out_p17(t okl_okc_migration_pvt.ctcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
705     , a1 out nocopy JTF_NUMBER_TABLE
706     , a2 out nocopy JTF_NUMBER_TABLE
707     , a3 out nocopy JTF_VARCHAR2_TABLE_100
708     , a4 out nocopy JTF_NUMBER_TABLE
709     , a5 out nocopy JTF_NUMBER_TABLE
710     , a6 out nocopy JTF_VARCHAR2_TABLE_100
711     , a7 out nocopy JTF_VARCHAR2_TABLE_200
712     , a8 out nocopy JTF_VARCHAR2_TABLE_100
713     , a9 out nocopy JTF_VARCHAR2_TABLE_100
714     , a10 out nocopy JTF_VARCHAR2_TABLE_500
715     , a11 out nocopy JTF_VARCHAR2_TABLE_500
716     , a12 out nocopy JTF_VARCHAR2_TABLE_500
717     , a13 out nocopy JTF_VARCHAR2_TABLE_500
718     , a14 out nocopy JTF_VARCHAR2_TABLE_500
719     , a15 out nocopy JTF_VARCHAR2_TABLE_500
720     , a16 out nocopy JTF_VARCHAR2_TABLE_500
721     , a17 out nocopy JTF_VARCHAR2_TABLE_500
722     , a18 out nocopy JTF_VARCHAR2_TABLE_500
723     , a19 out nocopy JTF_VARCHAR2_TABLE_500
724     , a20 out nocopy JTF_VARCHAR2_TABLE_500
725     , a21 out nocopy JTF_VARCHAR2_TABLE_500
726     , a22 out nocopy JTF_VARCHAR2_TABLE_500
727     , a23 out nocopy JTF_VARCHAR2_TABLE_500
728     , a24 out nocopy JTF_VARCHAR2_TABLE_500
729     , a25 out nocopy JTF_NUMBER_TABLE
730     , a26 out nocopy JTF_DATE_TABLE
731     , a27 out nocopy JTF_NUMBER_TABLE
732     , a28 out nocopy JTF_DATE_TABLE
733     , a29 out nocopy JTF_NUMBER_TABLE
734     , a30 out nocopy JTF_DATE_TABLE
735     , a31 out nocopy JTF_DATE_TABLE
736     );
737 
738   procedure create_contract_header(p_api_version  NUMBER
739     , p_init_msg_list  VARCHAR2
740     , x_return_status out nocopy  VARCHAR2
741     , x_msg_count out nocopy  NUMBER
742     , x_msg_data out nocopy  VARCHAR2
743     , p6_a0 out nocopy  NUMBER
744     , p6_a1 out nocopy  NUMBER
745     , p6_a2 out nocopy  VARCHAR2
746     , p6_a3 out nocopy  NUMBER
747     , p6_a4 out nocopy  NUMBER
748     , p6_a5 out nocopy  NUMBER
749     , p6_a6 out nocopy  NUMBER
750     , p6_a7 out nocopy  VARCHAR2
751     , p6_a8 out nocopy  NUMBER
752     , p6_a9 out nocopy  VARCHAR2
753     , p6_a10 out nocopy  VARCHAR2
754     , p6_a11 out nocopy  VARCHAR2
755     , p6_a12 out nocopy  VARCHAR2
756     , p6_a13 out nocopy  VARCHAR2
757     , p6_a14 out nocopy  VARCHAR2
758     , p6_a15 out nocopy  VARCHAR2
759     , p6_a16 out nocopy  VARCHAR2
760     , p6_a17 out nocopy  VARCHAR2
761     , p6_a18 out nocopy  VARCHAR2
762     , p6_a19 out nocopy  VARCHAR2
763     , p6_a20 out nocopy  VARCHAR2
764     , p6_a21 out nocopy  VARCHAR2
765     , p6_a22 out nocopy  VARCHAR2
766     , p6_a23 out nocopy  VARCHAR2
767     , p6_a24 out nocopy  VARCHAR2
768     , p6_a25 out nocopy  DATE
769     , p6_a26 out nocopy  DATE
770     , p6_a27 out nocopy  NUMBER
771     , p6_a28 out nocopy  DATE
772     , p6_a29 out nocopy  DATE
773     , p6_a30 out nocopy  VARCHAR2
774     , p6_a31 out nocopy  VARCHAR2
775     , p6_a32 out nocopy  VARCHAR2
776     , p6_a33 out nocopy  VARCHAR2
777     , p6_a34 out nocopy  VARCHAR2
778     , p6_a35 out nocopy  VARCHAR2
779     , p6_a36 out nocopy  NUMBER
780     , p6_a37 out nocopy  NUMBER
781     , p6_a38 out nocopy  DATE
782     , p6_a39 out nocopy  DATE
783     , p6_a40 out nocopy  DATE
784     , p6_a41 out nocopy  DATE
785     , p6_a42 out nocopy  DATE
786     , p6_a43 out nocopy  VARCHAR2
787     , p6_a44 out nocopy  DATE
788     , p6_a45 out nocopy  DATE
789     , p6_a46 out nocopy  NUMBER
790     , p6_a47 out nocopy  VARCHAR2
791     , p6_a48 out nocopy  VARCHAR2
792     , p6_a49 out nocopy  NUMBER
793     , p6_a50 out nocopy  NUMBER
794     , p6_a51 out nocopy  NUMBER
795     , p6_a52 out nocopy  VARCHAR2
796     , p6_a53 out nocopy  VARCHAR2
797     , p6_a54 out nocopy  NUMBER
798     , p6_a55 out nocopy  NUMBER
799     , p6_a56 out nocopy  VARCHAR2
800     , p6_a57 out nocopy  NUMBER
801     , p6_a58 out nocopy  VARCHAR2
802     , p6_a59 out nocopy  NUMBER
803     , p6_a60 out nocopy  NUMBER
804     , p6_a61 out nocopy  NUMBER
805     , p6_a62 out nocopy  DATE
806     , p6_a63 out nocopy  DATE
807     , p6_a64 out nocopy  DATE
808     , p6_a65 out nocopy  NUMBER
809     , p6_a66 out nocopy  NUMBER
810     , p6_a67 out nocopy  NUMBER
811     , p6_a68 out nocopy  VARCHAR2
812     , p6_a69 out nocopy  VARCHAR2
813     , p6_a70 out nocopy  VARCHAR2
814     , p6_a71 out nocopy  VARCHAR2
815     , p6_a72 out nocopy  VARCHAR2
816     , p6_a73 out nocopy  VARCHAR2
817     , p6_a74 out nocopy  VARCHAR2
818     , p6_a75 out nocopy  VARCHAR2
819     , p6_a76 out nocopy  VARCHAR2
820     , p6_a77 out nocopy  VARCHAR2
821     , p6_a78 out nocopy  VARCHAR2
822     , p6_a79 out nocopy  VARCHAR2
823     , p6_a80 out nocopy  VARCHAR2
824     , p6_a81 out nocopy  VARCHAR2
825     , p6_a82 out nocopy  VARCHAR2
826     , p6_a83 out nocopy  VARCHAR2
827     , p6_a84 out nocopy  NUMBER
828     , p6_a85 out nocopy  DATE
829     , p6_a86 out nocopy  NUMBER
830     , p6_a87 out nocopy  DATE
831     , p6_a88 out nocopy  NUMBER
832     , p6_a89 out nocopy  VARCHAR2
833     , p6_a90 out nocopy  VARCHAR2
834     , p6_a91 out nocopy  VARCHAR2
835     , p6_a92 out nocopy  VARCHAR2
836     , p6_a93 out nocopy  VARCHAR2
837     , p6_a94 out nocopy  NUMBER
838     , p6_a95 out nocopy  DATE
839     , p6_a96 out nocopy  NUMBER
840     , p6_a97 out nocopy  NUMBER
841     , p6_a98 out nocopy  NUMBER
842     , p6_a99 out nocopy  NUMBER
843     , p6_a100 out nocopy  VARCHAR2
844     , p6_a101 out nocopy  NUMBER
845     , p6_a102 out nocopy  DATE
846     , p6_a103 out nocopy  NUMBER
847     , p6_a104 out nocopy  NUMBER
848     , p5_a0  NUMBER := 0-1962.0724
849     , p5_a1  NUMBER := 0-1962.0724
850     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
851     , p5_a3  NUMBER := 0-1962.0724
852     , p5_a4  NUMBER := 0-1962.0724
853     , p5_a5  NUMBER := 0-1962.0724
854     , p5_a6  NUMBER := 0-1962.0724
855     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
856     , p5_a8  NUMBER := 0-1962.0724
857     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
858     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
859     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
860     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
861     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
862     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
863     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
864     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
865     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
866     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
867     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
868     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
869     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
870     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
871     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
872     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
873     , p5_a25  DATE := fnd_api.g_miss_date
874     , p5_a26  DATE := fnd_api.g_miss_date
875     , p5_a27  NUMBER := 0-1962.0724
876     , p5_a28  DATE := fnd_api.g_miss_date
877     , p5_a29  DATE := fnd_api.g_miss_date
878     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
879     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
880     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
881     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
882     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
883     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
884     , p5_a36  NUMBER := 0-1962.0724
885     , p5_a37  NUMBER := 0-1962.0724
886     , p5_a38  DATE := fnd_api.g_miss_date
887     , p5_a39  DATE := fnd_api.g_miss_date
888     , p5_a40  DATE := fnd_api.g_miss_date
889     , p5_a41  DATE := fnd_api.g_miss_date
890     , p5_a42  DATE := fnd_api.g_miss_date
891     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
892     , p5_a44  DATE := fnd_api.g_miss_date
893     , p5_a45  DATE := fnd_api.g_miss_date
894     , p5_a46  NUMBER := 0-1962.0724
895     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
896     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
897     , p5_a49  NUMBER := 0-1962.0724
898     , p5_a50  NUMBER := 0-1962.0724
899     , p5_a51  NUMBER := 0-1962.0724
900     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
901     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
902     , p5_a54  NUMBER := 0-1962.0724
903     , p5_a55  NUMBER := 0-1962.0724
904     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
905     , p5_a57  NUMBER := 0-1962.0724
906     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
907     , p5_a59  NUMBER := 0-1962.0724
908     , p5_a60  NUMBER := 0-1962.0724
909     , p5_a61  NUMBER := 0-1962.0724
910     , p5_a62  DATE := fnd_api.g_miss_date
911     , p5_a63  DATE := fnd_api.g_miss_date
912     , p5_a64  DATE := fnd_api.g_miss_date
913     , p5_a65  NUMBER := 0-1962.0724
914     , p5_a66  NUMBER := 0-1962.0724
915     , p5_a67  NUMBER := 0-1962.0724
916     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
917     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
918     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
919     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
920     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
921     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
922     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
923     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
924     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
925     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
926     , p5_a78  VARCHAR2 := fnd_api.g_miss_char
927     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
928     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
929     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
930     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
931     , p5_a83  VARCHAR2 := fnd_api.g_miss_char
932     , p5_a84  NUMBER := 0-1962.0724
933     , p5_a85  DATE := fnd_api.g_miss_date
934     , p5_a86  NUMBER := 0-1962.0724
935     , p5_a87  DATE := fnd_api.g_miss_date
936     , p5_a88  NUMBER := 0-1962.0724
937     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
938     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
939     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
940     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
941     , p5_a93  VARCHAR2 := fnd_api.g_miss_char
942     , p5_a94  NUMBER := 0-1962.0724
943     , p5_a95  DATE := fnd_api.g_miss_date
944     , p5_a96  NUMBER := 0-1962.0724
945     , p5_a97  NUMBER := 0-1962.0724
946     , p5_a98  NUMBER := 0-1962.0724
947     , p5_a99  NUMBER := 0-1962.0724
948     , p5_a100  VARCHAR2 := fnd_api.g_miss_char
949     , p5_a101  NUMBER := 0-1962.0724
950     , p5_a102  DATE := fnd_api.g_miss_date
951     , p5_a103  NUMBER := 0-1962.0724
952     , p5_a104  NUMBER := 0-1962.0724
953   );
954   procedure update_contract_header(p_api_version  NUMBER
955     , p_init_msg_list  VARCHAR2
956     , x_return_status out nocopy  VARCHAR2
957     , x_msg_count out nocopy  NUMBER
958     , x_msg_data out nocopy  VARCHAR2
959     , p_restricted_update  VARCHAR2
960     , p7_a0 out nocopy  NUMBER
961     , p7_a1 out nocopy  NUMBER
962     , p7_a2 out nocopy  VARCHAR2
963     , p7_a3 out nocopy  NUMBER
964     , p7_a4 out nocopy  NUMBER
965     , p7_a5 out nocopy  NUMBER
966     , p7_a6 out nocopy  NUMBER
967     , p7_a7 out nocopy  VARCHAR2
968     , p7_a8 out nocopy  NUMBER
969     , p7_a9 out nocopy  VARCHAR2
970     , p7_a10 out nocopy  VARCHAR2
971     , p7_a11 out nocopy  VARCHAR2
972     , p7_a12 out nocopy  VARCHAR2
973     , p7_a13 out nocopy  VARCHAR2
974     , p7_a14 out nocopy  VARCHAR2
975     , p7_a15 out nocopy  VARCHAR2
976     , p7_a16 out nocopy  VARCHAR2
977     , p7_a17 out nocopy  VARCHAR2
978     , p7_a18 out nocopy  VARCHAR2
979     , p7_a19 out nocopy  VARCHAR2
980     , p7_a20 out nocopy  VARCHAR2
981     , p7_a21 out nocopy  VARCHAR2
982     , p7_a22 out nocopy  VARCHAR2
983     , p7_a23 out nocopy  VARCHAR2
984     , p7_a24 out nocopy  VARCHAR2
985     , p7_a25 out nocopy  DATE
986     , p7_a26 out nocopy  DATE
987     , p7_a27 out nocopy  NUMBER
988     , p7_a28 out nocopy  DATE
989     , p7_a29 out nocopy  DATE
990     , p7_a30 out nocopy  VARCHAR2
991     , p7_a31 out nocopy  VARCHAR2
992     , p7_a32 out nocopy  VARCHAR2
993     , p7_a33 out nocopy  VARCHAR2
994     , p7_a34 out nocopy  VARCHAR2
995     , p7_a35 out nocopy  VARCHAR2
996     , p7_a36 out nocopy  NUMBER
997     , p7_a37 out nocopy  NUMBER
998     , p7_a38 out nocopy  DATE
999     , p7_a39 out nocopy  DATE
1000     , p7_a40 out nocopy  DATE
1001     , p7_a41 out nocopy  DATE
1002     , p7_a42 out nocopy  DATE
1003     , p7_a43 out nocopy  VARCHAR2
1004     , p7_a44 out nocopy  DATE
1005     , p7_a45 out nocopy  DATE
1006     , p7_a46 out nocopy  NUMBER
1007     , p7_a47 out nocopy  VARCHAR2
1008     , p7_a48 out nocopy  VARCHAR2
1009     , p7_a49 out nocopy  NUMBER
1010     , p7_a50 out nocopy  NUMBER
1011     , p7_a51 out nocopy  NUMBER
1012     , p7_a52 out nocopy  VARCHAR2
1013     , p7_a53 out nocopy  VARCHAR2
1014     , p7_a54 out nocopy  NUMBER
1015     , p7_a55 out nocopy  NUMBER
1016     , p7_a56 out nocopy  VARCHAR2
1017     , p7_a57 out nocopy  NUMBER
1018     , p7_a58 out nocopy  VARCHAR2
1019     , p7_a59 out nocopy  NUMBER
1020     , p7_a60 out nocopy  NUMBER
1021     , p7_a61 out nocopy  NUMBER
1022     , p7_a62 out nocopy  DATE
1023     , p7_a63 out nocopy  DATE
1024     , p7_a64 out nocopy  DATE
1025     , p7_a65 out nocopy  NUMBER
1026     , p7_a66 out nocopy  NUMBER
1027     , p7_a67 out nocopy  NUMBER
1028     , p7_a68 out nocopy  VARCHAR2
1029     , p7_a69 out nocopy  VARCHAR2
1030     , p7_a70 out nocopy  VARCHAR2
1031     , p7_a71 out nocopy  VARCHAR2
1032     , p7_a72 out nocopy  VARCHAR2
1033     , p7_a73 out nocopy  VARCHAR2
1034     , p7_a74 out nocopy  VARCHAR2
1035     , p7_a75 out nocopy  VARCHAR2
1036     , p7_a76 out nocopy  VARCHAR2
1037     , p7_a77 out nocopy  VARCHAR2
1038     , p7_a78 out nocopy  VARCHAR2
1039     , p7_a79 out nocopy  VARCHAR2
1040     , p7_a80 out nocopy  VARCHAR2
1041     , p7_a81 out nocopy  VARCHAR2
1042     , p7_a82 out nocopy  VARCHAR2
1043     , p7_a83 out nocopy  VARCHAR2
1044     , p7_a84 out nocopy  NUMBER
1045     , p7_a85 out nocopy  DATE
1046     , p7_a86 out nocopy  NUMBER
1047     , p7_a87 out nocopy  DATE
1048     , p7_a88 out nocopy  NUMBER
1049     , p7_a89 out nocopy  VARCHAR2
1050     , p7_a90 out nocopy  VARCHAR2
1051     , p7_a91 out nocopy  VARCHAR2
1052     , p7_a92 out nocopy  VARCHAR2
1053     , p7_a93 out nocopy  VARCHAR2
1054     , p7_a94 out nocopy  NUMBER
1055     , p7_a95 out nocopy  DATE
1056     , p7_a96 out nocopy  NUMBER
1057     , p7_a97 out nocopy  NUMBER
1058     , p7_a98 out nocopy  NUMBER
1059     , p7_a99 out nocopy  NUMBER
1060     , p7_a100 out nocopy  VARCHAR2
1061     , p7_a101 out nocopy  NUMBER
1062     , p7_a102 out nocopy  DATE
1063     , p7_a103 out nocopy  NUMBER
1064     , p7_a104 out nocopy  NUMBER
1065     , p6_a0  NUMBER := 0-1962.0724
1066     , p6_a1  NUMBER := 0-1962.0724
1067     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
1068     , p6_a3  NUMBER := 0-1962.0724
1069     , p6_a4  NUMBER := 0-1962.0724
1070     , p6_a5  NUMBER := 0-1962.0724
1071     , p6_a6  NUMBER := 0-1962.0724
1072     , p6_a7  VARCHAR2 := fnd_api.g_miss_char
1073     , p6_a8  NUMBER := 0-1962.0724
1074     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
1075     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
1076     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
1077     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
1078     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
1079     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
1080     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
1081     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
1082     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
1083     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
1084     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
1085     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
1086     , p6_a21  VARCHAR2 := fnd_api.g_miss_char
1087     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
1088     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
1089     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
1090     , p6_a25  DATE := fnd_api.g_miss_date
1091     , p6_a26  DATE := fnd_api.g_miss_date
1092     , p6_a27  NUMBER := 0-1962.0724
1093     , p6_a28  DATE := fnd_api.g_miss_date
1094     , p6_a29  DATE := fnd_api.g_miss_date
1095     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
1096     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
1097     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
1098     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
1099     , p6_a34  VARCHAR2 := fnd_api.g_miss_char
1100     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
1101     , p6_a36  NUMBER := 0-1962.0724
1102     , p6_a37  NUMBER := 0-1962.0724
1103     , p6_a38  DATE := fnd_api.g_miss_date
1104     , p6_a39  DATE := fnd_api.g_miss_date
1105     , p6_a40  DATE := fnd_api.g_miss_date
1106     , p6_a41  DATE := fnd_api.g_miss_date
1107     , p6_a42  DATE := fnd_api.g_miss_date
1108     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
1109     , p6_a44  DATE := fnd_api.g_miss_date
1110     , p6_a45  DATE := fnd_api.g_miss_date
1111     , p6_a46  NUMBER := 0-1962.0724
1112     , p6_a47  VARCHAR2 := fnd_api.g_miss_char
1113     , p6_a48  VARCHAR2 := fnd_api.g_miss_char
1114     , p6_a49  NUMBER := 0-1962.0724
1115     , p6_a50  NUMBER := 0-1962.0724
1116     , p6_a51  NUMBER := 0-1962.0724
1117     , p6_a52  VARCHAR2 := fnd_api.g_miss_char
1118     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
1119     , p6_a54  NUMBER := 0-1962.0724
1120     , p6_a55  NUMBER := 0-1962.0724
1121     , p6_a56  VARCHAR2 := fnd_api.g_miss_char
1122     , p6_a57  NUMBER := 0-1962.0724
1123     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
1124     , p6_a59  NUMBER := 0-1962.0724
1125     , p6_a60  NUMBER := 0-1962.0724
1126     , p6_a61  NUMBER := 0-1962.0724
1127     , p6_a62  DATE := fnd_api.g_miss_date
1128     , p6_a63  DATE := fnd_api.g_miss_date
1129     , p6_a64  DATE := fnd_api.g_miss_date
1130     , p6_a65  NUMBER := 0-1962.0724
1131     , p6_a66  NUMBER := 0-1962.0724
1132     , p6_a67  NUMBER := 0-1962.0724
1133     , p6_a68  VARCHAR2 := fnd_api.g_miss_char
1134     , p6_a69  VARCHAR2 := fnd_api.g_miss_char
1135     , p6_a70  VARCHAR2 := fnd_api.g_miss_char
1136     , p6_a71  VARCHAR2 := fnd_api.g_miss_char
1137     , p6_a72  VARCHAR2 := fnd_api.g_miss_char
1138     , p6_a73  VARCHAR2 := fnd_api.g_miss_char
1139     , p6_a74  VARCHAR2 := fnd_api.g_miss_char
1140     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
1141     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
1142     , p6_a77  VARCHAR2 := fnd_api.g_miss_char
1143     , p6_a78  VARCHAR2 := fnd_api.g_miss_char
1144     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
1145     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
1146     , p6_a81  VARCHAR2 := fnd_api.g_miss_char
1147     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
1148     , p6_a83  VARCHAR2 := fnd_api.g_miss_char
1149     , p6_a84  NUMBER := 0-1962.0724
1150     , p6_a85  DATE := fnd_api.g_miss_date
1151     , p6_a86  NUMBER := 0-1962.0724
1152     , p6_a87  DATE := fnd_api.g_miss_date
1153     , p6_a88  NUMBER := 0-1962.0724
1154     , p6_a89  VARCHAR2 := fnd_api.g_miss_char
1155     , p6_a90  VARCHAR2 := fnd_api.g_miss_char
1156     , p6_a91  VARCHAR2 := fnd_api.g_miss_char
1157     , p6_a92  VARCHAR2 := fnd_api.g_miss_char
1158     , p6_a93  VARCHAR2 := fnd_api.g_miss_char
1159     , p6_a94  NUMBER := 0-1962.0724
1160     , p6_a95  DATE := fnd_api.g_miss_date
1161     , p6_a96  NUMBER := 0-1962.0724
1162     , p6_a97  NUMBER := 0-1962.0724
1163     , p6_a98  NUMBER := 0-1962.0724
1164     , p6_a99  NUMBER := 0-1962.0724
1165     , p6_a100  VARCHAR2 := fnd_api.g_miss_char
1166     , p6_a101  NUMBER := 0-1962.0724
1167     , p6_a102  DATE := fnd_api.g_miss_date
1168     , p6_a103  NUMBER := 0-1962.0724
1169     , p6_a104  NUMBER := 0-1962.0724
1170   );
1171   procedure delete_contract_header(p_api_version  NUMBER
1172     , p_init_msg_list  VARCHAR2
1173     , x_return_status out nocopy  VARCHAR2
1174     , x_msg_count out nocopy  NUMBER
1175     , x_msg_data out nocopy  VARCHAR2
1176     , p5_a0  NUMBER := 0-1962.0724
1177     , p5_a1  NUMBER := 0-1962.0724
1178     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1179     , p5_a3  NUMBER := 0-1962.0724
1180     , p5_a4  NUMBER := 0-1962.0724
1181     , p5_a5  NUMBER := 0-1962.0724
1182     , p5_a6  NUMBER := 0-1962.0724
1183     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
1184     , p5_a8  NUMBER := 0-1962.0724
1185     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
1186     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
1187     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
1188     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1189     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1190     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
1191     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1192     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1193     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
1194     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1195     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1196     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1197     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1198     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1199     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1200     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1201     , p5_a25  DATE := fnd_api.g_miss_date
1202     , p5_a26  DATE := fnd_api.g_miss_date
1203     , p5_a27  NUMBER := 0-1962.0724
1204     , p5_a28  DATE := fnd_api.g_miss_date
1205     , p5_a29  DATE := fnd_api.g_miss_date
1206     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1207     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1208     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1209     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1210     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1211     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1212     , p5_a36  NUMBER := 0-1962.0724
1213     , p5_a37  NUMBER := 0-1962.0724
1214     , p5_a38  DATE := fnd_api.g_miss_date
1215     , p5_a39  DATE := fnd_api.g_miss_date
1216     , p5_a40  DATE := fnd_api.g_miss_date
1217     , p5_a41  DATE := fnd_api.g_miss_date
1218     , p5_a42  DATE := fnd_api.g_miss_date
1219     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
1220     , p5_a44  DATE := fnd_api.g_miss_date
1221     , p5_a45  DATE := fnd_api.g_miss_date
1222     , p5_a46  NUMBER := 0-1962.0724
1223     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
1224     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
1225     , p5_a49  NUMBER := 0-1962.0724
1226     , p5_a50  NUMBER := 0-1962.0724
1227     , p5_a51  NUMBER := 0-1962.0724
1228     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
1229     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
1230     , p5_a54  NUMBER := 0-1962.0724
1231     , p5_a55  NUMBER := 0-1962.0724
1232     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
1233     , p5_a57  NUMBER := 0-1962.0724
1234     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
1235     , p5_a59  NUMBER := 0-1962.0724
1236     , p5_a60  NUMBER := 0-1962.0724
1237     , p5_a61  NUMBER := 0-1962.0724
1238     , p5_a62  DATE := fnd_api.g_miss_date
1239     , p5_a63  DATE := fnd_api.g_miss_date
1240     , p5_a64  DATE := fnd_api.g_miss_date
1241     , p5_a65  NUMBER := 0-1962.0724
1242     , p5_a66  NUMBER := 0-1962.0724
1243     , p5_a67  NUMBER := 0-1962.0724
1244     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1245     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1246     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1247     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1248     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1249     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1250     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1251     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1252     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1253     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
1254     , p5_a78  VARCHAR2 := fnd_api.g_miss_char
1255     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
1256     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
1257     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1258     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
1259     , p5_a83  VARCHAR2 := fnd_api.g_miss_char
1260     , p5_a84  NUMBER := 0-1962.0724
1261     , p5_a85  DATE := fnd_api.g_miss_date
1262     , p5_a86  NUMBER := 0-1962.0724
1263     , p5_a87  DATE := fnd_api.g_miss_date
1264     , p5_a88  NUMBER := 0-1962.0724
1265     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1266     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1267     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1268     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1269     , p5_a93  VARCHAR2 := fnd_api.g_miss_char
1270     , p5_a94  NUMBER := 0-1962.0724
1271     , p5_a95  DATE := fnd_api.g_miss_date
1272     , p5_a96  NUMBER := 0-1962.0724
1273     , p5_a97  NUMBER := 0-1962.0724
1274     , p5_a98  NUMBER := 0-1962.0724
1275     , p5_a99  NUMBER := 0-1962.0724
1276     , p5_a100  VARCHAR2 := fnd_api.g_miss_char
1277     , p5_a101  NUMBER := 0-1962.0724
1278     , p5_a102  DATE := fnd_api.g_miss_date
1279     , p5_a103  NUMBER := 0-1962.0724
1280     , p5_a104  NUMBER := 0-1962.0724
1281   );
1282   procedure lock_contract_header(p_api_version  NUMBER
1283     , p_init_msg_list  VARCHAR2
1284     , x_return_status out nocopy  VARCHAR2
1285     , x_msg_count out nocopy  NUMBER
1286     , x_msg_data out nocopy  VARCHAR2
1287     , p5_a0  NUMBER := 0-1962.0724
1288     , p5_a1  NUMBER := 0-1962.0724
1289     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1290     , p5_a3  NUMBER := 0-1962.0724
1291     , p5_a4  NUMBER := 0-1962.0724
1292     , p5_a5  NUMBER := 0-1962.0724
1293     , p5_a6  NUMBER := 0-1962.0724
1294     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
1295     , p5_a8  NUMBER := 0-1962.0724
1296     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
1297     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
1298     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
1299     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1300     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1301     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
1302     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1303     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1304     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
1305     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1306     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1307     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1308     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1309     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1310     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1311     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1312     , p5_a25  DATE := fnd_api.g_miss_date
1313     , p5_a26  DATE := fnd_api.g_miss_date
1314     , p5_a27  NUMBER := 0-1962.0724
1315     , p5_a28  DATE := fnd_api.g_miss_date
1316     , p5_a29  DATE := fnd_api.g_miss_date
1317     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1318     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1319     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1320     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1321     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1322     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1323     , p5_a36  NUMBER := 0-1962.0724
1324     , p5_a37  NUMBER := 0-1962.0724
1325     , p5_a38  DATE := fnd_api.g_miss_date
1326     , p5_a39  DATE := fnd_api.g_miss_date
1327     , p5_a40  DATE := fnd_api.g_miss_date
1328     , p5_a41  DATE := fnd_api.g_miss_date
1329     , p5_a42  DATE := fnd_api.g_miss_date
1330     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
1331     , p5_a44  DATE := fnd_api.g_miss_date
1332     , p5_a45  DATE := fnd_api.g_miss_date
1333     , p5_a46  NUMBER := 0-1962.0724
1334     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
1335     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
1336     , p5_a49  NUMBER := 0-1962.0724
1337     , p5_a50  NUMBER := 0-1962.0724
1338     , p5_a51  NUMBER := 0-1962.0724
1339     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
1340     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
1341     , p5_a54  NUMBER := 0-1962.0724
1342     , p5_a55  NUMBER := 0-1962.0724
1343     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
1344     , p5_a57  NUMBER := 0-1962.0724
1345     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
1346     , p5_a59  NUMBER := 0-1962.0724
1347     , p5_a60  NUMBER := 0-1962.0724
1348     , p5_a61  NUMBER := 0-1962.0724
1349     , p5_a62  DATE := fnd_api.g_miss_date
1350     , p5_a63  DATE := fnd_api.g_miss_date
1351     , p5_a64  DATE := fnd_api.g_miss_date
1352     , p5_a65  NUMBER := 0-1962.0724
1353     , p5_a66  NUMBER := 0-1962.0724
1354     , p5_a67  NUMBER := 0-1962.0724
1355     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1356     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1357     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1358     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1359     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1360     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1361     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1362     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1363     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1364     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
1365     , p5_a78  VARCHAR2 := fnd_api.g_miss_char
1366     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
1367     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
1368     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1369     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
1370     , p5_a83  VARCHAR2 := fnd_api.g_miss_char
1371     , p5_a84  NUMBER := 0-1962.0724
1372     , p5_a85  DATE := fnd_api.g_miss_date
1373     , p5_a86  NUMBER := 0-1962.0724
1374     , p5_a87  DATE := fnd_api.g_miss_date
1375     , p5_a88  NUMBER := 0-1962.0724
1376     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1377     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1378     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1379     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1380     , p5_a93  VARCHAR2 := fnd_api.g_miss_char
1381     , p5_a94  NUMBER := 0-1962.0724
1382     , p5_a95  DATE := fnd_api.g_miss_date
1383     , p5_a96  NUMBER := 0-1962.0724
1384     , p5_a97  NUMBER := 0-1962.0724
1385     , p5_a98  NUMBER := 0-1962.0724
1386     , p5_a99  NUMBER := 0-1962.0724
1387     , p5_a100  VARCHAR2 := fnd_api.g_miss_char
1388     , p5_a101  NUMBER := 0-1962.0724
1389     , p5_a102  DATE := fnd_api.g_miss_date
1390     , p5_a103  NUMBER := 0-1962.0724
1391     , p5_a104  NUMBER := 0-1962.0724
1392   );
1393   procedure validate_contract_header(p_api_version  NUMBER
1394     , p_init_msg_list  VARCHAR2
1395     , x_return_status out nocopy  VARCHAR2
1396     , x_msg_count out nocopy  NUMBER
1397     , x_msg_data out nocopy  VARCHAR2
1398     , p5_a0  NUMBER := 0-1962.0724
1399     , p5_a1  NUMBER := 0-1962.0724
1400     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
1401     , p5_a3  NUMBER := 0-1962.0724
1402     , p5_a4  NUMBER := 0-1962.0724
1403     , p5_a5  NUMBER := 0-1962.0724
1404     , p5_a6  NUMBER := 0-1962.0724
1405     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
1406     , p5_a8  NUMBER := 0-1962.0724
1407     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
1408     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
1409     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
1410     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
1411     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
1412     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
1413     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
1414     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
1415     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
1416     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
1417     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
1418     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
1419     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
1420     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
1421     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
1422     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
1423     , p5_a25  DATE := fnd_api.g_miss_date
1424     , p5_a26  DATE := fnd_api.g_miss_date
1425     , p5_a27  NUMBER := 0-1962.0724
1426     , p5_a28  DATE := fnd_api.g_miss_date
1427     , p5_a29  DATE := fnd_api.g_miss_date
1428     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
1429     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
1430     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
1431     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
1432     , p5_a34  VARCHAR2 := fnd_api.g_miss_char
1433     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
1434     , p5_a36  NUMBER := 0-1962.0724
1435     , p5_a37  NUMBER := 0-1962.0724
1436     , p5_a38  DATE := fnd_api.g_miss_date
1437     , p5_a39  DATE := fnd_api.g_miss_date
1438     , p5_a40  DATE := fnd_api.g_miss_date
1439     , p5_a41  DATE := fnd_api.g_miss_date
1440     , p5_a42  DATE := fnd_api.g_miss_date
1441     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
1442     , p5_a44  DATE := fnd_api.g_miss_date
1443     , p5_a45  DATE := fnd_api.g_miss_date
1444     , p5_a46  NUMBER := 0-1962.0724
1445     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
1446     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
1447     , p5_a49  NUMBER := 0-1962.0724
1448     , p5_a50  NUMBER := 0-1962.0724
1449     , p5_a51  NUMBER := 0-1962.0724
1450     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
1451     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
1452     , p5_a54  NUMBER := 0-1962.0724
1453     , p5_a55  NUMBER := 0-1962.0724
1454     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
1455     , p5_a57  NUMBER := 0-1962.0724
1456     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
1457     , p5_a59  NUMBER := 0-1962.0724
1458     , p5_a60  NUMBER := 0-1962.0724
1459     , p5_a61  NUMBER := 0-1962.0724
1460     , p5_a62  DATE := fnd_api.g_miss_date
1461     , p5_a63  DATE := fnd_api.g_miss_date
1462     , p5_a64  DATE := fnd_api.g_miss_date
1463     , p5_a65  NUMBER := 0-1962.0724
1464     , p5_a66  NUMBER := 0-1962.0724
1465     , p5_a67  NUMBER := 0-1962.0724
1466     , p5_a68  VARCHAR2 := fnd_api.g_miss_char
1467     , p5_a69  VARCHAR2 := fnd_api.g_miss_char
1468     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
1469     , p5_a71  VARCHAR2 := fnd_api.g_miss_char
1470     , p5_a72  VARCHAR2 := fnd_api.g_miss_char
1471     , p5_a73  VARCHAR2 := fnd_api.g_miss_char
1472     , p5_a74  VARCHAR2 := fnd_api.g_miss_char
1473     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
1474     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
1475     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
1476     , p5_a78  VARCHAR2 := fnd_api.g_miss_char
1477     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
1478     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
1479     , p5_a81  VARCHAR2 := fnd_api.g_miss_char
1480     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
1481     , p5_a83  VARCHAR2 := fnd_api.g_miss_char
1482     , p5_a84  NUMBER := 0-1962.0724
1483     , p5_a85  DATE := fnd_api.g_miss_date
1484     , p5_a86  NUMBER := 0-1962.0724
1485     , p5_a87  DATE := fnd_api.g_miss_date
1486     , p5_a88  NUMBER := 0-1962.0724
1487     , p5_a89  VARCHAR2 := fnd_api.g_miss_char
1488     , p5_a90  VARCHAR2 := fnd_api.g_miss_char
1489     , p5_a91  VARCHAR2 := fnd_api.g_miss_char
1490     , p5_a92  VARCHAR2 := fnd_api.g_miss_char
1491     , p5_a93  VARCHAR2 := fnd_api.g_miss_char
1492     , p5_a94  NUMBER := 0-1962.0724
1493     , p5_a95  DATE := fnd_api.g_miss_date
1494     , p5_a96  NUMBER := 0-1962.0724
1495     , p5_a97  NUMBER := 0-1962.0724
1496     , p5_a98  NUMBER := 0-1962.0724
1497     , p5_a99  NUMBER := 0-1962.0724
1498     , p5_a100  VARCHAR2 := fnd_api.g_miss_char
1499     , p5_a101  NUMBER := 0-1962.0724
1500     , p5_a102  DATE := fnd_api.g_miss_date
1501     , p5_a103  NUMBER := 0-1962.0724
1502     , p5_a104  NUMBER := 0-1962.0724
1503   );
1504   procedure create_contract_line(p_api_version  NUMBER
1505     , p_init_msg_list  VARCHAR2
1506     , x_return_status out nocopy  VARCHAR2
1507     , x_msg_count out nocopy  NUMBER
1508     , x_msg_data out nocopy  VARCHAR2
1509     , p_restricted_update  VARCHAR2
1510     , p7_a0 out nocopy  NUMBER
1511     , p7_a1 out nocopy  NUMBER
1512     , p7_a2 out nocopy  VARCHAR2
1513     , p7_a3 out nocopy  NUMBER
1514     , p7_a4 out nocopy  NUMBER
1515     , p7_a5 out nocopy  NUMBER
1516     , p7_a6 out nocopy  NUMBER
1517     , p7_a7 out nocopy  NUMBER
1518     , p7_a8 out nocopy  VARCHAR2
1519     , p7_a9 out nocopy  VARCHAR2
1520     , p7_a10 out nocopy  NUMBER
1521     , p7_a11 out nocopy  VARCHAR2
1522     , p7_a12 out nocopy  NUMBER
1523     , p7_a13 out nocopy  VARCHAR2
1524     , p7_a14 out nocopy  VARCHAR2
1525     , p7_a15 out nocopy  VARCHAR2
1526     , p7_a16 out nocopy  VARCHAR2
1527     , p7_a17 out nocopy  VARCHAR2
1528     , p7_a18 out nocopy  NUMBER
1529     , p7_a19 out nocopy  NUMBER
1530     , p7_a20 out nocopy  NUMBER
1531     , p7_a21 out nocopy  NUMBER
1532     , p7_a22 out nocopy  VARCHAR2
1533     , p7_a23 out nocopy  VARCHAR2
1534     , p7_a24 out nocopy  VARCHAR2
1535     , p7_a25 out nocopy  VARCHAR2
1536     , p7_a26 out nocopy  VARCHAR2
1537     , p7_a27 out nocopy  VARCHAR2
1538     , p7_a28 out nocopy  DATE
1539     , p7_a29 out nocopy  VARCHAR2
1540     , p7_a30 out nocopy  DATE
1541     , p7_a31 out nocopy  DATE
1542     , p7_a32 out nocopy  DATE
1543     , p7_a33 out nocopy  VARCHAR2
1544     , p7_a34 out nocopy  NUMBER
1545     , p7_a35 out nocopy  VARCHAR2
1546     , p7_a36 out nocopy  NUMBER
1547     , p7_a37 out nocopy  VARCHAR2
1548     , p7_a38 out nocopy  VARCHAR2
1549     , p7_a39 out nocopy  VARCHAR2
1550     , p7_a40 out nocopy  VARCHAR2
1551     , p7_a41 out nocopy  VARCHAR2
1552     , p7_a42 out nocopy  VARCHAR2
1553     , p7_a43 out nocopy  VARCHAR2
1554     , p7_a44 out nocopy  VARCHAR2
1555     , p7_a45 out nocopy  VARCHAR2
1556     , p7_a46 out nocopy  VARCHAR2
1557     , p7_a47 out nocopy  VARCHAR2
1558     , p7_a48 out nocopy  VARCHAR2
1559     , p7_a49 out nocopy  VARCHAR2
1560     , p7_a50 out nocopy  VARCHAR2
1561     , p7_a51 out nocopy  VARCHAR2
1562     , p7_a52 out nocopy  VARCHAR2
1563     , p7_a53 out nocopy  VARCHAR2
1564     , p7_a54 out nocopy  NUMBER
1565     , p7_a55 out nocopy  DATE
1566     , p7_a56 out nocopy  NUMBER
1567     , p7_a57 out nocopy  DATE
1568     , p7_a58 out nocopy  VARCHAR2
1569     , p7_a59 out nocopy  VARCHAR2
1570     , p7_a60 out nocopy  VARCHAR2
1571     , p7_a61 out nocopy  NUMBER
1572     , p7_a62 out nocopy  VARCHAR2
1573     , p7_a63 out nocopy  VARCHAR2
1574     , p7_a64 out nocopy  VARCHAR2
1575     , p7_a65 out nocopy  VARCHAR2
1576     , p7_a66 out nocopy  VARCHAR2
1577     , p7_a67 out nocopy  NUMBER
1578     , p7_a68 out nocopy  NUMBER
1579     , p7_a69 out nocopy  NUMBER
1580     , p7_a70 out nocopy  DATE
1581     , p7_a71 out nocopy  NUMBER
1582     , p7_a72 out nocopy  DATE
1583     , p7_a73 out nocopy  NUMBER
1584     , p7_a74 out nocopy  NUMBER
1585     , p7_a75 out nocopy  VARCHAR2
1586     , p7_a76 out nocopy  VARCHAR2
1587     , p7_a77 out nocopy  NUMBER
1588     , p7_a78 out nocopy  NUMBER
1589     , p7_a79 out nocopy  VARCHAR2
1590     , p7_a80 out nocopy  VARCHAR2
1591     , p7_a81 out nocopy  NUMBER
1592     , p7_a82 out nocopy  VARCHAR2
1593     , p7_a83 out nocopy  NUMBER
1594     , p7_a84 out nocopy  NUMBER
1595     , p7_a85 out nocopy  NUMBER
1596     , p7_a86 out nocopy  NUMBER
1597     , p7_a87 out nocopy  VARCHAR2
1598     , p7_a88 out nocopy  NUMBER
1599     , p7_a89 out nocopy  NUMBER
1600     , p6_a0  NUMBER := 0-1962.0724
1601     , p6_a1  NUMBER := 0-1962.0724
1602     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
1603     , p6_a3  NUMBER := 0-1962.0724
1604     , p6_a4  NUMBER := 0-1962.0724
1605     , p6_a5  NUMBER := 0-1962.0724
1606     , p6_a6  NUMBER := 0-1962.0724
1607     , p6_a7  NUMBER := 0-1962.0724
1608     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
1609     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
1610     , p6_a10  NUMBER := 0-1962.0724
1611     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
1612     , p6_a12  NUMBER := 0-1962.0724
1613     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
1614     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
1615     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
1616     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
1617     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
1618     , p6_a18  NUMBER := 0-1962.0724
1619     , p6_a19  NUMBER := 0-1962.0724
1620     , p6_a20  NUMBER := 0-1962.0724
1621     , p6_a21  NUMBER := 0-1962.0724
1622     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
1623     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
1624     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
1625     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
1626     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
1627     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
1628     , p6_a28  DATE := fnd_api.g_miss_date
1629     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
1630     , p6_a30  DATE := fnd_api.g_miss_date
1631     , p6_a31  DATE := fnd_api.g_miss_date
1632     , p6_a32  DATE := fnd_api.g_miss_date
1633     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
1634     , p6_a34  NUMBER := 0-1962.0724
1635     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
1636     , p6_a36  NUMBER := 0-1962.0724
1637     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
1638     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
1639     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
1640     , p6_a40  VARCHAR2 := fnd_api.g_miss_char
1641     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
1642     , p6_a42  VARCHAR2 := fnd_api.g_miss_char
1643     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
1644     , p6_a44  VARCHAR2 := fnd_api.g_miss_char
1645     , p6_a45  VARCHAR2 := fnd_api.g_miss_char
1646     , p6_a46  VARCHAR2 := fnd_api.g_miss_char
1647     , p6_a47  VARCHAR2 := fnd_api.g_miss_char
1648     , p6_a48  VARCHAR2 := fnd_api.g_miss_char
1649     , p6_a49  VARCHAR2 := fnd_api.g_miss_char
1650     , p6_a50  VARCHAR2 := fnd_api.g_miss_char
1651     , p6_a51  VARCHAR2 := fnd_api.g_miss_char
1652     , p6_a52  VARCHAR2 := fnd_api.g_miss_char
1653     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
1654     , p6_a54  NUMBER := 0-1962.0724
1655     , p6_a55  DATE := fnd_api.g_miss_date
1656     , p6_a56  NUMBER := 0-1962.0724
1657     , p6_a57  DATE := fnd_api.g_miss_date
1658     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
1659     , p6_a59  VARCHAR2 := fnd_api.g_miss_char
1660     , p6_a60  VARCHAR2 := fnd_api.g_miss_char
1661     , p6_a61  NUMBER := 0-1962.0724
1662     , p6_a62  VARCHAR2 := fnd_api.g_miss_char
1663     , p6_a63  VARCHAR2 := fnd_api.g_miss_char
1664     , p6_a64  VARCHAR2 := fnd_api.g_miss_char
1665     , p6_a65  VARCHAR2 := fnd_api.g_miss_char
1666     , p6_a66  VARCHAR2 := fnd_api.g_miss_char
1667     , p6_a67  NUMBER := 0-1962.0724
1668     , p6_a68  NUMBER := 0-1962.0724
1669     , p6_a69  NUMBER := 0-1962.0724
1670     , p6_a70  DATE := fnd_api.g_miss_date
1671     , p6_a71  NUMBER := 0-1962.0724
1672     , p6_a72  DATE := fnd_api.g_miss_date
1673     , p6_a73  NUMBER := 0-1962.0724
1674     , p6_a74  NUMBER := 0-1962.0724
1675     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
1676     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
1677     , p6_a77  NUMBER := 0-1962.0724
1678     , p6_a78  NUMBER := 0-1962.0724
1679     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
1680     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
1681     , p6_a81  NUMBER := 0-1962.0724
1682     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
1683     , p6_a83  NUMBER := 0-1962.0724
1684     , p6_a84  NUMBER := 0-1962.0724
1685     , p6_a85  NUMBER := 0-1962.0724
1686     , p6_a86  NUMBER := 0-1962.0724
1687     , p6_a87  VARCHAR2 := fnd_api.g_miss_char
1688     , p6_a88  NUMBER := 0-1962.0724
1689     , p6_a89  NUMBER := 0-1962.0724
1690   );
1691   procedure create_contract_line(p_api_version  NUMBER
1692     , p_init_msg_list  VARCHAR2
1693     , x_return_status out nocopy  VARCHAR2
1694     , x_msg_count out nocopy  NUMBER
1695     , x_msg_data out nocopy  VARCHAR2
1696     , p_restricted_update  VARCHAR2
1697     , p6_a0 JTF_NUMBER_TABLE
1698     , p6_a1 JTF_NUMBER_TABLE
1699     , p6_a2 JTF_VARCHAR2_TABLE_100
1700     , p6_a3 JTF_NUMBER_TABLE
1701     , p6_a4 JTF_NUMBER_TABLE
1702     , p6_a5 JTF_NUMBER_TABLE
1703     , p6_a6 JTF_NUMBER_TABLE
1704     , p6_a7 JTF_NUMBER_TABLE
1705     , p6_a8 JTF_VARCHAR2_TABLE_200
1706     , p6_a9 JTF_VARCHAR2_TABLE_100
1707     , p6_a10 JTF_NUMBER_TABLE
1708     , p6_a11 JTF_VARCHAR2_TABLE_100
1709     , p6_a12 JTF_NUMBER_TABLE
1710     , p6_a13 JTF_VARCHAR2_TABLE_2000
1711     , p6_a14 JTF_VARCHAR2_TABLE_2000
1712     , p6_a15 JTF_VARCHAR2_TABLE_2000
1713     , p6_a16 JTF_VARCHAR2_TABLE_300
1714     , p6_a17 JTF_VARCHAR2_TABLE_100
1715     , p6_a18 JTF_NUMBER_TABLE
1716     , p6_a19 JTF_NUMBER_TABLE
1717     , p6_a20 JTF_NUMBER_TABLE
1718     , p6_a21 JTF_NUMBER_TABLE
1719     , p6_a22 JTF_VARCHAR2_TABLE_100
1720     , p6_a23 JTF_VARCHAR2_TABLE_100
1721     , p6_a24 JTF_VARCHAR2_TABLE_100
1722     , p6_a25 JTF_VARCHAR2_TABLE_2000
1723     , p6_a26 JTF_VARCHAR2_TABLE_100
1724     , p6_a27 JTF_VARCHAR2_TABLE_200
1725     , p6_a28 JTF_DATE_TABLE
1726     , p6_a29 JTF_VARCHAR2_TABLE_200
1727     , p6_a30 JTF_DATE_TABLE
1728     , p6_a31 JTF_DATE_TABLE
1729     , p6_a32 JTF_DATE_TABLE
1730     , p6_a33 JTF_VARCHAR2_TABLE_100
1731     , p6_a34 JTF_NUMBER_TABLE
1732     , p6_a35 JTF_VARCHAR2_TABLE_100
1733     , p6_a36 JTF_NUMBER_TABLE
1734     , p6_a37 JTF_VARCHAR2_TABLE_100
1735     , p6_a38 JTF_VARCHAR2_TABLE_100
1736     , p6_a39 JTF_VARCHAR2_TABLE_500
1737     , p6_a40 JTF_VARCHAR2_TABLE_500
1738     , p6_a41 JTF_VARCHAR2_TABLE_500
1739     , p6_a42 JTF_VARCHAR2_TABLE_500
1740     , p6_a43 JTF_VARCHAR2_TABLE_500
1741     , p6_a44 JTF_VARCHAR2_TABLE_500
1742     , p6_a45 JTF_VARCHAR2_TABLE_500
1743     , p6_a46 JTF_VARCHAR2_TABLE_500
1744     , p6_a47 JTF_VARCHAR2_TABLE_500
1745     , p6_a48 JTF_VARCHAR2_TABLE_500
1746     , p6_a49 JTF_VARCHAR2_TABLE_500
1747     , p6_a50 JTF_VARCHAR2_TABLE_500
1748     , p6_a51 JTF_VARCHAR2_TABLE_500
1749     , p6_a52 JTF_VARCHAR2_TABLE_500
1750     , p6_a53 JTF_VARCHAR2_TABLE_500
1751     , p6_a54 JTF_NUMBER_TABLE
1752     , p6_a55 JTF_DATE_TABLE
1753     , p6_a56 JTF_NUMBER_TABLE
1754     , p6_a57 JTF_DATE_TABLE
1755     , p6_a58 JTF_VARCHAR2_TABLE_100
1756     , p6_a59 JTF_VARCHAR2_TABLE_100
1757     , p6_a60 JTF_VARCHAR2_TABLE_100
1758     , p6_a61 JTF_NUMBER_TABLE
1759     , p6_a62 JTF_VARCHAR2_TABLE_100
1760     , p6_a63 JTF_VARCHAR2_TABLE_100
1761     , p6_a64 JTF_VARCHAR2_TABLE_100
1762     , p6_a65 JTF_VARCHAR2_TABLE_100
1763     , p6_a66 JTF_VARCHAR2_TABLE_100
1764     , p6_a67 JTF_NUMBER_TABLE
1765     , p6_a68 JTF_NUMBER_TABLE
1766     , p6_a69 JTF_NUMBER_TABLE
1767     , p6_a70 JTF_DATE_TABLE
1768     , p6_a71 JTF_NUMBER_TABLE
1769     , p6_a72 JTF_DATE_TABLE
1770     , p6_a73 JTF_NUMBER_TABLE
1771     , p6_a74 JTF_NUMBER_TABLE
1772     , p6_a75 JTF_VARCHAR2_TABLE_100
1773     , p6_a76 JTF_VARCHAR2_TABLE_100
1774     , p6_a77 JTF_NUMBER_TABLE
1775     , p6_a78 JTF_NUMBER_TABLE
1776     , p6_a79 JTF_VARCHAR2_TABLE_100
1777     , p6_a80 JTF_VARCHAR2_TABLE_100
1778     , p6_a81 JTF_NUMBER_TABLE
1779     , p6_a82 JTF_VARCHAR2_TABLE_100
1780     , p6_a83 JTF_NUMBER_TABLE
1781     , p6_a84 JTF_NUMBER_TABLE
1782     , p6_a85 JTF_NUMBER_TABLE
1783     , p6_a86 JTF_NUMBER_TABLE
1784     , p6_a87 JTF_VARCHAR2_TABLE_100
1785     , p6_a88 JTF_NUMBER_TABLE
1786     , p6_a89 JTF_NUMBER_TABLE
1787     , p7_a0 out nocopy JTF_NUMBER_TABLE
1788     , p7_a1 out nocopy JTF_NUMBER_TABLE
1789     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1790     , p7_a3 out nocopy JTF_NUMBER_TABLE
1791     , p7_a4 out nocopy JTF_NUMBER_TABLE
1792     , p7_a5 out nocopy JTF_NUMBER_TABLE
1793     , p7_a6 out nocopy JTF_NUMBER_TABLE
1794     , p7_a7 out nocopy JTF_NUMBER_TABLE
1795     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
1796     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1797     , p7_a10 out nocopy JTF_NUMBER_TABLE
1798     , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
1799     , p7_a12 out nocopy JTF_NUMBER_TABLE
1800     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
1801     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1802     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
1803     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
1804     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
1805     , p7_a18 out nocopy JTF_NUMBER_TABLE
1806     , p7_a19 out nocopy JTF_NUMBER_TABLE
1807     , p7_a20 out nocopy JTF_NUMBER_TABLE
1808     , p7_a21 out nocopy JTF_NUMBER_TABLE
1809     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
1810     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
1811     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
1812     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1813     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
1814     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
1815     , p7_a28 out nocopy JTF_DATE_TABLE
1816     , p7_a29 out nocopy JTF_VARCHAR2_TABLE_200
1817     , p7_a30 out nocopy JTF_DATE_TABLE
1818     , p7_a31 out nocopy JTF_DATE_TABLE
1819     , p7_a32 out nocopy JTF_DATE_TABLE
1820     , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
1821     , p7_a34 out nocopy JTF_NUMBER_TABLE
1822     , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
1823     , p7_a36 out nocopy JTF_NUMBER_TABLE
1824     , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
1825     , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
1826     , p7_a39 out nocopy JTF_VARCHAR2_TABLE_500
1827     , p7_a40 out nocopy JTF_VARCHAR2_TABLE_500
1828     , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
1829     , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
1830     , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500
1831     , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500
1832     , p7_a45 out nocopy JTF_VARCHAR2_TABLE_500
1833     , p7_a46 out nocopy JTF_VARCHAR2_TABLE_500
1834     , p7_a47 out nocopy JTF_VARCHAR2_TABLE_500
1835     , p7_a48 out nocopy JTF_VARCHAR2_TABLE_500
1836     , p7_a49 out nocopy JTF_VARCHAR2_TABLE_500
1837     , p7_a50 out nocopy JTF_VARCHAR2_TABLE_500
1838     , p7_a51 out nocopy JTF_VARCHAR2_TABLE_500
1839     , p7_a52 out nocopy JTF_VARCHAR2_TABLE_500
1840     , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
1841     , p7_a54 out nocopy JTF_NUMBER_TABLE
1842     , p7_a55 out nocopy JTF_DATE_TABLE
1843     , p7_a56 out nocopy JTF_NUMBER_TABLE
1844     , p7_a57 out nocopy JTF_DATE_TABLE
1845     , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
1846     , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
1847     , p7_a60 out nocopy JTF_VARCHAR2_TABLE_100
1848     , p7_a61 out nocopy JTF_NUMBER_TABLE
1849     , p7_a62 out nocopy JTF_VARCHAR2_TABLE_100
1850     , p7_a63 out nocopy JTF_VARCHAR2_TABLE_100
1851     , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
1852     , p7_a65 out nocopy JTF_VARCHAR2_TABLE_100
1853     , p7_a66 out nocopy JTF_VARCHAR2_TABLE_100
1854     , p7_a67 out nocopy JTF_NUMBER_TABLE
1855     , p7_a68 out nocopy JTF_NUMBER_TABLE
1856     , p7_a69 out nocopy JTF_NUMBER_TABLE
1857     , p7_a70 out nocopy JTF_DATE_TABLE
1858     , p7_a71 out nocopy JTF_NUMBER_TABLE
1859     , p7_a72 out nocopy JTF_DATE_TABLE
1860     , p7_a73 out nocopy JTF_NUMBER_TABLE
1861     , p7_a74 out nocopy JTF_NUMBER_TABLE
1862     , p7_a75 out nocopy JTF_VARCHAR2_TABLE_100
1863     , p7_a76 out nocopy JTF_VARCHAR2_TABLE_100
1864     , p7_a77 out nocopy JTF_NUMBER_TABLE
1865     , p7_a78 out nocopy JTF_NUMBER_TABLE
1866     , p7_a79 out nocopy JTF_VARCHAR2_TABLE_100
1867     , p7_a80 out nocopy JTF_VARCHAR2_TABLE_100
1868     , p7_a81 out nocopy JTF_NUMBER_TABLE
1869     , p7_a82 out nocopy JTF_VARCHAR2_TABLE_100
1870     , p7_a83 out nocopy JTF_NUMBER_TABLE
1871     , p7_a84 out nocopy JTF_NUMBER_TABLE
1872     , p7_a85 out nocopy JTF_NUMBER_TABLE
1873     , p7_a86 out nocopy JTF_NUMBER_TABLE
1874     , p7_a87 out nocopy JTF_VARCHAR2_TABLE_100
1875     , p7_a88 out nocopy JTF_NUMBER_TABLE
1876     , p7_a89 out nocopy JTF_NUMBER_TABLE
1877   );
1878   procedure update_contract_line(p_api_version  NUMBER
1879     , p_init_msg_list  VARCHAR2
1880     , x_return_status out nocopy  VARCHAR2
1881     , x_msg_count out nocopy  NUMBER
1882     , x_msg_data out nocopy  VARCHAR2
1883     , p_restricted_update  VARCHAR2
1884     , p7_a0 out nocopy  NUMBER
1885     , p7_a1 out nocopy  NUMBER
1886     , p7_a2 out nocopy  VARCHAR2
1887     , p7_a3 out nocopy  NUMBER
1888     , p7_a4 out nocopy  NUMBER
1889     , p7_a5 out nocopy  NUMBER
1890     , p7_a6 out nocopy  NUMBER
1891     , p7_a7 out nocopy  NUMBER
1892     , p7_a8 out nocopy  VARCHAR2
1893     , p7_a9 out nocopy  VARCHAR2
1894     , p7_a10 out nocopy  NUMBER
1895     , p7_a11 out nocopy  VARCHAR2
1896     , p7_a12 out nocopy  NUMBER
1897     , p7_a13 out nocopy  VARCHAR2
1898     , p7_a14 out nocopy  VARCHAR2
1899     , p7_a15 out nocopy  VARCHAR2
1900     , p7_a16 out nocopy  VARCHAR2
1901     , p7_a17 out nocopy  VARCHAR2
1902     , p7_a18 out nocopy  NUMBER
1903     , p7_a19 out nocopy  NUMBER
1904     , p7_a20 out nocopy  NUMBER
1905     , p7_a21 out nocopy  NUMBER
1906     , p7_a22 out nocopy  VARCHAR2
1907     , p7_a23 out nocopy  VARCHAR2
1908     , p7_a24 out nocopy  VARCHAR2
1909     , p7_a25 out nocopy  VARCHAR2
1910     , p7_a26 out nocopy  VARCHAR2
1911     , p7_a27 out nocopy  VARCHAR2
1912     , p7_a28 out nocopy  DATE
1913     , p7_a29 out nocopy  VARCHAR2
1914     , p7_a30 out nocopy  DATE
1915     , p7_a31 out nocopy  DATE
1916     , p7_a32 out nocopy  DATE
1917     , p7_a33 out nocopy  VARCHAR2
1918     , p7_a34 out nocopy  NUMBER
1919     , p7_a35 out nocopy  VARCHAR2
1920     , p7_a36 out nocopy  NUMBER
1921     , p7_a37 out nocopy  VARCHAR2
1922     , p7_a38 out nocopy  VARCHAR2
1923     , p7_a39 out nocopy  VARCHAR2
1924     , p7_a40 out nocopy  VARCHAR2
1925     , p7_a41 out nocopy  VARCHAR2
1926     , p7_a42 out nocopy  VARCHAR2
1927     , p7_a43 out nocopy  VARCHAR2
1928     , p7_a44 out nocopy  VARCHAR2
1929     , p7_a45 out nocopy  VARCHAR2
1930     , p7_a46 out nocopy  VARCHAR2
1931     , p7_a47 out nocopy  VARCHAR2
1932     , p7_a48 out nocopy  VARCHAR2
1933     , p7_a49 out nocopy  VARCHAR2
1934     , p7_a50 out nocopy  VARCHAR2
1935     , p7_a51 out nocopy  VARCHAR2
1936     , p7_a52 out nocopy  VARCHAR2
1937     , p7_a53 out nocopy  VARCHAR2
1938     , p7_a54 out nocopy  NUMBER
1939     , p7_a55 out nocopy  DATE
1940     , p7_a56 out nocopy  NUMBER
1941     , p7_a57 out nocopy  DATE
1942     , p7_a58 out nocopy  VARCHAR2
1943     , p7_a59 out nocopy  VARCHAR2
1944     , p7_a60 out nocopy  VARCHAR2
1945     , p7_a61 out nocopy  NUMBER
1946     , p7_a62 out nocopy  VARCHAR2
1947     , p7_a63 out nocopy  VARCHAR2
1948     , p7_a64 out nocopy  VARCHAR2
1949     , p7_a65 out nocopy  VARCHAR2
1950     , p7_a66 out nocopy  VARCHAR2
1951     , p7_a67 out nocopy  NUMBER
1952     , p7_a68 out nocopy  NUMBER
1953     , p7_a69 out nocopy  NUMBER
1954     , p7_a70 out nocopy  DATE
1955     , p7_a71 out nocopy  NUMBER
1956     , p7_a72 out nocopy  DATE
1957     , p7_a73 out nocopy  NUMBER
1958     , p7_a74 out nocopy  NUMBER
1959     , p7_a75 out nocopy  VARCHAR2
1960     , p7_a76 out nocopy  VARCHAR2
1961     , p7_a77 out nocopy  NUMBER
1962     , p7_a78 out nocopy  NUMBER
1963     , p7_a79 out nocopy  VARCHAR2
1964     , p7_a80 out nocopy  VARCHAR2
1965     , p7_a81 out nocopy  NUMBER
1966     , p7_a82 out nocopy  VARCHAR2
1967     , p7_a83 out nocopy  NUMBER
1968     , p7_a84 out nocopy  NUMBER
1969     , p7_a85 out nocopy  NUMBER
1970     , p7_a86 out nocopy  NUMBER
1971     , p7_a87 out nocopy  VARCHAR2
1972     , p7_a88 out nocopy  NUMBER
1973     , p7_a89 out nocopy  NUMBER
1974     , p6_a0  NUMBER := 0-1962.0724
1975     , p6_a1  NUMBER := 0-1962.0724
1976     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
1977     , p6_a3  NUMBER := 0-1962.0724
1978     , p6_a4  NUMBER := 0-1962.0724
1979     , p6_a5  NUMBER := 0-1962.0724
1980     , p6_a6  NUMBER := 0-1962.0724
1981     , p6_a7  NUMBER := 0-1962.0724
1982     , p6_a8  VARCHAR2 := fnd_api.g_miss_char
1983     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
1984     , p6_a10  NUMBER := 0-1962.0724
1985     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
1986     , p6_a12  NUMBER := 0-1962.0724
1987     , p6_a13  VARCHAR2 := fnd_api.g_miss_char
1988     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
1989     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
1990     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
1991     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
1992     , p6_a18  NUMBER := 0-1962.0724
1993     , p6_a19  NUMBER := 0-1962.0724
1994     , p6_a20  NUMBER := 0-1962.0724
1995     , p6_a21  NUMBER := 0-1962.0724
1996     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
1997     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
1998     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
1999     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
2000     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
2001     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
2002     , p6_a28  DATE := fnd_api.g_miss_date
2003     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
2004     , p6_a30  DATE := fnd_api.g_miss_date
2005     , p6_a31  DATE := fnd_api.g_miss_date
2006     , p6_a32  DATE := fnd_api.g_miss_date
2007     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
2008     , p6_a34  NUMBER := 0-1962.0724
2009     , p6_a35  VARCHAR2 := fnd_api.g_miss_char
2010     , p6_a36  NUMBER := 0-1962.0724
2011     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
2012     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
2013     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
2014     , p6_a40  VARCHAR2 := fnd_api.g_miss_char
2015     , p6_a41  VARCHAR2 := fnd_api.g_miss_char
2016     , p6_a42  VARCHAR2 := fnd_api.g_miss_char
2017     , p6_a43  VARCHAR2 := fnd_api.g_miss_char
2018     , p6_a44  VARCHAR2 := fnd_api.g_miss_char
2019     , p6_a45  VARCHAR2 := fnd_api.g_miss_char
2020     , p6_a46  VARCHAR2 := fnd_api.g_miss_char
2021     , p6_a47  VARCHAR2 := fnd_api.g_miss_char
2022     , p6_a48  VARCHAR2 := fnd_api.g_miss_char
2023     , p6_a49  VARCHAR2 := fnd_api.g_miss_char
2024     , p6_a50  VARCHAR2 := fnd_api.g_miss_char
2025     , p6_a51  VARCHAR2 := fnd_api.g_miss_char
2026     , p6_a52  VARCHAR2 := fnd_api.g_miss_char
2027     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
2028     , p6_a54  NUMBER := 0-1962.0724
2029     , p6_a55  DATE := fnd_api.g_miss_date
2030     , p6_a56  NUMBER := 0-1962.0724
2031     , p6_a57  DATE := fnd_api.g_miss_date
2032     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
2033     , p6_a59  VARCHAR2 := fnd_api.g_miss_char
2034     , p6_a60  VARCHAR2 := fnd_api.g_miss_char
2035     , p6_a61  NUMBER := 0-1962.0724
2036     , p6_a62  VARCHAR2 := fnd_api.g_miss_char
2037     , p6_a63  VARCHAR2 := fnd_api.g_miss_char
2038     , p6_a64  VARCHAR2 := fnd_api.g_miss_char
2039     , p6_a65  VARCHAR2 := fnd_api.g_miss_char
2040     , p6_a66  VARCHAR2 := fnd_api.g_miss_char
2041     , p6_a67  NUMBER := 0-1962.0724
2042     , p6_a68  NUMBER := 0-1962.0724
2043     , p6_a69  NUMBER := 0-1962.0724
2044     , p6_a70  DATE := fnd_api.g_miss_date
2045     , p6_a71  NUMBER := 0-1962.0724
2046     , p6_a72  DATE := fnd_api.g_miss_date
2047     , p6_a73  NUMBER := 0-1962.0724
2048     , p6_a74  NUMBER := 0-1962.0724
2049     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
2050     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
2051     , p6_a77  NUMBER := 0-1962.0724
2052     , p6_a78  NUMBER := 0-1962.0724
2053     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
2054     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
2055     , p6_a81  NUMBER := 0-1962.0724
2056     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
2057     , p6_a83  NUMBER := 0-1962.0724
2058     , p6_a84  NUMBER := 0-1962.0724
2059     , p6_a85  NUMBER := 0-1962.0724
2060     , p6_a86  NUMBER := 0-1962.0724
2061     , p6_a87  VARCHAR2 := fnd_api.g_miss_char
2062     , p6_a88  NUMBER := 0-1962.0724
2063     , p6_a89  NUMBER := 0-1962.0724
2064   );
2065   procedure update_contract_line(p_api_version  NUMBER
2066     , p_init_msg_list  VARCHAR2
2067     , x_return_status out nocopy  VARCHAR2
2068     , x_msg_count out nocopy  NUMBER
2069     , x_msg_data out nocopy  VARCHAR2
2070     , p_restricted_update  VARCHAR2
2071     , p6_a0 JTF_NUMBER_TABLE
2072     , p6_a1 JTF_NUMBER_TABLE
2073     , p6_a2 JTF_VARCHAR2_TABLE_100
2074     , p6_a3 JTF_NUMBER_TABLE
2075     , p6_a4 JTF_NUMBER_TABLE
2076     , p6_a5 JTF_NUMBER_TABLE
2077     , p6_a6 JTF_NUMBER_TABLE
2078     , p6_a7 JTF_NUMBER_TABLE
2079     , p6_a8 JTF_VARCHAR2_TABLE_200
2080     , p6_a9 JTF_VARCHAR2_TABLE_100
2081     , p6_a10 JTF_NUMBER_TABLE
2082     , p6_a11 JTF_VARCHAR2_TABLE_100
2083     , p6_a12 JTF_NUMBER_TABLE
2084     , p6_a13 JTF_VARCHAR2_TABLE_2000
2085     , p6_a14 JTF_VARCHAR2_TABLE_2000
2086     , p6_a15 JTF_VARCHAR2_TABLE_2000
2087     , p6_a16 JTF_VARCHAR2_TABLE_300
2088     , p6_a17 JTF_VARCHAR2_TABLE_100
2089     , p6_a18 JTF_NUMBER_TABLE
2090     , p6_a19 JTF_NUMBER_TABLE
2091     , p6_a20 JTF_NUMBER_TABLE
2092     , p6_a21 JTF_NUMBER_TABLE
2093     , p6_a22 JTF_VARCHAR2_TABLE_100
2094     , p6_a23 JTF_VARCHAR2_TABLE_100
2095     , p6_a24 JTF_VARCHAR2_TABLE_100
2096     , p6_a25 JTF_VARCHAR2_TABLE_2000
2097     , p6_a26 JTF_VARCHAR2_TABLE_100
2098     , p6_a27 JTF_VARCHAR2_TABLE_200
2099     , p6_a28 JTF_DATE_TABLE
2100     , p6_a29 JTF_VARCHAR2_TABLE_200
2101     , p6_a30 JTF_DATE_TABLE
2102     , p6_a31 JTF_DATE_TABLE
2103     , p6_a32 JTF_DATE_TABLE
2104     , p6_a33 JTF_VARCHAR2_TABLE_100
2105     , p6_a34 JTF_NUMBER_TABLE
2106     , p6_a35 JTF_VARCHAR2_TABLE_100
2107     , p6_a36 JTF_NUMBER_TABLE
2108     , p6_a37 JTF_VARCHAR2_TABLE_100
2109     , p6_a38 JTF_VARCHAR2_TABLE_100
2110     , p6_a39 JTF_VARCHAR2_TABLE_500
2111     , p6_a40 JTF_VARCHAR2_TABLE_500
2112     , p6_a41 JTF_VARCHAR2_TABLE_500
2113     , p6_a42 JTF_VARCHAR2_TABLE_500
2114     , p6_a43 JTF_VARCHAR2_TABLE_500
2115     , p6_a44 JTF_VARCHAR2_TABLE_500
2116     , p6_a45 JTF_VARCHAR2_TABLE_500
2117     , p6_a46 JTF_VARCHAR2_TABLE_500
2118     , p6_a47 JTF_VARCHAR2_TABLE_500
2119     , p6_a48 JTF_VARCHAR2_TABLE_500
2120     , p6_a49 JTF_VARCHAR2_TABLE_500
2121     , p6_a50 JTF_VARCHAR2_TABLE_500
2122     , p6_a51 JTF_VARCHAR2_TABLE_500
2123     , p6_a52 JTF_VARCHAR2_TABLE_500
2124     , p6_a53 JTF_VARCHAR2_TABLE_500
2125     , p6_a54 JTF_NUMBER_TABLE
2126     , p6_a55 JTF_DATE_TABLE
2127     , p6_a56 JTF_NUMBER_TABLE
2128     , p6_a57 JTF_DATE_TABLE
2129     , p6_a58 JTF_VARCHAR2_TABLE_100
2130     , p6_a59 JTF_VARCHAR2_TABLE_100
2131     , p6_a60 JTF_VARCHAR2_TABLE_100
2132     , p6_a61 JTF_NUMBER_TABLE
2133     , p6_a62 JTF_VARCHAR2_TABLE_100
2134     , p6_a63 JTF_VARCHAR2_TABLE_100
2135     , p6_a64 JTF_VARCHAR2_TABLE_100
2136     , p6_a65 JTF_VARCHAR2_TABLE_100
2137     , p6_a66 JTF_VARCHAR2_TABLE_100
2138     , p6_a67 JTF_NUMBER_TABLE
2139     , p6_a68 JTF_NUMBER_TABLE
2140     , p6_a69 JTF_NUMBER_TABLE
2141     , p6_a70 JTF_DATE_TABLE
2142     , p6_a71 JTF_NUMBER_TABLE
2143     , p6_a72 JTF_DATE_TABLE
2144     , p6_a73 JTF_NUMBER_TABLE
2145     , p6_a74 JTF_NUMBER_TABLE
2146     , p6_a75 JTF_VARCHAR2_TABLE_100
2147     , p6_a76 JTF_VARCHAR2_TABLE_100
2148     , p6_a77 JTF_NUMBER_TABLE
2149     , p6_a78 JTF_NUMBER_TABLE
2150     , p6_a79 JTF_VARCHAR2_TABLE_100
2151     , p6_a80 JTF_VARCHAR2_TABLE_100
2152     , p6_a81 JTF_NUMBER_TABLE
2153     , p6_a82 JTF_VARCHAR2_TABLE_100
2154     , p6_a83 JTF_NUMBER_TABLE
2155     , p6_a84 JTF_NUMBER_TABLE
2156     , p6_a85 JTF_NUMBER_TABLE
2157     , p6_a86 JTF_NUMBER_TABLE
2158     , p6_a87 JTF_VARCHAR2_TABLE_100
2159     , p6_a88 JTF_NUMBER_TABLE
2160     , p6_a89 JTF_NUMBER_TABLE
2161     , p7_a0 out nocopy JTF_NUMBER_TABLE
2162     , p7_a1 out nocopy JTF_NUMBER_TABLE
2163     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
2164     , p7_a3 out nocopy JTF_NUMBER_TABLE
2165     , p7_a4 out nocopy JTF_NUMBER_TABLE
2166     , p7_a5 out nocopy JTF_NUMBER_TABLE
2167     , p7_a6 out nocopy JTF_NUMBER_TABLE
2168     , p7_a7 out nocopy JTF_NUMBER_TABLE
2169     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
2170     , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
2171     , p7_a10 out nocopy JTF_NUMBER_TABLE
2172     , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
2173     , p7_a12 out nocopy JTF_NUMBER_TABLE
2174     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
2175     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
2176     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_2000
2177     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_300
2178     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
2179     , p7_a18 out nocopy JTF_NUMBER_TABLE
2180     , p7_a19 out nocopy JTF_NUMBER_TABLE
2181     , p7_a20 out nocopy JTF_NUMBER_TABLE
2182     , p7_a21 out nocopy JTF_NUMBER_TABLE
2183     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
2184     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
2185     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
2186     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
2187     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
2188     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
2189     , p7_a28 out nocopy JTF_DATE_TABLE
2190     , p7_a29 out nocopy JTF_VARCHAR2_TABLE_200
2191     , p7_a30 out nocopy JTF_DATE_TABLE
2192     , p7_a31 out nocopy JTF_DATE_TABLE
2193     , p7_a32 out nocopy JTF_DATE_TABLE
2194     , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
2195     , p7_a34 out nocopy JTF_NUMBER_TABLE
2196     , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
2197     , p7_a36 out nocopy JTF_NUMBER_TABLE
2198     , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
2199     , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
2200     , p7_a39 out nocopy JTF_VARCHAR2_TABLE_500
2201     , p7_a40 out nocopy JTF_VARCHAR2_TABLE_500
2202     , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
2203     , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
2204     , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500
2205     , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500
2206     , p7_a45 out nocopy JTF_VARCHAR2_TABLE_500
2207     , p7_a46 out nocopy JTF_VARCHAR2_TABLE_500
2208     , p7_a47 out nocopy JTF_VARCHAR2_TABLE_500
2209     , p7_a48 out nocopy JTF_VARCHAR2_TABLE_500
2210     , p7_a49 out nocopy JTF_VARCHAR2_TABLE_500
2211     , p7_a50 out nocopy JTF_VARCHAR2_TABLE_500
2212     , p7_a51 out nocopy JTF_VARCHAR2_TABLE_500
2213     , p7_a52 out nocopy JTF_VARCHAR2_TABLE_500
2214     , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
2215     , p7_a54 out nocopy JTF_NUMBER_TABLE
2216     , p7_a55 out nocopy JTF_DATE_TABLE
2217     , p7_a56 out nocopy JTF_NUMBER_TABLE
2218     , p7_a57 out nocopy JTF_DATE_TABLE
2219     , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
2220     , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
2221     , p7_a60 out nocopy JTF_VARCHAR2_TABLE_100
2222     , p7_a61 out nocopy JTF_NUMBER_TABLE
2223     , p7_a62 out nocopy JTF_VARCHAR2_TABLE_100
2224     , p7_a63 out nocopy JTF_VARCHAR2_TABLE_100
2225     , p7_a64 out nocopy JTF_VARCHAR2_TABLE_100
2226     , p7_a65 out nocopy JTF_VARCHAR2_TABLE_100
2227     , p7_a66 out nocopy JTF_VARCHAR2_TABLE_100
2228     , p7_a67 out nocopy JTF_NUMBER_TABLE
2229     , p7_a68 out nocopy JTF_NUMBER_TABLE
2230     , p7_a69 out nocopy JTF_NUMBER_TABLE
2231     , p7_a70 out nocopy JTF_DATE_TABLE
2232     , p7_a71 out nocopy JTF_NUMBER_TABLE
2233     , p7_a72 out nocopy JTF_DATE_TABLE
2234     , p7_a73 out nocopy JTF_NUMBER_TABLE
2235     , p7_a74 out nocopy JTF_NUMBER_TABLE
2236     , p7_a75 out nocopy JTF_VARCHAR2_TABLE_100
2237     , p7_a76 out nocopy JTF_VARCHAR2_TABLE_100
2238     , p7_a77 out nocopy JTF_NUMBER_TABLE
2239     , p7_a78 out nocopy JTF_NUMBER_TABLE
2240     , p7_a79 out nocopy JTF_VARCHAR2_TABLE_100
2241     , p7_a80 out nocopy JTF_VARCHAR2_TABLE_100
2242     , p7_a81 out nocopy JTF_NUMBER_TABLE
2243     , p7_a82 out nocopy JTF_VARCHAR2_TABLE_100
2244     , p7_a83 out nocopy JTF_NUMBER_TABLE
2245     , p7_a84 out nocopy JTF_NUMBER_TABLE
2246     , p7_a85 out nocopy JTF_NUMBER_TABLE
2247     , p7_a86 out nocopy JTF_NUMBER_TABLE
2248     , p7_a87 out nocopy JTF_VARCHAR2_TABLE_100
2249     , p7_a88 out nocopy JTF_NUMBER_TABLE
2250     , p7_a89 out nocopy JTF_NUMBER_TABLE
2251   );
2252   procedure delete_contract_line(p_api_version  NUMBER
2253     , p_init_msg_list  VARCHAR2
2254     , x_return_status out nocopy  VARCHAR2
2255     , x_msg_count out nocopy  NUMBER
2256     , x_msg_data out nocopy  VARCHAR2
2257     , p5_a0  NUMBER := 0-1962.0724
2258     , p5_a1  NUMBER := 0-1962.0724
2259     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
2260     , p5_a3  NUMBER := 0-1962.0724
2261     , p5_a4  NUMBER := 0-1962.0724
2262     , p5_a5  NUMBER := 0-1962.0724
2263     , p5_a6  NUMBER := 0-1962.0724
2264     , p5_a7  NUMBER := 0-1962.0724
2265     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2266     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
2267     , p5_a10  NUMBER := 0-1962.0724
2268     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
2269     , p5_a12  NUMBER := 0-1962.0724
2270     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2271     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2272     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2273     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2274     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2275     , p5_a18  NUMBER := 0-1962.0724
2276     , p5_a19  NUMBER := 0-1962.0724
2277     , p5_a20  NUMBER := 0-1962.0724
2278     , p5_a21  NUMBER := 0-1962.0724
2279     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2280     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2281     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2282     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2283     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2284     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2285     , p5_a28  DATE := fnd_api.g_miss_date
2286     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2287     , p5_a30  DATE := fnd_api.g_miss_date
2288     , p5_a31  DATE := fnd_api.g_miss_date
2289     , p5_a32  DATE := fnd_api.g_miss_date
2290     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
2291     , p5_a34  NUMBER := 0-1962.0724
2292     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
2293     , p5_a36  NUMBER := 0-1962.0724
2294     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
2295     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
2296     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
2297     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
2298     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
2299     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
2300     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
2301     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
2302     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2303     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2304     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
2305     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2306     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
2307     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2308     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
2309     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
2310     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
2311     , p5_a54  NUMBER := 0-1962.0724
2312     , p5_a55  DATE := fnd_api.g_miss_date
2313     , p5_a56  NUMBER := 0-1962.0724
2314     , p5_a57  DATE := fnd_api.g_miss_date
2315     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
2316     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
2317     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
2318     , p5_a61  NUMBER := 0-1962.0724
2319     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
2320     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
2321     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
2322     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
2323     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
2324     , p5_a67  NUMBER := 0-1962.0724
2325     , p5_a68  NUMBER := 0-1962.0724
2326     , p5_a69  NUMBER := 0-1962.0724
2327     , p5_a70  DATE := fnd_api.g_miss_date
2328     , p5_a71  NUMBER := 0-1962.0724
2329     , p5_a72  DATE := fnd_api.g_miss_date
2330     , p5_a73  NUMBER := 0-1962.0724
2331     , p5_a74  NUMBER := 0-1962.0724
2332     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
2333     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
2334     , p5_a77  NUMBER := 0-1962.0724
2335     , p5_a78  NUMBER := 0-1962.0724
2336     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
2337     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
2338     , p5_a81  NUMBER := 0-1962.0724
2339     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
2340     , p5_a83  NUMBER := 0-1962.0724
2341     , p5_a84  NUMBER := 0-1962.0724
2342     , p5_a85  NUMBER := 0-1962.0724
2343     , p5_a86  NUMBER := 0-1962.0724
2344     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
2345     , p5_a88  NUMBER := 0-1962.0724
2346     , p5_a89  NUMBER := 0-1962.0724
2347   );
2348   procedure delete_contract_line(p_api_version  NUMBER
2349     , p_init_msg_list  VARCHAR2
2350     , x_return_status out nocopy  VARCHAR2
2351     , x_msg_count out nocopy  NUMBER
2352     , x_msg_data out nocopy  VARCHAR2
2353     , p5_a0 JTF_NUMBER_TABLE
2354     , p5_a1 JTF_NUMBER_TABLE
2355     , p5_a2 JTF_VARCHAR2_TABLE_100
2356     , p5_a3 JTF_NUMBER_TABLE
2357     , p5_a4 JTF_NUMBER_TABLE
2358     , p5_a5 JTF_NUMBER_TABLE
2359     , p5_a6 JTF_NUMBER_TABLE
2360     , p5_a7 JTF_NUMBER_TABLE
2361     , p5_a8 JTF_VARCHAR2_TABLE_200
2362     , p5_a9 JTF_VARCHAR2_TABLE_100
2363     , p5_a10 JTF_NUMBER_TABLE
2364     , p5_a11 JTF_VARCHAR2_TABLE_100
2365     , p5_a12 JTF_NUMBER_TABLE
2366     , p5_a13 JTF_VARCHAR2_TABLE_2000
2367     , p5_a14 JTF_VARCHAR2_TABLE_2000
2368     , p5_a15 JTF_VARCHAR2_TABLE_2000
2369     , p5_a16 JTF_VARCHAR2_TABLE_300
2370     , p5_a17 JTF_VARCHAR2_TABLE_100
2371     , p5_a18 JTF_NUMBER_TABLE
2372     , p5_a19 JTF_NUMBER_TABLE
2373     , p5_a20 JTF_NUMBER_TABLE
2374     , p5_a21 JTF_NUMBER_TABLE
2375     , p5_a22 JTF_VARCHAR2_TABLE_100
2376     , p5_a23 JTF_VARCHAR2_TABLE_100
2377     , p5_a24 JTF_VARCHAR2_TABLE_100
2378     , p5_a25 JTF_VARCHAR2_TABLE_2000
2379     , p5_a26 JTF_VARCHAR2_TABLE_100
2380     , p5_a27 JTF_VARCHAR2_TABLE_200
2381     , p5_a28 JTF_DATE_TABLE
2382     , p5_a29 JTF_VARCHAR2_TABLE_200
2383     , p5_a30 JTF_DATE_TABLE
2384     , p5_a31 JTF_DATE_TABLE
2385     , p5_a32 JTF_DATE_TABLE
2386     , p5_a33 JTF_VARCHAR2_TABLE_100
2387     , p5_a34 JTF_NUMBER_TABLE
2388     , p5_a35 JTF_VARCHAR2_TABLE_100
2389     , p5_a36 JTF_NUMBER_TABLE
2390     , p5_a37 JTF_VARCHAR2_TABLE_100
2391     , p5_a38 JTF_VARCHAR2_TABLE_100
2392     , p5_a39 JTF_VARCHAR2_TABLE_500
2393     , p5_a40 JTF_VARCHAR2_TABLE_500
2394     , p5_a41 JTF_VARCHAR2_TABLE_500
2395     , p5_a42 JTF_VARCHAR2_TABLE_500
2396     , p5_a43 JTF_VARCHAR2_TABLE_500
2397     , p5_a44 JTF_VARCHAR2_TABLE_500
2398     , p5_a45 JTF_VARCHAR2_TABLE_500
2399     , p5_a46 JTF_VARCHAR2_TABLE_500
2400     , p5_a47 JTF_VARCHAR2_TABLE_500
2401     , p5_a48 JTF_VARCHAR2_TABLE_500
2402     , p5_a49 JTF_VARCHAR2_TABLE_500
2403     , p5_a50 JTF_VARCHAR2_TABLE_500
2404     , p5_a51 JTF_VARCHAR2_TABLE_500
2405     , p5_a52 JTF_VARCHAR2_TABLE_500
2406     , p5_a53 JTF_VARCHAR2_TABLE_500
2407     , p5_a54 JTF_NUMBER_TABLE
2408     , p5_a55 JTF_DATE_TABLE
2409     , p5_a56 JTF_NUMBER_TABLE
2410     , p5_a57 JTF_DATE_TABLE
2411     , p5_a58 JTF_VARCHAR2_TABLE_100
2412     , p5_a59 JTF_VARCHAR2_TABLE_100
2413     , p5_a60 JTF_VARCHAR2_TABLE_100
2414     , p5_a61 JTF_NUMBER_TABLE
2415     , p5_a62 JTF_VARCHAR2_TABLE_100
2416     , p5_a63 JTF_VARCHAR2_TABLE_100
2417     , p5_a64 JTF_VARCHAR2_TABLE_100
2418     , p5_a65 JTF_VARCHAR2_TABLE_100
2419     , p5_a66 JTF_VARCHAR2_TABLE_100
2420     , p5_a67 JTF_NUMBER_TABLE
2421     , p5_a68 JTF_NUMBER_TABLE
2422     , p5_a69 JTF_NUMBER_TABLE
2423     , p5_a70 JTF_DATE_TABLE
2424     , p5_a71 JTF_NUMBER_TABLE
2425     , p5_a72 JTF_DATE_TABLE
2426     , p5_a73 JTF_NUMBER_TABLE
2427     , p5_a74 JTF_NUMBER_TABLE
2428     , p5_a75 JTF_VARCHAR2_TABLE_100
2429     , p5_a76 JTF_VARCHAR2_TABLE_100
2430     , p5_a77 JTF_NUMBER_TABLE
2431     , p5_a78 JTF_NUMBER_TABLE
2432     , p5_a79 JTF_VARCHAR2_TABLE_100
2433     , p5_a80 JTF_VARCHAR2_TABLE_100
2434     , p5_a81 JTF_NUMBER_TABLE
2435     , p5_a82 JTF_VARCHAR2_TABLE_100
2436     , p5_a83 JTF_NUMBER_TABLE
2437     , p5_a84 JTF_NUMBER_TABLE
2438     , p5_a85 JTF_NUMBER_TABLE
2439     , p5_a86 JTF_NUMBER_TABLE
2440     , p5_a87 JTF_VARCHAR2_TABLE_100
2441     , p5_a88 JTF_NUMBER_TABLE
2442     , p5_a89 JTF_NUMBER_TABLE
2443   );
2444   procedure lock_contract_line(p_api_version  NUMBER
2445     , p_init_msg_list  VARCHAR2
2446     , x_return_status out nocopy  VARCHAR2
2447     , x_msg_count out nocopy  NUMBER
2448     , x_msg_data out nocopy  VARCHAR2
2449     , p5_a0  NUMBER := 0-1962.0724
2450     , p5_a1  NUMBER := 0-1962.0724
2451     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
2452     , p5_a3  NUMBER := 0-1962.0724
2453     , p5_a4  NUMBER := 0-1962.0724
2454     , p5_a5  NUMBER := 0-1962.0724
2455     , p5_a6  NUMBER := 0-1962.0724
2456     , p5_a7  NUMBER := 0-1962.0724
2457     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2458     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
2459     , p5_a10  NUMBER := 0-1962.0724
2460     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
2461     , p5_a12  NUMBER := 0-1962.0724
2462     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2463     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2464     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2465     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2466     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2467     , p5_a18  NUMBER := 0-1962.0724
2468     , p5_a19  NUMBER := 0-1962.0724
2469     , p5_a20  NUMBER := 0-1962.0724
2470     , p5_a21  NUMBER := 0-1962.0724
2471     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2472     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2473     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2474     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2475     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2476     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2477     , p5_a28  DATE := fnd_api.g_miss_date
2478     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2479     , p5_a30  DATE := fnd_api.g_miss_date
2480     , p5_a31  DATE := fnd_api.g_miss_date
2481     , p5_a32  DATE := fnd_api.g_miss_date
2482     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
2483     , p5_a34  NUMBER := 0-1962.0724
2484     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
2485     , p5_a36  NUMBER := 0-1962.0724
2486     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
2487     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
2488     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
2489     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
2490     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
2491     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
2492     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
2493     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
2494     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2495     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2496     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
2497     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2498     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
2499     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2500     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
2501     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
2502     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
2503     , p5_a54  NUMBER := 0-1962.0724
2504     , p5_a55  DATE := fnd_api.g_miss_date
2505     , p5_a56  NUMBER := 0-1962.0724
2506     , p5_a57  DATE := fnd_api.g_miss_date
2507     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
2508     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
2509     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
2510     , p5_a61  NUMBER := 0-1962.0724
2511     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
2512     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
2513     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
2514     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
2515     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
2516     , p5_a67  NUMBER := 0-1962.0724
2517     , p5_a68  NUMBER := 0-1962.0724
2518     , p5_a69  NUMBER := 0-1962.0724
2519     , p5_a70  DATE := fnd_api.g_miss_date
2520     , p5_a71  NUMBER := 0-1962.0724
2521     , p5_a72  DATE := fnd_api.g_miss_date
2522     , p5_a73  NUMBER := 0-1962.0724
2523     , p5_a74  NUMBER := 0-1962.0724
2524     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
2525     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
2526     , p5_a77  NUMBER := 0-1962.0724
2527     , p5_a78  NUMBER := 0-1962.0724
2528     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
2529     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
2530     , p5_a81  NUMBER := 0-1962.0724
2531     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
2532     , p5_a83  NUMBER := 0-1962.0724
2533     , p5_a84  NUMBER := 0-1962.0724
2534     , p5_a85  NUMBER := 0-1962.0724
2535     , p5_a86  NUMBER := 0-1962.0724
2536     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
2537     , p5_a88  NUMBER := 0-1962.0724
2538     , p5_a89  NUMBER := 0-1962.0724
2539   );
2540   procedure validate_contract_line(p_api_version  NUMBER
2541     , p_init_msg_list  VARCHAR2
2542     , x_return_status out nocopy  VARCHAR2
2543     , x_msg_count out nocopy  NUMBER
2544     , x_msg_data out nocopy  VARCHAR2
2545     , p5_a0  NUMBER := 0-1962.0724
2546     , p5_a1  NUMBER := 0-1962.0724
2547     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
2548     , p5_a3  NUMBER := 0-1962.0724
2549     , p5_a4  NUMBER := 0-1962.0724
2550     , p5_a5  NUMBER := 0-1962.0724
2551     , p5_a6  NUMBER := 0-1962.0724
2552     , p5_a7  NUMBER := 0-1962.0724
2553     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2554     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
2555     , p5_a10  NUMBER := 0-1962.0724
2556     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
2557     , p5_a12  NUMBER := 0-1962.0724
2558     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
2559     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2560     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
2561     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
2562     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
2563     , p5_a18  NUMBER := 0-1962.0724
2564     , p5_a19  NUMBER := 0-1962.0724
2565     , p5_a20  NUMBER := 0-1962.0724
2566     , p5_a21  NUMBER := 0-1962.0724
2567     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
2568     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
2569     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
2570     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
2571     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
2572     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
2573     , p5_a28  DATE := fnd_api.g_miss_date
2574     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
2575     , p5_a30  DATE := fnd_api.g_miss_date
2576     , p5_a31  DATE := fnd_api.g_miss_date
2577     , p5_a32  DATE := fnd_api.g_miss_date
2578     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
2579     , p5_a34  NUMBER := 0-1962.0724
2580     , p5_a35  VARCHAR2 := fnd_api.g_miss_char
2581     , p5_a36  NUMBER := 0-1962.0724
2582     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
2583     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
2584     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
2585     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
2586     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
2587     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
2588     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
2589     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
2590     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
2591     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
2592     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
2593     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
2594     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
2595     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
2596     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
2597     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
2598     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
2599     , p5_a54  NUMBER := 0-1962.0724
2600     , p5_a55  DATE := fnd_api.g_miss_date
2601     , p5_a56  NUMBER := 0-1962.0724
2602     , p5_a57  DATE := fnd_api.g_miss_date
2603     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
2604     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
2605     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
2606     , p5_a61  NUMBER := 0-1962.0724
2607     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
2608     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
2609     , p5_a64  VARCHAR2 := fnd_api.g_miss_char
2610     , p5_a65  VARCHAR2 := fnd_api.g_miss_char
2611     , p5_a66  VARCHAR2 := fnd_api.g_miss_char
2612     , p5_a67  NUMBER := 0-1962.0724
2613     , p5_a68  NUMBER := 0-1962.0724
2614     , p5_a69  NUMBER := 0-1962.0724
2615     , p5_a70  DATE := fnd_api.g_miss_date
2616     , p5_a71  NUMBER := 0-1962.0724
2617     , p5_a72  DATE := fnd_api.g_miss_date
2618     , p5_a73  NUMBER := 0-1962.0724
2619     , p5_a74  NUMBER := 0-1962.0724
2620     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
2621     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
2622     , p5_a77  NUMBER := 0-1962.0724
2623     , p5_a78  NUMBER := 0-1962.0724
2624     , p5_a79  VARCHAR2 := fnd_api.g_miss_char
2625     , p5_a80  VARCHAR2 := fnd_api.g_miss_char
2626     , p5_a81  NUMBER := 0-1962.0724
2627     , p5_a82  VARCHAR2 := fnd_api.g_miss_char
2628     , p5_a83  NUMBER := 0-1962.0724
2629     , p5_a84  NUMBER := 0-1962.0724
2630     , p5_a85  NUMBER := 0-1962.0724
2631     , p5_a86  NUMBER := 0-1962.0724
2632     , p5_a87  VARCHAR2 := fnd_api.g_miss_char
2633     , p5_a88  NUMBER := 0-1962.0724
2634     , p5_a89  NUMBER := 0-1962.0724
2635   );
2636   procedure create_governance(p_api_version  NUMBER
2637     , p_init_msg_list  VARCHAR2
2638     , x_return_status out nocopy  VARCHAR2
2639     , x_msg_count out nocopy  NUMBER
2640     , x_msg_data out nocopy  VARCHAR2
2641     , p6_a0 out nocopy  NUMBER
2642     , p6_a1 out nocopy  NUMBER
2643     , p6_a2 out nocopy  NUMBER
2644     , p6_a3 out nocopy  NUMBER
2645     , p6_a4 out nocopy  NUMBER
2646     , p6_a5 out nocopy  NUMBER
2647     , p6_a6 out nocopy  NUMBER
2648     , p6_a7 out nocopy  NUMBER
2649     , p6_a8 out nocopy  VARCHAR2
2650     , p6_a9 out nocopy  NUMBER
2651     , p6_a10 out nocopy  DATE
2652     , p6_a11 out nocopy  NUMBER
2653     , p6_a12 out nocopy  DATE
2654     , p6_a13 out nocopy  NUMBER
2655     , p5_a0  NUMBER := 0-1962.0724
2656     , p5_a1  NUMBER := 0-1962.0724
2657     , p5_a2  NUMBER := 0-1962.0724
2658     , p5_a3  NUMBER := 0-1962.0724
2659     , p5_a4  NUMBER := 0-1962.0724
2660     , p5_a5  NUMBER := 0-1962.0724
2661     , p5_a6  NUMBER := 0-1962.0724
2662     , p5_a7  NUMBER := 0-1962.0724
2663     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2664     , p5_a9  NUMBER := 0-1962.0724
2665     , p5_a10  DATE := fnd_api.g_miss_date
2666     , p5_a11  NUMBER := 0-1962.0724
2667     , p5_a12  DATE := fnd_api.g_miss_date
2668     , p5_a13  NUMBER := 0-1962.0724
2669   );
2670   procedure update_governance(p_api_version  NUMBER
2671     , p_init_msg_list  VARCHAR2
2672     , x_return_status out nocopy  VARCHAR2
2673     , x_msg_count out nocopy  NUMBER
2674     , x_msg_data out nocopy  VARCHAR2
2675     , p6_a0 out nocopy  NUMBER
2676     , p6_a1 out nocopy  NUMBER
2677     , p6_a2 out nocopy  NUMBER
2678     , p6_a3 out nocopy  NUMBER
2679     , p6_a4 out nocopy  NUMBER
2680     , p6_a5 out nocopy  NUMBER
2681     , p6_a6 out nocopy  NUMBER
2682     , p6_a7 out nocopy  NUMBER
2683     , p6_a8 out nocopy  VARCHAR2
2684     , p6_a9 out nocopy  NUMBER
2685     , p6_a10 out nocopy  DATE
2686     , p6_a11 out nocopy  NUMBER
2687     , p6_a12 out nocopy  DATE
2688     , p6_a13 out nocopy  NUMBER
2689     , p5_a0  NUMBER := 0-1962.0724
2690     , p5_a1  NUMBER := 0-1962.0724
2691     , p5_a2  NUMBER := 0-1962.0724
2692     , p5_a3  NUMBER := 0-1962.0724
2693     , p5_a4  NUMBER := 0-1962.0724
2694     , p5_a5  NUMBER := 0-1962.0724
2695     , p5_a6  NUMBER := 0-1962.0724
2696     , p5_a7  NUMBER := 0-1962.0724
2697     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2698     , p5_a9  NUMBER := 0-1962.0724
2699     , p5_a10  DATE := fnd_api.g_miss_date
2700     , p5_a11  NUMBER := 0-1962.0724
2701     , p5_a12  DATE := fnd_api.g_miss_date
2702     , p5_a13  NUMBER := 0-1962.0724
2703   );
2704   procedure delete_governance(p_api_version  NUMBER
2705     , p_init_msg_list  VARCHAR2
2706     , x_return_status out nocopy  VARCHAR2
2707     , x_msg_count out nocopy  NUMBER
2708     , x_msg_data out nocopy  VARCHAR2
2709     , p5_a0  NUMBER := 0-1962.0724
2710     , p5_a1  NUMBER := 0-1962.0724
2711     , p5_a2  NUMBER := 0-1962.0724
2712     , p5_a3  NUMBER := 0-1962.0724
2713     , p5_a4  NUMBER := 0-1962.0724
2714     , p5_a5  NUMBER := 0-1962.0724
2715     , p5_a6  NUMBER := 0-1962.0724
2716     , p5_a7  NUMBER := 0-1962.0724
2717     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2718     , p5_a9  NUMBER := 0-1962.0724
2719     , p5_a10  DATE := fnd_api.g_miss_date
2720     , p5_a11  NUMBER := 0-1962.0724
2721     , p5_a12  DATE := fnd_api.g_miss_date
2722     , p5_a13  NUMBER := 0-1962.0724
2723   );
2724   procedure lock_governance(p_api_version  NUMBER
2725     , p_init_msg_list  VARCHAR2
2726     , x_return_status out nocopy  VARCHAR2
2727     , x_msg_count out nocopy  NUMBER
2728     , x_msg_data out nocopy  VARCHAR2
2729     , p5_a0  NUMBER := 0-1962.0724
2730     , p5_a1  NUMBER := 0-1962.0724
2731     , p5_a2  NUMBER := 0-1962.0724
2732     , p5_a3  NUMBER := 0-1962.0724
2733     , p5_a4  NUMBER := 0-1962.0724
2734     , p5_a5  NUMBER := 0-1962.0724
2735     , p5_a6  NUMBER := 0-1962.0724
2736     , p5_a7  NUMBER := 0-1962.0724
2737     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2738     , p5_a9  NUMBER := 0-1962.0724
2739     , p5_a10  DATE := fnd_api.g_miss_date
2740     , p5_a11  NUMBER := 0-1962.0724
2741     , p5_a12  DATE := fnd_api.g_miss_date
2742     , p5_a13  NUMBER := 0-1962.0724
2743   );
2744   procedure validate_governance(p_api_version  NUMBER
2745     , p_init_msg_list  VARCHAR2
2746     , x_return_status out nocopy  VARCHAR2
2747     , x_msg_count out nocopy  NUMBER
2748     , x_msg_data out nocopy  VARCHAR2
2749     , p5_a0  NUMBER := 0-1962.0724
2750     , p5_a1  NUMBER := 0-1962.0724
2751     , p5_a2  NUMBER := 0-1962.0724
2752     , p5_a3  NUMBER := 0-1962.0724
2753     , p5_a4  NUMBER := 0-1962.0724
2754     , p5_a5  NUMBER := 0-1962.0724
2755     , p5_a6  NUMBER := 0-1962.0724
2756     , p5_a7  NUMBER := 0-1962.0724
2757     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2758     , p5_a9  NUMBER := 0-1962.0724
2759     , p5_a10  DATE := fnd_api.g_miss_date
2760     , p5_a11  NUMBER := 0-1962.0724
2761     , p5_a12  DATE := fnd_api.g_miss_date
2762     , p5_a13  NUMBER := 0-1962.0724
2763   );
2764   procedure version_contract(p_api_version  NUMBER
2765     , p_init_msg_list  VARCHAR2
2766     , x_return_status out nocopy  VARCHAR2
2767     , x_msg_count out nocopy  NUMBER
2768     , x_msg_data out nocopy  VARCHAR2
2769     , p_commit  VARCHAR2
2770     , p7_a0 out nocopy  NUMBER
2771     , p7_a1 out nocopy  NUMBER
2772     , p7_a2 out nocopy  NUMBER
2773     , p7_a3 out nocopy  NUMBER
2774     , p7_a4 out nocopy  NUMBER
2775     , p7_a5 out nocopy  DATE
2776     , p7_a6 out nocopy  NUMBER
2777     , p7_a7 out nocopy  DATE
2778     , p7_a8 out nocopy  NUMBER
2779     , p5_a0  NUMBER := 0-1962.0724
2780     , p5_a1  NUMBER := 0-1962.0724
2781     , p5_a2  NUMBER := 0-1962.0724
2782     , p5_a3  NUMBER := 0-1962.0724
2783     , p5_a4  NUMBER := 0-1962.0724
2784     , p5_a5  DATE := fnd_api.g_miss_date
2785     , p5_a6  NUMBER := 0-1962.0724
2786     , p5_a7  DATE := fnd_api.g_miss_date
2787     , p5_a8  NUMBER := 0-1962.0724
2788   );
2789   procedure version_contract(p_api_version  NUMBER
2790     , p_init_msg_list  VARCHAR2
2791     , x_return_status out nocopy  VARCHAR2
2792     , x_msg_count out nocopy  NUMBER
2793     , x_msg_data out nocopy  VARCHAR2
2794     , p5_a0 JTF_NUMBER_TABLE
2795     , p5_a1 JTF_NUMBER_TABLE
2796     , p5_a2 JTF_NUMBER_TABLE
2797     , p5_a3 JTF_NUMBER_TABLE
2798     , p5_a4 JTF_NUMBER_TABLE
2799     , p5_a5 JTF_DATE_TABLE
2800     , p5_a6 JTF_NUMBER_TABLE
2801     , p5_a7 JTF_DATE_TABLE
2802     , p5_a8 JTF_NUMBER_TABLE
2803     , p_commit  VARCHAR2
2804     , p7_a0 out nocopy JTF_NUMBER_TABLE
2805     , p7_a1 out nocopy JTF_NUMBER_TABLE
2806     , p7_a2 out nocopy JTF_NUMBER_TABLE
2807     , p7_a3 out nocopy JTF_NUMBER_TABLE
2808     , p7_a4 out nocopy JTF_NUMBER_TABLE
2809     , p7_a5 out nocopy JTF_DATE_TABLE
2810     , p7_a6 out nocopy JTF_NUMBER_TABLE
2811     , p7_a7 out nocopy JTF_DATE_TABLE
2812     , p7_a8 out nocopy JTF_NUMBER_TABLE
2813   );
2814   procedure create_contract_item(p_api_version  NUMBER
2815     , p_init_msg_list  VARCHAR2
2816     , x_return_status out nocopy  VARCHAR2
2817     , x_msg_count out nocopy  NUMBER
2818     , x_msg_data out nocopy  VARCHAR2
2819     , p6_a0 out nocopy  NUMBER
2820     , p6_a1 out nocopy  NUMBER
2821     , p6_a2 out nocopy  NUMBER
2822     , p6_a3 out nocopy  NUMBER
2823     , p6_a4 out nocopy  NUMBER
2824     , p6_a5 out nocopy  NUMBER
2825     , p6_a6 out nocopy  VARCHAR2
2826     , p6_a7 out nocopy  VARCHAR2
2827     , p6_a8 out nocopy  VARCHAR2
2828     , p6_a9 out nocopy  VARCHAR2
2829     , p6_a10 out nocopy  VARCHAR2
2830     , p6_a11 out nocopy  NUMBER
2831     , p6_a12 out nocopy  VARCHAR2
2832     , p6_a13 out nocopy  NUMBER
2833     , p6_a14 out nocopy  VARCHAR2
2834     , p6_a15 out nocopy  NUMBER
2835     , p6_a16 out nocopy  DATE
2836     , p6_a17 out nocopy  NUMBER
2837     , p6_a18 out nocopy  DATE
2838     , p6_a19 out nocopy  NUMBER
2839     , p5_a0  NUMBER := 0-1962.0724
2840     , p5_a1  NUMBER := 0-1962.0724
2841     , p5_a2  NUMBER := 0-1962.0724
2842     , p5_a3  NUMBER := 0-1962.0724
2843     , p5_a4  NUMBER := 0-1962.0724
2844     , p5_a5  NUMBER := 0-1962.0724
2845     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
2846     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
2847     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2848     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
2849     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2850     , p5_a11  NUMBER := 0-1962.0724
2851     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2852     , p5_a13  NUMBER := 0-1962.0724
2853     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2854     , p5_a15  NUMBER := 0-1962.0724
2855     , p5_a16  DATE := fnd_api.g_miss_date
2856     , p5_a17  NUMBER := 0-1962.0724
2857     , p5_a18  DATE := fnd_api.g_miss_date
2858     , p5_a19  NUMBER := 0-1962.0724
2859   );
2860   procedure create_contract_item(p_api_version  NUMBER
2861     , p_init_msg_list  VARCHAR2
2862     , x_return_status out nocopy  VARCHAR2
2863     , x_msg_count out nocopy  NUMBER
2864     , x_msg_data out nocopy  VARCHAR2
2865     , p5_a0 JTF_NUMBER_TABLE
2866     , p5_a1 JTF_NUMBER_TABLE
2867     , p5_a2 JTF_NUMBER_TABLE
2868     , p5_a3 JTF_NUMBER_TABLE
2869     , p5_a4 JTF_NUMBER_TABLE
2870     , p5_a5 JTF_NUMBER_TABLE
2871     , p5_a6 JTF_VARCHAR2_TABLE_100
2872     , p5_a7 JTF_VARCHAR2_TABLE_200
2873     , p5_a8 JTF_VARCHAR2_TABLE_100
2874     , p5_a9 JTF_VARCHAR2_TABLE_100
2875     , p5_a10 JTF_VARCHAR2_TABLE_100
2876     , p5_a11 JTF_NUMBER_TABLE
2877     , p5_a12 JTF_VARCHAR2_TABLE_100
2878     , p5_a13 JTF_NUMBER_TABLE
2879     , p5_a14 JTF_VARCHAR2_TABLE_100
2880     , p5_a15 JTF_NUMBER_TABLE
2881     , p5_a16 JTF_DATE_TABLE
2882     , p5_a17 JTF_NUMBER_TABLE
2883     , p5_a18 JTF_DATE_TABLE
2884     , p5_a19 JTF_NUMBER_TABLE
2885     , p6_a0 out nocopy JTF_NUMBER_TABLE
2886     , p6_a1 out nocopy JTF_NUMBER_TABLE
2887     , p6_a2 out nocopy JTF_NUMBER_TABLE
2888     , p6_a3 out nocopy JTF_NUMBER_TABLE
2889     , p6_a4 out nocopy JTF_NUMBER_TABLE
2890     , p6_a5 out nocopy JTF_NUMBER_TABLE
2891     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2892     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2893     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2894     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2895     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2896     , p6_a11 out nocopy JTF_NUMBER_TABLE
2897     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2898     , p6_a13 out nocopy JTF_NUMBER_TABLE
2899     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2900     , p6_a15 out nocopy JTF_NUMBER_TABLE
2901     , p6_a16 out nocopy JTF_DATE_TABLE
2902     , p6_a17 out nocopy JTF_NUMBER_TABLE
2903     , p6_a18 out nocopy JTF_DATE_TABLE
2904     , p6_a19 out nocopy JTF_NUMBER_TABLE
2905   );
2906   procedure update_contract_item(p_api_version  NUMBER
2907     , p_init_msg_list  VARCHAR2
2908     , x_return_status out nocopy  VARCHAR2
2909     , x_msg_count out nocopy  NUMBER
2910     , x_msg_data out nocopy  VARCHAR2
2911     , p6_a0 out nocopy  NUMBER
2912     , p6_a1 out nocopy  NUMBER
2913     , p6_a2 out nocopy  NUMBER
2914     , p6_a3 out nocopy  NUMBER
2915     , p6_a4 out nocopy  NUMBER
2916     , p6_a5 out nocopy  NUMBER
2917     , p6_a6 out nocopy  VARCHAR2
2918     , p6_a7 out nocopy  VARCHAR2
2919     , p6_a8 out nocopy  VARCHAR2
2920     , p6_a9 out nocopy  VARCHAR2
2921     , p6_a10 out nocopy  VARCHAR2
2922     , p6_a11 out nocopy  NUMBER
2923     , p6_a12 out nocopy  VARCHAR2
2924     , p6_a13 out nocopy  NUMBER
2925     , p6_a14 out nocopy  VARCHAR2
2926     , p6_a15 out nocopy  NUMBER
2927     , p6_a16 out nocopy  DATE
2928     , p6_a17 out nocopy  NUMBER
2929     , p6_a18 out nocopy  DATE
2930     , p6_a19 out nocopy  NUMBER
2931     , p5_a0  NUMBER := 0-1962.0724
2932     , p5_a1  NUMBER := 0-1962.0724
2933     , p5_a2  NUMBER := 0-1962.0724
2934     , p5_a3  NUMBER := 0-1962.0724
2935     , p5_a4  NUMBER := 0-1962.0724
2936     , p5_a5  NUMBER := 0-1962.0724
2937     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
2938     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
2939     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
2940     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
2941     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
2942     , p5_a11  NUMBER := 0-1962.0724
2943     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
2944     , p5_a13  NUMBER := 0-1962.0724
2945     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
2946     , p5_a15  NUMBER := 0-1962.0724
2947     , p5_a16  DATE := fnd_api.g_miss_date
2948     , p5_a17  NUMBER := 0-1962.0724
2949     , p5_a18  DATE := fnd_api.g_miss_date
2950     , p5_a19  NUMBER := 0-1962.0724
2951   );
2952   procedure update_contract_item(p_api_version  NUMBER
2953     , p_init_msg_list  VARCHAR2
2954     , x_return_status out nocopy  VARCHAR2
2955     , x_msg_count out nocopy  NUMBER
2956     , x_msg_data out nocopy  VARCHAR2
2957     , p5_a0 JTF_NUMBER_TABLE
2958     , p5_a1 JTF_NUMBER_TABLE
2959     , p5_a2 JTF_NUMBER_TABLE
2960     , p5_a3 JTF_NUMBER_TABLE
2961     , p5_a4 JTF_NUMBER_TABLE
2962     , p5_a5 JTF_NUMBER_TABLE
2963     , p5_a6 JTF_VARCHAR2_TABLE_100
2964     , p5_a7 JTF_VARCHAR2_TABLE_200
2965     , p5_a8 JTF_VARCHAR2_TABLE_100
2966     , p5_a9 JTF_VARCHAR2_TABLE_100
2967     , p5_a10 JTF_VARCHAR2_TABLE_100
2968     , p5_a11 JTF_NUMBER_TABLE
2969     , p5_a12 JTF_VARCHAR2_TABLE_100
2970     , p5_a13 JTF_NUMBER_TABLE
2971     , p5_a14 JTF_VARCHAR2_TABLE_100
2972     , p5_a15 JTF_NUMBER_TABLE
2973     , p5_a16 JTF_DATE_TABLE
2974     , p5_a17 JTF_NUMBER_TABLE
2975     , p5_a18 JTF_DATE_TABLE
2976     , p5_a19 JTF_NUMBER_TABLE
2977     , p6_a0 out nocopy JTF_NUMBER_TABLE
2978     , p6_a1 out nocopy JTF_NUMBER_TABLE
2979     , p6_a2 out nocopy JTF_NUMBER_TABLE
2980     , p6_a3 out nocopy JTF_NUMBER_TABLE
2981     , p6_a4 out nocopy JTF_NUMBER_TABLE
2982     , p6_a5 out nocopy JTF_NUMBER_TABLE
2983     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
2984     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
2985     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2986     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
2987     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
2988     , p6_a11 out nocopy JTF_NUMBER_TABLE
2989     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
2990     , p6_a13 out nocopy JTF_NUMBER_TABLE
2991     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
2992     , p6_a15 out nocopy JTF_NUMBER_TABLE
2993     , p6_a16 out nocopy JTF_DATE_TABLE
2994     , p6_a17 out nocopy JTF_NUMBER_TABLE
2995     , p6_a18 out nocopy JTF_DATE_TABLE
2996     , p6_a19 out nocopy JTF_NUMBER_TABLE
2997   );
2998   procedure delete_contract_item(p_api_version  NUMBER
2999     , p_init_msg_list  VARCHAR2
3000     , x_return_status out nocopy  VARCHAR2
3001     , x_msg_count out nocopy  NUMBER
3002     , x_msg_data out nocopy  VARCHAR2
3003     , p5_a0  NUMBER := 0-1962.0724
3004     , p5_a1  NUMBER := 0-1962.0724
3005     , p5_a2  NUMBER := 0-1962.0724
3006     , p5_a3  NUMBER := 0-1962.0724
3007     , p5_a4  NUMBER := 0-1962.0724
3008     , p5_a5  NUMBER := 0-1962.0724
3009     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3010     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
3011     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3012     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3013     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3014     , p5_a11  NUMBER := 0-1962.0724
3015     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3016     , p5_a13  NUMBER := 0-1962.0724
3017     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3018     , p5_a15  NUMBER := 0-1962.0724
3019     , p5_a16  DATE := fnd_api.g_miss_date
3020     , p5_a17  NUMBER := 0-1962.0724
3021     , p5_a18  DATE := fnd_api.g_miss_date
3022     , p5_a19  NUMBER := 0-1962.0724
3023   );
3024   procedure delete_contract_item(p_api_version  NUMBER
3025     , p_init_msg_list  VARCHAR2
3026     , x_return_status out nocopy  VARCHAR2
3027     , x_msg_count out nocopy  NUMBER
3028     , x_msg_data out nocopy  VARCHAR2
3029     , p5_a0 JTF_NUMBER_TABLE
3030     , p5_a1 JTF_NUMBER_TABLE
3031     , p5_a2 JTF_NUMBER_TABLE
3032     , p5_a3 JTF_NUMBER_TABLE
3033     , p5_a4 JTF_NUMBER_TABLE
3034     , p5_a5 JTF_NUMBER_TABLE
3035     , p5_a6 JTF_VARCHAR2_TABLE_100
3036     , p5_a7 JTF_VARCHAR2_TABLE_200
3037     , p5_a8 JTF_VARCHAR2_TABLE_100
3038     , p5_a9 JTF_VARCHAR2_TABLE_100
3039     , p5_a10 JTF_VARCHAR2_TABLE_100
3040     , p5_a11 JTF_NUMBER_TABLE
3041     , p5_a12 JTF_VARCHAR2_TABLE_100
3042     , p5_a13 JTF_NUMBER_TABLE
3043     , p5_a14 JTF_VARCHAR2_TABLE_100
3044     , p5_a15 JTF_NUMBER_TABLE
3045     , p5_a16 JTF_DATE_TABLE
3046     , p5_a17 JTF_NUMBER_TABLE
3047     , p5_a18 JTF_DATE_TABLE
3048     , p5_a19 JTF_NUMBER_TABLE
3049   );
3050   procedure create_k_party_role(p_api_version  NUMBER
3051     , p_init_msg_list  VARCHAR2
3052     , x_return_status out nocopy  VARCHAR2
3053     , x_msg_count out nocopy  NUMBER
3054     , x_msg_data out nocopy  VARCHAR2
3055     , p6_a0 out nocopy  NUMBER
3056     , p6_a1 out nocopy  NUMBER
3057     , p6_a2 out nocopy  VARCHAR2
3058     , p6_a3 out nocopy  NUMBER
3059     , p6_a4 out nocopy  NUMBER
3060     , p6_a5 out nocopy  NUMBER
3061     , p6_a6 out nocopy  VARCHAR2
3062     , p6_a7 out nocopy  NUMBER
3063     , p6_a8 out nocopy  VARCHAR2
3064     , p6_a9 out nocopy  VARCHAR2
3065     , p6_a10 out nocopy  VARCHAR2
3066     , p6_a11 out nocopy  VARCHAR2
3067     , p6_a12 out nocopy  VARCHAR2
3068     , p6_a13 out nocopy  VARCHAR2
3069     , p6_a14 out nocopy  VARCHAR2
3070     , p6_a15 out nocopy  VARCHAR2
3071     , p6_a16 out nocopy  VARCHAR2
3072     , p6_a17 out nocopy  VARCHAR2
3073     , p6_a18 out nocopy  VARCHAR2
3074     , p6_a19 out nocopy  VARCHAR2
3075     , p6_a20 out nocopy  VARCHAR2
3076     , p6_a21 out nocopy  VARCHAR2
3077     , p6_a22 out nocopy  VARCHAR2
3078     , p6_a23 out nocopy  VARCHAR2
3079     , p6_a24 out nocopy  VARCHAR2
3080     , p6_a25 out nocopy  VARCHAR2
3081     , p6_a26 out nocopy  VARCHAR2
3082     , p6_a27 out nocopy  VARCHAR2
3083     , p6_a28 out nocopy  VARCHAR2
3084     , p6_a29 out nocopy  VARCHAR2
3085     , p6_a30 out nocopy  VARCHAR2
3086     , p6_a31 out nocopy  VARCHAR2
3087     , p6_a32 out nocopy  VARCHAR2
3088     , p6_a33 out nocopy  VARCHAR2
3089     , p6_a34 out nocopy  NUMBER
3090     , p6_a35 out nocopy  DATE
3091     , p6_a36 out nocopy  NUMBER
3092     , p6_a37 out nocopy  DATE
3093     , p6_a38 out nocopy  NUMBER
3094     , p6_a39 out nocopy  NUMBER
3095     , p6_a40 out nocopy  NUMBER
3096     , p5_a0  NUMBER := 0-1962.0724
3097     , p5_a1  NUMBER := 0-1962.0724
3098     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
3099     , p5_a3  NUMBER := 0-1962.0724
3100     , p5_a4  NUMBER := 0-1962.0724
3101     , p5_a5  NUMBER := 0-1962.0724
3102     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3103     , p5_a7  NUMBER := 0-1962.0724
3104     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3105     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3106     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3107     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3108     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3109     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3110     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3111     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3112     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3113     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3114     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3115     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3116     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3117     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3118     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3119     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3120     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3121     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
3122     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
3123     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
3124     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
3125     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
3126     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
3127     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
3128     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
3129     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
3130     , p5_a34  NUMBER := 0-1962.0724
3131     , p5_a35  DATE := fnd_api.g_miss_date
3132     , p5_a36  NUMBER := 0-1962.0724
3133     , p5_a37  DATE := fnd_api.g_miss_date
3134     , p5_a38  NUMBER := 0-1962.0724
3135     , p5_a39  NUMBER := 0-1962.0724
3136     , p5_a40  NUMBER := 0-1962.0724
3137   );
3138   procedure create_k_party_role(p_api_version  NUMBER
3139     , p_init_msg_list  VARCHAR2
3140     , x_return_status out nocopy  VARCHAR2
3141     , x_msg_count out nocopy  NUMBER
3142     , x_msg_data out nocopy  VARCHAR2
3143     , p5_a0 JTF_NUMBER_TABLE
3144     , p5_a1 JTF_NUMBER_TABLE
3145     , p5_a2 JTF_VARCHAR2_TABLE_100
3146     , p5_a3 JTF_NUMBER_TABLE
3147     , p5_a4 JTF_NUMBER_TABLE
3148     , p5_a5 JTF_NUMBER_TABLE
3149     , p5_a6 JTF_VARCHAR2_TABLE_100
3150     , p5_a7 JTF_NUMBER_TABLE
3151     , p5_a8 JTF_VARCHAR2_TABLE_100
3152     , p5_a9 JTF_VARCHAR2_TABLE_200
3153     , p5_a10 JTF_VARCHAR2_TABLE_100
3154     , p5_a11 JTF_VARCHAR2_TABLE_300
3155     , p5_a12 JTF_VARCHAR2_TABLE_100
3156     , p5_a13 JTF_VARCHAR2_TABLE_100
3157     , p5_a14 JTF_VARCHAR2_TABLE_100
3158     , p5_a15 JTF_VARCHAR2_TABLE_100
3159     , p5_a16 JTF_VARCHAR2_TABLE_100
3160     , p5_a17 JTF_VARCHAR2_TABLE_200
3161     , p5_a18 JTF_VARCHAR2_TABLE_100
3162     , p5_a19 JTF_VARCHAR2_TABLE_500
3163     , p5_a20 JTF_VARCHAR2_TABLE_500
3164     , p5_a21 JTF_VARCHAR2_TABLE_500
3165     , p5_a22 JTF_VARCHAR2_TABLE_500
3166     , p5_a23 JTF_VARCHAR2_TABLE_500
3167     , p5_a24 JTF_VARCHAR2_TABLE_500
3168     , p5_a25 JTF_VARCHAR2_TABLE_500
3169     , p5_a26 JTF_VARCHAR2_TABLE_500
3170     , p5_a27 JTF_VARCHAR2_TABLE_500
3171     , p5_a28 JTF_VARCHAR2_TABLE_500
3172     , p5_a29 JTF_VARCHAR2_TABLE_500
3173     , p5_a30 JTF_VARCHAR2_TABLE_500
3174     , p5_a31 JTF_VARCHAR2_TABLE_500
3175     , p5_a32 JTF_VARCHAR2_TABLE_500
3176     , p5_a33 JTF_VARCHAR2_TABLE_500
3177     , p5_a34 JTF_NUMBER_TABLE
3178     , p5_a35 JTF_DATE_TABLE
3179     , p5_a36 JTF_NUMBER_TABLE
3180     , p5_a37 JTF_DATE_TABLE
3181     , p5_a38 JTF_NUMBER_TABLE
3182     , p5_a39 JTF_NUMBER_TABLE
3183     , p5_a40 JTF_NUMBER_TABLE
3184     , p6_a0 out nocopy JTF_NUMBER_TABLE
3185     , p6_a1 out nocopy JTF_NUMBER_TABLE
3186     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
3187     , p6_a3 out nocopy JTF_NUMBER_TABLE
3188     , p6_a4 out nocopy JTF_NUMBER_TABLE
3189     , p6_a5 out nocopy JTF_NUMBER_TABLE
3190     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3191     , p6_a7 out nocopy JTF_NUMBER_TABLE
3192     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3193     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
3194     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3195     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
3196     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
3197     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
3198     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3199     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3200     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3201     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
3202     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
3203     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
3204     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
3205     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
3206     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
3207     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3208     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
3209     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3210     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
3211     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
3212     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
3213     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
3214     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
3215     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
3216     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
3217     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
3218     , p6_a34 out nocopy JTF_NUMBER_TABLE
3219     , p6_a35 out nocopy JTF_DATE_TABLE
3220     , p6_a36 out nocopy JTF_NUMBER_TABLE
3221     , p6_a37 out nocopy JTF_DATE_TABLE
3222     , p6_a38 out nocopy JTF_NUMBER_TABLE
3223     , p6_a39 out nocopy JTF_NUMBER_TABLE
3224     , p6_a40 out nocopy JTF_NUMBER_TABLE
3225   );
3226   procedure update_k_party_role(p_api_version  NUMBER
3227     , p_init_msg_list  VARCHAR2
3228     , x_return_status out nocopy  VARCHAR2
3229     , x_msg_count out nocopy  NUMBER
3230     , x_msg_data out nocopy  VARCHAR2
3231     , p6_a0 out nocopy  NUMBER
3232     , p6_a1 out nocopy  NUMBER
3233     , p6_a2 out nocopy  VARCHAR2
3234     , p6_a3 out nocopy  NUMBER
3235     , p6_a4 out nocopy  NUMBER
3236     , p6_a5 out nocopy  NUMBER
3237     , p6_a6 out nocopy  VARCHAR2
3238     , p6_a7 out nocopy  NUMBER
3239     , p6_a8 out nocopy  VARCHAR2
3240     , p6_a9 out nocopy  VARCHAR2
3241     , p6_a10 out nocopy  VARCHAR2
3242     , p6_a11 out nocopy  VARCHAR2
3243     , p6_a12 out nocopy  VARCHAR2
3244     , p6_a13 out nocopy  VARCHAR2
3245     , p6_a14 out nocopy  VARCHAR2
3246     , p6_a15 out nocopy  VARCHAR2
3247     , p6_a16 out nocopy  VARCHAR2
3248     , p6_a17 out nocopy  VARCHAR2
3249     , p6_a18 out nocopy  VARCHAR2
3250     , p6_a19 out nocopy  VARCHAR2
3251     , p6_a20 out nocopy  VARCHAR2
3252     , p6_a21 out nocopy  VARCHAR2
3253     , p6_a22 out nocopy  VARCHAR2
3254     , p6_a23 out nocopy  VARCHAR2
3255     , p6_a24 out nocopy  VARCHAR2
3256     , p6_a25 out nocopy  VARCHAR2
3257     , p6_a26 out nocopy  VARCHAR2
3258     , p6_a27 out nocopy  VARCHAR2
3259     , p6_a28 out nocopy  VARCHAR2
3260     , p6_a29 out nocopy  VARCHAR2
3261     , p6_a30 out nocopy  VARCHAR2
3262     , p6_a31 out nocopy  VARCHAR2
3263     , p6_a32 out nocopy  VARCHAR2
3264     , p6_a33 out nocopy  VARCHAR2
3265     , p6_a34 out nocopy  NUMBER
3266     , p6_a35 out nocopy  DATE
3267     , p6_a36 out nocopy  NUMBER
3268     , p6_a37 out nocopy  DATE
3269     , p6_a38 out nocopy  NUMBER
3270     , p6_a39 out nocopy  NUMBER
3271     , p6_a40 out nocopy  NUMBER
3272     , p5_a0  NUMBER := 0-1962.0724
3273     , p5_a1  NUMBER := 0-1962.0724
3274     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
3275     , p5_a3  NUMBER := 0-1962.0724
3276     , p5_a4  NUMBER := 0-1962.0724
3277     , p5_a5  NUMBER := 0-1962.0724
3278     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3279     , p5_a7  NUMBER := 0-1962.0724
3280     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3281     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3282     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3283     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3284     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3285     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3286     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3287     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3288     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3289     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3290     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3291     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3292     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3293     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3294     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3295     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3296     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3297     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
3298     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
3299     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
3300     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
3301     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
3302     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
3303     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
3304     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
3305     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
3306     , p5_a34  NUMBER := 0-1962.0724
3307     , p5_a35  DATE := fnd_api.g_miss_date
3308     , p5_a36  NUMBER := 0-1962.0724
3309     , p5_a37  DATE := fnd_api.g_miss_date
3310     , p5_a38  NUMBER := 0-1962.0724
3311     , p5_a39  NUMBER := 0-1962.0724
3312     , p5_a40  NUMBER := 0-1962.0724
3313   );
3314   procedure update_k_party_role(p_api_version  NUMBER
3315     , p_init_msg_list  VARCHAR2
3316     , x_return_status out nocopy  VARCHAR2
3317     , x_msg_count out nocopy  NUMBER
3318     , x_msg_data out nocopy  VARCHAR2
3319     , p5_a0 JTF_NUMBER_TABLE
3320     , p5_a1 JTF_NUMBER_TABLE
3321     , p5_a2 JTF_VARCHAR2_TABLE_100
3322     , p5_a3 JTF_NUMBER_TABLE
3323     , p5_a4 JTF_NUMBER_TABLE
3324     , p5_a5 JTF_NUMBER_TABLE
3325     , p5_a6 JTF_VARCHAR2_TABLE_100
3326     , p5_a7 JTF_NUMBER_TABLE
3327     , p5_a8 JTF_VARCHAR2_TABLE_100
3328     , p5_a9 JTF_VARCHAR2_TABLE_200
3329     , p5_a10 JTF_VARCHAR2_TABLE_100
3330     , p5_a11 JTF_VARCHAR2_TABLE_300
3331     , p5_a12 JTF_VARCHAR2_TABLE_100
3332     , p5_a13 JTF_VARCHAR2_TABLE_100
3333     , p5_a14 JTF_VARCHAR2_TABLE_100
3334     , p5_a15 JTF_VARCHAR2_TABLE_100
3335     , p5_a16 JTF_VARCHAR2_TABLE_100
3336     , p5_a17 JTF_VARCHAR2_TABLE_200
3337     , p5_a18 JTF_VARCHAR2_TABLE_100
3338     , p5_a19 JTF_VARCHAR2_TABLE_500
3339     , p5_a20 JTF_VARCHAR2_TABLE_500
3340     , p5_a21 JTF_VARCHAR2_TABLE_500
3341     , p5_a22 JTF_VARCHAR2_TABLE_500
3342     , p5_a23 JTF_VARCHAR2_TABLE_500
3343     , p5_a24 JTF_VARCHAR2_TABLE_500
3344     , p5_a25 JTF_VARCHAR2_TABLE_500
3345     , p5_a26 JTF_VARCHAR2_TABLE_500
3346     , p5_a27 JTF_VARCHAR2_TABLE_500
3347     , p5_a28 JTF_VARCHAR2_TABLE_500
3348     , p5_a29 JTF_VARCHAR2_TABLE_500
3349     , p5_a30 JTF_VARCHAR2_TABLE_500
3350     , p5_a31 JTF_VARCHAR2_TABLE_500
3351     , p5_a32 JTF_VARCHAR2_TABLE_500
3352     , p5_a33 JTF_VARCHAR2_TABLE_500
3353     , p5_a34 JTF_NUMBER_TABLE
3354     , p5_a35 JTF_DATE_TABLE
3355     , p5_a36 JTF_NUMBER_TABLE
3356     , p5_a37 JTF_DATE_TABLE
3357     , p5_a38 JTF_NUMBER_TABLE
3358     , p5_a39 JTF_NUMBER_TABLE
3359     , p5_a40 JTF_NUMBER_TABLE
3360     , p6_a0 out nocopy JTF_NUMBER_TABLE
3361     , p6_a1 out nocopy JTF_NUMBER_TABLE
3362     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
3363     , p6_a3 out nocopy JTF_NUMBER_TABLE
3364     , p6_a4 out nocopy JTF_NUMBER_TABLE
3365     , p6_a5 out nocopy JTF_NUMBER_TABLE
3366     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3367     , p6_a7 out nocopy JTF_NUMBER_TABLE
3368     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3369     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
3370     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
3371     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
3372     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
3373     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
3374     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
3375     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
3376     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
3377     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
3378     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
3379     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
3380     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
3381     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
3382     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
3383     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3384     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
3385     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
3386     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
3387     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
3388     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
3389     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
3390     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
3391     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
3392     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
3393     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
3394     , p6_a34 out nocopy JTF_NUMBER_TABLE
3395     , p6_a35 out nocopy JTF_DATE_TABLE
3396     , p6_a36 out nocopy JTF_NUMBER_TABLE
3397     , p6_a37 out nocopy JTF_DATE_TABLE
3398     , p6_a38 out nocopy JTF_NUMBER_TABLE
3399     , p6_a39 out nocopy JTF_NUMBER_TABLE
3400     , p6_a40 out nocopy JTF_NUMBER_TABLE
3401   );
3402   procedure delete_k_party_role(p_api_version  NUMBER
3403     , p_init_msg_list  VARCHAR2
3404     , x_return_status out nocopy  VARCHAR2
3405     , x_msg_count out nocopy  NUMBER
3406     , x_msg_data out nocopy  VARCHAR2
3407     , p5_a0  NUMBER := 0-1962.0724
3408     , p5_a1  NUMBER := 0-1962.0724
3409     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
3410     , p5_a3  NUMBER := 0-1962.0724
3411     , p5_a4  NUMBER := 0-1962.0724
3412     , p5_a5  NUMBER := 0-1962.0724
3413     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3414     , p5_a7  NUMBER := 0-1962.0724
3415     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3416     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3417     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3418     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3419     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3420     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3421     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3422     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3423     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3424     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3425     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3426     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3427     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3428     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3429     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3430     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3431     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3432     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
3433     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
3434     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
3435     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
3436     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
3437     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
3438     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
3439     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
3440     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
3441     , p5_a34  NUMBER := 0-1962.0724
3442     , p5_a35  DATE := fnd_api.g_miss_date
3443     , p5_a36  NUMBER := 0-1962.0724
3444     , p5_a37  DATE := fnd_api.g_miss_date
3445     , p5_a38  NUMBER := 0-1962.0724
3446     , p5_a39  NUMBER := 0-1962.0724
3447     , p5_a40  NUMBER := 0-1962.0724
3448   );
3449   procedure delete_k_party_role(p_api_version  NUMBER
3450     , p_init_msg_list  VARCHAR2
3451     , x_return_status out nocopy  VARCHAR2
3452     , x_msg_count out nocopy  NUMBER
3453     , x_msg_data out nocopy  VARCHAR2
3454     , p5_a0 JTF_NUMBER_TABLE
3455     , p5_a1 JTF_NUMBER_TABLE
3456     , p5_a2 JTF_VARCHAR2_TABLE_100
3457     , p5_a3 JTF_NUMBER_TABLE
3458     , p5_a4 JTF_NUMBER_TABLE
3459     , p5_a5 JTF_NUMBER_TABLE
3460     , p5_a6 JTF_VARCHAR2_TABLE_100
3461     , p5_a7 JTF_NUMBER_TABLE
3462     , p5_a8 JTF_VARCHAR2_TABLE_100
3463     , p5_a9 JTF_VARCHAR2_TABLE_200
3464     , p5_a10 JTF_VARCHAR2_TABLE_100
3465     , p5_a11 JTF_VARCHAR2_TABLE_300
3466     , p5_a12 JTF_VARCHAR2_TABLE_100
3467     , p5_a13 JTF_VARCHAR2_TABLE_100
3468     , p5_a14 JTF_VARCHAR2_TABLE_100
3469     , p5_a15 JTF_VARCHAR2_TABLE_100
3470     , p5_a16 JTF_VARCHAR2_TABLE_100
3471     , p5_a17 JTF_VARCHAR2_TABLE_200
3472     , p5_a18 JTF_VARCHAR2_TABLE_100
3473     , p5_a19 JTF_VARCHAR2_TABLE_500
3474     , p5_a20 JTF_VARCHAR2_TABLE_500
3475     , p5_a21 JTF_VARCHAR2_TABLE_500
3476     , p5_a22 JTF_VARCHAR2_TABLE_500
3477     , p5_a23 JTF_VARCHAR2_TABLE_500
3478     , p5_a24 JTF_VARCHAR2_TABLE_500
3479     , p5_a25 JTF_VARCHAR2_TABLE_500
3480     , p5_a26 JTF_VARCHAR2_TABLE_500
3481     , p5_a27 JTF_VARCHAR2_TABLE_500
3482     , p5_a28 JTF_VARCHAR2_TABLE_500
3483     , p5_a29 JTF_VARCHAR2_TABLE_500
3484     , p5_a30 JTF_VARCHAR2_TABLE_500
3485     , p5_a31 JTF_VARCHAR2_TABLE_500
3486     , p5_a32 JTF_VARCHAR2_TABLE_500
3487     , p5_a33 JTF_VARCHAR2_TABLE_500
3488     , p5_a34 JTF_NUMBER_TABLE
3489     , p5_a35 JTF_DATE_TABLE
3490     , p5_a36 JTF_NUMBER_TABLE
3491     , p5_a37 JTF_DATE_TABLE
3492     , p5_a38 JTF_NUMBER_TABLE
3493     , p5_a39 JTF_NUMBER_TABLE
3494     , p5_a40 JTF_NUMBER_TABLE
3495   );
3496   procedure create_contact(p_api_version  NUMBER
3497     , p_init_msg_list  VARCHAR2
3498     , x_return_status out nocopy  VARCHAR2
3499     , x_msg_count out nocopy  NUMBER
3500     , x_msg_data out nocopy  VARCHAR2
3501     , p6_a0 out nocopy  NUMBER
3502     , p6_a1 out nocopy  NUMBER
3503     , p6_a2 out nocopy  NUMBER
3504     , p6_a3 out nocopy  VARCHAR2
3505     , p6_a4 out nocopy  NUMBER
3506     , p6_a5 out nocopy  NUMBER
3507     , p6_a6 out nocopy  VARCHAR2
3508     , p6_a7 out nocopy  VARCHAR2
3509     , p6_a8 out nocopy  VARCHAR2
3510     , p6_a9 out nocopy  VARCHAR2
3511     , p6_a10 out nocopy  VARCHAR2
3512     , p6_a11 out nocopy  VARCHAR2
3513     , p6_a12 out nocopy  VARCHAR2
3514     , p6_a13 out nocopy  VARCHAR2
3515     , p6_a14 out nocopy  VARCHAR2
3516     , p6_a15 out nocopy  VARCHAR2
3517     , p6_a16 out nocopy  VARCHAR2
3518     , p6_a17 out nocopy  VARCHAR2
3519     , p6_a18 out nocopy  VARCHAR2
3520     , p6_a19 out nocopy  VARCHAR2
3521     , p6_a20 out nocopy  VARCHAR2
3522     , p6_a21 out nocopy  VARCHAR2
3523     , p6_a22 out nocopy  VARCHAR2
3524     , p6_a23 out nocopy  VARCHAR2
3525     , p6_a24 out nocopy  VARCHAR2
3526     , p6_a25 out nocopy  NUMBER
3527     , p6_a26 out nocopy  DATE
3528     , p6_a27 out nocopy  NUMBER
3529     , p6_a28 out nocopy  DATE
3530     , p6_a29 out nocopy  NUMBER
3531     , p6_a30 out nocopy  DATE
3532     , p6_a31 out nocopy  DATE
3533     , p5_a0  NUMBER := 0-1962.0724
3534     , p5_a1  NUMBER := 0-1962.0724
3535     , p5_a2  NUMBER := 0-1962.0724
3536     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
3537     , p5_a4  NUMBER := 0-1962.0724
3538     , p5_a5  NUMBER := 0-1962.0724
3539     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3540     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
3541     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3542     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3543     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3544     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3545     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3546     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3547     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3548     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3549     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3550     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3551     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3552     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3553     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3554     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3555     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3556     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3557     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3558     , p5_a25  NUMBER := 0-1962.0724
3559     , p5_a26  DATE := fnd_api.g_miss_date
3560     , p5_a27  NUMBER := 0-1962.0724
3561     , p5_a28  DATE := fnd_api.g_miss_date
3562     , p5_a29  NUMBER := 0-1962.0724
3563     , p5_a30  DATE := fnd_api.g_miss_date
3564     , p5_a31  DATE := fnd_api.g_miss_date
3565   );
3566   procedure create_contact(p_api_version  NUMBER
3567     , p_init_msg_list  VARCHAR2
3568     , x_return_status out nocopy  VARCHAR2
3569     , x_msg_count out nocopy  NUMBER
3570     , x_msg_data out nocopy  VARCHAR2
3571     , p5_a0 JTF_NUMBER_TABLE
3572     , p5_a1 JTF_NUMBER_TABLE
3573     , p5_a2 JTF_NUMBER_TABLE
3574     , p5_a3 JTF_VARCHAR2_TABLE_100
3575     , p5_a4 JTF_NUMBER_TABLE
3576     , p5_a5 JTF_NUMBER_TABLE
3577     , p5_a6 JTF_VARCHAR2_TABLE_100
3578     , p5_a7 JTF_VARCHAR2_TABLE_200
3579     , p5_a8 JTF_VARCHAR2_TABLE_100
3580     , p5_a9 JTF_VARCHAR2_TABLE_100
3581     , p5_a10 JTF_VARCHAR2_TABLE_500
3582     , p5_a11 JTF_VARCHAR2_TABLE_500
3583     , p5_a12 JTF_VARCHAR2_TABLE_500
3584     , p5_a13 JTF_VARCHAR2_TABLE_500
3585     , p5_a14 JTF_VARCHAR2_TABLE_500
3586     , p5_a15 JTF_VARCHAR2_TABLE_500
3587     , p5_a16 JTF_VARCHAR2_TABLE_500
3588     , p5_a17 JTF_VARCHAR2_TABLE_500
3589     , p5_a18 JTF_VARCHAR2_TABLE_500
3590     , p5_a19 JTF_VARCHAR2_TABLE_500
3591     , p5_a20 JTF_VARCHAR2_TABLE_500
3592     , p5_a21 JTF_VARCHAR2_TABLE_500
3593     , p5_a22 JTF_VARCHAR2_TABLE_500
3594     , p5_a23 JTF_VARCHAR2_TABLE_500
3595     , p5_a24 JTF_VARCHAR2_TABLE_500
3596     , p5_a25 JTF_NUMBER_TABLE
3597     , p5_a26 JTF_DATE_TABLE
3598     , p5_a27 JTF_NUMBER_TABLE
3599     , p5_a28 JTF_DATE_TABLE
3600     , p5_a29 JTF_NUMBER_TABLE
3601     , p5_a30 JTF_DATE_TABLE
3602     , p5_a31 JTF_DATE_TABLE
3603     , p6_a0 out nocopy JTF_NUMBER_TABLE
3604     , p6_a1 out nocopy JTF_NUMBER_TABLE
3605     , p6_a2 out nocopy JTF_NUMBER_TABLE
3606     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3607     , p6_a4 out nocopy JTF_NUMBER_TABLE
3608     , p6_a5 out nocopy JTF_NUMBER_TABLE
3609     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3610     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
3611     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3612     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
3613     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
3614     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
3615     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
3616     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
3617     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
3618     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
3619     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
3620     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
3621     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
3622     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
3623     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
3624     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
3625     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
3626     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3627     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
3628     , p6_a25 out nocopy JTF_NUMBER_TABLE
3629     , p6_a26 out nocopy JTF_DATE_TABLE
3630     , p6_a27 out nocopy JTF_NUMBER_TABLE
3631     , p6_a28 out nocopy JTF_DATE_TABLE
3632     , p6_a29 out nocopy JTF_NUMBER_TABLE
3633     , p6_a30 out nocopy JTF_DATE_TABLE
3634     , p6_a31 out nocopy JTF_DATE_TABLE
3635   );
3636   procedure update_contact(p_api_version  NUMBER
3637     , p_init_msg_list  VARCHAR2
3638     , x_return_status out nocopy  VARCHAR2
3639     , x_msg_count out nocopy  NUMBER
3640     , x_msg_data out nocopy  VARCHAR2
3641     , p6_a0 out nocopy  NUMBER
3642     , p6_a1 out nocopy  NUMBER
3643     , p6_a2 out nocopy  NUMBER
3644     , p6_a3 out nocopy  VARCHAR2
3645     , p6_a4 out nocopy  NUMBER
3646     , p6_a5 out nocopy  NUMBER
3647     , p6_a6 out nocopy  VARCHAR2
3648     , p6_a7 out nocopy  VARCHAR2
3649     , p6_a8 out nocopy  VARCHAR2
3650     , p6_a9 out nocopy  VARCHAR2
3651     , p6_a10 out nocopy  VARCHAR2
3652     , p6_a11 out nocopy  VARCHAR2
3653     , p6_a12 out nocopy  VARCHAR2
3654     , p6_a13 out nocopy  VARCHAR2
3655     , p6_a14 out nocopy  VARCHAR2
3656     , p6_a15 out nocopy  VARCHAR2
3657     , p6_a16 out nocopy  VARCHAR2
3658     , p6_a17 out nocopy  VARCHAR2
3659     , p6_a18 out nocopy  VARCHAR2
3660     , p6_a19 out nocopy  VARCHAR2
3661     , p6_a20 out nocopy  VARCHAR2
3662     , p6_a21 out nocopy  VARCHAR2
3663     , p6_a22 out nocopy  VARCHAR2
3664     , p6_a23 out nocopy  VARCHAR2
3665     , p6_a24 out nocopy  VARCHAR2
3666     , p6_a25 out nocopy  NUMBER
3667     , p6_a26 out nocopy  DATE
3668     , p6_a27 out nocopy  NUMBER
3669     , p6_a28 out nocopy  DATE
3670     , p6_a29 out nocopy  NUMBER
3671     , p6_a30 out nocopy  DATE
3672     , p6_a31 out nocopy  DATE
3673     , p5_a0  NUMBER := 0-1962.0724
3674     , p5_a1  NUMBER := 0-1962.0724
3675     , p5_a2  NUMBER := 0-1962.0724
3676     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
3677     , p5_a4  NUMBER := 0-1962.0724
3678     , p5_a5  NUMBER := 0-1962.0724
3679     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3680     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
3681     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3682     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3683     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3684     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3685     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3686     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3687     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3688     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3689     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3690     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3691     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3692     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3693     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3694     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3695     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3696     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3697     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3698     , p5_a25  NUMBER := 0-1962.0724
3699     , p5_a26  DATE := fnd_api.g_miss_date
3700     , p5_a27  NUMBER := 0-1962.0724
3701     , p5_a28  DATE := fnd_api.g_miss_date
3702     , p5_a29  NUMBER := 0-1962.0724
3703     , p5_a30  DATE := fnd_api.g_miss_date
3704     , p5_a31  DATE := fnd_api.g_miss_date
3705   );
3706   procedure update_contact(p_api_version  NUMBER
3707     , p_init_msg_list  VARCHAR2
3708     , x_return_status out nocopy  VARCHAR2
3709     , x_msg_count out nocopy  NUMBER
3710     , x_msg_data out nocopy  VARCHAR2
3711     , p5_a0 JTF_NUMBER_TABLE
3712     , p5_a1 JTF_NUMBER_TABLE
3713     , p5_a2 JTF_NUMBER_TABLE
3714     , p5_a3 JTF_VARCHAR2_TABLE_100
3715     , p5_a4 JTF_NUMBER_TABLE
3716     , p5_a5 JTF_NUMBER_TABLE
3717     , p5_a6 JTF_VARCHAR2_TABLE_100
3718     , p5_a7 JTF_VARCHAR2_TABLE_200
3719     , p5_a8 JTF_VARCHAR2_TABLE_100
3720     , p5_a9 JTF_VARCHAR2_TABLE_100
3721     , p5_a10 JTF_VARCHAR2_TABLE_500
3722     , p5_a11 JTF_VARCHAR2_TABLE_500
3723     , p5_a12 JTF_VARCHAR2_TABLE_500
3724     , p5_a13 JTF_VARCHAR2_TABLE_500
3725     , p5_a14 JTF_VARCHAR2_TABLE_500
3726     , p5_a15 JTF_VARCHAR2_TABLE_500
3727     , p5_a16 JTF_VARCHAR2_TABLE_500
3728     , p5_a17 JTF_VARCHAR2_TABLE_500
3729     , p5_a18 JTF_VARCHAR2_TABLE_500
3730     , p5_a19 JTF_VARCHAR2_TABLE_500
3731     , p5_a20 JTF_VARCHAR2_TABLE_500
3732     , p5_a21 JTF_VARCHAR2_TABLE_500
3733     , p5_a22 JTF_VARCHAR2_TABLE_500
3734     , p5_a23 JTF_VARCHAR2_TABLE_500
3735     , p5_a24 JTF_VARCHAR2_TABLE_500
3736     , p5_a25 JTF_NUMBER_TABLE
3737     , p5_a26 JTF_DATE_TABLE
3738     , p5_a27 JTF_NUMBER_TABLE
3739     , p5_a28 JTF_DATE_TABLE
3740     , p5_a29 JTF_NUMBER_TABLE
3741     , p5_a30 JTF_DATE_TABLE
3742     , p5_a31 JTF_DATE_TABLE
3743     , p6_a0 out nocopy JTF_NUMBER_TABLE
3744     , p6_a1 out nocopy JTF_NUMBER_TABLE
3745     , p6_a2 out nocopy JTF_NUMBER_TABLE
3746     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
3747     , p6_a4 out nocopy JTF_NUMBER_TABLE
3748     , p6_a5 out nocopy JTF_NUMBER_TABLE
3749     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
3750     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
3751     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
3752     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
3753     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
3754     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
3755     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
3756     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
3757     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
3758     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
3759     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
3760     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
3761     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
3762     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
3763     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
3764     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
3765     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
3766     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
3767     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
3768     , p6_a25 out nocopy JTF_NUMBER_TABLE
3769     , p6_a26 out nocopy JTF_DATE_TABLE
3770     , p6_a27 out nocopy JTF_NUMBER_TABLE
3771     , p6_a28 out nocopy JTF_DATE_TABLE
3772     , p6_a29 out nocopy JTF_NUMBER_TABLE
3773     , p6_a30 out nocopy JTF_DATE_TABLE
3774     , p6_a31 out nocopy JTF_DATE_TABLE
3775   );
3776   procedure delete_contact(p_api_version  NUMBER
3777     , p_init_msg_list  VARCHAR2
3778     , x_return_status out nocopy  VARCHAR2
3779     , x_msg_count out nocopy  NUMBER
3780     , x_msg_data out nocopy  VARCHAR2
3781     , p5_a0  NUMBER := 0-1962.0724
3782     , p5_a1  NUMBER := 0-1962.0724
3783     , p5_a2  NUMBER := 0-1962.0724
3784     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
3785     , p5_a4  NUMBER := 0-1962.0724
3786     , p5_a5  NUMBER := 0-1962.0724
3787     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
3788     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
3789     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
3790     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
3791     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3792     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3793     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3794     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3795     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3796     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3797     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3798     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3799     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3800     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3801     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3802     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3803     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3804     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3805     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3806     , p5_a25  NUMBER := 0-1962.0724
3807     , p5_a26  DATE := fnd_api.g_miss_date
3808     , p5_a27  NUMBER := 0-1962.0724
3809     , p5_a28  DATE := fnd_api.g_miss_date
3810     , p5_a29  NUMBER := 0-1962.0724
3811     , p5_a30  DATE := fnd_api.g_miss_date
3812     , p5_a31  DATE := fnd_api.g_miss_date
3813   );
3814   procedure delete_contact(p_api_version  NUMBER
3815     , p_init_msg_list  VARCHAR2
3816     , x_return_status out nocopy  VARCHAR2
3817     , x_msg_count out nocopy  NUMBER
3818     , x_msg_data out nocopy  VARCHAR2
3819     , p5_a0 JTF_NUMBER_TABLE
3820     , p5_a1 JTF_NUMBER_TABLE
3821     , p5_a2 JTF_NUMBER_TABLE
3822     , p5_a3 JTF_VARCHAR2_TABLE_100
3823     , p5_a4 JTF_NUMBER_TABLE
3824     , p5_a5 JTF_NUMBER_TABLE
3825     , p5_a6 JTF_VARCHAR2_TABLE_100
3826     , p5_a7 JTF_VARCHAR2_TABLE_200
3827     , p5_a8 JTF_VARCHAR2_TABLE_100
3828     , p5_a9 JTF_VARCHAR2_TABLE_100
3829     , p5_a10 JTF_VARCHAR2_TABLE_500
3830     , p5_a11 JTF_VARCHAR2_TABLE_500
3831     , p5_a12 JTF_VARCHAR2_TABLE_500
3832     , p5_a13 JTF_VARCHAR2_TABLE_500
3833     , p5_a14 JTF_VARCHAR2_TABLE_500
3834     , p5_a15 JTF_VARCHAR2_TABLE_500
3835     , p5_a16 JTF_VARCHAR2_TABLE_500
3836     , p5_a17 JTF_VARCHAR2_TABLE_500
3837     , p5_a18 JTF_VARCHAR2_TABLE_500
3838     , p5_a19 JTF_VARCHAR2_TABLE_500
3839     , p5_a20 JTF_VARCHAR2_TABLE_500
3840     , p5_a21 JTF_VARCHAR2_TABLE_500
3841     , p5_a22 JTF_VARCHAR2_TABLE_500
3842     , p5_a23 JTF_VARCHAR2_TABLE_500
3843     , p5_a24 JTF_VARCHAR2_TABLE_500
3844     , p5_a25 JTF_NUMBER_TABLE
3845     , p5_a26 JTF_DATE_TABLE
3846     , p5_a27 JTF_NUMBER_TABLE
3847     , p5_a28 JTF_DATE_TABLE
3848     , p5_a29 JTF_NUMBER_TABLE
3849     , p5_a30 JTF_DATE_TABLE
3850     , p5_a31 JTF_DATE_TABLE
3851   );
3852   procedure create_rule_group(p_api_version  NUMBER
3853     , p_init_msg_list  VARCHAR2
3854     , x_return_status out nocopy  VARCHAR2
3855     , x_msg_count out nocopy  NUMBER
3856     , x_msg_data out nocopy  VARCHAR2
3857     , p6_a0 out nocopy  NUMBER
3858     , p6_a1 out nocopy  NUMBER
3859     , p6_a2 out nocopy  VARCHAR2
3860     , p6_a3 out nocopy  VARCHAR2
3861     , p6_a4 out nocopy  VARCHAR2
3862     , p6_a5 out nocopy  VARCHAR2
3863     , p6_a6 out nocopy  NUMBER
3864     , p6_a7 out nocopy  NUMBER
3865     , p6_a8 out nocopy  NUMBER
3866     , p6_a9 out nocopy  NUMBER
3867     , p6_a10 out nocopy  VARCHAR2
3868     , p6_a11 out nocopy  VARCHAR2
3869     , p6_a12 out nocopy  VARCHAR2
3870     , p6_a13 out nocopy  VARCHAR2
3871     , p6_a14 out nocopy  VARCHAR2
3872     , p6_a15 out nocopy  VARCHAR2
3873     , p6_a16 out nocopy  VARCHAR2
3874     , p6_a17 out nocopy  VARCHAR2
3875     , p6_a18 out nocopy  VARCHAR2
3876     , p6_a19 out nocopy  VARCHAR2
3877     , p6_a20 out nocopy  VARCHAR2
3878     , p6_a21 out nocopy  VARCHAR2
3879     , p6_a22 out nocopy  VARCHAR2
3880     , p6_a23 out nocopy  VARCHAR2
3881     , p6_a24 out nocopy  VARCHAR2
3882     , p6_a25 out nocopy  VARCHAR2
3883     , p6_a26 out nocopy  VARCHAR2
3884     , p6_a27 out nocopy  NUMBER
3885     , p6_a28 out nocopy  DATE
3886     , p6_a29 out nocopy  NUMBER
3887     , p6_a30 out nocopy  DATE
3888     , p6_a31 out nocopy  NUMBER
3889     , p5_a0  NUMBER := 0-1962.0724
3890     , p5_a1  NUMBER := 0-1962.0724
3891     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
3892     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
3893     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
3894     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
3895     , p5_a6  NUMBER := 0-1962.0724
3896     , p5_a7  NUMBER := 0-1962.0724
3897     , p5_a8  NUMBER := 0-1962.0724
3898     , p5_a9  NUMBER := 0-1962.0724
3899     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3900     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3901     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3902     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3903     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3904     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3905     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3906     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3907     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3908     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3909     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3910     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3911     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3912     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3913     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3914     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
3915     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
3916     , p5_a27  NUMBER := 0-1962.0724
3917     , p5_a28  DATE := fnd_api.g_miss_date
3918     , p5_a29  NUMBER := 0-1962.0724
3919     , p5_a30  DATE := fnd_api.g_miss_date
3920     , p5_a31  NUMBER := 0-1962.0724
3921   );
3922   procedure update_rule_group(p_api_version  NUMBER
3923     , p_init_msg_list  VARCHAR2
3924     , x_return_status out nocopy  VARCHAR2
3925     , x_msg_count out nocopy  NUMBER
3926     , x_msg_data out nocopy  VARCHAR2
3927     , p6_a0 out nocopy  NUMBER
3928     , p6_a1 out nocopy  NUMBER
3929     , p6_a2 out nocopy  VARCHAR2
3930     , p6_a3 out nocopy  VARCHAR2
3931     , p6_a4 out nocopy  VARCHAR2
3932     , p6_a5 out nocopy  VARCHAR2
3933     , p6_a6 out nocopy  NUMBER
3934     , p6_a7 out nocopy  NUMBER
3935     , p6_a8 out nocopy  NUMBER
3936     , p6_a9 out nocopy  NUMBER
3937     , p6_a10 out nocopy  VARCHAR2
3938     , p6_a11 out nocopy  VARCHAR2
3939     , p6_a12 out nocopy  VARCHAR2
3940     , p6_a13 out nocopy  VARCHAR2
3941     , p6_a14 out nocopy  VARCHAR2
3942     , p6_a15 out nocopy  VARCHAR2
3943     , p6_a16 out nocopy  VARCHAR2
3944     , p6_a17 out nocopy  VARCHAR2
3945     , p6_a18 out nocopy  VARCHAR2
3946     , p6_a19 out nocopy  VARCHAR2
3947     , p6_a20 out nocopy  VARCHAR2
3948     , p6_a21 out nocopy  VARCHAR2
3949     , p6_a22 out nocopy  VARCHAR2
3950     , p6_a23 out nocopy  VARCHAR2
3951     , p6_a24 out nocopy  VARCHAR2
3952     , p6_a25 out nocopy  VARCHAR2
3953     , p6_a26 out nocopy  VARCHAR2
3954     , p6_a27 out nocopy  NUMBER
3955     , p6_a28 out nocopy  DATE
3956     , p6_a29 out nocopy  NUMBER
3957     , p6_a30 out nocopy  DATE
3958     , p6_a31 out nocopy  NUMBER
3959     , p5_a0  NUMBER := 0-1962.0724
3960     , p5_a1  NUMBER := 0-1962.0724
3961     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
3962     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
3963     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
3964     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
3965     , p5_a6  NUMBER := 0-1962.0724
3966     , p5_a7  NUMBER := 0-1962.0724
3967     , p5_a8  NUMBER := 0-1962.0724
3968     , p5_a9  NUMBER := 0-1962.0724
3969     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
3970     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
3971     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
3972     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
3973     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
3974     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
3975     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
3976     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
3977     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
3978     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
3979     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
3980     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
3981     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
3982     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
3983     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
3984     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
3985     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
3986     , p5_a27  NUMBER := 0-1962.0724
3987     , p5_a28  DATE := fnd_api.g_miss_date
3988     , p5_a29  NUMBER := 0-1962.0724
3989     , p5_a30  DATE := fnd_api.g_miss_date
3990     , p5_a31  NUMBER := 0-1962.0724
3991   );
3992   procedure delete_rule_group(p_api_version  NUMBER
3993     , p_init_msg_list  VARCHAR2
3994     , x_return_status out nocopy  VARCHAR2
3995     , x_msg_count out nocopy  NUMBER
3996     , x_msg_data out nocopy  VARCHAR2
3997     , p5_a0  NUMBER := 0-1962.0724
3998     , p5_a1  NUMBER := 0-1962.0724
3999     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
4000     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
4001     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
4002     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
4003     , p5_a6  NUMBER := 0-1962.0724
4004     , p5_a7  NUMBER := 0-1962.0724
4005     , p5_a8  NUMBER := 0-1962.0724
4006     , p5_a9  NUMBER := 0-1962.0724
4007     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
4008     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
4009     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
4010     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
4011     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
4012     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
4013     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
4014     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
4015     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
4016     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
4017     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
4018     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
4019     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
4020     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
4021     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
4022     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
4023     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
4024     , p5_a27  NUMBER := 0-1962.0724
4025     , p5_a28  DATE := fnd_api.g_miss_date
4026     , p5_a29  NUMBER := 0-1962.0724
4027     , p5_a30  DATE := fnd_api.g_miss_date
4028     , p5_a31  NUMBER := 0-1962.0724
4029   );
4030   procedure lock_rule_group(p_api_version  NUMBER
4031     , p_init_msg_list  VARCHAR2
4032     , x_return_status out nocopy  VARCHAR2
4033     , x_msg_count out nocopy  NUMBER
4034     , x_msg_data out nocopy  VARCHAR2
4035     , p5_a0  NUMBER := 0-1962.0724
4036     , p5_a1  NUMBER := 0-1962.0724
4037     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
4038     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
4039     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
4040     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
4041     , p5_a6  NUMBER := 0-1962.0724
4042     , p5_a7  NUMBER := 0-1962.0724
4043     , p5_a8  NUMBER := 0-1962.0724
4044     , p5_a9  NUMBER := 0-1962.0724
4045     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
4046     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
4047     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
4048     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
4049     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
4050     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
4051     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
4052     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
4053     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
4054     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
4055     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
4056     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
4057     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
4058     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
4059     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
4060     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
4061     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
4062     , p5_a27  NUMBER := 0-1962.0724
4063     , p5_a28  DATE := fnd_api.g_miss_date
4064     , p5_a29  NUMBER := 0-1962.0724
4065     , p5_a30  DATE := fnd_api.g_miss_date
4066     , p5_a31  NUMBER := 0-1962.0724
4067   );
4068   procedure validate_rule_group(p_api_version  NUMBER
4069     , p_init_msg_list  VARCHAR2
4070     , x_return_status out nocopy  VARCHAR2
4071     , x_msg_count out nocopy  NUMBER
4072     , x_msg_data out nocopy  VARCHAR2
4073     , p5_a0  NUMBER := 0-1962.0724
4074     , p5_a1  NUMBER := 0-1962.0724
4075     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
4076     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
4077     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
4078     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
4079     , p5_a6  NUMBER := 0-1962.0724
4080     , p5_a7  NUMBER := 0-1962.0724
4081     , p5_a8  NUMBER := 0-1962.0724
4082     , p5_a9  NUMBER := 0-1962.0724
4083     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
4084     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
4085     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
4086     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
4087     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
4088     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
4089     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
4090     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
4091     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
4092     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
4093     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
4094     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
4095     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
4096     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
4097     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
4098     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
4099     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
4100     , p5_a27  NUMBER := 0-1962.0724
4101     , p5_a28  DATE := fnd_api.g_miss_date
4102     , p5_a29  NUMBER := 0-1962.0724
4103     , p5_a30  DATE := fnd_api.g_miss_date
4104     , p5_a31  NUMBER := 0-1962.0724
4105   );
4106   procedure create_rg_mode_pty_role(p_api_version  NUMBER
4107     , p_init_msg_list  VARCHAR2
4108     , x_return_status out nocopy  VARCHAR2
4109     , x_msg_count out nocopy  NUMBER
4110     , x_msg_data out nocopy  VARCHAR2
4111     , p6_a0 out nocopy  NUMBER
4112     , p6_a1 out nocopy  NUMBER
4113     , p6_a2 out nocopy  NUMBER
4114     , p6_a3 out nocopy  NUMBER
4115     , p6_a4 out nocopy  NUMBER
4116     , p6_a5 out nocopy  NUMBER
4117     , p6_a6 out nocopy  NUMBER
4118     , p6_a7 out nocopy  DATE
4119     , p6_a8 out nocopy  NUMBER
4120     , p6_a9 out nocopy  DATE
4121     , p6_a10 out nocopy  NUMBER
4122     , p5_a0  NUMBER := 0-1962.0724
4123     , p5_a1  NUMBER := 0-1962.0724
4124     , p5_a2  NUMBER := 0-1962.0724
4125     , p5_a3  NUMBER := 0-1962.0724
4126     , p5_a4  NUMBER := 0-1962.0724
4127     , p5_a5  NUMBER := 0-1962.0724
4128     , p5_a6  NUMBER := 0-1962.0724
4129     , p5_a7  DATE := fnd_api.g_miss_date
4130     , p5_a8  NUMBER := 0-1962.0724
4131     , p5_a9  DATE := fnd_api.g_miss_date
4132     , p5_a10  NUMBER := 0-1962.0724
4133   );
4134   procedure update_rg_mode_pty_role(p_api_version  NUMBER
4135     , p_init_msg_list  VARCHAR2
4136     , x_return_status out nocopy  VARCHAR2
4137     , x_msg_count out nocopy  NUMBER
4138     , x_msg_data out nocopy  VARCHAR2
4139     , p6_a0 out nocopy  NUMBER
4140     , p6_a1 out nocopy  NUMBER
4141     , p6_a2 out nocopy  NUMBER
4142     , p6_a3 out nocopy  NUMBER
4143     , p6_a4 out nocopy  NUMBER
4144     , p6_a5 out nocopy  NUMBER
4145     , p6_a6 out nocopy  NUMBER
4146     , p6_a7 out nocopy  DATE
4147     , p6_a8 out nocopy  NUMBER
4148     , p6_a9 out nocopy  DATE
4149     , p6_a10 out nocopy  NUMBER
4150     , p5_a0  NUMBER := 0-1962.0724
4151     , p5_a1  NUMBER := 0-1962.0724
4152     , p5_a2  NUMBER := 0-1962.0724
4153     , p5_a3  NUMBER := 0-1962.0724
4154     , p5_a4  NUMBER := 0-1962.0724
4155     , p5_a5  NUMBER := 0-1962.0724
4156     , p5_a6  NUMBER := 0-1962.0724
4157     , p5_a7  DATE := fnd_api.g_miss_date
4158     , p5_a8  NUMBER := 0-1962.0724
4159     , p5_a9  DATE := fnd_api.g_miss_date
4160     , p5_a10  NUMBER := 0-1962.0724
4161   );
4162   procedure delete_rg_mode_pty_role(p_api_version  NUMBER
4163     , p_init_msg_list  VARCHAR2
4164     , x_return_status out nocopy  VARCHAR2
4165     , x_msg_count out nocopy  NUMBER
4166     , x_msg_data out nocopy  VARCHAR2
4167     , p5_a0  NUMBER := 0-1962.0724
4168     , p5_a1  NUMBER := 0-1962.0724
4169     , p5_a2  NUMBER := 0-1962.0724
4170     , p5_a3  NUMBER := 0-1962.0724
4171     , p5_a4  NUMBER := 0-1962.0724
4172     , p5_a5  NUMBER := 0-1962.0724
4173     , p5_a6  NUMBER := 0-1962.0724
4174     , p5_a7  DATE := fnd_api.g_miss_date
4175     , p5_a8  NUMBER := 0-1962.0724
4176     , p5_a9  DATE := fnd_api.g_miss_date
4177     , p5_a10  NUMBER := 0-1962.0724
4178   );
4179   procedure lock_rg_mode_pty_role(p_api_version  NUMBER
4180     , p_init_msg_list  VARCHAR2
4181     , x_return_status out nocopy  VARCHAR2
4182     , x_msg_count out nocopy  NUMBER
4183     , x_msg_data out nocopy  VARCHAR2
4184     , p5_a0  NUMBER := 0-1962.0724
4185     , p5_a1  NUMBER := 0-1962.0724
4186     , p5_a2  NUMBER := 0-1962.0724
4187     , p5_a3  NUMBER := 0-1962.0724
4188     , p5_a4  NUMBER := 0-1962.0724
4189     , p5_a5  NUMBER := 0-1962.0724
4190     , p5_a6  NUMBER := 0-1962.0724
4191     , p5_a7  DATE := fnd_api.g_miss_date
4192     , p5_a8  NUMBER := 0-1962.0724
4193     , p5_a9  DATE := fnd_api.g_miss_date
4194     , p5_a10  NUMBER := 0-1962.0724
4195   );
4196   procedure validate_rg_mode_pty_role(p_api_version  NUMBER
4197     , p_init_msg_list  VARCHAR2
4198     , x_return_status out nocopy  VARCHAR2
4199     , x_msg_count out nocopy  NUMBER
4200     , x_msg_data out nocopy  VARCHAR2
4201     , p5_a0  NUMBER := 0-1962.0724
4202     , p5_a1  NUMBER := 0-1962.0724
4203     , p5_a2  NUMBER := 0-1962.0724
4204     , p5_a3  NUMBER := 0-1962.0724
4205     , p5_a4  NUMBER := 0-1962.0724
4206     , p5_a5  NUMBER := 0-1962.0724
4207     , p5_a6  NUMBER := 0-1962.0724
4208     , p5_a7  DATE := fnd_api.g_miss_date
4209     , p5_a8  NUMBER := 0-1962.0724
4210     , p5_a9  DATE := fnd_api.g_miss_date
4211     , p5_a10  NUMBER := 0-1962.0724
4212   );
4213 end okl_okc_migration_pvt_w;