7:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
8: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9: function rosetta_g_miss_date_in_map(d date) return date as
10: begin
11: if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
13: return d;
14: end;
15:
16: function rosetta_g_miss_num_map(n number) return number as
17: a number := fnd_api.g_miss_num;
18: b number := 0-1962.0724;
19: begin
20: if n=a then return b; end if;
21: if n=b then return a; end if;
592: , x_msg_count out nocopy NUMBER
593: , x_msg_data out nocopy VARCHAR2
594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
593: , x_msg_data out nocopy VARCHAR2
594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724
594: , ddrosetta_retval_bool OUT NOCOPY NUMBER
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724
602: , p1_a7 NUMBER := 0-1962.0724
595: , p1_a0 NUMBER := 0-1962.0724
596: , p1_a1 VARCHAR2 := fnd_api.g_miss_char
597: , p1_a2 VARCHAR2 := fnd_api.g_miss_char
598: , p1_a3 VARCHAR2 := fnd_api.g_miss_char
599: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
600: , p1_a5 NUMBER := 0-1962.0724
601: , p1_a6 NUMBER := 0-1962.0724
602: , p1_a7 NUMBER := 0-1962.0724
603: , p1_a8 NUMBER := 0-1962.0724
744: , x_return_status out nocopy VARCHAR2
745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
745: , x_msg_count out nocopy NUMBER
746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724
746: , x_msg_data out nocopy VARCHAR2
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724
754: , p4_a7 NUMBER := 0-1962.0724
747: , p4_a0 NUMBER := 0-1962.0724
748: , p4_a1 VARCHAR2 := fnd_api.g_miss_char
749: , p4_a2 VARCHAR2 := fnd_api.g_miss_char
750: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
751: , p4_a4 VARCHAR2 := fnd_api.g_miss_char
752: , p4_a5 NUMBER := 0-1962.0724
753: , p4_a6 NUMBER := 0-1962.0724
754: , p4_a7 NUMBER := 0-1962.0724
755: , p4_a8 NUMBER := 0-1962.0724