DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on V$NLS_PARAMETERS

Line 379: -- If NULL then get it from v$nls_parameters table.

375: -- p_nls_numeric_characters :
376: -- NLS setting for the customer site. In general for US customers
377: -- this is '.,', and for EU customers this is ',.'.
378: -- Number converters will use this value to convert existing values.
379: -- If NULL then get it from v$nls_parameters table.
380: --
381: FUNCTION set_nls_numeric_characters
382: (p_nls_numeric_characters IN VARCHAR2 DEFAULT NULL,
383: x_error OUT nocopy VARCHAR2)

Line 391: -- If NULL get from v$nls_parameters table.

387: l_invalid_set VARCHAR2(100) := '<>+-0123456789';
388: l_nls_numeric_characters VARCHAR2(100) := p_nls_numeric_characters;
389: BEGIN
390: --
391: -- If NULL get from v$nls_parameters table.
392: --
393: IF (l_nls_numeric_characters IS NULL) THEN
394: BEGIN
395: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */

Line 397: FROM v$nls_parameters

393: IF (l_nls_numeric_characters IS NULL) THEN
394: BEGIN
395: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
396: value INTO l_nls_numeric_characters
397: FROM v$nls_parameters
398: WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
399: EXCEPTION
400: WHEN OTHERS THEN
401: x_error := set_error(l_func_name,

Line 402: 'SELECT FROM V$NLS_PARAMETERS failed.',

398: WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
399: EXCEPTION
400: WHEN OTHERS THEN
401: x_error := set_error(l_func_name,
402: 'SELECT FROM V$NLS_PARAMETERS failed.',
403: Sqlerrm);
404: RETURN(FALSE);
405: END;
406: END IF;