DBA Data[Home] [Help]

APPS.XLA_EVENTS_PKG dependencies on XLA_ACCOUNTING_ERRORS

Line 183: | deleteing the data from XLA_ACCOUNTING_ERRORS |

179: | 13-Oct-10 nksurana Bug 10152910 Created new function/API |
180: | allow_third_party_update to check if the party|
181: | site can be updated, based on Control Account.|
182: | 06-Jan-11 sgullape Bug 9775727:Modified the WHERE condition while|
183: | deleteing the data from XLA_ACCOUNTING_ERRORS |
184: | in delete_je procedure. |
185: | Bug 10162587: Modified at SAVEPOINT in |
186: | delete_bulk_events procedure. |
187: +===========================================================================*/

Line 9506: DELETE FROM xla_accounting_errors

9502:
9503: -- shall we join to xla_events to get only the event with status D or I?
9504: -- good: reduce the event_id that are selected
9505: -- bad: need to join to xla_events table
9506: DELETE FROM xla_accounting_errors
9507: WHERE event_id IN
9508: (SELECT xeg.event_id FROM xla_events_int_gt xeg, xla_events xe
9509: WHERE xeg.event_id = xe.event_id
9510: AND xe.application_id = g_application_id -- 8967771