Search Results pay_monetary_units_s

Overview

APPS.PAY_MONETARY_UNITS_PKG is a PL/SQL package body in the Oracle E-Business Suite Payroll (PAY) schema. It manages the definition and maintenance of monetary units — the currency-denominated pay elements used in payroll processing, such as coins, tokens, and other cash-equivalent denominations that appear in monetary unit calculations. The package is classified as an OTHER API in the ETRM metadata, indicating it is a general-purpose data maintenance package rather than a formal public application programming interface, though it exposes a structured set of DML, validation, and translation procedures.

The package operates on a base/translation table pair (PAY_MONETARY_UNITS and PAY_MONETARY_UNITS_TL) with a language-independent _S table and a coin analysis element mapping table, giving it a standard multilingual, multi-organization data model footprint. Its status is VALID in both 12.1.1 and 12.2.2.

Key Procedures and Functions

Thirteen documented procedures/functions comprise the package surface:

• POP_FLDS — populates the field variables for monetary unit form or record handling.
• CHK_UNQ_ROW — enforces uniqueness of a monetary unit row prior to insert or update.
• GET_ID — returns the identifier for a monetary unit record.
• STB_DEL_VALID — performs delete validation (set-based deletion validity check).
• INSERT_ROW — inserts a new monetary unit record, applying defaulting and validation.
• LOCK_ROW — acquires a row-level lock for concurrency control during updates.
• UPDATE_ROW — updates an existing monetary unit record.
• DELETE_ROW — deletes a monetary unit record.
• ADD_LANGUAGE — inserts translation rows for a new language into the _TL table.
• TRANSLATE_ROW — retrieves the translated row for a given language.
• LOAD_ROW — loads a row with all associated translated and language-independent attributes.
• SET_TRANSLATION_GLOBALS — sets global translation context variables (language, territory, organization) used by the translation procedures.
• VALIDATE_TRANSLATION — validates translation data prior to commitment.

Tables Accessed

• PAY_MONETARY_UNITS — the base (language-independent) monetary unit definition table; primary DML target.
• PAY_MONETARY_UNITS_S — the dated/surrogate key table used by the package's concurrency and ID logic.
• PAY_MONETARY_UNITS_TL — the translation table holding language-specific names and descriptions.
• PAY_COIN_ANAL_ELEMENTS — maps monetary units (coins) to analysis elements for payroll costing and reporting.
• FND_LANGUAGES — supplies installed language definitions for the translation procedures.
• PER_ORGANIZATION_UNITS — provides organization-unit context for validation.
• FND_TERRITORIES_VL — territory (country/currency) validation.
• Also referenced: FND_GLOBAL, FND_MESSAGE, HR_API, HR_GENERAL2, HR_UTILITY, APP_EXCEPTION, and DUAL.

Usage Notes

PAY_MONETARY_UNITS_PKG is not referenced by any other database object in the documented dependency set, so it is invoked directly by the Oracle Payroll forms and concurrent programs that maintain monetary unit setup (typically Payroll Manager / Setup responsibilities), and potentially by custom deployment scripts. The ADD_LANGUAGE, TRANSLATE_ROW, LOAD_ROW, SET_TRANSLATION_GLOBALS, and VALIDATE_TRANSLATION procedures follow the standard EBS seed-data / translation-loading pattern and are commonly driven by the "Load Row" and "Translate Row" actions on the maintenance form. Because the package is flagged OTHER rather than a supported public API, custom code that calls it directly should expect interface stability to follow the underlying form behavior rather than a published API guarantee. Callers should typically invoke GET_ID or LOCK_ROW before UPDATE_ROW or DELETE_ROW to satisfy the package's concurrency expectations.