1 PACKAGE WMS_OP_DEST_SYS_APIS AUTHID CURRENT_USER AS
2 /* $Header: WMSOPDSS.pls 120.3.12020000.2 2013/03/10 13:26:01 srsomasu ship $*/
3
4
5 --
6 -- File : WMSOPDSS.pls
7 -- Content : WMS_OP_DEST_SYS_APIS package specification
8 -- Description : System seeded operation plan destination selection APIs.
9 -- Notes :
10 -- Modified : 10/01/2002 lezhang created
11
12
13
14 -- API name : Get_Loc_For_Delivery
15 -- Type : Public
16 -- Function :
17 -- Pre-reqs :
18 --
19 --
20 -- Parameters :
21 -- Output:
22 --
23 -- X_Return_status : API exeution status, differen meaning in different
24 -- call mode
25 -- For locator selection:
26 -- 'S' : Locator successfully returned.
27 -- 'E' : Locator is not returned because of application
28 -- error.
29 -- 'U' : Locator is not returned because of unexpected
30 -- error.
31 --
32 -- For locator validation:
33 -- 'S' : Locator is valid according to API logic.
34 -- 'W' : Locator is not valid, and user will be prompt for a warning
35 -- 'E' : Locator is not valid, and user should not be allowed to continue.
36 -- 'U' : API execution encountered unexpected error.
37 --
38 --
39 -- X_Message : Message corresponding to different statuses
40 -- and different call mode
41 -- For locator selection:
42 -- 'S' : Message that needs to displayed before
43 -- displaying the suggested locator.
44 -- 'E' : Reason why locator is not returned.
45 -- 'U' : Message for the unexpected error.
46 --
47 -- For locator validation:
48 -- 'S' : No message.
49 -- 'W' : Reason why locator is invalid.
50 -- 'E' : Reason why locator is invalid.
51 -- 'U' : Message for the unexpected error.
52 --
53 --
54 -- X_locator_ID : Locator returned according to API loc,
55 -- only apply to P_Call_Mode of locator selection.
56 --
57 -- X_Zone_ID : Zone returned according to API loc,
58 -- only apply to P_Call_Mode of locator selection.
59 --
60 -- X_Subinventory_Code : Subinventory code returned according to API loc
61 -- only apply to P_Call_Mode of locator selection.
62 --
63 --
64 -- Input:
65 --
66 -- P_Call_Mode : 1. Locator selection 2. Locator validation
67 --
68 -- P_Task_Type : Refer to lookup type WMS_TASK_TYPES
69 --
70 -- P_Task_ID : Primary key for the corresponding task type.
71 -- e.g. transaction_temp_id in MMTT for picking task type.
72 --
73 -- P_Locator_Id : The locator needs to be validated according to API logic,
74 -- only apply to P_Call_Mode of locator validation,
75 --
76 --
77 -- Version
78 -- Currently version is 1.0
79 --
80
81 PROCEDURE Get_CONS_Loc_For_Delivery
82 (
83 X_Return_status OUT nocopy VARCHAR2,
84 X_Message OUT nocopy VARCHAR2,
85 X_locator_ID OUT nocopy NUMBER,
86 X_Zone_ID OUT nocopy NUMBER,
87 X_Subinventory_Code OUT nocopy VARCHAR2,
88 P_Call_Mode IN NUMBER DEFAULT NULL,
89 P_Task_Type IN NUMBER DEFAULT NULL,
90 P_Task_ID IN NUMBER DEFAULT NULL,
91 P_Locator_Id IN NUMBER DEFAULT NULL
92 );
93
94 PROCEDURE Get_Staging_Loc_For_Delivery
95 (
96 X_Return_status OUT nocopy VARCHAR2,
97 X_Message OUT nocopy VARCHAR2,
98 X_locator_ID OUT nocopy NUMBER,
99 X_Zone_ID OUT nocopy NUMBER,
100 X_Subinventory_Code OUT nocopy VARCHAR2,
101 P_Call_Mode IN NUMBER DEFAULT NULL,
102 P_Task_Type IN NUMBER DEFAULT NULL,
103 P_Task_ID IN NUMBER DEFAULT NULL,
104 P_Locator_Id IN NUMBER DEFAULT NULL,
105 p_mol_id IN NUMBER DEFAULT NULL
106 );
107
108 /***************************************************************
109 This procedure returns a PJM logical locator for a physical locator
110 1. If this locator is the logical locator, do nothing.
111 2. If there is a logical locator for the given project/task, return that.
112 3. Otherwise, create/return a logical locator.
113 ***********************************************/
114
115 PROCEDURE create_pjm_locator(x_locator_id IN OUT nocopy NUMBER,
116 p_project_id IN NUMBER,
117 p_task_id IN NUMBER);
118
119
120 PROCEDURE Get_LPN_For_Delivery
121 (
122 X_Return_status OUT nocopy VARCHAR2,
123 X_Message OUT nocopy VARCHAR2,
124 X_LPN_ID OUT nocopy NUMBER,
125 P_Task_Type IN NUMBER DEFAULT NULL,
126 P_Task_ID IN NUMBER DEFAULT NULL,
127 p_sug_sub IN VARCHAR2 DEFAULT NULL,
128 p_sug_loc IN NUMBER DEFAULT NULL
129 );
130
131 -- Start of changes done for Bug 16371756 FP of Bug 16344535
132 TYPE SugDestSubLocRec IS RECORD (
133 grouping_id NUMBER,
134 subinventory_code wsh_delivery_details.subinventory%TYPE,
135 locator_id wsh_delivery_details.locator_id%TYPE);
136
137 TYPE SugDestSubLocTable IS TABLE OF SugDestSubLocRec INDEX BY LONG;
138 g_sug_dest_sub_loc_table SugDestSubLocTable;
139 -- End of changes done for Bug 16371756 FP of Bug 16344535
140
141 END wms_op_dest_sys_apis;
142