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