APPS.OKC_AQ_WRITE_ERROR_PVT SQL Statements

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

Line: 37

	--Select the retry count from events table
	Cursor retry_cur(p_msgid IN RAW) is
	select /*+ INDEX (OKC_AQ_EV_TAB) */ retry_count
	from OKC_AQ_EV_TAB
	where msgid = p_msgid;

Line: 88

		--Call the public api to insert records into error and message stack tables
		OKC_AQERRMSG_PUB.create_err_msg(
    				p_api_version		=> p_api_version,
    				p_init_msg_list		=> p_init_msg_list,
    				x_return_status		=> l_return_status,
    				x_msg_count		=> l_msg_count,
    				x_msg_data		=> l_msg_data,
    				p_aqev_rec		=> l_aqev_rec,
    				p_aqmv_tbl 		=> l_aqmv_tbl,
    				x_aqev_rec		=> x_aqev_rec,
   			 	x_aqmv_tbl 		=> x_aqmv_tbl);

Line: 127

		--Call the Public API to insert error records into the okc_aqerrors
		--and okc_aqmsgstacks
		OKC_AQERRMSG_PUB.create_err_msg(
    				p_api_version		=> p_api_version,
    				p_init_msg_list		=> p_init_msg_list,
    				x_return_status		=> l_return_status,
    				x_msg_count		=> l_msg_count,
    				x_msg_data		=> l_msg_data,
    				p_aqev_rec		=> l_aqev_rec,
    				p_aqmv_tbl 		=> l_aqmv_tbl,
    				x_aqev_rec		=> x_aqev_rec,
   			 	x_aqmv_tbl 		=> x_aqmv_tbl);

Line: 195

    PROCEDURE UPDATE_ERROR(p_api_version   IN NUMBER,
				   p_init_msg_list IN VARCHAR2 ,
				   p_id		   IN NUMBER,
				   p_aqe_id        IN NUMBER,
				   p_msg_seq_no    IN NUMBER,
				   p_source_name   IN VARCHAR2,
				   p_datetime	   IN DATE,
				   p_q_name	   IN VARCHAR2 ,
				   p_msgid         IN RAW ,
			           p_message_no	   IN NUMBER,
				   p_message_name  IN VARCHAR2,
				   p_message_text  IN VARCHAR2,
				   x_msg_count	   OUT NOCOPY NUMBER,
				   x_msg_data	   OUT NOCOPY VARCHAR2,
				   x_return_status OUT NOCOPY VARCHAR2) IS
    BEGIN
	NULL;

Line: 212

    END UPDATE_ERROR;

Line: 219

    PROCEDURE DELETE_ERROR(p_api_version   IN NUMBER,
				   p_init_msg_list IN VARCHAR2 ,
				   p_id 	   IN NUMBER,
				   x_msg_count	   OUT NOCOPY NUMBER,
				   x_msg_data	   OUT NOCOPY VARCHAR2,
				   x_return_status OUT NOCOPY VARCHAR2) IS
    BEGIN
	NULL;

Line: 227

    END DELETE_ERROR;

Line: 246

	select name
	from okc_actions_v
	where correlation = p_corrid;