APPS.BSC_MO_LOADER_CONFIG_PKG dependencies on BSC_KPI_DATA_TABLES

Line 192: FROM BSC_KPI_DATA_TABLES

188: cv CurTyp ;
189:
190: CURSOR cLevelCombinations (pIndicator IN NUMBER, pDimSetID IN NUMBER) IS
191: SELECT PERIODICITY_ID, LEVEL_COMB
192: FROM BSC_KPI_DATA_TABLES
193: WHERE INDICATOR = pIndicator
194: AND DIM_SET_ID = pDimSetID;
195: BEGIN
196: IF (BSC_METADATA_OPTIMIZER_PKG.gIndicators.count =0) THEN

Line 223: --l_stmt := 'SELECT PERIODICITY_ID, LEVEL_COMB FROM BSC_KPI_DATA_TABLES WHERE INDICATOR = :1 AND DIM_SET_ID = :2';

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);
225: LOOP
226: FETCH cLevelCombinations INTO l_periodicity_id, strDriles;
227: EXIT WHEN cLevelCombinations%NOTFOUND;

Line 237: bsc_mo_helper_pkg.writeTmp('UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = '||

233: substr(strDriles, levelPos - Length(strDriles) );
234: END LOOP;
235:
236: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
237: bsc_mo_helper_pkg.writeTmp('UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = '||
238: strDriles||' WHERE INDICATOR = '|| Indicator.Code||' AND DIM_SET_ID = '||
239: Configuracion||' AND PERIODICITY_ID = '|| l_periodicity_id||' AND LEVEL_COMB = '||strDrilesAnt, FND_LOG.LEVEL_STATEMENT);
240: END IF;
241:

Line 242: UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = strDriles

238: strDriles||' WHERE INDICATOR = '|| Indicator.Code||' AND DIM_SET_ID = '||
239: Configuracion||' AND PERIODICITY_ID = '|| l_periodicity_id||' AND LEVEL_COMB = '||strDrilesAnt, FND_LOG.LEVEL_STATEMENT);
240: END IF;
241:
242: UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = strDriles
243: WHERE INDICATOR = Indicator.Code AND DIM_SET_ID = Configuracion
244: AND PERIODICITY_ID = l_periodicity_id AND LEVEL_COMB = strDrilesAnt;
245: --EXECUTE IMMEDIATE l_stmt USING strDriles, Indicator.Code, Configuracion, l_periodicity_id, strDrilesAnt;
246:

Line 288: FROM BSC_KPI_DATA_TABLES_V

284: end_year NUMBER;
285:
286: CURSOR c1 IS
287: SELECT DISTINCT TABLE_NAME, PERIODICITY_ID
288: FROM BSC_KPI_DATA_TABLES_V
289: WHERE INDICATOR = indic
290: AND TABLE_NAME IS NOT NULL;
291: l_temp NUMBER;
292: BEGIN

Line 512: SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES_V

508: arrIndicTables OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE, numIndicTables OUT NOCOPY NUMBER) IS
509:
510: l_STMT VARCHAR2(1000);
511: CURSOR C1 (p1 NUMBER, p2 NUMBER) IS
512: SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES_V
513: WHERE INDICATOR = p1
514: AND DIM_SET_ID = p2
515: AND TABLE_NAME IS NOT NULL;
516:

Line 521: FROM BSC_KPI_DATA_TABLES_V

517: CURSOR c2 (p1 NUMBER, p2 NUMBER) IS
518: SELECT DISTINCT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
519: WHERE TABLE_NAME IN (
520: SELECT TABLE_NAME
521: FROM BSC_KPI_DATA_TABLES_V
522: WHERE INDICATOR = p1
523: AND DIM_SET_ID = p2
524: AND TABLE_NAME IS NOT NULL)
525: AND RELATION_TYPE = 1;

Line 1358: FROM bsc_kpi_data_tables

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
1361: AND sql_stmt IS NOT NULL)
1362: AND CALCULATION_TYPE = 4 ;

Line 1588: --the sql statements configured in BSC_KPI_DATA_TABLES for zero codes

1584: END LOOP;
1585: End If;
1586: END LOOP;
1587: --Fix bug#3350103 If the user change the rollup method we need to update
1588: --the sql statements configured in BSC_KPI_DATA_TABLES for zero codes
1589: If BSC_METADATA_OPTIMIZER_PKG.g_BSC_MV Then
1590:
1591: OPEN cRollups(indic, Configuracion);
1592: bsc_mo_helper_pkg.addStack (l_stack, ' Chk 8');

Line 1602: l_stmt := ' UPDATE bsc_kpi_data_tables '||

1598: END Loop;
1599: Close cRollups;
1600: If zeroCodeDataColumns IS NOT NULL Then
1601: bsc_mo_helper_pkg.addStack (l_stack, ' Chk 9');
1602: l_stmt := ' UPDATE bsc_kpi_data_tables '||
1603: ' SET sql_stmt = SUBSTR(sql_stmt, 1, INSTR(sql_stmt, ''PERIOD_TYPE_ID'') - 1)||''PERIOD_TYPE_ID''||'''|| zeroCodeDataColumns || '''|| '||
1604: ' SUBSTR(sql_stmt, INSTR(sql_stmt, '' FROM ''))'||
1605: ' WHERE indicator = :1 ' ||
1606: ' AND dim_set_id = :2 ' ||