Search Results get_person_type




Overview
Explore in AI Chat

Overview

The APPS.GHR_VALIDATE_PERWSEPI package body is a server-side PL/SQL validation utility that supports the Oracle EBS Public Sector / Human Resources person and personnel action (PA) processing model. Its name reflects its role as a validation helper for the "PERWSEPI" process — validation logic tied to person records and their associated personnel action requests within a business group. The package encapsulates reusable business rules that determine person classification and detect outstanding personnel action activity, allowing higher-level forms, APIs, or concurrent processes to make decisions about eligibility, routing, or data integrity before committing a transaction.

From an architectural standpoint, the package operates entirely in the APPS schema and is classified under ETRM as an "OTHER" API — meaning it is not a formally published, customer-facing API but an internal utility invoked by standard Oracle EBS components. It reads from core HR and Public Sector tables through APPS synonyms and returns simple scalar results (primarily VARCHAR2 flags such as 'TRUE'/'FALSE' or descriptive strings) to its callers.

Key Procedures and Functions

  • GET_PERSON_TYPE — Determines whether a given person, within a specified business group and evaluated as of a given effective date, is classified with the system person type of Employee (EMP). The function accepts a business group identifier, a person identifier, and an effective date, then queries the effective-dated person record joined to the person type definition. If an active person type with a system person type of 'EMP' is found for that business group and date, the function returns 'TRUE'; otherwise it returns 'FALSE'. This provides a dated, business-group-scoped test of employee status suitable for downstream validation.
  • CHECK_PEND_FUTURE_PARS — Evaluates whether completed future personnel action requests exist for a person within a specified date range. It builds a descriptive list of request information, including request number, first and second Notice of Action (NOA) codes, effective date, and the user name of the updater, drawing on personnel action request and routing history data. The function is used to detect pending or scheduled PA activity that may affect the validity of a proposed action.

Tables Accessed

  • PER_PERSON_TYPES — Supplies the person type definition, including the SYSTEM_PERSON_TYPE attribute (used to test for 'EMP'), the business group ownership, and the active flag. It is joined to the effective-dated person record to resolve classification.
  • GHR_PA_REQUESTS — The Public Sector personnel action request table, providing request numbers, NOA codes, effective dates, and other header information used by the future-PAR validation.
  • GHR_PA_ROUTING_HISTORY — Provides routing and updater information (for example, the user name of the person who last acted on a request), enabling the function to report who processed the action.

All access is read-only; the package does not appear to insert, update, or delete data, reinforcing its role as a validation and inquiry utility.

Usage Notes

Because GHR_VALIDATE_PERWSEPI is classified as an "OTHER" API and is referenced by zero other packages, it is best understood as an internal helper invoked directly by standard Oracle EBS forms, concurrent programs, or workflow components rather than through a public API layer. Customizations should call it cautiously and only after confirming the signature against the installed release.

Typical invocation scenarios include validating employee status before allowing a personnel action, and checking for outstanding future PA requests prior to processing a new action. The dated parameters matter: results depend on the effective date supplied, so callers must pass the date relevant to the transaction being validated. Because it relies on effective-dated HR records, results reflect the person's classification as of that date. Users searching for "get_person_type" will find this function is the mechanism for determining employee person type within a business group for a specific effective date.