create or replace procedure AK_seaarch_org_names5 (results out SYS_REFCURSOR)  
as  
  
  I_ORGANIZATION_ID NUMBER;  
  I_REQ_SSO_USER_ID VARCHAR2(200);  
  O_ORG_PROF_DTLS SYS_REFCURSOR;  
  O_ORG_PROF_DTLS1 SYS_REFCURSOR;  
   type nt_type is table of number;  
  nt nt_type := nt_type (143,88,141);  
  
  lv_org_number NUMBER;  
BEGIN  
 --   
  I_REQ_SSO_USER_ID := '28c200d0624fe559d381fb0032a7e97c';  
  for i in 1..nt.count loop  
    --dbms_output.put_line(nt(i));  
 I_ORGANIZATION_ID := nt(i);  
  PKG_MANAGE_ORGANIZAION_PROFILE.SP_GET_CM_ORG_PROF_PERM_DTLS(  
    I_ORGANIZATION_ID => I_ORGANIZATION_ID,  
    I_REQ_SSO_USER_ID => I_REQ_SSO_USER_ID,  
    O_ORG_PROF_DTLS => O_ORG_PROF_DTLS  
   );  
   END LOOP;   
  
  
END AK_seaarch_org_names5 ;