pears.NetClientRequirementSiteDetails

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original 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
*/
}