Results for “create_routing_rule”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQH_TCT_WIZARD_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite HRMS family, associated with the Public Sector / Talent and Configuration Toolset (TCT) components of the ETRM (Enterprise Talent and Resource Management) product line. Functionally, the package underpins the setup wizards that drive routing and authorization rule configuration for HR transactions. It provides the server-side logic used by wizard UI canvases to create, maintain, and validate the routing hierarchies, approver assignments, attribute selections, and rule definitions that determine how transactions are routed for approval across the enterprise.

The package is classified as an "OTHER" API, indicating it is primarily an internal implementation package invoked by the wizard framework rather than a public, customer-callable API. Its dependencies confirm this: it references only FND_NEW_MESSAGES and the STANDARD package at the top level, while its views and subordinate objects (PQH_ATTRIBUTE_RANGES_V3, PQH_ATTRIBUTE_RANGES_V4, PQH_ROUTING_CATEGORIES_V) reference it, forming a tightly coupled wizard subsystem.

Key Procedures and Functions

The package exposes 39 documented procedures and functions. The most significant cluster around routing and authorization setup:

Tables Accessed

The package reads and writes several core ETRM configuration tables through APPS synonyms. PQH_WIZARD_CANVASES and PQH_WIZARD_CANVASES_S store wizard canvas definitions and their translation rows. PQH_ROUTING_CATEGORIES and PQH_ROUTING_CATEGORIES_S hold routing category definitions. PQH_ATTRIBUTES, PQH_ATTRIBUTE_RANGES, and PQH_ATTRIBUTE_RANGES_S define the selectable attributes and their value ranges used when building rules. PQH_SYSTEM_RULE_S stores system-generated rules. PQH_ROUTING_HISTORY logs routing configuration changes. PQH_TRANSACTION_CATEGORIES and PQH_TXN_CATEGORY_ATTRIBUTES associate transaction types with the attributes available for routing. PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F supply employee and assignment context when identifying approvers, while FND_SESSIONS and FND_NEW_MESSAGES provide session state and message text.

Usage Notes

PQH_TCT_WIZARD_PKG is typically invoked by the Oracle EBS wizard forms and pages supplied with the ETRM configuration toolset, not directly by end users or external systems. Because it is not a published API, custom code should avoid calling it directly; integrations requiring routing rule manipulation should instead use documented public APIs or supported extension points. The package is referenced by three other packages and by the PQH_ATTRIBUTE_RANGES_V3, PQH_ATTRIBUTE_RANGES_V4, and PQH_ROUTING_CATEGORIES_V views, meaning it participates in the same read/write chain used to render wizard configuration data. Administrators interact with it indirectly through the Talent/Configuration wizard screens when setting up default hierarchies, approvers, routing attributes, and authorization rules. As with all APPS-owned packages, it should be treated as version-sensitive; behavior may differ between 12.1.1 and 12.2.2, and any diagnostic investigation should confirm the object status is VALID and review the documented dependent code before customization.