eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_CLASS dependencies on ICX_CAT_ITEMS_TLP

Line 119: FROM icx_cat_items_tlp

115:
116: CURSOR cRebuildItems(p_rt_category_id IN NUMBER,
117: p_language IN VARCHAR2) IS
118: SELECT rowid
119: FROM icx_cat_items_tlp
120: WHERE primary_category_id = p_rt_category_id
121: AND language = p_language;
122:
123: xRowIds DBMS_SQL.UROWID_TABLE;

Line 271: FROM icx_cat_items_tlp

267:
268: CURSOR cRebuildItems(p_rt_category_id IN NUMBER,
269: p_language IN VARCHAR2) IS
270: SELECT rowid
271: FROM icx_cat_items_tlp
272: WHERE primary_category_id = p_rt_category_id
273: AND language = p_language;
274:
275: xRowIds DBMS_SQL.UROWID_TABLE;

Line 312: UPDATE icx_cat_items_tlp

308: EXIT WHEN xRowIds.COUNT = 0;
309:
310: xErrLoc := 240;
311: FORALL j IN 1..xRowIds.COUNT
312: UPDATE icx_cat_items_tlp
313: SET primary_category_name = gUpdateCategoryNames(i),
314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,