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
1965: -- Delete percent complete .Need to pass project id
1966: -- since that is the leading key in the index
1967:
1968: x_err_stage := 'Delete task percent complete ';
1969: delete from pa_percent_completes
1970: where project_id = l_project_id
1971: and task_id in
1972: (select task_id
1973: from pa_tasks