Search Results submit_request_to_print_50

Overview

GHR_SF52_API is the server-side PL/SQL package that implements the Standard Form 52 (SF-52), "Request for Personnel Action," within Oracle E-Business Suite. In the U.S. federal human resources context, the SF-52 is the authorized instrument through which a personnel action is requested, reviewed, approved, and routed for processing. This package encapsulates the business rules required to create, modify, approve, terminate, and cancel those requests, and it is registered as an API object owned by the APPS schema. The package body header identifies version 120.33 and is dated 2012/07/19, consistent with the 12.1.1 and 12.2.2 release streams of the EBS HRMS/Advanced Benefits and federal HR product line. Functionally, GHR_SF52_API acts as the integration point between user-facing forms and the underlying request, routing, remarks, and event-history tables, shielding callers from direct DML against those structures.

Key Procedures and Functions

The documented API exposes eight entry points:

• CREATE_SF52 — Creates a new SF-52 personnel action request, accepting request attributes such as the notice of action family code, agency routing group, proposed effective date, and a broad set of optional descriptive elements, and returning the new PA request identifier.
• UPDATE_SF52 — Modifies an existing SF-52 request, applying changed attributes to the corresponding PA request record.
• END_SF52 — Closes or completes an SF-52 request, terminating its active lifecycle state.
• CANCEL_CANCOR — Cancels an SF-52 request and its associated cancellation routing, supporting withdrawal of a personnel action.
• SUBMIT_REQUEST_TO_PRINT_50 — Submits a request for the SF-50 (Notification of Personnel Action) to be produced or printed. This is the procedure associated with the search term "submit_request_to_print_50" and is the standard mechanism for triggering SF-50 output from an approved SF-52 workflow.
• GET_PAR_STATUS — Retrieves the current status of a personnel action request, allowing callers to evaluate workflow progress.
• CHECK_FOR_OPEN_EVENTS — Determines whether open events exist against a request, typically used as a validation guard before update, end, or cancel operations.
• UPDATE_DETAIL_REMARKS — Maintains detail-level remarks attached to a request, supporting the narrative annotations required on federal personnel actions.

Tables Accessed

The package operates across the GHR request, routing, remarks, and HR foundation tables accessed through APPS synonyms. GHR_PA_REQUESTS is the primary transaction table holding the personnel action request itself, supported by GHR_PA_REQUEST_EXTRA_INFO and GHR_PA_REQUEST_INFO_TYPES for extensible request attributes. GHR_NOA_FAMILIES and GHR_FAMILIES classify notice-of-action and action families, while GHR_NOAC_REMARKS, GHR_PA_REMARKS, GHR_PA_REMARKS_S, and GHR_REMARKS store narrative and remark data. Routing is handled through GHR_PA_ROUTING_HISTORY, GHR_ROUTING_LIST_MEMBERS, and GHR_GROUPBOXES. GHR_EVENT_HISTORY records lifecycle events, FND_USER resolves application user identities, and HR_ALL_POSITIONS_F and related position views supply the federal position data referenced by a request.

Usage Notes

GHR_SF52_API is typically invoked from the SF-52 and SF-50 Oracle Forms, from workflow background processes, and from custom extensions that need to raise or amend a personnel action programmatically. The presence of the p_validate convention on CREATE_SF52 indicates that API calls can be executed in validation-only mode before committing. Because the package is referenced by eleven other packages, callers should treat it as a shared dependency and avoid direct DML on the underlying GHR tables. The CHECK_FOR_OPEN_EVENTS guard should be evaluated before attempting UPDATE_SF52, END_SF52, or CANCEL_CANCOR to prevent inconsistent request states. SUBMIT_REQUEST_TO_PRINT_50 should be called only after the source SF-52 has reached the appropriate approved status.