DBA Data[Home] [Help]

APPS.OKL_BKT_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 357: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

353: , p6_a16 out nocopy NUMBER
354: , p5_a0 NUMBER := 0-1962.0724
355: , p5_a1 NUMBER := 0-1962.0724
356: , p5_a2 NUMBER := 0-1962.0724
357: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a5 NUMBER := 0-1962.0724
360: , p5_a6 NUMBER := 0-1962.0724
361: , p5_a7 NUMBER := 0-1962.0724

Line 358: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

354: , p5_a0 NUMBER := 0-1962.0724
355: , p5_a1 NUMBER := 0-1962.0724
356: , p5_a2 NUMBER := 0-1962.0724
357: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
358: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
359: , p5_a5 NUMBER := 0-1962.0724
360: , p5_a6 NUMBER := 0-1962.0724
361: , p5_a7 NUMBER := 0-1962.0724
362: , p5_a8 NUMBER := 0-1962.0724

Line 363: , p5_a9 DATE := fnd_api.g_miss_date

359: , p5_a5 NUMBER := 0-1962.0724
360: , p5_a6 NUMBER := 0-1962.0724
361: , p5_a7 NUMBER := 0-1962.0724
362: , p5_a8 NUMBER := 0-1962.0724
363: , p5_a9 DATE := fnd_api.g_miss_date
364: , p5_a10 DATE := fnd_api.g_miss_date
365: , p5_a11 DATE := fnd_api.g_miss_date
366: , p5_a12 NUMBER := 0-1962.0724
367: , p5_a13 DATE := fnd_api.g_miss_date

Line 364: , p5_a10 DATE := fnd_api.g_miss_date

360: , p5_a6 NUMBER := 0-1962.0724
361: , p5_a7 NUMBER := 0-1962.0724
362: , p5_a8 NUMBER := 0-1962.0724
363: , p5_a9 DATE := fnd_api.g_miss_date
364: , p5_a10 DATE := fnd_api.g_miss_date
365: , p5_a11 DATE := fnd_api.g_miss_date
366: , p5_a12 NUMBER := 0-1962.0724
367: , p5_a13 DATE := fnd_api.g_miss_date
368: , p5_a14 NUMBER := 0-1962.0724

Line 365: , p5_a11 DATE := fnd_api.g_miss_date

361: , p5_a7 NUMBER := 0-1962.0724
362: , p5_a8 NUMBER := 0-1962.0724
363: , p5_a9 DATE := fnd_api.g_miss_date
364: , p5_a10 DATE := fnd_api.g_miss_date
365: , p5_a11 DATE := fnd_api.g_miss_date
366: , p5_a12 NUMBER := 0-1962.0724
367: , p5_a13 DATE := fnd_api.g_miss_date
368: , p5_a14 NUMBER := 0-1962.0724
369: , p5_a15 DATE := fnd_api.g_miss_date

Line 367: , p5_a13 DATE := fnd_api.g_miss_date

363: , p5_a9 DATE := fnd_api.g_miss_date
364: , p5_a10 DATE := fnd_api.g_miss_date
365: , p5_a11 DATE := fnd_api.g_miss_date
366: , p5_a12 NUMBER := 0-1962.0724
367: , p5_a13 DATE := fnd_api.g_miss_date
368: , p5_a14 NUMBER := 0-1962.0724
369: , p5_a15 DATE := fnd_api.g_miss_date
370: , p5_a16 NUMBER := 0-1962.0724
371: )

Line 369: , p5_a15 DATE := fnd_api.g_miss_date

365: , p5_a11 DATE := fnd_api.g_miss_date
366: , p5_a12 NUMBER := 0-1962.0724
367: , p5_a13 DATE := fnd_api.g_miss_date
368: , p5_a14 NUMBER := 0-1962.0724
369: , p5_a15 DATE := fnd_api.g_miss_date
370: , p5_a16 NUMBER := 0-1962.0724
371: )
372:
373: as

Line 556: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

552: , x_msg_data out nocopy VARCHAR2
553: , p5_a0 NUMBER := 0-1962.0724
554: , p5_a1 NUMBER := 0-1962.0724
555: , p5_a2 NUMBER := 0-1962.0724
556: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a5 NUMBER := 0-1962.0724
559: , p5_a6 NUMBER := 0-1962.0724
560: , p5_a7 NUMBER := 0-1962.0724

Line 557: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

553: , p5_a0 NUMBER := 0-1962.0724
554: , p5_a1 NUMBER := 0-1962.0724
555: , p5_a2 NUMBER := 0-1962.0724
556: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
558: , p5_a5 NUMBER := 0-1962.0724
559: , p5_a6 NUMBER := 0-1962.0724
560: , p5_a7 NUMBER := 0-1962.0724
561: , p5_a8 NUMBER := 0-1962.0724

Line 562: , p5_a9 DATE := fnd_api.g_miss_date

558: , p5_a5 NUMBER := 0-1962.0724
559: , p5_a6 NUMBER := 0-1962.0724
560: , p5_a7 NUMBER := 0-1962.0724
561: , p5_a8 NUMBER := 0-1962.0724
562: , p5_a9 DATE := fnd_api.g_miss_date
563: , p5_a10 DATE := fnd_api.g_miss_date
564: , p5_a11 DATE := fnd_api.g_miss_date
565: , p5_a12 NUMBER := 0-1962.0724
566: , p5_a13 DATE := fnd_api.g_miss_date

Line 563: , p5_a10 DATE := fnd_api.g_miss_date

559: , p5_a6 NUMBER := 0-1962.0724
560: , p5_a7 NUMBER := 0-1962.0724
561: , p5_a8 NUMBER := 0-1962.0724
562: , p5_a9 DATE := fnd_api.g_miss_date
563: , p5_a10 DATE := fnd_api.g_miss_date
564: , p5_a11 DATE := fnd_api.g_miss_date
565: , p5_a12 NUMBER := 0-1962.0724
566: , p5_a13 DATE := fnd_api.g_miss_date
567: , p5_a14 NUMBER := 0-1962.0724

Line 564: , p5_a11 DATE := fnd_api.g_miss_date

560: , p5_a7 NUMBER := 0-1962.0724
561: , p5_a8 NUMBER := 0-1962.0724
562: , p5_a9 DATE := fnd_api.g_miss_date
563: , p5_a10 DATE := fnd_api.g_miss_date
564: , p5_a11 DATE := fnd_api.g_miss_date
565: , p5_a12 NUMBER := 0-1962.0724
566: , p5_a13 DATE := fnd_api.g_miss_date
567: , p5_a14 NUMBER := 0-1962.0724
568: , p5_a15 DATE := fnd_api.g_miss_date

Line 566: , p5_a13 DATE := fnd_api.g_miss_date

562: , p5_a9 DATE := fnd_api.g_miss_date
563: , p5_a10 DATE := fnd_api.g_miss_date
564: , p5_a11 DATE := fnd_api.g_miss_date
565: , p5_a12 NUMBER := 0-1962.0724
566: , p5_a13 DATE := fnd_api.g_miss_date
567: , p5_a14 NUMBER := 0-1962.0724
568: , p5_a15 DATE := fnd_api.g_miss_date
569: , p5_a16 NUMBER := 0-1962.0724
570: )

Line 568: , p5_a15 DATE := fnd_api.g_miss_date

564: , p5_a11 DATE := fnd_api.g_miss_date
565: , p5_a12 NUMBER := 0-1962.0724
566: , p5_a13 DATE := fnd_api.g_miss_date
567: , p5_a14 NUMBER := 0-1962.0724
568: , p5_a15 DATE := fnd_api.g_miss_date
569: , p5_a16 NUMBER := 0-1962.0724
570: )
571:
572: as

Line 712: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

