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_MAINT_VER_GLOBAL dependencies on PA_FIN_PLAN_TYPES_B

Line 73: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,

69:
70:
71: procedure set_global_values
72: (p_project_id IN pa_projects_all.project_id%TYPE,
73: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
74: p_user_id IN VARCHAR2,
75: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
76: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
77: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 112: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,

108: -- to also use org_id to avoid returning multiple rows
109: procedure Maintain_Versions_Init
110: (p_project_id IN pa_projects_all.project_id%TYPE,
111: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
112: p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
113: x_fin_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
114: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
115: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
116: x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895

Line 118: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895

114: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
115: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
116: x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895
117: x_proj_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
118: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
119: x_fin_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
120: x_derive_margin_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE, --File.Sql.39 bug 4440895
121: x_report_labor_hrs_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
122: x_auto_baseline_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 119: x_fin_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895

115: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
116: x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895
117: x_proj_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
118: x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
119: x_fin_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
120: x_derive_margin_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE, --File.Sql.39 bug 4440895
121: x_report_labor_hrs_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
122: x_auto_baseline_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123: x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 130: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

126: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
127: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
128:
129: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
130: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
131: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
132: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
133: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
134: l_derive_margin_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 131: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

127: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
128:
129: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
130: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
131: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
132: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
133: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
134: l_derive_margin_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
135: l_org_project_flag pa_project_types_all.org_project_flag%TYPE;

Line 251: from pa_fin_plan_types_b

247: select fin_plan_type_code,
248: plan_class_code
249: into l_fin_plan_type_code,
250: l_plan_class_code
251: from pa_fin_plan_types_b
252: where fin_plan_type_id = p_fin_plan_type_id;
253:
254: x_fin_plan_type_code := l_fin_plan_type_code;
255: -- x_fin_plan_class_code := l_plan_class_code;