APPS.AMS_LIST_QUERY_PVT_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_p2(t OUT NOCOPY ams_list_query_pvt.sql_string_tbl, a0 JTF_VARCHAR2_TABLE_4000) as

Line 113: , p7_a1 DATE := fnd_api.g_miss_date

109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , x_list_query_id OUT NOCOPY NUMBER
112: , p7_a0 NUMBER := 0-1962.0724
113: , p7_a1 DATE := fnd_api.g_miss_date
114: , p7_a2 NUMBER := 0-1962.0724
115: , p7_a3 DATE := fnd_api.g_miss_date
116: , p7_a4 NUMBER := 0-1962.0724
117: , p7_a5 NUMBER := 0-1962.0724

Line 115: , p7_a3 DATE := fnd_api.g_miss_date

111: , x_list_query_id OUT NOCOPY NUMBER
112: , p7_a0 NUMBER := 0-1962.0724
113: , p7_a1 DATE := fnd_api.g_miss_date
114: , p7_a2 NUMBER := 0-1962.0724
115: , p7_a3 DATE := fnd_api.g_miss_date
116: , p7_a4 NUMBER := 0-1962.0724
117: , p7_a5 NUMBER := 0-1962.0724
118: , p7_a6 NUMBER := 0-1962.0724
119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

115: , p7_a3 DATE := fnd_api.g_miss_date
116: , p7_a4 NUMBER := 0-1962.0724
117: , p7_a5 NUMBER := 0-1962.0724
118: , p7_a6 NUMBER := 0-1962.0724
119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

116: , p7_a4 NUMBER := 0-1962.0724
117: , p7_a5 NUMBER := 0-1962.0724
118: , p7_a6 NUMBER := 0-1962.0724
119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

117: , p7_a5 NUMBER := 0-1962.0724
118: , p7_a6 NUMBER := 0-1962.0724
119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

118: , p7_a6 NUMBER := 0-1962.0724
119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724

Line 123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

119: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

120: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a16 NUMBER := 0-1962.0724

Line 125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

121: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a16 NUMBER := 0-1962.0724
129: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

123: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a16 NUMBER := 0-1962.0724
129: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a19 NUMBER := 0-1962.0724

Line 129: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

125: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a16 NUMBER := 0-1962.0724
129: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a19 NUMBER := 0-1962.0724
132: , p7_a20 NUMBER := 0-1962.0724
133: )

Line 130: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

126: , p7_a14 NUMBER := 0-1962.0724
127: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a16 NUMBER := 0-1962.0724
129: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a19 NUMBER := 0-1962.0724
132: , p7_a20 NUMBER := 0-1962.0724
133: )
134: as

Line 202: , p7_a1 DATE := fnd_api.g_miss_date

198: , x_msg_data OUT NOCOPY VARCHAR2
199: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
200: , x_parent_list_query_id OUT NOCOPY NUMBER
201: , p7_a0 NUMBER := 0-1962.0724
202: , p7_a1 DATE := fnd_api.g_miss_date
203: , p7_a2 NUMBER := 0-1962.0724
204: , p7_a3 DATE := fnd_api.g_miss_date
205: , p7_a4 NUMBER := 0-1962.0724
206: , p7_a5 NUMBER := 0-1962.0724

Line 204: , p7_a3 DATE := fnd_api.g_miss_date

200: , x_parent_list_query_id OUT NOCOPY NUMBER
201: , p7_a0 NUMBER := 0-1962.0724
202: , p7_a1 DATE := fnd_api.g_miss_date
203: , p7_a2 NUMBER := 0-1962.0724
204: , p7_a3 DATE := fnd_api.g_miss_date
205: , p7_a4 NUMBER := 0-1962.0724
206: , p7_a5 NUMBER := 0-1962.0724
207: , p7_a6 NUMBER := 0-1962.0724
208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

204: , p7_a3 DATE := fnd_api.g_miss_date
205: , p7_a4 NUMBER := 0-1962.0724
206: , p7_a5 NUMBER := 0-1962.0724
207: , p7_a6 NUMBER := 0-1962.0724
208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

205: , p7_a4 NUMBER := 0-1962.0724
206: , p7_a5 NUMBER := 0-1962.0724
207: , p7_a6 NUMBER := 0-1962.0724
208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

206: , p7_a5 NUMBER := 0-1962.0724
207: , p7_a6 NUMBER := 0-1962.0724
208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

207: , p7_a6 NUMBER := 0-1962.0724
208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724

Line 212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

208: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724
216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

209: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724
216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a16 NUMBER := 0-1962.0724

Line 214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

