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;
796: , p6_a38 out nocopy DATE
797: , p6_a39 out nocopy NUMBER
798: , p5_a0 NUMBER := 0-1962.0724
799: , p5_a1 NUMBER := 0-1962.0724
800: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a3 NUMBER := 0-1962.0724
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a0 NUMBER := 0-1962.0724
799: , p5_a1 NUMBER := 0-1962.0724
800: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a3 NUMBER := 0-1962.0724
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
799: , p5_a1 NUMBER := 0-1962.0724
800: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a3 NUMBER := 0-1962.0724
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
800: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a3 NUMBER := 0-1962.0724
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a3 NUMBER := 0-1962.0724
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
803: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a7 DATE := fnd_api.g_miss_date
806: , p5_a8 DATE := fnd_api.g_miss_date
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a12 NUMBER := 0-1962.0724
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
818: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
819: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
827: , p5_a29 DATE := fnd_api.g_miss_date
820: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
827: , p5_a29 DATE := fnd_api.g_miss_date
828: , p5_a30 NUMBER := 0-1962.0724
821: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
827: , p5_a29 DATE := fnd_api.g_miss_date
828: , p5_a30 NUMBER := 0-1962.0724
829: , p5_a31 NUMBER := 0-1962.0724
822: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
827: , p5_a29 DATE := fnd_api.g_miss_date
828: , p5_a30 NUMBER := 0-1962.0724
829: , p5_a31 NUMBER := 0-1962.0724
830: , p5_a32 NUMBER := 0-1962.0724
823: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
824: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
825: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
826: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
827: , p5_a29 DATE := fnd_api.g_miss_date
828: , p5_a30 NUMBER := 0-1962.0724
829: , p5_a31 NUMBER := 0-1962.0724
830: , p5_a32 NUMBER := 0-1962.0724
831: , p5_a33 NUMBER := 0-1962.0724
828: , p5_a30 NUMBER := 0-1962.0724
829: , p5_a31 NUMBER := 0-1962.0724
830: , p5_a32 NUMBER := 0-1962.0724
831: , p5_a33 NUMBER := 0-1962.0724
832: , p5_a34 DATE := fnd_api.g_miss_date
833: , p5_a35 NUMBER := 0-1962.0724
834: , p5_a36 DATE := fnd_api.g_miss_date
835: , p5_a37 NUMBER := 0-1962.0724
836: , p5_a38 DATE := fnd_api.g_miss_date
830: , p5_a32 NUMBER := 0-1962.0724
831: , p5_a33 NUMBER := 0-1962.0724
832: , p5_a34 DATE := fnd_api.g_miss_date
833: , p5_a35 NUMBER := 0-1962.0724
834: , p5_a36 DATE := fnd_api.g_miss_date
835: , p5_a37 NUMBER := 0-1962.0724
836: , p5_a38 DATE := fnd_api.g_miss_date
837: , p5_a39 NUMBER := 0-1962.0724
838: )
832: , p5_a34 DATE := fnd_api.g_miss_date
833: , p5_a35 NUMBER := 0-1962.0724
834: , p5_a36 DATE := fnd_api.g_miss_date
835: , p5_a37 NUMBER := 0-1962.0724
836: , p5_a38 DATE := fnd_api.g_miss_date
837: , p5_a39 NUMBER := 0-1962.0724
838: )
839:
840: as
1156: , x_msg_count out nocopy NUMBER
1157: , x_msg_data out nocopy VARCHAR2
1158: , p5_a0 NUMBER := 0-1962.0724
1159: , p5_a1 NUMBER := 0-1962.0724
1160: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a3 NUMBER := 0-1962.0724
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a0 NUMBER := 0-1962.0724
1159: , p5_a1 NUMBER := 0-1962.0724
1160: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a3 NUMBER := 0-1962.0724
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1159: , p5_a1 NUMBER := 0-1962.0724
1160: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a3 NUMBER := 0-1962.0724
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a3 NUMBER := 0-1962.0724
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1161: , p5_a3 NUMBER := 0-1962.0724
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1162: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1163: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1164: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1165: , p5_a7 DATE := fnd_api.g_miss_date
1166: , p5_a8 DATE := fnd_api.g_miss_date
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1167: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1168: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1169: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1170: , p5_a12 NUMBER := 0-1962.0724
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1171: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1172: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1173: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1174: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1175: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1176: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1177: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1178: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1179: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a29 DATE := fnd_api.g_miss_date
1180: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a29 DATE := fnd_api.g_miss_date
1188: , p5_a30 NUMBER := 0-1962.0724
1181: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a29 DATE := fnd_api.g_miss_date
1188: , p5_a30 NUMBER := 0-1962.0724
1189: , p5_a31 NUMBER := 0-1962.0724
1182: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a29 DATE := fnd_api.g_miss_date
1188: , p5_a30 NUMBER := 0-1962.0724
1189: , p5_a31 NUMBER := 0-1962.0724
1190: , p5_a32 NUMBER := 0-1962.0724
1183: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1184: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1185: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1186: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1187: , p5_a29 DATE := fnd_api.g_miss_date
1188: , p5_a30 NUMBER := 0-1962.0724
1189: , p5_a31 NUMBER := 0-1962.0724
1190: , p5_a32 NUMBER := 0-1962.0724
1191: , p5_a33 NUMBER := 0-1962.0724
1188: , p5_a30 NUMBER := 0-1962.0724
1189: , p5_a31 NUMBER := 0-1962.0724
1190: , p5_a32 NUMBER := 0-1962.0724
1191: , p5_a33 NUMBER := 0-1962.0724
1192: , p5_a34 DATE := fnd_api.g_miss_date
1193: , p5_a35 NUMBER := 0-1962.0724
1194: , p5_a36 DATE := fnd_api.g_miss_date
1195: , p5_a37 NUMBER := 0-1962.0724
1196: , p5_a38 DATE := fnd_api.g_miss_date
1190: , p5_a32 NUMBER := 0-1962.0724
1191: , p5_a33 NUMBER := 0-1962.0724
1192: , p5_a34 DATE := fnd_api.g_miss_date
1193: , p5_a35 NUMBER := 0-1962.0724
1194: , p5_a36 DATE := fnd_api.g_miss_date
1195: , p5_a37 NUMBER := 0-1962.0724
1196: , p5_a38 DATE := fnd_api.g_miss_date
1197: , p5_a39 NUMBER := 0-1962.0724
1198: )
1192: , p5_a34 DATE := fnd_api.g_miss_date
1193: , p5_a35 NUMBER := 0-1962.0724
1194: , p5_a36 DATE := fnd_api.g_miss_date
1195: , p5_a37 NUMBER := 0-1962.0724
1196: , p5_a38 DATE := fnd_api.g_miss_date
1197: , p5_a39 NUMBER := 0-1962.0724
1198: )
1199:
1200: as
1427: , p6_a38 out nocopy DATE
1428: , p6_a39 out nocopy NUMBER
1429: , p5_a0 NUMBER := 0-1962.0724
1430: , p5_a1 NUMBER := 0-1962.0724
1431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a3 NUMBER := 0-1962.0724
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1429: , p5_a0 NUMBER := 0-1962.0724
1430: , p5_a1 NUMBER := 0-1962.0724
1431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a3 NUMBER := 0-1962.0724
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1430: , p5_a1 NUMBER := 0-1962.0724
1431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a3 NUMBER := 0-1962.0724
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1431: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a3 NUMBER := 0-1962.0724
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1432: , p5_a3 NUMBER := 0-1962.0724
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1433: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1434: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1435: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1436: , p5_a7 DATE := fnd_api.g_miss_date
1437: , p5_a8 DATE := fnd_api.g_miss_date
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1438: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1439: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1440: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1441: , p5_a12 NUMBER := 0-1962.0724
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1442: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1443: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1444: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1445: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1447: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a29 DATE := fnd_api.g_miss_date
1451: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a29 DATE := fnd_api.g_miss_date
1459: , p5_a30 NUMBER := 0-1962.0724
1452: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a29 DATE := fnd_api.g_miss_date
1459: , p5_a30 NUMBER := 0-1962.0724
1460: , p5_a31 NUMBER := 0-1962.0724
1453: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a29 DATE := fnd_api.g_miss_date
1459: , p5_a30 NUMBER := 0-1962.0724
1460: , p5_a31 NUMBER := 0-1962.0724
1461: , p5_a32 NUMBER := 0-1962.0724
1454: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a29 DATE := fnd_api.g_miss_date
1459: , p5_a30 NUMBER := 0-1962.0724
1460: , p5_a31 NUMBER := 0-1962.0724
1461: , p5_a32 NUMBER := 0-1962.0724
1462: , p5_a33 NUMBER := 0-1962.0724
1459: , p5_a30 NUMBER := 0-1962.0724
1460: , p5_a31 NUMBER := 0-1962.0724
1461: , p5_a32 NUMBER := 0-1962.0724
1462: , p5_a33 NUMBER := 0-1962.0724
1463: , p5_a34 DATE := fnd_api.g_miss_date
1464: , p5_a35 NUMBER := 0-1962.0724
1465: , p5_a36 DATE := fnd_api.g_miss_date
1466: , p5_a37 NUMBER := 0-1962.0724
1467: , p5_a38 DATE := fnd_api.g_miss_date
1461: , p5_a32 NUMBER := 0-1962.0724
1462: , p5_a33 NUMBER := 0-1962.0724
1463: , p5_a34 DATE := fnd_api.g_miss_date
1464: , p5_a35 NUMBER := 0-1962.0724
1465: , p5_a36 DATE := fnd_api.g_miss_date
1466: , p5_a37 NUMBER := 0-1962.0724
1467: , p5_a38 DATE := fnd_api.g_miss_date
1468: , p5_a39 NUMBER := 0-1962.0724
1469: )
1463: , p5_a34 DATE := fnd_api.g_miss_date
1464: , p5_a35 NUMBER := 0-1962.0724
1465: , p5_a36 DATE := fnd_api.g_miss_date
1466: , p5_a37 NUMBER := 0-1962.0724
1467: , p5_a38 DATE := fnd_api.g_miss_date
1468: , p5_a39 NUMBER := 0-1962.0724
1469: )
1470:
1471: as
1787: , x_msg_count out nocopy NUMBER
1788: , x_msg_data out nocopy VARCHAR2
1789: , p5_a0 NUMBER := 0-1962.0724
1790: , p5_a1 NUMBER := 0-1962.0724
1791: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a3 NUMBER := 0-1962.0724
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a0 NUMBER := 0-1962.0724
1790: , p5_a1 NUMBER := 0-1962.0724
1791: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a3 NUMBER := 0-1962.0724
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1790: , p5_a1 NUMBER := 0-1962.0724
1791: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a3 NUMBER := 0-1962.0724
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a3 NUMBER := 0-1962.0724
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a3 NUMBER := 0-1962.0724
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1794: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a7 DATE := fnd_api.g_miss_date
1797: , p5_a8 DATE := fnd_api.g_miss_date
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a12 NUMBER := 0-1962.0724
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a29 DATE := fnd_api.g_miss_date
1811: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a29 DATE := fnd_api.g_miss_date
1819: , p5_a30 NUMBER := 0-1962.0724
1812: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a29 DATE := fnd_api.g_miss_date
1819: , p5_a30 NUMBER := 0-1962.0724
1820: , p5_a31 NUMBER := 0-1962.0724
1813: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a29 DATE := fnd_api.g_miss_date
1819: , p5_a30 NUMBER := 0-1962.0724
1820: , p5_a31 NUMBER := 0-1962.0724
1821: , p5_a32 NUMBER := 0-1962.0724
1814: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1815: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1816: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1817: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1818: , p5_a29 DATE := fnd_api.g_miss_date
1819: , p5_a30 NUMBER := 0-1962.0724
1820: , p5_a31 NUMBER := 0-1962.0724
1821: , p5_a32 NUMBER := 0-1962.0724
1822: , p5_a33 NUMBER := 0-1962.0724
1819: , p5_a30 NUMBER := 0-1962.0724
1820: , p5_a31 NUMBER := 0-1962.0724
1821: , p5_a32 NUMBER := 0-1962.0724
1822: , p5_a33 NUMBER := 0-1962.0724
1823: , p5_a34 DATE := fnd_api.g_miss_date
1824: , p5_a35 NUMBER := 0-1962.0724
1825: , p5_a36 DATE := fnd_api.g_miss_date
1826: , p5_a37 NUMBER := 0-1962.0724
1827: , p5_a38 DATE := fnd_api.g_miss_date
1821: , p5_a32 NUMBER := 0-1962.0724
1822: , p5_a33 NUMBER := 0-1962.0724
1823: , p5_a34 DATE := fnd_api.g_miss_date
1824: , p5_a35 NUMBER := 0-1962.0724
1825: , p5_a36 DATE := fnd_api.g_miss_date
1826: , p5_a37 NUMBER := 0-1962.0724
1827: , p5_a38 DATE := fnd_api.g_miss_date
1828: , p5_a39 NUMBER := 0-1962.0724
1829: )
1823: , p5_a34 DATE := fnd_api.g_miss_date
1824: , p5_a35 NUMBER := 0-1962.0724
1825: , p5_a36 DATE := fnd_api.g_miss_date
1826: , p5_a37 NUMBER := 0-1962.0724
1827: , p5_a38 DATE := fnd_api.g_miss_date
1828: , p5_a39 NUMBER := 0-1962.0724
1829: )
1830:
1831: as
2018: , x_msg_count out nocopy NUMBER
2019: , x_msg_data out nocopy VARCHAR2
2020: , p5_a0 NUMBER := 0-1962.0724
2021: , p5_a1 NUMBER := 0-1962.0724
2022: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2023: , p5_a3 NUMBER := 0-1962.0724
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2020: , p5_a0 NUMBER := 0-1962.0724
2021: , p5_a1 NUMBER := 0-1962.0724
2022: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2023: , p5_a3 NUMBER := 0-1962.0724
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2021: , p5_a1 NUMBER := 0-1962.0724
2022: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2023: , p5_a3 NUMBER := 0-1962.0724
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2022: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2023: , p5_a3 NUMBER := 0-1962.0724
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2023: , p5_a3 NUMBER := 0-1962.0724
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2024: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2025: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2026: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2027: , p5_a7 DATE := fnd_api.g_miss_date
2028: , p5_a8 DATE := fnd_api.g_miss_date
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2029: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2030: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2031: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2032: , p5_a12 NUMBER := 0-1962.0724
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2033: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2034: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2035: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2036: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2037: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2038: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2039: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2040: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2041: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2049: , p5_a29 DATE := fnd_api.g_miss_date
2042: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2049: , p5_a29 DATE := fnd_api.g_miss_date
2050: , p5_a30 NUMBER := 0-1962.0724
2043: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2049: , p5_a29 DATE := fnd_api.g_miss_date
2050: , p5_a30 NUMBER := 0-1962.0724
2051: , p5_a31 NUMBER := 0-1962.0724
2044: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2049: , p5_a29 DATE := fnd_api.g_miss_date
2050: , p5_a30 NUMBER := 0-1962.0724
2051: , p5_a31 NUMBER := 0-1962.0724
2052: , p5_a32 NUMBER := 0-1962.0724
2045: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2046: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2047: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2048: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
2049: , p5_a29 DATE := fnd_api.g_miss_date
2050: , p5_a30 NUMBER := 0-1962.0724
2051: , p5_a31 NUMBER := 0-1962.0724
2052: , p5_a32 NUMBER := 0-1962.0724
2053: , p5_a33 NUMBER := 0-1962.0724
2050: , p5_a30 NUMBER := 0-1962.0724
2051: , p5_a31 NUMBER := 0-1962.0724
2052: , p5_a32 NUMBER := 0-1962.0724
2053: , p5_a33 NUMBER := 0-1962.0724
2054: , p5_a34 DATE := fnd_api.g_miss_date
2055: , p5_a35 NUMBER := 0-1962.0724
2056: , p5_a36 DATE := fnd_api.g_miss_date
2057: , p5_a37 NUMBER := 0-1962.0724
2058: , p5_a38 DATE := fnd_api.g_miss_date
2052: , p5_a32 NUMBER := 0-1962.0724
2053: , p5_a33 NUMBER := 0-1962.0724
2054: , p5_a34 DATE := fnd_api.g_miss_date
2055: , p5_a35 NUMBER := 0-1962.0724
2056: , p5_a36 DATE := fnd_api.g_miss_date
2057: , p5_a37 NUMBER := 0-1962.0724
2058: , p5_a38 DATE := fnd_api.g_miss_date
2059: , p5_a39 NUMBER := 0-1962.0724
2060: )
2054: , p5_a34 DATE := fnd_api.g_miss_date
2055: , p5_a35 NUMBER := 0-1962.0724
2056: , p5_a36 DATE := fnd_api.g_miss_date
2057: , p5_a37 NUMBER := 0-1962.0724
2058: , p5_a38 DATE := fnd_api.g_miss_date
2059: , p5_a39 NUMBER := 0-1962.0724
2060: )
2061:
2062: as