DBA Data[Home] [Help]

APPS.BSC_MO_HELPER_PKG dependencies on BSC_KPI_DEFAULTS_TL

Line 5945: --Update the name of period of indicators in BSC_KPI_DEFAULTS_TL table

5941: WHERE INDICATOR = Indicador.Code;
5942: UPDATE bsc_sys_objective_colors
5943: SET obj_color = BSC_METADATA_OPTIMIZER_PKG.ColorG
5944: WHERE indicator = Indicador.Code;
5945: --Update the name of period of indicators in BSC_KPI_DEFAULTS_TL table
5946: --BSC Kpi => BSC Periodicity
5947: --Labels are in BSC_SYS_PERIODS_TL
5948: BEGIN
5949: UPDATE BSC_KPI_DEFAULTS_TL D

Line 5949: UPDATE BSC_KPI_DEFAULTS_TL D

5945: --Update the name of period of indicators in BSC_KPI_DEFAULTS_TL table
5946: --BSC Kpi => BSC Periodicity
5947: --Labels are in BSC_SYS_PERIODS_TL
5948: BEGIN
5949: UPDATE BSC_KPI_DEFAULTS_TL D
5950: SET PERIOD_NAME = (
5951: SELECT
5952: CASE WHEN NVL(C.EDW_CALENDAR_TYPE_ID, 0) = 0 AND P.YEARLY_FLAG = 1 THEN
5953: K.PERIODICITY_ID||'-'||C.FISCAL_YEAR

Line 5982: writeTmp('Ignoring Error while updating BSC_KPI_DEFAULTS_TL in InitializeYear for Indic= '||Indicador.code||':'||sqlerrm);

5978: )
5979: WHERE
5980: INDICATOR = Indicador.Code;
5981: EXCEPTION WHEN OTHERS THEN
5982: writeTmp('Ignoring Error while updating BSC_KPI_DEFAULTS_TL in InitializeYear for Indic= '||Indicador.code||':'||sqlerrm);
5983: END;
5984: --Update date of indicator
5985: UPDATE BSC_KPI_DEFAULTS_B SET LAST_UPDATE_DATE = SYSDATE WHERE INDICATOR = Indicador.Code;
5986: --EXECUTE IMMEDIATE l_stmt USING Indicador.Code;