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
THANKS ALI
ردحذفYou are welcome
حذف