DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SWI dependencies on V$NLS_PARAMETERS

Line 2256: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters

2252: error_log CLOB;
2253: charset VARCHAR2(64);
2254: begin
2255: IF(NOT xmldom.isnull(p_error_doc)) THEN
2256: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2257: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2258: DBMS_LOB.createTemporary(error_log, FALSE);
2259: xmldom.writeToClob(p_error_doc,error_log,charset);
2260: p_error_log:=error_log;

Line 2257: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';

2253: charset VARCHAR2(64);
2254: begin
2255: IF(NOT xmldom.isnull(p_error_doc)) THEN
2256: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2257: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2258: DBMS_LOB.createTemporary(error_log, FALSE);
2259: xmldom.writeToClob(p_error_doc,error_log,charset);
2260: p_error_log:=error_log;
2261: DBMS_LOB.freetemporary(error_log);