[Home] [Help]
1: package body BSC_AW_LOAD AS
2: /*$Header: BSCAWLOB.pls 120.7 2006/04/20 11:27 vsurendr noship $*/
3: /*
4: the top package to handle all AW data loads, aggregations and forecasts
5: handles dim loads and kpi loads
18: bsc_aw_utility.open_file('TEST');
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;
44: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
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;
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;
80: rollback;
98: bsc_aw_utility.open_file('TEST');
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;
125: bsc_aw_utility.open_file('TEST');
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;
141: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);
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;
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;
176: rollback;
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;
199: rollback;
280: else
281: g_debug:=false;
282: end if;
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;
281: g_debug:=false;
282: end if;
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;
306: Exception when others then
307: null;
308: End;
309:
310: END BSC_AW_LOAD;