101: SELECT
102: LICENSE_PLATE_NUMBER
103: INTO X_PARENT_LPN
104: FROM
105: WMS_LICENSE_PLATE_NUMBERS
106: WHERE LPN_ID = L_PARENT_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
107: EXCEPTION
108: WHEN NO_DATA_FOUND THEN
109: X_PARENT_LPN := 'ERROR';
127: SELECT
128: LICENSE_PLATE_NUMBER
129: INTO X_OUTERMOST_LPN
130: FROM
131: WMS_LICENSE_PLATE_NUMBERS
132: WHERE LPN_ID = L_OUTERMOST_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: X_OUTERMOST_LPN := 'ERROR';