•Validate Input (appropriate product, store)
•SELECT qty INTO :tmp
• FROM
InStore
• WHERE
StoreID = :store AND prodID = :product
•UPDATE Product
• SET
WarehouseQty = WarehouseQty + :tmp
• WHERE prodID
= :product
•UPDATE InStore
• SET Qty =
0
• WHERE prodID
= :product
•COMMIT