1 PACKAGE AHL_WARRANTY_GRP AUTHID CURRENT_USER AS
2 /* $Header: AHLGSWCS.pls 120.0 2011/01/27 11:15:47 aukirade noship $ */
3 /*
4 * This Group package spec provides the APIs which may be invoked by other products
5 * such as Depot Repair
6 */
7
8 ------------------------------------------------------------------------------------
9 -- Start of Comments
10 -- Function name : IS_INSTANCE_WARRANTY_AVAILABLE
11 -- Type : Public
12 -- Function : Function to check if a given instance has at least one 'ACTIVE'
13 -- contract available or not. Returns 'Y' or 'N'.
14 -- Pre-reqs :
15 -- Parameters :
16 --
17 -- IS_INSTANCE_WARRANTY_AVAILABLE Parameters:
18 -- p_warranty_instance_id IN NUMBER Required : Warranty instance id
19 --
20 -- End of Comments
21
22 FUNCTION IS_INSTANCE_WARRANTY_AVAILABLE (
23 p_warranty_instance_id IN NUMBER
24 ) RETURN VARCHAR2;
25
26 END AHL_WARRANTY_GRP;