71: procedure Delete_Version
72: (p_project_id IN pa_budget_versions.project_id%TYPE,
73: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
74: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
75: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
79:
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
79:
80: --p_context can be PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET or PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN.
81: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.
82: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
83: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
84: procedure Delete_Version_Helper
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
79:
80: --p_context can be PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET or PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN.
81: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.
82: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
83: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
84: procedure Delete_Version_Helper
85: (p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
78: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
79:
80: --p_context can be PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET or PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN.
81: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.
82: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
83: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
84: procedure Delete_Version_Helper
85: (p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
86: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
82: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id
83: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
84: procedure Delete_Version_Helper
85: (p_project_id IN pa_projects_all.project_id%TYPE DEFAULT NULL,
86: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,
87: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
88: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
89: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
90: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
94: (p_project_id IN pa_budget_versions.project_id%TYPE,
95: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_copy_mode IN VARCHAR2,
97: p_adj_percentage IN NUMBER DEFAULT 0,
98: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
99: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168
100: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
101: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
102: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895