APPS.OKL_CURE_REQ_AMT_PUB SQL Statements

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

Line: 5

PROCEDURE update_cure_request(
            p_api_version    	    IN  NUMBER,
            p_init_msg_list         IN  VARCHAR2 ,
            x_return_status         OUT NOCOPY VARCHAR2,
            x_msg_count             OUT NOCOPY NUMBER,
            x_msg_data              OUT NOCOPY VARCHAR2,
            p_cure_req_tbl          IN         cure_req_tbl_type,
            x_cure_req_tbl          OUT NOCOPY cure_req_tbl_type) IS

    l_api_name	       VARCHAR2(30) := 'update_cure_request';

Line: 37

      OKL_CURE_REQ_AMT_PVT.update_cure_request(
	        p_api_version    	=> p_api_version,
	        p_init_msg_list  	=> p_init_msg_list,
	        x_return_status  	=> x_return_status,
	        x_msg_count      	=> x_msg_count,
	        x_msg_data       	=> x_msg_data,
	        p_cure_req_tbl	        => l_cure_req_tbl,
	   	x_cure_req_tbl		=> x_cure_req_tbl
		);

Line: 85

PROCEDURE update_cure_request(
            p_api_version    	     IN  NUMBER,
            p_init_msg_list          IN  VARCHAR2 ,
            x_return_status          OUT NOCOPY VARCHAR2,
            x_msg_count              OUT NOCOPY NUMBER,
            x_msg_data               OUT NOCOPY VARCHAR2,
            p_vendor_id                IN  NUMBER,
            p_cure_report_id        IN  NUMBER) IS

    l_api_name	       VARCHAR2(30) := 'update_cure_request';

Line: 118

      OKL_CURE_REQ_AMT_PVT.update_cure_request(
	        p_api_version    	=> p_api_version,
	        p_init_msg_list  	=> p_init_msg_list,
	        x_return_status  	=> x_return_status,
	        x_msg_count      	=> x_msg_count,
	        x_msg_data       	=> x_msg_data,
	        p_vendor_id	        => l_vendor_id,
	   	p_cure_report_id	=> l_cure_report_id
		);