[Home] [Help]
PACKAGE BODY: APPS.AMS_EVENTOFFER_PVT_W_NEW
Source
1 package body ams_eventoffer_pvt_w_new as
2 /* $Header: amsaevob.pls 120.0 2005/08/24 12:06 sikalyan noship $ */
3 procedure create_event_offer(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p4_a0 NUMBER
8 , p4_a1 DATE
9 , p4_a2 NUMBER
10 , p4_a3 DATE
11 , p4_a4 NUMBER
12 , p4_a5 NUMBER
13 , p4_a6 NUMBER
14 , p4_a7 NUMBER
15 , p4_a8 NUMBER
16 , p4_a9 VARCHAR2
17 , p4_a10 VARCHAR2
18 , p4_a11 VARCHAR2
19 , p4_a12 VARCHAR2
20 , p4_a13 NUMBER
21 , p4_a14 DATE
22 , p4_a15 VARCHAR2
23 , p4_a16 VARCHAR2
24 , p4_a17 NUMBER
25 , p4_a18 VARCHAR2
26 , p4_a19 VARCHAR2
27 , p4_a20 VARCHAR2
28 , p4_a21 NUMBER
29 , p4_a22 VARCHAR2
30 , p4_a23 VARCHAR2
31 , p4_a24 VARCHAR2
32 , p4_a25 VARCHAR2
33 , p4_a26 VARCHAR2
34 , p4_a27 VARCHAR2
35 , p4_a28 VARCHAR2
36 , p4_a29 VARCHAR2
37 , p4_a30 VARCHAR2
38 , p4_a31 VARCHAR2
39 , p4_a32 VARCHAR2
40 , p4_a33 VARCHAR2
41 , p4_a34 VARCHAR2
42 , p4_a35 NUMBER
43 , p4_a36 NUMBER
44 , p4_a37 VARCHAR2
45 , p4_a38 DATE
46 , p4_a39 DATE
47 , p4_a40 DATE
48 , p4_a41 DATE
49 , p4_a42 DATE
50 , p4_a43 DATE
51 , p4_a44 DATE
52 , p4_a45 DATE
53 , p4_a46 NUMBER
54 , p4_a47 NUMBER
55 , p4_a48 NUMBER
56 , p4_a49 NUMBER
57 , p4_a50 NUMBER
58 , p4_a51 DATE
59 , p4_a52 NUMBER
60 , p4_a53 VARCHAR2
61 , p4_a54 NUMBER
62 , p4_a55 NUMBER
63 , p4_a56 NUMBER
64 , p4_a57 NUMBER
65 , p4_a58 VARCHAR2
66 , p4_a59 VARCHAR2
67 , p4_a60 NUMBER
68 , p4_a61 VARCHAR2
69 , p4_a62 NUMBER
70 , p4_a63 NUMBER
71 , p4_a64 NUMBER
72 , p4_a65 NUMBER
73 , p4_a66 VARCHAR2
74 , p4_a67 NUMBER
75 , p4_a68 VARCHAR2
76 , p4_a69 NUMBER
77 , p4_a70 NUMBER
78 , p4_a71 VARCHAR2
79 , p4_a72 VARCHAR2
80 , p4_a73 VARCHAR2
81 , p4_a74 VARCHAR2
82 , p4_a75 VARCHAR2
83 , p4_a76 NUMBER
84 , p4_a77 NUMBER
85 , p4_a78 VARCHAR2
86 , p4_a79 VARCHAR2
87 , p4_a80 VARCHAR2
88 , p4_a81 NUMBER
89 , p4_a82 NUMBER
90 , p4_a83 VARCHAR2
91 , p4_a84 NUMBER
92 , p4_a85 VARCHAR2
93 , p4_a86 VARCHAR2
94 , p4_a87 VARCHAR2
95 , p4_a88 VARCHAR2
96 , p4_a89 VARCHAR2
97 , p4_a90 VARCHAR2
98 , p4_a91 VARCHAR2
99 , p4_a92 VARCHAR2
100 , p4_a93 VARCHAR2
101 , p4_a94 VARCHAR2
102 , p4_a95 VARCHAR2
103 , p4_a96 VARCHAR2
104 , p4_a97 VARCHAR2
105 , p4_a98 VARCHAR2
106 , p4_a99 VARCHAR2
107 , p4_a100 VARCHAR2
108 , p4_a101 VARCHAR2
109 , p4_a102 VARCHAR2
110 , p4_a103 VARCHAR2
111 , p4_a104 VARCHAR2
112 , p4_a105 NUMBER
113 , p4_a106 VARCHAR2
114 , p4_a107 NUMBER
115 , p4_a108 VARCHAR2
116 , p4_a109 VARCHAR2
117 , p4_a110 VARCHAR2
118 , p4_a111 VARCHAR2
119 , p4_a112 NUMBER
120 , p4_a113 VARCHAR2
121 , p4_a114 NUMBER
122 , p4_a115 VARCHAR2
123 , p4_a116 VARCHAR2
124 , p4_a117 VARCHAR2
125 , p4_a118 NUMBER
126 , p4_a119 VARCHAR2
127 , p4_a120 VARCHAR2
128 , p4_a121 VARCHAR2
129 , p4_a122 VARCHAR2
130 , p4_a123 VARCHAR2
131 , p4_a124 VARCHAR2
132 , p4_a125 DATE
133 , p4_a126 DATE
134 , p4_a127 NUMBER
135 , p4_a128 NUMBER
136 , p4_a129 VARCHAR2
137 , p4_a130 VARCHAR2
138 , p4_a131 VARCHAR2
139 , p4_a132 VARCHAR2
140 , p4_a133 VARCHAR2
141 , p4_a134 VARCHAR2
142 , p4_a135 VARCHAR2
143 , p4_a136 NUMBER
144 , p4_a137 VARCHAR2
145 , x_return_status out nocopy VARCHAR2
146 , x_msg_count out nocopy NUMBER
147 , x_msg_data out nocopy VARCHAR2
148 , x_evo_id out nocopy NUMBER
149 )
150
151 as
152 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
153 ddindx binary_integer; indx binary_integer;
154 begin
155
156 -- copy data to the local IN or IN-OUT args, if any
157
158
159
160
161 ddp_evo_rec.event_offer_id := p4_a0;
162 ddp_evo_rec.last_update_date := p4_a1;
163 ddp_evo_rec.last_updated_by := p4_a2;
164 ddp_evo_rec.creation_date := p4_a3;
165 ddp_evo_rec.created_by := p4_a4;
166 ddp_evo_rec.last_update_login := p4_a5;
167 ddp_evo_rec.object_version_number := p4_a6;
168 ddp_evo_rec.application_id := p4_a7;
169 ddp_evo_rec.event_header_id := p4_a8;
170 ddp_evo_rec.private_flag := p4_a9;
171 ddp_evo_rec.active_flag := p4_a10;
172 ddp_evo_rec.source_code := p4_a11;
173 ddp_evo_rec.event_level := p4_a12;
174 ddp_evo_rec.user_status_id := p4_a13;
175 ddp_evo_rec.last_status_date := p4_a14;
176 ddp_evo_rec.system_status_code := p4_a15;
177 ddp_evo_rec.event_type_code := p4_a16;
178 ddp_evo_rec.event_delivery_method_id := p4_a17;
179 ddp_evo_rec.event_delivery_method_code := p4_a18;
180 ddp_evo_rec.event_required_flag := p4_a19;
181 ddp_evo_rec.event_language_code := p4_a20;
182 ddp_evo_rec.event_location_id := p4_a21;
183 ddp_evo_rec.city := p4_a22;
184 ddp_evo_rec.state := p4_a23;
185 ddp_evo_rec.province := p4_a24;
186 ddp_evo_rec.country := p4_a25;
187 ddp_evo_rec.overflow_flag := p4_a26;
188 ddp_evo_rec.partner_flag := p4_a27;
189 ddp_evo_rec.event_standalone_flag := p4_a28;
190 ddp_evo_rec.reg_frozen_flag := p4_a29;
191 ddp_evo_rec.reg_required_flag := p4_a30;
192 ddp_evo_rec.reg_charge_flag := p4_a31;
193 ddp_evo_rec.reg_invited_only_flag := p4_a32;
194 ddp_evo_rec.reg_waitlist_allowed_flag := p4_a33;
195 ddp_evo_rec.reg_overbook_allowed_flag := p4_a34;
196 ddp_evo_rec.parent_event_offer_id := p4_a35;
197 ddp_evo_rec.event_duration := p4_a36;
198 ddp_evo_rec.event_duration_uom_code := p4_a37;
199 ddp_evo_rec.event_start_date := p4_a38;
200 ddp_evo_rec.event_start_date_time := p4_a39;
201 ddp_evo_rec.event_end_date := p4_a40;
202 ddp_evo_rec.event_end_date_time := p4_a41;
203 ddp_evo_rec.reg_start_date := p4_a42;
204 ddp_evo_rec.reg_start_time := p4_a43;
205 ddp_evo_rec.reg_end_date := p4_a44;
206 ddp_evo_rec.reg_end_time := p4_a45;
207 ddp_evo_rec.reg_maximum_capacity := p4_a46;
208 ddp_evo_rec.reg_overbook_pct := p4_a47;
209 ddp_evo_rec.reg_effective_capacity := p4_a48;
210 ddp_evo_rec.reg_waitlist_pct := p4_a49;
211 ddp_evo_rec.reg_minimum_capacity := p4_a50;
212 ddp_evo_rec.reg_minimum_req_by_date := p4_a51;
213 ddp_evo_rec.inventory_item_id := p4_a52;
214 ddp_evo_rec.inventory_item := p4_a53;
215 ddp_evo_rec.organization_id := p4_a54;
216 ddp_evo_rec.pricelist_header_id := p4_a55;
217 ddp_evo_rec.pricelist_line_id := p4_a56;
218 ddp_evo_rec.org_id := p4_a57;
219 ddp_evo_rec.waitlist_action_type_code := p4_a58;
220 ddp_evo_rec.stream_type_code := p4_a59;
221 ddp_evo_rec.owner_user_id := p4_a60;
222 ddp_evo_rec.event_full_flag := p4_a61;
223 ddp_evo_rec.forecasted_revenue := p4_a62;
224 ddp_evo_rec.actual_revenue := p4_a63;
225 ddp_evo_rec.forecasted_cost := p4_a64;
226 ddp_evo_rec.actual_cost := p4_a65;
227 ddp_evo_rec.fund_source_type_code := p4_a66;
228 ddp_evo_rec.fund_source_id := p4_a67;
229 ddp_evo_rec.cert_credit_type_code := p4_a68;
230 ddp_evo_rec.certification_credits := p4_a69;
231 ddp_evo_rec.coordinator_id := p4_a70;
232 ddp_evo_rec.priority_type_code := p4_a71;
233 ddp_evo_rec.cancellation_reason_code := p4_a72;
234 ddp_evo_rec.auto_register_flag := p4_a73;
235 ddp_evo_rec.email := p4_a74;
236 ddp_evo_rec.phone := p4_a75;
237 ddp_evo_rec.fund_amount_tc := p4_a76;
238 ddp_evo_rec.fund_amount_fc := p4_a77;
239 ddp_evo_rec.currency_code_tc := p4_a78;
240 ddp_evo_rec.currency_code_fc := p4_a79;
241 ddp_evo_rec.url := p4_a80;
242 ddp_evo_rec.timezone_id := p4_a81;
243 ddp_evo_rec.event_venue_id := p4_a82;
244 ddp_evo_rec.pricelist_header_currency_code := p4_a83;
245 ddp_evo_rec.pricelist_list_price := p4_a84;
246 ddp_evo_rec.inbound_script_name := p4_a85;
247 ddp_evo_rec.attribute_category := p4_a86;
248 ddp_evo_rec.attribute1 := p4_a87;
249 ddp_evo_rec.attribute2 := p4_a88;
250 ddp_evo_rec.attribute3 := p4_a89;
251 ddp_evo_rec.attribute4 := p4_a90;
252 ddp_evo_rec.attribute5 := p4_a91;
253 ddp_evo_rec.attribute6 := p4_a92;
254 ddp_evo_rec.attribute7 := p4_a93;
255 ddp_evo_rec.attribute8 := p4_a94;
256 ddp_evo_rec.attribute9 := p4_a95;
257 ddp_evo_rec.attribute10 := p4_a96;
258 ddp_evo_rec.attribute11 := p4_a97;
259 ddp_evo_rec.attribute12 := p4_a98;
260 ddp_evo_rec.attribute13 := p4_a99;
261 ddp_evo_rec.attribute14 := p4_a100;
262 ddp_evo_rec.attribute15 := p4_a101;
263 ddp_evo_rec.event_offer_name := p4_a102;
264 ddp_evo_rec.event_mktg_message := p4_a103;
265 ddp_evo_rec.description := p4_a104;
266 ddp_evo_rec.custom_setup_id := p4_a105;
267 ddp_evo_rec.country_code := p4_a106;
268 ddp_evo_rec.business_unit_id := p4_a107;
269 ddp_evo_rec.event_calendar := p4_a108;
270 ddp_evo_rec.start_period_name := p4_a109;
271 ddp_evo_rec.end_period_name := p4_a110;
272 ddp_evo_rec.global_flag := p4_a111;
273 ddp_evo_rec.task_id := p4_a112;
274 ddp_evo_rec.parent_type := p4_a113;
275 ddp_evo_rec.parent_id := p4_a114;
276 ddp_evo_rec.create_attendant_lead_flag := p4_a115;
277 ddp_evo_rec.create_registrant_lead_flag := p4_a116;
278 ddp_evo_rec.event_object_type := p4_a117;
279 ddp_evo_rec.reg_timezone_id := p4_a118;
280 ddp_evo_rec.event_password := p4_a119;
281 ddp_evo_rec.record_event_flag := p4_a120;
282 ddp_evo_rec.allow_register_in_middle_flag := p4_a121;
283 ddp_evo_rec.publish_attendees_flag := p4_a122;
284 ddp_evo_rec.direct_join_flag := p4_a123;
285 ddp_evo_rec.event_notification_method := p4_a124;
286 ddp_evo_rec.actual_start_time := p4_a125;
287 ddp_evo_rec.actual_end_time := p4_a126;
288 ddp_evo_rec.server_id := p4_a127;
289 ddp_evo_rec.owner_fnd_user_id := p4_a128;
290 ddp_evo_rec.meeting_dial_in_info := p4_a129;
291 ddp_evo_rec.meeting_email_subject := p4_a130;
292 ddp_evo_rec.meeting_schedule_type := p4_a131;
293 ddp_evo_rec.meeting_status := p4_a132;
294 ddp_evo_rec.meeting_misc_info := p4_a133;
295 ddp_evo_rec.publish_flag := p4_a134;
296 ddp_evo_rec.meeting_encryption_key_code := p4_a135;
297 ddp_evo_rec.number_of_attendees := p4_a136;
298 ddp_evo_rec.event_purpose_code := p4_a137;
299
300
301
302
303
304 -- here's the delegated call to the old PL/SQL routine
305 ams_eventoffer_pvt.create_event_offer(p_api_version,
306 p_init_msg_list,
307 p_commit,
308 p_validation_level,
309 ddp_evo_rec,
310 x_return_status,
311 x_msg_count,
312 x_msg_data,
313 x_evo_id);
314
315 -- copy data back from the local variables to OUT or IN-OUT args, if any
316
317
318
319
320
321
322
323
324 end;
325
326 procedure update_event_offer(p_api_version NUMBER
327 , p_init_msg_list VARCHAR2
328 , p_commit VARCHAR2
329 , p_validation_level NUMBER
330 , p4_a0 NUMBER
331 , p4_a1 DATE
332 , p4_a2 NUMBER
333 , p4_a3 DATE
334 , p4_a4 NUMBER
335 , p4_a5 NUMBER
336 , p4_a6 NUMBER
337 , p4_a7 NUMBER
338 , p4_a8 NUMBER
339 , p4_a9 VARCHAR2
340 , p4_a10 VARCHAR2
341 , p4_a11 VARCHAR2
342 , p4_a12 VARCHAR2
343 , p4_a13 NUMBER
344 , p4_a14 DATE
345 , p4_a15 VARCHAR2
346 , p4_a16 VARCHAR2
347 , p4_a17 NUMBER
348 , p4_a18 VARCHAR2
349 , p4_a19 VARCHAR2
350 , p4_a20 VARCHAR2
351 , p4_a21 NUMBER
352 , p4_a22 VARCHAR2
353 , p4_a23 VARCHAR2
354 , p4_a24 VARCHAR2
355 , p4_a25 VARCHAR2
356 , p4_a26 VARCHAR2
357 , p4_a27 VARCHAR2
358 , p4_a28 VARCHAR2
359 , p4_a29 VARCHAR2
360 , p4_a30 VARCHAR2
361 , p4_a31 VARCHAR2
362 , p4_a32 VARCHAR2
363 , p4_a33 VARCHAR2
364 , p4_a34 VARCHAR2
365 , p4_a35 NUMBER
366 , p4_a36 NUMBER
367 , p4_a37 VARCHAR2
368 , p4_a38 DATE
369 , p4_a39 DATE
370 , p4_a40 DATE
371 , p4_a41 DATE
372 , p4_a42 DATE
373 , p4_a43 DATE
374 , p4_a44 DATE
375 , p4_a45 DATE
376 , p4_a46 NUMBER
377 , p4_a47 NUMBER
378 , p4_a48 NUMBER
379 , p4_a49 NUMBER
380 , p4_a50 NUMBER
381 , p4_a51 DATE
382 , p4_a52 NUMBER
383 , p4_a53 VARCHAR2
384 , p4_a54 NUMBER
385 , p4_a55 NUMBER
386 , p4_a56 NUMBER
387 , p4_a57 NUMBER
388 , p4_a58 VARCHAR2
389 , p4_a59 VARCHAR2
390 , p4_a60 NUMBER
391 , p4_a61 VARCHAR2
392 , p4_a62 NUMBER
393 , p4_a63 NUMBER
394 , p4_a64 NUMBER
395 , p4_a65 NUMBER
396 , p4_a66 VARCHAR2
397 , p4_a67 NUMBER
398 , p4_a68 VARCHAR2
399 , p4_a69 NUMBER
400 , p4_a70 NUMBER
401 , p4_a71 VARCHAR2
402 , p4_a72 VARCHAR2
403 , p4_a73 VARCHAR2
404 , p4_a74 VARCHAR2
405 , p4_a75 VARCHAR2
406 , p4_a76 NUMBER
407 , p4_a77 NUMBER
408 , p4_a78 VARCHAR2
409 , p4_a79 VARCHAR2
410 , p4_a80 VARCHAR2
411 , p4_a81 NUMBER
412 , p4_a82 NUMBER
413 , p4_a83 VARCHAR2
414 , p4_a84 NUMBER
415 , p4_a85 VARCHAR2
416 , p4_a86 VARCHAR2
417 , p4_a87 VARCHAR2
418 , p4_a88 VARCHAR2
419 , p4_a89 VARCHAR2
420 , p4_a90 VARCHAR2
421 , p4_a91 VARCHAR2
422 , p4_a92 VARCHAR2
423 , p4_a93 VARCHAR2
424 , p4_a94 VARCHAR2
425 , p4_a95 VARCHAR2
426 , p4_a96 VARCHAR2
427 , p4_a97 VARCHAR2
428 , p4_a98 VARCHAR2
429 , p4_a99 VARCHAR2
430 , p4_a100 VARCHAR2
431 , p4_a101 VARCHAR2
432 , p4_a102 VARCHAR2
433 , p4_a103 VARCHAR2
434 , p4_a104 VARCHAR2
435 , p4_a105 NUMBER
436 , p4_a106 VARCHAR2
437 , p4_a107 NUMBER
438 , p4_a108 VARCHAR2
439 , p4_a109 VARCHAR2
440 , p4_a110 VARCHAR2
441 , p4_a111 VARCHAR2
442 , p4_a112 NUMBER
443 , p4_a113 VARCHAR2
444 , p4_a114 NUMBER
445 , p4_a115 VARCHAR2
446 , p4_a116 VARCHAR2
447 , p4_a117 VARCHAR2
448 , p4_a118 NUMBER
449 , p4_a119 VARCHAR2
450 , p4_a120 VARCHAR2
451 , p4_a121 VARCHAR2
452 , p4_a122 VARCHAR2
453 , p4_a123 VARCHAR2
454 , p4_a124 VARCHAR2
455 , p4_a125 DATE
456 , p4_a126 DATE
457 , p4_a127 NUMBER
458 , p4_a128 NUMBER
459 , p4_a129 VARCHAR2
460 , p4_a130 VARCHAR2
461 , p4_a131 VARCHAR2
462 , p4_a132 VARCHAR2
463 , p4_a133 VARCHAR2
464 , p4_a134 VARCHAR2
465 , p4_a135 VARCHAR2
466 , p4_a136 NUMBER
467 , p4_a137 VARCHAR2
468 , x_return_status out nocopy VARCHAR2
469 , x_msg_count out nocopy NUMBER
470 , x_msg_data out nocopy VARCHAR2
471 )
472
473 as
474 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
475 ddindx binary_integer; indx binary_integer;
476 begin
477
478 -- copy data to the local IN or IN-OUT args, if any
479
480
481
482
483 ddp_evo_rec.event_offer_id := p4_a0;
484 ddp_evo_rec.last_update_date := p4_a1;
485 ddp_evo_rec.last_updated_by := p4_a2;
486 ddp_evo_rec.creation_date := p4_a3;
487 ddp_evo_rec.created_by := p4_a4;
488 ddp_evo_rec.last_update_login := p4_a5;
489 ddp_evo_rec.object_version_number := p4_a6;
490 ddp_evo_rec.application_id := p4_a7;
491 ddp_evo_rec.event_header_id := p4_a8;
492 ddp_evo_rec.private_flag := p4_a9;
493 ddp_evo_rec.active_flag := p4_a10;
494 ddp_evo_rec.source_code := p4_a11;
495 ddp_evo_rec.event_level := p4_a12;
496 ddp_evo_rec.user_status_id := p4_a13;
497 ddp_evo_rec.last_status_date := p4_a14;
498 ddp_evo_rec.system_status_code := p4_a15;
499 ddp_evo_rec.event_type_code := p4_a16;
500 ddp_evo_rec.event_delivery_method_id := p4_a17;
501 ddp_evo_rec.event_delivery_method_code := p4_a18;
502 ddp_evo_rec.event_required_flag := p4_a19;
503 ddp_evo_rec.event_language_code := p4_a20;
504 ddp_evo_rec.event_location_id := p4_a21;
505 ddp_evo_rec.city := p4_a22;
506 ddp_evo_rec.state := p4_a23;
507 ddp_evo_rec.province := p4_a24;
508 ddp_evo_rec.country := p4_a25;
509 ddp_evo_rec.overflow_flag := p4_a26;
510 ddp_evo_rec.partner_flag := p4_a27;
511 ddp_evo_rec.event_standalone_flag := p4_a28;
512 ddp_evo_rec.reg_frozen_flag := p4_a29;
513 ddp_evo_rec.reg_required_flag := p4_a30;
514 ddp_evo_rec.reg_charge_flag := p4_a31;
515 ddp_evo_rec.reg_invited_only_flag := p4_a32;
516 ddp_evo_rec.reg_waitlist_allowed_flag := p4_a33;
517 ddp_evo_rec.reg_overbook_allowed_flag := p4_a34;
518 ddp_evo_rec.parent_event_offer_id := p4_a35;
519 ddp_evo_rec.event_duration := p4_a36;
520 ddp_evo_rec.event_duration_uom_code := p4_a37;
521 ddp_evo_rec.event_start_date := p4_a38;
522 ddp_evo_rec.event_start_date_time := p4_a39;
523 ddp_evo_rec.event_end_date := p4_a40;
524 ddp_evo_rec.event_end_date_time := p4_a41;
525 ddp_evo_rec.reg_start_date := p4_a42;
526 ddp_evo_rec.reg_start_time := p4_a43;
527 ddp_evo_rec.reg_end_date := p4_a44;
528 ddp_evo_rec.reg_end_time := p4_a45;
529 ddp_evo_rec.reg_maximum_capacity := p4_a46;
530 ddp_evo_rec.reg_overbook_pct := p4_a47;
531 ddp_evo_rec.reg_effective_capacity := p4_a48;
532 ddp_evo_rec.reg_waitlist_pct := p4_a49;
533 ddp_evo_rec.reg_minimum_capacity := p4_a50;
534 ddp_evo_rec.reg_minimum_req_by_date := p4_a51;
535 ddp_evo_rec.inventory_item_id := p4_a52;
536 ddp_evo_rec.inventory_item := p4_a53;
537 ddp_evo_rec.organization_id := p4_a54;
538 ddp_evo_rec.pricelist_header_id := p4_a55;
539 ddp_evo_rec.pricelist_line_id := p4_a56;
540 ddp_evo_rec.org_id := p4_a57;
541 ddp_evo_rec.waitlist_action_type_code := p4_a58;
542 ddp_evo_rec.stream_type_code := p4_a59;
543 ddp_evo_rec.owner_user_id := p4_a60;
544 ddp_evo_rec.event_full_flag := p4_a61;
545 ddp_evo_rec.forecasted_revenue := p4_a62;
546 ddp_evo_rec.actual_revenue := p4_a63;
547 ddp_evo_rec.forecasted_cost := p4_a64;
548 ddp_evo_rec.actual_cost := p4_a65;
549 ddp_evo_rec.fund_source_type_code := p4_a66;
550 ddp_evo_rec.fund_source_id := p4_a67;
551 ddp_evo_rec.cert_credit_type_code := p4_a68;
552 ddp_evo_rec.certification_credits := p4_a69;
553 ddp_evo_rec.coordinator_id := p4_a70;
554 ddp_evo_rec.priority_type_code := p4_a71;
555 ddp_evo_rec.cancellation_reason_code := p4_a72;
556 ddp_evo_rec.auto_register_flag := p4_a73;
557 ddp_evo_rec.email := p4_a74;
558 ddp_evo_rec.phone := p4_a75;
559 ddp_evo_rec.fund_amount_tc := p4_a76;
560 ddp_evo_rec.fund_amount_fc := p4_a77;
561 ddp_evo_rec.currency_code_tc := p4_a78;
562 ddp_evo_rec.currency_code_fc := p4_a79;
563 ddp_evo_rec.url := p4_a80;
564 ddp_evo_rec.timezone_id := p4_a81;
565 ddp_evo_rec.event_venue_id := p4_a82;
566 ddp_evo_rec.pricelist_header_currency_code := p4_a83;
567 ddp_evo_rec.pricelist_list_price := p4_a84;
568 ddp_evo_rec.inbound_script_name := p4_a85;
569 ddp_evo_rec.attribute_category := p4_a86;
570 ddp_evo_rec.attribute1 := p4_a87;
571 ddp_evo_rec.attribute2 := p4_a88;
572 ddp_evo_rec.attribute3 := p4_a89;
573 ddp_evo_rec.attribute4 := p4_a90;
574 ddp_evo_rec.attribute5 := p4_a91;
575 ddp_evo_rec.attribute6 := p4_a92;
576 ddp_evo_rec.attribute7 := p4_a93;
577 ddp_evo_rec.attribute8 := p4_a94;
578 ddp_evo_rec.attribute9 := p4_a95;
579 ddp_evo_rec.attribute10 := p4_a96;
580 ddp_evo_rec.attribute11 := p4_a97;
581 ddp_evo_rec.attribute12 := p4_a98;
582 ddp_evo_rec.attribute13 := p4_a99;
583 ddp_evo_rec.attribute14 := p4_a100;
584 ddp_evo_rec.attribute15 := p4_a101;
585 ddp_evo_rec.event_offer_name := p4_a102;
586 ddp_evo_rec.event_mktg_message := p4_a103;
587 ddp_evo_rec.description := p4_a104;
588 ddp_evo_rec.custom_setup_id := p4_a105;
589 ddp_evo_rec.country_code := p4_a106;
590 ddp_evo_rec.business_unit_id := p4_a107;
591 ddp_evo_rec.event_calendar := p4_a108;
592 ddp_evo_rec.start_period_name := p4_a109;
593 ddp_evo_rec.end_period_name := p4_a110;
594 ddp_evo_rec.global_flag := p4_a111;
595 ddp_evo_rec.task_id := p4_a112;
596 ddp_evo_rec.parent_type := p4_a113;
597 ddp_evo_rec.parent_id := p4_a114;
598 ddp_evo_rec.create_attendant_lead_flag := p4_a115;
599 ddp_evo_rec.create_registrant_lead_flag := p4_a116;
600 ddp_evo_rec.event_object_type := p4_a117;
601 ddp_evo_rec.reg_timezone_id := p4_a118;
602 ddp_evo_rec.event_password := p4_a119;
603 ddp_evo_rec.record_event_flag := p4_a120;
604 ddp_evo_rec.allow_register_in_middle_flag := p4_a121;
605 ddp_evo_rec.publish_attendees_flag := p4_a122;
606 ddp_evo_rec.direct_join_flag := p4_a123;
607 ddp_evo_rec.event_notification_method := p4_a124;
608 ddp_evo_rec.actual_start_time := p4_a125;
609 ddp_evo_rec.actual_end_time := p4_a126;
610 ddp_evo_rec.server_id := p4_a127;
611 ddp_evo_rec.owner_fnd_user_id := p4_a128;
612 ddp_evo_rec.meeting_dial_in_info := p4_a129;
613 ddp_evo_rec.meeting_email_subject := p4_a130;
614 ddp_evo_rec.meeting_schedule_type := p4_a131;
615 ddp_evo_rec.meeting_status := p4_a132;
616 ddp_evo_rec.meeting_misc_info := p4_a133;
617 ddp_evo_rec.publish_flag := p4_a134;
618 ddp_evo_rec.meeting_encryption_key_code := p4_a135;
619 ddp_evo_rec.number_of_attendees := p4_a136;
620 ddp_evo_rec.event_purpose_code := p4_a137;
621
622
623
624
625 -- here's the delegated call to the old PL/SQL routine
626 ams_eventoffer_pvt.update_event_offer(p_api_version,
627 p_init_msg_list,
628 p_commit,
629 p_validation_level,
630 ddp_evo_rec,
631 x_return_status,
632 x_msg_count,
633 x_msg_data);
634
635 -- copy data back from the local variables to OUT or IN-OUT args, if any
636
637
638
639
640
641
642
643 end;
644
645 procedure validate_event_offer(p_api_version NUMBER
646 , p_init_msg_list VARCHAR2
647 , p_validation_level NUMBER
648 , p3_a0 NUMBER
649 , p3_a1 DATE
650 , p3_a2 NUMBER
651 , p3_a3 DATE
652 , p3_a4 NUMBER
653 , p3_a5 NUMBER
654 , p3_a6 NUMBER
655 , p3_a7 NUMBER
656 , p3_a8 NUMBER
657 , p3_a9 VARCHAR2
658 , p3_a10 VARCHAR2
659 , p3_a11 VARCHAR2
660 , p3_a12 VARCHAR2
661 , p3_a13 NUMBER
662 , p3_a14 DATE
663 , p3_a15 VARCHAR2
664 , p3_a16 VARCHAR2
665 , p3_a17 NUMBER
666 , p3_a18 VARCHAR2
667 , p3_a19 VARCHAR2
668 , p3_a20 VARCHAR2
669 , p3_a21 NUMBER
670 , p3_a22 VARCHAR2
671 , p3_a23 VARCHAR2
672 , p3_a24 VARCHAR2
673 , p3_a25 VARCHAR2
674 , p3_a26 VARCHAR2
675 , p3_a27 VARCHAR2
676 , p3_a28 VARCHAR2
677 , p3_a29 VARCHAR2
678 , p3_a30 VARCHAR2
679 , p3_a31 VARCHAR2
680 , p3_a32 VARCHAR2
681 , p3_a33 VARCHAR2
682 , p3_a34 VARCHAR2
683 , p3_a35 NUMBER
684 , p3_a36 NUMBER
685 , p3_a37 VARCHAR2
686 , p3_a38 DATE
687 , p3_a39 DATE
688 , p3_a40 DATE
689 , p3_a41 DATE
690 , p3_a42 DATE
691 , p3_a43 DATE
692 , p3_a44 DATE
693 , p3_a45 DATE
694 , p3_a46 NUMBER
695 , p3_a47 NUMBER
696 , p3_a48 NUMBER
697 , p3_a49 NUMBER
698 , p3_a50 NUMBER
699 , p3_a51 DATE
700 , p3_a52 NUMBER
701 , p3_a53 VARCHAR2
702 , p3_a54 NUMBER
703 , p3_a55 NUMBER
704 , p3_a56 NUMBER
705 , p3_a57 NUMBER
706 , p3_a58 VARCHAR2
707 , p3_a59 VARCHAR2
708 , p3_a60 NUMBER
709 , p3_a61 VARCHAR2
710 , p3_a62 NUMBER
711 , p3_a63 NUMBER
712 , p3_a64 NUMBER
713 , p3_a65 NUMBER
714 , p3_a66 VARCHAR2
715 , p3_a67 NUMBER
716 , p3_a68 VARCHAR2
717 , p3_a69 NUMBER
718 , p3_a70 NUMBER
719 , p3_a71 VARCHAR2
720 , p3_a72 VARCHAR2
721 , p3_a73 VARCHAR2
722 , p3_a74 VARCHAR2
723 , p3_a75 VARCHAR2
724 , p3_a76 NUMBER
725 , p3_a77 NUMBER
726 , p3_a78 VARCHAR2
727 , p3_a79 VARCHAR2
728 , p3_a80 VARCHAR2
729 , p3_a81 NUMBER
730 , p3_a82 NUMBER
731 , p3_a83 VARCHAR2
732 , p3_a84 NUMBER
733 , p3_a85 VARCHAR2
734 , p3_a86 VARCHAR2
735 , p3_a87 VARCHAR2
736 , p3_a88 VARCHAR2
737 , p3_a89 VARCHAR2
738 , p3_a90 VARCHAR2
739 , p3_a91 VARCHAR2
740 , p3_a92 VARCHAR2
741 , p3_a93 VARCHAR2
742 , p3_a94 VARCHAR2
743 , p3_a95 VARCHAR2
744 , p3_a96 VARCHAR2
745 , p3_a97 VARCHAR2
746 , p3_a98 VARCHAR2
747 , p3_a99 VARCHAR2
748 , p3_a100 VARCHAR2
749 , p3_a101 VARCHAR2
750 , p3_a102 VARCHAR2
751 , p3_a103 VARCHAR2
752 , p3_a104 VARCHAR2
753 , p3_a105 NUMBER
754 , p3_a106 VARCHAR2
755 , p3_a107 NUMBER
756 , p3_a108 VARCHAR2
757 , p3_a109 VARCHAR2
758 , p3_a110 VARCHAR2
759 , p3_a111 VARCHAR2
760 , p3_a112 NUMBER
761 , p3_a113 VARCHAR2
762 , p3_a114 NUMBER
763 , p3_a115 VARCHAR2
764 , p3_a116 VARCHAR2
765 , p3_a117 VARCHAR2
766 , p3_a118 NUMBER
767 , p3_a119 VARCHAR2
768 , p3_a120 VARCHAR2
769 , p3_a121 VARCHAR2
770 , p3_a122 VARCHAR2
771 , p3_a123 VARCHAR2
772 , p3_a124 VARCHAR2
773 , p3_a125 DATE
774 , p3_a126 DATE
775 , p3_a127 NUMBER
776 , p3_a128 NUMBER
777 , p3_a129 VARCHAR2
778 , p3_a130 VARCHAR2
779 , p3_a131 VARCHAR2
780 , p3_a132 VARCHAR2
781 , p3_a133 VARCHAR2
782 , p3_a134 VARCHAR2
783 , p3_a135 VARCHAR2
784 , p3_a136 NUMBER
785 , p3_a137 VARCHAR2
786 , x_return_status out nocopy VARCHAR2
787 , x_msg_count out nocopy NUMBER
788 , x_msg_data out nocopy VARCHAR2
789 )
790
791 as
792 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
793 ddindx binary_integer; indx binary_integer;
794 begin
795
796 -- copy data to the local IN or IN-OUT args, if any
797
798
799
800 ddp_evo_rec.event_offer_id := p3_a0;
801 ddp_evo_rec.last_update_date := p3_a1;
802 ddp_evo_rec.last_updated_by := p3_a2;
803 ddp_evo_rec.creation_date := p3_a3;
804 ddp_evo_rec.created_by := p3_a4;
805 ddp_evo_rec.last_update_login := p3_a5;
806 ddp_evo_rec.object_version_number := p3_a6;
807 ddp_evo_rec.application_id := p3_a7;
808 ddp_evo_rec.event_header_id := p3_a8;
809 ddp_evo_rec.private_flag := p3_a9;
810 ddp_evo_rec.active_flag := p3_a10;
811 ddp_evo_rec.source_code := p3_a11;
812 ddp_evo_rec.event_level := p3_a12;
813 ddp_evo_rec.user_status_id := p3_a13;
814 ddp_evo_rec.last_status_date := p3_a14;
815 ddp_evo_rec.system_status_code := p3_a15;
816 ddp_evo_rec.event_type_code := p3_a16;
817 ddp_evo_rec.event_delivery_method_id := p3_a17;
818 ddp_evo_rec.event_delivery_method_code := p3_a18;
819 ddp_evo_rec.event_required_flag := p3_a19;
820 ddp_evo_rec.event_language_code := p3_a20;
821 ddp_evo_rec.event_location_id := p3_a21;
822 ddp_evo_rec.city := p3_a22;
823 ddp_evo_rec.state := p3_a23;
824 ddp_evo_rec.province := p3_a24;
825 ddp_evo_rec.country := p3_a25;
826 ddp_evo_rec.overflow_flag := p3_a26;
827 ddp_evo_rec.partner_flag := p3_a27;
828 ddp_evo_rec.event_standalone_flag := p3_a28;
829 ddp_evo_rec.reg_frozen_flag := p3_a29;
830 ddp_evo_rec.reg_required_flag := p3_a30;
831 ddp_evo_rec.reg_charge_flag := p3_a31;
832 ddp_evo_rec.reg_invited_only_flag := p3_a32;
833 ddp_evo_rec.reg_waitlist_allowed_flag := p3_a33;
834 ddp_evo_rec.reg_overbook_allowed_flag := p3_a34;
835 ddp_evo_rec.parent_event_offer_id := p3_a35;
836 ddp_evo_rec.event_duration := p3_a36;
837 ddp_evo_rec.event_duration_uom_code := p3_a37;
838 ddp_evo_rec.event_start_date := p3_a38;
839 ddp_evo_rec.event_start_date_time := p3_a39;
840 ddp_evo_rec.event_end_date := p3_a40;
841 ddp_evo_rec.event_end_date_time := p3_a41;
842 ddp_evo_rec.reg_start_date := p3_a42;
843 ddp_evo_rec.reg_start_time := p3_a43;
844 ddp_evo_rec.reg_end_date := p3_a44;
845 ddp_evo_rec.reg_end_time := p3_a45;
846 ddp_evo_rec.reg_maximum_capacity := p3_a46;
847 ddp_evo_rec.reg_overbook_pct := p3_a47;
848 ddp_evo_rec.reg_effective_capacity := p3_a48;
849 ddp_evo_rec.reg_waitlist_pct := p3_a49;
850 ddp_evo_rec.reg_minimum_capacity := p3_a50;
851 ddp_evo_rec.reg_minimum_req_by_date := p3_a51;
852 ddp_evo_rec.inventory_item_id := p3_a52;
853 ddp_evo_rec.inventory_item := p3_a53;
854 ddp_evo_rec.organization_id := p3_a54;
855 ddp_evo_rec.pricelist_header_id := p3_a55;
856 ddp_evo_rec.pricelist_line_id := p3_a56;
857 ddp_evo_rec.org_id := p3_a57;
858 ddp_evo_rec.waitlist_action_type_code := p3_a58;
859 ddp_evo_rec.stream_type_code := p3_a59;
860 ddp_evo_rec.owner_user_id := p3_a60;
861 ddp_evo_rec.event_full_flag := p3_a61;
862 ddp_evo_rec.forecasted_revenue := p3_a62;
863 ddp_evo_rec.actual_revenue := p3_a63;
864 ddp_evo_rec.forecasted_cost := p3_a64;
865 ddp_evo_rec.actual_cost := p3_a65;
866 ddp_evo_rec.fund_source_type_code := p3_a66;
867 ddp_evo_rec.fund_source_id := p3_a67;
868 ddp_evo_rec.cert_credit_type_code := p3_a68;
869 ddp_evo_rec.certification_credits := p3_a69;
870 ddp_evo_rec.coordinator_id := p3_a70;
871 ddp_evo_rec.priority_type_code := p3_a71;
872 ddp_evo_rec.cancellation_reason_code := p3_a72;
873 ddp_evo_rec.auto_register_flag := p3_a73;
874 ddp_evo_rec.email := p3_a74;
875 ddp_evo_rec.phone := p3_a75;
876 ddp_evo_rec.fund_amount_tc := p3_a76;
877 ddp_evo_rec.fund_amount_fc := p3_a77;
878 ddp_evo_rec.currency_code_tc := p3_a78;
879 ddp_evo_rec.currency_code_fc := p3_a79;
880 ddp_evo_rec.url := p3_a80;
881 ddp_evo_rec.timezone_id := p3_a81;
882 ddp_evo_rec.event_venue_id := p3_a82;
883 ddp_evo_rec.pricelist_header_currency_code := p3_a83;
884 ddp_evo_rec.pricelist_list_price := p3_a84;
885 ddp_evo_rec.inbound_script_name := p3_a85;
886 ddp_evo_rec.attribute_category := p3_a86;
887 ddp_evo_rec.attribute1 := p3_a87;
888 ddp_evo_rec.attribute2 := p3_a88;
889 ddp_evo_rec.attribute3 := p3_a89;
890 ddp_evo_rec.attribute4 := p3_a90;
891 ddp_evo_rec.attribute5 := p3_a91;
892 ddp_evo_rec.attribute6 := p3_a92;
893 ddp_evo_rec.attribute7 := p3_a93;
894 ddp_evo_rec.attribute8 := p3_a94;
895 ddp_evo_rec.attribute9 := p3_a95;
896 ddp_evo_rec.attribute10 := p3_a96;
897 ddp_evo_rec.attribute11 := p3_a97;
898 ddp_evo_rec.attribute12 := p3_a98;
899 ddp_evo_rec.attribute13 := p3_a99;
900 ddp_evo_rec.attribute14 := p3_a100;
901 ddp_evo_rec.attribute15 := p3_a101;
902 ddp_evo_rec.event_offer_name := p3_a102;
903 ddp_evo_rec.event_mktg_message := p3_a103;
904 ddp_evo_rec.description := p3_a104;
905 ddp_evo_rec.custom_setup_id := p3_a105;
906 ddp_evo_rec.country_code := p3_a106;
907 ddp_evo_rec.business_unit_id := p3_a107;
908 ddp_evo_rec.event_calendar := p3_a108;
909 ddp_evo_rec.start_period_name := p3_a109;
910 ddp_evo_rec.end_period_name := p3_a110;
911 ddp_evo_rec.global_flag := p3_a111;
912 ddp_evo_rec.task_id := p3_a112;
913 ddp_evo_rec.parent_type := p3_a113;
914 ddp_evo_rec.parent_id := p3_a114;
915 ddp_evo_rec.create_attendant_lead_flag := p3_a115;
916 ddp_evo_rec.create_registrant_lead_flag := p3_a116;
917 ddp_evo_rec.event_object_type := p3_a117;
918 ddp_evo_rec.reg_timezone_id := p3_a118;
919 ddp_evo_rec.event_password := p3_a119;
920 ddp_evo_rec.record_event_flag := p3_a120;
921 ddp_evo_rec.allow_register_in_middle_flag := p3_a121;
922 ddp_evo_rec.publish_attendees_flag := p3_a122;
923 ddp_evo_rec.direct_join_flag := p3_a123;
924 ddp_evo_rec.event_notification_method := p3_a124;
925 ddp_evo_rec.actual_start_time := p3_a125;
926 ddp_evo_rec.actual_end_time := p3_a126;
927 ddp_evo_rec.server_id := p3_a127;
928 ddp_evo_rec.owner_fnd_user_id := p3_a128;
929 ddp_evo_rec.meeting_dial_in_info := p3_a129;
930 ddp_evo_rec.meeting_email_subject := p3_a130;
931 ddp_evo_rec.meeting_schedule_type := p3_a131;
932 ddp_evo_rec.meeting_status := p3_a132;
933 ddp_evo_rec.meeting_misc_info := p3_a133;
934 ddp_evo_rec.publish_flag := p3_a134;
935 ddp_evo_rec.meeting_encryption_key_code := p3_a135;
936 ddp_evo_rec.number_of_attendees := p3_a136;
937 ddp_evo_rec.event_purpose_code := p3_a137;
938
939
940
941
942 -- here's the delegated call to the old PL/SQL routine
943 ams_eventoffer_pvt.validate_event_offer(p_api_version,
944 p_init_msg_list,
945 p_validation_level,
946 ddp_evo_rec,
947 x_return_status,
948 x_msg_count,
949 x_msg_data);
950
951 -- copy data back from the local variables to OUT or IN-OUT args, if any
952
953
954
955
956
957
958 end;
959
960 procedure check_evo_items(p0_a0 NUMBER
961 , p0_a1 DATE
962 , p0_a2 NUMBER
963 , p0_a3 DATE
964 , p0_a4 NUMBER
965 , p0_a5 NUMBER
966 , p0_a6 NUMBER
967 , p0_a7 NUMBER
968 , p0_a8 NUMBER
969 , p0_a9 VARCHAR2
970 , p0_a10 VARCHAR2
971 , p0_a11 VARCHAR2
972 , p0_a12 VARCHAR2
973 , p0_a13 NUMBER
974 , p0_a14 DATE
975 , p0_a15 VARCHAR2
976 , p0_a16 VARCHAR2
977 , p0_a17 NUMBER
978 , p0_a18 VARCHAR2
979 , p0_a19 VARCHAR2
980 , p0_a20 VARCHAR2
981 , p0_a21 NUMBER
982 , p0_a22 VARCHAR2
983 , p0_a23 VARCHAR2
984 , p0_a24 VARCHAR2
985 , p0_a25 VARCHAR2
986 , p0_a26 VARCHAR2
987 , p0_a27 VARCHAR2
988 , p0_a28 VARCHAR2
989 , p0_a29 VARCHAR2
990 , p0_a30 VARCHAR2
991 , p0_a31 VARCHAR2
992 , p0_a32 VARCHAR2
993 , p0_a33 VARCHAR2
994 , p0_a34 VARCHAR2
995 , p0_a35 NUMBER
996 , p0_a36 NUMBER
997 , p0_a37 VARCHAR2
998 , p0_a38 DATE
999 , p0_a39 DATE
1000 , p0_a40 DATE
1001 , p0_a41 DATE
1002 , p0_a42 DATE
1003 , p0_a43 DATE
1004 , p0_a44 DATE
1005 , p0_a45 DATE
1006 , p0_a46 NUMBER
1007 , p0_a47 NUMBER
1008 , p0_a48 NUMBER
1009 , p0_a49 NUMBER
1010 , p0_a50 NUMBER
1011 , p0_a51 DATE
1012 , p0_a52 NUMBER
1013 , p0_a53 VARCHAR2
1014 , p0_a54 NUMBER
1015 , p0_a55 NUMBER
1016 , p0_a56 NUMBER
1017 , p0_a57 NUMBER
1018 , p0_a58 VARCHAR2
1019 , p0_a59 VARCHAR2
1020 , p0_a60 NUMBER
1021 , p0_a61 VARCHAR2
1022 , p0_a62 NUMBER
1023 , p0_a63 NUMBER
1024 , p0_a64 NUMBER
1025 , p0_a65 NUMBER
1026 , p0_a66 VARCHAR2
1027 , p0_a67 NUMBER
1028 , p0_a68 VARCHAR2
1029 , p0_a69 NUMBER
1030 , p0_a70 NUMBER
1031 , p0_a71 VARCHAR2
1032 , p0_a72 VARCHAR2
1033 , p0_a73 VARCHAR2
1034 , p0_a74 VARCHAR2
1035 , p0_a75 VARCHAR2
1036 , p0_a76 NUMBER
1037 , p0_a77 NUMBER
1038 , p0_a78 VARCHAR2
1039 , p0_a79 VARCHAR2
1040 , p0_a80 VARCHAR2
1041 , p0_a81 NUMBER
1042 , p0_a82 NUMBER
1043 , p0_a83 VARCHAR2
1044 , p0_a84 NUMBER
1045 , p0_a85 VARCHAR2
1046 , p0_a86 VARCHAR2
1047 , p0_a87 VARCHAR2
1048 , p0_a88 VARCHAR2
1049 , p0_a89 VARCHAR2
1050 , p0_a90 VARCHAR2
1051 , p0_a91 VARCHAR2
1052 , p0_a92 VARCHAR2
1053 , p0_a93 VARCHAR2
1054 , p0_a94 VARCHAR2
1055 , p0_a95 VARCHAR2
1056 , p0_a96 VARCHAR2
1057 , p0_a97 VARCHAR2
1058 , p0_a98 VARCHAR2
1059 , p0_a99 VARCHAR2
1060 , p0_a100 VARCHAR2
1061 , p0_a101 VARCHAR2
1062 , p0_a102 VARCHAR2
1063 , p0_a103 VARCHAR2
1064 , p0_a104 VARCHAR2
1065 , p0_a105 NUMBER
1066 , p0_a106 VARCHAR2
1067 , p0_a107 NUMBER
1068 , p0_a108 VARCHAR2
1069 , p0_a109 VARCHAR2
1070 , p0_a110 VARCHAR2
1071 , p0_a111 VARCHAR2
1072 , p0_a112 NUMBER
1073 , p0_a113 VARCHAR2
1074 , p0_a114 NUMBER
1075 , p0_a115 VARCHAR2
1076 , p0_a116 VARCHAR2
1077 , p0_a117 VARCHAR2
1078 , p0_a118 NUMBER
1079 , p0_a119 VARCHAR2
1080 , p0_a120 VARCHAR2
1081 , p0_a121 VARCHAR2
1082 , p0_a122 VARCHAR2
1083 , p0_a123 VARCHAR2
1084 , p0_a124 VARCHAR2
1085 , p0_a125 DATE
1086 , p0_a126 DATE
1087 , p0_a127 NUMBER
1088 , p0_a128 NUMBER
1089 , p0_a129 VARCHAR2
1090 , p0_a130 VARCHAR2
1091 , p0_a131 VARCHAR2
1092 , p0_a132 VARCHAR2
1093 , p0_a133 VARCHAR2
1094 , p0_a134 VARCHAR2
1095 , p0_a135 VARCHAR2
1096 , p0_a136 NUMBER
1097 , p0_a137 VARCHAR2
1098 , p_validation_mode VARCHAR2
1099 , x_return_status out nocopy VARCHAR2
1100 )
1101
1102 as
1103 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
1104 ddindx binary_integer; indx binary_integer;
1105 begin
1106
1107 -- copy data to the local IN or IN-OUT args, if any
1108 ddp_evo_rec.event_offer_id := p0_a0;
1109 ddp_evo_rec.last_update_date := p0_a1;
1110 ddp_evo_rec.last_updated_by := p0_a2;
1111 ddp_evo_rec.creation_date := p0_a3;
1112 ddp_evo_rec.created_by := p0_a4;
1113 ddp_evo_rec.last_update_login := p0_a5;
1114 ddp_evo_rec.object_version_number := p0_a6;
1115 ddp_evo_rec.application_id := p0_a7;
1116 ddp_evo_rec.event_header_id := p0_a8;
1117 ddp_evo_rec.private_flag := p0_a9;
1118 ddp_evo_rec.active_flag := p0_a10;
1119 ddp_evo_rec.source_code := p0_a11;
1120 ddp_evo_rec.event_level := p0_a12;
1121 ddp_evo_rec.user_status_id := p0_a13;
1122 ddp_evo_rec.last_status_date := p0_a14;
1123 ddp_evo_rec.system_status_code := p0_a15;
1124 ddp_evo_rec.event_type_code := p0_a16;
1125 ddp_evo_rec.event_delivery_method_id := p0_a17;
1126 ddp_evo_rec.event_delivery_method_code := p0_a18;
1127 ddp_evo_rec.event_required_flag := p0_a19;
1128 ddp_evo_rec.event_language_code := p0_a20;
1129 ddp_evo_rec.event_location_id := p0_a21;
1130 ddp_evo_rec.city := p0_a22;
1131 ddp_evo_rec.state := p0_a23;
1132 ddp_evo_rec.province := p0_a24;
1133 ddp_evo_rec.country := p0_a25;
1134 ddp_evo_rec.overflow_flag := p0_a26;
1135 ddp_evo_rec.partner_flag := p0_a27;
1136 ddp_evo_rec.event_standalone_flag := p0_a28;
1137 ddp_evo_rec.reg_frozen_flag := p0_a29;
1138 ddp_evo_rec.reg_required_flag := p0_a30;
1139 ddp_evo_rec.reg_charge_flag := p0_a31;
1140 ddp_evo_rec.reg_invited_only_flag := p0_a32;
1141 ddp_evo_rec.reg_waitlist_allowed_flag := p0_a33;
1142 ddp_evo_rec.reg_overbook_allowed_flag := p0_a34;
1143 ddp_evo_rec.parent_event_offer_id := p0_a35;
1144 ddp_evo_rec.event_duration := p0_a36;
1145 ddp_evo_rec.event_duration_uom_code := p0_a37;
1146 ddp_evo_rec.event_start_date := p0_a38;
1147 ddp_evo_rec.event_start_date_time := p0_a39;
1148 ddp_evo_rec.event_end_date := p0_a40;
1149 ddp_evo_rec.event_end_date_time := p0_a41;
1150 ddp_evo_rec.reg_start_date := p0_a42;
1151 ddp_evo_rec.reg_start_time := p0_a43;
1152 ddp_evo_rec.reg_end_date := p0_a44;
1153 ddp_evo_rec.reg_end_time := p0_a45;
1154 ddp_evo_rec.reg_maximum_capacity := p0_a46;
1155 ddp_evo_rec.reg_overbook_pct := p0_a47;
1156 ddp_evo_rec.reg_effective_capacity := p0_a48;
1157 ddp_evo_rec.reg_waitlist_pct := p0_a49;
1158 ddp_evo_rec.reg_minimum_capacity := p0_a50;
1159 ddp_evo_rec.reg_minimum_req_by_date := p0_a51;
1160 ddp_evo_rec.inventory_item_id := p0_a52;
1161 ddp_evo_rec.inventory_item := p0_a53;
1162 ddp_evo_rec.organization_id := p0_a54;
1163 ddp_evo_rec.pricelist_header_id := p0_a55;
1164 ddp_evo_rec.pricelist_line_id := p0_a56;
1165 ddp_evo_rec.org_id := p0_a57;
1166 ddp_evo_rec.waitlist_action_type_code := p0_a58;
1167 ddp_evo_rec.stream_type_code := p0_a59;
1168 ddp_evo_rec.owner_user_id := p0_a60;
1169 ddp_evo_rec.event_full_flag := p0_a61;
1170 ddp_evo_rec.forecasted_revenue := p0_a62;
1171 ddp_evo_rec.actual_revenue := p0_a63;
1172 ddp_evo_rec.forecasted_cost := p0_a64;
1173 ddp_evo_rec.actual_cost := p0_a65;
1174 ddp_evo_rec.fund_source_type_code := p0_a66;
1175 ddp_evo_rec.fund_source_id := p0_a67;
1176 ddp_evo_rec.cert_credit_type_code := p0_a68;
1177 ddp_evo_rec.certification_credits := p0_a69;
1178 ddp_evo_rec.coordinator_id := p0_a70;
1179 ddp_evo_rec.priority_type_code := p0_a71;
1180 ddp_evo_rec.cancellation_reason_code := p0_a72;
1181 ddp_evo_rec.auto_register_flag := p0_a73;
1182 ddp_evo_rec.email := p0_a74;
1183 ddp_evo_rec.phone := p0_a75;
1184 ddp_evo_rec.fund_amount_tc := p0_a76;
1185 ddp_evo_rec.fund_amount_fc := p0_a77;
1186 ddp_evo_rec.currency_code_tc := p0_a78;
1187 ddp_evo_rec.currency_code_fc := p0_a79;
1188 ddp_evo_rec.url := p0_a80;
1189 ddp_evo_rec.timezone_id := p0_a81;
1190 ddp_evo_rec.event_venue_id := p0_a82;
1191 ddp_evo_rec.pricelist_header_currency_code := p0_a83;
1192 ddp_evo_rec.pricelist_list_price := p0_a84;
1193 ddp_evo_rec.inbound_script_name := p0_a85;
1194 ddp_evo_rec.attribute_category := p0_a86;
1195 ddp_evo_rec.attribute1 := p0_a87;
1196 ddp_evo_rec.attribute2 := p0_a88;
1197 ddp_evo_rec.attribute3 := p0_a89;
1198 ddp_evo_rec.attribute4 := p0_a90;
1199 ddp_evo_rec.attribute5 := p0_a91;
1200 ddp_evo_rec.attribute6 := p0_a92;
1201 ddp_evo_rec.attribute7 := p0_a93;
1202 ddp_evo_rec.attribute8 := p0_a94;
1203 ddp_evo_rec.attribute9 := p0_a95;
1204 ddp_evo_rec.attribute10 := p0_a96;
1205 ddp_evo_rec.attribute11 := p0_a97;
1206 ddp_evo_rec.attribute12 := p0_a98;
1207 ddp_evo_rec.attribute13 := p0_a99;
1208 ddp_evo_rec.attribute14 := p0_a100;
1209 ddp_evo_rec.attribute15 := p0_a101;
1210 ddp_evo_rec.event_offer_name := p0_a102;
1211 ddp_evo_rec.event_mktg_message := p0_a103;
1212 ddp_evo_rec.description := p0_a104;
1213 ddp_evo_rec.custom_setup_id := p0_a105;
1214 ddp_evo_rec.country_code := p0_a106;
1215 ddp_evo_rec.business_unit_id := p0_a107;
1216 ddp_evo_rec.event_calendar := p0_a108;
1217 ddp_evo_rec.start_period_name := p0_a109;
1218 ddp_evo_rec.end_period_name := p0_a110;
1219 ddp_evo_rec.global_flag := p0_a111;
1220 ddp_evo_rec.task_id := p0_a112;
1221 ddp_evo_rec.parent_type := p0_a113;
1222 ddp_evo_rec.parent_id := p0_a114;
1223 ddp_evo_rec.create_attendant_lead_flag := p0_a115;
1224 ddp_evo_rec.create_registrant_lead_flag := p0_a116;
1225 ddp_evo_rec.event_object_type := p0_a117;
1226 ddp_evo_rec.reg_timezone_id := p0_a118;
1227 ddp_evo_rec.event_password := p0_a119;
1228 ddp_evo_rec.record_event_flag := p0_a120;
1229 ddp_evo_rec.allow_register_in_middle_flag := p0_a121;
1230 ddp_evo_rec.publish_attendees_flag := p0_a122;
1231 ddp_evo_rec.direct_join_flag := p0_a123;
1232 ddp_evo_rec.event_notification_method := p0_a124;
1233 ddp_evo_rec.actual_start_time := p0_a125;
1234 ddp_evo_rec.actual_end_time := p0_a126;
1235 ddp_evo_rec.server_id := p0_a127;
1236 ddp_evo_rec.owner_fnd_user_id := p0_a128;
1237 ddp_evo_rec.meeting_dial_in_info := p0_a129;
1238 ddp_evo_rec.meeting_email_subject := p0_a130;
1239 ddp_evo_rec.meeting_schedule_type := p0_a131;
1240 ddp_evo_rec.meeting_status := p0_a132;
1241 ddp_evo_rec.meeting_misc_info := p0_a133;
1242 ddp_evo_rec.publish_flag := p0_a134;
1243 ddp_evo_rec.meeting_encryption_key_code := p0_a135;
1244 ddp_evo_rec.number_of_attendees := p0_a136;
1245 ddp_evo_rec.event_purpose_code := p0_a137;
1246
1247
1248
1249 -- here's the delegated call to the old PL/SQL routine
1250 ams_eventoffer_pvt.check_evo_items(ddp_evo_rec,
1251 p_validation_mode,
1252 x_return_status);
1253
1254 -- copy data back from the local variables to OUT or IN-OUT args, if any
1255
1256
1257 end;
1258
1259 procedure check_evo_record(p0_a0 NUMBER
1260 , p0_a1 DATE
1261 , p0_a2 NUMBER
1262 , p0_a3 DATE
1263 , p0_a4 NUMBER
1264 , p0_a5 NUMBER
1265 , p0_a6 NUMBER
1266 , p0_a7 NUMBER
1267 , p0_a8 NUMBER
1268 , p0_a9 VARCHAR2
1269 , p0_a10 VARCHAR2
1270 , p0_a11 VARCHAR2
1271 , p0_a12 VARCHAR2
1272 , p0_a13 NUMBER
1273 , p0_a14 DATE
1274 , p0_a15 VARCHAR2
1275 , p0_a16 VARCHAR2
1276 , p0_a17 NUMBER
1277 , p0_a18 VARCHAR2
1278 , p0_a19 VARCHAR2
1279 , p0_a20 VARCHAR2
1280 , p0_a21 NUMBER
1281 , p0_a22 VARCHAR2
1282 , p0_a23 VARCHAR2
1283 , p0_a24 VARCHAR2
1284 , p0_a25 VARCHAR2
1285 , p0_a26 VARCHAR2
1286 , p0_a27 VARCHAR2
1287 , p0_a28 VARCHAR2
1288 , p0_a29 VARCHAR2
1289 , p0_a30 VARCHAR2
1290 , p0_a31 VARCHAR2
1291 , p0_a32 VARCHAR2
1292 , p0_a33 VARCHAR2
1293 , p0_a34 VARCHAR2
1294 , p0_a35 NUMBER
1295 , p0_a36 NUMBER
1296 , p0_a37 VARCHAR2
1297 , p0_a38 DATE
1298 , p0_a39 DATE
1299 , p0_a40 DATE
1300 , p0_a41 DATE
1301 , p0_a42 DATE
1302 , p0_a43 DATE
1303 , p0_a44 DATE
1304 , p0_a45 DATE
1305 , p0_a46 NUMBER
1306 , p0_a47 NUMBER
1307 , p0_a48 NUMBER
1308 , p0_a49 NUMBER
1309 , p0_a50 NUMBER
1310 , p0_a51 DATE
1311 , p0_a52 NUMBER
1312 , p0_a53 VARCHAR2
1313 , p0_a54 NUMBER
1314 , p0_a55 NUMBER
1315 , p0_a56 NUMBER
1316 , p0_a57 NUMBER
1317 , p0_a58 VARCHAR2
1318 , p0_a59 VARCHAR2
1319 , p0_a60 NUMBER
1320 , p0_a61 VARCHAR2
1321 , p0_a62 NUMBER
1322 , p0_a63 NUMBER
1323 , p0_a64 NUMBER
1324 , p0_a65 NUMBER
1325 , p0_a66 VARCHAR2
1326 , p0_a67 NUMBER
1327 , p0_a68 VARCHAR2
1328 , p0_a69 NUMBER
1329 , p0_a70 NUMBER
1330 , p0_a71 VARCHAR2
1331 , p0_a72 VARCHAR2
1332 , p0_a73 VARCHAR2
1333 , p0_a74 VARCHAR2
1334 , p0_a75 VARCHAR2
1335 , p0_a76 NUMBER
1336 , p0_a77 NUMBER
1337 , p0_a78 VARCHAR2
1338 , p0_a79 VARCHAR2
1339 , p0_a80 VARCHAR2
1340 , p0_a81 NUMBER
1341 , p0_a82 NUMBER
1342 , p0_a83 VARCHAR2
1343 , p0_a84 NUMBER
1344 , p0_a85 VARCHAR2
1345 , p0_a86 VARCHAR2
1346 , p0_a87 VARCHAR2
1347 , p0_a88 VARCHAR2
1348 , p0_a89 VARCHAR2
1349 , p0_a90 VARCHAR2
1350 , p0_a91 VARCHAR2
1351 , p0_a92 VARCHAR2
1352 , p0_a93 VARCHAR2
1353 , p0_a94 VARCHAR2
1354 , p0_a95 VARCHAR2
1355 , p0_a96 VARCHAR2
1356 , p0_a97 VARCHAR2
1357 , p0_a98 VARCHAR2
1358 , p0_a99 VARCHAR2
1359 , p0_a100 VARCHAR2
1360 , p0_a101 VARCHAR2
1361 , p0_a102 VARCHAR2
1362 , p0_a103 VARCHAR2
1363 , p0_a104 VARCHAR2
1364 , p0_a105 NUMBER
1365 , p0_a106 VARCHAR2
1366 , p0_a107 NUMBER
1367 , p0_a108 VARCHAR2
1368 , p0_a109 VARCHAR2
1369 , p0_a110 VARCHAR2
1370 , p0_a111 VARCHAR2
1371 , p0_a112 NUMBER
1372 , p0_a113 VARCHAR2
1373 , p0_a114 NUMBER
1374 , p0_a115 VARCHAR2
1375 , p0_a116 VARCHAR2
1376 , p0_a117 VARCHAR2
1377 , p0_a118 NUMBER
1378 , p0_a119 VARCHAR2
1379 , p0_a120 VARCHAR2
1380 , p0_a121 VARCHAR2
1381 , p0_a122 VARCHAR2
1382 , p0_a123 VARCHAR2
1383 , p0_a124 VARCHAR2
1384 , p0_a125 DATE
1385 , p0_a126 DATE
1386 , p0_a127 NUMBER
1387 , p0_a128 NUMBER
1388 , p0_a129 VARCHAR2
1389 , p0_a130 VARCHAR2
1390 , p0_a131 VARCHAR2
1391 , p0_a132 VARCHAR2
1392 , p0_a133 VARCHAR2
1393 , p0_a134 VARCHAR2
1394 , p0_a135 VARCHAR2
1395 , p0_a136 NUMBER
1396 , p0_a137 VARCHAR2
1397 , p1_a0 NUMBER
1398 , p1_a1 DATE
1399 , p1_a2 NUMBER
1400 , p1_a3 DATE
1401 , p1_a4 NUMBER
1402 , p1_a5 NUMBER
1403 , p1_a6 NUMBER
1404 , p1_a7 NUMBER
1405 , p1_a8 NUMBER
1406 , p1_a9 VARCHAR2
1407 , p1_a10 VARCHAR2
1408 , p1_a11 VARCHAR2
1409 , p1_a12 VARCHAR2
1410 , p1_a13 NUMBER
1411 , p1_a14 DATE
1412 , p1_a15 VARCHAR2
1413 , p1_a16 VARCHAR2
1414 , p1_a17 NUMBER
1415 , p1_a18 VARCHAR2
1416 , p1_a19 VARCHAR2
1417 , p1_a20 VARCHAR2
1418 , p1_a21 NUMBER
1419 , p1_a22 VARCHAR2
1420 , p1_a23 VARCHAR2
1421 , p1_a24 VARCHAR2
1422 , p1_a25 VARCHAR2
1423 , p1_a26 VARCHAR2
1424 , p1_a27 VARCHAR2
1425 , p1_a28 VARCHAR2
1426 , p1_a29 VARCHAR2
1427 , p1_a30 VARCHAR2
1428 , p1_a31 VARCHAR2
1429 , p1_a32 VARCHAR2
1430 , p1_a33 VARCHAR2
1431 , p1_a34 VARCHAR2
1432 , p1_a35 NUMBER
1433 , p1_a36 NUMBER
1434 , p1_a37 VARCHAR2
1435 , p1_a38 DATE
1436 , p1_a39 DATE
1437 , p1_a40 DATE
1438 , p1_a41 DATE
1439 , p1_a42 DATE
1440 , p1_a43 DATE
1441 , p1_a44 DATE
1442 , p1_a45 DATE
1443 , p1_a46 NUMBER
1444 , p1_a47 NUMBER
1445 , p1_a48 NUMBER
1446 , p1_a49 NUMBER
1447 , p1_a50 NUMBER
1448 , p1_a51 DATE
1449 , p1_a52 NUMBER
1450 , p1_a53 VARCHAR2
1451 , p1_a54 NUMBER
1452 , p1_a55 NUMBER
1453 , p1_a56 NUMBER
1454 , p1_a57 NUMBER
1455 , p1_a58 VARCHAR2
1456 , p1_a59 VARCHAR2
1457 , p1_a60 NUMBER
1458 , p1_a61 VARCHAR2
1459 , p1_a62 NUMBER
1460 , p1_a63 NUMBER
1461 , p1_a64 NUMBER
1462 , p1_a65 NUMBER
1463 , p1_a66 VARCHAR2
1464 , p1_a67 NUMBER
1465 , p1_a68 VARCHAR2
1466 , p1_a69 NUMBER
1467 , p1_a70 NUMBER
1468 , p1_a71 VARCHAR2
1469 , p1_a72 VARCHAR2
1470 , p1_a73 VARCHAR2
1471 , p1_a74 VARCHAR2
1472 , p1_a75 VARCHAR2
1473 , p1_a76 NUMBER
1474 , p1_a77 NUMBER
1475 , p1_a78 VARCHAR2
1476 , p1_a79 VARCHAR2
1477 , p1_a80 VARCHAR2
1478 , p1_a81 NUMBER
1479 , p1_a82 NUMBER
1480 , p1_a83 VARCHAR2
1481 , p1_a84 NUMBER
1482 , p1_a85 VARCHAR2
1483 , p1_a86 VARCHAR2
1484 , p1_a87 VARCHAR2
1485 , p1_a88 VARCHAR2
1486 , p1_a89 VARCHAR2
1487 , p1_a90 VARCHAR2
1488 , p1_a91 VARCHAR2
1489 , p1_a92 VARCHAR2
1490 , p1_a93 VARCHAR2
1491 , p1_a94 VARCHAR2
1492 , p1_a95 VARCHAR2
1493 , p1_a96 VARCHAR2
1494 , p1_a97 VARCHAR2
1495 , p1_a98 VARCHAR2
1496 , p1_a99 VARCHAR2
1497 , p1_a100 VARCHAR2
1498 , p1_a101 VARCHAR2
1499 , p1_a102 VARCHAR2
1500 , p1_a103 VARCHAR2
1501 , p1_a104 VARCHAR2
1502 , p1_a105 NUMBER
1503 , p1_a106 VARCHAR2
1504 , p1_a107 NUMBER
1505 , p1_a108 VARCHAR2
1506 , p1_a109 VARCHAR2
1507 , p1_a110 VARCHAR2
1508 , p1_a111 VARCHAR2
1509 , p1_a112 NUMBER
1510 , p1_a113 VARCHAR2
1511 , p1_a114 NUMBER
1512 , p1_a115 VARCHAR2
1513 , p1_a116 VARCHAR2
1514 , p1_a117 VARCHAR2
1515 , p1_a118 NUMBER
1516 , p1_a119 VARCHAR2
1517 , p1_a120 VARCHAR2
1518 , p1_a121 VARCHAR2
1519 , p1_a122 VARCHAR2
1520 , p1_a123 VARCHAR2
1521 , p1_a124 VARCHAR2
1522 , p1_a125 DATE
1523 , p1_a126 DATE
1524 , p1_a127 NUMBER
1525 , p1_a128 NUMBER
1526 , p1_a129 VARCHAR2
1527 , p1_a130 VARCHAR2
1528 , p1_a131 VARCHAR2
1529 , p1_a132 VARCHAR2
1530 , p1_a133 VARCHAR2
1531 , p1_a134 VARCHAR2
1532 , p1_a135 VARCHAR2
1533 , p1_a136 NUMBER
1534 , p1_a137 VARCHAR2
1535 , x_return_status out nocopy VARCHAR2
1536 )
1537
1538 as
1539 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
1540 ddp_complete_rec ams_eventoffer_pvt.evo_rec_type;
1541 ddindx binary_integer; indx binary_integer;
1542 begin
1543
1544 -- copy data to the local IN or IN-OUT args, if any
1545 ddp_evo_rec.event_offer_id := p0_a0;
1546 ddp_evo_rec.last_update_date := p0_a1;
1547 ddp_evo_rec.last_updated_by := p0_a2;
1548 ddp_evo_rec.creation_date := p0_a3;
1549 ddp_evo_rec.created_by := p0_a4;
1550 ddp_evo_rec.last_update_login := p0_a5;
1551 ddp_evo_rec.object_version_number := p0_a6;
1552 ddp_evo_rec.application_id := p0_a7;
1553 ddp_evo_rec.event_header_id := p0_a8;
1554 ddp_evo_rec.private_flag := p0_a9;
1555 ddp_evo_rec.active_flag := p0_a10;
1556 ddp_evo_rec.source_code := p0_a11;
1557 ddp_evo_rec.event_level := p0_a12;
1558 ddp_evo_rec.user_status_id := p0_a13;
1559 ddp_evo_rec.last_status_date := p0_a14;
1560 ddp_evo_rec.system_status_code := p0_a15;
1561 ddp_evo_rec.event_type_code := p0_a16;
1562 ddp_evo_rec.event_delivery_method_id := p0_a17;
1563 ddp_evo_rec.event_delivery_method_code := p0_a18;
1564 ddp_evo_rec.event_required_flag := p0_a19;
1565 ddp_evo_rec.event_language_code := p0_a20;
1566 ddp_evo_rec.event_location_id := p0_a21;
1567 ddp_evo_rec.city := p0_a22;
1568 ddp_evo_rec.state := p0_a23;
1569 ddp_evo_rec.province := p0_a24;
1570 ddp_evo_rec.country := p0_a25;
1571 ddp_evo_rec.overflow_flag := p0_a26;
1572 ddp_evo_rec.partner_flag := p0_a27;
1573 ddp_evo_rec.event_standalone_flag := p0_a28;
1574 ddp_evo_rec.reg_frozen_flag := p0_a29;
1575 ddp_evo_rec.reg_required_flag := p0_a30;
1576 ddp_evo_rec.reg_charge_flag := p0_a31;
1577 ddp_evo_rec.reg_invited_only_flag := p0_a32;
1578 ddp_evo_rec.reg_waitlist_allowed_flag := p0_a33;
1579 ddp_evo_rec.reg_overbook_allowed_flag := p0_a34;
1580 ddp_evo_rec.parent_event_offer_id := p0_a35;
1581 ddp_evo_rec.event_duration := p0_a36;
1582 ddp_evo_rec.event_duration_uom_code := p0_a37;
1583 ddp_evo_rec.event_start_date := p0_a38;
1584 ddp_evo_rec.event_start_date_time := p0_a39;
1585 ddp_evo_rec.event_end_date := p0_a40;
1586 ddp_evo_rec.event_end_date_time := p0_a41;
1587 ddp_evo_rec.reg_start_date := p0_a42;
1588 ddp_evo_rec.reg_start_time := p0_a43;
1589 ddp_evo_rec.reg_end_date := p0_a44;
1590 ddp_evo_rec.reg_end_time := p0_a45;
1591 ddp_evo_rec.reg_maximum_capacity := p0_a46;
1592 ddp_evo_rec.reg_overbook_pct := p0_a47;
1593 ddp_evo_rec.reg_effective_capacity := p0_a48;
1594 ddp_evo_rec.reg_waitlist_pct := p0_a49;
1595 ddp_evo_rec.reg_minimum_capacity := p0_a50;
1596 ddp_evo_rec.reg_minimum_req_by_date := p0_a51;
1597 ddp_evo_rec.inventory_item_id := p0_a52;
1598 ddp_evo_rec.inventory_item := p0_a53;
1599 ddp_evo_rec.organization_id := p0_a54;
1600 ddp_evo_rec.pricelist_header_id := p0_a55;
1601 ddp_evo_rec.pricelist_line_id := p0_a56;
1602 ddp_evo_rec.org_id := p0_a57;
1603 ddp_evo_rec.waitlist_action_type_code := p0_a58;
1604 ddp_evo_rec.stream_type_code := p0_a59;
1605 ddp_evo_rec.owner_user_id := p0_a60;
1606 ddp_evo_rec.event_full_flag := p0_a61;
1607 ddp_evo_rec.forecasted_revenue := p0_a62;
1608 ddp_evo_rec.actual_revenue := p0_a63;
1609 ddp_evo_rec.forecasted_cost := p0_a64;
1610 ddp_evo_rec.actual_cost := p0_a65;
1611 ddp_evo_rec.fund_source_type_code := p0_a66;
1612 ddp_evo_rec.fund_source_id := p0_a67;
1613 ddp_evo_rec.cert_credit_type_code := p0_a68;
1614 ddp_evo_rec.certification_credits := p0_a69;
1615 ddp_evo_rec.coordinator_id := p0_a70;
1616 ddp_evo_rec.priority_type_code := p0_a71;
1617 ddp_evo_rec.cancellation_reason_code := p0_a72;
1618 ddp_evo_rec.auto_register_flag := p0_a73;
1619 ddp_evo_rec.email := p0_a74;
1620 ddp_evo_rec.phone := p0_a75;
1621 ddp_evo_rec.fund_amount_tc := p0_a76;
1622 ddp_evo_rec.fund_amount_fc := p0_a77;
1623 ddp_evo_rec.currency_code_tc := p0_a78;
1624 ddp_evo_rec.currency_code_fc := p0_a79;
1625 ddp_evo_rec.url := p0_a80;
1626 ddp_evo_rec.timezone_id := p0_a81;
1627 ddp_evo_rec.event_venue_id := p0_a82;
1628 ddp_evo_rec.pricelist_header_currency_code := p0_a83;
1629 ddp_evo_rec.pricelist_list_price := p0_a84;
1630 ddp_evo_rec.inbound_script_name := p0_a85;
1631 ddp_evo_rec.attribute_category := p0_a86;
1632 ddp_evo_rec.attribute1 := p0_a87;
1633 ddp_evo_rec.attribute2 := p0_a88;
1634 ddp_evo_rec.attribute3 := p0_a89;
1635 ddp_evo_rec.attribute4 := p0_a90;
1636 ddp_evo_rec.attribute5 := p0_a91;
1637 ddp_evo_rec.attribute6 := p0_a92;
1638 ddp_evo_rec.attribute7 := p0_a93;
1639 ddp_evo_rec.attribute8 := p0_a94;
1640 ddp_evo_rec.attribute9 := p0_a95;
1641 ddp_evo_rec.attribute10 := p0_a96;
1642 ddp_evo_rec.attribute11 := p0_a97;
1643 ddp_evo_rec.attribute12 := p0_a98;
1644 ddp_evo_rec.attribute13 := p0_a99;
1645 ddp_evo_rec.attribute14 := p0_a100;
1646 ddp_evo_rec.attribute15 := p0_a101;
1647 ddp_evo_rec.event_offer_name := p0_a102;
1648 ddp_evo_rec.event_mktg_message := p0_a103;
1649 ddp_evo_rec.description := p0_a104;
1650 ddp_evo_rec.custom_setup_id := p0_a105;
1651 ddp_evo_rec.country_code := p0_a106;
1652 ddp_evo_rec.business_unit_id := p0_a107;
1653 ddp_evo_rec.event_calendar := p0_a108;
1654 ddp_evo_rec.start_period_name := p0_a109;
1655 ddp_evo_rec.end_period_name := p0_a110;
1656 ddp_evo_rec.global_flag := p0_a111;
1657 ddp_evo_rec.task_id := p0_a112;
1658 ddp_evo_rec.parent_type := p0_a113;
1659 ddp_evo_rec.parent_id := p0_a114;
1660 ddp_evo_rec.create_attendant_lead_flag := p0_a115;
1661 ddp_evo_rec.create_registrant_lead_flag := p0_a116;
1662 ddp_evo_rec.event_object_type := p0_a117;
1663 ddp_evo_rec.reg_timezone_id := p0_a118;
1664 ddp_evo_rec.event_password := p0_a119;
1665 ddp_evo_rec.record_event_flag := p0_a120;
1666 ddp_evo_rec.allow_register_in_middle_flag := p0_a121;
1667 ddp_evo_rec.publish_attendees_flag := p0_a122;
1668 ddp_evo_rec.direct_join_flag := p0_a123;
1669 ddp_evo_rec.event_notification_method := p0_a124;
1670 ddp_evo_rec.actual_start_time := p0_a125;
1671 ddp_evo_rec.actual_end_time := p0_a126;
1672 ddp_evo_rec.server_id := p0_a127;
1673 ddp_evo_rec.owner_fnd_user_id := p0_a128;
1674 ddp_evo_rec.meeting_dial_in_info := p0_a129;
1675 ddp_evo_rec.meeting_email_subject := p0_a130;
1676 ddp_evo_rec.meeting_schedule_type := p0_a131;
1677 ddp_evo_rec.meeting_status := p0_a132;
1678 ddp_evo_rec.meeting_misc_info := p0_a133;
1679 ddp_evo_rec.publish_flag := p0_a134;
1680 ddp_evo_rec.meeting_encryption_key_code := p0_a135;
1681 ddp_evo_rec.number_of_attendees := p0_a136;
1682 ddp_evo_rec.event_purpose_code := p0_a137;
1683
1684 ddp_complete_rec.event_offer_id := p1_a0;
1685 ddp_complete_rec.last_update_date := p1_a1;
1686 ddp_complete_rec.last_updated_by := p1_a2;
1687 ddp_complete_rec.creation_date := p1_a3;
1688 ddp_complete_rec.created_by := p1_a4;
1689 ddp_complete_rec.last_update_login := p1_a5;
1690 ddp_complete_rec.object_version_number := p1_a6;
1691 ddp_complete_rec.application_id := p1_a7;
1692 ddp_complete_rec.event_header_id := p1_a8;
1693 ddp_complete_rec.private_flag := p1_a9;
1694 ddp_complete_rec.active_flag := p1_a10;
1695 ddp_complete_rec.source_code := p1_a11;
1696 ddp_complete_rec.event_level := p1_a12;
1697 ddp_complete_rec.user_status_id := p1_a13;
1698 ddp_complete_rec.last_status_date := p1_a14;
1699 ddp_complete_rec.system_status_code := p1_a15;
1700 ddp_complete_rec.event_type_code := p1_a16;
1701 ddp_complete_rec.event_delivery_method_id := p1_a17;
1702 ddp_complete_rec.event_delivery_method_code := p1_a18;
1703 ddp_complete_rec.event_required_flag := p1_a19;
1704 ddp_complete_rec.event_language_code := p1_a20;
1705 ddp_complete_rec.event_location_id := p1_a21;
1706 ddp_complete_rec.city := p1_a22;
1707 ddp_complete_rec.state := p1_a23;
1708 ddp_complete_rec.province := p1_a24;
1709 ddp_complete_rec.country := p1_a25;
1710 ddp_complete_rec.overflow_flag := p1_a26;
1711 ddp_complete_rec.partner_flag := p1_a27;
1712 ddp_complete_rec.event_standalone_flag := p1_a28;
1713 ddp_complete_rec.reg_frozen_flag := p1_a29;
1714 ddp_complete_rec.reg_required_flag := p1_a30;
1715 ddp_complete_rec.reg_charge_flag := p1_a31;
1716 ddp_complete_rec.reg_invited_only_flag := p1_a32;
1717 ddp_complete_rec.reg_waitlist_allowed_flag := p1_a33;
1718 ddp_complete_rec.reg_overbook_allowed_flag := p1_a34;
1719 ddp_complete_rec.parent_event_offer_id := p1_a35;
1720 ddp_complete_rec.event_duration := p1_a36;
1721 ddp_complete_rec.event_duration_uom_code := p1_a37;
1722 ddp_complete_rec.event_start_date := p1_a38;
1723 ddp_complete_rec.event_start_date_time := p1_a39;
1724 ddp_complete_rec.event_end_date := p1_a40;
1725 ddp_complete_rec.event_end_date_time := p1_a41;
1726 ddp_complete_rec.reg_start_date := p1_a42;
1727 ddp_complete_rec.reg_start_time := p1_a43;
1728 ddp_complete_rec.reg_end_date := p1_a44;
1729 ddp_complete_rec.reg_end_time := p1_a45;
1730 ddp_complete_rec.reg_maximum_capacity := p1_a46;
1731 ddp_complete_rec.reg_overbook_pct := p1_a47;
1732 ddp_complete_rec.reg_effective_capacity := p1_a48;
1733 ddp_complete_rec.reg_waitlist_pct := p1_a49;
1734 ddp_complete_rec.reg_minimum_capacity := p1_a50;
1735 ddp_complete_rec.reg_minimum_req_by_date := p1_a51;
1736 ddp_complete_rec.inventory_item_id := p1_a52;
1737 ddp_complete_rec.inventory_item := p1_a53;
1738 ddp_complete_rec.organization_id := p1_a54;
1739 ddp_complete_rec.pricelist_header_id := p1_a55;
1740 ddp_complete_rec.pricelist_line_id := p1_a56;
1741 ddp_complete_rec.org_id := p1_a57;
1742 ddp_complete_rec.waitlist_action_type_code := p1_a58;
1743 ddp_complete_rec.stream_type_code := p1_a59;
1744 ddp_complete_rec.owner_user_id := p1_a60;
1745 ddp_complete_rec.event_full_flag := p1_a61;
1746 ddp_complete_rec.forecasted_revenue := p1_a62;
1747 ddp_complete_rec.actual_revenue := p1_a63;
1748 ddp_complete_rec.forecasted_cost := p1_a64;
1749 ddp_complete_rec.actual_cost := p1_a65;
1750 ddp_complete_rec.fund_source_type_code := p1_a66;
1751 ddp_complete_rec.fund_source_id := p1_a67;
1752 ddp_complete_rec.cert_credit_type_code := p1_a68;
1753 ddp_complete_rec.certification_credits := p1_a69;
1754 ddp_complete_rec.coordinator_id := p1_a70;
1755 ddp_complete_rec.priority_type_code := p1_a71;
1756 ddp_complete_rec.cancellation_reason_code := p1_a72;
1757 ddp_complete_rec.auto_register_flag := p1_a73;
1758 ddp_complete_rec.email := p1_a74;
1759 ddp_complete_rec.phone := p1_a75;
1760 ddp_complete_rec.fund_amount_tc := p1_a76;
1761 ddp_complete_rec.fund_amount_fc := p1_a77;
1762 ddp_complete_rec.currency_code_tc := p1_a78;
1763 ddp_complete_rec.currency_code_fc := p1_a79;
1764 ddp_complete_rec.url := p1_a80;
1765 ddp_complete_rec.timezone_id := p1_a81;
1766 ddp_complete_rec.event_venue_id := p1_a82;
1767 ddp_complete_rec.pricelist_header_currency_code := p1_a83;
1768 ddp_complete_rec.pricelist_list_price := p1_a84;
1769 ddp_complete_rec.inbound_script_name := p1_a85;
1770 ddp_complete_rec.attribute_category := p1_a86;
1771 ddp_complete_rec.attribute1 := p1_a87;
1772 ddp_complete_rec.attribute2 := p1_a88;
1773 ddp_complete_rec.attribute3 := p1_a89;
1774 ddp_complete_rec.attribute4 := p1_a90;
1775 ddp_complete_rec.attribute5 := p1_a91;
1776 ddp_complete_rec.attribute6 := p1_a92;
1777 ddp_complete_rec.attribute7 := p1_a93;
1778 ddp_complete_rec.attribute8 := p1_a94;
1779 ddp_complete_rec.attribute9 := p1_a95;
1780 ddp_complete_rec.attribute10 := p1_a96;
1781 ddp_complete_rec.attribute11 := p1_a97;
1782 ddp_complete_rec.attribute12 := p1_a98;
1783 ddp_complete_rec.attribute13 := p1_a99;
1784 ddp_complete_rec.attribute14 := p1_a100;
1785 ddp_complete_rec.attribute15 := p1_a101;
1786 ddp_complete_rec.event_offer_name := p1_a102;
1787 ddp_complete_rec.event_mktg_message := p1_a103;
1788 ddp_complete_rec.description := p1_a104;
1789 ddp_complete_rec.custom_setup_id := p1_a105;
1790 ddp_complete_rec.country_code := p1_a106;
1791 ddp_complete_rec.business_unit_id := p1_a107;
1792 ddp_complete_rec.event_calendar := p1_a108;
1793 ddp_complete_rec.start_period_name := p1_a109;
1794 ddp_complete_rec.end_period_name := p1_a110;
1795 ddp_complete_rec.global_flag := p1_a111;
1796 ddp_complete_rec.task_id := p1_a112;
1797 ddp_complete_rec.parent_type := p1_a113;
1798 ddp_complete_rec.parent_id := p1_a114;
1799 ddp_complete_rec.create_attendant_lead_flag := p1_a115;
1800 ddp_complete_rec.create_registrant_lead_flag := p1_a116;
1801 ddp_complete_rec.event_object_type := p1_a117;
1802 ddp_complete_rec.reg_timezone_id := p1_a118;
1803 ddp_complete_rec.event_password := p1_a119;
1804 ddp_complete_rec.record_event_flag := p1_a120;
1805 ddp_complete_rec.allow_register_in_middle_flag := p1_a121;
1806 ddp_complete_rec.publish_attendees_flag := p1_a122;
1807 ddp_complete_rec.direct_join_flag := p1_a123;
1808 ddp_complete_rec.event_notification_method := p1_a124;
1809 ddp_complete_rec.actual_start_time := p1_a125;
1810 ddp_complete_rec.actual_end_time := p1_a126;
1811 ddp_complete_rec.server_id := p1_a127;
1812 ddp_complete_rec.owner_fnd_user_id := p1_a128;
1813 ddp_complete_rec.meeting_dial_in_info := p1_a129;
1814 ddp_complete_rec.meeting_email_subject := p1_a130;
1815 ddp_complete_rec.meeting_schedule_type := p1_a131;
1816 ddp_complete_rec.meeting_status := p1_a132;
1817 ddp_complete_rec.meeting_misc_info := p1_a133;
1818 ddp_complete_rec.publish_flag := p1_a134;
1819 ddp_complete_rec.meeting_encryption_key_code := p1_a135;
1820 ddp_complete_rec.number_of_attendees := p1_a136;
1821 ddp_complete_rec.event_purpose_code := p1_a137;
1822
1823
1824 -- here's the delegated call to the old PL/SQL routine
1825 ams_eventoffer_pvt.check_evo_record(ddp_evo_rec,
1826 ddp_complete_rec,
1827 x_return_status);
1828
1829 -- copy data back from the local variables to OUT or IN-OUT args, if any
1830
1831
1832 end;
1833
1834 procedure init_evo_rec(p0_a0 out nocopy NUMBER
1835 , p0_a1 out nocopy DATE
1836 , p0_a2 out nocopy NUMBER
1837 , p0_a3 out nocopy DATE
1838 , p0_a4 out nocopy NUMBER
1839 , p0_a5 out nocopy NUMBER
1840 , p0_a6 out nocopy NUMBER
1841 , p0_a7 out nocopy NUMBER
1842 , p0_a8 out nocopy NUMBER
1843 , p0_a9 out nocopy VARCHAR2
1844 , p0_a10 out nocopy VARCHAR2
1845 , p0_a11 out nocopy VARCHAR2
1846 , p0_a12 out nocopy VARCHAR2
1847 , p0_a13 out nocopy NUMBER
1848 , p0_a14 out nocopy DATE
1849 , p0_a15 out nocopy VARCHAR2
1850 , p0_a16 out nocopy VARCHAR2
1851 , p0_a17 out nocopy NUMBER
1852 , p0_a18 out nocopy VARCHAR2
1853 , p0_a19 out nocopy VARCHAR2
1854 , p0_a20 out nocopy VARCHAR2
1855 , p0_a21 out nocopy NUMBER
1856 , p0_a22 out nocopy VARCHAR2
1857 , p0_a23 out nocopy VARCHAR2
1858 , p0_a24 out nocopy VARCHAR2
1859 , p0_a25 out nocopy VARCHAR2
1860 , p0_a26 out nocopy VARCHAR2
1861 , p0_a27 out nocopy VARCHAR2
1862 , p0_a28 out nocopy VARCHAR2
1863 , p0_a29 out nocopy VARCHAR2
1864 , p0_a30 out nocopy VARCHAR2
1865 , p0_a31 out nocopy VARCHAR2
1866 , p0_a32 out nocopy VARCHAR2
1867 , p0_a33 out nocopy VARCHAR2
1868 , p0_a34 out nocopy VARCHAR2
1869 , p0_a35 out nocopy NUMBER
1870 , p0_a36 out nocopy NUMBER
1871 , p0_a37 out nocopy VARCHAR2
1872 , p0_a38 out nocopy DATE
1873 , p0_a39 out nocopy DATE
1874 , p0_a40 out nocopy DATE
1875 , p0_a41 out nocopy DATE
1876 , p0_a42 out nocopy DATE
1877 , p0_a43 out nocopy DATE
1878 , p0_a44 out nocopy DATE
1879 , p0_a45 out nocopy DATE
1880 , p0_a46 out nocopy NUMBER
1881 , p0_a47 out nocopy NUMBER
1882 , p0_a48 out nocopy NUMBER
1883 , p0_a49 out nocopy NUMBER
1884 , p0_a50 out nocopy NUMBER
1885 , p0_a51 out nocopy DATE
1886 , p0_a52 out nocopy NUMBER
1887 , p0_a53 out nocopy VARCHAR2
1888 , p0_a54 out nocopy NUMBER
1889 , p0_a55 out nocopy NUMBER
1890 , p0_a56 out nocopy NUMBER
1891 , p0_a57 out nocopy NUMBER
1892 , p0_a58 out nocopy VARCHAR2
1893 , p0_a59 out nocopy VARCHAR2
1894 , p0_a60 out nocopy NUMBER
1895 , p0_a61 out nocopy VARCHAR2
1896 , p0_a62 out nocopy NUMBER
1897 , p0_a63 out nocopy NUMBER
1898 , p0_a64 out nocopy NUMBER
1899 , p0_a65 out nocopy NUMBER
1900 , p0_a66 out nocopy VARCHAR2
1901 , p0_a67 out nocopy NUMBER
1902 , p0_a68 out nocopy VARCHAR2
1903 , p0_a69 out nocopy NUMBER
1904 , p0_a70 out nocopy NUMBER
1905 , p0_a71 out nocopy VARCHAR2
1906 , p0_a72 out nocopy VARCHAR2
1907 , p0_a73 out nocopy VARCHAR2
1908 , p0_a74 out nocopy VARCHAR2
1909 , p0_a75 out nocopy VARCHAR2
1910 , p0_a76 out nocopy NUMBER
1911 , p0_a77 out nocopy NUMBER
1912 , p0_a78 out nocopy VARCHAR2
1913 , p0_a79 out nocopy VARCHAR2
1914 , p0_a80 out nocopy VARCHAR2
1915 , p0_a81 out nocopy NUMBER
1916 , p0_a82 out nocopy NUMBER
1917 , p0_a83 out nocopy VARCHAR2
1918 , p0_a84 out nocopy NUMBER
1919 , p0_a85 out nocopy VARCHAR2
1920 , p0_a86 out nocopy VARCHAR2
1921 , p0_a87 out nocopy VARCHAR2
1922 , p0_a88 out nocopy VARCHAR2
1923 , p0_a89 out nocopy VARCHAR2
1924 , p0_a90 out nocopy VARCHAR2
1925 , p0_a91 out nocopy VARCHAR2
1926 , p0_a92 out nocopy VARCHAR2
1927 , p0_a93 out nocopy VARCHAR2
1928 , p0_a94 out nocopy VARCHAR2
1929 , p0_a95 out nocopy VARCHAR2
1930 , p0_a96 out nocopy VARCHAR2
1931 , p0_a97 out nocopy VARCHAR2
1932 , p0_a98 out nocopy VARCHAR2
1933 , p0_a99 out nocopy VARCHAR2
1934 , p0_a100 out nocopy VARCHAR2
1935 , p0_a101 out nocopy VARCHAR2
1936 , p0_a102 out nocopy VARCHAR2
1937 , p0_a103 out nocopy VARCHAR2
1938 , p0_a104 out nocopy VARCHAR2
1939 , p0_a105 out nocopy NUMBER
1940 , p0_a106 out nocopy VARCHAR2
1941 , p0_a107 out nocopy NUMBER
1942 , p0_a108 out nocopy VARCHAR2
1943 , p0_a109 out nocopy VARCHAR2
1944 , p0_a110 out nocopy VARCHAR2
1945 , p0_a111 out nocopy VARCHAR2
1946 , p0_a112 out nocopy NUMBER
1947 , p0_a113 out nocopy VARCHAR2
1948 , p0_a114 out nocopy NUMBER
1949 , p0_a115 out nocopy VARCHAR2
1950 , p0_a116 out nocopy VARCHAR2
1951 , p0_a117 out nocopy VARCHAR2
1952 , p0_a118 out nocopy NUMBER
1953 , p0_a119 out nocopy VARCHAR2
1954 , p0_a120 out nocopy VARCHAR2
1955 , p0_a121 out nocopy VARCHAR2
1956 , p0_a122 out nocopy VARCHAR2
1957 , p0_a123 out nocopy VARCHAR2
1958 , p0_a124 out nocopy VARCHAR2
1959 , p0_a125 out nocopy DATE
1960 , p0_a126 out nocopy DATE
1961 , p0_a127 out nocopy NUMBER
1962 , p0_a128 out nocopy NUMBER
1963 , p0_a129 out nocopy VARCHAR2
1964 , p0_a130 out nocopy VARCHAR2
1965 , p0_a131 out nocopy VARCHAR2
1966 , p0_a132 out nocopy VARCHAR2
1967 , p0_a133 out nocopy VARCHAR2
1968 , p0_a134 out nocopy VARCHAR2
1969 , p0_a135 out nocopy VARCHAR2
1970 , p0_a136 out nocopy NUMBER
1971 , p0_a137 out nocopy VARCHAR2
1972 )
1973
1974 as
1975 ddx_evo_rec ams_eventoffer_pvt.evo_rec_type;
1976 ddindx binary_integer; indx binary_integer;
1977 begin
1978
1979 -- copy data to the local IN or IN-OUT args, if any
1980
1981 -- here's the delegated call to the old PL/SQL routine
1982 ams_eventoffer_pvt.init_evo_rec(ddx_evo_rec);
1983
1984 -- copy data back from the local variables to OUT or IN-OUT args, if any
1985 p0_a0 := ddx_evo_rec.event_offer_id;
1986 p0_a1 := ddx_evo_rec.last_update_date;
1987 p0_a2 := ddx_evo_rec.last_updated_by;
1988 p0_a3 := ddx_evo_rec.creation_date;
1989 p0_a4 := ddx_evo_rec.created_by;
1990 p0_a5 := ddx_evo_rec.last_update_login;
1991 p0_a6 := ddx_evo_rec.object_version_number;
1992 p0_a7 := ddx_evo_rec.application_id;
1993 p0_a8 := ddx_evo_rec.event_header_id;
1994 p0_a9 := ddx_evo_rec.private_flag;
1995 p0_a10 := ddx_evo_rec.active_flag;
1996 p0_a11 := ddx_evo_rec.source_code;
1997 p0_a12 := ddx_evo_rec.event_level;
1998 p0_a13 := ddx_evo_rec.user_status_id;
1999 p0_a14 := ddx_evo_rec.last_status_date;
2000 p0_a15 := ddx_evo_rec.system_status_code;
2001 p0_a16 := ddx_evo_rec.event_type_code;
2002 p0_a17 := ddx_evo_rec.event_delivery_method_id;
2003 p0_a18 := ddx_evo_rec.event_delivery_method_code;
2004 p0_a19 := ddx_evo_rec.event_required_flag;
2005 p0_a20 := ddx_evo_rec.event_language_code;
2006 p0_a21 := ddx_evo_rec.event_location_id;
2007 p0_a22 := ddx_evo_rec.city;
2008 p0_a23 := ddx_evo_rec.state;
2009 p0_a24 := ddx_evo_rec.province;
2010 p0_a25 := ddx_evo_rec.country;
2011 p0_a26 := ddx_evo_rec.overflow_flag;
2012 p0_a27 := ddx_evo_rec.partner_flag;
2013 p0_a28 := ddx_evo_rec.event_standalone_flag;
2014 p0_a29 := ddx_evo_rec.reg_frozen_flag;
2015 p0_a30 := ddx_evo_rec.reg_required_flag;
2016 p0_a31 := ddx_evo_rec.reg_charge_flag;
2017 p0_a32 := ddx_evo_rec.reg_invited_only_flag;
2018 p0_a33 := ddx_evo_rec.reg_waitlist_allowed_flag;
2019 p0_a34 := ddx_evo_rec.reg_overbook_allowed_flag;
2020 p0_a35 := ddx_evo_rec.parent_event_offer_id;
2021 p0_a36 := ddx_evo_rec.event_duration;
2022 p0_a37 := ddx_evo_rec.event_duration_uom_code;
2023 p0_a38 := ddx_evo_rec.event_start_date;
2024 p0_a39 := ddx_evo_rec.event_start_date_time;
2025 p0_a40 := ddx_evo_rec.event_end_date;
2026 p0_a41 := ddx_evo_rec.event_end_date_time;
2027 p0_a42 := ddx_evo_rec.reg_start_date;
2028 p0_a43 := ddx_evo_rec.reg_start_time;
2029 p0_a44 := ddx_evo_rec.reg_end_date;
2030 p0_a45 := ddx_evo_rec.reg_end_time;
2031 p0_a46 := ddx_evo_rec.reg_maximum_capacity;
2032 p0_a47 := ddx_evo_rec.reg_overbook_pct;
2033 p0_a48 := ddx_evo_rec.reg_effective_capacity;
2034 p0_a49 := ddx_evo_rec.reg_waitlist_pct;
2035 p0_a50 := ddx_evo_rec.reg_minimum_capacity;
2036 p0_a51 := ddx_evo_rec.reg_minimum_req_by_date;
2037 p0_a52 := ddx_evo_rec.inventory_item_id;
2038 p0_a53 := ddx_evo_rec.inventory_item;
2039 p0_a54 := ddx_evo_rec.organization_id;
2040 p0_a55 := ddx_evo_rec.pricelist_header_id;
2041 p0_a56 := ddx_evo_rec.pricelist_line_id;
2042 p0_a57 := ddx_evo_rec.org_id;
2043 p0_a58 := ddx_evo_rec.waitlist_action_type_code;
2044 p0_a59 := ddx_evo_rec.stream_type_code;
2045 p0_a60 := ddx_evo_rec.owner_user_id;
2046 p0_a61 := ddx_evo_rec.event_full_flag;
2047 p0_a62 := ddx_evo_rec.forecasted_revenue;
2048 p0_a63 := ddx_evo_rec.actual_revenue;
2049 p0_a64 := ddx_evo_rec.forecasted_cost;
2050 p0_a65 := ddx_evo_rec.actual_cost;
2051 p0_a66 := ddx_evo_rec.fund_source_type_code;
2052 p0_a67 := ddx_evo_rec.fund_source_id;
2053 p0_a68 := ddx_evo_rec.cert_credit_type_code;
2054 p0_a69 := ddx_evo_rec.certification_credits;
2055 p0_a70 := ddx_evo_rec.coordinator_id;
2056 p0_a71 := ddx_evo_rec.priority_type_code;
2057 p0_a72 := ddx_evo_rec.cancellation_reason_code;
2058 p0_a73 := ddx_evo_rec.auto_register_flag;
2059 p0_a74 := ddx_evo_rec.email;
2060 p0_a75 := ddx_evo_rec.phone;
2061 p0_a76 := ddx_evo_rec.fund_amount_tc;
2062 p0_a77 := ddx_evo_rec.fund_amount_fc;
2063 p0_a78 := ddx_evo_rec.currency_code_tc;
2064 p0_a79 := ddx_evo_rec.currency_code_fc;
2065 p0_a80 := ddx_evo_rec.url;
2066 p0_a81 := ddx_evo_rec.timezone_id;
2067 p0_a82 := ddx_evo_rec.event_venue_id;
2068 p0_a83 := ddx_evo_rec.pricelist_header_currency_code;
2069 p0_a84 := ddx_evo_rec.pricelist_list_price;
2070 p0_a85 := ddx_evo_rec.inbound_script_name;
2071 p0_a86 := ddx_evo_rec.attribute_category;
2072 p0_a87 := ddx_evo_rec.attribute1;
2073 p0_a88 := ddx_evo_rec.attribute2;
2074 p0_a89 := ddx_evo_rec.attribute3;
2075 p0_a90 := ddx_evo_rec.attribute4;
2076 p0_a91 := ddx_evo_rec.attribute5;
2077 p0_a92 := ddx_evo_rec.attribute6;
2078 p0_a93 := ddx_evo_rec.attribute7;
2079 p0_a94 := ddx_evo_rec.attribute8;
2080 p0_a95 := ddx_evo_rec.attribute9;
2081 p0_a96 := ddx_evo_rec.attribute10;
2082 p0_a97 := ddx_evo_rec.attribute11;
2083 p0_a98 := ddx_evo_rec.attribute12;
2084 p0_a99 := ddx_evo_rec.attribute13;
2085 p0_a100 := ddx_evo_rec.attribute14;
2086 p0_a101 := ddx_evo_rec.attribute15;
2087 p0_a102 := ddx_evo_rec.event_offer_name;
2088 p0_a103 := ddx_evo_rec.event_mktg_message;
2089 p0_a104 := ddx_evo_rec.description;
2090 p0_a105 := ddx_evo_rec.custom_setup_id;
2091 p0_a106 := ddx_evo_rec.country_code;
2092 p0_a107 := ddx_evo_rec.business_unit_id;
2093 p0_a108 := ddx_evo_rec.event_calendar;
2094 p0_a109 := ddx_evo_rec.start_period_name;
2095 p0_a110 := ddx_evo_rec.end_period_name;
2096 p0_a111 := ddx_evo_rec.global_flag;
2097 p0_a112 := ddx_evo_rec.task_id;
2098 p0_a113 := ddx_evo_rec.parent_type;
2099 p0_a114 := ddx_evo_rec.parent_id;
2100 p0_a115 := ddx_evo_rec.create_attendant_lead_flag;
2101 p0_a116 := ddx_evo_rec.create_registrant_lead_flag;
2102 p0_a117 := ddx_evo_rec.event_object_type;
2103 p0_a118 := ddx_evo_rec.reg_timezone_id;
2104 p0_a119 := ddx_evo_rec.event_password;
2105 p0_a120 := ddx_evo_rec.record_event_flag;
2106 p0_a121 := ddx_evo_rec.allow_register_in_middle_flag;
2107 p0_a122 := ddx_evo_rec.publish_attendees_flag;
2108 p0_a123 := ddx_evo_rec.direct_join_flag;
2109 p0_a124 := ddx_evo_rec.event_notification_method;
2110 p0_a125 := ddx_evo_rec.actual_start_time;
2111 p0_a126 := ddx_evo_rec.actual_end_time;
2112 p0_a127 := ddx_evo_rec.server_id;
2113 p0_a128 := ddx_evo_rec.owner_fnd_user_id;
2114 p0_a129 := ddx_evo_rec.meeting_dial_in_info;
2115 p0_a130 := ddx_evo_rec.meeting_email_subject;
2116 p0_a131 := ddx_evo_rec.meeting_schedule_type;
2117 p0_a132 := ddx_evo_rec.meeting_status;
2118 p0_a133 := ddx_evo_rec.meeting_misc_info;
2119 p0_a134 := ddx_evo_rec.publish_flag;
2120 p0_a135 := ddx_evo_rec.meeting_encryption_key_code;
2121 p0_a136 := ddx_evo_rec.number_of_attendees;
2122 p0_a137 := ddx_evo_rec.event_purpose_code;
2123 end;
2124
2125 procedure complete_evo_rec(p0_a0 NUMBER
2126 , p0_a1 DATE
2127 , p0_a2 NUMBER
2128 , p0_a3 DATE
2129 , p0_a4 NUMBER
2130 , p0_a5 NUMBER
2131 , p0_a6 NUMBER
2132 , p0_a7 NUMBER
2133 , p0_a8 NUMBER
2134 , p0_a9 VARCHAR2
2135 , p0_a10 VARCHAR2
2136 , p0_a11 VARCHAR2
2137 , p0_a12 VARCHAR2
2138 , p0_a13 NUMBER
2139 , p0_a14 DATE
2140 , p0_a15 VARCHAR2
2141 , p0_a16 VARCHAR2
2142 , p0_a17 NUMBER
2143 , p0_a18 VARCHAR2
2144 , p0_a19 VARCHAR2
2145 , p0_a20 VARCHAR2
2146 , p0_a21 NUMBER
2147 , p0_a22 VARCHAR2
2148 , p0_a23 VARCHAR2
2149 , p0_a24 VARCHAR2
2150 , p0_a25 VARCHAR2
2151 , p0_a26 VARCHAR2
2152 , p0_a27 VARCHAR2
2153 , p0_a28 VARCHAR2
2154 , p0_a29 VARCHAR2
2155 , p0_a30 VARCHAR2
2156 , p0_a31 VARCHAR2
2157 , p0_a32 VARCHAR2
2158 , p0_a33 VARCHAR2
2159 , p0_a34 VARCHAR2
2160 , p0_a35 NUMBER
2161 , p0_a36 NUMBER
2162 , p0_a37 VARCHAR2
2163 , p0_a38 DATE
2164 , p0_a39 DATE
2165 , p0_a40 DATE
2166 , p0_a41 DATE
2167 , p0_a42 DATE
2168 , p0_a43 DATE
2169 , p0_a44 DATE
2170 , p0_a45 DATE
2171 , p0_a46 NUMBER
2172 , p0_a47 NUMBER
2173 , p0_a48 NUMBER
2174 , p0_a49 NUMBER
2175 , p0_a50 NUMBER
2176 , p0_a51 DATE
2177 , p0_a52 NUMBER
2178 , p0_a53 VARCHAR2
2179 , p0_a54 NUMBER
2180 , p0_a55 NUMBER
2181 , p0_a56 NUMBER
2182 , p0_a57 NUMBER
2183 , p0_a58 VARCHAR2
2184 , p0_a59 VARCHAR2
2185 , p0_a60 NUMBER
2186 , p0_a61 VARCHAR2
2187 , p0_a62 NUMBER
2188 , p0_a63 NUMBER
2189 , p0_a64 NUMBER
2190 , p0_a65 NUMBER
2191 , p0_a66 VARCHAR2
2192 , p0_a67 NUMBER
2193 , p0_a68 VARCHAR2
2194 , p0_a69 NUMBER
2195 , p0_a70 NUMBER
2196 , p0_a71 VARCHAR2
2197 , p0_a72 VARCHAR2
2198 , p0_a73 VARCHAR2
2199 , p0_a74 VARCHAR2
2200 , p0_a75 VARCHAR2
2201 , p0_a76 NUMBER
2202 , p0_a77 NUMBER
2203 , p0_a78 VARCHAR2
2204 , p0_a79 VARCHAR2
2205 , p0_a80 VARCHAR2
2206 , p0_a81 NUMBER
2207 , p0_a82 NUMBER
2208 , p0_a83 VARCHAR2
2209 , p0_a84 NUMBER
2210 , p0_a85 VARCHAR2
2211 , p0_a86 VARCHAR2
2212 , p0_a87 VARCHAR2
2213 , p0_a88 VARCHAR2
2214 , p0_a89 VARCHAR2
2215 , p0_a90 VARCHAR2
2216 , p0_a91 VARCHAR2
2217 , p0_a92 VARCHAR2
2218 , p0_a93 VARCHAR2
2219 , p0_a94 VARCHAR2
2220 , p0_a95 VARCHAR2
2221 , p0_a96 VARCHAR2
2222 , p0_a97 VARCHAR2
2223 , p0_a98 VARCHAR2
2224 , p0_a99 VARCHAR2
2225 , p0_a100 VARCHAR2
2226 , p0_a101 VARCHAR2
2227 , p0_a102 VARCHAR2
2228 , p0_a103 VARCHAR2
2229 , p0_a104 VARCHAR2
2230 , p0_a105 NUMBER
2231 , p0_a106 VARCHAR2
2232 , p0_a107 NUMBER
2233 , p0_a108 VARCHAR2
2234 , p0_a109 VARCHAR2
2235 , p0_a110 VARCHAR2
2236 , p0_a111 VARCHAR2
2237 , p0_a112 NUMBER
2238 , p0_a113 VARCHAR2
2239 , p0_a114 NUMBER
2240 , p0_a115 VARCHAR2
2241 , p0_a116 VARCHAR2
2242 , p0_a117 VARCHAR2
2243 , p0_a118 NUMBER
2244 , p0_a119 VARCHAR2
2245 , p0_a120 VARCHAR2
2246 , p0_a121 VARCHAR2
2247 , p0_a122 VARCHAR2
2248 , p0_a123 VARCHAR2
2249 , p0_a124 VARCHAR2
2250 , p0_a125 DATE
2251 , p0_a126 DATE
2252 , p0_a127 NUMBER
2253 , p0_a128 NUMBER
2254 , p0_a129 VARCHAR2
2255 , p0_a130 VARCHAR2
2256 , p0_a131 VARCHAR2
2257 , p0_a132 VARCHAR2
2258 , p0_a133 VARCHAR2
2259 , p0_a134 VARCHAR2
2260 , p0_a135 VARCHAR2
2261 , p0_a136 NUMBER
2262 , p0_a137 VARCHAR2
2263 , p1_a0 out nocopy NUMBER
2264 , p1_a1 out nocopy DATE
2265 , p1_a2 out nocopy NUMBER
2266 , p1_a3 out nocopy DATE
2267 , p1_a4 out nocopy NUMBER
2268 , p1_a5 out nocopy NUMBER
2269 , p1_a6 out nocopy NUMBER
2270 , p1_a7 out nocopy NUMBER
2271 , p1_a8 out nocopy NUMBER
2272 , p1_a9 out nocopy VARCHAR2
2273 , p1_a10 out nocopy VARCHAR2
2274 , p1_a11 out nocopy VARCHAR2
2275 , p1_a12 out nocopy VARCHAR2
2276 , p1_a13 out nocopy NUMBER
2277 , p1_a14 out nocopy DATE
2278 , p1_a15 out nocopy VARCHAR2
2279 , p1_a16 out nocopy VARCHAR2
2280 , p1_a17 out nocopy NUMBER
2281 , p1_a18 out nocopy VARCHAR2
2282 , p1_a19 out nocopy VARCHAR2
2283 , p1_a20 out nocopy VARCHAR2
2284 , p1_a21 out nocopy NUMBER
2285 , p1_a22 out nocopy VARCHAR2
2286 , p1_a23 out nocopy VARCHAR2
2287 , p1_a24 out nocopy VARCHAR2
2288 , p1_a25 out nocopy VARCHAR2
2289 , p1_a26 out nocopy VARCHAR2
2290 , p1_a27 out nocopy VARCHAR2
2291 , p1_a28 out nocopy VARCHAR2
2292 , p1_a29 out nocopy VARCHAR2
2293 , p1_a30 out nocopy VARCHAR2
2294 , p1_a31 out nocopy VARCHAR2
2295 , p1_a32 out nocopy VARCHAR2
2296 , p1_a33 out nocopy VARCHAR2
2297 , p1_a34 out nocopy VARCHAR2
2298 , p1_a35 out nocopy NUMBER
2299 , p1_a36 out nocopy NUMBER
2300 , p1_a37 out nocopy VARCHAR2
2301 , p1_a38 out nocopy DATE
2302 , p1_a39 out nocopy DATE
2303 , p1_a40 out nocopy DATE
2304 , p1_a41 out nocopy DATE
2305 , p1_a42 out nocopy DATE
2306 , p1_a43 out nocopy DATE
2307 , p1_a44 out nocopy DATE
2308 , p1_a45 out nocopy DATE
2309 , p1_a46 out nocopy NUMBER
2310 , p1_a47 out nocopy NUMBER
2311 , p1_a48 out nocopy NUMBER
2312 , p1_a49 out nocopy NUMBER
2313 , p1_a50 out nocopy NUMBER
2314 , p1_a51 out nocopy DATE
2315 , p1_a52 out nocopy NUMBER
2316 , p1_a53 out nocopy VARCHAR2
2317 , p1_a54 out nocopy NUMBER
2318 , p1_a55 out nocopy NUMBER
2319 , p1_a56 out nocopy NUMBER
2320 , p1_a57 out nocopy NUMBER
2321 , p1_a58 out nocopy VARCHAR2
2322 , p1_a59 out nocopy VARCHAR2
2323 , p1_a60 out nocopy NUMBER
2324 , p1_a61 out nocopy VARCHAR2
2325 , p1_a62 out nocopy NUMBER
2326 , p1_a63 out nocopy NUMBER
2327 , p1_a64 out nocopy NUMBER
2328 , p1_a65 out nocopy NUMBER
2329 , p1_a66 out nocopy VARCHAR2
2330 , p1_a67 out nocopy NUMBER
2331 , p1_a68 out nocopy VARCHAR2
2332 , p1_a69 out nocopy NUMBER
2333 , p1_a70 out nocopy NUMBER
2334 , p1_a71 out nocopy VARCHAR2
2335 , p1_a72 out nocopy VARCHAR2
2336 , p1_a73 out nocopy VARCHAR2
2337 , p1_a74 out nocopy VARCHAR2
2338 , p1_a75 out nocopy VARCHAR2
2339 , p1_a76 out nocopy NUMBER
2340 , p1_a77 out nocopy NUMBER
2341 , p1_a78 out nocopy VARCHAR2
2342 , p1_a79 out nocopy VARCHAR2
2343 , p1_a80 out nocopy VARCHAR2
2344 , p1_a81 out nocopy NUMBER
2345 , p1_a82 out nocopy NUMBER
2346 , p1_a83 out nocopy VARCHAR2
2347 , p1_a84 out nocopy NUMBER
2348 , p1_a85 out nocopy VARCHAR2
2349 , p1_a86 out nocopy VARCHAR2
2350 , p1_a87 out nocopy VARCHAR2
2351 , p1_a88 out nocopy VARCHAR2
2352 , p1_a89 out nocopy VARCHAR2
2353 , p1_a90 out nocopy VARCHAR2
2354 , p1_a91 out nocopy VARCHAR2
2355 , p1_a92 out nocopy VARCHAR2
2356 , p1_a93 out nocopy VARCHAR2
2357 , p1_a94 out nocopy VARCHAR2
2358 , p1_a95 out nocopy VARCHAR2
2359 , p1_a96 out nocopy VARCHAR2
2360 , p1_a97 out nocopy VARCHAR2
2361 , p1_a98 out nocopy VARCHAR2
2362 , p1_a99 out nocopy VARCHAR2
2363 , p1_a100 out nocopy VARCHAR2
2364 , p1_a101 out nocopy VARCHAR2
2365 , p1_a102 out nocopy VARCHAR2
2366 , p1_a103 out nocopy VARCHAR2
2367 , p1_a104 out nocopy VARCHAR2
2368 , p1_a105 out nocopy NUMBER
2369 , p1_a106 out nocopy VARCHAR2
2370 , p1_a107 out nocopy NUMBER
2371 , p1_a108 out nocopy VARCHAR2
2372 , p1_a109 out nocopy VARCHAR2
2373 , p1_a110 out nocopy VARCHAR2
2374 , p1_a111 out nocopy VARCHAR2
2375 , p1_a112 out nocopy NUMBER
2376 , p1_a113 out nocopy VARCHAR2
2377 , p1_a114 out nocopy NUMBER
2378 , p1_a115 out nocopy VARCHAR2
2379 , p1_a116 out nocopy VARCHAR2
2380 , p1_a117 out nocopy VARCHAR2
2381 , p1_a118 out nocopy NUMBER
2382 , p1_a119 out nocopy VARCHAR2
2383 , p1_a120 out nocopy VARCHAR2
2384 , p1_a121 out nocopy VARCHAR2
2385 , p1_a122 out nocopy VARCHAR2
2386 , p1_a123 out nocopy VARCHAR2
2387 , p1_a124 out nocopy VARCHAR2
2388 , p1_a125 out nocopy DATE
2389 , p1_a126 out nocopy DATE
2390 , p1_a127 out nocopy NUMBER
2391 , p1_a128 out nocopy NUMBER
2392 , p1_a129 out nocopy VARCHAR2
2393 , p1_a130 out nocopy VARCHAR2
2394 , p1_a131 out nocopy VARCHAR2
2395 , p1_a132 out nocopy VARCHAR2
2396 , p1_a133 out nocopy VARCHAR2
2397 , p1_a134 out nocopy VARCHAR2
2398 , p1_a135 out nocopy VARCHAR2
2399 , p1_a136 out nocopy NUMBER
2400 , p1_a137 out nocopy VARCHAR2
2401 )
2402
2403 as
2404 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
2405 ddx_complete_rec ams_eventoffer_pvt.evo_rec_type;
2406 ddindx binary_integer; indx binary_integer;
2407 begin
2408
2409 -- copy data to the local IN or IN-OUT args, if any
2410 ddp_evo_rec.event_offer_id := p0_a0;
2411 ddp_evo_rec.last_update_date := p0_a1;
2412 ddp_evo_rec.last_updated_by := p0_a2;
2413 ddp_evo_rec.creation_date := p0_a3;
2414 ddp_evo_rec.created_by := p0_a4;
2415 ddp_evo_rec.last_update_login := p0_a5;
2416 ddp_evo_rec.object_version_number := p0_a6;
2417 ddp_evo_rec.application_id := p0_a7;
2418 ddp_evo_rec.event_header_id := p0_a8;
2419 ddp_evo_rec.private_flag := p0_a9;
2420 ddp_evo_rec.active_flag := p0_a10;
2421 ddp_evo_rec.source_code := p0_a11;
2422 ddp_evo_rec.event_level := p0_a12;
2423 ddp_evo_rec.user_status_id := p0_a13;
2424 ddp_evo_rec.last_status_date := p0_a14;
2425 ddp_evo_rec.system_status_code := p0_a15;
2426 ddp_evo_rec.event_type_code := p0_a16;
2427 ddp_evo_rec.event_delivery_method_id := p0_a17;
2428 ddp_evo_rec.event_delivery_method_code := p0_a18;
2429 ddp_evo_rec.event_required_flag := p0_a19;
2430 ddp_evo_rec.event_language_code := p0_a20;
2431 ddp_evo_rec.event_location_id := p0_a21;
2432 ddp_evo_rec.city := p0_a22;
2433 ddp_evo_rec.state := p0_a23;
2434 ddp_evo_rec.province := p0_a24;
2435 ddp_evo_rec.country := p0_a25;
2436 ddp_evo_rec.overflow_flag := p0_a26;
2437 ddp_evo_rec.partner_flag := p0_a27;
2438 ddp_evo_rec.event_standalone_flag := p0_a28;
2439 ddp_evo_rec.reg_frozen_flag := p0_a29;
2440 ddp_evo_rec.reg_required_flag := p0_a30;
2441 ddp_evo_rec.reg_charge_flag := p0_a31;
2442 ddp_evo_rec.reg_invited_only_flag := p0_a32;
2443 ddp_evo_rec.reg_waitlist_allowed_flag := p0_a33;
2444 ddp_evo_rec.reg_overbook_allowed_flag := p0_a34;
2445 ddp_evo_rec.parent_event_offer_id := p0_a35;
2446 ddp_evo_rec.event_duration := p0_a36;
2447 ddp_evo_rec.event_duration_uom_code := p0_a37;
2448 ddp_evo_rec.event_start_date := p0_a38;
2449 ddp_evo_rec.event_start_date_time := p0_a39;
2450 ddp_evo_rec.event_end_date := p0_a40;
2451 ddp_evo_rec.event_end_date_time := p0_a41;
2452 ddp_evo_rec.reg_start_date := p0_a42;
2453 ddp_evo_rec.reg_start_time := p0_a43;
2454 ddp_evo_rec.reg_end_date := p0_a44;
2455 ddp_evo_rec.reg_end_time := p0_a45;
2456 ddp_evo_rec.reg_maximum_capacity := p0_a46;
2457 ddp_evo_rec.reg_overbook_pct := p0_a47;
2458 ddp_evo_rec.reg_effective_capacity := p0_a48;
2459 ddp_evo_rec.reg_waitlist_pct := p0_a49;
2460 ddp_evo_rec.reg_minimum_capacity := p0_a50;
2461 ddp_evo_rec.reg_minimum_req_by_date := p0_a51;
2462 ddp_evo_rec.inventory_item_id := p0_a52;
2463 ddp_evo_rec.inventory_item := p0_a53;
2464 ddp_evo_rec.organization_id := p0_a54;
2465 ddp_evo_rec.pricelist_header_id := p0_a55;
2466 ddp_evo_rec.pricelist_line_id := p0_a56;
2467 ddp_evo_rec.org_id := p0_a57;
2468 ddp_evo_rec.waitlist_action_type_code := p0_a58;
2469 ddp_evo_rec.stream_type_code := p0_a59;
2470 ddp_evo_rec.owner_user_id := p0_a60;
2471 ddp_evo_rec.event_full_flag := p0_a61;
2472 ddp_evo_rec.forecasted_revenue := p0_a62;
2473 ddp_evo_rec.actual_revenue := p0_a63;
2474 ddp_evo_rec.forecasted_cost := p0_a64;
2475 ddp_evo_rec.actual_cost := p0_a65;
2476 ddp_evo_rec.fund_source_type_code := p0_a66;
2477 ddp_evo_rec.fund_source_id := p0_a67;
2478 ddp_evo_rec.cert_credit_type_code := p0_a68;
2479 ddp_evo_rec.certification_credits := p0_a69;
2480 ddp_evo_rec.coordinator_id := p0_a70;
2481 ddp_evo_rec.priority_type_code := p0_a71;
2482 ddp_evo_rec.cancellation_reason_code := p0_a72;
2483 ddp_evo_rec.auto_register_flag := p0_a73;
2484 ddp_evo_rec.email := p0_a74;
2485 ddp_evo_rec.phone := p0_a75;
2486 ddp_evo_rec.fund_amount_tc := p0_a76;
2487 ddp_evo_rec.fund_amount_fc := p0_a77;
2488 ddp_evo_rec.currency_code_tc := p0_a78;
2489 ddp_evo_rec.currency_code_fc := p0_a79;
2490 ddp_evo_rec.url := p0_a80;
2491 ddp_evo_rec.timezone_id := p0_a81;
2492 ddp_evo_rec.event_venue_id := p0_a82;
2493 ddp_evo_rec.pricelist_header_currency_code := p0_a83;
2494 ddp_evo_rec.pricelist_list_price := p0_a84;
2495 ddp_evo_rec.inbound_script_name := p0_a85;
2496 ddp_evo_rec.attribute_category := p0_a86;
2497 ddp_evo_rec.attribute1 := p0_a87;
2498 ddp_evo_rec.attribute2 := p0_a88;
2499 ddp_evo_rec.attribute3 := p0_a89;
2500 ddp_evo_rec.attribute4 := p0_a90;
2501 ddp_evo_rec.attribute5 := p0_a91;
2502 ddp_evo_rec.attribute6 := p0_a92;
2503 ddp_evo_rec.attribute7 := p0_a93;
2504 ddp_evo_rec.attribute8 := p0_a94;
2505 ddp_evo_rec.attribute9 := p0_a95;
2506 ddp_evo_rec.attribute10 := p0_a96;
2507 ddp_evo_rec.attribute11 := p0_a97;
2508 ddp_evo_rec.attribute12 := p0_a98;
2509 ddp_evo_rec.attribute13 := p0_a99;
2510 ddp_evo_rec.attribute14 := p0_a100;
2511 ddp_evo_rec.attribute15 := p0_a101;
2512 ddp_evo_rec.event_offer_name := p0_a102;
2513 ddp_evo_rec.event_mktg_message := p0_a103;
2514 ddp_evo_rec.description := p0_a104;
2515 ddp_evo_rec.custom_setup_id := p0_a105;
2516 ddp_evo_rec.country_code := p0_a106;
2517 ddp_evo_rec.business_unit_id := p0_a107;
2518 ddp_evo_rec.event_calendar := p0_a108;
2519 ddp_evo_rec.start_period_name := p0_a109;
2520 ddp_evo_rec.end_period_name := p0_a110;
2521 ddp_evo_rec.global_flag := p0_a111;
2522 ddp_evo_rec.task_id := p0_a112;
2523 ddp_evo_rec.parent_type := p0_a113;
2524 ddp_evo_rec.parent_id := p0_a114;
2525 ddp_evo_rec.create_attendant_lead_flag := p0_a115;
2526 ddp_evo_rec.create_registrant_lead_flag := p0_a116;
2527 ddp_evo_rec.event_object_type := p0_a117;
2528 ddp_evo_rec.reg_timezone_id := p0_a118;
2529 ddp_evo_rec.event_password := p0_a119;
2530 ddp_evo_rec.record_event_flag := p0_a120;
2531 ddp_evo_rec.allow_register_in_middle_flag := p0_a121;
2532 ddp_evo_rec.publish_attendees_flag := p0_a122;
2533 ddp_evo_rec.direct_join_flag := p0_a123;
2534 ddp_evo_rec.event_notification_method := p0_a124;
2535 ddp_evo_rec.actual_start_time := p0_a125;
2536 ddp_evo_rec.actual_end_time := p0_a126;
2537 ddp_evo_rec.server_id := p0_a127;
2538 ddp_evo_rec.owner_fnd_user_id := p0_a128;
2539 ddp_evo_rec.meeting_dial_in_info := p0_a129;
2540 ddp_evo_rec.meeting_email_subject := p0_a130;
2541 ddp_evo_rec.meeting_schedule_type := p0_a131;
2542 ddp_evo_rec.meeting_status := p0_a132;
2543 ddp_evo_rec.meeting_misc_info := p0_a133;
2544 ddp_evo_rec.publish_flag := p0_a134;
2545 ddp_evo_rec.meeting_encryption_key_code := p0_a135;
2546 ddp_evo_rec.number_of_attendees := p0_a136;
2547 ddp_evo_rec.event_purpose_code := p0_a137;
2548
2549
2550 -- here's the delegated call to the old PL/SQL routine
2551 ams_eventoffer_pvt.complete_evo_rec(ddp_evo_rec,
2552 ddx_complete_rec);
2553
2554 -- copy data back from the local variables to OUT or IN-OUT args, if any
2555
2556 p1_a0 := ddx_complete_rec.event_offer_id;
2557 p1_a1 := ddx_complete_rec.last_update_date;
2558 p1_a2 := ddx_complete_rec.last_updated_by;
2559 p1_a3 := ddx_complete_rec.creation_date;
2560 p1_a4 := ddx_complete_rec.created_by;
2561 p1_a5 := ddx_complete_rec.last_update_login;
2562 p1_a6 := ddx_complete_rec.object_version_number;
2563 p1_a7 := ddx_complete_rec.application_id;
2564 p1_a8 := ddx_complete_rec.event_header_id;
2565 p1_a9 := ddx_complete_rec.private_flag;
2566 p1_a10 := ddx_complete_rec.active_flag;
2567 p1_a11 := ddx_complete_rec.source_code;
2568 p1_a12 := ddx_complete_rec.event_level;
2569 p1_a13 := ddx_complete_rec.user_status_id;
2570 p1_a14 := ddx_complete_rec.last_status_date;
2571 p1_a15 := ddx_complete_rec.system_status_code;
2572 p1_a16 := ddx_complete_rec.event_type_code;
2573 p1_a17 := ddx_complete_rec.event_delivery_method_id;
2574 p1_a18 := ddx_complete_rec.event_delivery_method_code;
2575 p1_a19 := ddx_complete_rec.event_required_flag;
2576 p1_a20 := ddx_complete_rec.event_language_code;
2577 p1_a21 := ddx_complete_rec.event_location_id;
2578 p1_a22 := ddx_complete_rec.city;
2579 p1_a23 := ddx_complete_rec.state;
2580 p1_a24 := ddx_complete_rec.province;
2581 p1_a25 := ddx_complete_rec.country;
2582 p1_a26 := ddx_complete_rec.overflow_flag;
2583 p1_a27 := ddx_complete_rec.partner_flag;
2584 p1_a28 := ddx_complete_rec.event_standalone_flag;
2585 p1_a29 := ddx_complete_rec.reg_frozen_flag;
2586 p1_a30 := ddx_complete_rec.reg_required_flag;
2587 p1_a31 := ddx_complete_rec.reg_charge_flag;
2588 p1_a32 := ddx_complete_rec.reg_invited_only_flag;
2589 p1_a33 := ddx_complete_rec.reg_waitlist_allowed_flag;
2590 p1_a34 := ddx_complete_rec.reg_overbook_allowed_flag;
2591 p1_a35 := ddx_complete_rec.parent_event_offer_id;
2592 p1_a36 := ddx_complete_rec.event_duration;
2593 p1_a37 := ddx_complete_rec.event_duration_uom_code;
2594 p1_a38 := ddx_complete_rec.event_start_date;
2595 p1_a39 := ddx_complete_rec.event_start_date_time;
2596 p1_a40 := ddx_complete_rec.event_end_date;
2597 p1_a41 := ddx_complete_rec.event_end_date_time;
2598 p1_a42 := ddx_complete_rec.reg_start_date;
2599 p1_a43 := ddx_complete_rec.reg_start_time;
2600 p1_a44 := ddx_complete_rec.reg_end_date;
2601 p1_a45 := ddx_complete_rec.reg_end_time;
2602 p1_a46 := ddx_complete_rec.reg_maximum_capacity;
2603 p1_a47 := ddx_complete_rec.reg_overbook_pct;
2604 p1_a48 := ddx_complete_rec.reg_effective_capacity;
2605 p1_a49 := ddx_complete_rec.reg_waitlist_pct;
2606 p1_a50 := ddx_complete_rec.reg_minimum_capacity;
2607 p1_a51 := ddx_complete_rec.reg_minimum_req_by_date;
2608 p1_a52 := ddx_complete_rec.inventory_item_id;
2609 p1_a53 := ddx_complete_rec.inventory_item;
2610 p1_a54 := ddx_complete_rec.organization_id;
2611 p1_a55 := ddx_complete_rec.pricelist_header_id;
2612 p1_a56 := ddx_complete_rec.pricelist_line_id;
2613 p1_a57 := ddx_complete_rec.org_id;
2614 p1_a58 := ddx_complete_rec.waitlist_action_type_code;
2615 p1_a59 := ddx_complete_rec.stream_type_code;
2616 p1_a60 := ddx_complete_rec.owner_user_id;
2617 p1_a61 := ddx_complete_rec.event_full_flag;
2618 p1_a62 := ddx_complete_rec.forecasted_revenue;
2619 p1_a63 := ddx_complete_rec.actual_revenue;
2620 p1_a64 := ddx_complete_rec.forecasted_cost;
2621 p1_a65 := ddx_complete_rec.actual_cost;
2622 p1_a66 := ddx_complete_rec.fund_source_type_code;
2623 p1_a67 := ddx_complete_rec.fund_source_id;
2624 p1_a68 := ddx_complete_rec.cert_credit_type_code;
2625 p1_a69 := ddx_complete_rec.certification_credits;
2626 p1_a70 := ddx_complete_rec.coordinator_id;
2627 p1_a71 := ddx_complete_rec.priority_type_code;
2628 p1_a72 := ddx_complete_rec.cancellation_reason_code;
2629 p1_a73 := ddx_complete_rec.auto_register_flag;
2630 p1_a74 := ddx_complete_rec.email;
2631 p1_a75 := ddx_complete_rec.phone;
2632 p1_a76 := ddx_complete_rec.fund_amount_tc;
2633 p1_a77 := ddx_complete_rec.fund_amount_fc;
2634 p1_a78 := ddx_complete_rec.currency_code_tc;
2635 p1_a79 := ddx_complete_rec.currency_code_fc;
2636 p1_a80 := ddx_complete_rec.url;
2637 p1_a81 := ddx_complete_rec.timezone_id;
2638 p1_a82 := ddx_complete_rec.event_venue_id;
2639 p1_a83 := ddx_complete_rec.pricelist_header_currency_code;
2640 p1_a84 := ddx_complete_rec.pricelist_list_price;
2641 p1_a85 := ddx_complete_rec.inbound_script_name;
2642 p1_a86 := ddx_complete_rec.attribute_category;
2643 p1_a87 := ddx_complete_rec.attribute1;
2644 p1_a88 := ddx_complete_rec.attribute2;
2645 p1_a89 := ddx_complete_rec.attribute3;
2646 p1_a90 := ddx_complete_rec.attribute4;
2647 p1_a91 := ddx_complete_rec.attribute5;
2648 p1_a92 := ddx_complete_rec.attribute6;
2649 p1_a93 := ddx_complete_rec.attribute7;
2650 p1_a94 := ddx_complete_rec.attribute8;
2651 p1_a95 := ddx_complete_rec.attribute9;
2652 p1_a96 := ddx_complete_rec.attribute10;
2653 p1_a97 := ddx_complete_rec.attribute11;
2654 p1_a98 := ddx_complete_rec.attribute12;
2655 p1_a99 := ddx_complete_rec.attribute13;
2656 p1_a100 := ddx_complete_rec.attribute14;
2657 p1_a101 := ddx_complete_rec.attribute15;
2658 p1_a102 := ddx_complete_rec.event_offer_name;
2659 p1_a103 := ddx_complete_rec.event_mktg_message;
2660 p1_a104 := ddx_complete_rec.description;
2661 p1_a105 := ddx_complete_rec.custom_setup_id;
2662 p1_a106 := ddx_complete_rec.country_code;
2663 p1_a107 := ddx_complete_rec.business_unit_id;
2664 p1_a108 := ddx_complete_rec.event_calendar;
2665 p1_a109 := ddx_complete_rec.start_period_name;
2666 p1_a110 := ddx_complete_rec.end_period_name;
2667 p1_a111 := ddx_complete_rec.global_flag;
2668 p1_a112 := ddx_complete_rec.task_id;
2669 p1_a113 := ddx_complete_rec.parent_type;
2670 p1_a114 := ddx_complete_rec.parent_id;
2671 p1_a115 := ddx_complete_rec.create_attendant_lead_flag;
2672 p1_a116 := ddx_complete_rec.create_registrant_lead_flag;
2673 p1_a117 := ddx_complete_rec.event_object_type;
2674 p1_a118 := ddx_complete_rec.reg_timezone_id;
2675 p1_a119 := ddx_complete_rec.event_password;
2676 p1_a120 := ddx_complete_rec.record_event_flag;
2677 p1_a121 := ddx_complete_rec.allow_register_in_middle_flag;
2678 p1_a122 := ddx_complete_rec.publish_attendees_flag;
2679 p1_a123 := ddx_complete_rec.direct_join_flag;
2680 p1_a124 := ddx_complete_rec.event_notification_method;
2681 p1_a125 := ddx_complete_rec.actual_start_time;
2682 p1_a126 := ddx_complete_rec.actual_end_time;
2683 p1_a127 := ddx_complete_rec.server_id;
2684 p1_a128 := ddx_complete_rec.owner_fnd_user_id;
2685 p1_a129 := ddx_complete_rec.meeting_dial_in_info;
2686 p1_a130 := ddx_complete_rec.meeting_email_subject;
2687 p1_a131 := ddx_complete_rec.meeting_schedule_type;
2688 p1_a132 := ddx_complete_rec.meeting_status;
2689 p1_a133 := ddx_complete_rec.meeting_misc_info;
2690 p1_a134 := ddx_complete_rec.publish_flag;
2691 p1_a135 := ddx_complete_rec.meeting_encryption_key_code;
2692 p1_a136 := ddx_complete_rec.number_of_attendees;
2693 p1_a137 := ddx_complete_rec.event_purpose_code;
2694 end;
2695
2696 end ams_eventoffer_pvt_w_new;