342: IF p_LPN_ID IS NOT NULL THEN
343: BEGIN
344: SELECT LICENSE_PLATE_NUMBER
345: INTO x_LPN
346: FROM WMS_LICENSE_PLATE_NUMBERS
347: WHERE LPN_ID = p_LPN_ID ;
348: EXCEPTION
349: WHEN OTHERS THEN
350: NULL;
354: IF p_TRANSFER_LPN_ID IS NOT NULL THEN
355: BEGIN
356: SELECT LICENSE_PLATE_NUMBER
357: INTO x_TRANSFER_LPN
358: FROM WMS_LICENSE_PLATE_NUMBERS
359: WHERE LPN_ID = p_TRANSFER_LPN_ID ;
360: EXCEPTION
361: WHEN OTHERS THEN
362: NULL;
365: IF p_CONTENT_LPN_ID IS NOT NULL THEN
366: BEGIN
367: SELECT LICENSE_PLATE_NUMBER
368: INTO x_CONTENT_LPN
369: FROM WMS_LICENSE_PLATE_NUMBERS
370: WHERE LPN_ID = p_CONTENT_LPN_ID ;
371: EXCEPTION
372: WHEN OTHERS THEN
373: NULL;