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