APPS.BSC_AW_ADAPTER_KPI dependencies on BSC_AW_MD_WRAPPER

Line 170: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

166: End;
167:
168: procedure get_dim_properties(p_kpi varchar2,p_dim in out nocopy dim_r) is
169: --
170: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
171: Begin
172: bsc_aw_md_api.get_dim_properties(p_dim); --recursive, multi level, time or normal, concat?, base value cube etc
173: bsc_aw_bsc_metadata.get_dim_level_properties(p_kpi,p_dim); --pk,fk,datatype for the levels and the filter
174: l_olap_object_relation.delete;

Line 217: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

213: raise;
214: End;
215:
216: procedure set_dim_level_positions(p_dim in out nocopy dim_r) is
217: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
218: Begin
219: l_olap_object.delete;
220: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim.dim_name,'dimension',l_olap_object);
221: for i in 1..p_dim.levels.count loop

Line 1584: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

1580: the system. drop has to be rerun till successful
1581: */
1582: procedure drop_kpi_objects_relational(p_kpi varchar2) is
1583: l_flag dbms_sql.varchar2_table;
1584: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1585: Begin
1586: bsc_aw_md_api.get_bsc_olap_object(null,null,p_kpi,'kpi',l_olap_object);
1587: for i in 1..l_olap_object.count loop
1588: l_flag(i):='N';

Line 4632: l_oo_object bsc_aw_md_wrapper.bsc_olap_object_tb;

4628: p_dim_levels dbms_sql.varchar2_table,
4629: p_name varchar2,
4630: p_table_name varchar2) is
4631: --
4632: l_oo_object bsc_aw_md_wrapper.bsc_olap_object_tb;
4633: l_oo_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
4634: l_dimset varchar2(100);
4635: l_dim_level_dims dbms_sql.varchar2_table;
4636: l_measures dbms_sql.varchar2_table;

Line 4633: l_oo_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

4629: p_name varchar2,
4630: p_table_name varchar2) is
4631: --
4632: l_oo_object bsc_aw_md_wrapper.bsc_olap_object_tb;
4633: l_oo_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
4634: l_dimset varchar2(100);
4635: l_dim_level_dims dbms_sql.varchar2_table;
4636: l_measures dbms_sql.varchar2_table;
4637: l_cubes dbms_sql.varchar2_table;