Search Results get_auction_request_id

Overview

PON_NEGOTIATION_HELPER_PVT is a private PL/SQL package in the APPS schema that provides internal helper logic for Oracle EBS Sourcing (Oracle Negotiations). It supports the negotiation and auction lifecycle handled by the PON (Purchasing Negotiation) module, including supplier bidding, auction attributes, item pricing, scoring, and document generation. As a PVT package, it is not intended as a public API; it is invoked by sibling packages such as PON_CLM_CLO_UTIL_PKG, PON_CP_INTRFAC_TO_TRANSACTION, PON_NEGOTIATION_PUBLISH_PVT, and recursively by itself. Its status is VALID in the documented 12.1.1/12.2.2 ETRM metadata.

Key Procedures and Functions

The package exposes approximately 27 documented procedures and functions. Purpose summaries include:

• WILL — Determines or evaluates whether a given negotiation condition or attribute will apply.
• GET_AUCTION_REQUEST_ID — Retrieves the auction request identifier associated with a negotiation.
• HAS_FIXED_AMT_OR_PER_UNIT_PE — Checks whether fixed-amount or per-unit price elements exist.
• HAS_GOODS_LINE_FIXED_AMOUNT_PE — Checks for fixed-amount price elements on goods lines.
• HAS_ITEMS — Determines whether a negotiation contains item lines.
• GET_NUMBER_OF_LINES — Returns the count of lines for a negotiation.
• GET_MAX_INTERNAL_AND_DOC_NUM — Obtains maximum internal and document numbers for numbering logic.
• REMOVE_SCORE — Removes scoring data associated with a negotiation response.
• HAS_PRICE_ELEMENTS — Checks for the presence of any price elements.
• HAS_SUPPLIER_PRICE_ELEMENTS — Checks for supplier-defined price elements.
• HAS_BUYER_PRICE_ELEMENTS — Checks for buyer-defined price elements.
• SYNC_PF_VALUES_BIDDING_PARTIES — Synchronizes price factor values for bidding parties.
• SYNC_PF_VALUES_ITEM_PRICES — Synchronizes price factor values into item prices.
• DELETE_ALL_LINES — Deletes all lines from a negotiation.
• DELETE_SINGLE_LINE — Deletes an individual negotiation line.
• RENUMBER_LINES — Renumbers negotiation lines after edit operations.
• DELETE_PAYMENT_ATTACHMENTS — Removes payment attachments associated with a negotiation.
• DELETE_DISCUSSIONS — Deletes discussion records tied to a negotiation.
• UPDATE_STAG_LINES_CLOSE_DATES — Updates staged line close dates.
• COUNT_LINES_LOTS_GROUPS — Counts lines, lots, and groups for structural validation.

Tables Accessed

The package reads and writes via APPS synonyms, including FND_ATTACHED_DOCUMENTS and PON_ATTACHMENT-related structures for attachments; PON_AUCTION_HEADERS_ALL, PON_AUCTION_ATTRIBUTES, PON_AUCTION_ATTR_MAPPING_B, PON_ATTRIBUTE_SCORES, PON_AUCTION_EXHIBIT_DETAILS, PON_AUCTION_ITEM_PRICES_ALL, PON_AUCTION_ITEM_PRICES_EXT_B, and PON_AUCTION_SHIPMENTS_ALL for auction configuration, attributes, exhibits, and pricing; PON_BIDDING_PARTIES for participant data; PON_DISCUSSIONS for negotiation threads; PON_AUC_DOCTYPES and PON_AUC_DOCTYPES_TL for document type lookups; PON_AUC_PAYMENTS_SHIPMENTS for payment/shipment defaults; and PON_LARGE_NEG_PF_VALUES for large negotiation price factor values.

Usage Notes

Because PON_NEGOTIATION_HELPER_PVT is a private package, it is not called directly from Oracle Forms or concurrent programs as a public API. Instead, it is invoked internally by public negotiation packages—principally PON_CLM_CLO_UTIL_PKG, PON_CP_INTRFAC_TO_TRANSACTION, and PON_NEGOTIATION_PUBLISH_PVT—during negotiation creation, modification, publishing, and closeout. Custom extensions should not call this package directly; instead, integrate through supported public APIs or the PON_ negotiation interface tables to avoid breakage across upgrades.