APPS.AMS_VENUE_RATES_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_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE

Line 298: , p7_a1 DATE := fnd_api.g_miss_date

294: , x_msg_count OUT NOCOPY NUMBER
295: , x_msg_data OUT NOCOPY VARCHAR2
296: , x_rate_id OUT NOCOPY NUMBER
297: , p7_a0 NUMBER := 0-1962.0724
298: , p7_a1 DATE := fnd_api.g_miss_date
299: , p7_a2 NUMBER := 0-1962.0724
300: , p7_a3 DATE := fnd_api.g_miss_date
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724

Line 300: , p7_a3 DATE := fnd_api.g_miss_date

296: , x_rate_id OUT NOCOPY NUMBER
297: , p7_a0 NUMBER := 0-1962.0724
298: , p7_a1 DATE := fnd_api.g_miss_date
299: , p7_a2 NUMBER := 0-1962.0724
300: , p7_a3 DATE := fnd_api.g_miss_date
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724
303: , p7_a6 NUMBER := 0-1962.0724
304: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 304: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

300: , p7_a3 DATE := fnd_api.g_miss_date
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724
303: , p7_a6 NUMBER := 0-1962.0724
304: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a8 NUMBER := 0-1962.0724
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 NUMBER := 0-1962.0724
308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

304: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a8 NUMBER := 0-1962.0724
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 NUMBER := 0-1962.0724
308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a12 NUMBER := 0-1962.0724
310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 NUMBER := 0-1962.0724
308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a12 NUMBER := 0-1962.0724
310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

307: , p7_a10 NUMBER := 0-1962.0724
308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a12 NUMBER := 0-1962.0724
310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

308: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a12 NUMBER := 0-1962.0724
310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

309: , p7_a12 NUMBER := 0-1962.0724
310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

310: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

311: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

Line 322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

Line 323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

Line 324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

Line 325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

Line 326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )

Line 327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as

Line 328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
332: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

Line 329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
332: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
333: ddindx binary_integer; indx binary_integer;

Line 410: , p7_a1 DATE := fnd_api.g_miss_date

406: , x_msg_count OUT NOCOPY NUMBER
407: , x_msg_data OUT NOCOPY VARCHAR2
408: , x_object_version_number OUT NOCOPY NUMBER
409: , p7_a0 NUMBER := 0-1962.0724
410: , p7_a1 DATE := fnd_api.g_miss_date
411: , p7_a2 NUMBER := 0-1962.0724
412: , p7_a3 DATE := fnd_api.g_miss_date
413: , p7_a4 NUMBER := 0-1962.0724
414: , p7_a5 NUMBER := 0-1962.0724

Line 412: , p7_a3 DATE := fnd_api.g_miss_date

408: , x_object_version_number OUT NOCOPY NUMBER
409: , p7_a0 NUMBER := 0-1962.0724
410: , p7_a1 DATE := fnd_api.g_miss_date
411: , p7_a2 NUMBER := 0-1962.0724
412: , p7_a3 DATE := fnd_api.g_miss_date
413: , p7_a4 NUMBER := 0-1962.0724
414: , p7_a5 NUMBER := 0-1962.0724
415: , p7_a6 NUMBER := 0-1962.0724
416: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 416: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

412: , p7_a3 DATE := fnd_api.g_miss_date
413: , p7_a4 NUMBER := 0-1962.0724
414: , p7_a5 NUMBER := 0-1962.0724
415: , p7_a6 NUMBER := 0-1962.0724
416: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a8 NUMBER := 0-1962.0724
418: , p7_a9 NUMBER := 0-1962.0724
419: , p7_a10 NUMBER := 0-1962.0724
420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

416: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a8 NUMBER := 0-1962.0724
418: , p7_a9 NUMBER := 0-1962.0724
419: , p7_a10 NUMBER := 0-1962.0724
420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a12 NUMBER := 0-1962.0724
422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

418: , p7_a9 NUMBER := 0-1962.0724
419: , p7_a10 NUMBER := 0-1962.0724
420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a12 NUMBER := 0-1962.0724
422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

419: , p7_a10 NUMBER := 0-1962.0724
420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a12 NUMBER := 0-1962.0724
422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

420: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a12 NUMBER := 0-1962.0724
422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

421: , p7_a12 NUMBER := 0-1962.0724
422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

422: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

423: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

424: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

425: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

426: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

427: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

428: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

429: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

Line 434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

430: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

Line 435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

431: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

Line 436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

432: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

Line 437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

433: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

