====== pears.NetClientRequirementSiteDetails ======
<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"."NetClientRequirementSiteDetails"( in "pWebUserID" char(20),in "pRowID" char(20),in "pIsShift" smallint ) 
result( 
  "Role" char(35),
  "SiteName" char(50),
  "SiteContact" char(100),
  "addr1" char(40),
  "addr2" char(40),
  "addr3" char(40),
  "town" char(30),
  "county" char(30),
  "country" char(30),
  "postcode" char(20),
  "SitePhoneNumbers" char(100),
  "SiteFax" char(50),
  "SiteEmail" char(100),
  "VacancyID" char(20) ) 
begin
  declare @VacancyID char(20);
  if "IQXNetHasPermission"("pWebUserID",'ORDERJOBS') = 0 then
    return
  end if;
  if "pIsShift" = 1 then
    set @VacancyID = (select "VacancyID" from "tempshiftplan" as "t" where "t"."tempshiftplanid" = "pRowID")
  else
    set @VacancyID = "pRowID"
  end if;
  select "v"."Role",
    "v"."Sitename",
    "v"."SiteContact",
    "v"."addr1",
    "v"."addr2",
    "v"."addr3",
    "v"."town",
    "v"."county",
    "v"."country",
    "v"."postcode",
    "v"."SitePhoneNumbers",
    "v"."SiteFax",
    "v"."SiteEmail",
    @VacancyID
    from "vacancy" as "v"
    where "v"."vacancyid" = @VacancyID
end /* DOC
28-11-2019 GJ Created IW-1044
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientRequirementSiteDetails" IS 
{create PROCEDURE pears."NetClientRequirementSiteDetails"( IN pWebUserID CHAR(20), IN pRowID CHAR(20), IN pIsShift SMALLINT ) 
RESULT( 
    Role CHAR(35),
    SiteName CHAR(50),
    SiteContact CHAR(100),
    addr1 CHAR(40),
    addr2 CHAR(40),
    addr3 CHAR(40),
    town CHAR(30),
    county CHAR(30),
    country CHAR(30),
    postcode CHAR(20),
    SitePhoneNumbers CHAR(100),
    SiteFax CHAR(50),
    SiteEmail CHAR(100),
    VacancyID CHAR(20)
) 
BEGIN   
    DECLARE @VacancyID CHAR(20);
    
    IF IQXNetHasPermission(pWebUserID,'ORDERJOBS') = 0 THEN
        RETURN;
    END IF;
    
    IF pIsShift = 1 THEN
        SET @VacancyID = (SELECT VacancyID FROM tempshiftplan t WHERE t.tempshiftplanid = pRowID);
    ELSE
        SET @VacancyID = pRowID
    END IF;
    
    SELECT
        v.Role,
        v.Sitename,
        v.SiteContact,
        v.addr1,
        v.addr2,
        v.addr3,
        v.town,
        v.county,
        v.country,
        v.postcode,
        v.SitePhoneNumbers,
        v.SiteFax,
        v.SiteEmail,
        @VacancyID
    FROM
        vacancy v
    WHERE 
        v.vacancyid = @VacancyID;
END
/* DOC
    28-11-2019 GJ Created IW-1044
*/
}
</code>