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);
PROCEDURE insert_sources_17(
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) := 'BUDGET_EXECUTION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_17';
(p_msg => 'BEGIN of insert_sources_17'
,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 'FV_BE_BA_FD_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_BE_BA_FD_HDR_V h1
,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND 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);
(p_msg => 'END of insert_sources_17'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_08901_AAD_S_000002_PKG.insert_sources_17');
END insert_sources_17;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: BUDGET_EXECUTION
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.GL_DATE source_25
FROM xla_events_gt xet
, FV_BE_BA_FD_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: BUDGET_EXECUTION
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
, 0
FROM xla_events_gt xet
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' ;
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_18(
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) := 'RPR_BUDGET_EXECUTION_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_18';
(p_msg => 'BEGIN of insert_sources_18'
,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 'FV_BE_RPR_HDR_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'GL_DATE'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.GL_DATE)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_BE_RPR_HDR_V h1
,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND 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);
(p_msg => 'END of insert_sources_18'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_08901_AAD_S_000002_PKG.insert_sources_18');
END insert_sources_18;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: RPR_BUDGET_EXECUTION
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.GL_DATE source_25
FROM xla_events_gt xet
, FV_BE_RPR_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: RPR_BUDGET_EXECUTION
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
, 0
FROM xla_events_gt xet
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' ;
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_19(
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) := 'TREASURY_ACCOMPLISHMENT_ALL';
l_log_module := C_DEFAULT_MODULE||'.insert_sources_19';
(p_msg => 'BEGIN of insert_sources_19'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
SELECT oracle_username
INTO p_apps_owner
FROM fnd_oracle_userid
WHERE read_only_flag = 'U'
;
INSERT INTO xla_diag_sources --hdr2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT
event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value ,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, 0 line_number
, CASE r
WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
WHEN 3 THEN 'FV_TREASURY_EXTRACT_HEADER_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'HEADER'
WHEN 2 THEN 'HEADER'
WHEN 3 THEN 'HEADER'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '200'
WHEN 2 THEN '200'
WHEN 3 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'ASP_WHEN_TO_ACCOUNT_PMT'
WHEN 2 THEN 'ASP_AUTOMATIC_OFFSETS_VALUE'
WHEN 3 THEN 'TREASURY_CONFIRMATION_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(h1.ASP_WHEN_TO_ACCOUNT_PMT)
WHEN 2 THEN TO_CHAR(h1.ASP_AUTOMATIC_OFFSETS_VALUE)
WHEN 3 THEN TO_CHAR(h3.TREASURY_CONFIRMATION_ID)
ELSE null
END source_value
, CASE r
WHEN 2 THEN fvl9.meaning
ELSE null
END source_meaning
FROM xla_events_gt xet
, AP_SYSTEM_PARAMETERS_EXTRACT_V h1
, FV_TREASURY_EXTRACT_HEADER_V h3
, fnd_lookup_values fvl9
,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
AND xet.event_class_code = C_EVENT_CLASS_CODE
AND h3.event_id = xet.event_id
AND h3.org_id = h1.asp_org_id AND fvl9.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl9.lookup_code(+) = h1.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl9.view_application_id(+) = 200
AND fvl9.language(+) = USERENV('LANG')
)
;
(p_msg => 'number of header sources inserted = '||SQL%ROWCOUNT
,p_level => C_LEVEL_STATEMENT
,p_module => l_log_module);
INSERT INTO xla_diag_sources --line2
(
event_id
, ledger_id
, sla_ledger_id
, description_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, source_value
, source_meaning
, created_by
, creation_date
, last_update_date
, last_updated_by
, last_update_login
, program_update_date
, program_application_id
, program_id
, request_id
)
SELECT event_id
, p_target_ledger_id
, p_sla_ledger_id
, p_language
, object_name
, object_type_code
, line_number
, source_application_id
, source_type_code
, source_code
, SUBSTR(source_value,1,1996)
, SUBSTR(source_meaning ,1,200)
, xla_environment_pkg.g_Usr_Id
, TRUNC(SYSDATE)
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Usr_Id
, xla_environment_pkg.g_Login_Id
, TRUNC(SYSDATE)
, xla_environment_pkg.g_Prog_Appl_Id
, xla_environment_pkg.g_Prog_Id
, xla_environment_pkg.g_Req_Id
FROM (
SELECT xet.event_id event_id
, l2.line_number line_number
, CASE r
WHEN 1 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 2 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 3 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 4 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 5 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 6 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 7 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 8 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 9 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 10 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 11 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 12 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 13 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 14 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 15 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 16 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 17 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 18 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 19 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
WHEN 20 THEN 'FV_TREASURY_EXTRACT_DETAILS_V'
ELSE null
END object_name
, CASE r
WHEN 1 THEN 'LINE'
WHEN 2 THEN 'LINE'
WHEN 3 THEN 'LINE'
WHEN 4 THEN 'LINE'
WHEN 5 THEN 'LINE'
WHEN 6 THEN 'LINE'
WHEN 7 THEN 'LINE'
WHEN 8 THEN 'LINE'
WHEN 9 THEN 'LINE'
WHEN 10 THEN 'LINE'
WHEN 11 THEN 'LINE'
WHEN 12 THEN 'LINE'
WHEN 13 THEN 'LINE'
WHEN 14 THEN 'LINE'
WHEN 15 THEN 'LINE'
WHEN 16 THEN 'LINE'
WHEN 17 THEN 'LINE'
WHEN 18 THEN 'LINE'
WHEN 19 THEN 'LINE'
WHEN 20 THEN 'LINE'
ELSE null
END object_type_code
, CASE r
WHEN 1 THEN '8901'
WHEN 2 THEN '8901'
WHEN 3 THEN '8901'
WHEN 4 THEN '8901'
WHEN 5 THEN '8901'
WHEN 6 THEN '8901'
WHEN 7 THEN '8901'
WHEN 8 THEN '8901'
WHEN 9 THEN '8901'
WHEN 10 THEN '8901'
WHEN 11 THEN '8901'
WHEN 12 THEN '8901'
WHEN 13 THEN '8901'
WHEN 14 THEN '8901'
WHEN 15 THEN '8901'
WHEN 16 THEN '8901'
WHEN 17 THEN '8901'
WHEN 18 THEN '8901'
WHEN 19 THEN '8901'
WHEN 20 THEN '8901'
ELSE null
END source_application_id
, 'S' source_type_code
, CASE r
WHEN 1 THEN 'FV_CHECK_NUMBER'
WHEN 2 THEN 'FV_CHECK_DATE'
WHEN 3 THEN 'FV_TREASURY_PAY_NUMBER'
WHEN 4 THEN 'FV_AP_CASH_ACCOUNT'
WHEN 5 THEN 'FV_AP_CASH_CLEARING_CCID'
WHEN 6 THEN 'DIT_CONFIRM_CASH_ACCOUNT'
WHEN 7 THEN 'FV_INV_DIST_CCID'
WHEN 8 THEN 'FV_AP_LIABILITY_ACCOUNT'
WHEN 9 THEN 'FV_INV_TYPE_LOOKUP_CODE'
WHEN 10 THEN 'FV_BUS_FLOW_FV_APP_ID'
WHEN 11 THEN 'FV_BUS_FLOW_TREASURY_DIST_TYPE'
WHEN 12 THEN 'FV_BUS_FLOW_TREAS_ENTITY_CODE'
WHEN 13 THEN 'FV_PAY_HIST_DIST_ID'
WHEN 14 THEN 'FV_TREASURY_CONFIRMATION_ID'
WHEN 15 THEN 'FV_PAY_DIST_AMOUNT'
WHEN 16 THEN 'FV_INV_CURRENCY_CODE'
WHEN 17 THEN 'FV_INV_EXCHANGE_DATE'
WHEN 18 THEN 'FV_INV_EXCHANGE_RATE'
WHEN 19 THEN 'FV_INV_EXCHANGE_RATE_TYPE'
WHEN 20 THEN 'FV_REV_PAY_HIST_DIST_ID'
ELSE null
END source_code
, CASE r
WHEN 1 THEN TO_CHAR(l2.FV_CHECK_NUMBER)
WHEN 2 THEN TO_CHAR(l2.FV_CHECK_DATE)
WHEN 3 THEN TO_CHAR(l2.FV_TREASURY_PAY_NUMBER)
WHEN 4 THEN TO_CHAR(l2.FV_AP_CASH_ACCOUNT)
WHEN 5 THEN TO_CHAR(l2.FV_AP_CASH_CLEARING_CCID)
WHEN 6 THEN TO_CHAR(l2.DIT_CONFIRM_CASH_ACCOUNT)
WHEN 7 THEN TO_CHAR(l2.FV_INV_DIST_CCID)
WHEN 8 THEN TO_CHAR(l2.FV_AP_LIABILITY_ACCOUNT)
WHEN 9 THEN TO_CHAR(l2.FV_INV_TYPE_LOOKUP_CODE)
WHEN 10 THEN TO_CHAR(l2.FV_BUS_FLOW_FV_APP_ID)
WHEN 11 THEN TO_CHAR(l2.FV_BUS_FLOW_TREASURY_DIST_TYPE)
WHEN 12 THEN TO_CHAR(l2.FV_BUS_FLOW_TREAS_ENTITY_CODE)
WHEN 13 THEN TO_CHAR(l2.FV_PAY_HIST_DIST_ID)
WHEN 14 THEN TO_CHAR(l2.FV_TREASURY_CONFIRMATION_ID)
WHEN 15 THEN TO_CHAR(l2.FV_PAY_DIST_AMOUNT)
WHEN 16 THEN TO_CHAR(l2.FV_INV_CURRENCY_CODE)
WHEN 17 THEN TO_CHAR(l2.FV_INV_EXCHANGE_DATE)
WHEN 18 THEN TO_CHAR(l2.FV_INV_EXCHANGE_RATE)
WHEN 19 THEN TO_CHAR(l2.FV_INV_EXCHANGE_RATE_TYPE)
WHEN 20 THEN TO_CHAR(l2.FV_REV_PAY_HIST_DIST_ID)
ELSE null
END source_value
, null source_meaning
FROM xla_events_gt xet
, FV_TREASURY_EXTRACT_DETAILS_V l2
, (select rownum r from all_objects where rownum <= 20 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
)
;
(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_19'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'XLA_08901_AAD_S_000002_PKG.insert_sources_19');
END insert_sources_19;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: TREASURY_ACCOMPLISHMENT
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.ASP_WHEN_TO_ACCOUNT_PMT source_5
, h1.ASP_AUTOMATIC_OFFSETS_VALUE source_9
, fvl9.meaning source_9_meaning
, h3.TREASURY_CONFIRMATION_ID source_13
FROM xla_events_gt xet
, AP_SYSTEM_PARAMETERS_EXTRACT_V h1
, FV_TREASURY_EXTRACT_HEADER_V h3
, fnd_lookup_values fvl9
WHERE xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
AND h3.org_id = h1.asp_org_id AND fvl9.lookup_type(+) = 'LIABILITY FLEXBUILD METHOD'
AND fvl9.lookup_code(+) = h1.ASP_AUTOMATIC_OFFSETS_VALUE
AND fvl9.view_application_id(+) = 200
AND fvl9.language(+) = USERENV('LANG')
ORDER BY event_id
;
SELECT /*+ leading(xet) cardinality(xet,1) */
-- Event Class Code: TREASURY_ACCOMPLISHMENT
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.FV_CHECK_NUMBER source_1
, l2.FV_CHECK_DATE source_2
, l2.FV_TREASURY_PAY_NUMBER source_3
, l2.FV_AP_CASH_ACCOUNT source_4
, l2.FV_AP_CASH_CLEARING_CCID source_6
, l2.DIT_CONFIRM_CASH_ACCOUNT source_7
, l2.FV_INV_DIST_CCID source_8
, l2.FV_AP_LIABILITY_ACCOUNT source_10
, l2.FV_INV_TYPE_LOOKUP_CODE source_11
, l2.FV_BUS_FLOW_FV_APP_ID source_14
, l2.FV_BUS_FLOW_TREASURY_DIST_TYPE source_15
, l2.FV_BUS_FLOW_TREAS_ENTITY_CODE source_16
, l2.FV_PAY_HIST_DIST_ID source_17
, l2.FV_TREASURY_CONFIRMATION_ID source_18
, l2.FV_PAY_DIST_AMOUNT source_19
, l2.FV_INV_CURRENCY_CODE source_20
, l2.FV_INV_EXCHANGE_DATE source_21
, l2.FV_INV_EXCHANGE_RATE source_22
, l2.FV_INV_EXCHANGE_RATE_TYPE source_23
, l2.FV_REV_PAY_HIST_DIST_ID source_24
FROM xla_events_gt xet
, FV_TREASURY_EXTRACT_DETAILS_V l2
WHERE xet.event_id between x_first_event_id and x_last_event_id
and xet.event_date between p_pad_start_date and p_pad_end_date
and xet.event_class_code = C_EVENT_CLASS_CODE
and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id
;
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_17(
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_18(
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_19(
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
);