usp_approvetimesheet.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE OR REPLACE PROCEDURE usp_ApproveTimeSheet
(
   inTimeSheetID   CHAR,
   inManagerID     CHAR
)
AS

BEGIN
   UPDATE TimeSheets
      SET ApprovalDate = SYSDATE,
      ManagerID = inManagerID
      WHERE TimeSheetID = inTimeSheetID;
   EXCEPTION
      WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR( -20999,'Approve timesheet failed.');
      RETURN;
END;