DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on WF_USERS

Line 718: l_po_email_add_prof WF_USERS.EMAIL_ADDRESS%TYPE;

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';

Line 719: l_po_email_performer WF_USERS.NAME%TYPE;

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

Line 720: l_display_name WF_USERS.DISPLAY_NAME%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
724: l_orgid number;

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

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;

Line 940: from wf_users where name = l_po_email_performer;

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