PACKAGE: APPS.GMI_GLOBAL_GRP

Source

1 PACKAGE GMI_GLOBAL_GRP AUTHID CURRENT_USER AS
2 -- $Header: GMIGGBLS.pls 115.3 2002/10/25 18:14:15 jdiiorio ship $
3 --+=========================================================================+
4 --|                Copyright (c) 1998 Oracle Corporation                    |
5 --|                        TVP, Reading, England                            |
6 --|                         All rights reserved                             |
7 --+=========================================================================+
8 --| FILENAME                                                                |
9 --|     GMIGGBLS.pls                                                        |
10 --|                                                                         |
11 --| DESCRIPTION                                                             |
12 --|     This package contains global inventory functions and procedures     |
13 --|                                                                         |
14 --| HISTORY                                                                 |
15 --|     01-OCT-1998  M.Godfrey       Created                                |
16 --|     17-FEB-1999  M.Godfrey       Upgrade to R11                         |
17 --|     25-OCT-2002  J. DiIorio      Bug#2643330 - added nocopy             |
18 --+=========================================================================+
19 -- API Name  : GMI_GLOBAL_GRP
20 -- Type      : Group
21 -- Function  : This package contains inventory global functions and
22 --             procedures
23 -- Pre-reqs  : N/A
24 -- Parameters: Per function
25 --
26 -- Current Vers  : 2.0
27 --
28 -- Previous Vers : 1.0
29 --
30 -- Initial Vers  : 1.0
31 -- Notes
32 --
33 PROCEDURE Get_Item
34 ( p_item_no       IN ic_item_mst.item_no%TYPE
35 , x_ic_item_mst   OUT NOCOPY ic_item_mst%ROWTYPE
36 , x_ic_item_cpg   OUT NOCOPY ic_item_cpg%ROWTYPE
37 );
38 
39 PROCEDURE Get_Lot
40 ( p_item_id       IN ic_lots_mst.item_id%TYPE
41 , p_lot_no        IN ic_lots_mst.lot_no%TYPE
42 , p_sublot_no     IN ic_lots_mst.sublot_no%TYPE
43 , x_ic_lots_mst   OUT NOCOPY ic_lots_mst%ROWTYPE
44 , x_ic_lots_cpg   OUT NOCOPY ic_lots_cpg%ROWTYPE
45 );
46 
47 PROCEDURE Get_Warehouse
48 ( p_whse_code     IN ic_whse_mst.whse_code%TYPE
49 , x_ic_whse_mst   OUT NOCOPY ic_whse_mst%ROWTYPE
50 );
51 
52 PROCEDURE Get_Loct_Inv
53 ( p_item_id       IN ic_loct_inv.item_id%TYPE
54 , p_whse_code     IN ic_loct_inv.whse_code%TYPE
55 , p_lot_id        IN ic_loct_inv.lot_id%TYPE
56 , p_location      IN ic_loct_inv.location%TYPE
57 , p_delete_mark   IN ic_loct_inv.delete_mark%TYPE  DEFAULT 0
58 , x_ic_loct_inv   OUT NOCOPY ic_loct_inv%ROWTYPE
59 );
60 
61 PROCEDURE Get_Um
62 ( p_um_code       IN sy_uoms_mst.um_code%TYPE
63 , x_sy_uoms_mst   OUT NOCOPY sy_uoms_mst%ROWTYPE
64 , x_sy_uoms_typ   OUT NOCOPY sy_uoms_typ%ROWTYPE
65 , x_error_code    OUT NOCOPY NUMBER
66 );
67 
68 PROCEDURE Get_Lot_Inv
69 ( p_item_id       IN ic_loct_inv.item_id%TYPE
70 , p_lot_id        IN ic_loct_inv.lot_id%TYPE
71 , p_delete_mark   IN ic_loct_inv.delete_mark%TYPE  DEFAULT 0
72 , x_lot_onhand    OUT NOCOPY NUMBER
73 );
74 
75 END GMI_GLOBAL_GRP;