Line 438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

434: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
442: )

Line 439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

435: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
442: )
443: as

Line 440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

436: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
442: )
443: as
444: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

Line 441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

437: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
441: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
442: )
443: as
444: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
445: ddindx binary_integer; indx binary_integer;

Line 521: , p3_a1 DATE := fnd_api.g_miss_date

517: , x_return_status OUT NOCOPY VARCHAR2
518: , x_msg_count OUT NOCOPY NUMBER
519: , x_msg_data OUT NOCOPY VARCHAR2
520: , p3_a0 NUMBER := 0-1962.0724
521: , p3_a1 DATE := fnd_api.g_miss_date
522: , p3_a2 NUMBER := 0-1962.0724
523: , p3_a3 DATE := fnd_api.g_miss_date
524: , p3_a4 NUMBER := 0-1962.0724
525: , p3_a5 NUMBER := 0-1962.0724

Line 523: , p3_a3 DATE := fnd_api.g_miss_date

519: , x_msg_data OUT NOCOPY VARCHAR2
520: , p3_a0 NUMBER := 0-1962.0724
521: , p3_a1 DATE := fnd_api.g_miss_date
522: , p3_a2 NUMBER := 0-1962.0724
523: , p3_a3 DATE := fnd_api.g_miss_date
524: , p3_a4 NUMBER := 0-1962.0724
525: , p3_a5 NUMBER := 0-1962.0724
526: , p3_a6 NUMBER := 0-1962.0724
527: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

Line 527: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

523: , p3_a3 DATE := fnd_api.g_miss_date
524: , p3_a4 NUMBER := 0-1962.0724
525: , p3_a5 NUMBER := 0-1962.0724
526: , p3_a6 NUMBER := 0-1962.0724
527: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p3_a8 NUMBER := 0-1962.0724
529: , p3_a9 NUMBER := 0-1962.0724
530: , p3_a10 NUMBER := 0-1962.0724
531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

527: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
528: , p3_a8 NUMBER := 0-1962.0724
529: , p3_a9 NUMBER := 0-1962.0724
530: , p3_a10 NUMBER := 0-1962.0724
531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p3_a12 NUMBER := 0-1962.0724
533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

Line 533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

529: , p3_a9 NUMBER := 0-1962.0724
530: , p3_a10 NUMBER := 0-1962.0724
531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p3_a12 NUMBER := 0-1962.0724
533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

Line 534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char

530: , p3_a10 NUMBER := 0-1962.0724
531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p3_a12 NUMBER := 0-1962.0724
533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

Line 535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

531: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
532: , p3_a12 NUMBER := 0-1962.0724
533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

Line 536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char

532: , p3_a12 NUMBER := 0-1962.0724
533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

Line 537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

533: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

Line 538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

534: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

Line 539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

535: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

Line 540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

536: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

Line 541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

537: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char

Line 542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

538: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char

Line 543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

539: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char

Line 544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

540: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char

Line 545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char

541: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char

Line 546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char

542: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char

Line 547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char

543: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char

Line 548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char

544: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char

Line 549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char

545: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char
553: )

Line 550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char

546: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char
553: )
554: as

Line 551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char

547: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char
553: )
554: as
555: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

Line 552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char

548: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
549: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
551: , p3_a31 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a32 VARCHAR2 := fnd_api.g_miss_char
553: )
554: as
555: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
556: ddindx binary_integer; indx binary_integer;

Line 624: , p0_a1 DATE := fnd_api.g_miss_date

