I am developing a ticketing application and using custom authentication using below function.



create or replace FUNCTION user_Auth(p_username IN VARCHAR2,
p_password IN VARCHAR2)
RETURN BOOLEAN IS
lv_char CHAR(1);
lv_cnt NUMBER;
BEGIN
SELECT 'x'
INTO lv_char
FROM people
WHERE upper(p_username) = upper(username)
AND p_password = password;
apex_util.set_authentication_result(0);
RETURN TRUE;

EXCEPTION
WHEN OTHERS THEN
apex_util.set_authentication_result(4);
RETURN FALSE;
END user_Auth;

As of now it takes username and password from people table, which i use in my login page.

Can i customize it further so that whenever there is a new user created in people, that user is prompted to set his own password and after setting,that password is automatically stored in people table??