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.

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 211: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVEL_PROPERTIES';

207: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
208: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_NO_COPY;
209:
210: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
211: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVEL_PROPERTIES';
212: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
213: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
214: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
215: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 474: FROM BSC_KPI_DIM_LEVEL_PROPERTIES

470: ,USER_LEVEL1
471: ,USER_LEVEL1_DEFAULT
472: ,USER_LEVEL2
473: ,USER_LEVEL2_DEFAULT
474: FROM BSC_KPI_DIM_LEVEL_PROPERTIES
475: WHERE INDICATOR = h_Trg_kpi_neg;
476:
477:
478: h_colum VARCHAR2(100);

Line 620: IF p_table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES' THEN

616: AND CALCULATION_ID = CD.CALCULATION_ID;
617: END LOOP;
618: END IF;
619:
620: IF p_table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES' THEN
621: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVEL_PROPERTIES:-');
622:
623: FOR CD IN c_Dim_Level_Properties LOOP
624: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES

Line 621: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVEL_PROPERTIES:-');

617: END LOOP;
618: END IF;
619:
620: IF p_table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES' THEN
621: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVEL_PROPERTIES:-');
622:
623: FOR CD IN c_Dim_Level_Properties LOOP
624: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES
625: SET USER_LEVEL0 = CD.USER_LEVEL0

Line 624: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES

620: IF p_table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES' THEN
621: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVEL_PROPERTIES:-');
622:
623: FOR CD IN c_Dim_Level_Properties LOOP
624: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES
625: SET USER_LEVEL0 = CD.USER_LEVEL0
626: ,USER_LEVEL1 = CD.USER_LEVEL1
627: ,USER_LEVEL1_DEFAULT = CD.USER_LEVEL1_DEFAULT
628: ,USER_LEVEL2 = CD.USER_LEVEL2

Line 2279: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES') THEN

2275: UPDATE BSC_KPI_DIM_LEVELS_B
2276: SET INDICATOR = h_Trg_kpi_neg
2277: WHERE INDICATOR = x_Trg_kpi;
2278: END IF;
2279: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES') THEN
2280: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES
2281: SET INDICATOR = h_Trg_kpi_neg
2282: WHERE INDICATOR = x_Trg_kpi;
2283: END IF;

Line 2280: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES

2276: SET INDICATOR = h_Trg_kpi_neg
2277: WHERE INDICATOR = x_Trg_kpi;
2278: END IF;
2279: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DIM_LEVEL_PROPERTIES') THEN
2280: UPDATE BSC_KPI_DIM_LEVEL_PROPERTIES
2281: SET INDICATOR = h_Trg_kpi_neg
2282: WHERE INDICATOR = x_Trg_kpi;
2283: END IF;
2284:

Line 2316: h_sql := 'DELETE BSC_KPI_DIM_LEVEL_PROPERTIES WHERE INDICATOR=:1'; --|| 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;
2317: Execute Immediate h_sql USING h_Trg_kpi_neg;
2318:
2319: --UPDATE SHARE_FLAG
2320: h_condition := 'WHERE INDICATOR = :1'; --|| x_Trg_kpi;

Line 2337: h_sql := 'DELETE BSC_KPI_DIM_LEVEL_PROPERTIES WHERE INDICATOR=:1'; --|| 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;
2338: Execute Immediate h_sql USING h_Trg_kpi_neg;
2339: BSC_MESSAGE.Add(x_message => SQLERRM,
2340: x_source => 'Duplicate_KPI_Metadata');
2341: RAISE;

Line 2748: FROM BSC_KPI_DIM_LEVEL_PROPERTIES

2744:
2745: CURSOR c_kpi_dim_level IS
2746:
2747: SELECT distinct(INDICATOR)
2748: FROM BSC_KPI_DIM_LEVEL_PROPERTIES
2749: WHERE DIM_LEVEL_ID = x_dim_level_id;
2750:
2751: h_kpi NUMBER;
2752: