APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 1817: l_Old_Dim_Level_Id bsc_sys_dim_levels_b.dim_level_id%TYPE;

1813: TYPE c_cur_type IS REF CURSOR;
1814: c_cursor c_cur_type;
1815: l_config_change BOOLEAN := FALSE;
1816: i NUMBER;
1817: l_Old_Dim_Level_Id bsc_sys_dim_levels_b.dim_level_id%TYPE;
1818:
1819: CURSOR c_Check_Config_Change IS
1820: SELECT
1821: kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,

Line 1826: bsc_sys_dim_levels_b dl

1822: parent_level_index,parent_level_rel,table_relation,
1823: parent_level_index2,parent_level_rel2
1824: FROM
1825: bsc_kpi_dim_levels_b kl,
1826: bsc_sys_dim_levels_b dl
1827: WHERE
1828: kl.indicator = p_Target_Indicator AND
1829: kl.level_table_name = dl.level_Table_name
1830: ORDER BY

Line 1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');

1840: l_sql := 'SELECT kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,';
1841: l_sql := l_sql || 'parent_level_index,parent_level_rel,table_relation,';
1842: l_sql := l_sql || 'parent_level_index2,parent_level_rel2 ';
1843: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_levels_b');
1844: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' kl ,bsc_sys_dim_levels_b');
1845: l_sql := l_sql || ' dl WHERE kl.indicator = :1 AND dl.dim_level_id = :2 AND kl.dim_set_id = :3 AND ';
1846: l_sql := l_sql || ' kl.level_table_name = dl.level_Table_name ORDER BY dim_set_id,dim_level_index ';
1847:
1848: FOR cd IN c_Check_Config_Change LOOP

Line 1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');

1912: EXECUTE IMMEDIATE l_sql USING p_Source_Indicator,p_Target_Indicator;
1913:
1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';
1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');
1916: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' src, bsc_sys_dim_levels_b');
1917: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' sys, bsc_kpi_dim_levels_b');
1918: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' dl WHERE src.indicator = dl.indicator ');
1919: l_sql := l_sql || ' AND src.dim_level_id = sys.dim_level_id AND sys.level_table_name = dl.level_table_name AND ';
1920: l_sql := l_sql || ' src.dim_set_id = dl.dim_set_id AND src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';