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_PVT dependencies on PA_PROJ_FP_OPTIONS

Line 294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
298: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used

Line 317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;

313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;
317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;
318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
319: l_auto_baseline_project pa_projects_all.baseline_funding_flag%TYPE;
320:
321: l_fc_plan_type_ids_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();

Line 318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;
317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;
318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
319: l_auto_baseline_project pa_projects_all.baseline_funding_flag%TYPE;
320:
321: l_fc_plan_type_ids_tbl SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type();
322: l_fc_pt_pref_code_tbl SYSTEM.pa_varchar2_30_tbl_type DEFAULT SYSTEM.pa_varchar2_30_tbl_type();

Line 460: pa_proj_fp_options opt,

456: l_auto_baseline_project
457: from pa_project_types_all pt,
458: pa_projects_all pr,
459: pa_budget_versions bv,
460: pa_proj_fp_options opt,
461: pa_fin_plan_types_b pavl
462: where bv.budget_version_id = p_budget_version_id and
463: opt.fin_plan_version_id = bv.budget_version_id and
464: bv.project_id = pr.project_id and

Line 1044: From Pa_proj_fp_options

1040:
1041: Select fin_plan_type_id,fin_plan_preference_code,primary_cost_forecast_flag, primary_rev_forecast_flag
1042: Bulk Collect
1043: Into l_fc_plan_type_ids_tbl,l_fc_pt_pref_code_tbl,l_primary_cost_fcst_flag_tbl,l_primary_rev_fcst_flag_tbl
1044: From Pa_proj_fp_options
1045: Where Project_Id = p_project_id
1046: And Fin_Plan_Option_Level_Code = 'PLAN_TYPE'
1047: And (primary_cost_forecast_flag = 'Y' or
1048: primary_rev_forecast_flag = 'Y');

Line 1362: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

1358: l_ar_flag VARCHAR2(1);
1359: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
1360: l_fin_plan_level_code VARCHAR2(30);
1361: l_fin_plan_type_code VARCHAR2(30);
1362: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1363: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
1364: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
1365: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
1366: l_warnings_only_flag VARCHAR2(1);

Line 1476: pa_proj_fp_options opt,

1472: from pa_project_types_all pt,
1473: pa_projects_all pr,
1474: pa_budget_versions bv,
1475: -- pa_budget_entry_methods be,
1476: pa_proj_fp_options opt,
1477: pa_fin_plan_types_b pavl
1478: where bv.budget_version_id = p_budget_version_id and
1479: opt.fin_plan_version_id = bv.budget_version_id and
1480: bv.project_id = pr.project_id and

Line 1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1809: l_approved_budget_plan_type varchar2(1) := 'N';
1810: l_project_id pa_projects_all.project_id%TYPE;
1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1812: l_version_type pa_budget_versions.version_type%TYPE;
1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
1815: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab;
1816: l_return_status VARCHAR2(2000);
1817: l_msg_count NUMBER;

Line 1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;

1810: l_project_id pa_projects_all.project_id%TYPE;
1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1812: l_version_type pa_budget_versions.version_type%TYPE;
1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
1815: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab;
1816: l_return_status VARCHAR2(2000);
1817: l_msg_count NUMBER;
1818: l_msg_data VARCHAR2(2000);

Line 2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

2081: ,p_version_type IN pa_budget_versions.version_type%TYPE
2082: -- Bug Fix: 4569365. Removed MRC code.
2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
2084: ,p_calling_context IN VARCHAR2
2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE

Line 2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
2084: ,p_calling_context IN VARCHAR2
2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE
2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE

2084: ,p_calling_context IN VARCHAR2
2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE
2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
2092: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE

Line 2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

Line 2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

Line 2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

Line 2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

Line 2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE

2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

Line 2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE

2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

Line 2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE

2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

Line 2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE

2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

Line 2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE

2118: ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

Line 2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE

2119: ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

Line 2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE

2120: ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab

Line 2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE

2121: ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.

Line 2168: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2164: AND pelm.parent_structure_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( p_project_id);
2165:
2166: impacted_task_rec impacted_task_cur%ROWTYPE;
2167:
2168: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2169: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
2170: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
2171: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2172:

Line 2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

2174: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2175: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

Line 2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2189: l_record_version_number pa_budget_versions.record_version_number%TYPE; /* Bug 2688610 */
2190:
2191: l_mixed_resource_planned_flag VARCHAR2(1);-- Added for Bug:-2625872
2192:
2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;

Line 2594: update pa_proj_fp_options

2590: /*
2591: Bug 2670747 - The MC attributes need to be updated only if MC flag is Y
2592: */
2593: IF (p_plan_in_mc_flag = 'Y') THEN
2594: update pa_proj_fp_options
2595: set projfunc_cost_rate_type = p_projfunc_cost_rate_type
2596: ,projfunc_cost_rate_date_type = p_projfunc_cost_rate_date_type
2597: ,projfunc_cost_rate_date = p_projfunc_cost_rate_date
2598: ,projfunc_rev_rate_type = p_projfunc_rev_rate_type

Line 3934: 1) pa_proj_fp_options

3930: Purpose: This api Deletes the proj fp options data pertaining
3931: to the workplan type attached to the project for
3932: the passed project id.
3933: Deletes data from the following tables -
3934: 1) pa_proj_fp_options
3935: 2) pa_fp_txn_currencies
3936: 3) pa_proj_period_profiles
3937: 4) pa_fp_upgrade_audit
3938:

Line 3962: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

3958: l_return_status VARCHAR2(2000);
3959: l_debug_mode VARCHAR2(30);
3960: --End of variables used for debugging
3961:
3962: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3963: l_sv_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3964: l_sv_id_count NUMBER;
3965:
3966: cursor c_struct_ver(c_project_id pa_projects_all.project_id%TYPE) IS

Line 4018: FROM pa_proj_fp_options pfo

4014: END IF;
4015:
4016: SELECT pfo.proj_fp_options_id
4017: INTO l_proj_fp_options_id
4018: FROM pa_proj_fp_options pfo
4019: ,pa_fin_plan_types_b pft
4020: WHERE pfo.project_id = p_project_id
4021: AND pfo.fin_plan_type_id = pft.fin_plan_type_id
4022: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

Line 4084: -- delete from pa_proj_fp_options table

4080: pa_debug.g_err_stage:='Deleting data from respective tables';
4081: pa_debug.write('Delete_wp_option: ' || g_module_name,pa_debug.g_err_stage,3);
4082: END IF;
4083:
4084: -- delete from pa_proj_fp_options table
4085: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4086:
4087: -- delete from pa_fp_txn_currencies
4088: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;

Line 4085: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;

4081: pa_debug.write('Delete_wp_option: ' || g_module_name,pa_debug.g_err_stage,3);
4082: END IF;
4083:
4084: -- delete from pa_proj_fp_options table
4085: DELETE FROM pa_proj_fp_options WHERE proj_fp_options_id = l_proj_fp_options_id;
4086:
4087: -- delete from pa_fp_txn_currencies
4088: DELETE FROM pa_fp_txn_currencies WHERE proj_fp_options_id = l_proj_fp_options_id;
4089:

Line 4390: l_ver_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

4386: l_total_revenue_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4387: l_number_null_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); --bug 3825873
4388:
4389: -- bug 4221650: added the following
4390: l_ver_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
4391:
4392: CURSOR get_proj_id_csr IS
4393: SELECT project_id FROM pa_budget_versions
4394: WHERE budget_version_id = p_fin_plan_version_id ;