GET_APPLICATION_STATUS Function

5.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;