DBA Data[Home] [Help]

APPS.FA_XML_REPORT_PKG dependencies on DBMS_LOB

Line 38: l_clob_size := dbms_lob.getlength(p_xml_clob);

34:
35: BEGIN
36:
37:
38: l_clob_size := dbms_lob.getlength(p_xml_clob);
39:
40: IF (l_clob_size = 0) THEN
41: RETURN;
42: END IF;

Line 48: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);

44: l_offset := 1;
45: l_chunk_size := 3000;
46:
47: WHILE (l_clob_size > 0) LOOP
48: l_chunk := dbms_lob.substr (p_xml_clob, l_chunk_size, l_offset);
49: fnd_file.put
50: (which => fnd_file.output
51: ,buff => l_chunk);
52: