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