290: l_process_enabled_flag VARCHAR2(1);
291: l_get_item_description VARCHAR2(1);
292: l_org_id NUMBER;
293:
294: CURSOR c_ic_item_mst_tl IS
295: SELECT *
296: FROM ic_item_mst_tl
297: WHERE item_id = p_item_id;
298:
292: l_org_id NUMBER;
293:
294: CURSOR c_ic_item_mst_tl IS
295: SELECT *
296: FROM ic_item_mst_tl
297: WHERE item_id = p_item_id;
298:
299: BEGIN
300: x_failure_count := 0;
943:
944: IF p_item_source = 'GMI' THEN
945:
946: -- Update the item description in the TL tables.
947: FOR d in c_ic_item_mst_tl LOOP
948: UPDATE mtl_system_items_tl
949: SET description = d.item_desc1,
950: long_description = nvl(long_description, d.item_desc2),
951: source_lang = d.source_lang,