DBA Data[Home] [Help]

APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_ROLES

Line 183: l_more_origsys wf_roles.orig_system%TYPE;

179: /* begin bug 3090563
180: * notification enhancement to support more info requested
181: */
182: l_more_info_role wf_notifications.more_info_role%TYPE;
183: l_more_origsys wf_roles.orig_system%TYPE;
184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
185: /* end bug 3090563 */
186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action
187: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */

Line 184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;

180: * notification enhancement to support more info requested
181: */
182: l_more_info_role wf_notifications.more_info_role%TYPE;
183: l_more_origsys wf_roles.orig_system%TYPE;
184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
185: /* end bug 3090563 */
186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action
187: /* bug 1817306 new cursor c_responderid is defined to replace c_responder */
188: CURSOR c_responderid(p_responder VARCHAR2) IS

Line 296: FROM WF_ROLES WFU

292:
293: BEGIN
294: SELECT WFU.ORIG_SYSTEM_ID
295: INTO l_original_recipient_id
296: FROM WF_ROLES WFU
297: WHERE WFU.NAME = l_original_recipient
298: AND WFU.ORIG_SYSTEM NOT IN ('POS', 'ENG_LIST', 'CUST_CONT');
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN