APPS.AMS_IMPORT_XML_PVT dependencies on DBMS_LOB

Line 1621: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);

1617: );
1618:
1619: END IF;
1620:
1621: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);
1622: COMMIT WORK;
1623:
1624: EXCEPTION
1625: WHEN FND_API.G_EXC_ERROR THEN

Line 1626: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);

1622: COMMIT WORK;
1623:
1624: EXCEPTION
1625: WHEN FND_API.G_EXC_ERROR THEN
1626: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);
1627: ROLLBACK TO Store_XML_Util;
1628: Retcode := FND_API.G_RET_STS_ERROR;
1629: WHEN OTHERS THEN
1630: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);

Line 1630: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);

1626: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);
1627: ROLLBACK TO Store_XML_Util;
1628: Retcode := FND_API.G_RET_STS_ERROR;
1629: WHEN OTHERS THEN
1630: --DBMS_LOB.FREETEMPORARY (l_xml_doc_content);
1631: ROLLBACK TO Store_XML_Util;
1632: Errbuf := 'Unexpected error in '
1633: || L_FULL_NAME || ': '|| SQLERRM;
1634: Retcode := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1698: l_doc_length := DBMS_LOB.GETLENGTH (l_xml_clob.CONTENT_TEXT);

1694: l_profile_length := TO_NUMBER (l_client_file_size);
1695: OPEN c_xml_doc (p_import_list_header_id);
1696: FETCH c_xml_doc INTO l_xml_clob;
1697: IF c_xml_doc%FOUND THEN
1698: l_doc_length := DBMS_LOB.GETLENGTH (l_xml_clob.CONTENT_TEXT);
1699: IF l_doc_length >= l_profile_length THEN
1700: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
1701: application => 'AMS',
1702: program => 'AMSILXOM',