Change Autharization, boint and assigned button for Process on runtime in APEX

 Change Autharization, boint and assigned button

for Process on runtime in APEX

Make Item for process

select PROCESS_NAME,ID from APEX_200200.wwv_flow_step_processing

                   where FLOW_ID = :P10_FLOW_ID 

                    and FLOW_STEP_ID =:P10_STEP_ID

Process for Autharization 

BEGIN

UPDATE APEX_200200.wwv_flow_step_processing -- Process table

    SET  SECURITY_SCHEME = :P10_SECURITY_ID -- Authorization schema

WHERE FLOW_ID = :P10_FLOW_ID -- APP ID

    and FLOW_STEP_ID = :P10_STEP_ID  -- PAGE ID

    and ID = :P10_PROCESS_ID; -- process id

end;

Process for process point 

BEGIN

UPDATE APEX_200200.wwv_flow_step_processing -- Process table

    SET  PROCESS_POINT = 'BEFORE_HEADER' -- PROCESS POINT

WHERE FLOW_ID = :P10_FLOW_ID -- APP ID

    and FLOW_STEP_ID = :P10_STEP_ID  -- PAGE ID

    and ID = :P10_PROCESS_ID; -- process id

end;

 

Process for assigned button 

BEGIN

UPDATE APEX_200200.wwv_flow_step_processing -- Process table

    SET  PROCESS_WHEN_BUTTON_ID = :P10_BUTTON_ID --when button

WHERE FLOW_ID = :P10_FLOW_ID -- APP ID

    and FLOW_STEP_ID = :P10_STEP_ID  -- PAGE ID

    and ID = :P10_PROCESS_ID; -- process id

end;

  

thanks 

 

How to Change Autharization, Build Option ,custom attribute and Server side condtion for button on runtime in Oracle APEX

How to Change Autharization, Build Option ,custom attribute and Server side condtion for button on runtime in Oracle APEX

Make Item for button

select BUTTON_IMAGE_ALT   ,ID from APEX_200200.wwv_flow_step_buttons

                   where FLOW_ID = :P8_FLOW_ID 

                    and FLOW_STEP_ID =:P8_STEP_ID

                    and BUTTON_PLUG_ID =:P8_REGION_ID

Process for Autharization 

select BUTTON_IMAGE_ALT   ,ID from APEX_200200.wwv_flow_step_buttons

                   where FLOW_ID = :P8_FLOW_ID 

                    and FLOW_STEP_ID =:P8_STEP_ID

                    and BUTTON_PLUG_ID =:P8_REGION_ID

Process for Build Option

BEGIN

UPDATE APEX_200200.wwv_flow_step_buttons -- buttons

SET REQUIRED_PATCH = :P8_BUILD_OPTION  

 WHERE FLOW_ID = :P8_FLOW_ID -- APP ID

 and FLOW_STEP_ID = :P8_STEP_ID  -- PAGE ID

 and BUTTON_PLUG_ID =:P8_REGION_ID -- region  

 and ID = :P8_BUTTON_ID; -- button id 

end;

 

Process for custom attribute

BEGIN

UPDATE APEX_200200.wwv_flow_step_buttons -- Buttons Table

SET   BUTTON_CATTRIBUTES = 'style="color:red;"'

 WHERE FLOW_ID = :P8_FLOW_ID -- APP ID

 and FLOW_STEP_ID = :P8_STEP_ID  -- PAGE ID

 and BUTTON_PLUG_ID =:P8_REGION_ID -- region region

 and ID = :P8_BUTTON_ID; -- button

end;

 Process for Server side condtion

BEGIN

UPDATE APEX_200200.wwv_flow_step_buttons -- button

SET  BUTTON_CONDITION_TYPE = 'EXISTS',

     BUTTON_CONDITION        ='select 1 from dual where 1=2'

 WHERE FLOW_ID = :P8_FLOW_ID -- APP ID

 and FLOW_STEP_ID = :P8_STEP_ID  -- PAGE ID

 and BUTTON_PLUG_ID =:P8_REGION_ID -- region region

 and ID = :P8_BUTTON_ID; -- button id 

end;

thanks