620:
621: procedure check_venue_rates_items(p_validation_mode VARCHAR2
622: , x_return_status OUT NOCOPY VARCHAR2
623: , p0_a0 NUMBER := 0-1962.0724
624: , p0_a1 DATE := fnd_api.g_miss_date
625: , p0_a2 NUMBER := 0-1962.0724
626: , p0_a3 DATE := fnd_api.g_miss_date
627: , p0_a4 NUMBER := 0-1962.0724
628: , p0_a5 NUMBER := 0-1962.0724

Line 626: , p0_a3 DATE := fnd_api.g_miss_date

622: , x_return_status OUT NOCOPY VARCHAR2
623: , p0_a0 NUMBER := 0-1962.0724
624: , p0_a1 DATE := fnd_api.g_miss_date
625: , p0_a2 NUMBER := 0-1962.0724
626: , p0_a3 DATE := fnd_api.g_miss_date
627: , p0_a4 NUMBER := 0-1962.0724
628: , p0_a5 NUMBER := 0-1962.0724
629: , p0_a6 NUMBER := 0-1962.0724
630: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 630: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

626: , p0_a3 DATE := fnd_api.g_miss_date
627: , p0_a4 NUMBER := 0-1962.0724
628: , p0_a5 NUMBER := 0-1962.0724
629: , p0_a6 NUMBER := 0-1962.0724
630: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
631: , p0_a8 NUMBER := 0-1962.0724
632: , p0_a9 NUMBER := 0-1962.0724
633: , p0_a10 NUMBER := 0-1962.0724
634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

630: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
631: , p0_a8 NUMBER := 0-1962.0724
632: , p0_a9 NUMBER := 0-1962.0724
633: , p0_a10 NUMBER := 0-1962.0724
634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
635: , p0_a12 NUMBER := 0-1962.0724
636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

632: , p0_a9 NUMBER := 0-1962.0724
633: , p0_a10 NUMBER := 0-1962.0724
634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
635: , p0_a12 NUMBER := 0-1962.0724
636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

633: , p0_a10 NUMBER := 0-1962.0724
634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
635: , p0_a12 NUMBER := 0-1962.0724
636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

634: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
635: , p0_a12 NUMBER := 0-1962.0724
636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

635: , p0_a12 NUMBER := 0-1962.0724
636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

636: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

637: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

638: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

639: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

640: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

Line 645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

641: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

Line 646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

642: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

Line 647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

643: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char

Line 648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char

644: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char

Line 649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char

645: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char

Line 650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char

646: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char

Line 651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char

647: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char

Line 652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char

648: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
656: )

Line 653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char

649: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
656: )
657: as

Line 654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char

650: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
656: )
657: as
658: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

Line 655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char

651: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
652: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
653: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
654: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
655: , p0_a32 VARCHAR2 := fnd_api.g_miss_char
656: )
657: as
658: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
659: ddindx binary_integer; indx binary_integer;

Line 715: , p5_a1 DATE := fnd_api.g_miss_date

711: , x_return_status OUT NOCOPY VARCHAR2
712: , x_msg_count OUT NOCOPY NUMBER
713: , x_msg_data OUT NOCOPY VARCHAR2
714: , p5_a0 NUMBER := 0-1962.0724
715: , p5_a1 DATE := fnd_api.g_miss_date
716: , p5_a2 NUMBER := 0-1962.0724
717: , p5_a3 DATE := fnd_api.g_miss_date
718: , p5_a4 NUMBER := 0-1962.0724
719: , p5_a5 NUMBER := 0-1962.0724

Line 717: , p5_a3 DATE := fnd_api.g_miss_date

713: , x_msg_data OUT NOCOPY VARCHAR2
714: , p5_a0 NUMBER := 0-1962.0724
715: , p5_a1 DATE := fnd_api.g_miss_date
716: , p5_a2 NUMBER := 0-1962.0724
717: , p5_a3 DATE := fnd_api.g_miss_date
718: , p5_a4 NUMBER := 0-1962.0724
719: , p5_a5 NUMBER := 0-1962.0724
720: , p5_a6 NUMBER := 0-1962.0724
721: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 721: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

717: , p5_a3 DATE := fnd_api.g_miss_date
718: , p5_a4 NUMBER := 0-1962.0724
719: , p5_a5 NUMBER := 0-1962.0724
720: , p5_a6 NUMBER := 0-1962.0724
721: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a8 NUMBER := 0-1962.0724
723: , p5_a9 NUMBER := 0-1962.0724
724: , p5_a10 NUMBER := 0-1962.0724
725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

721: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a8 NUMBER := 0-1962.0724
723: , p5_a9 NUMBER := 0-1962.0724
724: , p5_a10 NUMBER := 0-1962.0724
725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a12 NUMBER := 0-1962.0724
727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

723: , p5_a9 NUMBER := 0-1962.0724
724: , p5_a10 NUMBER := 0-1962.0724
725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a12 NUMBER := 0-1962.0724
727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

724: , p5_a10 NUMBER := 0-1962.0724
725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a12 NUMBER := 0-1962.0724
727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a12 NUMBER := 0-1962.0724
727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

726: , p5_a12 NUMBER := 0-1962.0724
727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

727: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

728: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

729: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

730: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
747: )

Line 744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
747: )
748: as

Line 745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
747: )
748: as
749: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;

Line 746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
747: )
748: as
749: ddp_venue_rates_rec ams_venue_rates_pvt.venue_rates_rec_type;
750: ddindx binary_integer; indx binary_integer;