--以下脚本于20180116在Tony环境实现
--创建用户并关联员工
--分配职责有单独脚本,不在此处赘述
-Oracle FND API–Create User
--API - fnd_user_pkg.createuser
--
--Example --
-- --------------------------------------
-- API to CREATE FND User
-- --------------------------------------
DECLARE
lc_user_name VARCHAR2 (100) := 'QUANWEIRU_TEST1';
lc_user_password VARCHAR2 (100) := 'Oracle123';
ld_user_start_date DATE := sysdate;
ld_user_end_date VARCHAR2 (100) := NULL;
ld_password_date VARCHAR2 (100) := sysdate;
ld_password_lifespan_days NUMBER := 90;
ln_person_id NUMBER := 67;
lc_email_address VARCHAR2 (100) := 'QUANWEIRU@KINWON.CN';
BEGIN
fnd_user_pkg.createuser (
--创建用户并关联员工
--分配职责有单独脚本,不在此处赘述
-Oracle FND API–Create User
--API - fnd_user_pkg.createuser
--
--Example --
-- --------------------------------------
-- API to CREATE FND User
-- --------------------------------------
DECLARE
lc_user_name VARCHAR2 (100) := 'QUANWEIRU_TEST1';
lc_user_password VARCHAR2 (100) := 'Oracle123';
ld_user_start_date DATE := sysdate;
ld_user_end_date VARCHAR2 (100) := NULL;
ld_password_date VARCHAR2 (100) := sysdate;
ld_password_lifespan_days NUMBER := 90;
ln_person_id NUMBER := 67;
lc_email_address VARCHAR2 (100) := 'QUANWEIRU@KINWON.CN';
BEGIN
fnd_user_pkg.createuser (