Search Results get_unawarded_bid_total

Overview

PON_TRANSFORM_BIDDING_PKG is an Oracle EBS Sourcing (Oracle Sourcing / Oracle iSupplier Portal bidding) PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It encapsulates the server-side business logic that supports the transformation, evaluation, and pricing of supplier bids associated with an auction. Within the EBS 12.1.1 and 12.2.2 code lines, the package provides the calculation engine that determines supplier bid totals, price amounts, and quote values used during bid comparison and award processing.

The package operates against auction and bidding header records and their associated line-level price and quantity data. Its functions accept auction header identifiers, bid numbers, trading partner identifiers, contacts, and site references, and return numeric or character results that drive the sourcing user interface and downstream award logic. The inclusion of a dedicated p_site parameter across many of its functions reflects the requirement to scope calculations to a specific supplier site, since a single trading partner organization may transact through multiple sites.

Because it is classified as an OTHER API rather than a formal public API, it is intended for internal consumption by Oracle Sourcing forms, concurrent processes, and dependent packages rather than as a supported extension point for customer customization.

Key Procedures and Functions

• FIND_USER_SITE — Returns the site identifier associated with a given auction header, trading partner, and trading partner contact. It resolves which supplier site a bid should be attributed to.
• CHECK_EST_QTY_ON_ALL_BID_LINES — Validates estimated quantity data across all bid lines for a specified auction header and bid number, returning a status string.
• CALCULATE_SUPPLIER_BID_TOTAL — Computes the total bid amount for a supplier, honoring contract type and supplier view type, scoped by trading partner and site.
• CALCULATE_BID_TOTAL — Derives the overall bid total for an auction header, bid number, trading partner, and site.
• CALC_BTOTAL_WITH_OUT_OL — Offer Enhancement function that calculates bid totals excluding certain offer-line considerations.
• CALC_SUP_BTOTAL_WITH_OUT_OL — Companion supplier-level total calculation with the same offer enhancement exclusion.
• CALCULATE_PRICE — Overloaded function that computes a price value from line number, price, quantity, trading partner, contact, site, and requested supplier inputs.
• UNTRANSFORM_ONE_PRICE — Reverses a prior price transformation for a single price record.
• CALCULATE_QUOTE_AMOUNT — Produces the quote amount used in bid comparison.
• HAS_PF_VALUES_DEFINED — Determines whether price factor values have been defined, supporting price factor evaluation.
• GET_DISPLAY_CURRENCY_INFO — Retrieves currency display information for the bidding context.
• GET_UNAWARDED_BID_TOTAL — Returns the total value of bids that remain unawarded.

Tables Accessed

• PON_AUCTION_HEADERS_ALL — Primary auction header source supplying contract type and supplier view type.
• PON_BID_HEADERS — Bidding header data including auction header, trading partner, and contact references.
• PON_AUCTION_ITEM_PRICES_ALL and PON_BID_ITEM_PRICES — Line-level price and quantity data used in total and price calculations.
• PON_BIDDING_PARTIES — Supplier participation records tied to an auction.
• PON_AUC_DOCTYPES — Auction document type configuration.
• PON_PF_SUPPLIER_FORMULA and PON_PF_SUPPLIER_VALUES — Price factor formulas and supplier values supporting price factor evaluation.
• FND_CURRENCIES — Currency definitions used by GET_DISPLAY_CURRENCY_INFO.
• DUAL — Utility selection for scalar returns.

Usage Notes

PON_TRANSFORM_BIDDING_PKG is invoked internally by Oracle Sourcing forms and by two dependent packages documented in ETRM. It executes in the APPS schema context and is not exposed as a supported public API. The pervasive p_site parameter confirms that callers must supply a valid supplier site, typically obtained via FIND_USER_SITE, to ensure calculations reflect the correct trading partner location. Customizations that call this package directly should be treated as unsupported and re-validated across the 12.1.1 and 12.2.2 releases.