DBA Data[Home] [Help]

APPS.BSC_AW_ADAPTER dependencies on BSC_AW_MANAGEMENT

Line 39: bsc_aw_management.get_workspace_lock('rw',l_options);

35: Begin
36: l_options:='create workspace,'||p_options;
37: upgrade(l_options);
38: set_up(l_options);
39: bsc_aw_management.get_workspace_lock('rw',l_options);
40: implement_kpi_aw(p_kpi_list,p_affected_kpi);
41: bsc_aw_management.commit_aw;
42: bsc_aw_md_api.analyze_md_tables;
43: commit;

Line 41: bsc_aw_management.commit_aw;

37: upgrade(l_options);
38: set_up(l_options);
39: bsc_aw_management.get_workspace_lock('rw',l_options);
40: implement_kpi_aw(p_kpi_list,p_affected_kpi);
41: bsc_aw_management.commit_aw;
42: bsc_aw_md_api.analyze_md_tables;
43: commit;
44: bsc_aw_management.detach_workspace;
45: Exception when others then

Line 44: bsc_aw_management.detach_workspace;

40: implement_kpi_aw(p_kpi_list,p_affected_kpi);
41: bsc_aw_management.commit_aw;
42: bsc_aw_md_api.analyze_md_tables;
43: commit;
44: bsc_aw_management.detach_workspace;
45: Exception when others then
46: bsc_aw_management.detach_workspace;
47: rollback;
48: log_n('Exception in implement_kpi_aw '||sqlerrm);

Line 46: bsc_aw_management.detach_workspace;

42: bsc_aw_md_api.analyze_md_tables;
43: commit;
44: bsc_aw_management.detach_workspace;
45: Exception when others then
46: bsc_aw_management.detach_workspace;
47: rollback;
48: log_n('Exception in implement_kpi_aw '||sqlerrm);
49: raise;
50: End;

Line 104: bsc_aw_management.get_workspace_lock('rw',p_options);

100: --
101: l_dim_list dbms_sql.varchar2_table;
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;

Line 108: bsc_aw_management.commit_aw;

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;
111: Exception when others then
112: bsc_aw_management.detach_workspace;

Line 109: bsc_aw_management.detach_workspace;

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;
111: Exception when others then
112: bsc_aw_management.detach_workspace;
113: rollback;

Line 112: bsc_aw_management.detach_workspace;

108: bsc_aw_management.commit_aw;
109: bsc_aw_management.detach_workspace;
110: commit;
111: Exception when others then
112: bsc_aw_management.detach_workspace;
113: rollback;
114: log_n('Exception in drop_kpi '||sqlerrm);
115: raise;
116: End;

Line 140: bsc_aw_management.get_workspace_lock('rw',l_options);

136: Begin
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;

Line 142: bsc_aw_management.commit_aw;

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
146: bsc_aw_management.detach_workspace;

Line 144: bsc_aw_management.detach_workspace;

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
146: bsc_aw_management.detach_workspace;
147: rollback;
148: log_n('Exception in create_dim '||sqlerrm);

Line 146: bsc_aw_management.detach_workspace;

142: bsc_aw_management.commit_aw;
143: commit;
144: bsc_aw_management.detach_workspace;
145: Exception when others then
146: bsc_aw_management.detach_workspace;
147: rollback;
148: log_n('Exception in create_dim '||sqlerrm);
149: raise;
150: End;

Line 165: bsc_aw_management.get_workspace_lock('rw',p_options);

161: bsc_aw_md_api.clear_all_cache;
162: l_old_upgrade_version:=bsc_aw_md_api.get_upgrade_version;
163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);
164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then
165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;
168: commit;
169: bsc_aw_management.detach_workspace;

Line 167: bsc_aw_management.commit_aw;

163: log('System Upgrade, New version='||bsc_aw_utility.g_upgrade_version||', Old version='||l_old_upgrade_version);
164: if bsc_aw_utility.g_upgrade_version>l_old_upgrade_version then
165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;
168: commit;
169: bsc_aw_management.detach_workspace;
170: end if;
171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');

Line 169: bsc_aw_management.detach_workspace;

165: bsc_aw_management.get_workspace_lock('rw',p_options);
166: upgrade(bsc_aw_utility.g_upgrade_version,l_old_upgrade_version);
167: bsc_aw_management.commit_aw;
168: commit;
169: bsc_aw_management.detach_workspace;
170: end if;
171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
172: Exception when others then
173: rollback;

Line 175: bsc_aw_management.detach_workspace;

171: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
172: Exception when others then
173: rollback;
174: bsc_aw_utility.release_db_lock('bsc_aw_system_upgrade');
175: bsc_aw_management.detach_workspace;
176: log_n('Exception in upgrade '||sqlerrm);
177: raise;
178: End;
179:

Line 237: bsc_aw_management.init_all;

233: bsc_aw_md_api.init_all;
234: bsc_aw_md_wrapper.init_all;
235: bsc_aw_bsc_metadata.init_all;
236: bsc_metadata.init_all;
237: bsc_aw_management.init_all;
238: g_init:=true;
239: Exception when others then
240: rollback;
241: log_n('Exception in init_all '||sqlerrm);