APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 189: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

185: l_ppp_end_date date;
186:
187: l_project_action_allowed varchar2(1);
188:
189: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
190: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
191: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
192: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
193: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

Line 190: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;

186:
187: l_project_action_allowed varchar2(1);
188:
189: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
190: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
191: l_fin_plan_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
192: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
193: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
194: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

Line 1302: pa_proj_fp_options_pkg.Insert_Row

1298: END IF;
1299:
1300: -- Create Proj Fin Plan Options at Project Level
1301: l_proj_fp_options_id := NULL;
1302: pa_proj_fp_options_pkg.Insert_Row
1303: ( px_proj_fp_options_id => l_proj_fp_options_id
1304: ,p_project_id => l_project_id
1305: ,p_fin_plan_option_level_code => 'PROJECT'
1306: ,p_fin_plan_type_id => NULL

Line 1362: pa_proj_fp_options_pkg.Insert_Row

1358: END IF;
1359:
1360: -- Create Proj Fin Plan Options at Plan Type Level
1361: l_proj_fp_options_id := NULL;
1362: pa_proj_fp_options_pkg.Insert_Row
1363: ( px_proj_fp_options_id => l_proj_fp_options_id
1364: ,p_project_id => l_project_id
1365: ,p_fin_plan_option_level_code => 'PLAN_TYPE'
1366: ,p_fin_plan_type_id => l_fin_plan_type_id

Line 1640: pa_proj_fp_options_pkg.Insert_Row

1636: END IF;
1637:
1638: -- Create Proj Fin Plan Options at Plan Version Level
1639: l_proj_fp_options_id := NULL;
1640: pa_proj_fp_options_pkg.Insert_Row
1641: ( px_proj_fp_options_id => l_proj_fp_options_id
1642: ,p_project_id => l_project_id
1643: ,p_fin_plan_option_level_code => 'PLAN_VERSION'
1644: ,p_fin_plan_type_id => l_fin_plan_type_id

Line 4280: l_source_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE ;

4276: l_ra_map_tmp_tbl13 ra_map_tmp_tbl13_type;
4277:
4278: l_source_project_id pa_projects.project_id%TYPE;
4279: l_target_project_id pa_projects.project_id%TYPE;
4280: l_source_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE ;
4281: l_target_struct_version_id pa_proj_element_versions.element_version_id%TYPE;
4282: l_source_struct_version_id pa_proj_element_versions.element_version_id%TYPE;
4283: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- bug 3841942
4284:

Line 4283: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- bug 3841942

4279: l_target_project_id pa_projects.project_id%TYPE;
4280: l_source_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE ;
4281: l_target_struct_version_id pa_proj_element_versions.element_version_id%TYPE;
4282: l_source_struct_version_id pa_proj_element_versions.element_version_id%TYPE;
4283: l_target_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE; -- bug 3841942
4284:
4285:
4286: -- cursor same_projects_cur is going to be used when the source and target projects are same
4287:

Line 5030: FROM pa_proj_fp_options

5026: ,project_id
5027: INTO l_cost_flag
5028: ,l_revenue_flag
5029: ,l_target_project_id
5030: FROM pa_proj_fp_options
5031: WHERE fin_plan_version_id=p_target_plan_version_id;
5032: /*
5033: IF P_PA_DEBUG_MODE = 'Y' THEN
5034: pa_debug.g_err_stage:='l_cost_flag ='||l_cost_flag;

Line 5755: FROM pa_proj_fp_options

5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5753: INTO l_revenue_flag
5754: ,l_cost_flag
5755: FROM pa_proj_fp_options
5756: WHERE fin_plan_version_id=p_target_plan_version_id;
5757: /*
5758: pa_debug.g_err_stage:='l_revenue_flag ='||l_revenue_flag;
5759: IF P_PA_DEBUG_MODE = 'Y' THEN