DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_FORECASTING_OPTIONS_ALL

Line 274: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;

270: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
272: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
273: is
274: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
275: l_period_set_name pa_implementations_all.period_set_name%TYPE;
276: l_act_period_type gl_periods.period_type%TYPE;
277: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;

Line 278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;

274: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
275: l_period_set_name pa_implementations_all.period_set_name%TYPE;
276: l_act_period_type gl_periods.period_type%TYPE;
277: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;

Line 280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;

276: l_act_period_type gl_periods.period_type%TYPE;
277: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;

Line 281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;

277: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
285: l_org_id pa_forecasting_options_all.org_id%TYPE;

Line 285: l_org_id pa_forecasting_options_all.org_id%TYPE;

281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
285: l_org_id pa_forecasting_options_all.org_id%TYPE;
286: l_return_status VARCHAR2(2000);
287: l_error_msg_code VARCHAR2(30);
288:
289: BEGIN