Search Results pqh_template_attributes_s

Overview

PQH_TAT_SHD is a seed data handler (SHD) package body in the APPS schema that manages the upload and maintenance of seed data for the Oracle E-Business Suite Enterprise Talent Management (ETRM) module, specifically for template attributes in Oracle Public Sector/HR (PQH) functionality. The "_SHD" suffix identifies this as part of the FND_LOAD_UTIL-based seed data loading framework, which is the standard mechanism Oracle uses to deliver and refresh configuration data across releases. Its business purpose is to populate and update rows in the template attribute configuration tables — the metadata that determines which attributes are available on which templates, how they are routed, and which transaction categories they belong to — during patching, upgrade, or administrative seed data load operations.

Key Procedures and Functions

The documented package exposes five program units, each supporting the seed data lifecycle:

• LOAD_ROW — The primary entry point in the FND_LOAD_UTIL seed data API contract. It accepts a row of template attribute seed data and inserts or merges it into the underlying configuration tables, resolving conflicts against existing rows so that patches can idempotently apply seed data.
• CONVERT_ARGS — Translates and validates inbound arguments from the loader's generic string-based interface into typed values suitable for the PQH template attribute tables, handling datatype and lookup conversions.
• API_UPDATING — Determines whether the current change originates from an API-driven update, guarding downstream validation logic so that seed loading does not trigger inappropriate business rules intended for runtime user transactions.
• LCK — A locking routine that acquires the row-level or logical lock needed to prevent concurrent modification of template attribute seed records during a load.
• CONSTRAINT_ERROR — Handles integrity constraint violations raised during insert or update, converting low-level Oracle errors into meaningful messages via FND_MESSAGE.

Tables Accessed

The package operates against the core ETRM template configuration schema. PQH_TEMPLATE_ATTRIBUTES and its PQH_TEMPLATE_ATTRIBUTES_S synonym (the object referenced by users searching "pqh_template_attributes_s") hold the attribute-to-template assignments that this package seeds. PQH_ATTRIBUTES supplies the attribute definitions themselves, while PQH_TEMPLATES and PQH_TEMPLATES_VL provide template header information (including translated views). PQH_TABLE_ROUTE and PQH_TRANSACTION_CATEGORIES and PQH_TXN_CATEGORY_ATTRIBUTES drive routing and transaction-category associations for the seeded attributes. ALL_CONSTRAINTS is queried to derive constraint metadata for validation, and standard utilities such as FND_LOAD_UTIL, FND_MESSAGE, HR_API, HR_GENERAL, and HR_UTILITY are used for loading, messaging, and HR-specific processing helpers.

Usage Notes

PQH_TAT_SHD is invoked indirectly rather than by end users. It is called by the Oracle seed data loader (FND_LOAD_UTIL) during patch application and upgrade, and it is documented as being referenced by five other packages, indicating that higher-level ETRM APIs or concurrent programs delegate template attribute loading to it. Direct invocation is not supported; the procedures are designed to be driven by the loader's row-by-row contract. Because it performs configuration-level inserts and updates, it should only run under controlled patch or administrative scenarios, not from end-user forms at runtime. Concurrent execution must be avoided, which is why the LCK procedure exists.