APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_ANALYSIS_OPTIONS_TL

Line 106: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_TL';

102: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
103: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
104:
105: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
106: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
107: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
108: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
109: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
110: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

Line 913: FROM BSC_KPI_ANALYSIS_OPTIONS_TL

909: WHERE INDICATOR = l_indicator;
910:
911: CURSOR c_kpi_analysis IS
912: SELECT LANGUAGE,SOURCE_LANG,NAME
913: FROM BSC_KPI_ANALYSIS_OPTIONS_TL
914: WHERE INDICATOR = l_indicator AND
915: ANALYSIS_GROUP_ID = h_a_grp AND
916: --OPTION_ID = h_a_opt; //bug#2740431
917: OPTION_ID = h_a_opt AND

Line 931: h_name BSC_KPI_ANALYSIS_OPTIONS_TL.NAME%TYPE;

927:
928: h_msg VARCHAR2(1000);
929: h_sql VARCHAR2(2000);
930: --
931: h_name BSC_KPI_ANALYSIS_OPTIONS_TL.NAME%TYPE;
932: h_lang VARCHAR2(4);
933: h_source_lang VARCHAR2(4);
934: h_tmp VARCHAR2(255); /* Bug Fix #2691601 changine size from 80 to 255 */
935: --

Line 2308: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2304:
2305: --DBMS_OUTPUT.PUT_LINE(' DELETEING BSC_KPI_ANALYSIS_OPTIONS_B:-' );
2306: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2307: Execute Immediate h_sql USING h_Trg_kpi_neg;
2308: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2309: Execute Immediate h_sql USING h_Trg_kpi_neg;
2310: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2311: Execute Immediate h_sql USING h_Trg_kpi_neg;
2312: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

Line 2329: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

2325: EXCEPTION
2326: WHEN OTHERS THEN
2327: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2328: Execute Immediate h_sql USING h_Trg_kpi_neg;
2329: h_sql := 'DELETE BSC_KPI_ANALYSIS_OPTIONS_TL WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2330: Execute Immediate h_sql USING h_Trg_kpi_neg;
2331: h_sql := 'DELETE BSC_KPI_PERIODICITIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2332: Execute Immediate h_sql USING h_Trg_kpi_neg;
2333: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;