APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_SYS_COM_DIM_LEVELS

Line 72: DELETE FROM BSC_SYS_COM_DIM_LEVELS

68: IF v_Index >= 0 then
69: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels It need delete some common Dimension Levels');
70:
71: -- Delete the Common Levels that not applay any more
72: DELETE FROM BSC_SYS_COM_DIM_LEVELS
73: WHERE TAB_ID = p_Tab_Id
74: AND DIM_LEVEL_INDEX >= v_Index;
75: l_deleted_rows := sql%rowcount;
76: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels l_deleted_rows = ' ||l_deleted_rows);

Line 178: from BSC_SYS_COM_DIM_LEVELS

174: -- Query to get the tabs where a dimension object is used
175: -- as common dimension level
176: CURSOR c_tabs_to_check is
177: select TAB_ID
178: from BSC_SYS_COM_DIM_LEVELS
179: Where DIM_LEVEL_id = p_Dim_Level_Id;
180:
181: l_tab_id number;
182:

Line 610: BSC_SYS_COM_DIM_LEVELS CL

606: CL.PARENT_LEVEL_INDEX,
607: CL.DIM_LEVEL_ID,
608: CL.PARENT_DIM_LEVEL_ID
609: FROM BSC_SYS_DIM_LEVELS_B SL,
610: BSC_SYS_COM_DIM_LEVELS CL
611: WHERE CL.TAB_ID = p_Tab_Id
612: AND SL.DIM_LEVEL_ID (+) = CL.DIM_LEVEL_ID
613: ORDER BY CL.DIM_LEVEL_INDEX;
614: