APPS.XLA_00201_AAD_S_000005_BC_PKG SQL Statements

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

Line: 274

     SELECT NAME
     INTO   l_meaning_meaning
     FROM   HR_ALL_ORGANIZATION_UNITS_VL
     WHERE  ORGANIZATION_ID = p_flex_value
     ;

Line: 1748

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

Line: 1818

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

Line: 2369

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

Line: 2439

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

Line: 2983

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

Line: 3053

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

Line: 3606

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

Line: 3676

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

Line: 4225

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

Line: 4295

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

Line: 4837

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

Line: 4907

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

Line: 5414

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

Line: 5484

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

Line: 5998

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

Line: 6068

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

Line: 6622

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

Line: 6692

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

Line: 7210

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

Line: 7280

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

Line: 7787

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

Line: 7857

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

Line: 8371

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

Line: 8441

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

Line: 9004

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

Line: 9074

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

Line: 9631

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

Line: 9701

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

Line: 10265

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

Line: 10335

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

Line: 10890

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

Line: 10960

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

Line: 11522

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

Line: 11592

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

Line: 12101

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

Line: 12171

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

Line: 12687

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

Line: 12757

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

Line: 13333

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

Line: 13403

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

Line: 13965

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

Line: 14035

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

Line: 14590

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

Line: 14660

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

Line: 15222

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

Line: 15292

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

Line: 15845

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

Line: 15915

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

Line: 16475

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

Line: 16545

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

Line: 17119

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

Line: 17189

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

Line: 17749

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

Line: 17819

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

Line: 18406

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

Line: 18476

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

Line: 19061

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

Line: 19131

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

Line: 19631

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

Line: 19701

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

Line: 20251

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

Line: 20321

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

Line: 20869

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

Line: 20939

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

Line: 21487

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

Line: 21557

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

Line: 22105

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

Line: 22175

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

Line: 22721

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

Line: 22791

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

Line: 23337

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

Line: 23407

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

Line: 23909

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

Line: 23979

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

Line: 24560

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

Line: 24630

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

Line: 25181

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

Line: 25251

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

Line: 25824

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

Line: 25894

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

Line: 26398

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

Line: 26468

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

Line: 26968

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

Line: 27038

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

Line: 27611

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

Line: 27681

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

Line: 28252

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

Line: 28322

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

Line: 28871

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

Line: 28941

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

Line: 29512

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

Line: 29582

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

Line: 30155

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

Line: 30225

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

Line: 30794

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

Line: 30864

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

Line: 31431

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

Line: 31501

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

Line: 32044

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

Line: 32114

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

Line: 32657

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

Line: 32727

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

Line: 33296

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

Line: 33366

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

Line: 33939

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

Line: 34009

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

Line: 34589

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

Line: 34659

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

Line: 35226

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

Line: 35296

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

Line: 35867

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

Line: 35937

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

Line: 36515

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

Line: 36585

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

Line: 37132

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

Line: 37202

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

Line: 37761

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

Line: 37831

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

Line: 38412

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

Line: 38482

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

Line: 39055

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

Line: 39125

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

Line: 39690

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

Line: 39760

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

Line: 40314

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

Line: 40384

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

Line: 40938

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

Line: 41008

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

Line: 41536

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

Line: 41606

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

Line: 42109

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

Line: 42179

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

Line: 42707

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

Line: 42777

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

Line: 43280

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

Line: 43350

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

Line: 43878

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

Line: 43948

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

Line: 44434

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

Line: 44504

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

Line: 45069

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

Line: 45139

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

Line: 45708

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

Line: 45778

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

Line: 46354

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

Line: 46424

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

Line: 46987

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

Line: 47057

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

Line: 47624

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

Line: 47694

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

Line: 48268

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

Line: 48338

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

Line: 48378

PROCEDURE insert_sources_85(
                                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_BURDEN_ALL';

Line: 48393

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_85';

Line: 48398

         (p_msg      => 'BEGIN of insert_sources_85'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 48405

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

Line: 48425

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 'PA_XLA_BC_PKT_PO_HEADER_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PA_XLA_BC_PKT_PO_HEADER_V  h2
             ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h2.event_id = xet.event_id

)
;

Line: 48514

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

Line: 48524

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
            , l1.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 2 THEN 'PA_XLA_TASK_REF_V' 
                WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 9 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 14 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 15 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 16 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 17 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 18 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 19 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 20 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 21 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 22 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 23 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 24 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 25 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 26 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 27 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 28 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 29 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 30 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 31 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 32 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 33 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 34 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 35 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 36 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 37 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 38 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 39 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 40 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 41 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 42 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 43 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 44 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 45 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 46 THEN 'PA_XLA_BC_PKT_PO_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' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                WHEN 31 THEN 'LINE' 
                WHEN 32 THEN 'LINE' 
                WHEN 33 THEN 'LINE' 
                WHEN 34 THEN 'LINE' 
                WHEN 35 THEN 'LINE' 
                WHEN 36 THEN 'LINE' 
                WHEN 37 THEN 'LINE' 
                WHEN 38 THEN 'LINE' 
                WHEN 39 THEN 'LINE' 
                WHEN 40 THEN 'LINE' 
                WHEN 41 THEN 'LINE' 
                WHEN 42 THEN 'LINE' 
                WHEN 43 THEN 'LINE' 
                WHEN 44 THEN 'LINE' 
                WHEN 45 THEN 'LINE' 
                WHEN 46 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '275' 
                WHEN 2 THEN '275' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                WHEN 6 THEN '201' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '201' 
                WHEN 9 THEN '275' 
                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' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                WHEN 26 THEN '201' 
                WHEN 27 THEN '201' 
                WHEN 28 THEN '201' 
                WHEN 29 THEN '201' 
                WHEN 30 THEN '201' 
                WHEN 31 THEN '201' 
                WHEN 32 THEN '201' 
                WHEN 33 THEN '201' 
                WHEN 34 THEN '201' 
                WHEN 35 THEN '201' 
                WHEN 36 THEN '201' 
                WHEN 37 THEN '201' 
                WHEN 38 THEN '201' 
                WHEN 39 THEN '201' 
                WHEN 40 THEN '201' 
                WHEN 41 THEN '201' 
                WHEN 42 THEN '201' 
                WHEN 43 THEN '201' 
                WHEN 44 THEN '201' 
                WHEN 45 THEN '201' 
                WHEN 46 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'PROJECT_NAME' 
                WHEN 2 THEN 'TASK_NAME' 
                WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID' 
                WHEN 4 THEN 'EXPENDITURE_TYPE' 
                WHEN 5 THEN 'DOCUMENT_TYPE' 
                WHEN 6 THEN 'BUDGET_ACCOUNT' 
                WHEN 7 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 8 THEN 'BURDEN_COST_FLAG' 
                WHEN 9 THEN 'PROJ_BURDEN_DISPLAY_METHOD' 
                WHEN 10 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 11 THEN 'ALLOC_TO_APPLN_ID' 
                WHEN 12 THEN 'ALLOC_TO_DIST_TYPE' 
                WHEN 13 THEN 'ALLOC_TO_ENTITY_CODE' 
                WHEN 14 THEN 'ALLOC_TO_FIRST_DIST_ID' 
                WHEN 15 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID' 
                WHEN 16 THEN 'PO_APPLICATION_ID' 
                WHEN 17 THEN 'PO_DISTRIBUTION_TYPE' 
                WHEN 18 THEN 'PO_ENTITY_CODE' 
                WHEN 19 THEN 'PO_FIRST_DIST_ID' 
                WHEN 20 THEN 'PO_FIRST_SYS_TRANS_ID' 
                WHEN 21 THEN 'PO_SECOND_DIST_ID' 
                WHEN 22 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 23 THEN 'LINE_TYPE_NAME' 
                WHEN 24 THEN 'ENC_UPG_CR_ACCT_CLASS' 
                WHEN 25 THEN 'ENC_UPG_CR_ACCOUNT' 
                WHEN 26 THEN 'ENTERED_AMT' 
                WHEN 27 THEN 'CURRENCY_CODE' 
                WHEN 28 THEN 'ACCOUNTED_AMT' 
                WHEN 29 THEN 'ENC_UPG_DR_ACCT_CLASS' 
                WHEN 30 THEN 'ENC_UPG_DR_ACCOUNT' 
                WHEN 31 THEN 'USE_ENC_UPG_ATTRIB_FLAG' 
                WHEN 32 THEN 'ENC_UPG_CR_ENC_TYPE_ID' 
                WHEN 33 THEN 'ENC_UPG_DR_ENC_TYPE_ID' 
                WHEN 34 THEN 'REQ_APPLICATION_ID' 
                WHEN 35 THEN 'REQ_DISTRIBUTION_TYPE' 
                WHEN 36 THEN 'REQ_ENTITY_CODE' 
                WHEN 37 THEN 'REQ_FIRST_DIST_ID' 
                WHEN 38 THEN 'REQ_FIRST_SYS_TRANS_ID' 
                WHEN 39 THEN 'REQ_SECOND_DIST_ID' 
                WHEN 40 THEN 'BACKING_REQ_ENC_FLIPPED_FLAG' 
                WHEN 41 THEN 'PA_APPLICATION_ID' 
                WHEN 42 THEN 'PA_DISTRIBUTION_TYPE' 
                WHEN 43 THEN 'PA_ENTITY_CODE' 
                WHEN 44 THEN 'PA_FIRST_DIST_ID' 
                WHEN 45 THEN 'PA_FIRST_SYS_TRANS_ID' 
                WHEN 46 THEN 'PA_SECOND_DIST_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
                WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
                WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
                WHEN 5 THEN TO_CHAR(l1.DOCUMENT_TYPE)
                WHEN 6 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
                WHEN 7 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
                WHEN 8 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
                WHEN 9 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
                WHEN 10 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
                WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
                WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
                WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
                WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
                WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
                WHEN 16 THEN TO_CHAR(l1.PO_APPLICATION_ID)
                WHEN 17 THEN TO_CHAR(l1.PO_DISTRIBUTION_TYPE)
                WHEN 18 THEN TO_CHAR(l1.PO_ENTITY_CODE)
                WHEN 19 THEN TO_CHAR(l1.PO_FIRST_DIST_ID)
                WHEN 20 THEN TO_CHAR(l1.PO_FIRST_SYS_TRANS_ID)
                WHEN 21 THEN TO_CHAR(l1.PO_SECOND_DIST_ID)
                WHEN 22 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
                WHEN 23 THEN TO_CHAR(l1.LINE_TYPE_NAME)
                WHEN 24 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
                WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
                WHEN 26 THEN TO_CHAR(l1.ENTERED_AMT)
                WHEN 27 THEN TO_CHAR(l1.CURRENCY_CODE)
                WHEN 28 THEN TO_CHAR(l1.ACCOUNTED_AMT)
                WHEN 29 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
                WHEN 30 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
                WHEN 31 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
                WHEN 32 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
                WHEN 33 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
                WHEN 34 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
                WHEN 35 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
                WHEN 36 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
                WHEN 37 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
                WHEN 38 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
                WHEN 39 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
                WHEN 40 THEN TO_CHAR(l1.BACKING_REQ_ENC_FLIPPED_FLAG)
                WHEN 41 THEN TO_CHAR(l1.PA_APPLICATION_ID)
                WHEN 42 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
                WHEN 43 THEN TO_CHAR(l1.PA_ENTITY_CODE)
                WHEN 44 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
                WHEN 45 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
                WHEN 46 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
                          1011404
                         ,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                         ,'EXPENDITURE_ORGANIZATION_ID'
                         ,'S'
                         ,201)
                WHEN 8 THEN fvl14.meaning
                
                ELSE null
              END               source_meaning
         FROM  xla_events_gt     xet  
        , PA_XLA_BC_PKT_PO_DETAIL_V  l1
        , PA_XLA_PROJECT_REF_V  l3
        , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
            , (select rownum r from all_objects where rownum <= 46 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 l1.event_id          = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  
)
;

Line: 48854

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

Line: 48863

         (p_msg      => 'END of insert_sources_85'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 48884

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_85');

Line: 48885

END insert_sources_85;

Line: 49080

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_BURDEN
    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 
  , h2.GL_DATE    source_79
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_PO_HEADER_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 49120

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_BURDEN
    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
 , l1.LINE_NUMBER  
  , l3.PROJECT_NAME    source_3
  , l4.TASK_NAME    source_4
  , l1.EXPENDITURE_ORGANIZATION_ID    source_5
  , l1.EXPENDITURE_TYPE    source_6
  , l1.DOCUMENT_TYPE    source_9
  , l1.BUDGET_ACCOUNT    source_11
  , l1.MAIN_OR_BACKING_CODE    source_13
  , l1.BURDEN_COST_FLAG    source_14
  , fvl14.meaning   source_14_meaning
  , l3.PROJ_BURDEN_DISPLAY_METHOD    source_15
  , l1.ACCOUNTING_REVERSAL_FLAG    source_16
  , l1.ALLOC_TO_APPLN_ID    source_17
  , l1.ALLOC_TO_DIST_TYPE    source_18
  , l1.ALLOC_TO_ENTITY_CODE    source_19
  , l1.ALLOC_TO_FIRST_DIST_ID    source_20
  , l1.ALLOC_TO_FIRST_SYS_TRANS_ID    source_21
  , l1.PO_APPLICATION_ID    source_23
  , l1.PO_DISTRIBUTION_TYPE    source_24
  , l1.PO_ENTITY_CODE    source_25
  , l1.PO_FIRST_DIST_ID    source_26
  , l1.PO_FIRST_SYS_TRANS_ID    source_27
  , l1.PO_SECOND_DIST_ID    source_28
  , l1.PO_DISTRIBUTION_ID    source_29
  , l1.LINE_TYPE_NAME    source_30
  , l1.ENC_UPG_CR_ACCT_CLASS    source_31
  , l1.ENC_UPG_CR_ACCOUNT    source_32
  , l1.ENTERED_AMT    source_33
  , l1.CURRENCY_CODE    source_34
  , l1.ACCOUNTED_AMT    source_35
  , l1.ENC_UPG_DR_ACCT_CLASS    source_36
  , l1.ENC_UPG_DR_ACCOUNT    source_37
  , l1.USE_ENC_UPG_ATTRIB_FLAG    source_38
  , l1.ENC_UPG_CR_ENC_TYPE_ID    source_39
  , l1.ENC_UPG_DR_ENC_TYPE_ID    source_40
  , l1.REQ_APPLICATION_ID    source_41
  , l1.REQ_DISTRIBUTION_TYPE    source_42
  , l1.REQ_ENTITY_CODE    source_43
  , l1.REQ_FIRST_DIST_ID    source_44
  , l1.REQ_FIRST_SYS_TRANS_ID    source_45
  , l1.REQ_SECOND_DIST_ID    source_46
  , l1.BACKING_REQ_ENC_FLIPPED_FLAG    source_67
  , l1.PA_APPLICATION_ID    source_68
  , l1.PA_DISTRIBUTION_TYPE    source_69
  , l1.PA_ENTITY_CODE    source_70
  , l1.PA_FIRST_DIST_ID    source_71
  , l1.PA_FIRST_SYS_TRANS_ID    source_72
  , l1.PA_SECOND_DIST_ID    source_73
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_PO_DETAIL_V  l1
  , PA_XLA_PROJECT_REF_V  l3
  , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
 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 l1.event_id      = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  ;

Line: 49235

g_array_event.DELETE;

Line: 49438

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 49459

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 50806

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 50814

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 50870

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

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_86';

Line: 50890

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

Line: 50897

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

Line: 50917

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 'GL_DATE' 
                WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h3.PO_TYPE)
                WHEN 2 THEN TO_CHAR(h3.PO_NUMBER)
                WHEN 3 THEN TO_CHAR(h3.PO_HEADER_ID)
                WHEN 4 THEN TO_CHAR(h3.GL_DATE)
                WHEN 5 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_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: 51026

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

