2196: /* if we reach here in code then all the attributes have been validated.
2197: So get the next value from the sequence which will be used as the ci_id*/
2198: select pa_control_items_s.nextval
2199: into l_ci_id 2200: from dual; 2201:
2202: /* now generate the ci_number;*/
2203: if(l_status_code is not null) then
2204: begin