708: , p6_a16 out nocopy NUMBER
709: , p5_a0 NUMBER := 0-1962.0724
710: , p5_a1 NUMBER := 0-1962.0724
711: , p5_a2 NUMBER := 0-1962.0724
712: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a5 NUMBER := 0-1962.0724
715: , p5_a6 NUMBER := 0-1962.0724
716: , p5_a7 NUMBER := 0-1962.0724

Line 713: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

709: , p5_a0 NUMBER := 0-1962.0724
710: , p5_a1 NUMBER := 0-1962.0724
711: , p5_a2 NUMBER := 0-1962.0724
712: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a5 NUMBER := 0-1962.0724
715: , p5_a6 NUMBER := 0-1962.0724
716: , p5_a7 NUMBER := 0-1962.0724
717: , p5_a8 NUMBER := 0-1962.0724

Line 718: , p5_a9 DATE := fnd_api.g_miss_date

714: , p5_a5 NUMBER := 0-1962.0724
715: , p5_a6 NUMBER := 0-1962.0724
716: , p5_a7 NUMBER := 0-1962.0724
717: , p5_a8 NUMBER := 0-1962.0724
718: , p5_a9 DATE := fnd_api.g_miss_date
719: , p5_a10 DATE := fnd_api.g_miss_date
720: , p5_a11 DATE := fnd_api.g_miss_date
721: , p5_a12 NUMBER := 0-1962.0724
722: , p5_a13 DATE := fnd_api.g_miss_date

Line 719: , p5_a10 DATE := fnd_api.g_miss_date

715: , p5_a6 NUMBER := 0-1962.0724
716: , p5_a7 NUMBER := 0-1962.0724
717: , p5_a8 NUMBER := 0-1962.0724
718: , p5_a9 DATE := fnd_api.g_miss_date
719: , p5_a10 DATE := fnd_api.g_miss_date
720: , p5_a11 DATE := fnd_api.g_miss_date
721: , p5_a12 NUMBER := 0-1962.0724
722: , p5_a13 DATE := fnd_api.g_miss_date
723: , p5_a14 NUMBER := 0-1962.0724

Line 720: , p5_a11 DATE := fnd_api.g_miss_date

716: , p5_a7 NUMBER := 0-1962.0724
717: , p5_a8 NUMBER := 0-1962.0724
718: , p5_a9 DATE := fnd_api.g_miss_date
719: , p5_a10 DATE := fnd_api.g_miss_date
720: , p5_a11 DATE := fnd_api.g_miss_date
721: , p5_a12 NUMBER := 0-1962.0724
722: , p5_a13 DATE := fnd_api.g_miss_date
723: , p5_a14 NUMBER := 0-1962.0724
724: , p5_a15 DATE := fnd_api.g_miss_date

Line 722: , p5_a13 DATE := fnd_api.g_miss_date

718: , p5_a9 DATE := fnd_api.g_miss_date
719: , p5_a10 DATE := fnd_api.g_miss_date
720: , p5_a11 DATE := fnd_api.g_miss_date
721: , p5_a12 NUMBER := 0-1962.0724
722: , p5_a13 DATE := fnd_api.g_miss_date
723: , p5_a14 NUMBER := 0-1962.0724
724: , p5_a15 DATE := fnd_api.g_miss_date
725: , p5_a16 NUMBER := 0-1962.0724
726: )

Line 724: , p5_a15 DATE := fnd_api.g_miss_date

720: , p5_a11 DATE := fnd_api.g_miss_date
721: , p5_a12 NUMBER := 0-1962.0724
722: , p5_a13 DATE := fnd_api.g_miss_date
723: , p5_a14 NUMBER := 0-1962.0724
724: , p5_a15 DATE := fnd_api.g_miss_date
725: , p5_a16 NUMBER := 0-1962.0724
726: )
727:
728: as

Line 911: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

