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);
XLA_AE_JOURNAL_ENTRY_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_166(
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) := 'FUTURE DATED PAYMENTS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_166';
(p_msg => 'BEGIN of insert_sources_166'
,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 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 26 THEN 'AP_PAYMENT_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'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
WHEN 20 THEN 'HEADER'
WHEN 21 THEN 'HEADER'
WHEN 22 THEN 'HEADER'
WHEN 23 THEN 'HEADER'
WHEN 24 THEN 'HEADER'
WHEN 25 THEN 'HEADER'
WHEN 26 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOC_SEQUENCE_NAME'
WHEN 2 THEN 'AC_DOC_SEQUENCE_VALUE'
WHEN 3 THEN 'PAYMENT_TRANSACTION_NUMBER'
WHEN 4 THEN 'AC_CHECK_DATE'
WHEN 5 THEN 'CBA_BANK_ACCOUNT_NAME'
WHEN 6 THEN 'AC_CURRENCY_CODE'
WHEN 7 THEN 'CGAC_AP_ASSET_CCID'
WHEN 8 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 9 THEN 'CGAC_CASH_CLEARING_CCID'
WHEN 10 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 11 THEN 'CGAC_GAIN_CCID'
WHEN 12 THEN 'ASP_GAIN_CCID'
WHEN 13 THEN 'CGAC_LOSS_CCID'
WHEN 14 THEN 'ASP_LOSS_CCID'
WHEN 15 THEN 'ASP_ROUNDING_ERROR_CCID'
WHEN 16 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 17 THEN 'AC_VENDOR_ID'
WHEN 18 THEN 'AC_VENDOR_SITE_ID'
WHEN 19 THEN 'THIRD_PARTY_TYPE'
WHEN 20 THEN 'CBA_POOLED_BANK_ACOUNT_FLAG'
WHEN 21 THEN 'AC_FUTURE_PAY_DUE_DATE'
WHEN 22 THEN 'AC_EXCHANGE_DATE'
WHEN 23 THEN 'AC_EXCHANGE_RATE'
WHEN 24 THEN 'AC_EXCHANGE_RATE_TYPE'
WHEN 25 THEN 'AC_DOC_CATEGORY_CODE'
WHEN 26 THEN 'PAYMENT_DOCUMENT_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.DOC_SEQUENCE_NAME)
WHEN 2 THEN TO_CHAR(h2.AC_DOC_SEQUENCE_VALUE)
WHEN 3 THEN TO_CHAR(h2.PAYMENT_TRANSACTION_NUMBER)
WHEN 4 THEN TO_CHAR(h2.AC_CHECK_DATE)
WHEN 5 THEN TO_CHAR(h2.CBA_BANK_ACCOUNT_NAME)
WHEN 6 THEN TO_CHAR(h2.AC_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(h2.CGAC_AP_ASSET_CCID)
WHEN 8 THEN TO_CHAR(h3.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 9 THEN TO_CHAR(h2.CGAC_CASH_CLEARING_CCID)
WHEN 10 THEN TO_CHAR(h3.ASP_AUTO_OFFSET_FLAG)
WHEN 11 THEN TO_CHAR(h2.CGAC_GAIN_CCID)
WHEN 12 THEN TO_CHAR(h3.ASP_GAIN_CCID)
WHEN 13 THEN TO_CHAR(h2.CGAC_LOSS_CCID)
WHEN 14 THEN TO_CHAR(h3.ASP_LOSS_CCID)
WHEN 15 THEN TO_CHAR(h3.ASP_ROUNDING_ERROR_CCID)
WHEN 16 THEN TO_CHAR(h3.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 17 THEN TO_CHAR(h2.AC_VENDOR_ID)
WHEN 18 THEN TO_CHAR(h2.AC_VENDOR_SITE_ID)
WHEN 19 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 20 THEN TO_CHAR(h2.CBA_POOLED_BANK_ACOUNT_FLAG)
WHEN 21 THEN TO_CHAR(h2.AC_FUTURE_PAY_DUE_DATE)
WHEN 22 THEN TO_CHAR(h2.AC_EXCHANGE_DATE)
WHEN 23 THEN TO_CHAR(h2.AC_EXCHANGE_RATE)
WHEN 24 THEN TO_CHAR(h2.AC_EXCHANGE_RATE_TYPE)
WHEN 25 THEN TO_CHAR(h2.AC_DOC_CATEGORY_CODE)
WHEN 26 THEN TO_CHAR(h2.PAYMENT_DOCUMENT_SEQUENCE_ID)
ELSE null
END source_value
, CASE r
WHEN 8 THEN fvl16.meaning
WHEN 10 THEN fvl42.meaning
WHEN 20 THEN fvl117.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl117
,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ac_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
)
;
(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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'APHD_PAYMENT_BASE_AMT'
WHEN 2 THEN 'AID_DIST_CCID'
WHEN 3 THEN 'APHD_PAY_DIST_LOOKUP_CODE'
WHEN 4 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 5 THEN 'APHD_AMOUNT'
WHEN 6 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 7 THEN 'BUS_FLOW_PAYMENT_DIST_TYPE'
WHEN 8 THEN 'BUS_FLOW_PAYMENT_ENTITY_CODE'
WHEN 9 THEN 'BUS_FLOW_PAYMENT_DIST_ID'
WHEN 10 THEN 'BUS_FLOW_PAYMENT_ID'
WHEN 11 THEN 'APHD_PAYMENT_HIST_DIST_ID'
WHEN 12 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 13 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 14 THEN 'APHD_REV_PAY_HIST_DIST_ID'
WHEN 15 THEN 'APHD_MATURED_BASE_AMOUNT'
WHEN 16 THEN 'PMT_MAT_BASE_AMT_DIFF'
WHEN 17 THEN 'PMT_MAT_GAIN_LOSS_INDICATOR'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.APHD_PAYMENT_BASE_AMT)
WHEN 2 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 3 THEN TO_CHAR(l1.APHD_PAY_DIST_LOOKUP_CODE)
WHEN 4 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 5 THEN TO_CHAR(l1.APHD_AMOUNT)
WHEN 6 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 7 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_DIST_TYPE)
WHEN 8 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_ENTITY_CODE)
WHEN 9 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_DIST_ID)
WHEN 10 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_ID)
WHEN 11 THEN TO_CHAR(l1.APHD_PAYMENT_HIST_DIST_ID)
WHEN 12 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 13 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 14 THEN TO_CHAR(l1.APHD_REV_PAY_HIST_DIST_ID)
WHEN 15 THEN TO_CHAR(l1.APHD_MATURED_BASE_AMOUNT)
WHEN 16 THEN TO_CHAR(l1.PMT_MAT_BASE_AMT_DIFF)
WHEN 17 THEN TO_CHAR(l1.PMT_MAT_GAIN_LOSS_INDICATOR)
ELSE null
END source_value
, CASE r
WHEN 3 THEN fvl51.meaning
WHEN 13 THEN fvl64.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l1.event_id = xet.event_id
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
)
;
(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_166'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000011_PKG.insert_sources_166');
END insert_sources_166;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: FUTURE DATED PAYMENTS
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.DOC_SEQUENCE_NAME source_5
, h2.AC_DOC_SEQUENCE_VALUE source_8
, h2.PAYMENT_TRANSACTION_NUMBER source_9
, h2.AC_CHECK_DATE source_10
, h2.CBA_BANK_ACCOUNT_NAME source_11
, h2.AC_CURRENCY_CODE source_12
, h2.CGAC_AP_ASSET_CCID source_13
, h3.ASP_AUTOMATIC_OFFSETS_VALUE source_16
, fvl16.meaning source_16_meaning
, h2.CGAC_CASH_CLEARING_CCID source_33
, h3.ASP_AUTO_OFFSET_FLAG source_42
, fvl42.meaning source_42_meaning
, h2.CGAC_GAIN_CCID source_44
, h3.ASP_GAIN_CCID source_45
, h2.CGAC_LOSS_CCID source_46
, h3.ASP_LOSS_CCID source_47
, h3.ASP_ROUNDING_ERROR_CCID source_49
, h3.ASP_WHEN_TO_ACCOUNT_PMT source_50
, h2.AC_VENDOR_ID source_65
, h2.AC_VENDOR_SITE_ID source_66
, h2.THIRD_PARTY_TYPE source_67
, h2.CBA_POOLED_BANK_ACOUNT_FLAG source_117
, fvl117.meaning source_117_meaning
, h2.AC_FUTURE_PAY_DUE_DATE source_118
, h2.AC_EXCHANGE_DATE source_121
, h2.AC_EXCHANGE_RATE source_122
, h2.AC_EXCHANGE_RATE_TYPE source_123
, h2.AC_DOC_CATEGORY_CODE source_156
, h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl117
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ac_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: FUTURE DATED PAYMENTS
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.APHD_PAYMENT_BASE_AMT source_21
, l1.AID_DIST_CCID source_29
, l1.APHD_PAY_DIST_LOOKUP_CODE source_51
, fvl51.meaning source_51_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_52
, l1.APHD_AMOUNT source_53
, l1.BUS_FLOW_AP_APP_ID source_54
, l1.BUS_FLOW_PAYMENT_DIST_TYPE source_55
, l1.BUS_FLOW_PAYMENT_ENTITY_CODE source_56
, l1.BUS_FLOW_PAYMENT_DIST_ID source_57
, l1.BUS_FLOW_PAYMENT_ID source_58
, l1.APHD_PAYMENT_HIST_DIST_ID source_59
, l1.DISTRIBUTION_LINK_TYPE source_60
, l1.OVERRIDE_ACCTD_AMT_FLAG source_64
, fvl64.meaning source_64_meaning
, l1.APHD_REV_PAY_HIST_DIST_ID source_68
, l1.APHD_MATURED_BASE_AMOUNT source_124
, l1.PMT_MAT_BASE_AMT_DIFF source_135
, l1.PMT_MAT_GAIN_LOSS_INDICATOR source_140
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
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 fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
;
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_167(
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) := 'PAYMENTS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_167';
(p_msg => 'BEGIN of insert_sources_167'
,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 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 38 THEN 'AP_PAYMENT_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'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
WHEN 20 THEN 'HEADER'
WHEN 21 THEN 'HEADER'
WHEN 22 THEN 'HEADER'
WHEN 23 THEN 'HEADER'
WHEN 24 THEN 'HEADER'
WHEN 25 THEN 'HEADER'
WHEN 26 THEN 'HEADER'
WHEN 27 THEN 'HEADER'
WHEN 28 THEN 'HEADER'
WHEN 29 THEN 'HEADER'
WHEN 30 THEN 'HEADER'
WHEN 31 THEN 'HEADER'
WHEN 32 THEN 'HEADER'
WHEN 33 THEN 'HEADER'
WHEN 34 THEN 'HEADER'
WHEN 35 THEN 'HEADER'
WHEN 36 THEN 'HEADER'
WHEN 37 THEN 'HEADER'
WHEN 38 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOC_SEQUENCE_NAME'
WHEN 2 THEN 'AC_DOC_SEQUENCE_VALUE'
WHEN 3 THEN 'PAYMENT_TRANSACTION_NUMBER'
WHEN 4 THEN 'AC_CHECK_DATE'
WHEN 5 THEN 'CBA_BANK_ACCOUNT_NAME'
WHEN 6 THEN 'AC_CURRENCY_CODE'
WHEN 7 THEN 'CGAC_AP_ASSET_CCID'
WHEN 8 THEN 'FSP_DISC_TAKEN_CCID'
WHEN 9 THEN 'ASP_DISCOUNT_DIST_METHOD'
WHEN 10 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 11 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 12 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 13 THEN 'CGAC_FUTURE_DATED_PMT_CCID'
WHEN 14 THEN 'ASP_FD_PMT_ACCT_SOURCE'
WHEN 15 THEN 'FSP_FUTURE_DATED_PAYMENT_CCID'
WHEN 16 THEN 'POS_FDP_CCID'
WHEN 17 THEN 'ASP_INTEREST_CCID'
WHEN 18 THEN 'ASP_PRORATE_INT_ACROSS_DISTS'
WHEN 19 THEN 'ASP_BUILD_PREPAY_ACCOUNTS_FLAG'
WHEN 20 THEN 'CGAC_CASH_CLEARING_CCID'
WHEN 21 THEN 'FSP_RETAINAGE_ACCOUNT'
WHEN 22 THEN 'ASP_DISC_TAKEN_CCID'
WHEN 23 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 24 THEN 'PAYCARD_ACCRUED_ACCOUNT_CCID'
WHEN 25 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 26 THEN 'AC_VENDOR_ID'
WHEN 27 THEN 'AC_VENDOR_SITE_ID'
WHEN 28 THEN 'THIRD_PARTY_TYPE'
WHEN 29 THEN 'PAYMENT_TYPE'
WHEN 30 THEN 'CBA_POOLED_BANK_ACOUNT_FLAG'
WHEN 31 THEN 'AC_FUTURE_PAY_DUE_DATE'
WHEN 32 THEN 'PAYMENT_PROCESSING_TYPE'
WHEN 33 THEN 'AC_EXCHANGE_DATE'
WHEN 34 THEN 'AC_EXCHANGE_RATE'
WHEN 35 THEN 'AC_EXCHANGE_RATE_TYPE'
WHEN 36 THEN 'AC_DOC_CATEGORY_CODE'
WHEN 37 THEN 'PAYMENT_DOCUMENT_SEQUENCE_ID'
WHEN 38 THEN 'TRANSAC_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.DOC_SEQUENCE_NAME)
WHEN 2 THEN TO_CHAR(h2.AC_DOC_SEQUENCE_VALUE)
WHEN 3 THEN TO_CHAR(h2.PAYMENT_TRANSACTION_NUMBER)
WHEN 4 THEN TO_CHAR(h2.AC_CHECK_DATE)
WHEN 5 THEN TO_CHAR(h2.CBA_BANK_ACCOUNT_NAME)
WHEN 6 THEN TO_CHAR(h2.AC_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(h2.CGAC_AP_ASSET_CCID)
WHEN 8 THEN TO_CHAR(h4.FSP_DISC_TAKEN_CCID)
WHEN 9 THEN TO_CHAR(h4.ASP_DISCOUNT_DIST_METHOD)
WHEN 10 THEN TO_CHAR(h4.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 11 THEN TO_CHAR(h4.ASP_RATE_VAR_GAIN_CCID)
WHEN 12 THEN TO_CHAR(h4.ASP_RATE_VAR_LOSS_CCID)
WHEN 13 THEN TO_CHAR(h2.CGAC_FUTURE_DATED_PMT_CCID)
WHEN 14 THEN TO_CHAR(h4.ASP_FD_PMT_ACCT_SOURCE)
WHEN 15 THEN TO_CHAR(h4.FSP_FUTURE_DATED_PAYMENT_CCID)
WHEN 16 THEN TO_CHAR(h2.POS_FDP_CCID)
WHEN 17 THEN TO_CHAR(h4.ASP_INTEREST_CCID)
WHEN 18 THEN TO_CHAR(h4.ASP_PRORATE_INT_ACROSS_DISTS)
WHEN 19 THEN TO_CHAR(h4.ASP_BUILD_PREPAY_ACCOUNTS_FLAG)
WHEN 20 THEN TO_CHAR(h2.CGAC_CASH_CLEARING_CCID)
WHEN 21 THEN TO_CHAR(h4.FSP_RETAINAGE_ACCOUNT)
WHEN 22 THEN TO_CHAR(h4.ASP_DISC_TAKEN_CCID)
WHEN 23 THEN TO_CHAR(h4.ASP_AUTO_OFFSET_FLAG)
WHEN 24 THEN TO_CHAR(h2.PAYCARD_ACCRUED_ACCOUNT_CCID)
WHEN 25 THEN TO_CHAR(h4.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 26 THEN TO_CHAR(h2.AC_VENDOR_ID)
WHEN 27 THEN TO_CHAR(h2.AC_VENDOR_SITE_ID)
WHEN 28 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 29 THEN TO_CHAR(h2.PAYMENT_TYPE)
WHEN 30 THEN TO_CHAR(h2.CBA_POOLED_BANK_ACOUNT_FLAG)
WHEN 31 THEN TO_CHAR(h2.AC_FUTURE_PAY_DUE_DATE)
WHEN 32 THEN TO_CHAR(h2.PAYMENT_PROCESSING_TYPE)
WHEN 33 THEN TO_CHAR(h2.AC_EXCHANGE_DATE)
WHEN 34 THEN TO_CHAR(h2.AC_EXCHANGE_RATE)
WHEN 35 THEN TO_CHAR(h2.AC_EXCHANGE_RATE_TYPE)
WHEN 36 THEN TO_CHAR(h2.AC_DOC_CATEGORY_CODE)
WHEN 37 THEN TO_CHAR(h2.PAYMENT_DOCUMENT_SEQUENCE_ID)
WHEN 38 THEN TO_CHAR(h2.TRANSAC_REVERSAL_FLAG)
ELSE null
END source_value
, CASE r
WHEN 9 THEN fvl15.meaning
WHEN 10 THEN fvl16.meaning
WHEN 14 THEN fvl24.meaning
WHEN 19 THEN fvl30.meaning
WHEN 23 THEN fvl42.meaning
WHEN 29 THEN fvl71.meaning
WHEN 30 THEN fvl117.meaning
WHEN 38 THEN fvl159.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl24
, fnd_lookup_values fvl30
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
, fnd_lookup_values fvl159
,(select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl24.lookup_type(+) = 'FUTURE PAY ACCT SOURCE'
AND fvl24.lookup_code(+) = h4.ASP_FD_PMT_ACCT_SOURCE
AND fvl24.view_application_id(+) = 200
AND fvl24.language(+) = USERENV('LANG')
AND fvl30.lookup_type(+) = 'YES_NO'
AND fvl30.lookup_code(+) = h4.ASP_BUILD_PREPAY_ACCOUNTS_FLAG
AND fvl30.view_application_id(+) = 0
AND fvl30.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
AND fvl159.lookup_type(+) = 'YES_NO'
AND fvl159.lookup_code(+) = h2.TRANSAC_REVERSAL_FLAG
AND fvl159.view_application_id(+) = 0
AND fvl159.language(+) = USERENV('LANG')
)
;
(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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 5 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 17 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 18 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 19 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 20 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 22 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 23 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 25 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 31 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 2 THEN 'APHD_PAYMENT_BASE_AMT'
WHEN 3 THEN 'APHD_CLEARING_BASE_AMT'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'PO_NUMBER'
WHEN 6 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 7 THEN 'AID_RET_RELATED_DIST_CCID'
WHEN 8 THEN 'AWT_RELATED_DIST_ACCOUNT'
WHEN 9 THEN 'POD_CCID'
WHEN 10 THEN 'PO_VARIANCE_ACCOUNT'
WHEN 11 THEN 'APHD_PAY_DIST_LOOKUP_CODE'
WHEN 12 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 13 THEN 'APHD_AMOUNT'
WHEN 14 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 15 THEN 'APHD_PAYMENT_HIST_DIST_ID'
WHEN 16 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 17 THEN 'POH_RATE_DATE'
WHEN 18 THEN 'POH_RATE'
WHEN 19 THEN 'POH_RATE_TYPE'
WHEN 20 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 21 THEN 'APHD_REV_PAY_HIST_DIST_ID'
WHEN 22 THEN 'TAX_LINE_ID'
WHEN 23 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 24 THEN 'APHD_INVOICE_DIST_AMOUNT'
WHEN 25 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 26 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 27 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 28 THEN 'BUS_FLOW_INV_ID'
WHEN 29 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 30 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 31 THEN 'AI_INVOICE_TYPE_PAID'
WHEN 32 THEN 'BF_RETAINED_INV_DIST_ID_PMT'
WHEN 33 THEN 'BF_RETAINED_INV_ID_PMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 2 THEN TO_CHAR(l1.APHD_PAYMENT_BASE_AMT)
WHEN 3 THEN TO_CHAR(l1.APHD_CLEARING_BASE_AMT)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l3.PO_NUMBER)
WHEN 6 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 7 THEN TO_CHAR(l1.AID_RET_RELATED_DIST_CCID)
WHEN 8 THEN TO_CHAR(l1.AWT_RELATED_DIST_ACCOUNT)
WHEN 9 THEN TO_CHAR(l1.POD_CCID)
WHEN 10 THEN TO_CHAR(l1.PO_VARIANCE_ACCOUNT)
WHEN 11 THEN TO_CHAR(l1.APHD_PAY_DIST_LOOKUP_CODE)
WHEN 12 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 13 THEN TO_CHAR(l1.APHD_AMOUNT)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 15 THEN TO_CHAR(l1.APHD_PAYMENT_HIST_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 17 THEN TO_CHAR(l3.POH_RATE_DATE)
WHEN 18 THEN TO_CHAR(l3.POH_RATE)
WHEN 19 THEN TO_CHAR(l3.POH_RATE_TYPE)
WHEN 20 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 21 THEN TO_CHAR(l1.APHD_REV_PAY_HIST_DIST_ID)
WHEN 22 THEN TO_CHAR(l5.TAX_LINE_ID)
WHEN 23 THEN TO_CHAR(l5.SUMMARY_TAX_LINE_ID)
WHEN 24 THEN TO_CHAR(l1.APHD_INVOICE_DIST_AMOUNT)
WHEN 25 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 26 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 27 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 28 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 29 THEN TO_CHAR(l6.REC_NREC_TAX_DIST_ID)
WHEN 30 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 31 THEN TO_CHAR(l1.AI_INVOICE_TYPE_PAID)
WHEN 32 THEN TO_CHAR(l1.BF_RETAINED_INV_DIST_ID_PMT)
WHEN 33 THEN TO_CHAR(l1.BF_RETAINED_INV_ID_PMT)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl19.meaning
WHEN 6 THEN fvl32.meaning
WHEN 11 THEN fvl51.meaning
WHEN 20 THEN fvl64.meaning
WHEN 30 THEN fvl111.meaning
WHEN 31 THEN fvl112.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
, fnd_lookup_values fvl112
, (select rownum r from all_objects where rownum <= 33 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.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl112.lookup_type(+) = 'INVOICE TYPE'
AND fvl112.lookup_code(+) = l1.AI_INVOICE_TYPE_PAID
AND fvl112.view_application_id(+) = 200
AND fvl112.language(+) = USERENV('LANG')
)
;
(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_167'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000011_PKG.insert_sources_167');
END insert_sources_167;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PAYMENTS
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.DOC_SEQUENCE_NAME source_5
, h2.AC_DOC_SEQUENCE_VALUE source_8
, h2.PAYMENT_TRANSACTION_NUMBER source_9
, h2.AC_CHECK_DATE source_10
, h2.CBA_BANK_ACCOUNT_NAME source_11
, h2.AC_CURRENCY_CODE source_12
, h2.CGAC_AP_ASSET_CCID source_13
, h4.FSP_DISC_TAKEN_CCID source_14
, h4.ASP_DISCOUNT_DIST_METHOD source_15
, fvl15.meaning source_15_meaning
, h4.ASP_AUTOMATIC_OFFSETS_VALUE source_16
, fvl16.meaning source_16_meaning
, h4.ASP_RATE_VAR_GAIN_CCID source_17
, h4.ASP_RATE_VAR_LOSS_CCID source_20
, h2.CGAC_FUTURE_DATED_PMT_CCID source_23
, h4.ASP_FD_PMT_ACCT_SOURCE source_24
, fvl24.meaning source_24_meaning
, h4.FSP_FUTURE_DATED_PAYMENT_CCID source_25
, h2.POS_FDP_CCID source_26
, h4.ASP_INTEREST_CCID source_27
, h4.ASP_PRORATE_INT_ACROSS_DISTS source_28
, h4.ASP_BUILD_PREPAY_ACCOUNTS_FLAG source_30
, fvl30.meaning source_30_meaning
, h2.CGAC_CASH_CLEARING_CCID source_33
, h4.FSP_RETAINAGE_ACCOUNT source_34
, h4.ASP_DISC_TAKEN_CCID source_39
, h4.ASP_AUTO_OFFSET_FLAG source_42
, fvl42.meaning source_42_meaning
, h2.PAYCARD_ACCRUED_ACCOUNT_CCID source_43
, h4.ASP_WHEN_TO_ACCOUNT_PMT source_50
, h2.AC_VENDOR_ID source_65
, h2.AC_VENDOR_SITE_ID source_66
, h2.THIRD_PARTY_TYPE source_67
, h2.PAYMENT_TYPE source_71
, fvl71.meaning source_71_meaning
, h2.CBA_POOLED_BANK_ACOUNT_FLAG source_117
, fvl117.meaning source_117_meaning
, h2.AC_FUTURE_PAY_DUE_DATE source_118
, h2.PAYMENT_PROCESSING_TYPE source_120
, h2.AC_EXCHANGE_DATE source_121
, h2.AC_EXCHANGE_RATE source_122
, h2.AC_EXCHANGE_RATE_TYPE source_123
, h2.AC_DOC_CATEGORY_CODE source_156
, h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
, h2.TRANSAC_REVERSAL_FLAG source_159
, fvl159.meaning source_159_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl24
, fnd_lookup_values fvl30
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
, fnd_lookup_values fvl159
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl24.lookup_type(+) = 'FUTURE PAY ACCT SOURCE'
AND fvl24.lookup_code(+) = h4.ASP_FD_PMT_ACCT_SOURCE
AND fvl24.view_application_id(+) = 200
AND fvl24.language(+) = USERENV('LANG')
AND fvl30.lookup_type(+) = 'YES_NO'
AND fvl30.lookup_code(+) = h4.ASP_BUILD_PREPAY_ACCOUNTS_FLAG
AND fvl30.view_application_id(+) = 0
AND fvl30.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
AND fvl159.lookup_type(+) = 'YES_NO'
AND fvl159.lookup_code(+) = h2.TRANSAC_REVERSAL_FLAG
AND fvl159.view_application_id(+) = 0
AND fvl159.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PAYMENTS
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.RELATED_INV_DIST_DEST_TYPE source_19
, fvl19.meaning source_19_meaning
, l1.APHD_PAYMENT_BASE_AMT source_21
, l1.APHD_CLEARING_BASE_AMT source_22
, l1.AID_DIST_CCID source_29
, l3.PO_NUMBER source_31
, l1.AID_LINE_TYPE_LOOKUP_CODE source_32
, fvl32.meaning source_32_meaning
, l1.AID_RET_RELATED_DIST_CCID source_35
, l1.AWT_RELATED_DIST_ACCOUNT source_36
, l1.POD_CCID source_40
, l1.PO_VARIANCE_ACCOUNT source_41
, l1.APHD_PAY_DIST_LOOKUP_CODE source_51
, fvl51.meaning source_51_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_52
, l1.APHD_AMOUNT source_53
, l1.BUS_FLOW_AP_APP_ID source_54
, l1.APHD_PAYMENT_HIST_DIST_ID source_59
, l1.DISTRIBUTION_LINK_TYPE source_60
, l3.POH_RATE_DATE source_61
, l3.POH_RATE source_62
, l3.POH_RATE_TYPE source_63
, l1.OVERRIDE_ACCTD_AMT_FLAG source_64
, fvl64.meaning source_64_meaning
, l1.APHD_REV_PAY_HIST_DIST_ID source_68
, l5.TAX_LINE_ID source_69
, l5.SUMMARY_TAX_LINE_ID source_70
, l1.APHD_INVOICE_DIST_AMOUNT source_72
, l1.BUS_FLOW_INV_DIST_TYPE source_73
, l1.BUS_FLOW_INV_ENTITY_CODE source_74
, l1.BUS_FLOW_INV_DIST_ID source_75
, l1.BUS_FLOW_INV_ID source_76
, l6.REC_NREC_TAX_DIST_ID source_77
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_111
, fvl111.meaning source_111_meaning
, l1.AI_INVOICE_TYPE_PAID source_112
, fvl112.meaning source_112_meaning
, l1.BF_RETAINED_INV_DIST_ID_PMT source_153
, l1.BF_RETAINED_INV_ID_PMT source_154
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
, fnd_lookup_values fvl112
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.POD_PO_Header_Id = l3.PO_Header_Id (+) AND l1.AID_DETAIL_TAX_DIST_ID = l5.REC_NREC_TAX_DIST_ID (+) AND l1.AID_DETAIL_TAX_DIST_ID = l6.REC_NREC_TAX_DIST_ID (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl112.lookup_type(+) = 'INVOICE TYPE'
AND fvl112.lookup_code(+) = l1.AI_INVOICE_TYPE_PAID
AND fvl112.view_application_id(+) = 200
AND fvl112.language(+) = USERENV('LANG')
;
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_168(
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) := 'PREPAYMENT APPLICATIONS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_168';
(p_msg => 'BEGIN of insert_sources_168'
,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 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 18 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 19 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 20 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 21 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 22 THEN 'AP_INVOICE_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'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
WHEN 20 THEN 'HEADER'
WHEN 21 THEN 'HEADER'
WHEN 22 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'INV_TRANSACTION_NUMBER'
WHEN 2 THEN 'AI_INVOICE_DATE'
WHEN 3 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'DOC_SEQUENCE_NAME'
WHEN 5 THEN 'INV_DOC_SEQUENCE_VALUE'
WHEN 6 THEN 'AI_DESCRIPTION'
WHEN 7 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 8 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 9 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 10 THEN 'FSP_RETAINAGE_ACCOUNT'
WHEN 11 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 12 THEN 'ASP_ROUNDING_ERROR_CCID'
WHEN 13 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 14 THEN 'THIRD_PARTY_TYPE'
WHEN 15 THEN 'AI_INVOICE_ID'
WHEN 16 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 17 THEN 'AI_VENDOR_ID'
WHEN 18 THEN 'AI_VENDOR_SITE_ID'
WHEN 19 THEN 'INV_EXCHANGE_DATE'
WHEN 20 THEN 'INV_EXCHANGE_RATE'
WHEN 21 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 22 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.INV_TRANSACTION_NUMBER)
WHEN 2 THEN TO_CHAR(h1.AI_INVOICE_DATE)
WHEN 3 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h1.DOC_SEQUENCE_NAME)
WHEN 5 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_VALUE)
WHEN 6 THEN TO_CHAR(h1.AI_DESCRIPTION)
WHEN 7 THEN TO_CHAR(h4.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 8 THEN TO_CHAR(h4.ASP_RATE_VAR_GAIN_CCID)
WHEN 9 THEN TO_CHAR(h4.ASP_RATE_VAR_LOSS_CCID)
WHEN 10 THEN TO_CHAR(h4.FSP_RETAINAGE_ACCOUNT)
WHEN 11 THEN TO_CHAR(h4.ASP_AUTO_OFFSET_FLAG)
WHEN 12 THEN TO_CHAR(h4.ASP_ROUNDING_ERROR_CCID)
WHEN 13 THEN TO_CHAR(h4.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 14 THEN TO_CHAR(h1.THIRD_PARTY_TYPE)
WHEN 15 THEN TO_CHAR(h1.AI_INVOICE_ID)
WHEN 16 THEN TO_CHAR(h1.AI_INVOICE_CURRENCY_CODE)
WHEN 17 THEN TO_CHAR(h1.AI_VENDOR_ID)
WHEN 18 THEN TO_CHAR(h1.AI_VENDOR_SITE_ID)
WHEN 19 THEN TO_CHAR(h1.INV_EXCHANGE_DATE)
WHEN 20 THEN TO_CHAR(h1.INV_EXCHANGE_RATE)
WHEN 21 THEN TO_CHAR(h1.INV_EXCHANGE_RATE_TYPE)
WHEN 22 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_IDENTIFIER)
ELSE null
END source_value
, CASE r
WHEN 7 THEN fvl16.meaning
WHEN 11 THEN fvl42.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h1
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
,(select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h4.asp_org_id = h1.ai_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
)
;
(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 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 2 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 3 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 4 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 9 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 10 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 11 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 13 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 15 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 16 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 17 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 18 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 19 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 23 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 24 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 25 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 26 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 27 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 28 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 29 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 30 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 31 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 32 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 33 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 34 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 35 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 36 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 37 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 38 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 39 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 40 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 41 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 42 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 43 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 44 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 45 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 46 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 47 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 48 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 49 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 50 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 51 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 52 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 53 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 54 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 55 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 56 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 57 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 58 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 59 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 60 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_V'
WHEN 61 THEN 'AP_PREPAYAPP_EXTRACT_DETAILS_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'
WHEN 47 THEN 'LINE'
WHEN 48 THEN 'LINE'
WHEN 49 THEN 'LINE'
WHEN 50 THEN 'LINE'
WHEN 51 THEN 'LINE'
WHEN 52 THEN 'LINE'
WHEN 53 THEN 'LINE'
WHEN 54 THEN 'LINE'
WHEN 55 THEN 'LINE'
WHEN 56 THEN 'LINE'
WHEN 57 THEN 'LINE'
WHEN 58 THEN 'LINE'
WHEN 59 THEN 'LINE'
WHEN 60 THEN 'LINE'
WHEN 61 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
WHEN 47 THEN '200'
WHEN 48 THEN '200'
WHEN 49 THEN '200'
WHEN 50 THEN '200'
WHEN 51 THEN '200'
WHEN 52 THEN '200'
WHEN 53 THEN '200'
WHEN 54 THEN '200'
WHEN 55 THEN '200'
WHEN 56 THEN '200'
WHEN 57 THEN '200'
WHEN 58 THEN '200'
WHEN 59 THEN '200'
WHEN 60 THEN '200'
WHEN 61 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'INV_DIST_BASE_AMOUNT'
WHEN 2 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 3 THEN 'AID_DIST_CCID'
WHEN 4 THEN 'AID_RET_RELATED_DIST_CCID'
WHEN 5 THEN 'RECP_INV_DIST_CCID'
WHEN 6 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 7 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 8 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 9 THEN 'POH_RATE_DATE'
WHEN 10 THEN 'POH_RATE'
WHEN 11 THEN 'POH_RATE_TYPE'
WHEN 12 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 13 THEN 'TAX_LINE_ID'
WHEN 14 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 15 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 16 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 17 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 18 THEN 'APAD_DIST_LOOKUP_CODE'
WHEN 19 THEN 'RECP_INV_DIST_TYPE'
WHEN 20 THEN 'APAD_DISTRIBUTION_IDENTIFIER'
WHEN 21 THEN 'BF_ACCRUAL_PREPAY_DIST_TYPE'
WHEN 22 THEN 'BF_ACCRUAL_PREPAY_ENTITY_CODE'
WHEN 23 THEN 'BF_ACCRUAL_PP_DIST_ID'
WHEN 24 THEN 'BF_ACCRUAL_PP_INV'
WHEN 25 THEN 'UPG_ENC_CR_ACCT_CLASS'
WHEN 26 THEN 'UPG_ENC_CR_CCID'
WHEN 27 THEN 'UPG_ENC_CR_AMT'
WHEN 28 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 29 THEN 'UPG_ENC_DR_ACCT_CLASS'
WHEN 30 THEN 'UPG_ENC_DR_CCID'
WHEN 31 THEN 'UPG_ENC_DR_AMT'
WHEN 32 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 33 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 34 THEN 'APAD_AMOUNT'
WHEN 35 THEN 'PREPAY_CLEAR_CURRENCY_CODE'
WHEN 36 THEN 'BASE_AMT_AT_PP_CLR_XRATE'
WHEN 37 THEN 'DEFERRED_END_DATE'
WHEN 38 THEN 'DEFERRED_OPTION'
WHEN 39 THEN 'DEFERRED_START_DATE'
WHEN 40 THEN 'REVERSED_PREPAY_APP_DIST_ID'
WHEN 41 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 42 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 43 THEN 'PREPAY_PAY_CURRENCY_CODE'
WHEN 44 THEN 'BASE_AMT_AT_PP_PAY_XRATE'
WHEN 45 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 46 THEN 'APAD_PREPAY_CLR_XDATE'
WHEN 47 THEN 'APAD_PREPAY_CLR_XRATE'
WHEN 48 THEN 'APAD_PREPAY_CLR_XRATE_TYPE'
WHEN 49 THEN 'APAD_PREPAY_PAY_XDATE'
WHEN 50 THEN 'APAD_PREPAY_PAY_XRATE'
WHEN 51 THEN 'APAD_PREPAY_PAY_XRATE_TYPE'
WHEN 52 THEN 'BF_CASHCLEARONLY_PP_DIST_TYPE'
WHEN 53 THEN 'BF_CASHCLEARONLY_PREPAY_ENTITY'
WHEN 54 THEN 'BF_CASHCLEAR_PP_CLEAR_DIST_ID'
WHEN 55 THEN 'BF_CASHALWAYS_PP_PMT_ID'
WHEN 56 THEN 'BF_CASH_ALWAYS_PP_DIST_TYPE'
WHEN 57 THEN 'BF_CASH_ALWAYS_PREPAY_ENTITY'
WHEN 58 THEN 'BF_CASHALWAYS_PP_PMT_DIST_ID'
WHEN 59 THEN 'AI_RECIPIENT_INV_TYPE'
WHEN 60 THEN 'BF_RET_DIST_ASSOC_TO_PP_RECIP'
WHEN 61 THEN 'BF_RET_INV_ASSOC_TO_PP_RECIP'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.INV_DIST_BASE_AMOUNT)
WHEN 2 THEN TO_CHAR(l3.RELATED_INV_DIST_DEST_TYPE)
WHEN 3 THEN TO_CHAR(l3.AID_DIST_CCID)
WHEN 4 THEN TO_CHAR(l3.AID_RET_RELATED_DIST_CCID)
WHEN 5 THEN TO_CHAR(l3.RECP_INV_DIST_CCID)
WHEN 6 THEN TO_CHAR(l3.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 7 THEN TO_CHAR(l3.BUS_FLOW_AP_APP_ID)
WHEN 8 THEN TO_CHAR(l3.DISTRIBUTION_LINK_TYPE)
WHEN 9 THEN TO_CHAR(l2.POH_RATE_DATE)
WHEN 10 THEN TO_CHAR(l2.POH_RATE)
WHEN 11 THEN TO_CHAR(l2.POH_RATE_TYPE)
WHEN 12 THEN TO_CHAR(l3.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 13 THEN TO_CHAR(l5.TAX_LINE_ID)
WHEN 14 THEN TO_CHAR(l3.SUMMARY_TAX_LINE_ID)
WHEN 15 THEN TO_CHAR(l3.BUS_FLOW_INV_DIST_TYPE)
WHEN 16 THEN TO_CHAR(l3.BUS_FLOW_INV_ENTITY_CODE)
WHEN 17 THEN TO_CHAR(l6.REC_NREC_TAX_DIST_ID)
WHEN 18 THEN TO_CHAR(l3.APAD_DIST_LOOKUP_CODE)
WHEN 19 THEN TO_CHAR(l3.RECP_INV_DIST_TYPE)
WHEN 20 THEN TO_CHAR(l3.APAD_DISTRIBUTION_IDENTIFIER)
WHEN 21 THEN TO_CHAR(l3.BF_ACCRUAL_PREPAY_DIST_TYPE)
WHEN 22 THEN TO_CHAR(l3.BF_ACCRUAL_PREPAY_ENTITY_CODE)
WHEN 23 THEN TO_CHAR(l3.BF_ACCRUAL_PP_DIST_ID)
WHEN 24 THEN TO_CHAR(l3.BF_ACCRUAL_PP_INV)
WHEN 25 THEN TO_CHAR(l3.UPG_ENC_CR_ACCT_CLASS)
WHEN 26 THEN TO_CHAR(l3.UPG_ENC_CR_CCID)
WHEN 27 THEN TO_CHAR(l3.UPG_ENC_CR_AMT)
WHEN 28 THEN TO_CHAR(l3.UPG_ENC_CR_BASE_AMT)
WHEN 29 THEN TO_CHAR(l3.UPG_ENC_DR_ACCT_CLASS)
WHEN 30 THEN TO_CHAR(l3.UPG_ENC_DR_CCID)
WHEN 31 THEN TO_CHAR(l3.UPG_ENC_DR_AMT)
WHEN 32 THEN TO_CHAR(l3.UPG_ENC_DR_BASE_AMT)
WHEN 33 THEN TO_CHAR(l3.UPG_AP_ENCUM_OPTION)
WHEN 34 THEN TO_CHAR(l3.APAD_AMOUNT)
WHEN 35 THEN TO_CHAR(l3.PREPAY_CLEAR_CURRENCY_CODE)
WHEN 36 THEN TO_CHAR(l3.BASE_AMT_AT_PP_CLR_XRATE)
WHEN 37 THEN TO_CHAR(l3.DEFERRED_END_DATE)
WHEN 38 THEN TO_CHAR(l3.DEFERRED_OPTION)
WHEN 39 THEN TO_CHAR(l3.DEFERRED_START_DATE)
WHEN 40 THEN TO_CHAR(l3.REVERSED_PREPAY_APP_DIST_ID)
WHEN 41 THEN TO_CHAR(l3.UPG_CR_ENC_TYPE_ID)
WHEN 42 THEN TO_CHAR(l3.UPG_DR_ENC_TYPE_ID)
WHEN 43 THEN TO_CHAR(l3.PREPAY_PAY_CURRENCY_CODE)
WHEN 44 THEN TO_CHAR(l3.BASE_AMT_AT_PP_PAY_XRATE)
WHEN 45 THEN TO_CHAR(l3.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 46 THEN TO_CHAR(l3.APAD_PREPAY_CLR_XDATE)
WHEN 47 THEN TO_CHAR(l3.APAD_PREPAY_CLR_XRATE)
WHEN 48 THEN TO_CHAR(l3.APAD_PREPAY_CLR_XRATE_TYPE)
WHEN 49 THEN TO_CHAR(l3.APAD_PREPAY_PAY_XDATE)
WHEN 50 THEN TO_CHAR(l3.APAD_PREPAY_PAY_XRATE)
WHEN 51 THEN TO_CHAR(l3.APAD_PREPAY_PAY_XRATE_TYPE)
WHEN 52 THEN TO_CHAR(l3.BF_CASHCLEARONLY_PP_DIST_TYPE)
WHEN 53 THEN TO_CHAR(l3.BF_CASHCLEARONLY_PREPAY_ENTITY)
WHEN 54 THEN TO_CHAR(l3.BF_CASHCLEAR_PP_CLEAR_DIST_ID)
WHEN 55 THEN TO_CHAR(l3.BF_CASHALWAYS_PP_PMT_ID)
WHEN 56 THEN TO_CHAR(l3.BF_CASH_ALWAYS_PP_DIST_TYPE)
WHEN 57 THEN TO_CHAR(l3.BF_CASH_ALWAYS_PREPAY_ENTITY)
WHEN 58 THEN TO_CHAR(l3.BF_CASHALWAYS_PP_PMT_DIST_ID)
WHEN 59 THEN TO_CHAR(l3.AI_RECIPIENT_INV_TYPE)
WHEN 60 THEN TO_CHAR(l3.BF_RET_DIST_ASSOC_TO_PP_RECIP)
WHEN 61 THEN TO_CHAR(l3.BF_RET_INV_ASSOC_TO_PP_RECIP)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl19.meaning
WHEN 12 THEN fvl64.meaning
WHEN 19 THEN fvl79.meaning
WHEN 45 THEN fvl111.meaning
WHEN 59 THEN fvl148.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PO_HEADERS_EXTRACT_V l2
, AP_PREPAYAPP_EXTRACT_DETAILS_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl64
, fnd_lookup_values fvl79
, fnd_lookup_values fvl111
, fnd_lookup_values fvl148
, (select rownum r from all_objects where rownum <= 61 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 l3.pod_po_header_id = l2.po_header_id (+) AND l3.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l3.recp_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l3.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l3.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl79.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl79.lookup_code(+) = l3.RECP_INV_DIST_TYPE
AND fvl79.view_application_id(+) = 200
AND fvl79.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l3.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl148.lookup_type(+) = 'INVOICE TYPE'
AND fvl148.lookup_code(+) = l3.AI_RECIPIENT_INV_TYPE
AND fvl148.view_application_id(+) = 200
AND fvl148.language(+) = USERENV('LANG')
)
;
(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_168'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000011_PKG.insert_sources_168');
END insert_sources_168;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT APPLICATIONS
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.INV_TRANSACTION_NUMBER source_2
, h1.AI_INVOICE_DATE source_3
, h1.INV_DOC_SEQUENCE_CATEGORY source_4
, h1.DOC_SEQUENCE_NAME source_5
, h1.INV_DOC_SEQUENCE_VALUE source_6
, h1.AI_DESCRIPTION source_7
, h4.ASP_AUTOMATIC_OFFSETS_VALUE source_16
, fvl16.meaning source_16_meaning
, h4.ASP_RATE_VAR_GAIN_CCID source_17
, h4.ASP_RATE_VAR_LOSS_CCID source_20
, h4.FSP_RETAINAGE_ACCOUNT source_34
, h4.ASP_AUTO_OFFSET_FLAG source_42
, fvl42.meaning source_42_meaning
, h4.ASP_ROUNDING_ERROR_CCID source_49
, h4.ASP_WHEN_TO_ACCOUNT_PMT source_50
, h1.THIRD_PARTY_TYPE source_67
, h1.AI_INVOICE_ID source_83
, h1.AI_INVOICE_CURRENCY_CODE source_91
, h1.AI_VENDOR_ID source_104
, h1.AI_VENDOR_SITE_ID source_105
, h1.INV_EXCHANGE_DATE source_131
, h1.INV_EXCHANGE_RATE source_132
, h1.INV_EXCHANGE_RATE_TYPE source_133
, h1.INV_DOC_SEQUENCE_IDENTIFIER source_160
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h1
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h4.asp_org_id = h1.ai_org_id AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT APPLICATIONS
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.INV_DIST_BASE_AMOUNT source_18
, l3.RELATED_INV_DIST_DEST_TYPE source_19
, fvl19.meaning source_19_meaning
, l3.AID_DIST_CCID source_29
, l3.AID_RET_RELATED_DIST_CCID source_35
, l3.RECP_INV_DIST_CCID source_48
, l3.DIST_ACCOUNT_REVERSAL_OPTION source_52
, l3.BUS_FLOW_AP_APP_ID source_54
, l3.DISTRIBUTION_LINK_TYPE source_60
, l2.POH_RATE_DATE source_61
, l2.POH_RATE source_62
, l2.POH_RATE_TYPE source_63
, l3.OVERRIDE_ACCTD_AMT_FLAG source_64
, fvl64.meaning source_64_meaning
, l5.TAX_LINE_ID source_69
, l3.SUMMARY_TAX_LINE_ID source_70
, l3.BUS_FLOW_INV_DIST_TYPE source_73
, l3.BUS_FLOW_INV_ENTITY_CODE source_74
, l6.REC_NREC_TAX_DIST_ID source_77
, l3.APAD_DIST_LOOKUP_CODE source_78
, l3.RECP_INV_DIST_TYPE source_79
, fvl79.meaning source_79_meaning
, l3.APAD_DISTRIBUTION_IDENTIFIER source_82
, l3.BF_ACCRUAL_PREPAY_DIST_TYPE source_84
, l3.BF_ACCRUAL_PREPAY_ENTITY_CODE source_85
, l3.BF_ACCRUAL_PP_DIST_ID source_86
, l3.BF_ACCRUAL_PP_INV source_87
, l3.UPG_ENC_CR_ACCT_CLASS source_88
, l3.UPG_ENC_CR_CCID source_89
, l3.UPG_ENC_CR_AMT source_90
, l3.UPG_ENC_CR_BASE_AMT source_92
, l3.UPG_ENC_DR_ACCT_CLASS source_93
, l3.UPG_ENC_DR_CCID source_94
, l3.UPG_ENC_DR_AMT source_95
, l3.UPG_ENC_DR_BASE_AMT source_96
, l3.UPG_AP_ENCUM_OPTION source_97
, l3.APAD_AMOUNT source_98
, l3.PREPAY_CLEAR_CURRENCY_CODE source_99
, l3.BASE_AMT_AT_PP_CLR_XRATE source_100
, l3.DEFERRED_END_DATE source_101
, l3.DEFERRED_OPTION source_102
, l3.DEFERRED_START_DATE source_103
, l3.REVERSED_PREPAY_APP_DIST_ID source_106
, l3.UPG_CR_ENC_TYPE_ID source_107
, l3.UPG_DR_ENC_TYPE_ID source_108
, l3.PREPAY_PAY_CURRENCY_CODE source_109
, l3.BASE_AMT_AT_PP_PAY_XRATE source_110
, l3.POD_ACCRUE_ON_RECEIPT_FLAG source_111
, fvl111.meaning source_111_meaning
, l3.APAD_PREPAY_CLR_XDATE source_125
, l3.APAD_PREPAY_CLR_XRATE source_126
, l3.APAD_PREPAY_CLR_XRATE_TYPE source_127
, l3.APAD_PREPAY_PAY_XDATE source_128
, l3.APAD_PREPAY_PAY_XRATE source_129
, l3.APAD_PREPAY_PAY_XRATE_TYPE source_130
, l3.BF_CASHCLEARONLY_PP_DIST_TYPE source_141
, l3.BF_CASHCLEARONLY_PREPAY_ENTITY source_142
, l3.BF_CASHCLEAR_PP_CLEAR_DIST_ID source_143
, l3.BF_CASHALWAYS_PP_PMT_ID source_144
, l3.BF_CASH_ALWAYS_PP_DIST_TYPE source_145
, l3.BF_CASH_ALWAYS_PREPAY_ENTITY source_146
, l3.BF_CASHALWAYS_PP_PMT_DIST_ID source_147
, l3.AI_RECIPIENT_INV_TYPE source_148
, fvl148.meaning source_148_meaning
, l3.BF_RET_DIST_ASSOC_TO_PP_RECIP source_149
, l3.BF_RET_INV_ASSOC_TO_PP_RECIP source_150
FROM xla_events_gt xet
, AP_PO_HEADERS_EXTRACT_V l2
, AP_PREPAYAPP_EXTRACT_DETAILS_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl64
, fnd_lookup_values fvl79
, fnd_lookup_values fvl111
, fnd_lookup_values fvl148
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 l3.POD_PO_Header_Id = l2.PO_Header_Id (+) AND l3.RECP_DETAIL_TAX_DIST_ID = l5.REC_NREC_TAX_DIST_ID (+) AND l3.RECP_DETAIL_TAX_DIST_ID = l6.REC_NREC_TAX_DIST_ID (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l3.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l3.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl79.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl79.lookup_code(+) = l3.RECP_INV_DIST_TYPE
AND fvl79.view_application_id(+) = 200
AND fvl79.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l3.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl148.lookup_type(+) = 'INVOICE TYPE'
AND fvl148.lookup_code(+) = l3.AI_RECIPIENT_INV_TYPE
AND fvl148.view_application_id(+) = 200
AND fvl148.language(+) = USERENV('LANG')
;
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_169(
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) := 'RECONCILED PAYMENTS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_169';
(p_msg => 'BEGIN of insert_sources_169'
,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 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 40 THEN 'AP_PAYMENT_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'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
WHEN 20 THEN 'HEADER'
WHEN 21 THEN 'HEADER'
WHEN 22 THEN 'HEADER'
WHEN 23 THEN 'HEADER'
WHEN 24 THEN 'HEADER'
WHEN 25 THEN 'HEADER'
WHEN 26 THEN 'HEADER'
WHEN 27 THEN 'HEADER'
WHEN 28 THEN 'HEADER'
WHEN 29 THEN 'HEADER'
WHEN 30 THEN 'HEADER'
WHEN 31 THEN 'HEADER'
WHEN 32 THEN 'HEADER'
WHEN 33 THEN 'HEADER'
WHEN 34 THEN 'HEADER'
WHEN 35 THEN 'HEADER'
WHEN 36 THEN 'HEADER'
WHEN 37 THEN 'HEADER'
WHEN 38 THEN 'HEADER'
WHEN 39 THEN 'HEADER'
WHEN 40 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOC_SEQUENCE_NAME'
WHEN 2 THEN 'AC_DOC_SEQUENCE_VALUE'
WHEN 3 THEN 'PAYMENT_TRANSACTION_NUMBER'
WHEN 4 THEN 'AC_CHECK_DATE'
WHEN 5 THEN 'CBA_BANK_ACCOUNT_NAME'
WHEN 6 THEN 'AC_CURRENCY_CODE'
WHEN 7 THEN 'CGAC_AP_ASSET_CCID'
WHEN 8 THEN 'FSP_DISC_TAKEN_CCID'
WHEN 9 THEN 'ASP_DISCOUNT_DIST_METHOD'
WHEN 10 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 11 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 12 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 13 THEN 'ASP_INTEREST_CCID'
WHEN 14 THEN 'ASP_PRORATE_INT_ACROSS_DISTS'
WHEN 15 THEN 'FSP_RETAINAGE_ACCOUNT'
WHEN 16 THEN 'CGAC_BANK_CHARGES_CCID'
WHEN 17 THEN 'CGAC_BANK_ERRORS_CCID'
WHEN 18 THEN 'ASP_DISC_TAKEN_CCID'
WHEN 19 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 20 THEN 'CGAC_GAIN_CCID'
WHEN 21 THEN 'ASP_GAIN_CCID'
WHEN 22 THEN 'CGAC_LOSS_CCID'
WHEN 23 THEN 'ASP_LOSS_CCID'
WHEN 24 THEN 'ASP_ROUNDING_ERROR_CCID'
WHEN 25 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 26 THEN 'AC_VENDOR_ID'
WHEN 27 THEN 'AC_VENDOR_SITE_ID'
WHEN 28 THEN 'THIRD_PARTY_TYPE'
WHEN 29 THEN 'PAYMENT_TYPE'
WHEN 30 THEN 'APH_BANK_CURRENCY_CODE'
WHEN 31 THEN 'APH_BANK_TO_BASE_XRATE_DATE'
WHEN 32 THEN 'APH_BANK_TO_BASE_XRATE'
WHEN 33 THEN 'APH_BANK_TO_BASE_XRATE_TYPE'
WHEN 34 THEN 'CBA_POOLED_BANK_ACOUNT_FLAG'
WHEN 35 THEN 'AC_FUTURE_PAY_DUE_DATE'
WHEN 36 THEN 'AC_EXCHANGE_DATE'
WHEN 37 THEN 'AC_EXCHANGE_RATE'
WHEN 38 THEN 'AC_EXCHANGE_RATE_TYPE'
WHEN 39 THEN 'AC_DOC_CATEGORY_CODE'
WHEN 40 THEN 'PAYMENT_DOCUMENT_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.DOC_SEQUENCE_NAME)
WHEN 2 THEN TO_CHAR(h2.AC_DOC_SEQUENCE_VALUE)
WHEN 3 THEN TO_CHAR(h2.PAYMENT_TRANSACTION_NUMBER)
WHEN 4 THEN TO_CHAR(h2.AC_CHECK_DATE)
WHEN 5 THEN TO_CHAR(h2.CBA_BANK_ACCOUNT_NAME)
WHEN 6 THEN TO_CHAR(h2.AC_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(h2.CGAC_AP_ASSET_CCID)
WHEN 8 THEN TO_CHAR(h4.FSP_DISC_TAKEN_CCID)
WHEN 9 THEN TO_CHAR(h4.ASP_DISCOUNT_DIST_METHOD)
WHEN 10 THEN TO_CHAR(h4.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 11 THEN TO_CHAR(h4.ASP_RATE_VAR_GAIN_CCID)
WHEN 12 THEN TO_CHAR(h4.ASP_RATE_VAR_LOSS_CCID)
WHEN 13 THEN TO_CHAR(h4.ASP_INTEREST_CCID)
WHEN 14 THEN TO_CHAR(h4.ASP_PRORATE_INT_ACROSS_DISTS)
WHEN 15 THEN TO_CHAR(h4.FSP_RETAINAGE_ACCOUNT)
WHEN 16 THEN TO_CHAR(h2.CGAC_BANK_CHARGES_CCID)
WHEN 17 THEN TO_CHAR(h2.CGAC_BANK_ERRORS_CCID)
WHEN 18 THEN TO_CHAR(h4.ASP_DISC_TAKEN_CCID)
WHEN 19 THEN TO_CHAR(h4.ASP_AUTO_OFFSET_FLAG)
WHEN 20 THEN TO_CHAR(h2.CGAC_GAIN_CCID)
WHEN 21 THEN TO_CHAR(h4.ASP_GAIN_CCID)
WHEN 22 THEN TO_CHAR(h2.CGAC_LOSS_CCID)
WHEN 23 THEN TO_CHAR(h4.ASP_LOSS_CCID)
WHEN 24 THEN TO_CHAR(h4.ASP_ROUNDING_ERROR_CCID)
WHEN 25 THEN TO_CHAR(h4.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 26 THEN TO_CHAR(h2.AC_VENDOR_ID)
WHEN 27 THEN TO_CHAR(h2.AC_VENDOR_SITE_ID)
WHEN 28 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 29 THEN TO_CHAR(h2.PAYMENT_TYPE)
WHEN 30 THEN TO_CHAR(h2.APH_BANK_CURRENCY_CODE)
WHEN 31 THEN TO_CHAR(h2.APH_BANK_TO_BASE_XRATE_DATE)
WHEN 32 THEN TO_CHAR(h2.APH_BANK_TO_BASE_XRATE)
WHEN 33 THEN TO_CHAR(h2.APH_BANK_TO_BASE_XRATE_TYPE)
WHEN 34 THEN TO_CHAR(h2.CBA_POOLED_BANK_ACOUNT_FLAG)
WHEN 35 THEN TO_CHAR(h2.AC_FUTURE_PAY_DUE_DATE)
WHEN 36 THEN TO_CHAR(h2.AC_EXCHANGE_DATE)
WHEN 37 THEN TO_CHAR(h2.AC_EXCHANGE_RATE)
WHEN 38 THEN TO_CHAR(h2.AC_EXCHANGE_RATE_TYPE)
WHEN 39 THEN TO_CHAR(h2.AC_DOC_CATEGORY_CODE)
WHEN 40 THEN TO_CHAR(h2.PAYMENT_DOCUMENT_SEQUENCE_ID)
ELSE null
END source_value
, CASE r
WHEN 9 THEN fvl15.meaning
WHEN 10 THEN fvl16.meaning
WHEN 19 THEN fvl42.meaning
WHEN 29 THEN fvl71.meaning
WHEN 34 THEN fvl117.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
,(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 h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
)
;
(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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 14 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 15 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 16 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 19 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 20 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 21 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 22 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 25 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 26 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 27 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 28 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 29 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 30 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 31 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 32 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 33 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 34 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 35 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 36 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 37 THEN 'AP_PAYMENT_EXTRACT_DETAILS_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 2 THEN 'APHD_PAYMENT_BASE_AMT'
WHEN 3 THEN 'APHD_CLEARING_BASE_AMT'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 6 THEN 'AID_RET_RELATED_DIST_CCID'
WHEN 7 THEN 'AWT_RELATED_DIST_ACCOUNT'
WHEN 8 THEN 'POD_CCID'
WHEN 9 THEN 'PO_VARIANCE_ACCOUNT'
WHEN 10 THEN 'APHD_PAY_DIST_LOOKUP_CODE'
WHEN 11 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 12 THEN 'APHD_AMOUNT'
WHEN 13 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 14 THEN 'BUS_FLOW_PAYMENT_DIST_TYPE'
WHEN 15 THEN 'BUS_FLOW_PAYMENT_ENTITY_CODE'
WHEN 16 THEN 'BUS_FLOW_PAYMENT_DIST_ID'
WHEN 17 THEN 'BUS_FLOW_PAYMENT_ID'
WHEN 18 THEN 'APHD_PAYMENT_HIST_DIST_ID'
WHEN 19 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 20 THEN 'POH_RATE_DATE'
WHEN 21 THEN 'POH_RATE'
WHEN 22 THEN 'POH_RATE_TYPE'
WHEN 23 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 24 THEN 'APHD_REV_PAY_HIST_DIST_ID'
WHEN 25 THEN 'TAX_LINE_ID'
WHEN 26 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 27 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 28 THEN 'AI_INVOICE_TYPE_PAID'
WHEN 29 THEN 'APHD_INVOICE_BASE_AMT'
WHEN 30 THEN 'INV_CLR_BASE_AMT_DIFF'
WHEN 31 THEN 'MAT_CLR_GAIN_LOSS_INDICATOR'
WHEN 32 THEN 'MAT_CLR_BASE_AMT_DIFF'
WHEN 33 THEN 'PMT_CLR_GAIN_LOSS_INDICATOR'
WHEN 34 THEN 'PMT_CLR_BASE_AMT_DIFF'
WHEN 35 THEN 'BF_RETAINED_INV_DIST_ID_CLR'
WHEN 36 THEN 'BF_RETAINED_INV_ID_CLR'
WHEN 37 THEN 'AWT_AT_PMT_TIME'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 2 THEN TO_CHAR(l1.APHD_PAYMENT_BASE_AMT)
WHEN 3 THEN TO_CHAR(l1.APHD_CLEARING_BASE_AMT)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 6 THEN TO_CHAR(l1.AID_RET_RELATED_DIST_CCID)
WHEN 7 THEN TO_CHAR(l1.AWT_RELATED_DIST_ACCOUNT)
WHEN 8 THEN TO_CHAR(l1.POD_CCID)
WHEN 9 THEN TO_CHAR(l1.PO_VARIANCE_ACCOUNT)
WHEN 10 THEN TO_CHAR(l1.APHD_PAY_DIST_LOOKUP_CODE)
WHEN 11 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 12 THEN TO_CHAR(l1.APHD_AMOUNT)
WHEN 13 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_DIST_TYPE)
WHEN 15 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_ENTITY_CODE)
WHEN 16 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_DIST_ID)
WHEN 17 THEN TO_CHAR(l1.BUS_FLOW_PAYMENT_ID)
WHEN 18 THEN TO_CHAR(l1.APHD_PAYMENT_HIST_DIST_ID)
WHEN 19 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 20 THEN TO_CHAR(l3.POH_RATE_DATE)
WHEN 21 THEN TO_CHAR(l3.POH_RATE)
WHEN 22 THEN TO_CHAR(l3.POH_RATE_TYPE)
WHEN 23 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 24 THEN TO_CHAR(l1.APHD_REV_PAY_HIST_DIST_ID)
WHEN 25 THEN TO_CHAR(l5.TAX_LINE_ID)
WHEN 26 THEN TO_CHAR(l5.SUMMARY_TAX_LINE_ID)
WHEN 27 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 28 THEN TO_CHAR(l1.AI_INVOICE_TYPE_PAID)
WHEN 29 THEN TO_CHAR(l1.APHD_INVOICE_BASE_AMT)
WHEN 30 THEN TO_CHAR(l1.INV_CLR_BASE_AMT_DIFF)
WHEN 31 THEN TO_CHAR(l1.MAT_CLR_GAIN_LOSS_INDICATOR)
WHEN 32 THEN TO_CHAR(l1.MAT_CLR_BASE_AMT_DIFF)
WHEN 33 THEN TO_CHAR(l1.PMT_CLR_GAIN_LOSS_INDICATOR)
WHEN 34 THEN TO_CHAR(l1.PMT_CLR_BASE_AMT_DIFF)
WHEN 35 THEN TO_CHAR(l1.BF_RETAINED_INV_DIST_ID_CLR)
WHEN 36 THEN TO_CHAR(l1.BF_RETAINED_INV_ID_CLR)
WHEN 37 THEN TO_CHAR(l1.AWT_AT_PMT_TIME)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl19.meaning
WHEN 5 THEN fvl32.meaning
WHEN 10 THEN fvl51.meaning
WHEN 23 THEN fvl64.meaning
WHEN 27 THEN fvl111.meaning
WHEN 28 THEN fvl112.meaning
WHEN 37 THEN fvl155.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
, fnd_lookup_values fvl112
, fnd_lookup_values fvl155
, (select rownum r from all_objects where rownum <= 37 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.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl112.lookup_type(+) = 'INVOICE TYPE'
AND fvl112.lookup_code(+) = l1.AI_INVOICE_TYPE_PAID
AND fvl112.view_application_id(+) = 200
AND fvl112.language(+) = USERENV('LANG')
AND fvl155.lookup_type(+) = 'YES_NO'
AND fvl155.lookup_code(+) = l1.AWT_AT_PMT_TIME
AND fvl155.view_application_id(+) = 0
AND fvl155.language(+) = USERENV('LANG')
)
;
(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_169'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000011_PKG.insert_sources_169');
END insert_sources_169;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECONCILED PAYMENTS
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.DOC_SEQUENCE_NAME source_5
, h2.AC_DOC_SEQUENCE_VALUE source_8
, h2.PAYMENT_TRANSACTION_NUMBER source_9
, h2.AC_CHECK_DATE source_10
, h2.CBA_BANK_ACCOUNT_NAME source_11
, h2.AC_CURRENCY_CODE source_12
, h2.CGAC_AP_ASSET_CCID source_13
, h4.FSP_DISC_TAKEN_CCID source_14
, h4.ASP_DISCOUNT_DIST_METHOD source_15
, fvl15.meaning source_15_meaning
, h4.ASP_AUTOMATIC_OFFSETS_VALUE source_16
, fvl16.meaning source_16_meaning
, h4.ASP_RATE_VAR_GAIN_CCID source_17
, h4.ASP_RATE_VAR_LOSS_CCID source_20
, h4.ASP_INTEREST_CCID source_27
, h4.ASP_PRORATE_INT_ACROSS_DISTS source_28
, h4.FSP_RETAINAGE_ACCOUNT source_34
, h2.CGAC_BANK_CHARGES_CCID source_37
, h2.CGAC_BANK_ERRORS_CCID source_38
, h4.ASP_DISC_TAKEN_CCID source_39
, h4.ASP_AUTO_OFFSET_FLAG source_42
, fvl42.meaning source_42_meaning
, h2.CGAC_GAIN_CCID source_44
, h4.ASP_GAIN_CCID source_45
, h2.CGAC_LOSS_CCID source_46
, h4.ASP_LOSS_CCID source_47
, h4.ASP_ROUNDING_ERROR_CCID source_49
, h4.ASP_WHEN_TO_ACCOUNT_PMT source_50
, h2.AC_VENDOR_ID source_65
, h2.AC_VENDOR_SITE_ID source_66
, h2.THIRD_PARTY_TYPE source_67
, h2.PAYMENT_TYPE source_71
, fvl71.meaning source_71_meaning
, h2.APH_BANK_CURRENCY_CODE source_113
, h2.APH_BANK_TO_BASE_XRATE_DATE source_114
, h2.APH_BANK_TO_BASE_XRATE source_115
, h2.APH_BANK_TO_BASE_XRATE_TYPE source_116
, h2.CBA_POOLED_BANK_ACOUNT_FLAG source_117
, fvl117.meaning source_117_meaning
, h2.AC_FUTURE_PAY_DUE_DATE source_118
, h2.AC_EXCHANGE_DATE source_121
, h2.AC_EXCHANGE_RATE source_122
, h2.AC_EXCHANGE_RATE_TYPE source_123
, h2.AC_DOC_CATEGORY_CODE source_156
, h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECONCILED PAYMENTS
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.RELATED_INV_DIST_DEST_TYPE source_19
, fvl19.meaning source_19_meaning
, l1.APHD_PAYMENT_BASE_AMT source_21
, l1.APHD_CLEARING_BASE_AMT source_22
, l1.AID_DIST_CCID source_29
, l1.AID_LINE_TYPE_LOOKUP_CODE source_32
, fvl32.meaning source_32_meaning
, l1.AID_RET_RELATED_DIST_CCID source_35
, l1.AWT_RELATED_DIST_ACCOUNT source_36
, l1.POD_CCID source_40
, l1.PO_VARIANCE_ACCOUNT source_41
, l1.APHD_PAY_DIST_LOOKUP_CODE source_51
, fvl51.meaning source_51_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_52
, l1.APHD_AMOUNT source_53
, l1.BUS_FLOW_AP_APP_ID source_54
, l1.BUS_FLOW_PAYMENT_DIST_TYPE source_55
, l1.BUS_FLOW_PAYMENT_ENTITY_CODE source_56
, l1.BUS_FLOW_PAYMENT_DIST_ID source_57
, l1.BUS_FLOW_PAYMENT_ID source_58
, l1.APHD_PAYMENT_HIST_DIST_ID source_59
, l1.DISTRIBUTION_LINK_TYPE source_60
, l3.POH_RATE_DATE source_61
, l3.POH_RATE source_62
, l3.POH_RATE_TYPE source_63
, l1.OVERRIDE_ACCTD_AMT_FLAG source_64
, fvl64.meaning source_64_meaning
, l1.APHD_REV_PAY_HIST_DIST_ID source_68
, l5.TAX_LINE_ID source_69
, l5.SUMMARY_TAX_LINE_ID source_70
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_111
, fvl111.meaning source_111_meaning
, l1.AI_INVOICE_TYPE_PAID source_112
, fvl112.meaning source_112_meaning
, l1.APHD_INVOICE_BASE_AMT source_119
, l1.INV_CLR_BASE_AMT_DIFF source_134
, l1.MAT_CLR_GAIN_LOSS_INDICATOR source_136
, l1.MAT_CLR_BASE_AMT_DIFF source_137
, l1.PMT_CLR_GAIN_LOSS_INDICATOR source_138
, l1.PMT_CLR_BASE_AMT_DIFF source_139
, l1.BF_RETAINED_INV_DIST_ID_CLR source_151
, l1.BF_RETAINED_INV_ID_CLR source_152
, l1.AWT_AT_PMT_TIME source_155
, fvl155.meaning source_155_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
, fnd_lookup_values fvl112
, fnd_lookup_values fvl155
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.POD_PO_Header_Id = l3.PO_Header_Id (+) AND l1.AID_DETAIL_TAX_DIST_ID = l5.REC_NREC_TAX_DIST_ID (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
AND fvl112.lookup_type(+) = 'INVOICE TYPE'
AND fvl112.lookup_code(+) = l1.AI_INVOICE_TYPE_PAID
AND fvl112.view_application_id(+) = 200
AND fvl112.language(+) = USERENV('LANG')
AND fvl155.lookup_type(+) = 'YES_NO'
AND fvl155.lookup_code(+) = l1.AWT_AT_PMT_TIME
AND fvl155.view_application_id(+) = 0
AND fvl155.language(+) = USERENV('LANG')
;
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_170(
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) := 'REFUNDS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_170';
(p_msg => 'BEGIN of insert_sources_170'
,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 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
WHEN 28 THEN 'AP_PAYMENT_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'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
WHEN 20 THEN 'HEADER'
WHEN 21 THEN 'HEADER'
WHEN 22 THEN 'HEADER'
WHEN 23 THEN 'HEADER'
WHEN 24 THEN 'HEADER'
WHEN 25 THEN 'HEADER'
WHEN 26 THEN 'HEADER'
WHEN 27 THEN 'HEADER'
WHEN 28 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOC_SEQUENCE_NAME'
WHEN 2 THEN 'AC_DOC_SEQUENCE_VALUE'
WHEN 3 THEN 'PAYMENT_TRANSACTION_NUMBER'
WHEN 4 THEN 'AC_CHECK_DATE'
WHEN 5 THEN 'CBA_BANK_ACCOUNT_NAME'
WHEN 6 THEN 'AC_CURRENCY_CODE'
WHEN 7 THEN 'CGAC_AP_ASSET_CCID'
WHEN 8 THEN 'FSP_DISC_TAKEN_CCID'
WHEN 9 THEN 'ASP_DISCOUNT_DIST_METHOD'
WHEN 10 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 11 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 12 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 13 THEN 'CGAC_CASH_CLEARING_CCID'
WHEN 14 THEN 'ASP_DISC_TAKEN_CCID'
WHEN 15 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 16 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 17 THEN 'AC_VENDOR_ID'
WHEN 18 THEN 'AC_VENDOR_SITE_ID'
WHEN 19 THEN 'THIRD_PARTY_TYPE'
WHEN 20 THEN 'PAYMENT_TYPE'
WHEN 21 THEN 'CBA_POOLED_BANK_ACOUNT_FLAG'
WHEN 22 THEN 'AC_FUTURE_PAY_DUE_DATE'
WHEN 23 THEN 'AC_EXCHANGE_DATE'
WHEN 24 THEN 'AC_EXCHANGE_RATE'
WHEN 25 THEN 'AC_EXCHANGE_RATE_TYPE'
WHEN 26 THEN 'AC_DOC_CATEGORY_CODE'
WHEN 27 THEN 'PAYMENT_DOCUMENT_SEQUENCE_ID'
WHEN 28 THEN 'TRANSAC_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.DOC_SEQUENCE_NAME)
WHEN 2 THEN TO_CHAR(h2.AC_DOC_SEQUENCE_VALUE)
WHEN 3 THEN TO_CHAR(h2.PAYMENT_TRANSACTION_NUMBER)
WHEN 4 THEN TO_CHAR(h2.AC_CHECK_DATE)
WHEN 5 THEN TO_CHAR(h2.CBA_BANK_ACCOUNT_NAME)
WHEN 6 THEN TO_CHAR(h2.AC_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(h2.CGAC_AP_ASSET_CCID)
WHEN 8 THEN TO_CHAR(h4.FSP_DISC_TAKEN_CCID)
WHEN 9 THEN TO_CHAR(h4.ASP_DISCOUNT_DIST_METHOD)
WHEN 10 THEN TO_CHAR(h4.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 11 THEN TO_CHAR(h4.ASP_RATE_VAR_GAIN_CCID)
WHEN 12 THEN TO_CHAR(h4.ASP_RATE_VAR_LOSS_CCID)
WHEN 13 THEN TO_CHAR(h2.CGAC_CASH_CLEARING_CCID)
WHEN 14 THEN TO_CHAR(h4.ASP_DISC_TAKEN_CCID)
WHEN 15 THEN TO_CHAR(h4.ASP_AUTO_OFFSET_FLAG)
WHEN 16 THEN TO_CHAR(h4.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 17 THEN TO_CHAR(h2.AC_VENDOR_ID)
WHEN 18 THEN TO_CHAR(h2.AC_VENDOR_SITE_ID)
WHEN 19 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 20 THEN TO_CHAR(h2.PAYMENT_TYPE)
WHEN 21 THEN TO_CHAR(h2.CBA_POOLED_BANK_ACOUNT_FLAG)
WHEN 22 THEN TO_CHAR(h2.AC_FUTURE_PAY_DUE_DATE)
WHEN 23 THEN TO_CHAR(h2.AC_EXCHANGE_DATE)
WHEN 24 THEN TO_CHAR(h2.AC_EXCHANGE_RATE)
WHEN 25 THEN TO_CHAR(h2.AC_EXCHANGE_RATE_TYPE)
WHEN 26 THEN TO_CHAR(h2.AC_DOC_CATEGORY_CODE)
WHEN 27 THEN TO_CHAR(h2.PAYMENT_DOCUMENT_SEQUENCE_ID)
WHEN 28 THEN TO_CHAR(h2.TRANSAC_REVERSAL_FLAG)
ELSE null
END source_value
, CASE r
WHEN 9 THEN fvl15.meaning
WHEN 10 THEN fvl16.meaning
WHEN 15 THEN fvl42.meaning
WHEN 20 THEN fvl71.meaning
WHEN 21 THEN fvl117.meaning
WHEN 28 THEN fvl159.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
, fnd_lookup_values fvl159
,(select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
AND fvl159.lookup_type(+) = 'YES_NO'
AND fvl159.lookup_code(+) = h2.TRANSAC_REVERSAL_FLAG
AND fvl159.view_application_id(+) = 0
AND fvl159.language(+) = USERENV('LANG')
)
;
(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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 2 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 3 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 4 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 5 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 6 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 7 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 8 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 9 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 10 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 11 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 12 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 13 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 14 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 15 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 16 THEN 'AP_PO_HEADERS_EXTRACT_V'
WHEN 17 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 18 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 19 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 20 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 21 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 22 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 23 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 24 THEN 'AP_PAYMENT_EXTRACT_DETAILS_V'
WHEN 25 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 26 THEN 'AP_PAYMENT_EXTRACT_DETAILS_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 2 THEN 'APHD_PAYMENT_BASE_AMT'
WHEN 3 THEN 'APHD_CLEARING_BASE_AMT'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 6 THEN 'POD_CCID'
WHEN 7 THEN 'PO_VARIANCE_ACCOUNT'
WHEN 8 THEN 'APHD_PAY_DIST_LOOKUP_CODE'
WHEN 9 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 10 THEN 'APHD_AMOUNT'
WHEN 11 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 12 THEN 'APHD_PAYMENT_HIST_DIST_ID'
WHEN 13 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 14 THEN 'POH_RATE_DATE'
WHEN 15 THEN 'POH_RATE'
WHEN 16 THEN 'POH_RATE_TYPE'
WHEN 17 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 18 THEN 'APHD_REV_PAY_HIST_DIST_ID'
WHEN 19 THEN 'TAX_LINE_ID'
WHEN 20 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 21 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 22 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 23 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 24 THEN 'BUS_FLOW_INV_ID'
WHEN 25 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 26 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 2 THEN TO_CHAR(l1.APHD_PAYMENT_BASE_AMT)
WHEN 3 THEN TO_CHAR(l1.APHD_CLEARING_BASE_AMT)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 6 THEN TO_CHAR(l1.POD_CCID)
WHEN 7 THEN TO_CHAR(l1.PO_VARIANCE_ACCOUNT)
WHEN 8 THEN TO_CHAR(l1.APHD_PAY_DIST_LOOKUP_CODE)
WHEN 9 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 10 THEN TO_CHAR(l1.APHD_AMOUNT)
WHEN 11 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 12 THEN TO_CHAR(l1.APHD_PAYMENT_HIST_DIST_ID)
WHEN 13 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 14 THEN TO_CHAR(l3.POH_RATE_DATE)
WHEN 15 THEN TO_CHAR(l3.POH_RATE)
WHEN 16 THEN TO_CHAR(l3.POH_RATE_TYPE)
WHEN 17 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 18 THEN TO_CHAR(l1.APHD_REV_PAY_HIST_DIST_ID)
WHEN 19 THEN TO_CHAR(l5.TAX_LINE_ID)
WHEN 20 THEN TO_CHAR(l5.SUMMARY_TAX_LINE_ID)
WHEN 21 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 22 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 23 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 24 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 25 THEN TO_CHAR(l6.REC_NREC_TAX_DIST_ID)
WHEN 26 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl19.meaning
WHEN 5 THEN fvl32.meaning
WHEN 8 THEN fvl51.meaning
WHEN 17 THEN fvl64.meaning
WHEN 26 THEN fvl111.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
, (select rownum r from all_objects where rownum <= 26 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.pod_po_header_id = l3.po_header_id (+) AND l1.aid_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND l1.aid_detail_tax_dist_id = l6.rec_nrec_tax_dist_id (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
)
;
(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_170'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000011_PKG.insert_sources_170');
END insert_sources_170;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REFUNDS
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.DOC_SEQUENCE_NAME source_5
, h2.AC_DOC_SEQUENCE_VALUE source_8
, h2.PAYMENT_TRANSACTION_NUMBER source_9
, h2.AC_CHECK_DATE source_10
, h2.CBA_BANK_ACCOUNT_NAME source_11
, h2.AC_CURRENCY_CODE source_12
, h2.CGAC_AP_ASSET_CCID source_13
, h4.FSP_DISC_TAKEN_CCID source_14
, h4.ASP_DISCOUNT_DIST_METHOD source_15
, fvl15.meaning source_15_meaning
, h4.ASP_AUTOMATIC_OFFSETS_VALUE source_16
, fvl16.meaning source_16_meaning
, h4.ASP_RATE_VAR_GAIN_CCID source_17
, h4.ASP_RATE_VAR_LOSS_CCID source_20
, h2.CGAC_CASH_CLEARING_CCID source_33
, h4.ASP_DISC_TAKEN_CCID source_39
, h4.ASP_AUTO_OFFSET_FLAG source_42
, fvl42.meaning source_42_meaning
, h4.ASP_WHEN_TO_ACCOUNT_PMT source_50
, h2.AC_VENDOR_ID source_65
, h2.AC_VENDOR_SITE_ID source_66
, h2.THIRD_PARTY_TYPE source_67
, h2.PAYMENT_TYPE source_71
, fvl71.meaning source_71_meaning
, h2.CBA_POOLED_BANK_ACOUNT_FLAG source_117
, fvl117.meaning source_117_meaning
, h2.AC_FUTURE_PAY_DUE_DATE source_118
, h2.AC_EXCHANGE_DATE source_121
, h2.AC_EXCHANGE_RATE source_122
, h2.AC_EXCHANGE_RATE_TYPE source_123
, h2.AC_DOC_CATEGORY_CODE source_156
, h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
, h2.TRANSAC_REVERSAL_FLAG source_159
, fvl159.meaning source_159_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h4
, fnd_lookup_values fvl15
, fnd_lookup_values fvl16
, fnd_lookup_values fvl42
, fnd_lookup_values fvl71
, fnd_lookup_values fvl117
, fnd_lookup_values fvl159
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h4.asp_org_id = h2.ac_org_id AND fvl15.lookup_type(+) = 'DISCOUNT_DIST_OPTIONS'
AND fvl15.lookup_code(+) = h4.ASP_DISCOUNT_DIST_METHOD
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl16.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl16.lookup_code(+) = h4.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl16.view_application_id(+) = 200
AND fvl16.language(+) = USERENV('LANG')
AND fvl42.lookup_type(+) = 'YES_NO'
AND fvl42.lookup_code(+) = h4.ASP_AUTO_OFFSET_FLAG
AND fvl42.view_application_id(+) = 0
AND fvl42.language(+) = USERENV('LANG')
AND fvl71.lookup_type(+) = 'PAYMENT TYPE'
AND fvl71.lookup_code(+) = h2.PAYMENT_TYPE
AND fvl71.view_application_id(+) = 200
AND fvl71.language(+) = USERENV('LANG')
AND fvl117.lookup_type(+) = 'YES_NO'
AND fvl117.lookup_code(+) = h2.CBA_POOLED_BANK_ACOUNT_FLAG
AND fvl117.view_application_id(+) = 0
AND fvl117.language(+) = USERENV('LANG')
AND fvl159.lookup_type(+) = 'YES_NO'
AND fvl159.lookup_code(+) = h2.TRANSAC_REVERSAL_FLAG
AND fvl159.view_application_id(+) = 0
AND fvl159.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REFUNDS
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.RELATED_INV_DIST_DEST_TYPE source_19
, fvl19.meaning source_19_meaning
, l1.APHD_PAYMENT_BASE_AMT source_21
, l1.APHD_CLEARING_BASE_AMT source_22
, l1.AID_DIST_CCID source_29
, l1.AID_LINE_TYPE_LOOKUP_CODE source_32
, fvl32.meaning source_32_meaning
, l1.POD_CCID source_40
, l1.PO_VARIANCE_ACCOUNT source_41
, l1.APHD_PAY_DIST_LOOKUP_CODE source_51
, fvl51.meaning source_51_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_52
, l1.APHD_AMOUNT source_53
, l1.BUS_FLOW_AP_APP_ID source_54
, l1.APHD_PAYMENT_HIST_DIST_ID source_59
, l1.DISTRIBUTION_LINK_TYPE source_60
, l3.POH_RATE_DATE source_61
, l3.POH_RATE source_62
, l3.POH_RATE_TYPE source_63
, l1.OVERRIDE_ACCTD_AMT_FLAG source_64
, fvl64.meaning source_64_meaning
, l1.APHD_REV_PAY_HIST_DIST_ID source_68
, l5.TAX_LINE_ID source_69
, l5.SUMMARY_TAX_LINE_ID source_70
, l1.BUS_FLOW_INV_DIST_TYPE source_73
, l1.BUS_FLOW_INV_ENTITY_CODE source_74
, l1.BUS_FLOW_INV_DIST_ID source_75
, l1.BUS_FLOW_INV_ID source_76
, l6.REC_NREC_TAX_DIST_ID source_77
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_111
, fvl111.meaning source_111_meaning
FROM xla_events_gt xet
, AP_PAYMENT_EXTRACT_DETAILS_V l1
, AP_PO_HEADERS_EXTRACT_V l3
, ZX_AP_DEF_TAX_EXTRACT_V l5
, ZX_AP_TAX_JRNL_LINE_DESC_V l6
, fnd_lookup_values fvl19
, fnd_lookup_values fvl32
, fnd_lookup_values fvl51
, fnd_lookup_values fvl64
, fnd_lookup_values fvl111
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.POD_PO_Header_Id = l3.PO_Header_Id (+) AND l1.AID_DETAIL_TAX_DIST_ID = l5.REC_NREC_TAX_DIST_ID (+) AND l1.AID_DETAIL_TAX_DIST_ID = l6.REC_NREC_TAX_DIST_ID (+) AND fvl19.lookup_type(+) = 'DESTINATION TYPE'
AND fvl19.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl19.view_application_id(+) = 201
AND fvl19.language(+) = USERENV('LANG')
AND fvl32.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl32.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl32.view_application_id(+) = 200
AND fvl32.language(+) = USERENV('LANG')
AND fvl51.lookup_type(+) = 'PAY_DIST_TYPES'
AND fvl51.lookup_code(+) = l1.APHD_PAY_DIST_LOOKUP_CODE
AND fvl51.view_application_id(+) = 200
AND fvl51.language(+) = USERENV('LANG')
AND fvl64.lookup_type(+) = 'YES_NO'
AND fvl64.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl64.view_application_id(+) = 0
AND fvl64.language(+) = USERENV('LANG')
AND fvl111.lookup_type(+) = 'YES_NO'
AND fvl111.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl111.view_application_id(+) = 0
AND fvl111.language(+) = USERENV('LANG')
;
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_166(
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_167(
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_168(
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_169(
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_170(
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
);