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 248: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

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

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

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

Line 260: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,

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