5.20 SET_APPLICATION_STATUS Procedure
This procedure sets the status of the application.
Syntax
APEX_APPLICATION_ADMIN.SET_APPLICATION_STATUS (
p_application_id IN NUMBER,
p_application_status IN t_app_status,
--
p_allowed_users_list IN apex_t_varchar2 DEFAULT NULL,
--
p_message IN VARCHAR2 DEFAULT NULL,
p_plsql_code IN VARCHAR2 DEFAULT NULL,
p_redirect_url IN VARCHAR2 DEFAULT NULL )
Parameters
Parameter | Description |
---|---|
p_application_id |
The application ID. |
p_application_status |
New status to set application to. Values include:
|
p_allowed_users_list |
An apex_t_varchar2 list of users which are allowed to access the application when p_application_status = c_app_restricted_access .
|
p_message |
Message shown to users when p_application_status = c_app_unavailable .
|
p_plsql_code |
Message shown to users when p_application_status = c_app_unavailable_show_plsql .
|
p_redirect_url |
URL to redirect to when p_application_status = c_app_unavailable_redirect .
|
Example
The following example sets the status for application 100 to "restricted access" and permits only USER1 and USER2 to use it.
BEGIN
apex_util.set_workspace('YOUR_WORKSPACE_NAME');
apex_application_admin.set_application_status (
p_application_id => 100,
p_application_status => apex_application_admin.c_app_restricted_access,
p_allowed_users_list => apex_t_varchar2('USER1','USER2') );
COMMIT;
END;
See Also:
GET_APPLICATION_STATUS FunctionParent topic: APEX_APPLICATION_ADMIN