APPS.AMS_CELL_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_cell_pvt.t_number, a0 JTF_NUMBER_TABLE) as

Line 72: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

68: , x_msg_count OUT NOCOPY NUMBER
69: , x_msg_data OUT NOCOPY VARCHAR2
70: , x_cell_id OUT NOCOPY NUMBER
71: , p7_a0 NUMBER := 0-1962.0724
72: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a2 DATE := fnd_api.g_miss_date
74: , p7_a3 NUMBER := 0-1962.0724
75: , p7_a4 DATE := fnd_api.g_miss_date
76: , p7_a5 NUMBER := 0-1962.0724

Line 73: , p7_a2 DATE := fnd_api.g_miss_date

69: , x_msg_data OUT NOCOPY VARCHAR2
70: , x_cell_id OUT NOCOPY NUMBER
71: , p7_a0 NUMBER := 0-1962.0724
72: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a2 DATE := fnd_api.g_miss_date
74: , p7_a3 NUMBER := 0-1962.0724
75: , p7_a4 DATE := fnd_api.g_miss_date
76: , p7_a5 NUMBER := 0-1962.0724
77: , p7_a6 NUMBER := 0-1962.0724

Line 75: , p7_a4 DATE := fnd_api.g_miss_date

71: , p7_a0 NUMBER := 0-1962.0724
72: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a2 DATE := fnd_api.g_miss_date
74: , p7_a3 NUMBER := 0-1962.0724
75: , p7_a4 DATE := fnd_api.g_miss_date
76: , p7_a5 NUMBER := 0-1962.0724
77: , p7_a6 NUMBER := 0-1962.0724
78: , p7_a7 NUMBER := 0-1962.0724
79: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 79: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

75: , p7_a4 DATE := fnd_api.g_miss_date
76: , p7_a5 NUMBER := 0-1962.0724
77: , p7_a6 NUMBER := 0-1962.0724
78: , p7_a7 NUMBER := 0-1962.0724
79: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a10 NUMBER := 0-1962.0724
82: , p7_a11 NUMBER := 0-1962.0724
83: , p7_a12 NUMBER := 0-1962.0724

Line 80: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

76: , p7_a5 NUMBER := 0-1962.0724
77: , p7_a6 NUMBER := 0-1962.0724
78: , p7_a7 NUMBER := 0-1962.0724
79: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a10 NUMBER := 0-1962.0724
82: , p7_a11 NUMBER := 0-1962.0724
83: , p7_a12 NUMBER := 0-1962.0724
84: , p7_a13 NUMBER := 0-1962.0724

Line 85: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

81: , p7_a10 NUMBER := 0-1962.0724
82: , p7_a11 NUMBER := 0-1962.0724
83: , p7_a12 NUMBER := 0-1962.0724
84: , p7_a13 NUMBER := 0-1962.0724
85: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a17 DATE := fnd_api.g_miss_date
89: , p7_a18 NUMBER := 0-1962.0724

Line 86: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

82: , p7_a11 NUMBER := 0-1962.0724
83: , p7_a12 NUMBER := 0-1962.0724
84: , p7_a13 NUMBER := 0-1962.0724
85: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a17 DATE := fnd_api.g_miss_date
89: , p7_a18 NUMBER := 0-1962.0724
90: )

Line 87: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

83: , p7_a12 NUMBER := 0-1962.0724
84: , p7_a13 NUMBER := 0-1962.0724
85: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a17 DATE := fnd_api.g_miss_date
89: , p7_a18 NUMBER := 0-1962.0724
90: )
91: as

Line 88: , p7_a17 DATE := fnd_api.g_miss_date

84: , p7_a13 NUMBER := 0-1962.0724
85: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a17 DATE := fnd_api.g_miss_date
89: , p7_a18 NUMBER := 0-1962.0724
90: )
91: as
92: ddp_cell_rec ams_cell_pvt.cell_rec_type;

Line 155: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

151: , x_return_status OUT NOCOPY VARCHAR2
152: , x_msg_count OUT NOCOPY NUMBER
153: , x_msg_data OUT NOCOPY VARCHAR2
154: , p7_a0 NUMBER := 0-1962.0724
155: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a2 DATE := fnd_api.g_miss_date
157: , p7_a3 NUMBER := 0-1962.0724
158: , p7_a4 DATE := fnd_api.g_miss_date
159: , p7_a5 NUMBER := 0-1962.0724

