APPS.BSC_AW_ADAPTER_DIM dependencies on BSC_OLAP_OBJECT

Line 640: l_objects bsc_aw_md_wrapper.bsc_olap_object_tb;

636: 4. others like programs
637: */
638: procedure drop_dim(p_dim_name varchar2) is
639: --
640: l_objects bsc_aw_md_wrapper.bsc_olap_object_tb;
641: l_flag dbms_sql.varchar2_table;
642: --
643: Begin
644: bsc_aw_md_api.get_dim_olap_objects(p_dim_name,l_objects,'all');

Line 1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

1625: p_aggregate_marker out nocopy dbms_sql.varchar2_table,
1626: p_reset_cubes out nocopy dbms_sql.varchar2_table
1627: ) is
1628: --
1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1630: Begin
1631: l_olap_object_relation.delete;
1632: bsc_aw_md_api.get_bsc_olap_object_relation(p_dim,'dimension',null,null,null,l_olap_object_relation);
1633: for i in 1..l_olap_object_relation.count loop

Line 1632: bsc_aw_md_api.get_bsc_olap_object_relation(p_dim,'dimension',null,null,null,l_olap_object_relation);

1628: --
1629: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1630: Begin
1631: l_olap_object_relation.delete;
1632: bsc_aw_md_api.get_bsc_olap_object_relation(p_dim,'dimension',null,null,null,l_olap_object_relation);
1633: for i in 1..l_olap_object_relation.count loop
1634: --do this only if the limit cube is "actual" limit cube. not if its target limit cube
1635: if bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'dim set type',',')='actual' then
1636: if l_olap_object_relation(i).relation_type='kpi limit cube' then

Line 2453: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

2449: End;
2450:
2451: /*if any level is view based, return Y*/
2452: function check_dim_view_based(p_dim varchar2) return varchar2 is
2453: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
2454: Begin
2455: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
2456: for i in 1..l_oo.count loop
2457: if bsc_aw_utility.get_parameter_value(l_oo(i).property1,'level source',',')='view' then

Line 2455: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);

2451: /*if any level is view based, return Y*/
2452: function check_dim_view_based(p_dim varchar2) return varchar2 is
2453: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
2454: Begin
2455: bsc_aw_md_api.get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
2456: for i in 1..l_oo.count loop
2457: if bsc_aw_utility.get_parameter_value(l_oo(i).property1,'level source',',')='view' then
2458: return 'Y';
2459: end if;