[Home] [Help]
PACKAGE BODY: APPS.AMS_DELIVKITITEM_PVT_W
Source
1 package body ams_delivkititem_pvt_w as
2 /* $Header: amswdkib.pls 115.11 2002/11/15 21:03:37 abhola ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_deliv_kit_item(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_deliv_kit_item_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 NUMBER := 0-1962.0724
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 NUMBER := 0-1962.0724
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 )
58 as
59 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_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_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p7_a0);
72 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
73 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
74 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
75 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p7_a4);
76 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
77 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
78 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p7_a7);
79 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p7_a8);
80 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p7_a9);
81 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p7_a10);
82 ddp_deliv_kit_item_rec.attribute_category := p7_a11;
83 ddp_deliv_kit_item_rec.attribute1 := p7_a12;
84 ddp_deliv_kit_item_rec.attribute2 := p7_a13;
85 ddp_deliv_kit_item_rec.attribute3 := p7_a14;
86 ddp_deliv_kit_item_rec.attribute4 := p7_a15;
87 ddp_deliv_kit_item_rec.attribute5 := p7_a16;
88 ddp_deliv_kit_item_rec.attribute6 := p7_a17;
89 ddp_deliv_kit_item_rec.attribute7 := p7_a18;
90 ddp_deliv_kit_item_rec.attribute8 := p7_a19;
91 ddp_deliv_kit_item_rec.attribute9 := p7_a20;
92 ddp_deliv_kit_item_rec.attribute10 := p7_a21;
93 ddp_deliv_kit_item_rec.attribute11 := p7_a22;
94 ddp_deliv_kit_item_rec.attribute12 := p7_a23;
95 ddp_deliv_kit_item_rec.attribute13 := p7_a24;
96 ddp_deliv_kit_item_rec.attribute14 := p7_a25;
97 ddp_deliv_kit_item_rec.attribute15 := p7_a26;
98
99
100 -- here's the delegated call to the old PL/SQL routine
101 ams_delivkititem_pvt.create_deliv_kit_item(p_api_version,
102 p_init_msg_list,
103 p_commit,
104 p_validation_level,
105 x_return_status,
106 x_msg_count,
107 x_msg_data,
108 ddp_deliv_kit_item_rec,
109 x_deliv_kit_item_id);
110
111 -- copy data back from the local OUT or IN-OUT args, if any
112
113
114
115
116
117
118
119
120 end;
121
122 procedure update_deliv_kit_item(p_api_version NUMBER
123 , p_init_msg_list VARCHAR2
124 , p_commit VARCHAR2
125 , p_validation_level NUMBER
126 , x_return_status OUT NOCOPY VARCHAR2
127 , x_msg_count OUT NOCOPY NUMBER
128 , x_msg_data OUT NOCOPY VARCHAR2
129 , p7_a0 NUMBER := 0-1962.0724
130 , p7_a1 DATE := fnd_api.g_miss_date
131 , p7_a2 NUMBER := 0-1962.0724
132 , p7_a3 DATE := fnd_api.g_miss_date
133 , p7_a4 NUMBER := 0-1962.0724
134 , p7_a5 NUMBER := 0-1962.0724
135 , p7_a6 NUMBER := 0-1962.0724
136 , p7_a7 NUMBER := 0-1962.0724
137 , p7_a8 NUMBER := 0-1962.0724
138 , p7_a9 NUMBER := 0-1962.0724
139 , p7_a10 NUMBER := 0-1962.0724
140 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
144 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
156 )
157 as
158 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
159 ddindx binary_integer; indx binary_integer;
160 begin
161
162 -- copy data to the local IN or IN-OUT args, if any
163
164
165
166
167
168
169
170 ddp_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p7_a0);
171 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
172 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
173 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
174 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p7_a4);
175 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
176 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
177 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p7_a7);
178 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p7_a8);
179 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p7_a9);
180 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p7_a10);
181 ddp_deliv_kit_item_rec.attribute_category := p7_a11;
182 ddp_deliv_kit_item_rec.attribute1 := p7_a12;
183 ddp_deliv_kit_item_rec.attribute2 := p7_a13;
184 ddp_deliv_kit_item_rec.attribute3 := p7_a14;
185 ddp_deliv_kit_item_rec.attribute4 := p7_a15;
186 ddp_deliv_kit_item_rec.attribute5 := p7_a16;
187 ddp_deliv_kit_item_rec.attribute6 := p7_a17;
188 ddp_deliv_kit_item_rec.attribute7 := p7_a18;
189 ddp_deliv_kit_item_rec.attribute8 := p7_a19;
190 ddp_deliv_kit_item_rec.attribute9 := p7_a20;
191 ddp_deliv_kit_item_rec.attribute10 := p7_a21;
192 ddp_deliv_kit_item_rec.attribute11 := p7_a22;
193 ddp_deliv_kit_item_rec.attribute12 := p7_a23;
194 ddp_deliv_kit_item_rec.attribute13 := p7_a24;
195 ddp_deliv_kit_item_rec.attribute14 := p7_a25;
196 ddp_deliv_kit_item_rec.attribute15 := p7_a26;
197
198 -- here's the delegated call to the old PL/SQL routine
199 ams_delivkititem_pvt.update_deliv_kit_item(p_api_version,
200 p_init_msg_list,
201 p_commit,
202 p_validation_level,
203 x_return_status,
204 x_msg_count,
205 x_msg_data,
206 ddp_deliv_kit_item_rec);
207
208 -- copy data back from the local OUT or IN-OUT args, if any
209
210
211
212
213
214
215
216 end;
217
218 procedure validate_deliv_kit_item(p_api_version NUMBER
219 , p_init_msg_list VARCHAR2
220 , p_validation_level NUMBER
221 , x_return_status OUT NOCOPY VARCHAR2
222 , x_msg_count OUT NOCOPY NUMBER
223 , x_msg_data OUT NOCOPY VARCHAR2
224 , p6_a0 NUMBER := 0-1962.0724
225 , p6_a1 DATE := fnd_api.g_miss_date
226 , p6_a2 NUMBER := 0-1962.0724
227 , p6_a3 DATE := fnd_api.g_miss_date
228 , p6_a4 NUMBER := 0-1962.0724
229 , p6_a5 NUMBER := 0-1962.0724
230 , p6_a6 NUMBER := 0-1962.0724
231 , p6_a7 NUMBER := 0-1962.0724
232 , p6_a8 NUMBER := 0-1962.0724
233 , p6_a9 NUMBER := 0-1962.0724
234 , p6_a10 NUMBER := 0-1962.0724
235 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
236 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
237 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
238 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
239 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
240 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
241 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
242 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
243 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
244 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
245 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
246 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
247 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
248 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
249 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
250 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
251 )
252 as
253 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
254 ddindx binary_integer; indx binary_integer;
255 begin
256
257 -- copy data to the local IN or IN-OUT args, if any
258
259
260
261
262
263
264 ddp_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p6_a0);
265 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
266 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
267 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
268 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p6_a4);
269 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
270 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
271 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p6_a7);
272 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p6_a8);
273 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p6_a9);
274 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p6_a10);
275 ddp_deliv_kit_item_rec.attribute_category := p6_a11;
276 ddp_deliv_kit_item_rec.attribute1 := p6_a12;
277 ddp_deliv_kit_item_rec.attribute2 := p6_a13;
278 ddp_deliv_kit_item_rec.attribute3 := p6_a14;
279 ddp_deliv_kit_item_rec.attribute4 := p6_a15;
280 ddp_deliv_kit_item_rec.attribute5 := p6_a16;
281 ddp_deliv_kit_item_rec.attribute6 := p6_a17;
282 ddp_deliv_kit_item_rec.attribute7 := p6_a18;
283 ddp_deliv_kit_item_rec.attribute8 := p6_a19;
284 ddp_deliv_kit_item_rec.attribute9 := p6_a20;
285 ddp_deliv_kit_item_rec.attribute10 := p6_a21;
286 ddp_deliv_kit_item_rec.attribute11 := p6_a22;
287 ddp_deliv_kit_item_rec.attribute12 := p6_a23;
288 ddp_deliv_kit_item_rec.attribute13 := p6_a24;
289 ddp_deliv_kit_item_rec.attribute14 := p6_a25;
290 ddp_deliv_kit_item_rec.attribute15 := p6_a26;
291
292 -- here's the delegated call to the old PL/SQL routine
293 ams_delivkititem_pvt.validate_deliv_kit_item(p_api_version,
294 p_init_msg_list,
295 p_validation_level,
296 x_return_status,
297 x_msg_count,
298 x_msg_data,
299 ddp_deliv_kit_item_rec);
300
301 -- copy data back from the local OUT or IN-OUT args, if any
302
303
304
305
306
307
308 end;
309
310 procedure check_deliv_kit_item_items(p_validation_mode VARCHAR2
311 , x_return_status OUT NOCOPY VARCHAR2
312 , p0_a0 NUMBER := 0-1962.0724
313 , p0_a1 DATE := fnd_api.g_miss_date
314 , p0_a2 NUMBER := 0-1962.0724
315 , p0_a3 DATE := fnd_api.g_miss_date
316 , p0_a4 NUMBER := 0-1962.0724
317 , p0_a5 NUMBER := 0-1962.0724
318 , p0_a6 NUMBER := 0-1962.0724
319 , p0_a7 NUMBER := 0-1962.0724
320 , p0_a8 NUMBER := 0-1962.0724
321 , p0_a9 NUMBER := 0-1962.0724
322 , p0_a10 NUMBER := 0-1962.0724
323 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
324 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
325 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
326 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
327 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
328 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
329 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
330 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
331 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
332 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
333 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
334 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
335 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
336 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
337 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
338 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
339 )
340 as
341 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
342 ddindx binary_integer; indx binary_integer;
343 begin
344
345 -- copy data to the local IN or IN-OUT args, if any
346 ddp_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p0_a0);
347 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
348 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
349 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
350 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p0_a4);
351 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
352 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
353 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p0_a7);
354 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p0_a8);
355 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p0_a9);
359 ddp_deliv_kit_item_rec.attribute2 := p0_a13;
356 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p0_a10);
357 ddp_deliv_kit_item_rec.attribute_category := p0_a11;
358 ddp_deliv_kit_item_rec.attribute1 := p0_a12;
360 ddp_deliv_kit_item_rec.attribute3 := p0_a14;
361 ddp_deliv_kit_item_rec.attribute4 := p0_a15;
362 ddp_deliv_kit_item_rec.attribute5 := p0_a16;
363 ddp_deliv_kit_item_rec.attribute6 := p0_a17;
364 ddp_deliv_kit_item_rec.attribute7 := p0_a18;
365 ddp_deliv_kit_item_rec.attribute8 := p0_a19;
366 ddp_deliv_kit_item_rec.attribute9 := p0_a20;
367 ddp_deliv_kit_item_rec.attribute10 := p0_a21;
368 ddp_deliv_kit_item_rec.attribute11 := p0_a22;
369 ddp_deliv_kit_item_rec.attribute12 := p0_a23;
370 ddp_deliv_kit_item_rec.attribute13 := p0_a24;
371 ddp_deliv_kit_item_rec.attribute14 := p0_a25;
372 ddp_deliv_kit_item_rec.attribute15 := p0_a26;
373
374
375
376 -- here's the delegated call to the old PL/SQL routine
377 ams_delivkititem_pvt.check_deliv_kit_item_items(ddp_deliv_kit_item_rec,
378 p_validation_mode,
379 x_return_status);
380
381 -- copy data back from the local OUT or IN-OUT args, if any
382
383
384 end;
385
386 procedure check_deliv_kit_item_record(x_return_status OUT NOCOPY VARCHAR2
387 , p0_a0 NUMBER := 0-1962.0724
388 , p0_a1 DATE := fnd_api.g_miss_date
389 , p0_a2 NUMBER := 0-1962.0724
390 , p0_a3 DATE := fnd_api.g_miss_date
391 , p0_a4 NUMBER := 0-1962.0724
392 , p0_a5 NUMBER := 0-1962.0724
393 , p0_a6 NUMBER := 0-1962.0724
394 , p0_a7 NUMBER := 0-1962.0724
395 , p0_a8 NUMBER := 0-1962.0724
396 , p0_a9 NUMBER := 0-1962.0724
397 , p0_a10 NUMBER := 0-1962.0724
398 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
399 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
400 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
401 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
402 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
403 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
404 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
405 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
406 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
407 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
408 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
409 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
410 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
411 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
412 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
413 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
414 , p1_a0 NUMBER := 0-1962.0724
415 , p1_a1 DATE := fnd_api.g_miss_date
416 , p1_a2 NUMBER := 0-1962.0724
417 , p1_a3 DATE := fnd_api.g_miss_date
418 , p1_a4 NUMBER := 0-1962.0724
419 , p1_a5 NUMBER := 0-1962.0724
420 , p1_a6 NUMBER := 0-1962.0724
421 , p1_a7 NUMBER := 0-1962.0724
422 , p1_a8 NUMBER := 0-1962.0724
423 , p1_a9 NUMBER := 0-1962.0724
424 , p1_a10 NUMBER := 0-1962.0724
425 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
426 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
427 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
428 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
429 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
430 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
431 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
432 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
433 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
434 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
435 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
436 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
437 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
438 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
439 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
440 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
441 )
442 as
443 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
444 ddp_complete_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
445 ddindx binary_integer; indx binary_integer;
446 begin
447
448 -- copy data to the local IN or IN-OUT args, if any
449 ddp_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p0_a0);
450 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
451 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
452 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
453 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p0_a4);
454 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
455 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
456 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p0_a7);
457 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p0_a8);
458 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p0_a9);
459 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p0_a10);
460 ddp_deliv_kit_item_rec.attribute_category := p0_a11;
461 ddp_deliv_kit_item_rec.attribute1 := p0_a12;
462 ddp_deliv_kit_item_rec.attribute2 := p0_a13;
463 ddp_deliv_kit_item_rec.attribute3 := p0_a14;
464 ddp_deliv_kit_item_rec.attribute4 := p0_a15;
465 ddp_deliv_kit_item_rec.attribute5 := p0_a16;
466 ddp_deliv_kit_item_rec.attribute6 := p0_a17;
467 ddp_deliv_kit_item_rec.attribute7 := p0_a18;
471 ddp_deliv_kit_item_rec.attribute11 := p0_a22;
468 ddp_deliv_kit_item_rec.attribute8 := p0_a19;
469 ddp_deliv_kit_item_rec.attribute9 := p0_a20;
470 ddp_deliv_kit_item_rec.attribute10 := p0_a21;
472 ddp_deliv_kit_item_rec.attribute12 := p0_a23;
473 ddp_deliv_kit_item_rec.attribute13 := p0_a24;
474 ddp_deliv_kit_item_rec.attribute14 := p0_a25;
475 ddp_deliv_kit_item_rec.attribute15 := p0_a26;
476
477 ddp_complete_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p1_a0);
478 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
479 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
480 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
481 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
482 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
483 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
484 ddp_complete_rec.deliverable_kit_id := rosetta_g_miss_num_map(p1_a7);
485 ddp_complete_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p1_a8);
486 ddp_complete_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p1_a9);
487 ddp_complete_rec.quantity := rosetta_g_miss_num_map(p1_a10);
488 ddp_complete_rec.attribute_category := p1_a11;
489 ddp_complete_rec.attribute1 := p1_a12;
490 ddp_complete_rec.attribute2 := p1_a13;
491 ddp_complete_rec.attribute3 := p1_a14;
492 ddp_complete_rec.attribute4 := p1_a15;
493 ddp_complete_rec.attribute5 := p1_a16;
494 ddp_complete_rec.attribute6 := p1_a17;
495 ddp_complete_rec.attribute7 := p1_a18;
496 ddp_complete_rec.attribute8 := p1_a19;
497 ddp_complete_rec.attribute9 := p1_a20;
498 ddp_complete_rec.attribute10 := p1_a21;
499 ddp_complete_rec.attribute11 := p1_a22;
500 ddp_complete_rec.attribute12 := p1_a23;
501 ddp_complete_rec.attribute13 := p1_a24;
502 ddp_complete_rec.attribute14 := p1_a25;
503 ddp_complete_rec.attribute15 := p1_a26;
504
505
506 -- here's the delegated call to the old PL/SQL routine
507 ams_delivkititem_pvt.check_deliv_kit_item_record(ddp_deliv_kit_item_rec,
508 ddp_complete_rec,
509 x_return_status);
510
511 -- copy data back from the local OUT or IN-OUT args, if any
512
513
514 end;
515
516 procedure init_deliv_kit_ite_rec(p0_a0 OUT NOCOPY NUMBER
517 , p0_a1 OUT NOCOPY DATE
518 , p0_a2 OUT NOCOPY NUMBER
519 , p0_a3 OUT NOCOPY DATE
520 , p0_a4 OUT NOCOPY NUMBER
521 , p0_a5 OUT NOCOPY NUMBER
522 , p0_a6 OUT NOCOPY NUMBER
523 , p0_a7 OUT NOCOPY NUMBER
524 , p0_a8 OUT NOCOPY NUMBER
525 , p0_a9 OUT NOCOPY NUMBER
526 , p0_a10 OUT NOCOPY NUMBER
527 , p0_a11 OUT NOCOPY VARCHAR2
528 , p0_a12 OUT NOCOPY VARCHAR2
529 , p0_a13 OUT NOCOPY VARCHAR2
530 , p0_a14 OUT NOCOPY VARCHAR2
531 , p0_a15 OUT NOCOPY VARCHAR2
532 , p0_a16 OUT NOCOPY VARCHAR2
533 , p0_a17 OUT NOCOPY VARCHAR2
534 , p0_a18 OUT NOCOPY VARCHAR2
535 , p0_a19 OUT NOCOPY VARCHAR2
536 , p0_a20 OUT NOCOPY VARCHAR2
537 , p0_a21 OUT NOCOPY VARCHAR2
538 , p0_a22 OUT NOCOPY VARCHAR2
539 , p0_a23 OUT NOCOPY VARCHAR2
540 , p0_a24 OUT NOCOPY VARCHAR2
541 , p0_a25 OUT NOCOPY VARCHAR2
542 , p0_a26 OUT NOCOPY VARCHAR2
543 )
544 as
545 ddx_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
546 ddindx binary_integer; indx binary_integer;
547 begin
548
549 -- copy data to the local IN or IN-OUT args, if any
550
551 -- here's the delegated call to the old PL/SQL routine
552 ams_delivkititem_pvt.init_deliv_kit_ite_rec(ddx_deliv_kit_item_rec);
553
554 -- copy data back from the local OUT or IN-OUT args, if any
555 p0_a0 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.deliverable_kit_item_id);
556 p0_a1 := ddx_deliv_kit_item_rec.last_update_date;
557 p0_a2 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.last_updated_by);
558 p0_a3 := ddx_deliv_kit_item_rec.creation_date;
559 p0_a4 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.created_by);
560 p0_a5 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.last_update_login);
561 p0_a6 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.object_version_number);
562 p0_a7 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.deliverable_kit_id);
563 p0_a8 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.deliverable_kit_part_id);
564 p0_a9 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.kit_part_included_from_kit_id);
565 p0_a10 := rosetta_g_miss_num_map(ddx_deliv_kit_item_rec.quantity);
566 p0_a11 := ddx_deliv_kit_item_rec.attribute_category;
567 p0_a12 := ddx_deliv_kit_item_rec.attribute1;
568 p0_a13 := ddx_deliv_kit_item_rec.attribute2;
569 p0_a14 := ddx_deliv_kit_item_rec.attribute3;
570 p0_a15 := ddx_deliv_kit_item_rec.attribute4;
571 p0_a16 := ddx_deliv_kit_item_rec.attribute5;
572 p0_a17 := ddx_deliv_kit_item_rec.attribute6;
573 p0_a18 := ddx_deliv_kit_item_rec.attribute7;
574 p0_a19 := ddx_deliv_kit_item_rec.attribute8;
575 p0_a20 := ddx_deliv_kit_item_rec.attribute9;
576 p0_a21 := ddx_deliv_kit_item_rec.attribute10;
577 p0_a22 := ddx_deliv_kit_item_rec.attribute11;
578 p0_a23 := ddx_deliv_kit_item_rec.attribute12;
579 p0_a24 := ddx_deliv_kit_item_rec.attribute13;
580 p0_a25 := ddx_deliv_kit_item_rec.attribute14;
584 procedure complete_deliv_kit_item_rec(p1_a0 OUT NOCOPY NUMBER
581 p0_a26 := ddx_deliv_kit_item_rec.attribute15;
582 end;
583
585 , p1_a1 OUT NOCOPY DATE
586 , p1_a2 OUT NOCOPY NUMBER
587 , p1_a3 OUT NOCOPY DATE
588 , p1_a4 OUT NOCOPY NUMBER
589 , p1_a5 OUT NOCOPY NUMBER
590 , p1_a6 OUT NOCOPY NUMBER
591 , p1_a7 OUT NOCOPY NUMBER
592 , p1_a8 OUT NOCOPY NUMBER
593 , p1_a9 OUT NOCOPY NUMBER
594 , p1_a10 OUT NOCOPY NUMBER
595 , p1_a11 OUT NOCOPY VARCHAR2
596 , p1_a12 OUT NOCOPY VARCHAR2
597 , p1_a13 OUT NOCOPY VARCHAR2
598 , p1_a14 OUT NOCOPY VARCHAR2
599 , p1_a15 OUT NOCOPY VARCHAR2
600 , p1_a16 OUT NOCOPY VARCHAR2
601 , p1_a17 OUT NOCOPY VARCHAR2
602 , p1_a18 OUT NOCOPY VARCHAR2
603 , p1_a19 OUT NOCOPY VARCHAR2
604 , p1_a20 OUT NOCOPY VARCHAR2
605 , p1_a21 OUT NOCOPY VARCHAR2
606 , p1_a22 OUT NOCOPY VARCHAR2
607 , p1_a23 OUT NOCOPY VARCHAR2
608 , p1_a24 OUT NOCOPY VARCHAR2
609 , p1_a25 OUT NOCOPY VARCHAR2
610 , p1_a26 OUT NOCOPY VARCHAR2
611 , p0_a0 NUMBER := 0-1962.0724
612 , p0_a1 DATE := fnd_api.g_miss_date
613 , p0_a2 NUMBER := 0-1962.0724
614 , p0_a3 DATE := fnd_api.g_miss_date
615 , p0_a4 NUMBER := 0-1962.0724
616 , p0_a5 NUMBER := 0-1962.0724
617 , p0_a6 NUMBER := 0-1962.0724
618 , p0_a7 NUMBER := 0-1962.0724
619 , p0_a8 NUMBER := 0-1962.0724
620 , p0_a9 NUMBER := 0-1962.0724
621 , p0_a10 NUMBER := 0-1962.0724
622 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
623 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
624 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
625 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
627 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
628 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
629 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
630 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
631 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
632 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
633 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
634 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
635 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
636 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
637 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
638 )
639 as
640 ddp_deliv_kit_item_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
641 ddx_complete_rec ams_delivkititem_pvt.deliv_kit_item_rec_type;
642 ddindx binary_integer; indx binary_integer;
643 begin
644
645 -- copy data to the local IN or IN-OUT args, if any
646 ddp_deliv_kit_item_rec.deliverable_kit_item_id := rosetta_g_miss_num_map(p0_a0);
647 ddp_deliv_kit_item_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
648 ddp_deliv_kit_item_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
649 ddp_deliv_kit_item_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
650 ddp_deliv_kit_item_rec.created_by := rosetta_g_miss_num_map(p0_a4);
651 ddp_deliv_kit_item_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
652 ddp_deliv_kit_item_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
653 ddp_deliv_kit_item_rec.deliverable_kit_id := rosetta_g_miss_num_map(p0_a7);
654 ddp_deliv_kit_item_rec.deliverable_kit_part_id := rosetta_g_miss_num_map(p0_a8);
655 ddp_deliv_kit_item_rec.kit_part_included_from_kit_id := rosetta_g_miss_num_map(p0_a9);
656 ddp_deliv_kit_item_rec.quantity := rosetta_g_miss_num_map(p0_a10);
657 ddp_deliv_kit_item_rec.attribute_category := p0_a11;
658 ddp_deliv_kit_item_rec.attribute1 := p0_a12;
659 ddp_deliv_kit_item_rec.attribute2 := p0_a13;
660 ddp_deliv_kit_item_rec.attribute3 := p0_a14;
661 ddp_deliv_kit_item_rec.attribute4 := p0_a15;
662 ddp_deliv_kit_item_rec.attribute5 := p0_a16;
663 ddp_deliv_kit_item_rec.attribute6 := p0_a17;
664 ddp_deliv_kit_item_rec.attribute7 := p0_a18;
665 ddp_deliv_kit_item_rec.attribute8 := p0_a19;
666 ddp_deliv_kit_item_rec.attribute9 := p0_a20;
667 ddp_deliv_kit_item_rec.attribute10 := p0_a21;
668 ddp_deliv_kit_item_rec.attribute11 := p0_a22;
669 ddp_deliv_kit_item_rec.attribute12 := p0_a23;
670 ddp_deliv_kit_item_rec.attribute13 := p0_a24;
671 ddp_deliv_kit_item_rec.attribute14 := p0_a25;
672 ddp_deliv_kit_item_rec.attribute15 := p0_a26;
673
674
675 -- here's the delegated call to the old PL/SQL routine
676 ams_delivkititem_pvt.complete_deliv_kit_item_rec(ddp_deliv_kit_item_rec,
677 ddx_complete_rec);
678
679 -- copy data back from the local OUT or IN-OUT args, if any
680
681 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.deliverable_kit_item_id);
682 p1_a1 := ddx_complete_rec.last_update_date;
683 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
684 p1_a3 := ddx_complete_rec.creation_date;
685 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
686 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
687 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
688 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.deliverable_kit_id);
689 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.deliverable_kit_part_id);
690 p1_a9 := rosetta_g_miss_num_map(ddx_complete_rec.kit_part_included_from_kit_id);
691 p1_a10 := rosetta_g_miss_num_map(ddx_complete_rec.quantity);
692 p1_a11 := ddx_complete_rec.attribute_category;
693 p1_a12 := ddx_complete_rec.attribute1;
694 p1_a13 := ddx_complete_rec.attribute2;
695 p1_a14 := ddx_complete_rec.attribute3;
696 p1_a15 := ddx_complete_rec.attribute4;
697 p1_a16 := ddx_complete_rec.attribute5;
698 p1_a17 := ddx_complete_rec.attribute6;
699 p1_a18 := ddx_complete_rec.attribute7;
700 p1_a19 := ddx_complete_rec.attribute8;
701 p1_a20 := ddx_complete_rec.attribute9;
702 p1_a21 := ddx_complete_rec.attribute10;
703 p1_a22 := ddx_complete_rec.attribute11;
704 p1_a23 := ddx_complete_rec.attribute12;
705 p1_a24 := ddx_complete_rec.attribute13;
706 p1_a25 := ddx_complete_rec.attribute14;
707 p1_a26 := ddx_complete_rec.attribute15;
708 end;
709
710 end ams_delivkititem_pvt_w;