210: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
211: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724
216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a16 NUMBER := 0-1962.0724
218: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

212: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
213: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724
216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a16 NUMBER := 0-1962.0724
218: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a18 NUMBER := 0-1962.0724
220: , p7_a19 NUMBER := 0-1962.0724

Line 218: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

214: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a14 NUMBER := 0-1962.0724
216: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
217: , p7_a16 NUMBER := 0-1962.0724
218: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a18 NUMBER := 0-1962.0724
220: , p7_a19 NUMBER := 0-1962.0724
221: )
222: as

Line 293: , p7_a1 DATE := fnd_api.g_miss_date

289: , x_msg_count OUT NOCOPY NUMBER
290: , x_msg_data OUT NOCOPY VARCHAR2
291: , x_object_version_number OUT NOCOPY NUMBER
292: , p7_a0 NUMBER := 0-1962.0724
293: , p7_a1 DATE := fnd_api.g_miss_date
294: , p7_a2 NUMBER := 0-1962.0724
295: , p7_a3 DATE := fnd_api.g_miss_date
296: , p7_a4 NUMBER := 0-1962.0724
297: , p7_a5 NUMBER := 0-1962.0724

Line 295: , p7_a3 DATE := fnd_api.g_miss_date

291: , x_object_version_number OUT NOCOPY NUMBER
292: , p7_a0 NUMBER := 0-1962.0724
293: , p7_a1 DATE := fnd_api.g_miss_date
294: , p7_a2 NUMBER := 0-1962.0724
295: , p7_a3 DATE := fnd_api.g_miss_date
296: , p7_a4 NUMBER := 0-1962.0724
297: , p7_a5 NUMBER := 0-1962.0724
298: , p7_a6 NUMBER := 0-1962.0724
299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

295: , p7_a3 DATE := fnd_api.g_miss_date
296: , p7_a4 NUMBER := 0-1962.0724
297: , p7_a5 NUMBER := 0-1962.0724
298: , p7_a6 NUMBER := 0-1962.0724
299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

296: , p7_a4 NUMBER := 0-1962.0724
297: , p7_a5 NUMBER := 0-1962.0724
298: , p7_a6 NUMBER := 0-1962.0724
299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

297: , p7_a5 NUMBER := 0-1962.0724
298: , p7_a6 NUMBER := 0-1962.0724
299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

298: , p7_a6 NUMBER := 0-1962.0724
299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724

Line 303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

299: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

300: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a16 NUMBER := 0-1962.0724

Line 305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

301: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a16 NUMBER := 0-1962.0724
309: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

303: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a16 NUMBER := 0-1962.0724
309: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a19 NUMBER := 0-1962.0724

Line 309: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

305: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a16 NUMBER := 0-1962.0724
309: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a19 NUMBER := 0-1962.0724
312: , p7_a20 NUMBER := 0-1962.0724
313: )

Line 310: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

306: , p7_a14 NUMBER := 0-1962.0724
307: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a16 NUMBER := 0-1962.0724
309: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a19 NUMBER := 0-1962.0724
312: , p7_a20 NUMBER := 0-1962.0724
313: )
314: as

Line 382: , p7_a1 DATE := fnd_api.g_miss_date

378: , x_msg_data OUT NOCOPY VARCHAR2
379: , p_sql_string_tbl JTF_VARCHAR2_TABLE_4000
380: , x_object_version_number OUT NOCOPY NUMBER
381: , p7_a0 NUMBER := 0-1962.0724
382: , p7_a1 DATE := fnd_api.g_miss_date
383: , p7_a2 NUMBER := 0-1962.0724
384: , p7_a3 DATE := fnd_api.g_miss_date
385: , p7_a4 NUMBER := 0-1962.0724
386: , p7_a5 NUMBER := 0-1962.0724

Line 384: , p7_a3 DATE := fnd_api.g_miss_date

380: , x_object_version_number OUT NOCOPY NUMBER
381: , p7_a0 NUMBER := 0-1962.0724
382: , p7_a1 DATE := fnd_api.g_miss_date
383: , p7_a2 NUMBER := 0-1962.0724
384: , p7_a3 DATE := fnd_api.g_miss_date
385: , p7_a4 NUMBER := 0-1962.0724
386: , p7_a5 NUMBER := 0-1962.0724
387: , p7_a6 NUMBER := 0-1962.0724
388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

384: , p7_a3 DATE := fnd_api.g_miss_date
385: , p7_a4 NUMBER := 0-1962.0724
386: , p7_a5 NUMBER := 0-1962.0724
387: , p7_a6 NUMBER := 0-1962.0724
388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

