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_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) := 'ADJUSTMENT_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_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_104'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_104');
END insert_sources_104;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h7.TRX_RECEIVABLE_CCID source_8
, h6.REC_ACT_TYPE source_16
, h2.BILL_CUST_ACCOUNT_ID source_25
, h3.BILL_USES_SITE_USE_ID source_26
, h7.XLA_PARTY_TYPE source_27
, h1.ADJ_DOC_SEQUENCE_CATEGORY source_73
, h1.ADJ_DOC_SEQUENCE_ID source_74
, h1.ADJ_DOC_SEQUENCE_VALUE source_75
FROM xla_events_gt xet
, AR_ADJUSTMENTS_H_V h1
, AR_BILL_TO_CUSTOMERS_S_V h2
, AR_BILL_TO_SITE_USES_S_V h3
, AR_RECEIVABLES_TRX_ACT_S_V h6
, AR_TRANSACTIONS_S_V h7
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h3.event_id = h1.event_id
AND h6.event_id (+) = h1.event_id
AND h7.event_id = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l4.LINE_NUMBER
, l5.DIST_CODE_COMBINATION_ID source_10
, l5.DIST_SOURCE_TYPE source_15
, l5.DIST_LINE_ID source_17
, l5.DISTRIBUTION_TYPE source_18
, l5.DIST_ENT_AMT source_19
, l5.DIST_CURRENCY_CODE source_20
, l4.DIST_CUR_CONVERSION_DATE source_21
, l4.DIST_CUR_CONVERSION_RATE source_22
, l4.DIST_CUR_CONVERSION_TYPE source_23
, l4.DIST_TO_ACCTD_AMT source_24
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_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) := 'CHARGEBACK_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_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_105'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_105');
END insert_sources_105;
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_25
, h2.BILL_USES_SITE_USE_ID source_26
, h5.XLA_PARTY_TYPE source_27
, h5.TRX_INVOICE_CURRENCY_CODE source_32
, h5.TRX_DOC_SEQUENCE_CATEGORY source_77
, h5.TRX_DOC_SEQUENCE_ID source_78
, h5.TRX_DOC_SEQUENCE_VALUE source_79
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_14
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l4.TRX_LINE_DIST_ID source_29
, l4.TRX_DISTRIBUTION_TYPE source_30
, l4.TRX_LINE_DIST_AMT source_31
, l3.TRX_LINE_CUR_CONVERSION_DATE source_33
, l3.TRX_LINE_CUR_CONVERSION_RATE source_34
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
, l3.TRX_LINE_ACCTD_AMT source_36
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) := 'CREDIT_MEMO_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_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_106'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_106');
END insert_sources_106;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.CM_RECEIVABLE_CCID source_2
, h8.CODE_COMBINATION_ID_GAIN source_12
, h8.CODE_COMBINATION_ID_LOSS source_13
, h5.XLA_PARTY_TYPE source_27
, h5.CM_INVOICE_CURRENCY_CODE source_39
, h2.CM_BILL_CUST_ACCOUNT_ID source_45
, h1.CM_BILL_USES_SITE_USE_ID source_46
, h5.CM_INVOICING_RULE_ID source_52
FROM xla_events_gt xet
, AR_CM_BILL_SITE_USES_H_V h1
, AR_CM_BILL_TO_CUST_H_V h2
, AR_CREDIT_MEMO_H_V h5
, AR_SYSTEM_PARAM_H_V h8
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h2.event_id = h1.event_id
AND h5.event_id = h1.event_id
AND h8.event_id (+) = h1.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l3.LINE_NUMBER
, l4.CM_LINE_DIST_CCID source_9
, l6.DIST_CODE_COMBINATION_ID source_10
, l6.DIST_SOURCE_TYPE source_15
, l7.REC_ACT_TYPE source_16
, l6.DIST_ENT_AMT source_19
, l3.CM_DIST_IDENTIFER source_37
, l3.CM_DIST_TYPE source_38
, l3.CM_LINE_CUR_CONVERSION_DATE source_40
, l3.CM_LINE_CUR_CONVERSION_RATE source_41
, l3.CM_LINE_CUR_CONVERSION_TYPE source_42
, l3.GAIN_LOSS_REF source_43
, l3.CM_LINE_ACCTD_AMT source_44
, l4.CM_TAX_LINE_ID source_47
, l4.CM_LINE_DIST_ACCOUNT_CLASS source_48
, l4.CM_LINE_DIST_AMT source_49
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_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) := 'DEBIT_MEMO_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_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_107'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_107');
END insert_sources_107;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT_MEMO
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.TRX_RECEIVABLE_CCID source_8
, h1.BILL_CUST_ACCOUNT_ID source_25
, h2.BILL_USES_SITE_USE_ID source_26
, h5.XLA_PARTY_TYPE source_27
, h5.TRX_INVOICE_CURRENCY_CODE source_32
, h5.TRX_INVOICING_RULE_ID source_53
, h5.TRX_DOC_SEQUENCE_CATEGORY source_77
, h5.TRX_DOC_SEQUENCE_ID source_78
, h5.TRX_DOC_SEQUENCE_VALUE source_79
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_14
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l4.TRX_LINE_DIST_ID source_29
, l4.TRX_DISTRIBUTION_TYPE source_30
, l4.TRX_LINE_DIST_AMT source_31
, l3.TRX_LINE_CUR_CONVERSION_DATE source_33
, l3.TRX_LINE_CUR_CONVERSION_RATE source_34
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
, l3.TRX_LINE_ACCTD_AMT source_36
, l4.TRX_TAX_LINE_ID source_50
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) := 'DEPOSIT_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_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_108'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_108');
END insert_sources_108;
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_25
, h2.BILL_USES_SITE_USE_ID source_26
, h5.XLA_PARTY_TYPE source_27
, h5.TRX_INVOICE_CURRENCY_CODE source_32
, h5.TRX_DOC_SEQUENCE_CATEGORY source_77
, h5.TRX_DOC_SEQUENCE_ID source_78
, h5.TRX_DOC_SEQUENCE_VALUE source_79
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_14
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l4.TRX_LINE_DIST_ID source_29
, l4.TRX_DISTRIBUTION_TYPE source_30
, l4.TRX_LINE_DIST_AMT source_31
, l3.TRX_LINE_CUR_CONVERSION_DATE source_33
, l3.TRX_LINE_CUR_CONVERSION_RATE source_34
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
, l3.TRX_LINE_ACCTD_AMT source_36
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) := 'GUARANTEE_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_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_109'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_109');
END insert_sources_109;
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_25
, h2.BILL_USES_SITE_USE_ID source_26
, h5.XLA_PARTY_TYPE source_27
, h5.TRX_INVOICE_CURRENCY_CODE source_32
, h5.TRX_DOC_SEQUENCE_CATEGORY source_77
, h5.TRX_DOC_SEQUENCE_ID source_78
, h5.TRX_DOC_SEQUENCE_VALUE source_79
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_14
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l4.TRX_LINE_DIST_ID source_29
, l4.TRX_DISTRIBUTION_TYPE source_30
, l4.TRX_LINE_DIST_AMT source_31
, l3.TRX_LINE_CUR_CONVERSION_DATE source_33
, l3.TRX_LINE_CUR_CONVERSION_RATE source_34
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
, l3.TRX_LINE_ACCTD_AMT source_36
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_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) := 'INVOICE_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_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_110'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_110');
END insert_sources_110;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.TRX_RECEIVABLE_CCID source_8
, h1.BILL_CUST_ACCOUNT_ID source_25
, h2.BILL_USES_SITE_USE_ID source_26
, h5.XLA_PARTY_TYPE source_27
, h5.TRX_INVOICE_CURRENCY_CODE source_32
, h5.TRX_INVOICING_RULE_ID source_53
, h5.TRX_DOC_SEQUENCE_CATEGORY source_77
, h5.TRX_DOC_SEQUENCE_ID source_78
, h5.TRX_DOC_SEQUENCE_VALUE source_79
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_14
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l4.TRX_LINE_DIST_ID source_29
, l4.TRX_DISTRIBUTION_TYPE source_30
, l4.TRX_LINE_DIST_AMT source_31
, l3.TRX_LINE_CUR_CONVERSION_DATE source_33
, l3.TRX_LINE_CUR_CONVERSION_RATE source_34
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
, l3.TRX_LINE_ACCTD_AMT source_36
, l4.TRX_TAX_LINE_ID source_50
, l3.ROUNDING_CORRECTION_FLAG source_51
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_111(
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_111';
(p_msg => 'BEGIN of insert_sources_111'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 5 THEN 'AR_RCT_METHOD_H_V'
WHEN 6 THEN 'AR_RCT_METHOD_H_V'
WHEN 7 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 8 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 9 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 10 THEN 'AR_CASH_RECEIPTS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RMT_BNK_BANK_CHARGES_CCID'
WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID'
WHEN 3 THEN 'RMT_BNK_CASH_CCID'
WHEN 4 THEN 'RMT_BNK_REMITTANCE_CCID'
WHEN 5 THEN 'RCT_CLASS_REMIT_FLAG'
WHEN 6 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 7 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 8 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 9 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 10 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.RMT_BNK_BANK_CHARGES_CCID)
WHEN 2 THEN TO_CHAR(h5.RMT_BNK_CONFIRMATION_CCID)
WHEN 3 THEN TO_CHAR(h5.RMT_BNK_CASH_CCID)
WHEN 4 THEN TO_CHAR(h5.RMT_BNK_REMITTANCE_CCID)
WHEN 5 THEN TO_CHAR(h4.RCT_CLASS_REMIT_FLAG)
WHEN 6 THEN TO_CHAR(h4.RCT_CLASS_CONFIRM_FLAG)
WHEN 7 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 8 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
WHEN 9 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 10 THEN TO_CHAR(h1.RCT_TRX_ACCT_REVERSAL)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h1
, AR_RCT_METHOD_H_V h4
, AR_REMIT_BANK_ACCT_H_V h5
,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l3.line_number line_number
, CASE r
WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 2 THEN '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_111'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_111');
END insert_sources_111;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.RMT_BNK_BANK_CHARGES_CCID source_1
, h5.RMT_BNK_CONFIRMATION_CCID source_3
, h5.RMT_BNK_CASH_CCID source_5
, h5.RMT_BNK_REMITTANCE_CCID source_6
, h4.RCT_CLASS_REMIT_FLAG source_56
, h4.RCT_CLASS_CONFIRM_FLAG source_57
, h1.RCT_DOC_SEQUENCE_CATEGORY source_80
, h1.RCT_DOC_SEQUENCE_ID source_81
, h1.RCT_DOC_SEQUENCE_VALUE source_82
, h1.RCT_TRX_ACCT_REVERSAL source_83
FROM xla_events_gt xet
, AR_CASH_RECEIPTS_H_V h1
, AR_RCT_METHOD_H_V h4
, AR_REMIT_BANK_ACCT_H_V h5
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
AND h4.event_id (+) = xet.event_id
AND h5.event_id (+) = xet.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: MISC_RECEIPT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l3.DIST_CODE_COMBINATION_ID source_10
, l3.DIST_SOURCE_TYPE source_15
, l3.DIST_LINE_ID source_17
, l3.DISTRIBUTION_TYPE source_18
, l3.DIST_ENT_AMT source_19
, l3.DIST_CURRENCY_CODE source_20
, l2.DIST_CUR_CONVERSION_RATE source_22
, l2.DIST_CUR_CONVERSION_TYPE source_23
, l2.DIST_TO_ACCTD_AMT source_24
, l3.DIST_MFAR_ADDITIONAL_ENTRY source_54
, l2.DIST_TO_CUR_CONVERSION_DATE source_55
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_112(
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_112';
(p_msg => 'BEGIN of insert_sources_112'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 2 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 3 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 4 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 5 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 9 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 10 THEN 'AR_RCT_METHOD_H_V'
WHEN 11 THEN 'AR_RCT_METHOD_H_V'
WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 13 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 14 THEN 'AR_RCT_SITE_USES_H_V'
WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 18 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 19 THEN 'AR_CASH_RECEIPTS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
WHEN 18 THEN 'HEADER'
WHEN 19 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
WHEN 18 THEN '222'
WHEN 19 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'RMT_BNK_BANK_CHARGES_CCID'
WHEN 2 THEN 'RMT_BNK_CONFIRMATION_CCID'
WHEN 3 THEN 'RMT_BNK_EARNED_CCID'
WHEN 4 THEN 'RMT_BNK_CASH_CCID'
WHEN 5 THEN 'RMT_BNK_REMITTANCE_CCID'
WHEN 6 THEN 'RMT_BNK_UNEARNED_CCID'
WHEN 7 THEN 'RMT_BNK_UNAPPLIED_CCID'
WHEN 8 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 9 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 10 THEN 'RCT_CLASS_REMIT_FLAG'
WHEN 11 THEN 'RCT_CLASS_CONFIRM_FLAG'
WHEN 12 THEN 'RCT_XLA_APPLIED_TO_APP_ID'
WHEN 13 THEN 'RCT_PAY_FROM_CUSTOMER'
WHEN 14 THEN 'RCT_SITE_SITE_USE_ID'
WHEN 15 THEN 'RCT_APP_STATUS'
WHEN 16 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 17 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 18 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 19 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h8.RMT_BNK_BANK_CHARGES_CCID)
WHEN 2 THEN TO_CHAR(h8.RMT_BNK_CONFIRMATION_CCID)
WHEN 3 THEN TO_CHAR(h8.RMT_BNK_EARNED_CCID)
WHEN 4 THEN TO_CHAR(h8.RMT_BNK_CASH_CCID)
WHEN 5 THEN TO_CHAR(h8.RMT_BNK_REMITTANCE_CCID)
WHEN 6 THEN TO_CHAR(h8.RMT_BNK_UNEARNED_CCID)
WHEN 7 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
WHEN 8 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
WHEN 9 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
WHEN 10 THEN TO_CHAR(h5.RCT_CLASS_REMIT_FLAG)
WHEN 11 THEN TO_CHAR(h5.RCT_CLASS_CONFIRM_FLAG)
WHEN 12 THEN TO_CHAR(h1.RCT_XLA_APPLIED_TO_APP_ID)
WHEN 13 THEN TO_CHAR(h1.RCT_PAY_FROM_CUSTOMER)
WHEN 14 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
WHEN 15 THEN TO_CHAR(h1.RCT_APP_STATUS)
WHEN 16 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 17 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
WHEN 18 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 19 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 <= 19 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND 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_112'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000007_PKG.insert_sources_112');
END insert_sources_112;
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_CONFIRMATION_CCID source_3
, h8.RMT_BNK_EARNED_CCID source_4
, h8.RMT_BNK_CASH_CCID source_5
, h8.RMT_BNK_REMITTANCE_CCID source_6
, h8.RMT_BNK_UNEARNED_CCID source_7
, h8.RMT_BNK_UNAPPLIED_CCID source_11
, h9.CODE_COMBINATION_ID_GAIN source_12
, h9.CODE_COMBINATION_ID_LOSS source_13
, h5.RCT_CLASS_REMIT_FLAG source_56
, h5.RCT_CLASS_CONFIRM_FLAG source_57
, h1.RCT_XLA_APPLIED_TO_APP_ID source_58
, h1.RCT_PAY_FROM_CUSTOMER source_70
, h6.RCT_SITE_SITE_USE_ID source_71
, h1.RCT_APP_STATUS source_72
, h1.RCT_DOC_SEQUENCE_CATEGORY source_80
, h1.RCT_DOC_SEQUENCE_ID source_81
, h1.RCT_DOC_SEQUENCE_VALUE source_82
, h1.RCT_TRX_ACCT_REVERSAL source_83
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_10
, l2.TRX_LINE_DIST_CCID source_14
, l4.DIST_SOURCE_TYPE source_15
, l7.REC_ACT_TYPE source_16
, l4.DIST_LINE_ID source_17
, l4.DISTRIBUTION_TYPE source_18
, l4.DIST_ENT_AMT source_19
, l4.DIST_CURRENCY_CODE source_20
, l3.DIST_CUR_CONVERSION_DATE source_21
, l3.DIST_CUR_CONVERSION_RATE source_22
, l3.DIST_CUR_CONVERSION_TYPE source_23
, l3.DIST_TO_ACCTD_AMT source_24
, l2.TRX_LINE_DIST_ACCOUNT_CLASS source_28
, l2.TRX_LINE_DIST_ID source_29
, l2.TRX_DISTRIBUTION_TYPE source_30
, l4.DIST_MFAR_ADDITIONAL_ENTRY source_54
, l3.DIST_TO_CUR_CONVERSION_DATE source_55
, l10.TRX_ENTITY_CODE source_59
, l10.TRX_CUSTOMER_TRX_ID source_60
, l4.DIST_ENT_AMT_FROM source_61
, l4.DIST_CURRENCY_CODE_FROM source_62
, l3.DIST_ACCTD_AMT source_63
, l4.DIST_PARTY_ID source_64
, l4.DIST_PARTY_SITE_ID source_65
, l4.DIST_PARTY_TYPE source_66
, l3.DIST_TO_CUR_CONVERSION_TYPE source_67
, l3.DIST_TO_CUR_CONVERSION_RATE source_68
, l4.DIST_SOURCE_TABLE source_69
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_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
);
insert_sources_111(
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_112(
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
);