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_lead_pss_line(p_api_version_number NUMBER
27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , x_lead_pss_line_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_lead_pss_line_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
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
37: , p7_a7 NUMBER := 0-1962.0724
38: , p7_a8 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
40: , p7_a10 DATE := fnd_api.g_miss_date
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a13 NUMBER := 0-1962.0724
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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: , p7_a31 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: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 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: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a33 NUMBER := 0-1962.0724
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: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
57: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: )
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: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: )
66: as
142: , x_return_status out nocopy VARCHAR2
143: , x_msg_count out nocopy NUMBER
144: , x_msg_data out nocopy VARCHAR2
145: , p7_a0 NUMBER := 0-1962.0724
146: , p7_a1 DATE := fnd_api.g_miss_date
147: , p7_a2 NUMBER := 0-1962.0724
148: , p7_a3 DATE := fnd_api.g_miss_date
149: , p7_a4 NUMBER := 0-1962.0724
150: , p7_a5 NUMBER := 0-1962.0724
144: , x_msg_data out nocopy VARCHAR2
145: , p7_a0 NUMBER := 0-1962.0724
146: , p7_a1 DATE := fnd_api.g_miss_date
147: , p7_a2 NUMBER := 0-1962.0724
148: , p7_a3 DATE := fnd_api.g_miss_date
149: , p7_a4 NUMBER := 0-1962.0724
150: , p7_a5 NUMBER := 0-1962.0724
151: , p7_a6 NUMBER := 0-1962.0724
152: , p7_a7 NUMBER := 0-1962.0724
151: , p7_a6 NUMBER := 0-1962.0724
152: , p7_a7 NUMBER := 0-1962.0724
153: , p7_a8 NUMBER := 0-1962.0724
154: , p7_a9 NUMBER := 0-1962.0724
155: , p7_a10 DATE := fnd_api.g_miss_date
156: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a12 NUMBER := 0-1962.0724
158: , p7_a13 NUMBER := 0-1962.0724
159: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
152: , p7_a7 NUMBER := 0-1962.0724
153: , p7_a8 NUMBER := 0-1962.0724
154: , p7_a9 NUMBER := 0-1962.0724
155: , p7_a10 DATE := fnd_api.g_miss_date
156: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a12 NUMBER := 0-1962.0724
158: , p7_a13 NUMBER := 0-1962.0724
159: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a15 NUMBER := 0-1962.0724
155: , p7_a10 DATE := fnd_api.g_miss_date
156: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
157: , p7_a12 NUMBER := 0-1962.0724
158: , p7_a13 NUMBER := 0-1962.0724
159: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a15 NUMBER := 0-1962.0724
161: , p7_a16 NUMBER := 0-1962.0724
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
158: , p7_a13 NUMBER := 0-1962.0724
159: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a15 NUMBER := 0-1962.0724
161: , p7_a16 NUMBER := 0-1962.0724
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
159: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a15 NUMBER := 0-1962.0724
161: , p7_a16 NUMBER := 0-1962.0724
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
160: , p7_a15 NUMBER := 0-1962.0724
161: , p7_a16 NUMBER := 0-1962.0724
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
161: , p7_a16 NUMBER := 0-1962.0724
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
162: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
165: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
166: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
167: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
168: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a33 NUMBER := 0-1962.0724
171: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a33 NUMBER := 0-1962.0724
179: , p7_a34 NUMBER := 0-1962.0724
172: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a33 NUMBER := 0-1962.0724
179: , p7_a34 NUMBER := 0-1962.0724
180: )
173: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
174: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
175: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
176: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
177: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a33 NUMBER := 0-1962.0724
179: , p7_a34 NUMBER := 0-1962.0724
180: )
181: as
253: , x_return_status out nocopy VARCHAR2
254: , x_msg_count out nocopy NUMBER
255: , x_msg_data out nocopy VARCHAR2
256: , p6_a0 NUMBER := 0-1962.0724
257: , p6_a1 DATE := fnd_api.g_miss_date
258: , p6_a2 NUMBER := 0-1962.0724
259: , p6_a3 DATE := fnd_api.g_miss_date
260: , p6_a4 NUMBER := 0-1962.0724
261: , p6_a5 NUMBER := 0-1962.0724
255: , x_msg_data out nocopy VARCHAR2
256: , p6_a0 NUMBER := 0-1962.0724
257: , p6_a1 DATE := fnd_api.g_miss_date
258: , p6_a2 NUMBER := 0-1962.0724
259: , p6_a3 DATE := fnd_api.g_miss_date
260: , p6_a4 NUMBER := 0-1962.0724
261: , p6_a5 NUMBER := 0-1962.0724
262: , p6_a6 NUMBER := 0-1962.0724
263: , p6_a7 NUMBER := 0-1962.0724
262: , p6_a6 NUMBER := 0-1962.0724
263: , p6_a7 NUMBER := 0-1962.0724
264: , p6_a8 NUMBER := 0-1962.0724
265: , p6_a9 NUMBER := 0-1962.0724
266: , p6_a10 DATE := fnd_api.g_miss_date
267: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a12 NUMBER := 0-1962.0724
269: , p6_a13 NUMBER := 0-1962.0724
270: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
263: , p6_a7 NUMBER := 0-1962.0724
264: , p6_a8 NUMBER := 0-1962.0724
265: , p6_a9 NUMBER := 0-1962.0724
266: , p6_a10 DATE := fnd_api.g_miss_date
267: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a12 NUMBER := 0-1962.0724
269: , p6_a13 NUMBER := 0-1962.0724
270: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a15 NUMBER := 0-1962.0724
266: , p6_a10 DATE := fnd_api.g_miss_date
267: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
268: , p6_a12 NUMBER := 0-1962.0724
269: , p6_a13 NUMBER := 0-1962.0724
270: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a15 NUMBER := 0-1962.0724
272: , p6_a16 NUMBER := 0-1962.0724
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
269: , p6_a13 NUMBER := 0-1962.0724
270: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a15 NUMBER := 0-1962.0724
272: , p6_a16 NUMBER := 0-1962.0724
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
270: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a15 NUMBER := 0-1962.0724
272: , p6_a16 NUMBER := 0-1962.0724
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
271: , p6_a15 NUMBER := 0-1962.0724
272: , p6_a16 NUMBER := 0-1962.0724
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
272: , p6_a16 NUMBER := 0-1962.0724
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
273: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
274: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
275: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
276: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
277: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
278: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
279: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
280: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
281: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
289: , p6_a33 NUMBER := 0-1962.0724
282: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
289: , p6_a33 NUMBER := 0-1962.0724
290: , p6_a34 NUMBER := 0-1962.0724
283: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
289: , p6_a33 NUMBER := 0-1962.0724
290: , p6_a34 NUMBER := 0-1962.0724
291: )
284: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
285: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
286: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
287: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
288: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
289: , p6_a33 NUMBER := 0-1962.0724
290: , p6_a34 NUMBER := 0-1962.0724
291: )
292: as
357:
358: procedure check_lead_pss_line_items(p_validation_mode VARCHAR2
359: , x_return_status out nocopy VARCHAR2
360: , p2_a0 NUMBER := 0-1962.0724
361: , p2_a1 DATE := fnd_api.g_miss_date
362: , p2_a2 NUMBER := 0-1962.0724
363: , p2_a3 DATE := fnd_api.g_miss_date
364: , p2_a4 NUMBER := 0-1962.0724
365: , p2_a5 NUMBER := 0-1962.0724
359: , x_return_status out nocopy VARCHAR2
360: , p2_a0 NUMBER := 0-1962.0724
361: , p2_a1 DATE := fnd_api.g_miss_date
362: , p2_a2 NUMBER := 0-1962.0724
363: , p2_a3 DATE := fnd_api.g_miss_date
364: , p2_a4 NUMBER := 0-1962.0724
365: , p2_a5 NUMBER := 0-1962.0724
366: , p2_a6 NUMBER := 0-1962.0724
367: , p2_a7 NUMBER := 0-1962.0724
366: , p2_a6 NUMBER := 0-1962.0724
367: , p2_a7 NUMBER := 0-1962.0724
368: , p2_a8 NUMBER := 0-1962.0724
369: , p2_a9 NUMBER := 0-1962.0724
370: , p2_a10 DATE := fnd_api.g_miss_date
371: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
372: , p2_a12 NUMBER := 0-1962.0724
373: , p2_a13 NUMBER := 0-1962.0724
374: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
367: , p2_a7 NUMBER := 0-1962.0724
368: , p2_a8 NUMBER := 0-1962.0724
369: , p2_a9 NUMBER := 0-1962.0724
370: , p2_a10 DATE := fnd_api.g_miss_date
371: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
372: , p2_a12 NUMBER := 0-1962.0724
373: , p2_a13 NUMBER := 0-1962.0724
374: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
375: , p2_a15 NUMBER := 0-1962.0724
370: , p2_a10 DATE := fnd_api.g_miss_date
371: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
372: , p2_a12 NUMBER := 0-1962.0724
373: , p2_a13 NUMBER := 0-1962.0724
374: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
375: , p2_a15 NUMBER := 0-1962.0724
376: , p2_a16 NUMBER := 0-1962.0724
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
373: , p2_a13 NUMBER := 0-1962.0724
374: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
375: , p2_a15 NUMBER := 0-1962.0724
376: , p2_a16 NUMBER := 0-1962.0724
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
374: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
375: , p2_a15 NUMBER := 0-1962.0724
376: , p2_a16 NUMBER := 0-1962.0724
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
375: , p2_a15 NUMBER := 0-1962.0724
376: , p2_a16 NUMBER := 0-1962.0724
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
376: , p2_a16 NUMBER := 0-1962.0724
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
377: , p2_a17 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
378: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
379: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
380: , p2_a20 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
381: , p2_a21 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
382: , p2_a22 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
383: , p2_a23 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
384: , p2_a24 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a32 VARCHAR2 := fnd_api.g_miss_char
385: , p2_a25 VARCHAR2 := fnd_api.g_miss_char
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a32 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a33 NUMBER := 0-1962.0724
386: , p2_a26 VARCHAR2 := fnd_api.g_miss_char
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a32 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a33 NUMBER := 0-1962.0724
394: , p2_a34 NUMBER := 0-1962.0724
387: , p2_a27 VARCHAR2 := fnd_api.g_miss_char
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a32 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a33 NUMBER := 0-1962.0724
394: , p2_a34 NUMBER := 0-1962.0724
395: )
388: , p2_a28 VARCHAR2 := fnd_api.g_miss_char
389: , p2_a29 VARCHAR2 := fnd_api.g_miss_char
390: , p2_a30 VARCHAR2 := fnd_api.g_miss_char
391: , p2_a31 VARCHAR2 := fnd_api.g_miss_char
392: , p2_a32 VARCHAR2 := fnd_api.g_miss_char
393: , p2_a33 NUMBER := 0-1962.0724
394: , p2_a34 NUMBER := 0-1962.0724
395: )
396: as
449:
450: procedure check_lead_pss_line_record(p_mode VARCHAR2
451: , x_return_status out nocopy VARCHAR2
452: , p0_a0 NUMBER := 0-1962.0724
453: , p0_a1 DATE := fnd_api.g_miss_date
454: , p0_a2 NUMBER := 0-1962.0724
455: , p0_a3 DATE := fnd_api.g_miss_date
456: , p0_a4 NUMBER := 0-1962.0724
457: , p0_a5 NUMBER := 0-1962.0724
451: , x_return_status out nocopy VARCHAR2
452: , p0_a0 NUMBER := 0-1962.0724
453: , p0_a1 DATE := fnd_api.g_miss_date
454: , p0_a2 NUMBER := 0-1962.0724
455: , p0_a3 DATE := fnd_api.g_miss_date
456: , p0_a4 NUMBER := 0-1962.0724
457: , p0_a5 NUMBER := 0-1962.0724
458: , p0_a6 NUMBER := 0-1962.0724
459: , p0_a7 NUMBER := 0-1962.0724
458: , p0_a6 NUMBER := 0-1962.0724
459: , p0_a7 NUMBER := 0-1962.0724
460: , p0_a8 NUMBER := 0-1962.0724
461: , p0_a9 NUMBER := 0-1962.0724
462: , p0_a10 DATE := fnd_api.g_miss_date
463: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a12 NUMBER := 0-1962.0724
465: , p0_a13 NUMBER := 0-1962.0724
466: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
459: , p0_a7 NUMBER := 0-1962.0724
460: , p0_a8 NUMBER := 0-1962.0724
461: , p0_a9 NUMBER := 0-1962.0724
462: , p0_a10 DATE := fnd_api.g_miss_date
463: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a12 NUMBER := 0-1962.0724
465: , p0_a13 NUMBER := 0-1962.0724
466: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a15 NUMBER := 0-1962.0724
462: , p0_a10 DATE := fnd_api.g_miss_date
463: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
464: , p0_a12 NUMBER := 0-1962.0724
465: , p0_a13 NUMBER := 0-1962.0724
466: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a15 NUMBER := 0-1962.0724
468: , p0_a16 NUMBER := 0-1962.0724
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
465: , p0_a13 NUMBER := 0-1962.0724
466: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a15 NUMBER := 0-1962.0724
468: , p0_a16 NUMBER := 0-1962.0724
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
466: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a15 NUMBER := 0-1962.0724
468: , p0_a16 NUMBER := 0-1962.0724
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
467: , p0_a15 NUMBER := 0-1962.0724
468: , p0_a16 NUMBER := 0-1962.0724
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
468: , p0_a16 NUMBER := 0-1962.0724
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
469: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
470: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
471: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
472: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
473: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
474: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
475: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
476: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
477: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485: , p0_a33 NUMBER := 0-1962.0724
478: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485: , p0_a33 NUMBER := 0-1962.0724
486: , p0_a34 NUMBER := 0-1962.0724
479: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485: , p0_a33 NUMBER := 0-1962.0724
486: , p0_a34 NUMBER := 0-1962.0724
487: , p1_a0 NUMBER := 0-1962.0724
480: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
481: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
482: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
483: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485: , p0_a33 NUMBER := 0-1962.0724
486: , p0_a34 NUMBER := 0-1962.0724
487: , p1_a0 NUMBER := 0-1962.0724
488: , p1_a1 DATE := fnd_api.g_miss_date
484: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
485: , p0_a33 NUMBER := 0-1962.0724
486: , p0_a34 NUMBER := 0-1962.0724
487: , p1_a0 NUMBER := 0-1962.0724
488: , p1_a1 DATE := fnd_api.g_miss_date
489: , p1_a2 NUMBER := 0-1962.0724
490: , p1_a3 DATE := fnd_api.g_miss_date
491: , p1_a4 NUMBER := 0-1962.0724
492: , p1_a5 NUMBER := 0-1962.0724
486: , p0_a34 NUMBER := 0-1962.0724
487: , p1_a0 NUMBER := 0-1962.0724
488: , p1_a1 DATE := fnd_api.g_miss_date
489: , p1_a2 NUMBER := 0-1962.0724
490: , p1_a3 DATE := fnd_api.g_miss_date
491: , p1_a4 NUMBER := 0-1962.0724
492: , p1_a5 NUMBER := 0-1962.0724
493: , p1_a6 NUMBER := 0-1962.0724
494: , p1_a7 NUMBER := 0-1962.0724
493: , p1_a6 NUMBER := 0-1962.0724
494: , p1_a7 NUMBER := 0-1962.0724
495: , p1_a8 NUMBER := 0-1962.0724
496: , p1_a9 NUMBER := 0-1962.0724
497: , p1_a10 DATE := fnd_api.g_miss_date
498: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
499: , p1_a12 NUMBER := 0-1962.0724
500: , p1_a13 NUMBER := 0-1962.0724
501: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
494: , p1_a7 NUMBER := 0-1962.0724
495: , p1_a8 NUMBER := 0-1962.0724
496: , p1_a9 NUMBER := 0-1962.0724
497: , p1_a10 DATE := fnd_api.g_miss_date
498: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
499: , p1_a12 NUMBER := 0-1962.0724
500: , p1_a13 NUMBER := 0-1962.0724
501: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
502: , p1_a15 NUMBER := 0-1962.0724
497: , p1_a10 DATE := fnd_api.g_miss_date
498: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
499: , p1_a12 NUMBER := 0-1962.0724
500: , p1_a13 NUMBER := 0-1962.0724
501: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
502: , p1_a15 NUMBER := 0-1962.0724
503: , p1_a16 NUMBER := 0-1962.0724
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
500: , p1_a13 NUMBER := 0-1962.0724
501: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
502: , p1_a15 NUMBER := 0-1962.0724
503: , p1_a16 NUMBER := 0-1962.0724
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
501: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
502: , p1_a15 NUMBER := 0-1962.0724
503: , p1_a16 NUMBER := 0-1962.0724
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
502: , p1_a15 NUMBER := 0-1962.0724
503: , p1_a16 NUMBER := 0-1962.0724
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
503: , p1_a16 NUMBER := 0-1962.0724
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
504: , p1_a17 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
505: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
506: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
507: , p1_a20 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
508: , p1_a21 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
509: , p1_a22 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
510: , p1_a23 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
511: , p1_a24 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a32 VARCHAR2 := fnd_api.g_miss_char
512: , p1_a25 VARCHAR2 := fnd_api.g_miss_char
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a32 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a33 NUMBER := 0-1962.0724
513: , p1_a26 VARCHAR2 := fnd_api.g_miss_char
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a32 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a33 NUMBER := 0-1962.0724
521: , p1_a34 NUMBER := 0-1962.0724
514: , p1_a27 VARCHAR2 := fnd_api.g_miss_char
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a32 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a33 NUMBER := 0-1962.0724
521: , p1_a34 NUMBER := 0-1962.0724
522: )
515: , p1_a28 VARCHAR2 := fnd_api.g_miss_char
516: , p1_a29 VARCHAR2 := fnd_api.g_miss_char
517: , p1_a30 VARCHAR2 := fnd_api.g_miss_char
518: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
519: , p1_a32 VARCHAR2 := fnd_api.g_miss_char
520: , p1_a33 NUMBER := 0-1962.0724
521: , p1_a34 NUMBER := 0-1962.0724
522: )
523: as
732: , p1_a32 out nocopy VARCHAR2
733: , p1_a33 out nocopy NUMBER
734: , p1_a34 out nocopy NUMBER
735: , p0_a0 NUMBER := 0-1962.0724
736: , p0_a1 DATE := fnd_api.g_miss_date
737: , p0_a2 NUMBER := 0-1962.0724
738: , p0_a3 DATE := fnd_api.g_miss_date
739: , p0_a4 NUMBER := 0-1962.0724
740: , p0_a5 NUMBER := 0-1962.0724
734: , p1_a34 out nocopy NUMBER
735: , p0_a0 NUMBER := 0-1962.0724
736: , p0_a1 DATE := fnd_api.g_miss_date
737: , p0_a2 NUMBER := 0-1962.0724
738: , p0_a3 DATE := fnd_api.g_miss_date
739: , p0_a4 NUMBER := 0-1962.0724
740: , p0_a5 NUMBER := 0-1962.0724
741: , p0_a6 NUMBER := 0-1962.0724
742: , p0_a7 NUMBER := 0-1962.0724
741: , p0_a6 NUMBER := 0-1962.0724
742: , p0_a7 NUMBER := 0-1962.0724
743: , p0_a8 NUMBER := 0-1962.0724
744: , p0_a9 NUMBER := 0-1962.0724
745: , p0_a10 DATE := fnd_api.g_miss_date
746: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
747: , p0_a12 NUMBER := 0-1962.0724
748: , p0_a13 NUMBER := 0-1962.0724
749: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
742: , p0_a7 NUMBER := 0-1962.0724
743: , p0_a8 NUMBER := 0-1962.0724
744: , p0_a9 NUMBER := 0-1962.0724
745: , p0_a10 DATE := fnd_api.g_miss_date
746: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
747: , p0_a12 NUMBER := 0-1962.0724
748: , p0_a13 NUMBER := 0-1962.0724
749: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
750: , p0_a15 NUMBER := 0-1962.0724
745: , p0_a10 DATE := fnd_api.g_miss_date
746: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
747: , p0_a12 NUMBER := 0-1962.0724
748: , p0_a13 NUMBER := 0-1962.0724
749: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
750: , p0_a15 NUMBER := 0-1962.0724
751: , p0_a16 NUMBER := 0-1962.0724
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
748: , p0_a13 NUMBER := 0-1962.0724
749: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
750: , p0_a15 NUMBER := 0-1962.0724
751: , p0_a16 NUMBER := 0-1962.0724
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
749: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
750: , p0_a15 NUMBER := 0-1962.0724
751: , p0_a16 NUMBER := 0-1962.0724
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
750: , p0_a15 NUMBER := 0-1962.0724
751: , p0_a16 NUMBER := 0-1962.0724
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
751: , p0_a16 NUMBER := 0-1962.0724
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
752: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
753: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
754: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
755: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
756: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
757: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
758: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
759: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
760: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
768: , p0_a33 NUMBER := 0-1962.0724
761: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
768: , p0_a33 NUMBER := 0-1962.0724
769: , p0_a34 NUMBER := 0-1962.0724
762: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
768: , p0_a33 NUMBER := 0-1962.0724
769: , p0_a34 NUMBER := 0-1962.0724
770: )
763: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
764: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
765: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
766: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
767: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
768: , p0_a33 NUMBER := 0-1962.0724
769: , p0_a34 NUMBER := 0-1962.0724
770: )
771: as