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

368: , p6_a17 out nocopy NUMBER
369: , p5_a0 NUMBER := 0-1962.0724
370: , p5_a1 NUMBER := 0-1962.0724
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a4 DATE := fnd_api.g_miss_date
374: , p5_a5 NUMBER := 0-1962.0724
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 NUMBER := 0-1962.0724

Line 373: , p5_a4 DATE := fnd_api.g_miss_date

369: , p5_a0 NUMBER := 0-1962.0724
370: , p5_a1 NUMBER := 0-1962.0724
371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a4 DATE := fnd_api.g_miss_date
374: , p5_a5 NUMBER := 0-1962.0724
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

371: , p5_a2 NUMBER := 0-1962.0724
372: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a4 DATE := fnd_api.g_miss_date
374: , p5_a5 NUMBER := 0-1962.0724
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
379: , p5_a10 NUMBER := 0-1962.0724

Line 377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

373: , p5_a4 DATE := fnd_api.g_miss_date
374: , p5_a5 NUMBER := 0-1962.0724
375: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
379: , p5_a10 NUMBER := 0-1962.0724
380: , p5_a11 DATE := fnd_api.g_miss_date
381: , p5_a12 NUMBER := 0-1962.0724

Line 380: , p5_a11 DATE := fnd_api.g_miss_date

376: , p5_a7 NUMBER := 0-1962.0724
377: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a9 NUMBER := 0-1962.0724
379: , p5_a10 NUMBER := 0-1962.0724
380: , p5_a11 DATE := fnd_api.g_miss_date
381: , p5_a12 NUMBER := 0-1962.0724
382: , p5_a13 NUMBER := 0-1962.0724
383: , p5_a14 DATE := fnd_api.g_miss_date
384: , p5_a15 NUMBER := 0-1962.0724

Line 383: , p5_a14 DATE := fnd_api.g_miss_date

379: , p5_a10 NUMBER := 0-1962.0724
380: , p5_a11 DATE := fnd_api.g_miss_date
381: , p5_a12 NUMBER := 0-1962.0724
382: , p5_a13 NUMBER := 0-1962.0724
383: , p5_a14 DATE := fnd_api.g_miss_date
384: , p5_a15 NUMBER := 0-1962.0724
385: , p5_a16 DATE := fnd_api.g_miss_date
386: , p5_a17 NUMBER := 0-1962.0724
387: )

Line 385: , p5_a16 DATE := fnd_api.g_miss_date

381: , p5_a12 NUMBER := 0-1962.0724
382: , p5_a13 NUMBER := 0-1962.0724
383: , p5_a14 DATE := fnd_api.g_miss_date
384: , p5_a15 NUMBER := 0-1962.0724
385: , p5_a16 DATE := fnd_api.g_miss_date
386: , p5_a17 NUMBER := 0-1962.0724
387: )
388:
389: as

Line 578: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

574: , x_msg_data out nocopy VARCHAR2
575: , p5_a0 NUMBER := 0-1962.0724
576: , p5_a1 NUMBER := 0-1962.0724
577: , p5_a2 NUMBER := 0-1962.0724
578: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a4 DATE := fnd_api.g_miss_date
580: , p5_a5 NUMBER := 0-1962.0724
581: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a7 NUMBER := 0-1962.0724

Line 579: , p5_a4 DATE := fnd_api.g_miss_date

575: , p5_a0 NUMBER := 0-1962.0724
576: , p5_a1 NUMBER := 0-1962.0724
577: , p5_a2 NUMBER := 0-1962.0724
578: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a4 DATE := fnd_api.g_miss_date
580: , p5_a5 NUMBER := 0-1962.0724
581: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a7 NUMBER := 0-1962.0724
583: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 581: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

577: , p5_a2 NUMBER := 0-1962.0724
578: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a4 DATE := fnd_api.g_miss_date
580: , p5_a5 NUMBER := 0-1962.0724
581: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a7 NUMBER := 0-1962.0724
583: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a9 NUMBER := 0-1962.0724
585: , p5_a10 NUMBER := 0-1962.0724

