APPS.XLA_AAD_LOADER_UTIL_PVT SQL Statements

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

Line: 102

    SELECT TO_CHAR(systimestamp,'SSSSSFF') INTO l_temp_code FROM dual;

Line: 114

    INSERT INTO xla_appli_amb_contexts
    (application_id
    ,amb_context_code
    ,staging_amb_context_code
    ,updated_flag
    ,last_analyzed_date
    ,batch_name
    ,object_version_number
    ,creation_date
    ,created_by
    ,last_update_date
    ,last_updated_by
    ,last_update_login)
    SELECT
     p_application_id
    ,p_amb_context_code
    ,l_code
    ,'Y'
    ,NULL
    ,NULL
    ,1
    ,sysdate
    ,xla_environment_pkg.g_usr_id
    ,sysdate
    ,xla_environment_pkg.g_usr_id
    ,xla_environment_pkg.g_login_id
    FROM dual
    WHERE NOT EXISTS (SELECT 1
                        FROM xla_appli_amb_contexts
                       WHERE staging_amb_context_code = l_code);

Line: 216

  DELETE FROM xla_acctg_method_rules
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 221

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

Line: 229

  DELETE FROM xla_line_defn_ac_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 234

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

Line: 239

  DELETE FROM xla_line_defn_adr_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 244

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

Line: 249

  DELETE FROM xla_line_defn_jlt_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 254

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

Line: 259

  DELETE FROM xla_line_definitions_b
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 264

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

Line: 269

  DELETE FROM xla_line_definitions_tl
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 274

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

Line: 279

  DELETE FROM xla_aad_line_defn_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 284

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

Line: 289

  DELETE FROM xla_aad_header_ac_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 294

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

Line: 299

  DELETE FROM xla_mpa_header_ac_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 304

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

Line: 309

  DELETE FROM xla_mpa_jlt_adr_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 314

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

Line: 319

  DELETE FROM xla_mpa_jlt_ac_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 324

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

Line: 329

  DELETE FROM xla_mpa_jlt_assgns
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 334

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

Line: 339

  DELETE FROM xla_aad_hdr_acct_attrs
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 344

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

Line: 349

  DELETE FROM xla_prod_acct_headers
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 354

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

Line: 362

  DELETE FROM xla_product_rules_tl
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 367

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

Line: 372

  DELETE FROM xla_product_rules_b
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 377

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

Line: 385

  DELETE FROM xla_conditions
   WHERE application_id = p_application_id
     AND amb_context_code       = p_amb_context_code
     AND segment_rule_detail_id IS NULL; -- bug 4367287: delete ADR on demand

Line: 391

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

Line: 399

