[Home] [Help]
156:
157: /* Bug # 2618119 */
158: procedure SYNCHRONIZE_BUDGET_VERSION
159: (
160: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
161: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
162: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
163: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: );
189: Initial Creation
190: =====================================================================================*/
191: FUNCTION Gen_Src_Plan_Version_Id(
192: p_target_project_id IN pa_projects_all.project_id%TYPE,
193: p_target_version_type IN pa_budget_versions.version_type%TYPE,
194: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
195: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
196: RETURN pa_budget_versions.budget_version_id%TYPE;
197:
192: p_target_project_id IN pa_projects_all.project_id%TYPE,
193: p_target_version_type IN pa_budget_versions.version_type%TYPE,
194: p_gen_src_plan_type_id IN pa_proj_fp_options.gen_src_cost_plan_type_id%TYPE,
195: p_gen_src_plan_ver_code IN pa_proj_fp_options.gen_src_cost_plan_ver_code%TYPE)
196: RETURN pa_budget_versions.budget_version_id%TYPE;
197:
198: /*=====================================================================================
199: This is a private api that would return gen src wokplan budget version id for a given
200: option based on project id and gen src workplan version code inputs
205:
206: FUNCTION Gen_Src_WP_Version_Id(
207: p_target_project_id IN pa_projects_all.project_id%TYPE,
208: p_gen_src_wp_ver_code IN pa_proj_fp_options.gen_src_cost_wp_ver_code%TYPE)
209: RETURN pa_budget_versions.budget_version_id%TYPE;
210:
211: /*==================================================================================
212: This procedure is used to create the seeded view for the periodic budget or forcasts
213: The selected amount types for the layout will be stored using this method.This will