APPS.BSC_AW_LOAD_KPI dependencies on DBMS_SQL

Line 23: p_kpi_list dbms_sql.varchar2_table

19: ----cache--------------------------------------------------------
20: g_cache_aggregation_r bsc_aw_load_kpi.aggregation_tb;
21: -----procedures----------------------------------------------------
22: procedure load_kpi(
23: p_kpi_list dbms_sql.varchar2_table
24: );
25: procedure load_base_table(
26: p_base_table_list dbms_sql.varchar2_table,
27: p_kpi_list dbms_sql.varchar2_table

Line 26: p_base_table_list dbms_sql.varchar2_table,

22: procedure load_kpi(
23: p_kpi_list dbms_sql.varchar2_table
24: );
25: procedure load_base_table(
26: p_base_table_list dbms_sql.varchar2_table,
27: p_kpi_list dbms_sql.varchar2_table
28: );
29: procedure load_kpi(p_kpi varchar2,p_base_table_list varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
30: procedure load_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,p_base_tables varchar2,

Line 27: p_kpi_list dbms_sql.varchar2_table

23: p_kpi_list dbms_sql.varchar2_table
24: );
25: procedure load_base_table(
26: p_base_table_list dbms_sql.varchar2_table,
27: p_kpi_list dbms_sql.varchar2_table
28: );
29: procedure load_kpi(p_kpi varchar2,p_base_table_list varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
30: procedure load_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,p_base_tables varchar2,
31: p_run_id number,p_job_name varchar2,p_options varchar2);

Line 32: procedure load_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,p_base_tables dbms_sql.varchar2_table);

28: );
29: procedure load_kpi(p_kpi varchar2,p_base_table_list varchar2,p_run_id number,p_job_name varchar2,p_options varchar2);
30: procedure load_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,p_base_tables varchar2,
31: p_run_id number,p_job_name varchar2,p_options varchar2);
32: procedure load_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,p_base_tables dbms_sql.varchar2_table);
33: procedure load_kpi_dimset_base_table(
34: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
35: );
36: function check_load_type(p_property varchar2) return varchar2;

Line 37: --procedure aggregate_kpi_base_table(p_kpi varchar2,p_base_tables dbms_sql.varchar2_table);

