224: SELECT
225: LICENSE_PLATE_NUMBER
226: INTO M_OUTERMOST_LPN
227: FROM
228: WMS_LICENSE_PLATE_NUMBERS
229: WHERE LPN_ID = P_OUTERMOST_LPN_ID;
230: -- For bug 14037978 commented and added Exception block code
231: /* IF SQL%NOTFOUND THEN
232: M_OUTERMOST_LPN := 'ERROR';
252: SELECT
253: LICENSE_PLATE_NUMBER
254: INTO M_PARENT_LPN
255: FROM
256: WMS_LICENSE_PLATE_NUMBERS
257: WHERE LPN_ID = P_PARENT_LPN_ID;
258: -- For bug 14037978 commented and added Exception block code
259: /* IF SQL%NOTFOUND THEN
260: M_PARENT_LPN := 'ERROR';