PACKAGE: APPS.CSP_VALIDATE_PUB

Source

1 PACKAGE CSP_VALIDATE_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspgtvps.pls 120.2 2008/06/30 10:52:24 htank ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_VALIDATE_PUB
5 -- File name        : cspgtvps.pls
6 -- Purpose          : The package includes public procedures used for CSP.
7 -- History          :
8 --   20-Dev-1999, Included Get_Avail_Qty function
9 --   10-Dec-1999, Vernon Lou
10 -- NOTE             :
11 -- End of Comments
12 
13 g_qoh  number := null;
14 g_atr  number := null;
15 
16 FUNCTION Get_Onhand_Qty RETURN NUMBER;
17 
18 FUNCTION Get_Available_Qty RETURN NUMBER;
19 
20 PROCEDURE CHECK_PART_AVAILABLE (
21     P_API_VERSION_NUMBER    IN  NUMBER,
22     P_INVENTORY_ITEM_ID     IN  NUMBER,
23     P_ORGANIZATION_ID       IN  NUMBER,
24     P_SUBINVENTORY_CODE     IN  VARCHAR2,
25     P_LOCATOR_ID            IN  NUMBER,
26     P_REVISION              IN  VARCHAR2,
27     P_SERIAL_NUMBER         IN  VARCHAR2,
28      P_LOT_NUMBER           IN  VARCHAR2,
29     X_AVAILABLE_QUANTITY    OUT NOCOPY NUMBER,
30     X_RETURN_STATUS         OUT NOCOPY VARCHAR2,
31     X_MSG_COUNT             OUT NOCOPY NUMBER,
32     X_MSG_DATA              OUT NOCOPY VARCHAR2
33     );
34 
35 
36 FUNCTION Get_Avail_Qty (
37 /*  Name: get_avail_qty
38     Purpose: Get the available quantity of an item at organization level, subinventory level or locator level.
39              For Spares Management, avail_qty = unreserved_qty = total_onhand_qty - reserved_qty
40     Author: Vernon Lou
41     Date: 2-Nov-99
42 */
43     p_organization_id   NUMBER,
44     p_subinventory_code VARCHAR2,
45     p_locator_id        NUMBER,
46     p_inventory_item_id NUMBER)
47 
48 RETURN NUMBER;
49 
50 FUNCTION Get_Avail_Qty (
51 /*  Name: get_avail_qty
52     Purpose: Get the available quantity of an item at organization level, subinventory level or locator level.
53              For Spares Management, avail_qty = unreserved_qty = total_onhand_qty - reserved_qty.
54              Also handling revision
55 
56     MODIFICATION HISTORY
57    -- Person     Date          Comments
58    -- ---------  ------        ------------------------------------------
59    -- hhaugeru   22-Jun-01     Created
60 
61    -- End of comments
62     Author: Hans Haugerud
63     Date: 22-Jun-01
64 */
65     p_organization_id   NUMBER,
66     p_subinventory_code VARCHAR2,
67     p_locator_id        NUMBER,
68     p_inventory_item_id NUMBER,
69     p_revision          VARCHAR2)
70 
71 RETURN NUMBER;
72 
73 -- bug # 7171956
74 FUNCTION Get_Avail_Qty (
75 /*  Name: get_avail_qty
76     Purpose: Get the available quantity of an item at organization level, subinventory level or locator level.
77              For Spares Management, avail_qty = unreserved_qty = total_onhand_qty - reserved_qty.
78              Also handling revision
79 */
80     p_organization_id   NUMBER,
81     p_subinventory_code VARCHAR2,
82     p_locator_id        NUMBER,
83     p_inventory_item_id NUMBER,
84     p_revision          VARCHAR2,
85     p_lot_num        VARCHAR2)
86 
87 RETURN NUMBER;
88 -- end of bug # 7171956
89 
90 END CSP_VALIDATE_PUB;