[Home] [Help]
PACKAGE BODY: APPS.AMS_MESSAGES_PVT_W
Source
1 package body ams_messages_pvt_w as
2 /* $Header: amswmsgb.pls 115.8 2002/11/15 21:03:57 abhola 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_msg(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_msg_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 DATE := fnd_api.g_miss_date
38 , p7_a8 DATE := fnd_api.g_miss_date
39 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 NUMBER := 0-1962.0724
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a14 NUMBER := 0-1962.0724
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 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 )
62 as
63 ddp_msg_rec ams_messages_pvt.msg_rec_type;
64 ddindx binary_integer; indx binary_integer;
65 begin
66
67 -- copy data to the local IN or IN-OUT args, if any
68
69
70
71
72
73
74
75 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p7_a0);
76 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
77 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
78 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
79 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p7_a4);
80 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
81 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
82 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p7_a7);
83 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p7_a8);
84 ddp_msg_rec.active_flag := p7_a9;
85 ddp_msg_rec.message_type_code := p7_a10;
86 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p7_a11);
87 ddp_msg_rec.message_name := p7_a12;
88 ddp_msg_rec.description := p7_a13;
89 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p7_a14);
90 ddp_msg_rec.attribute_category := p7_a15;
91 ddp_msg_rec.attribute1 := p7_a16;
92 ddp_msg_rec.attribute2 := p7_a17;
93 ddp_msg_rec.attribute3 := p7_a18;
94 ddp_msg_rec.attribute4 := p7_a19;
95 ddp_msg_rec.attribute5 := p7_a20;
96 ddp_msg_rec.attribute6 := p7_a21;
97 ddp_msg_rec.attribute7 := p7_a22;
98 ddp_msg_rec.attribute8 := p7_a23;
99 ddp_msg_rec.attribute9 := p7_a24;
100 ddp_msg_rec.attribute10 := p7_a25;
101 ddp_msg_rec.attribute11 := p7_a26;
102 ddp_msg_rec.attribute12 := p7_a27;
103 ddp_msg_rec.attribute13 := p7_a28;
104 ddp_msg_rec.attribute14 := p7_a29;
105 ddp_msg_rec.attribute15 := p7_a30;
106
107
108 -- here's the delegated call to the old PL/SQL routine
109 ams_messages_pvt.create_msg(p_api_version,
110 p_init_msg_list,
111 p_commit,
112 p_validation_level,
113 x_return_status,
114 x_msg_count,
115 x_msg_data,
116 ddp_msg_rec,
117 x_msg_id);
118
119 -- copy data back from the local OUT or IN-OUT args, if any
120
121
122
123
124
125
126
127
128 end;
129
130 procedure update_msg(p_api_version NUMBER
131 , p_init_msg_list VARCHAR2
132 , p_commit VARCHAR2
133 , p_validation_level NUMBER
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_count OUT NOCOPY NUMBER
136 , x_msg_data OUT NOCOPY VARCHAR2
137 , p7_a0 NUMBER := 0-1962.0724
138 , p7_a1 DATE := fnd_api.g_miss_date
139 , p7_a2 NUMBER := 0-1962.0724
140 , p7_a3 DATE := fnd_api.g_miss_date
141 , p7_a4 NUMBER := 0-1962.0724
142 , p7_a5 NUMBER := 0-1962.0724
143 , p7_a6 NUMBER := 0-1962.0724
144 , p7_a7 DATE := fnd_api.g_miss_date
145 , p7_a8 DATE := fnd_api.g_miss_date
146 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a11 NUMBER := 0-1962.0724
149 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a14 NUMBER := 0-1962.0724
152 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168 )
169 as
170 ddp_msg_rec ams_messages_pvt.msg_rec_type;
171 ddindx binary_integer; indx binary_integer;
172 begin
173
174 -- copy data to the local IN or IN-OUT args, if any
175
176
177
178
179
180
181
182 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p7_a0);
183 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
184 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
185 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
186 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p7_a4);
187 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
188 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
189 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p7_a7);
190 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p7_a8);
191 ddp_msg_rec.active_flag := p7_a9;
192 ddp_msg_rec.message_type_code := p7_a10;
193 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p7_a11);
194 ddp_msg_rec.message_name := p7_a12;
195 ddp_msg_rec.description := p7_a13;
196 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p7_a14);
197 ddp_msg_rec.attribute_category := p7_a15;
198 ddp_msg_rec.attribute1 := p7_a16;
199 ddp_msg_rec.attribute2 := p7_a17;
200 ddp_msg_rec.attribute3 := p7_a18;
201 ddp_msg_rec.attribute4 := p7_a19;
202 ddp_msg_rec.attribute5 := p7_a20;
203 ddp_msg_rec.attribute6 := p7_a21;
204 ddp_msg_rec.attribute7 := p7_a22;
205 ddp_msg_rec.attribute8 := p7_a23;
206 ddp_msg_rec.attribute9 := p7_a24;
207 ddp_msg_rec.attribute10 := p7_a25;
208 ddp_msg_rec.attribute11 := p7_a26;
209 ddp_msg_rec.attribute12 := p7_a27;
210 ddp_msg_rec.attribute13 := p7_a28;
211 ddp_msg_rec.attribute14 := p7_a29;
212 ddp_msg_rec.attribute15 := p7_a30;
213
214 -- here's the delegated call to the old PL/SQL routine
215 ams_messages_pvt.update_msg(p_api_version,
216 p_init_msg_list,
217 p_commit,
218 p_validation_level,
219 x_return_status,
220 x_msg_count,
221 x_msg_data,
222 ddp_msg_rec);
223
224 -- copy data back from the local OUT or IN-OUT args, if any
225
226
227
228
229
230
231
232 end;
233
234 procedure validate_msg(p_api_version NUMBER
235 , p_init_msg_list VARCHAR2
236 , p_validation_level NUMBER
237 , x_return_status OUT NOCOPY VARCHAR2
238 , x_msg_count OUT NOCOPY NUMBER
239 , x_msg_data OUT NOCOPY VARCHAR2
240 , p6_a0 NUMBER := 0-1962.0724
241 , p6_a1 DATE := fnd_api.g_miss_date
242 , p6_a2 NUMBER := 0-1962.0724
243 , p6_a3 DATE := fnd_api.g_miss_date
244 , p6_a4 NUMBER := 0-1962.0724
245 , p6_a5 NUMBER := 0-1962.0724
246 , p6_a6 NUMBER := 0-1962.0724
247 , p6_a7 DATE := fnd_api.g_miss_date
248 , p6_a8 DATE := fnd_api.g_miss_date
249 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251 , p6_a11 NUMBER := 0-1962.0724
252 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254 , p6_a14 NUMBER := 0-1962.0724
255 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
271 )
272 as
273 ddp_msg_rec ams_messages_pvt.msg_rec_type;
274 ddindx binary_integer; indx binary_integer;
275 begin
276
277 -- copy data to the local IN or IN-OUT args, if any
278
279
280
281
282
283
284 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p6_a0);
285 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
286 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
287 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
288 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p6_a4);
289 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
290 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
291 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p6_a7);
292 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p6_a8);
293 ddp_msg_rec.active_flag := p6_a9;
294 ddp_msg_rec.message_type_code := p6_a10;
295 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p6_a11);
296 ddp_msg_rec.message_name := p6_a12;
297 ddp_msg_rec.description := p6_a13;
298 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p6_a14);
299 ddp_msg_rec.attribute_category := p6_a15;
300 ddp_msg_rec.attribute1 := p6_a16;
301 ddp_msg_rec.attribute2 := p6_a17;
302 ddp_msg_rec.attribute3 := p6_a18;
303 ddp_msg_rec.attribute4 := p6_a19;
304 ddp_msg_rec.attribute5 := p6_a20;
305 ddp_msg_rec.attribute6 := p6_a21;
306 ddp_msg_rec.attribute7 := p6_a22;
307 ddp_msg_rec.attribute8 := p6_a23;
308 ddp_msg_rec.attribute9 := p6_a24;
309 ddp_msg_rec.attribute10 := p6_a25;
310 ddp_msg_rec.attribute11 := p6_a26;
311 ddp_msg_rec.attribute12 := p6_a27;
312 ddp_msg_rec.attribute13 := p6_a28;
313 ddp_msg_rec.attribute14 := p6_a29;
314 ddp_msg_rec.attribute15 := p6_a30;
315
316 -- here's the delegated call to the old PL/SQL routine
317 ams_messages_pvt.validate_msg(p_api_version,
318 p_init_msg_list,
319 p_validation_level,
320 x_return_status,
321 x_msg_count,
322 x_msg_data,
323 ddp_msg_rec);
324
325 -- copy data back from the local OUT or IN-OUT args, if any
326
327
328
329
330
331
332 end;
333
334 procedure check_items(p_validation_mode VARCHAR2
335 , x_return_status OUT NOCOPY VARCHAR2
336 , p2_a0 NUMBER := 0-1962.0724
337 , p2_a1 DATE := fnd_api.g_miss_date
338 , p2_a2 NUMBER := 0-1962.0724
339 , p2_a3 DATE := fnd_api.g_miss_date
340 , p2_a4 NUMBER := 0-1962.0724
341 , p2_a5 NUMBER := 0-1962.0724
342 , p2_a6 NUMBER := 0-1962.0724
343 , p2_a7 DATE := fnd_api.g_miss_date
344 , p2_a8 DATE := fnd_api.g_miss_date
345 , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346 , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347 , p2_a11 NUMBER := 0-1962.0724
348 , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349 , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350 , p2_a14 NUMBER := 0-1962.0724
351 , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352 , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353 , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354 , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355 , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356 , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357 , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358 , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359 , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360 , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361 , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362 , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363 , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364 , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365 , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366 , p2_a30 VARCHAR2 := fnd_api.g_miss_char
367 )
368 as
369 ddp_msg_rec ams_messages_pvt.msg_rec_type;
370 ddindx binary_integer; indx binary_integer;
371 begin
372
373 -- copy data to the local IN or IN-OUT args, if any
374
375
376 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p2_a0);
377 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p2_a1);
378 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p2_a2);
379 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p2_a3);
380 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p2_a4);
381 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p2_a5);
382 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p2_a6);
383 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p2_a7);
384 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p2_a8);
385 ddp_msg_rec.active_flag := p2_a9;
386 ddp_msg_rec.message_type_code := p2_a10;
387 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p2_a11);
388 ddp_msg_rec.message_name := p2_a12;
389 ddp_msg_rec.description := p2_a13;
390 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p2_a14);
391 ddp_msg_rec.attribute_category := p2_a15;
392 ddp_msg_rec.attribute1 := p2_a16;
393 ddp_msg_rec.attribute2 := p2_a17;
394 ddp_msg_rec.attribute3 := p2_a18;
395 ddp_msg_rec.attribute4 := p2_a19;
396 ddp_msg_rec.attribute5 := p2_a20;
397 ddp_msg_rec.attribute6 := p2_a21;
398 ddp_msg_rec.attribute7 := p2_a22;
399 ddp_msg_rec.attribute8 := p2_a23;
400 ddp_msg_rec.attribute9 := p2_a24;
401 ddp_msg_rec.attribute10 := p2_a25;
402 ddp_msg_rec.attribute11 := p2_a26;
403 ddp_msg_rec.attribute12 := p2_a27;
404 ddp_msg_rec.attribute13 := p2_a28;
405 ddp_msg_rec.attribute14 := p2_a29;
406 ddp_msg_rec.attribute15 := p2_a30;
407
408 -- here's the delegated call to the old PL/SQL routine
409 ams_messages_pvt.check_items(p_validation_mode,
410 x_return_status,
411 ddp_msg_rec);
412
413 -- copy data back from the local OUT or IN-OUT args, if any
414
415
416 end;
417
418 procedure check_req_items(p_validation_mode VARCHAR2
419 , x_return_status OUT NOCOPY VARCHAR2
420 , p1_a0 NUMBER := 0-1962.0724
421 , p1_a1 DATE := fnd_api.g_miss_date
422 , p1_a2 NUMBER := 0-1962.0724
423 , p1_a3 DATE := fnd_api.g_miss_date
424 , p1_a4 NUMBER := 0-1962.0724
425 , p1_a5 NUMBER := 0-1962.0724
426 , p1_a6 NUMBER := 0-1962.0724
427 , p1_a7 DATE := fnd_api.g_miss_date
428 , p1_a8 DATE := fnd_api.g_miss_date
429 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431 , p1_a11 NUMBER := 0-1962.0724
432 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434 , p1_a14 NUMBER := 0-1962.0724
435 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
451 )
452 as
453 ddp_msg_rec ams_messages_pvt.msg_rec_type;
454 ddindx binary_integer; indx binary_integer;
455 begin
456
457 -- copy data to the local IN or IN-OUT args, if any
458
459 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p1_a0);
460 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
461 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
462 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
463 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p1_a4);
464 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
465 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
466 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p1_a7);
467 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p1_a8);
468 ddp_msg_rec.active_flag := p1_a9;
469 ddp_msg_rec.message_type_code := p1_a10;
470 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p1_a11);
471 ddp_msg_rec.message_name := p1_a12;
472 ddp_msg_rec.description := p1_a13;
473 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p1_a14);
474 ddp_msg_rec.attribute_category := p1_a15;
475 ddp_msg_rec.attribute1 := p1_a16;
476 ddp_msg_rec.attribute2 := p1_a17;
477 ddp_msg_rec.attribute3 := p1_a18;
478 ddp_msg_rec.attribute4 := p1_a19;
479 ddp_msg_rec.attribute5 := p1_a20;
480 ddp_msg_rec.attribute6 := p1_a21;
481 ddp_msg_rec.attribute7 := p1_a22;
482 ddp_msg_rec.attribute8 := p1_a23;
483 ddp_msg_rec.attribute9 := p1_a24;
484 ddp_msg_rec.attribute10 := p1_a25;
485 ddp_msg_rec.attribute11 := p1_a26;
486 ddp_msg_rec.attribute12 := p1_a27;
487 ddp_msg_rec.attribute13 := p1_a28;
488 ddp_msg_rec.attribute14 := p1_a29;
489 ddp_msg_rec.attribute15 := p1_a30;
490
491
492 -- here's the delegated call to the old PL/SQL routine
493 ams_messages_pvt.check_req_items(p_validation_mode,
494 ddp_msg_rec,
495 x_return_status);
496
497 -- copy data back from the local OUT or IN-OUT args, if any
498
499
500 end;
501
502 procedure check_uk_items(p_validation_mode VARCHAR2
503 , x_return_status OUT NOCOPY VARCHAR2
504 , p1_a0 NUMBER := 0-1962.0724
505 , p1_a1 DATE := fnd_api.g_miss_date
506 , p1_a2 NUMBER := 0-1962.0724
507 , p1_a3 DATE := fnd_api.g_miss_date
508 , p1_a4 NUMBER := 0-1962.0724
509 , p1_a5 NUMBER := 0-1962.0724
510 , p1_a6 NUMBER := 0-1962.0724
511 , p1_a7 DATE := fnd_api.g_miss_date
512 , p1_a8 DATE := fnd_api.g_miss_date
513 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515 , p1_a11 NUMBER := 0-1962.0724
516 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518 , p1_a14 NUMBER := 0-1962.0724
519 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
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 )
536 as
537 ddp_msg_rec ams_messages_pvt.msg_rec_type;
538 ddindx binary_integer; indx binary_integer;
539 begin
540
541 -- copy data to the local IN or IN-OUT args, if any
542
543 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p1_a0);
544 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
545 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
546 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
547 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p1_a4);
548 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
549 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
550 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p1_a7);
551 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p1_a8);
552 ddp_msg_rec.active_flag := p1_a9;
553 ddp_msg_rec.message_type_code := p1_a10;
554 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p1_a11);
555 ddp_msg_rec.message_name := p1_a12;
556 ddp_msg_rec.description := p1_a13;
557 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p1_a14);
558 ddp_msg_rec.attribute_category := p1_a15;
559 ddp_msg_rec.attribute1 := p1_a16;
560 ddp_msg_rec.attribute2 := p1_a17;
561 ddp_msg_rec.attribute3 := p1_a18;
562 ddp_msg_rec.attribute4 := p1_a19;
563 ddp_msg_rec.attribute5 := p1_a20;
564 ddp_msg_rec.attribute6 := p1_a21;
565 ddp_msg_rec.attribute7 := p1_a22;
566 ddp_msg_rec.attribute8 := p1_a23;
567 ddp_msg_rec.attribute9 := p1_a24;
568 ddp_msg_rec.attribute10 := p1_a25;
569 ddp_msg_rec.attribute11 := p1_a26;
570 ddp_msg_rec.attribute12 := p1_a27;
571 ddp_msg_rec.attribute13 := p1_a28;
572 ddp_msg_rec.attribute14 := p1_a29;
573 ddp_msg_rec.attribute15 := p1_a30;
574
575
576 -- here's the delegated call to the old PL/SQL routine
577 ams_messages_pvt.check_uk_items(p_validation_mode,
578 ddp_msg_rec,
579 x_return_status);
580
581 -- copy data back from the local OUT or IN-OUT args, if any
582
583
584 end;
585
586 procedure check_record(x_return_status OUT NOCOPY VARCHAR2
587 , p0_a0 NUMBER := 0-1962.0724
588 , p0_a1 DATE := fnd_api.g_miss_date
589 , p0_a2 NUMBER := 0-1962.0724
590 , p0_a3 DATE := fnd_api.g_miss_date
591 , p0_a4 NUMBER := 0-1962.0724
592 , p0_a5 NUMBER := 0-1962.0724
593 , p0_a6 NUMBER := 0-1962.0724
594 , p0_a7 DATE := fnd_api.g_miss_date
595 , p0_a8 DATE := fnd_api.g_miss_date
596 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598 , p0_a11 NUMBER := 0-1962.0724
599 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601 , p0_a14 NUMBER := 0-1962.0724
602 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618 , p1_a0 NUMBER := 0-1962.0724
619 , p1_a1 DATE := fnd_api.g_miss_date
620 , p1_a2 NUMBER := 0-1962.0724
621 , p1_a3 DATE := fnd_api.g_miss_date
622 , p1_a4 NUMBER := 0-1962.0724
623 , p1_a5 NUMBER := 0-1962.0724
624 , p1_a6 NUMBER := 0-1962.0724
625 , p1_a7 DATE := fnd_api.g_miss_date
626 , p1_a8 DATE := fnd_api.g_miss_date
627 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629 , p1_a11 NUMBER := 0-1962.0724
630 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632 , p1_a14 NUMBER := 0-1962.0724
633 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
649 )
650 as
651 ddp_msg_rec ams_messages_pvt.msg_rec_type;
652 ddp_complete_rec ams_messages_pvt.msg_rec_type;
653 ddindx binary_integer; indx binary_integer;
654 begin
655
656 -- copy data to the local IN or IN-OUT args, if any
657 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p0_a0);
658 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
659 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
660 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
661 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p0_a4);
662 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
663 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
664 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p0_a7);
665 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p0_a8);
666 ddp_msg_rec.active_flag := p0_a9;
667 ddp_msg_rec.message_type_code := p0_a10;
668 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p0_a11);
669 ddp_msg_rec.message_name := p0_a12;
670 ddp_msg_rec.description := p0_a13;
671 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p0_a14);
672 ddp_msg_rec.attribute_category := p0_a15;
673 ddp_msg_rec.attribute1 := p0_a16;
674 ddp_msg_rec.attribute2 := p0_a17;
675 ddp_msg_rec.attribute3 := p0_a18;
676 ddp_msg_rec.attribute4 := p0_a19;
677 ddp_msg_rec.attribute5 := p0_a20;
678 ddp_msg_rec.attribute6 := p0_a21;
679 ddp_msg_rec.attribute7 := p0_a22;
680 ddp_msg_rec.attribute8 := p0_a23;
681 ddp_msg_rec.attribute9 := p0_a24;
682 ddp_msg_rec.attribute10 := p0_a25;
683 ddp_msg_rec.attribute11 := p0_a26;
684 ddp_msg_rec.attribute12 := p0_a27;
685 ddp_msg_rec.attribute13 := p0_a28;
686 ddp_msg_rec.attribute14 := p0_a29;
687 ddp_msg_rec.attribute15 := p0_a30;
688
689 ddp_complete_rec.message_id := rosetta_g_miss_num_map(p1_a0);
690 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
691 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
692 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
693 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
694 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
695 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
696 ddp_complete_rec.date_effective_from := rosetta_g_miss_date_in_map(p1_a7);
697 ddp_complete_rec.date_effective_to := rosetta_g_miss_date_in_map(p1_a8);
698 ddp_complete_rec.active_flag := p1_a9;
699 ddp_complete_rec.message_type_code := p1_a10;
700 ddp_complete_rec.owner_user_id := rosetta_g_miss_num_map(p1_a11);
701 ddp_complete_rec.message_name := p1_a12;
702 ddp_complete_rec.description := p1_a13;
703 ddp_complete_rec.country_id := rosetta_g_miss_num_map(p1_a14);
704 ddp_complete_rec.attribute_category := p1_a15;
705 ddp_complete_rec.attribute1 := p1_a16;
706 ddp_complete_rec.attribute2 := p1_a17;
707 ddp_complete_rec.attribute3 := p1_a18;
708 ddp_complete_rec.attribute4 := p1_a19;
709 ddp_complete_rec.attribute5 := p1_a20;
710 ddp_complete_rec.attribute6 := p1_a21;
711 ddp_complete_rec.attribute7 := p1_a22;
712 ddp_complete_rec.attribute8 := p1_a23;
713 ddp_complete_rec.attribute9 := p1_a24;
714 ddp_complete_rec.attribute10 := p1_a25;
715 ddp_complete_rec.attribute11 := p1_a26;
716 ddp_complete_rec.attribute12 := p1_a27;
717 ddp_complete_rec.attribute13 := p1_a28;
718 ddp_complete_rec.attribute14 := p1_a29;
719 ddp_complete_rec.attribute15 := p1_a30;
720
721
722 -- here's the delegated call to the old PL/SQL routine
723 ams_messages_pvt.check_record(ddp_msg_rec,
724 ddp_complete_rec,
725 x_return_status);
726
727 -- copy data back from the local OUT or IN-OUT args, if any
728
729
730 end;
731
732 procedure complete_msg_rec(p1_a0 OUT NOCOPY NUMBER
733 , p1_a1 OUT NOCOPY DATE
734 , p1_a2 OUT NOCOPY NUMBER
735 , p1_a3 OUT NOCOPY DATE
736 , p1_a4 OUT NOCOPY NUMBER
737 , p1_a5 OUT NOCOPY NUMBER
738 , p1_a6 OUT NOCOPY NUMBER
739 , p1_a7 OUT NOCOPY DATE
740 , p1_a8 OUT NOCOPY DATE
741 , p1_a9 OUT NOCOPY VARCHAR2
742 , p1_a10 OUT NOCOPY VARCHAR2
743 , p1_a11 OUT NOCOPY NUMBER
744 , p1_a12 OUT NOCOPY VARCHAR2
745 , p1_a13 OUT NOCOPY VARCHAR2
746 , p1_a14 OUT NOCOPY NUMBER
747 , p1_a15 OUT NOCOPY VARCHAR2
748 , p1_a16 OUT NOCOPY VARCHAR2
749 , p1_a17 OUT NOCOPY VARCHAR2
750 , p1_a18 OUT NOCOPY VARCHAR2
751 , p1_a19 OUT NOCOPY VARCHAR2
752 , p1_a20 OUT NOCOPY VARCHAR2
753 , p1_a21 OUT NOCOPY VARCHAR2
754 , p1_a22 OUT NOCOPY VARCHAR2
755 , p1_a23 OUT NOCOPY VARCHAR2
756 , p1_a24 OUT NOCOPY VARCHAR2
757 , p1_a25 OUT NOCOPY VARCHAR2
758 , p1_a26 OUT NOCOPY VARCHAR2
759 , p1_a27 OUT NOCOPY VARCHAR2
760 , p1_a28 OUT NOCOPY VARCHAR2
761 , p1_a29 OUT NOCOPY VARCHAR2
762 , p1_a30 OUT NOCOPY VARCHAR2
763 , p0_a0 NUMBER := 0-1962.0724
764 , p0_a1 DATE := fnd_api.g_miss_date
765 , p0_a2 NUMBER := 0-1962.0724
766 , p0_a3 DATE := fnd_api.g_miss_date
767 , p0_a4 NUMBER := 0-1962.0724
768 , p0_a5 NUMBER := 0-1962.0724
769 , p0_a6 NUMBER := 0-1962.0724
770 , p0_a7 DATE := fnd_api.g_miss_date
771 , p0_a8 DATE := fnd_api.g_miss_date
772 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774 , p0_a11 NUMBER := 0-1962.0724
775 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777 , p0_a14 NUMBER := 0-1962.0724
778 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
794 )
795 as
796 ddp_msg_rec ams_messages_pvt.msg_rec_type;
797 ddx_complete_rec ams_messages_pvt.msg_rec_type;
798 ddindx binary_integer; indx binary_integer;
799 begin
800
801 -- copy data to the local IN or IN-OUT args, if any
802 ddp_msg_rec.message_id := rosetta_g_miss_num_map(p0_a0);
803 ddp_msg_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
804 ddp_msg_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
805 ddp_msg_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
806 ddp_msg_rec.created_by := rosetta_g_miss_num_map(p0_a4);
807 ddp_msg_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
808 ddp_msg_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
809 ddp_msg_rec.date_effective_from := rosetta_g_miss_date_in_map(p0_a7);
810 ddp_msg_rec.date_effective_to := rosetta_g_miss_date_in_map(p0_a8);
811 ddp_msg_rec.active_flag := p0_a9;
812 ddp_msg_rec.message_type_code := p0_a10;
813 ddp_msg_rec.owner_user_id := rosetta_g_miss_num_map(p0_a11);
814 ddp_msg_rec.message_name := p0_a12;
815 ddp_msg_rec.description := p0_a13;
816 ddp_msg_rec.country_id := rosetta_g_miss_num_map(p0_a14);
817 ddp_msg_rec.attribute_category := p0_a15;
818 ddp_msg_rec.attribute1 := p0_a16;
819 ddp_msg_rec.attribute2 := p0_a17;
820 ddp_msg_rec.attribute3 := p0_a18;
821 ddp_msg_rec.attribute4 := p0_a19;
822 ddp_msg_rec.attribute5 := p0_a20;
823 ddp_msg_rec.attribute6 := p0_a21;
824 ddp_msg_rec.attribute7 := p0_a22;
825 ddp_msg_rec.attribute8 := p0_a23;
826 ddp_msg_rec.attribute9 := p0_a24;
827 ddp_msg_rec.attribute10 := p0_a25;
828 ddp_msg_rec.attribute11 := p0_a26;
829 ddp_msg_rec.attribute12 := p0_a27;
830 ddp_msg_rec.attribute13 := p0_a28;
831 ddp_msg_rec.attribute14 := p0_a29;
832 ddp_msg_rec.attribute15 := p0_a30;
833
834
835 -- here's the delegated call to the old PL/SQL routine
836 ams_messages_pvt.complete_msg_rec(ddp_msg_rec,
837 ddx_complete_rec);
838
839 -- copy data back from the local OUT or IN-OUT args, if any
840
841 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.message_id);
842 p1_a1 := ddx_complete_rec.last_update_date;
843 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
844 p1_a3 := ddx_complete_rec.creation_date;
845 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
846 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
847 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
848 p1_a7 := ddx_complete_rec.date_effective_from;
849 p1_a8 := ddx_complete_rec.date_effective_to;
850 p1_a9 := ddx_complete_rec.active_flag;
851 p1_a10 := ddx_complete_rec.message_type_code;
852 p1_a11 := rosetta_g_miss_num_map(ddx_complete_rec.owner_user_id);
853 p1_a12 := ddx_complete_rec.message_name;
854 p1_a13 := ddx_complete_rec.description;
855 p1_a14 := rosetta_g_miss_num_map(ddx_complete_rec.country_id);
856 p1_a15 := ddx_complete_rec.attribute_category;
857 p1_a16 := ddx_complete_rec.attribute1;
858 p1_a17 := ddx_complete_rec.attribute2;
859 p1_a18 := ddx_complete_rec.attribute3;
860 p1_a19 := ddx_complete_rec.attribute4;
861 p1_a20 := ddx_complete_rec.attribute5;
862 p1_a21 := ddx_complete_rec.attribute6;
863 p1_a22 := ddx_complete_rec.attribute7;
864 p1_a23 := ddx_complete_rec.attribute8;
865 p1_a24 := ddx_complete_rec.attribute9;
866 p1_a25 := ddx_complete_rec.attribute10;
867 p1_a26 := ddx_complete_rec.attribute11;
868 p1_a27 := ddx_complete_rec.attribute12;
869 p1_a28 := ddx_complete_rec.attribute13;
870 p1_a29 := ddx_complete_rec.attribute14;
871 p1_a30 := ddx_complete_rec.attribute15;
872 end;
873
874 procedure init_rec(p0_a0 OUT NOCOPY NUMBER
875 , p0_a1 OUT NOCOPY DATE
876 , p0_a2 OUT NOCOPY NUMBER
877 , p0_a3 OUT NOCOPY DATE
878 , p0_a4 OUT NOCOPY NUMBER
879 , p0_a5 OUT NOCOPY NUMBER
880 , p0_a6 OUT NOCOPY NUMBER
881 , p0_a7 OUT NOCOPY DATE
882 , p0_a8 OUT NOCOPY DATE
883 , p0_a9 OUT NOCOPY VARCHAR2
884 , p0_a10 OUT NOCOPY VARCHAR2
885 , p0_a11 OUT NOCOPY NUMBER
886 , p0_a12 OUT NOCOPY VARCHAR2
887 , p0_a13 OUT NOCOPY VARCHAR2
888 , p0_a14 OUT NOCOPY NUMBER
889 , p0_a15 OUT NOCOPY VARCHAR2
890 , p0_a16 OUT NOCOPY VARCHAR2
891 , p0_a17 OUT NOCOPY VARCHAR2
892 , p0_a18 OUT NOCOPY VARCHAR2
893 , p0_a19 OUT NOCOPY VARCHAR2
894 , p0_a20 OUT NOCOPY VARCHAR2
895 , p0_a21 OUT NOCOPY VARCHAR2
896 , p0_a22 OUT NOCOPY VARCHAR2
897 , p0_a23 OUT NOCOPY VARCHAR2
898 , p0_a24 OUT NOCOPY VARCHAR2
899 , p0_a25 OUT NOCOPY VARCHAR2
900 , p0_a26 OUT NOCOPY VARCHAR2
901 , p0_a27 OUT NOCOPY VARCHAR2
902 , p0_a28 OUT NOCOPY VARCHAR2
903 , p0_a29 OUT NOCOPY VARCHAR2
904 , p0_a30 OUT NOCOPY VARCHAR2
905 )
906 as
907 ddx_msg_rec ams_messages_pvt.msg_rec_type;
908 ddindx binary_integer; indx binary_integer;
909 begin
910
911 -- copy data to the local IN or IN-OUT args, if any
912
913 -- here's the delegated call to the old PL/SQL routine
914 ams_messages_pvt.init_rec(ddx_msg_rec);
915
916 -- copy data back from the local OUT or IN-OUT args, if any
917 p0_a0 := rosetta_g_miss_num_map(ddx_msg_rec.message_id);
918 p0_a1 := ddx_msg_rec.last_update_date;
919 p0_a2 := rosetta_g_miss_num_map(ddx_msg_rec.last_updated_by);
920 p0_a3 := ddx_msg_rec.creation_date;
921 p0_a4 := rosetta_g_miss_num_map(ddx_msg_rec.created_by);
922 p0_a5 := rosetta_g_miss_num_map(ddx_msg_rec.last_update_login);
923 p0_a6 := rosetta_g_miss_num_map(ddx_msg_rec.object_version_number);
924 p0_a7 := ddx_msg_rec.date_effective_from;
925 p0_a8 := ddx_msg_rec.date_effective_to;
926 p0_a9 := ddx_msg_rec.active_flag;
927 p0_a10 := ddx_msg_rec.message_type_code;
928 p0_a11 := rosetta_g_miss_num_map(ddx_msg_rec.owner_user_id);
929 p0_a12 := ddx_msg_rec.message_name;
930 p0_a13 := ddx_msg_rec.description;
931 p0_a14 := rosetta_g_miss_num_map(ddx_msg_rec.country_id);
932 p0_a15 := ddx_msg_rec.attribute_category;
933 p0_a16 := ddx_msg_rec.attribute1;
934 p0_a17 := ddx_msg_rec.attribute2;
935 p0_a18 := ddx_msg_rec.attribute3;
936 p0_a19 := ddx_msg_rec.attribute4;
937 p0_a20 := ddx_msg_rec.attribute5;
938 p0_a21 := ddx_msg_rec.attribute6;
939 p0_a22 := ddx_msg_rec.attribute7;
940 p0_a23 := ddx_msg_rec.attribute8;
941 p0_a24 := ddx_msg_rec.attribute9;
942 p0_a25 := ddx_msg_rec.attribute10;
943 p0_a26 := ddx_msg_rec.attribute11;
944 p0_a27 := ddx_msg_rec.attribute12;
945 p0_a28 := ddx_msg_rec.attribute13;
946 p0_a29 := ddx_msg_rec.attribute14;
947 p0_a30 := ddx_msg_rec.attribute15;
948 end;
949
950 end ams_messages_pvt_w;