Search Results xla_descriptions_f_pkg




Overview
Explore in AI Chat

Overview

XLA_DESCRIPTIONS_F_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Subledger Accounting (XLA) product family and serves as the descriptions repository maintenance layer for the XLA_DESCRIPTIONS_B and XLA_DESCRIPTIONS_TL tables. The package encapsulates the DML operations and translation-management logic required to sustain descriptive text associated with subledger accounting entities, such as application accounting definitions, journal line types, and accounting method components. It is classified under the ETRM as an "OTHER" API, indicating that it is not part of the supported public application programming interface but is instead an internal infrastructure package invoked by XLA forms and concurrent processes. The object is reported with a status of VALID, confirming that it compiles successfully against the documented dependencies. No other database object in the APPS schema references this package, establishing it as a leaf-level utility rather than a shared service.

Key Procedures and Functions

The package body exposes six documented program units, all of which are procedures:

  • INSERT_ROW — Creates a new description record in the base table, together with its corresponding translated row where applicable.
  • LOCK_ROW — Acquires a row-level lock on an existing description record, supporting optimistic concurrency control during update or delete processing.
  • UPDATE_ROW — Modifies an existing description record and propagates changes to the associated translation rows.
  • DELETE_ROW — Removes a description record and its dependent translation entries.
  • ADD_LANGUAGE — Inserts a new language-specific row into the translation table, enabling the description to be presented in an additional language.
  • TRANSLATE_ROW — Populates or refreshes the translated description text for an existing language row.

These six units together implement the complete create, read, update, and delete lifecycle for bilingual description data, including language expansion and translation maintenance.

Tables Accessed

The package reads and writes four tables through APPS synonyms. XLA_DESCRIPTIONS_B is the base table holding language-independent description attributes and serves as the primary target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW. XLA_DESCRIPTIONS_TL is the translation table storing language-specific description text; it is written by ADD_LANGUAGE and TRANSLATE_ROW and is kept synchronized by the base-table DML procedures. FND_APPLICATION is queried to resolve the owning application identifier for description records and for validation of the application context. FND_LANGUAGES is queried to validate language codes and to support the installed-language checks required by ADD_LANGUAGE and TRANSLATE_ROW.

Usage Notes

XLA_DESCRIPTIONS_F_PKG is invoked from Oracle Forms and Oracle Application Framework pages that maintain subledger accounting description metadata, and it is also callable from concurrent programs and custom PL/SQL that need to create or modify descriptions without directly manipulating the underlying tables. The package depends on APP_EXCEPTION, FND_LOAD_UTIL, FND_LOG, FND_MESSAGE, and XLA_EXCEPTIONS_PKG for error raising, message retrieval, logging, and exception translation, and it therefore participates in the standard Oracle EBS error-handling and diagnostics framework. Because the package is documented as an OTHER API, developers should treat it as a supported-by-convention rather than a guaranteed-interface component; direct invocation is generally reserved for internal XLA code paths and upgrade or translation-loading utilities. When bulk-loading translated descriptions, ADD_LANGUAGE and TRANSLATE_ROW should be executed in the appropriate language context so that FND_LANGUAGES validation succeeds.