Code Listing 3: Encapsulating in a SQL query

 1  CREATE OR REPLACE PROCEDURE process_employee (
  2    employee_id_in IN employee.EMPLOYEE_ID%TYPE)
  3  IS
  4    l_name hr_employee_tp.fullname_t;
  5  BEGIN
  6    l_name :=
  7       hr_employee_rp.fullname (
  8          employee_id_in);
  9
 10    perform_detailed_analysis (
 11        l_name);
 12* END;