DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000008_PKG SQL Statements

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

Line: 2375

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PROCEDURE insert_sources_102(
                                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: 52699

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_102';
Line: 52704

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_102');
Line: 53040

END insert_sources_102;
Line: 53178

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_9
  , h6.REC_ACT_TYPE    source_14
  , h2.BILL_CUST_ACCOUNT_ID    source_23
  , h3.BILL_USES_SITE_USE_ID    source_24
  , h7.XLA_PARTY_TYPE    source_25
  , h1.ADJ_DOC_SEQUENCE_CATEGORY    source_71
  , h1.ADJ_DOC_SEQUENCE_ID    source_72
  , h1.ADJ_DOC_SEQUENCE_VALUE    source_73
  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: 53233

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_3
  , l5.DIST_SOURCE_TYPE    source_13
  , l5.DIST_LINE_ID    source_15
  , l5.DISTRIBUTION_TYPE    source_16
  , l5.DIST_ENT_AMT    source_17
  , l5.DIST_CURRENCY_CODE    source_18
  , l4.DIST_CUR_CONVERSION_DATE    source_19
  , l4.DIST_CUR_CONVERSION_RATE    source_20
  , l4.DIST_CUR_CONVERSION_TYPE    source_21
  , l4.DIST_TO_ACCTD_AMT    source_22
  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: 53307

g_array_event.DELETE;
Line: 53535

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 53986

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 53994

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 54085

PROCEDURE insert_sources_103(
                                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: 54100

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_103';
Line: 54105

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_103');
Line: 54427

END insert_sources_103;
Line: 54561

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_23
  , h2.BILL_USES_SITE_USE_ID    source_24
  , h5.XLA_PARTY_TYPE    source_25
  , h5.TRX_INVOICE_CURRENCY_CODE    source_30
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_75
  , h5.TRX_DOC_SEQUENCE_ID    source_76
  , h5.TRX_DOC_SEQUENCE_VALUE    source_77
  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: 54611

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_4
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l4.TRX_LINE_DIST_ID    source_27
  , l4.TRX_DISTRIBUTION_TYPE    source_28
  , l4.TRX_LINE_DIST_AMT    source_29
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_31
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_32
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_33
  , l3.TRX_LINE_ACCTD_AMT    source_34
  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: 54684

g_array_event.DELETE;
Line: 54910

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 55232

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 55240

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 55331

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

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

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_104');
Line: 55716

END insert_sources_104;
Line: 55864

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_5
  , h8.CODE_COMBINATION_ID_GAIN    source_11
  , h8.CODE_COMBINATION_ID_LOSS    source_12
  , h5.XLA_PARTY_TYPE    source_25
  , h5.CM_INVOICE_CURRENCY_CODE    source_37
  , h2.CM_BILL_CUST_ACCOUNT_ID    source_43
  , h1.CM_BILL_USES_SITE_USE_ID    source_44
  , h5.CM_INVOICING_RULE_ID    source_50
  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: 55917

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_2
  , l6.DIST_CODE_COMBINATION_ID    source_3
  , l6.DIST_SOURCE_TYPE    source_13
  , l7.REC_ACT_TYPE    source_14
  , l6.DIST_ENT_AMT    source_17
  , l3.CM_DIST_IDENTIFER    source_35
  , l3.CM_DIST_TYPE    source_36
  , l3.CM_LINE_CUR_CONVERSION_DATE    source_38
  , l3.CM_LINE_CUR_CONVERSION_RATE    source_39
  , l3.CM_LINE_CUR_CONVERSION_TYPE    source_40
  , l3.GAIN_LOSS_REF    source_41
  , l3.CM_LINE_ACCTD_AMT    source_42
  , l4.CM_TAX_LINE_ID    source_45
  , l4.CM_LINE_DIST_ACCOUNT_CLASS    source_46
  , l4.CM_LINE_DIST_AMT    source_47
  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: 56002

g_array_event.DELETE;
Line: 56224

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 56851

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 56859

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 56950

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

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

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_105');
Line: 57307

END insert_sources_105;
Line: 57447

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_9
  , h1.BILL_CUST_ACCOUNT_ID    source_23
  , h2.BILL_USES_SITE_USE_ID    source_24
  , h5.XLA_PARTY_TYPE    source_25
  , h5.TRX_INVOICE_CURRENCY_CODE    source_30
  , h5.TRX_INVOICING_RULE_ID    source_51
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_75
  , h5.TRX_DOC_SEQUENCE_ID    source_76
  , h5.TRX_DOC_SEQUENCE_VALUE    source_77
  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: 57499

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_4
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l4.TRX_LINE_DIST_ID    source_27
  , l4.TRX_DISTRIBUTION_TYPE    source_28
  , l4.TRX_LINE_DIST_AMT    source_29
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_31
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_32
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_33
  , l3.TRX_LINE_ACCTD_AMT    source_34
  , l4.TRX_TAX_LINE_ID    source_48
  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: 57573

g_array_event.DELETE;
Line: 57803

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 58322

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 58330

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 58421

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

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

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_106');
Line: 58763

END insert_sources_106;
Line: 58897

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_23
  , h2.BILL_USES_SITE_USE_ID    source_24
  , h5.XLA_PARTY_TYPE    source_25
  , h5.TRX_INVOICE_CURRENCY_CODE    source_30
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_75
  , h5.TRX_DOC_SEQUENCE_ID    source_76
  , h5.TRX_DOC_SEQUENCE_VALUE    source_77
  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: 58947

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_4
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l4.TRX_LINE_DIST_ID    source_27
  , l4.TRX_DISTRIBUTION_TYPE    source_28
  , l4.TRX_LINE_DIST_AMT    source_29
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_31
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_32
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_33
  , l3.TRX_LINE_ACCTD_AMT    source_34
  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: 59020

g_array_event.DELETE;
Line: 59246

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 59568

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 59576

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 59667

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'GUARANTEE_ALL';
Line: 59682

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

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

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

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

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

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

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_107');
Line: 60009

END insert_sources_107;
Line: 60143

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_23
  , h2.BILL_USES_SITE_USE_ID    source_24
  , h5.XLA_PARTY_TYPE    source_25
  , h5.TRX_INVOICE_CURRENCY_CODE    source_30
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_75
  , h5.TRX_DOC_SEQUENCE_ID    source_76
  , h5.TRX_DOC_SEQUENCE_VALUE    source_77
  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: 60193

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_4
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l4.TRX_LINE_DIST_ID    source_27
  , l4.TRX_DISTRIBUTION_TYPE    source_28
  , l4.TRX_LINE_DIST_AMT    source_29
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_31
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_32
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_33
  , l3.TRX_LINE_ACCTD_AMT    source_34
  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: 60266

g_array_event.DELETE;
Line: 60492

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 60814

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 60822

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 60913

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'INVOICE_ALL';
Line: 60928

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

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

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

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

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

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

)
;
Line: 61244

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_108');
Line: 61275

END insert_sources_108;
Line: 61417

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_9
  , h1.BILL_CUST_ACCOUNT_ID    source_23
  , h2.BILL_USES_SITE_USE_ID    source_24
  , h5.XLA_PARTY_TYPE    source_25
  , h5.TRX_INVOICE_CURRENCY_CODE    source_30
  , h5.TRX_INVOICING_RULE_ID    source_51
  , h5.TRX_DOC_SEQUENCE_CATEGORY    source_75
  , h5.TRX_DOC_SEQUENCE_ID    source_76
  , h5.TRX_DOC_SEQUENCE_VALUE    source_77
  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: 61469

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag
 , l3.LINE_NUMBER  
  , l4.TRX_LINE_DIST_CCID    source_4
  , l4.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l4.TRX_LINE_DIST_ID    source_27
  , l4.TRX_DISTRIBUTION_TYPE    source_28
  , l4.TRX_LINE_DIST_AMT    source_29
  , l3.TRX_LINE_CUR_CONVERSION_DATE    source_31
  , l3.TRX_LINE_CUR_CONVERSION_RATE    source_32
  , l3.TRX_LINE_CUR_CONVERSION_TYPE    source_33
  , l3.TRX_LINE_ACCTD_AMT    source_34
  , l4.TRX_TAX_LINE_ID    source_48
  , l3.ROUNDING_CORRECTION_FLAG    source_49
  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: 61544

g_array_event.DELETE;
Line: 61774

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 62297

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 62305

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 62396

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'MISC_RECEIPT_ALL';
Line: 62411

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

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

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

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_CASH_CCID' 
                WHEN 3 THEN 'RMT_BNK_CONFIRMATION_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_CASH_CCID)
                WHEN 3 THEN TO_CHAR(h5.RMT_BNK_CONFIRMATION_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: 62578

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

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

)
;
Line: 62729

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_109');
Line: 62760

END insert_sources_109;
Line: 62904

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_CASH_CCID    source_6
  , h5.RMT_BNK_CONFIRMATION_CCID    source_7
  , h5.RMT_BNK_REMITTANCE_CCID    source_8
  , h4.RCT_CLASS_REMIT_FLAG    source_54
  , h4.RCT_CLASS_CONFIRM_FLAG    source_55
  , h1.RCT_DOC_SEQUENCE_CATEGORY    source_78
  , h1.RCT_DOC_SEQUENCE_ID    source_79
  , h1.RCT_DOC_SEQUENCE_VALUE    source_80
  , h1.RCT_TRX_ACCT_REVERSAL    source_81
  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: 62957

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_3
  , l3.DIST_SOURCE_TYPE    source_13
  , l3.DIST_LINE_ID    source_15
  , l3.DISTRIBUTION_TYPE    source_16
  , l3.DIST_ENT_AMT    source_17
  , l3.DIST_CURRENCY_CODE    source_18
  , l2.DIST_CUR_CONVERSION_RATE    source_20
  , l2.DIST_CUR_CONVERSION_TYPE    source_21
  , l2.DIST_TO_ACCTD_AMT    source_22
  , l3.DIST_MFAR_ADDITIONAL_ENTRY    source_52
  , l2.DIST_TO_CUR_CONVERSION_DATE    source_53
  FROM xla_events_gt     xet 
  , AR_DISTRIBUTIONS_BASE_V  l2
  , AR_DISTRIBUTIONS_L_V  l3
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l2.event_id      = xet.event_id
  AND l3.event_id    = l2.event_id
  AND l3.line_number = l2.line_number
;
Line: 63032

g_array_event.DELETE;
Line: 63266

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 63826

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 63834

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 63925

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

C_EVENT_TYPE_CODE    CONSTANT  VARCHAR2(30)  := 'RECEIPT_ALL';
Line: 63940

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

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

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

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_SYSTEM_PARAM_H_V' 
                WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V' 
                WHEN 8 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 9 THEN 'AR_RCT_METHOD_H_V' 
                WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 12 THEN 'AR_RCT_SITE_USES_H_V' 
                WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V' 
                WHEN 14 THEN 'AR_CASH_RECEIPTS_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' 
                
               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' 
                
                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' 
                
                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_CASH_CCID' 
                WHEN 3 THEN 'RMT_BNK_CONFIRMATION_CCID' 
                WHEN 4 THEN 'RMT_BNK_REMITTANCE_CCID' 
                WHEN 5 THEN 'RMT_BNK_UNAPPLIED_CCID' 
                WHEN 6 THEN 'CODE_COMBINATION_ID_GAIN' 
                WHEN 7 THEN 'CODE_COMBINATION_ID_LOSS' 
                WHEN 8 THEN 'RCT_CLASS_REMIT_FLAG' 
                WHEN 9 THEN 'RCT_CLASS_CONFIRM_FLAG' 
                WHEN 10 THEN 'RCT_XLA_APPLIED_TO_APP_ID' 
                WHEN 11 THEN 'RCT_PAY_FROM_CUSTOMER' 
                WHEN 12 THEN 'RCT_SITE_SITE_USE_ID' 
                WHEN 13 THEN 'RCT_APP_STATUS' 
                WHEN 14 THEN 'RCT_DOC_SEQUENCE_CATEGORY' 
                WHEN 15 THEN 'RCT_DOC_SEQUENCE_ID' 
                WHEN 16 THEN 'RCT_DOC_SEQUENCE_VALUE' 
                WHEN 17 THEN 'RCT_TRX_ACCT_REVERSAL' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h8.RMT_BNK_BANK_CHARGES_CCID)
                WHEN 2 THEN TO_CHAR(h8.RMT_BNK_CASH_CCID)
                WHEN 3 THEN TO_CHAR(h8.RMT_BNK_CONFIRMATION_CCID)
                WHEN 4 THEN TO_CHAR(h8.RMT_BNK_REMITTANCE_CCID)
                WHEN 5 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
                WHEN 6 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
                WHEN 7 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
                WHEN 8 THEN TO_CHAR(h5.RCT_CLASS_REMIT_FLAG)
                WHEN 9 THEN TO_CHAR(h5.RCT_CLASS_CONFIRM_FLAG)
                WHEN 10 THEN TO_CHAR(h1.RCT_XLA_APPLIED_TO_APP_ID)
                WHEN 11 THEN TO_CHAR(h1.RCT_PAY_FROM_CUSTOMER)
                WHEN 12 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
                WHEN 13 THEN TO_CHAR(h1.RCT_APP_STATUS)
                WHEN 14 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
                WHEN 15 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
                WHEN 16 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
                WHEN 17 THEN TO_CHAR(h1.RCT_TRX_ACCT_REVERSAL)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , AR_CASH_RECEIPTS_H_V  h1
      , AR_RCT_METHOD_H_V  h5
      , AR_RCT_SITE_USES_H_V  h6
      , AR_REMIT_BANK_ACCT_H_V  h8
      , AR_SYSTEM_PARAM_H_V  h9
             ,(select rownum r from all_objects where rownum <= 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 h1.event_id = xet.event_id
  AND h5.event_id (+) = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h8.event_id (+) = h1.event_id
  AND h9.event_id (+) = h1.event_id

)
;
Line: 64149

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

