eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_EVENTS_GT

Line 79: | xla_events_gt is modified. |

75: | Following new routine is added: |
76: | - CatchErr_MissingAAD |
77: | 21-Oct-2004 S.Singhania Bug 3962951. Modified PostAccounting. Update |
78: | statement to update event status in |
79: | xla_events_gt is modified. |
80: | Added one update statement on xla_events_gt |
81: | to update the event status to ERROR for the|
82: | case where validation in AccoutningRevesal |
83: | fails. |

Line 80: | Added one update statement on xla_events_gt |

76: | - CatchErr_MissingAAD |
77: | 21-Oct-2004 S.Singhania Bug 3962951. Modified PostAccounting. Update |
78: | statement to update event status in |
79: | xla_events_gt is modified. |
80: | Added one update statement on xla_events_gt |
81: | to update the event status to ERROR for the|
82: | case where validation in AccoutningRevesal |
83: | fails. |
84: | 02-Nov-2004 K.Boussema Changed for Diagnostic Framework. Included |

Line 502: FROM xla_events_gt xeg

498: -- so that we can set all the no-error event to related-error status
499: /*
500: CURSOR c_related_events is
501: SELECT xeg.entity_id, xeg.event_id
502: FROM xla_events_gt xeg
503: WHERE xeg.process_status_code = C_EVT_RELATED;
504:
505: CURSOR c_related_headers is
506: SELECT xe.event_id, xah.ae_header_id, xah.ledger_id

Line 508: ,xla_events_gt xe

504:
505: CURSOR c_related_headers is
506: SELECT xe.event_id, xah.ae_header_id, xah.ledger_id
507: FROM xla_ae_headers xah
508: ,xla_events_gt xe
509: WHERE xah.event_id = xe.event_id
510: AND xah.application_id = xe.application_id
511: AND xe.process_status_code = C_EVT_RELATED;
512: */

Line 535: UPDATE xla_events_gt xeg

