DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000009_PKG SQL Statements

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

Line: 5077

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'ADJUSTMENT_ALL';
Line: 67617

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_138');
Line: 67958

END insert_sources_138;
Line: 68096

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_23
  , h2.BILL_CUST_ACCOUNT_ID    source_32
  , h3.BILL_USES_SITE_USE_ID    source_33
  , h7.XLA_PARTY_TYPE    source_34
  , h1.ADJ_DOC_SEQUENCE_CATEGORY    source_81
  , h1.ADJ_DOC_SEQUENCE_ID    source_82
  , h1.ADJ_DOC_SEQUENCE_VALUE    source_83
  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: 68151

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_22
  , l5.DIST_LINE_ID    source_24
  , l5.DISTRIBUTION_TYPE    source_25
  , l5.DIST_ENT_AMT    source_26
  , l5.DIST_CURRENCY_CODE    source_27
  , l4.DIST_CUR_CONVERSION_DATE    source_28
  , l4.DIST_CUR_CONVERSION_RATE    source_29
  , l4.DIST_CUR_CONVERSION_TYPE    source_30
  , l4.DIST_TO_ACCTD_AMT    source_31
  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: 68225

g_array_event.DELETE;
Line: 68453

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 68873

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 68881

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 68972

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'CHARGEBACK_ALL';
Line: 68987

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_139');
Line: 69314

END insert_sources_139;
Line: 69448

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_32
  , h2.BILL_USES_SITE_USE_ID    source_33
  , h5.XLA_PARTY_TYPE    source_34
  , h5.TRX_INVOICE_CURRENCY_CODE    source_39
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_85
  , h5.TRX_DOC_SEQUENCE_ID    source_86
  , h5.TRX_DOC_SEQUENCE_VALUE    source_87
  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: 69498

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_21
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l4.TRX_LINE_DIST_ID    source_36
  , l4.TRX_DISTRIBUTION_TYPE    source_37
  , l4.TRX_LINE_DIST_AMT    source_38
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_40
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_41
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.TRX_LINE_ACCTD_AMT    source_43
  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: 69571

g_array_event.DELETE;
Line: 69797

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 70119

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 70127

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 70218

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'CREDIT_MEMO_ALL';
Line: 70233

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_140');
Line: 70603

END insert_sources_140;
Line: 70751

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_19
  , h8.CODE_COMBINATION_ID_LOSS    source_20
  , h5.XLA_PARTY_TYPE    source_34
  , h5.CM_INVOICE_CURRENCY_CODE    source_46
  , h2.CM_BILL_CUST_ACCOUNT_ID    source_52
  , h1.CM_BILL_USES_SITE_USE_ID    source_53
  , h5.CM_INVOICING_RULE_ID    source_69
  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: 70804

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_22
  , l7.REC_ACT_TYPE    source_23
  , l6.DIST_ENT_AMT    source_26
  , l3.CM_DIST_IDENTIFER    source_44
  , l3.CM_DIST_TYPE    source_45
  , l3.CM_LINE_CUR_CONVERSION_DATE    source_47
  , l3.CM_LINE_CUR_CONVERSION_RATE    source_48
  , l3.CM_LINE_CUR_CONVERSION_TYPE    source_49
  , l3.GAIN_LOSS_REF    source_50
  , l3.CM_LINE_ACCTD_AMT    source_51
  , l4.CM_TAX_LINE_ID    source_54
  , l4.CM_LINE_DIST_ACCOUNT_CLASS    source_55
  , l4.CM_LINE_DIST_AMT    source_56
  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: 70889

g_array_event.DELETE;
Line: 71111

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 71738

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 71746

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 71837

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'DEBIT_MEMO_ALL';
Line: 71852

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_141');
Line: 72194

END insert_sources_141;
Line: 72334

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_32
  , h2.BILL_USES_SITE_USE_ID    source_33
  , h5.XLA_PARTY_TYPE    source_34
  , h5.TRX_INVOICE_CURRENCY_CODE    source_39
  , h5.TRX_INVOICING_RULE_ID    source_70
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_85
  , h5.TRX_DOC_SEQUENCE_ID    source_86
  , h5.TRX_DOC_SEQUENCE_VALUE    source_87
  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: 72386

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_21
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l4.TRX_LINE_DIST_ID    source_36
  , l4.TRX_DISTRIBUTION_TYPE    source_37
  , l4.TRX_LINE_DIST_AMT    source_38
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_40
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_41
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.TRX_LINE_ACCTD_AMT    source_43
  , l4.TRX_TAX_LINE_ID    source_57
  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: 72460

