54: PROCEDURE FP_CI_GET_VERSION_DETAILS
55: (
56: p_project_id IN NUMBER,
57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
55: (
56: p_project_id IN NUMBER,
57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
56: p_project_id IN NUMBER,
57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
64: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
64: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
65: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
64: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
65: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
66: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
104: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
105:
106: PROCEDURE Is_Create_CI_Version_Allowed
107: ( p_project_id IN pa_budget_versions.project_id%TYPE
108: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
109: ,p_version_type IN pa_budget_versions.version_type%TYPE
110: ,p_impacted_task_id IN pa_tasks.task_id%TYPE
111: ,x_version_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148: RETURN NUMBER;
149:
150: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
151: ( p_project_id IN pa_projects_all.project_id%TYPE
152: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
153: ,p_version_type IN pa_budget_versions.version_type%TYPE
154: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
178: ) ;
179:
180: PROCEDURE FP_CI_CHECK_COPY_POSSIBLE
181: (
182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE
183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
179:
180: PROCEDURE FP_CI_CHECK_COPY_POSSIBLE
181: (
182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE
183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE
180: PROCEDURE FP_CI_CHECK_COPY_POSSIBLE
181: (
182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE
183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE
188: ,p_multiple_plan_types_flag IN VARCHAR2 DEFAULT 'N'
232:
233: procedure chk_res_resgrp_mismatch(
234: p_project_id in number,
235: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
236: p_s_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
237: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
238: p_t_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
239: p_calling_mode in varchar2,
240: x_res_resgr_mismatch_flag OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
234: p_project_id in number,
235: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
236: p_s_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
237: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
238: p_t_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
239: p_calling_mode in varchar2,
240: x_res_resgr_mismatch_flag OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
241: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
242: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895