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);
15: end if;
16:
17: return l_XSID;
18:
31: -- of length 26. Whereas the old method (encrypt3) always generates
32: -- the value in lengths of multiple of 16 (ex: 16,32,64)
33: if length(p_XSID) <> 26
34: then
35: l_SessionID := icx_call.decrypt3(p_XSID);
36: else
37: select SESSION_ID
38: into l_SessionID
39: from ICX_SESSIONS
68:
69: if (translate(p_XTID, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
70: 'xxxxxxxxxxxxxxxxxxxxxxxxxx') <> p_XTID)
71: then
72: l_TransactionID := icx_call.decrypt3(p_XTID);
73:
74: else
75:
76: select TRANSACTION_ID
85: exception
86: when no_data_found then
87: l_TransactionID := NULL;
88: when others then
89: l_TransactionID := icx_call.decrypt3(p_XTID);
90: */
91:
92:
93: exception