[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
3153: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3154: p_use_element_version_flag IN VARCHAR2)
3155: return VARCHAR2
3156: IS
3157: l_return_value pa_proj_elements.name%TYPE;
3158: BEGIN
3159: select name
3160: into l_return_value
3161: from pa_projects_all
3167: if p_use_element_version_flag = 'N' then
3168: -- using proj_element_id
3169: select pe.name
3170: into l_return_value
3171: from pa_proj_elements pe
3172: where pe.proj_element_id = p_wbs_project_element_id;
3173: return l_return_value;
3174: else
3175: -- using wbs_element_version_id
3175: -- using wbs_element_version_id
3176: select pe.name
3177: into l_return_value
3178: from pa_proj_element_versions pev,
3179: pa_proj_elements pe
3180: where pev.element_version_id = p_wbs_element_version_id and
3181: pev.proj_element_id = pe.proj_element_id;
3182: return l_return_value;
3183: end if; -- use wbs_element_version_id