Search Results cancel_po_program

Overview

The APPS.MRP_CANCEL_PO package is a PL/SQL API within Oracle E-Business Suite that supports the cancellation of purchase order supply in the context of Oracle Advanced Supply Chain Planning (ASCP) and the Material Requirements Planning (MRP) family of products. In the planning engine, purchase orders represent expected receipts of supply. When a planner determines that a given purchase order or shipment should no longer be treated as valid supply — for example, because a buyer has decided not to proceed with the order, because of a supplier cancellation, or because of a rescheduling decision — the planning application must be able to cancel the corresponding PO supply record so that dependent demand and netting calculations are recalculated correctly.

The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner. This is significant in the EBS context because it allows the planning engine and related concurrent programs to operate against the APPS schema objects using the caller's security profile, preserving multi-org and responsibility-based access control. The package is classified under the "OTHER" API category, which indicates it is a supporting utility rather than a formally published public interface such as the Purchasing open interfaces.

Key Procedures and Functions

The package exposes a single documented procedure:

• CANCEL_PO_PROGRAM — This is the primary entry point for cancelling purchase order supply. It accepts identifying information for the purchase order being cancelled, including the purchase order header identifier, the purchase order line identifier, the purchase order number, the shipment number, and document type and subtype indicators. These parameters together allow the procedure to uniquely locate the intended PO shipment and mark it for cancellation within the planning context. The procedure is intended to be called by the planning engine's cancellation logic rather than interactively by end users.

No public functions are documented for this package. The remaining logic is internal and not part of the supported interface.

Tables Accessed

The documented table reference for this package is PO_HEADERS_ALL, accessed through an APPS synonym. This is the core Purchasing table holding purchase order header information, including the PO header identifier, document type, document subtype, supplier, and status. The procedure uses this table to validate and resolve the purchase order being cancelled. Although the parameter list also references line and shipment level identifiers, the package may resolve related line and shipment data through the header or through dependent lookups not enumerated in the documented metadata.

Usage Notes

The MRP_CANCEL_PO package is typically invoked programmatically by the planning engine, most often during the execution of the ASCP or MRP plan or during cancellation processing within the planning workbench. It is referenced by one other package according to the documented metadata, confirming its role as a subordinate utility within a larger planning code path rather than as a standalone user-facing API.

Users searching for "can I cancel a PO" should note that this package is not a substitute for the standard Purchasing cancellation process. Purchase orders are cancelled through the Purchasing application or through the PO cancellation APIs; MRP_CANCEL_PO addresses the planning-side treatment of PO supply. Any custom integration that attempts to call this package directly should restrict itself to the documented parameter set and be aware that the procedure is owned by APPS and executes with invoker's rights, so appropriate schema privileges and access to PO_HEADERS_ALL are required.