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 GL_PERIODS

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

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
21: ,x_org_proj_template_id OUT NOCOPY pa_forecasting_options_all.org_fcst_project_template_id%TYPE --File.Sql.39 bug 4440895

Line 50: CURSOR gl_periods IS

46:
47: l_stage number := 0;
48: l_debug_mode VARCHAR2(30);
49:
50: CURSOR gl_periods IS
51: SELECT gp.end_date
52: FROM gl_periods gp
53: WHERE gp.period_set_name = l_period_set_name
54: AND gp.period_type = l_accounted_period_type

Line 52: FROM gl_periods gp

48: l_debug_mode VARCHAR2(30);
49:
50: CURSOR gl_periods IS
51: SELECT gp.end_date
52: FROM gl_periods gp
53: WHERE gp.period_set_name = l_period_set_name
54: AND gp.period_type = l_accounted_period_type
55: AND gp.start_date >= l_fcst_start_date
56: AND gp.adjustment_period_flag = 'N'

Line 61: FROM gl_periods gp

57: ORDER BY gp.start_date;
58:
59: CURSOR pa_periods IS
60: SELECT gp.end_date
61: FROM gl_periods gp
62: WHERE gp.period_set_name = l_period_set_name
63: AND gp.period_type = l_pa_period_type
64: AND gp.start_date >= l_fcst_start_date
65: AND gp.adjustment_period_flag = 'N'

Line 135: FROM gl_periods

131: x_act_period_type := l_accounted_period_type;
132:
133: SELECT start_date, end_date
134: INTO l_fcst_start_date, l_fcst_end_date
135: FROM gl_periods
136: WHERE period_set_name = l_period_set_name
137: AND period_type = l_accounted_period_type
138: AND period_name = l_start_period_name
139: AND adjustment_period_flag = 'N';

Line 143: OPEN gl_periods;

139: AND adjustment_period_flag = 'N';
140:
141: l_stage := 600;
142:
143: OPEN gl_periods;
144: FOR i IN 1..l_number_of_periods LOOP
145: FETCH gl_periods INTO l_fcst_end_date;
146: END LOOP;
147: CLOSE gl_periods;

Line 145: FETCH gl_periods INTO l_fcst_end_date;

141: l_stage := 600;
142:
143: OPEN gl_periods;
144: FOR i IN 1..l_number_of_periods LOOP
145: FETCH gl_periods INTO l_fcst_end_date;
146: END LOOP;
147: CLOSE gl_periods;
148: l_stage := 700;
149: ELSE -- PA period

Line 147: CLOSE gl_periods;

143: OPEN gl_periods;
144: FOR i IN 1..l_number_of_periods LOOP
145: FETCH gl_periods INTO l_fcst_end_date;
146: END LOOP;
147: CLOSE gl_periods;
148: l_stage := 700;
149: ELSE -- PA period
150: l_stage := 800;
151: x_act_period_type := l_pa_period_type;

Line 155: FROM gl_periods

151: x_act_period_type := l_pa_period_type;
152:
153: SELECT start_date, end_date
154: INTO l_fcst_start_date, l_fcst_end_date
155: FROM gl_periods
156: WHERE period_set_name = l_period_set_name
157: AND period_type = l_pa_period_type
158: AND period_name = l_start_period_name
159: AND adjustment_period_flag = 'N';

Line 367: ,p_period_set_name IN gl_periods.period_set_name%TYPE

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

Line 369: ,p_period_name IN gl_periods.period_name%TYPE

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
370: := NULL
371: ,x_utl_hours OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
372: ,x_utl_capacity OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
373: ,x_utl_percent OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 632: ,p_period_set_name IN gl_periods.period_set_name%TYPE

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

Line 634: ,p_act_period_type IN gl_periods.period_type%TYPE

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

Line 636: ,p_start_date IN gl_periods.start_date%TYPE

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