Line 583: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

579: , p5_a4 DATE := fnd_api.g_miss_date
580: , p5_a5 NUMBER := 0-1962.0724
581: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a7 NUMBER := 0-1962.0724
583: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a9 NUMBER := 0-1962.0724
585: , p5_a10 NUMBER := 0-1962.0724
586: , p5_a11 DATE := fnd_api.g_miss_date
587: , p5_a12 NUMBER := 0-1962.0724

Line 586: , p5_a11 DATE := fnd_api.g_miss_date

582: , p5_a7 NUMBER := 0-1962.0724
583: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
584: , p5_a9 NUMBER := 0-1962.0724
585: , p5_a10 NUMBER := 0-1962.0724
586: , p5_a11 DATE := fnd_api.g_miss_date
587: , p5_a12 NUMBER := 0-1962.0724
588: , p5_a13 NUMBER := 0-1962.0724
589: , p5_a14 DATE := fnd_api.g_miss_date
590: , p5_a15 NUMBER := 0-1962.0724

Line 589: , p5_a14 DATE := fnd_api.g_miss_date

585: , p5_a10 NUMBER := 0-1962.0724
586: , p5_a11 DATE := fnd_api.g_miss_date
587: , p5_a12 NUMBER := 0-1962.0724
588: , p5_a13 NUMBER := 0-1962.0724
589: , p5_a14 DATE := fnd_api.g_miss_date
590: , p5_a15 NUMBER := 0-1962.0724
591: , p5_a16 DATE := fnd_api.g_miss_date
592: , p5_a17 NUMBER := 0-1962.0724
593: )

Line 591: , p5_a16 DATE := fnd_api.g_miss_date

587: , p5_a12 NUMBER := 0-1962.0724
588: , p5_a13 NUMBER := 0-1962.0724
589: , p5_a14 DATE := fnd_api.g_miss_date
590: , p5_a15 NUMBER := 0-1962.0724
591: , p5_a16 DATE := fnd_api.g_miss_date
592: , p5_a17 NUMBER := 0-1962.0724
593: )
594:
595: as

Line 739: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

735: , p6_a17 out nocopy NUMBER
736: , p5_a0 NUMBER := 0-1962.0724
737: , p5_a1 NUMBER := 0-1962.0724
738: , p5_a2 NUMBER := 0-1962.0724
739: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a4 DATE := fnd_api.g_miss_date
741: , p5_a5 NUMBER := 0-1962.0724
742: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a7 NUMBER := 0-1962.0724

Line 740: , p5_a4 DATE := fnd_api.g_miss_date

736: , p5_a0 NUMBER := 0-1962.0724
737: , p5_a1 NUMBER := 0-1962.0724
738: , p5_a2 NUMBER := 0-1962.0724
739: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a4 DATE := fnd_api.g_miss_date
741: , p5_a5 NUMBER := 0-1962.0724
742: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a7 NUMBER := 0-1962.0724
744: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 742: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

738: , p5_a2 NUMBER := 0-1962.0724
739: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
740: , p5_a4 DATE := fnd_api.g_miss_date
741: , p5_a5 NUMBER := 0-1962.0724
742: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a7 NUMBER := 0-1962.0724
744: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a9 NUMBER := 0-1962.0724
746: , p5_a10 NUMBER := 0-1962.0724

Line 744: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

740: , p5_a4 DATE := fnd_api.g_miss_date
741: , p5_a5 NUMBER := 0-1962.0724
742: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a7 NUMBER := 0-1962.0724
744: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a9 NUMBER := 0-1962.0724
746: , p5_a10 NUMBER := 0-1962.0724
747: , p5_a11 DATE := fnd_api.g_miss_date
748: , p5_a12 NUMBER := 0-1962.0724

Line 747: , p5_a11 DATE := fnd_api.g_miss_date

