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_trigger_check_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_trigger_check_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
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
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
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
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 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 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 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724
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 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 NUMBER := 0-1962.0724
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 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 NUMBER := 0-1962.0724
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
50: , p7_a20 NUMBER := 0-1962.0724
51: , p7_a21 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 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 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 NUMBER := 0-1962.0724
57: , p7_a27 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
56: , p7_a26 NUMBER := 0-1962.0724
57: , p7_a27 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
64: as
57: , p7_a27 NUMBER := 0-1962.0724
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
64: as
65: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
137: , x_return_status out nocopy VARCHAR2
138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p7_a0 NUMBER := 0-1962.0724
141: , p7_a1 DATE := fnd_api.g_miss_date
142: , p7_a2 NUMBER := 0-1962.0724
143: , p7_a3 DATE := fnd_api.g_miss_date
144: , p7_a4 NUMBER := 0-1962.0724
145: , p7_a5 NUMBER := 0-1962.0724
139: , x_msg_data out nocopy VARCHAR2
140: , p7_a0 NUMBER := 0-1962.0724
141: , p7_a1 DATE := fnd_api.g_miss_date
142: , p7_a2 NUMBER := 0-1962.0724
143: , p7_a3 DATE := fnd_api.g_miss_date
144: , p7_a4 NUMBER := 0-1962.0724
145: , p7_a5 NUMBER := 0-1962.0724
146: , p7_a6 NUMBER := 0-1962.0724
147: , p7_a7 NUMBER := 0-1962.0724
145: , p7_a5 NUMBER := 0-1962.0724
146: , p7_a6 NUMBER := 0-1962.0724
147: , p7_a7 NUMBER := 0-1962.0724
148: , p7_a8 NUMBER := 0-1962.0724
149: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a13 NUMBER := 0-1962.0724
146: , p7_a6 NUMBER := 0-1962.0724
147: , p7_a7 NUMBER := 0-1962.0724
148: , p7_a8 NUMBER := 0-1962.0724
149: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a13 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a8 NUMBER := 0-1962.0724
149: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a13 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a15 NUMBER := 0-1962.0724
156: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a13 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a15 NUMBER := 0-1962.0724
156: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a13 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a15 NUMBER := 0-1962.0724
156: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a19 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
153: , p7_a13 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a15 NUMBER := 0-1962.0724
156: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a19 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
161: , p7_a21 NUMBER := 0-1962.0724
154: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a15 NUMBER := 0-1962.0724
156: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a19 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
161: , p7_a21 NUMBER := 0-1962.0724
162: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a19 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
161: , p7_a21 NUMBER := 0-1962.0724
162: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
159: , p7_a19 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
161: , p7_a21 NUMBER := 0-1962.0724
162: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
160: , p7_a20 NUMBER := 0-1962.0724
161: , p7_a21 NUMBER := 0-1962.0724
162: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a21 NUMBER := 0-1962.0724
162: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172: )
165: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172: )
173:
166: , p7_a26 NUMBER := 0-1962.0724
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172: )
173:
174: as
167: , p7_a27 NUMBER := 0-1962.0724
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172: )
173:
174: as
175: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
243: , x_return_status out nocopy VARCHAR2
244: , x_msg_count out nocopy NUMBER
245: , x_msg_data out nocopy VARCHAR2
246: , p6_a0 NUMBER := 0-1962.0724
247: , p6_a1 DATE := fnd_api.g_miss_date
248: , p6_a2 NUMBER := 0-1962.0724
249: , p6_a3 DATE := fnd_api.g_miss_date
250: , p6_a4 NUMBER := 0-1962.0724
251: , p6_a5 NUMBER := 0-1962.0724
245: , x_msg_data out nocopy VARCHAR2
246: , p6_a0 NUMBER := 0-1962.0724
247: , p6_a1 DATE := fnd_api.g_miss_date
248: , p6_a2 NUMBER := 0-1962.0724
249: , p6_a3 DATE := fnd_api.g_miss_date
250: , p6_a4 NUMBER := 0-1962.0724
251: , p6_a5 NUMBER := 0-1962.0724
252: , p6_a6 NUMBER := 0-1962.0724
253: , p6_a7 NUMBER := 0-1962.0724
251: , p6_a5 NUMBER := 0-1962.0724
252: , p6_a6 NUMBER := 0-1962.0724
253: , p6_a7 NUMBER := 0-1962.0724
254: , p6_a8 NUMBER := 0-1962.0724
255: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a13 NUMBER := 0-1962.0724
252: , p6_a6 NUMBER := 0-1962.0724
253: , p6_a7 NUMBER := 0-1962.0724
254: , p6_a8 NUMBER := 0-1962.0724
255: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a13 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a8 NUMBER := 0-1962.0724
255: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a13 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a15 NUMBER := 0-1962.0724
262: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a13 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a15 NUMBER := 0-1962.0724
262: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a13 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a15 NUMBER := 0-1962.0724
262: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a19 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
259: , p6_a13 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a15 NUMBER := 0-1962.0724
262: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a19 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
267: , p6_a21 NUMBER := 0-1962.0724
260: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a15 NUMBER := 0-1962.0724
262: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a19 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
267: , p6_a21 NUMBER := 0-1962.0724
268: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a19 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
267: , p6_a21 NUMBER := 0-1962.0724
268: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
265: , p6_a19 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
267: , p6_a21 NUMBER := 0-1962.0724
268: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
266: , p6_a20 NUMBER := 0-1962.0724
267: , p6_a21 NUMBER := 0-1962.0724
268: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a21 NUMBER := 0-1962.0724
268: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278: )
271: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278: )
279:
272: , p6_a26 NUMBER := 0-1962.0724
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278: )
279:
280: as
273: , p6_a27 NUMBER := 0-1962.0724
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278: )
279:
280: as
281: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
342:
343: procedure check_thldchk_items(p_validation_mode VARCHAR2
344: , x_return_status out nocopy VARCHAR2
345: , p0_a0 NUMBER := 0-1962.0724
346: , p0_a1 DATE := fnd_api.g_miss_date
347: , p0_a2 NUMBER := 0-1962.0724
348: , p0_a3 DATE := fnd_api.g_miss_date
349: , p0_a4 NUMBER := 0-1962.0724
350: , p0_a5 NUMBER := 0-1962.0724
344: , x_return_status out nocopy VARCHAR2
345: , p0_a0 NUMBER := 0-1962.0724
346: , p0_a1 DATE := fnd_api.g_miss_date
347: , p0_a2 NUMBER := 0-1962.0724
348: , p0_a3 DATE := fnd_api.g_miss_date
349: , p0_a4 NUMBER := 0-1962.0724
350: , p0_a5 NUMBER := 0-1962.0724
351: , p0_a6 NUMBER := 0-1962.0724
352: , p0_a7 NUMBER := 0-1962.0724
350: , p0_a5 NUMBER := 0-1962.0724
351: , p0_a6 NUMBER := 0-1962.0724
352: , p0_a7 NUMBER := 0-1962.0724
353: , p0_a8 NUMBER := 0-1962.0724
354: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a13 NUMBER := 0-1962.0724
351: , p0_a6 NUMBER := 0-1962.0724
352: , p0_a7 NUMBER := 0-1962.0724
353: , p0_a8 NUMBER := 0-1962.0724
354: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a13 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p0_a8 NUMBER := 0-1962.0724
354: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a13 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a15 NUMBER := 0-1962.0724
361: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a13 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a15 NUMBER := 0-1962.0724
361: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
358: , p0_a13 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a15 NUMBER := 0-1962.0724
361: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a19 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
358: , p0_a13 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a15 NUMBER := 0-1962.0724
361: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a19 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
366: , p0_a21 NUMBER := 0-1962.0724
359: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
360: , p0_a15 NUMBER := 0-1962.0724
361: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
362: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a19 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
366: , p0_a21 NUMBER := 0-1962.0724
367: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a19 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
366: , p0_a21 NUMBER := 0-1962.0724
367: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
364: , p0_a19 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
366: , p0_a21 NUMBER := 0-1962.0724
367: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
365: , p0_a20 NUMBER := 0-1962.0724
366: , p0_a21 NUMBER := 0-1962.0724
367: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a21 NUMBER := 0-1962.0724
367: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377: )
370: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377: )
378:
371: , p0_a26 NUMBER := 0-1962.0724
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377: )
378:
379: as
372: , p0_a27 NUMBER := 0-1962.0724
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377: )
378:
379: as
380: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
428: end;
429:
430: procedure check_thldchk_record(x_return_status out nocopy VARCHAR2
431: , p0_a0 NUMBER := 0-1962.0724
432: , p0_a1 DATE := fnd_api.g_miss_date
433: , p0_a2 NUMBER := 0-1962.0724
434: , p0_a3 DATE := fnd_api.g_miss_date
435: , p0_a4 NUMBER := 0-1962.0724
436: , p0_a5 NUMBER := 0-1962.0724
430: procedure check_thldchk_record(x_return_status out nocopy VARCHAR2
431: , p0_a0 NUMBER := 0-1962.0724
432: , p0_a1 DATE := fnd_api.g_miss_date
433: , p0_a2 NUMBER := 0-1962.0724
434: , p0_a3 DATE := fnd_api.g_miss_date
435: , p0_a4 NUMBER := 0-1962.0724
436: , p0_a5 NUMBER := 0-1962.0724
437: , p0_a6 NUMBER := 0-1962.0724
438: , p0_a7 NUMBER := 0-1962.0724
436: , p0_a5 NUMBER := 0-1962.0724
437: , p0_a6 NUMBER := 0-1962.0724
438: , p0_a7 NUMBER := 0-1962.0724
439: , p0_a8 NUMBER := 0-1962.0724
440: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a13 NUMBER := 0-1962.0724
437: , p0_a6 NUMBER := 0-1962.0724
438: , p0_a7 NUMBER := 0-1962.0724
439: , p0_a8 NUMBER := 0-1962.0724
440: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a13 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
439: , p0_a8 NUMBER := 0-1962.0724
440: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a13 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a15 NUMBER := 0-1962.0724
447: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
441: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a13 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a15 NUMBER := 0-1962.0724
447: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a13 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a15 NUMBER := 0-1962.0724
447: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a19 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
444: , p0_a13 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a15 NUMBER := 0-1962.0724
447: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a19 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
452: , p0_a21 NUMBER := 0-1962.0724
445: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a15 NUMBER := 0-1962.0724
447: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a19 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
452: , p0_a21 NUMBER := 0-1962.0724
453: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a19 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
452: , p0_a21 NUMBER := 0-1962.0724
453: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
450: , p0_a19 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
452: , p0_a21 NUMBER := 0-1962.0724
453: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
451: , p0_a20 NUMBER := 0-1962.0724
452: , p0_a21 NUMBER := 0-1962.0724
453: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a21 NUMBER := 0-1962.0724
453: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
456: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
464: , p1_a1 DATE := fnd_api.g_miss_date
457: , p0_a26 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
464: , p1_a1 DATE := fnd_api.g_miss_date
465: , p1_a2 NUMBER := 0-1962.0724
458: , p0_a27 NUMBER := 0-1962.0724
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
464: , p1_a1 DATE := fnd_api.g_miss_date
465: , p1_a2 NUMBER := 0-1962.0724
466: , p1_a3 DATE := fnd_api.g_miss_date
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
464: , p1_a1 DATE := fnd_api.g_miss_date
465: , p1_a2 NUMBER := 0-1962.0724
466: , p1_a3 DATE := fnd_api.g_miss_date
467: , p1_a4 NUMBER := 0-1962.0724
468: , p1_a5 NUMBER := 0-1962.0724
462: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463: , p1_a0 NUMBER := 0-1962.0724
464: , p1_a1 DATE := fnd_api.g_miss_date
465: , p1_a2 NUMBER := 0-1962.0724
466: , p1_a3 DATE := fnd_api.g_miss_date
467: , p1_a4 NUMBER := 0-1962.0724
468: , p1_a5 NUMBER := 0-1962.0724
469: , p1_a6 NUMBER := 0-1962.0724
470: , p1_a7 NUMBER := 0-1962.0724
468: , p1_a5 NUMBER := 0-1962.0724
469: , p1_a6 NUMBER := 0-1962.0724
470: , p1_a7 NUMBER := 0-1962.0724
471: , p1_a8 NUMBER := 0-1962.0724
472: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a13 NUMBER := 0-1962.0724
469: , p1_a6 NUMBER := 0-1962.0724
470: , p1_a7 NUMBER := 0-1962.0724
471: , p1_a8 NUMBER := 0-1962.0724
472: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a13 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
471: , p1_a8 NUMBER := 0-1962.0724
472: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a13 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a15 NUMBER := 0-1962.0724
479: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
473: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a13 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a15 NUMBER := 0-1962.0724
479: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
475: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p1_a13 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a15 NUMBER := 0-1962.0724
479: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a19 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
476: , p1_a13 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a15 NUMBER := 0-1962.0724
479: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a19 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
484: , p1_a21 NUMBER := 0-1962.0724
477: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p1_a15 NUMBER := 0-1962.0724
479: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a19 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
484: , p1_a21 NUMBER := 0-1962.0724
485: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
481: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p1_a19 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
484: , p1_a21 NUMBER := 0-1962.0724
485: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
482: , p1_a19 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
484: , p1_a21 NUMBER := 0-1962.0724
485: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
483: , p1_a20 NUMBER := 0-1962.0724
484: , p1_a21 NUMBER := 0-1962.0724
485: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a21 NUMBER := 0-1962.0724
485: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
488: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
489: , p1_a26 NUMBER := 0-1962.0724
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
497: as
490: , p1_a27 NUMBER := 0-1962.0724
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
497: as
498: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
689: , p1_a29 out nocopy VARCHAR2
690: , p1_a30 out nocopy VARCHAR2
691: , p1_a31 out nocopy VARCHAR2
692: , p0_a0 NUMBER := 0-1962.0724
693: , p0_a1 DATE := fnd_api.g_miss_date
694: , p0_a2 NUMBER := 0-1962.0724
695: , p0_a3 DATE := fnd_api.g_miss_date
696: , p0_a4 NUMBER := 0-1962.0724
697: , p0_a5 NUMBER := 0-1962.0724
691: , p1_a31 out nocopy VARCHAR2
692: , p0_a0 NUMBER := 0-1962.0724
693: , p0_a1 DATE := fnd_api.g_miss_date
694: , p0_a2 NUMBER := 0-1962.0724
695: , p0_a3 DATE := fnd_api.g_miss_date
696: , p0_a4 NUMBER := 0-1962.0724
697: , p0_a5 NUMBER := 0-1962.0724
698: , p0_a6 NUMBER := 0-1962.0724
699: , p0_a7 NUMBER := 0-1962.0724
697: , p0_a5 NUMBER := 0-1962.0724
698: , p0_a6 NUMBER := 0-1962.0724
699: , p0_a7 NUMBER := 0-1962.0724
700: , p0_a8 NUMBER := 0-1962.0724
701: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
702: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
703: , p0_a11 NUMBER := 0-1962.0724
704: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705: , p0_a13 NUMBER := 0-1962.0724
698: , p0_a6 NUMBER := 0-1962.0724
699: , p0_a7 NUMBER := 0-1962.0724
700: , p0_a8 NUMBER := 0-1962.0724
701: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
702: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
703: , p0_a11 NUMBER := 0-1962.0724
704: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705: , p0_a13 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a8 NUMBER := 0-1962.0724
701: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
702: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
703: , p0_a11 NUMBER := 0-1962.0724
704: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705: , p0_a13 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p0_a15 NUMBER := 0-1962.0724
708: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
702: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
703: , p0_a11 NUMBER := 0-1962.0724
704: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705: , p0_a13 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p0_a15 NUMBER := 0-1962.0724
708: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
704: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
705: , p0_a13 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p0_a15 NUMBER := 0-1962.0724
708: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
711: , p0_a19 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
705: , p0_a13 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p0_a15 NUMBER := 0-1962.0724
708: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
711: , p0_a19 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
713: , p0_a21 NUMBER := 0-1962.0724
706: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
707: , p0_a15 NUMBER := 0-1962.0724
708: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
709: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
710: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
711: , p0_a19 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
713: , p0_a21 NUMBER := 0-1962.0724
714: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
710: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
711: , p0_a19 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
713: , p0_a21 NUMBER := 0-1962.0724
714: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
711: , p0_a19 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
713: , p0_a21 NUMBER := 0-1962.0724
714: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
712: , p0_a20 NUMBER := 0-1962.0724
713: , p0_a21 NUMBER := 0-1962.0724
714: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
713: , p0_a21 NUMBER := 0-1962.0724
714: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
715: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
716: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
716: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
722: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
723: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724: )
717: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
722: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
723: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724: )
725:
718: , p0_a26 NUMBER := 0-1962.0724
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
722: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
723: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724: )
725:
726: as
719: , p0_a27 NUMBER := 0-1962.0724
720: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
721: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
722: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
723: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724: )
725:
726: as
727: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;