[Home] [Help]
296: IF p_DEPARTMENT_ID IS NOT NULL THEN
297: BEGIN
298: SELECT DEPARTMENT_CODE
299: INTO x_DEPARTMENT_CODE
300: FROM BOM_DEPARTMENTS
301: WHERE DEPARTMENT_ID =p_DEPARTMENT_ID;
302: EXCEPTION
303: WHEN OTHERS THEN
304: NULL;