-- apps_transaction.upStatusOrderToN (PROCEDURE)
begin
update header_transaction_owner1 hto
join detail_transaction_owner dto on hto.OrderID = dto.OrderID
set hto.ActiveYN = 'N', hto.LastUpdated = now(), hto.StatusOrderID = 7, hto.UpdatedBy = userID1,
dto.ActiveYN = 'N', dto.LastUpdated = now(), dto.UpdatedBy = userID1
where hto.OrderID = orderID1;
end