Search Results refresh_req_shadow

Overview

GHR_PROCESS_SF52 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the United States Federal Standard Form 52 (SF-52) personnel action process within Oracle Human Resources. SF-52 is the federal government's Request for Personnel Action, and the EBS implementation of this process requires a specialized engine to derive, validate, and persist personnel action data before it is routed for approval and eventually written to the HR tables. GHR_PROCESS_SF52 functions as that engine. It is responsible for building and maintaining the shadow record that represents an in-progress or pending SF-52 request, deriving pay and location columns, recalculating pay, and coordinating the family and nature-of-action routing logic that governs how a personnel action flows through the approval hierarchy. The package header is versioned ghproc52.pkh 120.0.12010000.2, last modified in August 2008, which places it in the 11i through 12.1.1 lineage and carried forward into 12.2.2. The API classification is OTHER, meaning it is an internal supporting utility rather than a public open interface, and the module exposes nineteen documented procedures and functions. The presence of the GHR_DUAL_ACTIONS and GHR_DUAL_PROC_METHODS tables indicates the package participates in dual processing logic, where an action is validated against both an original and a derived set of rules.

Key Procedures and Functions

• REFRESH_PA_REQUEST — synchronizes the GHR_PA_REQUESTS row for a person and effective date, optionally deriving the "to" columns from the "from" values.
• PROCESS_SF52 — the principal processing entry point that evaluates an SF-52 request record and applies the appropriate action logic.
• ASSIGN_NEW_RG — assigns a new grade or rate group to a personnel action request.
• COPY_2NDNOA_TO_1STNOA — copies second Nature of Action columns onto the first NOA columns.
• NULL_2NDNOA_COLS — clears the second Nature of Action columns.
• FETCH_EXTRA_INFO — retrieves SF-52 extra information rows from GHR_PA_REQUEST_EXTRA_INFO.
• GET_FAMILY_CODE — returns the family code associated with a given Nature of Action identifier.
• PROC_FUTR_ACT — processes future-dated personnel actions for a personnel office.
• ROUTE_INTERVN_FUTURE_ACTIONS — routes intervening future actions for a person and effective date.
• ROUTE_INTERVN_ACT_PEND_TODAY — routes intervening actions that are pending as of the current date.
• GET_PAR_AP_APUE_FIELDS — retrieves the PAR, AP, and APUE field values used in the action.
• DERIVE_TO_COLUMNS — derives destination column values from source values.
• REDO_PAY_CALC — recalculates pay for the request.
• REFRESH_REQ_SHADOW — refreshes the shadow request row.
• CREATE_SHADOW_ROW — creates the shadow row that holds the in-progress personnel action.
• UPDATE_RFRS_VALUES — updates refreshed values on the request.
• PRINT_SF52 — produces the printable SF-52 output.
• REINIT_DUAL_VAR — reinitializes dual processing variables.

Tables Accessed

The package reads and writes GHR_PA_REQUESTS, the master personnel action request table, and GHR_PA_REQUEST_SHADOW, which stores the working copy of an action before it is committed. GHR_PA_REQUEST_EXTRA_INFO supplies SF-52 specific supplemental attributes, while GHR_PA_HISTORY and GHR_PA_REMARKS capture audit trail and remark records. Configuration and reference data come from GHR_POIS, GHR_NATURE_OF_ACTIONS, GHR_NOA_FAMILIES, GHR_NOA_FAM_PROC_METHODS, GHR_FAMILIES, GHR_PA_DATA_FIELDS, GHR_DUAL_ACTIONS, and GHR_DUAL_PROC_METHODS. FND_SESSIONS provides session context, and FND_TERRITORIES_TL supplies territory descriptions for address related derivations.

Usage Notes

GHR_PROCESS_SF52 is normally invoked indirectly. It is called by the SF-52 form and by other HR packages; the metadata records that it is referenced by fifteen other packages, which is consistent with it serving as a shared processing layer rather than a standalone concurrent program. Customizations that need to create or refresh a shadow row should call CREATE_SHADOW_ROW and REFRESH_REQ_SHADOW rather than inserting into GHR_PA_REQUEST_SHADOW directly, because these procedures also maintain the derived columns, dual processing variables, and pay calculations. Because the package modifies shadow and request data, any direct invocation from custom code should be performed within a controlled transaction and validated using PROCESS_SF52 with the validate flag before committing.