procedure prc_insert_data(IN_ID in number, ON_PK_VALUE_ID out number) is
begin

     insert into MyTable (SEQ_ID)
     values (SEQ_ID_PK.nextval) RETURNING PARTNUMBER_ID INTO ON_PK_VALUE_ID;
     commit;
                                                          
end prc_insert_building;

function f_extract_string(in_position in number, iv_string in varchar2) return varchar2 is    
lv_retun_value varchar2(50);
begin             
        SELECT REGEXP_SUBSTR(iv_string,'[^,]+', 1,in_position)
        into lv_retun_value
        FROM DUAL;        
        
        return lv_retun_value;        
end f_extract_string;

function f_timestamp_to_date(iv_timestamp in varchar2) return date is    
  ldte_date date;
begin    

  select to_date(trunc(to_timestamp(iv_timestamp)))
  into ldte_date
  from dual;
  
  return ldte_date;          
end f_timestamp_to_date;