Line 156: , p7_a2 DATE := fnd_api.g_miss_date

152: , x_msg_count OUT NOCOPY NUMBER
153: , x_msg_data OUT NOCOPY VARCHAR2
154: , p7_a0 NUMBER := 0-1962.0724
155: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a2 DATE := fnd_api.g_miss_date
157: , p7_a3 NUMBER := 0-1962.0724
158: , p7_a4 DATE := fnd_api.g_miss_date
159: , p7_a5 NUMBER := 0-1962.0724
160: , p7_a6 NUMBER := 0-1962.0724

Line 158: , p7_a4 DATE := fnd_api.g_miss_date

154: , p7_a0 NUMBER := 0-1962.0724
155: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
156: , p7_a2 DATE := fnd_api.g_miss_date
157: , p7_a3 NUMBER := 0-1962.0724
158: , p7_a4 DATE := fnd_api.g_miss_date
159: , p7_a5 NUMBER := 0-1962.0724
160: , p7_a6 NUMBER := 0-1962.0724
161: , p7_a7 NUMBER := 0-1962.0724
162: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 162: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

158: , p7_a4 DATE := fnd_api.g_miss_date
159: , p7_a5 NUMBER := 0-1962.0724
160: , p7_a6 NUMBER := 0-1962.0724
161: , p7_a7 NUMBER := 0-1962.0724
162: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a10 NUMBER := 0-1962.0724
165: , p7_a11 NUMBER := 0-1962.0724
166: , p7_a12 NUMBER := 0-1962.0724

Line 163: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

159: , p7_a5 NUMBER := 0-1962.0724
160: , p7_a6 NUMBER := 0-1962.0724
161: , p7_a7 NUMBER := 0-1962.0724
162: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
163: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
164: , p7_a10 NUMBER := 0-1962.0724
165: , p7_a11 NUMBER := 0-1962.0724
166: , p7_a12 NUMBER := 0-1962.0724
167: , p7_a13 NUMBER := 0-1962.0724

Line 168: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

164: , p7_a10 NUMBER := 0-1962.0724
165: , p7_a11 NUMBER := 0-1962.0724
166: , p7_a12 NUMBER := 0-1962.0724
167: , p7_a13 NUMBER := 0-1962.0724
168: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a17 DATE := fnd_api.g_miss_date
172: , p7_a18 NUMBER := 0-1962.0724

Line 169: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

165: , p7_a11 NUMBER := 0-1962.0724
166: , p7_a12 NUMBER := 0-1962.0724
167: , p7_a13 NUMBER := 0-1962.0724
168: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a17 DATE := fnd_api.g_miss_date
172: , p7_a18 NUMBER := 0-1962.0724
173: )

Line 170: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

166: , p7_a12 NUMBER := 0-1962.0724
167: , p7_a13 NUMBER := 0-1962.0724
168: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a17 DATE := fnd_api.g_miss_date
172: , p7_a18 NUMBER := 0-1962.0724
173: )
174: as

Line 171: , p7_a17 DATE := fnd_api.g_miss_date

167: , p7_a13 NUMBER := 0-1962.0724
168: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
169: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
170: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
171: , p7_a17 DATE := fnd_api.g_miss_date
172: , p7_a18 NUMBER := 0-1962.0724
173: )
174: as
175: ddp_cell_rec ams_cell_pvt.cell_rec_type;

Line 234: , p6_a1 VARCHAR2 := fnd_api.g_miss_char

230: , x_return_status OUT NOCOPY VARCHAR2
231: , x_msg_count OUT NOCOPY NUMBER
232: , x_msg_data OUT NOCOPY VARCHAR2
233: , p6_a0 NUMBER := 0-1962.0724
234: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a2 DATE := fnd_api.g_miss_date
236: , p6_a3 NUMBER := 0-1962.0724
237: , p6_a4 DATE := fnd_api.g_miss_date
238: , p6_a5 NUMBER := 0-1962.0724

Line 235: , p6_a2 DATE := fnd_api.g_miss_date

