APPS.PO_COMMUNICATION_PVT dependencies on WF_LANGUAGES

Line 614: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

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

Line 615: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;

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

Line 808: FROM wf_languages wfl, fnd_languages_vl flv

804:
805: IF l_vendor_site_lang is NOT NULL then
806:
807: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
808: FROM wf_languages wfl, fnd_languages_vl flv
809: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
810:
811: ELSE
812:

Line 814: FROM wf_languages wfl, fnd_languages_vl flv

810:
811: ELSE
812:
813: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
814: FROM wf_languages wfl, fnd_languages_vl flv
815: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
816:
817: END IF;
818: