Search Results pop_flds

Overview

APPS.PAY_MONETARY_UNITS_PKG is a PL/SQL package in the Oracle E-Business Suite Payroll (PAY) product that manages the PAY_MONETARY_UNITS entity and its translated and audit-shadow counterparts. The package provides the programmatic interface through which Oracle EBS maintains the definition of monetary units — the graded denominations (for example, a currency's minor units or legislative subdivisions) tracked against a currency code, business group, and legislation code, each carrying a relative value, name, and descriptive comments. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling schema, and its header identifies it as an auto-generated-style table handler (pymon01t.pkh) that combines validation routines, key generation, and the standard INSERT/UPDATE/LOCK/DELETE row operations used by Oracle Forms and multilanguage seed data tooling.

Key Procedures and Functions

• POP_FLDS — Populates defaulted or derived field values for the monetary unit record, keying off a territory code and returning or adjusting the country value. This is the routine most directly relevant to the searched term "pop_flds".
• CHK_UNQ_ROW — Validates uniqueness of a monetary unit row, checking currency code, unit name, business group, and (optionally) legislation code and relative value, while excluding the current row via its rowid.
• GET_ID — Retrieves or generates the monetary unit identifier, returning it through an IN OUT parameter.
• STB_DEL_VALID — Determines whether the specified monetary unit row is eligible for deletion, preventing removal of records still referenced elsewhere.
• INSERT_ROW — Inserts a new monetary unit record, capturing the rowid, surrogate key, currency code, business group, legislation code, relative value, comments, and unit name, plus standard WHO audit columns.
• LOCK_ROW — Issues the locking read used for optimistic concurrency control before an update.
• UPDATE_ROW — Updates the mutable attributes and audit columns of an existing monetary unit record.
• DELETE_ROW — Deletes a monetary unit record by its identifier.
• ADD_LANGUAGE — Inserts translation rows for languages missing entries for monetary units, supporting the MLS (Multi-Language Support) model.
• TRANSLATE_ROW — Applies translated values for a monetary unit during language installation or upgrade seed-data loading.
• LOAD_ROW — Loads monetary unit definition rows, typically during seed data or upgrade processing.
• SET_TRANSLATION_GLOBALS — Sets the global context (language and related variables) used by the translation routines.
• VALIDATE_TRANSLATION — Verifies the consistency of translation data for monetary units.

Tables Accessed

• PAY_MONETARY_UNITS — The base table holding monetary unit definitions and audit columns.
• PAY_MONETARY_UNITS_TL — The translated table storing language-specific attributes such as unit name and relative value.
• PAY_MONETARY_UNITS_S — The MLS shadow table that tracks translation definition state.
• PAY_COIN_ANAL_ELEMENTS — Referenced for validation, reflecting the association of monetary units with coin analytic elements.
• FND_LANGUAGES — The installed-language repository used by ADD_LANGUAGE and the translation routines to determine which languages require translation rows.

Usage Notes

PAY_MONETARY_UNITS_PKG is normally invoked indirectly. The POP_FLDS, CHK_UNQ_ROW, LOCK_ROW, INSERT_ROW, UPDATE_ROW, and DELETE_ROW routines follow the Oracle Forms table-handler pattern and are typically called from the Payroll monetary unit maintenance form or equivalent UI. GET_ID and STB_DEL_VALID support key assignment and delete validation. The translation and loading procedures (ADD_LANGUAGE, TRANSLATE_ROW, LOAD_ROW, SET_TRANSLATION_GLOBALS, VALIDATE_TRANSLATION) are invoked by MLS installation, language patching, and seed-data upgrade processes rather than by end users. No other package in the EBS schema is documented as referencing it, so custom code that manipulates monetary units should call these procedures directly and should preserve the WHO audit columns and MLS row consistency rules that the package enforces.