APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_PERIODS_TL

Line 3388: -- BSC_SYS_PERIODS_TL to improve performance

3384:
3385: BEGIN
3386: -- x_action = 1 || x_action = NULL
3387: -- Drop Indexes from calendar tables: BSC_DB_CALENDAR, BSC_DB_WEEK_MAPS,
3388: -- BSC_SYS_PERIODS_TL to improve performance
3389: -- Note: Indexes on BSC_DB_CALENDAR and BSC_DB_WEEK_MAPS tables were removed.
3390:
3391: --LOCKING: We are not going to drop indexes anymore. If we remove indexes
3392: -- we cannot load different calendars at the same time

Line 3394: -- IF NOT Drop_Index('BSC_SYS_PERIODS_TL_U1') THEN

3390:
3391: --LOCKING: We are not going to drop indexes anymore. If we remove indexes
3392: -- we cannot load different calendars at the same time
3393: --IF NVL(x_action, 1) = 1 THEN
3394: -- IF NOT Drop_Index('BSC_SYS_PERIODS_TL_U1') THEN
3395: -- RAISE e_unexpected_error;
3396: -- END IF;
3397: --END IF;
3398:

Line 3502: -- Populate BSC_SYS_PERIODS_TL

3498: IF NOT Populate_Bsc_Db_Week_Maps(x_calendar_id) THEN
3499: RAISE e_unexpected_error;
3500: END IF;
3501:
3502: -- Populate BSC_SYS_PERIODS_TL
3503: IF NOT Populate_Bsc_Sys_Periods_Tl(x_calendar_id) THEN
3504: RAISE e_unexpected_error;
3505: END IF;
3506: END IF;

Line 3503: IF NOT Populate_Bsc_Sys_Periods_Tl(x_calendar_id) THEN

3499: RAISE e_unexpected_error;
3500: END IF;
3501:
3502: -- Populate BSC_SYS_PERIODS_TL
3503: IF NOT Populate_Bsc_Sys_Periods_Tl(x_calendar_id) THEN
3504: RAISE e_unexpected_error;
3505: END IF;
3506: END IF;
3507:

