DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000007_PKG SQL Statements

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

Line: 2655

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PROCEDURE insert_sources_104(
                                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: 53001

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_104';
Line: 53006

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

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

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_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V' 
                WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 5 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 6 THEN 'AR_ADJUSTMENTS_H_V' 
                WHEN 7 THEN 'AR_ADJUSTMENTS_H_V' 
                WHEN 8 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' 
                WHEN 8 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' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'TRX_RECEIVABLE_CCID' 
                WHEN 2 THEN 'REC_ACT_TYPE' 
                WHEN 3 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 4 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 5 THEN 'XLA_PARTY_TYPE' 
                WHEN 6 THEN 'ADJ_DOC_SEQUENCE_CATEGORY' 
                WHEN 7 THEN 'ADJ_DOC_SEQUENCE_ID' 
                WHEN 8 THEN 'ADJ_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h7.TRX_RECEIVABLE_CCID)
                WHEN 2 THEN TO_CHAR(h6.REC_ACT_TYPE)
                WHEN 3 THEN TO_CHAR(h2.BILL_CUST_ACCOUNT_ID)
                WHEN 4 THEN TO_CHAR(h3.BILL_USES_SITE_USE_ID)
                WHEN 5 THEN TO_CHAR(h7.XLA_PARTY_TYPE)
                WHEN 6 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_CATEGORY)
                WHEN 7 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_ID)
                WHEN 8 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 <= 8 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: 53165

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_104');
Line: 53342

END insert_sources_104;
Line: 53480

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 
  , h7.TRX_RECEIVABLE_CCID    source_8
  , h6.REC_ACT_TYPE    source_16
  , h2.BILL_CUST_ACCOUNT_ID    source_25
  , h3.BILL_USES_SITE_USE_ID    source_26
  , h7.XLA_PARTY_TYPE    source_27
  , h1.ADJ_DOC_SEQUENCE_CATEGORY    source_73
  , h1.ADJ_DOC_SEQUENCE_ID    source_74
  , h1.ADJ_DOC_SEQUENCE_VALUE    source_75
  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: 53535

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_10
  , l5.DIST_SOURCE_TYPE    source_15
  , l5.DIST_LINE_ID    source_17
  , l5.DISTRIBUTION_TYPE    source_18
  , l5.DIST_ENT_AMT    source_19
  , l5.DIST_CURRENCY_CODE    source_20
  , l4.DIST_CUR_CONVERSION_DATE    source_21
  , l4.DIST_CUR_CONVERSION_RATE    source_22
  , l4.DIST_CUR_CONVERSION_TYPE    source_23
  , l4.DIST_TO_ACCTD_AMT    source_24
  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: 53609

g_array_event.DELETE;
Line: 53837

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 54257

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 54265

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 54356

