1 PACKAGE WMS_EXPRESS_PICK_TASK AUTHID CURRENT_USER AS
2 /* $Header: WMSEXPTS.pls 115.6 2002/12/01 03:56:45 rbande ship $ */
3
4 PRAGMA RESTRICT_REFERENCES(WMS_EXPRESS_PICK_TASK,WNDS,WNPS);
5
6 PROCEDURE LOAD_AND_DROP(
7 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8 X_MSG_COUNT OUT NOCOPY NUMBER,
9 X_MSG_DATA OUT NOCOPY VARCHAR2,
10 P_ORG_ID IN NUMBER,
11 P_TEMP_ID IN NUMBER,
12 P_TO_LPN IN VARCHAR2,
13 P_TO_SUB IN VARCHAR2,
14 P_TO_LOC IN NUMBER,
15 P_ACTION IN VARCHAR2,
16 P_USER_ID IN NUMBER,
17 P_TASK_TYPE IN NUMBER
18 );
19
20 PROCEDURE LOAD_TASK(
21 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22 X_MSG_COUNT OUT NOCOPY NUMBER,
23 X_MSG_DATA OUT NOCOPY VARCHAR2,
24 P_TEMP_ID IN NUMBER,
25 P_LPN_ID IN NUMBER,
26 P_USER_ID IN NUMBER
27 );
28
29 PROCEDURE DROP_TASK(
30 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31 X_MSG_COUNT OUT NOCOPY NUMBER,
32 X_MSG_DATA OUT NOCOPY VARCHAR2,
33 P_ORG_ID IN NUMBER,
34 P_TEMP_ID IN NUMBER,
35 P_LPN_ID IN NUMBER,
36 P_TO_SUB IN VARCHAR2,
37 P_TO_LOC IN NUMBER,
38 P_USER_ID IN NUMBER,
39 P_TASK_TYPE IN NUMBER
40 );
41
42 PROCEDURE HAS_EXPRESS_PICK_TASKS(
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_COUNT OUT NOCOPY NUMBER,
45 X_MSG_DATA OUT NOCOPY VARCHAR2,
46 P_USER_ID IN NUMBER,
47 P_ORG_ID IN NUMBER
48 );
49
50 FUNCTION IS_EXPRESS_PICK_TASK( P_TASK_ID IN NUMBER ) RETURN VARCHAR2;
51 FUNCTION IS_EXPRESS_PICK_TASK_ELIGIBLE( P_TRANSACTION_TEMP_ID IN NUMBER) RETURN VARCHAR2;
52
53 END WMS_EXPRESS_PICK_TASK;