DBA Data[Home] [Help]

APPS.PAY_SA_CHEQUE_REPORT dependencies on DUAL

Line 594: select userenv('LANGUAGE') into g_nls_db_char from dual;

590: l_blob_offset pls_integer := 1;
591: begin
592: l_buffer_len := 20000;
593: hr_utility.set_location('Entered Procedure clob to blob',120);
594: select userenv('LANGUAGE') into g_nls_db_char from dual;
595: l_length_clob := dbms_lob.getlength(p_clob);
596: l_offset := 1;
597: while l_length_clob > 0 loop
598: hr_utility.trace('l_length_clob '|| l_length_clob);