text: 
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'WorksPackageSetOfflineStatus','/tender/offlineStatus-retenderEdit.action','setStatus=create',(select id from EG_MODULE where name = 'WorksPackage'),0,'WorksPackageSetOfflineStatus','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='WorksPackageSetOfflineStatus' and contextroot = 'egworks'));
  
  --rollback delete from eg_roleaction where actionid in (select id from eg_action where name in ('WorksPackageSetOfflineStatus') and contextroot = 'egworks') and roleid in(select id from eg_role where name = 'Super User');
  --rollback delete from eg_action where name in ('WorksPackageSetOfflineStatus') and contextroot = 'egworks';