33: procedure load_kpi_dimset_base_table(
34: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
35: );
36: function check_load_type(p_property varchar2) return varchar2;
37: --procedure aggregate_kpi_base_table(p_kpi varchar2,p_base_tables dbms_sql.varchar2_table);
38: procedure aggregate_kpi_dimset(p_kpi varchar2,p_dim_set varchar2,
39: p_run_id number,p_job_name varchar2,p_options varchar2);
40: procedure aggregate_kpi_dimset(
41: p_kpi varchar2,

Line 53: p_measures dbms_sql.varchar2_table,

49: );
50: procedure aggregate_measure(
51: p_kpi varchar2,
52: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
53: p_measures dbms_sql.varchar2_table,
54: p_aggregate_options varchar2
55: );
56: procedure aggregate_measure_formula(
57: p_kpi varchar2,

Line 59: p_measures dbms_sql.varchar2_table,

55: );
56: procedure aggregate_measure_formula(
57: p_kpi varchar2,
58: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
59: p_measures dbms_sql.varchar2_table,
60: p_aggregate_options varchar2
61: );
62: procedure correct_forecast_aggregation(
63: p_kpi varchar2,

Line 97: p_cubes dbms_sql.varchar2_table,

93: procedure pop_level(p_marker varchar2);
94: procedure purge_kpi(p_kpi varchar2);
95: procedure limit_measure_dim(
96: p_aggmap_operator bsc_aw_adapter_kpi.aggmap_operator_r,
97: p_cubes dbms_sql.varchar2_table,
98: p_partition_value varchar2
99: );
100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
101: procedure limit_dim_target_level_only(

Line 135: p_dim_levels dbms_sql.varchar2_table,

131: p_periodicity_dim varchar2);
132: procedure dmp_kpi_cubes_into_table(
133: p_kpi varchar2,
134: p_dimset varchar2,
135: p_dim_levels dbms_sql.varchar2_table,
136: p_table_name varchar2) ;
137: procedure limit_dim(p_dim varchar2,p_value varchar2,p_mode varchar2);
138: procedure dmp_kpi_cubes_into_table(
139: p_kpi varchar2,

Line 141: p_tables out nocopy dbms_sql.varchar2_table

137: procedure limit_dim(p_dim varchar2,p_value varchar2,p_mode varchar2);
138: procedure dmp_kpi_cubes_into_table(
139: p_kpi varchar2,
140: p_table_name varchar2,
141: p_tables out nocopy dbms_sql.varchar2_table
142: );
143: procedure lock_dimset_objects(p_kpi varchar2,p_dimset varchar2,p_object_type varchar2,p_lock_type varchar2);
144: procedure get_dimset_objects_to_lock(
145: p_kpi varchar2,

Line 148: p_lock_objects out nocopy dbms_sql.varchar2_table) ;

144: procedure get_dimset_objects_to_lock(
145: p_kpi varchar2,
146: p_dimset varchar2,
147: p_object_type varchar2,
148: p_lock_objects out nocopy dbms_sql.varchar2_table) ;
149: procedure load_kpi_jobs(p_kpi_list dbms_sql.varchar2_table,p_base_table_list varchar2);
150: procedure get_dimset_for_base_table(
151: p_kpi varchar2,
152: p_base_table_list dbms_sql.varchar2_table,

Line 149: procedure load_kpi_jobs(p_kpi_list dbms_sql.varchar2_table,p_base_table_list varchar2);

145: p_kpi varchar2,
146: p_dimset varchar2,
147: p_object_type varchar2,
148: p_lock_objects out nocopy dbms_sql.varchar2_table) ;
149: procedure load_kpi_jobs(p_kpi_list dbms_sql.varchar2_table,p_base_table_list varchar2);
150: procedure get_dimset_for_base_table(
151: p_kpi varchar2,
152: p_base_table_list dbms_sql.varchar2_table,
153: p_dim_set out nocopy dbms_sql.varchar2_table);

Line 152: p_base_table_list dbms_sql.varchar2_table,

148: p_lock_objects out nocopy dbms_sql.varchar2_table) ;
149: procedure load_kpi_jobs(p_kpi_list dbms_sql.varchar2_table,p_base_table_list varchar2);
150: procedure get_dimset_for_base_table(
151: p_kpi varchar2,
152: p_base_table_list dbms_sql.varchar2_table,
153: p_dim_set out nocopy dbms_sql.varchar2_table);
154: procedure get_aggregate_dimsets(
155: p_kpi varchar2,
156: p_dim_set dbms_sql.varchar2_table,

Line 153: p_dim_set out nocopy dbms_sql.varchar2_table);

149: procedure load_kpi_jobs(p_kpi_list dbms_sql.varchar2_table,p_base_table_list varchar2);
150: procedure get_dimset_for_base_table(
151: p_kpi varchar2,
152: p_base_table_list dbms_sql.varchar2_table,
153: p_dim_set out nocopy dbms_sql.varchar2_table);
154: procedure get_aggregate_dimsets(
155: p_kpi varchar2,
156: p_dim_set dbms_sql.varchar2_table,
157: p_aggregate_dimset out nocopy dbms_sql.varchar2_table

Line 156: p_dim_set dbms_sql.varchar2_table,

152: p_base_table_list dbms_sql.varchar2_table,
153: p_dim_set out nocopy dbms_sql.varchar2_table);
154: procedure get_aggregate_dimsets(
155: p_kpi varchar2,
156: p_dim_set dbms_sql.varchar2_table,
157: p_aggregate_dimset out nocopy dbms_sql.varchar2_table
158: );
159: function get_cache_aggregation_r(p_kpi varchar2) return aggregation_r;
160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);

