APPS.FND_RANDOM_NUMBER dependencies on FND_RAND_STATES

Line 144: from FND_RAND_STATES

140: X_POOL(16), X_POOL(17), X_POOL(18), X_POOL(19), X_POOL(20),
141: X_POOL(21), X_POOL(22), X_POOL(23), X_POOL(24), X_POOL(25),
142: X_POOL(26), X_POOL(27), X_POOL(28), X_POOL(29), X_POOL(30),
143: X_POOL(31), X_POOL(32)
144: from FND_RAND_STATES
145: where LOCK_ID = 1
146: for update;
147: -- Merge as much entropy as available into the pools
148: for X_COUNT in 1..32 loop

Line 157: update FND_RAND_STATES

153: end if;
154: end loop;
155: -- Update the pools and event counter
156: X_EVENTS := X_EVENTS + M_EVENTS;
157: update FND_RAND_STATES
158: set EVENT_COUNT = X_EVENTS,
159: POOL0 = X_POOL(1),
160: POOL1 = X_POOL(2),
161: POOL2 = X_POOL(3),

Line 239: from FND_RAND_STATES

235: X_POOL(16), X_POOL(17), X_POOL(18), X_POOL(19), X_POOL(20),
236: X_POOL(21), X_POOL(22), X_POOL(23), X_POOL(24), X_POOL(25),
237: X_POOL(26), X_POOL(27), X_POOL(28), X_POOL(29), X_POOL(30),
238: X_POOL(31), X_POOL(32)
239: from FND_RAND_STATES
240: where LOCK_ID = 1
241: for update;
242: -- Draw entropy from the pools
243: X_ENTROPY := null;

Line 271: update FND_RAND_STATES

267: X_COUNTER := X_COUNTER + 1;
268: end if;
269: -- Update the reseed counter, key, and entropy;
270: -- set the last sequence to 0 to force a re-initialization to occur
271: update FND_RAND_STATES
272: set LAST_SEQUENCE = 0,
273: EVENT_COUNT = 0,
274: RESEED_COUNTER = X_COUNTER,
275: RANDOM_KEY = X_KEY,

Line 334: from FND_RAND_STATES

330: begin
331: -- Re-fetch the row to lock it for update
332: select LAST_SEQUENCE, RANDOM_KEY
333: into X_LASTCOUNT, M_KEY
334: from FND_RAND_STATES
335: where LOCK_ID = 1
336: for update;
337: -- Recheck it to make sure we need to update it; it's possible
338: -- that another process beat us to it.

Line 365: update FND_RAND_STATES

361: -- Used the first 4 randoms from this block to regenerate the key
362: -- (one value was discarded to stay on an even count)
363: M_NUM_RANDOMS := C_BLOCK_SIZE - 4;
364: -- Update the counter and key
365: update FND_RAND_STATES
366: set LAST_SEQUENCE = X_LASTCOUNT,
367: RANDOM_KEY = X_NEWKEY
368: where LOCK_ID = 1;
369: commit;

Line 397: from FND_RAND_STATES

393: begin
394: -- Get the current state of the random counter and key
395: select LAST_SEQUENCE, RANDOM_KEY, FND_RAND_S.NEXTVAL
396: into X_LASTCOUNT, M_KEY, M_COUNTER
397: from FND_RAND_STATES
398: where LOCK_ID = 1;
399: if ((X_LASTCOUNT = 0) or (M_COUNTER < X_LASTCOUNT) or
400: ((M_COUNTER - X_LASTCOUNT) >= C_REKEY_SIZE)) then
401: -- If the sequence has advanced enough, recompute the key

Line 481: from FND_RAND_STATES

477: begin
478: X_ENTROPY := GENERATE_ENTROPY(P_ENTROPY=>P_E);
479: select RANDOM_KEY
480: into X_NEWKEY
481: from FND_RAND_STATES
482: where LOCK_ID = 1
483: for update;
484: X_NEWKEY := DBMS_OBFUSCATION_TOOLKIT.MD5(
485: INPUT => UTL_RAW.CONCAT(X_NEWKEY,X_ENTROPY));

Line 491: update FND_RAND_STATES

487: UTL_RAW.CONCAT(X_NEWKEY,
488: DBMS_OBFUSCATION_TOOLKIT.MD5(
489: INPUT => UTL_RAW.CONCAT(X_NEWKEY, X_NEWKEY))),
490: 1, 24);
491: update FND_RAND_STATES
492: set RANDOM_KEY = X_NEWKEY,
493: LAST_SEQUENCE = 0
494: where LOCK_ID = 1;
495: commit;