Results for “pon_auction_interface_pkg”

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

Overview

PON_AUCTION_INTERFACE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the programmatic interface layer for Oracle Sourcing (also referenced as Oracle Negotiations) auction and negotiation authoring. Its primary business function is to create and populate negotiation records — draft auctions, negotiation lines, attributes, price differentials, invitees, and catalog descriptors — from external or upstream sources, most notably from Oracle Purchasing sourcing rules, requisition consolidation, and custom integration programs. The package abstracts the underlying PON_AUCTION_HEADERS_ALL and PON_AUCTION_ATTRIBUTES tables so that callers can build negotiations without directly manipulating the Sourcing base tables.

Requested through the ETRM repository metadata for releases 12.1.1 and 12.2.2, the package is classified as API type "OTHER" and is documented as VALID in the APPS schema. It is a dependent object in the Sourcing technical stack, referencing SYS.STANDARD and being referenced by PO_NEGOTIATIONS_SV1, PO_NEGOTIATION_REQ_NOTIF, and the package itself, indicating internal recursion and a dependency on the Negotiations service layer.

Key Procedures and Functions

• CREATE_DRAFT_NEGOTIATION — Creates the initial draft negotiation header, establishing the auction or negotiation in a modifiable, unpublished state prior to release to suppliers.
• ADD_NEGOTIATION_LINE — Adds a line to an existing negotiation, linking the line to the goods or services being sourced.
• ADD_CATALOG_DESCRIPTORS — Attaches catalog descriptor information to a negotiation line, supporting catalog-style sourcing content.
• ADD_PRICE_DIFFERENTIAL — Records price differential data used in negotiation scoring and evaluation.
• GET_NEGOTIATION_OWNER — Returns the owner responsible for the negotiation, supporting defaulting and validation logic.
• GET_PO_NEGOTIATION_LINK — Retrieves the association between a Purchasing document and its corresponding negotiation, enabling integration between Purchasing and Sourcing.
• ADD_NEGOTIATION_INVITEES — Adds supplier invitees to the negotiation, including party and contact information.
• GET_DEFAULT_NEGOTIATION_STYLE — Returns the default negotiation style applicable to the negotiation, driving style-dependent behavior.
• MAINTAIN_CLM_RELATIONS — Maintains relationships associated with the negotiation, typically sourced from the Trading Community Model (HZ) tables.

Eleven procedures and functions are documented in total; the entries above reflect the primary API surface exposed to callers.

Tables Accessed

The package reads and writes Sourcing base tables, principally PON_AUCTION_HEADERS_ALL and its synonym PON_AUCTION_HEADERS_ALL_S, and PON_AUCTION_ATTRIBUTES, which hold negotiation attributes and line-level configuration. It also references PON_ATTRIBUTES_INTERFACE, indicating use of the attribute interface staging structure during negotiation creation. For supplier, party, and relationship data, the package accesses HZ_PARTIES, HZ_RELATIONSHIPS, and HZ_CODE_ASSIGNMENTS. Oracle Foundation lookups and setup data are read from FND_LOOKUP_VALUES, FND_PRODUCT_GROUPS, FND_USER, FND_DOCUMENTS, FND_DOCUMENT_CATEGORIES, and FND_ATTACHED_DOCUMENTS, supporting defaulting, security, and attachment handling. Inventory reference data is obtained from MTL_CATEGORIES_KFV and MTL_UNITS_OF_MEASURE.

Usage Notes

PON_AUCTION_INTERFACE_PKG is not an end-user entry point. It is invoked indirectly by the Sourcing service layer — PO_NEGOTIATIONS_SV1 and PO_NEGOTIATION_REQ_NOTIF — and by the Sourcing negotiation UI when a negotiation is created from requisitions, purchase orders, or sourcing rules. Custom integrations that need to build negotiations programmatically should call the documented procedures rather than inserting into PON_AUCTION_HEADERS_ALL or PON_AUCTION_ATTRIBUTES directly, because the package applies validation, defaulting, attribute population, and relationship maintenance logic that the base tables do not enforce. The dependency on PO_NEGOTIATIONS_SV1 confirms that the package is a lower-level utility rather than the primary business API, so callers requiring full negotiation lifecycle behavior should prefer the Negotiations service package and treat PON_AUCTION_INTERFACE_PKG as its supporting interface layer.