APPS.POR_CONTRACTOR_NOTIFY dependencies on WF_LANGUAGES

Line 308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;

304: L_VENDOR_SITE_CODE PO_VENDOR_SITES.VENDOR_SITE_CODE%TYPE;
305: L_VENDOR_SITE_ID NUMBER;
306: L_VENDOR_CONTACT_ID NUMBER;
307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;
308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;
309: L_ADHOCUSER_TERRITORY WF_LANGUAGES.NLS_TERRITORY%TYPE;
310: L_EMAIL_PERFORMER WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
311: L_EMAIL_ADDRESS VARCHAR2(2000) := NULL;
312: L_DISPLAY_NAME VARCHAR2(80);

Line 309: L_ADHOCUSER_TERRITORY WF_LANGUAGES.NLS_TERRITORY%TYPE;

305: L_VENDOR_SITE_ID NUMBER;
306: L_VENDOR_CONTACT_ID NUMBER;
307: L_VENDOR_SITE_LANG PO_VENDOR_SITES.LANGUAGE%TYPE;
308: L_ADHOCUSER_LANG WF_LANGUAGES.NLS_LANGUAGE%TYPE;
309: L_ADHOCUSER_TERRITORY WF_LANGUAGES.NLS_TERRITORY%TYPE;
310: L_EMAIL_PERFORMER WF_USER_ROLES.ROLE_NAME%TYPE := NULL;
311: L_EMAIL_ADDRESS VARCHAR2(2000) := NULL;
312: L_DISPLAY_NAME VARCHAR2(80);
313: L_PERFORMER_EXISTS NUMBER;

Line 403: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

399:
400: IF L_VENDOR_SITE_LANG IS NOT NULL THEN
401:
402: SELECT WFL.NLS_LANGUAGE, WFL.NLS_TERRITORY INTO L_ADHOCUSER_LANG, L_ADHOCUSER_TERRITORY
403: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV
404: WHERE WFL.CODE = FLV.LANGUAGE_CODE
405: AND FLV.NLS_LANGUAGE = L_VENDOR_SITE_LANG;
406:
407: ELSE

Line 410: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV

406:
407: ELSE
408:
409: SELECT WFL.NLS_LANGUAGE, WFL.NLS_TERRITORY INTO L_ADHOCUSER_LANG, L_ADHOCUSER_TERRITORY
410: FROM WF_LANGUAGES WFL, FND_LANGUAGES_VL FLV
411: WHERE WFL.CODE = FLV.LANGUAGE_CODE
412: AND FLV.INSTALLED_FLAG = 'B';
413:
414: END IF;