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;
586: , p6_a32 out nocopy NUMBER
587: , p5_a0 NUMBER := 0-1962.0724
588: , p5_a1 NUMBER := 0-1962.0724
589: , p5_a2 NUMBER := 0-1962.0724
590: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a4 NUMBER := 0-1962.0724
592: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a6 NUMBER := 0-1962.0724
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a1 NUMBER := 0-1962.0724
589: , p5_a2 NUMBER := 0-1962.0724
590: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a4 NUMBER := 0-1962.0724
592: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a6 NUMBER := 0-1962.0724
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
591: , p5_a4 NUMBER := 0-1962.0724
592: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a6 NUMBER := 0-1962.0724
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
592: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a6 NUMBER := 0-1962.0724
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
593: , p5_a6 NUMBER := 0-1962.0724
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a8 NUMBER := 0-1962.0724
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
597: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
600: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a26 NUMBER := 0-1962.0724
606: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a26 NUMBER := 0-1962.0724
614: , p5_a27 NUMBER := 0-1962.0724
607: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a26 NUMBER := 0-1962.0724
614: , p5_a27 NUMBER := 0-1962.0724
615: , p5_a28 NUMBER := 0-1962.0724
608: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a26 NUMBER := 0-1962.0724
614: , p5_a27 NUMBER := 0-1962.0724
615: , p5_a28 NUMBER := 0-1962.0724
616: , p5_a29 DATE := fnd_api.g_miss_date
612: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a26 NUMBER := 0-1962.0724
614: , p5_a27 NUMBER := 0-1962.0724
615: , p5_a28 NUMBER := 0-1962.0724
616: , p5_a29 DATE := fnd_api.g_miss_date
617: , p5_a30 NUMBER := 0-1962.0724
618: , p5_a31 DATE := fnd_api.g_miss_date
619: , p5_a32 NUMBER := 0-1962.0724
620: )
614: , p5_a27 NUMBER := 0-1962.0724
615: , p5_a28 NUMBER := 0-1962.0724
616: , p5_a29 DATE := fnd_api.g_miss_date
617: , p5_a30 NUMBER := 0-1962.0724
618: , p5_a31 DATE := fnd_api.g_miss_date
619: , p5_a32 NUMBER := 0-1962.0724
620: )
621:
622: as
897: , x_msg_data out nocopy VARCHAR2
898: , p5_a0 NUMBER := 0-1962.0724
899: , p5_a1 NUMBER := 0-1962.0724
900: , p5_a2 NUMBER := 0-1962.0724
901: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a4 NUMBER := 0-1962.0724
903: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a6 NUMBER := 0-1962.0724
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
899: , p5_a1 NUMBER := 0-1962.0724
900: , p5_a2 NUMBER := 0-1962.0724
901: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a4 NUMBER := 0-1962.0724
903: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a6 NUMBER := 0-1962.0724
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
901: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
902: , p5_a4 NUMBER := 0-1962.0724
903: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a6 NUMBER := 0-1962.0724
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
903: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a6 NUMBER := 0-1962.0724
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
904: , p5_a6 NUMBER := 0-1962.0724
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
905: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
906: , p5_a8 NUMBER := 0-1962.0724
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
907: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
908: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
909: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
910: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
911: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
912: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
913: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
914: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
915: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
916: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a26 NUMBER := 0-1962.0724
917: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a26 NUMBER := 0-1962.0724
925: , p5_a27 NUMBER := 0-1962.0724
918: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a26 NUMBER := 0-1962.0724
925: , p5_a27 NUMBER := 0-1962.0724
926: , p5_a28 NUMBER := 0-1962.0724
919: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
920: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
921: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
922: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a26 NUMBER := 0-1962.0724
925: , p5_a27 NUMBER := 0-1962.0724
926: , p5_a28 NUMBER := 0-1962.0724
927: , p5_a29 DATE := fnd_api.g_miss_date
923: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
924: , p5_a26 NUMBER := 0-1962.0724
925: , p5_a27 NUMBER := 0-1962.0724
926: , p5_a28 NUMBER := 0-1962.0724
927: , p5_a29 DATE := fnd_api.g_miss_date
928: , p5_a30 NUMBER := 0-1962.0724
929: , p5_a31 DATE := fnd_api.g_miss_date
930: , p5_a32 NUMBER := 0-1962.0724
931: )
925: , p5_a27 NUMBER := 0-1962.0724
926: , p5_a28 NUMBER := 0-1962.0724
927: , p5_a29 DATE := fnd_api.g_miss_date
928: , p5_a30 NUMBER := 0-1962.0724
929: , p5_a31 DATE := fnd_api.g_miss_date
930: , p5_a32 NUMBER := 0-1962.0724
931: )
932:
933: as
1133: , p6_a32 out nocopy NUMBER
1134: , p5_a0 NUMBER := 0-1962.0724
1135: , p5_a1 NUMBER := 0-1962.0724
1136: , p5_a2 NUMBER := 0-1962.0724
1137: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a4 NUMBER := 0-1962.0724
1139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a6 NUMBER := 0-1962.0724
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1135: , p5_a1 NUMBER := 0-1962.0724
1136: , p5_a2 NUMBER := 0-1962.0724
1137: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a4 NUMBER := 0-1962.0724
1139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a6 NUMBER := 0-1962.0724
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1137: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1138: , p5_a4 NUMBER := 0-1962.0724
1139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a6 NUMBER := 0-1962.0724
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a6 NUMBER := 0-1962.0724
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1140: , p5_a6 NUMBER := 0-1962.0724
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1142: , p5_a8 NUMBER := 0-1962.0724
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1143: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1144: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1145: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1148: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1149: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1150: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1151: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a26 NUMBER := 0-1962.0724
1153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a26 NUMBER := 0-1962.0724
1161: , p5_a27 NUMBER := 0-1962.0724
1154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a26 NUMBER := 0-1962.0724
1161: , p5_a27 NUMBER := 0-1962.0724
1162: , p5_a28 NUMBER := 0-1962.0724
1155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a26 NUMBER := 0-1962.0724
1161: , p5_a27 NUMBER := 0-1962.0724
1162: , p5_a28 NUMBER := 0-1962.0724
1163: , p5_a29 DATE := fnd_api.g_miss_date
1159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1160: , p5_a26 NUMBER := 0-1962.0724
1161: , p5_a27 NUMBER := 0-1962.0724
1162: , p5_a28 NUMBER := 0-1962.0724
1163: , p5_a29 DATE := fnd_api.g_miss_date
1164: , p5_a30 NUMBER := 0-1962.0724
1165: , p5_a31 DATE := fnd_api.g_miss_date
1166: , p5_a32 NUMBER := 0-1962.0724
1167: )
1161: , p5_a27 NUMBER := 0-1962.0724
1162: , p5_a28 NUMBER := 0-1962.0724
1163: , p5_a29 DATE := fnd_api.g_miss_date
1164: , p5_a30 NUMBER := 0-1962.0724
1165: , p5_a31 DATE := fnd_api.g_miss_date
1166: , p5_a32 NUMBER := 0-1962.0724
1167: )
1168:
1169: as
1444: , x_msg_data out nocopy VARCHAR2
1445: , p5_a0 NUMBER := 0-1962.0724
1446: , p5_a1 NUMBER := 0-1962.0724
1447: , p5_a2 NUMBER := 0-1962.0724
1448: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a4 NUMBER := 0-1962.0724
1450: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1446: , p5_a1 NUMBER := 0-1962.0724
1447: , p5_a2 NUMBER := 0-1962.0724
1448: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a4 NUMBER := 0-1962.0724
1450: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1448: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1449: , p5_a4 NUMBER := 0-1962.0724
1450: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1450: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1451: , p5_a6 NUMBER := 0-1962.0724
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1452: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1453: , p5_a8 NUMBER := 0-1962.0724
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1454: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1455: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1456: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1457: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1458: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1459: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1460: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1461: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1462: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1463: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a26 NUMBER := 0-1962.0724
1464: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a26 NUMBER := 0-1962.0724
1472: , p5_a27 NUMBER := 0-1962.0724
1465: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a26 NUMBER := 0-1962.0724
1472: , p5_a27 NUMBER := 0-1962.0724
1473: , p5_a28 NUMBER := 0-1962.0724
1466: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1467: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1468: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1469: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a26 NUMBER := 0-1962.0724
1472: , p5_a27 NUMBER := 0-1962.0724
1473: , p5_a28 NUMBER := 0-1962.0724
1474: , p5_a29 DATE := fnd_api.g_miss_date
1470: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1471: , p5_a26 NUMBER := 0-1962.0724
1472: , p5_a27 NUMBER := 0-1962.0724
1473: , p5_a28 NUMBER := 0-1962.0724
1474: , p5_a29 DATE := fnd_api.g_miss_date
1475: , p5_a30 NUMBER := 0-1962.0724
1476: , p5_a31 DATE := fnd_api.g_miss_date
1477: , p5_a32 NUMBER := 0-1962.0724
1478: )
1472: , p5_a27 NUMBER := 0-1962.0724
1473: , p5_a28 NUMBER := 0-1962.0724
1474: , p5_a29 DATE := fnd_api.g_miss_date
1475: , p5_a30 NUMBER := 0-1962.0724
1476: , p5_a31 DATE := fnd_api.g_miss_date
1477: , p5_a32 NUMBER := 0-1962.0724
1478: )
1479:
1480: as
1647: , x_msg_data out nocopy VARCHAR2
1648: , p5_a0 NUMBER := 0-1962.0724
1649: , p5_a1 NUMBER := 0-1962.0724
1650: , p5_a2 NUMBER := 0-1962.0724
1651: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a4 NUMBER := 0-1962.0724
1653: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a6 NUMBER := 0-1962.0724
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1649: , p5_a1 NUMBER := 0-1962.0724
1650: , p5_a2 NUMBER := 0-1962.0724
1651: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a4 NUMBER := 0-1962.0724
1653: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a6 NUMBER := 0-1962.0724
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1651: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1652: , p5_a4 NUMBER := 0-1962.0724
1653: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a6 NUMBER := 0-1962.0724
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1653: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a6 NUMBER := 0-1962.0724
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1654: , p5_a6 NUMBER := 0-1962.0724
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1655: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1656: , p5_a8 NUMBER := 0-1962.0724
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1657: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1658: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1659: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1660: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1661: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1662: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1663: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1664: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1665: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1666: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a26 NUMBER := 0-1962.0724
1667: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a26 NUMBER := 0-1962.0724
1675: , p5_a27 NUMBER := 0-1962.0724
1668: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a26 NUMBER := 0-1962.0724
1675: , p5_a27 NUMBER := 0-1962.0724
1676: , p5_a28 NUMBER := 0-1962.0724
1669: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1670: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1671: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1672: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a26 NUMBER := 0-1962.0724
1675: , p5_a27 NUMBER := 0-1962.0724
1676: , p5_a28 NUMBER := 0-1962.0724
1677: , p5_a29 DATE := fnd_api.g_miss_date
1673: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1674: , p5_a26 NUMBER := 0-1962.0724
1675: , p5_a27 NUMBER := 0-1962.0724
1676: , p5_a28 NUMBER := 0-1962.0724
1677: , p5_a29 DATE := fnd_api.g_miss_date
1678: , p5_a30 NUMBER := 0-1962.0724
1679: , p5_a31 DATE := fnd_api.g_miss_date
1680: , p5_a32 NUMBER := 0-1962.0724
1681: )
1675: , p5_a27 NUMBER := 0-1962.0724
1676: , p5_a28 NUMBER := 0-1962.0724
1677: , p5_a29 DATE := fnd_api.g_miss_date
1678: , p5_a30 NUMBER := 0-1962.0724
1679: , p5_a31 DATE := fnd_api.g_miss_date
1680: , p5_a32 NUMBER := 0-1962.0724
1681: )
1682:
1683: as