Line 157: p_aggregate_dimset out nocopy dbms_sql.varchar2_table

153: p_dim_set out nocopy dbms_sql.varchar2_table);
154: procedure get_aggregate_dimsets(
155: p_kpi varchar2,
156: p_dim_set dbms_sql.varchar2_table,
157: p_aggregate_dimset out nocopy dbms_sql.varchar2_table
158: );
159: function get_cache_aggregation_r(p_kpi varchar2) return aggregation_r;
160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);
161: procedure get_kpi_base_tables(

Line 160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);

156: p_dim_set dbms_sql.varchar2_table,
157: p_aggregate_dimset out nocopy dbms_sql.varchar2_table
158: );
159: function get_cache_aggregation_r(p_kpi varchar2) return aggregation_r;
160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);
161: procedure get_kpi_base_tables(
162: p_kpi varchar2,
163: p_base_table_list dbms_sql.varchar2_table,
164: p_kpi_base_tables out nocopy dbms_sql.varchar2_table

Line 163: p_base_table_list dbms_sql.varchar2_table,

159: function get_cache_aggregation_r(p_kpi varchar2) return aggregation_r;
160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);
161: procedure get_kpi_base_tables(
162: p_kpi varchar2,
163: p_base_table_list dbms_sql.varchar2_table,
164: p_kpi_base_tables out nocopy dbms_sql.varchar2_table
165: );
166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;

Line 164: p_kpi_base_tables out nocopy dbms_sql.varchar2_table

160: procedure load_kpi_dimset_job(p_kpi varchar2,p_dimset_list dbms_sql.varchar2_table,p_base_tables dbms_sql.varchar2_table);
161: procedure get_kpi_base_tables(
162: p_kpi varchar2,
163: p_base_table_list dbms_sql.varchar2_table,
164: p_kpi_base_tables out nocopy dbms_sql.varchar2_table
165: );
166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;
168: procedure get_measure_objects_to_lock(

Line 166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);

