Search Results ghr_sf52_api




Overview
Explore in AI Chat

Overview

GHR_SF52_API is a PL/SQL API package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle HRMS family of modules and, more specifically, to the Oracle Advanced Benefits / Standard Form 52 (SF52) functionality used by U.S. federal public-sector customers. Standard Form 52 is the U.S. Office of Personnel Management (OPM) form used to request personnel actions such as appointments, promotions, reassignments, and separations. The package encapsulates the business logic required to create, modify, end, and cancel SF52 personnel action requests within the Oracle HRMS application. It acts as the primary programmatic gateway to the GHR_PA_REQUESTS base table and its associated remark, routing, and extra-information tables, shielding callers from the underlying data model. The package is classified as an API in the ETRM documentation and is marked VALID in the APPS schema. Its dependencies include the HR_API utility package and the STANDARD SYS package, confirming that it enforces Oracle HRMS API conventions such as row locking, date-tracked validity, and standardized error handling.

Key Procedures and Functions

The documented interface exposes eight procedures:

  • CREATE_SF52 — Creates a new SF52 personnel action request record, establishing the base request in GHR_PA_REQUESTS and any dependent detail rows.
  • UPDATE_SF52 — Modifies an existing SF52 request, supporting changes to request attributes and associated information.
  • END_SF52 — Logically ends an active SF52 request, closing it out in the request lifecycle.
  • CANCEL_CANCOR — Handles cancellation of cancelled-original (CANCOR) requests, reversing or voiding a previously cancelled action.
  • SUBMIT_REQUEST_TO_PRINT_50 — Submits an SF52 request to the SF50 (Notification of Personnel Action) printing process.
  • GET_PAR_STATUS — Returns the current status of a personnel action request for validation or display purposes.
  • CHECK_FOR_OPEN_EVENTS — Determines whether open events exist that would block or affect the request being processed.
  • UPDATE_DETAIL_REMARKS — Maintains the remark lines attached to an SF52 request.

Parameter lists are not enumerated in the documented metadata and should be confirmed against the package specification in the target environment.

Tables Accessed

The package reads and writes a broad set of HRMS tables, primarily through APPS synonyms: GHR_PA_REQUESTS (the core personnel action request header), GHR_PA_REMARKS and GHR_PA_REMARKS_S (remark lines and their translations), GHR_REMARKS, GHR_NOAC_REMARKS and GHR_NOA_FAMILIES (notification-of-action remarks), GHR_PA_REQUEST_EXTRA_INFO and GHR_PA_REQUEST_INFO_TYPES (flexible extra attributes), GHR_PA_ROUTING_HISTORY and GHR_ROUTING_LIST_MEMBERS (approval and routing), GHR_EVENT_HISTORY (lifecycle event tracking), GHR_FAMILIES and GHR_GROUPBOXES (configuration metadata), FND_USER (requesting user identity), and HR_ALL_POSITIONS_F (position validation). These tables support the full SF52 lifecycle from creation through routing, printing, and archival.

Usage Notes

GHR_SF52_API is invoked primarily by the SF52/Notification of Personnel Action forms and by concurrent programs that process personnel actions in batch. It is referenced by eleven other packages including GHR_APPROVED_PA_REQUESTS, GHR_CORR_CANC_SF52, GHR_MASS_AWARDS_PKG, GHR_MASS_CHANGES, GHR_PROC_FUT_MT, GHR_SF52_POST_UPDATE, GHR_WF_WGI_PKG, and GHR_WGI_PKG, demonstrating its role as a low-level service used across mass processing, workflow, and post-update routines. Custom code should call these API procedures rather than performing direct DML against GHR_PA_REQUESTS to preserve validation, routing, and audit integrity.