APPS.FUN_OPEN_INTERFACE_PKG dependencies on DBMS_LOB

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

1129: l_log_module VARCHAR2(240);
1130:
1131: BEGIN
1132: -- Procedure to write teh xml data from clob to file.
1133: l_clob_size := dbms_lob.getlength(p_xml_clob);
1134:
1135: IF(l_clob_size = 0) THEN
1136: RETURN;
1137: END IF;

Line 1144: l_chunk := dbms_lob.SUBSTR(p_xml_clob, l_chunk_size, l_offset);

1140: l_chunk_size := 3000;
1141:
1142: WHILE(l_clob_size > 0)
1143: LOOP
1144: l_chunk := dbms_lob.SUBSTR(p_xml_clob, l_chunk_size, l_offset);
1145: fnd_file.put(which => fnd_file.OUTPUT, buff => l_chunk);
1146:
1147: l_clob_size := l_clob_size -l_chunk_size;
1148: l_offset := l_offset + l_chunk_size;