Search Results fem_object_types_pkg

Overview

FEM_OBJECT_TYPES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Enterprise Performance Foundation (now commonly referred to as the Financial Services Data Model / ETRM) infrastructure. Its business function is to manage the metadata that defines "object types" within the FEM data model. Object types provide the classification framework that identifies and categorizes the various business entities — such as ledgers, calendars, dimensions, and analytical structures — that participate in FEM-based processing. The package operates on the object type definition tables and their translation tables, making it a foundational metadata maintenance component rather than a transactional processing engine.

Per the documented metadata, the package is classified as OTHER in the ETRM API taxonomy, meaning it is not a public, end-user-facing extension API but rather an internal maintenance package. It is invoked by the object type data loader and interface packages, confirming its role as the persistence layer for object type records.

Key Procedures and Functions

The ETRM documentation lists six documented procedures and functions within FEM_OBJECT_TYPES_PKG. Their names reflect a standard Oracle Forms-style DML maintenance pattern:

• INSERT_ROW — Creates a new object type record in the base table, populating the definition and audit columns for a newly defined object type.
• LOCK_ROW — Acquires a row-level lock on an existing object type record, typically invoked ahead of an update to enforce concurrency control.
• UPDATE_ROW — Modifies the attributes of an existing object type record, applying changed definition values to the base table.
• DELETE_ROW — Removes an object type record from the base table, supporting retirement or cleanup of obsolete object type definitions.
• ADD_LANGUAGE — Establishes or registers a new language row for the translated (TL) side of the object type, enabling multi-language descriptions.
• TRANSLATE_ROW — Inserts or maintains translated description text for an object type in a specific language, supporting Oracle's MLS (Multi-Language Support) model.

These procedures collectively implement the standard CRUD and language-handling logic used by the object type maintenance forms and loaders.

Tables Accessed

The package references three tables through APPS synonyms:

• FEM_OBJECT_TYPES_B — The base table holding the core, language-independent object type definition records. This is the primary DML target for INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW.
• FEM_OBJECT_TYPES_TL — The translation table holding language-specific description text, written by ADD_LANGUAGE and TRANSLATE_ROW under the MLS model.
• FND_LANGUAGES — The Oracle Application Object Library languages table, queried to validate installed and active languages and to drive translation logic.

Usage Notes

FEM_OBJECT_TYPES_PKG is an internal, dependency-driven package. The documented dependency listing shows it is referenced by the data loader and interface packages FEM_OBJECT_TYPES_DL, FEM_OBJECT_TYPES_IL, and FEM_OBJECT_TYPES_UL, which indicates the typical invocation path: object type records are loaded or interfaced into the FEM repository through those packages, which in turn call the maintenance procedures here to persist the data. Direct customer invocation is uncommon; the package is normally reached through the FEM administrator setup forms that manage object types and their translations.

Because the procedures depend on FND_LANGUAGES for translation validation, they assume a standard Oracle Applications installation with the AOL schema available. Any custom code that calls these procedures directly should first ensure a matching language is installed and should respect the row-locking convention (LOCK_ROW before UPDATE_ROW or DELETE_ROW) to avoid concurrency conflicts. The package is present in both 12.1.1 and 12.2.2, with the documented status VALID.