APPS.OKL_CURE_WF dependencies on OKL_CRT_PVT

Line 294: lp_crtv_rec okl_crt_pvt.crtv_rec_type;

290: l_message VARCHAR2(32627);
291: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_CURE_REPORTS';
292: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
293: || l_api_name;
294: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
295: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
296:
297: cursor c_get_obj_ver(p_report_id IN NUMBER) is
298: select object_version_number

Line 295: lx_crtv_rec okl_crt_pvt.crtv_rec_type;

291: l_api_name CONSTANT VARCHAR2(50) := 'APPROVE_CURE_REPORTS';
292: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
293: || l_api_name;
294: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
295: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
296:
297: cursor c_get_obj_ver(p_report_id IN NUMBER) is
298: select object_version_number
299: from okl_cure_reports

Line 450: lp_crtv_rec okl_crt_pvt.crtv_rec_type;

446: l_msg_data VARCHAR2(32627);
447: l_message VARCHAR2(32627);
448:
449: l_cure_report_id VARCHAR2(32627);
450: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
451: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
452:
453: cursor c_get_obj_ver(p_report_id IN NUMBER) is
454: select object_version_number

Line 451: lx_crtv_rec okl_crt_pvt.crtv_rec_type;

447: l_message VARCHAR2(32627);
448:
449: l_cure_report_id VARCHAR2(32627);
450: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
451: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
452:
453: cursor c_get_obj_ver(p_report_id IN NUMBER) is
454: select object_version_number
455: from okl_cure_reports

Line 553: lp_crtv_rec okl_crt_pvt.crtv_rec_type;

549: l_msg_data VARCHAR2(32627);
550: l_message VARCHAR2(32627);
551:
552: l_cure_report_id VARCHAR2(32627);
553: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
554: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
555: cursor c_get_obj_ver(p_report_id IN NUMBER) is
556: select object_version_number
557: from okl_cure_reports

Line 554: lx_crtv_rec okl_crt_pvt.crtv_rec_type;

550: l_message VARCHAR2(32627);
551:
552: l_cure_report_id VARCHAR2(32627);
553: lp_crtv_rec okl_crt_pvt.crtv_rec_type;
554: lx_crtv_rec okl_crt_pvt.crtv_rec_type;
555: cursor c_get_obj_ver(p_report_id IN NUMBER) is
556: select object_version_number
557: from okl_cure_reports
558: where cure_report_id =p_report_id;