162: p_kpi varchar2,
163: p_base_table_list dbms_sql.varchar2_table,
164: p_kpi_base_tables out nocopy dbms_sql.varchar2_table
165: );
166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;
168: procedure get_measure_objects_to_lock(
169: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
170: p_measures dbms_sql.varchar2_table,

Line 170: p_measures dbms_sql.varchar2_table,

166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;
168: procedure get_measure_objects_to_lock(
169: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
170: p_measures dbms_sql.varchar2_table,
171: p_lock_objects out nocopy dbms_sql.varchar2_table
172: );
173: procedure aggregate_measure_job(
174: p_kpi varchar2,

Line 171: p_lock_objects out nocopy dbms_sql.varchar2_table

167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;
168: procedure get_measure_objects_to_lock(
169: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
170: p_measures dbms_sql.varchar2_table,
171: p_lock_objects out nocopy dbms_sql.varchar2_table
172: );
173: procedure aggregate_measure_job(
174: p_kpi varchar2,
175: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 176: p_measures dbms_sql.varchar2_table,

172: );
173: procedure aggregate_measure_job(
174: p_kpi varchar2,
175: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
176: p_measures dbms_sql.varchar2_table,
177: p_options varchar2,
178: p_measure_agg_type varchar2 --normal, balance or formula
179: );
180: procedure aggregate_measure(

Line 190: p_actual_measures dbms_sql.varchar2_table

186: procedure copy_target_to_actual_job(
187: p_kpi varchar2,
188: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
189: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
190: p_actual_measures dbms_sql.varchar2_table
191: );
192: procedure copy_target_to_actual_job(
193: p_kpi varchar2,
194: p_actual_dimset varchar2,

Line 202: p_actual_cubes dbms_sql.varchar2_table,

198: p_run_id number,p_job_name varchar2,p_options varchar2) ;
199: procedure copy_target_to_actual(
200: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
201: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
202: p_actual_cubes dbms_sql.varchar2_table,
203: p_partition_value varchar2,
204: p_partition_dim_value varchar2
205: );
206: procedure copy_target_to_actual(

Line 218: p_min_value dbms_sql.number_table,

214: p_dimset varchar2,
215: p_base_table_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get baes table, dimset and bt measures
216: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc
217: p_load_program varchar2,
218: p_min_value dbms_sql.number_table,
219: p_max_value dbms_sql.number_table,
220: p_bt_current_period dbms_sql.varchar2_table
221: );
222: procedure load_kpi_dimset_base_table_job(

Line 219: p_max_value dbms_sql.number_table,

215: p_base_table_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get baes table, dimset and bt measures
216: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc
217: p_load_program varchar2,
218: p_min_value dbms_sql.number_table,
219: p_max_value dbms_sql.number_table,
220: p_bt_current_period dbms_sql.varchar2_table
221: );
222: procedure load_kpi_dimset_base_table_job(
223: p_kpi varchar2,

Line 220: p_bt_current_period dbms_sql.varchar2_table

216: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc
217: p_load_program varchar2,
218: p_min_value dbms_sql.number_table,
219: p_max_value dbms_sql.number_table,
220: p_bt_current_period dbms_sql.varchar2_table
221: );
222: procedure load_kpi_dimset_base_table_job(
223: p_kpi varchar2,
224: p_dimset varchar2,

Line 229: p_min_value dbms_sql.number_table,

225: p_base_table_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get baes table, dimset and bt measures
226: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc
227: p_load_program varchar2,
228: p_LB_resync_program varchar2,
229: p_min_value dbms_sql.number_table,
230: p_max_value dbms_sql.number_table,
231: p_bt_current_period dbms_sql.varchar2_table
232: );
233: procedure load_cube_base_table(

Line 230: p_max_value dbms_sql.number_table,

226: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc
227: p_load_program varchar2,
228: p_LB_resync_program varchar2,
229: p_min_value dbms_sql.number_table,
230: p_max_value dbms_sql.number_table,
231: p_bt_current_period dbms_sql.varchar2_table
232: );
233: procedure load_cube_base_table(
234: p_kpi varchar2,

Line 231: p_bt_current_period dbms_sql.varchar2_table

227: p_load_program varchar2,
228: p_LB_resync_program varchar2,
229: p_min_value dbms_sql.number_table,
230: p_max_value dbms_sql.number_table,
231: p_bt_current_period dbms_sql.varchar2_table
232: );
233: procedure load_cube_base_table(
234: p_kpi varchar2,
235: p_dim_set varchar2,

Line 253: p_measures dbms_sql.varchar2_table,

249: procedure insert_bsc_aw_temp_cv(p_min_value number,p_max_value number,p_base_table varchar2);
250: procedure get_measure_objects_to_lock(
251: p_kpi varchar2,
252: p_dimset varchar2,
253: p_measures dbms_sql.varchar2_table,
254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;

Line 254: p_lock_objects out nocopy dbms_sql.varchar2_table

250: procedure get_measure_objects_to_lock(
251: p_kpi varchar2,
252: p_dimset varchar2,
253: p_measures dbms_sql.varchar2_table,
254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;

Line 258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;

254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);

Line 260: p_measures dbms_sql.varchar2_table,

256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 262: p_cubes out nocopy dbms_sql.varchar2_table);

258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);

Line 266: p_actual_measures dbms_sql.varchar2_table);

262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);
267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);
269: procedure get_ds_BT_parameters(
270: p_kpi varchar2,

Line 268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);