/* Bug 4367287 - the ADR is deleted on demand

  DELETE FROM xla_seg_rule_details
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 406

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

Line: 411

  DELETE FROM xla_seg_rules_tl
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 416

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

Line: 421

  DELETE FROM xla_seg_rules_b
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 426

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

Line: 435

  DELETE FROM xla_descript_details_tl
   WHERE description_detail_id IN
         (SELECT description_detail_id
            FROM xla_descript_details_b  dd
                ,xla_desc_priorities     dp
           WHERE dd.description_prio_id = dp.description_prio_id
             AND dp.application_id      = p_application_id
             AND dp.amb_context_code    = p_amb_context_code);

Line: 445

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

Line: 450

  DELETE FROM xla_descript_details_b
   WHERE description_prio_id IN
         (SELECT description_prio_id
            FROM xla_desc_priorities
           WHERE application_id = p_application_id
             AND amb_context_code = p_amb_context_code);

Line: 458

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

Line: 463

  DELETE FROM xla_desc_priorities
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 468

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

Line: 473

  DELETE FROM xla_descriptions_tl
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 478

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

Line: 483

  DELETE FROM xla_descriptions_b
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 488

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

Line: 496

  DELETE FROM xla_jlt_acct_attrs
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 501

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

Line: 506

  DELETE FROM xla_acct_line_types_tl
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 511

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

Line: 516

  DELETE FROM xla_acct_line_types_b
   WHERE application_id = p_application_id
     AND amb_context_code = p_amb_context_code;

Line: 521

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

Line: 556

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

Line: 563

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

Line: 570

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

Line: 577

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

Line: 584

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

Line: 591

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

Line: 598

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

Line: 605

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

Line: 612

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

Line: 619

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

Line: 626

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

Line: 633

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

Line: 640

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

Line: 647

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

Line: 654

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

Line: 661

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

Line: 668

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

Line: 675

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

Line: 682

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

Line: 689

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

Line: 696

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

Line: 703

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

Line: 710

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

Line: 717

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

Line: 724

    SELECT *
      FROM xla_descript_details_b  b
          ,xla_descript_details_tl t
          ,xla_desc_priorities     p
     WHERE t.description_detail_id  = b.description_detail_id
       AND b.description_prio_id    = p.description_prio_id
       AND p.application_id         = p_application_id
       AND p.amb_context_code       = p_amb_context_code
    FOR UPDATE NOWAIT;

Line: 735

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

Line: 742

    SELECT *
      FROM xla_mapping_sets_b     b
          ,xla_mapping_sets_tl    t
          ,xla_seg_rule_details   s
     WHERE t.mapping_set_code     = b.mapping_set_code
       AND b.mapping_set_code     = s.value_mapping_set_code
       AND s.application_id       = p_application_id
       AND s.amb_context_code     = p_amb_context_code
    FOR UPDATE NOWAIT;

Line: 753

    SELECT *
      FROM xla_mapping_set_values b
          ,xla_seg_rule_details   s
     WHERE b.mapping_set_code     = s.value_mapping_set_code
       AND s.application_id       = p_application_id
       AND s.amb_context_code     = p_amb_context_code
    FOR UPDATE NOWAIT;

Line: 762

    SELECT *
      FROM xla_analytical_hdrs_b  b
          ,xla_analytical_hdrs_tl t
     WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
       AND t.analytical_criterion_code      = b.analytical_criterion_code
       AND t.amb_context_code               = b.amb_context_code
       AND b.amb_context_code               = p_amb_context_code
       AND EXISTS (SELECT 1
                     FROM xla_aad_header_ac_assgns  xah
                    WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xah.analytical_criterion_code      = b.analytical_criterion_code
                      AND xah.amb_context_code               = b.amb_context_code
                      AND xah.application_id                 = p_application_id
                      AND xah.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_line_defn_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_header_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_jlt_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code)
    FOR UPDATE NOWAIT;*/

Line: 803

    SELECT *
      FROM xla_analytical_dtls_b  b
          ,xla_analytical_dtls_tl t
     WHERE t.analytical_criterion_type_code = b.analytical_criterion_type_code
       AND t.analytical_criterion_code      = b.analytical_criterion_code
       AND t.amb_context_code               = b.amb_context_code
       AND b.amb_context_code               = p_amb_context_code
       AND EXISTS (SELECT 1
                     FROM xla_aad_header_ac_assgns  xah
                    WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xah.analytical_criterion_code      = b.analytical_criterion_code
                      AND xah.amb_context_code               = b.amb_context_code
                      AND xah.application_id                 = p_application_id
                      AND xah.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_line_defn_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_header_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_jlt_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code)
    FOR UPDATE NOWAIT;*/

Line: 844

    SELECT *
      FROM xla_analytical_sources b
     WHERE b.amb_context_code               = p_amb_context_code
       AND EXISTS (SELECT 1
                     FROM xla_aad_header_ac_assgns  xah
                    WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xah.analytical_criterion_code      = b.analytical_criterion_code
                      AND xah.amb_context_code               = b.amb_context_code
                      AND xah.application_id                 = p_application_id
                      AND xah.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_line_defn_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_header_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code
                    UNION
                   SELECT 1
                     FROM xla_mpa_jlt_ac_assgns  xld
                    WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
                      AND xld.analytical_criterion_code      = b.analytical_criterion_code
                      AND xld.amb_context_code               = b.amb_context_code
                      AND xld.application_id                 = p_application_id
                      AND xld.amb_context_code               = p_amb_context_code)
    FOR UPDATE NOWAIT;*/

Line: 1203

    SELECT staging_amb_context_code
      FROM xla_appli_amb_contexts
     WHERE application_id    = p_application_id
       AND amb_context_code  = p_amb_context_code;

Line: 1212

    SELECT 1
      FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = l_staging_amb_context_code;

Line: 1292

        UPDATE SET base_version_num = s.base_version_num
                 , user_version     = s.user_version
                 , version_comment  = s.version_comment
                 , leapfrog_flag    = s.leapfrog_flag;

