Search Results cs_war




Overview
Explore in AI Chat

Overview

CS_WAR is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Service (CS) product family and is classified as an OTHER API within the ETRM repository. The package encapsulates warranty-related queries against Oracle Inventory item definitions, allowing Service modules and dependent forms to resolve which warranties are attached to a given item or customer product, and to retrieve the warranty's duration, period, and coverage attributes.

The package header carries a version marker indicating a 2005 baseline, with the header comment noting that the item-validation organization of an attached warranty is the same as that of the item or product being queried. All three documented entry points are read-only in nature, consistent with an OTHER classification rather than a transactional or open-interface API.

Key Procedures and Functions

  • GET_WAR_ITEM_IDS — A function returning a comma-separated list of item identifiers representing the warranties attached to a specified inventory item, evaluated as of a warranty date. It accepts an organization, an inventory item, and an effective date, and returns a VARCHAR2. The package comment records that the function is used by CSOEBAT and by the CSXSUDCP form, a usage pattern documented since January 1997.
  • WARRANTY_EXISTS — A function returning a Y or N flag indicating whether a warranty is attached to a given customer product identifier. It carries a RESTRICT_REFERENCES pragma (WNDS, WNPS), confirming it performs no database writes and reads no package state.
  • GET_WAR_DUR_PER — A procedure that returns the duration, the unit of measure code, and the coverage schedule identifier for a warranty on a product, as of a specified warranty date. The caller is responsible for verifying that the warranty is valid for the product; otherwise the procedure raises NO_DATA_FOUND. Its output parameters are declared IN OUT NOCOPY.

Note that GET_WAR_ITEM_IDS has its RESTRICT_REFERENCES pragma commented out in the source, while WARRANTY_EXISTS retains an active pragma.

Tables Accessed

The documented table reference for CS_WAR is MTL_SYSTEM_ITEMS, accessed through an APPS synonym. This is consistent with the package's purpose: warranty identification and validation in Oracle Service depends on inventory item attributes, including the item-validation organization and the relationships between a product item and its attached warranty items. No other base tables are recorded in the ETRM metadata, suggesting the remaining warranty logic is resolved through the item master rather than through dedicated warranty tables.

Usage Notes

CS_WAR is invoked primarily from Oracle Service forms and batch routines. The documented callers are the CSXSUDCP form and the CSOEBAT program, both of which rely on the comma-separated warranty item list returned by GET_WAR_ITEM_IDS. Customizations and extensions that need to determine warranty attachment or coverage for a service product may call WARRANTY_EXISTS for a simple yes/no check, or GET_WAR_DUR_PER when duration and coverage schedule data are required.

Because the package is documented as referenced by zero other packages, its consumers are forms, concurrent/batch programs, and custom code rather than other PL/SQL APIs. Callers should respect the NO_DATA_FOUND behavior of GET_WAR_DUR_PER and default the warranty date to SYSDATE where no explicit as-of date is required.