Search Results pay_pgr_upd




Overview
Explore in AI Chat

Overview

PAY_PGR_UPD is an Oracle Applications (APPS) schema PL/SQL package that belongs to the Oracle Payroll product family and operates within the grade/grade-rule rate configuration area of Oracle E-Business Suite. Its classification under ETRM is "OTHER," indicating it is an internal worker or helper package rather than a public, supported API intended for external integration. The package exists to apply changes to payroll grade rules and their associated rate values through the Payroll Grade Rules shadow entity, PAY_PGR_SHD, which is maintained as part of the HR/Payroll date-tracked ("datetrack") infrastructure.

Functionally, PAY_PGR_UPD encapsulates the update logic used when grade rule records must be created, modified, or end-dated in a controlled manner. Rather than exposing direct DML against the underlying table, the package works in conjunction with the shadow table and the HR_API utility package, which together enforce the datetrack and validation rules that Oracle HRMS requires for effective-dated payroll configuration data. The metadata confirms the package status as VALID in the ETRM registry for both 12.1.1 and 12.2.2, and identifies PAY_GRADE_RULES_F as the base table reached through APPS synonyms.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within this package:

  • UPD — The sole documented procedure/function. Based on the package name and the shadow-table architecture it participates in, UPD serves as the update entry point for grade rule records, applying the supplied grade rule changes and coordinating the corresponding shadow-table maintenance. ETRM does not publish the parameter list for this procedure, and it must not be assumed; integrators should inspect the packaged code or the system's data dictionary before attempting any invocation.

No other procedures or functions are documented in the ETRM metadata, although the package body may contain additional private helpers that are not exposed in the registry.

Tables Accessed

The documented table accessed by PAY_PGR_UPD is:

  • PAY_GRADE_RULES_F — The grade rules base table, referenced through the APPS synonym. This is the persistent store for payroll grade rule definitions, and it is the object that UPD ultimately affects. Because the package is coupled to PAY_PGR_SHD, the shadow table for the same entity, it is reasonable to expect that reads and writes occur against PAY_GRADE_RULES_F in the datetrack-aware pattern used throughout HRMS payroll configuration tables.

The dependency listing additionally shows that PAY_PGR_UPD references HR_API and STANDARD, and that it references PAY_PGR_SHD. HR_API supplies the shared HR datetrack and business-group validation routines; PAY_PGR_SHD supplies the shadow-table interface that keeps the base table and its effective-dated history in step.

Usage Notes

PAY_PGR_UPD is not a standalone, user-invocable API. It is referenced by HR_RATE_VALUES_API, the public API for rate value maintenance, and by itself, which indicates that rate value processing can drive grade rule updates indirectly. In practice this means the package is invoked during payroll configuration maintenance — for example when grade rates or grade rule values are amended through the Oracle HRMS forms, or when HR_RATE_VALUES_API is called by a concurrent program or by custom code that performs supported rate value maintenance.

Because ETRM classifies this package as OTHER and does not publish its signature, custom development should not call PAY_PGR_UPD directly. The supported route is to use HR_RATE_VALUES_API, which the package supports, so that datetrack validation, business group security, and shadow-table consistency are preserved. Any direct invocation risks bypassing the effective-date logic that the Payroll Grade Rules infrastructure depends on, and could leave PAY_GRADE_RULES_F and PAY_PGR_SHD out of synchronization.