APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_ITEMID

Line 1008: SELECT icx_por_itemid.nextval

1004:
1005: ELSE
1006: xErrLoc := 240;
1007: -- Create new rt_item_id
1008: SELECT icx_por_itemid.nextval
1009: INTO xRtItemId
1010: FROM sys.dual;
1011:
1012: xErrLoc := 300;

Line 1845: SELECT NVL(p.rt_item_id, icx_por_itemid.nextval) rt_item_id,

1841: PROCEDURE createPurchasingItemPrices IS
1842: snap_shot_too_old EXCEPTION;
1843: PRAGMA EXCEPTION_INIT(snap_shot_too_old, -1555);
1844: CURSOR cPurchasingItemPrices IS
1845: SELECT NVL(p.rt_item_id, icx_por_itemid.nextval) rt_item_id,
1846: i.rt_item_id old_rt_item_id,
1847: p.rt_item_id internal_rt_item_id,
1848: i.internal_item_id inventory_item_id,
1849: i.org_id org_id,