DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROJ_ELEMENTS

Line 129: l_task_name pa_proj_elements.name%TYPE;

125: l_prog_finish_date DATE;
126: l_progress_exists varchar2(1);
127:
128: l_task_elem_version_id NUMBER;
129: l_task_name pa_proj_elements.name%TYPE;
130: l_rlm_alias pa_resource_list_members.alias%TYPE;
131:
132: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
133: p_task_id in NUMBER,

Line 188: FROM pa_proj_elements

184: where resource_list_member_id = c_resource_list_member_id;
185:
186: CURSOR get_task_name(c_task_id NUMBER) IS
187: SELECT NAME
188: FROM pa_proj_elements
189: WHERE proj_element_id = c_task_id;
190:
191: --C_Res_List_Mem_Check_Rec C_Res_List_Mem_Check%ROWTYPE;
192:

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

703: END IF;
704:
705:
706:
707: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id
708: ,p_task_id => l_d_task_id);
709:
710:
711: ELSIF l_task_elem_version_id IS NULL AND p_task_assignment_periods_in.exists(i) AND

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

739: END IF;
740:
741:
742:
743: l_task_elem_version_id := PA_PROJ_ELEMENTS_UTILS.GET_TASK_VERSION_ID(p_structure_version_id => l_struct_elem_version_id
744: ,p_task_id => l_d_task_id);
745:
746: END IF;
747:

Line 2263: p_task_name IN pa_proj_elements.name%TYPE,

2259: p_period_set_name IN gl_periods.period_set_name%TYPE,
2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,
2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2265: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2266: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865
2267: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865