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_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_PROJ_FP_OPTIONS

Line 33: (p_planning_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE)

29: return G_BUDGET_VERSION_ID;
30: end get_budget_version_id;
31:
32: function get_lookup_planning_level
33: (p_planning_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE)
34: return VARCHAR2 is
35: l_planning_level pa_lookups.meaning%type;
36: BEGIN
37: select meaning

Line 46: (p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE)

42: return l_planning_level;
43: END get_lookup_planning_level;
44:
45: function get_lookup_time_phase
46: (p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE)
47: return VARCHAR2 is
48: l_time_phase pa_lookups.meaning%type;
49: BEGIN
50: select meaning

Line 268: (x_period_start_date OUT NOCOPY pa_proj_fp_options.fin_plan_start_date%TYPE, --File.Sql.39 bug 4440895

264: p_procedure_name => 'set_global_values');
265: end set_global_values;
266:
267: procedure get_start_end_period
268: (x_period_start_date OUT NOCOPY pa_proj_fp_options.fin_plan_start_date%TYPE, --File.Sql.39 bug 4440895
269: x_period_end_date OUT NOCOPY pa_proj_fp_options.fin_plan_end_date%TYPE, --File.Sql.39 bug 4440895
270: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
272: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 269: x_period_end_date OUT NOCOPY pa_proj_fp_options.fin_plan_end_date%TYPE, --File.Sql.39 bug 4440895

265: end set_global_values;
266:
267: procedure get_start_end_period
268: (x_period_start_date OUT NOCOPY pa_proj_fp_options.fin_plan_start_date%TYPE, --File.Sql.39 bug 4440895
269: x_period_end_date OUT NOCOPY pa_proj_fp_options.fin_plan_end_date%TYPE, --File.Sql.39 bug 4440895
270: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
272: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
273: is

Line 279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

275: l_period_set_name pa_implementations_all.period_set_name%TYPE;
276: l_act_period_type gl_periods.period_type%TYPE;
277: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
278: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;

Line 283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;

279: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
285: l_org_id pa_forecasting_options_all.org_id%TYPE;
286: l_return_status VARCHAR2(2000);
287: l_error_msg_code VARCHAR2(30);

Line 284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;

280: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
281: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;
282: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;
283: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
284: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
285: l_org_id pa_forecasting_options_all.org_id%TYPE;
286: l_return_status VARCHAR2(2000);
287: l_error_msg_code VARCHAR2(30);
288:

Line 323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

319: procedure Create_Versions_Init
320: (p_project_id IN pa_projects_all.project_id%TYPE,
321: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895

Line 326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895

322: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
328: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
329: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
330: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895

323: x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
324: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
325: x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
326: x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
327: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
328: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
329: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
330: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
331:

Line 333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

329: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
330: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
331:
332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

Line 336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

332: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;
333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
338:
339: l_msg_count NUMBER := 0;
340: l_msg_data VARCHAR2(2000);

Line 337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

333: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
334: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
335: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
336: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
337: l_approved_budget_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
338:
339: l_msg_count NUMBER := 0;
340: l_msg_data VARCHAR2(2000);
341: l_data VARCHAR2(2000);

Line 381: from pa_proj_fp_options

377: nvl(approved_rev_plan_type_flag, 'N')))
378: into l_proj_fp_options_id,
379: l_fin_plan_pref_code,
380: l_approved_budget_flag
381: from pa_proj_fp_options
382: where project_id = p_project_id and
383: fin_plan_type_id = p_fin_plan_type_id and
384: fin_plan_option_level_code = 'PLAN_TYPE';
385: