APPS.OKL_CURE_REQ_AMT_PVT 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: 18

    l_selected_on_request okl_cure_amounts.selected_on_request%type := null;

Line: 23

   select object_version_number, selected_on_request
   from okl_cure_amounts
   where cure_amount_id = l_cure_amount_id;

Line: 30

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : START');

Line: 60

            l_selected_on_request := null;

Line: 62

	    fetch get_obj_vers_no into l_obj_vers_no, l_selected_on_request;

Line: 66

	    	lp_camv_tbl(i).selected_on_request := 'N';

Line: 68

	        lp_camv_tbl(i).selected_on_request := 'Y';

Line: 85

	      okl_cure_amounts_pub.update_cure_amounts(
	        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_camv_tbl	        => lp_camv_tbl,
	   	x_camv_tbl		=> lx_camv_tbl
		);

Line: 95

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_amounts_pub.update_cure_amounts : '||x_return_status);

Line: 107

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');

Line: 139

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

   select cure_amount_id
   from okl_cure_amounts ca, okl_cure_reports cr
   where ca.show_on_request = 'Y'
   and ca.status = 'CURESINPROGRESS'
   and cr.vendor_id = p_vendor_id
   and ca.selected_on_request = 'Y'
   and cr.cure_report_id = ca.crt_id;

Line: 169

   select object_version_number
   from okl_cure_reports
   where cure_report_id = p_cure_report_id;

Line: 175

   SELECT COUNT(chr_id)
   FROM okl_cure_amounts
   WHERE crt_id = c_cure_report_id;

Line: 183

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : START');

Line: 184

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : p_vendor_id : '|| p_vendor_id);

Line: 185

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : p_cure_report_id : '|| p_cure_report_id);

Line: 224

   okl_cure_reports_pub.update_cure_reports(
	        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_crtv_rec	        => lp_crtv_rec,
	   	x_crtv_rec		=> lx_crtv_rec
		);

Line: 248

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_wf.approve_cure_reports : '|| x_return_status);

Line: 258

    okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');