DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_ELEMENTS

Line 115: l_task_name pa_proj_elements.name%TYPE;

111: l_prog_finish_date DATE;
112: l_progress_exists varchar2(1);
113:
114: l_task_elem_version_id NUMBER;
115: l_task_name pa_proj_elements.name%TYPE;
116: l_rlm_alias pa_resource_list_members.alias%TYPE;
117:
118: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
119: p_task_id in NUMBER,

Line 171: FROM pa_proj_elements

167: where resource_list_member_id = c_resource_list_member_id;
168:
169: CURSOR get_task_name(c_task_id NUMBER) IS
170: SELECT NAME
171: FROM pa_proj_elements
172: WHERE proj_element_id = c_task_id;
173:
174: --C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
175:

Line 657: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id

653: END IF;
654:
655:
656:
657: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id
658: ,p_task_id => l_d_task_id);
659:
660:
661: ELSIF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND

Line 693: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id

689: END IF;
690:
691:
692:
693: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id
694: ,p_task_id => l_d_task_id);
695:
696: END IF;
697:

Line 2023: p_task_name IN pa_proj_elements.name%TYPE,

2019: p_period_set_name IN gl_periods.period_set_name%TYPE,
2020: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2021: p_accounted_period_type IN gl_periods.period_type%TYPE,
2022: p_pa_period_type IN gl_periods.period_type%TYPE,
2023: p_task_name IN pa_proj_elements.name%TYPE,
2024: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2025: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2026: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865
2027: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865