Line: 51036

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_EXTRACT_DETAIL_V' 
                WHEN 2 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 3 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 4 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 5 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 6 THEN 'PO_EXTRACT_DETAIL_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 'PO_DISTS_REF_V' 
                WHEN 22 THEN 'PO_DISTS_REF_V' 
                WHEN 23 THEN 'PO_DISTS_REF_V' 
                WHEN 24 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 25 THEN 'PO_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' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                
                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' 
                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' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'JE_LINE_DESCRIPTION' 
                WHEN 2 THEN 'BUDGET_ACCOUNT' 
                WHEN 3 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 4 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 5 THEN 'PO_DISTRIBUTION_TYPE' 
                WHEN 6 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 7 THEN 'ENTERED_AMT' 
                WHEN 8 THEN 'CURRENCY_CODE' 
                WHEN 9 THEN 'ACCOUNTED_AMT' 
                WHEN 10 THEN 'ALLOC_TO_DISTRIBUTION_TYPE' 
                WHEN 11 THEN 'ALLOC_TO_DIST_ID_1' 
                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 'DISTRIBUTION_LINK_TYPE' 
                WHEN 18 THEN 'PO_ENCUM_UPG_OPTION' 
                WHEN 19 THEN 'JFMIP_REFERENCE' 
                WHEN 20 THEN 'PO_UPG_ENC_TYPE_ID' 
                WHEN 21 THEN 'CURRENCY_CONVERSION_DATE' 
                WHEN 22 THEN 'CURRENCY_CONVERSION_RATE' 
                WHEN 23 THEN 'CURRENCY_CONVERSION_TYPE' 
                WHEN 24 THEN 'BACKING_REQ_ENC_CHANGED' 
                WHEN 25 THEN 'ADJUSTMENT_STATUS' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l2.JE_LINE_DESCRIPTION)
                WHEN 2 THEN TO_CHAR(l2.BUDGET_ACCOUNT)
                WHEN 3 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
                WHEN 4 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
                WHEN 5 THEN TO_CHAR(l2.PO_DISTRIBUTION_TYPE)
                WHEN 6 THEN TO_CHAR(l2.PO_DISTRIBUTION_ID)
                WHEN 7 THEN TO_CHAR(l2.ENTERED_AMT)
                WHEN 8 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 9 THEN TO_CHAR(l2.ACCOUNTED_AMT)
                WHEN 10 THEN TO_CHAR(l2.ALLOC_TO_DISTRIBUTION_TYPE)
                WHEN 11 THEN TO_CHAR(l2.ALLOC_TO_DIST_ID_1)
                WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
                WHEN 13 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 14 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
                WHEN 15 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
                WHEN 16 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
                WHEN 17 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
                WHEN 18 THEN TO_CHAR(l2.PO_ENCUM_UPG_OPTION)
                WHEN 19 THEN TO_CHAR(l2.JFMIP_REFERENCE)
                WHEN 20 THEN TO_CHAR(l2.PO_UPG_ENC_TYPE_ID)
                WHEN 21 THEN TO_CHAR(l1.CURRENCY_CONVERSION_DATE)
                WHEN 22 THEN TO_CHAR(l1.CURRENCY_CONVERSION_RATE)
                WHEN 23 THEN TO_CHAR(l1.CURRENCY_CONVERSION_TYPE)
                WHEN 24 THEN TO_CHAR(l2.BACKING_REQ_ENC_CHANGED)
                WHEN 25 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , PO_DISTS_REF_V  l1
        , PO_EXTRACT_DETAIL_V  l2
            , (select rownum r from all_objects where rownum <= 25 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 l2.po_distribution_id = l1.po_distribution_id  (+)  and l2.po_distribution_type = l1.po_distribution_type (+) 
)
;

Line: 51245

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

Line: 51254

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

Line: 51275

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_86');

Line: 51276

END insert_sources_86;

Line: 51436

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 
  , h3.PO_TYPE    source_1
  , h3.PO_NUMBER    source_2
  , h3.PO_HEADER_ID    source_52
  , h3.GL_DATE    source_79
  , h3.ENCUMBRANCE_TYPE_ID    source_80
  FROM xla_events_gt     xet 
  , PO_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: 51480

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
 , l2.LINE_NUMBER  
  , l2.JE_LINE_DESCRIPTION    source_7
  , l2.BUDGET_ACCOUNT    source_11
  , l2.MAIN_OR_BACKING_CODE    source_13
  , l2.ACCOUNTING_REVERSAL_FLAG    source_16
  , l2.PO_DISTRIBUTION_TYPE    source_24
  , l2.PO_DISTRIBUTION_ID    source_29
  , l2.ENTERED_AMT    source_33
  , l2.CURRENCY_CODE    source_34
  , l2.ACCOUNTED_AMT    source_35
  , l2.ALLOC_TO_DISTRIBUTION_TYPE    source_49
  , l2.ALLOC_TO_DIST_ID_1    source_51
  , l2.APPLIED_TO_APPL_ID    source_53
  , l2.APPLIED_TO_DIST_LINK_TYPE    source_54
  , l2.APPLIED_TO_ENTITY_CODE    source_55
  , l2.APPLIED_TO_DIST_ID_1    source_56
  , l2.APPLIED_TO_HEADER_ID_1    source_57
  , l2.DISTRIBUTION_LINK_TYPE    source_58
  , l2.PO_ENCUM_UPG_OPTION    source_59
  , l2.JFMIP_REFERENCE    source_60
  , l2.PO_UPG_ENC_TYPE_ID    source_61
  , l1.CURRENCY_CONVERSION_DATE    source_62
  , l1.CURRENCY_CONVERSION_RATE    source_63
  , l1.CURRENCY_CONVERSION_TYPE    source_64
  , l2.BACKING_REQ_ENC_CHANGED    source_65
  , l2.ADJUSTMENT_STATUS    source_75
  FROM xla_events_gt     xet 
  , PO_DISTS_REF_V  l1
  , PO_EXTRACT_DETAIL_V  l2
 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 l2.po_distribution_id = l1.po_distribution_id  (+)  AND l2.po_distribution_type = l1.po_distribution_type (+) ;

