APPS.BSC_MO_HELPER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

select distinct sysdim.short_name, sysdim.level_view_name
  from bsc_sys_dim_levels_b sysdim,
       bsc_kpi_dim_levels_b kpidim,
       bsc_tmp_opt_ui_kpis  proc
 where proc.process_id = bsc_metadata_optimizer_pkg.g_ProcessID
   and proc.indicator=kpidim.indicator
   and kpidim.level_table_name = sysdim.level_table_name
   and sysdim.source = 'PMF'
   and BIS_UTILITIES_PVT.is_rolling_period_level(sysdim.short_name) = 0
minus
select sysdim.short_name, sysdim.level_view_name
  from user_views vws
     , bsc_sys_dim_levels_b sysdim
 where vws.view_name=sysdim.level_view_name;

Line: 65

SELECT SOURCE_TABLE_NAME
FROM BSC_DB_TABLES_RELS
WHERE TABLE_NAME = p_table;

Line: 78

l_stmt varchar2(1000) := 'select level_view_name from '||BSC_METADATA_OPTIMIZER_PKG.g_filtered_indics||' where indicator=:1 and dim_set_id=:2 and level_pk_col=:3';

Line: 120

  l_stmt := l_stmt || ' select distinct
       substr(table_name, instr(table_name, ''_'',  1, 2)+1, instr(table_name, ''_'',  1, 3)-instr(table_name, ''_'',  1, 2)-1) indicator,
       substr(table_name, instr(table_name, ''_'',  1, 3)+1, instr(table_name, ''_'',  1, 4)-instr(table_name, ''_'',  1, 3)-1) dim_set_id,
       table_name
       from bsc_db_tables_rels
       where table_name like ''BSC_S%''
       and (source_table_name like ''BSC_B%'' or source_table_name like ''BSC_T%'' )';

Line: 162

select distinct indicator, dim_set_id from bsc_kpi_data_tables
where table_name in
(select table_name from bsc_db_tables_rels
where table_name like 'BSC_S%'
connect by prior table_name = source_table_name
start with table_name = p_table);

Line: 190

'select distinct indicator, dim_set_id from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||'
where table_name in
(select table_name from bsc_db_tables_rels
where table_name like ''BSC_S%''
connect by prior table_name = source_table_name
start with table_name = :1)';

Line: 234

select periodicity_id from bsc_db_tables
where table_name = upper(p_table_name);

Line: 247

select count(1)
from bsc_db_tables tbl,
bsc_db_tables_rels rels
where
rels.table_name = p_table
and rels.source_table_name = tbl.table_name
and tbl.table_type = 0;

Line: 273

SELECT MESSAGE
FROM BSC_MESSAGE_LOGS
WHERE TYPE = 0
AND UPPER(SOURCE) = upper(apiName)
AND LAST_UPDATE_LOGIN = bsc_metadata_optimizer_pkg.g_session_id;

Line: 306

SELECT BSC_APPS.Get_Tablespace_Clause_Tbl FROM DUAL;

Line: 329

	l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx  FROM DUAL';

Line: 350

SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;

Line: 1557

SELECT PROJECT_FLAG FROM BSC_DB_TABLES
WHERE TABLE_NAME = p1;

Line: 1603

  SELECT PROPERTY_CODE FROM BSC_KPI_PROPERTIES
  WHERE INDICATOR = Indic
  AND UPPER(PROPERTY_CODE) = UPPER(Variable);

Line: 1615

      UPDATE BSC_KPI_PROPERTIES SET PROPERTY_VALUE = Valor
          WHERE INDICATOR = Indic AND PROPERTY_CODE = Variable;

Line: 1619

      INSERT INTO BSC_KPI_PROPERTIES (INDICATOR, PROPERTY_CODE, PROPERTY_VALUE)
          VALUES(Indic, Variable, Valor);

Line: 1687

  SELECT TABLE_NAME FROM ALL_TAB_COLUMNS
  WHERE TABLE_NAME = p_table AND COLUMN_NAME = upper(p_column) AND OWNER = p3;

Line: 1731

SELECT MEANING
FROM fnd_lookup_values_vl
WHERE LOOKUP_TYPE = p_lookup_type
AND LOOKUP_CODE = p_lookup_code;

Line: 2447

  BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(131) := 'DELETE';

Line: 2534

  BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(218) := 'INSERT';

Line: 2757

  BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(441) := 'SELECT';

Line: 2845

  BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(529) := 'UPDATE';

Line: 2902

  SELECT MEASURE_COL, HELP, MEASURE_GROUP_ID, PROJECTION_ID, NVL(MEASURE_TYPE, 1) MTYPE
  FROM BSC_DB_MEASURE_COLS_VL
   WHERE MEASURE_COL NOT IN
   (
       SELECT MEASURE_COL FROM BSC_SYS_MEASURES M
       WHERE NVL(M.SOURCE, 'BSC') = 'PMF'
      and  not exists( select 1 from BSC_SYS_MEASURES P where p.Measure_Col = m.measure_col
	           and NVL(p.SOURCE, 'BSC') = 'BSC')
   ) ORDER BY MEASURE_COL;*/

