eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 708: FROM xla_distribution_links

704:
705: IF l_links_insert = TRUE THEN
706:
707: DELETE
708: FROM xla_distribution_links
709: WHERE gain_or_loss_ref = to_char(l_upgrade_id);
710:
711: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
712: trace

Line 713: (p_msg => 'deleted rows from xla_distribution_links = ' || SQL%ROWCOUNT

709: WHERE gain_or_loss_ref = to_char(l_upgrade_id);
710:
711: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
712: trace
713: (p_msg => 'deleted rows from xla_distribution_links = ' || SQL%ROWCOUNT
714: ,p_level => C_LEVEL_PROCEDURE
715: ,p_module => l_log_module);
716: END IF;
717: COMMIT;

Line 3345: INSERT /+ append / INTO XLA_DISTRIBUTION_LINKS

3341:
3342:
3343:
3344:
3345: INSERT /*+ append */ INTO XLA_DISTRIBUTION_LINKS
3346: (
3347: APPLICATION_ID
3348: , EVENT_ID
3349: , AE_HEADER_ID

Line 3518: FROM XLA_DISTRIBUTION_LINKS XDL

3514: , XDL.ALLOC_TO_DIST_ID_CHAR_3
3515: , XDL.ALLOC_TO_DIST_ID_CHAR_4
3516: , XDL.ALLOC_TO_DIST_ID_CHAR_5
3517: , l_upgrade_id -- concurrent request id stored in column XDL.GAIN_OR_LOSS_REF
3518: FROM XLA_DISTRIBUTION_LINKS XDL
3519: ,XLA_AE_LINES XAL
3520: WHERE
3521: XAL.upg_batch_id = XDL.ae_header_id
3522: AND XAL.ledger_id = l_secondary_alc_ledger_id

Line 3535: (p_msg => 'Rows inserted into xla_distribution_links = ' || SQL%ROWCOUNT

3531:
3532:
3533: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3534: trace
3535: (p_msg => 'Rows inserted into xla_distribution_links = ' || SQL%ROWCOUNT
3536: ,p_level => C_LEVEL_PROCEDURE
3537: ,p_module => l_log_module);
3538:
3539: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')

Line 3558: UPDATE xla_distribution_links xdl

3554: -- section commented bug 7201652. update can be used in post script if needed. query for some cases
3555: -- still throws cannot update to null error. ref_ae_header should not have an impact on reversal/bflow
3556: -- since joins are not based on this column
3557:
3558: UPDATE xla_distribution_links xdl
3559: SET ref_ae_header_id = (SELECT ae_header_id
3560: FROM xla_ae_headers xah
3561: WHERE xah.upg_batch_id = -1 * xdl.ref_ae_header_id
3562: --AND xah.application_id = xdl.application_id

Line 3578: (p_msg => 'Rows updated in xla_distribution_links with negative ref headers = ' || SQL%ROWCOUNT

3574:
3575:
3576: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3577: trace
3578: (p_msg => 'Rows updated in xla_distribution_links with negative ref headers = ' || SQL%ROWCOUNT
3579: ,p_level => C_LEVEL_PROCEDURE
3580: ,p_module => l_log_module);
3581:
3582: SELECT to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')