2990: --if financial, check if ok to create subtask.
2991: --Bug 5988335 Adding condition for partial share project to skip financial validation
2992: --when a new subtask is getting created in workplan.
2993: If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') AND
2994: (PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id) <> 'SHARE_PARTIAL') --Bug 5988335
2995: THEN
2996: PA_TASK_UTILS.CHECK_CREATE_SUBTASK_OK(x_task_id => l_proj_element_id,
2997: x_err_code => l_err_code,
2998: x_err_stack => l_err_stack,
3036: END IF;
3037: --bug 3947726
3038: --do not allow sub-tasks creation if the lowest level task has progress.
3039: --This is also applicable for shared case if the task has only ETC but not actual. If actual is there then it means it will be stopped in expenditure items validation.
3040: IF pa_proj_task_struc_pub.wp_str_exists(l_project_id) = 'Y'
3041: AND pa_task_assignment_utils.get_task_level_record( l_project_id, p_parent_task_ver_id ) IS NOT NULL
3042: AND PA_PROGRESS_UTILS.check_object_has_prog(
3043: p_project_id => l_project_id
3044: ,p_proj_element_id => l_proj_element_id