DBA Data[Home] [Help]

APPS.IEM_ENCRYPT_TAGS_PVT dependencies on DBMS_RANDOM

Line 85: DBMS_RANDOM.INITIALIZE ( 8726527 );

81: raise IEM_AGENT_INTERACTION_ID_NULL;
82: end if;
83:
84: --Get random number and shorten it for 5 digits
85: DBMS_RANDOM.INITIALIZE ( 8726527 );
86: --l_ram := TO_CHAR( ABS(DBMS_RANDOM.Random) );
87: select to_char(fnd_crypto.randomnumber) into l_ram from dual;
88:
89: l_ram_len := LENGTH( l_ram );

Line 86: --l_ram := TO_CHAR( ABS(DBMS_RANDOM.Random) );

82: end if;
83:
84: --Get random number and shorten it for 5 digits
85: DBMS_RANDOM.INITIALIZE ( 8726527 );
86: --l_ram := TO_CHAR( ABS(DBMS_RANDOM.Random) );
87: select to_char(fnd_crypto.randomnumber) into l_ram from dual;
88:
89: l_ram_len := LENGTH( l_ram );
90: if l_ram_len < 5 then

Line 101: --DBMS_RANDOM.TERMINATE;

97: else
98: l_token := SUBSTR( l_ram, 1, 5 );
99: end if;
100:
101: --DBMS_RANDOM.TERMINATE;
102:
103: --get next sequential number
104: SELECT IEM_ENCRYPTED_TAGS_s1.nextval
105: INTO l_seq_id