26: rows := dbms_sql.fetch_rows(curs);
27: dbms_sql.column_value(curs, 1, guid);
28: dbms_sql.close_cursor(curs);
29:
30: fnd_random_pkg.init(7);
31: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, FALSE);
32: rnd_dt:=Substr((To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)),0,32);
33: RETURN guid||rnd_dt;
34: END;
27: dbms_sql.column_value(curs, 1, guid);
28: dbms_sql.close_cursor(curs);
29:
30: fnd_random_pkg.init(7);
31: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, FALSE);
32: rnd_dt:=Substr((To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)),0,32);
33: RETURN guid||rnd_dt;
34: END;
35:
28: dbms_sql.close_cursor(curs);
29:
30: fnd_random_pkg.init(7);
31: fnd_random_pkg.seed(to_number(to_char(sysdate, 'JSSSSS')), 10, FALSE);
32: rnd_dt:=Substr((To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)||To_char(fnd_random_pkg.get_next)),0,32);
33: RETURN guid||rnd_dt;
34: END;
35:
36: /* get_platform_code