Oracle EBS FND User Info API
时间:2022-03-10 17:32
1. 与用户信息相关API PKG.
;
;
;
2. 激活失效用户帐号.
-----------------------------
-----------------------------
;
DECLARE
BEGIN
(
‘QWR01‘
NULL
SYSDATE
);
--FND_USER_PKG.DisableUser(‘QWR01‘);
END;
DECLARE
IS
);
NUMBER;
BEGIN
;
LOOP
);
;
LOOP;
);
END;
---------------
---------------
DECLARE
IS
)
);
NUMBER;
BEGIN
;
LOOP
);
;
LOOP;
COMMIT;
);
END;
3. 激活失效用户职责.
;
;
---------------------
---------------------
DECLARE
IS
1
NULL)
)
)
‘QWR01‘
‘XYG-WH-WCB-OM-QUERY‘
;
NUMBER;
BEGIN
;
;
LOOP
);
;
LOOP;
COMMIT;
);
END;
4. 用户密码相关.
;
;
;
declare
);
);
);
begin
);
);
);
end;
declare
);
begin
);
);
--fnd_user_pkg.setreencryptedpassword(‘QWR01‘, newpass, ‘NEWKEY‘);
end;
Oracle EBS FND User Info API,布布扣,bubuko.com