5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , x_act_mks_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_mks_id out nocopy NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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: )
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: )
60:
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: )
60:
61: as
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: )
60:
61: as
62: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
131: , x_return_status out nocopy VARCHAR2
132: , x_msg_count out nocopy NUMBER
133: , x_msg_data out nocopy VARCHAR2
134: , p7_a0 NUMBER := 0-1962.0724
135: , p7_a1 DATE := fnd_api.g_miss_date
136: , p7_a2 NUMBER := 0-1962.0724
137: , p7_a3 DATE := fnd_api.g_miss_date
138: , p7_a4 NUMBER := 0-1962.0724
139: , p7_a5 NUMBER := 0-1962.0724
133: , x_msg_data out nocopy VARCHAR2
134: , p7_a0 NUMBER := 0-1962.0724
135: , p7_a1 DATE := fnd_api.g_miss_date
136: , p7_a2 NUMBER := 0-1962.0724
137: , p7_a3 DATE := fnd_api.g_miss_date
138: , p7_a4 NUMBER := 0-1962.0724
139: , p7_a5 NUMBER := 0-1962.0724
140: , p7_a6 NUMBER := 0-1962.0724
141: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a3 DATE := fnd_api.g_miss_date
138: , p7_a4 NUMBER := 0-1962.0724
139: , p7_a5 NUMBER := 0-1962.0724
140: , p7_a6 NUMBER := 0-1962.0724
141: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a9 NUMBER := 0-1962.0724
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a4 NUMBER := 0-1962.0724
139: , p7_a5 NUMBER := 0-1962.0724
140: , p7_a6 NUMBER := 0-1962.0724
141: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a9 NUMBER := 0-1962.0724
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a9 NUMBER := 0-1962.0724
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a9 NUMBER := 0-1962.0724
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a9 NUMBER := 0-1962.0724
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a10 NUMBER := 0-1962.0724
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
163: )
156: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
163: )
164:
157: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
163: )
164:
165: as
158: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
163: )
164:
165: as
166: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
231: , x_return_status out nocopy VARCHAR2
232: , x_msg_count out nocopy NUMBER
233: , x_msg_data out nocopy VARCHAR2
234: , p6_a0 NUMBER := 0-1962.0724
235: , p6_a1 DATE := fnd_api.g_miss_date
236: , p6_a2 NUMBER := 0-1962.0724
237: , p6_a3 DATE := fnd_api.g_miss_date
238: , p6_a4 NUMBER := 0-1962.0724
239: , p6_a5 NUMBER := 0-1962.0724
233: , x_msg_data out nocopy VARCHAR2
234: , p6_a0 NUMBER := 0-1962.0724
235: , p6_a1 DATE := fnd_api.g_miss_date
236: , p6_a2 NUMBER := 0-1962.0724
237: , p6_a3 DATE := fnd_api.g_miss_date
238: , p6_a4 NUMBER := 0-1962.0724
239: , p6_a5 NUMBER := 0-1962.0724
240: , p6_a6 NUMBER := 0-1962.0724
241: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
237: , p6_a3 DATE := fnd_api.g_miss_date
238: , p6_a4 NUMBER := 0-1962.0724
239: , p6_a5 NUMBER := 0-1962.0724
240: , p6_a6 NUMBER := 0-1962.0724
241: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a9 NUMBER := 0-1962.0724
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
238: , p6_a4 NUMBER := 0-1962.0724
239: , p6_a5 NUMBER := 0-1962.0724
240: , p6_a6 NUMBER := 0-1962.0724
241: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a9 NUMBER := 0-1962.0724
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p6_a7 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a9 NUMBER := 0-1962.0724
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a9 NUMBER := 0-1962.0724
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a9 NUMBER := 0-1962.0724
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
244: , p6_a10 NUMBER := 0-1962.0724
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
263: )
256: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
257: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
265: as
258: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
263: )
264:
265: as
266: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
324:
325: procedure check_mks_items(p_validation_mode VARCHAR2
326: , x_return_status out nocopy VARCHAR2
327: , p0_a0 NUMBER := 0-1962.0724
328: , p0_a1 DATE := fnd_api.g_miss_date
329: , p0_a2 NUMBER := 0-1962.0724
330: , p0_a3 DATE := fnd_api.g_miss_date
331: , p0_a4 NUMBER := 0-1962.0724
332: , p0_a5 NUMBER := 0-1962.0724
326: , x_return_status out nocopy VARCHAR2
327: , p0_a0 NUMBER := 0-1962.0724
328: , p0_a1 DATE := fnd_api.g_miss_date
329: , p0_a2 NUMBER := 0-1962.0724
330: , p0_a3 DATE := fnd_api.g_miss_date
331: , p0_a4 NUMBER := 0-1962.0724
332: , p0_a5 NUMBER := 0-1962.0724
333: , p0_a6 NUMBER := 0-1962.0724
334: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
330: , p0_a3 DATE := fnd_api.g_miss_date
331: , p0_a4 NUMBER := 0-1962.0724
332: , p0_a5 NUMBER := 0-1962.0724
333: , p0_a6 NUMBER := 0-1962.0724
334: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
335: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a9 NUMBER := 0-1962.0724
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
331: , p0_a4 NUMBER := 0-1962.0724
332: , p0_a5 NUMBER := 0-1962.0724
333: , p0_a6 NUMBER := 0-1962.0724
334: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
335: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a9 NUMBER := 0-1962.0724
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
334: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
335: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a9 NUMBER := 0-1962.0724
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
335: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a9 NUMBER := 0-1962.0724
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
336: , p0_a9 NUMBER := 0-1962.0724
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
337: , p0_a10 NUMBER := 0-1962.0724
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
345: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
347: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
356: )
349: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
356: )
357:
350: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
356: )
357:
358: as
351: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
356: )
357:
358: as
359: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
405:
406: procedure validate_cross_ent_rec(p_validation_mode VARCHAR2
407: , x_return_status out nocopy VARCHAR2
408: , p0_a0 NUMBER := 0-1962.0724
409: , p0_a1 DATE := fnd_api.g_miss_date
410: , p0_a2 NUMBER := 0-1962.0724
411: , p0_a3 DATE := fnd_api.g_miss_date
412: , p0_a4 NUMBER := 0-1962.0724
413: , p0_a5 NUMBER := 0-1962.0724
407: , x_return_status out nocopy VARCHAR2
408: , p0_a0 NUMBER := 0-1962.0724
409: , p0_a1 DATE := fnd_api.g_miss_date
410: , p0_a2 NUMBER := 0-1962.0724
411: , p0_a3 DATE := fnd_api.g_miss_date
412: , p0_a4 NUMBER := 0-1962.0724
413: , p0_a5 NUMBER := 0-1962.0724
414: , p0_a6 NUMBER := 0-1962.0724
415: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
411: , p0_a3 DATE := fnd_api.g_miss_date
412: , p0_a4 NUMBER := 0-1962.0724
413: , p0_a5 NUMBER := 0-1962.0724
414: , p0_a6 NUMBER := 0-1962.0724
415: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a9 NUMBER := 0-1962.0724
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
412: , p0_a4 NUMBER := 0-1962.0724
413: , p0_a5 NUMBER := 0-1962.0724
414: , p0_a6 NUMBER := 0-1962.0724
415: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a9 NUMBER := 0-1962.0724
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
415: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a9 NUMBER := 0-1962.0724
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
416: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a9 NUMBER := 0-1962.0724
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
417: , p0_a9 NUMBER := 0-1962.0724
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
418: , p0_a10 NUMBER := 0-1962.0724
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
419: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
420: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
421: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
422: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
423: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
424: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
425: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
427: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
429: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
430: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
438: , p1_a1 DATE := fnd_api.g_miss_date
431: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
438: , p1_a1 DATE := fnd_api.g_miss_date
439: , p1_a2 NUMBER := 0-1962.0724
432: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
438: , p1_a1 DATE := fnd_api.g_miss_date
439: , p1_a2 NUMBER := 0-1962.0724
440: , p1_a3 DATE := fnd_api.g_miss_date
434: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
438: , p1_a1 DATE := fnd_api.g_miss_date
439: , p1_a2 NUMBER := 0-1962.0724
440: , p1_a3 DATE := fnd_api.g_miss_date
441: , p1_a4 NUMBER := 0-1962.0724
442: , p1_a5 NUMBER := 0-1962.0724
436: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a0 NUMBER := 0-1962.0724
438: , p1_a1 DATE := fnd_api.g_miss_date
439: , p1_a2 NUMBER := 0-1962.0724
440: , p1_a3 DATE := fnd_api.g_miss_date
441: , p1_a4 NUMBER := 0-1962.0724
442: , p1_a5 NUMBER := 0-1962.0724
443: , p1_a6 NUMBER := 0-1962.0724
444: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a3 DATE := fnd_api.g_miss_date
441: , p1_a4 NUMBER := 0-1962.0724
442: , p1_a5 NUMBER := 0-1962.0724
443: , p1_a6 NUMBER := 0-1962.0724
444: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a9 NUMBER := 0-1962.0724
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a4 NUMBER := 0-1962.0724
442: , p1_a5 NUMBER := 0-1962.0724
443: , p1_a6 NUMBER := 0-1962.0724
444: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a9 NUMBER := 0-1962.0724
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a9 NUMBER := 0-1962.0724
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a9 NUMBER := 0-1962.0724
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a9 NUMBER := 0-1962.0724
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a10 NUMBER := 0-1962.0724
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
451: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
452: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
453: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
455: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
456: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
457: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
458: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
466: )
459: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
466: )
467:
460: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
466: )
467:
468: as
461: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
462: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
465: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
466: )
467:
468: as
469: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
547: end;
548:
549: procedure check_mks_record(x_return_status out nocopy VARCHAR2
550: , p0_a0 NUMBER := 0-1962.0724
551: , p0_a1 DATE := fnd_api.g_miss_date
552: , p0_a2 NUMBER := 0-1962.0724
553: , p0_a3 DATE := fnd_api.g_miss_date
554: , p0_a4 NUMBER := 0-1962.0724
555: , p0_a5 NUMBER := 0-1962.0724
549: procedure check_mks_record(x_return_status out nocopy VARCHAR2
550: , p0_a0 NUMBER := 0-1962.0724
551: , p0_a1 DATE := fnd_api.g_miss_date
552: , p0_a2 NUMBER := 0-1962.0724
553: , p0_a3 DATE := fnd_api.g_miss_date
554: , p0_a4 NUMBER := 0-1962.0724
555: , p0_a5 NUMBER := 0-1962.0724
556: , p0_a6 NUMBER := 0-1962.0724
557: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
553: , p0_a3 DATE := fnd_api.g_miss_date
554: , p0_a4 NUMBER := 0-1962.0724
555: , p0_a5 NUMBER := 0-1962.0724
556: , p0_a6 NUMBER := 0-1962.0724
557: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a9 NUMBER := 0-1962.0724
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a4 NUMBER := 0-1962.0724
555: , p0_a5 NUMBER := 0-1962.0724
556: , p0_a6 NUMBER := 0-1962.0724
557: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a9 NUMBER := 0-1962.0724
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a9 NUMBER := 0-1962.0724
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a9 NUMBER := 0-1962.0724
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a9 NUMBER := 0-1962.0724
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a10 NUMBER := 0-1962.0724
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
561: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
563: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
566: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
567: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
568: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
569: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
570: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
571: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
572: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
580: , p1_a1 DATE := fnd_api.g_miss_date
573: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
580: , p1_a1 DATE := fnd_api.g_miss_date
581: , p1_a2 NUMBER := 0-1962.0724
574: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
575: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
580: , p1_a1 DATE := fnd_api.g_miss_date
581: , p1_a2 NUMBER := 0-1962.0724
582: , p1_a3 DATE := fnd_api.g_miss_date
576: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
577: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
580: , p1_a1 DATE := fnd_api.g_miss_date
581: , p1_a2 NUMBER := 0-1962.0724
582: , p1_a3 DATE := fnd_api.g_miss_date
583: , p1_a4 NUMBER := 0-1962.0724
584: , p1_a5 NUMBER := 0-1962.0724
578: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
579: , p1_a0 NUMBER := 0-1962.0724
580: , p1_a1 DATE := fnd_api.g_miss_date
581: , p1_a2 NUMBER := 0-1962.0724
582: , p1_a3 DATE := fnd_api.g_miss_date
583: , p1_a4 NUMBER := 0-1962.0724
584: , p1_a5 NUMBER := 0-1962.0724
585: , p1_a6 NUMBER := 0-1962.0724
586: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
582: , p1_a3 DATE := fnd_api.g_miss_date
583: , p1_a4 NUMBER := 0-1962.0724
584: , p1_a5 NUMBER := 0-1962.0724
585: , p1_a6 NUMBER := 0-1962.0724
586: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
587: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p1_a9 NUMBER := 0-1962.0724
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
583: , p1_a4 NUMBER := 0-1962.0724
584: , p1_a5 NUMBER := 0-1962.0724
585: , p1_a6 NUMBER := 0-1962.0724
586: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
587: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p1_a9 NUMBER := 0-1962.0724
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
586: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
587: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p1_a9 NUMBER := 0-1962.0724
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
587: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
588: , p1_a9 NUMBER := 0-1962.0724
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
588: , p1_a9 NUMBER := 0-1962.0724
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
589: , p1_a10 NUMBER := 0-1962.0724
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
590: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
591: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
592: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
593: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
594: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
595: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
596: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
608: )
601: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
608: )
609:
602: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
608: )
609:
610: as
603: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
608: )
609:
610: as
611: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;
787: , p1_a26 out nocopy VARCHAR2
788: , p1_a27 out nocopy VARCHAR2
789: , p1_a28 out nocopy VARCHAR2
790: , p0_a0 NUMBER := 0-1962.0724
791: , p0_a1 DATE := fnd_api.g_miss_date
792: , p0_a2 NUMBER := 0-1962.0724
793: , p0_a3 DATE := fnd_api.g_miss_date
794: , p0_a4 NUMBER := 0-1962.0724
795: , p0_a5 NUMBER := 0-1962.0724
789: , p1_a28 out nocopy VARCHAR2
790: , p0_a0 NUMBER := 0-1962.0724
791: , p0_a1 DATE := fnd_api.g_miss_date
792: , p0_a2 NUMBER := 0-1962.0724
793: , p0_a3 DATE := fnd_api.g_miss_date
794: , p0_a4 NUMBER := 0-1962.0724
795: , p0_a5 NUMBER := 0-1962.0724
796: , p0_a6 NUMBER := 0-1962.0724
797: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a3 DATE := fnd_api.g_miss_date
794: , p0_a4 NUMBER := 0-1962.0724
795: , p0_a5 NUMBER := 0-1962.0724
796: , p0_a6 NUMBER := 0-1962.0724
797: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
798: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a9 NUMBER := 0-1962.0724
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
794: , p0_a4 NUMBER := 0-1962.0724
795: , p0_a5 NUMBER := 0-1962.0724
796: , p0_a6 NUMBER := 0-1962.0724
797: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
798: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a9 NUMBER := 0-1962.0724
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
797: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
798: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a9 NUMBER := 0-1962.0724
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
798: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a9 NUMBER := 0-1962.0724
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a9 NUMBER := 0-1962.0724
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
800: , p0_a10 NUMBER := 0-1962.0724
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
801: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
802: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
807: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
808: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
809: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
810: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
811: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
819: )
812: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
819: )
820:
813: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
819: )
820:
821: as
814: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
819: )
820:
821: as
822: ddp_mks_rec ams_act_market_segments_pvt.mks_rec_type;