743: , p5_a7 NUMBER := 0-1962.0724
744: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
745: , p5_a9 NUMBER := 0-1962.0724
746: , p5_a10 NUMBER := 0-1962.0724
747: , p5_a11 DATE := fnd_api.g_miss_date
748: , p5_a12 NUMBER := 0-1962.0724
749: , p5_a13 NUMBER := 0-1962.0724
750: , p5_a14 DATE := fnd_api.g_miss_date
751: , p5_a15 NUMBER := 0-1962.0724

Line 750: , p5_a14 DATE := fnd_api.g_miss_date

746: , p5_a10 NUMBER := 0-1962.0724
747: , p5_a11 DATE := fnd_api.g_miss_date
748: , p5_a12 NUMBER := 0-1962.0724
749: , p5_a13 NUMBER := 0-1962.0724
750: , p5_a14 DATE := fnd_api.g_miss_date
751: , p5_a15 NUMBER := 0-1962.0724
752: , p5_a16 DATE := fnd_api.g_miss_date
753: , p5_a17 NUMBER := 0-1962.0724
754: )

Line 752: , p5_a16 DATE := fnd_api.g_miss_date

748: , p5_a12 NUMBER := 0-1962.0724
749: , p5_a13 NUMBER := 0-1962.0724
750: , p5_a14 DATE := fnd_api.g_miss_date
751: , p5_a15 NUMBER := 0-1962.0724
752: , p5_a16 DATE := fnd_api.g_miss_date
753: , p5_a17 NUMBER := 0-1962.0724
754: )
755:
756: as

Line 945: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

941: , x_msg_data out nocopy VARCHAR2
942: , p5_a0 NUMBER := 0-1962.0724
943: , p5_a1 NUMBER := 0-1962.0724
944: , p5_a2 NUMBER := 0-1962.0724
945: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a4 DATE := fnd_api.g_miss_date
947: , p5_a5 NUMBER := 0-1962.0724
948: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a7 NUMBER := 0-1962.0724

Line 946: , p5_a4 DATE := fnd_api.g_miss_date

942: , p5_a0 NUMBER := 0-1962.0724
943: , p5_a1 NUMBER := 0-1962.0724
944: , p5_a2 NUMBER := 0-1962.0724
945: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a4 DATE := fnd_api.g_miss_date
947: , p5_a5 NUMBER := 0-1962.0724
948: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a7 NUMBER := 0-1962.0724
950: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 948: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

944: , p5_a2 NUMBER := 0-1962.0724
945: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
946: , p5_a4 DATE := fnd_api.g_miss_date
947: , p5_a5 NUMBER := 0-1962.0724
948: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a7 NUMBER := 0-1962.0724
950: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a9 NUMBER := 0-1962.0724
952: , p5_a10 NUMBER := 0-1962.0724

Line 950: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

946: , p5_a4 DATE := fnd_api.g_miss_date
947: , p5_a5 NUMBER := 0-1962.0724
948: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a7 NUMBER := 0-1962.0724
950: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a9 NUMBER := 0-1962.0724
952: , p5_a10 NUMBER := 0-1962.0724
953: , p5_a11 DATE := fnd_api.g_miss_date
954: , p5_a12 NUMBER := 0-1962.0724

Line 953: , p5_a11 DATE := fnd_api.g_miss_date

949: , p5_a7 NUMBER := 0-1962.0724
950: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a9 NUMBER := 0-1962.0724
952: , p5_a10 NUMBER := 0-1962.0724
953: , p5_a11 DATE := fnd_api.g_miss_date
954: , p5_a12 NUMBER := 0-1962.0724
955: , p5_a13 NUMBER := 0-1962.0724
956: , p5_a14 DATE := fnd_api.g_miss_date
957: , p5_a15 NUMBER := 0-1962.0724

Line 956: , p5_a14 DATE := fnd_api.g_miss_date

952: , p5_a10 NUMBER := 0-1962.0724
953: , p5_a11 DATE := fnd_api.g_miss_date
954: , p5_a12 NUMBER := 0-1962.0724
955: , p5_a13 NUMBER := 0-1962.0724
956: , p5_a14 DATE := fnd_api.g_miss_date
957: , p5_a15 NUMBER := 0-1962.0724
958: , p5_a16 DATE := fnd_api.g_miss_date
959: , p5_a17 NUMBER := 0-1962.0724
960: )

