APPS.BSC_DESIGNER_PVT dependencies on BSC_TAB_INDICATORS

Line 370: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_INDICATORS';

366: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
367: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
368:
369: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
370: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_TAB_INDICATORS';
371: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
372: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
373: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.NO;
374: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 554: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';

550: --DBMS_OUTPUT.PUT_LINE(' Insertred into table :-' || p_table_name);
551: --BUG 1224991
552: IF UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(p_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
553: h_sql:= 'UPDATE ' || p_table_name;
554: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';
555: h_sql:= h_sql || ' WHERE INDICATOR = :2'; --|| x_Trg_kpi;
556: Execute Immediate h_sql USING p_Trg_kpi, p_Trg_kpi;
557: END IF;
558:

Line 730: (SELECT TAB_ID,INDICATOR FROM BSC_TAB_INDICATORS));

726: WHERE (TAB_ID,INDICATOR) IN
727: (SELECT TAB_ID,INDICATOR
728: FROM BSC_KPI_DEFAULTS_B
729: WHERE (TAB_ID,INDICATOR) NOT IN
730: (SELECT TAB_ID,INDICATOR FROM BSC_TAB_INDICATORS));
731:
732: --Need to initiliaze in order to Do_DDL works fine
733: BSC_APPS.Init_Bsc_Apps;
734: --Get indicator configuration and type

Line 824: FROM BSC_TAB_INDICATORS

820: PROCEDURE Deflt_Clear(x_indicator IN NUMBER) IS
821:
822: CURSOR c_tab_kpi IS
823: SELECT TAB_ID
824: FROM BSC_TAB_INDICATORS
825: WHERE INDICATOR = l_indicator;
826:
827: h_msg VARCHAR2(1000);
828: h_sql VARCHAR2(2000);

Line 1850: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';

1846: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
1847: --BUG 1224991
1848: IF UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_B' Or UPPER(x_table_name) = 'BSC_KPI_DEFAULTS_TL' THEN
1849: h_sql:= 'UPDATE ' || x_table_name;
1850: h_sql:= h_sql || ' SET TAB_ID = (SELECT TAB_ID FROM BSC_TAB_INDICATORS WHERE INDICATOR =:1)'; --|| x_Trg_kpi || ')';
1851: h_sql:= h_sql || ' WHERE INDICATOR = :2'; --|| x_Trg_kpi;
1852: --BSC_UPDATE_UTIL.Execute_Immediate(h_sql); --bug 3111300 ,part2
1853: Execute Immediate h_sql USING x_Trg_kpi, x_Trg_kpi;
1854: END IF;