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;
517: , p6_a26 out nocopy DATE
518: , p6_a27 out nocopy NUMBER
519: , p5_a0 NUMBER := 0-1962.0724
520: , p5_a1 NUMBER := 0-1962.0724
521: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
518: , p6_a27 out nocopy NUMBER
519: , p5_a0 NUMBER := 0-1962.0724
520: , p5_a1 NUMBER := 0-1962.0724
521: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a1 NUMBER := 0-1962.0724
521: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a4 NUMBER := 0-1962.0724
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
528: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
529: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
531: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
532: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
533: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a22 NUMBER := 0-1962.0724
534: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a22 NUMBER := 0-1962.0724
542: , p5_a23 NUMBER := 0-1962.0724
535: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a22 NUMBER := 0-1962.0724
542: , p5_a23 NUMBER := 0-1962.0724
543: , p5_a24 DATE := fnd_api.g_miss_date
536: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
537: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
538: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a22 NUMBER := 0-1962.0724
542: , p5_a23 NUMBER := 0-1962.0724
543: , p5_a24 DATE := fnd_api.g_miss_date
544: , p5_a25 NUMBER := 0-1962.0724
539: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
540: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
541: , p5_a22 NUMBER := 0-1962.0724
542: , p5_a23 NUMBER := 0-1962.0724
543: , p5_a24 DATE := fnd_api.g_miss_date
544: , p5_a25 NUMBER := 0-1962.0724
545: , p5_a26 DATE := fnd_api.g_miss_date
546: , p5_a27 NUMBER := 0-1962.0724
547: )
541: , p5_a22 NUMBER := 0-1962.0724
542: , p5_a23 NUMBER := 0-1962.0724
543: , p5_a24 DATE := fnd_api.g_miss_date
544: , p5_a25 NUMBER := 0-1962.0724
545: , p5_a26 DATE := fnd_api.g_miss_date
546: , p5_a27 NUMBER := 0-1962.0724
547: )
548:
549: as
793: , x_msg_count out nocopy NUMBER
794: , x_msg_data out nocopy VARCHAR2
795: , p5_a0 NUMBER := 0-1962.0724
796: , p5_a1 NUMBER := 0-1962.0724
797: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
794: , x_msg_data out nocopy VARCHAR2
795: , p5_a0 NUMBER := 0-1962.0724
796: , p5_a1 NUMBER := 0-1962.0724
797: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
796: , p5_a1 NUMBER := 0-1962.0724
797: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
797: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
798: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
799: , p5_a4 NUMBER := 0-1962.0724
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
800: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
801: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
802: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
803: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
804: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
805: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
806: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
807: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
808: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
809: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a22 NUMBER := 0-1962.0724
810: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a22 NUMBER := 0-1962.0724
818: , p5_a23 NUMBER := 0-1962.0724
811: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a22 NUMBER := 0-1962.0724
818: , p5_a23 NUMBER := 0-1962.0724
819: , p5_a24 DATE := fnd_api.g_miss_date
812: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
813: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
814: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a22 NUMBER := 0-1962.0724
818: , p5_a23 NUMBER := 0-1962.0724
819: , p5_a24 DATE := fnd_api.g_miss_date
820: , p5_a25 NUMBER := 0-1962.0724
815: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
816: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
817: , p5_a22 NUMBER := 0-1962.0724
818: , p5_a23 NUMBER := 0-1962.0724
819: , p5_a24 DATE := fnd_api.g_miss_date
820: , p5_a25 NUMBER := 0-1962.0724
821: , p5_a26 DATE := fnd_api.g_miss_date
822: , p5_a27 NUMBER := 0-1962.0724
823: )
817: , p5_a22 NUMBER := 0-1962.0724
818: , p5_a23 NUMBER := 0-1962.0724
819: , p5_a24 DATE := fnd_api.g_miss_date
820: , p5_a25 NUMBER := 0-1962.0724
821: , p5_a26 DATE := fnd_api.g_miss_date
822: , p5_a27 NUMBER := 0-1962.0724
823: )
824:
825: as
1004: , p6_a26 out nocopy DATE
1005: , p6_a27 out nocopy NUMBER
1006: , p5_a0 NUMBER := 0-1962.0724
1007: , p5_a1 NUMBER := 0-1962.0724
1008: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1005: , p6_a27 out nocopy NUMBER
1006: , p5_a0 NUMBER := 0-1962.0724
1007: , p5_a1 NUMBER := 0-1962.0724
1008: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a1 NUMBER := 0-1962.0724
1008: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1008: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a4 NUMBER := 0-1962.0724
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a22 NUMBER := 0-1962.0724
1021: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a22 NUMBER := 0-1962.0724
1029: , p5_a23 NUMBER := 0-1962.0724
1022: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a22 NUMBER := 0-1962.0724
1029: , p5_a23 NUMBER := 0-1962.0724
1030: , p5_a24 DATE := fnd_api.g_miss_date
1023: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a22 NUMBER := 0-1962.0724
1029: , p5_a23 NUMBER := 0-1962.0724
1030: , p5_a24 DATE := fnd_api.g_miss_date
1031: , p5_a25 NUMBER := 0-1962.0724
1026: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a22 NUMBER := 0-1962.0724
1029: , p5_a23 NUMBER := 0-1962.0724
1030: , p5_a24 DATE := fnd_api.g_miss_date
1031: , p5_a25 NUMBER := 0-1962.0724
1032: , p5_a26 DATE := fnd_api.g_miss_date
1033: , p5_a27 NUMBER := 0-1962.0724
1034: )
1028: , p5_a22 NUMBER := 0-1962.0724
1029: , p5_a23 NUMBER := 0-1962.0724
1030: , p5_a24 DATE := fnd_api.g_miss_date
1031: , p5_a25 NUMBER := 0-1962.0724
1032: , p5_a26 DATE := fnd_api.g_miss_date
1033: , p5_a27 NUMBER := 0-1962.0724
1034: )
1035:
1036: as
1280: , x_msg_count out nocopy NUMBER
1281: , x_msg_data out nocopy VARCHAR2
1282: , p5_a0 NUMBER := 0-1962.0724
1283: , p5_a1 NUMBER := 0-1962.0724
1284: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1281: , x_msg_data out nocopy VARCHAR2
1282: , p5_a0 NUMBER := 0-1962.0724
1283: , p5_a1 NUMBER := 0-1962.0724
1284: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1283: , p5_a1 NUMBER := 0-1962.0724
1284: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1284: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1285: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1286: , p5_a4 NUMBER := 0-1962.0724
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1287: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1288: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1289: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1290: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1291: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1292: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1293: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1294: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1295: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1296: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a22 NUMBER := 0-1962.0724
1297: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a22 NUMBER := 0-1962.0724
1305: , p5_a23 NUMBER := 0-1962.0724
1298: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a22 NUMBER := 0-1962.0724
1305: , p5_a23 NUMBER := 0-1962.0724
1306: , p5_a24 DATE := fnd_api.g_miss_date
1299: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1300: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1301: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a22 NUMBER := 0-1962.0724
1305: , p5_a23 NUMBER := 0-1962.0724
1306: , p5_a24 DATE := fnd_api.g_miss_date
1307: , p5_a25 NUMBER := 0-1962.0724
1302: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1303: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1304: , p5_a22 NUMBER := 0-1962.0724
1305: , p5_a23 NUMBER := 0-1962.0724
1306: , p5_a24 DATE := fnd_api.g_miss_date
1307: , p5_a25 NUMBER := 0-1962.0724
1308: , p5_a26 DATE := fnd_api.g_miss_date
1309: , p5_a27 NUMBER := 0-1962.0724
1310: )
1304: , p5_a22 NUMBER := 0-1962.0724
1305: , p5_a23 NUMBER := 0-1962.0724
1306: , p5_a24 DATE := fnd_api.g_miss_date
1307: , p5_a25 NUMBER := 0-1962.0724
1308: , p5_a26 DATE := fnd_api.g_miss_date
1309: , p5_a27 NUMBER := 0-1962.0724
1310: )
1311:
1312: as
1463: , x_msg_count out nocopy NUMBER
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 NUMBER := 0-1962.0724
1466: , p5_a1 NUMBER := 0-1962.0724
1467: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1464: , x_msg_data out nocopy VARCHAR2
1465: , p5_a0 NUMBER := 0-1962.0724
1466: , p5_a1 NUMBER := 0-1962.0724
1467: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a1 NUMBER := 0-1962.0724
1467: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a4 NUMBER := 0-1962.0724
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1472: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1473: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1474: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1475: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1476: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1477: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1478: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1479: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a22 NUMBER := 0-1962.0724
1480: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a22 NUMBER := 0-1962.0724
1488: , p5_a23 NUMBER := 0-1962.0724
1481: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a22 NUMBER := 0-1962.0724
1488: , p5_a23 NUMBER := 0-1962.0724
1489: , p5_a24 DATE := fnd_api.g_miss_date
1482: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1483: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1484: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a22 NUMBER := 0-1962.0724
1488: , p5_a23 NUMBER := 0-1962.0724
1489: , p5_a24 DATE := fnd_api.g_miss_date
1490: , p5_a25 NUMBER := 0-1962.0724
1485: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1486: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1487: , p5_a22 NUMBER := 0-1962.0724
1488: , p5_a23 NUMBER := 0-1962.0724
1489: , p5_a24 DATE := fnd_api.g_miss_date
1490: , p5_a25 NUMBER := 0-1962.0724
1491: , p5_a26 DATE := fnd_api.g_miss_date
1492: , p5_a27 NUMBER := 0-1962.0724
1493: )
1487: , p5_a22 NUMBER := 0-1962.0724
1488: , p5_a23 NUMBER := 0-1962.0724
1489: , p5_a24 DATE := fnd_api.g_miss_date
1490: , p5_a25 NUMBER := 0-1962.0724
1491: , p5_a26 DATE := fnd_api.g_miss_date
1492: , p5_a27 NUMBER := 0-1962.0724
1493: )
1494:
1495: as