CREATE OR REPLACE FUNCTION SF_SST_GHSFYM(P_GHHBID varchar2)
return  number is   --1:正常 0:满。
-- MODIFICATION HISTORY
-- Person      Date         Comments
-- zhangyc     2014.05.05   create
   LS_COUNT0  number(10);
   COUNT1  number(10);
   LS_RETURN  number(10);
   LS_ERRORS  varchar2(40);
   P_ERRMSG   varchar2(200);
   LS_GHXHS0  SF_YSGHHB.GHXHS0%type;
   LS_GHYGHS  SF_YSGHHB.GHYGHS%type;
begin
  LS_COUNT0:=0; --计数
  LS_RETURN:=0;
  COUNT1:=0;

  IF 1=0 THEN
   begin
  select GHXHS0,GHYGHS into LS_GHXHS0,LS_GHYGHS from SF_YSGHHB where GHHBID=P_GHHBID ;
 exception
    when others then
     LS_GHXHS0:=0;
     LS_GHYGHS:=0;
  end;
  if (LS_GHXHS0>0) and (LS_GHYGHS>=LS_GHXHS0) then
    LS_RETURN:=0;
  else
    LS_RETURN:=1;
  end if;
  ELSE
  BEGIN
  select COUNT(1) into COUNT1 from YS_HBHZXH where GHHBID=to_number(P_GHHBID) and YYBZ00='1' and BRID00 is null;
   exception
    when others then
     COUNT1:=0;
     END;
   if COUNT1<1 then
    LS_RETURN:=0;
  else
    LS_RETURN:=1;
  end if;
    END IF;
return  LS_RETURN;

exception
  when no_data_found then
      P_ERRMSG:=substrb(P_ERRMSG||'判断医生的挂号是否已满失败！'||SQLERRM||'错误位置:'||Ls_Errors,1,255);
    when others then
      P_ERRMSG:=substrb(P_ERRMSG||'判断医生的挂号是否已满失败！'||SQLERRM||'错误位置:'||Ls_Errors,1,255);
end;