119: into l_key
120: from ICX_SESSIONS
121: where SESSION_ID = p_session_id;
122:
123: l_mac := fnd_crypto.mac(source => l_source,
124: mac_type => fnd_crypto.HMAC_MD5,
125: key => l_key);
126:
127: return fnd_crypto.encode(source => l_mac,
120: from ICX_SESSIONS
121: where SESSION_ID = p_session_id;
122:
123: l_mac := fnd_crypto.mac(source => l_source,
124: mac_type => fnd_crypto.HMAC_MD5,
125: key => l_key);
126:
127: return fnd_crypto.encode(source => l_mac,
128: fmt_type => fnd_crypto.ENCODE_URL);
123: l_mac := fnd_crypto.mac(source => l_source,
124: mac_type => fnd_crypto.HMAC_MD5,
125: key => l_key);
126:
127: return fnd_crypto.encode(source => l_mac,
128: fmt_type => fnd_crypto.ENCODE_URL);
129:
130: exception
131: when no_data_found then
124: mac_type => fnd_crypto.HMAC_MD5,
125: key => l_key);
126:
127: return fnd_crypto.encode(source => l_mac,
128: fmt_type => fnd_crypto.ENCODE_URL);
129:
130: exception
131: when no_data_found then
132: l_mac := NULL;