APPS.PA_FIN_PLAN_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

162: ,p_version_type IN pa_budget_versions.version_type%TYPE
163: -- Bug Fix: 4569365. Removed MRC code.
164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
165: ,p_calling_context IN VARCHAR2
166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE

Line 168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
165: ,p_calling_context IN VARCHAR2
166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE
172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

165: ,p_calling_context IN VARCHAR2
166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE
172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
173: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE

Line 195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

199: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

Line 204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

200: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

Line 205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

201: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab

Line 206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

202: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900

Line 260: 1) pa_proj_fp_options

256: Purpose: This api Deletes the proj fp options data pertaining
257: to the workplan type attached to the project for
258: the passed project id.
259: Deletes data from the following tables -
260: 1) pa_proj_fp_options
261: 2) pa_fp_txn_currencies
262: 3) pa_proj_period_profiles
263: 4) pa_fp_upgrade_audit
264: