l_count number; begin select count(*) into l_count from usermaster where usertypeid in ( select usertypeid from usermaster where usertypeid !=1 and userid=:P9_USERID or userid=:new); if l_count > 0 then return true; else htp.p('<script language="javascript">'); htp.p('alert("Sorry! You dont have Permission to view other information")'); htp.p('window.location ="http://localhost:8080/apex/f?p=112:8:&SESSION.::NO::"'); htp.p('</script>'); return false; end if; end;
:new
... or userid=:new.userid ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)