Search Results pqh_cec_bus




Overview
Explore in AI Chat

Overview

PQH_CEC_BUS is a private business-rule validation package within the Oracle E-Business Suite HRMS schema, owned by APPS. It forms part of the generated row-handler infrastructure associated with the PQH_CEC entity — the "CEC" element of the Public Sector / Human Resources budget and position control family (the PQH schema encompasses budget, position, and establishment management). The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining user, which is the standard convention for generated row-handler support code in Oracle HRMS.

The package does not expose public API functionality. It is a validation hook container: a placeholder structure into which the business rules for a given entity are placed, so that the corresponding insert, update, and delete row handlers can invoke them at the appropriate point in their execution flow. The header comment block ($Header: pqcecrhi.pkh 120.2 2005/10/12) identifies it as a generated row-handler include file, confirming its machine-generated origin. In EBS 12.1.1 and 12.2.2 alike, the package is shipped as part of the standard product installation and is not intended for direct customer modification.

Key Procedures and Functions

  • INSERT_VALIDATE — Controls the execution of all insert business-rule validations for the entity. It is called from the generated ins procedure after the insert record structure is populated, and prior to the physical row insertion. Its role is purely orchestration: it sequences validation calls. The documentation explicitly notes that failures are not handled within this procedure unless expressly coded, and advises that rules be implemented as direct procedure or function calls, avoiding conditional branching.
  • UPDATE_VALIDATE — Controls the execution of all update business-rule validations. It is invoked from the generated upd procedure once the update record structure has been assembled. As with insert validation, processing continues on success and this routine is the designated point at which update-specific rules are attached.
  • DELETE_VALIDATE — Controls the execution of all delete business-rule validations, called from the delete row handler prior to removal of the entity record. This is where referential or dependency safeguards against deletion are placed.

All three procedures accept the entity's PL/SQL record structure as their input parameter. The package is classified as Internal Row Handler Use Only; the procedures are not part of any supported public API surface.

Tables Accessed

The ETRM metadata for 12.2.2 records no direct table references for this package through APPS synonyms. This is consistent with the package's design intent: PQH_CEC_BUS is a validation dispatcher, and any SQL it performs would be issued by the individual business-rule routines it calls rather than by the dispatcher itself. Any data access is therefore indirect and dependent on whichever rules have been bound to the validate hooks at a given installation or patch level.

Usage Notes

PQH_CEC_BUS is referenced by three other packages, which corresponds to the row-handler and shared-record packages that call the validate hooks during insert, update, and delete processing. It is never invoked directly from a form, concurrent program, or custom code path; such calls would bypass the transaction context established by the row handler and are unsupported.

Because the package is generated and marked internal, customer extensions should not be applied to its source. Business rules requiring invocation at insert, update, or delete validation time are properly implemented through the supported entity APIs or by conventionally extending the corresponding row-handler logic, not by editing this unit. In upgrade scenarios across 12.1.1 and 12.2.2, the package may be regenerated or recompiled as part of HRMS patching, so any local modifications would be lost.

Users searching for "axis micro cec" may be attempting to reconcile this PQH package with an unrelated or third-party component; no such association exists in the documented metadata. PQH_CEC_BUS is solely the generated validation container for the PQH CEC entity's row handlers.