264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);
267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);
269: procedure get_ds_BT_parameters(
270: p_kpi varchar2,
271: p_dimset varchar2,
272: p_load_program varchar2,

Line 273: p_b_tables dbms_sql.varchar2_table,

269: procedure get_ds_BT_parameters(
270: p_kpi varchar2,
271: p_dimset varchar2,
272: p_load_program varchar2,
273: p_b_tables dbms_sql.varchar2_table,
274: p_ds_parameters out nocopy dbms_sql.varchar2_table);
275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);
276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
277: procedure limit_cal_target_level_only(

Line 274: p_ds_parameters out nocopy dbms_sql.varchar2_table);

270: p_kpi varchar2,
271: p_dimset varchar2,
272: p_load_program varchar2,
273: p_b_tables dbms_sql.varchar2_table,
274: p_ds_parameters out nocopy dbms_sql.varchar2_table);
275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);
276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
277: procedure limit_cal_target_level_only(
278: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);

272: p_load_program varchar2,
273: p_b_tables dbms_sql.varchar2_table,
274: p_ds_parameters out nocopy dbms_sql.varchar2_table);
275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);
276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
277: procedure limit_cal_target_level_only(
278: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
280: );

Line 284: p_cubes dbms_sql.varchar2_table,

280: );
281: procedure check_bt_current_period_change(
282: p_kpi varchar2,
283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
284: p_cubes dbms_sql.varchar2_table,
285: p_measures dbms_sql.varchar2_table,
286: p_base_tables dbms_sql.varchar2_table,
287: p_bt_current_period dbms_sql.varchar2_table,
288: p_options varchar2

Line 285: p_measures dbms_sql.varchar2_table,

281: procedure check_bt_current_period_change(
282: p_kpi varchar2,
283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
284: p_cubes dbms_sql.varchar2_table,
285: p_measures dbms_sql.varchar2_table,
286: p_base_tables dbms_sql.varchar2_table,
287: p_bt_current_period dbms_sql.varchar2_table,
288: p_options varchar2
289: );

Line 286: p_base_tables dbms_sql.varchar2_table,

282: p_kpi varchar2,
283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
284: p_cubes dbms_sql.varchar2_table,
285: p_measures dbms_sql.varchar2_table,
286: p_base_tables dbms_sql.varchar2_table,
287: p_bt_current_period dbms_sql.varchar2_table,
288: p_options varchar2
289: );
290: procedure check_bt_current_period_change(

Line 287: p_bt_current_period dbms_sql.varchar2_table,

283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
284: p_cubes dbms_sql.varchar2_table,
285: p_measures dbms_sql.varchar2_table,
286: p_base_tables dbms_sql.varchar2_table,
287: p_bt_current_period dbms_sql.varchar2_table,
288: p_options varchar2
289: );
290: procedure check_bt_current_period_change(
291: p_kpi varchar2,

Line 295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/

291: p_kpi varchar2,
292: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
293: p_cube varchar2,
294: p_measures bsc_aw_adapter_kpi.measure_tb,
295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/
296: p_start_period dbms_sql.varchar2_table,
297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */
299: );

Line 296: p_start_period dbms_sql.varchar2_table,

292: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
293: p_cube varchar2,
294: p_measures bsc_aw_adapter_kpi.measure_tb,
295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/
296: p_start_period dbms_sql.varchar2_table,
297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */
299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;

Line 297: p_end_period dbms_sql.varchar2_table,

293: p_cube varchar2,
294: p_measures bsc_aw_adapter_kpi.measure_tb,
295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/
296: p_start_period dbms_sql.varchar2_table,
297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */
299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;
301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

Line 302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;

298: p_options varchar2 /*contains partition info */
299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;
301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;

Line 303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;

299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;
301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;

Line 308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,

304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;
308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,
309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);
310: --procedures-------------------------------------------------------
311: procedure init_all;
312: procedure log(p_message varchar2);

Line 309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);

305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;
308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,
309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);
310: --procedures-------------------------------------------------------
311: procedure init_all;
312: procedure log(p_message varchar2);
313: procedure log_n(p_message varchar2);