DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,

11: /* This procedure should be used for the Workplan Task Details page ONLY!
12: */
13: PROCEDURE get_workplan_bvids
14: (p_project_id IN pa_budget_versions.project_id%TYPE,
15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 250: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

246: -- must be set to 'N'
247: FUNCTION get_wbs_element_name_from_id
248: (p_project_id IN pa_projects_all.project_id%TYPE,
249: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
250: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
251: p_use_element_version_flag IN VARCHAR2) return VARCHAR2;
252:
253: FUNCTION get_proj_element_id
254: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE) return NUMBER;

Line 254: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE) return NUMBER;

250: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
251: p_use_element_version_flag IN VARCHAR2) return VARCHAR2;
252:
253: FUNCTION get_proj_element_id
254: (p_wbs_element_version_id IN pa_proj_element_versions.element_version_id%TYPE) return NUMBER;
255:
256: FUNCTION get_rbs_element_name_from_id
257: (p_rbs_element_version_id IN pa_rbs_elements.rbs_element_id%TYPE) return VARCHAR2;
258:

Line 262: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

258:
259: FUNCTION get_task_percent_complete
260: (p_project_id IN pa_projects_all.project_id%TYPE,
261: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
262: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
263: p_calling_context IN VARCHAR2) return NUMBER;
264:
265: /* Bug 5524803: Added the below function to return the prior forecast version id
266: * to be used by PJI.