APPS.POR_AME_REQ_WF_PVT dependencies on WF_ROLES

Line 1107: ( SELECT name FROM wf_roles WHERE orig_system = l_forwardee.orig_system

1103: --CLM Apprvl
1104: IF p_response IN ('FORWARD', 'APPROVE AND FORWARD') THEN
1105: IF l_forwardee.name IS NULL THEN
1106: SELECT name into l_forwardee.name FROM
1107: ( SELECT name FROM wf_roles WHERE orig_system = l_forwardee.orig_system
1108: and orig_system_id = l_forwardee.orig_system_id
1109: order by start_date)
1110: WHERE rownum = 1;
1111: END IF;

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

1111: END IF;
1112: ELSE
1113: IF l_current_approver.name IS NULL THEN
1114: SELECT name into l_current_approver.name FROM
1115: ( SELECT name FROM wf_roles WHERE orig_system = l_current_approver.orig_system
1116: and orig_system_id = l_current_approver.orig_system_id
1117: order by start_date)
1118: WHERE rownum = 1;
1119: END IF;

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

1119: END IF;
1120: END IF;
1121:
1122: IF l_current_approver.name IS NULL THEN
1123: raise_application_error(-20001, 'Record Not Found in WF_ROLES for the orig_system_id :' ||
1124: l_current_approver.orig_system_id || ' -- orig_system :' ||
1125: l_current_approver.orig_system );
1126: END IF;
1127: