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;
32: , p3_a8 out nocopy DATE
33: , p3_a9 out nocopy NUMBER
34: , p0_a0 NUMBER := 0-1962.0724
35: , p0_a1 NUMBER := 0-1962.0724
36: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
33: , p3_a9 out nocopy NUMBER
34: , p0_a0 NUMBER := 0-1962.0724
35: , p0_a1 NUMBER := 0-1962.0724
36: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
34: , p0_a0 NUMBER := 0-1962.0724
35: , p0_a1 NUMBER := 0-1962.0724
36: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
36: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
37: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
43: , p0_a9 NUMBER := 0-1962.0724
44: )
38: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
39: , p0_a5 NUMBER := 0-1962.0724
40: , p0_a6 DATE := fnd_api.g_miss_date
41: , p0_a7 NUMBER := 0-1962.0724
42: , p0_a8 DATE := fnd_api.g_miss_date
43: , p0_a9 NUMBER := 0-1962.0724
44: )
45:
46: as
109: , p6_a8 out nocopy DATE
110: , p6_a9 out nocopy NUMBER
111: , p5_a0 NUMBER := 0-1962.0724
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 NUMBER := 0-1962.0724
117: , p5_a6 DATE := fnd_api.g_miss_date
110: , p6_a9 out nocopy NUMBER
111: , p5_a0 NUMBER := 0-1962.0724
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 NUMBER := 0-1962.0724
117: , p5_a6 DATE := fnd_api.g_miss_date
118: , p5_a7 NUMBER := 0-1962.0724
111: , p5_a0 NUMBER := 0-1962.0724
112: , p5_a1 NUMBER := 0-1962.0724
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 NUMBER := 0-1962.0724
117: , p5_a6 DATE := fnd_api.g_miss_date
118: , p5_a7 NUMBER := 0-1962.0724
119: , p5_a8 DATE := fnd_api.g_miss_date
113: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 NUMBER := 0-1962.0724
117: , p5_a6 DATE := fnd_api.g_miss_date
118: , p5_a7 NUMBER := 0-1962.0724
119: , p5_a8 DATE := fnd_api.g_miss_date
120: , p5_a9 NUMBER := 0-1962.0724
121: )
115: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
116: , p5_a5 NUMBER := 0-1962.0724
117: , p5_a6 DATE := fnd_api.g_miss_date
118: , p5_a7 NUMBER := 0-1962.0724
119: , p5_a8 DATE := fnd_api.g_miss_date
120: , p5_a9 NUMBER := 0-1962.0724
121: )
122:
123: as
188: , p6_a8 out nocopy DATE
189: , p6_a9 out nocopy NUMBER
190: , p5_a0 NUMBER := 0-1962.0724
191: , p5_a1 NUMBER := 0-1962.0724
192: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a5 NUMBER := 0-1962.0724
196: , p5_a6 DATE := fnd_api.g_miss_date
189: , p6_a9 out nocopy NUMBER
190: , p5_a0 NUMBER := 0-1962.0724
191: , p5_a1 NUMBER := 0-1962.0724
192: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a5 NUMBER := 0-1962.0724
196: , p5_a6 DATE := fnd_api.g_miss_date
197: , p5_a7 NUMBER := 0-1962.0724
190: , p5_a0 NUMBER := 0-1962.0724
191: , p5_a1 NUMBER := 0-1962.0724
192: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a5 NUMBER := 0-1962.0724
196: , p5_a6 DATE := fnd_api.g_miss_date
197: , p5_a7 NUMBER := 0-1962.0724
198: , p5_a8 DATE := fnd_api.g_miss_date
192: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
193: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
194: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a5 NUMBER := 0-1962.0724
196: , p5_a6 DATE := fnd_api.g_miss_date
197: , p5_a7 NUMBER := 0-1962.0724
198: , p5_a8 DATE := fnd_api.g_miss_date
199: , p5_a9 NUMBER := 0-1962.0724
200: )
194: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
195: , p5_a5 NUMBER := 0-1962.0724
196: , p5_a6 DATE := fnd_api.g_miss_date
197: , p5_a7 NUMBER := 0-1962.0724
198: , p5_a8 DATE := fnd_api.g_miss_date
199: , p5_a9 NUMBER := 0-1962.0724
200: )
201:
202: as