DBA Data[Home] [Help]

PACKAGE: APPS.OKL_INS_QUOTE_PUB_W

Source


1 package okl_ins_quote_pub_w AUTHID CURRENT_USER as
2   /* $Header: OKLUINQS.pls 120.2 2005/09/19 11:37:41 pagarg noship $ */
3   procedure save_quote(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p5_a0 in out nocopy  NUMBER
9     , p5_a1 in out nocopy  VARCHAR2
10     , p5_a2 in out nocopy  VARCHAR2
11     , p5_a3 in out nocopy  VARCHAR2
12     , p5_a4 in out nocopy  VARCHAR2
13     , p5_a5 in out nocopy  VARCHAR2
14     , p5_a6 in out nocopy  VARCHAR2
15     , p5_a7 in out nocopy  VARCHAR2
16     , p5_a8 in out nocopy  VARCHAR2
17     , p5_a9 in out nocopy  NUMBER
18     , p5_a10 in out nocopy  NUMBER
19     , p5_a11 in out nocopy  NUMBER
20     , p5_a12 in out nocopy  NUMBER
21     , p5_a13 in out nocopy  NUMBER
22     , p5_a14 in out nocopy  VARCHAR2
23     , p5_a15 in out nocopy  VARCHAR2
24     , p5_a16 in out nocopy  VARCHAR2
25     , p5_a17 in out nocopy  VARCHAR2
26     , p5_a18 in out nocopy  VARCHAR2
27     , p5_a19 in out nocopy  DATE
28     , p5_a20 in out nocopy  DATE
29     , p5_a21 in out nocopy  DATE
30     , p5_a22 in out nocopy  DATE
31     , p5_a23 in out nocopy  DATE
32     , p5_a24 in out nocopy  DATE
33     , p5_a25 in out nocopy  DATE
34     , p5_a26 in out nocopy  DATE
35     , p5_a27 in out nocopy  VARCHAR2
36     , p5_a28 in out nocopy  VARCHAR2
37     , p5_a29 in out nocopy  VARCHAR2
38     , p5_a30 in out nocopy  VARCHAR2
39     , p5_a31 in out nocopy  VARCHAR2
40     , p5_a32 in out nocopy  VARCHAR2
41     , p5_a33 in out nocopy  NUMBER
42     , p5_a34 in out nocopy  NUMBER
43     , p5_a35 in out nocopy  NUMBER
44     , p5_a36 in out nocopy  NUMBER
45     , p5_a37 in out nocopy  NUMBER
46     , p5_a38 in out nocopy  NUMBER
47     , p5_a39 in out nocopy  VARCHAR2
48     , p5_a40 in out nocopy  VARCHAR2
49     , p5_a41 in out nocopy  NUMBER
50     , p5_a42 in out nocopy  VARCHAR2
51     , p5_a43 in out nocopy  NUMBER
52     , p5_a44 in out nocopy  NUMBER
53     , p5_a45 in out nocopy  NUMBER
54     , p5_a46 in out nocopy  NUMBER
55     , p5_a47 in out nocopy  VARCHAR2
56     , p5_a48 in out nocopy  VARCHAR2
57     , p5_a49 in out nocopy  VARCHAR2
58     , p5_a50 in out nocopy  VARCHAR2
59     , p5_a51 in out nocopy  VARCHAR2
60     , p5_a52 in out nocopy  VARCHAR2
61     , p5_a53 in out nocopy  VARCHAR2
62     , p5_a54 in out nocopy  VARCHAR2
63     , p5_a55 in out nocopy  VARCHAR2
64     , p5_a56 in out nocopy  VARCHAR2
65     , p5_a57 in out nocopy  VARCHAR2
66     , p5_a58 in out nocopy  VARCHAR2
67     , p5_a59 in out nocopy  VARCHAR2
68     , p5_a60 in out nocopy  VARCHAR2
69     , p5_a61 in out nocopy  VARCHAR2
70     , p5_a62 in out nocopy  VARCHAR2
71     , p5_a63 in out nocopy  VARCHAR2
72     , p5_a64 in out nocopy  NUMBER
73     , p5_a65 in out nocopy  NUMBER
74     , p5_a66 in out nocopy  DATE
75     , p5_a67 in out nocopy  NUMBER
76     , p5_a68 in out nocopy  NUMBER
77     , p5_a69 in out nocopy  NUMBER
78     , p5_a70 in out nocopy  NUMBER
79     , p5_a71 in out nocopy  DATE
80     , p5_a72 in out nocopy  NUMBER
81     , p5_a73 in out nocopy  DATE
82     , p5_a74 in out nocopy  NUMBER
83     , p5_a75 in out nocopy  NUMBER
84     , x_message out nocopy  VARCHAR2
85   );
86   procedure save_accept_quote(p_api_version  NUMBER
87     , p_init_msg_list  VARCHAR2
88     , x_return_status out nocopy  VARCHAR2
89     , x_msg_count out nocopy  NUMBER
90     , x_msg_data out nocopy  VARCHAR2
91     , x_message out nocopy  VARCHAR2
92     , p5_a0  NUMBER := 0-1962.0724
93     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
94     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
95     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
96     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
97     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
98     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
99     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
100     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
101     , p5_a9  NUMBER := 0-1962.0724
102     , p5_a10  NUMBER := 0-1962.0724
103     , p5_a11  NUMBER := 0-1962.0724
104     , p5_a12  NUMBER := 0-1962.0724
105     , p5_a13  NUMBER := 0-1962.0724
106     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
107     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
108     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
109     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
110     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
111     , p5_a19  DATE := fnd_api.g_miss_date
112     , p5_a20  DATE := fnd_api.g_miss_date
113     , p5_a21  DATE := fnd_api.g_miss_date
114     , p5_a22  DATE := fnd_api.g_miss_date
115     , p5_a23  DATE := fnd_api.g_miss_date
116     , p5_a24  DATE := fnd_api.g_miss_date
117     , p5_a25  DATE := fnd_api.g_miss_date
118     , p5_a26  DATE := fnd_api.g_miss_date
119     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
120     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
121     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
122     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
123     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
124     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
125     , p5_a33  NUMBER := 0-1962.0724
126     , p5_a34  NUMBER := 0-1962.0724
127     , p5_a35  NUMBER := 0-1962.0724
128     , p5_a36  NUMBER := 0-1962.0724
129     , p5_a37  NUMBER := 0-1962.0724
130     , p5_a38  NUMBER := 0-1962.0724
131     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
132     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
133     , p5_a41  NUMBER := 0-1962.0724
134     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
135     , p5_a43  NUMBER := 0-1962.0724
136     , p5_a44  NUMBER := 0-1962.0724
137     , p5_a45  NUMBER := 0-1962.0724
138     , p5_a46  NUMBER := 0-1962.0724
139     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
140     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
141     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
142     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
143     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
144     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
145     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
146     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
147     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
148     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
149     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
150     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
151     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
152     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
153     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
154     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
155     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a64  NUMBER := 0-1962.0724
157     , p5_a65  NUMBER := 0-1962.0724
158     , p5_a66  DATE := fnd_api.g_miss_date
159     , p5_a67  NUMBER := 0-1962.0724
160     , p5_a68  NUMBER := 0-1962.0724
161     , p5_a69  NUMBER := 0-1962.0724
162     , p5_a70  NUMBER := 0-1962.0724
163     , p5_a71  DATE := fnd_api.g_miss_date
164     , p5_a72  NUMBER := 0-1962.0724
165     , p5_a73  DATE := fnd_api.g_miss_date
166     , p5_a74  NUMBER := 0-1962.0724
167     , p5_a75  NUMBER := 0-1962.0724
168   );
169   procedure create_ins_streams(p_api_version  NUMBER
170     , p_init_msg_list  VARCHAR2
171     , x_return_status out nocopy  VARCHAR2
172     , x_msg_count out nocopy  NUMBER
173     , x_msg_data out nocopy  VARCHAR2
174     , p5_a0  NUMBER := 0-1962.0724
175     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
176     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
177     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
178     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
179     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
180     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
181     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
182     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
183     , p5_a9  NUMBER := 0-1962.0724
184     , p5_a10  NUMBER := 0-1962.0724
185     , p5_a11  NUMBER := 0-1962.0724
186     , p5_a12  NUMBER := 0-1962.0724
187     , p5_a13  NUMBER := 0-1962.0724
188     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
190     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
192     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
193     , p5_a19  DATE := fnd_api.g_miss_date
194     , p5_a20  DATE := fnd_api.g_miss_date
195     , p5_a21  DATE := fnd_api.g_miss_date
196     , p5_a22  DATE := fnd_api.g_miss_date
197     , p5_a23  DATE := fnd_api.g_miss_date
198     , p5_a24  DATE := fnd_api.g_miss_date
199     , p5_a25  DATE := fnd_api.g_miss_date
200     , p5_a26  DATE := fnd_api.g_miss_date
201     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
202     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
203     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
205     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
206     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
207     , p5_a33  NUMBER := 0-1962.0724
208     , p5_a34  NUMBER := 0-1962.0724
209     , p5_a35  NUMBER := 0-1962.0724
210     , p5_a36  NUMBER := 0-1962.0724
211     , p5_a37  NUMBER := 0-1962.0724
212     , p5_a38  NUMBER := 0-1962.0724
213     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
214     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
215     , p5_a41  NUMBER := 0-1962.0724
216     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
217     , p5_a43  NUMBER := 0-1962.0724
218     , p5_a44  NUMBER := 0-1962.0724
219     , p5_a45  NUMBER := 0-1962.0724
220     , p5_a46  NUMBER := 0-1962.0724
221     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
222     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
223     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
224     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a64  NUMBER := 0-1962.0724
239     , p5_a65  NUMBER := 0-1962.0724
240     , p5_a66  DATE := fnd_api.g_miss_date
241     , p5_a67  NUMBER := 0-1962.0724
242     , p5_a68  NUMBER := 0-1962.0724
243     , p5_a69  NUMBER := 0-1962.0724
244     , p5_a70  NUMBER := 0-1962.0724
245     , p5_a71  DATE := fnd_api.g_miss_date
246     , p5_a72  NUMBER := 0-1962.0724
247     , p5_a73  DATE := fnd_api.g_miss_date
248     , p5_a74  NUMBER := 0-1962.0724
249     , p5_a75  NUMBER := 0-1962.0724
250   );
251   procedure calc_lease_premium(p_api_version  NUMBER
252     , p_init_msg_list  VARCHAR2
253     , x_return_status out nocopy  VARCHAR2
254     , x_msg_count out nocopy  NUMBER
255     , x_msg_data out nocopy  VARCHAR2
256     , p5_a0 in out nocopy  NUMBER
257     , p5_a1 in out nocopy  VARCHAR2
258     , p5_a2 in out nocopy  VARCHAR2
259     , p5_a3 in out nocopy  VARCHAR2
260     , p5_a4 in out nocopy  VARCHAR2
261     , p5_a5 in out nocopy  VARCHAR2
262     , p5_a6 in out nocopy  VARCHAR2
263     , p5_a7 in out nocopy  VARCHAR2
264     , p5_a8 in out nocopy  VARCHAR2
265     , p5_a9 in out nocopy  NUMBER
266     , p5_a10 in out nocopy  NUMBER
267     , p5_a11 in out nocopy  NUMBER
268     , p5_a12 in out nocopy  NUMBER
269     , p5_a13 in out nocopy  NUMBER
270     , p5_a14 in out nocopy  VARCHAR2
271     , p5_a15 in out nocopy  VARCHAR2
272     , p5_a16 in out nocopy  VARCHAR2
273     , p5_a17 in out nocopy  VARCHAR2
274     , p5_a18 in out nocopy  VARCHAR2
275     , p5_a19 in out nocopy  DATE
276     , p5_a20 in out nocopy  DATE
277     , p5_a21 in out nocopy  DATE
278     , p5_a22 in out nocopy  DATE
279     , p5_a23 in out nocopy  DATE
280     , p5_a24 in out nocopy  DATE
281     , p5_a25 in out nocopy  DATE
282     , p5_a26 in out nocopy  DATE
283     , p5_a27 in out nocopy  VARCHAR2
284     , p5_a28 in out nocopy  VARCHAR2
285     , p5_a29 in out nocopy  VARCHAR2
286     , p5_a30 in out nocopy  VARCHAR2
287     , p5_a31 in out nocopy  VARCHAR2
288     , p5_a32 in out nocopy  VARCHAR2
289     , p5_a33 in out nocopy  NUMBER
290     , p5_a34 in out nocopy  NUMBER
291     , p5_a35 in out nocopy  NUMBER
292     , p5_a36 in out nocopy  NUMBER
293     , p5_a37 in out nocopy  NUMBER
294     , p5_a38 in out nocopy  NUMBER
295     , p5_a39 in out nocopy  VARCHAR2
296     , p5_a40 in out nocopy  VARCHAR2
297     , p5_a41 in out nocopy  NUMBER
298     , p5_a42 in out nocopy  VARCHAR2
299     , p5_a43 in out nocopy  NUMBER
300     , p5_a44 in out nocopy  NUMBER
301     , p5_a45 in out nocopy  NUMBER
302     , p5_a46 in out nocopy  NUMBER
303     , p5_a47 in out nocopy  VARCHAR2
304     , p5_a48 in out nocopy  VARCHAR2
305     , p5_a49 in out nocopy  VARCHAR2
309     , p5_a53 in out nocopy  VARCHAR2
306     , p5_a50 in out nocopy  VARCHAR2
307     , p5_a51 in out nocopy  VARCHAR2
308     , p5_a52 in out nocopy  VARCHAR2
310     , p5_a54 in out nocopy  VARCHAR2
311     , p5_a55 in out nocopy  VARCHAR2
312     , p5_a56 in out nocopy  VARCHAR2
313     , p5_a57 in out nocopy  VARCHAR2
314     , p5_a58 in out nocopy  VARCHAR2
315     , p5_a59 in out nocopy  VARCHAR2
316     , p5_a60 in out nocopy  VARCHAR2
317     , p5_a61 in out nocopy  VARCHAR2
318     , p5_a62 in out nocopy  VARCHAR2
319     , p5_a63 in out nocopy  VARCHAR2
320     , p5_a64 in out nocopy  NUMBER
321     , p5_a65 in out nocopy  NUMBER
322     , p5_a66 in out nocopy  DATE
323     , p5_a67 in out nocopy  NUMBER
324     , p5_a68 in out nocopy  NUMBER
325     , p5_a69 in out nocopy  NUMBER
326     , p5_a70 in out nocopy  NUMBER
327     , p5_a71 in out nocopy  DATE
328     , p5_a72 in out nocopy  NUMBER
329     , p5_a73 in out nocopy  DATE
330     , p5_a74 in out nocopy  NUMBER
331     , p5_a75 in out nocopy  NUMBER
332     , x_message out nocopy  VARCHAR2
333     , p7_a0 out nocopy JTF_NUMBER_TABLE
334     , p7_a1 out nocopy JTF_NUMBER_TABLE
335     , p7_a2 out nocopy JTF_NUMBER_TABLE
336   );
337   procedure calc_optional_premium(p_api_version  NUMBER
338     , p_init_msg_list  VARCHAR2
339     , x_return_status out nocopy  VARCHAR2
340     , x_msg_count out nocopy  NUMBER
341     , x_msg_data out nocopy  VARCHAR2
342     , x_message out nocopy  VARCHAR2
343     , p7_a0 out nocopy  NUMBER
344     , p7_a1 out nocopy  VARCHAR2
345     , p7_a2 out nocopy  VARCHAR2
346     , p7_a3 out nocopy  VARCHAR2
347     , p7_a4 out nocopy  VARCHAR2
348     , p7_a5 out nocopy  VARCHAR2
349     , p7_a6 out nocopy  VARCHAR2
350     , p7_a7 out nocopy  VARCHAR2
351     , p7_a8 out nocopy  VARCHAR2
352     , p7_a9 out nocopy  NUMBER
353     , p7_a10 out nocopy  NUMBER
354     , p7_a11 out nocopy  NUMBER
355     , p7_a12 out nocopy  NUMBER
356     , p7_a13 out nocopy  NUMBER
357     , p7_a14 out nocopy  VARCHAR2
358     , p7_a15 out nocopy  VARCHAR2
359     , p7_a16 out nocopy  VARCHAR2
360     , p7_a17 out nocopy  VARCHAR2
361     , p7_a18 out nocopy  VARCHAR2
362     , p7_a19 out nocopy  DATE
363     , p7_a20 out nocopy  DATE
364     , p7_a21 out nocopy  DATE
365     , p7_a22 out nocopy  DATE
366     , p7_a23 out nocopy  DATE
367     , p7_a24 out nocopy  DATE
368     , p7_a25 out nocopy  DATE
369     , p7_a26 out nocopy  DATE
370     , p7_a27 out nocopy  VARCHAR2
371     , p7_a28 out nocopy  VARCHAR2
372     , p7_a29 out nocopy  VARCHAR2
373     , p7_a30 out nocopy  VARCHAR2
374     , p7_a31 out nocopy  VARCHAR2
375     , p7_a32 out nocopy  VARCHAR2
376     , p7_a33 out nocopy  NUMBER
377     , p7_a34 out nocopy  NUMBER
378     , p7_a35 out nocopy  NUMBER
379     , p7_a36 out nocopy  NUMBER
380     , p7_a37 out nocopy  NUMBER
381     , p7_a38 out nocopy  NUMBER
382     , p7_a39 out nocopy  VARCHAR2
383     , p7_a40 out nocopy  VARCHAR2
384     , p7_a41 out nocopy  NUMBER
385     , p7_a42 out nocopy  VARCHAR2
386     , p7_a43 out nocopy  NUMBER
387     , p7_a44 out nocopy  NUMBER
388     , p7_a45 out nocopy  NUMBER
389     , p7_a46 out nocopy  NUMBER
390     , p7_a47 out nocopy  VARCHAR2
391     , p7_a48 out nocopy  VARCHAR2
392     , p7_a49 out nocopy  VARCHAR2
393     , p7_a50 out nocopy  VARCHAR2
394     , p7_a51 out nocopy  VARCHAR2
395     , p7_a52 out nocopy  VARCHAR2
396     , p7_a53 out nocopy  VARCHAR2
397     , p7_a54 out nocopy  VARCHAR2
398     , p7_a55 out nocopy  VARCHAR2
399     , p7_a56 out nocopy  VARCHAR2
400     , p7_a57 out nocopy  VARCHAR2
401     , p7_a58 out nocopy  VARCHAR2
402     , p7_a59 out nocopy  VARCHAR2
403     , p7_a60 out nocopy  VARCHAR2
404     , p7_a61 out nocopy  VARCHAR2
405     , p7_a62 out nocopy  VARCHAR2
406     , p7_a63 out nocopy  VARCHAR2
407     , p7_a64 out nocopy  NUMBER
408     , p7_a65 out nocopy  NUMBER
409     , p7_a66 out nocopy  DATE
410     , p7_a67 out nocopy  NUMBER
411     , p7_a68 out nocopy  NUMBER
412     , p7_a69 out nocopy  NUMBER
413     , p7_a70 out nocopy  NUMBER
414     , p7_a71 out nocopy  DATE
415     , p7_a72 out nocopy  NUMBER
416     , p7_a73 out nocopy  DATE
417     , p7_a74 out nocopy  NUMBER
418     , p7_a75 out nocopy  NUMBER
419     , p5_a0  NUMBER := 0-1962.0724
420     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
421     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
422     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
423     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
424     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
425     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
426     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
427     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
428     , p5_a9  NUMBER := 0-1962.0724
429     , p5_a10  NUMBER := 0-1962.0724
430     , p5_a11  NUMBER := 0-1962.0724
431     , p5_a12  NUMBER := 0-1962.0724
432     , p5_a13  NUMBER := 0-1962.0724
433     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
434     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
435     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
436     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
437     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
438     , p5_a19  DATE := fnd_api.g_miss_date
439     , p5_a20  DATE := fnd_api.g_miss_date
443     , p5_a24  DATE := fnd_api.g_miss_date
440     , p5_a21  DATE := fnd_api.g_miss_date
441     , p5_a22  DATE := fnd_api.g_miss_date
442     , p5_a23  DATE := fnd_api.g_miss_date
444     , p5_a25  DATE := fnd_api.g_miss_date
445     , p5_a26  DATE := fnd_api.g_miss_date
446     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
447     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
448     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
449     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
450     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
451     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
452     , p5_a33  NUMBER := 0-1962.0724
453     , p5_a34  NUMBER := 0-1962.0724
454     , p5_a35  NUMBER := 0-1962.0724
455     , p5_a36  NUMBER := 0-1962.0724
456     , p5_a37  NUMBER := 0-1962.0724
457     , p5_a38  NUMBER := 0-1962.0724
458     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
459     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
460     , p5_a41  NUMBER := 0-1962.0724
461     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
462     , p5_a43  NUMBER := 0-1962.0724
463     , p5_a44  NUMBER := 0-1962.0724
464     , p5_a45  NUMBER := 0-1962.0724
465     , p5_a46  NUMBER := 0-1962.0724
466     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
467     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
468     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
469     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
470     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
471     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
472     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
473     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
474     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
475     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
476     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
477     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
478     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
479     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
480     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
481     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
482     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
483     , p5_a64  NUMBER := 0-1962.0724
484     , p5_a65  NUMBER := 0-1962.0724
485     , p5_a66  DATE := fnd_api.g_miss_date
486     , p5_a67  NUMBER := 0-1962.0724
487     , p5_a68  NUMBER := 0-1962.0724
488     , p5_a69  NUMBER := 0-1962.0724
489     , p5_a70  NUMBER := 0-1962.0724
490     , p5_a71  DATE := fnd_api.g_miss_date
491     , p5_a72  NUMBER := 0-1962.0724
492     , p5_a73  DATE := fnd_api.g_miss_date
493     , p5_a74  NUMBER := 0-1962.0724
494     , p5_a75  NUMBER := 0-1962.0724
495   );
496   procedure activate_ins_stream(p_api_version  NUMBER
497     , p_init_msg_list  VARCHAR2
498     , x_return_status out nocopy  VARCHAR2
499     , x_msg_count out nocopy  NUMBER
500     , x_msg_data out nocopy  VARCHAR2
501     , p5_a0  NUMBER := 0-1962.0724
502     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
503     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
504     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
505     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
506     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
507     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
508     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
509     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
510     , p5_a9  NUMBER := 0-1962.0724
511     , p5_a10  NUMBER := 0-1962.0724
512     , p5_a11  NUMBER := 0-1962.0724
513     , p5_a12  NUMBER := 0-1962.0724
514     , p5_a13  NUMBER := 0-1962.0724
515     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
516     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
517     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
518     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
519     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
520     , p5_a19  DATE := fnd_api.g_miss_date
521     , p5_a20  DATE := fnd_api.g_miss_date
522     , p5_a21  DATE := fnd_api.g_miss_date
523     , p5_a22  DATE := fnd_api.g_miss_date
524     , p5_a23  DATE := fnd_api.g_miss_date
525     , p5_a24  DATE := fnd_api.g_miss_date
526     , p5_a25  DATE := fnd_api.g_miss_date
527     , p5_a26  DATE := fnd_api.g_miss_date
528     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
529     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
530     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
531     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
532     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
533     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
534     , p5_a33  NUMBER := 0-1962.0724
535     , p5_a34  NUMBER := 0-1962.0724
536     , p5_a35  NUMBER := 0-1962.0724
537     , p5_a36  NUMBER := 0-1962.0724
538     , p5_a37  NUMBER := 0-1962.0724
539     , p5_a38  NUMBER := 0-1962.0724
540     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
541     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
542     , p5_a41  NUMBER := 0-1962.0724
543     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
544     , p5_a43  NUMBER := 0-1962.0724
545     , p5_a44  NUMBER := 0-1962.0724
546     , p5_a45  NUMBER := 0-1962.0724
547     , p5_a46  NUMBER := 0-1962.0724
548     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
549     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
550     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
551     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
552     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
553     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
554     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
555     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
556     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
557     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
558     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
562     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
559     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
560     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
561     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
563     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
564     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
565     , p5_a64  NUMBER := 0-1962.0724
566     , p5_a65  NUMBER := 0-1962.0724
567     , p5_a66  DATE := fnd_api.g_miss_date
568     , p5_a67  NUMBER := 0-1962.0724
569     , p5_a68  NUMBER := 0-1962.0724
570     , p5_a69  NUMBER := 0-1962.0724
571     , p5_a70  NUMBER := 0-1962.0724
572     , p5_a71  DATE := fnd_api.g_miss_date
573     , p5_a72  NUMBER := 0-1962.0724
574     , p5_a73  DATE := fnd_api.g_miss_date
575     , p5_a74  NUMBER := 0-1962.0724
576     , p5_a75  NUMBER := 0-1962.0724
577   );
578   procedure create_third_prt_ins(p_api_version  NUMBER
579     , p_init_msg_list  VARCHAR2
580     , x_return_status out nocopy  VARCHAR2
581     , x_msg_count out nocopy  NUMBER
582     , x_msg_data out nocopy  VARCHAR2
583     , p6_a0 out nocopy  NUMBER
584     , p6_a1 out nocopy  VARCHAR2
585     , p6_a2 out nocopy  VARCHAR2
586     , p6_a3 out nocopy  VARCHAR2
587     , p6_a4 out nocopy  VARCHAR2
588     , p6_a5 out nocopy  VARCHAR2
589     , p6_a6 out nocopy  VARCHAR2
590     , p6_a7 out nocopy  VARCHAR2
591     , p6_a8 out nocopy  VARCHAR2
592     , p6_a9 out nocopy  NUMBER
593     , p6_a10 out nocopy  NUMBER
594     , p6_a11 out nocopy  NUMBER
595     , p6_a12 out nocopy  NUMBER
596     , p6_a13 out nocopy  NUMBER
597     , p6_a14 out nocopy  VARCHAR2
598     , p6_a15 out nocopy  VARCHAR2
599     , p6_a16 out nocopy  VARCHAR2
600     , p6_a17 out nocopy  VARCHAR2
601     , p6_a18 out nocopy  VARCHAR2
602     , p6_a19 out nocopy  DATE
603     , p6_a20 out nocopy  DATE
604     , p6_a21 out nocopy  DATE
605     , p6_a22 out nocopy  DATE
606     , p6_a23 out nocopy  DATE
607     , p6_a24 out nocopy  DATE
608     , p6_a25 out nocopy  DATE
609     , p6_a26 out nocopy  DATE
610     , p6_a27 out nocopy  VARCHAR2
611     , p6_a28 out nocopy  VARCHAR2
612     , p6_a29 out nocopy  VARCHAR2
613     , p6_a30 out nocopy  VARCHAR2
614     , p6_a31 out nocopy  VARCHAR2
615     , p6_a32 out nocopy  VARCHAR2
616     , p6_a33 out nocopy  NUMBER
617     , p6_a34 out nocopy  NUMBER
618     , p6_a35 out nocopy  NUMBER
619     , p6_a36 out nocopy  NUMBER
620     , p6_a37 out nocopy  NUMBER
621     , p6_a38 out nocopy  NUMBER
622     , p6_a39 out nocopy  VARCHAR2
623     , p6_a40 out nocopy  VARCHAR2
624     , p6_a41 out nocopy  NUMBER
625     , p6_a42 out nocopy  VARCHAR2
626     , p6_a43 out nocopy  NUMBER
627     , p6_a44 out nocopy  NUMBER
628     , p6_a45 out nocopy  NUMBER
629     , p6_a46 out nocopy  NUMBER
630     , p6_a47 out nocopy  VARCHAR2
631     , p6_a48 out nocopy  VARCHAR2
632     , p6_a49 out nocopy  VARCHAR2
633     , p6_a50 out nocopy  VARCHAR2
634     , p6_a51 out nocopy  VARCHAR2
635     , p6_a52 out nocopy  VARCHAR2
636     , p6_a53 out nocopy  VARCHAR2
637     , p6_a54 out nocopy  VARCHAR2
638     , p6_a55 out nocopy  VARCHAR2
639     , p6_a56 out nocopy  VARCHAR2
640     , p6_a57 out nocopy  VARCHAR2
641     , p6_a58 out nocopy  VARCHAR2
642     , p6_a59 out nocopy  VARCHAR2
643     , p6_a60 out nocopy  VARCHAR2
644     , p6_a61 out nocopy  VARCHAR2
645     , p6_a62 out nocopy  VARCHAR2
646     , p6_a63 out nocopy  VARCHAR2
647     , p6_a64 out nocopy  NUMBER
648     , p6_a65 out nocopy  NUMBER
649     , p6_a66 out nocopy  DATE
650     , p6_a67 out nocopy  NUMBER
651     , p6_a68 out nocopy  NUMBER
652     , p6_a69 out nocopy  NUMBER
653     , p6_a70 out nocopy  NUMBER
654     , p6_a71 out nocopy  DATE
655     , p6_a72 out nocopy  NUMBER
656     , p6_a73 out nocopy  DATE
657     , p6_a74 out nocopy  NUMBER
658     , p6_a75 out nocopy  NUMBER
659     , p5_a0  NUMBER := 0-1962.0724
660     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
661     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
662     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
663     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
664     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
665     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
666     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
667     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
668     , p5_a9  NUMBER := 0-1962.0724
669     , p5_a10  NUMBER := 0-1962.0724
670     , p5_a11  NUMBER := 0-1962.0724
671     , p5_a12  NUMBER := 0-1962.0724
672     , p5_a13  NUMBER := 0-1962.0724
673     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
674     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
675     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
676     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
677     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
678     , p5_a19  DATE := fnd_api.g_miss_date
679     , p5_a20  DATE := fnd_api.g_miss_date
680     , p5_a21  DATE := fnd_api.g_miss_date
681     , p5_a22  DATE := fnd_api.g_miss_date
682     , p5_a23  DATE := fnd_api.g_miss_date
683     , p5_a24  DATE := fnd_api.g_miss_date
684     , p5_a25  DATE := fnd_api.g_miss_date
685     , p5_a26  DATE := fnd_api.g_miss_date
686     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
687     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
688     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
689     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
693     , p5_a34  NUMBER := 0-1962.0724
690     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
691     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
692     , p5_a33  NUMBER := 0-1962.0724
694     , p5_a35  NUMBER := 0-1962.0724
695     , p5_a36  NUMBER := 0-1962.0724
696     , p5_a37  NUMBER := 0-1962.0724
697     , p5_a38  NUMBER := 0-1962.0724
698     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
699     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
700     , p5_a41  NUMBER := 0-1962.0724
701     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
702     , p5_a43  NUMBER := 0-1962.0724
703     , p5_a44  NUMBER := 0-1962.0724
704     , p5_a45  NUMBER := 0-1962.0724
705     , p5_a46  NUMBER := 0-1962.0724
706     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
707     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
708     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
709     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
710     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
711     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
712     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
713     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
714     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
715     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
716     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
717     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
718     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
719     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
720     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
721     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
722     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
723     , p5_a64  NUMBER := 0-1962.0724
724     , p5_a65  NUMBER := 0-1962.0724
725     , p5_a66  DATE := fnd_api.g_miss_date
726     , p5_a67  NUMBER := 0-1962.0724
727     , p5_a68  NUMBER := 0-1962.0724
728     , p5_a69  NUMBER := 0-1962.0724
729     , p5_a70  NUMBER := 0-1962.0724
730     , p5_a71  DATE := fnd_api.g_miss_date
731     , p5_a72  NUMBER := 0-1962.0724
732     , p5_a73  DATE := fnd_api.g_miss_date
733     , p5_a74  NUMBER := 0-1962.0724
734     , p5_a75  NUMBER := 0-1962.0724
735   );
736   procedure crt_lseapp_thrdprt_ins(p_api_version  NUMBER
737     , p_init_msg_list  VARCHAR2
738     , x_return_status out nocopy  VARCHAR2
739     , x_msg_count out nocopy  NUMBER
740     , x_msg_data out nocopy  VARCHAR2
741     , p6_a0 out nocopy  NUMBER
742     , p6_a1 out nocopy  VARCHAR2
743     , p6_a2 out nocopy  VARCHAR2
744     , p6_a3 out nocopy  VARCHAR2
745     , p6_a4 out nocopy  VARCHAR2
746     , p6_a5 out nocopy  VARCHAR2
747     , p6_a6 out nocopy  VARCHAR2
748     , p6_a7 out nocopy  VARCHAR2
749     , p6_a8 out nocopy  VARCHAR2
750     , p6_a9 out nocopy  NUMBER
751     , p6_a10 out nocopy  NUMBER
752     , p6_a11 out nocopy  NUMBER
753     , p6_a12 out nocopy  NUMBER
754     , p6_a13 out nocopy  NUMBER
755     , p6_a14 out nocopy  VARCHAR2
756     , p6_a15 out nocopy  VARCHAR2
757     , p6_a16 out nocopy  VARCHAR2
758     , p6_a17 out nocopy  VARCHAR2
759     , p6_a18 out nocopy  VARCHAR2
760     , p6_a19 out nocopy  DATE
761     , p6_a20 out nocopy  DATE
762     , p6_a21 out nocopy  DATE
763     , p6_a22 out nocopy  DATE
764     , p6_a23 out nocopy  DATE
765     , p6_a24 out nocopy  DATE
766     , p6_a25 out nocopy  DATE
767     , p6_a26 out nocopy  DATE
768     , p6_a27 out nocopy  VARCHAR2
769     , p6_a28 out nocopy  VARCHAR2
770     , p6_a29 out nocopy  VARCHAR2
771     , p6_a30 out nocopy  VARCHAR2
772     , p6_a31 out nocopy  VARCHAR2
773     , p6_a32 out nocopy  VARCHAR2
774     , p6_a33 out nocopy  NUMBER
775     , p6_a34 out nocopy  NUMBER
776     , p6_a35 out nocopy  NUMBER
777     , p6_a36 out nocopy  NUMBER
778     , p6_a37 out nocopy  NUMBER
779     , p6_a38 out nocopy  NUMBER
780     , p6_a39 out nocopy  VARCHAR2
781     , p6_a40 out nocopy  VARCHAR2
782     , p6_a41 out nocopy  NUMBER
783     , p6_a42 out nocopy  VARCHAR2
784     , p6_a43 out nocopy  NUMBER
785     , p6_a44 out nocopy  NUMBER
786     , p6_a45 out nocopy  NUMBER
787     , p6_a46 out nocopy  NUMBER
788     , p6_a47 out nocopy  VARCHAR2
789     , p6_a48 out nocopy  VARCHAR2
790     , p6_a49 out nocopy  VARCHAR2
791     , p6_a50 out nocopy  VARCHAR2
792     , p6_a51 out nocopy  VARCHAR2
793     , p6_a52 out nocopy  VARCHAR2
794     , p6_a53 out nocopy  VARCHAR2
795     , p6_a54 out nocopy  VARCHAR2
796     , p6_a55 out nocopy  VARCHAR2
797     , p6_a56 out nocopy  VARCHAR2
798     , p6_a57 out nocopy  VARCHAR2
799     , p6_a58 out nocopy  VARCHAR2
800     , p6_a59 out nocopy  VARCHAR2
801     , p6_a60 out nocopy  VARCHAR2
802     , p6_a61 out nocopy  VARCHAR2
803     , p6_a62 out nocopy  VARCHAR2
804     , p6_a63 out nocopy  VARCHAR2
805     , p6_a64 out nocopy  NUMBER
806     , p6_a65 out nocopy  NUMBER
807     , p6_a66 out nocopy  DATE
808     , p6_a67 out nocopy  NUMBER
809     , p6_a68 out nocopy  NUMBER
810     , p6_a69 out nocopy  NUMBER
811     , p6_a70 out nocopy  NUMBER
812     , p6_a71 out nocopy  DATE
813     , p6_a72 out nocopy  NUMBER
814     , p6_a73 out nocopy  DATE
815     , p6_a74 out nocopy  NUMBER
816     , p6_a75 out nocopy  NUMBER
817     , p5_a0  NUMBER := 0-1962.0724
818     , p5_a1  VARCHAR2 := fnd_api.g_miss_char
819     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
820     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
821     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
825     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
822     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
823     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
824     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
826     , p5_a9  NUMBER := 0-1962.0724
827     , p5_a10  NUMBER := 0-1962.0724
828     , p5_a11  NUMBER := 0-1962.0724
829     , p5_a12  NUMBER := 0-1962.0724
830     , p5_a13  NUMBER := 0-1962.0724
831     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
832     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
833     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
834     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
835     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
836     , p5_a19  DATE := fnd_api.g_miss_date
837     , p5_a20  DATE := fnd_api.g_miss_date
838     , p5_a21  DATE := fnd_api.g_miss_date
839     , p5_a22  DATE := fnd_api.g_miss_date
840     , p5_a23  DATE := fnd_api.g_miss_date
841     , p5_a24  DATE := fnd_api.g_miss_date
842     , p5_a25  DATE := fnd_api.g_miss_date
843     , p5_a26  DATE := fnd_api.g_miss_date
844     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
845     , p5_a28  VARCHAR2 := fnd_api.g_miss_char
846     , p5_a29  VARCHAR2 := fnd_api.g_miss_char
847     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
848     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
849     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
850     , p5_a33  NUMBER := 0-1962.0724
851     , p5_a34  NUMBER := 0-1962.0724
852     , p5_a35  NUMBER := 0-1962.0724
853     , p5_a36  NUMBER := 0-1962.0724
854     , p5_a37  NUMBER := 0-1962.0724
855     , p5_a38  NUMBER := 0-1962.0724
856     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
857     , p5_a40  VARCHAR2 := fnd_api.g_miss_char
858     , p5_a41  NUMBER := 0-1962.0724
859     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
860     , p5_a43  NUMBER := 0-1962.0724
861     , p5_a44  NUMBER := 0-1962.0724
862     , p5_a45  NUMBER := 0-1962.0724
863     , p5_a46  NUMBER := 0-1962.0724
864     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
865     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
866     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
867     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
868     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
869     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
870     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
871     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
872     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
873     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
874     , p5_a57  VARCHAR2 := fnd_api.g_miss_char
875     , p5_a58  VARCHAR2 := fnd_api.g_miss_char
876     , p5_a59  VARCHAR2 := fnd_api.g_miss_char
877     , p5_a60  VARCHAR2 := fnd_api.g_miss_char
878     , p5_a61  VARCHAR2 := fnd_api.g_miss_char
879     , p5_a62  VARCHAR2 := fnd_api.g_miss_char
880     , p5_a63  VARCHAR2 := fnd_api.g_miss_char
881     , p5_a64  NUMBER := 0-1962.0724
882     , p5_a65  NUMBER := 0-1962.0724
883     , p5_a66  DATE := fnd_api.g_miss_date
884     , p5_a67  NUMBER := 0-1962.0724
885     , p5_a68  NUMBER := 0-1962.0724
886     , p5_a69  NUMBER := 0-1962.0724
887     , p5_a70  NUMBER := 0-1962.0724
888     , p5_a71  DATE := fnd_api.g_miss_date
889     , p5_a72  NUMBER := 0-1962.0724
890     , p5_a73  DATE := fnd_api.g_miss_date
891     , p5_a74  NUMBER := 0-1962.0724
892     , p5_a75  NUMBER := 0-1962.0724
893   );
894   procedure lseapp_thrdprty_to_ctrct(p_api_version  NUMBER
895     , p_init_msg_list  VARCHAR2
896     , x_return_status out nocopy  VARCHAR2
897     , x_msg_count out nocopy  NUMBER
898     , x_msg_data out nocopy  VARCHAR2
899     , p_lakhr_id  NUMBER
900     , p6_a0 out nocopy  NUMBER
901     , p6_a1 out nocopy  VARCHAR2
902     , p6_a2 out nocopy  VARCHAR2
903     , p6_a3 out nocopy  VARCHAR2
904     , p6_a4 out nocopy  VARCHAR2
905     , p6_a5 out nocopy  VARCHAR2
906     , p6_a6 out nocopy  VARCHAR2
907     , p6_a7 out nocopy  VARCHAR2
908     , p6_a8 out nocopy  VARCHAR2
909     , p6_a9 out nocopy  NUMBER
910     , p6_a10 out nocopy  NUMBER
911     , p6_a11 out nocopy  NUMBER
912     , p6_a12 out nocopy  NUMBER
913     , p6_a13 out nocopy  NUMBER
914     , p6_a14 out nocopy  VARCHAR2
915     , p6_a15 out nocopy  VARCHAR2
916     , p6_a16 out nocopy  VARCHAR2
917     , p6_a17 out nocopy  VARCHAR2
918     , p6_a18 out nocopy  VARCHAR2
919     , p6_a19 out nocopy  DATE
920     , p6_a20 out nocopy  DATE
921     , p6_a21 out nocopy  DATE
922     , p6_a22 out nocopy  DATE
923     , p6_a23 out nocopy  DATE
924     , p6_a24 out nocopy  DATE
925     , p6_a25 out nocopy  DATE
926     , p6_a26 out nocopy  DATE
927     , p6_a27 out nocopy  VARCHAR2
928     , p6_a28 out nocopy  VARCHAR2
929     , p6_a29 out nocopy  VARCHAR2
930     , p6_a30 out nocopy  VARCHAR2
931     , p6_a31 out nocopy  VARCHAR2
932     , p6_a32 out nocopy  VARCHAR2
933     , p6_a33 out nocopy  NUMBER
934     , p6_a34 out nocopy  NUMBER
935     , p6_a35 out nocopy  NUMBER
936     , p6_a36 out nocopy  NUMBER
937     , p6_a37 out nocopy  NUMBER
938     , p6_a38 out nocopy  NUMBER
939     , p6_a39 out nocopy  VARCHAR2
940     , p6_a40 out nocopy  VARCHAR2
941     , p6_a41 out nocopy  NUMBER
942     , p6_a42 out nocopy  VARCHAR2
943     , p6_a43 out nocopy  NUMBER
944     , p6_a44 out nocopy  NUMBER
945     , p6_a45 out nocopy  NUMBER
946     , p6_a46 out nocopy  NUMBER
947     , p6_a47 out nocopy  VARCHAR2
948     , p6_a48 out nocopy  VARCHAR2
949     , p6_a49 out nocopy  VARCHAR2
950     , p6_a50 out nocopy  VARCHAR2
951     , p6_a51 out nocopy  VARCHAR2
952     , p6_a52 out nocopy  VARCHAR2
953     , p6_a53 out nocopy  VARCHAR2
954     , p6_a54 out nocopy  VARCHAR2
955     , p6_a55 out nocopy  VARCHAR2
956     , p6_a56 out nocopy  VARCHAR2
957     , p6_a57 out nocopy  VARCHAR2
958     , p6_a58 out nocopy  VARCHAR2
959     , p6_a59 out nocopy  VARCHAR2
960     , p6_a60 out nocopy  VARCHAR2
961     , p6_a61 out nocopy  VARCHAR2
962     , p6_a62 out nocopy  VARCHAR2
963     , p6_a63 out nocopy  VARCHAR2
964     , p6_a64 out nocopy  NUMBER
965     , p6_a65 out nocopy  NUMBER
966     , p6_a66 out nocopy  DATE
967     , p6_a67 out nocopy  NUMBER
968     , p6_a68 out nocopy  NUMBER
969     , p6_a69 out nocopy  NUMBER
970     , p6_a70 out nocopy  NUMBER
971     , p6_a71 out nocopy  DATE
972     , p6_a72 out nocopy  NUMBER
973     , p6_a73 out nocopy  DATE
974     , p6_a74 out nocopy  NUMBER
975     , p6_a75 out nocopy  NUMBER
976   );
977 end okl_ins_quote_pub_w;