Search Results fem_proptypes_tl

Overview

APPS.FEM_PROPTYPES_PKG is the property type maintenance package within the Oracle Enterprise Taxonomy and Reference Model (ETRM) subsystem of Oracle E-Business Suite. ETRM provides the reference data foundation used by Oracle Financial Services and related analytical applications, defining the hierarchies, members, and classifications that drive balances, reporting, and consolidation. The property_type_code identifier supported by this package represents the key column of the property type reference data: a property type classifies attributes assigned to financial or analytical members, controlling whether those attributes are enabled, personal (user-defined), or read-only.

The package body provides the standard Oracle Forms-generated data maintenance API pattern: insert, lock, update, delete, and translation management for the underlying base and translation tables. It is classified as an OTHER API in ETRM 12.1.1 and is referenced by three other packages, indicating that property type rows may be seeded or consumed programmatically by dependent ETRM components during setup and administration.

Key Procedures and Functions

The documented package exposes six procedures:

• INSERT_ROW — Creates a new property type. It inserts the base-language row into FEM_PROPTYPES_B, including the enabled, personal, and read-only flags, object version number, and WHO audit columns, then inserts the translatable description and name into FEM_PROPTYPES_TL for every installed language, and returns the new ROWID to the caller.
• LOCK_ROW — Acquires a row-level lock against the property type so that a form or calling process can perform a read-modify-write cycle without concurrency conflicts.
• UPDATE_ROW — Modifies the attributes and descriptive fields of an existing property type across both the base and translation tables.
• DELETE_ROW — Removes a property type and its associated translation rows.
• ADD_LANGUAGE — Inserts translation rows for a newly installed language, propagating existing property type definitions so they remain available to users of that language.
• TRANSLATE_ROW — Updates the translatable name and description of a property type for a specific language, without altering the base record.

Tables Accessed

Three tables are referenced through APPS synonyms:

• FEM_PROPTYPES_B — The base table holding operational, language-independent property type attributes. INSERT_ROW writes here, and the package's cursor reads ROWID from this table to return the new row identifier.
• FEM_PROPTYPES_TL — The translation table storing language-specific property type name and description. INSERT_ROW populates it for all installed languages by querying FND_LANGUAGES, and it is the target of ADD_LANGUAGE and TRANSLATE_ROW.
• FND_LANGUAGES — The Oracle Application Object Library language registry. INSERT_ROW joins to it, selecting only languages with INSTALLED_FLAG in ('I','B'), and uses USERENV('LANG') to set SOURCE_LANG so that the correct translation source is recorded.

Usage Notes

FEM_PROPTYPES_PKG is characteristically invoked from the ETRM property type maintenance form, where Oracle Forms calls INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW in response to user actions. ADD_LANGUAGE is normally executed by the language installation utilities, such as the multilingual installation or NLS upgrade process, whenever a new language is enabled. TRANSLATE_ROW is used by the translation entry form and by translation-upload concurrent programs. Custom code should avoid direct DML against FEM_PROPTYPES_B and FEM_PROPTYPES_TL and instead call these procedures to ensure object version numbers, WHO audit columns, and translation rows remain consistent. Because other ETRM packages depend on the property type reference data, new values should be created through INSERT_ROW before any dependent configuration references the property_type_code.