g_array_event.DELETE;
Line: 72690

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 73209

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 73217

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 73308

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'DEPOSIT_ALL';
Line: 73323

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_142');
Line: 73650

END insert_sources_142;
Line: 73784

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_32
  , h2.BILL_USES_SITE_USE_ID    source_33
  , h5.XLA_PARTY_TYPE    source_34
  , h5.TRX_INVOICE_CURRENCY_CODE    source_39
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_85
  , h5.TRX_DOC_SEQUENCE_ID    source_86
  , h5.TRX_DOC_SEQUENCE_VALUE    source_87
  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: 73834

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_21
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l4.TRX_LINE_DIST_ID    source_36
  , l4.TRX_DISTRIBUTION_TYPE    source_37
  , l4.TRX_LINE_DIST_AMT    source_38
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_40
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_41
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.TRX_LINE_ACCTD_AMT    source_43
  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: 73907

g_array_event.DELETE;
Line: 74133

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 74455

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 74463

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 74554

PROCEDURE insert_sources_143(
                                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: 74569

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_143';
Line: 74574

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_143');
Line: 74896

END insert_sources_143;
Line: 75030

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_32
  , h2.BILL_USES_SITE_USE_ID    source_33
  , h5.XLA_PARTY_TYPE    source_34
  , h5.TRX_INVOICE_CURRENCY_CODE    source_39
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_85
  , h5.TRX_DOC_SEQUENCE_ID    source_86
  , h5.TRX_DOC_SEQUENCE_VALUE    source_87
  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: 75080

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_21
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l4.TRX_LINE_DIST_ID    source_36
  , l4.TRX_DISTRIBUTION_TYPE    source_37
  , l4.TRX_LINE_DIST_AMT    source_38
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_40
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_41
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.TRX_LINE_ACCTD_AMT    source_43
  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: 75153

g_array_event.DELETE;
Line: 75379

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 75701

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 75709

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 75800

PROCEDURE insert_sources_144(
                                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: 75815

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_144';
Line: 75820

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

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

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_CUSTOMERS_S_V' 
                WHEN 4 THEN 'AR_BILL_TO_SITE_USES_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' 
                WHEN 10 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' 
                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 'TRX_RECEIVABLE_CCID' 
                WHEN 2 THEN 'BILL_CUSTOMER_CLASS_CODE' 
                WHEN 3 THEN 'BILL_CUST_ACCOUNT_ID' 
                WHEN 4 THEN 'BILL_USES_SITE_USE_ID' 
                WHEN 5 THEN 'XLA_PARTY_TYPE' 
                WHEN 6 THEN 'TRX_INVOICE_CURRENCY_CODE' 
                WHEN 7 THEN 'TRX_INVOICING_RULE_ID' 
                WHEN 8 THEN 'TRX_DOC_SEQUENCE_CATEGORY' 
                WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID' 
                WHEN 10 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_CUSTOMER_CLASS_CODE)
                WHEN 3 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
                WHEN 4 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
                WHEN 5 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
                WHEN 6 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
                WHEN 7 THEN TO_CHAR(h5.TRX_INVOICING_RULE_ID)
                WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
                WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
                WHEN 10 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 <= 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 h1.event_id = xet.event_id
  AND h2.event_id  = h1.event_id
  AND h5.event_id  = h1.event_id

)
;
Line: 75985

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

