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