APPS.OZF_DENORM_QUERIES_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_p1(t OUT NOCOPY ozf_denorm_queries_pvt.stringarray, a0 JTF_VARCHAR2_TABLE_4000) as

Line 72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , x_denorm_query_id OUT NOCOPY NUMBER
71: , p4_a0 NUMBER := 0-1962.0724
72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

69: , x_msg_data OUT NOCOPY VARCHAR2
70: , x_denorm_query_id OUT NOCOPY NUMBER
71: , p4_a0 NUMBER := 0-1962.0724
72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

70: , x_denorm_query_id OUT NOCOPY NUMBER
71: , p4_a0 NUMBER := 0-1962.0724
72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

71: , p4_a0 NUMBER := 0-1962.0724
72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date

Line 76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

72: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date
80: , p4_a9 NUMBER := 0-1962.0724

Line 77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

73: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date
80: , p4_a9 NUMBER := 0-1962.0724
81: , p4_a10 DATE := fnd_api.g_miss_date

Line 78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

74: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date
80: , p4_a9 NUMBER := 0-1962.0724
81: , p4_a10 DATE := fnd_api.g_miss_date
82: , p4_a11 NUMBER := 0-1962.0724

Line 79: , p4_a8 DATE := fnd_api.g_miss_date

75: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
76: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date
80: , p4_a9 NUMBER := 0-1962.0724
81: , p4_a10 DATE := fnd_api.g_miss_date
82: , p4_a11 NUMBER := 0-1962.0724
83: , p4_a12 NUMBER := 0-1962.0724

Line 81: , p4_a10 DATE := fnd_api.g_miss_date

77: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
78: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
79: , p4_a8 DATE := fnd_api.g_miss_date
80: , p4_a9 NUMBER := 0-1962.0724
81: , p4_a10 DATE := fnd_api.g_miss_date
82: , p4_a11 NUMBER := 0-1962.0724
83: , p4_a12 NUMBER := 0-1962.0724
84: , p4_a13 NUMBER := 0-1962.0724
85: , p4_a14 NUMBER := 0-1962.0724

Line 147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

143: , x_return_status OUT NOCOPY VARCHAR2
144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p4_a0 NUMBER := 0-1962.0724
147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

144: , x_msg_count OUT NOCOPY NUMBER
145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p4_a0 NUMBER := 0-1962.0724
147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

145: , x_msg_data OUT NOCOPY VARCHAR2
146: , p4_a0 NUMBER := 0-1962.0724
147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

146: , p4_a0 NUMBER := 0-1962.0724
147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date

Line 151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

147: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date
155: , p4_a9 NUMBER := 0-1962.0724

Line 152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

148: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date
155: , p4_a9 NUMBER := 0-1962.0724
156: , p4_a10 DATE := fnd_api.g_miss_date

Line 153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

149: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date
155: , p4_a9 NUMBER := 0-1962.0724
156: , p4_a10 DATE := fnd_api.g_miss_date
157: , p4_a11 NUMBER := 0-1962.0724

Line 154: , p4_a8 DATE := fnd_api.g_miss_date

150: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
151: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date
155: , p4_a9 NUMBER := 0-1962.0724
156: , p4_a10 DATE := fnd_api.g_miss_date
157: , p4_a11 NUMBER := 0-1962.0724
158: , p4_a12 NUMBER := 0-1962.0724

Line 156: , p4_a10 DATE := fnd_api.g_miss_date

152: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
153: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
154: , p4_a8 DATE := fnd_api.g_miss_date
155: , p4_a9 NUMBER := 0-1962.0724
156: , p4_a10 DATE := fnd_api.g_miss_date
157: , p4_a11 NUMBER := 0-1962.0724
158: , p4_a12 NUMBER := 0-1962.0724
159: , p4_a13 NUMBER := 0-1962.0724
160: , p4_a14 NUMBER := 0-1962.0724

Line 219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char

215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_msg_count OUT NOCOPY NUMBER
217: , x_msg_data OUT NOCOPY VARCHAR2
218: , p4_a0 NUMBER := 0-1962.0724
219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

Line 220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char

216: , x_msg_count OUT NOCOPY NUMBER
217: , x_msg_data OUT NOCOPY VARCHAR2
218: , p4_a0 NUMBER := 0-1962.0724
219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

Line 221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char

217: , x_msg_data OUT NOCOPY VARCHAR2
218: , p4_a0 NUMBER := 0-1962.0724
219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char

218: , p4_a0 NUMBER := 0-1962.0724
219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date

Line 223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char

219: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date
227: , p4_a9 NUMBER := 0-1962.0724

Line 224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char

220: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date
227: , p4_a9 NUMBER := 0-1962.0724
228: , p4_a10 DATE := fnd_api.g_miss_date

Line 225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char

221: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date
227: , p4_a9 NUMBER := 0-1962.0724
228: , p4_a10 DATE := fnd_api.g_miss_date
229: , p4_a11 NUMBER := 0-1962.0724

Line 226: , p4_a8 DATE := fnd_api.g_miss_date

222: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
223: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date
227: , p4_a9 NUMBER := 0-1962.0724
228: , p4_a10 DATE := fnd_api.g_miss_date
229: , p4_a11 NUMBER := 0-1962.0724
230: , p4_a12 NUMBER := 0-1962.0724

Line 228: , p4_a10 DATE := fnd_api.g_miss_date

224: , p4_a6 VARCHAR2 := fnd_api.g_miss_char
225: , p4_a7 VARCHAR2 := fnd_api.g_miss_char
226: , p4_a8 DATE := fnd_api.g_miss_date
227: , p4_a9 NUMBER := 0-1962.0724
228: , p4_a10 DATE := fnd_api.g_miss_date
229: , p4_a11 NUMBER := 0-1962.0724
230: , p4_a12 NUMBER := 0-1962.0724
231: , p4_a13 NUMBER := 0-1962.0724
232: , p4_a14 NUMBER := 0-1962.0724

Line 286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

282:
283: procedure check_denorm_queries_items(p_validation_mode VARCHAR2
284: , x_return_status OUT NOCOPY VARCHAR2
285: , p0_a0 NUMBER := 0-1962.0724
286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

283: procedure check_denorm_queries_items(p_validation_mode VARCHAR2
284: , x_return_status OUT NOCOPY VARCHAR2
285: , p0_a0 NUMBER := 0-1962.0724
286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

284: , x_return_status OUT NOCOPY VARCHAR2
285: , p0_a0 NUMBER := 0-1962.0724
286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

285: , p0_a0 NUMBER := 0-1962.0724
286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date

Line 290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

286: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date
294: , p0_a9 NUMBER := 0-1962.0724

Line 291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

287: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date
294: , p0_a9 NUMBER := 0-1962.0724
295: , p0_a10 DATE := fnd_api.g_miss_date

Line 292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

288: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date
294: , p0_a9 NUMBER := 0-1962.0724
295: , p0_a10 DATE := fnd_api.g_miss_date
296: , p0_a11 NUMBER := 0-1962.0724

Line 293: , p0_a8 DATE := fnd_api.g_miss_date

289: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date
294: , p0_a9 NUMBER := 0-1962.0724
295: , p0_a10 DATE := fnd_api.g_miss_date
296: , p0_a11 NUMBER := 0-1962.0724
297: , p0_a12 NUMBER := 0-1962.0724

Line 295: , p0_a10 DATE := fnd_api.g_miss_date

291: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a8 DATE := fnd_api.g_miss_date
294: , p0_a9 NUMBER := 0-1962.0724
295: , p0_a10 DATE := fnd_api.g_miss_date
296: , p0_a11 NUMBER := 0-1962.0724
297: , p0_a12 NUMBER := 0-1962.0724
298: , p0_a13 NUMBER := 0-1962.0724
299: , p0_a14 NUMBER := 0-1962.0724

Line 337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

333: end;
334:
335: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
336: , p0_a0 NUMBER := 0-1962.0724
337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

334:
335: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
336: , p0_a0 NUMBER := 0-1962.0724
337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

335: procedure check_denorm_queries_record(x_return_status OUT NOCOPY VARCHAR2
336: , p0_a0 NUMBER := 0-1962.0724
337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

336: , p0_a0 NUMBER := 0-1962.0724
337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date

Line 341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

337: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date
345: , p0_a9 NUMBER := 0-1962.0724

Line 342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

338: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date
345: , p0_a9 NUMBER := 0-1962.0724
346: , p0_a10 DATE := fnd_api.g_miss_date

Line 343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

339: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date
345: , p0_a9 NUMBER := 0-1962.0724
346: , p0_a10 DATE := fnd_api.g_miss_date
347: , p0_a11 NUMBER := 0-1962.0724

Line 344: , p0_a8 DATE := fnd_api.g_miss_date

340: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
341: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date
345: , p0_a9 NUMBER := 0-1962.0724
346: , p0_a10 DATE := fnd_api.g_miss_date
347: , p0_a11 NUMBER := 0-1962.0724
348: , p0_a12 NUMBER := 0-1962.0724

Line 346: , p0_a10 DATE := fnd_api.g_miss_date

342: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
343: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
344: , p0_a8 DATE := fnd_api.g_miss_date
345: , p0_a9 NUMBER := 0-1962.0724
346: , p0_a10 DATE := fnd_api.g_miss_date
347: , p0_a11 NUMBER := 0-1962.0724
348: , p0_a12 NUMBER := 0-1962.0724
349: , p0_a13 NUMBER := 0-1962.0724
350: , p0_a14 NUMBER := 0-1962.0724

Line 443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

439: , p1_a12 OUT NOCOPY NUMBER
440: , p1_a13 OUT NOCOPY NUMBER
441: , p1_a14 OUT NOCOPY NUMBER
442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

Line 444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

440: , p1_a13 OUT NOCOPY NUMBER
441: , p1_a14 OUT NOCOPY NUMBER
442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char

441: , p1_a14 OUT NOCOPY NUMBER
442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

442: , p0_a0 NUMBER := 0-1962.0724
443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date

Line 447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

443: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date
451: , p0_a9 NUMBER := 0-1962.0724

Line 448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

444: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 DATE := fnd_api.g_miss_date

Line 449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

445: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 DATE := fnd_api.g_miss_date
453: , p0_a11 NUMBER := 0-1962.0724

Line 450: , p0_a8 DATE := fnd_api.g_miss_date

446: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
447: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 DATE := fnd_api.g_miss_date
453: , p0_a11 NUMBER := 0-1962.0724
454: , p0_a12 NUMBER := 0-1962.0724

Line 452: , p0_a10 DATE := fnd_api.g_miss_date

448: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a8 DATE := fnd_api.g_miss_date
451: , p0_a9 NUMBER := 0-1962.0724
452: , p0_a10 DATE := fnd_api.g_miss_date
453: , p0_a11 NUMBER := 0-1962.0724
454: , p0_a12 NUMBER := 0-1962.0724
455: , p0_a13 NUMBER := 0-1962.0724
456: , p0_a14 NUMBER := 0-1962.0724