Line: 2914

  SELECT DB.MEASURE_COL, DB.HELP, DB.MEASURE_GROUP_ID, DB.PROJECTION_ID, NVL(DB.MEASURE_TYPE, 1) MTYPE, M.SOURCE
    FROM BSC_DB_MEASURE_COLS_VL DB,
         BSC_SYS_MEASURES M
   WHERE db.Measure_Col = m.measure_col
     AND M.SOURCE = 'BSC'
   UNION
  SELECT M.MEASURE_COL, null HELP, -1 MEASURE_GROUP_ID, 0 PROJECTION_ID, 1 MTYPE, M.SOURCE
    FROM BSC_SYS_MEASURES M
   WHERE M.SOURCE='PMF'
   ORDER BY MEASURE_COL;

Line: 2988

  SELECT PROPERTY_VALUE
  FROM BSC_KPI_PROPERTIES
  WHERE INDICATOR = Indic
  AND PROPERTY_CODE = Variable;

Line: 3048

  DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;

Line: 3051

  		' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id||
  		' AND VARIABLE_ID = ' || x_variable_id || ')';

Line: 3068

   INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_n)
   VALUES
   (bsc_metadata_optimizer_pkg.g_session_id, x_variable_id, x_value(i));

Line: 3083

   INSERT INTO BSC_TMP_BIG_IN_COND(session_id, variable_id, value_v)
   VALUES
   (bsc_metadata_optimizer_pkg.g_session_id, x_variable_id, x_value(i));

Line: 3124

  DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id AND VARIABLE_ID = x_variable_id;

Line: 3126

  		' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = '||bsc_metadata_optimizer_pkg.g_session_id
                 ||' AND VARIABLE_ID = '||x_variable_id||')';

Line: 3165

PROCEDURE InsertRelatedTables(arrTables in dbms_Sql.varchar2_table,
		 numTables in number) IS

  arrNewTables dbms_sql.varchar2_table;

Line: 3186

     writeTmp( 'Inside InsertRelatedTables, numTables='||numTables, fnd_log.level_procedure, false);

Line: 3188

   writeTmp('Insert related tables, tables are ', fnd_log.level_statement, false);

Line: 3209

     l_stmt := 'SELECT TABLE_NAME FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInChildTables;

Line: 3229

     l_stmt := 'SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInParentTables;

