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 3989: from v$nls_parameters

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

Line 4574: from v$nls_parameters

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

Line 4596: from v$nls_parameters

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

Line 4613: from v$nls_parameters

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

Line 4662: from v$nls_parameters

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

Line 4678: from v$nls_parameters

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