APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_PRICE_LIST_LINES

Line 724: FROM icx_por_price_list_lines prl,

720: TO_CHAR(NULL) item_revision,
721: TO_NUMBER(NULL) line_type_id,
722: TO_NUMBER(NULL) buyer_id,
723: prl.rowid row_id
724: FROM icx_por_price_list_lines prl,
725: icx_por_items item,
726: po_vendor_sites_all pvs
727: WHERE prl.item_id = p_rt_item_id
728: AND prl.buyer_approval_status = 'APPROVED'

Line 1476: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES

1472: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1473: raise ICX_POR_EXT_UTL.gException;
1474: END moveExtractedPrices;
1475:
1476: -- Move data into ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES
1477: PROCEDURE moveBulkloadedPrices IS
1478: xErrLoc PLS_INTEGER;
1479: xReturnErr VARCHAR2(2000);
1480: xMode VARCHAR2(20) := 'BULKLOADED_PRICE';

Line 1496: 'ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES');

1492: END LOOP;
1493: END IF;
1494:
1495: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1496: 'ICX_CAT_ITEM_PRICES from ICX_POR_PRICE_LIST_LINES');
1497:
1498: xErrLoc := 200;
1499: FORALL i IN 1..gBPRtItemIds.COUNT
1500: INSERT INTO ICX_CAT_ITEM_PRICES

Line 1536: FROM ICX_POR_PRICE_LIST_LINES prl

1532: prl.header_id,
1533: gUpgradeUserId, gUpgradeUserId, sysdate,
1534: gUpgradeUserId, prl.creation_date, gUpgradePhaseId,
1535: gUpgradeUserId, gUpgradeUserId, sysdate
1536: FROM ICX_POR_PRICE_LIST_LINES prl
1537: WHERE prl.rowid = gBPRowIds(i);
1538:
1539: COMMIT;
1540:

Line 2585: FROM icx_por_price_list_lines pll

2581: AND (EXISTS (SELECT 'extracted price'
2582: FROM icx_por_oracle_item_subtable sub
2583: WHERE sub.rt_item_id = item.rt_item_id) OR
2584: EXISTS (SELECT 'bulkloaded price'
2585: FROM icx_por_price_list_lines pll
2586: WHERE pll.item_id = item.rt_item_id));
2587: BEGIN
2588: xErrLoc := 50;
2589: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Start Data Upgrade...');