264: l_maturity_days NUMBER;
265: l_hold_days NUMBER;
266: l_process_enabled_flag VARCHAR2(1);
267:
268: CURSOR c_ic_item_mst_tl IS
269: SELECT *
270: FROM ic_item_mst_tl
271: WHERE item_id = p_item_id;
272: BEGIN
266: l_process_enabled_flag VARCHAR2(1);
267:
268: CURSOR c_ic_item_mst_tl IS
269: SELECT *
270: FROM ic_item_mst_tl
271: WHERE item_id = p_item_id;
272: BEGIN
273: x_failure_count := 0;
274: -- Get the OPM Item Master Details
856:
857: IF p_item_source = 'GMI' THEN
858:
859: -- Update the item description in the TL tables.
860: FOR d in c_ic_item_mst_tl LOOP
861: UPDATE mtl_system_items_tl
862: SET description = d.item_desc1,
863: long_description = nvl(long_description, d.item_desc2),
864: source_lang = d.source_lang,