Search Results get_bill_rates




Overview
Explore in AI Chat

Overview

The APPS.OKS_CON_COVERAGE_PUB package body is a public API belonging to the Oracle E-Business Suite Service Contracts (OKS) module. Its principal business function is to apply contract coverage — including entitlement and discount logic — to service and estimate amounts. In an EBS environment, this package supports the pricing and coverage determination that occurs when a service contract is applied to a repair, order, or estimate line, allowing the system to compute the effectively discounted amount a customer pays once the terms of an active service contract are taken into account.

As a _PUB (public) API, the package serves as the externally supported entry point. It follows Oracle's standard API architecture: the public wrapper validates and routes the call to the corresponding private implementation (OKS_CON_COVERAGE_PVT), while the private package performs the actual business logic against the underlying tables. The header comment ($Header: OKSPACCB.pls 120.0 ...) indicates the API is an established, low-versioned component within the OKS data model.

Key Procedures and Functions

The package exposes three documented procedures, all classified as public API:

  • apply_contract_coverage — The primary procedure and the object of the user's search. It accepts an input table of estimated amounts and returns a corresponding table of estimated discounted amounts after applying contract coverage. It is the only procedure whose full signature appears in the source excerpt. The input table is of type ser_tbl_type and the output table is of type cov_tbl_type.
  • get_bp_pricelist — Retrieves a business partner price list associated with contract coverage evaluation, used to resolve price-list-based pricing in the coverage computation.
  • get_bill_rates — Returns billing rate information used in coverage and entitlement calculations, supporting the rate determination needed to derive discounted amounts.

All three follow the EBS API conventions of version and initialization parameters, returning status, message count, and message data to the caller. The specific parameter lists for get_bp_pricelist and get_bill_rates are not reproduced in the metadata and are not restated here.

Tables Accessed

The provided ETRM metadata does not enumerate the tables referenced by this package via APPS synonyms, so a definitive documented table list is unavailable. By design, OKS_CON_COVERAGE_PUB delegates all data access to its private counterpart OKS_CON_COVERAGE_PVT, which reads service contract coverage definitions, entitlement rules, and pricing/rate data to compute the discounted amounts. The public body itself contains no direct SQL; it manages the API activity lifecycle through OKC_API.START_ACTIVITY and OKC_API.END_ACTIVITY.

Usage Notes

OKS_CON_COVERAGE_PUB.apply_contract_coverage is typically invoked during service pricing and coverage determination flows — from Service Contracts forms, from estimate and service request processing, or from custom extensions that require contract-based discounting of amounts. The metadata records that the package is referenced by seven other packages, indicating its role as a shared pricing utility within OKS.

Callers should observe standard EBS API protocol: pass the API version and initialization flag, inspect x_return_status for G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR, and retrieve messages via the message count and message data outputs. Because the public layer traps and standardizes exceptions through OKC_API.HANDLE_EXCEPTIONS, callers should always check the return status rather than relying on unhandled exceptions.