[Home] [Help]
3864:
3865: CURSOR l_proj_element_id_csr
3866: IS
3867: SELECT 'X'
3868: FROM pa_proj_elements
3869: WHERE proj_element_id = p_pa_task_id
3870: AND project_id = p_pa_project_id;
3871:
3872: CURSOR cur_pa_proj_elems
3871:
3872: CURSOR cur_pa_proj_elems
3873: IS
3874: SELECT proj_element_id
3875: FROM pa_proj_elements
3876: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
3877: AND project_id = p_pa_project_id
3878: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
3879: FROM pa_proj_elements ppe,
3875: FROM pa_proj_elements
3876: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
3877: AND project_id = p_pa_project_id
3878: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
3879: FROM pa_proj_elements ppe,
3880: pa_proj_structure_types ppst,
3881: pa_structure_types pst
3882: WHERE ppe.proj_element_id = ppst.proj_element_id
3883: AND ppe.project_id = p_pa_project_id
3956: IF (p_structure_type = 'FINANCIAL') THEN
3957:
3958: --Added by rtarway, for BUG 3919800
3959: --Get the structure sharing type, if its partial shared structure, check for the task in
3960: --pa_proj_elements too.
3961:
3962: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_pa_project_id);
3963:
3964: IF p_pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9664: CLOSE lock_tasks_csr;
9665:
9666: --bug 2765115
9667:
9668: --only deletes from pa_proj_elements. There is a check in pa_task_pvt1.delete_task_version api not to delete from pa_tasks if called from AMG.
9669: PA_PROJ_TASK_STRUC_PUB.delete_task_structure
9670: (
9671: p_calling_module => 'AMG'
9672: ,p_task_id => l_task_id
10665: IS
10666: CURSOR cur_proj_elems
10667: IS
10668: SELECT ppe.proj_element_id
10669: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
10670: WHERE ppe.proj_element_id = ppst.proj_element_id
10671: AND ppe.project_id = p_project_id
10672: AND ppe.object_type = 'PA_STRUCTURES'
10673: AND ppst.structure_type_id = 1 ;