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: 222

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 231

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

Line: 239

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

Line: 245

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 254

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

Line: 259

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

Line: 265

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 274

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

Line: 279

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

Line: 285

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 294

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

Line: 299

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

Line: 305

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 314

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

Line: 319

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

Line: 325

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 334

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

Line: 339

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

Line: 345

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_line_defn_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 354

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

Line: 359

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

Line: 365

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 374

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

Line: 379

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

Line: 385

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 394

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

Line: 399

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

Line: 405

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 414

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

Line: 419

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

Line: 425

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 434

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

Line: 439

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

Line: 445

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 454

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

Line: 459

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

Line: 465

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 474

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

Line: 479

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

Line: 485

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 494

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

Line: 502

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

Line: 508

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 517

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

Line: 522

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

Line: 528

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 537

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

Line: 545

  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: 552

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 561

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

Line: 569

/* 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: 576

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

Line: 581

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

Line: 586

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

Line: 591

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

Line: 596

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

Line: 605

  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: 616

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 625

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

Line: 630

  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: 639

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 648

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

Line: 653

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

Line: 659

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 668

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

Line: 673

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

Line: 679

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 688

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

Line: 693

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

Line: 699

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 708

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

Line: 716

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

Line: 722

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 731

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

Line: 736

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

Line: 742

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 751

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

Line: 756

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

Line: 762

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge');

Line: 771

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

Line: 806

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

Line: 813

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

Line: 820

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

Line: 827

    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: 834

    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: 841

    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: 848

    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: 855

    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: 862

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

Line: 869

    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: 876

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

Line: 883

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

Line: 890

    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: 897

    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: 904

    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: 911

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

Line: 918

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

Line: 925

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

Line: 932

    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: 939

    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: 946

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

Line: 953

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

Line: 960

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

Line: 967

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

Line: 974

    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: 984

    FOR UPDATE OF p.application_id NOWAIT;

Line: 987

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

Line: 994

    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: 1004

    FOR UPDATE OF s.application_id NOWAIT;

Line: 1007

    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: 1015

    FOR UPDATE OF s.application_id NOWAIT;

Line: 1018

    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: 1059

    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: 1100

    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: 1154

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_product_rules_b',
             p_component_code   =>  'lock_area');

Line: 1173

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_product_rules_tl',
             p_component_code   =>  'lock_area');

Line: 1192

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_prod_acct_headers',
             p_component_code   =>  'lock_area');

Line: 1211

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_aad_hdr_acct_attrs',
             p_component_code   =>  'lock_area');

Line: 1230

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_aad_header_ac_assgns',
             p_component_code   =>  'lock_area');

Line: 1249

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mpa_header_ac_assgns',
             p_component_code   =>  'lock_area');

Line: 1268

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mpa_jlt_ac_assgns',
             p_component_code   =>  'lock_area');

Line: 1287

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mpa_jlt_adr_assgns',
             p_component_code   =>  'lock_area');

Line: 1306

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mpa_jlt_assgns',
             p_component_code   =>  'lock_area');

Line: 1325

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_aad_line_defn_assgns',
             p_component_code   =>  'lock_area');

Line: 1344

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_line_definitions_b',
             p_component_code   =>  'lock_area');

Line: 1363

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_line_definitions_tl',
             p_component_code   =>  'lock_area');

Line: 1382

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_line_defn_jlt_assgns',
             p_component_code   =>  'lock_area');

Line: 1402

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_line_defn_adr_assgns',
             p_component_code   =>  'lock_area');

Line: 1421

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_line_defn_ac_assgns',
             p_component_code   =>  'lock_area');

Line: 1440

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_seg_rules_b',
             p_component_code   =>  'lock_area');

Line: 1459

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_seg_rules_tl',
             p_component_code   =>  'lock_area');

Line: 1478

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  =>  'lock c_seg_rule_details',
             p_component_code   =>  'lock_area');

Line: 1497

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  =>  'lock c_acct_line_types_b',
             p_component_code   =>  'lock_area');

Line: 1516

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  =>  'lock c_acct_line_types_tl',
             p_component_code   =>  'lock_area');

Line: 1535

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_jlt_acct_attrs',
             p_component_code   =>  'lock_area');

Line: 1555

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_descriptions_b',
             p_component_code   =>  'lock_area');

Line: 1574

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_descriptions_tl',
             p_component_code   =>  'lock_area');

Line: 1593

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_desc_priorities',
             p_component_code   =>  'lock_area');

Line: 1612

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_descript_details_tl',
             p_component_code   =>  'lock_area');

Line: 1631

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_conditions',
             p_component_code   =>  'lock_area');

Line: 1650

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mapping_sets',
             p_component_code   =>  'lock_area');

Line: 1669

    xla_aad_loader_util_pvt.insert_aadloaderlog(
             p_amb_context_code =>  p_amb_context_code,
             p_application_id   =>  p_application_id,
             p_request_code     => 'IMPORT' ,
             p_log_type_code    => 'MERGE',
             p_encoded_message  => 'lock c_mapping_set_values',
             p_component_code   =>  'lock_area');

Line: 1742

    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: 1751

    SELECT 1
      FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = l_staging_amb_context_code;

Line: 1831

        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: 1837

  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: 1862

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

Line: 1867

  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: 1917

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

Line: 1932

        UPDATE SET base_version_num = s.base_version_num;

Line: 1935

  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: 1954

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

Line: 1959

  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: 2008

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

Line: 2120

  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: 2126

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

Line: 2134

  g_err_nums.DELETE;

Line: 2135

  g_err_msgs.DELETE;

Line: 2423

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

Line: 2434

    l_log_module := C_DEFAULT_MODULE||'.insert_errors';

Line: 2438

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

Line: 2444

    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: 2482

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

Line: 2488

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

Line: 2500

    trace(p_msg    => 'In exception of xla_aad_loader_util_pvt.insert_errors'
         ,p_module => l_log_module
         ,p_level  => C_LEVEL_PROCEDURE);

Line: 2506

    trace(p_msg    => 'Error in xla_aad_loader_util_pvt.insert_errors is : '||l_excp_code||'-'||l_exception
         ,p_module => l_log_module
         ,p_level  => C_LEVEL_PROCEDURE);

Line: 2515

               ,p_value_1         => 'xla_aad_loader_util_pvt.insert_errors'
               ,p_token_2         => 'ERROR'
               ,p_value_2         => sqlcode ||' - '||sqlerrm); --Bug 16208537

Line: 2520

END insert_errors;

Line: 2852

  SELECT application_short_name
    INTO l_short_name
    FROM fnd_application
   WHERE application_id    = p_application_id;

Line: 2857

  DELETE FROM xla_event_mappings_b     WHERE application_id = p_application_id;

Line: 2858

  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: 2863

  DELETE FROM xla_event_class_grps_b   WHERE application_id = p_application_id;

Line: 2864

  DELETE FROM xla_event_class_grps_tl  WHERE application_id = p_application_id;

Line: 2866

  DELETE FROM xla_entity_id_mappings   WHERE application_id = p_application_id;

Line: 2867

  DELETE FROM xla_event_class_attrs    WHERE application_id = p_application_id;

Line: 2868

  DELETE FROM xla_event_sources        WHERE application_id = p_application_id;

Line: 2869

  DELETE FROM xla_extract_objects      WHERE application_id = p_application_id;

Line: 2870

  DELETE FROM xla_reference_objects    WHERE application_id = p_application_id;

Line: 2871

  DELETE FROM xla_source_params        WHERE application_id = p_application_id;

Line: 2872

  DELETE FROM xla_evt_class_acct_attrs WHERE application_id = p_application_id;

Line: 2874

  DELETE FROM xla_event_types_tl       WHERE application_id = p_application_id;

Line: 2875

  DELETE FROM xla_event_types_b        WHERE application_id = p_application_id;

Line: 2876

  DELETE FROM xla_event_classes_tl     WHERE application_id = p_application_id;

Line: 2877

  DELETE FROM xla_event_classes_b      WHERE application_id = p_application_id;

Line: 2878

  DELETE FROM xla_entity_types_tl      WHERE application_id = p_application_id;

Line: 2879

  DELETE FROM xla_entity_types_b       WHERE application_id = p_application_id;

Line: 2881

  DELETE FROM xla_sources_tl           WHERE application_id = p_application_id;

Line: 2882

  DELETE FROM xla_sources_b            WHERE application_id = p_application_id;

Line: 2884

  DELETE FROM xla_subledgers           WHERE application_id = p_application_id;

Line: 2940

    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: 2986

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 2991

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  l_staging_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3000

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

Line: 3005

    DELETE FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 3010

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  l_staging_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3019

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

Line: 3024

    DELETE FROM xla_staging_components_h
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 3029

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  l_staging_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3038

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

Line: 3043

    DELETE FROM xla_stage_acctg_methods
     WHERE staging_amb_context_code = l_staging_context_code;

Line: 3048

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  l_staging_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_stage_acctg_methods) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3057

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

Line: 3064

    DELETE FROM xla_aad_loader_defns_t
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 3069

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3078

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

Line: 3083

    DELETE FROM xla_appli_amb_contexts
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 3088

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_appli_amb_contexts) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3097

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

Line: 3102

    DELETE FROM xla_staging_components_h
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 3107

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_staging_components_h) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3116

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

Line: 3121

    DELETE FROM xla_stage_acctg_methods
     WHERE staging_amb_context_code = p_amb_context_code;

Line: 3126

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_stage_acctg_methods) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3135

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

Line: 3141

  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: 3147

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_amb_setup_errors) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3156

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

Line: 3161

  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: 3167

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acctg_method_rules) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3176

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

Line: 3181

  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: 3187

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3196

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

Line: 3201

  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: 3207

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3216

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

Line: 3221

  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: 3227

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3236

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

Line: 3241

  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: 3247

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_adr_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3256

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

Line: 3261

  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: 3267

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3276

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

Line: 3281

  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: 3287

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3296

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

Line: 3301

  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: 3307

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3316

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

Line: 3321

  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: 3327

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3336

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

Line: 3341

  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: 3347

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3356

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

Line: 3361

  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: 3367

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_adr_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3376

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

Line: 3381

  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: 3387

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3396

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

Line: 3401

  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: 3407

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_definitions_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3416

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

Line: 3421

  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: 3427

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_line_definitions_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3436

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

Line: 3441

  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: 3447

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3456

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

Line: 3461

  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: 3467

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3476

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

Line: 3481

  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: 3487

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3497

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

Line: 3502

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

Line: 3508

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_conditions) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3517

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

Line: 3522

  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: 3534

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_analytical_sources) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3543

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

Line: 3548

  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: 3559

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_analytical_dtls_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3568

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

Line: 3573

  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: 3584

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_analytical_dtls_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3594

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

Line: 3599

  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: 3610

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_analytical_hdrs_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3620

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

Line: 3625

  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: 3631

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_analytical_hdrs_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3640

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

Line: 3645

  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: 3651

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_seg_rule_details) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3660

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

Line: 3665

  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: 3671

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_seg_rules_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3681

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

Line: 3686

  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: 3692

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_seg_rules_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3701

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

Line: 3706

  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: 3717

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3726

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

Line: 3731

  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: 3740

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3749

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

Line: 3754

  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: 3760

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3769

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

Line: 3774

  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: 3780

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descriptions_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3789

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

Line: 3794

  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: 3800

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_descriptions_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3809

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

Line: 3814

  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: 3820

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3829

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

Line: 3834

  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: 3840

xla_aad_loader_util_pvt.insert_aadloaderlog(
         p_amb_context_code =>  p_amb_context_code,
         p_application_id   =>  p_application_id,
         p_request_code     => 'IMPORT' ,
         p_log_type_code    => 'MERGE',
         p_encoded_message  => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
         p_component_code   =>  'purge_aad');

Line: 3849

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

Line: 3892

    SELECT analytical_criterion_type_code
         , analytical_criterion_code
         , amb_context_code
      FROM xla_analytical_hdrs_b;

Line: 3956

    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: 4119

  DELETE FROM xla_aads_h
   WHERE application_id = p_application_id;

Line: 4122

  DELETE FROM xla_amb_components_h
   WHERE application_id = p_application_id;

Line: 4125

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

Line: 4130

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

Line: 4135

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

Line: 4167

PROCEDURE insert_aadloaderlog(
             p_amb_context_code IN VARCHAR2
            ,p_application_id   IN NUMBER
            ,p_request_code     IN VARCHAR2
            ,p_log_type_code    IN VARCHAR2
            ,p_encoded_message  IN VARCHAR2
            ,p_component_code   IN VARCHAR2)
 IS
    PRAGMA AUTONOMOUS_TRANSACTION;

Line: 4177

  INSERT INTO xla_aad_loader_logs
         (aad_loader_log_id ,amb_context_code ,application_id  ,request_code ,log_type_code ,encoded_message ,message_num
         ,component_code ,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 ,p_log_type_code ,p_encoded_message,0
        ,p_component_code ,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: 4191

 (p_location   => 'xla_aad_loader_util_pvt.insert_aadloaderlog');

Line: 4192

END insert_aadloaderlog;