1229:
1230: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
1231: IS
1232: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED','Y','N')
1233: FROM pa_proj_elem_ver_structure str
1234: , pa_project_statuses status
1235: where str.element_version_id = c_structure_version_id
1236: AND str.project_id = c_project_id
1237: AND str.status_code = status.project_status_code;
1311: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
1312: 'WORKPLAN','N') sub_project_bac_value
1313: FROM
1314: pa_proj_element_versions ppv2
1315: ,pa_proj_elem_ver_structure ppevs2
1316: ,pa_object_relationships por1
1317: ,pa_object_relationships por2
1318: WHERE
1319: por1.object_id_from1 = c_task_version_id
4364: ,ppv1.element_version_id PARENT_TASK_VERSION_ID
4365: ,ppv1.proj_element_id PARENT_TASK_ID
4366: FROM
4367: pa_proj_element_versions ppv1
4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1
4372: ,pa_object_relationships por2
4366: FROM
4367: pa_proj_element_versions ppv1
4368: ,pa_proj_elem_ver_structure ppevs1
4369: ,pa_proj_element_versions ppv2
4370: ,pa_proj_elem_ver_structure ppevs2
4371: ,pa_object_relationships por1
4372: ,pa_object_relationships por2
4373: WHERE
4374: ppv2.element_version_id = por1.object_id_to1
6691: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
6692: 'WORKPLAN','N') sub_project_bac_value
6693: FROM
6694: pa_proj_element_versions ppv2
6695: ,pa_proj_elem_ver_structure ppevs2
6696: ,pa_object_relationships por1
6697: ,pa_object_relationships por2
6698: WHERE
6699: por1.object_id_from1 = c_task_version_id
10190: , a.element_version_id
10191: , a.prg_level
10192: , ppr.as_of_date
10193: FROM pa_proj_element_versions a,
10194: pa_proj_elem_ver_structure b,
10195: pa_proj_structure_types ppst,
10196: pa_proj_element_versions c,
10197: pa_progress_rollup ppr
10198: WHERE
10339: x_msg_data OUT NOCOPY VARCHAR2) IS
10340:
10341: cursor new_str_version_id is
10342: select ppevs.element_version_id
10343: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst
10344: where ppevs.project_id = p_project_id
10345: and ppevs.proj_element_id = ppst.proj_element_id
10346: and ppst.structure_type_id = 1
10347: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10345: and ppevs.proj_element_id = ppst.proj_element_id
10346: and ppst.structure_type_id = 1
10347: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10348: and ppevs.PUBLISHED_DATE = (select min(ppevs.published_date)
10349: from pa_proj_elem_ver_structure ppevs,
10350: pa_proj_structure_types ppst
10351: where ppevs.project_id = p_project_id
10352: and ppevs.proj_element_id = ppst.proj_element_id
10353: and ppst.structure_type_id = 1
10352: and ppevs.proj_element_id = ppst.proj_element_id
10353: and ppst.structure_type_id = 1
10354: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10355: and ppevs.published_date > (select published_date
10356: from pa_proj_elem_ver_structure
10357: where project_id = p_project_id
10358: and element_version_id = p_str_ver_id_to_del));
10359:
10360: l_str_ver_id number;