DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL dependencies on PA_PROJ_FP_OPTIONS

Line 111: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,

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
115: x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895

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

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

Line 120: x_derive_margin_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%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
124: x_plan_type_processing_code OUT NOCOPY pa_proj_fp_options.plan_processing_code%TYPE, --File.Sql.39 bug 4440895

Line 121: x_report_labor_hrs_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_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
124: x_plan_type_processing_code OUT NOCOPY pa_proj_fp_options.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 124: x_plan_type_processing_code OUT NOCOPY pa_proj_fp_options.plan_processing_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
124: x_plan_type_processing_code OUT NOCOPY pa_proj_fp_options.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
125: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
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:

Line 132: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

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;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 133: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

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;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;
137: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;

Line 134: l_derive_margin_from_code pa_proj_fp_options.margin_derived_from_code%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;
136: l_currency_code pa_projects_all.projfunc_currency_code%TYPE;
137: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
138:

Line 176: pa_proj_fp_options

172: l_derive_margin_from_code,
173: l_report_labor_hrs_from_code,
174: x_ar_flag
175: from
176: pa_proj_fp_options
177: where
178: proj_fp_options_id=p_fin_plan_options_id;
179: if (l_fin_plan_pref_code is null) then
180: l_msg_count := l_msg_count + 1;