Search Results update_rate_sync_salary
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:
- Mode and entry-point dispatchers: DT_MODE, CALL_PP_FROM_ASSIGNMENTS, CALL_PP_FROM_BENMNGLE, CALL_PP_FROM_AUI, CALL_PP_FOR_BATCH_ENRL, and CALL_FROM_WEBADI provide context-specific invocation paths, allowing the same post-processing logic to be triggered from assignment maintenance, the Benefits Manage Life Events flow, the Assignment User Interface, batch enrollment, or Web ADI upload.
- Eligibility and approval: OVERRIDE_ELIGIBILITY applies a manual eligibility override, while APPROVE_REJECT_AUI handles the approval or rejection decision originating from the assignment interface. CALL_CONCURRENT_REQ_AUI submits the associated concurrent request.
- Record creation and updates: CREATE_ENROLLMENT persists enrollment records; UPDATE_SALARY_INFO and UPDATE_ASSGMT_INFO write salary and assignment changes respectively.
- Rate synchronization: UPDATE_RATE_SYNC_SALARY and GSP_RATE_SYNC reconcile benefit rates with salary outcomes resulting from progression.
- Data retrieval: GET_PERSONS_GL_AND_GRADE returns a person's grade and grade ladder attributes used by the post-processing logic.
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.