1512: END IF;
1513:
1514: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS') LOOP
1515: --delete the old records
1516: fnd_attached_documents3_pkg.delete_row
1517: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1518: X_datatype_id => l_rec.datatype_id,
1519: delete_document_flag => 'Y'
1520: );
1538:
1539:
1540: for l_rec in modified_header_attachments_c(p_header_id,p_draft_id,'PO_HEADERS_DEL') LOOP
1541: --delete the old record
1542: fnd_attached_documents3_pkg.delete_row
1543: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1544: X_datatype_id => l_rec.datatype_id,
1545: delete_document_flag => 'Y'
1546: );
1627: END IF;
1628:
1629: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES') LOOP
1630: --delete the old record
1631: fnd_attached_documents3_pkg.delete_row
1632: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1633: X_datatype_id => l_rec.datatype_id,
1634: delete_document_flag => 'Y'
1635: );
1651: END IF;
1652:
1653: for l_rec in modified_line_attachments_c(p_draft_id,'PO_LINES_DEL') LOOP
1654: --delete the old record
1655: fnd_attached_documents3_pkg.delete_row
1656: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1657: X_datatype_id => l_rec.datatype_id,
1658: delete_document_flag => 'Y'
1659: );
1741: END IF;
1742:
1743: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS') LOOP
1744: --delete the old records
1745: fnd_attached_documents3_pkg.delete_row
1746: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1747: X_datatype_id => l_rec.datatype_id,
1748: delete_document_flag => 'Y'
1749: );
1764: PO_LOG.stmt(d_module, d_position, x_progress);
1765: END IF;
1766: for l_rec in modified_line_loc_attachment_c(p_draft_id,'PO_SHIPMENTS_DEL') LOOP
1767: --delete the records
1768: fnd_attached_documents3_pkg.delete_row
1769: ( X_attached_document_id => l_rec.ORIG_ATTACH_DOC_ID,
1770: X_datatype_id => l_rec.datatype_id,
1771: delete_document_flag => 'Y'
1772: );