first get last record.
select top 1 ctrl_last_no from CONTROL_FILE where ctrl_type = 'PKGNO' order by ctrl_last_no desc.
than store it any int variable than increment and insert in another table . or you can also write a stroed procedure/trigger for all above tasks(which is better approach)