Search Results pqh_copy_entity_functions




Overview
Explore in AI Chat

Overview

The PQH_COPY_ENTITY_FUNCTIONS table is a configuration and metadata table within the Oracle E-Business Suite Public Sector Human Resources (PQH) module. It plays a critical role in defining and managing custom business logic during data replication or "copy" operations. Specifically, it stores references to custom PL/SQL functions that are executed before (Pre) or after (Post) a specific event for a given table within a defined context. This mechanism allows for extensive customization and validation of data during complex HR processes, such as copying position or job structures, ensuring data integrity and adherence to specific public sector rules.

Key Information Stored

The table's primary purpose is to map custom functions to specific points in a data flow. While the full column list is not detailed in the provided metadata, the core columns can be inferred from the relationships and description. The primary key, COPY_ENTITY_FUNCTION_ID, uniquely identifies each function mapping. The TABLE_ROUTE_ID is a foreign key to PQH_TABLE_ROUTE, identifying the specific table involved in the copy operation. The CONTEXT column is a foreign key to PQH_COPY_ENTITY_CONTEXTS, defining the specific business scenario or process phase. Other essential columns would logically include the function name, an indicator for Pre or Post event execution, and the specific event type.

Common Use Cases and Queries

This table is primarily accessed by the underlying copy engine logic within PQH processes. A common use case is during the setup or troubleshooting of a custom data copy process. An administrator might query the table to review all custom functions attached to a specific table route or context. Sample queries include listing all configured functions for a particular context, or finding which functions fire before an insert event on a specific table.

  • Find functions for a context: SELECT * FROM pqh_copy_entity_functions WHERE context = '<CONTEXT_NAME>';
  • Join to see table and context details: SELECT cef.*, ptr.table_name, cec.context_name FROM pqh_copy_entity_functions cef, pqh_table_route ptr, pqh_copy_entity_contexts cec WHERE cef.table_route_id = ptr.table_route_id AND cef.context = cec.context;

Related Objects

The PQH_COPY_ENTITY_FUNCTIONS table is central to a small network of configuration tables. Its documented foreign key relationships are critical for understanding its dependencies.

  • PQH_TABLE_ROUTE: Linked via PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID. This table defines the specific database tables that are part of the copy entity routing, providing the target for the custom functions.
  • PQH_COPY_ENTITY_CONTEXTS: Linked via PQH_COPY_ENTITY_FUNCTIONS.CONTEXT. This table defines the various business contexts or scenarios (e.g., "Copy Position", "Update Grade") under which the copy operations and their associated functions are executed.

The table is referenced by the application's copy engine logic, which queries it dynamically to determine which custom PL/SQL functions to execute at defined points in a data transaction.