565: IF p_organization_id IS NULL OR p_inventory_item_id IS NULL OR p_serial_number IS NULL THEN
566: RETURN NULL;
567: ELSE
568: SELECT owning_department_id INTO l_owning_dept_id
569: FROM mtl_serial_numbers
570: WHERE current_organization_id = p_organization_id
571: AND inventory_item_id = p_inventory_item_id
572: AND serial_number = p_serial_number;
573:
1065: THEN
1066: RETURN NULL;
1067: ELSE
1068: SELECT gen_object_id INTO l_gen_object_id
1069: FROM mtl_serial_numbers
1070: WHERE current_organization_id = p_organization_id
1071: AND inventory_item_id = p_inventory_item_id
1072: AND serial_number = p_serial_number;
1073: