25.1.9.1.8.9.2 Making Items Conditionally Read Only

Make task page items editable only for the assigned owner while the task is active.

To make the page items editable only for the assignee, and only while the status of the task is Assigned, you can use the Read Only settings on P6_VALUE1 and P6_VALUE2 as shown below. The fields are be read-only if no row is returned by the query below. It returns a row when the task exists, the current user is the actual owner, and the status is ASSIGNED. Otherwise, no row is returned, and the fields render read-only.

select task_id
from apex_tasks
where task_id      = :P6_TASK_ID
  and actual_owner = :APP_USER
  and state_code   = 'ASSIGNED'

Figure 25-49 Making Items Read Only Unless User is Assigned Owner

Description of "Figure 25-49 Making Items Read Only Unless User is Assigned Owner"