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_INDICATOR_PKG dependencies on BSC_DB_MEASURE_COLS_TL

Line 2997: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL

2993: --****************************************************************************
2994: --InsertDataColumnInDBMeasureCols
2995: --
2996: -- DESCRIPTION:
2997: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL
2998: --
2999: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
3000: --***************************************************************************
3001: PROCEDURE InsertInDBMeasureCols(p_measure IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLOV) IS

Line 3013: l_stmt := 'DELETE FROM BSC_DB_MEASURE_COLS_TL WHERE MEASURE_COL = :1';

3009: END IF;
3010:
3011: bsc_mo_helper_pkg.write_this(p_measure);
3012: --Delete the records if exists
3013: l_stmt := 'DELETE FROM BSC_DB_MEASURE_COLS_TL WHERE MEASURE_COL = :1';
3014: EXECUTE IMMEDIATE l_stmt using p_measure.fieldName;
3015:
3016: --Because it is a TL table, we need to insert the record for every supported language
3017: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.first;

Line 3021: INSERT INTO BSC_DB_MEASURE_COLS_TL (

3017: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.first;
3018:
3019: LOOP
3020: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.count = 0;
3021: INSERT INTO BSC_DB_MEASURE_COLS_TL (
3022: MEASURE_COL, LANGUAGE, SOURCE_LANG,
3023: HELP, MEASURE_GROUP_ID, PROJECTION_ID, MEASURE_TYPE)
3024: VALUES (p_measure.fieldName, BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages(i), BSC_METADATA_OPTIMIZER_PKG.gLangCode,
3025: p_measure.Description, p_measure.groupCode, p_measure.prjMethod,p_measure.measureType );

Line 3046: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL

3042: --****************************************************************************
3043: --AddInternalColumnInDB
3044: --
3045: -- DESCRIPTION:
3046: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL
3047: -- and also added to the collection gLov.
3048: -- Projection method and type (balance or statistic) are deduced from
3049: -- the base columns.
3050: --