APPS.AS_SALES_LEAD_REFERRAL_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

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;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; 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 rosetta_table_copy_in_p53(t OUT NOCOPY as_sales_lead_referral.t_overriding_usernames, a0 JTF_VARCHAR2_TABLE_100) as

Line 135: , p9_a1 DATE := fnd_api.g_miss_date

131: , x_return_status OUT NOCOPY VARCHAR2
132: , x_msg_count OUT NOCOPY NUMBER
133: , x_msg_data OUT NOCOPY VARCHAR2
134: , p9_a0 NUMBER := 0-1962.0724
135: , p9_a1 DATE := fnd_api.g_miss_date
136: , p9_a2 NUMBER := 0-1962.0724
137: , p9_a3 DATE := fnd_api.g_miss_date
138: , p9_a4 NUMBER := 0-1962.0724
139: , p9_a5 NUMBER := 0-1962.0724

Line 137: , p9_a3 DATE := fnd_api.g_miss_date

133: , x_msg_data OUT NOCOPY VARCHAR2
134: , p9_a0 NUMBER := 0-1962.0724
135: , p9_a1 DATE := fnd_api.g_miss_date
136: , p9_a2 NUMBER := 0-1962.0724
137: , p9_a3 DATE := fnd_api.g_miss_date
138: , p9_a4 NUMBER := 0-1962.0724
139: , p9_a5 NUMBER := 0-1962.0724
140: , p9_a6 NUMBER := 0-1962.0724
141: , p9_a7 NUMBER := 0-1962.0724

Line 143: , p9_a9 DATE := fnd_api.g_miss_date

139: , p9_a5 NUMBER := 0-1962.0724
140: , p9_a6 NUMBER := 0-1962.0724
141: , p9_a7 NUMBER := 0-1962.0724
142: , p9_a8 NUMBER := 0-1962.0724
143: , p9_a9 DATE := fnd_api.g_miss_date
144: , p9_a10 VARCHAR2 := fnd_api.g_miss_char
145: , p9_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p9_a12 NUMBER := 0-1962.0724
147: , p9_a13 NUMBER := 0-1962.0724

Line 144: , p9_a10 VARCHAR2 := fnd_api.g_miss_char

140: , p9_a6 NUMBER := 0-1962.0724
141: , p9_a7 NUMBER := 0-1962.0724
142: , p9_a8 NUMBER := 0-1962.0724
143: , p9_a9 DATE := fnd_api.g_miss_date
144: , p9_a10 VARCHAR2 := fnd_api.g_miss_char
145: , p9_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p9_a12 NUMBER := 0-1962.0724
147: , p9_a13 NUMBER := 0-1962.0724
148: , p9_a14 NUMBER := 0-1962.0724

Line 145: , p9_a11 VARCHAR2 := fnd_api.g_miss_char

141: , p9_a7 NUMBER := 0-1962.0724
142: , p9_a8 NUMBER := 0-1962.0724
143: , p9_a9 DATE := fnd_api.g_miss_date
144: , p9_a10 VARCHAR2 := fnd_api.g_miss_char
145: , p9_a11 VARCHAR2 := fnd_api.g_miss_char
146: , p9_a12 NUMBER := 0-1962.0724
147: , p9_a13 NUMBER := 0-1962.0724
148: , p9_a14 NUMBER := 0-1962.0724
149: , p9_a15 NUMBER := 0-1962.0724

Line 150: , p9_a16 VARCHAR2 := fnd_api.g_miss_char

146: , p9_a12 NUMBER := 0-1962.0724
147: , p9_a13 NUMBER := 0-1962.0724
148: , p9_a14 NUMBER := 0-1962.0724
149: , p9_a15 NUMBER := 0-1962.0724
150: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char

Line 151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char

147: , p9_a13 NUMBER := 0-1962.0724
148: , p9_a14 NUMBER := 0-1962.0724
149: , p9_a15 NUMBER := 0-1962.0724
150: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char

Line 152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char

148: , p9_a14 NUMBER := 0-1962.0724
149: , p9_a15 NUMBER := 0-1962.0724
150: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char

Line 154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char

150: , p9_a16 VARCHAR2 := fnd_api.g_miss_char
151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char

Line 155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char

151: , p9_a17 VARCHAR2 := fnd_api.g_miss_char
152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char

Line 156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char

152: , p9_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p9_a19 NUMBER := 0-1962.0724
154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char

Line 158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char

154: , p9_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char

Line 159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char

155: , p9_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char

Line 160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char

156: , p9_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char

Line 161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char

157: , p9_a23 NUMBER := 0-1962.0724
158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char

Line 162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char

158: , p9_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char

Line 163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char

159: , p9_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char

Line 164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char

160: , p9_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char

Line 165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char

161: , p9_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char

Line 166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char

162: , p9_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char

Line 167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char

163: , p9_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char

Line 168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char

164: , p9_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char

Line 169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char

165: , p9_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char

Line 170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char

166: , p9_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char

Line 171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char

