eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_CALCULATIONS

Line 122: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS';

118: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
119: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
120:
121: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
122: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS';
123: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
124: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
125: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
126: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 130: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS_USER';

126: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
127: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_MASTER_KPI;
128:
129: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
130: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_CALCULATIONS_USER';
131: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
132: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
133: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
134: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 463: FROM BSC_KPI_CALCULATIONS

459: ,USER_LEVEL1
460: ,USER_LEVEL1_DEFAULT
461: ,USER_LEVEL2
462: ,USER_LEVEL2_DEFAULT
463: FROM BSC_KPI_CALCULATIONS
464: WHERE INDICATOR = h_Trg_kpi_neg;
465:
466: CURSOR c_Dim_Level_Properties IS
467: SELECT DIM_SET_ID

Line 606: IF p_table_name = 'BSC_KPI_CALCULATIONS' THEN

602: AND PERIODICITY_ID = CD.PERIODICITY_ID;
603: END LOOP;
604: END IF;
605:
606: IF p_table_name = 'BSC_KPI_CALCULATIONS' THEN
607: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_CALCULATIONS:-');
608: FOR CD IN c_Calculation LOOP
609: UPDATE BSC_KPI_CALCULATIONS
610: SET USER_LEVEL0 = CD.USER_LEVEL0

Line 607: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_CALCULATIONS:-');

603: END LOOP;
604: END IF;
605:
606: IF p_table_name = 'BSC_KPI_CALCULATIONS' THEN
607: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_CALCULATIONS:-');
608: FOR CD IN c_Calculation LOOP
609: UPDATE BSC_KPI_CALCULATIONS
610: SET USER_LEVEL0 = CD.USER_LEVEL0
611: ,USER_LEVEL1 = CD.USER_LEVEL1

Line 609: UPDATE BSC_KPI_CALCULATIONS

605:
606: IF p_table_name = 'BSC_KPI_CALCULATIONS' THEN
607: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_CALCULATIONS:-');
608: FOR CD IN c_Calculation LOOP
609: UPDATE BSC_KPI_CALCULATIONS
610: SET USER_LEVEL0 = CD.USER_LEVEL0
611: ,USER_LEVEL1 = CD.USER_LEVEL1
612: ,USER_LEVEL1_DEFAULT = CD.USER_LEVEL1_DEFAULT
613: ,USER_LEVEL2 = CD.USER_LEVEL2

Line 2269: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_CALCULATIONS') THEN

2265: UPDATE BSC_KPI_PERIODICITIES
2266: SET INDICATOR = h_Trg_kpi_neg
2267: WHERE INDICATOR = x_Trg_kpi;
2268: END IF;
2269: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_CALCULATIONS') THEN
2270: UPDATE BSC_KPI_CALCULATIONS
2271: SET INDICATOR = h_Trg_kpi_neg
2272: WHERE INDICATOR = x_Trg_kpi;
2273: END IF;

Line 2270: UPDATE BSC_KPI_CALCULATIONS

2266: SET INDICATOR = h_Trg_kpi_neg
2267: WHERE INDICATOR = x_Trg_kpi;
2268: END IF;
2269: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_CALCULATIONS') THEN
2270: UPDATE BSC_KPI_CALCULATIONS
2271: SET INDICATOR = h_Trg_kpi_neg
2272: WHERE INDICATOR = x_Trg_kpi;
2273: END IF;
2274: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DIM_LEVELS_B') THEN

Line 2312: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| 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;
2313: Execute Immediate h_sql USING h_Trg_kpi_neg;
2314: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2315: Execute Immediate h_sql USING h_Trg_kpi_neg;
2316: h_sql := 'DELETE BSC_KPI_DIM_LEVEL_PROPERTIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;

Line 2333: h_sql := 'DELETE BSC_KPI_CALCULATIONS WHERE INDICATOR=:1'; --|| 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;
2334: Execute Immediate h_sql USING h_Trg_kpi_neg;
2335: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2336: Execute Immediate h_sql USING h_Trg_kpi_neg;
2337: h_sql := 'DELETE BSC_KPI_DIM_LEVEL_PROPERTIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;