FUNCTION get_person_name (p_user_id IN NUMBER)
RETURN VARCHAR2
IS
v_person_name VARCHAR2 (100);
BEGIN
SELECT ppf.full_name
INTO v_person_name
FROM fnd_user fu, per_people_f ppf
WHERE fu.employee_id = ppf.person_id(+) AND fu.user_id = p_user_id;
RETURN (v_person_name);
EXCEPTION
WHEN OTHERS
THEN
RETURN (v_person_name);
END;