1 PACKAGE WMS_RULE_8 AS
2 procedure open_curs (
3 p_cursor IN OUT NOCOPY WMS_RULE_PVT.CV_PUT_TYPE,
4 p_organization_id IN NUMBER,
5 p_inventory_item_id IN NUMBER,
6 p_transaction_type_id IN NUMBER,
7 p_subinventory_code IN VARCHAR2,
8 p_locator_id IN NUMBER,
9 p_pp_transaction_temp_id IN NUMBER,
10 p_restrict_subs_code IN NUMBER,
11 p_restrict_locs_code IN NUMBER,
12 p_project_id IN NUMBER,
13 p_task_id IN NUMBER,
14 x_result OUT NOCOPY NUMBER);
15
16 PROCEDURE fetch_one_row (
17 p_cursor IN WMS_RULE_PVT.CV_PUT_TYPE,
18 x_subinventory_code OUT NOCOPY VARCHAR2,
19 x_locator_id OUT NOCOPY NUMBER,
20 x_project_id OUT NOCOPY NUMBER,
21 x_task_id OUT NOCOPY NUMBER,
22 x_return_status OUT NOCOPY NUMBER);
23
24 PROCEDURE close_curs(p_cursor IN WMS_RULE_PVT.CV_PUT_TYPE );
25
26 end WMS_RULE_8;