APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1650: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE_ALL

1646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1647: 'CLM Flag : '|| l_clm_flag);
1648: END IF;
1649:
1650: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE_ALL
1651: (accrue_on_receipt_flag,
1652: allow_substitute_receipts_flag,
1653: amount,
1654: amount_accepted,

Line 2021: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA

2017: ,POL.CLM_PROMISE_PERIOD_UOM
2018: ,POL.CLM_POP_DURATION
2019: ,POL.CLM_POP_DURATION_UOM
2020: FROM PO_LINE_LOCATIONS_ALL POL,
2021: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA
2022: WHERE ((p_document_type = 'RELEASE' AND
2023: POL.po_release_id = p_document_id) OR
2024: (p_document_type <> 'RELEASE' AND -- Bug 3210749
2025: POL.po_header_id = p_document_id AND

Line 2104: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1

2100: -- Comments removed for bug 3210749
2101:
2102: IF (p_document_type = 'RELEASE') THEN
2103:
2104: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1
2105: SET latest_external_flag = 'N'
2106: WHERE po_release_id = p_document_id
2107: AND latest_external_flag = 'Y'
2108: AND revision_num < p_revision_num

Line 2111: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2

2107: AND latest_external_flag = 'Y'
2108: AND revision_num < p_revision_num
2109: AND EXISTS
2110: (SELECT 'A new archived row'
2111: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2
2112: WHERE POL2.line_location_id = POL1.line_location_id
2113: AND POL2.latest_external_flag = 'Y'
2114: AND POL2.revision_num = p_revision_num
2115: );

Line 2120: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1

2116:
2117: ELSE
2118: -- p_document_type <> 'RELEASE'
2119:
2120: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL POL1
2121: SET latest_external_flag = 'N'
2122: WHERE ((po_header_id = p_document_id) AND (po_release_id IS NULL))
2123: AND latest_external_flag = 'Y'
2124: AND revision_num < p_revision_num

Line 2127: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2

2123: AND latest_external_flag = 'Y'
2124: AND revision_num < p_revision_num
2125: AND EXISTS
2126: (SELECT 'A new archived row'
2127: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POL2
2128: WHERE POL2.line_location_id = POL1.line_location_id
2129: AND POL2.latest_external_flag = 'Y'
2130: AND POL2.revision_num = p_revision_num
2131: );

Line 3808: FROM po_line_locations_archive_all

3804: RETURN BOOLEAN
3805: IS
3806: CURSOR archived_line_location_csr IS
3807: SELECT 'Line archive records'
3808: FROM po_line_locations_archive_all
3809: WHERE line_location_id = p_line_location_id;
3810:
3811: l_archive_csr_type archived_line_location_csr%ROWTYPE;
3812: l_line_location_is_archived BOOLEAN;

Line 6599: PO_LINE_LOCATIONS_ALL POL, PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

6595: ,POLE.DRAFT_ID
6596: ,p_revision_num
6597: ,'Y' --
6598: FROM PO_LINE_LOCATIONS_ALL_EXT_B POLE,
6599: PO_LINE_LOCATIONS_ALL POL, PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
6600: --
6601: WHERE POL.po_header_id = p_po_header_id
6602: AND POL.line_location_id = POLE.line_location_id
6603: AND POL.line_location_id = POLLA.line_location_id (+)

Line 6624: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL2, PO_LINE_LOCATIONS_ARCHIVE_ALL PLA

6620: WHERE latest_external_flag = 'Y'
6621: AND revision_num < p_revision_num
6622: AND EXISTS
6623: (SELECT 'A new archived row'
6624: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL2, PO_LINE_LOCATIONS_ARCHIVE_ALL PLA
6625: WHERE PLA.po_header_id = p_po_header_id
6626: AND PLA.line_location_id = POL1.line_location_id
6627: AND POL2.line_location_id = POL1.line_location_id
6628: AND POL2.latest_external_flag = 'Y'