PACKAGE: APPS.GMI_QUANTITY_PUB

Source

1 PACKAGE GMI_QUANTITY_PUB AUTHID CURRENT_USER AS
2 -- $Header: GMIPQTYS.pls 115.3 2002/10/28 20:11:29 jdiiorio gmigapib.pls $
3 --+=========================================================================+
4 --|                Copyright (c) 1998 Oracle Corporation                    |
5 --|                        TVP, Reading, England                            |
6 --|                         All rights reserved                             |
7 --+=========================================================================+
8 --| FILENAME                                                                |
9 --|     GMIPQTYS.pls                                                        |
10 --|                                                                         |
11 --| DESCRIPTION                                                             |
12 --|     This package contains public procedures relating creation of        |
13 --|     inventory quantity transactions.                                    |
14 --|                                                                         |
15 --| HISTORY                                                                 |
16 --|     01-OCT-1998  M.Godfrey       Created                                |
17 --|     25-FEB-1999  M.Godfrey       Upgrade to R11                         |
18 --|     28-OCT-2002  J.DiIorio       Bug#2643440 11.5.1J - added nocopy     |
19 --+=========================================================================+
20 -- API Name  : GMI_QUANTITY_PUB
21 -- Type      : Public
22 -- Function  : This package contains public procedures used to create
23 --             inventory quantity transactions.
24 -- Pre-reqs  : N/A
25 -- Parameters: Per function
26 --
27 -- Current Vers  : 2.0
28 --
29 -- Previous Vers : 1.0
30 --
31 -- Initial Vers  : 1.0
32 -- Notes
33 --
34 -- API specific parameters to be presented in SQL RECORD format
35 TYPE trans_rec_typ IS RECORD
36 ( trans_type      NUMBER(2)
37 , item_no         ic_item_mst.item_no%TYPE
38 , journal_no      ic_jrnl_mst.journal_no%TYPE
39 , from_whse_code  ic_tran_cmp.whse_code%TYPE
40 , to_whse_code    ic_tran_cmp.whse_code%TYPE  DEFAULT NULL
41 , item_um         ic_item_mst.item_um%TYPE    DEFAULT NULL
42 , item_um2        ic_item_mst.item_um2%TYPE   DEFAULT NULL
43 , lot_no          ic_lots_mst.lot_no%TYPE     DEFAULT NULL
44 , sublot_no       ic_lots_mst.sublot_no%TYPE  DEFAULT NULL
45 , from_location   ic_tran_cmp.location%TYPE   DEFAULT NULL
46 , to_location     ic_tran_cmp.location%TYPE   DEFAULT NULL
47 , trans_qty       ic_tran_cmp.trans_qty%TYPE  DEFAULT 0
48 , trans_qty2      ic_tran_cmp.trans_qty2%TYPE DEFAULT 0
49 , qc_grade        ic_tran_cmp.qc_grade%TYPE   DEFAULT NULL
50 , lot_status      ic_tran_cmp.lot_status%TYPE DEFAULT NULL
51 , co_code         ic_tran_cmp.co_code%TYPE
52 , orgn_code       ic_tran_cmp.orgn_code%TYPE
53 , trans_date      ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
54 , reason_code     ic_tran_cmp.reason_code%TYPE
55 , user_name       fnd_user.user_name%TYPE     DEFAULT 'OPM'
56 );
57 --
58 PROCEDURE Inventory_Posting
59 ( p_api_version        IN NUMBER
60 , p_init_msg_list      IN VARCHAR2        DEFAULT FND_API.G_FALSE
61 , p_commit             IN VARCHAR2        DEFAULT FND_API.G_FALSE
62 , p_validation_level   IN VARCHAR2        DEFAULT FND_API.G_VALID_LEVEL_FULL
63 , p_trans_rec          IN  trans_rec_typ
64 , x_return_status      OUT NOCOPY VARCHAR2
65 , x_msg_count          OUT NOCOPY NUMBER
66 , x_msg_data           OUT NOCOPY VARCHAR2
67 );
68 --
69 
70 END GMI_QUANTITY_PUB;