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;
697: , p6_a38 out nocopy VARCHAR2
698: , p6_a39 out nocopy NUMBER
699: , p5_a0 NUMBER := 0-1962.0724
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
698: , p6_a39 out nocopy NUMBER
699: , p5_a0 NUMBER := 0-1962.0724
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
699: , p5_a0 NUMBER := 0-1962.0724
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
700: , p5_a1 NUMBER := 0-1962.0724
701: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
703: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a6 DATE := fnd_api.g_miss_date
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a7 DATE := fnd_api.g_miss_date
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a25 NUMBER := 0-1962.0724
717: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 NUMBER := 0-1962.0724
718: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 NUMBER := 0-1962.0724
726: , p5_a27 NUMBER := 0-1962.0724
719: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 NUMBER := 0-1962.0724
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 NUMBER := 0-1962.0724
724: , p5_a25 NUMBER := 0-1962.0724
725: , p5_a26 NUMBER := 0-1962.0724
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 NUMBER := 0-1962.0724
728: , p5_a29 DATE := fnd_api.g_miss_date
729: , p5_a30 NUMBER := 0-1962.0724
730: , p5_a31 DATE := fnd_api.g_miss_date
731: , p5_a32 NUMBER := 0-1962.0724
732: , p5_a33 DATE := fnd_api.g_miss_date
726: , p5_a27 NUMBER := 0-1962.0724
727: , p5_a28 NUMBER := 0-1962.0724
728: , p5_a29 DATE := fnd_api.g_miss_date
729: , p5_a30 NUMBER := 0-1962.0724
730: , p5_a31 DATE := fnd_api.g_miss_date
731: , p5_a32 NUMBER := 0-1962.0724
732: , p5_a33 DATE := fnd_api.g_miss_date
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a29 DATE := fnd_api.g_miss_date
729: , p5_a30 NUMBER := 0-1962.0724
730: , p5_a31 DATE := fnd_api.g_miss_date
731: , p5_a32 NUMBER := 0-1962.0724
732: , p5_a33 DATE := fnd_api.g_miss_date
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a36 DATE := fnd_api.g_miss_date
736: , p5_a37 NUMBER := 0-1962.0724
730: , p5_a31 DATE := fnd_api.g_miss_date
731: , p5_a32 NUMBER := 0-1962.0724
732: , p5_a33 DATE := fnd_api.g_miss_date
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a36 DATE := fnd_api.g_miss_date
736: , p5_a37 NUMBER := 0-1962.0724
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 NUMBER := 0-1962.0724
731: , p5_a32 NUMBER := 0-1962.0724
732: , p5_a33 DATE := fnd_api.g_miss_date
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a36 DATE := fnd_api.g_miss_date
736: , p5_a37 NUMBER := 0-1962.0724
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 NUMBER := 0-1962.0724
739: )
733: , p5_a34 NUMBER := 0-1962.0724
734: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
735: , p5_a36 DATE := fnd_api.g_miss_date
736: , p5_a37 NUMBER := 0-1962.0724
737: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
738: , p5_a39 NUMBER := 0-1962.0724
739: )
740:
741: as
1057: , x_msg_count out nocopy NUMBER
1058: , x_msg_data out nocopy VARCHAR2
1059: , p5_a0 NUMBER := 0-1962.0724
1060: , p5_a1 NUMBER := 0-1962.0724
1061: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1058: , x_msg_data out nocopy VARCHAR2
1059: , p5_a0 NUMBER := 0-1962.0724
1060: , p5_a1 NUMBER := 0-1962.0724
1061: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1059: , p5_a0 NUMBER := 0-1962.0724
1060: , p5_a1 NUMBER := 0-1962.0724
1061: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1060: , p5_a1 NUMBER := 0-1962.0724
1061: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1061: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1062: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1063: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1064: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1065: , p5_a6 DATE := fnd_api.g_miss_date
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1066: , p5_a7 DATE := fnd_api.g_miss_date
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1067: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1068: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1069: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1070: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1071: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1072: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1073: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1074: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1075: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1083: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1076: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1083: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1084: , p5_a25 NUMBER := 0-1962.0724
1077: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1083: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1084: , p5_a25 NUMBER := 0-1962.0724
1085: , p5_a26 NUMBER := 0-1962.0724
1078: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1083: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1084: , p5_a25 NUMBER := 0-1962.0724
1085: , p5_a26 NUMBER := 0-1962.0724
1086: , p5_a27 NUMBER := 0-1962.0724
1079: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1080: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1081: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1082: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1083: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1084: , p5_a25 NUMBER := 0-1962.0724
1085: , p5_a26 NUMBER := 0-1962.0724
1086: , p5_a27 NUMBER := 0-1962.0724
1087: , p5_a28 NUMBER := 0-1962.0724
1084: , p5_a25 NUMBER := 0-1962.0724
1085: , p5_a26 NUMBER := 0-1962.0724
1086: , p5_a27 NUMBER := 0-1962.0724
1087: , p5_a28 NUMBER := 0-1962.0724
1088: , p5_a29 DATE := fnd_api.g_miss_date
1089: , p5_a30 NUMBER := 0-1962.0724
1090: , p5_a31 DATE := fnd_api.g_miss_date
1091: , p5_a32 NUMBER := 0-1962.0724
1092: , p5_a33 DATE := fnd_api.g_miss_date
1086: , p5_a27 NUMBER := 0-1962.0724
1087: , p5_a28 NUMBER := 0-1962.0724
1088: , p5_a29 DATE := fnd_api.g_miss_date
1089: , p5_a30 NUMBER := 0-1962.0724
1090: , p5_a31 DATE := fnd_api.g_miss_date
1091: , p5_a32 NUMBER := 0-1962.0724
1092: , p5_a33 DATE := fnd_api.g_miss_date
1093: , p5_a34 NUMBER := 0-1962.0724
1094: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a29 DATE := fnd_api.g_miss_date
1089: , p5_a30 NUMBER := 0-1962.0724
1090: , p5_a31 DATE := fnd_api.g_miss_date
1091: , p5_a32 NUMBER := 0-1962.0724
1092: , p5_a33 DATE := fnd_api.g_miss_date
1093: , p5_a34 NUMBER := 0-1962.0724
1094: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a36 DATE := fnd_api.g_miss_date
1096: , p5_a37 NUMBER := 0-1962.0724
1090: , p5_a31 DATE := fnd_api.g_miss_date
1091: , p5_a32 NUMBER := 0-1962.0724
1092: , p5_a33 DATE := fnd_api.g_miss_date
1093: , p5_a34 NUMBER := 0-1962.0724
1094: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a36 DATE := fnd_api.g_miss_date
1096: , p5_a37 NUMBER := 0-1962.0724
1097: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a39 NUMBER := 0-1962.0724
1091: , p5_a32 NUMBER := 0-1962.0724
1092: , p5_a33 DATE := fnd_api.g_miss_date
1093: , p5_a34 NUMBER := 0-1962.0724
1094: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a36 DATE := fnd_api.g_miss_date
1096: , p5_a37 NUMBER := 0-1962.0724
1097: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a39 NUMBER := 0-1962.0724
1099: )
1093: , p5_a34 NUMBER := 0-1962.0724
1094: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a36 DATE := fnd_api.g_miss_date
1096: , p5_a37 NUMBER := 0-1962.0724
1097: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a39 NUMBER := 0-1962.0724
1099: )
1100:
1101: as
1328: , p6_a38 out nocopy VARCHAR2
1329: , p6_a39 out nocopy NUMBER
1330: , p5_a0 NUMBER := 0-1962.0724
1331: , p5_a1 NUMBER := 0-1962.0724
1332: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1329: , p6_a39 out nocopy NUMBER
1330: , p5_a0 NUMBER := 0-1962.0724
1331: , p5_a1 NUMBER := 0-1962.0724
1332: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1330: , p5_a0 NUMBER := 0-1962.0724
1331: , p5_a1 NUMBER := 0-1962.0724
1332: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1331: , p5_a1 NUMBER := 0-1962.0724
1332: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1332: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1333: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1334: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1335: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1336: , p5_a6 DATE := fnd_api.g_miss_date
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1337: , p5_a7 DATE := fnd_api.g_miss_date
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1338: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1339: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1340: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1341: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1342: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1343: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1344: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1345: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1346: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1347: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a25 NUMBER := 0-1962.0724
1348: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a25 NUMBER := 0-1962.0724
1356: , p5_a26 NUMBER := 0-1962.0724
1349: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a25 NUMBER := 0-1962.0724
1356: , p5_a26 NUMBER := 0-1962.0724
1357: , p5_a27 NUMBER := 0-1962.0724
1350: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1351: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1352: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1353: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1354: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1355: , p5_a25 NUMBER := 0-1962.0724
1356: , p5_a26 NUMBER := 0-1962.0724
1357: , p5_a27 NUMBER := 0-1962.0724
1358: , p5_a28 NUMBER := 0-1962.0724
1355: , p5_a25 NUMBER := 0-1962.0724
1356: , p5_a26 NUMBER := 0-1962.0724
1357: , p5_a27 NUMBER := 0-1962.0724
1358: , p5_a28 NUMBER := 0-1962.0724
1359: , p5_a29 DATE := fnd_api.g_miss_date
1360: , p5_a30 NUMBER := 0-1962.0724
1361: , p5_a31 DATE := fnd_api.g_miss_date
1362: , p5_a32 NUMBER := 0-1962.0724
1363: , p5_a33 DATE := fnd_api.g_miss_date
1357: , p5_a27 NUMBER := 0-1962.0724
1358: , p5_a28 NUMBER := 0-1962.0724
1359: , p5_a29 DATE := fnd_api.g_miss_date
1360: , p5_a30 NUMBER := 0-1962.0724
1361: , p5_a31 DATE := fnd_api.g_miss_date
1362: , p5_a32 NUMBER := 0-1962.0724
1363: , p5_a33 DATE := fnd_api.g_miss_date
1364: , p5_a34 NUMBER := 0-1962.0724
1365: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1359: , p5_a29 DATE := fnd_api.g_miss_date
1360: , p5_a30 NUMBER := 0-1962.0724
1361: , p5_a31 DATE := fnd_api.g_miss_date
1362: , p5_a32 NUMBER := 0-1962.0724
1363: , p5_a33 DATE := fnd_api.g_miss_date
1364: , p5_a34 NUMBER := 0-1962.0724
1365: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1366: , p5_a36 DATE := fnd_api.g_miss_date
1367: , p5_a37 NUMBER := 0-1962.0724
1361: , p5_a31 DATE := fnd_api.g_miss_date
1362: , p5_a32 NUMBER := 0-1962.0724
1363: , p5_a33 DATE := fnd_api.g_miss_date
1364: , p5_a34 NUMBER := 0-1962.0724
1365: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1366: , p5_a36 DATE := fnd_api.g_miss_date
1367: , p5_a37 NUMBER := 0-1962.0724
1368: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1369: , p5_a39 NUMBER := 0-1962.0724
1362: , p5_a32 NUMBER := 0-1962.0724
1363: , p5_a33 DATE := fnd_api.g_miss_date
1364: , p5_a34 NUMBER := 0-1962.0724
1365: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1366: , p5_a36 DATE := fnd_api.g_miss_date
1367: , p5_a37 NUMBER := 0-1962.0724
1368: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1369: , p5_a39 NUMBER := 0-1962.0724
1370: )
1364: , p5_a34 NUMBER := 0-1962.0724
1365: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1366: , p5_a36 DATE := fnd_api.g_miss_date
1367: , p5_a37 NUMBER := 0-1962.0724
1368: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1369: , p5_a39 NUMBER := 0-1962.0724
1370: )
1371:
1372: as
1688: , x_msg_count out nocopy NUMBER
1689: , x_msg_data out nocopy VARCHAR2
1690: , p5_a0 NUMBER := 0-1962.0724
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1689: , x_msg_data out nocopy VARCHAR2
1690: , p5_a0 NUMBER := 0-1962.0724
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1690: , p5_a0 NUMBER := 0-1962.0724
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1691: , p5_a1 NUMBER := 0-1962.0724
1692: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1692: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1693: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1694: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1695: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1696: , p5_a6 DATE := fnd_api.g_miss_date
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1697: , p5_a7 DATE := fnd_api.g_miss_date
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1698: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1699: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1700: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1701: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1702: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1703: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1704: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1705: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1706: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1707: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a25 NUMBER := 0-1962.0724
1708: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a25 NUMBER := 0-1962.0724
1716: , p5_a26 NUMBER := 0-1962.0724
1709: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a25 NUMBER := 0-1962.0724
1716: , p5_a26 NUMBER := 0-1962.0724
1717: , p5_a27 NUMBER := 0-1962.0724
1710: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1711: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1712: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1713: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1714: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1715: , p5_a25 NUMBER := 0-1962.0724
1716: , p5_a26 NUMBER := 0-1962.0724
1717: , p5_a27 NUMBER := 0-1962.0724
1718: , p5_a28 NUMBER := 0-1962.0724
1715: , p5_a25 NUMBER := 0-1962.0724
1716: , p5_a26 NUMBER := 0-1962.0724
1717: , p5_a27 NUMBER := 0-1962.0724
1718: , p5_a28 NUMBER := 0-1962.0724
1719: , p5_a29 DATE := fnd_api.g_miss_date
1720: , p5_a30 NUMBER := 0-1962.0724
1721: , p5_a31 DATE := fnd_api.g_miss_date
1722: , p5_a32 NUMBER := 0-1962.0724
1723: , p5_a33 DATE := fnd_api.g_miss_date
1717: , p5_a27 NUMBER := 0-1962.0724
1718: , p5_a28 NUMBER := 0-1962.0724
1719: , p5_a29 DATE := fnd_api.g_miss_date
1720: , p5_a30 NUMBER := 0-1962.0724
1721: , p5_a31 DATE := fnd_api.g_miss_date
1722: , p5_a32 NUMBER := 0-1962.0724
1723: , p5_a33 DATE := fnd_api.g_miss_date
1724: , p5_a34 NUMBER := 0-1962.0724
1725: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1719: , p5_a29 DATE := fnd_api.g_miss_date
1720: , p5_a30 NUMBER := 0-1962.0724
1721: , p5_a31 DATE := fnd_api.g_miss_date
1722: , p5_a32 NUMBER := 0-1962.0724
1723: , p5_a33 DATE := fnd_api.g_miss_date
1724: , p5_a34 NUMBER := 0-1962.0724
1725: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a36 DATE := fnd_api.g_miss_date
1727: , p5_a37 NUMBER := 0-1962.0724
1721: , p5_a31 DATE := fnd_api.g_miss_date
1722: , p5_a32 NUMBER := 0-1962.0724
1723: , p5_a33 DATE := fnd_api.g_miss_date
1724: , p5_a34 NUMBER := 0-1962.0724
1725: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a36 DATE := fnd_api.g_miss_date
1727: , p5_a37 NUMBER := 0-1962.0724
1728: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a39 NUMBER := 0-1962.0724
1722: , p5_a32 NUMBER := 0-1962.0724
1723: , p5_a33 DATE := fnd_api.g_miss_date
1724: , p5_a34 NUMBER := 0-1962.0724
1725: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a36 DATE := fnd_api.g_miss_date
1727: , p5_a37 NUMBER := 0-1962.0724
1728: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a39 NUMBER := 0-1962.0724
1730: )
1724: , p5_a34 NUMBER := 0-1962.0724
1725: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1726: , p5_a36 DATE := fnd_api.g_miss_date
1727: , p5_a37 NUMBER := 0-1962.0724
1728: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1729: , p5_a39 NUMBER := 0-1962.0724
1730: )
1731:
1732: as
1919: , x_msg_count out nocopy NUMBER
1920: , x_msg_data out nocopy VARCHAR2
1921: , p5_a0 NUMBER := 0-1962.0724
1922: , p5_a1 NUMBER := 0-1962.0724
1923: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1920: , x_msg_data out nocopy VARCHAR2
1921: , p5_a0 NUMBER := 0-1962.0724
1922: , p5_a1 NUMBER := 0-1962.0724
1923: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1921: , p5_a0 NUMBER := 0-1962.0724
1922: , p5_a1 NUMBER := 0-1962.0724
1923: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1922: , p5_a1 NUMBER := 0-1962.0724
1923: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1923: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1924: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1925: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1926: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1927: , p5_a6 DATE := fnd_api.g_miss_date
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1928: , p5_a7 DATE := fnd_api.g_miss_date
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1929: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1930: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1931: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1932: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1933: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1934: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1935: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1936: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1937: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1938: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a25 NUMBER := 0-1962.0724
1939: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a25 NUMBER := 0-1962.0724
1947: , p5_a26 NUMBER := 0-1962.0724
1940: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a25 NUMBER := 0-1962.0724
1947: , p5_a26 NUMBER := 0-1962.0724
1948: , p5_a27 NUMBER := 0-1962.0724
1941: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1942: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1943: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1944: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1945: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1946: , p5_a25 NUMBER := 0-1962.0724
1947: , p5_a26 NUMBER := 0-1962.0724
1948: , p5_a27 NUMBER := 0-1962.0724
1949: , p5_a28 NUMBER := 0-1962.0724
1946: , p5_a25 NUMBER := 0-1962.0724
1947: , p5_a26 NUMBER := 0-1962.0724
1948: , p5_a27 NUMBER := 0-1962.0724
1949: , p5_a28 NUMBER := 0-1962.0724
1950: , p5_a29 DATE := fnd_api.g_miss_date
1951: , p5_a30 NUMBER := 0-1962.0724
1952: , p5_a31 DATE := fnd_api.g_miss_date
1953: , p5_a32 NUMBER := 0-1962.0724
1954: , p5_a33 DATE := fnd_api.g_miss_date
1948: , p5_a27 NUMBER := 0-1962.0724
1949: , p5_a28 NUMBER := 0-1962.0724
1950: , p5_a29 DATE := fnd_api.g_miss_date
1951: , p5_a30 NUMBER := 0-1962.0724
1952: , p5_a31 DATE := fnd_api.g_miss_date
1953: , p5_a32 NUMBER := 0-1962.0724
1954: , p5_a33 DATE := fnd_api.g_miss_date
1955: , p5_a34 NUMBER := 0-1962.0724
1956: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1950: , p5_a29 DATE := fnd_api.g_miss_date
1951: , p5_a30 NUMBER := 0-1962.0724
1952: , p5_a31 DATE := fnd_api.g_miss_date
1953: , p5_a32 NUMBER := 0-1962.0724
1954: , p5_a33 DATE := fnd_api.g_miss_date
1955: , p5_a34 NUMBER := 0-1962.0724
1956: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a36 DATE := fnd_api.g_miss_date
1958: , p5_a37 NUMBER := 0-1962.0724
1952: , p5_a31 DATE := fnd_api.g_miss_date
1953: , p5_a32 NUMBER := 0-1962.0724
1954: , p5_a33 DATE := fnd_api.g_miss_date
1955: , p5_a34 NUMBER := 0-1962.0724
1956: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a36 DATE := fnd_api.g_miss_date
1958: , p5_a37 NUMBER := 0-1962.0724
1959: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a39 NUMBER := 0-1962.0724
1953: , p5_a32 NUMBER := 0-1962.0724
1954: , p5_a33 DATE := fnd_api.g_miss_date
1955: , p5_a34 NUMBER := 0-1962.0724
1956: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a36 DATE := fnd_api.g_miss_date
1958: , p5_a37 NUMBER := 0-1962.0724
1959: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a39 NUMBER := 0-1962.0724
1961: )
1955: , p5_a34 NUMBER := 0-1962.0724
1956: , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1957: , p5_a36 DATE := fnd_api.g_miss_date
1958: , p5_a37 NUMBER := 0-1962.0724
1959: , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1960: , p5_a39 NUMBER := 0-1962.0724
1961: )
1962:
1963: as