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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;