Search Results ghr_sf52_update




Overview
Explore in AI Chat

Overview

GHR_SF52_UPDATE is an Oracle EBS Human Resources (HR) package owned by the APPS schema and classified under the "OTHER" API category in Oracle's E-Business Suite Technical Reference Manual (ETRM) for release 12.2.2. The "SF52" prefix references the Oracle HRMS Statement of Earnings / pay-slip style reporting form (typically associated with the "SF52" legislative/statutory pay statement used in certain localizations), and the package's role is to support the update and recalculation of pay-related request records associated with that process. The package header, last modified under the 120.0.12010000.1 version stamp dated 2008/07/28, is a thin public interface exposing a single entry point (MAIN) that performs the substantive processing.

The package operates on HRMS "PA" (Payroll/Assignment) request data, taking a PA request row and its associated extra-information records as input/output parameters, and recalculating or updating derived values such as capped other pay. It is an internal Oracle-owned utility rather than a published public API, and is intended to be invoked by the HRMS engine (for example, the associated form or concurrent process) rather than by customer code.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure:

  • MAIN — The single documented entry point of the package. It accepts an in/out reference to a GHR_PA_REQUESTS row, extra-information records for the PA request, a generic extra-information record, and an optional capped-other-pay amount, and performs the core update logic. As an in out NOCOPY parameter, the PA request record is modified in place by the procedure and returned to the caller.

No public functions are documented. All other logic within the package body is private and not exposed through the package specification.

Tables Accessed

The package reads and writes the following tables via APPS synonyms, as documented in the ETRM:

Usage Notes

GHR_SF52_UPDATE is an internal HRMS component, not a supported public API. It is referenced by two other packages within the APPS schema, which typically invoke MAIN to perform the pay-request update as part of a broader HR/payroll flow. In practice it is triggered from the Oracle HRMS form or concurrent program processing the SF52 statement, rather than being called directly by customers.

Because the parameters include NOCOPY in/out records, the procedure mutates the caller's PL/SQL record, so integrators must not assume the input rows remain unchanged. The presence of the optional p_capped_other_pay parameter indicates that callers may optionally supply a cap value to be applied during recalculation. Customers requiring similar functionality should rely on Oracle's supported HRMS public APIs and concurrent programs, treating GHR_SF52_UPDATE as an internal implementation detail subject to change between patch levels.