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;
40: , p6_a13 out nocopy NUMBER
41: , p5_a0 NUMBER := 0-1962.0724
42: , p5_a1 NUMBER := 0-1962.0724
43: , p5_a2 NUMBER := 0-1962.0724
44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
41: , p5_a0 NUMBER := 0-1962.0724
42: , p5_a1 NUMBER := 0-1962.0724
43: , p5_a2 NUMBER := 0-1962.0724
44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
42: , p5_a1 NUMBER := 0-1962.0724
43: , p5_a2 NUMBER := 0-1962.0724
44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
43: , p5_a2 NUMBER := 0-1962.0724
44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
44: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
45: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
46: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date
47: , p5_a6 DATE := fnd_api.g_miss_date
48: , p5_a7 DATE := fnd_api.g_miss_date
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date
54: , p5_a13 NUMBER := 0-1962.0724
55: )
49: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
50: , p5_a9 NUMBER := 0-1962.0724
51: , p5_a10 DATE := fnd_api.g_miss_date
52: , p5_a11 NUMBER := 0-1962.0724
53: , p5_a12 DATE := fnd_api.g_miss_date
54: , p5_a13 NUMBER := 0-1962.0724
55: )
56:
57: as
218: , x_msg_data out nocopy VARCHAR2
219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
222: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
225: , p5_a6 DATE := fnd_api.g_miss_date
226: , p5_a7 DATE := fnd_api.g_miss_date
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: )
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: )
234:
235: as
359: , p6_a13 out nocopy NUMBER
360: , p5_a0 NUMBER := 0-1962.0724
361: , p5_a1 NUMBER := 0-1962.0724
362: , p5_a2 NUMBER := 0-1962.0724
363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
360: , p5_a0 NUMBER := 0-1962.0724
361: , p5_a1 NUMBER := 0-1962.0724
362: , p5_a2 NUMBER := 0-1962.0724
363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
361: , p5_a1 NUMBER := 0-1962.0724
362: , p5_a2 NUMBER := 0-1962.0724
363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
362: , p5_a2 NUMBER := 0-1962.0724
363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
363: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
364: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date
366: , p5_a6 DATE := fnd_api.g_miss_date
367: , p5_a7 DATE := fnd_api.g_miss_date
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date
373: , p5_a13 NUMBER := 0-1962.0724
374: )
368: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
369: , p5_a9 NUMBER := 0-1962.0724
370: , p5_a10 DATE := fnd_api.g_miss_date
371: , p5_a11 NUMBER := 0-1962.0724
372: , p5_a12 DATE := fnd_api.g_miss_date
373: , p5_a13 NUMBER := 0-1962.0724
374: )
375:
376: as
537: , x_msg_data out nocopy VARCHAR2
538: , p5_a0 NUMBER := 0-1962.0724
539: , p5_a1 NUMBER := 0-1962.0724
540: , p5_a2 NUMBER := 0-1962.0724
541: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
538: , p5_a0 NUMBER := 0-1962.0724
539: , p5_a1 NUMBER := 0-1962.0724
540: , p5_a2 NUMBER := 0-1962.0724
541: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
539: , p5_a1 NUMBER := 0-1962.0724
540: , p5_a2 NUMBER := 0-1962.0724
541: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
540: , p5_a2 NUMBER := 0-1962.0724
541: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
541: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
542: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
543: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date
544: , p5_a6 DATE := fnd_api.g_miss_date
545: , p5_a7 DATE := fnd_api.g_miss_date
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date
551: , p5_a13 NUMBER := 0-1962.0724
552: )
546: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
547: , p5_a9 NUMBER := 0-1962.0724
548: , p5_a10 DATE := fnd_api.g_miss_date
549: , p5_a11 NUMBER := 0-1962.0724
550: , p5_a12 DATE := fnd_api.g_miss_date
551: , p5_a13 NUMBER := 0-1962.0724
552: )
553:
554: as
664: , x_msg_data out nocopy VARCHAR2
665: , p5_a0 NUMBER := 0-1962.0724
666: , p5_a1 NUMBER := 0-1962.0724
667: , p5_a2 NUMBER := 0-1962.0724
668: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
665: , p5_a0 NUMBER := 0-1962.0724
666: , p5_a1 NUMBER := 0-1962.0724
667: , p5_a2 NUMBER := 0-1962.0724
668: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a1 NUMBER := 0-1962.0724
667: , p5_a2 NUMBER := 0-1962.0724
668: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
667: , p5_a2 NUMBER := 0-1962.0724
668: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
668: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
669: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date
671: , p5_a6 DATE := fnd_api.g_miss_date
672: , p5_a7 DATE := fnd_api.g_miss_date
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date
678: , p5_a13 NUMBER := 0-1962.0724
679: )
673: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
674: , p5_a9 NUMBER := 0-1962.0724
675: , p5_a10 DATE := fnd_api.g_miss_date
676: , p5_a11 NUMBER := 0-1962.0724
677: , p5_a12 DATE := fnd_api.g_miss_date
678: , p5_a13 NUMBER := 0-1962.0724
679: )
680:
681: as