APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_LANGUAGES

Line 4588: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

4584: l_vendor_site_code varchar2(15);
4585: l_vendor_site_id number;
4586: --EMAILPO FPH START--
4587: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
4588: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;

Line 4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;

4585: l_vendor_site_id number;
4586: --EMAILPO FPH START--
4587: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
4588: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */
4592: l_po_email_performer WF_USERS.NAME%TYPE;
4593: l_po_email_add WF_USERS.EMAIL_ADDRESS%TYPE;

Line 4701: FROM wf_languages wfl, fnd_languages_vl flv

4697:
4698: --EMAILPO FPH START--
4699: IF l_vendor_site_lang is NOT NULL then
4700: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
4701: FROM wf_languages wfl, fnd_languages_vl flv
4702: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
4703: ELSE
4704: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
4705: FROM wf_languages wfl, fnd_languages_vl flv

Line 4705: FROM wf_languages wfl, fnd_languages_vl flv

4701: FROM wf_languages wfl, fnd_languages_vl flv
4702: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
4703: ELSE
4704: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
4705: FROM wf_languages wfl, fnd_languages_vl flv
4706: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
4707: END IF;
4708: --EMAILPO FPH END--
4709: