Change Authorization, point and assigned button for Process

Table of contents

No heading

No headings in the article.

Make an Item for the 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 Authorization

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;