APPS.OKL_CURE_REQ_AMT_PVT dependencies on OKL_CURE_AMOUNTS

Line 18: l_selected_on_request okl_cure_amounts.selected_on_request%type := null;

14: l_api_name VARCHAR2(30) := 'update_cure_request';
15: l_api_version CONSTANT NUMBER := 1.0;
16: i NUMBER;
17: l_obj_vers_no NUMBER;
18: l_selected_on_request okl_cure_amounts.selected_on_request%type := null;
19: lp_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
20: lx_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
21:
22: Cursor get_obj_vers_no(l_cure_amount_id NUMBER) is

Line 19: lp_camv_tbl okl_cure_amounts_pub.camv_tbl_type;

15: l_api_version CONSTANT NUMBER := 1.0;
16: i NUMBER;
17: l_obj_vers_no NUMBER;
18: l_selected_on_request okl_cure_amounts.selected_on_request%type := null;
19: lp_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
20: lx_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
21:
22: Cursor get_obj_vers_no(l_cure_amount_id NUMBER) is
23: select object_version_number, selected_on_request

Line 20: lx_camv_tbl okl_cure_amounts_pub.camv_tbl_type;

16: i NUMBER;
17: l_obj_vers_no NUMBER;
18: l_selected_on_request okl_cure_amounts.selected_on_request%type := null;
19: lp_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
20: lx_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
21:
22: Cursor get_obj_vers_no(l_cure_amount_id NUMBER) is
23: select object_version_number, selected_on_request
24: from okl_cure_amounts

Line 24: from okl_cure_amounts

20: lx_camv_tbl okl_cure_amounts_pub.camv_tbl_type;
21:
22: Cursor get_obj_vers_no(l_cure_amount_id NUMBER) is
23: select object_version_number, selected_on_request
24: from okl_cure_amounts
25: where cure_amount_id = l_cure_amount_id;
26:
27:
28: BEGIN

Line 85: okl_cure_amounts_pub.update_cure_amounts(

81: EXIT WHEN (i = p_cure_req_tbl.LAST);
82: i := p_cure_req_tbl.NEXT(i);
83: END LOOP;
84:
85: okl_cure_amounts_pub.update_cure_amounts(
86: p_api_version => p_api_version,
87: p_init_msg_list => p_init_msg_list,
88: x_return_status => x_return_status,
89: x_msg_count => x_msg_count,

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

91: p_camv_tbl => lp_camv_tbl,
92: x_camv_tbl => lx_camv_tbl
93: );
94:
95: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_amounts_pub.update_cure_amounts : '||x_return_status);
96:
97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

Line 159: from okl_cure_amounts ca, okl_cure_reports cr

155: lx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
156:
157: Cursor upd_cure_amts_csr is
158: select cure_amount_id
159: from okl_cure_amounts ca, okl_cure_reports cr
160: where ca.show_on_request = 'Y'
161: and ca.status = 'CURESINPROGRESS'
162: and cr.vendor_id = p_vendor_id
163: and ca.selected_on_request = 'Y'

Line 176: FROM okl_cure_amounts

172:
173: --dkagrawa added following cursor for OA Migration
174: CURSOR c_get_contract_count(c_cure_report_id IN NUMBER) IS
175: SELECT COUNT(chr_id)
176: FROM okl_cure_amounts
177: WHERE crt_id = c_cure_report_id;
178:
179: l_count NUMBER;
180: