5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
759: , p6_a36 out nocopy DATE
760: , p6_a37 out nocopy NUMBER
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
760: , p6_a37 out nocopy NUMBER
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
761: , p5_a0 NUMBER := 0-1962.0724
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
762: , p5_a1 NUMBER := 0-1962.0724
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
763: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
764: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
765: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a12 NUMBER := 0-1962.0724
766: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
767: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 NUMBER := 0-1962.0724
768: , p5_a7 DATE := fnd_api.g_miss_date
769: , p5_a8 DATE := fnd_api.g_miss_date
770: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 NUMBER := 0-1962.0724
776: , p5_a15 NUMBER := 0-1962.0724
773: , p5_a12 NUMBER := 0-1962.0724
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 NUMBER := 0-1962.0724
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a13 NUMBER := 0-1962.0724
775: , p5_a14 NUMBER := 0-1962.0724
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a14 NUMBER := 0-1962.0724
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a15 NUMBER := 0-1962.0724
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a16 DATE := fnd_api.g_miss_date
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
787: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
795: , p5_a34 DATE := fnd_api.g_miss_date
788: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
795: , p5_a34 DATE := fnd_api.g_miss_date
796: , p5_a35 NUMBER := 0-1962.0724
789: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
795: , p5_a34 DATE := fnd_api.g_miss_date
796: , p5_a35 NUMBER := 0-1962.0724
797: , p5_a36 DATE := fnd_api.g_miss_date
791: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
795: , p5_a34 DATE := fnd_api.g_miss_date
796: , p5_a35 NUMBER := 0-1962.0724
797: , p5_a36 DATE := fnd_api.g_miss_date
798: , p5_a37 NUMBER := 0-1962.0724
799: )
793: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a33 NUMBER := 0-1962.0724
795: , p5_a34 DATE := fnd_api.g_miss_date
796: , p5_a35 NUMBER := 0-1962.0724
797: , p5_a36 DATE := fnd_api.g_miss_date
798: , p5_a37 NUMBER := 0-1962.0724
799: )
800:
801: as
1105: , x_msg_count out nocopy NUMBER
1106: , x_msg_data out nocopy VARCHAR2
1107: , p5_a0 NUMBER := 0-1962.0724
1108: , p5_a1 NUMBER := 0-1962.0724
1109: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1106: , x_msg_data out nocopy VARCHAR2
1107: , p5_a0 NUMBER := 0-1962.0724
1108: , p5_a1 NUMBER := 0-1962.0724
1109: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1107: , p5_a0 NUMBER := 0-1962.0724
1108: , p5_a1 NUMBER := 0-1962.0724
1109: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1108: , p5_a1 NUMBER := 0-1962.0724
1109: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a12 NUMBER := 0-1962.0724
1112: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a12 NUMBER := 0-1962.0724
1120: , p5_a13 NUMBER := 0-1962.0724
1113: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a12 NUMBER := 0-1962.0724
1120: , p5_a13 NUMBER := 0-1962.0724
1121: , p5_a14 NUMBER := 0-1962.0724
1114: , p5_a7 DATE := fnd_api.g_miss_date
1115: , p5_a8 DATE := fnd_api.g_miss_date
1116: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a12 NUMBER := 0-1962.0724
1120: , p5_a13 NUMBER := 0-1962.0724
1121: , p5_a14 NUMBER := 0-1962.0724
1122: , p5_a15 NUMBER := 0-1962.0724
1119: , p5_a12 NUMBER := 0-1962.0724
1120: , p5_a13 NUMBER := 0-1962.0724
1121: , p5_a14 NUMBER := 0-1962.0724
1122: , p5_a15 NUMBER := 0-1962.0724
1123: , p5_a16 DATE := fnd_api.g_miss_date
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a13 NUMBER := 0-1962.0724
1121: , p5_a14 NUMBER := 0-1962.0724
1122: , p5_a15 NUMBER := 0-1962.0724
1123: , p5_a16 DATE := fnd_api.g_miss_date
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a14 NUMBER := 0-1962.0724
1122: , p5_a15 NUMBER := 0-1962.0724
1123: , p5_a16 DATE := fnd_api.g_miss_date
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1122: , p5_a15 NUMBER := 0-1962.0724
1123: , p5_a16 DATE := fnd_api.g_miss_date
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1123: , p5_a16 DATE := fnd_api.g_miss_date
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1124: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1125: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1126: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1127: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1128: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1129: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1130: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1131: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1132: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1133: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1141: , p5_a34 DATE := fnd_api.g_miss_date
1134: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1141: , p5_a34 DATE := fnd_api.g_miss_date
1142: , p5_a35 NUMBER := 0-1962.0724
1135: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1136: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1141: , p5_a34 DATE := fnd_api.g_miss_date
1142: , p5_a35 NUMBER := 0-1962.0724
1143: , p5_a36 DATE := fnd_api.g_miss_date
1137: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1141: , p5_a34 DATE := fnd_api.g_miss_date
1142: , p5_a35 NUMBER := 0-1962.0724
1143: , p5_a36 DATE := fnd_api.g_miss_date
1144: , p5_a37 NUMBER := 0-1962.0724
1145: )
1139: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a33 NUMBER := 0-1962.0724
1141: , p5_a34 DATE := fnd_api.g_miss_date
1142: , p5_a35 NUMBER := 0-1962.0724
1143: , p5_a36 DATE := fnd_api.g_miss_date
1144: , p5_a37 NUMBER := 0-1962.0724
1145: )
1146:
1147: as
1366: , p6_a36 out nocopy DATE
1367: , p6_a37 out nocopy NUMBER
1368: , p5_a0 NUMBER := 0-1962.0724
1369: , p5_a1 NUMBER := 0-1962.0724
1370: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1367: , p6_a37 out nocopy NUMBER
1368: , p5_a0 NUMBER := 0-1962.0724
1369: , p5_a1 NUMBER := 0-1962.0724
1370: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1368: , p5_a0 NUMBER := 0-1962.0724
1369: , p5_a1 NUMBER := 0-1962.0724
1370: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1369: , p5_a1 NUMBER := 0-1962.0724
1370: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1370: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1371: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1372: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a12 NUMBER := 0-1962.0724
1373: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a12 NUMBER := 0-1962.0724
1381: , p5_a13 NUMBER := 0-1962.0724
1374: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a12 NUMBER := 0-1962.0724
1381: , p5_a13 NUMBER := 0-1962.0724
1382: , p5_a14 NUMBER := 0-1962.0724
1375: , p5_a7 DATE := fnd_api.g_miss_date
1376: , p5_a8 DATE := fnd_api.g_miss_date
1377: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a12 NUMBER := 0-1962.0724
1381: , p5_a13 NUMBER := 0-1962.0724
1382: , p5_a14 NUMBER := 0-1962.0724
1383: , p5_a15 NUMBER := 0-1962.0724
1380: , p5_a12 NUMBER := 0-1962.0724
1381: , p5_a13 NUMBER := 0-1962.0724
1382: , p5_a14 NUMBER := 0-1962.0724
1383: , p5_a15 NUMBER := 0-1962.0724
1384: , p5_a16 DATE := fnd_api.g_miss_date
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a13 NUMBER := 0-1962.0724
1382: , p5_a14 NUMBER := 0-1962.0724
1383: , p5_a15 NUMBER := 0-1962.0724
1384: , p5_a16 DATE := fnd_api.g_miss_date
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a14 NUMBER := 0-1962.0724
1383: , p5_a15 NUMBER := 0-1962.0724
1384: , p5_a16 DATE := fnd_api.g_miss_date
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a15 NUMBER := 0-1962.0724
1384: , p5_a16 DATE := fnd_api.g_miss_date
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a16 DATE := fnd_api.g_miss_date
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1394: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1402: , p5_a34 DATE := fnd_api.g_miss_date
1395: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1402: , p5_a34 DATE := fnd_api.g_miss_date
1403: , p5_a35 NUMBER := 0-1962.0724
1396: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1402: , p5_a34 DATE := fnd_api.g_miss_date
1403: , p5_a35 NUMBER := 0-1962.0724
1404: , p5_a36 DATE := fnd_api.g_miss_date
1398: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1402: , p5_a34 DATE := fnd_api.g_miss_date
1403: , p5_a35 NUMBER := 0-1962.0724
1404: , p5_a36 DATE := fnd_api.g_miss_date
1405: , p5_a37 NUMBER := 0-1962.0724
1406: )
1400: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a33 NUMBER := 0-1962.0724
1402: , p5_a34 DATE := fnd_api.g_miss_date
1403: , p5_a35 NUMBER := 0-1962.0724
1404: , p5_a36 DATE := fnd_api.g_miss_date
1405: , p5_a37 NUMBER := 0-1962.0724
1406: )
1407:
1408: as
1712: , x_msg_count out nocopy NUMBER
1713: , x_msg_data out nocopy VARCHAR2
1714: , p5_a0 NUMBER := 0-1962.0724
1715: , p5_a1 NUMBER := 0-1962.0724
1716: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1713: , x_msg_data out nocopy VARCHAR2
1714: , p5_a0 NUMBER := 0-1962.0724
1715: , p5_a1 NUMBER := 0-1962.0724
1716: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1714: , p5_a0 NUMBER := 0-1962.0724
1715: , p5_a1 NUMBER := 0-1962.0724
1716: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1715: , p5_a1 NUMBER := 0-1962.0724
1716: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1716: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1717: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1718: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a12 NUMBER := 0-1962.0724
1719: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a12 NUMBER := 0-1962.0724
1727: , p5_a13 NUMBER := 0-1962.0724
1720: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a12 NUMBER := 0-1962.0724
1727: , p5_a13 NUMBER := 0-1962.0724
1728: , p5_a14 NUMBER := 0-1962.0724
1721: , p5_a7 DATE := fnd_api.g_miss_date
1722: , p5_a8 DATE := fnd_api.g_miss_date
1723: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1724: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1725: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a12 NUMBER := 0-1962.0724
1727: , p5_a13 NUMBER := 0-1962.0724
1728: , p5_a14 NUMBER := 0-1962.0724
1729: , p5_a15 NUMBER := 0-1962.0724
1726: , p5_a12 NUMBER := 0-1962.0724
1727: , p5_a13 NUMBER := 0-1962.0724
1728: , p5_a14 NUMBER := 0-1962.0724
1729: , p5_a15 NUMBER := 0-1962.0724
1730: , p5_a16 DATE := fnd_api.g_miss_date
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1727: , p5_a13 NUMBER := 0-1962.0724
1728: , p5_a14 NUMBER := 0-1962.0724
1729: , p5_a15 NUMBER := 0-1962.0724
1730: , p5_a16 DATE := fnd_api.g_miss_date
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1728: , p5_a14 NUMBER := 0-1962.0724
1729: , p5_a15 NUMBER := 0-1962.0724
1730: , p5_a16 DATE := fnd_api.g_miss_date
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a15 NUMBER := 0-1962.0724
1730: , p5_a16 DATE := fnd_api.g_miss_date
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1730: , p5_a16 DATE := fnd_api.g_miss_date
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1731: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1732: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1733: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1734: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1735: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1736: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1737: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1738: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1739: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1740: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1748: , p5_a34 DATE := fnd_api.g_miss_date
1741: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1748: , p5_a34 DATE := fnd_api.g_miss_date
1749: , p5_a35 NUMBER := 0-1962.0724
1742: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1743: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1748: , p5_a34 DATE := fnd_api.g_miss_date
1749: , p5_a35 NUMBER := 0-1962.0724
1750: , p5_a36 DATE := fnd_api.g_miss_date
1744: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1745: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1748: , p5_a34 DATE := fnd_api.g_miss_date
1749: , p5_a35 NUMBER := 0-1962.0724
1750: , p5_a36 DATE := fnd_api.g_miss_date
1751: , p5_a37 NUMBER := 0-1962.0724
1752: )
1746: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1747: , p5_a33 NUMBER := 0-1962.0724
1748: , p5_a34 DATE := fnd_api.g_miss_date
1749: , p5_a35 NUMBER := 0-1962.0724
1750: , p5_a36 DATE := fnd_api.g_miss_date
1751: , p5_a37 NUMBER := 0-1962.0724
1752: )
1753:
1754: as
1935: , x_msg_count out nocopy NUMBER
1936: , x_msg_data out nocopy VARCHAR2
1937: , p5_a0 NUMBER := 0-1962.0724
1938: , p5_a1 NUMBER := 0-1962.0724
1939: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1936: , x_msg_data out nocopy VARCHAR2
1937: , p5_a0 NUMBER := 0-1962.0724
1938: , p5_a1 NUMBER := 0-1962.0724
1939: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1937: , p5_a0 NUMBER := 0-1962.0724
1938: , p5_a1 NUMBER := 0-1962.0724
1939: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1938: , p5_a1 NUMBER := 0-1962.0724
1939: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a12 NUMBER := 0-1962.0724
1942: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a12 NUMBER := 0-1962.0724
1950: , p5_a13 NUMBER := 0-1962.0724
1943: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a12 NUMBER := 0-1962.0724
1950: , p5_a13 NUMBER := 0-1962.0724
1951: , p5_a14 NUMBER := 0-1962.0724
1944: , p5_a7 DATE := fnd_api.g_miss_date
1945: , p5_a8 DATE := fnd_api.g_miss_date
1946: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1947: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1948: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1949: , p5_a12 NUMBER := 0-1962.0724
1950: , p5_a13 NUMBER := 0-1962.0724
1951: , p5_a14 NUMBER := 0-1962.0724
1952: , p5_a15 NUMBER := 0-1962.0724
1949: , p5_a12 NUMBER := 0-1962.0724
1950: , p5_a13 NUMBER := 0-1962.0724
1951: , p5_a14 NUMBER := 0-1962.0724
1952: , p5_a15 NUMBER := 0-1962.0724
1953: , p5_a16 DATE := fnd_api.g_miss_date
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a13 NUMBER := 0-1962.0724
1951: , p5_a14 NUMBER := 0-1962.0724
1952: , p5_a15 NUMBER := 0-1962.0724
1953: , p5_a16 DATE := fnd_api.g_miss_date
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1951: , p5_a14 NUMBER := 0-1962.0724
1952: , p5_a15 NUMBER := 0-1962.0724
1953: , p5_a16 DATE := fnd_api.g_miss_date
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1952: , p5_a15 NUMBER := 0-1962.0724
1953: , p5_a16 DATE := fnd_api.g_miss_date
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1953: , p5_a16 DATE := fnd_api.g_miss_date
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1954: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1955: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1956: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1958: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1959: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1961: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1962: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1963: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1971: , p5_a34 DATE := fnd_api.g_miss_date
1964: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1971: , p5_a34 DATE := fnd_api.g_miss_date
1972: , p5_a35 NUMBER := 0-1962.0724
1965: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1966: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1971: , p5_a34 DATE := fnd_api.g_miss_date
1972: , p5_a35 NUMBER := 0-1962.0724
1973: , p5_a36 DATE := fnd_api.g_miss_date
1967: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1968: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1971: , p5_a34 DATE := fnd_api.g_miss_date
1972: , p5_a35 NUMBER := 0-1962.0724
1973: , p5_a36 DATE := fnd_api.g_miss_date
1974: , p5_a37 NUMBER := 0-1962.0724
1975: )
1969: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1970: , p5_a33 NUMBER := 0-1962.0724
1971: , p5_a34 DATE := fnd_api.g_miss_date
1972: , p5_a35 NUMBER := 0-1962.0724
1973: , p5_a36 DATE := fnd_api.g_miss_date
1974: , p5_a37 NUMBER := 0-1962.0724
1975: )
1976:
1977: as