PACKAGE: APPS.GMI_QUANTITY_PVT

Source

1 PACKAGE GMI_QUANTITY_PVT AUTHID CURRENT_USER AS
2 -- $Header: GMIVQTYS.pls 115.2 99/07/16 04:50:14 porting ship  $
3 --+=========================================================================+
4 --|                Copyright (c) 1998 Oracle Corporation                    |
5 --|                        TVP, Reading, England                            |
6 --|                         All rights reserved                             |
7 --+=========================================================================+
8 --| FILENAME                                                                |
9 --|     GMIVQTYS.pls                                                        |
10 --|                                                                         |
11 --| DESCRIPTION                                                             |
12 --|     This package contains private procedures relating to inventory      |
13 --|     quantity API transactions                                           |
14 --|                                                                         |
15 --| HISTORY                                                                 |
16 --|     01-OCT-1998  M.Godfrey       Created                                |
17 --|     25-FEB-1999  M.Godfrey       Upgrade to R11                         |
18 --+=========================================================================+
19 -- API Name  : GMI_QUANTITY_PVT
20 -- Type      : Private
21 -- Function  : This package contains private procedures used to create
22 --             inventory quantity transactions.
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 
34 PROCEDURE Validate_Inventory_Posting
35 ( p_trans_rec          IN GMI_QUANTITY_PUB.trans_rec_typ
36 , x_item_id            OUT ic_item_mst.item_id%TYPE
37 , x_lot_id             OUT ic_lots_mst.lot_id%TYPE
38 , x_old_lot_status     OUT ic_lots_sts.lot_status%TYPE
39 , x_old_qc_grade       OUT qc_grad_mst.qc_grade%TYPE
40 , x_return_status      OUT VARCHAR2
41 , x_msg_count          OUT NUMBER
42 , x_msg_data           OUT VARCHAR2
43 , x_trans_rec          OUT GMI_QUANTITY_PUB.trans_rec_typ
44 );
45 --
46 
47 FUNCTION Insert_ic_jrnl_mst
48 ( p_ic_jrnl_mst_rec  IN ic_jrnl_mst%ROWTYPE
49 )
50 RETURN BOOLEAN;
51 
52 --
53 FUNCTION Insert_ic_adjs_jnl
54 ( p_ic_adjs_jnl_rec  IN ic_adjs_jnl%ROWTYPE
55 )
56 RETURN BOOLEAN;
57 
58 --
59 FUNCTION Check_unposted_jnl_lot_status
60 ( p_item_id      IN ic_item_mst.item_id%TYPE
61 , p_lot_id       IN ic_lots_mst.lot_id%TYPE
62 , p_whse_code    IN ic_whse_mst.whse_code%TYPE
63 , p_location     IN ic_loct_mst.location%TYPE
64 , p_lot_status   IN ic_lots_sts.lot_status%TYPE
65 )
66 RETURN BOOLEAN;
67 
68 --
69 FUNCTION Check_unposted_jnl_qc_grade
70 ( p_item_id      IN ic_item_mst.item_id%TYPE
71 , p_lot_id       IN ic_lots_mst.lot_id%TYPE
72 , p_qc_grade     IN qc_grad_mst.qc_grade%TYPE
73 )
74 RETURN BOOLEAN;
75 
76 END GMI_QUANTITY_PVT;