Search Results pon_auction_headers_pkg




Overview
Explore in AI Chat

Overview

PON_AUCTION_HEADERS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Sourcing (Oracle Sourcing / Oracle iProcurement sourcing) auction engine. Its central role is to manage the header-level state of an auction or negotiation — including auction metadata, bid ranking, best-price evaluation, and proxy bidding — against the underlying tables PON_AUCTION_HEADERS_ALL and its dependent child records. In ETRM terms the package is classified as an "OTHER" API, meaning it is not published as a formally supported open interface but remains a core internal component of the Sourcing application.

The package is validated. Its only explicit external dependency is on SYS.STANDARD (the PL/SQL STANDARD package), signalling that it is largely self-contained and relies on the APPS synonyms for its data access. It sits at the heart of the auction processing logic, and is referenced by PON_PRINTING_PKG and PON_RESPONSE_PVT, which confirms its role in printing negotiation documents and in processing supplier responses.

Key Procedures and Functions

ETRM documents 21 procedures and functions, oriented around three functional themes: proxy bidding, price and ranking evaluation, and auction information maintenance.

Tables Accessed

The package reads and writes the principal auction and bid tables through APPS synonyms. PON_AUCTION_HEADERS_ALL and PON_AUCTION_ITEM_PRICES_ALL hold the auction header and item price records updated by UPDATE_AUCTION_INFO and the price routines. PON_BID_HEADERS, PON_BID_HEADERS_S, and PON_BID_ITEM_PRICES hold supplier bid headers and item prices used by ranking, best-price, and proxy-bid evaluation. PON_BIDDING_PARTIES and PON_BID_ATTRIBUTE_VALUES provide supplier participation and attribute-level scoring data. Business rules are sourced from PON_AUC_BIZRULES and PON_AUC_DOCTYPE_RULES, driving mask and rule behaviour. Finally, FND_USER and the FND_DOCUMENTS / FND_ATTACHED_DOCUMENTS / FND_DOCUMENT_CATEGORIES family support user identification and negotiation document attachments.

Usage Notes

PON_AUCTION_HEADERS_PKG is invoked indirectly by the Sourcing application rather than called directly by end users. It is most commonly reached through the Oracle Sourcing and iProcurement Java/Forms front end when buyers create or amend auctions, when the bidding engine evaluates supplier responses, and when proxy bids are placed. PON_PRINTING_PKG calls it while generating printable auction documents, and PON_RESPONSE_PVT calls it when processing supplier responses, indicating that the package is exercised during both the buyer-side setup and supplier-side bidding phases.

Because the package is not a published API, customizations and extensions should avoid calling its subprograms directly unless the calling code is fully regression-tested against the specific patch level. Any custom integration should prefer documented open interfaces and treat PON_AUCTION_HEADERS_PKG as internal implementation, since its signature and behaviour are subject to change across EBS 12.1.1 and 12.2.2 releases.