APPS.ICX_SEC dependencies on V$NLS_PARAMETERS

Line 1319: from v$nls_parameters

1315:
1316: /*
1317: cursor nls is
1318: select parameter, value
1319: from v$nls_parameters
1320: where parameter in ('NLS_LANGUAGE','NLS_DATE_LANGUAGE','NLS_SORT',
1321: 'NLS_TERRITORY','NLS_DATE_FORMAT',
1322: 'NLS_NUMERIC_CHARACTERS')
1323: order by parameter;

Line 3067: from v$nls_parameters

3063: then
3064: /*
3065: select value
3066: into n_id
3067: from v$nls_parameters
3068: where parameter = 'NLS_DATE_FORMAT';
3069: */
3070:
3071: n_id:=getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527

Line 3987: from v$nls_parameters

3983: BEGIN
3984:
3985: select upper(value)
3986: into requested_val
3987: from v$nls_parameters
3988: where parameter = p_param;
3989:
3990: RETURN requested_val;
3991:

Line 4578: from v$nls_parameters

4574:
4575: /*
4576: select upper(value)
4577: into l_language
4578: from v$nls_parameters
4579: where parameter = 'NLS_LANGUAGE';
4580: */ -- removed select 1574527 mputman
4581:
4582: l_language:=getNLS_PARAMETER('NLS_LANGUAGE'); -- replaces above select mputman 1574527

Line 4600: from v$nls_parameters

4596: if l_nls_sort is null then
4597: /*
4598: select upper(value)
4599: into l_nls_sort
4600: from v$nls_parameters
4601: where parameter = 'NLS_SORT';
4602: */
4603: l_nls_sort:=getNLS_PARAMETER('NLS_SORT'); -- replaces above select mputman 1574527
4604:

Line 4617: from v$nls_parameters

4613: if l_date_format is null then
4614: /*
4615: select upper(value)
4616: into l_date_format
4617: from v$nls_parameters
4618: where parameter = 'NLS_DATE_FORMAT';
4619: */
4620: l_date_format:=getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
4621:

Line 4666: from v$nls_parameters

4662: if l_numeric_characters is null then
4663: /*
4664: select upper(value)
4665: into l_numeric_characters
4666: from v$nls_parameters
4667: where parameter = 'NLS_NUMERIC_CHARACTERS';
4668: */
4669: l_numeric_characters:=getNLS_PARAMETER('NLS_NUMERIC_CHARACTERS'); -- replaces above select mputman 1574527
4670:

Line 4682: from v$nls_parameters

4678: if l_nls_territory is null then
4679: /*
4680: select upper(value)
4681: into l_nls_territory
4682: from v$nls_parameters
4683: where parameter = 'NLS_TERRITORY';
4684: */
4685: l_nls_territory:=getNLS_PARAMETER('NLS_TERRITORY'); -- replaces above select mputman 1574527
4686: