pears.NetAgencyCurrentRequirementCount

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."NetAgencyCurrentRequirementCount"( IN "pWebUserID" CHAR(20) ) 
RESULT( "pResult" INTEGER ) 
BEGIN
  SELECT "COUNT"()
    FROM "NetAgencyCurrentRequirementSearch"(
      "pWebUserID","pSlice" = 
      0,"pSliceSize" = 
      100000,"pLineID" = 
      '',"pStatus" = 
      'C',"pCompanyName" = 
      NULL,"pPermOrShift" = 
      NULL,"pPosition" = 
      NULL,"pRef" = 
      NULL,"pSearchStartDate" = 
      "dateformat"("dateadd"("day",-7,"today"()),'yyyy-mm-dd'),"pSearchEndDate" = 
      "dateformat"("dateadd"("day",7,"today"()),'yyyy-mm-dd'))
END /* DOC
2017-07-13 PC modified date format
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyCurrentRequirementCount" IS 
{CREATE PROCEDURE pears."NetAgencyCurrentRequirementCount"(pWebUserID CHAR(20))
RESULT(pResult INTEGER)
BEGIN
 
    SELECT COUNT(*) 
    FROM 
    "NetAgencyCurrentRequirementSearch"(
        pWebUserID,
        "pSlice" = 0,
        "pSliceSize" = 100000,
        "pLineID" = '',
        "pStatus" = 'C',
        "pCompanyName" = NULL,
        "pPermOrShift" = NULL,
        "pPosition" = NULL,
        "pRef" = NULL,
        "pSearchStartDate" = dateformat(dateadd(DAY,-7,today(*)), 'yyyy-mm-dd'),
        "pSearchEndDate" = dateformat(dateadd(DAY,7,today(*)), 'yyyy-mm-dd')
    )
END
 
/* DOC
    2017-07-13 PC modified date format
 
*/
}