DBA Data[Home] [Help]

APPS.OKL_LLA_UTIL_PVT dependencies on V$NLS_PARAMETERS

Line 24: FROM v$nls_parameters

20: BEGIN
21: SELECT REPLACE(REPLACE(p_amount_in,SUBSTR(value,2,1)),SUBSTR(value,1,1),'.')
22: -- select replace(replace(p_amount_in,substr(',.',2,1)),substr(',.',1,1),'.')
23: INTO l_amount_out
24: FROM v$nls_parameters
25: WHERE parameter = 'NLS_NUMERIC_CHARACTERS';
26: RETURN(l_amount_out);
27: EXCEPTION
28: WHEN OTHERS THEN