SET_APPLICATION_STATUS Procedure

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

Table 35-90 SET_APPLICATION_STATUS Parameters

Parameter	Description
`p_application_id`	The Application ID.
`p_application_status`	New application status . Values include: `AVAILABLE` - Application is available with no restrictions. `AVAILABLE_W_EDIT_LINK` - Application is available with no restrictions. Developer Toolbar shown to developers . `DEVELOPERS_ONLY` - Application only available to developers. `RESTRICTED_ACCESS` - Application only available to users in `p_restricted_user_list`. `UNAVAILABLE` - Application unavailable. Message shown in `p_unavailable_value`. `UNAVAILABLE_PLSQL` - Application unavailable. Message shown from PL/SQL block in `p_unavailable_value`. `UNAVAILABLE_URL` - Application unavailable. Redirected to URL provided in `p_unavailable_value`.
`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;