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
ليست هناك تعليقات:
إرسال تعليق