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

277: , p6_a10 out nocopy DATE
278: , p6_a11 out nocopy NUMBER
279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 NUMBER := 0-1962.0724
281: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date

Line 282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

278: , p6_a11 out nocopy NUMBER
279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 NUMBER := 0-1962.0724
281: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724

Line 283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

279: , p5_a0 NUMBER := 0-1962.0724
280: , p5_a1 NUMBER := 0-1962.0724
281: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date

Line 284: , p5_a5 DATE := fnd_api.g_miss_date

280: , p5_a1 NUMBER := 0-1962.0724
281: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 NUMBER := 0-1962.0724

Line 285: , p5_a6 DATE := fnd_api.g_miss_date

281: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
282: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 NUMBER := 0-1962.0724
289: , p5_a10 DATE := fnd_api.g_miss_date

Line 287: , p5_a8 DATE := fnd_api.g_miss_date

283: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
284: , p5_a5 DATE := fnd_api.g_miss_date
285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 NUMBER := 0-1962.0724
289: , p5_a10 DATE := fnd_api.g_miss_date
290: , p5_a11 NUMBER := 0-1962.0724
291: )

Line 289: , p5_a10 DATE := fnd_api.g_miss_date

285: , p5_a6 DATE := fnd_api.g_miss_date
286: , p5_a7 NUMBER := 0-1962.0724
287: , p5_a8 DATE := fnd_api.g_miss_date
288: , p5_a9 NUMBER := 0-1962.0724
289: , p5_a10 DATE := fnd_api.g_miss_date
290: , p5_a11 NUMBER := 0-1962.0724
291: )
292:
293: as

Line 445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2
443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 NUMBER := 0-1962.0724
445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date

Line 446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

442: , x_msg_data out nocopy VARCHAR2
443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 NUMBER := 0-1962.0724
445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724

Line 447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

443: , p5_a0 NUMBER := 0-1962.0724
444: , p5_a1 NUMBER := 0-1962.0724
445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date

Line 448: , p5_a5 DATE := fnd_api.g_miss_date

444: , p5_a1 NUMBER := 0-1962.0724
445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 NUMBER := 0-1962.0724

Line 449: , p5_a6 DATE := fnd_api.g_miss_date

445: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
446: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 NUMBER := 0-1962.0724
453: , p5_a10 DATE := fnd_api.g_miss_date

Line 451: , p5_a8 DATE := fnd_api.g_miss_date

447: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
448: , p5_a5 DATE := fnd_api.g_miss_date
449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 NUMBER := 0-1962.0724
453: , p5_a10 DATE := fnd_api.g_miss_date
454: , p5_a11 NUMBER := 0-1962.0724
455: )

Line 453: , p5_a10 DATE := fnd_api.g_miss_date

449: , p5_a6 DATE := fnd_api.g_miss_date
450: , p5_a7 NUMBER := 0-1962.0724
451: , p5_a8 DATE := fnd_api.g_miss_date
452: , p5_a9 NUMBER := 0-1962.0724
453: , p5_a10 DATE := fnd_api.g_miss_date
454: , p5_a11 NUMBER := 0-1962.0724
455: )
456:
457: as

Line 576: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

572: , p6_a10 out nocopy DATE
573: , p6_a11 out nocopy NUMBER
574: , p5_a0 NUMBER := 0-1962.0724
575: , p5_a1 NUMBER := 0-1962.0724
576: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
577: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
579: , p5_a5 DATE := fnd_api.g_miss_date
580: , p5_a6 DATE := fnd_api.g_miss_date

Line 577: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 578: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 579: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 580: , p5_a6 DATE := fnd_api.g_miss_date

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

Line 582: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 584: , p5_a10 DATE := fnd_api.g_miss_date

580: , p5_a6 DATE := fnd_api.g_miss_date
581: , p5_a7 NUMBER := 0-1962.0724
582: , p5_a8 DATE := fnd_api.g_miss_date
583: , p5_a9 NUMBER := 0-1962.0724
584: , p5_a10 DATE := fnd_api.g_miss_date
585: , p5_a11 NUMBER := 0-1962.0724
586: )
587:
588: as

Line 740: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

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

Line 741: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

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

Line 742: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 743: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 744: , p5_a6 DATE := fnd_api.g_miss_date

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

Line 746: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 748: , p5_a10 DATE := fnd_api.g_miss_date

744: , p5_a6 DATE := fnd_api.g_miss_date
745: , p5_a7 NUMBER := 0-1962.0724
746: , p5_a8 DATE := fnd_api.g_miss_date
747: , p5_a9 NUMBER := 0-1962.0724
748: , p5_a10 DATE := fnd_api.g_miss_date
749: , p5_a11 NUMBER := 0-1962.0724
750: )
751:
752: as

Line 859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

855: , x_msg_count out nocopy NUMBER
856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date

Line 860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

856: , x_msg_data out nocopy VARCHAR2
857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724

Line 861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

857: , p5_a0 NUMBER := 0-1962.0724
858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date

Line 862: , p5_a5 DATE := fnd_api.g_miss_date

858: , p5_a1 NUMBER := 0-1962.0724
859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 NUMBER := 0-1962.0724

Line 863: , p5_a6 DATE := fnd_api.g_miss_date

859: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 NUMBER := 0-1962.0724
867: , p5_a10 DATE := fnd_api.g_miss_date

Line 865: , p5_a8 DATE := fnd_api.g_miss_date

861: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a5 DATE := fnd_api.g_miss_date
863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 NUMBER := 0-1962.0724
867: , p5_a10 DATE := fnd_api.g_miss_date
868: , p5_a11 NUMBER := 0-1962.0724
869: )

Line 867: , p5_a10 DATE := fnd_api.g_miss_date

863: , p5_a6 DATE := fnd_api.g_miss_date
864: , p5_a7 NUMBER := 0-1962.0724
865: , p5_a8 DATE := fnd_api.g_miss_date
866: , p5_a9 NUMBER := 0-1962.0724
867: , p5_a10 DATE := fnd_api.g_miss_date
868: , p5_a11 NUMBER := 0-1962.0724
869: )
870:
871: as