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_DB_CALCULATIONS

Line 778: TYPE tab_clsDBCalculations IS TABLE OF BSC_DB_CALCULATIONS%ROWTYPE index by binary_integer;

774: TYPE tab_clsDBTables IS TABLE OF BSC_DB_TABLES%ROWTYPE index by binary_integer;
775: l_db_tables_record BSC_DB_TABLES%ROWTYPE ;
776: l_tab_db_tables tab_clsDBTables;
777:
778: TYPE tab_clsDBCalculations IS TABLE OF BSC_DB_CALCULATIONS%ROWTYPE index by binary_integer;
779: l_db_calculations_record BSC_DB_CALCULATIONS%ROWTYPE ;
780: l_tab_db_calculations tab_clsDBCalculations;
781:
782: TYPE tab_clsDBTablesCols IS TABLE OF BSC_DB_TABLES_COLS%ROWTYPE index by binary_integer;

Line 779: l_db_calculations_record BSC_DB_CALCULATIONS%ROWTYPE ;

775: l_db_tables_record BSC_DB_TABLES%ROWTYPE ;
776: l_tab_db_tables tab_clsDBTables;
777:
778: TYPE tab_clsDBCalculations IS TABLE OF BSC_DB_CALCULATIONS%ROWTYPE index by binary_integer;
779: l_db_calculations_record BSC_DB_CALCULATIONS%ROWTYPE ;
780: l_tab_db_calculations tab_clsDBCalculations;
781:
782: TYPE tab_clsDBTablesCols IS TABLE OF BSC_DB_TABLES_COLS%ROWTYPE index by binary_integer;
783: l_db_tables_cols_record BSC_DB_TABLES_COLS%ROWTYPE ;

Line 839: DELETE FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = l_tbl_delete(i) AND CALCULATION_TYPE in (l_calc4,l_calc5);

835: DELETE FROM BSC_DB_TABLES_RELS WHERE TABLE_NAME = l_tbl_delete(i);
836: FORALL i IN 1..l_tbl_delete.count
837: DELETE FROM BSC_DB_TABLES WHERE TABLE_NAME = l_tbl_delete(i);
838: FORALL i IN 1..l_tbl_delete.count
839: DELETE FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = l_tbl_delete(i) AND CALCULATION_TYPE in (l_calc4,l_calc5);
840: FORALL i IN 1..l_tbl_delete.count
841: DELETE FROM BSC_DB_TABLES_COLS WHERE TABLE_NAME = l_tbl_delete(i) AND COLUMN_TYPE in (l_colP,l_colA);
842: l_tab_rels.delete;
843: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.first;

Line 977: --BSC_DB_CALCULATIONS (Calculation of zero code)

973: l_db_tables_record.EDW_FLAG := EDW_Flag;
974: l_db_tables_record.TARGET_FLAG := Target_Flag;
975: l_tab_db_tables(l_tab_db_tables.count+1) := l_db_tables_record;
976:
977: --BSC_DB_CALCULATIONS (Calculation of zero code)
978:
979: numZeroCodeKeys := 0;
980: IF (Tabla_keyname.count >0 ) THEN
981: l_index2 := Tabla_keyname.first;

Line 1021: --BSC_DB_CALCULATIONS (Merge targets)

1017: EXIT WHEN l_index2 = Tabla_Data.last;
1018: l_index2 := Tabla_Data.next(l_index2);
1019: END LOOP;
1020: END LOOP;
1021: --BSC_DB_CALCULATIONS (Merge targets)
1022:
1023: IF (Tabla_originTable1.count>0) THEN
1024: l_index2 := Tabla_originTable1.first;
1025: LOOP

Line 1126: --BSC_DB_CALCULATIONS

1122: END IF;
1123: If getLevelIndex(Tabla.Indicator, Tabla.Configuration, Dril1) = 1 Then
1124: --This is the table for the first drill (account drill).
1125: --We need to calculate the profit
1126: --BSC_DB_CALCULATIONS
1127: l_db_calc_1_delete(l_db_calc_1_delete.count+1) := UPPER(Tabla.Name);
1128: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1129: BSC_MO_HELPER_PKG.writeTmp('INSERT DB_CALCULATIONS3:'||Tabla.Name||',1,'|| Dril1||' '||bsc_mo_helper_pkg.get_time);
1130: END IF;

Line 1212: DELETE FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = l_db_calc_1_delete(i) AND CALCULATION_TYPE = 1;

