[Home] [Help]
2131: -- the link manually and then delete the task.
2132:
2133: CURSOR is_linked_task(c_task_version_id NUMBER) IS
2134: SELECT 'Y'
2135: FROM DUAL
2136: WHERE EXISTS(
2137: SELECT pors.object_relationship_id
2138: FROM pa_object_relationships pors,
2139: pa_object_relationships pors1
3768: where element_version_id = c_element_version_id;
3769:
3770: -- bug#16083858
3771: CURSOR check_cost_code_enabled(c_project_id NUMBER) IS
3772: select 'Y' from dual where
3773: EXISTS
3774: (SELECT *
3775: FROM pa_projects_all
3776: WHERE project_id = c_project_id
3778: AND CBS_ENABLE_FLAG = 'Y');
3779:
3780: -- bug#16083858
3781: CURSOR check_same_cbs_exist(c_src_project_id NUMBER, c_trgt_project_id NUMBER) IS
3782: select 'Y' from dual where
3783: EXISTS
3784: (SELECT *
3785: FROM pa_projects_all
3786: WHERE project_id = c_src_project_id
9465: AND pst.structure_type_class_code IN( 'FINANCIAL' );
9466:
9467: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
9468: SELECT 'Y'
9469: FROM dual
9470: WHERE EXISTS(
9471: SELECT 'xyz'
9472: FROM pa_proj_elem_ver_structure
9473: WHERE proj_element_id = c_structure_id
9503: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9504:
9505: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
9506: SELECT '1'
9507: FROM dual
9508: WHERE EXISTS
9509: (SELECT 'xyz'
9510: FROM pa_object_relationships
9511: WHERE object_id_from1 = c_task_version_id
10950: AND pst.structure_type_class_code IN( 'FINANCIAL' );
10951:
10952: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
10953: SELECT 'Y'
10954: FROM dual
10955: WHERE EXISTS(
10956: SELECT 'xyz'
10957: FROM pa_proj_elem_ver_structure
10958: WHERE proj_element_id = c_structure_id
10988: AND a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
10989:
10990: CURSOR get_sub_tasks(c_task_version_id NUMBER) IS
10991: SELECT '1'
10992: FROM dual
10993: WHERE EXISTS
10994: (SELECT 'xyz'
10995: FROM pa_object_relationships
10996: WHERE object_id_from1 = c_task_version_id
16410: CONNECT BY object_id_from1 = PRIOR object_id_to1
16411: and relationship_type = 'S'
16412: UNION
16413: SELECT to_number(null) object_id_from1, c_task_version_id object_id_to1
16414: FROM DUAL
16415: ) pobj
16416: WHERE
16417: ppv2.element_version_id = por1.object_id_to1
16418: AND por1.object_id_from1 = por2.object_id_to1