APPS.XLA_UPGRADE_PUB dependencies on XLA_AE_HEADERS

Line 70: xla_ae_headers.ae_header_id%type

66: TYPE t_event_id IS TABLE OF
67: xla_events.event_id%type
68: INDEX BY BINARY_INTEGER;
69: TYPE t_header_id IS TABLE OF
70: xla_ae_headers.ae_header_id%type
71: INDEX BY BINARY_INTEGER;
72: TYPE t_line_num IS TABLE OF
73: xla_ae_lines.ae_line_num%type
74: INDEX BY BINARY_INTEGER;

Line 639: update xla_ae_headers

635: LIMIT g_batch_size;
636: EXIT WHEN l_header_id.COUNT = 0;
637:
638: FORALL i IN l_header_id.FIRST..l_header_id.LAST
639: update xla_ae_headers
640: set upg_valid_flag = null
641: where ae_header_id = l_header_id(i)
642: and application_id = g_application_id;
643:

Line 1436: from xla_ae_headers xah

1432: THEN 'Y'
1433: ELSE 'N' END header_error4-- Balance type code invalid
1434: ,CASE when xe.event_id IS NULL THEN 'Y'
1435: ELSE 'N' END header_error5-- Header without valid event
1436: from xla_ae_headers xah
1437: ,gl_ledgers gll
1438: ,xla_events xe
1439: where gll.ledger_id (+) = xah.ledger_id
1440: and xe.event_id (+) = xah.event_id

Line 1499: from xla_ae_headers xah

1495: <> nvl(sum(entered_cr), 0)) xal,
1496: gl_row_multipliers grm
1497: where xal.ae_header_id in ( select /*+ use_hash(xah) swap_join_inputs(xah) */
1498: xah.ae_header_id
1499: from xla_ae_headers xah
1500: where xah.application_id = p_application_id
1501: and xah.ae_header_id = p_header_id
1502: and xah.balance_type_code <> 'B')
1503: and grm.multiplier < 3

Line 1526: from xla_ae_headers xah

1522: , 'H'
1523: ,ae_header_id
1524: ,'XLA_UPG_HDR_WO_LINES'
1525: from (select xah.ae_header_id
1526: from xla_ae_headers xah
1527: where NOT EXISTS (SELECT xal.ae_header_id
1528: from xla_ae_lines xal
1529: where xah.ae_header_id = xal.ae_header_id
1530: and xah.application_id = xal.application_id

Line 1540: UPDATE xla_ae_headers

1536:
1537: l_rowcount := l_rowcount + sql%rowcount;
1538:
1539: If l_rowcount > 0 THEN
1540: UPDATE xla_ae_headers
1541: set upg_valid_flag = CASE upg_valid_flag
1542: WHEN 'F' THEN 'L'
1543: WHEN 'J' THEN 'M'
1544: WHEN 'I' THEN 'N'

Line 1640: FROM xla_ae_headers xah

1636: ELSE 'N' END line_error9
1637: , CASE when xal.party_site_id IS NULL
1638: and xal.party_id IS NULL then 'Y'
1639: ELSE 'N' END line_error10
1640: FROM xla_ae_headers xah
1641: , xla_ae_lines xal
1642: , gl_code_combinations glcc
1643: , gl_ledgers gll
1644: , hz_parties hz

Line 1691: UPDATE xla_ae_headers

1687:
1688: l_rowcount := l_rowcount + sql%rowcount;
1689:
1690: If l_rowcount > 0 THEN
1691: UPDATE xla_ae_headers
1692: set upg_valid_flag = CASE upg_valid_flag
1693: WHEN 'F' THEN 'P'
1694: WHEN 'J' THEN 'Q'
1695: WHEN 'I' THEN 'R'