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;
699: , p6_a32 out nocopy DATE
700: , p6_a33 out nocopy NUMBER
701: , p5_a0 NUMBER := 0-1962.0724
702: , p5_a1 NUMBER := 0-1962.0724
703: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a3 NUMBER := 0-1962.0724
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
701: , p5_a0 NUMBER := 0-1962.0724
702: , p5_a1 NUMBER := 0-1962.0724
703: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a3 NUMBER := 0-1962.0724
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
702: , p5_a1 NUMBER := 0-1962.0724
703: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a3 NUMBER := 0-1962.0724
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
703: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
704: , p5_a3 NUMBER := 0-1962.0724
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
704: , p5_a3 NUMBER := 0-1962.0724
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
705: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
706: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
708: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
709: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
710: , p5_a9 DATE := fnd_api.g_miss_date
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
711: , p5_a10 DATE := fnd_api.g_miss_date
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
712: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
713: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
714: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
715: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
716: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
717: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
718: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
719: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
720: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
721: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
722: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a29 NUMBER := 0-1962.0724
723: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
724: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a29 NUMBER := 0-1962.0724
731: , p5_a30 DATE := fnd_api.g_miss_date
725: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
726: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a29 NUMBER := 0-1962.0724
731: , p5_a30 DATE := fnd_api.g_miss_date
732: , p5_a31 NUMBER := 0-1962.0724
733: , p5_a32 DATE := fnd_api.g_miss_date
727: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
728: , p5_a27 NUMBER := 0-1962.0724
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a29 NUMBER := 0-1962.0724
731: , p5_a30 DATE := fnd_api.g_miss_date
732: , p5_a31 NUMBER := 0-1962.0724
733: , p5_a32 DATE := fnd_api.g_miss_date
734: , p5_a33 NUMBER := 0-1962.0724
735: )
729: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
730: , p5_a29 NUMBER := 0-1962.0724
731: , p5_a30 DATE := fnd_api.g_miss_date
732: , p5_a31 NUMBER := 0-1962.0724
733: , p5_a32 DATE := fnd_api.g_miss_date
734: , p5_a33 NUMBER := 0-1962.0724
735: )
736:
737: as
1017: , x_msg_count out nocopy NUMBER
1018: , x_msg_data out nocopy VARCHAR2
1019: , p5_a0 NUMBER := 0-1962.0724
1020: , p5_a1 NUMBER := 0-1962.0724
1021: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a3 NUMBER := 0-1962.0724
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a0 NUMBER := 0-1962.0724
1020: , p5_a1 NUMBER := 0-1962.0724
1021: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a3 NUMBER := 0-1962.0724
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a1 NUMBER := 0-1962.0724
1021: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a3 NUMBER := 0-1962.0724
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1021: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a3 NUMBER := 0-1962.0724
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1022: , p5_a3 NUMBER := 0-1962.0724
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a9 DATE := fnd_api.g_miss_date
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a10 DATE := fnd_api.g_miss_date
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1039: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1040: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a29 NUMBER := 0-1962.0724
1041: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1042: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a29 NUMBER := 0-1962.0724
1049: , p5_a30 DATE := fnd_api.g_miss_date
1043: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1044: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a29 NUMBER := 0-1962.0724
1049: , p5_a30 DATE := fnd_api.g_miss_date
1050: , p5_a31 NUMBER := 0-1962.0724
1051: , p5_a32 DATE := fnd_api.g_miss_date
1045: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1046: , p5_a27 NUMBER := 0-1962.0724
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a29 NUMBER := 0-1962.0724
1049: , p5_a30 DATE := fnd_api.g_miss_date
1050: , p5_a31 NUMBER := 0-1962.0724
1051: , p5_a32 DATE := fnd_api.g_miss_date
1052: , p5_a33 NUMBER := 0-1962.0724
1053: )
1047: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1048: , p5_a29 NUMBER := 0-1962.0724
1049: , p5_a30 DATE := fnd_api.g_miss_date
1050: , p5_a31 NUMBER := 0-1962.0724
1051: , p5_a32 DATE := fnd_api.g_miss_date
1052: , p5_a33 NUMBER := 0-1962.0724
1053: )
1054:
1055: as
1258: , p6_a32 out nocopy DATE
1259: , p6_a33 out nocopy NUMBER
1260: , p5_a0 NUMBER := 0-1962.0724
1261: , p5_a1 NUMBER := 0-1962.0724
1262: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a3 NUMBER := 0-1962.0724
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1260: , p5_a0 NUMBER := 0-1962.0724
1261: , p5_a1 NUMBER := 0-1962.0724
1262: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a3 NUMBER := 0-1962.0724
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1261: , p5_a1 NUMBER := 0-1962.0724
1262: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a3 NUMBER := 0-1962.0724
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1262: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1263: , p5_a3 NUMBER := 0-1962.0724
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1263: , p5_a3 NUMBER := 0-1962.0724
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1265: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1266: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1267: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1268: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1269: , p5_a9 DATE := fnd_api.g_miss_date
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1270: , p5_a10 DATE := fnd_api.g_miss_date
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1271: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1272: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1273: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1274: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1275: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1276: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1277: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1278: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1279: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1280: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1281: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a29 NUMBER := 0-1962.0724
1282: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a29 NUMBER := 0-1962.0724
1290: , p5_a30 DATE := fnd_api.g_miss_date
1284: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a29 NUMBER := 0-1962.0724
1290: , p5_a30 DATE := fnd_api.g_miss_date
1291: , p5_a31 NUMBER := 0-1962.0724
1292: , p5_a32 DATE := fnd_api.g_miss_date
1286: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a27 NUMBER := 0-1962.0724
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a29 NUMBER := 0-1962.0724
1290: , p5_a30 DATE := fnd_api.g_miss_date
1291: , p5_a31 NUMBER := 0-1962.0724
1292: , p5_a32 DATE := fnd_api.g_miss_date
1293: , p5_a33 NUMBER := 0-1962.0724
1294: )
1288: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a29 NUMBER := 0-1962.0724
1290: , p5_a30 DATE := fnd_api.g_miss_date
1291: , p5_a31 NUMBER := 0-1962.0724
1292: , p5_a32 DATE := fnd_api.g_miss_date
1293: , p5_a33 NUMBER := 0-1962.0724
1294: )
1295:
1296: as
1576: , x_msg_count out nocopy NUMBER
1577: , x_msg_data out nocopy VARCHAR2
1578: , p5_a0 NUMBER := 0-1962.0724
1579: , p5_a1 NUMBER := 0-1962.0724
1580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1581: , p5_a3 NUMBER := 0-1962.0724
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a0 NUMBER := 0-1962.0724
1579: , p5_a1 NUMBER := 0-1962.0724
1580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1581: , p5_a3 NUMBER := 0-1962.0724
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a1 NUMBER := 0-1962.0724
1580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1581: , p5_a3 NUMBER := 0-1962.0724
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1581: , p5_a3 NUMBER := 0-1962.0724
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1581: , p5_a3 NUMBER := 0-1962.0724
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1583: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1587: , p5_a9 DATE := fnd_api.g_miss_date
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1588: , p5_a10 DATE := fnd_api.g_miss_date
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1589: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1590: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1591: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1592: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1593: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1594: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1595: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1596: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1597: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1598: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1599: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a29 NUMBER := 0-1962.0724
1600: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1601: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a29 NUMBER := 0-1962.0724
1608: , p5_a30 DATE := fnd_api.g_miss_date
1602: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1603: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a29 NUMBER := 0-1962.0724
1608: , p5_a30 DATE := fnd_api.g_miss_date
1609: , p5_a31 NUMBER := 0-1962.0724
1610: , p5_a32 DATE := fnd_api.g_miss_date
1604: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1605: , p5_a27 NUMBER := 0-1962.0724
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a29 NUMBER := 0-1962.0724
1608: , p5_a30 DATE := fnd_api.g_miss_date
1609: , p5_a31 NUMBER := 0-1962.0724
1610: , p5_a32 DATE := fnd_api.g_miss_date
1611: , p5_a33 NUMBER := 0-1962.0724
1612: )
1606: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1607: , p5_a29 NUMBER := 0-1962.0724
1608: , p5_a30 DATE := fnd_api.g_miss_date
1609: , p5_a31 NUMBER := 0-1962.0724
1610: , p5_a32 DATE := fnd_api.g_miss_date
1611: , p5_a33 NUMBER := 0-1962.0724
1612: )
1613:
1614: as
1783: , x_msg_count out nocopy NUMBER
1784: , x_msg_data out nocopy VARCHAR2
1785: , p5_a0 NUMBER := 0-1962.0724
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a3 NUMBER := 0-1962.0724
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1785: , p5_a0 NUMBER := 0-1962.0724
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a3 NUMBER := 0-1962.0724
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1786: , p5_a1 NUMBER := 0-1962.0724
1787: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a3 NUMBER := 0-1962.0724
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1787: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1788: , p5_a3 NUMBER := 0-1962.0724
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1788: , p5_a3 NUMBER := 0-1962.0724
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1789: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1790: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1791: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1792: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1793: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1794: , p5_a9 DATE := fnd_api.g_miss_date
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1795: , p5_a10 DATE := fnd_api.g_miss_date
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1796: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1797: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1798: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1799: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1800: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1801: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1802: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1803: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1804: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1805: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1806: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a29 NUMBER := 0-1962.0724
1807: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1808: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a29 NUMBER := 0-1962.0724
1815: , p5_a30 DATE := fnd_api.g_miss_date
1809: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1810: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a29 NUMBER := 0-1962.0724
1815: , p5_a30 DATE := fnd_api.g_miss_date
1816: , p5_a31 NUMBER := 0-1962.0724
1817: , p5_a32 DATE := fnd_api.g_miss_date
1811: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1812: , p5_a27 NUMBER := 0-1962.0724
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a29 NUMBER := 0-1962.0724
1815: , p5_a30 DATE := fnd_api.g_miss_date
1816: , p5_a31 NUMBER := 0-1962.0724
1817: , p5_a32 DATE := fnd_api.g_miss_date
1818: , p5_a33 NUMBER := 0-1962.0724
1819: )
1813: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1814: , p5_a29 NUMBER := 0-1962.0724
1815: , p5_a30 DATE := fnd_api.g_miss_date
1816: , p5_a31 NUMBER := 0-1962.0724
1817: , p5_a32 DATE := fnd_api.g_miss_date
1818: , p5_a33 NUMBER := 0-1962.0724
1819: )
1820:
1821: as