APPS.FND_SESSION_MANAGEMENT dependencies on FND_CRYPTO

Line 15: l_session_id := fnd_crypto.SmallRandomNumber;

11: x_session_id varchar2(1) := 'N';
12:
13: begin
14:
15: l_session_id := fnd_crypto.SmallRandomNumber;
16:
17: loop
18:
19: select 'Y' into x_session_id from icx_sessions

Line 24: l_session_id := fnd_crypto.SmallRandomNumber;

20: where session_id = l_session_id;
21:
22: if x_session_id = 'Y'
23: then
24: l_session_id := fnd_crypto.SmallRandomNumber;
25: else
26: return(l_session_id);
27: end if;
28:

Line 44: l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);

40: x_XSID varchar2(1) := 'N';
41:
42: begin
43:
44: l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
45:
46: loop
47:
48: select 'Y' into x_XSID from icx_sessions

Line 53: l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);

49: where XSID = l_XSID;
50:
51: if x_XSID = 'Y'
52: then
53: l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
54: else
55: return(l_XSID||':S');
56: end if;
57:

Line 73: l_transaction_id := fnd_crypto.SmallRandomNumber;

69: x_transaction_id varchar2(1) := 'N';
70:
71: begin
72:
73: l_transaction_id := fnd_crypto.SmallRandomNumber;
74:
75: loop
76:
77: select 'Y' into x_transaction_id from icx_transactions

Line 82: l_transaction_id := fnd_crypto.SmallRandomNumber;

78: where transaction_id = l_transaction_id;
79:
80: if x_transaction_id = 'Y'
81: then
82: l_transaction_id := fnd_crypto.SmallRandomNumber;
83: else
84: return(l_transaction_id);
85: end if;
86:

Line 104: l_transaction_id := fnd_crypto.SmallRandomNumber;

100: x_transaction_id varchar2(1) := 'N';
101:
102: begin
103:
104: l_transaction_id := fnd_crypto.SmallRandomNumber;
105:
106: loop
107:
108: select 'Y' into x_transaction_id from icx_transactions

Line 115: l_transaction_id := fnd_crypto.SmallRandomNumber;

111: and DISABLED_FLAG <> 'Y';
112:
113: if x_transaction_id = 'Y'
114: then
115: l_transaction_id := fnd_crypto.SmallRandomNumber;
116: else
117: return(l_transaction_id);
118: end if;
119:

Line 135: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);

131: x_XTID varchar2(1);
132:
133: begin
134:
135: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
136:
137: loop
138:
139: select 'Y' into x_XTID from icx_transactions

Line 144: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);

140: where XTID = l_XTID;
141:
142: if x_XTID = 'Y'
143: then
144: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
145: else
146: return(l_XTID||':T');
147: end if;
148:

Line 453: l_enc_key := fnd_crypto.RandomBytes(32);

449:
450: -- fetch values for the encryption keys
451: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
452: if ( l_mac_key is null or l_enc_key is null ) then
453: l_enc_key := fnd_crypto.RandomBytes(32);
454: l_mac_key := fnd_crypto.RandomBytes(20);
455: end if;
456:
457: insert into icx_sessions (

Line 454: l_mac_key := fnd_crypto.RandomBytes(20);

450: -- fetch values for the encryption keys
451: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
452: if ( l_mac_key is null or l_enc_key is null ) then
453: l_enc_key := fnd_crypto.RandomBytes(32);
454: l_mac_key := fnd_crypto.RandomBytes(20);
455: end if;
456:
457: insert into icx_sessions (
458: session_id,