Search Results fem_datasets_ul

Overview

FEM_DATASETS_PKG is an Oracle E-Business Suite 12.1.1 and 12.2.2 PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM (Enterprise Territory and Resource Management) module. Its primary business function is to serve as the low-level data access and maintenance layer for dataset definitions used by ETRM. A "dataset" in this context represents a named grouping of dimension members or source data that drives analysis, territory assignment, and resource modeling within Oracle's Trade Management and related ETRM components. The package encapsulates the standard CRUD (Create, Read, Update, Delete) logic against the dataset base and translation tables, providing a controlled programmatic interface so that forms, concurrent programs, and dependent packages do not manipulate the underlying tables directly.

Key Procedures and Functions

The package exposes six documented procedures and functions, reflecting a conventional Oracle Forms-driven multi-language table pattern:

• INSERT_ROW — Creates a new dataset record, typically inserting the base definition row into the primary table and coordinating the corresponding translation row.
• LOCK_ROW — Acquires a row-level lock on an existing dataset record, used primarily by Oracle Forms to enforce optimistic concurrency control during an edit session.
• UPDATE_ROW — Modifies an existing dataset record, updating the relevant base and translation columns.
• DELETE_ROW — Removes a dataset record and its associated translation entries.
• ADD_LANGUAGE — Inserts translation rows for a newly installed or enabled language, ensuring the dataset's translatable attributes exist for all active languages.
• TRANSLATE_ROW — Writes or updates the translatable (language-specific) text attributes of a dataset, such as its display name and description.

No parameter lists are documented in the ETRM metadata, so calling conventions should be confirmed from the package specification in the target environment.

Tables Accessed

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

• FEM_DATASETS_B — The base table holding language-independent dataset attributes. It is the target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operations.
• FEM_DATASETS_TL — The translation table storing language-specific text for each dataset. It supports ADD_LANGUAGE and TRANSLATE_ROW, and is joined to the base table for display.
• FND_LANGUAGES — The Oracle Applications installed-languages table, read to determine which languages require translation rows and to validate language codes.

Usage Notes

FEM_DATASETS_PKG is referenced by five other database objects: FEM_DATASETS_DL, FEM_DATASETS_IL, FEM_DATASETS_UL (the dataset delete, insert, and update APIs respectively), FEM_DIMENSION_UTIL_PKG, and FEM_DIM_UTILS_PVT. This dependency pattern indicates the package is a foundational utility invoked by higher-level dataset APIs and dimension utilities rather than being called directly by end users. In practice it is most commonly exercised through the ETRM setup and administration forms, where the standard Forms block triggers call LOCK_ROW, INSERT_ROW, UPDATE_ROW, and DELETE_ROW as users maintain dataset definitions. Multi-language maintenance paths invoke ADD_LANGUAGE and TRANSLATE_ROW when translations are entered or a new language is enabled. Custom code should prefer the public dataset APIs (FEM_DATASETS_DL, _IL, _UL) over calling FEM_DATASETS_PKG directly, since the package performs no business validation beyond persistence and relies on callers to enforce data integrity rules.