How to change Region read only on runtime in Oracle APEX

 1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 

PLUG_NAME,

ID

 from APEX_200200.wwv_flow_page_plugs

                    where FLOW_ID =:P6_FLOW_ID

                    and   PAGE_ID =:P6_STEP_ID

  and make process to update Region read only

 BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs -- Region

SET PLUG_READ_ONLY_WHEN_TYPE = 'EXISTS' ,

    PLUG_READ_ONLY_WHEN = 'SELECT 1 from dual where 1 =2 '

WHERE FLOW_ID = :P6_FLOW_ID -- APP ID

 and PAGE_ID = :P6_STEP_ID  -- PAGE ID

 and ID = :P6_REGION_ID -- REGION ID

; end;

thanks

How to change Region Serveer Side COndition on runtime in Oracle APEX

1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 

PLUG_NAME,

ID

 from APEX_200200.wwv_flow_page_plugs

                    where FLOW_ID =:P6_FLOW_ID

                    and   PAGE_ID =:P6_STEP_ID

  and make process to update Region Server side condition 

 BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs -- Region

SET PLUG_DISPLAY_CONDITION_TYPE = 'NOT_EXISTS' ,

    PLUG_DISPLAY_WHEN_CONDITION = 'SELECT 1 from dual where 1=2'

WHERE FLOW_ID = :P6_FLOW_ID -- APP ID

 and PAGE_ID = :P6_STEP_ID  -- PAGE ID

 and ID = :P6_REGION_ID -- REGION ID; 

end;

--
thanks

How to change Region Bulid Option on runtime in Oracle APEX

1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 

PLUG_NAME,

ID

 from APEX_200200.wwv_flow_page_plugs

                    where FLOW_ID =:P6_FLOW_ID

                    and   PAGE_ID =:P6_STEP_ID

and select list item  P6_BUILD_OPTION

that will contain all build Option available for your APP

use this code as source 

select PATCH_NAME,ID from APEX_200200.wwv_flow_patches

                    where FLOW_ID =:P6_FLOW_ID

 

and make process to update Region Build Option

 BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs -- Region

SET REQUIRED_PATCH = :P6_BUILD_OPTION  

WHERE FLOW_ID = :P6_FLOW_ID -- APP ID

 and PAGE_ID = :P6_STEP_ID  -- PAGE ID

 and ID = :P6_REGION_ID -- REGION ID; 

end;

--
thanks

How to change Region Authorization Scheme on runtime in Oracle APEX

1: Make P6_REGION_ID

that will contain all Region available for your page 

use this code as source 

select 

PLUG_NAME,

ID

 from APEX_200200.wwv_flow_page_plugs

                    where FLOW_ID =:P6_FLOW_ID

                    and   PAGE_ID =:P6_STEP_ID

and select list item  P6_SECURITY_ID

that will contain all Authorization available for your APP

use this code as source 

select NAME,ID from 

APEX_200200.wwv_flow_security_schemes

 where FLOW_ID =:P7_FLOW_ID

and make process to update Region Authorization 

BEGIN

UPDATE APEX_200200.wwv_flow_page_plugs 

SET PLUG_REQUIRED_ROLE = :P6_SECURITY_ID 

WHERE FLOW_ID = :P6_FLOW_ID 

 and PAGE_ID = :P6_STEP_ID  

 and ID = :P6_REGION_ID

end;

--
thanks

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

How to change Page Authorization Scheme on runtime in Oracle APEX

   first make select list item  P7_SECURITY_ID

that will contain all Authorization available for your APP

use this code as source 

select NAME,ID from 

APEX_200200.wwv_flow_security_schemes

 where FLOW_ID =:P7_FLOW_ID

and make process to update Page Authorization 

BEGIN

UPDATE APEX_200200.wwv_flow_steps -- PageS

SET required_role = :P7_SECURITY_ID -- Authorization schema

WHERE FLOW_ID = :P7_FLOW_ID -- APP ID

 and ID = :P7_STEP_ID  -- PAGE ID

; 

end;

--
thanks

How to change Authorization Scheme on runtime in Oracle APEX

  first make select list item  P4_AUTHORIZTION_SCHEMA

that will contain all Authorization available for your APP

 

use this code as source 

 

select a.d, a.r from (

    select APEX_200200.wwv_flow_lang.system_message('MUST_NOT_BE_PUBLIC_USER') d,'MUST_NOT_BE_PUBLIC_USER' r, 1 

    from dual

    union all

    select APEX_200200.wwv_flow_escape.html(substr(name,1,50)),to_char(id), 1

    from APEX_200200.wwv_flow_security_schemes where flow_id = :APP_ID

    union all

    select '{'||APEX_200200.wwv_flow_lang.system_message('NOT_W_ARGUMENT',APEX_200200.wwv_flow_escape.html(substr(name,1,50)))||'}' d,

     '!'||to_char(id) r, 2

    from   APEX_200200.wwv_flow_security_schemes

    where flow_id = :APP_ID

    order by 3,1) a

and make process to update Application Authorization 

UPDATE APEX_200200.wwv_flows 

SET SECURITY_SCHEME =:P4_AUTHORIZTION_SCHEMA

where ID = :APP_ID;

--
thanks

How to change Parsing Schema on runtime in Oracle APEX

  first make select list item  P4_AUTHORIZTION_SCHEMA

that will contain all DB schema available for your workspace

use this code as source 

select APEX_200200.wwv_flow_escape.html(schema) d, schema r

from   APEX_200200.wwv_flow_company_schemas

where  security_group_id = :flow_security_group_id

order by 1

and make process to update Application Authentication 

UPDATE APEX_200200.wwv_flows 

SET SECURITY_SCHEME =:P4_AUTHORIZTION_SCHEMA

where ID = :APP_ID;

--
thanks

How to change Authentication Schemes on runtime in Oracle APEX

 first make select list item  P2_AUTHENTICATION_ID
that will contain all Authentication available for your APP

use this code as source 

select name as d,

       id   as r

  from APEX_200200.wwv_flow_authentications

 where flow_id           = :APP_ID

   and security_group_id = :WORKSPACE_ID

 order by 1

and make process to update Application Authentication 

UPDATE APEX_200200.wwv_flows 

SET AUTHENTICATION_ID =:P2_AUTHENTICATION_ID

where ID = :APP_ID;

--
thanks