Search Results pqh_gsp_post_process




Overview
Explore in AI Chat

Overview

APPS.PQH_GSP_POST_PROCESS is a PL/SQL package in the Oracle E-Business Suite HRMS schema that supports the post-processing phase of the Grade/Step Progression (GSP) and associated compensation enrollment workflow. Residing in the APPS schema and holding a VALID status in ETRM for both 12.1.1 and 12.2.2, the package acts as the transactional bridge between a GSP- or life-event-driven eligibility determination and the persistent benefit, salary, and assignment records that must ultimately reflect the resulting change.

Where the GSP eligibility engine evaluates whether an employee qualifies for a progression, rate change, or open enrollment opportunity, PQH_GSP_POST_PROCESS carries out the downstream consequences: creating enrollment rows, updating salary and assignment information, overriding eligibility outcomes, and synchronizing rates. It is classified under the ETRM category OTHER, indicating it is an internal technical package rather than a public, customer-facing API, and is intended to be invoked by Oracle-owned calling modules rather than directly by end users.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. Their names indicate a well-defined division of responsibilities:

No parameter signatures are documented; callers should reference the package specification for exact arguments.

Tables Accessed

The package reads and writes Benefits tables through APPS synonyms. Plan and program configuration is resolved via BEN_PGM_F, BEN_PGM_EXTRA_INFO, BEN_PL_F, BEN_PL_TYP_F, BEN_OPT_F, BEN_OIPL_F, BEN_PLIP_F, and BEN_POPL_ENRT_TYP_CYCL_F. Life-event context is obtained from BEN_LER_F, BEN_LEE_RSN_F, and BEN_PER_IN_LER. Enrollment and rate results are held in BEN_ENRT_RT and BEN_ACTY_BASE_RT_F, while BEN_ELIG_PER_ELCTBL_CHC supplies per-person eligibility and electable choice data. BEN_POPL_YR_PERD defines the plan year period used when dating these records.

Usage Notes

PQH_GSP_POST_PROCESS is not intended for direct customer invocation. It is referenced by five other packages: BEN_MANAGE_LIFE_EVENTS, HR_ASSIGNMENT_API, HR_MAINTAIN_PROPOSAL_API, HR_SP_PLACEMENT_API, PQH_RANK_UTILITY, and recursively by itself. These callers cover assignment changes, placement, life events, and rank (grade step) processing, confirming its role as shared post-processing infrastructure. Invocation typically occurs when a GSP or life-event transaction is approved, either synchronously from the originating form or API, or asynchronously for batch enrollment via a concurrent request. Custom code should avoid calling these procedures directly and instead use the supported public APIs, since the package depends only on SYS.STANDARD and is otherwise internal.