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_LEVELS_B

Line 186: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_B';

182: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
183: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
184:
185: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
186: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_DIM_LEVELS_B';
187: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
188: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
189: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
190: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 443: FROM BSC_KPI_DIM_LEVELS_B

439: ,USER_LEVEL1_DEFAULT
440: ,USER_LEVEL2
441: ,USER_LEVEL2_DEFAULT
442: ,LEVEL_VIEW_NAME
443: FROM BSC_KPI_DIM_LEVELS_B
444: WHERE INDICATOR = h_Trg_kpi_neg;
445:
446: CURSOR c_Periodicity IS
447: SELECT PERIODICITY_ID

Line 576: IF p_table_name = 'BSC_KPI_DIM_LEVELS_B' THEN

572: AND PARENT_OPTION_ID = CD.PARENT_OPTION_ID
573: AND GRANDPARENT_OPTION_ID = CD.GRANDPARENT_OPTION_ID;
574: END LOOP;
575: END IF;
576: IF p_table_name = 'BSC_KPI_DIM_LEVELS_B' THEN
577: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVELS_B:-');
578: FOR CD IN c_Dim_level LOOP
579: UPDATE BSC_KPI_DIM_LEVELS_B
580: SET USER_LEVEL0 = CD.USER_LEVEL0

Line 577: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVELS_B:-');

573: AND GRANDPARENT_OPTION_ID = CD.GRANDPARENT_OPTION_ID;
574: END LOOP;
575: END IF;
576: IF p_table_name = 'BSC_KPI_DIM_LEVELS_B' THEN
577: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVELS_B:-');
578: FOR CD IN c_Dim_level LOOP
579: UPDATE BSC_KPI_DIM_LEVELS_B
580: SET USER_LEVEL0 = CD.USER_LEVEL0
581: ,USER_LEVEL1 = CD.USER_LEVEL1

Line 579: UPDATE BSC_KPI_DIM_LEVELS_B

575: END IF;
576: IF p_table_name = 'BSC_KPI_DIM_LEVELS_B' THEN
577: --DBMS_OUTPUT.PUT_LINE(' UPDATEIN BSC_KPI_DIM_LEVELS_B:-');
578: FOR CD IN c_Dim_level LOOP
579: UPDATE BSC_KPI_DIM_LEVELS_B
580: SET USER_LEVEL0 = CD.USER_LEVEL0
581: ,USER_LEVEL1 = CD.USER_LEVEL1
582: ,USER_LEVEL1_DEFAULT = CD.USER_LEVEL1_DEFAULT
583: ,USER_LEVEL2 = CD.USER_LEVEL2

Line 1375: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1371: -- Update dimension values
1372:
1373: h_sql := 'UPDATE BSC_KPI_DEFAULTS_B KD SET ' ||
1374: ' DIM_LEVEL1_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1375: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1376: ' WHERE KDL.DIM_LEVEL_INDEX = 0 ' ||
1377: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1378: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID),' ||
1379: ' DIM_LEVEL2_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1380: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1376: ' WHERE KDL.DIM_LEVEL_INDEX = 0 ' ||
1377: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1378: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID),' ||
1379: ' DIM_LEVEL2_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1380: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1381: ' where KDL.DIM_LEVEL_INDEX = 1 ' ||
1382: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1383: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1384: ' DIM_LEVEL3_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1385: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1381: ' where KDL.DIM_LEVEL_INDEX = 1 ' ||
1382: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1383: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1384: ' DIM_LEVEL3_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1385: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1386: ' WHERE KDL.DIM_LEVEL_INDEX = 2 ' ||
1387: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1388: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1389: ' DIM_LEVEL4_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1390: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1386: ' WHERE KDL.DIM_LEVEL_INDEX = 2 ' ||
1387: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1388: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1389: ' DIM_LEVEL4_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1390: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1391: ' WHERE KDL.DIM_LEVEL_INDEX = 3 ' ||
1392: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1393: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1394: ' DIM_LEVEL5_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1395: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1391: ' WHERE KDL.DIM_LEVEL_INDEX = 3 ' ||
1392: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1393: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1394: ' DIM_LEVEL5_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1395: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1396: ' WHERE KDL.DIM_LEVEL_INDEX = 4 ' ||
1397: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1398: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1399: ' DIM_LEVEL6_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1400: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1396: ' WHERE KDL.DIM_LEVEL_INDEX = 4 ' ||
1397: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1398: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1399: ' DIM_LEVEL6_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1400: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1401: ' WHERE KDL.DIM_LEVEL_INDEX = 5 ' ||
1402: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1403: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1404: ' DIM_LEVEL7_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1405: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1401: ' WHERE KDL.DIM_LEVEL_INDEX = 5 ' ||
1402: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1403: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1404: ' DIM_LEVEL7_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1405: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1406: ' WHERE KDL.DIM_LEVEL_INDEX = 6 ' ||
1407: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1408: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1409: ' DIM_LEVEL8_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||

Line 1410: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||

1406: ' WHERE KDL.DIM_LEVEL_INDEX = 6 ' ||
1407: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1408: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID), ' ||
1409: ' DIM_LEVEL8_VALUE = (SELECT DECODE(DEFAULT_KEY_VALUE, NULL, DECODE(DEFAULT_VALUE,''C'',-1,0), DEFAULT_KEY_VALUE) VALUE ' ||
1410: ' FROM BSC_KPI_DIM_LEVELS_B KDL ' ||
1411: ' WHERE KDL.DIM_LEVEL_INDEX = 7 ' ||
1412: ' AND KDL.INDICATOR = KD.INDICATOR ' ||
1413: ' AND KDL.DIM_SET_ID = KD.DIM_SET_ID) ' ||
1414: ' WHERE KD.INDICATOR =:1'; --|| l_indicator;

Line 1462: FROM BSC_KPI_DIM_LEVELS_B B,

1458: DECODE(B.STATUS,2,TL.NAME,NULL) AS NAME,
1459: DECODE(DEFAULT_KEY_VALUE,NULL,
1460: DECODE(DEFAULT_VALUE,
1461: 'C',COMP_DISP_NAME,TOTAL_DISP_NAME),NULL) TEXT
1462: FROM BSC_KPI_DIM_LEVELS_B B,
1463: BSC_KPI_DIM_LEVELS_TL TL,
1464: BSC_KPI_DEFAULTS_B DF
1465: WHERE B.INDICATOR = l_indicator AND
1466: B.INDICATOR = TL.INDICATOR AND

Line 2274: IF(l_kpi_metadata_tables(i).table_name = 'BSC_KPI_DIM_LEVELS_B') 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
2275: UPDATE BSC_KPI_DIM_LEVELS_B
2276: SET INDICATOR = h_Trg_kpi_neg
2277: WHERE INDICATOR = x_Trg_kpi;
2278: END IF;

Line 2275: UPDATE BSC_KPI_DIM_LEVELS_B

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
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

Line 2314: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| 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;
2317: Execute Immediate h_sql USING h_Trg_kpi_neg;
2318:

Line 2335: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| 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;
2338: Execute Immediate h_sql USING h_Trg_kpi_neg;
2339: BSC_MESSAGE.Add(x_message => SQLERRM,