1 package WSM_RESERVATIONS_GRP as
2 /* $Header: WSMGRSVS.pls 120.0 2005/06/27 08:30:41 mprathap noship $ */
3
4 PROCEDURE get_available_supply_demand (
5 x_return_status OUT NOCOPY VARCHAR2
6 , x_msg_count OUT NOCOPY NUMBER
7 , x_msg_data OUT NOCOPY VARCHAR2
8 , x_available_quantity OUT NOCOPY NUMBER
9 , x_source_uom_code OUT NOCOPY VARCHAR2
10 , x_source_primary_uom_code OUT NOCOPY VARCHAR2
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_code IN NUMBER
18 , p_supply_demand_type_id IN NUMBER
19 , p_supply_demand_header_id IN NUMBER
20 , p_supply_demand_line_id IN NUMBER
21 , p_supply_demand_line_detail IN NUMBER
22 , p_lpn_id IN NUMBER
23 , p_project_id IN NUMBER default null
24 , p_task_id IN NUMBER default null
25 , p_api_version_number IN NUMBER default 1.0
26 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
27 );
28
29 PROCEDURE validate_supply_demand (
30 x_return_status OUT NOCOPY VARCHAR2
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , x_valid_status OUT NOCOPY VARCHAR2
34 , p_organization_id IN NUMBER
35 , p_item_id IN NUMBER
36 , p_supply_demand_code IN NUMBER
37 , p_supply_demand_type_id IN NUMBER
38 , p_supply_demand_header_id IN NUMBER
39 , p_supply_demand_line_id IN NUMBER
40 , p_supply_demand_line_detail IN NUMBER
41 , p_demand_ship_date IN DATE
42 , p_expected_receipt_date IN DATE
43 , p_api_version_number IN NUMBER default 1.0
44 , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
45 );
46 end WSM_RESERVATIONS_GRP;
[Home] [Help]