[Home] [Help]
PACKAGE BODY: APPS.AMS_EVENTOFFER_PUB_W
Source
1 package body ams_eventoffer_pub_w as
2 /* $Header: amswevob.pls 115.21 2003/05/31 00:28:45 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 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 procedure create_eventoffer(p_api_version NUMBER
14 , p_init_msg_list VARCHAR2
15 , p_commit VARCHAR2
16 , p_validation_level NUMBER
17 , x_return_status out nocopy VARCHAR2
18 , x_msg_count out nocopy NUMBER
19 , x_msg_data out nocopy VARCHAR2
20 , x_evo_id out nocopy NUMBER
21 , p7_a0 NUMBER := 0-1962.0724
22 , p7_a1 DATE := fnd_api.g_miss_date
23 , p7_a2 NUMBER := 0-1962.0724
24 , p7_a3 DATE := fnd_api.g_miss_date
25 , p7_a4 NUMBER := 0-1962.0724
26 , p7_a5 NUMBER := 0-1962.0724
27 , p7_a6 NUMBER := 0-1962.0724
28 , p7_a7 NUMBER := 0-1962.0724
29 , p7_a8 NUMBER := 0-1962.0724
30 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
31 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
32 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
33 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
34 , p7_a13 NUMBER := 0-1962.0724
35 , p7_a14 DATE := fnd_api.g_miss_date
36 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
37 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
38 , p7_a17 NUMBER := 0-1962.0724
39 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a21 NUMBER := 0-1962.0724
43 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a35 NUMBER := 0-1962.0724
57 , p7_a36 NUMBER := 0-1962.0724
58 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a38 DATE := fnd_api.g_miss_date
60 , p7_a39 DATE := fnd_api.g_miss_date
61 , p7_a40 DATE := fnd_api.g_miss_date
62 , p7_a41 DATE := fnd_api.g_miss_date
63 , p7_a42 DATE := fnd_api.g_miss_date
64 , p7_a43 DATE := fnd_api.g_miss_date
65 , p7_a44 DATE := fnd_api.g_miss_date
66 , p7_a45 DATE := fnd_api.g_miss_date
67 , p7_a46 NUMBER := 0-1962.0724
68 , p7_a47 NUMBER := 0-1962.0724
69 , p7_a48 NUMBER := 0-1962.0724
70 , p7_a49 NUMBER := 0-1962.0724
71 , p7_a50 NUMBER := 0-1962.0724
72 , p7_a51 DATE := fnd_api.g_miss_date
73 , p7_a52 NUMBER := 0-1962.0724
74 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a54 NUMBER := 0-1962.0724
76 , p7_a55 NUMBER := 0-1962.0724
77 , p7_a56 NUMBER := 0-1962.0724
78 , p7_a57 NUMBER := 0-1962.0724
79 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a60 NUMBER := 0-1962.0724
82 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a62 NUMBER := 0-1962.0724
84 , p7_a63 NUMBER := 0-1962.0724
85 , p7_a64 NUMBER := 0-1962.0724
86 , p7_a65 NUMBER := 0-1962.0724
87 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a67 NUMBER := 0-1962.0724
89 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a69 NUMBER := 0-1962.0724
91 , p7_a70 NUMBER := 0-1962.0724
92 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a76 NUMBER := 0-1962.0724
98 , p7_a77 NUMBER := 0-1962.0724
99 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
101 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a81 NUMBER := 0-1962.0724
103 , p7_a82 NUMBER := 0-1962.0724
104 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a84 NUMBER := 0-1962.0724
106 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
114 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
115 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
116 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
117 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
119 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
120 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
124 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
125 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
126 , p7_a105 NUMBER := 0-1962.0724
127 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a107 NUMBER := 0-1962.0724
129 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a112 NUMBER := 0-1962.0724
134 , p7_a113 VARCHAR2 := fnd_api.g_miss_char
135 , p7_a114 NUMBER := 0-1962.0724
136 , p7_a115 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a116 VARCHAR2 := fnd_api.g_miss_char
138 , p7_a117 VARCHAR2 := fnd_api.g_miss_char
139 , p7_a118 NUMBER := 0-1962.0724
140 , p7_a119 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a120 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a121 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a122 VARCHAR2 := fnd_api.g_miss_char
144 , p7_a123 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a124 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a125 DATE := fnd_api.g_miss_date
147 , p7_a126 DATE := fnd_api.g_miss_date
148 , p7_a127 NUMBER := 0-1962.0724
149 , p7_a128 NUMBER := 0-1962.0724
150 , p7_a129 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a130 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a131 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a132 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a133 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a134 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a135 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a136 NUMBER := 0-1962.0724
158 , p7_a137 VARCHAR2 := fnd_api.g_miss_char
159 )
160
161 as
162 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
163 ddindx binary_integer; indx binary_integer;
164 begin
165
166 -- copy data to the local IN or IN-OUT args, if any
167
168
169
170
171
172
173
174 ddp_evo_rec.event_offer_id := p7_a0;
175 ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
176 ddp_evo_rec.last_updated_by := p7_a2;
177 ddp_evo_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
178 ddp_evo_rec.created_by := p7_a4;
179 ddp_evo_rec.last_update_login := p7_a5;
180 ddp_evo_rec.object_version_number := p7_a6;
181 ddp_evo_rec.application_id := p7_a7;
182 ddp_evo_rec.event_header_id := p7_a8;
183 ddp_evo_rec.private_flag := p7_a9;
184 ddp_evo_rec.active_flag := p7_a10;
185 ddp_evo_rec.source_code := p7_a11;
186 ddp_evo_rec.event_level := p7_a12;
187 ddp_evo_rec.user_status_id := p7_a13;
188 ddp_evo_rec.last_status_date := rosetta_g_miss_date_in_map(p7_a14);
189 ddp_evo_rec.system_status_code := p7_a15;
190 ddp_evo_rec.event_type_code := p7_a16;
191 ddp_evo_rec.event_delivery_method_id := p7_a17;
192 ddp_evo_rec.event_delivery_method_code := p7_a18;
193 ddp_evo_rec.event_required_flag := p7_a19;
194 ddp_evo_rec.event_language_code := p7_a20;
195 ddp_evo_rec.event_location_id := p7_a21;
196 ddp_evo_rec.city := p7_a22;
197 ddp_evo_rec.state := p7_a23;
198 ddp_evo_rec.province := p7_a24;
199 ddp_evo_rec.country := p7_a25;
200 ddp_evo_rec.overflow_flag := p7_a26;
201 ddp_evo_rec.partner_flag := p7_a27;
202 ddp_evo_rec.event_standalone_flag := p7_a28;
203 ddp_evo_rec.reg_frozen_flag := p7_a29;
204 ddp_evo_rec.reg_required_flag := p7_a30;
205 ddp_evo_rec.reg_charge_flag := p7_a31;
206 ddp_evo_rec.reg_invited_only_flag := p7_a32;
207 ddp_evo_rec.reg_waitlist_allowed_flag := p7_a33;
208 ddp_evo_rec.reg_overbook_allowed_flag := p7_a34;
209 ddp_evo_rec.parent_event_offer_id := p7_a35;
210 ddp_evo_rec.event_duration := p7_a36;
211 ddp_evo_rec.event_duration_uom_code := p7_a37;
212 ddp_evo_rec.event_start_date := rosetta_g_miss_date_in_map(p7_a38);
213 ddp_evo_rec.event_start_date_time := rosetta_g_miss_date_in_map(p7_a39);
214 ddp_evo_rec.event_end_date := rosetta_g_miss_date_in_map(p7_a40);
215 ddp_evo_rec.event_end_date_time := rosetta_g_miss_date_in_map(p7_a41);
216 ddp_evo_rec.reg_start_date := rosetta_g_miss_date_in_map(p7_a42);
217 ddp_evo_rec.reg_start_time := rosetta_g_miss_date_in_map(p7_a43);
218 ddp_evo_rec.reg_end_date := rosetta_g_miss_date_in_map(p7_a44);
219 ddp_evo_rec.reg_end_time := rosetta_g_miss_date_in_map(p7_a45);
220 ddp_evo_rec.reg_maximum_capacity := p7_a46;
221 ddp_evo_rec.reg_overbook_pct := p7_a47;
222 ddp_evo_rec.reg_effective_capacity := p7_a48;
223 ddp_evo_rec.reg_waitlist_pct := p7_a49;
224 ddp_evo_rec.reg_minimum_capacity := p7_a50;
225 ddp_evo_rec.reg_minimum_req_by_date := rosetta_g_miss_date_in_map(p7_a51);
226 ddp_evo_rec.inventory_item_id := p7_a52;
227 ddp_evo_rec.inventory_item := p7_a53;
228 ddp_evo_rec.organization_id := p7_a54;
229 ddp_evo_rec.pricelist_header_id := p7_a55;
230 ddp_evo_rec.pricelist_line_id := p7_a56;
231 ddp_evo_rec.org_id := p7_a57;
232 ddp_evo_rec.waitlist_action_type_code := p7_a58;
233 ddp_evo_rec.stream_type_code := p7_a59;
234 ddp_evo_rec.owner_user_id := p7_a60;
235 ddp_evo_rec.event_full_flag := p7_a61;
236 ddp_evo_rec.forecasted_revenue := p7_a62;
237 ddp_evo_rec.actual_revenue := p7_a63;
238 ddp_evo_rec.forecasted_cost := p7_a64;
239 ddp_evo_rec.actual_cost := p7_a65;
240 ddp_evo_rec.fund_source_type_code := p7_a66;
241 ddp_evo_rec.fund_source_id := p7_a67;
242 ddp_evo_rec.cert_credit_type_code := p7_a68;
243 ddp_evo_rec.certification_credits := p7_a69;
244 ddp_evo_rec.coordinator_id := p7_a70;
245 ddp_evo_rec.priority_type_code := p7_a71;
246 ddp_evo_rec.cancellation_reason_code := p7_a72;
247 ddp_evo_rec.auto_register_flag := p7_a73;
248 ddp_evo_rec.email := p7_a74;
249 ddp_evo_rec.phone := p7_a75;
250 ddp_evo_rec.fund_amount_tc := p7_a76;
251 ddp_evo_rec.fund_amount_fc := p7_a77;
252 ddp_evo_rec.currency_code_tc := p7_a78;
253 ddp_evo_rec.currency_code_fc := p7_a79;
254 ddp_evo_rec.url := p7_a80;
255 ddp_evo_rec.timezone_id := p7_a81;
256 ddp_evo_rec.event_venue_id := p7_a82;
257 ddp_evo_rec.pricelist_header_currency_code := p7_a83;
258 ddp_evo_rec.pricelist_list_price := p7_a84;
259 ddp_evo_rec.inbound_script_name := p7_a85;
260 ddp_evo_rec.attribute_category := p7_a86;
261 ddp_evo_rec.attribute1 := p7_a87;
262 ddp_evo_rec.attribute2 := p7_a88;
263 ddp_evo_rec.attribute3 := p7_a89;
264 ddp_evo_rec.attribute4 := p7_a90;
265 ddp_evo_rec.attribute5 := p7_a91;
266 ddp_evo_rec.attribute6 := p7_a92;
267 ddp_evo_rec.attribute7 := p7_a93;
268 ddp_evo_rec.attribute8 := p7_a94;
269 ddp_evo_rec.attribute9 := p7_a95;
270 ddp_evo_rec.attribute10 := p7_a96;
271 ddp_evo_rec.attribute11 := p7_a97;
272 ddp_evo_rec.attribute12 := p7_a98;
273 ddp_evo_rec.attribute13 := p7_a99;
274 ddp_evo_rec.attribute14 := p7_a100;
275 ddp_evo_rec.attribute15 := p7_a101;
276 ddp_evo_rec.event_offer_name := p7_a102;
277 ddp_evo_rec.event_mktg_message := p7_a103;
278 ddp_evo_rec.description := p7_a104;
279 ddp_evo_rec.custom_setup_id := p7_a105;
280 ddp_evo_rec.country_code := p7_a106;
281 ddp_evo_rec.business_unit_id := p7_a107;
282 ddp_evo_rec.event_calendar := p7_a108;
283 ddp_evo_rec.start_period_name := p7_a109;
284 ddp_evo_rec.end_period_name := p7_a110;
285 ddp_evo_rec.global_flag := p7_a111;
286 ddp_evo_rec.task_id := p7_a112;
287 ddp_evo_rec.parent_type := p7_a113;
288 ddp_evo_rec.parent_id := p7_a114;
289 ddp_evo_rec.create_attendant_lead_flag := p7_a115;
290 ddp_evo_rec.create_registrant_lead_flag := p7_a116;
291 ddp_evo_rec.event_object_type := p7_a117;
292 ddp_evo_rec.reg_timezone_id := p7_a118;
293 ddp_evo_rec.event_password := p7_a119;
294 ddp_evo_rec.record_event_flag := p7_a120;
295 ddp_evo_rec.allow_register_in_middle_flag := p7_a121;
296 ddp_evo_rec.publish_attendees_flag := p7_a122;
297 ddp_evo_rec.direct_join_flag := p7_a123;
298 ddp_evo_rec.event_notification_method := p7_a124;
299 ddp_evo_rec.actual_start_time := rosetta_g_miss_date_in_map(p7_a125);
300 ddp_evo_rec.actual_end_time := rosetta_g_miss_date_in_map(p7_a126);
301 ddp_evo_rec.server_id := p7_a127;
302 ddp_evo_rec.owner_fnd_user_id := p7_a128;
303 ddp_evo_rec.meeting_dial_in_info := p7_a129;
304 ddp_evo_rec.meeting_email_subject := p7_a130;
305 ddp_evo_rec.meeting_schedule_type := p7_a131;
306 ddp_evo_rec.meeting_status := p7_a132;
307 ddp_evo_rec.meeting_misc_info := p7_a133;
308 ddp_evo_rec.publish_flag := p7_a134;
309 ddp_evo_rec.meeting_encryption_key_code := p7_a135;
310 ddp_evo_rec.number_of_attendees := p7_a136;
311 ddp_evo_rec.event_purpose_code := p7_a137;
312
313
314 -- here's the delegated call to the old PL/SQL routine
315 ams_eventoffer_pub.create_eventoffer(p_api_version,
316 p_init_msg_list,
317 p_commit,
318 p_validation_level,
319 x_return_status,
320 x_msg_count,
321 x_msg_data,
322 ddp_evo_rec,
323 x_evo_id);
324
325 -- copy data back from the local variables to OUT or IN-OUT args, if any
326
327
328
329
330
331
332
333
334 end;
335
336 procedure update_eventoffer(p_api_version NUMBER
337 , p_init_msg_list VARCHAR2
338 , p_commit VARCHAR2
339 , p_validation_level NUMBER
340 , x_return_status out nocopy VARCHAR2
341 , x_msg_count out nocopy NUMBER
342 , x_msg_data out nocopy VARCHAR2
343 , p7_a0 NUMBER := 0-1962.0724
344 , p7_a1 DATE := fnd_api.g_miss_date
345 , p7_a2 NUMBER := 0-1962.0724
346 , p7_a3 DATE := fnd_api.g_miss_date
347 , p7_a4 NUMBER := 0-1962.0724
348 , p7_a5 NUMBER := 0-1962.0724
349 , p7_a6 NUMBER := 0-1962.0724
350 , p7_a7 NUMBER := 0-1962.0724
351 , p7_a8 NUMBER := 0-1962.0724
352 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a13 NUMBER := 0-1962.0724
357 , p7_a14 DATE := fnd_api.g_miss_date
358 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
359 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
360 , p7_a17 NUMBER := 0-1962.0724
361 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
362 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
363 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
364 , p7_a21 NUMBER := 0-1962.0724
365 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
368 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
370 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a35 NUMBER := 0-1962.0724
379 , p7_a36 NUMBER := 0-1962.0724
380 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a38 DATE := fnd_api.g_miss_date
382 , p7_a39 DATE := fnd_api.g_miss_date
383 , p7_a40 DATE := fnd_api.g_miss_date
384 , p7_a41 DATE := fnd_api.g_miss_date
385 , p7_a42 DATE := fnd_api.g_miss_date
386 , p7_a43 DATE := fnd_api.g_miss_date
387 , p7_a44 DATE := fnd_api.g_miss_date
388 , p7_a45 DATE := fnd_api.g_miss_date
389 , p7_a46 NUMBER := 0-1962.0724
390 , p7_a47 NUMBER := 0-1962.0724
391 , p7_a48 NUMBER := 0-1962.0724
392 , p7_a49 NUMBER := 0-1962.0724
393 , p7_a50 NUMBER := 0-1962.0724
394 , p7_a51 DATE := fnd_api.g_miss_date
395 , p7_a52 NUMBER := 0-1962.0724
396 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
397 , p7_a54 NUMBER := 0-1962.0724
398 , p7_a55 NUMBER := 0-1962.0724
399 , p7_a56 NUMBER := 0-1962.0724
400 , p7_a57 NUMBER := 0-1962.0724
401 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
402 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
403 , p7_a60 NUMBER := 0-1962.0724
404 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a62 NUMBER := 0-1962.0724
406 , p7_a63 NUMBER := 0-1962.0724
407 , p7_a64 NUMBER := 0-1962.0724
408 , p7_a65 NUMBER := 0-1962.0724
409 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a67 NUMBER := 0-1962.0724
411 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a69 NUMBER := 0-1962.0724
413 , p7_a70 NUMBER := 0-1962.0724
414 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
415 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
416 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
417 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
418 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
419 , p7_a76 NUMBER := 0-1962.0724
420 , p7_a77 NUMBER := 0-1962.0724
421 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
422 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
423 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
424 , p7_a81 NUMBER := 0-1962.0724
425 , p7_a82 NUMBER := 0-1962.0724
426 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
427 , p7_a84 NUMBER := 0-1962.0724
428 , p7_a85 VARCHAR2 := fnd_api.g_miss_char
429 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
430 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
431 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
432 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
433 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
434 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
435 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
436 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
437 , p7_a94 VARCHAR2 := fnd_api.g_miss_char
438 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
439 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
440 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
441 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
442 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
443 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
444 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
445 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
446 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
447 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
448 , p7_a105 NUMBER := 0-1962.0724
449 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
450 , p7_a107 NUMBER := 0-1962.0724
451 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
452 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
453 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
454 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
455 , p7_a112 NUMBER := 0-1962.0724
456 , p7_a113 VARCHAR2 := fnd_api.g_miss_char
457 , p7_a114 NUMBER := 0-1962.0724
458 , p7_a115 VARCHAR2 := fnd_api.g_miss_char
459 , p7_a116 VARCHAR2 := fnd_api.g_miss_char
460 , p7_a117 VARCHAR2 := fnd_api.g_miss_char
461 , p7_a118 NUMBER := 0-1962.0724
462 , p7_a119 VARCHAR2 := fnd_api.g_miss_char
463 , p7_a120 VARCHAR2 := fnd_api.g_miss_char
464 , p7_a121 VARCHAR2 := fnd_api.g_miss_char
465 , p7_a122 VARCHAR2 := fnd_api.g_miss_char
466 , p7_a123 VARCHAR2 := fnd_api.g_miss_char
467 , p7_a124 VARCHAR2 := fnd_api.g_miss_char
468 , p7_a125 DATE := fnd_api.g_miss_date
469 , p7_a126 DATE := fnd_api.g_miss_date
470 , p7_a127 NUMBER := 0-1962.0724
471 , p7_a128 NUMBER := 0-1962.0724
472 , p7_a129 VARCHAR2 := fnd_api.g_miss_char
473 , p7_a130 VARCHAR2 := fnd_api.g_miss_char
474 , p7_a131 VARCHAR2 := fnd_api.g_miss_char
475 , p7_a132 VARCHAR2 := fnd_api.g_miss_char
476 , p7_a133 VARCHAR2 := fnd_api.g_miss_char
477 , p7_a134 VARCHAR2 := fnd_api.g_miss_char
478 , p7_a135 VARCHAR2 := fnd_api.g_miss_char
479 , p7_a136 NUMBER := 0-1962.0724
480 , p7_a137 VARCHAR2 := fnd_api.g_miss_char
481 )
482
483 as
484 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
485 ddindx binary_integer; indx binary_integer;
486 begin
487
488 -- copy data to the local IN or IN-OUT args, if any
489
490
491
492
493
494
495
496 ddp_evo_rec.event_offer_id := p7_a0;
497 ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
498 ddp_evo_rec.last_updated_by := p7_a2;
499 ddp_evo_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
500 ddp_evo_rec.created_by := p7_a4;
501 ddp_evo_rec.last_update_login := p7_a5;
502 ddp_evo_rec.object_version_number := p7_a6;
503 ddp_evo_rec.application_id := p7_a7;
504 ddp_evo_rec.event_header_id := p7_a8;
505 ddp_evo_rec.private_flag := p7_a9;
506 ddp_evo_rec.active_flag := p7_a10;
507 ddp_evo_rec.source_code := p7_a11;
508 ddp_evo_rec.event_level := p7_a12;
509 ddp_evo_rec.user_status_id := p7_a13;
510 ddp_evo_rec.last_status_date := rosetta_g_miss_date_in_map(p7_a14);
511 ddp_evo_rec.system_status_code := p7_a15;
512 ddp_evo_rec.event_type_code := p7_a16;
513 ddp_evo_rec.event_delivery_method_id := p7_a17;
514 ddp_evo_rec.event_delivery_method_code := p7_a18;
515 ddp_evo_rec.event_required_flag := p7_a19;
516 ddp_evo_rec.event_language_code := p7_a20;
517 ddp_evo_rec.event_location_id := p7_a21;
518 ddp_evo_rec.city := p7_a22;
519 ddp_evo_rec.state := p7_a23;
520 ddp_evo_rec.province := p7_a24;
521 ddp_evo_rec.country := p7_a25;
522 ddp_evo_rec.overflow_flag := p7_a26;
523 ddp_evo_rec.partner_flag := p7_a27;
524 ddp_evo_rec.event_standalone_flag := p7_a28;
525 ddp_evo_rec.reg_frozen_flag := p7_a29;
526 ddp_evo_rec.reg_required_flag := p7_a30;
527 ddp_evo_rec.reg_charge_flag := p7_a31;
528 ddp_evo_rec.reg_invited_only_flag := p7_a32;
529 ddp_evo_rec.reg_waitlist_allowed_flag := p7_a33;
530 ddp_evo_rec.reg_overbook_allowed_flag := p7_a34;
531 ddp_evo_rec.parent_event_offer_id := p7_a35;
532 ddp_evo_rec.event_duration := p7_a36;
533 ddp_evo_rec.event_duration_uom_code := p7_a37;
534 ddp_evo_rec.event_start_date := rosetta_g_miss_date_in_map(p7_a38);
535 ddp_evo_rec.event_start_date_time := rosetta_g_miss_date_in_map(p7_a39);
536 ddp_evo_rec.event_end_date := rosetta_g_miss_date_in_map(p7_a40);
537 ddp_evo_rec.event_end_date_time := rosetta_g_miss_date_in_map(p7_a41);
538 ddp_evo_rec.reg_start_date := rosetta_g_miss_date_in_map(p7_a42);
539 ddp_evo_rec.reg_start_time := rosetta_g_miss_date_in_map(p7_a43);
540 ddp_evo_rec.reg_end_date := rosetta_g_miss_date_in_map(p7_a44);
541 ddp_evo_rec.reg_end_time := rosetta_g_miss_date_in_map(p7_a45);
542 ddp_evo_rec.reg_maximum_capacity := p7_a46;
543 ddp_evo_rec.reg_overbook_pct := p7_a47;
544 ddp_evo_rec.reg_effective_capacity := p7_a48;
545 ddp_evo_rec.reg_waitlist_pct := p7_a49;
546 ddp_evo_rec.reg_minimum_capacity := p7_a50;
547 ddp_evo_rec.reg_minimum_req_by_date := rosetta_g_miss_date_in_map(p7_a51);
548 ddp_evo_rec.inventory_item_id := p7_a52;
549 ddp_evo_rec.inventory_item := p7_a53;
550 ddp_evo_rec.organization_id := p7_a54;
551 ddp_evo_rec.pricelist_header_id := p7_a55;
552 ddp_evo_rec.pricelist_line_id := p7_a56;
553 ddp_evo_rec.org_id := p7_a57;
554 ddp_evo_rec.waitlist_action_type_code := p7_a58;
555 ddp_evo_rec.stream_type_code := p7_a59;
556 ddp_evo_rec.owner_user_id := p7_a60;
557 ddp_evo_rec.event_full_flag := p7_a61;
558 ddp_evo_rec.forecasted_revenue := p7_a62;
559 ddp_evo_rec.actual_revenue := p7_a63;
560 ddp_evo_rec.forecasted_cost := p7_a64;
561 ddp_evo_rec.actual_cost := p7_a65;
562 ddp_evo_rec.fund_source_type_code := p7_a66;
563 ddp_evo_rec.fund_source_id := p7_a67;
564 ddp_evo_rec.cert_credit_type_code := p7_a68;
565 ddp_evo_rec.certification_credits := p7_a69;
566 ddp_evo_rec.coordinator_id := p7_a70;
567 ddp_evo_rec.priority_type_code := p7_a71;
568 ddp_evo_rec.cancellation_reason_code := p7_a72;
569 ddp_evo_rec.auto_register_flag := p7_a73;
570 ddp_evo_rec.email := p7_a74;
571 ddp_evo_rec.phone := p7_a75;
572 ddp_evo_rec.fund_amount_tc := p7_a76;
573 ddp_evo_rec.fund_amount_fc := p7_a77;
574 ddp_evo_rec.currency_code_tc := p7_a78;
575 ddp_evo_rec.currency_code_fc := p7_a79;
576 ddp_evo_rec.url := p7_a80;
577 ddp_evo_rec.timezone_id := p7_a81;
578 ddp_evo_rec.event_venue_id := p7_a82;
579 ddp_evo_rec.pricelist_header_currency_code := p7_a83;
580 ddp_evo_rec.pricelist_list_price := p7_a84;
581 ddp_evo_rec.inbound_script_name := p7_a85;
582 ddp_evo_rec.attribute_category := p7_a86;
583 ddp_evo_rec.attribute1 := p7_a87;
584 ddp_evo_rec.attribute2 := p7_a88;
585 ddp_evo_rec.attribute3 := p7_a89;
586 ddp_evo_rec.attribute4 := p7_a90;
587 ddp_evo_rec.attribute5 := p7_a91;
588 ddp_evo_rec.attribute6 := p7_a92;
589 ddp_evo_rec.attribute7 := p7_a93;
590 ddp_evo_rec.attribute8 := p7_a94;
591 ddp_evo_rec.attribute9 := p7_a95;
592 ddp_evo_rec.attribute10 := p7_a96;
593 ddp_evo_rec.attribute11 := p7_a97;
594 ddp_evo_rec.attribute12 := p7_a98;
595 ddp_evo_rec.attribute13 := p7_a99;
596 ddp_evo_rec.attribute14 := p7_a100;
597 ddp_evo_rec.attribute15 := p7_a101;
598 ddp_evo_rec.event_offer_name := p7_a102;
599 ddp_evo_rec.event_mktg_message := p7_a103;
600 ddp_evo_rec.description := p7_a104;
601 ddp_evo_rec.custom_setup_id := p7_a105;
602 ddp_evo_rec.country_code := p7_a106;
603 ddp_evo_rec.business_unit_id := p7_a107;
604 ddp_evo_rec.event_calendar := p7_a108;
605 ddp_evo_rec.start_period_name := p7_a109;
606 ddp_evo_rec.end_period_name := p7_a110;
607 ddp_evo_rec.global_flag := p7_a111;
608 ddp_evo_rec.task_id := p7_a112;
609 ddp_evo_rec.parent_type := p7_a113;
610 ddp_evo_rec.parent_id := p7_a114;
611 ddp_evo_rec.create_attendant_lead_flag := p7_a115;
612 ddp_evo_rec.create_registrant_lead_flag := p7_a116;
613 ddp_evo_rec.event_object_type := p7_a117;
614 ddp_evo_rec.reg_timezone_id := p7_a118;
615 ddp_evo_rec.event_password := p7_a119;
616 ddp_evo_rec.record_event_flag := p7_a120;
617 ddp_evo_rec.allow_register_in_middle_flag := p7_a121;
618 ddp_evo_rec.publish_attendees_flag := p7_a122;
619 ddp_evo_rec.direct_join_flag := p7_a123;
620 ddp_evo_rec.event_notification_method := p7_a124;
621 ddp_evo_rec.actual_start_time := rosetta_g_miss_date_in_map(p7_a125);
622 ddp_evo_rec.actual_end_time := rosetta_g_miss_date_in_map(p7_a126);
623 ddp_evo_rec.server_id := p7_a127;
624 ddp_evo_rec.owner_fnd_user_id := p7_a128;
625 ddp_evo_rec.meeting_dial_in_info := p7_a129;
626 ddp_evo_rec.meeting_email_subject := p7_a130;
627 ddp_evo_rec.meeting_schedule_type := p7_a131;
628 ddp_evo_rec.meeting_status := p7_a132;
629 ddp_evo_rec.meeting_misc_info := p7_a133;
630 ddp_evo_rec.publish_flag := p7_a134;
631 ddp_evo_rec.meeting_encryption_key_code := p7_a135;
632 ddp_evo_rec.number_of_attendees := p7_a136;
633 ddp_evo_rec.event_purpose_code := p7_a137;
634
635 -- here's the delegated call to the old PL/SQL routine
636 ams_eventoffer_pub.update_eventoffer(p_api_version,
637 p_init_msg_list,
638 p_commit,
639 p_validation_level,
640 x_return_status,
641 x_msg_count,
642 x_msg_data,
643 ddp_evo_rec);
644
645 -- copy data back from the local variables to OUT or IN-OUT args, if any
646
647
648
649
650
651
652
653 end;
654
655 procedure validate_eventoffer(p_api_version NUMBER
656 , p_init_msg_list VARCHAR2
657 , p_validation_level NUMBER
658 , x_return_status out nocopy VARCHAR2
659 , x_msg_count out nocopy NUMBER
660 , x_msg_data out nocopy VARCHAR2
661 , p6_a0 NUMBER := 0-1962.0724
662 , p6_a1 DATE := fnd_api.g_miss_date
663 , p6_a2 NUMBER := 0-1962.0724
664 , p6_a3 DATE := fnd_api.g_miss_date
665 , p6_a4 NUMBER := 0-1962.0724
666 , p6_a5 NUMBER := 0-1962.0724
667 , p6_a6 NUMBER := 0-1962.0724
668 , p6_a7 NUMBER := 0-1962.0724
669 , p6_a8 NUMBER := 0-1962.0724
670 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
671 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
672 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
673 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
674 , p6_a13 NUMBER := 0-1962.0724
675 , p6_a14 DATE := fnd_api.g_miss_date
676 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
677 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
678 , p6_a17 NUMBER := 0-1962.0724
679 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
680 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
681 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
682 , p6_a21 NUMBER := 0-1962.0724
683 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
684 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
685 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
686 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
687 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
688 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
689 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
690 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
691 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
692 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
693 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
694 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
695 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
696 , p6_a35 NUMBER := 0-1962.0724
697 , p6_a36 NUMBER := 0-1962.0724
698 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
699 , p6_a38 DATE := fnd_api.g_miss_date
700 , p6_a39 DATE := fnd_api.g_miss_date
701 , p6_a40 DATE := fnd_api.g_miss_date
702 , p6_a41 DATE := fnd_api.g_miss_date
703 , p6_a42 DATE := fnd_api.g_miss_date
704 , p6_a43 DATE := fnd_api.g_miss_date
705 , p6_a44 DATE := fnd_api.g_miss_date
706 , p6_a45 DATE := fnd_api.g_miss_date
707 , p6_a46 NUMBER := 0-1962.0724
708 , p6_a47 NUMBER := 0-1962.0724
709 , p6_a48 NUMBER := 0-1962.0724
710 , p6_a49 NUMBER := 0-1962.0724
711 , p6_a50 NUMBER := 0-1962.0724
712 , p6_a51 DATE := fnd_api.g_miss_date
713 , p6_a52 NUMBER := 0-1962.0724
714 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
715 , p6_a54 NUMBER := 0-1962.0724
716 , p6_a55 NUMBER := 0-1962.0724
717 , p6_a56 NUMBER := 0-1962.0724
718 , p6_a57 NUMBER := 0-1962.0724
719 , p6_a58 VARCHAR2 := fnd_api.g_miss_char
720 , p6_a59 VARCHAR2 := fnd_api.g_miss_char
721 , p6_a60 NUMBER := 0-1962.0724
722 , p6_a61 VARCHAR2 := fnd_api.g_miss_char
723 , p6_a62 NUMBER := 0-1962.0724
724 , p6_a63 NUMBER := 0-1962.0724
725 , p6_a64 NUMBER := 0-1962.0724
726 , p6_a65 NUMBER := 0-1962.0724
727 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
728 , p6_a67 NUMBER := 0-1962.0724
729 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
730 , p6_a69 NUMBER := 0-1962.0724
731 , p6_a70 NUMBER := 0-1962.0724
732 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
733 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
734 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
735 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
736 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
737 , p6_a76 NUMBER := 0-1962.0724
738 , p6_a77 NUMBER := 0-1962.0724
739 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
740 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
741 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
742 , p6_a81 NUMBER := 0-1962.0724
743 , p6_a82 NUMBER := 0-1962.0724
744 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
745 , p6_a84 NUMBER := 0-1962.0724
746 , p6_a85 VARCHAR2 := fnd_api.g_miss_char
747 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
748 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
749 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
750 , p6_a89 VARCHAR2 := fnd_api.g_miss_char
751 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
752 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
753 , p6_a92 VARCHAR2 := fnd_api.g_miss_char
754 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
755 , p6_a94 VARCHAR2 := fnd_api.g_miss_char
756 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
757 , p6_a96 VARCHAR2 := fnd_api.g_miss_char
758 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
759 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
760 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
761 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
762 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
763 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
764 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
765 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
766 , p6_a105 NUMBER := 0-1962.0724
767 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
768 , p6_a107 NUMBER := 0-1962.0724
769 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
770 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
771 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
772 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
773 , p6_a112 NUMBER := 0-1962.0724
774 , p6_a113 VARCHAR2 := fnd_api.g_miss_char
775 , p6_a114 NUMBER := 0-1962.0724
776 , p6_a115 VARCHAR2 := fnd_api.g_miss_char
777 , p6_a116 VARCHAR2 := fnd_api.g_miss_char
778 , p6_a117 VARCHAR2 := fnd_api.g_miss_char
779 , p6_a118 NUMBER := 0-1962.0724
780 , p6_a119 VARCHAR2 := fnd_api.g_miss_char
781 , p6_a120 VARCHAR2 := fnd_api.g_miss_char
782 , p6_a121 VARCHAR2 := fnd_api.g_miss_char
783 , p6_a122 VARCHAR2 := fnd_api.g_miss_char
784 , p6_a123 VARCHAR2 := fnd_api.g_miss_char
785 , p6_a124 VARCHAR2 := fnd_api.g_miss_char
786 , p6_a125 DATE := fnd_api.g_miss_date
787 , p6_a126 DATE := fnd_api.g_miss_date
788 , p6_a127 NUMBER := 0-1962.0724
789 , p6_a128 NUMBER := 0-1962.0724
790 , p6_a129 VARCHAR2 := fnd_api.g_miss_char
791 , p6_a130 VARCHAR2 := fnd_api.g_miss_char
792 , p6_a131 VARCHAR2 := fnd_api.g_miss_char
793 , p6_a132 VARCHAR2 := fnd_api.g_miss_char
794 , p6_a133 VARCHAR2 := fnd_api.g_miss_char
795 , p6_a134 VARCHAR2 := fnd_api.g_miss_char
796 , p6_a135 VARCHAR2 := fnd_api.g_miss_char
797 , p6_a136 NUMBER := 0-1962.0724
798 , p6_a137 VARCHAR2 := fnd_api.g_miss_char
799 )
800
801 as
802 ddp_evo_rec ams_eventoffer_pvt.evo_rec_type;
803 ddindx binary_integer; indx binary_integer;
804 begin
805
806 -- copy data to the local IN or IN-OUT args, if any
807
808
809
810
811
812
813 ddp_evo_rec.event_offer_id := p6_a0;
814 ddp_evo_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
815 ddp_evo_rec.last_updated_by := p6_a2;
816 ddp_evo_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
817 ddp_evo_rec.created_by := p6_a4;
818 ddp_evo_rec.last_update_login := p6_a5;
819 ddp_evo_rec.object_version_number := p6_a6;
820 ddp_evo_rec.application_id := p6_a7;
821 ddp_evo_rec.event_header_id := p6_a8;
822 ddp_evo_rec.private_flag := p6_a9;
823 ddp_evo_rec.active_flag := p6_a10;
824 ddp_evo_rec.source_code := p6_a11;
825 ddp_evo_rec.event_level := p6_a12;
826 ddp_evo_rec.user_status_id := p6_a13;
827 ddp_evo_rec.last_status_date := rosetta_g_miss_date_in_map(p6_a14);
828 ddp_evo_rec.system_status_code := p6_a15;
829 ddp_evo_rec.event_type_code := p6_a16;
830 ddp_evo_rec.event_delivery_method_id := p6_a17;
831 ddp_evo_rec.event_delivery_method_code := p6_a18;
832 ddp_evo_rec.event_required_flag := p6_a19;
833 ddp_evo_rec.event_language_code := p6_a20;
834 ddp_evo_rec.event_location_id := p6_a21;
835 ddp_evo_rec.city := p6_a22;
836 ddp_evo_rec.state := p6_a23;
837 ddp_evo_rec.province := p6_a24;
838 ddp_evo_rec.country := p6_a25;
839 ddp_evo_rec.overflow_flag := p6_a26;
840 ddp_evo_rec.partner_flag := p6_a27;
841 ddp_evo_rec.event_standalone_flag := p6_a28;
842 ddp_evo_rec.reg_frozen_flag := p6_a29;
843 ddp_evo_rec.reg_required_flag := p6_a30;
844 ddp_evo_rec.reg_charge_flag := p6_a31;
845 ddp_evo_rec.reg_invited_only_flag := p6_a32;
846 ddp_evo_rec.reg_waitlist_allowed_flag := p6_a33;
847 ddp_evo_rec.reg_overbook_allowed_flag := p6_a34;
848 ddp_evo_rec.parent_event_offer_id := p6_a35;
849 ddp_evo_rec.event_duration := p6_a36;
850 ddp_evo_rec.event_duration_uom_code := p6_a37;
851 ddp_evo_rec.event_start_date := rosetta_g_miss_date_in_map(p6_a38);
852 ddp_evo_rec.event_start_date_time := rosetta_g_miss_date_in_map(p6_a39);
853 ddp_evo_rec.event_end_date := rosetta_g_miss_date_in_map(p6_a40);
854 ddp_evo_rec.event_end_date_time := rosetta_g_miss_date_in_map(p6_a41);
855 ddp_evo_rec.reg_start_date := rosetta_g_miss_date_in_map(p6_a42);
856 ddp_evo_rec.reg_start_time := rosetta_g_miss_date_in_map(p6_a43);
857 ddp_evo_rec.reg_end_date := rosetta_g_miss_date_in_map(p6_a44);
858 ddp_evo_rec.reg_end_time := rosetta_g_miss_date_in_map(p6_a45);
859 ddp_evo_rec.reg_maximum_capacity := p6_a46;
860 ddp_evo_rec.reg_overbook_pct := p6_a47;
861 ddp_evo_rec.reg_effective_capacity := p6_a48;
862 ddp_evo_rec.reg_waitlist_pct := p6_a49;
863 ddp_evo_rec.reg_minimum_capacity := p6_a50;
864 ddp_evo_rec.reg_minimum_req_by_date := rosetta_g_miss_date_in_map(p6_a51);
865 ddp_evo_rec.inventory_item_id := p6_a52;
866 ddp_evo_rec.inventory_item := p6_a53;
867 ddp_evo_rec.organization_id := p6_a54;
868 ddp_evo_rec.pricelist_header_id := p6_a55;
869 ddp_evo_rec.pricelist_line_id := p6_a56;
870 ddp_evo_rec.org_id := p6_a57;
871 ddp_evo_rec.waitlist_action_type_code := p6_a58;
872 ddp_evo_rec.stream_type_code := p6_a59;
873 ddp_evo_rec.owner_user_id := p6_a60;
874 ddp_evo_rec.event_full_flag := p6_a61;
875 ddp_evo_rec.forecasted_revenue := p6_a62;
876 ddp_evo_rec.actual_revenue := p6_a63;
877 ddp_evo_rec.forecasted_cost := p6_a64;
878 ddp_evo_rec.actual_cost := p6_a65;
879 ddp_evo_rec.fund_source_type_code := p6_a66;
880 ddp_evo_rec.fund_source_id := p6_a67;
881 ddp_evo_rec.cert_credit_type_code := p6_a68;
882 ddp_evo_rec.certification_credits := p6_a69;
883 ddp_evo_rec.coordinator_id := p6_a70;
884 ddp_evo_rec.priority_type_code := p6_a71;
885 ddp_evo_rec.cancellation_reason_code := p6_a72;
886 ddp_evo_rec.auto_register_flag := p6_a73;
887 ddp_evo_rec.email := p6_a74;
888 ddp_evo_rec.phone := p6_a75;
889 ddp_evo_rec.fund_amount_tc := p6_a76;
890 ddp_evo_rec.fund_amount_fc := p6_a77;
891 ddp_evo_rec.currency_code_tc := p6_a78;
892 ddp_evo_rec.currency_code_fc := p6_a79;
893 ddp_evo_rec.url := p6_a80;
894 ddp_evo_rec.timezone_id := p6_a81;
895 ddp_evo_rec.event_venue_id := p6_a82;
896 ddp_evo_rec.pricelist_header_currency_code := p6_a83;
897 ddp_evo_rec.pricelist_list_price := p6_a84;
898 ddp_evo_rec.inbound_script_name := p6_a85;
899 ddp_evo_rec.attribute_category := p6_a86;
900 ddp_evo_rec.attribute1 := p6_a87;
901 ddp_evo_rec.attribute2 := p6_a88;
902 ddp_evo_rec.attribute3 := p6_a89;
903 ddp_evo_rec.attribute4 := p6_a90;
904 ddp_evo_rec.attribute5 := p6_a91;
905 ddp_evo_rec.attribute6 := p6_a92;
906 ddp_evo_rec.attribute7 := p6_a93;
907 ddp_evo_rec.attribute8 := p6_a94;
908 ddp_evo_rec.attribute9 := p6_a95;
909 ddp_evo_rec.attribute10 := p6_a96;
910 ddp_evo_rec.attribute11 := p6_a97;
911 ddp_evo_rec.attribute12 := p6_a98;
912 ddp_evo_rec.attribute13 := p6_a99;
913 ddp_evo_rec.attribute14 := p6_a100;
914 ddp_evo_rec.attribute15 := p6_a101;
915 ddp_evo_rec.event_offer_name := p6_a102;
916 ddp_evo_rec.event_mktg_message := p6_a103;
917 ddp_evo_rec.description := p6_a104;
918 ddp_evo_rec.custom_setup_id := p6_a105;
919 ddp_evo_rec.country_code := p6_a106;
920 ddp_evo_rec.business_unit_id := p6_a107;
921 ddp_evo_rec.event_calendar := p6_a108;
922 ddp_evo_rec.start_period_name := p6_a109;
923 ddp_evo_rec.end_period_name := p6_a110;
924 ddp_evo_rec.global_flag := p6_a111;
925 ddp_evo_rec.task_id := p6_a112;
926 ddp_evo_rec.parent_type := p6_a113;
927 ddp_evo_rec.parent_id := p6_a114;
928 ddp_evo_rec.create_attendant_lead_flag := p6_a115;
929 ddp_evo_rec.create_registrant_lead_flag := p6_a116;
930 ddp_evo_rec.event_object_type := p6_a117;
931 ddp_evo_rec.reg_timezone_id := p6_a118;
932 ddp_evo_rec.event_password := p6_a119;
933 ddp_evo_rec.record_event_flag := p6_a120;
934 ddp_evo_rec.allow_register_in_middle_flag := p6_a121;
935 ddp_evo_rec.publish_attendees_flag := p6_a122;
936 ddp_evo_rec.direct_join_flag := p6_a123;
937 ddp_evo_rec.event_notification_method := p6_a124;
938 ddp_evo_rec.actual_start_time := rosetta_g_miss_date_in_map(p6_a125);
939 ddp_evo_rec.actual_end_time := rosetta_g_miss_date_in_map(p6_a126);
940 ddp_evo_rec.server_id := p6_a127;
941 ddp_evo_rec.owner_fnd_user_id := p6_a128;
942 ddp_evo_rec.meeting_dial_in_info := p6_a129;
943 ddp_evo_rec.meeting_email_subject := p6_a130;
944 ddp_evo_rec.meeting_schedule_type := p6_a131;
945 ddp_evo_rec.meeting_status := p6_a132;
946 ddp_evo_rec.meeting_misc_info := p6_a133;
947 ddp_evo_rec.publish_flag := p6_a134;
948 ddp_evo_rec.meeting_encryption_key_code := p6_a135;
949 ddp_evo_rec.number_of_attendees := p6_a136;
950 ddp_evo_rec.event_purpose_code := p6_a137;
951
952 -- here's the delegated call to the old PL/SQL routine
953 ams_eventoffer_pub.validate_eventoffer(p_api_version,
954 p_init_msg_list,
955 p_validation_level,
956 x_return_status,
957 x_msg_count,
958 x_msg_data,
959 ddp_evo_rec);
960
961 -- copy data back from the local variables to OUT or IN-OUT args, if any
962
963
964
965
966
967
968 end;
969
970 end ams_eventoffer_pub_w;