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;
89: , x_msg_count out nocopy NUMBER
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 NUMBER := 0-1962.0724
92: , p5_a1 NUMBER := 0-1962.0724
93: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
90: , x_msg_data out nocopy VARCHAR2
91: , p5_a0 NUMBER := 0-1962.0724
92: , p5_a1 NUMBER := 0-1962.0724
93: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
91: , p5_a0 NUMBER := 0-1962.0724
92: , p5_a1 NUMBER := 0-1962.0724
93: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a1 NUMBER := 0-1962.0724
93: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
94: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
95: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
96: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
97: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
98: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
99: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
100: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
101: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
102: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
103: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
104: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
105: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p5_a22 NUMBER := 0-1962.0724
106: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p5_a22 NUMBER := 0-1962.0724
114: , p5_a23 NUMBER := 0-1962.0724
107: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p5_a22 NUMBER := 0-1962.0724
114: , p5_a23 NUMBER := 0-1962.0724
115: , p5_a24 NUMBER := 0-1962.0724
108: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
109: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
110: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
111: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p5_a22 NUMBER := 0-1962.0724
114: , p5_a23 NUMBER := 0-1962.0724
115: , p5_a24 NUMBER := 0-1962.0724
116: , p5_a25 DATE := fnd_api.g_miss_date
112: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
113: , p5_a22 NUMBER := 0-1962.0724
114: , p5_a23 NUMBER := 0-1962.0724
115: , p5_a24 NUMBER := 0-1962.0724
116: , p5_a25 DATE := fnd_api.g_miss_date
117: , p5_a26 NUMBER := 0-1962.0724
118: , p5_a27 DATE := fnd_api.g_miss_date
119: , p5_a28 NUMBER := 0-1962.0724
120: , p5_a29 DATE := fnd_api.g_miss_date
114: , p5_a23 NUMBER := 0-1962.0724
115: , p5_a24 NUMBER := 0-1962.0724
116: , p5_a25 DATE := fnd_api.g_miss_date
117: , p5_a26 NUMBER := 0-1962.0724
118: , p5_a27 DATE := fnd_api.g_miss_date
119: , p5_a28 NUMBER := 0-1962.0724
120: , p5_a29 DATE := fnd_api.g_miss_date
121: , p5_a30 NUMBER := 0-1962.0724
122: )
116: , p5_a25 DATE := fnd_api.g_miss_date
117: , p5_a26 NUMBER := 0-1962.0724
118: , p5_a27 DATE := fnd_api.g_miss_date
119: , p5_a28 NUMBER := 0-1962.0724
120: , p5_a29 DATE := fnd_api.g_miss_date
121: , p5_a30 NUMBER := 0-1962.0724
122: )
123:
124: as
286: , p5_a0 NUMBER := 0-1962.0724
287: , p5_a1 NUMBER := 0-1962.0724
288: , p5_a2 NUMBER := 0-1962.0724
289: , p5_a3 NUMBER := 0-1962.0724
290: , p5_a4 DATE := fnd_api.g_miss_date
291: , p5_a5 DATE := fnd_api.g_miss_date
292: , p5_a6 NUMBER := 0-1962.0724
293: , p5_a7 NUMBER := 0-1962.0724
294: , p5_a8 NUMBER := 0-1962.0724
287: , p5_a1 NUMBER := 0-1962.0724
288: , p5_a2 NUMBER := 0-1962.0724
289: , p5_a3 NUMBER := 0-1962.0724
290: , p5_a4 DATE := fnd_api.g_miss_date
291: , p5_a5 DATE := fnd_api.g_miss_date
292: , p5_a6 NUMBER := 0-1962.0724
293: , p5_a7 NUMBER := 0-1962.0724
294: , p5_a8 NUMBER := 0-1962.0724
295: , p5_a9 DATE := fnd_api.g_miss_date
291: , p5_a5 DATE := fnd_api.g_miss_date
292: , p5_a6 NUMBER := 0-1962.0724
293: , p5_a7 NUMBER := 0-1962.0724
294: , p5_a8 NUMBER := 0-1962.0724
295: , p5_a9 DATE := fnd_api.g_miss_date
296: , p5_a10 NUMBER := 0-1962.0724
297: , p5_a11 DATE := fnd_api.g_miss_date
298: , p5_a12 NUMBER := 0-1962.0724
299: , p5_a13 DATE := fnd_api.g_miss_date
293: , p5_a7 NUMBER := 0-1962.0724
294: , p5_a8 NUMBER := 0-1962.0724
295: , p5_a9 DATE := fnd_api.g_miss_date
296: , p5_a10 NUMBER := 0-1962.0724
297: , p5_a11 DATE := fnd_api.g_miss_date
298: , p5_a12 NUMBER := 0-1962.0724
299: , p5_a13 DATE := fnd_api.g_miss_date
300: , p5_a14 NUMBER := 0-1962.0724
301: )
295: , p5_a9 DATE := fnd_api.g_miss_date
296: , p5_a10 NUMBER := 0-1962.0724
297: , p5_a11 DATE := fnd_api.g_miss_date
298: , p5_a12 NUMBER := 0-1962.0724
299: , p5_a13 DATE := fnd_api.g_miss_date
300: , p5_a14 NUMBER := 0-1962.0724
301: )
302:
303: as