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_METADATA_OPTIMIZER_PKG

Line 269: PROCEDURE InsertInDBMeasureCols(P_Measure_Col IN BSC_METADATA_OPTIMIZER_PKG.clsMeasureLov) IS

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
270:
271: l_stmt VARCHAR2(1000);
272: i NUMBER;
273:

Line 275: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

271: l_stmt VARCHAR2(1000);
272: i NUMBER;
273:
274: BEGIN
275: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
276: bsc_mo_helper_pkg.writeTmp( 'Inside InsertInDBMeasureCols, P_Measure_Col = ');
277: END IF;
278:
279: bsc_mo_helper_pkg.write_this(P_Measure_Col);

Line 285: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.first;

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;
286:
287: LOOP
288: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.count = 0;
289: INSERT INTO BSC_DB_MEASURE_COLS_TL (

Line 288: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.count = 0;

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

Line 292: VALUES (P_Measure_Col.fieldName, BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages(i), BSC_METADATA_OPTIMIZER_PKG.gLangCode,

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 );
294: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.last;
295: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.next(i);
296: END LOOP;

Line 294: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.last;

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 );
294: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.last;
295: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.next(i);
296: END LOOP;
297: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
298: bsc_mo_helper_pkg.writeTmp( 'Compl. InsertInDBMeasureCols');

Line 295: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.next(i);

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 );
294: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.last;
295: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.next(i);
296: END LOOP;
297: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
298: bsc_mo_helper_pkg.writeTmp( 'Compl. InsertInDBMeasureCols');
299: END IF;

Line 297: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

293: P_Measure_Col.Description, P_Measure_Col.groupCode, P_Measure_Col.prjMethod,P_Measure_Col.measureType );
294: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.last;
295: i := BSC_METADATA_OPTIMIZER_PKG.gInstalled_Languages.next(i);
296: END LOOP;
297: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
298: bsc_mo_helper_pkg.writeTmp( 'Compl. InsertInDBMeasureCols');
299: END IF;
300:
301:

Line 324: L_Measure_Col BSC_METADATA_OPTIMIZER_PKG.clsmeasureLov;

