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

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

Line 374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

370: , p6_a11 out nocopy NUMBER
371: , p5_a0 NUMBER := 0-1962.0724
372: , p5_a1 NUMBER := 0-1962.0724
373: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a7 NUMBER := 0-1962.0724

Line 375: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

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

Line 376: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

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

Line 377: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 379: , p5_a8 DATE := fnd_api.g_miss_date

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

Line 381: , p5_a10 DATE := fnd_api.g_miss_date

377: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
378: , p5_a7 NUMBER := 0-1962.0724
379: , p5_a8 DATE := fnd_api.g_miss_date
380: , p5_a9 NUMBER := 0-1962.0724
381: , p5_a10 DATE := fnd_api.g_miss_date
382: , p5_a11 NUMBER := 0-1962.0724
383: )
384:
385: as

Line 537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 NUMBER := 0-1962.0724
536: , p5_a1 NUMBER := 0-1962.0724
537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 NUMBER := 0-1962.0724
536: , p5_a1 NUMBER := 0-1962.0724
537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724

Line 539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

535: , p5_a0 NUMBER := 0-1962.0724
536: , p5_a1 NUMBER := 0-1962.0724
537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724
543: , p5_a8 DATE := fnd_api.g_miss_date

Line 540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

536: , p5_a1 NUMBER := 0-1962.0724
537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724
543: , p5_a8 DATE := fnd_api.g_miss_date
544: , p5_a9 NUMBER := 0-1962.0724

Line 541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

537: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724
543: , p5_a8 DATE := fnd_api.g_miss_date
544: , p5_a9 NUMBER := 0-1962.0724
545: , p5_a10 DATE := fnd_api.g_miss_date

Line 543: , p5_a8 DATE := fnd_api.g_miss_date

539: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724
543: , p5_a8 DATE := fnd_api.g_miss_date
544: , p5_a9 NUMBER := 0-1962.0724
545: , p5_a10 DATE := fnd_api.g_miss_date
546: , p5_a11 NUMBER := 0-1962.0724
547: )

Line 545: , p5_a10 DATE := fnd_api.g_miss_date

541: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a7 NUMBER := 0-1962.0724
543: , p5_a8 DATE := fnd_api.g_miss_date
544: , p5_a9 NUMBER := 0-1962.0724
545: , p5_a10 DATE := fnd_api.g_miss_date
546: , p5_a11 NUMBER := 0-1962.0724
547: )
548:
549: as

Line 668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

664: , p6_a10 out nocopy DATE
665: , p6_a11 out nocopy NUMBER
666: , p5_a0 NUMBER := 0-1962.0724
667: , p5_a1 NUMBER := 0-1962.0724
668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

665: , p6_a11 out nocopy NUMBER
666: , p5_a0 NUMBER := 0-1962.0724
667: , p5_a1 NUMBER := 0-1962.0724
668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724

Line 670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

666: , p5_a0 NUMBER := 0-1962.0724
667: , p5_a1 NUMBER := 0-1962.0724
668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724
674: , p5_a8 DATE := fnd_api.g_miss_date

Line 671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

667: , p5_a1 NUMBER := 0-1962.0724
668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724
674: , p5_a8 DATE := fnd_api.g_miss_date
675: , p5_a9 NUMBER := 0-1962.0724

Line 672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

668: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724
674: , p5_a8 DATE := fnd_api.g_miss_date
675: , p5_a9 NUMBER := 0-1962.0724
676: , p5_a10 DATE := fnd_api.g_miss_date

Line 674: , p5_a8 DATE := fnd_api.g_miss_date

670: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724
674: , p5_a8 DATE := fnd_api.g_miss_date
675: , p5_a9 NUMBER := 0-1962.0724
676: , p5_a10 DATE := fnd_api.g_miss_date
677: , p5_a11 NUMBER := 0-1962.0724
678: )

Line 676: , p5_a10 DATE := fnd_api.g_miss_date

672: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
673: , p5_a7 NUMBER := 0-1962.0724
674: , p5_a8 DATE := fnd_api.g_miss_date
675: , p5_a9 NUMBER := 0-1962.0724
676: , p5_a10 DATE := fnd_api.g_miss_date
677: , p5_a11 NUMBER := 0-1962.0724
678: )
679:
680: as

Line 832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 NUMBER := 0-1962.0724
831: , p5_a1 NUMBER := 0-1962.0724
832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

829: , x_msg_data out nocopy VARCHAR2
830: , p5_a0 NUMBER := 0-1962.0724
831: , p5_a1 NUMBER := 0-1962.0724
832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724

Line 834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

830: , p5_a0 NUMBER := 0-1962.0724
831: , p5_a1 NUMBER := 0-1962.0724
832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724
838: , p5_a8 DATE := fnd_api.g_miss_date

Line 835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

831: , p5_a1 NUMBER := 0-1962.0724
832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724
838: , p5_a8 DATE := fnd_api.g_miss_date
839: , p5_a9 NUMBER := 0-1962.0724

Line 836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

832: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
833: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724
838: , p5_a8 DATE := fnd_api.g_miss_date
839: , p5_a9 NUMBER := 0-1962.0724
840: , p5_a10 DATE := fnd_api.g_miss_date

Line 838: , p5_a8 DATE := fnd_api.g_miss_date

834: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
835: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724
838: , p5_a8 DATE := fnd_api.g_miss_date
839: , p5_a9 NUMBER := 0-1962.0724
840: , p5_a10 DATE := fnd_api.g_miss_date
841: , p5_a11 NUMBER := 0-1962.0724
842: )

Line 840: , p5_a10 DATE := fnd_api.g_miss_date

836: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
837: , p5_a7 NUMBER := 0-1962.0724
838: , p5_a8 DATE := fnd_api.g_miss_date
839: , p5_a9 NUMBER := 0-1962.0724
840: , p5_a10 DATE := fnd_api.g_miss_date
841: , p5_a11 NUMBER := 0-1962.0724
842: )
843:
844: as

Line 951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

947: , x_msg_count out nocopy NUMBER
948: , x_msg_data out nocopy VARCHAR2
949: , p5_a0 NUMBER := 0-1962.0724
950: , p5_a1 NUMBER := 0-1962.0724
951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

948: , x_msg_data out nocopy VARCHAR2
949: , p5_a0 NUMBER := 0-1962.0724
950: , p5_a1 NUMBER := 0-1962.0724
951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724

Line 953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

949: , p5_a0 NUMBER := 0-1962.0724
950: , p5_a1 NUMBER := 0-1962.0724
951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724
957: , p5_a8 DATE := fnd_api.g_miss_date

Line 954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

950: , p5_a1 NUMBER := 0-1962.0724
951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724
957: , p5_a8 DATE := fnd_api.g_miss_date
958: , p5_a9 NUMBER := 0-1962.0724

Line 955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

951: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724
957: , p5_a8 DATE := fnd_api.g_miss_date
958: , p5_a9 NUMBER := 0-1962.0724
959: , p5_a10 DATE := fnd_api.g_miss_date

Line 957: , p5_a8 DATE := fnd_api.g_miss_date

953: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724
957: , p5_a8 DATE := fnd_api.g_miss_date
958: , p5_a9 NUMBER := 0-1962.0724
959: , p5_a10 DATE := fnd_api.g_miss_date
960: , p5_a11 NUMBER := 0-1962.0724
961: )

Line 959: , p5_a10 DATE := fnd_api.g_miss_date

955: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
956: , p5_a7 NUMBER := 0-1962.0724
957: , p5_a8 DATE := fnd_api.g_miss_date
958: , p5_a9 NUMBER := 0-1962.0724
959: , p5_a10 DATE := fnd_api.g_miss_date
960: , p5_a11 NUMBER := 0-1962.0724
961: )
962:
963: as