LOOKUP_ERRATAFILE_TYPE

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: function
     2: lookup_erratafile_type (
     3: 	label_in in varchar2
     4: ) return number deterministic is
     5: 	erratafile_type_id number;
     6: begin
     7: 	select	id
     8: 	into	erratafile_type_id
     9: 	from	rhnErrataFileType
    10: 	where	label = label_in;
    11: 
    12: 	return erratafile_type_id;
    13: exception
    14: 	when no_data_found then
    15: 		rhn_exception.raise_exception('erratafile_type_not_found');
    16: end;