Line 3513: -- IF NOT Create_Unique_Index('BSC_SYS_PERIODS_TL',

3509: -- Enable indexes
3510: --LOCKING: We are not going to drop indexes anymore. If we remove indexes
3511: -- we cannot load different calendars at the same time
3512: --IF NVL(x_action, 3) = 3 THEN
3513: -- IF NOT Create_Unique_Index('BSC_SYS_PERIODS_TL',
3514: -- 'BSC_SYS_PERIODS_TL_U1',
3515: -- 'YEAR, PERIODICITY_ID, PERIOD_ID, MONTH, LANGUAGE',
3516: -- BSC_APPS.other_index_tbs_type) THEN
3517: -- RAISE e_unexpected_error;

Line 3514: -- 'BSC_SYS_PERIODS_TL_U1',

3510: --LOCKING: We are not going to drop indexes anymore. If we remove indexes
3511: -- we cannot load different calendars at the same time
3512: --IF NVL(x_action, 3) = 3 THEN
3513: -- IF NOT Create_Unique_Index('BSC_SYS_PERIODS_TL',
3514: -- 'BSC_SYS_PERIODS_TL_U1',
3515: -- 'YEAR, PERIODICITY_ID, PERIOD_ID, MONTH, LANGUAGE',
3516: -- BSC_APPS.other_index_tbs_type) THEN
3517: -- RAISE e_unexpected_error;
3518: -- END IF;

Line 4301: | FUNCTION Populate_Bsc_Sys_Periods_Tl

4297: END Populate_Bsc_Db_Week_Maps;
4298:
4299:
4300: /*===========================================================================+
4301: | FUNCTION Populate_Bsc_Sys_Periods_Tl
4302: +============================================================================*/
4303: FUNCTION Populate_Bsc_Sys_Periods_Tl(
4304: x_calendar_id IN NUMBER
4305: ) RETURN BOOLEAN IS

Line 4303: FUNCTION Populate_Bsc_Sys_Periods_Tl(

4299:
4300: /*===========================================================================+
4301: | FUNCTION Populate_Bsc_Sys_Periods_Tl
4302: +============================================================================*/
4303: FUNCTION Populate_Bsc_Sys_Periods_Tl(
4304: x_calendar_id IN NUMBER
4305: ) RETURN BOOLEAN IS
4306:
4307: h_sql VARCHAR2(32700);

Line 4324: -- Delete all rows from bsc_sys_periods_tl

4320: h_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
4321: h_num_bind_vars NUMBER;
4322:
4323: BEGIN
4324: -- Delete all rows from bsc_sys_periods_tl
4325: DELETE FROM BSC_SYS_PERIODS_TL
4326: WHERE PERIODICITY_ID IN (
4327: SELECT PERIODICITY_ID
4328: FROM BSC_SYS_PERIODICITIES

Line 4325: DELETE FROM BSC_SYS_PERIODS_TL

4321: h_num_bind_vars NUMBER;
4322:
4323: BEGIN
4324: -- Delete all rows from bsc_sys_periods_tl
4325: DELETE FROM BSC_SYS_PERIODS_TL
4326: WHERE PERIODICITY_ID IN (
4327: SELECT PERIODICITY_ID
4328: FROM BSC_SYS_PERIODICITIES
4329: WHERE CALENDAR_ID = x_calendar_id);

Line 4334: INSERT INTO BSC_SYS_PERIODS_TL (YEAR, PERIODICITY_ID, PERIOD_ID, MONTH,

4330:
4331:
4332: -- A. LABELS FOR PREDEFINED PERIODICITIES
4333: -- Insert the records
4334: INSERT INTO BSC_SYS_PERIODS_TL (YEAR, PERIODICITY_ID, PERIOD_ID, MONTH,
4335: LANGUAGE, SOURCE_LANG, NAME, SHORT_NAME)
4336: SELECT
4337: CA.YEAR,
4338: CA.PERIODICITY_ID,

Line 4478: h_sql := 'INSERT INTO BSC_SYS_PERIODS_TL (

4474: --OPEN c_custom_pers FOR c_custom_pers_sql USING x_calendar_id, 0;
4475: OPEN c_custom_pers(x_calendar_id, 0);
4476: FETCH c_custom_pers INTO h_periodicity_id, h_db_column_name;
4477: WHILE c_custom_pers%FOUND LOOP
4478: h_sql := 'INSERT INTO BSC_SYS_PERIODS_TL (
4479: YEAR,
4480: PERIODICITY_ID,
4481: PERIOD_ID,
4482: MONTH,

Line 4530: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Sys_Periods_Tl');

4526: EXCEPTION
4527: WHEN OTHERS THEN
4528: BSC_MESSAGE.Add(
4529: x_message => SQLERRM,
4530: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Sys_Periods_Tl');
4531: RETURN FALSE;
4532:
4533: END Populate_Bsc_Sys_Periods_Tl;
4534:

Line 4533: END Populate_Bsc_Sys_Periods_Tl;

4529: x_message => SQLERRM,
4530: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Sys_Periods_Tl');
4531: RETURN FALSE;
4532:
4533: END Populate_Bsc_Sys_Periods_Tl;
4534:
4535:
4536: /*===========================================================================+
4537: | PROCEDURE Populate_Calendar_Tables

Line 5077: -- Labels are in BSC_SYS_PERIODS_TL

5073: WHERE indicator = x_indicator;
5074:
5075: IF h_edw_flag = 0 THEN
5076: -- BSC Kpi => BSC Periodicity
5077: -- Labels are in BSC_SYS_PERIODS_TL
5078:
5079: h_sql := ' UPDATE
5080: BSC_KPI_DEFAULTS_TL D
5081: SET

Line 5090: BSC_SYS_PERIODS_TL L

5086: (SELECT
5087: K.PERIODICITY_ID||''-''||L.NAME
5088: FROM
5089: BSC_KPI_PERIODICITIES KP,
5090: BSC_SYS_PERIODS_TL L
5091: WHERE
5092: K.INDICATOR = KP.INDICATOR AND
5093: K.PERIODICITY_ID = KP.PERIODICITY_ID AND
5094: C.FISCAL_YEAR = L.YEAR AND