APPS.FND_GLOBAL dependencies on V$NLS_PARAMETERS

Line 1088: v_nls_date_language v$nls_parameters.value%type

1084: function override_nls_date_language(p_nls_date_language varchar2 default null)
1085: return varchar2 is
1086: -- Bug 6718678 and 5032384
1087: -- use nls_language instead of nls_date_language
1088: v_nls_date_language v$nls_parameters.value%type
1089: := nvl(p_nls_date_language,nls_language);
1090: nul_dl boolean := false;
1091: new_dl boolean := false;
1092: new_df boolean := false;

Line 1155: t_nls_date_language v$nls_parameters.value%type

1151:
1152: declare
1153: -- Bug 6718678 and 5032384
1154: -- use nls_language instead of nls_date_language
1155: t_nls_date_language v$nls_parameters.value%type
1156: := nvl(p_nls_date_language,nls_language);
1157: begin
1158: select nls_date_language
1159: into v_nls_date_language

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

1198:
1199: -- See this routine's associated function.
1200: procedure override_nls_date_language
1201: is
1202: tmp v$nls_parameters.value%type;
1203: begin
1204: tmp := override_nls_date_language;
1205: end override_nls_date_language;
1206:

Line 1216: from v$nls_parameters

1212: begin
1213: -- query to ensure the cache is accurate.
1214: -- not using FND_CONST in query to avoid SQL context switch.
1215: for nls in (select *
1216: from v$nls_parameters
1217: where parameter in (
1218: 'NLS_LANGUAGE',
1219: 'NLS_DATE_LANGUAGE',
1220: 'NLS_SORT',

Line 1293: v_nls_language v$nls_parameters.value%type

1289: -- follow this ordering. It was very confusing to me why the parameters
1290: -- to older NLS routines didn't follow a logical order. It doesn't even
1291: -- look like they were ordered based on most highly used.
1292:
1293: v_nls_language v$nls_parameters.value%type
1294: := upper(p_nls_language);
1295: v_nls_date_language v$nls_parameters.value%type
1296: := upper(p_nls_date_language);
1297: v_nls_sort v$nls_parameters.value%type

Line 1295: v_nls_date_language v$nls_parameters.value%type

1291: -- look like they were ordered based on most highly used.
1292:
1293: v_nls_language v$nls_parameters.value%type
1294: := upper(p_nls_language);
1295: v_nls_date_language v$nls_parameters.value%type
1296: := upper(p_nls_date_language);
1297: v_nls_sort v$nls_parameters.value%type
1298: := upper(p_nls_sort);
1299:

Line 1297: v_nls_sort v$nls_parameters.value%type

1293: v_nls_language v$nls_parameters.value%type
1294: := upper(p_nls_language);
1295: v_nls_date_language v$nls_parameters.value%type
1296: := upper(p_nls_date_language);
1297: v_nls_sort v$nls_parameters.value%type
1298: := upper(p_nls_sort);
1299:
1300: v_nls_territory v$nls_parameters.value%type
1301: := upper(p_nls_territory);

Line 1300: v_nls_territory v$nls_parameters.value%type

1296: := upper(p_nls_date_language);
1297: v_nls_sort v$nls_parameters.value%type
1298: := upper(p_nls_sort);
1299:
1300: v_nls_territory v$nls_parameters.value%type
1301: := upper(p_nls_territory);
1302: v_nls_date_format v$nls_parameters.value%type
1303: := upper(p_nls_date_format);
1304: v_nls_numeric_characters v$nls_parameters.value%type

Line 1302: v_nls_date_format v$nls_parameters.value%type

1298: := upper(p_nls_sort);
1299:
1300: v_nls_territory v$nls_parameters.value%type
1301: := upper(p_nls_territory);
1302: v_nls_date_format v$nls_parameters.value%type
1303: := upper(p_nls_date_format);
1304: v_nls_numeric_characters v$nls_parameters.value%type
1305: := p_nls_numeric_characters;
1306:

Line 1304: v_nls_numeric_characters v$nls_parameters.value%type

1300: v_nls_territory v$nls_parameters.value%type
1301: := upper(p_nls_territory);
1302: v_nls_date_format v$nls_parameters.value%type
1303: := upper(p_nls_date_format);
1304: v_nls_numeric_characters v$nls_parameters.value%type
1305: := p_nls_numeric_characters;
1306:
1307: v_nls_characterset v$nls_parameters.value%type
1308: := get(FND_CONST.NLS_CHARACTERSET);

Line 1307: v_nls_characterset v$nls_parameters.value%type

1303: := upper(p_nls_date_format);
1304: v_nls_numeric_characters v$nls_parameters.value%type
1305: := p_nls_numeric_characters;
1306:
1307: v_nls_characterset v$nls_parameters.value%type
1308: := get(FND_CONST.NLS_CHARACTERSET);
1309:
1310: --
1311: -- calls dbms_session.set_nls

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

2063: -- will eliminate trips to the DB.
2064: declare
2065: torg_id number;
2066: mrc_reporting_sob_id number;
2067: icx_language v$nls_parameters.value%type;
2068: tsec_prof number;
2069: tdef_org_id number;
2070:
2071: begin