l_emp(i)
is a table.
IF l_emp(i).last_name IS NOT NULL
THEN
l_emp(i).last_name := l_emp(i).last_name;
END IF;
IF l_emp(i).first_name IS NOT NULL
THEN
l_emp(i).first_name := l_emp(i).first_name;
END IF;
IF l_emp(i).middle_name IS NOT NULL
THEN
l_emp(i).middle_name := l_emp(i).middle_name;
END IF;
IF l_emp(i).url IS NOT NULL
THEN
l_emp(i).url := l_emp(i).url;
END IF;