APPS.ICX_CHANGE_LANGUAGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 81

	SELECT LANGUAGE_CODE,
	       NLS_LANGUAGE,
	       DESCRIPTION,
	       ISO_LANGUAGE,
	       ISO_TERRITORY
	FROM   FND_LANGUAGES_VL
	WHERE  INSTALLED_FLAG in ('I', 'B')
        ORDER BY DESCRIPTION;

Line: 117

             }'); -- updated mputman 1402459

Line: 141

    htp.p('');

Line: 145

		 '" SELECTED> ' || prec.description || ' [' ||
		 prec.ISO_LANGUAGE || '-' || prec.ISO_TERRITORY || ']');

Line: 153

    htp.p('');

      select  language_code
      into    l_language_code
      from    fnd_languages
      where   nls_language = v_language;

      update icx_sessions
      set    nls_language = v_language,
             language_code = l_language_code,
             nls_date_language = p_db_nls_date_language
      where  session_id = icx_sec.g_session_id;