APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 1918: INSERT INTO PO_DISTRIBUTIONS_ARCHIVE_ALL

1914: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1915: 'INSERT PO_DISTRIBUTIONS_ARCHIVE');
1916: END IF;
1917:
1918: INSERT INTO PO_DISTRIBUTIONS_ARCHIVE_ALL
1919: (accrual_account_id,
1920: accrue_on_receipt_flag,
1921: accrued_flag,
1922: amount_billed,

Line 2138: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

2134: POD.retainage_withheld_amount,
2135: POD.retainage_released_amount
2136: --
2137: FROM PO_DISTRIBUTIONS_ALL POD,
2138: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
2139: WHERE ((p_document_type = 'RELEASE' AND
2140: POD.po_release_id = p_document_id) OR
2141: (p_document_type <> 'RELEASE' AND -- Bug 3210749
2142: POD.po_header_id = p_document_id AND

Line 2216: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id

2212: END IF;
2213:
2214: -- Bug 3648552 START
2215: -- Get PO_HEADER_ID for Release since there is no index on
2216: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id
2217: IF (p_document_type = 'RELEASE') THEN
2218: SELECT po_header_id
2219: INTO l_po_header_id
2220: FROM po_releases_all

Line 2230: UPDATE PO_DISTRIBUTIONS_ARCHIVE_ALL POD1

2226: END IF;
2227: -- Bug 3648552 END
2228:
2229: -- If a row was inserted into PO_DISTRIBUTIONS_ARCHIVE, then set the appropriate flags
2230: UPDATE PO_DISTRIBUTIONS_ARCHIVE_ALL POD1
2231: SET latest_external_flag = 'N'
2232: -- Bug 3648552 START
2233: WHERE po_header_id = l_po_header_id
2234: -- Bug 3713788: fixed regression caused by bug 3648552

Line 2241: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

2237: AND latest_external_flag = 'Y'
2238: AND revision_num < p_revision_num
2239: AND EXISTS
2240: (SELECT 'A new archived row'
2241: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
2242: WHERE POD2.po_distribution_id = POD1.po_distribution_id
2243: AND POD2.latest_external_flag = 'Y'
2244: AND POD2.revision_num = p_revision_num);
2245: ELSE