APPS.ICX_CAT_FPI_UPGRADE dependencies on POR_FAVORITE_LIST_LINES

Line 84: -- POR_FAVORITE_LIST_LINES

80: gBPSupplierSiteIds DBMS_SQL.NUMBER_TABLE;
81: gBPPriceTypes DBMS_SQL.VARCHAR2_TABLE;
82: gBPRowIds DBMS_SQL.UROWID_TABLE;
83:
84: -- POR_FAVORITE_LIST_LINES
85: gUpFavRowIds DBMS_SQL.UROWID_TABLE;
86: gUpFavRtItemIds DBMS_SQL.NUMBER_TABLE;
87: gInFavRowIds DBMS_SQL.UROWID_TABLE;
88: gInFavRtItemIds DBMS_SQL.NUMBER_TABLE;

Line 2140: -- Update POR_FAVORITE_LIST_LINES

2136: ICX_POR_EXT_UTL.pushError(xReturnErr);
2137: raise ICX_POR_EXT_UTL.gException;
2138: END movePriceLists;
2139:
2140: -- Update POR_FAVORITE_LIST_LINES
2141: PROCEDURE updateFavoriteList IS
2142: xErrLoc PLS_INTEGER;
2143: xReturnErr VARCHAR2(2000);
2144: BEGIN

Line 2156: UPDATE por_favorite_list_lines

2152: END IF;
2153:
2154: xErrLoc := 120;
2155: FORALL i IN 1..gUpFavRowIds.COUNT
2156: UPDATE por_favorite_list_lines
2157: SET rt_item_id = gUpFavRtItemIds(i)
2158: WHERE rowid = gUpFavRowIds(i);
2159: xErrLoc := 200;
2160: gUpFavRtItemIds.DELETE;

Line 2174: -- Insert POR_FAVORITE_LIST_LINES

2170: ICX_POR_EXT_UTL.pushError(xReturnErr);
2171: raise ICX_POR_EXT_UTL.gException;
2172: END updateFavoriteList;
2173:
2174: -- Insert POR_FAVORITE_LIST_LINES
2175: PROCEDURE insertFavoriteList IS
2176: xErrLoc PLS_INTEGER;
2177: xReturnErr VARCHAR2(2000);
2178: BEGIN

Line 2190: INSERT INTO por_favorite_list_lines

2186: END IF;
2187:
2188: xErrLoc := 120;
2189: FORALL i IN 1..gInFavRowIds.COUNT
2190: INSERT INTO por_favorite_list_lines
2191: (favorite_list_line_id,
2192: favorite_list_id,
2193: last_update_date,
2194: last_updated_by,

Line 2250: por_favorite_list_lines_s.nextval,

2246: currency,
2247: rate_type,
2248: rate)
2249: SELECT
2250: por_favorite_list_lines_s.nextval,
2251: favorite_list_id,
2252: sysdate,
2253: gUpgradeUserId,
2254: sysdate,

Line 2308: FROM por_favorite_list_lines

2304: price_list_id,
2305: currency,
2306: rate_type,
2307: rate
2308: FROM por_favorite_list_lines
2309: WHERE rowid = gInFavRowIds(i);
2310: xErrLoc := 200;
2311: gInFavRowIds.DELETE;
2312: gInFavRowIds.DELETE;

Line 2325: -- Upgrade POR_FAVORITE_LIST_LINES

2321: ICX_POR_EXT_UTL.pushError(xReturnErr);
2322: raise ICX_POR_EXT_UTL.gException;
2323: END insertFavoriteList;
2324:
2325: -- Upgrade POR_FAVORITE_LIST_LINES
2326: PROCEDURE upgradeFavoriteList IS
2327: CURSOR cFavoriteListLines IS
2328: SELECT rowid,
2329: nvl(source_doc_header_id, ICX_POR_EXT_ITEM.NULL_NUMBER) contract_id,

Line 2337: FROM por_favorite_list_lines

2333: nvl(template_line_num, ICX_POR_EXT_ITEM.NULL_NUMBER) template_line_id,
2334: nvl(item_id, ICX_POR_EXT_ITEM.NULL_NUMBER) inventory_item_id,
2335: price_list_id,
2336: rt_item_id
2337: FROM por_favorite_list_lines
2338: WHERE rt_item_id IS NOT NULL;
2339:
2340: TYPE tCursorType IS REF CURSOR;
2341: cMatchRtItemIds tCursorType;

Line 2351: 'upgrade POR_FAVORITE_LIST_LINES');

2347:
2348: BEGIN
2349: xErrLoc := 50;
2350: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
2351: 'upgrade POR_FAVORITE_LIST_LINES');
2352:
2353: xErrLoc := 100;
2354: FOR favorite IN cFavoriteListLines LOOP
2355: xErrLoc := 120;