Line: 51567

g_array_event.DELETE;

Line: 51790

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 51811

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 52599

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 52607

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 52663

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

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_87';

Line: 52683

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

Line: 52690

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

Line: 52710

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 'GL_DATE' 
                WHEN 6 THEN 'ENCUMBRANCE_TYPE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h3.PO_TYPE)
                WHEN 2 THEN TO_CHAR(h3.PO_NUMBER)
                WHEN 3 THEN TO_CHAR(h4.PO_RELEASE_NUMBER)
                WHEN 4 THEN TO_CHAR(h3.PO_RELEASE_ID)
                WHEN 5 THEN TO_CHAR(h3.GL_DATE)
                WHEN 6 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_EXTRACT_HEADER_V  h3
      , PO_RELEASES_REF_V  h4
             ,(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 h3.event_id = xet.event_id
 AND h3.po_release_id = h4.po_release_id
)
;

Line: 52825

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

Line: 52835

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_EXTRACT_DETAIL_V' 
                WHEN 2 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 3 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 4 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 5 THEN 'PO_EXTRACT_DETAIL_V' 
                WHEN 6 THEN 'PO_EXTRACT_DETAIL_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_DISTS_REF_V' 
                WHEN 21 THEN 'PO_DISTS_REF_V' 
                WHEN 22 THEN 'PO_DISTS_REF_V' 
                WHEN 23 THEN 'PO_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 '201' 
                WHEN 3 THEN '201' 
                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 'BUDGET_ACCOUNT' 
                WHEN 3 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 4 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 5 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 6 THEN 'ENTERED_AMT' 
                WHEN 7 THEN 'CURRENCY_CODE' 
                WHEN 8 THEN 'ACCOUNTED_AMT' 
                WHEN 9 THEN 'ALLOC_TO_DISTRIBUTION_TYPE' 
                WHEN 10 THEN 'ALLOC_TO_DIST_ID_1' 
                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 'DISTRIBUTION_LINK_TYPE' 
                WHEN 17 THEN 'PO_ENCUM_UPG_OPTION' 
                WHEN 18 THEN 'JFMIP_REFERENCE' 
                WHEN 19 THEN 'PO_UPG_ENC_TYPE_ID' 
                WHEN 20 THEN 'CURRENCY_CONVERSION_DATE' 
                WHEN 21 THEN 'CURRENCY_CONVERSION_RATE' 
                WHEN 22 THEN 'CURRENCY_CONVERSION_TYPE' 
                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(l2.BUDGET_ACCOUNT)
                WHEN 3 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
                WHEN 4 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
                WHEN 5 THEN TO_CHAR(l2.PO_DISTRIBUTION_ID)
                WHEN 6 THEN TO_CHAR(l2.ENTERED_AMT)
                WHEN 7 THEN TO_CHAR(l2.CURRENCY_CODE)
                WHEN 8 THEN TO_CHAR(l2.ACCOUNTED_AMT)
                WHEN 9 THEN TO_CHAR(l2.ALLOC_TO_DISTRIBUTION_TYPE)
                WHEN 10 THEN TO_CHAR(l2.ALLOC_TO_DIST_ID_1)
                WHEN 11 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
                WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
                WHEN 13 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
                WHEN 14 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
                WHEN 15 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
                WHEN 16 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
                WHEN 17 THEN TO_CHAR(l2.PO_ENCUM_UPG_OPTION)
                WHEN 18 THEN TO_CHAR(l2.JFMIP_REFERENCE)
                WHEN 19 THEN TO_CHAR(l2.PO_UPG_ENC_TYPE_ID)
                WHEN 20 THEN TO_CHAR(l1.CURRENCY_CONVERSION_DATE)
                WHEN 21 THEN TO_CHAR(l1.CURRENCY_CONVERSION_RATE)
                WHEN 22 THEN TO_CHAR(l1.CURRENCY_CONVERSION_TYPE)
                WHEN 23 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM  xla_events_gt     xet  
        , PO_DISTS_REF_V  l1
        , PO_EXTRACT_DETAIL_V  l2
            , (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 l2.po_distribution_id = l1.po_distribution_id  (+)  and l2.po_distribution_type = l1.po_distribution_type (+) 
)
;

Line: 53034

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

Line: 53043

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

Line: 53064

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_87');

Line: 53065

END insert_sources_87;

Line: 53223

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 
  , h3.PO_TYPE    source_1
  , h3.PO_NUMBER    source_2
  , h4.PO_RELEASE_NUMBER    source_8
  , h3.PO_RELEASE_ID    source_66
  , h3.GL_DATE    source_79
  , h3.ENCUMBRANCE_TYPE_ID    source_80
  FROM xla_events_gt     xet 
  , PO_EXTRACT_HEADER_V  h3
  , PO_RELEASES_REF_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 h3.event_id = xet.event_id
 AND h3.po_release_id = h4.po_release_id
 ORDER BY event_id
;

Line: 53269

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
 , l2.LINE_NUMBER  
  , l2.JE_LINE_DESCRIPTION    source_7
  , l2.BUDGET_ACCOUNT    source_11
  , l2.MAIN_OR_BACKING_CODE    source_13
  , l2.ACCOUNTING_REVERSAL_FLAG    source_16
  , l2.PO_DISTRIBUTION_ID    source_29
  , l2.ENTERED_AMT    source_33
  , l2.CURRENCY_CODE    source_34
  , l2.ACCOUNTED_AMT    source_35
  , l2.ALLOC_TO_DISTRIBUTION_TYPE    source_49
  , l2.ALLOC_TO_DIST_ID_1    source_51
  , l2.APPLIED_TO_APPL_ID    source_53
  , l2.APPLIED_TO_DIST_LINK_TYPE    source_54
  , l2.APPLIED_TO_ENTITY_CODE    source_55
  , l2.APPLIED_TO_DIST_ID_1    source_56
  , l2.APPLIED_TO_HEADER_ID_1    source_57
  , l2.DISTRIBUTION_LINK_TYPE    source_58
  , l2.PO_ENCUM_UPG_OPTION    source_59
  , l2.JFMIP_REFERENCE    source_60
  , l2.PO_UPG_ENC_TYPE_ID    source_61
  , l1.CURRENCY_CONVERSION_DATE    source_62
  , l1.CURRENCY_CONVERSION_RATE    source_63
  , l1.CURRENCY_CONVERSION_TYPE    source_64
  , l2.ADJUSTMENT_STATUS    source_75
  FROM xla_events_gt     xet 
  , PO_DISTS_REF_V  l1
  , PO_EXTRACT_DETAIL_V  l2
 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 l2.po_distribution_id = l1.po_distribution_id  (+)  AND l2.po_distribution_type = l1.po_distribution_type (+) ;

Line: 53354

g_array_event.DELETE;

Line: 53580

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 53601

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 54258

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 54266

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 54322

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)  := 'RELEASE_BURDEN_ALL';

Line: 54337

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_88';

Line: 54342

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

Line: 54349

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

Line: 54369

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 'PA_XLA_BC_PKT_PO_HEADER_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PA_XLA_BC_PKT_PO_HEADER_V  h2
             ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h2.event_id = xet.event_id

)
;

Line: 54458

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

Line: 54468

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
            , l1.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 2 THEN 'PA_XLA_TASK_REF_V' 
                WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 9 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 14 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 15 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 16 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 17 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 18 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 19 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 20 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 21 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 22 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 23 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 24 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 25 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 26 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 27 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 28 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 29 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 30 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 31 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 32 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 33 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 34 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 35 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 36 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 37 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 38 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 39 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 40 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 41 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 42 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 43 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 44 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 45 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V' 
                WHEN 46 THEN 'PA_XLA_BC_PKT_PO_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' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                WHEN 31 THEN 'LINE' 
                WHEN 32 THEN 'LINE' 
                WHEN 33 THEN 'LINE' 
                WHEN 34 THEN 'LINE' 
                WHEN 35 THEN 'LINE' 
                WHEN 36 THEN 'LINE' 
                WHEN 37 THEN 'LINE' 
                WHEN 38 THEN 'LINE' 
                WHEN 39 THEN 'LINE' 
                WHEN 40 THEN 'LINE' 
                WHEN 41 THEN 'LINE' 
                WHEN 42 THEN 'LINE' 
                WHEN 43 THEN 'LINE' 
                WHEN 44 THEN 'LINE' 
                WHEN 45 THEN 'LINE' 
                WHEN 46 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '275' 
                WHEN 2 THEN '275' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                WHEN 6 THEN '201' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '201' 
                WHEN 9 THEN '275' 
                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' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                WHEN 26 THEN '201' 
                WHEN 27 THEN '201' 
                WHEN 28 THEN '201' 
                WHEN 29 THEN '201' 
                WHEN 30 THEN '201' 
                WHEN 31 THEN '201' 
                WHEN 32 THEN '201' 
                WHEN 33 THEN '201' 
                WHEN 34 THEN '201' 
                WHEN 35 THEN '201' 
                WHEN 36 THEN '201' 
                WHEN 37 THEN '201' 
                WHEN 38 THEN '201' 
                WHEN 39 THEN '201' 
                WHEN 40 THEN '201' 
                WHEN 41 THEN '201' 
                WHEN 42 THEN '201' 
                WHEN 43 THEN '201' 
                WHEN 44 THEN '201' 
                WHEN 45 THEN '201' 
                WHEN 46 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'PROJECT_NAME' 
                WHEN 2 THEN 'TASK_NAME' 
                WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID' 
                WHEN 4 THEN 'EXPENDITURE_TYPE' 
                WHEN 5 THEN 'DOCUMENT_TYPE' 
                WHEN 6 THEN 'BUDGET_ACCOUNT' 
                WHEN 7 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 8 THEN 'BURDEN_COST_FLAG' 
                WHEN 9 THEN 'PROJ_BURDEN_DISPLAY_METHOD' 
                WHEN 10 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 11 THEN 'ALLOC_TO_APPLN_ID' 
                WHEN 12 THEN 'ALLOC_TO_DIST_TYPE' 
                WHEN 13 THEN 'ALLOC_TO_ENTITY_CODE' 
                WHEN 14 THEN 'ALLOC_TO_FIRST_DIST_ID' 
                WHEN 15 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID' 
                WHEN 16 THEN 'ALLOC_TO_SECOND_DIST_ID' 
                WHEN 17 THEN 'PO_APPLICATION_ID' 
                WHEN 18 THEN 'PO_DISTRIBUTION_TYPE' 
                WHEN 19 THEN 'PO_ENTITY_CODE' 
                WHEN 20 THEN 'PO_FIRST_DIST_ID' 
                WHEN 21 THEN 'PO_FIRST_SYS_TRANS_ID' 
                WHEN 22 THEN 'PO_SECOND_DIST_ID' 
                WHEN 23 THEN 'PO_DISTRIBUTION_ID' 
                WHEN 24 THEN 'LINE_TYPE_NAME' 
                WHEN 25 THEN 'ENC_UPG_CR_ACCT_CLASS' 
                WHEN 26 THEN 'ENC_UPG_CR_ACCOUNT' 
                WHEN 27 THEN 'ENTERED_AMT' 
                WHEN 28 THEN 'CURRENCY_CODE' 
                WHEN 29 THEN 'ACCOUNTED_AMT' 
                WHEN 30 THEN 'ENC_UPG_DR_ACCT_CLASS' 
                WHEN 31 THEN 'ENC_UPG_DR_ACCOUNT' 
                WHEN 32 THEN 'USE_ENC_UPG_ATTRIB_FLAG' 
                WHEN 33 THEN 'ENC_UPG_CR_ENC_TYPE_ID' 
                WHEN 34 THEN 'ENC_UPG_DR_ENC_TYPE_ID' 
                WHEN 35 THEN 'REQ_APPLICATION_ID' 
                WHEN 36 THEN 'REQ_DISTRIBUTION_TYPE' 
                WHEN 37 THEN 'REQ_ENTITY_CODE' 
                WHEN 38 THEN 'REQ_FIRST_DIST_ID' 
                WHEN 39 THEN 'REQ_FIRST_SYS_TRANS_ID' 
                WHEN 40 THEN 'REQ_SECOND_DIST_ID' 
                WHEN 41 THEN 'PA_APPLICATION_ID' 
                WHEN 42 THEN 'PA_DISTRIBUTION_TYPE' 
                WHEN 43 THEN 'PA_ENTITY_CODE' 
                WHEN 44 THEN 'PA_FIRST_DIST_ID' 
                WHEN 45 THEN 'PA_FIRST_SYS_TRANS_ID' 
                WHEN 46 THEN 'PA_SECOND_DIST_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
                WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
                WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
                WHEN 5 THEN TO_CHAR(l1.DOCUMENT_TYPE)
                WHEN 6 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
                WHEN 7 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
                WHEN 8 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
                WHEN 9 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
                WHEN 10 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
                WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
                WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
                WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
                WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
                WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
                WHEN 16 THEN TO_CHAR(l1.ALLOC_TO_SECOND_DIST_ID)
                WHEN 17 THEN TO_CHAR(l1.PO_APPLICATION_ID)
                WHEN 18 THEN TO_CHAR(l1.PO_DISTRIBUTION_TYPE)
                WHEN 19 THEN TO_CHAR(l1.PO_ENTITY_CODE)
                WHEN 20 THEN TO_CHAR(l1.PO_FIRST_DIST_ID)
                WHEN 21 THEN TO_CHAR(l1.PO_FIRST_SYS_TRANS_ID)
                WHEN 22 THEN TO_CHAR(l1.PO_SECOND_DIST_ID)
                WHEN 23 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
                WHEN 24 THEN TO_CHAR(l1.LINE_TYPE_NAME)
                WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
                WHEN 26 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
                WHEN 27 THEN TO_CHAR(l1.ENTERED_AMT)
                WHEN 28 THEN TO_CHAR(l1.CURRENCY_CODE)
                WHEN 29 THEN TO_CHAR(l1.ACCOUNTED_AMT)
                WHEN 30 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
                WHEN 31 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
                WHEN 32 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
                WHEN 33 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
                WHEN 34 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
                WHEN 35 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
                WHEN 36 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
                WHEN 37 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
                WHEN 38 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
                WHEN 39 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
                WHEN 40 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
                WHEN 41 THEN TO_CHAR(l1.PA_APPLICATION_ID)
                WHEN 42 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
                WHEN 43 THEN TO_CHAR(l1.PA_ENTITY_CODE)
                WHEN 44 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
                WHEN 45 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
                WHEN 46 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
                          1011404
                         ,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                         ,'EXPENDITURE_ORGANIZATION_ID'
                         ,'S'
                         ,201)
                WHEN 8 THEN fvl14.meaning
                
                ELSE null
              END               source_meaning
         FROM  xla_events_gt     xet  
        , PA_XLA_BC_PKT_PO_DETAIL_V  l1
        , PA_XLA_PROJECT_REF_V  l3
        , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
            , (select rownum r from all_objects where rownum <= 46 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 l1.event_id          = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  
)
;

Line: 54798

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

Line: 54807

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

Line: 54828

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_88');

Line: 54829

END insert_sources_88;

Line: 55024

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE_BURDEN
    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 
  , h2.GL_DATE    source_79
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_PO_HEADER_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 55064

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE_BURDEN
    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
 , l1.LINE_NUMBER  
  , l3.PROJECT_NAME    source_3
  , l4.TASK_NAME    source_4
  , l1.EXPENDITURE_ORGANIZATION_ID    source_5
  , l1.EXPENDITURE_TYPE    source_6
  , l1.DOCUMENT_TYPE    source_9
  , l1.BUDGET_ACCOUNT    source_11
  , l1.MAIN_OR_BACKING_CODE    source_13
  , l1.BURDEN_COST_FLAG    source_14
  , fvl14.meaning   source_14_meaning
  , l3.PROJ_BURDEN_DISPLAY_METHOD    source_15
  , l1.ACCOUNTING_REVERSAL_FLAG    source_16
  , l1.ALLOC_TO_APPLN_ID    source_17
  , l1.ALLOC_TO_DIST_TYPE    source_18
  , l1.ALLOC_TO_ENTITY_CODE    source_19
  , l1.ALLOC_TO_FIRST_DIST_ID    source_20
  , l1.ALLOC_TO_FIRST_SYS_TRANS_ID    source_21
  , l1.ALLOC_TO_SECOND_DIST_ID    source_22
  , l1.PO_APPLICATION_ID    source_23
  , l1.PO_DISTRIBUTION_TYPE    source_24
  , l1.PO_ENTITY_CODE    source_25
  , l1.PO_FIRST_DIST_ID    source_26
  , l1.PO_FIRST_SYS_TRANS_ID    source_27
  , l1.PO_SECOND_DIST_ID    source_28
  , l1.PO_DISTRIBUTION_ID    source_29
  , l1.LINE_TYPE_NAME    source_30
  , l1.ENC_UPG_CR_ACCT_CLASS    source_31
  , l1.ENC_UPG_CR_ACCOUNT    source_32
  , l1.ENTERED_AMT    source_33
  , l1.CURRENCY_CODE    source_34
  , l1.ACCOUNTED_AMT    source_35
  , l1.ENC_UPG_DR_ACCT_CLASS    source_36
  , l1.ENC_UPG_DR_ACCOUNT    source_37
  , l1.USE_ENC_UPG_ATTRIB_FLAG    source_38
  , l1.ENC_UPG_CR_ENC_TYPE_ID    source_39
  , l1.ENC_UPG_DR_ENC_TYPE_ID    source_40
  , l1.REQ_APPLICATION_ID    source_41
  , l1.REQ_DISTRIBUTION_TYPE    source_42
  , l1.REQ_ENTITY_CODE    source_43
  , l1.REQ_FIRST_DIST_ID    source_44
  , l1.REQ_FIRST_SYS_TRANS_ID    source_45
  , l1.REQ_SECOND_DIST_ID    source_46
  , l1.PA_APPLICATION_ID    source_68
  , l1.PA_DISTRIBUTION_TYPE    source_69
  , l1.PA_ENTITY_CODE    source_70
  , l1.PA_FIRST_DIST_ID    source_71
  , l1.PA_FIRST_SYS_TRANS_ID    source_72
  , l1.PA_SECOND_DIST_ID    source_73
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_PO_DETAIL_V  l1
  , PA_XLA_PROJECT_REF_V  l3
  , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
 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 l1.event_id      = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  ;

Line: 55179

g_array_event.DELETE;

Line: 55382

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 55403

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 56860

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 56868

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 56924

