APPS.OKS_AUTO_REMINDER dependencies on DBMS_RANDOM

Line 374: (DBMS_RANDOM.STRING

370: -- Bug fix 4228115
371: CURSOR l_password_csr
372: IS
373: SELECT CONCAT
374: (DBMS_RANDOM.STRING
375: ('l',
376: (NVL
377: (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
378: 7) -

Line 381: ROUND (DBMS_RANDOM.VALUE (100, 999)))

377: (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
378: 7) -
379: 3
380: )),
381: ROUND (DBMS_RANDOM.VALUE (100, 999)))
382: FROM DUAL;
383:
384: l_return_status VARCHAR2 (1)
385: := okc_api.g_ret_sts_success;

Line 471: DBMS_RANDOM.STRING

467: IF l_test_user = 0
468: THEN
469: -- ok to create a new user
470: x_password :=
471: DBMS_RANDOM.STRING
472: ('l',
473: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
474: 7) -
475: 3

Line 477: ROUND (DBMS_RANDOM.VALUE (100, 999));

473: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
474: 7) -
475: 3
476: )) ||
477: ROUND (DBMS_RANDOM.VALUE (100, 999));
478: l_user_id :=
479: fnd_user_pkg.createuseridparty
480: (x_user_name => UPPER
481: (TRIM

Line 3250: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||

3246: IF l_test_user = 0
3247: THEN
3248: -- ok to create a new user
3249: /*
3250: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||
3251: round(dbms_random.value(100,999));
3252: */
3253:
3254: -- log file

Line 3251: round(dbms_random.value(100,999));

3247: THEN
3248: -- ok to create a new user
3249: /*
3250: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||
3251: round(dbms_random.value(100,999));
3252: */
3253:
3254: -- log file
3255: fnd_file.put_line