Search Results undo_distribution_adjustment

Overview

PSP_WF_ADJ_PKG (PSPWFAJS.pls) is an Oracle E-Business Suite PL/SQL package owned by APPS that implements the Oracle Time and Labor / Payroll distribution adjustment approval workflow. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user and relies on APPS synonyms for all referenced objects. Its business purpose is to drive the enhanced workflow process for distribution adjustments: when the user profile option "PSP: Distribution Adj. Enhanced Workflow" is set to "Yes", submission of a distribution adjustment batch triggers this package to initiate, route, approve, or undo the adjustment batch through Oracle Workflow. The header comment in the source identifies the package as part of the distribution adjustment feature set; the header revision (115.11, dated 2003/07/24) reflects the long-standing lineage of the object. In 12.1.1 and 12.2.2 the package remains an APPS-owned "OTHER" classification API and is referenced by one other package. It is not a general-purpose public API; it is the workflow callback library invoked by the workflow engine and by the distribution adjustment submission logic.

Key Procedures and Functions

• INIT_WORKFLOW — Initiates the distribution adjustment workflow when a user submits the distribution adjustment batch and the profile option is set to "Yes". It accepts the batch identity, the requesting person, display name, assignment, date range, currency, comments, and a timeout value, and returns a numeric return code: 0 on success, or -1 / -2 on failure. The currency parameter was introduced to support a bug fix, indicating the signature has evolved over releases.
• SELECT_APPROVER — Called by the "Select Approver" activity in the workflow process. By default the supervisor is chosen as approver; customizations redirect to PSP_WF_CUSTOM.select_adj_approver to obtain the approver's person ID.
• UNDO_DISTRIBUTION_ADJUSTMENT — Called by the "Undo Distribution Adjustment" activity in the workflow process, used when the adjustment batch must be reversed or cancelled as part of the workflow outcome.
• GET_APPROVAL_RESPONDER — Resolves the responder to whom an approval notification is routed within the workflow.
• RECORD_APPROVER — Persists the identity of the approver as part of workflow processing.
• OMIT_APPROVAL — Supports bypassing the approval step when the business rule or configuration permits it.
• RECORD_CREATOR — Records the person who created the adjustment so the workflow can attribute ownership.

Tables Accessed

• PSP_ADJUSTMENT_CONTROL_TABLE — Stores the distribution adjustment control and batch state manipulated by INIT_WORKFLOW and the undo activity.
• PSP_PAYROLL_CONTROLS — Provides payroll control context for the adjustment.
• WF_ITEMS, WF_ITEM_ACTIVITY_STATUSES, WF_PROCESS_ACTIVITIES, WF_NOTIFICATIONS — Oracle Workflow runtime tables used to create item keys, advance activities, and deliver approval notifications.
• PER_ALL_PEOPLE_F, FND_USER — Used to resolve approvers and responders to person IDs and application users.

Usage Notes

PSP_WF_ADJ_PKG is invoked indirectly rather than called from custom code. It is launched when a distribution adjustment batch is submitted through the standard distribution adjustment form or concurrent process, provided the "PSP: Distribution Adj. Enhanced Workflow" profile option is "Yes". The Oracle Workflow engine subsequently calls SELECT_APPROVER, GET_APPROVAL_RESPONDER, RECORD_APPROVER, OMIT_APPROVAL, RECORD_CREATOR, and UNDO_DISTRIBUTION_ADJUSTMENT as activity callbacks. Rather than modifying the package, customers should use PSP_WF_CUSTOM.select_adj_approver for approver customization, preserving the standard API across 12.1.1 and 12.2.2.