1 PACKAGE WMS_RULE_PICK_PKG1 AS
2
3
4 ---- For Opening the PICK CURSOR ----
5 ----
6 PROCEDURE EXECUTE_OPEN_RULE(
7 p_cursor IN OUT NOCOPY WMS_RULE_PVT.Cv_pick_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_revision IN VARCHAR2,
13 p_lot_number IN VARCHAR2,
14 p_subinventory_code IN VARCHAR2,
15 p_locator_id IN NUMBER,
16 p_cost_group_id IN NUMBER,
17 p_pp_transaction_temp_id IN NUMBER,
18 p_serial_controlled IN NUMBER,
19 p_detail_serial IN NUMBER,
20 p_detail_any_serial IN NUMBER,
21 p_from_serial_number IN VARCHAR2,
22 p_to_serial_number IN VARCHAR2,
23 p_unit_number IN VARCHAR2,
24 p_lpn_id IN NUMBER,
25 p_project_id IN NUMBER,
26 p_task_id IN NUMBER,
27 x_result OUT NOCOPY NUMBER);
28
29 PROCEDURE EXECUTE_FETCH_RULE (
30 p_cursor IN WMS_RULE_PVT.Cv_pick_type,
31 p_rule_id IN NUMBER,
32 x_revision OUT NOCOPY VARCHAR2,
33 x_lot_number OUT NOCOPY VARCHAR2,
34 x_lot_expiration_date OUT NOCOPY DATE,
35 x_subinventory_code OUT NOCOPY VARCHAR2,
36 x_locator_id OUT NOCOPY NUMBER,
37 x_cost_group_id OUT NOCOPY NUMBER,
38 x_uom_code OUT NOCOPY VARCHAR2,
39 x_lpn_id OUT NOCOPY NUMBER,
40 x_serial_number OUT NOCOPY VARCHAR2,
41 x_possible_quantity OUT NOCOPY NUMBER,
42 x_sec_possible_quantity OUT NOCOPY NUMBER,
43 x_grade_code OUT NOCOPY VARCHAR2,
44 x_consist_string OUT NOCOPY VARCHAR2,
45 x_order_by_string OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY NUMBER);
47
48 PROCEDURE EXECUTE_FETCH_AVAILABLE_INV (
49 p_cursor IN WMS_RULE_PVT.Cv_pick_type,
50 p_rule_id IN NUMBER,
51 x_return_status OUT NOCOPY NUMBER
52 );
53
54 PROCEDURE EXECUTE_CLOSE_RULE (p_rule_id IN NUMBER ,
55 p_cursor IN WMS_RULE_PVT.Cv_pick_type) ;
56
57 END WMS_RULE_PICK_PKG1;
58 --COMMIT;
59 --EXIT;
60
61