APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1388: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE_ALL

1384: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1385: 'INSERT PO_LINE_LOCATIONS_ARCHIVE');
1386: END IF;
1387:
1388: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE_ALL
1389: (accrue_on_receipt_flag,
1390: allow_substitute_receipts_flag,
1391: amount,
1392: amount_accepted,

Line 1722: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA

1718: , POL.retainage_released_amount
1719: --
1720: , POL.outsourced_assembly --
1721: FROM PO_LINE_LOCATIONS_ALL POL,
1722: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA
1723: WHERE ((p_document_type = 'RELEASE' AND
1724: POL.po_release_id = p_document_id) OR
1725: (p_document_type <> 'RELEASE' AND -- Bug 3210749
1726: POL.po_header_id = p_document_id AND

Line 1802: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1

1798: -- Comments removed for bug 3210749
1799:
1800: IF (p_document_type = 'RELEASE') THEN
1801:
1802: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1
1803: SET latest_external_flag = 'N'
1804: WHERE po_release_id = p_document_id
1805: AND latest_external_flag = 'Y'
1806: AND revision_num < p_revision_num

Line 1809: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2

1805: AND latest_external_flag = 'Y'
1806: AND revision_num < p_revision_num
1807: AND EXISTS
1808: (SELECT 'A new archived row'
1809: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2
1810: WHERE POL2.line_location_id = POL1.line_location_id
1811: AND POL2.latest_external_flag = 'Y'
1812: AND POL2.revision_num = p_revision_num
1813: );

Line 1818: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1

1814:
1815: ELSE
1816: -- p_document_type <> 'RELEASE'
1817:
1818: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1
1819: SET latest_external_flag = 'N'
1820: WHERE ((po_header_id = p_document_id) AND (po_release_id IS NULL))
1821: AND latest_external_flag = 'Y'
1822: AND revision_num < p_revision_num

Line 1825: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2

1821: AND latest_external_flag = 'Y'
1822: AND revision_num < p_revision_num
1823: AND EXISTS
1824: (SELECT 'A new archived row'
1825: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2
1826: WHERE POL2.line_location_id = POL1.line_location_id
1827: AND POL2.latest_external_flag = 'Y'
1828: AND POL2.revision_num = p_revision_num
1829: );

Line 3244: FROM po_line_locations_archive_all

3240: RETURN BOOLEAN
3241: IS
3242: CURSOR archived_line_location_csr IS
3243: SELECT 'Line archive records'
3244: FROM po_line_locations_archive_all
3245: WHERE line_location_id = p_line_location_id;
3246:
3247: l_archive_csr_type archived_line_location_csr%ROWTYPE;
3248: l_line_location_is_archived BOOLEAN;