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_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_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 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
43: , p7_a13 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
44: , p7_a14 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
45: , p7_a15 DATE := fnd_api.g_miss_date
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 DATE := fnd_api.g_miss_date
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
47: , p7_a17 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
48: , p7_a18 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
49: , p7_a19 DATE := fnd_api.g_miss_date
50: , p7_a20 DATE := fnd_api.g_miss_date
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 DATE := fnd_api.g_miss_date
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 DATE := fnd_api.g_miss_date
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
55: , p7_a25 DATE := fnd_api.g_miss_date
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
64: as
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
64: as
65: ddp_trig_rec ams_trig_pvt.trig_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 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
150: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
151: , p7_a11 NUMBER := 0-1962.0724
152: , p7_a12 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
152: , p7_a12 NUMBER := 0-1962.0724
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
153: , p7_a13 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
154: , p7_a14 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
155: , p7_a15 DATE := fnd_api.g_miss_date
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a16 DATE := fnd_api.g_miss_date
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
157: , p7_a17 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
158: , p7_a18 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
159: , p7_a19 DATE := fnd_api.g_miss_date
160: , p7_a20 DATE := fnd_api.g_miss_date
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a21 DATE := fnd_api.g_miss_date
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a22 DATE := fnd_api.g_miss_date
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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
163: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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
164: , p7_a24 NUMBER := 0-1962.0724
165: , p7_a25 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
166: , p7_a26 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
167: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
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_trig_rec ams_trig_pvt.trig_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 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
256: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
257: , p6_a11 NUMBER := 0-1962.0724
258: , p6_a12 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
258: , p6_a12 NUMBER := 0-1962.0724
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
259: , p6_a13 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
260: , p6_a14 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
261: , p6_a15 DATE := fnd_api.g_miss_date
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a16 DATE := fnd_api.g_miss_date
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
263: , p6_a17 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
264: , p6_a18 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
265: , p6_a19 DATE := fnd_api.g_miss_date
266: , p6_a20 DATE := fnd_api.g_miss_date
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a21 DATE := fnd_api.g_miss_date
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a22 DATE := fnd_api.g_miss_date
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
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
269: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
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
270: , p6_a24 NUMBER := 0-1962.0724
271: , p6_a25 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
272: , p6_a26 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
273: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
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_trig_rec ams_trig_pvt.trig_rec_type;
342:
343: procedure check_trig_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 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
355: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
356: , p0_a11 NUMBER := 0-1962.0724
357: , p0_a12 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
357: , p0_a12 NUMBER := 0-1962.0724
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
358: , p0_a13 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
359: , p0_a14 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
360: , p0_a15 DATE := fnd_api.g_miss_date
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
361: , p0_a16 DATE := fnd_api.g_miss_date
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
362: , p0_a17 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
363: , p0_a18 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
364: , p0_a19 DATE := fnd_api.g_miss_date
365: , p0_a20 DATE := fnd_api.g_miss_date
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
366: , p0_a21 DATE := fnd_api.g_miss_date
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
373: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a22 DATE := fnd_api.g_miss_date
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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
368: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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
369: , p0_a24 NUMBER := 0-1962.0724
370: , p0_a25 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
371: , p0_a26 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
372: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
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_trig_rec ams_trig_pvt.trig_rec_type;
428: end;
429:
430: procedure check_trig_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_trig_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 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
441: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
442: , p0_a11 NUMBER := 0-1962.0724
443: , p0_a12 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
443: , p0_a12 NUMBER := 0-1962.0724
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
444: , p0_a13 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
445: , p0_a14 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
446: , p0_a15 DATE := fnd_api.g_miss_date
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a16 DATE := fnd_api.g_miss_date
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
448: , p0_a17 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
449: , p0_a18 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
450: , p0_a19 DATE := fnd_api.g_miss_date
451: , p0_a20 DATE := fnd_api.g_miss_date
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
452: , p0_a21 DATE := fnd_api.g_miss_date
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
453: , p0_a22 DATE := fnd_api.g_miss_date
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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
454: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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
455: , p0_a24 NUMBER := 0-1962.0724
456: , p0_a25 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
457: , p0_a26 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
458: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
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 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
473: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
474: , p1_a11 NUMBER := 0-1962.0724
475: , p1_a12 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
475: , p1_a12 NUMBER := 0-1962.0724
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
476: , p1_a13 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
477: , p1_a14 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
478: , p1_a15 DATE := fnd_api.g_miss_date
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
479: , p1_a16 DATE := fnd_api.g_miss_date
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
480: , p1_a17 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
481: , p1_a18 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
482: , p1_a19 DATE := fnd_api.g_miss_date
483: , p1_a20 DATE := fnd_api.g_miss_date
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
484: , p1_a21 DATE := fnd_api.g_miss_date
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
491: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
485: , p1_a22 DATE := fnd_api.g_miss_date
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
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
486: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
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
487: , p1_a24 NUMBER := 0-1962.0724
488: , p1_a25 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
489: , p1_a26 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
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 DATE := fnd_api.g_miss_date
490: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
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_trig_rec ams_trig_pvt.trig_rec_type;
579: end;
580:
581: procedure check_trig_req_items(x_return_status out nocopy VARCHAR2
582: , p0_a0 NUMBER := 0-1962.0724
583: , p0_a1 DATE := fnd_api.g_miss_date
584: , p0_a2 NUMBER := 0-1962.0724
585: , p0_a3 DATE := fnd_api.g_miss_date
586: , p0_a4 NUMBER := 0-1962.0724
587: , p0_a5 NUMBER := 0-1962.0724
581: procedure check_trig_req_items(x_return_status out nocopy VARCHAR2
582: , p0_a0 NUMBER := 0-1962.0724
583: , p0_a1 DATE := fnd_api.g_miss_date
584: , p0_a2 NUMBER := 0-1962.0724
585: , p0_a3 DATE := fnd_api.g_miss_date
586: , p0_a4 NUMBER := 0-1962.0724
587: , p0_a5 NUMBER := 0-1962.0724
588: , p0_a6 NUMBER := 0-1962.0724
589: , p0_a7 NUMBER := 0-1962.0724
587: , p0_a5 NUMBER := 0-1962.0724
588: , p0_a6 NUMBER := 0-1962.0724
589: , p0_a7 NUMBER := 0-1962.0724
590: , p0_a8 NUMBER := 0-1962.0724
591: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a11 NUMBER := 0-1962.0724
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
588: , p0_a6 NUMBER := 0-1962.0724
589: , p0_a7 NUMBER := 0-1962.0724
590: , p0_a8 NUMBER := 0-1962.0724
591: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a11 NUMBER := 0-1962.0724
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
591: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a11 NUMBER := 0-1962.0724
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
592: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a11 NUMBER := 0-1962.0724
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
593: , p0_a11 NUMBER := 0-1962.0724
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
594: , p0_a12 NUMBER := 0-1962.0724
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
595: , p0_a13 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
596: , p0_a14 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
597: , p0_a15 DATE := fnd_api.g_miss_date
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a16 DATE := fnd_api.g_miss_date
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
599: , p0_a17 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
600: , p0_a18 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
601: , p0_a19 DATE := fnd_api.g_miss_date
602: , p0_a20 DATE := fnd_api.g_miss_date
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a21 DATE := fnd_api.g_miss_date
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a22 DATE := fnd_api.g_miss_date
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a24 NUMBER := 0-1962.0724
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
614: )
607: , p0_a25 DATE := fnd_api.g_miss_date
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
614: )
615:
608: , p0_a26 DATE := fnd_api.g_miss_date
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
614: )
615:
616: as
609: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
614: )
615:
616: as
617: ddp_trig_rec ams_trig_pvt.trig_rec_type;
772: , p1_a29 out nocopy VARCHAR2
773: , p1_a30 out nocopy VARCHAR2
774: , p1_a31 out nocopy VARCHAR2
775: , p0_a0 NUMBER := 0-1962.0724
776: , p0_a1 DATE := fnd_api.g_miss_date
777: , p0_a2 NUMBER := 0-1962.0724
778: , p0_a3 DATE := fnd_api.g_miss_date
779: , p0_a4 NUMBER := 0-1962.0724
780: , p0_a5 NUMBER := 0-1962.0724
774: , p1_a31 out nocopy VARCHAR2
775: , p0_a0 NUMBER := 0-1962.0724
776: , p0_a1 DATE := fnd_api.g_miss_date
777: , p0_a2 NUMBER := 0-1962.0724
778: , p0_a3 DATE := fnd_api.g_miss_date
779: , p0_a4 NUMBER := 0-1962.0724
780: , p0_a5 NUMBER := 0-1962.0724
781: , p0_a6 NUMBER := 0-1962.0724
782: , p0_a7 NUMBER := 0-1962.0724
780: , p0_a5 NUMBER := 0-1962.0724
781: , p0_a6 NUMBER := 0-1962.0724
782: , p0_a7 NUMBER := 0-1962.0724
783: , p0_a8 NUMBER := 0-1962.0724
784: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a11 NUMBER := 0-1962.0724
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
781: , p0_a6 NUMBER := 0-1962.0724
782: , p0_a7 NUMBER := 0-1962.0724
783: , p0_a8 NUMBER := 0-1962.0724
784: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a11 NUMBER := 0-1962.0724
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
784: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a11 NUMBER := 0-1962.0724
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
785: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a11 NUMBER := 0-1962.0724
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
786: , p0_a11 NUMBER := 0-1962.0724
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
787: , p0_a12 NUMBER := 0-1962.0724
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
788: , p0_a13 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
789: , p0_a14 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
790: , p0_a15 DATE := fnd_api.g_miss_date
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a16 DATE := fnd_api.g_miss_date
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
792: , p0_a17 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
793: , p0_a18 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
794: , p0_a19 DATE := fnd_api.g_miss_date
795: , p0_a20 DATE := fnd_api.g_miss_date
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
796: , p0_a21 DATE := fnd_api.g_miss_date
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
797: , p0_a22 DATE := fnd_api.g_miss_date
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
798: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
799: , p0_a24 NUMBER := 0-1962.0724
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
807: )
800: , p0_a25 DATE := fnd_api.g_miss_date
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
807: )
808:
801: , p0_a26 DATE := fnd_api.g_miss_date
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
807: )
808:
809: as
802: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
807: )
808:
809: as
810: ddp_trig_rec ams_trig_pvt.trig_rec_type;