198: p_department_id <> FND_API.G_MISS_NUM)
199: THEN
200: SELECT department_id
201: INTO x_department_id
202: FROM BOM_DEPARTMENTS
203: WHERE organization_id = p_organization_id
204: AND department_id = p_department_id;
205: ELSE
206: --
205: ELSE
206: --
207: SELECT department_id
208: INTO x_department_id
209: FROM BOM_DEPARTMENTS
210: WHERE organization_id = p_organization_id
211: AND description = p_dept_description;
212: END IF;
213: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;