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;