APPS.BSC_DESIGNER_PVT dependencies on BSC_COLOR_TYPE_PROPS

Line 33: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_COLOR_TYPE_PROPS';

29: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;
30: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).copy_type := C_MASTER_KPI;
31:
32: g_num_obj_kpi_metadata_tables := g_num_obj_kpi_metadata_tables + 1;
33: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_name := 'BSC_COLOR_TYPE_PROPS';
34: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_type := C_KPI_MEAS_TABLE;
35: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).table_column := C_INDICATOR;
36: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
37: g_obj_kpi_metadata_tables(g_num_obj_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 1990: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT color_range_id, property_value FROM bsc_color_type_props');

1986: l_src_property_value NUMBER;
1987: TYPE c_cur_type IS REF CURSOR;
1988: c_color_range c_cur_type;
1989: BEGIN
1990: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT color_range_id, property_value FROM bsc_color_type_props');
1991: l_sql := l_sql || 'WHERE indicator = :1';
1992:
1993: IF p_src_kpi_measure_id IS NULL THEN
1994: l_sql := l_sql || ' AND kpi_measure_id IS NULL';

Line 2006: UPDATE bsc_color_type_props

2002:
2003: SELECT bsc_color_range_id_s.NEXTVAL INTO l_trg_color_range_id from dual;
2004:
2005: IF p_trg_kpi_measure_id IS NOT NULL THEN
2006: UPDATE bsc_color_type_props
2007: SET color_range_id = l_trg_color_range_id
2008: WHERE indicator = p_trg_kpi
2009: AND kpi_measure_id = p_trg_kpi_measure_id
2010: AND NVL(property_value, -1) = DECODE(l_src_property_value, NULL, -1, l_src_property_value);

Line 2012: UPDATE bsc_color_type_props

2008: WHERE indicator = p_trg_kpi
2009: AND kpi_measure_id = p_trg_kpi_measure_id
2010: AND NVL(property_value, -1) = DECODE(l_src_property_value, NULL, -1, l_src_property_value);
2011: ELSE
2012: UPDATE bsc_color_type_props
2013: SET color_range_id = l_trg_color_range_id
2014: WHERE indicator = p_trg_kpi
2015: AND kpi_measure_id IS NULL;
2016: END IF;

Line 2100: p_table_name => 'BSC_COLOR_TYPE_PROPS'

2096: END LOOP;
2097:
2098: -- Check whether thresholds are specified at objective level.
2099: insert_kpi_meas_data (
2100: p_table_name => 'BSC_COLOR_TYPE_PROPS'
2101: , p_src_kpi => p_src_kpi
2102: , p_trg_kpi => p_trg_kpi
2103: , p_src_kpi_measure_id => NULL
2104: , p_trg_kpi_measure_id => NULL

Line 2107: FROM bsc_color_type_props

2103: , p_src_kpi_measure_id => NULL
2104: , p_trg_kpi_measure_id => NULL
2105: );
2106: SELECT COUNT(1) INTO l_Count
2107: FROM bsc_color_type_props
2108: WHERE indicator = p_trg_kpi AND kpi_measure_id IS NULL;
2109:
2110: IF l_Count = 1 THEN
2111: Copy_Thresholds (