Working on Oracle APEX Workflow app (APEX 22.x) and it would be useful to be able to set a task parameter value via the API AFTER a task has been created. My objective is to hack into the Unified Tasks Report and conditionally replace the “Accept” function with a pop up based on the existence of task parameter.
select gt.*
, simon.apex_people_status.get_photo_url(apex_approval.get_task_parameter_value(gt.task_id, 'PERSON_ID')
, image_type => 'IDThumb') as PHOTO_URL
, Simon.Mailing_Utils.get_name(apex_approval.get_task_parameter_value(gt.task_id, 'PERSON_ID')) as PNAME
-- , apex_approval.get_task_parameter_value(gt.task_id, 'MORE_INFO') as MORE_INFO
, 'set-access-options' as MORE_INFO
from table (
apex_approval.get_tasks (
p_context => 'MY_TASKS',
p_show_expired_tasks => :P12_SHOW_EXPIRED ) ) GT
I actually got most of the APEX work done before discovering that there is NO set_task_parameter_value function call. My plan had been to set this value when the task was created if other conditions were met, and then after processing, clear that value. I was able to tweak the button definition to NOT appear if the “MORE_INFO” parameter was set in the select statement. It was actually my intention to have that be a page alias, but my javascript fu is weak. Along with the code to suppress the “Accept” button, I was able to conditional include a “Provide More Info” button. Although I could provide the update function details page, I still want to control the accept button.