The following lines contain the word 'select', 'insert', 'update' or 'delete':
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
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';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_86';
(p_msg => 'BEGIN of insert_sources_86'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_TYPE'
WHEN 2 THEN 'PO_NUMBER'
WHEN 3 THEN 'PO_HEADER_ID'
WHEN 4 THEN 'ENCUMBRANCE_TYPE_ID'
WHEN 5 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h4.PO_TYPE)
WHEN 2 THEN TO_CHAR(h4.PO_NUMBER)
WHEN 3 THEN TO_CHAR(h4.PO_HEADER_ID)
WHEN 4 THEN TO_CHAR(h4.ENCUMBRANCE_TYPE_ID)
WHEN 5 THEN TO_CHAR(h4.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h4
,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h4.event_id = xet.event_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l3.line_number line_number
, CASE r
WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 2 THEN 'FV_XLA_PO_REF_V'
WHEN 3 THEN 'FV_XLA_PO_REF_V'
WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 5 THEN 'FV_XLA_PO_REF_V'
WHEN 6 THEN 'FV_XLA_PO_REF_V'
WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 21 THEN 'FV_XLA_PO_REF_V'
WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 26 THEN 'PO_DISTS_REF_V'
WHEN 27 THEN 'PO_DISTS_REF_V'
WHEN 28 THEN 'PO_DISTS_REF_V'
WHEN 29 THEN 'FV_XLA_PO_REF_V'
WHEN 30 THEN 'FV_XLA_PO_REF_V'
WHEN 31 THEN 'FV_XLA_PO_REF_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '201'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '8901'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
WHEN 26 THEN '201'
WHEN 27 THEN '201'
WHEN 28 THEN '201'
WHEN 29 THEN '8901'
WHEN 30 THEN '8901'
WHEN 31 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 4 THEN 'BUDGET_ACCOUNT'
WHEN 5 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 6 THEN 'FEDERAL_NET_PYA_ADJ_AMT'
WHEN 7 THEN 'MAIN_OR_BACKING_CODE'
WHEN 8 THEN 'PO_DISTRIBUTION_TYPE'
WHEN 9 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 11 THEN 'PO_DISTRIBUTION_ID'
WHEN 12 THEN 'APPLIED_TO_APPL_ID'
WHEN 13 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 14 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 15 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 16 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 17 THEN 'ENTERED_AMT'
WHEN 18 THEN 'CURRENCY_CODE'
WHEN 19 THEN 'ACCOUNTED_AMT'
WHEN 20 THEN 'PO_ENCUM_UPG_OPTION'
WHEN 21 THEN 'FEDERAL_UNANTICIPATED_AMT'
WHEN 22 THEN 'JFMIP_REFERENCE'
WHEN 23 THEN 'PO_UPG_ENC_TYPE_ID'
WHEN 24 THEN 'ALLOC_TO_DISTRIBUTION_TYPE'
WHEN 25 THEN 'ALLOC_TO_DIST_ID_1'
WHEN 26 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 27 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 28 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 29 THEN 'FEDERAL_PYA_DIFF_AMT'
WHEN 30 THEN 'FEDERAL_ANTICIPATED_AMT'
WHEN 31 THEN 'FEDERAL_PYA_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 4 THEN TO_CHAR(l3.BUDGET_ACCOUNT)
WHEN 5 THEN TO_CHAR(l1.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 6 THEN TO_CHAR(l1.FEDERAL_NET_PYA_ADJ_AMT)
WHEN 7 THEN TO_CHAR(l3.MAIN_OR_BACKING_CODE)
WHEN 8 THEN TO_CHAR(l3.PO_DISTRIBUTION_TYPE)
WHEN 9 THEN TO_CHAR(l3.ACCOUNTING_REVERSAL_FLAG)
WHEN 10 THEN TO_CHAR(l3.DISTRIBUTION_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l3.PO_DISTRIBUTION_ID)
WHEN 12 THEN TO_CHAR(l3.APPLIED_TO_APPL_ID)
WHEN 13 THEN TO_CHAR(l3.APPLIED_TO_DIST_LINK_TYPE)
WHEN 14 THEN TO_CHAR(l3.APPLIED_TO_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l3.APPLIED_TO_DIST_ID_1)
WHEN 16 THEN TO_CHAR(l3.APPLIED_TO_HEADER_ID_1)
WHEN 17 THEN TO_CHAR(l3.ENTERED_AMT)
WHEN 18 THEN TO_CHAR(l3.CURRENCY_CODE)
WHEN 19 THEN TO_CHAR(l3.ACCOUNTED_AMT)
WHEN 20 THEN TO_CHAR(l3.PO_ENCUM_UPG_OPTION)
WHEN 21 THEN TO_CHAR(l1.FEDERAL_UNANTICIPATED_AMT)
WHEN 22 THEN TO_CHAR(l3.JFMIP_REFERENCE)
WHEN 23 THEN TO_CHAR(l3.PO_UPG_ENC_TYPE_ID)
WHEN 24 THEN TO_CHAR(l3.ALLOC_TO_DISTRIBUTION_TYPE)
WHEN 25 THEN TO_CHAR(l3.ALLOC_TO_DIST_ID_1)
WHEN 26 THEN TO_CHAR(l2.CURRENCY_CONVERSION_DATE)
WHEN 27 THEN TO_CHAR(l2.CURRENCY_CONVERSION_RATE)
WHEN 28 THEN TO_CHAR(l2.CURRENCY_CONVERSION_TYPE)
WHEN 29 THEN TO_CHAR(l1.FEDERAL_PYA_DIFF_AMT)
WHEN 30 THEN TO_CHAR(l1.FEDERAL_ANTICIPATED_AMT)
WHEN 31 THEN TO_CHAR(l1.FEDERAL_PYA_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_DISTS_REF_V l2
, PO_EXTRACT_DETAIL_V l3
, (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l1.federal_event_id (+) = l3.event_id and l1.federal_line_number (+) = l3.line_number AND l3.po_distribution_id = l2.po_distribution_id (+) and l3.po_distribution_type = l2.po_distribution_type (+)
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_86'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_86');
END insert_sources_86;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h4.PO_TYPE source_1
, h4.PO_NUMBER source_2
, h4.PO_HEADER_ID source_20
, h4.ENCUMBRANCE_TYPE_ID source_48
, h4.GL_DATE source_49
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h4
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h4.event_id = xet.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l3.JE_LINE_DESCRIPTION source_3
, l1.FEDERAL_FUND_CATEGORY source_7
, l1.FEDERAL_FUND_EXPIRED_STATUS source_8
, l3.BUDGET_ACCOUNT source_9
, l1.FEDERAL_PRIOR_YEAR_FLAG source_10
, l1.FEDERAL_NET_PYA_ADJ_AMT source_11
, l3.MAIN_OR_BACKING_CODE source_13
, l3.PO_DISTRIBUTION_TYPE source_14
, l3.ACCOUNTING_REVERSAL_FLAG source_15
, l3.DISTRIBUTION_LINK_TYPE source_17
, l3.PO_DISTRIBUTION_ID source_19
, l3.APPLIED_TO_APPL_ID source_21
, l3.APPLIED_TO_DIST_LINK_TYPE source_22
, l3.APPLIED_TO_ENTITY_CODE source_23
, l3.APPLIED_TO_DIST_ID_1 source_24
, l3.APPLIED_TO_HEADER_ID_1 source_25
, l3.ENTERED_AMT source_26
, l3.CURRENCY_CODE source_27
, l3.ACCOUNTED_AMT source_28
, l3.PO_ENCUM_UPG_OPTION source_29
, l1.FEDERAL_UNANTICIPATED_AMT source_30
, l3.JFMIP_REFERENCE source_31
, l3.PO_UPG_ENC_TYPE_ID source_32
, l3.ALLOC_TO_DISTRIBUTION_TYPE source_33
, l3.ALLOC_TO_DIST_ID_1 source_34
, l2.CURRENCY_CONVERSION_DATE source_35
, l2.CURRENCY_CONVERSION_RATE source_36
, l2.CURRENCY_CONVERSION_TYPE source_37
, l1.FEDERAL_PYA_DIFF_AMT source_38
, l1.FEDERAL_ANTICIPATED_AMT source_39
, l1.FEDERAL_PYA_AMT source_40
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_DISTS_REF_V l2
, PO_EXTRACT_DETAIL_V l3
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l1.Federal_event_id (+) = l3.event_id AND l1.Federal_Line_Number (+) = l3.Line_Number AND l3.po_distribution_id = l2.po_distribution_id (+) AND l3.po_distribution_type = l2.po_distribution_type (+) ;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
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';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_87';
(p_msg => 'BEGIN of insert_sources_87'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'PO_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_RELEASES_REF_V'
WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
WHEN 6 THEN 'PO_EXTRACT_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_TYPE'
WHEN 2 THEN 'PO_NUMBER'
WHEN 3 THEN 'PO_RELEASE_NUMBER'
WHEN 4 THEN 'PO_RELEASE_ID'
WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID'
WHEN 6 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h4.PO_TYPE)
WHEN 2 THEN TO_CHAR(h4.PO_NUMBER)
WHEN 3 THEN TO_CHAR(h5.PO_RELEASE_NUMBER)
WHEN 4 THEN TO_CHAR(h4.PO_RELEASE_ID)
WHEN 5 THEN TO_CHAR(h4.ENCUMBRANCE_TYPE_ID)
WHEN 6 THEN TO_CHAR(h4.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h4
, PO_RELEASES_REF_V h5
,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h4.event_id = xet.event_id
AND h4.po_release_id = h5.po_release_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l3.line_number line_number
, CASE r
WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 2 THEN 'FV_XLA_PO_REF_V'
WHEN 3 THEN 'FV_XLA_PO_REF_V'
WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 5 THEN 'FV_XLA_PO_REF_V'
WHEN 6 THEN 'FV_XLA_PO_REF_V'
WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 20 THEN 'FV_XLA_PO_REF_V'
WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 25 THEN 'PO_DISTS_REF_V'
WHEN 26 THEN 'PO_DISTS_REF_V'
WHEN 27 THEN 'PO_DISTS_REF_V'
WHEN 28 THEN 'FV_XLA_PO_REF_V'
WHEN 29 THEN 'FV_XLA_PO_REF_V'
WHEN 30 THEN 'FV_XLA_PO_REF_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '201'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '8901'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
WHEN 26 THEN '201'
WHEN 27 THEN '201'
WHEN 28 THEN '8901'
WHEN 29 THEN '8901'
WHEN 30 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 4 THEN 'BUDGET_ACCOUNT'
WHEN 5 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 6 THEN 'FEDERAL_NET_PYA_ADJ_AMT'
WHEN 7 THEN 'MAIN_OR_BACKING_CODE'
WHEN 8 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 9 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 10 THEN 'PO_DISTRIBUTION_ID'
WHEN 11 THEN 'APPLIED_TO_APPL_ID'
WHEN 12 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 13 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 14 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 15 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 16 THEN 'ENTERED_AMT'
WHEN 17 THEN 'CURRENCY_CODE'
WHEN 18 THEN 'ACCOUNTED_AMT'
WHEN 19 THEN 'PO_ENCUM_UPG_OPTION'
WHEN 20 THEN 'FEDERAL_UNANTICIPATED_AMT'
WHEN 21 THEN 'JFMIP_REFERENCE'
WHEN 22 THEN 'PO_UPG_ENC_TYPE_ID'
WHEN 23 THEN 'ALLOC_TO_DISTRIBUTION_TYPE'
WHEN 24 THEN 'ALLOC_TO_DIST_ID_1'
WHEN 25 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 26 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 27 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 28 THEN 'FEDERAL_PYA_DIFF_AMT'
WHEN 29 THEN 'FEDERAL_ANTICIPATED_AMT'
WHEN 30 THEN 'FEDERAL_PYA_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 4 THEN TO_CHAR(l3.BUDGET_ACCOUNT)
WHEN 5 THEN TO_CHAR(l1.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 6 THEN TO_CHAR(l1.FEDERAL_NET_PYA_ADJ_AMT)
WHEN 7 THEN TO_CHAR(l3.MAIN_OR_BACKING_CODE)
WHEN 8 THEN TO_CHAR(l3.ACCOUNTING_REVERSAL_FLAG)
WHEN 9 THEN TO_CHAR(l3.DISTRIBUTION_LINK_TYPE)
WHEN 10 THEN TO_CHAR(l3.PO_DISTRIBUTION_ID)
WHEN 11 THEN TO_CHAR(l3.APPLIED_TO_APPL_ID)
WHEN 12 THEN TO_CHAR(l3.APPLIED_TO_DIST_LINK_TYPE)
WHEN 13 THEN TO_CHAR(l3.APPLIED_TO_ENTITY_CODE)
WHEN 14 THEN TO_CHAR(l3.APPLIED_TO_DIST_ID_1)
WHEN 15 THEN TO_CHAR(l3.APPLIED_TO_HEADER_ID_1)
WHEN 16 THEN TO_CHAR(l3.ENTERED_AMT)
WHEN 17 THEN TO_CHAR(l3.CURRENCY_CODE)
WHEN 18 THEN TO_CHAR(l3.ACCOUNTED_AMT)
WHEN 19 THEN TO_CHAR(l3.PO_ENCUM_UPG_OPTION)
WHEN 20 THEN TO_CHAR(l1.FEDERAL_UNANTICIPATED_AMT)
WHEN 21 THEN TO_CHAR(l3.JFMIP_REFERENCE)
WHEN 22 THEN TO_CHAR(l3.PO_UPG_ENC_TYPE_ID)
WHEN 23 THEN TO_CHAR(l3.ALLOC_TO_DISTRIBUTION_TYPE)
WHEN 24 THEN TO_CHAR(l3.ALLOC_TO_DIST_ID_1)
WHEN 25 THEN TO_CHAR(l2.CURRENCY_CONVERSION_DATE)
WHEN 26 THEN TO_CHAR(l2.CURRENCY_CONVERSION_RATE)
WHEN 27 THEN TO_CHAR(l2.CURRENCY_CONVERSION_TYPE)
WHEN 28 THEN TO_CHAR(l1.FEDERAL_PYA_DIFF_AMT)
WHEN 29 THEN TO_CHAR(l1.FEDERAL_ANTICIPATED_AMT)
WHEN 30 THEN TO_CHAR(l1.FEDERAL_PYA_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_DISTS_REF_V l2
, PO_EXTRACT_DETAIL_V l3
, (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l1.federal_event_id (+) = l3.event_id and l3.line_number = l1.federal_line_number (+) AND l3.po_distribution_id = l2.po_distribution_id (+) and l3.po_distribution_type = l2.po_distribution_type (+)
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_87'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_87');
END insert_sources_87;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h4.PO_TYPE source_1
, h4.PO_NUMBER source_2
, h5.PO_RELEASE_NUMBER source_4
, h4.PO_RELEASE_ID source_41
, h4.ENCUMBRANCE_TYPE_ID source_48
, h4.GL_DATE source_49
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h4
, PO_RELEASES_REF_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h4.event_id = xet.event_id
AND h4.po_release_id = h5.po_release_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l3.JE_LINE_DESCRIPTION source_3
, l1.FEDERAL_FUND_CATEGORY source_7
, l1.FEDERAL_FUND_EXPIRED_STATUS source_8
, l3.BUDGET_ACCOUNT source_9
, l1.FEDERAL_PRIOR_YEAR_FLAG source_10
, l1.FEDERAL_NET_PYA_ADJ_AMT source_11
, l3.MAIN_OR_BACKING_CODE source_13
, l3.ACCOUNTING_REVERSAL_FLAG source_15
, l3.DISTRIBUTION_LINK_TYPE source_17
, l3.PO_DISTRIBUTION_ID source_19
, l3.APPLIED_TO_APPL_ID source_21
, l3.APPLIED_TO_DIST_LINK_TYPE source_22
, l3.APPLIED_TO_ENTITY_CODE source_23
, l3.APPLIED_TO_DIST_ID_1 source_24
, l3.APPLIED_TO_HEADER_ID_1 source_25
, l3.ENTERED_AMT source_26
, l3.CURRENCY_CODE source_27
, l3.ACCOUNTED_AMT source_28
, l3.PO_ENCUM_UPG_OPTION source_29
, l1.FEDERAL_UNANTICIPATED_AMT source_30
, l3.JFMIP_REFERENCE source_31
, l3.PO_UPG_ENC_TYPE_ID source_32
, l3.ALLOC_TO_DISTRIBUTION_TYPE source_33
, l3.ALLOC_TO_DIST_ID_1 source_34
, l2.CURRENCY_CONVERSION_DATE source_35
, l2.CURRENCY_CONVERSION_RATE source_36
, l2.CURRENCY_CONVERSION_TYPE source_37
, l1.FEDERAL_PYA_DIFF_AMT source_38
, l1.FEDERAL_ANTICIPATED_AMT source_39
, l1.FEDERAL_PYA_AMT source_40
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_DISTS_REF_V l2
, PO_EXTRACT_DETAIL_V l3
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l1.federal_event_id (+) = l3.event_id AND l3.line_number = l1.federal_line_number (+) AND l3.po_distribution_id = l2.po_distribution_id (+) AND l3.po_distribution_type = l2.po_distribution_type (+) ;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
PROCEDURE insert_sources_88(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'REQUISITION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_88';
(p_msg => 'BEGIN of insert_sources_88'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_REQ_EXTRACT_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOCUMENT_TYPE'
WHEN 2 THEN 'REQ_NUMBER'
WHEN 3 THEN 'REQ_ID'
WHEN 4 THEN 'ENCUMBRANCE_TYPE_ID'
WHEN 5 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.DOCUMENT_TYPE)
WHEN 2 THEN TO_CHAR(h3.REQ_NUMBER)
WHEN 3 THEN TO_CHAR(h3.REQ_ID)
WHEN 4 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
WHEN 5 THEN TO_CHAR(h3.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_REQ_EXTRACT_HEADER_V h3
,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 2 THEN 'FV_XLA_PO_REF_V'
WHEN 3 THEN 'FV_XLA_PO_REF_V'
WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 17 THEN 'PO_REQ_LINES_REF_V'
WHEN 18 THEN 'PO_REQ_LINES_REF_V'
WHEN 19 THEN 'PO_REQ_LINES_REF_V'
WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 21 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 22 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 23 THEN 'PO_REQ_EXTRACT_DETAIL_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 4 THEN 'BUDGET_ACCOUNT'
WHEN 5 THEN 'MAIN_OR_BACKING_CODE'
WHEN 6 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 7 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 8 THEN 'APPLIED_TO_APPL_ID'
WHEN 9 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 10 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 11 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 12 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 13 THEN 'ENTERED_AMT'
WHEN 14 THEN 'CURRENCY_CODE'
WHEN 15 THEN 'ACCOUNTED_AMT'
WHEN 16 THEN 'JFMIP_REFERENCE'
WHEN 17 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 18 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 19 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 20 THEN 'REQ_DISTRIBUTION_ID'
WHEN 21 THEN 'REQ_ENCUM_UPG_OPTION'
WHEN 22 THEN 'REQ_UPG_ENC_TYPE_ID'
WHEN 23 THEN 'ADJUSTMENT_STATUS'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l1.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 4 THEN TO_CHAR(l2.BUDGET_ACCOUNT)
WHEN 5 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
WHEN 6 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
WHEN 7 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
WHEN 8 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
WHEN 9 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
WHEN 10 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
WHEN 11 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
WHEN 13 THEN TO_CHAR(l2.ENTERED_AMT)
WHEN 14 THEN TO_CHAR(l2.CURRENCY_CODE)
WHEN 15 THEN TO_CHAR(l2.ACCOUNTED_AMT)
WHEN 16 THEN TO_CHAR(l2.JFMIP_REFERENCE)
WHEN 17 THEN TO_CHAR(l4.CURRENCY_CONVERSION_DATE)
WHEN 18 THEN TO_CHAR(l4.CURRENCY_CONVERSION_RATE)
WHEN 19 THEN TO_CHAR(l4.CURRENCY_CONVERSION_TYPE)
WHEN 20 THEN TO_CHAR(l2.REQ_DISTRIBUTION_ID)
WHEN 21 THEN TO_CHAR(l2.REQ_ENCUM_UPG_OPTION)
WHEN 22 THEN TO_CHAR(l2.REQ_UPG_ENC_TYPE_ID)
WHEN 23 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_REQ_EXTRACT_DETAIL_V l2
, PO_REQ_LINES_REF_V l4
, (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l2.event_id = xet.event_id
AND l1.federal_event_id (+) =l2.event_id and l1.federal_line_number (+) =l2.line_number AND l2.req_line_id = l4.req_line_id (+)
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_88'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000004_BC_PKG.insert_sources_88');
END insert_sources_88;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h3.DOCUMENT_TYPE source_5
, h3.REQ_NUMBER source_6
, h3.REQ_ID source_44
, h3.ENCUMBRANCE_TYPE_ID source_48
, h3.GL_DATE source_49
FROM xla_events_gt xet
, PO_REQ_EXTRACT_HEADER_V h3
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.JE_LINE_DESCRIPTION source_3
, l1.FEDERAL_FUND_CATEGORY source_7
, l1.FEDERAL_FUND_EXPIRED_STATUS source_8
, l2.BUDGET_ACCOUNT source_9
, l2.MAIN_OR_BACKING_CODE source_13
, l2.ACCOUNTING_REVERSAL_FLAG source_15
, l2.DISTRIBUTION_LINK_TYPE source_17
, l2.APPLIED_TO_APPL_ID source_21
, l2.APPLIED_TO_DIST_LINK_TYPE source_22
, l2.APPLIED_TO_ENTITY_CODE source_23
, l2.APPLIED_TO_DIST_ID_1 source_24
, l2.APPLIED_TO_HEADER_ID_1 source_25
, l2.ENTERED_AMT source_26
, l2.CURRENCY_CODE source_27
, l2.ACCOUNTED_AMT source_28
, l2.JFMIP_REFERENCE source_31
, l4.CURRENCY_CONVERSION_DATE source_35
, l4.CURRENCY_CONVERSION_RATE source_36
, l4.CURRENCY_CONVERSION_TYPE source_37
, l2.REQ_DISTRIBUTION_ID source_43
, l2.REQ_ENCUM_UPG_OPTION source_45
, l2.REQ_UPG_ENC_TYPE_ID source_46
, l2.ADJUSTMENT_STATUS source_47
FROM xla_events_gt xet
, FV_XLA_PO_REF_V l1
, PO_REQ_EXTRACT_DETAIL_V l2
, PO_REQ_LINES_REF_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l1.Federal_Event_id (+) =l2.event_id AND l1.federal_line_number (+) =l2.line_number AND l2.req_line_id = l4.req_line_id (+) ;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
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
);
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
);
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
);