oracle query

--1    EnumValue=215

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
  select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=215;
  IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',215,'Battery Counter Indicator','Battery Counter Indicator',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--2  EnumValue=216

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=216;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',216,'Battery Counter Indicator                                                                                                                      
Critical Alaram','Battery Counter Indicator
Critical Alaram',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--3  EnumValue=217

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=217;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',217,'Battery Counter Indicator
Detached
Critical Alaram','Battery Counter Indicator
Detached
Critical Alaram',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--4  EnumValue=218

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=218;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',218,'Battery Counter Indicator
Device Battery Low','Battery Counter Indicator
Device Battery Low',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;

--5  EnumValue=219

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=219;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',219,'Battery Counter Indicator
Detached
Device Low Battery','Battery Counter Indicator
Detached
Device Low Battery',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--6  EnumValue=220

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=220;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',220,'Not Current Read
Leak Detection','Not Current Read
Leak Detection',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--7  EnumValue=221

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=221;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',221,'Not Current Read
Battery Counter Indicator/Detached
Leak Detection','Not Current Read
Battery Counter Indicator/Detached
Leak Detection',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;
--8  EnumValue=222

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=222;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',222,'Not Current Read
Reverse Flow','Not Current Read
Reverse Flow',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;

/
commit;
--9  EnumValue=223

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=223;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',223,'Not Current Read
Battery Counter Indicator/Detached
Reverse Flow','Not Current Read
Battery Counter Indicator/Detached
Reverse Flow',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;

/
commit;
--10  EnumValue=223

DECLARE  
   cnt  NUMBER(3,2);
BEGIN
 select count(*) INTO cnt from EnumTranslation where EnumName = 'ReportTamperTranslationTypes' and EnumValue=224;
IF cnt = 0 THEN insert into EnumTranslation values (sys_guid(),'ReportTamperTranslationTypes',224,'Not Current Read
Battery Counter Indicator/Detached
Leak Detection
Reverse Flow','Not Current Read
Battery Counter Indicator/Detached
Leak Detection
Reverse Flow',NULL,' ',sysdate,NULL,'Insert',0);
  END IF;
END;
/
commit;