Search Results pqp_gb_psi_grade_codes




Overview
Explore in AI Chat

Overview

PQP_GB_PSI_GRADE_CODES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the United Kingdom (GB) localization of Oracle Payroll statutory payments processing. Specifically, it belongs to the PQP product family, which underpins the Payroll Statutory Information and payment calculation engines used by the GB payroll legislation. The package is concerned with the retrieval, validation, and post-processing of grade codes defined in Oracle Human Resources, so that statutory payment calculations (such as Statutory Sick Pay and Statutory Maternity Pay) can be evaluated against the correct employee grade structure.

In Oracle Payroll, grade codes represent pay grades assigned to employees and are frequently used as eligibility criteria for statutory payment rules and rate tables. PQP_GB_PSI_GRADE_CODES acts as the bridge between the HR grade setup held in PER_GRADES and the statutory payment engine, extracting the relevant grade information and validating it before the data is consumed by downstream payroll processes. The package status is documented as VALID in both EBS 12.1.1 and 12.2.2, and its API classification is recorded as OTHER, indicating that it is an internal technical utility rather than a formally published public API.

Key Procedures and Functions

The documented package exposes seven procedures and functions, each with a distinct responsibility:

  • GRADE_EXTRACT_MAIN — The principal entry point of the package. It orchestrates the extraction of grade code data required by the GB statutory payment engine, coordinating validation and subsequent post-processing.
  • CHK_GRADE_CODES_CRIT — A validation routine that checks grade code selection criteria, ensuring that grade data meets the business rules expected before processing continues.
  • GRADE_CODES_POST_PROCESSING — Performs follow-up processing on the extracted grade codes once the main extraction and validation steps have completed.
  • DEBUG — A diagnostic utility used to emit debug information during execution, typically controlled by a logging flag.
  • DEBUG_ENTER — Records entry into a procedure or function for traceability during troubleshooting.
  • DEBUG_EXIT — Records exit from a procedure or function, complementing DEBUG_ENTER.
  • DEBUG_OTHERS — A generic exception handler that captures and logs unexpected errors raised within the package.

The debug procedures are standard instrumentation used across Oracle HRMS/Payroll packages and are not intended for direct invocation by external callers.

Tables Accessed

The package references the APPS synonym PER_GRADES, which is the core Oracle HRMS table storing grade definitions, including grade name, validity dates, and associated business group information. Access to PER_GRADES allows the package to resolve the grade codes that statutory payment processing requires. In addition, the dependency metadata shows references to PER_BUSINESS_GROUPS and HR_UTILITY, indicating that the package operates within a defined business group context and uses shared HR utility routines. No other application tables are documented as being directly referenced.

Usage Notes

PQP_GB_PSI_GRADE_CODES is an internal utility and is not designed for direct invocation by end users or custom code. It is typically invoked from within the GB statutory payment processing flow, where grade-based eligibility and rate determination must be established before payroll calculations execute. In practical terms, the package is triggered indirectly through payroll runs and statutory payment processes rather than from a dedicated concurrent program or form. The documented metadata shows that the package is referenced by zero other packages, reinforcing its role as a supporting routine rather than a shared library. Developers troubleshooting GB statutory payment grade issues may enable the debug procedures to trace execution, but any custom reuse of this package should be avoided because its interface is not published and may change between releases.