6.1 Constants and Data Types

The APEX_APPLICATION_ADMIN package uses the following constants and data types.

Application Status

subtype t_app_status is varchar2(30);
c_app_available                constant t_app_status := 'AVAILABLE';
c_app_available_with_edit_link constant t_app_status := 'AVAILABLE_W_EDIT_LINK';
c_app_available_devs_only      constant t_app_status := 'DEVELOPERS_ONLY';
c_app_restricted_access        constant t_app_status := 'RESTRICTED_ACCESS';
c_app_unavailable              constant t_app_status := 'UNAVAILABLE';
c_app_unavailable_redirect     constant t_app_status := 'UNAVAILABLE_URL';
c_app_unavailable_show_plsql   constant t_app_status := 'UNAVAILABLE_PLSQL';

Build Status

subtype t_build_status is varchar2(30);
c_build_status_run_and_build   constant t_build_status := 'RUN_AND_BUILD';
c_build_status_run_only        constant t_build_status := 'RUN_ONLY';

Build Option Status

subtype t_build_option_status is varchar2(30);
c_build_option_status_include constant t_build_option_status := 'INCLUDE';
c_build_option_status_exclude constant t_build_option_status := 'EXCLUDE';

Storage Type

subtype t_storage_type is varchar2(30);
c_file_storage_oci     constant t_storage_type := 'OBJECT_STORE';
c_file_storage_db      constant t_storage_type := 'DB';