1 PACKAGE WMS_RULE_18 AS
2 procedure open_curs (
3 p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,
4 p_organization_id IN NUMBER,
5 p_inventory_item_id IN NUMBER,
6 p_transaction_type_id IN NUMBER,
7 p_revision IN VARCHAR2,
8 p_lot_number IN VARCHAR2,
9 p_subinventory_code IN VARCHAR2,
10 p_locator_id IN NUMBER,
11 p_cost_group_id IN NUMBER,
12 p_pp_transaction_temp_id IN NUMBER,
13 p_serial_controlled IN NUMBER,
14 p_detail_serial IN NUMBER,
15 p_detail_any_serial IN NUMBER,
16 p_from_serial_number IN VARCHAR2,
17 p_to_serial_number IN VARCHAR2,
18 p_unit_number IN VARCHAR2,
19 p_lpn_id IN NUMBER,
20 p_project_id IN NUMBER,
21 p_task_id IN NUMBER,
22 x_result OUT NOCOPY NUMBER);
23
24 PROCEDURE fetch_one_row (
25 p_cursor IN WMS_RULE_PVT.cv_pick_type,
26 x_revision OUT NOCOPY VARCHAR2,
27 x_lot_number OUT NOCOPY VARCHAR2,
28 x_lot_expiration_date OUT NOCOPY DATE,
29 x_subinventory_code OUT NOCOPY VARCHAR2,
30 x_locator_id OUT NOCOPY NUMBER,
31 x_cost_group_id OUT NOCOPY NUMBER,
32 x_uom_code OUT NOCOPY VARCHAR2,
33 x_lpn_id OUT NOCOPY NUMBER,
34 x_serial_number OUT NOCOPY VARCHAR2,
35 x_possible_quantity OUT NOCOPY NUMBER,
36 x_sec_possible_quantity OUT NOCOPY NUMBER,
37 x_grade_code OUT NOCOPY VARCHAR2,
38 x_consist_string OUT NOCOPY VARCHAR2,
39 x_order_by_string OUT NOCOPY VARCHAR2,
40 x_return_status OUT NOCOPY NUMBER);
41
42 PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type);
43
44 PROCEDURE fetch_available_rows (
45 p_cursor IN WMS_RULE_PVT.cv_pick_type,
46 x_return_status OUT NOCOPY NUMBER);
47
48
49
50 end WMS_RULE_18;