1267: begin
1268:
1269: SELECT nvl(next_unique_identifier,0)
1270: into l_dummy
1271: FROM gms_unique_identifier_control
1272: WHERE table_name = 'GMS_AWARDS'
1273: FOR update of next_unique_identifier;
1274:
1275: UPDATE gms_unique_identifier_control
1271: FROM gms_unique_identifier_control
1272: WHERE table_name = 'GMS_AWARDS'
1273: FOR update of next_unique_identifier;
1274:
1275: UPDATE gms_unique_identifier_control
1276: SET next_unique_identifier = l_dummy + 1,
1277: last_update_date = trunc(sysdate) ,
1278: last_updated_by = 0
1279: WHERE table_name = 'GMS_AWARDS';