select dept_name,address,phone into :x,:y,:z from dept
where dept_no=:dept_no

 
 P53_DEPTNO,P53_DNAME,P53_LOC,P53_COUNT

Set process point On Demand : Run this application process when requested by a page process

declare
      v_deptno number(10);
      v_dname varchar2(100);
      v_loc varchar2(100);
      v_count number(10):=0;
begin
    v_deptno:=wwv_flow.g_x01;

    SELECT DNAME,LOC INTO v_dname,v_loc 
    FROM DEPT WHERE DEPTNO=v_deptno;
  
    SELECT COUNT(*) INTO v_count from EMP
    WHERE DEPTNO=v_deptno;


  apex_util.set_session_state('P53_DNAME',v_dname); 
  apex_util.set_session_state('P53_LOC',v_loc); 
  apex_util.set_session_state('P53_COUNT',v_count); 
  apex_util.json_from_items('P53_DNAME:P53_LOC:P53_COUNT');
EXCEPTION
  WHEN NO_DATA_FOUND THEN
  NULL;
end;

<script type="text/javascript">
<!--
function disFormItems()
{
    $x_disableItem('P53_DNAME',true);
    $x_Style('P53_DNAME','background','yellow');
    $x_disableItem('P53_LOC',true);
    $x_Style('P53_LOC','background','yellow');
    $x_disableItem('P53_COUNT',true);
    $x_Style('P53_COUNT','background','yellow');



}

function f_dinfo(pValue)
{ 
     $x(document.getElementById('P53_LOC')).value='';
     $x(document.getElementById('P53_COUNT')).value='';
     $x(document.getElementById('P53_DNAME')).value='';

     var getData = new apex.ajax.ondemand('multipleAjax',
     function()
		   {
						
                        var rState = p.readyState;
			if(rState == 4)
			{ 
			  gReturn = p.responseText;
			  (gReturn)?json_SetItems(gReturn):null;
			}
			else if (rState==1||rState==2||rState==3)
                         {
                         }
                        else
			{
			return false;
			}
			}
                        );
  getData.ajax.addParam('x01',(!!pValue)?pValue:$v('P53_DEPTNO'));
  getData._get();
}
//-->
</script>

onload="disFormItems();"