293: RP_WAREHOUSE := NULL;
294: END;
295: END IF;
296: IF P_ITEM_ID IS NOT NULL THEN
297: RP_ITEM := WSH_UTIL_CORE.GET_ITEM_NAME(P_ITEM_ID
298: ,P_ORGANIZATION_ID
299: ,P_ITEM_FLEX_CODE
300: ,LP_STRUCTURE_NUM);
301: END IF;
339: ELSE
340: NAME := ITEM_DESCRIPTION;
341: END IF;
342: ELSIF P_ITEM_DISPLAY = 'F' THEN
343: NAME := WSH_UTIL_CORE.GET_ITEM_NAME(INVENTORY_ITEM_ID
344: ,ORGANIZATION_ID
345: ,P_ITEM_FLEX_CODE
346: ,LP_STRUCTURE_NUM);
347: ELSE
352: CLOSE INVENTORY_LABEL;
353: ELSE
354: NAME := ITEM_DESCRIPTION;
355: END IF;
356: NAME := WSH_UTIL_CORE.GET_ITEM_NAME(INVENTORY_ITEM_ID
357: ,ORGANIZATION_ID
358: ,P_ITEM_FLEX_CODE
359: ,LP_STRUCTURE_NUM) || ' ' || NAME;
360: END IF;
386: ELSE
387: NAME := ITEM_DESCRIPTION;
388: END IF;
389: ELSIF P_ITEM_DISPLAY = 'F' THEN
390: NAME := WSH_UTIL_CORE.GET_ITEM_NAME(LINE_ITEM
391: ,ORGANIZATION_ID
392: ,P_ITEM_FLEX_CODE
393: ,LP_STRUCTURE_NUM);
394: ELSE
399: CLOSE INVENTORY_LABEL;
400: ELSE
401: NAME := ITEM_DESCRIPTION;
402: END IF;
403: NAME := WSH_UTIL_CORE.GET_ITEM_NAME(LINE_ITEM
404: ,ORGANIZATION_ID
405: ,P_ITEM_FLEX_CODE
406: ,LP_STRUCTURE_NUM) || ' ' || NAME;
407: END IF;