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);
PROCEDURE insert_sources_32(
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) := 'ACCRUAL_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_32';
(p_msg => 'BEGIN of insert_sources_32'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_SHR_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 9 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
WHEN 9 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
WHEN 9 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'TCN_ACCRUAL_REVERSAL_DATE'
WHEN 8 THEN 'GL_DATE'
WHEN 9 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h3.TCN_ACCRUAL_REVERSAL_DATE)
WHEN 8 THEN TO_CHAR(h1.GL_DATE)
WHEN 9 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
, OKL_SHR_EXTRACT_HDR_V h3
,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
AND h3.tcn_id (+) = h1.tcn_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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_32'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_32');
END insert_sources_32;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ACCRUAL
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h3.TCN_ACCRUAL_REVERSAL_DATE source_14
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
, OKL_SHR_EXTRACT_HDR_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 h1.event_id = xet.event_id
AND h3.TCN_ID (+) = h1.TCN_ID
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ACCRUAL
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.language(+) = USERENV('LANG')
;
g_array_event.DELETE;
XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
XLA_AE_JOURNAL_ENTRY_PKG.updateJournalEntryStatus (p_hdr_idx => g_last_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_33(
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) := 'ASSET_DISPOSITION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_33';
(p_msg => 'BEGIN of insert_sources_33'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_33'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_33');
END insert_sources_33;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ASSET_DISPOSITION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: ASSET_DISPOSITION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_34(
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) := 'BOOKING_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_34';
(p_msg => 'BEGIN of insert_sources_34'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_34'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_34');
END insert_sources_34;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BOOKING
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BOOKING
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_35(
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) := 'EVERGREEN_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_35';
(p_msg => 'BEGIN of insert_sources_35'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_35'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_35');
END insert_sources_35;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: EVERGREEN
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: EVERGREEN
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_36(
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) := 'GENERAL_LOSS_PROVISION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_36';
(p_msg => 'BEGIN of insert_sources_36'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_36'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_36');
END insert_sources_36;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GENERAL_LOSS_PROVISION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: GENERAL_LOSS_PROVISION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_37(
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) := 'INVESTOR_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_37';
(p_msg => 'BEGIN of insert_sources_37'
,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 'OKL_IA_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_IA_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_IA_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_INV_AGRMNT_NUMBER'
WHEN 2 THEN 'TCN_INV_AGRMNT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h2.TEH_INV_AGRMNT_NUMBER)
WHEN 2 THEN TO_CHAR(h2.TCN_INV_AGRMNT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h2.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h2.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h2.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h2.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h2.GL_DATE)
WHEN 8 THEN TO_CHAR(h2.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_IA_EXTRACT_HDR_V h2
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND 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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l1.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l1.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l1.DIST_ID)
WHEN 4 THEN TO_CHAR(l1.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l1.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l1
, fnd_lookup_values fvl6
, (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 l1.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l1.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_37'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_37');
END insert_sources_37;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: INVESTOR
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.TEH_INV_AGRMNT_NUMBER source_3
, h2.TCN_INV_AGRMNT_PRODUCT_NAME source_4
, h2.TCN_CURRENCY_CODE source_10
, h2.TCN_CURR_CONVERSION_DATE source_11
, h2.TCN_CURR_CONVERSION_RATE source_12
, h2.TCN_CURR_CONVERSION_TYPE source_13
, h2.GL_DATE source_15
, h2.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_IA_EXTRACT_HDR_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: INVESTOR
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.DIST_CODE_COMBINATION_ID source_5
, l1.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l1.DIST_ID source_7
, l1.DIST_TYPE source_8
, l1.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l1
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l1.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_38(
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) := 'PRINCIPAL_ADJUSTMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_38';
(p_msg => 'BEGIN of insert_sources_38'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_38'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_38');
END insert_sources_38;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PRINCIPAL_ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: PRINCIPAL_ADJUSTMENT
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_39(
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) := 'REBOOK_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_39';
(p_msg => 'BEGIN of insert_sources_39'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_39'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_39');
END insert_sources_39;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REBOOK
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: REBOOK
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_40(
p_target_ledger_id IN NUMBER
, p_language IN VARCHAR2
, p_sla_ledger_id IN NUMBER
, p_pad_start_date IN DATE
, p_pad_end_date IN DATE
)
IS
C_EVENT_TYPE_CODE CONSTANT VARCHAR2(30) := 'RECEIPT_APPLICATION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_40';
(p_msg => 'BEGIN of insert_sources_40'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_40'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_40');
END insert_sources_40;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT_APPLICATION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RECEIPT_APPLICATION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_41(
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) := 'RE_LEASE_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_41';
(p_msg => 'BEGIN of insert_sources_41'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_41'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_41');
END insert_sources_41;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RE_LEASE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RE_LEASE
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_42(
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) := 'SPECIFIC_LOSS_PROVISION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_42';
(p_msg => 'BEGIN of insert_sources_42'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_42'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_42');
END insert_sources_42;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: SPECIFIC_LOSS_PROVISION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: SPECIFIC_LOSS_PROVISION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_43(
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) := 'SPLIT_ASSET_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_43';
(p_msg => 'BEGIN of insert_sources_43'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_43'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_43');
END insert_sources_43;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: SPLIT_ASSET
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: SPLIT_ASSET
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_44(
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) := 'TERMINATION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_44';
(p_msg => 'BEGIN of insert_sources_44'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_44'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_44');
END insert_sources_44;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: TERMINATION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: TERMINATION
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_45(
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) := 'UPFRONT_TAX_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_45';
(p_msg => 'BEGIN of insert_sources_45'
,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 'OKL_CMN_EXTRACT_HDR_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 6 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 7 THEN 'OKL_CMN_EXTRACT_HDR_V'
WHEN 8 THEN 'OKL_CMN_EXTRACT_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
WHEN 4 THEN 'HEADER'
WHEN 5 THEN 'HEADER'
WHEN 6 THEN 'HEADER'
WHEN 7 THEN 'HEADER'
WHEN 8 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
WHEN 6 THEN '540'
WHEN 7 THEN '540'
WHEN 8 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'TEH_CONTRACT_NUMBER'
WHEN 2 THEN 'TCN_CONTRACT_PRODUCT_NAME'
WHEN 3 THEN 'TCN_CURRENCY_CODE'
WHEN 4 THEN 'TCN_CURR_CONVERSION_DATE'
WHEN 5 THEN 'TCN_CURR_CONVERSION_RATE'
WHEN 6 THEN 'TCN_CURR_CONVERSION_TYPE'
WHEN 7 THEN 'GL_DATE'
WHEN 8 THEN 'TCN_ACCOUNTING_REVERSAL_FLAG'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.TEH_CONTRACT_NUMBER)
WHEN 2 THEN TO_CHAR(h1.TCN_CONTRACT_PRODUCT_NAME)
WHEN 3 THEN TO_CHAR(h1.TCN_CURRENCY_CODE)
WHEN 4 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_DATE)
WHEN 5 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_RATE)
WHEN 6 THEN TO_CHAR(h1.TCN_CURR_CONVERSION_TYPE)
WHEN 7 THEN TO_CHAR(h1.GL_DATE)
WHEN 8 THEN TO_CHAR(h1.TCN_ACCOUNTING_REVERSAL_FLAG)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h1.event_id = xet.event_id
)
;
(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 'OKL_CMN_EXTRACT_LINE_V'
WHEN 2 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 3 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 4 THEN 'OKL_CMN_EXTRACT_LINE_V'
WHEN 5 THEN 'OKL_CMN_EXTRACT_LINE_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'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '540'
WHEN 2 THEN '540'
WHEN 3 THEN '540'
WHEN 4 THEN '540'
WHEN 5 THEN '540'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'DIST_CODE_COMBINATION_ID'
WHEN 2 THEN 'DIST_AE_LINE_TYPE_CODE'
WHEN 3 THEN 'DIST_ID'
WHEN 4 THEN 'DIST_TYPE'
WHEN 5 THEN 'DIST_ENTERED_AMOUNT'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.DIST_CODE_COMBINATION_ID)
WHEN 2 THEN TO_CHAR(l2.DIST_AE_LINE_TYPE_CODE)
WHEN 3 THEN TO_CHAR(l2.DIST_ID)
WHEN 4 THEN TO_CHAR(l2.DIST_TYPE)
WHEN 5 THEN TO_CHAR(l2.DIST_ENTERED_AMOUNT)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl6.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
, (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 l2.event_id = xet.event_id
AND fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_45'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_00540_AAD_S_000014_PKG.insert_sources_45');
END insert_sources_45;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: UPFRONT_TAX
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, h1.TEH_CONTRACT_NUMBER source_1
, h1.TCN_CONTRACT_PRODUCT_NAME source_2
, h1.TCN_CURRENCY_CODE source_10
, h1.TCN_CURR_CONVERSION_DATE source_11
, h1.TCN_CURR_CONVERSION_RATE source_12
, h1.TCN_CURR_CONVERSION_TYPE source_13
, h1.GL_DATE source_15
, h1.TCN_ACCOUNTING_REVERSAL_FLAG source_16
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_HDR_V h1
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
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: UPFRONT_TAX
xet.entity_id
,xet.legal_entity_id
,xet.entity_code
,xet.transaction_number
,xet.event_id
,xet.event_class_code
,xet.event_type_code
,xet.event_number
,xet.event_date
,xet.transaction_date
,xet.reference_num_1
,xet.reference_num_2
,xet.reference_num_3
,xet.reference_num_4
,xet.reference_char_1
,xet.reference_char_2
,xet.reference_char_3
,xet.reference_char_4
,xet.reference_date_1
,xet.reference_date_2
,xet.reference_date_3
,xet.reference_date_4
,xet.event_created_by
,xet.budgetary_control_flag
, l2.LINE_NUMBER
, l2.DIST_CODE_COMBINATION_ID source_5
, l2.DIST_AE_LINE_TYPE_CODE source_6
, fvl6.meaning source_6_meaning
, l2.DIST_ID source_7
, l2.DIST_TYPE source_8
, l2.DIST_ENTERED_AMOUNT source_9
FROM xla_events_gt xet
, OKL_CMN_EXTRACT_LINE_V l2
, fnd_lookup_values fvl6
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 fvl6.lookup_type(+) = 'OKL_ACCOUNTING_LINE_TYPE'
AND fvl6.lookup_code(+) = l2.DIST_AE_LINE_TYPE_CODE
AND fvl6.view_application_id(+) = 0
AND fvl6.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_32(
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_33(
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_34(
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_35(
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_36(
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_37(
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_38(
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_39(
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_40(
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_41(
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_42(
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_43(
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_44(
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_45(
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
);