APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 2364: INSERT INTO XLA_DISTRIBUTION_LINKS

2360:
2361:
2362: -- rowid condition not needed below since only x-y rowid XAH headers stored in xla_historic_mapping_gt
2363:
2364: INSERT INTO XLA_DISTRIBUTION_LINKS
2365: (
2366: APPLICATION_ID
2367: , EVENT_ID
2368: , AE_HEADER_ID

Line 2575: xla_distribution_links XDL,

2571: , GAIN_OR_LOSS_REF
2572: FROM xla_historic_control XHC,
2573: xla_historic_mapping_gt XMAP,
2574: xla_ae_lines XAL,
2575: xla_distribution_links XDL,
2576: xla_rc_upgrade_rates XRUR
2577: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2578: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2579: AND XHC.upgrade_id = p_ugprade_id -- worker input

Line 2601: (p_msg => 'Rows inserted into xla_distribution_links: ' || SQL%ROWCOUNT ||' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS') -- to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')

2597:
2598: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2599:
2600: trace
2601: (p_msg => 'Rows inserted into xla_distribution_links: ' || SQL%ROWCOUNT ||' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS') -- to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2602: ,p_level => C_LEVEL_PROCEDURE
2603: ,p_module => l_log_module);
2604:
2605: END IF;