Search Results pon_auction_pkg




Overview
Explore in AI Chat

Overview

PON_AUCTION_PKG is a core PL/SQL package in the APPS schema that supports the Oracle Sourcing (Oracle iProcurement/Sourcing) auction and negotiation functionality within Oracle E-Business Suite 12.1.1 and 12.2.2. It provides the procedural foundation for managing the full auction lifecycle — from bidder registration and auction start through bidding, bid retraction, disqualification, and award. The package status is documented as VALID in ETRM, indicating that it is a compiled and active database object in the APPS schema.

The package is heavily integrated into the sourcing module. It is referenced by twenty-six other packages, including PON_AUCTION_APPROVAL_PKG, PON_AUCTION_CREATE_PO_PKG, PON_AUCTION_INTERFACE_PKG, PON_AWARD_PKG, PON_RESPONSE_PVT, and PON_NEGOTIATION_PUBLISH_PVT. This dependency footprint confirms that PON_AUCTION_PKG acts as a central utility layer for auction-related processing rather than an isolated component. Its API classification is reported as OTHER, and 150 procedures and functions are documented, of which a representative subset is described below.

Key Procedures and Functions

The documented procedures cover auction state transitions, bidder management, and notification logic:

Tables Accessed

The package reads and writes to several core Sourcing and Oracle foundation tables via APPS synonyms:

Usage Notes

PON_AUCTION_PKG is not typically called directly by end users; it is invoked programmatically by other Sourcing packages, Oracle Sourcing forms, workflow components such as PON_WF_UTL_PKG, and concurrent programs that process auctions, bids, and notifications. Because it is referenced by PON_AUCTION_INTERFACE_PKG and PON_AUCTION_CREATE_PO_PKG, it participates in both interface/import processing and award-to-purchase-order flows. Custom extensions should invoke this package only through its documented procedure signatures, since it is an internal implementation package rather than a formally published public API. Any modifications to underlying tables should follow Oracle's standards for the APPS schema.