[Home] [Help]
PACKAGE BODY: APPS.AMS_MEDIA_PVT_W
Source
1 package body ams_media_pvt_w as
2 /* $Header: amswmedb.pls 115.13 2002/12/30 05:38:57 cgoyal 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_media(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_media_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 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 )
60 as
61 ddp_media_rec ams_media_pvt.media_rec_type;
62 ddindx binary_integer; indx binary_integer;
63 begin
64
65 -- copy data to the local IN or IN-OUT args, if any
66
67
68
69
70
71
72
73 ddp_media_rec.media_id := rosetta_g_miss_num_map(p7_a0);
74 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
75 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
76 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
77 ddp_media_rec.created_by := rosetta_g_miss_num_map(p7_a4);
78 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
79 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
80 ddp_media_rec.media_type_code := p7_a7;
81 ddp_media_rec.media_type_name := p7_a8;
82 ddp_media_rec.inbound_flag := p7_a9;
83 ddp_media_rec.enabled_flag := p7_a10;
84 ddp_media_rec.attribute_category := p7_a11;
85 ddp_media_rec.attribute1 := p7_a12;
86 ddp_media_rec.attribute2 := p7_a13;
87 ddp_media_rec.attribute3 := p7_a14;
88 ddp_media_rec.attribute4 := p7_a15;
89 ddp_media_rec.attribute5 := p7_a16;
90 ddp_media_rec.attribute6 := p7_a17;
91 ddp_media_rec.attribute7 := p7_a18;
92 ddp_media_rec.attribute8 := p7_a19;
93 ddp_media_rec.attribute9 := p7_a20;
94 ddp_media_rec.attribute10 := p7_a21;
95 ddp_media_rec.attribute11 := p7_a22;
96 ddp_media_rec.attribute12 := p7_a23;
97 ddp_media_rec.attribute13 := p7_a24;
98 ddp_media_rec.attribute14 := p7_a25;
99 ddp_media_rec.attribute15 := p7_a26;
100 ddp_media_rec.media_name := p7_a27;
101 ddp_media_rec.description := p7_a28;
102
103
104 -- here's the delegated call to the old PL/SQL routine
105 ams_media_pvt.create_media(p_api_version,
106 p_init_msg_list,
107 p_commit,
108 p_validation_level,
109 x_return_status,
110 x_msg_count,
111 x_msg_data,
112 ddp_media_rec,
113 x_media_id);
114
115 -- copy data back from the local OUT or IN-OUT args, if any
116
117
118
119
120
121
122
123
124 end;
125
126 procedure update_media(p_api_version NUMBER
127 , p_init_msg_list VARCHAR2
128 , p_commit VARCHAR2
129 , p_validation_level NUMBER
130 , x_return_status OUT NOCOPY VARCHAR2
131 , x_msg_count OUT NOCOPY NUMBER
132 , x_msg_data OUT NOCOPY VARCHAR2
133 , p7_a0 NUMBER := 0-1962.0724
134 , p7_a1 DATE := fnd_api.g_miss_date
135 , p7_a2 NUMBER := 0-1962.0724
136 , p7_a3 DATE := fnd_api.g_miss_date
137 , p7_a4 NUMBER := 0-1962.0724
138 , p7_a5 NUMBER := 0-1962.0724
139 , p7_a6 NUMBER := 0-1962.0724
140 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
144 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
149 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
158 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
159 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
161 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
162 )
163 as
164 ddp_media_rec ams_media_pvt.media_rec_type;
165 ddindx binary_integer; indx binary_integer;
166 begin
167
168 -- copy data to the local IN or IN-OUT args, if any
169
170
171
172
173
174
175
176 ddp_media_rec.media_id := rosetta_g_miss_num_map(p7_a0);
177 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
178 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
179 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
180 ddp_media_rec.created_by := rosetta_g_miss_num_map(p7_a4);
181 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
182 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
183 ddp_media_rec.media_type_code := p7_a7;
184 ddp_media_rec.media_type_name := p7_a8;
185 ddp_media_rec.inbound_flag := p7_a9;
186 ddp_media_rec.enabled_flag := p7_a10;
187 ddp_media_rec.attribute_category := p7_a11;
188 ddp_media_rec.attribute1 := p7_a12;
189 ddp_media_rec.attribute2 := p7_a13;
190 ddp_media_rec.attribute3 := p7_a14;
191 ddp_media_rec.attribute4 := p7_a15;
192 ddp_media_rec.attribute5 := p7_a16;
193 ddp_media_rec.attribute6 := p7_a17;
194 ddp_media_rec.attribute7 := p7_a18;
195 ddp_media_rec.attribute8 := p7_a19;
196 ddp_media_rec.attribute9 := p7_a20;
197 ddp_media_rec.attribute10 := p7_a21;
198 ddp_media_rec.attribute11 := p7_a22;
199 ddp_media_rec.attribute12 := p7_a23;
200 ddp_media_rec.attribute13 := p7_a24;
201 ddp_media_rec.attribute14 := p7_a25;
202 ddp_media_rec.attribute15 := p7_a26;
203 ddp_media_rec.media_name := p7_a27;
204 ddp_media_rec.description := p7_a28;
205
206 -- here's the delegated call to the old PL/SQL routine
207 ams_media_pvt.update_media(p_api_version,
208 p_init_msg_list,
209 p_commit,
210 p_validation_level,
211 x_return_status,
212 x_msg_count,
213 x_msg_data,
214 ddp_media_rec);
215
216 -- copy data back from the local OUT or IN-OUT args, if any
217
218
219
220
221
222
223
224 end;
225
226 procedure validate_media(p_api_version NUMBER
227 , p_init_msg_list VARCHAR2
228 , p_commit VARCHAR2
229 , p_validation_level NUMBER
230 , x_return_status OUT NOCOPY VARCHAR2
231 , x_msg_count OUT NOCOPY NUMBER
232 , x_msg_data OUT NOCOPY VARCHAR2
233 , p7_a0 NUMBER := 0-1962.0724
234 , p7_a1 DATE := fnd_api.g_miss_date
235 , p7_a2 NUMBER := 0-1962.0724
236 , p7_a3 DATE := fnd_api.g_miss_date
237 , p7_a4 NUMBER := 0-1962.0724
238 , p7_a5 NUMBER := 0-1962.0724
239 , p7_a6 NUMBER := 0-1962.0724
240 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
241 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
242 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
243 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
244 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
245 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
246 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
247 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
248 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
249 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
250 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
251 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
253 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
259 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
260 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
262 )
263 as
264 ddp_media_rec ams_media_pvt.media_rec_type;
265 ddindx binary_integer; indx binary_integer;
266 begin
267
268 -- copy data to the local IN or IN-OUT args, if any
269
270
271
272
273
274
275
276 ddp_media_rec.media_id := rosetta_g_miss_num_map(p7_a0);
277 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
278 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
279 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
280 ddp_media_rec.created_by := rosetta_g_miss_num_map(p7_a4);
281 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
282 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
283 ddp_media_rec.media_type_code := p7_a7;
284 ddp_media_rec.media_type_name := p7_a8;
285 ddp_media_rec.inbound_flag := p7_a9;
286 ddp_media_rec.enabled_flag := p7_a10;
287 ddp_media_rec.attribute_category := p7_a11;
288 ddp_media_rec.attribute1 := p7_a12;
289 ddp_media_rec.attribute2 := p7_a13;
290 ddp_media_rec.attribute3 := p7_a14;
291 ddp_media_rec.attribute4 := p7_a15;
292 ddp_media_rec.attribute5 := p7_a16;
293 ddp_media_rec.attribute6 := p7_a17;
294 ddp_media_rec.attribute7 := p7_a18;
295 ddp_media_rec.attribute8 := p7_a19;
296 ddp_media_rec.attribute9 := p7_a20;
297 ddp_media_rec.attribute10 := p7_a21;
298 ddp_media_rec.attribute11 := p7_a22;
299 ddp_media_rec.attribute12 := p7_a23;
300 ddp_media_rec.attribute13 := p7_a24;
301 ddp_media_rec.attribute14 := p7_a25;
302 ddp_media_rec.attribute15 := p7_a26;
303 ddp_media_rec.media_name := p7_a27;
304 ddp_media_rec.description := p7_a28;
305
306 -- here's the delegated call to the old PL/SQL routine
307 ams_media_pvt.validate_media(p_api_version,
308 p_init_msg_list,
309 p_commit,
310 p_validation_level,
311 x_return_status,
312 x_msg_count,
313 x_msg_data,
314 ddp_media_rec);
315
316 -- copy data back from the local OUT or IN-OUT args, if any
317
318
319
320
321
322
323
324 end;
325
326 procedure check_media_items(p_validation_mode VARCHAR2
327 , x_return_status OUT NOCOPY VARCHAR2
328 , p0_a0 NUMBER := 0-1962.0724
329 , p0_a1 DATE := fnd_api.g_miss_date
330 , p0_a2 NUMBER := 0-1962.0724
331 , p0_a3 DATE := fnd_api.g_miss_date
332 , p0_a4 NUMBER := 0-1962.0724
333 , p0_a5 NUMBER := 0-1962.0724
334 , p0_a6 NUMBER := 0-1962.0724
335 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
336 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
337 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
338 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
339 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
340 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
341 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
342 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
343 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
344 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
345 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
346 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
347 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
348 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
349 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
350 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
351 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
352 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
353 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
354 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
355 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
356 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
357 )
358 as
359 ddp_media_rec ams_media_pvt.media_rec_type;
360 ddindx binary_integer; indx binary_integer;
361 begin
362
363 -- copy data to the local IN or IN-OUT args, if any
364 ddp_media_rec.media_id := rosetta_g_miss_num_map(p0_a0);
365 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
366 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
367 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
368 ddp_media_rec.created_by := rosetta_g_miss_num_map(p0_a4);
369 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
370 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
371 ddp_media_rec.media_type_code := p0_a7;
372 ddp_media_rec.media_type_name := p0_a8;
373 ddp_media_rec.inbound_flag := p0_a9;
374 ddp_media_rec.enabled_flag := p0_a10;
375 ddp_media_rec.attribute_category := p0_a11;
376 ddp_media_rec.attribute1 := p0_a12;
377 ddp_media_rec.attribute2 := p0_a13;
378 ddp_media_rec.attribute3 := p0_a14;
379 ddp_media_rec.attribute4 := p0_a15;
380 ddp_media_rec.attribute5 := p0_a16;
381 ddp_media_rec.attribute6 := p0_a17;
382 ddp_media_rec.attribute7 := p0_a18;
383 ddp_media_rec.attribute8 := p0_a19;
384 ddp_media_rec.attribute9 := p0_a20;
385 ddp_media_rec.attribute10 := p0_a21;
386 ddp_media_rec.attribute11 := p0_a22;
387 ddp_media_rec.attribute12 := p0_a23;
388 ddp_media_rec.attribute13 := p0_a24;
389 ddp_media_rec.attribute14 := p0_a25;
390 ddp_media_rec.attribute15 := p0_a26;
391 ddp_media_rec.media_name := p0_a27;
392 ddp_media_rec.description := p0_a28;
393
394
395
396 -- here's the delegated call to the old PL/SQL routine
397 ams_media_pvt.check_media_items(ddp_media_rec,
398 p_validation_mode,
399 x_return_status);
400
401 -- copy data back from the local OUT or IN-OUT args, if any
402
403
404 end;
405
406 procedure check_media_record(x_return_status OUT NOCOPY VARCHAR2
407 , p0_a0 NUMBER := 0-1962.0724
408 , p0_a1 DATE := fnd_api.g_miss_date
409 , p0_a2 NUMBER := 0-1962.0724
410 , p0_a3 DATE := fnd_api.g_miss_date
411 , p0_a4 NUMBER := 0-1962.0724
412 , p0_a5 NUMBER := 0-1962.0724
413 , p0_a6 NUMBER := 0-1962.0724
414 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
415 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
416 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
417 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
418 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
419 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
420 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
421 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
422 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
423 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
424 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
425 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
426 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
427 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
428 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
429 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
430 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
431 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
432 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
433 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
434 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
435 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
436 , p1_a0 NUMBER := 0-1962.0724
437 , p1_a1 DATE := fnd_api.g_miss_date
438 , p1_a2 NUMBER := 0-1962.0724
439 , p1_a3 DATE := fnd_api.g_miss_date
440 , p1_a4 NUMBER := 0-1962.0724
441 , p1_a5 NUMBER := 0-1962.0724
442 , p1_a6 NUMBER := 0-1962.0724
443 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
444 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
445 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
446 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
447 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
448 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
449 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
450 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
451 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
452 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
453 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
454 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
455 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
456 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
457 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
458 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
459 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
460 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
461 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
462 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
463 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
464 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
465 )
466 as
467 ddp_media_rec ams_media_pvt.media_rec_type;
468 ddp_complete_rec ams_media_pvt.media_rec_type;
469 ddindx binary_integer; indx binary_integer;
470 begin
471
472 -- copy data to the local IN or IN-OUT args, if any
473 ddp_media_rec.media_id := rosetta_g_miss_num_map(p0_a0);
474 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
475 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
476 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
477 ddp_media_rec.created_by := rosetta_g_miss_num_map(p0_a4);
478 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
479 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
480 ddp_media_rec.media_type_code := p0_a7;
481 ddp_media_rec.media_type_name := p0_a8;
482 ddp_media_rec.inbound_flag := p0_a9;
483 ddp_media_rec.enabled_flag := p0_a10;
484 ddp_media_rec.attribute_category := p0_a11;
485 ddp_media_rec.attribute1 := p0_a12;
486 ddp_media_rec.attribute2 := p0_a13;
487 ddp_media_rec.attribute3 := p0_a14;
488 ddp_media_rec.attribute4 := p0_a15;
489 ddp_media_rec.attribute5 := p0_a16;
490 ddp_media_rec.attribute6 := p0_a17;
491 ddp_media_rec.attribute7 := p0_a18;
492 ddp_media_rec.attribute8 := p0_a19;
493 ddp_media_rec.attribute9 := p0_a20;
494 ddp_media_rec.attribute10 := p0_a21;
495 ddp_media_rec.attribute11 := p0_a22;
496 ddp_media_rec.attribute12 := p0_a23;
497 ddp_media_rec.attribute13 := p0_a24;
498 ddp_media_rec.attribute14 := p0_a25;
499 ddp_media_rec.attribute15 := p0_a26;
500 ddp_media_rec.media_name := p0_a27;
501 ddp_media_rec.description := p0_a28;
502
503 ddp_complete_rec.media_id := rosetta_g_miss_num_map(p1_a0);
507 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
504 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
505 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
506 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
508 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
509 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
510 ddp_complete_rec.media_type_code := p1_a7;
511 ddp_complete_rec.media_type_name := p1_a8;
512 ddp_complete_rec.inbound_flag := p1_a9;
513 ddp_complete_rec.enabled_flag := p1_a10;
514 ddp_complete_rec.attribute_category := p1_a11;
515 ddp_complete_rec.attribute1 := p1_a12;
516 ddp_complete_rec.attribute2 := p1_a13;
517 ddp_complete_rec.attribute3 := p1_a14;
518 ddp_complete_rec.attribute4 := p1_a15;
519 ddp_complete_rec.attribute5 := p1_a16;
520 ddp_complete_rec.attribute6 := p1_a17;
521 ddp_complete_rec.attribute7 := p1_a18;
522 ddp_complete_rec.attribute8 := p1_a19;
523 ddp_complete_rec.attribute9 := p1_a20;
524 ddp_complete_rec.attribute10 := p1_a21;
525 ddp_complete_rec.attribute11 := p1_a22;
526 ddp_complete_rec.attribute12 := p1_a23;
527 ddp_complete_rec.attribute13 := p1_a24;
528 ddp_complete_rec.attribute14 := p1_a25;
529 ddp_complete_rec.attribute15 := p1_a26;
530 ddp_complete_rec.media_name := p1_a27;
531 ddp_complete_rec.description := p1_a28;
532
533
534 -- here's the delegated call to the old PL/SQL routine
535 ams_media_pvt.check_media_record(ddp_media_rec,
536 ddp_complete_rec,
537 x_return_status);
538
539 -- copy data back from the local OUT or IN-OUT args, if any
540
541
542 end;
543
544 procedure init_media_rec(p0_a0 OUT NOCOPY NUMBER
545 , p0_a1 OUT NOCOPY DATE
546 , p0_a2 OUT NOCOPY NUMBER
547 , p0_a3 OUT NOCOPY DATE
548 , p0_a4 OUT NOCOPY NUMBER
549 , p0_a5 OUT NOCOPY NUMBER
550 , p0_a6 OUT NOCOPY NUMBER
551 , p0_a7 OUT NOCOPY VARCHAR2
552 , p0_a8 OUT NOCOPY VARCHAR2
553 , p0_a9 OUT NOCOPY VARCHAR2
554 , p0_a10 OUT NOCOPY VARCHAR2
555 , p0_a11 OUT NOCOPY VARCHAR2
556 , p0_a12 OUT NOCOPY VARCHAR2
557 , p0_a13 OUT NOCOPY VARCHAR2
558 , p0_a14 OUT NOCOPY VARCHAR2
559 , p0_a15 OUT NOCOPY VARCHAR2
560 , p0_a16 OUT NOCOPY VARCHAR2
561 , p0_a17 OUT NOCOPY VARCHAR2
562 , p0_a18 OUT NOCOPY VARCHAR2
563 , p0_a19 OUT NOCOPY VARCHAR2
564 , p0_a20 OUT NOCOPY VARCHAR2
565 , p0_a21 OUT NOCOPY VARCHAR2
566 , p0_a22 OUT NOCOPY VARCHAR2
567 , p0_a23 OUT NOCOPY VARCHAR2
568 , p0_a24 OUT NOCOPY VARCHAR2
569 , p0_a25 OUT NOCOPY VARCHAR2
570 , p0_a26 OUT NOCOPY VARCHAR2
571 , p0_a27 OUT NOCOPY VARCHAR2
572 , p0_a28 OUT NOCOPY VARCHAR2
573 )
574 as
575 ddx_media_rec ams_media_pvt.media_rec_type;
576 ddindx binary_integer; indx binary_integer;
577 begin
578
579 -- copy data to the local IN or IN-OUT args, if any
580
581 -- here's the delegated call to the old PL/SQL routine
582 ams_media_pvt.init_media_rec(ddx_media_rec);
583
584 -- copy data back from the local OUT or IN-OUT args, if any
585 p0_a0 := rosetta_g_miss_num_map(ddx_media_rec.media_id);
586 p0_a1 := ddx_media_rec.last_update_date;
587 p0_a2 := rosetta_g_miss_num_map(ddx_media_rec.last_updated_by);
588 p0_a3 := ddx_media_rec.creation_date;
589 p0_a4 := rosetta_g_miss_num_map(ddx_media_rec.created_by);
590 p0_a5 := rosetta_g_miss_num_map(ddx_media_rec.last_update_login);
591 p0_a6 := rosetta_g_miss_num_map(ddx_media_rec.object_version_number);
592 p0_a7 := ddx_media_rec.media_type_code;
593 p0_a8 := ddx_media_rec.media_type_name;
594 p0_a9 := ddx_media_rec.inbound_flag;
595 p0_a10 := ddx_media_rec.enabled_flag;
596 p0_a11 := ddx_media_rec.attribute_category;
597 p0_a12 := ddx_media_rec.attribute1;
598 p0_a13 := ddx_media_rec.attribute2;
599 p0_a14 := ddx_media_rec.attribute3;
600 p0_a15 := ddx_media_rec.attribute4;
601 p0_a16 := ddx_media_rec.attribute5;
602 p0_a17 := ddx_media_rec.attribute6;
603 p0_a18 := ddx_media_rec.attribute7;
604 p0_a19 := ddx_media_rec.attribute8;
605 p0_a20 := ddx_media_rec.attribute9;
606 p0_a21 := ddx_media_rec.attribute10;
607 p0_a22 := ddx_media_rec.attribute11;
608 p0_a23 := ddx_media_rec.attribute12;
609 p0_a24 := ddx_media_rec.attribute13;
610 p0_a25 := ddx_media_rec.attribute14;
611 p0_a26 := ddx_media_rec.attribute15;
612 p0_a27 := ddx_media_rec.media_name;
613 p0_a28 := ddx_media_rec.description;
614 end;
615
616 procedure complete_media_rec(p1_a0 OUT NOCOPY NUMBER
617 , p1_a1 OUT NOCOPY DATE
618 , p1_a2 OUT NOCOPY NUMBER
619 , p1_a3 OUT NOCOPY DATE
620 , p1_a4 OUT NOCOPY NUMBER
621 , p1_a5 OUT NOCOPY NUMBER
622 , p1_a6 OUT NOCOPY NUMBER
623 , p1_a7 OUT NOCOPY VARCHAR2
624 , p1_a8 OUT NOCOPY VARCHAR2
625 , p1_a9 OUT NOCOPY VARCHAR2
626 , p1_a10 OUT NOCOPY VARCHAR2
627 , p1_a11 OUT NOCOPY VARCHAR2
628 , p1_a12 OUT NOCOPY VARCHAR2
629 , p1_a13 OUT NOCOPY VARCHAR2
633 , p1_a17 OUT NOCOPY VARCHAR2
630 , p1_a14 OUT NOCOPY VARCHAR2
631 , p1_a15 OUT NOCOPY VARCHAR2
632 , p1_a16 OUT NOCOPY VARCHAR2
634 , p1_a18 OUT NOCOPY VARCHAR2
635 , p1_a19 OUT NOCOPY VARCHAR2
636 , p1_a20 OUT NOCOPY VARCHAR2
637 , p1_a21 OUT NOCOPY VARCHAR2
638 , p1_a22 OUT NOCOPY VARCHAR2
639 , p1_a23 OUT NOCOPY VARCHAR2
640 , p1_a24 OUT NOCOPY VARCHAR2
641 , p1_a25 OUT NOCOPY VARCHAR2
642 , p1_a26 OUT NOCOPY VARCHAR2
643 , p1_a27 OUT NOCOPY VARCHAR2
644 , p1_a28 OUT NOCOPY VARCHAR2
645 , p0_a0 NUMBER := 0-1962.0724
646 , p0_a1 DATE := fnd_api.g_miss_date
647 , p0_a2 NUMBER := 0-1962.0724
648 , p0_a3 DATE := fnd_api.g_miss_date
649 , p0_a4 NUMBER := 0-1962.0724
650 , p0_a5 NUMBER := 0-1962.0724
651 , p0_a6 NUMBER := 0-1962.0724
652 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
653 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
654 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
655 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
656 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
657 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
658 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
659 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
660 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
661 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
662 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
663 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
664 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
665 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
666 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
667 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
668 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
669 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
670 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
671 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
672 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
673 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
674 )
675 as
676 ddp_media_rec ams_media_pvt.media_rec_type;
677 ddx_complete_rec ams_media_pvt.media_rec_type;
678 ddindx binary_integer; indx binary_integer;
679 begin
680
681 -- copy data to the local IN or IN-OUT args, if any
682 ddp_media_rec.media_id := rosetta_g_miss_num_map(p0_a0);
683 ddp_media_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
684 ddp_media_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
685 ddp_media_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
686 ddp_media_rec.created_by := rosetta_g_miss_num_map(p0_a4);
687 ddp_media_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
688 ddp_media_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
689 ddp_media_rec.media_type_code := p0_a7;
690 ddp_media_rec.media_type_name := p0_a8;
691 ddp_media_rec.inbound_flag := p0_a9;
692 ddp_media_rec.enabled_flag := p0_a10;
693 ddp_media_rec.attribute_category := p0_a11;
694 ddp_media_rec.attribute1 := p0_a12;
695 ddp_media_rec.attribute2 := p0_a13;
696 ddp_media_rec.attribute3 := p0_a14;
697 ddp_media_rec.attribute4 := p0_a15;
698 ddp_media_rec.attribute5 := p0_a16;
699 ddp_media_rec.attribute6 := p0_a17;
700 ddp_media_rec.attribute7 := p0_a18;
701 ddp_media_rec.attribute8 := p0_a19;
702 ddp_media_rec.attribute9 := p0_a20;
703 ddp_media_rec.attribute10 := p0_a21;
704 ddp_media_rec.attribute11 := p0_a22;
705 ddp_media_rec.attribute12 := p0_a23;
706 ddp_media_rec.attribute13 := p0_a24;
707 ddp_media_rec.attribute14 := p0_a25;
708 ddp_media_rec.attribute15 := p0_a26;
709 ddp_media_rec.media_name := p0_a27;
710 ddp_media_rec.description := p0_a28;
711
712
713 -- here's the delegated call to the old PL/SQL routine
714 ams_media_pvt.complete_media_rec(ddp_media_rec,
715 ddx_complete_rec);
716
717 -- copy data back from the local OUT or IN-OUT args, if any
718
719 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.media_id);
720 p1_a1 := ddx_complete_rec.last_update_date;
721 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
722 p1_a3 := ddx_complete_rec.creation_date;
723 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
724 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
725 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
726 p1_a7 := ddx_complete_rec.media_type_code;
727 p1_a8 := ddx_complete_rec.media_type_name;
728 p1_a9 := ddx_complete_rec.inbound_flag;
729 p1_a10 := ddx_complete_rec.enabled_flag;
730 p1_a11 := ddx_complete_rec.attribute_category;
731 p1_a12 := ddx_complete_rec.attribute1;
732 p1_a13 := ddx_complete_rec.attribute2;
733 p1_a14 := ddx_complete_rec.attribute3;
734 p1_a15 := ddx_complete_rec.attribute4;
735 p1_a16 := ddx_complete_rec.attribute5;
736 p1_a17 := ddx_complete_rec.attribute6;
737 p1_a18 := ddx_complete_rec.attribute7;
738 p1_a19 := ddx_complete_rec.attribute8;
739 p1_a20 := ddx_complete_rec.attribute9;
740 p1_a21 := ddx_complete_rec.attribute10;
741 p1_a22 := ddx_complete_rec.attribute11;
742 p1_a23 := ddx_complete_rec.attribute12;
743 p1_a24 := ddx_complete_rec.attribute13;
744 p1_a25 := ddx_complete_rec.attribute14;
745 p1_a26 := ddx_complete_rec.attribute15;
746 p1_a27 := ddx_complete_rec.media_name;
750 procedure create_mediachannel(p_api_version NUMBER
747 p1_a28 := ddx_complete_rec.description;
748 end;
749
751 , p_init_msg_list VARCHAR2
752 , p_commit VARCHAR2
753 , p_validation_level NUMBER
754 , x_return_status OUT NOCOPY VARCHAR2
755 , x_msg_count OUT NOCOPY NUMBER
756 , x_msg_data OUT NOCOPY VARCHAR2
757 , x_mediachl_id OUT NOCOPY NUMBER
758 , p7_a0 NUMBER := 0-1962.0724
759 , p7_a1 DATE := fnd_api.g_miss_date
760 , p7_a2 NUMBER := 0-1962.0724
761 , p7_a3 DATE := fnd_api.g_miss_date
762 , p7_a4 NUMBER := 0-1962.0724
763 , p7_a5 NUMBER := 0-1962.0724
764 , p7_a6 NUMBER := 0-1962.0724
765 , p7_a7 NUMBER := 0-1962.0724
766 , p7_a8 NUMBER := 0-1962.0724
767 , p7_a9 DATE := fnd_api.g_miss_date
768 , p7_a10 DATE := fnd_api.g_miss_date
769 )
770 as
771 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
772 ddindx binary_integer; indx binary_integer;
773 begin
774
775 -- copy data to the local IN or IN-OUT args, if any
776
777
778
779
780
781
782
783 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p7_a0);
784 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
785 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
786 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
787 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p7_a4);
788 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
789 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
790 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p7_a7);
791 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p7_a8);
792 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p7_a9);
793 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
794
795
796 -- here's the delegated call to the old PL/SQL routine
797 ams_media_pvt.create_mediachannel(p_api_version,
798 p_init_msg_list,
799 p_commit,
800 p_validation_level,
801 x_return_status,
802 x_msg_count,
803 x_msg_data,
804 ddp_mediachl_rec,
805 x_mediachl_id);
806
807 -- copy data back from the local OUT or IN-OUT args, if any
808
809
810
811
812
813
814
815
816 end;
817
818 procedure update_mediachannel(p_api_version NUMBER
819 , p_init_msg_list VARCHAR2
820 , p_commit VARCHAR2
821 , p_validation_level NUMBER
822 , x_return_status OUT NOCOPY VARCHAR2
823 , x_msg_count OUT NOCOPY NUMBER
824 , x_msg_data OUT NOCOPY VARCHAR2
825 , p7_a0 NUMBER := 0-1962.0724
826 , p7_a1 DATE := fnd_api.g_miss_date
827 , p7_a2 NUMBER := 0-1962.0724
828 , p7_a3 DATE := fnd_api.g_miss_date
829 , p7_a4 NUMBER := 0-1962.0724
830 , p7_a5 NUMBER := 0-1962.0724
831 , p7_a6 NUMBER := 0-1962.0724
832 , p7_a7 NUMBER := 0-1962.0724
833 , p7_a8 NUMBER := 0-1962.0724
834 , p7_a9 DATE := fnd_api.g_miss_date
835 , p7_a10 DATE := fnd_api.g_miss_date
836 )
837 as
838 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
839 ddindx binary_integer; indx binary_integer;
840 begin
841
842 -- copy data to the local IN or IN-OUT args, if any
843
844
845
846
847
848
849
850 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p7_a0);
851 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
852 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
853 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
854 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p7_a4);
855 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
856 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
857 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p7_a7);
858 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p7_a8);
859 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p7_a9);
860 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
861
862 -- here's the delegated call to the old PL/SQL routine
863 ams_media_pvt.update_mediachannel(p_api_version,
864 p_init_msg_list,
865 p_commit,
866 p_validation_level,
867 x_return_status,
868 x_msg_count,
869 x_msg_data,
870 ddp_mediachl_rec);
871
872 -- copy data back from the local OUT or IN-OUT args, if any
873
874
875
876
877
878
879
880 end;
881
882 procedure validate_mediachannel(p_api_version NUMBER
883 , p_init_msg_list VARCHAR2
884 , p_commit VARCHAR2
885 , p_validation_level NUMBER
886 , x_return_status OUT NOCOPY VARCHAR2
887 , x_msg_count OUT NOCOPY NUMBER
888 , x_msg_data OUT NOCOPY VARCHAR2
889 , p7_a0 NUMBER := 0-1962.0724
890 , p7_a1 DATE := fnd_api.g_miss_date
891 , p7_a2 NUMBER := 0-1962.0724
892 , p7_a3 DATE := fnd_api.g_miss_date
893 , p7_a4 NUMBER := 0-1962.0724
897 , p7_a8 NUMBER := 0-1962.0724
894 , p7_a5 NUMBER := 0-1962.0724
895 , p7_a6 NUMBER := 0-1962.0724
896 , p7_a7 NUMBER := 0-1962.0724
898 , p7_a9 DATE := fnd_api.g_miss_date
899 , p7_a10 DATE := fnd_api.g_miss_date
900 )
901 as
902 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
903 ddindx binary_integer; indx binary_integer;
904 begin
905
906 -- copy data to the local IN or IN-OUT args, if any
907
908
909
910
911
912
913
914 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p7_a0);
915 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
916 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
917 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
918 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p7_a4);
919 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
920 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
921 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p7_a7);
922 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p7_a8);
923 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p7_a9);
924 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p7_a10);
925
926 -- here's the delegated call to the old PL/SQL routine
927 ams_media_pvt.validate_mediachannel(p_api_version,
928 p_init_msg_list,
929 p_commit,
930 p_validation_level,
931 x_return_status,
932 x_msg_count,
933 x_msg_data,
934 ddp_mediachl_rec);
935
936 -- copy data back from the local OUT or IN-OUT args, if any
937
938
939
940
941
942
943
944 end;
945
946 procedure check_mediachannel_items(p_validation_mode VARCHAR2
947 , x_return_status OUT NOCOPY VARCHAR2
948 , p0_a0 NUMBER := 0-1962.0724
949 , p0_a1 DATE := fnd_api.g_miss_date
950 , p0_a2 NUMBER := 0-1962.0724
951 , p0_a3 DATE := fnd_api.g_miss_date
952 , p0_a4 NUMBER := 0-1962.0724
953 , p0_a5 NUMBER := 0-1962.0724
954 , p0_a6 NUMBER := 0-1962.0724
955 , p0_a7 NUMBER := 0-1962.0724
956 , p0_a8 NUMBER := 0-1962.0724
957 , p0_a9 DATE := fnd_api.g_miss_date
958 , p0_a10 DATE := fnd_api.g_miss_date
959 )
960 as
961 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
962 ddindx binary_integer; indx binary_integer;
963 begin
964
965 -- copy data to the local IN or IN-OUT args, if any
966 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p0_a0);
967 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
968 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
969 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
970 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p0_a4);
971 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
972 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
973 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p0_a7);
974 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p0_a8);
975 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p0_a9);
976 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p0_a10);
977
978
979
980 -- here's the delegated call to the old PL/SQL routine
981 ams_media_pvt.check_mediachannel_items(ddp_mediachl_rec,
982 p_validation_mode,
983 x_return_status);
984
985 -- copy data back from the local OUT or IN-OUT args, if any
986
987
988 end;
989
990 procedure check_mediachannel_record(x_return_status OUT NOCOPY VARCHAR2
991 , p0_a0 NUMBER := 0-1962.0724
992 , p0_a1 DATE := fnd_api.g_miss_date
993 , p0_a2 NUMBER := 0-1962.0724
994 , p0_a3 DATE := fnd_api.g_miss_date
995 , p0_a4 NUMBER := 0-1962.0724
996 , p0_a5 NUMBER := 0-1962.0724
997 , p0_a6 NUMBER := 0-1962.0724
998 , p0_a7 NUMBER := 0-1962.0724
999 , p0_a8 NUMBER := 0-1962.0724
1000 , p0_a9 DATE := fnd_api.g_miss_date
1001 , p0_a10 DATE := fnd_api.g_miss_date
1002 , p1_a0 NUMBER := 0-1962.0724
1003 , p1_a1 DATE := fnd_api.g_miss_date
1004 , p1_a2 NUMBER := 0-1962.0724
1005 , p1_a3 DATE := fnd_api.g_miss_date
1006 , p1_a4 NUMBER := 0-1962.0724
1007 , p1_a5 NUMBER := 0-1962.0724
1008 , p1_a6 NUMBER := 0-1962.0724
1009 , p1_a7 NUMBER := 0-1962.0724
1010 , p1_a8 NUMBER := 0-1962.0724
1011 , p1_a9 DATE := fnd_api.g_miss_date
1012 , p1_a10 DATE := fnd_api.g_miss_date
1013 )
1014 as
1015 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1016 ddp_complete_rec ams_media_pvt.mediachannel_rec_type;
1017 ddindx binary_integer; indx binary_integer;
1018 begin
1019
1020 -- copy data to the local IN or IN-OUT args, if any
1021 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p0_a0);
1022 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1023 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1024 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1028 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p0_a7);
1025 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1026 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1027 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1029 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p0_a8);
1030 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p0_a9);
1031 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p0_a10);
1032
1033 ddp_complete_rec.media_channel_id := rosetta_g_miss_num_map(p1_a0);
1034 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
1035 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
1036 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
1037 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
1038 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
1039 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
1040 ddp_complete_rec.media_id := rosetta_g_miss_num_map(p1_a7);
1041 ddp_complete_rec.channel_id := rosetta_g_miss_num_map(p1_a8);
1042 ddp_complete_rec.active_from_date := rosetta_g_miss_date_in_map(p1_a9);
1043 ddp_complete_rec.active_to_date := rosetta_g_miss_date_in_map(p1_a10);
1044
1045
1046 -- here's the delegated call to the old PL/SQL routine
1047 ams_media_pvt.check_mediachannel_record(ddp_mediachl_rec,
1048 ddp_complete_rec,
1049 x_return_status);
1050
1051 -- copy data back from the local OUT or IN-OUT args, if any
1052
1053
1054 end;
1055
1056 procedure init_mediachannel_rec(p0_a0 OUT NOCOPY NUMBER
1057 , p0_a1 OUT NOCOPY DATE
1058 , p0_a2 OUT NOCOPY NUMBER
1059 , p0_a3 OUT NOCOPY DATE
1060 , p0_a4 OUT NOCOPY NUMBER
1061 , p0_a5 OUT NOCOPY NUMBER
1062 , p0_a6 OUT NOCOPY NUMBER
1063 , p0_a7 OUT NOCOPY NUMBER
1064 , p0_a8 OUT NOCOPY NUMBER
1065 , p0_a9 OUT NOCOPY DATE
1066 , p0_a10 OUT NOCOPY DATE
1067 )
1068 as
1069 ddx_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1070 ddindx binary_integer; indx binary_integer;
1071 begin
1072
1073 -- copy data to the local IN or IN-OUT args, if any
1074
1075 -- here's the delegated call to the old PL/SQL routine
1076 ams_media_pvt.init_mediachannel_rec(ddx_mediachl_rec);
1077
1078 -- copy data back from the local OUT or IN-OUT args, if any
1079 p0_a0 := rosetta_g_miss_num_map(ddx_mediachl_rec.media_channel_id);
1080 p0_a1 := ddx_mediachl_rec.last_update_date;
1081 p0_a2 := rosetta_g_miss_num_map(ddx_mediachl_rec.last_updated_by);
1082 p0_a3 := ddx_mediachl_rec.creation_date;
1083 p0_a4 := rosetta_g_miss_num_map(ddx_mediachl_rec.created_by);
1084 p0_a5 := rosetta_g_miss_num_map(ddx_mediachl_rec.last_update_login);
1085 p0_a6 := rosetta_g_miss_num_map(ddx_mediachl_rec.object_version_number);
1086 p0_a7 := rosetta_g_miss_num_map(ddx_mediachl_rec.media_id);
1087 p0_a8 := rosetta_g_miss_num_map(ddx_mediachl_rec.channel_id);
1088 p0_a9 := ddx_mediachl_rec.active_from_date;
1089 p0_a10 := ddx_mediachl_rec.active_to_date;
1090 end;
1091
1092 procedure complete_mediachannel_rec(p1_a0 OUT NOCOPY NUMBER
1093 , p1_a1 OUT NOCOPY DATE
1094 , p1_a2 OUT NOCOPY NUMBER
1095 , p1_a3 OUT NOCOPY DATE
1096 , p1_a4 OUT NOCOPY NUMBER
1097 , p1_a5 OUT NOCOPY NUMBER
1098 , p1_a6 OUT NOCOPY NUMBER
1099 , p1_a7 OUT NOCOPY NUMBER
1100 , p1_a8 OUT NOCOPY NUMBER
1101 , p1_a9 OUT NOCOPY DATE
1102 , p1_a10 OUT NOCOPY DATE
1103 , p0_a0 NUMBER := 0-1962.0724
1104 , p0_a1 DATE := fnd_api.g_miss_date
1105 , p0_a2 NUMBER := 0-1962.0724
1106 , p0_a3 DATE := fnd_api.g_miss_date
1107 , p0_a4 NUMBER := 0-1962.0724
1108 , p0_a5 NUMBER := 0-1962.0724
1109 , p0_a6 NUMBER := 0-1962.0724
1110 , p0_a7 NUMBER := 0-1962.0724
1111 , p0_a8 NUMBER := 0-1962.0724
1112 , p0_a9 DATE := fnd_api.g_miss_date
1113 , p0_a10 DATE := fnd_api.g_miss_date
1114 )
1115 as
1116 ddp_mediachl_rec ams_media_pvt.mediachannel_rec_type;
1117 ddx_complete_rec ams_media_pvt.mediachannel_rec_type;
1118 ddindx binary_integer; indx binary_integer;
1119 begin
1120
1121 -- copy data to the local IN or IN-OUT args, if any
1122 ddp_mediachl_rec.media_channel_id := rosetta_g_miss_num_map(p0_a0);
1123 ddp_mediachl_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1124 ddp_mediachl_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1125 ddp_mediachl_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1126 ddp_mediachl_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1127 ddp_mediachl_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1128 ddp_mediachl_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1129 ddp_mediachl_rec.media_id := rosetta_g_miss_num_map(p0_a7);
1130 ddp_mediachl_rec.channel_id := rosetta_g_miss_num_map(p0_a8);
1131 ddp_mediachl_rec.active_from_date := rosetta_g_miss_date_in_map(p0_a9);
1132 ddp_mediachl_rec.active_to_date := rosetta_g_miss_date_in_map(p0_a10);
1133
1134
1135 -- here's the delegated call to the old PL/SQL routine
1136 ams_media_pvt.complete_mediachannel_rec(ddp_mediachl_rec,
1137 ddx_complete_rec);
1138
1139 -- copy data back from the local OUT or IN-OUT args, if any
1140
1141 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.media_channel_id);
1142 p1_a1 := ddx_complete_rec.last_update_date;
1143 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
1144 p1_a3 := ddx_complete_rec.creation_date;
1145 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
1146 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
1147 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
1148 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.media_id);
1149 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.channel_id);
1150 p1_a9 := ddx_complete_rec.active_from_date;
1151 p1_a10 := ddx_complete_rec.active_to_date;
1152 end;
1153
1154 end ams_media_pvt_w;