459: ', Dept Id = ' || p_department_id || ', Dept Name = ' || p_dept_name);
460: END IF;
461: IF (p_department_id IS NOT NULL) THEN
462: SELECT department_id INTO x_department_id
463: FROM BOM_DEPARTMENTS
464: WHERE organization_id = p_organization_id
465: AND department_id = p_department_id;
466: END IF;
467:
466: END IF;
467:
468: IF (p_dept_name IS NOT NULL) THEN
469: SELECT department_id INTO x_department_id
470: FROM BOM_DEPARTMENTS
471: WHERE organization_id = p_organization_id
472: AND description = p_dept_name;
473: END IF;
474: