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'),'InspectionSuccess','/inspection/success/',null,(select id from eg_module where name='BPA Transanctions'),16,'InspectionSuccess','false','bpa',0,1,now(),1,now(),
  (select id from eg_module where name='BPA'));
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='EMPLOYEE'), (select id from eg_action where name='InspectionSuccess'));
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='ULB Operator'),(select id from eg_action where name='InspectionSuccess'));
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='BPA Approver'), (select id from eg_action where name='InspectionSuccess'));