APPS.BSC_AW_READ SQL Statements

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

Line: 48

  l_short_name.delete;

Line: 63

  l_short_name.delete;

Line: 144

    SELECT source_indicator INTO l_kpi
      FROM bsc_kpis_b
      WHERE indicator  = p_kpi;

Line: 232

  g_kpi(p_kpi).property.last_update_date:=bsc_metadata.get_kpi_LUD(p_kpi);

Line: 233

  g_kpi(p_kpi).dim_set.delete;

Line: 234

  g_kpi(p_kpi).dim_set_id.delete;

Line: 273

  p_dim_set.levels.delete;

Line: 355

          l_child_levels.delete;

Line: 356

          l_rel_level_name.delete; --'parent.child'

Line: 425

      l_child_levels.delete;

Line: 426

      l_rel_level_name.delete;

Line: 467

  p_dim_set.measure.delete;

Line: 486

  add_measures.delete;

Line: 669

    bsc_aw_utility.delete_table('bsc_aw_temp_vn',null);

Line: 671

      execute immediate 'insert into bsc_aw_temp_vn(name) values (:1)' using l_xtd_report_date(i);

Line: 672

    g_stmt:='select to_char(periodicity_id),period||''.''||year period from '||l_xtd_keys_table||',bsc_aw_temp_vn where session_id=:1 and '||
    'to_char(report_date,''MM/DD/YYYY'')=bsc_aw_temp_vn.name order by periodicity_id';

Line: 713

  select calendar_id into l_calendar_id from bsc_sys_periodicities where periodicity_id=l_periodicity_id;

Line: 714

  select max(year) into l_max_period from bsc_db_calendar where calendar_id=l_calendar_id;

Line: 715

  select min(year) into l_min_period from bsc_db_calendar where calendar_id=l_calendar_id;

Line: 773

  these values in the cube. but select from the mv will show all 1000 dim values. to restrict this to just the 2, we have to limit
  the dim to only those values in the composite
  in order to do this we do the following
  - limit dim to ALL (as before)
  - limit CC dim add dim (as before)
  - create a session boolean cube 
  - for all composites
    - cube=true across composites
  - limit CC dim to cube
  */
  for i in 1..p_dim_set.limit_track(l_count).limit_dim.count loop
    if p_dim_set.limit_track(l_count).limit_dim(i).value='^ALL' then
      bsc_aw_dbms_aw.execute('limit '||p_dim_set.limit_track(l_count).limit_dim(i).level_name||' TO ALL');

Line: 793

        l_parse_values.delete;

Line: 897

          bsc_aw_dbms_aw.execute_ne('delete '||l_cube);

Line: 908

  bsc_aw_dbms_aw.execute_ne('delete '||l_cube);

Line: 1053

    l_measures.delete;

Line: 1351

      l_cubes.delete;

Line: 1513

  g_kpi.delete;

Line: 1523

  if l_date>g_kpi(p_kpi).property.last_update_date then
    return true;