[Home] [Help]
PACKAGE BODY: APPS.AMS_PS_POSTING_PVT_W
Source
1 package body ams_ps_posting_pvt_w as
2 /* $Header: amswpstb.pls 115.5 2002/12/19 04:17:09 ryedator ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p3(t out nocopy ams_ps_posting_pvt.ps_posting_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_DATE_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_DATE_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_VARCHAR2_TABLE_100
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_VARCHAR2_TABLE_300
35 , a13 JTF_VARCHAR2_TABLE_300
36 , a14 JTF_VARCHAR2_TABLE_4000
37 , a15 JTF_VARCHAR2_TABLE_200
38 , a16 JTF_VARCHAR2_TABLE_200
39 , a17 JTF_VARCHAR2_TABLE_200
40 , a18 JTF_VARCHAR2_TABLE_200
41 , a19 JTF_VARCHAR2_TABLE_200
42 , a20 JTF_VARCHAR2_TABLE_200
43 , a21 JTF_VARCHAR2_TABLE_200
44 , a22 JTF_VARCHAR2_TABLE_200
45 , a23 JTF_VARCHAR2_TABLE_200
46 , a24 JTF_VARCHAR2_TABLE_200
47 , a25 JTF_VARCHAR2_TABLE_200
48 , a26 JTF_VARCHAR2_TABLE_200
49 , a27 JTF_VARCHAR2_TABLE_200
50 , a28 JTF_VARCHAR2_TABLE_200
51 , a29 JTF_VARCHAR2_TABLE_100
52 , a30 JTF_VARCHAR2_TABLE_1000
53 ) as
54 ddindx binary_integer; indx binary_integer;
55 begin
56 if a0 is not null and a0.count > 0 then
57 if a0.count > 0 then
58 indx := a0.first;
59 ddindx := 1;
60 while true loop
61 t(ddindx).created_by := rosetta_g_miss_num_map(a0(indx));
62 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a1(indx));
63 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
64 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a3(indx));
65 t(ddindx).last_update_login := rosetta_g_miss_num_map(a4(indx));
66 t(ddindx).object_version_number := rosetta_g_miss_num_map(a5(indx));
67 t(ddindx).posting_id := rosetta_g_miss_num_map(a6(indx));
68 t(ddindx).max_no_contents := rosetta_g_miss_num_map(a7(indx));
69 t(ddindx).posting_type := a8(indx);
70 t(ddindx).content_type := a9(indx);
71 t(ddindx).default_content_id := rosetta_g_miss_num_map(a10(indx));
72 t(ddindx).status_code := a11(indx);
73 t(ddindx).posting_name := a12(indx);
74 t(ddindx).display_name := a13(indx);
75 t(ddindx).posting_description := a14(indx);
76 t(ddindx).attribute_category := a15(indx);
77 t(ddindx).attribute1 := a16(indx);
78 t(ddindx).attribute2 := a17(indx);
79 t(ddindx).attribute3 := a18(indx);
80 t(ddindx).attribute4 := a19(indx);
81 t(ddindx).attribute5 := a20(indx);
82 t(ddindx).attribute6 := a21(indx);
83 t(ddindx).attribute7 := a22(indx);
84 t(ddindx).attribute8 := a23(indx);
85 t(ddindx).attribute9 := a24(indx);
86 t(ddindx).attribute10 := a25(indx);
87 t(ddindx).attribute11 := a26(indx);
88 t(ddindx).attribute12 := a27(indx);
89 t(ddindx).attribute13 := a28(indx);
90 t(ddindx).attribute14 := a29(indx);
91 t(ddindx).attribute15 := a30(indx);
92 ddindx := ddindx+1;
93 if a0.last =indx
94 then exit;
95 end if;
96 indx := a0.next(indx);
97 end loop;
98 end if;
99 end if;
100 end rosetta_table_copy_in_p3;
101 procedure rosetta_table_copy_out_p3(t ams_ps_posting_pvt.ps_posting_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102 , a1 out nocopy JTF_DATE_TABLE
103 , a2 out nocopy JTF_NUMBER_TABLE
104 , a3 out nocopy JTF_DATE_TABLE
105 , a4 out nocopy JTF_NUMBER_TABLE
106 , a5 out nocopy JTF_NUMBER_TABLE
107 , a6 out nocopy JTF_NUMBER_TABLE
108 , a7 out nocopy JTF_NUMBER_TABLE
109 , a8 out nocopy JTF_VARCHAR2_TABLE_100
110 , a9 out nocopy JTF_VARCHAR2_TABLE_100
111 , a10 out nocopy JTF_NUMBER_TABLE
112 , a11 out nocopy JTF_VARCHAR2_TABLE_100
113 , a12 out nocopy JTF_VARCHAR2_TABLE_300
114 , a13 out nocopy JTF_VARCHAR2_TABLE_300
115 , a14 out nocopy JTF_VARCHAR2_TABLE_4000
116 , a15 out nocopy JTF_VARCHAR2_TABLE_200
117 , a16 out nocopy JTF_VARCHAR2_TABLE_200
118 , a17 out nocopy JTF_VARCHAR2_TABLE_200
119 , a18 out nocopy JTF_VARCHAR2_TABLE_200
120 , a19 out nocopy JTF_VARCHAR2_TABLE_200
121 , a20 out nocopy JTF_VARCHAR2_TABLE_200
122 , a21 out nocopy JTF_VARCHAR2_TABLE_200
123 , a22 out nocopy JTF_VARCHAR2_TABLE_200
124 , a23 out nocopy JTF_VARCHAR2_TABLE_200
125 , a24 out nocopy JTF_VARCHAR2_TABLE_200
126 , a25 out nocopy JTF_VARCHAR2_TABLE_200
127 , a26 out nocopy JTF_VARCHAR2_TABLE_200
128 , a27 out nocopy JTF_VARCHAR2_TABLE_200
129 , a28 out nocopy JTF_VARCHAR2_TABLE_200
130 , a29 out nocopy JTF_VARCHAR2_TABLE_100
131 , a30 out nocopy JTF_VARCHAR2_TABLE_1000
132 ) as
133 ddindx binary_integer; indx binary_integer;
134 begin
135 if t is null or t.count = 0 then
136 a0 := JTF_NUMBER_TABLE();
137 a1 := JTF_DATE_TABLE();
138 a2 := JTF_NUMBER_TABLE();
139 a3 := JTF_DATE_TABLE();
140 a4 := JTF_NUMBER_TABLE();
141 a5 := JTF_NUMBER_TABLE();
142 a6 := JTF_NUMBER_TABLE();
143 a7 := JTF_NUMBER_TABLE();
144 a8 := JTF_VARCHAR2_TABLE_100();
145 a9 := JTF_VARCHAR2_TABLE_100();
146 a10 := JTF_NUMBER_TABLE();
147 a11 := JTF_VARCHAR2_TABLE_100();
148 a12 := JTF_VARCHAR2_TABLE_300();
149 a13 := JTF_VARCHAR2_TABLE_300();
150 a14 := JTF_VARCHAR2_TABLE_4000();
151 a15 := JTF_VARCHAR2_TABLE_200();
152 a16 := JTF_VARCHAR2_TABLE_200();
153 a17 := JTF_VARCHAR2_TABLE_200();
154 a18 := JTF_VARCHAR2_TABLE_200();
155 a19 := JTF_VARCHAR2_TABLE_200();
156 a20 := JTF_VARCHAR2_TABLE_200();
157 a21 := JTF_VARCHAR2_TABLE_200();
158 a22 := JTF_VARCHAR2_TABLE_200();
159 a23 := JTF_VARCHAR2_TABLE_200();
160 a24 := JTF_VARCHAR2_TABLE_200();
161 a25 := JTF_VARCHAR2_TABLE_200();
162 a26 := JTF_VARCHAR2_TABLE_200();
163 a27 := JTF_VARCHAR2_TABLE_200();
164 a28 := JTF_VARCHAR2_TABLE_200();
165 a29 := JTF_VARCHAR2_TABLE_100();
166 a30 := JTF_VARCHAR2_TABLE_1000();
167 else
168 a0 := JTF_NUMBER_TABLE();
169 a1 := JTF_DATE_TABLE();
170 a2 := JTF_NUMBER_TABLE();
171 a3 := JTF_DATE_TABLE();
172 a4 := JTF_NUMBER_TABLE();
173 a5 := JTF_NUMBER_TABLE();
174 a6 := JTF_NUMBER_TABLE();
175 a7 := JTF_NUMBER_TABLE();
176 a8 := JTF_VARCHAR2_TABLE_100();
177 a9 := JTF_VARCHAR2_TABLE_100();
178 a10 := JTF_NUMBER_TABLE();
179 a11 := JTF_VARCHAR2_TABLE_100();
180 a12 := JTF_VARCHAR2_TABLE_300();
181 a13 := JTF_VARCHAR2_TABLE_300();
182 a14 := JTF_VARCHAR2_TABLE_4000();
183 a15 := JTF_VARCHAR2_TABLE_200();
184 a16 := JTF_VARCHAR2_TABLE_200();
185 a17 := JTF_VARCHAR2_TABLE_200();
186 a18 := JTF_VARCHAR2_TABLE_200();
187 a19 := JTF_VARCHAR2_TABLE_200();
188 a20 := JTF_VARCHAR2_TABLE_200();
189 a21 := JTF_VARCHAR2_TABLE_200();
190 a22 := JTF_VARCHAR2_TABLE_200();
191 a23 := JTF_VARCHAR2_TABLE_200();
192 a24 := JTF_VARCHAR2_TABLE_200();
193 a25 := JTF_VARCHAR2_TABLE_200();
194 a26 := JTF_VARCHAR2_TABLE_200();
195 a27 := JTF_VARCHAR2_TABLE_200();
196 a28 := JTF_VARCHAR2_TABLE_200();
197 a29 := JTF_VARCHAR2_TABLE_100();
198 a30 := JTF_VARCHAR2_TABLE_1000();
199 if t.count > 0 then
200 a0.extend(t.count);
201 a1.extend(t.count);
202 a2.extend(t.count);
203 a3.extend(t.count);
204 a4.extend(t.count);
205 a5.extend(t.count);
206 a6.extend(t.count);
207 a7.extend(t.count);
208 a8.extend(t.count);
209 a9.extend(t.count);
210 a10.extend(t.count);
211 a11.extend(t.count);
212 a12.extend(t.count);
213 a13.extend(t.count);
214 a14.extend(t.count);
215 a15.extend(t.count);
216 a16.extend(t.count);
217 a17.extend(t.count);
218 a18.extend(t.count);
219 a19.extend(t.count);
220 a20.extend(t.count);
221 a21.extend(t.count);
222 a22.extend(t.count);
223 a23.extend(t.count);
224 a24.extend(t.count);
225 a25.extend(t.count);
226 a26.extend(t.count);
227 a27.extend(t.count);
228 a28.extend(t.count);
229 a29.extend(t.count);
230 a30.extend(t.count);
231 ddindx := t.first;
232 indx := 1;
233 while true loop
234 a0(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
235 a1(indx) := t(ddindx).creation_date;
236 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
237 a3(indx) := t(ddindx).last_update_date;
238 a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
239 a5(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
240 a6(indx) := rosetta_g_miss_num_map(t(ddindx).posting_id);
241 a7(indx) := rosetta_g_miss_num_map(t(ddindx).max_no_contents);
242 a8(indx) := t(ddindx).posting_type;
243 a9(indx) := t(ddindx).content_type;
244 a10(indx) := rosetta_g_miss_num_map(t(ddindx).default_content_id);
245 a11(indx) := t(ddindx).status_code;
246 a12(indx) := t(ddindx).posting_name;
247 a13(indx) := t(ddindx).display_name;
248 a14(indx) := t(ddindx).posting_description;
249 a15(indx) := t(ddindx).attribute_category;
250 a16(indx) := t(ddindx).attribute1;
251 a17(indx) := t(ddindx).attribute2;
252 a18(indx) := t(ddindx).attribute3;
253 a19(indx) := t(ddindx).attribute4;
254 a20(indx) := t(ddindx).attribute5;
255 a21(indx) := t(ddindx).attribute6;
256 a22(indx) := t(ddindx).attribute7;
257 a23(indx) := t(ddindx).attribute8;
258 a24(indx) := t(ddindx).attribute9;
259 a25(indx) := t(ddindx).attribute10;
260 a26(indx) := t(ddindx).attribute11;
261 a27(indx) := t(ddindx).attribute12;
262 a28(indx) := t(ddindx).attribute13;
263 a29(indx) := t(ddindx).attribute14;
264 a30(indx) := t(ddindx).attribute15;
265 indx := indx+1;
266 if t.last =ddindx
267 then exit;
268 end if;
269 ddindx := t.next(ddindx);
270 end loop;
271 end if;
272 end if;
273 end rosetta_table_copy_out_p3;
274
275 procedure create_ps_posting(p_api_version_number NUMBER
276 , p_init_msg_list VARCHAR2
277 , p_commit VARCHAR2
278 , p_validation_level NUMBER
279 , x_return_status out nocopy VARCHAR2
280 , x_msg_count out nocopy NUMBER
281 , x_msg_data out nocopy VARCHAR2
282 , x_posting_id out nocopy NUMBER
283 , p7_a0 NUMBER := 0-1962.0724
284 , p7_a1 DATE := fnd_api.g_miss_date
285 , p7_a2 NUMBER := 0-1962.0724
286 , p7_a3 DATE := fnd_api.g_miss_date
287 , p7_a4 NUMBER := 0-1962.0724
288 , p7_a5 NUMBER := 0-1962.0724
289 , p7_a6 NUMBER := 0-1962.0724
290 , p7_a7 NUMBER := 0-1962.0724
291 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
292 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
293 , p7_a10 NUMBER := 0-1962.0724
294 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
295 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
296 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
297 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
298 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
299 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
300 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
301 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
302 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
303 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
304 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
305 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
306 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
307 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
308 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
309 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
310 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
311 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
312 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
313 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
314 )
315
316 as
317 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
318 ddindx binary_integer; indx binary_integer;
319 begin
320
321 -- copy data to the local IN or IN-OUT args, if any
322
323
324
325
326
327
328
329 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p7_a0);
330 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p7_a1);
331 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
332 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);
333 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);
334 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p7_a5);
335 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p7_a6);
336 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p7_a7);
337 ddp_ps_posting_rec.posting_type := p7_a8;
338 ddp_ps_posting_rec.content_type := p7_a9;
339 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p7_a10);
340 ddp_ps_posting_rec.status_code := p7_a11;
341 ddp_ps_posting_rec.posting_name := p7_a12;
342 ddp_ps_posting_rec.display_name := p7_a13;
343 ddp_ps_posting_rec.posting_description := p7_a14;
344 ddp_ps_posting_rec.attribute_category := p7_a15;
345 ddp_ps_posting_rec.attribute1 := p7_a16;
346 ddp_ps_posting_rec.attribute2 := p7_a17;
347 ddp_ps_posting_rec.attribute3 := p7_a18;
348 ddp_ps_posting_rec.attribute4 := p7_a19;
349 ddp_ps_posting_rec.attribute5 := p7_a20;
350 ddp_ps_posting_rec.attribute6 := p7_a21;
351 ddp_ps_posting_rec.attribute7 := p7_a22;
352 ddp_ps_posting_rec.attribute8 := p7_a23;
353 ddp_ps_posting_rec.attribute9 := p7_a24;
354 ddp_ps_posting_rec.attribute10 := p7_a25;
355 ddp_ps_posting_rec.attribute11 := p7_a26;
356 ddp_ps_posting_rec.attribute12 := p7_a27;
357 ddp_ps_posting_rec.attribute13 := p7_a28;
358 ddp_ps_posting_rec.attribute14 := p7_a29;
359 ddp_ps_posting_rec.attribute15 := p7_a30;
360
361
362 -- here's the delegated call to the old PL/SQL routine
363 ams_ps_posting_pvt.create_ps_posting(p_api_version_number,
364 p_init_msg_list,
365 p_commit,
366 p_validation_level,
367 x_return_status,
368 x_msg_count,
369 x_msg_data,
370 ddp_ps_posting_rec,
371 x_posting_id);
372
373 -- copy data back from the local variables to OUT or IN-OUT args, if any
374
375
376
377
378
379
380
381
382 end;
383
384 procedure update_ps_posting(p_api_version_number NUMBER
385 , p_init_msg_list VARCHAR2
386 , p_commit VARCHAR2
387 , p_validation_level NUMBER
388 , x_return_status out nocopy VARCHAR2
389 , x_msg_count out nocopy NUMBER
390 , x_msg_data out nocopy VARCHAR2
391 , x_object_version_number out nocopy NUMBER
392 , p7_a0 NUMBER := 0-1962.0724
393 , p7_a1 DATE := fnd_api.g_miss_date
394 , p7_a2 NUMBER := 0-1962.0724
395 , p7_a3 DATE := fnd_api.g_miss_date
396 , p7_a4 NUMBER := 0-1962.0724
397 , p7_a5 NUMBER := 0-1962.0724
398 , p7_a6 NUMBER := 0-1962.0724
399 , p7_a7 NUMBER := 0-1962.0724
400 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
401 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
402 , p7_a10 NUMBER := 0-1962.0724
406 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
403 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
404 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
409 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
413 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
414 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
415 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
416 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
417 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
418 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
419 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
420 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
421 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
422 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
423 )
424
425 as
426 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
427 ddindx binary_integer; indx binary_integer;
428 begin
429
430 -- copy data to the local IN or IN-OUT args, if any
431
432
433
434
435
436
437
438 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p7_a0);
439 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p7_a1);
440 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
441 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);
442 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p7_a4);
443 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p7_a5);
444 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p7_a6);
445 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p7_a7);
446 ddp_ps_posting_rec.posting_type := p7_a8;
447 ddp_ps_posting_rec.content_type := p7_a9;
448 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p7_a10);
449 ddp_ps_posting_rec.status_code := p7_a11;
450 ddp_ps_posting_rec.posting_name := p7_a12;
451 ddp_ps_posting_rec.display_name := p7_a13;
452 ddp_ps_posting_rec.posting_description := p7_a14;
453 ddp_ps_posting_rec.attribute_category := p7_a15;
454 ddp_ps_posting_rec.attribute1 := p7_a16;
455 ddp_ps_posting_rec.attribute2 := p7_a17;
456 ddp_ps_posting_rec.attribute3 := p7_a18;
457 ddp_ps_posting_rec.attribute4 := p7_a19;
458 ddp_ps_posting_rec.attribute5 := p7_a20;
459 ddp_ps_posting_rec.attribute6 := p7_a21;
460 ddp_ps_posting_rec.attribute7 := p7_a22;
461 ddp_ps_posting_rec.attribute8 := p7_a23;
462 ddp_ps_posting_rec.attribute9 := p7_a24;
463 ddp_ps_posting_rec.attribute10 := p7_a25;
464 ddp_ps_posting_rec.attribute11 := p7_a26;
465 ddp_ps_posting_rec.attribute12 := p7_a27;
466 ddp_ps_posting_rec.attribute13 := p7_a28;
467 ddp_ps_posting_rec.attribute14 := p7_a29;
468 ddp_ps_posting_rec.attribute15 := p7_a30;
469
470
471 -- here's the delegated call to the old PL/SQL routine
472 ams_ps_posting_pvt.update_ps_posting(p_api_version_number,
473 p_init_msg_list,
474 p_commit,
475 p_validation_level,
476 x_return_status,
477 x_msg_count,
478 x_msg_data,
479 ddp_ps_posting_rec,
480 x_object_version_number);
481
482 -- copy data back from the local variables to OUT or IN-OUT args, if any
483
484
485
486
487
488
489
490
491 end;
492
493 procedure validate_ps_posting(p_api_version_number NUMBER
494 , p_init_msg_list VARCHAR2
495 , p_validation_level NUMBER
496 , x_return_status out nocopy VARCHAR2
497 , x_msg_count out nocopy NUMBER
498 , x_msg_data out nocopy VARCHAR2
499 , p3_a0 NUMBER := 0-1962.0724
500 , p3_a1 DATE := fnd_api.g_miss_date
501 , p3_a2 NUMBER := 0-1962.0724
502 , p3_a3 DATE := fnd_api.g_miss_date
503 , p3_a4 NUMBER := 0-1962.0724
504 , p3_a5 NUMBER := 0-1962.0724
505 , p3_a6 NUMBER := 0-1962.0724
506 , p3_a7 NUMBER := 0-1962.0724
507 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
508 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
509 , p3_a10 NUMBER := 0-1962.0724
510 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
511 , p3_a12 VARCHAR2 := fnd_api.g_miss_char
512 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
513 , p3_a14 VARCHAR2 := fnd_api.g_miss_char
514 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
515 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
516 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
517 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
518 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
519 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
520 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
521 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
522 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
523 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
524 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
525 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
526 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
527 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
528 , p3_a29 VARCHAR2 := fnd_api.g_miss_char
529 , p3_a30 VARCHAR2 := fnd_api.g_miss_char
530 )
531
532 as
533 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
534 ddindx binary_integer; indx binary_integer;
535 begin
536
540
537 -- copy data to the local IN or IN-OUT args, if any
538
539
541 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p3_a0);
542 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p3_a1);
543 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p3_a2);
544 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a3);
545 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p3_a4);
546 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p3_a5);
547 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p3_a6);
548 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p3_a7);
549 ddp_ps_posting_rec.posting_type := p3_a8;
550 ddp_ps_posting_rec.content_type := p3_a9;
551 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p3_a10);
552 ddp_ps_posting_rec.status_code := p3_a11;
553 ddp_ps_posting_rec.posting_name := p3_a12;
554 ddp_ps_posting_rec.display_name := p3_a13;
555 ddp_ps_posting_rec.posting_description := p3_a14;
556 ddp_ps_posting_rec.attribute_category := p3_a15;
557 ddp_ps_posting_rec.attribute1 := p3_a16;
558 ddp_ps_posting_rec.attribute2 := p3_a17;
559 ddp_ps_posting_rec.attribute3 := p3_a18;
560 ddp_ps_posting_rec.attribute4 := p3_a19;
561 ddp_ps_posting_rec.attribute5 := p3_a20;
562 ddp_ps_posting_rec.attribute6 := p3_a21;
563 ddp_ps_posting_rec.attribute7 := p3_a22;
564 ddp_ps_posting_rec.attribute8 := p3_a23;
565 ddp_ps_posting_rec.attribute9 := p3_a24;
566 ddp_ps_posting_rec.attribute10 := p3_a25;
567 ddp_ps_posting_rec.attribute11 := p3_a26;
568 ddp_ps_posting_rec.attribute12 := p3_a27;
569 ddp_ps_posting_rec.attribute13 := p3_a28;
570 ddp_ps_posting_rec.attribute14 := p3_a29;
571 ddp_ps_posting_rec.attribute15 := p3_a30;
572
573
574
575
576 -- here's the delegated call to the old PL/SQL routine
577 ams_ps_posting_pvt.validate_ps_posting(p_api_version_number,
578 p_init_msg_list,
579 p_validation_level,
580 ddp_ps_posting_rec,
581 x_return_status,
582 x_msg_count,
583 x_msg_data);
584
585 -- copy data back from the local variables to OUT or IN-OUT args, if any
586
587
588
589
590
591
592 end;
593
594 procedure check_ps_posting_items(p_validation_mode VARCHAR2
595 , x_return_status out nocopy VARCHAR2
596 , p0_a0 NUMBER := 0-1962.0724
597 , p0_a1 DATE := fnd_api.g_miss_date
598 , p0_a2 NUMBER := 0-1962.0724
599 , p0_a3 DATE := fnd_api.g_miss_date
600 , p0_a4 NUMBER := 0-1962.0724
601 , p0_a5 NUMBER := 0-1962.0724
602 , p0_a6 NUMBER := 0-1962.0724
603 , p0_a7 NUMBER := 0-1962.0724
604 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
605 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
606 , p0_a10 NUMBER := 0-1962.0724
607 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
608 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
609 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
610 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
611 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
612 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
613 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
614 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
615 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
616 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
617 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
618 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
619 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
620 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
621 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
622 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
623 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
624 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
625 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
627 )
628
629 as
630 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
631 ddindx binary_integer; indx binary_integer;
632 begin
633
634 -- copy data to the local IN or IN-OUT args, if any
635 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p0_a0);
636 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p0_a1);
637 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
638 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a3);
639 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p0_a4);
640 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p0_a5);
641 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p0_a6);
642 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p0_a7);
643 ddp_ps_posting_rec.posting_type := p0_a8;
644 ddp_ps_posting_rec.content_type := p0_a9;
645 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p0_a10);
646 ddp_ps_posting_rec.status_code := p0_a11;
647 ddp_ps_posting_rec.posting_name := p0_a12;
648 ddp_ps_posting_rec.display_name := p0_a13;
649 ddp_ps_posting_rec.posting_description := p0_a14;
650 ddp_ps_posting_rec.attribute_category := p0_a15;
651 ddp_ps_posting_rec.attribute1 := p0_a16;
652 ddp_ps_posting_rec.attribute2 := p0_a17;
653 ddp_ps_posting_rec.attribute3 := p0_a18;
654 ddp_ps_posting_rec.attribute4 := p0_a19;
655 ddp_ps_posting_rec.attribute5 := p0_a20;
656 ddp_ps_posting_rec.attribute6 := p0_a21;
657 ddp_ps_posting_rec.attribute7 := p0_a22;
658 ddp_ps_posting_rec.attribute8 := p0_a23;
659 ddp_ps_posting_rec.attribute9 := p0_a24;
663 ddp_ps_posting_rec.attribute13 := p0_a28;
660 ddp_ps_posting_rec.attribute10 := p0_a25;
661 ddp_ps_posting_rec.attribute11 := p0_a26;
662 ddp_ps_posting_rec.attribute12 := p0_a27;
664 ddp_ps_posting_rec.attribute14 := p0_a29;
665 ddp_ps_posting_rec.attribute15 := p0_a30;
666
667
668
669 -- here's the delegated call to the old PL/SQL routine
670 ams_ps_posting_pvt.check_ps_posting_items(ddp_ps_posting_rec,
671 p_validation_mode,
672 x_return_status);
673
674 -- copy data back from the local variables to OUT or IN-OUT args, if any
675
676
677 end;
678
679 procedure check_ps_posting_req_items(p_validation_mode VARCHAR2
680 , x_return_status out nocopy VARCHAR2
681 , p1_a0 NUMBER := 0-1962.0724
682 , p1_a1 DATE := fnd_api.g_miss_date
683 , p1_a2 NUMBER := 0-1962.0724
684 , p1_a3 DATE := fnd_api.g_miss_date
685 , p1_a4 NUMBER := 0-1962.0724
686 , p1_a5 NUMBER := 0-1962.0724
687 , p1_a6 NUMBER := 0-1962.0724
688 , p1_a7 NUMBER := 0-1962.0724
689 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
690 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
691 , p1_a10 NUMBER := 0-1962.0724
692 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
693 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
694 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
695 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
696 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
697 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
698 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
699 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
700 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
701 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
702 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
703 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
704 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
705 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
706 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
707 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
708 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
709 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
710 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
711 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
712 )
713
714 as
715 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
716 ddindx binary_integer; indx binary_integer;
717 begin
718
719 -- copy data to the local IN or IN-OUT args, if any
720
721 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p1_a0);
722 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p1_a1);
723 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
724 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a3);
725 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p1_a4);
726 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p1_a5);
727 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p1_a6);
728 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p1_a7);
729 ddp_ps_posting_rec.posting_type := p1_a8;
730 ddp_ps_posting_rec.content_type := p1_a9;
731 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p1_a10);
732 ddp_ps_posting_rec.status_code := p1_a11;
733 ddp_ps_posting_rec.posting_name := p1_a12;
734 ddp_ps_posting_rec.display_name := p1_a13;
735 ddp_ps_posting_rec.posting_description := p1_a14;
736 ddp_ps_posting_rec.attribute_category := p1_a15;
737 ddp_ps_posting_rec.attribute1 := p1_a16;
738 ddp_ps_posting_rec.attribute2 := p1_a17;
739 ddp_ps_posting_rec.attribute3 := p1_a18;
740 ddp_ps_posting_rec.attribute4 := p1_a19;
741 ddp_ps_posting_rec.attribute5 := p1_a20;
742 ddp_ps_posting_rec.attribute6 := p1_a21;
743 ddp_ps_posting_rec.attribute7 := p1_a22;
744 ddp_ps_posting_rec.attribute8 := p1_a23;
745 ddp_ps_posting_rec.attribute9 := p1_a24;
746 ddp_ps_posting_rec.attribute10 := p1_a25;
747 ddp_ps_posting_rec.attribute11 := p1_a26;
748 ddp_ps_posting_rec.attribute12 := p1_a27;
749 ddp_ps_posting_rec.attribute13 := p1_a28;
750 ddp_ps_posting_rec.attribute14 := p1_a29;
751 ddp_ps_posting_rec.attribute15 := p1_a30;
752
753
754 -- here's the delegated call to the old PL/SQL routine
755 ams_ps_posting_pvt.check_ps_posting_req_items(p_validation_mode,
756 ddp_ps_posting_rec,
757 x_return_status);
758
759 -- copy data back from the local variables to OUT or IN-OUT args, if any
760
761
762 end;
763
764 procedure check_ps_posting_fk_items(x_return_status out nocopy VARCHAR2
765 , p0_a0 NUMBER := 0-1962.0724
766 , p0_a1 DATE := fnd_api.g_miss_date
767 , p0_a2 NUMBER := 0-1962.0724
768 , p0_a3 DATE := fnd_api.g_miss_date
769 , p0_a4 NUMBER := 0-1962.0724
770 , p0_a5 NUMBER := 0-1962.0724
771 , p0_a6 NUMBER := 0-1962.0724
772 , p0_a7 NUMBER := 0-1962.0724
773 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
774 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
775 , p0_a10 NUMBER := 0-1962.0724
776 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
777 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
778 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
779 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
780 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
781 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
782 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
783 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
784 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
788 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
785 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
786 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
787 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
789 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
790 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
791 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
792 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
793 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
794 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
795 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
796 )
797
798 as
799 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
800 ddindx binary_integer; indx binary_integer;
801 begin
802
803 -- copy data to the local IN or IN-OUT args, if any
804 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p0_a0);
805 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p0_a1);
806 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
807 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a3);
808 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p0_a4);
809 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p0_a5);
810 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p0_a6);
811 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p0_a7);
812 ddp_ps_posting_rec.posting_type := p0_a8;
813 ddp_ps_posting_rec.content_type := p0_a9;
814 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p0_a10);
815 ddp_ps_posting_rec.status_code := p0_a11;
816 ddp_ps_posting_rec.posting_name := p0_a12;
817 ddp_ps_posting_rec.display_name := p0_a13;
818 ddp_ps_posting_rec.posting_description := p0_a14;
819 ddp_ps_posting_rec.attribute_category := p0_a15;
820 ddp_ps_posting_rec.attribute1 := p0_a16;
821 ddp_ps_posting_rec.attribute2 := p0_a17;
822 ddp_ps_posting_rec.attribute3 := p0_a18;
823 ddp_ps_posting_rec.attribute4 := p0_a19;
824 ddp_ps_posting_rec.attribute5 := p0_a20;
825 ddp_ps_posting_rec.attribute6 := p0_a21;
826 ddp_ps_posting_rec.attribute7 := p0_a22;
827 ddp_ps_posting_rec.attribute8 := p0_a23;
828 ddp_ps_posting_rec.attribute9 := p0_a24;
829 ddp_ps_posting_rec.attribute10 := p0_a25;
830 ddp_ps_posting_rec.attribute11 := p0_a26;
831 ddp_ps_posting_rec.attribute12 := p0_a27;
832 ddp_ps_posting_rec.attribute13 := p0_a28;
833 ddp_ps_posting_rec.attribute14 := p0_a29;
834 ddp_ps_posting_rec.attribute15 := p0_a30;
835
836
837 -- here's the delegated call to the old PL/SQL routine
838 ams_ps_posting_pvt.check_ps_posting_fk_items(ddp_ps_posting_rec,
839 x_return_status);
840
841 -- copy data back from the local variables to OUT or IN-OUT args, if any
842
843 end;
844
845 procedure validate_ps_posting_rec(p_api_version_number NUMBER
846 , p_init_msg_list VARCHAR2
847 , x_return_status out nocopy VARCHAR2
848 , x_msg_count out nocopy NUMBER
849 , x_msg_data out nocopy VARCHAR2
850 , p5_a0 NUMBER := 0-1962.0724
851 , p5_a1 DATE := fnd_api.g_miss_date
852 , p5_a2 NUMBER := 0-1962.0724
853 , p5_a3 DATE := fnd_api.g_miss_date
854 , p5_a4 NUMBER := 0-1962.0724
855 , p5_a5 NUMBER := 0-1962.0724
856 , p5_a6 NUMBER := 0-1962.0724
857 , p5_a7 NUMBER := 0-1962.0724
858 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
859 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
860 , p5_a10 NUMBER := 0-1962.0724
861 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
862 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
863 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
864 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
865 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
866 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
867 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
868 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
869 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
870 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
871 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
872 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
873 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
874 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
876 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
881 )
882
883 as
884 ddp_ps_posting_rec ams_ps_posting_pvt.ps_posting_rec_type;
885 ddindx binary_integer; indx binary_integer;
886 begin
887
888 -- copy data to the local IN or IN-OUT args, if any
889
890
891
892
893
894 ddp_ps_posting_rec.created_by := rosetta_g_miss_num_map(p5_a0);
895 ddp_ps_posting_rec.creation_date := rosetta_g_miss_date_in_map(p5_a1);
896 ddp_ps_posting_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);
897 ddp_ps_posting_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a3);
898 ddp_ps_posting_rec.last_update_login := rosetta_g_miss_num_map(p5_a4);
899 ddp_ps_posting_rec.object_version_number := rosetta_g_miss_num_map(p5_a5);
900 ddp_ps_posting_rec.posting_id := rosetta_g_miss_num_map(p5_a6);
901 ddp_ps_posting_rec.max_no_contents := rosetta_g_miss_num_map(p5_a7);
902 ddp_ps_posting_rec.posting_type := p5_a8;
903 ddp_ps_posting_rec.content_type := p5_a9;
907 ddp_ps_posting_rec.display_name := p5_a13;
904 ddp_ps_posting_rec.default_content_id := rosetta_g_miss_num_map(p5_a10);
905 ddp_ps_posting_rec.status_code := p5_a11;
906 ddp_ps_posting_rec.posting_name := p5_a12;
908 ddp_ps_posting_rec.posting_description := p5_a14;
909 ddp_ps_posting_rec.attribute_category := p5_a15;
910 ddp_ps_posting_rec.attribute1 := p5_a16;
911 ddp_ps_posting_rec.attribute2 := p5_a17;
912 ddp_ps_posting_rec.attribute3 := p5_a18;
913 ddp_ps_posting_rec.attribute4 := p5_a19;
914 ddp_ps_posting_rec.attribute5 := p5_a20;
915 ddp_ps_posting_rec.attribute6 := p5_a21;
916 ddp_ps_posting_rec.attribute7 := p5_a22;
917 ddp_ps_posting_rec.attribute8 := p5_a23;
918 ddp_ps_posting_rec.attribute9 := p5_a24;
919 ddp_ps_posting_rec.attribute10 := p5_a25;
920 ddp_ps_posting_rec.attribute11 := p5_a26;
921 ddp_ps_posting_rec.attribute12 := p5_a27;
922 ddp_ps_posting_rec.attribute13 := p5_a28;
923 ddp_ps_posting_rec.attribute14 := p5_a29;
924 ddp_ps_posting_rec.attribute15 := p5_a30;
925
926 -- here's the delegated call to the old PL/SQL routine
927 ams_ps_posting_pvt.validate_ps_posting_rec(p_api_version_number,
928 p_init_msg_list,
929 x_return_status,
930 x_msg_count,
931 x_msg_data,
932 ddp_ps_posting_rec);
933
934 -- copy data back from the local variables to OUT or IN-OUT args, if any
935
936
937
938
939
940 end;
941
942 end ams_ps_posting_pvt_w;