Search Results get_gen_emp




Overview
Explore in AI Chat

Overview

The APPS.GHR_PD_COVERSHEET_DATA package is a server-side PL/SQL utility within the Oracle E-Business Suite Human Resources (HR) module. Its name reflects its role in the Human Resources Professional Development and position description framework, specifically the population and derivation of data displayed on position description "coversheet" or worksheet forms. In Oracle EBS 12.1.1 and 12.2.2, this package functions as a data-access layer that resolves descriptive attributes for positions, requests, and payment plans so that the presentation layer can render meaningful information rather than raw identifier values.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and relies on the APPS synonym layer for object resolution. Its header carries a legacy revision marker (ghrwspdc.pkh, 1999), indicating that it is a long-standing component of the HR schema rather than a recent addition. The API classification recorded in ETRM is OTHER, which designates it as a supporting internal package rather than a formally published business API.

Key Procedures and Functions

ETRM documents four callable units, all declared as FUNCTION and all carrying the PRAGMA RESTRICT_REFERENCES (…, WNDS, WNPS) purity assertion. That pragma guarantees the functions write neither database state (WNDS) nor package state (WNPS), confirming they are read-only helpers safe for use inside SQL and PL/SQL expressions.

  • GET_FR_POSITION_GROUP — Returns a VARCHAR2 value representing the position group associated with a given position, qualified by an information type and information number. It resolves the grouping attribute used to categorize a position within the coversheet context.
  • GET_GEN_EMP — The function the user searched for. It returns a VARCHAR2 derived from a position requisition/request identifier and an information number. It supplies the "general employee" or descriptive personnel value required for display on the coversheet, effectively translating a request reference into a human-readable result.
  • GET_PAY_PLAN — Accepts a lookup code and returns the corresponding pay plan description as VARCHAR2. This provides a decoded display value for a coded pay plan reference.
  • FLEXFIELD — A generic key flexfield accessor that returns a VARCHAR2 segment value given a position identifier, a structure name, and a segment name. It abstracts the multi-segment key flexfield lookup logic used for position and related descriptive flexfields.

No parameter lists beyond those shown in the source header should be assumed; the documented signatures are authoritative.

Tables Accessed

The package reads through APPS synonyms across six documented tables:

All access is read-only, consistent with the WNDS pragma.

Usage Notes

Because the functions return display-ready strings and are purity-constrained, GHR_PD_COVERSHEET_DATA is typically invoked from Oracle Forms-based HR forms and from custom PL/SQL or SQL expressions embedded in reports and concurrent programs. It is referenced by one other documented package, indicating a dependency chain within the position description subsystem. When troubleshooting calls to GET_GEN_EMP, verify that a matching row exists in GHR_PA_REQUEST_EXTRA_INFO for the supplied request identifier and information number, since an unmatched lookup will return a null or default value rather than raising an exception. Custom code should call these functions only as documented, relying on the APPS synonym layer and avoiding direct table access.