Search Results po_wip_integration_grp




Overview
Explore in AI Chat

Overview

APPS.PO_WIP_INTEGRATION_GRP is a group (GRP) type PL/SQL package in the Oracle E-Business Suite Purchasing module. It serves as the integration bridge between Oracle Purchasing and Oracle Work in Process (WIP) for outside processing (OSP) transactions. In a manufacturing environment, outside processing allows a manufacturer to send partially completed assemblies to a supplier for further processing, then receive them back into the shop floor. Because this workflow spans both the Purchasing and Manufacturing applications, a dedicated integration layer is required to keep purchase orders, requisitions, and work orders synchronized.

The package is classified as GRP, meaning it acts as a grouping or dispatcher package rather than a single-purpose API. Its documented procedures support both the update and cancellation of supplier-facing documents and internal requisitions, providing the maintenance operations needed when OSP requirements change after the original documentation has been created. The package is recorded as VALID in the APPS schema and is referenced by both itself and the WIP_OSP package, confirming its role as a supporting component of the outside processing flow.

Key Procedures and Functions

The ETRM metadata documents four procedures for this package:

  • UPDATE_DOCUMENT — Updates an existing purchasing document associated with an outside processing transaction, allowing changes to be reflected on the supplier-facing document when OSP details are revised.
  • CANCEL_DOCUMENT — Cancels the purchasing document tied to an outside processing event, supporting scenarios where the OSP requirement is withdrawn or rerouted.
  • UPDATE_REQUISITION — Updates the internal requisition linked to the WIP outside processing demand, ensuring requisition data remains consistent with current manufacturing requirements.
  • CANCEL_REQUISITION — Cancels the associated requisition when the underlying outside processing need no longer exists.

These procedures follow the standard EBS API convention of accepting change records and returning error records rather than raising unhandled exceptions, allowing callers to process and report errors programmatically.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. PLITBLM is a standard EBS table used in the outside processing and purchasing integration flow. The package operates on data in this table to support the update and cancellation operations described above, rather than performing direct inserts into core purchasing or WIP base tables.

The dependency listing reveals significant use of PL/SQL record and collection types: PO_API_ERRORS_REC_TYPE, PO_CHANGES_REC_TYPE, PO_REQ_CHANGES_REC_TYPE, PO_TBL_NUMBER, and PO_TBL_VARCHAR30. These types underpin the package's parameter interface, enabling it to pass structured change data and collect error messages. PO_API_ERRORS_REC_TYPE is the standard error record type used throughout the Purchasing APIs and is the object most commonly searched alongside this package.

Usage Notes

PO_WIP_INTEGRATION_GRP is not intended for direct invocation by end users. It is typically called from the WIP_OSP package and other components of the outside processing integration, which in turn are triggered by Work in Process transactions or concurrent programs. Customizations that need to modify OSP-related purchasing documents or requisitions should call these procedures rather than updating base tables directly, and should always inspect the returned error records for failures. Because the package is referenced by WIP_OSP, changes to its interface can affect outside processing behavior across the manufacturing and purchasing modules, and it should be treated as an internal integration dependency rather than a public, standalone API.