568: return null;
569: END get_supplier_name;
570:
571: FUNCTION get_schedule_role_name
572: (p_proj_assignment_id IN pa_project_assignments.assignment_id%TYPE) return VARCHAR2 is
573: l_return_value VARCHAR2(80) := 'invalid value';
574: BEGIN
575: select assignment_name
576: into l_return_value
573: l_return_value VARCHAR2(80) := 'invalid value';
574: BEGIN
575: select assignment_name
576: into l_return_value
577: from pa_project_assignments
578: where assignment_id = p_proj_assignment_id;
579: return l_return_value;
580: EXCEPTION
581: when NO_DATA_FOUND then