APPS.BSC_AW_MD_API SQL Statements

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

Line: 8

  g_olap_object.delete;

Line: 25

  g_olap_object_relation.delete;

Line: 85

  p_dim_list.delete;

Line: 91

      l_dim.delete;

Line: 113

      l_oo_dim.delete;

Line: 168

  g_olap_object.delete;

Line: 197

  g_olap_object.delete;

Line: 217

procedure delete_calendar(p_calendar bsc_aw_calendar.calendar_r) is
Begin
  clear_all_cache;

Line: 223

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

Line: 243

  g_olap_object.delete;

Line: 280

  g_olap_object.delete;

Line: 313

  l_oo.delete;

Line: 316

    l_oor.delete;

Line: 498

  g_olap_object_relation.delete;

Line: 520

  l_oo.delete;

Line: 524

  l_oo.delete;

Line: 552

  l_olap_object_relation.delete;

Line: 553

  p_dim_set.calendar.parent_child.delete;

Line: 573

  g_olap_object.delete;

Line: 625

  g_olap_object_relation.delete;

Line: 658

  g_olap_object_relation.delete;

Line: 702

    l_values.delete;

Line: 710

    l_values.delete;

Line: 996

  p_dim.levels.delete;

Line: 1014

        l_oor_zero_code.delete;

Line: 1019

        l_oor_rec_level.delete;

Line: 1026

  l_olap_object_relation.delete;

Line: 1104

  l_olap_object_relation.delete;

Line: 1105

  p_calendar.parent_child.delete;

Line: 1183

  l_oo.delete;

Line: 1249

procedure update_olap_object(
p_object varchar2,
p_object_type varchar2,
p_parent_object varchar2,
p_parent_object_type varchar2,
p_match_columns varchar2, --comma separated
p_match_values varchar2, --comma separated
p_set_columns varchar2, --comma separated
p_set_values varchar2 --^ separated. since values can contain , inside
) is
--
l_match_columns dbms_sql.varchar2_table;

Line: 1270

  bsc_aw_md_wrapper.update_olap_object(p_object,p_object_type,p_parent_object,p_parent_object_type,
  l_match_columns,l_match_values,l_set_columns,l_set_values);

Line: 1275

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

Line: 1289

procedure update_olap_object_relation(
p_object varchar2,
p_object_type varchar2,
p_relation_type varchar2,
p_parent_object varchar2,
p_parent_object_type varchar2,
p_match_columns varchar2, --comma separated
p_match_values varchar2, --comma separated
p_set_columns varchar2, --comma separated
p_set_values varchar2 --^ separated
) is
--
l_match_columns dbms_sql.varchar2_table;

Line: 1311

  bsc_aw_md_wrapper.update_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
  l_match_columns,l_match_values,l_set_columns,l_set_values);

Line: 1315

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

Line: 1319

procedure insert_olap_object(
p_object varchar2,
p_object_type varchar2,
p_olap_object varchar2,
p_olap_object_type varchar2,
p_parent_object varchar2,
p_parent_object_type varchar2,
p_property1 varchar2
) is
Begin
  /*insert has no cache invalidation */
  bsc_aw_md_wrapper.insert_olap_object(p_object,p_object_type,p_olap_object,p_olap_object_type,p_parent_object,p_parent_object_type,p_property1);

Line: 1332

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

Line: 1336

procedure insert_olap_object_relation(
p_object varchar2,
p_object_type varchar2,
p_relation_object varchar2,
p_relation_object_type varchar2,
p_relation_type varchar2,
p_parent_object varchar2,
p_parent_object_type varchar2,
p_property1 varchar2
) is
Begin
  /*insert has no cache invalidation */
  bsc_aw_md_wrapper.insert_olap_object_relation(p_object,p_object_type,p_relation_object,p_relation_object_type,p_relation_type,
  p_parent_object,p_parent_object_type,p_property1);

Line: 1351

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

Line: 1358

3 api. one to create metadata entry, one to get the current value. one to update to a new value
get_base_table_change_vector will return null if the base table is not in olap object relation
also creates an entry for current period
*/
procedure create_bt_change_vector(p_base_table varchar2) is
l_cv_value number;

Line: 1367

    bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table','0','change vector','base table change vector',
    p_base_table,'base table',null);

Line: 1369

    bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table',null,'current period','base table current period',
    p_base_table,'base table',null);

Line: 1381

  bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table change vector',null,null,p_base_table,'base table');

Line: 1382

  bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table current period',null,null,p_base_table,'base table');

Line: 1417

procedure update_bt_change_vector(p_base_table varchar2, p_value number) is
Begin
  update_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',
  null,null,'relation_object',to_char(p_value));

Line: 1422

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

Line: 1428

procedure update_bt_current_period(p_base_table varchar2,p_value varchar2) is
Begin
  update_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',
  null,null,'relation_object',p_value);

Line: 1433

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

Line: 1458

  g_oo_cache.delete;

Line: 1459

  g_oor_cache.delete;

Line: 1575

      l_oo.delete;

Line: 1613

    update_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',
    null,null,'olap_object,olap_object_type',bsc_aw_utility.g_upgrade_version||'^bsc aw version');

Line: 1616

    insert_olap_object('bsc aw version','bsc aw version',to_char(bsc_aw_utility.g_upgrade_version),'bsc aw version','bsc aw version',
    'bsc aw version',null);