Search Results get_noa_code_desc

Overview

GHR_WGI_PKG is an Oracle EBS Human Resources package in the APPS schema that supports the Within Grade Increase (WGI) process used by federal and public sector installations. The package encapsulates the PL/SQL logic required to evaluate employee eligibility for within-grade increases, calculate the effective pay date, validate the personnel office and pay plan parameters supplied by the concurrent program, and write processing outcomes to the GHR process log. It is classified as an OTHER API rather than a public interface, indicating that it is intended primarily for internal use by Oracle's WGI concurrent programs and by the GHR forms that drive them, though it is referenced by ten other packages in the same product family. The package header carries a version stamp of 120.1.12010000.1, consistent with the 12.1.1 code line that remains valid in 12.2.2.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. GHR_WGI_PROCESS is the primary concurrent program entry point, accepting an error buffer and return code along with optional personnel office and pay plan filters. GHR_WGI_EMP performs the per-employee evaluation, taking an effective date, a frequency value defaulting to ninety days, a log flag, and the same optional office and pay plan parameters. CREATE_GHR_ERRORLOG writes diagnostic text, message name, program name, and log date into the process log table.

GET_NOA_CODE_DESC, the object of the user's search, resolves a Nature of Action code and effective date into the corresponding nature_of_action_id and description, providing the lookup used throughout the WGI eligibility logic. GET_FND_LOOKUP_MEANING performs the analogous resolution against HR_LOOKUPS for a given lookup type, code, and effective date.

The remaining routines perform validation and derivation: CHECK_ASSIGNMENT_PRD, CHECK_PAY_PLAN, CHECKIFFWPAYPLAN, CHECKPAYPLANPARM, CHECKPOIPARM, and CHECKIFMAXPAYPLAN verify pay rate determinants, pay plan configuration, personnel office identifiers, and maximum pay plan boundaries; PERSON_IN_PA_REQUESTS and CHECK_P confirm the presence of prior personnel action requests for a person; DERIVE_LEGAL_AUTH_CD_REMARKS builds the legal authority code and remarks text; and RET_WGI_PAY_DATE returns the computed within-grade increase pay date.

Tables Accessed

The package reads and writes through APPS synonyms. Core personnel action data resides in GHR_PA_REQUESTS and GHR_PA_REMARKS, while GHR_PA_ROUTING_HISTORY tracks routing. Nature of action and family configuration is drawn from GHR_NATURE_OF_ACTIONS, GHR_FAMILIES, and GHR_NOA_FAMILIES. Pay plan definitions come from GHR_PAY_PLANS. Employee assignment and grade data are read from PER_ALL_ASSIGNMENTS_F and PER_GRADES. Supporting reference data includes GHR_POIS, GHR_DUTY_STATIONS_F, and GHR_REMARKS. Logging uses GHR_PROCESS_LOG and its sequence GHR_PROCESS_LOG_S, and FND_SESSIONS supplies session context.

Usage Notes

GHR_WGI_PKG is normally invoked from the WGI concurrent program and from the associated GHR forms rather than directly by end users. Custom code should call GET_NOA_CODE_DESC when it needs to translate a Nature of Action code into its identifier and description at a specific effective date, and should observe the effective-date parameters on all validation routines to preserve date-tracked behavior. Because it is classified as OTHER, Oracle does not guarantee interface stability across patches; extensions should be revalidated after applying HRMS family patches in either 12.1.1 or 12.2.2.