DBA Data[Home] [Help]

APPS.INV_INVARPSL_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 204: WMS_LICENSE_PLATE_NUMBERS

200: SELECT
201: LICENSE_PLATE_NUMBER
202: INTO M_OUTERMOST_LPN
203: FROM
204: WMS_LICENSE_PLATE_NUMBERS
205: WHERE LPN_ID = P_OUTERMOST_LPN_ID;
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: M_OUTERMOST_LPN := 'ERROR';

Line 224: WMS_LICENSE_PLATE_NUMBERS

220: SELECT
221: LICENSE_PLATE_NUMBER
222: INTO M_PARENT_LPN
223: FROM
224: WMS_LICENSE_PLATE_NUMBERS
225: WHERE LPN_ID = P_PARENT_LPN_ID;
226: EXCEPTION
227: WHEN NO_DATA_FOUND THEN
228: M_PARENT_LPN := 'ERROR';