PACKAGE: APPS.GMI_ALLOCATE_INVENTORY_PVT

Source

1 PACKAGE GMI_ALLOCATE_INVENTORY_PVT AUTHID CURRENT_USER AS
2 /*  $Header: GMIVALIS.pls 115.6 2003/04/06 23:28:47 nchekuri ship $
3  +=========================================================================+
4  |                Copyright (c) 1998 Oracle Corporation                    |
5  |                        TVP, Reading, England                            |
6  |                         All rights reserved                             |
7  +=========================================================================+
8  | FILENAME                                                                |
9  |     GMIVALIS.pls                                                        |
10  |                                                                         |
11  | DESCRIPTION                                                             |
12  |     This package contains private procedures controling auto-allocation |
13  |     of OPM inventory against a particular oreder/shipment line.         |
14  |                                                                         |
15  | HISTORY                                                                 |
16  |     15-DEC-1999  K.Y.Hunt                                               |
17  +=========================================================================+
18   API Name  : GMI_ALLOCATE_INVENTORY_PVT
19   Type      : Private
20   Function  : This package contains private procedures controling auto-
21               allocation of OPM inventory against order/shipment lines.
22   Pre-reqs  : N/A
23   Parameters: Per function
24 
25   Current Vers  : 1.0
26 
27   Previous Vers : 1.0
28 
29   Initial Vers  : 1.0
30   Notes
31 */
32 
33 PROCEDURE ALLOCATE_LINE
34 ( p_allocation_rec     IN  GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
35 , p_ic_item_mst        IN  ic_item_mst%ROWTYPE
36 , p_ic_whse_mst        IN  ic_whse_mst%ROWTYPE
37 , p_op_alot_prm        IN  op_alot_prm%ROWTYPE
38 , p_batch_id	       IN  NUMBER DEFAULT NULL
39 , x_allocated_qty1     OUT NOCOPY NUMBER
40 , x_allocated_qty2     OUT NOCOPY NUMBER
41 , x_return_status      OUT NOCOPY VARCHAR2
42 , x_msg_count          OUT NOCOPY NUMBER
43 , x_msg_data           OUT NOCOPY VARCHAR2
44 );
45 
46 PROCEDURE BALANCE_DEFAULT_LOT
47 ( p_default_qty1       IN  NUMBER
48 , p_default_qty2       IN  NUMBER
49 , p_allocation_rec     IN  GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
50 , p_ic_item_mst        IN  ic_item_mst%ROWTYPE
51 , p_ic_whse_mst        IN  ic_whse_mst%ROWTYPE
52 , x_return_status      OUT NOCOPY VARCHAR2
53 , x_msg_count          OUT NOCOPY NUMBER
54 , x_msg_data           OUT NOCOPY VARCHAR2
55 );
56 
57 FUNCTION CHECK_EXISTING_ALLOCATIONS
58 ( p_doc_id        IN ic_tran_pnd.doc_id%TYPE
59 , p_line_id       IN ic_tran_pnd.line_id%TYPE
60 , p_lot_ctl       IN ic_item_mst.lot_ctl%TYPE
61 , p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE
62 , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE
63 )
64 RETURN BOOLEAN;
65 
66 FUNCTION UNSTAGED_ALLOCATIONS_EXIST
67 ( p_doc_id        IN ic_tran_pnd.doc_id%TYPE
68 , p_line_id       IN ic_tran_pnd.line_id%TYPE
69 )
70 RETURN BOOLEAN;
71 
72 END GMI_ALLOCATE_INVENTORY_PVT;