Search Results get_war_dur_per

Overview

The APPS.CS_WAR package body is a Service (CS) module PL/SQL unit in Oracle E-Business Suite that provides a thin wrapper layer over the core warranty-handling routines defined in the CS_STD package. Its business purpose is to expose warranty-related queries used by the Service and Depot Repair flows: identifying which warranty items are attached to a given inventory item, determining whether a warranty exists for a customer product instance, and retrieving the duration, period, and coverage details of a warranty as of a specified effective date.

The package is classified in ETRM as an OTHER API under the APPS schema, meaning it is not a formal public interface API but is still available for call by Service applications and custom extensions. The source header ($Header: csxcuwab.pls 120.0 2005/08/01) indicates the package has been stable since the 11i era and remains present through 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_WAR_ITEM_IDS — Returns the comma-separated list of item identifiers for warranties attached to a specified inventory item, evaluated as of a caller-supplied warranty date (defaulting to the current date). It accepts an organization context and inventory item identifier and returns the item ID list as a varchar2. Internally it delegates to CS_STD.GET_WAR_ITEM_IDS. The item-validation organization of the attached warranty is assumed to match the item's own organization.
• WARRANTY_EXISTS — Returns a single-character flag (Y or N) indicating whether a warranty is attached to a given customer product instance, identified by its product/instance ID. It delegates to CS_STD.WARRANTY_EXISTS.
• GET_WAR_DUR_PER — The procedure most relevant to the search term "get_war_dur_per". It retrieves the duration, unit of measure, and coverage schedule identifier for a warranty attached to a product, evaluated as of a caller-supplied warranty date (defaulting to SYSDATE). It operates in an IN OUT NOCOPY mode for its output parameters, and the caller is responsible for ensuring the specified warranty is a valid warranty on the product — otherwise an NO_DATA_FOUND exception is raised. It is declared with organization, product inventory item, and warranty inventory item inputs, and uses internal locals l_war_date and l_com_bill_seq_id during processing.

Tables Accessed

The documented metadata identifies MTL_SYSTEM_ITEMS (accessed via an APPS synonym) as the primary table reference. This is consistent with the package's warranty-validation logic, which needs to confirm that the warranty item and the product item share the same item-validation organization. Warranty definition and coverage data ultimately reside in the CS warranty schema tables, which the delegated CS_STD routines access on behalf of CS_WAR; the wrapper itself contributes the item-organization validation against MTL_SYSTEM_ITEMS.

Usage Notes

CS_WAR is typically invoked from Service forms, Depot Repair processes, and custom PL/SQL that must determine warranty eligibility or display warranty coverage on a service request, repair order, or customer product record. Because it is a wrapper around CS_STD, the recommended invocation pattern is to call the wrapper rather than the underlying package directly, preserving organization-validation behavior. It is referenced by zero other packages in the documented ETRM metadata, indicating it functions as an entry-point utility rather than a shared library. Callers of GET_WAR_DUR_PER should handle NO_DATA_FOUND explicitly, since the procedure raises it when no valid warranty exists for the product as of the supplied date. The default of SYSDATE on the warranty-date parameters makes the functions convenient for real-time validation, while explicit date values support historical or as-of-date warranty reporting. All three routines are read-only in nature, making them safe for use in query-only customizations and reporting extensions.