DBA Data[Home] [Help]

PACKAGE: APPS.OKL_LEASE_QUOTE_PVT_W

Source


1 package okl_lease_quote_pvt_w as
2   /* $Header: OKLELSQS.pls 120.7 2007/08/08 21:08:52 rravikir noship $ */
3   procedure create_lease_qte(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_transaction_control  VARCHAR2
6     , p3_a0  NUMBER
7     , p3_a1  NUMBER
8     , p3_a2  VARCHAR2
9     , p3_a3  VARCHAR2
10     , p3_a4  VARCHAR2
11     , p3_a5  VARCHAR2
12     , p3_a6  VARCHAR2
13     , p3_a7  VARCHAR2
14     , p3_a8  VARCHAR2
15     , p3_a9  VARCHAR2
16     , p3_a10  VARCHAR2
17     , p3_a11  VARCHAR2
18     , p3_a12  VARCHAR2
19     , p3_a13  VARCHAR2
20     , p3_a14  VARCHAR2
21     , p3_a15  VARCHAR2
22     , p3_a16  VARCHAR2
23     , p3_a17  VARCHAR2
24     , p3_a18  VARCHAR2
25     , p3_a19  VARCHAR2
26     , p3_a20  VARCHAR2
27     , p3_a21  NUMBER
28     , p3_a22  DATE
29     , p3_a23  DATE
30     , p3_a24  VARCHAR2
31     , p3_a25  VARCHAR2
32     , p3_a26  DATE
33     , p3_a27  DATE
34     , p3_a28  DATE
35     , p3_a29  VARCHAR2
36     , p3_a30  NUMBER
37     , p3_a31  NUMBER
38     , p3_a32  NUMBER
39     , p3_a33  VARCHAR2
40     , p3_a34  VARCHAR2
41     , p3_a35  NUMBER
42     , p3_a36  NUMBER
43     , p3_a37  NUMBER
44     , p3_a38  VARCHAR2
45     , p3_a39  NUMBER
46     , p3_a40  NUMBER
47     , p3_a41  VARCHAR2
48     , p3_a42  VARCHAR2
49     , p3_a43  NUMBER
50     , p3_a44  NUMBER
51     , p3_a45  NUMBER
52     , p3_a46  NUMBER
53     , p3_a47  NUMBER
54     , p3_a48  NUMBER
55     , p3_a49  NUMBER
56     , p3_a50  NUMBER
57     , p3_a51  NUMBER
58     , p3_a52  VARCHAR2
59     , p3_a53  VARCHAR2
60     , p3_a54  VARCHAR2
61     , p3_a55  NUMBER
62     , p3_a56  NUMBER
63     , p3_a57  VARCHAR2
64     , p3_a58  VARCHAR2
65     , p3_a59  VARCHAR2
66     , p3_a60  NUMBER
67     , p3_a61  VARCHAR2
68     , p3_a62  NUMBER
69     , p3_a63  VARCHAR2
70     , p3_a64  VARCHAR2
71     , p3_a65  VARCHAR2
72     , p3_a66  VARCHAR2
73     , p3_a67  NUMBER
74     , p3_a68  VARCHAR2
75     , p3_a69  VARCHAR2
76     , p3_a70  VARCHAR2
77     , p3_a71  VARCHAR2
78     , p4_a0 out nocopy  NUMBER
79     , p4_a1 out nocopy  NUMBER
80     , p4_a2 out nocopy  VARCHAR2
81     , p4_a3 out nocopy  VARCHAR2
82     , p4_a4 out nocopy  VARCHAR2
83     , p4_a5 out nocopy  VARCHAR2
84     , p4_a6 out nocopy  VARCHAR2
85     , p4_a7 out nocopy  VARCHAR2
86     , p4_a8 out nocopy  VARCHAR2
87     , p4_a9 out nocopy  VARCHAR2
88     , p4_a10 out nocopy  VARCHAR2
89     , p4_a11 out nocopy  VARCHAR2
90     , p4_a12 out nocopy  VARCHAR2
91     , p4_a13 out nocopy  VARCHAR2
92     , p4_a14 out nocopy  VARCHAR2
93     , p4_a15 out nocopy  VARCHAR2
94     , p4_a16 out nocopy  VARCHAR2
95     , p4_a17 out nocopy  VARCHAR2
96     , p4_a18 out nocopy  VARCHAR2
97     , p4_a19 out nocopy  VARCHAR2
98     , p4_a20 out nocopy  VARCHAR2
99     , p4_a21 out nocopy  NUMBER
100     , p4_a22 out nocopy  DATE
101     , p4_a23 out nocopy  DATE
102     , p4_a24 out nocopy  VARCHAR2
103     , p4_a25 out nocopy  VARCHAR2
104     , p4_a26 out nocopy  DATE
105     , p4_a27 out nocopy  DATE
106     , p4_a28 out nocopy  DATE
107     , p4_a29 out nocopy  VARCHAR2
108     , p4_a30 out nocopy  NUMBER
109     , p4_a31 out nocopy  NUMBER
110     , p4_a32 out nocopy  NUMBER
111     , p4_a33 out nocopy  VARCHAR2
112     , p4_a34 out nocopy  VARCHAR2
113     , p4_a35 out nocopy  NUMBER
114     , p4_a36 out nocopy  NUMBER
115     , p4_a37 out nocopy  NUMBER
116     , p4_a38 out nocopy  VARCHAR2
117     , p4_a39 out nocopy  NUMBER
118     , p4_a40 out nocopy  NUMBER
119     , p4_a41 out nocopy  VARCHAR2
120     , p4_a42 out nocopy  VARCHAR2
121     , p4_a43 out nocopy  NUMBER
122     , p4_a44 out nocopy  NUMBER
123     , p4_a45 out nocopy  NUMBER
124     , p4_a46 out nocopy  NUMBER
125     , p4_a47 out nocopy  NUMBER
126     , p4_a48 out nocopy  NUMBER
127     , p4_a49 out nocopy  NUMBER
128     , p4_a50 out nocopy  NUMBER
129     , p4_a51 out nocopy  NUMBER
130     , p4_a52 out nocopy  VARCHAR2
131     , p4_a53 out nocopy  VARCHAR2
132     , p4_a54 out nocopy  VARCHAR2
133     , p4_a55 out nocopy  NUMBER
134     , p4_a56 out nocopy  NUMBER
135     , p4_a57 out nocopy  VARCHAR2
136     , p4_a58 out nocopy  VARCHAR2
137     , p4_a59 out nocopy  VARCHAR2
138     , p4_a60 out nocopy  NUMBER
139     , p4_a61 out nocopy  VARCHAR2
140     , p4_a62 out nocopy  NUMBER
141     , p4_a63 out nocopy  VARCHAR2
142     , p4_a64 out nocopy  VARCHAR2
143     , p4_a65 out nocopy  VARCHAR2
144     , p4_a66 out nocopy  VARCHAR2
145     , p4_a67 out nocopy  NUMBER
146     , p4_a68 out nocopy  VARCHAR2
147     , p4_a69 out nocopy  VARCHAR2
148     , p4_a70 out nocopy  VARCHAR2
149     , p4_a71 out nocopy  VARCHAR2
150     , x_return_status out nocopy  VARCHAR2
151     , x_msg_count out nocopy  NUMBER
152     , x_msg_data out nocopy  VARCHAR2
153   );
154   procedure update_lease_qte(p_api_version  NUMBER
155     , p_init_msg_list  VARCHAR2
156     , p_transaction_control  VARCHAR2
157     , p3_a0  NUMBER
158     , p3_a1  NUMBER
159     , p3_a2  VARCHAR2
160     , p3_a3  VARCHAR2
161     , p3_a4  VARCHAR2
162     , p3_a5  VARCHAR2
163     , p3_a6  VARCHAR2
164     , p3_a7  VARCHAR2
165     , p3_a8  VARCHAR2
166     , p3_a9  VARCHAR2
167     , p3_a10  VARCHAR2
168     , p3_a11  VARCHAR2
169     , p3_a12  VARCHAR2
170     , p3_a13  VARCHAR2
171     , p3_a14  VARCHAR2
172     , p3_a15  VARCHAR2
173     , p3_a16  VARCHAR2
174     , p3_a17  VARCHAR2
175     , p3_a18  VARCHAR2
176     , p3_a19  VARCHAR2
177     , p3_a20  VARCHAR2
178     , p3_a21  NUMBER
179     , p3_a22  DATE
180     , p3_a23  DATE
181     , p3_a24  VARCHAR2
182     , p3_a25  VARCHAR2
183     , p3_a26  DATE
184     , p3_a27  DATE
185     , p3_a28  DATE
186     , p3_a29  VARCHAR2
187     , p3_a30  NUMBER
188     , p3_a31  NUMBER
189     , p3_a32  NUMBER
190     , p3_a33  VARCHAR2
191     , p3_a34  VARCHAR2
192     , p3_a35  NUMBER
193     , p3_a36  NUMBER
194     , p3_a37  NUMBER
195     , p3_a38  VARCHAR2
196     , p3_a39  NUMBER
197     , p3_a40  NUMBER
198     , p3_a41  VARCHAR2
199     , p3_a42  VARCHAR2
200     , p3_a43  NUMBER
201     , p3_a44  NUMBER
202     , p3_a45  NUMBER
203     , p3_a46  NUMBER
204     , p3_a47  NUMBER
205     , p3_a48  NUMBER
206     , p3_a49  NUMBER
207     , p3_a50  NUMBER
208     , p3_a51  NUMBER
209     , p3_a52  VARCHAR2
210     , p3_a53  VARCHAR2
211     , p3_a54  VARCHAR2
212     , p3_a55  NUMBER
213     , p3_a56  NUMBER
214     , p3_a57  VARCHAR2
215     , p3_a58  VARCHAR2
216     , p3_a59  VARCHAR2
217     , p3_a60  NUMBER
218     , p3_a61  VARCHAR2
219     , p3_a62  NUMBER
220     , p3_a63  VARCHAR2
221     , p3_a64  VARCHAR2
222     , p3_a65  VARCHAR2
223     , p3_a66  VARCHAR2
224     , p3_a67  NUMBER
225     , p3_a68  VARCHAR2
226     , p3_a69  VARCHAR2
227     , p3_a70  VARCHAR2
228     , p3_a71  VARCHAR2
229     , p4_a0 out nocopy  NUMBER
230     , p4_a1 out nocopy  NUMBER
231     , p4_a2 out nocopy  VARCHAR2
232     , p4_a3 out nocopy  VARCHAR2
233     , p4_a4 out nocopy  VARCHAR2
234     , p4_a5 out nocopy  VARCHAR2
235     , p4_a6 out nocopy  VARCHAR2
236     , p4_a7 out nocopy  VARCHAR2
237     , p4_a8 out nocopy  VARCHAR2
238     , p4_a9 out nocopy  VARCHAR2
239     , p4_a10 out nocopy  VARCHAR2
240     , p4_a11 out nocopy  VARCHAR2
241     , p4_a12 out nocopy  VARCHAR2
242     , p4_a13 out nocopy  VARCHAR2
243     , p4_a14 out nocopy  VARCHAR2
244     , p4_a15 out nocopy  VARCHAR2
245     , p4_a16 out nocopy  VARCHAR2
246     , p4_a17 out nocopy  VARCHAR2
247     , p4_a18 out nocopy  VARCHAR2
248     , p4_a19 out nocopy  VARCHAR2
249     , p4_a20 out nocopy  VARCHAR2
250     , p4_a21 out nocopy  NUMBER
251     , p4_a22 out nocopy  DATE
252     , p4_a23 out nocopy  DATE
253     , p4_a24 out nocopy  VARCHAR2
254     , p4_a25 out nocopy  VARCHAR2
255     , p4_a26 out nocopy  DATE
256     , p4_a27 out nocopy  DATE
257     , p4_a28 out nocopy  DATE
258     , p4_a29 out nocopy  VARCHAR2
259     , p4_a30 out nocopy  NUMBER
260     , p4_a31 out nocopy  NUMBER
261     , p4_a32 out nocopy  NUMBER
262     , p4_a33 out nocopy  VARCHAR2
263     , p4_a34 out nocopy  VARCHAR2
264     , p4_a35 out nocopy  NUMBER
265     , p4_a36 out nocopy  NUMBER
266     , p4_a37 out nocopy  NUMBER
267     , p4_a38 out nocopy  VARCHAR2
268     , p4_a39 out nocopy  NUMBER
269     , p4_a40 out nocopy  NUMBER
270     , p4_a41 out nocopy  VARCHAR2
271     , p4_a42 out nocopy  VARCHAR2
272     , p4_a43 out nocopy  NUMBER
273     , p4_a44 out nocopy  NUMBER
274     , p4_a45 out nocopy  NUMBER
275     , p4_a46 out nocopy  NUMBER
276     , p4_a47 out nocopy  NUMBER
277     , p4_a48 out nocopy  NUMBER
278     , p4_a49 out nocopy  NUMBER
279     , p4_a50 out nocopy  NUMBER
280     , p4_a51 out nocopy  NUMBER
281     , p4_a52 out nocopy  VARCHAR2
282     , p4_a53 out nocopy  VARCHAR2
283     , p4_a54 out nocopy  VARCHAR2
284     , p4_a55 out nocopy  NUMBER
285     , p4_a56 out nocopy  NUMBER
286     , p4_a57 out nocopy  VARCHAR2
287     , p4_a58 out nocopy  VARCHAR2
288     , p4_a59 out nocopy  VARCHAR2
289     , p4_a60 out nocopy  NUMBER
290     , p4_a61 out nocopy  VARCHAR2
291     , p4_a62 out nocopy  NUMBER
292     , p4_a63 out nocopy  VARCHAR2
293     , p4_a64 out nocopy  VARCHAR2
294     , p4_a65 out nocopy  VARCHAR2
295     , p4_a66 out nocopy  VARCHAR2
296     , p4_a67 out nocopy  NUMBER
297     , p4_a68 out nocopy  VARCHAR2
298     , p4_a69 out nocopy  VARCHAR2
299     , p4_a70 out nocopy  VARCHAR2
300     , p4_a71 out nocopy  VARCHAR2
301     , x_return_status out nocopy  VARCHAR2
302     , x_msg_count out nocopy  NUMBER
303     , x_msg_data out nocopy  VARCHAR2
304   );
305   procedure duplicate_lease_qte(p_api_version  NUMBER
306     , p_init_msg_list  VARCHAR2
307     , p_transaction_control  VARCHAR2
308     , p_source_quote_id  NUMBER
309     , p4_a0  NUMBER
310     , p4_a1  NUMBER
311     , p4_a2  VARCHAR2
312     , p4_a3  VARCHAR2
313     , p4_a4  VARCHAR2
314     , p4_a5  VARCHAR2
315     , p4_a6  VARCHAR2
316     , p4_a7  VARCHAR2
317     , p4_a8  VARCHAR2
318     , p4_a9  VARCHAR2
319     , p4_a10  VARCHAR2
320     , p4_a11  VARCHAR2
321     , p4_a12  VARCHAR2
322     , p4_a13  VARCHAR2
323     , p4_a14  VARCHAR2
324     , p4_a15  VARCHAR2
325     , p4_a16  VARCHAR2
326     , p4_a17  VARCHAR2
327     , p4_a18  VARCHAR2
328     , p4_a19  VARCHAR2
329     , p4_a20  VARCHAR2
330     , p4_a21  NUMBER
331     , p4_a22  DATE
332     , p4_a23  DATE
333     , p4_a24  VARCHAR2
334     , p4_a25  VARCHAR2
335     , p4_a26  DATE
336     , p4_a27  DATE
337     , p4_a28  DATE
338     , p4_a29  VARCHAR2
339     , p4_a30  NUMBER
340     , p4_a31  NUMBER
341     , p4_a32  NUMBER
342     , p4_a33  VARCHAR2
343     , p4_a34  VARCHAR2
344     , p4_a35  NUMBER
345     , p4_a36  NUMBER
346     , p4_a37  NUMBER
347     , p4_a38  VARCHAR2
348     , p4_a39  NUMBER
349     , p4_a40  NUMBER
350     , p4_a41  VARCHAR2
351     , p4_a42  VARCHAR2
352     , p4_a43  NUMBER
353     , p4_a44  NUMBER
354     , p4_a45  NUMBER
355     , p4_a46  NUMBER
356     , p4_a47  NUMBER
357     , p4_a48  NUMBER
358     , p4_a49  NUMBER
359     , p4_a50  NUMBER
360     , p4_a51  NUMBER
361     , p4_a52  VARCHAR2
362     , p4_a53  VARCHAR2
363     , p4_a54  VARCHAR2
364     , p4_a55  NUMBER
365     , p4_a56  NUMBER
366     , p4_a57  VARCHAR2
367     , p4_a58  VARCHAR2
368     , p4_a59  VARCHAR2
369     , p4_a60  NUMBER
370     , p4_a61  VARCHAR2
371     , p4_a62  NUMBER
372     , p4_a63  VARCHAR2
373     , p4_a64  VARCHAR2
374     , p4_a65  VARCHAR2
375     , p4_a66  VARCHAR2
376     , p4_a67  NUMBER
377     , p4_a68  VARCHAR2
378     , p4_a69  VARCHAR2
379     , p4_a70  VARCHAR2
380     , p4_a71  VARCHAR2
381     , p5_a0 out nocopy  NUMBER
382     , p5_a1 out nocopy  NUMBER
383     , p5_a2 out nocopy  VARCHAR2
384     , p5_a3 out nocopy  VARCHAR2
385     , p5_a4 out nocopy  VARCHAR2
386     , p5_a5 out nocopy  VARCHAR2
387     , p5_a6 out nocopy  VARCHAR2
388     , p5_a7 out nocopy  VARCHAR2
389     , p5_a8 out nocopy  VARCHAR2
390     , p5_a9 out nocopy  VARCHAR2
391     , p5_a10 out nocopy  VARCHAR2
392     , p5_a11 out nocopy  VARCHAR2
393     , p5_a12 out nocopy  VARCHAR2
394     , p5_a13 out nocopy  VARCHAR2
395     , p5_a14 out nocopy  VARCHAR2
396     , p5_a15 out nocopy  VARCHAR2
397     , p5_a16 out nocopy  VARCHAR2
398     , p5_a17 out nocopy  VARCHAR2
399     , p5_a18 out nocopy  VARCHAR2
400     , p5_a19 out nocopy  VARCHAR2
401     , p5_a20 out nocopy  VARCHAR2
402     , p5_a21 out nocopy  NUMBER
403     , p5_a22 out nocopy  DATE
404     , p5_a23 out nocopy  DATE
405     , p5_a24 out nocopy  VARCHAR2
406     , p5_a25 out nocopy  VARCHAR2
407     , p5_a26 out nocopy  DATE
408     , p5_a27 out nocopy  DATE
409     , p5_a28 out nocopy  DATE
410     , p5_a29 out nocopy  VARCHAR2
411     , p5_a30 out nocopy  NUMBER
412     , p5_a31 out nocopy  NUMBER
413     , p5_a32 out nocopy  NUMBER
414     , p5_a33 out nocopy  VARCHAR2
415     , p5_a34 out nocopy  VARCHAR2
416     , p5_a35 out nocopy  NUMBER
417     , p5_a36 out nocopy  NUMBER
418     , p5_a37 out nocopy  NUMBER
419     , p5_a38 out nocopy  VARCHAR2
420     , p5_a39 out nocopy  NUMBER
421     , p5_a40 out nocopy  NUMBER
422     , p5_a41 out nocopy  VARCHAR2
423     , p5_a42 out nocopy  VARCHAR2
424     , p5_a43 out nocopy  NUMBER
425     , p5_a44 out nocopy  NUMBER
426     , p5_a45 out nocopy  NUMBER
427     , p5_a46 out nocopy  NUMBER
428     , p5_a47 out nocopy  NUMBER
429     , p5_a48 out nocopy  NUMBER
430     , p5_a49 out nocopy  NUMBER
431     , p5_a50 out nocopy  NUMBER
432     , p5_a51 out nocopy  NUMBER
433     , p5_a52 out nocopy  VARCHAR2
434     , p5_a53 out nocopy  VARCHAR2
435     , p5_a54 out nocopy  VARCHAR2
436     , p5_a55 out nocopy  NUMBER
437     , p5_a56 out nocopy  NUMBER
438     , p5_a57 out nocopy  VARCHAR2
439     , p5_a58 out nocopy  VARCHAR2
440     , p5_a59 out nocopy  VARCHAR2
441     , p5_a60 out nocopy  NUMBER
442     , p5_a61 out nocopy  VARCHAR2
443     , p5_a62 out nocopy  NUMBER
444     , p5_a63 out nocopy  VARCHAR2
445     , p5_a64 out nocopy  VARCHAR2
446     , p5_a65 out nocopy  VARCHAR2
447     , p5_a66 out nocopy  VARCHAR2
448     , p5_a67 out nocopy  NUMBER
449     , p5_a68 out nocopy  VARCHAR2
450     , p5_a69 out nocopy  VARCHAR2
451     , p5_a70 out nocopy  VARCHAR2
452     , p5_a71 out nocopy  VARCHAR2
453     , x_return_status out nocopy  VARCHAR2
454     , x_msg_count out nocopy  NUMBER
455     , x_msg_data out nocopy  VARCHAR2
456   );
457   procedure duplicate_lease_qte(p_api_version  NUMBER
458     , p_init_msg_list  VARCHAR2
459     , p_transaction_control  VARCHAR2
460     , p_quote_id  NUMBER
461     , p4_a0 out nocopy  NUMBER
462     , p4_a1 out nocopy  NUMBER
463     , p4_a2 out nocopy  VARCHAR2
464     , p4_a3 out nocopy  VARCHAR2
465     , p4_a4 out nocopy  VARCHAR2
466     , p4_a5 out nocopy  VARCHAR2
467     , p4_a6 out nocopy  VARCHAR2
468     , p4_a7 out nocopy  VARCHAR2
469     , p4_a8 out nocopy  VARCHAR2
470     , p4_a9 out nocopy  VARCHAR2
471     , p4_a10 out nocopy  VARCHAR2
472     , p4_a11 out nocopy  VARCHAR2
473     , p4_a12 out nocopy  VARCHAR2
474     , p4_a13 out nocopy  VARCHAR2
475     , p4_a14 out nocopy  VARCHAR2
476     , p4_a15 out nocopy  VARCHAR2
477     , p4_a16 out nocopy  VARCHAR2
478     , p4_a17 out nocopy  VARCHAR2
479     , p4_a18 out nocopy  VARCHAR2
480     , p4_a19 out nocopy  VARCHAR2
481     , p4_a20 out nocopy  VARCHAR2
482     , p4_a21 out nocopy  NUMBER
483     , p4_a22 out nocopy  DATE
484     , p4_a23 out nocopy  DATE
485     , p4_a24 out nocopy  VARCHAR2
486     , p4_a25 out nocopy  VARCHAR2
487     , p4_a26 out nocopy  DATE
488     , p4_a27 out nocopy  DATE
489     , p4_a28 out nocopy  DATE
490     , p4_a29 out nocopy  VARCHAR2
491     , p4_a30 out nocopy  NUMBER
492     , p4_a31 out nocopy  NUMBER
493     , p4_a32 out nocopy  NUMBER
494     , p4_a33 out nocopy  VARCHAR2
495     , p4_a34 out nocopy  VARCHAR2
496     , p4_a35 out nocopy  NUMBER
497     , p4_a36 out nocopy  NUMBER
498     , p4_a37 out nocopy  NUMBER
499     , p4_a38 out nocopy  VARCHAR2
500     , p4_a39 out nocopy  NUMBER
501     , p4_a40 out nocopy  NUMBER
502     , p4_a41 out nocopy  VARCHAR2
503     , p4_a42 out nocopy  VARCHAR2
504     , p4_a43 out nocopy  NUMBER
505     , p4_a44 out nocopy  NUMBER
506     , p4_a45 out nocopy  NUMBER
507     , p4_a46 out nocopy  NUMBER
508     , p4_a47 out nocopy  NUMBER
509     , p4_a48 out nocopy  NUMBER
510     , p4_a49 out nocopy  NUMBER
511     , p4_a50 out nocopy  NUMBER
512     , p4_a51 out nocopy  NUMBER
513     , p4_a52 out nocopy  VARCHAR2
514     , p4_a53 out nocopy  VARCHAR2
515     , p4_a54 out nocopy  VARCHAR2
516     , p4_a55 out nocopy  NUMBER
517     , p4_a56 out nocopy  NUMBER
518     , p4_a57 out nocopy  VARCHAR2
519     , p4_a58 out nocopy  VARCHAR2
520     , p4_a59 out nocopy  VARCHAR2
521     , p4_a60 out nocopy  NUMBER
522     , p4_a61 out nocopy  VARCHAR2
523     , p4_a62 out nocopy  NUMBER
524     , p4_a63 out nocopy  VARCHAR2
525     , p4_a64 out nocopy  VARCHAR2
526     , p4_a65 out nocopy  VARCHAR2
527     , p4_a66 out nocopy  VARCHAR2
528     , p4_a67 out nocopy  NUMBER
529     , p4_a68 out nocopy  VARCHAR2
530     , p4_a69 out nocopy  VARCHAR2
531     , p4_a70 out nocopy  VARCHAR2
532     , p4_a71 out nocopy  VARCHAR2
533     , x_return_status out nocopy  VARCHAR2
534     , x_msg_count out nocopy  NUMBER
535     , x_msg_data out nocopy  VARCHAR2
536   );
537   procedure cancel_lease_qte(p_api_version  NUMBER
538     , p_init_msg_list  VARCHAR2
539     , p_transaction_control  VARCHAR2
540     , p3_a0 JTF_NUMBER_TABLE
541     , p3_a1 JTF_NUMBER_TABLE
542     , p3_a2 JTF_VARCHAR2_TABLE_100
543     , p3_a3 JTF_VARCHAR2_TABLE_500
544     , p3_a4 JTF_VARCHAR2_TABLE_500
545     , p3_a5 JTF_VARCHAR2_TABLE_500
546     , p3_a6 JTF_VARCHAR2_TABLE_500
547     , p3_a7 JTF_VARCHAR2_TABLE_500
548     , p3_a8 JTF_VARCHAR2_TABLE_500
549     , p3_a9 JTF_VARCHAR2_TABLE_500
550     , p3_a10 JTF_VARCHAR2_TABLE_500
551     , p3_a11 JTF_VARCHAR2_TABLE_500
552     , p3_a12 JTF_VARCHAR2_TABLE_500
553     , p3_a13 JTF_VARCHAR2_TABLE_500
554     , p3_a14 JTF_VARCHAR2_TABLE_500
555     , p3_a15 JTF_VARCHAR2_TABLE_500
556     , p3_a16 JTF_VARCHAR2_TABLE_500
557     , p3_a17 JTF_VARCHAR2_TABLE_500
558     , p3_a18 JTF_VARCHAR2_TABLE_200
559     , p3_a19 JTF_VARCHAR2_TABLE_100
560     , p3_a20 JTF_VARCHAR2_TABLE_100
561     , p3_a21 JTF_NUMBER_TABLE
562     , p3_a22 JTF_DATE_TABLE
563     , p3_a23 JTF_DATE_TABLE
564     , p3_a24 JTF_VARCHAR2_TABLE_100
565     , p3_a25 JTF_VARCHAR2_TABLE_100
566     , p3_a26 JTF_DATE_TABLE
567     , p3_a27 JTF_DATE_TABLE
568     , p3_a28 JTF_DATE_TABLE
569     , p3_a29 JTF_VARCHAR2_TABLE_100
570     , p3_a30 JTF_NUMBER_TABLE
571     , p3_a31 JTF_NUMBER_TABLE
572     , p3_a32 JTF_NUMBER_TABLE
573     , p3_a33 JTF_VARCHAR2_TABLE_100
574     , p3_a34 JTF_VARCHAR2_TABLE_100
575     , p3_a35 JTF_NUMBER_TABLE
576     , p3_a36 JTF_NUMBER_TABLE
577     , p3_a37 JTF_NUMBER_TABLE
578     , p3_a38 JTF_VARCHAR2_TABLE_100
579     , p3_a39 JTF_NUMBER_TABLE
580     , p3_a40 JTF_NUMBER_TABLE
581     , p3_a41 JTF_VARCHAR2_TABLE_100
582     , p3_a42 JTF_VARCHAR2_TABLE_100
583     , p3_a43 JTF_NUMBER_TABLE
584     , p3_a44 JTF_NUMBER_TABLE
585     , p3_a45 JTF_NUMBER_TABLE
586     , p3_a46 JTF_NUMBER_TABLE
587     , p3_a47 JTF_NUMBER_TABLE
588     , p3_a48 JTF_NUMBER_TABLE
589     , p3_a49 JTF_NUMBER_TABLE
590     , p3_a50 JTF_NUMBER_TABLE
591     , p3_a51 JTF_NUMBER_TABLE
592     , p3_a52 JTF_VARCHAR2_TABLE_100
593     , p3_a53 JTF_VARCHAR2_TABLE_100
594     , p3_a54 JTF_VARCHAR2_TABLE_100
595     , p3_a55 JTF_NUMBER_TABLE
596     , p3_a56 JTF_NUMBER_TABLE
597     , p3_a57 JTF_VARCHAR2_TABLE_100
598     , p3_a58 JTF_VARCHAR2_TABLE_100
599     , p3_a59 JTF_VARCHAR2_TABLE_100
600     , p3_a60 JTF_NUMBER_TABLE
601     , p3_a61 JTF_VARCHAR2_TABLE_100
602     , p3_a62 JTF_NUMBER_TABLE
603     , p3_a63 JTF_VARCHAR2_TABLE_100
604     , p3_a64 JTF_VARCHAR2_TABLE_100
605     , p3_a65 JTF_VARCHAR2_TABLE_100
606     , p3_a66 JTF_VARCHAR2_TABLE_100
607     , p3_a67 JTF_NUMBER_TABLE
608     , p3_a68 JTF_VARCHAR2_TABLE_300
609     , p3_a69 JTF_VARCHAR2_TABLE_300
610     , p3_a70 JTF_VARCHAR2_TABLE_2000
611     , p3_a71 JTF_VARCHAR2_TABLE_2000
612     , x_return_status out nocopy  VARCHAR2
613     , x_msg_count out nocopy  NUMBER
614     , x_msg_data out nocopy  VARCHAR2
615   );
616   procedure validate_lease_qte(p0_a0  NUMBER
617     , p0_a1  NUMBER
618     , p0_a2  VARCHAR2
619     , p0_a3  VARCHAR2
620     , p0_a4  VARCHAR2
621     , p0_a5  VARCHAR2
622     , p0_a6  VARCHAR2
623     , p0_a7  VARCHAR2
624     , p0_a8  VARCHAR2
625     , p0_a9  VARCHAR2
626     , p0_a10  VARCHAR2
627     , p0_a11  VARCHAR2
628     , p0_a12  VARCHAR2
629     , p0_a13  VARCHAR2
630     , p0_a14  VARCHAR2
631     , p0_a15  VARCHAR2
632     , p0_a16  VARCHAR2
633     , p0_a17  VARCHAR2
634     , p0_a18  VARCHAR2
635     , p0_a19  VARCHAR2
636     , p0_a20  VARCHAR2
637     , p0_a21  NUMBER
638     , p0_a22  DATE
639     , p0_a23  DATE
640     , p0_a24  VARCHAR2
641     , p0_a25  VARCHAR2
642     , p0_a26  DATE
643     , p0_a27  DATE
644     , p0_a28  DATE
645     , p0_a29  VARCHAR2
646     , p0_a30  NUMBER
647     , p0_a31  NUMBER
648     , p0_a32  NUMBER
649     , p0_a33  VARCHAR2
650     , p0_a34  VARCHAR2
651     , p0_a35  NUMBER
652     , p0_a36  NUMBER
653     , p0_a37  NUMBER
654     , p0_a38  VARCHAR2
655     , p0_a39  NUMBER
656     , p0_a40  NUMBER
657     , p0_a41  VARCHAR2
658     , p0_a42  VARCHAR2
659     , p0_a43  NUMBER
660     , p0_a44  NUMBER
661     , p0_a45  NUMBER
662     , p0_a46  NUMBER
663     , p0_a47  NUMBER
664     , p0_a48  NUMBER
665     , p0_a49  NUMBER
666     , p0_a50  NUMBER
667     , p0_a51  NUMBER
668     , p0_a52  VARCHAR2
669     , p0_a53  VARCHAR2
670     , p0_a54  VARCHAR2
671     , p0_a55  NUMBER
672     , p0_a56  NUMBER
673     , p0_a57  VARCHAR2
674     , p0_a58  VARCHAR2
675     , p0_a59  VARCHAR2
676     , p0_a60  NUMBER
677     , p0_a61  VARCHAR2
678     , p0_a62  NUMBER
679     , p0_a63  VARCHAR2
680     , p0_a64  VARCHAR2
681     , p0_a65  VARCHAR2
682     , p0_a66  VARCHAR2
683     , p0_a67  NUMBER
684     , p0_a68  VARCHAR2
685     , p0_a69  VARCHAR2
686     , p0_a70  VARCHAR2
687     , p0_a71  VARCHAR2
688     , x_return_status out nocopy  VARCHAR2
689   );
690 end okl_lease_quote_pvt_w;