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