DBA Data[Home] [Help]

APPS.WMS_RULE_2 dependencies on WMS_RULE_PVT

Line 3: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE WMS_RULE_2 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,

Line 25: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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,

Line 42: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type);

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);

Line 45: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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: