eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
46: -- characters. Hence using fnd_crypto.RandomString to generate alpha numeric
47: -- string as XSID.
48: l_XSID := fnd_crypto.RandomString(len=>26,

Line 46: -- characters. Hence using fnd_crypto.RandomString to generate alpha numeric

42: begin
43:
44: -- l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
45: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
46: -- characters. Hence using fnd_crypto.RandomString to generate alpha numeric
47: -- string as XSID.
48: l_XSID := fnd_crypto.RandomString(len=>26,
49: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
50:

Line 48: l_XSID := fnd_crypto.RandomString(len=>26,

44: -- l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
45: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
46: -- characters. Hence using fnd_crypto.RandomString to generate alpha numeric
47: -- string as XSID.
48: l_XSID := fnd_crypto.RandomString(len=>26,
49: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
50:
51: loop
52:

Line 49: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);

45: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
46: -- characters. Hence using fnd_crypto.RandomString to generate alpha numeric
47: -- string as XSID.
48: l_XSID := fnd_crypto.RandomString(len=>26,
49: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
50:
51: loop
52:
53: select 'Y' into x_XSID from icx_sessions

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

54: where XSID = l_XSID;
55:
56: if x_XSID = 'Y'
57: then
58: -- l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
59: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
60: -- characters. Hence using fnd_crypto.RandomString to generate
61: -- alpha numeric string as XSID.
62: l_XSID := fnd_crypto.RandomString(len=>26,

Line 60: -- characters. Hence using fnd_crypto.RandomString to generate

56: if x_XSID = 'Y'
57: then
58: -- l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
59: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
60: -- characters. Hence using fnd_crypto.RandomString to generate
61: -- alpha numeric string as XSID.
62: l_XSID := fnd_crypto.RandomString(len=>26,
63: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
64: else

Line 62: l_XSID := fnd_crypto.RandomString(len=>26,

58: -- l_XSID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
59: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
60: -- characters. Hence using fnd_crypto.RandomString to generate
61: -- alpha numeric string as XSID.
62: l_XSID := fnd_crypto.RandomString(len=>26,
63: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
64: else
65: -- return(l_XSID||':S');
66: return(l_XSID);

Line 63: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);

59: -- Bug#4192742. XSID which is stored as cookie value can't contain illegal
60: -- characters. Hence using fnd_crypto.RandomString to generate
61: -- alpha numeric string as XSID.
62: l_XSID := fnd_crypto.RandomString(len=>26,
63: msk=> FND_CRYPTO_CONSTANTS.ALPHANUMERIC_MASK);
64: else
65: -- return(l_XSID||':S');
66: return(l_XSID);
67: end if;

Line 85: l_transaction_id := fnd_crypto.SmallRandomNumber;

81: x_transaction_id varchar2(1) := 'N';
82:
83: begin
84:
85: l_transaction_id := fnd_crypto.SmallRandomNumber;
86:
87: loop
88:
89: select 'Y' into x_transaction_id from icx_transactions

Line 94: l_transaction_id := fnd_crypto.SmallRandomNumber;

90: where transaction_id = l_transaction_id;
91:
92: if x_transaction_id = 'Y'
93: then
94: l_transaction_id := fnd_crypto.SmallRandomNumber;
95: else
96: return(l_transaction_id);
97: end if;
98:

Line 116: l_transaction_id := fnd_crypto.SmallRandomNumber;

112: x_transaction_id varchar2(1) := 'N';
113:
114: begin
115:
116: l_transaction_id := fnd_crypto.SmallRandomNumber;
117:
118: loop
119:
120: select 'Y' into x_transaction_id from icx_transactions

Line 127: l_transaction_id := fnd_crypto.SmallRandomNumber;

123: and DISABLED_FLAG <> 'Y';
124:
125: if x_transaction_id = 'Y'
126: then
127: l_transaction_id := fnd_crypto.SmallRandomNumber;
128: else
129: return(l_transaction_id);
130: end if;
131:

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

143: x_XTID varchar2(1);
144:
145: begin
146:
147: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
148:
149: loop
150:
151: select 'Y' into x_XTID from icx_transactions

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

152: where XTID = l_XTID;
153:
154: if x_XTID = 'Y'
155: then
156: l_XTID := fnd_crypto.encode(fnd_crypto.RandomBytes(18),fnd_crypto.ENCODE_URL);
157: else
158: return(l_XTID||':T');
159: end if;
160:

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

490:
491: -- fetch values for the encryption keys
492: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
493: if ( l_mac_key is null or l_enc_key is null ) then
494: l_enc_key := fnd_crypto.RandomBytes(32);
495: l_mac_key := fnd_crypto.RandomBytes(20);
496: end if;
497:
498: insert into icx_sessions (

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

491: -- fetch values for the encryption keys
492: get_fixed_sec_keys(p_user_id, l_mac_key, l_enc_key);
493: if ( l_mac_key is null or l_enc_key is null ) then
494: l_enc_key := fnd_crypto.RandomBytes(32);
495: l_mac_key := fnd_crypto.RandomBytes(20);
496: end if;
497:
498: insert into icx_sessions (
499: session_id,