APPS.XLA_00260_AAD_S_000001_PKG SQL Statements

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

Line: 1347

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 1417

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 1868

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 1938

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 2389

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 2459

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 2910

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 2980

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 3431

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 3501

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 3952

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 4022

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 4477

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 4547

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 5002

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 5072

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 5527

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 5597

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 6052

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 6122

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 6577

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 6647

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 7102

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 7172

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 7627

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 7697

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 8152

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 8222

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 8689

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 8759

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 9226

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 9296

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 9763

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 9833

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 10300

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
         ,p_balance_type_code => l_balance_type_code
         );

Line: 10370

      XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
               (p_hdr_idx           => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);

Line: 10410

PROCEDURE insert_sources_26(
                                p_target_ledger_id       IN NUMBER
                              , p_language               IN VARCHAR2
                              , p_sla_ledger_id          IN NUMBER
                              , p_pad_start_date         IN DATE
                              , p_pad_end_date           IN DATE
                         )
IS

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'CE_BAT_CLEARED';

Line: 10425

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_26';

Line: 10430

         (p_msg      => 'BEGIN of insert_sources_26'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 10437

SELECT oracle_username
  INTO p_apps_owner
  FROM fnd_oracle_userid
 WHERE read_only_flag = 'U'
;

Line: 10457

INSERT INTO xla_diag_sources --hdr1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT
        event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value ,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , 0                             line_number
            , CASE r
               WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                WHEN 7 THEN 'HEADER' 
                WHEN 8 THEN 'HEADER' 
                WHEN 9 THEN 'HEADER' 
                WHEN 10 THEN 'HEADER' 
                WHEN 11 THEN 'HEADER' 
                WHEN 12 THEN 'HEADER' 
                WHEN 13 THEN 'HEADER' 
                WHEN 14 THEN 'HEADER' 
                WHEN 15 THEN 'HEADER' 
                WHEN 16 THEN 'HEADER' 
                WHEN 17 THEN 'HEADER' 
                WHEN 18 THEN 'HEADER' 
                WHEN 19 THEN 'HEADER' 
                WHEN 20 THEN 'HEADER' 
                WHEN 21 THEN 'HEADER' 
                WHEN 22 THEN 'HEADER' 
                WHEN 23 THEN 'HEADER' 
                WHEN 24 THEN 'HEADER' 
                WHEN 25 THEN 'HEADER' 
                WHEN 26 THEN 'HEADER' 
                WHEN 27 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '260' 
                WHEN 2 THEN '260' 
                WHEN 3 THEN '260' 
                WHEN 4 THEN '260' 
                WHEN 5 THEN '260' 
                WHEN 6 THEN '260' 
                WHEN 7 THEN '260' 
                WHEN 8 THEN '260' 
                WHEN 9 THEN '260' 
                WHEN 10 THEN '260' 
                WHEN 11 THEN '260' 
                WHEN 12 THEN '260' 
                WHEN 13 THEN '260' 
                WHEN 14 THEN '260' 
                WHEN 15 THEN '260' 
                WHEN 16 THEN '260' 
                WHEN 17 THEN '260' 
                WHEN 18 THEN '260' 
                WHEN 19 THEN '260' 
                WHEN 20 THEN '260' 
                WHEN 21 THEN '260' 
                WHEN 22 THEN '260' 
                WHEN 23 THEN '260' 
                WHEN 24 THEN '260' 
                WHEN 25 THEN '260' 
                WHEN 26 THEN '260' 
                WHEN 27 THEN '260' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CF_BA_BANK_CHARGE_CCID' 
                WHEN 2 THEN 'CF_BA_BANK_ERROR_CCID' 
                WHEN 3 THEN 'CF_BA_CASH_ACCT_CCID' 
                WHEN 4 THEN 'CF_BA_FX_CHARGE_CCID' 
                WHEN 5 THEN 'CF_OFFSET_CCID' 
                WHEN 6 THEN 'CF_CLEARED_CHARGE_AMOUNT' 
                WHEN 7 THEN 'REVERSAL_INDICATOR' 
                WHEN 8 THEN 'CASHFLOW_NUMBER' 
                WHEN 9 THEN 'CASHFLOW_HIST_IDENTIFIER' 
                WHEN 10 THEN 'DISTRIBUTION_TYPE' 
                WHEN 11 THEN 'CF_BA_CURRENCY' 
                WHEN 12 THEN 'CF_CLEARED_EXCHANGE_DATE' 
                WHEN 13 THEN 'CF_CLEARED_EXCHANGE_RATE' 
                WHEN 14 THEN 'CF_CLEARED_EXC_RATE_TYPE' 
                WHEN 15 THEN 'REVERSAL_FIRST_DIST_ID' 
                WHEN 16 THEN 'REVERSAL_SECOND_DIST_ID' 
                WHEN 17 THEN 'REVERSAL_DIST_TYPE' 
                WHEN 18 THEN 'CF_CLEARED_ERROR_AMOUNT' 
                WHEN 19 THEN 'CF_FX_CHARGE_AMOUNT' 
                WHEN 20 THEN 'CF_DIRECTION' 
                WHEN 21 THEN 'CF_CLEARED_AMOUNT' 
                WHEN 22 THEN 'CF_AMOUNT' 
                WHEN 23 THEN 'CF_CURRENCY' 
                WHEN 24 THEN 'CF_EXCHANGE_DATE' 
                WHEN 25 THEN 'CF_EXCHANGE_RATE' 
                WHEN 26 THEN 'CF_EXCHANGE_RATE_TYPE' 
                WHEN 27 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.CF_BA_BANK_CHARGE_CCID)
                WHEN 2 THEN TO_CHAR(h1.CF_BA_BANK_ERROR_CCID)
                WHEN 3 THEN TO_CHAR(h1.CF_BA_CASH_ACCT_CCID)
                WHEN 4 THEN TO_CHAR(h1.CF_BA_FX_CHARGE_CCID)
                WHEN 5 THEN TO_CHAR(h1.CF_OFFSET_CCID)
                WHEN 6 THEN TO_CHAR(h1.CF_CLEARED_CHARGE_AMOUNT)
                WHEN 7 THEN TO_CHAR(h1.REVERSAL_INDICATOR)
                WHEN 8 THEN TO_CHAR(h1.CASHFLOW_NUMBER)
                WHEN 9 THEN TO_CHAR(h1.CASHFLOW_HIST_IDENTIFIER)
                WHEN 10 THEN TO_CHAR(h1.DISTRIBUTION_TYPE)
                WHEN 11 THEN TO_CHAR(h1.CF_BA_CURRENCY)
                WHEN 12 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_DATE)
                WHEN 13 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_RATE)
                WHEN 14 THEN TO_CHAR(h1.CF_CLEARED_EXC_RATE_TYPE)
                WHEN 15 THEN TO_CHAR(h1.REVERSAL_FIRST_DIST_ID)
                WHEN 16 THEN TO_CHAR(h1.REVERSAL_SECOND_DIST_ID)
                WHEN 17 THEN TO_CHAR(h1.REVERSAL_DIST_TYPE)
                WHEN 18 THEN TO_CHAR(h1.CF_CLEARED_ERROR_AMOUNT)
                WHEN 19 THEN TO_CHAR(h1.CF_FX_CHARGE_AMOUNT)
                WHEN 20 THEN TO_CHAR(h1.CF_DIRECTION)
                WHEN 21 THEN TO_CHAR(h1.CF_CLEARED_AMOUNT)
                WHEN 22 THEN TO_CHAR(h1.CF_AMOUNT)
                WHEN 23 THEN TO_CHAR(h1.CF_CURRENCY)
                WHEN 24 THEN TO_CHAR(h1.CF_EXCHANGE_DATE)
                WHEN 25 THEN TO_CHAR(h1.CF_EXCHANGE_RATE)
                WHEN 26 THEN TO_CHAR(h1.CF_EXCHANGE_RATE_TYPE)
                WHEN 27 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 20 THEN fvl22.meaning
                
                ELSE null
              END               source_meaning
        FROM xla_events_gt     xet  
      , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
            ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
       WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
         AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
)
;

