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);
PROCEDURE insert_sources_138(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'ADJUSTMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_138';
(p_msg => 'BEGIN of insert_sources_138'
,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 'AR_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
WHEN 7 THEN 'AR_ADJUSTMENTS_H_V'
WHEN 8 THEN 'AR_ADJUSTMENTS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_RECEIVABLE_CCID'
WHEN 2 THEN 'REC_ACT_TYPE'
WHEN 3 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 4 THEN 'BILL_USES_SITE_USE_ID'
WHEN 5 THEN 'XLA_PARTY_TYPE'
WHEN 6 THEN 'ADJ_DOC_SEQUENCE_CATEGORY'
WHEN 7 THEN 'ADJ_DOC_SEQUENCE_ID'
WHEN 8 THEN 'ADJ_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h7.TRX_RECEIVABLE_CCID)
WHEN 2 THEN TO_CHAR(h6.REC_ACT_TYPE)
WHEN 3 THEN TO_CHAR(h2.BILL_CUST_ACCOUNT_ID)
WHEN 4 THEN TO_CHAR(h3.BILL_USES_SITE_USE_ID)
WHEN 5 THEN TO_CHAR(h7.XLA_PARTY_TYPE)
WHEN 6 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_CATEGORY)
WHEN 7 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_ID)
WHEN 8 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_ADJUSTMENTS_H_V h1
, AR_BILL_TO_CUSTOMERS_S_V h2
, AR_BILL_TO_SITE_USES_S_V h3
, AR_RECEIVABLES_TRX_ACT_S_V h6
, AR_TRANSACTIONS_S_V h7
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h3.event_id = h1.event_id
AND h6.event_id (+) = h1.event_id
AND h7.event_id = h1.event_id
)
;
(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
, l5.line_number line_number
, CASE r
WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 7 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 8 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_SOURCE_TYPE'
WHEN 3 THEN 'DIST_LINE_ID'
WHEN 4 THEN 'DISTRIBUTION_TYPE'
WHEN 5 THEN 'DIST_ENT_AMT'
WHEN 6 THEN 'DIST_CURRENCY_CODE'
WHEN 7 THEN 'DIST_CUR_CONVERSION_DATE'
WHEN 8 THEN 'DIST_CUR_CONVERSION_RATE'
WHEN 9 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 10 THEN 'DIST_TO_ACCTD_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l5.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l5.DIST_SOURCE_TYPE)
WHEN 3 THEN TO_CHAR(l5.DIST_LINE_ID)
WHEN 4 THEN TO_CHAR(l5.DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l5.DIST_ENT_AMT)
WHEN 6 THEN TO_CHAR(l5.DIST_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_DATE)
WHEN 8 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_RATE)
WHEN 9 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_TYPE)
WHEN 10 THEN TO_CHAR(l4.DIST_TO_ACCTD_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l4
, AR_DISTRIBUTIONS_L_V l5
, (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l4.event_id = xet.event_id
AND l5.event_id = l4.event_id
AND l5.line_number = l4.line_number
)
;
(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_138'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_138');
END insert_sources_138;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h7.TRX_RECEIVABLE_CCID source_8
, h6.REC_ACT_TYPE source_23
, h2.BILL_CUST_ACCOUNT_ID source_32
, h3.BILL_USES_SITE_USE_ID source_33
, h7.XLA_PARTY_TYPE source_34
, h1.ADJ_DOC_SEQUENCE_CATEGORY source_81
, h1.ADJ_DOC_SEQUENCE_ID source_82
, h1.ADJ_DOC_SEQUENCE_VALUE source_83
FROM xla_events_gt xet
, AR_ADJUSTMENTS_H_V h1
, AR_BILL_TO_CUSTOMERS_S_V h2
, AR_BILL_TO_SITE_USES_S_V h3
, AR_RECEIVABLES_TRX_ACT_S_V h6
, AR_TRANSACTIONS_S_V h7
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h3.event_id = h1.event_id
AND h6.event_id (+) = h1.event_id
AND h7.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l4.LINE_NUMBER
, l5.DIST_CODE_COMBINATION_ID source_10
, l5.DIST_SOURCE_TYPE source_22
, l5.DIST_LINE_ID source_24
, l5.DISTRIBUTION_TYPE source_25
, l5.DIST_ENT_AMT source_26
, l5.DIST_CURRENCY_CODE source_27
, l4.DIST_CUR_CONVERSION_DATE source_28
, l4.DIST_CUR_CONVERSION_RATE source_29
, l4.DIST_CUR_CONVERSION_TYPE source_30
, l4.DIST_TO_ACCTD_AMT source_31
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l4
, AR_DISTRIBUTIONS_L_V l5
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id
AND l5.event_id = l4.event_id
AND l5.line_number = l4.line_number
;
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_139(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'CHARGEBACK_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_139';
(p_msg => 'BEGIN of insert_sources_139'
,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 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 2 THEN 'BILL_USES_SITE_USE_ID'
WHEN 3 THEN 'XLA_PARTY_TYPE'
WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID'
WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
)
;
(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
, l4.line_number line_number
, CASE r
WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_LINE_DIST_CCID'
WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 3 THEN 'TRX_LINE_DIST_ID'
WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 5 THEN 'TRX_LINE_DIST_AMT'
WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE'
WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE'
WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE'
WHEN 9 THEN 'TRX_LINE_ACCTD_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
)
;
(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_139'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_139');
END insert_sources_139;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CHARGEBACK
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.BILL_CUST_ACCOUNT_ID source_32
, h2.BILL_USES_SITE_USE_ID source_33
, h5.XLA_PARTY_TYPE source_34
, h5.TRX_INVOICE_CURRENCY_CODE source_39
, h5.TRX_DOC_SEQUENCE_CATEGORY source_85
, h5.TRX_DOC_SEQUENCE_ID source_86
, h5.TRX_DOC_SEQUENCE_VALUE source_87
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CHARGEBACK
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.TRX_LINE_DIST_CCID source_21
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l4.TRX_LINE_DIST_ID source_36
, l4.TRX_DISTRIBUTION_TYPE source_37
, l4.TRX_LINE_DIST_AMT source_38
, l3.TRX_LINE_CUR_CONVERSION_DATE source_40
, l3.TRX_LINE_CUR_CONVERSION_RATE source_41
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
, l3.TRX_LINE_ACCTD_AMT source_43
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
;
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_140(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'CREDIT_MEMO_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_140';
(p_msg => 'BEGIN of insert_sources_140'
,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 'AR_CREDIT_MEMO_H_V'
WHEN 2 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 4 THEN 'AR_CREDIT_MEMO_H_V'
WHEN 5 THEN 'AR_CREDIT_MEMO_H_V'
WHEN 6 THEN 'AR_CM_BILL_TO_CUST_H_V'
WHEN 7 THEN 'AR_CM_BILL_SITE_USES_H_V'
WHEN 8 THEN 'AR_CREDIT_MEMO_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'CM_RECEIVABLE_CCID'
WHEN 2 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 3 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 4 THEN 'XLA_PARTY_TYPE'
WHEN 5 THEN 'CM_INVOICE_CURRENCY_CODE'
WHEN 6 THEN 'CM_BILL_CUST_ACCOUNT_ID'
WHEN 7 THEN 'CM_BILL_USES_SITE_USE_ID'
WHEN 8 THEN 'CM_INVOICING_RULE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.CM_RECEIVABLE_CCID)
WHEN 2 THEN TO_CHAR(h8.CODE_COMBINATION_ID_GAIN)
WHEN 3 THEN TO_CHAR(h8.CODE_COMBINATION_ID_LOSS)
WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 5 THEN TO_CHAR(h5.CM_INVOICE_CURRENCY_CODE)
WHEN 6 THEN TO_CHAR(h2.CM_BILL_CUST_ACCOUNT_ID)
WHEN 7 THEN TO_CHAR(h1.CM_BILL_USES_SITE_USE_ID)
WHEN 8 THEN TO_CHAR(h5.CM_INVOICING_RULE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CM_BILL_SITE_USES_H_V h1
, AR_CM_BILL_TO_CUST_H_V h2
, AR_CREDIT_MEMO_H_V h5
, AR_SYSTEM_PARAM_H_V h8
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
AND h8.event_id (+) = h1.event_id
)
;
(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 'AR_CM_LINES_L_V'
WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 6 THEN 'AR_CM_LINES_BASE_V'
WHEN 7 THEN 'AR_CM_LINES_BASE_V'
WHEN 8 THEN 'AR_CM_LINES_BASE_V'
WHEN 9 THEN 'AR_CM_LINES_BASE_V'
WHEN 10 THEN 'AR_CM_LINES_BASE_V'
WHEN 11 THEN 'AR_CM_LINES_BASE_V'
WHEN 12 THEN 'AR_CM_LINES_BASE_V'
WHEN 13 THEN 'AR_CM_LINES_L_V'
WHEN 14 THEN 'AR_CM_LINES_L_V'
WHEN 15 THEN 'AR_CM_LINES_L_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'CM_LINE_DIST_CCID'
WHEN 2 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 3 THEN 'DIST_SOURCE_TYPE'
WHEN 4 THEN 'REC_ACT_TYPE'
WHEN 5 THEN 'DIST_ENT_AMT'
WHEN 6 THEN 'CM_DIST_IDENTIFER'
WHEN 7 THEN 'CM_DIST_TYPE'
WHEN 8 THEN 'CM_LINE_CUR_CONVERSION_DATE'
WHEN 9 THEN 'CM_LINE_CUR_CONVERSION_RATE'
WHEN 10 THEN 'CM_LINE_CUR_CONVERSION_TYPE'
WHEN 11 THEN 'GAIN_LOSS_REF'
WHEN 12 THEN 'CM_LINE_ACCTD_AMT'
WHEN 13 THEN 'CM_TAX_LINE_ID'
WHEN 14 THEN 'CM_LINE_DIST_ACCOUNT_CLASS'
WHEN 15 THEN 'CM_LINE_DIST_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.CM_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l6.DIST_CODE_COMBINATION_ID)
WHEN 3 THEN TO_CHAR(l6.DIST_SOURCE_TYPE)
WHEN 4 THEN TO_CHAR(l7.REC_ACT_TYPE)
WHEN 5 THEN TO_CHAR(l6.DIST_ENT_AMT)
WHEN 6 THEN TO_CHAR(l3.CM_DIST_IDENTIFER)
WHEN 7 THEN TO_CHAR(l3.CM_DIST_TYPE)
WHEN 8 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_DATE)
WHEN 9 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_RATE)
WHEN 10 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_TYPE)
WHEN 11 THEN TO_CHAR(l3.GAIN_LOSS_REF)
WHEN 12 THEN TO_CHAR(l3.CM_LINE_ACCTD_AMT)
WHEN 13 THEN TO_CHAR(l4.CM_TAX_LINE_ID)
WHEN 14 THEN TO_CHAR(l4.CM_LINE_DIST_ACCOUNT_CLASS)
WHEN 15 THEN TO_CHAR(l4.CM_LINE_DIST_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CM_LINES_BASE_V l3
, AR_CM_LINES_L_V l4
, AR_DISTRIBUTIONS_L_V l6
, AR_RECEIVABLES_TRX_ACT_S_V l7
, (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id (+) = l3.event_id
AND l4.line_number (+) = l3.line_number
AND l6.event_id (+) = l3.event_id
AND l6.line_number (+) = l3.line_number
AND l7.event_id (+) = l3.event_id
AND l7.line_number (+) = l3.line_number
)
;
(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_140'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_140');
END insert_sources_140;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.CM_RECEIVABLE_CCID source_2
, h8.CODE_COMBINATION_ID_GAIN source_19
, h8.CODE_COMBINATION_ID_LOSS source_20
, h5.XLA_PARTY_TYPE source_34
, h5.CM_INVOICE_CURRENCY_CODE source_46
, h2.CM_BILL_CUST_ACCOUNT_ID source_52
, h1.CM_BILL_USES_SITE_USE_ID source_53
, h5.CM_INVOICING_RULE_ID source_69
FROM xla_events_gt xet
, AR_CM_BILL_SITE_USES_H_V h1
, AR_CM_BILL_TO_CUST_H_V h2
, AR_CREDIT_MEMO_H_V h5
, AR_SYSTEM_PARAM_H_V h8
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
AND h8.event_id (+) = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.CM_LINE_DIST_CCID source_9
, l6.DIST_CODE_COMBINATION_ID source_10
, l6.DIST_SOURCE_TYPE source_22
, l7.REC_ACT_TYPE source_23
, l6.DIST_ENT_AMT source_26
, l3.CM_DIST_IDENTIFER source_44
, l3.CM_DIST_TYPE source_45
, l3.CM_LINE_CUR_CONVERSION_DATE source_47
, l3.CM_LINE_CUR_CONVERSION_RATE source_48
, l3.CM_LINE_CUR_CONVERSION_TYPE source_49
, l3.GAIN_LOSS_REF source_50
, l3.CM_LINE_ACCTD_AMT source_51
, l4.CM_TAX_LINE_ID source_54
, l4.CM_LINE_DIST_ACCOUNT_CLASS source_55
, l4.CM_LINE_DIST_AMT source_56
FROM xla_events_gt xet
, AR_CM_LINES_BASE_V l3
, AR_CM_LINES_L_V l4
, AR_DISTRIBUTIONS_L_V l6
, AR_RECEIVABLES_TRX_ACT_S_V l7
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id (+) = l3.event_id
AND l4.line_number (+) = l3.line_number
AND l6.event_id (+) = l3.event_id
AND l6.line_number (+) = l3.line_number
AND l7.event_id (+) = l3.event_id
AND l7.line_number (+) = l3.line_number
;
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_141(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'DEBIT_MEMO_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_141';
(p_msg => 'BEGIN of insert_sources_141'
,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 'AR_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 3 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_RECEIVABLE_CCID'
WHEN 2 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 3 THEN 'BILL_USES_SITE_USE_ID'
WHEN 4 THEN 'XLA_PARTY_TYPE'
WHEN 5 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 6 THEN 'TRX_INVOICING_RULE_ID'
WHEN 7 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 8 THEN 'TRX_DOC_SEQUENCE_ID'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
WHEN 2 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 3 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 4 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 5 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 6 THEN TO_CHAR(h5.TRX_INVOICING_RULE_ID)
WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
)
;
(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
, l4.line_number line_number
, CASE r
WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_LINE_DIST_CCID'
WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 3 THEN 'TRX_LINE_DIST_ID'
WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 5 THEN 'TRX_LINE_DIST_AMT'
WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE'
WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE'
WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE'
WHEN 9 THEN 'TRX_LINE_ACCTD_AMT'
WHEN 10 THEN 'TRX_TAX_LINE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
WHEN 10 THEN TO_CHAR(l4.TRX_TAX_LINE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
)
;
(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_141'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_141');
END insert_sources_141;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.TRX_RECEIVABLE_CCID source_8
, h1.BILL_CUST_ACCOUNT_ID source_32
, h2.BILL_USES_SITE_USE_ID source_33
, h5.XLA_PARTY_TYPE source_34
, h5.TRX_INVOICE_CURRENCY_CODE source_39
, h5.TRX_INVOICING_RULE_ID source_70
, h5.TRX_DOC_SEQUENCE_CATEGORY source_85
, h5.TRX_DOC_SEQUENCE_ID source_86
, h5.TRX_DOC_SEQUENCE_VALUE source_87
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.TRX_LINE_DIST_CCID source_21
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l4.TRX_LINE_DIST_ID source_36
, l4.TRX_DISTRIBUTION_TYPE source_37
, l4.TRX_LINE_DIST_AMT source_38
, l3.TRX_LINE_CUR_CONVERSION_DATE source_40
, l3.TRX_LINE_CUR_CONVERSION_RATE source_41
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
, l3.TRX_LINE_ACCTD_AMT source_43
, l4.TRX_TAX_LINE_ID source_57
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
;
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_142(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'DEPOSIT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_142';
(p_msg => 'BEGIN of insert_sources_142'
,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 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 2 THEN 'BILL_USES_SITE_USE_ID'
WHEN 3 THEN 'XLA_PARTY_TYPE'
WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID'
WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
)
;
(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
, l4.line_number line_number
, CASE r
WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_LINE_DIST_CCID'
WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 3 THEN 'TRX_LINE_DIST_ID'
WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 5 THEN 'TRX_LINE_DIST_AMT'
WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE'
WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE'
WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE'
WHEN 9 THEN 'TRX_LINE_ACCTD_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
)
;
(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_142'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_142');
END insert_sources_142;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEPOSIT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.BILL_CUST_ACCOUNT_ID source_32
, h2.BILL_USES_SITE_USE_ID source_33
, h5.XLA_PARTY_TYPE source_34
, h5.TRX_INVOICE_CURRENCY_CODE source_39
, h5.TRX_DOC_SEQUENCE_CATEGORY source_85
, h5.TRX_DOC_SEQUENCE_ID source_86
, h5.TRX_DOC_SEQUENCE_VALUE source_87
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEPOSIT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.TRX_LINE_DIST_CCID source_21
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l4.TRX_LINE_DIST_ID source_36
, l4.TRX_DISTRIBUTION_TYPE source_37
, l4.TRX_LINE_DIST_AMT source_38
, l3.TRX_LINE_CUR_CONVERSION_DATE source_40
, l3.TRX_LINE_CUR_CONVERSION_RATE source_41
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
, l3.TRX_LINE_ACCTD_AMT source_43
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
;
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_143(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'GUARANTEE_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_143';
(p_msg => 'BEGIN of insert_sources_143'
,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 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 2 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 2 THEN 'BILL_USES_SITE_USE_ID'
WHEN 3 THEN 'XLA_PARTY_TYPE'
WHEN 4 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 5 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 6 THEN 'TRX_DOC_SEQUENCE_ID'
WHEN 7 THEN 'TRX_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 2 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 3 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 4 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 5 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 6 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
WHEN 7 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
)
;
(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
, l4.line_number line_number
, CASE r
WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_LINE_DIST_CCID'
WHEN 2 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 3 THEN 'TRX_LINE_DIST_ID'
WHEN 4 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 5 THEN 'TRX_LINE_DIST_AMT'
WHEN 6 THEN 'TRX_LINE_CUR_CONVERSION_DATE'
WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_RATE'
WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_TYPE'
WHEN 9 THEN 'TRX_LINE_ACCTD_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
WHEN 4 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
WHEN 6 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
WHEN 9 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
)
;
(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_143'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_143');
END insert_sources_143;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GUARANTEE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.BILL_CUST_ACCOUNT_ID source_32
, h2.BILL_USES_SITE_USE_ID source_33
, h5.XLA_PARTY_TYPE source_34
, h5.TRX_INVOICE_CURRENCY_CODE source_39
, h5.TRX_DOC_SEQUENCE_CATEGORY source_85
, h5.TRX_DOC_SEQUENCE_ID source_86
, h5.TRX_DOC_SEQUENCE_VALUE source_87
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GUARANTEE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.TRX_LINE_DIST_CCID source_21
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l4.TRX_LINE_DIST_ID source_36
, l4.TRX_DISTRIBUTION_TYPE source_37
, l4.TRX_LINE_DIST_AMT source_38
, l3.TRX_LINE_CUR_CONVERSION_DATE source_40
, l3.TRX_LINE_CUR_CONVERSION_RATE source_41
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
, l3.TRX_LINE_ACCTD_AMT source_43
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
;
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_144(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'INVOICE_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_144';
(p_msg => 'BEGIN of insert_sources_144'
,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 'AR_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_V'
WHEN 7 THEN 'AR_TRANSACTIONS_S_V'
WHEN 8 THEN 'AR_TRANSACTIONS_S_V'
WHEN 9 THEN 'AR_TRANSACTIONS_S_V'
WHEN 10 THEN 'AR_TRANSACTIONS_S_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_RECEIVABLE_CCID'
WHEN 2 THEN 'BILL_CUSTOMER_CLASS_CODE'
WHEN 3 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 4 THEN 'BILL_USES_SITE_USE_ID'
WHEN 5 THEN 'XLA_PARTY_TYPE'
WHEN 6 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 7 THEN 'TRX_INVOICING_RULE_ID'
WHEN 8 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
WHEN 10 THEN 'TRX_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
WHEN 2 THEN TO_CHAR(h1.BILL_CUSTOMER_CLASS_CODE)
WHEN 3 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 4 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 5 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 6 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(h5.TRX_INVOICING_RULE_ID)
WHEN 8 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
WHEN 10 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l4.line_number line_number
, CASE r
WHEN 1 THEN 'FV_XLA_AR_REF_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 12 THEN 'FV_XLA_AR_REF_V'
WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '8901'
WHEN 13 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 2 THEN 'TRX_LINE_DIST_CCID'
WHEN 3 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 4 THEN 'TRX_LINE_DIST_ID'
WHEN 5 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 6 THEN 'TRX_LINE_DIST_AMT'
WHEN 7 THEN 'TRX_LINE_CUR_CONVERSION_DATE'
WHEN 8 THEN 'TRX_LINE_CUR_CONVERSION_RATE'
WHEN 9 THEN 'TRX_LINE_CUR_CONVERSION_TYPE'
WHEN 10 THEN 'TRX_LINE_ACCTD_AMT'
WHEN 11 THEN 'TRX_TAX_LINE_ID'
WHEN 12 THEN 'FEDERAL_ACCOUNT_VALID_FLAG'
WHEN 13 THEN 'ROUNDING_CORRECTION_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
WHEN 2 THEN TO_CHAR(l4.TRX_LINE_DIST_CCID)
WHEN 3 THEN TO_CHAR(l4.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 4 THEN TO_CHAR(l4.TRX_LINE_DIST_ID)
WHEN 5 THEN TO_CHAR(l4.TRX_DISTRIBUTION_TYPE)
WHEN 6 THEN TO_CHAR(l4.TRX_LINE_DIST_AMT)
WHEN 7 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_DATE)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_RATE)
WHEN 9 THEN TO_CHAR(l3.TRX_LINE_CUR_CONVERSION_TYPE)
WHEN 10 THEN TO_CHAR(l3.TRX_LINE_ACCTD_AMT)
WHEN 11 THEN TO_CHAR(l4.TRX_TAX_LINE_ID)
WHEN 12 THEN TO_CHAR(l6.FEDERAL_ACCOUNT_VALID_FLAG)
WHEN 13 THEN TO_CHAR(l3.ROUNDING_CORRECTION_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, FV_XLA_AR_REF_V l6
, (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
AND l6.federal_event_id (+) = l4.event_id and l6.federal_line_number (+) = l4.line_number
)
;
(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_144'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_144');
END insert_sources_144;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.TRX_RECEIVABLE_CCID source_8
, h1.BILL_CUSTOMER_CLASS_CODE source_12
, h1.BILL_CUST_ACCOUNT_ID source_32
, h2.BILL_USES_SITE_USE_ID source_33
, h5.XLA_PARTY_TYPE source_34
, h5.TRX_INVOICE_CURRENCY_CODE source_39
, h5.TRX_INVOICING_RULE_ID source_70
, h5.TRX_DOC_SEQUENCE_CATEGORY source_85
, h5.TRX_DOC_SEQUENCE_ID source_86
, h5.TRX_DOC_SEQUENCE_VALUE source_87
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_TRANSACTIONS_S_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l6.FEDERAL_FUND_CATEGORY source_11
, l4.TRX_LINE_DIST_CCID source_21
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l4.TRX_LINE_DIST_ID source_36
, l4.TRX_DISTRIBUTION_TYPE source_37
, l4.TRX_LINE_DIST_AMT source_38
, l3.TRX_LINE_CUR_CONVERSION_DATE source_40
, l3.TRX_LINE_CUR_CONVERSION_RATE source_41
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
, l3.TRX_LINE_ACCTD_AMT source_43
, l4.TRX_TAX_LINE_ID source_57
, l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
, l3.ROUNDING_CORRECTION_FLAG source_68
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_BASE_V l3
, AR_CUST_TRX_LINES_L_V l4
, FV_XLA_AR_REF_V l6
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
AND l6.federal_event_id (+) = l4.event_id AND l6.federal_line_number (+) = l4.line_number;
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_145(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'MISC_RECEIPT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_145';
(p_msg => 'BEGIN of insert_sources_145'
,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 'AR_REMIT_BANK_ACCT_H_V'
WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 5 THEN 'AR_RCT_METHOD_H_V'
WHEN 6 THEN 'AR_RCT_METHOD_H_V'
WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RMT_BNK_BANK_CHARGES_CCID'
WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID'
WHEN 3 THEN 'RMT_BNK_CASH_CCID'
WHEN 4 THEN 'RMT_BNK_REMITTANCE_CCID'
WHEN 5 THEN 'RCT_CLASS_REMIT_FLAG'
WHEN 6 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 7 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 8 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 9 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 10 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.RMT_BNK_BANK_CHARGES_CCID)
WHEN 2 THEN TO_CHAR(h5.RMT_BNK_CONFIRMATION_CCID)
WHEN 3 THEN TO_CHAR(h5.RMT_BNK_CASH_CCID)
WHEN 4 THEN TO_CHAR(h5.RMT_BNK_REMITTANCE_CCID)
WHEN 5 THEN TO_CHAR(h4.RCT_CLASS_REMIT_FLAG)
WHEN 6 THEN TO_CHAR(h4.RCT_CLASS_CONFIRM_FLAG)
WHEN 7 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 8 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
WHEN 9 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 10 THEN TO_CHAR(h1.RCT_TRX_ACCT_REVERSAL)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h1
, AR_RCT_METHOD_H_V h4
, AR_REMIT_BANK_ACCT_H_V h5
,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
)
;
(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 'AR_DISTRIBUTIONS_L_V'
WHEN 2 THEN 'FV_XLA_AR_REF_V'
WHEN 3 THEN 'FV_XLA_AR_REF_V'
WHEN 4 THEN 'FV_XLA_AR_REF_V'
WHEN 5 THEN 'FV_XLA_AR_REF_V'
WHEN 6 THEN 'FV_XLA_AR_REF_V'
WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 15 THEN 'FV_XLA_AR_REF_V'
WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '8901'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '8901'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 4 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 5 THEN 'FEDERAL_FUND_TIME_FRAME'
WHEN 6 THEN 'FEDERAL_APPORTIONMENT_CATEGORY'
WHEN 7 THEN 'DIST_SOURCE_TYPE'
WHEN 8 THEN 'DIST_LINE_ID'
WHEN 9 THEN 'DISTRIBUTION_TYPE'
WHEN 10 THEN 'DIST_ENT_AMT'
WHEN 11 THEN 'DIST_CURRENCY_CODE'
WHEN 12 THEN 'DIST_CUR_CONVERSION_RATE'
WHEN 13 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 14 THEN 'DIST_TO_ACCTD_AMT'
WHEN 15 THEN 'FEDERAL_ACCOUNT_VALID_FLAG'
WHEN 16 THEN 'DIST_TO_CUR_CONVERSION_DATE'
WHEN 17 THEN 'DIST_MFAR_ADDITIONAL_ENTRY'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l6.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 4 THEN TO_CHAR(l6.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 5 THEN TO_CHAR(l6.FEDERAL_FUND_TIME_FRAME)
WHEN 6 THEN TO_CHAR(l6.FEDERAL_APPORTIONMENT_CATEGORY)
WHEN 7 THEN TO_CHAR(l3.DIST_SOURCE_TYPE)
WHEN 8 THEN TO_CHAR(l3.DIST_LINE_ID)
WHEN 9 THEN TO_CHAR(l3.DISTRIBUTION_TYPE)
WHEN 10 THEN TO_CHAR(l3.DIST_ENT_AMT)
WHEN 11 THEN TO_CHAR(l3.DIST_CURRENCY_CODE)
WHEN 12 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_RATE)
WHEN 13 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_TYPE)
WHEN 14 THEN TO_CHAR(l2.DIST_TO_ACCTD_AMT)
WHEN 15 THEN TO_CHAR(l6.FEDERAL_ACCOUNT_VALID_FLAG)
WHEN 16 THEN TO_CHAR(l2.DIST_TO_CUR_CONVERSION_DATE)
WHEN 17 THEN TO_CHAR(l3.DIST_MFAR_ADDITIONAL_ENTRY)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l2
, AR_DISTRIBUTIONS_L_V l3
, FV_XLA_AR_REF_V l6
, (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 l2.event_id = xet.event_id
AND l3.event_id = l2.event_id
AND l3.line_number = l2.line_number
AND l6.federal_event_id (+) = l3.event_id and l6.federal_line_number (+) = l3.line_number
)
;
(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_145'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_145');
END insert_sources_145;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.RMT_BNK_BANK_CHARGES_CCID source_1
, h5.RMT_BNK_CONFIRMATION_CCID source_3
, h5.RMT_BNK_CASH_CCID source_5
, h5.RMT_BNK_REMITTANCE_CCID source_6
, h4.RCT_CLASS_REMIT_FLAG source_72
, h4.RCT_CLASS_CONFIRM_FLAG source_73
, h1.RCT_DOC_SEQUENCE_CATEGORY source_88
, h1.RCT_DOC_SEQUENCE_ID source_89
, h1.RCT_DOC_SEQUENCE_VALUE source_90
, h1.RCT_TRX_ACCT_REVERSAL source_91
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h1
, AR_RCT_METHOD_H_V h4
, AR_REMIT_BANK_ACCT_H_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
AND h4.event_id (+) = xet.event_id
AND h5.event_id (+) = xet.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l3.DIST_CODE_COMBINATION_ID source_10
, l6.FEDERAL_FUND_CATEGORY source_11
, l6.FEDERAL_FUND_EXPIRED_STATUS source_14
, l6.FEDERAL_PRIOR_YEAR_FLAG source_15
, l6.FEDERAL_FUND_TIME_FRAME source_16
, l6.FEDERAL_APPORTIONMENT_CATEGORY source_17
, l3.DIST_SOURCE_TYPE source_22
, l3.DIST_LINE_ID source_24
, l3.DISTRIBUTION_TYPE source_25
, l3.DIST_ENT_AMT source_26
, l3.DIST_CURRENCY_CODE source_27
, l2.DIST_CUR_CONVERSION_RATE source_29
, l2.DIST_CUR_CONVERSION_TYPE source_30
, l2.DIST_TO_ACCTD_AMT source_31
, l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
, l2.DIST_TO_CUR_CONVERSION_DATE source_59
, l3.DIST_MFAR_ADDITIONAL_ENTRY source_71
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l2
, AR_DISTRIBUTIONS_L_V l3
, FV_XLA_AR_REF_V l6
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l3.event_id = l2.event_id
AND l3.line_number = l2.line_number
AND l6.federal_event_id (+) = l3.event_id AND l6.federal_line_number (+) = l3.line_number;
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_146(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'RECEIPT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_146';
(p_msg => 'BEGIN of insert_sources_146'
,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 'AR_REMIT_BANK_ACCT_H_V'
WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 11 THEN 'AR_RCT_METHOD_H_V'
WHEN 12 THEN 'AR_RCT_METHOD_H_V'
WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
WHEN 18 THEN '222'
WHEN 19 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RMT_BNK_BANK_CHARGES_CCID'
WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID'
WHEN 3 THEN 'RMT_BNK_EARNED_CCID'
WHEN 4 THEN 'RMT_BNK_CASH_CCID'
WHEN 5 THEN 'RMT_BNK_REMITTANCE_CCID'
WHEN 6 THEN 'RMT_BNK_UNEARNED_CCID'
WHEN 7 THEN 'RMT_BNK_UNAPPLIED_CCID'
WHEN 8 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 9 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 10 THEN 'RCT_XLA_APPLIED_TO_APP_ID'
WHEN 11 THEN 'RCT_CLASS_REMIT_FLAG'
WHEN 12 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 13 THEN 'RCT_PAY_FROM_CUSTOMER'
WHEN 14 THEN 'RCT_SITE_SITE_USE_ID'
WHEN 15 THEN 'RCT_APP_STATUS'
WHEN 16 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 17 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 18 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 19 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h9.RMT_BNK_BANK_CHARGES_CCID)
WHEN 2 THEN TO_CHAR(h9.RMT_BNK_CONFIRMATION_CCID)
WHEN 3 THEN TO_CHAR(h9.RMT_BNK_EARNED_CCID)
WHEN 4 THEN TO_CHAR(h9.RMT_BNK_CASH_CCID)
WHEN 5 THEN TO_CHAR(h9.RMT_BNK_REMITTANCE_CCID)
WHEN 6 THEN TO_CHAR(h9.RMT_BNK_UNEARNED_CCID)
WHEN 7 THEN TO_CHAR(h9.RMT_BNK_UNAPPLIED_CCID)
WHEN 8 THEN TO_CHAR(h10.CODE_COMBINATION_ID_GAIN)
WHEN 9 THEN TO_CHAR(h10.CODE_COMBINATION_ID_LOSS)
WHEN 10 THEN TO_CHAR(h2.RCT_XLA_APPLIED_TO_APP_ID)
WHEN 11 THEN TO_CHAR(h6.RCT_CLASS_REMIT_FLAG)
WHEN 12 THEN TO_CHAR(h6.RCT_CLASS_CONFIRM_FLAG)
WHEN 13 THEN TO_CHAR(h2.RCT_PAY_FROM_CUSTOMER)
WHEN 14 THEN TO_CHAR(h7.RCT_SITE_SITE_USE_ID)
WHEN 15 THEN TO_CHAR(h2.RCT_APP_STATUS)
WHEN 16 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 17 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_ID)
WHEN 18 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_VALUE)
WHEN 19 THEN TO_CHAR(h2.RCT_TRX_ACCT_REVERSAL)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h2
, AR_RCT_METHOD_H_V h6
, AR_RCT_SITE_USES_H_V h7
, AR_REMIT_BANK_ACCT_H_V h9
, AR_SYSTEM_PARAM_H_V h10
,(select rownum r from all_objects where rownum <= 19 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 h6.event_id (+) = h2.event_id
AND h7.event_id (+) = h2.event_id
AND h9.event_id (+) = h2.event_id
AND h10.event_id (+) = h2.event_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l5.line_number line_number
, CASE r
WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 3 THEN 'FV_XLA_AR_REF_V'
WHEN 4 THEN 'FV_XLA_AR_REF_V'
WHEN 5 THEN 'FV_XLA_AR_REF_V'
WHEN 6 THEN 'FV_XLA_AR_REF_V'
WHEN 7 THEN 'FV_XLA_AR_REF_V'
WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 13 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 22 THEN 'FV_XLA_AR_REF_V'
WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
WHEN 25 THEN 'AR_TRANSACTIONS_S_V'
WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 28 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 31 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 32 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 33 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 34 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 35 THEN 'AR_DISTRIBUTIONS_L_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '8901'
WHEN 4 THEN '8901'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '8901'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
WHEN 18 THEN '222'
WHEN 19 THEN '222'
WHEN 20 THEN '222'
WHEN 21 THEN '222'
WHEN 22 THEN '8901'
WHEN 23 THEN '222'
WHEN 24 THEN '222'
WHEN 25 THEN '222'
WHEN 26 THEN '222'
WHEN 27 THEN '222'
WHEN 28 THEN '222'
WHEN 29 THEN '222'
WHEN 30 THEN '222'
WHEN 31 THEN '222'
WHEN 32 THEN '222'
WHEN 33 THEN '222'
WHEN 34 THEN '222'
WHEN 35 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'BILL_CUSTOMER_CLASS_CODE'
WHEN 3 THEN 'FEDERAL_ACCOUNT_RULE'
WHEN 4 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 5 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 6 THEN 'FEDERAL_FUND_TIME_FRAME'
WHEN 7 THEN 'FEDERAL_APPORTIONMENT_CATEGORY'
WHEN 8 THEN 'TRX_LINE_DIST_CCID'
WHEN 9 THEN 'DIST_SOURCE_TYPE'
WHEN 10 THEN 'REC_ACT_TYPE'
WHEN 11 THEN 'DIST_LINE_ID'
WHEN 12 THEN 'DISTRIBUTION_TYPE'
WHEN 13 THEN 'DIST_ENT_AMT'
WHEN 14 THEN 'DIST_CURRENCY_CODE'
WHEN 15 THEN 'DIST_CUR_CONVERSION_DATE'
WHEN 16 THEN 'DIST_CUR_CONVERSION_RATE'
WHEN 17 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 18 THEN 'DIST_TO_ACCTD_AMT'
WHEN 19 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 20 THEN 'TRX_LINE_DIST_ID'
WHEN 21 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 22 THEN 'FEDERAL_ACCOUNT_VALID_FLAG'
WHEN 23 THEN 'DIST_TO_CUR_CONVERSION_DATE'
WHEN 24 THEN 'TRX_ENTITY_CODE'
WHEN 25 THEN 'TRX_CUSTOMER_TRX_ID'
WHEN 26 THEN 'DIST_CURRENCY_CODE_FROM'
WHEN 27 THEN 'DIST_TO_CUR_CONVERSION_RATE'
WHEN 28 THEN 'DIST_PARTY_ID'
WHEN 29 THEN 'DIST_PARTY_SITE_ID'
WHEN 30 THEN 'DIST_PARTY_TYPE'
WHEN 31 THEN 'DIST_MFAR_ADDITIONAL_ENTRY'
WHEN 32 THEN 'DIST_ENT_AMT_FROM'
WHEN 33 THEN 'DIST_ACCTD_AMT'
WHEN 34 THEN 'DIST_TO_CUR_CONVERSION_TYPE'
WHEN 35 THEN 'DIST_SOURCE_TABLE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l5.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l1.BILL_CUSTOMER_CLASS_CODE)
WHEN 3 THEN TO_CHAR(l12.FEDERAL_ACCOUNT_RULE)
WHEN 4 THEN TO_CHAR(l12.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 5 THEN TO_CHAR(l12.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 6 THEN TO_CHAR(l12.FEDERAL_FUND_TIME_FRAME)
WHEN 7 THEN TO_CHAR(l12.FEDERAL_APPORTIONMENT_CATEGORY)
WHEN 8 THEN TO_CHAR(l3.TRX_LINE_DIST_CCID)
WHEN 9 THEN TO_CHAR(l5.DIST_SOURCE_TYPE)
WHEN 10 THEN TO_CHAR(l8.REC_ACT_TYPE)
WHEN 11 THEN TO_CHAR(l5.DIST_LINE_ID)
WHEN 12 THEN TO_CHAR(l5.DISTRIBUTION_TYPE)
WHEN 13 THEN TO_CHAR(l5.DIST_ENT_AMT)
WHEN 14 THEN TO_CHAR(l5.DIST_CURRENCY_CODE)
WHEN 15 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_DATE)
WHEN 16 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_RATE)
WHEN 17 THEN TO_CHAR(l4.DIST_CUR_CONVERSION_TYPE)
WHEN 18 THEN TO_CHAR(l4.DIST_TO_ACCTD_AMT)
WHEN 19 THEN TO_CHAR(l3.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 20 THEN TO_CHAR(l3.TRX_LINE_DIST_ID)
WHEN 21 THEN TO_CHAR(l3.TRX_DISTRIBUTION_TYPE)
WHEN 22 THEN TO_CHAR(l12.FEDERAL_ACCOUNT_VALID_FLAG)
WHEN 23 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_DATE)
WHEN 24 THEN TO_CHAR(l11.TRX_ENTITY_CODE)
WHEN 25 THEN TO_CHAR(l11.TRX_CUSTOMER_TRX_ID)
WHEN 26 THEN TO_CHAR(l5.DIST_CURRENCY_CODE_FROM)
WHEN 27 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_RATE)
WHEN 28 THEN TO_CHAR(l5.DIST_PARTY_ID)
WHEN 29 THEN TO_CHAR(l5.DIST_PARTY_SITE_ID)
WHEN 30 THEN TO_CHAR(l5.DIST_PARTY_TYPE)
WHEN 31 THEN TO_CHAR(l5.DIST_MFAR_ADDITIONAL_ENTRY)
WHEN 32 THEN TO_CHAR(l5.DIST_ENT_AMT_FROM)
WHEN 33 THEN TO_CHAR(l4.DIST_ACCTD_AMT)
WHEN 34 THEN TO_CHAR(l4.DIST_TO_CUR_CONVERSION_TYPE)
WHEN 35 THEN TO_CHAR(l5.DIST_SOURCE_TABLE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V l1
, AR_CUST_TRX_LINES_L_V l3
, AR_DISTRIBUTIONS_BASE_V l4
, AR_DISTRIBUTIONS_L_V l5
, AR_RECEIVABLES_TRX_ACT_S_V l8
, AR_TRANSACTIONS_S_V l11
, FV_XLA_AR_REF_V l12
, (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l4.event_id = xet.event_id
AND l1.event_id (+) = l4.event_id
AND l1.line_number (+) = l4.line_number
AND l3.event_id (+) = l4.event_id
AND l3.line_number (+) = l4.line_number
AND l5.event_id = l4.event_id
AND l5.line_number = l4.line_number
AND l8.event_id (+) = l4.event_id
AND l8.line_number (+) = l4.line_number
AND l11.event_id (+) = l4.event_id
AND l11.line_number (+) = l4.line_number
AND l12.federal_event_id (+) = l5.event_id and l12.federal_line_number (+) = l5.line_number
)
;
(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_146'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000009_PKG.insert_sources_146');
END insert_sources_146;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h9.RMT_BNK_BANK_CHARGES_CCID source_1
, h9.RMT_BNK_CONFIRMATION_CCID source_3
, h9.RMT_BNK_EARNED_CCID source_4
, h9.RMT_BNK_CASH_CCID source_5
, h9.RMT_BNK_REMITTANCE_CCID source_6
, h9.RMT_BNK_UNEARNED_CCID source_7
, h9.RMT_BNK_UNAPPLIED_CCID source_18
, h10.CODE_COMBINATION_ID_GAIN source_19
, h10.CODE_COMBINATION_ID_LOSS source_20
, h2.RCT_XLA_APPLIED_TO_APP_ID source_60
, h6.RCT_CLASS_REMIT_FLAG source_72
, h6.RCT_CLASS_CONFIRM_FLAG source_73
, h2.RCT_PAY_FROM_CUSTOMER source_78
, h7.RCT_SITE_SITE_USE_ID source_79
, h2.RCT_APP_STATUS source_80
, h2.RCT_DOC_SEQUENCE_CATEGORY source_88
, h2.RCT_DOC_SEQUENCE_ID source_89
, h2.RCT_DOC_SEQUENCE_VALUE source_90
, h2.RCT_TRX_ACCT_REVERSAL source_91
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h2
, AR_RCT_METHOD_H_V h6
, AR_RCT_SITE_USES_H_V h7
, AR_REMIT_BANK_ACCT_H_V h9
, AR_SYSTEM_PARAM_H_V h10
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 h6.event_id (+) = h2.event_id
AND h7.event_id (+) = h2.event_id
AND h9.event_id (+) = h2.event_id
AND h10.event_id (+) = h2.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l4.LINE_NUMBER
, l5.DIST_CODE_COMBINATION_ID source_10
, l1.BILL_CUSTOMER_CLASS_CODE source_12
, l12.FEDERAL_ACCOUNT_RULE source_13
, l12.FEDERAL_FUND_EXPIRED_STATUS source_14
, l12.FEDERAL_PRIOR_YEAR_FLAG source_15
, l12.FEDERAL_FUND_TIME_FRAME source_16
, l12.FEDERAL_APPORTIONMENT_CATEGORY source_17
, l3.TRX_LINE_DIST_CCID source_21
, l5.DIST_SOURCE_TYPE source_22
, l8.REC_ACT_TYPE source_23
, l5.DIST_LINE_ID source_24
, l5.DISTRIBUTION_TYPE source_25
, l5.DIST_ENT_AMT source_26
, l5.DIST_CURRENCY_CODE source_27
, l4.DIST_CUR_CONVERSION_DATE source_28
, l4.DIST_CUR_CONVERSION_RATE source_29
, l4.DIST_CUR_CONVERSION_TYPE source_30
, l4.DIST_TO_ACCTD_AMT source_31
, l3.TRX_LINE_DIST_ACCOUNT_CLASS source_35
, l3.TRX_LINE_DIST_ID source_36
, l3.TRX_DISTRIBUTION_TYPE source_37
, l12.FEDERAL_ACCOUNT_VALID_FLAG source_58
, l4.DIST_TO_CUR_CONVERSION_DATE source_59
, l11.TRX_ENTITY_CODE source_61
, l11.TRX_CUSTOMER_TRX_ID source_62
, l5.DIST_CURRENCY_CODE_FROM source_63
, l4.DIST_TO_CUR_CONVERSION_RATE source_64
, l5.DIST_PARTY_ID source_65
, l5.DIST_PARTY_SITE_ID source_66
, l5.DIST_PARTY_TYPE source_67
, l5.DIST_MFAR_ADDITIONAL_ENTRY source_71
, l5.DIST_ENT_AMT_FROM source_74
, l4.DIST_ACCTD_AMT source_75
, l4.DIST_TO_CUR_CONVERSION_TYPE source_76
, l5.DIST_SOURCE_TABLE source_77
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V l1
, AR_CUST_TRX_LINES_L_V l3
, AR_DISTRIBUTIONS_BASE_V l4
, AR_DISTRIBUTIONS_L_V l5
, AR_RECEIVABLES_TRX_ACT_S_V l8
, AR_TRANSACTIONS_S_V l11
, FV_XLA_AR_REF_V l12
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id
AND l1.event_id (+) = l4.event_id
AND l1.line_number (+) = l4.line_number
AND l3.event_id (+) = l4.event_id
AND l3.line_number (+) = l4.line_number
AND l5.event_id = l4.event_id
AND l5.line_number = l4.line_number
AND l8.event_id (+) = l4.event_id
AND l8.line_number (+) = l4.line_number
AND l11.event_id (+) = l4.event_id
AND l11.line_number (+) = l4.line_number
AND l12.federal_event_id (+) = l5.event_id AND l12.federal_line_number (+) = l5.line_number;
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_138(
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_139(
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_140(
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_141(
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_142(
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_143(
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_144(
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_145(
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_146(
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
);