PACKAGE: APPS.INV_RCV_CACHE

Source

1 PACKAGE inv_rcv_cache AS
2 /* $Header: INVRCSHS.pls 120.1 2006/02/07 13:30:51 gayu noship $*/
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    )
28   RETURN NUMBER;
29 
30 FUNCTION get_primary_uom_code
31   (p_organization_id     IN NUMBER
32    ,p_inventory_item_id  IN NUMBER
33    )
34   RETURN VARCHAR2;
35 
36 FUNCTION get_secondary_uom_code
37   (p_organization_id     IN NUMBER
38    ,p_inventory_item_id  IN NUMBER
39    )
40   RETURN VARCHAR2;
41 
42 FUNCTION get_sn_ctrl_code
43   (p_organization_id     IN NUMBER
44    ,p_inventory_item_id  IN NUMBER
45    )
46   RETURN NUMBER;
47 
48 FUNCTION get_lot_control_code
49   (p_organization_id     IN NUMBER
50    ,p_inventory_item_id  IN NUMBER
51    )
52   RETURN NUMBER;
53 
54 FUNCTION get_conversion_rate
55   (p_inventory_item_id   IN NUMBER
56    ,p_from_uom_code      IN VARCHAR2
57    ,p_to_uom_code        IN VARCHAR2
58    )
59   RETURN NUMBER;
60 
61 END inv_rcv_cache;