/*  insert/update version info */

insert into SYSTEM_INFO_UPDATE
  (PATCH_VERSION,DATETIME_EXECUTION,CHANGE_INFO)
values
  (65,'now',:BLOBFROMFILE_00000000)
;

  insert into SYSTEM_INFO_MODULE
    (ID_INFO_UPDATE,APP_MODULE_NAME,APP_MODULE_VERSION)
  select max(SIU.ID_INFO_UPDATE),
         'POS',
         '3.6.65.65'
  from SYSTEM_INFO_UPDATE SIU
;

  insert into SYSTEM_INFO_MODULE
    (ID_INFO_UPDATE,APP_MODULE_NAME,APP_MODULE_VERSION)
  select max(SIU.ID_INFO_UPDATE),
         'ADMIN',
         '3.6.65.65'
  from SYSTEM_INFO_UPDATE SIU
;

insert into SYSTEM_INFO_MODULE
       (ID_INFO_UPDATE,APP_MODULE_NAME,APP_MODULE_VERSION)
select max(SIU.ID_INFO_UPDATE),
       'DBMAIN',
       65
from SYSTEM_INFO_UPDATE SIU
;

execute procedure SYSTEM_INFO_SET('PATCH_VERSION', 65)
;

commit work
;

execute procedure RIGHTS_REGRANT
;

commit work
;
