APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_LANGUAGES

Line 3882: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

3878: l_vendor_site_code VARCHAR2(15);
3879: l_vendor_site_id NUMBER;
3880: --EMAILPO FPH START--
3881: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
3882: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;

Line 3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;

3879: l_vendor_site_id NUMBER;
3880: --EMAILPO FPH START--
3881: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
3882: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
3883: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
3884: --EMAILPO FPH START--
3885: /* Bug 2989951 Increased the width of the following variables */
3886: l_po_email_performer WF_USERS.NAME%TYPE;
3887: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;

Line 3901: l_lang_code wf_languages.code%TYPE;

3897: l_note fnd_new_messages.message_text%TYPE;
3898: /* End Bug 9108606 */
3899: /*Bug 9283386*/
3900: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
3901: l_lang_code wf_languages.code%TYPE;
3902: /*Bug 9283386*/
3903:
3904: --ER 5688144: retrieve vendor name for display name of email address
3905: l_vendor_name po_vendors.vendor_name%TYPE;

Line 3981: FROM wf_languages wfl,

3977: wfl.code
3978: INTO l_adhocuser_lang,
3979: l_adhocuser_territory,
3980: l_lang_code
3981: FROM wf_languages wfl,
3982: fnd_languages_vl flv
3983: WHERE wfl.code = flv.language_code
3984: AND flv.nls_language = l_vendor_site_lang;
3985: ELSE

Line 3992: FROM wf_languages wfl,

3988: wfl.code
3989: INTO l_adhocuser_lang,
3990: l_adhocuser_territory,
3991: l_lang_code
3992: FROM wf_languages wfl,
3993: fnd_languages_vl flv
3994: WHERE wfl.code = flv.language_code
3995: AND flv.installed_flag = 'B';
3996: END IF;