APPS.BSC_AW_ADAPTER_DIM SQL Statements

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

Line: 83

  l_level_considered.delete;

Line: 183

    l_dim.level_groups.delete;

Line: 184

    bsc_aw_utility.delete_table('bsc_aw_temp_vn',null);

Line: 189

        execute immediate 'insert into bsc_aw_temp_vn(name,id) values(:1,:2)' using l_level,l_id;

Line: 195

    g_stmt:='select distinct name,id from bsc_aw_temp_vn order by id';

Line: 315

  p_dim.level_groups(1).levels.delete;

Line: 316

  p_dim.level_groups(1).parent_child.delete;

Line: 317

  p_dim.level_groups(1).zero_levels.delete;

Line: 318

  p_dim.level_groups(1).rec_levels.delete;

Line: 321

  p_dim.kpi_for_dim.delete;

Line: 534

updates the metadata and then creates the aw objects for new dim
the logic is as follows:

*/
procedure implement_dim_aw(
p_dimensions in out nocopy dimension_tb,
p_affected_kpi in out nocopy dbms_sql.varchar2_table
) is
--
--
Begin
  if g_debug then
    log_n('In implement_dim_aw');

Line: 660

      bsc_aw_utility.delete_aw_object(l_objects(i).object);

Line: 666

      bsc_aw_utility.delete_aw_object(l_objects(i).object);

Line: 672

      bsc_aw_utility.delete_aw_object(l_objects(i).object);

Line: 678

      bsc_aw_utility.delete_aw_object(l_objects(i).object);

Line: 682

  bsc_aw_md_api.drop_dim(p_dim_name);--this will delete all child objects in metadata

Line: 960

  g_commands.delete;

Line: 995

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 999

    l_levels.delete;

Line: 1000

    l_parent_child.delete;

Line: 1001

    l_zero_levels.delete;

Line: 1002

    l_snowflake_levels.delete;

Line: 1029

      l_levels.delete;

Line: 1030

      l_parent_child.delete;

Line: 1031

      l_zero_levels.delete;

Line: 1032

      l_snowflake_levels.delete;

Line: 1038

      bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1060

  /*deletes for dimensions
  delete are handled in the following way
  delete table has 2 columns. dim_level and delete_value. say we have geog dim. city,state,country
  we want to delete all cities in ca and ca
  the table has
  'city'    'SF'
  'city'    'LA'
  'state'   'CA'
  for each level in the dim, we see if there are delete values. if there are we do the following
  mark limit cubes for the parent value for re-agg.
  in our case, we will mark state of ca and country of usa for re-agg
  the dim values are deleted in dim load module
  */
  --p_level_group.levels(i).level_name
  bsc_aw_utility.add_g_commands(g_commands,'allstat');

Line: 1079

        bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select delete_value from bsc_aw_dim_delete '||
        ' where dim_level=\'''||p_level_group.levels(i).level_name||'\''');

Line: 1083

        /*5064802. we need to handle the case where the dim value in bsc_aw_dim_delete does not exist in aw dim. go on append mode. then
        dim loader delete will delete them */
        bsc_aw_utility.add_g_commands(g_commands,':append '||p_level_group.levels(i).level_name||' --');

Line: 1222

  g_commands.delete;

Line: 1228

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1244

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1264

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1304

  g_commands.delete;

Line: 1310

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1338

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1375

    bsc_aw_utility.add_g_commands(g_commands,'sql declare c1 cursor for select --');

Line: 1376

    bsc_aw_utility.add_g_commands(g_commands,'delete_value from bsc_aw_dim_delete '||
    ' where dim_level=\'''||p_dimension.level_groups(1).levels(1).level_name||'\''');

Line: 1518

  l_dim.level_groups(1).data_source.data_source:='(select distinct data_type from bsc_sys_benchmarks_b)';

Line: 1519

  l_dim.level_groups(1).data_source.inc_data_source:='(select distinct data_type from bsc_sys_benchmarks_b)';

Line: 1574

  g_commands.delete;

Line: 1578

  bsc_aw_utility.add_g_commands(g_commands,'insert into bsc_aw_dim_data values (\'''||p_dim_level||'\'',:'||p_dim_level||') DIRECT=YES');

Line: 1631

  l_olap_object_relation.delete;

Line: 1679

    delete old metadata
    insert new metadata
  endif

merge:
  delete old metadata
  create dim with merge mode
    add level name dim / relation
    create new levels
    recreate program
  insert metadata
--
*/
procedure correct_old_dim(p_dim dimension_r,p_flag out nocopy varchar2) is
l_old_dim dimension_tb;

Line: 1779

  p_old_dim.level_groups.delete;

Line: 1934

    l_parents.delete;

Line: 1983

          bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).parent_child(j).parent_level||'.'||
          p_old_level_groups(i).parent_child(j).child_level||'''');

Line: 2003

        bsc_aw_dbms_aw.execute('maintain '||p_level_name_dim||' delete '''||p_old_level_groups(i).zero_levels(j).level_name||'.'||
        p_old_level_groups(i).zero_levels(j).child_level_name||'''');

Line: 2023

    l_new_level_groups.delete;

Line: 2073

      l_level_considered.delete;

Line: 2347

      l_pc_subset_temp.delete;