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;
363: , x_msg_count out nocopy NUMBER
364: , x_msg_data out nocopy VARCHAR2
365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
364: , x_msg_data out nocopy VARCHAR2
365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
365: , x_status_rule_id out nocopy NUMBER
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
366: , p3_a0 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724
367: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
368: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724
375: , p3_a9 NUMBER := 0-1962.0724
369: , p3_a3 DATE := fnd_api.g_miss_date
370: , p3_a4 DATE := fnd_api.g_miss_date
371: , p3_a5 DATE := fnd_api.g_miss_date
372: , p3_a6 NUMBER := 0-1962.0724
373: , p3_a7 DATE := fnd_api.g_miss_date
374: , p3_a8 NUMBER := 0-1962.0724
375: , p3_a9 NUMBER := 0-1962.0724
376: , p3_a10 NUMBER := 0-1962.0724
377: , p3_a11 NUMBER := 0-1962.0724
545: , x_return_status out nocopy VARCHAR2
546: , x_msg_count out nocopy NUMBER
547: , x_msg_data out nocopy VARCHAR2
548: , p3_a0 NUMBER := 0-1962.0724
549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
547: , x_msg_data out nocopy VARCHAR2
548: , p3_a0 NUMBER := 0-1962.0724
549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date
549: , p3_a1 VARCHAR2 := fnd_api.g_miss_char
550: , p3_a2 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date
556: , p3_a8 NUMBER := 0-1962.0724
557: , p3_a9 NUMBER := 0-1962.0724
551: , p3_a3 VARCHAR2 := fnd_api.g_miss_char
552: , p3_a4 NUMBER := 0-1962.0724
553: , p3_a5 DATE := fnd_api.g_miss_date
554: , p3_a6 NUMBER := 0-1962.0724
555: , p3_a7 DATE := fnd_api.g_miss_date
556: , p3_a8 NUMBER := 0-1962.0724
557: , p3_a9 NUMBER := 0-1962.0724
558: , p3_a10 NUMBER := 0-1962.0724
559: , p3_a11 NUMBER := 0-1962.0724