Search Results pay_pyr_upd




Overview
Explore in AI Chat

Overview

PAY_PYR_UPD is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an API of type OTHER. Its name follows the Oracle Payroll naming convention in which the PAY_ prefix denotes the Payroll product and the _UPD suffix indicates an update-oriented utility. The package therefore serves as a low-level maintenance routine for payroll rate records, most directly for the PAY_RATES entity exposed through the PAY_PYR_SHD shared synonym.

The ETRM metadata records the package as VALID and documents two subobjects — the package specification and the package body — together with one callable entry point, the procedure UPD. The package references HR_API, the Human Resources public API layer, and the SYS.STANDARD package, confirming that it operates within the standard PL/SQL runtime and participates in the HR/Payroll integration boundary. Its dependency footprint is deliberately narrow: it is referenced by only one other package, HR_RATE_API, and it also appears in its own dependency list, indicating internal recursive or wrapper calls within the body.

Key Procedures and Functions

  • UPD — The single documented procedure in the package. Its purpose is to perform the update of payroll rate data on behalf of the calling layer. As implied by the package name and its position beneath HR_RATE_API, UPD encapsulates the DML logic required to modify existing rate rows rather than to create or delete them. No parameter list is documented in the ETRM extract, so the exact signature should be confirmed by inspecting the package specification in the database; callers should not assume argument order or defaults from documentation alone.

Because UPD is the only exposed subprogram recorded, the package should be treated as a focused, single-responsibility update utility rather than a general-purpose rate maintenance API. The absence of documented insert, delete, or query procedures reinforces that interpretation.

Tables Accessed

The only table documented for this package is PAY_RATES, reached through the APPS synonym PAY_PYR_SHD. PAY_RATES is the core Payroll repository for rate definitions — the basis, amount, and effective-dating attributes that drive element and assignment cost calculations. PAY_PYR_UPD reads and writes this table in order to apply the modifications requested by its caller. The dependency on HR_API further suggests that certain validation or business-rule checks surrounding the rate record are delegated to the HR API layer rather than being reimplemented inside this package, which keeps the update logic consistent with HR master data rules.

Usage Notes

PAY_PYR_UPD is an internal building block, not an end-user-facing interface. It is not invoked directly from a Payroll form or a seeded concurrent program; instead it is called by HR_RATE_API, which is the documented consumer of this package. The practical implication is that developers should call HR_RATE_API rather than PAY_PYR_UPD directly, preserving the layering that Oracle has established and insulating custom code from changes to the lower-level update routine.

When reviewing customizations that touch payroll rates, the recommended sequence is to locate the HR_RATE_API call, trace downward to PAY_PYR_UPD.UPD, and then inspect the package body for the specific DML and validation ordering. Because the package is documented as VALID in both 12.1.1 and 12.2.2 environments, behavior is expected to be consistent across those releases, though the ETRM entry provides no parameter documentation, so direct invocation from custom code should be preceded by a specification review and careful attention to commit and error-handling semantics.