DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 209: PO_RELEASES_ARCHIVE_ALL PHA

205: SELECT NVL(ph.revision_num, 0),
206: NVL(pha.revision_num, -1)
207: INTO x_revision_num, l_arch_revision_num
208: FROM PO_RELEASES_ALL PH,
209: PO_RELEASES_ARCHIVE_ALL PHA
210: WHERE ph.po_release_id = p_document_id
211: AND ph.approved_date IS NOT NULL
212: AND ph.approved_flag = 'Y'
213: AND ph.po_release_id = pha.po_release_id (+)

Line 761: UPDATE PO_RELEASES_ARCHIVE_ALL

757: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
758: 'Update PO_HEADERS_ARCHIVE to reset latest_external_flag');
759: END IF;
760:
761: UPDATE PO_RELEASES_ARCHIVE_ALL
762: SET latest_external_flag = 'N'
763: WHERE po_release_id = p_document_id
764: AND latest_external_flag = 'Y';
765:

Line 774: INSERT INTO PO_RELEASES_ARCHIVE_ALL

770: 'Insert PO_RELEASES_ARCHIVE ');
771: END IF;
772:
773: -- Archiving the releases
774: INSERT INTO PO_RELEASES_ARCHIVE_ALL
775: (acceptance_due_date ,
776: acceptance_required_flag ,
777: agent_id ,
778: approved_date ,