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: 	pragma autonomous_transaction;
     6: 	erratafile_type_id number;
     7: begin
     8: 	select	id
     9: 	into	erratafile_type_id
    10: 	from	rhnErrataFileType
    11: 	where	label = label_in;
    12: 	return erratafile_type_id;
    13: exception
    14: 	when no_data_found then
    15: 		rhn_exception.raise_exception('erratafile_type_not_found');
    16: end;