APPS.FND_OAM_METALINK_CREDS dependencies on FND_CRYPTO

Line 55: v_key := fnd_crypto.randombytes(24);

51:
52: select user_id into v_userid
53: from fnd_user where upper(user_name) = upper(p_username);
54:
55: v_key := fnd_crypto.randombytes(24);
56:
57: --
58: -- Note: The call to utl_raw.cast_to_raw as coded below
59: -- may cause problems if database characterset changes.

Line 67: v_encr := fnd_crypto.encrypt(

63: -- plaintext => utl_raw.cast_to_raw(
64: -- convert(p_metalink_password, 'AL32UTF8'));
65: --
66:
67: v_encr := fnd_crypto.encrypt(
68: plaintext => utl_raw.cast_to_raw(p_metalink_password),
69: key => v_key);
70: v_dec := v_key || v_encr;
71: v_enc := fnd_crypto.encode(

Line 71: v_enc := fnd_crypto.encode(

67: v_encr := fnd_crypto.encrypt(
68: plaintext => utl_raw.cast_to_raw(p_metalink_password),
69: key => v_key);
70: v_dec := v_key || v_encr;
71: v_enc := fnd_crypto.encode(
72: source => v_dec,
73: fmt_type => fnd_crypto.ENCODE_B64);
74:
75:

Line 73: fmt_type => fnd_crypto.ENCODE_B64);

69: key => v_key);
70: v_dec := v_key || v_encr;
71: v_enc := fnd_crypto.encode(
72: source => v_dec,
73: fmt_type => fnd_crypto.ENCODE_B64);
74:
75:
76: begin
77: select user_id into v_userid

Line 166: v_dec := fnd_crypto.decode(

162: fnd_user fu
163: where fu.user_id = fom.user_id
164: and upper(fu.user_name) = upper(p_username);
165:
166: v_dec := fnd_crypto.decode(
167: source => v_enc,
168: fmt_type => fnd_crypto.ENCODE_B64);
169: v_key := utl_raw.substr(v_dec, 1, 24);
170: v_encr := utl_raw.substr(v_dec, 25);

Line 168: fmt_type => fnd_crypto.ENCODE_B64);

164: and upper(fu.user_name) = upper(p_username);
165:
166: v_dec := fnd_crypto.decode(
167: source => v_enc,
168: fmt_type => fnd_crypto.ENCODE_B64);
169: v_key := utl_raw.substr(v_dec, 1, 24);
170: v_encr := utl_raw.substr(v_dec, 25);
171:
172:

Line 184: p_metalink_password := utl_raw.cast_to_varchar2(fnd_crypto.decrypt(

180: -- (utl_raw.convert(src, userenv('language'),
181: -- 'AMERICAN_AMERICA.AL32UTF8'));
182: --
183:
184: p_metalink_password := utl_raw.cast_to_varchar2(fnd_crypto.decrypt(
185: cryptext => v_encr,
186: key => v_key));
187:
188: EXCEPTION