Search Results apply_contract

Overview

CS_EST_APPLY_CONTRACT_PKG is an Oracle EBS Service (CS) module PL/SQL package owned by the APPS schema. It functions as a supporting API within the Oracle TeleService and Service Contracts entitlement flow, specifically bridging estimated contract coverage data (CS_ESTIMATE_DETAILS) with the entitlement and contract engine exposed through the OKS (Service Contracts) public APIs. In the 12.1.1 and 12.2.2 releases of Oracle E-Business Suite, the package is classified as an "OTHER" API, meaning it is an internal utility rather than a formally published, externally supported interface.

The package is listed with a header revision of 120.2 dated 2005/08/18, reflecting a long-standing artifact used during estimate processing. It is referenced by one other package, which indicates it occupies a mid-tier position in the dependency chain of the service estimation logic—consumed by higher-level processing routines rather than being invoked directly by end-user forms or concurrent programs.

Key Procedures and Functions

• APPLY_CONTRACT – Processes interface records to apply contract coverage, producing a discount amount output along with standard return status, message count, and message data outputs. The presence of p_coverage_id, p_coverage_txn_group_id, p_txn_billing_type_id, and p_business_process_id indicates it drives entitlement coverage application for a given coverage transaction group.
• UPDATE_ESTIMATE_DETAILS – Updates an existing estimate detail row, taking an estimate detail identifier and a discount price. This is the primary write path into CS_ESTIMATE_DETAILS.
• GET_CONTRACT_LINES – Retrieves contract lines into a collection of type ENT_CONTRACT_TAB (based on OKS_ENTITLEMENTS_PUB.GET_CONTOP_TBL). This procedure exposes the P_CALC_RESPTIME_FLAG parameter, a VARCHAR2 defaulting to NULL, which governs whether response-time calculations are included when qualifying contract lines. It also accepts customer, account, service line, customer product, system, inventory item, request date, business process, and validate flags—supporting bug fixes 3040124 for system and inventory item filtering.

Tables Accessed

• CS_ESTIMATE_DETAILS – The central repository for service estimate detail lines; read during contract line retrieval and written by UPDATE_ESTIMATE_DETAILS to persist discount pricing.
• PLITBLM – A standard Applications message/diagnostic table used to store message tokens and error data emitted through X_MSG_DATA, X_MSG_COUNT, and X_RETURN_STATUS.

Usage Notes

This package is invoked internally, typically from the entitlement estimator path that converts an estimate into applied contract coverage. It is not intended for direct invocation from Service Contracts forms or concurrent programs; the "OTHER" API classification confirms it is an internal dependency rather than a public interface. Custom code should prefer the formally published OKS_ENTITLEMENTS_PUB APIs over calling CS_EST_APPLY_CONTRACT_PKG directly, since the package’s signature and behavior are subject to change without notice between 12.1.1 and 12.2.2. Debugging efforts involving p_calc_resptime_flag should focus on GET_CONTRACT_LINES, where a non-NULL value triggers response-time qualification logic during contract line retrieval.