[Home] [Help]
PACKAGE BODY: APPS.AMS_ACTCATEGORY_PVT_W
Source
1 package body ams_actcategory_pvt_w as
2 /* $Header: amswactb.pls 120.2 2005/09/26 23:38 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 create_act_category(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_act_category_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 NUMBER := 0-1962.0724
38 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56 )
57
58 as
59 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
60 ddindx binary_integer; indx binary_integer;
61 begin
62
63 -- copy data to the local IN or IN-OUT args, if any
64
65
66
67
68
69
70
71 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p7_a0);
72 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
73 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
74 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
75 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p7_a4);
76 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
77 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
78 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p7_a7);
79 ddp_act_category_rec.arc_act_category_used_by := p7_a8;
80 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p7_a9);
81 ddp_act_category_rec.attribute_category := p7_a10;
82 ddp_act_category_rec.attribute1 := p7_a11;
83 ddp_act_category_rec.attribute2 := p7_a12;
84 ddp_act_category_rec.attribute3 := p7_a13;
85 ddp_act_category_rec.attribute4 := p7_a14;
86 ddp_act_category_rec.attribute5 := p7_a15;
87 ddp_act_category_rec.attribute6 := p7_a16;
88 ddp_act_category_rec.attribute7 := p7_a17;
89 ddp_act_category_rec.attribute8 := p7_a18;
90 ddp_act_category_rec.attribute9 := p7_a19;
91 ddp_act_category_rec.attribute10 := p7_a20;
92 ddp_act_category_rec.attribute11 := p7_a21;
93 ddp_act_category_rec.attribute12 := p7_a22;
94 ddp_act_category_rec.attribute13 := p7_a23;
95 ddp_act_category_rec.attribute14 := p7_a24;
96 ddp_act_category_rec.attribute15 := p7_a25;
97
98
99 -- here's the delegated call to the old PL/SQL routine
100 ams_actcategory_pvt.create_act_category(p_api_version,
101 p_init_msg_list,
102 p_commit,
103 p_validation_level,
104 x_return_status,
105 x_msg_count,
106 x_msg_data,
107 ddp_act_category_rec,
108 x_act_category_id);
109
110 -- copy data back from the local variables to OUT or IN-OUT args, if any
111
112
113
114
115
116
117
118
119 end;
120
121 procedure update_act_category(p_api_version NUMBER
122 , p_init_msg_list VARCHAR2
123 , p_commit VARCHAR2
124 , p_validation_level NUMBER
125 , x_return_status out nocopy VARCHAR2
126 , x_msg_count out nocopy NUMBER
127 , x_msg_data out nocopy VARCHAR2
128 , p7_a0 NUMBER := 0-1962.0724
129 , p7_a1 DATE := fnd_api.g_miss_date
130 , p7_a2 NUMBER := 0-1962.0724
131 , p7_a3 DATE := fnd_api.g_miss_date
132 , p7_a4 NUMBER := 0-1962.0724
133 , p7_a5 NUMBER := 0-1962.0724
134 , p7_a6 NUMBER := 0-1962.0724
135 , p7_a7 NUMBER := 0-1962.0724
136 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a9 NUMBER := 0-1962.0724
138 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
139 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
140 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
144 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
149 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
154 )
155
156 as
157 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
158 ddindx binary_integer; indx binary_integer;
159 begin
160
161 -- copy data to the local IN or IN-OUT args, if any
162
163
164
165
166
167
168
169 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p7_a0);
170 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
171 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
172 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
173 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p7_a4);
174 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
175 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
176 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p7_a7);
177 ddp_act_category_rec.arc_act_category_used_by := p7_a8;
178 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p7_a9);
179 ddp_act_category_rec.attribute_category := p7_a10;
180 ddp_act_category_rec.attribute1 := p7_a11;
181 ddp_act_category_rec.attribute2 := p7_a12;
182 ddp_act_category_rec.attribute3 := p7_a13;
183 ddp_act_category_rec.attribute4 := p7_a14;
184 ddp_act_category_rec.attribute5 := p7_a15;
185 ddp_act_category_rec.attribute6 := p7_a16;
186 ddp_act_category_rec.attribute7 := p7_a17;
187 ddp_act_category_rec.attribute8 := p7_a18;
188 ddp_act_category_rec.attribute9 := p7_a19;
189 ddp_act_category_rec.attribute10 := p7_a20;
190 ddp_act_category_rec.attribute11 := p7_a21;
191 ddp_act_category_rec.attribute12 := p7_a22;
192 ddp_act_category_rec.attribute13 := p7_a23;
193 ddp_act_category_rec.attribute14 := p7_a24;
194 ddp_act_category_rec.attribute15 := p7_a25;
195
196 -- here's the delegated call to the old PL/SQL routine
197 ams_actcategory_pvt.update_act_category(p_api_version,
198 p_init_msg_list,
199 p_commit,
200 p_validation_level,
201 x_return_status,
202 x_msg_count,
203 x_msg_data,
204 ddp_act_category_rec);
205
206 -- copy data back from the local variables to OUT or IN-OUT args, if any
207
208
209
210
211
212
213
214 end;
215
216 procedure validate_act_category(p_api_version NUMBER
217 , p_init_msg_list VARCHAR2
218 , p_validation_level NUMBER
219 , x_return_status out nocopy VARCHAR2
220 , x_msg_count out nocopy NUMBER
221 , x_msg_data out nocopy VARCHAR2
222 , p6_a0 NUMBER := 0-1962.0724
223 , p6_a1 DATE := fnd_api.g_miss_date
224 , p6_a2 NUMBER := 0-1962.0724
225 , p6_a3 DATE := fnd_api.g_miss_date
226 , p6_a4 NUMBER := 0-1962.0724
227 , p6_a5 NUMBER := 0-1962.0724
228 , p6_a6 NUMBER := 0-1962.0724
229 , p6_a7 NUMBER := 0-1962.0724
230 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
231 , p6_a9 NUMBER := 0-1962.0724
232 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
233 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
234 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
235 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
236 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
237 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
238 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
239 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
240 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
241 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
242 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
243 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
244 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
245 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
246 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
247 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
248 )
249
250 as
251 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
252 ddindx binary_integer; indx binary_integer;
253 begin
254
255 -- copy data to the local IN or IN-OUT args, if any
256
257
258
259
260
261
262 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p6_a0);
263 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
264 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
265 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
266 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p6_a4);
267 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
268 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
269 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p6_a7);
270 ddp_act_category_rec.arc_act_category_used_by := p6_a8;
271 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p6_a9);
272 ddp_act_category_rec.attribute_category := p6_a10;
273 ddp_act_category_rec.attribute1 := p6_a11;
274 ddp_act_category_rec.attribute2 := p6_a12;
275 ddp_act_category_rec.attribute3 := p6_a13;
276 ddp_act_category_rec.attribute4 := p6_a14;
277 ddp_act_category_rec.attribute5 := p6_a15;
278 ddp_act_category_rec.attribute6 := p6_a16;
279 ddp_act_category_rec.attribute7 := p6_a17;
280 ddp_act_category_rec.attribute8 := p6_a18;
281 ddp_act_category_rec.attribute9 := p6_a19;
282 ddp_act_category_rec.attribute10 := p6_a20;
283 ddp_act_category_rec.attribute11 := p6_a21;
284 ddp_act_category_rec.attribute12 := p6_a22;
285 ddp_act_category_rec.attribute13 := p6_a23;
286 ddp_act_category_rec.attribute14 := p6_a24;
287 ddp_act_category_rec.attribute15 := p6_a25;
288
289 -- here's the delegated call to the old PL/SQL routine
290 ams_actcategory_pvt.validate_act_category(p_api_version,
291 p_init_msg_list,
292 p_validation_level,
293 x_return_status,
294 x_msg_count,
295 x_msg_data,
296 ddp_act_category_rec);
297
298 -- copy data back from the local variables to OUT or IN-OUT args, if any
299
300
301
302
303
304
305 end;
306
307 procedure validate_act_cty_items(p_validation_mode VARCHAR2
308 , x_return_status out nocopy VARCHAR2
309 , p0_a0 NUMBER := 0-1962.0724
310 , p0_a1 DATE := fnd_api.g_miss_date
311 , p0_a2 NUMBER := 0-1962.0724
312 , p0_a3 DATE := fnd_api.g_miss_date
313 , p0_a4 NUMBER := 0-1962.0724
314 , p0_a5 NUMBER := 0-1962.0724
315 , p0_a6 NUMBER := 0-1962.0724
316 , p0_a7 NUMBER := 0-1962.0724
317 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
318 , p0_a9 NUMBER := 0-1962.0724
319 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
320 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
321 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
322 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
323 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
324 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
325 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
326 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
327 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
328 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
329 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
330 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
331 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
332 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
333 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
334 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
335 )
336
337 as
338 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
339 ddindx binary_integer; indx binary_integer;
340 begin
341
342 -- copy data to the local IN or IN-OUT args, if any
343 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p0_a0);
344 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
345 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
346 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
347 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
348 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
349 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
350 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p0_a7);
351 ddp_act_category_rec.arc_act_category_used_by := p0_a8;
352 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p0_a9);
353 ddp_act_category_rec.attribute_category := p0_a10;
354 ddp_act_category_rec.attribute1 := p0_a11;
355 ddp_act_category_rec.attribute2 := p0_a12;
356 ddp_act_category_rec.attribute3 := p0_a13;
357 ddp_act_category_rec.attribute4 := p0_a14;
358 ddp_act_category_rec.attribute5 := p0_a15;
359 ddp_act_category_rec.attribute6 := p0_a16;
360 ddp_act_category_rec.attribute7 := p0_a17;
361 ddp_act_category_rec.attribute8 := p0_a18;
362 ddp_act_category_rec.attribute9 := p0_a19;
363 ddp_act_category_rec.attribute10 := p0_a20;
364 ddp_act_category_rec.attribute11 := p0_a21;
365 ddp_act_category_rec.attribute12 := p0_a22;
366 ddp_act_category_rec.attribute13 := p0_a23;
367 ddp_act_category_rec.attribute14 := p0_a24;
368 ddp_act_category_rec.attribute15 := p0_a25;
369
370
371
372 -- here's the delegated call to the old PL/SQL routine
373 ams_actcategory_pvt.validate_act_cty_items(ddp_act_category_rec,
374 p_validation_mode,
375 x_return_status);
376
377 -- copy data back from the local variables to OUT or IN-OUT args, if any
378
379
380 end;
381
382 procedure validate_act_cty_record(x_return_status out nocopy VARCHAR2
383 , p0_a0 NUMBER := 0-1962.0724
384 , p0_a1 DATE := fnd_api.g_miss_date
385 , p0_a2 NUMBER := 0-1962.0724
386 , p0_a3 DATE := fnd_api.g_miss_date
387 , p0_a4 NUMBER := 0-1962.0724
388 , p0_a5 NUMBER := 0-1962.0724
389 , p0_a6 NUMBER := 0-1962.0724
390 , p0_a7 NUMBER := 0-1962.0724
391 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
392 , p0_a9 NUMBER := 0-1962.0724
396 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
393 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
394 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
395 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
397 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
398 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
399 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
400 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
401 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
402 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
403 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
404 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
405 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
406 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
407 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
408 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
409 )
410
411 as
412 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
413 ddindx binary_integer; indx binary_integer;
414 begin
415
416 -- copy data to the local IN or IN-OUT args, if any
417 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p0_a0);
418 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
419 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
420 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
421 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
422 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
423 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
424 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p0_a7);
425 ddp_act_category_rec.arc_act_category_used_by := p0_a8;
426 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p0_a9);
427 ddp_act_category_rec.attribute_category := p0_a10;
428 ddp_act_category_rec.attribute1 := p0_a11;
429 ddp_act_category_rec.attribute2 := p0_a12;
430 ddp_act_category_rec.attribute3 := p0_a13;
431 ddp_act_category_rec.attribute4 := p0_a14;
432 ddp_act_category_rec.attribute5 := p0_a15;
433 ddp_act_category_rec.attribute6 := p0_a16;
434 ddp_act_category_rec.attribute7 := p0_a17;
435 ddp_act_category_rec.attribute8 := p0_a18;
436 ddp_act_category_rec.attribute9 := p0_a19;
437 ddp_act_category_rec.attribute10 := p0_a20;
438 ddp_act_category_rec.attribute11 := p0_a21;
439 ddp_act_category_rec.attribute12 := p0_a22;
440 ddp_act_category_rec.attribute13 := p0_a23;
441 ddp_act_category_rec.attribute14 := p0_a24;
442 ddp_act_category_rec.attribute15 := p0_a25;
443
444
445 -- here's the delegated call to the old PL/SQL routine
446 ams_actcategory_pvt.validate_act_cty_record(ddp_act_category_rec,
447 x_return_status);
448
449 -- copy data back from the local variables to OUT or IN-OUT args, if any
450
451 end;
452
453 procedure complete_act_category_rec(p1_a0 out nocopy NUMBER
454 , p1_a1 out nocopy DATE
455 , p1_a2 out nocopy NUMBER
456 , p1_a3 out nocopy DATE
457 , p1_a4 out nocopy NUMBER
458 , p1_a5 out nocopy NUMBER
459 , p1_a6 out nocopy NUMBER
460 , p1_a7 out nocopy NUMBER
461 , p1_a8 out nocopy VARCHAR2
462 , p1_a9 out nocopy NUMBER
463 , p1_a10 out nocopy VARCHAR2
464 , p1_a11 out nocopy VARCHAR2
465 , p1_a12 out nocopy VARCHAR2
466 , p1_a13 out nocopy VARCHAR2
467 , p1_a14 out nocopy VARCHAR2
468 , p1_a15 out nocopy VARCHAR2
469 , p1_a16 out nocopy VARCHAR2
470 , p1_a17 out nocopy VARCHAR2
471 , p1_a18 out nocopy VARCHAR2
472 , p1_a19 out nocopy VARCHAR2
473 , p1_a20 out nocopy VARCHAR2
474 , p1_a21 out nocopy VARCHAR2
475 , p1_a22 out nocopy VARCHAR2
476 , p1_a23 out nocopy VARCHAR2
477 , p1_a24 out nocopy VARCHAR2
478 , p1_a25 out nocopy VARCHAR2
479 , p0_a0 NUMBER := 0-1962.0724
480 , p0_a1 DATE := fnd_api.g_miss_date
481 , p0_a2 NUMBER := 0-1962.0724
482 , p0_a3 DATE := fnd_api.g_miss_date
483 , p0_a4 NUMBER := 0-1962.0724
484 , p0_a5 NUMBER := 0-1962.0724
485 , p0_a6 NUMBER := 0-1962.0724
486 , p0_a7 NUMBER := 0-1962.0724
487 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
488 , p0_a9 NUMBER := 0-1962.0724
489 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
490 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
491 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
492 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
493 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
494 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
495 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
496 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
497 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
499 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
500 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
501 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
502 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
503 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
504 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
505 )
506
507 as
508 ddp_act_category_rec ams_actcategory_pvt.act_category_rec_type;
509 ddx_act_category_rec ams_actcategory_pvt.act_category_rec_type;
510 ddindx binary_integer; indx binary_integer;
511 begin
512
513 -- copy data to the local IN or IN-OUT args, if any
517 ddp_act_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
514 ddp_act_category_rec.activity_category_id := rosetta_g_miss_num_map(p0_a0);
515 ddp_act_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
516 ddp_act_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
518 ddp_act_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
519 ddp_act_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
520 ddp_act_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
521 ddp_act_category_rec.act_category_used_by_id := rosetta_g_miss_num_map(p0_a7);
522 ddp_act_category_rec.arc_act_category_used_by := p0_a8;
523 ddp_act_category_rec.category_id := rosetta_g_miss_num_map(p0_a9);
524 ddp_act_category_rec.attribute_category := p0_a10;
525 ddp_act_category_rec.attribute1 := p0_a11;
526 ddp_act_category_rec.attribute2 := p0_a12;
527 ddp_act_category_rec.attribute3 := p0_a13;
528 ddp_act_category_rec.attribute4 := p0_a14;
529 ddp_act_category_rec.attribute5 := p0_a15;
530 ddp_act_category_rec.attribute6 := p0_a16;
531 ddp_act_category_rec.attribute7 := p0_a17;
532 ddp_act_category_rec.attribute8 := p0_a18;
533 ddp_act_category_rec.attribute9 := p0_a19;
534 ddp_act_category_rec.attribute10 := p0_a20;
535 ddp_act_category_rec.attribute11 := p0_a21;
536 ddp_act_category_rec.attribute12 := p0_a22;
537 ddp_act_category_rec.attribute13 := p0_a23;
538 ddp_act_category_rec.attribute14 := p0_a24;
539 ddp_act_category_rec.attribute15 := p0_a25;
540
541
542 -- here's the delegated call to the old PL/SQL routine
543 ams_actcategory_pvt.complete_act_category_rec(ddp_act_category_rec,
544 ddx_act_category_rec);
545
546 -- copy data back from the local variables to OUT or IN-OUT args, if any
547
548 p1_a0 := rosetta_g_miss_num_map(ddx_act_category_rec.activity_category_id);
549 p1_a1 := ddx_act_category_rec.last_update_date;
550 p1_a2 := rosetta_g_miss_num_map(ddx_act_category_rec.last_updated_by);
551 p1_a3 := ddx_act_category_rec.creation_date;
552 p1_a4 := rosetta_g_miss_num_map(ddx_act_category_rec.created_by);
553 p1_a5 := rosetta_g_miss_num_map(ddx_act_category_rec.last_update_login);
554 p1_a6 := rosetta_g_miss_num_map(ddx_act_category_rec.object_version_number);
555 p1_a7 := rosetta_g_miss_num_map(ddx_act_category_rec.act_category_used_by_id);
556 p1_a8 := ddx_act_category_rec.arc_act_category_used_by;
557 p1_a9 := rosetta_g_miss_num_map(ddx_act_category_rec.category_id);
558 p1_a10 := ddx_act_category_rec.attribute_category;
559 p1_a11 := ddx_act_category_rec.attribute1;
560 p1_a12 := ddx_act_category_rec.attribute2;
561 p1_a13 := ddx_act_category_rec.attribute3;
562 p1_a14 := ddx_act_category_rec.attribute4;
563 p1_a15 := ddx_act_category_rec.attribute5;
564 p1_a16 := ddx_act_category_rec.attribute6;
565 p1_a17 := ddx_act_category_rec.attribute7;
566 p1_a18 := ddx_act_category_rec.attribute8;
567 p1_a19 := ddx_act_category_rec.attribute9;
568 p1_a20 := ddx_act_category_rec.attribute10;
569 p1_a21 := ddx_act_category_rec.attribute11;
570 p1_a22 := ddx_act_category_rec.attribute12;
571 p1_a23 := ddx_act_category_rec.attribute13;
572 p1_a24 := ddx_act_category_rec.attribute14;
573 p1_a25 := ddx_act_category_rec.attribute15;
574 end;
575
576 end ams_actcategory_pvt_w;