3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;
14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure create_msg(p_api_version NUMBER
27: , x_msg_count OUT NOCOPY NUMBER
28: , x_msg_data OUT NOCOPY VARCHAR2
29: , x_msg_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_msg_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 DATE := fnd_api.g_miss_date
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 DATE := fnd_api.g_miss_date
38: , p7_a8 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
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date
38: , p7_a8 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 VARCHAR2 := fnd_api.g_miss_char
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date
38: , p7_a8 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 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 DATE := fnd_api.g_miss_date
38: , p7_a8 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 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
38: , p7_a8 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 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
41: , p7_a11 NUMBER := 0-1962.0724
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 NUMBER := 0-1962.0724
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: )
54: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: )
62: as
55: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: )
62: as
63: ddp_msg_rec ams_messages_pvt.msg_rec_type;
56: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: )
62: as
63: ddp_msg_rec ams_messages_pvt.msg_rec_type;
64: ddindx binary_integer; indx binary_integer;
134: , x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_count OUT NOCOPY NUMBER
136: , x_msg_data OUT NOCOPY VARCHAR2
137: , p7_a0 NUMBER := 0-1962.0724
138: , p7_a1 DATE := fnd_api.g_miss_date
139: , p7_a2 NUMBER := 0-1962.0724
140: , p7_a3 DATE := fnd_api.g_miss_date
141: , p7_a4 NUMBER := 0-1962.0724
142: , p7_a5 NUMBER := 0-1962.0724
136: , x_msg_data OUT NOCOPY VARCHAR2
137: , p7_a0 NUMBER := 0-1962.0724
138: , p7_a1 DATE := fnd_api.g_miss_date
139: , p7_a2 NUMBER := 0-1962.0724
140: , p7_a3 DATE := fnd_api.g_miss_date
141: , p7_a4 NUMBER := 0-1962.0724
142: , p7_a5 NUMBER := 0-1962.0724
143: , p7_a6 NUMBER := 0-1962.0724
144: , p7_a7 DATE := fnd_api.g_miss_date
140: , p7_a3 DATE := fnd_api.g_miss_date
141: , p7_a4 NUMBER := 0-1962.0724
142: , p7_a5 NUMBER := 0-1962.0724
143: , p7_a6 NUMBER := 0-1962.0724
144: , p7_a7 DATE := fnd_api.g_miss_date
145: , p7_a8 DATE := fnd_api.g_miss_date
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
141: , p7_a4 NUMBER := 0-1962.0724
142: , p7_a5 NUMBER := 0-1962.0724
143: , p7_a6 NUMBER := 0-1962.0724
144: , p7_a7 DATE := fnd_api.g_miss_date
145: , p7_a8 DATE := fnd_api.g_miss_date
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a5 NUMBER := 0-1962.0724
143: , p7_a6 NUMBER := 0-1962.0724
144: , p7_a7 DATE := fnd_api.g_miss_date
145: , p7_a8 DATE := fnd_api.g_miss_date
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a6 NUMBER := 0-1962.0724
144: , p7_a7 DATE := fnd_api.g_miss_date
145: , p7_a8 DATE := fnd_api.g_miss_date
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
145: , p7_a8 DATE := fnd_api.g_miss_date
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a11 NUMBER := 0-1962.0724
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a14 NUMBER := 0-1962.0724
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
153: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
154: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
155: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168: )
161: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168: )
169: as
162: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168: )
169: as
170: ddp_msg_rec ams_messages_pvt.msg_rec_type;
163: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168: )
169: as
170: ddp_msg_rec ams_messages_pvt.msg_rec_type;
171: ddindx binary_integer; indx binary_integer;
237: , x_return_status OUT NOCOPY VARCHAR2
238: , x_msg_count OUT NOCOPY NUMBER
239: , x_msg_data OUT NOCOPY VARCHAR2
240: , p6_a0 NUMBER := 0-1962.0724
241: , p6_a1 DATE := fnd_api.g_miss_date
242: , p6_a2 NUMBER := 0-1962.0724
243: , p6_a3 DATE := fnd_api.g_miss_date
244: , p6_a4 NUMBER := 0-1962.0724
245: , p6_a5 NUMBER := 0-1962.0724
239: , x_msg_data OUT NOCOPY VARCHAR2
240: , p6_a0 NUMBER := 0-1962.0724
241: , p6_a1 DATE := fnd_api.g_miss_date
242: , p6_a2 NUMBER := 0-1962.0724
243: , p6_a3 DATE := fnd_api.g_miss_date
244: , p6_a4 NUMBER := 0-1962.0724
245: , p6_a5 NUMBER := 0-1962.0724
246: , p6_a6 NUMBER := 0-1962.0724
247: , p6_a7 DATE := fnd_api.g_miss_date
243: , p6_a3 DATE := fnd_api.g_miss_date
244: , p6_a4 NUMBER := 0-1962.0724
245: , p6_a5 NUMBER := 0-1962.0724
246: , p6_a6 NUMBER := 0-1962.0724
247: , p6_a7 DATE := fnd_api.g_miss_date
248: , p6_a8 DATE := fnd_api.g_miss_date
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
244: , p6_a4 NUMBER := 0-1962.0724
245: , p6_a5 NUMBER := 0-1962.0724
246: , p6_a6 NUMBER := 0-1962.0724
247: , p6_a7 DATE := fnd_api.g_miss_date
248: , p6_a8 DATE := fnd_api.g_miss_date
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
245: , p6_a5 NUMBER := 0-1962.0724
246: , p6_a6 NUMBER := 0-1962.0724
247: , p6_a7 DATE := fnd_api.g_miss_date
248: , p6_a8 DATE := fnd_api.g_miss_date
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
246: , p6_a6 NUMBER := 0-1962.0724
247: , p6_a7 DATE := fnd_api.g_miss_date
248: , p6_a8 DATE := fnd_api.g_miss_date
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
248: , p6_a8 DATE := fnd_api.g_miss_date
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
251: , p6_a11 NUMBER := 0-1962.0724
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
252: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
253: , p6_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
254: , p6_a14 NUMBER := 0-1962.0724
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
255: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
256: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
257: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
258: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
259: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
260: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
261: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
262: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
271: )
264: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
265: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
273: ddp_msg_rec ams_messages_pvt.msg_rec_type;
266: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
267: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
273: ddp_msg_rec ams_messages_pvt.msg_rec_type;
274: ddindx binary_integer; indx binary_integer;
333:
334: procedure check_items(p_validation_mode VARCHAR2
335: , x_return_status OUT NOCOPY VARCHAR2
336: , p2_a0 NUMBER := 0-1962.0724
337: , p2_a1 DATE := fnd_api.g_miss_date
338: , p2_a2 NUMBER := 0-1962.0724
339: , p2_a3 DATE := fnd_api.g_miss_date
340: , p2_a4 NUMBER := 0-1962.0724
341: , p2_a5 NUMBER := 0-1962.0724
335: , x_return_status OUT NOCOPY VARCHAR2
336: , p2_a0 NUMBER := 0-1962.0724
337: , p2_a1 DATE := fnd_api.g_miss_date
338: , p2_a2 NUMBER := 0-1962.0724
339: , p2_a3 DATE := fnd_api.g_miss_date
340: , p2_a4 NUMBER := 0-1962.0724
341: , p2_a5 NUMBER := 0-1962.0724
342: , p2_a6 NUMBER := 0-1962.0724
343: , p2_a7 DATE := fnd_api.g_miss_date
339: , p2_a3 DATE := fnd_api.g_miss_date
340: , p2_a4 NUMBER := 0-1962.0724
341: , p2_a5 NUMBER := 0-1962.0724
342: , p2_a6 NUMBER := 0-1962.0724
343: , p2_a7 DATE := fnd_api.g_miss_date
344: , p2_a8 DATE := fnd_api.g_miss_date
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
340: , p2_a4 NUMBER := 0-1962.0724
341: , p2_a5 NUMBER := 0-1962.0724
342: , p2_a6 NUMBER := 0-1962.0724
343: , p2_a7 DATE := fnd_api.g_miss_date
344: , p2_a8 DATE := fnd_api.g_miss_date
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
341: , p2_a5 NUMBER := 0-1962.0724
342: , p2_a6 NUMBER := 0-1962.0724
343: , p2_a7 DATE := fnd_api.g_miss_date
344: , p2_a8 DATE := fnd_api.g_miss_date
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
342: , p2_a6 NUMBER := 0-1962.0724
343: , p2_a7 DATE := fnd_api.g_miss_date
344: , p2_a8 DATE := fnd_api.g_miss_date
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
344: , p2_a8 DATE := fnd_api.g_miss_date
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
345: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
346: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
347: , p2_a11 NUMBER := 0-1962.0724
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
348: , p2_a12 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
349: , p2_a13 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
350: , p2_a14 NUMBER := 0-1962.0724
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
351: , p2_a15 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
352: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
353: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
354: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
355: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
356: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
357: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
358: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
359: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
367: )
360: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
367: )
368: as
361: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
367: )
368: as
369: ddp_msg_rec ams_messages_pvt.msg_rec_type;
362: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
363: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
364: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
365: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
366: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
367: )
368: as
369: ddp_msg_rec ams_messages_pvt.msg_rec_type;
370: ddindx binary_integer; indx binary_integer;
417:
418: procedure check_req_items(p_validation_mode VARCHAR2
419: , x_return_status OUT NOCOPY VARCHAR2
420: , p1_a0 NUMBER := 0-1962.0724
421: , p1_a1 DATE := fnd_api.g_miss_date
422: , p1_a2 NUMBER := 0-1962.0724
423: , p1_a3 DATE := fnd_api.g_miss_date
424: , p1_a4 NUMBER := 0-1962.0724
425: , p1_a5 NUMBER := 0-1962.0724
419: , x_return_status OUT NOCOPY VARCHAR2
420: , p1_a0 NUMBER := 0-1962.0724
421: , p1_a1 DATE := fnd_api.g_miss_date
422: , p1_a2 NUMBER := 0-1962.0724
423: , p1_a3 DATE := fnd_api.g_miss_date
424: , p1_a4 NUMBER := 0-1962.0724
425: , p1_a5 NUMBER := 0-1962.0724
426: , p1_a6 NUMBER := 0-1962.0724
427: , p1_a7 DATE := fnd_api.g_miss_date
423: , p1_a3 DATE := fnd_api.g_miss_date
424: , p1_a4 NUMBER := 0-1962.0724
425: , p1_a5 NUMBER := 0-1962.0724
426: , p1_a6 NUMBER := 0-1962.0724
427: , p1_a7 DATE := fnd_api.g_miss_date
428: , p1_a8 DATE := fnd_api.g_miss_date
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
424: , p1_a4 NUMBER := 0-1962.0724
425: , p1_a5 NUMBER := 0-1962.0724
426: , p1_a6 NUMBER := 0-1962.0724
427: , p1_a7 DATE := fnd_api.g_miss_date
428: , p1_a8 DATE := fnd_api.g_miss_date
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
425: , p1_a5 NUMBER := 0-1962.0724
426: , p1_a6 NUMBER := 0-1962.0724
427: , p1_a7 DATE := fnd_api.g_miss_date
428: , p1_a8 DATE := fnd_api.g_miss_date
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
426: , p1_a6 NUMBER := 0-1962.0724
427: , p1_a7 DATE := fnd_api.g_miss_date
428: , p1_a8 DATE := fnd_api.g_miss_date
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
428: , p1_a8 DATE := fnd_api.g_miss_date
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
429: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
430: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
431: , p1_a11 NUMBER := 0-1962.0724
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
432: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
433: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
434: , p1_a14 NUMBER := 0-1962.0724
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
435: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
436: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
437: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
438: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
439: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
440: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
441: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
442: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
443: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
451: )
444: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
451: )
452: as
445: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
451: )
452: as
453: ddp_msg_rec ams_messages_pvt.msg_rec_type;
446: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
447: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
448: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
449: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
450: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
451: )
452: as
453: ddp_msg_rec ams_messages_pvt.msg_rec_type;
454: ddindx binary_integer; indx binary_integer;
501:
502: procedure check_uk_items(p_validation_mode VARCHAR2
503: , x_return_status OUT NOCOPY VARCHAR2
504: , p1_a0 NUMBER := 0-1962.0724
505: , p1_a1 DATE := fnd_api.g_miss_date
506: , p1_a2 NUMBER := 0-1962.0724
507: , p1_a3 DATE := fnd_api.g_miss_date
508: , p1_a4 NUMBER := 0-1962.0724
509: , p1_a5 NUMBER := 0-1962.0724
503: , x_return_status OUT NOCOPY VARCHAR2
504: , p1_a0 NUMBER := 0-1962.0724
505: , p1_a1 DATE := fnd_api.g_miss_date
506: , p1_a2 NUMBER := 0-1962.0724
507: , p1_a3 DATE := fnd_api.g_miss_date
508: , p1_a4 NUMBER := 0-1962.0724
509: , p1_a5 NUMBER := 0-1962.0724
510: , p1_a6 NUMBER := 0-1962.0724
511: , p1_a7 DATE := fnd_api.g_miss_date
507: , p1_a3 DATE := fnd_api.g_miss_date
508: , p1_a4 NUMBER := 0-1962.0724
509: , p1_a5 NUMBER := 0-1962.0724
510: , p1_a6 NUMBER := 0-1962.0724
511: , p1_a7 DATE := fnd_api.g_miss_date
512: , p1_a8 DATE := fnd_api.g_miss_date
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
508: , p1_a4 NUMBER := 0-1962.0724
509: , p1_a5 NUMBER := 0-1962.0724
510: , p1_a6 NUMBER := 0-1962.0724
511: , p1_a7 DATE := fnd_api.g_miss_date
512: , p1_a8 DATE := fnd_api.g_miss_date
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a5 NUMBER := 0-1962.0724
510: , p1_a6 NUMBER := 0-1962.0724
511: , p1_a7 DATE := fnd_api.g_miss_date
512: , p1_a8 DATE := fnd_api.g_miss_date
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a6 NUMBER := 0-1962.0724
511: , p1_a7 DATE := fnd_api.g_miss_date
512: , p1_a8 DATE := fnd_api.g_miss_date
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
512: , p1_a8 DATE := fnd_api.g_miss_date
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a11 NUMBER := 0-1962.0724
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a14 NUMBER := 0-1962.0724
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
521: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
522: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
523: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
524: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
525: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
526: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
527: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
535: )
528: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
535: )
536: as
529: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
535: )
536: as
537: ddp_msg_rec ams_messages_pvt.msg_rec_type;
530: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
531: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
532: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
533: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
534: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
535: )
536: as
537: ddp_msg_rec ams_messages_pvt.msg_rec_type;
538: ddindx binary_integer; indx binary_integer;
584: end;
585:
586: procedure check_record(x_return_status OUT NOCOPY VARCHAR2
587: , p0_a0 NUMBER := 0-1962.0724
588: , p0_a1 DATE := fnd_api.g_miss_date
589: , p0_a2 NUMBER := 0-1962.0724
590: , p0_a3 DATE := fnd_api.g_miss_date
591: , p0_a4 NUMBER := 0-1962.0724
592: , p0_a5 NUMBER := 0-1962.0724
586: procedure check_record(x_return_status OUT NOCOPY VARCHAR2
587: , p0_a0 NUMBER := 0-1962.0724
588: , p0_a1 DATE := fnd_api.g_miss_date
589: , p0_a2 NUMBER := 0-1962.0724
590: , p0_a3 DATE := fnd_api.g_miss_date
591: , p0_a4 NUMBER := 0-1962.0724
592: , p0_a5 NUMBER := 0-1962.0724
593: , p0_a6 NUMBER := 0-1962.0724
594: , p0_a7 DATE := fnd_api.g_miss_date
590: , p0_a3 DATE := fnd_api.g_miss_date
591: , p0_a4 NUMBER := 0-1962.0724
592: , p0_a5 NUMBER := 0-1962.0724
593: , p0_a6 NUMBER := 0-1962.0724
594: , p0_a7 DATE := fnd_api.g_miss_date
595: , p0_a8 DATE := fnd_api.g_miss_date
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
591: , p0_a4 NUMBER := 0-1962.0724
592: , p0_a5 NUMBER := 0-1962.0724
593: , p0_a6 NUMBER := 0-1962.0724
594: , p0_a7 DATE := fnd_api.g_miss_date
595: , p0_a8 DATE := fnd_api.g_miss_date
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a5 NUMBER := 0-1962.0724
593: , p0_a6 NUMBER := 0-1962.0724
594: , p0_a7 DATE := fnd_api.g_miss_date
595: , p0_a8 DATE := fnd_api.g_miss_date
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p0_a6 NUMBER := 0-1962.0724
594: , p0_a7 DATE := fnd_api.g_miss_date
595: , p0_a8 DATE := fnd_api.g_miss_date
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
595: , p0_a8 DATE := fnd_api.g_miss_date
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
598: , p0_a11 NUMBER := 0-1962.0724
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p0_a14 NUMBER := 0-1962.0724
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
606: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
607: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
608: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
609: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
610: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
611: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
619: , p1_a1 DATE := fnd_api.g_miss_date
612: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
619: , p1_a1 DATE := fnd_api.g_miss_date
620: , p1_a2 NUMBER := 0-1962.0724
613: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
614: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
619: , p1_a1 DATE := fnd_api.g_miss_date
620: , p1_a2 NUMBER := 0-1962.0724
621: , p1_a3 DATE := fnd_api.g_miss_date
615: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
616: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
619: , p1_a1 DATE := fnd_api.g_miss_date
620: , p1_a2 NUMBER := 0-1962.0724
621: , p1_a3 DATE := fnd_api.g_miss_date
622: , p1_a4 NUMBER := 0-1962.0724
623: , p1_a5 NUMBER := 0-1962.0724
617: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
618: , p1_a0 NUMBER := 0-1962.0724
619: , p1_a1 DATE := fnd_api.g_miss_date
620: , p1_a2 NUMBER := 0-1962.0724
621: , p1_a3 DATE := fnd_api.g_miss_date
622: , p1_a4 NUMBER := 0-1962.0724
623: , p1_a5 NUMBER := 0-1962.0724
624: , p1_a6 NUMBER := 0-1962.0724
625: , p1_a7 DATE := fnd_api.g_miss_date
621: , p1_a3 DATE := fnd_api.g_miss_date
622: , p1_a4 NUMBER := 0-1962.0724
623: , p1_a5 NUMBER := 0-1962.0724
624: , p1_a6 NUMBER := 0-1962.0724
625: , p1_a7 DATE := fnd_api.g_miss_date
626: , p1_a8 DATE := fnd_api.g_miss_date
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
622: , p1_a4 NUMBER := 0-1962.0724
623: , p1_a5 NUMBER := 0-1962.0724
624: , p1_a6 NUMBER := 0-1962.0724
625: , p1_a7 DATE := fnd_api.g_miss_date
626: , p1_a8 DATE := fnd_api.g_miss_date
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
623: , p1_a5 NUMBER := 0-1962.0724
624: , p1_a6 NUMBER := 0-1962.0724
625: , p1_a7 DATE := fnd_api.g_miss_date
626: , p1_a8 DATE := fnd_api.g_miss_date
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
624: , p1_a6 NUMBER := 0-1962.0724
625: , p1_a7 DATE := fnd_api.g_miss_date
626: , p1_a8 DATE := fnd_api.g_miss_date
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
626: , p1_a8 DATE := fnd_api.g_miss_date
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
627: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
628: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p1_a11 NUMBER := 0-1962.0724
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
630: , p1_a12 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
631: , p1_a13 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
632: , p1_a14 NUMBER := 0-1962.0724
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
633: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
634: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
635: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
636: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
637: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
638: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
639: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
640: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
641: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
649: )
642: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
649: )
650: as
643: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
649: )
650: as
651: ddp_msg_rec ams_messages_pvt.msg_rec_type;
644: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
645: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
646: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
647: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
648: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
649: )
650: as
651: ddp_msg_rec ams_messages_pvt.msg_rec_type;
652: ddp_complete_rec ams_messages_pvt.msg_rec_type;
760: , p1_a28 OUT NOCOPY VARCHAR2
761: , p1_a29 OUT NOCOPY VARCHAR2
762: , p1_a30 OUT NOCOPY VARCHAR2
763: , p0_a0 NUMBER := 0-1962.0724
764: , p0_a1 DATE := fnd_api.g_miss_date
765: , p0_a2 NUMBER := 0-1962.0724
766: , p0_a3 DATE := fnd_api.g_miss_date
767: , p0_a4 NUMBER := 0-1962.0724
768: , p0_a5 NUMBER := 0-1962.0724
762: , p1_a30 OUT NOCOPY VARCHAR2
763: , p0_a0 NUMBER := 0-1962.0724
764: , p0_a1 DATE := fnd_api.g_miss_date
765: , p0_a2 NUMBER := 0-1962.0724
766: , p0_a3 DATE := fnd_api.g_miss_date
767: , p0_a4 NUMBER := 0-1962.0724
768: , p0_a5 NUMBER := 0-1962.0724
769: , p0_a6 NUMBER := 0-1962.0724
770: , p0_a7 DATE := fnd_api.g_miss_date
766: , p0_a3 DATE := fnd_api.g_miss_date
767: , p0_a4 NUMBER := 0-1962.0724
768: , p0_a5 NUMBER := 0-1962.0724
769: , p0_a6 NUMBER := 0-1962.0724
770: , p0_a7 DATE := fnd_api.g_miss_date
771: , p0_a8 DATE := fnd_api.g_miss_date
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
767: , p0_a4 NUMBER := 0-1962.0724
768: , p0_a5 NUMBER := 0-1962.0724
769: , p0_a6 NUMBER := 0-1962.0724
770: , p0_a7 DATE := fnd_api.g_miss_date
771: , p0_a8 DATE := fnd_api.g_miss_date
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
768: , p0_a5 NUMBER := 0-1962.0724
769: , p0_a6 NUMBER := 0-1962.0724
770: , p0_a7 DATE := fnd_api.g_miss_date
771: , p0_a8 DATE := fnd_api.g_miss_date
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
769: , p0_a6 NUMBER := 0-1962.0724
770: , p0_a7 DATE := fnd_api.g_miss_date
771: , p0_a8 DATE := fnd_api.g_miss_date
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
771: , p0_a8 DATE := fnd_api.g_miss_date
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
772: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
773: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
774: , p0_a11 NUMBER := 0-1962.0724
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
777: , p0_a14 NUMBER := 0-1962.0724
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
778: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
779: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
780: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
781: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
782: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
783: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
784: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
785: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
786: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
794: )
787: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
794: )
795: as
788: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
794: )
795: as
796: ddp_msg_rec ams_messages_pvt.msg_rec_type;
789: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
794: )
795: as
796: ddp_msg_rec ams_messages_pvt.msg_rec_type;
797: ddx_complete_rec ams_messages_pvt.msg_rec_type;