Change Autharization, Build Option ,custom attribute and Server side condtion for button on runtime in Oracle APEX
Table of contents
No headings in the article.
Make an Item for the 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 Authorization
BEGIN
UPDATE APEX_200200.wwv_flow_step_items -- ITEMS
SET SECURITY_SCHEME = :P9_SECURITY_ID -- Authorization schema
WHERE FLOW_ID = :P9_FLOW_ID -- APP ID
and FLOW_STEP_ID = :P9_STEP_ID -- PAGE ID
and ITEM_PLUG_ID =:P9_REGION_ID -- region region
and ID = :P9_ITEM_ID; -- item id
end;
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 condition
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;