1 PACKAGE BODY INV_SUPPLIER_OWNED_STOCK_GRP AS
2 --$Header: INVGTPSB.pls 115.3 2003/01/23 01:09:55 vma noship $
3 --============================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, California, USA |
6 --| All rights reserved. |
7 --============================================================================+
8 --| |
9 --| FILENAME : INVGTPSS.pls |
10 --| |
11 --| DESCRIPTION: OBSOLETED FILE |
12 --| This package is used to check on hand consigned |
13 --| or VMI stock of suppliers |
14 --| |
15 --| HISTORY: 18-NOV-2002 vma Created |
16 --| 22-Jan-2003 vma Obsolete the file by replacing |
17 --| functions with empty stubs. |
18 --| Active functions are now in file |
19 --| INVMPOXB.pls |
20 --|===========================================================================+
21
22 --========================================================================
23 -- FUNCTION : SUPPLIER_OWNS_TPS PUBLIC
24 -- PARAMETERS : p_vendor_id IN NUMBER
25 -- RETURN : TRUE if on hand consigned stock exist for the supplier;
26 -- FALSE otherwise.
27 -- DESCRIPTION : Check whether on hand consigned stock exists for a given
28 -- supplier. The function checks whether any supplier site
29 -- of this supplier owns on hand consigned stock.
30 --
31 -- CHANGE HISTORY : 18-Nov-2002 vma Created
32 -- 22-Jan-2003 vma Obsoleted
33 --========================================================================
34 FUNCTION supplier_owns_tps (p_vendor_id IN NUMBER) RETURN BOOLEAN IS
35 BEGIN
36 RETURN FALSE;
37 END supplier_owns_tps;
38
39
40 --========================================================================
41 -- FUNCTION : SUP_SITE_OWNS_TPS PUBLIC
42 -- PARAMETERS : p_vendor_site_id IN NUMBER
43 -- RETURN : TRUE if on hand consigned or VMI stock exist for the
44 -- supplier site; FALSE otherwise.
45 -- DESCRIPTION : Check whether on hand consigned or VMI stock exists for
46 -- a given supplier site.
47 --
48 -- CHANGE HISTORY : 18-Nov-2002 vma Created
49 -- 22-Jan-2003 vma Obsoleted
50 --========================================================================
51 FUNCTION sup_site_owns_tps(p_vendor_site_id IN Number) RETURN BOOLEAN IS
52 BEGIN
53 RETURN FALSE;
54 END sup_site_owns_tps;
55
56
57 END INV_SUPPLIER_OWNED_STOCK_GRP;