DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PO_RELEASES_ARCHIVE_ALL

Line 835: update po_releases_archive_all

831: po_header_id = p_header_id and
832: po_release_id = p_release_id and
833: org_id = p_org_id;
834:
835: update po_releases_archive_all
836: set xml_send_date = sysdate
837: where
838: po_header_id = p_header_id and
839: po_release_id = p_release_id and

Line 851: update po_releases_archive_all

847: po_header_id = p_header_id and
848: po_release_id = p_release_id and
849: org_id = p_org_id;
850:
851: update po_releases_archive_all
852: set xml_change_send_date = sysdate
853: where
854: po_header_id = p_header_id and
855: po_release_id = p_release_id and

Line 1422: from PO_RELEASES_ARCHIVE_ALL praa, po_headers_all pha

1418:
1419: select PHA.SEGMENT1, PRAA.REVISION_NUM,
1420: PRAA.RELEASE_NUM
1421: into l_ponum, l_revision_num, l_release_num
1422: from PO_RELEASES_ARCHIVE_ALL praa, po_headers_all pha
1423: where PHA.PO_HEADER_ID = PRAA.PO_HEADER_ID and
1424: praa.po_release_id = l_release_id and
1425: praa.revision_num = l_revision_num;
1426: