APPS.ICX_POR_CTX_DESC dependencies on FND_LANGUAGES

Line 259: vLang FND_LANGUAGES.language_code%TYPE;

255: p_log_type IN VARCHAR2 DEFAULT 'LOADER')
256: IS
257:
258: vCategoryId INTEGER := 0;
259: vLang FND_LANGUAGES.language_code%TYPE;
260: xErrLoc PLS_INTEGER;
261: vItemSourceCursor NUMBER;
262: vSqlString VARCHAR2(4000);
263:

Line 297: FROM fnd_languages

293:
294: BEGIN
295: SELECT language_code
296: INTO vLang
297: FROM fnd_languages
298: WHERE installed_flag = 'B';
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: vLang := 'US';

Line 349: vLang FND_LANGUAGES.language_code%TYPE;

345: p_log_type IN VARCHAR2 DEFAULT 'LOADER')
346: IS
347:
348: vCategoryId INTEGER := 0;
349: vLang FND_LANGUAGES.language_code%TYPE;
350: xErrLoc PLS_INTEGER;
351: vItemSourceCursor NUMBER;
352: vSqlString VARCHAR2(4000);
353:

Line 380: FROM fnd_languages

376: xErrLoc := 101;
377: BEGIN
378: SELECT language_code
379: INTO vLang
380: FROM fnd_languages
381: WHERE installed_flag = 'B';
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN
384: vLang := 'US';