Search Results fem_fundstatus_pkg

Overview

FEM_FUNDSTATUS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the maintenance of fund status reference data within the Enterprise Performance Foundation (now marketed as Oracle Financial Services Enterprise Performance Foundation, or ETRM in this documentation context). Fund status records identify the lifecycle classification assigned to a fund — for example, active, inactive, or closed — and are consumed by downstream profitability, allocation, and performance measurement processes that must distinguish between funds that are currently reporting and those that have been retired. The package follows the standard Oracle EBS table-handler design pattern, in which a single package encapsulates the insert, update, delete, locking, and translation operations for a base table and its translation table. In the 12.1.1 and 12.2.2 releases this object is documented as VALID with an API classification of OTHER, indicating that it is an internal support package rather than a formally published public API. Its presence in the ETRM dependency inventory confirms that it is a core, actively maintained component of the fund reference data layer.

Key Procedures and Functions

The package body exposes six documented procedures that together provide complete DML and translation control for the fund status entity:

• INSERT_ROW — Creates a new fund status definition, writing the base record into the primary table and the corresponding descriptive columns into the translation table.
• UPDATE_ROW — Modifies an existing fund status record, updating the base attributes and any changed translated values.
• DELETE_ROW — Removes a fund status definition, including its associated translation rows, from the underlying tables.
• LOCK_ROW — Acquires a row-level lock on a fund status record to enforce concurrency control while a form session or batch process holds the record for update.
• ADD_LANGUAGE — Installs translation rows for a newly enabled language, populating the TL table for existing fund status records.
• TRANSLATE_ROW — Maintains or updates the translated description of a fund status in a specific language.

Only the procedure and function names are documented; individual parameter signatures are not published in the ETRM metadata and should be confirmed against the deployed package specification in each environment.

Tables Accessed

The package operates against three tables, referenced through APPS synonyms:

• FEM_FUNDSTATUS_B — the base table holding the language-independent attributes of each fund status record.
• FEM_FUNDSTATUS_TL — the translation table holding language-specific descriptions, populated by ADD_LANGUAGE and TRANSLATE_ROW and maintained alongside INSERT_ROW and UPDATE_ROW.
• FND_LANGUAGES — the Oracle Application Object Library table of installed and enabled languages, used to determine which languages require translation rows.

Usage Notes

FEM_FUNDSTATUS_PKG is referenced by three other packages — FEM_FUNDSTATUS_DL, FEM_FUNDSTATUS_IL, and FEM_FUNDSTATUS_UL — which respectively provide the delete, insert, and update logic used by the EBS Forms layer for the Fund Status maintenance window. Consequently, the package is normally invoked indirectly: a user maintaining fund statuses through the ETRM setup responsibility triggers form-level DML that delegates to these wrapper packages and ultimately to FEM_FUNDSTATUS_PKG. The package may also be called from custom code or concurrent processing when fund status reference data must be loaded or synchronized programmatically, in which case callers should invoke the documented procedures within a properly managed transaction and respect the locking semantics enforced by LOCK_ROW. Because the object is classified as OTHER rather than a published API, Oracle does not guarantee signature stability, and any custom dependency on it should be validated after patching or upgrading between 12.1.1 and 12.2.2.