CREATE FUNCTION apps.XX_decrypt_get_pwd (in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2
AS
LANGUAGE JAVA
NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String' ;
SELECT usr.user_name,
Xx_decrypt_get_pwd (
(SELECT (SELECT xx_decrypt_get_pwd (
fnd_web_sec.get_guest_username_pwd,
usertable.encrypted_foundation_password)
FROM DUAL)
AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name =
(SELECT SUBSTR (
fnd_web_sec.get_guest_username_pwd,
1,
INSTR (fnd_web_sec.get_guest_username_pwd,
'/')
- 1)
FROM DUAL)),
usr.encrypted_user_password)
PASSWORD
FROM fnd_user usr
WHERE usr.user_name = 'user_name';
in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2
AS
LANGUAGE JAVA
NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String' ;
SELECT usr.user_name,
Xx_decrypt_get_pwd (
(SELECT (SELECT xx_decrypt_get_pwd (
fnd_web_sec.get_guest_username_pwd,
usertable.encrypted_foundation_password)
FROM DUAL)
AS apps_password
FROM fnd_user usertable
WHERE usertable.user_name =
(SELECT SUBSTR (
fnd_web_sec.get_guest_username_pwd,
1,
INSTR (fnd_web_sec.get_guest_username_pwd,
'/')
- 1)
FROM DUAL)),
usr.encrypted_user_password)
PASSWORD
FROM fnd_user usr
WHERE usr.user_name = 'user_name';