The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => sysdate
,v_end_time => NULL
,v_status => 'START'
,v_message => 'IN PROCESS OF ' || acctable_list(i)
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => NULL
,v_end_time => sysdate
,v_status => 'COMPLETE'
,v_message => 'FINISHED ' || acctable_list(i)
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => sysdate
,v_end_time => NULL
,v_status => 'FAILED'
,v_message => sqlerrm
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);
l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => sysdate
,v_end_time => NULL
,v_status => 'START'
,v_message => 'IN PROCESS OF ' || acctable_list(i)
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => NULL
,v_end_time => sysdate
,v_status => 'COMPLETE'
,v_message => 'FINISHED ' || acctable_list(i)
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);
JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
(v_package_name => NULL
,v_procedure_name => NULL
,v_con_query_id => NULL
,v_query_stmt => l_query_string
,v_start_time => sysdate
,v_end_time => NULL
,v_status => 'FAILED'
,v_message => sqlerrm
,x_log_id => ll_log_id
,x_status => ll_status
,x_msg_data => ll_message);