APPS.ECE_PO_ARCHIVE_PKG dependencies on PO_RELEASES

Line 162: -- archive PO_RELEASES

158: -- when modified archive PO_LINES.
159: -- When CONTRACT
160: -- archive PO_HEADERS
161: -- When RELEASE
162: -- archive PO_RELEASES
163: -- when modified archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS.
164: -- End Case
165: -- Note: Private Procedure
166: -- ============================================================================

Line 385: FROM PO_RELEASES

381: -- If the revision_num does not exist (which should never be the
382: -- case), we default to 0.
383: SELECT NVL(REVISION_NUM,0)
384: INTO l_revision_num
385: FROM PO_RELEASES
386: WHERE PO_RELEASE_ID = p_document_id;
387:
388: -- Assert: Release exists.
389: -- Check if Release is already archived.

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 1437: -- Desc: Archive PO_RELEASES, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1433: END PORARSHIPDIST;
1434:
1435: -- ============================================================================
1436: -- Name: porarrelease
1437: -- Desc: Archive PO_RELEASES, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1438: -- Args: IN: p_document_id - The unique identifier of the Release
1439: -- p_revision_num - The revision number of the header
1440: -- Err : Error message context returned in global_stack.
1441: -- Algr: Set the LATEST_EXTERNAL_FLAG of the currently archived release

Line 1443: -- Archive PO_RELEASES

1439: -- p_revision_num - The revision number of the header
1440: -- Err : Error message context returned in global_stack.
1441: -- Algr: Set the LATEST_EXTERNAL_FLAG of the currently archived release
1442: -- to "N"
1443: -- Archive PO_RELEASES
1444: -- Archive PO_LINE_LOCATIONS
1445: -- Archive PO_DISTRIBUTIONS
1446: -- Note: Private Procedure
1447: -- ============================================================================

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 ,

Line 1575: FROM PO_RELEASES

1571: REQUEST_ID ,
1572: REVISED_DATE ,
1573: REVISION_NUM ,
1574: USSGL_TRANSACTION_CODE
1575: FROM PO_RELEASES
1576: WHERE PO_RELEASE_ID = p_document_id;
1577:
1578:
1579: -- Archive the Shipments.