DBA Data[Home] [Help]

APPS.PAY_KW_CHEQUE_REPORT dependencies on DUAL

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

613: l_blob_offset pls_integer := 1;
614: begin
615: l_buffer_len := 20000;
616: hr_utility.set_location('Entered Procedure clob to blob',120);
617: select userenv('LANGUAGE') into g_nls_db_char from dual;
618: l_length_clob := dbms_lob.getlength(p_clob);
619: l_offset := 1;
620: while l_length_clob > 0 loop
621: hr_utility.trace('l_length_clob '|| l_length_clob);