Search Results delete_interface_header

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:

• PO_HEADERS_ALL / PO_HEADERS — Core purchasing document header storage, written during CPA creation and header maintenance.
• PO_HEADERS_INTERFACE — Staging table for inbound header data, targeted by the interface deletion routine.
• PO_HEADERS_DRAFT_ALL — Holds draft header versions generated during document editing workflows.
• PON_AUCTION_HEADERS_ALL and PON_BID_HEADERS — Sourcing and auction-related header and bid data, linking negotiated sourcing outcomes to purchasing documents.
• PO_DOC_STYLE_HEADERS and PO_PRINT_FORM_FORMATS — Document style and print format configuration used when generating sourcing output.
• PO_SYSTEM_PARAMETERS, FINANCIALS_SYSTEM_PARAMETERS, and PO_GA_ORG_ASSIGNMENTS — System-level defaults, financials setup, and organization assignment rules applied during document creation.
• ORG_FREIGHT, AP_TERMS, GL_PERIOD_STATUSES, and PO_AME_APPROVALS_S — Freight terms, payment terms, open/closed period validation, and AME approval records referenced during the creation and validation cycle.

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.