====== pears.NetAgencyCurrentRequirementCount ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code 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

*/
}
</code>