385: , p7_a4 NUMBER := 0-1962.0724
386: , p7_a5 NUMBER := 0-1962.0724
387: , p7_a6 NUMBER := 0-1962.0724
388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

386: , p7_a5 NUMBER := 0-1962.0724
387: , p7_a6 NUMBER := 0-1962.0724
388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

387: , p7_a6 NUMBER := 0-1962.0724
388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724

Line 392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

388: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724
396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

389: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724
396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
397: , p7_a16 NUMBER := 0-1962.0724

Line 394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

390: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
391: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724
396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
397: , p7_a16 NUMBER := 0-1962.0724
398: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

392: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
393: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724
396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
397: , p7_a16 NUMBER := 0-1962.0724
398: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
399: , p7_a18 NUMBER := 0-1962.0724
400: , p7_a19 NUMBER := 0-1962.0724

Line 398: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

394: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
395: , p7_a14 NUMBER := 0-1962.0724
396: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
397: , p7_a16 NUMBER := 0-1962.0724
398: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
399: , p7_a18 NUMBER := 0-1962.0724
400: , p7_a19 NUMBER := 0-1962.0724
401: )
402: as

Line 471: , p3_a1 DATE := fnd_api.g_miss_date

467: , x_return_status OUT NOCOPY VARCHAR2
468: , x_msg_count OUT NOCOPY NUMBER
469: , x_msg_data OUT NOCOPY VARCHAR2
470: , p3_a0 NUMBER := 0-1962.0724
471: , p3_a1 DATE := fnd_api.g_miss_date
472: , p3_a2 NUMBER := 0-1962.0724
473: , p3_a3 DATE := fnd_api.g_miss_date
474: , p3_a4 NUMBER := 0-1962.0724
475: , p3_a5 NUMBER := 0-1962.0724

Line 473: , p3_a3 DATE := fnd_api.g_miss_date

469: , x_msg_data OUT NOCOPY VARCHAR2
470: , p3_a0 NUMBER := 0-1962.0724
471: , p3_a1 DATE := fnd_api.g_miss_date
472: , p3_a2 NUMBER := 0-1962.0724
473: , p3_a3 DATE := fnd_api.g_miss_date
474: , p3_a4 NUMBER := 0-1962.0724
475: , p3_a5 NUMBER := 0-1962.0724
476: , p3_a6 NUMBER := 0-1962.0724
477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

Line 477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

473: , p3_a3 DATE := fnd_api.g_miss_date
474: , p3_a4 NUMBER := 0-1962.0724
475: , p3_a5 NUMBER := 0-1962.0724
476: , p3_a6 NUMBER := 0-1962.0724
477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

474: , p3_a4 NUMBER := 0-1962.0724
475: , p3_a5 NUMBER := 0-1962.0724
476: , p3_a6 NUMBER := 0-1962.0724
477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

Line 479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

475: , p3_a5 NUMBER := 0-1962.0724
476: , p3_a6 NUMBER := 0-1962.0724
477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

Line 480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

476: , p3_a6 NUMBER := 0-1962.0724
477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724

Line 481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

477: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

Line 482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

478: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
486: , p3_a16 NUMBER := 0-1962.0724

Line 483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

479: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
480: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
486: , p3_a16 NUMBER := 0-1962.0724
487: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

Line 485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

481: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
482: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
486: , p3_a16 NUMBER := 0-1962.0724
487: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
488: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
489: , p3_a19 NUMBER := 0-1962.0724

Line 487: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

483: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
486: , p3_a16 NUMBER := 0-1962.0724
487: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
488: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
489: , p3_a19 NUMBER := 0-1962.0724
490: , p3_a20 NUMBER := 0-1962.0724
491: )

Line 488: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

484: , p3_a14 NUMBER := 0-1962.0724
485: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
486: , p3_a16 NUMBER := 0-1962.0724
487: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
488: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
489: , p3_a19 NUMBER := 0-1962.0724
490: , p3_a20 NUMBER := 0-1962.0724
491: )
492: as

Line 547: , p0_a1 DATE := fnd_api.g_miss_date

