77: IF p_instance_number IS NOT NULL THEN
78: BEGIN
79: SELECT csi.instance_id
80: INTO l_instance_id
81: FROM csi_item_instances csi
82: WHERE csi.instance_id = p_instance_id
83: AND csi.instance_number = p_instance_number;
84: EXCEPTION
85: WHEN NO_DATA_FOUND THEN
109: ELSIF p_instance_number IS NOT NULL THEN
110: BEGIN
111: SELECT csi.instance_id
112: INTO l_instance_id
113: FROM csi_item_instances csi
114: WHERE csi.instance_number = p_instance_number;
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: IF (l_debug_level > 1) THEN