INSERT INTO xla_diag_sources  --line2
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT  event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value,1,1996)
      , SUBSTR(source_meaning ,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'FV_XLA_AR_REF_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 12 THEN 'FV_XLA_AR_REF_V' 
                WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '8901' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '8901' 
                WHEN 13 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 2 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 3 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 4 THEN 'TRX_LINE_DIST_ID' 
                WHEN 5 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 6 THEN 'TRX_LINE_DIST_AMT' 
                WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_DATE' 
                WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_RATE' 
                WHEN 9 THEN 'TRX_LINE_CUR_CONVERSION_TYPE' 
                WHEN 10 THEN 'TRX_LINE_ACCTD_AMT' 
                WHEN 11 THEN 'TRX_TAX_LINE_ID' 
                WHEN 12 THEN 'FEDERAL_ACCOUNT_VALID_FLAG' 
                WHEN 13 THEN 'ROUNDING_CORRECTION_FLAG' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
                WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
                WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 4 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
                WHEN 5 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
                WHEN 6 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
                WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
                WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
                WHEN 9 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
                WHEN 10 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
                WHEN 11 THEN TO_CHAR(l4.TRX_TAX_LINE_ID)
                WHEN 12 THEN TO_CHAR(l6.FEDERAL_ACCOUNT_VALID_FLAG)
                WHEN 13 THEN TO_CHAR(l3.ROUNDING_CORRECTION_FLAG)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_BASE_V  l3
        , AR_CUST_TRX_LINES_L_V  l4
        , FV_XLA_AR_REF_V  l6
            , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_class_code = C_EVENT_CLASS_CODE
            AND l3.event_id          = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
 AND l6.federal_event_id   (+) =  l4.event_id  and l6.federal_line_number   (+) =  l4.line_number
)
;
Line: 76147

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_144');
Line: 76178

END insert_sources_144;
Line: 76326

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_CUSTOMER_CLASS_CODE    source_12
  , h1.BILL_CUST_ACCOUNT_ID    source_32
  , h2.BILL_USES_SITE_USE_ID    source_33
  , h5.XLA_PARTY_TYPE    source_34
  , h5.TRX_INVOICE_CURRENCY_CODE    source_39
  , h5.TRX_INVOICING_RULE_ID    source_70
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_85
  , h5.TRX_DOC_SEQUENCE_ID    source_86
  , h5.TRX_DOC_SEQUENCE_VALUE    source_87
  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: 76379

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag
 , l3.LINE_NUMBER  
  , l6.FEDERAL_FUND_CATEGORY    source_11
  , l4.TRX_LINE_DIST_CCID    source_21
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l4.TRX_LINE_DIST_ID    source_36
  , l4.TRX_DISTRIBUTION_TYPE    source_37
  , l4.TRX_LINE_DIST_AMT    source_38
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_40
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_41
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_42
  , l3.TRX_LINE_ACCTD_AMT    source_43
  , l4.TRX_TAX_LINE_ID    source_57
  , l6.FEDERAL_ACCOUNT_VALID_FLAG    source_58
  , l3.ROUNDING_CORRECTION_FLAG    source_68
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_BASE_V  l3
  , AR_CUST_TRX_LINES_L_V  l4
  , FV_XLA_AR_REF_V  l6
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l3.event_id      = xet.event_id
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
 AND l6.federal_event_id   (+) =  l4.event_id  AND l6.federal_line_number   (+) =  l4.line_number;
Line: 76457

g_array_event.DELETE;
Line: 76689

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 77284

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 77292

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 77383