231: , x_msg_count OUT NOCOPY NUMBER
232: , x_msg_data OUT NOCOPY VARCHAR2
233: , p6_a0 NUMBER := 0-1962.0724
234: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a2 DATE := fnd_api.g_miss_date
236: , p6_a3 NUMBER := 0-1962.0724
237: , p6_a4 DATE := fnd_api.g_miss_date
238: , p6_a5 NUMBER := 0-1962.0724
239: , p6_a6 NUMBER := 0-1962.0724

Line 237: , p6_a4 DATE := fnd_api.g_miss_date

233: , p6_a0 NUMBER := 0-1962.0724
234: , p6_a1 VARCHAR2 := fnd_api.g_miss_char
235: , p6_a2 DATE := fnd_api.g_miss_date
236: , p6_a3 NUMBER := 0-1962.0724
237: , p6_a4 DATE := fnd_api.g_miss_date
238: , p6_a5 NUMBER := 0-1962.0724
239: , p6_a6 NUMBER := 0-1962.0724
240: , p6_a7 NUMBER := 0-1962.0724
241: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

Line 241: , p6_a8 VARCHAR2 := fnd_api.g_miss_char

237: , p6_a4 DATE := fnd_api.g_miss_date
238: , p6_a5 NUMBER := 0-1962.0724
239: , p6_a6 NUMBER := 0-1962.0724
240: , p6_a7 NUMBER := 0-1962.0724
241: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a10 NUMBER := 0-1962.0724
244: , p6_a11 NUMBER := 0-1962.0724
245: , p6_a12 NUMBER := 0-1962.0724

Line 242: , p6_a9 VARCHAR2 := fnd_api.g_miss_char

238: , p6_a5 NUMBER := 0-1962.0724
239: , p6_a6 NUMBER := 0-1962.0724
240: , p6_a7 NUMBER := 0-1962.0724
241: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
242: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
243: , p6_a10 NUMBER := 0-1962.0724
244: , p6_a11 NUMBER := 0-1962.0724
245: , p6_a12 NUMBER := 0-1962.0724
246: , p6_a13 NUMBER := 0-1962.0724

Line 247: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

243: , p6_a10 NUMBER := 0-1962.0724
244: , p6_a11 NUMBER := 0-1962.0724
245: , p6_a12 NUMBER := 0-1962.0724
246: , p6_a13 NUMBER := 0-1962.0724
247: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a17 DATE := fnd_api.g_miss_date
251: , p6_a18 NUMBER := 0-1962.0724

Line 248: , p6_a15 VARCHAR2 := fnd_api.g_miss_char

244: , p6_a11 NUMBER := 0-1962.0724
245: , p6_a12 NUMBER := 0-1962.0724
246: , p6_a13 NUMBER := 0-1962.0724
247: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a17 DATE := fnd_api.g_miss_date
251: , p6_a18 NUMBER := 0-1962.0724
252: )

Line 249: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

245: , p6_a12 NUMBER := 0-1962.0724
246: , p6_a13 NUMBER := 0-1962.0724
247: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a17 DATE := fnd_api.g_miss_date
251: , p6_a18 NUMBER := 0-1962.0724
252: )
253: as

Line 250: , p6_a17 DATE := fnd_api.g_miss_date

246: , p6_a13 NUMBER := 0-1962.0724
247: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
248: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
249: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
250: , p6_a17 DATE := fnd_api.g_miss_date
251: , p6_a18 NUMBER := 0-1962.0724
252: )
253: as
254: ddp_cell_rec ams_cell_pvt.cell_rec_type;

Line 306: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