PROCEDURE insert_sources_105(
                                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: 54371

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_105';
Line: 54376

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

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

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_BILL_TO_CUSTOMERS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_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 'BILL_CUST_ACCOUNT_ID' 
                WHEN 2 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 3 THEN 'XLA_PARTY_TYPE' 
                WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                
                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: 54526

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_105');
Line: 54698

END insert_sources_105;
Line: 54832

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 
  , h1.BILL_CUST_ACCOUNT_ID    source_25
  , h2.BILL_USES_SITE_USE_ID    source_26
  , h5.XLA_PARTY_TYPE    source_27
  , h5.TRX_INVOICE_CURRENCY_CODE    source_32
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_77
  , h5.TRX_DOC_SEQUENCE_ID    source_78
  , h5.TRX_DOC_SEQUENCE_VALUE    source_79
  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: 54882

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_14
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l4.TRX_LINE_DIST_ID    source_29
  , l4.TRX_DISTRIBUTION_TYPE    source_30
  , l4.TRX_LINE_DIST_AMT    source_31
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_33
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_34
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_35
  , l3.TRX_LINE_ACCTD_AMT    source_36
  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: 54955

g_array_event.DELETE;
Line: 55181

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 55503

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 55511

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 55602

PROCEDURE insert_sources_106(
                                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: 55617

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_106';
Line: 55622

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

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

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_CREDIT_MEMO_H_V' 
                WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 4 THEN 'AR_CREDIT_MEMO_H_V' 
                WHEN 5 THEN 'AR_CREDIT_MEMO_H_V' 
                WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V' 
                WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V' 
                WHEN 8 THEN 'AR_CREDIT_MEMO_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' 
                
                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' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CM_RECEIVABLE_CCID' 
                WHEN 2 THEN 'CODE_COMBINATION_ID_GAIN' 
                WHEN 3 THEN 'CODE_COMBINATION_ID_LOSS' 
                WHEN 4 THEN 'XLA_PARTY_TYPE' 
                WHEN 5 THEN 'CM_INVOICE_CURRENCY_CODE' 
                WHEN 6 THEN 'CM_BILL_CUST_ACCOUNT_ID' 
                WHEN 7 THEN 'CM_BILL_USES_SITE_USE_ID' 
                WHEN 8 THEN 'CM_INVOICING_RULE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.CM_RECEIVABLE_CCID)
                WHEN 2 THEN TO_CHAR(h8.CODE_COMBINATION_ID_GAIN)
                WHEN 3 THEN TO_CHAR(h8.CODE_COMBINATION_ID_LOSS)
                WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 5 THEN TO_CHAR(h5.CM_INVOICE_CURRENCY_CODE)
                WHEN 6 THEN TO_CHAR(h2.CM_BILL_CUST_ACCOUNT_ID)
                WHEN 7 THEN TO_CHAR(h1.CM_BILL_USES_SITE_USE_ID)
                WHEN 8 THEN TO_CHAR(h5.CM_INVOICING_RULE_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 <= 8 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: 55779

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

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_CM_LINES_L_V' 
                WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 7 THEN 'AR_CM_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CM_LINES_BASE_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_L_V' 
                WHEN 14 THEN 'AR_CM_LINES_L_V' 
                WHEN 15 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' 
                
                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' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'CM_LINE_DIST_CCID' 
                WHEN 2 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 3 THEN 'DIST_SOURCE_TYPE' 
                WHEN 4 THEN 'REC_ACT_TYPE' 
                WHEN 5 THEN 'DIST_ENT_AMT' 
                WHEN 6 THEN 'CM_DIST_IDENTIFER' 
                WHEN 7 THEN 'CM_DIST_TYPE' 
                WHEN 8 THEN 'CM_LINE_CUR_CONVERSION_DATE' 
                WHEN 9 THEN 'CM_LINE_CUR_CONVERSION_RATE' 
                WHEN 10 THEN 'CM_LINE_CUR_CONVERSION_TYPE' 
                WHEN 11 THEN 'GAIN_LOSS_REF' 
                WHEN 12 THEN 'CM_LINE_ACCTD_AMT' 
                WHEN 13 THEN 'CM_TAX_LINE_ID' 
                WHEN 14 THEN 'CM_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 15 THEN 'CM_LINE_DIST_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.CM_LINE_DIST_CCID)
                WHEN 2 THEN TO_CHAR(l6.DIST_CODE_COMBINATION_ID)
                WHEN 3 THEN TO_CHAR(l6.DIST_SOURCE_TYPE)
                WHEN 4 THEN TO_CHAR(l7.REC_ACT_TYPE)
                WHEN 5 THEN TO_CHAR(l6.DIST_ENT_AMT)
                WHEN 6 THEN TO_CHAR(l3.CM_DIST_IDENTIFER)
                WHEN 7 THEN TO_CHAR(l3.CM_DIST_TYPE)
                WHEN 8 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_DATE)
                WHEN 9 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_RATE)
                WHEN 10 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_TYPE)
                WHEN 11 THEN TO_CHAR(l3.GAIN_LOSS_REF)
                WHEN 12 THEN TO_CHAR(l3.CM_LINE_ACCTD_AMT)
                WHEN 13 THEN TO_CHAR(l4.CM_TAX_LINE_ID)
                WHEN 14 THEN TO_CHAR(l4.CM_LINE_DIST_ACCOUNT_CLASS)
                WHEN 15 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
            , (select rownum r from all_objects where rownum <= 15 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

)
;
Line: 55956

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_106');
Line: 55987

