Results for “select_authorization_attribute”

10 results




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

Overview

APPS.PQH_TCT_WIZARD_PKG is a PL/SQL package body in the Oracle E-Business Suite HRMS/Enterprise Talent Management (ETRM) schema. Its responsibility is to support the Transaction Category (TCT) Setup Wizard, the interview-style user interface through which administrators configure routing and authorization behavior for HR transactions such as promotions, transfers, terminations, and other workforce events. The package persists wizard configuration into the underlying transaction-category metadata tables and derives the routing and authorization rules that govern who approves a given transaction and which attributes are evaluated during approval. It is the programmatic engine behind the wizard canvases (PQH_WIZARD_CANVASES and PQH_WIZARD_CANVASES_S) that define the steps and screens the user traverses. Because routing and authorization configuration is complex, involving attribute selection, range definition, hierarchy assignment, approver defaults, and rule generation, the package encapsulates these operations in a single cohesive unit rather than requiring the form to manipulate the base tables directly. The package is classified as OTHER in the documented API metadata rather than a public interfaces API, confirming that it is an internal implementation component invoked by the wizard UI rather than a documented integration point for customer extensions.

Key Procedures and Functions

The documented package exposes thirty-nine procedures and functions. The principal routines fall into several functional groups:

Tables Accessed

The package reads and writes the core TCT configuration tables. PQH_TRANSACTION_CATEGORIES and PQH_TRANSACTION_CATEGORIES_VL hold the transaction category definition. PQH_TXN_CATEGORY_ATTRIBUTES links attributes to categories, while PQH_ATTRIBUTES and PQH_ATTRIBUTE_RANGES (with PQH_ATTRIBUTE_RANGES_S) define available attributes and their permitted ranges. PQH_ROUTING_CATEGORIES and PQH_ROUTING_CATEGORIES_S store routing category configuration. PQH_ROUTING_HISTORY records routing changes. PQH_SYSTEM_RULE_S holds system routing rules. PQH_WIZARD_CANVASES and PQH_WIZARD_CANVASES_S define the wizard screens, and the package updates these to reflect wizard progress.

Usage Notes

The package is invoked from the Transaction Category Setup Wizard form (PQH_TCT_WIZARD) when the administrator navigates, selects attributes, defines approvers, or saves configuration. It is not intended for direct customer invocation; extensions should use the corresponding public APIs (PQH_ATTRIBUTE_RANGES_API, PQH_ROUTING_CATEGORIES_API, PQH_TRAN_CATEGORY_API, PQH_TXN_CAT_ATTRIBUTES_API, PQH_ROUTING_CATEGORIES_API) which the package itself references. No database object references this package, confirming its role as a leaf-level UI support component.