APPS.BSC_AW_ADAPTER dependencies on BSC_AW_ADAPTER

Line 1: package body BSC_AW_ADAPTER AS

1: package body BSC_AW_ADAPTER AS
2: /*$Header: BSCAWAPB.pls 120.14 2006/04/20 11:49 vsurendr noship $*/
3:
4: /*
5: implement_kpi_aw is the top procedure. optimizer calls this api, passes a list of kpi to be implemented

Line 67: bsc_aw_adapter_dim.create_dim(l_dim_list,p_affected_kpi);

63: drop_kpi(p_kpi_list);
64: --for the list of kpi, get the dim list...then call the dim adapter
65: --l_dim_list will be the BSC dim levels
66: bsc_aw_bsc_metadata.get_dims_for_kpis(p_kpi_list,l_dim_list);
67: bsc_aw_adapter_dim.create_dim(l_dim_list,p_affected_kpi);
68: --check to see if we need to create calendar
69: --create calendar will only create if needed
70: if bsc_aw_utility.g_debug then
71: bsc_aw_calendar.g_debug:=true;

Line 83: bsc_aw_adapter_kpi.create_kpi(p_kpi_list);

79: l_calendar_processed(l_calendar_processed.count+1):=l_calendar;
80: end if;
81: end loop;
82: --
83: bsc_aw_adapter_kpi.create_kpi(p_kpi_list);
84: bsc_aw_utility.subtract_array(p_affected_kpi,p_kpi_list);
85: bsc_aw_utility.dmp_values(p_affected_kpi,'Affected KPIs');
86: Exception when others then
87: rollback;

Line 106: bsc_aw_adapter_dim.create_dim(l_dim_list);

102: Begin
103: set_up(p_options);
104: bsc_aw_management.get_workspace_lock('rw',p_options);
105: bsc_aw_bsc_metadata.get_dims_for_kpis(p_kpi_list,l_dim_list);
106: bsc_aw_adapter_dim.create_dim(l_dim_list);
107: drop_kpi(p_kpi_list);
108: bsc_aw_management.commit_aw;
109: bsc_aw_management.detach_workspace;
110: commit;

Line 121: bsc_aw_adapter_kpi.drop_kpi_objects(p_kpi_list(i));

117:
118: procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table) is
119: Begin
120: for i in 1..p_kpi_list.count loop
121: bsc_aw_adapter_kpi.drop_kpi_objects(p_kpi_list(i));
122: end loop;
123: Exception when others then
124: log_n('Exception in drop_kpi '||sqlerrm);
125: raise;

Line 141: bsc_aw_adapter_dim.create_dim(p_dim_level_list);

137: l_options:='create workspace,'||p_options;
138: upgrade(l_options);
139: set_up(l_options);
140: bsc_aw_management.get_workspace_lock('rw',l_options);
141: bsc_aw_adapter_dim.create_dim(p_dim_level_list);
142: bsc_aw_management.commit_aw;
143: commit;
144: bsc_aw_management.detach_workspace;
145: Exception when others then

Line 185: bsc_aw_adapter_dim.upgrade(p_new_version,p_old_version);

181: Begin
182: /*cal upgrade*/
183: bsc_aw_calendar.upgrade(p_new_version,p_old_version);
184: /*dim upgrade*/
185: bsc_aw_adapter_dim.upgrade(p_new_version,p_old_version);
186: /*kpi upgrade*/
187: bsc_aw_adapter_kpi.upgrade(p_new_version,p_old_version);
188: /*update the latest upgrade version */
189: bsc_aw_md_api.set_upgrade_version(p_new_version);

Line 187: bsc_aw_adapter_kpi.upgrade(p_new_version,p_old_version);

183: bsc_aw_calendar.upgrade(p_new_version,p_old_version);
184: /*dim upgrade*/
185: bsc_aw_adapter_dim.upgrade(p_new_version,p_old_version);
186: /*kpi upgrade*/
187: bsc_aw_adapter_kpi.upgrade(p_new_version,p_old_version);
188: /*update the latest upgrade version */
189: bsc_aw_md_api.set_upgrade_version(p_new_version);
190: Exception when others then
191: log_n('Exception in upgrade '||sqlerrm);

Line 228: bsc_aw_adapter_dim.init_all;

224: g_debug:=false;
225: end if;
226: /* */
227: bsc_aw_utility.init_all(g_debug);
228: bsc_aw_adapter_dim.init_all;
229: bsc_aw_adapter_kpi.init_all;
230: bsc_aw_load_dim.init_all;
231: bsc_aw_load_kpi.init_all;
232: bsc_aw_dbms_aw.init_all;

Line 229: bsc_aw_adapter_kpi.init_all;

225: end if;
226: /* */
227: bsc_aw_utility.init_all(g_debug);
228: bsc_aw_adapter_dim.init_all;
229: bsc_aw_adapter_kpi.init_all;
230: bsc_aw_load_dim.init_all;
231: bsc_aw_load_kpi.init_all;
232: bsc_aw_dbms_aw.init_all;
233: bsc_aw_md_api.init_all;

Line 260: END BSC_AW_ADAPTER;

256: Exception when others then
257: null;
258: End;
259:
260: END BSC_AW_ADAPTER;