DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_DIAG_EVENTS

Line 161: | - xla_extract_events BY xla_diag_events |

157: | Event Extract Diagnostics data: |
158: | - delete_request_je() AND |
159: | - delete_transaction_je() |
160: | 12/08/2004 K. Boussema Renamed THE diagnostic framework TABLES: |
161: | - xla_extract_events BY xla_diag_events |
162: | - xla_extract_ledgers BY xla_diag_ledgers |
163: | - xla_extract_sources BY xla_diag_sources |
164: | 01/04/2005 S. Singhania Bug 3928357. g_total_error_Count IS SET TO|
165: | have THE right value IN document MODE |

Line 4007: DELETE FROM xla_diag_events

4003: ,p_level => C_LEVEL_STATEMENT
4004: ,p_module => l_log_module);
4005: END IF;
4006:
4007: DELETE FROM xla_diag_events
4008: WHERE event_id IN
4009: (SELECT event_id FROM xla_events_gt);
4010:
4011: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 4022: FROM xla_diag_events

4018: DELETE FROM xla_diag_ledgers d
4019: WHERE d.application_id = g_application_id
4020: AND NOT EXISTS
4021: (SELECT ledger_id, request_id
4022: FROM xla_diag_events
4023: WHERE application_id = d.application_id
4024: AND request_id = d.accounting_request_id
4025: AND ledger_id = d.primary_ledger_id
4026: );

Line 7236: DELETE FROM xla_diag_events

7232: ,p_module => l_log_module);
7233: END IF;
7234:
7235: FORALL i IN 1..l_array_event_id.COUNT
7236: DELETE FROM xla_diag_events
7237: WHERE application_id = g_application_id
7238: AND event_id = l_array_event_id(i);
7239:
7240: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 7241: trace(p_msg => '# xla_diag_events deleted = '||SQL%ROWCOUNT

7237: WHERE application_id = g_application_id
7238: AND event_id = l_array_event_id(i);
7239:
7240: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7241: trace(p_msg => '# xla_diag_events deleted = '||SQL%ROWCOUNT
7242: ,p_level => C_LEVEL_STATEMENT
7243: ,p_module => l_log_module);
7244: END IF;
7245: --bug6369888

Line 7250: FROM xla_diag_events

7246: DELETE FROM xla_diag_ledgers d
7247: WHERE d.application_id = g_application_id
7248: AND NOT EXISTS
7249: (SELECT ledger_id, request_id
7250: FROM xla_diag_events
7251: WHERE application_id = d.application_id
7252: AND request_id = d.accounting_request_id
7253: AND ledger_id = d.primary_ledger_id
7254: );