1639: ELSE
1640: IF l_project_id IS NOT NULL THEN
1641: UPDATE MTL_MWB_GTMP
1642: SET project_number = (SELECT project_number
1643: FROM pjm_projects_v
1644: WHERE project_id = l_project_id)
1645: WHERE locator_id = rec.locator_id;
1646: END IF;
1647: END IF;