Search Results delete_sbcr




Overview
Explore in AI Chat

Overview

APPS.PON_CLM_OKC_INTEG_PKG is a PL/SQL package body in the Oracle E-Business Suite APPS schema that provides integration logic between Oracle Sourcing (PON) contract and auction functionality and Oracle Contracts (OKC). The package is classified as an "OTHER" API, meaning it is neither a fully public interface nor a strictly private internal component. Its principal role is to bridge sourcing-side contract line and auction item pricing data with the Oracle Contracts repository, supporting the exchange of solution amounts, supplier bid cost/component records (SBCR), and supporting cleanup of those records.

The package holds a VALID status in the database and is documented for both Oracle EBS 12.1.1 and 12.2.2. It depends on several foundation and application objects, most notably the FND_API error-handling framework, FND_LOG for diagnostic logging, the OKC_IMP_RECORD_TYPES and OKC_REP_CONTRACT_IMP_PUB packages for contract import processing, and the PON_AUCTION_ITEM_PRICES_ALL table for auction pricing data.

Key Procedures and Functions

The ETRM metadata documents three program units within this package body:

  • GET_SOL_TOTAL_AMT — Returns the total solution amount associated with the sourcing/contract integration context. It is used to derive the aggregate value (for example, a bid, award, or contract total) that must be communicated to the contracts side.
  • GET_SBCR_DETAILS — Retrieves supplier bid cost/component record (SBCR) details. This procedure/function surfaces the detailed cost structure submitted by suppliers so that it can be passed to Oracle Contracts processing.
  • DELETE_SBCR — Removes previously captured SBCR records, supporting cleanup after integration processing or when a sourcing document is modified, cancelled, or re-released.

Parameter lists are not part of the documented metadata and are therefore not enumerated here. Consistent with the package's dependency on FND_API, these routines are expected to follow the standard EBS API conventions of an initialization flag and a return status/message structure.

Tables Accessed

The documented table accessed by this package is:

  • PON_AUCTION_ITEM_PRICES_ALL — The auction item prices table. It stores pricing information for auction line items in Oracle Sourcing. The package reads this table to obtain item-level pricing and pricing totals that must be integrated with contract records, and it is referenced in the context of the SBCR retrieval and deletion logic.

No other application tables are documented as direct references for this object, though the OKC_IMP_RECORD_TYPES and OKC_REP_CONTRACT_IMP_PUB dependencies indicate that contract import record structures are used during processing.

Usage Notes

PON_CLM_OKC_INTEG_PKG is not referenced by any other database object, as confirmed by both the dependency documentation and the ETRM metadata. It is therefore an entry-point package rather than a shared utility, and it is invoked through the standard Oracle Sourcing contract integration flow rather than from dependent PL/SQL code.

Typical invocation points include:

  • Oracle Sourcing / Oracle Contracts integration flows where negotiated auction or sourcing results are transferred into contract terms;
  • Concurrent programs or workflow-backed processing that trigger contract creation or update from sourcing documents;
  • Custom extensions that must reproduce the same integration behavior for solution amount and SBCR handling.

Because the package depends on FND_API and FND_LOG, failures are surfaced through the standard EBS API status and error message mechanism and are logged for diagnostics. Developers extending or debugging this integration should treat the FND_API return status and FND_LOG output as the primary troubleshooting signals. As with all APPS package bodies, direct modification is not supported; behavior should be extended through supported APIs or custom wrappers.