Search Results get_varchar2_column

Overview

GHR_CORR_CANC_SF52 is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the Oracle HRMS (GHR) module. Its principal business function is to manage the correction, cancellation, and termination processing of SF52 records — the Standard Form 52, the U.S. Federal Government's Request for Personnel Action. In Oracle EBS, personnel action requests are stored in GHR_PA_REQUESTS and tracked through related history and audit tables. This package provides the programmatic logic that allows an SF52-based personnel action to be corrected, cancelled, or terminated after it has been created, including handling appointments, other-family actions, and dual corrections.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it operates primarily against the record structure of GHR_PA_REQUESTS (referenced as ghr_pa_requests%rowtype throughout its signatures). It is a documented API in the ETRM 12.2.2 repository and is referenced by four other packages, indicating it is a shared utility within the federal HR personnel action framework.

Key Procedures and Functions

• Correction_SF52 — Performs the core correction processing for an SF52 personnel action, accepting the request record, a process type (defaulting to 'CURRENT'), and an optional capped other-pay amount.
• Cancel_Appt_SF52 — Cancels an appointment associated with an SF52 action.
• Cancel_Correction_SF52 — Reverses or cancels a previously applied correction.
• Cancel_Other_Family_Sf52 — Handles cancellation for actions belonging to the "other" family of nature-of-actions.
• cancel_term_SF52 — Cancels a termination action. This is the object the user searched for ("cancel_term_sf52") and is the entry point for reversing termination processing on an SF52 request.
• update_eleentval — Updates an element value record based on a history row passed in.
• build_corrected_sf52 — Constructs a corrected SF52 request record given a personnel action request ID, a corrected nature-of-action code, and calling context.
• Cancel_Routine — General cancellation routine shared across cancellation paths.
• populate_corrected_sf52 — Populates the corrected SF52 data for a given request ID and corrected NOA code.
• get_date_column / get_number_column / get_varchar2_column — Typed conversion helper functions that return date, number, and varchar2 values respectively.
• get_sf52_to_details_for_ia — Retrieves SF52 detail information for an IA-context request using the personnel action request ID and retroactive effective date.
• posn_not_active — Determines whether a position is inactive at an effective date, returning position effective start/end dates and a prior position override number.
• apply_dual_correction — Applies a dual correction (added via bug fix 6850492) to an SF52 request.

Tables Accessed

The package reads and writes against several categories of tables through APPS synonyms:

• Personnel action tables — GHR_PA_REQUESTS (the primary request record), GHR_PA_HISTORY (audit trail of changes), GHR_PA_ROUTING_HISTORY, GHR_PA_REQUEST_SHADOW, GHR_PA_REQUEST_EI_SHADOW, and GHR_PA_REQUEST_EXTRA_INFO hold the request, its routing, and supplementary data.
• Nature-of-action configuration — GHR_FAMILIES, GHR_NATURE_OF_ACTIONS, and GHR_NOA_FAMILIES define the valid actions and their family groupings used when validating and building corrections.
• Benefits and enrollment tables — BEN_LER_F, BEN_PER_IN_LER, BEN_PGM_F, BEN_PRTT_ENRT_RSLT_F, and BEN_PTNL_LER_FOR_PER are referenced to keep benefit eligibility and enrollment results consistent when personnel actions are corrected or cancelled.
• FND_USER — Used to resolve the application user performing or owning the action.

Usage Notes

This package is an internal "OTHER"-classified API rather than a public open interface. It is typically invoked indirectly — from Oracle HRMS forms that process personnel actions, from concurrent programs that batch-process corrections and cancellations, or from other PL/SQL packages (four packages reference it). Custom code should call the documented procedures (for example, GHR_CORR_CANC_SF52.cancel_term_SF52) and pass a fully populated GHR_PA_REQUESTS rowtype, respecting the in out nocopy semantics of the cancellation procedures. Because the package manipulates request, history, and benefits data together, callers should ensure the request is in an appropriate state before invoking correction or cancellation routines, and should allow the package to manage the associated shadow and history updates rather than writing to those tables directly.