DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895

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

Line 59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%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

Line 60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%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

Line 61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_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

Line 62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%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

Line 108: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

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

Line 152: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE

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

Line 182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE

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

Line 183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%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

Line 184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_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'

Line 236: p_s_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,

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

Line 238: p_t_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,

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