302:
303: procedure check_cell_items(p_validation_mode VARCHAR2
304: , x_return_status OUT NOCOPY VARCHAR2
305: , p0_a0 NUMBER := 0-1962.0724
306: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
307: , p0_a2 DATE := fnd_api.g_miss_date
308: , p0_a3 NUMBER := 0-1962.0724
309: , p0_a4 DATE := fnd_api.g_miss_date
310: , p0_a5 NUMBER := 0-1962.0724

Line 307: , p0_a2 DATE := fnd_api.g_miss_date

303: procedure check_cell_items(p_validation_mode VARCHAR2
304: , x_return_status OUT NOCOPY VARCHAR2
305: , p0_a0 NUMBER := 0-1962.0724
306: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
307: , p0_a2 DATE := fnd_api.g_miss_date
308: , p0_a3 NUMBER := 0-1962.0724
309: , p0_a4 DATE := fnd_api.g_miss_date
310: , p0_a5 NUMBER := 0-1962.0724
311: , p0_a6 NUMBER := 0-1962.0724

Line 309: , p0_a4 DATE := fnd_api.g_miss_date

305: , p0_a0 NUMBER := 0-1962.0724
306: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
307: , p0_a2 DATE := fnd_api.g_miss_date
308: , p0_a3 NUMBER := 0-1962.0724
309: , p0_a4 DATE := fnd_api.g_miss_date
310: , p0_a5 NUMBER := 0-1962.0724
311: , p0_a6 NUMBER := 0-1962.0724
312: , p0_a7 NUMBER := 0-1962.0724
313: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

Line 313: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

309: , p0_a4 DATE := fnd_api.g_miss_date
310: , p0_a5 NUMBER := 0-1962.0724
311: , p0_a6 NUMBER := 0-1962.0724
312: , p0_a7 NUMBER := 0-1962.0724
313: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a10 NUMBER := 0-1962.0724
316: , p0_a11 NUMBER := 0-1962.0724
317: , p0_a12 NUMBER := 0-1962.0724

Line 314: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

310: , p0_a5 NUMBER := 0-1962.0724
311: , p0_a6 NUMBER := 0-1962.0724
312: , p0_a7 NUMBER := 0-1962.0724
313: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
314: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
315: , p0_a10 NUMBER := 0-1962.0724
316: , p0_a11 NUMBER := 0-1962.0724
317: , p0_a12 NUMBER := 0-1962.0724
318: , p0_a13 NUMBER := 0-1962.0724

Line 319: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

315: , p0_a10 NUMBER := 0-1962.0724
316: , p0_a11 NUMBER := 0-1962.0724
317: , p0_a12 NUMBER := 0-1962.0724
318: , p0_a13 NUMBER := 0-1962.0724
319: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
321: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a17 DATE := fnd_api.g_miss_date
323: , p0_a18 NUMBER := 0-1962.0724

Line 320: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

316: , p0_a11 NUMBER := 0-1962.0724
317: , p0_a12 NUMBER := 0-1962.0724
318: , p0_a13 NUMBER := 0-1962.0724
319: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
321: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a17 DATE := fnd_api.g_miss_date
323: , p0_a18 NUMBER := 0-1962.0724
324: )

Line 321: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

317: , p0_a12 NUMBER := 0-1962.0724
318: , p0_a13 NUMBER := 0-1962.0724
319: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
321: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a17 DATE := fnd_api.g_miss_date
323: , p0_a18 NUMBER := 0-1962.0724
324: )
325: as

Line 322: , p0_a17 DATE := fnd_api.g_miss_date

318: , p0_a13 NUMBER := 0-1962.0724
319: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
320: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
321: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
322: , p0_a17 DATE := fnd_api.g_miss_date
323: , p0_a18 NUMBER := 0-1962.0724
324: )
325: as
326: ddp_cell_rec ams_cell_pvt.cell_rec_type;

Line 435: , p0_a1 VARCHAR2 := fnd_api.g_miss_char

431: , p1_a16 OUT NOCOPY VARCHAR2
432: , p1_a17 OUT NOCOPY DATE
433: , p1_a18 OUT NOCOPY NUMBER
434: , p0_a0 NUMBER := 0-1962.0724
435: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a2 DATE := fnd_api.g_miss_date
437: , p0_a3 NUMBER := 0-1962.0724
438: , p0_a4 DATE := fnd_api.g_miss_date
439: , p0_a5 NUMBER := 0-1962.0724

Line 436: , p0_a2 DATE := fnd_api.g_miss_date

432: , p1_a17 OUT NOCOPY DATE
433: , p1_a18 OUT NOCOPY NUMBER
434: , p0_a0 NUMBER := 0-1962.0724
435: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a2 DATE := fnd_api.g_miss_date
437: , p0_a3 NUMBER := 0-1962.0724
438: , p0_a4 DATE := fnd_api.g_miss_date
439: , p0_a5 NUMBER := 0-1962.0724
440: , p0_a6 NUMBER := 0-1962.0724

Line 438: , p0_a4 DATE := fnd_api.g_miss_date

434: , p0_a0 NUMBER := 0-1962.0724
435: , p0_a1 VARCHAR2 := fnd_api.g_miss_char
436: , p0_a2 DATE := fnd_api.g_miss_date
437: , p0_a3 NUMBER := 0-1962.0724
438: , p0_a4 DATE := fnd_api.g_miss_date
439: , p0_a5 NUMBER := 0-1962.0724
440: , p0_a6 NUMBER := 0-1962.0724
441: , p0_a7 NUMBER := 0-1962.0724
442: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

Line 442: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

438: , p0_a4 DATE := fnd_api.g_miss_date
439: , p0_a5 NUMBER := 0-1962.0724
440: , p0_a6 NUMBER := 0-1962.0724
441: , p0_a7 NUMBER := 0-1962.0724
442: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a10 NUMBER := 0-1962.0724
445: , p0_a11 NUMBER := 0-1962.0724
446: , p0_a12 NUMBER := 0-1962.0724

Line 443: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

439: , p0_a5 NUMBER := 0-1962.0724
440: , p0_a6 NUMBER := 0-1962.0724
441: , p0_a7 NUMBER := 0-1962.0724
442: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
443: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
444: , p0_a10 NUMBER := 0-1962.0724
445: , p0_a11 NUMBER := 0-1962.0724
446: , p0_a12 NUMBER := 0-1962.0724
447: , p0_a13 NUMBER := 0-1962.0724

Line 448: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

444: , p0_a10 NUMBER := 0-1962.0724
445: , p0_a11 NUMBER := 0-1962.0724
446: , p0_a12 NUMBER := 0-1962.0724
447: , p0_a13 NUMBER := 0-1962.0724
448: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a17 DATE := fnd_api.g_miss_date
452: , p0_a18 NUMBER := 0-1962.0724

Line 449: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

445: , p0_a11 NUMBER := 0-1962.0724
446: , p0_a12 NUMBER := 0-1962.0724
447: , p0_a13 NUMBER := 0-1962.0724
448: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a17 DATE := fnd_api.g_miss_date
452: , p0_a18 NUMBER := 0-1962.0724
453: )

Line 450: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

446: , p0_a12 NUMBER := 0-1962.0724
447: , p0_a13 NUMBER := 0-1962.0724
448: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a17 DATE := fnd_api.g_miss_date
452: , p0_a18 NUMBER := 0-1962.0724
453: )
454: as

Line 451: , p0_a17 DATE := fnd_api.g_miss_date

447: , p0_a13 NUMBER := 0-1962.0724
448: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
449: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
450: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
451: , p0_a17 DATE := fnd_api.g_miss_date
452: , p0_a18 NUMBER := 0-1962.0724
453: )
454: as
455: ddp_cell_rec ams_cell_pvt.cell_rec_type;

Line 518: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

514: , x_msg_count OUT NOCOPY NUMBER
515: , x_msg_data OUT NOCOPY VARCHAR2
516: , x_cell_id OUT NOCOPY NUMBER
517: , p7_a0 NUMBER := 0-1962.0724
518: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
519: , p7_a2 DATE := fnd_api.g_miss_date
520: , p7_a3 NUMBER := 0-1962.0724
521: , p7_a4 DATE := fnd_api.g_miss_date
522: , p7_a5 NUMBER := 0-1962.0724

Line 519: , p7_a2 DATE := fnd_api.g_miss_date

515: , x_msg_data OUT NOCOPY VARCHAR2
516: , x_cell_id OUT NOCOPY NUMBER
517: , p7_a0 NUMBER := 0-1962.0724
518: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
519: , p7_a2 DATE := fnd_api.g_miss_date
520: , p7_a3 NUMBER := 0-1962.0724
521: , p7_a4 DATE := fnd_api.g_miss_date
522: , p7_a5 NUMBER := 0-1962.0724
523: , p7_a6 NUMBER := 0-1962.0724

Line 521: , p7_a4 DATE := fnd_api.g_miss_date