PROCEDURE insert_sources_145(
                                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: 77398

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_145';
Line: 77403

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

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

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

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

INSERT INTO xla_diag_sources  --line2
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT  event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value,1,1996)
      , SUBSTR(source_meaning ,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , l3.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 2 THEN 'FV_XLA_AR_REF_V' 
                WHEN 3 THEN 'FV_XLA_AR_REF_V' 
                WHEN 4 THEN 'FV_XLA_AR_REF_V' 
                WHEN 5 THEN 'FV_XLA_AR_REF_V' 
                WHEN 6 THEN 'FV_XLA_AR_REF_V' 
                WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 15 THEN 'FV_XLA_AR_REF_V' 
                WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '8901' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                WHEN 15 THEN '8901' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 2 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 4 THEN 'FEDERAL_PRIOR_YEAR_FLAG' 
                WHEN 5 THEN 'FEDERAL_FUND_TIME_FRAME' 
                WHEN 6 THEN 'FEDERAL_APPORTIONMENT_CATEGORY' 
                WHEN 7 THEN 'DIST_SOURCE_TYPE' 
                WHEN 8 THEN 'DIST_LINE_ID' 
                WHEN 9 THEN 'DISTRIBUTION_TYPE' 
                WHEN 10 THEN 'DIST_ENT_AMT' 
                WHEN 11 THEN 'DIST_CURRENCY_CODE' 
                WHEN 12 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 13 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 14 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 15 THEN 'FEDERAL_ACCOUNT_VALID_FLAG' 
                WHEN 16 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                WHEN 17 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
                WHEN 3 THEN TO_CHAR(l6.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 4 THEN TO_CHAR(l6.FEDERAL_PRIOR_YEAR_FLAG)
                WHEN 5 THEN TO_CHAR(l6.FEDERAL_FUND_TIME_FRAME)
                WHEN 6 THEN TO_CHAR(l6.FEDERAL_APPORTIONMENT_CATEGORY)
                WHEN 7 THEN TO_CHAR(l3.DIST_SOURCE_TYPE)
                WHEN 8 THEN TO_CHAR(l3.DIST_LINE_ID)
                WHEN 9 THEN TO_CHAR(l3.DISTRIBUTION_TYPE)
                WHEN 10 THEN TO_CHAR(l3.DIST_ENT_AMT)
                WHEN 11 THEN TO_CHAR(l3.DIST_CURRENCY_CODE)
                WHEN 12 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_RATE)
                WHEN 13 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_TYPE)
                WHEN 14 THEN TO_CHAR(l2.DIST_TO_ACCTD_AMT)
                WHEN 15 THEN TO_CHAR(l6.FEDERAL_ACCOUNT_VALID_FLAG)
                WHEN 16 THEN TO_CHAR(l2.DIST_TO_CUR_CONVERSION_DATE)
                WHEN 17 THEN TO_CHAR(l3.DIST_MFAR_ADDITIONAL_ENTRY)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_DISTRIBUTIONS_BASE_V  l2
        , AR_DISTRIBUTIONS_L_V  l3
        , FV_XLA_AR_REF_V  l6
            , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_class_code = C_EVENT_CLASS_CODE
            AND l2.event_id          = xet.event_id
  AND l3.event_id    = l2.event_id
  AND l3.line_number = l2.line_number
 AND l6.federal_event_id   (+) =  l3.event_id  and l6.federal_line_number   (+) =  l3.line_number
)
;
Line: 77747

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_145');
Line: 77778

END insert_sources_145;
Line: 77934

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_72
  , h4.RCT_CLASS_CONFIRM_FLAG    source_73
  , h1.RCT_DOC_SEQUENCE_CATEGORY    source_88
  , h1.RCT_DOC_SEQUENCE_ID    source_89
  , h1.RCT_DOC_SEQUENCE_VALUE    source_90
  , h1.RCT_TRX_ACCT_REVERSAL    source_91
  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: 77987

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
  , l6.FEDERAL_FUND_CATEGORY    source_11
  , l6.FEDERAL_FUND_EXPIRED_STATUS    source_14
  , l6.FEDERAL_PRIOR_YEAR_FLAG    source_15
  , l6.FEDERAL_FUND_TIME_FRAME    source_16
  , l6.FEDERAL_APPORTIONMENT_CATEGORY    source_17
  , l3.DIST_SOURCE_TYPE    source_22
  , l3.DIST_LINE_ID    source_24
  , l3.DISTRIBUTION_TYPE    source_25
  , l3.DIST_ENT_AMT    source_26
  , l3.DIST_CURRENCY_CODE    source_27
  , l2.DIST_CUR_CONVERSION_RATE    source_29
  , l2.DIST_CUR_CONVERSION_TYPE    source_30
  , l2.DIST_TO_ACCTD_AMT    source_31
  , l6.FEDERAL_ACCOUNT_VALID_FLAG    source_58
  , l2.DIST_TO_CUR_CONVERSION_DATE    source_59
  , l3.DIST_MFAR_ADDITIONAL_ENTRY    source_71
  FROM xla_events_gt     xet 
  , AR_DISTRIBUTIONS_BASE_V  l2
  , AR_DISTRIBUTIONS_L_V  l3
  , FV_XLA_AR_REF_V  l6
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l2.event_id      = xet.event_id
  AND l3.event_id    = l2.event_id
  AND l3.line_number = l2.line_number
 AND l6.federal_event_id   (+) =  l3.event_id  AND l6.federal_line_number   (+) =  l3.line_number;
Line: 78069

g_array_event.DELETE;
Line: 78303

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 79123

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 79131

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 79222

