DBA Data[Home] [Help]

APPS.INV_INVARCLI_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 228: WMS_LICENSE_PLATE_NUMBERS

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';

Line 256: WMS_LICENSE_PLATE_NUMBERS

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';