Search Results cs_est_apply_contract_pkg




Overview
Explore in AI Chat

Overview

CS_EST_APPLY_CONTRACT_PKG is a service-oriented PL/SQL package in the Oracle E-Business Suite (EBS) Service (CS) module. It functions as a bridge between estimate processing and Oracle Contracts (OKS) coverage application. Its principal role is to take estimate line and coverage information captured in the Service module and pass it to the Contracts Coverage public API (OKS_CON_COVERAGE_PUB.APPLY_CONTRACT_COVERAGE) so that a contract or service agreement can be applied against an estimate charge. In this way, pricing, coverage, and discount entitlements defined in a service contract are evaluated and reflected in the estimate.

The package is classified by ETRM as an "OTHER" API object, indicating it is a supporting/internal API rather than a formally published interface. The header comment in the source body carries the revision signature csxchcob.pls 120.2 and is marked "noship," confirming that it is a seed/internal component shipped with the applications stack. The package belongs to the APPS schema, which is standard for EBS PL/SQL APIs.

Key Procedures and Functions

  • APPLY_CONTRACT — The core procedure. It accepts estimate coverage context (coverage identifier, transaction group, billing type, business process, request date, and amount) and returns the applied discount amount along with standard API return status, message count, and message data. Internally it populates a Contracts coverage input record, validates that the mandatory attributes are not null, and invokes OKS_CON_COVERAGE_PUB.APPLY_CONTRACT_COVERAGE with an API version of 1.0 and P_INIT_MSG_LIST => 'T'. The output table returns the estimated discounted amounts.
  • UPDATE_ESTIMATE_DETAILS — Updates the persisted estimate detail records to reflect the contract coverage and discount results produced by the contract application process. This keeps the stored estimate data synchronized with what the Contracts engine calculated.
  • GET_CONTRACT_LINES — Retrieves contract line information relevant to an estimate. This procedure/function is the object matched by the user's search term. It supplies the contract line identifiers and associated details needed when applying coverage, effectively acting as the read-side counterpart to APPLY_CONTRACT.

Tables Accessed

  • CS_ESTIMATE_DETAILS — The Service estimate detail table. This package reads and updates estimate lines so that contract-derived coverage and pricing values are written back to the estimate.
  • PLITBLM — The standard EBS PL/SQL message table used for storing and retrieving API error and warning messages returned through the X_MSG_COUNT and X_MSG_DATA parameters.

In addition, the package operates on the OKS Contracts coverage API structures (OKS_CON_COVERAGE_PUB.ser_tbl_type and OKS_CON_COVERAGE_PUB.cov_tbl_type), which are passed as input and output record collections rather than direct table references.

Usage Notes

This package is typically invoked from Service module estimate workflows, including the estimate entry and coverage application forms, and from any concurrent or custom process that needs to apply contract coverage to an estimate. Because it wraps the OKS coverage API, callers should always inspect X_RETURN_STATUS and iterate the PLITBLM messages via X_MSG_COUNT and X_MSG_DATA to handle exceptions. The APPLY_CONTRACT procedure raises an internal e_contracts_warning exception to signal contract-specific warning conditions. ETRM records that this package is referenced by one other package, confirming it is a dependent utility rather than a top-level entry point. Developers extending estimate-to-contract integration should call APPLY_CONTRACT for application and GET_CONTRACT_LINES to resolve the relevant contract lines beforehand.