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_FORECASTING_OPTIONS

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

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

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

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

Line 20: ,x_weighted_or_full_code OUT NOCOPY pa_forecasting_options_all.weighted_or_full_code%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
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

Line 21: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%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
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

Line 34: l_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%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;
38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;

Line 35: l_start_period_name pa_forecasting_options_all.start_period_name%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;
38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
39:

Line 36: l_number_of_periods pa_forecasting_options_all.number_of_periods%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;
38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
39:
40: l_period_set_name gl_sets_of_books.period_set_name%TYPE;

Line 37: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%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;
38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
39:
40: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
41: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;

Line 38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%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;
38: l_org_proj_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
39:
40: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
41: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
42: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;

Line 112: FROM pa_forecasting_options;

108: l_start_period_name,
109: l_number_of_periods,
110: l_weighted_or_full_code,
111: l_org_proj_template_id
112: FROM pa_forecasting_options;
113:
114: l_stage := 300;
115:
116: SELECT period_set_name

Line 365: ,p_period_type IN pa_forecasting_options_all.org_fcst_period_type%TYPE

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
366: := NULL
367: ,p_period_set_name IN gl_periods.period_set_name%TYPE
368: := NULL
369: ,p_period_name IN gl_periods.period_name%TYPE

Line 630: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE

626: ( p_project_id IN pa_projects_all.project_id%TYPE
627: := NULL
628: ,p_period_profile_type IN pa_proj_period_profiles.period_profile_type%TYPE
629: := NULL
630: ,p_plan_period_type IN pa_forecasting_options.org_fcst_period_type%TYPE
631: := NULL
632: ,p_period_set_name IN gl_periods.period_set_name%TYPE
633: := NULL
634: ,p_act_period_type IN gl_periods.period_type%TYPE

Line 638: ,p_number_of_periods IN pa_forecasting_options.number_of_periods%TYPE

634: ,p_act_period_type IN gl_periods.period_type%TYPE
635: := NULL
636: ,p_start_date IN gl_periods.start_date%TYPE
637: := NULL
638: ,p_number_of_periods IN pa_forecasting_options.number_of_periods%TYPE
639: ,x_period_profile_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
640: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
641: ,x_err_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
642: IS

Line 719: FROM pa_forecasting_options

715: l_org_proj_template_exists := 'N';
716:
717: SELECT 'Y'
718: INTO l_org_proj_template_exists
719: FROM pa_forecasting_options
720: WHERE org_fcst_project_template_id = p_project_id;
721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723:

Line 780: FROM Pa_Forecasting_Options_All

776: WHERE Project_Id = p_project_id;
777:
778: SELECT Default_Tp_Amount_Type
779: INTO x_tp_amount_type
780: FROM Pa_Forecasting_Options_All
781: WHERE nvl(Org_Id,-99) = l_org_id;
782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: PA_UTILS.Add_Message(