text: -----------------Role action mappings to Contractor search form----------------
  insert into eg_action (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'WorksSearchLOAContractor','/letterofacceptance/contractorsearchform',null,(select id from EG_MODULE where name = 'WorksLetterOfAcceptance'),1,'Search Contractor for LOA','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 ='WorksSearchLOAContractor' 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 = 'WorksSearchLOAContractor' and contextroot = 'egworks'));
  
  -----------------Role action mappings to get Contractors for LOA----------------
  insert into eg_action (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'AjaxContractorsForLOA','/letterofacceptance/ajax-contractorsforloa',null,(select id from EG_MODULE where name = 'WorksLetterOfAcceptance'),1,'Contractors to Create LOA','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 ='AjaxContractorsForLOA' 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 = 'AjaxContractorsForLOA' and contextroot = 'egworks'));
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Creator') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxContractorsForLOA' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxContractorsForLOA' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'AjaxContractorsForLOA' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Creator') and actionid = (SELECT id FROM eg_action WHERE name ='WorksSearchLOAContractor' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='WorksSearchLOAContractor' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'WorksSearchLOAContractor' and contextroot = 'egworks';
  