466: (
467: p_system_id number,
468: p_error_flag varchar2 default 'TRUE'
469: ) return varchar2 is 470: l_system_name cs_systems.name%type; 471: begin
472: if p_system_id is null then
473: raise NO_DATA_FOUND;
474: end if;
Line 478: from cs_systems
474: end if;
475: --
476: select name
477: into l_system_name 478: from cs_systems 479: where system_id = p_system_id;
480: --
481: return(l_system_name);
482: --