Search Results fem_dim_attributes_tl

Overview

FEM_DIM_ATTRIBUTES_PKG is a PL/SQL package that belongs to the Application Services (APPS) schema and supports the Oracle Enterprise Taxation and Regulatory Management (ETRM) / Enterprise Performance Foundation dimensional model. Its central responsibility is to maintain the definition of dimension attributes — the configurable descriptive properties that may be associated with the members of a dimension. The package provides a programmatic API for the creation, modification, locking, and deletion of attribute definitions, together with the multilingual maintenance routines required to keep translated attribute names and descriptions synchronized.

The package operates over both the base table FEM_DIM_ATTRIBUTES_B and its translation table FEM_DIM_ATTRIBUTES_TL, and it is the canonical insertion point cited whenever a search is performed for "fem_dim_attributes_tl". Users encountering that table name are typically looking for the package that populates or updates it, and FEM_DIM_ATTRIBUTES_PKG is that object. The package's presence in the ETRM API catalog, classified as OTHER, confirms it is an internal but reusable interface rather than a standalone concurrent program.

Key Procedures and Functions

• INSERT_ROW — Creates a new dimension attribute definition. It accepts the full complement of attribute metadata, including attribute identifier, dimension and attribute-dimension identifiers, data type code, value column name, ordering type, and the numerous Y/N flags governing multiple assignment, inheritance, report queryability, multiple versions, read-only status, personal attributes, and user assignment. It inserts the base row into FEM_DIM_ATTRIBUTES_B and returns the ROWID via an output parameter, and it also carries the attribute name and description destined for the translated table.
• LOCK_ROW — Obtains a row-level lock on an existing attribute definition, enforcing optimistic concurrency control during update or delete operations.
• UPDATE_ROW — Modifies an existing attribute definition, applying changes to the base row and preserving the audit columns (last update date, user, and login).
• DELETE_ROW — Removes an attribute definition, cascading logically to the associated translation rows.
• ADD_LANGUAGE — Inserts a new language row into FEM_DIM_ATTRIBUTES_TL for a specified language, seeding the translated name and description from the base, typically when a language is installed or enabled.
• TRANSLATE_ROW — Updates the translated name and description for a language that already exists in the translation table, supporting multilingual maintenance of attribute labels.

Tables Accessed

• FEM_DIM_ATTRIBUTES_B — The base table holding language-independent attribute definitions; the primary read/write target of INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW.
• FEM_DIM_ATTRIBUTES_TL — The translated table holding language-specific attribute names and descriptions; written by INSERT_ROW (initial translation), ADD_LANGUAGE, and TRANSLATE_ROW.
• FND_LANGUAGES — The Oracle Application Object Library language repository, consulted to determine installed and enabled languages when adding translations.

Usage Notes

The package is an internal API and is not ordinarily exposed as a standalone executable. It is invoked by the ETRM setup forms that administer dimensional attributes, by concurrent programs that install or propagate languages, and by other EBS packages. ETRM metadata indicates the package is referenced by four other packages, which means customizations should not alter the base table directly but should call these routines to preserve translation consistency and audit integrity. Developers extending ETRM dimensions should treat INSERT_ROW, UPDATE_ROW, and DELETE_ROW as the supported DML surface, and should pair every base-table operation with the appropriate translation routine so that FEM_DIM_ATTRIBUTES_TL remains aligned with FEM_DIM_ATTRIBUTES_B across all installed languages.