Results for “xla_event_class_grps”

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

Overview

The XLA_EVENT_CLASS_GRPS_F_PKG package is the Forms PL/SQL wrapper for the XLA_EVENT_CLASS_GRPS entity within the Oracle E-Business Suite Subledger Accounting (XLA) module. Subledger Accounting relies on event class groups to organize and categorize the accounting events generated by subledger transactions, such as invoices, payments, receipts, and journal entries. An event class group defines a logical grouping of related event classes and controls attributes such as the group name, description, and enabled status.

This package provides the standard Forms-level data manipulation interface for maintaining records in the underlying XLA_EVENT_CLASS_GRPS_B and XLA_EVENT_CLASS_GRPS_TL tables. It was generated from the XLAUTB table definition, as indicated by the header history, and follows the Oracle Applications conventions for Forms-generated PL/SQL wrappers, exposing insert, lock, update, delete, language maintenance, and multi-language loading and translation routines. Business users interact with these operations indirectly through the Subledger Accounting setup forms rather than by invoking the package directly.

Key Procedures and Functions

• INSERT_ROW — Creates a new event class group record, accepting the primary key components, descriptive attributes, and the standard WHO audit columns. Returns the ROWID of the newly inserted row.
• LOCK_ROW — Obtains a row-level lock on an existing event class group record to support optimistic concurrency control during a Forms transaction.
• UPDATE_ROW — Modifies the descriptive and enabled-status attributes of an existing event class group, together with the audit columns tracking the last update.
• DELETE_ROW — Removes an event class group record identified by its application and event class group code.
• ADD_LANGUAGE — Inserts missing translation rows into the translated (TL) table for languages that do not yet have entries for existing base records.
• LOAD_ROW — Loads a single event class group record using application short name and group code rather than numeric identifiers, supporting data migration and seed data loading.
• TRANSLATE_ROW — Loads or updates translated name and description values for a given event class group in a target language.

Tables Accessed

• XLA_EVENT_CLASS_GRPS_B — The base table storing the language-independent attributes of each event class group, including application, group code, enabled flag, and audit columns.
• XLA_EVENT_CLASS_GRPS_TL — The translation table holding the language-specific name and description values for each event class group.
• FND_APPLICATION — Consulted to resolve the application short name to the numeric application identifier used in LOAD_ROW and TRANSLATE_ROW.
• FND_LANGUAGES — Used by ADD_LANGUAGE and TRANSLATE_ROW to determine the installed and active languages for which translation rows must exist.

Usage Notes

This package is primarily invoked by the Oracle Forms-based Subledger Accounting setup user interface when administrators define or maintain event class groups. The INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW procedures map directly to form-level block operations, while ADD_LANGUAGE, LOAD_ROW, and TRANSLATE_ROW support multi-language deployment and data loading activities.

The package is referenced by one other database package according to the documented metadata, indicating that some programmatic consumers depend on it rather than the underlying base-table APIs. Custom development should generally avoid calling this Forms wrapper directly and instead use the supported XLA public APIs, since the wrapper performs no business validation beyond that required by the form. As the wrapper is generated from XLAUTB, any change to the base table structure would normally be reflected through regeneration of this package.