1 PACKAGE WMS_RULE_PUT_PKG3 AS
2
3
4 ---- For Opening the Putaway CURSOR ----
5 ----
6 PROCEDURE EXECUTE_OPEN_RULE(
7 p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,
8 p_rule_id IN NUMBER,
9 p_organization_id IN NUMBER,
10 p_inventory_item_id IN NUMBER,
11 p_transaction_type_id IN NUMBER,
12 p_subinventory_code IN VARCHAR2,
13 p_locator_id IN NUMBER,
14 p_pp_transaction_temp_id IN NUMBER,
15 p_restrict_subs_code IN NUMBER,
16 p_restrict_locs_code IN NUMBER,
17 p_project_id IN NUMBER,
18 p_task_id IN NUMBER,
19 x_result OUT NOCOPY NUMBER);
20
21 PROCEDURE EXECUTE_FETCH_RULE (
22 p_cursor IN WMS_RULE_PVT.cv_put_type,
23 p_rule_id IN NUMBER,
24 x_subinventory_code OUT NOCOPY VARCHAR2,
25 x_locator_id OUT NOCOPY NUMBER,
26 x_project_id OUT NOCOPY NUMBER,
27 x_task_id OUT NOCOPY NUMBER,
28 x_return_status OUT NOCOPY NUMBER);
29
30 PROCEDURE EXECUTE_CLOSE_RULE (p_rule_id IN NUMBER,
31 p_cursor IN WMS_RULE_PVT.cv_put_type) ;
32
33 END WMS_RULE_PUT_PKG3;
34 --COMMIT;
35 --EXIT;
36
37