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_136(
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_136';
(p_msg => 'BEGIN of insert_sources_136'
,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_136'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_136');
END insert_sources_136;
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_16
, h6.REC_ACT_TYPE source_21
, h2.BILL_CUST_ACCOUNT_ID source_30
, h3.BILL_USES_SITE_USE_ID source_31
, h7.XLA_PARTY_TYPE source_32
, h1.ADJ_DOC_SEQUENCE_CATEGORY source_79
, h1.ADJ_DOC_SEQUENCE_ID source_80
, h1.ADJ_DOC_SEQUENCE_VALUE source_81
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_3
, l5.DIST_SOURCE_TYPE source_20
, l5.DIST_LINE_ID source_22
, l5.DISTRIBUTION_TYPE source_23
, l5.DIST_ENT_AMT source_24
, l5.DIST_CURRENCY_CODE source_25
, l4.DIST_CUR_CONVERSION_DATE source_26
, l4.DIST_CUR_CONVERSION_RATE source_27
, l4.DIST_CUR_CONVERSION_TYPE source_28
, l4.DIST_TO_ACCTD_AMT source_29
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_137(
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_137';
(p_msg => 'BEGIN of insert_sources_137'
,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_137'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_137');
END insert_sources_137;
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_30
, h2.BILL_USES_SITE_USE_ID source_31
, h5.XLA_PARTY_TYPE source_32
, h5.TRX_INVOICE_CURRENCY_CODE source_37
, h5.TRX_DOC_SEQUENCE_CATEGORY source_83
, h5.TRX_DOC_SEQUENCE_ID source_84
, h5.TRX_DOC_SEQUENCE_VALUE source_85
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_4
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l4.TRX_LINE_DIST_ID source_34
, l4.TRX_DISTRIBUTION_TYPE source_35
, l4.TRX_LINE_DIST_AMT source_36
, l3.TRX_LINE_CUR_CONVERSION_DATE source_38
, l3.TRX_LINE_CUR_CONVERSION_RATE source_39
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
, l3.TRX_LINE_ACCTD_AMT source_41
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_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) := 'CREDIT_MEMO_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_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_138'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_138');
END insert_sources_138;
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_12
, h8.CODE_COMBINATION_ID_GAIN source_18
, h8.CODE_COMBINATION_ID_LOSS source_19
, h5.XLA_PARTY_TYPE source_32
, h5.CM_INVOICE_CURRENCY_CODE source_44
, h2.CM_BILL_CUST_ACCOUNT_ID source_50
, h1.CM_BILL_USES_SITE_USE_ID source_51
, h5.CM_INVOICING_RULE_ID source_67
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_2
, l6.DIST_CODE_COMBINATION_ID source_3
, l6.DIST_SOURCE_TYPE source_20
, l7.REC_ACT_TYPE source_21
, l6.DIST_ENT_AMT source_24
, l3.CM_DIST_IDENTIFER source_42
, l3.CM_DIST_TYPE source_43
, l3.CM_LINE_CUR_CONVERSION_DATE source_45
, l3.CM_LINE_CUR_CONVERSION_RATE source_46
, l3.CM_LINE_CUR_CONVERSION_TYPE source_47
, l3.GAIN_LOSS_REF source_48
, l3.CM_LINE_ACCTD_AMT source_49
, l4.CM_TAX_LINE_ID source_52
, l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
, l4.CM_LINE_DIST_AMT source_54
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_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) := 'DEBIT_MEMO_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_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_139'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_139');
END insert_sources_139;
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_16
, h1.BILL_CUST_ACCOUNT_ID source_30
, h2.BILL_USES_SITE_USE_ID source_31
, h5.XLA_PARTY_TYPE source_32
, h5.TRX_INVOICE_CURRENCY_CODE source_37
, h5.TRX_INVOICING_RULE_ID source_68
, h5.TRX_DOC_SEQUENCE_CATEGORY source_83
, h5.TRX_DOC_SEQUENCE_ID source_84
, h5.TRX_DOC_SEQUENCE_VALUE source_85
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_4
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l4.TRX_LINE_DIST_ID source_34
, l4.TRX_DISTRIBUTION_TYPE source_35
, l4.TRX_LINE_DIST_AMT source_36
, l3.TRX_LINE_CUR_CONVERSION_DATE source_38
, l3.TRX_LINE_CUR_CONVERSION_RATE source_39
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
, l3.TRX_LINE_ACCTD_AMT source_41
, l4.TRX_TAX_LINE_ID source_55
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) := 'DEPOSIT_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_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_140'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_140');
END insert_sources_140;
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_30
, h2.BILL_USES_SITE_USE_ID source_31
, h5.XLA_PARTY_TYPE source_32
, h5.TRX_INVOICE_CURRENCY_CODE source_37
, h5.TRX_DOC_SEQUENCE_CATEGORY source_83
, h5.TRX_DOC_SEQUENCE_ID source_84
, h5.TRX_DOC_SEQUENCE_VALUE source_85
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_4
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l4.TRX_LINE_DIST_ID source_34
, l4.TRX_DISTRIBUTION_TYPE source_35
, l4.TRX_LINE_DIST_AMT source_36
, l3.TRX_LINE_CUR_CONVERSION_DATE source_38
, l3.TRX_LINE_CUR_CONVERSION_RATE source_39
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
, l3.TRX_LINE_ACCTD_AMT source_41
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_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) := 'GUARANTEE_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_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_141'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_141');
END insert_sources_141;
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_30
, h2.BILL_USES_SITE_USE_ID source_31
, h5.XLA_PARTY_TYPE source_32
, h5.TRX_INVOICE_CURRENCY_CODE source_37
, h5.TRX_DOC_SEQUENCE_CATEGORY source_83
, h5.TRX_DOC_SEQUENCE_ID source_84
, h5.TRX_DOC_SEQUENCE_VALUE source_85
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_4
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l4.TRX_LINE_DIST_ID source_34
, l4.TRX_DISTRIBUTION_TYPE source_35
, l4.TRX_LINE_DIST_AMT source_36
, l3.TRX_LINE_CUR_CONVERSION_DATE source_38
, l3.TRX_LINE_CUR_CONVERSION_RATE source_39
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
, l3.TRX_LINE_ACCTD_AMT source_41
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) := 'INVOICE_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_TRANSACTIONS_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 'BILL_CUSTOMER_CLASS_CODE'
WHEN 2 THEN 'TRX_RECEIVABLE_CCID'
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(h1.BILL_CUSTOMER_CLASS_CODE)
WHEN 2 THEN TO_CHAR(h5.TRX_RECEIVABLE_CCID)
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 'AR_CUST_TRX_LINES_L_V'
WHEN 2 THEN 'FV_XLA_AR_REF_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 '222'
WHEN 2 THEN '8901'
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 'TRX_LINE_DIST_CCID'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
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(l4.TRX_LINE_DIST_CCID)
WHEN 2 THEN TO_CHAR(l6.FEDERAL_FUND_CATEGORY)
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_142'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_142');
END insert_sources_142;
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
, h1.BILL_CUSTOMER_CLASS_CODE source_6
, h5.TRX_RECEIVABLE_CCID source_16
, h1.BILL_CUST_ACCOUNT_ID source_30
, h2.BILL_USES_SITE_USE_ID source_31
, h5.XLA_PARTY_TYPE source_32
, h5.TRX_INVOICE_CURRENCY_CODE source_37
, h5.TRX_INVOICING_RULE_ID source_68
, h5.TRX_DOC_SEQUENCE_CATEGORY source_83
, h5.TRX_DOC_SEQUENCE_ID source_84
, h5.TRX_DOC_SEQUENCE_VALUE source_85
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
, l4.TRX_LINE_DIST_CCID source_4
, l6.FEDERAL_FUND_CATEGORY source_5
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l4.TRX_LINE_DIST_ID source_34
, l4.TRX_DISTRIBUTION_TYPE source_35
, l4.TRX_LINE_DIST_AMT source_36
, l3.TRX_LINE_CUR_CONVERSION_DATE source_38
, l3.TRX_LINE_CUR_CONVERSION_RATE source_39
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
, l3.TRX_LINE_ACCTD_AMT source_41
, l4.TRX_TAX_LINE_ID source_55
, l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
, l3.ROUNDING_CORRECTION_FLAG source_66
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_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) := 'MISC_RECEIPT_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_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_CASH_CCID'
WHEN 3 THEN 'RMT_BNK_CONFIRMATION_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_CASH_CCID)
WHEN 3 THEN TO_CHAR(h5.RMT_BNK_CONFIRMATION_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_143'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_143');
END insert_sources_143;
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_CASH_CCID source_13
, h5.RMT_BNK_CONFIRMATION_CCID source_14
, h5.RMT_BNK_REMITTANCE_CCID source_15
, h4.RCT_CLASS_REMIT_FLAG source_70
, h4.RCT_CLASS_CONFIRM_FLAG source_71
, h1.RCT_DOC_SEQUENCE_CATEGORY source_86
, h1.RCT_DOC_SEQUENCE_ID source_87
, h1.RCT_DOC_SEQUENCE_VALUE source_88
, h1.RCT_TRX_ACCT_REVERSAL source_89
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_3
, l6.FEDERAL_FUND_CATEGORY source_5
, l6.FEDERAL_FUND_EXPIRED_STATUS source_8
, l6.FEDERAL_PRIOR_YEAR_FLAG source_9
, l6.FEDERAL_FUND_TIME_FRAME source_10
, l6.FEDERAL_APPORTIONMENT_CATEGORY source_11
, l3.DIST_SOURCE_TYPE source_20
, l3.DIST_LINE_ID source_22
, l3.DISTRIBUTION_TYPE source_23
, l3.DIST_ENT_AMT source_24
, l3.DIST_CURRENCY_CODE source_25
, l2.DIST_CUR_CONVERSION_RATE source_27
, l2.DIST_CUR_CONVERSION_TYPE source_28
, l2.DIST_TO_ACCTD_AMT source_29
, l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
, l2.DIST_TO_CUR_CONVERSION_DATE source_57
, l3.DIST_MFAR_ADDITIONAL_ENTRY source_69
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_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) := 'RECEIPT_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_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_SYSTEM_PARAM_H_V'
WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 9 THEN 'AR_RCT_METHOD_H_V'
WHEN 10 THEN 'AR_RCT_METHOD_H_V'
WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 12 THEN 'AR_RCT_SITE_USES_H_V'
WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 14 THEN 'AR_CASH_RECEIPTS_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'
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'
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'
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_CASH_CCID'
WHEN 3 THEN 'RMT_BNK_CONFIRMATION_CCID'
WHEN 4 THEN 'RMT_BNK_REMITTANCE_CCID'
WHEN 5 THEN 'RMT_BNK_UNAPPLIED_CCID'
WHEN 6 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 7 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 8 THEN 'RCT_XLA_APPLIED_TO_APP_ID'
WHEN 9 THEN 'RCT_CLASS_REMIT_FLAG'
WHEN 10 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 11 THEN 'RCT_PAY_FROM_CUSTOMER'
WHEN 12 THEN 'RCT_SITE_SITE_USE_ID'
WHEN 13 THEN 'RCT_APP_STATUS'
WHEN 14 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 15 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 16 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 17 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_CASH_CCID)
WHEN 3 THEN TO_CHAR(h9.RMT_BNK_CONFIRMATION_CCID)
WHEN 4 THEN TO_CHAR(h9.RMT_BNK_REMITTANCE_CCID)
WHEN 5 THEN TO_CHAR(h9.RMT_BNK_UNAPPLIED_CCID)
WHEN 6 THEN TO_CHAR(h10.CODE_COMBINATION_ID_GAIN)
WHEN 7 THEN TO_CHAR(h10.CODE_COMBINATION_ID_LOSS)
WHEN 8 THEN TO_CHAR(h2.RCT_XLA_APPLIED_TO_APP_ID)
WHEN 9 THEN TO_CHAR(h6.RCT_CLASS_REMIT_FLAG)
WHEN 10 THEN TO_CHAR(h6.RCT_CLASS_CONFIRM_FLAG)
WHEN 11 THEN TO_CHAR(h2.RCT_PAY_FROM_CUSTOMER)
WHEN 12 THEN TO_CHAR(h7.RCT_SITE_SITE_USE_ID)
WHEN 13 THEN TO_CHAR(h2.RCT_APP_STATUS)
WHEN 14 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 15 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_ID)
WHEN 16 THEN TO_CHAR(h2.RCT_DOC_SEQUENCE_VALUE)
WHEN 17 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 <= 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 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_CUST_TRX_LINES_L_V'
WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_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 'FV_XLA_AR_REF_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 '222'
WHEN 4 THEN '8901'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '8901'
WHEN 8 THEN '8901'
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 'TRX_LINE_DIST_CCID'
WHEN 3 THEN 'BILL_CUSTOMER_CLASS_CODE'
WHEN 4 THEN 'FEDERAL_ACCOUNT_RULE'
WHEN 5 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 6 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 7 THEN 'FEDERAL_FUND_TIME_FRAME'
WHEN 8 THEN 'FEDERAL_APPORTIONMENT_CATEGORY'
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(l3.TRX_LINE_DIST_CCID)
WHEN 3 THEN TO_CHAR(l1.BILL_CUSTOMER_CLASS_CODE)
WHEN 4 THEN TO_CHAR(l12.FEDERAL_ACCOUNT_RULE)
WHEN 5 THEN TO_CHAR(l12.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 6 THEN TO_CHAR(l12.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 7 THEN TO_CHAR(l12.FEDERAL_FUND_TIME_FRAME)
WHEN 8 THEN TO_CHAR(l12.FEDERAL_APPORTIONMENT_CATEGORY)
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_144'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000006_PKG.insert_sources_144');
END insert_sources_144;
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_CASH_CCID source_13
, h9.RMT_BNK_CONFIRMATION_CCID source_14
, h9.RMT_BNK_REMITTANCE_CCID source_15
, h9.RMT_BNK_UNAPPLIED_CCID source_17
, h10.CODE_COMBINATION_ID_GAIN source_18
, h10.CODE_COMBINATION_ID_LOSS source_19
, h2.RCT_XLA_APPLIED_TO_APP_ID source_58
, h6.RCT_CLASS_REMIT_FLAG source_70
, h6.RCT_CLASS_CONFIRM_FLAG source_71
, h2.RCT_PAY_FROM_CUSTOMER source_76
, h7.RCT_SITE_SITE_USE_ID source_77
, h2.RCT_APP_STATUS source_78
, h2.RCT_DOC_SEQUENCE_CATEGORY source_86
, h2.RCT_DOC_SEQUENCE_ID source_87
, h2.RCT_DOC_SEQUENCE_VALUE source_88
, h2.RCT_TRX_ACCT_REVERSAL source_89
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_3
, l3.TRX_LINE_DIST_CCID source_4
, l1.BILL_CUSTOMER_CLASS_CODE source_6
, l12.FEDERAL_ACCOUNT_RULE source_7
, l12.FEDERAL_FUND_EXPIRED_STATUS source_8
, l12.FEDERAL_PRIOR_YEAR_FLAG source_9
, l12.FEDERAL_FUND_TIME_FRAME source_10
, l12.FEDERAL_APPORTIONMENT_CATEGORY source_11
, l5.DIST_SOURCE_TYPE source_20
, l8.REC_ACT_TYPE source_21
, l5.DIST_LINE_ID source_22
, l5.DISTRIBUTION_TYPE source_23
, l5.DIST_ENT_AMT source_24
, l5.DIST_CURRENCY_CODE source_25
, l4.DIST_CUR_CONVERSION_DATE source_26
, l4.DIST_CUR_CONVERSION_RATE source_27
, l4.DIST_CUR_CONVERSION_TYPE source_28
, l4.DIST_TO_ACCTD_AMT source_29
, l3.TRX_LINE_DIST_ACCOUNT_CLASS source_33
, l3.TRX_LINE_DIST_ID source_34
, l3.TRX_DISTRIBUTION_TYPE source_35
, l12.FEDERAL_ACCOUNT_VALID_FLAG source_56
, l4.DIST_TO_CUR_CONVERSION_DATE source_57
, l11.TRX_ENTITY_CODE source_59
, l11.TRX_CUSTOMER_TRX_ID source_60
, l5.DIST_CURRENCY_CODE_FROM source_61
, l4.DIST_TO_CUR_CONVERSION_RATE source_62
, l5.DIST_PARTY_ID source_63
, l5.DIST_PARTY_SITE_ID source_64
, l5.DIST_PARTY_TYPE source_65
, l5.DIST_MFAR_ADDITIONAL_ENTRY source_69
, l5.DIST_ENT_AMT_FROM source_72
, l4.DIST_ACCTD_AMT source_73
, l4.DIST_TO_CUR_CONVERSION_TYPE source_74
, l5.DIST_SOURCE_TABLE source_75
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_136(
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_137(
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_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
);