517: , p7_a0 NUMBER := 0-1962.0724
518: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
519: , p7_a2 DATE := fnd_api.g_miss_date
520: , p7_a3 NUMBER := 0-1962.0724
521: , p7_a4 DATE := fnd_api.g_miss_date
522: , p7_a5 NUMBER := 0-1962.0724
523: , p7_a6 NUMBER := 0-1962.0724
524: , p7_a7 NUMBER := 0-1962.0724
525: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 525: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

521: , p7_a4 DATE := fnd_api.g_miss_date
522: , p7_a5 NUMBER := 0-1962.0724
523: , p7_a6 NUMBER := 0-1962.0724
524: , p7_a7 NUMBER := 0-1962.0724
525: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a10 NUMBER := 0-1962.0724
528: , p7_a11 NUMBER := 0-1962.0724
529: , p7_a12 NUMBER := 0-1962.0724

Line 526: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

522: , p7_a5 NUMBER := 0-1962.0724
523: , p7_a6 NUMBER := 0-1962.0724
524: , p7_a7 NUMBER := 0-1962.0724
525: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
526: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
527: , p7_a10 NUMBER := 0-1962.0724
528: , p7_a11 NUMBER := 0-1962.0724
529: , p7_a12 NUMBER := 0-1962.0724
530: , p7_a13 NUMBER := 0-1962.0724

Line 531: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

527: , p7_a10 NUMBER := 0-1962.0724
528: , p7_a11 NUMBER := 0-1962.0724
529: , p7_a12 NUMBER := 0-1962.0724
530: , p7_a13 NUMBER := 0-1962.0724
531: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724

Line 532: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

528: , p7_a11 NUMBER := 0-1962.0724
529: , p7_a12 NUMBER := 0-1962.0724
530: , p7_a13 NUMBER := 0-1962.0724
531: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724

Line 533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

529: , p7_a12 NUMBER := 0-1962.0724
530: , p7_a13 NUMBER := 0-1962.0724
531: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724
537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 534: , p7_a17 DATE := fnd_api.g_miss_date

530: , p7_a13 NUMBER := 0-1962.0724
531: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
532: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724
537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
538: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

533: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724
537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
538: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
539: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
540: , p7_a23 NUMBER := 0-1962.0724
541: , p7_a24 NUMBER := 0-1962.0724

Line 538: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

534: , p7_a17 DATE := fnd_api.g_miss_date
535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724
537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
538: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
539: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
540: , p7_a23 NUMBER := 0-1962.0724
541: , p7_a24 NUMBER := 0-1962.0724
542: , p7_a25 NUMBER := 0-1962.0724

Line 539: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

535: , p7_a18 NUMBER := 0-1962.0724
536: , p7_a19 NUMBER := 0-1962.0724
537: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
538: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
539: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
540: , p7_a23 NUMBER := 0-1962.0724
541: , p7_a24 NUMBER := 0-1962.0724
542: , p7_a25 NUMBER := 0-1962.0724
543: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 543: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

539: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
540: , p7_a23 NUMBER := 0-1962.0724
541: , p7_a24 NUMBER := 0-1962.0724
542: , p7_a25 NUMBER := 0-1962.0724
543: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a28 NUMBER := 0-1962.0724
546: )
547: as

Line 544: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

540: , p7_a23 NUMBER := 0-1962.0724
541: , p7_a24 NUMBER := 0-1962.0724
542: , p7_a25 NUMBER := 0-1962.0724
543: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
544: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
545: , p7_a28 NUMBER := 0-1962.0724
546: )
547: as
548: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;

Line 621: , p7_a1 VARCHAR2 := fnd_api.g_miss_char

617: , x_return_status OUT NOCOPY VARCHAR2
618: , x_msg_count OUT NOCOPY NUMBER
619: , x_msg_data OUT NOCOPY VARCHAR2
620: , p7_a0 NUMBER := 0-1962.0724
621: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
622: , p7_a2 DATE := fnd_api.g_miss_date
623: , p7_a3 NUMBER := 0-1962.0724
624: , p7_a4 DATE := fnd_api.g_miss_date
625: , p7_a5 NUMBER := 0-1962.0724

Line 622: , p7_a2 DATE := fnd_api.g_miss_date