Line: 3261

       l_stmt := 'SELECT TABLE_NAME FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' WHERE INDICATOR IN (
                SELECT INDICATOR FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' WHERE '|| strWhereInNewTables||')
                AND '|| strWhereNotInNewTables ||' AND TABLE_NAME IS NOT NULL ';

Line: 3278

       InsertRelatedTables (arrNewTables, numNewTables);

Line: 3283

     writeTmp( 'Compl. InsertRelatedTables', fnd_log.level_procedure, false);

Line: 3289

      writeTmp( 'Exception in InsertRelatedTables :'||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

Line: 3462

  l_stmt := 'SELECT DISTINCT M.MEASURE_COL, M.SOURCE, M.MEASURE_ID FROM BSC_SYS_MEASURES M, '||
            BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I
            WHERE I.MEASURE_ID = M.MEASURE_ID AND ('|| strWhereInIndics ||' )
            AND M.TYPE = 0';

Line: 3487

  l_stmt := 'SELECT DISTINCT M.MEASURE_ID, M.MEASURE_COL FROM BSC_SYS_MEASURES M, '
            ||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||
             ' I WHERE I.MEASURE_ID = M.MEASURE_ID
  	       AND ('|| strWhereNotInIndics ||' )
            AND M.TYPE = 0 ';

Line: 3531

    l_stmt := 'SELECT DISTINCT INDICATOR FROM BSC_DB_MEASURE_BY_DIM_SET_V WHERE ('|| strWhereInMeasures || ')';

Line: 3540

      l_stack := l_stack ||newline||'going to update...';

Line: 3541

      UPDATE BSC_KPIS_B
         SET PROTOTYPE_FLAG   = DECODE(PROTOTYPE_FLAG, 2, 2, 3, 3, 4),
             LAST_UPDATED_BY  = BSC_METADATA_OPTIMIZER_PKG.gUserId,
             LAST_UPDATE_DATE = SYSDATE
	   WHERE INDICATOR = l_indicator
             AND prototype_flag not in (2,3);

Line: 3548

        l_stack := l_stack ||'updated '||l_indicator||' to 4';

Line: 3585

	l_stmt := 'SELECT PROPERTY_VALUE FROM BSC_SYS_INIT WHERE UPPER(PROPERTY_CODE) = :1';

Line: 3740

PROCEDURE insert_per(p_periodicity IN NUMBER, p_origin IN VARCHAR2) IS
l_origin_list DBMS_SQL.NUMBER_TABLE;

Line: 3743

l_stmt VARCHAR2(1000) := 'INSERT INTO '||l_table_name||'(periodicity, source) values (:1, :2)';

Line: 3753

    writeTmp('Exception in insert_per:'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);

Line: 3764

  SELECT distinct sysper.PERIODICITY_ID, sysper.SOURCE
  FROM BSC_SYS_PERIODICITIES sysper
  ORDER BY PERIODICITY_ID;

Line: 3783

      insert_per(cPeriodRow.periodicity_id, cPeriodRow.source);

Line: 3788

  l_stmt := ' select periodicity from '||l_table_name||' connect by periodicity = prior source start with periodicity = :1';

Line: 3850

  SELECT distinct sysper.PERIODICITY_ID, sysper.SOURCE, sysper.EDW_FLAG, sysper.YEARLY_FLAG,
  sysper.CALENDAR_ID, NVL(sysper.PERIODICITY_TYPE, 0) AS PERIODICITY_TYPE
  FROM BSC_SYS_PERIODICITIES_VL sysper
  ORDER BY PERIODICITY_ID;

Line: 3982

SELECT
B.CALENDAR_ID,
B.EDW_FLAG,
B.NAME,
B.FISCAL_YEAR,
B.RANGE_YR_MOD,
NVL(B.EDW_CALENDAR_TYPE_ID, 0) SOURCE,
(
 NVL((SELECT MAX(NUM_OF_YEARS - PREVIOUS_YEARS)
 FROM BSC_KPI_PERIODICITIES
 WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
     PERIODICITY_ID IN (SELECT PERIODICITY_ID
                  FROM BSC_SYS_PERIODICITIES S
                  WHERE S.CALENDAR_ID = B.CALENDAR_ID))
   , 1)
) AS MAX_FORYEAR,
(
 NVL((SELECT MAX(PREVIOUS_YEARS)
 FROM BSC_KPI_PERIODICITIES
 WHERE NVL(NUM_OF_YEARS, 0) > 0 AND
     PERIODICITY_ID IN (SELECT PERIODICITY_ID
                  FROM BSC_SYS_PERIODICITIES S
                  WHERE S.CALENDAR_ID = B.CALENDAR_ID))
   , 1)
) AS MAX_PREVIOUS,
--Added 05/18/2005 after conversation with Venu
--DBI calendar ids should be 1001, 1002 or 1003
EDW_CALENDAR_ID
FROM
BSC_SYS_CALENDARS_VL B;

Line: 4062

PROCEDURE InsertDirectTables(arrTables in out nocopy dbms_Sql.varchar2_table, p_variable_id IN NUMBER) IS
CURSOR cStoITables IS
select distinct source_table_name from bsc_db_tables_rels
connect by table_name = prior source_table_name
start with table_name in (
    SELECT VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = bsc_metadata_optimizer_pkg.g_session_id
    AND VARIABLE_ID = p_variable_id);

Line: 4087

l_stmt VARCHAR2(1000):= 'select distinct source_table_name from bsc_db_tables_rels
connect by table_name = prior source_table_name
start with table_name in (';

Line: 4106

Procedure MarkTablesForSelectedKPIs IS

    l_stmt varchar2(1000);

Line: 4129

    writeTmp( 'Inside MarkTablesForSelectedKPIs', FND_LOG.LEVEL_PROCEDURE, false);

Line: 4139

  BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

Line: 4151

    l_stmt := ' SELECT DISTINCT TABLE_NAME FROM BSC_KPI_DATA_TABLES WHERE ('||
       	 strWhereInIndics|| ') AND TABLE_NAME IS NOT NULL';

Line: 4186

    writeTmp( 'Calling InsertDirectTables', FND_LOG.LEVEL_STATEMENT, false);

Line: 4187

    InsertDirectTables(BSC_METADATA_OPTIMIZER_PKG.garrTables, 21);

Line: 4188

    writeTmp( 'Done with InsertDirectTables', FND_LOG.LEVEL_STATEMENT, false);

Line: 4196

    writeTmp( 'Calling InsertRelatedTables', FND_LOG.LEVEL_STATEMENT, false);

Line: 4197

    InsertRelatedTables( arrayDirectTables, BSC_METADATA_OPTIMIZER_PKG.gnumTables);

Line: 4198

    writeTmp( 'Done InsertRelatedTables', FND_LOG.LEVEL_STATEMENT, false);

Line: 4204

    l_varchar2_list.delete;

Line: 4216

    l_varchar2_list.delete;

Line: 4223

    l_dontProcessIndics  := 'SELECT DISTINCT INDICATOR FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' WHERE ('||strWhereInTables|| ')';

Line: 4234

    l_dontDropTables := ' select source_table_name from bsc_db_tables_rels
                  connect by table_name = prior source_table_name start with table_name in
                 (select table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in ('||l_dontProcessIndics||') )';

Line: 4241

    l_dropTables := 'select table_name from bsc_db_tables where ('||strWhereInDirectTables||') '||' and table_name not in ('||
                      l_dontDropTables||')';

Line: 4245

    BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

Line: 4259

    writeTmp( 'Completed MarkTablesForSelectedKPIs', FND_LOG.LEVEL_PROCEDURE, false);

Line: 4264

      writeTmp('Exception in MarkTablesForSelectedKPIs : '||lError);

Line: 4287

  SELECT DISTINCT K.INDICATOR
  FROM BSC_KPIS_B K, BSC_TAB_INDICATORS T WHERE K.INDICATOR = T.INDICATOR (+)
  AND T.INDICATOR IS NULL AND K.PROTOTYPE_FLAG <> 2 ORDER BY K.INDICATOR;

Line: 4349

  SELECT DISTINCT INDICATOR, SOURCE_INDICATOR FROM BSC_KPIS_B
  WHERE SHARE_FLAG = 3 AND SOURCE_INDICATOR IS NOT NULL AND PROTOTYPE_FLAG <> 2 ;

Line: 4403

  SELECT DISTINCT K.INDICATOR
  FROM BSC_KPIS_B K
  WHERE EDW_FLAG = 1
		AND EXISTS ( SELECT P.PROPERTY_CODE FROM BSC_KPI_PROPERTIES P
		WHERE P.INDICATOR = K.INDICATOR AND P.PROPERTY_VALUE = 0
		AND P.PROPERTY_CODE IN ('EDW_DATASET_STATUS', 'EDW_CALENDAR_STATUS', 'EDW_DIMENSION_STATUS'));

Line: 4463

  SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE <> 2;

Line: 4465

  SELECT INDICATOR FROM BSC_KPIS_B WHERE PROTOTYPE_FLAG = 4 ORDER BY INDICATOR;

Line: 4480

  BSC_METADATA_OPTIMIZER_PKG.garrIndics.delete;

Line: 4483

  BSC_METADATA_OPTIMIZER_PKG.garrIndics4.delete;

Line: 4486

  BSC_METADATA_OPTIMIZER_PKG.garrTables.delete;

Line: 4492

    UPDATE bsc_kpis_b
	   SET prototype_flag = 3
	 WHERE prototype_flag=1;

Line: 4497

  l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
      INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
      SHARE_FLAG, SOURCE_INDICATOR,
      EDW_FLAG FROM BSC_KPIS_VL ';

Line: 4508

     DELETE FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID;

Line: 4509

	 INSERT INTO BSC_TMP_OPT_UI_KPIS (INDICATOR, PROTOTYPE_FLAG, PROCESS_ID)
	 SELECT INDICATOR, PROTOTYPE_FLAG, BSC_METADATA_OPTIMIZER_PKG.g_processID
	 FROM BSC_KPIS_VL
	 where short_name is null OR
	 (short_name is not null and BSC_DBGEN_UTILS.Get_Objective_Type(short_name) = 'OBJECTIVE');

Line: 4516

	 SELECT COUNT(1) INTO l_total_count FROM BSC_KPIS_VL;

Line: 4522

  ELSE-- Modified or Selected indicators
    l_stmt := l_stmt || ' where prototype_flag in (2,3) and indicator in (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = '||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';

Line: 4567

  ELSE -- incremental mode or selected mode

    MarkTablesForSelectedKPIs;

Line: 4572

	--Add indicators with flag = 4 (reconfigure update)
    --in the collection gIndicadores
    --Of course if the indicator is already in gIndicadores (Structural changes) we do not change it.
    --Init an array with the Kpis in prototype 4 (changes in loader configuration)
    l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
      INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
      SHARE_FLAG, SOURCE_INDICATOR,
      EDW_FLAG FROM BSC_KPIS_VL WHERE INDICATOR in
	  (select indicator from bsc_tmp_opt_ui_kpis where prototype_flag =4 and process_id= :1) ORDER BY INDICATOR';

Line: 4641

      l_stmt := 'SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG, INDICATOR_TYPE,
                  CONFIG_TYPE, PERIODICITY_ID, SHARE_FLAG, SOURCE_INDICATOR,
                  EDW_FLAG FROM BSC_KPIS_VL ';

Line: 4645

      l_stmt := l_stmt ||' WHERE INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=:1) ';

Line: 4720

  SELECT count(1) FROM USER_OBJECTS
  WHERE OBJECT_NAME = upper(ObjectName);

Line: 4753

SELECT 1 FROM ALL_TABLES
WHERE TABLE_NAME = pTableName
AND OWNER = pOwner;

Line: 4800

  l_stmt := l_stmt||' AS SELECT * FROM '||TableName||' '||p_where_clause;

Line: 4802

  l_stmt := 'select count(1) from '||CopyTableName;

Line: 4807

  writeTmp('# of rows inserted into '||CopyTableName||':'||l_val, FND_LOG.LEVEL_STATEMENT, false);

Line: 4832

  SELECT index_name, uniqueness
  FROM all_indexes
  WHERE table_name = TableName
  AND owner = pOwner;

Line: 4838

  SELECT column_name
  FROM all_ind_columns
  WHERE index_name = pIndex
  AND table_owner = pOwner
  AND column_name not like 'SYS%$'
  ORDER BY column_position;

Line: 4944

  SELECT R.TABLE_NAME
	FROM BSC_DB_TABLES_RELS R, BSC_DB_TABLES T
	WHERE R.SOURCE_TABLE_NAME = T.TABLE_NAME
	AND T.TABLE_TYPE = 0;

Line: 4980

     SELECT index_name FROM ALL_INDEXES WHERE
     table_name = UPPER(p_table) AND table_owner = bsc_metadata_optimizer_pkg.gBscSchema;

Line: 5056

	  SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
	  CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
	  start with table_name in
	    (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
	         (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')
	     )
	  UNION
	  SELECT TABLE_NAME FROM BSC_DB_TABLES_RELS
	  CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
	  start with table_name in
	    (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
	         (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')
	     )
      )';

Line: 5080

	         (select indicator from bsc_tmp_opt_ui_kpis where process_id='||BSC_METADATA_OPTIMIZER_PKG.g_processID||')';

Line: 5090

    (select source_table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||'
    connect by table_name = prior source_table_name
    start with table_name in (select table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last||'))';

Line: 5321

PROCEDURE InsertChildTables_LAST(arrTables IN dbms_sql.varchar2_table,
                       numTables IN OUT NOCOPY number,
           				 arrChildTables IN OUT NOCOPY dbms_sql.varchar2_table,
                       numChildTables IN OUT NOCOPY number) IS

l_table_name varchar2(300);

Line: 5333

select  table_name  from bsc_db_tables_rels
connect by prior table_name = source_Table_name
start with source_table_name = pOriginTable;

Line: 5348

      arrTablesAux.delete;

Line: 5358

      InsertChildTables_LAST (arrTablesAux, numTablesAux, arrChildTables, numChildTables);

Line: 5363

      writeTmp( 'Exception  in InsertChildTables_LAST :'||l_error, FND_LOG.LEVEL_UNEXPECTED, true);

Line: 5409

  l_stmt VARCHAR2(1000):='SELECT R.TABLE_NAME, R.SOURCE_TABLE_NAME, BT.PERIODICITY_ID
	FROM '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||' R, '||
	BSC_METADATA_OPTIMIZER_PKG.g_db_tables_last||' IT, '||
	BSC_METADATA_OPTIMIZER_PKG.g_db_tables_last||' BT
	WHERE R.SOURCE_TABLE_NAME = IT.TABLE_NAME
	AND IT.TABLE_TYPE = 0
	AND R.TABLE_NAME = BT.TABLE_NAME
	AND IT.TABLE_NAME IN
	 (SELECT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
	  CONNECT BY TABLE_NAME=prior SOURCE_TABLE_NAME
	  start with table_name in
	    (select distinct table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' where indicator in
	         (select indicator from bsc_tmp_opt_ui_kpis where process_id=:1)
	     )
      )
	ORDER BY R.SOURCE_TABLE_NAME';

Line: 5433

  SELECT column_name FROM all_tab_columns
			WHERE table_name = pTableName
			AND owner = pOwner
			ORDER BY column_id;

Line: 5476

     InsertChildTables_LAST(arrTables, numTables, arrChildTables, numChildTables);

Line: 5480

     l_stmt := 'SELECT DISTINCT INDICATOR FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' WHERE '||strWhereInChildTables;

Line: 5507

  l_stmt := 'SELECT DISTINCT INDICATOR FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||' WHERE TABLE_NAME IS NOT NULL';

Line: 5509

  BSC_METADATA_OPTIMIZER_PKG.garrOldIndicators.delete;

Line: 5510

  l_arr_indicators.delete;

Line: 5540

PROCEDURE deletePreviousRunTables IS
  l_stmt varchar2(1000);

Line: 5558

  writeTmp( 'Inside deletePreviousRunTables, time is '||get_time, FND_LOG.LEVEL_STATEMENT, true);

Line: 5607

      l_stmt := ' UPDATE BSC_KPIS_B
                  SET PROTOTYPE_FLAG = DECODE(PROTOTYPE_FLAG, 2, 2, 3),
                  LAST_UPDATED_BY = :1,
                  LAST_UPDATE_DATE = SYSDATE  WHERE '|| strWhereInIndics;

Line: 5614

    l_stmt := 'SELECT DISTINCT MV_NAME FROM BSC_KPI_DATA_TABLES WHERE ('||  strWhereInIndics ||')  AND MV_NAME IS NOT NULL';

Line: 5626

    l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME
            FROM BSC_DB_TABLES_RELS WHERE TABLE_NAME IN (
              SELECT TABLE_NAME
              FROM '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table||'
              WHERE (' || strWhereInIndics || ') AND TABLE_NAME IS NOT NULL ) AND RELATION_TYPE = 1';

Line: 5641

    l_stmt := 'SELECT DISTINCT PROJECTION_DATA FROM BSC_KPI_DATA_TABLES  WHERE ('|| strWhereInIndics || ')
              AND PROJECTION_DATA IS NOT NULL';

Line: 5654

    l_stmt := 'UPDATE BSC_KPI_DATA_TABLES
		       SET   TABLE_NAME = NULL, MV_NAME = NULL, DATA_SOURCE = NULL,
                 SQL_STMT = NULL, PROJECTION_SOURCE = 0, PROJECTION_DATA = NULL
		       WHERE '|| strWhereInIndics;

Line: 5672

      l_stmt := 'UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG = DECODE(PROTOTYPE_FLAG, 2, 2, 4), '||
			' LAST_UPDATED_BY = :1 ,'||
			' LAST_UPDATE_DATE = SYSDATE '||
			' WHERE (' || strWhereInIndics4 || ')';

Line: 5686

      l_stmt := 'SELECT DISTINCT MV_NAME FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics4 ||')';

Line: 5705

      l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME
                FROM BSC_DB_TABLES_RELS WHERE TABLE_NAME IN (
                SELECT TABLE_NAME FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics4 || ')';

Line: 5768

    l_stmt := 'DELETE FROM BSC_DB_TABLES WHERE '||strWhereInTables;

Line: 5773

    l_stmt := 'DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInTables;

Line: 5778

    l_stmt := 'DELETE FROM BSC_DB_TABLES_COLS WHERE '||  strWhereInTables;

Line: 5783

    l_stmt := 'DELETE FROM BSC_DB_CALCULATIONS WHERE '||  strWhereInTables;

Line: 5802

  writeTmp( 'Compl deletePreviousRunTables, system time is '||get_time, FND_LOG.LEVEL_STATEMENT, true);

Line: 5805

  bsc_mo_helper_pkg.writeTmp( 'Exception in deletePreviousRunTables '||l_ERROR, FND_LOG.LEVEL_UNEXPECTED, true);

Line: 5825

    SELECT Count(1) INTO l_count FROM BSC_SYS_INIT
    WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);

Line: 5829

      UPDATE BSC_SYS_INIT SET PROPERTY_VALUE = propertyValue, LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserID, LAST_UPDATE_DATE = SYSDATE
      WHERE UPPER(PROPERTY_CODE) = UPPER(propertyCode);

Line: 5833

      INSERT INTO BSC_SYS_INIT (PROPERTY_CODE, PROPERTY_VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE)
      VALUES(propertyCode, propertyValue, BSC_METADATA_OPTIMIZER_PKG.gUserID, SYSDATE, BSC_METADATA_OPTIMIZER_PKG.gUserID, SYSDATE);

Line: 5876

        BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);

Line: 5877

        BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');

Line: 5896

          UPDATE BSC_DB_TABLES SET NUM_OF_YEARS = num_anos, PREVIOUS_YEARS = num_anosant
                  WHERE PERIODICITY_ID IN (
                  SELECT PERIODICITY_ID FROM BSC_SYS_PERIODICITIES
                  WHERE CALENDAR_ID = Calendar.Code );

Line: 5902

            BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);

Line: 5903

            BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');

Line: 5928

        UPDATE BSC_KPI_PERIODICITIES K
           SET CURRENT_PERIOD =
		       (SELECT  DECODE(P.YEARLY_FLAG, 1, C.FISCAL_YEAR, 1)
                  FROM BSC_SYS_PERIODICITIES P, BSC_SYS_CALENDARS_B C
                 WHERE K.PERIODICITY_ID = P.PERIODICITY_ID
				   AND P.CALENDAR_ID = C.CALENDAR_ID
				)
         WHERE INDICATOR = Indicador.Code;

Line: 5937

        UPDATE BSC_SYS_KPI_COLORS
          SET  KPI_COLOR = BSC_METADATA_OPTIMIZER_PKG.ColorG,
               ACTUAL_DATA = NULL,
               BUDGET_DATA = NULL
          WHERE INDICATOR = Indicador.Code;

Line: 5942

        UPDATE bsc_sys_objective_colors
           SET obj_color = BSC_METADATA_OPTIMIZER_PKG.ColorG
           WHERE indicator = Indicador.Code;

Line: 5949

         UPDATE BSC_KPI_DEFAULTS_TL D
             SET PERIOD_NAME = (
               SELECT
                 CASE WHEN NVL(C.EDW_CALENDAR_TYPE_ID, 0) = 0 AND P.YEARLY_FLAG = 1  THEN
                 K.PERIODICITY_ID||'-'||C.FISCAL_YEAR
                 ELSE
                 (SELECT
                    K.PERIODICITY_ID||'-'||L.NAME
                  FROM
                    BSC_KPI_PERIODICITIES KP,
                    BSC_SYS_PERIODS_TL L
                  WHERE
                    K.INDICATOR = KP.INDICATOR AND
                    K.PERIODICITY_ID = KP.PERIODICITY_ID AND
                    C.FISCAL_YEAR = L.YEAR AND
                    KP.PERIODICITY_ID = L.PERIODICITY_ID AND
                    KP.CURRENT_PERIOD = L.PERIOD_ID AND
                    D.LANGUAGE = L.LANGUAGE
                 )
                 END
               FROM
                 BSC_DB_COLOR_KPI_V K,
                 BSC_SYS_PERIODICITIES P,
                 BSC_SYS_CALENDARS_B C
               WHERE
                 K.TAB_ID = D.TAB_ID AND
                 K.INDICATOR = D.INDICATOR AND
                 K.PERIODICITY_ID = P.PERIODICITY_ID AND
                 P.CALENDAR_ID = C.CALENDAR_ID
             )
            WHERE
            INDICATOR = Indicador.Code;

Line: 5984

		  --Update date of indicator
          UPDATE BSC_KPI_DEFAULTS_B SET LAST_UPDATE_DATE = SYSDATE  WHERE INDICATOR = Indicador.Code;

Line: 5994

  WriteInitTable( 'UPDATE_DATE', to_char(sysdate, 'dd/mm/yyyy'));

Line: 6002

'SELECT last.table_name, last.column_name
   FROM '||bsc_metadata_optimizer_pkg.g_db_tables_cols_last||' last
      , bsc_tmp_big_in_cond cond
  WHERE last.table_name = cond.value_v
    AND cond.variable_id = :1
    AND cond.session_id = :2
    AND last.column_type = :3
  MINUS
 SELECT cols.table_name, cols.column_name
   FROM bsc_db_tables_cols cols
      , bsc_db_tables_rels rels
      , bsc_tmp_big_in_cond cond
  WHERE cond.value_v = rels.source_table_name
    AND rels.table_name = cols.table_name
    AND cond.variable_id = :4
    AND cond.session_id = :5
    AND cols.column_type = :6';

Line: 6054

  DELETE bsc_db_tables_cols
   WHERE table_name = p_Table_name
     AND column_name = p_column_name;

Line: 6063

    'select distinct source_table_name from '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||'
    connect by table_name = prior source_table_name
    start with table_name in (select value_v from bsc_tmp_big_in_cond where variable_id=:1 and session_id=:2)';

Line: 6127

  SELECT distinct table_name FROM '||BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last||' last
   WHERE table_name LIKE ''BSC_S%'' AND source_table_name NOT like ''BSC_S%''
     AND table_name in
         (select distinct table_name
            from '||BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last||' )';

Line: 6151

select distinct level_table_name
from bsc_sys_dim_levels_b lvl
   , all_snapshot_logs log
where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
  and log.master = lvl.level_Table_name
minus
select distinct level_table_name
from bsc_sys_dim_levels_b lvl
   , all_snapshot_logs log
   , all_dependencies db
   , all_mviews mv
where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
  and log.master = lvl.level_Table_name
  and db.referenced_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
  and db.referenced_type = 'TABLE'
  and db.referenced_name = lvl.level_table_name
  and db.type = 'MATERIALIZED VIEW'
  and db.owner=mv.owner
  and db.name=mv.mview_name
  and mv.owner = BSC_METADATA_OPTIMIZER_PKG.gAppsSchema
  and mv.fast_refreshable<>'NO';

Line: 6209

    with kpi_data as(SELECT DISTINCT TABLE_NAME
    FROM BSC_KPI_DATA_TABLES
    WHERE TABLE_NAME IS NOT NULL )
    SELECT table_name from kpi_data
    UNION
    SELECT DISTINCT SOURCE_TABLE_NAME FROM BSC_DB_TABLES_RELS
    START WITH table_name IN (SELECT TABLE_NAME from kpi_data)
    CONNECT BY PRIOR source_table_name = table_name ; */

Line: 6218

    select table_name from bsc_db_tables where table_type=0
    union all
    SELECT DISTINCT table_name
    from BSC_DB_TABLES_RELS
    START WITH source_TABLE_NAME IN
    (select table_name from bsc_db_tables where table_type=0)
    CONNECT BY PRIOR TABLE_NAME = source_TABLE_NAME;

Line: 6231

  SELECT table_name, owner
    FROM all_tables
   WHERE (table_name like BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_period_circ_check_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_filtered_indics_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_db_tables_last_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_db_tables_rels_last_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last_pfx||'%'
      OR table_name like BSC_METADATA_OPTIMIZER_PKG.g_db_tables_cols_last_pfx||'%'
      OR table_name like 'BSC_TMP_COL_TYPE%'
	   )
	 AND owner in (BSC_METADATA_OPTIMIZER_PKG.gAppsSchema, BSC_METADATA_OPTIMIZER_PKG.gBSCSchema))
   SELECT table_name, owner
    FROM btable
   MINUS
   SELECT table_name, owner
    FROM btable, v$session
	WHERE substr(table_name, instr(table_name, '_', -1)+1, 100) in
        (select to_char(audsid) from v$session where status<>'KILLED');

Line: 6296

  l_stmt := 'SELECT DISTINCT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE <> 2 AND NOT (' ||
           strWhereInCondition || ')';

Line: 6299

  l_stmt := 'SELECT DISTINCT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE <> :1
   minus
   select upper(value_v) from bsc_tmp_big_in_cond where variable_id=:2 and session_id = :3';

Line: 6345

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES WHERE '||strWhereInCondition;

Line: 6348

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE '|| strWhereInCondition;

Line: 6351

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE '|| strWhereInCondition;

Line: 6354

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE '|| strWhereInCondition;

Line: 6359

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES WHERE table_name IN '||l_drop_these;

Line: 6362

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_RELS WHERE table_name IN '||l_drop_these;

Line: 6365

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_TABLES_COLS WHERE table_name IN '||l_drop_these;

Line: 6368

      EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE table_name IN '||l_drop_these;

Line: 6372

    BSC_MO_HELPER_PKG.writeTmp('Deleted invalid entries from metadata tables '||get_time, FND_LOG.LEVEL_PROCEDURE);

Line: 6379

    UPDATE BSC_KPI_PROPERTIES set property_value = 1 where property_code = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;

Line: 6382

    BSC_MO_HELPER_PKG.writeTmp('Updated kpi_properties '||get_time, FND_LOG.LEVEL_PROCEDURE);

Line: 6440

    g_stack.delete(g_stack.first);

Line: 6575

PROCEDURE UpdateFlags IS
l_stmt VARCHAR2(300);

Line: 6581

  BSC_MO_HELPER_PKG.writeTmp('Inside UpdateFlags '||get_time, FND_LOG.LEVEL_PROCEDURE, true);

Line: 6591

          DELETE FROM BSC_KPIS_B WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6592

          DELETE FROM BSC_KPIS_TL WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).code;

Line: 6593

          DELETE FROM BSC_KPI_DATA_TABLES WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).code;

Line: 6597

          UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG = 0,
                  LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserId,
                  LAST_UPDATE_DATE = SYSDATE
                  WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6604

	  UPDATE bsc_kpi_analysis_measures_b
	    SET prototype_flag = 0
            WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6611

          UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG = 6,
                  LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserId,
                  LAST_UPDATE_DATE = SYSDATE
                  WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6616

	  UPDATE bsc_kpi_analysis_measures_b
	    SET prototype_flag = 7
            WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6624

              UPDATE BSC_KPIS_B SET PROTOTYPE_FLAG = 6,
                      LAST_UPDATED_BY = BSC_METADATA_OPTIMIZER_PKG.gUserId,
                      LAST_UPDATE_DATE = SYSDATE
                      WHERE INDICATOR = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6629

	      UPDATE bsc_kpi_analysis_measures_b
	        SET prototype_flag = 7
                WHERE indicator = BSC_METADATA_OPTIMIZER_PKG.gIndicators(i).Code;

Line: 6641

  /*UPDATE BSC_KPI_ANALYSIS_MEASURES_B
          SET PROTOTYPE_FLAG = 0
          WHERE DATASET_ID IN (
          SELECT DATASET_ID FROM BSC_SYS_DATASETS_B
          WHERE NVL(SOURCE, 'BSC') = 'PMF')
		  AND INDICATOR IN (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id = BSC_METADATA_OPTIMIZER_PKG.g_processID);*/

