APPS.XLA_SEQUENCE_DATAFIX_PKG SQL Statements

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

Line: 120

    SELECT accounting_entry_status_code, completion_acct_seq_version_id, completed_date
      INTO l_entry_status_code, l_seq_ver_id, l_start_date
      FROM xla_ae_headers
     WHERE ae_header_id   = p_ae_header_id
       AND application_id = p_application_id;

Line: 167

    SELECT start_date
      INTO l_start_date
      FROM gl_period_statuses
     WHERE ledger_id=p_ledger_id
       AND application_id = 101
       AND period_name = p_period_name;

Line: 213

    INSERT INTO xla_events_gt
      (event_id
      ,application_id
      ,ledger_id
      ,entity_code
      ,event_type_code
      ,event_date
      ,event_status_code
      )
    SELECT DISTINCT
      event_id
      ,p_application_id
      ,p_ledger_id
      ,'a'
      ,'a'
      ,sysdate
      ,'U'
    FROM xla_ae_headers
    WHERE completion_acct_seq_version_id = l_seq_ver_id
      AND ledger_id = p_ledger_id
      AND application_id = p_application_id
      AND accounting_entry_status_code = 'F'
      AND completed_date >= l_start_date;

Line: 239

           (p_msg      => ' ver_id is not null, # of rows inserted:'||to_char(l_result)
           ,p_level    => C_LEVEL_STATEMENT
           ,p_module   => l_log_module);

Line: 245

    INSERT INTO xla_events_gt
      (event_id
      ,application_id
      ,ledger_id
      ,entity_code
      ,event_type_code
      ,event_date
      ,event_status_code
      )
    SELECT DISTINCT
      event_id
      ,p_application_id
      ,p_ledger_id
      ,'a'
      ,'a'
      ,sysdate
     ,'U'
    FROM xla_ae_headers
    WHERE ledger_id = p_ledger_id
      AND application_id = p_application_id
      AND accounting_entry_status_code = 'F'
      AND (completed_date >= l_start_date or completed_date is null);

Line: 271

           (p_msg      => ' ver_id is null, # of rows inserted:'||to_char(l_result)
           ,p_level    => C_LEVEL_STATEMENT
           ,p_module   => l_log_module);

Line: 359

  SELECT min(completion_acct_seq_value), completion_acct_seq_version_id
    FROM xla_ae_headers
   WHERE ledger_id = p_ledger_id
     AND application_id = p_application_id
     AND (completed_date >= p_start_date or completed_date is null)
     AND accounting_entry_status_code = 'F'
     --AND completion_acct_seq_version_id is not null
  GROUP BY completion_acct_seq_version_id;

Line: 386

    SELECT min(completion_acct_seq_value)
      INTO l_seq_value
      FROM xla_ae_headers
     WHERE ledger_id = p_ledger_id
       AND application_id = p_application_id
       AND accounting_entry_status_code = 'F'
       AND completed_date >= p_start_date
       AND completion_acct_seq_version_id = p_seq_ver_id;

Line: 406

      UPDATE xla_ae_headers
         SET completion_acct_seq_version_id = null
            ,completion_acct_seq_value = null
            ,completion_acct_seq_assign_id = null
            ,completed_date = null
       WHERE ledger_id = p_ledger_id
         AND application_id = p_application_id
         AND completed_date >= p_start_date
         AND accounting_entry_status_code = 'F'
         AND completion_acct_seq_version_id = p_seq_ver_id;

Line: 446

    UPDATE xla_ae_headers
       SET completion_acct_seq_version_id = null
          ,completion_acct_seq_value = null
          ,completion_acct_seq_assign_id = null
          ,completed_date = null
     WHERE ledger_id = p_ledger_id
       AND application_id = p_application_id
       AND accounting_entry_status_code = 'F'
       AND (completed_date >= p_start_date or completed_date is null);