pears.NetClientRejectCandidateReason

CREATE PROCEDURE "pears"."NetClientRejectCandidateReason"( IN "pWebUserID" CHAR(20) ) 
RESULT( "value" CHAR(20),"descrip" CHAR(50) ) 
// IQXNet
BEGIN
  SELECT "rejectreasonid","reason" FROM "rejectionreason" ORDER BY "sortorder" ASC
END /* DOC
2016-12-08 PC supply a reason for rejecting a candidate from a placement
 
Inputs:
pWebUserID
 
Outputs:
value
descrip
 
Tests:
invalid pWebUserID
valid pWebUserID
*/
/* TEST
call NetTestSetup('');
insert into rejectionreason on existing update values ('TEST','test',0);
select top 1 * from NetClientRejectCandidateReason(null) where value='TEST';
expect value=TEST,descrip=test;
select top 1 * from NetClientRejectCandidateReason('test.client') where value='TEST';
expect value=TEST,descrip=test;
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetClientRejectCandidateReason" IS 
{CREATE PROCEDURE pears."NetClientRejectCandidateReason"(IN pWebUserID CHAR(20))
RESULT(VALUE CHAR(20),descrip CHAR(50))
// IQXNet
BEGIN
	SELECT rejectreasonid,reason FROM rejectionreason ORDER BY sortorder ASC;
END
 
/* DOC
2016-12-08 PC supply a reason for rejecting a candidate from a placement
 
Inputs:
    pWebUserID
 
Outputs:
    value
    descrip
 
Tests:
    invalid pWebUserID
    valid pWebUserID
*/
 
/* TEST
call NetTestSetup('');
insert into rejectionreason on existing update values ('TEST','test',0);
select top 1 * from NetClientRejectCandidateReason(null) where value='TEST';
expect value=TEST,descrip=test;
select top 1 * from NetClientRejectCandidateReason('test.client') where value='TEST';
expect value=TEST,descrip=test;
 
*/
}