53.112 SET_APPLICATION_STATUS Procedure (Deprecated)
Note:
This API is deprecated and will be removed in a future release.
Use SET_APPLICATION_STATUS Procedure in APEX_APPLICATION_ADMIN instead.
This procedure changes the status of the application.
Syntax
APEX_UTIL.SET_APPLICATION_STATUS (
p_application_id IN NUMBER,
p_application_status IN VARCHAR2,
p_unavailable_value IN VARCHAR2,
p_restricted_user_list IN VARCHAR2 )
Parameters
Parameter | Description |
---|---|
p_application_id |
The Application ID. |
p_application_status |
New application status. Values include:
|
p_unavailable_value |
Value used when application is unavailable. This value has different semantics dependent upon value for p_application_status .
|
p_restricted_user_list |
Comma separated list of users permitted to access application, when p_application_status = RESTRICTED_ACCESS .
|
Examples
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'AVAILABLE' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'AVAILABLE_W_EDIT_LINK' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'DEVELOPERS_ONLY' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'RESTRICTED_ACCESS',
p_restricted_user_list => 'xxx.xxx@abc.com' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'UNAVAILABLE',
p_unavailable_value => 'Application not available, sorry' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'UNAVAILABLE_PLSQL',
p_unavailable_value => 'sys.htp.p(''Application unavailable, sorry'');' );
end;
begin
apex_util.set_application_status(
p_application_id => 117,
p_application_status => 'UNAVAILABLE_URL',
p_unavailable_value => 'http://www.xyz.com' );
end;
See Also:
Availability in Oracle APEX App Builder User’s Guide
Parent topic: APEX_UTIL