801: where
802: po_header_id = p_header_id and
803: org_id = p_org_id;
804:
805: update po_headers_archive_all
806: set xml_send_date = sysdate
807: where
808: po_header_id = p_header_id and
809: org_id = p_org_id and
815: where
816: po_header_id = p_header_id and
817: org_id = p_org_id;
818:
819: update po_headers_archive_all
820: set xml_change_send_date = sysdate
821: where
822: po_header_id = p_header_id and
823: org_id = p_org_id and
1426:
1427: else --for standard POs.
1428: x_progress := 'PO_XML_DELIVERY.setwfUserKey : 04';
1429: select segment1 into l_ponum
1430: from po_headers_archive_all poh
1431: where po_header_id= l_document_id and
1432: revision_num = l_revision_num;
1433:
1434: l_user_key := l_ponum || '-' || to_char(l_revision_num);