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'),'createOcNoc','/ocnocapplication/create',null,(select id from eg_module where name='BPA Transanctions'),
  (select max(ordernumber)+1 from EG_ACTION),'createOcNoc','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='BUSINESS'),
  (select id from eg_action where name='createOcNoc'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='createOcNoc'));
  ------------------------
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application)
  values (nextval('SEQ_EG_ACTION'),'updateOcNocApplication','/ocnocapplication/update',null,(select id from eg_module where name='BPA Transanctions'),
  (select max(ordernumber)+1 from EG_ACTION),'updateOcNocApplication','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='BUSINESS'),
  (select id from eg_action where name='updateOcNocApplication'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='updateOcNocApplication'));
  ------------------------------
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application)
  values (nextval('SEQ_EG_ACTION'),'OC Noc application success','/ocnocapplication/success',null,(select id from eg_module where name='BPA Transanctions'),(select max(ordernumber)+1 from EG_ACTION),'OC Noc application success','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='BUSINESS'),
  (select id from eg_action where name='OC Noc application success'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='OC Noc application success'));
  
  ----------------------------------
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application)
  values (nextval('SEQ_EG_ACTION'),'ocupdateNoc','/ocnocapplication/updateNoc',null,(select id from eg_module where name='BPA Transanctions'),
  (select max(ordernumber)+1 from EG_ACTION),'ocupdateNoc','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='BUSINESS'),
  (select id from eg_action where name='ocupdateNoc'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='ocupdateNoc'));
  
  
  
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application)
  values (nextval('SEQ_EG_ACTION'),'ocviewNoc','/ocnocapplication/view',null,(select id from eg_module where name='BPA Transanctions'),
  (select max(ordernumber)+1 from EG_ACTION),'ocviewNoc','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='BUSINESS'),
  (select id from eg_action where name='ocviewNoc'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='ocviewNoc'));
  
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='EMPLOYEE'),
  (select id from eg_action where name='ocviewNoc'));
  
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='EMPLOYEE'),
  (select id from eg_action where name='createOcNoc'));
  
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='EMPLOYEE'),
  (select id from eg_action where name='OC Noc application success'));
  
  
  
  
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application) 
  values (nextval('SEQ_EG_ACTION'),'get oc documents by service type','/application/getocdocumentlistbyservicetype',null,(select id from eg_module where name='BPA Transanctions'),16,'get oc documents by service type','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='ULB Operator'),(select id from eg_action where name='get oc documents by service type'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='BPA Approver'), (select id from eg_action where name='get oc documents by service type'));
  
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'), (select id from eg_action where name='get oc documents by service type'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='BUSINESS'), (select id from eg_action where name='get oc documents by service type'));
  
  -----------------------------------------------------------------------------------------
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application) 
  values (nextval('SEQ_EG_ACTION'),'OCNocUser','/ajax/getOCNocUsersByCode',null,(select id from eg_module where name='BPA Transanctions'),18,'NocUser','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='BUSINESS'), (select id from eg_action where name='OCNocUser'));
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'), (select id from eg_action where name='OCNocUser'));
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='EMPLOYEE'), (select id from eg_action where name='OCNocUser'));
  
  