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_MO_HELPER_PKG dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 6604: UPDATE bsc_kpi_analysis_measures_b

6600: WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6601: -- Color By KPI: Mark KPIs to Production mode in tendem with Objective's prototype flag.
6602: -- This is done so that both Objective and underlying KPIs come with the same color in IViewer,
6603: -- once GDB is run for the Objective. i.e. DARK_GRAY color
6604: UPDATE bsc_kpi_analysis_measures_b
6605: SET prototype_flag = 0
6606: WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6607: --Execute IMMEDIATE l_stmt USING BSC_METADATA_OPTIMIZER_PKG.gUserId, BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6608: writeTmp('Updating prototype_flag=0 for indicator='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code||' from old value='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Action_Flag, FND_LOG.LEVEL_STATEMENT, false);

Line 6616: UPDATE bsc_kpi_analysis_measures_b

6612: LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserId,
6613: LAST_UPDATE_DATE = SYSDATE
6614: WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6615: -- Color By KPI: Mark KPIs for color re-calculation
6616: UPDATE bsc_kpi_analysis_measures_b
6617: SET prototype_flag = 7
6618: WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6619: --Execute IMMEDIATE l_stmt USING BSC_METADATA_OPTIMIZER_PKG.gUserId, BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6620: writeTmp('Updating prototype_flag=6 for indicator='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code||' from old value='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Action_Flag, FND_LOG.LEVEL_STATEMENT, false);

Line 6629: UPDATE bsc_kpi_analysis_measures_b

6625: LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserId,
6626: LAST_UPDATE_DATE = SYSDATE
6627: WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6628: -- Color By KPI: Mark KPIs for color re-calculation
6629: UPDATE bsc_kpi_analysis_measures_b
6630: SET prototype_flag = 7
6631: WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;
6632: writeTmp('Updating prototype_flag=6 for indicator='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code||' from old value='||BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Action_Flag, FND_LOG.LEVEL_STATEMENT, false);
6633: END IF;

Line 6641: /*UPDATE BSC_KPI_ANALYSIS_MEASURES_B

6637: END LOOP;
6638:
6639: --BSC-PMF Integration: Update ALL PMF measures to production mode
6640: -- no need
6641: /*UPDATE BSC_KPI_ANALYSIS_MEASURES_B
6642: SET PROTOTYPE_FLAG = 0
6643: WHERE DATASET_ID IN (
6644: SELECT DATASET_ID FROM BSC_SYS_DATASETS_B
6645: WHERE NVL(SOURCE, 'BSC') = 'PMF')