APPS.AP_PERIOD_CLOSE_PKG dependencies on XLA_AE_HEADERS

Line 1724: UPDATE xla_ae_headers aeh

1720:
1721: END LOOP;
1722:
1723: forall i in l_event_ids.first..l_event_ids.last
1724: UPDATE xla_ae_headers aeh
1725: SET aeh.accounting_date = g_sweep_to_date,
1726: aeh.period_name = g_sweep_to_period,
1727: last_update_date = SYSDATE,
1728: last_updated_by = FND_GLOBAL.user_id

Line 1741: FROM xla_ae_headers aeh

1737: last_update_date = sysdate,
1738: last_updated_by = FND_GLOBAL.user_id
1739: WHERE ael.ae_header_id in (
1740: SELECT aeh.ae_header_id
1741: FROM xla_ae_headers aeh
1742: WHERE aeh.event_id = l_event_ids(i)
1743: AND aeh.application_id = 200
1744: AND aeh.gl_transfer_status_code <> 'Y'
1745: AND aeh.accounting_entry_status_code <> 'F');

Line 2008: TABLE OF xla_ae_headers.ae_header_id%TYPE

2004: TABLE OF xla_events.event_id%TYPE
2005: INDEX BY BINARY_INTEGER;
2006:
2007: TYPE orphan_headers_tab IS
2008: TABLE OF xla_ae_headers.ae_header_id%TYPE
2009: INDEX BY BINARY_INTEGER;
2010:
2011: l_orphan_events_data ORPHAN_EVENTS_TAB;
2012: l_orphan_headers_data ORPHAN_HEADERS_TAB;

Line 2019: xla_ae_headers xah

2015: SELECT xe.event_id,
2016: xah.ae_header_id
2017: FROM xla_events xe,
2018: xla_transaction_entities_upg xte,
2019: xla_ae_headers xah
2020: WHERE xe.application_id = 200
2021: AND xte.application_id = 200
2022: AND xah.application_id(+) = 200
2023: AND xe.entity_id = xte.entity_id

Line 2091: DELETE FROM xla_ae_headers

2087: AND l_orphan_headers_data(i) IS NOT NULL;
2088:
2089: debug('deleting the orphan headers');
2090: FORALL i IN l_orphan_headers_data.FIRST..l_orphan_headers_data.LAST
2091: DELETE FROM xla_ae_headers
2092: WHERE application_id = 200
2093: AND ae_header_id = l_orphan_headers_data(i)
2094: AND l_orphan_headers_data(i) IS NOT NULL;
2095: