DBA Data[Home] [Help]

PACKAGE: APPS.OKL_AM_PARTIES_PVT_W

Source


1 package okl_am_parties_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLEAMPS.pls 115.10 2002/12/13 19:30:32 gkadarka noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_DATE_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_400
23     , a20 JTF_VARCHAR2_TABLE_2000
24     , a21 JTF_VARCHAR2_TABLE_100
25     , a22 JTF_VARCHAR2_TABLE_200
26     , a23 JTF_VARCHAR2_TABLE_100
27     , a24 JTF_VARCHAR2_TABLE_400
28     , a25 JTF_VARCHAR2_TABLE_2000
29     , a26 JTF_VARCHAR2_TABLE_2000
30     , a27 JTF_NUMBER_TABLE
31     , a28 JTF_DATE_TABLE
32     , a29 JTF_NUMBER_TABLE
33     , a30 JTF_VARCHAR2_TABLE_100
34     , a31 JTF_VARCHAR2_TABLE_100
35     , a32 JTF_VARCHAR2_TABLE_2000
36     , a33 JTF_VARCHAR2_TABLE_2000
37     , a34 JTF_NUMBER_TABLE
38     , a35 JTF_DATE_TABLE
39     );
40   procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41     , a1 out nocopy JTF_NUMBER_TABLE
42     , a2 out nocopy JTF_VARCHAR2_TABLE_100
43     , a3 out nocopy JTF_NUMBER_TABLE
44     , a4 out nocopy JTF_VARCHAR2_TABLE_100
45     , a5 out nocopy JTF_VARCHAR2_TABLE_100
46     , a6 out nocopy JTF_DATE_TABLE
47     , a7 out nocopy JTF_DATE_TABLE
48     , a8 out nocopy JTF_NUMBER_TABLE
49     , a9 out nocopy JTF_DATE_TABLE
50     , a10 out nocopy JTF_NUMBER_TABLE
51     , a11 out nocopy JTF_DATE_TABLE
52     , a12 out nocopy JTF_NUMBER_TABLE
53     , a13 out nocopy JTF_NUMBER_TABLE
54     , a14 out nocopy JTF_VARCHAR2_TABLE_100
55     , a15 out nocopy JTF_VARCHAR2_TABLE_100
56     , a16 out nocopy JTF_VARCHAR2_TABLE_100
57     , a17 out nocopy JTF_VARCHAR2_TABLE_200
58     , a18 out nocopy JTF_VARCHAR2_TABLE_100
59     , a19 out nocopy JTF_VARCHAR2_TABLE_400
60     , a20 out nocopy JTF_VARCHAR2_TABLE_2000
61     , a21 out nocopy JTF_VARCHAR2_TABLE_100
62     , a22 out nocopy JTF_VARCHAR2_TABLE_200
63     , a23 out nocopy JTF_VARCHAR2_TABLE_100
64     , a24 out nocopy JTF_VARCHAR2_TABLE_400
65     , a25 out nocopy JTF_VARCHAR2_TABLE_2000
66     , a26 out nocopy JTF_VARCHAR2_TABLE_2000
67     , a27 out nocopy JTF_NUMBER_TABLE
68     , a28 out nocopy JTF_DATE_TABLE
69     , a29 out nocopy JTF_NUMBER_TABLE
70     , a30 out nocopy JTF_VARCHAR2_TABLE_100
71     , a31 out nocopy JTF_VARCHAR2_TABLE_100
72     , a32 out nocopy JTF_VARCHAR2_TABLE_2000
73     , a33 out nocopy JTF_VARCHAR2_TABLE_2000
74     , a34 out nocopy JTF_NUMBER_TABLE
75     , a35 out nocopy JTF_DATE_TABLE
76     );
77 
78   procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100
79     , a1 JTF_VARCHAR2_TABLE_100
80     , a2 JTF_VARCHAR2_TABLE_200
81     , a3 JTF_VARCHAR2_TABLE_400
82     , a4 JTF_VARCHAR2_TABLE_2000
83     , a5 JTF_VARCHAR2_TABLE_100
84     , a6 JTF_VARCHAR2_TABLE_100
85     , a7 JTF_VARCHAR2_TABLE_200
86     , a8 JTF_VARCHAR2_TABLE_400
87     , a9 JTF_VARCHAR2_TABLE_2000
88     , a10 JTF_VARCHAR2_TABLE_100
89     , a11 JTF_VARCHAR2_TABLE_100
90     , a12 JTF_VARCHAR2_TABLE_200
91     , a13 JTF_VARCHAR2_TABLE_400
92     , a14 JTF_VARCHAR2_TABLE_2000
93     , a15 JTF_VARCHAR2_TABLE_2000
94     , a16 JTF_NUMBER_TABLE
95     , a17 JTF_NUMBER_TABLE
96     , a18 JTF_VARCHAR2_TABLE_100
97     , a19 JTF_VARCHAR2_TABLE_2000
98     );
99   procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
100     , a1 out nocopy JTF_VARCHAR2_TABLE_100
101     , a2 out nocopy JTF_VARCHAR2_TABLE_200
102     , a3 out nocopy JTF_VARCHAR2_TABLE_400
103     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
104     , a5 out nocopy JTF_VARCHAR2_TABLE_100
105     , a6 out nocopy JTF_VARCHAR2_TABLE_100
106     , a7 out nocopy JTF_VARCHAR2_TABLE_200
107     , a8 out nocopy JTF_VARCHAR2_TABLE_400
108     , a9 out nocopy JTF_VARCHAR2_TABLE_2000
109     , a10 out nocopy JTF_VARCHAR2_TABLE_100
110     , a11 out nocopy JTF_VARCHAR2_TABLE_100
111     , a12 out nocopy JTF_VARCHAR2_TABLE_200
112     , a13 out nocopy JTF_VARCHAR2_TABLE_400
113     , a14 out nocopy JTF_VARCHAR2_TABLE_2000
114     , a15 out nocopy JTF_VARCHAR2_TABLE_2000
115     , a16 out nocopy JTF_NUMBER_TABLE
116     , a17 out nocopy JTF_NUMBER_TABLE
117     , a18 out nocopy JTF_VARCHAR2_TABLE_100
118     , a19 out nocopy JTF_VARCHAR2_TABLE_2000
119     );
120 
121   procedure fetch_rule_quote_parties(p_api_version  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , x_msg_count out nocopy  NUMBER
124     , x_msg_data out nocopy  VARCHAR2
125     , x_return_status out nocopy  VARCHAR2
126     , p6_a0 out nocopy JTF_NUMBER_TABLE
127     , p6_a1 out nocopy JTF_NUMBER_TABLE
128     , p6_a2 out nocopy JTF_NUMBER_TABLE
129     , p6_a3 out nocopy JTF_NUMBER_TABLE
130     , p6_a4 out nocopy JTF_DATE_TABLE
131     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
132     , p6_a6 out nocopy JTF_NUMBER_TABLE
133     , p6_a7 out nocopy JTF_NUMBER_TABLE
134     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
135     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
136     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
137     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
138     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
139     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
140     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
141     , p6_a15 out nocopy JTF_NUMBER_TABLE
142     , p6_a16 out nocopy JTF_DATE_TABLE
143     , p6_a17 out nocopy JTF_NUMBER_TABLE
144     , p6_a18 out nocopy JTF_DATE_TABLE
145     , p6_a19 out nocopy JTF_NUMBER_TABLE
146     , p7_a0 out nocopy JTF_NUMBER_TABLE
147     , p7_a1 out nocopy JTF_NUMBER_TABLE
148     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
149     , p7_a3 out nocopy JTF_NUMBER_TABLE
150     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
151     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
152     , p7_a6 out nocopy JTF_DATE_TABLE
153     , p7_a7 out nocopy JTF_DATE_TABLE
154     , p7_a8 out nocopy JTF_NUMBER_TABLE
155     , p7_a9 out nocopy JTF_DATE_TABLE
156     , p7_a10 out nocopy JTF_NUMBER_TABLE
157     , p7_a11 out nocopy JTF_DATE_TABLE
158     , p7_a12 out nocopy JTF_NUMBER_TABLE
159     , p7_a13 out nocopy JTF_NUMBER_TABLE
160     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
161     , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
162     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
163     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
164     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
165     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
166     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
167     , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
168     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
169     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
170     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400
171     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
172     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
173     , p7_a27 out nocopy JTF_NUMBER_TABLE
174     , p7_a28 out nocopy JTF_DATE_TABLE
175     , p7_a29 out nocopy JTF_NUMBER_TABLE
176     , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
177     , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
178     , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000
179     , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000
180     , p7_a34 out nocopy JTF_NUMBER_TABLE
181     , p7_a35 out nocopy JTF_DATE_TABLE
182     , x_record_count out nocopy  NUMBER
183     , p5_a0  NUMBER := 0-1962.0724
184     , p5_a1  NUMBER := 0-1962.0724
185     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
186     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
187     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
188     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
190     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
192     , p5_a9  NUMBER := 0-1962.0724
193     , p5_a10  NUMBER := 0-1962.0724
194     , p5_a11  NUMBER := 0-1962.0724
195     , p5_a12  NUMBER := 0-1962.0724
196     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
197     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
198     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
199     , p5_a16  DATE := fnd_api.g_miss_date
200     , p5_a17  DATE := fnd_api.g_miss_date
201     , p5_a18  DATE := fnd_api.g_miss_date
202     , p5_a19  DATE := fnd_api.g_miss_date
203     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
204     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
205     , p5_a22  NUMBER := 0-1962.0724
206     , p5_a23  NUMBER := 0-1962.0724
207     , p5_a24  NUMBER := 0-1962.0724
208     , p5_a25  NUMBER := 0-1962.0724
209     , p5_a26  DATE := fnd_api.g_miss_date
210     , p5_a27  DATE := fnd_api.g_miss_date
211     , p5_a28  NUMBER := 0-1962.0724
212     , p5_a29  NUMBER := 0-1962.0724
213     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
214     , p5_a31  DATE := fnd_api.g_miss_date
215     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
216     , p5_a33  NUMBER := 0-1962.0724
217     , p5_a34  DATE := fnd_api.g_miss_date
218     , p5_a35  NUMBER := 0-1962.0724
219     , p5_a36  NUMBER := 0-1962.0724
220     , p5_a37  VARCHAR2 := fnd_api.g_miss_char
221     , p5_a38  VARCHAR2 := fnd_api.g_miss_char
222     , p5_a39  VARCHAR2 := fnd_api.g_miss_char
223     , p5_a40  DATE := fnd_api.g_miss_date
224     , p5_a41  VARCHAR2 := fnd_api.g_miss_char
225     , p5_a42  VARCHAR2 := fnd_api.g_miss_char
226     , p5_a43  VARCHAR2 := fnd_api.g_miss_char
227     , p5_a44  VARCHAR2 := fnd_api.g_miss_char
228     , p5_a45  VARCHAR2 := fnd_api.g_miss_char
229     , p5_a46  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a47  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a48  VARCHAR2 := fnd_api.g_miss_char
232     , p5_a49  VARCHAR2 := fnd_api.g_miss_char
233     , p5_a50  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a51  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a52  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a53  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a54  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a55  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a56  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a57  DATE := fnd_api.g_miss_date
241     , p5_a58  NUMBER := 0-1962.0724
242     , p5_a59  NUMBER := 0-1962.0724
243     , p5_a60  NUMBER := 0-1962.0724
244     , p5_a61  NUMBER := 0-1962.0724
245     , p5_a62  NUMBER := 0-1962.0724
246     , p5_a63  DATE := fnd_api.g_miss_date
247     , p5_a64  NUMBER := 0-1962.0724
248     , p5_a65  DATE := fnd_api.g_miss_date
249     , p5_a66  NUMBER := 0-1962.0724
250     , p5_a67  DATE := fnd_api.g_miss_date
251     , p5_a68  NUMBER := 0-1962.0724
252     , p5_a69  NUMBER := 0-1962.0724
253     , p5_a70  VARCHAR2 := fnd_api.g_miss_char
254     , p5_a71  NUMBER := 0-1962.0724
255     , p5_a72  NUMBER := 0-1962.0724
256     , p5_a73  NUMBER := 0-1962.0724
257     , p5_a74  NUMBER := 0-1962.0724
258     , p5_a75  VARCHAR2 := fnd_api.g_miss_char
259     , p5_a76  VARCHAR2 := fnd_api.g_miss_char
260     , p5_a77  VARCHAR2 := fnd_api.g_miss_char
261     , p5_a78  NUMBER := 0-1962.0724
262     , p5_a79  DATE := fnd_api.g_miss_date
263   );
264   procedure create_partner_as_recipient(p_validate_only  number
265     , p2_a0 out nocopy JTF_NUMBER_TABLE
266     , p2_a1 out nocopy JTF_NUMBER_TABLE
267     , p2_a2 out nocopy JTF_NUMBER_TABLE
268     , p2_a3 out nocopy JTF_NUMBER_TABLE
269     , p2_a4 out nocopy JTF_DATE_TABLE
270     , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
271     , p2_a6 out nocopy JTF_NUMBER_TABLE
272     , p2_a7 out nocopy JTF_NUMBER_TABLE
273     , p2_a8 out nocopy JTF_VARCHAR2_TABLE_600
274     , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
275     , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
276     , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200
277     , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
278     , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
279     , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200
280     , p2_a15 out nocopy JTF_NUMBER_TABLE
281     , p2_a16 out nocopy JTF_DATE_TABLE
282     , p2_a17 out nocopy JTF_NUMBER_TABLE
283     , p2_a18 out nocopy JTF_DATE_TABLE
284     , p2_a19 out nocopy JTF_NUMBER_TABLE
285     , x_return_status out nocopy  VARCHAR2
286     , p0_a0  NUMBER := 0-1962.0724
287     , p0_a1  NUMBER := 0-1962.0724
288     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
289     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
290     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
291     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
292     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
293     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
294     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
295     , p0_a9  NUMBER := 0-1962.0724
296     , p0_a10  NUMBER := 0-1962.0724
297     , p0_a11  NUMBER := 0-1962.0724
298     , p0_a12  NUMBER := 0-1962.0724
299     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
300     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
301     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
302     , p0_a16  DATE := fnd_api.g_miss_date
303     , p0_a17  DATE := fnd_api.g_miss_date
304     , p0_a18  DATE := fnd_api.g_miss_date
305     , p0_a19  DATE := fnd_api.g_miss_date
306     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
307     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
308     , p0_a22  NUMBER := 0-1962.0724
309     , p0_a23  NUMBER := 0-1962.0724
310     , p0_a24  NUMBER := 0-1962.0724
311     , p0_a25  NUMBER := 0-1962.0724
312     , p0_a26  DATE := fnd_api.g_miss_date
313     , p0_a27  DATE := fnd_api.g_miss_date
314     , p0_a28  NUMBER := 0-1962.0724
315     , p0_a29  NUMBER := 0-1962.0724
316     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
317     , p0_a31  DATE := fnd_api.g_miss_date
318     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
319     , p0_a33  NUMBER := 0-1962.0724
320     , p0_a34  DATE := fnd_api.g_miss_date
321     , p0_a35  NUMBER := 0-1962.0724
322     , p0_a36  NUMBER := 0-1962.0724
323     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
324     , p0_a38  VARCHAR2 := fnd_api.g_miss_char
325     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
326     , p0_a40  DATE := fnd_api.g_miss_date
327     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
328     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
329     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
330     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
331     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
332     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
333     , p0_a47  VARCHAR2 := fnd_api.g_miss_char
334     , p0_a48  VARCHAR2 := fnd_api.g_miss_char
335     , p0_a49  VARCHAR2 := fnd_api.g_miss_char
336     , p0_a50  VARCHAR2 := fnd_api.g_miss_char
337     , p0_a51  VARCHAR2 := fnd_api.g_miss_char
338     , p0_a52  VARCHAR2 := fnd_api.g_miss_char
339     , p0_a53  VARCHAR2 := fnd_api.g_miss_char
340     , p0_a54  VARCHAR2 := fnd_api.g_miss_char
341     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
342     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
343     , p0_a57  DATE := fnd_api.g_miss_date
344     , p0_a58  NUMBER := 0-1962.0724
345     , p0_a59  NUMBER := 0-1962.0724
346     , p0_a60  NUMBER := 0-1962.0724
347     , p0_a61  NUMBER := 0-1962.0724
348     , p0_a62  NUMBER := 0-1962.0724
349     , p0_a63  DATE := fnd_api.g_miss_date
350     , p0_a64  NUMBER := 0-1962.0724
351     , p0_a65  DATE := fnd_api.g_miss_date
352     , p0_a66  NUMBER := 0-1962.0724
353     , p0_a67  DATE := fnd_api.g_miss_date
354     , p0_a68  NUMBER := 0-1962.0724
355     , p0_a69  NUMBER := 0-1962.0724
356     , p0_a70  VARCHAR2 := fnd_api.g_miss_char
357     , p0_a71  NUMBER := 0-1962.0724
358     , p0_a72  NUMBER := 0-1962.0724
359     , p0_a73  NUMBER := 0-1962.0724
360     , p0_a74  NUMBER := 0-1962.0724
361     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
362     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
363     , p0_a77  VARCHAR2 := fnd_api.g_miss_char
364     , p0_a78  NUMBER := 0-1962.0724
365     , p0_a79  DATE := fnd_api.g_miss_date
366   );
367   procedure create_quote_parties(p1_a0 JTF_NUMBER_TABLE
368     , p1_a1 JTF_NUMBER_TABLE
369     , p1_a2 JTF_NUMBER_TABLE
370     , p1_a3 JTF_NUMBER_TABLE
371     , p1_a4 JTF_DATE_TABLE
372     , p1_a5 JTF_VARCHAR2_TABLE_100
373     , p1_a6 JTF_NUMBER_TABLE
374     , p1_a7 JTF_NUMBER_TABLE
375     , p1_a8 JTF_VARCHAR2_TABLE_600
376     , p1_a9 JTF_VARCHAR2_TABLE_100
377     , p1_a10 JTF_VARCHAR2_TABLE_100
378     , p1_a11 JTF_VARCHAR2_TABLE_200
379     , p1_a12 JTF_VARCHAR2_TABLE_100
380     , p1_a13 JTF_VARCHAR2_TABLE_100
381     , p1_a14 JTF_VARCHAR2_TABLE_200
382     , p1_a15 JTF_NUMBER_TABLE
383     , p1_a16 JTF_DATE_TABLE
384     , p1_a17 JTF_NUMBER_TABLE
385     , p1_a18 JTF_DATE_TABLE
386     , p1_a19 JTF_NUMBER_TABLE
387     , p_validate_only  number
388     , p3_a0 out nocopy JTF_NUMBER_TABLE
389     , p3_a1 out nocopy JTF_NUMBER_TABLE
390     , p3_a2 out nocopy JTF_NUMBER_TABLE
391     , p3_a3 out nocopy JTF_NUMBER_TABLE
392     , p3_a4 out nocopy JTF_DATE_TABLE
393     , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
394     , p3_a6 out nocopy JTF_NUMBER_TABLE
395     , p3_a7 out nocopy JTF_NUMBER_TABLE
396     , p3_a8 out nocopy JTF_VARCHAR2_TABLE_600
397     , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
398     , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
399     , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200
400     , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
401     , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
402     , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
403     , p3_a15 out nocopy JTF_NUMBER_TABLE
404     , p3_a16 out nocopy JTF_DATE_TABLE
405     , p3_a17 out nocopy JTF_NUMBER_TABLE
406     , p3_a18 out nocopy JTF_DATE_TABLE
407     , p3_a19 out nocopy JTF_NUMBER_TABLE
408     , x_return_status out nocopy  VARCHAR2
409     , p0_a0  NUMBER := 0-1962.0724
410     , p0_a1  NUMBER := 0-1962.0724
411     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
412     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
413     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
414     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
415     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
416     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
417     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
418     , p0_a9  NUMBER := 0-1962.0724
419     , p0_a10  NUMBER := 0-1962.0724
420     , p0_a11  NUMBER := 0-1962.0724
421     , p0_a12  NUMBER := 0-1962.0724
422     , p0_a13  VARCHAR2 := fnd_api.g_miss_char
423     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
424     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
425     , p0_a16  DATE := fnd_api.g_miss_date
426     , p0_a17  DATE := fnd_api.g_miss_date
427     , p0_a18  DATE := fnd_api.g_miss_date
428     , p0_a19  DATE := fnd_api.g_miss_date
429     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
430     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
431     , p0_a22  NUMBER := 0-1962.0724
432     , p0_a23  NUMBER := 0-1962.0724
433     , p0_a24  NUMBER := 0-1962.0724
434     , p0_a25  NUMBER := 0-1962.0724
435     , p0_a26  DATE := fnd_api.g_miss_date
436     , p0_a27  DATE := fnd_api.g_miss_date
437     , p0_a28  NUMBER := 0-1962.0724
438     , p0_a29  NUMBER := 0-1962.0724
439     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
440     , p0_a31  DATE := fnd_api.g_miss_date
441     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
442     , p0_a33  NUMBER := 0-1962.0724
443     , p0_a34  DATE := fnd_api.g_miss_date
444     , p0_a35  NUMBER := 0-1962.0724
445     , p0_a36  NUMBER := 0-1962.0724
446     , p0_a37  VARCHAR2 := fnd_api.g_miss_char
447     , p0_a38  VARCHAR2 := fnd_api.g_miss_char
448     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
449     , p0_a40  DATE := fnd_api.g_miss_date
450     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
451     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
452     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
453     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
454     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
455     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
456     , p0_a47  VARCHAR2 := fnd_api.g_miss_char
457     , p0_a48  VARCHAR2 := fnd_api.g_miss_char
458     , p0_a49  VARCHAR2 := fnd_api.g_miss_char
459     , p0_a50  VARCHAR2 := fnd_api.g_miss_char
460     , p0_a51  VARCHAR2 := fnd_api.g_miss_char
461     , p0_a52  VARCHAR2 := fnd_api.g_miss_char
462     , p0_a53  VARCHAR2 := fnd_api.g_miss_char
463     , p0_a54  VARCHAR2 := fnd_api.g_miss_char
464     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
465     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
466     , p0_a57  DATE := fnd_api.g_miss_date
467     , p0_a58  NUMBER := 0-1962.0724
468     , p0_a59  NUMBER := 0-1962.0724
469     , p0_a60  NUMBER := 0-1962.0724
470     , p0_a61  NUMBER := 0-1962.0724
471     , p0_a62  NUMBER := 0-1962.0724
472     , p0_a63  DATE := fnd_api.g_miss_date
473     , p0_a64  NUMBER := 0-1962.0724
474     , p0_a65  DATE := fnd_api.g_miss_date
475     , p0_a66  NUMBER := 0-1962.0724
476     , p0_a67  DATE := fnd_api.g_miss_date
477     , p0_a68  NUMBER := 0-1962.0724
478     , p0_a69  NUMBER := 0-1962.0724
479     , p0_a70  VARCHAR2 := fnd_api.g_miss_char
480     , p0_a71  NUMBER := 0-1962.0724
481     , p0_a72  NUMBER := 0-1962.0724
482     , p0_a73  NUMBER := 0-1962.0724
483     , p0_a74  NUMBER := 0-1962.0724
484     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
485     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
486     , p0_a77  VARCHAR2 := fnd_api.g_miss_char
487     , p0_a78  NUMBER := 0-1962.0724
488     , p0_a79  DATE := fnd_api.g_miss_date
489   );
490   procedure get_party_details(p_id_code  VARCHAR2
491     , p_id_value  VARCHAR2
492     , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
493     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
494     , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
495     , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
496     , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
497     , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
498     , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
499     , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
500     , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
501     , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
502     , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
503     , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
504     , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
505     , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
506     , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
507     , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
508     , p2_a16 out nocopy JTF_NUMBER_TABLE
509     , p2_a17 out nocopy JTF_NUMBER_TABLE
510     , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
511     , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000
512     , x_return_status out nocopy  VARCHAR2
513   );
514   procedure get_quote_parties(p_api_version  NUMBER
515     , p_init_msg_list  VARCHAR2
516     , x_msg_count out nocopy  NUMBER
517     , x_msg_data out nocopy  VARCHAR2
518     , x_return_status out nocopy  VARCHAR2
519     , p6_a0 out nocopy JTF_NUMBER_TABLE
520     , p6_a1 out nocopy JTF_NUMBER_TABLE
521     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
522     , p6_a3 out nocopy JTF_NUMBER_TABLE
523     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
524     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
525     , p6_a6 out nocopy JTF_DATE_TABLE
526     , p6_a7 out nocopy JTF_DATE_TABLE
527     , p6_a8 out nocopy JTF_NUMBER_TABLE
528     , p6_a9 out nocopy JTF_DATE_TABLE
529     , p6_a10 out nocopy JTF_NUMBER_TABLE
530     , p6_a11 out nocopy JTF_DATE_TABLE
531     , p6_a12 out nocopy JTF_NUMBER_TABLE
532     , p6_a13 out nocopy JTF_NUMBER_TABLE
533     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
534     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
535     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
536     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
537     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
538     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
539     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
540     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
541     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
542     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
543     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
544     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
545     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
546     , p6_a27 out nocopy JTF_NUMBER_TABLE
547     , p6_a28 out nocopy JTF_DATE_TABLE
548     , p6_a29 out nocopy JTF_NUMBER_TABLE
549     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
550     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
551     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
552     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
553     , p6_a34 out nocopy JTF_NUMBER_TABLE
554     , p6_a35 out nocopy JTF_DATE_TABLE
555     , x_record_count out nocopy  NUMBER
556     , p5_a0  NUMBER := 0-1962.0724
557     , p5_a1  NUMBER := 0-1962.0724
558     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
559     , p5_a3  NUMBER := 0-1962.0724
560     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
561     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
562     , p5_a6  DATE := fnd_api.g_miss_date
563     , p5_a7  DATE := fnd_api.g_miss_date
564     , p5_a8  NUMBER := 0-1962.0724
565     , p5_a9  DATE := fnd_api.g_miss_date
566     , p5_a10  NUMBER := 0-1962.0724
567     , p5_a11  DATE := fnd_api.g_miss_date
568     , p5_a12  NUMBER := 0-1962.0724
569     , p5_a13  NUMBER := 0-1962.0724
570     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
571     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
572     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
573     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
574     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
575     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
576     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
577     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
578     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
579     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
580     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
581     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
582     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
583     , p5_a27  NUMBER := 0-1962.0724
584     , p5_a28  DATE := fnd_api.g_miss_date
585     , p5_a29  NUMBER := 0-1962.0724
586     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
587     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
588     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
589     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
590     , p5_a34  NUMBER := 0-1962.0724
591     , p5_a35  DATE := fnd_api.g_miss_date
592   );
593   procedure get_quote_party_contacts(p_api_version  NUMBER
594     , p_init_msg_list  VARCHAR2
595     , x_msg_count out nocopy  NUMBER
596     , x_msg_data out nocopy  VARCHAR2
597     , x_return_status out nocopy  VARCHAR2
598     , p6_a0 out nocopy JTF_NUMBER_TABLE
599     , p6_a1 out nocopy JTF_NUMBER_TABLE
600     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
601     , p6_a3 out nocopy JTF_NUMBER_TABLE
602     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
603     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
604     , p6_a6 out nocopy JTF_DATE_TABLE
605     , p6_a7 out nocopy JTF_DATE_TABLE
606     , p6_a8 out nocopy JTF_NUMBER_TABLE
607     , p6_a9 out nocopy JTF_DATE_TABLE
608     , p6_a10 out nocopy JTF_NUMBER_TABLE
609     , p6_a11 out nocopy JTF_DATE_TABLE
610     , p6_a12 out nocopy JTF_NUMBER_TABLE
611     , p6_a13 out nocopy JTF_NUMBER_TABLE
612     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
613     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
614     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
615     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
616     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
617     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
618     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
619     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
620     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
621     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
622     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
623     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
624     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
625     , p6_a27 out nocopy JTF_NUMBER_TABLE
626     , p6_a28 out nocopy JTF_DATE_TABLE
627     , p6_a29 out nocopy JTF_NUMBER_TABLE
628     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
629     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
630     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
631     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
632     , p6_a34 out nocopy JTF_NUMBER_TABLE
633     , p6_a35 out nocopy JTF_DATE_TABLE
634     , x_record_count out nocopy  NUMBER
635     , p5_a0  NUMBER := 0-1962.0724
636     , p5_a1  NUMBER := 0-1962.0724
637     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
638     , p5_a3  NUMBER := 0-1962.0724
639     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
640     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
641     , p5_a6  DATE := fnd_api.g_miss_date
642     , p5_a7  DATE := fnd_api.g_miss_date
643     , p5_a8  NUMBER := 0-1962.0724
644     , p5_a9  DATE := fnd_api.g_miss_date
645     , p5_a10  NUMBER := 0-1962.0724
646     , p5_a11  DATE := fnd_api.g_miss_date
647     , p5_a12  NUMBER := 0-1962.0724
648     , p5_a13  NUMBER := 0-1962.0724
649     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
650     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
651     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
652     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
653     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
654     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
655     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
656     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
657     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
658     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
659     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
660     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
661     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
662     , p5_a27  NUMBER := 0-1962.0724
663     , p5_a28  DATE := fnd_api.g_miss_date
664     , p5_a29  NUMBER := 0-1962.0724
665     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
666     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
667     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
668     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
669     , p5_a34  NUMBER := 0-1962.0724
670     , p5_a35  DATE := fnd_api.g_miss_date
671   );
672   procedure get_quote_contact_points(p_api_version  NUMBER
673     , p_init_msg_list  VARCHAR2
674     , x_msg_count out nocopy  NUMBER
675     , x_msg_data out nocopy  VARCHAR2
676     , x_return_status out nocopy  VARCHAR2
677     , p6_a0 out nocopy JTF_NUMBER_TABLE
678     , p6_a1 out nocopy JTF_NUMBER_TABLE
679     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
680     , p6_a3 out nocopy JTF_NUMBER_TABLE
681     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
682     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
683     , p6_a6 out nocopy JTF_DATE_TABLE
684     , p6_a7 out nocopy JTF_DATE_TABLE
685     , p6_a8 out nocopy JTF_NUMBER_TABLE
686     , p6_a9 out nocopy JTF_DATE_TABLE
687     , p6_a10 out nocopy JTF_NUMBER_TABLE
688     , p6_a11 out nocopy JTF_DATE_TABLE
689     , p6_a12 out nocopy JTF_NUMBER_TABLE
690     , p6_a13 out nocopy JTF_NUMBER_TABLE
691     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
692     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
693     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
694     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
695     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
696     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
697     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
698     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
699     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
700     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
701     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
702     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
703     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
704     , p6_a27 out nocopy JTF_NUMBER_TABLE
705     , p6_a28 out nocopy JTF_DATE_TABLE
706     , p6_a29 out nocopy JTF_NUMBER_TABLE
707     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
708     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
709     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
710     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
711     , p6_a34 out nocopy JTF_NUMBER_TABLE
712     , p6_a35 out nocopy JTF_DATE_TABLE
713     , x_record_count out nocopy  NUMBER
714     , p5_a0  NUMBER := 0-1962.0724
715     , p5_a1  NUMBER := 0-1962.0724
716     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
717     , p5_a3  NUMBER := 0-1962.0724
718     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
719     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
720     , p5_a6  DATE := fnd_api.g_miss_date
721     , p5_a7  DATE := fnd_api.g_miss_date
722     , p5_a8  NUMBER := 0-1962.0724
723     , p5_a9  DATE := fnd_api.g_miss_date
724     , p5_a10  NUMBER := 0-1962.0724
725     , p5_a11  DATE := fnd_api.g_miss_date
726     , p5_a12  NUMBER := 0-1962.0724
727     , p5_a13  NUMBER := 0-1962.0724
728     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
729     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
730     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
731     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
732     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
733     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
734     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
735     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
736     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
737     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
738     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
739     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
740     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
741     , p5_a27  NUMBER := 0-1962.0724
742     , p5_a28  DATE := fnd_api.g_miss_date
743     , p5_a29  NUMBER := 0-1962.0724
744     , p5_a30  VARCHAR2 := fnd_api.g_miss_char
745     , p5_a31  VARCHAR2 := fnd_api.g_miss_char
746     , p5_a32  VARCHAR2 := fnd_api.g_miss_char
747     , p5_a33  VARCHAR2 := fnd_api.g_miss_char
748     , p5_a34  NUMBER := 0-1962.0724
749     , p5_a35  DATE := fnd_api.g_miss_date
750   );
751 end okl_am_parties_pvt_w;