Search Results ghr_pd_coversheet_data




Overview
Explore in AI Chat

Overview

GHR_PD_COVERSHEET_DATA is an Oracle EBS HRMS (Human Resources Management System) package body owned by the APPS schema. It supports the generation of position description (PD) coversheet documents within the Oracle Public Sector / Federal HRMS footprint, retrieving descriptive and flexfield-derived data about positions and personnel actions. The package abstracts the lookup logic required to populate coversheet report or form fields, returning human-readable values from coded descriptors stored in the GHR and PER schema tables. It is classified as an OTHER API, indicating it is not a public, supported interface but rather an internal helper that supports presentation-layer logic. The package exposes four documented functions and, as the "get_segment" search term suggests, provides a flexfield accessor that resolves Key Flexfield segment values by position and structure.

Key Procedures and Functions

  • GET_FR_POSITION_GROUP — Returns the position group code for a given position and information type/number. It reads from PER_POSITION_EXTRA_INFO and decodes the descriptive flexfield attribute (information3, 5, or 12) corresponding to the requested information number, providing the coversheet with the position's functional grouping.
  • GET_GEN_EMP — Returns the general employee indicator associated with a personnel action request (PA request). It queries GHR_PA_REQUEST_EXTRA_INFO for information type GHR_US_PD_GEN_EMP and decodes the appropriate information segment based on the requested information number.
  • GET_PAY_PLAN — Returns the descriptive name of a pay plan from the GHR_PAY_PLANS table given a pay plan lookup code. This converts the stored short code into the full description presented on the coversheet.
  • FLEXFIELD — Resolves a Key Flexfield segment value for a position, given the position identifier, the flexfield structure, and the segment name. This function uses FND_ID_FLEX_STRUCTURES_TL and FND_ID_FLEX_SEGMENTS to look up the segment definition, and reads the actual segment values from PER_POSITION_DEFINITIONS, returning the display value used on the coversheet. This is the function most closely associated with the "get_segment" search term.

Tables Accessed

  • PER_POSITION_EXTRA_INFO — Source of position descriptive flexfield attribute values used by GET_FR_POSITION_GROUP and segment resolution logic.
  • PER_POSITION_DEFINITIONS — Stores the flexfield definition and segment value data resolved by FLEXFIELD.
  • GHR_PA_REQUEST_EXTRA_INFO — Stores additional personnel action request attributes read by GET_GEN_EMP.
  • GHR_PAY_PLANS — Pay plan code and description lookup used by GET_PAY_PLAN.
  • FND_ID_FLEX_SEGMENTS and FND_ID_FLEX_STRUCTURES_TL — Application Object Library flexfield metadata used by FLEXFIELD to identify the requested segment and its structure.

Usage Notes

GHR_PD_COVERSHEET_DATA is invoked internally by the position description coversheet generation logic, typically from Oracle Forms or a concurrent program that assembles the PD document. The functions are read-only, returning VARCHAR2 values that are formatted directly into the coversheet output. Because the package is classified as OTHER rather than a public API, it should not be called from external custom code without risk of change across patches. The presence of the "get_segment" search term reflects common use of the FLEXFIELD function to obtain a specific Key Flexfield segment value for a position; developers investigating segment retrieval should note that the segment name, structure, and position identifier are all required inputs. Referenced by one other package, it forms a small but integral part of the HRMS position description reporting chain in both EBS 12.1.1 and 12.2.2.