Search Results ghr_upd_hr_validation




Overview
Explore in AI Chat

Overview

The APPS.GHR_UPD_HR_VALIDATION package is a server-side PL/SQL validation library used by Oracle EBS Human Resources (HR) and, more specifically, by the Public Sector / HRMS legislative extensions supporting the U.S. Federal government configuration. Its header declares AUTHID CURRENT_USER, meaning that when invoked it executes with the privileges of the calling schema rather than the owner (APPS). This design is typical of defensive-validation packages that are called directly from Oracle Forms and from the supporting GHR (Government Human Resources) APIs.

In the 12.2.2 documented metadata it is classified as API classification OTHER — that is, a supporting validation utility rather than a published, customer-callable business API. The package header was last updated with the file revision ghuhrval.pkh 120.1.12000000.1 (2007), indicating relative stability across the 12.1.1 and 12.2.2 releases. All GHR business modules (assignment, position, payroll, benefits, awards) consult this package before committing changes to the database.

Key Procedures and Functions

Six documented procedures and functions are present. Each name is significant; parameter lists are not enumerated because the package is not a published API contract.

  • GET_FORM_ITEM_NAME / SET_FORM_ITEM_NAME — These pair together as a package-level state accessor and mutator for form_item_name, declared as VARCHAR2(61) and representing the current block_name.item_name in the calling Oracle Form. They allow the validation routines to report errors against the specific field that triggered them.
  • MAIN_VALIDATION — The user-searched entry point. It accepts the PA request row (ghr_pa_requests%ROWTYPE) and an extensive set of typed record parameters covering assignment, NTE dates, person group, uniformed services, retained grade, separation/retirement, probation, position groups, within-grade increase, government awards, government payroll, performance appraisal, recruitment and relocation bonuses, student loan repayment, special pay (MDDDS), premium pay indicator, conversions, conduct/performance, thrift savings plan, benefit info, and SCD info. It orchestrates the full GHR rule set for the update request.
  • GET_EXEMP_AWARD_DATE — Returns the date used when an award is exempt from standard effective-date rules.
  • GET_RPA_INFO — Returns data from the Recruitment, Placement, and Awards (RPA) tables for the current row.
  • TO_POSN_NOT_ACTIVE — Converts or flags a position as inactive as part of the validation flow.

Tables Accessed

The documented synonym references indicate the following read/write footprint:

Usage Notes

The package is invoked from Oracle Forms during data entry and from the GHR update APIs before the underlying DML is committed. It is referenced by four other packages, so its behavior affects all callers; changes should be regression-tested across the GHR module set. Because it runs with AUTHID CURRENT_USER, direct calls from custom code must ensure the calling schema has the appropriate privileges on the referenced GHR and PER synonyms. It is not exposed as a concurrent program.