[Home] [Help]
PACKAGE BODY: APPS.AMS_CATEGORY_PVT_W
Source
1 package body ams_category_pvt_w as
2 /* $Header: amswctyb.pls 120.1 2005/10/21 03:54 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_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_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 VARCHAR2 := fnd_api.g_miss_char
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 , 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 NUMBER := 0-1962.0724
60 , p7_a30 NUMBER := 0-1962.0724
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a32 NUMBER := 0-1962.0724
63 )
64
65 as
66 ddp_category_rec ams_category_pvt.category_rec_type;
67 ddindx binary_integer; indx binary_integer;
68 begin
69
70 -- copy data to the local IN or IN-OUT args, if any
71
72
73
74
75
76
77
78 ddp_category_rec.category_id := rosetta_g_miss_num_map(p7_a0);
79 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
80 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
81 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
82 ddp_category_rec.created_by := rosetta_g_miss_num_map(p7_a4);
83 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
84 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
85 ddp_category_rec.arc_category_created_for := p7_a7;
86 ddp_category_rec.enabled_flag := p7_a8;
87 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p7_a9);
88 ddp_category_rec.attribute_category := p7_a10;
89 ddp_category_rec.attribute1 := p7_a11;
90 ddp_category_rec.attribute2 := p7_a12;
91 ddp_category_rec.attribute3 := p7_a13;
92 ddp_category_rec.attribute4 := p7_a14;
93 ddp_category_rec.attribute5 := p7_a15;
94 ddp_category_rec.attribute6 := p7_a16;
95 ddp_category_rec.attribute7 := p7_a17;
96 ddp_category_rec.attribute8 := p7_a18;
97 ddp_category_rec.attribute9 := p7_a19;
98 ddp_category_rec.attribute10 := p7_a20;
99 ddp_category_rec.attribute11 := p7_a21;
100 ddp_category_rec.attribute12 := p7_a22;
101 ddp_category_rec.attribute13 := p7_a23;
102 ddp_category_rec.attribute14 := p7_a24;
103 ddp_category_rec.attribute15 := p7_a25;
104 ddp_category_rec.source_lang := p7_a26;
105 ddp_category_rec.category_name := p7_a27;
106 ddp_category_rec.description := p7_a28;
107 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p7_a29);
108 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p7_a30);
109 ddp_category_rec.budget_code_suffix := p7_a31;
110 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p7_a32);
111
112
113 -- here's the delegated call to the old PL/SQL routine
114 ams_category_pvt.create_category(p_api_version,
115 p_init_msg_list,
116 p_commit,
117 p_validation_level,
118 x_return_status,
119 x_msg_count,
120 x_msg_data,
121 ddp_category_rec,
122 x_category_id);
123
124 -- copy data back from the local variables to OUT or IN-OUT args, if any
125
126
127
128
129
130
131
132
133 end;
134
135 procedure update_category(p_api_version NUMBER
136 , p_init_msg_list VARCHAR2
137 , p_commit VARCHAR2
138 , p_validation_level NUMBER
139 , x_return_status out nocopy VARCHAR2
140 , x_msg_count out nocopy NUMBER
141 , x_msg_data out nocopy VARCHAR2
142 , p7_a0 NUMBER := 0-1962.0724
143 , p7_a1 DATE := fnd_api.g_miss_date
144 , p7_a2 NUMBER := 0-1962.0724
145 , p7_a3 DATE := fnd_api.g_miss_date
146 , p7_a4 NUMBER := 0-1962.0724
147 , p7_a5 NUMBER := 0-1962.0724
148 , p7_a6 NUMBER := 0-1962.0724
149 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a9 NUMBER := 0-1962.0724
152 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
158 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
159 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
161 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
162 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
167 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
168 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a29 NUMBER := 0-1962.0724
172 , p7_a30 NUMBER := 0-1962.0724
173 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
174 , p7_a32 NUMBER := 0-1962.0724
175 )
176
177 as
178 ddp_category_rec ams_category_pvt.category_rec_type;
179 ddindx binary_integer; indx binary_integer;
180 begin
181
182 -- copy data to the local IN or IN-OUT args, if any
183
184
185
186
187
188
189
190 ddp_category_rec.category_id := rosetta_g_miss_num_map(p7_a0);
191 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
192 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
193 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
194 ddp_category_rec.created_by := rosetta_g_miss_num_map(p7_a4);
195 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
196 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
197 ddp_category_rec.arc_category_created_for := p7_a7;
198 ddp_category_rec.enabled_flag := p7_a8;
199 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p7_a9);
200 ddp_category_rec.attribute_category := p7_a10;
201 ddp_category_rec.attribute1 := p7_a11;
202 ddp_category_rec.attribute2 := p7_a12;
203 ddp_category_rec.attribute3 := p7_a13;
204 ddp_category_rec.attribute4 := p7_a14;
205 ddp_category_rec.attribute5 := p7_a15;
206 ddp_category_rec.attribute6 := p7_a16;
207 ddp_category_rec.attribute7 := p7_a17;
208 ddp_category_rec.attribute8 := p7_a18;
209 ddp_category_rec.attribute9 := p7_a19;
210 ddp_category_rec.attribute10 := p7_a20;
211 ddp_category_rec.attribute11 := p7_a21;
212 ddp_category_rec.attribute12 := p7_a22;
213 ddp_category_rec.attribute13 := p7_a23;
214 ddp_category_rec.attribute14 := p7_a24;
215 ddp_category_rec.attribute15 := p7_a25;
216 ddp_category_rec.source_lang := p7_a26;
217 ddp_category_rec.category_name := p7_a27;
218 ddp_category_rec.description := p7_a28;
219 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p7_a29);
220 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p7_a30);
221 ddp_category_rec.budget_code_suffix := p7_a31;
222 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p7_a32);
223
224 -- here's the delegated call to the old PL/SQL routine
225 ams_category_pvt.update_category(p_api_version,
226 p_init_msg_list,
227 p_commit,
228 p_validation_level,
229 x_return_status,
230 x_msg_count,
231 x_msg_data,
232 ddp_category_rec);
233
234 -- copy data back from the local variables to OUT or IN-OUT args, if any
235
236
237
238
239
240
241
242 end;
243
244 procedure complete_category_rec(p1_a0 out nocopy NUMBER
245 , p1_a1 out nocopy DATE
246 , p1_a2 out nocopy NUMBER
247 , p1_a3 out nocopy DATE
248 , p1_a4 out nocopy NUMBER
249 , p1_a5 out nocopy NUMBER
250 , p1_a6 out nocopy NUMBER
251 , p1_a7 out nocopy VARCHAR2
252 , p1_a8 out nocopy VARCHAR2
253 , p1_a9 out nocopy NUMBER
254 , p1_a10 out nocopy VARCHAR2
255 , p1_a11 out nocopy VARCHAR2
256 , p1_a12 out nocopy VARCHAR2
257 , p1_a13 out nocopy VARCHAR2
258 , p1_a14 out nocopy VARCHAR2
259 , p1_a15 out nocopy VARCHAR2
260 , p1_a16 out nocopy VARCHAR2
261 , p1_a17 out nocopy VARCHAR2
262 , p1_a18 out nocopy VARCHAR2
263 , p1_a19 out nocopy VARCHAR2
264 , p1_a20 out nocopy VARCHAR2
265 , p1_a21 out nocopy VARCHAR2
266 , p1_a22 out nocopy VARCHAR2
267 , p1_a23 out nocopy VARCHAR2
268 , p1_a24 out nocopy VARCHAR2
269 , p1_a25 out nocopy VARCHAR2
270 , p1_a26 out nocopy VARCHAR2
271 , p1_a27 out nocopy VARCHAR2
272 , p1_a28 out nocopy VARCHAR2
273 , p1_a29 out nocopy NUMBER
274 , p1_a30 out nocopy NUMBER
275 , p1_a31 out nocopy VARCHAR2
276 , p1_a32 out nocopy NUMBER
277 , p0_a0 NUMBER := 0-1962.0724
278 , p0_a1 DATE := fnd_api.g_miss_date
279 , p0_a2 NUMBER := 0-1962.0724
280 , p0_a3 DATE := fnd_api.g_miss_date
281 , p0_a4 NUMBER := 0-1962.0724
282 , p0_a5 NUMBER := 0-1962.0724
283 , p0_a6 NUMBER := 0-1962.0724
284 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
285 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
286 , p0_a9 NUMBER := 0-1962.0724
287 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
288 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
289 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
290 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
291 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
292 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
293 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
294 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
295 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
296 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
297 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
298 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
299 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
300 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
301 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
302 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
303 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
304 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
305 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
306 , p0_a29 NUMBER := 0-1962.0724
307 , p0_a30 NUMBER := 0-1962.0724
308 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
309 , p0_a32 NUMBER := 0-1962.0724
310 )
311
312 as
313 ddp_category_rec ams_category_pvt.category_rec_type;
314 ddx_complete_rec ams_category_pvt.category_rec_type;
315 ddindx binary_integer; indx binary_integer;
316 begin
317
318 -- copy data to the local IN or IN-OUT args, if any
319 ddp_category_rec.category_id := rosetta_g_miss_num_map(p0_a0);
320 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
321 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
322 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
323 ddp_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
324 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
325 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
326 ddp_category_rec.arc_category_created_for := p0_a7;
327 ddp_category_rec.enabled_flag := p0_a8;
328 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p0_a9);
329 ddp_category_rec.attribute_category := p0_a10;
330 ddp_category_rec.attribute1 := p0_a11;
331 ddp_category_rec.attribute2 := p0_a12;
332 ddp_category_rec.attribute3 := p0_a13;
333 ddp_category_rec.attribute4 := p0_a14;
334 ddp_category_rec.attribute5 := p0_a15;
335 ddp_category_rec.attribute6 := p0_a16;
339 ddp_category_rec.attribute10 := p0_a20;
336 ddp_category_rec.attribute7 := p0_a17;
337 ddp_category_rec.attribute8 := p0_a18;
338 ddp_category_rec.attribute9 := p0_a19;
340 ddp_category_rec.attribute11 := p0_a21;
341 ddp_category_rec.attribute12 := p0_a22;
342 ddp_category_rec.attribute13 := p0_a23;
343 ddp_category_rec.attribute14 := p0_a24;
344 ddp_category_rec.attribute15 := p0_a25;
345 ddp_category_rec.source_lang := p0_a26;
346 ddp_category_rec.category_name := p0_a27;
347 ddp_category_rec.description := p0_a28;
348 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p0_a29);
349 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p0_a30);
350 ddp_category_rec.budget_code_suffix := p0_a31;
351 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p0_a32);
352
353
354 -- here's the delegated call to the old PL/SQL routine
355 ams_category_pvt.complete_category_rec(ddp_category_rec,
356 ddx_complete_rec);
357
358 -- copy data back from the local variables to OUT or IN-OUT args, if any
359
360 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.category_id);
361 p1_a1 := ddx_complete_rec.last_update_date;
362 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
363 p1_a3 := ddx_complete_rec.creation_date;
364 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
365 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
366 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
367 p1_a7 := ddx_complete_rec.arc_category_created_for;
368 p1_a8 := ddx_complete_rec.enabled_flag;
369 p1_a9 := rosetta_g_miss_num_map(ddx_complete_rec.parent_category_id);
370 p1_a10 := ddx_complete_rec.attribute_category;
371 p1_a11 := ddx_complete_rec.attribute1;
372 p1_a12 := ddx_complete_rec.attribute2;
373 p1_a13 := ddx_complete_rec.attribute3;
374 p1_a14 := ddx_complete_rec.attribute4;
375 p1_a15 := ddx_complete_rec.attribute5;
376 p1_a16 := ddx_complete_rec.attribute6;
377 p1_a17 := ddx_complete_rec.attribute7;
378 p1_a18 := ddx_complete_rec.attribute8;
379 p1_a19 := ddx_complete_rec.attribute9;
380 p1_a20 := ddx_complete_rec.attribute10;
381 p1_a21 := ddx_complete_rec.attribute11;
382 p1_a22 := ddx_complete_rec.attribute12;
383 p1_a23 := ddx_complete_rec.attribute13;
384 p1_a24 := ddx_complete_rec.attribute14;
385 p1_a25 := ddx_complete_rec.attribute15;
386 p1_a26 := ddx_complete_rec.source_lang;
387 p1_a27 := ddx_complete_rec.category_name;
388 p1_a28 := ddx_complete_rec.description;
389 p1_a29 := rosetta_g_miss_num_map(ddx_complete_rec.accrued_liability_account);
390 p1_a30 := rosetta_g_miss_num_map(ddx_complete_rec.ded_adjustment_account);
391 p1_a31 := ddx_complete_rec.budget_code_suffix;
392 p1_a32 := rosetta_g_miss_num_map(ddx_complete_rec.ledger_id);
393 end;
394
395 procedure validate_category(p_api_version NUMBER
396 , p_init_msg_list VARCHAR2
397 , p_validation_level NUMBER
398 , x_return_status out nocopy VARCHAR2
399 , x_msg_count out nocopy NUMBER
400 , x_msg_data out nocopy VARCHAR2
401 , p6_a0 NUMBER := 0-1962.0724
402 , p6_a1 DATE := fnd_api.g_miss_date
403 , p6_a2 NUMBER := 0-1962.0724
404 , p6_a3 DATE := fnd_api.g_miss_date
405 , p6_a4 NUMBER := 0-1962.0724
406 , p6_a5 NUMBER := 0-1962.0724
407 , p6_a6 NUMBER := 0-1962.0724
408 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
409 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
410 , p6_a9 NUMBER := 0-1962.0724
411 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
412 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
413 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
414 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
415 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
416 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
417 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
418 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
419 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
420 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
421 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
422 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
423 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
424 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
425 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
426 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
427 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
428 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
429 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
430 , p6_a29 NUMBER := 0-1962.0724
431 , p6_a30 NUMBER := 0-1962.0724
432 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
433 , p6_a32 NUMBER := 0-1962.0724
434 )
435
436 as
437 ddp_category_rec ams_category_pvt.category_rec_type;
438 ddindx binary_integer; indx binary_integer;
439 begin
440
441 -- copy data to the local IN or IN-OUT args, if any
442
443
444
445
446
447
448 ddp_category_rec.category_id := rosetta_g_miss_num_map(p6_a0);
449 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
450 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
451 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
452 ddp_category_rec.created_by := rosetta_g_miss_num_map(p6_a4);
456 ddp_category_rec.enabled_flag := p6_a8;
453 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
454 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
455 ddp_category_rec.arc_category_created_for := p6_a7;
457 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p6_a9);
458 ddp_category_rec.attribute_category := p6_a10;
459 ddp_category_rec.attribute1 := p6_a11;
460 ddp_category_rec.attribute2 := p6_a12;
461 ddp_category_rec.attribute3 := p6_a13;
462 ddp_category_rec.attribute4 := p6_a14;
463 ddp_category_rec.attribute5 := p6_a15;
464 ddp_category_rec.attribute6 := p6_a16;
465 ddp_category_rec.attribute7 := p6_a17;
466 ddp_category_rec.attribute8 := p6_a18;
467 ddp_category_rec.attribute9 := p6_a19;
468 ddp_category_rec.attribute10 := p6_a20;
469 ddp_category_rec.attribute11 := p6_a21;
470 ddp_category_rec.attribute12 := p6_a22;
471 ddp_category_rec.attribute13 := p6_a23;
472 ddp_category_rec.attribute14 := p6_a24;
473 ddp_category_rec.attribute15 := p6_a25;
474 ddp_category_rec.source_lang := p6_a26;
475 ddp_category_rec.category_name := p6_a27;
476 ddp_category_rec.description := p6_a28;
477 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p6_a29);
478 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p6_a30);
479 ddp_category_rec.budget_code_suffix := p6_a31;
480 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p6_a32);
481
482 -- here's the delegated call to the old PL/SQL routine
483 ams_category_pvt.validate_category(p_api_version,
484 p_init_msg_list,
485 p_validation_level,
486 x_return_status,
487 x_msg_count,
488 x_msg_data,
489 ddp_category_rec);
490
491 -- copy data back from the local variables to OUT or IN-OUT args, if any
492
493
494
495
496
497
498 end;
499
500 procedure validate_cty_items(x_return_status out nocopy VARCHAR2
501 , p0_a0 NUMBER := 0-1962.0724
502 , p0_a1 DATE := fnd_api.g_miss_date
503 , p0_a2 NUMBER := 0-1962.0724
504 , p0_a3 DATE := fnd_api.g_miss_date
505 , p0_a4 NUMBER := 0-1962.0724
506 , p0_a5 NUMBER := 0-1962.0724
507 , p0_a6 NUMBER := 0-1962.0724
508 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
509 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
510 , p0_a9 NUMBER := 0-1962.0724
511 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
512 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
513 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
514 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
515 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
516 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
517 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
518 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
519 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
520 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
521 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
522 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
523 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
524 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
525 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
526 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
527 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
528 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
529 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
530 , p0_a29 NUMBER := 0-1962.0724
531 , p0_a30 NUMBER := 0-1962.0724
532 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
533 , p0_a32 NUMBER := 0-1962.0724
534 )
535
536 as
537 ddp_category_rec ams_category_pvt.category_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 ddp_category_rec.category_id := rosetta_g_miss_num_map(p0_a0);
543 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
544 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
545 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
546 ddp_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
547 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
548 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
549 ddp_category_rec.arc_category_created_for := p0_a7;
550 ddp_category_rec.enabled_flag := p0_a8;
551 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p0_a9);
552 ddp_category_rec.attribute_category := p0_a10;
553 ddp_category_rec.attribute1 := p0_a11;
554 ddp_category_rec.attribute2 := p0_a12;
555 ddp_category_rec.attribute3 := p0_a13;
556 ddp_category_rec.attribute4 := p0_a14;
557 ddp_category_rec.attribute5 := p0_a15;
558 ddp_category_rec.attribute6 := p0_a16;
559 ddp_category_rec.attribute7 := p0_a17;
560 ddp_category_rec.attribute8 := p0_a18;
561 ddp_category_rec.attribute9 := p0_a19;
562 ddp_category_rec.attribute10 := p0_a20;
563 ddp_category_rec.attribute11 := p0_a21;
564 ddp_category_rec.attribute12 := p0_a22;
565 ddp_category_rec.attribute13 := p0_a23;
566 ddp_category_rec.attribute14 := p0_a24;
567 ddp_category_rec.attribute15 := p0_a25;
568 ddp_category_rec.source_lang := p0_a26;
569 ddp_category_rec.category_name := p0_a27;
570 ddp_category_rec.description := p0_a28;
574 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p0_a32);
571 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p0_a29);
572 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p0_a30);
573 ddp_category_rec.budget_code_suffix := p0_a31;
575
576
577 -- here's the delegated call to the old PL/SQL routine
578 ams_category_pvt.validate_cty_items(ddp_category_rec,
579 x_return_status);
580
581 -- copy data back from the local variables to OUT or IN-OUT args, if any
582
583 end;
584
585 procedure validate_cty_record(p_api_version NUMBER
586 , p_init_msg_list VARCHAR2
587 , x_return_status out nocopy VARCHAR2
588 , x_msg_count out nocopy NUMBER
589 , x_msg_data out nocopy VARCHAR2
590 , p5_a0 NUMBER := 0-1962.0724
591 , p5_a1 DATE := fnd_api.g_miss_date
592 , p5_a2 NUMBER := 0-1962.0724
593 , p5_a3 DATE := fnd_api.g_miss_date
594 , p5_a4 NUMBER := 0-1962.0724
595 , p5_a5 NUMBER := 0-1962.0724
596 , p5_a6 NUMBER := 0-1962.0724
597 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
599 , p5_a9 NUMBER := 0-1962.0724
600 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
601 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
603 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a29 NUMBER := 0-1962.0724
620 , p5_a30 NUMBER := 0-1962.0724
621 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a32 NUMBER := 0-1962.0724
623 )
624
625 as
626 ddp_category_rec ams_category_pvt.category_rec_type;
627 ddindx binary_integer; indx binary_integer;
628 begin
629
630 -- copy data to the local IN or IN-OUT args, if any
631
632
633
634
635
636 ddp_category_rec.category_id := rosetta_g_miss_num_map(p5_a0);
637 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a1);
638 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p5_a2);
639 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p5_a3);
640 ddp_category_rec.created_by := rosetta_g_miss_num_map(p5_a4);
641 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p5_a5);
642 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p5_a6);
643 ddp_category_rec.arc_category_created_for := p5_a7;
644 ddp_category_rec.enabled_flag := p5_a8;
645 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p5_a9);
646 ddp_category_rec.attribute_category := p5_a10;
647 ddp_category_rec.attribute1 := p5_a11;
648 ddp_category_rec.attribute2 := p5_a12;
649 ddp_category_rec.attribute3 := p5_a13;
650 ddp_category_rec.attribute4 := p5_a14;
651 ddp_category_rec.attribute5 := p5_a15;
652 ddp_category_rec.attribute6 := p5_a16;
653 ddp_category_rec.attribute7 := p5_a17;
654 ddp_category_rec.attribute8 := p5_a18;
655 ddp_category_rec.attribute9 := p5_a19;
656 ddp_category_rec.attribute10 := p5_a20;
657 ddp_category_rec.attribute11 := p5_a21;
658 ddp_category_rec.attribute12 := p5_a22;
659 ddp_category_rec.attribute13 := p5_a23;
660 ddp_category_rec.attribute14 := p5_a24;
661 ddp_category_rec.attribute15 := p5_a25;
662 ddp_category_rec.source_lang := p5_a26;
663 ddp_category_rec.category_name := p5_a27;
664 ddp_category_rec.description := p5_a28;
665 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p5_a29);
666 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p5_a30);
667 ddp_category_rec.budget_code_suffix := p5_a31;
668 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p5_a32);
669
670 -- here's the delegated call to the old PL/SQL routine
671 ams_category_pvt.validate_cty_record(p_api_version,
672 p_init_msg_list,
673 x_return_status,
674 x_msg_count,
675 x_msg_data,
676 ddp_category_rec);
677
678 -- copy data back from the local variables to OUT or IN-OUT args, if any
679
680
681
682
683
684 end;
685
686 procedure check_req_cty_items(x_return_status out nocopy VARCHAR2
687 , p0_a0 NUMBER := 0-1962.0724
688 , p0_a1 DATE := fnd_api.g_miss_date
689 , p0_a2 NUMBER := 0-1962.0724
690 , p0_a3 DATE := fnd_api.g_miss_date
691 , p0_a4 NUMBER := 0-1962.0724
692 , p0_a5 NUMBER := 0-1962.0724
693 , p0_a6 NUMBER := 0-1962.0724
694 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
695 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
699 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
696 , p0_a9 NUMBER := 0-1962.0724
697 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
698 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
700 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
701 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
702 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
703 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
704 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
705 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
706 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
707 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
708 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
709 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
710 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
711 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
712 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
713 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
714 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
715 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
716 , p0_a29 NUMBER := 0-1962.0724
717 , p0_a30 NUMBER := 0-1962.0724
718 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
719 , p0_a32 NUMBER := 0-1962.0724
720 )
721
722 as
723 ddp_category_rec ams_category_pvt.category_rec_type;
724 ddindx binary_integer; indx binary_integer;
725 begin
726
727 -- copy data to the local IN or IN-OUT args, if any
728 ddp_category_rec.category_id := rosetta_g_miss_num_map(p0_a0);
729 ddp_category_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
730 ddp_category_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
731 ddp_category_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
732 ddp_category_rec.created_by := rosetta_g_miss_num_map(p0_a4);
733 ddp_category_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
734 ddp_category_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
735 ddp_category_rec.arc_category_created_for := p0_a7;
736 ddp_category_rec.enabled_flag := p0_a8;
737 ddp_category_rec.parent_category_id := rosetta_g_miss_num_map(p0_a9);
738 ddp_category_rec.attribute_category := p0_a10;
739 ddp_category_rec.attribute1 := p0_a11;
740 ddp_category_rec.attribute2 := p0_a12;
741 ddp_category_rec.attribute3 := p0_a13;
742 ddp_category_rec.attribute4 := p0_a14;
743 ddp_category_rec.attribute5 := p0_a15;
744 ddp_category_rec.attribute6 := p0_a16;
745 ddp_category_rec.attribute7 := p0_a17;
746 ddp_category_rec.attribute8 := p0_a18;
747 ddp_category_rec.attribute9 := p0_a19;
748 ddp_category_rec.attribute10 := p0_a20;
749 ddp_category_rec.attribute11 := p0_a21;
750 ddp_category_rec.attribute12 := p0_a22;
751 ddp_category_rec.attribute13 := p0_a23;
752 ddp_category_rec.attribute14 := p0_a24;
753 ddp_category_rec.attribute15 := p0_a25;
754 ddp_category_rec.source_lang := p0_a26;
755 ddp_category_rec.category_name := p0_a27;
756 ddp_category_rec.description := p0_a28;
757 ddp_category_rec.accrued_liability_account := rosetta_g_miss_num_map(p0_a29);
758 ddp_category_rec.ded_adjustment_account := rosetta_g_miss_num_map(p0_a30);
759 ddp_category_rec.budget_code_suffix := p0_a31;
760 ddp_category_rec.ledger_id := rosetta_g_miss_num_map(p0_a32);
761
762
763 -- here's the delegated call to the old PL/SQL routine
764 ams_category_pvt.check_req_cty_items(ddp_category_rec,
765 x_return_status);
766
767 -- copy data back from the local variables to OUT or IN-OUT args, if any
768
769 end;
770
771 end ams_category_pvt_w;