pears.NetTimesheetsTickInvoiced

CREATE PROCEDURE "pears"."NetTimesheetsTickInvoiced"( IN "pWebUserID" CHAR(20),IN "pTimesheetID" CHAR(20),IN "pTickValue" INTEGER ) 
RESULT( "retval" CHAR(50) ) 
-- 20121109 tick timesheet ExternalStatus
-- 20130213 derived from GenevaNetTimesheetsTickInvoiced
BEGIN
  DECLARE "returnval" CHAR(50);
  UPDATE "temptimesheet" AS "t" SET "t"."ExternalStatus" = "pTickValue" WHERE "t"."temptimesheetid" = "pTimesheetID";
  SELECT '0~success'
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetTimesheetsTickInvoiced" IS 
{CREATE PROCEDURE pears."NetTimesheetsTickInvoiced"( IN "pWebUserID" CHAR(20),IN "pTimesheetID" CHAR(20),IN "pTickValue" INTEGER ) 
RESULT( "retval" CHAR(50) ) 
-- 20121109 tick timesheet ExternalStatus
-- 20130213 derived from GenevaNetTimesheetsTickInvoiced
BEGIN
  DECLARE "returnval" CHAR(50);
  UPDATE "temptimesheet" AS "t" SET "t"."ExternalStatus" = "pTickValue" WHERE "t"."temptimesheetid" = "pTimesheetID";
  SELECT '0~success'
END
}