APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL dependencies on PA_BUDGET_VERSIONS

Line 147: from pa_budget_versions

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

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

287: end Maintain_Versions_Init;
288:
289:
290: procedure Create_Working_Copy
291: (p_project_id IN pa_budget_versions.project_id%TYPE,
292: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
293: p_copy_mode IN VARCHAR2,
294: p_adj_percentage IN NUMBER DEFAULT 0,
295: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

Line 292: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

288:
289:
290: procedure Create_Working_Copy
291: (p_project_id IN pa_budget_versions.project_id%TYPE,
292: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
293: p_copy_mode IN VARCHAR2,
294: p_adj_percentage IN NUMBER DEFAULT 0,
295: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
296: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

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

292: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
293: p_copy_mode IN VARCHAR2,
294: p_adj_percentage IN NUMBER DEFAULT 0,
295: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
296: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
297: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
298: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
299: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
300:

Line 324: from pa_budget_versions

320: if l_return_status = FND_API.G_RET_STS_SUCCESS then
321: -- prepend 'Copy: ' to version name
322: select version_name
323: into l_version_name
324: from pa_budget_versions
325: where budget_version_id = px_target_version_id;
326: FND_MESSAGE.SET_NAME('PA','PA_FP_COPY_MESSAGE');
327: l_version_name:= FND_MESSAGE.GET || ': ' || l_version_name;
328: -- bug 3139862 the maximum value version_name column can hold is 60 characters

Line 332: update pa_budget_versions

328: -- bug 3139862 the maximum value version_name column can hold is 60 characters
329: -- It could be that after appending "copy: " the version name exceeds 60 char
330: -- So, the version_name should be truncated
331: l_version_name := substr(l_version_name, 1, 60);
332: update pa_budget_versions
333: set version_name = l_version_name
334: where budget_version_id = px_target_version_id;
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: else