Facility Changes Procs v12

Former Member
Former Member $organization

Hello everyone. I have a job set up that executes certain procedures and I run it when there are changes to a facility. This is what I have and I'm wondering if any of this will need to change for v12. Does anyone know?

 

execute up_populate_tx_perf_seat

execute up_rebuild_all_bsmaps

execute up_update_bsmap_sequence

execute up_update_comp_maps

execute up_update_logical_nos

execute up_update_zone_no

Delete TX_PERF_SEAT where not exists (select * from T_SEAT where SEAT_NO = TX_PERF_SEAT.SEAT_NO and IS_SEAT = 1) 

Delete TX_COMPOSITE_SEAT where not exists (select * from T_SEAT where SEAT_NO = TX_COMPOSITE_SEAT.SEAT_NO and IS_SEAT = 1) 

update tx_perf_seat

set seat_num = s.seat_num, seat_row = s.seat_row

from tx_perf_seat ps, t_seat s

where ps.seat_no = s.seat_no

and (ps.seat_num <> s.seat_num or ps.seat_row <> s.seat_row)