APPS.XLA_AAD_INSTALL_PVT SQL Statements

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

Line: 103

  SELECT p_amb_context_code||'_INSTALL_'||application_short_name
    INTO l_staging_context_code
    FROM fnd_application
   WHERE application_id = p_application_id;

Line: 114

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 118

    xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'IMPORT');

Line: 133

  xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'IMPORT');

Line: 174

  SELECT p_amb_context_code||'_INSTALL_'||application_short_name
    INTO l_staging_context_code
    FROM fnd_application
   WHERE application_id = p_application_id;

Line: 228

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 232

      UPDATE xla_product_rules_b
         SET compile_status_code = 'R'
       WHERE application_id = p_application_id
         AND amb_context_code = p_amb_context_code;

Line: 237

      FOR l IN (SELECT * FROM xla_product_rules_b
                 WHERE application_id = p_application_id
                   AND amb_context_code = p_amb_context_code) LOOP
        xla_amb_aad_pkg.validate_and_compile_aad
               (p_application_id            => p_application_id
               ,p_amb_context_code          => p_amb_context_code
               ,p_product_rule_type_code    => l.product_rule_type_code
               ,p_product_rule_code         => l.product_rule_code
               ,x_validation_status_code    => l_validation_status_code
               ,x_compilation_status_code   => l_compilation_status_code
               ,x_hash_id                   => l_hash_id);

Line: 251

    xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'IMPORT');

Line: 266

  xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'IMPORT');

Line: 321

    xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'EXPORT');

Line: 336

  xla_aad_loader_util_pvt.insert_errors
             (p_application_id     => p_application_id
             ,p_amb_context_code   => p_amb_context_code
             ,p_request_code       => 'EXPORT');