[Home] [Help]
PACKAGE: APPS.AMS_EVTREGS_PVT_W
Source
1 package ams_evtregs_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswregs.pls 115.14 2004/04/08 09:12:31 anchaudh ship $ */
3 procedure create_evtregs(p_api_version_number NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_block_fulfillment VARCHAR2
8 , x_event_registration_id OUT NOCOPY NUMBER
9 , x_confirmation_code OUT NOCOPY VARCHAR2
10 , x_system_status_code OUT NOCOPY VARCHAR2
11 , x_return_status OUT NOCOPY VARCHAR2
12 , x_msg_count OUT NOCOPY NUMBER
13 , x_msg_data OUT NOCOPY VARCHAR2
14 , p4_a0 NUMBER := 0-1962.0724
15 , p4_a1 DATE := fnd_api.g_miss_date
16 , p4_a2 NUMBER := 0-1962.0724
17 , p4_a3 DATE := fnd_api.g_miss_date
18 , p4_a4 NUMBER := 0-1962.0724
19 , p4_a5 NUMBER := 0-1962.0724
20 , p4_a6 NUMBER := 0-1962.0724
21 , p4_a7 NUMBER := 0-1962.0724
22 , p4_a8 NUMBER := 0-1962.0724
23 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
24 , p4_a10 NUMBER := 0-1962.0724
25 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
26 , p4_a12 DATE := fnd_api.g_miss_date
27 , p4_a13 NUMBER := 0-1962.0724
28 , p4_a14 DATE := fnd_api.g_miss_date
29 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
30 , p4_a16 NUMBER := 0-1962.0724
31 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
32 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
33 , p4_a19 NUMBER := 0-1962.0724
34 , p4_a20 NUMBER := 0-1962.0724
35 , p4_a21 NUMBER := 0-1962.0724
36 , p4_a22 NUMBER := 0-1962.0724
37 , p4_a23 NUMBER := 0-1962.0724
38 , p4_a24 NUMBER := 0-1962.0724
39 , p4_a25 NUMBER := 0-1962.0724
40 , p4_a26 NUMBER := 0-1962.0724
41 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
42 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
43 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
44 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
45 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
46 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
47 , p4_a33 NUMBER := 0-1962.0724
48 , p4_a34 NUMBER := 0-1962.0724
49 , p4_a35 NUMBER := 0-1962.0724
50 , p4_a36 NUMBER := 0-1962.0724
51 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
52 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
53 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
54 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
55 , p4_a41 NUMBER := 0-1962.0724
56 , p4_a42 NUMBER := 0-1962.0724
57 , p4_a43 NUMBER := 0-1962.0724
58 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
59 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
60 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
61 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
62 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
63 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
64 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
65 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
66 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
67 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
68 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
69 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
70 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
71 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
72 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
73 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
74 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
75 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
76 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
77 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
78 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
79 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
80 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
81 , p4_a67 DATE := fnd_api.g_miss_date
82 , p4_a68 DATE := fnd_api.g_miss_date
83 , p4_a69 DATE := fnd_api.g_miss_date
84 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
85 );
86 procedure update_evtregs(p_api_version_number NUMBER
87 , p_init_msg_list VARCHAR2
88 , p_commit VARCHAR2
89 , p_validation_level NUMBER
90 , p_block_fulfillment VARCHAR2
91 , x_return_status OUT NOCOPY VARCHAR2
92 , x_msg_count OUT NOCOPY NUMBER
93 , x_msg_data OUT NOCOPY VARCHAR2
94 , p4_a0 NUMBER := 0-1962.0724
95 , p4_a1 DATE := fnd_api.g_miss_date
96 , p4_a2 NUMBER := 0-1962.0724
97 , p4_a3 DATE := fnd_api.g_miss_date
98 , p4_a4 NUMBER := 0-1962.0724
99 , p4_a5 NUMBER := 0-1962.0724
100 , p4_a6 NUMBER := 0-1962.0724
101 , p4_a7 NUMBER := 0-1962.0724
102 , p4_a8 NUMBER := 0-1962.0724
103 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
104 , p4_a10 NUMBER := 0-1962.0724
105 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
106 , p4_a12 DATE := fnd_api.g_miss_date
107 , p4_a13 NUMBER := 0-1962.0724
108 , p4_a14 DATE := fnd_api.g_miss_date
109 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
110 , p4_a16 NUMBER := 0-1962.0724
111 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
112 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
113 , p4_a19 NUMBER := 0-1962.0724
114 , p4_a20 NUMBER := 0-1962.0724
115 , p4_a21 NUMBER := 0-1962.0724
116 , p4_a22 NUMBER := 0-1962.0724
117 , p4_a23 NUMBER := 0-1962.0724
118 , p4_a24 NUMBER := 0-1962.0724
119 , p4_a25 NUMBER := 0-1962.0724
120 , p4_a26 NUMBER := 0-1962.0724
121 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
122 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
123 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
124 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
125 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
126 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
127 , p4_a33 NUMBER := 0-1962.0724
128 , p4_a34 NUMBER := 0-1962.0724
129 , p4_a35 NUMBER := 0-1962.0724
130 , p4_a36 NUMBER := 0-1962.0724
131 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
132 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
133 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
134 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
135 , p4_a41 NUMBER := 0-1962.0724
136 , p4_a42 NUMBER := 0-1962.0724
137 , p4_a43 NUMBER := 0-1962.0724
138 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
139 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
140 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
141 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
142 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
143 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
144 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
145 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
146 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
147 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
148 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
149 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
150 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
151 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
152 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
153 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
154 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
155 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
156 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
157 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
158 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
159 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
160 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
161 , p4_a67 DATE := fnd_api.g_miss_date
162 , p4_a68 DATE := fnd_api.g_miss_date
163 , p4_a69 DATE := fnd_api.g_miss_date
164 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
165 );
166 procedure update_evtregs_wrapper(p_api_version_number NUMBER
167 , p_init_msg_list VARCHAR2
168 , p_commit VARCHAR2
169 , p_validation_level NUMBER
170 , p_block_fulfillment VARCHAR2
171 , p_cancellation_reason_code VARCHAR2
172 , x_cancellation_code OUT NOCOPY VARCHAR2
173 , x_return_status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , x_msg_data OUT NOCOPY VARCHAR2
176 , p4_a0 NUMBER := 0-1962.0724
177 , p4_a1 DATE := fnd_api.g_miss_date
178 , p4_a2 NUMBER := 0-1962.0724
179 , p4_a3 DATE := fnd_api.g_miss_date
180 , p4_a4 NUMBER := 0-1962.0724
181 , p4_a5 NUMBER := 0-1962.0724
182 , p4_a6 NUMBER := 0-1962.0724
183 , p4_a7 NUMBER := 0-1962.0724
184 , p4_a8 NUMBER := 0-1962.0724
185 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
186 , p4_a10 NUMBER := 0-1962.0724
187 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
188 , p4_a12 DATE := fnd_api.g_miss_date
189 , p4_a13 NUMBER := 0-1962.0724
190 , p4_a14 DATE := fnd_api.g_miss_date
191 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
192 , p4_a16 NUMBER := 0-1962.0724
193 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
194 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
195 , p4_a19 NUMBER := 0-1962.0724
196 , p4_a20 NUMBER := 0-1962.0724
197 , p4_a21 NUMBER := 0-1962.0724
198 , p4_a22 NUMBER := 0-1962.0724
199 , p4_a23 NUMBER := 0-1962.0724
200 , p4_a24 NUMBER := 0-1962.0724
201 , p4_a25 NUMBER := 0-1962.0724
202 , p4_a26 NUMBER := 0-1962.0724
203 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
204 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
205 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
206 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
207 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
208 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
209 , p4_a33 NUMBER := 0-1962.0724
210 , p4_a34 NUMBER := 0-1962.0724
211 , p4_a35 NUMBER := 0-1962.0724
212 , p4_a36 NUMBER := 0-1962.0724
213 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
214 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
215 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
216 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
217 , p4_a41 NUMBER := 0-1962.0724
218 , p4_a42 NUMBER := 0-1962.0724
219 , p4_a43 NUMBER := 0-1962.0724
220 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
221 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
222 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
223 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
224 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
225 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
226 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
227 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
228 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
229 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
230 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
231 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
232 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
233 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
234 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
235 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
236 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
237 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
238 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
239 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
240 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
241 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
242 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
243 , p4_a67 DATE := fnd_api.g_miss_date
244 , p4_a68 DATE := fnd_api.g_miss_date
245 , p4_a69 DATE := fnd_api.g_miss_date
246 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
247 );
248 procedure check_evtregs_items(p_validation_mode VARCHAR2
249 , x_return_status OUT NOCOPY VARCHAR2
250 , p0_a0 NUMBER := 0-1962.0724
251 , p0_a1 DATE := fnd_api.g_miss_date
252 , p0_a2 NUMBER := 0-1962.0724
253 , p0_a3 DATE := fnd_api.g_miss_date
254 , p0_a4 NUMBER := 0-1962.0724
255 , p0_a5 NUMBER := 0-1962.0724
256 , p0_a6 NUMBER := 0-1962.0724
257 , p0_a7 NUMBER := 0-1962.0724
258 , p0_a8 NUMBER := 0-1962.0724
259 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
260 , p0_a10 NUMBER := 0-1962.0724
261 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
262 , p0_a12 DATE := fnd_api.g_miss_date
263 , p0_a13 NUMBER := 0-1962.0724
264 , p0_a14 DATE := fnd_api.g_miss_date
265 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
266 , p0_a16 NUMBER := 0-1962.0724
267 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
268 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
269 , p0_a19 NUMBER := 0-1962.0724
270 , p0_a20 NUMBER := 0-1962.0724
271 , p0_a21 NUMBER := 0-1962.0724
272 , p0_a22 NUMBER := 0-1962.0724
273 , p0_a23 NUMBER := 0-1962.0724
274 , p0_a24 NUMBER := 0-1962.0724
275 , p0_a25 NUMBER := 0-1962.0724
276 , p0_a26 NUMBER := 0-1962.0724
277 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
278 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
279 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
280 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
281 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
282 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
283 , p0_a33 NUMBER := 0-1962.0724
284 , p0_a34 NUMBER := 0-1962.0724
285 , p0_a35 NUMBER := 0-1962.0724
286 , p0_a36 NUMBER := 0-1962.0724
287 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
288 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
289 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
290 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
291 , p0_a41 NUMBER := 0-1962.0724
292 , p0_a42 NUMBER := 0-1962.0724
293 , p0_a43 NUMBER := 0-1962.0724
294 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
295 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
296 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
297 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
298 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
299 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
300 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
301 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
302 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
303 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
304 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
305 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
306 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
307 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
308 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
309 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
310 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
311 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
312 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
313 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
314 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
315 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
316 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
317 , p0_a67 DATE := fnd_api.g_miss_date
318 , p0_a68 DATE := fnd_api.g_miss_date
319 , p0_a69 DATE := fnd_api.g_miss_date
320 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
321 );
322 procedure check_evtregs_req_items(x_return_status OUT NOCOPY VARCHAR2
323 , p0_a0 NUMBER := 0-1962.0724
324 , p0_a1 DATE := fnd_api.g_miss_date
325 , p0_a2 NUMBER := 0-1962.0724
326 , p0_a3 DATE := fnd_api.g_miss_date
327 , p0_a4 NUMBER := 0-1962.0724
328 , p0_a5 NUMBER := 0-1962.0724
329 , p0_a6 NUMBER := 0-1962.0724
330 , p0_a7 NUMBER := 0-1962.0724
331 , p0_a8 NUMBER := 0-1962.0724
332 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
333 , p0_a10 NUMBER := 0-1962.0724
334 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
335 , p0_a12 DATE := fnd_api.g_miss_date
336 , p0_a13 NUMBER := 0-1962.0724
337 , p0_a14 DATE := fnd_api.g_miss_date
338 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
339 , p0_a16 NUMBER := 0-1962.0724
340 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
341 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
342 , p0_a19 NUMBER := 0-1962.0724
343 , p0_a20 NUMBER := 0-1962.0724
344 , p0_a21 NUMBER := 0-1962.0724
345 , p0_a22 NUMBER := 0-1962.0724
346 , p0_a23 NUMBER := 0-1962.0724
347 , p0_a24 NUMBER := 0-1962.0724
348 , p0_a25 NUMBER := 0-1962.0724
349 , p0_a26 NUMBER := 0-1962.0724
350 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
351 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
352 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
353 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
354 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
355 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
356 , p0_a33 NUMBER := 0-1962.0724
357 , p0_a34 NUMBER := 0-1962.0724
358 , p0_a35 NUMBER := 0-1962.0724
359 , p0_a36 NUMBER := 0-1962.0724
360 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
361 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
362 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
366 , p0_a43 NUMBER := 0-1962.0724
363 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
364 , p0_a41 NUMBER := 0-1962.0724
365 , p0_a42 NUMBER := 0-1962.0724
367 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
368 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
369 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
370 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
371 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
372 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
373 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
374 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
375 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
376 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
377 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
378 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
379 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
380 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
381 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
382 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
383 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
384 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
385 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
386 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
387 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
388 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
389 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
390 , p0_a67 DATE := fnd_api.g_miss_date
391 , p0_a68 DATE := fnd_api.g_miss_date
392 , p0_a69 DATE := fnd_api.g_miss_date
393 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
394 );
395 procedure check_evtregs_fk_items(p_validation_mode VARCHAR2
396 , x_return_status OUT NOCOPY VARCHAR2
397 , p0_a0 NUMBER := 0-1962.0724
398 , p0_a1 DATE := fnd_api.g_miss_date
399 , p0_a2 NUMBER := 0-1962.0724
400 , p0_a3 DATE := fnd_api.g_miss_date
401 , p0_a4 NUMBER := 0-1962.0724
402 , p0_a5 NUMBER := 0-1962.0724
403 , p0_a6 NUMBER := 0-1962.0724
404 , p0_a7 NUMBER := 0-1962.0724
405 , p0_a8 NUMBER := 0-1962.0724
406 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
407 , p0_a10 NUMBER := 0-1962.0724
408 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
409 , p0_a12 DATE := fnd_api.g_miss_date
410 , p0_a13 NUMBER := 0-1962.0724
411 , p0_a14 DATE := fnd_api.g_miss_date
412 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
413 , p0_a16 NUMBER := 0-1962.0724
414 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
415 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
416 , p0_a19 NUMBER := 0-1962.0724
417 , p0_a20 NUMBER := 0-1962.0724
418 , p0_a21 NUMBER := 0-1962.0724
419 , p0_a22 NUMBER := 0-1962.0724
420 , p0_a23 NUMBER := 0-1962.0724
421 , p0_a24 NUMBER := 0-1962.0724
422 , p0_a25 NUMBER := 0-1962.0724
423 , p0_a26 NUMBER := 0-1962.0724
424 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
425 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
426 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
427 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
428 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
429 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
430 , p0_a33 NUMBER := 0-1962.0724
431 , p0_a34 NUMBER := 0-1962.0724
432 , p0_a35 NUMBER := 0-1962.0724
433 , p0_a36 NUMBER := 0-1962.0724
434 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
435 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
436 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
437 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
438 , p0_a41 NUMBER := 0-1962.0724
439 , p0_a42 NUMBER := 0-1962.0724
440 , p0_a43 NUMBER := 0-1962.0724
441 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
442 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
443 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
444 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
445 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
446 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
447 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
448 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
449 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
450 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
451 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
452 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
453 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
454 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
455 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
456 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
457 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
458 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
459 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
460 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
461 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
462 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
463 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
464 , p0_a67 DATE := fnd_api.g_miss_date
465 , p0_a68 DATE := fnd_api.g_miss_date
466 , p0_a69 DATE := fnd_api.g_miss_date
467 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
468 );
469 procedure check_evtregs_lookup_items(x_return_status OUT NOCOPY VARCHAR2
470 , p0_a0 NUMBER := 0-1962.0724
471 , p0_a1 DATE := fnd_api.g_miss_date
472 , p0_a2 NUMBER := 0-1962.0724
473 , p0_a3 DATE := fnd_api.g_miss_date
474 , p0_a4 NUMBER := 0-1962.0724
475 , p0_a5 NUMBER := 0-1962.0724
476 , p0_a6 NUMBER := 0-1962.0724
477 , p0_a7 NUMBER := 0-1962.0724
478 , p0_a8 NUMBER := 0-1962.0724
479 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
480 , p0_a10 NUMBER := 0-1962.0724
481 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
485 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
482 , p0_a12 DATE := fnd_api.g_miss_date
483 , p0_a13 NUMBER := 0-1962.0724
484 , p0_a14 DATE := fnd_api.g_miss_date
486 , p0_a16 NUMBER := 0-1962.0724
487 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
488 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
489 , p0_a19 NUMBER := 0-1962.0724
490 , p0_a20 NUMBER := 0-1962.0724
491 , p0_a21 NUMBER := 0-1962.0724
492 , p0_a22 NUMBER := 0-1962.0724
493 , p0_a23 NUMBER := 0-1962.0724
494 , p0_a24 NUMBER := 0-1962.0724
495 , p0_a25 NUMBER := 0-1962.0724
496 , p0_a26 NUMBER := 0-1962.0724
497 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
499 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
500 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
501 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
502 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
503 , p0_a33 NUMBER := 0-1962.0724
504 , p0_a34 NUMBER := 0-1962.0724
505 , p0_a35 NUMBER := 0-1962.0724
506 , p0_a36 NUMBER := 0-1962.0724
507 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
508 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
509 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
510 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
511 , p0_a41 NUMBER := 0-1962.0724
512 , p0_a42 NUMBER := 0-1962.0724
513 , p0_a43 NUMBER := 0-1962.0724
514 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
515 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
516 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
517 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
518 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
519 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
520 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
521 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
522 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
523 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
524 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
525 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
526 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
527 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
528 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
529 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
530 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
531 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
532 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
533 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
534 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
535 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
536 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
537 , p0_a67 DATE := fnd_api.g_miss_date
538 , p0_a68 DATE := fnd_api.g_miss_date
539 , p0_a69 DATE := fnd_api.g_miss_date
540 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
541 );
542 procedure check_evtregs_flag_items(x_return_status OUT NOCOPY VARCHAR2
543 , p0_a0 NUMBER := 0-1962.0724
544 , p0_a1 DATE := fnd_api.g_miss_date
545 , p0_a2 NUMBER := 0-1962.0724
546 , p0_a3 DATE := fnd_api.g_miss_date
547 , p0_a4 NUMBER := 0-1962.0724
548 , p0_a5 NUMBER := 0-1962.0724
549 , p0_a6 NUMBER := 0-1962.0724
550 , p0_a7 NUMBER := 0-1962.0724
551 , p0_a8 NUMBER := 0-1962.0724
552 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
553 , p0_a10 NUMBER := 0-1962.0724
554 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
555 , p0_a12 DATE := fnd_api.g_miss_date
556 , p0_a13 NUMBER := 0-1962.0724
557 , p0_a14 DATE := fnd_api.g_miss_date
558 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
559 , p0_a16 NUMBER := 0-1962.0724
560 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
561 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
562 , p0_a19 NUMBER := 0-1962.0724
563 , p0_a20 NUMBER := 0-1962.0724
564 , p0_a21 NUMBER := 0-1962.0724
565 , p0_a22 NUMBER := 0-1962.0724
566 , p0_a23 NUMBER := 0-1962.0724
567 , p0_a24 NUMBER := 0-1962.0724
568 , p0_a25 NUMBER := 0-1962.0724
569 , p0_a26 NUMBER := 0-1962.0724
570 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
571 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
572 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
573 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
574 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
575 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
576 , p0_a33 NUMBER := 0-1962.0724
577 , p0_a34 NUMBER := 0-1962.0724
578 , p0_a35 NUMBER := 0-1962.0724
579 , p0_a36 NUMBER := 0-1962.0724
580 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
581 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
582 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
583 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
584 , p0_a41 NUMBER := 0-1962.0724
585 , p0_a42 NUMBER := 0-1962.0724
586 , p0_a43 NUMBER := 0-1962.0724
587 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
588 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
589 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
590 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
591 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
592 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
593 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
594 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
595 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
596 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
597 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
598 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
599 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
600 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
604 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
601 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
602 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
603 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
605 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
606 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
607 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
608 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
609 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
610 , p0_a67 DATE := fnd_api.g_miss_date
611 , p0_a68 DATE := fnd_api.g_miss_date
612 , p0_a69 DATE := fnd_api.g_miss_date
613 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
614 );
615 procedure check_evtregs_record(x_return_status OUT NOCOPY VARCHAR2
616 , p0_a0 NUMBER := 0-1962.0724
617 , p0_a1 DATE := fnd_api.g_miss_date
618 , p0_a2 NUMBER := 0-1962.0724
619 , p0_a3 DATE := fnd_api.g_miss_date
620 , p0_a4 NUMBER := 0-1962.0724
621 , p0_a5 NUMBER := 0-1962.0724
622 , p0_a6 NUMBER := 0-1962.0724
623 , p0_a7 NUMBER := 0-1962.0724
624 , p0_a8 NUMBER := 0-1962.0724
625 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a10 NUMBER := 0-1962.0724
627 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
628 , p0_a12 DATE := fnd_api.g_miss_date
629 , p0_a13 NUMBER := 0-1962.0724
630 , p0_a14 DATE := fnd_api.g_miss_date
631 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
632 , p0_a16 NUMBER := 0-1962.0724
633 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
634 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
635 , p0_a19 NUMBER := 0-1962.0724
636 , p0_a20 NUMBER := 0-1962.0724
637 , p0_a21 NUMBER := 0-1962.0724
638 , p0_a22 NUMBER := 0-1962.0724
639 , p0_a23 NUMBER := 0-1962.0724
640 , p0_a24 NUMBER := 0-1962.0724
641 , p0_a25 NUMBER := 0-1962.0724
642 , p0_a26 NUMBER := 0-1962.0724
643 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
644 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
645 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
646 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
647 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
648 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
649 , p0_a33 NUMBER := 0-1962.0724
650 , p0_a34 NUMBER := 0-1962.0724
651 , p0_a35 NUMBER := 0-1962.0724
652 , p0_a36 NUMBER := 0-1962.0724
653 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
654 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
655 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
656 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
657 , p0_a41 NUMBER := 0-1962.0724
658 , p0_a42 NUMBER := 0-1962.0724
659 , p0_a43 NUMBER := 0-1962.0724
660 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
661 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
662 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
663 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
664 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
665 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
666 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
667 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
668 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
669 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
670 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
671 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
672 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
673 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
674 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
675 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
676 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
677 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
678 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
679 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
680 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
681 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
682 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
683 , p0_a67 DATE := fnd_api.g_miss_date
684 , p0_a68 DATE := fnd_api.g_miss_date
685 , p0_a69 DATE := fnd_api.g_miss_date
686 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
687 );
688 procedure validate_evtregs(p_api_version_number NUMBER
689 , p_init_msg_list VARCHAR2
690 , p_validation_level NUMBER
691 , p_validation_mode VARCHAR2
692 , x_return_status OUT NOCOPY VARCHAR2
693 , x_msg_count OUT NOCOPY NUMBER
694 , x_msg_data OUT NOCOPY VARCHAR2
695 , p3_a0 NUMBER := 0-1962.0724
696 , p3_a1 DATE := fnd_api.g_miss_date
697 , p3_a2 NUMBER := 0-1962.0724
698 , p3_a3 DATE := fnd_api.g_miss_date
699 , p3_a4 NUMBER := 0-1962.0724
700 , p3_a5 NUMBER := 0-1962.0724
701 , p3_a6 NUMBER := 0-1962.0724
702 , p3_a7 NUMBER := 0-1962.0724
703 , p3_a8 NUMBER := 0-1962.0724
704 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
705 , p3_a10 NUMBER := 0-1962.0724
706 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
707 , p3_a12 DATE := fnd_api.g_miss_date
708 , p3_a13 NUMBER := 0-1962.0724
709 , p3_a14 DATE := fnd_api.g_miss_date
710 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
711 , p3_a16 NUMBER := 0-1962.0724
712 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
713 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
714 , p3_a19 NUMBER := 0-1962.0724
715 , p3_a20 NUMBER := 0-1962.0724
716 , p3_a21 NUMBER := 0-1962.0724
717 , p3_a22 NUMBER := 0-1962.0724
718 , p3_a23 NUMBER := 0-1962.0724
719 , p3_a24 NUMBER := 0-1962.0724
720 , p3_a25 NUMBER := 0-1962.0724
721 , p3_a26 NUMBER := 0-1962.0724
725 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
722 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
723 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
724 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
726 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
727 , p3_a32 VARCHAR2 := fnd_api.g_miss_char
728 , p3_a33 NUMBER := 0-1962.0724
729 , p3_a34 NUMBER := 0-1962.0724
730 , p3_a35 NUMBER := 0-1962.0724
731 , p3_a36 NUMBER := 0-1962.0724
732 , p3_a37 VARCHAR2 := fnd_api.g_miss_char
733 , p3_a38 VARCHAR2 := fnd_api.g_miss_char
734 , p3_a39 VARCHAR2 := fnd_api.g_miss_char
735 , p3_a40 VARCHAR2 := fnd_api.g_miss_char
736 , p3_a41 NUMBER := 0-1962.0724
737 , p3_a42 NUMBER := 0-1962.0724
738 , p3_a43 NUMBER := 0-1962.0724
739 , p3_a44 VARCHAR2 := fnd_api.g_miss_char
740 , p3_a45 VARCHAR2 := fnd_api.g_miss_char
741 , p3_a46 VARCHAR2 := fnd_api.g_miss_char
742 , p3_a47 VARCHAR2 := fnd_api.g_miss_char
743 , p3_a48 VARCHAR2 := fnd_api.g_miss_char
744 , p3_a49 VARCHAR2 := fnd_api.g_miss_char
745 , p3_a50 VARCHAR2 := fnd_api.g_miss_char
746 , p3_a51 VARCHAR2 := fnd_api.g_miss_char
747 , p3_a52 VARCHAR2 := fnd_api.g_miss_char
748 , p3_a53 VARCHAR2 := fnd_api.g_miss_char
749 , p3_a54 VARCHAR2 := fnd_api.g_miss_char
750 , p3_a55 VARCHAR2 := fnd_api.g_miss_char
751 , p3_a56 VARCHAR2 := fnd_api.g_miss_char
752 , p3_a57 VARCHAR2 := fnd_api.g_miss_char
753 , p3_a58 VARCHAR2 := fnd_api.g_miss_char
754 , p3_a59 VARCHAR2 := fnd_api.g_miss_char
755 , p3_a60 VARCHAR2 := fnd_api.g_miss_char
756 , p3_a61 VARCHAR2 := fnd_api.g_miss_char
757 , p3_a62 VARCHAR2 := fnd_api.g_miss_char
758 , p3_a63 VARCHAR2 := fnd_api.g_miss_char
759 , p3_a64 VARCHAR2 := fnd_api.g_miss_char
760 , p3_a65 VARCHAR2 := fnd_api.g_miss_char
761 , p3_a66 VARCHAR2 := fnd_api.g_miss_char
762 , p3_a67 DATE := fnd_api.g_miss_date
763 , p3_a68 DATE := fnd_api.g_miss_date
764 , p3_a69 DATE := fnd_api.g_miss_date
765 , p3_a70 VARCHAR2 := fnd_api.g_miss_char
766 );
767 procedure init_evtregs_rec(p0_a0 OUT NOCOPY NUMBER
768 , p0_a1 OUT NOCOPY DATE
769 , p0_a2 OUT NOCOPY NUMBER
770 , p0_a3 OUT NOCOPY DATE
771 , p0_a4 OUT NOCOPY NUMBER
772 , p0_a5 OUT NOCOPY NUMBER
773 , p0_a6 OUT NOCOPY NUMBER
774 , p0_a7 OUT NOCOPY NUMBER
775 , p0_a8 OUT NOCOPY NUMBER
776 , p0_a9 OUT NOCOPY VARCHAR2
777 , p0_a10 OUT NOCOPY NUMBER
778 , p0_a11 OUT NOCOPY VARCHAR2
779 , p0_a12 OUT NOCOPY DATE
780 , p0_a13 OUT NOCOPY NUMBER
781 , p0_a14 OUT NOCOPY DATE
782 , p0_a15 OUT NOCOPY VARCHAR2
783 , p0_a16 OUT NOCOPY NUMBER
784 , p0_a17 OUT NOCOPY VARCHAR2
785 , p0_a18 OUT NOCOPY VARCHAR2
786 , p0_a19 OUT NOCOPY NUMBER
787 , p0_a20 OUT NOCOPY NUMBER
788 , p0_a21 OUT NOCOPY NUMBER
789 , p0_a22 OUT NOCOPY NUMBER
790 , p0_a23 OUT NOCOPY NUMBER
791 , p0_a24 OUT NOCOPY NUMBER
792 , p0_a25 OUT NOCOPY NUMBER
793 , p0_a26 OUT NOCOPY NUMBER
794 , p0_a27 OUT NOCOPY VARCHAR2
795 , p0_a28 OUT NOCOPY VARCHAR2
796 , p0_a29 OUT NOCOPY VARCHAR2
797 , p0_a30 OUT NOCOPY VARCHAR2
798 , p0_a31 OUT NOCOPY VARCHAR2
799 , p0_a32 OUT NOCOPY VARCHAR2
800 , p0_a33 OUT NOCOPY NUMBER
801 , p0_a34 OUT NOCOPY NUMBER
802 , p0_a35 OUT NOCOPY NUMBER
803 , p0_a36 OUT NOCOPY NUMBER
804 , p0_a37 OUT NOCOPY VARCHAR2
805 , p0_a38 OUT NOCOPY VARCHAR2
806 , p0_a39 OUT NOCOPY VARCHAR2
807 , p0_a40 OUT NOCOPY VARCHAR2
808 , p0_a41 OUT NOCOPY NUMBER
809 , p0_a42 OUT NOCOPY NUMBER
810 , p0_a43 OUT NOCOPY NUMBER
811 , p0_a44 OUT NOCOPY VARCHAR2
812 , p0_a45 OUT NOCOPY VARCHAR2
813 , p0_a46 OUT NOCOPY VARCHAR2
814 , p0_a47 OUT NOCOPY VARCHAR2
815 , p0_a48 OUT NOCOPY VARCHAR2
816 , p0_a49 OUT NOCOPY VARCHAR2
817 , p0_a50 OUT NOCOPY VARCHAR2
818 , p0_a51 OUT NOCOPY VARCHAR2
819 , p0_a52 OUT NOCOPY VARCHAR2
820 , p0_a53 OUT NOCOPY VARCHAR2
821 , p0_a54 OUT NOCOPY VARCHAR2
822 , p0_a55 OUT NOCOPY VARCHAR2
823 , p0_a56 OUT NOCOPY VARCHAR2
824 , p0_a57 OUT NOCOPY VARCHAR2
825 , p0_a58 OUT NOCOPY VARCHAR2
826 , p0_a59 OUT NOCOPY VARCHAR2
827 , p0_a60 OUT NOCOPY VARCHAR2
828 , p0_a61 OUT NOCOPY VARCHAR2
829 , p0_a62 OUT NOCOPY VARCHAR2
830 , p0_a63 OUT NOCOPY VARCHAR2
831 , p0_a64 OUT NOCOPY VARCHAR2
832 , p0_a65 OUT NOCOPY VARCHAR2
833 , p0_a66 OUT NOCOPY VARCHAR2
834 , p0_a67 OUT NOCOPY DATE
835 , p0_a68 OUT NOCOPY DATE
836 , p0_a69 OUT NOCOPY DATE
837 , p0_a70 OUT NOCOPY VARCHAR2
838 );
839 procedure complete_evtreg_rec(p1_a0 OUT NOCOPY NUMBER
840 , p1_a1 OUT NOCOPY DATE
841 , p1_a2 OUT NOCOPY NUMBER
842 , p1_a3 OUT NOCOPY DATE
843 , p1_a4 OUT NOCOPY NUMBER
844 , p1_a5 OUT NOCOPY NUMBER
845 , p1_a6 OUT NOCOPY NUMBER
846 , p1_a7 OUT NOCOPY NUMBER
847 , p1_a8 OUT NOCOPY NUMBER
848 , p1_a9 OUT NOCOPY VARCHAR2
849 , p1_a10 OUT NOCOPY NUMBER
850 , p1_a11 OUT NOCOPY VARCHAR2
851 , p1_a12 OUT NOCOPY DATE
852 , p1_a13 OUT NOCOPY NUMBER
853 , p1_a14 OUT NOCOPY DATE
857 , p1_a18 OUT NOCOPY VARCHAR2
854 , p1_a15 OUT NOCOPY VARCHAR2
855 , p1_a16 OUT NOCOPY NUMBER
856 , p1_a17 OUT NOCOPY VARCHAR2
858 , p1_a19 OUT NOCOPY NUMBER
859 , p1_a20 OUT NOCOPY NUMBER
860 , p1_a21 OUT NOCOPY NUMBER
861 , p1_a22 OUT NOCOPY NUMBER
862 , p1_a23 OUT NOCOPY NUMBER
863 , p1_a24 OUT NOCOPY NUMBER
864 , p1_a25 OUT NOCOPY NUMBER
865 , p1_a26 OUT NOCOPY NUMBER
866 , p1_a27 OUT NOCOPY VARCHAR2
867 , p1_a28 OUT NOCOPY VARCHAR2
868 , p1_a29 OUT NOCOPY VARCHAR2
869 , p1_a30 OUT NOCOPY VARCHAR2
870 , p1_a31 OUT NOCOPY VARCHAR2
871 , p1_a32 OUT NOCOPY VARCHAR2
872 , p1_a33 OUT NOCOPY NUMBER
873 , p1_a34 OUT NOCOPY NUMBER
874 , p1_a35 OUT NOCOPY NUMBER
875 , p1_a36 OUT NOCOPY NUMBER
876 , p1_a37 OUT NOCOPY VARCHAR2
877 , p1_a38 OUT NOCOPY VARCHAR2
878 , p1_a39 OUT NOCOPY VARCHAR2
879 , p1_a40 OUT NOCOPY VARCHAR2
880 , p1_a41 OUT NOCOPY NUMBER
881 , p1_a42 OUT NOCOPY NUMBER
882 , p1_a43 OUT NOCOPY NUMBER
883 , p1_a44 OUT NOCOPY VARCHAR2
884 , p1_a45 OUT NOCOPY VARCHAR2
885 , p1_a46 OUT NOCOPY VARCHAR2
886 , p1_a47 OUT NOCOPY VARCHAR2
887 , p1_a48 OUT NOCOPY VARCHAR2
888 , p1_a49 OUT NOCOPY VARCHAR2
889 , p1_a50 OUT NOCOPY VARCHAR2
890 , p1_a51 OUT NOCOPY VARCHAR2
891 , p1_a52 OUT NOCOPY VARCHAR2
892 , p1_a53 OUT NOCOPY VARCHAR2
893 , p1_a54 OUT NOCOPY VARCHAR2
894 , p1_a55 OUT NOCOPY VARCHAR2
895 , p1_a56 OUT NOCOPY VARCHAR2
896 , p1_a57 OUT NOCOPY VARCHAR2
897 , p1_a58 OUT NOCOPY VARCHAR2
898 , p1_a59 OUT NOCOPY VARCHAR2
899 , p1_a60 OUT NOCOPY VARCHAR2
900 , p1_a61 OUT NOCOPY VARCHAR2
901 , p1_a62 OUT NOCOPY VARCHAR2
902 , p1_a63 OUT NOCOPY VARCHAR2
903 , p1_a64 OUT NOCOPY VARCHAR2
904 , p1_a65 OUT NOCOPY VARCHAR2
905 , p1_a66 OUT NOCOPY VARCHAR2
906 , p1_a67 OUT NOCOPY DATE
907 , p1_a68 OUT NOCOPY DATE
908 , p1_a69 OUT NOCOPY DATE
909 , p1_a70 OUT NOCOPY VARCHAR2
910 , p0_a0 NUMBER := 0-1962.0724
911 , p0_a1 DATE := fnd_api.g_miss_date
912 , p0_a2 NUMBER := 0-1962.0724
913 , p0_a3 DATE := fnd_api.g_miss_date
914 , p0_a4 NUMBER := 0-1962.0724
915 , p0_a5 NUMBER := 0-1962.0724
916 , p0_a6 NUMBER := 0-1962.0724
917 , p0_a7 NUMBER := 0-1962.0724
918 , p0_a8 NUMBER := 0-1962.0724
919 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
920 , p0_a10 NUMBER := 0-1962.0724
921 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
922 , p0_a12 DATE := fnd_api.g_miss_date
923 , p0_a13 NUMBER := 0-1962.0724
924 , p0_a14 DATE := fnd_api.g_miss_date
925 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
926 , p0_a16 NUMBER := 0-1962.0724
927 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
928 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
929 , p0_a19 NUMBER := 0-1962.0724
930 , p0_a20 NUMBER := 0-1962.0724
931 , p0_a21 NUMBER := 0-1962.0724
932 , p0_a22 NUMBER := 0-1962.0724
933 , p0_a23 NUMBER := 0-1962.0724
934 , p0_a24 NUMBER := 0-1962.0724
935 , p0_a25 NUMBER := 0-1962.0724
936 , p0_a26 NUMBER := 0-1962.0724
937 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
938 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
939 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
940 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
941 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
942 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
943 , p0_a33 NUMBER := 0-1962.0724
944 , p0_a34 NUMBER := 0-1962.0724
945 , p0_a35 NUMBER := 0-1962.0724
946 , p0_a36 NUMBER := 0-1962.0724
947 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
948 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
949 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
950 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
951 , p0_a41 NUMBER := 0-1962.0724
952 , p0_a42 NUMBER := 0-1962.0724
953 , p0_a43 NUMBER := 0-1962.0724
954 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
955 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
956 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
957 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
958 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
959 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
960 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
961 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
962 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
963 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
964 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
965 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
966 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
967 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
968 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
969 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
970 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
971 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
972 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
973 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
974 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
975 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
976 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
977 , p0_a67 DATE := fnd_api.g_miss_date
978 , p0_a68 DATE := fnd_api.g_miss_date
979 , p0_a69 DATE := fnd_api.g_miss_date
980 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
981 );
982 end ams_evtregs_pvt_w;