531: --
532: --
533: -- Add hint as per bug 5529420
534: --
535: UPDATE xla_events_gt xeg
536: SET xeg.process_status_code = C_EVT_RELATED
537: WHERE xeg.process_status_code in (C_DRAFT, C_PROCESSED)
538: AND EXISTS (SELECT /*+ HASH_SJ */ 1
539: FROM xla_events_gt xeg2

Line 539: FROM xla_events_gt xeg2

535: UPDATE xla_events_gt xeg
536: SET xeg.process_status_code = C_EVT_RELATED
537: WHERE xeg.process_status_code in (C_DRAFT, C_PROCESSED)
538: AND EXISTS (SELECT /*+ HASH_SJ */ 1
539: FROM xla_events_gt xeg2
540: WHERE xeg2.entity_id = xeg.entity_id
541: AND xeg2.process_status_code in (C_INVALID,
542: C_ERROR));
543:

Line 572: FROM xla_events_gt xe

568: -- Bug 5056632. update group_id to NULL if entry is in error
569: ,group_id = NULL
570: WHERE xah.event_id in
571: (SELECT xe.event_id
572: FROM xla_events_gt xe
573: WHERE xe.process_status_code = C_EVT_RELATED );
574:
575: /*
576: OPEN c_related_headers;

Line 1108: (p_msg => 'SQL- update xla_events_gt'

1104: -- the update
1105: --
1106: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1107: trace
1108: (p_msg => 'SQL- update xla_events_gt'
1109: ,p_level => C_LEVEL_STATEMENT
1110: ,p_module => l_log_module);
1111: END IF;
1112:

Line 1119: UPDATE xla_events_gt

1115: FROM xla_ae_lines_gt
1116: WHERE reversal_code = 'DUMMY_LR_ERROR';
1117:
1118: FORALL i IN 1..l_array_temp_events.COUNT
1119: UPDATE xla_events_gt
1120: SET process_status_code = 'E'
1121: WHERE event_id = l_array_temp_events(i);
1122:
1123:

Line 1126: (p_msg => '# rows updated in xla_events_gt ='||SQL%ROWCOUNT

1122:
1123:
1124: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1125: trace
1126: (p_msg => '# rows updated in xla_events_gt ='||SQL%ROWCOUNT
1127: ,p_level => C_LEVEL_STATEMENT
1128: ,p_module => l_log_module);
1129: END IF;
1130: --

Line 1327: UPDATE xla_events_gt

1323: order by event_id , event_status_code desc -- added for bug#9086275
1324: ;
1325:
1326: FORALL i IN 1..l_array_temp_events.COUNT
1327: UPDATE xla_events_gt
1328: SET process_status_code = DECODE(l_array_temp_status(i)
1329: ,'X', DECODE(process_status_code
1330: ,'E','I'
1331: ,DECODE(p_accounting_mode

Line 1385: UPDATE xla_events_gt xe

1381: -- 12411043 Start of Code
1382: -- BUG 13811614: Replaced Nvl(xldb.budgetary_control_flag,'X') with Nvl(xldb.budgetary_control_flag,'N')
1383: -- Changed the Status from P','P' to 'N', 'P'
1384:
1385: UPDATE xla_events_gt xe
1386: SET xe.event_status_code = 'N'
1387: ,xe.process_status_code = 'P'
1388: ,xe.reference_char_4 = (CASE WHEN xe.application_id > 20000 then xe.reference_char_4 else 'CASH' end)
1389: WHERE EXISTS (SELECT 1

Line 1701: -- get min and max event date from the xla_events_gt_table.

1697: --
1698: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;
1699:
1700: --
1701: -- get min and max event date from the xla_events_gt_table.
1702: -- this information is used to find the AADs that will used
1703: -- to account for events
1704: --
1705: SELECT MIN(event_date), MAX(event_date)

Line 1707: FROM xla_events_gt;

1703: -- to account for events
1704: --
1705: SELECT MIN(event_date), MAX(event_date)
1706: INTO p_min_event_date, p_max_event_date
1707: FROM xla_events_gt;
1708:
1709: --
1710: -- looping for base ledgers
1711: --

Line 1737: -- which there are events in the XLA_EVENTS_GT table.

1733: --
1734: FOR Kdx IN 1 .. l_array_pads.COUNT LOOP
1735: --
1736: -- following code will be used to see if there are missing AADs for
1737: -- which there are events in the XLA_EVENTS_GT table.
1738: -- These events should actually be marked as error/invalid.
1739: --
1740: IF (l_min_aad_start_date IS NULL OR
1741: l_min_aad_start_date > NVL(l_array_pads(Kdx).start_date_active,p_min_event_date))

Line 2044: UPDATE xla_events_gt

2040: ,p_level => C_LEVEL_PROCEDURE
2041: ,p_module => l_log_module);
2042: END IF;
2043:
2044: UPDATE xla_events_gt
2045: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2046: WHERE event_date BETWEEN p_min_date AND p_max_date
2047: RETURNING entity_id, event_id
2048: BULK COLLECT INTO

Line 2142: UPDATE xla_events_gt

2138:
2139: IF (p_min_event_date < p_min_aad_start_date AND
2140: p_max_event_date > p_max_aad_end_date)
2141: THEN
2142: UPDATE xla_events_gt
2143: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2144: WHERE event_date BETWEEN p_min_event_date AND (p_min_aad_start_date -1)
2145: OR event_date BETWEEN (p_max_aad_end_date +1) AND p_max_event_date
2146: RETURNING entity_id, event_id

Line 2151: UPDATE xla_events_gt

2147: BULK COLLECT INTO
2148: l_array_entity_id
2149: ,l_array_event_id;
2150: ELSIF p_min_event_date < p_min_aad_start_date THEN
2151: UPDATE xla_events_gt
2152: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2153: WHERE event_date BETWEEN p_min_event_date AND (p_min_aad_start_date -1)
2154: RETURNING entity_id, event_id
2155: BULK COLLECT INTO

Line 2159: UPDATE xla_events_gt

2155: BULK COLLECT INTO
2156: l_array_entity_id
2157: ,l_array_event_id;
2158: ELSIF p_max_event_date > p_max_aad_end_date THEN
2159: UPDATE xla_events_gt
2160: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2161: WHERE event_date BETWEEN (p_max_aad_end_date +1) AND p_max_event_date
2162: RETURNING entity_id, event_id
2163: BULK COLLECT INTO