Search Results check_pend_future_pars

Overview

The APPS.GHR_VALIDATE_PERWSEPI package is a server-side PL/SQL API belonging to the Oracle E-Business Suite HRMS product family. It is defined with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking schema rather than the package owner. The package name aligns with the GHR (Global Human Resources) "PERWSEPI" module file header ghrwsepi.pkh, which indicates it serves a validation role within the person extra-information and self-service personnel action framework. Its documented purpose is to provide reusable validation entry points that confirm whether a person holds a valid person type on a given effective date and whether outstanding or future-dated personnel action requests (PARs) exist for that person across a defined date range.

Key Procedures and Functions

The package exposes two documented callable units.

• GET_PERSON_TYPE — A function that returns a VARCHAR2 value representing the person type for a given person, evaluated as of a specified effective date within a business group context. This supports callers that must resolve the current or point-in-time classification of a person (for example, employee versus applicant) before allowing a transaction or self-service action to proceed.
• CHECK_PEND_FUTURE_PARS — A function that returns a VARCHAR2 result indicating whether pending or future-dated personnel action requests exist for a person between a supplied from-date and to-date. It is the object most commonly referenced by searches involving this package, and is typically used to block or warn about conflicting in-flight actions before a new personnel action is submitted.

Note that only the names and business intent of these units are documented in the ETRM metadata; the parameter lists above should not be extended beyond what the source header declares.

Tables Accessed

Through APPS synonyms, the package references three base tables:

• GHR_PA_REQUESTS — The personnel action request header table, read to identify pending, future-dated, or in-progress requests for a person.
• GHR_PA_ROUTING_HISTORY — The routing and approval history for PARs, consulted to determine whether a request remains outstanding or has completed its approval cycle.
• PER_PERSON_TYPES — The person type definition table, used by GET_PERSON_TYPE to resolve the classification applicable to the person on the effective date.

Usage Notes

This package is not referenced by any other PL/SQL package in the documented dependency set, which suggests it is consumed directly by forms, Oracle Self-Service HR (SSHR) pages, or custom extensions rather than being a shared lower-level utility. It is typically invoked at the point of validation—when a user submits or schedules a personnel action, or when a self-service page must decide whether a pending/future PAR conflict exists. Because the functions return VARCHAR2, callers should follow the package's own convention for interpreting the returned status string. As with all AUTHID CURRENT_USER APIs, grants on the underlying GHR and PER tables must be in place for the invoking schema. The package header carries a version reference dated 2009 and marked "noship," indicating it is a shipping product object maintained through standard patch application rather than a customer-modifiable artifact.