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_ITEM_UPLOAD dependencies on ICX_CAT_CATEGORY_ITEMS

Line 1208: INSERT into icx_cat_category_items(rt_category_id, rt_item_id, last_update_login, last_updated_by, last_update_date, created_by, creation_date)

1204:
1205: xErrLoc := 200;
1206:
1207: FORALL i in 1..vCount
1208: INSERT into icx_cat_category_items(rt_category_id, rt_item_id, last_update_login, last_updated_by, last_update_date, created_by, creation_date)
1209: VALUES (vCategoryIds(i), vItemIds(i), gUserLogin, gUserId, sysdate, gUserId, sysdate);
1210:
1211: xErrLoc := 300;
1212:

Line 1217: UPDATE icx_cat_category_items

1213: --For update/translate we update category items
1214: -- There could be template reference in the category items table, so just
1215: -- update only for the genus category specified in the catalog file.
1216: FORALL i in 1..gItemIds.COUNT
1217: UPDATE icx_cat_category_items
1218: SET rt_category_id = gCategoryIds(i)
1219: WHERE gSystemActions(i) in ('UPDATE', 'TRANSLATE')
1220: and rt_item_id = gItemIds(i)
1221: and rt_category_id = gOldCategoryIds(i); --Bug#2714487

Line 1224: -- For delete we delete from icx_cat_category_items

1220: and rt_item_id = gItemIds(i)
1221: and rt_category_id = gOldCategoryIds(i); --Bug#2714487
1222: xErrLoc := 350;
1223:
1224: -- For delete we delete from icx_cat_category_items
1225: FORALL i in 1..gItemIds.COUNT
1226: DELETE from icx_cat_category_items
1227: WHERE gSystemActions(i) = 'DELETE'
1228: and rt_category_id = gCategoryIds(i)

Line 1226: DELETE from icx_cat_category_items

1222: xErrLoc := 350;
1223:
1224: -- For delete we delete from icx_cat_category_items
1225: FORALL i in 1..gItemIds.COUNT
1226: DELETE from icx_cat_category_items
1227: WHERE gSystemActions(i) = 'DELETE'
1228: and rt_category_id = gCategoryIds(i)
1229: and rt_item_id = gItemIds(i);
1230:

Line 1944: -- ICX_CAT_CATEGORY_ITEMS

1940: AND v_action = gSystemActions(i);
1941:
1942: xErrLoc := 400;
1943:
1944: -- ICX_CAT_CATEGORY_ITEMS
1945: FORALL i in 1..gRowIds.COUNT
1946: DELETE from icx_cat_category_items
1947: WHERE rt_item_id = gItemIds(i)
1948: AND v_action = gSystemActions(i);

Line 1946: DELETE from icx_cat_category_items

1942: xErrLoc := 400;
1943:
1944: -- ICX_CAT_CATEGORY_ITEMS
1945: FORALL i in 1..gRowIds.COUNT
1946: DELETE from icx_cat_category_items
1947: WHERE rt_item_id = gItemIds(i)
1948: AND v_action = gSystemActions(i);
1949:
1950: xErrLoc := 450;