DBA Data[Home] [Help]

APPS.OKL_CURE_VNDR_RFND_PUB SQL Statements

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

Line: 84

PROCEDURE update_cure_refund(
            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_rfnd_tbl          IN  cure_rfnd_tbl_type,
            x_cure_rfnd_tbl          OUT NOCOPY cure_rfnd_tbl_type
) IS

    l_api_name	       VARCHAR2(30) := 'update_cure_refund';
Line: 116

     OKL_CURE_VNDR_RFND_PVT.update_cure_refund(
	        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_rfnd_tbl	        => p_cure_rfnd_tbl,
	   	x_cure_rfnd_tbl		=> x_cure_rfnd_tbl
		);
Line: 164

PROCEDURE delete_cure_refund(
            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_rfnd_tbl         IN  cure_rfnd_tbl_type
) IS

    l_api_name	       VARCHAR2(30) := 'delete_cure_refund';
Line: 194

     OKL_CURE_VNDR_RFND_PVT.delete_cure_refund(
	        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_rfnd_tbl	        => p_cure_rfnd_tbl
		);