package (param1,param2,param3)
   Procedure A (param1, param2, param3)
   	Procedure B (Param1,param2)
   	Procedure C (Param1, param3)
   		Procedure D(param1, param2,param3)
   end;

 1.pass param4 in the query as IN clause
    like suppose someone select emp1, emp4,emp5 then 
    my query replaced like
    select * from emp
    where deptId =<param1> 
    ...
    and empid in (param4);
    
2. How to map the data into in clause
   BEGIN
     	 rec_grp_id := FIND_GROUP(group_name);
     	 grp_col_id := FIND_COLUMN(group_name||'.'||coll_name);
     	 ln_update := 0;
   	
   	
   	 IF ID_NULL(FIND_GROUP(group_name)) THEN		--B
   				message('Select transactions to reprocess');	
     	 	  		
   	 ELSE
   		 IF GET_GROUP_ROW_COUNT(rec_grp_id) > 0 THEN
   					for i in 1..GET_GROUP_ROW_COUNT(rec_grp_id) loop --A
   						
     	 	  		  tpp_id_tbl(i) := GET_GROUP_NUMBER_CELL(grp_col_id ,i);
    	 	  		 	package(param1,param2,param3,param4)
     	 	  	end loop; --A
      	   		    	 	  		
      	 ELSE
     	 	message('Select transactions to reprocess');	
     	 	  
      	 END IF;
   
      END IF;		--B
   		 
   END REPROCESS;