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;
762: , p6_a36 out nocopy DATE
763: , p6_a37 out nocopy NUMBER
764: , p5_a0 NUMBER := 0-1962.0724
765: , p5_a1 NUMBER := 0-1962.0724
766: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
763: , p6_a37 out nocopy NUMBER
764: , p5_a0 NUMBER := 0-1962.0724
765: , p5_a1 NUMBER := 0-1962.0724
766: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a1 NUMBER := 0-1962.0724
766: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
766: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
774: , p5_a10 NUMBER := 0-1962.0724
767: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
774: , p5_a10 NUMBER := 0-1962.0724
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a4 NUMBER := 0-1962.0724
769: , p5_a5 DATE := fnd_api.g_miss_date
770: , p5_a6 DATE := fnd_api.g_miss_date
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
774: , p5_a10 NUMBER := 0-1962.0724
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
774: , p5_a10 NUMBER := 0-1962.0724
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a9 NUMBER := 0-1962.0724
774: , p5_a10 NUMBER := 0-1962.0724
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a10 NUMBER := 0-1962.0724
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a13 NUMBER := 0-1962.0724
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
790: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
798: , p5_a34 DATE := fnd_api.g_miss_date
791: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
798: , p5_a34 DATE := fnd_api.g_miss_date
799: , p5_a35 NUMBER := 0-1962.0724
792: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
798: , p5_a34 DATE := fnd_api.g_miss_date
799: , p5_a35 NUMBER := 0-1962.0724
800: , p5_a36 DATE := fnd_api.g_miss_date
794: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
795: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
798: , p5_a34 DATE := fnd_api.g_miss_date
799: , p5_a35 NUMBER := 0-1962.0724
800: , p5_a36 DATE := fnd_api.g_miss_date
801: , p5_a37 NUMBER := 0-1962.0724
802: )
796: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a33 NUMBER := 0-1962.0724
798: , p5_a34 DATE := fnd_api.g_miss_date
799: , p5_a35 NUMBER := 0-1962.0724
800: , p5_a36 DATE := fnd_api.g_miss_date
801: , p5_a37 NUMBER := 0-1962.0724
802: )
803:
804: as
1108: , x_msg_count out nocopy NUMBER
1109: , x_msg_data out nocopy VARCHAR2
1110: , p5_a0 NUMBER := 0-1962.0724
1111: , p5_a1 NUMBER := 0-1962.0724
1112: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1109: , x_msg_data out nocopy VARCHAR2
1110: , p5_a0 NUMBER := 0-1962.0724
1111: , p5_a1 NUMBER := 0-1962.0724
1112: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a1 NUMBER := 0-1962.0724
1112: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1112: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1120: , p5_a10 NUMBER := 0-1962.0724
1113: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1120: , p5_a10 NUMBER := 0-1962.0724
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a4 NUMBER := 0-1962.0724
1115: , p5_a5 DATE := fnd_api.g_miss_date
1116: , p5_a6 DATE := fnd_api.g_miss_date
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1120: , p5_a10 NUMBER := 0-1962.0724
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1120: , p5_a10 NUMBER := 0-1962.0724
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a9 NUMBER := 0-1962.0724
1120: , p5_a10 NUMBER := 0-1962.0724
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a10 NUMBER := 0-1962.0724
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a13 NUMBER := 0-1962.0724
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1136: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1144: , p5_a34 DATE := fnd_api.g_miss_date
1137: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1144: , p5_a34 DATE := fnd_api.g_miss_date
1145: , p5_a35 NUMBER := 0-1962.0724
1138: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1144: , p5_a34 DATE := fnd_api.g_miss_date
1145: , p5_a35 NUMBER := 0-1962.0724
1146: , p5_a36 DATE := fnd_api.g_miss_date
1140: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1144: , p5_a34 DATE := fnd_api.g_miss_date
1145: , p5_a35 NUMBER := 0-1962.0724
1146: , p5_a36 DATE := fnd_api.g_miss_date
1147: , p5_a37 NUMBER := 0-1962.0724
1148: )
1142: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a33 NUMBER := 0-1962.0724
1144: , p5_a34 DATE := fnd_api.g_miss_date
1145: , p5_a35 NUMBER := 0-1962.0724
1146: , p5_a36 DATE := fnd_api.g_miss_date
1147: , p5_a37 NUMBER := 0-1962.0724
1148: )
1149:
1150: as
1369: , p6_a36 out nocopy DATE
1370: , p6_a37 out nocopy NUMBER
1371: , p5_a0 NUMBER := 0-1962.0724
1372: , p5_a1 NUMBER := 0-1962.0724
1373: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1370: , p6_a37 out nocopy NUMBER
1371: , p5_a0 NUMBER := 0-1962.0724
1372: , p5_a1 NUMBER := 0-1962.0724
1373: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a1 NUMBER := 0-1962.0724
1373: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1373: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1381: , p5_a10 NUMBER := 0-1962.0724
1374: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1381: , p5_a10 NUMBER := 0-1962.0724
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a4 NUMBER := 0-1962.0724
1376: , p5_a5 DATE := fnd_api.g_miss_date
1377: , p5_a6 DATE := fnd_api.g_miss_date
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1381: , p5_a10 NUMBER := 0-1962.0724
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1381: , p5_a10 NUMBER := 0-1962.0724
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a9 NUMBER := 0-1962.0724
1381: , p5_a10 NUMBER := 0-1962.0724
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a10 NUMBER := 0-1962.0724
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a13 NUMBER := 0-1962.0724
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1397: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1405: , p5_a34 DATE := fnd_api.g_miss_date
1398: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1405: , p5_a34 DATE := fnd_api.g_miss_date
1406: , p5_a35 NUMBER := 0-1962.0724
1399: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1405: , p5_a34 DATE := fnd_api.g_miss_date
1406: , p5_a35 NUMBER := 0-1962.0724
1407: , p5_a36 DATE := fnd_api.g_miss_date
1401: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1405: , p5_a34 DATE := fnd_api.g_miss_date
1406: , p5_a35 NUMBER := 0-1962.0724
1407: , p5_a36 DATE := fnd_api.g_miss_date
1408: , p5_a37 NUMBER := 0-1962.0724
1409: )
1403: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a33 NUMBER := 0-1962.0724
1405: , p5_a34 DATE := fnd_api.g_miss_date
1406: , p5_a35 NUMBER := 0-1962.0724
1407: , p5_a36 DATE := fnd_api.g_miss_date
1408: , p5_a37 NUMBER := 0-1962.0724
1409: )
1410:
1411: as
1715: , x_msg_count out nocopy NUMBER
1716: , x_msg_data out nocopy VARCHAR2
1717: , p5_a0 NUMBER := 0-1962.0724
1718: , p5_a1 NUMBER := 0-1962.0724
1719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1716: , x_msg_data out nocopy VARCHAR2
1717: , p5_a0 NUMBER := 0-1962.0724
1718: , p5_a1 NUMBER := 0-1962.0724
1719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a1 NUMBER := 0-1962.0724
1719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1719: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1727: , p5_a10 NUMBER := 0-1962.0724
1720: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1727: , p5_a10 NUMBER := 0-1962.0724
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a4 NUMBER := 0-1962.0724
1722: , p5_a5 DATE := fnd_api.g_miss_date
1723: , p5_a6 DATE := fnd_api.g_miss_date
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1727: , p5_a10 NUMBER := 0-1962.0724
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1727: , p5_a10 NUMBER := 0-1962.0724
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a9 NUMBER := 0-1962.0724
1727: , p5_a10 NUMBER := 0-1962.0724
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1727: , p5_a10 NUMBER := 0-1962.0724
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1728: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a13 NUMBER := 0-1962.0724
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1731: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1743: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1751: , p5_a34 DATE := fnd_api.g_miss_date
1744: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1751: , p5_a34 DATE := fnd_api.g_miss_date
1752: , p5_a35 NUMBER := 0-1962.0724
1745: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1751: , p5_a34 DATE := fnd_api.g_miss_date
1752: , p5_a35 NUMBER := 0-1962.0724
1753: , p5_a36 DATE := fnd_api.g_miss_date
1747: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1748: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1751: , p5_a34 DATE := fnd_api.g_miss_date
1752: , p5_a35 NUMBER := 0-1962.0724
1753: , p5_a36 DATE := fnd_api.g_miss_date
1754: , p5_a37 NUMBER := 0-1962.0724
1755: )
1749: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1750: , p5_a33 NUMBER := 0-1962.0724
1751: , p5_a34 DATE := fnd_api.g_miss_date
1752: , p5_a35 NUMBER := 0-1962.0724
1753: , p5_a36 DATE := fnd_api.g_miss_date
1754: , p5_a37 NUMBER := 0-1962.0724
1755: )
1756:
1757: as
1938: , x_msg_count out nocopy NUMBER
1939: , x_msg_data out nocopy VARCHAR2
1940: , p5_a0 NUMBER := 0-1962.0724
1941: , p5_a1 NUMBER := 0-1962.0724
1942: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1939: , x_msg_data out nocopy VARCHAR2
1940: , p5_a0 NUMBER := 0-1962.0724
1941: , p5_a1 NUMBER := 0-1962.0724
1942: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a1 NUMBER := 0-1962.0724
1942: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1942: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1950: , p5_a10 NUMBER := 0-1962.0724
1943: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1950: , p5_a10 NUMBER := 0-1962.0724
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a4 NUMBER := 0-1962.0724
1945: , p5_a5 DATE := fnd_api.g_miss_date
1946: , p5_a6 DATE := fnd_api.g_miss_date
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1950: , p5_a10 NUMBER := 0-1962.0724
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1950: , p5_a10 NUMBER := 0-1962.0724
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a9 NUMBER := 0-1962.0724
1950: , p5_a10 NUMBER := 0-1962.0724
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a10 NUMBER := 0-1962.0724
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a13 NUMBER := 0-1962.0724
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1954: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1966: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1974: , p5_a34 DATE := fnd_api.g_miss_date
1967: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1974: , p5_a34 DATE := fnd_api.g_miss_date
1975: , p5_a35 NUMBER := 0-1962.0724
1968: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1974: , p5_a34 DATE := fnd_api.g_miss_date
1975: , p5_a35 NUMBER := 0-1962.0724
1976: , p5_a36 DATE := fnd_api.g_miss_date
1970: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1971: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1974: , p5_a34 DATE := fnd_api.g_miss_date
1975: , p5_a35 NUMBER := 0-1962.0724
1976: , p5_a36 DATE := fnd_api.g_miss_date
1977: , p5_a37 NUMBER := 0-1962.0724
1978: )
1972: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1973: , p5_a33 NUMBER := 0-1962.0724
1974: , p5_a34 DATE := fnd_api.g_miss_date
1975: , p5_a35 NUMBER := 0-1962.0724
1976: , p5_a36 DATE := fnd_api.g_miss_date
1977: , p5_a37 NUMBER := 0-1962.0724
1978: )
1979:
1980: as