DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_FORECASTING_OPTIONS

Line 13: ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895

9:
10: /* 20-Mar-2002 SManivannan Added Procedure Get_Tp_Amount_Type */
11:
12: PROCEDURE get_forecast_option_details
13: ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895
14: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895
15: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
17: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895

Line 17: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895

13: ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895
14: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895
15: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
17: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
18: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895
19: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
20: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
21: ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 18: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895

14: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895
15: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
17: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
18: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895
19: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
20: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
21: ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
22: ,x_fcst_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 19: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895

15: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
17: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
18: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895
19: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
20: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
21: ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
22: ,x_fcst_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
23: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895

Line 47: ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE

43: ( p_org_id IN pa_implementations_all.org_id%TYPE
44: := NULL
45: ,p_organization_id IN hr_organization_units.organization_id%TYPE
46: := NULL
47: ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE
48: := NULL
49: ,p_period_set_name IN gl_periods.period_set_name%TYPE
50: := NULL
51: ,p_period_name IN gl_periods.period_name%TYPE

Line 79: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE

75: ( p_project_id IN pa_projects_all.project_id%TYPE
76: := NULL
77: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
78: := NULL
79: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE
80: := NULL
81: ,p_period_set_name IN gl_periods.period_set_name%TYPE
82: := NULL
83: ,p_act_period_type IN gl_periods.period_type%TYPE

Line 87: ,p_number_of_periods IN pa_forecasting_options.number_of_periods%TYPE

83: ,p_act_period_type IN gl_periods.period_type%TYPE
84: := NULL
85: ,p_start_date IN gl_periods.start_date%TYPE
86: := NULL
87: ,p_number_of_periods IN pa_forecasting_options.number_of_periods%TYPE
88: ,x_period_profile_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
89: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
91: