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'),'WorksSaveContractorBill','/contractorbill/contractorbill-save',null,(select id from EG_MODULE where name = 'WorksContractorBill'),1,'WorksSaveContractorBill',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 ='WorksSaveContractorBill' and contextroot = 'egworks'));
  insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Creator'),(select id from eg_action where name ='WorksSaveContractorBill' and contextroot = 'egworks'));
  
  
  insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'WorksSaveContractorBillSuccess','/contractorbill/contractorbill-success',null,(select id from EG_MODULE where name = 'WorksContractorBill'),1,'WorksSaveContractorBillSuccess',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 ='WorksSaveContractorBillSuccess' and contextroot = 'egworks'));
  insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Creator'),(select id from eg_action where name ='WorksSaveContractorBillSuccess' and contextroot = 'egworks'));
  
  --rollback delete from eg_roleaction where actionid in (select id from eg_action where name in ('WorksSaveContractorBillSuccess','WorksSaveContractorBill') and contextroot = 'egworks') and roleid in(select id from eg_role where name in('Super User','Works Creator'));
  --rollback delete from eg_action where name in ('WorksSaveContractorBillSuccess','WorksSaveContractorBill') and contextroot = 'egworks';