APPS.BSC_AW_LOAD_KPI dependencies on BSC_AW_MD_WRAPPER

Line 6: g_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

2: /*$Header: BSCAWLKS.pls 120.15 2006/03/25 12:32 vsurendr noship $*/
3: --program runtime parameters
4: g_debug boolean;
5: g_stmt varchar2(32000);
6: g_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
7: g_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
8: ------------types--------------------------------------------------
9: --
10: --a kpi has multiple dimsets, here we only consider 1 dimset at a time

Line 7: g_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

3: --program runtime parameters
4: g_debug boolean;
5: g_stmt varchar2(32000);
6: g_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
7: g_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
8: ------------types--------------------------------------------------
9: --
10: --a kpi has multiple dimsets, here we only consider 1 dimset at a time
11: --both actual and target dimsets are contained in dim_set

Line 34: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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;
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,

Line 215: p_base_table_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get baes table, dimset and bt measures

211: procedure reset_dimset_change_vector(p_kpi varchar2);
212: procedure load_kpi_dimset_base_table(
213: p_kpi varchar2,
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,

Line 216: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc

212: procedure load_kpi_dimset_base_table(
213: p_kpi varchar2,
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

Line 225: p_base_table_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get baes table, dimset and bt measures

221: );
222: procedure load_kpi_dimset_base_table_job(
223: p_kpi varchar2,
224: p_dimset varchar2,
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,

Line 226: p_dimset_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb, --to get measures etc

222: procedure load_kpi_dimset_base_table_job(
223: p_kpi varchar2,
224: p_dimset varchar2,
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,

Line 275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);

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,
279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r