167: , p9_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char

Line 172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char

168: , p9_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char

Line 173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char

169: , p9_a35 VARCHAR2 := fnd_api.g_miss_char
170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
177: , p9_a43 NUMBER := 0-1962.0724

Line 174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char

170: , p9_a36 VARCHAR2 := fnd_api.g_miss_char
171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
177: , p9_a43 NUMBER := 0-1962.0724
178: , p9_a44 NUMBER := 0-1962.0724

Line 175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char

171: , p9_a37 VARCHAR2 := fnd_api.g_miss_char
172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
177: , p9_a43 NUMBER := 0-1962.0724
178: , p9_a44 NUMBER := 0-1962.0724
179: , p9_a45 NUMBER := 0-1962.0724

Line 176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char

172: , p9_a38 VARCHAR2 := fnd_api.g_miss_char
173: , p9_a39 VARCHAR2 := fnd_api.g_miss_char
174: , p9_a40 VARCHAR2 := fnd_api.g_miss_char
175: , p9_a41 VARCHAR2 := fnd_api.g_miss_char
176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
177: , p9_a43 NUMBER := 0-1962.0724
178: , p9_a44 NUMBER := 0-1962.0724
179: , p9_a45 NUMBER := 0-1962.0724
180: , p9_a46 DATE := fnd_api.g_miss_date

Line 180: , p9_a46 DATE := fnd_api.g_miss_date

176: , p9_a42 VARCHAR2 := fnd_api.g_miss_char
177: , p9_a43 NUMBER := 0-1962.0724
178: , p9_a44 NUMBER := 0-1962.0724
179: , p9_a45 NUMBER := 0-1962.0724
180: , p9_a46 DATE := fnd_api.g_miss_date
181: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724

Line 181: , p9_a47 VARCHAR2 := fnd_api.g_miss_char

177: , p9_a43 NUMBER := 0-1962.0724
178: , p9_a44 NUMBER := 0-1962.0724
179: , p9_a45 NUMBER := 0-1962.0724
180: , p9_a46 DATE := fnd_api.g_miss_date
181: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724

Line 182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char

178: , p9_a44 NUMBER := 0-1962.0724
179: , p9_a45 NUMBER := 0-1962.0724
180: , p9_a46 DATE := fnd_api.g_miss_date
181: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char

Line 183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char

179: , p9_a45 NUMBER := 0-1962.0724
180: , p9_a46 DATE := fnd_api.g_miss_date
181: , p9_a47 VARCHAR2 := fnd_api.g_miss_char
182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char

Line 186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char

182: , p9_a48 VARCHAR2 := fnd_api.g_miss_char
183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char
189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char
190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char

Line 187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char

183: , p9_a49 VARCHAR2 := fnd_api.g_miss_char
184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char
189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char
190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
191: , p9_a57 NUMBER := 0-1962.0724

Line 188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char

184: , p9_a50 NUMBER := 0-1962.0724
185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char
189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char
190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
191: , p9_a57 NUMBER := 0-1962.0724
192: , p9_a58 NUMBER := 0-1962.0724

Line 189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char

185: , p9_a51 NUMBER := 0-1962.0724
186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char
189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char
190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
191: , p9_a57 NUMBER := 0-1962.0724
192: , p9_a58 NUMBER := 0-1962.0724
193: , p9_a59 NUMBER := 0-1962.0724

Line 190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char

186: , p9_a52 VARCHAR2 := fnd_api.g_miss_char
187: , p9_a53 VARCHAR2 := fnd_api.g_miss_char
188: , p9_a54 VARCHAR2 := fnd_api.g_miss_char
189: , p9_a55 VARCHAR2 := fnd_api.g_miss_char
190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
191: , p9_a57 NUMBER := 0-1962.0724
192: , p9_a58 NUMBER := 0-1962.0724
193: , p9_a59 NUMBER := 0-1962.0724
194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char

Line 194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char

190: , p9_a56 VARCHAR2 := fnd_api.g_miss_char
191: , p9_a57 NUMBER := 0-1962.0724
192: , p9_a58 NUMBER := 0-1962.0724
193: , p9_a59 NUMBER := 0-1962.0724
194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char
195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char

Line 195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char

191: , p9_a57 NUMBER := 0-1962.0724
192: , p9_a58 NUMBER := 0-1962.0724
193: , p9_a59 NUMBER := 0-1962.0724
194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char
195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char

Line 196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char

192: , p9_a58 NUMBER := 0-1962.0724
193: , p9_a59 NUMBER := 0-1962.0724
194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char
195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char

Line 197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char

193: , p9_a59 NUMBER := 0-1962.0724
194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char
195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char

Line 198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char

194: , p9_a60 VARCHAR2 := fnd_api.g_miss_char
195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char
202: , p9_a68 NUMBER := 0-1962.0724

Line 199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char

195: , p9_a61 VARCHAR2 := fnd_api.g_miss_char
196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char
202: , p9_a68 NUMBER := 0-1962.0724
203: , p9_a69 NUMBER := 0-1962.0724

Line 200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char

196: , p9_a62 VARCHAR2 := fnd_api.g_miss_char
197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char
202: , p9_a68 NUMBER := 0-1962.0724
203: , p9_a69 NUMBER := 0-1962.0724
204: , p9_a70 NUMBER := 0-1962.0724

Line 201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char

197: , p9_a63 VARCHAR2 := fnd_api.g_miss_char
198: , p9_a64 VARCHAR2 := fnd_api.g_miss_char
199: , p9_a65 VARCHAR2 := fnd_api.g_miss_char
200: , p9_a66 VARCHAR2 := fnd_api.g_miss_char
201: , p9_a67 VARCHAR2 := fnd_api.g_miss_char
202: , p9_a68 NUMBER := 0-1962.0724
203: , p9_a69 NUMBER := 0-1962.0724
204: , p9_a70 NUMBER := 0-1962.0724
205: , p9_a71 NUMBER := 0-1962.0724

Line 206: , p9_a72 VARCHAR2 := fnd_api.g_miss_char

202: , p9_a68 NUMBER := 0-1962.0724
203: , p9_a69 NUMBER := 0-1962.0724
204: , p9_a70 NUMBER := 0-1962.0724
205: , p9_a71 NUMBER := 0-1962.0724
206: , p9_a72 VARCHAR2 := fnd_api.g_miss_char
207: , p9_a73 VARCHAR2 := fnd_api.g_miss_char
208: , p9_a74 VARCHAR2 := fnd_api.g_miss_char
209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char
210: , p9_a76 NUMBER := 0-1962.0724

Line 207: , p9_a73 VARCHAR2 := fnd_api.g_miss_char

203: , p9_a69 NUMBER := 0-1962.0724
204: , p9_a70 NUMBER := 0-1962.0724
205: , p9_a71 NUMBER := 0-1962.0724
206: , p9_a72 VARCHAR2 := fnd_api.g_miss_char
207: , p9_a73 VARCHAR2 := fnd_api.g_miss_char
208: , p9_a74 VARCHAR2 := fnd_api.g_miss_char
209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char
210: , p9_a76 NUMBER := 0-1962.0724
211: , p9_a77 NUMBER := 0-1962.0724

Line 208: , p9_a74 VARCHAR2 := fnd_api.g_miss_char

204: , p9_a70 NUMBER := 0-1962.0724
205: , p9_a71 NUMBER := 0-1962.0724
206: , p9_a72 VARCHAR2 := fnd_api.g_miss_char
207: , p9_a73 VARCHAR2 := fnd_api.g_miss_char
208: , p9_a74 VARCHAR2 := fnd_api.g_miss_char
209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char
210: , p9_a76 NUMBER := 0-1962.0724
211: , p9_a77 NUMBER := 0-1962.0724
212: , p9_a78 NUMBER := 0-1962.0724

Line 209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char

205: , p9_a71 NUMBER := 0-1962.0724
206: , p9_a72 VARCHAR2 := fnd_api.g_miss_char
207: , p9_a73 VARCHAR2 := fnd_api.g_miss_char
208: , p9_a74 VARCHAR2 := fnd_api.g_miss_char
209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char
210: , p9_a76 NUMBER := 0-1962.0724
211: , p9_a77 NUMBER := 0-1962.0724
212: , p9_a78 NUMBER := 0-1962.0724
213: , p9_a79 DATE := fnd_api.g_miss_date

Line 213: , p9_a79 DATE := fnd_api.g_miss_date

209: , p9_a75 VARCHAR2 := fnd_api.g_miss_char
210: , p9_a76 NUMBER := 0-1962.0724
211: , p9_a77 NUMBER := 0-1962.0724
212: , p9_a78 NUMBER := 0-1962.0724
213: , p9_a79 DATE := fnd_api.g_miss_date
214: , p9_a80 VARCHAR2 := fnd_api.g_miss_char
215: , p9_a81 VARCHAR2 := fnd_api.g_miss_char
216: )
217:

Line 214: , p9_a80 VARCHAR2 := fnd_api.g_miss_char

210: , p9_a76 NUMBER := 0-1962.0724
211: , p9_a77 NUMBER := 0-1962.0724
212: , p9_a78 NUMBER := 0-1962.0724
213: , p9_a79 DATE := fnd_api.g_miss_date
214: , p9_a80 VARCHAR2 := fnd_api.g_miss_char
215: , p9_a81 VARCHAR2 := fnd_api.g_miss_char
216: )
217:
218: as

Line 215: , p9_a81 VARCHAR2 := fnd_api.g_miss_char

211: , p9_a77 NUMBER := 0-1962.0724
212: , p9_a78 NUMBER := 0-1962.0724
213: , p9_a79 DATE := fnd_api.g_miss_date
214: , p9_a80 VARCHAR2 := fnd_api.g_miss_char
215: , p9_a81 VARCHAR2 := fnd_api.g_miss_char
216: )
217:
218: as
219: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;