APPS.POR_AME_REQ_WF_PVT dependencies on WF_ROLES

Line 728: ( SELECT name FROM wf_roles WHERE orig_system = l_current_approver.orig_system

724: -- This is a mandatory field. If we do not pass this value to AME, we will get invalid parameter exception.
725: -- bug# 4936145
726: IF l_current_approver.name IS NULL THEN
727: SELECT name into l_current_approver.name FROM
728: ( SELECT name FROM wf_roles WHERE orig_system = l_current_approver.orig_system
729: and orig_system_id = l_current_approver.orig_system_id
730: order by start_date
731: )
732: WHERE rownum = 1;

Line 736: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||

732: WHERE rownum = 1;
733: END IF;
734:
735: IF l_current_approver.name IS NULL THEN
736: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
737: l_current_approver.orig_system_id || ' -- orig_system :' || l_current_approver.orig_system );
738: END IF;
739:
740: -- Update the Approval status with the response from the approver.