Line 958: , p5_a16 DATE := fnd_api.g_miss_date

954: , p5_a12 NUMBER := 0-1962.0724
955: , p5_a13 NUMBER := 0-1962.0724
956: , p5_a14 DATE := fnd_api.g_miss_date
957: , p5_a15 NUMBER := 0-1962.0724
958: , p5_a16 DATE := fnd_api.g_miss_date
959: , p5_a17 NUMBER := 0-1962.0724
960: )
961:
962: as

Line 1088: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1084: , x_msg_data out nocopy VARCHAR2
1085: , p5_a0 NUMBER := 0-1962.0724
1086: , p5_a1 NUMBER := 0-1962.0724
1087: , p5_a2 NUMBER := 0-1962.0724
1088: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a4 DATE := fnd_api.g_miss_date
1090: , p5_a5 NUMBER := 0-1962.0724
1091: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a7 NUMBER := 0-1962.0724

Line 1089: , p5_a4 DATE := fnd_api.g_miss_date

1085: , p5_a0 NUMBER := 0-1962.0724
1086: , p5_a1 NUMBER := 0-1962.0724
1087: , p5_a2 NUMBER := 0-1962.0724
1088: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a4 DATE := fnd_api.g_miss_date
1090: , p5_a5 NUMBER := 0-1962.0724
1091: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a7 NUMBER := 0-1962.0724
1093: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1091: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1087: , p5_a2 NUMBER := 0-1962.0724
1088: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1089: , p5_a4 DATE := fnd_api.g_miss_date
1090: , p5_a5 NUMBER := 0-1962.0724
1091: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a7 NUMBER := 0-1962.0724
1093: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1094: , p5_a9 NUMBER := 0-1962.0724
1095: , p5_a10 NUMBER := 0-1962.0724

Line 1093: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1089: , p5_a4 DATE := fnd_api.g_miss_date
1090: , p5_a5 NUMBER := 0-1962.0724
1091: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a7 NUMBER := 0-1962.0724
1093: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1094: , p5_a9 NUMBER := 0-1962.0724
1095: , p5_a10 NUMBER := 0-1962.0724
1096: , p5_a11 DATE := fnd_api.g_miss_date
1097: , p5_a12 NUMBER := 0-1962.0724

Line 1096: , p5_a11 DATE := fnd_api.g_miss_date

1092: , p5_a7 NUMBER := 0-1962.0724
1093: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1094: , p5_a9 NUMBER := 0-1962.0724
1095: , p5_a10 NUMBER := 0-1962.0724
1096: , p5_a11 DATE := fnd_api.g_miss_date
1097: , p5_a12 NUMBER := 0-1962.0724
1098: , p5_a13 NUMBER := 0-1962.0724
1099: , p5_a14 DATE := fnd_api.g_miss_date
1100: , p5_a15 NUMBER := 0-1962.0724

Line 1099: , p5_a14 DATE := fnd_api.g_miss_date

1095: , p5_a10 NUMBER := 0-1962.0724
1096: , p5_a11 DATE := fnd_api.g_miss_date
1097: , p5_a12 NUMBER := 0-1962.0724
1098: , p5_a13 NUMBER := 0-1962.0724
1099: , p5_a14 DATE := fnd_api.g_miss_date
1100: , p5_a15 NUMBER := 0-1962.0724
1101: , p5_a16 DATE := fnd_api.g_miss_date
1102: , p5_a17 NUMBER := 0-1962.0724
1103: )

Line 1101: , p5_a16 DATE := fnd_api.g_miss_date

1097: , p5_a12 NUMBER := 0-1962.0724
1098: , p5_a13 NUMBER := 0-1962.0724
1099: , p5_a14 DATE := fnd_api.g_miss_date
1100: , p5_a15 NUMBER := 0-1962.0724
1101: , p5_a16 DATE := fnd_api.g_miss_date
1102: , p5_a17 NUMBER := 0-1962.0724
1103: )
1104:
1105: as