APPS.XLA_AAD_IMPORT_PVT SQL Statements

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

Line: 70

    SELECT *
      FROM xla_appli_amb_contexts
     WHERE application_id      = p_application_id
       AND amb_context_code    = p_amb_context_code
    FOR UPDATE OF application_id NOWAIT;

Line: 97

  DELETE FROM xla_stage_acctg_methods
   WHERE staging_amb_context_code = p_staging_context_code;

Line: 101

    trace(p_msg    => '# record deleted from xla_stage_acctg_methods = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 107

  DELETE FROM xla_staging_components_h
   WHERE staging_amb_context_code = p_staging_context_code;

Line: 111

    trace(p_msg    => '# record deleted from xla_staging_components_h = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 117

  DELETE FROM xla_conditions
   WHERE amb_context_code       = p_staging_context_code
     AND segment_rule_detail_id IS NOT NULL;

Line: 122

    trace(p_msg    => '# record deleted from xla_conditions = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 127

  DELETE FROM xla_seg_rule_details
   WHERE amb_context_code = p_staging_context_code;

Line: 131

    trace(p_msg    => '# record deleted from xla_seg_rule_details = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 136

  DELETE FROM xla_seg_rules_tl
   WHERE amb_context_code = p_staging_context_code;

Line: 140

    trace(p_msg    => '# record deleted from xla_seg_rules_tl = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 145

  DELETE FROM xla_seg_rules_b
   WHERE amb_context_code = p_staging_context_code;

Line: 149

    trace(p_msg    => '# record deleted from xla_seg_rules_b = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 155

  DELETE FROM xla_mapping_set_values
   WHERE amb_context_code = p_staging_context_code;

Line: 159

    trace(p_msg    => '# record deleted from xla_mapping_set_values = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 164

  DELETE FROM xla_mapping_sets_tl
   WHERE amb_context_code = p_staging_context_code;

Line: 168

    trace(p_msg    => '# record deleted from xla_mapping_sets_tl = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 173

  DELETE FROM xla_mapping_sets_b
   WHERE amb_context_code = p_staging_context_code;

Line: 177

    trace(p_msg    => '# record deleted from xla_mapping_sets_b = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 183

  DELETE FROM xla_analytical_sources
   WHERE amb_context_code = p_staging_context_code;

Line: 187

    trace(p_msg    => '# record deleted from xla_analytical_sources = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 192

  DELETE FROM xla_analytical_dtls_tl
   WHERE amb_context_code = p_staging_context_code;

Line: 196

    trace(p_msg    => '# record deleted from xla_analytical_dtls_tl = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 201

  DELETE FROM xla_analytical_dtls_b
   WHERE amb_context_code = p_staging_context_code;

Line: 205

    trace(p_msg    => '# record deleted from xla_analytical_dtls_b = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 210

  DELETE FROM xla_analytical_hdrs_tl
   WHERE amb_context_code = p_staging_context_code;

Line: 214

    trace(p_msg    => '# record deleted from xla_analytical_hdrs_tl = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 219

  DELETE FROM xla_analytical_hdrs_b
   WHERE amb_context_code = p_staging_context_code;

Line: 223

    trace(p_msg    => '# record deleted from xla_analytical_hdrs_b = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 293

  INSERT INTO xla_aad_loader_logs
  (aad_loader_log_id
  ,amb_context_code
  ,application_id
  ,request_code
  ,log_type_code
  ,aad_application_id
  ,product_rule_code
  ,product_rule_type_code
  ,version_to
  ,object_version_number
  ,creation_date
  ,created_by
  ,last_update_date
  ,last_updated_by
  ,last_update_login
  ,program_update_date
  ,program_application_id
  ,program_id
  ,request_id)
  SELECT xla_aad_loader_logs_s.nextval
        ,p_amb_context_code
        ,p_application_id
        ,'IMPORT'
        ,'IMPORTED_AAD'
        ,application_id
        ,product_rule_code
        ,product_rule_type_code
        ,version_num
        ,1
        ,sysdate
        ,xla_environment_pkg.g_usr_id
        ,sysdate
        ,xla_environment_pkg.g_usr_id
        ,xla_environment_pkg.g_login_id
        ,sysdate
        ,xla_environment_pkg.g_prog_appl_id
        ,xla_environment_pkg.g_prog_id
        ,xla_environment_pkg.g_req_Id
   FROM xla_product_rules_b
  WHERE application_id         = p_application_id
    AND amb_context_code       = p_staging_context_code;

Line: 337

    trace(p_msg    => '# rows inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_STATEMENT);

Line: 384

  UPDATE xla_appli_amb_contexts
     SET updated_flag        = 'Y'
        ,creation_date       = sysdate
        ,created_by          = xla_environment_pkg.g_usr_id
        ,last_update_date    = sysdate
        ,last_updated_by     = xla_environment_pkg.g_usr_id
        ,last_update_login   = xla_environment_pkg.g_login_id
   WHERE amb_context_code    = p_amb_context_code
     AND application_id      = p_application_id;