select deleted_p
from mp3_mp3s
where file_path = :client_filename
select mp3_id
from mp3_mp3s
where file_path = :client_filename
update mp3_mp3s
set file_path = :client_filename,
title = :mp3_title,
artist = :artist,
bitrate = :bitrate,
album = :album,
tracknum = :tracknum,
genre = :genre,
year = :year,
layer = :layer,
copyright_p = :copyright_p,
version = :version,
mode_num = :mode_num,
stereo_p = :stereo_p,
frequency = :frequency,
minutes = :minutes,
deleted_p = 'f'
where mp3_id = :mp3_id
update acs_objects
set creation_user = :creation_user,
creation_ip = :creation_ip,
creation_date = current_timestamp,
context_id = :package_id
where object_id = :mp3_id