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;
43: , p6_a16 out nocopy NUMBER
44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
44: , p5_a0 NUMBER := 0-1962.0724
45: , p5_a1 NUMBER := 0-1962.0724
46: , p5_a2 NUMBER := 0-1962.0724
47: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
49: , p5_a5 NUMBER := 0-1962.0724
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
50: , p5_a6 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
51: , p5_a7 NUMBER := 0-1962.0724
52: , p5_a8 NUMBER := 0-1962.0724
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
53: , p5_a9 DATE := fnd_api.g_miss_date
54: , p5_a10 DATE := fnd_api.g_miss_date
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )
55: , p5_a11 DATE := fnd_api.g_miss_date
56: , p5_a12 NUMBER := 0-1962.0724
57: , p5_a13 DATE := fnd_api.g_miss_date
58: , p5_a14 NUMBER := 0-1962.0724
59: , p5_a15 DATE := fnd_api.g_miss_date
60: , p5_a16 NUMBER := 0-1962.0724
61: )
62:
63: as
242: , x_msg_data out nocopy VARCHAR2
243: , p5_a0 NUMBER := 0-1962.0724
244: , p5_a1 NUMBER := 0-1962.0724
245: , p5_a2 NUMBER := 0-1962.0724
246: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
243: , p5_a0 NUMBER := 0-1962.0724
244: , p5_a1 NUMBER := 0-1962.0724
245: , p5_a2 NUMBER := 0-1962.0724
246: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
248: , p5_a5 NUMBER := 0-1962.0724
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
249: , p5_a6 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
250: , p5_a7 NUMBER := 0-1962.0724
251: , p5_a8 NUMBER := 0-1962.0724
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date
252: , p5_a9 DATE := fnd_api.g_miss_date
253: , p5_a10 DATE := fnd_api.g_miss_date
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date
259: , p5_a16 NUMBER := 0-1962.0724
260: )
254: , p5_a11 DATE := fnd_api.g_miss_date
255: , p5_a12 NUMBER := 0-1962.0724
256: , p5_a13 DATE := fnd_api.g_miss_date
257: , p5_a14 NUMBER := 0-1962.0724
258: , p5_a15 DATE := fnd_api.g_miss_date
259: , p5_a16 NUMBER := 0-1962.0724
260: )
261:
262: as
398: , p6_a16 out nocopy NUMBER
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 NUMBER := 0-1962.0724
401: , p5_a2 NUMBER := 0-1962.0724
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
399: , p5_a0 NUMBER := 0-1962.0724
400: , p5_a1 NUMBER := 0-1962.0724
401: , p5_a2 NUMBER := 0-1962.0724
402: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
404: , p5_a5 NUMBER := 0-1962.0724
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
405: , p5_a6 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
406: , p5_a7 NUMBER := 0-1962.0724
407: , p5_a8 NUMBER := 0-1962.0724
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date
408: , p5_a9 DATE := fnd_api.g_miss_date
409: , p5_a10 DATE := fnd_api.g_miss_date
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date
415: , p5_a16 NUMBER := 0-1962.0724
416: )
410: , p5_a11 DATE := fnd_api.g_miss_date
411: , p5_a12 NUMBER := 0-1962.0724
412: , p5_a13 DATE := fnd_api.g_miss_date
413: , p5_a14 NUMBER := 0-1962.0724
414: , p5_a15 DATE := fnd_api.g_miss_date
415: , p5_a16 NUMBER := 0-1962.0724
416: )
417:
418: as
597: , x_msg_data out nocopy VARCHAR2
598: , p5_a0 NUMBER := 0-1962.0724
599: , p5_a1 NUMBER := 0-1962.0724
600: , p5_a2 NUMBER := 0-1962.0724
601: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
598: , p5_a0 NUMBER := 0-1962.0724
599: , p5_a1 NUMBER := 0-1962.0724
600: , p5_a2 NUMBER := 0-1962.0724
601: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
603: , p5_a5 NUMBER := 0-1962.0724
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
604: , p5_a6 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
605: , p5_a7 NUMBER := 0-1962.0724
606: , p5_a8 NUMBER := 0-1962.0724
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date
607: , p5_a9 DATE := fnd_api.g_miss_date
608: , p5_a10 DATE := fnd_api.g_miss_date
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date
614: , p5_a16 NUMBER := 0-1962.0724
615: )
609: , p5_a11 DATE := fnd_api.g_miss_date
610: , p5_a12 NUMBER := 0-1962.0724
611: , p5_a13 DATE := fnd_api.g_miss_date
612: , p5_a14 NUMBER := 0-1962.0724
613: , p5_a15 DATE := fnd_api.g_miss_date
614: , p5_a16 NUMBER := 0-1962.0724
615: )
616:
617: as
736: , x_msg_data out nocopy VARCHAR2
737: , p5_a0 NUMBER := 0-1962.0724
738: , p5_a1 NUMBER := 0-1962.0724
739: , p5_a2 NUMBER := 0-1962.0724
740: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
737: , p5_a0 NUMBER := 0-1962.0724
738: , p5_a1 NUMBER := 0-1962.0724
739: , p5_a2 NUMBER := 0-1962.0724
740: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
741: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
742: , p5_a5 NUMBER := 0-1962.0724
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
743: , p5_a6 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
744: , p5_a7 NUMBER := 0-1962.0724
745: , p5_a8 NUMBER := 0-1962.0724
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date
746: , p5_a9 DATE := fnd_api.g_miss_date
747: , p5_a10 DATE := fnd_api.g_miss_date
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date
753: , p5_a16 NUMBER := 0-1962.0724
754: )
748: , p5_a11 DATE := fnd_api.g_miss_date
749: , p5_a12 NUMBER := 0-1962.0724
750: , p5_a13 DATE := fnd_api.g_miss_date
751: , p5_a14 NUMBER := 0-1962.0724
752: , p5_a15 DATE := fnd_api.g_miss_date
753: , p5_a16 NUMBER := 0-1962.0724
754: )
755:
756: as