[Home] [Help]
206: temp_count := 0;
207: if cr.PLANNING_EXCEPTION_SET is not null then
208: begin
209: select count(*) into temp_count
210: from MRP_PLANNING_EXCEPTION_SETS
211: where EXCEPTION_SET_NAME = cr.PLANNING_EXCEPTION_SET;
212: if temp_count = 0 then
213: RAISE count_is_zero;
214: end if;