3246:
3247: /* Bug 2781710: We should update the note_to_vendor column
3248: in the archive table also. */
3249:
3250: UPDATE po_headers_archive pha
3251: SET pha.note_to_vendor = p_note_to_vendor
3252: WHERE pha.po_header_id = p_doc_id AND
3253: pha.revision_num = (SELECT poh.revision_num
3254: FROM po_headers poh
5305:
5306: l_progress :='003';
5307: SELECT Count(1)
5308: INTO l_archive_count
5309: FROM po_headers_archive_all
5310: WHERE po_header_id = p_doc_id;
5311:
5312: ELSE
5313: l_progress :='004';