1343: BEGIN
1344: IF(p_owning_department IS NOT NULL) THEN
1345: select department_id
1346: into l_dept_id
1347: from bom_departments
1348: where organization_id = p_organization_id
1349: and department_code = p_owning_department;
1350: END IF;
1351: EXCEPTION WHEN OTHERS THEN
2615:
2616: BEGIN
2617: select department_id
2618: into l_dept_id
2619: from bom_departments
2620: where organization_id = l_org_id
2621: and department_code = p_owning_department;
2622:
2623: EXCEPTION WHEN OTHERS THEN