Search Results per_person_extra_info

Overview

GHR_CORR_CANC_SF52 is an Oracle EBS HRMS package body in the APPS schema that implements correction and cancellation processing for the SF52 (Personnel Action) framework. SF52 refers to the standard personnel action form used across Oracle HRMS to record and track changes to employee records, including appointments, terminations, corrections, and other family-related actions. This package provides the backend PL/SQL logic that supports cancelling and correcting existing personnel action requests stored in GHR_PA_REQUESTS, along with their associated shadow records, history rows, and extra information records. The package is classified as OTHER under the ETRM API classification scheme, meaning it is not a public HRMS API but an internal implementation body invoked indirectly through the personnel action routing framework. Its header indicates a last build of 2008 for release 12.1.1, and the package remains in use through 12.2.2. Because it manipulates historical and shadow tables directly, it plays a critical role in maintaining data integrity when users cancel or amend previously approved personnel actions.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, each targeting a specific cancellation or correction scenario:

• CORRECTION_SF52 — Main correction driver for SF52 personnel actions.
• CANCEL_APPT_SF52 — Handles cancellation of appointment-related personnel actions.
• CANCEL_CORRECTION_SF52 — Reverses a previously applied correction.
• CANCEL_OTHER_FAMILY_SF52 — Cancels actions belonging to non-appointment families.
• CANCEL_TERM_SF52 — Cancels termination actions.
• UPDATE_ELEENTVAL — Updates element entry values associated with a corrected action.
• BUILD_CORRECTED_SF52 — Constructs the corrected SF52 record set.
• CANCEL_ROUTINE — Generic cancellation routine used by the specialized cancel procedures.
• POPULATE_CORRECTED_SF52 — Populates the corrected data structure prior to re-application.
• GET_DATE_COLUMN — Retrieves a date-typed column dynamically.
• GET_NUMBER_COLUMN — Retrieves a numeric column dynamically.
• GET_VARCHAR2_COLUMN — Retrieves a character column dynamically.
• GET_SF52_TO_DETAILS_FOR_IA — Fetches SF52 header-to-detail relationships for information access.
• POSN_NOT_ACTIVE — Evaluates whether a position is inactive at a given effective date.
• APPLY_DUAL_CORRECTION — Applies a correction affecting a pair of related actions.

Tables Accessed

The package reads and writes several core HRMS personnel action tables. GHR_PA_REQUESTS stores the primary SF52 request records, while GHR_PA_HISTORY holds the audit history of prior actions used during rollback. Shadow tables GHR_PA_REQUEST_SHADOW and GHR_PA_REQUEST_EI_SHADOW capture pre-change snapshots, and GHR_PA_REQUEST_EXTRA_INFO (referenced by the search term per_person_extra_info context) stores supplemental attribute values tied to those requests. GHR_PA_ROUTING_HISTORY tracks workflow routing. GHR_FAMILIES, GHR_NOA_FAMILIES, and GHR_NATURE_OF_ACTIONS resolve action categorization. Benefits tables BEN_LER_F, BEN_PER_IN_LER, BEN_PGM_F, BEN_PRTT_ENRT_RSLT_F, and BEN_PTNL_LER_FOR_PER are consulted for benefit-related action effects, and FND_USER provides the acting user identity.

Usage Notes

GHR_CORR_CANC_SF52 is not invoked directly by end users or custom code. It is called by the Oracle HRMS personnel action forms and by four other packages within the GHR_CORR_CANC family, which delegate family-specific cancellation and correction requests to this body. Typical invocation occurs when a user selects a previously approved personnel action and chooses to cancel or correct it through the Professional Forms interface. The package composes shadow comparisons, history deletion, and re-application logic to keep GHR_PA_REQUESTS consistent with downstream employee and assignment data. Customizations should avoid calling this package directly; instead, use supported HRMS APIs. Because the package manipulates rowids and shadow records, any extension must preserve the original transactional ordering to avoid orphaning history or extra information rows.