907: , x_msg_data out nocopy VARCHAR2
908: , p5_a0 NUMBER := 0-1962.0724
909: , p5_a1 NUMBER := 0-1962.0724
910: , p5_a2 NUMBER := 0-1962.0724
911: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a5 NUMBER := 0-1962.0724
914: , p5_a6 NUMBER := 0-1962.0724
915: , p5_a7 NUMBER := 0-1962.0724

Line 912: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

908: , p5_a0 NUMBER := 0-1962.0724
909: , p5_a1 NUMBER := 0-1962.0724
910: , p5_a2 NUMBER := 0-1962.0724
911: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a5 NUMBER := 0-1962.0724
914: , p5_a6 NUMBER := 0-1962.0724
915: , p5_a7 NUMBER := 0-1962.0724
916: , p5_a8 NUMBER := 0-1962.0724

Line 917: , p5_a9 DATE := fnd_api.g_miss_date

913: , p5_a5 NUMBER := 0-1962.0724
914: , p5_a6 NUMBER := 0-1962.0724
915: , p5_a7 NUMBER := 0-1962.0724
916: , p5_a8 NUMBER := 0-1962.0724
917: , p5_a9 DATE := fnd_api.g_miss_date
918: , p5_a10 DATE := fnd_api.g_miss_date
919: , p5_a11 DATE := fnd_api.g_miss_date
920: , p5_a12 NUMBER := 0-1962.0724
921: , p5_a13 DATE := fnd_api.g_miss_date

Line 918: , p5_a10 DATE := fnd_api.g_miss_date

914: , p5_a6 NUMBER := 0-1962.0724
915: , p5_a7 NUMBER := 0-1962.0724
916: , p5_a8 NUMBER := 0-1962.0724
917: , p5_a9 DATE := fnd_api.g_miss_date
918: , p5_a10 DATE := fnd_api.g_miss_date
919: , p5_a11 DATE := fnd_api.g_miss_date
920: , p5_a12 NUMBER := 0-1962.0724
921: , p5_a13 DATE := fnd_api.g_miss_date
922: , p5_a14 NUMBER := 0-1962.0724

Line 919: , p5_a11 DATE := fnd_api.g_miss_date

915: , p5_a7 NUMBER := 0-1962.0724
916: , p5_a8 NUMBER := 0-1962.0724
917: , p5_a9 DATE := fnd_api.g_miss_date
918: , p5_a10 DATE := fnd_api.g_miss_date
919: , p5_a11 DATE := fnd_api.g_miss_date
920: , p5_a12 NUMBER := 0-1962.0724
921: , p5_a13 DATE := fnd_api.g_miss_date
922: , p5_a14 NUMBER := 0-1962.0724
923: , p5_a15 DATE := fnd_api.g_miss_date

Line 921: , p5_a13 DATE := fnd_api.g_miss_date

917: , p5_a9 DATE := fnd_api.g_miss_date
918: , p5_a10 DATE := fnd_api.g_miss_date
919: , p5_a11 DATE := fnd_api.g_miss_date
920: , p5_a12 NUMBER := 0-1962.0724
921: , p5_a13 DATE := fnd_api.g_miss_date
922: , p5_a14 NUMBER := 0-1962.0724
923: , p5_a15 DATE := fnd_api.g_miss_date
924: , p5_a16 NUMBER := 0-1962.0724
925: )

Line 923: , p5_a15 DATE := fnd_api.g_miss_date

919: , p5_a11 DATE := fnd_api.g_miss_date
920: , p5_a12 NUMBER := 0-1962.0724
921: , p5_a13 DATE := fnd_api.g_miss_date
922: , p5_a14 NUMBER := 0-1962.0724
923: , p5_a15 DATE := fnd_api.g_miss_date
924: , p5_a16 NUMBER := 0-1962.0724
925: )
926:
927: as

Line 1050: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1046: , x_msg_data out nocopy VARCHAR2
1047: , p5_a0 NUMBER := 0-1962.0724
1048: , p5_a1 NUMBER := 0-1962.0724
1049: , p5_a2 NUMBER := 0-1962.0724
1050: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a5 NUMBER := 0-1962.0724
1053: , p5_a6 NUMBER := 0-1962.0724
1054: , p5_a7 NUMBER := 0-1962.0724

Line 1051: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

1047: , p5_a0 NUMBER := 0-1962.0724
1048: , p5_a1 NUMBER := 0-1962.0724
1049: , p5_a2 NUMBER := 0-1962.0724
1050: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1051: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1052: , p5_a5 NUMBER := 0-1962.0724
1053: , p5_a6 NUMBER := 0-1962.0724
1054: , p5_a7 NUMBER := 0-1962.0724
1055: , p5_a8 NUMBER := 0-1962.0724

Line 1056: , p5_a9 DATE := fnd_api.g_miss_date

1052: , p5_a5 NUMBER := 0-1962.0724
1053: , p5_a6 NUMBER := 0-1962.0724
1054: , p5_a7 NUMBER := 0-1962.0724
1055: , p5_a8 NUMBER := 0-1962.0724
1056: , p5_a9 DATE := fnd_api.g_miss_date
1057: , p5_a10 DATE := fnd_api.g_miss_date
1058: , p5_a11 DATE := fnd_api.g_miss_date
1059: , p5_a12 NUMBER := 0-1962.0724
1060: , p5_a13 DATE := fnd_api.g_miss_date

Line 1057: , p5_a10 DATE := fnd_api.g_miss_date

1053: , p5_a6 NUMBER := 0-1962.0724
1054: , p5_a7 NUMBER := 0-1962.0724
1055: , p5_a8 NUMBER := 0-1962.0724
1056: , p5_a9 DATE := fnd_api.g_miss_date
1057: , p5_a10 DATE := fnd_api.g_miss_date
1058: , p5_a11 DATE := fnd_api.g_miss_date
1059: , p5_a12 NUMBER := 0-1962.0724
1060: , p5_a13 DATE := fnd_api.g_miss_date
1061: , p5_a14 NUMBER := 0-1962.0724

Line 1058: , p5_a11 DATE := fnd_api.g_miss_date

1054: , p5_a7 NUMBER := 0-1962.0724
1055: , p5_a8 NUMBER := 0-1962.0724
1056: , p5_a9 DATE := fnd_api.g_miss_date
1057: , p5_a10 DATE := fnd_api.g_miss_date
1058: , p5_a11 DATE := fnd_api.g_miss_date
1059: , p5_a12 NUMBER := 0-1962.0724
1060: , p5_a13 DATE := fnd_api.g_miss_date
1061: , p5_a14 NUMBER := 0-1962.0724
1062: , p5_a15 DATE := fnd_api.g_miss_date

Line 1060: , p5_a13 DATE := fnd_api.g_miss_date

1056: , p5_a9 DATE := fnd_api.g_miss_date
1057: , p5_a10 DATE := fnd_api.g_miss_date
1058: , p5_a11 DATE := fnd_api.g_miss_date
1059: , p5_a12 NUMBER := 0-1962.0724
1060: , p5_a13 DATE := fnd_api.g_miss_date
1061: , p5_a14 NUMBER := 0-1962.0724
1062: , p5_a15 DATE := fnd_api.g_miss_date
1063: , p5_a16 NUMBER := 0-1962.0724
1064: )

Line 1062: , p5_a15 DATE := fnd_api.g_miss_date

1058: , p5_a11 DATE := fnd_api.g_miss_date
1059: , p5_a12 NUMBER := 0-1962.0724
1060: , p5_a13 DATE := fnd_api.g_miss_date
1061: , p5_a14 NUMBER := 0-1962.0724
1062: , p5_a15 DATE := fnd_api.g_miss_date
1063: , p5_a16 NUMBER := 0-1962.0724
1064: )
1065:
1066: as