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_LOADER_CONFIG_PKG dependencies on BSC_MO_INDICATOR_PKG

Line 207: colConfiguraciones := BSC_MO_INDICATOR_PKG.GetConfigurationsForIndic(Indicator.Code);

203: --BSC-MV Note: If there is change of summarization level
204: --we need to process all the indicators.
205: If (Indicator.Action_Flag = 3) Or (Indicator.Action_Flag <> 2 And BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0) Then
206: --Get the list of configurations of the kpi
207: colConfiguraciones := BSC_MO_INDICATOR_PKG.GetConfigurationsForIndic(Indicator.Code);
208: IF (colConfiguraciones.count > 0) THEN
209: l_index2 := colConfiguraciones.first;
210: END IF;
211: LOOP

Line 220: colDimensions := BSC_MO_INDICATOR_PKG.GetLevelCollection(Indicator.Code, Configuracion);

216: bsc_mo_helper_pkg.writeTmp('# of phantom levels = '||numPhantomLevels);
217: END IF;
218: If numPhantomLevels > 0 Then
219: --Get the list of drills of the kpi in the given configuration
220: colDimensions := BSC_MO_INDICATOR_PKG.GetLevelCollection(Indicator.Code, Configuracion);
221: If colDimensions.Count > 0 Then
222: --Only fix those having at least one family of drills
223: --l_stmt := 'SELECT PERIODICITY_ID, LEVEL_COMB FROM BSC_KPI_DATA_TABLES WHERE INDICATOR = :1 AND DIM_SET_ID = :2';
224: OPEN cLevelCombinations(Indicator.Code, Configuracion);

Line 1000: ZeroCodeOrigin := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn || ')/SUM('

996: LOOP
997: EXIT WHEN Tabla_Data.count = 0;
998: l_measure := Tabla_Data(l_index2);
999: If l_measure.AvgLFlag = 'Y' Then
1000: ZeroCodeOrigin := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn || ')/SUM('
1001: || l_measure.AvgLCounterColumn || ')');
1002: Else
1003: ZeroCodeOrigin := l_measure.aggFunction|| '('|| l_measure.fieldName || ')';
1004: End If;

Line 1115: If BSC_MO_INDICATOR_PKG.IsIndicatorPnL(Tabla.Indicator, true ) Then

1111: If Tabla.Indicator <> 0 Then
1112: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1113: BSC_MO_HELPER_PKG.writeTmp('Indicator<>0');
1114: END IF;
1115: If BSC_MO_INDICATOR_PKG.IsIndicatorPnL(Tabla.Indicator, true ) Then
1116: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1117: BSC_MO_HELPER_PKG.writeTmp('Indicator is PnL');
1118: END IF;
1119: --This is a table of a PnL indicator

Line 1370: colConfiguraciones := BSC_MO_INDICATOR_PKG.GetConfigurationsForIndic(Indic);

1366: l_cols_used VARCHAR2(32000);
1367: BEGIN
1368: bsc_mo_helper_pkg.writeTmp('Inside ReConfigureUploadFieldsIndic');
1369: --Get the list of configurations of the kpi
1370: colConfiguraciones := BSC_MO_INDICATOR_PKG.GetConfigurationsForIndic(Indic);
1371: IF (colConfiguraciones.count=0) THEN
1372: bsc_mo_helper_pkg.writeTmp('Completed ReConfigureUploadFieldsIndic, 0 count');
1373: return;
1374: END IF;

Line 1386: colDatos := BSC_MO_INDICATOR_PKG.GetDataFields(Indic, Configuracion, True);

1382: --IndicTables() contains the tables used direclty by the indicator in the given configuration
1383: --including the target tables created for the indicator
1384: InitarrTablesIndic( Indic, Configuracion, arrTables, numTables, arrIndicTables, numIndicTables);
1385: --Initialize the collection of data columns of the indicator
1386: colDatos := BSC_MO_INDICATOR_PKG.GetDataFields(Indic, Configuracion, True);
1387: bsc_mo_helper_pkg.write_this(colDatos, FND_LOG.LEVEL_STATEMENT, false);
1388: --Reconfigure
1389: --The only non-structural changes that could happen are:
1390: --Change in the rollup method

