APPS.OKL_CURE_VNDR_RFND_PVT SQL Statements

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

Line: 34

     select object_version_number
     from OKL_CURE_REFUND_HEADERS_B
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 39

     select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
     from OKL_CURE_REFUNDS
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 92

                lp_crsv_tbl(i).status := 'SELECTED';

Line: 100

           OKL_cure_refunds_pub.insert_cure_refunds(
	        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_crfv_tbl	        => lp_crfv_tbl,
	   	x_crfv_tbl		=> lx_crfv_tbl
		);

Line: 135

            OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
	        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_chdv_rec	        => lp_chdv_rec,
	   	x_chdv_rec		=> lx_chdv_rec
		);

Line: 153

            OKL_cure_rfnd_stage_pub.update_cure_refunds(
	        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_crsv_tbl	        => lp_crsv_tbl,
	   	x_crsv_tbl		=> lx_crsv_tbl
		);

Line: 204

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: 234

     select object_version_number
     from OKL_CURE_REFUND_HEADERS_B
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 239

     select sum(received_amount),sum(offset_amount), sum(disbursement_amount)
     from OKL_CURE_REFUNDS
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 293

                lp_crsv_tbl(i).status := 'SELECTED';

Line: 301

           OKL_cure_refunds_pub.update_cure_refunds(
	        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_crfv_tbl	        => lp_crfv_tbl,
	   	x_crfv_tbl		=> lx_crfv_tbl
		);

Line: 336

            OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
	        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_chdv_rec	        => lp_chdv_rec,
	   	x_chdv_rec		=> lx_chdv_rec
		);

Line: 354

            OKL_cure_rfnd_stage_pub.update_cure_refunds(
	        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_crsv_tbl	        => lp_crsv_tbl,
	   	x_crsv_tbl		=> lx_crsv_tbl
		);

Line: 404

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: 435

     select object_version_number
     from OKL_CURE_REFUND_HEADERS_B
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 440

     select sum(received_amount),sum(offset_amount)
     from OKL_CURE_REFUNDS
     where cure_refund_header_id = l_cure_refund_header_id;

Line: 491

           OKL_cure_refunds_pub.delete_cure_refunds(
	        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_crfv_tbl	        => lp_crfv_tbl
		);

Line: 524

            OKL_cure_rfnd_hdr_pub.update_cure_rfnd_hdr(
	        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_chdv_rec	        => lp_chdv_rec,
	   	x_chdv_rec		=> lx_chdv_rec
		);

Line: 542

            OKL_cure_rfnd_stage_pub.update_cure_refunds(
	        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_crsv_tbl	        => lp_crsv_tbl,
	   	x_crsv_tbl		=> lx_crsv_tbl
		);