35.109 SET_BUILD_OPTION_STATUS Procedure

Use this procedure to change the build option status of a specified application.

Note:

The build option status will be overwritten when the application is upgraded to a new version. To keep the status set via the API, it is necessary to set the build option attribute On Upgrade Keep Status to Yes.

Syntax

apex_util.set_build_option_status(p_application_id IN NUMBER,
                                  p_id IN NUMBER,
                                  p_build_status IN VARCHAR2);

Parameters

Table 35-93 SET_BUILD_OPTION_STATUS Parameters

Parameter	Description
`p_application_id`	The ID of the application that owns the build option under shared components.
`p_id`	The ID of the build option in the application.
`p_build`_status	The new status of the build option. Possible values are `INCLUDE`, `EXCLUDE` both upper case.

Example

The following example demonstrates how to use the SET_BUILD_OPTION_STATUS procedure to change the current status of build option.

BEGIN
APEX_UTIL.SET_BUILD_OPTION_STATUS(
    P_APPLICATION_ID => 101,
    P_ID => 245935500311121039, P_BUILD_STATUS=>'INCLUDE');
 
END;

Parent topic: APEX_UTIL