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
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;
789: , p6_a38 out nocopy DATE
790: , p6_a39 out nocopy NUMBER
791: , p5_a0 NUMBER := 0-1962.0724
792: , p5_a1 NUMBER := 0-1962.0724
793: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a3 NUMBER := 0-1962.0724
795: , p5_a4 NUMBER := 0-1962.0724
796: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a1 NUMBER := 0-1962.0724
793: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a3 NUMBER := 0-1962.0724
795: , p5_a4 NUMBER := 0-1962.0724
796: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
793: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a3 NUMBER := 0-1962.0724
795: , p5_a4 NUMBER := 0-1962.0724
796: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
794: , p5_a3 NUMBER := 0-1962.0724
795: , p5_a4 NUMBER := 0-1962.0724
796: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
802: , p5_a11 DATE := fnd_api.g_miss_date
796: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
802: , p5_a11 DATE := fnd_api.g_miss_date
803: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
802: , p5_a11 DATE := fnd_api.g_miss_date
803: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a14 NUMBER := 0-1962.0724
806: , p5_a15 NUMBER := 0-1962.0724
799: , p5_a8 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
802: , p5_a11 DATE := fnd_api.g_miss_date
803: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a14 NUMBER := 0-1962.0724
806: , p5_a15 NUMBER := 0-1962.0724
807: , p5_a16 NUMBER := 0-1962.0724
800: , p5_a9 DATE := fnd_api.g_miss_date
801: , p5_a10 NUMBER := 0-1962.0724
802: , p5_a11 DATE := fnd_api.g_miss_date
803: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a14 NUMBER := 0-1962.0724
806: , p5_a15 NUMBER := 0-1962.0724
807: , p5_a16 NUMBER := 0-1962.0724
808: , p5_a17 NUMBER := 0-1962.0724
805: , p5_a14 NUMBER := 0-1962.0724
806: , p5_a15 NUMBER := 0-1962.0724
807: , p5_a16 NUMBER := 0-1962.0724
808: , p5_a17 NUMBER := 0-1962.0724
809: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a15 NUMBER := 0-1962.0724
807: , p5_a16 NUMBER := 0-1962.0724
808: , p5_a17 NUMBER := 0-1962.0724
809: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a16 NUMBER := 0-1962.0724
808: , p5_a17 NUMBER := 0-1962.0724
809: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a17 NUMBER := 0-1962.0724
809: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
819: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
827: , p5_a36 DATE := fnd_api.g_miss_date
820: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
827: , p5_a36 DATE := fnd_api.g_miss_date
828: , p5_a37 NUMBER := 0-1962.0724
821: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
827: , p5_a36 DATE := fnd_api.g_miss_date
828: , p5_a37 NUMBER := 0-1962.0724
829: , p5_a38 DATE := fnd_api.g_miss_date
823: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
827: , p5_a36 DATE := fnd_api.g_miss_date
828: , p5_a37 NUMBER := 0-1962.0724
829: , p5_a38 DATE := fnd_api.g_miss_date
830: , p5_a39 NUMBER := 0-1962.0724
831: )
825: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a35 NUMBER := 0-1962.0724
827: , p5_a36 DATE := fnd_api.g_miss_date
828: , p5_a37 NUMBER := 0-1962.0724
829: , p5_a38 DATE := fnd_api.g_miss_date
830: , p5_a39 NUMBER := 0-1962.0724
831: )
832:
833: as
1149: , x_msg_count out nocopy NUMBER
1150: , x_msg_data out nocopy VARCHAR2
1151: , p5_a0 NUMBER := 0-1962.0724
1152: , p5_a1 NUMBER := 0-1962.0724
1153: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a3 NUMBER := 0-1962.0724
1155: , p5_a4 NUMBER := 0-1962.0724
1156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a1 NUMBER := 0-1962.0724
1153: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a3 NUMBER := 0-1962.0724
1155: , p5_a4 NUMBER := 0-1962.0724
1156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1153: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a3 NUMBER := 0-1962.0724
1155: , p5_a4 NUMBER := 0-1962.0724
1156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1154: , p5_a3 NUMBER := 0-1962.0724
1155: , p5_a4 NUMBER := 0-1962.0724
1156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1162: , p5_a11 DATE := fnd_api.g_miss_date
1156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1162: , p5_a11 DATE := fnd_api.g_miss_date
1163: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1162: , p5_a11 DATE := fnd_api.g_miss_date
1163: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a14 NUMBER := 0-1962.0724
1166: , p5_a15 NUMBER := 0-1962.0724
1159: , p5_a8 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1162: , p5_a11 DATE := fnd_api.g_miss_date
1163: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a14 NUMBER := 0-1962.0724
1166: , p5_a15 NUMBER := 0-1962.0724
1167: , p5_a16 NUMBER := 0-1962.0724
1160: , p5_a9 DATE := fnd_api.g_miss_date
1161: , p5_a10 NUMBER := 0-1962.0724
1162: , p5_a11 DATE := fnd_api.g_miss_date
1163: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a14 NUMBER := 0-1962.0724
1166: , p5_a15 NUMBER := 0-1962.0724
1167: , p5_a16 NUMBER := 0-1962.0724
1168: , p5_a17 NUMBER := 0-1962.0724
1165: , p5_a14 NUMBER := 0-1962.0724
1166: , p5_a15 NUMBER := 0-1962.0724
1167: , p5_a16 NUMBER := 0-1962.0724
1168: , p5_a17 NUMBER := 0-1962.0724
1169: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1166: , p5_a15 NUMBER := 0-1962.0724
1167: , p5_a16 NUMBER := 0-1962.0724
1168: , p5_a17 NUMBER := 0-1962.0724
1169: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1167: , p5_a16 NUMBER := 0-1962.0724
1168: , p5_a17 NUMBER := 0-1962.0724
1169: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a17 NUMBER := 0-1962.0724
1169: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1179: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1187: , p5_a36 DATE := fnd_api.g_miss_date
1180: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1187: , p5_a36 DATE := fnd_api.g_miss_date
1188: , p5_a37 NUMBER := 0-1962.0724
1181: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1187: , p5_a36 DATE := fnd_api.g_miss_date
1188: , p5_a37 NUMBER := 0-1962.0724
1189: , p5_a38 DATE := fnd_api.g_miss_date
1183: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1187: , p5_a36 DATE := fnd_api.g_miss_date
1188: , p5_a37 NUMBER := 0-1962.0724
1189: , p5_a38 DATE := fnd_api.g_miss_date
1190: , p5_a39 NUMBER := 0-1962.0724
1191: )
1185: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a35 NUMBER := 0-1962.0724
1187: , p5_a36 DATE := fnd_api.g_miss_date
1188: , p5_a37 NUMBER := 0-1962.0724
1189: , p5_a38 DATE := fnd_api.g_miss_date
1190: , p5_a39 NUMBER := 0-1962.0724
1191: )
1192:
1193: as
1420: , p6_a38 out nocopy DATE
1421: , p6_a39 out nocopy NUMBER
1422: , p5_a0 NUMBER := 0-1962.0724
1423: , p5_a1 NUMBER := 0-1962.0724
1424: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a3 NUMBER := 0-1962.0724
1426: , p5_a4 NUMBER := 0-1962.0724
1427: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1423: , p5_a1 NUMBER := 0-1962.0724
1424: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a3 NUMBER := 0-1962.0724
1426: , p5_a4 NUMBER := 0-1962.0724
1427: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1424: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1425: , p5_a3 NUMBER := 0-1962.0724
1426: , p5_a4 NUMBER := 0-1962.0724
1427: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1425: , p5_a3 NUMBER := 0-1962.0724
1426: , p5_a4 NUMBER := 0-1962.0724
1427: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1433: , p5_a11 DATE := fnd_api.g_miss_date
1427: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1428: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1433: , p5_a11 DATE := fnd_api.g_miss_date
1434: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1433: , p5_a11 DATE := fnd_api.g_miss_date
1434: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a14 NUMBER := 0-1962.0724
1437: , p5_a15 NUMBER := 0-1962.0724
1430: , p5_a8 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1433: , p5_a11 DATE := fnd_api.g_miss_date
1434: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a14 NUMBER := 0-1962.0724
1437: , p5_a15 NUMBER := 0-1962.0724
1438: , p5_a16 NUMBER := 0-1962.0724
1431: , p5_a9 DATE := fnd_api.g_miss_date
1432: , p5_a10 NUMBER := 0-1962.0724
1433: , p5_a11 DATE := fnd_api.g_miss_date
1434: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a14 NUMBER := 0-1962.0724
1437: , p5_a15 NUMBER := 0-1962.0724
1438: , p5_a16 NUMBER := 0-1962.0724
1439: , p5_a17 NUMBER := 0-1962.0724
1436: , p5_a14 NUMBER := 0-1962.0724
1437: , p5_a15 NUMBER := 0-1962.0724
1438: , p5_a16 NUMBER := 0-1962.0724
1439: , p5_a17 NUMBER := 0-1962.0724
1440: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1437: , p5_a15 NUMBER := 0-1962.0724
1438: , p5_a16 NUMBER := 0-1962.0724
1439: , p5_a17 NUMBER := 0-1962.0724
1440: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a16 NUMBER := 0-1962.0724
1439: , p5_a17 NUMBER := 0-1962.0724
1440: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a17 NUMBER := 0-1962.0724
1440: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1450: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1458: , p5_a36 DATE := fnd_api.g_miss_date
1451: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1458: , p5_a36 DATE := fnd_api.g_miss_date
1459: , p5_a37 NUMBER := 0-1962.0724
1452: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1458: , p5_a36 DATE := fnd_api.g_miss_date
1459: , p5_a37 NUMBER := 0-1962.0724
1460: , p5_a38 DATE := fnd_api.g_miss_date
1454: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1458: , p5_a36 DATE := fnd_api.g_miss_date
1459: , p5_a37 NUMBER := 0-1962.0724
1460: , p5_a38 DATE := fnd_api.g_miss_date
1461: , p5_a39 NUMBER := 0-1962.0724
1462: )
1456: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a35 NUMBER := 0-1962.0724
1458: , p5_a36 DATE := fnd_api.g_miss_date
1459: , p5_a37 NUMBER := 0-1962.0724
1460: , p5_a38 DATE := fnd_api.g_miss_date
1461: , p5_a39 NUMBER := 0-1962.0724
1462: )
1463:
1464: as
1780: , x_msg_count out nocopy NUMBER
1781: , x_msg_data out nocopy VARCHAR2
1782: , p5_a0 NUMBER := 0-1962.0724
1783: , p5_a1 NUMBER := 0-1962.0724
1784: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a3 NUMBER := 0-1962.0724
1786: , p5_a4 NUMBER := 0-1962.0724
1787: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1783: , p5_a1 NUMBER := 0-1962.0724
1784: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a3 NUMBER := 0-1962.0724
1786: , p5_a4 NUMBER := 0-1962.0724
1787: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1784: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a3 NUMBER := 0-1962.0724
1786: , p5_a4 NUMBER := 0-1962.0724
1787: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1785: , p5_a3 NUMBER := 0-1962.0724
1786: , p5_a4 NUMBER := 0-1962.0724
1787: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1793: , p5_a11 DATE := fnd_api.g_miss_date
1787: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1793: , p5_a11 DATE := fnd_api.g_miss_date
1794: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1793: , p5_a11 DATE := fnd_api.g_miss_date
1794: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a14 NUMBER := 0-1962.0724
1797: , p5_a15 NUMBER := 0-1962.0724
1790: , p5_a8 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1793: , p5_a11 DATE := fnd_api.g_miss_date
1794: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a14 NUMBER := 0-1962.0724
1797: , p5_a15 NUMBER := 0-1962.0724
1798: , p5_a16 NUMBER := 0-1962.0724
1791: , p5_a9 DATE := fnd_api.g_miss_date
1792: , p5_a10 NUMBER := 0-1962.0724
1793: , p5_a11 DATE := fnd_api.g_miss_date
1794: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a14 NUMBER := 0-1962.0724
1797: , p5_a15 NUMBER := 0-1962.0724
1798: , p5_a16 NUMBER := 0-1962.0724
1799: , p5_a17 NUMBER := 0-1962.0724
1796: , p5_a14 NUMBER := 0-1962.0724
1797: , p5_a15 NUMBER := 0-1962.0724
1798: , p5_a16 NUMBER := 0-1962.0724
1799: , p5_a17 NUMBER := 0-1962.0724
1800: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a15 NUMBER := 0-1962.0724
1798: , p5_a16 NUMBER := 0-1962.0724
1799: , p5_a17 NUMBER := 0-1962.0724
1800: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a16 NUMBER := 0-1962.0724
1799: , p5_a17 NUMBER := 0-1962.0724
1800: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a17 NUMBER := 0-1962.0724
1800: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1810: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1818: , p5_a36 DATE := fnd_api.g_miss_date
1811: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1818: , p5_a36 DATE := fnd_api.g_miss_date
1819: , p5_a37 NUMBER := 0-1962.0724
1812: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1818: , p5_a36 DATE := fnd_api.g_miss_date
1819: , p5_a37 NUMBER := 0-1962.0724
1820: , p5_a38 DATE := fnd_api.g_miss_date
1814: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1818: , p5_a36 DATE := fnd_api.g_miss_date
1819: , p5_a37 NUMBER := 0-1962.0724
1820: , p5_a38 DATE := fnd_api.g_miss_date
1821: , p5_a39 NUMBER := 0-1962.0724
1822: )
1816: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a35 NUMBER := 0-1962.0724
1818: , p5_a36 DATE := fnd_api.g_miss_date
1819: , p5_a37 NUMBER := 0-1962.0724
1820: , p5_a38 DATE := fnd_api.g_miss_date
1821: , p5_a39 NUMBER := 0-1962.0724
1822: )
1823:
1824: as
2011: , x_msg_count out nocopy NUMBER
2012: , x_msg_data out nocopy VARCHAR2
2013: , p5_a0 NUMBER := 0-1962.0724
2014: , p5_a1 NUMBER := 0-1962.0724
2015: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2016: , p5_a3 NUMBER := 0-1962.0724
2017: , p5_a4 NUMBER := 0-1962.0724
2018: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2019: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2014: , p5_a1 NUMBER := 0-1962.0724
2015: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2016: , p5_a3 NUMBER := 0-1962.0724
2017: , p5_a4 NUMBER := 0-1962.0724
2018: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2019: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2015: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2016: , p5_a3 NUMBER := 0-1962.0724
2017: , p5_a4 NUMBER := 0-1962.0724
2018: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2019: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2016: , p5_a3 NUMBER := 0-1962.0724
2017: , p5_a4 NUMBER := 0-1962.0724
2018: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2019: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2024: , p5_a11 DATE := fnd_api.g_miss_date
2018: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2019: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2024: , p5_a11 DATE := fnd_api.g_miss_date
2025: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2024: , p5_a11 DATE := fnd_api.g_miss_date
2025: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a14 NUMBER := 0-1962.0724
2028: , p5_a15 NUMBER := 0-1962.0724
2021: , p5_a8 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2024: , p5_a11 DATE := fnd_api.g_miss_date
2025: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a14 NUMBER := 0-1962.0724
2028: , p5_a15 NUMBER := 0-1962.0724
2029: , p5_a16 NUMBER := 0-1962.0724
2022: , p5_a9 DATE := fnd_api.g_miss_date
2023: , p5_a10 NUMBER := 0-1962.0724
2024: , p5_a11 DATE := fnd_api.g_miss_date
2025: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a14 NUMBER := 0-1962.0724
2028: , p5_a15 NUMBER := 0-1962.0724
2029: , p5_a16 NUMBER := 0-1962.0724
2030: , p5_a17 NUMBER := 0-1962.0724
2027: , p5_a14 NUMBER := 0-1962.0724
2028: , p5_a15 NUMBER := 0-1962.0724
2029: , p5_a16 NUMBER := 0-1962.0724
2030: , p5_a17 NUMBER := 0-1962.0724
2031: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2028: , p5_a15 NUMBER := 0-1962.0724
2029: , p5_a16 NUMBER := 0-1962.0724
2030: , p5_a17 NUMBER := 0-1962.0724
2031: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2029: , p5_a16 NUMBER := 0-1962.0724
2030: , p5_a17 NUMBER := 0-1962.0724
2031: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a17 NUMBER := 0-1962.0724
2031: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2041: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2049: , p5_a36 DATE := fnd_api.g_miss_date
2042: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2049: , p5_a36 DATE := fnd_api.g_miss_date
2050: , p5_a37 NUMBER := 0-1962.0724
2043: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2049: , p5_a36 DATE := fnd_api.g_miss_date
2050: , p5_a37 NUMBER := 0-1962.0724
2051: , p5_a38 DATE := fnd_api.g_miss_date
2045: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2049: , p5_a36 DATE := fnd_api.g_miss_date
2050: , p5_a37 NUMBER := 0-1962.0724
2051: , p5_a38 DATE := fnd_api.g_miss_date
2052: , p5_a39 NUMBER := 0-1962.0724
2053: )
2047: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a35 NUMBER := 0-1962.0724
2049: , p5_a36 DATE := fnd_api.g_miss_date
2050: , p5_a37 NUMBER := 0-1962.0724
2051: , p5_a38 DATE := fnd_api.g_miss_date
2052: , p5_a39 NUMBER := 0-1962.0724
2053: )
2054:
2055: as