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);
PROCEDURE insert_sources_85(
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) := 'PO_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_85';
(p_msg => 'BEGIN of insert_sources_85'
,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 'PA_XLA_BC_PKT_PO_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_HEADER_V h2
,(select rownum r from all_objects where rownum <= 1 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
)
;
(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 'PA_XLA_PROJECT_REF_V'
WHEN 2 THEN 'PA_XLA_TASK_REF_V'
WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 14 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 15 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 41 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 42 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 43 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 44 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 45 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 46 THEN 'PA_XLA_BC_PKT_PO_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '275'
WHEN 2 THEN '275'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '275'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
WHEN 26 THEN '201'
WHEN 27 THEN '201'
WHEN 28 THEN '201'
WHEN 29 THEN '201'
WHEN 30 THEN '201'
WHEN 31 THEN '201'
WHEN 32 THEN '201'
WHEN 33 THEN '201'
WHEN 34 THEN '201'
WHEN 35 THEN '201'
WHEN 36 THEN '201'
WHEN 37 THEN '201'
WHEN 38 THEN '201'
WHEN 39 THEN '201'
WHEN 40 THEN '201'
WHEN 41 THEN '201'
WHEN 42 THEN '201'
WHEN 43 THEN '201'
WHEN 44 THEN '201'
WHEN 45 THEN '201'
WHEN 46 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PROJECT_NAME'
WHEN 2 THEN 'TASK_NAME'
WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 4 THEN 'EXPENDITURE_TYPE'
WHEN 5 THEN 'DOCUMENT_TYPE'
WHEN 6 THEN 'BUDGET_ACCOUNT'
WHEN 7 THEN 'MAIN_OR_BACKING_CODE'
WHEN 8 THEN 'BURDEN_COST_FLAG'
WHEN 9 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 10 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 11 THEN 'ALLOC_TO_APPLN_ID'
WHEN 12 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 13 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 14 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 15 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 16 THEN 'PO_APPLICATION_ID'
WHEN 17 THEN 'PO_DISTRIBUTION_TYPE'
WHEN 18 THEN 'PO_ENTITY_CODE'
WHEN 19 THEN 'PO_FIRST_DIST_ID'
WHEN 20 THEN 'PO_FIRST_SYS_TRANS_ID'
WHEN 21 THEN 'PO_SECOND_DIST_ID'
WHEN 22 THEN 'PO_DISTRIBUTION_ID'
WHEN 23 THEN 'LINE_TYPE_NAME'
WHEN 24 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 25 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 26 THEN 'ENTERED_AMT'
WHEN 27 THEN 'CURRENCY_CODE'
WHEN 28 THEN 'ACCOUNTED_AMT'
WHEN 29 THEN 'ENC_UPG_DR_ACCT_CLASS'
WHEN 30 THEN 'ENC_UPG_DR_ACCOUNT'
WHEN 31 THEN 'USE_ENC_UPG_ATTRIB_FLAG'
WHEN 32 THEN 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 33 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 34 THEN 'REQ_APPLICATION_ID'
WHEN 35 THEN 'REQ_DISTRIBUTION_TYPE'
WHEN 36 THEN 'REQ_ENTITY_CODE'
WHEN 37 THEN 'REQ_FIRST_DIST_ID'
WHEN 38 THEN 'REQ_FIRST_SYS_TRANS_ID'
WHEN 39 THEN 'REQ_SECOND_DIST_ID'
WHEN 40 THEN 'BACKING_REQ_ENC_FLIPPED_FLAG'
WHEN 41 THEN 'PA_APPLICATION_ID'
WHEN 42 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 43 THEN 'PA_ENTITY_CODE'
WHEN 44 THEN 'PA_FIRST_DIST_ID'
WHEN 45 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 46 THEN 'PA_SECOND_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
WHEN 5 THEN TO_CHAR(l1.DOCUMENT_TYPE)
WHEN 6 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
WHEN 7 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
WHEN 8 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 9 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 10 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 16 THEN TO_CHAR(l1.PO_APPLICATION_ID)
WHEN 17 THEN TO_CHAR(l1.PO_DISTRIBUTION_TYPE)
WHEN 18 THEN TO_CHAR(l1.PO_ENTITY_CODE)
WHEN 19 THEN TO_CHAR(l1.PO_FIRST_DIST_ID)
WHEN 20 THEN TO_CHAR(l1.PO_FIRST_SYS_TRANS_ID)
WHEN 21 THEN TO_CHAR(l1.PO_SECOND_DIST_ID)
WHEN 22 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 23 THEN TO_CHAR(l1.LINE_TYPE_NAME)
WHEN 24 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
WHEN 26 THEN TO_CHAR(l1.ENTERED_AMT)
WHEN 27 THEN TO_CHAR(l1.CURRENCY_CODE)
WHEN 28 THEN TO_CHAR(l1.ACCOUNTED_AMT)
WHEN 29 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
WHEN 30 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
WHEN 31 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
WHEN 32 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 33 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 34 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
WHEN 35 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
WHEN 36 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
WHEN 37 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
WHEN 38 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
WHEN 39 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
WHEN 40 THEN TO_CHAR(l1.BACKING_REQ_ENC_FLIPPED_FLAG)
WHEN 41 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 42 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 43 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 44 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 45 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 46 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,201)
WHEN 8 THEN fvl14.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
, (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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_85'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_85');
END insert_sources_85;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_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
, h2.GL_DATE source_79
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_HEADER_V h2
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_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
, l3.PROJECT_NAME source_3
, l4.TASK_NAME source_4
, l1.EXPENDITURE_ORGANIZATION_ID source_5
, l1.EXPENDITURE_TYPE source_6
, l1.DOCUMENT_TYPE source_9
, l1.BUDGET_ACCOUNT source_11
, l1.MAIN_OR_BACKING_CODE source_13
, l1.BURDEN_COST_FLAG source_14
, fvl14.meaning source_14_meaning
, l3.PROJ_BURDEN_DISPLAY_METHOD source_15
, l1.ACCOUNTING_REVERSAL_FLAG source_16
, l1.ALLOC_TO_APPLN_ID source_17
, l1.ALLOC_TO_DIST_TYPE source_18
, l1.ALLOC_TO_ENTITY_CODE source_19
, l1.ALLOC_TO_FIRST_DIST_ID source_20
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_21
, l1.PO_APPLICATION_ID source_23
, l1.PO_DISTRIBUTION_TYPE source_24
, l1.PO_ENTITY_CODE source_25
, l1.PO_FIRST_DIST_ID source_26
, l1.PO_FIRST_SYS_TRANS_ID source_27
, l1.PO_SECOND_DIST_ID source_28
, l1.PO_DISTRIBUTION_ID source_29
, l1.LINE_TYPE_NAME source_30
, l1.ENC_UPG_CR_ACCT_CLASS source_31
, l1.ENC_UPG_CR_ACCOUNT source_32
, l1.ENTERED_AMT source_33
, l1.CURRENCY_CODE source_34
, l1.ACCOUNTED_AMT source_35
, l1.ENC_UPG_DR_ACCT_CLASS source_36
, l1.ENC_UPG_DR_ACCOUNT source_37
, l1.USE_ENC_UPG_ATTRIB_FLAG source_38
, l1.ENC_UPG_CR_ENC_TYPE_ID source_39
, l1.ENC_UPG_DR_ENC_TYPE_ID source_40
, l1.REQ_APPLICATION_ID source_41
, l1.REQ_DISTRIBUTION_TYPE source_42
, l1.REQ_ENTITY_CODE source_43
, l1.REQ_FIRST_DIST_ID source_44
, l1.REQ_FIRST_SYS_TRANS_ID source_45
, l1.REQ_SECOND_DIST_ID source_46
, l1.BACKING_REQ_ENC_FLIPPED_FLAG source_67
, l1.PA_APPLICATION_ID source_68
, l1.PA_DISTRIBUTION_TYPE source_69
, l1.PA_ENTITY_CODE source_70
, l1.PA_FIRST_DIST_ID source_71
, l1.PA_FIRST_SYS_TRANS_ID source_72
, l1.PA_SECOND_DIST_ID source_73
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_86(
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) := 'PO_PA_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_86';
(p_msg => 'BEGIN of insert_sources_86'
,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 'PO_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_EXTRACT_HEADER_V'
WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_TYPE'
WHEN 2 THEN 'PO_NUMBER'
WHEN 3 THEN 'PO_HEADER_ID'
WHEN 4 THEN 'GL_DATE'
WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.PO_TYPE)
WHEN 2 THEN TO_CHAR(h3.PO_NUMBER)
WHEN 3 THEN TO_CHAR(h3.PO_HEADER_ID)
WHEN 4 THEN TO_CHAR(h3.GL_DATE)
WHEN 5 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h3
,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
)
;
(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 'PO_EXTRACT_DETAIL_V'
WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 21 THEN 'PO_DISTS_REF_V'
WHEN 22 THEN 'PO_DISTS_REF_V'
WHEN 23 THEN 'PO_DISTS_REF_V'
WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 25 THEN 'PO_EXTRACT_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'BUDGET_ACCOUNT'
WHEN 3 THEN 'MAIN_OR_BACKING_CODE'
WHEN 4 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 5 THEN 'PO_DISTRIBUTION_TYPE'
WHEN 6 THEN 'PO_DISTRIBUTION_ID'
WHEN 7 THEN 'ENTERED_AMT'
WHEN 8 THEN 'CURRENCY_CODE'
WHEN 9 THEN 'ACCOUNTED_AMT'
WHEN 10 THEN 'ALLOC_TO_DISTRIBUTION_TYPE'
WHEN 11 THEN 'ALLOC_TO_DIST_ID_1'
WHEN 12 THEN 'APPLIED_TO_APPL_ID'
WHEN 13 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 14 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 15 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 16 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 17 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 18 THEN 'PO_ENCUM_UPG_OPTION'
WHEN 19 THEN 'JFMIP_REFERENCE'
WHEN 20 THEN 'PO_UPG_ENC_TYPE_ID'
WHEN 21 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 22 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 23 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 24 THEN 'BACKING_REQ_ENC_CHANGED'
WHEN 25 THEN 'ADJUSTMENT_STATUS'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l2.BUDGET_ACCOUNT)
WHEN 3 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
WHEN 4 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
WHEN 5 THEN TO_CHAR(l2.PO_DISTRIBUTION_TYPE)
WHEN 6 THEN TO_CHAR(l2.PO_DISTRIBUTION_ID)
WHEN 7 THEN TO_CHAR(l2.ENTERED_AMT)
WHEN 8 THEN TO_CHAR(l2.CURRENCY_CODE)
WHEN 9 THEN TO_CHAR(l2.ACCOUNTED_AMT)
WHEN 10 THEN TO_CHAR(l2.ALLOC_TO_DISTRIBUTION_TYPE)
WHEN 11 THEN TO_CHAR(l2.ALLOC_TO_DIST_ID_1)
WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
WHEN 13 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
WHEN 14 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
WHEN 15 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
WHEN 16 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
WHEN 17 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
WHEN 18 THEN TO_CHAR(l2.PO_ENCUM_UPG_OPTION)
WHEN 19 THEN TO_CHAR(l2.JFMIP_REFERENCE)
WHEN 20 THEN TO_CHAR(l2.PO_UPG_ENC_TYPE_ID)
WHEN 21 THEN TO_CHAR(l1.CURRENCY_CONVERSION_DATE)
WHEN 22 THEN TO_CHAR(l1.CURRENCY_CONVERSION_RATE)
WHEN 23 THEN TO_CHAR(l1.CURRENCY_CONVERSION_TYPE)
WHEN 24 THEN TO_CHAR(l2.BACKING_REQ_ENC_CHANGED)
WHEN 25 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_DISTS_REF_V l1
, PO_EXTRACT_DETAIL_V l2
, (select rownum r from all_objects where rownum <= 25 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.po_distribution_id = l1.po_distribution_id (+) and l2.po_distribution_type = l1.po_distribution_type (+)
)
;
(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_86'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_86');
END insert_sources_86;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
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.PO_TYPE source_1
, h3.PO_NUMBER source_2
, h3.PO_HEADER_ID source_52
, h3.GL_DATE source_79
, h3.ENCUMBRANCE_TYPE_ID source_80
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h3
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PO_PA
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.JE_LINE_DESCRIPTION source_7
, l2.BUDGET_ACCOUNT source_11
, l2.MAIN_OR_BACKING_CODE source_13
, l2.ACCOUNTING_REVERSAL_FLAG source_16
, l2.PO_DISTRIBUTION_TYPE source_24
, l2.PO_DISTRIBUTION_ID source_29
, l2.ENTERED_AMT source_33
, l2.CURRENCY_CODE source_34
, l2.ACCOUNTED_AMT source_35
, l2.ALLOC_TO_DISTRIBUTION_TYPE source_49
, l2.ALLOC_TO_DIST_ID_1 source_51
, l2.APPLIED_TO_APPL_ID source_53
, l2.APPLIED_TO_DIST_LINK_TYPE source_54
, l2.APPLIED_TO_ENTITY_CODE source_55
, l2.APPLIED_TO_DIST_ID_1 source_56
, l2.APPLIED_TO_HEADER_ID_1 source_57
, l2.DISTRIBUTION_LINK_TYPE source_58
, l2.PO_ENCUM_UPG_OPTION source_59
, l2.JFMIP_REFERENCE source_60
, l2.PO_UPG_ENC_TYPE_ID source_61
, l1.CURRENCY_CONVERSION_DATE source_62
, l1.CURRENCY_CONVERSION_RATE source_63
, l1.CURRENCY_CONVERSION_TYPE source_64
, l2.BACKING_REQ_ENC_CHANGED source_65
, l2.ADJUSTMENT_STATUS source_75
FROM xla_events_gt xet
, PO_DISTS_REF_V l1
, PO_EXTRACT_DETAIL_V l2
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l2.po_distribution_id = l1.po_distribution_id (+) AND l2.po_distribution_type = l1.po_distribution_type (+) ;
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_87(
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) := 'RELEASE_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_87';
(p_msg => 'BEGIN of insert_sources_87'
,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 'PO_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_RELEASES_REF_V'
WHEN 4 THEN 'PO_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_EXTRACT_HEADER_V'
WHEN 6 THEN 'PO_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_TYPE'
WHEN 2 THEN 'PO_NUMBER'
WHEN 3 THEN 'PO_RELEASE_NUMBER'
WHEN 4 THEN 'PO_RELEASE_ID'
WHEN 5 THEN 'GL_DATE'
WHEN 6 THEN 'ENCUMBRANCE_TYPE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h3.PO_TYPE)
WHEN 2 THEN TO_CHAR(h3.PO_NUMBER)
WHEN 3 THEN TO_CHAR(h4.PO_RELEASE_NUMBER)
WHEN 4 THEN TO_CHAR(h3.PO_RELEASE_ID)
WHEN 5 THEN TO_CHAR(h3.GL_DATE)
WHEN 6 THEN TO_CHAR(h3.ENCUMBRANCE_TYPE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h3
, PO_RELEASES_REF_V h4
,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
AND h3.po_release_id = h4.po_release_id
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 2 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 3 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 5 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 6 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
WHEN 20 THEN 'PO_DISTS_REF_V'
WHEN 21 THEN 'PO_DISTS_REF_V'
WHEN 22 THEN 'PO_DISTS_REF_V'
WHEN 23 THEN 'PO_EXTRACT_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'BUDGET_ACCOUNT'
WHEN 3 THEN 'MAIN_OR_BACKING_CODE'
WHEN 4 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 5 THEN 'PO_DISTRIBUTION_ID'
WHEN 6 THEN 'ENTERED_AMT'
WHEN 7 THEN 'CURRENCY_CODE'
WHEN 8 THEN 'ACCOUNTED_AMT'
WHEN 9 THEN 'ALLOC_TO_DISTRIBUTION_TYPE'
WHEN 10 THEN 'ALLOC_TO_DIST_ID_1'
WHEN 11 THEN 'APPLIED_TO_APPL_ID'
WHEN 12 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 13 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 14 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 15 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 16 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 17 THEN 'PO_ENCUM_UPG_OPTION'
WHEN 18 THEN 'JFMIP_REFERENCE'
WHEN 19 THEN 'PO_UPG_ENC_TYPE_ID'
WHEN 20 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 21 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 22 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 23 THEN 'ADJUSTMENT_STATUS'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l2.BUDGET_ACCOUNT)
WHEN 3 THEN TO_CHAR(l2.MAIN_OR_BACKING_CODE)
WHEN 4 THEN TO_CHAR(l2.ACCOUNTING_REVERSAL_FLAG)
WHEN 5 THEN TO_CHAR(l2.PO_DISTRIBUTION_ID)
WHEN 6 THEN TO_CHAR(l2.ENTERED_AMT)
WHEN 7 THEN TO_CHAR(l2.CURRENCY_CODE)
WHEN 8 THEN TO_CHAR(l2.ACCOUNTED_AMT)
WHEN 9 THEN TO_CHAR(l2.ALLOC_TO_DISTRIBUTION_TYPE)
WHEN 10 THEN TO_CHAR(l2.ALLOC_TO_DIST_ID_1)
WHEN 11 THEN TO_CHAR(l2.APPLIED_TO_APPL_ID)
WHEN 12 THEN TO_CHAR(l2.APPLIED_TO_DIST_LINK_TYPE)
WHEN 13 THEN TO_CHAR(l2.APPLIED_TO_ENTITY_CODE)
WHEN 14 THEN TO_CHAR(l2.APPLIED_TO_DIST_ID_1)
WHEN 15 THEN TO_CHAR(l2.APPLIED_TO_HEADER_ID_1)
WHEN 16 THEN TO_CHAR(l2.DISTRIBUTION_LINK_TYPE)
WHEN 17 THEN TO_CHAR(l2.PO_ENCUM_UPG_OPTION)
WHEN 18 THEN TO_CHAR(l2.JFMIP_REFERENCE)
WHEN 19 THEN TO_CHAR(l2.PO_UPG_ENC_TYPE_ID)
WHEN 20 THEN TO_CHAR(l1.CURRENCY_CONVERSION_DATE)
WHEN 21 THEN TO_CHAR(l1.CURRENCY_CONVERSION_RATE)
WHEN 22 THEN TO_CHAR(l1.CURRENCY_CONVERSION_TYPE)
WHEN 23 THEN TO_CHAR(l2.ADJUSTMENT_STATUS)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_DISTS_REF_V l1
, PO_EXTRACT_DETAIL_V l2
, (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l2.event_id = xet.event_id
AND l2.po_distribution_id = l1.po_distribution_id (+) and l2.po_distribution_type = l1.po_distribution_type (+)
)
;
(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_87'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_87');
END insert_sources_87;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
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.PO_TYPE source_1
, h3.PO_NUMBER source_2
, h4.PO_RELEASE_NUMBER source_8
, h3.PO_RELEASE_ID source_66
, h3.GL_DATE source_79
, h3.ENCUMBRANCE_TYPE_ID source_80
FROM xla_events_gt xet
, PO_EXTRACT_HEADER_V h3
, PO_RELEASES_REF_V h4
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
AND h3.po_release_id = h4.po_release_id
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE
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.JE_LINE_DESCRIPTION source_7
, l2.BUDGET_ACCOUNT source_11
, l2.MAIN_OR_BACKING_CODE source_13
, l2.ACCOUNTING_REVERSAL_FLAG source_16
, l2.PO_DISTRIBUTION_ID source_29
, l2.ENTERED_AMT source_33
, l2.CURRENCY_CODE source_34
, l2.ACCOUNTED_AMT source_35
, l2.ALLOC_TO_DISTRIBUTION_TYPE source_49
, l2.ALLOC_TO_DIST_ID_1 source_51
, l2.APPLIED_TO_APPL_ID source_53
, l2.APPLIED_TO_DIST_LINK_TYPE source_54
, l2.APPLIED_TO_ENTITY_CODE source_55
, l2.APPLIED_TO_DIST_ID_1 source_56
, l2.APPLIED_TO_HEADER_ID_1 source_57
, l2.DISTRIBUTION_LINK_TYPE source_58
, l2.PO_ENCUM_UPG_OPTION source_59
, l2.JFMIP_REFERENCE source_60
, l2.PO_UPG_ENC_TYPE_ID source_61
, l1.CURRENCY_CONVERSION_DATE source_62
, l1.CURRENCY_CONVERSION_RATE source_63
, l1.CURRENCY_CONVERSION_TYPE source_64
, l2.ADJUSTMENT_STATUS source_75
FROM xla_events_gt xet
, PO_DISTS_REF_V l1
, PO_EXTRACT_DETAIL_V l2
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l2.po_distribution_id = l1.po_distribution_id (+) AND l2.po_distribution_type = l1.po_distribution_type (+) ;
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_88(
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) := 'RELEASE_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_88';
(p_msg => 'BEGIN of insert_sources_88'
,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 'PA_XLA_BC_PKT_PO_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_HEADER_V h2
,(select rownum r from all_objects where rownum <= 1 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
)
;
(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 'PA_XLA_PROJECT_REF_V'
WHEN 2 THEN 'PA_XLA_TASK_REF_V'
WHEN 3 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 4 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 8 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 9 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 12 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 14 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 15 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 41 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 42 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 43 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 44 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 45 THEN 'PA_XLA_BC_PKT_PO_DETAIL_V'
WHEN 46 THEN 'PA_XLA_BC_PKT_PO_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '275'
WHEN 2 THEN '275'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '275'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
WHEN 26 THEN '201'
WHEN 27 THEN '201'
WHEN 28 THEN '201'
WHEN 29 THEN '201'
WHEN 30 THEN '201'
WHEN 31 THEN '201'
WHEN 32 THEN '201'
WHEN 33 THEN '201'
WHEN 34 THEN '201'
WHEN 35 THEN '201'
WHEN 36 THEN '201'
WHEN 37 THEN '201'
WHEN 38 THEN '201'
WHEN 39 THEN '201'
WHEN 40 THEN '201'
WHEN 41 THEN '201'
WHEN 42 THEN '201'
WHEN 43 THEN '201'
WHEN 44 THEN '201'
WHEN 45 THEN '201'
WHEN 46 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PROJECT_NAME'
WHEN 2 THEN 'TASK_NAME'
WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 4 THEN 'EXPENDITURE_TYPE'
WHEN 5 THEN 'DOCUMENT_TYPE'
WHEN 6 THEN 'BUDGET_ACCOUNT'
WHEN 7 THEN 'MAIN_OR_BACKING_CODE'
WHEN 8 THEN 'BURDEN_COST_FLAG'
WHEN 9 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 10 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 11 THEN 'ALLOC_TO_APPLN_ID'
WHEN 12 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 13 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 14 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 15 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 16 THEN 'ALLOC_TO_SECOND_DIST_ID'
WHEN 17 THEN 'PO_APPLICATION_ID'
WHEN 18 THEN 'PO_DISTRIBUTION_TYPE'
WHEN 19 THEN 'PO_ENTITY_CODE'
WHEN 20 THEN 'PO_FIRST_DIST_ID'
WHEN 21 THEN 'PO_FIRST_SYS_TRANS_ID'
WHEN 22 THEN 'PO_SECOND_DIST_ID'
WHEN 23 THEN 'PO_DISTRIBUTION_ID'
WHEN 24 THEN 'LINE_TYPE_NAME'
WHEN 25 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 26 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 27 THEN 'ENTERED_AMT'
WHEN 28 THEN 'CURRENCY_CODE'
WHEN 29 THEN 'ACCOUNTED_AMT'
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 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 34 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 35 THEN 'REQ_APPLICATION_ID'
WHEN 36 THEN 'REQ_DISTRIBUTION_TYPE'
WHEN 37 THEN 'REQ_ENTITY_CODE'
WHEN 38 THEN 'REQ_FIRST_DIST_ID'
WHEN 39 THEN 'REQ_FIRST_SYS_TRANS_ID'
WHEN 40 THEN 'REQ_SECOND_DIST_ID'
WHEN 41 THEN 'PA_APPLICATION_ID'
WHEN 42 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 43 THEN 'PA_ENTITY_CODE'
WHEN 44 THEN 'PA_FIRST_DIST_ID'
WHEN 45 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 46 THEN 'PA_SECOND_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
WHEN 5 THEN TO_CHAR(l1.DOCUMENT_TYPE)
WHEN 6 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
WHEN 7 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
WHEN 8 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 9 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 10 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 16 THEN TO_CHAR(l1.ALLOC_TO_SECOND_DIST_ID)
WHEN 17 THEN TO_CHAR(l1.PO_APPLICATION_ID)
WHEN 18 THEN TO_CHAR(l1.PO_DISTRIBUTION_TYPE)
WHEN 19 THEN TO_CHAR(l1.PO_ENTITY_CODE)
WHEN 20 THEN TO_CHAR(l1.PO_FIRST_DIST_ID)
WHEN 21 THEN TO_CHAR(l1.PO_FIRST_SYS_TRANS_ID)
WHEN 22 THEN TO_CHAR(l1.PO_SECOND_DIST_ID)
WHEN 23 THEN TO_CHAR(l1.PO_DISTRIBUTION_ID)
WHEN 24 THEN TO_CHAR(l1.LINE_TYPE_NAME)
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.ENTERED_AMT)
WHEN 28 THEN TO_CHAR(l1.CURRENCY_CODE)
WHEN 29 THEN TO_CHAR(l1.ACCOUNTED_AMT)
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.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 34 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 35 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
WHEN 36 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
WHEN 37 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
WHEN 38 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
WHEN 39 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
WHEN 40 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
WHEN 41 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 42 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 43 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 44 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 45 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 46 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
ELSE null
END source_value
, CASE r
WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,201)
WHEN 8 THEN fvl14.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
, (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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_88'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_88');
END insert_sources_88;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE_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
, h2.GL_DATE source_79
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_HEADER_V h2
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RELEASE_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
, l3.PROJECT_NAME source_3
, l4.TASK_NAME source_4
, l1.EXPENDITURE_ORGANIZATION_ID source_5
, l1.EXPENDITURE_TYPE source_6
, l1.DOCUMENT_TYPE source_9
, l1.BUDGET_ACCOUNT source_11
, l1.MAIN_OR_BACKING_CODE source_13
, l1.BURDEN_COST_FLAG source_14
, fvl14.meaning source_14_meaning
, l3.PROJ_BURDEN_DISPLAY_METHOD source_15
, l1.ACCOUNTING_REVERSAL_FLAG source_16
, l1.ALLOC_TO_APPLN_ID source_17
, l1.ALLOC_TO_DIST_TYPE source_18
, l1.ALLOC_TO_ENTITY_CODE source_19
, l1.ALLOC_TO_FIRST_DIST_ID source_20
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_21
, l1.ALLOC_TO_SECOND_DIST_ID source_22
, l1.PO_APPLICATION_ID source_23
, l1.PO_DISTRIBUTION_TYPE source_24
, l1.PO_ENTITY_CODE source_25
, l1.PO_FIRST_DIST_ID source_26
, l1.PO_FIRST_SYS_TRANS_ID source_27
, l1.PO_SECOND_DIST_ID source_28
, l1.PO_DISTRIBUTION_ID source_29
, l1.LINE_TYPE_NAME source_30
, l1.ENC_UPG_CR_ACCT_CLASS source_31
, l1.ENC_UPG_CR_ACCOUNT source_32
, l1.ENTERED_AMT source_33
, l1.CURRENCY_CODE source_34
, l1.ACCOUNTED_AMT source_35
, l1.ENC_UPG_DR_ACCT_CLASS source_36
, l1.ENC_UPG_DR_ACCOUNT source_37
, l1.USE_ENC_UPG_ATTRIB_FLAG source_38
, l1.ENC_UPG_CR_ENC_TYPE_ID source_39
, l1.ENC_UPG_DR_ENC_TYPE_ID source_40
, l1.REQ_APPLICATION_ID source_41
, l1.REQ_DISTRIBUTION_TYPE source_42
, l1.REQ_ENTITY_CODE source_43
, l1.REQ_FIRST_DIST_ID source_44
, l1.REQ_FIRST_SYS_TRANS_ID source_45
, l1.REQ_SECOND_DIST_ID source_46
, l1.PA_APPLICATION_ID source_68
, l1.PA_DISTRIBUTION_TYPE source_69
, l1.PA_ENTITY_CODE source_70
, l1.PA_FIRST_DIST_ID source_71
, l1.PA_FIRST_SYS_TRANS_ID source_72
, l1.PA_SECOND_DIST_ID source_73
FROM xla_events_gt xet
, PA_XLA_BC_PKT_PO_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_89(
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) := 'REQUISITION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_89';
(p_msg => 'BEGIN of insert_sources_89'
,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 'PO_REQ_EXTRACT_HEADER_V'
WHEN 2 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 3 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 4 THEN 'PO_REQ_EXTRACT_HEADER_V'
WHEN 5 THEN 'PO_REQ_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DOCUMENT_TYPE'
WHEN 2 THEN 'REQ_NUMBER'
WHEN 3 THEN 'REQ_ID'
WHEN 4 THEN 'GL_DATE'
WHEN 5 THEN 'ENCUMBRANCE_TYPE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.DOCUMENT_TYPE)
WHEN 2 THEN TO_CHAR(h2.REQ_NUMBER)
WHEN 3 THEN TO_CHAR(h2.REQ_ID)
WHEN 4 THEN TO_CHAR(h2.GL_DATE)
WHEN 5 THEN TO_CHAR(h2.ENCUMBRANCE_TYPE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_REQ_EXTRACT_HEADER_V h2
,(select rownum r from all_objects where rownum <= 5 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
)
;
(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 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 2 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 3 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 4 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 5 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 6 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 7 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 8 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 9 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 10 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 11 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 12 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 13 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 14 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 15 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 16 THEN 'PO_REQ_LINES_REF_V'
WHEN 17 THEN 'PO_REQ_LINES_REF_V'
WHEN 18 THEN 'PO_REQ_LINES_REF_V'
WHEN 19 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 20 THEN 'PO_REQ_EXTRACT_DETAIL_V'
WHEN 21 THEN 'PO_REQ_EXTRACT_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '201'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '201'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'JE_LINE_DESCRIPTION'
WHEN 2 THEN 'BUDGET_ACCOUNT'
WHEN 3 THEN 'MAIN_OR_BACKING_CODE'
WHEN 4 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 5 THEN 'ENTERED_AMT'
WHEN 6 THEN 'CURRENCY_CODE'
WHEN 7 THEN 'ACCOUNTED_AMT'
WHEN 8 THEN 'REQ_DISTRIBUTION_ID'
WHEN 9 THEN 'APPLIED_TO_APPL_ID'
WHEN 10 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 11 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 12 THEN 'APPLIED_TO_DIST_ID_1'
WHEN 13 THEN 'APPLIED_TO_HEADER_ID_1'
WHEN 14 THEN 'DISTRIBUTION_LINK_TYPE'
WHEN 15 THEN 'JFMIP_REFERENCE'
WHEN 16 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 17 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 18 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 19 THEN 'ADJUSTMENT_STATUS'
WHEN 20 THEN 'REQ_ENCUM_UPG_OPTION'
WHEN 21 THEN 'REQ_UPG_ENC_TYPE_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.JE_LINE_DESCRIPTION)
WHEN 2 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
WHEN 3 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
WHEN 4 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
WHEN 5 THEN TO_CHAR(l1.ENTERED_AMT)
WHEN 6 THEN TO_CHAR(l1.CURRENCY_CODE)
WHEN 7 THEN TO_CHAR(l1.ACCOUNTED_AMT)
WHEN 8 THEN TO_CHAR(l1.REQ_DISTRIBUTION_ID)
WHEN 9 THEN TO_CHAR(l1.APPLIED_TO_APPL_ID)
WHEN 10 THEN TO_CHAR(l1.APPLIED_TO_DIST_LINK_TYPE)
WHEN 11 THEN TO_CHAR(l1.APPLIED_TO_ENTITY_CODE)
WHEN 12 THEN TO_CHAR(l1.APPLIED_TO_DIST_ID_1)
WHEN 13 THEN TO_CHAR(l1.APPLIED_TO_HEADER_ID_1)
WHEN 14 THEN TO_CHAR(l1.DISTRIBUTION_LINK_TYPE)
WHEN 15 THEN TO_CHAR(l1.JFMIP_REFERENCE)
WHEN 16 THEN TO_CHAR(l3.CURRENCY_CONVERSION_DATE)
WHEN 17 THEN TO_CHAR(l3.CURRENCY_CONVERSION_RATE)
WHEN 18 THEN TO_CHAR(l3.CURRENCY_CONVERSION_TYPE)
WHEN 19 THEN TO_CHAR(l1.ADJUSTMENT_STATUS)
WHEN 20 THEN TO_CHAR(l1.REQ_ENCUM_UPG_OPTION)
WHEN 21 THEN TO_CHAR(l1.REQ_UPG_ENC_TYPE_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PO_REQ_EXTRACT_DETAIL_V l1
, PO_REQ_LINES_REF_V l3
, (select rownum r from all_objects where rownum <= 21 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.req_line_id = l3.req_line_id (+)
)
;
(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_89'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_89');
END insert_sources_89;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
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
, h2.DOCUMENT_TYPE source_9
, h2.REQ_NUMBER source_10
, h2.REQ_ID source_76
, h2.GL_DATE source_79
, h2.ENCUMBRANCE_TYPE_ID source_80
FROM xla_events_gt xet
, PO_REQ_EXTRACT_HEADER_V h2
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION
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.JE_LINE_DESCRIPTION source_7
, l1.BUDGET_ACCOUNT source_11
, l1.MAIN_OR_BACKING_CODE source_13
, l1.ACCOUNTING_REVERSAL_FLAG source_16
, l1.ENTERED_AMT source_33
, l1.CURRENCY_CODE source_34
, l1.ACCOUNTED_AMT source_35
, l1.REQ_DISTRIBUTION_ID source_47
, l1.APPLIED_TO_APPL_ID source_53
, l1.APPLIED_TO_DIST_LINK_TYPE source_54
, l1.APPLIED_TO_ENTITY_CODE source_55
, l1.APPLIED_TO_DIST_ID_1 source_56
, l1.APPLIED_TO_HEADER_ID_1 source_57
, l1.DISTRIBUTION_LINK_TYPE source_58
, l1.JFMIP_REFERENCE source_60
, l3.CURRENCY_CONVERSION_DATE source_62
, l3.CURRENCY_CONVERSION_RATE source_63
, l3.CURRENCY_CONVERSION_TYPE source_64
, l1.ADJUSTMENT_STATUS source_75
, l1.REQ_ENCUM_UPG_OPTION source_77
, l1.REQ_UPG_ENC_TYPE_ID source_78
FROM xla_events_gt xet
, PO_REQ_EXTRACT_DETAIL_V l1
, PO_REQ_LINES_REF_V l3
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
AND l1.req_line_id = l3.req_line_id (+) ;
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_90(
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) := 'REQUISITION_BURDEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_90';
(p_msg => 'BEGIN of insert_sources_90'
,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 'PA_XLA_BC_PKT_REQ_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_REQ_HEADER_V h2
,(select rownum r from all_objects where rownum <= 1 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
)
;
(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 'PA_XLA_PROJECT_REF_V'
WHEN 2 THEN 'PA_XLA_TASK_REF_V'
WHEN 3 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 4 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 5 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 6 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 7 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 8 THEN 'PA_XLA_PROJECT_REF_V'
WHEN 9 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 10 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 11 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 12 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 13 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 14 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 15 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 16 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 17 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 18 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 19 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 20 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 21 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 22 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 23 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 24 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 25 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 26 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 27 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 28 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 29 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 30 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 31 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 32 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 33 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 34 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 35 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 36 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 37 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 38 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 39 THEN 'PA_XLA_BC_PKT_REQ_DETAIL_V'
WHEN 40 THEN 'PA_XLA_BC_PKT_REQ_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '275'
WHEN 2 THEN '275'
WHEN 3 THEN '201'
WHEN 4 THEN '201'
WHEN 5 THEN '201'
WHEN 6 THEN '201'
WHEN 7 THEN '201'
WHEN 8 THEN '275'
WHEN 9 THEN '201'
WHEN 10 THEN '201'
WHEN 11 THEN '201'
WHEN 12 THEN '201'
WHEN 13 THEN '201'
WHEN 14 THEN '201'
WHEN 15 THEN '201'
WHEN 16 THEN '201'
WHEN 17 THEN '201'
WHEN 18 THEN '201'
WHEN 19 THEN '201'
WHEN 20 THEN '201'
WHEN 21 THEN '201'
WHEN 22 THEN '201'
WHEN 23 THEN '201'
WHEN 24 THEN '201'
WHEN 25 THEN '201'
WHEN 26 THEN '201'
WHEN 27 THEN '201'
WHEN 28 THEN '201'
WHEN 29 THEN '201'
WHEN 30 THEN '201'
WHEN 31 THEN '201'
WHEN 32 THEN '201'
WHEN 33 THEN '201'
WHEN 34 THEN '201'
WHEN 35 THEN '201'
WHEN 36 THEN '201'
WHEN 37 THEN '201'
WHEN 38 THEN '201'
WHEN 39 THEN '201'
WHEN 40 THEN '201'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PROJECT_NAME'
WHEN 2 THEN 'TASK_NAME'
WHEN 3 THEN 'EXPENDITURE_ORGANIZATION_ID'
WHEN 4 THEN 'EXPENDITURE_TYPE'
WHEN 5 THEN 'BUDGET_ACCOUNT'
WHEN 6 THEN 'MAIN_OR_BACKING_CODE'
WHEN 7 THEN 'BURDEN_COST_FLAG'
WHEN 8 THEN 'PROJ_BURDEN_DISPLAY_METHOD'
WHEN 9 THEN 'ACCOUNTING_REVERSAL_FLAG'
WHEN 10 THEN 'ALLOC_TO_APPLN_ID'
WHEN 11 THEN 'ALLOC_TO_DIST_TYPE'
WHEN 12 THEN 'ALLOC_TO_ENTITY_CODE'
WHEN 13 THEN 'ALLOC_TO_FIRST_DIST_ID'
WHEN 14 THEN 'ALLOC_TO_FIRST_SYS_TRANS_ID'
WHEN 15 THEN 'ALLOC_TO_SECOND_DIST_ID'
WHEN 16 THEN 'LINE_TYPE_NAME'
WHEN 17 THEN 'ENC_UPG_CR_ACCT_CLASS'
WHEN 18 THEN 'ENC_UPG_CR_ACCOUNT'
WHEN 19 THEN 'ENTERED_AMT'
WHEN 20 THEN 'CURRENCY_CODE'
WHEN 21 THEN 'ACCOUNTED_AMT'
WHEN 22 THEN 'ENC_UPG_DR_ACCT_CLASS'
WHEN 23 THEN 'ENC_UPG_DR_ACCOUNT'
WHEN 24 THEN 'USE_ENC_UPG_ATTRIB_FLAG'
WHEN 25 THEN 'ENC_UPG_CR_ENC_TYPE_ID'
WHEN 26 THEN 'ENC_UPG_DR_ENC_TYPE_ID'
WHEN 27 THEN 'REQ_APPLICATION_ID'
WHEN 28 THEN 'REQ_DISTRIBUTION_TYPE'
WHEN 29 THEN 'REQ_ENTITY_CODE'
WHEN 30 THEN 'REQ_FIRST_DIST_ID'
WHEN 31 THEN 'REQ_FIRST_SYS_TRANS_ID'
WHEN 32 THEN 'REQ_SECOND_DIST_ID'
WHEN 33 THEN 'REQ_DISTRIBUTION_ID'
WHEN 34 THEN 'PA_APPLICATION_ID'
WHEN 35 THEN 'PA_DISTRIBUTION_TYPE'
WHEN 36 THEN 'PA_ENTITY_CODE'
WHEN 37 THEN 'PA_FIRST_DIST_ID'
WHEN 38 THEN 'PA_FIRST_SYS_TRANS_ID'
WHEN 39 THEN 'PA_SECOND_DIST_ID'
WHEN 40 THEN 'DOCUMENT_DISTRIBUTION_TYPE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l3.PROJECT_NAME)
WHEN 2 THEN TO_CHAR(l4.TASK_NAME)
WHEN 3 THEN TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
WHEN 4 THEN TO_CHAR(l1.EXPENDITURE_TYPE)
WHEN 5 THEN TO_CHAR(l1.BUDGET_ACCOUNT)
WHEN 6 THEN TO_CHAR(l1.MAIN_OR_BACKING_CODE)
WHEN 7 THEN TO_CHAR(l1.BURDEN_COST_FLAG)
WHEN 8 THEN TO_CHAR(l3.PROJ_BURDEN_DISPLAY_METHOD)
WHEN 9 THEN TO_CHAR(l1.ACCOUNTING_REVERSAL_FLAG)
WHEN 10 THEN TO_CHAR(l1.ALLOC_TO_APPLN_ID)
WHEN 11 THEN TO_CHAR(l1.ALLOC_TO_DIST_TYPE)
WHEN 12 THEN TO_CHAR(l1.ALLOC_TO_ENTITY_CODE)
WHEN 13 THEN TO_CHAR(l1.ALLOC_TO_FIRST_DIST_ID)
WHEN 14 THEN TO_CHAR(l1.ALLOC_TO_FIRST_SYS_TRANS_ID)
WHEN 15 THEN TO_CHAR(l1.ALLOC_TO_SECOND_DIST_ID)
WHEN 16 THEN TO_CHAR(l1.LINE_TYPE_NAME)
WHEN 17 THEN TO_CHAR(l1.ENC_UPG_CR_ACCT_CLASS)
WHEN 18 THEN TO_CHAR(l1.ENC_UPG_CR_ACCOUNT)
WHEN 19 THEN TO_CHAR(l1.ENTERED_AMT)
WHEN 20 THEN TO_CHAR(l1.CURRENCY_CODE)
WHEN 21 THEN TO_CHAR(l1.ACCOUNTED_AMT)
WHEN 22 THEN TO_CHAR(l1.ENC_UPG_DR_ACCT_CLASS)
WHEN 23 THEN TO_CHAR(l1.ENC_UPG_DR_ACCOUNT)
WHEN 24 THEN TO_CHAR(l1.USE_ENC_UPG_ATTRIB_FLAG)
WHEN 25 THEN TO_CHAR(l1.ENC_UPG_CR_ENC_TYPE_ID)
WHEN 26 THEN TO_CHAR(l1.ENC_UPG_DR_ENC_TYPE_ID)
WHEN 27 THEN TO_CHAR(l1.REQ_APPLICATION_ID)
WHEN 28 THEN TO_CHAR(l1.REQ_DISTRIBUTION_TYPE)
WHEN 29 THEN TO_CHAR(l1.REQ_ENTITY_CODE)
WHEN 30 THEN TO_CHAR(l1.REQ_FIRST_DIST_ID)
WHEN 31 THEN TO_CHAR(l1.REQ_FIRST_SYS_TRANS_ID)
WHEN 32 THEN TO_CHAR(l1.REQ_SECOND_DIST_ID)
WHEN 33 THEN TO_CHAR(l1.REQ_DISTRIBUTION_ID)
WHEN 34 THEN TO_CHAR(l1.PA_APPLICATION_ID)
WHEN 35 THEN TO_CHAR(l1.PA_DISTRIBUTION_TYPE)
WHEN 36 THEN TO_CHAR(l1.PA_ENTITY_CODE)
WHEN 37 THEN TO_CHAR(l1.PA_FIRST_DIST_ID)
WHEN 38 THEN TO_CHAR(l1.PA_FIRST_SYS_TRANS_ID)
WHEN 39 THEN TO_CHAR(l1.PA_SECOND_DIST_ID)
WHEN 40 THEN TO_CHAR(l1.DOCUMENT_DISTRIBUTION_TYPE)
ELSE null
END source_value
, CASE r
WHEN 3 THEN XLA_00201_AAD_S_000005_BC_PKG.GetMeaning(
1011404
,TO_CHAR(l1.EXPENDITURE_ORGANIZATION_ID)
,'EXPENDITURE_ORGANIZATION_ID'
,'S'
,201)
WHEN 7 THEN fvl14.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, PA_XLA_BC_PKT_REQ_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
, (select rownum r from all_objects where rownum <= 40 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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_90'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00201_AAD_S_000005_BC_PKG.insert_sources_90');
END insert_sources_90;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION_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
, h2.GL_DATE source_79
FROM xla_events_gt xet
, PA_XLA_BC_PKT_REQ_HEADER_V h2
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REQUISITION_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
, l3.PROJECT_NAME source_3
, l4.TASK_NAME source_4
, l1.EXPENDITURE_ORGANIZATION_ID source_5
, l1.EXPENDITURE_TYPE source_6
, l1.BUDGET_ACCOUNT source_11
, l1.MAIN_OR_BACKING_CODE source_13
, l1.BURDEN_COST_FLAG source_14
, fvl14.meaning source_14_meaning
, l3.PROJ_BURDEN_DISPLAY_METHOD source_15
, l1.ACCOUNTING_REVERSAL_FLAG source_16
, l1.ALLOC_TO_APPLN_ID source_17
, l1.ALLOC_TO_DIST_TYPE source_18
, l1.ALLOC_TO_ENTITY_CODE source_19
, l1.ALLOC_TO_FIRST_DIST_ID source_20
, l1.ALLOC_TO_FIRST_SYS_TRANS_ID source_21
, l1.ALLOC_TO_SECOND_DIST_ID source_22
, l1.LINE_TYPE_NAME source_30
, l1.ENC_UPG_CR_ACCT_CLASS source_31
, l1.ENC_UPG_CR_ACCOUNT source_32
, l1.ENTERED_AMT source_33
, l1.CURRENCY_CODE source_34
, l1.ACCOUNTED_AMT source_35
, l1.ENC_UPG_DR_ACCT_CLASS source_36
, l1.ENC_UPG_DR_ACCOUNT source_37
, l1.USE_ENC_UPG_ATTRIB_FLAG source_38
, l1.ENC_UPG_CR_ENC_TYPE_ID source_39
, l1.ENC_UPG_DR_ENC_TYPE_ID source_40
, l1.REQ_APPLICATION_ID source_41
, l1.REQ_DISTRIBUTION_TYPE source_42
, l1.REQ_ENTITY_CODE source_43
, l1.REQ_FIRST_DIST_ID source_44
, l1.REQ_FIRST_SYS_TRANS_ID source_45
, l1.REQ_SECOND_DIST_ID source_46
, l1.REQ_DISTRIBUTION_ID source_47
, l1.PA_APPLICATION_ID source_68
, l1.PA_DISTRIBUTION_TYPE source_69
, l1.PA_ENTITY_CODE source_70
, l1.PA_FIRST_DIST_ID source_71
, l1.PA_FIRST_SYS_TRANS_ID source_72
, l1.PA_SECOND_DIST_ID source_73
, l1.DOCUMENT_DISTRIBUTION_TYPE source_74
FROM xla_events_gt xet
, PA_XLA_BC_PKT_REQ_DETAIL_V l1
, PA_XLA_PROJECT_REF_V l3
, PA_XLA_TASK_REF_V l4
, fnd_lookup_values fvl14
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 l3.project_id=l1.project_id AND l4.task_id=l1.task_id AND fvl14.lookup_type(+) = 'BC_PKT_BURDEN_COST_FLAG'
AND fvl14.lookup_code(+) = l1.BURDEN_COST_FLAG
AND fvl14.view_application_id(+) = 275
AND fvl14.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_85(
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_86(
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_87(
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_88(
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_89(
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_90(
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
);