Search Results oks_coverage

Overview

OKS_CON_COVERAGE_PUB is a public PL/SQL package in the Oracle E-Business Suite Service Contracts (OKS) module, owned by the APPS schema and classified as a public API. Its documented display name is "Coverage utility procedures," and it is catalogued under the business entity OKS_COVERAGE. The package provides programmatic access to service contract coverage information, allowing callers to retrieve the monetary benefit (discount or covered amount) that a service or extended warranty contract applies to a given transaction, and to enumerate the business processes and associated price lists that govern a contract line.

The package exposes three documented program units: APPLY_CONTRACT_COVERAGE, GET_BP_PRICELIST, and GET_BILL_RATES. The header declares global constants G_PKG_NAME and G_APP_NAME (set to 'OKC'), along with two PL/SQL record and table types—ser_tbl_type and cov_tbl_type—used to pass sets of service lines into the coverage calculation and to return the corresponding discounted amounts and processing status. These structures indicate that the package is designed to process multiple contract lines in a single call, which is characteristic of pricing and coverage engines invoked during the contract authoring and billing cycles.

Key Procedures and Functions

• APPLY_CONTRACT_COVERAGE — Returns the discounted charge amount for a given business process. Per the documented comment, it calculates the amount for a Service or Extended Warranty based on the Discount Amount and Percentage Covered specified in the service contract coverage terms. It accepts service line records (charges line number, estimate detail ID, contract line ID, transaction group ID, business process ID, request date, and billing type) and returns corresponding coverage records that add the discounted amount and a status indicator.
• GET_BP_PRICELIST — Returns all business processes and their respective price lists for a given contract line. This is the routine most frequently referenced in custom pricing and integration code, and it is the object surfaced by the search term "get_bp_pricelist." It supports callers that must determine which price list applies to each business process attached to a contract line before performing qualification, pricing, or coverage evaluation.
• GET_BILL_RATES — Retrieves billing rate information associated with contract coverage, supporting downstream billing and revenue recognition processing for covered service lines.

Tables Accessed

The ETRM metadata does not enumerate specific base tables; the package accesses its data through APPS synonyms, consistent with standard Oracle EBS coding practice. Functionally, the package reads the Service Contracts coverage and pricing structures—contract lines, business process assignments, price lists, and coverage terms—to derive discount amounts and billing rates. It is documented as being referenced by seven other packages, confirming that it serves as a shared utility layer rather than an entry point that directly owns transactional data.

Usage Notes

OKS_CON_COVERAGE_PUB is typically invoked from Service Contracts forms and concurrent programs during contract authoring, pricing, and billing, and from custom code that needs to replicate coverage or price list derivation logic. Because it is a public API, Oracle supports direct calls, but the documented reference is Oracle Metalink Bulletin 284732.1, which should be consulted for supported usage, parameter semantics, and version-specific behaviour prior to building custom integrations. Developers should rely on the packaged APIs rather than querying the underlying coverage tables directly, and should account for the bulk record types when processing multiple contract lines to avoid row-by-row performance degradation. The header identifies the source file as OKSPACCS.pls, revision 120.0, providing a traceable reference point for the 12.1.1 and 12.2.2 releases.