DBA Data[Home] [Help]

APPS.FND_ORACLE_USER_PKG dependencies on FND_WEB_SEC

Line 38: ret :=fnd_web_sec.create_oracle_user(x_oracle_username,

34: end if;
35:
36: /* Java layer takes care of decrypting and encrypting password and */
37: /* store in table */
38: ret :=fnd_web_sec.create_oracle_user(x_oracle_username,
39: x_reencrypted_oracle_password,
40: 'LOADER',
41: ouser_id);
42: if (ret = 'Y') then

Line 132: enc_pwd := fnd_web_sec.cvt_reencrypted_oracle_pwd(

128: /* being encrypted with right key for storing it in the database */
129: /* (apps pwd) */
130: enc_pwd := x_encrypted_oracle_password;
131: if ((enc_pwd <> 'EXTERNAL') AND (enc_pwd <> 'INVALID')) then
132: enc_pwd := fnd_web_sec.cvt_reencrypted_oracle_pwd(
133: x_encrypted_oracle_password, 'LOADER');
134: end if;
135: if(enc_pwd is NULL) then
136: enc_pwd := 'INVALID';

Line 183: return (fnd_web_sec.get_reencrypted_oracle_pwd(username, newkey));

179: --
180: function GetReEncryptedPassword(username varchar2,
181: newkey varchar2) return varchar2 is
182: begin
183: return (fnd_web_sec.get_reencrypted_oracle_pwd(username, newkey));
184: end;
185:
186: end FND_ORACLE_USER_PKG;