6: l_XSID varchar2(32);
7: begin
8: select XSID
9: into l_XSID
10: from ICX_SESSIONS
11: where SESSION_ID = p_session_id;
12: if l_XSID is null
13: then
14: l_XSID := icx_call.encrypt3(p_session_id);
31: l_SessionID := icx_call.decrypt3(p_XSID);
32: else
33: select SESSION_ID
34: into l_SessionID
35: from ICX_SESSIONS
36: where XSID = p_XSID;
37: end if;
38:
39: return l_SessionID;
112: l_source := utl_raw.cast_to_raw(p_source);
113:
114: select MAC_KEY
115: into l_key
116: from ICX_SESSIONS
117: where SESSION_ID = p_session_id;
118:
119: l_mac := fnd_crypto.mac(source => l_source,
120: mac_type => fnd_crypto.HMAC_MD5,