DBA Data[Home] [Help]

APPS.OKL_SXP_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 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 NUMBER := 0-1962.0724
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 NUMBER := 0-1962.0724
314: , p5_a5 NUMBER := 0-1962.0724
315: , p5_a6 NUMBER := 0-1962.0724
316: , p5_a7 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 NUMBER := 0-1962.0724
319: , p5_a10 NUMBER := 0-1962.0724
320: , p5_a11 DATE := fnd_api.g_miss_date
321: , p5_a12 DATE := fnd_api.g_miss_date
322: , p5_a13 NUMBER := 0-1962.0724
323: )
324:

Line 321: , p5_a12 DATE := fnd_api.g_miss_date

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

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 NUMBER := 0-1962.0724
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 NUMBER := 0-1962.0724
492: , p5_a5 NUMBER := 0-1962.0724
493: , p5_a6 NUMBER := 0-1962.0724
494: , p5_a7 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 NUMBER := 0-1962.0724
497: , p5_a10 NUMBER := 0-1962.0724
498: , p5_a11 DATE := fnd_api.g_miss_date
499: , p5_a12 DATE := fnd_api.g_miss_date
500: , p5_a13 NUMBER := 0-1962.0724
501: )
502:

Line 499: , p5_a12 DATE := fnd_api.g_miss_date

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

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 NUMBER := 0-1962.0724
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 NUMBER := 0-1962.0724
633: , p5_a5 NUMBER := 0-1962.0724
634: , p5_a6 NUMBER := 0-1962.0724
635: , p5_a7 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 NUMBER := 0-1962.0724
638: , p5_a10 NUMBER := 0-1962.0724
639: , p5_a11 DATE := fnd_api.g_miss_date
640: , p5_a12 DATE := fnd_api.g_miss_date
641: , p5_a13 NUMBER := 0-1962.0724
642: )
643:

Line 640: , p5_a12 DATE := fnd_api.g_miss_date

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

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 NUMBER := 0-1962.0724
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 NUMBER := 0-1962.0724
811: , p5_a5 NUMBER := 0-1962.0724
812: , p5_a6 NUMBER := 0-1962.0724
813: , p5_a7 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 NUMBER := 0-1962.0724
816: , p5_a10 NUMBER := 0-1962.0724
817: , p5_a11 DATE := fnd_api.g_miss_date
818: , p5_a12 DATE := fnd_api.g_miss_date
819: , p5_a13 NUMBER := 0-1962.0724
820: )
821:

Line 818: , p5_a12 DATE := fnd_api.g_miss_date

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

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 NUMBER := 0-1962.0724
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 NUMBER := 0-1962.0724
938: , p5_a5 NUMBER := 0-1962.0724
939: , p5_a6 NUMBER := 0-1962.0724
940: , p5_a7 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 NUMBER := 0-1962.0724
943: , p5_a10 NUMBER := 0-1962.0724
944: , p5_a11 DATE := fnd_api.g_miss_date
945: , p5_a12 DATE := fnd_api.g_miss_date
946: , p5_a13 NUMBER := 0-1962.0724
947: )
948:

Line 945: , p5_a12 DATE := fnd_api.g_miss_date

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