1 PACKAGE PO_INV_THIRD_PARTY_STOCK_MDTR AUTHID CURRENT_USER AS
2 -- $Header: POXMTPSS.pls 115.1 2002/12/13 01:24:38 fdubois noship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXMTPSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Consiged Inventory PO/INV dependency wrapper API. |
13 --| This mediator package is used to access INV objects from |
14 --| PO product. |
15 --| |
16 --| HISTORY |
17 --| 12/09/2002 vchu Created |
18 --| 12/12/2002 vma Added two functions Supplier_Owns_Tps and |
19 --| Sup_Site_Owns_Tps. |
20 --+=======================================================================+
21
22 --=========================================================================
23 -- PROCEDURES AND FUNCTIONS
24 --=========================================================================
25
26 --=========================================================================
27 -- FUNCTION : consumption_trans_exist
28 -- PARAMETERS: p_transaction_source_id ID of the parent blanket
29 -- agreement
30 -- p_inventory_item_id Item ID of the transaction.
31 -- This field
32 -- RETURNS : Return 'Y' if there exists a consumption transaction
33 -- that is in process for the passed in transaction source
34 -- agreement ID and and item ID. The value 'Y' is returned
35 -- if the passed in item ID is null and if there exists
36 -- consumption transactions that are in process and match
37 -- with the passed in transaction source ID. The value 'N'
38 -- is returned if no corresponding consumption transactions
39 -- that are in process are found.
40 -- COMMENT : This function is called by PO Summary form to decide
41 -- whether it can provide the "Finally Close" and "Cancel"
42 -- actions in the the list of control actions for a PO
43 -- Header or a PO Line.
44 --=========================================================================
45
46 FUNCTION consumption_trans_exist
47 ( p_transaction_source_id IN NUMBER
48 , p_item_id IN NUMBER
49 )
50 RETURN VARCHAR2;
51
52 --========================================================================
53 -- FUNCTION : Supplier_Owns_Tps PUBLIC
54 -- PARAMETERS : p_vendor_id IN NUMBER
55 -- RETURN : TRUE if on hand consigned stock exist for the supplier;
56 -- FALSE otherwise.
57 -- DESCRIPTION : Check whether on hand consigned stock exists for a given
58 -- supplier. The function checks whether any supplier site
59 -- of this supplier owns on hand consigned stock.
60 --
61 -- HISTORY : 18-Nov-2002 Created by VMA
62 --========================================================================
63 FUNCTION Supplier_Owns_Tps (p_vendor_id IN NUMBER) RETURN BOOLEAN;
64
65 --========================================================================
66 -- FUNCTION : Sup_Site_Owns_Tps PUBLIC
67 -- PARAMETERS : p_vendor_site_id IN NUMBER
68 -- RETURN : TRUE if on hand consigned or VMI stock exist for the
69 -- supplier site; FALSE otherwise.
70 -- DESCRIPTION : Check whether on hand consigned or VMI stock exists for
71 -- a given supplier site.
72 --
73 -- HISTORY : 18-Nov-2002 Created by VMA
74 --========================================================================
75 FUNCTION Sup_Site_Owns_Tps(p_vendor_site_id IN Number) RETURN BOOLEAN;
76
77
78 END PO_INV_THIRD_PARTY_STOCK_MDTR;
79