APPS.FND_RANDOM_NUMBER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 131

    select EVENT_COUNT,
           POOL0,  POOL1,  POOL2,  POOL3,  POOL4,  POOL5,  POOL6,  POOL7,
           POOL8,  POOL9,  POOL10, POOL11, POOL12, POOL13, POOL14, POOL15,
           POOL16, POOL17, POOL18, POOL19, POOL20, POOL21, POOL22, POOL23,
           POOL24, POOL25, POOL26, POOL27, POOL28, POOL29, POOL30, POOL31
      into X_EVENTS,
           X_POOL(1),  X_POOL(2),  X_POOL(3),  X_POOL(4),  X_POOL(5),
           X_POOL(6),  X_POOL(7),  X_POOL(8),  X_POOL(9),  X_POOL(10),
           X_POOL(11), X_POOL(12), X_POOL(13), X_POOL(14), X_POOL(15),
           X_POOL(16), X_POOL(17), X_POOL(18), X_POOL(19), X_POOL(20),
           X_POOL(21), X_POOL(22), X_POOL(23), X_POOL(24), X_POOL(25),
           X_POOL(26), X_POOL(27), X_POOL(28), X_POOL(29), X_POOL(30),
           X_POOL(31), X_POOL(32)
      from FND_RAND_STATES
     where LOCK_ID = 1
       for update;

Line: 157

    update FND_RAND_STATES
       set EVENT_COUNT = X_EVENTS,
           POOL0  = X_POOL(1),
           POOL1  = X_POOL(2),
           POOL2  = X_POOL(3),
           POOL3  = X_POOL(4),
           POOL4  = X_POOL(5),
           POOL5  = X_POOL(6),
           POOL6  = X_POOL(7),
           POOL7  = X_POOL(8),
           POOL8  = X_POOL(9),
           POOL9  = X_POOL(10),
           POOL10 = X_POOL(11),
           POOL11 = X_POOL(12),
           POOL12 = X_POOL(13),
           POOL13 = X_POOL(14),
           POOL14 = X_POOL(15),
           POOL15 = X_POOL(16),
           POOL16 = X_POOL(17),
           POOL17 = X_POOL(18),
           POOL18 = X_POOL(19),
           POOL19 = X_POOL(20),
           POOL20 = X_POOL(21),
           POOL21 = X_POOL(22),
           POOL22 = X_POOL(23),
           POOL23 = X_POOL(24),
           POOL24 = X_POOL(25),
           POOL25 = X_POOL(26),
           POOL26 = X_POOL(27),
           POOL27 = X_POOL(28),
           POOL28 = X_POOL(29),
           POOL29 = X_POOL(30),
           POOL30 = X_POOL(31),
           POOL31 = X_POOL(32)
      where LOCK_ID = 1;

Line: 226

    select LAST_SEQUENCE, RANDOM_KEY, RESEED_COUNTER, EVENT_COUNT,
           POOL0,  POOL1,  POOL2,  POOL3,  POOL4,  POOL5,  POOL6,  POOL7,
           POOL8,  POOL9,  POOL10, POOL11, POOL12, POOL13, POOL14, POOL15,
           POOL16, POOL17, POOL18, POOL19, POOL20, POOL21, POOL22, POOL23,
           POOL24, POOL25, POOL26, POOL27, POOL28, POOL29, POOL30, POOL31
      into X_SEQUENCE, X_KEY, X_COUNTER, X_EVENTS,
           X_POOL(1),  X_POOL(2),  X_POOL(3),  X_POOL(4),  X_POOL(5),
           X_POOL(6),  X_POOL(7),  X_POOL(8),  X_POOL(9),  X_POOL(10),
           X_POOL(11), X_POOL(12), X_POOL(13), X_POOL(14), X_POOL(15),
           X_POOL(16), X_POOL(17), X_POOL(18), X_POOL(19), X_POOL(20),
           X_POOL(21), X_POOL(22), X_POOL(23), X_POOL(24), X_POOL(25),
           X_POOL(26), X_POOL(27), X_POOL(28), X_POOL(29), X_POOL(30),
           X_POOL(31), X_POOL(32)
      from FND_RAND_STATES
     where LOCK_ID = 1
       for update;

Line: 271

    update FND_RAND_STATES
       set LAST_SEQUENCE = 0,
           EVENT_COUNT = 0,
           RESEED_COUNTER = X_COUNTER,
           RANDOM_KEY = X_KEY,
           POOL0  = X_POOL(1),
           POOL1  = X_POOL(2),
           POOL2  = X_POOL(3),
           POOL3  = X_POOL(4),
           POOL4  = X_POOL(5),
           POOL5  = X_POOL(6),
           POOL6  = X_POOL(7),
           POOL7  = X_POOL(8),
           POOL8  = X_POOL(9),
           POOL9  = X_POOL(10),
           POOL10 = X_POOL(11),
           POOL11 = X_POOL(12),
           POOL12 = X_POOL(13),
           POOL13 = X_POOL(14),
           POOL14 = X_POOL(15),
           POOL15 = X_POOL(16),
           POOL16 = X_POOL(17),
           POOL17 = X_POOL(18),
           POOL18 = X_POOL(19),
           POOL19 = X_POOL(20),
           POOL20 = X_POOL(21),
           POOL21 = X_POOL(22),
           POOL22 = X_POOL(23),
           POOL23 = X_POOL(24),
           POOL24 = X_POOL(25),
           POOL25 = X_POOL(26),
           POOL26 = X_POOL(27),
           POOL27 = X_POOL(28),
           POOL28 = X_POOL(29),
           POOL29 = X_POOL(30),
           POOL30 = X_POOL(31),
           POOL31 = X_POOL(32)
      where LOCK_ID = 1;

Line: 321

  procedure UPDATE_KEY(P_LASTCOUNT in number)
  is
  pragma AUTONOMOUS_TRANSACTION;

Line: 332

    select LAST_SEQUENCE, RANDOM_KEY
      into X_LASTCOUNT, M_KEY
      from FND_RAND_STATES
     where LOCK_ID = 1
       for update;

Line: 365

      update FND_RAND_STATES
         set LAST_SEQUENCE = X_LASTCOUNT,
             RANDOM_KEY = X_NEWKEY
      where LOCK_ID = 1;

Line: 378

  end UPDATE_KEY;

Line: 395

    select LAST_SEQUENCE, RANDOM_KEY, FND_RAND_S.NEXTVAL
      into X_LASTCOUNT, M_KEY, M_COUNTER
      from FND_RAND_STATES
     where LOCK_ID = 1;

Line: 402

      UPDATE_KEY(X_LASTCOUNT);

Line: 479

     select RANDOM_KEY
       into X_NEWKEY
       from FND_RAND_STATES
     where LOCK_ID = 1
       for update;

Line: 491

     update FND_RAND_STATES
       set RANDOM_KEY = X_NEWKEY,
           LAST_SEQUENCE = 0
     where LOCK_ID = 1;