eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_IMPLEMENTATIONS_ALL

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

12: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
13:
14: PROCEDURE get_forecast_option_details
15: ( x_fcst_period_type OUT NOCOPY pa_forecasting_options_all.org_fcst_period_type%TYPE --File.Sql.39 bug 4440895
16: ,x_period_set_name OUT NOCOPY pa_implementations_all.period_set_name%TYPE --File.Sql.39 bug 4440895
17: ,x_act_period_type OUT NOCOPY gl_periods.period_type%TYPE --File.Sql.39 bug 4440895
18: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
19: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
20: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895

Line 22: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895

18: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895
19: ,x_number_of_periods OUT NOCOPY pa_forecasting_options_all.number_of_periods%TYPE --File.Sql.39 bug 4440895
20: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%TYPE --File.Sql.39 bug 4440895
21: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
22: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
23: ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
24: ,x_fcst_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
25: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895
26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 25: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895

21: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895
22: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895
23: ,x_fcst_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
24: ,x_fcst_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
25: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895
26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27: ,x_err_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
28:
29: l_org_id pa_implementations_all.org_id%TYPE;

Line 29: l_org_id pa_implementations_all.org_id%TYPE;

25: ,x_org_id OUT NOCOPY pa_implementations_all.org_id%TYPE --File.Sql.39 bug 4440895
26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27: ,x_err_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
28:
29: l_org_id pa_implementations_all.org_id%TYPE;
30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;
32: l_start_organization pa_implementations_all.start_organization_id%TYPE;
33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

Line 30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

26: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
27: ,x_err_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
28:
29: l_org_id pa_implementations_all.org_id%TYPE;
30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;
32: l_start_organization pa_implementations_all.start_organization_id%TYPE;
33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
34: l_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;

Line 31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;

27: ,x_err_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
28:
29: l_org_id pa_implementations_all.org_id%TYPE;
30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;
32: l_start_organization pa_implementations_all.start_organization_id%TYPE;
33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
34: l_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
35: l_start_period_name pa_forecasting_options_all.start_period_name%TYPE;

Line 32: l_start_organization pa_implementations_all.start_organization_id%TYPE;

28:
29: l_org_id pa_implementations_all.org_id%TYPE;
30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;
32: l_start_organization pa_implementations_all.start_organization_id%TYPE;
33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
34: l_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
35: l_start_period_name pa_forecasting_options_all.start_period_name%TYPE;
36: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;

Line 33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

29: l_org_id pa_implementations_all.org_id%TYPE;
30: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
31: l_org_struc_version_id pa_implementations_all.org_structure_version_id%TYPE;
32: l_start_organization pa_implementations_all.start_organization_id%TYPE;
33: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
34: l_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
35: l_start_period_name pa_forecasting_options_all.start_period_name%TYPE;
36: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
37: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;

Line 361: ( p_org_id IN pa_implementations_all.org_id%TYPE

357: pa_debug.reset_err_stack;
358: END get_org_task_info;
359:
360: PROCEDURE get_utilization_details
361: ( p_org_id IN pa_implementations_all.org_id%TYPE
362: := NULL
363: ,p_organization_id IN hr_organization_units.organization_id%TYPE
364: := NULL
365: ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE