API to Create User

This Script will prompt for user name and employee name.

DECLARE

   v_session_id      INTEGER                         := USERENV ('sessionid');

   v_user_name       VARCHAR2 (30)                    := UPPER ('&User_Name');

   v_employee_name   per_all_people_f.full_name%TYPE      := '&employee_name';

   v_employee_id     NUMBER;

   v_email_address   per_all_people_f.email_address%TYPE;

BEGIN