INSERT INTO xla_diag_sources  --line2
(
        event_id
      , ledger_id
      , sla_ledger_id
      , description_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , source_value
      , source_meaning
      , created_by
      , creation_date
      , last_update_date
      , last_updated_by
      , last_update_login
      , program_update_date
      , program_application_id
      , program_id
      , request_id
)
SELECT  event_id
      , p_target_ledger_id
      , p_sla_ledger_id
      , p_language
      , object_name
      , object_type_code
      , line_number
      , source_application_id
      , source_type_code
      , source_code
      , SUBSTR(source_value,1,1996)
      , SUBSTR(source_meaning ,1,200)
      , xla_environment_pkg.g_Usr_Id
      , TRUNC(SYSDATE)
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Usr_Id
      , xla_environment_pkg.g_Login_Id
      , TRUNC(SYSDATE)
      , xla_environment_pkg.g_Prog_Appl_Id
      , xla_environment_pkg.g_Prog_Id
      , xla_environment_pkg.g_Req_Id
  FROM (
       SELECT xet.event_id                  event_id
            , l4.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V' 
                WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V' 
                WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 18 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 19 THEN 'AR_TRANSACTIONS_S_V' 
                WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V' 
                WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V' 
                WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                WHEN 18 THEN 'LINE' 
                WHEN 19 THEN 'LINE' 
                WHEN 20 THEN 'LINE' 
                WHEN 21 THEN 'LINE' 
                WHEN 22 THEN 'LINE' 
                WHEN 23 THEN 'LINE' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '222' 
                WHEN 2 THEN '222' 
                WHEN 3 THEN '222' 
                WHEN 4 THEN '222' 
                WHEN 5 THEN '222' 
                WHEN 6 THEN '222' 
                WHEN 7 THEN '222' 
                WHEN 8 THEN '222' 
                WHEN 9 THEN '222' 
                WHEN 10 THEN '222' 
                WHEN 11 THEN '222' 
                WHEN 12 THEN '222' 
                WHEN 13 THEN '222' 
                WHEN 14 THEN '222' 
                WHEN 15 THEN '222' 
                WHEN 16 THEN '222' 
                WHEN 17 THEN '222' 
                WHEN 18 THEN '222' 
                WHEN 19 THEN '222' 
                WHEN 20 THEN '222' 
                WHEN 21 THEN '222' 
                WHEN 22 THEN '222' 
                WHEN 23 THEN '222' 
                WHEN 24 THEN '222' 
                WHEN 25 THEN '222' 
                WHEN 26 THEN '222' 
                WHEN 27 THEN '222' 
                WHEN 28 THEN '222' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DIST_CODE_COMBINATION_ID' 
                WHEN 2 THEN 'TRX_LINE_DIST_CCID' 
                WHEN 3 THEN 'DIST_SOURCE_TYPE' 
                WHEN 4 THEN 'REC_ACT_TYPE' 
                WHEN 5 THEN 'DIST_LINE_ID' 
                WHEN 6 THEN 'DISTRIBUTION_TYPE' 
                WHEN 7 THEN 'DIST_ENT_AMT' 
                WHEN 8 THEN 'DIST_CURRENCY_CODE' 
                WHEN 9 THEN 'DIST_CUR_CONVERSION_DATE' 
                WHEN 10 THEN 'DIST_CUR_CONVERSION_RATE' 
                WHEN 11 THEN 'DIST_CUR_CONVERSION_TYPE' 
                WHEN 12 THEN 'DIST_TO_ACCTD_AMT' 
                WHEN 13 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS' 
                WHEN 14 THEN 'TRX_LINE_DIST_ID' 
                WHEN 15 THEN 'TRX_DISTRIBUTION_TYPE' 
                WHEN 16 THEN 'DIST_MFAR_ADDITIONAL_ENTRY' 
                WHEN 17 THEN 'DIST_TO_CUR_CONVERSION_DATE' 
                WHEN 18 THEN 'TRX_ENTITY_CODE' 
                WHEN 19 THEN 'TRX_CUSTOMER_TRX_ID' 
                WHEN 20 THEN 'DIST_ENT_AMT_FROM' 
                WHEN 21 THEN 'DIST_CURRENCY_CODE_FROM' 
                WHEN 22 THEN 'DIST_ACCTD_AMT' 
                WHEN 23 THEN 'DIST_PARTY_ID' 
                WHEN 24 THEN 'DIST_PARTY_SITE_ID' 
                WHEN 25 THEN 'DIST_PARTY_TYPE' 
                WHEN 26 THEN 'DIST_TO_CUR_CONVERSION_TYPE' 
                WHEN 27 THEN 'DIST_TO_CUR_CONVERSION_RATE' 
                WHEN 28 THEN 'DIST_SOURCE_TABLE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l4.DIST_CODE_COMBINATION_ID)
                WHEN 2 THEN TO_CHAR(l2.TRX_LINE_DIST_CCID)
                WHEN 3 THEN TO_CHAR(l4.DIST_SOURCE_TYPE)
                WHEN 4 THEN TO_CHAR(l7.REC_ACT_TYPE)
                WHEN 5 THEN TO_CHAR(l4.DIST_LINE_ID)
                WHEN 6 THEN TO_CHAR(l4.DISTRIBUTION_TYPE)
                WHEN 7 THEN TO_CHAR(l4.DIST_ENT_AMT)
                WHEN 8 THEN TO_CHAR(l4.DIST_CURRENCY_CODE)
                WHEN 9 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_DATE)
                WHEN 10 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_RATE)
                WHEN 11 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_TYPE)
                WHEN 12 THEN TO_CHAR(l3.DIST_TO_ACCTD_AMT)
                WHEN 13 THEN TO_CHAR(l2.TRX_LINE_DIST_ACCOUNT_CLASS)
                WHEN 14 THEN TO_CHAR(l2.TRX_LINE_DIST_ID)
                WHEN 15 THEN TO_CHAR(l2.TRX_DISTRIBUTION_TYPE)
                WHEN 16 THEN TO_CHAR(l4.DIST_MFAR_ADDITIONAL_ENTRY)
                WHEN 17 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_DATE)
                WHEN 18 THEN TO_CHAR(l10.TRX_ENTITY_CODE)
                WHEN 19 THEN TO_CHAR(l10.TRX_CUSTOMER_TRX_ID)
                WHEN 20 THEN TO_CHAR(l4.DIST_ENT_AMT_FROM)
                WHEN 21 THEN TO_CHAR(l4.DIST_CURRENCY_CODE_FROM)
                WHEN 22 THEN TO_CHAR(l3.DIST_ACCTD_AMT)
                WHEN 23 THEN TO_CHAR(l4.DIST_PARTY_ID)
                WHEN 24 THEN TO_CHAR(l4.DIST_PARTY_SITE_ID)
                WHEN 25 THEN TO_CHAR(l4.DIST_PARTY_TYPE)
                WHEN 26 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_TYPE)
                WHEN 27 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_RATE)
                WHEN 28 THEN TO_CHAR(l4.DIST_SOURCE_TABLE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , AR_CUST_TRX_LINES_L_V  l2
        , AR_DISTRIBUTIONS_BASE_V  l3
        , AR_DISTRIBUTIONS_L_V  l4
        , AR_RECEIVABLES_TRX_ACT_S_V  l7
        , AR_TRANSACTIONS_S_V  l10
            , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
        WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
          AND xet.event_class_code = C_EVENT_CLASS_CODE
            AND l3.event_id          = xet.event_id
  AND l2.event_id (+)    = l3.event_id
  AND l2.line_number (+) = l3.line_number
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l10.event_id (+)    = l3.event_id
  AND l10.line_number (+) = l3.line_number

)
;
Line: 64394

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

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

           (p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_110');
Line: 64425

END insert_sources_110;
Line: 64617

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag 
  , h8.RMT_BNK_BANK_CHARGES_CCID    source_1
  , h8.RMT_BNK_CASH_CCID    source_6
  , h8.RMT_BNK_CONFIRMATION_CCID    source_7
  , h8.RMT_BNK_REMITTANCE_CCID    source_8
  , h8.RMT_BNK_UNAPPLIED_CCID    source_10
  , h9.CODE_COMBINATION_ID_GAIN    source_11
  , h9.CODE_COMBINATION_ID_LOSS    source_12
  , h5.RCT_CLASS_REMIT_FLAG    source_54
  , h5.RCT_CLASS_CONFIRM_FLAG    source_55
  , h1.RCT_XLA_APPLIED_TO_APP_ID    source_56
  , h1.RCT_PAY_FROM_CUSTOMER    source_68
  , h6.RCT_SITE_SITE_USE_ID    source_69
  , h1.RCT_APP_STATUS    source_70
  , h1.RCT_DOC_SEQUENCE_CATEGORY    source_78
  , h1.RCT_DOC_SEQUENCE_ID    source_79
  , h1.RCT_DOC_SEQUENCE_VALUE    source_80
  , h1.RCT_TRX_ACCT_REVERSAL    source_81
  FROM xla_events_gt     xet 
  , AR_CASH_RECEIPTS_H_V  h1
  , AR_RCT_METHOD_H_V  h5
  , AR_RCT_SITE_USES_H_V  h6
  , AR_REMIT_BANK_ACCT_H_V  h8
  , AR_SYSTEM_PARAM_H_V  h9
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h1.event_id = xet.event_id
  AND h5.event_id (+) = h1.event_id
  AND h6.event_id (+) = h1.event_id
  AND h8.event_id (+) = h1.event_id
  AND h9.event_id (+) = h1.event_id

 ORDER BY event_id
;
Line: 64681

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
    xet.entity_id
   ,xet.legal_entity_id
   ,xet.entity_code
   ,xet.transaction_number
   ,xet.event_id
   ,xet.event_class_code
   ,xet.event_type_code
   ,xet.event_number
   ,xet.event_date
   ,xet.transaction_date
   ,xet.reference_num_1
   ,xet.reference_num_2
   ,xet.reference_num_3
   ,xet.reference_num_4
   ,xet.reference_char_1
   ,xet.reference_char_2
   ,xet.reference_char_3
   ,xet.reference_char_4
   ,xet.reference_date_1
   ,xet.reference_date_2
   ,xet.reference_date_3
   ,xet.reference_date_4
   ,xet.event_created_by
   ,xet.budgetary_control_flag
 , l3.LINE_NUMBER  
  , l4.DIST_CODE_COMBINATION_ID    source_3
  , l2.TRX_LINE_DIST_CCID    source_4
  , l4.DIST_SOURCE_TYPE    source_13
  , l7.REC_ACT_TYPE    source_14
  , l4.DIST_LINE_ID    source_15
  , l4.DISTRIBUTION_TYPE    source_16
  , l4.DIST_ENT_AMT    source_17
  , l4.DIST_CURRENCY_CODE    source_18
  , l3.DIST_CUR_CONVERSION_DATE    source_19
  , l3.DIST_CUR_CONVERSION_RATE    source_20
  , l3.DIST_CUR_CONVERSION_TYPE    source_21
  , l3.DIST_TO_ACCTD_AMT    source_22
  , l2.TRX_LINE_DIST_ACCOUNT_CLASS    source_26
  , l2.TRX_LINE_DIST_ID    source_27
  , l2.TRX_DISTRIBUTION_TYPE    source_28
  , l4.DIST_MFAR_ADDITIONAL_ENTRY    source_52
  , l3.DIST_TO_CUR_CONVERSION_DATE    source_53
  , l10.TRX_ENTITY_CODE    source_57
  , l10.TRX_CUSTOMER_TRX_ID    source_58
  , l4.DIST_ENT_AMT_FROM    source_59
  , l4.DIST_CURRENCY_CODE_FROM    source_60
  , l3.DIST_ACCTD_AMT    source_61
  , l4.DIST_PARTY_ID    source_62
  , l4.DIST_PARTY_SITE_ID    source_63
  , l4.DIST_PARTY_TYPE    source_64
  , l3.DIST_TO_CUR_CONVERSION_TYPE    source_65
  , l3.DIST_TO_CUR_CONVERSION_RATE    source_66
  , l4.DIST_SOURCE_TABLE    source_67
  FROM xla_events_gt     xet 
  , AR_CUST_TRX_LINES_L_V  l2
  , AR_DISTRIBUTIONS_BASE_V  l3
  , AR_DISTRIBUTIONS_L_V  l4
  , AR_RECEIVABLES_TRX_ACT_S_V  l7
  , AR_TRANSACTIONS_S_V  l10
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l3.event_id      = xet.event_id
  AND l2.event_id (+)    = l3.event_id
  AND l2.line_number (+) = l3.line_number
  AND l4.event_id    = l3.event_id
  AND l4.line_number = l3.line_number
  AND l7.event_id (+)    = l3.event_id
  AND l7.line_number (+) = l3.line_number
  AND l10.event_id (+)    = l3.event_id
  AND l10.line_number (+) = l3.line_number
;
Line: 64782

g_array_event.DELETE;
Line: 65030

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 66650

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 66658

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 66817

         insert_sources_102(
                          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: 66851

         insert_sources_103(
                          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: 66885

         insert_sources_104(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 66919

         insert_sources_105(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 66953

         insert_sources_106(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 66987

         insert_sources_107(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 67021

         insert_sources_108(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 67055

         insert_sources_109(
                          p_target_ledger_id => p_target_ledger_id
                        , p_language         => l_language
                        , p_sla_ledger_id    => l_sla_ledger_id
                        , p_pad_start_date   => p_pad_start_date
                        , p_pad_end_date     => p_pad_end_date
                          );
Line: 67089

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