APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_PERIODS_TL

Line 5873: --BSC_SYS_PERIODS_TL, etc

5869: EXIT WHEN BSC_METADATA_OPTIMIZER_PKG.gCalendars.count=0;
5870: Calendar := BSC_METADATA_OPTIMIZER_PKG.gCalendars(l_index1);
5871: --BIS DIMENSIONS: We cannot call Populate_Calendar_Tables for BIS Calendars
5872: --The API that imported the BIS Calendars already populated BSC_DB_CALENDAR and
5873: --BSC_SYS_PERIODS_TL, etc
5874: IF Calendar.Source = 'BSC' THEN
5875: --BSC Calendar
5876: BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);
5877: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');

Line 5908: --BSC_SYS_PERIODS_TL, etc

5904: End IF;
5905:
5906: --BIS DIMENSIONS: We cannot call Populate_Calendar_Tables for BIS Calendars
5907: --The API that imported the BIS Calendars already populated BSC_DB_CALENDAR and
5908: --BSC_SYS_PERIODS_TL, etc
5909:
5910: End IF;
5911: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gCalendars.last;
5912: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gCalendars.next(l_index1);

Line 5947: --Labels are in BSC_SYS_PERIODS_TL

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
5950: SET PERIOD_NAME = (
5951: SELECT

Line 5959: BSC_SYS_PERIODS_TL L

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
5963: C.FISCAL_YEAR = L.YEAR AND