DBA Data[Home] [Help]

PACKAGE: APPS.AMS_LISTHEADER_PVT_W

Source


1 package ams_listheader_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswlshs.pls 115.19 2004/02/04 01:34:37 vbhandar ship $ */
3   procedure create_listheader(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status out nocopy  VARCHAR2
8     , x_msg_count out nocopy  NUMBER
9     , x_msg_data out nocopy  VARCHAR2
10     , x_listheader_id out nocopy  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  DATE := fnd_api.g_miss_date
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  DATE := fnd_api.g_miss_date
15     , p7_a4  NUMBER := 0-1962.0724
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  NUMBER := 0-1962.0724
18     , p7_a7  NUMBER := 0-1962.0724
19     , p7_a8  NUMBER := 0-1962.0724
20     , p7_a9  NUMBER := 0-1962.0724
21     , p7_a10  DATE := fnd_api.g_miss_date
22     , p7_a11  NUMBER := 0-1962.0724
23     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  NUMBER := 0-1962.0724
25     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
26     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
27     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
28     , p7_a17  DATE := fnd_api.g_miss_date
29     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
31     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
32     , p7_a21  NUMBER := 0-1962.0724
33     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
34     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
35     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
36     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
37     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
38     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
39     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
40     , p7_a29  DATE := fnd_api.g_miss_date
41     , p7_a30  DATE := fnd_api.g_miss_date
42     , p7_a31  DATE := fnd_api.g_miss_date
43     , p7_a32  DATE := fnd_api.g_miss_date
44     , p7_a33  DATE := fnd_api.g_miss_date
45     , p7_a34  DATE := fnd_api.g_miss_date
46     , p7_a35  NUMBER := 0-1962.0724
47     , p7_a36  NUMBER := 0-1962.0724
48     , p7_a37  NUMBER := 0-1962.0724
49     , p7_a38  NUMBER := 0-1962.0724
50     , p7_a39  NUMBER := 0-1962.0724
51     , p7_a40  NUMBER := 0-1962.0724
52     , p7_a41  NUMBER := 0-1962.0724
53     , p7_a42  NUMBER := 0-1962.0724
54     , p7_a43  NUMBER := 0-1962.0724
55     , p7_a44  NUMBER := 0-1962.0724
56     , p7_a45  NUMBER := 0-1962.0724
57     , p7_a46  NUMBER := 0-1962.0724
58     , p7_a47  NUMBER := 0-1962.0724
59     , p7_a48  NUMBER := 0-1962.0724
60     , p7_a49  DATE := fnd_api.g_miss_date
61     , p7_a50  DATE := fnd_api.g_miss_date
62     , p7_a51  NUMBER := 0-1962.0724
63     , p7_a52  NUMBER := 0-1962.0724
64     , p7_a53  NUMBER := 0-1962.0724
65     , p7_a54  NUMBER := 0-1962.0724
66     , p7_a55  VARCHAR2 := fnd_api.g_miss_char
67     , p7_a56  VARCHAR2 := fnd_api.g_miss_char
68     , p7_a57  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a58  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a59  NUMBER := 0-1962.0724
71     , p7_a60  NUMBER := 0-1962.0724
72     , p7_a61  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a62  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a63  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a64  NUMBER := 0-1962.0724
76     , p7_a65  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a66  NUMBER := 0-1962.0724
78     , p7_a67  NUMBER := 0-1962.0724
79     , p7_a68  NUMBER := 0-1962.0724
80     , p7_a69  NUMBER := 0-1962.0724
81     , p7_a70  DATE := fnd_api.g_miss_date
82     , p7_a71  VARCHAR2 := fnd_api.g_miss_char
83     , p7_a72  VARCHAR2 := fnd_api.g_miss_char
84     , p7_a73  VARCHAR2 := fnd_api.g_miss_char
85     , p7_a74  VARCHAR2 := fnd_api.g_miss_char
86     , p7_a75  VARCHAR2 := fnd_api.g_miss_char
87     , p7_a76  VARCHAR2 := fnd_api.g_miss_char
88     , p7_a77  VARCHAR2 := fnd_api.g_miss_char
89     , p7_a78  VARCHAR2 := fnd_api.g_miss_char
90     , p7_a79  VARCHAR2 := fnd_api.g_miss_char
91     , p7_a80  VARCHAR2 := fnd_api.g_miss_char
92     , p7_a81  VARCHAR2 := fnd_api.g_miss_char
93     , p7_a82  VARCHAR2 := fnd_api.g_miss_char
94     , p7_a83  VARCHAR2 := fnd_api.g_miss_char
95     , p7_a84  VARCHAR2 := fnd_api.g_miss_char
96     , p7_a85  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a86  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a87  NUMBER := 0-1962.0724
99     , p7_a88  DATE := fnd_api.g_miss_date
100     , p7_a89  NUMBER := 0-1962.0724
101     , p7_a90  NUMBER := 0-1962.0724
102     , p7_a91  NUMBER := 0-1962.0724
103     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a93  NUMBER := 0-1962.0724
105     , p7_a94  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a95  NUMBER := 0-1962.0724
107     , p7_a96  NUMBER := 0-1962.0724
108     , p7_a97  VARCHAR2 := fnd_api.g_miss_char
109     , p7_a98  VARCHAR2 := fnd_api.g_miss_char
110     , p7_a99  VARCHAR2 := fnd_api.g_miss_char
111     , p7_a100  VARCHAR2 := fnd_api.g_miss_char
112     , p7_a101  VARCHAR2 := fnd_api.g_miss_char
113     , p7_a102  VARCHAR2 := fnd_api.g_miss_char
114     , p7_a103  NUMBER := 0-1962.0724
115     , p7_a104  NUMBER := 0-1962.0724
116     , p7_a105  NUMBER := 0-1962.0724
117     , p7_a106  VARCHAR2 := fnd_api.g_miss_char
118     , p7_a107  NUMBER := 0-1962.0724
119     , p7_a108  VARCHAR2 := fnd_api.g_miss_char
120   );
121   procedure update_listheader(p_api_version  NUMBER
122     , p_init_msg_list  VARCHAR2
123     , p_commit  VARCHAR2
124     , p_validation_level  NUMBER
125     , x_return_status out nocopy  VARCHAR2
126     , x_msg_count out nocopy  NUMBER
127     , x_msg_data out nocopy  VARCHAR2
128     , p7_a0  NUMBER := 0-1962.0724
129     , p7_a1  DATE := fnd_api.g_miss_date
130     , p7_a2  NUMBER := 0-1962.0724
131     , p7_a3  DATE := fnd_api.g_miss_date
132     , p7_a4  NUMBER := 0-1962.0724
133     , p7_a5  NUMBER := 0-1962.0724
134     , p7_a6  NUMBER := 0-1962.0724
135     , p7_a7  NUMBER := 0-1962.0724
136     , p7_a8  NUMBER := 0-1962.0724
137     , p7_a9  NUMBER := 0-1962.0724
138     , p7_a10  DATE := fnd_api.g_miss_date
139     , p7_a11  NUMBER := 0-1962.0724
140     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a13  NUMBER := 0-1962.0724
142     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a17  DATE := fnd_api.g_miss_date
146     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
147     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
148     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
149     , p7_a21  NUMBER := 0-1962.0724
150     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
151     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
152     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
153     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
154     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
155     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
156     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
157     , p7_a29  DATE := fnd_api.g_miss_date
158     , p7_a30  DATE := fnd_api.g_miss_date
159     , p7_a31  DATE := fnd_api.g_miss_date
160     , p7_a32  DATE := fnd_api.g_miss_date
161     , p7_a33  DATE := fnd_api.g_miss_date
162     , p7_a34  DATE := fnd_api.g_miss_date
163     , p7_a35  NUMBER := 0-1962.0724
164     , p7_a36  NUMBER := 0-1962.0724
165     , p7_a37  NUMBER := 0-1962.0724
166     , p7_a38  NUMBER := 0-1962.0724
167     , p7_a39  NUMBER := 0-1962.0724
168     , p7_a40  NUMBER := 0-1962.0724
169     , p7_a41  NUMBER := 0-1962.0724
170     , p7_a42  NUMBER := 0-1962.0724
171     , p7_a43  NUMBER := 0-1962.0724
172     , p7_a44  NUMBER := 0-1962.0724
173     , p7_a45  NUMBER := 0-1962.0724
174     , p7_a46  NUMBER := 0-1962.0724
175     , p7_a47  NUMBER := 0-1962.0724
176     , p7_a48  NUMBER := 0-1962.0724
177     , p7_a49  DATE := fnd_api.g_miss_date
178     , p7_a50  DATE := fnd_api.g_miss_date
179     , p7_a51  NUMBER := 0-1962.0724
180     , p7_a52  NUMBER := 0-1962.0724
181     , p7_a53  NUMBER := 0-1962.0724
182     , p7_a54  NUMBER := 0-1962.0724
183     , p7_a55  VARCHAR2 := fnd_api.g_miss_char
184     , p7_a56  VARCHAR2 := fnd_api.g_miss_char
185     , p7_a57  VARCHAR2 := fnd_api.g_miss_char
186     , p7_a58  VARCHAR2 := fnd_api.g_miss_char
187     , p7_a59  NUMBER := 0-1962.0724
188     , p7_a60  NUMBER := 0-1962.0724
189     , p7_a61  VARCHAR2 := fnd_api.g_miss_char
190     , p7_a62  VARCHAR2 := fnd_api.g_miss_char
191     , p7_a63  VARCHAR2 := fnd_api.g_miss_char
192     , p7_a64  NUMBER := 0-1962.0724
193     , p7_a65  VARCHAR2 := fnd_api.g_miss_char
194     , p7_a66  NUMBER := 0-1962.0724
195     , p7_a67  NUMBER := 0-1962.0724
196     , p7_a68  NUMBER := 0-1962.0724
197     , p7_a69  NUMBER := 0-1962.0724
198     , p7_a70  DATE := fnd_api.g_miss_date
199     , p7_a71  VARCHAR2 := fnd_api.g_miss_char
200     , p7_a72  VARCHAR2 := fnd_api.g_miss_char
201     , p7_a73  VARCHAR2 := fnd_api.g_miss_char
202     , p7_a74  VARCHAR2 := fnd_api.g_miss_char
203     , p7_a75  VARCHAR2 := fnd_api.g_miss_char
204     , p7_a76  VARCHAR2 := fnd_api.g_miss_char
205     , p7_a77  VARCHAR2 := fnd_api.g_miss_char
206     , p7_a78  VARCHAR2 := fnd_api.g_miss_char
207     , p7_a79  VARCHAR2 := fnd_api.g_miss_char
208     , p7_a80  VARCHAR2 := fnd_api.g_miss_char
209     , p7_a81  VARCHAR2 := fnd_api.g_miss_char
210     , p7_a82  VARCHAR2 := fnd_api.g_miss_char
211     , p7_a83  VARCHAR2 := fnd_api.g_miss_char
212     , p7_a84  VARCHAR2 := fnd_api.g_miss_char
213     , p7_a85  VARCHAR2 := fnd_api.g_miss_char
214     , p7_a86  VARCHAR2 := fnd_api.g_miss_char
215     , p7_a87  NUMBER := 0-1962.0724
216     , p7_a88  DATE := fnd_api.g_miss_date
217     , p7_a89  NUMBER := 0-1962.0724
218     , p7_a90  NUMBER := 0-1962.0724
219     , p7_a91  NUMBER := 0-1962.0724
220     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
221     , p7_a93  NUMBER := 0-1962.0724
222     , p7_a94  VARCHAR2 := fnd_api.g_miss_char
223     , p7_a95  NUMBER := 0-1962.0724
224     , p7_a96  NUMBER := 0-1962.0724
225     , p7_a97  VARCHAR2 := fnd_api.g_miss_char
226     , p7_a98  VARCHAR2 := fnd_api.g_miss_char
227     , p7_a99  VARCHAR2 := fnd_api.g_miss_char
228     , p7_a100  VARCHAR2 := fnd_api.g_miss_char
229     , p7_a101  VARCHAR2 := fnd_api.g_miss_char
230     , p7_a102  VARCHAR2 := fnd_api.g_miss_char
231     , p7_a103  NUMBER := 0-1962.0724
232     , p7_a104  NUMBER := 0-1962.0724
233     , p7_a105  NUMBER := 0-1962.0724
234     , p7_a106  VARCHAR2 := fnd_api.g_miss_char
235     , p7_a107  NUMBER := 0-1962.0724
236     , p7_a108  VARCHAR2 := fnd_api.g_miss_char
237   );
238   procedure validate_listheader(p_api_version  NUMBER
239     , p_init_msg_list  VARCHAR2
240     , p_validation_level  NUMBER
241     , x_return_status out nocopy  VARCHAR2
242     , x_msg_count out nocopy  NUMBER
243     , x_msg_data out nocopy  VARCHAR2
244     , p6_a0  NUMBER := 0-1962.0724
245     , p6_a1  DATE := fnd_api.g_miss_date
246     , p6_a2  NUMBER := 0-1962.0724
247     , p6_a3  DATE := fnd_api.g_miss_date
248     , p6_a4  NUMBER := 0-1962.0724
249     , p6_a5  NUMBER := 0-1962.0724
250     , p6_a6  NUMBER := 0-1962.0724
251     , p6_a7  NUMBER := 0-1962.0724
252     , p6_a8  NUMBER := 0-1962.0724
253     , p6_a9  NUMBER := 0-1962.0724
254     , p6_a10  DATE := fnd_api.g_miss_date
255     , p6_a11  NUMBER := 0-1962.0724
256     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
257     , p6_a13  NUMBER := 0-1962.0724
258     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
259     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
260     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
261     , p6_a17  DATE := fnd_api.g_miss_date
262     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
263     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
264     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
265     , p6_a21  NUMBER := 0-1962.0724
266     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
267     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
268     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
269     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
270     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
271     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
272     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
273     , p6_a29  DATE := fnd_api.g_miss_date
274     , p6_a30  DATE := fnd_api.g_miss_date
275     , p6_a31  DATE := fnd_api.g_miss_date
276     , p6_a32  DATE := fnd_api.g_miss_date
277     , p6_a33  DATE := fnd_api.g_miss_date
278     , p6_a34  DATE := fnd_api.g_miss_date
279     , p6_a35  NUMBER := 0-1962.0724
280     , p6_a36  NUMBER := 0-1962.0724
281     , p6_a37  NUMBER := 0-1962.0724
282     , p6_a38  NUMBER := 0-1962.0724
283     , p6_a39  NUMBER := 0-1962.0724
284     , p6_a40  NUMBER := 0-1962.0724
285     , p6_a41  NUMBER := 0-1962.0724
286     , p6_a42  NUMBER := 0-1962.0724
287     , p6_a43  NUMBER := 0-1962.0724
288     , p6_a44  NUMBER := 0-1962.0724
289     , p6_a45  NUMBER := 0-1962.0724
290     , p6_a46  NUMBER := 0-1962.0724
291     , p6_a47  NUMBER := 0-1962.0724
292     , p6_a48  NUMBER := 0-1962.0724
293     , p6_a49  DATE := fnd_api.g_miss_date
294     , p6_a50  DATE := fnd_api.g_miss_date
295     , p6_a51  NUMBER := 0-1962.0724
296     , p6_a52  NUMBER := 0-1962.0724
297     , p6_a53  NUMBER := 0-1962.0724
298     , p6_a54  NUMBER := 0-1962.0724
299     , p6_a55  VARCHAR2 := fnd_api.g_miss_char
300     , p6_a56  VARCHAR2 := fnd_api.g_miss_char
301     , p6_a57  VARCHAR2 := fnd_api.g_miss_char
302     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
303     , p6_a59  NUMBER := 0-1962.0724
304     , p6_a60  NUMBER := 0-1962.0724
305     , p6_a61  VARCHAR2 := fnd_api.g_miss_char
306     , p6_a62  VARCHAR2 := fnd_api.g_miss_char
307     , p6_a63  VARCHAR2 := fnd_api.g_miss_char
308     , p6_a64  NUMBER := 0-1962.0724
309     , p6_a65  VARCHAR2 := fnd_api.g_miss_char
310     , p6_a66  NUMBER := 0-1962.0724
314     , p6_a70  DATE := fnd_api.g_miss_date
311     , p6_a67  NUMBER := 0-1962.0724
312     , p6_a68  NUMBER := 0-1962.0724
313     , p6_a69  NUMBER := 0-1962.0724
315     , p6_a71  VARCHAR2 := fnd_api.g_miss_char
316     , p6_a72  VARCHAR2 := fnd_api.g_miss_char
317     , p6_a73  VARCHAR2 := fnd_api.g_miss_char
318     , p6_a74  VARCHAR2 := fnd_api.g_miss_char
319     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
320     , p6_a76  VARCHAR2 := fnd_api.g_miss_char
321     , p6_a77  VARCHAR2 := fnd_api.g_miss_char
322     , p6_a78  VARCHAR2 := fnd_api.g_miss_char
323     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
324     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
325     , p6_a81  VARCHAR2 := fnd_api.g_miss_char
326     , p6_a82  VARCHAR2 := fnd_api.g_miss_char
327     , p6_a83  VARCHAR2 := fnd_api.g_miss_char
328     , p6_a84  VARCHAR2 := fnd_api.g_miss_char
329     , p6_a85  VARCHAR2 := fnd_api.g_miss_char
330     , p6_a86  VARCHAR2 := fnd_api.g_miss_char
331     , p6_a87  NUMBER := 0-1962.0724
332     , p6_a88  DATE := fnd_api.g_miss_date
333     , p6_a89  NUMBER := 0-1962.0724
334     , p6_a90  NUMBER := 0-1962.0724
335     , p6_a91  NUMBER := 0-1962.0724
336     , p6_a92  VARCHAR2 := fnd_api.g_miss_char
337     , p6_a93  NUMBER := 0-1962.0724
338     , p6_a94  VARCHAR2 := fnd_api.g_miss_char
339     , p6_a95  NUMBER := 0-1962.0724
340     , p6_a96  NUMBER := 0-1962.0724
341     , p6_a97  VARCHAR2 := fnd_api.g_miss_char
342     , p6_a98  VARCHAR2 := fnd_api.g_miss_char
343     , p6_a99  VARCHAR2 := fnd_api.g_miss_char
344     , p6_a100  VARCHAR2 := fnd_api.g_miss_char
345     , p6_a101  VARCHAR2 := fnd_api.g_miss_char
346     , p6_a102  VARCHAR2 := fnd_api.g_miss_char
347     , p6_a103  NUMBER := 0-1962.0724
348     , p6_a104  NUMBER := 0-1962.0724
349     , p6_a105  NUMBER := 0-1962.0724
350     , p6_a106  VARCHAR2 := fnd_api.g_miss_char
351     , p6_a107  NUMBER := 0-1962.0724
352     , p6_a108  VARCHAR2 := fnd_api.g_miss_char
353   );
354   procedure validate_list_items(p_validation_mode  VARCHAR2
355     , x_return_status out nocopy  VARCHAR2
356     , p0_a0  NUMBER := 0-1962.0724
357     , p0_a1  DATE := fnd_api.g_miss_date
358     , p0_a2  NUMBER := 0-1962.0724
359     , p0_a3  DATE := fnd_api.g_miss_date
360     , p0_a4  NUMBER := 0-1962.0724
361     , p0_a5  NUMBER := 0-1962.0724
362     , p0_a6  NUMBER := 0-1962.0724
363     , p0_a7  NUMBER := 0-1962.0724
364     , p0_a8  NUMBER := 0-1962.0724
365     , p0_a9  NUMBER := 0-1962.0724
366     , p0_a10  DATE := fnd_api.g_miss_date
367     , p0_a11  NUMBER := 0-1962.0724
368     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
369     , p0_a13  NUMBER := 0-1962.0724
370     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
371     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
372     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
373     , p0_a17  DATE := fnd_api.g_miss_date
374     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
375     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
376     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
377     , p0_a21  NUMBER := 0-1962.0724
378     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
379     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
380     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
381     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
382     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
383     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
384     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
385     , p0_a29  DATE := fnd_api.g_miss_date
386     , p0_a30  DATE := fnd_api.g_miss_date
387     , p0_a31  DATE := fnd_api.g_miss_date
388     , p0_a32  DATE := fnd_api.g_miss_date
389     , p0_a33  DATE := fnd_api.g_miss_date
390     , p0_a34  DATE := fnd_api.g_miss_date
391     , p0_a35  NUMBER := 0-1962.0724
392     , p0_a36  NUMBER := 0-1962.0724
393     , p0_a37  NUMBER := 0-1962.0724
394     , p0_a38  NUMBER := 0-1962.0724
395     , p0_a39  NUMBER := 0-1962.0724
396     , p0_a40  NUMBER := 0-1962.0724
397     , p0_a41  NUMBER := 0-1962.0724
398     , p0_a42  NUMBER := 0-1962.0724
399     , p0_a43  NUMBER := 0-1962.0724
400     , p0_a44  NUMBER := 0-1962.0724
401     , p0_a45  NUMBER := 0-1962.0724
402     , p0_a46  NUMBER := 0-1962.0724
403     , p0_a47  NUMBER := 0-1962.0724
404     , p0_a48  NUMBER := 0-1962.0724
405     , p0_a49  DATE := fnd_api.g_miss_date
406     , p0_a50  DATE := fnd_api.g_miss_date
407     , p0_a51  NUMBER := 0-1962.0724
408     , p0_a52  NUMBER := 0-1962.0724
409     , p0_a53  NUMBER := 0-1962.0724
410     , p0_a54  NUMBER := 0-1962.0724
411     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
412     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
413     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
414     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
415     , p0_a59  NUMBER := 0-1962.0724
416     , p0_a60  NUMBER := 0-1962.0724
417     , p0_a61  VARCHAR2 := fnd_api.g_miss_char
418     , p0_a62  VARCHAR2 := fnd_api.g_miss_char
419     , p0_a63  VARCHAR2 := fnd_api.g_miss_char
420     , p0_a64  NUMBER := 0-1962.0724
421     , p0_a65  VARCHAR2 := fnd_api.g_miss_char
422     , p0_a66  NUMBER := 0-1962.0724
423     , p0_a67  NUMBER := 0-1962.0724
424     , p0_a68  NUMBER := 0-1962.0724
425     , p0_a69  NUMBER := 0-1962.0724
426     , p0_a70  DATE := fnd_api.g_miss_date
427     , p0_a71  VARCHAR2 := fnd_api.g_miss_char
428     , p0_a72  VARCHAR2 := fnd_api.g_miss_char
429     , p0_a73  VARCHAR2 := fnd_api.g_miss_char
433     , p0_a77  VARCHAR2 := fnd_api.g_miss_char
430     , p0_a74  VARCHAR2 := fnd_api.g_miss_char
431     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
432     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
434     , p0_a78  VARCHAR2 := fnd_api.g_miss_char
435     , p0_a79  VARCHAR2 := fnd_api.g_miss_char
436     , p0_a80  VARCHAR2 := fnd_api.g_miss_char
437     , p0_a81  VARCHAR2 := fnd_api.g_miss_char
438     , p0_a82  VARCHAR2 := fnd_api.g_miss_char
439     , p0_a83  VARCHAR2 := fnd_api.g_miss_char
440     , p0_a84  VARCHAR2 := fnd_api.g_miss_char
441     , p0_a85  VARCHAR2 := fnd_api.g_miss_char
442     , p0_a86  VARCHAR2 := fnd_api.g_miss_char
443     , p0_a87  NUMBER := 0-1962.0724
444     , p0_a88  DATE := fnd_api.g_miss_date
445     , p0_a89  NUMBER := 0-1962.0724
446     , p0_a90  NUMBER := 0-1962.0724
447     , p0_a91  NUMBER := 0-1962.0724
448     , p0_a92  VARCHAR2 := fnd_api.g_miss_char
449     , p0_a93  NUMBER := 0-1962.0724
450     , p0_a94  VARCHAR2 := fnd_api.g_miss_char
451     , p0_a95  NUMBER := 0-1962.0724
452     , p0_a96  NUMBER := 0-1962.0724
453     , p0_a97  VARCHAR2 := fnd_api.g_miss_char
454     , p0_a98  VARCHAR2 := fnd_api.g_miss_char
455     , p0_a99  VARCHAR2 := fnd_api.g_miss_char
456     , p0_a100  VARCHAR2 := fnd_api.g_miss_char
457     , p0_a101  VARCHAR2 := fnd_api.g_miss_char
458     , p0_a102  VARCHAR2 := fnd_api.g_miss_char
459     , p0_a103  NUMBER := 0-1962.0724
460     , p0_a104  NUMBER := 0-1962.0724
461     , p0_a105  NUMBER := 0-1962.0724
462     , p0_a106  VARCHAR2 := fnd_api.g_miss_char
463     , p0_a107  NUMBER := 0-1962.0724
464     , p0_a108  VARCHAR2 := fnd_api.g_miss_char
465   );
466   procedure validate_list_record(x_return_status out nocopy  VARCHAR2
467     , p0_a0  NUMBER := 0-1962.0724
468     , p0_a1  DATE := fnd_api.g_miss_date
469     , p0_a2  NUMBER := 0-1962.0724
470     , p0_a3  DATE := fnd_api.g_miss_date
471     , p0_a4  NUMBER := 0-1962.0724
472     , p0_a5  NUMBER := 0-1962.0724
473     , p0_a6  NUMBER := 0-1962.0724
474     , p0_a7  NUMBER := 0-1962.0724
475     , p0_a8  NUMBER := 0-1962.0724
476     , p0_a9  NUMBER := 0-1962.0724
477     , p0_a10  DATE := fnd_api.g_miss_date
478     , p0_a11  NUMBER := 0-1962.0724
479     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
480     , p0_a13  NUMBER := 0-1962.0724
481     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
482     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
483     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
484     , p0_a17  DATE := fnd_api.g_miss_date
485     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
486     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
487     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
488     , p0_a21  NUMBER := 0-1962.0724
489     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
490     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
491     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
492     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
493     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
494     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
495     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
496     , p0_a29  DATE := fnd_api.g_miss_date
497     , p0_a30  DATE := fnd_api.g_miss_date
498     , p0_a31  DATE := fnd_api.g_miss_date
499     , p0_a32  DATE := fnd_api.g_miss_date
500     , p0_a33  DATE := fnd_api.g_miss_date
501     , p0_a34  DATE := fnd_api.g_miss_date
502     , p0_a35  NUMBER := 0-1962.0724
503     , p0_a36  NUMBER := 0-1962.0724
504     , p0_a37  NUMBER := 0-1962.0724
505     , p0_a38  NUMBER := 0-1962.0724
506     , p0_a39  NUMBER := 0-1962.0724
507     , p0_a40  NUMBER := 0-1962.0724
508     , p0_a41  NUMBER := 0-1962.0724
509     , p0_a42  NUMBER := 0-1962.0724
510     , p0_a43  NUMBER := 0-1962.0724
511     , p0_a44  NUMBER := 0-1962.0724
512     , p0_a45  NUMBER := 0-1962.0724
513     , p0_a46  NUMBER := 0-1962.0724
514     , p0_a47  NUMBER := 0-1962.0724
515     , p0_a48  NUMBER := 0-1962.0724
516     , p0_a49  DATE := fnd_api.g_miss_date
517     , p0_a50  DATE := fnd_api.g_miss_date
518     , p0_a51  NUMBER := 0-1962.0724
519     , p0_a52  NUMBER := 0-1962.0724
520     , p0_a53  NUMBER := 0-1962.0724
521     , p0_a54  NUMBER := 0-1962.0724
522     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
523     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
524     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
525     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
526     , p0_a59  NUMBER := 0-1962.0724
527     , p0_a60  NUMBER := 0-1962.0724
528     , p0_a61  VARCHAR2 := fnd_api.g_miss_char
529     , p0_a62  VARCHAR2 := fnd_api.g_miss_char
530     , p0_a63  VARCHAR2 := fnd_api.g_miss_char
531     , p0_a64  NUMBER := 0-1962.0724
532     , p0_a65  VARCHAR2 := fnd_api.g_miss_char
533     , p0_a66  NUMBER := 0-1962.0724
534     , p0_a67  NUMBER := 0-1962.0724
535     , p0_a68  NUMBER := 0-1962.0724
536     , p0_a69  NUMBER := 0-1962.0724
537     , p0_a70  DATE := fnd_api.g_miss_date
538     , p0_a71  VARCHAR2 := fnd_api.g_miss_char
539     , p0_a72  VARCHAR2 := fnd_api.g_miss_char
540     , p0_a73  VARCHAR2 := fnd_api.g_miss_char
541     , p0_a74  VARCHAR2 := fnd_api.g_miss_char
542     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
543     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
544     , p0_a77  VARCHAR2 := fnd_api.g_miss_char
545     , p0_a78  VARCHAR2 := fnd_api.g_miss_char
546     , p0_a79  VARCHAR2 := fnd_api.g_miss_char
547     , p0_a80  VARCHAR2 := fnd_api.g_miss_char
548     , p0_a81  VARCHAR2 := fnd_api.g_miss_char
549     , p0_a82  VARCHAR2 := fnd_api.g_miss_char
553     , p0_a86  VARCHAR2 := fnd_api.g_miss_char
550     , p0_a83  VARCHAR2 := fnd_api.g_miss_char
551     , p0_a84  VARCHAR2 := fnd_api.g_miss_char
552     , p0_a85  VARCHAR2 := fnd_api.g_miss_char
554     , p0_a87  NUMBER := 0-1962.0724
555     , p0_a88  DATE := fnd_api.g_miss_date
556     , p0_a89  NUMBER := 0-1962.0724
557     , p0_a90  NUMBER := 0-1962.0724
558     , p0_a91  NUMBER := 0-1962.0724
559     , p0_a92  VARCHAR2 := fnd_api.g_miss_char
560     , p0_a93  NUMBER := 0-1962.0724
561     , p0_a94  VARCHAR2 := fnd_api.g_miss_char
562     , p0_a95  NUMBER := 0-1962.0724
563     , p0_a96  NUMBER := 0-1962.0724
564     , p0_a97  VARCHAR2 := fnd_api.g_miss_char
565     , p0_a98  VARCHAR2 := fnd_api.g_miss_char
566     , p0_a99  VARCHAR2 := fnd_api.g_miss_char
567     , p0_a100  VARCHAR2 := fnd_api.g_miss_char
568     , p0_a101  VARCHAR2 := fnd_api.g_miss_char
569     , p0_a102  VARCHAR2 := fnd_api.g_miss_char
570     , p0_a103  NUMBER := 0-1962.0724
571     , p0_a104  NUMBER := 0-1962.0724
572     , p0_a105  NUMBER := 0-1962.0724
573     , p0_a106  VARCHAR2 := fnd_api.g_miss_char
574     , p0_a107  NUMBER := 0-1962.0724
575     , p0_a108  VARCHAR2 := fnd_api.g_miss_char
576     , p1_a0  NUMBER := 0-1962.0724
577     , p1_a1  DATE := fnd_api.g_miss_date
578     , p1_a2  NUMBER := 0-1962.0724
579     , p1_a3  DATE := fnd_api.g_miss_date
580     , p1_a4  NUMBER := 0-1962.0724
581     , p1_a5  NUMBER := 0-1962.0724
582     , p1_a6  NUMBER := 0-1962.0724
583     , p1_a7  NUMBER := 0-1962.0724
584     , p1_a8  NUMBER := 0-1962.0724
585     , p1_a9  NUMBER := 0-1962.0724
586     , p1_a10  DATE := fnd_api.g_miss_date
587     , p1_a11  NUMBER := 0-1962.0724
588     , p1_a12  VARCHAR2 := fnd_api.g_miss_char
589     , p1_a13  NUMBER := 0-1962.0724
590     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
591     , p1_a15  VARCHAR2 := fnd_api.g_miss_char
592     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
593     , p1_a17  DATE := fnd_api.g_miss_date
594     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
595     , p1_a19  VARCHAR2 := fnd_api.g_miss_char
596     , p1_a20  VARCHAR2 := fnd_api.g_miss_char
597     , p1_a21  NUMBER := 0-1962.0724
598     , p1_a22  VARCHAR2 := fnd_api.g_miss_char
599     , p1_a23  VARCHAR2 := fnd_api.g_miss_char
600     , p1_a24  VARCHAR2 := fnd_api.g_miss_char
601     , p1_a25  VARCHAR2 := fnd_api.g_miss_char
602     , p1_a26  VARCHAR2 := fnd_api.g_miss_char
603     , p1_a27  VARCHAR2 := fnd_api.g_miss_char
604     , p1_a28  VARCHAR2 := fnd_api.g_miss_char
605     , p1_a29  DATE := fnd_api.g_miss_date
606     , p1_a30  DATE := fnd_api.g_miss_date
607     , p1_a31  DATE := fnd_api.g_miss_date
608     , p1_a32  DATE := fnd_api.g_miss_date
609     , p1_a33  DATE := fnd_api.g_miss_date
610     , p1_a34  DATE := fnd_api.g_miss_date
611     , p1_a35  NUMBER := 0-1962.0724
612     , p1_a36  NUMBER := 0-1962.0724
613     , p1_a37  NUMBER := 0-1962.0724
614     , p1_a38  NUMBER := 0-1962.0724
615     , p1_a39  NUMBER := 0-1962.0724
616     , p1_a40  NUMBER := 0-1962.0724
617     , p1_a41  NUMBER := 0-1962.0724
618     , p1_a42  NUMBER := 0-1962.0724
619     , p1_a43  NUMBER := 0-1962.0724
620     , p1_a44  NUMBER := 0-1962.0724
621     , p1_a45  NUMBER := 0-1962.0724
622     , p1_a46  NUMBER := 0-1962.0724
623     , p1_a47  NUMBER := 0-1962.0724
624     , p1_a48  NUMBER := 0-1962.0724
625     , p1_a49  DATE := fnd_api.g_miss_date
626     , p1_a50  DATE := fnd_api.g_miss_date
627     , p1_a51  NUMBER := 0-1962.0724
628     , p1_a52  NUMBER := 0-1962.0724
629     , p1_a53  NUMBER := 0-1962.0724
630     , p1_a54  NUMBER := 0-1962.0724
631     , p1_a55  VARCHAR2 := fnd_api.g_miss_char
632     , p1_a56  VARCHAR2 := fnd_api.g_miss_char
633     , p1_a57  VARCHAR2 := fnd_api.g_miss_char
634     , p1_a58  VARCHAR2 := fnd_api.g_miss_char
635     , p1_a59  NUMBER := 0-1962.0724
636     , p1_a60  NUMBER := 0-1962.0724
637     , p1_a61  VARCHAR2 := fnd_api.g_miss_char
638     , p1_a62  VARCHAR2 := fnd_api.g_miss_char
639     , p1_a63  VARCHAR2 := fnd_api.g_miss_char
640     , p1_a64  NUMBER := 0-1962.0724
641     , p1_a65  VARCHAR2 := fnd_api.g_miss_char
642     , p1_a66  NUMBER := 0-1962.0724
643     , p1_a67  NUMBER := 0-1962.0724
644     , p1_a68  NUMBER := 0-1962.0724
645     , p1_a69  NUMBER := 0-1962.0724
646     , p1_a70  DATE := fnd_api.g_miss_date
647     , p1_a71  VARCHAR2 := fnd_api.g_miss_char
648     , p1_a72  VARCHAR2 := fnd_api.g_miss_char
649     , p1_a73  VARCHAR2 := fnd_api.g_miss_char
650     , p1_a74  VARCHAR2 := fnd_api.g_miss_char
651     , p1_a75  VARCHAR2 := fnd_api.g_miss_char
652     , p1_a76  VARCHAR2 := fnd_api.g_miss_char
653     , p1_a77  VARCHAR2 := fnd_api.g_miss_char
654     , p1_a78  VARCHAR2 := fnd_api.g_miss_char
655     , p1_a79  VARCHAR2 := fnd_api.g_miss_char
656     , p1_a80  VARCHAR2 := fnd_api.g_miss_char
657     , p1_a81  VARCHAR2 := fnd_api.g_miss_char
658     , p1_a82  VARCHAR2 := fnd_api.g_miss_char
659     , p1_a83  VARCHAR2 := fnd_api.g_miss_char
660     , p1_a84  VARCHAR2 := fnd_api.g_miss_char
661     , p1_a85  VARCHAR2 := fnd_api.g_miss_char
662     , p1_a86  VARCHAR2 := fnd_api.g_miss_char
663     , p1_a87  NUMBER := 0-1962.0724
664     , p1_a88  DATE := fnd_api.g_miss_date
665     , p1_a89  NUMBER := 0-1962.0724
666     , p1_a90  NUMBER := 0-1962.0724
667     , p1_a91  NUMBER := 0-1962.0724
668     , p1_a92  VARCHAR2 := fnd_api.g_miss_char
669     , p1_a93  NUMBER := 0-1962.0724
670     , p1_a94  VARCHAR2 := fnd_api.g_miss_char
674     , p1_a98  VARCHAR2 := fnd_api.g_miss_char
671     , p1_a95  NUMBER := 0-1962.0724
672     , p1_a96  NUMBER := 0-1962.0724
673     , p1_a97  VARCHAR2 := fnd_api.g_miss_char
675     , p1_a99  VARCHAR2 := fnd_api.g_miss_char
676     , p1_a100  VARCHAR2 := fnd_api.g_miss_char
677     , p1_a101  VARCHAR2 := fnd_api.g_miss_char
678     , p1_a102  VARCHAR2 := fnd_api.g_miss_char
679     , p1_a103  NUMBER := 0-1962.0724
680     , p1_a104  NUMBER := 0-1962.0724
681     , p1_a105  NUMBER := 0-1962.0724
682     , p1_a106  VARCHAR2 := fnd_api.g_miss_char
683     , p1_a107  NUMBER := 0-1962.0724
684     , p1_a108  VARCHAR2 := fnd_api.g_miss_char
685   );
686   procedure init_listheader_rec(p0_a0 out nocopy  NUMBER
687     , p0_a1 out nocopy  DATE
688     , p0_a2 out nocopy  NUMBER
689     , p0_a3 out nocopy  DATE
690     , p0_a4 out nocopy  NUMBER
691     , p0_a5 out nocopy  NUMBER
692     , p0_a6 out nocopy  NUMBER
693     , p0_a7 out nocopy  NUMBER
694     , p0_a8 out nocopy  NUMBER
695     , p0_a9 out nocopy  NUMBER
696     , p0_a10 out nocopy  DATE
697     , p0_a11 out nocopy  NUMBER
698     , p0_a12 out nocopy  VARCHAR2
699     , p0_a13 out nocopy  NUMBER
700     , p0_a14 out nocopy  VARCHAR2
701     , p0_a15 out nocopy  VARCHAR2
702     , p0_a16 out nocopy  VARCHAR2
703     , p0_a17 out nocopy  DATE
704     , p0_a18 out nocopy  VARCHAR2
705     , p0_a19 out nocopy  VARCHAR2
706     , p0_a20 out nocopy  VARCHAR2
707     , p0_a21 out nocopy  NUMBER
708     , p0_a22 out nocopy  VARCHAR2
709     , p0_a23 out nocopy  VARCHAR2
710     , p0_a24 out nocopy  VARCHAR2
711     , p0_a25 out nocopy  VARCHAR2
712     , p0_a26 out nocopy  VARCHAR2
713     , p0_a27 out nocopy  VARCHAR2
714     , p0_a28 out nocopy  VARCHAR2
715     , p0_a29 out nocopy  DATE
716     , p0_a30 out nocopy  DATE
717     , p0_a31 out nocopy  DATE
718     , p0_a32 out nocopy  DATE
719     , p0_a33 out nocopy  DATE
720     , p0_a34 out nocopy  DATE
721     , p0_a35 out nocopy  NUMBER
722     , p0_a36 out nocopy  NUMBER
723     , p0_a37 out nocopy  NUMBER
724     , p0_a38 out nocopy  NUMBER
725     , p0_a39 out nocopy  NUMBER
726     , p0_a40 out nocopy  NUMBER
727     , p0_a41 out nocopy  NUMBER
728     , p0_a42 out nocopy  NUMBER
729     , p0_a43 out nocopy  NUMBER
730     , p0_a44 out nocopy  NUMBER
731     , p0_a45 out nocopy  NUMBER
732     , p0_a46 out nocopy  NUMBER
733     , p0_a47 out nocopy  NUMBER
734     , p0_a48 out nocopy  NUMBER
735     , p0_a49 out nocopy  DATE
736     , p0_a50 out nocopy  DATE
737     , p0_a51 out nocopy  NUMBER
738     , p0_a52 out nocopy  NUMBER
739     , p0_a53 out nocopy  NUMBER
740     , p0_a54 out nocopy  NUMBER
741     , p0_a55 out nocopy  VARCHAR2
742     , p0_a56 out nocopy  VARCHAR2
743     , p0_a57 out nocopy  VARCHAR2
744     , p0_a58 out nocopy  VARCHAR2
745     , p0_a59 out nocopy  NUMBER
746     , p0_a60 out nocopy  NUMBER
747     , p0_a61 out nocopy  VARCHAR2
748     , p0_a62 out nocopy  VARCHAR2
749     , p0_a63 out nocopy  VARCHAR2
750     , p0_a64 out nocopy  NUMBER
751     , p0_a65 out nocopy  VARCHAR2
752     , p0_a66 out nocopy  NUMBER
753     , p0_a67 out nocopy  NUMBER
754     , p0_a68 out nocopy  NUMBER
755     , p0_a69 out nocopy  NUMBER
756     , p0_a70 out nocopy  DATE
757     , p0_a71 out nocopy  VARCHAR2
758     , p0_a72 out nocopy  VARCHAR2
759     , p0_a73 out nocopy  VARCHAR2
760     , p0_a74 out nocopy  VARCHAR2
761     , p0_a75 out nocopy  VARCHAR2
762     , p0_a76 out nocopy  VARCHAR2
763     , p0_a77 out nocopy  VARCHAR2
764     , p0_a78 out nocopy  VARCHAR2
765     , p0_a79 out nocopy  VARCHAR2
766     , p0_a80 out nocopy  VARCHAR2
767     , p0_a81 out nocopy  VARCHAR2
768     , p0_a82 out nocopy  VARCHAR2
769     , p0_a83 out nocopy  VARCHAR2
770     , p0_a84 out nocopy  VARCHAR2
771     , p0_a85 out nocopy  VARCHAR2
772     , p0_a86 out nocopy  VARCHAR2
773     , p0_a87 out nocopy  NUMBER
774     , p0_a88 out nocopy  DATE
775     , p0_a89 out nocopy  NUMBER
776     , p0_a90 out nocopy  NUMBER
777     , p0_a91 out nocopy  NUMBER
778     , p0_a92 out nocopy  VARCHAR2
779     , p0_a93 out nocopy  NUMBER
780     , p0_a94 out nocopy  VARCHAR2
781     , p0_a95 out nocopy  NUMBER
782     , p0_a96 out nocopy  NUMBER
783     , p0_a97 out nocopy  VARCHAR2
784     , p0_a98 out nocopy  VARCHAR2
785     , p0_a99 out nocopy  VARCHAR2
786     , p0_a100 out nocopy  VARCHAR2
787     , p0_a101 out nocopy  VARCHAR2
788     , p0_a102 out nocopy  VARCHAR2
789     , p0_a103 out nocopy  NUMBER
790     , p0_a104 out nocopy  NUMBER
791     , p0_a105 out nocopy  NUMBER
792     , p0_a106 out nocopy  VARCHAR2
793     , p0_a107 out nocopy  NUMBER
794     , p0_a108 out nocopy  VARCHAR2
795   );
796   procedure complete_listheader_rec(p1_a0 out nocopy  NUMBER
797     , p1_a1 out nocopy  DATE
798     , p1_a2 out nocopy  NUMBER
799     , p1_a3 out nocopy  DATE
800     , p1_a4 out nocopy  NUMBER
801     , p1_a5 out nocopy  NUMBER
802     , p1_a6 out nocopy  NUMBER
803     , p1_a7 out nocopy  NUMBER
804     , p1_a8 out nocopy  NUMBER
805     , p1_a9 out nocopy  NUMBER
806     , p1_a10 out nocopy  DATE
807     , p1_a11 out nocopy  NUMBER
808     , p1_a12 out nocopy  VARCHAR2
809     , p1_a13 out nocopy  NUMBER
810     , p1_a14 out nocopy  VARCHAR2
814     , p1_a18 out nocopy  VARCHAR2
811     , p1_a15 out nocopy  VARCHAR2
812     , p1_a16 out nocopy  VARCHAR2
813     , p1_a17 out nocopy  DATE
815     , p1_a19 out nocopy  VARCHAR2
816     , p1_a20 out nocopy  VARCHAR2
817     , p1_a21 out nocopy  NUMBER
818     , p1_a22 out nocopy  VARCHAR2
819     , p1_a23 out nocopy  VARCHAR2
820     , p1_a24 out nocopy  VARCHAR2
821     , p1_a25 out nocopy  VARCHAR2
822     , p1_a26 out nocopy  VARCHAR2
823     , p1_a27 out nocopy  VARCHAR2
824     , p1_a28 out nocopy  VARCHAR2
825     , p1_a29 out nocopy  DATE
826     , p1_a30 out nocopy  DATE
827     , p1_a31 out nocopy  DATE
828     , p1_a32 out nocopy  DATE
829     , p1_a33 out nocopy  DATE
830     , p1_a34 out nocopy  DATE
831     , p1_a35 out nocopy  NUMBER
832     , p1_a36 out nocopy  NUMBER
833     , p1_a37 out nocopy  NUMBER
834     , p1_a38 out nocopy  NUMBER
835     , p1_a39 out nocopy  NUMBER
836     , p1_a40 out nocopy  NUMBER
837     , p1_a41 out nocopy  NUMBER
838     , p1_a42 out nocopy  NUMBER
839     , p1_a43 out nocopy  NUMBER
840     , p1_a44 out nocopy  NUMBER
841     , p1_a45 out nocopy  NUMBER
842     , p1_a46 out nocopy  NUMBER
843     , p1_a47 out nocopy  NUMBER
844     , p1_a48 out nocopy  NUMBER
845     , p1_a49 out nocopy  DATE
846     , p1_a50 out nocopy  DATE
847     , p1_a51 out nocopy  NUMBER
848     , p1_a52 out nocopy  NUMBER
849     , p1_a53 out nocopy  NUMBER
850     , p1_a54 out nocopy  NUMBER
851     , p1_a55 out nocopy  VARCHAR2
852     , p1_a56 out nocopy  VARCHAR2
853     , p1_a57 out nocopy  VARCHAR2
854     , p1_a58 out nocopy  VARCHAR2
855     , p1_a59 out nocopy  NUMBER
856     , p1_a60 out nocopy  NUMBER
857     , p1_a61 out nocopy  VARCHAR2
858     , p1_a62 out nocopy  VARCHAR2
859     , p1_a63 out nocopy  VARCHAR2
860     , p1_a64 out nocopy  NUMBER
861     , p1_a65 out nocopy  VARCHAR2
862     , p1_a66 out nocopy  NUMBER
863     , p1_a67 out nocopy  NUMBER
864     , p1_a68 out nocopy  NUMBER
865     , p1_a69 out nocopy  NUMBER
866     , p1_a70 out nocopy  DATE
867     , p1_a71 out nocopy  VARCHAR2
868     , p1_a72 out nocopy  VARCHAR2
869     , p1_a73 out nocopy  VARCHAR2
870     , p1_a74 out nocopy  VARCHAR2
871     , p1_a75 out nocopy  VARCHAR2
872     , p1_a76 out nocopy  VARCHAR2
873     , p1_a77 out nocopy  VARCHAR2
874     , p1_a78 out nocopy  VARCHAR2
875     , p1_a79 out nocopy  VARCHAR2
876     , p1_a80 out nocopy  VARCHAR2
877     , p1_a81 out nocopy  VARCHAR2
878     , p1_a82 out nocopy  VARCHAR2
879     , p1_a83 out nocopy  VARCHAR2
880     , p1_a84 out nocopy  VARCHAR2
881     , p1_a85 out nocopy  VARCHAR2
882     , p1_a86 out nocopy  VARCHAR2
883     , p1_a87 out nocopy  NUMBER
884     , p1_a88 out nocopy  DATE
885     , p1_a89 out nocopy  NUMBER
886     , p1_a90 out nocopy  NUMBER
887     , p1_a91 out nocopy  NUMBER
888     , p1_a92 out nocopy  VARCHAR2
889     , p1_a93 out nocopy  NUMBER
890     , p1_a94 out nocopy  VARCHAR2
891     , p1_a95 out nocopy  NUMBER
892     , p1_a96 out nocopy  NUMBER
893     , p1_a97 out nocopy  VARCHAR2
894     , p1_a98 out nocopy  VARCHAR2
895     , p1_a99 out nocopy  VARCHAR2
896     , p1_a100 out nocopy  VARCHAR2
897     , p1_a101 out nocopy  VARCHAR2
898     , p1_a102 out nocopy  VARCHAR2
899     , p1_a103 out nocopy  NUMBER
900     , p1_a104 out nocopy  NUMBER
901     , p1_a105 out nocopy  NUMBER
902     , p1_a106 out nocopy  VARCHAR2
903     , p1_a107 out nocopy  NUMBER
904     , p1_a108 out nocopy  VARCHAR2
905     , p0_a0  NUMBER := 0-1962.0724
906     , p0_a1  DATE := fnd_api.g_miss_date
907     , p0_a2  NUMBER := 0-1962.0724
908     , p0_a3  DATE := fnd_api.g_miss_date
909     , p0_a4  NUMBER := 0-1962.0724
910     , p0_a5  NUMBER := 0-1962.0724
911     , p0_a6  NUMBER := 0-1962.0724
912     , p0_a7  NUMBER := 0-1962.0724
913     , p0_a8  NUMBER := 0-1962.0724
914     , p0_a9  NUMBER := 0-1962.0724
915     , p0_a10  DATE := fnd_api.g_miss_date
916     , p0_a11  NUMBER := 0-1962.0724
917     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
918     , p0_a13  NUMBER := 0-1962.0724
919     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
920     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
921     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
922     , p0_a17  DATE := fnd_api.g_miss_date
923     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
924     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
925     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
926     , p0_a21  NUMBER := 0-1962.0724
927     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
928     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
929     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
930     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
931     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
932     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
933     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
934     , p0_a29  DATE := fnd_api.g_miss_date
935     , p0_a30  DATE := fnd_api.g_miss_date
936     , p0_a31  DATE := fnd_api.g_miss_date
937     , p0_a32  DATE := fnd_api.g_miss_date
938     , p0_a33  DATE := fnd_api.g_miss_date
939     , p0_a34  DATE := fnd_api.g_miss_date
940     , p0_a35  NUMBER := 0-1962.0724
941     , p0_a36  NUMBER := 0-1962.0724
942     , p0_a37  NUMBER := 0-1962.0724
943     , p0_a38  NUMBER := 0-1962.0724
944     , p0_a39  NUMBER := 0-1962.0724
948     , p0_a43  NUMBER := 0-1962.0724
945     , p0_a40  NUMBER := 0-1962.0724
946     , p0_a41  NUMBER := 0-1962.0724
947     , p0_a42  NUMBER := 0-1962.0724
949     , p0_a44  NUMBER := 0-1962.0724
950     , p0_a45  NUMBER := 0-1962.0724
951     , p0_a46  NUMBER := 0-1962.0724
952     , p0_a47  NUMBER := 0-1962.0724
953     , p0_a48  NUMBER := 0-1962.0724
954     , p0_a49  DATE := fnd_api.g_miss_date
955     , p0_a50  DATE := fnd_api.g_miss_date
956     , p0_a51  NUMBER := 0-1962.0724
957     , p0_a52  NUMBER := 0-1962.0724
958     , p0_a53  NUMBER := 0-1962.0724
959     , p0_a54  NUMBER := 0-1962.0724
960     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
961     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
962     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
963     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
964     , p0_a59  NUMBER := 0-1962.0724
965     , p0_a60  NUMBER := 0-1962.0724
966     , p0_a61  VARCHAR2 := fnd_api.g_miss_char
967     , p0_a62  VARCHAR2 := fnd_api.g_miss_char
968     , p0_a63  VARCHAR2 := fnd_api.g_miss_char
969     , p0_a64  NUMBER := 0-1962.0724
970     , p0_a65  VARCHAR2 := fnd_api.g_miss_char
971     , p0_a66  NUMBER := 0-1962.0724
972     , p0_a67  NUMBER := 0-1962.0724
973     , p0_a68  NUMBER := 0-1962.0724
974     , p0_a69  NUMBER := 0-1962.0724
975     , p0_a70  DATE := fnd_api.g_miss_date
976     , p0_a71  VARCHAR2 := fnd_api.g_miss_char
977     , p0_a72  VARCHAR2 := fnd_api.g_miss_char
978     , p0_a73  VARCHAR2 := fnd_api.g_miss_char
979     , p0_a74  VARCHAR2 := fnd_api.g_miss_char
980     , p0_a75  VARCHAR2 := fnd_api.g_miss_char
981     , p0_a76  VARCHAR2 := fnd_api.g_miss_char
982     , p0_a77  VARCHAR2 := fnd_api.g_miss_char
983     , p0_a78  VARCHAR2 := fnd_api.g_miss_char
984     , p0_a79  VARCHAR2 := fnd_api.g_miss_char
985     , p0_a80  VARCHAR2 := fnd_api.g_miss_char
986     , p0_a81  VARCHAR2 := fnd_api.g_miss_char
987     , p0_a82  VARCHAR2 := fnd_api.g_miss_char
988     , p0_a83  VARCHAR2 := fnd_api.g_miss_char
989     , p0_a84  VARCHAR2 := fnd_api.g_miss_char
990     , p0_a85  VARCHAR2 := fnd_api.g_miss_char
991     , p0_a86  VARCHAR2 := fnd_api.g_miss_char
992     , p0_a87  NUMBER := 0-1962.0724
993     , p0_a88  DATE := fnd_api.g_miss_date
994     , p0_a89  NUMBER := 0-1962.0724
995     , p0_a90  NUMBER := 0-1962.0724
996     , p0_a91  NUMBER := 0-1962.0724
997     , p0_a92  VARCHAR2 := fnd_api.g_miss_char
998     , p0_a93  NUMBER := 0-1962.0724
999     , p0_a94  VARCHAR2 := fnd_api.g_miss_char
1000     , p0_a95  NUMBER := 0-1962.0724
1001     , p0_a96  NUMBER := 0-1962.0724
1002     , p0_a97  VARCHAR2 := fnd_api.g_miss_char
1003     , p0_a98  VARCHAR2 := fnd_api.g_miss_char
1004     , p0_a99  VARCHAR2 := fnd_api.g_miss_char
1005     , p0_a100  VARCHAR2 := fnd_api.g_miss_char
1006     , p0_a101  VARCHAR2 := fnd_api.g_miss_char
1007     , p0_a102  VARCHAR2 := fnd_api.g_miss_char
1008     , p0_a103  NUMBER := 0-1962.0724
1009     , p0_a104  NUMBER := 0-1962.0724
1010     , p0_a105  NUMBER := 0-1962.0724
1011     , p0_a106  VARCHAR2 := fnd_api.g_miss_char
1012     , p0_a107  NUMBER := 0-1962.0724
1013     , p0_a108  VARCHAR2 := fnd_api.g_miss_char
1014   );
1015   procedure update_prev_contacted_count(p_used_by_id  NUMBER
1016     , p_used_by  VARCHAR2
1017     , p_last_contacted_date  date
1021     , x_msg_count out nocopy  NUMBER
1018     , p_init_msg_list  VARCHAR2
1019     , p_commit  VARCHAR2
1020     , x_return_status out nocopy  VARCHAR2
1022     , x_msg_data out nocopy  VARCHAR2
1023   );
1024   procedure copy_list(p_api_version  NUMBER
1025     , p_init_msg_list  VARCHAR2
1026     , p_commit  VARCHAR2
1027     , p_validation_level  NUMBER
1028     , x_return_status out nocopy  VARCHAR2
1029     , x_msg_count out nocopy  NUMBER
1030     , x_msg_data out nocopy  VARCHAR2
1031     , p_source_listheader_id  NUMBER
1032     , p_copy_select_actions  VARCHAR2
1033     , p_copy_list_queries  VARCHAR2
1034     , p_copy_list_entries  VARCHAR2
1035     , x_listheader_id out nocopy  NUMBER
1036     , p8_a0  NUMBER := 0-1962.0724
1037     , p8_a1  DATE := fnd_api.g_miss_date
1038     , p8_a2  NUMBER := 0-1962.0724
1039     , p8_a3  DATE := fnd_api.g_miss_date
1040     , p8_a4  NUMBER := 0-1962.0724
1041     , p8_a5  NUMBER := 0-1962.0724
1042     , p8_a6  NUMBER := 0-1962.0724
1043     , p8_a7  NUMBER := 0-1962.0724
1044     , p8_a8  NUMBER := 0-1962.0724
1045     , p8_a9  NUMBER := 0-1962.0724
1046     , p8_a10  DATE := fnd_api.g_miss_date
1047     , p8_a11  NUMBER := 0-1962.0724
1048     , p8_a12  VARCHAR2 := fnd_api.g_miss_char
1049     , p8_a13  NUMBER := 0-1962.0724
1050     , p8_a14  VARCHAR2 := fnd_api.g_miss_char
1051     , p8_a15  VARCHAR2 := fnd_api.g_miss_char
1052     , p8_a16  VARCHAR2 := fnd_api.g_miss_char
1053     , p8_a17  DATE := fnd_api.g_miss_date
1054     , p8_a18  VARCHAR2 := fnd_api.g_miss_char
1055     , p8_a19  VARCHAR2 := fnd_api.g_miss_char
1056     , p8_a20  VARCHAR2 := fnd_api.g_miss_char
1057     , p8_a21  NUMBER := 0-1962.0724
1058     , p8_a22  VARCHAR2 := fnd_api.g_miss_char
1059     , p8_a23  VARCHAR2 := fnd_api.g_miss_char
1060     , p8_a24  VARCHAR2 := fnd_api.g_miss_char
1061     , p8_a25  VARCHAR2 := fnd_api.g_miss_char
1062     , p8_a26  VARCHAR2 := fnd_api.g_miss_char
1063     , p8_a27  VARCHAR2 := fnd_api.g_miss_char
1064     , p8_a28  VARCHAR2 := fnd_api.g_miss_char
1065     , p8_a29  DATE := fnd_api.g_miss_date
1066     , p8_a30  DATE := fnd_api.g_miss_date
1067     , p8_a31  DATE := fnd_api.g_miss_date
1068     , p8_a32  DATE := fnd_api.g_miss_date
1069     , p8_a33  DATE := fnd_api.g_miss_date
1070     , p8_a34  DATE := fnd_api.g_miss_date
1071     , p8_a35  NUMBER := 0-1962.0724
1072     , p8_a36  NUMBER := 0-1962.0724
1073     , p8_a37  NUMBER := 0-1962.0724
1074     , p8_a38  NUMBER := 0-1962.0724
1075     , p8_a39  NUMBER := 0-1962.0724
1076     , p8_a40  NUMBER := 0-1962.0724
1077     , p8_a41  NUMBER := 0-1962.0724
1078     , p8_a42  NUMBER := 0-1962.0724
1079     , p8_a43  NUMBER := 0-1962.0724
1080     , p8_a44  NUMBER := 0-1962.0724
1081     , p8_a45  NUMBER := 0-1962.0724
1082     , p8_a46  NUMBER := 0-1962.0724
1083     , p8_a47  NUMBER := 0-1962.0724
1084     , p8_a48  NUMBER := 0-1962.0724
1085     , p8_a49  DATE := fnd_api.g_miss_date
1086     , p8_a50  DATE := fnd_api.g_miss_date
1087     , p8_a51  NUMBER := 0-1962.0724
1088     , p8_a52  NUMBER := 0-1962.0724
1089     , p8_a53  NUMBER := 0-1962.0724
1090     , p8_a54  NUMBER := 0-1962.0724
1091     , p8_a55  VARCHAR2 := fnd_api.g_miss_char
1092     , p8_a56  VARCHAR2 := fnd_api.g_miss_char
1093     , p8_a57  VARCHAR2 := fnd_api.g_miss_char
1094     , p8_a58  VARCHAR2 := fnd_api.g_miss_char
1095     , p8_a59  NUMBER := 0-1962.0724
1096     , p8_a60  NUMBER := 0-1962.0724
1097     , p8_a61  VARCHAR2 := fnd_api.g_miss_char
1098     , p8_a62  VARCHAR2 := fnd_api.g_miss_char
1099     , p8_a63  VARCHAR2 := fnd_api.g_miss_char
1100     , p8_a64  NUMBER := 0-1962.0724
1101     , p8_a65  VARCHAR2 := fnd_api.g_miss_char
1102     , p8_a66  NUMBER := 0-1962.0724
1103     , p8_a67  NUMBER := 0-1962.0724
1104     , p8_a68  NUMBER := 0-1962.0724
1105     , p8_a69  NUMBER := 0-1962.0724
1106     , p8_a70  DATE := fnd_api.g_miss_date
1107     , p8_a71  VARCHAR2 := fnd_api.g_miss_char
1108     , p8_a72  VARCHAR2 := fnd_api.g_miss_char
1109     , p8_a73  VARCHAR2 := fnd_api.g_miss_char
1110     , p8_a74  VARCHAR2 := fnd_api.g_miss_char
1111     , p8_a75  VARCHAR2 := fnd_api.g_miss_char
1112     , p8_a76  VARCHAR2 := fnd_api.g_miss_char
1113     , p8_a77  VARCHAR2 := fnd_api.g_miss_char
1114     , p8_a78  VARCHAR2 := fnd_api.g_miss_char
1115     , p8_a79  VARCHAR2 := fnd_api.g_miss_char
1116     , p8_a80  VARCHAR2 := fnd_api.g_miss_char
1117     , p8_a81  VARCHAR2 := fnd_api.g_miss_char
1118     , p8_a82  VARCHAR2 := fnd_api.g_miss_char
1119     , p8_a83  VARCHAR2 := fnd_api.g_miss_char
1120     , p8_a84  VARCHAR2 := fnd_api.g_miss_char
1121     , p8_a85  VARCHAR2 := fnd_api.g_miss_char
1122     , p8_a86  VARCHAR2 := fnd_api.g_miss_char
1123     , p8_a87  NUMBER := 0-1962.0724
1124     , p8_a88  DATE := fnd_api.g_miss_date
1125     , p8_a89  NUMBER := 0-1962.0724
1126     , p8_a90  NUMBER := 0-1962.0724
1127     , p8_a91  NUMBER := 0-1962.0724
1128     , p8_a92  VARCHAR2 := fnd_api.g_miss_char
1129     , p8_a93  NUMBER := 0-1962.0724
1130     , p8_a94  VARCHAR2 := fnd_api.g_miss_char
1131     , p8_a95  NUMBER := 0-1962.0724
1132     , p8_a96  NUMBER := 0-1962.0724
1133     , p8_a97  VARCHAR2 := fnd_api.g_miss_char
1134     , p8_a98  VARCHAR2 := fnd_api.g_miss_char
1135     , p8_a99  VARCHAR2 := fnd_api.g_miss_char
1136     , p8_a100  VARCHAR2 := fnd_api.g_miss_char
1137     , p8_a101  VARCHAR2 := fnd_api.g_miss_char
1138     , p8_a102  VARCHAR2 := fnd_api.g_miss_char
1139     , p8_a103  NUMBER := 0-1962.0724
1143     , p8_a107  NUMBER := 0-1962.0724
1140     , p8_a104  NUMBER := 0-1962.0724
1141     , p8_a105  NUMBER := 0-1962.0724
1142     , p8_a106  VARCHAR2 := fnd_api.g_miss_char
1144     , p8_a108  VARCHAR2 := fnd_api.g_miss_char
1145   );
1146 end ams_listheader_pvt_w;