APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_DATA_TABLES

Line 154: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DATA_TABLES';

150: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
151: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
152:
153: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
154: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DATA_TABLES';
155: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
156: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
157: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
158: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 2291: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_DATA_TABLES') )THEN

2287: FOR i IN 1..l_num_kpi_metadata_tables LOOP
2288: IF ((l_kpi_metadata_tables(i).table_name <> 'BSC_KPIS_B' )
2289: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPIS_TL' )
2290: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_CAUSE_EFFECT_RELS' )
2291: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_DATA_TABLES') )THEN
2292: Copy_Record_by_Indicator_Table(l_kpi_metadata_tables(i).table_name,l_kpi_metadata_tables(i).table_type,l_kpi_metadata_tables(i).table_column, x_Src_kpi, x_Trg_kpi);
2293: ELSE
2294: IF l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DATA_TABLES' THEN
2295: IF h_SRC_Flag <> 0 THEN --gActionFlag.Normal =0

Line 2294: IF l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DATA_TABLES' THEN

2290: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_CAUSE_EFFECT_RELS' )
2291: AND (l_kpi_metadata_tables(i).table_name <> 'BSC_KPI_DATA_TABLES') )THEN
2292: Copy_Record_by_Indicator_Table(l_kpi_metadata_tables(i).table_name,l_kpi_metadata_tables(i).table_type,l_kpi_metadata_tables(i).table_column, x_Src_kpi, x_Trg_kpi);
2293: ELSE
2294: IF l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DATA_TABLES' THEN
2295: IF h_SRC_Flag <> 0 THEN --gActionFlag.Normal =0
2296: Copy_Record_by_Indicator_Table(l_kpi_metadata_tables(i).table_name,l_kpi_metadata_tables(i).table_type,l_kpi_metadata_tables(i).table_column, x_Src_kpi, x_Trg_kpi);
2297: END IF;
2298: END IF;

Line 2656: FROM BSC_KPI_DATA_TABLES

2652: IF h_newflag = h_structure THEN -- Structure Change . to Prototype
2653: -- Insert at least one record in the KPI_DATA_TABLES
2654: SELECT COUNT(INDICATOR)
2655: INTO l_count_kpis
2656: FROM BSC_KPI_DATA_TABLES
2657: WHERE INDICATOR = p_indicator
2658: AND TABLE_NAME IS NOT NULL;
2659:
2660: IF(l_count_kpis = 0) THEN

Line 2661: DELETE BSC_KPI_DATA_TABLES WHERE DIM_SET_ID =0 AND INDICATOR = p_indicator;

2657: WHERE INDICATOR = p_indicator
2658: AND TABLE_NAME IS NOT NULL;
2659:
2660: IF(l_count_kpis = 0) THEN
2661: DELETE BSC_KPI_DATA_TABLES WHERE DIM_SET_ID =0 AND INDICATOR = p_indicator;
2662: INSERT INTO BSC_KPI_DATA_TABLES
2663: (INDICATOR,PERIODICITY_ID,DIM_SET_ID,LEVEL_COMB,TABLE_NAME,FILTER_CONDITION)
2664: (SELECT INDICATOR INDICATOR,PERIODICITY_ID PERIODICITY_ID,0 DIM_SET_ID,'?' LEVEL_COMB,
2665: NULL TABLE_NAME,NULL FILTER_CONDITION FROM BSC_KPI_PERIODICITIES

Line 2662: INSERT INTO BSC_KPI_DATA_TABLES

2658: AND TABLE_NAME IS NOT NULL;
2659:
2660: IF(l_count_kpis = 0) THEN
2661: DELETE BSC_KPI_DATA_TABLES WHERE DIM_SET_ID =0 AND INDICATOR = p_indicator;
2662: INSERT INTO BSC_KPI_DATA_TABLES
2663: (INDICATOR,PERIODICITY_ID,DIM_SET_ID,LEVEL_COMB,TABLE_NAME,FILTER_CONDITION)
2664: (SELECT INDICATOR INDICATOR,PERIODICITY_ID PERIODICITY_ID,0 DIM_SET_ID,'?' LEVEL_COMB,
2665: NULL TABLE_NAME,NULL FILTER_CONDITION FROM BSC_KPI_PERIODICITIES
2666: WHERE INDICATOR = p_indicator);