[Home] [Help]
PACKAGE: APPS.WMS_GET_DEST_LOC_LPN
Source
1 package wms_get_dest_loc_lpn AUTHID CURRENT_USER as
2 /* $Header: WMSDLLWS.pls 115.9 2003/11/03 21:18:00 joabraha noship $ */
3 --
4 --
5 -- ---------------------------------------------------------------------------|
6 -- |-------------------------------< trace >----------------------------------|
7 -- ---------------------------------------------------------------------------|
8 -- {Start Of Comments}
9 --
10 -- Description:
11 -- Wrapper around the tracing utility.
12 --
13 -- Prerequisites:
14 -- None
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_message Yes varchar2 Message to be displayed in the log file.
19 -- p_prompt Yes varchar2 Prompt.
20 -- p_level No number Level.
21 --
22 -- Post Success:
23 -- None.
24 --
25 -- Post Failure:
26 -- None
27 --
28 -- Access Status:
29 -- Internal Development Use Only.
30 --
31 -- {End Of Comments}
32 --
33
34 Procedure trace(
35 p_message in varchar2
36 , p_level in number default 4
37 );
38 --
39 -- ---------------------------------------------------------------------------------
40 -- |-----------------------< wms_dest_loc_w_item >----------------------------------|
41 -- ---------------------------------------------------------------------------------
42 -- {Start Of Comments}
43 --
44 -- Description:
45 -- Returns selected Locator or validates Locator passed in with Item restriction.
46 --
47 -- Prerequisites:
48 --
49 -- In Parameters:
50 -- Name Reqd Type Description
51 -- --------------------- ---- -------- ---------------------------
52 -- p_mode Yes number Mode indicating call is
53 -- 1. Selection 2. Validation
54 -- p_task_id Yes varchar2 MMTT.transaction_temp_id
55 -- p_activity_type_id Yes varchar2 Activity Type :
56 -- 1 Inbound
57 -- 2 Outbound
58 -- p_call_hook_id Yes number Seeded/Custom API call hook
59 -- id in the wms_api_hook_calls
60 -- p_locator_id No number Location ID passed in for
61 -- validation when called with
62 -- p_mode = 2.
63 -- p_item_id Yes number Item ID passed in for
64 -- Restriction purposes..
65 -- Post Success:
66 -- Returns a selected a Locator ID or validates a Locator ID.
67 --
68 -- Post Failure:
69 --
70 --
71 -- Access Status:
72 -- Internal Development Use Only.
73 --
74 -- {End Of Comments}
75 --
76 --
77 Procedure wms_dest_loc_w_item(
78 x_return_status out nocopy varchar2
79 , x_msg_count out nocopy number
80 , x_msg_data out nocopy varchar2
81 , x_locator_id out nocopy number
82 , x_zone_id out nocopy number
83 , x_subinventory_code out nocopy varchar2
84 , x_loc_valid out nocopy varchar2
85 , p_mode in number default 1
86 , p_task_id in number
87 , p_activity_type_id in number default 1
88 , p_locator_id in number default null
89 , p_item_id in number default null
90 , p_api_version in number
91 , p_init_msg_list in varchar2
92 , p_commit in varchar2
93 );
94 --
95 --
96 -- ---------------------------------------------------------------------------------
97 -- |-----------------------< wms_dest_loc_wo_item >---------------------------------|
98 -- ---------------------------------------------------------------------------------
99 -- {Start Of Comments}
100 --
101 -- Description:
102 -- Returns selected Locator or validates Locator passed in without Item restriction.
103 --
104 -- Prerequisites:
105 --
106 -- In Parameters:
107 -- Name Reqd Type Description
108 -- ------------------- ---- -------- ---------------------------
109 -- p_mode Yes number Mode indicating call is
110 -- 1. Selection 2. Validation
111 -- p_task_id Yes varchar2 MMTT.transaction_temp_id
112 -- p_activity_type_id Yes varchar2 Activity Type :
113 -- 1 Inbound
114 -- 2 Outbound
115 -- p_call_hook_id Yes number Seeded/Custom API call hook
116 -- id in the wms_api_hook_calls
117 -- p_locator_id No number Location ID passed in for
118 -- validation when called with
119 -- p_mode = 2.
120 --
121 -- Post Success:
122 -- Returns a selected a Locator ID or validates a Locator ID.
123 --
124 -- Post Failure:
125 --
126 --
127 -- Access Status:
128 -- Internal Development Use Only.
129 --
130 -- {End Of Comments}
131 --
132 --
133 Procedure wms_dest_loc_wo_item(
134 x_return_status out nocopy varchar2
135 , x_msg_count out nocopy number
136 , x_msg_data out nocopy varchar2
137 , x_locator_id out nocopy number
138 , x_zone_id out nocopy number
139 , x_subinventory_code out nocopy varchar2
140 , x_loc_valid out nocopy varchar2
141 , p_mode in number default 1
142 , p_task_id in number
143 , p_activity_type_id in number default 1
144 , p_locator_id in number default null
145 , p_item_id in number default null
146 , p_api_version in number
147 , p_init_msg_list in varchar2
148 , p_commit in varchar2
149 );
150
151 --
152 --
153 -- ---------------------------------------------------------------------------------
154 -- |-----------------------< wms_dest_lpn_w_item >----------------------------------|
155 -- ---------------------------------------------------------------------------------
156 -- {Start Of Comments}
157 --
158 -- Description:
159 -- Returns selected LPN or validates LPN passed in, with Item restriction.
160 --
161 -- Prerequisites:
162 --
163 -- In Parameters:
164 -- Name Reqd Type Description
165 -- ------------------- ---- -------- ---------------------------
166 -- p_mode Yes number Mode indicating call is
167 -- 1. Selection 2. Validation
168 -- p_task_id Yes varchar2 MMTT.transaction_temp_id
169 -- p_activity_type_id Yes varchar2 Activity Type :
170 -- 1 Inbound
171 -- 2 Outbound
172 -- p_call_hook_id Yes number Seeded/Custom API call hook
173 -- id in the wms_api_hook_calls
174 -- p_lpn_id No number LPN ID passed in for
175 -- validation when called with
176 -- p_mode = 2.
177 -- p_item_id Yes number Item ID passed in for
178 -- Restriction purposes..
179 --
180 --
181 -- Post Success:
182 -- Returns a selected a Locator ID or validates a Locator ID.
183 --
184 -- Post Failure:
185 --
186 --
187 -- Access Status:
188 -- Internal Development Use Only.
189 --
190 -- {End Of Comments}
191 --
192 --
193 Procedure wms_dest_lpn_w_item(
194 x_return_status out nocopy varchar2
195 , x_msg_count out nocopy number
196 , x_msg_data out nocopy varchar2
197 , x_lpn_id out nocopy number
198 , x_lpn_valid out nocopy varchar2
199 , p_mode in number default 1
200 , p_task_id in number
201 , p_activity_type_id in number default 1
202 , p_lpn_id in number default null
203 , p_item_id in number default null
204 , p_subinventory_code in varchar2
205 , p_locator_id in number
206 , p_api_version in number
207 , p_init_msg_list in varchar2
208 , p_commit in varchar2
209 );
210 --
211 --
212 -- ---------------------------------------------------------------------------------
213 -- |-----------------------< wms_dest_lpn_wo_item >---------------------------------|
214 -- ---------------------------------------------------------------------------------
215 -- {Start Of Comments}
216 --
217 -- Description:
218 -- Returns selected LPN or validates LPN passed in, with Item restriction.
219 --
220 -- Prerequisites:
221 --
222 -- In Parameters:
223 -- Name Reqd Type Description
224 -- ------------------- ---- -------- ---------------------------
225 -- p_mode Yes number Mode indicating call is
226 -- 1. Selection 2. Validation
227 -- p_task_id Yes varchar2 MMTT.transaction_temp_id
228 -- p_activity_type_id Yes varchar2 Activity Type :
229 -- 1 Inbound
230 -- 2 Outbound
231 -- p_call_hook_id Yes number Seeded/Custom API call hook
232 -- id in the wms_api_hook_calls
233 -- p_lpn_id No number LPN ID passed in for
234 -- validation when called with
235 -- p_mode = 2.
236 -- Post Success:
237 -- Returns a selected a Locator IDor validates a Locator ID.
238 --
239 -- Post Failure:
240 --
241 --
242 -- Access Status:
243 -- Internal Development Use Only.
244 --
245 -- {End Of Comments}
246 --
247 --
248 Procedure wms_dest_lpn_wo_item(
249 x_return_status out nocopy varchar2
250 , x_msg_count out nocopy number
251 , x_msg_data out nocopy varchar2
252 , x_lpn_id out nocopy number
253 , x_lpn_valid out nocopy varchar2
254 , p_mode in number default 1
255 , p_task_id in number
256 , p_activity_type_id in number default 1
257 , p_lpn_id in number default null
258 , p_item_id in number default null
259 , p_subinventory_code in varchar2
260 , p_locator_id in number
261 , p_api_version in number
262 , p_init_msg_list in varchar2
263 , p_commit in varchar2
264 );
265 --
266 --
267 end wms_get_dest_loc_lpn;