APPS.BSC_AW_UTILITY SQL Statements

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

Line: 249

procedure delete_aw_object(p_object varchar2) is
Begin
  if p_object is not null then
    bsc_aw_dbms_aw.execute('delete '||p_object);

Line: 255

  null;--may try to delete an object that does not exist

Line: 300

procedure delete_table(p_table varchar2,p_where varchar2) is
--
l_stmt varchar2(1000);

Line: 305

    log('delete '||p_table||' where '||p_where);

Line: 308

    l_stmt:='delete '||p_table;

Line: 310

    l_stmt:='delete '||p_table||' where '||p_where;

Line: 317

    log('Deleted '||sql%rowcount||' rows '||get_time);

Line: 320

  log('Exception in delete_table '||sqlerrm);

Line: 355

  p_relation.delete;

Line: 413

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

Line: 424

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

Line: 472

ORA-34738: (NOUPDATE) A severe problem has been detected. Analytic workspace operations have been disabled.
ORA-06512: at "APPS.BSC_AW_UTILITY", line 466
ORA-06512: at "APPS.BSC_AW_LOAD", line 112
ORA-37666: ** SYSTEM ERROR xsSqlImport01 **
A severe problem has been detected. Please save your work via EXPORT or OUTFILE and exit as soon as possible.
As a safety measure, analytic workspace operations have been disabled. Call Oracle OLAP technical support.
ORA-06512: at line 7
somehow, hardcoded 1 is interpreted as true / false 1.
so we will see if count is in the formula. if yes, we will go for groupby
*/
procedure parse_out_agg_function(p_formula varchar2,p_noagg_formula out nocopy varchar2) is
--
l_agg_function varchar2(100);

Line: 525

  g_stmt:='select 1 from '||p_table;

Line: 820

cursor c1 is select table_owner from user_synonyms where synonym_name=upper(p_table);

Line: 842

  SELECT oracle_username
  FROM fnd_oracle_userid WHERE oracle_id
  BETWEEN 900 AND 999 AND read_only_flag = 'U';

Line: 1021

/*5121276 bsc_aw_dim_delete needs to be created here too*/
procedure create_perm_tables is
table_columns bsc_update_util.t_array_temp_table_cols;

Line: 1032

  table_name:='bsc_aw_dim_delete';

Line: 1036

  table_columns.delete;

Line: 1041

  table_columns(table_columns.count+1).column_name:='DELETE_VALUE';

Line: 1060

    if bsc_update_util.Create_Permanent_Table(table_name,table_columns,table_columns.count,l_tablespace,l_idx_tablespace)=false then
      log_n('Exception in bsc_update_util.Create_Permanent_Table. For now, not raising this exception...');

Line: 1229

      p_array.delete(p_array.count);

Line: 1349

        update_job_status(p_parallel_jobs(i));--read from the pipe. then update the fields

Line: 1371

procedure update_job_status(p_parallel_job in out nocopy parallel_job_r) is
--
l_pipe_message varchar2(2000);

Line: 1391

  log_n('Exception in update_job_status '||sqlerrm);

Line: 1455

cursor c1 is select 1 from all_jobs where job=p_job_id;

Line: 1476

    g_parallel_jobs.delete;

Line: 1484

    g_parallel_jobs.delete;

Line: 1562

  open cv for 'select count(*) from all_scheduler_running_jobs';

Line: 1575

cursor c1 is select value from v$parameter param where name=p_name;

Line: 1606

  select mystat.sid into l_sid from v$mystat mystat where rownum=1;

Line: 1649

this will also update the option value if already in g_options
*/
procedure add_option(p_options varchar2,p_option_value varchar2,p_separator varchar2) is
l_values value_tb;

Line: 1732

    p_array.delete;

Line: 1825

  g_sqlerror.delete;

Line: 1838

  g_sqlerror.delete;

Line: 1874

  bsc_aw_utility.delete_table('bsc_aw_temp_pc',null);

Line: 1877

      execute immediate 'insert into bsc_aw_temp_pc(parent,child,id) values (:1,:2,:3)' using nvl(p_pc_1(i).parent,'null'),
      nvl(p_pc_1(i).child,'null'),1;

Line: 1883

      execute immediate 'insert into bsc_aw_temp_pc(parent,child,id) values (:1,:2,:3)' using nvl(p_pc_2(i).parent,'null'),
      nvl(p_pc_2(i).child,'null'),2;

Line: 1892

  open cv for 'select parent,child from bsc_aw_temp_pc where id=1 minus select parent,child from bsc_aw_temp_pc where id=2';

Line: 1904

  open cv for 'select parent,child from bsc_aw_temp_pc where id=2 minus select parent,child from bsc_aw_temp_pc where id=1';

Line: 1934

  g_values.delete;

Line: 1943

  g_values(p_index).new_values.delete;

Line: 1978

    delete_table('bsc_aw_temp_vn',null);

Line: 1980

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

Line: 1981

    open cv for 'select name from bsc_aw_temp_vn order by name';

Line: 2113

cursor c1 is select * from all_tables where table_name=upper(p_table) and owner=upper(p_owner);

Line: 2244

we update p_string with the values*/
procedure update_property(p_string in out nocopy varchar2,p_parameter varchar2,p_value varchar2,p_separator varchar2) is
l_values dbms_sql.varchar2_table;

Line: 2266

  log_n('Exception in update_property '||sqlerrm);

Line: 2286

/*add/update property */
procedure merge_property(p_property in out nocopy property_tb,p_property_name varchar2,p_property_type varchar2,p_property_value varchar2) is
Begin
  for i in 1..p_property.count loop
    if p_property(i).property_name=p_property_name then
      p_property(i).property_type:=p_property_type;

Line: 2385

cursor c1 is select statname.name, mystat.value from v$mystat mystat,v$statname statname where mystat.statistic#=statname.statistic#
order by statname.name;

Line: 2398

cursor c1 is select event.event,event.total_waits,event.total_timeouts,round(event.time_waited) time_waited,
round(event.average_wait) average_wait,round(event.max_wait) max_wait
from v$session_event event where event.sid=get_session_id order by event.event;

Line: 2474

  p_ssg.session_stats.delete;

Line: 2617

  stmt:='select count(*) from '||p_table;