Operation Details
Description: This method returns a count of the evidence Forms, which can be added to a given Integrated case. These are the forms associated with the IC Type, where no forms of that evidenceType have already been recorded.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  ProductEvidenceFormLink,
  EvidenceForm PRIMARYFORM,
  ProductCategory,
  Product 
WHERE 
  (
    ProductCategory.categoryCode = :integratedCaseType 
    AND Product.statusCode = :recordStatus 
    AND Product.productID = ProductCategory.productID 
  ) 
  AND ProductEvidenceFormLink.productID = Product.productID 
  AND ProductEvidenceFormLink.recordStatus = :recordStatus 
  AND PRIMARYFORM.evidenceFormID = ProductEvidenceFormLink.evidenceFormID 
  AND NOT EXISTS 
  ( 
  SELECT
    * 
  FROM
    CaseEvidence,
    CaseEvidenceType,
    EvidenceForm OTHERFORM 
  WHERE CaseEvidence.caseID = :caseID 
    AND CaseEvidenceType.evidenceID = CaseEvidence.evidenceID 
    AND OTHERFORM.evidenceNameCode = CaseEvidenceType.evidenceFormName 
    AND PRIMARYFORM.caseEvidenceType = OTHERFORM.caseEvidenceType 
  )