DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_IMPLEMENTATIONS_ALL

Line 14: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895

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
18: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895

Line 20: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%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
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 23: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%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
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
26:
27: PROCEDURE get_org_project_info

Line 43: ( p_org_id IN pa_implementations_all.org_id%TYPE

39: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: ,x_err_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
41:
42: PROCEDURE get_utilization_details
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