7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
837: , p6_a41 out nocopy DATE
838: , p6_a42 out nocopy NUMBER
839: , p5_a0 NUMBER := 0-1962.0724
840: , p5_a1 NUMBER := 0-1962.0724
841: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a4 DATE := fnd_api.g_miss_date
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
838: , p6_a42 out nocopy NUMBER
839: , p5_a0 NUMBER := 0-1962.0724
840: , p5_a1 NUMBER := 0-1962.0724
841: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a4 DATE := fnd_api.g_miss_date
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
846: , p5_a7 NUMBER := 0-1962.0724
839: , p5_a0 NUMBER := 0-1962.0724
840: , p5_a1 NUMBER := 0-1962.0724
841: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a4 DATE := fnd_api.g_miss_date
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
846: , p5_a7 NUMBER := 0-1962.0724
847: , p5_a8 NUMBER := 0-1962.0724
840: , p5_a1 NUMBER := 0-1962.0724
841: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a4 DATE := fnd_api.g_miss_date
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
846: , p5_a7 NUMBER := 0-1962.0724
847: , p5_a8 NUMBER := 0-1962.0724
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
841: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
842: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
843: , p5_a4 DATE := fnd_api.g_miss_date
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
846: , p5_a7 NUMBER := 0-1962.0724
847: , p5_a8 NUMBER := 0-1962.0724
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
844: , p5_a5 DATE := fnd_api.g_miss_date
845: , p5_a6 DATE := fnd_api.g_miss_date
846: , p5_a7 NUMBER := 0-1962.0724
847: , p5_a8 NUMBER := 0-1962.0724
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
846: , p5_a7 NUMBER := 0-1962.0724
847: , p5_a8 NUMBER := 0-1962.0724
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
847: , p5_a8 NUMBER := 0-1962.0724
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
848: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
849: , p5_a10 NUMBER := 0-1962.0724
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
850: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
851: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
852: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
853: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
854: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
855: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
856: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
857: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
858: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
859: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a28 NUMBER := 0-1962.0724
860: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a28 NUMBER := 0-1962.0724
868: , p5_a29 NUMBER := 0-1962.0724
861: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a28 NUMBER := 0-1962.0724
868: , p5_a29 NUMBER := 0-1962.0724
869: , p5_a30 NUMBER := 0-1962.0724
862: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
863: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
864: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
865: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a28 NUMBER := 0-1962.0724
868: , p5_a29 NUMBER := 0-1962.0724
869: , p5_a30 NUMBER := 0-1962.0724
870: , p5_a31 DATE := fnd_api.g_miss_date
866: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
867: , p5_a28 NUMBER := 0-1962.0724
868: , p5_a29 NUMBER := 0-1962.0724
869: , p5_a30 NUMBER := 0-1962.0724
870: , p5_a31 DATE := fnd_api.g_miss_date
871: , p5_a32 NUMBER := 0-1962.0724
872: , p5_a33 NUMBER := 0-1962.0724
873: , p5_a34 DATE := fnd_api.g_miss_date
874: , p5_a35 NUMBER := 0-1962.0724
869: , p5_a30 NUMBER := 0-1962.0724
870: , p5_a31 DATE := fnd_api.g_miss_date
871: , p5_a32 NUMBER := 0-1962.0724
872: , p5_a33 NUMBER := 0-1962.0724
873: , p5_a34 DATE := fnd_api.g_miss_date
874: , p5_a35 NUMBER := 0-1962.0724
875: , p5_a36 DATE := fnd_api.g_miss_date
876: , p5_a37 NUMBER := 0-1962.0724
877: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
871: , p5_a32 NUMBER := 0-1962.0724
872: , p5_a33 NUMBER := 0-1962.0724
873: , p5_a34 DATE := fnd_api.g_miss_date
874: , p5_a35 NUMBER := 0-1962.0724
875: , p5_a36 DATE := fnd_api.g_miss_date
876: , p5_a37 NUMBER := 0-1962.0724
877: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a40 NUMBER := 0-1962.0724
873: , p5_a34 DATE := fnd_api.g_miss_date
874: , p5_a35 NUMBER := 0-1962.0724
875: , p5_a36 DATE := fnd_api.g_miss_date
876: , p5_a37 NUMBER := 0-1962.0724
877: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a40 NUMBER := 0-1962.0724
880: , p5_a41 DATE := fnd_api.g_miss_date
881: , p5_a42 NUMBER := 0-1962.0724
874: , p5_a35 NUMBER := 0-1962.0724
875: , p5_a36 DATE := fnd_api.g_miss_date
876: , p5_a37 NUMBER := 0-1962.0724
877: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a40 NUMBER := 0-1962.0724
880: , p5_a41 DATE := fnd_api.g_miss_date
881: , p5_a42 NUMBER := 0-1962.0724
882: )
876: , p5_a37 NUMBER := 0-1962.0724
877: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
878: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
879: , p5_a40 NUMBER := 0-1962.0724
880: , p5_a41 DATE := fnd_api.g_miss_date
881: , p5_a42 NUMBER := 0-1962.0724
882: )
883:
884: as
1218: , x_msg_count out nocopy NUMBER
1219: , x_msg_data out nocopy VARCHAR2
1220: , p5_a0 NUMBER := 0-1962.0724
1221: , p5_a1 NUMBER := 0-1962.0724
1222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a4 DATE := fnd_api.g_miss_date
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1219: , x_msg_data out nocopy VARCHAR2
1220: , p5_a0 NUMBER := 0-1962.0724
1221: , p5_a1 NUMBER := 0-1962.0724
1222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a4 DATE := fnd_api.g_miss_date
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1227: , p5_a7 NUMBER := 0-1962.0724
1220: , p5_a0 NUMBER := 0-1962.0724
1221: , p5_a1 NUMBER := 0-1962.0724
1222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a4 DATE := fnd_api.g_miss_date
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1227: , p5_a7 NUMBER := 0-1962.0724
1228: , p5_a8 NUMBER := 0-1962.0724
1221: , p5_a1 NUMBER := 0-1962.0724
1222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a4 DATE := fnd_api.g_miss_date
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1227: , p5_a7 NUMBER := 0-1962.0724
1228: , p5_a8 NUMBER := 0-1962.0724
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a4 DATE := fnd_api.g_miss_date
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1227: , p5_a7 NUMBER := 0-1962.0724
1228: , p5_a8 NUMBER := 0-1962.0724
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1225: , p5_a5 DATE := fnd_api.g_miss_date
1226: , p5_a6 DATE := fnd_api.g_miss_date
1227: , p5_a7 NUMBER := 0-1962.0724
1228: , p5_a8 NUMBER := 0-1962.0724
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a7 NUMBER := 0-1962.0724
1228: , p5_a8 NUMBER := 0-1962.0724
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a8 NUMBER := 0-1962.0724
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1229: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1230: , p5_a10 NUMBER := 0-1962.0724
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1231: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1232: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1233: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1234: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1235: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1236: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1237: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1238: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1239: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1240: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a28 NUMBER := 0-1962.0724
1241: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a28 NUMBER := 0-1962.0724
1249: , p5_a29 NUMBER := 0-1962.0724
1242: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a28 NUMBER := 0-1962.0724
1249: , p5_a29 NUMBER := 0-1962.0724
1250: , p5_a30 NUMBER := 0-1962.0724
1243: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1244: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1245: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1246: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a28 NUMBER := 0-1962.0724
1249: , p5_a29 NUMBER := 0-1962.0724
1250: , p5_a30 NUMBER := 0-1962.0724
1251: , p5_a31 DATE := fnd_api.g_miss_date
1247: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p5_a28 NUMBER := 0-1962.0724
1249: , p5_a29 NUMBER := 0-1962.0724
1250: , p5_a30 NUMBER := 0-1962.0724
1251: , p5_a31 DATE := fnd_api.g_miss_date
1252: , p5_a32 NUMBER := 0-1962.0724
1253: , p5_a33 NUMBER := 0-1962.0724
1254: , p5_a34 DATE := fnd_api.g_miss_date
1255: , p5_a35 NUMBER := 0-1962.0724
1250: , p5_a30 NUMBER := 0-1962.0724
1251: , p5_a31 DATE := fnd_api.g_miss_date
1252: , p5_a32 NUMBER := 0-1962.0724
1253: , p5_a33 NUMBER := 0-1962.0724
1254: , p5_a34 DATE := fnd_api.g_miss_date
1255: , p5_a35 NUMBER := 0-1962.0724
1256: , p5_a36 DATE := fnd_api.g_miss_date
1257: , p5_a37 NUMBER := 0-1962.0724
1258: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1252: , p5_a32 NUMBER := 0-1962.0724
1253: , p5_a33 NUMBER := 0-1962.0724
1254: , p5_a34 DATE := fnd_api.g_miss_date
1255: , p5_a35 NUMBER := 0-1962.0724
1256: , p5_a36 DATE := fnd_api.g_miss_date
1257: , p5_a37 NUMBER := 0-1962.0724
1258: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a40 NUMBER := 0-1962.0724
1254: , p5_a34 DATE := fnd_api.g_miss_date
1255: , p5_a35 NUMBER := 0-1962.0724
1256: , p5_a36 DATE := fnd_api.g_miss_date
1257: , p5_a37 NUMBER := 0-1962.0724
1258: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a40 NUMBER := 0-1962.0724
1261: , p5_a41 DATE := fnd_api.g_miss_date
1262: , p5_a42 NUMBER := 0-1962.0724
1255: , p5_a35 NUMBER := 0-1962.0724
1256: , p5_a36 DATE := fnd_api.g_miss_date
1257: , p5_a37 NUMBER := 0-1962.0724
1258: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a40 NUMBER := 0-1962.0724
1261: , p5_a41 DATE := fnd_api.g_miss_date
1262: , p5_a42 NUMBER := 0-1962.0724
1263: )
1257: , p5_a37 NUMBER := 0-1962.0724
1258: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1259: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a40 NUMBER := 0-1962.0724
1261: , p5_a41 DATE := fnd_api.g_miss_date
1262: , p5_a42 NUMBER := 0-1962.0724
1263: )
1264:
1265: as
1504: , p6_a41 out nocopy DATE
1505: , p6_a42 out nocopy NUMBER
1506: , p5_a0 NUMBER := 0-1962.0724
1507: , p5_a1 NUMBER := 0-1962.0724
1508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1510: , p5_a4 DATE := fnd_api.g_miss_date
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1505: , p6_a42 out nocopy NUMBER
1506: , p5_a0 NUMBER := 0-1962.0724
1507: , p5_a1 NUMBER := 0-1962.0724
1508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1510: , p5_a4 DATE := fnd_api.g_miss_date
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1513: , p5_a7 NUMBER := 0-1962.0724
1506: , p5_a0 NUMBER := 0-1962.0724
1507: , p5_a1 NUMBER := 0-1962.0724
1508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1510: , p5_a4 DATE := fnd_api.g_miss_date
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1513: , p5_a7 NUMBER := 0-1962.0724
1514: , p5_a8 NUMBER := 0-1962.0724
1507: , p5_a1 NUMBER := 0-1962.0724
1508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1510: , p5_a4 DATE := fnd_api.g_miss_date
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1513: , p5_a7 NUMBER := 0-1962.0724
1514: , p5_a8 NUMBER := 0-1962.0724
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1508: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1509: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1510: , p5_a4 DATE := fnd_api.g_miss_date
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1513: , p5_a7 NUMBER := 0-1962.0724
1514: , p5_a8 NUMBER := 0-1962.0724
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1511: , p5_a5 DATE := fnd_api.g_miss_date
1512: , p5_a6 DATE := fnd_api.g_miss_date
1513: , p5_a7 NUMBER := 0-1962.0724
1514: , p5_a8 NUMBER := 0-1962.0724
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1513: , p5_a7 NUMBER := 0-1962.0724
1514: , p5_a8 NUMBER := 0-1962.0724
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1514: , p5_a8 NUMBER := 0-1962.0724
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1515: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1516: , p5_a10 NUMBER := 0-1962.0724
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1517: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1518: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1519: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1520: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1521: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1522: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1523: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1524: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1525: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1526: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1534: , p5_a28 NUMBER := 0-1962.0724
1527: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1534: , p5_a28 NUMBER := 0-1962.0724
1535: , p5_a29 NUMBER := 0-1962.0724
1528: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1534: , p5_a28 NUMBER := 0-1962.0724
1535: , p5_a29 NUMBER := 0-1962.0724
1536: , p5_a30 NUMBER := 0-1962.0724
1529: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1530: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1531: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1532: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1534: , p5_a28 NUMBER := 0-1962.0724
1535: , p5_a29 NUMBER := 0-1962.0724
1536: , p5_a30 NUMBER := 0-1962.0724
1537: , p5_a31 DATE := fnd_api.g_miss_date
1533: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1534: , p5_a28 NUMBER := 0-1962.0724
1535: , p5_a29 NUMBER := 0-1962.0724
1536: , p5_a30 NUMBER := 0-1962.0724
1537: , p5_a31 DATE := fnd_api.g_miss_date
1538: , p5_a32 NUMBER := 0-1962.0724
1539: , p5_a33 NUMBER := 0-1962.0724
1540: , p5_a34 DATE := fnd_api.g_miss_date
1541: , p5_a35 NUMBER := 0-1962.0724
1536: , p5_a30 NUMBER := 0-1962.0724
1537: , p5_a31 DATE := fnd_api.g_miss_date
1538: , p5_a32 NUMBER := 0-1962.0724
1539: , p5_a33 NUMBER := 0-1962.0724
1540: , p5_a34 DATE := fnd_api.g_miss_date
1541: , p5_a35 NUMBER := 0-1962.0724
1542: , p5_a36 DATE := fnd_api.g_miss_date
1543: , p5_a37 NUMBER := 0-1962.0724
1544: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1538: , p5_a32 NUMBER := 0-1962.0724
1539: , p5_a33 NUMBER := 0-1962.0724
1540: , p5_a34 DATE := fnd_api.g_miss_date
1541: , p5_a35 NUMBER := 0-1962.0724
1542: , p5_a36 DATE := fnd_api.g_miss_date
1543: , p5_a37 NUMBER := 0-1962.0724
1544: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1545: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1546: , p5_a40 NUMBER := 0-1962.0724
1540: , p5_a34 DATE := fnd_api.g_miss_date
1541: , p5_a35 NUMBER := 0-1962.0724
1542: , p5_a36 DATE := fnd_api.g_miss_date
1543: , p5_a37 NUMBER := 0-1962.0724
1544: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1545: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1546: , p5_a40 NUMBER := 0-1962.0724
1547: , p5_a41 DATE := fnd_api.g_miss_date
1548: , p5_a42 NUMBER := 0-1962.0724
1541: , p5_a35 NUMBER := 0-1962.0724
1542: , p5_a36 DATE := fnd_api.g_miss_date
1543: , p5_a37 NUMBER := 0-1962.0724
1544: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1545: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1546: , p5_a40 NUMBER := 0-1962.0724
1547: , p5_a41 DATE := fnd_api.g_miss_date
1548: , p5_a42 NUMBER := 0-1962.0724
1549: )
1543: , p5_a37 NUMBER := 0-1962.0724
1544: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1545: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1546: , p5_a40 NUMBER := 0-1962.0724
1547: , p5_a41 DATE := fnd_api.g_miss_date
1548: , p5_a42 NUMBER := 0-1962.0724
1549: )
1550:
1551: as
1885: , x_msg_count out nocopy NUMBER
1886: , x_msg_data out nocopy VARCHAR2
1887: , p5_a0 NUMBER := 0-1962.0724
1888: , p5_a1 NUMBER := 0-1962.0724
1889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1890: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1891: , p5_a4 DATE := fnd_api.g_miss_date
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1886: , x_msg_data out nocopy VARCHAR2
1887: , p5_a0 NUMBER := 0-1962.0724
1888: , p5_a1 NUMBER := 0-1962.0724
1889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1890: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1891: , p5_a4 DATE := fnd_api.g_miss_date
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1894: , p5_a7 NUMBER := 0-1962.0724
1887: , p5_a0 NUMBER := 0-1962.0724
1888: , p5_a1 NUMBER := 0-1962.0724
1889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1890: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1891: , p5_a4 DATE := fnd_api.g_miss_date
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1894: , p5_a7 NUMBER := 0-1962.0724
1895: , p5_a8 NUMBER := 0-1962.0724
1888: , p5_a1 NUMBER := 0-1962.0724
1889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1890: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1891: , p5_a4 DATE := fnd_api.g_miss_date
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1894: , p5_a7 NUMBER := 0-1962.0724
1895: , p5_a8 NUMBER := 0-1962.0724
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1890: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1891: , p5_a4 DATE := fnd_api.g_miss_date
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1894: , p5_a7 NUMBER := 0-1962.0724
1895: , p5_a8 NUMBER := 0-1962.0724
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1892: , p5_a5 DATE := fnd_api.g_miss_date
1893: , p5_a6 DATE := fnd_api.g_miss_date
1894: , p5_a7 NUMBER := 0-1962.0724
1895: , p5_a8 NUMBER := 0-1962.0724
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1894: , p5_a7 NUMBER := 0-1962.0724
1895: , p5_a8 NUMBER := 0-1962.0724
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1895: , p5_a8 NUMBER := 0-1962.0724
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1897: , p5_a10 NUMBER := 0-1962.0724
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1915: , p5_a28 NUMBER := 0-1962.0724
1908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1915: , p5_a28 NUMBER := 0-1962.0724
1916: , p5_a29 NUMBER := 0-1962.0724
1909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1915: , p5_a28 NUMBER := 0-1962.0724
1916: , p5_a29 NUMBER := 0-1962.0724
1917: , p5_a30 NUMBER := 0-1962.0724
1910: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1911: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1912: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1913: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1915: , p5_a28 NUMBER := 0-1962.0724
1916: , p5_a29 NUMBER := 0-1962.0724
1917: , p5_a30 NUMBER := 0-1962.0724
1918: , p5_a31 DATE := fnd_api.g_miss_date
1914: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1915: , p5_a28 NUMBER := 0-1962.0724
1916: , p5_a29 NUMBER := 0-1962.0724
1917: , p5_a30 NUMBER := 0-1962.0724
1918: , p5_a31 DATE := fnd_api.g_miss_date
1919: , p5_a32 NUMBER := 0-1962.0724
1920: , p5_a33 NUMBER := 0-1962.0724
1921: , p5_a34 DATE := fnd_api.g_miss_date
1922: , p5_a35 NUMBER := 0-1962.0724
1917: , p5_a30 NUMBER := 0-1962.0724
1918: , p5_a31 DATE := fnd_api.g_miss_date
1919: , p5_a32 NUMBER := 0-1962.0724
1920: , p5_a33 NUMBER := 0-1962.0724
1921: , p5_a34 DATE := fnd_api.g_miss_date
1922: , p5_a35 NUMBER := 0-1962.0724
1923: , p5_a36 DATE := fnd_api.g_miss_date
1924: , p5_a37 NUMBER := 0-1962.0724
1925: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1919: , p5_a32 NUMBER := 0-1962.0724
1920: , p5_a33 NUMBER := 0-1962.0724
1921: , p5_a34 DATE := fnd_api.g_miss_date
1922: , p5_a35 NUMBER := 0-1962.0724
1923: , p5_a36 DATE := fnd_api.g_miss_date
1924: , p5_a37 NUMBER := 0-1962.0724
1925: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a40 NUMBER := 0-1962.0724
1921: , p5_a34 DATE := fnd_api.g_miss_date
1922: , p5_a35 NUMBER := 0-1962.0724
1923: , p5_a36 DATE := fnd_api.g_miss_date
1924: , p5_a37 NUMBER := 0-1962.0724
1925: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a40 NUMBER := 0-1962.0724
1928: , p5_a41 DATE := fnd_api.g_miss_date
1929: , p5_a42 NUMBER := 0-1962.0724
1922: , p5_a35 NUMBER := 0-1962.0724
1923: , p5_a36 DATE := fnd_api.g_miss_date
1924: , p5_a37 NUMBER := 0-1962.0724
1925: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a40 NUMBER := 0-1962.0724
1928: , p5_a41 DATE := fnd_api.g_miss_date
1929: , p5_a42 NUMBER := 0-1962.0724
1930: )
1924: , p5_a37 NUMBER := 0-1962.0724
1925: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a40 NUMBER := 0-1962.0724
1928: , p5_a41 DATE := fnd_api.g_miss_date
1929: , p5_a42 NUMBER := 0-1962.0724
1930: )
1931:
1932: as
2128: , x_msg_count out nocopy NUMBER
2129: , x_msg_data out nocopy VARCHAR2
2130: , p5_a0 NUMBER := 0-1962.0724
2131: , p5_a1 NUMBER := 0-1962.0724
2132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2134: , p5_a4 DATE := fnd_api.g_miss_date
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2129: , x_msg_data out nocopy VARCHAR2
2130: , p5_a0 NUMBER := 0-1962.0724
2131: , p5_a1 NUMBER := 0-1962.0724
2132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2134: , p5_a4 DATE := fnd_api.g_miss_date
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2137: , p5_a7 NUMBER := 0-1962.0724
2130: , p5_a0 NUMBER := 0-1962.0724
2131: , p5_a1 NUMBER := 0-1962.0724
2132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2134: , p5_a4 DATE := fnd_api.g_miss_date
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2137: , p5_a7 NUMBER := 0-1962.0724
2138: , p5_a8 NUMBER := 0-1962.0724
2131: , p5_a1 NUMBER := 0-1962.0724
2132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2134: , p5_a4 DATE := fnd_api.g_miss_date
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2137: , p5_a7 NUMBER := 0-1962.0724
2138: , p5_a8 NUMBER := 0-1962.0724
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2132: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2133: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2134: , p5_a4 DATE := fnd_api.g_miss_date
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2137: , p5_a7 NUMBER := 0-1962.0724
2138: , p5_a8 NUMBER := 0-1962.0724
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2135: , p5_a5 DATE := fnd_api.g_miss_date
2136: , p5_a6 DATE := fnd_api.g_miss_date
2137: , p5_a7 NUMBER := 0-1962.0724
2138: , p5_a8 NUMBER := 0-1962.0724
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2137: , p5_a7 NUMBER := 0-1962.0724
2138: , p5_a8 NUMBER := 0-1962.0724
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2138: , p5_a8 NUMBER := 0-1962.0724
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2139: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2140: , p5_a10 NUMBER := 0-1962.0724
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2141: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2142: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2143: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2144: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2145: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2146: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2147: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2148: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2149: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2150: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2158: , p5_a28 NUMBER := 0-1962.0724
2151: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2158: , p5_a28 NUMBER := 0-1962.0724
2159: , p5_a29 NUMBER := 0-1962.0724
2152: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2158: , p5_a28 NUMBER := 0-1962.0724
2159: , p5_a29 NUMBER := 0-1962.0724
2160: , p5_a30 NUMBER := 0-1962.0724
2153: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2154: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2155: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2156: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2158: , p5_a28 NUMBER := 0-1962.0724
2159: , p5_a29 NUMBER := 0-1962.0724
2160: , p5_a30 NUMBER := 0-1962.0724
2161: , p5_a31 DATE := fnd_api.g_miss_date
2157: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2158: , p5_a28 NUMBER := 0-1962.0724
2159: , p5_a29 NUMBER := 0-1962.0724
2160: , p5_a30 NUMBER := 0-1962.0724
2161: , p5_a31 DATE := fnd_api.g_miss_date
2162: , p5_a32 NUMBER := 0-1962.0724
2163: , p5_a33 NUMBER := 0-1962.0724
2164: , p5_a34 DATE := fnd_api.g_miss_date
2165: , p5_a35 NUMBER := 0-1962.0724
2160: , p5_a30 NUMBER := 0-1962.0724
2161: , p5_a31 DATE := fnd_api.g_miss_date
2162: , p5_a32 NUMBER := 0-1962.0724
2163: , p5_a33 NUMBER := 0-1962.0724
2164: , p5_a34 DATE := fnd_api.g_miss_date
2165: , p5_a35 NUMBER := 0-1962.0724
2166: , p5_a36 DATE := fnd_api.g_miss_date
2167: , p5_a37 NUMBER := 0-1962.0724
2168: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2162: , p5_a32 NUMBER := 0-1962.0724
2163: , p5_a33 NUMBER := 0-1962.0724
2164: , p5_a34 DATE := fnd_api.g_miss_date
2165: , p5_a35 NUMBER := 0-1962.0724
2166: , p5_a36 DATE := fnd_api.g_miss_date
2167: , p5_a37 NUMBER := 0-1962.0724
2168: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2169: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2170: , p5_a40 NUMBER := 0-1962.0724
2164: , p5_a34 DATE := fnd_api.g_miss_date
2165: , p5_a35 NUMBER := 0-1962.0724
2166: , p5_a36 DATE := fnd_api.g_miss_date
2167: , p5_a37 NUMBER := 0-1962.0724
2168: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2169: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2170: , p5_a40 NUMBER := 0-1962.0724
2171: , p5_a41 DATE := fnd_api.g_miss_date
2172: , p5_a42 NUMBER := 0-1962.0724
2165: , p5_a35 NUMBER := 0-1962.0724
2166: , p5_a36 DATE := fnd_api.g_miss_date
2167: , p5_a37 NUMBER := 0-1962.0724
2168: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2169: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2170: , p5_a40 NUMBER := 0-1962.0724
2171: , p5_a41 DATE := fnd_api.g_miss_date
2172: , p5_a42 NUMBER := 0-1962.0724
2173: )
2167: , p5_a37 NUMBER := 0-1962.0724
2168: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2169: , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2170: , p5_a40 NUMBER := 0-1962.0724
2171: , p5_a41 DATE := fnd_api.g_miss_date
2172: , p5_a42 NUMBER := 0-1962.0724
2173: )
2174:
2175: as