2258: -- get the relevant manufacturer id
2259: BEGIN
2260: SELECT MANUFACTURER_ID
2261: INTO l_manufacture_id
2262: FROM mtl_manufacturers
2263: WHERE MANUFACTURER_NAME = l_supplier_name
2264: AND rownum < 2;
2265:
2266: IF (l_Debug_Level <= 1) THEN