1 PACKAGE inv_rcv_availability AS
2 /* $Header: INVRCVAS.pls 120.0 2005/06/15 09:10:15 gayu noship $*/
3 PROCEDURE get_available_supply_demand(
4 x_return_status OUT NOCOPY VARCHAR2,
5 x_msg_count OUT NOCOPY NUMBER,
6 x_msg_data OUT NOCOPY VARCHAR2,
7 x_available_quantity OUT NOCOPY NUMBER,
8 x_source_uom_code OUT NOCOPY VARCHAR2,
9 x_source_primary_uom_code OUT NOCOPY VARCHAR2,
10 p_supply_demand_code IN NUMBER,
11 p_organization_id IN NUMBER DEFAULT NULL,
12 p_item_id IN NUMBER DEFAULT NULL,
13 p_revision IN VARCHAR2 DEFAULT NULL,
14 p_lot_number IN VARCHAR2 DEFAULT NULL,
15 p_subinventory_code IN VARCHAR2 DEFAULT NULL,
16 p_locator_id IN NUMBER DEFAULT NULL,
17 p_supply_demand_type_id IN NUMBER,
18 p_supply_demand_header_id IN NUMBER,
19 p_supply_demand_line_id IN NUMBER,
20 p_supply_demand_line_detail IN NUMBER DEFAULT fnd_api.g_miss_num,
21 p_lpn_id IN NUMBER DEFAULT fnd_api.g_miss_num,
22 p_project_id IN NUMBER DEFAULT NULL,
23 p_task_id IN NUMBER DEFAULT NULL,
24 p_api_version_number IN NUMBER DEFAULT 1.0,
25 p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
26 );
27
28 END inv_rcv_availability;
[Home] [Help]