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;
609: , p6_a26 out nocopy DATE
610: , p6_a27 out nocopy NUMBER
611: , p5_a0 NUMBER := 0-1962.0724
612: , p5_a1 NUMBER := 0-1962.0724
613: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a3 NUMBER := 0-1962.0724
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a1 NUMBER := 0-1962.0724
613: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a3 NUMBER := 0-1962.0724
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a3 NUMBER := 0-1962.0724
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a3 NUMBER := 0-1962.0724
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a4 NUMBER := 0-1962.0724
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
619: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
620: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
621: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
622: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
623: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
624: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
625: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
626: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
627: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
635: , p5_a24 DATE := fnd_api.g_miss_date
628: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
635: , p5_a24 DATE := fnd_api.g_miss_date
636: , p5_a25 NUMBER := 0-1962.0724
629: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
630: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
635: , p5_a24 DATE := fnd_api.g_miss_date
636: , p5_a25 NUMBER := 0-1962.0724
637: , p5_a26 DATE := fnd_api.g_miss_date
631: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
635: , p5_a24 DATE := fnd_api.g_miss_date
636: , p5_a25 NUMBER := 0-1962.0724
637: , p5_a26 DATE := fnd_api.g_miss_date
638: , p5_a27 NUMBER := 0-1962.0724
639: )
633: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
634: , p5_a23 NUMBER := 0-1962.0724
635: , p5_a24 DATE := fnd_api.g_miss_date
636: , p5_a25 NUMBER := 0-1962.0724
637: , p5_a26 DATE := fnd_api.g_miss_date
638: , p5_a27 NUMBER := 0-1962.0724
639: )
640:
641: as
885: , x_msg_count out nocopy NUMBER
886: , x_msg_data out nocopy VARCHAR2
887: , p5_a0 NUMBER := 0-1962.0724
888: , p5_a1 NUMBER := 0-1962.0724
889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a3 NUMBER := 0-1962.0724
891: , p5_a4 NUMBER := 0-1962.0724
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
888: , p5_a1 NUMBER := 0-1962.0724
889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a3 NUMBER := 0-1962.0724
891: , p5_a4 NUMBER := 0-1962.0724
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
889: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a3 NUMBER := 0-1962.0724
891: , p5_a4 NUMBER := 0-1962.0724
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
890: , p5_a3 NUMBER := 0-1962.0724
891: , p5_a4 NUMBER := 0-1962.0724
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
891: , p5_a4 NUMBER := 0-1962.0724
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
892: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
893: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
894: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
895: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
896: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
897: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
898: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
900: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
903: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
911: , p5_a24 DATE := fnd_api.g_miss_date
904: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
911: , p5_a24 DATE := fnd_api.g_miss_date
912: , p5_a25 NUMBER := 0-1962.0724
905: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
911: , p5_a24 DATE := fnd_api.g_miss_date
912: , p5_a25 NUMBER := 0-1962.0724
913: , p5_a26 DATE := fnd_api.g_miss_date
907: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
911: , p5_a24 DATE := fnd_api.g_miss_date
912: , p5_a25 NUMBER := 0-1962.0724
913: , p5_a26 DATE := fnd_api.g_miss_date
914: , p5_a27 NUMBER := 0-1962.0724
915: )
909: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a23 NUMBER := 0-1962.0724
911: , p5_a24 DATE := fnd_api.g_miss_date
912: , p5_a25 NUMBER := 0-1962.0724
913: , p5_a26 DATE := fnd_api.g_miss_date
914: , p5_a27 NUMBER := 0-1962.0724
915: )
916:
917: as
1096: , p6_a26 out nocopy DATE
1097: , p6_a27 out nocopy NUMBER
1098: , p5_a0 NUMBER := 0-1962.0724
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 NUMBER := 0-1962.0724
1102: , p5_a4 NUMBER := 0-1962.0724
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1099: , p5_a1 NUMBER := 0-1962.0724
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 NUMBER := 0-1962.0724
1102: , p5_a4 NUMBER := 0-1962.0724
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1100: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 NUMBER := 0-1962.0724
1102: , p5_a4 NUMBER := 0-1962.0724
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1101: , p5_a3 NUMBER := 0-1962.0724
1102: , p5_a4 NUMBER := 0-1962.0724
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1102: , p5_a4 NUMBER := 0-1962.0724
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1103: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1104: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1105: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1106: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1107: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1108: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1109: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1110: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1111: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1112: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1113: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1114: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1122: , p5_a24 DATE := fnd_api.g_miss_date
1115: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1122: , p5_a24 DATE := fnd_api.g_miss_date
1123: , p5_a25 NUMBER := 0-1962.0724
1116: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1117: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1122: , p5_a24 DATE := fnd_api.g_miss_date
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 DATE := fnd_api.g_miss_date
1118: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1119: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1122: , p5_a24 DATE := fnd_api.g_miss_date
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 DATE := fnd_api.g_miss_date
1125: , p5_a27 NUMBER := 0-1962.0724
1126: )
1120: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1121: , p5_a23 NUMBER := 0-1962.0724
1122: , p5_a24 DATE := fnd_api.g_miss_date
1123: , p5_a25 NUMBER := 0-1962.0724
1124: , p5_a26 DATE := fnd_api.g_miss_date
1125: , p5_a27 NUMBER := 0-1962.0724
1126: )
1127:
1128: as
1372: , x_msg_count out nocopy NUMBER
1373: , x_msg_data out nocopy VARCHAR2
1374: , p5_a0 NUMBER := 0-1962.0724
1375: , p5_a1 NUMBER := 0-1962.0724
1376: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1377: , p5_a3 NUMBER := 0-1962.0724
1378: , p5_a4 NUMBER := 0-1962.0724
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1375: , p5_a1 NUMBER := 0-1962.0724
1376: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1377: , p5_a3 NUMBER := 0-1962.0724
1378: , p5_a4 NUMBER := 0-1962.0724
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1376: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1377: , p5_a3 NUMBER := 0-1962.0724
1378: , p5_a4 NUMBER := 0-1962.0724
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1377: , p5_a3 NUMBER := 0-1962.0724
1378: , p5_a4 NUMBER := 0-1962.0724
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1378: , p5_a4 NUMBER := 0-1962.0724
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1379: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1380: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1381: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1382: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1383: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1384: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1386: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1390: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1398: , p5_a24 DATE := fnd_api.g_miss_date
1391: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1398: , p5_a24 DATE := fnd_api.g_miss_date
1399: , p5_a25 NUMBER := 0-1962.0724
1392: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1398: , p5_a24 DATE := fnd_api.g_miss_date
1399: , p5_a25 NUMBER := 0-1962.0724
1400: , p5_a26 DATE := fnd_api.g_miss_date
1394: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1398: , p5_a24 DATE := fnd_api.g_miss_date
1399: , p5_a25 NUMBER := 0-1962.0724
1400: , p5_a26 DATE := fnd_api.g_miss_date
1401: , p5_a27 NUMBER := 0-1962.0724
1402: )
1396: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a23 NUMBER := 0-1962.0724
1398: , p5_a24 DATE := fnd_api.g_miss_date
1399: , p5_a25 NUMBER := 0-1962.0724
1400: , p5_a26 DATE := fnd_api.g_miss_date
1401: , p5_a27 NUMBER := 0-1962.0724
1402: )
1403:
1404: as
1555: , x_msg_count out nocopy NUMBER
1556: , x_msg_data out nocopy VARCHAR2
1557: , p5_a0 NUMBER := 0-1962.0724
1558: , p5_a1 NUMBER := 0-1962.0724
1559: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a3 NUMBER := 0-1962.0724
1561: , p5_a4 NUMBER := 0-1962.0724
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1558: , p5_a1 NUMBER := 0-1962.0724
1559: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a3 NUMBER := 0-1962.0724
1561: , p5_a4 NUMBER := 0-1962.0724
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1559: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a3 NUMBER := 0-1962.0724
1561: , p5_a4 NUMBER := 0-1962.0724
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1560: , p5_a3 NUMBER := 0-1962.0724
1561: , p5_a4 NUMBER := 0-1962.0724
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1561: , p5_a4 NUMBER := 0-1962.0724
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1562: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1563: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1564: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1565: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1566: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1567: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1568: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1569: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1570: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1571: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1572: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1573: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1581: , p5_a24 DATE := fnd_api.g_miss_date
1574: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1581: , p5_a24 DATE := fnd_api.g_miss_date
1582: , p5_a25 NUMBER := 0-1962.0724
1575: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1576: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1581: , p5_a24 DATE := fnd_api.g_miss_date
1582: , p5_a25 NUMBER := 0-1962.0724
1583: , p5_a26 DATE := fnd_api.g_miss_date
1577: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1578: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1581: , p5_a24 DATE := fnd_api.g_miss_date
1582: , p5_a25 NUMBER := 0-1962.0724
1583: , p5_a26 DATE := fnd_api.g_miss_date
1584: , p5_a27 NUMBER := 0-1962.0724
1585: )
1579: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1580: , p5_a23 NUMBER := 0-1962.0724
1581: , p5_a24 DATE := fnd_api.g_miss_date
1582: , p5_a25 NUMBER := 0-1962.0724
1583: , p5_a26 DATE := fnd_api.g_miss_date
1584: , p5_a27 NUMBER := 0-1962.0724
1585: )
1586:
1587: as