APPS.OKL_OVD_PVT_W dependencies on FND_API

Line 9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 325: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

321: , p6_a12 out nocopy NUMBER
322: , p6_a13 out nocopy DATE
323: , p6_a14 out nocopy NUMBER
324: , p5_a0 NUMBER := 0-1962.0724
325: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a2 NUMBER := 0-1962.0724
327: , p5_a3 NUMBER := 0-1962.0724
328: , p5_a4 NUMBER := 0-1962.0724
329: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 329: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

325: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a2 NUMBER := 0-1962.0724
327: , p5_a3 NUMBER := 0-1962.0724
328: , p5_a4 NUMBER := 0-1962.0724
329: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 330: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

326: , p5_a2 NUMBER := 0-1962.0724
327: , p5_a3 NUMBER := 0-1962.0724
328: , p5_a4 NUMBER := 0-1962.0724
329: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a10 NUMBER := 0-1962.0724

Line 333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

329: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date

Line 335: , p5_a11 DATE := fnd_api.g_miss_date

331: , p5_a7 NUMBER := 0-1962.0724
332: , p5_a8 NUMBER := 0-1962.0724
333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date
338: , p5_a14 NUMBER := 0-1962.0724
339: )

Line 337: , p5_a13 DATE := fnd_api.g_miss_date

333: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a10 NUMBER := 0-1962.0724
335: , p5_a11 DATE := fnd_api.g_miss_date
336: , p5_a12 NUMBER := 0-1962.0724
337: , p5_a13 DATE := fnd_api.g_miss_date
338: , p5_a14 NUMBER := 0-1962.0724
339: )
340:
341: as

Line 510: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

506: , x_return_status out nocopy VARCHAR2
507: , x_msg_count out nocopy NUMBER
508: , x_msg_data out nocopy VARCHAR2
509: , p5_a0 NUMBER := 0-1962.0724
510: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a2 NUMBER := 0-1962.0724
512: , p5_a3 NUMBER := 0-1962.0724
513: , p5_a4 NUMBER := 0-1962.0724
514: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 514: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

510: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a2 NUMBER := 0-1962.0724
512: , p5_a3 NUMBER := 0-1962.0724
513: , p5_a4 NUMBER := 0-1962.0724
514: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 515: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

511: , p5_a2 NUMBER := 0-1962.0724
512: , p5_a3 NUMBER := 0-1962.0724
513: , p5_a4 NUMBER := 0-1962.0724
514: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a10 NUMBER := 0-1962.0724

Line 518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

514: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date

Line 520: , p5_a11 DATE := fnd_api.g_miss_date

516: , p5_a7 NUMBER := 0-1962.0724
517: , p5_a8 NUMBER := 0-1962.0724
518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date
523: , p5_a14 NUMBER := 0-1962.0724
524: )

Line 522: , p5_a13 DATE := fnd_api.g_miss_date

518: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a10 NUMBER := 0-1962.0724
520: , p5_a11 DATE := fnd_api.g_miss_date
521: , p5_a12 NUMBER := 0-1962.0724
522: , p5_a13 DATE := fnd_api.g_miss_date
523: , p5_a14 NUMBER := 0-1962.0724
524: )
525:
526: as

Line 656: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

652: , p6_a12 out nocopy NUMBER
653: , p6_a13 out nocopy DATE
654: , p6_a14 out nocopy NUMBER
655: , p5_a0 NUMBER := 0-1962.0724
656: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a2 NUMBER := 0-1962.0724
658: , p5_a3 NUMBER := 0-1962.0724
659: , p5_a4 NUMBER := 0-1962.0724
660: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 660: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

656: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a2 NUMBER := 0-1962.0724
658: , p5_a3 NUMBER := 0-1962.0724
659: , p5_a4 NUMBER := 0-1962.0724
660: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 661: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

