DBA Data[Home] [Help]

PACKAGE: APPS.AMS_EVENTOFFER_PUB_W

Source


1 package ams_eventoffer_pub_w AUTHID CURRENT_USER as
2   /* $Header: amswevos.pls 115.22 2003/05/31 00:28:48 dbiswas ship $ */
3   procedure create_eventoffer(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_evo_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  VARCHAR2 := fnd_api.g_miss_char
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
23     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  NUMBER := 0-1962.0724
25     , p7_a14  DATE := fnd_api.g_miss_date
26     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
27     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
28     , p7_a17  NUMBER := 0-1962.0724
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  VARCHAR2 := fnd_api.g_miss_char
41     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
42     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
43     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
44     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
45     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
46     , p7_a35  NUMBER := 0-1962.0724
47     , p7_a36  NUMBER := 0-1962.0724
48     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
49     , p7_a38  DATE := fnd_api.g_miss_date
50     , p7_a39  DATE := fnd_api.g_miss_date
51     , p7_a40  DATE := fnd_api.g_miss_date
52     , p7_a41  DATE := fnd_api.g_miss_date
53     , p7_a42  DATE := fnd_api.g_miss_date
54     , p7_a43  DATE := fnd_api.g_miss_date
55     , p7_a44  DATE := fnd_api.g_miss_date
56     , p7_a45  DATE := fnd_api.g_miss_date
57     , p7_a46  NUMBER := 0-1962.0724
58     , p7_a47  NUMBER := 0-1962.0724
59     , p7_a48  NUMBER := 0-1962.0724
60     , p7_a49  NUMBER := 0-1962.0724
61     , p7_a50  NUMBER := 0-1962.0724
62     , p7_a51  DATE := fnd_api.g_miss_date
63     , p7_a52  NUMBER := 0-1962.0724
64     , p7_a53  VARCHAR2 := fnd_api.g_miss_char
65     , p7_a54  NUMBER := 0-1962.0724
66     , p7_a55  NUMBER := 0-1962.0724
67     , p7_a56  NUMBER := 0-1962.0724
68     , p7_a57  NUMBER := 0-1962.0724
69     , p7_a58  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a59  VARCHAR2 := fnd_api.g_miss_char
71     , p7_a60  NUMBER := 0-1962.0724
72     , p7_a61  VARCHAR2 := fnd_api.g_miss_char
73     , p7_a62  NUMBER := 0-1962.0724
74     , p7_a63  NUMBER := 0-1962.0724
75     , p7_a64  NUMBER := 0-1962.0724
76     , p7_a65  NUMBER := 0-1962.0724
77     , p7_a66  VARCHAR2 := fnd_api.g_miss_char
78     , p7_a67  NUMBER := 0-1962.0724
79     , p7_a68  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a69  NUMBER := 0-1962.0724
81     , p7_a70  NUMBER := 0-1962.0724
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  NUMBER := 0-1962.0724
88     , p7_a77  NUMBER := 0-1962.0724
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  NUMBER := 0-1962.0724
93     , p7_a82  NUMBER := 0-1962.0724
94     , p7_a83  VARCHAR2 := fnd_api.g_miss_char
95     , p7_a84  NUMBER := 0-1962.0724
96     , p7_a85  VARCHAR2 := fnd_api.g_miss_char
97     , p7_a86  VARCHAR2 := fnd_api.g_miss_char
98     , p7_a87  VARCHAR2 := fnd_api.g_miss_char
99     , p7_a88  VARCHAR2 := fnd_api.g_miss_char
100     , p7_a89  VARCHAR2 := fnd_api.g_miss_char
101     , p7_a90  VARCHAR2 := fnd_api.g_miss_char
102     , p7_a91  VARCHAR2 := fnd_api.g_miss_char
103     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
104     , p7_a93  VARCHAR2 := fnd_api.g_miss_char
105     , p7_a94  VARCHAR2 := fnd_api.g_miss_char
106     , p7_a95  VARCHAR2 := fnd_api.g_miss_char
107     , p7_a96  VARCHAR2 := fnd_api.g_miss_char
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  VARCHAR2 := fnd_api.g_miss_char
115     , p7_a104  VARCHAR2 := fnd_api.g_miss_char
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     , p7_a109  VARCHAR2 := fnd_api.g_miss_char
121     , p7_a110  VARCHAR2 := fnd_api.g_miss_char
122     , p7_a111  VARCHAR2 := fnd_api.g_miss_char
123     , p7_a112  NUMBER := 0-1962.0724
124     , p7_a113  VARCHAR2 := fnd_api.g_miss_char
125     , p7_a114  NUMBER := 0-1962.0724
126     , p7_a115  VARCHAR2 := fnd_api.g_miss_char
127     , p7_a116  VARCHAR2 := fnd_api.g_miss_char
128     , p7_a117  VARCHAR2 := fnd_api.g_miss_char
129     , p7_a118  NUMBER := 0-1962.0724
130     , p7_a119  VARCHAR2 := fnd_api.g_miss_char
131     , p7_a120  VARCHAR2 := fnd_api.g_miss_char
132     , p7_a121  VARCHAR2 := fnd_api.g_miss_char
133     , p7_a122  VARCHAR2 := fnd_api.g_miss_char
134     , p7_a123  VARCHAR2 := fnd_api.g_miss_char
135     , p7_a124  VARCHAR2 := fnd_api.g_miss_char
136     , p7_a125  DATE := fnd_api.g_miss_date
137     , p7_a126  DATE := fnd_api.g_miss_date
138     , p7_a127  NUMBER := 0-1962.0724
139     , p7_a128  NUMBER := 0-1962.0724
140     , p7_a129  VARCHAR2 := fnd_api.g_miss_char
141     , p7_a130  VARCHAR2 := fnd_api.g_miss_char
142     , p7_a131  VARCHAR2 := fnd_api.g_miss_char
143     , p7_a132  VARCHAR2 := fnd_api.g_miss_char
144     , p7_a133  VARCHAR2 := fnd_api.g_miss_char
145     , p7_a134  VARCHAR2 := fnd_api.g_miss_char
146     , p7_a135  VARCHAR2 := fnd_api.g_miss_char
147     , p7_a136  NUMBER := 0-1962.0724
148     , p7_a137  VARCHAR2 := fnd_api.g_miss_char
149   );
150   procedure update_eventoffer(p_api_version  NUMBER
151     , p_init_msg_list  VARCHAR2
152     , p_commit  VARCHAR2
153     , p_validation_level  NUMBER
154     , x_return_status out nocopy  VARCHAR2
155     , x_msg_count out nocopy  NUMBER
156     , x_msg_data out nocopy  VARCHAR2
157     , p7_a0  NUMBER := 0-1962.0724
158     , p7_a1  DATE := fnd_api.g_miss_date
159     , p7_a2  NUMBER := 0-1962.0724
160     , p7_a3  DATE := fnd_api.g_miss_date
161     , p7_a4  NUMBER := 0-1962.0724
162     , p7_a5  NUMBER := 0-1962.0724
163     , p7_a6  NUMBER := 0-1962.0724
164     , p7_a7  NUMBER := 0-1962.0724
165     , p7_a8  NUMBER := 0-1962.0724
166     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
167     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
168     , p7_a11  VARCHAR2 := fnd_api.g_miss_char
169     , p7_a12  VARCHAR2 := fnd_api.g_miss_char
170     , p7_a13  NUMBER := 0-1962.0724
171     , p7_a14  DATE := fnd_api.g_miss_date
172     , p7_a15  VARCHAR2 := fnd_api.g_miss_char
173     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
174     , p7_a17  NUMBER := 0-1962.0724
175     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
176     , p7_a19  VARCHAR2 := fnd_api.g_miss_char
177     , p7_a20  VARCHAR2 := fnd_api.g_miss_char
178     , p7_a21  NUMBER := 0-1962.0724
179     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
180     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
181     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
182     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
183     , p7_a26  VARCHAR2 := fnd_api.g_miss_char
184     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
185     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
186     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
187     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
188     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
189     , p7_a32  VARCHAR2 := fnd_api.g_miss_char
190     , p7_a33  VARCHAR2 := fnd_api.g_miss_char
191     , p7_a34  VARCHAR2 := fnd_api.g_miss_char
192     , p7_a35  NUMBER := 0-1962.0724
193     , p7_a36  NUMBER := 0-1962.0724
194     , p7_a37  VARCHAR2 := fnd_api.g_miss_char
195     , p7_a38  DATE := fnd_api.g_miss_date
196     , p7_a39  DATE := fnd_api.g_miss_date
197     , p7_a40  DATE := fnd_api.g_miss_date
198     , p7_a41  DATE := fnd_api.g_miss_date
199     , p7_a42  DATE := fnd_api.g_miss_date
200     , p7_a43  DATE := fnd_api.g_miss_date
201     , p7_a44  DATE := fnd_api.g_miss_date
202     , p7_a45  DATE := fnd_api.g_miss_date
203     , p7_a46  NUMBER := 0-1962.0724
204     , p7_a47  NUMBER := 0-1962.0724
205     , p7_a48  NUMBER := 0-1962.0724
206     , p7_a49  NUMBER := 0-1962.0724
207     , p7_a50  NUMBER := 0-1962.0724
208     , p7_a51  DATE := fnd_api.g_miss_date
209     , p7_a52  NUMBER := 0-1962.0724
210     , p7_a53  VARCHAR2 := fnd_api.g_miss_char
211     , p7_a54  NUMBER := 0-1962.0724
212     , p7_a55  NUMBER := 0-1962.0724
213     , p7_a56  NUMBER := 0-1962.0724
214     , p7_a57  NUMBER := 0-1962.0724
215     , p7_a58  VARCHAR2 := fnd_api.g_miss_char
216     , p7_a59  VARCHAR2 := fnd_api.g_miss_char
217     , p7_a60  NUMBER := 0-1962.0724
218     , p7_a61  VARCHAR2 := fnd_api.g_miss_char
219     , p7_a62  NUMBER := 0-1962.0724
220     , p7_a63  NUMBER := 0-1962.0724
221     , p7_a64  NUMBER := 0-1962.0724
222     , p7_a65  NUMBER := 0-1962.0724
223     , p7_a66  VARCHAR2 := fnd_api.g_miss_char
224     , p7_a67  NUMBER := 0-1962.0724
225     , p7_a68  VARCHAR2 := fnd_api.g_miss_char
226     , p7_a69  NUMBER := 0-1962.0724
227     , p7_a70  NUMBER := 0-1962.0724
228     , p7_a71  VARCHAR2 := fnd_api.g_miss_char
229     , p7_a72  VARCHAR2 := fnd_api.g_miss_char
230     , p7_a73  VARCHAR2 := fnd_api.g_miss_char
231     , p7_a74  VARCHAR2 := fnd_api.g_miss_char
232     , p7_a75  VARCHAR2 := fnd_api.g_miss_char
233     , p7_a76  NUMBER := 0-1962.0724
234     , p7_a77  NUMBER := 0-1962.0724
235     , p7_a78  VARCHAR2 := fnd_api.g_miss_char
236     , p7_a79  VARCHAR2 := fnd_api.g_miss_char
237     , p7_a80  VARCHAR2 := fnd_api.g_miss_char
238     , p7_a81  NUMBER := 0-1962.0724
239     , p7_a82  NUMBER := 0-1962.0724
240     , p7_a83  VARCHAR2 := fnd_api.g_miss_char
241     , p7_a84  NUMBER := 0-1962.0724
242     , p7_a85  VARCHAR2 := fnd_api.g_miss_char
243     , p7_a86  VARCHAR2 := fnd_api.g_miss_char
244     , p7_a87  VARCHAR2 := fnd_api.g_miss_char
245     , p7_a88  VARCHAR2 := fnd_api.g_miss_char
246     , p7_a89  VARCHAR2 := fnd_api.g_miss_char
247     , p7_a90  VARCHAR2 := fnd_api.g_miss_char
248     , p7_a91  VARCHAR2 := fnd_api.g_miss_char
249     , p7_a92  VARCHAR2 := fnd_api.g_miss_char
250     , p7_a93  VARCHAR2 := fnd_api.g_miss_char
251     , p7_a94  VARCHAR2 := fnd_api.g_miss_char
252     , p7_a95  VARCHAR2 := fnd_api.g_miss_char
253     , p7_a96  VARCHAR2 := fnd_api.g_miss_char
254     , p7_a97  VARCHAR2 := fnd_api.g_miss_char
255     , p7_a98  VARCHAR2 := fnd_api.g_miss_char
256     , p7_a99  VARCHAR2 := fnd_api.g_miss_char
257     , p7_a100  VARCHAR2 := fnd_api.g_miss_char
258     , p7_a101  VARCHAR2 := fnd_api.g_miss_char
259     , p7_a102  VARCHAR2 := fnd_api.g_miss_char
260     , p7_a103  VARCHAR2 := fnd_api.g_miss_char
261     , p7_a104  VARCHAR2 := fnd_api.g_miss_char
262     , p7_a105  NUMBER := 0-1962.0724
263     , p7_a106  VARCHAR2 := fnd_api.g_miss_char
264     , p7_a107  NUMBER := 0-1962.0724
265     , p7_a108  VARCHAR2 := fnd_api.g_miss_char
266     , p7_a109  VARCHAR2 := fnd_api.g_miss_char
267     , p7_a110  VARCHAR2 := fnd_api.g_miss_char
268     , p7_a111  VARCHAR2 := fnd_api.g_miss_char
269     , p7_a112  NUMBER := 0-1962.0724
270     , p7_a113  VARCHAR2 := fnd_api.g_miss_char
271     , p7_a114  NUMBER := 0-1962.0724
272     , p7_a115  VARCHAR2 := fnd_api.g_miss_char
273     , p7_a116  VARCHAR2 := fnd_api.g_miss_char
274     , p7_a117  VARCHAR2 := fnd_api.g_miss_char
275     , p7_a118  NUMBER := 0-1962.0724
276     , p7_a119  VARCHAR2 := fnd_api.g_miss_char
277     , p7_a120  VARCHAR2 := fnd_api.g_miss_char
278     , p7_a121  VARCHAR2 := fnd_api.g_miss_char
279     , p7_a122  VARCHAR2 := fnd_api.g_miss_char
280     , p7_a123  VARCHAR2 := fnd_api.g_miss_char
281     , p7_a124  VARCHAR2 := fnd_api.g_miss_char
282     , p7_a125  DATE := fnd_api.g_miss_date
283     , p7_a126  DATE := fnd_api.g_miss_date
284     , p7_a127  NUMBER := 0-1962.0724
285     , p7_a128  NUMBER := 0-1962.0724
286     , p7_a129  VARCHAR2 := fnd_api.g_miss_char
287     , p7_a130  VARCHAR2 := fnd_api.g_miss_char
288     , p7_a131  VARCHAR2 := fnd_api.g_miss_char
289     , p7_a132  VARCHAR2 := fnd_api.g_miss_char
290     , p7_a133  VARCHAR2 := fnd_api.g_miss_char
291     , p7_a134  VARCHAR2 := fnd_api.g_miss_char
292     , p7_a135  VARCHAR2 := fnd_api.g_miss_char
293     , p7_a136  NUMBER := 0-1962.0724
294     , p7_a137  VARCHAR2 := fnd_api.g_miss_char
295   );
296   procedure validate_eventoffer(p_api_version  NUMBER
297     , p_init_msg_list  VARCHAR2
298     , p_validation_level  NUMBER
299     , x_return_status out nocopy  VARCHAR2
300     , x_msg_count out nocopy  NUMBER
301     , x_msg_data out nocopy  VARCHAR2
302     , p6_a0  NUMBER := 0-1962.0724
303     , p6_a1  DATE := fnd_api.g_miss_date
304     , p6_a2  NUMBER := 0-1962.0724
305     , p6_a3  DATE := fnd_api.g_miss_date
306     , p6_a4  NUMBER := 0-1962.0724
307     , p6_a5  NUMBER := 0-1962.0724
308     , p6_a6  NUMBER := 0-1962.0724
309     , p6_a7  NUMBER := 0-1962.0724
310     , p6_a8  NUMBER := 0-1962.0724
311     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
312     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
313     , p6_a11  VARCHAR2 := fnd_api.g_miss_char
314     , p6_a12  VARCHAR2 := fnd_api.g_miss_char
315     , p6_a13  NUMBER := 0-1962.0724
316     , p6_a14  DATE := fnd_api.g_miss_date
317     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
318     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
319     , p6_a17  NUMBER := 0-1962.0724
320     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
321     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
322     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
323     , p6_a21  NUMBER := 0-1962.0724
324     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
325     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
326     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
327     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
328     , p6_a26  VARCHAR2 := fnd_api.g_miss_char
329     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
330     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
331     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
332     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
333     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
334     , p6_a32  VARCHAR2 := fnd_api.g_miss_char
335     , p6_a33  VARCHAR2 := fnd_api.g_miss_char
336     , p6_a34  VARCHAR2 := fnd_api.g_miss_char
337     , p6_a35  NUMBER := 0-1962.0724
338     , p6_a36  NUMBER := 0-1962.0724
339     , p6_a37  VARCHAR2 := fnd_api.g_miss_char
340     , p6_a38  DATE := fnd_api.g_miss_date
341     , p6_a39  DATE := fnd_api.g_miss_date
342     , p6_a40  DATE := fnd_api.g_miss_date
343     , p6_a41  DATE := fnd_api.g_miss_date
344     , p6_a42  DATE := fnd_api.g_miss_date
345     , p6_a43  DATE := fnd_api.g_miss_date
346     , p6_a44  DATE := fnd_api.g_miss_date
347     , p6_a45  DATE := fnd_api.g_miss_date
348     , p6_a46  NUMBER := 0-1962.0724
349     , p6_a47  NUMBER := 0-1962.0724
350     , p6_a48  NUMBER := 0-1962.0724
351     , p6_a49  NUMBER := 0-1962.0724
352     , p6_a50  NUMBER := 0-1962.0724
353     , p6_a51  DATE := fnd_api.g_miss_date
354     , p6_a52  NUMBER := 0-1962.0724
355     , p6_a53  VARCHAR2 := fnd_api.g_miss_char
356     , p6_a54  NUMBER := 0-1962.0724
357     , p6_a55  NUMBER := 0-1962.0724
358     , p6_a56  NUMBER := 0-1962.0724
359     , p6_a57  NUMBER := 0-1962.0724
360     , p6_a58  VARCHAR2 := fnd_api.g_miss_char
361     , p6_a59  VARCHAR2 := fnd_api.g_miss_char
362     , p6_a60  NUMBER := 0-1962.0724
363     , p6_a61  VARCHAR2 := fnd_api.g_miss_char
364     , p6_a62  NUMBER := 0-1962.0724
365     , p6_a63  NUMBER := 0-1962.0724
366     , p6_a64  NUMBER := 0-1962.0724
367     , p6_a65  NUMBER := 0-1962.0724
368     , p6_a66  VARCHAR2 := fnd_api.g_miss_char
369     , p6_a67  NUMBER := 0-1962.0724
370     , p6_a68  VARCHAR2 := fnd_api.g_miss_char
371     , p6_a69  NUMBER := 0-1962.0724
372     , p6_a70  NUMBER := 0-1962.0724
373     , p6_a71  VARCHAR2 := fnd_api.g_miss_char
374     , p6_a72  VARCHAR2 := fnd_api.g_miss_char
375     , p6_a73  VARCHAR2 := fnd_api.g_miss_char
376     , p6_a74  VARCHAR2 := fnd_api.g_miss_char
377     , p6_a75  VARCHAR2 := fnd_api.g_miss_char
378     , p6_a76  NUMBER := 0-1962.0724
379     , p6_a77  NUMBER := 0-1962.0724
380     , p6_a78  VARCHAR2 := fnd_api.g_miss_char
381     , p6_a79  VARCHAR2 := fnd_api.g_miss_char
382     , p6_a80  VARCHAR2 := fnd_api.g_miss_char
383     , p6_a81  NUMBER := 0-1962.0724
384     , p6_a82  NUMBER := 0-1962.0724
385     , p6_a83  VARCHAR2 := fnd_api.g_miss_char
386     , p6_a84  NUMBER := 0-1962.0724
387     , p6_a85  VARCHAR2 := fnd_api.g_miss_char
388     , p6_a86  VARCHAR2 := fnd_api.g_miss_char
389     , p6_a87  VARCHAR2 := fnd_api.g_miss_char
390     , p6_a88  VARCHAR2 := fnd_api.g_miss_char
391     , p6_a89  VARCHAR2 := fnd_api.g_miss_char
392     , p6_a90  VARCHAR2 := fnd_api.g_miss_char
393     , p6_a91  VARCHAR2 := fnd_api.g_miss_char
394     , p6_a92  VARCHAR2 := fnd_api.g_miss_char
395     , p6_a93  VARCHAR2 := fnd_api.g_miss_char
396     , p6_a94  VARCHAR2 := fnd_api.g_miss_char
397     , p6_a95  VARCHAR2 := fnd_api.g_miss_char
398     , p6_a96  VARCHAR2 := fnd_api.g_miss_char
399     , p6_a97  VARCHAR2 := fnd_api.g_miss_char
400     , p6_a98  VARCHAR2 := fnd_api.g_miss_char
401     , p6_a99  VARCHAR2 := fnd_api.g_miss_char
402     , p6_a100  VARCHAR2 := fnd_api.g_miss_char
403     , p6_a101  VARCHAR2 := fnd_api.g_miss_char
404     , p6_a102  VARCHAR2 := fnd_api.g_miss_char
405     , p6_a103  VARCHAR2 := fnd_api.g_miss_char
406     , p6_a104  VARCHAR2 := fnd_api.g_miss_char
407     , p6_a105  NUMBER := 0-1962.0724
408     , p6_a106  VARCHAR2 := fnd_api.g_miss_char
409     , p6_a107  NUMBER := 0-1962.0724
410     , p6_a108  VARCHAR2 := fnd_api.g_miss_char
411     , p6_a109  VARCHAR2 := fnd_api.g_miss_char
412     , p6_a110  VARCHAR2 := fnd_api.g_miss_char
413     , p6_a111  VARCHAR2 := fnd_api.g_miss_char
414     , p6_a112  NUMBER := 0-1962.0724
415     , p6_a113  VARCHAR2 := fnd_api.g_miss_char
416     , p6_a114  NUMBER := 0-1962.0724
417     , p6_a115  VARCHAR2 := fnd_api.g_miss_char
418     , p6_a116  VARCHAR2 := fnd_api.g_miss_char
419     , p6_a117  VARCHAR2 := fnd_api.g_miss_char
420     , p6_a118  NUMBER := 0-1962.0724
421     , p6_a119  VARCHAR2 := fnd_api.g_miss_char
422     , p6_a120  VARCHAR2 := fnd_api.g_miss_char
423     , p6_a121  VARCHAR2 := fnd_api.g_miss_char
424     , p6_a122  VARCHAR2 := fnd_api.g_miss_char
425     , p6_a123  VARCHAR2 := fnd_api.g_miss_char
426     , p6_a124  VARCHAR2 := fnd_api.g_miss_char
427     , p6_a125  DATE := fnd_api.g_miss_date
428     , p6_a126  DATE := fnd_api.g_miss_date
429     , p6_a127  NUMBER := 0-1962.0724
430     , p6_a128  NUMBER := 0-1962.0724
431     , p6_a129  VARCHAR2 := fnd_api.g_miss_char
432     , p6_a130  VARCHAR2 := fnd_api.g_miss_char
433     , p6_a131  VARCHAR2 := fnd_api.g_miss_char
434     , p6_a132  VARCHAR2 := fnd_api.g_miss_char
435     , p6_a133  VARCHAR2 := fnd_api.g_miss_char
436     , p6_a134  VARCHAR2 := fnd_api.g_miss_char
437     , p6_a135  VARCHAR2 := fnd_api.g_miss_char
438     , p6_a136  NUMBER := 0-1962.0724
439     , p6_a137  VARCHAR2 := fnd_api.g_miss_char
440   );
441 end ams_eventoffer_pub_w;