Search Results po_sourcing_pvt




Overview
Explore in AI Chat

Overview

APPS.PO_SOURCING_PVT is a private PL/SQL package within the Oracle E-Business Suite Purchasing module. Its API classification of "PVT" indicates that it is an internal, private package, not intended for direct invocation by external or customer-developed code. The package functions as a supporting engine for the public sourcing APIs and forms, encapsulating the business logic required to create and maintain sourcing documents such as CPA (Consolidated Purchase Agreements) records and related header interface data. In the context of Oracle EBS 12.1.1 and 12.2.2, the package operates under the APPS schema and is recorded with a VALID status in the ETRM metadata.

Key Procedures and Functions

The documented metadata identifies two procedures or functions within this package:

  • CREATE_CPA — Responsible for the creation of a CPA (Consolidated Purchase Agreement) record. This routine encapsulates the logic that consolidates procurement document data into the sourcing structure, writing the resulting header records to the purchasing tables.
  • DELETE_INTERFACE_HEADER — Handles the removal of records from the purchasing header interface, cleaning up staging data that has been processed or rejected prior to the standard concurrent import cycle.

No parameter lists are documented in the metadata, and external callers should not construct direct calls against these private routines. Access to this logic is achieved through the public wrapper package PO_SOURCING_GRP.

Tables Accessed

The ETRM dependency data confirms that PO_SOURCING_PVT references the following APPS-synonym tables:

Usage Notes

PO_SOURCING_PVT is not a public API and should never be invoked directly by custom code. The metadata records that it is referenced by the public package PO_SOURCING_GRP, which serves as the supported entry point. The package is typically invoked indirectly through the Purchasing and Sourcing forms, and through concurrent programs that process header interface records and create consolidated purchase agreements. Because the package validates against GL period statuses and AME approval records, creation routines are sensitive to the period state and approval configuration in effect at run time. Customizations requiring CPA creation or interface header deletion must call the PO_SOURCING_GRP wrapper rather than the private routines, and should follow standard EBS API conventions regarding initialization, commit control, and error handling.