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;
132: , x_return_status out nocopy VARCHAR2
133: , x_msg_count out nocopy NUMBER
134: , x_msg_data out nocopy VARCHAR2
135: , p9_a0 NUMBER := 0-1962.0724
136: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
137: , p9_a2 NUMBER := 0-1962.0724
138: , p9_a3 DATE := fnd_api.g_miss_date
139: , p9_a4 NUMBER := 0-1962.0724
140: , p9_a5 NUMBER := 0-1962.0724
134: , x_msg_data out nocopy VARCHAR2
135: , p9_a0 NUMBER := 0-1962.0724
136: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
137: , p9_a2 NUMBER := 0-1962.0724
138: , p9_a3 DATE := fnd_api.g_miss_date
139: , p9_a4 NUMBER := 0-1962.0724
140: , p9_a5 NUMBER := 0-1962.0724
141: , p9_a6 DATE := fnd_api.g_miss_date
142: , p9_a7 NUMBER := 0-1962.0724
137: , p9_a2 NUMBER := 0-1962.0724
138: , p9_a3 DATE := fnd_api.g_miss_date
139: , p9_a4 NUMBER := 0-1962.0724
140: , p9_a5 NUMBER := 0-1962.0724
141: , p9_a6 DATE := fnd_api.g_miss_date
142: , p9_a7 NUMBER := 0-1962.0724
143: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
144: )
145:
139: , p9_a4 NUMBER := 0-1962.0724
140: , p9_a5 NUMBER := 0-1962.0724
141: , p9_a6 DATE := fnd_api.g_miss_date
142: , p9_a7 NUMBER := 0-1962.0724
143: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
144: )
145:
146: as
147: ddp_profile_tbl as_utility_pub.profile_tbl_type;
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p9_a0 NUMBER := 0-1962.0724
225: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
226: , p9_a2 NUMBER := 0-1962.0724
227: , p9_a3 DATE := fnd_api.g_miss_date
228: , p9_a4 NUMBER := 0-1962.0724
229: , p9_a5 NUMBER := 0-1962.0724
223: , x_msg_data out nocopy VARCHAR2
224: , p9_a0 NUMBER := 0-1962.0724
225: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
226: , p9_a2 NUMBER := 0-1962.0724
227: , p9_a3 DATE := fnd_api.g_miss_date
228: , p9_a4 NUMBER := 0-1962.0724
229: , p9_a5 NUMBER := 0-1962.0724
230: , p9_a6 DATE := fnd_api.g_miss_date
231: , p9_a7 NUMBER := 0-1962.0724
226: , p9_a2 NUMBER := 0-1962.0724
227: , p9_a3 DATE := fnd_api.g_miss_date
228: , p9_a4 NUMBER := 0-1962.0724
229: , p9_a5 NUMBER := 0-1962.0724
230: , p9_a6 DATE := fnd_api.g_miss_date
231: , p9_a7 NUMBER := 0-1962.0724
232: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
233: )
234:
228: , p9_a4 NUMBER := 0-1962.0724
229: , p9_a5 NUMBER := 0-1962.0724
230: , p9_a6 DATE := fnd_api.g_miss_date
231: , p9_a7 NUMBER := 0-1962.0724
232: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
233: )
234:
235: as
236: ddp_profile_tbl as_utility_pub.profile_tbl_type;
307: , x_return_status out nocopy VARCHAR2
308: , x_msg_count out nocopy NUMBER
309: , x_msg_data out nocopy VARCHAR2
310: , p9_a0 NUMBER := 0-1962.0724
311: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
312: , p9_a2 NUMBER := 0-1962.0724
313: , p9_a3 DATE := fnd_api.g_miss_date
314: , p9_a4 NUMBER := 0-1962.0724
315: , p9_a5 NUMBER := 0-1962.0724
309: , x_msg_data out nocopy VARCHAR2
310: , p9_a0 NUMBER := 0-1962.0724
311: , p9_a1 VARCHAR2 := fnd_api.g_miss_char
312: , p9_a2 NUMBER := 0-1962.0724
313: , p9_a3 DATE := fnd_api.g_miss_date
314: , p9_a4 NUMBER := 0-1962.0724
315: , p9_a5 NUMBER := 0-1962.0724
316: , p9_a6 DATE := fnd_api.g_miss_date
317: , p9_a7 NUMBER := 0-1962.0724
312: , p9_a2 NUMBER := 0-1962.0724
313: , p9_a3 DATE := fnd_api.g_miss_date
314: , p9_a4 NUMBER := 0-1962.0724
315: , p9_a5 NUMBER := 0-1962.0724
316: , p9_a6 DATE := fnd_api.g_miss_date
317: , p9_a7 NUMBER := 0-1962.0724
318: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
319: )
320:
314: , p9_a4 NUMBER := 0-1962.0724
315: , p9_a5 NUMBER := 0-1962.0724
316: , p9_a6 DATE := fnd_api.g_miss_date
317: , p9_a7 NUMBER := 0-1962.0724
318: , p9_a8 VARCHAR2 := fnd_api.g_miss_char
319: )
320:
321: as
322: ddp_profile_tbl as_utility_pub.profile_tbl_type;