56: WHERE pol.draft_id = p_draft_id;
57:
58: --Delete attachments for the above lines
59: FOR i IN 1 .. po_line_ids_tbl.COUNT LOOP
60: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
61: ( 'PO_LINES',
62: po_line_ids_tbl(i)||'-'||p_draft_id,
63: '', '', '', '', '');
64: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
60: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
61: ( 'PO_LINES',
62: po_line_ids_tbl(i)||'-'||p_draft_id,
63: '', '', '', '', '');
64: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
65: ( 'PO_LINES_DEL',
66: po_line_ids_tbl(i)||'-'||p_draft_id,
67: '', '', '', '', '');
68: END LOOP;
68: END LOOP;
69:
70: ELSE
71: --Delete the attachments for the line id passed
72: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
73: ( 'PO_LINES',
74: p_po_line_id||'-'||p_draft_id,
75: '', '', '', '', '');
76:
73: ( 'PO_LINES',
74: p_po_line_id||'-'||p_draft_id,
75: '', '', '', '', '');
76:
77: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
78: ( 'PO_LINES_DEL',
79: p_po_line_id||'-'||p_draft_id,
80: '', '', '', '', '');
81: END IF;