[Home] [Help]
PACKAGE BODY: APPS.AMS_EVTREGS_PVT_W
Source
1 package body ams_evtregs_pvt_w as
2 /* $Header: amswregb.pls 115.13 2004/04/08 09:12:18 anchaudh ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_evtregs(p_api_version_number NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , p_block_fulfillment VARCHAR2
27 , x_event_registration_id OUT NOCOPY NUMBER
28 , x_confirmation_code OUT NOCOPY VARCHAR2
29 , x_system_status_code OUT NOCOPY VARCHAR2
30 , x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , p4_a0 NUMBER := 0-1962.0724
34 , p4_a1 DATE := fnd_api.g_miss_date
35 , p4_a2 NUMBER := 0-1962.0724
36 , p4_a3 DATE := fnd_api.g_miss_date
37 , p4_a4 NUMBER := 0-1962.0724
38 , p4_a5 NUMBER := 0-1962.0724
39 , p4_a6 NUMBER := 0-1962.0724
40 , p4_a7 NUMBER := 0-1962.0724
41 , p4_a8 NUMBER := 0-1962.0724
42 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
43 , p4_a10 NUMBER := 0-1962.0724
44 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
45 , p4_a12 DATE := fnd_api.g_miss_date
46 , p4_a13 NUMBER := 0-1962.0724
47 , p4_a14 DATE := fnd_api.g_miss_date
48 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
49 , p4_a16 NUMBER := 0-1962.0724
50 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
51 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
52 , p4_a19 NUMBER := 0-1962.0724
53 , p4_a20 NUMBER := 0-1962.0724
54 , p4_a21 NUMBER := 0-1962.0724
55 , p4_a22 NUMBER := 0-1962.0724
56 , p4_a23 NUMBER := 0-1962.0724
57 , p4_a24 NUMBER := 0-1962.0724
58 , p4_a25 NUMBER := 0-1962.0724
59 , p4_a26 NUMBER := 0-1962.0724
60 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
61 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
62 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
63 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
64 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
65 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
66 , p4_a33 NUMBER := 0-1962.0724
67 , p4_a34 NUMBER := 0-1962.0724
68 , p4_a35 NUMBER := 0-1962.0724
69 , p4_a36 NUMBER := 0-1962.0724
70 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
71 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
72 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
73 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
74 , p4_a41 NUMBER := 0-1962.0724
75 , p4_a42 NUMBER := 0-1962.0724
76 , p4_a43 NUMBER := 0-1962.0724
77 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
78 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
79 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
80 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
81 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
82 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
83 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
84 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
85 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
86 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
87 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
88 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
89 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
90 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
91 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
92 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
93 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
94 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
95 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
96 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
97 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
98 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
99 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
100 , p4_a67 DATE := fnd_api.g_miss_date
101 , p4_a68 DATE := fnd_api.g_miss_date
102 , p4_a69 DATE := fnd_api.g_miss_date
103 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
104 )
105 as
106 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
107 ddindx binary_integer; indx binary_integer;
108 begin
109
110 -- copy data to the local IN or IN-OUT args, if any
111
112
113
114
115 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p4_a0);
116 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);
117 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);
118 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p4_a3);
119 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p4_a4);
120 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);
121 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p4_a6);
122 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p4_a7);
123 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p4_a8);
124 ddp_evt_regs_rec.active_flag := p4_a9;
125 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p4_a10);
126 ddp_evt_regs_rec.system_status_code := p4_a11;
127 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p4_a12);
128 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p4_a13);
129 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p4_a14);
130 ddp_evt_regs_rec.reg_source_type_code := p4_a15;
131 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p4_a16);
132 ddp_evt_regs_rec.confirmation_code := p4_a17;
133 ddp_evt_regs_rec.source_code := p4_a18;
134 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p4_a19);
135 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p4_a20);
136 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p4_a21);
137 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p4_a22);
138 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p4_a23);
139 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p4_a24);
140 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p4_a25);
141 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p4_a26);
142 ddp_evt_regs_rec.prospect_flag := p4_a27;
143 ddp_evt_regs_rec.attended_flag := p4_a28;
144 ddp_evt_regs_rec.confirmed_flag := p4_a29;
145 ddp_evt_regs_rec.evaluated_flag := p4_a30;
146 ddp_evt_regs_rec.waitlisted_flag := p4_a31;
147 ddp_evt_regs_rec.attendance_result_code := p4_a32;
148 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p4_a33);
149 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p4_a34);
150 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p4_a35);
151 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p4_a36);
152 ddp_evt_regs_rec.cancellation_code := p4_a37;
153 ddp_evt_regs_rec.cancellation_reason_code := p4_a38;
154 ddp_evt_regs_rec.attendance_failure_reason := p4_a39;
155 ddp_evt_regs_rec.attendant_language := p4_a40;
156 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p4_a41);
157 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p4_a42);
158 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p4_a43);
159 ddp_evt_regs_rec.description := p4_a44;
160 ddp_evt_regs_rec.max_attendee_override_flag := p4_a45;
161 ddp_evt_regs_rec.invite_only_override_flag := p4_a46;
162 ddp_evt_regs_rec.payment_status_code := p4_a47;
163 ddp_evt_regs_rec.auto_register_flag := p4_a48;
164 ddp_evt_regs_rec.attribute_category := p4_a49;
165 ddp_evt_regs_rec.attribute1 := p4_a50;
166 ddp_evt_regs_rec.attribute2 := p4_a51;
167 ddp_evt_regs_rec.attribute3 := p4_a52;
168 ddp_evt_regs_rec.attribute4 := p4_a53;
169 ddp_evt_regs_rec.attribute5 := p4_a54;
170 ddp_evt_regs_rec.attribute6 := p4_a55;
171 ddp_evt_regs_rec.attribute7 := p4_a56;
172 ddp_evt_regs_rec.attribute8 := p4_a57;
173 ddp_evt_regs_rec.attribute9 := p4_a58;
174 ddp_evt_regs_rec.attribute10 := p4_a59;
175 ddp_evt_regs_rec.attribute11 := p4_a60;
176 ddp_evt_regs_rec.attribute12 := p4_a61;
177 ddp_evt_regs_rec.attribute13 := p4_a62;
178 ddp_evt_regs_rec.attribute14 := p4_a63;
179 ddp_evt_regs_rec.attribute15 := p4_a64;
180 ddp_evt_regs_rec.attendee_role_type := p4_a65;
181 ddp_evt_regs_rec.notification_type := p4_a66;
182 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p4_a67);
183 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p4_a68);
184 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p4_a69);
185 ddp_evt_regs_rec.meeting_encryption_key_code := p4_a70;
186
187
188
189
190
191
192
193
194 -- here's the delegated call to the old PL/SQL routine
195 ams_evtregs_pvt.create_evtregs(p_api_version_number,
196 p_init_msg_list,
197 p_commit,
198 p_validation_level,
199 ddp_evt_regs_rec,
200 p_block_fulfillment,
201 x_event_registration_id,
202 x_confirmation_code,
203 x_system_status_code,
204 x_return_status,
205 x_msg_count,
206 x_msg_data);
207
208 -- copy data back from the local OUT or IN-OUT args, if any
209
210
211
212
213
214
215
216
217
218
219
220 end;
221
222 procedure update_evtregs(p_api_version_number NUMBER
223 , p_init_msg_list VARCHAR2
224 , p_commit VARCHAR2
225 , p_validation_level NUMBER
226 , p_block_fulfillment VARCHAR2
227 , x_return_status OUT NOCOPY VARCHAR2
228 , x_msg_count OUT NOCOPY NUMBER
229 , x_msg_data OUT NOCOPY VARCHAR2
230 , p4_a0 NUMBER := 0-1962.0724
231 , p4_a1 DATE := fnd_api.g_miss_date
232 , p4_a2 NUMBER := 0-1962.0724
233 , p4_a3 DATE := fnd_api.g_miss_date
234 , p4_a4 NUMBER := 0-1962.0724
235 , p4_a5 NUMBER := 0-1962.0724
236 , p4_a6 NUMBER := 0-1962.0724
237 , p4_a7 NUMBER := 0-1962.0724
238 , p4_a8 NUMBER := 0-1962.0724
239 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
240 , p4_a10 NUMBER := 0-1962.0724
241 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
242 , p4_a12 DATE := fnd_api.g_miss_date
243 , p4_a13 NUMBER := 0-1962.0724
244 , p4_a14 DATE := fnd_api.g_miss_date
245 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
246 , p4_a16 NUMBER := 0-1962.0724
247 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
248 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
249 , p4_a19 NUMBER := 0-1962.0724
250 , p4_a20 NUMBER := 0-1962.0724
251 , p4_a21 NUMBER := 0-1962.0724
252 , p4_a22 NUMBER := 0-1962.0724
253 , p4_a23 NUMBER := 0-1962.0724
254 , p4_a24 NUMBER := 0-1962.0724
255 , p4_a25 NUMBER := 0-1962.0724
256 , p4_a26 NUMBER := 0-1962.0724
257 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
258 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
259 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
260 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
261 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
262 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
263 , p4_a33 NUMBER := 0-1962.0724
264 , p4_a34 NUMBER := 0-1962.0724
265 , p4_a35 NUMBER := 0-1962.0724
266 , p4_a36 NUMBER := 0-1962.0724
267 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
268 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
269 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
270 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
271 , p4_a41 NUMBER := 0-1962.0724
272 , p4_a42 NUMBER := 0-1962.0724
273 , p4_a43 NUMBER := 0-1962.0724
274 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
275 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
276 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
277 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
278 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
279 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
280 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
281 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
282 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
283 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
284 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
285 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
286 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
287 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
288 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
289 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
290 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
291 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
292 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
293 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
294 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
295 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
296 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
297 , p4_a67 DATE := fnd_api.g_miss_date
298 , p4_a68 DATE := fnd_api.g_miss_date
299 , p4_a69 DATE := fnd_api.g_miss_date
300 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
301 )
302 as
303 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
304 ddindx binary_integer; indx binary_integer;
305 begin
306
307 -- copy data to the local IN or IN-OUT args, if any
308
309
310
311
312 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p4_a0);
313 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);
314 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);
315 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p4_a3);
316 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p4_a4);
317 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);
318 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p4_a6);
319 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p4_a7);
320 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p4_a8);
321 ddp_evt_regs_rec.active_flag := p4_a9;
322 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p4_a10);
323 ddp_evt_regs_rec.system_status_code := p4_a11;
324 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p4_a12);
325 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p4_a13);
326 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p4_a14);
327 ddp_evt_regs_rec.reg_source_type_code := p4_a15;
328 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p4_a16);
329 ddp_evt_regs_rec.confirmation_code := p4_a17;
330 ddp_evt_regs_rec.source_code := p4_a18;
331 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p4_a19);
332 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p4_a20);
333 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p4_a21);
334 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p4_a22);
335 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p4_a23);
336 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p4_a24);
337 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p4_a25);
338 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p4_a26);
339 ddp_evt_regs_rec.prospect_flag := p4_a27;
340 ddp_evt_regs_rec.attended_flag := p4_a28;
341 ddp_evt_regs_rec.confirmed_flag := p4_a29;
342 ddp_evt_regs_rec.evaluated_flag := p4_a30;
343 ddp_evt_regs_rec.waitlisted_flag := p4_a31;
344 ddp_evt_regs_rec.attendance_result_code := p4_a32;
345 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p4_a33);
346 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p4_a34);
347 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p4_a35);
348 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p4_a36);
349 ddp_evt_regs_rec.cancellation_code := p4_a37;
350 ddp_evt_regs_rec.cancellation_reason_code := p4_a38;
351 ddp_evt_regs_rec.attendance_failure_reason := p4_a39;
352 ddp_evt_regs_rec.attendant_language := p4_a40;
356 ddp_evt_regs_rec.description := p4_a44;
353 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p4_a41);
354 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p4_a42);
355 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p4_a43);
357 ddp_evt_regs_rec.max_attendee_override_flag := p4_a45;
358 ddp_evt_regs_rec.invite_only_override_flag := p4_a46;
359 ddp_evt_regs_rec.payment_status_code := p4_a47;
360 ddp_evt_regs_rec.auto_register_flag := p4_a48;
361 ddp_evt_regs_rec.attribute_category := p4_a49;
362 ddp_evt_regs_rec.attribute1 := p4_a50;
363 ddp_evt_regs_rec.attribute2 := p4_a51;
364 ddp_evt_regs_rec.attribute3 := p4_a52;
365 ddp_evt_regs_rec.attribute4 := p4_a53;
366 ddp_evt_regs_rec.attribute5 := p4_a54;
367 ddp_evt_regs_rec.attribute6 := p4_a55;
368 ddp_evt_regs_rec.attribute7 := p4_a56;
369 ddp_evt_regs_rec.attribute8 := p4_a57;
370 ddp_evt_regs_rec.attribute9 := p4_a58;
371 ddp_evt_regs_rec.attribute10 := p4_a59;
372 ddp_evt_regs_rec.attribute11 := p4_a60;
373 ddp_evt_regs_rec.attribute12 := p4_a61;
374 ddp_evt_regs_rec.attribute13 := p4_a62;
375 ddp_evt_regs_rec.attribute14 := p4_a63;
376 ddp_evt_regs_rec.attribute15 := p4_a64;
377 ddp_evt_regs_rec.attendee_role_type := p4_a65;
378 ddp_evt_regs_rec.notification_type := p4_a66;
379 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p4_a67);
380 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p4_a68);
381 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p4_a69);
382 ddp_evt_regs_rec.meeting_encryption_key_code := p4_a70;
383
384
385
386
387
388 -- here's the delegated call to the old PL/SQL routine
389 ams_evtregs_pvt.update_evtregs(p_api_version_number,
390 p_init_msg_list,
391 p_commit,
392 p_validation_level,
393 ddp_evt_regs_rec,
394 p_block_fulfillment,
395 x_return_status,
396 x_msg_count,
397 x_msg_data);
398
399 -- copy data back from the local OUT or IN-OUT args, if any
400
401
402
403
404
405
406
407
408 end;
409
410 procedure update_evtregs_wrapper(p_api_version_number NUMBER
411 , p_init_msg_list VARCHAR2
412 , p_commit VARCHAR2
413 , p_validation_level NUMBER
414 , p_block_fulfillment VARCHAR2
415 , p_cancellation_reason_code VARCHAR2
416 , x_cancellation_code OUT NOCOPY VARCHAR2
417 , x_return_status OUT NOCOPY VARCHAR2
418 , x_msg_count OUT NOCOPY NUMBER
419 , x_msg_data OUT NOCOPY VARCHAR2
420 , p4_a0 NUMBER := 0-1962.0724
421 , p4_a1 DATE := fnd_api.g_miss_date
422 , p4_a2 NUMBER := 0-1962.0724
423 , p4_a3 DATE := fnd_api.g_miss_date
424 , p4_a4 NUMBER := 0-1962.0724
425 , p4_a5 NUMBER := 0-1962.0724
426 , p4_a6 NUMBER := 0-1962.0724
427 , p4_a7 NUMBER := 0-1962.0724
428 , p4_a8 NUMBER := 0-1962.0724
429 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
430 , p4_a10 NUMBER := 0-1962.0724
431 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
432 , p4_a12 DATE := fnd_api.g_miss_date
433 , p4_a13 NUMBER := 0-1962.0724
434 , p4_a14 DATE := fnd_api.g_miss_date
435 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
436 , p4_a16 NUMBER := 0-1962.0724
437 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
438 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
439 , p4_a19 NUMBER := 0-1962.0724
440 , p4_a20 NUMBER := 0-1962.0724
441 , p4_a21 NUMBER := 0-1962.0724
442 , p4_a22 NUMBER := 0-1962.0724
443 , p4_a23 NUMBER := 0-1962.0724
444 , p4_a24 NUMBER := 0-1962.0724
445 , p4_a25 NUMBER := 0-1962.0724
446 , p4_a26 NUMBER := 0-1962.0724
447 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
448 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
449 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
450 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
451 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
452 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
453 , p4_a33 NUMBER := 0-1962.0724
454 , p4_a34 NUMBER := 0-1962.0724
455 , p4_a35 NUMBER := 0-1962.0724
456 , p4_a36 NUMBER := 0-1962.0724
457 , p4_a37 VARCHAR2 := fnd_api.g_miss_char
458 , p4_a38 VARCHAR2 := fnd_api.g_miss_char
459 , p4_a39 VARCHAR2 := fnd_api.g_miss_char
460 , p4_a40 VARCHAR2 := fnd_api.g_miss_char
461 , p4_a41 NUMBER := 0-1962.0724
462 , p4_a42 NUMBER := 0-1962.0724
463 , p4_a43 NUMBER := 0-1962.0724
464 , p4_a44 VARCHAR2 := fnd_api.g_miss_char
465 , p4_a45 VARCHAR2 := fnd_api.g_miss_char
466 , p4_a46 VARCHAR2 := fnd_api.g_miss_char
467 , p4_a47 VARCHAR2 := fnd_api.g_miss_char
468 , p4_a48 VARCHAR2 := fnd_api.g_miss_char
469 , p4_a49 VARCHAR2 := fnd_api.g_miss_char
470 , p4_a50 VARCHAR2 := fnd_api.g_miss_char
471 , p4_a51 VARCHAR2 := fnd_api.g_miss_char
472 , p4_a52 VARCHAR2 := fnd_api.g_miss_char
473 , p4_a53 VARCHAR2 := fnd_api.g_miss_char
474 , p4_a54 VARCHAR2 := fnd_api.g_miss_char
475 , p4_a55 VARCHAR2 := fnd_api.g_miss_char
476 , p4_a56 VARCHAR2 := fnd_api.g_miss_char
477 , p4_a57 VARCHAR2 := fnd_api.g_miss_char
478 , p4_a58 VARCHAR2 := fnd_api.g_miss_char
479 , p4_a59 VARCHAR2 := fnd_api.g_miss_char
483 , p4_a63 VARCHAR2 := fnd_api.g_miss_char
480 , p4_a60 VARCHAR2 := fnd_api.g_miss_char
481 , p4_a61 VARCHAR2 := fnd_api.g_miss_char
482 , p4_a62 VARCHAR2 := fnd_api.g_miss_char
484 , p4_a64 VARCHAR2 := fnd_api.g_miss_char
485 , p4_a65 VARCHAR2 := fnd_api.g_miss_char
486 , p4_a66 VARCHAR2 := fnd_api.g_miss_char
487 , p4_a67 DATE := fnd_api.g_miss_date
488 , p4_a68 DATE := fnd_api.g_miss_date
489 , p4_a69 DATE := fnd_api.g_miss_date
490 , p4_a70 VARCHAR2 := fnd_api.g_miss_char
491 )
492 as
493 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
494 ddindx binary_integer; indx binary_integer;
495 begin
496
497 -- copy data to the local IN or IN-OUT args, if any
498
499
500
501
502 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p4_a0);
503 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a1);
504 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p4_a2);
505 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p4_a3);
506 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p4_a4);
507 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p4_a5);
508 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p4_a6);
509 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p4_a7);
510 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p4_a8);
511 ddp_evt_regs_rec.active_flag := p4_a9;
512 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p4_a10);
513 ddp_evt_regs_rec.system_status_code := p4_a11;
514 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p4_a12);
515 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p4_a13);
516 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p4_a14);
517 ddp_evt_regs_rec.reg_source_type_code := p4_a15;
518 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p4_a16);
519 ddp_evt_regs_rec.confirmation_code := p4_a17;
520 ddp_evt_regs_rec.source_code := p4_a18;
521 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p4_a19);
522 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p4_a20);
523 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p4_a21);
524 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p4_a22);
525 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p4_a23);
526 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p4_a24);
527 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p4_a25);
528 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p4_a26);
529 ddp_evt_regs_rec.prospect_flag := p4_a27;
530 ddp_evt_regs_rec.attended_flag := p4_a28;
531 ddp_evt_regs_rec.confirmed_flag := p4_a29;
532 ddp_evt_regs_rec.evaluated_flag := p4_a30;
533 ddp_evt_regs_rec.waitlisted_flag := p4_a31;
534 ddp_evt_regs_rec.attendance_result_code := p4_a32;
535 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p4_a33);
536 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p4_a34);
537 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p4_a35);
538 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p4_a36);
539 ddp_evt_regs_rec.cancellation_code := p4_a37;
540 ddp_evt_regs_rec.cancellation_reason_code := p4_a38;
541 ddp_evt_regs_rec.attendance_failure_reason := p4_a39;
542 ddp_evt_regs_rec.attendant_language := p4_a40;
543 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p4_a41);
544 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p4_a42);
545 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p4_a43);
546 ddp_evt_regs_rec.description := p4_a44;
547 ddp_evt_regs_rec.max_attendee_override_flag := p4_a45;
548 ddp_evt_regs_rec.invite_only_override_flag := p4_a46;
549 ddp_evt_regs_rec.payment_status_code := p4_a47;
550 ddp_evt_regs_rec.auto_register_flag := p4_a48;
551 ddp_evt_regs_rec.attribute_category := p4_a49;
552 ddp_evt_regs_rec.attribute1 := p4_a50;
553 ddp_evt_regs_rec.attribute2 := p4_a51;
554 ddp_evt_regs_rec.attribute3 := p4_a52;
555 ddp_evt_regs_rec.attribute4 := p4_a53;
556 ddp_evt_regs_rec.attribute5 := p4_a54;
557 ddp_evt_regs_rec.attribute6 := p4_a55;
558 ddp_evt_regs_rec.attribute7 := p4_a56;
559 ddp_evt_regs_rec.attribute8 := p4_a57;
560 ddp_evt_regs_rec.attribute9 := p4_a58;
561 ddp_evt_regs_rec.attribute10 := p4_a59;
562 ddp_evt_regs_rec.attribute11 := p4_a60;
563 ddp_evt_regs_rec.attribute12 := p4_a61;
564 ddp_evt_regs_rec.attribute13 := p4_a62;
565 ddp_evt_regs_rec.attribute14 := p4_a63;
566 ddp_evt_regs_rec.attribute15 := p4_a64;
567 ddp_evt_regs_rec.attendee_role_type := p4_a65;
568 ddp_evt_regs_rec.notification_type := p4_a66;
569 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p4_a67);
570 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p4_a68);
571 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p4_a69);
572 ddp_evt_regs_rec.meeting_encryption_key_code := p4_a70;
573
574
575
576
577
578
579
580 -- here's the delegated call to the old PL/SQL routine
581 ams_evtregs_pvt.update_evtregs_wrapper(p_api_version_number,
582 p_init_msg_list,
583 p_commit,
584 p_validation_level,
585 ddp_evt_regs_rec,
586 p_block_fulfillment,
587 p_cancellation_reason_code,
591 x_msg_data);
588 x_cancellation_code,
589 x_return_status,
590 x_msg_count,
592
593 -- copy data back from the local OUT or IN-OUT args, if any
594
595
596
597
598
599
600
601
602
603
604 end;
605
606 procedure check_evtregs_items(p_validation_mode VARCHAR2
607 , x_return_status OUT NOCOPY VARCHAR2
608 , p0_a0 NUMBER := 0-1962.0724
609 , p0_a1 DATE := fnd_api.g_miss_date
610 , p0_a2 NUMBER := 0-1962.0724
611 , p0_a3 DATE := fnd_api.g_miss_date
612 , p0_a4 NUMBER := 0-1962.0724
613 , p0_a5 NUMBER := 0-1962.0724
614 , p0_a6 NUMBER := 0-1962.0724
615 , p0_a7 NUMBER := 0-1962.0724
616 , p0_a8 NUMBER := 0-1962.0724
617 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
618 , p0_a10 NUMBER := 0-1962.0724
619 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
620 , p0_a12 DATE := fnd_api.g_miss_date
621 , p0_a13 NUMBER := 0-1962.0724
622 , p0_a14 DATE := fnd_api.g_miss_date
623 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
624 , p0_a16 NUMBER := 0-1962.0724
625 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
627 , p0_a19 NUMBER := 0-1962.0724
628 , p0_a20 NUMBER := 0-1962.0724
629 , p0_a21 NUMBER := 0-1962.0724
630 , p0_a22 NUMBER := 0-1962.0724
631 , p0_a23 NUMBER := 0-1962.0724
632 , p0_a24 NUMBER := 0-1962.0724
633 , p0_a25 NUMBER := 0-1962.0724
634 , p0_a26 NUMBER := 0-1962.0724
635 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
636 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
637 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
638 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
639 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
640 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
641 , p0_a33 NUMBER := 0-1962.0724
642 , p0_a34 NUMBER := 0-1962.0724
643 , p0_a35 NUMBER := 0-1962.0724
644 , p0_a36 NUMBER := 0-1962.0724
645 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
646 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
647 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
648 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
649 , p0_a41 NUMBER := 0-1962.0724
650 , p0_a42 NUMBER := 0-1962.0724
651 , p0_a43 NUMBER := 0-1962.0724
652 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
653 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
654 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
655 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
656 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
657 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
658 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
659 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
660 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
661 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
662 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
663 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
664 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
665 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
666 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
667 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
668 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
669 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
670 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
671 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
672 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
673 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
674 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
675 , p0_a67 DATE := fnd_api.g_miss_date
676 , p0_a68 DATE := fnd_api.g_miss_date
677 , p0_a69 DATE := fnd_api.g_miss_date
678 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
679 )
680 as
681 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
682 ddindx binary_integer; indx binary_integer;
683 begin
684
685 -- copy data to the local IN or IN-OUT args, if any
686 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
687 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
688 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
689 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
690 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
691 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
692 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
693 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
694 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
695 ddp_evt_regs_rec.active_flag := p0_a9;
696 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
697 ddp_evt_regs_rec.system_status_code := p0_a11;
698 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
699 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
700 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
701 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
702 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
703 ddp_evt_regs_rec.confirmation_code := p0_a17;
704 ddp_evt_regs_rec.source_code := p0_a18;
705 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
706 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
707 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
708 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
712 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
709 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
710 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
711 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
713 ddp_evt_regs_rec.prospect_flag := p0_a27;
714 ddp_evt_regs_rec.attended_flag := p0_a28;
715 ddp_evt_regs_rec.confirmed_flag := p0_a29;
716 ddp_evt_regs_rec.evaluated_flag := p0_a30;
717 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
718 ddp_evt_regs_rec.attendance_result_code := p0_a32;
719 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
720 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
721 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
722 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
723 ddp_evt_regs_rec.cancellation_code := p0_a37;
724 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
725 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
726 ddp_evt_regs_rec.attendant_language := p0_a40;
727 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
728 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
729 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
730 ddp_evt_regs_rec.description := p0_a44;
731 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
732 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
733 ddp_evt_regs_rec.payment_status_code := p0_a47;
734 ddp_evt_regs_rec.auto_register_flag := p0_a48;
735 ddp_evt_regs_rec.attribute_category := p0_a49;
736 ddp_evt_regs_rec.attribute1 := p0_a50;
737 ddp_evt_regs_rec.attribute2 := p0_a51;
738 ddp_evt_regs_rec.attribute3 := p0_a52;
739 ddp_evt_regs_rec.attribute4 := p0_a53;
740 ddp_evt_regs_rec.attribute5 := p0_a54;
741 ddp_evt_regs_rec.attribute6 := p0_a55;
742 ddp_evt_regs_rec.attribute7 := p0_a56;
743 ddp_evt_regs_rec.attribute8 := p0_a57;
744 ddp_evt_regs_rec.attribute9 := p0_a58;
745 ddp_evt_regs_rec.attribute10 := p0_a59;
746 ddp_evt_regs_rec.attribute11 := p0_a60;
747 ddp_evt_regs_rec.attribute12 := p0_a61;
748 ddp_evt_regs_rec.attribute13 := p0_a62;
749 ddp_evt_regs_rec.attribute14 := p0_a63;
750 ddp_evt_regs_rec.attribute15 := p0_a64;
751 ddp_evt_regs_rec.attendee_role_type := p0_a65;
752 ddp_evt_regs_rec.notification_type := p0_a66;
753 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
754 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
755 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
756 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
757
758
759
760 -- here's the delegated call to the old PL/SQL routine
761 ams_evtregs_pvt.check_evtregs_items(ddp_evt_regs_rec,
762 p_validation_mode,
763 x_return_status);
764
765 -- copy data back from the local OUT or IN-OUT args, if any
766
767
768 end;
769
770 procedure check_evtregs_req_items(x_return_status OUT NOCOPY VARCHAR2
771 , p0_a0 NUMBER := 0-1962.0724
772 , p0_a1 DATE := fnd_api.g_miss_date
773 , p0_a2 NUMBER := 0-1962.0724
774 , p0_a3 DATE := fnd_api.g_miss_date
775 , p0_a4 NUMBER := 0-1962.0724
776 , p0_a5 NUMBER := 0-1962.0724
777 , p0_a6 NUMBER := 0-1962.0724
778 , p0_a7 NUMBER := 0-1962.0724
779 , p0_a8 NUMBER := 0-1962.0724
780 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
781 , p0_a10 NUMBER := 0-1962.0724
782 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
783 , p0_a12 DATE := fnd_api.g_miss_date
784 , p0_a13 NUMBER := 0-1962.0724
785 , p0_a14 DATE := fnd_api.g_miss_date
786 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
787 , p0_a16 NUMBER := 0-1962.0724
788 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
789 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
790 , p0_a19 NUMBER := 0-1962.0724
791 , p0_a20 NUMBER := 0-1962.0724
792 , p0_a21 NUMBER := 0-1962.0724
793 , p0_a22 NUMBER := 0-1962.0724
794 , p0_a23 NUMBER := 0-1962.0724
795 , p0_a24 NUMBER := 0-1962.0724
796 , p0_a25 NUMBER := 0-1962.0724
797 , p0_a26 NUMBER := 0-1962.0724
798 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
799 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
800 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
801 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
802 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
803 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
804 , p0_a33 NUMBER := 0-1962.0724
805 , p0_a34 NUMBER := 0-1962.0724
806 , p0_a35 NUMBER := 0-1962.0724
807 , p0_a36 NUMBER := 0-1962.0724
808 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
809 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
810 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
811 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
812 , p0_a41 NUMBER := 0-1962.0724
813 , p0_a42 NUMBER := 0-1962.0724
814 , p0_a43 NUMBER := 0-1962.0724
815 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
816 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
817 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
818 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
819 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
820 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
821 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
822 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
826 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
823 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
824 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
825 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
827 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
828 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
829 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
830 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
831 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
832 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
833 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
834 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
835 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
836 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
837 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
838 , p0_a67 DATE := fnd_api.g_miss_date
839 , p0_a68 DATE := fnd_api.g_miss_date
840 , p0_a69 DATE := fnd_api.g_miss_date
841 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
842 )
843 as
844 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
845 ddindx binary_integer; indx binary_integer;
846 begin
847
848 -- copy data to the local IN or IN-OUT args, if any
849 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
850 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
851 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
852 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
853 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
854 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
855 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
856 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
857 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
858 ddp_evt_regs_rec.active_flag := p0_a9;
859 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
860 ddp_evt_regs_rec.system_status_code := p0_a11;
861 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
862 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
863 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
864 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
865 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
866 ddp_evt_regs_rec.confirmation_code := p0_a17;
867 ddp_evt_regs_rec.source_code := p0_a18;
868 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
869 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
870 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
871 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
872 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
873 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
874 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
875 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
876 ddp_evt_regs_rec.prospect_flag := p0_a27;
877 ddp_evt_regs_rec.attended_flag := p0_a28;
878 ddp_evt_regs_rec.confirmed_flag := p0_a29;
879 ddp_evt_regs_rec.evaluated_flag := p0_a30;
880 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
881 ddp_evt_regs_rec.attendance_result_code := p0_a32;
882 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
883 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
884 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
885 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
886 ddp_evt_regs_rec.cancellation_code := p0_a37;
887 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
888 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
889 ddp_evt_regs_rec.attendant_language := p0_a40;
890 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
891 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
892 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
893 ddp_evt_regs_rec.description := p0_a44;
894 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
895 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
896 ddp_evt_regs_rec.payment_status_code := p0_a47;
897 ddp_evt_regs_rec.auto_register_flag := p0_a48;
898 ddp_evt_regs_rec.attribute_category := p0_a49;
899 ddp_evt_regs_rec.attribute1 := p0_a50;
900 ddp_evt_regs_rec.attribute2 := p0_a51;
901 ddp_evt_regs_rec.attribute3 := p0_a52;
902 ddp_evt_regs_rec.attribute4 := p0_a53;
903 ddp_evt_regs_rec.attribute5 := p0_a54;
904 ddp_evt_regs_rec.attribute6 := p0_a55;
905 ddp_evt_regs_rec.attribute7 := p0_a56;
906 ddp_evt_regs_rec.attribute8 := p0_a57;
907 ddp_evt_regs_rec.attribute9 := p0_a58;
908 ddp_evt_regs_rec.attribute10 := p0_a59;
909 ddp_evt_regs_rec.attribute11 := p0_a60;
910 ddp_evt_regs_rec.attribute12 := p0_a61;
911 ddp_evt_regs_rec.attribute13 := p0_a62;
912 ddp_evt_regs_rec.attribute14 := p0_a63;
913 ddp_evt_regs_rec.attribute15 := p0_a64;
914 ddp_evt_regs_rec.attendee_role_type := p0_a65;
915 ddp_evt_regs_rec.notification_type := p0_a66;
916 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
917 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
918 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
919 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
920
921
922 -- here's the delegated call to the old PL/SQL routine
926 -- copy data back from the local OUT or IN-OUT args, if any
923 ams_evtregs_pvt.check_evtregs_req_items(ddp_evt_regs_rec,
924 x_return_status);
925
927
928 end;
929
930 procedure check_evtregs_fk_items(p_validation_mode VARCHAR2
931 , x_return_status OUT NOCOPY VARCHAR2
932 , p0_a0 NUMBER := 0-1962.0724
933 , p0_a1 DATE := fnd_api.g_miss_date
934 , p0_a2 NUMBER := 0-1962.0724
935 , p0_a3 DATE := fnd_api.g_miss_date
936 , p0_a4 NUMBER := 0-1962.0724
937 , p0_a5 NUMBER := 0-1962.0724
938 , p0_a6 NUMBER := 0-1962.0724
939 , p0_a7 NUMBER := 0-1962.0724
940 , p0_a8 NUMBER := 0-1962.0724
941 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
942 , p0_a10 NUMBER := 0-1962.0724
943 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
944 , p0_a12 DATE := fnd_api.g_miss_date
945 , p0_a13 NUMBER := 0-1962.0724
946 , p0_a14 DATE := fnd_api.g_miss_date
947 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
948 , p0_a16 NUMBER := 0-1962.0724
949 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
950 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
951 , p0_a19 NUMBER := 0-1962.0724
952 , p0_a20 NUMBER := 0-1962.0724
953 , p0_a21 NUMBER := 0-1962.0724
954 , p0_a22 NUMBER := 0-1962.0724
955 , p0_a23 NUMBER := 0-1962.0724
956 , p0_a24 NUMBER := 0-1962.0724
957 , p0_a25 NUMBER := 0-1962.0724
958 , p0_a26 NUMBER := 0-1962.0724
959 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
960 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
961 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
962 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
963 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
964 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
965 , p0_a33 NUMBER := 0-1962.0724
966 , p0_a34 NUMBER := 0-1962.0724
967 , p0_a35 NUMBER := 0-1962.0724
968 , p0_a36 NUMBER := 0-1962.0724
969 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
970 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
971 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
972 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
973 , p0_a41 NUMBER := 0-1962.0724
974 , p0_a42 NUMBER := 0-1962.0724
975 , p0_a43 NUMBER := 0-1962.0724
976 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
977 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
978 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
979 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
980 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
981 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
982 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
983 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
984 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
985 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
986 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
987 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
988 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
989 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
990 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
991 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
992 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
993 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
994 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
995 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
996 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
997 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
998 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
999 , p0_a67 DATE := fnd_api.g_miss_date
1000 , p0_a68 DATE := fnd_api.g_miss_date
1001 , p0_a69 DATE := fnd_api.g_miss_date
1002 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1003 )
1004 as
1005 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1006 ddindx binary_integer; indx binary_integer;
1007 begin
1008
1009 -- copy data to the local IN or IN-OUT args, if any
1010 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
1011 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1012 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1013 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1014 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1015 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1016 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1017 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
1018 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
1019 ddp_evt_regs_rec.active_flag := p0_a9;
1020 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
1021 ddp_evt_regs_rec.system_status_code := p0_a11;
1022 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
1023 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
1024 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
1025 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
1026 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
1027 ddp_evt_regs_rec.confirmation_code := p0_a17;
1028 ddp_evt_regs_rec.source_code := p0_a18;
1029 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
1030 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
1031 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
1032 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
1033 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
1037 ddp_evt_regs_rec.prospect_flag := p0_a27;
1034 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
1035 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
1036 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
1038 ddp_evt_regs_rec.attended_flag := p0_a28;
1039 ddp_evt_regs_rec.confirmed_flag := p0_a29;
1040 ddp_evt_regs_rec.evaluated_flag := p0_a30;
1041 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
1042 ddp_evt_regs_rec.attendance_result_code := p0_a32;
1043 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
1044 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
1045 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
1046 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
1047 ddp_evt_regs_rec.cancellation_code := p0_a37;
1048 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
1049 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
1050 ddp_evt_regs_rec.attendant_language := p0_a40;
1051 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
1052 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
1053 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
1054 ddp_evt_regs_rec.description := p0_a44;
1055 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
1056 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
1057 ddp_evt_regs_rec.payment_status_code := p0_a47;
1058 ddp_evt_regs_rec.auto_register_flag := p0_a48;
1059 ddp_evt_regs_rec.attribute_category := p0_a49;
1060 ddp_evt_regs_rec.attribute1 := p0_a50;
1061 ddp_evt_regs_rec.attribute2 := p0_a51;
1062 ddp_evt_regs_rec.attribute3 := p0_a52;
1063 ddp_evt_regs_rec.attribute4 := p0_a53;
1064 ddp_evt_regs_rec.attribute5 := p0_a54;
1065 ddp_evt_regs_rec.attribute6 := p0_a55;
1066 ddp_evt_regs_rec.attribute7 := p0_a56;
1067 ddp_evt_regs_rec.attribute8 := p0_a57;
1068 ddp_evt_regs_rec.attribute9 := p0_a58;
1069 ddp_evt_regs_rec.attribute10 := p0_a59;
1070 ddp_evt_regs_rec.attribute11 := p0_a60;
1071 ddp_evt_regs_rec.attribute12 := p0_a61;
1072 ddp_evt_regs_rec.attribute13 := p0_a62;
1073 ddp_evt_regs_rec.attribute14 := p0_a63;
1074 ddp_evt_regs_rec.attribute15 := p0_a64;
1075 ddp_evt_regs_rec.attendee_role_type := p0_a65;
1076 ddp_evt_regs_rec.notification_type := p0_a66;
1077 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
1078 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
1079 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
1080 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
1081
1082
1083
1084 -- here's the delegated call to the old PL/SQL routine
1085 ams_evtregs_pvt.check_evtregs_fk_items(ddp_evt_regs_rec,
1086 p_validation_mode,
1087 x_return_status);
1088
1089 -- copy data back from the local OUT or IN-OUT args, if any
1090
1091
1092 end;
1093
1094 procedure check_evtregs_lookup_items(x_return_status OUT NOCOPY VARCHAR2
1095 , p0_a0 NUMBER := 0-1962.0724
1096 , p0_a1 DATE := fnd_api.g_miss_date
1097 , p0_a2 NUMBER := 0-1962.0724
1098 , p0_a3 DATE := fnd_api.g_miss_date
1099 , p0_a4 NUMBER := 0-1962.0724
1100 , p0_a5 NUMBER := 0-1962.0724
1101 , p0_a6 NUMBER := 0-1962.0724
1102 , p0_a7 NUMBER := 0-1962.0724
1103 , p0_a8 NUMBER := 0-1962.0724
1104 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1105 , p0_a10 NUMBER := 0-1962.0724
1106 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1107 , p0_a12 DATE := fnd_api.g_miss_date
1108 , p0_a13 NUMBER := 0-1962.0724
1109 , p0_a14 DATE := fnd_api.g_miss_date
1110 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1111 , p0_a16 NUMBER := 0-1962.0724
1112 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1113 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1114 , p0_a19 NUMBER := 0-1962.0724
1115 , p0_a20 NUMBER := 0-1962.0724
1116 , p0_a21 NUMBER := 0-1962.0724
1117 , p0_a22 NUMBER := 0-1962.0724
1118 , p0_a23 NUMBER := 0-1962.0724
1119 , p0_a24 NUMBER := 0-1962.0724
1120 , p0_a25 NUMBER := 0-1962.0724
1121 , p0_a26 NUMBER := 0-1962.0724
1122 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1123 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1124 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1125 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1126 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1127 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1128 , p0_a33 NUMBER := 0-1962.0724
1129 , p0_a34 NUMBER := 0-1962.0724
1130 , p0_a35 NUMBER := 0-1962.0724
1131 , p0_a36 NUMBER := 0-1962.0724
1132 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1133 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1134 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1135 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1136 , p0_a41 NUMBER := 0-1962.0724
1137 , p0_a42 NUMBER := 0-1962.0724
1138 , p0_a43 NUMBER := 0-1962.0724
1139 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1140 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1141 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1142 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1143 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1144 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1145 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1146 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1147 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1151 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1148 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1149 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1150 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1152 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1153 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1154 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
1155 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
1156 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1157 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1158 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1159 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
1160 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1161 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
1162 , p0_a67 DATE := fnd_api.g_miss_date
1163 , p0_a68 DATE := fnd_api.g_miss_date
1164 , p0_a69 DATE := fnd_api.g_miss_date
1165 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1166 )
1167 as
1168 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1169 ddindx binary_integer; indx binary_integer;
1170 begin
1171
1172 -- copy data to the local IN or IN-OUT args, if any
1173 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
1174 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1175 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1176 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1177 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1178 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1179 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1180 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
1181 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
1182 ddp_evt_regs_rec.active_flag := p0_a9;
1183 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
1184 ddp_evt_regs_rec.system_status_code := p0_a11;
1185 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
1186 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
1187 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
1188 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
1189 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
1190 ddp_evt_regs_rec.confirmation_code := p0_a17;
1191 ddp_evt_regs_rec.source_code := p0_a18;
1192 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
1193 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
1194 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
1195 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
1196 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
1197 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
1198 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
1199 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
1200 ddp_evt_regs_rec.prospect_flag := p0_a27;
1201 ddp_evt_regs_rec.attended_flag := p0_a28;
1202 ddp_evt_regs_rec.confirmed_flag := p0_a29;
1203 ddp_evt_regs_rec.evaluated_flag := p0_a30;
1204 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
1205 ddp_evt_regs_rec.attendance_result_code := p0_a32;
1206 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
1207 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
1208 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
1209 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
1210 ddp_evt_regs_rec.cancellation_code := p0_a37;
1211 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
1212 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
1213 ddp_evt_regs_rec.attendant_language := p0_a40;
1214 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
1215 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
1216 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
1217 ddp_evt_regs_rec.description := p0_a44;
1218 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
1219 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
1220 ddp_evt_regs_rec.payment_status_code := p0_a47;
1221 ddp_evt_regs_rec.auto_register_flag := p0_a48;
1222 ddp_evt_regs_rec.attribute_category := p0_a49;
1223 ddp_evt_regs_rec.attribute1 := p0_a50;
1224 ddp_evt_regs_rec.attribute2 := p0_a51;
1225 ddp_evt_regs_rec.attribute3 := p0_a52;
1226 ddp_evt_regs_rec.attribute4 := p0_a53;
1227 ddp_evt_regs_rec.attribute5 := p0_a54;
1228 ddp_evt_regs_rec.attribute6 := p0_a55;
1229 ddp_evt_regs_rec.attribute7 := p0_a56;
1230 ddp_evt_regs_rec.attribute8 := p0_a57;
1231 ddp_evt_regs_rec.attribute9 := p0_a58;
1232 ddp_evt_regs_rec.attribute10 := p0_a59;
1233 ddp_evt_regs_rec.attribute11 := p0_a60;
1234 ddp_evt_regs_rec.attribute12 := p0_a61;
1235 ddp_evt_regs_rec.attribute13 := p0_a62;
1236 ddp_evt_regs_rec.attribute14 := p0_a63;
1237 ddp_evt_regs_rec.attribute15 := p0_a64;
1238 ddp_evt_regs_rec.attendee_role_type := p0_a65;
1239 ddp_evt_regs_rec.notification_type := p0_a66;
1240 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
1241 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
1242 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
1243 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
1244
1245
1246 -- here's the delegated call to the old PL/SQL routine
1250 -- copy data back from the local OUT or IN-OUT args, if any
1247 ams_evtregs_pvt.check_evtregs_lookup_items(ddp_evt_regs_rec,
1248 x_return_status);
1249
1251
1252 end;
1253
1254 procedure check_evtregs_flag_items(x_return_status OUT NOCOPY VARCHAR2
1255 , p0_a0 NUMBER := 0-1962.0724
1256 , p0_a1 DATE := fnd_api.g_miss_date
1257 , p0_a2 NUMBER := 0-1962.0724
1258 , p0_a3 DATE := fnd_api.g_miss_date
1259 , p0_a4 NUMBER := 0-1962.0724
1260 , p0_a5 NUMBER := 0-1962.0724
1261 , p0_a6 NUMBER := 0-1962.0724
1262 , p0_a7 NUMBER := 0-1962.0724
1263 , p0_a8 NUMBER := 0-1962.0724
1264 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1265 , p0_a10 NUMBER := 0-1962.0724
1266 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1267 , p0_a12 DATE := fnd_api.g_miss_date
1268 , p0_a13 NUMBER := 0-1962.0724
1269 , p0_a14 DATE := fnd_api.g_miss_date
1270 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1271 , p0_a16 NUMBER := 0-1962.0724
1272 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1273 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1274 , p0_a19 NUMBER := 0-1962.0724
1275 , p0_a20 NUMBER := 0-1962.0724
1276 , p0_a21 NUMBER := 0-1962.0724
1277 , p0_a22 NUMBER := 0-1962.0724
1278 , p0_a23 NUMBER := 0-1962.0724
1279 , p0_a24 NUMBER := 0-1962.0724
1280 , p0_a25 NUMBER := 0-1962.0724
1281 , p0_a26 NUMBER := 0-1962.0724
1282 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1283 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1284 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1285 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1286 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1287 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1288 , p0_a33 NUMBER := 0-1962.0724
1289 , p0_a34 NUMBER := 0-1962.0724
1290 , p0_a35 NUMBER := 0-1962.0724
1291 , p0_a36 NUMBER := 0-1962.0724
1292 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1293 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1294 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1295 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1296 , p0_a41 NUMBER := 0-1962.0724
1297 , p0_a42 NUMBER := 0-1962.0724
1298 , p0_a43 NUMBER := 0-1962.0724
1299 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1300 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1301 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1302 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1303 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1304 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1305 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1306 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1307 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1308 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1309 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1310 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1311 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1312 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1313 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1314 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
1315 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
1316 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1317 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1318 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1319 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
1320 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1321 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
1322 , p0_a67 DATE := fnd_api.g_miss_date
1323 , p0_a68 DATE := fnd_api.g_miss_date
1324 , p0_a69 DATE := fnd_api.g_miss_date
1325 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1326 )
1327 as
1328 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1329 ddindx binary_integer; indx binary_integer;
1330 begin
1331
1332 -- copy data to the local IN or IN-OUT args, if any
1333 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
1334 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1335 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1336 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1337 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1338 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1339 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1340 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
1341 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
1342 ddp_evt_regs_rec.active_flag := p0_a9;
1343 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
1344 ddp_evt_regs_rec.system_status_code := p0_a11;
1345 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
1346 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
1347 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
1348 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
1349 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
1350 ddp_evt_regs_rec.confirmation_code := p0_a17;
1351 ddp_evt_regs_rec.source_code := p0_a18;
1352 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
1353 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
1354 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
1355 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
1356 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
1357 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
1361 ddp_evt_regs_rec.attended_flag := p0_a28;
1358 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
1359 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
1360 ddp_evt_regs_rec.prospect_flag := p0_a27;
1362 ddp_evt_regs_rec.confirmed_flag := p0_a29;
1363 ddp_evt_regs_rec.evaluated_flag := p0_a30;
1364 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
1365 ddp_evt_regs_rec.attendance_result_code := p0_a32;
1366 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
1367 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
1368 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
1369 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
1370 ddp_evt_regs_rec.cancellation_code := p0_a37;
1371 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
1372 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
1373 ddp_evt_regs_rec.attendant_language := p0_a40;
1374 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
1375 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
1376 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
1377 ddp_evt_regs_rec.description := p0_a44;
1378 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
1379 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
1380 ddp_evt_regs_rec.payment_status_code := p0_a47;
1381 ddp_evt_regs_rec.auto_register_flag := p0_a48;
1382 ddp_evt_regs_rec.attribute_category := p0_a49;
1383 ddp_evt_regs_rec.attribute1 := p0_a50;
1384 ddp_evt_regs_rec.attribute2 := p0_a51;
1385 ddp_evt_regs_rec.attribute3 := p0_a52;
1386 ddp_evt_regs_rec.attribute4 := p0_a53;
1387 ddp_evt_regs_rec.attribute5 := p0_a54;
1388 ddp_evt_regs_rec.attribute6 := p0_a55;
1389 ddp_evt_regs_rec.attribute7 := p0_a56;
1390 ddp_evt_regs_rec.attribute8 := p0_a57;
1391 ddp_evt_regs_rec.attribute9 := p0_a58;
1392 ddp_evt_regs_rec.attribute10 := p0_a59;
1393 ddp_evt_regs_rec.attribute11 := p0_a60;
1394 ddp_evt_regs_rec.attribute12 := p0_a61;
1395 ddp_evt_regs_rec.attribute13 := p0_a62;
1396 ddp_evt_regs_rec.attribute14 := p0_a63;
1397 ddp_evt_regs_rec.attribute15 := p0_a64;
1398 ddp_evt_regs_rec.attendee_role_type := p0_a65;
1399 ddp_evt_regs_rec.notification_type := p0_a66;
1400 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
1401 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
1402 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
1403 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
1404
1405
1406 -- here's the delegated call to the old PL/SQL routine
1407 ams_evtregs_pvt.check_evtregs_flag_items(ddp_evt_regs_rec,
1408 x_return_status);
1409
1410 -- copy data back from the local OUT or IN-OUT args, if any
1411
1412 end;
1413
1414 procedure check_evtregs_record(x_return_status OUT NOCOPY VARCHAR2
1415 , p0_a0 NUMBER := 0-1962.0724
1416 , p0_a1 DATE := fnd_api.g_miss_date
1417 , p0_a2 NUMBER := 0-1962.0724
1418 , p0_a3 DATE := fnd_api.g_miss_date
1419 , p0_a4 NUMBER := 0-1962.0724
1420 , p0_a5 NUMBER := 0-1962.0724
1421 , p0_a6 NUMBER := 0-1962.0724
1422 , p0_a7 NUMBER := 0-1962.0724
1423 , p0_a8 NUMBER := 0-1962.0724
1424 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1425 , p0_a10 NUMBER := 0-1962.0724
1426 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1427 , p0_a12 DATE := fnd_api.g_miss_date
1428 , p0_a13 NUMBER := 0-1962.0724
1429 , p0_a14 DATE := fnd_api.g_miss_date
1430 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1431 , p0_a16 NUMBER := 0-1962.0724
1432 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1433 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1434 , p0_a19 NUMBER := 0-1962.0724
1435 , p0_a20 NUMBER := 0-1962.0724
1436 , p0_a21 NUMBER := 0-1962.0724
1437 , p0_a22 NUMBER := 0-1962.0724
1438 , p0_a23 NUMBER := 0-1962.0724
1439 , p0_a24 NUMBER := 0-1962.0724
1440 , p0_a25 NUMBER := 0-1962.0724
1441 , p0_a26 NUMBER := 0-1962.0724
1442 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1443 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1444 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1445 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
1446 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1447 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1448 , p0_a33 NUMBER := 0-1962.0724
1449 , p0_a34 NUMBER := 0-1962.0724
1450 , p0_a35 NUMBER := 0-1962.0724
1451 , p0_a36 NUMBER := 0-1962.0724
1452 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1453 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1454 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1455 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1456 , p0_a41 NUMBER := 0-1962.0724
1457 , p0_a42 NUMBER := 0-1962.0724
1458 , p0_a43 NUMBER := 0-1962.0724
1459 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1460 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1461 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1462 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1463 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1464 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1465 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1466 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1467 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
1468 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
1469 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
1470 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
1474 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
1471 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
1472 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
1473 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
1475 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
1476 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
1477 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
1478 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
1479 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
1480 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
1481 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
1482 , p0_a67 DATE := fnd_api.g_miss_date
1483 , p0_a68 DATE := fnd_api.g_miss_date
1484 , p0_a69 DATE := fnd_api.g_miss_date
1485 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
1486 )
1487 as
1488 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1489 ddindx binary_integer; indx binary_integer;
1490 begin
1491
1492 -- copy data to the local IN or IN-OUT args, if any
1493 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
1494 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1495 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1496 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1497 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1498 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1499 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1500 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
1501 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
1502 ddp_evt_regs_rec.active_flag := p0_a9;
1503 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
1504 ddp_evt_regs_rec.system_status_code := p0_a11;
1505 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
1506 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
1507 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
1508 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
1509 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
1510 ddp_evt_regs_rec.confirmation_code := p0_a17;
1511 ddp_evt_regs_rec.source_code := p0_a18;
1512 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
1513 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
1514 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
1515 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
1516 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
1517 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
1518 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
1519 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
1520 ddp_evt_regs_rec.prospect_flag := p0_a27;
1521 ddp_evt_regs_rec.attended_flag := p0_a28;
1522 ddp_evt_regs_rec.confirmed_flag := p0_a29;
1523 ddp_evt_regs_rec.evaluated_flag := p0_a30;
1524 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
1525 ddp_evt_regs_rec.attendance_result_code := p0_a32;
1526 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
1527 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
1528 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
1529 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
1530 ddp_evt_regs_rec.cancellation_code := p0_a37;
1531 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
1532 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
1533 ddp_evt_regs_rec.attendant_language := p0_a40;
1534 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
1535 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
1536 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
1537 ddp_evt_regs_rec.description := p0_a44;
1538 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
1539 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
1540 ddp_evt_regs_rec.payment_status_code := p0_a47;
1541 ddp_evt_regs_rec.auto_register_flag := p0_a48;
1542 ddp_evt_regs_rec.attribute_category := p0_a49;
1543 ddp_evt_regs_rec.attribute1 := p0_a50;
1544 ddp_evt_regs_rec.attribute2 := p0_a51;
1545 ddp_evt_regs_rec.attribute3 := p0_a52;
1546 ddp_evt_regs_rec.attribute4 := p0_a53;
1547 ddp_evt_regs_rec.attribute5 := p0_a54;
1548 ddp_evt_regs_rec.attribute6 := p0_a55;
1549 ddp_evt_regs_rec.attribute7 := p0_a56;
1550 ddp_evt_regs_rec.attribute8 := p0_a57;
1551 ddp_evt_regs_rec.attribute9 := p0_a58;
1552 ddp_evt_regs_rec.attribute10 := p0_a59;
1553 ddp_evt_regs_rec.attribute11 := p0_a60;
1554 ddp_evt_regs_rec.attribute12 := p0_a61;
1555 ddp_evt_regs_rec.attribute13 := p0_a62;
1556 ddp_evt_regs_rec.attribute14 := p0_a63;
1557 ddp_evt_regs_rec.attribute15 := p0_a64;
1558 ddp_evt_regs_rec.attendee_role_type := p0_a65;
1559 ddp_evt_regs_rec.notification_type := p0_a66;
1560 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
1561 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
1562 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
1563 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
1564
1565
1566 -- here's the delegated call to the old PL/SQL routine
1567 ams_evtregs_pvt.check_evtregs_record(ddp_evt_regs_rec,
1568 x_return_status);
1569
1570 -- copy data back from the local OUT or IN-OUT args, if any
1571
1572 end;
1573
1577 , p_validation_mode VARCHAR2
1574 procedure validate_evtregs(p_api_version_number NUMBER
1575 , p_init_msg_list VARCHAR2
1576 , p_validation_level NUMBER
1578 , x_return_status OUT NOCOPY VARCHAR2
1579 , x_msg_count OUT NOCOPY NUMBER
1580 , x_msg_data OUT NOCOPY VARCHAR2
1581 , p3_a0 NUMBER := 0-1962.0724
1582 , p3_a1 DATE := fnd_api.g_miss_date
1583 , p3_a2 NUMBER := 0-1962.0724
1584 , p3_a3 DATE := fnd_api.g_miss_date
1585 , p3_a4 NUMBER := 0-1962.0724
1586 , p3_a5 NUMBER := 0-1962.0724
1587 , p3_a6 NUMBER := 0-1962.0724
1588 , p3_a7 NUMBER := 0-1962.0724
1589 , p3_a8 NUMBER := 0-1962.0724
1590 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
1591 , p3_a10 NUMBER := 0-1962.0724
1592 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
1593 , p3_a12 DATE := fnd_api.g_miss_date
1594 , p3_a13 NUMBER := 0-1962.0724
1595 , p3_a14 DATE := fnd_api.g_miss_date
1596 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1597 , p3_a16 NUMBER := 0-1962.0724
1598 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1599 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1600 , p3_a19 NUMBER := 0-1962.0724
1601 , p3_a20 NUMBER := 0-1962.0724
1602 , p3_a21 NUMBER := 0-1962.0724
1603 , p3_a22 NUMBER := 0-1962.0724
1604 , p3_a23 NUMBER := 0-1962.0724
1605 , p3_a24 NUMBER := 0-1962.0724
1606 , p3_a25 NUMBER := 0-1962.0724
1607 , p3_a26 NUMBER := 0-1962.0724
1608 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1609 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1610 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
1611 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
1612 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
1613 , p3_a32 VARCHAR2 := fnd_api.g_miss_char
1614 , p3_a33 NUMBER := 0-1962.0724
1615 , p3_a34 NUMBER := 0-1962.0724
1616 , p3_a35 NUMBER := 0-1962.0724
1617 , p3_a36 NUMBER := 0-1962.0724
1618 , p3_a37 VARCHAR2 := fnd_api.g_miss_char
1619 , p3_a38 VARCHAR2 := fnd_api.g_miss_char
1620 , p3_a39 VARCHAR2 := fnd_api.g_miss_char
1621 , p3_a40 VARCHAR2 := fnd_api.g_miss_char
1622 , p3_a41 NUMBER := 0-1962.0724
1623 , p3_a42 NUMBER := 0-1962.0724
1624 , p3_a43 NUMBER := 0-1962.0724
1625 , p3_a44 VARCHAR2 := fnd_api.g_miss_char
1626 , p3_a45 VARCHAR2 := fnd_api.g_miss_char
1627 , p3_a46 VARCHAR2 := fnd_api.g_miss_char
1628 , p3_a47 VARCHAR2 := fnd_api.g_miss_char
1629 , p3_a48 VARCHAR2 := fnd_api.g_miss_char
1630 , p3_a49 VARCHAR2 := fnd_api.g_miss_char
1631 , p3_a50 VARCHAR2 := fnd_api.g_miss_char
1632 , p3_a51 VARCHAR2 := fnd_api.g_miss_char
1633 , p3_a52 VARCHAR2 := fnd_api.g_miss_char
1634 , p3_a53 VARCHAR2 := fnd_api.g_miss_char
1635 , p3_a54 VARCHAR2 := fnd_api.g_miss_char
1636 , p3_a55 VARCHAR2 := fnd_api.g_miss_char
1637 , p3_a56 VARCHAR2 := fnd_api.g_miss_char
1638 , p3_a57 VARCHAR2 := fnd_api.g_miss_char
1639 , p3_a58 VARCHAR2 := fnd_api.g_miss_char
1640 , p3_a59 VARCHAR2 := fnd_api.g_miss_char
1641 , p3_a60 VARCHAR2 := fnd_api.g_miss_char
1642 , p3_a61 VARCHAR2 := fnd_api.g_miss_char
1643 , p3_a62 VARCHAR2 := fnd_api.g_miss_char
1644 , p3_a63 VARCHAR2 := fnd_api.g_miss_char
1645 , p3_a64 VARCHAR2 := fnd_api.g_miss_char
1646 , p3_a65 VARCHAR2 := fnd_api.g_miss_char
1647 , p3_a66 VARCHAR2 := fnd_api.g_miss_char
1648 , p3_a67 DATE := fnd_api.g_miss_date
1649 , p3_a68 DATE := fnd_api.g_miss_date
1650 , p3_a69 DATE := fnd_api.g_miss_date
1651 , p3_a70 VARCHAR2 := fnd_api.g_miss_char
1652 )
1653 as
1654 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1655 ddindx binary_integer; indx binary_integer;
1656 begin
1657
1658 -- copy data to the local IN or IN-OUT args, if any
1659
1660
1661
1662 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p3_a0);
1663 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a1);
1664 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);
1665 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p3_a3);
1666 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p3_a4);
1667 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p3_a5);
1668 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p3_a6);
1669 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p3_a7);
1670 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p3_a8);
1671 ddp_evt_regs_rec.active_flag := p3_a9;
1672 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p3_a10);
1673 ddp_evt_regs_rec.system_status_code := p3_a11;
1674 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p3_a12);
1675 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p3_a13);
1676 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p3_a14);
1677 ddp_evt_regs_rec.reg_source_type_code := p3_a15;
1678 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p3_a16);
1679 ddp_evt_regs_rec.confirmation_code := p3_a17;
1680 ddp_evt_regs_rec.source_code := p3_a18;
1681 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p3_a19);
1682 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p3_a20);
1683 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p3_a21);
1684 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p3_a22);
1688 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p3_a26);
1685 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p3_a23);
1686 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p3_a24);
1687 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p3_a25);
1689 ddp_evt_regs_rec.prospect_flag := p3_a27;
1690 ddp_evt_regs_rec.attended_flag := p3_a28;
1691 ddp_evt_regs_rec.confirmed_flag := p3_a29;
1692 ddp_evt_regs_rec.evaluated_flag := p3_a30;
1693 ddp_evt_regs_rec.waitlisted_flag := p3_a31;
1694 ddp_evt_regs_rec.attendance_result_code := p3_a32;
1695 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p3_a33);
1696 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p3_a34);
1697 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p3_a35);
1698 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p3_a36);
1699 ddp_evt_regs_rec.cancellation_code := p3_a37;
1700 ddp_evt_regs_rec.cancellation_reason_code := p3_a38;
1701 ddp_evt_regs_rec.attendance_failure_reason := p3_a39;
1702 ddp_evt_regs_rec.attendant_language := p3_a40;
1703 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p3_a41);
1704 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p3_a42);
1705 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p3_a43);
1706 ddp_evt_regs_rec.description := p3_a44;
1707 ddp_evt_regs_rec.max_attendee_override_flag := p3_a45;
1708 ddp_evt_regs_rec.invite_only_override_flag := p3_a46;
1709 ddp_evt_regs_rec.payment_status_code := p3_a47;
1710 ddp_evt_regs_rec.auto_register_flag := p3_a48;
1711 ddp_evt_regs_rec.attribute_category := p3_a49;
1712 ddp_evt_regs_rec.attribute1 := p3_a50;
1713 ddp_evt_regs_rec.attribute2 := p3_a51;
1714 ddp_evt_regs_rec.attribute3 := p3_a52;
1715 ddp_evt_regs_rec.attribute4 := p3_a53;
1716 ddp_evt_regs_rec.attribute5 := p3_a54;
1717 ddp_evt_regs_rec.attribute6 := p3_a55;
1718 ddp_evt_regs_rec.attribute7 := p3_a56;
1719 ddp_evt_regs_rec.attribute8 := p3_a57;
1720 ddp_evt_regs_rec.attribute9 := p3_a58;
1721 ddp_evt_regs_rec.attribute10 := p3_a59;
1722 ddp_evt_regs_rec.attribute11 := p3_a60;
1723 ddp_evt_regs_rec.attribute12 := p3_a61;
1724 ddp_evt_regs_rec.attribute13 := p3_a62;
1725 ddp_evt_regs_rec.attribute14 := p3_a63;
1726 ddp_evt_regs_rec.attribute15 := p3_a64;
1727 ddp_evt_regs_rec.attendee_role_type := p3_a65;
1728 ddp_evt_regs_rec.notification_type := p3_a66;
1729 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p3_a67);
1730 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p3_a68);
1731 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p3_a69);
1732 ddp_evt_regs_rec.meeting_encryption_key_code := p3_a70;
1733
1734
1735
1736
1737
1738 -- here's the delegated call to the old PL/SQL routine
1739 ams_evtregs_pvt.validate_evtregs(p_api_version_number,
1740 p_init_msg_list,
1741 p_validation_level,
1742 ddp_evt_regs_rec,
1743 p_validation_mode,
1744 x_return_status,
1745 x_msg_count,
1746 x_msg_data);
1747
1748 -- copy data back from the local OUT or IN-OUT args, if any
1749
1750
1751
1752
1753
1754
1755
1756 end;
1757
1758 procedure init_evtregs_rec(p0_a0 OUT NOCOPY NUMBER
1759 , p0_a1 OUT NOCOPY DATE
1760 , p0_a2 OUT NOCOPY NUMBER
1761 , p0_a3 OUT NOCOPY DATE
1762 , p0_a4 OUT NOCOPY NUMBER
1763 , p0_a5 OUT NOCOPY NUMBER
1764 , p0_a6 OUT NOCOPY NUMBER
1765 , p0_a7 OUT NOCOPY NUMBER
1766 , p0_a8 OUT NOCOPY NUMBER
1767 , p0_a9 OUT NOCOPY VARCHAR2
1768 , p0_a10 OUT NOCOPY NUMBER
1769 , p0_a11 OUT NOCOPY VARCHAR2
1770 , p0_a12 OUT NOCOPY DATE
1771 , p0_a13 OUT NOCOPY NUMBER
1772 , p0_a14 OUT NOCOPY DATE
1773 , p0_a15 OUT NOCOPY VARCHAR2
1774 , p0_a16 OUT NOCOPY NUMBER
1775 , p0_a17 OUT NOCOPY VARCHAR2
1776 , p0_a18 OUT NOCOPY VARCHAR2
1777 , p0_a19 OUT NOCOPY NUMBER
1778 , p0_a20 OUT NOCOPY NUMBER
1779 , p0_a21 OUT NOCOPY NUMBER
1780 , p0_a22 OUT NOCOPY NUMBER
1781 , p0_a23 OUT NOCOPY NUMBER
1782 , p0_a24 OUT NOCOPY NUMBER
1783 , p0_a25 OUT NOCOPY NUMBER
1784 , p0_a26 OUT NOCOPY NUMBER
1785 , p0_a27 OUT NOCOPY VARCHAR2
1786 , p0_a28 OUT NOCOPY VARCHAR2
1787 , p0_a29 OUT NOCOPY VARCHAR2
1788 , p0_a30 OUT NOCOPY VARCHAR2
1789 , p0_a31 OUT NOCOPY VARCHAR2
1790 , p0_a32 OUT NOCOPY VARCHAR2
1791 , p0_a33 OUT NOCOPY NUMBER
1792 , p0_a34 OUT NOCOPY NUMBER
1793 , p0_a35 OUT NOCOPY NUMBER
1794 , p0_a36 OUT NOCOPY NUMBER
1795 , p0_a37 OUT NOCOPY VARCHAR2
1796 , p0_a38 OUT NOCOPY VARCHAR2
1797 , p0_a39 OUT NOCOPY VARCHAR2
1798 , p0_a40 OUT NOCOPY VARCHAR2
1799 , p0_a41 OUT NOCOPY NUMBER
1800 , p0_a42 OUT NOCOPY NUMBER
1801 , p0_a43 OUT NOCOPY NUMBER
1802 , p0_a44 OUT NOCOPY VARCHAR2
1803 , p0_a45 OUT NOCOPY VARCHAR2
1804 , p0_a46 OUT NOCOPY VARCHAR2
1805 , p0_a47 OUT NOCOPY VARCHAR2
1806 , p0_a48 OUT NOCOPY VARCHAR2
1807 , p0_a49 OUT NOCOPY VARCHAR2
1808 , p0_a50 OUT NOCOPY VARCHAR2
1809 , p0_a51 OUT NOCOPY VARCHAR2
1810 , p0_a52 OUT NOCOPY VARCHAR2
1811 , p0_a53 OUT NOCOPY VARCHAR2
1812 , p0_a54 OUT NOCOPY VARCHAR2
1813 , p0_a55 OUT NOCOPY VARCHAR2
1817 , p0_a59 OUT NOCOPY VARCHAR2
1814 , p0_a56 OUT NOCOPY VARCHAR2
1815 , p0_a57 OUT NOCOPY VARCHAR2
1816 , p0_a58 OUT NOCOPY VARCHAR2
1818 , p0_a60 OUT NOCOPY VARCHAR2
1819 , p0_a61 OUT NOCOPY VARCHAR2
1820 , p0_a62 OUT NOCOPY VARCHAR2
1821 , p0_a63 OUT NOCOPY VARCHAR2
1822 , p0_a64 OUT NOCOPY VARCHAR2
1823 , p0_a65 OUT NOCOPY VARCHAR2
1824 , p0_a66 OUT NOCOPY VARCHAR2
1825 , p0_a67 OUT NOCOPY DATE
1826 , p0_a68 OUT NOCOPY DATE
1827 , p0_a69 OUT NOCOPY DATE
1828 , p0_a70 OUT NOCOPY VARCHAR2
1829 )
1830 as
1831 ddx_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
1832 ddindx binary_integer; indx binary_integer;
1833 begin
1834
1835 -- copy data to the local IN or IN-OUT args, if any
1836
1837 -- here's the delegated call to the old PL/SQL routine
1838 ams_evtregs_pvt.init_evtregs_rec(ddx_evt_regs_rec);
1839
1840 -- copy data back from the local OUT or IN-OUT args, if any
1841 p0_a0 := rosetta_g_miss_num_map(ddx_evt_regs_rec.event_registration_id);
1842 p0_a1 := ddx_evt_regs_rec.last_update_date;
1843 p0_a2 := rosetta_g_miss_num_map(ddx_evt_regs_rec.last_updated_by);
1844 p0_a3 := ddx_evt_regs_rec.creation_date;
1845 p0_a4 := rosetta_g_miss_num_map(ddx_evt_regs_rec.created_by);
1846 p0_a5 := rosetta_g_miss_num_map(ddx_evt_regs_rec.last_update_login);
1847 p0_a6 := rosetta_g_miss_num_map(ddx_evt_regs_rec.object_version_number);
1848 p0_a7 := rosetta_g_miss_num_map(ddx_evt_regs_rec.event_offer_id);
1849 p0_a8 := rosetta_g_miss_num_map(ddx_evt_regs_rec.application_id);
1850 p0_a9 := ddx_evt_regs_rec.active_flag;
1851 p0_a10 := rosetta_g_miss_num_map(ddx_evt_regs_rec.owner_user_id);
1852 p0_a11 := ddx_evt_regs_rec.system_status_code;
1853 p0_a12 := ddx_evt_regs_rec.date_registration_placed;
1854 p0_a13 := rosetta_g_miss_num_map(ddx_evt_regs_rec.user_status_id);
1855 p0_a14 := ddx_evt_regs_rec.last_reg_status_date;
1856 p0_a15 := ddx_evt_regs_rec.reg_source_type_code;
1857 p0_a16 := rosetta_g_miss_num_map(ddx_evt_regs_rec.registration_source_id);
1858 p0_a17 := ddx_evt_regs_rec.confirmation_code;
1859 p0_a18 := ddx_evt_regs_rec.source_code;
1860 p0_a19 := rosetta_g_miss_num_map(ddx_evt_regs_rec.registration_group_id);
1861 p0_a20 := rosetta_g_miss_num_map(ddx_evt_regs_rec.registrant_party_id);
1862 p0_a21 := rosetta_g_miss_num_map(ddx_evt_regs_rec.registrant_contact_id);
1863 p0_a22 := rosetta_g_miss_num_map(ddx_evt_regs_rec.registrant_account_id);
1864 p0_a23 := rosetta_g_miss_num_map(ddx_evt_regs_rec.attendant_party_id);
1865 p0_a24 := rosetta_g_miss_num_map(ddx_evt_regs_rec.attendant_contact_id);
1866 p0_a25 := rosetta_g_miss_num_map(ddx_evt_regs_rec.attendant_account_id);
1867 p0_a26 := rosetta_g_miss_num_map(ddx_evt_regs_rec.original_registrant_contact_id);
1868 p0_a27 := ddx_evt_regs_rec.prospect_flag;
1869 p0_a28 := ddx_evt_regs_rec.attended_flag;
1870 p0_a29 := ddx_evt_regs_rec.confirmed_flag;
1871 p0_a30 := ddx_evt_regs_rec.evaluated_flag;
1872 p0_a31 := ddx_evt_regs_rec.waitlisted_flag;
1873 p0_a32 := ddx_evt_regs_rec.attendance_result_code;
1874 p0_a33 := rosetta_g_miss_num_map(ddx_evt_regs_rec.waitlisted_priority);
1875 p0_a34 := rosetta_g_miss_num_map(ddx_evt_regs_rec.target_list_id);
1876 p0_a35 := rosetta_g_miss_num_map(ddx_evt_regs_rec.inbound_media_id);
1877 p0_a36 := rosetta_g_miss_num_map(ddx_evt_regs_rec.inbound_channel_id);
1878 p0_a37 := ddx_evt_regs_rec.cancellation_code;
1879 p0_a38 := ddx_evt_regs_rec.cancellation_reason_code;
1880 p0_a39 := ddx_evt_regs_rec.attendance_failure_reason;
1881 p0_a40 := ddx_evt_regs_rec.attendant_language;
1882 p0_a41 := rosetta_g_miss_num_map(ddx_evt_regs_rec.salesrep_id);
1883 p0_a42 := rosetta_g_miss_num_map(ddx_evt_regs_rec.order_header_id);
1884 p0_a43 := rosetta_g_miss_num_map(ddx_evt_regs_rec.order_line_id);
1885 p0_a44 := ddx_evt_regs_rec.description;
1886 p0_a45 := ddx_evt_regs_rec.max_attendee_override_flag;
1887 p0_a46 := ddx_evt_regs_rec.invite_only_override_flag;
1888 p0_a47 := ddx_evt_regs_rec.payment_status_code;
1889 p0_a48 := ddx_evt_regs_rec.auto_register_flag;
1890 p0_a49 := ddx_evt_regs_rec.attribute_category;
1891 p0_a50 := ddx_evt_regs_rec.attribute1;
1892 p0_a51 := ddx_evt_regs_rec.attribute2;
1893 p0_a52 := ddx_evt_regs_rec.attribute3;
1894 p0_a53 := ddx_evt_regs_rec.attribute4;
1895 p0_a54 := ddx_evt_regs_rec.attribute5;
1896 p0_a55 := ddx_evt_regs_rec.attribute6;
1897 p0_a56 := ddx_evt_regs_rec.attribute7;
1898 p0_a57 := ddx_evt_regs_rec.attribute8;
1899 p0_a58 := ddx_evt_regs_rec.attribute9;
1900 p0_a59 := ddx_evt_regs_rec.attribute10;
1901 p0_a60 := ddx_evt_regs_rec.attribute11;
1902 p0_a61 := ddx_evt_regs_rec.attribute12;
1903 p0_a62 := ddx_evt_regs_rec.attribute13;
1904 p0_a63 := ddx_evt_regs_rec.attribute14;
1905 p0_a64 := ddx_evt_regs_rec.attribute15;
1906 p0_a65 := ddx_evt_regs_rec.attendee_role_type;
1907 p0_a66 := ddx_evt_regs_rec.notification_type;
1908 p0_a67 := ddx_evt_regs_rec.last_notified_time;
1909 p0_a68 := ddx_evt_regs_rec.event_join_time;
1910 p0_a69 := ddx_evt_regs_rec.event_exit_time;
1911 p0_a70 := ddx_evt_regs_rec.meeting_encryption_key_code;
1912 end;
1913
1914 procedure complete_evtreg_rec(p1_a0 OUT NOCOPY NUMBER
1915 , p1_a1 OUT NOCOPY DATE
1916 , p1_a2 OUT NOCOPY NUMBER
1917 , p1_a3 OUT NOCOPY DATE
1918 , p1_a4 OUT NOCOPY NUMBER
1919 , p1_a5 OUT NOCOPY NUMBER
1920 , p1_a6 OUT NOCOPY NUMBER
1924 , p1_a10 OUT NOCOPY NUMBER
1921 , p1_a7 OUT NOCOPY NUMBER
1922 , p1_a8 OUT NOCOPY NUMBER
1923 , p1_a9 OUT NOCOPY VARCHAR2
1925 , p1_a11 OUT NOCOPY VARCHAR2
1926 , p1_a12 OUT NOCOPY DATE
1927 , p1_a13 OUT NOCOPY NUMBER
1928 , p1_a14 OUT NOCOPY DATE
1929 , p1_a15 OUT NOCOPY VARCHAR2
1930 , p1_a16 OUT NOCOPY NUMBER
1931 , p1_a17 OUT NOCOPY VARCHAR2
1932 , p1_a18 OUT NOCOPY VARCHAR2
1933 , p1_a19 OUT NOCOPY NUMBER
1934 , p1_a20 OUT NOCOPY NUMBER
1935 , p1_a21 OUT NOCOPY NUMBER
1936 , p1_a22 OUT NOCOPY NUMBER
1937 , p1_a23 OUT NOCOPY NUMBER
1938 , p1_a24 OUT NOCOPY NUMBER
1939 , p1_a25 OUT NOCOPY NUMBER
1940 , p1_a26 OUT NOCOPY NUMBER
1941 , p1_a27 OUT NOCOPY VARCHAR2
1942 , p1_a28 OUT NOCOPY VARCHAR2
1943 , p1_a29 OUT NOCOPY VARCHAR2
1944 , p1_a30 OUT NOCOPY VARCHAR2
1945 , p1_a31 OUT NOCOPY VARCHAR2
1946 , p1_a32 OUT NOCOPY VARCHAR2
1947 , p1_a33 OUT NOCOPY NUMBER
1948 , p1_a34 OUT NOCOPY NUMBER
1949 , p1_a35 OUT NOCOPY NUMBER
1950 , p1_a36 OUT NOCOPY NUMBER
1951 , p1_a37 OUT NOCOPY VARCHAR2
1952 , p1_a38 OUT NOCOPY VARCHAR2
1953 , p1_a39 OUT NOCOPY VARCHAR2
1954 , p1_a40 OUT NOCOPY VARCHAR2
1955 , p1_a41 OUT NOCOPY NUMBER
1956 , p1_a42 OUT NOCOPY NUMBER
1957 , p1_a43 OUT NOCOPY NUMBER
1958 , p1_a44 OUT NOCOPY VARCHAR2
1959 , p1_a45 OUT NOCOPY VARCHAR2
1960 , p1_a46 OUT NOCOPY VARCHAR2
1961 , p1_a47 OUT NOCOPY VARCHAR2
1962 , p1_a48 OUT NOCOPY VARCHAR2
1963 , p1_a49 OUT NOCOPY VARCHAR2
1964 , p1_a50 OUT NOCOPY VARCHAR2
1965 , p1_a51 OUT NOCOPY VARCHAR2
1966 , p1_a52 OUT NOCOPY VARCHAR2
1967 , p1_a53 OUT NOCOPY VARCHAR2
1968 , p1_a54 OUT NOCOPY VARCHAR2
1969 , p1_a55 OUT NOCOPY VARCHAR2
1970 , p1_a56 OUT NOCOPY VARCHAR2
1971 , p1_a57 OUT NOCOPY VARCHAR2
1972 , p1_a58 OUT NOCOPY VARCHAR2
1973 , p1_a59 OUT NOCOPY VARCHAR2
1974 , p1_a60 OUT NOCOPY VARCHAR2
1975 , p1_a61 OUT NOCOPY VARCHAR2
1976 , p1_a62 OUT NOCOPY VARCHAR2
1977 , p1_a63 OUT NOCOPY VARCHAR2
1978 , p1_a64 OUT NOCOPY VARCHAR2
1979 , p1_a65 OUT NOCOPY VARCHAR2
1980 , p1_a66 OUT NOCOPY VARCHAR2
1981 , p1_a67 OUT NOCOPY DATE
1982 , p1_a68 OUT NOCOPY DATE
1983 , p1_a69 OUT NOCOPY DATE
1984 , p1_a70 OUT NOCOPY VARCHAR2
1985 , p0_a0 NUMBER := 0-1962.0724
1986 , p0_a1 DATE := fnd_api.g_miss_date
1987 , p0_a2 NUMBER := 0-1962.0724
1988 , p0_a3 DATE := fnd_api.g_miss_date
1989 , p0_a4 NUMBER := 0-1962.0724
1990 , p0_a5 NUMBER := 0-1962.0724
1991 , p0_a6 NUMBER := 0-1962.0724
1992 , p0_a7 NUMBER := 0-1962.0724
1993 , p0_a8 NUMBER := 0-1962.0724
1994 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1995 , p0_a10 NUMBER := 0-1962.0724
1996 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1997 , p0_a12 DATE := fnd_api.g_miss_date
1998 , p0_a13 NUMBER := 0-1962.0724
1999 , p0_a14 DATE := fnd_api.g_miss_date
2000 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
2001 , p0_a16 NUMBER := 0-1962.0724
2002 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
2003 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
2004 , p0_a19 NUMBER := 0-1962.0724
2005 , p0_a20 NUMBER := 0-1962.0724
2006 , p0_a21 NUMBER := 0-1962.0724
2007 , p0_a22 NUMBER := 0-1962.0724
2008 , p0_a23 NUMBER := 0-1962.0724
2009 , p0_a24 NUMBER := 0-1962.0724
2010 , p0_a25 NUMBER := 0-1962.0724
2011 , p0_a26 NUMBER := 0-1962.0724
2012 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
2013 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
2014 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
2015 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
2016 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
2017 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
2018 , p0_a33 NUMBER := 0-1962.0724
2019 , p0_a34 NUMBER := 0-1962.0724
2020 , p0_a35 NUMBER := 0-1962.0724
2021 , p0_a36 NUMBER := 0-1962.0724
2022 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
2023 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
2024 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
2025 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
2026 , p0_a41 NUMBER := 0-1962.0724
2027 , p0_a42 NUMBER := 0-1962.0724
2028 , p0_a43 NUMBER := 0-1962.0724
2029 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
2030 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
2031 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
2032 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
2033 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
2034 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
2035 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
2036 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
2037 , p0_a52 VARCHAR2 := fnd_api.g_miss_char
2038 , p0_a53 VARCHAR2 := fnd_api.g_miss_char
2039 , p0_a54 VARCHAR2 := fnd_api.g_miss_char
2040 , p0_a55 VARCHAR2 := fnd_api.g_miss_char
2041 , p0_a56 VARCHAR2 := fnd_api.g_miss_char
2042 , p0_a57 VARCHAR2 := fnd_api.g_miss_char
2043 , p0_a58 VARCHAR2 := fnd_api.g_miss_char
2044 , p0_a59 VARCHAR2 := fnd_api.g_miss_char
2045 , p0_a60 VARCHAR2 := fnd_api.g_miss_char
2046 , p0_a61 VARCHAR2 := fnd_api.g_miss_char
2047 , p0_a62 VARCHAR2 := fnd_api.g_miss_char
2051 , p0_a66 VARCHAR2 := fnd_api.g_miss_char
2048 , p0_a63 VARCHAR2 := fnd_api.g_miss_char
2049 , p0_a64 VARCHAR2 := fnd_api.g_miss_char
2050 , p0_a65 VARCHAR2 := fnd_api.g_miss_char
2052 , p0_a67 DATE := fnd_api.g_miss_date
2053 , p0_a68 DATE := fnd_api.g_miss_date
2054 , p0_a69 DATE := fnd_api.g_miss_date
2055 , p0_a70 VARCHAR2 := fnd_api.g_miss_char
2056 )
2057 as
2058 ddp_evt_regs_rec ams_evtregs_pvt.evt_regs_rec_type;
2059 ddx_complete_rec ams_evtregs_pvt.evt_regs_rec_type;
2060 ddindx binary_integer; indx binary_integer;
2061 begin
2062
2063 -- copy data to the local IN or IN-OUT args, if any
2064 ddp_evt_regs_rec.event_registration_id := rosetta_g_miss_num_map(p0_a0);
2065 ddp_evt_regs_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
2066 ddp_evt_regs_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
2067 ddp_evt_regs_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
2068 ddp_evt_regs_rec.created_by := rosetta_g_miss_num_map(p0_a4);
2069 ddp_evt_regs_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
2070 ddp_evt_regs_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
2071 ddp_evt_regs_rec.event_offer_id := rosetta_g_miss_num_map(p0_a7);
2072 ddp_evt_regs_rec.application_id := rosetta_g_miss_num_map(p0_a8);
2073 ddp_evt_regs_rec.active_flag := p0_a9;
2074 ddp_evt_regs_rec.owner_user_id := rosetta_g_miss_num_map(p0_a10);
2075 ddp_evt_regs_rec.system_status_code := p0_a11;
2076 ddp_evt_regs_rec.date_registration_placed := rosetta_g_miss_date_in_map(p0_a12);
2077 ddp_evt_regs_rec.user_status_id := rosetta_g_miss_num_map(p0_a13);
2078 ddp_evt_regs_rec.last_reg_status_date := rosetta_g_miss_date_in_map(p0_a14);
2079 ddp_evt_regs_rec.reg_source_type_code := p0_a15;
2080 ddp_evt_regs_rec.registration_source_id := rosetta_g_miss_num_map(p0_a16);
2081 ddp_evt_regs_rec.confirmation_code := p0_a17;
2082 ddp_evt_regs_rec.source_code := p0_a18;
2083 ddp_evt_regs_rec.registration_group_id := rosetta_g_miss_num_map(p0_a19);
2084 ddp_evt_regs_rec.registrant_party_id := rosetta_g_miss_num_map(p0_a20);
2085 ddp_evt_regs_rec.registrant_contact_id := rosetta_g_miss_num_map(p0_a21);
2086 ddp_evt_regs_rec.registrant_account_id := rosetta_g_miss_num_map(p0_a22);
2087 ddp_evt_regs_rec.attendant_party_id := rosetta_g_miss_num_map(p0_a23);
2088 ddp_evt_regs_rec.attendant_contact_id := rosetta_g_miss_num_map(p0_a24);
2089 ddp_evt_regs_rec.attendant_account_id := rosetta_g_miss_num_map(p0_a25);
2090 ddp_evt_regs_rec.original_registrant_contact_id := rosetta_g_miss_num_map(p0_a26);
2091 ddp_evt_regs_rec.prospect_flag := p0_a27;
2092 ddp_evt_regs_rec.attended_flag := p0_a28;
2093 ddp_evt_regs_rec.confirmed_flag := p0_a29;
2094 ddp_evt_regs_rec.evaluated_flag := p0_a30;
2095 ddp_evt_regs_rec.waitlisted_flag := p0_a31;
2096 ddp_evt_regs_rec.attendance_result_code := p0_a32;
2097 ddp_evt_regs_rec.waitlisted_priority := rosetta_g_miss_num_map(p0_a33);
2098 ddp_evt_regs_rec.target_list_id := rosetta_g_miss_num_map(p0_a34);
2099 ddp_evt_regs_rec.inbound_media_id := rosetta_g_miss_num_map(p0_a35);
2100 ddp_evt_regs_rec.inbound_channel_id := rosetta_g_miss_num_map(p0_a36);
2101 ddp_evt_regs_rec.cancellation_code := p0_a37;
2102 ddp_evt_regs_rec.cancellation_reason_code := p0_a38;
2103 ddp_evt_regs_rec.attendance_failure_reason := p0_a39;
2104 ddp_evt_regs_rec.attendant_language := p0_a40;
2105 ddp_evt_regs_rec.salesrep_id := rosetta_g_miss_num_map(p0_a41);
2106 ddp_evt_regs_rec.order_header_id := rosetta_g_miss_num_map(p0_a42);
2107 ddp_evt_regs_rec.order_line_id := rosetta_g_miss_num_map(p0_a43);
2108 ddp_evt_regs_rec.description := p0_a44;
2109 ddp_evt_regs_rec.max_attendee_override_flag := p0_a45;
2110 ddp_evt_regs_rec.invite_only_override_flag := p0_a46;
2111 ddp_evt_regs_rec.payment_status_code := p0_a47;
2112 ddp_evt_regs_rec.auto_register_flag := p0_a48;
2113 ddp_evt_regs_rec.attribute_category := p0_a49;
2114 ddp_evt_regs_rec.attribute1 := p0_a50;
2115 ddp_evt_regs_rec.attribute2 := p0_a51;
2116 ddp_evt_regs_rec.attribute3 := p0_a52;
2117 ddp_evt_regs_rec.attribute4 := p0_a53;
2118 ddp_evt_regs_rec.attribute5 := p0_a54;
2119 ddp_evt_regs_rec.attribute6 := p0_a55;
2120 ddp_evt_regs_rec.attribute7 := p0_a56;
2121 ddp_evt_regs_rec.attribute8 := p0_a57;
2122 ddp_evt_regs_rec.attribute9 := p0_a58;
2123 ddp_evt_regs_rec.attribute10 := p0_a59;
2124 ddp_evt_regs_rec.attribute11 := p0_a60;
2125 ddp_evt_regs_rec.attribute12 := p0_a61;
2126 ddp_evt_regs_rec.attribute13 := p0_a62;
2127 ddp_evt_regs_rec.attribute14 := p0_a63;
2128 ddp_evt_regs_rec.attribute15 := p0_a64;
2129 ddp_evt_regs_rec.attendee_role_type := p0_a65;
2130 ddp_evt_regs_rec.notification_type := p0_a66;
2131 ddp_evt_regs_rec.last_notified_time := rosetta_g_miss_date_in_map(p0_a67);
2132 ddp_evt_regs_rec.event_join_time := rosetta_g_miss_date_in_map(p0_a68);
2133 ddp_evt_regs_rec.event_exit_time := rosetta_g_miss_date_in_map(p0_a69);
2134 ddp_evt_regs_rec.meeting_encryption_key_code := p0_a70;
2135
2136
2137 -- here's the delegated call to the old PL/SQL routine
2138 ams_evtregs_pvt.complete_evtreg_rec(ddp_evt_regs_rec,
2139 ddx_complete_rec);
2140
2141 -- copy data back from the local OUT or IN-OUT args, if any
2142
2143 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.event_registration_id);
2144 p1_a1 := ddx_complete_rec.last_update_date;
2145 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
2146 p1_a3 := ddx_complete_rec.creation_date;
2150 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.event_offer_id);
2147 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
2148 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
2149 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
2151 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.application_id);
2152 p1_a9 := ddx_complete_rec.active_flag;
2153 p1_a10 := rosetta_g_miss_num_map(ddx_complete_rec.owner_user_id);
2154 p1_a11 := ddx_complete_rec.system_status_code;
2155 p1_a12 := ddx_complete_rec.date_registration_placed;
2156 p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.user_status_id);
2157 p1_a14 := ddx_complete_rec.last_reg_status_date;
2158 p1_a15 := ddx_complete_rec.reg_source_type_code;
2159 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.registration_source_id);
2160 p1_a17 := ddx_complete_rec.confirmation_code;
2161 p1_a18 := ddx_complete_rec.source_code;
2162 p1_a19 := rosetta_g_miss_num_map(ddx_complete_rec.registration_group_id);
2163 p1_a20 := rosetta_g_miss_num_map(ddx_complete_rec.registrant_party_id);
2164 p1_a21 := rosetta_g_miss_num_map(ddx_complete_rec.registrant_contact_id);
2165 p1_a22 := rosetta_g_miss_num_map(ddx_complete_rec.registrant_account_id);
2166 p1_a23 := rosetta_g_miss_num_map(ddx_complete_rec.attendant_party_id);
2167 p1_a24 := rosetta_g_miss_num_map(ddx_complete_rec.attendant_contact_id);
2168 p1_a25 := rosetta_g_miss_num_map(ddx_complete_rec.attendant_account_id);
2169 p1_a26 := rosetta_g_miss_num_map(ddx_complete_rec.original_registrant_contact_id);
2170 p1_a27 := ddx_complete_rec.prospect_flag;
2171 p1_a28 := ddx_complete_rec.attended_flag;
2172 p1_a29 := ddx_complete_rec.confirmed_flag;
2173 p1_a30 := ddx_complete_rec.evaluated_flag;
2174 p1_a31 := ddx_complete_rec.waitlisted_flag;
2175 p1_a32 := ddx_complete_rec.attendance_result_code;
2176 p1_a33 := rosetta_g_miss_num_map(ddx_complete_rec.waitlisted_priority);
2177 p1_a34 := rosetta_g_miss_num_map(ddx_complete_rec.target_list_id);
2178 p1_a35 := rosetta_g_miss_num_map(ddx_complete_rec.inbound_media_id);
2179 p1_a36 := rosetta_g_miss_num_map(ddx_complete_rec.inbound_channel_id);
2180 p1_a37 := ddx_complete_rec.cancellation_code;
2181 p1_a38 := ddx_complete_rec.cancellation_reason_code;
2182 p1_a39 := ddx_complete_rec.attendance_failure_reason;
2183 p1_a40 := ddx_complete_rec.attendant_language;
2184 p1_a41 := rosetta_g_miss_num_map(ddx_complete_rec.salesrep_id);
2185 p1_a42 := rosetta_g_miss_num_map(ddx_complete_rec.order_header_id);
2186 p1_a43 := rosetta_g_miss_num_map(ddx_complete_rec.order_line_id);
2187 p1_a44 := ddx_complete_rec.description;
2188 p1_a45 := ddx_complete_rec.max_attendee_override_flag;
2189 p1_a46 := ddx_complete_rec.invite_only_override_flag;
2190 p1_a47 := ddx_complete_rec.payment_status_code;
2191 p1_a48 := ddx_complete_rec.auto_register_flag;
2192 p1_a49 := ddx_complete_rec.attribute_category;
2193 p1_a50 := ddx_complete_rec.attribute1;
2194 p1_a51 := ddx_complete_rec.attribute2;
2195 p1_a52 := ddx_complete_rec.attribute3;
2196 p1_a53 := ddx_complete_rec.attribute4;
2197 p1_a54 := ddx_complete_rec.attribute5;
2198 p1_a55 := ddx_complete_rec.attribute6;
2199 p1_a56 := ddx_complete_rec.attribute7;
2200 p1_a57 := ddx_complete_rec.attribute8;
2201 p1_a58 := ddx_complete_rec.attribute9;
2202 p1_a59 := ddx_complete_rec.attribute10;
2203 p1_a60 := ddx_complete_rec.attribute11;
2204 p1_a61 := ddx_complete_rec.attribute12;
2205 p1_a62 := ddx_complete_rec.attribute13;
2206 p1_a63 := ddx_complete_rec.attribute14;
2207 p1_a64 := ddx_complete_rec.attribute15;
2208 p1_a65 := ddx_complete_rec.attendee_role_type;
2209 p1_a66 := ddx_complete_rec.notification_type;
2210 p1_a67 := ddx_complete_rec.last_notified_time;
2211 p1_a68 := ddx_complete_rec.event_join_time;
2212 p1_a69 := ddx_complete_rec.event_exit_time;
2213 p1_a70 := ddx_complete_rec.meeting_encryption_key_code;
2214 end;
2215
2216 end ams_evtregs_pvt_w;