621:
622: FOR l_rec IN Cur_get_text LOOP
623: IF l_rec.material_detail_id IS NOT NULL THEN
624: IF l_rec.text_code IS NOT NULL THEN
625: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(l_rec.text_code,'FM_TEXT_TBL_TL','GME_TEXT_TABLE_TL');
626:
627: UPDATE gme_material_details
628: SET text_code = l_text_code
629: WHERE material_detail_id = l_rec.material_detail_id;
630: END IF;
631: END IF;
632: IF l_rec.orginal_text_code IS NOT NULL AND
633: l_rec.text_code <> l_rec.orginal_text_code THEN
634: GMA_EDITTEXT_PKG.Delete_Text(l_rec.orginal_text_code,'GME_TEXT_TABLE_TL');
635: END IF;
636: END LOOP;
637:
638: update gmd_material_details_gtmp a