51.26 END_USER_ACCOUNT_DAYS_LEFT Function

This function returns the number of days remaining before an end user account password expires. This function may be run in a page request context by any authenticated user.

Syntax

APEX_UTIL.END_USER_ACCOUNT_DAYS_LEFT (
    p_user_name     IN VARCHAR2 );
RETURN NUMBER

Parameters

Table 51-24 END_USER_ACCOUNT_DAYS_LEFT Parameters

Parameter	Description
p_user_name	The user name of the user account.

Example

The following example determines the number of days remaining before an APEX end user account in the current workspace expires.

DECLARE
    l_days_left NUMBER;
BEGIN
    FOR c1 IN (SELECT user_name from apex_users) LOOP
        l_days_left := APEX_UTIL.END_USER_ACCOUNT_DAYS_LEFT(p_user_name => c1.user_name);
        htp.p('End User Account:'||c1.user_name||' expires in '||l_days_left||' days.');
    END LOOP;
END;

See Also:

• EXPIRE_END_USER_ACCOUNT Procedure
• UNEXPIRE_END_USER_ACCOUNT Procedure