APPS.ECE_PO_ARCHIVE_PKG dependencies on PO_RELEASES_ARCHIVE

Line 396: FROM PO_RELEASES_ARCHIVE

392: BEGIN
393:
394: SELECT NVL(REVISION_NUM,-1)
395: INTO l_archived_revision_num
396: FROM PO_RELEASES_ARCHIVE
397: WHERE PO_RELEASE_ID = p_document_id
398: AND LATEST_EXTERNAL_FLAG = 'Y';
399:
400: EXCEPTION

Line 1456: UPDATE PO_RELEASES_ARCHIVE

1452: IS
1453:
1454: BEGIN
1455: -- Set the latest_external_flag of the archived header to 'N'.
1456: UPDATE PO_RELEASES_ARCHIVE
1457: SET LATEST_EXTERNAL_FLAG = 'N'
1458: WHERE PO_RELEASE_ID = p_document_id
1459: AND LATEST_EXTERNAL_FLAG = 'Y';
1460:

Line 1462: INSERT INTO PO_RELEASES_ARCHIVE

1458: WHERE PO_RELEASE_ID = p_document_id
1459: AND LATEST_EXTERNAL_FLAG = 'Y';
1460:
1461: -- Archive the release.
1462: INSERT INTO PO_RELEASES_ARCHIVE
1463: (
1464: ACCEPTANCE_DUE_DATE ,
1465: ACCEPTANCE_REQUIRED_FLAG ,
1466: AGENT_ID ,