APPS.JTM_CHECK_ACC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;

Line: 30

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);

Line: 45

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);

Line: 73

 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);

Line: 113

l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;

Line: 115

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);

Line: 130

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);

Line: 157

 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);