PROCEDURE insert_sources_146(
                                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: 79237

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_146';
Line: 79242

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

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

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_CASH_RECEIPTS_H_V' 
                WHEN 11 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 12 THEN 'AR_RCT_METHOD_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_XLA_APPLIED_TO_APP_ID' 
                WHEN 11 THEN 'RCT_CLASS_REMIT_FLAG' 
                WHEN 12 THEN 'RCT_CLASS_CONFIRM_FLAG' 
                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(h9.RMT_BNK_BANK_CHARGES_CCID)
                WHEN 2 THEN TO_CHAR(h9.RMT_BNK_CONFIRMATION_CCID)
                WHEN 3 THEN TO_CHAR(h9.RMT_BNK_EARNED_CCID)
                WHEN 4 THEN TO_CHAR(h9.RMT_BNK_CASH_CCID)
                WHEN 5 THEN TO_CHAR(h9.RMT_BNK_REMITTANCE_CCID)
                WHEN 6 THEN TO_CHAR(h9.RMT_BNK_UNEARNED_CCID)
                WHEN 7 THEN TO_CHAR(h9.RMT_BNK_UNAPPLIED_CCID)
                WHEN 8 THEN TO_CHAR(h10.CODE_COMBINATION_ID_GAIN)
                WHEN 9 THEN TO_CHAR(h10.CODE_COMBINATION_ID_LOSS)
                WHEN 10 THEN TO_CHAR(h2.RCT_XLA_APPLIED_TO_APP_ID)
                WHEN 11 THEN TO_CHAR(h6.RCT_CLASS_REMIT_FLAG)
                WHEN 12 THEN TO_CHAR(h6.RCT_CLASS_CONFIRM_FLAG)
                WHEN 13 THEN TO_CHAR(h2.RCT_PAY_FROM_CUSTOMER)
                WHEN 14 THEN TO_CHAR(h7.RCT_SITE_SITE_USE_ID)
                WHEN 15 THEN TO_CHAR(h2.RCT_APP_STATUS)
                WHEN 16 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 17 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_ID)
                WHEN 18 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_VALUE)
                WHEN 19 THEN TO_CHAR(h2.RCT_TRX_ACCT_REVERSAL)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_CASH_RECEIPTS_H_V  h2
      , AR_RCT_METHOD_H_V  h6
      , AR_RCT_SITE_USES_H_V  h7
      , AR_REMIT_BANK_ACCT_H_V  h9
      , AR_SYSTEM_PARAM_H_V  h10
             ,(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 h2.event_id = xet.event_id
  AND h6.event_id (+) = h2.event_id
  AND h7.event_id (+) = h2.event_id
  AND h9.event_id (+) = h2.event_id
  AND h10.event_id (+) = h2.event_id

)
;
Line: 79456

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_146');
Line: 79771

END insert_sources_146;
Line: 79981

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag 
  , h9.RMT_BNK_BANK_CHARGES_CCID    source_1
  , h9.RMT_BNK_CONFIRMATION_CCID    source_3
  , h9.RMT_BNK_EARNED_CCID    source_4
  , h9.RMT_BNK_CASH_CCID    source_5
  , h9.RMT_BNK_REMITTANCE_CCID    source_6
  , h9.RMT_BNK_UNEARNED_CCID    source_7
  , h9.RMT_BNK_UNAPPLIED_CCID    source_18
  , h10.CODE_COMBINATION_ID_GAIN    source_19
  , h10.CODE_COMBINATION_ID_LOSS    source_20
  , h2.RCT_XLA_APPLIED_TO_APP_ID    source_60
  , h6.RCT_CLASS_REMIT_FLAG    source_72
  , h6.RCT_CLASS_CONFIRM_FLAG    source_73
  , h2.RCT_PAY_FROM_CUSTOMER    source_78
  , h7.RCT_SITE_SITE_USE_ID    source_79
  , h2.RCT_APP_STATUS    source_80
  , h2.RCT_DOC_SEQUENCE_CATEGORY    source_88
  , h2.RCT_DOC_SEQUENCE_ID    source_89
  , h2.RCT_DOC_SEQUENCE_VALUE    source_90
  , h2.RCT_TRX_ACCT_REVERSAL    source_91
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h2
  , AR_RCT_METHOD_H_V  h6
  , AR_RCT_SITE_USES_H_V  h7
  , AR_REMIT_BANK_ACCT_H_V  h9
  , AR_SYSTEM_PARAM_H_V  h10
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id
  AND h6.event_id (+) = h2.event_id
  AND h7.event_id (+) = h2.event_id
  AND h9.event_id (+) = h2.event_id
  AND h10.event_id (+) = h2.event_id

 ORDER BY event_id
