APPS.XLA_UPG_VERIFICATION_PUB dependencies on XLA_EVENTS

Line 46: xla_events.event_id%type

42: xla_transaction_entities.entity_id%type
43: INDEX BY BINARY_INTEGER;
44: TYPE t_error_flag IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
45: TYPE t_event_id IS TABLE OF
46: xla_events.event_id%type
47: INDEX BY BINARY_INTEGER;
48: TYPE t_header_id IS TABLE OF
49: xla_ae_headers.ae_header_id%type
50: INDEX BY BINARY_INTEGER;

Line 297: UPDATE xla_events

293:
294: -- Updating as invalids all events that are associated with invalid entity.
295:
296: FORALL i IN l_entity_id.FIRST..l_entity_id.LAST
297: UPDATE xla_events
298: set upg_valid_flag = 'B'
299: where entity_id = l_entity_id(i);
300:
301: -- Cumilitive number of rows updated.

Line 454: UPDATE xla_events

450:
451: -- Updating as invalids all events that are associated with invalid entity.
452:
453: FORALL i IN l_entity_id.FIRST..l_entity_id.LAST
454: UPDATE xla_events
455: set upg_valid_flag = 'E'
456: where entity_id = l_entity_id(i);
457:
458: -- Cumilitive number of rows updated.

Line 618: from xla_events xe

614: ,CASE when xevt.event_class_code IS NULL THEN 'Y'
615: ELSE 'N' END event_error7-- Event Class Code is Invalid
616: ,CASE when xalb.accounting_class_code IS NULL THEN 'Y'
617: ELSE 'N' END event_error8
618: from xla_events xe
619: , xla_transaction_entities_upg xen
620: , xla_event_types_b xevt
621: , xla_acct_line_types_b xalb
622: , xla_entity_types_b xent

Line 662: UPDATE xla_events

658: EXIT WHEN l_event_id.COUNT = 0;
659:
660: -- Mark Event as having errors
661: FORALL i IN l_event_id.FIRST..l_event_id.LAST
662: UPDATE xla_events
663: set upg_valid_flag = CASE upg_valid_flag
664: WHEN 'E' THEN 'G'
665: ELSE 'H'
666: END

Line 823: ,xla_events xe

819: ,CASE when xe.event_id IS NULL THEN 'Y'
820: ELSE 'N' END header_error5-- Header without valid event
821: from xla_ae_headers xah
822: ,gl_ledgers gll
823: ,xla_events xe
824: where gll.ledger_id (+) = xah.ledger_id
825: and xe.event_id (+) = xah.event_id
826: and (gll.ledger_id IS NULL OR
827: (xah.BALANCE_TYPE_CODE = 'B' AND