[Home] [Help]
3987: B.RANGE_YR_MOD,
3988: NVL(B.EDW_CALENDAR_TYPE_ID, 0) SOURCE,
3989: (
3990: NVL((SELECT MAX(NUM_OF_YEARS - PREVIOUS_YEARS)
3991: FROM BSC_KPI_PERIODICITIES
3992: WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
3993: PERIODICITY_ID IN (SELECT PERIODICITY_ID
3994: FROM BSC_SYS_PERIODICITIES S
3995: WHERE S.CALENDAR_ID = B.CALENDAR_ID))
3996: , 1)
3997: ) AS MAX_FORYEAR,
3998: (
3999: NVL((SELECT MAX(PREVIOUS_YEARS)
4000: FROM BSC_KPI_PERIODICITIES
4001: WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
4002: PERIODICITY_ID IN (SELECT PERIODICITY_ID
4003: FROM BSC_SYS_PERIODICITIES S
4004: WHERE S.CALENDAR_ID = B.CALENDAR_ID))
5921: LOOP
5922: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gIndicators.count = 0;
5923: Indicador := BSC_METADATA_OPTIMIZER_PKG.gIndicators(l_index1);
5924: IF Indicador.Action_Flag = 3 THEN
5925: --Update indicators current period in BSC_KPI_PERIODICITIES
5926: --IF the periodicity is not yearly then the period need to be 1,
5927: --otherwise the period ned to be the current fiscal year of the calendar
5928: UPDATE BSC_KPI_PERIODICITIES K
5929: SET CURRENT_PERIOD =
5924: IF Indicador.Action_Flag = 3 THEN
5925: --Update indicators current period in BSC_KPI_PERIODICITIES
5926: --IF the periodicity is not yearly then the period need to be 1,
5927: --otherwise the period ned to be the current fiscal year of the calendar
5928: UPDATE BSC_KPI_PERIODICITIES K
5929: SET CURRENT_PERIOD =
5930: (SELECT DECODE(P.YEARLY_FLAG, 1, C.FISCAL_YEAR, 1)
5931: FROM BSC_SYS_PERIODICITIES P, BSC_SYS_CALENDARS_B C
5932: WHERE K.PERIODICITY_ID = P.PERIODICITY_ID
5954: ELSE
5955: (SELECT
5956: K.PERIODICITY_ID||'-'||L.NAME
5957: FROM
5958: BSC_KPI_PERIODICITIES KP,
5959: BSC_SYS_PERIODS_TL L
5960: WHERE
5961: K.INDICATOR = KP.INDICATOR AND
5962: K.PERIODICITY_ID = KP.PERIODICITY_ID AND