1 PACKAGE INV_SUPPLIER_OWNED_STOCK_GRP AUTHID CURRENT_USER AS
2 --$Header: INVGTPSS.pls 115.0 2002/11/19 21:37:02 vma noship $
3 --============================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, California, USA |
6 --| All rights reserved. |
7 --============================================================================+
8 --| |
9 --| FILENAME : INVSTPSS.pls |
10 --| |
11 --| DESCRIPTION: This package is used to check on hand consigned |
12 --| or VMI stock of suppliers |
13 --| |
14 --| HISTORY: 18-NOV-2002 : vma |
15 --|===========================================================================+
16
17 --========================================================================
18 -- FUNCTION : SUPPLIER_OWNS_TPS PUBLIC
19 -- PARAMETERS : p_vendor_id IN NUMBER
20 -- RETURN : TRUE if on hand consigned stock exist for the supplier;
21 -- FALSE otherwise.
22 -- DESCRIPTION : Check whether on hand consigned stock exists for a given
23 -- supplier. The function checks whether any supplier site
24 -- of this supplier owns on hand consigned stock.
25 --
26 -- CHANGE HISTORY : 18-Nov-2002 Created by VMA
27 --========================================================================
28 FUNCTION supplier_owns_tps (p_vendor_id IN NUMBER) RETURN BOOLEAN;
29
30
31 --========================================================================
32 -- FUNCTION : SUP_SITE_OWNS_TPS PUBLIC
33 -- PARAMETERS : p_vendor_site_id IN NUMBER
34 -- RETURN : TRUE if on hand consigned or VMI stock exist for the
35 -- supplier site; FALSE otherwise.
36 -- DESCRIPTION : Check whether on hand consigned or VMI stock exists for
37 -- a given supplier site.
38 --
39 -- CHANGE HISTORY : 18-Nov-2002 Created by VMA
40 --========================================================================
41 FUNCTION sup_site_owns_tps(p_vendor_site_id IN Number) RETURN BOOLEAN;
42
43
44 END INV_SUPPLIER_OWNED_STOCK_GRP;