DBA Data[Home] [Help]

APPS.BSC_AW_LOAD dependencies on BSC_AW_MANAGEMENT

Line 23: bsc_aw_management.detach_workspace;

19: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
20: init_all;
21: bsc_aw_adapter.upgrade(p_options);/*serial across all processes. we call upgrade(p_options) to invoke workspace attach in that api*/
22: bsc_aw_load_dim.load_dim(p_dim_level_list);
23: bsc_aw_management.detach_workspace;
24: Exception when others then
25: bsc_aw_management.detach_workspace;
26: rollback;
27: log_n('Exception in load_dim '||sqlerrm);

Line 25: bsc_aw_management.detach_workspace;

21: bsc_aw_adapter.upgrade(p_options);/*serial across all processes. we call upgrade(p_options) to invoke workspace attach in that api*/
22: bsc_aw_load_dim.load_dim(p_dim_level_list);
23: bsc_aw_management.detach_workspace;
24: Exception when others then
25: bsc_aw_management.detach_workspace;
26: rollback;
27: log_n('Exception in load_dim '||sqlerrm);
28: raise;
29: End;

Line 49: bsc_aw_management.detach_workspace;

45: bsc_aw_utility.open_file('TEST');
46: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
47: init_all;
48: bsc_aw_load_dim.purge_dim(p_dim_level_list);
49: bsc_aw_management.detach_workspace;
50: Exception when others then
51: bsc_aw_management.detach_workspace;
52: rollback;
53: log_n('Exception in purge_dim '||sqlerrm);

Line 51: bsc_aw_management.detach_workspace;

47: init_all;
48: bsc_aw_load_dim.purge_dim(p_dim_level_list);
49: bsc_aw_management.detach_workspace;
50: Exception when others then
51: bsc_aw_management.detach_workspace;
52: rollback;
53: log_n('Exception in purge_dim '||sqlerrm);
54: raise;
55: End;

Line 75: bsc_aw_management.get_workspace_lock('ro',null);

71: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
72: bsc_aw_utility.open_file('TEST');
73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;
75: bsc_aw_management.get_workspace_lock('ro',null);
76: bsc_aw_load_dim.dmp_dim_level_into_table(p_dim_level_list);
77: bsc_aw_management.detach_workspace;
78: Exception when others then
79: bsc_aw_management.detach_workspace;

Line 77: bsc_aw_management.detach_workspace;

73: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
74: init_all;
75: bsc_aw_management.get_workspace_lock('ro',null);
76: bsc_aw_load_dim.dmp_dim_level_into_table(p_dim_level_list);
77: bsc_aw_management.detach_workspace;
78: Exception when others then
79: bsc_aw_management.detach_workspace;
80: rollback;
81: log_n('Exception in dmp_dim_level_into_table '||sqlerrm);

Line 79: bsc_aw_management.detach_workspace;

75: bsc_aw_management.get_workspace_lock('ro',null);
76: bsc_aw_load_dim.dmp_dim_level_into_table(p_dim_level_list);
77: bsc_aw_management.detach_workspace;
78: Exception when others then
79: bsc_aw_management.detach_workspace;
80: rollback;
81: log_n('Exception in dmp_dim_level_into_table '||sqlerrm);
82: raise;
83: End;

Line 103: bsc_aw_management.detach_workspace;

99: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
100: init_all;
101: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
102: bsc_aw_load_kpi.load_kpi(p_kpi_list);
103: bsc_aw_management.detach_workspace;
104: Exception when others then
105: bsc_aw_management.detach_workspace;
106: rollback;
107: log_n('Exception in load_kpi '||sqlerrm);

Line 105: bsc_aw_management.detach_workspace;

101: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
102: bsc_aw_load_kpi.load_kpi(p_kpi_list);
103: bsc_aw_management.detach_workspace;
104: Exception when others then
105: bsc_aw_management.detach_workspace;
106: rollback;
107: log_n('Exception in load_kpi '||sqlerrm);
108: raise;
109: End;

Line 130: bsc_aw_management.detach_workspace;

