APPS.OKL_CURE_REQ_AMT_PVT dependencies on OKL_CURE_REPORTS

Line 154: lp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

150: i NUMBER := 0;
151: l_cure_amt_id NUMBER;
152: l_obj_vers_no NUMBER;
153:
154: lp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
155: lx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
156:
157: Cursor upd_cure_amts_csr is
158: select cure_amount_id

Line 155: lx_crtv_rec okl_cure_reports_pub.crtv_rec_type;

151: l_cure_amt_id NUMBER;
152: l_obj_vers_no NUMBER;
153:
154: lp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
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

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 170: from okl_cure_reports

166: p_cure_req_tbl cure_req_tbl_type;
167:
168: Cursor get_obj_vers_no is
169: select object_version_number
170: from okl_cure_reports
171: where cure_report_id = p_cure_report_id;
172:
173: --dkagrawa added following cursor for OA Migration
174: CURSOR c_get_contract_count(c_cure_report_id IN NUMBER) IS

Line 224: okl_cure_reports_pub.update_cure_reports(

220: close get_obj_vers_no;
221:
222: lp_crtv_rec.object_version_number := l_obj_vers_no;
223:
224: okl_cure_reports_pub.update_cure_reports(
225: p_api_version => p_api_version,
226: p_init_msg_list => p_init_msg_list,
227: x_return_status => x_return_status,
228: x_msg_count => x_msg_count,