DBA Data[Home] [Help]

APPS.BSC_AW_LOAD dependencies on BSC_AW_MD_API

Line 231: bsc_aw_md_api.create_bt_change_vector(upper(p_base_table)); /*creates cv and current period */

227: when a B table is dropped by the MO, it needs to call drop_bt_change_vector
228: */
229: procedure init_bt_change_vector(p_base_table varchar2) is
230: Begin
231: bsc_aw_md_api.create_bt_change_vector(upper(p_base_table)); /*creates cv and current period */
232: Exception when others then
233: log_n('Exception in init_bt_change_vector '||sqlerrm);
234: raise;
235: End;

Line 239: bsc_aw_md_api.drop_bt_change_vector(upper(p_base_table)); /*drops cv and cp */

235: End;
236:
237: procedure drop_bt_change_vector(p_base_table varchar2) is
238: Begin
239: bsc_aw_md_api.drop_bt_change_vector(upper(p_base_table)); /*drops cv and cp */
240: Exception when others then
241: log_n('Exception in drop_bt_change_vector '||sqlerrm);
242: raise;
243: End;

Line 248: l_value:=bsc_aw_md_api.get_bt_change_vector(upper(p_base_table))+1;

244:
245: function get_bt_next_change_vector(p_base_table varchar2) return number is
246: l_value number;
247: Begin
248: l_value:=bsc_aw_md_api.get_bt_change_vector(upper(p_base_table))+1;
249: return l_value;
250: Exception when others then
251: log_n('Exception in get_bt_next_change_vector '||sqlerrm);
252: raise;

Line 258: bsc_aw_md_api.update_bt_change_vector(upper(p_base_table),p_value);

254:
255: --for base table change vector management
256: procedure update_bt_change_vector(p_base_table varchar2, p_value number) is
257: Begin
258: bsc_aw_md_api.update_bt_change_vector(upper(p_base_table),p_value);
259: Exception when others then
260: log_n('Exception in update_bt_change_vector '||sqlerrm);
261: raise;
262: End;

Line 268: bsc_aw_md_api.update_bt_current_period(upper(p_base_table),p_period||'.'||p_year);

264: /*to set the current period of the B table , p_value is period.year format at the periodicity of the B table
265: we need this value to set projection and balance aggregations on time to null when the cp moves forward*/
266: procedure update_bt_current_period(p_base_table varchar2,p_period number,p_year number) is
267: Begin
268: bsc_aw_md_api.update_bt_current_period(upper(p_base_table),p_period||'.'||p_year);
269: Exception when others then
270: log_n('Exception in update_bt_current_period '||sqlerrm);
271: raise;
272: End;

Line 287: bsc_aw_md_api.init_all;

283: bsc_aw_utility.init_all(g_debug);
284: bsc_aw_load_dim.init_all;
285: bsc_aw_load_kpi.init_all;
286: bsc_aw_dbms_aw.init_all;
287: bsc_aw_md_api.init_all;
288: bsc_aw_md_wrapper.init_all;
289: bsc_aw_management.init_all;
290: Exception when others then
291: log_n('Exception in init_all '||sqlerrm);