Search Results hr_approval_wf




Overview
Explore in AI Chat

Overview

HR_APPROVAL_WF is an Oracle Application Object Library package body owned by the APPS schema that provides the programmatic backbone for the Oracle HRMS approval workflow. It encapsulates the PL/SQL logic used by Oracle Workflow to route, notify, and track approval transactions originating in Human Resources self-service functions, including offer approvals, vacancy and requisition routing, and related person or assignment based approvals. The package supplies the workflow engine with the item attributes, routing determinations, and notification URLs required to move an approval item from initiation through final disposition. It is validated and marked VALID in ETRM for both the 12.1.1 and 12.2.2 releases and is documented with an API classification of OTHER, indicating it is an internal implementation package rather than a formally published public API.

Key Procedures and Functions

The package body exposes twenty-nine documented procedures and functions. The most prominent include:

  • CREATE_ITEM_ATTRIB_IF_NOTEXIST — Ensures that the workflow item attributes required by the HR approval process are defined in the Workflow item type, creating them only when absent so that repeated invocations remain idempotent.
  • INITIALIZE_ITEM_ATTRIBUTES — Populates the item attribute values for a workflow item at the point of initiation, giving downstream activities the transaction context they need.
  • SET_ROUTING_DETAILS1 through SET_ROUTING_DETAILS5 — Establish routing information for approval items. These routines determine the approver chain or routing target used by the workflow during specific approval stages.
  • SET_URL1 through SET_URL13 — Construct and assign the notification URLs embedded in approval notifications. Because Oracle HRMS supports numerous approval transactions, the package provides thirteen separate URL builders so each notification can deep-link the recipient to the appropriate self-service page.

Additional documented members round out the set to twenty-nine. Naming and behavior indicate the procedures are invoked from workflow function activities and from the custom hooks HR_APPROVAL_CUSTOM and HR_OFFER_CUSTOM.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • WF_ITEM_ATTRIBUTE_VALUES — Stores attribute values for workflow items; the package inserts and updates these as item attributes are created and initialized.
  • PER_ALL_PEOPLE_F — Supplies person records for approvers, requestors, and affected employees in the routing logic.
  • OTA_EVENTS — Provides learning or event-related context where approval transactions are linked to Oracle Training Administration events.

Dependency metadata also shows references to PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_VACANCIES, WF_DIRECTORY, WF_USERS, WF_ENGINE, ICX_SEC, HR_UTIL_WEB, and HR_WORKFLOW_SERVICE, indicating the package draws on assignment, vacancy, directory, security, and workflow services during processing.

Usage Notes

HR_APPROVAL_WF is not intended for direct invocation by end users or casual customizations. It is called by the Oracle Workflow engine when an HR approval item type executes its function activities, and indirectly by HRMS self-service flows that launch approval processes for offers, vacancies, and related transactions. The package is referenced by fourteen other database objects and itself depends on the customization hooks HR_APPROVAL_CUSTOM and HR_OFFER_CUSTOM, which are the supported extension points for tailoring approval behavior. On upgrade or when patching Oracle HRMS, the package must remain valid because Workflow activities resolve to its procedures at runtime; an invalid state will halt HR approval notifications. Customizations should target the custom hook packages rather than HR_APPROVAL_WF itself, since the latter is an Oracle-owned internal package subject to change between 12.1.1 and 12.2.2 and does not constitute a published public API.