Results for “pon_auction_headers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PON_SUPPLIER_RESEARCH_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Sourcing module. It serves as the internal engine behind the Supplier Research functionality, which allows sourcing and procurement personnel to evaluate a supplier's historical performance and activity across the negotiation and purchasing lifecycle. Rather than exposing a public interface, this private package provides the computational logic that aggregates transactional statistics for a given supplier or party, drawing from both the Sourcing (PON) and Purchasing (PO) schemas.

The package is classified as a helper or supporting package: ETRM metadata confirms that it is referenced by zero other database objects, meaning it is invoked internally by dependent Sourcing code rather than being called directly by external program units. Because the package depends on FND_PROFILE, its behavior may be influenced by profile option settings governing multi-org and operating unit context. The body's status is VALID across both 12.1.1 and 12.2.2, and its table dependencies are resolved through APPS synonyms.

Key Procedures and Functions

The ETRM documentation identifies four procedures/functions exposed by this package body. Each is oriented toward returning aggregate counts used in supplier scorecards and research displays:

• GET_TOTAL_INVITED_NEGOTIATIONS — Returns the count of sourcing negotiations to which the supplier has been invited. This value supports supplier participation and responsiveness metrics.
• GET_TOTAL_AWARDED_BIDS — Returns the count of bids or auctions the supplier has won, providing a measure of competitive success in sourcing events.
• GET_TOTAL_PO_DOCUMENTS — Returns the count of purchasing documents associated with the supplier, reflecting downstream purchasing activity.
• GET_TOTAL_TXN_HISTORY — Returns an aggregate transactional history figure for the supplier, generally the broadest of the four metrics.

Parameter lists are not disclosed in the ETRM metadata and are intentionally not enumerated here. The functions are presumed to accept a supplier or party identifier and return a numeric result.

Tables Accessed

The package reads from the following documented tables via APPS synonyms:

• HZ_PARTIES — The Trading Community Architecture registry of parties, used to link the supplier to its party record.
• PON_AUCTION_HEADERS — The header records for sourcing auctions, the source for invited and awarded negotiation counts. This is the table most directly associated with the user search term.
• PON_BIDDING_PARTIES — Records which suppliers were invited to and participated in each auction.
• PON_BID_HEADERS — The bid submissions, used to determine awarded bids.
• PO_HEADERS — Purchasing document headers for PO-related counts.
• PO_RELEASES_ALL — Release-level purchasing data, supporting the transactional history metric.

Additionally, the dependency listing names PO_VENDORS and FND_PROFILE. These are used to resolve the supplier identity and instance profile context respectively.

Usage Notes

Because PON_SUPPLIER_RESEARCH_PVT is a PVT package and is not referenced by any other database object per ETRM, it is not intended as a standalone integration point. It is invoked internally by the Sourcing application—typically in support of the Supplier Research or supplier qualification pages rendered through Oracle Forms (the PON form family) in 12.1.1 and the corresponding OAF-based pages in 12.2.2. Administrators and developers should treat it as a private implementation detail; direct custom calls are possible but unsupported because the signature is not part of a public API contract. Functional users observe its output indirectly as supplier activity counts displayed in sourcing and negotiation screens.