Line: 6657

  UPDATE BSC_SYS_CALENDARS_B SET RANGE_YR_MOD = 0;

Line: 6663

  execute immediate 'delete bsc_tmp_opt_ui_kpis where process_id=:1' using BSC_METADATA_OPTIMIZER_PKG.g_processID;

Line: 6665

  BSC_MO_HELPER_PKG.writeTmp('Completed UpdateFlags'||get_time, FND_LOG.LEVEL_PROCEDURE, true);

Line: 6667

      writeTmp('Exception in UpdateFlags:'||sqlerrm,  FND_LOG.LEVEL_UNEXPECTED, true);

Line: 6677

SELECT key_name, Origin, Need_zero_code, Calc_zero_code,
Filter_View_Name, dim_index
from BSC_TMP_OPT_KEY_COLS
WHERE
table_name = table_name
and key_name = key_name;

Line: 6739

CURSOR cKeys IS SELECT key_name, Origin, Need_zero_code, Calc_zero_code,
Filter_View_Name, dim_index from BSC_TMP_OPT_KEY_COLS WHERE table_name = pTableName
order by seqnum;

Line: 6793

SELECT
  field_name, aggfunction, origin, avglflag, avgltotalcolumn, avglcountercolumn,
  Internal_Column_Type, Internal_Column_Source
