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;
308: , p6_a13 out nocopy NUMBER
309: , p5_a0 NUMBER := 0-1962.0724
310: , p5_a1 NUMBER := 0-1962.0724
311: , p5_a2 NUMBER := 0-1962.0724
312: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
313: , p5_a4 NUMBER := 0-1962.0724
314: , p5_a5 NUMBER := 0-1962.0724
315: , p5_a6 NUMBER := 0-1962.0724
316: , p5_a7 NUMBER := 0-1962.0724
316: , p5_a7 NUMBER := 0-1962.0724
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 NUMBER := 0-1962.0724
319: , p5_a10 NUMBER := 0-1962.0724
320: , p5_a11 DATE := fnd_api.g_miss_date
321: , p5_a12 DATE := fnd_api.g_miss_date
322: , p5_a13 NUMBER := 0-1962.0724
323: )
324:
317: , p5_a8 NUMBER := 0-1962.0724
318: , p5_a9 NUMBER := 0-1962.0724
319: , p5_a10 NUMBER := 0-1962.0724
320: , p5_a11 DATE := fnd_api.g_miss_date
321: , p5_a12 DATE := fnd_api.g_miss_date
322: , p5_a13 NUMBER := 0-1962.0724
323: )
324:
325: as
486: , x_msg_data out nocopy VARCHAR2
487: , p5_a0 NUMBER := 0-1962.0724
488: , p5_a1 NUMBER := 0-1962.0724
489: , p5_a2 NUMBER := 0-1962.0724
490: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a4 NUMBER := 0-1962.0724
492: , p5_a5 NUMBER := 0-1962.0724
493: , p5_a6 NUMBER := 0-1962.0724
494: , p5_a7 NUMBER := 0-1962.0724
494: , p5_a7 NUMBER := 0-1962.0724
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 NUMBER := 0-1962.0724
497: , p5_a10 NUMBER := 0-1962.0724
498: , p5_a11 DATE := fnd_api.g_miss_date
499: , p5_a12 DATE := fnd_api.g_miss_date
500: , p5_a13 NUMBER := 0-1962.0724
501: )
502:
495: , p5_a8 NUMBER := 0-1962.0724
496: , p5_a9 NUMBER := 0-1962.0724
497: , p5_a10 NUMBER := 0-1962.0724
498: , p5_a11 DATE := fnd_api.g_miss_date
499: , p5_a12 DATE := fnd_api.g_miss_date
500: , p5_a13 NUMBER := 0-1962.0724
501: )
502:
503: as
627: , p6_a13 out nocopy NUMBER
628: , p5_a0 NUMBER := 0-1962.0724
629: , p5_a1 NUMBER := 0-1962.0724
630: , p5_a2 NUMBER := 0-1962.0724
631: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
632: , p5_a4 NUMBER := 0-1962.0724
633: , p5_a5 NUMBER := 0-1962.0724
634: , p5_a6 NUMBER := 0-1962.0724
635: , p5_a7 NUMBER := 0-1962.0724
635: , p5_a7 NUMBER := 0-1962.0724
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 NUMBER := 0-1962.0724
638: , p5_a10 NUMBER := 0-1962.0724
639: , p5_a11 DATE := fnd_api.g_miss_date
640: , p5_a12 DATE := fnd_api.g_miss_date
641: , p5_a13 NUMBER := 0-1962.0724
642: )
643:
636: , p5_a8 NUMBER := 0-1962.0724
637: , p5_a9 NUMBER := 0-1962.0724
638: , p5_a10 NUMBER := 0-1962.0724
639: , p5_a11 DATE := fnd_api.g_miss_date
640: , p5_a12 DATE := fnd_api.g_miss_date
641: , p5_a13 NUMBER := 0-1962.0724
642: )
643:
644: as
805: , x_msg_data out nocopy VARCHAR2
806: , p5_a0 NUMBER := 0-1962.0724
807: , p5_a1 NUMBER := 0-1962.0724
808: , p5_a2 NUMBER := 0-1962.0724
809: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
810: , p5_a4 NUMBER := 0-1962.0724
811: , p5_a5 NUMBER := 0-1962.0724
812: , p5_a6 NUMBER := 0-1962.0724
813: , p5_a7 NUMBER := 0-1962.0724
813: , p5_a7 NUMBER := 0-1962.0724
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 NUMBER := 0-1962.0724
816: , p5_a10 NUMBER := 0-1962.0724
817: , p5_a11 DATE := fnd_api.g_miss_date
818: , p5_a12 DATE := fnd_api.g_miss_date
819: , p5_a13 NUMBER := 0-1962.0724
820: )
821:
814: , p5_a8 NUMBER := 0-1962.0724
815: , p5_a9 NUMBER := 0-1962.0724
816: , p5_a10 NUMBER := 0-1962.0724
817: , p5_a11 DATE := fnd_api.g_miss_date
818: , p5_a12 DATE := fnd_api.g_miss_date
819: , p5_a13 NUMBER := 0-1962.0724
820: )
821:
822: as
932: , x_msg_data out nocopy VARCHAR2
933: , p5_a0 NUMBER := 0-1962.0724
934: , p5_a1 NUMBER := 0-1962.0724
935: , p5_a2 NUMBER := 0-1962.0724
936: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
937: , p5_a4 NUMBER := 0-1962.0724
938: , p5_a5 NUMBER := 0-1962.0724
939: , p5_a6 NUMBER := 0-1962.0724
940: , p5_a7 NUMBER := 0-1962.0724
940: , p5_a7 NUMBER := 0-1962.0724
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 NUMBER := 0-1962.0724
943: , p5_a10 NUMBER := 0-1962.0724
944: , p5_a11 DATE := fnd_api.g_miss_date
945: , p5_a12 DATE := fnd_api.g_miss_date
946: , p5_a13 NUMBER := 0-1962.0724
947: )
948:
941: , p5_a8 NUMBER := 0-1962.0724
942: , p5_a9 NUMBER := 0-1962.0724
943: , p5_a10 NUMBER := 0-1962.0724
944: , p5_a11 DATE := fnd_api.g_miss_date
945: , p5_a12 DATE := fnd_api.g_miss_date
946: , p5_a13 NUMBER := 0-1962.0724
947: )
948:
949: as