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.PO_COMMUNICATION_PVT dependencies on WF_USERS

Line 616: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

612: l_vendor_site_id number;
613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
615: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
616: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
617: l_po_email_performer WF_USERS.NAME%TYPE;
618: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
619: l_performer_exists number;
620: l_notification_preference varchar2(20) := 'MAILHTML';

Line 617: l_po_email_performer WF_USERS.NAME%TYPE;

613: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
615: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
616: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
617: l_po_email_performer WF_USERS.NAME%TYPE;
618: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
619: l_performer_exists number;
620: l_notification_preference varchar2(20) := 'MAILHTML';
621: l_orgid number;

Line 618: l_display_name WF_USERS.DISPLAY_NAME%TYPE;

614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
615: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
616: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
617: l_po_email_performer WF_USERS.NAME%TYPE;
618: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
619: l_performer_exists number;
620: l_notification_preference varchar2(20) := 'MAILHTML';
621: l_orgid number;
622: --l_legal_name hr_all_organization_units.name%TYPE;

Line 823: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: Verify whether the role exists in wf_users';

819: l_po_email_performer := p_email_address||'.'||l_adhocuser_lang;
820: l_po_email_performer := upper(l_po_email_performer);
821: l_display_name := p_email_address; -- Bug # 3290385
822:
823: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: Verify whether the role exists in wf_users';
824:
825: IF (g_po_wf_debug = 'Y') THEN
826: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey,l_progress);
827: END IF;

Line 831: from wf_users where name = l_po_email_performer;

827: END IF;
828:
829:
830: select count(1) into l_performer_exists
831: from wf_users where name = l_po_email_performer;
832:
833: if (l_performer_exists = 0) then
834:
835: -- Pass in the correct adhocuser language and territory for CreateAdHocUser and SetAdhocUserAttr instead of null