eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.AMS_ACTPRODUCT_PVT_W

Source


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