APPS.BSC_UPDATE_COLOR dependencies on BSC_SYS_COM_DIM_LEVELS

Line 2016: FROM bsc_sys_com_dim_levels

2012: h_cursor t_cursor;
2013:
2014: cursor c_tabs is
2015: SELECT tab_id, dim_level_index, parent_level_index
2016: FROM bsc_sys_com_dim_levels
2017: ORDER BY tab_id, dim_level_index;
2018:
2019: TYPE t_tabs IS RECORD (
2020: tab_id bsc_sys_com_dim_levels.tab_id%TYPE,

Line 2020: tab_id bsc_sys_com_dim_levels.tab_id%TYPE,

2016: FROM bsc_sys_com_dim_levels
2017: ORDER BY tab_id, dim_level_index;
2018:
2019: TYPE t_tabs IS RECORD (
2020: tab_id bsc_sys_com_dim_levels.tab_id%TYPE,
2021: dim_level_index bsc_sys_com_dim_levels.dim_level_index%TYPE,
2022: parent_level_index bsc_sys_com_dim_levels.parent_level_index%TYPE
2023: );
2024: h_tab t_tabs;

Line 2021: dim_level_index bsc_sys_com_dim_levels.dim_level_index%TYPE,

2017: ORDER BY tab_id, dim_level_index;
2018:
2019: TYPE t_tabs IS RECORD (
2020: tab_id bsc_sys_com_dim_levels.tab_id%TYPE,
2021: dim_level_index bsc_sys_com_dim_levels.dim_level_index%TYPE,
2022: parent_level_index bsc_sys_com_dim_levels.parent_level_index%TYPE
2023: );
2024: h_tab t_tabs;
2025:

Line 2022: parent_level_index bsc_sys_com_dim_levels.parent_level_index%TYPE

2018:
2019: TYPE t_tabs IS RECORD (
2020: tab_id bsc_sys_com_dim_levels.tab_id%TYPE,
2021: dim_level_index bsc_sys_com_dim_levels.dim_level_index%TYPE,
2022: parent_level_index bsc_sys_com_dim_levels.parent_level_index%TYPE
2023: );
2024: h_tab t_tabs;
2025:
2026: h_last_tab_id NUMBER;

Line 2101: ' FROM BSC_SYS_COM_DIM_LEVELS C, BSC_SYS_DIM_LEVELS_B D'||

2097: h_sql := 'INSERT /*+ append */ INTO BSC_TMP_TAB_DEF'||
2098: ' SELECT C.TAB_ID, C.DIM_LEVEL_INDEX,'||
2099: ' D.LEVEL_PK_COL, D.LEVEL_VIEW_NAME,'||
2100: ' 0 AS FAMILY_INDEX, 0 AS DIM_INDEX'||
2101: ' FROM BSC_SYS_COM_DIM_LEVELS C, BSC_SYS_DIM_LEVELS_B D'||
2102: ' WHERE C.DIM_LEVEL_ID = D.DIM_LEVEL_ID';
2103: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
2104: commit;
2105: