14: into fuid
15: from dual;
16:
17: -- Get a random number
18: fnd_random_pkg.init(7);
19: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, false);
20: frand := fnd_random_pkg.get_next;
21:
22: -- Compute CRC32 of the random number and the sequence number,
15: from dual;
16:
17: -- Get a random number
18: fnd_random_pkg.init(7);
19: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, false);
20: frand := fnd_random_pkg.get_next;
21:
22: -- Compute CRC32 of the random number and the sequence number,
23: -- this creates a self-checking value.
16:
17: -- Get a random number
18: fnd_random_pkg.init(7);
19: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, false);
20: frand := fnd_random_pkg.get_next;
21:
22: -- Compute CRC32 of the random number and the sequence number,
23: -- this creates a self-checking value.
24: rval := lpad(to_char(frand),10,'0')||lpad(to_char(fuid),10,'0');