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);
PROCEDURE insert_sources_102(
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_102';
(p_msg => 'BEGIN of insert_sources_102'
,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_102'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_102');
END insert_sources_102;
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_9
, h6.REC_ACT_TYPE source_14
, h2.BILL_CUST_ACCOUNT_ID source_23
, h3.BILL_USES_SITE_USE_ID source_24
, h7.XLA_PARTY_TYPE source_25
, h1.ADJ_DOC_SEQUENCE_CATEGORY source_71
, h1.ADJ_DOC_SEQUENCE_ID source_72
, h1.ADJ_DOC_SEQUENCE_VALUE source_73
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_13
, l5.DIST_LINE_ID source_15
, l5.DISTRIBUTION_TYPE source_16
, l5.DIST_ENT_AMT source_17
, l5.DIST_CURRENCY_CODE source_18
, l4.DIST_CUR_CONVERSION_DATE source_19
, l4.DIST_CUR_CONVERSION_RATE source_20
, l4.DIST_CUR_CONVERSION_TYPE source_21
, l4.DIST_TO_ACCTD_AMT source_22
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_103(
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_103';
(p_msg => 'BEGIN of insert_sources_103'
,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_103'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_103');
END insert_sources_103;
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_23
, h2.BILL_USES_SITE_USE_ID source_24
, h5.XLA_PARTY_TYPE source_25
, h5.TRX_INVOICE_CURRENCY_CODE source_30
, h5.TRX_DOC_SEQUENCE_CATEGORY source_75
, h5.TRX_DOC_SEQUENCE_ID source_76
, h5.TRX_DOC_SEQUENCE_VALUE source_77
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_26
, l4.TRX_LINE_DIST_ID source_27
, l4.TRX_DISTRIBUTION_TYPE source_28
, l4.TRX_LINE_DIST_AMT source_29
, l3.TRX_LINE_CUR_CONVERSION_DATE source_31
, l3.TRX_LINE_CUR_CONVERSION_RATE source_32
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
, l3.TRX_LINE_ACCTD_AMT source_34
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_104(
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_104';
(p_msg => 'BEGIN of insert_sources_104'
,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_104'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_104');
END insert_sources_104;
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_5
, h8.CODE_COMBINATION_ID_GAIN source_11
, h8.CODE_COMBINATION_ID_LOSS source_12
, h5.XLA_PARTY_TYPE source_25
, h5.CM_INVOICE_CURRENCY_CODE source_37
, h2.CM_BILL_CUST_ACCOUNT_ID source_43
, h1.CM_BILL_USES_SITE_USE_ID source_44
, h5.CM_INVOICING_RULE_ID source_50
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_13
, l7.REC_ACT_TYPE source_14
, l6.DIST_ENT_AMT source_17
, l3.CM_DIST_IDENTIFER source_35
, l3.CM_DIST_TYPE source_36
, l3.CM_LINE_CUR_CONVERSION_DATE source_38
, l3.CM_LINE_CUR_CONVERSION_RATE source_39
, l3.CM_LINE_CUR_CONVERSION_TYPE source_40
, l3.GAIN_LOSS_REF source_41
, l3.CM_LINE_ACCTD_AMT source_42
, l4.CM_TAX_LINE_ID source_45
, l4.CM_LINE_DIST_ACCOUNT_CLASS source_46
, l4.CM_LINE_DIST_AMT source_47
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_105(
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_105';
(p_msg => 'BEGIN of insert_sources_105'
,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_105'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_105');
END insert_sources_105;
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_9
, h1.BILL_CUST_ACCOUNT_ID source_23
, h2.BILL_USES_SITE_USE_ID source_24
, h5.XLA_PARTY_TYPE source_25
, h5.TRX_INVOICE_CURRENCY_CODE source_30
, h5.TRX_INVOICING_RULE_ID source_51
, h5.TRX_DOC_SEQUENCE_CATEGORY source_75
, h5.TRX_DOC_SEQUENCE_ID source_76
, h5.TRX_DOC_SEQUENCE_VALUE source_77
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_26
, l4.TRX_LINE_DIST_ID source_27
, l4.TRX_DISTRIBUTION_TYPE source_28
, l4.TRX_LINE_DIST_AMT source_29
, l3.TRX_LINE_CUR_CONVERSION_DATE source_31
, l3.TRX_LINE_CUR_CONVERSION_RATE source_32
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
, l3.TRX_LINE_ACCTD_AMT source_34
, l4.TRX_TAX_LINE_ID source_48
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_106(
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_106';
(p_msg => 'BEGIN of insert_sources_106'
,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_106'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_106');
END insert_sources_106;
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_23
, h2.BILL_USES_SITE_USE_ID source_24
, h5.XLA_PARTY_TYPE source_25
, h5.TRX_INVOICE_CURRENCY_CODE source_30
, h5.TRX_DOC_SEQUENCE_CATEGORY source_75
, h5.TRX_DOC_SEQUENCE_ID source_76
, h5.TRX_DOC_SEQUENCE_VALUE source_77
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_26
, l4.TRX_LINE_DIST_ID source_27
, l4.TRX_DISTRIBUTION_TYPE source_28
, l4.TRX_LINE_DIST_AMT source_29
, l3.TRX_LINE_CUR_CONVERSION_DATE source_31
, l3.TRX_LINE_CUR_CONVERSION_RATE source_32
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
, l3.TRX_LINE_ACCTD_AMT source_34
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_107(
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_107';
(p_msg => 'BEGIN of insert_sources_107'
,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_107'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_107');
END insert_sources_107;
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_23
, h2.BILL_USES_SITE_USE_ID source_24
, h5.XLA_PARTY_TYPE source_25
, h5.TRX_INVOICE_CURRENCY_CODE source_30
, h5.TRX_DOC_SEQUENCE_CATEGORY source_75
, h5.TRX_DOC_SEQUENCE_ID source_76
, h5.TRX_DOC_SEQUENCE_VALUE source_77
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_26
, l4.TRX_LINE_DIST_ID source_27
, l4.TRX_DISTRIBUTION_TYPE source_28
, l4.TRX_LINE_DIST_AMT source_29
, l3.TRX_LINE_CUR_CONVERSION_DATE source_31
, l3.TRX_LINE_CUR_CONVERSION_RATE source_32
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
, l3.TRX_LINE_ACCTD_AMT source_34
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_108(
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_108';
(p_msg => 'BEGIN of insert_sources_108'
,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'
WHEN 11 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'
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'
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'
WHEN 11 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(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)
WHEN 11 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
, (select rownum r from all_objects where rownum <= 11 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_108'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_108');
END insert_sources_108;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.TRX_RECEIVABLE_CCID source_9
, h1.BILL_CUST_ACCOUNT_ID source_23
, h2.BILL_USES_SITE_USE_ID source_24
, h5.XLA_PARTY_TYPE source_25
, h5.TRX_INVOICE_CURRENCY_CODE source_30
, h5.TRX_INVOICING_RULE_ID source_51
, h5.TRX_DOC_SEQUENCE_CATEGORY source_75
, h5.TRX_DOC_SEQUENCE_ID source_76
, h5.TRX_DOC_SEQUENCE_VALUE source_77
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
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_26
, l4.TRX_LINE_DIST_ID source_27
, l4.TRX_DISTRIBUTION_TYPE source_28
, l4.TRX_LINE_DIST_AMT source_29
, l3.TRX_LINE_CUR_CONVERSION_DATE source_31
, l3.TRX_LINE_CUR_CONVERSION_RATE source_32
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
, l3.TRX_LINE_ACCTD_AMT source_34
, l4.TRX_TAX_LINE_ID source_48
, l3.ROUNDING_CORRECTION_FLAG source_49
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_109(
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_109';
(p_msg => 'BEGIN of insert_sources_109'
,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 '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_L_V'
WHEN 11 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'
WHEN 11 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'
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_RATE'
WHEN 8 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 9 THEN 'DIST_TO_ACCTD_AMT'
WHEN 10 THEN 'DIST_MFAR_ADDITIONAL_ENTRY'
WHEN 11 THEN 'DIST_TO_CUR_CONVERSION_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l3.DIST_SOURCE_TYPE)
WHEN 3 THEN TO_CHAR(l3.DIST_LINE_ID)
WHEN 4 THEN TO_CHAR(l3.DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l3.DIST_ENT_AMT)
WHEN 6 THEN TO_CHAR(l3.DIST_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_RATE)
WHEN 8 THEN TO_CHAR(l2.DIST_CUR_CONVERSION_TYPE)
WHEN 9 THEN TO_CHAR(l2.DIST_TO_ACCTD_AMT)
WHEN 10 THEN TO_CHAR(l3.DIST_MFAR_ADDITIONAL_ENTRY)
WHEN 11 THEN TO_CHAR(l2.DIST_TO_CUR_CONVERSION_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l2
, AR_DISTRIBUTIONS_L_V l3
, (select rownum r from all_objects where rownum <= 11 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
)
;
(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_109'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_109');
END insert_sources_109;
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_6
, h5.RMT_BNK_CONFIRMATION_CCID source_7
, h5.RMT_BNK_REMITTANCE_CCID source_8
, h4.RCT_CLASS_REMIT_FLAG source_54
, h4.RCT_CLASS_CONFIRM_FLAG source_55
, h1.RCT_DOC_SEQUENCE_CATEGORY source_78
, h1.RCT_DOC_SEQUENCE_ID source_79
, h1.RCT_DOC_SEQUENCE_VALUE source_80
, h1.RCT_TRX_ACCT_REVERSAL source_81
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
, l3.DIST_SOURCE_TYPE source_13
, l3.DIST_LINE_ID source_15
, l3.DISTRIBUTION_TYPE source_16
, l3.DIST_ENT_AMT source_17
, l3.DIST_CURRENCY_CODE source_18
, l2.DIST_CUR_CONVERSION_RATE source_20
, l2.DIST_CUR_CONVERSION_TYPE source_21
, l2.DIST_TO_ACCTD_AMT source_22
, l3.DIST_MFAR_ADDITIONAL_ENTRY source_52
, l2.DIST_TO_CUR_CONVERSION_DATE source_53
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l2
, AR_DISTRIBUTIONS_L_V l3
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l3.event_id = l2.event_id
AND l3.line_number = l2.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_110(
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_110';
(p_msg => 'BEGIN of insert_sources_110'
,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_RCT_METHOD_H_V'
WHEN 9 THEN 'AR_RCT_METHOD_H_V'
WHEN 10 THEN 'AR_CASH_RECEIPTS_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_CLASS_REMIT_FLAG'
WHEN 9 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 10 THEN 'RCT_XLA_APPLIED_TO_APP_ID'
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(h8.RMT_BNK_BANK_CHARGES_CCID)
WHEN 2 THEN TO_CHAR(h8.RMT_BNK_CASH_CCID)
WHEN 3 THEN TO_CHAR(h8.RMT_BNK_CONFIRMATION_CCID)
WHEN 4 THEN TO_CHAR(h8.RMT_BNK_REMITTANCE_CCID)
WHEN 5 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
WHEN 6 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
WHEN 7 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
WHEN 8 THEN TO_CHAR(h5.RCT_CLASS_REMIT_FLAG)
WHEN 9 THEN TO_CHAR(h5.RCT_CLASS_CONFIRM_FLAG)
WHEN 10 THEN TO_CHAR(h1.RCT_XLA_APPLIED_TO_APP_ID)
WHEN 11 THEN TO_CHAR(h1.RCT_PAY_FROM_CUSTOMER)
WHEN 12 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
WHEN 13 THEN TO_CHAR(h1.RCT_APP_STATUS)
WHEN 14 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 15 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
WHEN 16 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 17 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 h5
, AR_RCT_SITE_USES_H_V h6
, AR_REMIT_BANK_ACCT_H_V h8
, AR_SYSTEM_PARAM_H_V h9
,(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 h1.event_id = xet.event_id
AND h5.event_id (+) = h1.event_id
AND h6.event_id (+) = h1.event_id
AND h8.event_id (+) = h1.event_id
AND h9.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_DISTRIBUTIONS_L_V'
WHEN 2 THEN 'AR_CUST_TRX_LINES_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_DISTRIBUTIONS_L_V'
WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
WHEN 19 THEN 'AR_TRANSACTIONS_S_V'
WHEN 20 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 21 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 22 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 23 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 24 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 25 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 27 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 28 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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
WHEN 18 THEN '222'
WHEN 19 THEN '222'
WHEN 20 THEN '222'
WHEN 21 THEN '222'
WHEN 22 THEN '222'
WHEN 23 THEN '222'
WHEN 24 THEN '222'
WHEN 25 THEN '222'
WHEN 26 THEN '222'
WHEN 27 THEN '222'
WHEN 28 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 'DIST_SOURCE_TYPE'
WHEN 4 THEN 'REC_ACT_TYPE'
WHEN 5 THEN 'DIST_LINE_ID'
WHEN 6 THEN 'DISTRIBUTION_TYPE'
WHEN 7 THEN 'DIST_ENT_AMT'
WHEN 8 THEN 'DIST_CURRENCY_CODE'
WHEN 9 THEN 'DIST_CUR_CONVERSION_DATE'
WHEN 10 THEN 'DIST_CUR_CONVERSION_RATE'
WHEN 11 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 12 THEN 'DIST_TO_ACCTD_AMT'
WHEN 13 THEN 'TRX_LINE_DIST_ACCOUNT_CLASS'
WHEN 14 THEN 'TRX_LINE_DIST_ID'
WHEN 15 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 16 THEN 'DIST_MFAR_ADDITIONAL_ENTRY'
WHEN 17 THEN 'DIST_TO_CUR_CONVERSION_DATE'
WHEN 18 THEN 'TRX_ENTITY_CODE'
WHEN 19 THEN 'TRX_CUSTOMER_TRX_ID'
WHEN 20 THEN 'DIST_ENT_AMT_FROM'
WHEN 21 THEN 'DIST_CURRENCY_CODE_FROM'
WHEN 22 THEN 'DIST_ACCTD_AMT'
WHEN 23 THEN 'DIST_PARTY_ID'
WHEN 24 THEN 'DIST_PARTY_SITE_ID'
WHEN 25 THEN 'DIST_PARTY_TYPE'
WHEN 26 THEN 'DIST_TO_CUR_CONVERSION_TYPE'
WHEN 27 THEN 'DIST_TO_CUR_CONVERSION_RATE'
WHEN 28 THEN 'DIST_SOURCE_TABLE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.TRX_LINE_DIST_CCID)
WHEN 3 THEN TO_CHAR(l4.DIST_SOURCE_TYPE)
WHEN 4 THEN TO_CHAR(l7.REC_ACT_TYPE)
WHEN 5 THEN TO_CHAR(l4.DIST_LINE_ID)
WHEN 6 THEN TO_CHAR(l4.DISTRIBUTION_TYPE)
WHEN 7 THEN TO_CHAR(l4.DIST_ENT_AMT)
WHEN 8 THEN TO_CHAR(l4.DIST_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_DATE)
WHEN 10 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_RATE)
WHEN 11 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_TYPE)
WHEN 12 THEN TO_CHAR(l3.DIST_TO_ACCTD_AMT)
WHEN 13 THEN TO_CHAR(l2.TRX_LINE_DIST_ACCOUNT_CLASS)
WHEN 14 THEN TO_CHAR(l2.TRX_LINE_DIST_ID)
WHEN 15 THEN TO_CHAR(l2.TRX_DISTRIBUTION_TYPE)
WHEN 16 THEN TO_CHAR(l4.DIST_MFAR_ADDITIONAL_ENTRY)
WHEN 17 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_DATE)
WHEN 18 THEN TO_CHAR(l10.TRX_ENTITY_CODE)
WHEN 19 THEN TO_CHAR(l10.TRX_CUSTOMER_TRX_ID)
WHEN 20 THEN TO_CHAR(l4.DIST_ENT_AMT_FROM)
WHEN 21 THEN TO_CHAR(l4.DIST_CURRENCY_CODE_FROM)
WHEN 22 THEN TO_CHAR(l3.DIST_ACCTD_AMT)
WHEN 23 THEN TO_CHAR(l4.DIST_PARTY_ID)
WHEN 24 THEN TO_CHAR(l4.DIST_PARTY_SITE_ID)
WHEN 25 THEN TO_CHAR(l4.DIST_PARTY_TYPE)
WHEN 26 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_TYPE)
WHEN 27 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_RATE)
WHEN 28 THEN TO_CHAR(l4.DIST_SOURCE_TABLE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_L_V l2
, AR_DISTRIBUTIONS_BASE_V l3
, AR_DISTRIBUTIONS_L_V l4
, AR_RECEIVABLES_TRX_ACT_S_V l7
, AR_TRANSACTIONS_S_V l10
, (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l3.event_id = xet.event_id
AND l2.event_id (+) = l3.event_id
AND l2.line_number (+) = l3.line_number
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
AND l7.event_id (+) = l3.event_id
AND l7.line_number (+) = l3.line_number
AND l10.event_id (+) = l3.event_id
AND l10.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_110'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000008_PKG.insert_sources_110');
END insert_sources_110;
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
, h8.RMT_BNK_BANK_CHARGES_CCID source_1
, h8.RMT_BNK_CASH_CCID source_6
, h8.RMT_BNK_CONFIRMATION_CCID source_7
, h8.RMT_BNK_REMITTANCE_CCID source_8
, h8.RMT_BNK_UNAPPLIED_CCID source_10
, h9.CODE_COMBINATION_ID_GAIN source_11
, h9.CODE_COMBINATION_ID_LOSS source_12
, h5.RCT_CLASS_REMIT_FLAG source_54
, h5.RCT_CLASS_CONFIRM_FLAG source_55
, h1.RCT_XLA_APPLIED_TO_APP_ID source_56
, h1.RCT_PAY_FROM_CUSTOMER source_68
, h6.RCT_SITE_SITE_USE_ID source_69
, h1.RCT_APP_STATUS source_70
, h1.RCT_DOC_SEQUENCE_CATEGORY source_78
, h1.RCT_DOC_SEQUENCE_ID source_79
, h1.RCT_DOC_SEQUENCE_VALUE source_80
, h1.RCT_TRX_ACCT_REVERSAL source_81
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h1
, AR_RCT_METHOD_H_V h5
, AR_RCT_SITE_USES_H_V h6
, AR_REMIT_BANK_ACCT_H_V h8
, AR_SYSTEM_PARAM_H_V h9
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 h5.event_id (+) = h1.event_id
AND h6.event_id (+) = h1.event_id
AND h8.event_id (+) = h1.event_id
AND h9.event_id (+) = h1.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
, l3.LINE_NUMBER
, l4.DIST_CODE_COMBINATION_ID source_3
, l2.TRX_LINE_DIST_CCID source_4
, l4.DIST_SOURCE_TYPE source_13
, l7.REC_ACT_TYPE source_14
, l4.DIST_LINE_ID source_15
, l4.DISTRIBUTION_TYPE source_16
, l4.DIST_ENT_AMT source_17
, l4.DIST_CURRENCY_CODE source_18
, l3.DIST_CUR_CONVERSION_DATE source_19
, l3.DIST_CUR_CONVERSION_RATE source_20
, l3.DIST_CUR_CONVERSION_TYPE source_21
, l3.DIST_TO_ACCTD_AMT source_22
, l2.TRX_LINE_DIST_ACCOUNT_CLASS source_26
, l2.TRX_LINE_DIST_ID source_27
, l2.TRX_DISTRIBUTION_TYPE source_28
, l4.DIST_MFAR_ADDITIONAL_ENTRY source_52
, l3.DIST_TO_CUR_CONVERSION_DATE source_53
, l10.TRX_ENTITY_CODE source_57
, l10.TRX_CUSTOMER_TRX_ID source_58
, l4.DIST_ENT_AMT_FROM source_59
, l4.DIST_CURRENCY_CODE_FROM source_60
, l3.DIST_ACCTD_AMT source_61
, l4.DIST_PARTY_ID source_62
, l4.DIST_PARTY_SITE_ID source_63
, l4.DIST_PARTY_TYPE source_64
, l3.DIST_TO_CUR_CONVERSION_TYPE source_65
, l3.DIST_TO_CUR_CONVERSION_RATE source_66
, l4.DIST_SOURCE_TABLE source_67
FROM xla_events_gt xet
, AR_CUST_TRX_LINES_L_V l2
, AR_DISTRIBUTIONS_BASE_V l3
, AR_DISTRIBUTIONS_L_V l4
, AR_RECEIVABLES_TRX_ACT_S_V l7
, AR_TRANSACTIONS_S_V l10
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 l2.event_id (+) = l3.event_id
AND l2.line_number (+) = l3.line_number
AND l4.event_id = l3.event_id
AND l4.line_number = l3.line_number
AND l7.event_id (+) = l3.event_id
AND l7.line_number (+) = l3.line_number
AND l10.event_id (+) = l3.event_id
AND l10.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 ;
insert_sources_102(
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_103(
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_104(
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_105(
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_106(
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_107(
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_108(
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_109(
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_110(
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
);