APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_AE_LINES

Line 1297: xla_ae_lines XAL

1293: IS
1294: SELECT /*+ parallel(xah) parallel(xal) leading(xah) */ distinct(XAL.currency_code)
1295: FROM xla_ae_headers XAH,
1296: xla_historic_control XHC,
1297: xla_ae_lines XAL
1298: WHERE XHC.primary_ledger = g_primary_ledger_id
1299: AND XHC.secondary_alc_ledger = g_secondary_alc_ledger_id
1300: AND XHC.upgrade_id = g_upgrade_id
1301: AND XHC.application_id = g_application_id

Line 2574: xla_ae_lines XAL,

2570: , XDL.ALLOC_TO_DIST_ID_CHAR_5
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

Line 2609: INSERT INTO XLA_AE_LINES

2605: END IF;
2606:
2607:
2608:
2609: INSERT INTO XLA_AE_LINES
2610: ( AE_HEADER_ID
2611: , AE_LINE_NUM
2612: , APPLICATION_ID
2613: , CODE_COMBINATION_ID

Line 2812: xla_ae_lines XAL,

2808: , XAL.SOURCE_ID
2809: , XAL.ACCOUNT_OVERLAY_SOURCE_ID
2810: FROM xla_historic_control XHC,
2811: xla_historic_mapping_gt XMAP,
2812: xla_ae_lines XAL,
2813: xla_rc_upgrade_rates XRUR
2814: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2815: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2816: AND XHC.upgrade_id = p_ugprade_id -- worker input

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

2832:
2833: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2834:
2835: trace
2836: (p_msg => 'Rows inserted into xla_ae_lines: ' || SQL%ROWCOUNT || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS') -- to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2837: ,p_level => C_LEVEL_PROCEDURE
2838: ,p_module => l_log_module);
2839:
2840: END IF;

Line 2859: FROM xla_ae_lines XAL

2855:
2856:
2857: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2858: SELECT distinct p_mapping_rel_id, code_combination_id
2859: FROM xla_ae_lines XAL
2860: WHERE application_id = p_application_id
2861: AND EXISTS (SELECT 1
2862: FROM xla_historic_mapping_gt XMAP
2863: WHERE XMAP.new_header_id = XAL.ae_header_id); -- sec/alc header id

Line 2880: UPDATE xla_ae_lines XAL

2876: GL_ACCOUNTS_MAP_GRP.MAP(mapping_name => p_coa_map_name
2877: ,create_ccid => (NVL(p_dynamic_flag,'N') ='Y' )
2878: ,debug => g_log_enabled);
2879:
2880: UPDATE xla_ae_lines XAL
2881: SET code_combination_id = (SELECT (nvl(GL_INT.to_ccid, -1))
2882: FROM gl_accts_map_int_gt GL_INT
2883: WHERE XAL.code_combination_id = GL_INT.from_ccid
2884: AND GL_INT.coa_mapping_id = p_mapping_rel_id)

Line 2893: (p_msg => 'Rows updated in xla_ae_lines with new ccid = ' || SQL%ROWCOUNT || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')

2889:
2890: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2891:
2892: trace
2893: (p_msg => 'Rows updated in xla_ae_lines with new ccid = ' || SQL%ROWCOUNT || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2894: ,p_level => C_LEVEL_PROCEDURE
2895: ,p_module => l_log_module);
2896:
2897: END IF;