Search Results pon_large_auction_util_pkg

Overview

APPS.PON_LARGE_AUCTION_UTIL_PKG is a utility package body in the Oracle E-Business Suite Sourcing (Oracle Sourcing / Oracle iProcurement) module. Its principal business function is to support the high-volume import and management of supplier bids for large auctions within Oracle Sourcing. Large auctions — those with substantial bid volumes that risk exceeding normal processing limits — require dedicated utility routines to track concurrent request status, detect errors, cancel in-flight requests, and clean up bid data. This package encapsulates that logic.

The package is classified as an OTHER API (not a public, documented, callable interface), meaning it is an internal helper intended for use by other Sourcing components rather than by external integrations. It resides in the APPS schema with a VALID status and is referenced by 15 other database objects, confirming its role as a shared utility layer consumed by higher-level Sourcing packages.

Key Procedures and Functions

The package exposes 19 documented subprograms, organized into several functional groups:

Bid deletion: DELETE_BID removes a single bid record and its dependent data; DELETE_BID_BY_HEADER deletes bids associated with a given bid header; DELETE_BID_HEADER_ATTACHMENT removes attachments linked to a bid header.
Request status tracking: GET_REQUEST_INFO, GET_REQUEST_DISPLAY_STATUS, GET_REQUEST_INTERNAL_STATUS, and IS_REQUEST_COMPLETE retrieve and interpret the state of a concurrent request. IS_AUCTION_REQUEST_PENDING and IS_BID_REQUEST_PENDING report whether auction or bid requests remain outstanding.
Error handling: REQUEST_HAS_ERRORS and REQUEST_ERROR_COUNT detect and quantify errors for a request, while PURGE_INTERFACE_ERRORS_CP is a concurrent-program entry point that clears interface error records.
Concurrent request control: CANCEL_CONCURRENT_REQUEST terminates an active concurrent request.
Auction state helpers: IS_AUCTION_COMPLETE and IS_AUCTION_NOT_UPDATED determine completion and update status; UPDATE_AUCTION_IMPORT_COLS refreshes auction import columns; GET_DOCTYPE_SUFFIX derives a document-type suffix.
Numeric validation: IS_LARGE_NEG and IS_SUPER_LARGE_NEG test for large and super-large negative values, likely used to guard against numeric overflow or sentinel values in bid pricing.

Tables Accessed

The package reads and writes Sourcing transactional and administrative tables through APPS synonyms:

Auction and bid core: PON_AUCTION_HEADERS_ALL, PON_AUCTION_SUMMARY, PON_BID_HEADERS, PON_BID_ATTRIBUTE_VALUES, PON_BID_ITEM_PRICES, PON_BID_SHIPMENTS, PON_BID_PAYMENTS_SHIPMENTS, PON_BID_PRICE_ELEMENTS, and PON_BID_PRICE_DIFFERENTIALS hold auction definitions and supplier bid lines, prices, attributes, shipments, and price breakdowns.
Configuration and errors: PON_AUC_DOCTYPES, PON_INTERFACE_ERRORS, and PON_PARTY_PREFERENCES support document-type resolution, error logging, and party preference lookups.
Concurrent and attachments: FND_CONCURRENT_REQUESTS, FND_CONCURRENT, FND_ATTACHED_DOCUMENTS, and FND_ATTACHED_DOCUMENTS2_PKG provide request status and attachment management, while FND_API, FND_LOG, FND_MESSAGE, FND_PROFILE, OKC_TERMS_UTIL_GRP, and PON_CONTERMS_UTL_GRP supply standard API, logging, messaging, profile, and contract-terms utilities.

Usage Notes

PON_LARGE_AUCTION_UTIL_PKG is invoked internally by Oracle Sourcing forms and concurrent programs that process large auction bid imports and their cleanup. The presence of a public concurrent-program entry point (PURGE_INTERFACE_ERRORS_CP) and multiple status-checking functions indicates it is called from the "Purge Interface Errors" and related Sourcing concurrent requests, as well as from UI actions such as bid deletion. Because it is not referenced by any external database object and is classified as OTHER, customers and integrators should treat it as a private implementation utility. Custom code should not call it directly; instead, use supported Sourcing APIs. Any modification is unsupported and may compromise bid import integrity across releases 12.1.1 and 12.2.2.

