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_metric_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_metric_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 NUMBER := 0-1962.0724
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 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
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 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 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 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 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 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 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 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 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 NUMBER := 0-1962.0724
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 NUMBER := 0-1962.0724
48: , p7_a18 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
48: , p7_a18 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
48: , p7_a18 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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
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 NUMBER := 0-1962.0724
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: )
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
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: )
62:
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
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: )
62:
63: as
56: , p7_a26 NUMBER := 0-1962.0724
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: )
62:
63: as
64: ddp_metric_rec ams_metric_pvt.metric_rec_type;
135: , x_return_status out nocopy VARCHAR2
136: , x_msg_count out nocopy NUMBER
137: , x_msg_data out nocopy VARCHAR2
138: , p7_a0 NUMBER := 0-1962.0724
139: , p7_a1 DATE := fnd_api.g_miss_date
140: , p7_a2 NUMBER := 0-1962.0724
141: , p7_a3 DATE := fnd_api.g_miss_date
142: , p7_a4 NUMBER := 0-1962.0724
143: , p7_a5 NUMBER := 0-1962.0724
137: , x_msg_data out nocopy VARCHAR2
138: , p7_a0 NUMBER := 0-1962.0724
139: , p7_a1 DATE := fnd_api.g_miss_date
140: , p7_a2 NUMBER := 0-1962.0724
141: , p7_a3 DATE := fnd_api.g_miss_date
142: , p7_a4 NUMBER := 0-1962.0724
143: , p7_a5 NUMBER := 0-1962.0724
144: , p7_a6 NUMBER := 0-1962.0724
145: , p7_a7 NUMBER := 0-1962.0724
142: , p7_a4 NUMBER := 0-1962.0724
143: , p7_a5 NUMBER := 0-1962.0724
144: , p7_a6 NUMBER := 0-1962.0724
145: , p7_a7 NUMBER := 0-1962.0724
146: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a5 NUMBER := 0-1962.0724
144: , p7_a6 NUMBER := 0-1962.0724
145: , p7_a7 NUMBER := 0-1962.0724
146: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a7 NUMBER := 0-1962.0724
146: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
146: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
148: , p7_a10 NUMBER := 0-1962.0724
149: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
156: , p7_a18 NUMBER := 0-1962.0724
150: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
156: , p7_a18 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a15 NUMBER := 0-1962.0724
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
156: , p7_a18 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
156: , p7_a18 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a17 NUMBER := 0-1962.0724
156: , p7_a18 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a18 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
157: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
169: )
162: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
169: )
170:
163: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
169: )
170:
171: as
164: , p7_a26 NUMBER := 0-1962.0724
165: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
169: )
170:
171: as
172: ddp_metric_rec ams_metric_pvt.metric_rec_type;
239: , x_return_status out nocopy VARCHAR2
240: , x_msg_count out nocopy NUMBER
241: , x_msg_data out nocopy VARCHAR2
242: , p6_a0 NUMBER := 0-1962.0724
243: , p6_a1 DATE := fnd_api.g_miss_date
244: , p6_a2 NUMBER := 0-1962.0724
245: , p6_a3 DATE := fnd_api.g_miss_date
246: , p6_a4 NUMBER := 0-1962.0724
247: , p6_a5 NUMBER := 0-1962.0724
241: , x_msg_data out nocopy VARCHAR2
242: , p6_a0 NUMBER := 0-1962.0724
243: , p6_a1 DATE := fnd_api.g_miss_date
244: , p6_a2 NUMBER := 0-1962.0724
245: , p6_a3 DATE := fnd_api.g_miss_date
246: , p6_a4 NUMBER := 0-1962.0724
247: , p6_a5 NUMBER := 0-1962.0724
248: , p6_a6 NUMBER := 0-1962.0724
249: , p6_a7 NUMBER := 0-1962.0724
246: , p6_a4 NUMBER := 0-1962.0724
247: , p6_a5 NUMBER := 0-1962.0724
248: , p6_a6 NUMBER := 0-1962.0724
249: , p6_a7 NUMBER := 0-1962.0724
250: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
247: , p6_a5 NUMBER := 0-1962.0724
248: , p6_a6 NUMBER := 0-1962.0724
249: , p6_a7 NUMBER := 0-1962.0724
250: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a7 NUMBER := 0-1962.0724
250: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
250: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
252: , p6_a10 NUMBER := 0-1962.0724
253: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
260: , p6_a18 NUMBER := 0-1962.0724
254: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
260: , p6_a18 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a15 NUMBER := 0-1962.0724
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
260: , p6_a18 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
260: , p6_a18 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a17 NUMBER := 0-1962.0724
260: , p6_a18 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a18 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
261: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
273: )
266: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
273: )
274:
267: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
273: )
274:
275: as
268: , p6_a26 NUMBER := 0-1962.0724
269: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
273: )
274:
275: as
276: ddp_metric_rec ams_metric_pvt.metric_rec_type;
336:
337: procedure validate_metric_items(p_validation_mode VARCHAR2
338: , x_return_status out nocopy VARCHAR2
339: , p0_a0 NUMBER := 0-1962.0724
340: , p0_a1 DATE := fnd_api.g_miss_date
341: , p0_a2 NUMBER := 0-1962.0724
342: , p0_a3 DATE := fnd_api.g_miss_date
343: , p0_a4 NUMBER := 0-1962.0724
344: , p0_a5 NUMBER := 0-1962.0724
338: , x_return_status out nocopy VARCHAR2
339: , p0_a0 NUMBER := 0-1962.0724
340: , p0_a1 DATE := fnd_api.g_miss_date
341: , p0_a2 NUMBER := 0-1962.0724
342: , p0_a3 DATE := fnd_api.g_miss_date
343: , p0_a4 NUMBER := 0-1962.0724
344: , p0_a5 NUMBER := 0-1962.0724
345: , p0_a6 NUMBER := 0-1962.0724
346: , p0_a7 NUMBER := 0-1962.0724
343: , p0_a4 NUMBER := 0-1962.0724
344: , p0_a5 NUMBER := 0-1962.0724
345: , p0_a6 NUMBER := 0-1962.0724
346: , p0_a7 NUMBER := 0-1962.0724
347: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a5 NUMBER := 0-1962.0724
345: , p0_a6 NUMBER := 0-1962.0724
346: , p0_a7 NUMBER := 0-1962.0724
347: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
346: , p0_a7 NUMBER := 0-1962.0724
347: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
347: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
348: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
349: , p0_a10 NUMBER := 0-1962.0724
350: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
357: , p0_a18 NUMBER := 0-1962.0724
351: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
352: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
357: , p0_a18 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
354: , p0_a15 NUMBER := 0-1962.0724
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
357: , p0_a18 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
357: , p0_a18 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a17 NUMBER := 0-1962.0724
357: , p0_a18 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
357: , p0_a18 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
358: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
359: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
370: )
363: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
370: )
371:
364: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
370: )
371:
372: as
365: , p0_a26 NUMBER := 0-1962.0724
366: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
370: )
371:
372: as
373: ddp_metric_rec ams_metric_pvt.metric_rec_type;
420: end;
421:
422: procedure validate_metric_record(x_return_status out nocopy VARCHAR2
423: , p0_a0 NUMBER := 0-1962.0724
424: , p0_a1 DATE := fnd_api.g_miss_date
425: , p0_a2 NUMBER := 0-1962.0724
426: , p0_a3 DATE := fnd_api.g_miss_date
427: , p0_a4 NUMBER := 0-1962.0724
428: , p0_a5 NUMBER := 0-1962.0724
422: procedure validate_metric_record(x_return_status out nocopy VARCHAR2
423: , p0_a0 NUMBER := 0-1962.0724
424: , p0_a1 DATE := fnd_api.g_miss_date
425: , p0_a2 NUMBER := 0-1962.0724
426: , p0_a3 DATE := fnd_api.g_miss_date
427: , p0_a4 NUMBER := 0-1962.0724
428: , p0_a5 NUMBER := 0-1962.0724
429: , p0_a6 NUMBER := 0-1962.0724
430: , p0_a7 NUMBER := 0-1962.0724
427: , p0_a4 NUMBER := 0-1962.0724
428: , p0_a5 NUMBER := 0-1962.0724
429: , p0_a6 NUMBER := 0-1962.0724
430: , p0_a7 NUMBER := 0-1962.0724
431: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
428: , p0_a5 NUMBER := 0-1962.0724
429: , p0_a6 NUMBER := 0-1962.0724
430: , p0_a7 NUMBER := 0-1962.0724
431: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
430: , p0_a7 NUMBER := 0-1962.0724
431: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
431: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
432: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
433: , p0_a10 NUMBER := 0-1962.0724
434: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
441: , p0_a18 NUMBER := 0-1962.0724
435: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
437: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
441: , p0_a18 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
438: , p0_a15 NUMBER := 0-1962.0724
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
441: , p0_a18 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
439: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
441: , p0_a18 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
440: , p0_a17 NUMBER := 0-1962.0724
441: , p0_a18 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a18 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
442: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
447: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
455: , p1_a1 DATE := fnd_api.g_miss_date
448: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
455: , p1_a1 DATE := fnd_api.g_miss_date
456: , p1_a2 NUMBER := 0-1962.0724
449: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
455: , p1_a1 DATE := fnd_api.g_miss_date
456: , p1_a2 NUMBER := 0-1962.0724
457: , p1_a3 DATE := fnd_api.g_miss_date
451: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
455: , p1_a1 DATE := fnd_api.g_miss_date
456: , p1_a2 NUMBER := 0-1962.0724
457: , p1_a3 DATE := fnd_api.g_miss_date
458: , p1_a4 NUMBER := 0-1962.0724
459: , p1_a5 NUMBER := 0-1962.0724
453: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
454: , p1_a0 NUMBER := 0-1962.0724
455: , p1_a1 DATE := fnd_api.g_miss_date
456: , p1_a2 NUMBER := 0-1962.0724
457: , p1_a3 DATE := fnd_api.g_miss_date
458: , p1_a4 NUMBER := 0-1962.0724
459: , p1_a5 NUMBER := 0-1962.0724
460: , p1_a6 NUMBER := 0-1962.0724
461: , p1_a7 NUMBER := 0-1962.0724
458: , p1_a4 NUMBER := 0-1962.0724
459: , p1_a5 NUMBER := 0-1962.0724
460: , p1_a6 NUMBER := 0-1962.0724
461: , p1_a7 NUMBER := 0-1962.0724
462: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
459: , p1_a5 NUMBER := 0-1962.0724
460: , p1_a6 NUMBER := 0-1962.0724
461: , p1_a7 NUMBER := 0-1962.0724
462: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
461: , p1_a7 NUMBER := 0-1962.0724
462: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
468: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
462: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
468: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
468: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
464: , p1_a10 NUMBER := 0-1962.0724
465: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
468: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
472: , p1_a18 NUMBER := 0-1962.0724
466: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
467: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
468: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
472: , p1_a18 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
469: , p1_a15 NUMBER := 0-1962.0724
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
472: , p1_a18 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
470: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
472: , p1_a18 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a17 NUMBER := 0-1962.0724
472: , p1_a18 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
472: , p1_a18 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
473: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
477: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
485: )
478: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
485: )
486:
479: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
485: )
486:
487: as
480: , p1_a26 NUMBER := 0-1962.0724
481: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
483: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
485: )
486:
487: as
488: ddp_metric_rec ams_metric_pvt.metric_rec_type;