DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on V$NLS_PARAMETERS

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

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

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

389: l_invalid_set VARCHAR2(100) := '<>+-0123456789';
390: l_nls_numeric_characters VARCHAR2(100) := p_nls_numeric_characters;
391: BEGIN
392: --
393: -- If NULL get from v$nls_parameters table.
394: --
395: IF (l_nls_numeric_characters IS NULL) THEN
396: BEGIN
397: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */

Line 399: FROM v$nls_parameters

395: IF (l_nls_numeric_characters IS NULL) THEN
396: BEGIN
397: SELECT /* $Header: AFFFUPUB.pls 120.4.12020000.2 2012/11/30 18:19:14 hgeorgi ship $ */
398: value INTO l_nls_numeric_characters
399: FROM v$nls_parameters
400: WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
401: EXCEPTION
402: WHEN OTHERS THEN
403: x_error := set_error(l_func_name,

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

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