APPS.PO_XML_DELIVERY dependencies on PO_HEADERS_ARCHIVE_ALL

Line 805: update po_headers_archive_all

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

Line 819: update po_headers_archive_all

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

Line 1433: from po_headers_archive_all poh

1429:
1430: else --for standard POs.
1431: x_progress := 'PO_XML_DELIVERY.setwfUserKey : 04';
1432: select segment1 into l_ponum
1433: from po_headers_archive_all poh
1434: where po_header_id= l_document_id and
1435: revision_num = l_revision_num;
1436:
1437: l_user_key := l_ponum || '-' || to_char(l_revision_num);