DBA Data[Home] [Help]

APPS.WMS_RULE_PICK_PKG1 dependencies on WMS_RULE_PVT

Line 6: p_cursor IN OUT NOCOPY WMS_RULE_PVT.Cv_pick_type,

2:
3: ---- For Opening the Pick CURSOR ----
4: ----
5: PROCEDURE EXECUTE_OPEN_RULE(
6: p_cursor IN OUT NOCOPY WMS_RULE_PVT.Cv_pick_type,
7: p_rule_id IN NUMBER,
8: p_organization_id IN NUMBER,
9: p_inventory_item_id IN NUMBER,
10: p_transaction_type_id IN NUMBER,

Line 276: p_cursor IN WMS_RULE_PVT.Cv_pick_type,

272: END IF;
273: END EXECUTE_OPEN_RULE;
274:
275: PROCEDURE EXECUTE_FETCH_RULE (
276: p_cursor IN WMS_RULE_PVT.Cv_pick_type,
277: p_rule_id IN NUMBER,
278: x_revision OUT NOCOPY VARCHAR2,
279: x_lot_number OUT NOCOPY VARCHAR2,
280: x_lot_expiration_date OUT NOCOPY DATE,

Line 499: p_cursor IN WMS_RULE_PVT.Cv_pick_type,

495:
496: END EXECUTE_FETCH_RULE;
497:
498: PROCEDURE EXECUTE_FETCH_AVAILABLE_INV (
499: p_cursor IN WMS_RULE_PVT.Cv_pick_type,
500: p_rule_id IN NUMBER,
501: x_return_status OUT NOCOPY NUMBER) is
502:
503: BEGIN

Line 554: p_cursor IN WMS_RULE_PVT.Cv_pick_type) is

550:
551: END EXECUTE_FETCH_AVAILABLE_INV;
552:
553: PROCEDURE EXECUTE_CLOSE_RULE (p_rule_id IN NUMBER,
554: p_cursor IN WMS_RULE_PVT.Cv_pick_type) is
555: BEGIN
556: IF p_rule_id = 1 THEN
557: WMS_RULE_1.close_curs(p_cursor);
558: ELSIF p_rule_id = 2 THEN