APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_PRICE_DIFFERENTIALS_ARCHIVE

Line 2417: -- PO_PRICE_DIFFERENTIALS_ARCHIVE

2413: --Name: ARCHIVE_PRICE_DIFFS
2414: --Pre-reqs:
2415: -- None.
2416: --Modifies:
2417: -- PO_PRICE_DIFFERENTIALS_ARCHIVE
2418: --Locks:
2419: -- None.
2420: --Function:
2421: -- Arcives the price differentials.

Line 2456: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');

2452: l_progress := '010';
2453: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2454: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2455: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2456: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');
2457: END IF;
2458:
2459: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE
2460: (created_by ,

Line 2459: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE

2455: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2456: 'INSERT PO_PRICE_DIFFERENTIALS_ARCHIVE');
2457: END IF;
2458:
2459: INSERT INTO PO_PRICE_DIFFERENTIALS_ARCHIVE
2460: (created_by ,
2461: creation_date ,
2462: enabled_flag ,
2463: entity_id ,

Line 2494: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA

2490: POR.price_type ,
2491: 'Y' ,
2492: p_revision_num
2493: FROM PO_PRICE_DIFFERENTIALS POR,
2494: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA
2495: WHERE ((p_entity_type = 'PRICE BREAK' AND
2496: POR.entity_id IN (SELECT line_location_id
2497: FROM PO_LINE_LOCATIONS_ALL
2498: WHERE po_header_id = p_document_id)) OR

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

2529: l_progress := '020';
2530: l_module := G_MODULE_PREFIX||l_api_name||'.'||l_progress||'.';
2531: IF G_FND_DEBUG = 'Y' AND G_FND_DEBUG_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
2532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2533: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2534: END IF;
2535:
2536: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
2537: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1

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

2532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
2533: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2534: END IF;
2535:
2536: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
2537: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1
2538: SET latest_external_flag = 'N'
2539: WHERE ((p_entity_type = 'PRICE BREAK' AND
2540: entity_id IN (SELECT line_location_id

Line 2537: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1

2533: 'Update PO_PRICE_DIFFERENTIALS_ARCHIVE to reset latest_external_flag');
2534: END IF;
2535:
2536: -- If a row was inserted into PO_PRICE_DIFFERENTIALS_ARCHIVE, then set the appropriate flags
2537: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1
2538: SET latest_external_flag = 'N'
2539: WHERE ((p_entity_type = 'PRICE BREAK' AND
2540: entity_id IN (SELECT line_location_id
2541: FROM PO_LINE_LOCATIONS_ALL

Line 2552: FROM PO_PRICE_DIFFERENTIALS_ARCHIVE POR2

2548: AND latest_external_flag = 'Y'
2549: AND revision_num < p_revision_num
2550: AND EXISTS
2551: (SELECT 'A new archived row'
2552: FROM PO_PRICE_DIFFERENTIALS_ARCHIVE POR2
2553: WHERE POR2.price_differential_id = POR1.price_differential_id
2554: AND POR2.latest_external_flag = 'Y'
2555: AND POR2.revision_num = p_revision_num);
2556: ELSE

Line 3299: FROM po_price_differentials_archive

3295: RETURN BOOLEAN
3296: IS
3297: CURSOR archived_price_diff_csr IS
3298: SELECT 'Price Differential archive records'
3299: FROM po_price_differentials_archive
3300: WHERE price_differential_id = p_price_differential_id;
3301:
3302: l_archive_csr_type archived_price_diff_csr%ROWTYPE;
3303: l_price_diff_is_archived BOOLEAN;