618: , x_msg_count OUT NOCOPY NUMBER
619: , x_msg_data OUT NOCOPY VARCHAR2
620: , p7_a0 NUMBER := 0-1962.0724
621: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
622: , p7_a2 DATE := fnd_api.g_miss_date
623: , p7_a3 NUMBER := 0-1962.0724
624: , p7_a4 DATE := fnd_api.g_miss_date
625: , p7_a5 NUMBER := 0-1962.0724
626: , p7_a6 NUMBER := 0-1962.0724

Line 624: , p7_a4 DATE := fnd_api.g_miss_date

620: , p7_a0 NUMBER := 0-1962.0724
621: , p7_a1 VARCHAR2 := fnd_api.g_miss_char
622: , p7_a2 DATE := fnd_api.g_miss_date
623: , p7_a3 NUMBER := 0-1962.0724
624: , p7_a4 DATE := fnd_api.g_miss_date
625: , p7_a5 NUMBER := 0-1962.0724
626: , p7_a6 NUMBER := 0-1962.0724
627: , p7_a7 NUMBER := 0-1962.0724
628: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

Line 628: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

624: , p7_a4 DATE := fnd_api.g_miss_date
625: , p7_a5 NUMBER := 0-1962.0724
626: , p7_a6 NUMBER := 0-1962.0724
627: , p7_a7 NUMBER := 0-1962.0724
628: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
629: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
630: , p7_a10 NUMBER := 0-1962.0724
631: , p7_a11 NUMBER := 0-1962.0724
632: , p7_a12 NUMBER := 0-1962.0724

Line 629: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

625: , p7_a5 NUMBER := 0-1962.0724
626: , p7_a6 NUMBER := 0-1962.0724
627: , p7_a7 NUMBER := 0-1962.0724
628: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
629: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
630: , p7_a10 NUMBER := 0-1962.0724
631: , p7_a11 NUMBER := 0-1962.0724
632: , p7_a12 NUMBER := 0-1962.0724
633: , p7_a13 NUMBER := 0-1962.0724

Line 634: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

630: , p7_a10 NUMBER := 0-1962.0724
631: , p7_a11 NUMBER := 0-1962.0724
632: , p7_a12 NUMBER := 0-1962.0724
633: , p7_a13 NUMBER := 0-1962.0724
634: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724

Line 635: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

631: , p7_a11 NUMBER := 0-1962.0724
632: , p7_a12 NUMBER := 0-1962.0724
633: , p7_a13 NUMBER := 0-1962.0724
634: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724

Line 636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

632: , p7_a12 NUMBER := 0-1962.0724
633: , p7_a13 NUMBER := 0-1962.0724
634: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724
640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 637: , p7_a17 DATE := fnd_api.g_miss_date

633: , p7_a13 NUMBER := 0-1962.0724
634: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
635: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724
640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

636: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724
640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a23 NUMBER := 0-1962.0724
644: , p7_a24 NUMBER := 0-1962.0724

Line 641: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

637: , p7_a17 DATE := fnd_api.g_miss_date
638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724
640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a23 NUMBER := 0-1962.0724
644: , p7_a24 NUMBER := 0-1962.0724
645: , p7_a25 NUMBER := 0-1962.0724

Line 642: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

638: , p7_a18 NUMBER := 0-1962.0724
639: , p7_a19 NUMBER := 0-1962.0724
640: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
641: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
642: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a23 NUMBER := 0-1962.0724
644: , p7_a24 NUMBER := 0-1962.0724
645: , p7_a25 NUMBER := 0-1962.0724
646: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 646: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

642: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
643: , p7_a23 NUMBER := 0-1962.0724
644: , p7_a24 NUMBER := 0-1962.0724
645: , p7_a25 NUMBER := 0-1962.0724
646: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a28 NUMBER := 0-1962.0724
649: )
650: as

Line 647: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

643: , p7_a23 NUMBER := 0-1962.0724
644: , p7_a24 NUMBER := 0-1962.0724
645: , p7_a25 NUMBER := 0-1962.0724
646: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
647: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
648: , p7_a28 NUMBER := 0-1962.0724
649: )
650: as
651: ddp_sql_cell_rec ams_cell_pvt.sqlcell_rec_type;