DBA Data[Home] [Help]

PACKAGE: APPS.OE_ORDER_MISC_UTIL

Source


1 PACKAGE OE_Order_Misc_Util AS
2 /* $Header: OEXMISCS.pls 120.1 2006/05/25 08:00:28 pkannan noship $ */
3 
4 -- Bug 5244726
5 PROCEDURE GET_ITEM_INFO
6 (   x_return_status         OUT NOCOPY VARCHAR2
7 ,   x_msg_count             OUT NOCOPY NUMBER
8 ,   x_msg_data              OUT NOCOPY VARCHAR2
9 ,   p_item_identifier_type          IN VARCHAR2
10 ,   p_inventory_item_id             IN Number
11 ,   p_ordered_item_id               IN Number
12 ,   p_sold_to_org_id                IN Number
13 ,   p_ordered_item                  IN VARCHAR2
14 ,   x_ordered_item          OUT NOCOPY VARCHAR2
15 ,   x_ordered_item_desc     OUT NOCOPY VARCHAR2
16 ,   x_inventory_item        OUT NOCOPY VARCHAR2
17 ,   p_org_id                        IN Number DEFAULT NULL
18 );
19 
20 
21 Function convert_uom
22 (
23   p_item_id   	in  number,
24   p_from_uom_code in  varchar2,
25   p_to_uom_code   in  varchar2,
26   p_from_qty  	in  number
27 ) return number;
28 
29 end OE_Order_Misc_Util;