eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE_UTIL dependencies on BSC_DB_WEEK_MAPS

Line 3387: -- Drop Indexes from calendar tables: BSC_DB_CALENDAR, BSC_DB_WEEK_MAPS,

3383: h_count NUMBER;
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

Line 3389: -- Note: Indexes on BSC_DB_CALENDAR and BSC_DB_WEEK_MAPS tables were removed.

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
3393: --IF NVL(x_action, 1) = 1 THEN

Line 3497: -- Populate BSC_DB_WEEK_MAPS

3493: END IF;
3494: END LOOP;
3495: END LOOP;
3496:
3497: -- Populate BSC_DB_WEEK_MAPS
3498: IF NOT Populate_Bsc_Db_Week_Maps(x_calendar_id) THEN
3499: RAISE e_unexpected_error;
3500: END IF;
3501:

Line 3498: IF NOT Populate_Bsc_Db_Week_Maps(x_calendar_id) THEN

3494: END LOOP;
3495: END LOOP;
3496:
3497: -- Populate BSC_DB_WEEK_MAPS
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

Line 4257: | FUNCTION Populate_Bsc_Db_Week_Maps

4253: END Populate_Bsc_Db_Calendar;
4254:
4255:
4256: /*===========================================================================+
4257: | FUNCTION Populate_Bsc_Db_Week_Maps
4258: +============================================================================*/
4259: FUNCTION Populate_Bsc_Db_Week_Maps (
4260: x_calendar_id IN NUMBER
4261: ) RETURN BOOLEAN IS

Line 4259: FUNCTION Populate_Bsc_Db_Week_Maps (

4255:
4256: /*===========================================================================+
4257: | FUNCTION Populate_Bsc_Db_Week_Maps
4258: +============================================================================*/
4259: FUNCTION Populate_Bsc_Db_Week_Maps (
4260: x_calendar_id IN NUMBER
4261: ) RETURN BOOLEAN IS
4262:
4263: sql_stmt VARCHAR2(2000);

Line 4267: -- Delete all rows from bsc_db_week_maps

4263: sql_stmt VARCHAR2(2000);
4264: h_message VARCHAR2(4000);
4265:
4266: BEGIN
4267: -- Delete all rows from bsc_db_week_maps
4268: /* sql_stmt := 'DELETE FROM BSC_DB_WEEK_MAPS'||
4269: ' WHERE CALENDAR_ID = :1';
4270: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4271:

Line 4268: /* sql_stmt := 'DELETE FROM BSC_DB_WEEK_MAPS'||

4264: h_message VARCHAR2(4000);
4265:
4266: BEGIN
4267: -- Delete all rows from bsc_db_week_maps
4268: /* sql_stmt := 'DELETE FROM BSC_DB_WEEK_MAPS'||
4269: ' WHERE CALENDAR_ID = :1';
4270: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4271:
4272: DELETE FROM BSC_DB_WEEK_MAPS

Line 4272: DELETE FROM BSC_DB_WEEK_MAPS

4268: /* sql_stmt := 'DELETE FROM BSC_DB_WEEK_MAPS'||
4269: ' WHERE CALENDAR_ID = :1';
4270: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4271:
4272: DELETE FROM BSC_DB_WEEK_MAPS
4273: WHERE CALENDAR_ID = x_calendar_id;
4274:
4275: -- Insert the records
4276: /* sql_stmt := 'INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)'||

Line 4276: /* sql_stmt := 'INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)'||

4272: DELETE FROM BSC_DB_WEEK_MAPS
4273: WHERE CALENDAR_ID = x_calendar_id;
4274:
4275: -- Insert the records
4276: /* sql_stmt := 'INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)'||
4277: ' SELECT year, min(month), week4, week52, calendar_id'||
4278: ' FROM bsc_db_calendar'||
4279: ' WHERE calendar_id = :1'||
4280: ' GROUP BY year, week4, week52, calendar_id';

Line 4282: INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)

4278: ' FROM bsc_db_calendar'||
4279: ' WHERE calendar_id = :1'||
4280: ' GROUP BY year, week4, week52, calendar_id';
4281: EXECUTE IMMEDIATE sql_stmt USING x_calendar_id; */
4282: INSERT INTO bsc_db_week_maps (year, month, week, week52, calendar_id)
4283: SELECT year, min(month), week4, week52, calendar_id
4284: FROM bsc_db_calendar
4285: WHERE calendar_id = x_calendar_id
4286: GROUP BY year, week4, week52, calendar_id;

Line 4294: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Week_Maps');

4290: EXCEPTION
4291: WHEN OTHERS THEN
4292: BSC_MESSAGE.Add(
4293: x_message => SQLERRM,
4294: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Week_Maps');
4295: RETURN FALSE;
4296:
4297: END Populate_Bsc_Db_Week_Maps;
4298:

Line 4297: END Populate_Bsc_Db_Week_Maps;

4293: x_message => SQLERRM,
4294: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Week_Maps');
4295: RETURN FALSE;
4296:
4297: END Populate_Bsc_Db_Week_Maps;
4298:
4299:
4300: /*===========================================================================+
4301: | FUNCTION Populate_Bsc_Sys_Periods_Tl