Search Results aso_service_contracts_int




Overview
Explore in AI Chat

Overview

APPS.ASO_SERVICE_CONTRACTS_INT is a PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema. Its name and dependency footprint identify it as an integration and service-entitlement utility within the Oracle Service Contracts (OKS) and Oracle Quoting / Order Capture (ASO) product family. The package presents a PUBLIC interface (its specification, ASO_SERVICE_CONTRACTS_INT) that exposes a small set of inquiry-style functions used to determine whether service or warranty coverage exists for a given item instance, to retrieve the duration of that coverage, to enumerate the services available against an instance, and to return individual service attributes.

The body depends on OKS_EXTWAR_UTIL_PUB, OKS_EXTWAR_UTIL_PVT, OKS_OMINT_PUB, and OKC_API for warranty and contract retrieval, on ASO_QUOTE_PUB, ASO_UTILITY_PVT, and ASO_DEBUG_PUB for quoting context and diagnostics, on CS_STD and CSI_ITEM_INSTANCES for installed-base lookups, and on the standard FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE foundation packages for error handling, message stacking, and profile-option resolution. The ETRM record classifies the API as OTHER with a VALID status, and notes that it is referenced by six other packages while referencing no database objects through its own triggers or views.

Key Procedures and Functions

The documented PUBLIC interface exposes the following five program units. Parameter lists are not enumerated here, as they are defined in the package specification.

  • IS_SERVICE_AVAILABLE — Returns an indication of whether service coverage or entitlement is available for the supplied context, typically an item instance or inventory item. This is the primary Boolean-style gate used by callers before offering service options.
  • AVAILABLE_SERVICES — Returns the set of services that may be ordered or applied against the instance. This is used to populate selection lists in order capture and service workflows.
  • GET_DURATION — Retrieves the duration of an applicable service or warranty contract, supporting calculations such as remaining coverage period.
  • GET_WARRANTY — Retrieves warranty information associated with an item instance, delegating to the OKS external warranty utilities and contract APIs.
  • GET_SERVICE_ATTRIBUTES — Returns attribute detail for a specified service, supplying descriptive and qualifying information to downstream pricing and order logic.

Tables Accessed

  • CSI_ITEM_INSTANCES — The installed-base repository of customer item instances; the anchor for all entitlement and warranty inquiries.
  • ASO_QUOTE_HEADERS_ALL and ASO_QUOTE_LINES_ALL — Quote header and line data used when service availability is evaluated during quoting or order capture.
  • OE_ORDER_LINES_ALL — Order line data consulted where service entitlement is tied to ordered items.
  • MTL_SYSTEM_ITEMS_B (and the MTL_SYSTEM_ITEMS_VL view) — Item master information supplying item validation and descriptive attributes.
  • PLITBLM — The standard PL/SQL table/BLOB utility used by Oracle Forms and PL/SQL for bulk collections.

Usage Notes

The package is normally invoked indirectly. Oracle Quoting, Order Management, and Oracle Service Contracts flows call it to determine whether a customer's installed item is under warranty or eligible for a service offering, and to surface available services at the point of quote or order entry. It is typically reached through its PUBLIC specification rather than from custom code, and callers should observe standard EBS API conventions: initialize FND_GLOBAL and message tables, check FND_API.G_RET_STS_SUCCESS, and inspect FND_MSG_PUB for messages. Because the body references no database objects directly for its own persistence but is referenced by six other packages, it functions as a shared entitlement service layer rather than a data-maintenance API. Diagnostic behavior is supported through ASO_DEBUG_PUB, which can be enabled via profile options to trace entitlement resolution during troubleshooting.