from BSC_TMP_OPT_DATA_COLS
WHERE
table_name = table_name
and upper(field_name) = upper(field_name);

Line: 6831

  BSC_METADATA_OPTIMIZER_PKG.g_time_updateOneDisagg := BSC_METADATA_OPTIMIZER_PKG.g_time_updateOneDisagg + (sysdate - l_start_time) * 86400;

Line: 6847

SELECT field_name, aggfunction, origin, avglflag, avgltotalcolumn, avglcountercolumn,
      Internal_Column_Type, Internal_Column_Source
from BSC_TMP_OPT_DATA_COLS WHERE
table_name = pTableName
order by seqnum;

Line: 7115

SELECT S.DIM_LEVEL_ID, S.LEVEL_TABLE_NAME, S.TABLE_TYPE, S.source,
        S.LEVEL_PK_COL, S.USER_KEY_SIZE, S.DISP_KEY_SIZE, NVL(S.EDW_FLAG, 0) AS EDW_FLAG, R.SOURCE_TABLE_NAME
        FROM BSC_SYS_DIM_LEVELS_B S, BSC_DB_TABLES_RELS R
      WHERE S.LEVEL_TABLE_NAME  = R.TABLE_NAME (+)
      ORDER BY LEVEL_TABLE_NAME;

Line: 7132

  SELECT D.LEVEL_TABLE_NAME, D.LEVEL_PK_COL
  FROM BSC_SYS_DIM_LEVELS_B D, BSC_SYS_DIM_LEVEL_RELS R
  WHERE D.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
  AND R.DIM_LEVEL_ID =  p_dimID
  AND R.RELATION_TYPE = p_relation_type;

