7.4 GET_APPLICATION_STATUS Function
This function retrieves the application_status
(such as Available, Unavailable). Returns t_app_status
.
Syntax
APEX_APPLICATION_ADMIN.GET_APPLICATION_STATUS (
p_application_id IN NUMBER )
RETURN t_app_status;
Parameters
Parameter | Description |
---|---|
p_application_id |
The application ID. |
Example
The following example gets the application status for application 100 and works with one of the constants to act on the result.
DECLARE
l_app_status apex_application_admin.t_app_status;
BEGIN
apex_util.set_workspace('YOUR_WORKSPACE_NAME');
l_app_status := apex_application_admin.get_application_status (
p_application_id => 100 );
IF l_app_status = apex_application_admin.c_app_available_with_edit_link THEN
dbms_output.put_line(l_app_status);
-- your custom code here...
END IF;
END;
See Also:
SET_APPLICATION_STATUS ProcedureParent topic: APEX_APPLICATION_ADMIN