ACS3 Data Model

     1: function im_proj_url_from_type ( v_group_id IN integer, v_url_type IN varchar )
     2: return varchar
     3: IS
     4:   v_url 		im_project_url_map.url%TYPE;
     5: BEGIN
     6:   begin
     7:     select url into v_url
     8:       from im_url_types, im_project_url_map
     9:      where group_id=v_group_id
    10:        and im_url_types.url_type_id=im_project_url_map.url_type_id
    11:        and url_type=v_url_type;
    12:   exception when others then null;
    13:   end;
    14:   return v_url;
    15: END;