The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NAME
INTO l_meaning_meaning
FROM HR_ALL_ORGANIZATION_UNITS_VL
WHERE ORGANIZATION_ID = p_flex_value
;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(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_103(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'CREDIT MEMOS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_103';
(p_msg => 'BEGIN of insert_sources_103'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 2 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 3 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 4 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 5 THEN 'FSP_PURCH_ENCUMBRANCE_FLAG'
WHEN 6 THEN 'AI_INVOICE_ID'
WHEN 7 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 8 THEN 'INV_EXCHANGE_DATE'
WHEN 9 THEN 'INV_EXCHANGE_RATE'
WHEN 10 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 11 THEN 'AI_VENDOR_ID'
WHEN 12 THEN 'AI_VENDOR_SITE_ID'
WHEN 13 THEN 'THIRD_PARTY_TYPE'
WHEN 14 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 15 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
WHEN 16 THEN 'INV_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.ASP_RATE_VAR_GAIN_CCID)
WHEN 2 THEN TO_CHAR(h3.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 3 THEN TO_CHAR(h3.ASP_RATE_VAR_LOSS_CCID)
WHEN 4 THEN TO_CHAR(h3.ASP_AUTO_OFFSET_FLAG)
WHEN 5 THEN TO_CHAR(h3.FSP_PURCH_ENCUMBRANCE_FLAG)
WHEN 6 THEN TO_CHAR(h2.AI_INVOICE_ID)
WHEN 7 THEN TO_CHAR(h2.AI_INVOICE_CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(h2.INV_EXCHANGE_DATE)
WHEN 9 THEN TO_CHAR(h2.INV_EXCHANGE_RATE)
WHEN 10 THEN TO_CHAR(h2.INV_EXCHANGE_RATE_TYPE)
WHEN 11 THEN TO_CHAR(h2.AI_VENDOR_ID)
WHEN 12 THEN TO_CHAR(h2.AI_VENDOR_SITE_ID)
WHEN 13 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 14 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_CATEGORY)
WHEN 15 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_IDENTIFIER)
WHEN 16 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl7.meaning
WHEN 4 THEN fvl12.meaning
WHEN 5 THEN fvl17.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 3 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 4 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 5 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 12 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 17 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 18 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 19 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 20 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 21 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 22 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 23 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 24 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 42 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 45 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 46 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 47 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
WHEN 46 THEN 'LINE'
WHEN 47 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
WHEN 47 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'AID_DESCRIPTION'
WHEN 2 THEN 'INV_DIST_BASE_AMOUNT'
WHEN 3 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'SELF_ASSESSED_TAX_ACCOUNT'
WHEN 6 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 7 THEN 'AID_AMOUNT_VARIANCE'
WHEN 8 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 9 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 11 THEN 'ALLOC_TO_MAIN_DIST_ID'
WHEN 12 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 13 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 14 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 15 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 16 THEN 'BUS_FLOW_INV_ID'
WHEN 17 THEN 'AID_INVOICE_DIST_ID'
WHEN 18 THEN 'UPG_ENC_CR_CCID'
WHEN 19 THEN 'UPG_ENC_CR_AMT'
WHEN 20 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 21 THEN 'UPG_ENC_DR_CCID'
WHEN 22 THEN 'UPG_ENC_DR_AMT'
WHEN 23 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 24 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 25 THEN 'AID_BASE_AMOUNT_VARIANCE'
WHEN 26 THEN 'DEFERRED_END_DATE'
WHEN 27 THEN 'DEFERRED_OPTION'
WHEN 28 THEN 'DEFERRED_START_DATE'
WHEN 29 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 30 THEN 'AID_PARENT_REVERSAL_ID'
WHEN 31 THEN 'AID_STAT_AMOUNT'
WHEN 32 THEN 'TAX_LINE_ID'
WHEN 33 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 34 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 35 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 36 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 37 THEN 'PO_DISTRIBUTION_ID'
WHEN 38 THEN 'SELF_ASSESSED_TAX_FLAG'
WHEN 39 THEN 'BUS_FLOW_PO_APP_ID'
WHEN 40 THEN 'BUS_FLOW_PO_DIST_TYPE'
WHEN 41 THEN 'BUS_FLOW_PO_ENTITY_CODE'
WHEN 42 THEN 'BUS_FLOW_PO_DIST_ID'
WHEN 43 THEN 'BUS_FLOW_PO_DOC_ID'
WHEN 44 THEN 'ENCUMBRANCE_AMOUNT'
WHEN 45 THEN 'ENCUMBRANCE_BASE_AMOUNT'
WHEN 46 THEN 'AID_QUANTITY_VARIANCE'
WHEN 47 THEN 'AID_BASE_QUANTITY_VARIANCE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.AID_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.INV_DIST_BASE_AMOUNT)
WHEN 3 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_ACCOUNT)
WHEN 6 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 7 THEN TO_CHAR(l1.AID_AMOUNT_VARIANCE)
WHEN 8 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 9 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 10 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_MAIN_DIST_ID)
WHEN 12 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 13 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 17 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 18 THEN TO_CHAR(l1.UPG_ENC_CR_CCID)
WHEN 19 THEN TO_CHAR(l1.UPG_ENC_CR_AMT)
WHEN 20 THEN TO_CHAR(l1.UPG_ENC_CR_BASE_AMT)
WHEN 21 THEN TO_CHAR(l1.UPG_ENC_DR_CCID)
WHEN 22 THEN TO_CHAR(l1.UPG_ENC_DR_AMT)
WHEN 23 THEN TO_CHAR(l1.UPG_ENC_DR_BASE_AMT)
WHEN 24 THEN TO_CHAR(l1.UPG_AP_ENCUM_OPTION)
WHEN 25 THEN TO_CHAR(l1.AID_BASE_AMOUNT_VARIANCE)
WHEN 26 THEN TO_CHAR(l1.DEFERRED_END_DATE)
WHEN 27 THEN TO_CHAR(l1.DEFERRED_OPTION)
WHEN 28 THEN TO_CHAR(l1.DEFERRED_START_DATE)
WHEN 29 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 30 THEN TO_CHAR(l1.AID_PARENT_REVERSAL_ID)
WHEN 31 THEN TO_CHAR(l1.AID_STAT_AMOUNT)
WHEN 32 THEN TO_CHAR(l4.TAX_LINE_ID)
WHEN 33 THEN TO_CHAR(l5.REC_NREC_TAX_DIST_ID)
WHEN 34 THEN TO_CHAR(l1.SUMMARY_TAX_LINE_ID)
WHEN 35 THEN TO_CHAR(l1.UPG_CR_ENC_TYPE_ID)
WHEN 36 THEN TO_CHAR(l1.UPG_DR_ENC_TYPE_ID)
WHEN 37 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 38 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_FLAG)
WHEN 39 THEN TO_CHAR(l1.BUS_FLOW_PO_APP_ID)
WHEN 40 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_TYPE)
WHEN 41 THEN TO_CHAR(l1.BUS_FLOW_PO_ENTITY_CODE)
WHEN 42 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_ID)
WHEN 43 THEN TO_CHAR(l1.BUS_FLOW_PO_DOC_ID)
WHEN 44 THEN TO_CHAR(l1.ENCUMBRANCE_AMOUNT)
WHEN 45 THEN TO_CHAR(l1.ENCUMBRANCE_BASE_AMOUNT)
WHEN 46 THEN TO_CHAR(l1.AID_QUANTITY_VARIANCE)
WHEN 47 THEN TO_CHAR(l1.AID_BASE_QUANTITY_VARIANCE)
ELSE null
END source_value
, CASE r
WHEN 3 THEN fvl9.meaning
WHEN 6 THEN fvl15.meaning
WHEN 8 THEN fvl18.meaning
WHEN 29 THEN fvl46.meaning
WHEN 38 THEN fvl59.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
, (select rownum r from all_objects where rownum <= 47 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 l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_103'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_103');
END insert_sources_103;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT MEMOS
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
, h3.ASP_RATE_VAR_GAIN_CCID source_6
, h3.ASP_AUTOMATIC_OFFSETS_VALUE source_7
, fvl7.meaning source_7_meaning
, h3.ASP_RATE_VAR_LOSS_CCID source_10
, h3.ASP_AUTO_OFFSET_FLAG source_12
, fvl12.meaning source_12_meaning
, h3.FSP_PURCH_ENCUMBRANCE_FLAG source_17
, fvl17.meaning source_17_meaning
, h2.AI_INVOICE_ID source_24
, h2.AI_INVOICE_CURRENCY_CODE source_33
, h2.INV_EXCHANGE_DATE source_39
, h2.INV_EXCHANGE_RATE source_40
, h2.INV_EXCHANGE_RATE_TYPE source_41
, h2.AI_VENDOR_ID source_47
, h2.AI_VENDOR_SITE_ID source_48
, h2.THIRD_PARTY_TYPE source_49
, h2.INV_DOC_SEQUENCE_CATEGORY source_122
, h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
, h2.INV_DOC_SEQUENCE_VALUE source_124
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: CREDIT MEMOS
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
, l1.AID_DESCRIPTION source_1
, l1.INV_DIST_BASE_AMOUNT source_8
, l1.RELATED_INV_DIST_DEST_TYPE source_9
, fvl9.meaning source_9_meaning
, l1.AID_DIST_CCID source_11
, l1.SELF_ASSESSED_TAX_ACCOUNT source_13
, l1.AID_LINE_TYPE_LOOKUP_CODE source_15
, fvl15.meaning source_15_meaning
, l1.AID_AMOUNT_VARIANCE source_16
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_18
, fvl18.meaning source_18_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_19
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.ALLOC_TO_MAIN_DIST_ID source_23
, l1.BUS_FLOW_AP_APP_ID source_25
, l1.BUS_FLOW_INV_DIST_TYPE source_26
, l1.BUS_FLOW_INV_ENTITY_CODE source_27
, l1.BUS_FLOW_INV_DIST_ID source_28
, l1.BUS_FLOW_INV_ID source_29
, l1.AID_INVOICE_DIST_ID source_30
, l1.UPG_ENC_CR_CCID source_31
, l1.UPG_ENC_CR_AMT source_32
, l1.UPG_ENC_CR_BASE_AMT source_34
, l1.UPG_ENC_DR_CCID source_35
, l1.UPG_ENC_DR_AMT source_36
, l1.UPG_ENC_DR_BASE_AMT source_37
, l1.UPG_AP_ENCUM_OPTION source_38
, l1.AID_BASE_AMOUNT_VARIANCE source_42
, l1.DEFERRED_END_DATE source_43
, l1.DEFERRED_OPTION source_44
, l1.DEFERRED_START_DATE source_45
, l1.OVERRIDE_ACCTD_AMT_FLAG source_46
, fvl46.meaning source_46_meaning
, l1.AID_PARENT_REVERSAL_ID source_50
, l1.AID_STAT_AMOUNT source_51
, l4.TAX_LINE_ID source_52
, l5.REC_NREC_TAX_DIST_ID source_53
, l1.SUMMARY_TAX_LINE_ID source_54
, l1.UPG_CR_ENC_TYPE_ID source_55
, l1.UPG_DR_ENC_TYPE_ID source_56
, l1.PO_DISTRIBUTION_ID source_58
, l1.SELF_ASSESSED_TAX_FLAG source_59
, fvl59.meaning source_59_meaning
, l1.BUS_FLOW_PO_APP_ID source_60
, l1.BUS_FLOW_PO_DIST_TYPE source_61
, l1.BUS_FLOW_PO_ENTITY_CODE source_62
, l1.BUS_FLOW_PO_DIST_ID source_63
, l1.BUS_FLOW_PO_DOC_ID source_64
, l1.ENCUMBRANCE_AMOUNT source_65
, l1.ENCUMBRANCE_BASE_AMOUNT source_66
, l1.AID_QUANTITY_VARIANCE source_81
, l1.AID_BASE_QUANTITY_VARIANCE source_82
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
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 l1.ZRND_tax_dist_id = l4.REC_NREC_TAX_DIST_ID (+) AND l1.ZRND_tax_dist_id = l5.REC_NREC_TAX_DIST_ID (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_104(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'DEBIT MEMOS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_104';
(p_msg => 'BEGIN of insert_sources_104'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 2 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 3 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 4 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 5 THEN 'FSP_PURCH_ENCUMBRANCE_FLAG'
WHEN 6 THEN 'AI_INVOICE_ID'
WHEN 7 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 8 THEN 'INV_EXCHANGE_DATE'
WHEN 9 THEN 'INV_EXCHANGE_RATE'
WHEN 10 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 11 THEN 'AI_VENDOR_ID'
WHEN 12 THEN 'AI_VENDOR_SITE_ID'
WHEN 13 THEN 'THIRD_PARTY_TYPE'
WHEN 14 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 15 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
WHEN 16 THEN 'INV_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.ASP_RATE_VAR_GAIN_CCID)
WHEN 2 THEN TO_CHAR(h3.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 3 THEN TO_CHAR(h3.ASP_RATE_VAR_LOSS_CCID)
WHEN 4 THEN TO_CHAR(h3.ASP_AUTO_OFFSET_FLAG)
WHEN 5 THEN TO_CHAR(h3.FSP_PURCH_ENCUMBRANCE_FLAG)
WHEN 6 THEN TO_CHAR(h2.AI_INVOICE_ID)
WHEN 7 THEN TO_CHAR(h2.AI_INVOICE_CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(h2.INV_EXCHANGE_DATE)
WHEN 9 THEN TO_CHAR(h2.INV_EXCHANGE_RATE)
WHEN 10 THEN TO_CHAR(h2.INV_EXCHANGE_RATE_TYPE)
WHEN 11 THEN TO_CHAR(h2.AI_VENDOR_ID)
WHEN 12 THEN TO_CHAR(h2.AI_VENDOR_SITE_ID)
WHEN 13 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 14 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_CATEGORY)
WHEN 15 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_IDENTIFIER)
WHEN 16 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl7.meaning
WHEN 4 THEN fvl12.meaning
WHEN 5 THEN fvl17.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h3.asp_org_id= h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 3 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 4 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 5 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 12 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 17 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 18 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 19 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 20 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 21 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 22 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 23 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 24 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 31 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 32 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 42 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 45 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 46 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
WHEN 46 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'AID_DESCRIPTION'
WHEN 2 THEN 'INV_DIST_BASE_AMOUNT'
WHEN 3 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'SELF_ASSESSED_TAX_ACCOUNT'
WHEN 6 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 7 THEN 'AID_AMOUNT_VARIANCE'
WHEN 8 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 9 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 11 THEN 'ALLOC_TO_MAIN_DIST_ID'
WHEN 12 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 13 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 14 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 15 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 16 THEN 'BUS_FLOW_INV_ID'
WHEN 17 THEN 'AID_INVOICE_DIST_ID'
WHEN 18 THEN 'UPG_ENC_CR_CCID'
WHEN 19 THEN 'UPG_ENC_CR_AMT'
WHEN 20 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 21 THEN 'UPG_ENC_DR_CCID'
WHEN 22 THEN 'UPG_ENC_DR_AMT'
WHEN 23 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 24 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 25 THEN 'AID_BASE_AMOUNT_VARIANCE'
WHEN 26 THEN 'DEFERRED_END_DATE'
WHEN 27 THEN 'DEFERRED_OPTION'
WHEN 28 THEN 'DEFERRED_START_DATE'
WHEN 29 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 30 THEN 'AID_PARENT_REVERSAL_ID'
WHEN 31 THEN 'TAX_LINE_ID'
WHEN 32 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 33 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 34 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 35 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 36 THEN 'PO_DISTRIBUTION_ID'
WHEN 37 THEN 'SELF_ASSESSED_TAX_FLAG'
WHEN 38 THEN 'BUS_FLOW_PO_APP_ID'
WHEN 39 THEN 'BUS_FLOW_PO_DIST_TYPE'
WHEN 40 THEN 'BUS_FLOW_PO_ENTITY_CODE'
WHEN 41 THEN 'BUS_FLOW_PO_DIST_ID'
WHEN 42 THEN 'BUS_FLOW_PO_DOC_ID'
WHEN 43 THEN 'ENCUMBRANCE_AMOUNT'
WHEN 44 THEN 'ENCUMBRANCE_BASE_AMOUNT'
WHEN 45 THEN 'AID_QUANTITY_VARIANCE'
WHEN 46 THEN 'AID_BASE_QUANTITY_VARIANCE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.AID_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.INV_DIST_BASE_AMOUNT)
WHEN 3 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_ACCOUNT)
WHEN 6 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 7 THEN TO_CHAR(l1.AID_AMOUNT_VARIANCE)
WHEN 8 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 9 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 10 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_MAIN_DIST_ID)
WHEN 12 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 13 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 17 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 18 THEN TO_CHAR(l1.UPG_ENC_CR_CCID)
WHEN 19 THEN TO_CHAR(l1.UPG_ENC_CR_AMT)
WHEN 20 THEN TO_CHAR(l1.UPG_ENC_CR_BASE_AMT)
WHEN 21 THEN TO_CHAR(l1.UPG_ENC_DR_CCID)
WHEN 22 THEN TO_CHAR(l1.UPG_ENC_DR_AMT)
WHEN 23 THEN TO_CHAR(l1.UPG_ENC_DR_BASE_AMT)
WHEN 24 THEN TO_CHAR(l1.UPG_AP_ENCUM_OPTION)
WHEN 25 THEN TO_CHAR(l1.AID_BASE_AMOUNT_VARIANCE)
WHEN 26 THEN TO_CHAR(l1.DEFERRED_END_DATE)
WHEN 27 THEN TO_CHAR(l1.DEFERRED_OPTION)
WHEN 28 THEN TO_CHAR(l1.DEFERRED_START_DATE)
WHEN 29 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 30 THEN TO_CHAR(l1.AID_PARENT_REVERSAL_ID)
WHEN 31 THEN TO_CHAR(l4.TAX_LINE_ID)
WHEN 32 THEN TO_CHAR(l5.REC_NREC_TAX_DIST_ID)
WHEN 33 THEN TO_CHAR(l1.SUMMARY_TAX_LINE_ID)
WHEN 34 THEN TO_CHAR(l1.UPG_CR_ENC_TYPE_ID)
WHEN 35 THEN TO_CHAR(l1.UPG_DR_ENC_TYPE_ID)
WHEN 36 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 37 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_FLAG)
WHEN 38 THEN TO_CHAR(l1.BUS_FLOW_PO_APP_ID)
WHEN 39 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_TYPE)
WHEN 40 THEN TO_CHAR(l1.BUS_FLOW_PO_ENTITY_CODE)
WHEN 41 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_ID)
WHEN 42 THEN TO_CHAR(l1.BUS_FLOW_PO_DOC_ID)
WHEN 43 THEN TO_CHAR(l1.ENCUMBRANCE_AMOUNT)
WHEN 44 THEN TO_CHAR(l1.ENCUMBRANCE_BASE_AMOUNT)
WHEN 45 THEN TO_CHAR(l1.AID_QUANTITY_VARIANCE)
WHEN 46 THEN TO_CHAR(l1.AID_BASE_QUANTITY_VARIANCE)
ELSE null
END source_value
, CASE r
WHEN 3 THEN fvl9.meaning
WHEN 6 THEN fvl15.meaning
WHEN 8 THEN fvl18.meaning
WHEN 29 THEN fvl46.meaning
WHEN 37 THEN fvl59.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
, (select rownum r from all_objects where rownum <= 46 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 l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_104'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_104');
END insert_sources_104;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT MEMOS
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
, h3.ASP_RATE_VAR_GAIN_CCID source_6
, h3.ASP_AUTOMATIC_OFFSETS_VALUE source_7
, fvl7.meaning source_7_meaning
, h3.ASP_RATE_VAR_LOSS_CCID source_10
, h3.ASP_AUTO_OFFSET_FLAG source_12
, fvl12.meaning source_12_meaning
, h3.FSP_PURCH_ENCUMBRANCE_FLAG source_17
, fvl17.meaning source_17_meaning
, h2.AI_INVOICE_ID source_24
, h2.AI_INVOICE_CURRENCY_CODE source_33
, h2.INV_EXCHANGE_DATE source_39
, h2.INV_EXCHANGE_RATE source_40
, h2.INV_EXCHANGE_RATE_TYPE source_41
, h2.AI_VENDOR_ID source_47
, h2.AI_VENDOR_SITE_ID source_48
, h2.THIRD_PARTY_TYPE source_49
, h2.INV_DOC_SEQUENCE_CATEGORY source_122
, h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
, h2.INV_DOC_SEQUENCE_VALUE source_124
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h3.asp_org_id= h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DEBIT MEMOS
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
, l1.AID_DESCRIPTION source_1
, l1.INV_DIST_BASE_AMOUNT source_8
, l1.RELATED_INV_DIST_DEST_TYPE source_9
, fvl9.meaning source_9_meaning
, l1.AID_DIST_CCID source_11
, l1.SELF_ASSESSED_TAX_ACCOUNT source_13
, l1.AID_LINE_TYPE_LOOKUP_CODE source_15
, fvl15.meaning source_15_meaning
, l1.AID_AMOUNT_VARIANCE source_16
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_18
, fvl18.meaning source_18_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_19
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.ALLOC_TO_MAIN_DIST_ID source_23
, l1.BUS_FLOW_AP_APP_ID source_25
, l1.BUS_FLOW_INV_DIST_TYPE source_26
, l1.BUS_FLOW_INV_ENTITY_CODE source_27
, l1.BUS_FLOW_INV_DIST_ID source_28
, l1.BUS_FLOW_INV_ID source_29
, l1.AID_INVOICE_DIST_ID source_30
, l1.UPG_ENC_CR_CCID source_31
, l1.UPG_ENC_CR_AMT source_32
, l1.UPG_ENC_CR_BASE_AMT source_34
, l1.UPG_ENC_DR_CCID source_35
, l1.UPG_ENC_DR_AMT source_36
, l1.UPG_ENC_DR_BASE_AMT source_37
, l1.UPG_AP_ENCUM_OPTION source_38
, l1.AID_BASE_AMOUNT_VARIANCE source_42
, l1.DEFERRED_END_DATE source_43
, l1.DEFERRED_OPTION source_44
, l1.DEFERRED_START_DATE source_45
, l1.OVERRIDE_ACCTD_AMT_FLAG source_46
, fvl46.meaning source_46_meaning
, l1.AID_PARENT_REVERSAL_ID source_50
, l4.TAX_LINE_ID source_52
, l5.REC_NREC_TAX_DIST_ID source_53
, l1.SUMMARY_TAX_LINE_ID source_54
, l1.UPG_CR_ENC_TYPE_ID source_55
, l1.UPG_DR_ENC_TYPE_ID source_56
, l1.PO_DISTRIBUTION_ID source_58
, l1.SELF_ASSESSED_TAX_FLAG source_59
, fvl59.meaning source_59_meaning
, l1.BUS_FLOW_PO_APP_ID source_60
, l1.BUS_FLOW_PO_DIST_TYPE source_61
, l1.BUS_FLOW_PO_ENTITY_CODE source_62
, l1.BUS_FLOW_PO_DIST_ID source_63
, l1.BUS_FLOW_PO_DOC_ID source_64
, l1.ENCUMBRANCE_AMOUNT source_65
, l1.ENCUMBRANCE_BASE_AMOUNT source_66
, l1.AID_QUANTITY_VARIANCE source_81
, l1.AID_BASE_QUANTITY_VARIANCE source_82
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
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 l1.ZRND_tax_dist_id = l4.REC_NREC_TAX_DIST_ID (+) AND l1.ZRND_tax_dist_id = l5.REC_NREC_TAX_DIST_ID (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_105(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'INVOICES_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_105';
(p_msg => 'BEGIN of insert_sources_105'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 17 THEN 'AP_INVOICE_EXTRACT_HEADER_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 '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 2 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 3 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 4 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 5 THEN 'FSP_PURCH_ENCUMBRANCE_FLAG'
WHEN 6 THEN 'AI_INVOICE_ID'
WHEN 7 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 8 THEN 'INV_EXCHANGE_DATE'
WHEN 9 THEN 'INV_EXCHANGE_RATE'
WHEN 10 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 11 THEN 'AI_VENDOR_ID'
WHEN 12 THEN 'AI_VENDOR_SITE_ID'
WHEN 13 THEN 'THIRD_PARTY_TYPE'
WHEN 14 THEN 'AI_INVOICE_TYPE_LOOKUP_CODE'
WHEN 15 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 16 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
WHEN 17 THEN 'INV_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.ASP_RATE_VAR_GAIN_CCID)
WHEN 2 THEN TO_CHAR(h3.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 3 THEN TO_CHAR(h3.ASP_RATE_VAR_LOSS_CCID)
WHEN 4 THEN TO_CHAR(h3.ASP_AUTO_OFFSET_FLAG)
WHEN 5 THEN TO_CHAR(h3.FSP_PURCH_ENCUMBRANCE_FLAG)
WHEN 6 THEN TO_CHAR(h2.AI_INVOICE_ID)
WHEN 7 THEN TO_CHAR(h2.AI_INVOICE_CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(h2.INV_EXCHANGE_DATE)
WHEN 9 THEN TO_CHAR(h2.INV_EXCHANGE_RATE)
WHEN 10 THEN TO_CHAR(h2.INV_EXCHANGE_RATE_TYPE)
WHEN 11 THEN TO_CHAR(h2.AI_VENDOR_ID)
WHEN 12 THEN TO_CHAR(h2.AI_VENDOR_SITE_ID)
WHEN 13 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 14 THEN TO_CHAR(h2.AI_INVOICE_TYPE_LOOKUP_CODE)
WHEN 15 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_CATEGORY)
WHEN 16 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_IDENTIFIER)
WHEN 17 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl7.meaning
WHEN 4 THEN fvl12.meaning
WHEN 5 THEN fvl17.meaning
WHEN 14 THEN fvl68.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
, fnd_lookup_values fvl68
,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
AND fvl68.lookup_type(+) = 'INVOICE TYPE'
AND fvl68.lookup_code(+) = h2.AI_INVOICE_TYPE_LOOKUP_CODE
AND fvl68.view_application_id(+) = 200
AND fvl68.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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 3 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 4 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 5 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 12 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 17 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 18 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 19 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 20 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 21 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 22 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 23 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 24 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 42 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 45 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 46 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 47 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 48 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
WHEN 46 THEN 'LINE'
WHEN 47 THEN 'LINE'
WHEN 48 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
WHEN 47 THEN '200'
WHEN 48 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'AID_DESCRIPTION'
WHEN 2 THEN 'INV_DIST_BASE_AMOUNT'
WHEN 3 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'SELF_ASSESSED_TAX_ACCOUNT'
WHEN 6 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 7 THEN 'AID_AMOUNT_VARIANCE'
WHEN 8 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 9 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 11 THEN 'ALLOC_TO_MAIN_DIST_ID'
WHEN 12 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 13 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 14 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 15 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 16 THEN 'BUS_FLOW_INV_ID'
WHEN 17 THEN 'AID_INVOICE_DIST_ID'
WHEN 18 THEN 'UPG_ENC_CR_CCID'
WHEN 19 THEN 'UPG_ENC_CR_AMT'
WHEN 20 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 21 THEN 'UPG_ENC_DR_CCID'
WHEN 22 THEN 'UPG_ENC_DR_AMT'
WHEN 23 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 24 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 25 THEN 'AID_BASE_AMOUNT_VARIANCE'
WHEN 26 THEN 'DEFERRED_END_DATE'
WHEN 27 THEN 'DEFERRED_OPTION'
WHEN 28 THEN 'DEFERRED_START_DATE'
WHEN 29 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 30 THEN 'AID_PARENT_REVERSAL_ID'
WHEN 31 THEN 'AID_STAT_AMOUNT'
WHEN 32 THEN 'TAX_LINE_ID'
WHEN 33 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 34 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 35 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 36 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 37 THEN 'AID_AMOUNT'
WHEN 38 THEN 'PO_DISTRIBUTION_ID'
WHEN 39 THEN 'SELF_ASSESSED_TAX_FLAG'
WHEN 40 THEN 'BUS_FLOW_PO_APP_ID'
WHEN 41 THEN 'BUS_FLOW_PO_DIST_TYPE'
WHEN 42 THEN 'BUS_FLOW_PO_ENTITY_CODE'
WHEN 43 THEN 'BUS_FLOW_PO_DIST_ID'
WHEN 44 THEN 'BUS_FLOW_PO_DOC_ID'
WHEN 45 THEN 'ENCUMBRANCE_AMOUNT'
WHEN 46 THEN 'ENCUMBRANCE_BASE_AMOUNT'
WHEN 47 THEN 'AID_QUANTITY_VARIANCE'
WHEN 48 THEN 'AID_BASE_QUANTITY_VARIANCE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.AID_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.INV_DIST_BASE_AMOUNT)
WHEN 3 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_ACCOUNT)
WHEN 6 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 7 THEN TO_CHAR(l1.AID_AMOUNT_VARIANCE)
WHEN 8 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 9 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 10 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_MAIN_DIST_ID)
WHEN 12 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 13 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 17 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 18 THEN TO_CHAR(l1.UPG_ENC_CR_CCID)
WHEN 19 THEN TO_CHAR(l1.UPG_ENC_CR_AMT)
WHEN 20 THEN TO_CHAR(l1.UPG_ENC_CR_BASE_AMT)
WHEN 21 THEN TO_CHAR(l1.UPG_ENC_DR_CCID)
WHEN 22 THEN TO_CHAR(l1.UPG_ENC_DR_AMT)
WHEN 23 THEN TO_CHAR(l1.UPG_ENC_DR_BASE_AMT)
WHEN 24 THEN TO_CHAR(l1.UPG_AP_ENCUM_OPTION)
WHEN 25 THEN TO_CHAR(l1.AID_BASE_AMOUNT_VARIANCE)
WHEN 26 THEN TO_CHAR(l1.DEFERRED_END_DATE)
WHEN 27 THEN TO_CHAR(l1.DEFERRED_OPTION)
WHEN 28 THEN TO_CHAR(l1.DEFERRED_START_DATE)
WHEN 29 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 30 THEN TO_CHAR(l1.AID_PARENT_REVERSAL_ID)
WHEN 31 THEN TO_CHAR(l1.AID_STAT_AMOUNT)
WHEN 32 THEN TO_CHAR(l4.TAX_LINE_ID)
WHEN 33 THEN TO_CHAR(l5.REC_NREC_TAX_DIST_ID)
WHEN 34 THEN TO_CHAR(l1.SUMMARY_TAX_LINE_ID)
WHEN 35 THEN TO_CHAR(l1.UPG_CR_ENC_TYPE_ID)
WHEN 36 THEN TO_CHAR(l1.UPG_DR_ENC_TYPE_ID)
WHEN 37 THEN TO_CHAR(l1.AID_AMOUNT)
WHEN 38 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 39 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_FLAG)
WHEN 40 THEN TO_CHAR(l1.BUS_FLOW_PO_APP_ID)
WHEN 41 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_TYPE)
WHEN 42 THEN TO_CHAR(l1.BUS_FLOW_PO_ENTITY_CODE)
WHEN 43 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_ID)
WHEN 44 THEN TO_CHAR(l1.BUS_FLOW_PO_DOC_ID)
WHEN 45 THEN TO_CHAR(l1.ENCUMBRANCE_AMOUNT)
WHEN 46 THEN TO_CHAR(l1.ENCUMBRANCE_BASE_AMOUNT)
WHEN 47 THEN TO_CHAR(l1.AID_QUANTITY_VARIANCE)
WHEN 48 THEN TO_CHAR(l1.AID_BASE_QUANTITY_VARIANCE)
ELSE null
END source_value
, CASE r
WHEN 3 THEN fvl9.meaning
WHEN 6 THEN fvl15.meaning
WHEN 8 THEN fvl18.meaning
WHEN 29 THEN fvl46.meaning
WHEN 39 THEN fvl59.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
, (select rownum r from all_objects where rownum <= 48 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 l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_105'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_105');
END insert_sources_105;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICES
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
, h3.ASP_RATE_VAR_GAIN_CCID source_6
, h3.ASP_AUTOMATIC_OFFSETS_VALUE source_7
, fvl7.meaning source_7_meaning
, h3.ASP_RATE_VAR_LOSS_CCID source_10
, h3.ASP_AUTO_OFFSET_FLAG source_12
, fvl12.meaning source_12_meaning
, h3.FSP_PURCH_ENCUMBRANCE_FLAG source_17
, fvl17.meaning source_17_meaning
, h2.AI_INVOICE_ID source_24
, h2.AI_INVOICE_CURRENCY_CODE source_33
, h2.INV_EXCHANGE_DATE source_39
, h2.INV_EXCHANGE_RATE source_40
, h2.INV_EXCHANGE_RATE_TYPE source_41
, h2.AI_VENDOR_ID source_47
, h2.AI_VENDOR_SITE_ID source_48
, h2.THIRD_PARTY_TYPE source_49
, h2.AI_INVOICE_TYPE_LOOKUP_CODE source_68
, fvl68.meaning source_68_meaning
, h2.INV_DOC_SEQUENCE_CATEGORY source_122
, h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
, h2.INV_DOC_SEQUENCE_VALUE source_124
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
, fnd_lookup_values fvl68
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
AND fvl68.lookup_type(+) = 'INVOICE TYPE'
AND fvl68.lookup_code(+) = h2.AI_INVOICE_TYPE_LOOKUP_CODE
AND fvl68.view_application_id(+) = 200
AND fvl68.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICES
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
, l1.AID_DESCRIPTION source_1
, l1.INV_DIST_BASE_AMOUNT source_8
, l1.RELATED_INV_DIST_DEST_TYPE source_9
, fvl9.meaning source_9_meaning
, l1.AID_DIST_CCID source_11
, l1.SELF_ASSESSED_TAX_ACCOUNT source_13
, l1.AID_LINE_TYPE_LOOKUP_CODE source_15
, fvl15.meaning source_15_meaning
, l1.AID_AMOUNT_VARIANCE source_16
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_18
, fvl18.meaning source_18_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_19
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.ALLOC_TO_MAIN_DIST_ID source_23
, l1.BUS_FLOW_AP_APP_ID source_25
, l1.BUS_FLOW_INV_DIST_TYPE source_26
, l1.BUS_FLOW_INV_ENTITY_CODE source_27
, l1.BUS_FLOW_INV_DIST_ID source_28
, l1.BUS_FLOW_INV_ID source_29
, l1.AID_INVOICE_DIST_ID source_30
, l1.UPG_ENC_CR_CCID source_31
, l1.UPG_ENC_CR_AMT source_32
, l1.UPG_ENC_CR_BASE_AMT source_34
, l1.UPG_ENC_DR_CCID source_35
, l1.UPG_ENC_DR_AMT source_36
, l1.UPG_ENC_DR_BASE_AMT source_37
, l1.UPG_AP_ENCUM_OPTION source_38
, l1.AID_BASE_AMOUNT_VARIANCE source_42
, l1.DEFERRED_END_DATE source_43
, l1.DEFERRED_OPTION source_44
, l1.DEFERRED_START_DATE source_45
, l1.OVERRIDE_ACCTD_AMT_FLAG source_46
, fvl46.meaning source_46_meaning
, l1.AID_PARENT_REVERSAL_ID source_50
, l1.AID_STAT_AMOUNT source_51
, l4.TAX_LINE_ID source_52
, l5.REC_NREC_TAX_DIST_ID source_53
, l1.SUMMARY_TAX_LINE_ID source_54
, l1.UPG_CR_ENC_TYPE_ID source_55
, l1.UPG_DR_ENC_TYPE_ID source_56
, l1.AID_AMOUNT source_57
, l1.PO_DISTRIBUTION_ID source_58
, l1.SELF_ASSESSED_TAX_FLAG source_59
, fvl59.meaning source_59_meaning
, l1.BUS_FLOW_PO_APP_ID source_60
, l1.BUS_FLOW_PO_DIST_TYPE source_61
, l1.BUS_FLOW_PO_ENTITY_CODE source_62
, l1.BUS_FLOW_PO_DIST_ID source_63
, l1.BUS_FLOW_PO_DOC_ID source_64
, l1.ENCUMBRANCE_AMOUNT source_65
, l1.ENCUMBRANCE_BASE_AMOUNT source_66
, l1.AID_QUANTITY_VARIANCE source_81
, l1.AID_BASE_QUANTITY_VARIANCE source_82
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
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 l1.ZRND_tax_dist_id = l4.REC_NREC_TAX_DIST_ID (+) AND l1.ZRND_tax_dist_id = l5.REC_NREC_TAX_DIST_ID (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_106(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'INVOICE_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_106';
(p_msg => 'BEGIN of insert_sources_106'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 3 THEN 'PA_XLA_TASK_REF_V'
WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 14 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 41 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 42 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 43 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 44 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 45 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 46 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 47 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 48 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 49 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 50 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 51 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
WHEN 46 THEN 'LINE'
WHEN 47 THEN 'LINE'
WHEN 48 THEN 'LINE'
WHEN 49 THEN 'LINE'
WHEN 50 THEN 'LINE'
WHEN 51 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '275'
WHEN 3 THEN '275'
WHEN 4 THEN '275'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '275'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
WHEN 47 THEN '200'
WHEN 48 THEN '200'
WHEN 49 THEN '200'
WHEN 50 THEN '200'
WHEN 51 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOCUMENT_DISTRIBUTION_TYPE'
WHEN 2 THEN 'PROJECT_NAME'
WHEN 3 THEN 'TASK_NUMBER'
WHEN 4 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 5 THEN 'BUDGET_CCID'
WHEN 6 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 7 THEN 'AID_INVOICE_DIST_ID'
WHEN 8 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 9 THEN 'INV_EXCHANGE_DATE'
WHEN 10 THEN 'INV_EXCHANGE_RATE'
WHEN 11 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 12 THEN 'AID_AMOUNT'
WHEN 13 THEN 'DOCUMENT_TYPE'
WHEN 14 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 15 THEN 'ACCT_REVERSAL_INDICATOR'
WHEN 16 THEN 'ALLOC_TO_APPLN_ID'
WHEN 17 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 18 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 19 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 20 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 21 THEN 'AP_APPLICATION_ID'
WHEN 22 THEN 'AP_DISTRIBUTION_TYPE'
WHEN 23 THEN 'AP_ENTITY_CODE'
WHEN 24 THEN 'AP_FIRST_DIST_ID'
WHEN 25 THEN 'AP_FIRST_SYS_TRANS_ID'
WHEN 26 THEN 'AID_EXPENDITURE_TYPE'
WHEN 27 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 28 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 29 THEN 'AID_BASE_AMT_NO_ROUND'
WHEN 30 THEN 'ENC_UPG_DR_ACCT_CLASS'
WHEN 31 THEN 'ENC_UPG_DR_ACCOUNT'
WHEN 32 THEN 'USE_ENC_UPG_ATTRIB_FLAG'
WHEN 33 THEN 'ACCT_REVERSAL_FIRST_DIST_ID'
WHEN 34 THEN 'AP_SECOND_DIST_ID'
WHEN 35 THEN 'ACCT_REV_DISTRIBUTION_TYPE'
WHEN 36 THEN 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 37 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 38 THEN 'BURDEN_COST_FLAG'
WHEN 39 THEN 'PA_APPLICATION_ID'
WHEN 40 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 41 THEN 'PA_ENTITY_CODE'
WHEN 42 THEN 'PA_FIRST_DIST_ID'
WHEN 43 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 44 THEN 'PA_SECOND_DIST_ID'
WHEN 45 THEN 'PO_RELEASE_ID'
WHEN 46 THEN 'PO_APPLICATION_ID'
WHEN 47 THEN 'PO_DISTRIBUTION_TYPE'
WHEN 48 THEN 'PO_ENTITY_CODE'
WHEN 49 THEN 'PO_FIRST_DIST_ID'
WHEN 50 THEN 'PO_FIRST_SYS_TRANS_ID'
WHEN 51 THEN 'PO_SECOND_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.DOCUMENT_DISTRIBUTION_TYPE)
WHEN 2 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 3 THEN TO_CHAR(l4.TASK_NUMBER)
WHEN 4 THEN TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
WHEN 5 THEN TO_CHAR(l1.BUDGET_CCID)
WHEN 6 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 7 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 8 THEN TO_CHAR(l1.AI_INVOICE_CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(l1.INV_EXCHANGE_DATE)
WHEN 10 THEN TO_CHAR(l1.INV_EXCHANGE_RATE)
WHEN 11 THEN TO_CHAR(l1.INV_EXCHANGE_RATE_TYPE)
WHEN 12 THEN TO_CHAR(l1.AID_AMOUNT)
WHEN 13 THEN TO_CHAR(l1.DOCUMENT_TYPE)
WHEN 14 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 15 THEN TO_CHAR(l1.ACCT_REVERSAL_INDICATOR)
WHEN 16 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 17 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 18 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 19 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 20 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 21 THEN TO_CHAR(l1.AP_APPLICATION_ID)
WHEN 22 THEN TO_CHAR(l1.AP_DISTRIBUTION_TYPE)
WHEN 23 THEN TO_CHAR(l1.AP_ENTITY_CODE)
WHEN 24 THEN TO_CHAR(l1.AP_FIRST_DIST_ID)
WHEN 25 THEN TO_CHAR(l1.AP_FIRST_SYS_TRANS_ID)
WHEN 26 THEN TO_CHAR(l1.AID_EXPENDITURE_TYPE)
WHEN 27 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
WHEN 28 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
WHEN 29 THEN TO_CHAR(l1.AID_BASE_AMT_NO_ROUND)
WHEN 30 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
WHEN 31 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
WHEN 32 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
WHEN 33 THEN TO_CHAR(l1.ACCT_REVERSAL_FIRST_DIST_ID)
WHEN 34 THEN TO_CHAR(l1.AP_SECOND_DIST_ID)
WHEN 35 THEN TO_CHAR(l1.ACCT_REV_DISTRIBUTION_TYPE)
WHEN 36 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 37 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 38 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 39 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 40 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 41 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 42 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 43 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 44 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
WHEN 45 THEN TO_CHAR(l1.PO_RELEASE_ID)
WHEN 46 THEN TO_CHAR(l1.PO_APPLICATION_ID)
WHEN 47 THEN TO_CHAR(l1.PO_DISTRIBUTION_TYPE)
WHEN 48 THEN TO_CHAR(l1.PO_ENTITY_CODE)
WHEN 49 THEN TO_CHAR(l1.PO_FIRST_DIST_ID)
WHEN 50 THEN TO_CHAR(l1.PO_FIRST_SYS_TRANS_ID)
WHEN 51 THEN TO_CHAR(l1.PO_SECOND_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 4 THEN XLA_00200_AAD_S_000006_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,275)
WHEN 38 THEN fvl108.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
, (select rownum r from all_objects where rownum <= 51 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.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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_106'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_106');
END insert_sources_106;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE_BURDEN
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
FROM xla_events_gt xet
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'
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVOICE_BURDEN
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
, l1.DOCUMENT_DISTRIBUTION_TYPE source_2
, l3.PROJECT_NAME source_3
, l4.TASK_NUMBER source_4
, l2.EXPENDITURE_ORGANIZATION_ID source_5
, l1.BUDGET_CCID source_14
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.AID_INVOICE_DIST_ID source_30
, l1.AI_INVOICE_CURRENCY_CODE source_33
, l1.INV_EXCHANGE_DATE source_39
, l1.INV_EXCHANGE_RATE source_40
, l1.INV_EXCHANGE_RATE_TYPE source_41
, l1.AID_AMOUNT source_57
, l1.DOCUMENT_TYPE source_83
, l3.PROJ_BURDEN_DISPLAY_METHOD source_84
, l1.ACCT_REVERSAL_INDICATOR source_85
, l1.ALLOC_TO_APPLN_ID source_86
, l1.ALLOC_TO_DIST_TYPE source_87
, l1.ALLOC_TO_ENTITY_CODE source_88
, l1.ALLOC_TO_FIRST_DIST_ID source_89
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_90
, l1.AP_APPLICATION_ID source_91
, l1.AP_DISTRIBUTION_TYPE source_92
, l1.AP_ENTITY_CODE source_93
, l1.AP_FIRST_DIST_ID source_94
, l1.AP_FIRST_SYS_TRANS_ID source_95
, l1.AID_EXPENDITURE_TYPE source_96
, l1.ENC_UPG_CR_ACCT_CLASS source_97
, l1.ENC_UPG_CR_ACCOUNT source_98
, l1.AID_BASE_AMT_NO_ROUND source_99
, l1.ENC_UPG_DR_ACCT_CLASS source_100
, l1.ENC_UPG_DR_ACCOUNT source_101
, l1.USE_ENC_UPG_ATTRIB_FLAG source_102
, l1.ACCT_REVERSAL_FIRST_DIST_ID source_103
, l1.AP_SECOND_DIST_ID source_104
, l1.ACCT_REV_DISTRIBUTION_TYPE source_105
, l1.ENC_UPG_CR_ENC_TYPE_ID source_106
, l1.ENC_UPG_DR_ENC_TYPE_ID source_107
, l1.BURDEN_COST_FLAG source_108
, fvl108.meaning source_108_meaning
, l1.PA_APPLICATION_ID source_109
, l1.PA_DISTRIBUTION_TYPE source_110
, l1.PA_ENTITY_CODE source_111
, l1.PA_FIRST_DIST_ID source_112
, l1.PA_FIRST_SYS_TRANS_ID source_113
, l1.PA_SECOND_DIST_ID source_114
, l1.PO_RELEASE_ID source_115
, l1.PO_APPLICATION_ID source_116
, l1.PO_DISTRIBUTION_TYPE source_117
, l1.PO_ENTITY_CODE source_118
, l1.PO_FIRST_DIST_ID source_119
, l1.PO_FIRST_SYS_TRANS_ID source_120
, l1.PO_SECOND_DIST_ID source_121
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
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.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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_107(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'PREPAYMENT APPLICATIONS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_107';
(p_msg => 'BEGIN of insert_sources_107'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 3 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 4 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 5 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_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 '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'FSP_PURCH_ENCUMBRANCE_FLAG'
WHEN 2 THEN 'AI_INVOICE_ID'
WHEN 3 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 4 THEN 'THIRD_PARTY_TYPE'
WHEN 5 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 6 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
WHEN 7 THEN 'INV_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.FSP_PURCH_ENCUMBRANCE_FLAG)
WHEN 2 THEN TO_CHAR(h1.AI_INVOICE_ID)
WHEN 3 THEN TO_CHAR(h1.AI_INVOICE_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.THIRD_PARTY_TYPE)
WHEN 5 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_CATEGORY)
WHEN 6 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_IDENTIFIER)
WHEN 7 THEN TO_CHAR(h1.INV_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, CASE r
WHEN 1 THEN fvl17.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h1
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl17
,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h3.asp_org_id = h1.ai_org_id AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.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
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 2 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 3 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 4 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 5 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 6 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 7 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 8 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 9 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 10 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 11 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 12 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 13 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 14 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 15 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 16 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 17 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 18 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 19 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 20 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 21 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 22 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 23 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 24 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 25 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 26 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 27 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 28 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 29 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 30 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 31 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 32 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 33 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 34 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
WHEN 35 THEN 'AP_PREPAYAPP_EXTRACT_DTLS_BC_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 2 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 3 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 4 THEN 'UPG_ENC_CR_CCID'
WHEN 5 THEN 'UPG_ENC_CR_AMT'
WHEN 6 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 7 THEN 'UPG_ENC_DR_CCID'
WHEN 8 THEN 'UPG_ENC_DR_AMT'
WHEN 9 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 10 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 11 THEN 'DEFERRED_END_DATE'
WHEN 12 THEN 'DEFERRED_OPTION'
WHEN 13 THEN 'DEFERRED_START_DATE'
WHEN 14 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 15 THEN 'TAX_LINE_ID'
WHEN 16 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 17 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 18 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 19 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 20 THEN 'PO_DISTRIBUTION_ID'
WHEN 21 THEN 'BUS_FLOW_PO_APP_ID'
WHEN 22 THEN 'BUS_FLOW_PO_DIST_TYPE'
WHEN 23 THEN 'BUS_FLOW_PO_ENTITY_CODE'
WHEN 24 THEN 'BUS_FLOW_PO_DOC_ID'
WHEN 25 THEN 'APAD_DIST_LOOKUP_CODE'
WHEN 26 THEN 'APAD_DISTRIBUTION_IDENTIFIER'
WHEN 27 THEN 'BF_ACCRUAL_PREPAY_DIST_TYPE'
WHEN 28 THEN 'BF_ACCRUAL_PREPAY_ENTITY_CODE'
WHEN 29 THEN 'BF_ACCRUAL_PP_DIST_ID'
WHEN 30 THEN 'BF_ACCRUAL_PP_INV'
WHEN 31 THEN 'UPG_ENC_CR_ACCT_CLASS'
WHEN 32 THEN 'UPG_ENC_DR_ACCT_CLASS'
WHEN 33 THEN 'APAD_AMOUNT'
WHEN 34 THEN 'APAD_BASE_AMOUNT'
WHEN 35 THEN 'REVERSED_PREPAY_APP_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 2 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
WHEN 3 THEN TO_CHAR(l2.BUS_FLOW_AP_APP_ID)
WHEN 4 THEN TO_CHAR(l2.UPG_ENC_CR_CCID)
WHEN 5 THEN TO_CHAR(l2.UPG_ENC_CR_AMT)
WHEN 6 THEN TO_CHAR(l2.UPG_ENC_CR_BASE_AMT)
WHEN 7 THEN TO_CHAR(l2.UPG_ENC_DR_CCID)
WHEN 8 THEN TO_CHAR(l2.UPG_ENC_DR_AMT)
WHEN 9 THEN TO_CHAR(l2.UPG_ENC_DR_BASE_AMT)
WHEN 10 THEN TO_CHAR(l2.UPG_AP_ENCUM_OPTION)
WHEN 11 THEN TO_CHAR(l2.DEFERRED_END_DATE)
WHEN 12 THEN TO_CHAR(l2.DEFERRED_OPTION)
WHEN 13 THEN TO_CHAR(l2.DEFERRED_START_DATE)
WHEN 14 THEN TO_CHAR(l2.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 15 THEN TO_CHAR(l4.TAX_LINE_ID)
WHEN 16 THEN TO_CHAR(l5.REC_NREC_TAX_DIST_ID)
WHEN 17 THEN TO_CHAR(l2.SUMMARY_TAX_LINE_ID)
WHEN 18 THEN TO_CHAR(l2.UPG_CR_ENC_TYPE_ID)
WHEN 19 THEN TO_CHAR(l2.UPG_DR_ENC_TYPE_ID)
WHEN 20 THEN TO_CHAR(l2.PO_DISTRIBUTION_ID)
WHEN 21 THEN TO_CHAR(l2.BUS_FLOW_PO_APP_ID)
WHEN 22 THEN TO_CHAR(l2.BUS_FLOW_PO_DIST_TYPE)
WHEN 23 THEN TO_CHAR(l2.BUS_FLOW_PO_ENTITY_CODE)
WHEN 24 THEN TO_CHAR(l2.BUS_FLOW_PO_DOC_ID)
WHEN 25 THEN TO_CHAR(l2.APAD_DIST_LOOKUP_CODE)
WHEN 26 THEN TO_CHAR(l2.APAD_DISTRIBUTION_IDENTIFIER)
WHEN 27 THEN TO_CHAR(l2.BF_ACCRUAL_PREPAY_DIST_TYPE)
WHEN 28 THEN TO_CHAR(l2.BF_ACCRUAL_PREPAY_ENTITY_CODE)
WHEN 29 THEN TO_CHAR(l2.BF_ACCRUAL_PP_DIST_ID)
WHEN 30 THEN TO_CHAR(l2.BF_ACCRUAL_PP_INV)
WHEN 31 THEN TO_CHAR(l2.UPG_ENC_CR_ACCT_CLASS)
WHEN 32 THEN TO_CHAR(l2.UPG_ENC_DR_ACCT_CLASS)
WHEN 33 THEN TO_CHAR(l2.APAD_AMOUNT)
WHEN 34 THEN TO_CHAR(l2.APAD_BASE_AMOUNT)
WHEN 35 THEN TO_CHAR(l2.REVERSED_PREPAY_APP_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 14 THEN fvl46.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl46
, (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l2.event_id = xet.event_id
AND l2.recp_detail_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l2.recp_detail_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l2.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.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_107'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_107');
END insert_sources_107;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT APPLICATIONS
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
, h3.FSP_PURCH_ENCUMBRANCE_FLAG source_17
, fvl17.meaning source_17_meaning
, h1.AI_INVOICE_ID source_24
, h1.AI_INVOICE_CURRENCY_CODE source_33
, h1.THIRD_PARTY_TYPE source_49
, h1.INV_DOC_SEQUENCE_CATEGORY source_122
, h1.INV_DOC_SEQUENCE_IDENTIFIER source_123
, h1.INV_DOC_SEQUENCE_VALUE source_124
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h1
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl17
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 h3.asp_org_id = h1.ai_org_id AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT APPLICATIONS
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
, l2.DIST_ACCOUNT_REVERSAL_OPTION source_19
, l2.DISTRIBUTION_LINK_TYPE source_21
, l2.BUS_FLOW_AP_APP_ID source_25
, l2.UPG_ENC_CR_CCID source_31
, l2.UPG_ENC_CR_AMT source_32
, l2.UPG_ENC_CR_BASE_AMT source_34
, l2.UPG_ENC_DR_CCID source_35
, l2.UPG_ENC_DR_AMT source_36
, l2.UPG_ENC_DR_BASE_AMT source_37
, l2.UPG_AP_ENCUM_OPTION source_38
, l2.DEFERRED_END_DATE source_43
, l2.DEFERRED_OPTION source_44
, l2.DEFERRED_START_DATE source_45
, l2.OVERRIDE_ACCTD_AMT_FLAG source_46
, fvl46.meaning source_46_meaning
, l4.TAX_LINE_ID source_52
, l5.REC_NREC_TAX_DIST_ID source_53
, l2.SUMMARY_TAX_LINE_ID source_54
, l2.UPG_CR_ENC_TYPE_ID source_55
, l2.UPG_DR_ENC_TYPE_ID source_56
, l2.PO_DISTRIBUTION_ID source_58
, l2.BUS_FLOW_PO_APP_ID source_60
, l2.BUS_FLOW_PO_DIST_TYPE source_61
, l2.BUS_FLOW_PO_ENTITY_CODE source_62
, l2.BUS_FLOW_PO_DOC_ID source_64
, l2.APAD_DIST_LOOKUP_CODE source_69
, l2.APAD_DISTRIBUTION_IDENTIFIER source_71
, l2.BF_ACCRUAL_PREPAY_DIST_TYPE source_72
, l2.BF_ACCRUAL_PREPAY_ENTITY_CODE source_73
, l2.BF_ACCRUAL_PP_DIST_ID source_74
, l2.BF_ACCRUAL_PP_INV source_75
, l2.UPG_ENC_CR_ACCT_CLASS source_76
, l2.UPG_ENC_DR_ACCT_CLASS source_77
, l2.APAD_AMOUNT source_78
, l2.APAD_BASE_AMOUNT source_79
, l2.REVERSED_PREPAY_APP_DIST_ID source_80
FROM xla_events_gt xet
, AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl46
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 l2.RECP_DETAIL_TAX_DIST_ID = l4.REC_NREC_TAX_DIST_ID (+) AND l2.RECP_DETAIL_TAX_DIST_ID = l5.REC_NREC_TAX_DIST_ID (+) AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l2.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.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_108(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'PREPAYMENTS_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_108';
(p_msg => 'BEGIN of insert_sources_108'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 6 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 7 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 8 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 9 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 10 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 11 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 12 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 13 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 14 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 15 THEN 'AP_INVOICE_EXTRACT_HEADER_V'
WHEN 16 THEN 'AP_INVOICE_EXTRACT_HEADER_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'ASP_RATE_VAR_GAIN_CCID'
WHEN 2 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 3 THEN 'ASP_RATE_VAR_LOSS_CCID'
WHEN 4 THEN 'ASP_AUTO_OFFSET_FLAG'
WHEN 5 THEN 'FSP_PURCH_ENCUMBRANCE_FLAG'
WHEN 6 THEN 'AI_INVOICE_ID'
WHEN 7 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 8 THEN 'INV_EXCHANGE_DATE'
WHEN 9 THEN 'INV_EXCHANGE_RATE'
WHEN 10 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 11 THEN 'AI_VENDOR_ID'
WHEN 12 THEN 'AI_VENDOR_SITE_ID'
WHEN 13 THEN 'THIRD_PARTY_TYPE'
WHEN 14 THEN 'INV_DOC_SEQUENCE_CATEGORY'
WHEN 15 THEN 'INV_DOC_SEQUENCE_IDENTIFIER'
WHEN 16 THEN 'INV_DOC_SEQUENCE_VALUE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.ASP_RATE_VAR_GAIN_CCID)
WHEN 2 THEN TO_CHAR(h3.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 3 THEN TO_CHAR(h3.ASP_RATE_VAR_LOSS_CCID)
WHEN 4 THEN TO_CHAR(h3.ASP_AUTO_OFFSET_FLAG)
WHEN 5 THEN TO_CHAR(h3.FSP_PURCH_ENCUMBRANCE_FLAG)
WHEN 6 THEN TO_CHAR(h2.AI_INVOICE_ID)
WHEN 7 THEN TO_CHAR(h2.AI_INVOICE_CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(h2.INV_EXCHANGE_DATE)
WHEN 9 THEN TO_CHAR(h2.INV_EXCHANGE_RATE)
WHEN 10 THEN TO_CHAR(h2.INV_EXCHANGE_RATE_TYPE)
WHEN 11 THEN TO_CHAR(h2.AI_VENDOR_ID)
WHEN 12 THEN TO_CHAR(h2.AI_VENDOR_SITE_ID)
WHEN 13 THEN TO_CHAR(h2.THIRD_PARTY_TYPE)
WHEN 14 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_CATEGORY)
WHEN 15 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_IDENTIFIER)
WHEN 16 THEN TO_CHAR(h2.INV_DOC_SEQUENCE_VALUE)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl7.meaning
WHEN 4 THEN fvl12.meaning
WHEN 5 THEN fvl17.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 2 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 3 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 4 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 5 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 6 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 7 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 8 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 9 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 10 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 11 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 12 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 13 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 14 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 15 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 16 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 17 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 18 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 19 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 20 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 21 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 22 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 23 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 24 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 28 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 29 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 32 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
WHEN 33 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 36 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 42 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 43 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 44 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 45 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 46 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
WHEN 47 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
WHEN 46 THEN 'LINE'
WHEN 47 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '200'
WHEN 4 THEN '200'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
WHEN 46 THEN '200'
WHEN 47 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'AID_DESCRIPTION'
WHEN 2 THEN 'INV_DIST_BASE_AMOUNT'
WHEN 3 THEN 'RELATED_INV_DIST_DEST_TYPE'
WHEN 4 THEN 'AID_DIST_CCID'
WHEN 5 THEN 'SELF_ASSESSED_TAX_ACCOUNT'
WHEN 6 THEN 'AID_LINE_TYPE_LOOKUP_CODE'
WHEN 7 THEN 'AID_AMOUNT_VARIANCE'
WHEN 8 THEN 'POD_ACCRUE_ON_RECEIPT_FLAG'
WHEN 9 THEN 'DIST_ACCOUNT_REVERSAL_OPTION'
WHEN 10 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 11 THEN 'ALLOC_TO_MAIN_DIST_ID'
WHEN 12 THEN 'BUS_FLOW_AP_APP_ID'
WHEN 13 THEN 'BUS_FLOW_INV_DIST_TYPE'
WHEN 14 THEN 'BUS_FLOW_INV_ENTITY_CODE'
WHEN 15 THEN 'BUS_FLOW_INV_DIST_ID'
WHEN 16 THEN 'BUS_FLOW_INV_ID'
WHEN 17 THEN 'AID_INVOICE_DIST_ID'
WHEN 18 THEN 'UPG_ENC_CR_CCID'
WHEN 19 THEN 'UPG_ENC_CR_AMT'
WHEN 20 THEN 'UPG_ENC_CR_BASE_AMT'
WHEN 21 THEN 'UPG_ENC_DR_CCID'
WHEN 22 THEN 'UPG_ENC_DR_AMT'
WHEN 23 THEN 'UPG_ENC_DR_BASE_AMT'
WHEN 24 THEN 'UPG_AP_ENCUM_OPTION'
WHEN 25 THEN 'AID_BASE_AMOUNT_VARIANCE'
WHEN 26 THEN 'DEFERRED_END_DATE'
WHEN 27 THEN 'DEFERRED_OPTION'
WHEN 28 THEN 'DEFERRED_START_DATE'
WHEN 29 THEN 'OVERRIDE_ACCTD_AMT_FLAG'
WHEN 30 THEN 'AID_PARENT_REVERSAL_ID'
WHEN 31 THEN 'AID_STAT_AMOUNT'
WHEN 32 THEN 'TAX_LINE_ID'
WHEN 33 THEN 'REC_NREC_TAX_DIST_ID'
WHEN 34 THEN 'SUMMARY_TAX_LINE_ID'
WHEN 35 THEN 'UPG_CR_ENC_TYPE_ID'
WHEN 36 THEN 'UPG_DR_ENC_TYPE_ID'
WHEN 37 THEN 'PO_DISTRIBUTION_ID'
WHEN 38 THEN 'SELF_ASSESSED_TAX_FLAG'
WHEN 39 THEN 'BUS_FLOW_PO_APP_ID'
WHEN 40 THEN 'BUS_FLOW_PO_DIST_TYPE'
WHEN 41 THEN 'BUS_FLOW_PO_ENTITY_CODE'
WHEN 42 THEN 'BUS_FLOW_PO_DIST_ID'
WHEN 43 THEN 'BUS_FLOW_PO_DOC_ID'
WHEN 44 THEN 'ENCUMBRANCE_AMOUNT'
WHEN 45 THEN 'ENCUMBRANCE_BASE_AMOUNT'
WHEN 46 THEN 'AID_QUANTITY_VARIANCE'
WHEN 47 THEN 'AID_BASE_QUANTITY_VARIANCE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.AID_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.INV_DIST_BASE_AMOUNT)
WHEN 3 THEN TO_CHAR(l1.RELATED_INV_DIST_DEST_TYPE)
WHEN 4 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 5 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_ACCOUNT)
WHEN 6 THEN TO_CHAR(l1.AID_LINE_TYPE_LOOKUP_CODE)
WHEN 7 THEN TO_CHAR(l1.AID_AMOUNT_VARIANCE)
WHEN 8 THEN TO_CHAR(l1.POD_ACCRUE_ON_RECEIPT_FLAG)
WHEN 9 THEN TO_CHAR(l1.DIST_ACCOUNT_REVERSAL_OPTION)
WHEN 10 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_MAIN_DIST_ID)
WHEN 12 THEN TO_CHAR(l1.BUS_FLOW_AP_APP_ID)
WHEN 13 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_TYPE)
WHEN 14 THEN TO_CHAR(l1.BUS_FLOW_INV_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l1.BUS_FLOW_INV_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.BUS_FLOW_INV_ID)
WHEN 17 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 18 THEN TO_CHAR(l1.UPG_ENC_CR_CCID)
WHEN 19 THEN TO_CHAR(l1.UPG_ENC_CR_AMT)
WHEN 20 THEN TO_CHAR(l1.UPG_ENC_CR_BASE_AMT)
WHEN 21 THEN TO_CHAR(l1.UPG_ENC_DR_CCID)
WHEN 22 THEN TO_CHAR(l1.UPG_ENC_DR_AMT)
WHEN 23 THEN TO_CHAR(l1.UPG_ENC_DR_BASE_AMT)
WHEN 24 THEN TO_CHAR(l1.UPG_AP_ENCUM_OPTION)
WHEN 25 THEN TO_CHAR(l1.AID_BASE_AMOUNT_VARIANCE)
WHEN 26 THEN TO_CHAR(l1.DEFERRED_END_DATE)
WHEN 27 THEN TO_CHAR(l1.DEFERRED_OPTION)
WHEN 28 THEN TO_CHAR(l1.DEFERRED_START_DATE)
WHEN 29 THEN TO_CHAR(l1.OVERRIDE_ACCTD_AMT_FLAG)
WHEN 30 THEN TO_CHAR(l1.AID_PARENT_REVERSAL_ID)
WHEN 31 THEN TO_CHAR(l1.AID_STAT_AMOUNT)
WHEN 32 THEN TO_CHAR(l4.TAX_LINE_ID)
WHEN 33 THEN TO_CHAR(l5.REC_NREC_TAX_DIST_ID)
WHEN 34 THEN TO_CHAR(l1.SUMMARY_TAX_LINE_ID)
WHEN 35 THEN TO_CHAR(l1.UPG_CR_ENC_TYPE_ID)
WHEN 36 THEN TO_CHAR(l1.UPG_DR_ENC_TYPE_ID)
WHEN 37 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 38 THEN TO_CHAR(l1.SELF_ASSESSED_TAX_FLAG)
WHEN 39 THEN TO_CHAR(l1.BUS_FLOW_PO_APP_ID)
WHEN 40 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_TYPE)
WHEN 41 THEN TO_CHAR(l1.BUS_FLOW_PO_ENTITY_CODE)
WHEN 42 THEN TO_CHAR(l1.BUS_FLOW_PO_DIST_ID)
WHEN 43 THEN TO_CHAR(l1.BUS_FLOW_PO_DOC_ID)
WHEN 44 THEN TO_CHAR(l1.ENCUMBRANCE_AMOUNT)
WHEN 45 THEN TO_CHAR(l1.ENCUMBRANCE_BASE_AMOUNT)
WHEN 46 THEN TO_CHAR(l1.AID_QUANTITY_VARIANCE)
WHEN 47 THEN TO_CHAR(l1.AID_BASE_QUANTITY_VARIANCE)
ELSE null
END source_value
, CASE r
WHEN 3 THEN fvl9.meaning
WHEN 6 THEN fvl15.meaning
WHEN 8 THEN fvl18.meaning
WHEN 29 THEN fvl46.meaning
WHEN 38 THEN fvl59.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
, (select rownum r from all_objects where rownum <= 47 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 l1.zrnd_tax_dist_id = l4.rec_nrec_tax_dist_id (+) AND l1.zrnd_tax_dist_id = l5.rec_nrec_tax_dist_id (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_108'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_108');
END insert_sources_108;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENTS
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
, h3.ASP_RATE_VAR_GAIN_CCID source_6
, h3.ASP_AUTOMATIC_OFFSETS_VALUE source_7
, fvl7.meaning source_7_meaning
, h3.ASP_RATE_VAR_LOSS_CCID source_10
, h3.ASP_AUTO_OFFSET_FLAG source_12
, fvl12.meaning source_12_meaning
, h3.FSP_PURCH_ENCUMBRANCE_FLAG source_17
, fvl17.meaning source_17_meaning
, h2.AI_INVOICE_ID source_24
, h2.AI_INVOICE_CURRENCY_CODE source_33
, h2.INV_EXCHANGE_DATE source_39
, h2.INV_EXCHANGE_RATE source_40
, h2.INV_EXCHANGE_RATE_TYPE source_41
, h2.AI_VENDOR_ID source_47
, h2.AI_VENDOR_SITE_ID source_48
, h2.THIRD_PARTY_TYPE source_49
, h2.INV_DOC_SEQUENCE_CATEGORY source_122
, h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
, h2.INV_DOC_SEQUENCE_VALUE source_124
FROM xla_events_gt xet
, AP_INVOICE_EXTRACT_HEADER_V h2
, AP_SYSTEM_PARAMETERS_EXTRACT_V h3
, fnd_lookup_values fvl7
, fnd_lookup_values fvl12
, fnd_lookup_values fvl17
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
AND h3.asp_org_id = h2.ai_org_id AND fvl7.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl7.lookup_code(+) = h3.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl7.view_application_id(+) = 200
AND fvl7.language(+) = USERENV('LANG')
AND fvl12.lookup_type(+) = 'YES_NO'
AND fvl12.lookup_code(+) = h3.ASP_AUTO_OFFSET_FLAG
AND fvl12.view_application_id(+) = 0
AND fvl12.language(+) = USERENV('LANG')
AND fvl17.lookup_type(+) = 'YES_NO'
AND fvl17.lookup_code(+) = h3.FSP_PURCH_ENCUMBRANCE_FLAG
AND fvl17.view_application_id(+) = 0
AND fvl17.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENTS
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
, l1.AID_DESCRIPTION source_1
, l1.INV_DIST_BASE_AMOUNT source_8
, l1.RELATED_INV_DIST_DEST_TYPE source_9
, fvl9.meaning source_9_meaning
, l1.AID_DIST_CCID source_11
, l1.SELF_ASSESSED_TAX_ACCOUNT source_13
, l1.AID_LINE_TYPE_LOOKUP_CODE source_15
, fvl15.meaning source_15_meaning
, l1.AID_AMOUNT_VARIANCE source_16
, l1.POD_ACCRUE_ON_RECEIPT_FLAG source_18
, fvl18.meaning source_18_meaning
, l1.DIST_ACCOUNT_REVERSAL_OPTION source_19
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.ALLOC_TO_MAIN_DIST_ID source_23
, l1.BUS_FLOW_AP_APP_ID source_25
, l1.BUS_FLOW_INV_DIST_TYPE source_26
, l1.BUS_FLOW_INV_ENTITY_CODE source_27
, l1.BUS_FLOW_INV_DIST_ID source_28
, l1.BUS_FLOW_INV_ID source_29
, l1.AID_INVOICE_DIST_ID source_30
, l1.UPG_ENC_CR_CCID source_31
, l1.UPG_ENC_CR_AMT source_32
, l1.UPG_ENC_CR_BASE_AMT source_34
, l1.UPG_ENC_DR_CCID source_35
, l1.UPG_ENC_DR_AMT source_36
, l1.UPG_ENC_DR_BASE_AMT source_37
, l1.UPG_AP_ENCUM_OPTION source_38
, l1.AID_BASE_AMOUNT_VARIANCE source_42
, l1.DEFERRED_END_DATE source_43
, l1.DEFERRED_OPTION source_44
, l1.DEFERRED_START_DATE source_45
, l1.OVERRIDE_ACCTD_AMT_FLAG source_46
, fvl46.meaning source_46_meaning
, l1.AID_PARENT_REVERSAL_ID source_50
, l1.AID_STAT_AMOUNT source_51
, l4.TAX_LINE_ID source_52
, l5.REC_NREC_TAX_DIST_ID source_53
, l1.SUMMARY_TAX_LINE_ID source_54
, l1.UPG_CR_ENC_TYPE_ID source_55
, l1.UPG_DR_ENC_TYPE_ID source_56
, l1.PO_DISTRIBUTION_ID source_58
, l1.SELF_ASSESSED_TAX_FLAG source_59
, fvl59.meaning source_59_meaning
, l1.BUS_FLOW_PO_APP_ID source_60
, l1.BUS_FLOW_PO_DIST_TYPE source_61
, l1.BUS_FLOW_PO_ENTITY_CODE source_62
, l1.BUS_FLOW_PO_DIST_ID source_63
, l1.BUS_FLOW_PO_DOC_ID source_64
, l1.ENCUMBRANCE_AMOUNT source_65
, l1.ENCUMBRANCE_BASE_AMOUNT source_66
, l1.AID_QUANTITY_VARIANCE source_81
, l1.AID_BASE_QUANTITY_VARIANCE source_82
FROM xla_events_gt xet
, AP_EXTRACT_INVOICE_DTLS_BC_V l1
, ZX_AP_DEF_TAX_EXTRACT_V l4
, ZX_AP_TAX_JRNL_LINE_DESC_V l5
, fnd_lookup_values fvl9
, fnd_lookup_values fvl15
, fnd_lookup_values fvl18
, fnd_lookup_values fvl46
, fnd_lookup_values fvl59
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 l1.ZRND_tax_dist_id = l4.REC_NREC_TAX_DIST_ID (+) AND l1.ZRND_tax_dist_id = l5.REC_NREC_TAX_DIST_ID (+) AND fvl9.lookup_type(+) = 'DESTINATION TYPE'
AND fvl9.lookup_code(+) = l1.RELATED_INV_DIST_DEST_TYPE
AND fvl9.view_application_id(+) = 201
AND fvl9.language(+) = USERENV('LANG')
AND fvl15.lookup_type(+) = 'INVOICE DISTRIBUTION TYPE'
AND fvl15.lookup_code(+) = l1.AID_LINE_TYPE_LOOKUP_CODE
AND fvl15.view_application_id(+) = 200
AND fvl15.language(+) = USERENV('LANG')
AND fvl18.lookup_type(+) = 'YES_NO'
AND fvl18.lookup_code(+) = l1.POD_ACCRUE_ON_RECEIPT_FLAG
AND fvl18.view_application_id(+) = 0
AND fvl18.language(+) = USERENV('LANG')
AND fvl46.lookup_type(+) = 'YES_NO'
AND fvl46.lookup_code(+) = l1.OVERRIDE_ACCTD_AMT_FLAG
AND fvl46.view_application_id(+) = 0
AND fvl46.language(+) = USERENV('LANG')
AND fvl59.lookup_type(+) = 'YES_NO'
AND fvl59.lookup_code(+) = l1.SELF_ASSESSED_TAX_FLAG
AND fvl59.view_application_id(+) = 0
AND fvl59.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_109(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'PREPAYMENT_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_109';
(p_msg => 'BEGIN of insert_sources_109'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 3 THEN 'PA_XLA_TASK_REF_V'
WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 15 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 41 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 42 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 43 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 44 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 45 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
WHEN 43 THEN 'LINE'
WHEN 44 THEN 'LINE'
WHEN 45 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '275'
WHEN 3 THEN '275'
WHEN 4 THEN '275'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '200'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '275'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
WHEN 43 THEN '200'
WHEN 44 THEN '200'
WHEN 45 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOCUMENT_DISTRIBUTION_TYPE'
WHEN 2 THEN 'PROJECT_NAME'
WHEN 3 THEN 'TASK_NUMBER'
WHEN 4 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 5 THEN 'AID_DIST_CCID'
WHEN 6 THEN 'BUDGET_CCID'
WHEN 7 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 8 THEN 'AID_INVOICE_DIST_ID'
WHEN 9 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 10 THEN 'INV_EXCHANGE_DATE'
WHEN 11 THEN 'INV_EXCHANGE_RATE'
WHEN 12 THEN 'INV_EXCHANGE_RATE_TYPE'
WHEN 13 THEN 'AID_AMOUNT'
WHEN 14 THEN 'DOCUMENT_TYPE'
WHEN 15 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 16 THEN 'ACCT_REVERSAL_INDICATOR'
WHEN 17 THEN 'ALLOC_TO_APPLN_ID'
WHEN 18 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 19 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 20 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 21 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 22 THEN 'AP_APPLICATION_ID'
WHEN 23 THEN 'AP_DISTRIBUTION_TYPE'
WHEN 24 THEN 'AP_ENTITY_CODE'
WHEN 25 THEN 'AP_FIRST_DIST_ID'
WHEN 26 THEN 'AP_FIRST_SYS_TRANS_ID'
WHEN 27 THEN 'AID_EXPENDITURE_TYPE'
WHEN 28 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 29 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 30 THEN 'AID_BASE_AMT_NO_ROUND'
WHEN 31 THEN 'ENC_UPG_DR_ACCT_CLASS'
WHEN 32 THEN 'ENC_UPG_DR_ACCOUNT'
WHEN 33 THEN 'USE_ENC_UPG_ATTRIB_FLAG'
WHEN 34 THEN 'ACCT_REVERSAL_FIRST_DIST_ID'
WHEN 35 THEN 'AP_SECOND_DIST_ID'
WHEN 36 THEN 'ACCT_REV_DISTRIBUTION_TYPE'
WHEN 37 THEN 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 38 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 39 THEN 'BURDEN_COST_FLAG'
WHEN 40 THEN 'PA_APPLICATION_ID'
WHEN 41 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 42 THEN 'PA_ENTITY_CODE'
WHEN 43 THEN 'PA_FIRST_DIST_ID'
WHEN 44 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 45 THEN 'PA_SECOND_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.DOCUMENT_DISTRIBUTION_TYPE)
WHEN 2 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 3 THEN TO_CHAR(l4.TASK_NUMBER)
WHEN 4 THEN TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
WHEN 5 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 6 THEN TO_CHAR(l1.BUDGET_CCID)
WHEN 7 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 8 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 9 THEN TO_CHAR(l1.AI_INVOICE_CURRENCY_CODE)
WHEN 10 THEN TO_CHAR(l1.INV_EXCHANGE_DATE)
WHEN 11 THEN TO_CHAR(l1.INV_EXCHANGE_RATE)
WHEN 12 THEN TO_CHAR(l1.INV_EXCHANGE_RATE_TYPE)
WHEN 13 THEN TO_CHAR(l1.AID_AMOUNT)
WHEN 14 THEN TO_CHAR(l1.DOCUMENT_TYPE)
WHEN 15 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 16 THEN TO_CHAR(l1.ACCT_REVERSAL_INDICATOR)
WHEN 17 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 18 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 19 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 20 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 21 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 22 THEN TO_CHAR(l1.AP_APPLICATION_ID)
WHEN 23 THEN TO_CHAR(l1.AP_DISTRIBUTION_TYPE)
WHEN 24 THEN TO_CHAR(l1.AP_ENTITY_CODE)
WHEN 25 THEN TO_CHAR(l1.AP_FIRST_DIST_ID)
WHEN 26 THEN TO_CHAR(l1.AP_FIRST_SYS_TRANS_ID)
WHEN 27 THEN TO_CHAR(l1.AID_EXPENDITURE_TYPE)
WHEN 28 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
WHEN 29 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
WHEN 30 THEN TO_CHAR(l1.AID_BASE_AMT_NO_ROUND)
WHEN 31 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
WHEN 32 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
WHEN 33 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
WHEN 34 THEN TO_CHAR(l1.ACCT_REVERSAL_FIRST_DIST_ID)
WHEN 35 THEN TO_CHAR(l1.AP_SECOND_DIST_ID)
WHEN 36 THEN TO_CHAR(l1.ACCT_REV_DISTRIBUTION_TYPE)
WHEN 37 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 38 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 39 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 40 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 41 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 42 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 43 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 44 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 45 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 4 THEN XLA_00200_AAD_S_000006_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,275)
WHEN 39 THEN fvl108.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
, (select rownum r from all_objects where rownum <= 45 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.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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_109'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_109');
END insert_sources_109;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT_BURDEN
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
FROM xla_events_gt xet
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'
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAYMENT_BURDEN
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
, l1.DOCUMENT_DISTRIBUTION_TYPE source_2
, l3.PROJECT_NAME source_3
, l4.TASK_NUMBER source_4
, l2.EXPENDITURE_ORGANIZATION_ID source_5
, l1.AID_DIST_CCID source_11
, l1.BUDGET_CCID source_14
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.AID_INVOICE_DIST_ID source_30
, l1.AI_INVOICE_CURRENCY_CODE source_33
, l1.INV_EXCHANGE_DATE source_39
, l1.INV_EXCHANGE_RATE source_40
, l1.INV_EXCHANGE_RATE_TYPE source_41
, l1.AID_AMOUNT source_57
, l1.DOCUMENT_TYPE source_83
, l3.PROJ_BURDEN_DISPLAY_METHOD source_84
, l1.ACCT_REVERSAL_INDICATOR source_85
, l1.ALLOC_TO_APPLN_ID source_86
, l1.ALLOC_TO_DIST_TYPE source_87
, l1.ALLOC_TO_ENTITY_CODE source_88
, l1.ALLOC_TO_FIRST_DIST_ID source_89
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_90
, l1.AP_APPLICATION_ID source_91
, l1.AP_DISTRIBUTION_TYPE source_92
, l1.AP_ENTITY_CODE source_93
, l1.AP_FIRST_DIST_ID source_94
, l1.AP_FIRST_SYS_TRANS_ID source_95
, l1.AID_EXPENDITURE_TYPE source_96
, l1.ENC_UPG_CR_ACCT_CLASS source_97
, l1.ENC_UPG_CR_ACCOUNT source_98
, l1.AID_BASE_AMT_NO_ROUND source_99
, l1.ENC_UPG_DR_ACCT_CLASS source_100
, l1.ENC_UPG_DR_ACCOUNT source_101
, l1.USE_ENC_UPG_ATTRIB_FLAG source_102
, l1.ACCT_REVERSAL_FIRST_DIST_ID source_103
, l1.AP_SECOND_DIST_ID source_104
, l1.ACCT_REV_DISTRIBUTION_TYPE source_105
, l1.ENC_UPG_CR_ENC_TYPE_ID source_106
, l1.ENC_UPG_DR_ENC_TYPE_ID source_107
, l1.BURDEN_COST_FLAG source_108
, fvl108.meaning source_108_meaning
, l1.PA_APPLICATION_ID source_109
, l1.PA_DISTRIBUTION_TYPE source_110
, l1.PA_ENTITY_CODE source_111
, l1.PA_FIRST_DIST_ID source_112
, l1.PA_FIRST_SYS_TRANS_ID source_113
, l1.PA_SECOND_DIST_ID source_114
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
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.EXPENDITURE_ORGANIZATION_ID=l1.AID_EXPENDITURE_ORG_ID AND l3.PROJECT_ID=l1.AID_PROJECT_ID AND l4.TASK_ID=l1.AID_TASK_ID AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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_110(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'PREPAY_APPLICATION_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_110';
(p_msg => 'BEGIN of insert_sources_110'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --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
, l1.line_number line_number
, CASE r
WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 3 THEN 'PA_XLA_TASK_REF_V'
WHEN 4 THEN 'PA_XLA_EXP_ORG_REF_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 12 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 41 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
WHEN 42 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
WHEN 21 THEN 'LINE'
WHEN 22 THEN 'LINE'
WHEN 23 THEN 'LINE'
WHEN 24 THEN 'LINE'
WHEN 25 THEN 'LINE'
WHEN 26 THEN 'LINE'
WHEN 27 THEN 'LINE'
WHEN 28 THEN 'LINE'
WHEN 29 THEN 'LINE'
WHEN 30 THEN 'LINE'
WHEN 31 THEN 'LINE'
WHEN 32 THEN 'LINE'
WHEN 33 THEN 'LINE'
WHEN 34 THEN 'LINE'
WHEN 35 THEN 'LINE'
WHEN 36 THEN 'LINE'
WHEN 37 THEN 'LINE'
WHEN 38 THEN 'LINE'
WHEN 39 THEN 'LINE'
WHEN 40 THEN 'LINE'
WHEN 41 THEN 'LINE'
WHEN 42 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '275'
WHEN 3 THEN '275'
WHEN 4 THEN '275'
WHEN 5 THEN '200'
WHEN 6 THEN '200'
WHEN 7 THEN '200'
WHEN 8 THEN '200'
WHEN 9 THEN '200'
WHEN 10 THEN '200'
WHEN 11 THEN '200'
WHEN 12 THEN '275'
WHEN 13 THEN '200'
WHEN 14 THEN '200'
WHEN 15 THEN '200'
WHEN 16 THEN '200'
WHEN 17 THEN '200'
WHEN 18 THEN '200'
WHEN 19 THEN '200'
WHEN 20 THEN '200'
WHEN 21 THEN '200'
WHEN 22 THEN '200'
WHEN 23 THEN '200'
WHEN 24 THEN '200'
WHEN 25 THEN '200'
WHEN 26 THEN '200'
WHEN 27 THEN '200'
WHEN 28 THEN '200'
WHEN 29 THEN '200'
WHEN 30 THEN '200'
WHEN 31 THEN '200'
WHEN 32 THEN '200'
WHEN 33 THEN '200'
WHEN 34 THEN '200'
WHEN 35 THEN '200'
WHEN 36 THEN '200'
WHEN 37 THEN '200'
WHEN 38 THEN '200'
WHEN 39 THEN '200'
WHEN 40 THEN '200'
WHEN 41 THEN '200'
WHEN 42 THEN '200'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOCUMENT_DISTRIBUTION_TYPE'
WHEN 2 THEN 'PROJECT_NAME'
WHEN 3 THEN 'TASK_NUMBER'
WHEN 4 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 5 THEN 'AID_DIST_CCID'
WHEN 6 THEN 'BUDGET_CCID'
WHEN 7 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 8 THEN 'AID_INVOICE_DIST_ID'
WHEN 9 THEN 'AI_INVOICE_CURRENCY_CODE'
WHEN 10 THEN 'AID_AMOUNT'
WHEN 11 THEN 'DOCUMENT_TYPE'
WHEN 12 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 13 THEN 'ACCT_REVERSAL_INDICATOR'
WHEN 14 THEN 'ALLOC_TO_APPLN_ID'
WHEN 15 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 16 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 17 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 18 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 19 THEN 'AP_APPLICATION_ID'
WHEN 20 THEN 'AP_DISTRIBUTION_TYPE'
WHEN 21 THEN 'AP_ENTITY_CODE'
WHEN 22 THEN 'AP_FIRST_DIST_ID'
WHEN 23 THEN 'AP_FIRST_SYS_TRANS_ID'
WHEN 24 THEN 'AID_EXPENDITURE_TYPE'
WHEN 25 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 26 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 27 THEN 'AID_BASE_AMT_NO_ROUND'
WHEN 28 THEN 'ENC_UPG_DR_ACCT_CLASS'
WHEN 29 THEN 'ENC_UPG_DR_ACCOUNT'
WHEN 30 THEN 'USE_ENC_UPG_ATTRIB_FLAG'
WHEN 31 THEN 'ACCT_REVERSAL_FIRST_DIST_ID'
WHEN 32 THEN 'AP_SECOND_DIST_ID'
WHEN 33 THEN 'ACCT_REV_DISTRIBUTION_TYPE'
WHEN 34 THEN 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 35 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 36 THEN 'BURDEN_COST_FLAG'
WHEN 37 THEN 'PA_APPLICATION_ID'
WHEN 38 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 39 THEN 'PA_ENTITY_CODE'
WHEN 40 THEN 'PA_FIRST_DIST_ID'
WHEN 41 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 42 THEN 'PA_SECOND_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.DOCUMENT_DISTRIBUTION_TYPE)
WHEN 2 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 3 THEN TO_CHAR(l4.TASK_NUMBER)
WHEN 4 THEN TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
WHEN 5 THEN TO_CHAR(l1.AID_DIST_CCID)
WHEN 6 THEN TO_CHAR(l1.BUDGET_CCID)
WHEN 7 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 8 THEN TO_CHAR(l1.AID_INVOICE_DIST_ID)
WHEN 9 THEN TO_CHAR(l1.AI_INVOICE_CURRENCY_CODE)
WHEN 10 THEN TO_CHAR(l1.AID_AMOUNT)
WHEN 11 THEN TO_CHAR(l1.DOCUMENT_TYPE)
WHEN 12 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 13 THEN TO_CHAR(l1.ACCT_REVERSAL_INDICATOR)
WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 16 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 17 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 18 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 19 THEN TO_CHAR(l1.AP_APPLICATION_ID)
WHEN 20 THEN TO_CHAR(l1.AP_DISTRIBUTION_TYPE)
WHEN 21 THEN TO_CHAR(l1.AP_ENTITY_CODE)
WHEN 22 THEN TO_CHAR(l1.AP_FIRST_DIST_ID)
WHEN 23 THEN TO_CHAR(l1.AP_FIRST_SYS_TRANS_ID)
WHEN 24 THEN TO_CHAR(l1.AID_EXPENDITURE_TYPE)
WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
WHEN 26 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
WHEN 27 THEN TO_CHAR(l1.AID_BASE_AMT_NO_ROUND)
WHEN 28 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
WHEN 29 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
WHEN 30 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
WHEN 31 THEN TO_CHAR(l1.ACCT_REVERSAL_FIRST_DIST_ID)
WHEN 32 THEN TO_CHAR(l1.AP_SECOND_DIST_ID)
WHEN 33 THEN TO_CHAR(l1.ACCT_REV_DISTRIBUTION_TYPE)
WHEN 34 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 35 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 36 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 37 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 38 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 39 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 40 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 41 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 42 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 4 THEN XLA_00200_AAD_S_000006_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l2.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,275)
WHEN 36 THEN fvl108.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
, (select rownum r from all_objects where rownum <= 42 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.expenditure_organization_id=l1.aid_expenditure_org_id AND l3.project_id=l1.aid_project_id AND l4.task_id=l1.aid_task_id AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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_110'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00200_AAD_S_000006_BC_PKG.insert_sources_110');
END insert_sources_110;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAY_APPLICATION_BURDEN
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
FROM xla_events_gt xet
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'
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PREPAY_APPLICATION_BURDEN
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
, l1.DOCUMENT_DISTRIBUTION_TYPE source_2
, l3.PROJECT_NAME source_3
, l4.TASK_NUMBER source_4
, l2.EXPENDITURE_ORGANIZATION_ID source_5
, l1.AID_DIST_CCID source_11
, l1.BUDGET_CCID source_14
, l1.DISTRIBUTION_LINK_TYPE source_21
, l1.AID_INVOICE_DIST_ID source_30
, l1.AI_INVOICE_CURRENCY_CODE source_33
, l1.AID_AMOUNT source_57
, l1.DOCUMENT_TYPE source_83
, l3.PROJ_BURDEN_DISPLAY_METHOD source_84
, l1.ACCT_REVERSAL_INDICATOR source_85
, l1.ALLOC_TO_APPLN_ID source_86
, l1.ALLOC_TO_DIST_TYPE source_87
, l1.ALLOC_TO_ENTITY_CODE source_88
, l1.ALLOC_TO_FIRST_DIST_ID source_89
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_90
, l1.AP_APPLICATION_ID source_91
, l1.AP_DISTRIBUTION_TYPE source_92
, l1.AP_ENTITY_CODE source_93
, l1.AP_FIRST_DIST_ID source_94
, l1.AP_FIRST_SYS_TRANS_ID source_95
, l1.AID_EXPENDITURE_TYPE source_96
, l1.ENC_UPG_CR_ACCT_CLASS source_97
, l1.ENC_UPG_CR_ACCOUNT source_98
, l1.AID_BASE_AMT_NO_ROUND source_99
, l1.ENC_UPG_DR_ACCT_CLASS source_100
, l1.ENC_UPG_DR_ACCOUNT source_101
, l1.USE_ENC_UPG_ATTRIB_FLAG source_102
, l1.ACCT_REVERSAL_FIRST_DIST_ID source_103
, l1.AP_SECOND_DIST_ID source_104
, l1.ACCT_REV_DISTRIBUTION_TYPE source_105
, l1.ENC_UPG_CR_ENC_TYPE_ID source_106
, l1.ENC_UPG_DR_ENC_TYPE_ID source_107
, l1.BURDEN_COST_FLAG source_108
, fvl108.meaning source_108_meaning
, l1.PA_APPLICATION_ID source_109
, l1.PA_DISTRIBUTION_TYPE source_110
, l1.PA_ENTITY_CODE source_111
, l1.PA_FIRST_DIST_ID source_112
, l1.PA_FIRST_SYS_TRANS_ID source_113
, l1.PA_SECOND_DIST_ID source_114
FROM xla_events_gt xet
, PA_XLA_BC_PKT_AP_DETAIL_V l1
, PA_XLA_EXP_ORG_REF_V l2
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl108
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.EXPENDITURE_ORGANIZATION_ID=l1.AID_EXPENDITURE_ORG_ID AND l3.PROJECT_ID=l1.AID_PROJECT_ID AND l4.TASK_ID=l1.AID_TASK_ID AND fvl108.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl108.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl108.view_application_id(+) = 275
AND fvl108.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 ;
insert_sources_103(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_104(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_105(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_106(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_107(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_108(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_109(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);
insert_sources_110(
p_target_ledger_id => p_target_ledger_id
, p_language => l_language
, p_sla_ledger_id => l_sla_ledger_id
, p_pad_start_date => p_pad_start_date
, p_pad_end_date => p_pad_end_date
);