46.36 GET_APPLICATION_STATUS Function

This function returns the current status of the application. Status values include AVAILABLE, AVAILABLE_W_EDIT_LINK, DEVELOPERS_ONLY, RESTRICTED_ACCESS, UNAVAILABLE, UNAVAILABLE_PLSQL, and UNAVAILABLE_URL.

Syntax

APEX_UTIL.GET_APPLICATION_STATUS(
    p_application_id IN NUMBER) RETURN VARCHAR2;

Parameters

Table 46-33 GET_APPLICATION_STATUS Parameters

Parameter Description

p_application_id

The Application ID.

Example

declare
    l_status varchar2(100);
begin
    l_status := apex_util.get_application_status(
                    p_application_id => 117 );
    dbms_output.put_line( 'The current application status is: ' || l_status );
end;

See Also:

"Availability" in Oracle APEX App Builder User’s Guide