320: --***************************************************************************
321: /*
322: PROCEDURE AddInternalColumnInDB(internalColumn IN VARCHAR2, InternalColumnType NUMBER,
323: baseColumns IN dbms_sql.varchar2_table , numBaseColumns IN NUMBER) IS
324: L_Measure_Col BSC_METADATA_OPTIMIZER_PKG.clsmeasureLov;
325: i NUMBER;
326: prjMethod NUMBER;
327:
328:

Line 333: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));

329: l_temp number;
330: BEGIN
331:
332: L_Measure_Col.fieldName := internalColumn;
333: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));
334: L_Measure_Col.groupCode := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).groupCode;
335: L_Measure_Col.Description := BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'INTERNAL_COLUMN');
336:
337: IF (InternalColumnType =1) THEN

Line 334: L_Measure_Col.groupCode := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).groupCode;

330: BEGIN
331:
332: L_Measure_Col.fieldName := internalColumn;
333: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));
334: L_Measure_Col.groupCode := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).groupCode;
335: L_Measure_Col.Description := BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'INTERNAL_COLUMN');
336:
337: IF (InternalColumnType =1) THEN
338: --Formula

Line 360: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));

356: L_Measure_Col.prjMethod := 1; --Moving average has the lowest priority
357: i := baseColumns.first;
358: LOOP
359: EXIT WHEN baseColumns.count = 0;
360: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));
361: prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
362:
363: If prjMethod = 0 Then
364: --No forecast

Line 361: prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;

357: i := baseColumns.first;
358: LOOP
359: EXIT WHEN baseColumns.count = 0;
360: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));
361: prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
362:
363: If prjMethod = 0 Then
364: --No forecast
365: L_Measure_Col.prjMethod := 0;

Line 391: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));

387: --2: Balance
388: i := baseColumns.first;
389: LOOP
390: EXIT WHEN baseColumns.count = 0;
391: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));
392: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;
393: If L_Measure_Col.measureType = 2 Then
394: EXIT;
395: END IF;

Line 392: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;

388: i := baseColumns.first;
389: LOOP
390: EXIT WHEN baseColumns.count = 0;
391: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(i));
392: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;
393: If L_Measure_Col.measureType = 2 Then
394: EXIT;
395: END IF;
396: EXIT WHEN i = baseColumns.last;

Line 404: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));

400: --Total and counter for Average at Lowest Level
401:
402: --Projection method and type are the same of the base column
403: --In this case there is only one base column
404: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));
405: L_Measure_Col.prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
406: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;
407: END IF;
408:

Line 405: L_Measure_Col.prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;

401:
402: --Projection method and type are the same of the base column
403: --In this case there is only one base column
404: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));
405: L_Measure_Col.prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
406: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;
407: END IF;
408:
409: If Not sys_measure_exists(internalColumn, 'BSC') Then

Line 406: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;

402: --Projection method and type are the same of the base column
403: --In this case there is only one base column
404: l_temp := bsc_mo_helper_pkg.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, baseColumns(baseColumns.first));
405: L_Measure_Col.prjMethod := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
406: L_Measure_Col.measureType := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).measureType;
407: END IF;
408:
409: If Not sys_measure_exists(internalColumn, 'BSC') Then
410: IF (g_sys_measures.count>0) THEN

Line 425: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

421: g_sys_measures(l_temp).prjMethod := L_Measure_Col.prjMethod;
422: END IF;
423: InsertInDBMeasureCols( L_Measure_Col);
424:
425: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
426: bsc_mo_helper_pkg.writeTmp( 'Compl AddInternalColumnInDB');
427: END IF;
428:
429:

Line 490: OPEN c1(BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,

486: cRow c1%ROWTYPE;
487:
488: BEGIN
489:
490: OPEN c1(BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
491: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
492: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER,
493: dataColumn);
494: FETCH c1 INto cRow;

Line 491: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,

487:
488: BEGIN
489:
490: OPEN c1(BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
491: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
492: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER,
493: dataColumn);
494: FETCH c1 INto cRow;
495: If c1%NOTFOUND Then

Line 492: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER,

488: BEGIN
489:
490: OPEN c1(BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
491: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
492: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER,
493: dataColumn);
494: FETCH c1 INto cRow;
495: If c1%NOTFOUND Then
496: p_aggregation_method := null;

Line 578: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,

574: cv CurTyp;
575: l_measure_source varchar2(30);
576: BEGIN
577:
578: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
579: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
580: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;
582: LOOP

Line 579: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,

575: l_measure_source varchar2(30);
576: BEGIN
577:
578: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
579: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
580: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;
582: LOOP
583: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_id, l_measure_type, l_measure_source;

Line 580: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,

576: BEGIN
577:
578: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
579: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
580: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;
582: LOOP
583: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_id, l_measure_type, l_measure_source;
584: EXIT WHEN cv%NOTFOUND;

Line 581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;

577:
578: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
579: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
580: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
581: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER;
582: LOOP
583: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_id, l_measure_type, l_measure_source;
584: EXIT WHEN cv%NOTFOUND;
585: Measures := BSC_DBGEN_UTILS.get_measure_list(l_measure_name);

Line 1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,

1190: cv CurTyp;
1191: l_measure_source varchar2(30);
1192: BEGIN
1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);
1198:

Line 1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,

1191: l_measure_source varchar2(30);
1192: BEGIN
1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);
1198:
1199: LOOP

Line 1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,

1192: BEGIN
1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);
1198:
1199: LOOP
1200: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_source ;

Line 1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);

1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);
1198:
1199: LOOP
1200: FETCH cv INTO l_measure_name, l_aggregation_method, pFormulaSource, pAvgL, pAvgLTotal, pAvgLCounter, l_measure_source ;
1201: EXIT WHEN cv%NOTFOUND;

Line 1233: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, AvgLTotalColumn);

1229: baseColumn(0) := Measures(i);
1230: If AvgLTotalColumn IS NULL Then
1231: AvgLTotalColumn := get_Next_Internal_Column_Name;
1232: --Update the measure property pAvgLTotal in the database
1233: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, AvgLTotalColumn);
1234: END IF;
1235: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, AvgLTotalColumn);
1236: --AddInternalColumnInDB(AvgLTotalColumn, 2, baseColumn, 1);
1237: If AvgLCounterColumn IS NULL Then

Line 1240: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, AvgLCounterColumn);

1236: --AddInternalColumnInDB(AvgLTotalColumn, 2, baseColumn, 1);
1237: If AvgLCounterColumn IS NULL Then
1238: AvgLCounterColumn := get_Next_Internal_Column_Name;
1239: --Update the measure property pAvgLCounter in the database
1240: SetMeasurePropertyDB (Measures(i), BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, AvgLCounterColumn);
1241: END IF;
1242: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, AvgLCounterColumn);
1243: --AddInternalColumnInDB(AvgLCounterColumn, 3, baseColumn, 1);
1244: END IF;

Line 1279: raise bsc_metadata_optimizer_pkg.optimizer_exception ;

1275: END IF;
1276: END IF;
1277:
1278: ELSE
1279: raise bsc_metadata_optimizer_pkg.optimizer_exception ;
1280: EXIT ;
1281: END IF;
1282: EXIT WHEN i = Measures.last;
1283: i := Measures.next(i);

Line 1304: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, pAvgLTotal);

1300: --BSC_DB_MEASURES_COLS_TL table
1301: If pAvgLTotal IS NULL Then
1302: pAvgLTotal := get_Next_Internal_Column_Name ;
1303: --Update the measure property pAvgLTotal in the database
1304: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL, pAvgLTotal);
1305: END IF;
1306: --AddInternalColumnInDB(pAvgLTotal, 2, Measures, l_num_measures);
1307: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, pAvgLTotal);
1308: If pAvgLCounter IS NULL Then

Line 1311: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, pAvgLCounter);

1307: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_TOTAL_COLUMN, pAvgLTotal);
1308: If pAvgLCounter IS NULL Then
1309: pAvgLCounter := get_Next_Internal_Column_Name;
1310: --Update the measure property pAvgLTotal in the database
1311: SetMeasurePropertyDB( l_measure_name, BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, pAvgLCounter);
1312: END IF;
1313: --AddInternalColumnInDB( pAvgLCounter, 3, Measures, l_num_measures);
1314: bsc_dbgen_utils.add_property(l_measure.properties, BSC_DBGEN_STD_METADATA.AVGL_COUNTER_COLUMN, pAvgLCounter);
1315: END IF;

Line 2414: AND PROP.PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE

2410: SELECT kpi.indicator
2411: FROM BSC_KPIS_VL KPI,
2412: BSC_KPI_PROPERTIES PROP
2413: WHERE KPI.INDICATOR = PROP.INDICATOR
2414: AND PROP.PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE
2415: AND PROP.PROPERTY_VALUE = '2';
2416: l_facts DBMS_SQL.VARCHAR2_TABLE;
2417: Begin
2418: FOR i IN cAWFacts

Line 2578: AND PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;

2574: SELECT property_value
2575: FROM
2576: BSC_KPI_PROPERTIES
2577: WHERE INDICATOR = p_fact
2578: AND PROPERTY_CODE = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;
2579: l_impl_type varchar2(30);
2580:
2581: l_mv_level number;
2582: begin

Line 2888: IF BSC_MO_HELPER_PKG.FindIndex(BSC_METADATA_OPTIMIZER_PKG.g_bt_tables_tgt,p_b_table_name) = -1 THEN

2884: l_col_type2 := 'A';
2885: end if;
2886:
2887: --rkumar: modified for bug#5506476
2888: IF BSC_MO_HELPER_PKG.FindIndex(BSC_METADATA_OPTIMIZER_PKG.g_bt_tables_tgt,p_b_table_name) = -1 THEN
2889: open cSummary('BSC_S_'||p_fact);
2890: fetch cSummary into l_s_table;
2891: close cSummary;
2892: ELSE