DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_EVENTS_GT

Line 10361: UPDATE xla_events_gt

10357: --------------------------------------------------------------------------------------
10358:
10359: /*
10360: FORALL i IN 1..g_err_count
10361: UPDATE xla_events_gt
10362: SET process_status_code = 'I'
10363: WHERE event_id = g_err_event_ids(i)
10364: AND process_status_code <> 'E';
10365: */

Line 10367: UPDATE xla_events_gt evt -- 4262811a

10363: WHERE event_id = g_err_event_ids(i)
10364: AND process_status_code <> 'E';
10365: */
10366: FORALL i IN 1..g_err_count
10367: UPDATE xla_events_gt evt -- 4262811a
10368: SET process_status_code =
10369: (SELECT DECODE(xah2.parent_ae_line_num,NULL,'I' -- 4262811a Status of MPA rows does not affect event status
10370: , evt.process_status_code)
10371: FROM xla_ae_headers xah2

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

10376: AND process_status_code <> 'E';
10377:
10378:
10379: IF (C_LEVEL_EVENT >= g_log_level) THEN
10380: trace(p_msg => '# xla_events_gt updated = '||SQL%ROWCOUNT,
10381: p_module => l_log_module,
10382: p_level => C_LEVEL_EVENT);
10383: END IF;
10384: END IF; -- 4262811a g_caller = C_CALLER_ACCT_PROGRAM

Line 10412: , xla_events_gt xeg

10408: IS
10409: CURSOR c_failed_je IS
10410: SELECT distinct xah.ledger_id, xah.event_id
10411: FROM xla_ae_headers xah
10412: , xla_events_gt xeg
10413: WHERE xeg.event_id = xah.event_id
10414: AND xah.application_id = g_application_id
10415: AND xeg.process_status_code = 'I';
10416: