1 PACKAGE rcv_availability AS
2 /* $Header: RCVAVALS.pls 120.0 2005/06/02 01:06:52 appldev 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 PROCEDURE validate_supply_demand(
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 x_valid_status OUT NOCOPY VARCHAR2,
33 p_organization_id IN NUMBER,
34 p_item_id IN NUMBER,
35 p_supply_demand_code IN NUMBER,
36 p_supply_demand_type_id IN NUMBER,
37 p_supply_demand_header_id IN NUMBER,
38 p_supply_demand_line_id IN NUMBER,
39 p_supply_demand_line_detail IN NUMBER DEFAULT fnd_api.g_miss_num,
40 p_demand_ship_date IN DATE,
41 p_expected_receipt_date IN DATE,
42 p_api_version_number IN NUMBER DEFAULT 1.0,
43 p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
44 );
45 END rcv_availability;