APPS.PAY_NL_REM_REPORT dependencies on DBMS_LOB

Line 73: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);

69:
70: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
71:
72: l_str := ''||EOL;
73: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
74: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
75:
76:
77: IF p_XMLTable.COUNT > 0 THEN

Line 74: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);

70: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
71:
72: l_str := ''||EOL;
73: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
74: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
75:
76:
77: IF p_XMLTable.COUNT > 0 THEN
78: FOR table_counter IN p_XMLTable.FIRST .. p_XMLTable.LAST

Line 89: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);

85: l_xml_element := '<' || p_XMLTable(table_counter).tagname ||
86: '>'|| clean_XML(p_XMLTable(table_counter).tagvalue) ||
87: ''||EOL;
88: END IF;
89: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);
90: END LOOP;
91: ELSE
92: dbms_lob.writeAppend(p_clob, length(l_str), l_str );
93: END IF;

Line 92: dbms_lob.writeAppend(p_clob, length(l_str), l_str );

88: END IF;
89: dbms_lob.writeappend(p_clob, length(l_xml_element), l_xml_element);
90: END LOOP;
91: ELSE
92: dbms_lob.writeAppend(p_clob, length(l_str), l_str );
93: END IF;
94:
95: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
96:

Line 1789: dbms_lob.freeTemporary(l_xml);

1785: write_to_clob(p_xmltable => xXMLtable
1786: ,p_clob => l_xml);
1787:
1788: p_xml := l_xml;
1789: dbms_lob.freeTemporary(l_xml);
1790:
1791:
1792: EXCEPTION
1793: WHEN OTHERS THEN