PROCEDURE insert_sources_89(
                                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: 56939

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_89';

Line: 56944

         (p_msg      => 'BEGIN of insert_sources_89'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 56951

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

Line: 56971

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 'GL_DATE' 
                WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.DOCUMENT_TYPE)
                WHEN 2 THEN TO_CHAR(h2.REQ_NUMBER)
                WHEN 3 THEN TO_CHAR(h2.REQ_ID)
                WHEN 4 THEN TO_CHAR(h2.GL_DATE)
                WHEN 5 THEN TO_CHAR(h2.ENCUMBRANCE_TYPE_ID)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PO_REQ_EXTRACT_HEADER_V  h2
             ,(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 h2.event_id = xet.event_id

)
;

Line: 57080

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

Line: 57090

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

Line: 57279

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

Line: 57288

         (p_msg      => 'END of insert_sources_89'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 57309

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_89');

Line: 57310

END insert_sources_89;

Line: 57462

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 
  , h2.DOCUMENT_TYPE    source_9
  , h2.REQ_NUMBER    source_10
  , h2.REQ_ID    source_76
  , h2.GL_DATE    source_79
  , h2.ENCUMBRANCE_TYPE_ID    source_80
  FROM xla_events_gt     xet 
  , PO_REQ_EXTRACT_HEADER_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 57506

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
 , l1.LINE_NUMBER  
  , l1.JE_LINE_DESCRIPTION    source_7
  , l1.BUDGET_ACCOUNT    source_11
  , l1.MAIN_OR_BACKING_CODE    source_13
  , l1.ACCOUNTING_REVERSAL_FLAG    source_16
  , l1.ENTERED_AMT    source_33
  , l1.CURRENCY_CODE    source_34
  , l1.ACCOUNTED_AMT    source_35
  , l1.REQ_DISTRIBUTION_ID    source_47
  , l1.APPLIED_TO_APPL_ID    source_53
  , l1.APPLIED_TO_DIST_LINK_TYPE    source_54
  , l1.APPLIED_TO_ENTITY_CODE    source_55
  , l1.APPLIED_TO_DIST_ID_1    source_56
  , l1.APPLIED_TO_HEADER_ID_1    source_57
  , l1.DISTRIBUTION_LINK_TYPE    source_58
  , l1.JFMIP_REFERENCE    source_60
  , l3.CURRENCY_CONVERSION_DATE    source_62
  , l3.CURRENCY_CONVERSION_RATE    source_63
  , l3.CURRENCY_CONVERSION_TYPE    source_64
  , l1.ADJUSTMENT_STATUS    source_75
  , l1.REQ_ENCUM_UPG_OPTION    source_77
  , l1.REQ_UPG_ENC_TYPE_ID    source_78
  FROM xla_events_gt     xet 
  , PO_REQ_EXTRACT_DETAIL_V  l1
  , PO_REQ_LINES_REF_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 l1.event_id      = xet.event_id
 AND l1.req_line_id = l3.req_line_id (+) ;

Line: 57589

g_array_event.DELETE;

Line: 57812

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 57833

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 58225

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 58233

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 58289

PROCEDURE insert_sources_90(
                                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_BURDEN_ALL';

Line: 58304

      l_log_module := C_DEFAULT_MODULE||'.insert_sources_90';

Line: 58309

         (p_msg      => 'BEGIN of insert_sources_90'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 58316

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

Line: 58336

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 'PA_XLA_BC_PKT_REQ_HEADER_V' 
                
               ELSE null
              END                           object_name
            , CASE r
                WHEN 1 THEN 'HEADER' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'GL_DATE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(h2.GL_DATE)
                
                ELSE null
              END                           source_value
            , null              source_meaning
         FROM xla_events_gt     xet  
      , PA_XLA_BC_PKT_REQ_HEADER_V  h2
             ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
         WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
           AND xet.event_class_code = C_EVENT_CLASS_CODE
              AND h2.event_id = xet.event_id

)
;

Line: 58425

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

Line: 58435

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
            , l1.line_number                 line_number
            , CASE r
               WHEN 1 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 2 THEN 'PA_XLA_TASK_REF_V' 
                WHEN 3 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 4 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 5 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 6 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 7 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 8 THEN 'PA_XLA_PROJECT_REF_V' 
                WHEN 9 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 10 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 11 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 12 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 13 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 14 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 15 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 16 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 17 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 18 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 19 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 20 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 21 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 22 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 23 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 24 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 25 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 26 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 27 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 28 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 29 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 30 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 31 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 32 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 33 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 34 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 35 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 36 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 37 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 38 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 39 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V' 
                WHEN 40 THEN 'PA_XLA_BC_PKT_REQ_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' 
                WHEN 24 THEN 'LINE' 
                WHEN 25 THEN 'LINE' 
                WHEN 26 THEN 'LINE' 
                WHEN 27 THEN 'LINE' 
                WHEN 28 THEN 'LINE' 
                WHEN 29 THEN 'LINE' 
                WHEN 30 THEN 'LINE' 
                WHEN 31 THEN 'LINE' 
                WHEN 32 THEN 'LINE' 
                WHEN 33 THEN 'LINE' 
                WHEN 34 THEN 'LINE' 
                WHEN 35 THEN 'LINE' 
                WHEN 36 THEN 'LINE' 
                WHEN 37 THEN 'LINE' 
                WHEN 38 THEN 'LINE' 
                WHEN 39 THEN 'LINE' 
                WHEN 40 THEN 'LINE' 
                
                ELSE null
              END                           object_type_code
            , CASE r
                WHEN 1 THEN '275' 
                WHEN 2 THEN '275' 
                WHEN 3 THEN '201' 
                WHEN 4 THEN '201' 
                WHEN 5 THEN '201' 
                WHEN 6 THEN '201' 
                WHEN 7 THEN '201' 
                WHEN 8 THEN '275' 
                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' 
                WHEN 24 THEN '201' 
                WHEN 25 THEN '201' 
                WHEN 26 THEN '201' 
                WHEN 27 THEN '201' 
                WHEN 28 THEN '201' 
                WHEN 29 THEN '201' 
                WHEN 30 THEN '201' 
                WHEN 31 THEN '201' 
                WHEN 32 THEN '201' 
                WHEN 33 THEN '201' 
                WHEN 34 THEN '201' 
                WHEN 35 THEN '201' 
                WHEN 36 THEN '201' 
                WHEN 37 THEN '201' 
                WHEN 38 THEN '201' 
                WHEN 39 THEN '201' 
                WHEN 40 THEN '201' 
                
                ELSE null
              END                           source_application_id
            , 'S'             source_type_code
            , CASE r
                WHEN 1 THEN 'PROJECT_NAME' 
                WHEN 2 THEN 'TASK_NAME' 
                WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID' 
                WHEN 4 THEN 'EXPENDITURE_TYPE' 
                WHEN 5 THEN 'BUDGET_ACCOUNT' 
                WHEN 6 THEN 'MAIN_OR_BACKING_CODE' 
                WHEN 7 THEN 'BURDEN_COST_FLAG' 
                WHEN 8 THEN 'PROJ_BURDEN_DISPLAY_METHOD' 
                WHEN 9 THEN 'ACCOUNTING_REVERSAL_FLAG' 
                WHEN 10 THEN 'ALLOC_TO_APPLN_ID' 
                WHEN 11 THEN 'ALLOC_TO_DIST_TYPE' 
                WHEN 12 THEN 'ALLOC_TO_ENTITY_CODE' 
                WHEN 13 THEN 'ALLOC_TO_FIRST_DIST_ID' 
                WHEN 14 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID' 
                WHEN 15 THEN 'ALLOC_TO_SECOND_DIST_ID' 
                WHEN 16 THEN 'LINE_TYPE_NAME' 
                WHEN 17 THEN 'ENC_UPG_CR_ACCT_CLASS' 
                WHEN 18 THEN 'ENC_UPG_CR_ACCOUNT' 
                WHEN 19 THEN 'ENTERED_AMT' 
                WHEN 20 THEN 'CURRENCY_CODE' 
                WHEN 21 THEN 'ACCOUNTED_AMT' 
                WHEN 22 THEN 'ENC_UPG_DR_ACCT_CLASS' 
                WHEN 23 THEN 'ENC_UPG_DR_ACCOUNT' 
                WHEN 24 THEN 'USE_ENC_UPG_ATTRIB_FLAG' 
                WHEN 25 THEN 'ENC_UPG_CR_ENC_TYPE_ID' 
                WHEN 26 THEN 'ENC_UPG_DR_ENC_TYPE_ID' 
                WHEN 27 THEN 'REQ_APPLICATION_ID' 
                WHEN 28 THEN 'REQ_DISTRIBUTION_TYPE' 
                WHEN 29 THEN 'REQ_ENTITY_CODE' 
                WHEN 30 THEN 'REQ_FIRST_DIST_ID' 
                WHEN 31 THEN 'REQ_FIRST_SYS_TRANS_ID' 
                WHEN 32 THEN 'REQ_SECOND_DIST_ID' 
                WHEN 33 THEN 'REQ_DISTRIBUTION_ID' 
                WHEN 34 THEN 'PA_APPLICATION_ID' 
                WHEN 35 THEN 'PA_DISTRIBUTION_TYPE' 
                WHEN 36 THEN 'PA_ENTITY_CODE' 
                WHEN 37 THEN 'PA_FIRST_DIST_ID' 
                WHEN 38 THEN 'PA_FIRST_SYS_TRANS_ID' 
                WHEN 39 THEN 'PA_SECOND_DIST_ID' 
                WHEN 40 THEN 'DOCUMENT_DISTRIBUTION_TYPE' 
                
                ELSE null
              END                           source_code
            , CASE r
                WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
                WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
                WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
                WHEN 5 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
                WHEN 6 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
                WHEN 7 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
                WHEN 8 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
                WHEN 9 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
                WHEN 10 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
                WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
                WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
                WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
                WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
                WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_SECOND_DIST_ID)
                WHEN 16 THEN TO_CHAR(l1.LINE_TYPE_NAME)
                WHEN 17 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
                WHEN 18 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
                WHEN 19 THEN TO_CHAR(l1.ENTERED_AMT)
                WHEN 20 THEN TO_CHAR(l1.CURRENCY_CODE)
                WHEN 21 THEN TO_CHAR(l1.ACCOUNTED_AMT)
                WHEN 22 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
                WHEN 23 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
                WHEN 24 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
                WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
                WHEN 26 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
                WHEN 27 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
                WHEN 28 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
                WHEN 29 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
                WHEN 30 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
                WHEN 31 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
                WHEN 32 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
                WHEN 33 THEN TO_CHAR(l1.REQ_DISTRIBUTION_ID)
                WHEN 34 THEN TO_CHAR(l1.PA_APPLICATION_ID)
                WHEN 35 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
                WHEN 36 THEN TO_CHAR(l1.PA_ENTITY_CODE)
                WHEN 37 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
                WHEN 38 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
                WHEN 39 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
                WHEN 40 THEN TO_CHAR(l1.DOCUMENT_DISTRIBUTION_TYPE)
                
                ELSE null
              END                           source_value
            , CASE r
                WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
                          1011404
                         ,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
                         ,'EXPENDITURE_ORGANIZATION_ID'
                         ,'S'
                         ,201)
                WHEN 7 THEN fvl14.meaning
                
                ELSE null
              END               source_meaning
         FROM  xla_events_gt     xet  
        , PA_XLA_BC_PKT_REQ_DETAIL_V  l1
        , PA_XLA_PROJECT_REF_V  l3
        , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
            , (select rownum r from all_objects where rownum <= 40 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 l1.event_id          = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  
)
;

Line: 58735

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

Line: 58744

         (p_msg      => 'END of insert_sources_90'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 58765

           (p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_90');

Line: 58766

END insert_sources_90;

Line: 58949

SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION_BURDEN
    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 
  , h2.GL_DATE    source_79
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_REQ_HEADER_V  h2
 WHERE xet.event_date between p_pad_start_date and p_pad_end_date
   and xet.event_class_code = C_EVENT_CLASS_CODE
   and xet.event_status_code <> 'N'  AND h2.event_id = xet.event_id

 ORDER BY event_id
;

Line: 58989

SELECT  /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION_BURDEN
    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
 , l1.LINE_NUMBER  
  , l3.PROJECT_NAME    source_3
  , l4.TASK_NAME    source_4
  , l1.EXPENDITURE_ORGANIZATION_ID    source_5
  , l1.EXPENDITURE_TYPE    source_6
  , l1.BUDGET_ACCOUNT    source_11
  , l1.MAIN_OR_BACKING_CODE    source_13
  , l1.BURDEN_COST_FLAG    source_14
  , fvl14.meaning   source_14_meaning
  , l3.PROJ_BURDEN_DISPLAY_METHOD    source_15
  , l1.ACCOUNTING_REVERSAL_FLAG    source_16
  , l1.ALLOC_TO_APPLN_ID    source_17
  , l1.ALLOC_TO_DIST_TYPE    source_18
  , l1.ALLOC_TO_ENTITY_CODE    source_19
  , l1.ALLOC_TO_FIRST_DIST_ID    source_20
  , l1.ALLOC_TO_FIRST_SYS_TRANS_ID    source_21
  , l1.ALLOC_TO_SECOND_DIST_ID    source_22
  , l1.LINE_TYPE_NAME    source_30
  , l1.ENC_UPG_CR_ACCT_CLASS    source_31
  , l1.ENC_UPG_CR_ACCOUNT    source_32
  , l1.ENTERED_AMT    source_33
  , l1.CURRENCY_CODE    source_34
  , l1.ACCOUNTED_AMT    source_35
  , l1.ENC_UPG_DR_ACCT_CLASS    source_36
  , l1.ENC_UPG_DR_ACCOUNT    source_37
  , l1.USE_ENC_UPG_ATTRIB_FLAG    source_38
  , l1.ENC_UPG_CR_ENC_TYPE_ID    source_39
  , l1.ENC_UPG_DR_ENC_TYPE_ID    source_40
  , l1.REQ_APPLICATION_ID    source_41
  , l1.REQ_DISTRIBUTION_TYPE    source_42
  , l1.REQ_ENTITY_CODE    source_43
  , l1.REQ_FIRST_DIST_ID    source_44
  , l1.REQ_FIRST_SYS_TRANS_ID    source_45
  , l1.REQ_SECOND_DIST_ID    source_46
  , l1.REQ_DISTRIBUTION_ID    source_47
  , l1.PA_APPLICATION_ID    source_68
  , l1.PA_DISTRIBUTION_TYPE    source_69
  , l1.PA_ENTITY_CODE    source_70
  , l1.PA_FIRST_DIST_ID    source_71
  , l1.PA_FIRST_SYS_TRANS_ID    source_72
  , l1.PA_SECOND_DIST_ID    source_73
  , l1.DOCUMENT_DISTRIBUTION_TYPE    source_74
  FROM xla_events_gt     xet 
  , PA_XLA_BC_PKT_REQ_DETAIL_V  l1
  , PA_XLA_PROJECT_REF_V  l3
  , PA_XLA_TASK_REF_V  l4
  , fnd_lookup_values    fvl14
 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 l1.event_id      = xet.event_id
 AND l3.project_id=l1.project_id AND l4.task_id=l1.task_id   AND fvl14.lookup_type(+)         = 'BC_PKT_BURDEN_COST_FLAG'
  AND fvl14.lookup_code(+)         = l1.BURDEN_COST_FLAG
  AND fvl14.view_application_id(+) = 275
  AND fvl14.language(+)            = USERENV('LANG')
  ;

Line: 59098

g_array_event.DELETE;

Line: 59301

XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

Line: 59322

   l_result := XLA_AE_LINES_PKG.InsertLines;

Line: 60043

l_result := XLA_AE_LINES_PKG.InsertLines ;

Line: 60051

l_result := XLA_AE_HEADER_PKG.InsertHeaders ;

Line: 60175

         insert_sources_85(
                          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: 60209

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

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

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

Line: 60311

         insert_sources_89(
                          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: 60345

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