DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 75: p_context IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET,

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:

Line 80: --p_context can be PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET or PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN.

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

Line 81: --p_budget_version_id is mandatory whenever p_context is PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET.

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,

Line 82: --When PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN, data for the version will be deleted when p_budget_version_id

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,

Line 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

Line 98: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

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