-- apps_master.spRejectUpdateDocOutlet (PROCEDURE) BEGIN UPDATE apps_master.update_documents_owner SET ActionStatus = actStatus, ActionDate = NOW(), RejectReason = CASE WHEN reason = '' THEN NULL ELSE reason END, LastUpdated = NOW(), UpdatedBy = userid WHERE ID = id1 AND OutletID = outid; END