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;
201: , x_cure_refund_header_id out nocopy NUMBER
202: , x_return_status out nocopy VARCHAR2
203: , x_msg_count out nocopy NUMBER
204: , x_msg_data out nocopy VARCHAR2
205: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
206: , p3_a1 NUMBER := 0-1962.0724
207: , p3_a2 NUMBER := 0-1962.0724
208: , p3_a3 DATE := fnd_api.g_miss_date
209: , p3_a4 NUMBER := 0-1962.0724
204: , x_msg_data out nocopy VARCHAR2
205: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
206: , p3_a1 NUMBER := 0-1962.0724
207: , p3_a2 NUMBER := 0-1962.0724
208: , p3_a3 DATE := fnd_api.g_miss_date
209: , p3_a4 NUMBER := 0-1962.0724
210: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
211: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
212: , p3_a7 NUMBER := 0-1962.0724
206: , p3_a1 NUMBER := 0-1962.0724
207: , p3_a2 NUMBER := 0-1962.0724
208: , p3_a3 DATE := fnd_api.g_miss_date
209: , p3_a4 NUMBER := 0-1962.0724
210: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
211: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
212: , p3_a7 NUMBER := 0-1962.0724
213: , p3_a8 NUMBER := 0-1962.0724
214: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
207: , p3_a2 NUMBER := 0-1962.0724
208: , p3_a3 DATE := fnd_api.g_miss_date
209: , p3_a4 NUMBER := 0-1962.0724
210: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
211: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
212: , p3_a7 NUMBER := 0-1962.0724
213: , p3_a8 NUMBER := 0-1962.0724
214: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a10 NUMBER := 0-1962.0724
210: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
211: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
212: , p3_a7 NUMBER := 0-1962.0724
213: , p3_a8 NUMBER := 0-1962.0724
214: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
215: , p3_a10 NUMBER := 0-1962.0724
216: , p3_a11 NUMBER := 0-1962.0724
217: , p3_a12 NUMBER := 0-1962.0724
218: , p3_a13 NUMBER := 0-1962.0724
217: , p3_a12 NUMBER := 0-1962.0724
218: , p3_a13 NUMBER := 0-1962.0724
219: , p3_a14 NUMBER := 0-1962.0724
220: , p3_a15 NUMBER := 0-1962.0724
221: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
222: , p3_a17 NUMBER := 0-1962.0724
223: , p3_a18 NUMBER := 0-1962.0724
224: , p3_a19 NUMBER := 0-1962.0724
225: )
283: , p_commit VARCHAR2
284: , x_return_status out nocopy VARCHAR2
285: , x_msg_count out nocopy NUMBER
286: , x_msg_data out nocopy VARCHAR2
287: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
288: , p3_a1 NUMBER := 0-1962.0724
289: , p3_a2 NUMBER := 0-1962.0724
290: , p3_a3 DATE := fnd_api.g_miss_date
291: , p3_a4 NUMBER := 0-1962.0724
286: , x_msg_data out nocopy VARCHAR2
287: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
288: , p3_a1 NUMBER := 0-1962.0724
289: , p3_a2 NUMBER := 0-1962.0724
290: , p3_a3 DATE := fnd_api.g_miss_date
291: , p3_a4 NUMBER := 0-1962.0724
292: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p3_a7 NUMBER := 0-1962.0724
288: , p3_a1 NUMBER := 0-1962.0724
289: , p3_a2 NUMBER := 0-1962.0724
290: , p3_a3 DATE := fnd_api.g_miss_date
291: , p3_a4 NUMBER := 0-1962.0724
292: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p3_a7 NUMBER := 0-1962.0724
295: , p3_a8 NUMBER := 0-1962.0724
296: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
289: , p3_a2 NUMBER := 0-1962.0724
290: , p3_a3 DATE := fnd_api.g_miss_date
291: , p3_a4 NUMBER := 0-1962.0724
292: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p3_a7 NUMBER := 0-1962.0724
295: , p3_a8 NUMBER := 0-1962.0724
296: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a10 NUMBER := 0-1962.0724
292: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
293: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
294: , p3_a7 NUMBER := 0-1962.0724
295: , p3_a8 NUMBER := 0-1962.0724
296: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
297: , p3_a10 NUMBER := 0-1962.0724
298: , p3_a11 NUMBER := 0-1962.0724
299: , p3_a12 NUMBER := 0-1962.0724
300: , p3_a13 NUMBER := 0-1962.0724
299: , p3_a12 NUMBER := 0-1962.0724
300: , p3_a13 NUMBER := 0-1962.0724
301: , p3_a14 NUMBER := 0-1962.0724
302: , p3_a15 NUMBER := 0-1962.0724
303: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
304: , p3_a17 NUMBER := 0-1962.0724
305: , p3_a18 NUMBER := 0-1962.0724
306: , p3_a19 NUMBER := 0-1962.0724
307: )
363: , x_cure_refund_header_id out nocopy NUMBER
364: , x_return_status out nocopy VARCHAR2
365: , x_msg_count out nocopy NUMBER
366: , x_msg_data out nocopy VARCHAR2
367: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a1 NUMBER := 0-1962.0724
369: , p3_a2 NUMBER := 0-1962.0724
370: , p3_a3 DATE := fnd_api.g_miss_date
371: , p3_a4 NUMBER := 0-1962.0724
366: , x_msg_data out nocopy VARCHAR2
367: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a1 NUMBER := 0-1962.0724
369: , p3_a2 NUMBER := 0-1962.0724
370: , p3_a3 DATE := fnd_api.g_miss_date
371: , p3_a4 NUMBER := 0-1962.0724
372: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
374: , p3_a7 NUMBER := 0-1962.0724
368: , p3_a1 NUMBER := 0-1962.0724
369: , p3_a2 NUMBER := 0-1962.0724
370: , p3_a3 DATE := fnd_api.g_miss_date
371: , p3_a4 NUMBER := 0-1962.0724
372: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
374: , p3_a7 NUMBER := 0-1962.0724
375: , p3_a8 NUMBER := 0-1962.0724
376: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a2 NUMBER := 0-1962.0724
370: , p3_a3 DATE := fnd_api.g_miss_date
371: , p3_a4 NUMBER := 0-1962.0724
372: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
374: , p3_a7 NUMBER := 0-1962.0724
375: , p3_a8 NUMBER := 0-1962.0724
376: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a10 NUMBER := 0-1962.0724
372: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
374: , p3_a7 NUMBER := 0-1962.0724
375: , p3_a8 NUMBER := 0-1962.0724
376: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
377: , p3_a10 NUMBER := 0-1962.0724
378: , p3_a11 NUMBER := 0-1962.0724
379: , p3_a12 NUMBER := 0-1962.0724
380: , p3_a13 NUMBER := 0-1962.0724
379: , p3_a12 NUMBER := 0-1962.0724
380: , p3_a13 NUMBER := 0-1962.0724
381: , p3_a14 NUMBER := 0-1962.0724
382: , p3_a15 NUMBER := 0-1962.0724
383: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
384: , p3_a17 NUMBER := 0-1962.0724
385: , p3_a18 NUMBER := 0-1962.0724
386: , p3_a19 NUMBER := 0-1962.0724
387: )
445: , p_commit VARCHAR2
446: , x_return_status out nocopy VARCHAR2
447: , x_msg_count out nocopy NUMBER
448: , x_msg_data out nocopy VARCHAR2
449: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a1 NUMBER := 0-1962.0724
451: , p3_a2 NUMBER := 0-1962.0724
452: , p3_a3 DATE := fnd_api.g_miss_date
453: , p3_a4 NUMBER := 0-1962.0724
448: , x_msg_data out nocopy VARCHAR2
449: , p3_a0 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a1 NUMBER := 0-1962.0724
451: , p3_a2 NUMBER := 0-1962.0724
452: , p3_a3 DATE := fnd_api.g_miss_date
453: , p3_a4 NUMBER := 0-1962.0724
454: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a7 NUMBER := 0-1962.0724
450: , p3_a1 NUMBER := 0-1962.0724
451: , p3_a2 NUMBER := 0-1962.0724
452: , p3_a3 DATE := fnd_api.g_miss_date
453: , p3_a4 NUMBER := 0-1962.0724
454: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a7 NUMBER := 0-1962.0724
457: , p3_a8 NUMBER := 0-1962.0724
458: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a2 NUMBER := 0-1962.0724
452: , p3_a3 DATE := fnd_api.g_miss_date
453: , p3_a4 NUMBER := 0-1962.0724
454: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a7 NUMBER := 0-1962.0724
457: , p3_a8 NUMBER := 0-1962.0724
458: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p3_a10 NUMBER := 0-1962.0724
454: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a7 NUMBER := 0-1962.0724
457: , p3_a8 NUMBER := 0-1962.0724
458: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
459: , p3_a10 NUMBER := 0-1962.0724
460: , p3_a11 NUMBER := 0-1962.0724
461: , p3_a12 NUMBER := 0-1962.0724
462: , p3_a13 NUMBER := 0-1962.0724
461: , p3_a12 NUMBER := 0-1962.0724
462: , p3_a13 NUMBER := 0-1962.0724
463: , p3_a14 NUMBER := 0-1962.0724
464: , p3_a15 NUMBER := 0-1962.0724
465: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
466: , p3_a17 NUMBER := 0-1962.0724
467: , p3_a18 NUMBER := 0-1962.0724
468: , p3_a19 NUMBER := 0-1962.0724
469: )