453: ELSIF (p_batch_id IS NOT NULL) THEN
454: -- Query and cache the value based on p_batch_id
455: SELECT *
456: INTO wpb_rec
457: FROM wsh_picking_batches
458: WHERE batch_id = p_batch_id;
459: RETURN TRUE;
460: ELSIF (p_request_number IS NOT NULL) THEN
461: -- Query and cache the value based on p_request_number
460: ELSIF (p_request_number IS NOT NULL) THEN
461: -- Query and cache the value based on p_request_number
462: SELECT *
463: INTO wpb_rec
464: FROM wsh_picking_batches
465: WHERE name = p_request_number;
466: RETURN TRUE;
467: ELSE
468: -- Should not reach this condition