Search Results pqh_ss_workflow




Overview
Explore in AI Chat

Overview

APPS.PQH_SS_WORKFLOW is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema that supports the Self-Service workflow and approval infrastructure for Oracle Public Sector/HR (PQH) transactions in releases 12.1.1 and 12.2.2. Its documented API classification is OTHER, indicating it is an internal helper package rather than a public, supported API. The package orchestrates the approval lifecycle of HR self-service transactions — such as promotions, transfers, terminations, and other assignment-based actions — by starting Oracle Workflow processes, tracking step and value history, and managing transaction status transitions as an approver or HR representative acts on a pending transaction.

The package holds status VALID in the ETRM 12.2.2 registry and depends only on SYS.STANDARD at the lowest level, relying on APPS synonyms for all business tables. It is referenced by six other packages, confirming its role as a shared utility within the PQH self-service stack.

Key Procedures and Functions

The ETRM registry documents 36 procedures and functions. Representative members include:

Tables Accessed

The package reads and writes the following APPS-synonym tables:

Usage Notes

PQH_SS_WORKFLOW is invoked indirectly rather than called directly by end users. It is referenced by HR_APPROVAL_SS, HR_PERSON_INFO_UTIL_SS, HR_TRANSACTION_SS, HR_WORKFLOW_SS, PQH_AME_APPROVALS, and PQH_SS_HISTORY, and it recurses onto itself. These callers are the self-service OAF/forms pages and the AME (Approvals Management Engine) integration layer that drive the approval flow. The package is therefore triggered when a manager or HR representative submits, approves, rejects, returns, or saves a self-service HR transaction, and when workflow notifications are responded to. Custom code should not call it directly; extensions should be built against documented public APIs. Because procedures and functions are undocumented publicly, references should be validated against the specific patch level of 12.1.1 or 12.2.2 in use.