Results for “xla_event_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XLA_EVENT_TYPES_F_PKG is the Forms PL/SQL wrapper for the Subledger Accounting event type definition entity, generated from the XLAUTB table-based form definition. In Oracle EBS 12.1.1 and 12.2.2, Subledger Accounting (SLA) organizes accounting rules by application, entity, event class, and event type. The event type is the most granular of these, identifying the specific business action — an invoice validation, a payment creation, a receipt application — for which journal entries are generated.

The package maintains the definitional and descriptive attributes of those event types within the XLA_EVENT_TYPES_B and XLA_EVENT_TYPES_TL tables. Because the object is a Forms wrapper rather than a public business API, its procedures mirror the DML operations that the Subledger Accounting event type setup form issues when a user creates, queries, updates, or deletes an event type. Its header indicates generation from the Oracle Application Object Library table-driven form generator, and its ownership resides with APPS.

Key Procedures and Functions

The documented procedures correspond to the standard insert, lock, update, and delete operations of a Forms block, together with multi-language management routines.

• INSERT_ROW — Inserts a new event type row, accepting the application identifier, entity code, event class code, and event type code along with the accounting flag, tax flag, enabled flag, name, description, and standard WHO audit columns.
• LOCK_ROW — Selects an existing event type row with locking semantics so the form can detect concurrent modification before permitting an update.
• UPDATE_ROW — Modifies the descriptive and flag attributes of an existing event type identified by its four-part key, stamping the last update date, user, and login.
• DELETE_ROW — Removes an event type identified by application, entity, event class, and event type code.
• ADD_LANGUAGE — Creates translated rows in the translation table for a specified language.
• LOAD_ROW — Loads or refreshes a row from seed data, supporting the standard Oracle seeding mechanism.
• TRANSLATE_ROW — Populates translatable descriptive attributes for a given language.

Tables Accessed

The package operates against the base and translation tables of the event type entity, plus the standard Oracle reference tables used for validation and translation.

• XLA_EVENT_TYPES_B — The base table holding the non-translatable attributes and flags of each event type.
• XLA_EVENT_TYPES_TL — The translation table holding language-specific name and description values managed by ADD_LANGUAGE and TRANSLATE_ROW.
• FND_APPLICATION — The application registry, referenced to resolve and validate the owning application identifier.
• FND_LANGUAGES — The language registry, referenced to validate the language used by the translation routines.

Usage Notes

This package is invoked indirectly through the Subledger Accounting event type setup form and, in some implementations, through the Oracle seeding and translation utilities that call LOAD_ROW, ADD_LANGUAGE, and TRANSLATE_ROW. It is not intended as a supported integration API for external accounting data. Two other packages reference it, indicating its role as a supporting component within the SLA setup layer.

Custom code should avoid calling these procedures directly because no concurrency or validation guarantees are published beyond those the form itself requires. When event types must be created or changed programmatically, the appropriate approach is to use the documented Subledger Accounting setup APIs or the supported data-loading interfaces. Direct manipulation of XLA_EVENT_TYPES_B and XLA_EVENT_TYPES_TL through this wrapper bypasses any higher-level validation that the SLA accounting engine expects.