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_FP_ORG_FCST_GEN_PUB dependencies on PA_PROJECTS

Line 219: l_project_id pa_projects_all.project_id%TYPE;

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

Line 220: l_project_name pa_projects_all.name%TYPE;

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

Line 221: l_project_number pa_projects_all.segment1%TYPE;

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

Line 222: l_new_project_number pa_projects_all.segment1%TYPE;

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

Line 223: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

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

Line 1712: pa_projects pa

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

Line 4278: l_source_project_id pa_projects.project_id%TYPE;

4274: l_ra_map_tmp_tbl12 ra_map_tmp_tbl12_type;
4275: -- Declared for bug 3615617
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;

Line 4279: l_target_project_id pa_projects.project_id%TYPE;

4275: -- Declared for bug 3615617
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

Line 4668: FROM pa_projects p

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

Line 4961: l_target_project_id pa_projects.project_id%TYPE;

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