The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT EXECUTE_FLAG
, HOOK_PACKAGE
, HOOK_API
FROM JTF_HOOKS_DATA
WHERE PRODUCT_CODE = 'CSL'
AND PACKAGE_NAME = b_package_name
AND API_NAME = b_api_name
AND HOOK_TYPE = b_hook_type
AND PROCESSING_TYPE = b_process_type
AND EXECUTE_FLAG = 'Y';
hookTable(1).apiName := 'DELETE_ROW' ;
hookTable(2).apiName := 'DELETE_ROW' ;
hookTable(3).apiName := 'INSERT_ROW' ;
hookTable(4).apiName := 'INSERT_ROW' ;
hookTable(5).apiName := 'UPDATE_ROW' ;
hookTable(6).apiName := 'UPDATE_ROW' ;
hookTable(7).apiName := 'DELETE_ROW' ;
hookTable(8).apiName := 'INSERT_ROW' ;
hookTable(9).apiName := 'UPDATE_ROW' ;
hookTable(10).apiName := 'UPDATE_ROW' ;
hookTable(11).apiName := 'INSERT_ROW' ;
hookTable(12).apiName := 'UPDATE_ROW' ;
hookTable(13).apiName := 'INSERT_ROW' ;
hookTable(14).apiName := 'UPDATE_ROW' ;
hookTable(16).apiName := 'UPDATE_LOCATION' ;
hookTable(19).apiName := 'Update_ServiceRequest' ;
hookTable(20).apiName := 'Update_ServiceRequest' ;
hookTable(23).apiName := 'DELETE_TASK' ;
hookTable(24).apiName := 'DELETE_TASK' ;
hookTable(25).apiName := 'UPDATE_TASK' ;
hookTable(26).apiName := 'UPDATE_TASK' ;
hookTable(29).apiName := 'DELETE_TASK_ASSIGNMENT' ;
hookTable(30).apiName := 'DELETE_TASK_ASSIGNMENT' ;
hookTable(31).apiName := 'UPDATE_TASK_ASSIGNMENT' ;
hookTable(32).apiName := 'UPDATE_TASK_ASSIGNMENT' ;
hookTable(36).apiName := 'DELETE_COUNTER' ;
hookTable(37).apiName := 'DELETE_CTR_PROP' ;
hookTable(38).apiName := 'UPDATE_COUNTER' ;
hookTable(39).apiName := 'UPDATE_CTR_GRP' ;
hookTable(40).apiName := 'UPDATE_CTR_PROP' ;
hookTable(43).apiName := 'UPDATE_COUNTER_READING' ;
hookTable(44).apiName := 'UPDATE_COUNTER_READING' ;
hookTable(47).apiName := 'UPDATE_NOTE' ;
hookTable(49).apiName := 'DELETE_RESOURCE_GROUP_MEMBERS' ;