pears.IQXNetSetPhones [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.IQXNetSetPhones ======
<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"."IQXNetSetPhones"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "pWebUserID" char(20),in "cpe" char(2),in "ptype" char(25),in "snumber" char(250) ) 
begin -- For phones for web logins which link to multiple company employments
  for "emploop" as "empcur" no scroll cursor for
    select "employmentid","personid" from "iqxnetuserlink" where "iqxnetuserid" = "pWebUserID" for read only do
    if "cpe" = 'P' and "personid" is not null then
      call "SetPhone"("cpe","ptype","personid","snumber")
    else if "employmentid" is not null then
        call "SetPhone"("cpe","ptype","employmentid","snumber")
      end if
    end if
  end for
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXNetSetPhones" IS 
{create procedure IQXNetSetPhones 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in pWebUserID char(20),in cpe char(2),in ptype char(25),in snumber char(250))
begin -- For phones for web logins which link to multiple company employments
  for emploop as empcur no scroll cursor for
    select employmentid,personid from iqxnetuserlink where iqxnetuserid = pWebUserID for read only do
    if cpe = 'P' and personid is not null then
      call SetPhone(cpe,ptype,personid,snumber)
    else if employmentid is not null then
        call SetPhone(cpe,ptype,employmentid,snumber)
      end if
    end if end for
end
}
</code>