DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_PROJECTS

Line 220: l_project_id pa_projects_all.project_id%TYPE;

216: l_org_location_id hr_organization_units.location_id%TYPE;
217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 221: l_project_name pa_projects_all.name%TYPE;

217: l_pfi_organization_id hr_organization_units.organization_id%TYPE;
218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
225: l_own_task_id pa_tasks.task_id%TYPE;

Line 222: l_project_number pa_projects_all.segment1%TYPE;

218: l_pfi_project_organization_id hr_organization_units.organization_id%TYPE;
219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
225: l_own_task_id pa_tasks.task_id%TYPE;
226: l_prob_percent pa_probability_members.probability_percentage%TYPE;

Line 223: l_new_project_number pa_projects_all.segment1%TYPE;

219: l_pfi_exp_organization_id hr_organization_units.organization_id%TYPE;
220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
225: l_own_task_id pa_tasks.task_id%TYPE;
226: l_prob_percent pa_probability_members.probability_percentage%TYPE;
227: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;

Line 224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

220: l_project_id pa_projects_all.project_id%TYPE;
221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
225: l_own_task_id pa_tasks.task_id%TYPE;
226: l_prob_percent pa_probability_members.probability_percentage%TYPE;
227: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
228: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;

Line 1713: pa_projects pa

1709: l_period_profile_id,
1710: l_organization_id,
1711: l_org_projfunc_currency_code
1712: FROM pa_budget_versions bv,
1713: pa_projects pa
1714: WHERE bv.budget_version_id = p_budget_version_id
1715: AND pa.project_id = bv.project_id;
1716:
1717: l_stage := 3900;

Line 4279: l_source_project_id pa_projects.project_id%TYPE;

4275: l_ra_map_tmp_tbl12 ra_map_tmp_tbl12_type;
4276: -- Declared for bug 3615617
4277: l_ra_map_tmp_tbl13 ra_map_tmp_tbl13_type;
4278:
4279: l_source_project_id pa_projects.project_id%TYPE;
4280: l_target_project_id pa_projects.project_id%TYPE;
4281: l_source_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE ;
4282: l_target_struct_version_id pa_proj_element_versions.element_version_id%TYPE;
4283: l_source_struct_version_id pa_proj_element_versions.element_version_id%TYPE;

Line 4280: l_target_project_id pa_projects.project_id%TYPE;

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

Line 4669: FROM pa_projects p

4665: END IF;
4666:
4667: SELECT p.start_date
4668: INTO l_start_date
4669: FROM pa_projects p
4670: WHERE p.project_id = l_source_project_id;
4671:
4672: IF l_start_date IS NULL THEN
4673:

Line 4962: l_target_project_id pa_projects.project_id%TYPE;

4958: l_return_status VARCHAR2(2000);
4959: l_debug_mode VARCHAR2(30);
4960:
4961: l_adj_percentage NUMBER ;
4962: l_target_project_id pa_projects.project_id%TYPE;
4963: l_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
4964: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
4965:
4966: l_tmp NUMBER;