Line: 10684

         (p_msg      => 'number of header sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 10696

         (p_msg      => 'END of insert_sources_26'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 10717

           (p_location => 'XLA_00260_AAD_S_000001_PKG.insert_sources_26');

Line: 10718

END insert_sources_26;

Line: 10873

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: CE_BAT_CLEARED
-- Event Class Code: BAT_CLASS
    xet.entity_id
  , xet.legal_entity_id
  , xet.entity_code
  , xet.transaction_number
  , xet.event_id
  , xet.event_class_code
  , xet.event_type_code
  , xet.event_number
  , xet.event_date
  , xet.transaction_date
  , xet.reference_num_1
  , xet.reference_num_2
  , xet.reference_num_3
  , xet.reference_num_4
  , xet.reference_char_1
  , xet.reference_char_2
  , xet.reference_char_3
  , xet.reference_char_4
  , xet.reference_date_1
  , xet.reference_date_2
  , xet.reference_date_3
  , xet.reference_date_4
  , xet.event_created_by
  , xet.budgetary_control_flag 
  , h1.CF_BA_BANK_CHARGE_CCID    source_3
  , h1.CF_BA_BANK_ERROR_CCID    source_4
  , h1.CF_BA_CASH_ACCT_CCID    source_5
  , h1.CF_BA_FX_CHARGE_CCID    source_6
  , h1.CF_OFFSET_CCID    source_7
  , h1.CF_CLEARED_CHARGE_AMOUNT    source_8
  , h1.REVERSAL_INDICATOR    source_9
  , h1.CASHFLOW_NUMBER    source_10
  , h1.CASHFLOW_HIST_IDENTIFIER    source_11
  , h1.DISTRIBUTION_TYPE    source_12
  , h1.CF_BA_CURRENCY    source_13
  , h1.CF_CLEARED_EXCHANGE_DATE    source_14
  , h1.CF_CLEARED_EXCHANGE_RATE    source_15
  , h1.CF_CLEARED_EXC_RATE_TYPE    source_16
  , h1.REVERSAL_FIRST_DIST_ID    source_17
  , h1.REVERSAL_SECOND_DIST_ID    source_18
  , h1.REVERSAL_DIST_TYPE    source_19
  , h1.CF_CLEARED_ERROR_AMOUNT    source_20
  , h1.CF_FX_CHARGE_AMOUNT    source_21
  , h1.CF_DIRECTION    source_22
  , fvl22.meaning   source_22_meaning
  , h1.CF_CLEARED_AMOUNT    source_23
  , h1.CF_AMOUNT    source_24
  , h1.CF_CURRENCY    source_25
  , h1.CF_EXCHANGE_DATE    source_26
  , h1.CF_EXCHANGE_RATE    source_27
  , h1.CF_EXCHANGE_RATE_TYPE    source_28
  , h1.ACCOUNTING_DATE    source_29
  FROM xla_events_gt     xet 
  , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
 ORDER BY event_id
;

Line: 10946

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: CE_BAT_CLEARED
-- Event Class Code: BAT_CLASS
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag  , 0 
  FROM xla_events_gt     xet  
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  ;

Line: 11005

g_array_event.DELETE;

Line: 11262

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 11283

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 11752

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 11760

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 11816

PROCEDURE insert_sources_27(
                                p_target_ledger_id       IN NUMBER
                              , p_language               IN VARCHAR2
                              , p_sla_ledger_id          IN NUMBER
                              , p_pad_start_date         IN DATE
                              , p_pad_end_date           IN DATE
                         )
IS

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'CE_BAT_UNCLEARED';

Line: 11831

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_27';

Line: 11836

         (p_msg      => 'BEGIN of insert_sources_27'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 11843

SELECT oracle_username
  INTO p_apps_owner
  FROM fnd_oracle_userid
 WHERE read_only_flag = 'U'
;

Line: 11863

INSERT INTO xla_diag_sources --hdr1
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT
        event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value ,1,1996)
      , SUBSTR(source_meaning,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , 0                             line_number
            , CASE r
               WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                WHEN 7 THEN 'HEADER' 
                WHEN 8 THEN 'HEADER' 
                WHEN 9 THEN 'HEADER' 
                WHEN 10 THEN 'HEADER' 
                WHEN 11 THEN 'HEADER' 
                WHEN 12 THEN 'HEADER' 
                WHEN 13 THEN 'HEADER' 
                WHEN 14 THEN 'HEADER' 
                WHEN 15 THEN 'HEADER' 
                WHEN 16 THEN 'HEADER' 
                WHEN 17 THEN 'HEADER' 
                WHEN 18 THEN 'HEADER' 
                WHEN 19 THEN 'HEADER' 
                WHEN 20 THEN 'HEADER' 
                WHEN 21 THEN 'HEADER' 
                WHEN 22 THEN 'HEADER' 
                WHEN 23 THEN 'HEADER' 
                WHEN 24 THEN 'HEADER' 
                WHEN 25 THEN 'HEADER' 
                WHEN 26 THEN 'HEADER' 
                WHEN 27 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '260' 
                WHEN 2 THEN '260' 
                WHEN 3 THEN '260' 
                WHEN 4 THEN '260' 
                WHEN 5 THEN '260' 
                WHEN 6 THEN '260' 
                WHEN 7 THEN '260' 
                WHEN 8 THEN '260' 
                WHEN 9 THEN '260' 
                WHEN 10 THEN '260' 
                WHEN 11 THEN '260' 
                WHEN 12 THEN '260' 
                WHEN 13 THEN '260' 
                WHEN 14 THEN '260' 
                WHEN 15 THEN '260' 
                WHEN 16 THEN '260' 
                WHEN 17 THEN '260' 
                WHEN 18 THEN '260' 
                WHEN 19 THEN '260' 
                WHEN 20 THEN '260' 
                WHEN 21 THEN '260' 
                WHEN 22 THEN '260' 
                WHEN 23 THEN '260' 
                WHEN 24 THEN '260' 
                WHEN 25 THEN '260' 
                WHEN 26 THEN '260' 
                WHEN 27 THEN '260' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CF_BA_BANK_CHARGE_CCID' 
                WHEN 2 THEN 'CF_BA_BANK_ERROR_CCID' 
                WHEN 3 THEN 'CF_BA_CASH_ACCT_CCID' 
                WHEN 4 THEN 'CF_BA_FX_CHARGE_CCID' 
                WHEN 5 THEN 'CF_OFFSET_CCID' 
                WHEN 6 THEN 'CF_CLEARED_CHARGE_AMOUNT' 
                WHEN 7 THEN 'REVERSAL_INDICATOR' 
                WHEN 8 THEN 'CASHFLOW_NUMBER' 
                WHEN 9 THEN 'CASHFLOW_HIST_IDENTIFIER' 
                WHEN 10 THEN 'DISTRIBUTION_TYPE' 
                WHEN 11 THEN 'CF_BA_CURRENCY' 
                WHEN 12 THEN 'CF_CLEARED_EXCHANGE_DATE' 
                WHEN 13 THEN 'CF_CLEARED_EXCHANGE_RATE' 
                WHEN 14 THEN 'CF_CLEARED_EXC_RATE_TYPE' 
                WHEN 15 THEN 'REVERSAL_FIRST_DIST_ID' 
                WHEN 16 THEN 'REVERSAL_SECOND_DIST_ID' 
                WHEN 17 THEN 'REVERSAL_DIST_TYPE' 
                WHEN 18 THEN 'CF_CLEARED_ERROR_AMOUNT' 
                WHEN 19 THEN 'CF_FX_CHARGE_AMOUNT' 
                WHEN 20 THEN 'CF_DIRECTION' 
                WHEN 21 THEN 'CF_CLEARED_AMOUNT' 
                WHEN 22 THEN 'CF_AMOUNT' 
                WHEN 23 THEN 'CF_CURRENCY' 
                WHEN 24 THEN 'CF_EXCHANGE_DATE' 
                WHEN 25 THEN 'CF_EXCHANGE_RATE' 
                WHEN 26 THEN 'CF_EXCHANGE_RATE_TYPE' 
                WHEN 27 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.CF_BA_BANK_CHARGE_CCID)
                WHEN 2 THEN TO_CHAR(h1.CF_BA_BANK_ERROR_CCID)
                WHEN 3 THEN TO_CHAR(h1.CF_BA_CASH_ACCT_CCID)
                WHEN 4 THEN TO_CHAR(h1.CF_BA_FX_CHARGE_CCID)
                WHEN 5 THEN TO_CHAR(h1.CF_OFFSET_CCID)
                WHEN 6 THEN TO_CHAR(h1.CF_CLEARED_CHARGE_AMOUNT)
                WHEN 7 THEN TO_CHAR(h1.REVERSAL_INDICATOR)
                WHEN 8 THEN TO_CHAR(h1.CASHFLOW_NUMBER)
                WHEN 9 THEN TO_CHAR(h1.CASHFLOW_HIST_IDENTIFIER)
                WHEN 10 THEN TO_CHAR(h1.DISTRIBUTION_TYPE)
                WHEN 11 THEN TO_CHAR(h1.CF_BA_CURRENCY)
                WHEN 12 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_DATE)
                WHEN 13 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_RATE)
                WHEN 14 THEN TO_CHAR(h1.CF_CLEARED_EXC_RATE_TYPE)
                WHEN 15 THEN TO_CHAR(h1.REVERSAL_FIRST_DIST_ID)
                WHEN 16 THEN TO_CHAR(h1.REVERSAL_SECOND_DIST_ID)
                WHEN 17 THEN TO_CHAR(h1.REVERSAL_DIST_TYPE)
                WHEN 18 THEN TO_CHAR(h1.CF_CLEARED_ERROR_AMOUNT)
                WHEN 19 THEN TO_CHAR(h1.CF_FX_CHARGE_AMOUNT)
                WHEN 20 THEN TO_CHAR(h1.CF_DIRECTION)
                WHEN 21 THEN TO_CHAR(h1.CF_CLEARED_AMOUNT)
                WHEN 22 THEN TO_CHAR(h1.CF_AMOUNT)
                WHEN 23 THEN TO_CHAR(h1.CF_CURRENCY)
                WHEN 24 THEN TO_CHAR(h1.CF_EXCHANGE_DATE)
                WHEN 25 THEN TO_CHAR(h1.CF_EXCHANGE_RATE)
                WHEN 26 THEN TO_CHAR(h1.CF_EXCHANGE_RATE_TYPE)
                WHEN 27 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 20 THEN fvl22.meaning
                
                ELSE null
              END               source_meaning
        FROM xla_events_gt     xet  
      , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
            ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
       WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
         AND xet.event_type_code = C_EVENT_TYPE_CODE
            AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
)
;

