eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AES_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 311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

307: , p6_a12 out nocopy NUMBER
308: , p6_a13 out nocopy NUMBER
309: , p5_a0 NUMBER := 0-1962.0724
310: , p5_a1 NUMBER := 0-1962.0724
311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date

Line 312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

308: , p6_a13 out nocopy NUMBER
309: , p5_a0 NUMBER := 0-1962.0724
310: , p5_a1 NUMBER := 0-1962.0724
311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date
316: , p5_a7 NUMBER := 0-1962.0724

Line 313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

309: , p5_a0 NUMBER := 0-1962.0724
310: , p5_a1 NUMBER := 0-1962.0724
311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date
316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724

Line 314: , p5_a5 DATE := fnd_api.g_miss_date

310: , p5_a1 NUMBER := 0-1962.0724
311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date
316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 DATE := fnd_api.g_miss_date

Line 315: , p5_a6 DATE := fnd_api.g_miss_date

311: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date
316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 DATE := fnd_api.g_miss_date
319: , p5_a10 NUMBER := 0-1962.0724

Line 318: , p5_a9 DATE := fnd_api.g_miss_date

314: , p5_a5 DATE := fnd_api.g_miss_date
315: , p5_a6 DATE := fnd_api.g_miss_date
316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 DATE := fnd_api.g_miss_date
319: , p5_a10 NUMBER := 0-1962.0724
320: , p5_a11 DATE := fnd_api.g_miss_date
321: , p5_a12 NUMBER := 0-1962.0724
322: , p5_a13 NUMBER := 0-1962.0724

Line 320: , p5_a11 DATE := fnd_api.g_miss_date

316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 DATE := fnd_api.g_miss_date
319: , p5_a10 NUMBER := 0-1962.0724
320: , p5_a11 DATE := fnd_api.g_miss_date
321: , p5_a12 NUMBER := 0-1962.0724
322: , p5_a13 NUMBER := 0-1962.0724
323: )
324:

Line 489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

485: , x_msg_count out nocopy NUMBER
486: , x_msg_data out nocopy VARCHAR2
487: , p5_a0 NUMBER := 0-1962.0724
488: , p5_a1 NUMBER := 0-1962.0724
489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date

Line 490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

486: , x_msg_data out nocopy VARCHAR2
487: , p5_a0 NUMBER := 0-1962.0724
488: , p5_a1 NUMBER := 0-1962.0724
489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date
494: , p5_a7 NUMBER := 0-1962.0724

Line 491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

487: , p5_a0 NUMBER := 0-1962.0724
488: , p5_a1 NUMBER := 0-1962.0724
489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date
494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724

Line 492: , p5_a5 DATE := fnd_api.g_miss_date

488: , p5_a1 NUMBER := 0-1962.0724
489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date
494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 DATE := fnd_api.g_miss_date

Line 493: , p5_a6 DATE := fnd_api.g_miss_date

489: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date
494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 DATE := fnd_api.g_miss_date
497: , p5_a10 NUMBER := 0-1962.0724

Line 496: , p5_a9 DATE := fnd_api.g_miss_date

492: , p5_a5 DATE := fnd_api.g_miss_date
493: , p5_a6 DATE := fnd_api.g_miss_date
494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 DATE := fnd_api.g_miss_date
497: , p5_a10 NUMBER := 0-1962.0724
498: , p5_a11 DATE := fnd_api.g_miss_date
499: , p5_a12 NUMBER := 0-1962.0724
500: , p5_a13 NUMBER := 0-1962.0724

Line 498: , p5_a11 DATE := fnd_api.g_miss_date

494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 DATE := fnd_api.g_miss_date
497: , p5_a10 NUMBER := 0-1962.0724
498: , p5_a11 DATE := fnd_api.g_miss_date
499: , p5_a12 NUMBER := 0-1962.0724
500: , p5_a13 NUMBER := 0-1962.0724
501: )
502:

Line 630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

626: , p6_a12 out nocopy NUMBER
627: , p6_a13 out nocopy NUMBER
628: , p5_a0 NUMBER := 0-1962.0724
629: , p5_a1 NUMBER := 0-1962.0724
630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date

Line 631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

627: , p6_a13 out nocopy NUMBER
628: , p5_a0 NUMBER := 0-1962.0724
629: , p5_a1 NUMBER := 0-1962.0724
630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date
635: , p5_a7 NUMBER := 0-1962.0724

Line 632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

628: , p5_a0 NUMBER := 0-1962.0724
629: , p5_a1 NUMBER := 0-1962.0724
630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date
635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724

Line 633: , p5_a5 DATE := fnd_api.g_miss_date

629: , p5_a1 NUMBER := 0-1962.0724
630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date
635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 DATE := fnd_api.g_miss_date

Line 634: , p5_a6 DATE := fnd_api.g_miss_date

