Results for “post_copy_function_name”
30 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PQH_COPY_ENTITY_FUNCTIONS is a configuration table in the Oracle E-Business Suite HR schema, owned by the Public Sector HR (PQH) product. It defines the context-sensitive function hooks that the copy-entity framework invokes when records are copied between entities. The table documents, per table route and per context, which pre-copy, copy, and post-copy database functions should be executed. Because the copy-entity mechanism must behave differently depending on the entity and the timing of the operation, this table acts as a registry of callable program units keyed by route and context.
The heuristic Data Vault classification mined from the foreign key structure is link. This reflects the fact that the table primarily serves to associate two other tables — PQH_TABLE_ROUTE and PQH_COPY_ENTITY_CONTEXTS — and to hold the function assignments that result from that association. It should be regarded as a modeling suggestion rather than a mandated classification, and analysts designing downstream integration models may treat it as either a link or a satellite depending on whether the function-name attributes are considered descriptive or associative. The object is reported as VALID under the HR schema in both EBS 12.1.1 and 12.2.2.
Key Information Stored
The documented physical schema comprises 14 columns. The most significant are summarized below.
- COPY_ENTITY_FUNCTION_ID — the surrogate primary key, defined by the unique index PQH_COPY_ENTITY_FUNCTIONS_PK. The index also includes ZD_EDITION_NAME, making it a composite business-key candidate for edition-aware lookups.
- TABLE_ROUTE_ID — foreign key to PQH_TABLE_ROUTE, identifying the table-copy route to which the function assignment applies.
- CONTEXT — foreign key to PQH_COPY_ENTITY_CONTEXTS, qualifying the assignment with the context under which the functions run.
- FUNCTION_TYPE_CD — the code that categorizes the function role within the copy lifecycle.
- PRE_COPY_FUNCTION_NAME, COPY_FUNCTION_NAME, and POST_COPY_FUNCTION_NAME — the three function names executed before, during, and after the copy operation for the given route and context.
- OBJECT_VERSION_NUMBER — the optimistic locking version used by the EBS framework to detect concurrent updates.
- ZD_EDITION_NAME — the editioning discriminator, included in the primary key index and used for edition-aware access in 12.2.x.
- Standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE — capturing who created and last modified each row and when.
Common Use Cases and Queries
The primary use case is diagnosing copy behavior: identifying which functions run for a given table route and context. A typical query joining the function registry to its parent route table would be:
SELECT cef.COPY_ENTITY_FUNCTION_ID, cef.TABLE_ROUTE_ID, cef.CONTEXT, cef.FUNCTION_TYPE_CD, cef.PRE_COPY_FUNCTION_NAME, cef.COPY_FUNCTION_NAME, cef.POST_COPY_FUNCTION_NAME FROM HR.PQH_COPY_ENTITY_FUNCTIONS cef WHERE cef.TABLE_ROUTE_ID = :route_id;- Enumerating all contexts configured for a specific function type:
WHERE cef.FUNCTION_TYPE_CD = :type_cd. - Auditing recently changed configurations using LAST_UPDATE_DATE and LAST_UPDATED_BY to detect unauthorized function substitutions.
Reporting scenarios include configuration matrices showing route/context coverage, gap analysis to find routes lacking pre- or post-copy functions, and impact analysis before a function name is changed or deprecated.
Related Objects
The following objects are the most significant dependencies, based on the documented foreign keys and the surrounding PQH copy-entity framework.
- PQH_TABLE_ROUTE — referenced by PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID; defines the copy route itself.
- PQH_COPY_ENTITY_CONTEXTS — referenced by PQH_COPY_ENTITY_FUNCTIONS.CONTEXT; defines valid contexts.
- PQH_COPY_ENTITY_FUNCTIONS_PK — the primary key index on COPY_ENTITY_FUNCTION_ID and ZD_EDITION_NAME.
- The broader PQH copy-entity configuration tables and the PL/SQL packages that read this registry at runtime, which resolve the named functions and invoke them during copy processing.
-
For a context Pre / Post and event functions for table is listed
-
For a context Pre / Post and event functions for table is listed
-
PACKAGE: APPS.PQH_CEF_SHD 12.2.2
-
PACKAGE: APPS.PQH_CEF_SHD 12.1.1
-
PACKAGE: APPS.PQH_CEF_INS 12.1.1
-
PACKAGE: APPS.PQH_CEF_INS 12.2.2
-
PACKAGE: APPS.PQH_CEF_SHD 12.1.1
-
PACKAGE: APPS.PQH_CEF_SHD 12.2.2
-
eTRM - PQH Tables and Views 12.2.2
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - PQH Tables and Views 12.1.1
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.