DBA Data[Home] [Help]

APPS.PA_BUDGET_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895

153: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
154: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
155: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
156: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895

154: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
155: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
156: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

Line 159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895

155: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
156: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

156: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

157: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895

158: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895

159: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

160: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

Line 165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895

161: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

Line 166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895

162: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

Line 167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

163: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

Line 168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895

164: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895

165: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895

166: ,px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: ,px_revenue_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895

167: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
168: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
169: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
170: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
171: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
172: ,px_raw_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173: ,px_burdened_cost_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: ,px_revenue_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: ,px_cost_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 245: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

241: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
242: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
243: ,p_version_type IN pa_budget_versions.version_type%TYPE
244: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
245: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
246: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
247: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
248: ,p_allow_qty_flag IN VARCHAR2
249: ,p_allow_raw_cost_flag IN VARCHAR2

Line 247: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

243: ,p_version_type IN pa_budget_versions.version_type%TYPE
244: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
245: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
246: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
247: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
248: ,p_allow_qty_flag IN VARCHAR2
249: ,p_allow_raw_cost_flag IN VARCHAR2
250: ,p_allow_burdened_cost_flag IN VARCHAR2
251: ,p_allow_revenue_flag IN VARCHAR2

Line 252: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

248: ,p_allow_qty_flag IN VARCHAR2
249: ,p_allow_raw_cost_flag IN VARCHAR2
250: ,p_allow_burdened_cost_flag IN VARCHAR2
251: ,p_allow_revenue_flag IN VARCHAR2
252: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE

Line 253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

249: ,p_allow_raw_cost_flag IN VARCHAR2
250: ,p_allow_burdened_cost_flag IN VARCHAR2
251: ,p_allow_revenue_flag IN VARCHAR2
252: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

250: ,p_allow_burdened_cost_flag IN VARCHAR2
251: ,p_allow_revenue_flag IN VARCHAR2
252: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

251: ,p_allow_revenue_flag IN VARCHAR2
252: ,p_multi_currency_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

253: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

254: ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

255: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
256: ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE
257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

257: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

258: ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

259: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
260: ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE
261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
267: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

261: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
267: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
268: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
269:

Line 266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

262: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
267: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
268: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
269:
270: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added*/

Line 267: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

263: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
264: ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
265: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
266: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
267: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
268: ,p_projfunc_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE
269:
270: /* Bug 3986129: FP.M Web ADI Dev changes: New parameters added*/
271: ,p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols DEFAULT NULL

Line 340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

336: Earlier this procedure was a local procedure to this package only. But now it has
337: has been made public as we need to use it directly from pa_budget_pub
338: =================================================================================*/
339: PROCEDURE VALID_RATE_TYPE
340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

337: has been made public as we need to use it directly from pa_budget_pub
338: =================================================================================*/
339: PROCEDURE VALID_RATE_TYPE
340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

338: =================================================================================*/
339: PROCEDURE VALID_RATE_TYPE
340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

339: PROCEDURE VALID_RATE_TYPE
340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

340: ( p_pt_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
348: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN

Line 345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

341: ,p_pt_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
348: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN
349: ,x_return_status OUT NOCOPY VARCHAR2

Line 346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

342: ,p_pt_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
348: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN
349: ,x_return_status OUT NOCOPY VARCHAR2
350: ,x_msg_count OUT NOCOPY NUMBER

Line 347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

343: ,p_pt_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
344: ,p_pv_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
345: ,p_pv_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
346: ,p_pv_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
347: ,p_pv_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
348: ,x_is_rate_type_valid OUT NOCOPY BOOLEAN
349: ,x_return_status OUT NOCOPY VARCHAR2
350: ,x_msg_count OUT NOCOPY NUMBER
351: ,x_msg_data OUT NOCOPY VARCHAR2