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 497: FROM xla_events_gt xeg

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

Line 503: ,xla_events_gt xe

499:
500: CURSOR c_related_headers is
501: SELECT xe.event_id, xah.ae_header_id, xah.ledger_id
502: FROM xla_ae_headers xah
503: ,xla_events_gt xe
504: WHERE xah.event_id = xe.event_id
505: AND xah.application_id = xe.application_id
506: AND xe.process_status_code = C_EVT_RELATED;
507: */

Line 530: UPDATE xla_events_gt xeg

526: --
527: --
528: -- Add hint as per bug 5529420
529: --
530: UPDATE xla_events_gt xeg
531: SET xeg.process_status_code = C_EVT_RELATED
532: WHERE xeg.process_status_code in (C_DRAFT, C_PROCESSED)
533: AND EXISTS (SELECT /*+ HASH_SJ */ 1
534: FROM xla_events_gt xeg2

Line 534: FROM xla_events_gt xeg2

530: UPDATE xla_events_gt xeg
531: SET xeg.process_status_code = C_EVT_RELATED
532: WHERE xeg.process_status_code in (C_DRAFT, C_PROCESSED)
533: AND EXISTS (SELECT /*+ HASH_SJ */ 1
534: FROM xla_events_gt xeg2
535: WHERE xeg2.entity_id = xeg.entity_id
536: AND xeg2.process_status_code in (C_INVALID,
537: C_ERROR));
538:

Line 567: FROM xla_events_gt xe

563: -- Bug 5056632. update group_id to NULL if entry is in error
564: ,group_id = NULL
565: WHERE xah.event_id in
566: (SELECT xe.event_id
567: FROM xla_events_gt xe
568: WHERE xe.process_status_code = C_EVT_RELATED );
569:
570: /*
571: OPEN c_related_headers;

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

1078: -- the update
1079: --
1080: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1081: trace
1082: (p_msg => 'SQL- update xla_events_gt'
1083: ,p_level => C_LEVEL_STATEMENT
1084: ,p_module => l_log_module);
1085: END IF;
1086:

Line 1093: UPDATE xla_events_gt

1089: FROM xla_ae_lines_gt
1090: WHERE reversal_code = 'DUMMY_LR_ERROR';
1091:
1092: FORALL i IN 1..l_array_temp_events.COUNT
1093: UPDATE xla_events_gt
1094: SET process_status_code = 'E'
1095: WHERE event_id = l_array_temp_events(i);
1096:
1097:

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

1096:
1097:
1098: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1099: trace
1100: (p_msg => '# rows updated in xla_events_gt ='||SQL%ROWCOUNT
1101: ,p_level => C_LEVEL_STATEMENT
1102: ,p_module => l_log_module);
1103: END IF;
1104: --

Line 1287: UPDATE xla_events_gt

1283: INTO l_array_temp_events, l_array_temp_status
1284: FROM xla_ae_headers_gt;
1285:
1286: FORALL i IN 1..l_array_temp_events.COUNT
1287: UPDATE xla_events_gt
1288: SET process_status_code = DECODE(l_array_temp_status(i)
1289: ,'X', DECODE(process_status_code
1290: ,'E','I'
1291: ,DECODE(p_accounting_mode

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

1578: --
1579: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;
1580:
1581: --
1582: -- get min and max event date from the xla_events_gt_table.
1583: -- this information is used to find the AADs that will used
1584: -- to account for events
1585: --
1586: SELECT MIN(event_date), MAX(event_date)

Line 1588: FROM xla_events_gt;

1584: -- to account for events
1585: --
1586: SELECT MIN(event_date), MAX(event_date)
1587: INTO p_min_event_date, p_max_event_date
1588: FROM xla_events_gt;
1589:
1590: --
1591: -- looping for base ledgers
1592: --

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

1614: --
1615: FOR Kdx IN 1 .. l_array_pads.COUNT LOOP
1616: --
1617: -- following code will be used to see if there are missing AADs for
1618: -- which there are events in the XLA_EVENTS_GT table.
1619: -- These events should actually be marked as error/invalid.
1620: --
1621: IF (l_min_aad_start_date IS NULL OR
1622: l_min_aad_start_date > NVL(l_array_pads(Kdx).start_date_active,p_min_event_date))

Line 1925: UPDATE xla_events_gt

1921: ,p_level => C_LEVEL_PROCEDURE
1922: ,p_module => l_log_module);
1923: END IF;
1924:
1925: UPDATE xla_events_gt
1926: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
1927: WHERE event_date BETWEEN p_min_date AND p_max_date
1928: RETURNING entity_id, event_id
1929: BULK COLLECT INTO

Line 2022: UPDATE xla_events_gt

2018:
2019: IF (p_min_event_date < p_min_aad_start_date AND
2020: p_max_event_date > p_max_aad_end_date)
2021: THEN
2022: UPDATE xla_events_gt
2023: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2024: WHERE event_date BETWEEN p_min_event_date AND (p_min_aad_start_date -1)
2025: OR event_date BETWEEN (p_max_aad_end_date +1) AND p_max_event_date
2026: RETURNING entity_id, event_id

Line 2031: UPDATE xla_events_gt

2027: BULK COLLECT INTO
2028: l_array_entity_id
2029: ,l_array_event_id;
2030: ELSIF p_min_event_date < p_min_aad_start_date THEN
2031: UPDATE xla_events_gt
2032: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2033: WHERE event_date BETWEEN p_min_event_date AND (p_min_aad_start_date -1)
2034: RETURNING entity_id, event_id
2035: BULK COLLECT INTO

Line 2039: UPDATE xla_events_gt

2035: BULK COLLECT INTO
2036: l_array_entity_id
2037: ,l_array_event_id;
2038: ELSIF p_max_event_date > p_max_aad_end_date THEN
2039: UPDATE xla_events_gt
2040: SET process_status_code = DECODE(process_status_code, 'U', 'E', process_status_code)
2041: WHERE event_date BETWEEN (p_max_aad_end_date +1) AND p_max_event_date
2042: RETURNING entity_id, event_id
2043: BULK COLLECT INTO