630: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date
635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 DATE := fnd_api.g_miss_date
638: , p5_a10 NUMBER := 0-1962.0724

Line 637: , p5_a9 DATE := fnd_api.g_miss_date

633: , p5_a5 DATE := fnd_api.g_miss_date
634: , p5_a6 DATE := fnd_api.g_miss_date
635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 DATE := fnd_api.g_miss_date
638: , p5_a10 NUMBER := 0-1962.0724
639: , p5_a11 DATE := fnd_api.g_miss_date
640: , p5_a12 NUMBER := 0-1962.0724
641: , p5_a13 NUMBER := 0-1962.0724

Line 639: , p5_a11 DATE := fnd_api.g_miss_date

635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 DATE := fnd_api.g_miss_date
638: , p5_a10 NUMBER := 0-1962.0724
639: , p5_a11 DATE := fnd_api.g_miss_date
640: , p5_a12 NUMBER := 0-1962.0724
641: , p5_a13 NUMBER := 0-1962.0724
642: )
643:

Line 808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

804: , x_msg_count out nocopy NUMBER
805: , x_msg_data out nocopy VARCHAR2
806: , p5_a0 NUMBER := 0-1962.0724
807: , p5_a1 NUMBER := 0-1962.0724
808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date

Line 809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

805: , x_msg_data out nocopy VARCHAR2
806: , p5_a0 NUMBER := 0-1962.0724
807: , p5_a1 NUMBER := 0-1962.0724
808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date
813: , p5_a7 NUMBER := 0-1962.0724

Line 810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

806: , p5_a0 NUMBER := 0-1962.0724
807: , p5_a1 NUMBER := 0-1962.0724
808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date
813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724

Line 811: , p5_a5 DATE := fnd_api.g_miss_date

807: , p5_a1 NUMBER := 0-1962.0724
808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date
813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 DATE := fnd_api.g_miss_date

Line 812: , p5_a6 DATE := fnd_api.g_miss_date

808: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date
813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 DATE := fnd_api.g_miss_date
816: , p5_a10 NUMBER := 0-1962.0724

Line 815: , p5_a9 DATE := fnd_api.g_miss_date

811: , p5_a5 DATE := fnd_api.g_miss_date
812: , p5_a6 DATE := fnd_api.g_miss_date
813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 DATE := fnd_api.g_miss_date
816: , p5_a10 NUMBER := 0-1962.0724
817: , p5_a11 DATE := fnd_api.g_miss_date
818: , p5_a12 NUMBER := 0-1962.0724
819: , p5_a13 NUMBER := 0-1962.0724

Line 817: , p5_a11 DATE := fnd_api.g_miss_date

813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 DATE := fnd_api.g_miss_date
816: , p5_a10 NUMBER := 0-1962.0724
817: , p5_a11 DATE := fnd_api.g_miss_date
818: , p5_a12 NUMBER := 0-1962.0724
819: , p5_a13 NUMBER := 0-1962.0724
820: )
821:

Line 935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

931: , x_msg_count out nocopy NUMBER
932: , x_msg_data out nocopy VARCHAR2
933: , p5_a0 NUMBER := 0-1962.0724
934: , p5_a1 NUMBER := 0-1962.0724
935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date

Line 936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

932: , x_msg_data out nocopy VARCHAR2
933: , p5_a0 NUMBER := 0-1962.0724
934: , p5_a1 NUMBER := 0-1962.0724
935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date
940: , p5_a7 NUMBER := 0-1962.0724

Line 937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

933: , p5_a0 NUMBER := 0-1962.0724
934: , p5_a1 NUMBER := 0-1962.0724
935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date
940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724

Line 938: , p5_a5 DATE := fnd_api.g_miss_date

934: , p5_a1 NUMBER := 0-1962.0724
935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date
940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 DATE := fnd_api.g_miss_date

Line 939: , p5_a6 DATE := fnd_api.g_miss_date

935: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date
940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 DATE := fnd_api.g_miss_date
943: , p5_a10 NUMBER := 0-1962.0724

Line 942: , p5_a9 DATE := fnd_api.g_miss_date

938: , p5_a5 DATE := fnd_api.g_miss_date
939: , p5_a6 DATE := fnd_api.g_miss_date
940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 DATE := fnd_api.g_miss_date
943: , p5_a10 NUMBER := 0-1962.0724
944: , p5_a11 DATE := fnd_api.g_miss_date
945: , p5_a12 NUMBER := 0-1962.0724
946: , p5_a13 NUMBER := 0-1962.0724

Line 944: , p5_a11 DATE := fnd_api.g_miss_date

940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 DATE := fnd_api.g_miss_date
943: , p5_a10 NUMBER := 0-1962.0724
944: , p5_a11 DATE := fnd_api.g_miss_date
945: , p5_a12 NUMBER := 0-1962.0724
946: , p5_a13 NUMBER := 0-1962.0724
947: )
948: