Search Results g_entity_id

Overview

APPS.XLA_EVENTS_PKG is a private PL/SQL package in the Oracle E-Business Suite Subledger Accounting (XLA) module. It contains the core APIs required for creating, maintaining, and purging accounting events, which are the fundamental units of work processed by the Subledger Accounting engine. The package operates beneath the public wrapper XLA_EVENT_PUB_PKG, which exposes supported APIs to external callers. The source header identifies the file as xlaevevt.pkb and confirms that the APIs deliberately avoid issuing COMMIT or ROLLBACK, with the single documented exception of the period-close procedure. Internal error messages are hard-coded in English, reflecting the package's classification as an internal, private component rather than a user-facing API surface.

Key Procedures and Functions

The package exposes twenty-five documented procedures and functions. INITIALIZE prepares package-level state and was made public in early releases. CREATE_EVENT, CREATE_MANUAL_EVENT, and CREATE_BULK_EVENTS handle event creation through single, manual, and set-based paths respectively. UPDATE_EVENT, UPDATE_MANUAL_EVENT, UPDATE_EVENT_STATUS, and UPDATE_BULK_EVENT_STATUSES maintain event attributes and status transitions. DELETE_EVENT, DELETE_PROCESSED_EVENT, DELETE_EVENTS, DELETE_ENTITY, DELETE_BULK_EVENTS, and PURGE_ENTITY provide removal and purge capabilities across individual, bulk, and entity-level granularity. Retrieval is served by GET_EVENT_INFO, GET_EVENT_STATUS, EVENT_EXISTS, and GET_ARRAY_EVENT_INFO. UPDATE_TRANSACTION_NUMBER manages the transaction number attribute introduced into XLA_ENTITIES. ALLOW_THIRD_PARTY_UPDATE governs whether externally sourced updates are permitted.

The history notes are relevant to the search term g_entity_id. In the 04-Mar-2002 revision, the condition entity_id = g_entity_id was added to all update APIs, and date validation was removed while event dates were truncated. This global variable scopes updates to the current entity, preventing cross-entity modification within a session. The 18-Mar-2002 revision converted bulk APIs to use a temporary table for performance.

Tables Accessed

The package reads and writes the principal XLA event and accounting tables. XLA_ENTITY_ID_MAPPINGS and XLA_ENTITY_TYPES_B resolve entity identity and type metadata, directly supporting the g_entity_id logic. XLA_DISTRIBUTION_LINKS, XLA_AE_HEADERS, XLA_AE_HEADER_ACS, XLA_AE_HEADER_DETAILS, XLA_AE_LINES, XLA_AE_LINE_ACS, XLA_AE_LINE_DETAILS, and XLA_AE_SEGMENT_VALUES are referenced during purge and event-status operations that cascade into accounting entries. XLA_ACCOUNTING_ERRORS is consulted for error state. GL_LEDGERS and GL_JE_BATCHES provide ledger and journal batch context. FND_APPLICATION_TL and FND_LANGUAGES supply translated application and language names.

Usage Notes

Because XLA_EVENTS_PKG is a private package, it should not be called directly from custom code; the supported entry point is XLA_EVENT_PUB_PKG, which wraps these routines. In standard operation the package is invoked indirectly by Subledger Accounting concurrent programs, such as event creation and accounting generation processes, and by subledger application logic during transaction processing. The absence of internal commits means calling programs must manage transaction boundaries, with period close being the documented exception. Reference in the ETRM metadata indicates the package is referenced by eight other packages, confirming its role as a foundational dependency within the XLA processing stack for both 12.1.1 and 12.2.2.