1 PACKAGE inv_rcv_cache AUTHID CURRENT_USER AS
2 /* $Header: INVRCSHS.pls 120.1.12010000.2 2010/05/20 09:38:24 skommine ship $*/
3
4 TYPE to_uom_code_tb IS TABLE OF NUMBER INDEX BY VARCHAR2(3);
5 TYPE from_uom_code_tb IS TABLE OF to_uom_code_tb INDEX BY VARCHAR2(3);
6 TYPE item_uom_conversion_tb IS TABLE OF from_uom_code_tb INDEX BY BINARY_INTEGER;
7
8 TYPE item_attributes IS RECORD
9 ( primary_uom_code VARCHAR2(3)
10 ,secondary_uom_code VARCHAR2(3)
11 ,lot_control_code NUMBER
12 ,serial_number_control_code NUMBER);
13
14 TYPE item_attrib_tb IS TABLE OF item_attributes INDEX BY BINARY_INTEGER;
15 TYPE org_item_attrib_tb IS TABLE OF item_attrib_tb INDEX BY BINARY_INTEGER;
16
17 g_org_item_attrib_tb org_item_attrib_tb;
18 g_item_uom_conversion_tb item_uom_conversion_tb;
19 g_conversion_precision CONSTANT NUMBER := 5;
20
21 FUNCTION convert_qty
22 (p_inventory_item_id IN NUMBER
23 ,p_from_qty IN NUMBER
24 ,p_from_uom_code IN VARCHAR2
25 ,p_to_uom_code IN VARCHAR2
26 ,p_precision IN NUMBER DEFAULT NULL
27 , p_organization_id IN NUMBER DEFAULT NULL --Bug#9570776
28 , p_lot_number IN VARCHAR2 DEFAULT NULL --Bug#9570776
29 )
30 RETURN NUMBER;
31
32 FUNCTION get_primary_uom_code
33 (p_organization_id IN NUMBER
34 ,p_inventory_item_id IN NUMBER
35 )
36 RETURN VARCHAR2;
37
38 FUNCTION get_secondary_uom_code
39 (p_organization_id IN NUMBER
40 ,p_inventory_item_id IN NUMBER
41 )
42 RETURN VARCHAR2;
43
44 FUNCTION get_sn_ctrl_code
45 (p_organization_id IN NUMBER
46 ,p_inventory_item_id IN NUMBER
47 )
48 RETURN NUMBER;
49
50 FUNCTION get_lot_control_code
51 (p_organization_id IN NUMBER
52 ,p_inventory_item_id IN NUMBER
53 )
54 RETURN NUMBER;
55
56 FUNCTION get_conversion_rate
57 (p_inventory_item_id IN NUMBER
58 ,p_from_uom_code IN VARCHAR2
59 ,p_to_uom_code IN VARCHAR2
60 )
61 RETURN NUMBER;
62
63 END inv_rcv_cache;