482: into l_user_name
483: from fnd_registrations r
484: where r.registration_id = p_registration_id;
485:
486: l_testname := FND_USER_PKG.TestUserName(l_user_name);
487: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
488: lv_unencrypted_password := NULL;
489: END IF;
490:
483: from fnd_registrations r
484: where r.registration_id = p_registration_id;
485:
486: l_testname := FND_USER_PKG.TestUserName(l_user_name);
487: IF (l_testname = FND_USER_PKG.USER_SYNCHED) THEN
488: lv_unencrypted_password := NULL;
489: END IF;
490:
491: RETURN lv_unencrypted_password;
1323: RETURN;
1324: END IF;
1325:
1326: l_user_in_oid := 'N';
1327: if (FND_USER_PKG.TestUserName(l_rec.requested_user_name) = FND_USER_PKG.USER_SYNCHED) then
1328: l_user_in_oid := 'Y';
1329: end if;
1330:
1331: -- create supplier user account