Search Results fem_ledgers_tl

Overview

The APPS.FEM_LEDGERS_PKG package body is a foundational data-access layer within the Oracle Enterprise Performance Foundation / Enterprise Tax Reporting and Management (ETRM) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the DML logic required to maintain the ledger registry that the ETRM applications rely upon to identify the accounting ledgers available for consolidation, transfer pricing, and reporting purposes. The package abstracts the underlying multi-language table design of the FEM schema, presenting a single entry point for creating, modifying, removing, and translating ledger definitions.

The package follows the standard Oracle Applications table-handler pattern, in which a base table (FEM_LEDGERS_B) stores language-independent attributes and a translation table (FEM_LEDGERS_TL) stores the descriptive, user-facing text per installed language. This design is the reason a search such as fem_ledgers_tl surfaces this package: the TL table is populated and maintained exclusively through this package's procedures rather than by direct DML.

Key Procedures and Functions

The package exposes six documented procedures:

• INSERT_ROW — Creates a new ledger definition. It inserts the language-independent row into the base table and then seeds translation rows into the translation table for every installed language, capturing the display name, description, language code, and source language.
• LOCK_ROW — Obtains a row-level lock on an existing ledger record, typically used by the calling form to guarantee optimistic concurrency before an update. It verifies that the row has not been modified by another session.
• UPDATE_ROW — Modifies the attributes and descriptive text of an existing ledger definition in both the base and translation tables.
• DELETE_ROW — Removes a ledger definition from the base and translation tables.
• ADD_LANGUAGE — Inserts translation rows into FEM_LEDGERS_TL for a newly installed language, backfilling descriptions for existing ledger records.
• TRANSLATE_ROW — Updates the translatable columns (ledger name and description) for a specific ledger in a specific language, supporting the Translation Editor and multilingual maintenance.

Tables Accessed

• FEM_LEDGERS_B — The base table holding non-translatable ledger attributes, including ledger identifier, display code, personal and read-only flags, enabled flag, object version number, and standard WHO audit columns. INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW operate against this table.
• FEM_LEDGERS_TL — The translation table holding LEDGER_NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG. All procedures that manage descriptive text write here.
• FND_LANGUAGES — Queried to enumerate installed or base languages (INSTALLED_FLAG in ('I','B')) so translation rows are created only for active languages, using USERENV('LANG') as the source language.

Usage Notes

This package is a private implementation package (API classification OTHER) rather than a public, customer-callable API. It is typically invoked indirectly by the ETRM ledger administration forms, by concurrent programs that maintain ledger metadata, and by other FEM packages — the ETRM metadata records that it is referenced by five other packages. Custom code should not call FEM_LEDGERS_PKG directly; instead, developers should route ledger maintenance through the supported public APIs or the standard application forms, because the package assumes the caller has already validated business rules, derived the object version number, and supplied WHO audit columns. Direct DML against FEM_LEDGERS_B or FEM_LEDGERS_TL should likewise be avoided, since the package enforces the base/translation consistency contract.