Line: 1298

  UPDATE xla_aads_h h
     SET (base_version_num
         ,user_version
         ,version_comment
         ,leapfrog_flag) =
         (SELECT NVL(s.base_version_num, h2.base_version_num)
                ,NVL(s.product_rule_version, h2.user_version)
                ,NVL(s.version_comment, h2.version_comment)
                ,NVL(s.leapfrog_flag, h2.leapfrog_flag)
            FROM xla_aads_h h2
               , xla_staging_components_h s
           WHERE h.application_id              = h2.application_id
             AND h.product_rule_type_code      = h2.product_rule_type_code
             AND h.product_rule_code           = h2.product_rule_code
             AND h.version_num                 = h2.version_num
             AND h2.application_id             = s.application_id(+)
             AND h2.product_rule_type_code     = s.component_owner_code(+)
             AND h2.product_rule_code          = s.component_code(+)
             AND h2.version_num                = s.version_num(+)
             AND s.application_id(+)           = p_application_id
             AND s.staging_amb_context_code(+) = p_staging_context_code
             AND s.component_type_code(+)      = 'AAD');

Line: 1323

    trace(p_msg    => '# xla_aads_h updated = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 1328

  INSERT INTO xla_aads_h
               (application_id
               ,product_rule_type_code
               ,product_rule_code
               ,version_num
               ,base_version_num
               ,user_version
               ,version_comment
               ,leapfrog_flag
               ,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 p_application_id
               ,s.component_owner_code
               ,s.component_code
               ,s.version_num
               ,s.base_version_num
               ,s.product_rule_version
               ,s.version_comment
               ,s.leapfrog_flag
               ,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_staging_components_h s
          WHERE s.application_id           = p_application_id
            AND s.staging_amb_context_code = p_staging_context_code
            AND s.component_type_code      = 'AAD'
            AND NOT EXISTS
                (SELECT 1
                   FROM xla_aads_h h
                  WHERE h.application_id           = s.application_id
                    AND h.product_rule_type_code   = s.component_owner_code
                    AND h.product_rule_code        = s.component_code
                    AND h.version_num              = s.version_num);

Line: 1378

    trace(p_msg    => '# xla_aads_h inserted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 1393

        UPDATE SET base_version_num = s.base_version_num;

Line: 1396

  UPDATE xla_amb_components_h h
     SET base_version_num =
         (SELECT nvl(s.base_version_num, h2.base_version_num)
            FROM xla_amb_components_h      h2
               , xla_staging_components_h  s
           WHERE h.component_type_code         = h2.component_type_code
             AND h.component_owner_code        = h2.component_owner_code
             AND h.component_code              = h2.component_code
             AND h.application_id              = h2.application_id
             AND h.version_num                 = h2.version_num
             AND h2.component_type_code        = s.component_type_code(+)
             AND h2.component_owner_code       = s.component_owner_code(+)
             AND h2.component_code             = s.component_code(+)
             AND h2.application_id             = s.application_id(+)
             AND h2.version_num                = s.version_num(+)
             AND s.staging_amb_context_code(+) = p_staging_context_code
             AND s.component_type_code(+)      <> 'AAD');

Line: 1415

    trace(p_msg    => '# xla_amb_components_h updated = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 1420

  INSERT INTO xla_amb_components_h h
               (component_type_code
               ,component_owner_code
               ,component_code
               ,application_id
               ,version_num
               ,base_version_num
               ,leapfrog_flag
               ,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
                s.component_type_code
               ,s.component_owner_code
               ,s.component_code
               ,NVL(s.application_id,-1)
               ,s.version_num
               ,s.base_version_num
               ,s.leapfrog_flag
               ,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_staging_components_h s
          WHERE s.staging_amb_context_code = p_staging_context_code
            AND s.component_type_code      <> 'AAD'
            AND NOT EXISTS
                (SELECT 1
                   FROM xla_amb_components_h h
                  WHERE h.component_type_code      = s.component_type_code
                    AND h.component_owner_code     = s.component_owner_code
                    AND h.component_code           = s.component_code
                    AND h.application_id           = NVL(s.application_id,-1)
                    AND h.version_num              = s.version_num);

Line: 1469

    trace(p_msg    => '# xla_amb_components_h inserted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 1581

  DELETE FROM xla_aad_loader_logs
   WHERE application_id     = p_application_id
     AND amb_context_code   = p_amb_context_code
     AND request_code       = p_request_code;

Line: 1587

    trace(p_msg    => '# row deleted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_EVENT);

Line: 1595

  g_err_nums.DELETE;

Line: 1596

  g_err_msgs.DELETE;

Line: 1884

PROCEDURE insert_errors
(p_application_id       INTEGER
,p_amb_context_code     VARCHAR2
,p_request_code         VARCHAR2)
IS
  l_log_module       VARCHAR2(240);

Line: 1892

    l_log_module := C_DEFAULT_MODULE||'.insert_errors';

Line: 1896

    trace(p_msg      => 'BEGIN of procedure insert_errors'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1902

    INSERT INTO xla_aad_loader_logs
      (aad_loader_log_id
      ,amb_context_code
      ,application_id
      ,request_code
      ,log_type_code
      ,encoded_message
      ,message_num
      ,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)
    VALUES
      (xla_aad_loader_logs_s.nextval
      ,p_amb_context_code
      ,p_application_id
      ,p_request_code
      ,'ERROR'
      ,g_err_msgs(i)
      ,g_err_nums(i)
      ,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);

Line: 1940

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

Line: 1946

    trace(p_msg    => 'END of procedure insert_errors'
         ,p_module => l_log_module
         ,p_level  => C_LEVEL_PROCEDURE);

Line: 1956

               ,p_value_1         => 'xla_aad_loader_util_pvt.insert_errors'
               ,p_token_2         => 'ERROR'
               ,p_value_2         => 'unhandled exception');

Line: 1961

END insert_errors;

Line: 2293

  SELECT application_short_name
    INTO l_short_name
    FROM fnd_application
   WHERE application_id    = p_application_id;

Line: 2298

  DELETE FROM xla_event_mappings_b     WHERE application_id = p_application_id;

Line: 2299

  DELETE FROM xla_event_mappings_tl    WHERE event_mapping_id IN
  (SELECT event_mapping_id
     FROM xla_event_mappings_b
    WHERE application_id = p_application_id);

Line: 2304

  DELETE FROM xla_event_class_grps_b   WHERE application_id = p_application_id;

Line: 2305

  DELETE FROM xla_event_class_grps_tl  WHERE application_id = p_application_id;

Line: 2307

  DELETE FROM xla_entity_id_mappings   WHERE application_id = p_application_id;

Line: 2308

  DELETE FROM xla_event_class_attrs    WHERE application_id = p_application_id;

Line: 2309

  DELETE FROM xla_event_sources        WHERE application_id = p_application_id;

Line: 2310

  DELETE FROM xla_extract_objects      WHERE application_id = p_application_id;

Line: 2311

  DELETE FROM xla_reference_objects    WHERE application_id = p_application_id;

Line: 2312

  DELETE FROM xla_source_params        WHERE application_id = p_application_id;

Line: 2313

  DELETE FROM xla_evt_class_acct_attrs WHERE application_id = p_application_id;

Line: 2315

  DELETE FROM xla_event_types_tl       WHERE application_id = p_application_id;

Line: 2316

  DELETE FROM xla_event_types_b        WHERE application_id = p_application_id;

Line: 2317

  DELETE FROM xla_event_classes_tl     WHERE application_id = p_application_id;

Line: 2318

  DELETE FROM xla_event_classes_b      WHERE application_id = p_application_id;

Line: 2319

  DELETE FROM xla_entity_types_tl      WHERE application_id = p_application_id;

Line: 2320

  DELETE FROM xla_entity_types_b       WHERE application_id = p_application_id;

Line: 2322

  DELETE FROM xla_sources_tl           WHERE application_id = p_application_id;

Line: 2323

  DELETE FROM xla_sources_b            WHERE application_id = p_application_id;

Line: 2325

  DELETE FROM xla_subledgers           WHERE application_id = p_application_id;

Line: 2381

    SELECT staging_amb_context_code
      FROM xla_appli_amb_contexts
     WHERE amb_context_code   = p_amb_context_code
       AND application_id     = p_application_id;

Line: 2427

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 2431

      trace(p_msg    => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 2436

    DELETE FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 2440

      trace(p_msg    => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 2445

    DELETE FROM xla_staging_components_h
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 2449

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

Line: 2454

    DELETE FROM xla_stage_acctg_methods
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 2458

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

Line: 2465

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 2469

      trace(p_msg    => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 2474

    DELETE FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 2478

      trace(p_msg    => '# xla_appli_amb_contexts deleted = '||SQL%ROWCOUNT,
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 2483

    DELETE FROM xla_staging_components_h
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 2487

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

Line: 2492

    DELETE FROM xla_stage_acctg_methods
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 2496

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

Line: 2502

  DELETE FROM xla_amb_setup_errors
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2507

    trace(p_msg    => '# xla_amb_setup_errors deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2512

  DELETE FROM xla_acctg_method_rules
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2517

    trace(p_msg    => '# xla_acctg_method_rules deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2522

  DELETE FROM xla_aad_hdr_acct_attrs
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2527

    trace(p_msg    => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2532

  DELETE FROM xla_aad_header_ac_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2537

    trace(p_msg    => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2542

  DELETE FROM xla_mpa_header_ac_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2547

    trace(p_msg    => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2552

  DELETE FROM xla_mpa_jlt_adr_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2557

    trace(p_msg    => '# xla_mpa_jlt_adr_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2562

  DELETE FROM xla_mpa_jlt_ac_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2567

    trace(p_msg    => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2572

  DELETE FROM xla_mpa_jlt_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2577

    trace(p_msg    => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2582

  DELETE FROM xla_aad_line_defn_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2587

    trace(p_msg    => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2592

  DELETE FROM xla_jlt_acct_attrs
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2597

    trace(p_msg    => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2602

  DELETE FROM xla_line_defn_ac_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2607

    trace(p_msg    => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2612

  DELETE FROM xla_line_defn_adr_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2617

    trace(p_msg    => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2622

  DELETE FROM xla_line_defn_jlt_assgns
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2627

    trace(p_msg    => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2632

  DELETE FROM xla_line_definitions_tl
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2637

    trace(p_msg    => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2642

  DELETE FROM xla_line_definitions_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2647

    trace(p_msg    => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2652

  DELETE FROM xla_prod_acct_headers
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2657

    trace(p_msg    => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2662

  DELETE FROM xla_product_rules_tl
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2667

    trace(p_msg    => '# xla_product_rules_tl deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2672

  DELETE FROM xla_product_rules_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2677

    trace(p_msg    => '# xla_product_rules_b deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2682

  DELETE FROM xla_conditions
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2687

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

Line: 2692

  DELETE FROM xla_analytical_sources b
   WHERE EXISTS (SELECT 1
                   FROM xla_analytical_hdrs_b h
                  WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
                    AND b.analytical_criterion_code      = h.analytical_criterion_code
                    AND b.amb_context_code               = h.amb_context_code
                    AND h.amb_context_code               IN (p_amb_context_code, l_staging_context_code)
                    AND h.application_id                 = p_application_id);

Line: 2702

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

Line: 2707

  DELETE FROM xla_analytical_dtls_tl b
   WHERE EXISTS (SELECT 1
                   FROM xla_analytical_hdrs_b h
                  WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
                    AND b.analytical_criterion_code      = h.analytical_criterion_code
                    AND b.amb_context_code               = h.amb_context_code
                    AND h.amb_context_code               IN (p_amb_context_code, l_staging_context_code)
                    AND h.application_id                 = p_application_id);

Line: 2717

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

Line: 2722

  DELETE FROM xla_analytical_dtls_b b
   WHERE EXISTS (SELECT 1
                   FROM xla_analytical_hdrs_b h
                  WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
                    AND b.analytical_criterion_code      = h.analytical_criterion_code
                    AND b.amb_context_code               = h.amb_context_code
                    AND h.amb_context_code               IN (p_amb_context_code, l_staging_context_code)
                    AND h.application_id                 = p_application_id);

Line: 2732

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

Line: 2737

  DELETE FROM xla_analytical_hdrs_tl b
   WHERE EXISTS (SELECT 1
                   FROM xla_analytical_hdrs_b h
                  WHERE b.analytical_criterion_type_code = h.analytical_criterion_type_code
                    AND b.analytical_criterion_code      = h.analytical_criterion_code
                    AND b.amb_context_code               = h.amb_context_code
                    AND h.amb_context_code               IN (p_amb_context_code, l_staging_context_code)
                    AND h.application_id                 = p_application_id);

Line: 2747

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

Line: 2752

  DELETE FROM xla_analytical_hdrs_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2757

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

Line: 2762

  DELETE FROM xla_seg_rule_details
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2767

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

Line: 2772

  DELETE FROM xla_seg_rules_tl
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2777

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

Line: 2782

  DELETE FROM xla_seg_rules_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2787

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

Line: 2792

  DELETE FROM xla_descript_details_tl
   WHERE description_detail_id IN
         (SELECT d.description_detail_id
            FROM xla_descript_details_b d
                ,xla_desc_priorities    p
           WHERE d.description_prio_id  = p.description_prio_id
             AND p.application_id   = p_application_id
             AND p.amb_context_code IN (p_amb_context_code, l_staging_context_code));

Line: 2802

    trace(p_msg    => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2807

  DELETE FROM xla_descript_details_b
   WHERE description_prio_id IN
         (SELECT description_prio_id
            FROM xla_desc_priorities
           WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
             AND application_id   = p_application_id);

Line: 2815

    trace(p_msg    => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2820

  DELETE FROM xla_desc_priorities
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2825

    trace(p_msg    => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2830

  DELETE FROM xla_descriptions_tl
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2835

    trace(p_msg    => '# xla_descriptions_tl deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2840

  DELETE FROM xla_descriptions_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2845

    trace(p_msg    => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2850

  DELETE FROM xla_acct_line_types_tl
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2855

    trace(p_msg    => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2860

  DELETE FROM xla_acct_line_types_b
   WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
     AND application_id   = p_application_id;

Line: 2865

    trace(p_msg    => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_PROCEDURE);

Line: 2908

    SELECT analytical_criterion_type_code
         , analytical_criterion_code
         , amb_context_code
      FROM xla_analytical_hdrs_b;

Line: 2972

    SELECT app.application_name
         , xst.name segment_rule_name
         , lk1.meaning segment_rule_owner
         , xld.adr_version_num version_num
      FROM xla_line_defn_adr_assgns xld
         , xla_seg_rules_b          xsr
         , xla_seg_rules_tl         xst
         , fnd_application_vl       app
         , xla_lookups              lk1
     WHERE xld.amb_context_code       = p_staging_context_code
       AND xld.segment_rule_appl_id  <> p_application_id
       AND xsr.amb_context_code       = p_amb_context_code
       AND xsr.application_id         = xld.segment_rule_appl_id
       AND xsr.segment_rule_type_code = xld.segment_rule_type_code
       AND xsr.segment_rule_code      = xld.segment_rule_code
       AND xsr.version_num            < xld.adr_version_num
       AND app.application_id         = xld.segment_rule_appl_id
       AND xst.application_id         = xld.segment_rule_appl_id
       AND xst.segment_rule_type_code = xld.segment_rule_type_code
       AND xst.segment_rule_code      = xld.segment_rule_code
       AND xst.language               = USERENV('LANG')
       AND lk1.lookup_type            = 'XLA_OWNER_TYPE'
       AND lk1.lookup_code            = xld.segment_rule_type_code
    UNION
    SELECT app.application_name
         , xst.name segment_rule_name
         , lk1.meaning segment_rule_owner
         , xsd.value_adr_version_num
      FROM xla_seg_rule_details     xsd
         , xla_seg_rules_b          xsr
         , xla_seg_rules_tl         xst
         , fnd_application_vl       app
         , xla_lookups              lk1
     WHERE xsd.amb_context_code           = p_staging_context_code
       AND xsd.value_segment_rule_appl_id <> p_application_id
       AND xsr.amb_context_code           = p_amb_context_code
       AND xsr.application_id             = xsd.value_segment_rule_appl_id
       AND xsr.segment_rule_type_code     = xsd.value_segment_rule_type_code
       AND xsr.segment_rule_code          = xsd.value_segment_rule_code
       AND xsr.version_num                < xsd.value_adr_version_num
       AND app.application_id             = xsd.value_segment_rule_appl_id
       AND xst.application_id             = xsd.value_segment_rule_appl_id
       AND xst.segment_rule_type_code     = xsd.value_segment_rule_type_code
       AND xst.segment_rule_code          = xsd.value_segment_rule_code
       AND xst.language                   = USERENV('LANG')
       AND lk1.lookup_type                = 'XLA_OWNER_TYPE'
       AND lk1.lookup_code                = xsd.value_segment_rule_type_code;

Line: 3135

  DELETE FROM xla_aads_h
   WHERE application_id = p_application_id;

Line: 3138

  DELETE FROM xla_amb_components_h
   WHERE application_id = p_application_id;

Line: 3141

  UPDATE xla_product_rules_b
     SET version_num = 0
       , updated_flag = 'Y'
   WHERE application_id = p_application_id;

Line: 3146

  UPDATE xla_seg_rules_b
     SET version_num = 0
       , updated_flag = 'Y'
   WHERE application_id = p_application_id;

Line: 3151

  UPDATE xla_analytical_hdrs_b
     SET version_num = 0
       , updated_flag = 'Y'
   WHERE application_id = p_application_id;