eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CURE_WF dependencies on OKL_CURE_REPORTS

Line 143: from okl_cure_reports crt,

139:
140: cursor c_get_ref_details (p_cure_report_id IN NUMBER)
141: is select crt.report_number
142: ,pov.vendor_name
143: from okl_cure_reports crt,
144: po_vendors pov
145: where crt.vendor_id =pov.vendor_id
146: and crt.cure_report_id =p_cure_report_id;
147:

Line 148: l_report_number okl_cure_reports.report_number%TYPE;

144: po_vendors pov
145: where crt.vendor_id =pov.vendor_id
146: and crt.cure_report_id =p_cure_report_id;
147:
148: l_report_number okl_cure_reports.report_number%TYPE;
149:
150: l_vendor_name po_vendors.vendor_name%TYPE;
151: l_notification_agent varchar2(100);
152:

Line 299: from okl_cure_reports

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
300: where cure_report_id =p_report_id;
301:
302:
303: BEGIN

Line 342: p_object => 'RECORD IN OKL_CURE_REPORTS ',

338: --set error message,so this will be prefixed before the
339: --actual message, so it makes more sense than displaying an
340: -- OKL message.
341: AddfailMsg(
342: p_object => 'RECORD IN OKL_CURE_REPORTS ',
343: p_operation => 'UPDATE' );
344:
345: lp_crtv_rec.cure_report_id :=p_report_id;
346: lp_crtv_rec.approval_status :='PENDING';

Line 352: OKL_cure_reports_pub.update_cure_reports(

348: OPEN c_get_obj_ver(p_report_id);
349: FETCH c_get_obj_ver INTO lp_crtv_rec.object_version_number;
350: CLOSE c_get_obj_ver;
351:
352: OKL_cure_reports_pub.update_cure_reports(
353: p_api_version => 1.0
354: ,p_init_msg_list => 'F'
355: ,x_return_status => l_return_status
356: ,x_msg_count => l_msg_count

Line 361: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

357: ,x_msg_data => l_msg_data
358: ,p_crtv_rec => lp_crtv_rec
359: ,x_crtv_rec => lx_crtv_rec);
360:
361: okl_debug_pub.logmessage('OKL_CURE_WF: invoke_report_wf : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
362:
363: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
364: Get_Messages (l_msg_count,l_message);
365: IF PG_DEBUG < 11 THEN

Line 455: from okl_cure_reports

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
456: where cure_report_id =p_report_id;
457:
458:
459: BEGIN

Line 486: OKL_cure_reports_pub.update_cure_reports(

482: OPEN c_get_obj_ver(l_cure_report_id);
483: FETCH c_get_obj_ver INTO lp_crtv_rec.object_version_number;
484: CLOSE c_get_obj_ver;
485:
486: OKL_cure_reports_pub.update_cure_reports(
487: p_api_version => 1.0
488: ,p_init_msg_list => 'F'
489: ,x_return_status => l_return_status
490: ,x_msg_count => l_msg_count

Line 495: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

491: ,x_msg_data => l_msg_data
492: ,p_crtv_rec => lp_crtv_rec
493: ,x_crtv_rec => lx_crtv_rec);
494:
495: okl_debug_pub.logmessage('OKL_CURE_WF: set_approval_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
496:
497: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
498: Get_Messages (l_msg_count,l_message);
499: IF PG_DEBUG < 11 THEN

Line 557: from okl_cure_reports

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;
559:
560:
561:

Line 590: OKL_cure_reports_pub.update_cure_reports(

586: OPEN c_get_obj_ver(l_cure_report_id);
587: FETCH c_get_obj_ver INTO lp_crtv_rec.object_version_number;
588: CLOSE c_get_obj_ver;
589:
590: OKL_cure_reports_pub.update_cure_reports(
591: p_api_version => 1.0
592: ,p_init_msg_list => 'F'
593: ,x_return_status => l_return_status
594: ,x_msg_count => l_msg_count

Line 599: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);

595: ,x_msg_data => l_msg_data
596: ,p_crtv_rec => lp_crtv_rec
597: ,x_crtv_rec => lx_crtv_rec);
598:
599: okl_debug_pub.logmessage('OKL_CURE_WF: set_reject_status : OKL_cure_reports_pub.update_cure_reports : '||l_return_status);
600:
601: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
602: Get_Messages (l_msg_count,l_message);
603: IF PG_DEBUG < 11 THEN