Search Results chk_context

Overview

APPS.PQH_CEC_BUS is a business-rule layer (CEC = Copy Entity Contexts) within the Oracle EBS Public Sector / Higher Education "HR Copy Entity" architecture, historically associated with the Copy Entity Contexts entity used by the Oracle HRMS and Public Sector Payroll copy-and-rollback utilities. The package body follows the canonical Oracle HRMS API design pattern: a shared private layer (PQH_CEC_SHD) holds record definitions, global constants and helper utilities, while the _BUS (business) package holds the row-handler validation logic that governs whether a context row may be inserted, updated, or deleted.

As documented in the source header, the package declares a private global g_package variable and implements the internal procedure chk_context. The header comment for chk_context states explicitly: "This procedure is used to check that the primary key for the table is created properly. It should be null on insert and should not be able to be updated." The access status is documented as "internal table handler use only," meaning chk_context is not intended for direct external invocation.

Key Procedures and Functions

• chk_context — Internal procedure that validates the primary key of the record being processed. It accepts the context value and the object_version_number, calls pqh_cec_shd.api_updating to determine whether the operation is an update, and raises a constraint error against PQH_COPY_ENTITY_CONTEXTS_PK if an attempt is made to change the primary key. The source notes that the "PK is null on insert" check is not enforced here because the context value is not system-generated.
• INSERT_VALIDATE — Documented row-handler procedure invoked before a new context record is inserted. It exists to enforce business validation rules prior to the DML, and would conventionally call chk_context as part of its validation chain.
• UPDATE_VALIDATE — Documented row-handler procedure invoked before an existing context record is updated. It ensures that any update respects the immutability of the primary key context column and any other business constraints on the row.
• DELETE_VALIDATE — Documented row-handler procedure invoked before a context record is removed. It checks deletion eligibility and prevents removal of rows that are referenced elsewhere in the copy-entity context hierarchy.

No parameter lists are invented here; per ETRM metadata the documented entry points are limited to these three validation procedures, with chk_context being private support logic.

Tables Accessed

The package operates against the entity context table surfaced through the APPS synonym for the copy-entity contexts structure — referenced in the source by the primary key constraint name PQH_COPY_ENTITY_CONTEXTS_PK. The bus layer does not issue unrestricted DML itself; the actual insert, update, and delete statements are owned by the table handler generated alongside the _BUS package, while this package contributes the pre-DML validation. Because ETRM does not enumerate the tables referenced via APPS synonyms for this object, the precise column set cannot be confirmed from the metadata alone; the PK constraint name is the definitive evidence of the underlying table.

Usage Notes

PQH_CEC_BUS is invoked indirectly. It is not exposed through a form or concurrent program by name. Instead, it is called by the generated table-handler API whenever a context row is created, amended, or deleted — for example, when a user runs the Copy Entity Contexts flow to replicate payroll/HR contexts between entities, or performs a rollback of that copy operation. The documented fact that it is referenced by three other packages confirms its role as a shared bus-layer dependency consumed by the table handler and related PQH copy-entity APIs.

Customizations should observe the "internal table handler use only" designation: developers should not call chk_context directly. Extending business rules belongs in the INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE entry points, or better, in a supported customization layer that wraps the seeded table handler. Direct modification of the seeded package body is not supported and will be overwritten by patching between 12.1.1 and 12.2.2.