7.22 IS_BUSINESS_ADMIN Function

This function checks whether the given user is a business administrator for at least one task definition.

Syntax

APEX_APPROVAL.IS_BUSINESS_ADMIN (
    p_user              IN VARCHAR2 DEFAULT apex_application.g_user,
    p_application_id    IN NUMBER   DEFAULT NULL )
RETURN BOOLEAN;

Parameters

Table 7-13 IS_BUSINESS_ADMIN Parameters

Parameter Description
p_user The user to check for. Default is logged-in user.
p_application_id The application to check for. Default behavior checks against all applications in the workspace.

Returns

TRUE if the user given by p_user is at least in one task definition configured as participant type BUSINESS_ADMIN, FALSE otherwise.

Example

DECLARE
    l_is_business_admin boolean;
BEGIN
    l_is_business_admin := apex_approval.is_business_admin(
        p_user => 'STIGER'
    );
    IF l_is_business_admin THEN
        dbms_output.put_line('STIGER is a Business Administrator');
    END IF;
END;