ACS3 Data Model

     1: procedure apm_insert_unique_param_val(
     2:   p_element_id in integer,
     3:   p_value in varchar)
     4: is
     5:   exists_p integer;
     6: begin
     7:   select count(*) into exists_p
     8:     from ad_parameter_values
     9:     where element_id = p_element_id;
    10: 
    11:   if exists_p <> 0 then
    12: 
    13:     update ad_parameter_values
    14:       set value = p_value
    15:       where element_id = p_element_id;
    16: 
    17:   else
    18: 
    19:     insert into ad_parameter_values
    20:       (value_id,element_id,value)
    21:       values
    22:       (ad_param_value_id_sequence.nextval,p_element_id,p_value);
    23: 
    24:   end if;
    25: 
    26: end;