END insert_sources_106;
Line: 56135

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 
  , h5.CM_RECEIVABLE_CCID    source_2
  , h8.CODE_COMBINATION_ID_GAIN    source_12
  , h8.CODE_COMBINATION_ID_LOSS    source_13
  , h5.XLA_PARTY_TYPE    source_27
  , h5.CM_INVOICE_CURRENCY_CODE    source_39
  , h2.CM_BILL_CUST_ACCOUNT_ID    source_45
  , h1.CM_BILL_USES_SITE_USE_ID    source_46
  , h5.CM_INVOICING_RULE_ID    source_52
  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: 56188

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  
  , l4.CM_LINE_DIST_CCID    source_9
  , l6.DIST_CODE_COMBINATION_ID    source_10
  , l6.DIST_SOURCE_TYPE    source_15
  , l7.REC_ACT_TYPE    source_16
  , l6.DIST_ENT_AMT    source_19
  , l3.CM_DIST_IDENTIFER    source_37
  , l3.CM_DIST_TYPE    source_38
  , l3.CM_LINE_CUR_CONVERSION_DATE    source_40
  , l3.CM_LINE_CUR_CONVERSION_RATE    source_41
  , l3.CM_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.GAIN_LOSS_REF    source_43
  , l3.CM_LINE_ACCTD_AMT    source_44
  , l4.CM_TAX_LINE_ID    source_47
  , l4.CM_LINE_DIST_ACCOUNT_CLASS    source_48
  , l4.CM_LINE_DIST_AMT    source_49
  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
 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
;
Line: 56273

g_array_event.DELETE;
Line: 56495

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 57122

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 57130

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 57221

PROCEDURE insert_sources_107(
                                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: 57236

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_107';
Line: 57241

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

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

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' 
                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_RECEIVABLE_CCID' 
                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_INVOICING_RULE_ID' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 8 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 9 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
                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_INVOICING_RULE_ID)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                
                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: 57401

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_107');
Line: 57578

END insert_sources_107;
Line: 57718

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_RECEIVABLE_CCID    source_8
  , h1.BILL_CUST_ACCOUNT_ID    source_25
  , h2.BILL_USES_SITE_USE_ID    source_26
  , h5.XLA_PARTY_TYPE    source_27
  , h5.TRX_INVOICE_CURRENCY_CODE    source_32
  , h5.TRX_INVOICING_RULE_ID    source_53
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_77
  , h5.TRX_DOC_SEQUENCE_ID    source_78
  , h5.TRX_DOC_SEQUENCE_VALUE    source_79
  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: 57770

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_14
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l4.TRX_LINE_DIST_ID    source_29
  , l4.TRX_DISTRIBUTION_TYPE    source_30
  , l4.TRX_LINE_DIST_AMT    source_31
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_33
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_34
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_35
  , l3.TRX_LINE_ACCTD_AMT    source_36
  , l4.TRX_TAX_LINE_ID    source_50
  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: 57844

g_array_event.DELETE;
Line: 58074

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 58593

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 58601

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 58692

