APPS.OZF_PRICELIST_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 797: , p7_a0 VARCHAR2 := fnd_api.g_miss_char

793: , p10_a31 JTF_VARCHAR2_TABLE_300
794: , x_list_header_id out nocopy NUMBER
795: , x_error_source out nocopy VARCHAR2
796: , x_error_location out nocopy NUMBER
797: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
798: , p7_a1 DATE := fnd_api.g_miss_date
799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

Line 798: , p7_a1 DATE := fnd_api.g_miss_date

794: , x_list_header_id out nocopy NUMBER
795: , x_error_source out nocopy VARCHAR2
796: , x_error_location out nocopy NUMBER
797: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
798: , p7_a1 DATE := fnd_api.g_miss_date
799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

Line 800: , p7_a3 DATE := fnd_api.g_miss_date

796: , x_error_location out nocopy NUMBER
797: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
798: , p7_a1 DATE := fnd_api.g_miss_date
799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

797: , p7_a0 VARCHAR2 := fnd_api.g_miss_char
798: , p7_a1 DATE := fnd_api.g_miss_date
799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
805: , p7_a8 NUMBER := 0-1962.0724

Line 802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

798: , p7_a1 DATE := fnd_api.g_miss_date
799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
805: , p7_a8 NUMBER := 0-1962.0724
806: , p7_a9 NUMBER := 0-1962.0724

Line 803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

799: , p7_a2 NUMBER := 0-1962.0724
800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
805: , p7_a8 NUMBER := 0-1962.0724
806: , p7_a9 NUMBER := 0-1962.0724
807: , p7_a10 NUMBER := 0-1962.0724

Line 804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

800: , p7_a3 DATE := fnd_api.g_miss_date
801: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
802: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
803: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
805: , p7_a8 NUMBER := 0-1962.0724
806: , p7_a9 NUMBER := 0-1962.0724
807: , p7_a10 NUMBER := 0-1962.0724
808: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 808: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

804: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
805: , p7_a8 NUMBER := 0-1962.0724
806: , p7_a9 NUMBER := 0-1962.0724
807: , p7_a10 NUMBER := 0-1962.0724
808: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p7_a12 NUMBER := 0-1962.0724
810: , p7_a13 NUMBER := 0-1962.0724
811: , p7_a14 NUMBER := 0-1962.0724
812: , p7_a15 DATE := fnd_api.g_miss_date

Line 812: , p7_a15 DATE := fnd_api.g_miss_date

808: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
809: , p7_a12 NUMBER := 0-1962.0724
810: , p7_a13 NUMBER := 0-1962.0724
811: , p7_a14 NUMBER := 0-1962.0724
812: , p7_a15 DATE := fnd_api.g_miss_date
813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

809: , p7_a12 NUMBER := 0-1962.0724
810: , p7_a13 NUMBER := 0-1962.0724
811: , p7_a14 NUMBER := 0-1962.0724
812: , p7_a15 DATE := fnd_api.g_miss_date
813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

811: , p7_a14 NUMBER := 0-1962.0724
812: , p7_a15 DATE := fnd_api.g_miss_date
813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

812: , p7_a15 DATE := fnd_api.g_miss_date
813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

813: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

814: , p7_a17 NUMBER := 0-1962.0724
815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

Line 819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

815: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

Line 820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

816: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

Line 821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

817: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

Line 822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char

818: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

Line 823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char

819: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

Line 824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char

820: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

Line 825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char

821: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

Line 826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char

822: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

Line 827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char

823: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char

Line 828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char

824: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
832: , p7_a35 NUMBER := 0-1962.0724

Line 829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char

825: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
832: , p7_a35 NUMBER := 0-1962.0724
833: )

Line 830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char

826: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
832: , p7_a35 NUMBER := 0-1962.0724
833: )
834:

Line 831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char

827: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
828: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
829: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
830: , p7_a33 VARCHAR2 := fnd_api.g_miss_char
831: , p7_a34 VARCHAR2 := fnd_api.g_miss_char
832: , p7_a35 NUMBER := 0-1962.0724
833: )
834:
835: as