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_PROJECTS_ALL

Line 72: (p_project_id IN pa_projects_all.project_id%TYPE,

68: end set_global_finplan_security;
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

Line 110: (p_project_id IN pa_projects_all.project_id%TYPE,

106: -- HISTORY
107: -- 11/15/2002 - bug fix 2668857: when querying pa_project_types_all, need
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

Line 116: x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895

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

Line 117: x_proj_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

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

Line 136: l_currency_code pa_projects_all.projfunc_currency_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;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;
137: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
138:
139: l_msg_count NUMBER := 0;
140: l_msg_data VARCHAR2(2000);

Line 137: l_proj_currency_code pa_projects_all.project_currency_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;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;
137: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
138:
139: l_msg_count NUMBER := 0;
140: l_msg_data VARCHAR2(2000);
141: l_data VARCHAR2(2000);

Line 207: pa_projects_all p,

203: l_currency_code,
204: l_proj_currency_code,
205: l_org_project_flag
206: from
207: pa_projects_all p,
208: pa_project_types_all pt
209: where
210: p.project_id=p_project_id and
211: p.project_type=pt.project_type and

Line 350: (p_project_id IN pa_projects_all.project_id%TYPE,

346: END Create_Working_Copy;
347:
348:
349: PROCEDURE Resubmit_Concurrent_Process
350: (p_project_id IN pa_projects_all.project_id%TYPE,
351: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
352: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
353: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
354: IS