postgresql7.1 update download_archive_revisions set approved_p = :approved_p, approved_comment = :approved_comment, approved_user = :user_id, approved_date = current_timestamp where revision_id = :revision_id FIX ME PLSQL - need acs-notification declare v_id integer; begin v_id := nt__post_request( party_from => :user_id, party_to => :creation_user, expand_group => 'f', subject => :subject, message => :body); return v_id; end;