7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
370: , p6_a16 out nocopy DATE
371: , p6_a17 out nocopy NUMBER
372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
371: , p6_a17 out nocopy NUMBER
372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a0 NUMBER := 0-1962.0724
373: , p5_a1 NUMBER := 0-1962.0724
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
374: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
375: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
376: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
377: , p5_a5 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
378: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
379: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
380: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
381: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724
382: , p5_a10 DATE := fnd_api.g_miss_date
383: , p5_a11 DATE := fnd_api.g_miss_date
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724
388: , p5_a16 DATE := fnd_api.g_miss_date
389: , p5_a17 NUMBER := 0-1962.0724
390: )
384: , p5_a12 NUMBER := 0-1962.0724
385: , p5_a13 NUMBER := 0-1962.0724
386: , p5_a14 DATE := fnd_api.g_miss_date
387: , p5_a15 NUMBER := 0-1962.0724
388: , p5_a16 DATE := fnd_api.g_miss_date
389: , p5_a17 NUMBER := 0-1962.0724
390: )
391:
392: as
576: , x_msg_count out nocopy NUMBER
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
577: , x_msg_data out nocopy VARCHAR2
578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a0 NUMBER := 0-1962.0724
579: , p5_a1 NUMBER := 0-1962.0724
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
580: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
581: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
582: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
583: , p5_a5 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
584: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
585: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
587: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724
588: , p5_a10 DATE := fnd_api.g_miss_date
589: , p5_a11 DATE := fnd_api.g_miss_date
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724
594: , p5_a16 DATE := fnd_api.g_miss_date
595: , p5_a17 NUMBER := 0-1962.0724
596: )
590: , p5_a12 NUMBER := 0-1962.0724
591: , p5_a13 NUMBER := 0-1962.0724
592: , p5_a14 DATE := fnd_api.g_miss_date
593: , p5_a15 NUMBER := 0-1962.0724
594: , p5_a16 DATE := fnd_api.g_miss_date
595: , p5_a17 NUMBER := 0-1962.0724
596: )
597:
598: as
737: , p6_a16 out nocopy DATE
738: , p6_a17 out nocopy NUMBER
739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
738: , p6_a17 out nocopy NUMBER
739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
739: , p5_a0 NUMBER := 0-1962.0724
740: , p5_a1 NUMBER := 0-1962.0724
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
742: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
743: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
744: , p5_a5 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
745: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
746: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
747: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
748: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724
749: , p5_a10 DATE := fnd_api.g_miss_date
750: , p5_a11 DATE := fnd_api.g_miss_date
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724
755: , p5_a16 DATE := fnd_api.g_miss_date
756: , p5_a17 NUMBER := 0-1962.0724
757: )
751: , p5_a12 NUMBER := 0-1962.0724
752: , p5_a13 NUMBER := 0-1962.0724
753: , p5_a14 DATE := fnd_api.g_miss_date
754: , p5_a15 NUMBER := 0-1962.0724
755: , p5_a16 DATE := fnd_api.g_miss_date
756: , p5_a17 NUMBER := 0-1962.0724
757: )
758:
759: as
943: , x_msg_count out nocopy NUMBER
944: , x_msg_data out nocopy VARCHAR2
945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
944: , x_msg_data out nocopy VARCHAR2
945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
945: , p5_a0 NUMBER := 0-1962.0724
946: , p5_a1 NUMBER := 0-1962.0724
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
947: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
948: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
949: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
950: , p5_a5 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
951: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
952: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
953: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
954: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724
955: , p5_a10 DATE := fnd_api.g_miss_date
956: , p5_a11 DATE := fnd_api.g_miss_date
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724
961: , p5_a16 DATE := fnd_api.g_miss_date
962: , p5_a17 NUMBER := 0-1962.0724
963: )
957: , p5_a12 NUMBER := 0-1962.0724
958: , p5_a13 NUMBER := 0-1962.0724
959: , p5_a14 DATE := fnd_api.g_miss_date
960: , p5_a15 NUMBER := 0-1962.0724
961: , p5_a16 DATE := fnd_api.g_miss_date
962: , p5_a17 NUMBER := 0-1962.0724
963: )
964:
965: as
1086: , x_msg_count out nocopy NUMBER
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1087: , x_msg_data out nocopy VARCHAR2
1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1088: , p5_a0 NUMBER := 0-1962.0724
1089: , p5_a1 NUMBER := 0-1962.0724
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1090: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1091: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1092: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1093: , p5_a5 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1094: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1095: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1096: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1097: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724
1098: , p5_a10 DATE := fnd_api.g_miss_date
1099: , p5_a11 DATE := fnd_api.g_miss_date
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724
1104: , p5_a16 DATE := fnd_api.g_miss_date
1105: , p5_a17 NUMBER := 0-1962.0724
1106: )
1100: , p5_a12 NUMBER := 0-1962.0724
1101: , p5_a13 NUMBER := 0-1962.0724
1102: , p5_a14 DATE := fnd_api.g_miss_date
1103: , p5_a15 NUMBER := 0-1962.0724
1104: , p5_a16 DATE := fnd_api.g_miss_date
1105: , p5_a17 NUMBER := 0-1962.0724
1106: )
1107:
1108: as