APPS.PO_COMMUNICATION_PVT dependencies on WF_LANGUAGES

Line 716: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

712: l_workflow_process po_document_types.wf_approval_process%type;
713: l_vendor_site_code varchar2(15);
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;

Line 717: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;

713: l_vendor_site_code varchar2(15);
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;

Line 917: FROM wf_languages wfl, fnd_languages_vl flv

913:
914: IF l_vendor_site_lang is NOT NULL then
915:
916: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
917: FROM wf_languages wfl, fnd_languages_vl flv
918: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
919:
920: ELSE
921:

Line 923: FROM wf_languages wfl, fnd_languages_vl flv

919:
920: ELSE
921:
922: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
923: FROM wf_languages wfl, fnd_languages_vl flv
924: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
925:
926: END IF;
927: