text: --module names
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License Reports','t','tl',(select id from eg_module where name = 'Trade License'),'Reports', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License Transactions','t','tl',(select id from eg_module where name = 'Trade License'),'Transactions', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Search Trade','t','tl',(select id from eg_module where name = 'Trade License'),'Search', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License Masters','t','tl',(select id from eg_module where name = 'Trade License'),'Masters', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License Category','t','tl',(select id from eg_module where name = 'Trade License Masters'),'Category', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License SubCategory','t','tl',(select id from eg_module where name = 'Trade License Masters'),'Sub Category', null);
  insert into EG_MODULE (ID,NAME,ENABLED,CONTEXTROOT,PARENTMODULE,DISPLAYNAME,ORDERNUMBER) VALUES (NEXTVAL('SEQ_EG_MODULE'),'Trade License UOM','t','tl',(select id from eg_module where name = 'Trade License Masters'),'Unit Of Measurement', null);
  
  --action urls
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseLateRenewalsReport','/reports/Trade License Reports-showLateRenewalsReport.action',null,(select id from EG_MODULE where name = 'Trade License Reports'),4,'Late Renewals','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Enter Trade License','/entertradelicense/enterTradeLicense-enterExistingForm.action',null,(select id from EG_MODULE where name = 'Trade License Transactions'),2,'Enter License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradelicense index page','/eGov_TRADELICENSE.jsp',null,(select id from EG_MODULE where name = 'Trade License'),1,'Index page','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Create New License','/newtradelicense/newTradeLicense-newForm.action',null,(select id from EG_MODULE where name = 'Trade License Transactions'),2,'Create New License','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'SearchTradeLicense','/search/searchTrade-newForm.action',null,(select id from EG_MODULE where name = 'Search Trade'),1,'Search Trade License','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseZoneWiseReport','/reports/Trade License Reports-showZoneWiseReport.action',null,(select id from EG_MODULE where name = 'Trade License Reports'),1,'Zonewise Licenses','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseWardWiseReport','/reports/Trade License Reports-showWardWiseReport.action',null,(select id from EG_MODULE where name = 'Trade License Reports'),2,'Wardwise Licenses','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseTradeWiseReport','/reports/Trade License Reports-showTradeWiseReport.action',null,(select id from EG_MODULE where name = 'Trade License Reports'),3,'Tradewise Licenses','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'New Trade License Action','/newtradelicense/newTradeLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'New Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Enter Trade License Action','/entertradelicense/enterTradeLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Enter Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Search Trade License Action','/search/searchTrade.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Search Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade License Bill Collect','/integration/licenseBillCollect.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Trade License Collection','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Cancel Trade License New Form','/cancellation/cancelLicense-newForm.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Cancel Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Cancel Trade License Action','/cancellation/cancelLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Cancel Trade Action','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Duplicate Certificate','/viewtradelicense/viewTradeLicense-duplicateCertificate.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Duplicate Certificate','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Generate Certificate','/viewtradelicense/viewTradeLicense-generateCertificate.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Generate Certificate','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Transfer Trade License New Form','/transfer/transferTradeLicense-newForm.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Transfer Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Transfer Trade License Action','/transfer/transferTradeLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Transfer Trade Action','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Transfer Trade License Show for Approval','/transfer/transferTradeLicense-showForApproval.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Transfer Show for Approval','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'New Trade License Before Edit','/newtradelicense/editTradeLicense-beforeEdit.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'New Trade License Edit','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Edit Trade License Action','/newtradelicense/editTradeLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Edit Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  /*
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Show for Approval','/viewtradelicense/viewTradeLicense-showForApproval.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Show for Approval','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  */
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Action','/viewtradelicense/viewTradeLicense.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'View Trade License','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Generate Rejection Certificate','/viewtradelicense/viewTradeLicense-generateRejCertificate.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Generate Rejection Certificate','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade License Objection New Form','/objection/objection-newForm.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Trade License Objection','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade License Objection Action','/objection/objection.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Trade Objection Action','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade License Objection Show for Approval','/objection/objection-showForApproval.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Objection Show for Approval','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Revoke Suspension New Form','/revokesuspension/revokeSuspension-newForm.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Revoke Suspension','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Revoke Suspension Action','/revokesuspension/revokeSuspension.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Revoke Suspension','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade License Renewal Notice','/renew/tradeRenewalNotice-renewalNotice.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Renewal Notice','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'New Trade License Before Renew','/newtradelicense/newTradeLicense-beforeRenew.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Trade Before Renew','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Objection Preliminary Notice','/objection/objection-preNotice.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Preliminary Notice','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Objection Show Cause Notice','/objection/objection-scNotice.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Show Cause Notice','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Objection Print Preliminary Notice','/objection/objection-preliminaryNotice.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Preliminary Notice','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Trade Objection Print Show Cause Notice','/objection/objection-showCauseNotice.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Show Cause Notice','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Transfer Trade License Before Edit','/transfer/transferTradeLicense-beforeEdit.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Transfer License Edit','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License Certificate for Rejection','/viewtradelicense/viewTradeLicense-certificateForRej.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Certificate for Rejection','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Populate Divisions for Trade License','/commonAjax-populateDivisions.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Populate Divisions','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Populate Designation for Trade License','/commonAjax-ajaxPopulateDesignationsByDept.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Populate Designation','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Populate Users for Trade License','/commonAjax-ajaxPopulateUsersByDesignation.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'Populate Users','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'TLAuditTrailReport','/viewtradelicense/viewTradeLicense-auditReport.action','moduleName=TL',(select id from EG_MODULE where name = 'Trade License Reports'),1,'Audit Trail Report','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Search Trade Portal Licenses','/search/searchTrade-searchPortal.action',null,(select id from EG_MODULE where name = 'Search Trade'),2,'Search Portal Licenses','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  --action urls for category
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Create License Category','/masters/licenseCategory-newform.action',null,(select id from EG_MODULE where name = 'Trade License Category'),1,'Create License Category','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Save License Category','/masters/licenseCategory-save.action',null,(select id from EG_MODULE where name = 'Trade License Category'),1,'Save License Category','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Modify License Category','/masters/licenseCategory-edit.action','userMode=edit',(select id from EG_MODULE where name = 'Trade License Category'),2,'Modify License Category','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'saveEditedCategory','/masters/licenseCategory-newform.action','id=',(select id from EG_MODULE where name = 'Trade License Category'),2,'saveEditedCategory','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View License Category','/masters/licenseCategory-edit.action','userMode=view',(select id from EG_MODULE where name = 'Trade License Category'),3,'View License Category','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  --action urls for subcategory
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Create License SubCategory','/masters/licenseSubCategory-newform.action',null,(select id from EG_MODULE where name = 'Trade License SubCategory'),1,'Create License SubCategory','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Save License SubCategory','/masters/licenseSubCategory-save.action',null,(select id from EG_MODULE where name = 'Trade License SubCategory'),1,'Save License SubCategory','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Modify License SubCategory','/masters/licenseSubCategory-edit.action','userMode=edit',(select id from EG_MODULE where name = 'Trade License SubCategory'),2,'Modify License SubCategory','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'saveEditedSubCategory','/masters/licenseSubCategory-newform.action','id=',(select id from EG_MODULE where name = 'Trade License SubCategory'),2,'saveEditedSubCategory','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View License SubCategory','/masters/licenseSubCategory-edit.action','userMode=view',(select id from EG_MODULE where name = 'Trade License SubCategory'),3,'View License SubCategory','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  --action urls for search / edit / create tradelicense
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'searchTrade-search','/search/searchTrade-search.action',(select id from eg_module where name='Search Trade'),1,'searchTrade-search',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'editTradeLicense-edit','/newtradelicense/editTradeLicense-edit.action',(select id from eg_module where name='Trade License Transactions'),1,'editTradeLicense-edit',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'newTradeLicense-create','/newtradelicense/newTradeLicense-create.action',(select id from eg_module where name='Trade License Transactions'),1,'newTradeLicense-create',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'transferTradeLicense-create','/transfer/transferTradeLicense-create.action',(select id from eg_module where name='Trade License Transactions'),1,'transferTradeLicense-create',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'transferTradeLicense-edit','/transfer/transferTradeLicense-edit.action',(select id from eg_module where name='Trade License Transactions'),1,'transferTradeLicense-edit',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'viewTradeLicense-view','/viewtradelicense/viewTradeLicense-view.action',(select id from eg_module where name='Trade License Transactions'),1,'viewTradeLicense-view',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'objection-create','/objection/objection-create.action',(select id from eg_module where name='Trade License Transactions'),1,'objection-create',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'ajax-populateDivisions','/domain/commonTradeLicenseAjax-populateDivisions.action',(select id from eg_module where name='Trade License Transactions'),1,'ajax-populateDivisions',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  
  
  --action urls for UOM
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Create Unit Of Measurement','/masters/unitOfMeasurement-newform.action',null,(select id from EG_MODULE where name = 'Trade License UOM'),1,'Create Unit Of Measurement','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Save UOM','/masters/unitOfMeasurement-save.action',null,(select id from EG_MODULE where name = 'Trade License UOM'),1,'Save UOM','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License UOM'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'editUnitOfMeasurement','/masters/unitOfMeasurement-newform.action','id=',(select id from EG_MODULE where name = 'Trade License UOM'),1,'editUnitOfMeasurement','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseAjaxMaster','/masters/ajaxMaster-validateActions.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'tradeLicenseAjaxMaster','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Modify Unit Of Measurement','/masters/unitOfMeasurement-edit.action','userMode=edit',(select id from EG_MODULE where name = 'Trade License UOM'),2,'Modify Unit Of Measurement','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Unit Of Measurement','/masters/unitOfMeasurement-edit.action','userMode=view',(select id from EG_MODULE where name = 'Trade License UOM'),3,'View Unit Of Measurement','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  INSERT INTO EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values 
  (NEXTVAL('SEQ_EG_ACTION'),'NewTradeLicense-approve','/newtradelicense/newTradeLicense-approve.action',null,(select id from EG_MODULE where name = 'Trade License'),null,null,'f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values 
  (NEXTVAL('SEQ_EG_ACTION'),'NewTradeLicense-renewal','/newtradelicense/newTradeLicense-renewal.action',null,(select id from EG_MODULE where name = 'Trade License'),null,null,'f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseSubCategoryAjax','/domain/commonTradeLicenseAjax-populateSubCategory.action',null,(select id from EG_MODULE where name = 'Trade License Transactions'),1,'tradeLicenseSubCategoryAjax','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'tradeLicenseLocalityAjax','/domain/commonTradeLicenseAjax-blockByLocality',null,(select id from EG_MODULE where name = 'Trade License Transactions'),1,'tradeLicenseLocalityAjax','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  
  -------Action urls for FeeMatrix
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'Create-FeeMatrix','/feematrix/create',(select id from eg_module where name='Trade License Masters'),1,'Create-FeeMatrix',true,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='Create-FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'Update-FeeMatrix','/feematrix/update',(select id from eg_module where name='Trade License Masters'),1,'Update-FeeMatrix',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='Update-FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'View-FeeMatrix','/feematrix/view',(select id from eg_module where name='Trade License Masters'),1,'View-FeeMatrix',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='View-FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'Edit-FeeMatrix','/feematrix/edit',(select id from eg_module where name='Trade License Masters'),1,'Edit-FeeMatrix',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='Edit-FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'Ajax-SubCategoryByParent','/domain/commonAjax-ajaxPopulateSubCategory.action',(select id from eg_module where name='Trade License Masters'),1,'Ajax-SubCategoryByParent',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='Ajax-SubCategoryByParent'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application) values(nextval('SEQ_EG_ACTION'),'Search-FeeMatrix','/feematrix/search',(select id from eg_module where name='Trade License Masters'),1,'Search-FeeMatrix',false,'tl',(select id from eg_module where name='Trade License' and parentmodule is null));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='Search-FeeMatrix'));
  
  
  ------RoleAction Mappings for SuperUser----------------
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name = 'Create New License Create Action';
  
  
  -- category
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Create License Category' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Save License Category' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Modify License Category' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='View License Category' and contextroot = 'tl';
  
  
  -- subcategory
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Create License SubCategory' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Save License SubCategory' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Modify License SubCategory' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='View License SubCategory' and contextroot = 'tl';
  
  
  --search
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='searchTrade-search'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='editTradeLicense-edit'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='newTradeLicense-create'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='transferTradeLicense-create'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='transferTradeLicense-edit'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='viewTradeLicense-view'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='objection-create'));
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),(select id from eg_action where name='ajax-populateDivisions'));
  
  
  --UOM
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Create Unit Of Measurement' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Save UOM' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='editUnitOfMeasurement' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='tradeLicenseAjaxMaster' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='Modify Unit Of Measurement' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='View Unit Of Measurement' and contextroot = 'tl';
  
  
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'viewTradeLicense-view'), (select id from eg_role where name = 'Super User'));
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name = 'NewTradeLicense-renewal';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='tradeLicenseSubCategoryAjax' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='tradeLicenseLocalityAjax' and contextroot = 'tl';
  
  
  ------------Role Action Mappings for TLCreator and  TLApprover 
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLCreator'),(select id from eg_action where name = 'ajax-populateDivisions'));
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLCreator'),(select id from eg_action where name = 'newTradeLicense-create'));
  /* INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLApprover'),(select id from eg_action where name = 'View Trade License Show for Approval'));
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLCreator'),(select id from eg_action where name = 'View Trade License Show for Approval')); */
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLCreator'),(select id from eg_action where name = 'New Trade License Before Edit'));
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLCreator'),(select id from eg_action where name = 'editTradeLicense-edit'));
  INSERT INTO eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'TLApprover'),(select id from eg_action where name = 'NewTradeLicense-approve'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'Create New License'), (select id from eg_role where name = 'TLCreator'));
  /*
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'AjaxDesignationDropdown'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'AjaxApproverDropdown'), (select id from eg_role where name = 'TLCreator'));
  */
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'SearchTradeLicense'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'SearchTradeLicense'), (select id from eg_role where name = 'TLApprover'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'searchTrade-search'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'searchTrade-search'), (select id from eg_role where name = 'TLApprover'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'viewTradeLicense-view'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'viewTradeLicense-view'), (select id from eg_role where name = 'TLApprover'));
  /*
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'AjaxDesignationDropdown'), (select id from eg_role where name = 'TLApprover'));
  
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'AjaxApproverDropdown'), (select id from eg_role where name = 'TLApprover'));
  */
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'New Trade License Before Renew'), (select id from eg_role where name = 'TLCreator'));
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLCreator'), id from eg_action where name = 'NewTradeLicense-renewal';
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'View Trade License Duplicate Certificate'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'View Trade License Generate Certificate'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'Transfer Trade License New Form'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'transferTradeLicense-create'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'Trade License Objection New Form'), (select id from eg_role where name = 'TLCreator'));
  INSERT INTO eg_roleaction (actionid, roleid) values ((select id from eg_action where name = 'objection-create'), (select id from eg_role where name = 'TLCreator'));
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLCreator'), id from eg_action where name='tradeLicenseSubCategoryAjax' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLCreator'), id from eg_action where name='tradeLicenseLocalityAjax' and contextroot = 'tl';
  
  
  --action and roleaction mapping for feematrix
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application)
  values(nextval('SEQ_EG_ACTION'),'Create-License FeeMatrix','/feematrix/create?fee=License Fee',
  (select id from eg_module where name='Trade License Masters'),1,'Create-License FeeMatrix',true,'tl',
  (select id from eg_module where name='Trade License' and parentmodule is null));
  
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),
  (select id from eg_action where name='Create-License FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application)
  values(nextval('SEQ_EG_ACTION'),'Create-Motor FeeMatrix','/feematrix/create?fee=Motor Fee',
  (select id from eg_module where name='Trade License Masters'),1,'Create-Motor FeeMatrix',true,'tl',
  (select id from eg_module where name='Trade License' and parentmodule is null));
  
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),
  (select id from eg_action where name='Create-Motor FeeMatrix'));
  
  Insert into eg_action(id,name,url,parentmodule,ordernumber,displayname,enabled,contextroot,application)
  values(nextval('SEQ_EG_ACTION'),'Create-Workforce FeeMatrix','/feematrix/create?fee=Workforce Fee',
  (select id from eg_module where name='Trade License Masters'),1,'Create-Workforce FeeMatrix',true,'tl',
  (select id from eg_module where name='Trade License' and parentmodule is null));
  
  Insert into eg_roleaction values((select id from eg_role where name='Super User'),
  (select id from eg_action where name='Create-Workforce FeeMatrix'));
  
  
  -- Adding roleaction for TLApprover
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='tradeLicenseLocalityAjax' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name = 'newTradeLicense-create';
  
  -- Adding egaction and roleaction for view Trade License
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'View Trade License for Approval','/newtradelicense/newTradeLicense-showForApproval.action',null,(select id from EG_MODULE where name = 'Trade License'),1,'View Trade License for Approval','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLCreator'), id from eg_action where name='View Trade License for Approval' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='View Trade License for Approval' and contextroot = 'tl';
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'Super User'), id from eg_action where name='View Trade License for Approval' and contextroot = 'tl';
  
  
  
  --Action and Roleaction Mappings for Cancel License
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Cancel License','/search/searchLicense-commonForm.action','mode=Cancel License',(select id from EG_MODULE where name = 'Trade License Transactions'),3,'Cancel License','t','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Cancel License Search','/search/searchLicense-commonSearch.action',null,(select id from EG_MODULE where name = 'Trade License Transactions'),4,'Cancel License Search','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='Cancel License' and contextroot = 'tl';
  
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='Cancel License Search' and contextroot = 'tl';
  
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='Cancel Trade License New Form' and contextroot = 'tl';
  
  
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'Cancel License Submit','/cancellation/cancelLicense-confirmCancellation.action',null,(select id from EG_MODULE where name = 'Trade License Transactions'),5,'Cancel License Submit','f','tl',0,1,now(),1,now(),(select id from eg_module  where name = 'Trade License'));
  
  insert into eg_roleaction (roleid, actionid) select (select id from eg_role where name = 'TLApprover'), id from eg_action where name='Cancel License Submit' and contextroot = 'tl';
  