DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 422: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE --File.Sql.39 bug 4440895

418: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
419: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
420: ,p_is_wp_separate_from_fn IN VARCHAR2
421: ,p_is_wp_versioning_enabled IN VARCHAR2
422: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE --File.Sql.39 bug 4440895
423: -- The following parameter has been added after review obsoleting get_task_unpub_status_ver_code api.
424: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE --File.Sql.39 bug 4440895
425: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
426: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 424: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE --File.Sql.39 bug 4440895

420: ,p_is_wp_separate_from_fn IN VARCHAR2
421: ,p_is_wp_versioning_enabled IN VARCHAR2
422: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE --File.Sql.39 bug 4440895
423: -- The following parameter has been added after review obsoleting get_task_unpub_status_ver_code api.
424: ,x_task_unpub_ver_status_code OUT NOCOPY pa_proj_element_versions.task_unpub_ver_status_code%TYPE --File.Sql.39 bug 4440895
425: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
426: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
427: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
428:

Line 463: p_proj_element_id IN PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) return VARCHAR2;

459: -- This API returns task level of Financial Tasks
460: -- Please see package body for more details reg. this function
461: function GET_TASK_LEVEL(
462: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
463: p_proj_element_id IN PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID%TYPE) return VARCHAR2;
464:
465: --Added by sabansal
466: --Function to check whether the given task is a workplan task or not
467: function CHECK_IS_WORKPLAN_TASK(p_project_id NUMBER,