4067: THEN
4068: BEGIN
4069: SELECT CURRENT_PHASE_ID
4070: INTO l_change_subject_unexp_rec.lifecycle_state_id
4071: FROM MTL_System_items_vl
4072: WHERE INVENTORY_ITEM_ID = l_change_subject_unexp_rec.pk1_value
4073: AND ORGANIZATION_ID = l_change_subject_unexp_rec.pk2_value;
4074: EXCEPTION
4075: WHEN NO_DATA_FOUND THEN