[Home] [Help]
1667: loop
1668: fetch C into l_attachment_id, l_document_id;
1669: EXIT WHEN C%NOTFOUND;
1670: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1671: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1672: end loop;
1673: close C;
1674: delete from eng_attachment_changes
1675: where change_id = p_change_id
1796: where document_id = l_document_id;
1797:
1798: -- Temporarily deleting the attachment from fnd_attached_document
1799: -- instead of deleting from the fnd_documents table
1800: -- until the fnd_documents_pkg is fixed
1801:
1802: -- Check if the document exists as part of any other change order
1803: SELECT count(*) into l_document_exists
1804: FROM eng_attachment_changes
1806: AND change_id <> p_change_id
1807: AND revised_item_sequence_id <> p_rev_item_seq_id;
1808:
1809: IF l_document_exists > 0 THEN
1810: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'N');
1811: END IF;
1812: end loop;
1813: close C;
1814:
1928: loop
1929: fetch C into l_attachment_id, l_document_id;
1930: EXIT WHEN C%NOTFOUND;
1931: select datatype_id into l_datatype_id from fnd_documents where document_id = l_document_id;
1932: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
1933: end loop;
1934: close C;
1935: -- Standard ending code ------------------------------------------------
1936: FND_MSG_PUB.Count_And_Get
2038: where attached_document_id = p_attachment_id;
2039: select datatype_id into l_datatype_id
2040: from fnd_documents
2041: where document_id = l_document_id;
2042: fnd_documents_pkg.delete_row(l_document_id, l_datatype_id, 'Y');
2043: exception
2044: when NO_DATA_FOUND then
2045: return;
2046: end;