APPS.BSC_AW_CALENDAR SQL Statements

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

Line: 107

select db_column_name,periodicity_id,periodicity_type,source from bsc_sys_periodicities where calendar_id=p_calendar
and periodicity_type not in (11,12);

Line: 276

  g_commands.delete;

Line: 299

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

Line: 367

      l_lower_periodicities.delete;

Line: 392

    l_upper_periodicities.delete;

Line: 430

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

Line: 435

  bsc_aw_utility.add_g_commands(g_commands,'from (select * from bsc_db_calendar where calendar_id='||p_calendar.calendar_id||
  ' order by calendar_year desc,calendar_month desc,calendar_day desc) where rownum=1');

Line: 446

      l_lower_periodicities.delete;

Line: 666

      l_source.delete;

Line: 714

  bsc_aw_md_api.delete_calendar(p_calendar);

Line: 744

cursor c1 is select current_year from bsc_sys_calendars_b where calendar_id=p_calendar;

Line: 776

  bsc_aw_utility.g_options.delete;

Line: 797

cursor c1 is select min(calendar_year)-1,max(calendar_year)+1 from bsc_db_calendar where calendar_id=p_calendar;

Line: 813

  l_bsc_olap_object.delete;

Line: 830

  bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','loaded');

Line: 862

      bsc_aw_dbms_aw.execute('maintain '||l_olap_object(i).object||' delete all');

Line: 868

      bsc_aw_dbms_aw.execute('maintain '||l_olap_object(i).object||' delete all');

Line: 872

  bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','purged');

Line: 956

            bsc_aw_dbms_aw.execute('maintain '||l_level_name_dim||' delete '''||l_oor(j).relation_object||'.'||l_oor(j).object||'''');

Line: 973

    l_pc.delete;

Line: 1036

        bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

Line: 1042

        bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

Line: 1048

        bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

Line: 1055

        bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

Line: 1108

      l_missing_levels.delete;

Line: 1128

      l_missing_levels.delete;

Line: 1197

          l_missing_levels.delete;

Line: 1232

          l_missing_levels.delete;

Line: 1289

we have to acquire locks and update in a certain order . else we get
ORA-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
we cannot update a relation before a dim. so when we get locks, we first get dim, then relations, then variables
*/
procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table) is
l_dim varchar2(300);

Line: 1409

  bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','empty');