714: l_vendor_site_id number;
715: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
716: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
717: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
718: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
719: l_po_email_performer WF_USERS.NAME%TYPE;
720: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
721: l_performer_exists number;
722: l_notification_preference varchar2(20) := 'MAILHTM2';
715: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
716: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
717: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
718: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
719: l_po_email_performer WF_USERS.NAME%TYPE;
720: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
721: l_performer_exists number;
722: l_notification_preference varchar2(20) := 'MAILHTM2';
723: --Bug13871793
716: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
717: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
718: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;
719: l_po_email_performer WF_USERS.NAME%TYPE;
720: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
721: l_performer_exists number;
722: l_notification_preference varchar2(20) := 'MAILHTM2';
723: --Bug13871793
724: l_orgid number;
928: l_po_email_performer := p_email_address || '.' || l_adhocuser_lang;
929: l_po_email_performer := upper(l_po_email_performer);
930: l_display_name := p_email_address; -- Bug # 3290385
931:
932: l_progress := 'PO_COMMUNICATION_PVT.Start_Email_WF_Process: Verify whether the role exists in wf_users';
933:
934: IF (g_po_wf_debug = 'Y') THEN
935: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
936: END IF;
936: END IF;
937:
938:
939: select count(1) into l_performer_exists
940: from wf_users where name = l_po_email_performer;
941:
942: if (l_performer_exists = 0) then
943:
944: -- Pass in the correct adhocuser language and territory for CreateAdHocUser and SetAdhocUserAttr instead of null