Search Results fem_proptypes_dl

Overview

FEM_PROPTYPES_PKG is an Oracle Applications (APPS) PL/SQL package that belongs to the Enterprise Tax, Regulatory, and Reporting (ETRM) product family, specifically the Financial Enterprise Management (FEM) module. It serves as the low-level data maintenance layer for the FEM_PROPTYPES entity, which stores "property types" — the classification codes that describe the nature of a legal entity or organizational property used across Oracle Financials, intercompany, and consolidation processing. In the Oracle EBS 12.1.1 and 12.2.2 releases this package is documented with an API classification of OTHER, indicating that it is an internal, infrastructure-level package rather than a public or business-facing API. Its purpose is to provide standard row-level operations (insert, lock, update, delete) plus translation management over the base table and its translation table, so that higher-level views and forms can persist property type definitions in a consistent and language-aware manner.

Key Procedures and Functions

The ETRM documentation lists six procedures/functions for this package:

• INSERT_ROW — Creates a new property type record, writing the base definition into the base table and managing the associated translation entry.
• LOCK_ROW — Acquires a row-level lock on an existing property type so that concurrent update or delete operations cannot corrupt the record.
• UPDATE_ROW — Modifies the attributes of an existing property type row, preserving audit and translation integrity.
• DELETE_ROW — Removes a property type record (and, by extension, its translated descriptions) from the entity.
• ADD_LANGUAGE — Registers a new language row in the translation table for an existing property type, normally driven by an FND_LANGUAGES installation or language-addition concurrent process.
• TRANSLATE_ROW — Updates the translatable text columns (the description) for a specific property type and language without altering the base record.

Tables Accessed

The documented table dependencies are:

• FEM_PROPTYPES_B — the base table holding language-independent property type definitions.
• FEM_PROPTYPES_TL — the translation table storing language-specific descriptions, keyed by language.
• FND_LANGUAGES — the Oracle Applications language repository, consulted to validate or enumerate installed languages for the ADD_LANGUAGE operation.

This base/translation (B/TL) table pair is the standard Oracle EBS multilingual design pattern; the package abstracts both tables behind a single logical entity.

Usage Notes

FEM_PROPTYPES_PKG is not intended for direct invocation by end users or third-party customizations. The ETRM metadata shows it is referenced by three other APPS packages — FEM_PROPTYPES_DL (delete logic), FEM_PROPTYPES_IL (insert logic), and FEM_PROPTYPES_UL (update logic) — which form the standard "row handler" D/L/I/U utility stack generated for Oracle Forms-based maintenance screens. The package is therefore invoked indirectly, typically through an Oracle Forms block or a concurrent program that manages property type setup. Its only external dependencies are SYS.STANDARD and the referenced tables, confirming it contains no calls to unrelated business logic and is safe to treat as a contained data access routine. Because the documented API is limited to row-level DML and translation management, custom code needing robust error handling, concurrent-safe updates, or validation should call the higher-level DL/IL/UL wrappers rather than invoking this package directly.