APPS.POR_AME_RCO_WF_PVT dependencies on WF_ROLES

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

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

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

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