DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 2225: INSERT INTO PO_DISTRIBUTIONS_ARCHIVE_ALL

2221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2222: 'CLM Flag : ' || l_clm_flag);
2223: END IF;
2224:
2225: INSERT INTO PO_DISTRIBUTIONS_ARCHIVE_ALL
2226: (accrual_account_id,
2227: accrue_on_receipt_flag,
2228: accrued_flag,
2229: amount_billed,

Line 2493: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

2489: ,POD.USSGL_TRANSACTION_CODE
2490: --
2491: ,POD.clm_payment_sequence_num --
2492: FROM PO_DISTRIBUTIONS_ALL POD,
2493: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
2494: WHERE ((p_document_type = 'RELEASE' AND
2495: POD.po_release_id = p_document_id) OR
2496: (p_document_type <> 'RELEASE' AND -- Bug 3210749
2497: POD.po_header_id = p_document_id AND

Line 2574: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id

2570: END IF;
2571:
2572: -- Bug 3648552 START
2573: -- Get PO_HEADER_ID for Release since there is no index on
2574: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id
2575: IF (p_document_type = 'RELEASE') THEN
2576: SELECT po_header_id
2577: INTO l_po_header_id
2578: FROM po_releases_all

Line 2588: UPDATE PO_DISTRIBUTIONS_ARCHIVE_ALL POD1

2584: END IF;
2585: -- Bug 3648552 END
2586:
2587: -- If a row was inserted into PO_DISTRIBUTIONS_ARCHIVE, then set the appropriate flags
2588: UPDATE PO_DISTRIBUTIONS_ARCHIVE_ALL POD1
2589: SET latest_external_flag = 'N'
2590: -- Bug 3648552 START
2591: WHERE po_header_id = l_po_header_id
2592: -- Bug 3713788: fixed regression caused by bug 3648552

Line 2599: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2

2595: AND latest_external_flag = 'Y'
2596: AND revision_num < p_revision_num
2597: AND EXISTS
2598: (SELECT 'A new archived row'
2599: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL POD2
2600: WHERE POD2.po_distribution_id = POD1.po_distribution_id
2601: AND POD2.latest_external_flag = 'Y'
2602: AND POD2.revision_num = p_revision_num);
2603: ELSE