DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on GL_PERIODS

Line 15: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895

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
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

Line 49: ,p_period_set_name IN gl_periods.period_set_name%TYPE

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
52: := NULL
53: ,x_utl_hours OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 51: ,p_period_name IN gl_periods.period_name%TYPE

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
52: := NULL
53: ,x_utl_hours OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54: ,x_utl_capacity OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
55: ,x_utl_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 81: ,p_period_set_name IN gl_periods.period_set_name%TYPE

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
84: := NULL
85: ,p_start_date IN gl_periods.start_date%TYPE

Line 83: ,p_act_period_type IN gl_periods.period_type%TYPE

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
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

Line 85: ,p_start_date IN gl_periods.start_date%TYPE

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
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