DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_FIN_PLAN_TYPES_B

Line 321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,

317: 5/25/05 -- added x_approved_budget_flag param
318: ======================================================== */
319: procedure Create_Versions_Init
320: (p_project_id IN pa_projects_all.project_id%TYPE,
321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895

Line 324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895

320: (p_project_id IN pa_projects_all.project_id%TYPE,
321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
328: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895

321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
328: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
329: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

330: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
331:
332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
338:

Line 335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

331:
332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
338:
339: l_msg_count NUMBER := 0;

Line 367: from pa_fin_plan_types_b

363: select fin_plan_type_code,
364: plan_class_code
365: into l_fin_plan_type_code,
366: l_plan_class_code
367: from pa_fin_plan_types_b
368: where fin_plan_type_id = p_fin_plan_type_id;
369:
370: select proj_fp_options_id,
371: fin_plan_preference_code,