DBA Data[Home] [Help]

APPS.PA_BUDGET_CHECK_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 137: l_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;

133: valid_gl_end_date VARCHAR2(1) := 'N';
134: valid_pa_start_date VARCHAR2(1) := 'N';
135: valid_pa_end_date VARCHAR2(1) := 'N';
136:
137: l_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
138: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
139: l_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
141: l_compl_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();

Line 138: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;

134: valid_pa_start_date VARCHAR2(1) := 'N';
135: valid_pa_end_date VARCHAR2(1) := 'N';
136:
137: l_elem_ver_id pa_proj_element_versions.element_version_id%TYPE;
138: l_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE;
139: l_elem_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_start_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
141: l_compl_date_tbl SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
142: l_msg_count NUMBER;

Line 734: FROM pa_proj_element_versions pev

730: IF p_task_id <> 0 THEN
731: BEGIN
732: SELECT pev.element_version_id
733: INTO l_elem_ver_id
734: FROM pa_proj_element_versions pev
735: WHERE pev.proj_element_id = p_task_id
736: AND pev.parent_structure_version_id = l_parent_structure_version_id;
737: EXCEPTION
738: WHEN NO_DATA_FOUND THEN