APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL dependencies on PA_BUDGET_VERSIONS

Line 146: from pa_budget_versions

142: l_msg_index_out NUMBER;
143:
144: cursor wbs_errored_versions_csr is
145: select budget_version_id
146: from pa_budget_versions
147: where project_id = p_project_id and
148: fin_plan_type_id = p_fin_plan_type_id and
149: plan_processing_code = 'WUE' and
150: process_update_wbs_flag = 'Y';

Line 280: (p_project_id IN pa_budget_versions.project_id%TYPE,

276: end Maintain_Versions_Init;
277:
278:
279: procedure Create_Working_Copy
280: (p_project_id IN pa_budget_versions.project_id%TYPE,
281: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
282: p_copy_mode IN VARCHAR2,
283: p_adj_percentage IN NUMBER DEFAULT 0,
284: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

Line 281: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

277:
278:
279: procedure Create_Working_Copy
280: (p_project_id IN pa_budget_versions.project_id%TYPE,
281: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
282: p_copy_mode IN VARCHAR2,
283: p_adj_percentage IN NUMBER DEFAULT 0,
284: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
285: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 285: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

281: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
282: p_copy_mode IN VARCHAR2,
283: p_adj_percentage IN NUMBER DEFAULT 0,
284: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
285: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
286: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
287: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
288: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
289:

Line 313: from pa_budget_versions

309: if l_return_status = FND_API.G_RET_STS_SUCCESS then
310: -- prepend 'Copy: ' to version name
311: select version_name
312: into l_version_name
313: from pa_budget_versions
314: where budget_version_id = px_target_version_id;
315: FND_MESSAGE.SET_NAME('PA','PA_FP_COPY_MESSAGE');
316: l_version_name:= FND_MESSAGE.GET || ': ' || l_version_name;
317: -- bug 3139862 the maximum value version_name column can hold is 60 characters

Line 321: update pa_budget_versions

317: -- bug 3139862 the maximum value version_name column can hold is 60 characters
318: -- It could be that after appending "copy: " the version name exceeds 60 char
319: -- So, the version_name should be truncated
320: l_version_name := substr(l_version_name, 1, 60);
321: update pa_budget_versions
322: set version_name = l_version_name
323: where budget_version_id = px_target_version_id;
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325: else