APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 156: PO_RELEASES_ARCHIVE_ALL PHA

152: SELECT NVL(ph.revision_num, 0),
153: NVL(pha.revision_num, -1)
154: INTO x_revision_num, l_arch_revision_num
155: FROM PO_RELEASES_ALL PH,
156: PO_RELEASES_ARCHIVE_ALL PHA
157: WHERE ph.po_release_id = p_document_id
158: AND ph.approved_date IS NOT NULL
159: AND ph.approved_flag = 'Y'
160: AND ph.po_release_id = pha.po_release_id (+)

Line 602: UPDATE PO_RELEASES_ARCHIVE_ALL

598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
599: 'Update PO_HEADERS_ARCHIVE to reset latest_external_flag');
600: END IF;
601:
602: UPDATE PO_RELEASES_ARCHIVE_ALL
603: SET latest_external_flag = 'N'
604: WHERE po_release_id = p_document_id
605: AND latest_external_flag = 'Y';
606:

Line 615: INSERT INTO PO_RELEASES_ARCHIVE_ALL

611: 'Insert PO_RELEASES_ARCHIVE ');
612: END IF;
613:
614: -- Archiving the releases
615: INSERT INTO PO_RELEASES_ARCHIVE_ALL
616: (acceptance_due_date ,
617: acceptance_required_flag ,
618: agent_id ,
619: approved_date ,