Search Results pon_exhibits_pkg

Overview

PON_EXHIBITS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER-type API within the Oracle Procurement (PON) product family. Its principal business function is to manage sourcing "exhibits" and their associated line detail records across negotiation, auction, and award workflows. Exhibits represent structured sections of supplier-facing negotiation or auction content — for example terms, delivery schedules, cost breakdowns, and CDRL (Contract Data Requirements List) attachments — that buyers assemble and suppliers respond to. The package provides the programmatic backbone for creating, copying, updating, and deleting those exhibit and exhibit-detail records, including the ELIN (Exhibit Line Item Number) associations that link individual negotiation lines to their exhibit definitions.

The package is marked VALID in the ETRM registry under release 12.1.1 and 12.2.2, and exposure is governed by profile-controlled enablement checks, allowing the exhibits feature to be switched on or off per operating context.

Key Procedures and Functions

Seventeen documented procedures and functions are exposed. Their purposes are summarized below.

IS_EXHIBITS_ENABLED / IS_EXHIBITS_ENABLED_FOR_AUC / IS_CDRLS_ENABLED — Boolean-style check functions that report whether exhibits, auction-specific exhibits, or CDRL processing are enabled for the current context; callers use these before invoking the mutating APIs.
CREATE_EXHIBIT_DETAILS / UPDATE_EXHIBIT_DETAILS / DELETE_EXHIBIT_DETAILS — Core maintenance routines that insert, amend, and remove individual exhibit detail rows associated with a negotiation or auction.
COPY_EXHIBITS / COPY_ELINS — Copy routines used when a negotiation, template, or auction is duplicated; they replicate exhibit definitions and their ELIN associations into the target document.
DELETE_EXHIBITS / DELETE_ELINS — Counterpart removal routines that purge exhibit and ELIN data, typically during document cancellation or cleanup.
GET_NEXT_EXHIBIT — Returns the next exhibit identifier/sequence, supporting automatic numbering during exhibit creation.
HANDLE_AUCTION_EXHIBIT_DETAILS — Auction-specific handler that synchronizes exhibit detail data with auction structures.
HAS_ELIN_ASSOC_FOR_LINE / IS_LINE_ELIN — Predicate functions that test whether a given line has an ELIN association or whether the line itself is an ELIN, used to drive UI and validation logic.
INSERT_CDRL_EXHIBIT_DETAILS / DELETE_CDRL_EXHIBIT_DETAILS — Specialized routines that manage CDRL-specific exhibit detail records.
LOG_MESSAGE — Generic logging utility used for diagnostic and error messaging throughout the package.

The metadata does not document parameter signatures; the descriptions above reflect each routine's name and documented role only.

Tables Accessed

The package operates against the following tables through APPS synonyms. PON_AUCTION_EXHIBIT_DETAILS is the primary transactional store for exhibit detail rows, supported by PON_AUCTION_HEADERS_ALL and PON_AUCTION_ITEM_PRICES_ALL for auction header and pricing context. OKC_DELIVERABLES supports CDRL-related exhibit handling. FND_LOOKUP_VALUES supplies lookup codes and enablement values, FND_USER provides the current user identity for auditing and logging, DUAL supports single-row evaluations, and PLITBLM serves as the standard EBS PL/SQL index-by table of VARCHAR2 for bulk message handling.

Usage Notes

PON_EXHIBITS_PKG is an internal, non-public API. It is not referenced independently by forms or concurrent programs but is consumed by five other packages: OKC_CDRL_PVT, PON_AWARD_PKG, PON_BID_DEFAULTING_PKG, PON_NEGOTIATION_HELPER_PVT, and PON_SOURCING_OPENAPI_GRP. These package dependencies indicate the exhibits functionality is invoked during award processing, bid defaulting, negotiation UI support, CDRL integration, and sourcing open-API calls. Because the underlying exhibit tables are auction-oriented, the package is most active in auction and negotiation flows rather than standard purchase order entry. Customizations should call these routines rather than writing directly to the underlying tables, and should always test the IS_EXHIBITS_ENABLED family of functions first to respect configuration and avoid unintended writes.

PACKAGE: APPS.PON_EXHIBITS_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_EXHIBITS_PKG, status:VALID,
PACKAGE BODY: APPS.PON_EXHIBITS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_EXHIBITS_PKG, status:VALID,
PACKAGE: APPS.PON_CLM_CLO_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_CLM_CLO_UTIL_PKG, status:VALID,
PACKAGE: APPS.PON_CLO_RENUMBER_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_CLO_RENUMBER_PKG, status:VALID,
SYNONYM: APPS.OKC_DELIVERABLES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_DELIVERABLES, status:VALID,
PACKAGE BODY: APPS.OKC_CDRL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_CDRL_PVT, status:VALID,
SYNONYM: APPS.PON_AUCTION_EXHIBIT_DETAILS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_EXHIBIT_DETAILS, status:VALID,
PACKAGE: APPS.PON_EXHIBITS_PKG 12.2.2
PACKAGE: APPS.OKC_CDRL_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_CDRL_PVT, status:VALID,
PACKAGE BODY: APPS.PON_NEGOTIATION_HELPER_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_NEGOTIATION_HELPER_PVT, status:VALID,
PACKAGE BODY: APPS.PON_AWARD_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AWARD_PKG, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.PON_CLM_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_CLM_UTIL_PKG, status:VALID,
PACKAGE BODY: APPS.PON_BID_DEFAULTING_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_BID_DEFAULTING_PKG, status:VALID,
PACKAGE BODY: APPS.PON_SOURCING_OPENAPI_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_SOURCING_OPENAPI_GRP, status:VALID,
SYNONYM: APPS.PON_AUCTION_ITEM_PRICES_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_ITEM_PRICES_ALL, status:VALID,
SYNONYM: APPS.PON_AUCTION_HEADERS_ALL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_HEADERS_ALL, status:VALID,
PACKAGE: APPS.PO_CORE_S 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PO_CORE_S, status:VALID,
TYPE: APPS.PO_TBL_VARCHAR30 12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_VARCHAR30, status:VALID,
PACKAGE BODY: APPS.PON_EXHIBITS_PKG 12.2.2
APPS.PON_EXHIBITS_PKG dependencies on PON_EXHIBITS_PKG 12.2.2
APPS.OKC_CDRL_PVT dependencies on PON_EXHIBITS_PKG 12.2.2
APPS.PON_NEGOTIATION_HELPER_PVT dependencies on PON_EXHIBITS_PKG 12.2.2
APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_EXHIBITS_PKG 12.2.2
TYPE: APPS.PO_TBL_NUMBER 12.2.2
owner:APPS, object_type:TYPE, object_name:PO_TBL_NUMBER, status:VALID,
APPS.PON_BID_DEFAULTING_PKG dependencies on PON_EXHIBITS_PKG 12.2.2
APPS.PON_AWARD_PKG dependencies on PON_EXHIBITS_PKG 12.2.2
SYNONYM: APPS.FND_LOOKUP_VALUES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_LOOKUP_VALUES, status:VALID,
SYNONYM: APPS.FND_USER 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_USER, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: APPS.FND_LOG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_LOG, status:VALID,
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
PACKAGE: APPS.FND_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.FND_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,