eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on WF_USERS

Line 5940: l_po_email_performer WF_USERS.NAME%TYPE;

5936: l_workflow_process po_document_types.wf_approval_process%type;
5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;
5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
5943: l_performer_exists number;
5944: l_user_exists NUMBER;

Line 5941: l_email_address WF_USERS.NAME%TYPE;

5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;
5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
5943: l_performer_exists number;
5944: l_user_exists NUMBER;
5945: l_notification_preference varchar2(20) := 'MAILHTM2';

Line 5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;

5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;
5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
5943: l_performer_exists number;
5944: l_user_exists NUMBER;
5945: l_notification_preference varchar2(20) := 'MAILHTM2';
5946: l_orgid number;

Line 5964: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: Verify whether the role exists in wf_users';

5960: SELECT segment1 into l_segment1
5961: from po_requisition_headers_all
5962: where requisition_header_id = p_document_id;
5963:
5964: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: Verify whether the role exists in wf_users';
5965:
5966: IF (g_po_wf_debug = 'Y') THEN
5967: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
5968: END IF;

Line 5971: from wf_users where ORIG_SYSTEM_ID = p_to_user_id;

5967: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
5968: END IF;
5969:
5970: select count(1) into l_user_exists
5971: from wf_users where ORIG_SYSTEM_ID = p_to_user_id;
5972:
5973: if (l_user_exists = 0) THEN
5974: BEGIN
5975: SELECT wfl.nls_language,

Line 5993: from wf_users where name = Upper(l_po_email_performer);

5989:
5990: l_po_email_performer := Upper(l_po_email_performer);
5991:
5992: select count(1) into l_performer_exists
5993: from wf_users where name = Upper(l_po_email_performer);
5994:
5995: IF l_performer_exists = 0 then
5996: WF_DIRECTORY.CreateAdHocUser(l_po_email_performer, l_display_name, l_adhocuser_lang, l_adhocuser_territory, null, l_notification_preference, l_po_email_performer, null, 'ACTIVE', null);
5997: END IF;

Line 6006: from wf_users where ORIG_SYSTEM_ID = p_to_user_id AND ROWNUM = 1;

6002: RETURN;
6003: END;
6004: ELSE
6005: SELECT name into l_po_email_performer
6006: from wf_users where ORIG_SYSTEM_ID = p_to_user_id AND ROWNUM = 1;
6007:
6008: l_po_email_performer := Upper(l_po_email_performer);
6009: end if;
6010: