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;
693: procedure bind_asset_variable(p_get_asset_cursor_id NUMBER
694: , p0_a0 NUMBER := 0-1962.0724
695: , p0_a1 NUMBER := 0-1962.0724
696: , p0_a2 NUMBER := 0-1962.0724
697: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
698: , p0_a4 NUMBER := 0-1962.0724
699: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a6 NUMBER := 0-1962.0724
701: )
695: , p0_a1 NUMBER := 0-1962.0724
696: , p0_a2 NUMBER := 0-1962.0724
697: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
698: , p0_a4 NUMBER := 0-1962.0724
699: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
700: , p0_a6 NUMBER := 0-1962.0724
701: )
702:
703: as
824: procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2
825: , p0_a0 NUMBER := 0-1962.0724
826: , p0_a1 NUMBER := 0-1962.0724
827: , p0_a2 NUMBER := 0-1962.0724
828: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
829: , p0_a4 NUMBER := 0-1962.0724
830: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
831: , p0_a6 NUMBER := 0-1962.0724
832: )
826: , p0_a1 NUMBER := 0-1962.0724
827: , p0_a2 NUMBER := 0-1962.0724
828: , p0_a3 VARCHAR2 := fnd_api.g_miss_char
829: , p0_a4 NUMBER := 0-1962.0724
830: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
831: , p0_a6 NUMBER := 0-1962.0724
832: )
833:
834: as
892: , x_msg_data out nocopy VARCHAR2
893: , p4_a0 NUMBER := 0-1962.0724
894: , p4_a1 NUMBER := 0-1962.0724
895: , p4_a2 NUMBER := 0-1962.0724
896: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
897: , p4_a4 NUMBER := 0-1962.0724
898: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
899: , p4_a6 NUMBER := 0-1962.0724
900: )
894: , p4_a1 NUMBER := 0-1962.0724
895: , p4_a2 NUMBER := 0-1962.0724
896: , p4_a3 VARCHAR2 := fnd_api.g_miss_char
897: , p4_a4 NUMBER := 0-1962.0724
898: , p4_a5 VARCHAR2 := fnd_api.g_miss_char
899: , p4_a6 NUMBER := 0-1962.0724
900: )
901:
902: as