126: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
127: init_all;
128: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
129: bsc_aw_load_kpi.load_base_table(p_base_table_list,p_kpi_list);
130: bsc_aw_management.detach_workspace;
131: Exception when others then
132: bsc_aw_management.detach_workspace;
133: rollback;
134: log_n('Exception in load_base_table '||sqlerrm);

Line 132: bsc_aw_management.detach_workspace;

128: bsc_aw_adapter.upgrade(p_options);/*serial across all processes*/
129: bsc_aw_load_kpi.load_base_table(p_base_table_list,p_kpi_list);
130: bsc_aw_management.detach_workspace;
131: Exception when others then
132: bsc_aw_management.detach_workspace;
133: rollback;
134: log_n('Exception in load_base_table '||sqlerrm);
135: raise;
136: End;

Line 146: bsc_aw_management.detach_workspace;

142: bsc_aw_utility.open_file('TEST');
143: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
144: init_all;
145: bsc_aw_load_kpi.purge_kpi(p_kpi);
146: bsc_aw_management.detach_workspace;
147: Exception when others then
148: bsc_aw_management.detach_workspace;
149: rollback;
150: log_n('Exception in purge_kpi '||sqlerrm);

Line 148: bsc_aw_management.detach_workspace;

144: init_all;
145: bsc_aw_load_kpi.purge_kpi(p_kpi);
146: bsc_aw_management.detach_workspace;
147: Exception when others then
148: bsc_aw_management.detach_workspace;
149: rollback;
150: log_n('Exception in purge_kpi '||sqlerrm);
151: raise;
152: End;

Line 171: bsc_aw_management.get_workspace_lock('ro',null);

167: bsc_aw_utility.open_file('TEST');
168: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
169: init_all;
170: --read lock only
171: bsc_aw_management.get_workspace_lock('ro',null);
172: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_table_name,p_tables);
173: bsc_aw_management.detach_workspace;
174: Exception when others then
175: bsc_aw_management.detach_workspace;

Line 173: bsc_aw_management.detach_workspace;

169: init_all;
170: --read lock only
171: bsc_aw_management.get_workspace_lock('ro',null);
172: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_table_name,p_tables);
173: bsc_aw_management.detach_workspace;
174: Exception when others then
175: bsc_aw_management.detach_workspace;
176: rollback;
177: log_n('Exception in dmp_kpi_cubes_into_table '||sqlerrm);

Line 175: bsc_aw_management.detach_workspace;

171: bsc_aw_management.get_workspace_lock('ro',null);
172: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_table_name,p_tables);
173: bsc_aw_management.detach_workspace;
174: Exception when others then
175: bsc_aw_management.detach_workspace;
176: rollback;
177: log_n('Exception in dmp_kpi_cubes_into_table '||sqlerrm);
178: raise;
179: End;

Line 194: bsc_aw_management.get_workspace_lock('ro',null);

190: bsc_aw_utility.open_file('TEST');
191: bsc_aw_utility.dmp_g_options(bsc_aw_utility.g_options);
192: init_all;
193: --read lock only
194: bsc_aw_management.get_workspace_lock('ro',null);
195: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_dimset,p_dim_levels,p_table_name);
196: bsc_aw_management.detach_workspace;
197: Exception when others then
198: bsc_aw_management.detach_workspace;

Line 196: bsc_aw_management.detach_workspace;

192: init_all;
193: --read lock only
194: bsc_aw_management.get_workspace_lock('ro',null);
195: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_dimset,p_dim_levels,p_table_name);
196: bsc_aw_management.detach_workspace;
197: Exception when others then
198: bsc_aw_management.detach_workspace;
199: rollback;
200: log_n('Exception in dmp_kpi_cubes_into_table '||sqlerrm);

Line 198: bsc_aw_management.detach_workspace;

194: bsc_aw_management.get_workspace_lock('ro',null);
195: bsc_aw_load_kpi.dmp_kpi_cubes_into_table(p_kpi,p_dimset,p_dim_levels,p_table_name);
196: bsc_aw_management.detach_workspace;
197: Exception when others then
198: bsc_aw_management.detach_workspace;
199: rollback;
200: log_n('Exception in dmp_kpi_cubes_into_table '||sqlerrm);
201: raise;
202: End;

Line 289: bsc_aw_management.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);
292: raise;
293: End;