443: SELECT
444: CUSTOMER_ITEM_NUMBER
445: INTO V_CUST_ITEM_NUMBER
446: FROM
447: MTL_CUSTOMER_ITEMS
448: WHERE CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1;
449: RETURN (V_CUST_ITEM_NUMBER);
450: EXCEPTION
451: WHEN OTHERS THEN
458: SELECT
459: CUSTOMER_ITEM_DESC
460: INTO V_CUST_ITEM_DESC
461: FROM
462: MTL_CUSTOMER_ITEMS
463: WHERE CUSTOMER_ITEM_ID = CUSTOMER_ITEM_ID1;
464: RETURN (V_CUST_ITEM_DESC);
465: EXCEPTION
466: WHEN OTHERS THEN