;
Line: 80047

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag
 , l4.LINE_NUMBER  
  , l5.DIST_CODE_COMBINATION_ID    source_10
  , l1.BILL_CUSTOMER_CLASS_CODE    source_12
  , l12.FEDERAL_ACCOUNT_RULE    source_13
  , l12.FEDERAL_FUND_EXPIRED_STATUS    source_14
  , l12.FEDERAL_PRIOR_YEAR_FLAG    source_15
  , l12.FEDERAL_FUND_TIME_FRAME    source_16
  , l12.FEDERAL_APPORTIONMENT_CATEGORY    source_17
  , l3.TRX_LINE_DIST_CCID    source_21
  , l5.DIST_SOURCE_TYPE    source_22
  , l8.REC_ACT_TYPE    source_23
  , l5.DIST_LINE_ID    source_24
  , l5.DISTRIBUTION_TYPE    source_25
  , l5.DIST_ENT_AMT    source_26
  , l5.DIST_CURRENCY_CODE    source_27
  , l4.DIST_CUR_CONVERSION_DATE    source_28
  , l4.DIST_CUR_CONVERSION_RATE    source_29
  , l4.DIST_CUR_CONVERSION_TYPE    source_30
  , l4.DIST_TO_ACCTD_AMT    source_31
  , l3.TRX_LINE_DIST_ACCOUNT_CLASS    source_35
  , l3.TRX_LINE_DIST_ID    source_36
  , l3.TRX_DISTRIBUTION_TYPE    source_37
  , l12.FEDERAL_ACCOUNT_VALID_FLAG    source_58
  , l4.DIST_TO_CUR_CONVERSION_DATE    source_59
  , l11.TRX_ENTITY_CODE    source_61
  , l11.TRX_CUSTOMER_TRX_ID    source_62
  , l5.DIST_CURRENCY_CODE_FROM    source_63
  , l4.DIST_TO_CUR_CONVERSION_RATE    source_64
  , l5.DIST_PARTY_ID    source_65
  , l5.DIST_PARTY_SITE_ID    source_66
  , l5.DIST_PARTY_TYPE    source_67
  , l5.DIST_MFAR_ADDITIONAL_ENTRY    source_71
  , l5.DIST_ENT_AMT_FROM    source_74
  , l4.DIST_ACCTD_AMT    source_75
  , l4.DIST_TO_CUR_CONVERSION_TYPE    source_76
  , l5.DIST_SOURCE_TABLE    source_77
  FROM xla_events_gt     xet 
  , AR_BILL_TO_CUSTOMERS_S_V  l1
  , AR_CUST_TRX_LINES_L_V  l3
  , AR_DISTRIBUTIONS_BASE_V  l4
  , AR_DISTRIBUTIONS_L_V  l5
  , AR_RECEIVABLES_TRX_ACT_S_V  l8
  , AR_TRANSACTIONS_S_V  l11
  , FV_XLA_AR_REF_V  l12
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l4.event_id      = xet.event_id
  AND l1.event_id (+)    = l4.event_id
  AND l1.line_number (+) = l4.line_number
  AND l3.event_id (+)    = l4.event_id
  AND l3.line_number (+) = l4.line_number
  AND l5.event_id    = l4.event_id
  AND l5.line_number = l4.line_number
  AND l8.event_id (+)    = l4.event_id
  AND l8.line_number (+) = l4.line_number
  AND l11.event_id (+)    = l4.event_id
  AND l11.line_number (+) = l4.line_number
 AND l12.federal_event_id   (+) =  l5.event_id  AND l12.federal_line_number   (+) =  l5.line_number;
Line: 80159

g_array_event.DELETE;
Line: 80411

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 82408

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 82416

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 82575

         insert_sources_138(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 82609

         insert_sources_139(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 82643

         insert_sources_140(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 82677

         insert_sources_141(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 82711

         insert_sources_142(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 82745

         insert_sources_143(
                          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: 82779

         insert_sources_144(
                          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: 82813

         insert_sources_145(
                          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: 82847

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