[Home] [Help]
PACKAGE: APPS.GMI_ITEM_LOT_CONV_PUB
Source
1 PACKAGE GMI_ITEM_LOT_CONV_PUB AUTHID CURRENT_USER AS
2 -- $Header: GMIPILCS.pls 115.3 2002/10/25 18:33:39 jdiiorio gmigapib.pls $
3 --+=========================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| TVP, Reading, England |
6 --| All rights reserved |
7 --+=========================================================================+
8 --| FILENAME |
9 --| GMIPILCS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains public procedures relating to Item / Lot |
13 --| unit of measure conversion. |
14 --| |
15 --| HISTORY |
16 --| 01-OCT-1998 M.Godfrey Created |
17 --| 25-FEB-1999 M.Godfrey Upgrade to R11 |
18 --| 25-OCT-2002 J. DiIorio Bug#2643440 - added nocopy. |
19 --+=========================================================================+
20 -- API Name : GMI_ITEM_LOT_CONV_PUB
21 -- Type : Public
22 -- Function : This package contains public procedures used to create an
23 -- item / lot unit of measure conversion.
24 -- Pre-reqs : N/A
25 -- Parameters: Per function
26 --
27 -- Current Vers : 2.0
28 --
29 -- Previous Vers : 2.0
30 --
31 -- Initial Vers : 1.0
32 -- Notes
33 --
34
35 -- API specific parameters to be presented in PL/SQL RECORD format
36 TYPE item_cnv_rec_typ IS RECORD
37 ( item_no IC_ITEM_MST.item_no%TYPE
38 , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL
39 , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL
40 , from_uom SY_UOMS_MST.um_code%TYPE
41 , to_uom SY_UOMS_MST.um_code%TYPE
42 , type_factor IC_ITEM_CNV.type_factor%TYPE
43 , user_name FND_USER.user_name%TYPE DEFAULT 'OPM'
44 );
45 --
46 PROCEDURE Create_Item_Lot_UOM_Conv
47 ( p_api_version IN NUMBER
48 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
49 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
51 , p_item_cnv_rec IN item_cnv_rec_typ
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_count OUT NOCOPY NUMBER
54 , x_msg_data OUT NOCOPY VARCHAR2
55 );
56 --
57
58 END GMI_ITEM_LOT_CONV_PUB;