Search Results pqh_cec_shd




Overview
Explore in AI Chat

Overview

APPS.PQH_CEC_SHD is a valid PL/SQL package body in the Oracle E-Business Suite APPS schema that supports the Public Sector/HR Copy Entity Contexts framework, an internal utility layer used by Oracle's HRMS (PQH) components to manage and seed entity context definitions. The package name combines the PQH product prefix with "CEC" (Copy Entity Contexts) and the "SHD" suffix conventionally used by Oracle for shadow or seed-data loader packages, indicating that the unit is responsible for loading, validating, and maintaining the reference data that governs how HR entities (positions, organizations, and related context objects) are copied and propagated within an installation.

Its principal role is that of a seed/reference-data loader and integrity-check utility rather than a user-facing business API. The package operates against the PQH_COPY_ENTITY_CONTEXTS table, which stores the context mappings that drive entity-copy behavior, and it depends on standard HRMS infrastructure packages (HR_API, HR_GENERAL, HR_UTILITY), the generic loader utility FND_LOAD_UTIL, and the public ALL_CONSTRAINTS dictionary view.

Key Procedures and Functions

Five documented program units are exposed by the package:

  • CONSTRAINT_ERROR — A validation routine that inspects constraint definitions (via ALL_CONSTRAINTS) and raises or reports an error when the expected data-integrity conditions are not satisfied.
  • API_UPDATING — A guard/state function that determines whether an API-driven update is currently in progress, allowing the package to distinguish internal API updates from direct data manipulation.
  • LCK — A locking routine that serializes access to the entity-context data so concurrent load or copy operations do not corrupt shared rows.
  • CONVERT_ARGS — A helper that transforms or normalizes argument values before they are passed into the underlying loader or copy logic.
  • LOAD_ROW — The primary seed-data loader entry point, invoked to insert or synchronize a single row of entity-context reference data, typically through FND_LOAD_UTIL.

Detailed parameter lists are not reproduced here; implementations should be treated as Oracle-internal.

Tables Accessed

The package references three tables through APPS synonyms:

  • PQH_COPY_ENTITY_CONTEXTS — The core application table holding the entity-copy context definitions that LOAD_ROW and the locking routines read and maintain.
  • ALL_CONSTRAINTS — The data-dictionary view consulted by CONSTRAINT_ERROR to verify that required constraints exist on the relevant tables.
  • DUAL — Standard single-row utility table used for scalar queries and function evaluation.

Usage Notes

PQH_CEC_SHD is not referenced by other database objects, including package bodies, indicating it is a terminal or leaf-level utility called only by external drivers. In practice it is invoked during installation, patching, and seed-data apply operations through FND_LOAD_UTIL, and by Oracle HRMS copy-entity concurrent processes that populate or refresh PQH_COPY_ENTITY_CONTEXTS. Because it is not a published business API, customizations should avoid direct invocation; customers requiring the same behavior should use the supported concurrent programs or the higher-level PQH copy-entity APIs instead. As with all APPS shadow/seed packages, modifications are overwritten by patching and must not be edited directly.