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

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

261: --****************************************************************************
262: --InsertDataColumnInDBMeasureCols
263: --
264: -- DESCRIPTION:
265: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL
266: --
267: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
268: --***************************************************************************
269: PROCEDURE InsertInDBMeasureCols(P_Measure_Col IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLov) IS

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

277: END IF;
278:
279: bsc_mo_helper_pkg.write_this(P_Measure_Col);
280: --Delete the records if exists
281: l_stmt := 'DELETE FROM BSC_DB_MEASURE_COLS_TL WHERE MEASURE_COL = :1';
282: EXECUTE IMMEDIATE l_stmt using P_Measure_Col.fieldName;
283:
284: --Because it is a TL table, we need to insert the record for every supported language
285: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.first;

Line 289: INSERT INTO BSC_DB_MEASURE_COLS_TL (

285: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.first;
286:
287: LOOP
288: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.count = 0;
289: INSERT INTO BSC_DB_MEASURE_COLS_TL (
290: MEASURE_COL, LANGUAGE, SOURCE_LANG,
291: HELP, MEASURE_GROUP_ID, PROJECTION_ID, MEASURE_TYPE)
292: VALUES (P_Measure_Col.fieldName, BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages(i), BSC_METADATA_OPTIMIZER_PKG.gLangCode,
293: P_Measure_Col.Description, P_Measure_Col.groupCode, P_Measure_Col.prjMethod,P_Measure_Col.measureType );

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

310: --****************************************************************************
311: --AddInternalColumnInDB
312: --
313: -- DESCRIPTION:
314: -- Creates the record for the internal column in BSC_DB_MEASURE_COLS_TL
315: -- and also added to the collection gLov.
316: -- Projection method and type (balance or statistic) are deduced from
317: -- the base columns.
318: --