543:
544: procedure check_list_query_items(p_validation_mode VARCHAR2
545: , x_return_status OUT NOCOPY VARCHAR2
546: , p0_a0 NUMBER := 0-1962.0724
547: , p0_a1 DATE := fnd_api.g_miss_date
548: , p0_a2 NUMBER := 0-1962.0724
549: , p0_a3 DATE := fnd_api.g_miss_date
550: , p0_a4 NUMBER := 0-1962.0724
551: , p0_a5 NUMBER := 0-1962.0724

Line 549: , p0_a3 DATE := fnd_api.g_miss_date

545: , x_return_status OUT NOCOPY VARCHAR2
546: , p0_a0 NUMBER := 0-1962.0724
547: , p0_a1 DATE := fnd_api.g_miss_date
548: , p0_a2 NUMBER := 0-1962.0724
549: , p0_a3 DATE := fnd_api.g_miss_date
550: , p0_a4 NUMBER := 0-1962.0724
551: , p0_a5 NUMBER := 0-1962.0724
552: , p0_a6 NUMBER := 0-1962.0724
553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

549: , p0_a3 DATE := fnd_api.g_miss_date
550: , p0_a4 NUMBER := 0-1962.0724
551: , p0_a5 NUMBER := 0-1962.0724
552: , p0_a6 NUMBER := 0-1962.0724
553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

550: , p0_a4 NUMBER := 0-1962.0724
551: , p0_a5 NUMBER := 0-1962.0724
552: , p0_a6 NUMBER := 0-1962.0724
553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

551: , p0_a5 NUMBER := 0-1962.0724
552: , p0_a6 NUMBER := 0-1962.0724
553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

552: , p0_a6 NUMBER := 0-1962.0724
553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724

Line 557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

553: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

554: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a16 NUMBER := 0-1962.0724

Line 559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

555: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
556: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a16 NUMBER := 0-1962.0724
563: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

557: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
558: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a16 NUMBER := 0-1962.0724
563: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a19 NUMBER := 0-1962.0724

Line 563: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

559: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a16 NUMBER := 0-1962.0724
563: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a19 NUMBER := 0-1962.0724
566: , p0_a20 NUMBER := 0-1962.0724
567: )

Line 564: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

560: , p0_a14 NUMBER := 0-1962.0724
561: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
562: , p0_a16 NUMBER := 0-1962.0724
563: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
564: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
565: , p0_a19 NUMBER := 0-1962.0724
566: , p0_a20 NUMBER := 0-1962.0724
567: )
568: as

Line 614: , p5_a1 DATE := fnd_api.g_miss_date

610: , x_return_status OUT NOCOPY VARCHAR2
611: , x_msg_count OUT NOCOPY NUMBER
612: , x_msg_data OUT NOCOPY VARCHAR2
613: , p5_a0 NUMBER := 0-1962.0724
614: , p5_a1 DATE := fnd_api.g_miss_date
615: , p5_a2 NUMBER := 0-1962.0724
616: , p5_a3 DATE := fnd_api.g_miss_date
617: , p5_a4 NUMBER := 0-1962.0724
618: , p5_a5 NUMBER := 0-1962.0724

Line 616: , p5_a3 DATE := fnd_api.g_miss_date

612: , x_msg_data OUT NOCOPY VARCHAR2
613: , p5_a0 NUMBER := 0-1962.0724
614: , p5_a1 DATE := fnd_api.g_miss_date
615: , p5_a2 NUMBER := 0-1962.0724
616: , p5_a3 DATE := fnd_api.g_miss_date
617: , p5_a4 NUMBER := 0-1962.0724
618: , p5_a5 NUMBER := 0-1962.0724
619: , p5_a6 NUMBER := 0-1962.0724
620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

616: , p5_a3 DATE := fnd_api.g_miss_date
617: , p5_a4 NUMBER := 0-1962.0724
618: , p5_a5 NUMBER := 0-1962.0724
619: , p5_a6 NUMBER := 0-1962.0724
620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

617: , p5_a4 NUMBER := 0-1962.0724
618: , p5_a5 NUMBER := 0-1962.0724
619: , p5_a6 NUMBER := 0-1962.0724
620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

618: , p5_a5 NUMBER := 0-1962.0724
619: , p5_a6 NUMBER := 0-1962.0724
620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

619: , p5_a6 NUMBER := 0-1962.0724
620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724

Line 624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

620: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

621: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a16 NUMBER := 0-1962.0724

Line 626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

622: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a16 NUMBER := 0-1962.0724
630: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

624: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a16 NUMBER := 0-1962.0724
630: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a19 NUMBER := 0-1962.0724

Line 630: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

626: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a16 NUMBER := 0-1962.0724
630: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a19 NUMBER := 0-1962.0724
633: , p5_a20 NUMBER := 0-1962.0724
634: )

Line 631: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

627: , p5_a14 NUMBER := 0-1962.0724
628: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a16 NUMBER := 0-1962.0724
630: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a19 NUMBER := 0-1962.0724
633: , p5_a20 NUMBER := 0-1962.0724
634: )
635: as