[Home] [Help]
371: -- GET TASK NAME AND NUMBER
372: select pe.name || ' (' || pe.element_number || ')'
373: into l_return_value
374: from pa_resource_assignments ra,
375: pa_proj_elements pe
376: where ra.resource_assignment_id = p_resource_assignment_id and
377: ra.task_id = pe.proj_element_id;
378: end if;
379: return l_return_value;
460: fetch cur_obj_rel into v_dummy_id;
461: if cur_obj_rel%FOUND then
462: -- the task is a TOP task or a LOWEST_TASK
463: l_summary_task_flag :=
464: PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_element_version_id);
465: if l_summary_task_flag = 'N' then
466: -- task is a Lowest Task
467: l_return_value := 'LOWEST_TASK';
468: l_top_and_lowest_task_flag := 'Y';--Bug 4057673
471: l_return_value := 'TOP_TASK';
472: end if;
473: else
474: l_summary_task_flag :=
475: PA_PROJ_ELEMENTS_UTILS.is_summary_task_or_structure(l_element_version_id);
476: if l_summary_task_flag = 'N' then
477: -- task is a Lowest Task
478: l_return_value := 'LOWEST_TASK';
479: else
3197: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3198: p_use_element_version_flag IN VARCHAR2)
3199: return VARCHAR2
3200: IS
3201: l_return_value pa_proj_elements.name%TYPE;
3202: BEGIN
3203: select name
3204: into l_return_value
3205: from pa_projects_all
3211: if p_use_element_version_flag = 'N' then
3212: -- using proj_element_id
3213: select pe.name
3214: into l_return_value
3215: from pa_proj_elements pe
3216: where pe.proj_element_id = p_wbs_project_element_id;
3217: return l_return_value;
3218: else
3219: -- using wbs_element_version_id
3219: -- using wbs_element_version_id
3220: select pe.name
3221: into l_return_value
3222: from pa_proj_element_versions pev,
3223: pa_proj_elements pe
3224: where pev.element_version_id = p_wbs_element_version_id and
3225: pev.proj_element_id = pe.proj_element_id;
3226: return l_return_value;
3227: end if; -- use wbs_element_version_id