Line: 7143

  SELECT COLUMN_NAME
  FROM BSC_SYS_DIM_LEVEL_COLS
  WHERE DIM_LEVEL_ID = p_DIM_LEVEL_ID
  AND UPPER(COLUMN_TYPE) = 'A';

Line: 7151

  SELECT DISTINCT D.RELATION_COL, T.SOURCE_TABLE_NAME
  FROM BSC_SYS_DIM_LEVEL_RELS D, BSC_DB_TABLES_RELS T
  WHERE D.RELATION_TYPE = 2 AND D.RELATION_COL = T.TABLE_NAME (+);

Line: 7158

  SELECT A.LEVEL_TABLE_NAME AS TABLE_A,
  A.LEVEL_PK_COL AS PK_COL_A,
  B.LEVEL_TABLE_NAME AS TABLE_B,
  B.LEVEL_PK_COL AS PK_COL_B
  FROM BSC_SYS_DIM_LEVELS_B A,
       BSC_SYS_DIM_LEVEL_RELS R,
       BSC_SYS_DIM_LEVELS_B B
  WHERE
      A.DIM_LEVEL_ID = R.DIM_LEVEL_ID AND
      R.PARENT_DIM_LEVEL_ID = B.DIM_LEVEL_ID AND
      UPPER(R.RELATION_COL) = upper(pRelation);

Line: 7264

  select count(1) into l_count
    from bsc_kpi_properties p
       , bsc_kpis_vl k
   where p.indicator=k.indicator
     and p.property_code=bsc_metadata_optimizer_pkg.impl_type
     and p.property_value = 2
         -- only production objectives
     and k.prototype_flag not in (1,2,3,4)
      ;

Line: 7282

l_lud_stmt varchar2(1000):= 'select last_update_date
from bsc_reporting_calendar
where calendar_id=:1 and rownum=1';

Line: 7287

select calendar_id, last_update_date
from bsc_sys_calendars_b;

Line: 7306

      writeTmp('LUD for sys calendar '||i.calendar_id ||':'||to_char(i.last_update_date, 'mm/dd/yy hh24:mi:ss')||
        ' and rpt calendar:'||to_char( l_rpt_lud, 'mm/dd/yy hh24:mi:ss' ));

Line: 7310

      IF (l_rpt_lud is not null and l_rpt_lud>=i.last_update_date) then
        null;