Line: 12090

         (p_msg      => 'number of header sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 12102

         (p_msg      => 'END of insert_sources_27'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 12123

           (p_location => 'XLA_00260_AAD_S_000001_PKG.insert_sources_27');

Line: 12124

END insert_sources_27;

Line: 12279

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: CE_BAT_UNCLEARED
-- Event Class Code: BAT_CLASS
    xet.entity_id
  , xet.legal_entity_id
  , xet.entity_code
  , xet.transaction_number
  , xet.event_id
  , xet.event_class_code
  , xet.event_type_code
  , xet.event_number
  , xet.event_date
  , xet.transaction_date
  , xet.reference_num_1
  , xet.reference_num_2
  , xet.reference_num_3
  , xet.reference_num_4
  , xet.reference_char_1
  , xet.reference_char_2
  , xet.reference_char_3
  , xet.reference_char_4
  , xet.reference_date_1
  , xet.reference_date_2
  , xet.reference_date_3
  , xet.reference_date_4
  , xet.event_created_by
  , xet.budgetary_control_flag 
  , h1.CF_BA_BANK_CHARGE_CCID    source_3
  , h1.CF_BA_BANK_ERROR_CCID    source_4
  , h1.CF_BA_CASH_ACCT_CCID    source_5
  , h1.CF_BA_FX_CHARGE_CCID    source_6
  , h1.CF_OFFSET_CCID    source_7
  , h1.CF_CLEARED_CHARGE_AMOUNT    source_8
  , h1.REVERSAL_INDICATOR    source_9
  , h1.CASHFLOW_NUMBER    source_10
  , h1.CASHFLOW_HIST_IDENTIFIER    source_11
  , h1.DISTRIBUTION_TYPE    source_12
  , h1.CF_BA_CURRENCY    source_13
  , h1.CF_CLEARED_EXCHANGE_DATE    source_14
  , h1.CF_CLEARED_EXCHANGE_RATE    source_15
  , h1.CF_CLEARED_EXC_RATE_TYPE    source_16
  , h1.REVERSAL_FIRST_DIST_ID    source_17
  , h1.REVERSAL_SECOND_DIST_ID    source_18
  , h1.REVERSAL_DIST_TYPE    source_19
  , h1.CF_CLEARED_ERROR_AMOUNT    source_20
  , h1.CF_FX_CHARGE_AMOUNT    source_21
  , h1.CF_DIRECTION    source_22
  , fvl22.meaning   source_22_meaning
  , h1.CF_CLEARED_AMOUNT    source_23
  , h1.CF_AMOUNT    source_24
  , h1.CF_CURRENCY    source_25
  , h1.CF_EXCHANGE_DATE    source_26
  , h1.CF_EXCHANGE_RATE    source_27
  , h1.CF_EXCHANGE_RATE_TYPE    source_28
  , h1.ACCOUNTING_DATE    source_29
  FROM xla_events_gt     xet 
  , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
 ORDER BY event_id
;

Line: 12352

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Type Code: CE_BAT_UNCLEARED
-- Event Class Code: BAT_CLASS
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag  , 0 
  FROM xla_events_gt     xet  
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_type_code = C_EVENT_TYPE_CODE
   and xet.event_status_code <> 'N'  ;

Line: 12411

g_array_event.DELETE;

Line: 12668

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 12689

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 13158

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 13166

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 13222

PROCEDURE insert_sources_28(
                                p_target_ledger_id       IN NUMBER
                              , p_language               IN VARCHAR2
                              , p_sla_ledger_id          IN NUMBER
                              , p_pad_start_date         IN DATE
                              , p_pad_end_date           IN DATE
                         )
IS

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'STMT_CLASS_ALL';

Line: 13237

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_28';

Line: 13242

         (p_msg      => 'BEGIN of insert_sources_28'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 13249

SELECT oracle_username
  INTO p_apps_owner
  FROM fnd_oracle_userid
 WHERE read_only_flag = 'U'
;

Line: 13269

INSERT INTO xla_diag_sources --hdr2
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT
        event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value ,1,1996)
      , SUBSTR(source_meaning ,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , 0                          line_number
            , CASE r
               WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V' 
                WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                WHEN 7 THEN 'HEADER' 
                WHEN 8 THEN 'HEADER' 
                WHEN 9 THEN 'HEADER' 
                WHEN 10 THEN 'HEADER' 
                WHEN 11 THEN 'HEADER' 
                WHEN 12 THEN 'HEADER' 
                WHEN 13 THEN 'HEADER' 
                WHEN 14 THEN 'HEADER' 
                WHEN 15 THEN 'HEADER' 
                WHEN 16 THEN 'HEADER' 
                WHEN 17 THEN 'HEADER' 
                WHEN 18 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '260' 
                WHEN 2 THEN '260' 
                WHEN 3 THEN '260' 
                WHEN 4 THEN '260' 
                WHEN 5 THEN '260' 
                WHEN 6 THEN '260' 
                WHEN 7 THEN '260' 
                WHEN 8 THEN '260' 
                WHEN 9 THEN '260' 
                WHEN 10 THEN '260' 
                WHEN 11 THEN '260' 
                WHEN 12 THEN '260' 
                WHEN 13 THEN '260' 
                WHEN 14 THEN '260' 
                WHEN 15 THEN '260' 
                WHEN 16 THEN '260' 
                WHEN 17 THEN '260' 
                WHEN 18 THEN '260' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CF_REFERENCE_TEXT' 
                WHEN 2 THEN 'CF_DESCRIPTION' 
                WHEN 3 THEN 'CF_BA_CASH_ACCT_CCID' 
                WHEN 4 THEN 'CF_OFFSET_CCID' 
                WHEN 5 THEN 'REVERSAL_INDICATOR' 
                WHEN 6 THEN 'CASHFLOW_NUMBER' 
                WHEN 7 THEN 'CASHFLOW_HIST_IDENTIFIER' 
                WHEN 8 THEN 'DISTRIBUTION_TYPE' 
                WHEN 9 THEN 'CF_BA_CURRENCY' 
                WHEN 10 THEN 'CF_CLEARED_EXCHANGE_DATE' 
                WHEN 11 THEN 'CF_CLEARED_EXCHANGE_RATE' 
                WHEN 12 THEN 'CF_CLEARED_EXC_RATE_TYPE' 
                WHEN 13 THEN 'REVERSAL_FIRST_DIST_ID' 
                WHEN 14 THEN 'REVERSAL_SECOND_DIST_ID' 
                WHEN 15 THEN 'REVERSAL_DIST_TYPE' 
                WHEN 16 THEN 'CF_DIRECTION' 
                WHEN 17 THEN 'CF_CLEARED_AMOUNT' 
                WHEN 18 THEN 'ACCOUNTING_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.CF_REFERENCE_TEXT)
                WHEN 2 THEN TO_CHAR(h1.CF_DESCRIPTION)
                WHEN 3 THEN TO_CHAR(h1.CF_BA_CASH_ACCT_CCID)
                WHEN 4 THEN TO_CHAR(h1.CF_OFFSET_CCID)
                WHEN 5 THEN TO_CHAR(h1.REVERSAL_INDICATOR)
                WHEN 6 THEN TO_CHAR(h1.CASHFLOW_NUMBER)
                WHEN 7 THEN TO_CHAR(h1.CASHFLOW_HIST_IDENTIFIER)
                WHEN 8 THEN TO_CHAR(h1.DISTRIBUTION_TYPE)
                WHEN 9 THEN TO_CHAR(h1.CF_BA_CURRENCY)
                WHEN 10 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_DATE)
                WHEN 11 THEN TO_CHAR(h1.CF_CLEARED_EXCHANGE_RATE)
                WHEN 12 THEN TO_CHAR(h1.CF_CLEARED_EXC_RATE_TYPE)
                WHEN 13 THEN TO_CHAR(h1.REVERSAL_FIRST_DIST_ID)
                WHEN 14 THEN TO_CHAR(h1.REVERSAL_SECOND_DIST_ID)
                WHEN 15 THEN TO_CHAR(h1.REVERSAL_DIST_TYPE)
                WHEN 16 THEN TO_CHAR(h1.CF_DIRECTION)
                WHEN 17 THEN TO_CHAR(h1.CF_CLEARED_AMOUNT)
                WHEN 18 THEN TO_CHAR(h1.ACCOUNTING_DATE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 16 THEN fvl22.meaning
                
                ELSE null
              END               source_meaning
         FROM xla_events_gt     xet  
      , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
             ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
)
;

Line: 13452

         (p_msg      => 'number of header sources inserted = '||SQL%ROWCOUNT
         ,p_level    => C_LEVEL_STATEMENT
         ,p_module   => l_log_module);

Line: 13464

         (p_msg      => 'END of insert_sources_28'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 13485

           (p_location => 'XLA_00260_AAD_S_000001_PKG.insert_sources_28');

Line: 13486

END insert_sources_28;

Line: 13623

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: STMT_CLASS
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag 
  , h1.CF_REFERENCE_TEXT    source_1
  , h1.CF_DESCRIPTION    source_2
  , h1.CF_BA_CASH_ACCT_CCID    source_5
  , h1.CF_OFFSET_CCID    source_7
  , h1.REVERSAL_INDICATOR    source_9
  , h1.CASHFLOW_NUMBER    source_10
  , h1.CASHFLOW_HIST_IDENTIFIER    source_11
  , h1.DISTRIBUTION_TYPE    source_12
  , h1.CF_BA_CURRENCY    source_13
  , h1.CF_CLEARED_EXCHANGE_DATE    source_14
  , h1.CF_CLEARED_EXCHANGE_RATE    source_15
  , h1.CF_CLEARED_EXC_RATE_TYPE    source_16
  , h1.REVERSAL_FIRST_DIST_ID    source_17
  , h1.REVERSAL_SECOND_DIST_ID    source_18
  , h1.REVERSAL_DIST_TYPE    source_19
  , h1.CF_DIRECTION    source_22
  , fvl22.meaning   source_22_meaning
  , h1.CF_CLEARED_AMOUNT    source_23
  , h1.ACCOUNTING_DATE    source_29
  FROM xla_events_gt     xet 
  , CE_XLA_EXT_HEADERS_V  h1
  , fnd_lookup_values    fvl22
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h1.event_id = xet.event_id
   AND fvl22.lookup_type(+)         = 'CE_CASHFLOW_DIRECTION'
  AND fvl22.lookup_code(+)         = h1.CF_DIRECTION
  AND fvl22.view_application_id(+) = 260
  AND fvl22.language(+)            = USERENV('LANG')
  
 ORDER BY event_id
;

Line: 13686

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: STMT_CLASS
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag
 , 0 
  FROM xla_events_gt     xet  
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  ;

Line: 13745

g_array_event.DELETE;

Line: 13993

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 14014

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 14394

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 14402

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 14526

         insert_sources_26(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );

Line: 14560

         insert_sources_27(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );

Line: 14594

         insert_sources_28(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );