Update task status and logged hours
Hello!
I need to update task status and logged hours in Oracle Projects. I have found 2 APIs which are suspected :
- pa_project_pub.update_task,
- pa_status_pub.update_progress
UPDATE_TASK is working fine but in only updates data like is in PA_TASKS_AMG_V View (for example task name, description etc. ) but when i check PA_TASK_PROGRESS_AMG_V with the same task_id/project_id there was old data before update. This API could be but i need to pass parameter which will increase actual logged ours and will change status (i guess p_ext_act_duration or p_duration &pa_status)