How to change Build Option for Page on runtime in Oracle APEX

    first make select list item  P7_BUILD_OPTION

that will contain all Build Option available for your APP

use this code as source 

  select patch_name||' ('||wwv_flow_lang.system_message(patch_status)||')' d, id r 

  from APEX_200200.wwv_flow_patches where FLOW_ID = :APP_ID

and make process to update Page Build Option

BEGIN

UPDATE APEX_200200.wwv_flow_steps -

SET REQUIRED_PATCH = :P7_BUILD_OPTION  

 WHERE FLOW_ID = :P7_FLOW_ID 

 and ID = :P7_STEP_ID ; 

end;

--
thanks

How to change Page Read only on runtime in Oracle APEX

Make process to change Page Read only on runtime

BEGIN

UPDATE APEX_200200.wwv_flow_steps -- PageS

SET READ_ONLY_WHEN_TYPE = 'EXISTS' ,

READ_ONLY_WHEN = 'select 1 from dual where 1=1'

WHERE FLOW_ID = :P7_FLOW_ID -- APP ID

 and ID = :P7_STEP_ID  -- PAGE ID

; 

end;

--
thanks

How to change Page to Public or Not on runtime in Oracle APEX

    first make select list item  P7_PAGE_IS_PUBLIC_Y_N

 

use this code as source 

and make process to change Page to Public  or Not

BEGIN

UPDATE APEX_200200.wwv_flow_steps -- PageS

SET PAGE_IS_PUBLIC_Y_N = :P7_PAGE_IS_PUBLIC_Y_N -- Authorization schema

WHERE FLOW_ID = :P7_FLOW_ID -- APP ID

 and ID = :P7_STEP_ID  -- PAGE ID

; 

end;

--
thanks