ID정보를 입력하면 해당 ID의 이름을 갖고옴


<script language="JavaScript1.1" type="text/javascript">
function GET_SNATIVE_NM_P1() 
{
var ajaxRequestN = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=GET_SNATIVE_NM_P1',0);
  ajaxRequestN.add('P1_LEAD_ID',document.getElementById('P1_LEAD_ID').value);
  ajaxResultN = ajaxRequestN.get();

if (ajaxResultN.indexOf("sqlerrm") >= 0)
  {
   document.getElementById('P1_LEAD_ID').value = '*******';
  }
  else
  {
   document.getElementById('P1_LEAD_NAME').value = ajaxResultN;
  }
   ajaxRequestN = null;
}

</script>


--------------------------------------------------------------

이름을 입력하면 해당되는 사람의 ID정보 LIST를 볼수 있는 기능


<script language="JavaScript1.1" type="text/javascript">
function getMemberList ()
{
  var ajaxRequest = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=GET_NAME_ALL_P1',0);
  ajaxRequest.add('P1_LEAD_NAME',html_GetElement('P1_LEAD_NAME').value);
  ajaxResult = ajaxRequest.get();
  if(ajaxResult)
    {  html_GetElement('MemberListDiv').innerHTML = ajaxResult  }
    else
    {  html_GetElement('MemberListDiv').innerHTML = 'null'  }
  ajaxRequest = null;
}
</script>


======================================================================

 Shared Components 의 Application Processes


GET_NAME_ALL_P1            

declare
  lv_Name_List varchar2(30000) := '';

begin
  begin
    for i in (Select SNATIVE_NM, SMEMBER_ID, SGROUP_ID, STELPERSONAL from VIEW_CHURCHMEMBER
        where Upper(SNATIVE_NM)   like upper(:P1_LEAD_NAME) || '%' 
order by     SNATIVE_NM)
    loop
      lv_Name_List := lv_Name_List || i.SNATIVE_NM   || '*' || i.SMEMBER_ID  || '*' ||  '#' || i.SGROUP_ID || '*' || case when substr(I.STELPERSONAL, 1,3) = '111' then ' '  else to_char (i.STELPERSONAL) end ||  '<br />';
    end loop;

  exception when no_data_found then null;
    when others
     then
        null;

  end;
  htp.prn(lv_Name_List);
end;

---------------------------------------------------------------------

GET_SNATIVE_NM_P1


declare
  lv_Member_List varchar2(30000) := '';
BEGIN
  begin
   select SNATIVE_NM into lv_Member_List from VIEW_CHURCHMEMBER where upper (SMEMBER_ID)  = upper (:P1_LEAD_ID)  ;

      exception when no_data_found then null;
  end;
  htp.prn(lv_Member_List);
end;


==============================================

* Application Processes GET_NAME_ALL_P1    이 실행되는 item의 Region Source

<div id="MemberListDiv"> </div>