SYNONYM: APPS.PON_INTERFACE_ERRORS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_INTERFACE_ERRORS, status:VALID,
PACKAGE BODY: APPS.PON_LARGE_AUCTION_UTIL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_LARGE_AUCTION_UTIL_PKG, status:VALID,
PACKAGE BODY: APPS.PON_LARGE_AUCTION_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_LARGE_AUCTION_UTIL_PKG, status:VALID,
PACKAGE: APPS.PON_LARGE_AUCTION_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_LARGE_AUCTION_UTIL_PKG, status:VALID,
SYNONYM: APPS.PON_INTERFACE_ERRORS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_INTERFACE_ERRORS, status:VALID,
PACKAGE: APPS.PON_LARGE_AUCTION_UTIL_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PON_LARGE_AUCTION_UTIL_PKG, status:VALID,
SYNONYM: APPS.PON_BID_HEADERS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_HEADERS, status:VALID,
SYNONYM: APPS.PON_BID_PRICE_DIFFERENTIALS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_DIFFERENTIALS, status:VALID,
SYNONYM: APPS.PON_AUCTION_HEADERS_ALL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_HEADERS_ALL, status:VALID,
PACKAGE: APPS.PON_CONTERMS_UTL_GRP 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_CONTERMS_UTL_GRP, status:VALID,
PACKAGE BODY: APPS.PON_MULTIPLE_RESPONSE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_MULTIPLE_RESPONSE_PKG, status:VALID,
SYNONYM: APPS.PON_BID_HEADERS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_HEADERS, status:VALID,
SYNONYM: APPS.PON_AUCTION_SUMMARY 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_SUMMARY, status:VALID,
PACKAGE: APPS.PON_UNSOL_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_UNSOL_UTIL_PKG, status:VALID,
SYNONYM: APPS.PON_PARTY_PREFERENCES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_PARTY_PREFERENCES, status:VALID,
SYNONYM: APPS.PON_BID_PRICE_DIFFERENTIALS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_DIFFERENTIALS, status:VALID,
12.1.1 DBA Data 12.1.1
SYNONYM: APPS.PON_PARTY_PREFERENCES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_PARTY_PREFERENCES, status:VALID,
SYNONYM: APPS.PON_BID_PRICE_ELEMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_ELEMENTS, status:VALID,
SYNONYM: APPS.PON_BID_PRICE_ELEMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PRICE_ELEMENTS, status:VALID,
PACKAGE: APPS.PON_CONTERMS_UTL_GRP 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PON_CONTERMS_UTL_GRP, status:VALID,
PACKAGE BODY: APPS.PON_PROFILE_UTIL_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_PROFILE_UTIL_PKG, status:VALID,
SYNONYM: APPS.PON_AUCTION_SUMMARY 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_AUCTION_SUMMARY, status:VALID,
SYNONYM: APPS.PON_BID_ATTRIBUTE_VALUES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_ATTRIBUTE_VALUES, status:VALID,
SYNONYM: APPS.PON_BID_SHIPMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_SHIPMENTS, status:VALID,
SYNONYM: APPS.PON_BID_SHIPMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_SHIPMENTS, status:VALID,
SYNONYM: APPS.PON_BID_ATTRIBUTE_VALUES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_ATTRIBUTE_VALUES, status:VALID,
SYNONYM: APPS.PON_BID_PAYMENTS_SHIPMENTS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PAYMENTS_SHIPMENTS, status:VALID,
SYNONYM: APPS.PON_BID_PAYMENTS_SHIPMENTS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_BID_PAYMENTS_SHIPMENTS, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.PON_PROFILE_UTIL_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_PROFILE_UTIL_PKG, status:VALID,
PACKAGE BODY: APPS.PON_RESPONSE_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_RESPONSE_PVT, status:VALID,
PACKAGE BODY: APPS.PON_NEGOTIATION_HELPER_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_NEGOTIATION_HELPER_PVT, status:VALID,
PACKAGE BODY: APPS.PON_AUCTION_HEADERS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AUCTION_HEADERS_PKG, status:VALID,
PACKAGE BODY: APPS.PON_BID_VALIDATIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_BID_VALIDATIONS_PKG, status:VALID,
PACKAGE BODY: APPS.PON_BID_VALIDATIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_BID_VALIDATIONS_PKG, status:VALID,
PACKAGE BODY: APPS.PON_FBO_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_FBO_PKG, status:VALID,
PACKAGE BODY: APPS.PON_AWARD_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AWARD_PKG, status:VALID,
PACKAGE BODY: APPS.PON_RESPONSE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_RESPONSE_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,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PON_BID_DEFAULTING_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_BID_DEFAULTING_PKG, status:VALID,
SYNONYM: APPS.PON_AUC_DOCTYPES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_AUC_DOCTYPES, status:VALID,
PACKAGE BODY: APPS.PON_AUCTION_HEADERS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AUCTION_HEADERS_PKG, 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 BODY: APPS.PON_RESPONSE_IMPORT_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_RESPONSE_IMPORT_PKG, status:VALID,
PACKAGE BODY: APPS.PON_AWARD_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AWARD_PKG, status:VALID,
PACKAGE BODY: APPS.PON_SOURCING_OPENAPI_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_SOURCING_OPENAPI_GRP, status:VALID,
PACKAGE BODY: APPS.PON_NEGOTIATION_PUBLISH_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_NEGOTIATION_PUBLISH_PVT, status:VALID,