APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_EVENTS_GT

Line 9676: UPDATE xla_events_gt

9672: --------------------------------------------------------------------------------------
9673:
9674: /*
9675: FORALL i IN 1..g_err_count
9676: UPDATE xla_events_gt
9677: SET process_status_code = 'I'
9678: WHERE event_id = g_err_event_ids(i)
9679: AND process_status_code <> 'E';
9680: */

Line 9682: UPDATE xla_events_gt evt -- 4262811a

9678: WHERE event_id = g_err_event_ids(i)
9679: AND process_status_code <> 'E';
9680: */
9681: FORALL i IN 1..g_err_count
9682: UPDATE xla_events_gt evt -- 4262811a
9683: SET process_status_code =
9684: (SELECT DECODE(xah2.parent_ae_line_num,NULL,'I' -- 4262811a Status of MPA rows does not affect event status
9685: , evt.process_status_code)
9686: FROM xla_ae_headers xah2

Line 9695: trace(p_msg => '# xla_events_gt updated = '||SQL%ROWCOUNT,

9691: AND process_status_code <> 'E';
9692:
9693:
9694: IF (C_LEVEL_EVENT >= g_log_level) THEN
9695: trace(p_msg => '# xla_events_gt updated = '||SQL%ROWCOUNT,
9696: p_module => l_log_module,
9697: p_level => C_LEVEL_EVENT);
9698: END IF;
9699: END IF; -- 4262811a g_caller = C_CALLER_ACCT_PROGRAM

Line 9727: , xla_events_gt xeg

9723: IS
9724: CURSOR c_failed_je IS
9725: SELECT distinct xah.ledger_id, xah.event_id
9726: FROM xla_ae_headers xah
9727: , xla_events_gt xeg
9728: WHERE xeg.event_id = xah.event_id
9729: AND xah.application_id = g_application_id
9730: AND xeg.process_status_code = 'I';
9731: