APPS.POR_AME_RCO_WF_PVT dependencies on WF_ROLES

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

637: -- This is a mandatory field. If we do not pass this value to AME, we will get invalid parameter exception.
638: -- bug# 4936145
639: IF l_current_approver.name IS NULL THEN
640: SELECT name into l_current_approver.name FROM
641: ( SELECT name FROM wf_roles WHERE orig_system = l_current_approver.orig_system
642: and orig_system_id = l_current_approver.orig_system_id
643: order by start_date
644: )
645: WHERE rownum = 1;

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

645: WHERE rownum = 1;
646: END IF;
647:
648: IF l_current_approver.name IS NULL THEN
649: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
650: l_current_approver.orig_system_id || ' -- orig_system :' || l_current_approver.orig_system );
651: END IF;
652:
653: -- Update the Approval status with the response from the approver.