APPS.FND_GLOBAL dependencies on V$NLS_PARAMETERS

Line 1211: v_nls_date_language v$nls_parameters.value%type

1207: function override_nls_date_language(p_nls_date_language varchar2 default null)
1208: return varchar2 is
1209: -- Bug 6718678 and 5032384
1210: -- use nls_language instead of nls_date_language
1211: v_nls_date_language v$nls_parameters.value%type
1212: := nvl(p_nls_date_language,nls_language);
1213: nul_dl boolean := false;
1214: new_dl boolean := false;
1215: new_df boolean := false;

Line 1276: t_nls_date_language v$nls_parameters.value%type

1272:
1273: declare
1274: -- Bug 6718678 and 5032384
1275: -- use nls_language instead of nls_date_language
1276: t_nls_date_language v$nls_parameters.value%type
1277: := nvl(p_nls_date_language,nls_language);
1278: begin
1279: /*
1280: select nls_date_language

Line 1361: tmp v$nls_parameters.value%type;

1357:
1358: -- See this routine's associated function.
1359: procedure override_nls_date_language
1360: is
1361: tmp v$nls_parameters.value%type;
1362: begin
1363: tmp := override_nls_date_language;
1364: end override_nls_date_language;
1365:

Line 1374: from v$nls_parameters

1370: begin
1371: -- query to ensure the cache is accurate.
1372: -- not using FND_CONST in query to avoid SQL context switch.
1373: for nls in (select *
1374: from v$nls_parameters
1375: where parameter in (
1376: 'NLS_LANGUAGE',
1377: 'NLS_DATE_LANGUAGE',
1378: 'NLS_SORT',

Line 1451: v_nls_language v$nls_parameters.value%type

1447: -- follow this ordering. It was very confusing to me why the parameters
1448: -- to older NLS routines didn't follow a logical order. It doesn't even
1449: -- look like they were ordered based on most highly used.
1450:
1451: v_nls_language v$nls_parameters.value%type
1452: := upper(p_nls_language);
1453: v_nls_date_language v$nls_parameters.value%type
1454: := upper(p_nls_date_language);
1455: v_nls_sort v$nls_parameters.value%type

Line 1453: v_nls_date_language v$nls_parameters.value%type

1449: -- look like they were ordered based on most highly used.
1450:
1451: v_nls_language v$nls_parameters.value%type
1452: := upper(p_nls_language);
1453: v_nls_date_language v$nls_parameters.value%type
1454: := upper(p_nls_date_language);
1455: v_nls_sort v$nls_parameters.value%type
1456: := upper(p_nls_sort);
1457:

Line 1455: v_nls_sort v$nls_parameters.value%type

1451: v_nls_language v$nls_parameters.value%type
1452: := upper(p_nls_language);
1453: v_nls_date_language v$nls_parameters.value%type
1454: := upper(p_nls_date_language);
1455: v_nls_sort v$nls_parameters.value%type
1456: := upper(p_nls_sort);
1457:
1458: v_nls_territory v$nls_parameters.value%type
1459: := upper(p_nls_territory);

Line 1458: v_nls_territory v$nls_parameters.value%type

1454: := upper(p_nls_date_language);
1455: v_nls_sort v$nls_parameters.value%type
1456: := upper(p_nls_sort);
1457:
1458: v_nls_territory v$nls_parameters.value%type
1459: := upper(p_nls_territory);
1460: v_nls_date_format v$nls_parameters.value%type
1461: := upper(p_nls_date_format);
1462: v_nls_numeric_characters v$nls_parameters.value%type

Line 1460: v_nls_date_format v$nls_parameters.value%type

1456: := upper(p_nls_sort);
1457:
1458: v_nls_territory v$nls_parameters.value%type
1459: := upper(p_nls_territory);
1460: v_nls_date_format v$nls_parameters.value%type
1461: := upper(p_nls_date_format);
1462: v_nls_numeric_characters v$nls_parameters.value%type
1463: := p_nls_numeric_characters;
1464:

Line 1462: v_nls_numeric_characters v$nls_parameters.value%type

1458: v_nls_territory v$nls_parameters.value%type
1459: := upper(p_nls_territory);
1460: v_nls_date_format v$nls_parameters.value%type
1461: := upper(p_nls_date_format);
1462: v_nls_numeric_characters v$nls_parameters.value%type
1463: := p_nls_numeric_characters;
1464:
1465: v_nls_characterset v$nls_parameters.value%type
1466: := get(FND_CONST.NLS_CHARACTERSET);

Line 1465: v_nls_characterset v$nls_parameters.value%type

1461: := upper(p_nls_date_format);
1462: v_nls_numeric_characters v$nls_parameters.value%type
1463: := p_nls_numeric_characters;
1464:
1465: v_nls_characterset v$nls_parameters.value%type
1466: := get(FND_CONST.NLS_CHARACTERSET);
1467:
1468: --
1469: -- calls dbms_session.set_nls

Line 2309: icx_language v$nls_parameters.value%type;

2305: -- This, according to ATGPERF, results in a performance improvement since it
2306: -- will eliminate trips to the DB.
2307: declare
2308: mrc_reporting_sob_id number;
2309: icx_language v$nls_parameters.value%type;
2310: begin
2311:
2312: if fnd_release.major_version < 12 then
2313: -- MRC is no longer used beyond 11i.