APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_DIM_LEVELS_TL

Line 194: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_TL';

190: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
191: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
192:
193: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
194: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_TL';
195: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
196: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
197: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
198: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

Line 1463: BSC_KPI_DIM_LEVELS_TL TL,

1459: DECODE(DEFAULT_KEY_VALUE,NULL,
1460: DECODE(DEFAULT_VALUE,
1461: 'C',COMP_DISP_NAME,TOTAL_DISP_NAME),NULL) TEXT
1462: FROM BSC_KPI_DIM_LEVELS_B B,
1463: BSC_KPI_DIM_LEVELS_TL TL,
1464: BSC_KPI_DEFAULTS_B DF
1465: WHERE B.INDICATOR = l_indicator AND
1466: B.INDICATOR = TL.INDICATOR AND
1467: B.INDICATOR = DF.INDICATOR AND

Line 1489: h_name BSC_KPI_DIM_LEVELS_TL.NAME%TYPE;

1485: h_level_view_name VARCHAR2(30);
1486: h_value_order_by NUMBER(5);
1487: h_dim_txt VARCHAR2(100);
1488: h_lang VARCHAR2(4);
1489: h_name BSC_KPI_DIM_LEVELS_TL.NAME%TYPE;
1490: h_text VARCHAR2(240);
1491: BEGIN
1492:
1493: --Initiliaze the inetrnal variable by kpis