DBA Data[Home] [Help]

APPS.XLA_00201_AAD_S_000004_BC_PKG SQL Statements

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

Line: 2404

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

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

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

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

   XLA_AE_JOURNAL_ENTRY_PKG.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: 4125

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   XLA_AE_JOURNAL_ENTRY_PKG.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: 18525

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
         (p_hdr_idx => g_array_event(p_event_id).array_value_num('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('acc_rev_header_index')
               ,p_balance_type_code => l_balance_type_code);
Line: 34125

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

PROCEDURE insert_sources_86(
                                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)  := 'PO_PA_ALL';
Line: 47151

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_86';
Line: 47156

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

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

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 'PO_EXTRACT_HEADER_V' 
                WHEN 2 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 3 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 4 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 5 THEN 'PO_EXTRACT_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '201' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'PO_TYPE' 
                WHEN 2 THEN 'PO_NUMBER' 
                WHEN 3 THEN 'PO_HEADER_ID' 
                WHEN 4 THEN 'ENCUMBRANCE_TYPE_ID' 
                WHEN 5 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h4.PO_TYPE)
                WHEN 2 THEN TO_CHAR(h4.PO_NUMBER)
                WHEN 3 THEN TO_CHAR(h4.PO_HEADER_ID)
                WHEN 4 THEN TO_CHAR(h4.ENCUMBRANCE_TYPE_ID)
                WHEN 5 THEN TO_CHAR(h4.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_EXTRACT_HEADER_V  h4
             ,(select rownum r from all_objects where rownum <= 5 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 h4.event_id = xet.event_id

)
;
Line: 47292

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

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 'PO_EXTRACT_DETAIL_V' 
                WHEN 2 THEN 'FV_XLA_PO_REF_V' 
                WHEN 3 THEN 'FV_XLA_PO_REF_V' 
                WHEN 4 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 5 THEN 'FV_XLA_PO_REF_V' 
                WHEN 6 THEN 'FV_XLA_PO_REF_V' 
                WHEN 7 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 8 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 9 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 10 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 11 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 12 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 13 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 14 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 15 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 16 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 17 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 18 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 19 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 20 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 21 THEN 'FV_XLA_PO_REF_V' 
                WHEN 22 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 23 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 24 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 25 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 26 THEN 'PO_DISTS_REF_V' 
                WHEN 27 THEN 'PO_DISTS_REF_V' 
                WHEN 28 THEN 'PO_DISTS_REF_V' 
                WHEN 29 THEN 'FV_XLA_PO_REF_V' 
                WHEN 30 THEN 'FV_XLA_PO_REF_V' 
                WHEN 31 THEN 'FV_XLA_PO_REF_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                WHEN 18 THEN 'LINE' 
                WHEN 19 THEN 'LINE' 
                WHEN 20 THEN 'LINE' 
                WHEN 21 THEN 'LINE' 
                WHEN 22 THEN 'LINE' 
                WHEN 23 THEN 'LINE' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                WHEN 31 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '201' 
                WHEN 9 THEN '201' 
                WHEN 10 THEN '201' 
                WHEN 11 THEN '201' 
                WHEN 12 THEN '201' 
                WHEN 13 THEN '201' 
                WHEN 14 THEN '201' 
                WHEN 15 THEN '201' 
                WHEN 16 THEN '201' 
                WHEN 17 THEN '201' 
                WHEN 18 THEN '201' 
                WHEN 19 THEN '201' 
                WHEN 20 THEN '201' 
                WHEN 21 THEN '8901' 
                WHEN 22 THEN '201' 
                WHEN 23 THEN '201' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                WHEN 26 THEN '201' 
                WHEN 27 THEN '201' 
                WHEN 28 THEN '201' 
                WHEN 29 THEN '8901' 
                WHEN 30 THEN '8901' 
                WHEN 31 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'JE_LINE_DESCRIPTION' 
                WHEN 2 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 4 THEN 'BUDGET_ACCOUNT' 
                WHEN 5 THEN 'FEDERAL_PRIOR_YEAR_FLAG' 
                WHEN 6 THEN 'FEDERAL_NET_PYA_ADJ_AMT' 
                WHEN 7 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 8 THEN 'PO_DISTRIBUTION_TYPE' 
                WHEN 9 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE' 
                WHEN 11 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 12 THEN 'APPLIED_TO_APPL_ID' 
                WHEN 13 THEN 'APPLIED_TO_DIST_LINK_TYPE' 
                WHEN 14 THEN 'APPLIED_TO_ENTITY_CODE' 
                WHEN 15 THEN 'APPLIED_TO_DIST_ID_1' 
                WHEN 16 THEN 'APPLIED_TO_HEADER_ID_1' 
                WHEN 17 THEN 'ENTERED_AMT' 
                WHEN 18 THEN 'CURRENCY_CODE' 
                WHEN 19 THEN 'ACCOUNTED_AMT' 
                WHEN 20 THEN 'PO_ENCUM_UPG_OPTION' 
                WHEN 21 THEN 'FEDERAL_UNANTICIPATED_AMT' 
                WHEN 22 THEN 'JFMIP_REFERENCE' 
                WHEN 23 THEN 'PO_UPG_ENC_TYPE_ID' 
                WHEN 24 THEN 'ALLOC_TO_DISTRIBUTION_TYPE' 
                WHEN 25 THEN 'ALLOC_TO_DIST_ID_1' 
                WHEN 26 THEN 'CURRENCY_CONVERSION_DATE' 
                WHEN 27 THEN 'CURRENCY_CONVERSION_RATE' 
                WHEN 28 THEN 'CURRENCY_CONVERSION_TYPE' 
                WHEN 29 THEN 'FEDERAL_PYA_DIFF_AMT' 
                WHEN 30 THEN 'FEDERAL_ANTICIPATED_AMT' 
                WHEN 31 THEN 'FEDERAL_PYA_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.JE_LINE_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
                WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 4 THEN TO_CHAR(l3.BUDGET_ACCOUNT)
                WHEN 5 THEN TO_CHAR(l1.FEDERAL_PRIOR_YEAR_FLAG)
                WHEN 6 THEN TO_CHAR(l1.FEDERAL_NET_PYA_ADJ_AMT)
                WHEN 7 THEN TO_CHAR(l3.MAIN_OR_BACKING_CODE)
                WHEN 8 THEN TO_CHAR(l3.PO_DISTRIBUTION_TYPE)
                WHEN 9 THEN TO_CHAR(l3.ACCOUNTING_REVERSAL_FLAG)
                WHEN 10 THEN TO_CHAR(l3.DISTRIBUTION_LINK_TYPE)
                WHEN 11 THEN TO_CHAR(l3.PO_DISTRIBUTION_ID)
                WHEN 12 THEN TO_CHAR(l3.APPLIED_TO_APPL_ID)
                WHEN 13 THEN TO_CHAR(l3.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 14 THEN TO_CHAR(l3.APPLIED_TO_ENTITY_CODE)
                WHEN 15 THEN TO_CHAR(l3.APPLIED_TO_DIST_ID_1)
                WHEN 16 THEN TO_CHAR(l3.APPLIED_TO_HEADER_ID_1)
                WHEN 17 THEN TO_CHAR(l3.ENTERED_AMT)
                WHEN 18 THEN TO_CHAR(l3.CURRENCY_CODE)
                WHEN 19 THEN TO_CHAR(l3.ACCOUNTED_AMT)
                WHEN 20 THEN TO_CHAR(l3.PO_ENCUM_UPG_OPTION)
                WHEN 21 THEN TO_CHAR(l1.FEDERAL_UNANTICIPATED_AMT)
                WHEN 22 THEN TO_CHAR(l3.JFMIP_REFERENCE)
                WHEN 23 THEN TO_CHAR(l3.PO_UPG_ENC_TYPE_ID)
                WHEN 24 THEN TO_CHAR(l3.ALLOC_TO_DISTRIBUTION_TYPE)
                WHEN 25 THEN TO_CHAR(l3.ALLOC_TO_DIST_ID_1)
                WHEN 26 THEN TO_CHAR(l2.CURRENCY_CONVERSION_DATE)
                WHEN 27 THEN TO_CHAR(l2.CURRENCY_CONVERSION_RATE)
                WHEN 28 THEN TO_CHAR(l2.CURRENCY_CONVERSION_TYPE)
                WHEN 29 THEN TO_CHAR(l1.FEDERAL_PYA_DIFF_AMT)
                WHEN 30 THEN TO_CHAR(l1.FEDERAL_ANTICIPATED_AMT)
                WHEN 31 THEN TO_CHAR(l1.FEDERAL_PYA_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , FV_XLA_PO_REF_V  l1
        , PO_DISTS_REF_V  l2
        , PO_EXTRACT_DETAIL_V  l3
            , (select rownum r from all_objects where rownum <= 31 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 l1.federal_event_id  (+) = l3.event_id  and l1.federal_line_number  (+) = l3.line_number AND l3.po_distribution_id = l2.po_distribution_id  (+)  and l3.po_distribution_type = l2.po_distribution_type (+) 
)
;
Line: 47542

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

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

           (p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_86');
Line: 47573

END insert_sources_86;
Line: 47745

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
    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 
  , h4.PO_TYPE    source_1
  , h4.PO_NUMBER    source_2
  , h4.PO_HEADER_ID    source_20
  , h4.ENCUMBRANCE_TYPE_ID    source_48
  , h4.GL_DATE    source_49
  FROM xla_events_gt     xet 
  , PO_EXTRACT_HEADER_V  h4
 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 h4.event_id = xet.event_id

 ORDER BY event_id
;
Line: 47789

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
    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  
  , l3.JE_LINE_DESCRIPTION    source_3
  , l1.FEDERAL_FUND_CATEGORY    source_7
  , l1.FEDERAL_FUND_EXPIRED_STATUS    source_8
  , l3.BUDGET_ACCOUNT    source_9
  , l1.FEDERAL_PRIOR_YEAR_FLAG    source_10
  , l1.FEDERAL_NET_PYA_ADJ_AMT    source_11
  , l3.MAIN_OR_BACKING_CODE    source_13
  , l3.PO_DISTRIBUTION_TYPE    source_14
  , l3.ACCOUNTING_REVERSAL_FLAG    source_15
  , l3.DISTRIBUTION_LINK_TYPE    source_17
  , l3.PO_DISTRIBUTION_ID    source_19
  , l3.APPLIED_TO_APPL_ID    source_21
  , l3.APPLIED_TO_DIST_LINK_TYPE    source_22
  , l3.APPLIED_TO_ENTITY_CODE    source_23
  , l3.APPLIED_TO_DIST_ID_1    source_24
  , l3.APPLIED_TO_HEADER_ID_1    source_25
  , l3.ENTERED_AMT    source_26
  , l3.CURRENCY_CODE    source_27
  , l3.ACCOUNTED_AMT    source_28
  , l3.PO_ENCUM_UPG_OPTION    source_29
  , l1.FEDERAL_UNANTICIPATED_AMT    source_30
  , l3.JFMIP_REFERENCE    source_31
  , l3.PO_UPG_ENC_TYPE_ID    source_32
  , l3.ALLOC_TO_DISTRIBUTION_TYPE    source_33
  , l3.ALLOC_TO_DIST_ID_1    source_34
  , l2.CURRENCY_CONVERSION_DATE    source_35
  , l2.CURRENCY_CONVERSION_RATE    source_36
  , l2.CURRENCY_CONVERSION_TYPE    source_37
  , l1.FEDERAL_PYA_DIFF_AMT    source_38
  , l1.FEDERAL_ANTICIPATED_AMT    source_39
  , l1.FEDERAL_PYA_AMT    source_40
  FROM xla_events_gt     xet 
  , FV_XLA_PO_REF_V  l1
  , PO_DISTS_REF_V  l2
  , PO_EXTRACT_DETAIL_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 l3.event_id      = xet.event_id
 AND l1.Federal_event_id  (+) = l3.event_id  AND l1.Federal_Line_Number  (+) = l3.Line_Number AND l3.po_distribution_id = l2.po_distribution_id  (+)  AND l3.po_distribution_type = l2.po_distribution_type (+) ;
Line: 47883

g_array_event.DELETE;
Line: 48106

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 49871

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 49879

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 49935

PROCEDURE insert_sources_87(
                                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)  := 'RELEASE_ALL';
Line: 49950

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_87';
Line: 49955

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

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

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 'PO_EXTRACT_HEADER_V' 
                WHEN 2 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 3 THEN 'PO_RELEASES_REF_V' 
                WHEN 4 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 5 THEN 'PO_EXTRACT_HEADER_V' 
                WHEN 6 THEN 'PO_EXTRACT_HEADER_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                WHEN 2 THEN 'HEADER' 
                WHEN 3 THEN 'HEADER' 
                WHEN 4 THEN 'HEADER' 
                WHEN 5 THEN 'HEADER' 
                WHEN 6 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '201' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                WHEN 6 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'PO_TYPE' 
                WHEN 2 THEN 'PO_NUMBER' 
                WHEN 3 THEN 'PO_RELEASE_NUMBER' 
                WHEN 4 THEN 'PO_RELEASE_ID' 
                WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID' 
                WHEN 6 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h4.PO_TYPE)
                WHEN 2 THEN TO_CHAR(h4.PO_NUMBER)
                WHEN 3 THEN TO_CHAR(h5.PO_RELEASE_NUMBER)
                WHEN 4 THEN TO_CHAR(h4.PO_RELEASE_ID)
                WHEN 5 THEN TO_CHAR(h4.ENCUMBRANCE_TYPE_ID)
                WHEN 6 THEN TO_CHAR(h4.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_EXTRACT_HEADER_V  h4
      , PO_RELEASES_REF_V  h5
             ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h4.event_id = xet.event_id
 AND h4.po_release_id = h5.po_release_id
)
;
Line: 50097

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

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 'PO_EXTRACT_DETAIL_V' 
                WHEN 2 THEN 'FV_XLA_PO_REF_V' 
                WHEN 3 THEN 'FV_XLA_PO_REF_V' 
                WHEN 4 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 5 THEN 'FV_XLA_PO_REF_V' 
                WHEN 6 THEN 'FV_XLA_PO_REF_V' 
                WHEN 7 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 8 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 9 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 10 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 11 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 12 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 13 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 14 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 15 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 16 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 17 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 18 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 19 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 20 THEN 'FV_XLA_PO_REF_V' 
                WHEN 21 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 22 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 23 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 24 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 25 THEN 'PO_DISTS_REF_V' 
                WHEN 26 THEN 'PO_DISTS_REF_V' 
                WHEN 27 THEN 'PO_DISTS_REF_V' 
                WHEN 28 THEN 'FV_XLA_PO_REF_V' 
                WHEN 29 THEN 'FV_XLA_PO_REF_V' 
                WHEN 30 THEN 'FV_XLA_PO_REF_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'LINE' 
                WHEN 2 THEN 'LINE' 
                WHEN 3 THEN 'LINE' 
                WHEN 4 THEN 'LINE' 
                WHEN 5 THEN 'LINE' 
                WHEN 6 THEN 'LINE' 
                WHEN 7 THEN 'LINE' 
                WHEN 8 THEN 'LINE' 
                WHEN 9 THEN 'LINE' 
                WHEN 10 THEN 'LINE' 
                WHEN 11 THEN 'LINE' 
                WHEN 12 THEN 'LINE' 
                WHEN 13 THEN 'LINE' 
                WHEN 14 THEN 'LINE' 
                WHEN 15 THEN 'LINE' 
                WHEN 16 THEN 'LINE' 
                WHEN 17 THEN 'LINE' 
                WHEN 18 THEN 'LINE' 
                WHEN 19 THEN 'LINE' 
                WHEN 20 THEN 'LINE' 
                WHEN 21 THEN 'LINE' 
                WHEN 22 THEN 'LINE' 
                WHEN 23 THEN 'LINE' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '8901' 
                WHEN 6 THEN '8901' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '201' 
                WHEN 9 THEN '201' 
                WHEN 10 THEN '201' 
                WHEN 11 THEN '201' 
                WHEN 12 THEN '201' 
                WHEN 13 THEN '201' 
                WHEN 14 THEN '201' 
                WHEN 15 THEN '201' 
                WHEN 16 THEN '201' 
                WHEN 17 THEN '201' 
                WHEN 18 THEN '201' 
                WHEN 19 THEN '201' 
                WHEN 20 THEN '8901' 
                WHEN 21 THEN '201' 
                WHEN 22 THEN '201' 
                WHEN 23 THEN '201' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                WHEN 26 THEN '201' 
                WHEN 27 THEN '201' 
                WHEN 28 THEN '8901' 
                WHEN 29 THEN '8901' 
                WHEN 30 THEN '8901' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'JE_LINE_DESCRIPTION' 
                WHEN 2 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 4 THEN 'BUDGET_ACCOUNT' 
                WHEN 5 THEN 'FEDERAL_PRIOR_YEAR_FLAG' 
                WHEN 6 THEN 'FEDERAL_NET_PYA_ADJ_AMT' 
                WHEN 7 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 8 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 9 THEN 'DISTRIBUTION_LINK_TYPE' 
                WHEN 10 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 11 THEN 'APPLIED_TO_APPL_ID' 
                WHEN 12 THEN 'APPLIED_TO_DIST_LINK_TYPE' 
                WHEN 13 THEN 'APPLIED_TO_ENTITY_CODE' 
                WHEN 14 THEN 'APPLIED_TO_DIST_ID_1' 
                WHEN 15 THEN 'APPLIED_TO_HEADER_ID_1' 
                WHEN 16 THEN 'ENTERED_AMT' 
                WHEN 17 THEN 'CURRENCY_CODE' 
                WHEN 18 THEN 'ACCOUNTED_AMT' 
                WHEN 19 THEN 'PO_ENCUM_UPG_OPTION' 
                WHEN 20 THEN 'FEDERAL_UNANTICIPATED_AMT' 
                WHEN 21 THEN 'JFMIP_REFERENCE' 
                WHEN 22 THEN 'PO_UPG_ENC_TYPE_ID' 
                WHEN 23 THEN 'ALLOC_TO_DISTRIBUTION_TYPE' 
                WHEN 24 THEN 'ALLOC_TO_DIST_ID_1' 
                WHEN 25 THEN 'CURRENCY_CONVERSION_DATE' 
                WHEN 26 THEN 'CURRENCY_CONVERSION_RATE' 
                WHEN 27 THEN 'CURRENCY_CONVERSION_TYPE' 
                WHEN 28 THEN 'FEDERAL_PYA_DIFF_AMT' 
                WHEN 29 THEN 'FEDERAL_ANTICIPATED_AMT' 
                WHEN 30 THEN 'FEDERAL_PYA_AMT' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.JE_LINE_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
                WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 4 THEN TO_CHAR(l3.BUDGET_ACCOUNT)
                WHEN 5 THEN TO_CHAR(l1.FEDERAL_PRIOR_YEAR_FLAG)
                WHEN 6 THEN TO_CHAR(l1.FEDERAL_NET_PYA_ADJ_AMT)
                WHEN 7 THEN TO_CHAR(l3.MAIN_OR_BACKING_CODE)
                WHEN 8 THEN TO_CHAR(l3.ACCOUNTING_REVERSAL_FLAG)
                WHEN 9 THEN TO_CHAR(l3.DISTRIBUTION_LINK_TYPE)
                WHEN 10 THEN TO_CHAR(l3.PO_DISTRIBUTION_ID)
                WHEN 11 THEN TO_CHAR(l3.APPLIED_TO_APPL_ID)
                WHEN 12 THEN TO_CHAR(l3.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 13 THEN TO_CHAR(l3.APPLIED_TO_ENTITY_CODE)
                WHEN 14 THEN TO_CHAR(l3.APPLIED_TO_DIST_ID_1)
                WHEN 15 THEN TO_CHAR(l3.APPLIED_TO_HEADER_ID_1)
                WHEN 16 THEN TO_CHAR(l3.ENTERED_AMT)
                WHEN 17 THEN TO_CHAR(l3.CURRENCY_CODE)
                WHEN 18 THEN TO_CHAR(l3.ACCOUNTED_AMT)
                WHEN 19 THEN TO_CHAR(l3.PO_ENCUM_UPG_OPTION)
                WHEN 20 THEN TO_CHAR(l1.FEDERAL_UNANTICIPATED_AMT)
                WHEN 21 THEN TO_CHAR(l3.JFMIP_REFERENCE)
                WHEN 22 THEN TO_CHAR(l3.PO_UPG_ENC_TYPE_ID)
                WHEN 23 THEN TO_CHAR(l3.ALLOC_TO_DISTRIBUTION_TYPE)
                WHEN 24 THEN TO_CHAR(l3.ALLOC_TO_DIST_ID_1)
                WHEN 25 THEN TO_CHAR(l2.CURRENCY_CONVERSION_DATE)
                WHEN 26 THEN TO_CHAR(l2.CURRENCY_CONVERSION_RATE)
                WHEN 27 THEN TO_CHAR(l2.CURRENCY_CONVERSION_TYPE)
                WHEN 28 THEN TO_CHAR(l1.FEDERAL_PYA_DIFF_AMT)
                WHEN 29 THEN TO_CHAR(l1.FEDERAL_ANTICIPATED_AMT)
                WHEN 30 THEN TO_CHAR(l1.FEDERAL_PYA_AMT)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , FV_XLA_PO_REF_V  l1
        , PO_DISTS_REF_V  l2
        , PO_EXTRACT_DETAIL_V  l3
            , (select rownum r from all_objects where rownum <= 30 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 l1.federal_event_id  (+) = l3.event_id  and l3.line_number = l1.federal_line_number (+)  AND l3.po_distribution_id = l2.po_distribution_id  (+)  and l3.po_distribution_type = l2.po_distribution_type (+) 
)
;
Line: 50342

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

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

           (p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_87');
Line: 50373

END insert_sources_87;
Line: 50545

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
    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 
  , h4.PO_TYPE    source_1
  , h4.PO_NUMBER    source_2
  , h5.PO_RELEASE_NUMBER    source_4
  , h4.PO_RELEASE_ID    source_41
  , h4.ENCUMBRANCE_TYPE_ID    source_48
  , h4.GL_DATE    source_49
  FROM xla_events_gt     xet 
  , PO_EXTRACT_HEADER_V  h4
  , PO_RELEASES_REF_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 h4.event_id = xet.event_id
 AND h4.po_release_id = h5.po_release_id
 ORDER BY event_id
;
Line: 50591

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
    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  
  , l3.JE_LINE_DESCRIPTION    source_3
  , l1.FEDERAL_FUND_CATEGORY    source_7
  , l1.FEDERAL_FUND_EXPIRED_STATUS    source_8
  , l3.BUDGET_ACCOUNT    source_9
  , l1.FEDERAL_PRIOR_YEAR_FLAG    source_10
  , l1.FEDERAL_NET_PYA_ADJ_AMT    source_11
  , l3.MAIN_OR_BACKING_CODE    source_13
  , l3.ACCOUNTING_REVERSAL_FLAG    source_15
  , l3.DISTRIBUTION_LINK_TYPE    source_17
  , l3.PO_DISTRIBUTION_ID    source_19
  , l3.APPLIED_TO_APPL_ID    source_21
  , l3.APPLIED_TO_DIST_LINK_TYPE    source_22
  , l3.APPLIED_TO_ENTITY_CODE    source_23
  , l3.APPLIED_TO_DIST_ID_1    source_24
  , l3.APPLIED_TO_HEADER_ID_1    source_25
  , l3.ENTERED_AMT    source_26
  , l3.CURRENCY_CODE    source_27
  , l3.ACCOUNTED_AMT    source_28
  , l3.PO_ENCUM_UPG_OPTION    source_29
  , l1.FEDERAL_UNANTICIPATED_AMT    source_30
  , l3.JFMIP_REFERENCE    source_31
  , l3.PO_UPG_ENC_TYPE_ID    source_32
  , l3.ALLOC_TO_DISTRIBUTION_TYPE    source_33
  , l3.ALLOC_TO_DIST_ID_1    source_34
  , l2.CURRENCY_CONVERSION_DATE    source_35
  , l2.CURRENCY_CONVERSION_RATE    source_36
  , l2.CURRENCY_CONVERSION_TYPE    source_37
  , l1.FEDERAL_PYA_DIFF_AMT    source_38
  , l1.FEDERAL_ANTICIPATED_AMT    source_39
  , l1.FEDERAL_PYA_AMT    source_40
  FROM xla_events_gt     xet 
  , FV_XLA_PO_REF_V  l1
  , PO_DISTS_REF_V  l2
  , PO_EXTRACT_DETAIL_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 l3.event_id      = xet.event_id
 AND l1.federal_event_id  (+) = l3.event_id  AND l3.line_number = l1.federal_line_number (+)  AND l3.po_distribution_id = l2.po_distribution_id  (+)  AND l3.po_distribution_type = l2.po_distribution_type (+) ;
Line: 50684

g_array_event.DELETE;
Line: 50910

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 52380

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 52388

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 52444

PROCEDURE insert_sources_88(
                                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)  := 'REQUISITION_ALL';
Line: 52459

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_88';
Line: 52464

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

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

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 'PO_REQ_EXTRACT_HEADER_V' 
                WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V' 
                WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V' 
                WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V' 
                WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '201' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'DOCUMENT_TYPE' 
                WHEN 2 THEN 'REQ_NUMBER' 
                WHEN 3 THEN 'REQ_ID' 
                WHEN 4 THEN 'ENCUMBRANCE_TYPE_ID' 
                WHEN 5 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h3.DOCUMENT_TYPE)
                WHEN 2 THEN TO_CHAR(h3.REQ_NUMBER)
                WHEN 3 THEN TO_CHAR(h3.REQ_ID)
                WHEN 4 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
                WHEN 5 THEN TO_CHAR(h3.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_REQ_EXTRACT_HEADER_V  h3
             ,(select rownum r from all_objects where rownum <= 5 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 h3.event_id = xet.event_id

)
;
Line: 52600

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

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
            , l2.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 2 THEN 'FV_XLA_PO_REF_V' 
                WHEN 3 THEN 'FV_XLA_PO_REF_V' 
                WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 17 THEN 'PO_REQ_LINES_REF_V' 
                WHEN 18 THEN 'PO_REQ_LINES_REF_V' 
                WHEN 19 THEN 'PO_REQ_LINES_REF_V' 
                WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V' 
                WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_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' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                WHEN 2 THEN '8901' 
                WHEN 3 THEN '8901' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                WHEN 6 THEN '201' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '201' 
                WHEN 9 THEN '201' 
                WHEN 10 THEN '201' 
                WHEN 11 THEN '201' 
                WHEN 12 THEN '201' 
                WHEN 13 THEN '201' 
                WHEN 14 THEN '201' 
                WHEN 15 THEN '201' 
                WHEN 16 THEN '201' 
                WHEN 17 THEN '201' 
                WHEN 18 THEN '201' 
                WHEN 19 THEN '201' 
                WHEN 20 THEN '201' 
                WHEN 21 THEN '201' 
                WHEN 22 THEN '201' 
                WHEN 23 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'JE_LINE_DESCRIPTION' 
                WHEN 2 THEN 'FEDERAL_FUND_CATEGORY' 
                WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS' 
                WHEN 4 THEN 'BUDGET_ACCOUNT' 
                WHEN 5 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 6 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 7 THEN 'DISTRIBUTION_LINK_TYPE' 
                WHEN 8 THEN 'APPLIED_TO_APPL_ID' 
                WHEN 9 THEN 'APPLIED_TO_DIST_LINK_TYPE' 
                WHEN 10 THEN 'APPLIED_TO_ENTITY_CODE' 
                WHEN 11 THEN 'APPLIED_TO_DIST_ID_1' 
                WHEN 12 THEN 'APPLIED_TO_HEADER_ID_1' 
                WHEN 13 THEN 'ENTERED_AMT' 
                WHEN 14 THEN 'CURRENCY_CODE' 
                WHEN 15 THEN 'ACCOUNTED_AMT' 
                WHEN 16 THEN 'JFMIP_REFERENCE' 
                WHEN 17 THEN 'CURRENCY_CONVERSION_DATE' 
                WHEN 18 THEN 'CURRENCY_CONVERSION_RATE' 
                WHEN 19 THEN 'CURRENCY_CONVERSION_TYPE' 
                WHEN 20 THEN 'REQ_DISTRIBUTION_ID' 
                WHEN 21 THEN 'REQ_ENCUM_UPG_OPTION' 
                WHEN 22 THEN 'REQ_UPG_ENC_TYPE_ID' 
                WHEN 23 THEN 'ADJUSTMENT_STATUS' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.JE_LINE_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
                WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
                WHEN 4 THEN TO_CHAR(l2.BUDGET_ACCOUNT)
                WHEN 5 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
                WHEN 6 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
                WHEN 7 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
                WHEN 8 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
                WHEN 9 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 10 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
                WHEN 11 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
                WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
                WHEN 13 THEN TO_CHAR(l2.ENTERED_AMT)
                WHEN 14 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 15 THEN TO_CHAR(l2.ACCOUNTED_AMT)
                WHEN 16 THEN TO_CHAR(l2.JFMIP_REFERENCE)
                WHEN 17 THEN TO_CHAR(l4.CURRENCY_CONVERSION_DATE)
                WHEN 18 THEN TO_CHAR(l4.CURRENCY_CONVERSION_RATE)
                WHEN 19 THEN TO_CHAR(l4.CURRENCY_CONVERSION_TYPE)
                WHEN 20 THEN TO_CHAR(l2.REQ_DISTRIBUTION_ID)
                WHEN 21 THEN TO_CHAR(l2.REQ_ENCUM_UPG_OPTION)
                WHEN 22 THEN TO_CHAR(l2.REQ_UPG_ENC_TYPE_ID)
                WHEN 23 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , FV_XLA_PO_REF_V  l1
        , PO_REQ_EXTRACT_DETAIL_V  l2
        , PO_REQ_LINES_REF_V  l4
            , (select rownum r from all_objects where rownum <= 23 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 l1.federal_event_id (+) =l2.event_id  and l1.federal_line_number (+) =l2.line_number AND l2.req_line_id = l4.req_line_id (+) 
)
;
Line: 52810

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

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

           (p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_88');
Line: 52841

END insert_sources_88;
Line: 52997

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
    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 
  , h3.DOCUMENT_TYPE    source_5
  , h3.REQ_NUMBER    source_6
  , h3.REQ_ID    source_44
  , h3.ENCUMBRANCE_TYPE_ID    source_48
  , h3.GL_DATE    source_49
  FROM xla_events_gt     xet 
  , PO_REQ_EXTRACT_HEADER_V  h3
 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 h3.event_id = xet.event_id

 ORDER BY event_id
;
Line: 53041

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
    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  
  , l2.JE_LINE_DESCRIPTION    source_3
  , l1.FEDERAL_FUND_CATEGORY    source_7
  , l1.FEDERAL_FUND_EXPIRED_STATUS    source_8
  , l2.BUDGET_ACCOUNT    source_9
  , l2.MAIN_OR_BACKING_CODE    source_13
  , l2.ACCOUNTING_REVERSAL_FLAG    source_15
  , l2.DISTRIBUTION_LINK_TYPE    source_17
  , l2.APPLIED_TO_APPL_ID    source_21
  , l2.APPLIED_TO_DIST_LINK_TYPE    source_22
  , l2.APPLIED_TO_ENTITY_CODE    source_23
  , l2.APPLIED_TO_DIST_ID_1    source_24
  , l2.APPLIED_TO_HEADER_ID_1    source_25
  , l2.ENTERED_AMT    source_26
  , l2.CURRENCY_CODE    source_27
  , l2.ACCOUNTED_AMT    source_28
  , l2.JFMIP_REFERENCE    source_31
  , l4.CURRENCY_CONVERSION_DATE    source_35
  , l4.CURRENCY_CONVERSION_RATE    source_36
  , l4.CURRENCY_CONVERSION_TYPE    source_37
  , l2.REQ_DISTRIBUTION_ID    source_43
  , l2.REQ_ENCUM_UPG_OPTION    source_45
  , l2.REQ_UPG_ENC_TYPE_ID    source_46
  , l2.ADJUSTMENT_STATUS    source_47
  FROM xla_events_gt     xet 
  , FV_XLA_PO_REF_V  l1
  , PO_REQ_EXTRACT_DETAIL_V  l2
  , PO_REQ_LINES_REF_V  l4
 WHERE xet.event_id between x_first_event_id and x_last_event_id
   and xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'   AND l2.event_id      = xet.event_id
 AND l1.Federal_Event_id (+) =l2.event_id  AND l1.federal_line_number (+) =l2.line_number AND l2.req_line_id = l4.req_line_id (+) ;
Line: 53127

g_array_event.DELETE;
Line: 53350

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

   l_result := XLA_AE_LINES_PKG.InsertLines;
Line: 53879

l_result := XLA_AE_LINES_PKG.InsertLines ;
Line: 53887

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
Line: 54011

         insert_sources_86(
                          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: 54045

         insert_sources_87(
                          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: 54079

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