[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
,p_balance_type_code => l_balance_type_code
);
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
(p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
,p_balance_type_code => l_balance_type_code);
PROCEDURE insert_sources_53(
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) := 'DELIVER_EXPENSE_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_53';
(p_msg => 'BEGIN of insert_sources_53'
,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_DISTS_REF_V'
WHEN 2 THEN 'CST_XLA_RCV_REF_V'
WHEN 3 THEN 'CST_XLA_RCV_REF_V'
WHEN 4 THEN 'CST_XLA_RCV_REF_V'
WHEN 5 THEN 'CST_XLA_RCV_REF_V'
WHEN 6 THEN 'CST_XLA_RCV_REF_V'
WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
WHEN 8 THEN 'CST_XLA_RCV_REF_V'
WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
WHEN 10 THEN 'CST_XLA_RCV_REF_V'
WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
WHEN 15 THEN 'PO_HEADERS_REF_V'
WHEN 16 THEN 'CST_XLA_RCV_REF_V'
WHEN 17 THEN 'CST_XLA_RCV_HEADERS_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
WHEN 14 THEN 'HEADER'
WHEN 15 THEN 'HEADER'
WHEN 16 THEN 'HEADER'
WHEN 17 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '707'
WHEN 3 THEN '707'
WHEN 4 THEN '707'
WHEN 5 THEN '707'
WHEN 6 THEN '707'
WHEN 7 THEN '707'
WHEN 8 THEN '707'
WHEN 9 THEN '707'
WHEN 10 THEN '707'
WHEN 11 THEN '707'
WHEN 12 THEN '707'
WHEN 13 THEN '707'
WHEN 14 THEN '707'
WHEN 15 THEN '201'
WHEN 16 THEN '707'
WHEN 17 THEN '707'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_BUDGET_ACCOUNT'
WHEN 2 THEN 'APPLIED_TO_APPL_ID'
WHEN 3 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 4 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 5 THEN 'PO_DISTRIBUTION_ID'
WHEN 6 THEN 'APPLIED_TO_PO_DOC_ID'
WHEN 7 THEN 'DISTRIBUTION_TYPE'
WHEN 8 THEN 'ENCUM_REVERSAL_AMOUNT_ENTERED'
WHEN 9 THEN 'CURRENCY_CODE'
WHEN 10 THEN 'ENCUMBRANCE_REVERSAL_AMOUNT'
WHEN 11 THEN 'CST_ENCUM_UPG_OPTION'
WHEN 12 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 13 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 14 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 15 THEN 'PURCH_ENCUMBRANCE_TYPE_ID'
WHEN 16 THEN 'PARENT_TRANSACTION_ID'
WHEN 17 THEN 'TRANSFER_TO_GL_INDICATOR'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.PO_BUDGET_ACCOUNT)
WHEN 2 THEN TO_CHAR(h3.APPLIED_TO_APPL_ID)
WHEN 3 THEN TO_CHAR(h3.APPLIED_TO_DIST_LINK_TYPE)
WHEN 4 THEN TO_CHAR(h3.APPLIED_TO_ENTITY_CODE)
WHEN 5 THEN TO_CHAR(h3.PO_DISTRIBUTION_ID)
WHEN 6 THEN TO_CHAR(h3.APPLIED_TO_PO_DOC_ID)
WHEN 7 THEN TO_CHAR(h1.DISTRIBUTION_TYPE)
WHEN 8 THEN TO_CHAR(h3.ENCUM_REVERSAL_AMOUNT_ENTERED)
WHEN 9 THEN TO_CHAR(h1.CURRENCY_CODE)
WHEN 10 THEN TO_CHAR(h3.ENCUMBRANCE_REVERSAL_AMOUNT)
WHEN 11 THEN TO_CHAR(h7.CST_ENCUM_UPG_OPTION)
WHEN 12 THEN TO_CHAR(h1.CURRENCY_CONVERSION_DATE)
WHEN 13 THEN TO_CHAR(h1.CURRENCY_CONVERSION_RATE)
WHEN 14 THEN TO_CHAR(h1.CURRENCY_CONVERSION_TYPE)
WHEN 15 THEN TO_CHAR(h6.PURCH_ENCUMBRANCE_TYPE_ID)
WHEN 16 THEN TO_CHAR(h3.PARENT_TRANSACTION_ID)
WHEN 17 THEN TO_CHAR(h1.TRANSFER_TO_GL_INDICATOR)
ELSE null
END source_value
, CASE r
WHEN 7 THEN fvl13.meaning
WHEN 17 THEN fvl36.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, CST_XLA_RCV_HEADERS_V h1
, CST_XLA_RCV_REF_V h3
, PO_DISTS_REF_V h5
, PO_HEADERS_REF_V h6
, PSA_CST_XLA_UPG_V h7
, fnd_lookup_values fvl13
, fnd_lookup_values fvl36
,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h3.ref_rcv_accounting_event_id = h1.rcv_accounting_event_id AND h3.po_header_id = h5.po_header_id (+) and h3.po_distribution_id = h5.po_distribution_id (+) AND h3.po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'
AND fvl13.lookup_code(+) = h1.DISTRIBUTION_TYPE
AND fvl13.view_application_id(+) = 700
AND fvl13.language(+) = USERENV('LANG')
AND fvl36.lookup_type(+) = 'YES_NO'
AND fvl36.lookup_code(+) = h1.TRANSFER_TO_GL_INDICATOR
AND fvl36.view_application_id(+) = 0
AND fvl36.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'FV_XLA_CST_REF_V'
WHEN 2 THEN 'FV_XLA_CST_REF_V'
WHEN 3 THEN 'FV_XLA_CST_REF_V'
WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
WHEN 6 THEN 'FV_XLA_CST_REF_V'
WHEN 7 THEN 'FV_XLA_CST_REF_V'
WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
WHEN 10 THEN 'FV_XLA_CST_REF_V'
WHEN 11 THEN 'FV_XLA_CST_REF_V'
WHEN 12 THEN 'FV_XLA_CST_REF_V'
WHEN 13 THEN 'FV_XLA_CST_REF_V'
WHEN 14 THEN 'FV_XLA_CST_REF_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '707'
WHEN 5 THEN '707'
WHEN 6 THEN '8901'
WHEN 7 THEN '8901'
WHEN 8 THEN '707'
WHEN 9 THEN '707'
WHEN 10 THEN '8901'
WHEN 11 THEN '8901'
WHEN 12 THEN '8901'
WHEN 13 THEN '8901'
WHEN 14 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 4 THEN 'RCV_ACCOUNTING_LINE_TYPE'
WHEN 5 THEN 'DISTRIBUTION_IDENTIFIER'
WHEN 6 THEN 'FEDERAL_ANTICIPATED_AMT'
WHEN 7 THEN 'FEDERAL_UNANTICIPATED_AMT'
WHEN 8 THEN 'ENTERED_AMOUNT'
WHEN 9 THEN 'ACCOUNTED_AMOUNT'
WHEN 10 THEN 'FEDERAL_NET_PYA_ADJ_AMT'
WHEN 11 THEN 'FEDERAL_PAID_UNEXP_OBG_AMT'
WHEN 12 THEN 'FEDERAL_UNPAID_UNEXP_OBG_AMT'
WHEN 13 THEN 'FEDERAL_RCV_SUB_LEDGER_ID'
WHEN 14 THEN 'FEDERAL_UNEXP_OBG_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 2 THEN TO_CHAR(l4.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l4.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 4 THEN TO_CHAR(l2.RCV_ACCOUNTING_LINE_TYPE)
WHEN 5 THEN TO_CHAR(l2.DISTRIBUTION_IDENTIFIER)
WHEN 6 THEN TO_CHAR(l4.FEDERAL_ANTICIPATED_AMT)
WHEN 7 THEN TO_CHAR(l4.FEDERAL_UNANTICIPATED_AMT)
WHEN 8 THEN TO_CHAR(l2.ENTERED_AMOUNT)
WHEN 9 THEN TO_CHAR(l2.ACCOUNTED_AMOUNT)
WHEN 10 THEN TO_CHAR(l4.FEDERAL_NET_PYA_ADJ_AMT)
WHEN 11 THEN TO_CHAR(l4.FEDERAL_PAID_UNEXP_OBG_AMT)
WHEN 12 THEN TO_CHAR(l4.FEDERAL_UNPAID_UNEXP_OBG_AMT)
WHEN 13 THEN TO_CHAR(l4.FEDERAL_RCV_SUB_LEDGER_ID)
WHEN 14 THEN TO_CHAR(l4.FEDERAL_UNEXP_OBG_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, CST_XLA_RCV_LINES_V l2
, FV_XLA_CST_REF_V l4
, (select rownum r from all_objects where rownum <= 14 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 l4.federal_event_id = l2.event_id and l4.federal_line_number=l2.line_number
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_53'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00707_AAD_S_000007_BC_PKG.insert_sources_53');
END insert_sources_53;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DELIVER_EXPENSE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.PO_BUDGET_ACCOUNT source_3
, h3.APPLIED_TO_APPL_ID source_7
, h3.APPLIED_TO_DIST_LINK_TYPE source_8
, h3.APPLIED_TO_ENTITY_CODE source_9
, h3.PO_DISTRIBUTION_ID source_10
, h3.APPLIED_TO_PO_DOC_ID source_11
, h1.DISTRIBUTION_TYPE source_13
, fvl13.meaning source_13_meaning
, h3.ENCUM_REVERSAL_AMOUNT_ENTERED source_14
, h1.CURRENCY_CODE source_15
, h3.ENCUMBRANCE_REVERSAL_AMOUNT source_16
, h7.CST_ENCUM_UPG_OPTION source_17
, h1.CURRENCY_CONVERSION_DATE source_19
, h1.CURRENCY_CONVERSION_RATE source_20
, h1.CURRENCY_CONVERSION_TYPE source_21
, h6.PURCH_ENCUMBRANCE_TYPE_ID source_22
, h3.PARENT_TRANSACTION_ID source_33
, h1.TRANSFER_TO_GL_INDICATOR source_36
, fvl36.meaning source_36_meaning
FROM xla_events_gt xet
, CST_XLA_RCV_HEADERS_V h1
, CST_XLA_RCV_REF_V h3
, PO_DISTS_REF_V h5
, PO_HEADERS_REF_V h6
, PSA_CST_XLA_UPG_V h7
, fnd_lookup_values fvl13
, fnd_lookup_values fvl36
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h5.po_header_id (+) AND h3.po_distribution_id = h5.po_distribution_id (+) AND h3.po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'
AND fvl13.lookup_code(+) = h1.DISTRIBUTION_TYPE
AND fvl13.view_application_id(+) = 700
AND fvl13.language(+) = USERENV('LANG')
AND fvl36.lookup_type(+) = 'YES_NO'
AND fvl36.lookup_code(+) = h1.TRANSFER_TO_GL_INDICATOR
AND fvl36.view_application_id(+) = 0
AND fvl36.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: DELIVER_EXPENSE
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
, l4.FEDERAL_FUND_EXPIRED_STATUS source_1
, l4.FEDERAL_FUND_CATEGORY source_2
, l4.FEDERAL_PRIOR_YEAR_FLAG source_5
, l2.RCV_ACCOUNTING_LINE_TYPE source_6
, l2.DISTRIBUTION_IDENTIFIER source_12
, l4.FEDERAL_ANTICIPATED_AMT source_18
, l4.FEDERAL_UNANTICIPATED_AMT source_24
, l2.ENTERED_AMOUNT source_25
, l2.ACCOUNTED_AMOUNT source_26
, l4.FEDERAL_NET_PYA_ADJ_AMT source_27
, l4.FEDERAL_PAID_UNEXP_OBG_AMT source_28
, l4.FEDERAL_UNPAID_UNEXP_OBG_AMT source_29
, l4.FEDERAL_RCV_SUB_LEDGER_ID source_32
, l4.FEDERAL_UNEXP_OBG_AMT source_34
FROM xla_events_gt xet
, CST_XLA_RCV_LINES_V l2
, FV_XLA_CST_REF_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l4.federal_event_id = l2.event_id AND l4.federal_line_number=l2.line_number;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
PROCEDURE insert_sources_54(
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) := 'PURCHASE_ORDER_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_54';
(p_msg => 'BEGIN of insert_sources_54'
,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_DISTS_REF_V'
WHEN 2 THEN 'CST_XLA_INV_REF_V'
WHEN 3 THEN 'CST_XLA_INV_REF_V'
WHEN 4 THEN 'CST_XLA_INV_REF_V'
WHEN 5 THEN 'CST_XLA_INV_REF_V'
WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
WHEN 7 THEN 'CST_XLA_INV_REF_V'
WHEN 8 THEN 'CST_XLA_INV_REF_V'
WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
WHEN 10 THEN 'PO_HEADERS_REF_V'
WHEN 11 THEN 'CST_XLA_INV_REF_V'
WHEN 12 THEN 'CST_XLA_INV_REF_V'
WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
WHEN 10 THEN 'HEADER'
WHEN 11 THEN 'HEADER'
WHEN 12 THEN 'HEADER'
WHEN 13 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '201'
WHEN 2 THEN '707'
WHEN 3 THEN '707'
WHEN 4 THEN '707'
WHEN 5 THEN '707'
WHEN 6 THEN '707'
WHEN 7 THEN '707'
WHEN 8 THEN '707'
WHEN 9 THEN '707'
WHEN 10 THEN '201'
WHEN 11 THEN '707'
WHEN 12 THEN '707'
WHEN 13 THEN '707'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'PO_BUDGET_ACCOUNT'
WHEN 2 THEN 'APPLIED_TO_APPL_ID'
WHEN 3 THEN 'APPLIED_TO_DIST_LINK_TYPE'
WHEN 4 THEN 'APPLIED_TO_ENTITY_CODE'
WHEN 5 THEN 'APPLIED_TO_PO_DOC_ID'
WHEN 6 THEN 'DISTRIBUTION_TYPE'
WHEN 7 THEN 'ENCUM_REVERSAL_AMOUNT_ENTERED'
WHEN 8 THEN 'ENCUMBRANCE_REVERSAL_AMOUNT'
WHEN 9 THEN 'CST_ENCUM_UPG_OPTION'
WHEN 10 THEN 'PURCH_ENCUMBRANCE_TYPE_ID'
WHEN 11 THEN 'TXN_PO_DISTRIBUTION_ID'
WHEN 12 THEN 'PARENT_TRANSACTION_ID'
WHEN 13 THEN 'TRANSFER_TO_GL_INDICATOR'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h5.PO_BUDGET_ACCOUNT)
WHEN 2 THEN TO_CHAR(h3.APPLIED_TO_APPL_ID)
WHEN 3 THEN TO_CHAR(h3.APPLIED_TO_DIST_LINK_TYPE)
WHEN 4 THEN TO_CHAR(h3.APPLIED_TO_ENTITY_CODE)
WHEN 5 THEN TO_CHAR(h3.APPLIED_TO_PO_DOC_ID)
WHEN 6 THEN TO_CHAR(h1.DISTRIBUTION_TYPE)
WHEN 7 THEN TO_CHAR(h3.ENCUM_REVERSAL_AMOUNT_ENTERED)
WHEN 8 THEN TO_CHAR(h3.ENCUMBRANCE_REVERSAL_AMOUNT)
WHEN 9 THEN TO_CHAR(h7.CST_ENCUM_UPG_OPTION)
WHEN 10 THEN TO_CHAR(h6.PURCH_ENCUMBRANCE_TYPE_ID)
WHEN 11 THEN TO_CHAR(h3.TXN_PO_DISTRIBUTION_ID)
WHEN 12 THEN TO_CHAR(h3.PARENT_TRANSACTION_ID)
WHEN 13 THEN TO_CHAR(h1.TRANSFER_TO_GL_INDICATOR)
ELSE null
END source_value
, CASE r
WHEN 6 THEN fvl13.meaning
WHEN 13 THEN fvl36.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, CST_XLA_INV_HEADERS_V h1
, CST_XLA_INV_REF_V h3
, PO_DISTS_REF_V h5
, PO_HEADERS_REF_V h6
, PSA_CST_XLA_UPG_V h7
, fnd_lookup_values fvl13
, fnd_lookup_values fvl36
,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h5.po_header_id (+) and h3.txn_po_distribution_id = h5.po_distribution_id (+) AND h3.txn_po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'
AND fvl13.lookup_code(+) = h1.DISTRIBUTION_TYPE
AND fvl13.view_application_id(+) = 700
AND fvl13.language(+) = USERENV('LANG')
AND fvl36.lookup_type(+) = 'YES_NO'
AND fvl36.lookup_code(+) = h1.TRANSFER_TO_GL_INDICATOR
AND fvl36.view_application_id(+) = 0
AND fvl36.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'FV_XLA_CST_REF_V'
WHEN 2 THEN 'FV_XLA_CST_REF_V'
WHEN 3 THEN 'FV_XLA_CST_REF_V'
WHEN 4 THEN 'CST_XLA_INV_LINES_V'
WHEN 5 THEN 'CST_XLA_INV_LINES_V'
WHEN 6 THEN 'FV_XLA_CST_REF_V'
WHEN 7 THEN 'CST_XLA_INV_LINES_V'
WHEN 8 THEN 'CST_XLA_INV_LINES_V'
WHEN 9 THEN 'CST_XLA_INV_LINES_V'
WHEN 10 THEN 'FV_XLA_CST_REF_V'
WHEN 11 THEN 'CST_XLA_INV_LINES_V'
WHEN 12 THEN 'CST_XLA_INV_LINES_V'
WHEN 13 THEN 'FV_XLA_CST_REF_V'
WHEN 14 THEN 'FV_XLA_CST_REF_V'
WHEN 15 THEN 'FV_XLA_CST_REF_V'
WHEN 16 THEN 'FV_XLA_CST_REF_V'
WHEN 17 THEN 'FV_XLA_CST_REF_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '707'
WHEN 5 THEN '707'
WHEN 6 THEN '8901'
WHEN 7 THEN '707'
WHEN 8 THEN '707'
WHEN 9 THEN '707'
WHEN 10 THEN '8901'
WHEN 11 THEN '707'
WHEN 12 THEN '707'
WHEN 13 THEN '8901'
WHEN 14 THEN '8901'
WHEN 15 THEN '8901'
WHEN 16 THEN '8901'
WHEN 17 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'FEDERAL_FUND_EXPIRED_STATUS'
WHEN 2 THEN 'FEDERAL_FUND_CATEGORY'
WHEN 3 THEN 'FEDERAL_PRIOR_YEAR_FLAG'
WHEN 4 THEN 'DISTRIBUTION_IDENTIFIER'
WHEN 5 THEN 'CURRENCY_CODE'
WHEN 6 THEN 'FEDERAL_ANTICIPATED_AMT'
WHEN 7 THEN 'CURRENCY_CONVERSION_DATE'
WHEN 8 THEN 'CURRENCY_CONVERSION_RATE'
WHEN 9 THEN 'CURRENCY_CONVERSION_TYPE'
WHEN 10 THEN 'FEDERAL_UNANTICIPATED_AMT'
WHEN 11 THEN 'ENTERED_AMOUNT'
WHEN 12 THEN 'ACCOUNTED_AMOUNT'
WHEN 13 THEN 'FEDERAL_NET_PYA_ADJ_AMT'
WHEN 14 THEN 'FEDERAL_PAID_UNEXP_OBG_AMT'
WHEN 15 THEN 'FEDERAL_UNPAID_UNEXP_OBG_AMT'
WHEN 16 THEN 'FEDERAL_RCV_SUB_LEDGER_ID'
WHEN 17 THEN 'FEDERAL_UNEXP_OBG_AMT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l4.FEDERAL_FUND_EXPIRED_STATUS)
WHEN 2 THEN TO_CHAR(l4.FEDERAL_FUND_CATEGORY)
WHEN 3 THEN TO_CHAR(l4.FEDERAL_PRIOR_YEAR_FLAG)
WHEN 4 THEN TO_CHAR(l2.DISTRIBUTION_IDENTIFIER)
WHEN 5 THEN TO_CHAR(l2.CURRENCY_CODE)
WHEN 6 THEN TO_CHAR(l4.FEDERAL_ANTICIPATED_AMT)
WHEN 7 THEN TO_CHAR(l2.CURRENCY_CONVERSION_DATE)
WHEN 8 THEN TO_CHAR(l2.CURRENCY_CONVERSION_RATE)
WHEN 9 THEN TO_CHAR(l2.CURRENCY_CONVERSION_TYPE)
WHEN 10 THEN TO_CHAR(l4.FEDERAL_UNANTICIPATED_AMT)
WHEN 11 THEN TO_CHAR(l2.ENTERED_AMOUNT)
WHEN 12 THEN TO_CHAR(l2.ACCOUNTED_AMOUNT)
WHEN 13 THEN TO_CHAR(l4.FEDERAL_NET_PYA_ADJ_AMT)
WHEN 14 THEN TO_CHAR(l4.FEDERAL_PAID_UNEXP_OBG_AMT)
WHEN 15 THEN TO_CHAR(l4.FEDERAL_UNPAID_UNEXP_OBG_AMT)
WHEN 16 THEN TO_CHAR(l4.FEDERAL_RCV_SUB_LEDGER_ID)
WHEN 17 THEN TO_CHAR(l4.FEDERAL_UNEXP_OBG_AMT)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, CST_XLA_INV_LINES_V l2
, FV_XLA_CST_REF_V l4
, (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND l2.event_id = xet.event_id
AND l4.federal_event_id (+) = l2.event_id and l4.federal_line_number (+) =l2.line_number
)
;
(p_msg => 'number of line sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
(p_msg => 'END of insert_sources_54'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00707_AAD_S_000007_BC_PKG.insert_sources_54');
END insert_sources_54;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PURCHASE_ORDER
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h5.PO_BUDGET_ACCOUNT source_3
, h3.APPLIED_TO_APPL_ID source_7
, h3.APPLIED_TO_DIST_LINK_TYPE source_8
, h3.APPLIED_TO_ENTITY_CODE source_9
, h3.APPLIED_TO_PO_DOC_ID source_11
, h1.DISTRIBUTION_TYPE source_13
, fvl13.meaning source_13_meaning
, h3.ENCUM_REVERSAL_AMOUNT_ENTERED source_14
, h3.ENCUMBRANCE_REVERSAL_AMOUNT source_16
, h7.CST_ENCUM_UPG_OPTION source_17
, h6.PURCH_ENCUMBRANCE_TYPE_ID source_22
, h3.TXN_PO_DISTRIBUTION_ID source_23
, h3.PARENT_TRANSACTION_ID source_33
, h1.TRANSFER_TO_GL_INDICATOR source_36
, fvl36.meaning source_36_meaning
FROM xla_events_gt xet
, CST_XLA_INV_HEADERS_V h1
, CST_XLA_INV_REF_V h3
, PO_DISTS_REF_V h5
, PO_HEADERS_REF_V h6
, PSA_CST_XLA_UPG_V h7
, fnd_lookup_values fvl13
, fnd_lookup_values fvl36
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h5.po_header_id (+) AND h3.txn_po_distribution_id = h5.po_distribution_id (+) AND h3.txn_po_header_id = h6.po_header_id (+) AND h3.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'
AND fvl13.lookup_code(+) = h1.DISTRIBUTION_TYPE
AND fvl13.view_application_id(+) = 700
AND fvl13.language(+) = USERENV('LANG')
AND fvl36.lookup_type(+) = 'YES_NO'
AND fvl36.lookup_code(+) = h1.TRANSFER_TO_GL_INDICATOR
AND fvl36.view_application_id(+) = 0
AND fvl36.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PURCHASE_ORDER
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
, l4.FEDERAL_FUND_EXPIRED_STATUS source_1
, l4.FEDERAL_FUND_CATEGORY source_2
, l4.FEDERAL_PRIOR_YEAR_FLAG source_5
, l2.DISTRIBUTION_IDENTIFIER source_12
, l2.CURRENCY_CODE source_15
, l4.FEDERAL_ANTICIPATED_AMT source_18
, l2.CURRENCY_CONVERSION_DATE source_19
, l2.CURRENCY_CONVERSION_RATE source_20
, l2.CURRENCY_CONVERSION_TYPE source_21
, l4.FEDERAL_UNANTICIPATED_AMT source_24
, l2.ENTERED_AMOUNT source_25
, l2.ACCOUNTED_AMOUNT source_26
, l4.FEDERAL_NET_PYA_ADJ_AMT source_27
, l4.FEDERAL_PAID_UNEXP_OBG_AMT source_28
, l4.FEDERAL_UNPAID_UNEXP_OBG_AMT source_29
, l4.FEDERAL_RCV_SUB_LEDGER_ID source_32
, l4.FEDERAL_UNEXP_OBG_AMT source_34
FROM xla_events_gt xet
, CST_XLA_INV_LINES_V l2
, FV_XLA_CST_REF_V l4
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
AND l4.federal_event_id (+) = l2.event_id AND l4.federal_line_number (+) =l2.line_number;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
l_result := XLA_AE_LINES_PKG.InsertLines;
l_result := XLA_AE_LINES_PKG.InsertLines ;
l_result := XLA_AE_HEADER_PKG.InsertHeaders ;
insert_sources_53(
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_54(
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
);