Cancels a requested pickup. The pickup in question is specified by its ConfirmationNumber. Other input information that is related to the pickup will be fetched from the corresponding record in the Pickups table. A side effect of this procedure is that the pertinent record will be deleted from the Pickups table.
Procedure Specific Information
The stored procedure will examine the following tables for input:
The stored procedure will remove a record from the following table:
In order to execute this procedure, one must specify ConfirmationNumber, and Reason. See the example below:
EXECUTE CancelPickup ConfirmationNumber = '65527580142029', Reason = 'Change of Schedule.'
|ConfirmationNumber||String||Confirmation number of the pickup to be canceled.|
|Reason||String||Reason for cancellation.|
Result Set Columns
|Success||String||Success or failure.|