[Home] [Help]
PACKAGE BODY: APPS.AMS_CAT_ACTIVITY_PVT_W
Source
1 package body ams_cat_activity_pvt_w as
2 /* $Header: amswcacb.pls 120.1 2005/11/23 05:22 vmodur noship $ */
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_cat_activity_pvt.cat_activity_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_DATE_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_DATE_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_VARCHAR2_TABLE_200
33 , a11 JTF_VARCHAR2_TABLE_200
34 , a12 JTF_VARCHAR2_TABLE_200
35 , a13 JTF_VARCHAR2_TABLE_200
36 , a14 JTF_VARCHAR2_TABLE_200
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 ) as
48 ddindx binary_integer; indx binary_integer;
49 begin
50 if a0 is not null and a0.count > 0 then
51 if a0.count > 0 then
52 indx := a0.first;
53 ddindx := 1;
54 while true loop
55 t(ddindx).cat_activity_id := rosetta_g_miss_num_map(a0(indx));
56 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
57 t(ddindx).category_id := rosetta_g_miss_num_map(a2(indx));
58 t(ddindx).activity_id := rosetta_g_miss_num_map(a3(indx));
59 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a4(indx));
60 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a5(indx));
61 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a6(indx));
62 t(ddindx).created_by := rosetta_g_miss_num_map(a7(indx));
63 t(ddindx).last_update_login := rosetta_g_miss_num_map(a8(indx));
64 t(ddindx).attribute_category := a9(indx);
65 t(ddindx).attribute1 := a10(indx);
66 t(ddindx).attribute2 := a11(indx);
67 t(ddindx).attribute3 := a12(indx);
68 t(ddindx).attribute4 := a13(indx);
69 t(ddindx).attribute5 := a14(indx);
70 t(ddindx).attribute6 := a15(indx);
71 t(ddindx).attribute7 := a16(indx);
72 t(ddindx).attribute8 := a17(indx);
73 t(ddindx).attribute9 := a18(indx);
74 t(ddindx).attribute10 := a19(indx);
75 t(ddindx).attribute11 := a20(indx);
76 t(ddindx).attribute12 := a21(indx);
77 t(ddindx).attribute13 := a22(indx);
78 t(ddindx).attribute14 := a23(indx);
79 t(ddindx).attribute15 := a24(indx);
80 ddindx := ddindx+1;
81 if a0.last =indx
82 then exit;
83 end if;
84 indx := a0.next(indx);
85 end loop;
86 end if;
87 end if;
88 end rosetta_table_copy_in_p3;
89 procedure rosetta_table_copy_out_p3(t ams_cat_activity_pvt.cat_activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90 , a1 out nocopy JTF_NUMBER_TABLE
91 , a2 out nocopy JTF_NUMBER_TABLE
92 , a3 out nocopy JTF_NUMBER_TABLE
93 , a4 out nocopy JTF_DATE_TABLE
94 , a5 out nocopy JTF_NUMBER_TABLE
95 , a6 out nocopy JTF_DATE_TABLE
96 , a7 out nocopy JTF_NUMBER_TABLE
97 , a8 out nocopy JTF_NUMBER_TABLE
98 , a9 out nocopy JTF_VARCHAR2_TABLE_100
99 , a10 out nocopy JTF_VARCHAR2_TABLE_200
100 , a11 out nocopy JTF_VARCHAR2_TABLE_200
101 , a12 out nocopy JTF_VARCHAR2_TABLE_200
102 , a13 out nocopy JTF_VARCHAR2_TABLE_200
103 , a14 out nocopy JTF_VARCHAR2_TABLE_200
104 , a15 out nocopy JTF_VARCHAR2_TABLE_200
105 , a16 out nocopy JTF_VARCHAR2_TABLE_200
106 , a17 out nocopy JTF_VARCHAR2_TABLE_200
107 , a18 out nocopy JTF_VARCHAR2_TABLE_200
108 , a19 out nocopy JTF_VARCHAR2_TABLE_200
109 , a20 out nocopy JTF_VARCHAR2_TABLE_200
110 , a21 out nocopy JTF_VARCHAR2_TABLE_200
111 , a22 out nocopy JTF_VARCHAR2_TABLE_200
112 , a23 out nocopy JTF_VARCHAR2_TABLE_200
113 , a24 out nocopy JTF_VARCHAR2_TABLE_200
114 ) as
115 ddindx binary_integer; indx binary_integer;
116 begin
117 if t is null or t.count = 0 then
118 a0 := JTF_NUMBER_TABLE();
119 a1 := JTF_NUMBER_TABLE();
120 a2 := JTF_NUMBER_TABLE();
121 a3 := JTF_NUMBER_TABLE();
122 a4 := JTF_DATE_TABLE();
123 a5 := JTF_NUMBER_TABLE();
124 a6 := JTF_DATE_TABLE();
125 a7 := JTF_NUMBER_TABLE();
126 a8 := JTF_NUMBER_TABLE();
127 a9 := JTF_VARCHAR2_TABLE_100();
128 a10 := JTF_VARCHAR2_TABLE_200();
129 a11 := JTF_VARCHAR2_TABLE_200();
130 a12 := JTF_VARCHAR2_TABLE_200();
131 a13 := JTF_VARCHAR2_TABLE_200();
132 a14 := JTF_VARCHAR2_TABLE_200();
133 a15 := JTF_VARCHAR2_TABLE_200();
134 a16 := JTF_VARCHAR2_TABLE_200();
135 a17 := JTF_VARCHAR2_TABLE_200();
136 a18 := JTF_VARCHAR2_TABLE_200();
137 a19 := JTF_VARCHAR2_TABLE_200();
138 a20 := JTF_VARCHAR2_TABLE_200();
139 a21 := JTF_VARCHAR2_TABLE_200();
140 a22 := JTF_VARCHAR2_TABLE_200();
141 a23 := JTF_VARCHAR2_TABLE_200();
142 a24 := JTF_VARCHAR2_TABLE_200();
143 else
144 a0 := JTF_NUMBER_TABLE();
145 a1 := JTF_NUMBER_TABLE();
146 a2 := JTF_NUMBER_TABLE();
147 a3 := JTF_NUMBER_TABLE();
148 a4 := JTF_DATE_TABLE();
149 a5 := JTF_NUMBER_TABLE();
150 a6 := JTF_DATE_TABLE();
151 a7 := JTF_NUMBER_TABLE();
152 a8 := JTF_NUMBER_TABLE();
153 a9 := JTF_VARCHAR2_TABLE_100();
154 a10 := JTF_VARCHAR2_TABLE_200();
155 a11 := JTF_VARCHAR2_TABLE_200();
156 a12 := JTF_VARCHAR2_TABLE_200();
157 a13 := JTF_VARCHAR2_TABLE_200();
158 a14 := JTF_VARCHAR2_TABLE_200();
159 a15 := JTF_VARCHAR2_TABLE_200();
160 a16 := JTF_VARCHAR2_TABLE_200();
161 a17 := JTF_VARCHAR2_TABLE_200();
162 a18 := JTF_VARCHAR2_TABLE_200();
163 a19 := JTF_VARCHAR2_TABLE_200();
164 a20 := JTF_VARCHAR2_TABLE_200();
165 a21 := JTF_VARCHAR2_TABLE_200();
166 a22 := JTF_VARCHAR2_TABLE_200();
167 a23 := JTF_VARCHAR2_TABLE_200();
168 a24 := JTF_VARCHAR2_TABLE_200();
169 if t.count > 0 then
170 a0.extend(t.count);
171 a1.extend(t.count);
172 a2.extend(t.count);
173 a3.extend(t.count);
174 a4.extend(t.count);
175 a5.extend(t.count);
176 a6.extend(t.count);
177 a7.extend(t.count);
178 a8.extend(t.count);
179 a9.extend(t.count);
180 a10.extend(t.count);
181 a11.extend(t.count);
182 a12.extend(t.count);
183 a13.extend(t.count);
184 a14.extend(t.count);
185 a15.extend(t.count);
186 a16.extend(t.count);
187 a17.extend(t.count);
188 a18.extend(t.count);
189 a19.extend(t.count);
190 a20.extend(t.count);
191 a21.extend(t.count);
192 a22.extend(t.count);
193 a23.extend(t.count);
194 a24.extend(t.count);
195 ddindx := t.first;
196 indx := 1;
197 while true loop
198 a0(indx) := rosetta_g_miss_num_map(t(ddindx).cat_activity_id);
199 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
200 a2(indx) := rosetta_g_miss_num_map(t(ddindx).category_id);
201 a3(indx) := rosetta_g_miss_num_map(t(ddindx).activity_id);
202 a4(indx) := t(ddindx).last_update_date;
203 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
204 a6(indx) := t(ddindx).creation_date;
205 a7(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
206 a8(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
207 a9(indx) := t(ddindx).attribute_category;
208 a10(indx) := t(ddindx).attribute1;
209 a11(indx) := t(ddindx).attribute2;
210 a12(indx) := t(ddindx).attribute3;
211 a13(indx) := t(ddindx).attribute4;
212 a14(indx) := t(ddindx).attribute5;
213 a15(indx) := t(ddindx).attribute6;
214 a16(indx) := t(ddindx).attribute7;
215 a17(indx) := t(ddindx).attribute8;
216 a18(indx) := t(ddindx).attribute9;
217 a19(indx) := t(ddindx).attribute10;
218 a20(indx) := t(ddindx).attribute11;
219 a21(indx) := t(ddindx).attribute12;
220 a22(indx) := t(ddindx).attribute13;
221 a23(indx) := t(ddindx).attribute14;
222 a24(indx) := t(ddindx).attribute15;
223 indx := indx+1;
224 if t.last =ddindx
225 then exit;
226 end if;
227 ddindx := t.next(ddindx);
228 end loop;
229 end if;
230 end if;
231 end rosetta_table_copy_out_p3;
232
233 procedure create_cat_activity(p_api_version_number NUMBER
234 , p_init_msg_list VARCHAR2
235 , p_commit 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 , x_cat_activity_id out nocopy NUMBER
241 , p7_a0 NUMBER := 0-1962.0724
242 , p7_a1 NUMBER := 0-1962.0724
243 , p7_a2 NUMBER := 0-1962.0724
244 , p7_a3 NUMBER := 0-1962.0724
245 , p7_a4 DATE := fnd_api.g_miss_date
246 , p7_a5 NUMBER := 0-1962.0724
247 , p7_a6 DATE := fnd_api.g_miss_date
248 , p7_a7 NUMBER := 0-1962.0724
249 , p7_a8 NUMBER := 0-1962.0724
250 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
266 )
267
268 as
269 ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;
270 ddindx binary_integer; indx binary_integer;
271 begin
272
273 -- copy data to the local IN or IN-OUT args, if any
274
275
276
277
278
279
280
281 ddp_cat_activity_rec.cat_activity_id := rosetta_g_miss_num_map(p7_a0);
282 ddp_cat_activity_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
283 ddp_cat_activity_rec.category_id := rosetta_g_miss_num_map(p7_a2);
284 ddp_cat_activity_rec.activity_id := rosetta_g_miss_num_map(p7_a3);
285 ddp_cat_activity_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);
286 ddp_cat_activity_rec.last_updated_by := rosetta_g_miss_num_map(p7_a5);
287 ddp_cat_activity_rec.creation_date := rosetta_g_miss_date_in_map(p7_a6);
288 ddp_cat_activity_rec.created_by := rosetta_g_miss_num_map(p7_a7);
289 ddp_cat_activity_rec.last_update_login := rosetta_g_miss_num_map(p7_a8);
290 ddp_cat_activity_rec.attribute_category := p7_a9;
291 ddp_cat_activity_rec.attribute1 := p7_a10;
292 ddp_cat_activity_rec.attribute2 := p7_a11;
293 ddp_cat_activity_rec.attribute3 := p7_a12;
294 ddp_cat_activity_rec.attribute4 := p7_a13;
295 ddp_cat_activity_rec.attribute5 := p7_a14;
296 ddp_cat_activity_rec.attribute6 := p7_a15;
297 ddp_cat_activity_rec.attribute7 := p7_a16;
298 ddp_cat_activity_rec.attribute8 := p7_a17;
299 ddp_cat_activity_rec.attribute9 := p7_a18;
300 ddp_cat_activity_rec.attribute10 := p7_a19;
301 ddp_cat_activity_rec.attribute11 := p7_a20;
302 ddp_cat_activity_rec.attribute12 := p7_a21;
303 ddp_cat_activity_rec.attribute13 := p7_a22;
304 ddp_cat_activity_rec.attribute14 := p7_a23;
305 ddp_cat_activity_rec.attribute15 := p7_a24;
306
307
308 -- here's the delegated call to the old PL/SQL routine
309 ams_cat_activity_pvt.create_cat_activity(p_api_version_number,
310 p_init_msg_list,
311 p_commit,
312 p_validation_level,
313 x_return_status,
314 x_msg_count,
315 x_msg_data,
316 ddp_cat_activity_rec,
317 x_cat_activity_id);
318
319 -- copy data back from the local variables to OUT or IN-OUT args, if any
320
321
322
323
324
325
326
327
328 end;
329
330 procedure update_cat_activity(p_api_version_number NUMBER
331 , p_init_msg_list VARCHAR2
332 , p_commit VARCHAR2
333 , p_validation_level NUMBER
334 , x_return_status out nocopy VARCHAR2
335 , x_msg_count out nocopy NUMBER
336 , x_msg_data out nocopy VARCHAR2
340 , p7_a2 NUMBER := 0-1962.0724
337 , x_object_version_number out nocopy NUMBER
338 , p7_a0 NUMBER := 0-1962.0724
339 , p7_a1 NUMBER := 0-1962.0724
341 , p7_a3 NUMBER := 0-1962.0724
342 , p7_a4 DATE := fnd_api.g_miss_date
343 , p7_a5 NUMBER := 0-1962.0724
344 , p7_a6 DATE := fnd_api.g_miss_date
345 , p7_a7 NUMBER := 0-1962.0724
346 , p7_a8 NUMBER := 0-1962.0724
347 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
363 )
364
365 as
366 ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;
367 ddindx binary_integer; indx binary_integer;
368 begin
369
370 -- copy data to the local IN or IN-OUT args, if any
371
372
373
374
375
376
377
378 ddp_cat_activity_rec.cat_activity_id := rosetta_g_miss_num_map(p7_a0);
379 ddp_cat_activity_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
380 ddp_cat_activity_rec.category_id := rosetta_g_miss_num_map(p7_a2);
381 ddp_cat_activity_rec.activity_id := rosetta_g_miss_num_map(p7_a3);
382 ddp_cat_activity_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a4);
383 ddp_cat_activity_rec.last_updated_by := rosetta_g_miss_num_map(p7_a5);
384 ddp_cat_activity_rec.creation_date := rosetta_g_miss_date_in_map(p7_a6);
385 ddp_cat_activity_rec.created_by := rosetta_g_miss_num_map(p7_a7);
386 ddp_cat_activity_rec.last_update_login := rosetta_g_miss_num_map(p7_a8);
387 ddp_cat_activity_rec.attribute_category := p7_a9;
388 ddp_cat_activity_rec.attribute1 := p7_a10;
389 ddp_cat_activity_rec.attribute2 := p7_a11;
390 ddp_cat_activity_rec.attribute3 := p7_a12;
391 ddp_cat_activity_rec.attribute4 := p7_a13;
392 ddp_cat_activity_rec.attribute5 := p7_a14;
393 ddp_cat_activity_rec.attribute6 := p7_a15;
394 ddp_cat_activity_rec.attribute7 := p7_a16;
395 ddp_cat_activity_rec.attribute8 := p7_a17;
396 ddp_cat_activity_rec.attribute9 := p7_a18;
397 ddp_cat_activity_rec.attribute10 := p7_a19;
398 ddp_cat_activity_rec.attribute11 := p7_a20;
399 ddp_cat_activity_rec.attribute12 := p7_a21;
400 ddp_cat_activity_rec.attribute13 := p7_a22;
401 ddp_cat_activity_rec.attribute14 := p7_a23;
402 ddp_cat_activity_rec.attribute15 := p7_a24;
403
404
405 -- here's the delegated call to the old PL/SQL routine
406 ams_cat_activity_pvt.update_cat_activity(p_api_version_number,
407 p_init_msg_list,
408 p_commit,
409 p_validation_level,
410 x_return_status,
411 x_msg_count,
412 x_msg_data,
413 ddp_cat_activity_rec,
414 x_object_version_number);
415
416 -- copy data back from the local variables to OUT or IN-OUT args, if any
417
418
419
420
421
422
423
424
425 end;
426
427 procedure validate_cat_activity(p_api_version_number NUMBER
428 , p_init_msg_list VARCHAR2
429 , p_validation_level NUMBER
430 , x_return_status out nocopy VARCHAR2
431 , x_msg_count out nocopy NUMBER
432 , x_msg_data out nocopy VARCHAR2
433 , p3_a0 NUMBER := 0-1962.0724
434 , p3_a1 NUMBER := 0-1962.0724
435 , p3_a2 NUMBER := 0-1962.0724
436 , p3_a3 NUMBER := 0-1962.0724
437 , p3_a4 DATE := fnd_api.g_miss_date
438 , p3_a5 NUMBER := 0-1962.0724
439 , p3_a6 DATE := fnd_api.g_miss_date
440 , p3_a7 NUMBER := 0-1962.0724
441 , p3_a8 NUMBER := 0-1962.0724
442 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443 , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445 , p3_a12 VARCHAR2 := fnd_api.g_miss_char
449 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
446 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447 , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
450 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
458 )
459
460 as
461 ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;
462 ddindx binary_integer; indx binary_integer;
463 begin
464
465 -- copy data to the local IN or IN-OUT args, if any
466
467
468
469 ddp_cat_activity_rec.cat_activity_id := rosetta_g_miss_num_map(p3_a0);
470 ddp_cat_activity_rec.object_version_number := rosetta_g_miss_num_map(p3_a1);
471 ddp_cat_activity_rec.category_id := rosetta_g_miss_num_map(p3_a2);
472 ddp_cat_activity_rec.activity_id := rosetta_g_miss_num_map(p3_a3);
473 ddp_cat_activity_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a4);
474 ddp_cat_activity_rec.last_updated_by := rosetta_g_miss_num_map(p3_a5);
475 ddp_cat_activity_rec.creation_date := rosetta_g_miss_date_in_map(p3_a6);
476 ddp_cat_activity_rec.created_by := rosetta_g_miss_num_map(p3_a7);
477 ddp_cat_activity_rec.last_update_login := rosetta_g_miss_num_map(p3_a8);
478 ddp_cat_activity_rec.attribute_category := p3_a9;
479 ddp_cat_activity_rec.attribute1 := p3_a10;
480 ddp_cat_activity_rec.attribute2 := p3_a11;
481 ddp_cat_activity_rec.attribute3 := p3_a12;
482 ddp_cat_activity_rec.attribute4 := p3_a13;
483 ddp_cat_activity_rec.attribute5 := p3_a14;
484 ddp_cat_activity_rec.attribute6 := p3_a15;
485 ddp_cat_activity_rec.attribute7 := p3_a16;
486 ddp_cat_activity_rec.attribute8 := p3_a17;
487 ddp_cat_activity_rec.attribute9 := p3_a18;
488 ddp_cat_activity_rec.attribute10 := p3_a19;
489 ddp_cat_activity_rec.attribute11 := p3_a20;
490 ddp_cat_activity_rec.attribute12 := p3_a21;
491 ddp_cat_activity_rec.attribute13 := p3_a22;
492 ddp_cat_activity_rec.attribute14 := p3_a23;
493 ddp_cat_activity_rec.attribute15 := p3_a24;
494
495
496
497
498 -- here's the delegated call to the old PL/SQL routine
499 ams_cat_activity_pvt.validate_cat_activity(p_api_version_number,
500 p_init_msg_list,
501 p_validation_level,
502 ddp_cat_activity_rec,
503 x_return_status,
504 x_msg_count,
505 x_msg_data);
506
507 -- copy data back from the local variables to OUT or IN-OUT args, if any
508
509
510
511
512
513
514 end;
515
516 procedure check_cat_activity_items(p_validation_mode VARCHAR2
517 , x_return_status out nocopy VARCHAR2
518 , p0_a0 NUMBER := 0-1962.0724
519 , p0_a1 NUMBER := 0-1962.0724
520 , p0_a2 NUMBER := 0-1962.0724
521 , p0_a3 NUMBER := 0-1962.0724
522 , p0_a4 DATE := fnd_api.g_miss_date
523 , p0_a5 NUMBER := 0-1962.0724
524 , p0_a6 DATE := fnd_api.g_miss_date
525 , p0_a7 NUMBER := 0-1962.0724
526 , p0_a8 NUMBER := 0-1962.0724
527 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
543 )
544
545 as
549
546 ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;
547 ddindx binary_integer; indx binary_integer;
548 begin
550 -- copy data to the local IN or IN-OUT args, if any
551 ddp_cat_activity_rec.cat_activity_id := rosetta_g_miss_num_map(p0_a0);
552 ddp_cat_activity_rec.object_version_number := rosetta_g_miss_num_map(p0_a1);
553 ddp_cat_activity_rec.category_id := rosetta_g_miss_num_map(p0_a2);
554 ddp_cat_activity_rec.activity_id := rosetta_g_miss_num_map(p0_a3);
555 ddp_cat_activity_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a4);
556 ddp_cat_activity_rec.last_updated_by := rosetta_g_miss_num_map(p0_a5);
557 ddp_cat_activity_rec.creation_date := rosetta_g_miss_date_in_map(p0_a6);
558 ddp_cat_activity_rec.created_by := rosetta_g_miss_num_map(p0_a7);
559 ddp_cat_activity_rec.last_update_login := rosetta_g_miss_num_map(p0_a8);
560 ddp_cat_activity_rec.attribute_category := p0_a9;
561 ddp_cat_activity_rec.attribute1 := p0_a10;
562 ddp_cat_activity_rec.attribute2 := p0_a11;
563 ddp_cat_activity_rec.attribute3 := p0_a12;
564 ddp_cat_activity_rec.attribute4 := p0_a13;
565 ddp_cat_activity_rec.attribute5 := p0_a14;
566 ddp_cat_activity_rec.attribute6 := p0_a15;
567 ddp_cat_activity_rec.attribute7 := p0_a16;
568 ddp_cat_activity_rec.attribute8 := p0_a17;
569 ddp_cat_activity_rec.attribute9 := p0_a18;
570 ddp_cat_activity_rec.attribute10 := p0_a19;
571 ddp_cat_activity_rec.attribute11 := p0_a20;
572 ddp_cat_activity_rec.attribute12 := p0_a21;
573 ddp_cat_activity_rec.attribute13 := p0_a22;
574 ddp_cat_activity_rec.attribute14 := p0_a23;
575 ddp_cat_activity_rec.attribute15 := p0_a24;
576
577
578
579 -- here's the delegated call to the old PL/SQL routine
580 ams_cat_activity_pvt.check_cat_activity_items(ddp_cat_activity_rec,
581 p_validation_mode,
582 x_return_status);
583
584 -- copy data back from the local variables to OUT or IN-OUT args, if any
585
586
587 end;
588
589 procedure validate_cat_activity_rec(p_api_version_number NUMBER
590 , p_init_msg_list VARCHAR2
591 , x_return_status out nocopy VARCHAR2
592 , x_msg_count out nocopy NUMBER
593 , x_msg_data out nocopy VARCHAR2
594 , p5_a0 NUMBER := 0-1962.0724
595 , p5_a1 NUMBER := 0-1962.0724
596 , p5_a2 NUMBER := 0-1962.0724
597 , p5_a3 NUMBER := 0-1962.0724
598 , p5_a4 DATE := fnd_api.g_miss_date
599 , p5_a5 NUMBER := 0-1962.0724
600 , p5_a6 DATE := fnd_api.g_miss_date
601 , p5_a7 NUMBER := 0-1962.0724
602 , p5_a8 NUMBER := 0-1962.0724
603 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
619 )
620
621 as
622 ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;
623 ddindx binary_integer; indx binary_integer;
624 begin
625
626 -- copy data to the local IN or IN-OUT args, if any
627
628
629
630
631
632 ddp_cat_activity_rec.cat_activity_id := rosetta_g_miss_num_map(p5_a0);
633 ddp_cat_activity_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
634 ddp_cat_activity_rec.category_id := rosetta_g_miss_num_map(p5_a2);
635 ddp_cat_activity_rec.activity_id := rosetta_g_miss_num_map(p5_a3);
636 ddp_cat_activity_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a4);
637 ddp_cat_activity_rec.last_updated_by := rosetta_g_miss_num_map(p5_a5);
638 ddp_cat_activity_rec.creation_date := rosetta_g_miss_date_in_map(p5_a6);
639 ddp_cat_activity_rec.created_by := rosetta_g_miss_num_map(p5_a7);
640 ddp_cat_activity_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
641 ddp_cat_activity_rec.attribute_category := p5_a9;
642 ddp_cat_activity_rec.attribute1 := p5_a10;
643 ddp_cat_activity_rec.attribute2 := p5_a11;
644 ddp_cat_activity_rec.attribute3 := p5_a12;
645 ddp_cat_activity_rec.attribute4 := p5_a13;
646 ddp_cat_activity_rec.attribute5 := p5_a14;
647 ddp_cat_activity_rec.attribute6 := p5_a15;
648 ddp_cat_activity_rec.attribute7 := p5_a16;
649 ddp_cat_activity_rec.attribute8 := p5_a17;
650 ddp_cat_activity_rec.attribute9 := p5_a18;
651 ddp_cat_activity_rec.attribute10 := p5_a19;
652 ddp_cat_activity_rec.attribute11 := p5_a20;
653 ddp_cat_activity_rec.attribute12 := p5_a21;
654 ddp_cat_activity_rec.attribute13 := p5_a22;
655 ddp_cat_activity_rec.attribute14 := p5_a23;
656 ddp_cat_activity_rec.attribute15 := p5_a24;
657
658 -- here's the delegated call to the old PL/SQL routine
659 ams_cat_activity_pvt.validate_cat_activity_rec(p_api_version_number,
660 p_init_msg_list,
661 x_return_status,
662 x_msg_count,
663 x_msg_data,
664 ddp_cat_activity_rec);
665
666 -- copy data back from the local variables to OUT or IN-OUT args, if any
667
668
669
670
671
672 end;
673
674 end ams_cat_activity_pvt_w;