APPS.POR_CONTRACTOR_NOTIFY dependencies on WF_USER_ROLES

Line 73: L_NOTIFIER WF_USER_ROLES.ROLE_NAME%TYPE;

69:
70: L_REQUISITION_SUPPLIER_ID PO_REQUISITION_SUPPLIERS.REQUISITION_SUPPLIER_ID%TYPE;
71: L_REQ_HEADER_ID PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE;
72: L_SUPPLIER_EXISTS VARCHAR2(50);
73: L_NOTIFIER WF_USER_ROLES.ROLE_NAME%TYPE;
74: L_START_DATE PO_REQUISITION_LINES_ALL.ASSIGNMENT_START_DATE%TYPE;
75: L_JOB_DESCRIPTION PO_REQUISITION_LINES_ALL.ITEM_DESCRIPTION%TYPE;
76: L_COMPANY_NAME varchar2(100);
77: L_REQ_NUM_LINE_NUM varchar2(100);

Line 310: L_EMAIL_PERFORMER WF_USER_ROLES.ROLE_NAME%TYPE := NULL;

306: L_VENDOR_CONTACT_ID NUMBER;
307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;
308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;
309: L_ADHOCUSER_TERRITORY WF_LANGUAGES.NLS_TERRITORY%TYPE;
310: L_EMAIL_PERFORMER WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
311: L_EMAIL_ADDRESS VARCHAR2(2000) := NULL;
312: L_DISPLAY_NAME VARCHAR2(80);
313: L_PERFORMER_EXISTS NUMBER;
314: L_NOTIFICATION_PREFERENCE VARCHAR2(20) := 'MAILHTML';