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:
- Setup validation: CHK_IF_SETUP_FINISH and CHK_RULES_EXIST determine whether the wizard configuration is complete and whether routing rules have been generated. CHK_ROUTING_HISTORY_EXISTS tests for existing routing history records. DISABLE_ROUT_HIER_IF_NO_ATTR disables a routing hierarchy when no attributes are selected.
- Hierarchy and approver defaults: CREATE_DEFAULT_HIERARCHY, UPDATE_DEFAULT_HIERARCHY, CREATE_DEFAULT_APPROVER, UPDATE_DEFAULT_APPROVER, and DELETE_DEFAULT_APPROVER establish and maintain the default approval hierarchy and default approver for a transaction category.
- Attribute selection: SELECT_ROUTING_ATTRIBUTE, UNSELECT_ROUTING_ATTRIBUTE, SELECT_AUTHORIZATION_ATTRIBUTE, and UNSELECT_AUTH_ATTRIBUTE manage which transaction attributes participate in routing and authorization. GET_ALL_ATTRIBUTE_RANGE_ID retrieves attribute range identifiers used in range definitions.
- Rule generation and maintenance: REFRESH_ROUTING_RULES and REFRESH_AUTHORIZATION_RULES rebuild the derived rule sets; CREATE_ROUTING_RULE, UPDATE_ROUTING_RULE, and DELETE_ROUTING_RULE perform individual rule maintenance. GENERATE_RULE_NAME produces rule naming.
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.