Line 1415: l_table_name := BSC_MO_INDICATOR_PKG.GetProjectionTableName(arrTables(i));

1411: --need to add this new column to the projection table.
1412: If BSC_METADATA_OPTIMIZER_PKG.G_BSC_MV Then
1413: l_optimizationMode := bsc_mo_helper_pkg.getKPIPropertyValue(Indic, 'DB_TRANSFORM', 1);
1414: IF (l_optimizationMode = 2) THEN -- targets at different levels, PT tables shd exist
1415: l_table_name := BSC_MO_INDICATOR_PKG.GetProjectionTableName(arrTables(i));
1416: ELSE
1417: l_table_name := arrTables(i);
1418: END IF;
1419: Else

Line 1457: ZeroCodeOrigin := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn ||')/SUM('||

1453: --BSC_DB_CALCULATIONS (Zero code calculation)
1454: If ((l_table_type = 3) Or (l_table_type = 4)) And (l_measure.AvgLFlag = 'Y') Then
1455: --This is table used directly by the indicator
1456: --and the data is AVGL
1457: ZeroCodeOrigin := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn ||')/SUM('||
1458: l_measure.AvgLCounterColumn ||')');
1459: Else
1460: ZeroCodeOrigin := l_measure.aggFunction || '(' || l_measure.fieldName || ')';
1461: End If;

Line 1527: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression(l_measure.aggFunction|| '(' ||

1523: --Case 0 --Normal (Non-Internal column)
1524: l_source := l_measure.aggFunction|| '(' || l_measure.fieldName || ')';
1525: ELSIF (l_measure.InternalColumnType=1) THEN
1526: --Case 1 --Formula at lowest level
1527: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression(l_measure.aggFunction|| '(' ||
1528: l_measure.InternalColumnSource || ')');
1529: ELSIF (l_measure.InternalColumnType=2) THEN
1530: --Case 2 --Total for Average at Lowest Level
1531: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.InternalColumnSource || ')');

Line 1531: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.InternalColumnSource || ')');

1527: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression(l_measure.aggFunction|| '(' ||
1528: l_measure.InternalColumnSource || ')');
1529: ELSIF (l_measure.InternalColumnType=2) THEN
1530: --Case 2 --Total for Average at Lowest Level
1531: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.InternalColumnSource || ')');
1532: ELSIF (l_measure.InternalColumnType=3) THEN
1533: --Case 3 --Counter for Average at Lowest Level
1534: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('COUNT(' || l_measure.InternalColumnSource || ')');
1535: End IF;

Line 1534: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('COUNT(' || l_measure.InternalColumnSource || ')');

1530: --Case 2 --Total for Average at Lowest Level
1531: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.InternalColumnSource || ')');
1532: ELSIF (l_measure.InternalColumnType=3) THEN
1533: --Case 3 --Counter for Average at Lowest Level
1534: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('COUNT(' || l_measure.InternalColumnSource || ')');
1535: End IF;
1536: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt5.1, l_source = '||l_source);
1537: ELSIF (l_table_type =4) THEN
1538: --Case 4

Line 1541: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn || ')/SUM('||

1537: ELSIF (l_table_type =4) THEN
1538: --Case 4
1539: --The table is originated from another indicator table
1540: If l_measure.AvgLFlag = 'Y' Then
1541: l_source := BSC_MO_INDICATOR_PKG.GetFreeDivZeroExpression('SUM(' || l_measure.AvgLTotalColumn || ')/SUM('||
1542: l_measure.AvgLCounterColumn || ')');
1543: Else
1544: l_source := l_measure.aggFunction || '(' || l_measure.fieldName || ')';
1545: End If;