APPS.BSC_TEMPLATE SQL Statements

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

Line: 41

  Select PROPERTY_VALUE
  Into l_sys_type
  From BSC_SYS_INIT
  Where PROPERTY_CODE = 'MODEL_TYPE';

Line: 55

  Update BSC_SYS_INIT
  Set    PROPERTY_VALUE = x_sys_name  , LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
  Where  PROPERTY_CODE = 'SYSTEM_NAME';

Line: 59

  Update BSC_SYS_INIT
  Set    PROPERTY_VALUE = to_char(x_template_type),LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
  Where  PROPERTY_CODE = 'MODEL_TYPE';

Line: 129

  Delete From BSC_SYS_DATASET_CALC Where DATASET_ID <> -1;

Line: 132

  Delete From BSC_SYS_DATASETS_TL  Where DATASET_ID <> -1;

Line: 135

  Delete From BSC_SYS_DATASETS_B Where DATASET_ID <> -1;

Line: 138

  Delete From BSC_DB_MEASURE_COLS_TL where MEASURE_COL <> 'Default_Field';

Line: 141

  Delete From BSC_SYS_MEASURES where MEASURE_ID <> -1;

Line: 144

  Delete From BSC_SYS_DIM_LEVELS_BY_GROUP;

Line: 147

  Delete From BSC_SYS_DIM_GROUPS_TL;

Line: 153

  Delete From BSC_SYS_DIM_LEVEL_RELS;

Line: 156

  Delete From BSC_SYS_DIM_LEVELS_TL;

Line: 159

  Delete From BSC_SYS_DIM_LEVELS_B;

Line: 162

  Delete From BSC_SYS_DIM_LEVEL_COLS;

Line: 165

  Delete From BSC_KPI_DIM_GROUPS;

Line: 168

  Delete From BSC_KPI_DIM_LEVEL_PROPERTIES;

Line: 172

  Delete From  BSC_TAB_INDICATORS;

Line: 175

  Delete From  BSC_KPI_DATA_TABLES ;

Line: 178

  Delete From  BSC_KPI_PERIODICITIES ;

Line: 181

  Delete From  BSC_KPI_ANALYSIS_OPTIONS_B ;

Line: 184

  Delete From  BSC_KPI_ANALYSIS_OPTIONS_TL ;

Line: 187

  Delete From  BSC_KPI_DIM_LEVELS_TL ;

Line: 190

  Delete From  BSC_KPI_DIM_LEVELS_B ;

Line: 193

  Delete From  BSC_KPI_DIM_SETS_TL ;

Line: 196

  Delete From  BSC_KPI_ANALYSIS_MEASURES_B;

Line: 199

  Delete From  BSC_KPI_ANALYSIS_MEASURES_TL;

Line: 202

  Delete From  BSC_KPI_CALCULATIONS ;

Line: 205

  Delete From  BSC_KPI_ANALYSIS_GROUPS;

Line: 208

  Delete From  BSC_KPI_DEFAULTS_TL ;

Line: 211

  Delete From  BSC_KPI_DEFAULTS_B ;

Line: 214

  Delete From  BSC_KPIS_TL;

Line: 217

  Delete From  BSC_KPI_PROPERTIES;

Line: 220

  Delete From  BSC_KPIS_B ;

Line: 225

  Delete From  BSC_SYS_LINES ;

Line: 228

  Delete From  BSC_SYS_USER_OPTIONS;

Line: 231

  Delete From  BSC_TAB_IND_GROUPS_B;

Line: 234

  Delete From  BSC_TAB_IND_GROUPS_TL;

Line: 238

  Delete From  BSC_TAB_CSF_B;

Line: 241

  Delete From  BSC_TAB_CSF_TL;

Line: 244

  Delete From  BSC_TABS_B;

Line: 247

  Delete From  BSC_TABS_TL;

Line: 251

  Update BSC_SYS_INIT Set PROPERTY_VALUE= '-1',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
  Where  PROPERTY_CODE= 'MODEL_TYPE';

Line: 256

  Update BSC_SYS_INIT Set PROPERTY_VALUE= 'NoSystem',LAST_UPDATED_BY =2,LAST_UPDATE_DATE=SYSDATE
  Where  PROPERTY_CODE= 'SYSTEM_NAME';

Line: 260

  Select count(*)
  Into   l_count
  From   User_Tables
  Where  table_name = 'BSC_D_TYPE_OF_ACCOUNT';

Line: 275

  Select count(*)
  Into   l_count
  From   User_Tables
  Where  table_name = 'BSC_D_ACCOUNT';

Line: 290

  Select count(*)
  Into   l_count
  From   User_Tables
  Where  table_name = 'BSC_D_SUBACCOUNT';

Line: 307

      Select count(*)
      Into   l_project_count
      From   User_Tables
      Where  table_name = 'BSC_D_PROJECT';