APPS.XLA_UPGRADE_PUB dependencies on XLA_AE_HEADERS

Line 78: xla_ae_headers.ae_header_id%type

74: TYPE t_event_id IS TABLE OF
75: xla_events.event_id%type
76: INDEX BY BINARY_INTEGER;
77: TYPE t_header_id IS TABLE OF
78: xla_ae_headers.ae_header_id%type
79: INDEX BY BINARY_INTEGER;
80: TYPE t_line_num IS TABLE OF
81: xla_ae_lines.ae_line_num%type
82: INDEX BY BINARY_INTEGER;

Line 758: update xla_ae_headers

754: LIMIT g_batch_size;
755: EXIT WHEN l_header_id.COUNT = 0;
756:
757: FORALL i IN l_header_id.FIRST..l_header_id.LAST
758: update xla_ae_headers
759: set upg_valid_flag = null
760: where ae_header_id = l_header_id(i)
761: and application_id = g_application_id;
762:

Line 2495: from xla_ae_headers xah

2491: THEN 'Y'
2492: ELSE 'N' END header_error4-- Balance type code invalid
2493: ,CASE when xe.event_id IS NULL THEN 'Y'
2494: ELSE 'N' END header_error5-- Header without valid event
2495: from xla_ae_headers xah
2496: ,gl_ledgers gll
2497: ,xla_events xe
2498: where gll.ledger_id (+) = xah.ledger_id
2499: and xe.event_id (+) = xah.event_id

Line 2558: from xla_ae_headers xah

2554: <> nvl(sum(entered_cr), 0)) xal,
2555: gl_row_multipliers grm
2556: where xal.ae_header_id in ( select /*+ use_hash(xah) swap_join_inputs(xah) */
2557: xah.ae_header_id
2558: from xla_ae_headers xah
2559: where xah.application_id = p_application_id
2560: and xah.ae_header_id = p_header_id
2561: and xah.balance_type_code <> 'B')
2562: and grm.multiplier < 3

Line 2585: from xla_ae_headers xah

2581: , 'H'
2582: ,ae_header_id
2583: ,'XLA_UPG_HDR_WO_LINES'
2584: from (select xah.ae_header_id
2585: from xla_ae_headers xah
2586: where NOT EXISTS (SELECT xal.ae_header_id
2587: from xla_ae_lines xal
2588: where xah.ae_header_id = xal.ae_header_id
2589: and xah.application_id = xal.application_id

Line 2599: UPDATE xla_ae_headers

2595:
2596: l_rowcount := l_rowcount + sql%rowcount;
2597:
2598: If l_rowcount > 0 THEN
2599: UPDATE xla_ae_headers
2600: set upg_valid_flag = CASE upg_valid_flag
2601: WHEN 'F' THEN 'L'
2602: WHEN 'J' THEN 'M'
2603: WHEN 'I' THEN 'N'

Line 2699: FROM xla_ae_headers xah

2695: ELSE 'N' END line_error9
2696: , CASE when xal.party_site_id IS NULL
2697: and xal.party_id IS NULL then 'Y'
2698: ELSE 'N' END line_error10
2699: FROM xla_ae_headers xah
2700: , xla_ae_lines xal
2701: , gl_code_combinations glcc
2702: , gl_ledgers gll
2703: , hz_parties hz

Line 2750: UPDATE xla_ae_headers

2746:
2747: l_rowcount := l_rowcount + sql%rowcount;
2748:
2749: If l_rowcount > 0 THEN
2750: UPDATE xla_ae_headers
2751: set upg_valid_flag = CASE upg_valid_flag
2752: WHEN 'F' THEN 'P'
2753: WHEN 'J' THEN 'Q'
2754: WHEN 'I' THEN 'R'