APPS.BSC_AW_ADAPTER SQL Statements

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

Line: 75

    l_affected_kpi.delete;

Line: 97

state. if the kpi is dropped and we do not correct the dim, we can have issues later when country is deleted.
*/
procedure drop_kpi(p_kpi_list dbms_sql.varchar2_table,p_options varchar2) is
--
l_dim_list dbms_sql.varchar2_table;

Line: 154

must be careful with cache. once the upgrade version is updated back in the system, then only must other process read
olap metadata*/
procedure upgrade(p_options varchar2) is  /*call from upgrade script etc */
l_old_upgrade_version number;

Line: 188

  /*update the latest upgrade version */
  bsc_aw_md_api.set_upgrade_version(p_new_version);

Line: 200

  bsc_aw_utility.g_options.delete;