-- apps_transaction.upKonfirmasi (PROCEDURE)
begin
update header_transaction_owner1 set UpdatedBy = userID1, StatusOrderID = 5, 
ApprovedDate = NOW(), LastUpdated = now(), ApprovedID = userID1
where OrderID = orderID1;
end