628:
629: -- Delete percent complete .We shall be deleting all rows for the
630: -- project including the task rows.
631:
632: delete from pa_percent_completes
633: where project_id = x_project_id;
634:
635: --Bug 3617393
636: --Moved the delete_task code before delete_project_structure as PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP
1949: -- Delete percent complete .Need to pass project id
1950: -- since that is the leading key in the index
1951:
1952: x_err_stage := 'Delete task percent complete ';
1953: delete from pa_percent_completes
1954: where project_id = l_project_id
1955: and task_id in
1956: (select task_id
1957: from pa_tasks