[Home] [Help]
PACKAGE BODY: APPS.AMS_AGENDAS_PVT_W
Source
1 package body ams_agendas_pvt_w as
2 /* $Header: amswagnb.pls 115.2 2002/11/16 00:48:41 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_agenda(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_agenda_id OUT NOCOPY NUMBER
30 , p4_a0 NUMBER := 0-1962.0724
31 , p4_a1 NUMBER := 0-1962.0724
32 , p4_a2 DATE := fnd_api.g_miss_date
33 , p4_a3 NUMBER := 0-1962.0724
34 , p4_a4 DATE := fnd_api.g_miss_date
35 , p4_a5 NUMBER := 0-1962.0724
36 , p4_a6 NUMBER := 0-1962.0724
37 , p4_a7 NUMBER := 0-1962.0724
38 , p4_a8 NUMBER := 0-1962.0724
39 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p4_a12 NUMBER := 0-1962.0724
43 , p4_a13 DATE := fnd_api.g_miss_date
44 , p4_a14 DATE := fnd_api.g_miss_date
45 , p4_a15 NUMBER := 0-1962.0724
46 , p4_a16 NUMBER := 0-1962.0724
47 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p4_a18 NUMBER := 0-1962.0724
49 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p4_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
52 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
55 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
56 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
57 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
63 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
64 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
65 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
66 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
67 )
68 as
69 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
70 ddindx binary_integer; indx binary_integer;
71 begin
72
73 -- copy data to the local IN or IN-OUT args, if any
74
75
76
77
78 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p4_a0);
79 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p4_a1);
80 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a2);
81 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p4_a3);
82 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p4_a4);
83 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p4_a5);
84 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p4_a6);
85 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p4_a7);
86 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p4_a8);
87 ddp_agenda_rec.active_flag := p4_a9;
88 ddp_agenda_rec.default_track_flag := p4_a10;
89 ddp_agenda_rec.agenda_type := p4_a11;
90 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p4_a12);
91 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p4_a13);
92 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p4_a14);
93 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p4_a15);
94 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p4_a16);
95 ddp_agenda_rec.parent_type := p4_a17;
96 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p4_a18);
97 ddp_agenda_rec.attribute_category := p4_a19;
98 ddp_agenda_rec.attribute1 := p4_a20;
99 ddp_agenda_rec.attribute2 := p4_a21;
100 ddp_agenda_rec.attribute3 := p4_a22;
101 ddp_agenda_rec.attribute4 := p4_a23;
102 ddp_agenda_rec.attribute5 := p4_a24;
103 ddp_agenda_rec.attribute6 := p4_a25;
104 ddp_agenda_rec.attribute7 := p4_a26;
105 ddp_agenda_rec.attribute8 := p4_a27;
106 ddp_agenda_rec.attribute9 := p4_a28;
107 ddp_agenda_rec.attribute10 := p4_a29;
108 ddp_agenda_rec.attribute11 := p4_a30;
109 ddp_agenda_rec.attribute12 := p4_a31;
110 ddp_agenda_rec.attribute13 := p4_a32;
111 ddp_agenda_rec.attribute14 := p4_a33;
112 ddp_agenda_rec.attribute15 := p4_a34;
113 ddp_agenda_rec.agenda_name := p4_a35;
114 ddp_agenda_rec.description := p4_a36;
115
116
117
118
119
120 -- here's the delegated call to the old PL/SQL routine
121 ams_agendas_pvt.create_agenda(p_api_version,
122 p_init_msg_list,
123 p_commit,
124 p_validation_level,
125 ddp_agenda_rec,
126 x_return_status,
127 x_msg_count,
128 x_msg_data,
129 x_agenda_id);
130
131 -- copy data back from the local OUT or IN-OUT args, if any
132
133
134
135
136
137
138
139
140 end;
141
142 procedure update_agenda(p_api_version NUMBER
143 , p_init_msg_list VARCHAR2
144 , p_commit VARCHAR2
145 , p_validation_level NUMBER
146 , x_return_status OUT NOCOPY VARCHAR2
147 , x_msg_count OUT NOCOPY NUMBER
148 , x_msg_data OUT NOCOPY VARCHAR2
149 , p4_a0 NUMBER := 0-1962.0724
150 , p4_a1 NUMBER := 0-1962.0724
151 , p4_a2 DATE := fnd_api.g_miss_date
152 , p4_a3 NUMBER := 0-1962.0724
153 , p4_a4 DATE := fnd_api.g_miss_date
154 , p4_a5 NUMBER := 0-1962.0724
155 , p4_a6 NUMBER := 0-1962.0724
156 , p4_a7 NUMBER := 0-1962.0724
157 , p4_a8 NUMBER := 0-1962.0724
158 , p4_a9 VARCHAR2 := fnd_api.g_miss_char
159 , p4_a10 VARCHAR2 := fnd_api.g_miss_char
160 , p4_a11 VARCHAR2 := fnd_api.g_miss_char
161 , p4_a12 NUMBER := 0-1962.0724
162 , p4_a13 DATE := fnd_api.g_miss_date
163 , p4_a14 DATE := fnd_api.g_miss_date
164 , p4_a15 NUMBER := 0-1962.0724
165 , p4_a16 NUMBER := 0-1962.0724
166 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
167 , p4_a18 NUMBER := 0-1962.0724
168 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
169 , p4_a20 VARCHAR2 := fnd_api.g_miss_char
170 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
171 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
172 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
173 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
174 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
175 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
176 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
177 , p4_a28 VARCHAR2 := fnd_api.g_miss_char
178 , p4_a29 VARCHAR2 := fnd_api.g_miss_char
179 , p4_a30 VARCHAR2 := fnd_api.g_miss_char
180 , p4_a31 VARCHAR2 := fnd_api.g_miss_char
181 , p4_a32 VARCHAR2 := fnd_api.g_miss_char
182 , p4_a33 VARCHAR2 := fnd_api.g_miss_char
183 , p4_a34 VARCHAR2 := fnd_api.g_miss_char
184 , p4_a35 VARCHAR2 := fnd_api.g_miss_char
185 , p4_a36 VARCHAR2 := fnd_api.g_miss_char
186 )
187 as
188 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
189 ddindx binary_integer; indx binary_integer;
190 begin
191
192 -- copy data to the local IN or IN-OUT args, if any
193
194
195
196
197 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p4_a0);
198 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p4_a1);
199 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a2);
200 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p4_a3);
201 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p4_a4);
202 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p4_a5);
203 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p4_a6);
204 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p4_a7);
205 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p4_a8);
206 ddp_agenda_rec.active_flag := p4_a9;
207 ddp_agenda_rec.default_track_flag := p4_a10;
208 ddp_agenda_rec.agenda_type := p4_a11;
209 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p4_a12);
210 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p4_a13);
211 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p4_a14);
212 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p4_a15);
213 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p4_a16);
214 ddp_agenda_rec.parent_type := p4_a17;
215 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p4_a18);
216 ddp_agenda_rec.attribute_category := p4_a19;
217 ddp_agenda_rec.attribute1 := p4_a20;
218 ddp_agenda_rec.attribute2 := p4_a21;
219 ddp_agenda_rec.attribute3 := p4_a22;
220 ddp_agenda_rec.attribute4 := p4_a23;
221 ddp_agenda_rec.attribute5 := p4_a24;
222 ddp_agenda_rec.attribute6 := p4_a25;
223 ddp_agenda_rec.attribute7 := p4_a26;
224 ddp_agenda_rec.attribute8 := p4_a27;
225 ddp_agenda_rec.attribute9 := p4_a28;
226 ddp_agenda_rec.attribute10 := p4_a29;
227 ddp_agenda_rec.attribute11 := p4_a30;
228 ddp_agenda_rec.attribute12 := p4_a31;
229 ddp_agenda_rec.attribute13 := p4_a32;
230 ddp_agenda_rec.attribute14 := p4_a33;
231 ddp_agenda_rec.attribute15 := p4_a34;
232 ddp_agenda_rec.agenda_name := p4_a35;
233 ddp_agenda_rec.description := p4_a36;
234
235
236
237
238 -- here's the delegated call to the old PL/SQL routine
239 ams_agendas_pvt.update_agenda(p_api_version,
240 p_init_msg_list,
241 p_commit,
242 p_validation_level,
243 ddp_agenda_rec,
244 x_return_status,
245 x_msg_count,
246 x_msg_data);
247
248 -- copy data back from the local OUT or IN-OUT args, if any
249
250
251
252
253
254
255
256 end;
257
258 procedure validate_agenda(p_api_version NUMBER
259 , p_init_msg_list VARCHAR2
260 , p_validation_level NUMBER
261 , x_return_status OUT NOCOPY VARCHAR2
262 , x_msg_count OUT NOCOPY NUMBER
263 , x_msg_data OUT NOCOPY VARCHAR2
264 , p3_a0 NUMBER := 0-1962.0724
265 , p3_a1 NUMBER := 0-1962.0724
266 , p3_a2 DATE := fnd_api.g_miss_date
267 , p3_a3 NUMBER := 0-1962.0724
268 , p3_a4 DATE := fnd_api.g_miss_date
269 , p3_a5 NUMBER := 0-1962.0724
270 , p3_a6 NUMBER := 0-1962.0724
271 , p3_a7 NUMBER := 0-1962.0724
272 , p3_a8 NUMBER := 0-1962.0724
273 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
274 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
275 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
276 , p3_a12 NUMBER := 0-1962.0724
277 , p3_a13 DATE := fnd_api.g_miss_date
278 , p3_a14 DATE := fnd_api.g_miss_date
279 , p3_a15 NUMBER := 0-1962.0724
280 , p3_a16 NUMBER := 0-1962.0724
281 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
282 , p3_a18 NUMBER := 0-1962.0724
283 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
284 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
285 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
286 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
287 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
288 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
289 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
290 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
291 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
292 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
293 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
294 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
295 , p3_a31 VARCHAR2 := fnd_api.g_miss_char
296 , p3_a32 VARCHAR2 := fnd_api.g_miss_char
297 , p3_a33 VARCHAR2 := fnd_api.g_miss_char
298 , p3_a34 VARCHAR2 := fnd_api.g_miss_char
299 , p3_a35 VARCHAR2 := fnd_api.g_miss_char
300 , p3_a36 VARCHAR2 := fnd_api.g_miss_char
301 )
302 as
303 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
304 ddindx binary_integer; indx binary_integer;
305 begin
306
307 -- copy data to the local IN or IN-OUT args, if any
308
309
310
311 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p3_a0);
312 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p3_a1);
313 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a2);
314 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p3_a3);
315 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p3_a4);
316 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p3_a5);
317 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p3_a6);
318 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p3_a7);
319 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p3_a8);
320 ddp_agenda_rec.active_flag := p3_a9;
321 ddp_agenda_rec.default_track_flag := p3_a10;
322 ddp_agenda_rec.agenda_type := p3_a11;
323 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p3_a12);
324 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p3_a13);
325 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p3_a14);
326 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p3_a15);
327 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p3_a16);
328 ddp_agenda_rec.parent_type := p3_a17;
329 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p3_a18);
330 ddp_agenda_rec.attribute_category := p3_a19;
331 ddp_agenda_rec.attribute1 := p3_a20;
332 ddp_agenda_rec.attribute2 := p3_a21;
333 ddp_agenda_rec.attribute3 := p3_a22;
334 ddp_agenda_rec.attribute4 := p3_a23;
335 ddp_agenda_rec.attribute5 := p3_a24;
336 ddp_agenda_rec.attribute6 := p3_a25;
337 ddp_agenda_rec.attribute7 := p3_a26;
338 ddp_agenda_rec.attribute8 := p3_a27;
339 ddp_agenda_rec.attribute9 := p3_a28;
340 ddp_agenda_rec.attribute10 := p3_a29;
341 ddp_agenda_rec.attribute11 := p3_a30;
342 ddp_agenda_rec.attribute12 := p3_a31;
343 ddp_agenda_rec.attribute13 := p3_a32;
344 ddp_agenda_rec.attribute14 := p3_a33;
345 ddp_agenda_rec.attribute15 := p3_a34;
346 ddp_agenda_rec.agenda_name := p3_a35;
347 ddp_agenda_rec.description := p3_a36;
348
349
350
351
352 -- here's the delegated call to the old PL/SQL routine
353 ams_agendas_pvt.validate_agenda(p_api_version,
354 p_init_msg_list,
355 p_validation_level,
356 ddp_agenda_rec,
357 x_return_status,
358 x_msg_count,
359 x_msg_data);
360
361 -- copy data back from the local OUT or IN-OUT args, if any
362
363
364
365
366
367
368 end;
369
370 procedure validate_agenda_items(p_validation_mode VARCHAR2
371 , x_return_status OUT NOCOPY VARCHAR2
372 , p0_a0 NUMBER := 0-1962.0724
373 , p0_a1 NUMBER := 0-1962.0724
374 , p0_a2 DATE := fnd_api.g_miss_date
375 , p0_a3 NUMBER := 0-1962.0724
376 , p0_a4 DATE := fnd_api.g_miss_date
377 , p0_a5 NUMBER := 0-1962.0724
378 , p0_a6 NUMBER := 0-1962.0724
379 , p0_a7 NUMBER := 0-1962.0724
380 , p0_a8 NUMBER := 0-1962.0724
381 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
382 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
383 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
384 , p0_a12 NUMBER := 0-1962.0724
385 , p0_a13 DATE := fnd_api.g_miss_date
386 , p0_a14 DATE := fnd_api.g_miss_date
387 , p0_a15 NUMBER := 0-1962.0724
388 , p0_a16 NUMBER := 0-1962.0724
389 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
390 , p0_a18 NUMBER := 0-1962.0724
391 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
395 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
392 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
393 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
394 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
396 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
397 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
398 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
399 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
400 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
401 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
402 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
403 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
404 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
405 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
406 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
407 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
408 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
409 )
410 as
411 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
412 ddindx binary_integer; indx binary_integer;
413 begin
414
415 -- copy data to the local IN or IN-OUT args, if any
416 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p0_a0);
417 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p0_a1);
418 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
419 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
420 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
421 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p0_a5);
422 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
423 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
424 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p0_a8);
425 ddp_agenda_rec.active_flag := p0_a9;
426 ddp_agenda_rec.default_track_flag := p0_a10;
427 ddp_agenda_rec.agenda_type := p0_a11;
428 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p0_a12);
429 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a13);
430 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p0_a14);
431 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p0_a15);
432 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p0_a16);
433 ddp_agenda_rec.parent_type := p0_a17;
434 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p0_a18);
435 ddp_agenda_rec.attribute_category := p0_a19;
436 ddp_agenda_rec.attribute1 := p0_a20;
437 ddp_agenda_rec.attribute2 := p0_a21;
438 ddp_agenda_rec.attribute3 := p0_a22;
439 ddp_agenda_rec.attribute4 := p0_a23;
440 ddp_agenda_rec.attribute5 := p0_a24;
441 ddp_agenda_rec.attribute6 := p0_a25;
442 ddp_agenda_rec.attribute7 := p0_a26;
443 ddp_agenda_rec.attribute8 := p0_a27;
444 ddp_agenda_rec.attribute9 := p0_a28;
445 ddp_agenda_rec.attribute10 := p0_a29;
446 ddp_agenda_rec.attribute11 := p0_a30;
447 ddp_agenda_rec.attribute12 := p0_a31;
448 ddp_agenda_rec.attribute13 := p0_a32;
449 ddp_agenda_rec.attribute14 := p0_a33;
450 ddp_agenda_rec.attribute15 := p0_a34;
451 ddp_agenda_rec.agenda_name := p0_a35;
452 ddp_agenda_rec.description := p0_a36;
453
454
455
456 -- here's the delegated call to the old PL/SQL routine
457 ams_agendas_pvt.validate_agenda_items(ddp_agenda_rec,
458 p_validation_mode,
459 x_return_status);
460
461 -- copy data back from the local OUT or IN-OUT args, if any
462
463
464 end;
465
466 procedure validate_agenda_record(x_return_status OUT NOCOPY VARCHAR2
467 , p0_a0 NUMBER := 0-1962.0724
468 , p0_a1 NUMBER := 0-1962.0724
469 , p0_a2 DATE := fnd_api.g_miss_date
470 , p0_a3 NUMBER := 0-1962.0724
471 , p0_a4 DATE := fnd_api.g_miss_date
472 , p0_a5 NUMBER := 0-1962.0724
473 , p0_a6 NUMBER := 0-1962.0724
474 , p0_a7 NUMBER := 0-1962.0724
475 , p0_a8 NUMBER := 0-1962.0724
476 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
477 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
478 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
479 , p0_a12 NUMBER := 0-1962.0724
480 , p0_a13 DATE := fnd_api.g_miss_date
481 , p0_a14 DATE := fnd_api.g_miss_date
482 , p0_a15 NUMBER := 0-1962.0724
483 , p0_a16 NUMBER := 0-1962.0724
484 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
485 , p0_a18 NUMBER := 0-1962.0724
486 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
487 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
488 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
489 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
490 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
491 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
492 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
493 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
494 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
495 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
496 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
497 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
499 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
500 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
501 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
502 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
503 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
504 , p1_a0 NUMBER := 0-1962.0724
505 , p1_a1 NUMBER := 0-1962.0724
506 , p1_a2 DATE := fnd_api.g_miss_date
507 , p1_a3 NUMBER := 0-1962.0724
508 , p1_a4 DATE := fnd_api.g_miss_date
512 , p1_a8 NUMBER := 0-1962.0724
509 , p1_a5 NUMBER := 0-1962.0724
510 , p1_a6 NUMBER := 0-1962.0724
511 , p1_a7 NUMBER := 0-1962.0724
513 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
516 , p1_a12 NUMBER := 0-1962.0724
517 , p1_a13 DATE := fnd_api.g_miss_date
518 , p1_a14 DATE := fnd_api.g_miss_date
519 , p1_a15 NUMBER := 0-1962.0724
520 , p1_a16 NUMBER := 0-1962.0724
521 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522 , p1_a18 NUMBER := 0-1962.0724
523 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
535 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
536 , p1_a32 VARCHAR2 := fnd_api.g_miss_char
537 , p1_a33 VARCHAR2 := fnd_api.g_miss_char
538 , p1_a34 VARCHAR2 := fnd_api.g_miss_char
539 , p1_a35 VARCHAR2 := fnd_api.g_miss_char
540 , p1_a36 VARCHAR2 := fnd_api.g_miss_char
541 )
542 as
543 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
544 ddp_complete_rec ams_agendas_pvt.agenda_rec_type;
545 ddindx binary_integer; indx binary_integer;
546 begin
547
548 -- copy data to the local IN or IN-OUT args, if any
549 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p0_a0);
550 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p0_a1);
551 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
552 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
553 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
554 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p0_a5);
555 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
556 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
557 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p0_a8);
558 ddp_agenda_rec.active_flag := p0_a9;
559 ddp_agenda_rec.default_track_flag := p0_a10;
560 ddp_agenda_rec.agenda_type := p0_a11;
561 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p0_a12);
562 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a13);
563 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p0_a14);
564 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p0_a15);
565 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p0_a16);
566 ddp_agenda_rec.parent_type := p0_a17;
567 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p0_a18);
568 ddp_agenda_rec.attribute_category := p0_a19;
569 ddp_agenda_rec.attribute1 := p0_a20;
570 ddp_agenda_rec.attribute2 := p0_a21;
571 ddp_agenda_rec.attribute3 := p0_a22;
572 ddp_agenda_rec.attribute4 := p0_a23;
573 ddp_agenda_rec.attribute5 := p0_a24;
574 ddp_agenda_rec.attribute6 := p0_a25;
575 ddp_agenda_rec.attribute7 := p0_a26;
576 ddp_agenda_rec.attribute8 := p0_a27;
577 ddp_agenda_rec.attribute9 := p0_a28;
578 ddp_agenda_rec.attribute10 := p0_a29;
579 ddp_agenda_rec.attribute11 := p0_a30;
580 ddp_agenda_rec.attribute12 := p0_a31;
581 ddp_agenda_rec.attribute13 := p0_a32;
582 ddp_agenda_rec.attribute14 := p0_a33;
583 ddp_agenda_rec.attribute15 := p0_a34;
584 ddp_agenda_rec.agenda_name := p0_a35;
585 ddp_agenda_rec.description := p0_a36;
586
587 ddp_complete_rec.agenda_id := rosetta_g_miss_num_map(p1_a0);
588 ddp_complete_rec.setup_type_id := rosetta_g_miss_num_map(p1_a1);
589 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a2);
590 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a3);
591 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a4);
592 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a5);
593 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a6);
594 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a7);
595 ddp_complete_rec.application_id := rosetta_g_miss_num_map(p1_a8);
596 ddp_complete_rec.active_flag := p1_a9;
597 ddp_complete_rec.default_track_flag := p1_a10;
598 ddp_complete_rec.agenda_type := p1_a11;
599 ddp_complete_rec.room_id := rosetta_g_miss_num_map(p1_a12);
600 ddp_complete_rec.start_date_time := rosetta_g_miss_date_in_map(p1_a13);
601 ddp_complete_rec.end_date_time := rosetta_g_miss_date_in_map(p1_a14);
602 ddp_complete_rec.coordinator_id := rosetta_g_miss_num_map(p1_a15);
603 ddp_complete_rec.timezone_id := rosetta_g_miss_num_map(p1_a16);
604 ddp_complete_rec.parent_type := p1_a17;
605 ddp_complete_rec.parent_id := rosetta_g_miss_num_map(p1_a18);
606 ddp_complete_rec.attribute_category := p1_a19;
607 ddp_complete_rec.attribute1 := p1_a20;
608 ddp_complete_rec.attribute2 := p1_a21;
609 ddp_complete_rec.attribute3 := p1_a22;
610 ddp_complete_rec.attribute4 := p1_a23;
611 ddp_complete_rec.attribute5 := p1_a24;
612 ddp_complete_rec.attribute6 := p1_a25;
613 ddp_complete_rec.attribute7 := p1_a26;
617 ddp_complete_rec.attribute11 := p1_a30;
614 ddp_complete_rec.attribute8 := p1_a27;
615 ddp_complete_rec.attribute9 := p1_a28;
616 ddp_complete_rec.attribute10 := p1_a29;
618 ddp_complete_rec.attribute12 := p1_a31;
619 ddp_complete_rec.attribute13 := p1_a32;
620 ddp_complete_rec.attribute14 := p1_a33;
621 ddp_complete_rec.attribute15 := p1_a34;
622 ddp_complete_rec.agenda_name := p1_a35;
623 ddp_complete_rec.description := p1_a36;
624
625
626 -- here's the delegated call to the old PL/SQL routine
627 ams_agendas_pvt.validate_agenda_record(ddp_agenda_rec,
628 ddp_complete_rec,
629 x_return_status);
630
631 -- copy data back from the local OUT or IN-OUT args, if any
632
633
634 end;
635
636 procedure init_agenda_rec(p1_a0 OUT NOCOPY NUMBER
637 , p1_a1 OUT NOCOPY NUMBER
638 , p1_a2 OUT NOCOPY DATE
639 , p1_a3 OUT NOCOPY NUMBER
640 , p1_a4 OUT NOCOPY DATE
641 , p1_a5 OUT NOCOPY NUMBER
642 , p1_a6 OUT NOCOPY NUMBER
643 , p1_a7 OUT NOCOPY NUMBER
644 , p1_a8 OUT NOCOPY NUMBER
645 , p1_a9 OUT NOCOPY VARCHAR2
646 , p1_a10 OUT NOCOPY VARCHAR2
647 , p1_a11 OUT NOCOPY VARCHAR2
648 , p1_a12 OUT NOCOPY NUMBER
649 , p1_a13 OUT NOCOPY DATE
650 , p1_a14 OUT NOCOPY DATE
651 , p1_a15 OUT NOCOPY NUMBER
652 , p1_a16 OUT NOCOPY NUMBER
653 , p1_a17 OUT NOCOPY VARCHAR2
654 , p1_a18 OUT NOCOPY NUMBER
655 , p1_a19 OUT NOCOPY VARCHAR2
656 , p1_a20 OUT NOCOPY VARCHAR2
657 , p1_a21 OUT NOCOPY VARCHAR2
658 , p1_a22 OUT NOCOPY VARCHAR2
659 , p1_a23 OUT NOCOPY VARCHAR2
660 , p1_a24 OUT NOCOPY VARCHAR2
661 , p1_a25 OUT NOCOPY VARCHAR2
662 , p1_a26 OUT NOCOPY VARCHAR2
663 , p1_a27 OUT NOCOPY VARCHAR2
664 , p1_a28 OUT NOCOPY VARCHAR2
665 , p1_a29 OUT NOCOPY VARCHAR2
666 , p1_a30 OUT NOCOPY VARCHAR2
667 , p1_a31 OUT NOCOPY VARCHAR2
668 , p1_a32 OUT NOCOPY VARCHAR2
669 , p1_a33 OUT NOCOPY VARCHAR2
670 , p1_a34 OUT NOCOPY VARCHAR2
671 , p1_a35 OUT NOCOPY VARCHAR2
672 , p1_a36 OUT NOCOPY VARCHAR2
673 , p0_a0 NUMBER := 0-1962.0724
674 , p0_a1 NUMBER := 0-1962.0724
675 , p0_a2 DATE := fnd_api.g_miss_date
676 , p0_a3 NUMBER := 0-1962.0724
677 , p0_a4 DATE := fnd_api.g_miss_date
678 , p0_a5 NUMBER := 0-1962.0724
679 , p0_a6 NUMBER := 0-1962.0724
680 , p0_a7 NUMBER := 0-1962.0724
681 , p0_a8 NUMBER := 0-1962.0724
682 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
683 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
684 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
685 , p0_a12 NUMBER := 0-1962.0724
686 , p0_a13 DATE := fnd_api.g_miss_date
687 , p0_a14 DATE := fnd_api.g_miss_date
688 , p0_a15 NUMBER := 0-1962.0724
689 , p0_a16 NUMBER := 0-1962.0724
690 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
691 , p0_a18 NUMBER := 0-1962.0724
692 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
693 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
694 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
695 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
696 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
697 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
698 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
699 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
700 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
701 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
702 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
703 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
704 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
705 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
706 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
707 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
708 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
709 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
710 )
711 as
712 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
713 ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
714 ddindx binary_integer; indx binary_integer;
715 begin
716
717 -- copy data to the local IN or IN-OUT args, if any
718 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p0_a0);
719 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p0_a1);
720 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
721 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
722 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
723 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p0_a5);
724 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
725 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
726 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p0_a8);
727 ddp_agenda_rec.active_flag := p0_a9;
728 ddp_agenda_rec.default_track_flag := p0_a10;
729 ddp_agenda_rec.agenda_type := p0_a11;
730 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p0_a12);
731 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a13);
732 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p0_a14);
733 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p0_a15);
734 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p0_a16);
735 ddp_agenda_rec.parent_type := p0_a17;
739 ddp_agenda_rec.attribute2 := p0_a21;
736 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p0_a18);
737 ddp_agenda_rec.attribute_category := p0_a19;
738 ddp_agenda_rec.attribute1 := p0_a20;
740 ddp_agenda_rec.attribute3 := p0_a22;
741 ddp_agenda_rec.attribute4 := p0_a23;
742 ddp_agenda_rec.attribute5 := p0_a24;
743 ddp_agenda_rec.attribute6 := p0_a25;
744 ddp_agenda_rec.attribute7 := p0_a26;
745 ddp_agenda_rec.attribute8 := p0_a27;
746 ddp_agenda_rec.attribute9 := p0_a28;
747 ddp_agenda_rec.attribute10 := p0_a29;
748 ddp_agenda_rec.attribute11 := p0_a30;
749 ddp_agenda_rec.attribute12 := p0_a31;
750 ddp_agenda_rec.attribute13 := p0_a32;
751 ddp_agenda_rec.attribute14 := p0_a33;
752 ddp_agenda_rec.attribute15 := p0_a34;
753 ddp_agenda_rec.agenda_name := p0_a35;
754 ddp_agenda_rec.description := p0_a36;
755
756
757 -- here's the delegated call to the old PL/SQL routine
758 ams_agendas_pvt.init_agenda_rec(ddp_agenda_rec,
759 ddx_agenda_rec);
760
761 -- copy data back from the local OUT or IN-OUT args, if any
762
763 p1_a0 := rosetta_g_miss_num_map(ddx_agenda_rec.agenda_id);
764 p1_a1 := rosetta_g_miss_num_map(ddx_agenda_rec.setup_type_id);
765 p1_a2 := ddx_agenda_rec.last_update_date;
766 p1_a3 := rosetta_g_miss_num_map(ddx_agenda_rec.last_updated_by);
767 p1_a4 := ddx_agenda_rec.creation_date;
768 p1_a5 := rosetta_g_miss_num_map(ddx_agenda_rec.created_by);
769 p1_a6 := rosetta_g_miss_num_map(ddx_agenda_rec.last_update_login);
770 p1_a7 := rosetta_g_miss_num_map(ddx_agenda_rec.object_version_number);
771 p1_a8 := rosetta_g_miss_num_map(ddx_agenda_rec.application_id);
772 p1_a9 := ddx_agenda_rec.active_flag;
773 p1_a10 := ddx_agenda_rec.default_track_flag;
774 p1_a11 := ddx_agenda_rec.agenda_type;
775 p1_a12 := rosetta_g_miss_num_map(ddx_agenda_rec.room_id);
776 p1_a13 := ddx_agenda_rec.start_date_time;
777 p1_a14 := ddx_agenda_rec.end_date_time;
778 p1_a15 := rosetta_g_miss_num_map(ddx_agenda_rec.coordinator_id);
779 p1_a16 := rosetta_g_miss_num_map(ddx_agenda_rec.timezone_id);
780 p1_a17 := ddx_agenda_rec.parent_type;
781 p1_a18 := rosetta_g_miss_num_map(ddx_agenda_rec.parent_id);
782 p1_a19 := ddx_agenda_rec.attribute_category;
783 p1_a20 := ddx_agenda_rec.attribute1;
784 p1_a21 := ddx_agenda_rec.attribute2;
785 p1_a22 := ddx_agenda_rec.attribute3;
786 p1_a23 := ddx_agenda_rec.attribute4;
787 p1_a24 := ddx_agenda_rec.attribute5;
788 p1_a25 := ddx_agenda_rec.attribute6;
789 p1_a26 := ddx_agenda_rec.attribute7;
790 p1_a27 := ddx_agenda_rec.attribute8;
791 p1_a28 := ddx_agenda_rec.attribute9;
792 p1_a29 := ddx_agenda_rec.attribute10;
793 p1_a30 := ddx_agenda_rec.attribute11;
794 p1_a31 := ddx_agenda_rec.attribute12;
795 p1_a32 := ddx_agenda_rec.attribute13;
796 p1_a33 := ddx_agenda_rec.attribute14;
797 p1_a34 := ddx_agenda_rec.attribute15;
798 p1_a35 := ddx_agenda_rec.agenda_name;
799 p1_a36 := ddx_agenda_rec.description;
800 end;
801
802 procedure complete_agenda_rec(p1_a0 OUT NOCOPY NUMBER
803 , p1_a1 OUT NOCOPY NUMBER
804 , p1_a2 OUT NOCOPY DATE
805 , p1_a3 OUT NOCOPY NUMBER
806 , p1_a4 OUT NOCOPY DATE
807 , p1_a5 OUT NOCOPY NUMBER
808 , p1_a6 OUT NOCOPY NUMBER
809 , p1_a7 OUT NOCOPY NUMBER
810 , p1_a8 OUT NOCOPY NUMBER
811 , p1_a9 OUT NOCOPY VARCHAR2
812 , p1_a10 OUT NOCOPY VARCHAR2
813 , p1_a11 OUT NOCOPY VARCHAR2
814 , p1_a12 OUT NOCOPY NUMBER
815 , p1_a13 OUT NOCOPY DATE
816 , p1_a14 OUT NOCOPY DATE
817 , p1_a15 OUT NOCOPY NUMBER
818 , p1_a16 OUT NOCOPY NUMBER
819 , p1_a17 OUT NOCOPY VARCHAR2
820 , p1_a18 OUT NOCOPY NUMBER
821 , p1_a19 OUT NOCOPY VARCHAR2
822 , p1_a20 OUT NOCOPY VARCHAR2
823 , p1_a21 OUT NOCOPY VARCHAR2
824 , p1_a22 OUT NOCOPY VARCHAR2
825 , p1_a23 OUT NOCOPY VARCHAR2
826 , p1_a24 OUT NOCOPY VARCHAR2
827 , p1_a25 OUT NOCOPY VARCHAR2
828 , p1_a26 OUT NOCOPY VARCHAR2
829 , p1_a27 OUT NOCOPY VARCHAR2
830 , p1_a28 OUT NOCOPY VARCHAR2
831 , p1_a29 OUT NOCOPY VARCHAR2
832 , p1_a30 OUT NOCOPY VARCHAR2
833 , p1_a31 OUT NOCOPY VARCHAR2
834 , p1_a32 OUT NOCOPY VARCHAR2
835 , p1_a33 OUT NOCOPY VARCHAR2
836 , p1_a34 OUT NOCOPY VARCHAR2
837 , p1_a35 OUT NOCOPY VARCHAR2
838 , p1_a36 OUT NOCOPY VARCHAR2
839 , p0_a0 NUMBER := 0-1962.0724
840 , p0_a1 NUMBER := 0-1962.0724
841 , p0_a2 DATE := fnd_api.g_miss_date
842 , p0_a3 NUMBER := 0-1962.0724
843 , p0_a4 DATE := fnd_api.g_miss_date
844 , p0_a5 NUMBER := 0-1962.0724
845 , p0_a6 NUMBER := 0-1962.0724
846 , p0_a7 NUMBER := 0-1962.0724
847 , p0_a8 NUMBER := 0-1962.0724
848 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
849 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
850 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
851 , p0_a12 NUMBER := 0-1962.0724
852 , p0_a13 DATE := fnd_api.g_miss_date
853 , p0_a14 DATE := fnd_api.g_miss_date
854 , p0_a15 NUMBER := 0-1962.0724
855 , p0_a16 NUMBER := 0-1962.0724
856 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
857 , p0_a18 NUMBER := 0-1962.0724
858 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
862 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
859 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
860 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
861 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
863 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
864 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
865 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
866 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
867 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
868 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
869 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
870 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
871 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
872 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
873 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
874 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
875 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
876 )
877 as
878 ddp_agenda_rec ams_agendas_pvt.agenda_rec_type;
879 ddx_agenda_rec ams_agendas_pvt.agenda_rec_type;
880 ddindx binary_integer; indx binary_integer;
881 begin
882
886 ddp_agenda_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a2);
883 -- copy data to the local IN or IN-OUT args, if any
884 ddp_agenda_rec.agenda_id := rosetta_g_miss_num_map(p0_a0);
885 ddp_agenda_rec.setup_type_id := rosetta_g_miss_num_map(p0_a1);
887 ddp_agenda_rec.last_updated_by := rosetta_g_miss_num_map(p0_a3);
888 ddp_agenda_rec.creation_date := rosetta_g_miss_date_in_map(p0_a4);
889 ddp_agenda_rec.created_by := rosetta_g_miss_num_map(p0_a5);
890 ddp_agenda_rec.last_update_login := rosetta_g_miss_num_map(p0_a6);
891 ddp_agenda_rec.object_version_number := rosetta_g_miss_num_map(p0_a7);
892 ddp_agenda_rec.application_id := rosetta_g_miss_num_map(p0_a8);
893 ddp_agenda_rec.active_flag := p0_a9;
894 ddp_agenda_rec.default_track_flag := p0_a10;
895 ddp_agenda_rec.agenda_type := p0_a11;
896 ddp_agenda_rec.room_id := rosetta_g_miss_num_map(p0_a12);
897 ddp_agenda_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a13);
898 ddp_agenda_rec.end_date_time := rosetta_g_miss_date_in_map(p0_a14);
899 ddp_agenda_rec.coordinator_id := rosetta_g_miss_num_map(p0_a15);
900 ddp_agenda_rec.timezone_id := rosetta_g_miss_num_map(p0_a16);
901 ddp_agenda_rec.parent_type := p0_a17;
902 ddp_agenda_rec.parent_id := rosetta_g_miss_num_map(p0_a18);
903 ddp_agenda_rec.attribute_category := p0_a19;
904 ddp_agenda_rec.attribute1 := p0_a20;
905 ddp_agenda_rec.attribute2 := p0_a21;
906 ddp_agenda_rec.attribute3 := p0_a22;
907 ddp_agenda_rec.attribute4 := p0_a23;
908 ddp_agenda_rec.attribute5 := p0_a24;
909 ddp_agenda_rec.attribute6 := p0_a25;
910 ddp_agenda_rec.attribute7 := p0_a26;
911 ddp_agenda_rec.attribute8 := p0_a27;
912 ddp_agenda_rec.attribute9 := p0_a28;
913 ddp_agenda_rec.attribute10 := p0_a29;
914 ddp_agenda_rec.attribute11 := p0_a30;
915 ddp_agenda_rec.attribute12 := p0_a31;
916 ddp_agenda_rec.attribute13 := p0_a32;
917 ddp_agenda_rec.attribute14 := p0_a33;
918 ddp_agenda_rec.attribute15 := p0_a34;
919 ddp_agenda_rec.agenda_name := p0_a35;
920 ddp_agenda_rec.description := p0_a36;
921
922
923 -- here's the delegated call to the old PL/SQL routine
924 ams_agendas_pvt.complete_agenda_rec(ddp_agenda_rec,
925 ddx_agenda_rec);
926
927 -- copy data back from the local OUT or IN-OUT args, if any
928
929 p1_a0 := rosetta_g_miss_num_map(ddx_agenda_rec.agenda_id);
930 p1_a1 := rosetta_g_miss_num_map(ddx_agenda_rec.setup_type_id);
931 p1_a2 := ddx_agenda_rec.last_update_date;
932 p1_a3 := rosetta_g_miss_num_map(ddx_agenda_rec.last_updated_by);
933 p1_a4 := ddx_agenda_rec.creation_date;
934 p1_a5 := rosetta_g_miss_num_map(ddx_agenda_rec.created_by);
935 p1_a6 := rosetta_g_miss_num_map(ddx_agenda_rec.last_update_login);
936 p1_a7 := rosetta_g_miss_num_map(ddx_agenda_rec.object_version_number);
937 p1_a8 := rosetta_g_miss_num_map(ddx_agenda_rec.application_id);
938 p1_a9 := ddx_agenda_rec.active_flag;
939 p1_a10 := ddx_agenda_rec.default_track_flag;
940 p1_a11 := ddx_agenda_rec.agenda_type;
941 p1_a12 := rosetta_g_miss_num_map(ddx_agenda_rec.room_id);
942 p1_a13 := ddx_agenda_rec.start_date_time;
943 p1_a14 := ddx_agenda_rec.end_date_time;
944 p1_a15 := rosetta_g_miss_num_map(ddx_agenda_rec.coordinator_id);
945 p1_a16 := rosetta_g_miss_num_map(ddx_agenda_rec.timezone_id);
946 p1_a17 := ddx_agenda_rec.parent_type;
947 p1_a18 := rosetta_g_miss_num_map(ddx_agenda_rec.parent_id);
948 p1_a19 := ddx_agenda_rec.attribute_category;
949 p1_a20 := ddx_agenda_rec.attribute1;
950 p1_a21 := ddx_agenda_rec.attribute2;
951 p1_a22 := ddx_agenda_rec.attribute3;
952 p1_a23 := ddx_agenda_rec.attribute4;
953 p1_a24 := ddx_agenda_rec.attribute5;
954 p1_a25 := ddx_agenda_rec.attribute6;
955 p1_a26 := ddx_agenda_rec.attribute7;
956 p1_a27 := ddx_agenda_rec.attribute8;
957 p1_a28 := ddx_agenda_rec.attribute9;
958 p1_a29 := ddx_agenda_rec.attribute10;
959 p1_a30 := ddx_agenda_rec.attribute11;
960 p1_a31 := ddx_agenda_rec.attribute12;
961 p1_a32 := ddx_agenda_rec.attribute13;
962 p1_a33 := ddx_agenda_rec.attribute14;
963 p1_a34 := ddx_agenda_rec.attribute15;
964 p1_a35 := ddx_agenda_rec.agenda_name;
965 p1_a36 := ddx_agenda_rec.description;
966 end;
967
968 end ams_agendas_pvt_w;