[Home] [Help]
150:
151: /* Bug # 2618119 */
152: procedure SYNCHRONIZE_BUDGET_VERSION
153: (
154: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
155: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
156: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
157: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158: );
183: Initial Creation
184: =====================================================================================*/
185: FUNCTION Gen_Src_Plan_Version_Id(
186: p_target_project_id IN pa_projects_all.project_id%TYPE,
187: p_target_version_type IN pa_budget_versions.version_type%TYPE,
188: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
189: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
190: RETURN pa_budget_versions.budget_version_id%TYPE;
191:
186: p_target_project_id IN pa_projects_all.project_id%TYPE,
187: p_target_version_type IN pa_budget_versions.version_type%TYPE,
188: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
189: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
190: RETURN pa_budget_versions.budget_version_id%TYPE;
191:
192: /*=====================================================================================
193: This is a private api that would return gen src wokplan budget version id for a given
194: option based on project id and gen src workplan version code inputs
199:
200: FUNCTION Gen_Src_WP_Version_Id(
201: p_target_project_id IN pa_projects_all.project_id%TYPE,
202: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
203: RETURN pa_budget_versions.budget_version_id%TYPE;
204:
205: /*==================================================================================
206: This procedure is used to create the seeded view for the periodic budget or forcasts
207: The selected amount types for the layout will be stored using this method.This will