Search Results fem_entity_types_tl

Overview

FEM_ENTITY_TYPES_PKG is an Oracle Enterprise Business Suite (EBS) PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API. It serves as the foundational data-access and maintenance layer for the FEM_ENTITY_TYPES entity type registry used by the Enterprise Resource Management (ETRM) / Financials Enterprise Management (FEM) modules. The package governs the definition of entity types that participate in the ETRM data model, controlling which entity types are enabled, personalized, or read-only, and maintaining their multilingual name and description translations.

Because entity type definitions are referenced by many downstream ETRM components — the metadata indicates this package is referenced by three other packages — the package acts as a controlled gateway for the creation, maintenance, deletion, and translation of these definitions. The package body adheres to Oracle's standard table-handling API conventions, separating the base entity (FEM_ENTITY_TYPES_B) from the translatable text (FEM_ENTITY_TYPES_TL) and applying the multilingual (MLS) pattern via FND_LANGUAGES.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions, all of which follow the standard Oracle EBS table-handling API blueprint:

• INSERT_ROW — Creates a new entity type definition. It inserts the base record into FEM_ENTITY_TYPES_B and, for each installed or base language in FND_LANGUAGES, inserts a corresponding translatable row into FEM_ENTITY_TYPES_TL. The procedure returns the ROWID of the newly created base row. The header revision ($Header: fem_enttype_pkb.plb 120.0) shows a 2005-era origin, placing it within the mature TER/ETRM code line.
• LOCK_ROW — Acquires a row-level lock on an entity type definition to support optimistic concurrency control before an update or delete, typically by selecting the row with a FOR UPDATE clause.
• UPDATE_ROW — Modifies an existing entity type definition, updating attributes such as the enabled flag, personal flag, read-only flag, and object version number in the base table, and following the MLS pattern for translatable attributes.
• DELETE_ROW — Removes an entity type definition from the base table and its associated translation rows, respecting referential dependencies.
• ADD_LANGUAGE — Adds a new language row to FEM_ENTITY_TYPES_TL for existing entity type definitions when a new language is installed into the application. This is a common MLS maintenance routine invoked after language installation.
• TRANSLATE_ROW — Updates or inserts the translated name and description for a specific entity type and language combination, supporting multi-language display in EBS forms.

Tables Accessed

The package references three tables via APPS synonyms:

• FEM_ENTITY_TYPES_B — The base (non-translatable) table storing the entity type code, enabled flag, personal flag, read-only flag, object version number, and standard WHO audit columns. This is the primary insert/update/delete target.
• FEM_ENTITY_TYPES_TL — The translation table storing the entity type name and description per language. The INSERT_ROW logic selects from FND_LANGUAGES where INSTALLED_FLAG is 'I' or 'B' and populates one TL row per language, using userenv('LANG') as SOURCE_LANG.
• FND_LANGUAGES — The Oracle Application Object Library languages table, read to determine which languages are installed and therefore which TL rows must be created during insert and ADD_LANGUAGE operations.

Usage Notes

This package is typically invoked by ETRM setup forms, concurrent programs, and custom extensions that need to manage entity type definitions consistently with Oracle's MLS and WHO auditing standards. Users searching for "fem_entity_types_tl" are generally working with the translation table directly, but modifications should be routed through this package (particularly INSERT_ROW, UPDATE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW) so that the base and translation tables remain synchronized and the standard who-columns are populated correctly. Direct DML against FEM_ENTITY_TYPES_TL is discouraged because it bypasses the package's language-coverage logic and can produce orphaned or missing translations. Because the package is referenced by other ETRM packages, changes to its behavior or to the underlying tables should be regression-tested against those dependents before deployment in either 12.1.1 or 12.2.2 environments.