DBA Data[Home] [Help]

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

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

Line 538: , p5_a4 DATE := fnd_api.g_miss_date

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

Line 539: , p5_a5 DATE := fnd_api.g_miss_date

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

Line 540: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

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

Line 541: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

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

Line 542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

538: , p5_a4 DATE := fnd_api.g_miss_date
539: , p5_a5 DATE := fnd_api.g_miss_date
540: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

539: , p5_a5 DATE := fnd_api.g_miss_date
540: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

540: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

541: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

542: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

543: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

544: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

545: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

546: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

547: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

548: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

549: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a23 NUMBER := 0-1962.0724

Line 554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

550: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a23 NUMBER := 0-1962.0724
558: , p5_a24 NUMBER := 0-1962.0724

Line 555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

551: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a23 NUMBER := 0-1962.0724
558: , p5_a24 NUMBER := 0-1962.0724
559: , p5_a25 DATE := fnd_api.g_miss_date

Line 556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

552: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
553: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
554: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a23 NUMBER := 0-1962.0724
558: , p5_a24 NUMBER := 0-1962.0724
559: , p5_a25 DATE := fnd_api.g_miss_date
560: , p5_a26 NUMBER := 0-1962.0724

Line 559: , p5_a25 DATE := fnd_api.g_miss_date

555: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
556: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
557: , p5_a23 NUMBER := 0-1962.0724
558: , p5_a24 NUMBER := 0-1962.0724
559: , p5_a25 DATE := fnd_api.g_miss_date
560: , p5_a26 NUMBER := 0-1962.0724
561: , p5_a27 DATE := fnd_api.g_miss_date
562: , p5_a28 NUMBER := 0-1962.0724
563: )

Line 561: , p5_a27 DATE := fnd_api.g_miss_date

557: , p5_a23 NUMBER := 0-1962.0724
558: , p5_a24 NUMBER := 0-1962.0724
559: , p5_a25 DATE := fnd_api.g_miss_date
560: , p5_a26 NUMBER := 0-1962.0724
561: , p5_a27 DATE := fnd_api.g_miss_date
562: , p5_a28 NUMBER := 0-1962.0724
563: )
564:
565: as

Line 849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

845: , p6_a28 out nocopy NUMBER
846: , p5_a0 NUMBER := 0-1962.0724
847: , p5_a1 NUMBER := 0-1962.0724
848: , p5_a2 NUMBER := 0-1962.0724
849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 850: , p5_a4 DATE := fnd_api.g_miss_date

846: , p5_a0 NUMBER := 0-1962.0724
847: , p5_a1 NUMBER := 0-1962.0724
848: , p5_a2 NUMBER := 0-1962.0724
849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 851: , p5_a5 DATE := fnd_api.g_miss_date

847: , p5_a1 NUMBER := 0-1962.0724
848: , p5_a2 NUMBER := 0-1962.0724
849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

848: , p5_a2 NUMBER := 0-1962.0724
849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

849: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

850: , p5_a4 DATE := fnd_api.g_miss_date
851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

851: , p5_a5 DATE := fnd_api.g_miss_date
852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

852: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

853: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

854: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

855: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

856: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

857: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

858: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

859: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

860: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

861: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a23 NUMBER := 0-1962.0724

Line 866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

862: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a23 NUMBER := 0-1962.0724
870: , p5_a24 NUMBER := 0-1962.0724

Line 867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

863: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a23 NUMBER := 0-1962.0724
870: , p5_a24 NUMBER := 0-1962.0724
871: , p5_a25 DATE := fnd_api.g_miss_date

Line 868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

864: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a23 NUMBER := 0-1962.0724
870: , p5_a24 NUMBER := 0-1962.0724
871: , p5_a25 DATE := fnd_api.g_miss_date
872: , p5_a26 NUMBER := 0-1962.0724

Line 871: , p5_a25 DATE := fnd_api.g_miss_date

867: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
868: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
869: , p5_a23 NUMBER := 0-1962.0724
870: , p5_a24 NUMBER := 0-1962.0724
871: , p5_a25 DATE := fnd_api.g_miss_date
872: , p5_a26 NUMBER := 0-1962.0724
873: , p5_a27 DATE := fnd_api.g_miss_date
874: , p5_a28 NUMBER := 0-1962.0724
875: )

Line 873: , p5_a27 DATE := fnd_api.g_miss_date

869: , p5_a23 NUMBER := 0-1962.0724
870: , p5_a24 NUMBER := 0-1962.0724
871: , p5_a25 DATE := fnd_api.g_miss_date
872: , p5_a26 NUMBER := 0-1962.0724
873: , p5_a27 DATE := fnd_api.g_miss_date
874: , p5_a28 NUMBER := 0-1962.0724
875: )
876:
877: as

Line 1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char

1128: , x_msg_data out nocopy VARCHAR2
1129: , p5_a0 NUMBER := 0-1962.0724
1130: , p5_a1 NUMBER := 0-1962.0724
1131: , p5_a2 NUMBER := 0-1962.0724
1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 1133: , p5_a4 DATE := fnd_api.g_miss_date

1129: , p5_a0 NUMBER := 0-1962.0724
1130: , p5_a1 NUMBER := 0-1962.0724
1131: , p5_a2 NUMBER := 0-1962.0724
1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 1134: , p5_a5 DATE := fnd_api.g_miss_date

1130: , p5_a1 NUMBER := 0-1962.0724
1131: , p5_a2 NUMBER := 0-1962.0724
1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

1131: , p5_a2 NUMBER := 0-1962.0724
1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

Line 1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

1132: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

1133: , p5_a4 DATE := fnd_api.g_miss_date
1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

1134: , p5_a5 DATE := fnd_api.g_miss_date
1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

1135: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

Line 1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

1136: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

1137: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

1138: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

1139: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

1140: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

1141: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

1142: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

1143: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

1144: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a23 NUMBER := 0-1962.0724

Line 1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

1145: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a23 NUMBER := 0-1962.0724
1153: , p5_a24 NUMBER := 0-1962.0724

Line 1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

1146: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a23 NUMBER := 0-1962.0724
1153: , p5_a24 NUMBER := 0-1962.0724
1154: , p5_a25 DATE := fnd_api.g_miss_date

Line 1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

1147: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a23 NUMBER := 0-1962.0724
1153: , p5_a24 NUMBER := 0-1962.0724
1154: , p5_a25 DATE := fnd_api.g_miss_date
1155: , p5_a26 NUMBER := 0-1962.0724

Line 1154: , p5_a25 DATE := fnd_api.g_miss_date

1150: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a23 NUMBER := 0-1962.0724
1153: , p5_a24 NUMBER := 0-1962.0724
1154: , p5_a25 DATE := fnd_api.g_miss_date
1155: , p5_a26 NUMBER := 0-1962.0724
1156: , p5_a27 DATE := fnd_api.g_miss_date
1157: , p5_a28 NUMBER := 0-1962.0724
1158: )

Line 1156: , p5_a27 DATE := fnd_api.g_miss_date

1152: , p5_a23 NUMBER := 0-1962.0724
1153: , p5_a24 NUMBER := 0-1962.0724
1154: , p5_a25 DATE := fnd_api.g_miss_date
1155: , p5_a26 NUMBER := 0-1962.0724
1156: , p5_a27 DATE := fnd_api.g_miss_date
1157: , p5_a28 NUMBER := 0-1962.0724
1158: )
1159:
1160: as