ACS3 Data Model

     1: procedure apm_register_file(v_version_id in integer, v_path in varchar, v_file_type in varchar) is
     2: begin
     3:     insert into apm_package_files(file_id, version_id, path, file_type)
     4:         select apm_package_file_id_seq.nextval, v_version_id, v_path, v_file_type from dual
     5:         where not exists (select 1 from apm_package_files where path = v_path and version_id = v_version_id);
     6: end;