223: BEGIN
224:
225: SELECT meaning
226: INTO l_released_status_name
227: FROM wsh_lookups
228: WHERE lookup_type = 'PICK_STATUS'
229: AND lookup_code = 'I';
230:
231: EXCEPTION
237: -- bug 4267981
238: IF p_released_status = 'S' AND p_move_order_line_id is null THEN
239: SELECT meaning
240: INTO l_released_status_name
241: FROM wsh_lookups
242: WHERE lookup_type = 'PICK_STATUS'
243: AND lookup_code = 'K';
244: ELSE
245: SELECT meaning
243: AND lookup_code = 'K';
244: ELSE
245: SELECT meaning
246: INTO l_released_status_name
247: FROM wsh_lookups
248: WHERE lookup_type = 'PICK_STATUS'
249: AND lookup_code = p_released_status;
250: END IF;
251: EXCEPTION