APPS.ICX_SEC dependencies on DBMS_RANDOM

Line 17: l_session_id := abs(dbms_random.random);

13: x_session_id varchar2(1);
14:
15: begin
16:
17: l_session_id := abs(dbms_random.random);
18:
19: loop
20:
21: select 'Y' into x_session_id from icx_sessions

Line 26: l_session_id := abs(dbms_random.random);

22: where session_id = l_session_id;
23:
24: if x_session_id = 'Y'
25: then
26: l_session_id := abs(dbms_random.random);
27: end if;
28: end loop;
29:
30: EXCEPTION

Line 38: dbms_random.terminate;

34: l_new_session_id := l_session_id;
35:
36: -- Moved terminare above return
37:
38: dbms_random.terminate;
39:
40: return(l_new_session_id);
41:
42: