Search Results ghr_par_extra_info_api




Overview
Explore in AI Chat

Overview

GHR_PAR_EXTRA_INFO_API is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a public API within the Oracle HRMS (GHR) product family. Its purpose is to manage the additional descriptive information attached to Performance and Appraisal (PA) requests. In Oracle EBS, a PA request represents a formal employee-managed transaction such as an appraisal, award nomination, or similar HR action. While the core request record is stored in GHR_PA_REQUESTS, organizations frequently need to capture supplementary data fields that are not part of the standard request structure, including extra attribute values stored in a key-flexfield style. The package exposes a controlled programmatic interface for creating, maintaining, and removing these supplementary records so that they stay synchronized with the parent PA request throughout its lifecycle. Because it is built on top of HR_API, the package participates in the standard HRMS API conventions for validation, business-group security, and DML handling, allowing it to be safely invoked from both standard application flows and extensions.

Key Procedures and Functions

The package exposes three documented entry points, each corresponding to a stage in the lifecycle of a PA request's extra information.

  • CREATE_PA_REQUEST_EXTRA_INFO — Inserts extra information records associated with a PA request. It is invoked when a request is first created or when a user supplies additional attribute values during request definition.
  • UPDATE_PA_REQUEST_EXTRA_INFO — Modifies existing extra information rows for a PA request, supporting corrections and mid-lifecycle changes to the supplementary attributes.
  • DELETE_PA_REQUEST_EXTRA_INFO — Removes extra information records, typically when the request is cancelled, terminated, or the extra attributes are no longer applicable.

Each routine applies the validation and security logic inherited from HR_API rather than performing raw DML, which ensures consistent behavior across all calling modules. Parameter lists are not reproduced here; consult the package specification for exact signatures.

Tables Accessed

The package operates against three documented tables, accessed through APPS synonyms.

  • GHR_PA_REQUEST_EXTRA_INFO — The primary target table, holding the supplementary attribute values tied to a PA request. All create, update, and delete operations act on this table.
  • GHR_PA_REQUESTS — The parent request table. It is referenced to validate the request identity and context so that extra information is correctly associated with a valid request.
  • PER_TIME_PERIODS — The time period definitions used by Oracle HRMS. It is consulted for date and period validation when extra information is date effective.

Usage Notes

GHR_PAR_EXTRA_INFO_API is not intended to be called directly by end users; it is an internal integration point. It is referenced by nine other packages, including GHR_APPROVED_PA_REQUESTS, GHR_MASS_AWARDS_PKG, GHR_MASS_CON_PROGRAM, GHR_MASS_SEL_NOA, GHR_MRE_PKG, GHR_MTI_APP, GHR_MTO_PKG, GHR_NON_SF52_EXTRA_INFO, and GHR_SS_RPA_CREATION. This dependency pattern shows that the API is embedded in approval routing, mass award processing, mass contests, mass selections, and self-service request creation, meaning extra information is written or maintained automatically as these higher-level programs execute. Customizations that need to populate or amend PA request extra information should call these three procedures instead of writing directly to GHR_PA_REQUEST_EXTRA_INFO, preserving validation and upgrade safety. Because the object is documented as VALID in both 12.1.1 and 12.2.2, the interface is stable across releases, though callers should verify signatures against the local package specification before compilation.