1 PACKAGE EAM_MATERIAL_ALLOCQTY_PKG as
2 /* $Header: EAMMRALS.pls 120.1 2007/11/29 03:23:28 mashah ship $ */
3
4
5 --This function returns allocated quantity by querying from inv. tables
6 FUNCTION allocated_quantity(p_wip_entity_id IN NUMBER,
7 p_operation_seq_num IN NUMBER,
8 p_organization_id IN NUMBER,
9 p_inventory_item_id IN NUMBER)
10 return NUMBER;
11
12 --This function returns open quantity.If open qty is less than 0,it returns 0
13 FUNCTION open_quantity(p_wip_entity_id IN NUMBER,
14 p_operation_seq_num IN NUMBER,
15 p_organization_id IN NUMBER,
16 p_inventory_item_id IN NUMBER,
17 p_required_quantity IN NUMBER,
18 p_quantity_issued IN NUMBER)
19 return NUMBER;
20
21 --This will call the function allocated_quantity to find the quantity allocated
22 PROCEDURE quantity_allocated(p_wip_entity_id IN NUMBER,
23 p_operation_seq_num IN NUMBER,
24 p_organization_id IN NUMBER,
25 p_inventory_item_id IN NUMBER,
26 x_quantity_allocated OUT NOCOPY NUMBER);
27
28 --This will call Eam_Common_Utilties_Pvt.Get_OnHand_Quant to find the on_hand_qty and available quantity
29 --for an inventory item
30 PROCEDURE get_onhand_avail_quant(p_organization_id IN NUMBER,
31 p_inventory_item_id IN NUMBER,
32 p_subinventory_code IN VARCHAR2 DEFAULT NULL, --12.1 source sub project
33 x_onhand_quant OUT NOCOPY NUMBER,
34 x_avail_quant OUT NOCOPY NUMBER);
35
36
37 END EAM_MATERIAL_ALLOCQTY_PKG;