180: end if;
181: else
182: select pos_bus_class_attr_s.nextval
183: into l_class_id
184: from dual;
185:
186: -- approving pending data
187: insert into pos_bus_class_attr
188: (
601: if( l_po_status = 'Y' ) then
602: x_modified := 'Y';
603: select POS_BUS_CLASS_ATTR_S.NEXTVAL
604: into l_id
605: from dual;
606:
607: insert into pos_bus_class_attr
608: (
609: classification_id, certificate_number,
859: else
860:
861: select pos_bus_class_attr_s.nextval
862: into l_class_id
863: from dual;
864:
865: -- approving pending data
866: insert into pos_bus_class_attr
867: (
1061: else
1062:
1063: select pos_bus_class_attr_s.nextval
1064: into l_class_id
1065: from dual;
1066:
1067: -- approving pending data
1068: insert into pos_bus_class_attr
1069: (