APPS.BSC_MO_HELPER_PKG dependencies on ALL_TABLES

Line 3251: --if one table of one indicator is marked then all tables of this indicator are marked

3247: END IF;
3248: Add_Value_Bulk(3, arrNewTables);
3249:
3250: If numNewTables > 0 Then
3251: --if one table of one indicator is marked then all tables of this indicator are marked
3252: --EDW Integration note:
3253: --In BSC_KPI_DATA_TABLES, Metadata Optimizer is storing the name of the view (Example: BSC_3001_0_0_5_V)
3254: --and the name of the S table for BSC Kpis (Example: BSC_3002_0_0_5)
3255: --In this procedure we need to get tables names from a view BSC_KPI_DATA_TABLES_V.

Line 4552: --the array arrTables() with all tables related to the tables used directly by the indicators

4548: END Loop;
4549: CLOSE cv;
4550:
4551: --With the array garrIndics() initialized, the following function initialize
4552: --the array arrTables() with all tables related to the tables used directly by the indicators
4553: --in the array garrIndics(). Additionally, add in the array garrIndics() the related indicators.
4554: --BSC-MV Note: Performance fix: if metadata is running for all indicators we do not need
4555: --that complex logic to figure out all the affected tables
4556: IF BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE = 0 THEN

Line 4753: SELECT 1 FROM ALL_TABLES

4749: l_count NUMBER;
4750: cv CurTyp;
4751:
4752: CURSOR cTables(pTableName IN VARCHAR2, pOwner IN VARCHAR2) IS
4753: SELECT 1 FROM ALL_TABLES
4754: WHERE TABLE_NAME = pTableName
4755: AND OWNER = pOwner;
4756:
4757: BEGIN

Line 5534: -- Delete all tables and records created by a previous execution of

5530: --***************************************************************************
5531: -- deletePreviousRunTables
5532: --
5533: -- DESCRIPTION:
5534: -- Delete all tables and records created by a previous execution of
5535: -- Metadatada Optimizer.
5536: --
5537: -- AUTHOR/DATE - MODIFICATIONS (AUTHOR/DATE/DESCRIPTION):
5538: --****************************************************************************

Line 5594: writeTmp( 'Loop thru and drop all tables');

5590: Add_Value_Bulk(3, BSC_METADATA_OPTIMIZER_PKG.garrIndics4);
5591: strWhereInTables := Get_New_Big_In_Cond_Varchar2( 2, 'TABLE_NAME');
5592: Add_Value_Bulk(2, BSC_METADATA_OPTIMIZER_PKG.garrTables);
5593: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
5594: writeTmp( 'Loop thru and drop all tables');
5595: END IF;
5596:
5597: IF BSC_METADATA_OPTIMIZER_PKG.garrIndics.count > 0 THEN
5598: --Set the prototype flag to 3 for the indicators that are going to be re-created

Line 5640: --BSC-MV Note: Drop all tables created for projections

5636: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5638: END LOOP;
5639: Close cv;
5640: --BSC-MV Note: Drop all tables created for projections
5641: l_stmt := 'SELECT DISTINCT PROJECTION_DATA FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics || ')
5642: AND PROJECTION_DATA IS NOT NULL';
5643: OPEN cv FOR l_stmt;
5644: LOOP

Line 6187: -- It will drop all tables that are not being used by any indidator.

6183: --
6184: -- DESCRIPTION:
6185: -- Clean un-used tables from the database
6186: -- This is just to make sure that the system is clean after user run Metadata Optmizer
6187: -- It will drop all tables that are not being used by any indidator.
6188: -- This situation should not happen, but due to some unkown issue in the past
6189: -- some tables could be there but no indicator is using it.
6190: --****************************************************************************
6191: PROCEDURE CleanDatabase IS

Line 6232: FROM all_tables

6228:
6229: CURSOR cDropThese IS
6230: WITH btable as (
6231: SELECT table_name, owner
6232: FROM all_tables
6233: WHERE (table_name like BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table_pfx||'%'
6234: OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_period_circ_check_pfx||'%'
6235: OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_filtered_indics_pfx||'%'
6236: OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_db_tables_last_pfx||'%'