APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_PRICE_DIFFERENTIALS_ARCHIVE

Line 2775: -- PO_PRICE_DIFFERENTIALS_ARCHIVE

2771: --Name: ARCHIVE_PRICE_DIFFS
2772: --Pre-reqs:
2773: -- None.
2774: --Modifies:
2775: -- PO_PRICE_DIFFERENTIALS_ARCHIVE
2776: --Locks:
2777: -- None.
2778: --Function:
2779: -- Arcives the price differentials.

Line 2814: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');

2810: l_progress := '010';
2811: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2812: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2813: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2814: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');
2815: END IF;
2816:
2817: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE
2818: (created_by ,

Line 2817: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE

2813: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2814: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');
2815: END IF;
2816:
2817: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE
2818: (created_by ,
2819: creation_date ,
2820: enabled_flag ,
2821: entity_id ,

Line 2852: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA

2848: POR.price_type ,
2849: 'Y' ,
2850: p_revision_num
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

Line 2891: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');

2887: l_progress := '020';
2888: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2889: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2890: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2891: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2892: END IF;
2893:
2894: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
2895: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1

Line 2894: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags

2890: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2891: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2892: END IF;
2893:
2894: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
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

Line 2895: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1

2891: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2892: END IF;
2893:
2894: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
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

Line 2910: FROM PO_PRICE_DIFFERENTIALS_ARCHIVE POR2

2906: AND latest_external_flag = 'Y'
2907: AND revision_num < p_revision_num
2908: AND EXISTS
2909: (SELECT 'A new archived row'
2910: FROM PO_PRICE_DIFFERENTIALS_ARCHIVE POR2
2911: WHERE POR2.price_differential_id = POR1.price_differential_id
2912: AND POR2.latest_external_flag = 'Y'
2913: AND POR2.revision_num = p_revision_num);
2914: ELSE

Line 3863: FROM po_price_differentials_archive

3859: RETURN BOOLEAN
3860: IS
3861: CURSOR archived_price_diff_csr IS
3862: SELECT 'Price Differential archive records'
3863: FROM po_price_differentials_archive
3864: WHERE price_differential_id = p_price_differential_id;
3865:
3866: l_archive_csr_type archived_price_diff_csr%ROWTYPE;
3867: l_price_diff_is_archived BOOLEAN;