PROCEDURE insert_sources_108(
                                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: 58707

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_108';
Line: 58712

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

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

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_BILL_TO_CUSTOMERS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_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 'BILL_CUST_ACCOUNT_ID' 
                WHEN 2 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 3 THEN 'XLA_PARTY_TYPE' 
                WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                
                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: 58862

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_108');
Line: 59034

END insert_sources_108;
Line: 59168

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 
  , h1.BILL_CUST_ACCOUNT_ID    source_25
  , h2.BILL_USES_SITE_USE_ID    source_26
  , h5.XLA_PARTY_TYPE    source_27
  , h5.TRX_INVOICE_CURRENCY_CODE    source_32
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_77
  , h5.TRX_DOC_SEQUENCE_ID    source_78
  , h5.TRX_DOC_SEQUENCE_VALUE    source_79
  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: 59218

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_14
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l4.TRX_LINE_DIST_ID    source_29
  , l4.TRX_DISTRIBUTION_TYPE    source_30
  , l4.TRX_LINE_DIST_AMT    source_31
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_33
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_34
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_35
  , l3.TRX_LINE_ACCTD_AMT    source_36
  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: 59291

g_array_event.DELETE;
Line: 59517

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 59839

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 59847

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 59938

PROCEDURE insert_sources_109(
                                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: 59953

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_109';
Line: 59958

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

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

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_BILL_TO_CUSTOMERS_S_V' 
                WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V' 
                WHEN 3 THEN 'AR_TRANSACTIONS_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 'BILL_CUST_ACCOUNT_ID' 
                WHEN 2 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 3 THEN 'XLA_PARTY_TYPE' 
                WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                
                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: 60108

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_109');
Line: 60280

END insert_sources_109;
Line: 60414

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 
  , h1.BILL_CUST_ACCOUNT_ID    source_25
  , h2.BILL_USES_SITE_USE_ID    source_26
  , h5.XLA_PARTY_TYPE    source_27
  , h5.TRX_INVOICE_CURRENCY_CODE    source_32
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_77
  , h5.TRX_DOC_SEQUENCE_ID    source_78
  , h5.TRX_DOC_SEQUENCE_VALUE    source_79
  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: 60464

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_14
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l4.TRX_LINE_DIST_ID    source_29
  , l4.TRX_DISTRIBUTION_TYPE    source_30
  , l4.TRX_LINE_DIST_AMT    source_31
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_33
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_34
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_35
  , l3.TRX_LINE_ACCTD_AMT    source_36
  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: 60537

g_array_event.DELETE;
Line: 60763

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 61085

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 61093

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 61184

PROCEDURE insert_sources_110(
                                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: 61199

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_110';
Line: 61204

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

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

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' 
                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_RECEIVABLE_CCID' 
                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_INVOICING_RULE_ID' 
                WHEN 7 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 8 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 9 THEN 'TRX_DOC_SEQUENCE_VALUE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
                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_INVOICING_RULE_ID)
                WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
                
                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: 61364

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

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' 
                WHEN 11 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' 
                
                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' 
                
                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' 
                WHEN 11 THEN 'ROUNDING_CORRECTION_FLAG' 
                
                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)
                WHEN 11 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
            , (select rownum r from all_objects where rownum <= 11 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: 61515

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_110');
Line: 61546

END insert_sources_110;
Line: 61688

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_RECEIVABLE_CCID    source_8
  , h1.BILL_CUST_ACCOUNT_ID    source_25
  , h2.BILL_USES_SITE_USE_ID    source_26
  , h5.XLA_PARTY_TYPE    source_27
  , h5.TRX_INVOICE_CURRENCY_CODE    source_32
  , h5.TRX_INVOICING_RULE_ID    source_53
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_77
  , h5.TRX_DOC_SEQUENCE_ID    source_78
  , h5.TRX_DOC_SEQUENCE_VALUE    source_79
  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: 61740

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  
  , l4.TRX_LINE_DIST_CCID    source_14
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l4.TRX_LINE_DIST_ID    source_29
  , l4.TRX_DISTRIBUTION_TYPE    source_30
  , l4.TRX_LINE_DIST_AMT    source_31
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_33
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_34
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_35
  , l3.TRX_LINE_ACCTD_AMT    source_36
  , l4.TRX_TAX_LINE_ID    source_50
  , l3.ROUNDING_CORRECTION_FLAG    source_51
  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: 61815

g_array_event.DELETE;
Line: 62045

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 62568

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 62576

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 62667

PROCEDURE insert_sources_111(
                                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: 62682

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_111';
Line: 62687

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

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

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_REMIT_BANK_ACCT_H_V' 
                WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 5 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 6 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 7 THEN 'AR_CASH_RECEIPTS_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' 
                
               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' 
                
                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 'RMT_BNK_BANK_CHARGES_CCID' 
                WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID' 
                WHEN 3 THEN 'RMT_BNK_CASH_CCID' 
                WHEN 4 THEN 'RMT_BNK_REMITTANCE_CCID' 
                WHEN 5 THEN 'RCT_CLASS_REMIT_FLAG' 
                WHEN 6 THEN 'RCT_CLASS_CONFIRM_FLAG' 
                WHEN 7 THEN 'RCT_DOC_SEQUENCE_CATEGORY' 
                WHEN 8 THEN 'RCT_DOC_SEQUENCE_ID' 
                WHEN 9 THEN 'RCT_DOC_SEQUENCE_VALUE' 
                WHEN 10 THEN 'RCT_TRX_ACCT_REVERSAL' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h5.RMT_BNK_BANK_CHARGES_CCID)
                WHEN 2 THEN TO_CHAR(h5.RMT_BNK_CONFIRMATION_CCID)
                WHEN 3 THEN TO_CHAR(h5.RMT_BNK_CASH_CCID)
                WHEN 4 THEN TO_CHAR(h5.RMT_BNK_REMITTANCE_CCID)
                WHEN 5 THEN TO_CHAR(h4.RCT_CLASS_REMIT_FLAG)
                WHEN 6 THEN TO_CHAR(h4.RCT_CLASS_CONFIRM_FLAG)
                WHEN 7 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 8 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
                WHEN 9 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
                WHEN 10 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
      , AR_RCT_METHOD_H_V  h4
      , AR_REMIT_BANK_ACCT_H_V  h5
             ,(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
            
)
;
Line: 62849

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

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 '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_L_V' 
                WHEN 11 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' 
                WHEN 11 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' 
                
                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_RATE' 
                WHEN 8 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 9 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 10 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                WHEN 11 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l3.DIST_SOURCE_TYPE)
                WHEN 3 THEN TO_CHAR(l3.DIST_LINE_ID)
                WHEN 4 THEN TO_CHAR(l3.DISTRIBUTION_TYPE)
                WHEN 5 THEN TO_CHAR(l3.DIST_ENT_AMT)
                WHEN 6 THEN TO_CHAR(l3.DIST_CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_RATE)
                WHEN 8 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_TYPE)
                WHEN 9 THEN TO_CHAR(l2.DIST_TO_ACCTD_AMT)
                WHEN 10 THEN TO_CHAR(l3.DIST_MFAR_ADDITIONAL_ENTRY)
                WHEN 11 THEN TO_CHAR(l2.DIST_TO_CUR_CONVERSION_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_DISTRIBUTIONS_BASE_V  l2
        , AR_DISTRIBUTIONS_L_V  l3
            , (select rownum r from all_objects where rownum <= 11 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

)
;
Line: 63000

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_111');
Line: 63031

END insert_sources_111;
Line: 63175

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 
  , h5.RMT_BNK_BANK_CHARGES_CCID    source_1
  , h5.RMT_BNK_CONFIRMATION_CCID    source_3
  , h5.RMT_BNK_CASH_CCID    source_5
  , h5.RMT_BNK_REMITTANCE_CCID    source_6
  , h4.RCT_CLASS_REMIT_FLAG    source_56
  , h4.RCT_CLASS_CONFIRM_FLAG    source_57
  , h1.RCT_DOC_SEQUENCE_CATEGORY    source_80
  , h1.RCT_DOC_SEQUENCE_ID    source_81
  , h1.RCT_DOC_SEQUENCE_VALUE    source_82
  , h1.RCT_TRX_ACCT_REVERSAL    source_83
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h1
  , AR_RCT_METHOD_H_V  h4
  , AR_REMIT_BANK_ACCT_H_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 h4.event_id (+) = xet.event_id
  AND h5.event_id (+) = xet.event_id

 ORDER BY event_id
;
Line: 63228

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_10
  , l3.DIST_SOURCE_TYPE    source_15
  , l3.DIST_LINE_ID    source_17
  , l3.DISTRIBUTION_TYPE    source_18
  , l3.DIST_ENT_AMT    source_19
  , l3.DIST_CURRENCY_CODE    source_20
  , l2.DIST_CUR_CONVERSION_RATE    source_22
  , l2.DIST_CUR_CONVERSION_TYPE    source_23
  , l2.DIST_TO_ACCTD_AMT    source_24
  , l3.DIST_MFAR_ADDITIONAL_ENTRY    source_54
  , l2.DIST_TO_CUR_CONVERSION_DATE    source_55
  FROM xla_events_gt     xet 
  , AR_DISTRIBUTIONS_BASE_V  l2
  , AR_DISTRIBUTIONS_L_V  l3
 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
;
Line: 63303

g_array_event.DELETE;
Line: 63537

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 64097

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 64105

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 64196

PROCEDURE insert_sources_112(
                                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: 64211

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_112';
Line: 64216

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

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

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_REMIT_BANK_ACCT_H_V' 
                WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V' 
                WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 10 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 11 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 14 THEN 'AR_RCT_SITE_USES_H_V' 
                WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 19 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' 
                WHEN 15 THEN 'HEADER' 
                WHEN 16 THEN 'HEADER' 
                WHEN 17 THEN 'HEADER' 
                WHEN 18 THEN 'HEADER' 
                WHEN 19 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' 
                WHEN 15 THEN '222' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                WHEN 18 THEN '222' 
                WHEN 19 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'RMT_BNK_BANK_CHARGES_CCID' 
                WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID' 
                WHEN 3 THEN 'RMT_BNK_EARNED_CCID' 
                WHEN 4 THEN 'RMT_BNK_CASH_CCID' 
                WHEN 5 THEN 'RMT_BNK_REMITTANCE_CCID' 
                WHEN 6 THEN 'RMT_BNK_UNEARNED_CCID' 
                WHEN 7 THEN 'RMT_BNK_UNAPPLIED_CCID' 
                WHEN 8 THEN 'CODE_COMBINATION_ID_GAIN' 
                WHEN 9 THEN 'CODE_COMBINATION_ID_LOSS' 
                WHEN 10 THEN 'RCT_CLASS_REMIT_FLAG' 
                WHEN 11 THEN 'RCT_CLASS_CONFIRM_FLAG' 
                WHEN 12 THEN 'RCT_XLA_APPLIED_TO_APP_ID' 
                WHEN 13 THEN 'RCT_PAY_FROM_CUSTOMER' 
                WHEN 14 THEN 'RCT_SITE_SITE_USE_ID' 
                WHEN 15 THEN 'RCT_APP_STATUS' 
                WHEN 16 THEN 'RCT_DOC_SEQUENCE_CATEGORY' 
                WHEN 17 THEN 'RCT_DOC_SEQUENCE_ID' 
                WHEN 18 THEN 'RCT_DOC_SEQUENCE_VALUE' 
                WHEN 19 THEN 'RCT_TRX_ACCT_REVERSAL' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h8.RMT_BNK_BANK_CHARGES_CCID)
                WHEN 2 THEN TO_CHAR(h8.RMT_BNK_CONFIRMATION_CCID)
                WHEN 3 THEN TO_CHAR(h8.RMT_BNK_EARNED_CCID)
                WHEN 4 THEN TO_CHAR(h8.RMT_BNK_CASH_CCID)
                WHEN 5 THEN TO_CHAR(h8.RMT_BNK_REMITTANCE_CCID)
                WHEN 6 THEN TO_CHAR(h8.RMT_BNK_UNEARNED_CCID)
                WHEN 7 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
                WHEN 8 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
                WHEN 9 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
                WHEN 10 THEN TO_CHAR(h5.RCT_CLASS_REMIT_FLAG)
                WHEN 11 THEN TO_CHAR(h5.RCT_CLASS_CONFIRM_FLAG)
                WHEN 12 THEN TO_CHAR(h1.RCT_XLA_APPLIED_TO_APP_ID)
                WHEN 13 THEN TO_CHAR(h1.RCT_PAY_FROM_CUSTOMER)
                WHEN 14 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
                WHEN 15 THEN TO_CHAR(h1.RCT_APP_STATUS)
                WHEN 16 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 17 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
                WHEN 18 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
                WHEN 19 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
      , AR_RCT_METHOD_H_V  h5
      , 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 <= 19 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 h5.event_id (+) = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h8.event_id (+) = h1.event_id
  AND h9.event_id (+) = h1.event_id

)
;
Line: 64430

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

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_DISTRIBUTIONS_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 18 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 19 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 28 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' 
                
                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' 
                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 '222' 
                WHEN 26 THEN '222' 
                WHEN 27 THEN '222' 
                WHEN 28 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 2 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 3 THEN 'DIST_SOURCE_TYPE' 
                WHEN 4 THEN 'REC_ACT_TYPE' 
                WHEN 5 THEN 'DIST_LINE_ID' 
                WHEN 6 THEN 'DISTRIBUTION_TYPE' 
                WHEN 7 THEN 'DIST_ENT_AMT' 
                WHEN 8 THEN 'DIST_CURRENCY_CODE' 
                WHEN 9 THEN 'DIST_CUR_CONVERSION_DATE' 
                WHEN 10 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 11 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 12 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 13 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 14 THEN 'TRX_LINE_DIST_ID' 
                WHEN 15 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 16 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                WHEN 17 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                WHEN 18 THEN 'TRX_ENTITY_CODE' 
                WHEN 19 THEN 'TRX_CUSTOMER_TRX_ID' 
                WHEN 20 THEN 'DIST_ENT_AMT_FROM' 
                WHEN 21 THEN 'DIST_CURRENCY_CODE_FROM' 
                WHEN 22 THEN 'DIST_ACCTD_AMT' 
                WHEN 23 THEN 'DIST_PARTY_ID' 
                WHEN 24 THEN 'DIST_PARTY_SITE_ID' 
                WHEN 25 THEN 'DIST_PARTY_TYPE' 
                WHEN 26 THEN 'DIST_TO_CUR_CONVERSION_TYPE' 
                WHEN 27 THEN 'DIST_TO_CUR_CONVERSION_RATE' 
                WHEN 28 THEN 'DIST_SOURCE_TABLE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l2.TRX_LINE_DIST_CCID)
                WHEN 3 THEN TO_CHAR(l4.DIST_SOURCE_TYPE)
                WHEN 4 THEN TO_CHAR(l7.REC_ACT_TYPE)
                WHEN 5 THEN TO_CHAR(l4.DIST_LINE_ID)
                WHEN 6 THEN TO_CHAR(l4.DISTRIBUTION_TYPE)
                WHEN 7 THEN TO_CHAR(l4.DIST_ENT_AMT)
                WHEN 8 THEN TO_CHAR(l4.DIST_CURRENCY_CODE)
                WHEN 9 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_DATE)
                WHEN 10 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_RATE)
                WHEN 11 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_TYPE)
                WHEN 12 THEN TO_CHAR(l3.DIST_TO_ACCTD_AMT)
                WHEN 13 THEN TO_CHAR(l2.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 14 THEN TO_CHAR(l2.TRX_LINE_DIST_ID)
                WHEN 15 THEN TO_CHAR(l2.TRX_DISTRIBUTION_TYPE)
                WHEN 16 THEN TO_CHAR(l4.DIST_MFAR_ADDITIONAL_ENTRY)
                WHEN 17 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_DATE)
                WHEN 18 THEN TO_CHAR(l10.TRX_ENTITY_CODE)
                WHEN 19 THEN TO_CHAR(l10.TRX_CUSTOMER_TRX_ID)
                WHEN 20 THEN TO_CHAR(l4.DIST_ENT_AMT_FROM)
                WHEN 21 THEN TO_CHAR(l4.DIST_CURRENCY_CODE_FROM)
                WHEN 22 THEN TO_CHAR(l3.DIST_ACCTD_AMT)
                WHEN 23 THEN TO_CHAR(l4.DIST_PARTY_ID)
                WHEN 24 THEN TO_CHAR(l4.DIST_PARTY_SITE_ID)
                WHEN 25 THEN TO_CHAR(l4.DIST_PARTY_TYPE)
                WHEN 26 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_TYPE)
                WHEN 27 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_RATE)
                WHEN 28 THEN TO_CHAR(l4.DIST_SOURCE_TABLE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_L_V  l2
        , AR_DISTRIBUTIONS_BASE_V  l3
        , AR_DISTRIBUTIONS_L_V  l4
        , AR_RECEIVABLES_TRX_ACT_S_V  l7
        , AR_TRANSACTIONS_S_V  l10
            , (select rownum r from all_objects where rownum <= 28 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 l2.event_id (+)    = l3.event_id
  AND l2.line_number (+) = l3.line_number
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l10.event_id (+)    = l3.event_id
  AND l10.line_number (+) = l3.line_number

)
;
Line: 64675

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

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

           (p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_112');
Line: 64706

END insert_sources_112;
Line: 64902

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 
  , h8.RMT_BNK_BANK_CHARGES_CCID    source_1
  , h8.RMT_BNK_CONFIRMATION_CCID    source_3
  , h8.RMT_BNK_EARNED_CCID    source_4
  , h8.RMT_BNK_CASH_CCID    source_5
  , h8.RMT_BNK_REMITTANCE_CCID    source_6
  , h8.RMT_BNK_UNEARNED_CCID    source_7
  , h8.RMT_BNK_UNAPPLIED_CCID    source_11
  , h9.CODE_COMBINATION_ID_GAIN    source_12
  , h9.CODE_COMBINATION_ID_LOSS    source_13
  , h5.RCT_CLASS_REMIT_FLAG    source_56
  , h5.RCT_CLASS_CONFIRM_FLAG    source_57
  , h1.RCT_XLA_APPLIED_TO_APP_ID    source_58
  , h1.RCT_PAY_FROM_CUSTOMER    source_70
  , h6.RCT_SITE_SITE_USE_ID    source_71
  , h1.RCT_APP_STATUS    source_72
  , h1.RCT_DOC_SEQUENCE_CATEGORY    source_80
  , h1.RCT_DOC_SEQUENCE_ID    source_81
  , h1.RCT_DOC_SEQUENCE_VALUE    source_82
  , h1.RCT_TRX_ACCT_REVERSAL    source_83
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h1
  , AR_RCT_METHOD_H_V  h5
  , 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 h1.event_id = xet.event_id
  AND h5.event_id (+) = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h8.event_id (+) = h1.event_id
  AND h9.event_id (+) = h1.event_id

 ORDER BY event_id
;
Line: 64968

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
 , l3.LINE_NUMBER  
  , l4.DIST_CODE_COMBINATION_ID    source_10
  , l2.TRX_LINE_DIST_CCID    source_14
  , l4.DIST_SOURCE_TYPE    source_15
  , l7.REC_ACT_TYPE    source_16
  , l4.DIST_LINE_ID    source_17
  , l4.DISTRIBUTION_TYPE    source_18
  , l4.DIST_ENT_AMT    source_19
  , l4.DIST_CURRENCY_CODE    source_20
  , l3.DIST_CUR_CONVERSION_DATE    source_21
  , l3.DIST_CUR_CONVERSION_RATE    source_22
  , l3.DIST_CUR_CONVERSION_TYPE    source_23
  , l3.DIST_TO_ACCTD_AMT    source_24
  , l2.TRX_LINE_DIST_ACCOUNT_CLASS    source_28
  , l2.TRX_LINE_DIST_ID    source_29
  , l2.TRX_DISTRIBUTION_TYPE    source_30
  , l4.DIST_MFAR_ADDITIONAL_ENTRY    source_54
  , l3.DIST_TO_CUR_CONVERSION_DATE    source_55
  , l10.TRX_ENTITY_CODE    source_59
  , l10.TRX_CUSTOMER_TRX_ID    source_60
  , l4.DIST_ENT_AMT_FROM    source_61
  , l4.DIST_CURRENCY_CODE_FROM    source_62
  , l3.DIST_ACCTD_AMT    source_63
  , l4.DIST_PARTY_ID    source_64
  , l4.DIST_PARTY_SITE_ID    source_65
  , l4.DIST_PARTY_TYPE    source_66
  , l3.DIST_TO_CUR_CONVERSION_TYPE    source_67
  , l3.DIST_TO_CUR_CONVERSION_RATE    source_68
  , l4.DIST_SOURCE_TABLE    source_69
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_L_V  l2
  , AR_DISTRIBUTIONS_BASE_V  l3
  , AR_DISTRIBUTIONS_L_V  l4
  , AR_RECEIVABLES_TRX_ACT_S_V  l7
  , AR_TRANSACTIONS_S_V  l10
 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 l2.event_id (+)    = l3.event_id
  AND l2.line_number (+) = l3.line_number
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l10.event_id (+)    = l3.event_id
  AND l10.line_number (+) = l3.line_number
;
Line: 65069

g_array_event.DELETE;
Line: 65321

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 66977

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 66985

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 67144

         insert_sources_104(
                          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: 67178

         insert_sources_105(
                          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: 67212

         insert_sources_106(
                          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: 67246

         insert_sources_107(
                          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: 67280

         insert_sources_108(
                          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: 67314

         insert_sources_109(
                          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: 67348

         insert_sources_110(
                          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: 67382

         insert_sources_111(
                          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: 67416

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