PACKAGE: APPS.INV_3PL_SEEDED_SOURCES

Source

1 PACKAGE inv_3pl_seeded_sources AUTHID CURRENT_USER AS
2 /* $Header: INVSSRCS.pls 120.1 2010/05/25 11:06:33 damahaja noship $ */
3 
4 PROCEDURE number_receive_transactions
5     (      x_counter_value             OUT NOCOPY NUMBER,
6       x_return_status             OUT NOCOPY VARCHAR2
7     );
8 
9 PROCEDURE number_shipment_lines
10     (      x_counter_value             OUT NOCOPY NUMBER,
11       x_return_status             OUT NOCOPY VARCHAR2
12     );
13 
14 PROCEDURE number_picking_transactions
15     (      x_counter_value             OUT NOCOPY NUMBER,
16       x_return_status             OUT NOCOPY VARCHAR2
17     );
18 
19 PROCEDURE qty_receiving_transactions
20     (      x_counter_value             OUT NOCOPY NUMBER,
21       x_return_status             OUT NOCOPY VARCHAR2
22     );
23 
24 PROCEDURE number_putaway_transactions
25     (      x_counter_value             OUT NOCOPY NUMBER,
26       x_return_status             OUT NOCOPY VARCHAR2
27     );
28 
29 PROCEDURE capacity_number_of_days
30     (      x_counter_value             OUT NOCOPY NUMBER,
31       x_return_status             OUT NOCOPY VARCHAR2
32     );
33 
34 PROCEDURE volume_utilized
35     (      x_counter_value             OUT NOCOPY NUMBER,
36       x_return_status             OUT NOCOPY VARCHAR2
37     );
38 
39 PROCEDURE area_utilized
40     (      x_counter_value             OUT NOCOPY NUMBER,
41       x_return_status             OUT NOCOPY VARCHAR2
42     );
43 
44 FUNCTION get_item_uom_code (p_uom_name   VARCHAR2) RETURN VARCHAR2;
45 
46 FUNCTION get_area_for_locator(p_inventory_location_id  NUMBER , p_organization_id NUMBER)
47 RETURN NUMBER;
48 
49 FUNCTION get_volume_for_locator(p_inventory_location_id  NUMBER , p_organization_id NUMBER , p_billing_uom VARCHAR2)
50 RETURN NUMBER;
51 
52 END INV_3PL_SEEDED_SOURCES;