APPS.BSC_AW_LOAD SQL Statements

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

Line: 16

  bsc_aw_utility.g_options.delete;

Line: 43

  bsc_aw_utility.g_options.delete;

Line: 60

to know which values have got deleted

this creates the program on the fly, executes it and drops the program
NO COMMIT!!!
*/
procedure dmp_dim_level_into_table(
p_dim_level_list dbms_sql.varchar2_table,
p_options varchar2
) is
Begin
  bsc_aw_utility.g_options.delete;

Line: 96

  bsc_aw_utility.g_options.delete;

Line: 123

  bsc_aw_utility.g_options.delete;

Line: 140

  bsc_aw_utility.g_options.delete;

Line: 165

  bsc_aw_utility.g_options.delete;

Line: 188

  bsc_aw_utility.g_options.delete;

Line: 219

update_bt_change_vector('BSC_B_1',l_cv);

Line: 225

if the change vector in the B table > in the metadata, it is due to some loader failure before update_bt_change_vector
was called
when a B table is dropped by the MO, it needs to call drop_bt_change_vector
*/
procedure init_bt_change_vector(p_base_table varchar2) is
Begin
  bsc_aw_md_api.create_bt_change_vector(upper(p_base_table)); /*creates cv and current period */

Line: 256

procedure update_bt_change_vector(p_base_table varchar2, p_value number) is
Begin
  bsc_aw_md_api.update_bt_change_vector(upper(p_base_table),p_value);

Line: 260

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

Line: 266

procedure update_bt_current_period(p_base_table varchar2,p_period number,p_year number) is
Begin
  bsc_aw_md_api.update_bt_current_period(upper(p_base_table),p_period||'.'||p_year);

Line: 270

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