DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000005_PKG SQL Statements

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

Line: 4394

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PROCEDURE insert_sources_134(
                                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)  := 'ADJUSTMENT_ALL';
Line: 66656

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_134';
Line: 66661

         (p_msg      => 'BEGIN of insert_sources_134'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 66668

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

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 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 4 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 5 THEN 'AR_ADJUSTMENTS_H_V' 
                WHEN 6 THEN 'AR_ADJUSTMENTS_H_V' 
                WHEN 7 THEN 'AR_ADJUSTMENTS_H_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'REC_ACT_TYPE' 
                WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 3 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'ADJ_DOC_SEQUENCE_CATEGORY' 
                WHEN 6 THEN 'ADJ_DOC_SEQUENCE_ID' 
                WHEN 7 THEN 'ADJ_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h6.REC_ACT_TYPE)
                WHEN 2 THEN TO_CHAR(h2.BILL_CUST_ACCOUNT_ID)
                WHEN 3 THEN TO_CHAR(h3.BILL_USES_SITE_USE_ID)
                WHEN 4 THEN TO_CHAR(h7.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_CATEGORY)
                WHEN 6 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_ID)
                WHEN 7 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_VALUE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_ADJUSTMENTS_H_V  h1
      , AR_BILL_TO_CUSTOMERS_S_V  h2
      , AR_BILL_TO_SITE_USES_S_V  h3
      , AR_RECEIVABLES_TRX_ACT_S_V  h6
      , AR_TRANSACTIONS_S_V  h7
             ,(select rownum r from all_objects where rownum <= 7 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 h2.event_id  = h1.event_id
  AND h3.event_id  = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h7.event_id  = h1.event_id

)
;
Line: 66815

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l5.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 2 THEN 'DIST_SOURCE_TYPE' 
                WHEN 3 THEN 'DIST_LINE_ID' 
                WHEN 4 THEN 'DISTRIBUTION_TYPE' 
                WHEN 5 THEN 'DIST_ENT_AMT' 
                WHEN 6 THEN 'DIST_CURRENCY_CODE' 
                WHEN 7 THEN 'DIST_CUR_CONVERSION_DATE' 
                WHEN 8 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 9 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 10 THEN 'DIST_TO_ACCTD_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l5.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l5.DIST_SOURCE_TYPE)
                WHEN 3 THEN TO_CHAR(l5.DIST_LINE_ID)
                WHEN 4 THEN TO_CHAR(l5.DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l5.DIST_ENT_AMT)
                WHEN 6 THEN TO_CHAR(l5.DIST_CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_DATE)
                WHEN 8 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_RATE)
                WHEN 9 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_TYPE)
                WHEN 10 THEN TO_CHAR(l4.DIST_TO_ACCTD_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_DISTRIBUTIONS_BASE_V  l4
        , AR_DISTRIBUTIONS_L_V  l5
            , (select rownum r from all_objects where rownum <= 10 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 l4.event_id          = xet.event_id
  AND l5.event_id    = l4.event_id
  AND l5.line_number = l4.line_number

)
;
Line: 66961

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

         (p_msg      => 'END of insert_sources_134'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 66991

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_134');
Line: 66992

END insert_sources_134;
Line: 67128

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
    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 
  , h6.REC_ACT_TYPE    source_21
  , h2.BILL_CUST_ACCOUNT_ID    source_30
  , h3.BILL_USES_SITE_USE_ID    source_31
  , h7.XLA_PARTY_TYPE    source_32
  , h1.ADJ_DOC_SEQUENCE_CATEGORY    source_77
  , h1.ADJ_DOC_SEQUENCE_ID    source_78
  , h1.ADJ_DOC_SEQUENCE_VALUE    source_79
  FROM xla_events_gt     xet 
  , AR_ADJUSTMENTS_H_V  h1
  , AR_BILL_TO_CUSTOMERS_S_V  h2
  , AR_BILL_TO_SITE_USES_S_V  h3
  , AR_RECEIVABLES_TRX_ACT_S_V  h6
  , AR_TRANSACTIONS_S_V  h7
 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 h2.event_id  = h1.event_id
  AND h3.event_id  = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h7.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 67182

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
    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
 , l4.LINE_NUMBER  
  , l5.DIST_CODE_COMBINATION_ID    source_5
  , l5.DIST_SOURCE_TYPE    source_20
  , l5.DIST_LINE_ID    source_22
  , l5.DISTRIBUTION_TYPE    source_23
  , l5.DIST_ENT_AMT    source_24
  , l5.DIST_CURRENCY_CODE    source_25
  , l4.DIST_CUR_CONVERSION_DATE    source_26
  , l4.DIST_CUR_CONVERSION_RATE    source_27
  , l4.DIST_CUR_CONVERSION_TYPE    source_28
  , l4.DIST_TO_ACCTD_AMT    source_29
  FROM xla_events_gt     xet 
  , AR_DISTRIBUTIONS_BASE_V  l4
  , AR_DISTRIBUTIONS_L_V  l5
 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'   AND l4.event_id      = xet.event_id
  AND l5.event_id    = l4.event_id
  AND l5.line_number = l4.line_number
;
Line: 67256

g_array_event.DELETE;
Line: 67482

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 67503

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 67993

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 68001

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 68092

PROCEDURE insert_sources_135(
                                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)  := 'CHARGEBACK_ALL';
Line: 68107

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_135';
Line: 68112

         (p_msg      => 'BEGIN of insert_sources_135'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 68119

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

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 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 4 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 5 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 6 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 7 THEN 'AR_TRANSACTIONS_S_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 3 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                WHEN 2 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 3 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_BILL_TO_CUSTOMERS_S_V  h1
      , AR_BILL_TO_SITE_USES_S_V  h2
      , AR_TRANSACTIONS_S_V  h5
             ,(select rownum r from all_objects where rownum <= 7 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 68262

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 3 THEN 'TRX_LINE_DIST_ID' 
                WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 5 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 9 THEN 'TRX_LINE_ACCTD_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
            , (select rownum r from all_objects where rownum <= 9 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 l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number

)
;
Line: 68403

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

         (p_msg      => 'END of insert_sources_135'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 68433

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_135');
Line: 68434

END insert_sources_135;
Line: 68568

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CHARGEBACK
    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 
  , h5.TRX_DOC_SEQUENCE_VALUE    source_3
  , h1.BILL_CUST_ACCOUNT_ID    source_30
  , h2.BILL_USES_SITE_USE_ID    source_31
  , h5.XLA_PARTY_TYPE    source_32
  , h5.TRX_INVOICE_CURRENCY_CODE    source_37
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_81
  , h5.TRX_DOC_SEQUENCE_ID    source_82
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  h1
  , AR_BILL_TO_SITE_USES_S_V  h2
  , AR_TRANSACTIONS_S_V  h5
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 68618

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CHARGEBACK
    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
 , l3.LINE_NUMBER  
  , l4.TRX_LINE_DIST_CCID    source_19
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l4.TRX_LINE_DIST_ID    source_34
  , l4.TRX_DISTRIBUTION_TYPE    source_35
  , l4.TRX_LINE_DIST_AMT    source_36
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_38
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_39
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.TRX_LINE_ACCTD_AMT    source_41
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
;
Line: 68691

g_array_event.DELETE;
Line: 68917

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 68938

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 69239

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 69247

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 69338

PROCEDURE insert_sources_136(
                                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)  := 'CREDIT_MEMO_ALL';
Line: 69353

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_136';
Line: 69358

         (p_msg      => 'BEGIN of insert_sources_136'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 69365

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

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 'AR_SYSTEM_PARAM_H_V' 
                WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 3 THEN 'AR_CREDIT_MEMO_H_V' 
                WHEN 4 THEN 'AR_CREDIT_MEMO_H_V' 
                WHEN 5 THEN 'AR_CM_BILL_TO_CUST_H_V' 
                WHEN 6 THEN 'AR_CM_BILL_SITE_USES_H_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CODE_COMBINATION_ID_GAIN' 
                WHEN 2 THEN 'CODE_COMBINATION_ID_LOSS' 
                WHEN 3 THEN 'XLA_PARTY_TYPE' 
                WHEN 4 THEN 'CM_INVOICE_CURRENCY_CODE' 
                WHEN 5 THEN 'CM_BILL_CUST_ACCOUNT_ID' 
                WHEN 6 THEN 'CM_BILL_USES_SITE_USE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h8.CODE_COMBINATION_ID_GAIN)
                WHEN 2 THEN TO_CHAR(h8.CODE_COMBINATION_ID_LOSS)
                WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 4 THEN TO_CHAR(h5.CM_INVOICE_CURRENCY_CODE)
                WHEN 5 THEN TO_CHAR(h2.CM_BILL_CUST_ACCOUNT_ID)
                WHEN 6 THEN TO_CHAR(h1.CM_BILL_USES_SITE_USE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_CM_BILL_SITE_USES_H_V  h1
      , AR_CM_BILL_TO_CUST_H_V  h2
      , AR_CREDIT_MEMO_H_V  h5
      , AR_SYSTEM_PARAM_H_V  h8
             ,(select rownum r from all_objects where rownum <= 6 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id
  AND h8.event_id (+) = h1.event_id

)
;
Line: 69505

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l3.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 4 THEN 'AR_CM_LINES_L_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 9 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 10 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 11 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 12 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 13 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 14 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 15 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 16 THEN 'AR_CM_LINES_L_V' 
                WHEN 17 THEN 'AR_CM_LINES_L_V' 
                WHEN 18 THEN 'AR_CM_LINES_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                WHEN 18 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                WHEN 15 THEN '222' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                WHEN 18 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_TYPE_NAME' 
                WHEN 2 THEN 'TRX_NUMBER' 
                WHEN 3 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 4 THEN 'CM_LINE_DIST_CCID' 
                WHEN 5 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 6 THEN 'DIST_SOURCE_TYPE' 
                WHEN 7 THEN 'REC_ACT_TYPE' 
                WHEN 8 THEN 'DIST_ENT_AMT' 
                WHEN 9 THEN 'CM_DIST_IDENTIFER' 
                WHEN 10 THEN 'CM_DIST_TYPE' 
                WHEN 11 THEN 'CM_LINE_CUR_CONVERSION_DATE' 
                WHEN 12 THEN 'CM_LINE_CUR_CONVERSION_RATE' 
                WHEN 13 THEN 'CM_LINE_CUR_CONVERSION_TYPE' 
                WHEN 14 THEN 'GAIN_LOSS_REF' 
                WHEN 15 THEN 'CM_LINE_ACCTD_AMT' 
                WHEN 16 THEN 'CM_TAX_LINE_ID' 
                WHEN 17 THEN 'CM_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 18 THEN 'CM_LINE_DIST_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l9.TRX_TYPE_NAME)
                WHEN 2 THEN TO_CHAR(l9.TRX_NUMBER)
                WHEN 3 THEN TO_CHAR(l9.TRX_DOC_SEQUENCE_VALUE)
                WHEN 4 THEN TO_CHAR(l4.CM_LINE_DIST_CCID)
                WHEN 5 THEN TO_CHAR(l6.DIST_CODE_COMBINATION_ID)
                WHEN 6 THEN TO_CHAR(l6.DIST_SOURCE_TYPE)
                WHEN 7 THEN TO_CHAR(l7.REC_ACT_TYPE)
                WHEN 8 THEN TO_CHAR(l6.DIST_ENT_AMT)
                WHEN 9 THEN TO_CHAR(l3.CM_DIST_IDENTIFER)
                WHEN 10 THEN TO_CHAR(l3.CM_DIST_TYPE)
                WHEN 11 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_DATE)
                WHEN 12 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_RATE)
                WHEN 13 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_TYPE)
                WHEN 14 THEN TO_CHAR(l3.GAIN_LOSS_REF)
                WHEN 15 THEN TO_CHAR(l3.CM_LINE_ACCTD_AMT)
                WHEN 16 THEN TO_CHAR(l4.CM_TAX_LINE_ID)
                WHEN 17 THEN TO_CHAR(l4.CM_LINE_DIST_ACCOUNT_CLASS)
                WHEN 18 THEN TO_CHAR(l4.CM_LINE_DIST_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CM_LINES_BASE_V  l3
        , AR_CM_LINES_L_V  l4
        , AR_DISTRIBUTIONS_L_V  l6
        , AR_RECEIVABLES_TRX_ACT_S_V  l7
        , AR_TRANSACTIONS_S_V  l9
            , (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 l3.event_id          = xet.event_id
  AND l4.event_id (+)    = l3.event_id
  AND l4.line_number (+) = l3.line_number
  AND l6.event_id (+)    = l3.event_id
  AND l6.line_number (+) = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l9.event_id (+)    = l3.event_id
  AND l9.line_number (+) = l3.line_number

)
;
Line: 69700

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

         (p_msg      => 'END of insert_sources_136'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 69730

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_136');
Line: 69731

END insert_sources_136;
Line: 69881

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
    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 
  , h8.CODE_COMBINATION_ID_GAIN    source_7
  , h8.CODE_COMBINATION_ID_LOSS    source_8
  , h5.XLA_PARTY_TYPE    source_32
  , h5.CM_INVOICE_CURRENCY_CODE    source_44
  , h2.CM_BILL_CUST_ACCOUNT_ID    source_50
  , h1.CM_BILL_USES_SITE_USE_ID    source_51
  FROM xla_events_gt     xet 
  , AR_CM_BILL_SITE_USES_H_V  h1
  , AR_CM_BILL_TO_CUST_H_V  h2
  , AR_CREDIT_MEMO_H_V  h5
  , AR_SYSTEM_PARAM_H_V  h8
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id
  AND h8.event_id (+) = h1.event_id

 ORDER BY event_id
;
Line: 69932

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
    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
 , l3.LINE_NUMBER  
  , l9.TRX_TYPE_NAME    source_1
  , l9.TRX_NUMBER    source_2
  , l9.TRX_DOC_SEQUENCE_VALUE    source_3
  , l4.CM_LINE_DIST_CCID    source_4
  , l6.DIST_CODE_COMBINATION_ID    source_5
  , l6.DIST_SOURCE_TYPE    source_20
  , l7.REC_ACT_TYPE    source_21
  , l6.DIST_ENT_AMT    source_24
  , l3.CM_DIST_IDENTIFER    source_42
  , l3.CM_DIST_TYPE    source_43
  , l3.CM_LINE_CUR_CONVERSION_DATE    source_45
  , l3.CM_LINE_CUR_CONVERSION_RATE    source_46
  , l3.CM_LINE_CUR_CONVERSION_TYPE    source_47
  , l3.GAIN_LOSS_REF    source_48
  , l3.CM_LINE_ACCTD_AMT    source_49
  , l4.CM_TAX_LINE_ID    source_52
  , l4.CM_LINE_DIST_ACCOUNT_CLASS    source_53
  , l4.CM_LINE_DIST_AMT    source_54
  FROM xla_events_gt     xet 
  , AR_CM_LINES_BASE_V  l3
  , AR_CM_LINES_L_V  l4
  , AR_DISTRIBUTIONS_L_V  l6
  , AR_RECEIVABLES_TRX_ACT_S_V  l7
  , AR_TRANSACTIONS_S_V  l9
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id (+)    = l3.event_id
  AND l4.line_number (+) = l3.line_number
  AND l6.event_id (+)    = l3.event_id
  AND l6.line_number (+) = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l9.event_id (+)    = l3.event_id
  AND l9.line_number (+) = l3.line_number
;
Line: 70023

g_array_event.DELETE;
Line: 70241

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 70262

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 70971

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 70979

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 71070

PROCEDURE insert_sources_137(
                                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)  := 'DEBIT_MEMO_ALL';
Line: 71085

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_137';
Line: 71090

         (p_msg      => 'BEGIN of insert_sources_137'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 71097

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

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 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 4 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 5 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 6 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 7 THEN 'AR_TRANSACTIONS_S_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 3 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                WHEN 2 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 3 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_BILL_TO_CUSTOMERS_S_V  h1
      , AR_BILL_TO_SITE_USES_S_V  h2
      , AR_TRANSACTIONS_S_V  h5
             ,(select rownum r from all_objects where rownum <= 7 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 71240

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 3 THEN 'TRX_LINE_DIST_ID' 
                WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 5 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 9 THEN 'TRX_LINE_ACCTD_AMT' 
                WHEN 10 THEN 'TRX_TAX_LINE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                WHEN 10 THEN TO_CHAR(l4.TRX_TAX_LINE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
            , (select rownum r from all_objects where rownum <= 10 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 l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number

)
;
Line: 71386

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

         (p_msg      => 'END of insert_sources_137'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 71416

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_137');
Line: 71417

END insert_sources_137;
Line: 71553

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT_MEMO
    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 
  , h5.TRX_DOC_SEQUENCE_VALUE    source_3
  , h1.BILL_CUST_ACCOUNT_ID    source_30
  , h2.BILL_USES_SITE_USE_ID    source_31
  , h5.XLA_PARTY_TYPE    source_32
  , h5.TRX_INVOICE_CURRENCY_CODE    source_37
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_81
  , h5.TRX_DOC_SEQUENCE_ID    source_82
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  h1
  , AR_BILL_TO_SITE_USES_S_V  h2
  , AR_TRANSACTIONS_S_V  h5
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 71603

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT_MEMO
    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
 , l3.LINE_NUMBER  
  , l4.TRX_LINE_DIST_CCID    source_19
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l4.TRX_LINE_DIST_ID    source_34
  , l4.TRX_DISTRIBUTION_TYPE    source_35
  , l4.TRX_LINE_DIST_AMT    source_36
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_38
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_39
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.TRX_LINE_ACCTD_AMT    source_41
  , l4.TRX_TAX_LINE_ID    source_55
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
;
Line: 71677

g_array_event.DELETE;
Line: 71903

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 71924

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 72452

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 72460

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 72551

PROCEDURE insert_sources_138(
                                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)  := 'DEPOSIT_ALL';
Line: 72566

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_138';
Line: 72571

         (p_msg      => 'BEGIN of insert_sources_138'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 72578

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

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 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 4 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 5 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 6 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 7 THEN 'AR_TRANSACTIONS_S_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 3 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                WHEN 2 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 3 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_BILL_TO_CUSTOMERS_S_V  h1
      , AR_BILL_TO_SITE_USES_S_V  h2
      , AR_TRANSACTIONS_S_V  h5
             ,(select rownum r from all_objects where rownum <= 7 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 72721

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 3 THEN 'TRX_LINE_DIST_ID' 
                WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 5 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 9 THEN 'TRX_LINE_ACCTD_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
            , (select rownum r from all_objects where rownum <= 9 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 l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number

)
;
Line: 72862

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

         (p_msg      => 'END of insert_sources_138'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 72892

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_138');
Line: 72893

END insert_sources_138;
Line: 73027

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEPOSIT
    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 
  , h5.TRX_DOC_SEQUENCE_VALUE    source_3
  , h1.BILL_CUST_ACCOUNT_ID    source_30
  , h2.BILL_USES_SITE_USE_ID    source_31
  , h5.XLA_PARTY_TYPE    source_32
  , h5.TRX_INVOICE_CURRENCY_CODE    source_37
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_81
  , h5.TRX_DOC_SEQUENCE_ID    source_82
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  h1
  , AR_BILL_TO_SITE_USES_S_V  h2
  , AR_TRANSACTIONS_S_V  h5
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 73077

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEPOSIT
    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
 , l3.LINE_NUMBER  
  , l4.TRX_LINE_DIST_CCID    source_19
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l4.TRX_LINE_DIST_ID    source_34
  , l4.TRX_DISTRIBUTION_TYPE    source_35
  , l4.TRX_LINE_DIST_AMT    source_36
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_38
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_39
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.TRX_LINE_ACCTD_AMT    source_41
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
;
Line: 73150

g_array_event.DELETE;
Line: 73376

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 73397

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 73698

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 73706

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 73797

PROCEDURE insert_sources_139(
                                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)  := 'GUARANTEE_ALL';
Line: 73812

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_139';
Line: 73817

         (p_msg      => 'BEGIN of insert_sources_139'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 73824

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

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 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 4 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 5 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 6 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 7 THEN 'AR_TRANSACTIONS_S_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 3 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                WHEN 2 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 3 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_BILL_TO_CUSTOMERS_S_V  h1
      , AR_BILL_TO_SITE_USES_S_V  h2
      , AR_TRANSACTIONS_S_V  h5
             ,(select rownum r from all_objects where rownum <= 7 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 73967

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 3 THEN 'TRX_LINE_DIST_ID' 
                WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 5 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 9 THEN 'TRX_LINE_ACCTD_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
            , (select rownum r from all_objects where rownum <= 9 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 l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number

)
;
Line: 74108

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

         (p_msg      => 'END of insert_sources_139'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 74138

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_139');
Line: 74139

END insert_sources_139;
Line: 74273

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GUARANTEE
    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 
  , h5.TRX_DOC_SEQUENCE_VALUE    source_3
  , h1.BILL_CUST_ACCOUNT_ID    source_30
  , h2.BILL_USES_SITE_USE_ID    source_31
  , h5.XLA_PARTY_TYPE    source_32
  , h5.TRX_INVOICE_CURRENCY_CODE    source_37
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_81
  , h5.TRX_DOC_SEQUENCE_ID    source_82
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  h1
  , AR_BILL_TO_SITE_USES_S_V  h2
  , AR_TRANSACTIONS_S_V  h5
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 74323

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GUARANTEE
    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
 , l3.LINE_NUMBER  
  , l4.TRX_LINE_DIST_CCID    source_19
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l4.TRX_LINE_DIST_ID    source_34
  , l4.TRX_DISTRIBUTION_TYPE    source_35
  , l4.TRX_LINE_DIST_AMT    source_36
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_38
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_39
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.TRX_LINE_ACCTD_AMT    source_41
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
;
Line: 74396

g_array_event.DELETE;
Line: 74622

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 74643

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 74944

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 74952

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 75043

PROCEDURE insert_sources_140(
                                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)  := 'INVOICE_ALL';
Line: 75058

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_140';
Line: 75063

         (p_msg      => 'BEGIN of insert_sources_140'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 75070

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

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 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 6 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 7 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 8 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 9 THEN 'AR_TRANSACTIONS_S_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 2 THEN 'BILL_CUSTOMER_CLASS_CODE' 
                WHEN 3 THEN 'TRX_RECEIVABLE_CCID' 
                WHEN 4 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 5 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 6 THEN 'XLA_PARTY_TYPE' 
                WHEN 7 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 8 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                WHEN 2 THEN TO_CHAR(h1.BILL_CUSTOMER_CLASS_CODE)
                WHEN 3 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
                WHEN 4 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 5 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 6 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 7 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_BILL_TO_CUSTOMERS_S_V  h1
      , AR_BILL_TO_SITE_USES_S_V  h2
      , AR_TRANSACTIONS_S_V  h5
             ,(select rownum r from all_objects where rownum <= 9 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 75223

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'FV_XLA_AR_REF_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 12 THEN 'FV_XLA_AR_REF_V' 
                WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '8901' 
                WHEN 13 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 2 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 3 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 4 THEN 'TRX_LINE_DIST_ID' 
                WHEN 5 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 6 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 9 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 10 THEN 'TRX_LINE_ACCTD_AMT' 
                WHEN 11 THEN 'TRX_TAX_LINE_ID' 
                WHEN 12 THEN 'FEDERAL_ACCOUNT_VALID_FLAG' 
                WHEN 13 THEN 'ROUNDING_CORRECTION_FLAG' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 4 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 5 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 6 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 10 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                WHEN 11 THEN TO_CHAR(l4.TRX_TAX_LINE_ID)
                WHEN 12 THEN TO_CHAR(l6.FEDERAL_ACCOUNT_VALID_FLAG)
                WHEN 13 THEN TO_CHAR(l3.ROUNDING_CORRECTION_FLAG)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
        , FV_XLA_AR_REF_V  l6
            , (select rownum r from all_objects where rownum <= 13 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 l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
 AND l6.federal_event_id   (+) =  l4.event_id  and l6.federal_line_number   (+) =  l4.line_number
)
;
Line: 75385

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

         (p_msg      => 'END of insert_sources_140'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 75415

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_140');
Line: 75416

END insert_sources_140;
Line: 75562

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
    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 
  , h5.TRX_DOC_SEQUENCE_VALUE    source_3
  , h1.BILL_CUSTOMER_CLASS_CODE    source_10
  , h5.TRX_RECEIVABLE_CCID    source_16
  , h1.BILL_CUST_ACCOUNT_ID    source_30
  , h2.BILL_USES_SITE_USE_ID    source_31
  , h5.XLA_PARTY_TYPE    source_32
  , h5.TRX_INVOICE_CURRENCY_CODE    source_37
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_81
  , h5.TRX_DOC_SEQUENCE_ID    source_82
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  h1
  , AR_BILL_TO_SITE_USES_S_V  h2
  , AR_TRANSACTIONS_S_V  h5
 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 h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

 ORDER BY event_id
;
Line: 75614

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
    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
 , l3.LINE_NUMBER  
  , l6.FEDERAL_FUND_CATEGORY    source_9
  , l4.TRX_LINE_DIST_CCID    source_19
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l4.TRX_LINE_DIST_ID    source_34
  , l4.TRX_DISTRIBUTION_TYPE    source_35
  , l4.TRX_LINE_DIST_AMT    source_36
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_38
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_39
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.TRX_LINE_ACCTD_AMT    source_41
  , l4.TRX_TAX_LINE_ID    source_55
  , l6.FEDERAL_ACCOUNT_VALID_FLAG    source_56
  , l3.ROUNDING_CORRECTION_FLAG    source_66
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
  , FV_XLA_AR_REF_V  l6
 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'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
 AND l6.federal_event_id   (+) =  l4.event_id  AND l6.federal_line_number   (+) =  l4.line_number;
Line: 75692

g_array_event.DELETE;
Line: 75922

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 75943

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 76646

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 76654

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 76745

PROCEDURE insert_sources_141(
                                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)  := 'MISC_RECEIPT_ALL';
Line: 76760

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_141';
Line: 76765

         (p_msg      => 'BEGIN of insert_sources_141'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 76772

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

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 'AR_CASH_RECEIPTS_H_V' 
                WHEN 2 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 3 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'RCT_DOC_SEQUENCE_CATEGORY' 
                WHEN 2 THEN 'RCT_DOC_SEQUENCE_ID' 
                WHEN 3 THEN 'RCT_DOC_SEQUENCE_VALUE' 
                WHEN 4 THEN 'RCT_TRX_ACCT_REVERSAL' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 2 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
                WHEN 3 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
                WHEN 4 THEN TO_CHAR(h1.RCT_TRX_ACCT_REVERSAL)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_CASH_RECEIPTS_H_V  h1
             ,(select rownum r from all_objects where rownum <= 4 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
            
)
;
Line: 76895

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l3.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 2 THEN 'FV_XLA_AR_REF_V' 
                WHEN 3 THEN 'FV_XLA_AR_REF_V' 
                WHEN 4 THEN 'FV_XLA_AR_REF_V' 
                WHEN 5 THEN 'FV_XLA_AR_REF_V' 
                WHEN 6 THEN 'FV_XLA_AR_REF_V' 
                WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 15 THEN 'FV_XLA_AR_REF_V' 
                WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                WHEN 15 THEN '8901' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 2 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 4 THEN 'FEDERAL_PRIOR_YEAR_FLAG' 
                WHEN 5 THEN 'FEDERAL_FUND_TIME_FRAME' 
                WHEN 6 THEN 'FEDERAL_APPORTIONMENT_CATEGORY' 
                WHEN 7 THEN 'DIST_SOURCE_TYPE' 
                WHEN 8 THEN 'DIST_LINE_ID' 
                WHEN 9 THEN 'DISTRIBUTION_TYPE' 
                WHEN 10 THEN 'DIST_ENT_AMT' 
                WHEN 11 THEN 'DIST_CURRENCY_CODE' 
                WHEN 12 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 13 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 14 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 15 THEN 'FEDERAL_ACCOUNT_VALID_FLAG' 
                WHEN 16 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                WHEN 17 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l4.FEDERAL_FUND_CATEGORY)
                WHEN 3 THEN TO_CHAR(l4.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 4 THEN TO_CHAR(l4.FEDERAL_PRIOR_YEAR_FLAG)
                WHEN 5 THEN TO_CHAR(l4.FEDERAL_FUND_TIME_FRAME)
                WHEN 6 THEN TO_CHAR(l4.FEDERAL_APPORTIONMENT_CATEGORY)
                WHEN 7 THEN TO_CHAR(l3.DIST_SOURCE_TYPE)
                WHEN 8 THEN TO_CHAR(l3.DIST_LINE_ID)
                WHEN 9 THEN TO_CHAR(l3.DISTRIBUTION_TYPE)
                WHEN 10 THEN TO_CHAR(l3.DIST_ENT_AMT)
                WHEN 11 THEN TO_CHAR(l3.DIST_CURRENCY_CODE)
                WHEN 12 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_RATE)
                WHEN 13 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_TYPE)
                WHEN 14 THEN TO_CHAR(l2.DIST_TO_ACCTD_AMT)
                WHEN 15 THEN TO_CHAR(l4.FEDERAL_ACCOUNT_VALID_FLAG)
                WHEN 16 THEN TO_CHAR(l2.DIST_TO_CUR_CONVERSION_DATE)
                WHEN 17 THEN TO_CHAR(l3.DIST_MFAR_ADDITIONAL_ENTRY)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_DISTRIBUTIONS_BASE_V  l2
        , AR_DISTRIBUTIONS_L_V  l3
        , FV_XLA_AR_REF_V  l4
            , (select rownum r from all_objects where rownum <= 17 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 l2.event_id          = xet.event_id
  AND l3.event_id    = l2.event_id
  AND l3.line_number = l2.line_number
 AND l4.federal_event_id   (+) =  l3.event_id  and l4.federal_line_number   (+) =  l3.line_number
)
;
Line: 77077

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

         (p_msg      => 'END of insert_sources_141'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 77107

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_141');
Line: 77108

END insert_sources_141;
Line: 77252

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
    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.RCT_DOC_SEQUENCE_CATEGORY    source_83
  , h1.RCT_DOC_SEQUENCE_ID    source_84
  , h1.RCT_DOC_SEQUENCE_VALUE    source_85
  , h1.RCT_TRX_ACCT_REVERSAL    source_86
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h1
 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

 ORDER BY event_id
;
Line: 77295

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
    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
 , l2.LINE_NUMBER  
  , l3.DIST_CODE_COMBINATION_ID    source_5
  , l4.FEDERAL_FUND_CATEGORY    source_9
  , l4.FEDERAL_FUND_EXPIRED_STATUS    source_12
  , l4.FEDERAL_PRIOR_YEAR_FLAG    source_13
  , l4.FEDERAL_FUND_TIME_FRAME    source_14
  , l4.FEDERAL_APPORTIONMENT_CATEGORY    source_15
  , l3.DIST_SOURCE_TYPE    source_20
  , l3.DIST_LINE_ID    source_22
  , l3.DISTRIBUTION_TYPE    source_23
  , l3.DIST_ENT_AMT    source_24
  , l3.DIST_CURRENCY_CODE    source_25
  , l2.DIST_CUR_CONVERSION_RATE    source_27
  , l2.DIST_CUR_CONVERSION_TYPE    source_28
  , l2.DIST_TO_ACCTD_AMT    source_29
  , l4.FEDERAL_ACCOUNT_VALID_FLAG    source_56
  , l2.DIST_TO_CUR_CONVERSION_DATE    source_57
  , l3.DIST_MFAR_ADDITIONAL_ENTRY    source_67
  FROM xla_events_gt     xet 
  , AR_DISTRIBUTIONS_BASE_V  l2
  , AR_DISTRIBUTIONS_L_V  l3
  , FV_XLA_AR_REF_V  l4
 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'   AND l2.event_id      = xet.event_id
  AND l3.event_id    = l2.event_id
  AND l3.line_number = l2.line_number
 AND l4.federal_event_id   (+) =  l3.event_id  AND l4.federal_line_number   (+) =  l3.line_number;
Line: 77377

g_array_event.DELETE;
Line: 77599

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 77620

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 78353

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 78361

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 78452

PROCEDURE insert_sources_142(
                                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)  := 'RECEIPT_ALL';
Line: 78467

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_142';
Line: 78472

         (p_msg      => 'BEGIN of insert_sources_142'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 78479

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

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 'AR_SYSTEM_PARAM_H_V' 
                WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 5 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 7 THEN 'AR_RCT_SITE_USES_H_V' 
                WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 14 THEN 'AR_CASH_RECEIPTS_H_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CODE_COMBINATION_ID_GAIN' 
                WHEN 2 THEN 'CODE_COMBINATION_ID_LOSS' 
                WHEN 3 THEN 'RMT_BNK_UNAPPLIED_CCID' 
                WHEN 4 THEN 'RMT_BNK_UNIDENTIFIED_CCID' 
                WHEN 5 THEN 'RCT_XLA_APPLIED_TO_APP_ID' 
                WHEN 6 THEN 'RCT_PAY_FROM_CUSTOMER' 
                WHEN 7 THEN 'RCT_SITE_SITE_USE_ID' 
                WHEN 8 THEN 'RCT_APP_STATUS' 
                WHEN 9 THEN 'RCT_PREV_PAY_FROM_CUSTOMER' 
                WHEN 10 THEN 'RCT_PREV_CUSTOMER_SITE_USE_ID' 
                WHEN 11 THEN 'RCT_DOC_SEQUENCE_CATEGORY' 
                WHEN 12 THEN 'RCT_DOC_SEQUENCE_ID' 
                WHEN 13 THEN 'RCT_DOC_SEQUENCE_VALUE' 
                WHEN 14 THEN 'RCT_TRX_ACCT_REVERSAL' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
                WHEN 2 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
                WHEN 3 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
                WHEN 4 THEN TO_CHAR(h8.RMT_BNK_UNIDENTIFIED_CCID)
                WHEN 5 THEN TO_CHAR(h2.RCT_XLA_APPLIED_TO_APP_ID)
                WHEN 6 THEN TO_CHAR(h2.RCT_PAY_FROM_CUSTOMER)
                WHEN 7 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
                WHEN 8 THEN TO_CHAR(h2.RCT_APP_STATUS)
                WHEN 9 THEN TO_CHAR(h2.RCT_PREV_PAY_FROM_CUSTOMER)
                WHEN 10 THEN TO_CHAR(h2.RCT_PREV_CUSTOMER_SITE_USE_ID)
                WHEN 11 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 12 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_ID)
                WHEN 13 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_VALUE)
                WHEN 14 THEN TO_CHAR(h2.RCT_TRX_ACCT_REVERSAL)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_CASH_RECEIPTS_H_V  h2
      , AR_RCT_SITE_USES_H_V  h6
      , AR_REMIT_BANK_ACCT_H_V  h8
      , AR_SYSTEM_PARAM_H_V  h9
             ,(select rownum r from all_objects where rownum <= 14 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 h2.event_id = xet.event_id
  AND h6.event_id (+) = h2.event_id
  AND h8.event_id (+) = h2.event_id
  AND h9.event_id (+) = h2.event_id

)
;
Line: 78659

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

INSERT INTO xla_diag_sources  --line2
(
        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
            , l5.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 2 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 7 THEN 'FV_XLA_AR_REF_V' 
                WHEN 8 THEN 'FV_XLA_AR_REF_V' 
                WHEN 9 THEN 'FV_XLA_AR_REF_V' 
                WHEN 10 THEN 'FV_XLA_AR_REF_V' 
                WHEN 11 THEN 'FV_XLA_AR_REF_V' 
                WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 25 THEN 'FV_XLA_AR_REF_V' 
                WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 27 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 28 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 30 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 33 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 34 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 36 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 37 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 38 THEN 'AR_DISTRIBUTIONS_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                WHEN 18 THEN 'LINE' 
                WHEN 19 THEN 'LINE' 
                WHEN 20 THEN 'LINE' 
                WHEN 21 THEN 'LINE' 
                WHEN 22 THEN 'LINE' 
                WHEN 23 THEN 'LINE' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                WHEN 31 THEN 'LINE' 
                WHEN 32 THEN 'LINE' 
                WHEN 33 THEN 'LINE' 
                WHEN 34 THEN 'LINE' 
                WHEN 35 THEN 'LINE' 
                WHEN 36 THEN 'LINE' 
                WHEN 37 THEN 'LINE' 
                WHEN 38 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '8901' 
                WHEN 8 THEN '8901' 
                WHEN 9 THEN '8901' 
                WHEN 10 THEN '8901' 
                WHEN 11 THEN '8901' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                WHEN 15 THEN '222' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                WHEN 18 THEN '222' 
                WHEN 19 THEN '222' 
                WHEN 20 THEN '222' 
                WHEN 21 THEN '222' 
                WHEN 22 THEN '222' 
                WHEN 23 THEN '222' 
                WHEN 24 THEN '222' 
                WHEN 25 THEN '8901' 
                WHEN 26 THEN '222' 
                WHEN 27 THEN '222' 
                WHEN 28 THEN '222' 
                WHEN 29 THEN '222' 
                WHEN 30 THEN '222' 
                WHEN 31 THEN '222' 
                WHEN 32 THEN '222' 
                WHEN 33 THEN '222' 
                WHEN 34 THEN '222' 
                WHEN 35 THEN '222' 
                WHEN 36 THEN '222' 
                WHEN 37 THEN '222' 
                WHEN 38 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_TYPE_NAME' 
                WHEN 2 THEN 'TRX_NUMBER' 
                WHEN 3 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                WHEN 4 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 5 THEN 'GAIN_LOSS_CCID' 
                WHEN 6 THEN 'BILL_CUSTOMER_CLASS_CODE' 
                WHEN 7 THEN 'FEDERAL_ACCOUNT_RULE' 
                WHEN 8 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 9 THEN 'FEDERAL_PRIOR_YEAR_FLAG' 
                WHEN 10 THEN 'FEDERAL_FUND_TIME_FRAME' 
                WHEN 11 THEN 'FEDERAL_APPORTIONMENT_CATEGORY' 
                WHEN 12 THEN 'DIST_SOURCE_TYPE' 
                WHEN 13 THEN 'REC_ACT_TYPE' 
                WHEN 14 THEN 'DIST_LINE_ID' 
                WHEN 15 THEN 'DISTRIBUTION_TYPE' 
                WHEN 16 THEN 'DIST_ENT_AMT' 
                WHEN 17 THEN 'DIST_CURRENCY_CODE' 
                WHEN 18 THEN 'DIST_CUR_CONVERSION_DATE' 
                WHEN 19 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 20 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 21 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 22 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 23 THEN 'TRX_LINE_DIST_ID' 
                WHEN 24 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 25 THEN 'FEDERAL_ACCOUNT_VALID_FLAG' 
                WHEN 26 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                WHEN 27 THEN 'TRX_ENTITY_CODE' 
                WHEN 28 THEN 'TRX_CUSTOMER_TRX_ID' 
                WHEN 29 THEN 'DIST_CURRENCY_CODE_FROM' 
                WHEN 30 THEN 'DIST_TO_CUR_CONVERSION_RATE' 
                WHEN 31 THEN 'DIST_PARTY_ID' 
                WHEN 32 THEN 'DIST_PARTY_SITE_ID' 
                WHEN 33 THEN 'DIST_PARTY_TYPE' 
                WHEN 34 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                WHEN 35 THEN 'DIST_ENT_AMT_FROM' 
                WHEN 36 THEN 'DIST_ACCTD_AMT' 
                WHEN 37 THEN 'DIST_TO_CUR_CONVERSION_TYPE' 
                WHEN 38 THEN 'DIST_SOURCE_TABLE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l10.TRX_TYPE_NAME)
                WHEN 2 THEN TO_CHAR(l10.TRX_NUMBER)
                WHEN 3 THEN TO_CHAR(l10.TRX_DOC_SEQUENCE_VALUE)
                WHEN 4 THEN TO_CHAR(l5.DIST_CODE_COMBINATION_ID)
                WHEN 5 THEN TO_CHAR(l5.GAIN_LOSS_CCID)
                WHEN 6 THEN TO_CHAR(l1.BILL_CUSTOMER_CLASS_CODE)
                WHEN 7 THEN TO_CHAR(l11.FEDERAL_ACCOUNT_RULE)
                WHEN 8 THEN TO_CHAR(l11.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 9 THEN TO_CHAR(l11.FEDERAL_PRIOR_YEAR_FLAG)
                WHEN 10 THEN TO_CHAR(l11.FEDERAL_FUND_TIME_FRAME)
                WHEN 11 THEN TO_CHAR(l11.FEDERAL_APPORTIONMENT_CATEGORY)
                WHEN 12 THEN TO_CHAR(l5.DIST_SOURCE_TYPE)
                WHEN 13 THEN TO_CHAR(l7.REC_ACT_TYPE)
                WHEN 14 THEN TO_CHAR(l5.DIST_LINE_ID)
                WHEN 15 THEN TO_CHAR(l5.DISTRIBUTION_TYPE)
                WHEN 16 THEN TO_CHAR(l5.DIST_ENT_AMT)
                WHEN 17 THEN TO_CHAR(l5.DIST_CURRENCY_CODE)
                WHEN 18 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_DATE)
                WHEN 19 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_RATE)
                WHEN 20 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_TYPE)
                WHEN 21 THEN TO_CHAR(l4.DIST_TO_ACCTD_AMT)
                WHEN 22 THEN TO_CHAR(l3.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 23 THEN TO_CHAR(l3.TRX_LINE_DIST_ID)
                WHEN 24 THEN TO_CHAR(l3.TRX_DISTRIBUTION_TYPE)
                WHEN 25 THEN TO_CHAR(l11.FEDERAL_ACCOUNT_VALID_FLAG)
                WHEN 26 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_DATE)
                WHEN 27 THEN TO_CHAR(l10.TRX_ENTITY_CODE)
                WHEN 28 THEN TO_CHAR(l10.TRX_CUSTOMER_TRX_ID)
                WHEN 29 THEN TO_CHAR(l5.DIST_CURRENCY_CODE_FROM)
                WHEN 30 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_RATE)
                WHEN 31 THEN TO_CHAR(l5.DIST_PARTY_ID)
                WHEN 32 THEN TO_CHAR(l5.DIST_PARTY_SITE_ID)
                WHEN 33 THEN TO_CHAR(l5.DIST_PARTY_TYPE)
                WHEN 34 THEN TO_CHAR(l5.DIST_MFAR_ADDITIONAL_ENTRY)
                WHEN 35 THEN TO_CHAR(l5.DIST_ENT_AMT_FROM)
                WHEN 36 THEN TO_CHAR(l4.DIST_ACCTD_AMT)
                WHEN 37 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_TYPE)
                WHEN 38 THEN TO_CHAR(l5.DIST_SOURCE_TABLE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_BILL_TO_CUSTOMERS_S_V  l1
        , AR_CUST_TRX_LINES_L_V  l3
        , AR_DISTRIBUTIONS_BASE_V  l4
        , AR_DISTRIBUTIONS_L_V  l5
        , AR_RECEIVABLES_TRX_ACT_S_V  l7
        , AR_TRANSACTIONS_S_V  l10
        , FV_XLA_AR_REF_V  l11
            , (select rownum r from all_objects where rownum <= 38 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 l4.event_id          = xet.event_id
  AND l1.event_id (+)    = l4.event_id
  AND l1.line_number (+) = l4.line_number
  AND l3.event_id (+)    = l4.event_id
  AND l3.line_number (+) = l4.line_number
  AND l5.event_id    = l4.event_id
  AND l5.line_number = l4.line_number
  AND l7.event_id (+)    = l4.event_id
  AND l7.line_number (+) = l4.line_number
  AND l10.event_id (+)    = l4.event_id
  AND l10.line_number (+) = l4.line_number
 AND l11.federal_event_id   (+) =  l5.event_id  and l11.federal_line_number   (+) =  l5.line_number
)
;
Line: 78958

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

         (p_msg      => 'END of insert_sources_142'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);
Line: 78988

           (p_location => 'XLA_00222_AAD_S_000005_PKG.insert_sources_142');
Line: 78989

END insert_sources_142;
Line: 79195

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    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 
  , h9.CODE_COMBINATION_ID_GAIN    source_7
  , h9.CODE_COMBINATION_ID_LOSS    source_8
  , h8.RMT_BNK_UNAPPLIED_CCID    source_17
  , h8.RMT_BNK_UNIDENTIFIED_CCID    source_18
  , h2.RCT_XLA_APPLIED_TO_APP_ID    source_58
  , h2.RCT_PAY_FROM_CUSTOMER    source_72
  , h6.RCT_SITE_SITE_USE_ID    source_73
  , h2.RCT_APP_STATUS    source_74
  , h2.RCT_PREV_PAY_FROM_CUSTOMER    source_75
  , h2.RCT_PREV_CUSTOMER_SITE_USE_ID    source_76
  , h2.RCT_DOC_SEQUENCE_CATEGORY    source_83
  , h2.RCT_DOC_SEQUENCE_ID    source_84
  , h2.RCT_DOC_SEQUENCE_VALUE    source_85
  , h2.RCT_TRX_ACCT_REVERSAL    source_86
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h2
  , AR_RCT_SITE_USES_H_V  h6
  , AR_REMIT_BANK_ACCT_H_V  h8
  , AR_SYSTEM_PARAM_H_V  h9
 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 h2.event_id = xet.event_id
  AND h6.event_id (+) = h2.event_id
  AND h8.event_id (+) = h2.event_id
  AND h9.event_id (+) = h2.event_id

 ORDER BY event_id
;
Line: 79254

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    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
 , l4.LINE_NUMBER  
  , l10.TRX_TYPE_NAME    source_1
  , l10.TRX_NUMBER    source_2
  , l10.TRX_DOC_SEQUENCE_VALUE    source_3
  , l5.DIST_CODE_COMBINATION_ID    source_5
  , l5.GAIN_LOSS_CCID    source_6
  , l1.BILL_CUSTOMER_CLASS_CODE    source_10
  , l11.FEDERAL_ACCOUNT_RULE    source_11
  , l11.FEDERAL_FUND_EXPIRED_STATUS    source_12
  , l11.FEDERAL_PRIOR_YEAR_FLAG    source_13
  , l11.FEDERAL_FUND_TIME_FRAME    source_14
  , l11.FEDERAL_APPORTIONMENT_CATEGORY    source_15
  , l5.DIST_SOURCE_TYPE    source_20
  , l7.REC_ACT_TYPE    source_21
  , l5.DIST_LINE_ID    source_22
  , l5.DISTRIBUTION_TYPE    source_23
  , l5.DIST_ENT_AMT    source_24
  , l5.DIST_CURRENCY_CODE    source_25
  , l4.DIST_CUR_CONVERSION_DATE    source_26
  , l4.DIST_CUR_CONVERSION_RATE    source_27
  , l4.DIST_CUR_CONVERSION_TYPE    source_28
  , l4.DIST_TO_ACCTD_AMT    source_29
  , l3.TRX_LINE_DIST_ACCOUNT_CLASS    source_33
  , l3.TRX_LINE_DIST_ID    source_34
  , l3.TRX_DISTRIBUTION_TYPE    source_35
  , l11.FEDERAL_ACCOUNT_VALID_FLAG    source_56
  , l4.DIST_TO_CUR_CONVERSION_DATE    source_57
  , l10.TRX_ENTITY_CODE    source_59
  , l10.TRX_CUSTOMER_TRX_ID    source_60
  , l5.DIST_CURRENCY_CODE_FROM    source_61
  , l4.DIST_TO_CUR_CONVERSION_RATE    source_62
  , l5.DIST_PARTY_ID    source_63
  , l5.DIST_PARTY_SITE_ID    source_64
  , l5.DIST_PARTY_TYPE    source_65
  , l5.DIST_MFAR_ADDITIONAL_ENTRY    source_67
  , l5.DIST_ENT_AMT_FROM    source_68
  , l4.DIST_ACCTD_AMT    source_69
  , l4.DIST_TO_CUR_CONVERSION_TYPE    source_70
  , l5.DIST_SOURCE_TABLE    source_71
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  l1
  , AR_CUST_TRX_LINES_L_V  l3
  , AR_DISTRIBUTIONS_BASE_V  l4
  , AR_DISTRIBUTIONS_L_V  l5
  , AR_RECEIVABLES_TRX_ACT_S_V  l7
  , AR_TRANSACTIONS_S_V  l10
  , FV_XLA_AR_REF_V  l11
 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'   AND l4.event_id      = xet.event_id
  AND l1.event_id (+)    = l4.event_id
  AND l1.line_number (+) = l4.line_number
  AND l3.event_id (+)    = l4.event_id
  AND l3.line_number (+) = l4.line_number
  AND l5.event_id    = l4.event_id
  AND l5.line_number = l4.line_number
  AND l7.event_id (+)    = l4.event_id
  AND l7.line_number (+) = l4.line_number
  AND l10.event_id (+)    = l4.event_id
  AND l10.line_number (+) = l4.line_number
 AND l11.federal_event_id   (+) =  l5.event_id  AND l11.federal_line_number   (+) =  l5.line_number;
Line: 79369

g_array_event.DELETE;
Line: 79611

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
Line: 79632

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 81358

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 81366

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 81525

         insert_sources_134(
                          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: 81559

         insert_sources_135(
                          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: 81593

         insert_sources_136(
                          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: 81627

         insert_sources_137(
                          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: 81661

         insert_sources_138(
                          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: 81695

         insert_sources_139(
                          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: 81729

         insert_sources_140(
                          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: 81763

         insert_sources_141(
                          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: 81797

         insert_sources_142(
                          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
                          );