[Home] [Help]
1874: loop
1875: fetch C into l_attachment_id, l_document_id;
1876: EXIT WHEN C%NOTFOUND;
1877: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1878: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1879: end loop;
1880: close C;
1881: delete from eng_attachment_changes
1882: where change_id = p_change_id
2003: where document_id = l_document_id;
2004:
2005: -- Temporarily deleting the attachment from fnd_attached_document
2006: -- instead of deleting from the fnd_documents table
2007: -- until the fnd_documents_pkg is fixed
2008:
2009: -- Check if the document exists as part of any other change order
2010: SELECT count(*) into l_document_exists
2011: FROM eng_attachment_changes
2013: AND change_id <> p_change_id
2014: AND revised_item_sequence_id <> p_rev_item_seq_id;
2015:
2016: IF l_document_exists > 0 THEN
2017: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'N');
2018: END IF;
2019: end loop;
2020: close C;
2021:
2135: loop
2136: fetch C into l_attachment_id, l_document_id;
2137: EXIT WHEN C%NOTFOUND;
2138: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
2139: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2140: end loop;
2141: close C;
2142: -- Standard ending code ------------------------------------------------
2143: FND_MSG_PUB.Count_And_Get
2245: where attached_document_id = p_attachment_id;
2246: select datatype_id into l_datatype_id
2247: from fnd_documents
2248: where document_id = l_document_id;
2249: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2250: exception
2251: when NO_DATA_FOUND then
2252: return;
2253: end;