eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS

Line 1599: -- PO_LINE_LOCATIONS_ARCHIVE

1595: --Name: ARCHIVE_LINE_LOCATIONS
1596: --Pre-reqs:
1597: -- None.
1598: --Modifies:
1599: -- PO_LINE_LOCATIONS_ARCHIVE
1600: --Locks:
1601: -- None.
1602: --Function:
1603: -- Arcives the po document line locations.

Line 1645: 'INSERT PO_LINE_LOCATIONS_ARCHIVE');

1641:
1642: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
1643: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
1644: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1645: 'INSERT PO_LINE_LOCATIONS_ARCHIVE');
1646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1647: 'CLM Flag : '|| l_clm_flag);
1648: END IF;
1649:

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 2020: FROM PO_LINE_LOCATIONS_ALL POL,

2016: ,POL.CLM_PROMISE_PERIOD
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

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 2091: 'Update PO_LINE_LOCATIONS_ARCHIVE to reset latest_external_flag');

2087: l_progress := '020';
2088: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2089: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2090: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2091: 'Update PO_LINE_LOCATIONS_ARCHIVE to reset latest_external_flag');
2092: END IF;
2093:
2094:
2095: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags

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 2855: FROM PO_LINE_LOCATIONS_ALL

2851: FROM PO_PRICE_DIFFERENTIALS POR,
2852: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA
2853: WHERE ((p_entity_type = 'PRICE BREAK' AND
2854: POR.entity_id IN (SELECT line_location_id
2855: FROM PO_LINE_LOCATIONS_ALL
2856: WHERE po_header_id = p_document_id)) OR
2857: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2858: POR.entity_id IN (SELECT po_line_id
2859: FROM PO_LINES_ALL

Line 2899: FROM PO_LINE_LOCATIONS_ALL

2895: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1
2896: SET latest_external_flag = 'N'
2897: WHERE ((p_entity_type = 'PRICE BREAK' AND
2898: entity_id IN (SELECT line_location_id
2899: FROM PO_LINE_LOCATIONS_ALL
2900: WHERE po_header_id = p_document_id)) OR
2901: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2902: entity_id IN (SELECT po_line_id
2903: FROM PO_LINES_ALL

Line 3147: * when modified archive PO_LINES, PO_LINE_LOCATIONS,

3143: * When PO
3144: * Case entity.document_subtype is
3145: * When STANDARD or PLANNED
3146: * archive PO_HEADERS
3147: * when modified archive PO_LINES, PO_LINE_LOCATIONS,
3148: * PO_PRICE_DIFFERENTIALS and PO_DISTRIBUTIONS.
3149: * End Case
3150: * When PA
3151: * Case entity.document_subtype is

Line 3154: * when modified archive PO_LINES, PO_LINE_LOCATIONS, PO_PRICE_DIFFERENTIALS

3150: * When PA
3151: * Case entity.document_subtype is
3152: * When BLANKET
3153: * archive PO_HEADERS
3154: * when modified archive PO_LINES, PO_LINE_LOCATIONS, PO_PRICE_DIFFERENTIALS
3155: * (for price breaks)
3156: * When CONTRACT
3157: * archive PO_HEADERS
3158: * End Case

Line 3163: * when modified archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS.

3159: * If global_agreement_flag = Y (i.e. global blanket or global contract) --
3160: * When modified, archive PO_GA_ORG_ASSIGNMENT
3161: * When RELEASE
3162: * archive PO_RELEASES
3163: * when modified archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS.
3164: * End Case
3165: *
3166: * IF error happens, rollback to the savepoint;
3167: *

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 6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');

6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;
6378:
6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6380: (EXTENSION_ID

Line 6598: FROM PO_LINE_LOCATIONS_ALL_EXT_B POLE,

6594: ,POLE.UDA_TEMPLATE_ID
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

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'

Line 6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');

6638:
6639: -- Start PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6640: l_progress := '130';
6641: IF PO_LOG.d_stmt THEN
6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');
6643: END IF;
6644:
6645: INSERT INTO PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6646: (EXTENSION_ID

Line 6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,

6764: ,POLE.UDA_TEMPLATE_ID
6765: ,POLE.DRAFT_ID
6766: ,p_revision_num
6767: ,NULL
6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,
6769: PO_LINE_LOCATIONS_ALL POL
6770: WHERE POL.po_header_id = p_po_header_id
6771: AND POL.line_location_id = POLE.line_location_id
6772: AND POLE.draft_id = -1;

Line 6769: PO_LINE_LOCATIONS_ALL POL

6765: ,POLE.DRAFT_ID
6766: ,p_revision_num
6767: ,NULL
6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,
6769: PO_LINE_LOCATIONS_ALL POL
6770: WHERE POL.po_header_id = p_po_header_id
6771: AND POL.line_location_id = POLE.line_location_id
6772: AND POLE.draft_id = -1;
6773:

Line 6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6847:

Line 6856: CURSOR po_shipment_cursor(p_po_line_id po_line_locations.po_line_id%TYPE) IS

6852: FROM PO_LINES_ALL
6853: WHERE po_header_id = p_po_header_id
6854: ORDER BY line_num;
6855:
6856: CURSOR po_shipment_cursor(p_po_line_id po_line_locations.po_line_id%TYPE) IS
6857: SELECT line_location_id
6858: FROM PO_LINE_LOCATIONS_ALL
6859: WHERE po_line_id = p_po_line_id
6860: ORDER BY shipment_num;

Line 6858: FROM PO_LINE_LOCATIONS_ALL

6854: ORDER BY line_num;
6855:
6856: CURSOR po_shipment_cursor(p_po_line_id po_line_locations.po_line_id%TYPE) IS
6857: SELECT line_location_id
6858: FROM PO_LINE_LOCATIONS_ALL
6859: WHERE po_line_id = p_po_line_id
6860: ORDER BY shipment_num;
6861:
6862: CURSOR po_distribution_cursor(p_line_location_id po_distributions.line_location_id%TYPE) IS