Results for “ghr_sf52_post_update”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_SF52_POST_UPDATE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM registry as an "OTHER" API. It belongs to the Oracle Human Resources (HR) family of packages, as indicated by the "GHR" prefix, and specifically supports the processing of SF-52 personnel action requests. An SF-52 is the United States federal government form used to request personnel actions such as appointments, promotions, reassignments, and separations. Within Oracle EBS, this package encapsulates the business logic required to post, cancel, or defer those personnel action requests after they have been approved within the HR workflow.

The package is declared with AUTHID CURRENT_USER, meaning its executable privileges are determined by the invoking user's schema rather than the package owner. This design is common for shared HR APIs that must respect the security context of the calling session, particularly in multi-organization or restricted-access government deployments.

Key Procedures and Functions

The ETRM metadata documents four public programs within this package:

• POST_SF52_PROCESS — The primary posting routine. It applies an approved SF-52 personnel action request to the HR schema, updating the affected assignment and position records according to the requested action, effective date, and position and agency parameters.
• POST_SF52_CANCEL — Handles the cancellation path of an SF-52 request. It reverses or voids a previously submitted or posted action, preserving the integrity of the underlying assignment and position data.
• POST_SF52_FUTURE — Manages future-dated SF-52 actions, allowing personnel changes to be staged so they take effect on a later effective date rather than immediately.
• GET_NOTIFICATION_DETAILS — A query routine that retrieves notification-related attributes for a given personnel action request, including agency codes, agency descriptions, office symbols, and personnel office identifiers. It populates output parameters used to construct workflow notifications and approval routing.

These programs accept parameters such as the personnel action request identifier, effective date, and an in-out object version number used for optimistic locking. The exact parameter lists are documented in the package specification and must be referenced directly when integrating.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• GHR_PA_REQUESTS — The master personnel action request table; the row type of this table is passed into POST_SF52_PROCESS as a parameter.
• GHR_PA_NOTIFICATIONS_S — Stores workflow notification records tied to personnel actions.
• GHR_PA_REQUEST_EXTRA_INFO — Holds supplementary, customer-defined attributes for requests.
• HR_ALL_POSITIONS_F — The date-tracked positions table, queried or updated during posting.
• PER_ALL_ASSIGNMENTS_F — The date-tracked employee assignment table, the primary target of posted personnel actions.
• PER_POSITION_EXTRA_INFO — Contains additional position-level descriptive information.

Usage Notes

GHR_SF52_POST_UPDATE is typically invoked indirectly rather than from ad hoc SQL. The HR personnel action request form and its associated workflow background processes call these procedures to apply approved requests. It is also referenced by seven other packages in the ETRM registry, confirming its role as a shared service component. Customizations should call the package through its documented public procedures only, supply a valid object version number for concurrency control, and ensure the effective date and request identifiers align with the row in GHR_PA_REQUESTS. Direct DML against the underlying tables is not supported.