eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_OPTION dependencies on EDW_OWB_COLLECTION_UTIL

Line 72: username=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');

68: end if;
69: end if;
70: if p_option_value is null then
71: select default_tablespace into p_option_value from dba_users where
72: username=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
73: end if;
74:
75: end if;
76:

Line 81: edw_owb_collection_util.write_to_log_file_n('Error in get_warehouse_option '||sqlerrm);

77: return true;
78:
79: Exception when others then
80: g_status_message:=sqlerrm;
81: edw_owb_collection_util.write_to_log_file_n('Error in get_warehouse_option '||sqlerrm);
82: return false;
83: end get_warehouse_option;
84:
85: function get_option_columns(p_object_name varchar2, p_object_id number,p_option_code varchar2,

Line 86: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,

82: return false;
83: end get_warehouse_option;
84:
85: function get_option_columns(p_object_name varchar2, p_object_id number,p_option_code varchar2,
86: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
87: p_number_option_cols out nocopy number) return boolean is
88: l_object_id number(9);
89: l_stmt varchar2(5000);
90: l_option_fk_key number;

Line 100: edw_owb_collection_util.write_to_log_file_n('Error in get_option_columns '||sqlerrm);

96: p_number_option_cols:=0;
97: return true;
98: Exception when others then
99: g_status_message:=sqlerrm;
100: edw_owb_collection_util.write_to_log_file_n('Error in get_option_columns '||sqlerrm);
101: return false;
102: end get_option_columns;
103:
104: function get_fk_dangling_load(p_object_id number,p_option_fk_key number,

Line 105: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)

101: return false;
102: end get_option_columns;
103:
104: function get_fk_dangling_load(p_object_id number,p_option_fk_key number,
105: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)
106: return boolean is
107: l_stmt varchar2(5000);
108: TYPE CurTyp IS REF CURSOR;
109: cv CurTyp;

Line 111: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

107: l_stmt varchar2(5000);
108: TYPE CurTyp IS REF CURSOR;
109: cv CurTyp;
110: l_count number;
111: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
112: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
113: l_number_option_cols number;
114: Begin
115: p_number_option_cols:=0;

Line 112: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;

108: TYPE CurTyp IS REF CURSOR;
109: cv CurTyp;
110: l_count number;
111: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
112: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
113: l_number_option_cols number;
114: Begin
115: p_number_option_cols:=0;
116: return true;

Line 119: edw_owb_collection_util.write_to_log_file_n('Error in get_fk_dangling_load '||sqlerrm);

115: p_number_option_cols:=0;
116: return true;
117: Exception when others then
118: g_status_message:=sqlerrm;
119: edw_owb_collection_util.write_to_log_file_n('Error in get_fk_dangling_load '||sqlerrm);
120: return false;
121: End;
122:
123: function get_level_skip_update(p_object_id number,p_option_fk_key number,

Line 124: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)

120: return false;
121: End;
122:
123: function get_level_skip_update(p_object_id number,p_option_fk_key number,
124: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)
125: return boolean is
126: l_stmt varchar2(5000);
127: TYPE CurTyp IS REF CURSOR;
128: cv CurTyp;

Line 129: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

125: return boolean is
126: l_stmt varchar2(5000);
127: TYPE CurTyp IS REF CURSOR;
128: cv CurTyp;
129: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
131: l_number_option_cols number;
132: Begin
133: p_number_option_cols:=0;

Line 130: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;

126: l_stmt varchar2(5000);
127: TYPE CurTyp IS REF CURSOR;
128: cv CurTyp;
129: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
130: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
131: l_number_option_cols number;
132: Begin
133: p_number_option_cols:=0;
134: return true;

Line 137: edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_update '||sqlerrm);

133: p_number_option_cols:=0;
134: return true;
135: Exception when others then
136: g_status_message:=sqlerrm;
137: edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_update '||sqlerrm);
138: return false;
139: End;
140:
141:

Line 143: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)

139: End;
140:
141:
142: function get_level_skip_delete(p_object_id number,p_option_fk_key number,
143: p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)
144: return boolean is
145: l_stmt varchar2(5000);
146: TYPE CurTyp IS REF CURSOR;
147: cv CurTyp;

Line 148: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;

144: return boolean is
145: l_stmt varchar2(5000);
146: TYPE CurTyp IS REF CURSOR;
147: cv CurTyp;
148: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
149: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
150: l_number_option_cols number;
151: Begin
152: p_number_option_cols:=0;

Line 149: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;

145: l_stmt varchar2(5000);
146: TYPE CurTyp IS REF CURSOR;
147: cv CurTyp;
148: l_option_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
149: l_option_values EDW_OWB_COLLECTION_UTIL.varcharTableType;
150: l_number_option_cols number;
151: Begin
152: p_number_option_cols:=0;
153: return true;

Line 156: edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_delete '||sqlerrm);

152: p_number_option_cols:=0;
153: return true;
154: Exception when others then
155: g_status_message:=sqlerrm;
156: edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_delete '||sqlerrm);
157: return false;
158: End;
159:
160: function get_time return varchar2 is

Line 170: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);

166: End;
167:
168: procedure write_to_log_file(p_message varchar2) is
169: begin
170: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);
171: Exception when others then
172: null;
173: End;
174: