2213: /* if we reach here in code then all the attributes have been validated.
2214: So get the next value from the sequence which will be used as the ci_id*/
2215: select pa_control_items_s.nextval
2216: into l_ci_id 2217: from dual; 2218:
2219: /* now generate the ci_number;*/
2220: if(l_status_code is not null) then
2221: begin