1208: BSC_MO_HELPER_PKG.writeTmp('Checkpoint 11 '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, false);
1209:
1210: --BULK DELETES
1211: FORALL i IN 1..l_db_calc_1_delete.count
1212: DELETE FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = l_db_calc_1_delete(i) AND CALCULATION_TYPE = 1;
1213:
1214: FORALL i IN 1..l_db_cols_1_delete_table_name.count
1215: DELETE FROM BSC_DB_TABLES_COLS WHERE TABLE_NAME=l_db_cols_1_delete_table_name(i) AND column_name=l_db_cols_1_delete_field_name(i) and column_type='A';
1216:

Line 1237: INSERT INTO BSC_DB_CALCULATIONS VALUES l_tab_db_calculations(i);

1233: END;
1234:
1235: BEGIN
1236: FORALL i IN 1..l_tab_db_calculations.count
1237: INSERT INTO BSC_DB_CALCULATIONS VALUES l_tab_db_calculations(i);
1238: EXCEPTION
1239: WHEN others THEN
1240:
1241: bsc_mo_helper_pkg.writeTmp('Insert calculations: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);

Line 1356: SELECT DISTINCT parameter3, parameter5 FROM bsc_db_calculations

1352: cv CurTyp ;
1353: l_stack varchar2(32000);
1354:
1355: CURSOR cRollups(pIndicator IN NUMBER, pDimSetID IN NUMBER) IS
1356: SELECT DISTINCT parameter3, parameter5 FROM bsc_db_calculations
1357: WHERE table_name IN (SELECT table_name
1358: FROM bsc_kpi_data_tables
1359: WHERE indicator = pIndicator
1360: AND dim_set_id = pDimSetID

Line 1453: --BSC_DB_CALCULATIONS (Zero code calculation)

1449: END IF;
1450: End If;
1451: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt2 ');
1452: End If;
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('||

Line 1469: l_stmt := 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2 '||

1465: --If the table does not calculate zero code then no record is inserted
1466: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1467: BSC_MO_HELPER_PKG.writeTmp('4 INSERT DB_CALCULATIONS:');
1468: END IF;
1469: l_stmt := 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2 '||
1470: ', PARAMETER3, PARAMETER4, PARAMETER5) '||
1471: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2, :1, parameter4, :2 FROM BSC_DB_CALCULATIONS '||
1472: ' WHERE TABLE_NAME = :3 AND CALCULATION_TYPE = 4';
1473: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.1, L_STMT = '||l_stmt);

Line 1471: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2, :1, parameter4, :2 FROM BSC_DB_CALCULATIONS '||

1467: BSC_MO_HELPER_PKG.writeTmp('4 INSERT DB_CALCULATIONS:');
1468: END IF;
1469: l_stmt := 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2 '||
1470: ', PARAMETER3, PARAMETER4, PARAMETER5) '||
1471: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2, :1, parameter4, :2 FROM BSC_DB_CALCULATIONS '||
1472: ' WHERE TABLE_NAME = :3 AND CALCULATION_TYPE = 4';
1473: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.1, L_STMT = '||l_stmt);
1474: INSERT INTO BSC_DB_CALCULATIONS
1475: (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2

Line 1474: INSERT INTO BSC_DB_CALCULATIONS

1470: ', PARAMETER3, PARAMETER4, PARAMETER5) '||
1471: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2, :1, parameter4, :2 FROM BSC_DB_CALCULATIONS '||
1472: ' WHERE TABLE_NAME = :3 AND CALCULATION_TYPE = 4';
1473: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.1, L_STMT = '||l_stmt);
1474: INSERT INTO BSC_DB_CALCULATIONS
1475: (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2
1476: , PARAMETER3, PARAMETER4, PARAMETER5)
1477: SELECT DISTINCT
1478: TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2,

Line 1480: FROM BSC_DB_CALCULATIONS

1476: , PARAMETER3, PARAMETER4, PARAMETER5)
1477: SELECT DISTINCT
1478: TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2,
1479: l_measure.fieldName, parameter4, ZeroCodeOrigin
1480: FROM BSC_DB_CALCULATIONS
1481: WHERE TABLE_NAME = UPPER(arrTables(i)) AND CALCULATION_TYPE = 4;
1482: Else
1483: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1484: BSC_MO_HELPER_PKG.writeTmp('4 UPDATE DB_CALCULATIONS:');

Line 1487: l_stmt := 'UPDATE BSC_DB_CALCULATIONS SET PARAMETER5 = :1 WHERE '||

1483: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1484: BSC_MO_HELPER_PKG.writeTmp('4 UPDATE DB_CALCULATIONS:');
1485: END IF;
1486: --If the table does not calculate zero code then no record is updated
1487: l_stmt := 'UPDATE BSC_DB_CALCULATIONS SET PARAMETER5 = :1 WHERE '||
1488: ' TABLE_NAME = :2 AND PARAMETER3 = :3 AND CALCULATION_TYPE = 4 ';
1489: bsc_mo_helper_pkg.writeTmp(' Chkpt4.2, L_STMT = '||l_stmt||', :1='||ZeroCodeOrigin||', :2='||UPPER(arrTables(i))||', :3='||
1490: l_measure.fieldName);
1491: UPDATE BSC_DB_CALCULATIONS

Line 1491: UPDATE BSC_DB_CALCULATIONS

1487: l_stmt := 'UPDATE BSC_DB_CALCULATIONS SET PARAMETER5 = :1 WHERE '||
1488: ' TABLE_NAME = :2 AND PARAMETER3 = :3 AND CALCULATION_TYPE = 4 ';
1489: bsc_mo_helper_pkg.writeTmp(' Chkpt4.2, L_STMT = '||l_stmt||', :1='||ZeroCodeOrigin||', :2='||UPPER(arrTables(i))||', :3='||
1490: l_measure.fieldName);
1491: UPDATE BSC_DB_CALCULATIONS
1492: SET PARAMETER5 = ZeroCodeOrigin
1493: WHERE
1494: TABLE_NAME = UPPER(arrTables(i))
1495: AND PARAMETER3 = l_measure.fieldName

Line 1498: --BSC_DB_CALCULATIONS (Merge targets)

1494: TABLE_NAME = UPPER(arrTables(i))
1495: AND PARAMETER3 = l_measure.fieldName
1496: AND CALCULATION_TYPE = 4 ;
1497: End If;
1498: --BSC_DB_CALCULATIONS (Merge targets)
1499: --No changes for current columns
1500: If newColumnFlag Then
1501: --This is a internal column that was added to the indicator table
1502: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 1505: l_stmt:= 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2) '||

1501: --This is a internal column that was added to the indicator table
1502: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1503: BSC_MO_HELPER_PKG.writeTmp('5 INSERT DB_CALCULATIONS:');
1504: END IF;
1505: l_stmt:= 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2) '||
1506: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, :2'||
1507: ' FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = :2 AND CALCULATION_TYPE = 5';
1508: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.3, L_STMT = '||l_stmt);
1509: INSERT INTO BSC_DB_CALCULATIONS(TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2)

Line 1507: ' FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = :2 AND CALCULATION_TYPE = 5';

1503: BSC_MO_HELPER_PKG.writeTmp('5 INSERT DB_CALCULATIONS:');
1504: END IF;
1505: l_stmt:= 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2) '||
1506: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, :2'||
1507: ' FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = :2 AND CALCULATION_TYPE = 5';
1508: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.3, L_STMT = '||l_stmt);
1509: INSERT INTO BSC_DB_CALCULATIONS(TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2)
1510: SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, l_measure.fieldName
1511: FROM BSC_DB_CALCULATIONS

Line 1509: INSERT INTO BSC_DB_CALCULATIONS(TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2)

1505: l_stmt:= 'INSERT INTO BSC_DB_CALCULATIONS (TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2) '||
1506: ' SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, :2'||
1507: ' FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = :2 AND CALCULATION_TYPE = 5';
1508: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.3, L_STMT = '||l_stmt);
1509: INSERT INTO BSC_DB_CALCULATIONS(TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2)
1510: SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, l_measure.fieldName
1511: FROM BSC_DB_CALCULATIONS
1512: WHERE TABLE_NAME = UPPER(arrTables(i))
1513: AND CALCULATION_TYPE = 5;

Line 1511: FROM BSC_DB_CALCULATIONS

1507: ' FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = :2 AND CALCULATION_TYPE = 5';
1508: bsc_mo_helper_pkg.addStack (l_stack, ' Chkpt4.3, L_STMT = '||l_stmt);
1509: INSERT INTO BSC_DB_CALCULATIONS(TABLE_NAME, CALCULATION_TYPE, PARAMETER1, PARAMETER2)
1510: SELECT DISTINCT TABLE_NAME, CALCULATION_TYPE, PARAMETER1, l_measure.fieldName
1511: FROM BSC_DB_CALCULATIONS
1512: WHERE TABLE_NAME = UPPER(arrTables(i))
1513: AND CALCULATION_TYPE = 5;
1514: End If;
1515: --BSC_DB_TABLES_COLS