Search Results fem_entity_types_pkg




Overview
Explore in AI Chat

Overview

APPS.FEM_ENTITY_TYPES_PKG is a PL/SQL package belonging to the Enterprise Tax, Regulatory, and Reporting (ETRM / FEM) product family in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its purpose is to encapsulate the data manipulation logic for the entity type definition used by the FEM (Financial Enterprise Management) applications. An entity type describes a category of organizational unit that the ETRM engine can recognize and process, such as a legal entity, balancing segment, or management segment. Maintaining consistent, validated access to this metadata is essential because entity types drive how transactions, balances, and reporting hierarchies are interpreted across the ETRM data model.

The package is a standard Oracle Forms-style table handler: it provides the four CRUD entry points (INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW) plus a base-table maintenance pair (ADD_LANGUAGE, TRANSLATE_ROW) for the translated (TL) table. It is classified as OTHER in ETRM documentation, meaning it is an internal supporting package rather than a public integration API.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new entity type definition into the base table, populating the WHO columns and identity information required for a new record.
  • LOCK_ROW — Issues a locking read (SELECT ... FOR UPDATE) against the entity type row so that concurrent sessions cannot modify it while the caller is editing, providing optimistic-control semantics typical of Oracle Forms.
  • UPDATE_ROW — Modifies an existing entity type definition, refreshing the audit WHO columns on the base record.
  • DELETE_ROW — Removes an entity type definition from the base table.
  • ADD_LANGUAGE — Inserts a new language row into the translated table for an entity type, supporting the multi-language requirement of ETRM definitions.
  • TRANSLATE_ROW — Updates the translatable descriptive columns (name/description) in the TL table for a specified language. (Note: these two procedures are not listed among the documented metadata; they are inferred from the naming convention of companion FEM packages.)

Tables Accessed

The package references the following objects through APPS synonyms:

  • FEM_ENTITY_TYPES_B — The base ("B") table holding the language-independent columns of each entity type. This is the primary write target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • FEM_ENTITY_TYPES_TL — The translation ("TL") table storing language-specific name and description text. ADD_LANGUAGE and TRANSLATE_ROW operate here.
  • FND_LANGUAGES — The Oracle Application Object Library reference table of installed/available languages, consulted to validate the language code supplied to the translation procedures.

All three are accessed via APPS synonyms; the package itself is owned by the APPS schema and depends on the SYS.STANDARD package supplied by the PL/SQL runtime.

Usage Notes

FEM_ENTITY_TYPES_PKG is primarily invoked from the ETRM maintenance forms that administer entity type definitions, where Oracle Forms triggers call LOCK_ROW during a query/update cycle and INSERT_ROW, UPDATE_ROW, or DELETE_ROW on commit. Concurrent programs and the ETRM loaders may also call it when seeding or migrating entity type metadata.

The package is referenced by three other packages — FEM_ENTITY_TYPES_DL, FEM_ENTITY_TYPES_IL, and FEM_ENTITY_TYPES_UL — which represent the delete, insert, and update loader layers respectively. These loaders hide the PKG from external consumers, so customizations should target the loader or the base tables rather than calling FEM_ENTITY_TYPES_PKG directly. Because the API classification is OTHER, Oracle does not guarantee backward compatibility of its signatures across EBS upgrades; review dependencies before patching in 12.1.1 or 12.2.2 environments.