Search Results fem_data_types_pkg




Overview
Explore in AI Chat

Overview

APPS.FEM_DATA_TYPES_PKG is a PL/SQL package owned by the APPS schema that provides the low-level data access and maintenance layer for data type definitions used by Oracle Enterprise Billing / Enterprise Resource and Territory Management (ETRM) applications in Oracle E-Business Suite 12.1.1 and 12.2.2. Data types in this context describe the classification applied to source and target objects (such as balances, amounts, and members) so that the ETRM engine can interpret, aggregate, and validate financial and analytical data consistently across the applications.

The package is documented as an OTHER classification object rather than a published public API, meaning it is intended primarily for internal consumption by the ETRM forms, listing/validation packages, and translation utilities. Its status is VALID, and it depends only on the SYS.STANDARD package, confirming that it is a self-contained DML and locking utility with no external library dependency beyond the PL/SQL runtime.

Key Procedures and Functions

  • INSERT_ROW — Creates a new data type definition row, inserting the base record into the base table and, where applicable, the corresponding translated description row.
  • LOCK_ROW — Acquires a row-level lock on an existing data type record to serialize concurrent modification, typically invoked before update or delete operations.
  • UPDATE_ROW — Modifies the attributes of an existing data type definition, writing changes to the base and translated tables.
  • DELETE_ROW — Removes a data type definition and its associated translation rows from the underlying tables.
  • ADD_LANGUAGE — Inserts translation rows for a newly installed or enabled language, ensuring every data type definition has a corresponding description record in FND_LANGUAGES-managed languages.
  • TRANSLATE_ROW — Updates the translated description text for an existing data type in a specific language.

All six procedures follow the standard Oracle Forms-generated table handler pattern: they encapsulate DML, WHO column maintenance, and language/translation handling so that the parent form blocks or helper packages do not issue raw SQL.

Tables Accessed

  • FEM_DATA_TYPES_B — The base table storing language-independent data type attributes (identifier, code, and related flags). INSERT_ROW, UPDATE_ROW, and DELETE_ROW operate here.
  • FEM_DATA_TYPES_TL — The translated table holding language-specific descriptions. It is written by INSERT_ROW, DELETE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW.
  • FND_LANGUAGES — The Oracle Application Object Library language repository, referenced to determine the set of installed/active languages when ADD_LANGUAGE seeds translation rows.

Usage Notes

FEM_DATA_TYPES_PKG sits beneath three dependent packages: FEM_DATA_TYPES_DL (detail/data listing), FEM_DATA_TYPES_IL (interaction/inquiry listing), and FEM_DATA_TYPES_UL (utility/update listing), plus self-reference. These dependents expose multi-row query and maintenance logic to the ETRM user interface and concurrent programs, while this package performs the atomic, single-row operations.

Typical invocation occurs indirectly: an ETRM setup or administration form calls the DL/IL/UL layers, which delegate INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, ADD_LANGUAGE, and TRANSLATE_ROW to this package. Concurrent programs and language-installation routines may call ADD_LANGUAGE directly. Because it is classified OTHER rather than a certified public API, custom code should avoid calling it directly; instead, use supported APIs or form-based maintenance. Any direct use must respect the package's locking contract (LOCK_ROW before UPDATE_ROW/DELETE_ROW) and preserve the alignment between the base and translated tables.