DBA Data[Home] [Help]

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 1430: from po_headers_archive_all poh

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);