DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on XLA_AE_LINES

Line 1735: UPDATE xla_ae_lines ael

1731: AND gl_transfer_status_code <> 'Y'
1732: AND accounting_entry_status_code <> 'F';
1733:
1734: forall i in l_event_ids.first..l_event_ids.last
1735: UPDATE xla_ae_lines ael
1736: SET ael.accounting_date = g_sweep_to_date,
1737: last_update_date = sysdate,
1738: last_updated_by = FND_GLOBAL.user_id
1739: WHERE ael.ae_header_id in (

Line 2084: DELETE FROM xla_ae_lines

2080: AND l_orphan_headers_data(i) IS NOT NULL;
2081:
2082: debug('deleting the orphan lines');
2083: FORALL i IN l_orphan_headers_data.FIRST..l_orphan_headers_data.LAST
2084: DELETE FROM xla_ae_lines
2085: WHERE application_id = 200
2086: AND ae_header_id = l_orphan_headers_data(i)
2087: AND l_orphan_headers_data(i) IS NOT NULL;
2088: