APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 10422: FROM PA_RESOURCE_ASSIGNMENTS a, pa_proj_element_versions pelm

10418: SELECT 'Y'
10419: INTO l_exists
10420: FROM DUAL
10421: WHERE EXISTS (SELECT 'x'
10422: FROM PA_RESOURCE_ASSIGNMENTS a, pa_proj_element_versions pelm
10423: WHERE a.budget_version_id = p_budget_version_id
10424: AND a.task_id = pelm.proj_element_id
10425: AND a.resource_class_code = PA_FP_CONSTANTS_PKG.G_RESOURCE_CLASS_CODE_FIN
10426: AND a.task_id = p_task_id

Line 10533: FROM pa_proj_element_versions ppev1,

10529: and pst.structure_type_class_code = 'WORKPLAN';
10530:
10531: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10532: SELECT ppev1.proj_element_id
10533: FROM pa_proj_element_versions ppev1,
10534: pa_proj_element_versions ppev2
10535: WHERE ppev2.object_type = 'PA_STRUCTURES'
10536: AND ppev2.project_id = p_project_id
10537: AND ppev2.proj_element_id = c_structure_id

Line 10534: pa_proj_element_versions ppev2

10530:
10531: CURSOR get_tasks (c_structure_id pa_proj_elements.proj_element_id%TYPE) IS
10532: SELECT ppev1.proj_element_id
10533: FROM pa_proj_element_versions ppev1,
10534: pa_proj_element_versions ppev2
10535: WHERE ppev2.object_type = 'PA_STRUCTURES'
10536: AND ppev2.project_id = p_project_id
10537: AND ppev2.proj_element_id = c_structure_id
10538: AND ppev1.parent_structure_version_id = ppev2.element_version_id

Line 10547: from pa_proj_element_versions ppev1,

10543: where project_id = p_project_id
10544: and object_type = 'PA_TASKS'
10545: and proj_element_id IN (
10546: select ppev1.proj_element_id
10547: from pa_proj_element_versions ppev1,
10548: pa_proj_element_versions ppev2
10549: where ppev2.object_type = 'PA_STRUCTURES'
10550: and ppev2.project_id = p_project_id
10551: and ppev2.proj_element_id = c_structure_id

Line 10548: pa_proj_element_versions ppev2

10544: and object_type = 'PA_TASKS'
10545: and proj_element_id IN (
10546: select ppev1.proj_element_id
10547: from pa_proj_element_versions ppev1,
10548: pa_proj_element_versions ppev2
10549: where ppev2.object_type = 'PA_STRUCTURES'
10550: and ppev2.project_id = p_project_id
10551: and ppev2.proj_element_id = c_structure_id
10552: and ppev1.parent_structure_version_id = ppev2.element_version_id);

Line 12937: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)

12933: is introduced as part of performance improvement for FP.M excel download.
12934: */
12935: FUNCTION get_physical_pc_complete
12936: ( p_project_id IN pa_projects_all.project_id%TYPE,
12937: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)
12938:
12939: RETURN NUMBER IS
12940:
12941: l_msg_count NUMBER;

Line 12987: (p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE,

12983:
12984: END get_physical_pc_complete;
12985:
12986: FUNCTION set_webadi_download_var
12987: (p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE,
12988: p_structure_status_flag IN VARCHAR2)
12989:
12990: RETURN VARCHAR2
12991: IS

Line 13013: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,

13009: * and the structure version status flag to be used as URL parameter for BNE URL
13010: */
13011: PROCEDURE return_struct_ver_info
13012: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
13013: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,
13014: x_struct_status_flag OUT NOCOPY VARCHAR2,
13015: x_return_status OUT NOCOPY VARCHAR2,
13016: x_msg_count OUT NOCOPY NUMBER,
13017: x_msg_data OUT NOCOPY VARCHAR2)