Oracle FND api–create User

--api-fnd_user_pkg.createuser
--
--example--

-- --------------------------------------
--API to CREATE FND User
-- --------------------------------------

DECLARE
Lc_user_name VARCHAR2 (+): = ' quanweiru_test1 ';
Lc_user_password VARCHAR2 (+): = ' Oracle123 ';
Ld_user_start_date Date: = To_date (' 01-jun-2015 ');
Ld_user_end_date VARCHAR2 (+): = NULL;
Ld_password_date VARCHAR2 (+): = To_date (' 01-jun-2015 ');
Ld_password_lifespan_days number: = 90;
LN_PERSON_ID number: = 5022;
Lc_email_address VARCHAR2 (+): = ' [email protected] ';
BEGIN
Fnd_user_pkg.createuser (
X_user_name = Lc_user_name,
X_owner = NULL,
X_unencrypted_password = Lc_user_password,
X_start_date = Ld_user_start_date,
X_end_date = Ld_user_end_date,
X_password_date = Ld_password_date,
X_password_lifespan_days = Ld_password_lifespan_days,
x_employee_id = ln_person_id,
x_email_address = lc_email_address);

COMMIT;
EXCEPTION
When OTHERS
Then
ROLLBACK;
Dbms_output. Put_Line (SQLERRM);
END;

Oracle FND api–create User