APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_POR_PRICE_LISTS

Line 2091: -- Move records from icx_por_price_lists to icx_cat_price_lists

2087: ICX_POR_EXT_UTL.pushError(xReturnErr);
2088: raise ICX_POR_EXT_UTL.gException;
2089: END updateRequestId;
2090:
2091: -- Move records from icx_por_price_lists to icx_cat_price_lists
2092: PROCEDURE movePriceLists IS
2093: xErrLoc PLS_INTEGER;
2094: xReturnErr VARCHAR2(2000);
2095: BEGIN

Line 2098: 'Move records from icx_por_price_lists to icx_cat_price_lists');

2094: xReturnErr VARCHAR2(2000);
2095: BEGIN
2096: xErrLoc := 50;
2097: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
2098: 'Move records from icx_por_price_lists to icx_cat_price_lists');
2099:
2100: xErrLoc := 100;
2101: LOOP
2102: INSERT INTO ICX_CAT_PRICE_LISTS

Line 2118: FROM ICX_POR_PRICE_LISTS old_list

2114: job_number, begindate, enddate, status,
2115: published_date, outdated_date, approval_date,
2116: rejected_date, deleted_date, buyercomments,
2117: action, type, parent_header_id
2118: FROM ICX_POR_PRICE_LISTS old_list
2119: WHERE NOT EXISTS (SELECT 'Already upgraded'
2120: FROM ICX_CAT_PRICE_LISTS new_list
2121: WHERE old_list.header_id = new_list.price_list_id)
2122: AND ROWNUM <= gCommitSize;