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_SETS_OF_BOOKS

Line 18: ,x_org_projfunc_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE --File.Sql.39 bug 4440895

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
22: ,x_org_structure_version_id OUT NOCOPY pa_implementations_all.org_structure_version_id%TYPE --File.Sql.39 bug 4440895

Line 40: l_period_set_name gl_sets_of_books.period_set_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;
43:
44: l_fcst_start_date date;

Line 41: l_accounted_period_type gl_sets_of_books.accounted_period_type%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;
43:
44: l_fcst_start_date date;
45: l_fcst_end_date date;

Line 42: l_org_projfunc_currency_code gl_sets_of_books.currency_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;
43:
44: l_fcst_start_date date;
45: l_fcst_end_date date;
46:

Line 122: FROM gl_sets_of_books

118: ,currency_code
119: INTO l_period_set_name
120: ,l_accounted_period_type
121: ,l_org_projfunc_currency_code
122: FROM gl_sets_of_books
123: WHERE set_of_books_id = l_set_of_books_id;
124:
125: l_stage := 400;
126: