Search Results notify_req_plan

Overview

PO_SUP_CHG_REQUEST_WF_GRP is a PL/SQL package owned by APPS and classified as a Group (GRP) API within Oracle E-Business Suite Purchasing. It provides the workflow-enabled integration layer that governs the supplier change request lifecycle for purchase orders and releases. The package name reflects its dual role: it manages the notification and approval workflow (WF) surrounding supplier-initiated change requests against purchasing documents, while grouping related programmatic entry points for buyer and supplier interactions. The header comment identifies the source file as POXGSCWS.pls, indicating a Purchasing (PO) family module, and the package is declared with AUTHID CURRENT_USER.

In practical terms, the package coordinates the handoff between supplier change request records, the Oracle Workflow engine, and the purchasing document hierarchy. It determines whether supplier acknowledgment is required, evaluates approval status against hierarchy rules, transitions change request statuses, and drives responses from buyers and suppliers through the workflow. The procedures are designed to be invoked both directly by application logic and indirectly as workflow function activities.

Key Procedures and Functions

• Buyer_CancelDocWithChn — Cancels a purchasing document in conjunction with an associated change request group. It operates against header, release, revision, and change group identifiers.
• KickOffPOApproval — Initiates the purchase order approval process for a specified header and release.
• ProcessHdrCancelResponse — Processes the buyer's response to a header-level cancellation request, capturing the user, acceptance or rejection decision, and reason.
• ProcessResponse — Central routine for processing responses to a change request group, returning status messages, a return code, and a document check record.
• StartSupplierChangeWF — Launches the supplier change workflow for a given document, accepting a change request group and acceptance flag.
• NOTIFY_REQ_PLAN — A workflow callback that notifies the requisition planner; invoked with workflow item type, item key, activity, and function mode.
• PROCESS_RESPONSE — Workflow-callable wrapper that processes a response and returns a workflow result.
• BUYER_ACCEPT_CHANGE / BUYER_REJECT_CHANGE — Record the buyer's decision to accept or reject a supplier change.
• IS_PRORATE_NEEDED — Evaluates whether proration logic applies to the change.
• CHG_STATUS_TO_APPROVED — Advances change request status to approved.
• CARRY_SUP_ACK_TO_NEW_REV / DOES_PO_REQ_SUP_ACK — Determine and propagate supplier acknowledgment requirements across revisions.
• IS_PO_APPROVED_BY_HIE — Checks whether the document has been approved through the approval hierarchy.
• SET_DATA_SUP_CHN_EVT / SET_DATA_CHN_RESP_EVT — Populate event payloads for supplier change and change response workflow events.
• ANY_NEW_SUP_CHN / ANY_SUPPLIER_CHANGE — Boolean checks for the existence of new or pending supplier changes.
• REGISTER_REJECTION / IS_PO_HDR_REJECTED — Register and test rejection state at the document header level.

Tables Accessed

• FND_USER — Resolves user identity for responses and approvals.
• PO_CHANGE_REQUESTS — Core change request records driving the workflow.
• PO_HEADERS_ALL — Purchase order header data for status and approval evaluation.
• PO_RELEASES_ALL — Release-level data supporting change and cancellation logic.
• PO_WF_ITEMKEY_S — Stores workflow item key mappings for notification routing.

Usage Notes

The package is invoked from Oracle Purchasing forms such as the Purchase Order and Supplier Change Request screens, as well as from workflow function activities where NOTIFY_REQ_PLAN and PROCESS_RESPONSE serve as callbacks. Because it is a GRP-classified API, custom extensions should call its routines rather than modify underlying tables. The package is referenced by two other packages, so changes must be assessed for downstream impact.