[Home] [Help]
927: AND ppe.proj_element_id = p_task_id
928: AND ppev.proj_element_id = ppe.proj_element_id
929: AND ppev.element_version_id = ppevsh.element_version_id
930: AND ppev.project_id = ppevsh.project_id
931: AND ppev.parent_structure_version_id = PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(ppe.project_id, 'WORKPLAN');
932:
933: CURSOR cur_pa_task_prg2
934: IS
935: SELECT nvl(ppe.WQ_ACTUAL_ENTRY_CODE,ptt.ACTUAL_WQ_ENTRY_CODE)
2384: l_rollup_date date;
2385: begin
2386:
2387: /* -- FPM Dev CR 4 : Added condition for PA_TASKS and structure_version_id
2388: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then
2389:
2390: select max(as_of_date)
2391: into l_rollup_date
2392: from pa_progress_rollup
3634: l_time_phase_code VARCHAR2(30);
3635: l_structure_version_id NUMBER;
3636: BEGIN
3637: if p_structure_version_id is null then
3638: l_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'WORKPLAN');
3639: else
3640: l_structure_version_id := p_structure_version_id;
3641: end if;
3642: BEGIN
10086: if l_return_date is NULL then
10087:
10088: -- Get latest published structure version id.
10089:
10090: l_lp_str_ver_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id,'WORKPLAN');
10091:
10092: if p_start_end_flag = 'S' then
10093:
10094: open cur_lp_sch_start_date(l_lp_str_ver_id);