eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 1568: -- Creates the entries in bsc_kpi_dim_level_properties

1564: /************************************************************************************
1565: -- API name : Copy_Dim_Level_Props
1566: -- Type : Private
1567: -- Function :
1568: -- Creates the entries in bsc_kpi_dim_level_properties
1569: ************************************************************************************/
1570:
1571: PROCEDURE Copy_Dim_Level_Props(
1572: p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1799: -- Creates the entries in bsc_kpi_dim_level_properties

1795: /************************************************************************************
1796: -- API name : Check_Key_Item_Props
1797: -- Type : Private
1798: -- Function :
1799: -- Creates the entries in bsc_kpi_dim_level_properties
1800: ************************************************************************************/
1801:
1802: PROCEDURE Check_Key_Item_Props(
1803: p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1878: bsc_kpi_dim_level_properties

1874: END LOOP;
1875:
1876: IF l_config_change THEN
1877: UPDATE
1878: bsc_kpi_dim_level_properties
1879: SET
1880: default_key_value = NULL
1881: ,target_level=1
1882: WHERE

Line 1914: l_sql := 'UPDATE bsc_kpi_dim_level_properties tar SET tar.default_key_value = (SELECT src.default_key_value ';

1910: l_sql := l_sql || ' src WHERE src.indicator = :1 AND src.dim_set_id = tar.dim_set_id AND';
1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
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 ');

Line 1915: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('FROM bsc_kpi_dim_level_properties');

1911: l_sql := l_sql || ' src.dim_level_index = tar.dim_level_index) WHERE indicator = :2';
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 ';

Line 1973: -- Creates the entries in bsc_kpi_dim_level_properties

1969: /************************************************************************************
1970: -- API name : Check_Color_By_Total_Props
1971: -- Type : Private
1972: -- Function :
1973: -- Creates the entries in bsc_kpi_dim_level_properties
1974: ************************************************************************************/
1975:
1976: PROCEDURE Check_Color_By_Total_Props(
1977: p_commit IN VARCHAR2 := FND_API.G_FALSE