The following lines contain the word 'select', 'insert', 'update' or 'delete':
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
PROCEDURE insert_sources_143(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'ADJUSTMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_143';
(p_msg => 'BEGIN of insert_sources_143'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AR_ADJUSTMENTS_H_V'
WHEN 2 THEN 'AR_ADJUSTMENTS_H_V'
WHEN 3 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 5 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 6 THEN 'AR_TRANSACTIONS_S_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 'ADJ_NUMBER'
WHEN 2 THEN 'ADJ_DOC_SEQUENCE_VALUE'
WHEN 3 THEN 'REC_ACT_TYPE'
WHEN 4 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 5 THEN 'BILL_USES_SITE_USE_ID'
WHEN 6 THEN 'XLA_PARTY_TYPE'
WHEN 7 THEN 'ADJ_DOC_SEQUENCE_CATEGORY'
WHEN 8 THEN 'ADJ_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.ADJ_NUMBER)
WHEN 2 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_VALUE)
WHEN 3 THEN TO_CHAR(h6.REC_ACT_TYPE)
WHEN 4 THEN TO_CHAR(h2.BILL_CUST_ACCOUNT_ID)
WHEN 5 THEN TO_CHAR(h3.BILL_USES_SITE_USE_ID)
WHEN 6 THEN TO_CHAR(h7.XLA_PARTY_TYPE)
WHEN 7 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_CATEGORY)
WHEN 8 THEN TO_CHAR(h1.ADJ_DOC_SEQUENCE_ID)
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_143'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_143');
END insert_sources_143;
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
, h1.ADJ_NUMBER source_1
, h1.ADJ_DOC_SEQUENCE_VALUE source_2
, h6.REC_ACT_TYPE source_40
, h2.BILL_CUST_ACCOUNT_ID source_49
, h3.BILL_USES_SITE_USE_ID source_50
, h7.XLA_PARTY_TYPE source_51
, h1.ADJ_DOC_SEQUENCE_CATEGORY source_117
, h1.ADJ_DOC_SEQUENCE_ID source_118
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_32
, l5.DIST_SOURCE_TYPE source_39
, l5.DIST_LINE_ID source_41
, l5.DISTRIBUTION_TYPE source_42
, l5.DIST_ENT_AMT source_43
, l5.DIST_CURRENCY_CODE source_44
, l4.DIST_CUR_CONVERSION_DATE source_45
, l4.DIST_CUR_CONVERSION_RATE source_46
, l4.DIST_CUR_CONVERSION_TYPE source_47
, l4.DIST_TO_ACCTD_AMT source_48
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_144(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'BILL_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_144';
(p_msg => 'BEGIN of insert_sources_144'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
WHEN 6 THEN 'AR_DRAWEE_CUSTOMERS_H_V'
WHEN 7 THEN 'AR_DRAWEE_SITE_USES_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'
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 'TRX_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 4 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 5 THEN 'XLA_PARTY_TYPE'
WHEN 6 THEN 'DRAW_CUST_ACCOUNT_ID'
WHEN 7 THEN 'DRAW_SITE_SITE_USE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h6.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h6.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.CODE_COMBINATION_ID_GAIN)
WHEN 4 THEN TO_CHAR(h5.CODE_COMBINATION_ID_LOSS)
WHEN 5 THEN TO_CHAR(h6.XLA_PARTY_TYPE)
WHEN 6 THEN TO_CHAR(h3.DRAW_CUST_ACCOUNT_ID)
WHEN 7 THEN TO_CHAR(h4.DRAW_SITE_SITE_USE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_DRAWEE_CUSTOMERS_H_V h3
, AR_DRAWEE_SITE_USES_H_V h4
, AR_SYSTEM_PARAM_H_V h5
, AR_TRANSACTIONS_S_V h6
,(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 h3.event_id = xet.event_id
AND h4.event_id = h3.event_id
AND h5.event_id (+) = h3.event_id
AND h6.event_id (+) = h3.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
, l2.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_ACCTD_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_SOURCE_TYPE)
WHEN 3 THEN TO_CHAR(l2.DIST_LINE_ID)
WHEN 4 THEN TO_CHAR(l2.DISTRIBUTION_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENT_AMT)
WHEN 6 THEN TO_CHAR(l2.DIST_CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(l1.DIST_CUR_CONVERSION_DATE)
WHEN 8 THEN TO_CHAR(l1.DIST_CUR_CONVERSION_RATE)
WHEN 9 THEN TO_CHAR(l1.DIST_CUR_CONVERSION_TYPE)
WHEN 10 THEN TO_CHAR(l1.DIST_ACCTD_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l1
, AR_DISTRIBUTIONS_L_V l2
, (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 l1.event_id = xet.event_id
AND l2.event_id = l1.event_id
AND l2.line_number = l1.line_number
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_144'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_144');
END insert_sources_144;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BILL
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
, h6.TRX_TYPE_NAME source_3
, h6.TRX_NUMBER source_4
, h5.CODE_COMBINATION_ID_GAIN source_34
, h5.CODE_COMBINATION_ID_LOSS source_35
, h6.XLA_PARTY_TYPE source_51
, h3.DRAW_CUST_ACCOUNT_ID source_53
, h4.DRAW_SITE_SITE_USE_ID source_54
FROM xla_events_gt xet
, AR_DRAWEE_CUSTOMERS_H_V h3
, AR_DRAWEE_SITE_USES_H_V h4
, AR_SYSTEM_PARAM_H_V h5
, AR_TRANSACTIONS_S_V h6
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 h3.event_id = xet.event_id
AND h4.event_id = h3.event_id
AND h5.event_id (+) = h3.event_id
AND h6.event_id (+) = h3.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BILL
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l1.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_32
, l2.DIST_SOURCE_TYPE source_39
, l2.DIST_LINE_ID source_41
, l2.DISTRIBUTION_TYPE source_42
, l2.DIST_ENT_AMT source_43
, l2.DIST_CURRENCY_CODE source_44
, l1.DIST_CUR_CONVERSION_DATE source_45
, l1.DIST_CUR_CONVERSION_RATE source_46
, l1.DIST_CUR_CONVERSION_TYPE source_47
, l1.DIST_ACCTD_AMT source_52
FROM xla_events_gt xet
, AR_DISTRIBUTIONS_BASE_V l1
, AR_DISTRIBUTIONS_L_V l2
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
AND l2.event_id = l1.event_id
AND l2.line_number = l1.line_number
;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
PROCEDURE insert_sources_145(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'CHARGEBACK_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_145';
(p_msg => 'BEGIN of insert_sources_145'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 6 THEN 'BILL_USES_SITE_USE_ID'
WHEN 7 THEN 'XLA_PARTY_TYPE'
WHEN 8 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 6 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 7 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 8 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
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'
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_145'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_145');
END insert_sources_145;
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
, h5.TRX_TYPE_NAME source_3
, h5.TRX_NUMBER source_4
, h5.TRX_DOC_SEQUENCE_CATEGORY source_5
, h5.TRX_DOC_SEQUENCE_VALUE source_6
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h5.XLA_PARTY_TYPE source_51
, h5.TRX_INVOICE_CURRENCY_CODE source_59
, h5.TRX_DOC_SEQUENCE_ID source_120
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_38
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_55
, l4.TRX_LINE_DIST_ID source_56
, l4.TRX_DISTRIBUTION_TYPE source_57
, l4.TRX_LINE_DIST_AMT source_58
, l3.TRX_LINE_CUR_CONVERSION_DATE source_60
, l3.TRX_LINE_CUR_CONVERSION_RATE source_61
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
, l3.TRX_LINE_ACCTD_AMT source_63
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_146(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'COLLECTION_OCC_DOCUMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_146';
(p_msg => 'BEGIN of insert_sources_146'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 10 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 12 THEN 'AR_TRANSACTIONS_S_V'
WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JLBR_BANK_OCC_DESC'
WHEN 2 THEN 'JLBR_DOCUMENT_NUMBER'
WHEN 3 THEN 'JLBR_TRADE_NOTE_NUMBER'
WHEN 4 THEN 'BILL_CUST_PARTY_NAME'
WHEN 5 THEN 'BILL_CUST_PARTY_NUMBER'
WHEN 6 THEN 'RMT_BNK_ACCOUNT_NAME'
WHEN 7 THEN 'RMT_BNK_ACCOUNT_NUM'
WHEN 8 THEN 'RMT_BANK_NAME'
WHEN 9 THEN 'RMT_BANK_NUM'
WHEN 10 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 11 THEN 'BILL_USES_SITE_USE_ID'
WHEN 12 THEN 'XLA_PARTY_TYPE'
WHEN 13 THEN 'JLBR_OCCURRENCE_ID'
WHEN 14 THEN 'JLBR_EXCHG_GAIN_CCID'
WHEN 15 THEN 'JLBR_EXCHG_LOSS_CCID'
WHEN 16 THEN 'JLBR_GL_DATE'
WHEN 17 THEN 'JLBR_TRANSFER_TO_GL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h6.JLBR_BANK_OCC_DESC)
WHEN 2 THEN TO_CHAR(h6.JLBR_DOCUMENT_NUMBER)
WHEN 3 THEN TO_CHAR(h6.JLBR_TRADE_NOTE_NUMBER)
WHEN 4 THEN TO_CHAR(h1.BILL_CUST_PARTY_NAME)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_PARTY_NUMBER)
WHEN 6 THEN TO_CHAR(h3.RMT_BNK_ACCOUNT_NAME)
WHEN 7 THEN TO_CHAR(h3.RMT_BNK_ACCOUNT_NUM)
WHEN 8 THEN TO_CHAR(h3.RMT_BANK_NAME)
WHEN 9 THEN TO_CHAR(h3.RMT_BANK_NUM)
WHEN 10 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 11 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 12 THEN TO_CHAR(h4.XLA_PARTY_TYPE)
WHEN 13 THEN TO_CHAR(h6.JLBR_OCCURRENCE_ID)
WHEN 14 THEN TO_CHAR(h6.JLBR_EXCHG_GAIN_CCID)
WHEN 15 THEN TO_CHAR(h6.JLBR_EXCHG_LOSS_CCID)
WHEN 16 THEN TO_CHAR(h6.JLBR_GL_DATE)
WHEN 17 THEN TO_CHAR(h6.JLBR_TRANSFER_TO_GL_FLAG)
ELSE null
END source_value
, CASE r
WHEN 17 THEN fvl124.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_REMIT_BANK_ACCT_H_V h3
, AR_TRANSACTIONS_S_V h4
, JL_BR_AR_COLL_OCC_DOCS_H_V h6
, fnd_lookup_values fvl124
,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
AND h1.event_id (+) = h3.event_id
AND h2.event_id (+) = h3.event_id
AND h4.event_id (+) = h3.event_id
AND h6.event_id = h3.event_id
AND fvl124.lookup_type(+) = 'YES_NO'
AND fvl124.lookup_code(+) = h6.JLBR_TRANSFER_TO_GL_FLAG
AND fvl124.view_application_id(+) = 0
AND fvl124.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l5.line_number line_number
, CASE r
WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_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'
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'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JLBR_BORDERO_TYPE'
WHEN 2 THEN 'JLBR_CD_BANK_CHARGES_CCID'
WHEN 3 THEN 'JLBR_CD_BIL_UND_COLL_CCID'
WHEN 4 THEN 'JLBR_CD_CASH_CCID'
WHEN 5 THEN 'JLBR_CD_COLL_ENDRSMNT_CCID'
WHEN 6 THEN 'JLBR_DISTRIBUTION_TYPE'
WHEN 7 THEN 'JLBR_ACCT_REVERSING_OPTN'
WHEN 8 THEN 'JLBR_PRIOR_DIST_LINK_TYPE'
WHEN 9 THEN 'JLBR_PRIOR_DIST_ID'
WHEN 10 THEN 'JLBR_PRIOR_DOCUMENT_ID'
WHEN 11 THEN 'JLBR_PRIOR_OCCURRENCE_ID'
WHEN 12 THEN 'JLBR_DISTRIBUTION_ID'
WHEN 13 THEN 'JLBR_DISTRIBUTION_LINK_TYPE'
WHEN 14 THEN 'JLBR_ENTERED_AMT'
WHEN 15 THEN 'JLBR_ENTERED_CURRENCY_CODE'
WHEN 16 THEN 'JLBR_CONVERSION_DATE'
WHEN 17 THEN 'JLBR_CONVERSION_RATE'
WHEN 18 THEN 'JLBR_CONVERSION_RATE_TYPE'
WHEN 19 THEN 'JLBR_ACCTD_AMT'
WHEN 20 THEN 'JLBR_REVERSED_DIST_ID'
WHEN 21 THEN 'JLBR_REVERSED_DIST_LINK_TYPE'
WHEN 22 THEN 'JLBR_BANK_OCC_TYPE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l5.JLBR_BORDERO_TYPE)
WHEN 2 THEN TO_CHAR(l5.JLBR_CD_BANK_CHARGES_CCID)
WHEN 3 THEN TO_CHAR(l5.JLBR_CD_BIL_UND_COLL_CCID)
WHEN 4 THEN TO_CHAR(l5.JLBR_CD_CASH_CCID)
WHEN 5 THEN TO_CHAR(l5.JLBR_CD_COLL_ENDRSMNT_CCID)
WHEN 6 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_TYPE)
WHEN 7 THEN TO_CHAR(l5.JLBR_ACCT_REVERSING_OPTN)
WHEN 8 THEN TO_CHAR(l5.JLBR_PRIOR_DIST_LINK_TYPE)
WHEN 9 THEN TO_CHAR(l5.JLBR_PRIOR_DIST_ID)
WHEN 10 THEN TO_CHAR(l5.JLBR_PRIOR_DOCUMENT_ID)
WHEN 11 THEN TO_CHAR(l5.JLBR_PRIOR_OCCURRENCE_ID)
WHEN 12 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_ID)
WHEN 13 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_LINK_TYPE)
WHEN 14 THEN TO_CHAR(l5.JLBR_ENTERED_AMT)
WHEN 15 THEN TO_CHAR(l5.JLBR_ENTERED_CURRENCY_CODE)
WHEN 16 THEN TO_CHAR(l5.JLBR_CONVERSION_DATE)
WHEN 17 THEN TO_CHAR(l5.JLBR_CONVERSION_RATE)
WHEN 18 THEN TO_CHAR(l5.JLBR_CONVERSION_RATE_TYPE)
WHEN 19 THEN TO_CHAR(l5.JLBR_ACCTD_AMT)
WHEN 20 THEN TO_CHAR(l5.JLBR_REVERSED_DIST_ID)
WHEN 21 THEN TO_CHAR(l5.JLBR_REVERSED_DIST_LINK_TYPE)
WHEN 22 THEN TO_CHAR(l5.JLBR_BANK_OCC_TYPE)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl13.meaning
WHEN 6 THEN fvl77.meaning
WHEN 7 THEN fvl78.meaning
WHEN 22 THEN fvl96.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, JL_BR_AR_COLL_DOC_DISTS_L_V l5
, fnd_lookup_values fvl13
, fnd_lookup_values fvl77
, fnd_lookup_values fvl78
, fnd_lookup_values fvl96
, (select rownum r from all_objects where rownum <= 22 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l5.event_id = xet.event_id
AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'
AND fvl13.lookup_code(+) = l5.JLBR_BORDERO_TYPE
AND fvl13.view_application_id(+) = 0
AND fvl13.language(+) = USERENV('LANG')
AND fvl77.lookup_type(+) = 'JLBR_AR_DIST_TYPE'
AND fvl77.lookup_code(+) = l5.JLBR_DISTRIBUTION_TYPE
AND fvl77.view_application_id(+) = 0
AND fvl77.language(+) = USERENV('LANG')
AND fvl78.lookup_type(+) = 'YES_NO'
AND fvl78.lookup_code(+) = l5.JLBR_ACCT_REVERSING_OPTN
AND fvl78.view_application_id(+) = 0
AND fvl78.language(+) = USERENV('LANG')
AND fvl96.lookup_type(+) = 'JLBR_AR_BANK_OCCURRENCE_TYPE'
AND fvl96.lookup_code(+) = l5.JLBR_BANK_OCC_TYPE
AND fvl96.view_application_id(+) = 0
AND fvl96.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_146'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_146');
END insert_sources_146;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: COLLECTION_OCC_DOCUMENT
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
, h6.JLBR_BANK_OCC_DESC source_10
, h6.JLBR_DOCUMENT_NUMBER source_11
, h6.JLBR_TRADE_NOTE_NUMBER source_12
, h1.BILL_CUST_PARTY_NAME source_14
, h1.BILL_CUST_PARTY_NUMBER source_15
, h3.RMT_BNK_ACCOUNT_NAME source_16
, h3.RMT_BNK_ACCOUNT_NUM source_17
, h3.RMT_BANK_NAME source_18
, h3.RMT_BANK_NUM source_19
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h4.XLA_PARTY_TYPE source_51
, h6.JLBR_OCCURRENCE_ID source_93
, h6.JLBR_EXCHG_GAIN_CCID source_121
, h6.JLBR_EXCHG_LOSS_CCID source_122
, h6.JLBR_GL_DATE source_123
, h6.JLBR_TRANSFER_TO_GL_FLAG source_124
, fvl124.meaning source_124_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_REMIT_BANK_ACCT_H_V h3
, AR_TRANSACTIONS_S_V h4
, JL_BR_AR_COLL_OCC_DOCS_H_V h6
, fnd_lookup_values fvl124
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 h3.event_id = xet.event_id
AND h1.event_id (+) = h3.event_id
AND h2.event_id (+) = h3.event_id
AND h4.event_id (+) = h3.event_id
AND h6.event_id = h3.event_id
AND fvl124.lookup_type(+) = 'YES_NO'
AND fvl124.lookup_code(+) = h6.JLBR_TRANSFER_TO_GL_FLAG
AND fvl124.view_application_id(+) = 0
AND fvl124.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: COLLECTION_OCC_DOCUMENT
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
, l5.LINE_NUMBER
, l5.JLBR_BORDERO_TYPE source_13
, fvl13.meaning source_13_meaning
, l5.JLBR_CD_BANK_CHARGES_CCID source_25
, l5.JLBR_CD_BIL_UND_COLL_CCID source_26
, l5.JLBR_CD_CASH_CCID source_28
, l5.JLBR_CD_COLL_ENDRSMNT_CCID source_29
, l5.JLBR_DISTRIBUTION_TYPE source_77
, fvl77.meaning source_77_meaning
, l5.JLBR_ACCT_REVERSING_OPTN source_78
, fvl78.meaning source_78_meaning
, l5.JLBR_PRIOR_DIST_LINK_TYPE source_80
, l5.JLBR_PRIOR_DIST_ID source_82
, l5.JLBR_PRIOR_DOCUMENT_ID source_83
, l5.JLBR_PRIOR_OCCURRENCE_ID source_84
, l5.JLBR_DISTRIBUTION_ID source_85
, l5.JLBR_DISTRIBUTION_LINK_TYPE source_86
, l5.JLBR_ENTERED_AMT source_87
, l5.JLBR_ENTERED_CURRENCY_CODE source_88
, l5.JLBR_CONVERSION_DATE source_89
, l5.JLBR_CONVERSION_RATE source_90
, l5.JLBR_CONVERSION_RATE_TYPE source_91
, l5.JLBR_ACCTD_AMT source_92
, l5.JLBR_REVERSED_DIST_ID source_94
, l5.JLBR_REVERSED_DIST_LINK_TYPE source_95
, l5.JLBR_BANK_OCC_TYPE source_96
, fvl96.meaning source_96_meaning
FROM xla_events_gt xet
, JL_BR_AR_COLL_DOC_DISTS_L_V l5
, fnd_lookup_values fvl13
, fnd_lookup_values fvl77
, fnd_lookup_values fvl78
, fnd_lookup_values fvl96
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 l5.event_id = xet.event_id
AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'
AND fvl13.lookup_code(+) = l5.JLBR_BORDERO_TYPE
AND fvl13.view_application_id(+) = 0
AND fvl13.language(+) = USERENV('LANG')
AND fvl77.lookup_type(+) = 'JLBR_AR_DIST_TYPE'
AND fvl77.lookup_code(+) = l5.JLBR_DISTRIBUTION_TYPE
AND fvl77.view_application_id(+) = 0
AND fvl77.language(+) = USERENV('LANG')
AND fvl78.lookup_type(+) = 'YES_NO'
AND fvl78.lookup_code(+) = l5.JLBR_ACCT_REVERSING_OPTN
AND fvl78.view_application_id(+) = 0
AND fvl78.language(+) = USERENV('LANG')
AND fvl96.lookup_type(+) = 'JLBR_AR_BANK_OCCURRENCE_TYPE'
AND fvl96.lookup_code(+) = l5.JLBR_BANK_OCC_TYPE
AND fvl96.view_application_id(+) = 0
AND fvl96.language(+) = USERENV('LANG')
;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
PROCEDURE insert_sources_147(
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_147';
(p_msg => 'BEGIN of insert_sources_147'
,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_CREDIT_MEMO_H_V'
WHEN 3 THEN 'AR_CREDIT_MEMO_H_V'
WHEN 4 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 5 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 6 THEN 'AR_CREDIT_MEMO_H_V'
WHEN 7 THEN 'AR_CREDIT_MEMO_H_V'
WHEN 8 THEN 'AR_CM_BILL_TO_CUST_H_V'
WHEN 9 THEN 'AR_CM_BILL_SITE_USES_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'
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 'CM_TRX_TYPE_NAME'
WHEN 2 THEN 'CM_TRX_NUMBER'
WHEN 3 THEN 'CM_DOC_SEQUENCE_VALUE'
WHEN 4 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 5 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 6 THEN 'XLA_PARTY_TYPE'
WHEN 7 THEN 'CM_INVOICE_CURRENCY_CODE'
WHEN 8 THEN 'CM_BILL_CUST_ACCOUNT_ID'
WHEN 9 THEN 'CM_BILL_USES_SITE_USE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.CM_TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.CM_TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.CM_DOC_SEQUENCE_VALUE)
WHEN 4 THEN TO_CHAR(h8.CODE_COMBINATION_ID_GAIN)
WHEN 5 THEN TO_CHAR(h8.CODE_COMBINATION_ID_LOSS)
WHEN 6 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 7 THEN TO_CHAR(h5.CM_INVOICE_CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(h2.CM_BILL_CUST_ACCOUNT_ID)
WHEN 9 THEN TO_CHAR(h1.CM_BILL_USES_SITE_USE_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 <= 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
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_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_CM_LINES_L_V'
WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 7 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
WHEN 8 THEN 'AR_DISTRIBUTIONS_L_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_BASE_V'
WHEN 14 THEN 'AR_CM_LINES_BASE_V'
WHEN 15 THEN 'AR_CM_LINES_BASE_V'
WHEN 16 THEN 'AR_CM_LINES_L_V'
WHEN 17 THEN 'AR_CM_LINES_L_V'
WHEN 18 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'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 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'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 4 THEN 'CM_LINE_DIST_CCID'
WHEN 5 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 6 THEN 'DIST_SOURCE_TYPE'
WHEN 7 THEN 'REC_ACT_TYPE'
WHEN 8 THEN 'DIST_ENT_AMT'
WHEN 9 THEN 'CM_DIST_IDENTIFER'
WHEN 10 THEN 'CM_DIST_TYPE'
WHEN 11 THEN 'CM_LINE_CUR_CONVERSION_DATE'
WHEN 12 THEN 'CM_LINE_CUR_CONVERSION_RATE'
WHEN 13 THEN 'CM_LINE_CUR_CONVERSION_TYPE'
WHEN 14 THEN 'GAIN_LOSS_REF'
WHEN 15 THEN 'CM_LINE_ACCTD_AMT'
WHEN 16 THEN 'CM_TAX_LINE_ID'
WHEN 17 THEN 'CM_LINE_DIST_ACCOUNT_CLASS'
WHEN 18 THEN 'CM_LINE_DIST_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l9.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(l9.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(l9.TRX_DOC_SEQUENCE_VALUE)
WHEN 4 THEN TO_CHAR(l4.CM_LINE_DIST_CCID)
WHEN 5 THEN TO_CHAR(l6.DIST_CODE_COMBINATION_ID)
WHEN 6 THEN TO_CHAR(l6.DIST_SOURCE_TYPE)
WHEN 7 THEN TO_CHAR(l7.REC_ACT_TYPE)
WHEN 8 THEN TO_CHAR(l6.DIST_ENT_AMT)
WHEN 9 THEN TO_CHAR(l3.CM_DIST_IDENTIFER)
WHEN 10 THEN TO_CHAR(l3.CM_DIST_TYPE)
WHEN 11 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_DATE)
WHEN 12 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_RATE)
WHEN 13 THEN TO_CHAR(l3.CM_LINE_CUR_CONVERSION_TYPE)
WHEN 14 THEN TO_CHAR(l3.GAIN_LOSS_REF)
WHEN 15 THEN TO_CHAR(l3.CM_LINE_ACCTD_AMT)
WHEN 16 THEN TO_CHAR(l4.CM_TAX_LINE_ID)
WHEN 17 THEN TO_CHAR(l4.CM_LINE_DIST_ACCOUNT_CLASS)
WHEN 18 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
, AR_TRANSACTIONS_S_V l9
, (select rownum r from all_objects where rownum <= 18 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
AND l9.event_id (+) = l3.event_id
AND l9.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_147'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_147');
END insert_sources_147;
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_TRX_TYPE_NAME source_7
, h5.CM_TRX_NUMBER source_8
, h5.CM_DOC_SEQUENCE_VALUE source_9
, h8.CODE_COMBINATION_ID_GAIN source_34
, h8.CODE_COMBINATION_ID_LOSS source_35
, h5.XLA_PARTY_TYPE source_51
, h5.CM_INVOICE_CURRENCY_CODE source_66
, h2.CM_BILL_CUST_ACCOUNT_ID source_72
, h1.CM_BILL_USES_SITE_USE_ID source_73
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
, l9.TRX_TYPE_NAME source_3
, l9.TRX_NUMBER source_4
, l9.TRX_DOC_SEQUENCE_VALUE source_6
, l4.CM_LINE_DIST_CCID source_24
, l6.DIST_CODE_COMBINATION_ID source_32
, l6.DIST_SOURCE_TYPE source_39
, l7.REC_ACT_TYPE source_40
, l6.DIST_ENT_AMT source_43
, l3.CM_DIST_IDENTIFER source_64
, l3.CM_DIST_TYPE source_65
, l3.CM_LINE_CUR_CONVERSION_DATE source_67
, l3.CM_LINE_CUR_CONVERSION_RATE source_68
, l3.CM_LINE_CUR_CONVERSION_TYPE source_69
, l3.GAIN_LOSS_REF source_70
, l3.CM_LINE_ACCTD_AMT source_71
, l4.CM_TAX_LINE_ID source_74
, l4.CM_LINE_DIST_ACCOUNT_CLASS source_75
, l4.CM_LINE_DIST_AMT source_76
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
, AR_TRANSACTIONS_S_V l9
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
AND l9.event_id (+) = l3.event_id
AND l9.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_148(
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_148';
(p_msg => 'BEGIN of insert_sources_148'
,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_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 6 THEN 'BILL_USES_SITE_USE_ID'
WHEN 7 THEN 'XLA_PARTY_TYPE'
WHEN 8 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 6 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 7 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 8 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
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_148'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_148');
END insert_sources_148;
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_TYPE_NAME source_3
, h5.TRX_NUMBER source_4
, h5.TRX_DOC_SEQUENCE_CATEGORY source_5
, h5.TRX_DOC_SEQUENCE_VALUE source_6
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h5.XLA_PARTY_TYPE source_51
, h5.TRX_INVOICE_CURRENCY_CODE source_59
, h5.TRX_DOC_SEQUENCE_ID source_120
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_38
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_55
, l4.TRX_LINE_DIST_ID source_56
, l4.TRX_DISTRIBUTION_TYPE source_57
, l4.TRX_LINE_DIST_AMT source_58
, l3.TRX_LINE_CUR_CONVERSION_DATE source_60
, l3.TRX_LINE_CUR_CONVERSION_RATE source_61
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
, l3.TRX_LINE_ACCTD_AMT source_63
, l4.TRX_TAX_LINE_ID source_97
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_149(
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_149';
(p_msg => 'BEGIN of insert_sources_149'
,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_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 6 THEN 'BILL_USES_SITE_USE_ID'
WHEN 7 THEN 'XLA_PARTY_TYPE'
WHEN 8 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 6 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 7 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 8 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
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'
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_149'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_149');
END insert_sources_149;
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
, h5.TRX_TYPE_NAME source_3
, h5.TRX_NUMBER source_4
, h5.TRX_DOC_SEQUENCE_CATEGORY source_5
, h5.TRX_DOC_SEQUENCE_VALUE source_6
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h5.XLA_PARTY_TYPE source_51
, h5.TRX_INVOICE_CURRENCY_CODE source_59
, h5.TRX_DOC_SEQUENCE_ID source_120
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_38
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_55
, l4.TRX_LINE_DIST_ID source_56
, l4.TRX_DISTRIBUTION_TYPE source_57
, l4.TRX_LINE_DIST_AMT source_58
, l3.TRX_LINE_CUR_CONVERSION_DATE source_60
, l3.TRX_LINE_CUR_CONVERSION_RATE source_61
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
, l3.TRX_LINE_ACCTD_AMT source_63
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_150(
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) := 'FACTORING_OCC_DOCUMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_150';
(p_msg => 'BEGIN of insert_sources_150'
,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 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 2 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 3 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 4 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 7 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 8 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 10 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 11 THEN 'AR_BILL_TO_SITE_USES_S_V'
WHEN 12 THEN 'AR_TRANSACTIONS_S_V'
WHEN 13 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 14 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 15 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 16 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
WHEN 17 THEN 'JL_BR_AR_COLL_OCC_DOCS_H_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '222'
WHEN 2 THEN '222'
WHEN 3 THEN '222'
WHEN 4 THEN '222'
WHEN 5 THEN '222'
WHEN 6 THEN '222'
WHEN 7 THEN '222'
WHEN 8 THEN '222'
WHEN 9 THEN '222'
WHEN 10 THEN '222'
WHEN 11 THEN '222'
WHEN 12 THEN '222'
WHEN 13 THEN '222'
WHEN 14 THEN '222'
WHEN 15 THEN '222'
WHEN 16 THEN '222'
WHEN 17 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JLBR_BANK_OCC_DESC'
WHEN 2 THEN 'JLBR_DOCUMENT_NUMBER'
WHEN 3 THEN 'JLBR_TRADE_NOTE_NUMBER'
WHEN 4 THEN 'BILL_CUST_PARTY_NAME'
WHEN 5 THEN 'BILL_CUST_PARTY_NUMBER'
WHEN 6 THEN 'RMT_BNK_ACCOUNT_NAME'
WHEN 7 THEN 'RMT_BNK_ACCOUNT_NUM'
WHEN 8 THEN 'RMT_BANK_NAME'
WHEN 9 THEN 'RMT_BANK_NUM'
WHEN 10 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 11 THEN 'BILL_USES_SITE_USE_ID'
WHEN 12 THEN 'XLA_PARTY_TYPE'
WHEN 13 THEN 'JLBR_OCCURRENCE_ID'
WHEN 14 THEN 'JLBR_EXCHG_GAIN_CCID'
WHEN 15 THEN 'JLBR_EXCHG_LOSS_CCID'
WHEN 16 THEN 'JLBR_GL_DATE'
WHEN 17 THEN 'JLBR_TRANSFER_TO_GL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h6.JLBR_BANK_OCC_DESC)
WHEN 2 THEN TO_CHAR(h6.JLBR_DOCUMENT_NUMBER)
WHEN 3 THEN TO_CHAR(h6.JLBR_TRADE_NOTE_NUMBER)
WHEN 4 THEN TO_CHAR(h1.BILL_CUST_PARTY_NAME)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_PARTY_NUMBER)
WHEN 6 THEN TO_CHAR(h3.RMT_BNK_ACCOUNT_NAME)
WHEN 7 THEN TO_CHAR(h3.RMT_BNK_ACCOUNT_NUM)
WHEN 8 THEN TO_CHAR(h3.RMT_BANK_NAME)
WHEN 9 THEN TO_CHAR(h3.RMT_BANK_NUM)
WHEN 10 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 11 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 12 THEN TO_CHAR(h4.XLA_PARTY_TYPE)
WHEN 13 THEN TO_CHAR(h6.JLBR_OCCURRENCE_ID)
WHEN 14 THEN TO_CHAR(h6.JLBR_EXCHG_GAIN_CCID)
WHEN 15 THEN TO_CHAR(h6.JLBR_EXCHG_LOSS_CCID)
WHEN 16 THEN TO_CHAR(h6.JLBR_GL_DATE)
WHEN 17 THEN TO_CHAR(h6.JLBR_TRANSFER_TO_GL_FLAG)
ELSE null
END source_value
, CASE r
WHEN 17 THEN fvl124.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_REMIT_BANK_ACCT_H_V h3
, AR_TRANSACTIONS_S_V h4
, JL_BR_AR_COLL_OCC_DOCS_H_V h6
, fnd_lookup_values fvl124
,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
AND h1.event_id (+) = h3.event_id
AND h2.event_id (+) = h3.event_id
AND h4.event_id (+) = h3.event_id
AND h6.event_id = h3.event_id
AND fvl124.lookup_type(+) = 'YES_NO'
AND fvl124.lookup_code(+) = h6.JLBR_TRANSFER_TO_GL_FLAG
AND fvl124.view_application_id(+) = 0
AND fvl124.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l5.line_number line_number
, CASE r
WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_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'
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'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JLBR_BORDERO_TYPE'
WHEN 2 THEN 'JLBR_CD_BANK_CHARGES_CCID'
WHEN 3 THEN 'JLBR_CD_BIL_UND_DISC_CCID'
WHEN 4 THEN 'JLBR_CD_CASH_CCID'
WHEN 5 THEN 'JLBR_CD_DISC_ENDRSMNT_CCID'
WHEN 6 THEN 'JLBR_CD_FACT_CHARGES_CCID'
WHEN 7 THEN 'JLBR_DISTRIBUTION_TYPE'
WHEN 8 THEN 'JLBR_ACCT_REVERSING_OPTN'
WHEN 9 THEN 'JLBR_PRIOR_DIST_LINK_TYPE'
WHEN 10 THEN 'JLBR_PRIOR_DIST_ID'
WHEN 11 THEN 'JLBR_PRIOR_DOCUMENT_ID'
WHEN 12 THEN 'JLBR_PRIOR_OCCURRENCE_ID'
WHEN 13 THEN 'JLBR_DISTRIBUTION_ID'
WHEN 14 THEN 'JLBR_DISTRIBUTION_LINK_TYPE'
WHEN 15 THEN 'JLBR_ENTERED_AMT'
WHEN 16 THEN 'JLBR_ENTERED_CURRENCY_CODE'
WHEN 17 THEN 'JLBR_CONVERSION_DATE'
WHEN 18 THEN 'JLBR_CONVERSION_RATE'
WHEN 19 THEN 'JLBR_CONVERSION_RATE_TYPE'
WHEN 20 THEN 'JLBR_ACCTD_AMT'
WHEN 21 THEN 'JLBR_REVERSED_DIST_ID'
WHEN 22 THEN 'JLBR_REVERSED_DIST_LINK_TYPE'
WHEN 23 THEN 'JLBR_BANK_OCC_TYPE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l5.JLBR_BORDERO_TYPE)
WHEN 2 THEN TO_CHAR(l5.JLBR_CD_BANK_CHARGES_CCID)
WHEN 3 THEN TO_CHAR(l5.JLBR_CD_BIL_UND_DISC_CCID)
WHEN 4 THEN TO_CHAR(l5.JLBR_CD_CASH_CCID)
WHEN 5 THEN TO_CHAR(l5.JLBR_CD_DISC_ENDRSMNT_CCID)
WHEN 6 THEN TO_CHAR(l5.JLBR_CD_FACT_CHARGES_CCID)
WHEN 7 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_TYPE)
WHEN 8 THEN TO_CHAR(l5.JLBR_ACCT_REVERSING_OPTN)
WHEN 9 THEN TO_CHAR(l5.JLBR_PRIOR_DIST_LINK_TYPE)
WHEN 10 THEN TO_CHAR(l5.JLBR_PRIOR_DIST_ID)
WHEN 11 THEN TO_CHAR(l5.JLBR_PRIOR_DOCUMENT_ID)
WHEN 12 THEN TO_CHAR(l5.JLBR_PRIOR_OCCURRENCE_ID)
WHEN 13 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_ID)
WHEN 14 THEN TO_CHAR(l5.JLBR_DISTRIBUTION_LINK_TYPE)
WHEN 15 THEN TO_CHAR(l5.JLBR_ENTERED_AMT)
WHEN 16 THEN TO_CHAR(l5.JLBR_ENTERED_CURRENCY_CODE)
WHEN 17 THEN TO_CHAR(l5.JLBR_CONVERSION_DATE)
WHEN 18 THEN TO_CHAR(l5.JLBR_CONVERSION_RATE)
WHEN 19 THEN TO_CHAR(l5.JLBR_CONVERSION_RATE_TYPE)
WHEN 20 THEN TO_CHAR(l5.JLBR_ACCTD_AMT)
WHEN 21 THEN TO_CHAR(l5.JLBR_REVERSED_DIST_ID)
WHEN 22 THEN TO_CHAR(l5.JLBR_REVERSED_DIST_LINK_TYPE)
WHEN 23 THEN TO_CHAR(l5.JLBR_BANK_OCC_TYPE)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl13.meaning
WHEN 7 THEN fvl77.meaning
WHEN 8 THEN fvl78.meaning
WHEN 23 THEN fvl96.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, JL_BR_AR_COLL_DOC_DISTS_L_V l5
, fnd_lookup_values fvl13
, fnd_lookup_values fvl77
, fnd_lookup_values fvl78
, fnd_lookup_values fvl96
, (select rownum r from all_objects where rownum <= 23 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 l5.event_id = xet.event_id
AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'
AND fvl13.lookup_code(+) = l5.JLBR_BORDERO_TYPE
AND fvl13.view_application_id(+) = 0
AND fvl13.language(+) = USERENV('LANG')
AND fvl77.lookup_type(+) = 'JLBR_AR_DIST_TYPE'
AND fvl77.lookup_code(+) = l5.JLBR_DISTRIBUTION_TYPE
AND fvl77.view_application_id(+) = 0
AND fvl77.language(+) = USERENV('LANG')
AND fvl78.lookup_type(+) = 'YES_NO'
AND fvl78.lookup_code(+) = l5.JLBR_ACCT_REVERSING_OPTN
AND fvl78.view_application_id(+) = 0
AND fvl78.language(+) = USERENV('LANG')
AND fvl96.lookup_type(+) = 'JLBR_AR_BANK_OCCURRENCE_TYPE'
AND fvl96.lookup_code(+) = l5.JLBR_BANK_OCC_TYPE
AND fvl96.view_application_id(+) = 0
AND fvl96.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_150'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_150');
END insert_sources_150;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: FACTORING_OCC_DOCUMENT
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
, h6.JLBR_BANK_OCC_DESC source_10
, h6.JLBR_DOCUMENT_NUMBER source_11
, h6.JLBR_TRADE_NOTE_NUMBER source_12
, h1.BILL_CUST_PARTY_NAME source_14
, h1.BILL_CUST_PARTY_NUMBER source_15
, h3.RMT_BNK_ACCOUNT_NAME source_16
, h3.RMT_BNK_ACCOUNT_NUM source_17
, h3.RMT_BANK_NAME source_18
, h3.RMT_BANK_NUM source_19
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h4.XLA_PARTY_TYPE source_51
, h6.JLBR_OCCURRENCE_ID source_93
, h6.JLBR_EXCHG_GAIN_CCID source_121
, h6.JLBR_EXCHG_LOSS_CCID source_122
, h6.JLBR_GL_DATE source_123
, h6.JLBR_TRANSFER_TO_GL_FLAG source_124
, fvl124.meaning source_124_meaning
FROM xla_events_gt xet
, AR_BILL_TO_CUSTOMERS_S_V h1
, AR_BILL_TO_SITE_USES_S_V h2
, AR_REMIT_BANK_ACCT_H_V h3
, AR_TRANSACTIONS_S_V h4
, JL_BR_AR_COLL_OCC_DOCS_H_V h6
, fnd_lookup_values fvl124
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 h3.event_id = xet.event_id
AND h1.event_id (+) = h3.event_id
AND h2.event_id (+) = h3.event_id
AND h4.event_id (+) = h3.event_id
AND h6.event_id = h3.event_id
AND fvl124.lookup_type(+) = 'YES_NO'
AND fvl124.lookup_code(+) = h6.JLBR_TRANSFER_TO_GL_FLAG
AND fvl124.view_application_id(+) = 0
AND fvl124.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: FACTORING_OCC_DOCUMENT
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
, l5.LINE_NUMBER
, l5.JLBR_BORDERO_TYPE source_13
, fvl13.meaning source_13_meaning
, l5.JLBR_CD_BANK_CHARGES_CCID source_25
, l5.JLBR_CD_BIL_UND_DISC_CCID source_27
, l5.JLBR_CD_CASH_CCID source_28
, l5.JLBR_CD_DISC_ENDRSMNT_CCID source_30
, l5.JLBR_CD_FACT_CHARGES_CCID source_31
, l5.JLBR_DISTRIBUTION_TYPE source_77
, fvl77.meaning source_77_meaning
, l5.JLBR_ACCT_REVERSING_OPTN source_78
, fvl78.meaning source_78_meaning
, l5.JLBR_PRIOR_DIST_LINK_TYPE source_80
, l5.JLBR_PRIOR_DIST_ID source_82
, l5.JLBR_PRIOR_DOCUMENT_ID source_83
, l5.JLBR_PRIOR_OCCURRENCE_ID source_84
, l5.JLBR_DISTRIBUTION_ID source_85
, l5.JLBR_DISTRIBUTION_LINK_TYPE source_86
, l5.JLBR_ENTERED_AMT source_87
, l5.JLBR_ENTERED_CURRENCY_CODE source_88
, l5.JLBR_CONVERSION_DATE source_89
, l5.JLBR_CONVERSION_RATE source_90
, l5.JLBR_CONVERSION_RATE_TYPE source_91
, l5.JLBR_ACCTD_AMT source_92
, l5.JLBR_REVERSED_DIST_ID source_94
, l5.JLBR_REVERSED_DIST_LINK_TYPE source_95
, l5.JLBR_BANK_OCC_TYPE source_96
, fvl96.meaning source_96_meaning
FROM xla_events_gt xet
, JL_BR_AR_COLL_DOC_DISTS_L_V l5
, fnd_lookup_values fvl13
, fnd_lookup_values fvl77
, fnd_lookup_values fvl78
, fnd_lookup_values fvl96
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 l5.event_id = xet.event_id
AND fvl13.lookup_type(+) = 'JLBR_AR_BORDERO_TYPE'
AND fvl13.lookup_code(+) = l5.JLBR_BORDERO_TYPE
AND fvl13.view_application_id(+) = 0
AND fvl13.language(+) = USERENV('LANG')
AND fvl77.lookup_type(+) = 'JLBR_AR_DIST_TYPE'
AND fvl77.lookup_code(+) = l5.JLBR_DISTRIBUTION_TYPE
AND fvl77.view_application_id(+) = 0
AND fvl77.language(+) = USERENV('LANG')
AND fvl78.lookup_type(+) = 'YES_NO'
AND fvl78.lookup_code(+) = l5.JLBR_ACCT_REVERSING_OPTN
AND fvl78.view_application_id(+) = 0
AND fvl78.language(+) = USERENV('LANG')
AND fvl96.lookup_type(+) = 'JLBR_AR_BANK_OCCURRENCE_TYPE'
AND fvl96.lookup_code(+) = l5.JLBR_BANK_OCC_TYPE
AND fvl96.view_application_id(+) = 0
AND fvl96.language(+) = USERENV('LANG')
;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
PROCEDURE insert_sources_151(
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_151';
(p_msg => 'BEGIN of insert_sources_151'
,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_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 6 THEN 'BILL_USES_SITE_USE_ID'
WHEN 7 THEN 'XLA_PARTY_TYPE'
WHEN 8 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 6 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 7 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 8 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
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'
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_151'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_151');
END insert_sources_151;
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
, h5.TRX_TYPE_NAME source_3
, h5.TRX_NUMBER source_4
, h5.TRX_DOC_SEQUENCE_CATEGORY source_5
, h5.TRX_DOC_SEQUENCE_VALUE source_6
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h5.XLA_PARTY_TYPE source_51
, h5.TRX_INVOICE_CURRENCY_CODE source_59
, h5.TRX_DOC_SEQUENCE_ID source_120
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_38
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_55
, l4.TRX_LINE_DIST_ID source_56
, l4.TRX_DISTRIBUTION_TYPE source_57
, l4.TRX_LINE_DIST_AMT source_58
, l3.TRX_LINE_CUR_CONVERSION_DATE source_60
, l3.TRX_LINE_CUR_CONVERSION_RATE source_61
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
, l3.TRX_LINE_ACCTD_AMT source_63
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_152(
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_152';
(p_msg => 'BEGIN of insert_sources_152'
,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_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
WHEN 4 THEN 'AR_TRANSACTIONS_S_V'
WHEN 5 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
WHEN 6 THEN 'AR_BILL_TO_SITE_USES_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_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_CATEGORY'
WHEN 4 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'BILL_CUST_ACCOUNT_ID'
WHEN 6 THEN 'BILL_USES_SITE_USE_ID'
WHEN 7 THEN 'XLA_PARTY_TYPE'
WHEN 8 THEN 'TRX_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'TRX_DOC_SEQUENCE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(h5.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_CATEGORY)
WHEN 4 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h1.BILL_CUST_ACCOUNT_ID)
WHEN 6 THEN TO_CHAR(h2.BILL_USES_SITE_USE_ID)
WHEN 7 THEN TO_CHAR(h5.XLA_PARTY_TYPE)
WHEN 8 THEN TO_CHAR(h5.TRX_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(h5.TRX_DOC_SEQUENCE_ID)
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_152'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_152');
END insert_sources_152;
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_TYPE_NAME source_3
, h5.TRX_NUMBER source_4
, h5.TRX_DOC_SEQUENCE_CATEGORY source_5
, h5.TRX_DOC_SEQUENCE_VALUE source_6
, h1.BILL_CUST_ACCOUNT_ID source_49
, h2.BILL_USES_SITE_USE_ID source_50
, h5.XLA_PARTY_TYPE source_51
, h5.TRX_INVOICE_CURRENCY_CODE source_59
, h5.TRX_DOC_SEQUENCE_ID source_120
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_38
, l4.TRX_LINE_DIST_ACCOUNT_CLASS source_55
, l4.TRX_LINE_DIST_ID source_56
, l4.TRX_DISTRIBUTION_TYPE source_57
, l4.TRX_LINE_DIST_AMT source_58
, l3.TRX_LINE_CUR_CONVERSION_DATE source_60
, l3.TRX_LINE_CUR_CONVERSION_RATE source_61
, l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
, l3.TRX_LINE_ACCTD_AMT source_63
, l4.TRX_TAX_LINE_ID source_97
, l3.ROUNDING_CORRECTION_FLAG source_98
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_153(
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_153';
(p_msg => 'BEGIN of insert_sources_153'
,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_CASH_RECEIPTS_H_V'
WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 5 THEN 'AR_RCT_METHOD_H_V'
WHEN 6 THEN 'AR_CASH_RECEIPTS_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'
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 'RMT_BNK_ACCOUNT_NAME'
WHEN 2 THEN 'RMT_BANK_NAME'
WHEN 3 THEN 'RCT_RECEIPT_NUMBER'
WHEN 4 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'RCT_MTHD_NAME'
WHEN 6 THEN 'RCT_RECEIPT_DATE'
WHEN 7 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 8 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 9 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.RMT_BNK_ACCOUNT_NAME)
WHEN 2 THEN TO_CHAR(h5.RMT_BANK_NAME)
WHEN 3 THEN TO_CHAR(h1.RCT_RECEIPT_NUMBER)
WHEN 4 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h4.RCT_MTHD_NAME)
WHEN 6 THEN TO_CHAR(h1.RCT_RECEIPT_DATE)
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_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 <= 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
)
;
(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_153'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_153');
END insert_sources_153;
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_ACCOUNT_NAME source_16
, h5.RMT_BANK_NAME source_18
, h1.RCT_RECEIPT_NUMBER source_20
, h1.RCT_DOC_SEQUENCE_VALUE source_21
, h4.RCT_MTHD_NAME source_22
, h1.RCT_RECEIPT_DATE source_23
, h1.RCT_DOC_SEQUENCE_CATEGORY source_125
, h1.RCT_DOC_SEQUENCE_ID source_126
, h1.RCT_TRX_ACCT_REVERSAL source_127
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_32
, l3.DIST_SOURCE_TYPE source_39
, l3.DIST_LINE_ID source_41
, l3.DISTRIBUTION_TYPE source_42
, l3.DIST_ENT_AMT source_43
, l3.DIST_CURRENCY_CODE source_44
, l2.DIST_CUR_CONVERSION_RATE source_46
, l2.DIST_CUR_CONVERSION_TYPE source_47
, l2.DIST_TO_ACCTD_AMT source_48
, l3.DIST_MFAR_ADDITIONAL_ENTRY source_99
, l2.DIST_TO_CUR_CONVERSION_DATE source_100
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_154(
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_154';
(p_msg => 'BEGIN of insert_sources_154'
,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_CASH_RECEIPTS_H_V'
WHEN 4 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 5 THEN 'AR_RCT_METHOD_H_V'
WHEN 6 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 7 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 8 THEN 'AR_SYSTEM_PARAM_H_V'
WHEN 9 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 10 THEN 'AR_REMIT_BANK_ACCT_H_V'
WHEN 11 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 12 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 13 THEN 'AR_RCT_SITE_USES_H_V'
WHEN 14 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 15 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 16 THEN 'AR_CASH_RECEIPTS_H_V'
WHEN 17 THEN 'AR_CASH_RECEIPTS_H_V'
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_ACCOUNT_NAME'
WHEN 2 THEN 'RMT_BANK_NAME'
WHEN 3 THEN 'RCT_RECEIPT_NUMBER'
WHEN 4 THEN 'RCT_DOC_SEQUENCE_VALUE'
WHEN 5 THEN 'RCT_MTHD_NAME'
WHEN 6 THEN 'RCT_RECEIPT_DATE'
WHEN 7 THEN 'CODE_COMBINATION_ID_GAIN'
WHEN 8 THEN 'CODE_COMBINATION_ID_LOSS'
WHEN 9 THEN 'RMT_BNK_UNAPPLIED_CCID'
WHEN 10 THEN 'RMT_BNK_UNIDENTIFIED_CCID'
WHEN 11 THEN 'RCT_XLA_APPLIED_TO_APP_ID'
WHEN 12 THEN 'RCT_PAY_FROM_CUSTOMER'
WHEN 13 THEN 'RCT_SITE_SITE_USE_ID'
WHEN 14 THEN 'RCT_APP_STATUS'
WHEN 15 THEN 'RCT_PREV_PAY_FROM_CUSTOMER'
WHEN 16 THEN 'RCT_PREV_CUSTOMER_SITE_USE_ID'
WHEN 17 THEN 'RCT_DOC_SEQUENCE_CATEGORY'
WHEN 18 THEN 'RCT_DOC_SEQUENCE_ID'
WHEN 19 THEN 'RCT_TRX_ACCT_REVERSAL'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h8.RMT_BNK_ACCOUNT_NAME)
WHEN 2 THEN TO_CHAR(h8.RMT_BANK_NAME)
WHEN 3 THEN TO_CHAR(h1.RCT_RECEIPT_NUMBER)
WHEN 4 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_VALUE)
WHEN 5 THEN TO_CHAR(h5.RCT_MTHD_NAME)
WHEN 6 THEN TO_CHAR(h1.RCT_RECEIPT_DATE)
WHEN 7 THEN TO_CHAR(h9.CODE_COMBINATION_ID_GAIN)
WHEN 8 THEN TO_CHAR(h9.CODE_COMBINATION_ID_LOSS)
WHEN 9 THEN TO_CHAR(h8.RMT_BNK_UNAPPLIED_CCID)
WHEN 10 THEN TO_CHAR(h8.RMT_BNK_UNIDENTIFIED_CCID)
WHEN 11 THEN TO_CHAR(h1.RCT_XLA_APPLIED_TO_APP_ID)
WHEN 12 THEN TO_CHAR(h1.RCT_PAY_FROM_CUSTOMER)
WHEN 13 THEN TO_CHAR(h6.RCT_SITE_SITE_USE_ID)
WHEN 14 THEN TO_CHAR(h1.RCT_APP_STATUS)
WHEN 15 THEN TO_CHAR(h1.RCT_PREV_PAY_FROM_CUSTOMER)
WHEN 16 THEN TO_CHAR(h1.RCT_PREV_CUSTOMER_SITE_USE_ID)
WHEN 17 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_CATEGORY)
WHEN 18 THEN TO_CHAR(h1.RCT_DOC_SEQUENCE_ID)
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_TRANSACTIONS_S_V'
WHEN 2 THEN 'AR_TRANSACTIONS_S_V'
WHEN 3 THEN 'AR_TRANSACTIONS_S_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_RECEIVABLES_TRX_ACT_S_V'
WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
WHEN 22 THEN 'AR_TRANSACTIONS_S_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_L_V'
WHEN 27 THEN 'AR_DISTRIBUTIONS_L_V'
WHEN 28 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 29 THEN 'AR_DISTRIBUTIONS_BASE_V'
WHEN 30 THEN 'AR_DISTRIBUTIONS_L_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
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'
WHEN 29 THEN '222'
WHEN 30 THEN '222'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TRX_TYPE_NAME'
WHEN 2 THEN 'TRX_NUMBER'
WHEN 3 THEN 'TRX_DOC_SEQUENCE_VALUE'
WHEN 4 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 5 THEN 'GAIN_LOSS_CCID'
WHEN 6 THEN 'DIST_SOURCE_TYPE'
WHEN 7 THEN 'REC_ACT_TYPE'
WHEN 8 THEN 'DIST_LINE_ID'
WHEN 9 THEN 'DISTRIBUTION_TYPE'
WHEN 10 THEN 'DIST_ENT_AMT'
WHEN 11 THEN 'DIST_CURRENCY_CODE'
WHEN 12 THEN 'DIST_CUR_CONVERSION_DATE'
WHEN 13 THEN 'DIST_CUR_CONVERSION_RATE'
WHEN 14 THEN 'DIST_CUR_CONVERSION_TYPE'
WHEN 15 THEN 'DIST_TO_ACCTD_AMT'
WHEN 16 THEN 'DIST_ACCTD_AMT'
WHEN 17 THEN 'TRX_LINE_DIST_ID'
WHEN 18 THEN 'TRX_DISTRIBUTION_TYPE'
WHEN 19 THEN 'DIST_MFAR_ADDITIONAL_ENTRY'
WHEN 20 THEN 'DIST_TO_CUR_CONVERSION_DATE'
WHEN 21 THEN 'TRX_ENTITY_CODE'
WHEN 22 THEN 'TRX_CUSTOMER_TRX_ID'
WHEN 23 THEN 'DIST_ENT_AMT_FROM'
WHEN 24 THEN 'DIST_CURRENCY_CODE_FROM'
WHEN 25 THEN 'DIST_PARTY_ID'
WHEN 26 THEN 'DIST_PARTY_SITE_ID'
WHEN 27 THEN 'DIST_PARTY_TYPE'
WHEN 28 THEN 'DIST_TO_CUR_CONVERSION_TYPE'
WHEN 29 THEN 'DIST_TO_CUR_CONVERSION_RATE'
WHEN 30 THEN 'DIST_SOURCE_TABLE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l10.TRX_TYPE_NAME)
WHEN 2 THEN TO_CHAR(l10.TRX_NUMBER)
WHEN 3 THEN TO_CHAR(l10.TRX_DOC_SEQUENCE_VALUE)
WHEN 4 THEN TO_CHAR(l4.DIST_CODE_COMBINATION_ID)
WHEN 5 THEN TO_CHAR(l4.GAIN_LOSS_CCID)
WHEN 6 THEN TO_CHAR(l4.DIST_SOURCE_TYPE)
WHEN 7 THEN TO_CHAR(l7.REC_ACT_TYPE)
WHEN 8 THEN TO_CHAR(l4.DIST_LINE_ID)
WHEN 9 THEN TO_CHAR(l4.DISTRIBUTION_TYPE)
WHEN 10 THEN TO_CHAR(l4.DIST_ENT_AMT)
WHEN 11 THEN TO_CHAR(l4.DIST_CURRENCY_CODE)
WHEN 12 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_DATE)
WHEN 13 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_RATE)
WHEN 14 THEN TO_CHAR(l3.DIST_CUR_CONVERSION_TYPE)
WHEN 15 THEN TO_CHAR(l3.DIST_TO_ACCTD_AMT)
WHEN 16 THEN TO_CHAR(l3.DIST_ACCTD_AMT)
WHEN 17 THEN TO_CHAR(l2.TRX_LINE_DIST_ID)
WHEN 18 THEN TO_CHAR(l2.TRX_DISTRIBUTION_TYPE)
WHEN 19 THEN TO_CHAR(l4.DIST_MFAR_ADDITIONAL_ENTRY)
WHEN 20 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_DATE)
WHEN 21 THEN TO_CHAR(l10.TRX_ENTITY_CODE)
WHEN 22 THEN TO_CHAR(l10.TRX_CUSTOMER_TRX_ID)
WHEN 23 THEN TO_CHAR(l4.DIST_ENT_AMT_FROM)
WHEN 24 THEN TO_CHAR(l4.DIST_CURRENCY_CODE_FROM)
WHEN 25 THEN TO_CHAR(l4.DIST_PARTY_ID)
WHEN 26 THEN TO_CHAR(l4.DIST_PARTY_SITE_ID)
WHEN 27 THEN TO_CHAR(l4.DIST_PARTY_TYPE)
WHEN 28 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_TYPE)
WHEN 29 THEN TO_CHAR(l3.DIST_TO_CUR_CONVERSION_RATE)
WHEN 30 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 <= 30 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_154'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00222_AAD_S_000002_PKG.insert_sources_154');
END insert_sources_154;
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_ACCOUNT_NAME source_16
, h8.RMT_BANK_NAME source_18
, h1.RCT_RECEIPT_NUMBER source_20
, h1.RCT_DOC_SEQUENCE_VALUE source_21
, h5.RCT_MTHD_NAME source_22
, h1.RCT_RECEIPT_DATE source_23
, h9.CODE_COMBINATION_ID_GAIN source_34
, h9.CODE_COMBINATION_ID_LOSS source_35
, h8.RMT_BNK_UNAPPLIED_CCID source_36
, h8.RMT_BNK_UNIDENTIFIED_CCID source_37
, h1.RCT_XLA_APPLIED_TO_APP_ID source_101
, h1.RCT_PAY_FROM_CUSTOMER source_112
, h6.RCT_SITE_SITE_USE_ID source_113
, h1.RCT_APP_STATUS source_114
, h1.RCT_PREV_PAY_FROM_CUSTOMER source_115
, h1.RCT_PREV_CUSTOMER_SITE_USE_ID source_116
, h1.RCT_DOC_SEQUENCE_CATEGORY source_125
, h1.RCT_DOC_SEQUENCE_ID source_126
, h1.RCT_TRX_ACCT_REVERSAL source_127
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
, l10.TRX_TYPE_NAME source_3
, l10.TRX_NUMBER source_4
, l10.TRX_DOC_SEQUENCE_VALUE source_6
, l4.DIST_CODE_COMBINATION_ID source_32
, l4.GAIN_LOSS_CCID source_33
, l4.DIST_SOURCE_TYPE source_39
, l7.REC_ACT_TYPE source_40
, l4.DIST_LINE_ID source_41
, l4.DISTRIBUTION_TYPE source_42
, l4.DIST_ENT_AMT source_43
, l4.DIST_CURRENCY_CODE source_44
, l3.DIST_CUR_CONVERSION_DATE source_45
, l3.DIST_CUR_CONVERSION_RATE source_46
, l3.DIST_CUR_CONVERSION_TYPE source_47
, l3.DIST_TO_ACCTD_AMT source_48
, l3.DIST_ACCTD_AMT source_52
, l2.TRX_LINE_DIST_ID source_56
, l2.TRX_DISTRIBUTION_TYPE source_57
, l4.DIST_MFAR_ADDITIONAL_ENTRY source_99
, l3.DIST_TO_CUR_CONVERSION_DATE source_100
, l10.TRX_ENTITY_CODE source_102
, l10.TRX_CUSTOMER_TRX_ID source_103
, l4.DIST_ENT_AMT_FROM source_104
, l4.DIST_CURRENCY_CODE_FROM source_105
, l4.DIST_PARTY_ID source_106
, l4.DIST_PARTY_SITE_ID source_107
, l4.DIST_PARTY_TYPE source_108
, l3.DIST_TO_CUR_CONVERSION_TYPE source_109
, l3.DIST_TO_CUR_CONVERSION_RATE source_110
, l4.DIST_SOURCE_TABLE source_111
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_143(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_144(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_145(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_146(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_147(
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_148(
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_149(
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_150(
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_151(
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_152(
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_153(
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_154(
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
);