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;
116: , p6_a4 out nocopy VARCHAR2
117: , p6_a5 out nocopy VARCHAR2
118: , p6_a6 out nocopy DATE
119: , p5_a0 NUMBER := 0-1962.0724
120: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a3 NUMBER := 0-1962.0724
123: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
117: , p6_a5 out nocopy VARCHAR2
118: , p6_a6 out nocopy DATE
119: , p5_a0 NUMBER := 0-1962.0724
120: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a3 NUMBER := 0-1962.0724
123: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a6 DATE := fnd_api.g_miss_date
119: , p5_a0 NUMBER := 0-1962.0724
120: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a3 NUMBER := 0-1962.0724
123: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a6 DATE := fnd_api.g_miss_date
126: )
127:
120: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a3 NUMBER := 0-1962.0724
123: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a6 DATE := fnd_api.g_miss_date
126: )
127:
128: as
121: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a3 NUMBER := 0-1962.0724
123: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
124: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a6 DATE := fnd_api.g_miss_date
126: )
127:
128: as
129: ddp_recy_rec okl_am_recycle_trmnt_pvt.recy_rec_type;