657: , p5_a2 NUMBER := 0-1962.0724
658: , p5_a3 NUMBER := 0-1962.0724
659: , p5_a4 NUMBER := 0-1962.0724
660: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a10 NUMBER := 0-1962.0724

Line 664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

660: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date

Line 666: , p5_a11 DATE := fnd_api.g_miss_date

662: , p5_a7 NUMBER := 0-1962.0724
663: , p5_a8 NUMBER := 0-1962.0724
664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date
669: , p5_a14 NUMBER := 0-1962.0724
670: )

Line 668: , p5_a13 DATE := fnd_api.g_miss_date

664: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a10 NUMBER := 0-1962.0724
666: , p5_a11 DATE := fnd_api.g_miss_date
667: , p5_a12 NUMBER := 0-1962.0724
668: , p5_a13 DATE := fnd_api.g_miss_date
669: , p5_a14 NUMBER := 0-1962.0724
670: )
671:
672: as

Line 841: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

837: , x_return_status out nocopy VARCHAR2
838: , x_msg_count out nocopy NUMBER
839: , x_msg_data out nocopy VARCHAR2
840: , p5_a0 NUMBER := 0-1962.0724
841: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a2 NUMBER := 0-1962.0724
843: , p5_a3 NUMBER := 0-1962.0724
844: , p5_a4 NUMBER := 0-1962.0724
845: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 845: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

841: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a2 NUMBER := 0-1962.0724
843: , p5_a3 NUMBER := 0-1962.0724
844: , p5_a4 NUMBER := 0-1962.0724
845: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
846: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 846: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

842: , p5_a2 NUMBER := 0-1962.0724
843: , p5_a3 NUMBER := 0-1962.0724
844: , p5_a4 NUMBER := 0-1962.0724
845: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
846: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a10 NUMBER := 0-1962.0724

Line 849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

845: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
846: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date

Line 851: , p5_a11 DATE := fnd_api.g_miss_date

847: , p5_a7 NUMBER := 0-1962.0724
848: , p5_a8 NUMBER := 0-1962.0724
849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date
854: , p5_a14 NUMBER := 0-1962.0724
855: )

Line 853: , p5_a13 DATE := fnd_api.g_miss_date

849: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a10 NUMBER := 0-1962.0724
851: , p5_a11 DATE := fnd_api.g_miss_date
852: , p5_a12 NUMBER := 0-1962.0724
853: , p5_a13 DATE := fnd_api.g_miss_date
854: , p5_a14 NUMBER := 0-1962.0724
855: )
856:
857: as

Line 972: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

968: , x_return_status out nocopy VARCHAR2
969: , x_msg_count out nocopy NUMBER
970: , x_msg_data out nocopy VARCHAR2
971: , p5_a0 NUMBER := 0-1962.0724
972: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a2 NUMBER := 0-1962.0724
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 NUMBER := 0-1962.0724
976: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 976: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

972: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
973: , p5_a2 NUMBER := 0-1962.0724
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 NUMBER := 0-1962.0724
976: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 977: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

973: , p5_a2 NUMBER := 0-1962.0724
974: , p5_a3 NUMBER := 0-1962.0724
975: , p5_a4 NUMBER := 0-1962.0724
976: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 NUMBER := 0-1962.0724

Line 980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

976: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
977: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date

Line 982: , p5_a11 DATE := fnd_api.g_miss_date

978: , p5_a7 NUMBER := 0-1962.0724
979: , p5_a8 NUMBER := 0-1962.0724
980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date
985: , p5_a14 NUMBER := 0-1962.0724
986: )

Line 984: , p5_a13 DATE := fnd_api.g_miss_date

980: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
981: , p5_a10 NUMBER := 0-1962.0724
982: , p5_a11 DATE := fnd_api.g_miss_date
983: , p5_a12 NUMBER := 0-1962.0724
984: , p5_a13 DATE := fnd_api.g_miss_date
985: , p5_a14 NUMBER := 0-1962.0724
986: )
987:
988: as